Shalini Singh Email and Phone Number

• Designed and implemented end-to-end data solutions on Azure, including data ingestion, transformation, and storage using Azure Data Lake Storage and Azure SQL Data Warehouse.• Developed and maintained complex data pipelines in Azure Data Factory, ensuring efficient and reliable data movement.• Utilized Apache Spark and Databricks to perform data processing, transformation, and analysis on large datasets, improving data quality and providing actionable insights.• Created and… Show more • Designed and implemented end-to-end data solutions on Azure, including data ingestion, transformation, and storage using Azure Data Lake Storage and Azure SQL Data Warehouse.• Developed and maintained complex data pipelines in Azure Data Factory, ensuring efficient and reliable data movement.• Utilized Apache Spark and Databricks to perform data processing, transformation, and analysis on large datasets, improving data quality and providing actionable insights.• Created and scheduled data pipelines and ETL processes, optimizing performance and reducing data latency.• Implemented security measures, including data encryption and role-based access control, to ensure data integrity and compliance.• Produced interactive and visually appealing dashboards and reports using Power BI to communicate data-driven insights to stakeholders. Show less

• Effectively enhanced an established data warehouse system by transitioning from SSIS packages to Pentaho ETL, resulting in a remarkable 30% increase in 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 the presentation layer.• Developed stored procedures and SQL scripts for data cleansing, transformation, and enrichment.• Implemented… Show more • Effectively enhanced an established data warehouse system by transitioning from SSIS packages to Pentaho ETL, resulting in a remarkable 30% increase in 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 the presentation layer.• Developed stored procedures and SQL scripts for data cleansing, transformation, and enrichment.• Implemented modularization in the ETL process by creating templates for generating transformations for SAP tables in the SAP S/4HANA ERP system.• Developed PowerBI dashboards for visualizing Datamart performance• Effectively managed sprint planning, ticket grooming, sprint retrospectives, and sprint review sessions to ensure project alignment with organizational goals. Show less

• Over seven years of extensive IT expertise covering the full spectrum of SQL Server, ranging from design and modelling to development, implementation, and support.• Efficiently perform ETL processes, transferring client business and financial data into the database using SQL Server Integration Services (SSIS).• Ensure seamless data integration with my SSIS error handling expertise, where I employ advanced tools like precedence constraints, breakpoints, checkpoints, and logging for a… Show more • Over seven years of extensive IT expertise covering the full spectrum of SQL Server, ranging from design and modelling to development, implementation, and support.• Efficiently perform ETL processes, transferring client business and financial data into the database using SQL Server Integration Services (SSIS).• Ensure seamless data integration with my SSIS error handling expertise, where I employ advanced tools like precedence constraints, breakpoints, checkpoints, and logging for a reliable process.• Steer SSIS Control Flow and Data Flow components seamlessly for the most efficient execution of intricate data workflows.• Transfer data across servers utilizing Bulk Copy Program (BCP) and SSIS, deploying reports across diverse environments, and scripting SQL operations to streamline processes.• Developing reports using Crystal Reports and SSRS.• Generate analytical reports that incorporate historical data analysis and predictive analytics capabilities by leveraging SQL Server Reporting Services (SSRS) and Multidimensional Expressions (MDX).• Proficiently utilize Common Table Expressions (CTEs), temporary tables, and practical triggers to optimize data manipulation processes, ensuring seamless support for existing applications.• Craft dynamic queries, sub-queries, and complex joins to build custom database elements that perfectly suit clients’ varied requirements. Show less

• 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 archived them in a folder.