Jeewan Chaudhary

• Over 5 years of progressive experience in architecting and developing end-to-end database and ETL solutions across OLTP and OLAP systems, using Microsoft SQL Server 2022 through 2016, supporting complex business domains including finance, pharmaceuticals, and manufacturing. • Designed and implemented enterprise-grade SSIS/DTS-based ETL frameworks for high-volume data transfers between heterogeneous systems; responsible for the full lifecycle of package development, deployment, scheduling, monitoring, and troubleshooting. • Automated SSRS reporting workflows to align with real-time transaction processing, significantly reducing manual intervention and improving report delivery efficiency. • Expert in designing and optimizing database objects including indexes, views, triggers, common table expressions (CTEs), table-valued functions, and parameterized stored procedures for performance tuned data operations. • Well-versed in all phases of the Software Development Life Cycle (SDLC), including architecture design, system analysis, development, testing, deployment, and production support in both Agile and Waterfall environments. • Developed modular SSIS solutions leveraging master-child package design patterns, centralized configurations, and logging frameworks to enhance reusability and maintainability. • Integrated flat files, Excel files, and OLEDB sources/targets for seamless ETL operations across staging, data marts, and enterprise data warehouses. • Designed and implemented dimensional data models (Star and Snowflake schemas), including fact and dimension tables, aligned with best practices in enterprise data warehousing and BI. • Hands-on experience in logical and physical data modeling, including normalization, surrogate key management, and dimensional design using tools such as Microsoft Access and Microsoft Visio. • Implemented enterprise Business Intelligence solutions using Microsoft BI stack—SSIS for ETL, SSRS for reporting, and SSAS for cube development and analytical modeling. • Practical working knowledge of Oracle databases (10g/11g) and development using PL/SQL, stored procedures, packages, and dynamic SQL for cross-platform integrations. • Supported and enhanced SQL Server Reporting Services (SSRS) environments by resolving performance bottlenecks, refining report queries, and developing complex visualizations for operational and executive reporting. • Experience integrating and supporting data pipelines involving BCP, DTS, and linked server configurations between SQL Server, Oracle, and Sybase environments. • Proficient in SQL Server performance diagnostics using tools such as SQL Profiler, Index Tuning Advisor, and Windows Performance Monitor to monitor, trace, and fine-tune system performance. • Built and managed ETL processes using SSIS to extract, transform, and load data from a wide range of sources including Oracle, DB2, flat files, Excel, CSV, and Access into centralized SQL Server-based data warehouses.