Shalini Singh

• Effectively enhanced an established data warehouse system by transitioning from SSIS packages to Pentaho ETL, increasing efficiency and significantly enhancing the system's maintainability. • Designed and implemented end-to-end ETL transformations for logistics, sales, and purchasing data from multiple source systems to presentation layer. • Developed stored procedures and SQL scripts for data cleansing, transformation, and enrichment. • Developed PowerBI dashboards for visualizing Datamart performance

Experienced in providing client specific solutions for design changes and enhancements. Experise in Planning, Analyzing and Developing/Fixing production issues for different releases.Experienced in Designing, development and maintenance of various types of SSRS Reports, including report deployments server implementation. Experienced in Creating, analyzing and modifying stored procedures, views, functions and triggers, according to user requirement in SQL server and handling small & large databases.

• Understand and analyze the clients’ business requirements for system migration. • Tested the system after data migration. • Implemented error handling in SSIS packages along with logging and configuration. • Extracted data from SQL Server, Flat files, CSV files and loaded into Data warehouse. • Downloaded big flat files from FTP and after loading them to our destination tables compressed them and archive them to a folder.