Deepshikha Singh Email & Phone Number

Fort Collins, Colorado, United States

Florida, United States

Design and Development ETL/ELT Azure data pipelines using Azure Data Factory, Synapse Analytics, Pyspark notebooks and SQL Database objects for the implementation of data lake house. Applied expertise for creating data pipelines to extract, transform and Load student and Healthcare data to data lake house for analysis by the end users.• Demonstrated proficiency in creating Azure Synapse data pipelines and integrated end points between different source such as Oracle HCM, SQL DB, REST APIs… Show more Design and Development ETL/ELT Azure data pipelines using Azure Data Factory, Synapse Analytics, Pyspark notebooks and SQL Database objects for the implementation of data lake house. Applied expertise for creating data pipelines to extract, transform and Load student and Healthcare data to data lake house for analysis by the end users.• Demonstrated proficiency in creating Azure Synapse data pipelines and integrated end points between different source such as Oracle HCM, SQL DB, REST APIs and loaded into destinations - Azure Data Lake storage – ADLS Gen2, SQL Pools and SQL server.• Effective implementation of data acquisition, transformation, validation, and curation utilizing skills of writing complex queries with SQL, PySpark, and SQL notebooks for creating data lake house and delta tables.• Successfully developed SQL Server database objects including Tables, Functions, Stored Procedure, Views, Indexes, constraints, Triggers, CTEs etc. with T-SQL and SQL pool / serverless SQL pool objects such as external tables, views.• Proficiently worked with complex data sets such as JSON format, nested structures, and with big volumes of data.• Creating and managing data mapping, transformation routines and ensuring data integrity, accuracy, and consistency.• Monitoring integrated systems for performance optimization, tuning ETL data pipelines and implementing data security protocols.• Creating and modifying Visualization reports for end users using SSRS and Power BI.• Creating documentation and provide training and support to end-users, administrators, and support teams.• Collaborated with cross-functional and business teams to understand data integration requirements and business processes.• Utilized Azure Data Studio, Azure DevOps, Git, SQL Server Management Studio (SSMS), Continuous Integration and deployment automation with CI/CD pipelines. Show less

Bengaluru, Karnataka, India

• Demonstrated prowess in the design, architecture, and development of robust and scalable and optimized ETL pipelines for large amount of data using Azure Data Factory – ADF, Azure Synapse, Databricks, Azure SQL database, Azure Data Lake storage – ADLS Gen2.• Applied Expertise in database development and testing; creation of stored procedures, functions, views, indexes, complex SQL Queries and performance optimization utilizing skills in SQL, T-SQL, SQL Server, Azure SQL.• Executed… Show more • Demonstrated prowess in the design, architecture, and development of robust and scalable and optimized ETL pipelines for large amount of data using Azure Data Factory – ADF, Azure Synapse, Databricks, Azure SQL database, Azure Data Lake storage – ADLS Gen2.• Applied Expertise in database development and testing; creation of stored procedures, functions, views, indexes, complex SQL Queries and performance optimization utilizing skills in SQL, T-SQL, SQL Server, Azure SQL.• Executed large-scale data processing, implemented ETL, created Delta Lake, Delta tables with PySpark, Spark SQL, Python – Pandas, NumPy etc.• Well Versed with batch and real – time data streaming, Azure Stream Analytics, Event Hub, Azure Logic Apps, Azure Cosmos DB NoSQL, Snowflake and Azure key vault and Azure Cloud SaaS solutions. • Exposure to Microsoft Purview - metadata management, Data Governance, Lineage, Data Quality and data security implementations.• Efficiently completed job scheduling, monitoring, maintenance, and performance tuning on SQL Server.• Proficiently various data sources and formats including databases, REST APIs; Parquet, text, Flat files, CSV, JSON, Excel - Formats.• Utilized Agile development methodology, Test driven development (TDD), Azure DevOps, Git, CI/CD pipelines.• Proficiently worked with data analysis, data modelling, data mart, and data warehouse implementation, using Azure Synapse, Azure Analysis Service, Power BI. Snowflake • Provided guidance, mentoring and feedback to a team of 4 team members, ensuring successful delivery of the project. • Collaborated with Business Analysts, Developers and Project Stakeholders across the product lifecycle; executed unit testing, integration testing, data validation, created test strategies, test plans and test cases, alongside QAs.• Actively participated in requirement gathering, Sprint planning, release management, change control and management, Backlog management, and conducted Retrospective and Scrum meetings Show less

Noida India

• Applied expertise in designing and developing database objects, including stored procedures, tables, constraints, indexes, views etc. using SQL Server database for OLAP environment, Windows Server, SQL Server Management Studio – SSMS.• Proficiently Designed, developed, and tested Data Flows and ETL using SQL server Integration services – SSIS packages, and efficiently implemented ad-hoc SQL Server Reporting services SSRS reports as well as Tableau report changes. • Actively… Show more • Applied expertise in designing and developing database objects, including stored procedures, tables, constraints, indexes, views etc. using SQL Server database for OLAP environment, Windows Server, SQL Server Management Studio – SSMS.• Proficiently Designed, developed, and tested Data Flows and ETL using SQL server Integration services – SSIS packages, and efficiently implemented ad-hoc SQL Server Reporting services SSRS reports as well as Tableau report changes. • Actively participated in data analysis, data profiling, and data validation alongside Business Analysts to understand client requirements, create data models, enhance data warehouses, handling meta data, developed source to target mappings. • Implemented innovative solutions to enhance performance for ETL and Reporting, completed POCs or the client for different requirements.• Automated QA test cases to save 80% of QA testing time. Actively participated in performance tuning of SQL queries and database performance optimization.• Managed the deployment, scheduling, and monitoring of SQL Server objects, SSIS packages, version control using TFS (Team Foundation Server), GitHub, SQL Server Agent.• Mentored, guided, and led a team of 3 members, planned work, scheduled, assigned, and reviewed work items for them.• Resolved defects in databases, SQL Queries, and ETL solutions, including making necessary changes to .NET C# code. • Collaboratively partnered with Quality Assurance (QA) teams to plan and develop test cases, decide test strategies, address issues and bugs. • Experience with waterfall and Agile methodologies throughout the complete Software Development Life Cycle (SDLC). Environment: Microsoft Business Intelligence (MSBI), MS SQL Server, T-SQL, OLAP, (SSMS), Data Flows, ETL, SQL, SSIS, SSRS, SSAS, Tableau, data analysis, data profiling, data validation, data models, data warehouses, QA test cases, SQL queries, database optimization, TFS, GitHub, SQL Server Agent, JIRA, , .NET C# Show less

Gurgaon

• Proficient in database development, data analysis, and ETL operations, with expertise in SSIS, SQL Server for the implementation of a data warehousing system. • Conducted data validation, data profiling, testing and analysis of financial and non-financial data of customers and effectively resolved data issues and bugs, ensuring data accuracy and integrity. • Performed reconciliation of financial data across various data sources utilizing MS Access, Windows Server and SQL server DB… Show more • Proficient in database development, data analysis, and ETL operations, with expertise in SSIS, SQL Server for the implementation of a data warehousing system. • Conducted data validation, data profiling, testing and analysis of financial and non-financial data of customers and effectively resolved data issues and bugs, ensuring data accuracy and integrity. • Performed reconciliation of financial data across various data sources utilizing MS Access, Windows Server and SQL server DB. Automated the process with SQL Server and saved 64% of processing time.• Effectively implement SSIS packages and SSRS report changes for various client requirements.• Collaborated closely with Business Analysts to create detailed source-to-target mappings, facilitating data integration and transformation processes for P&C insurance Customer company. Environment: SSIS, SQL Server, data warehousing, data validation, MS Access, Windows Server, SQL Server DB, automation, SSRS, Business Analysts, source-to-target mappings, data integration, data transformation.Environment: SSIS, SQL Server, data warehousing, data validation, MS Access, Windows Server, SQL Server DB, automation, SSRS, Business Analysts, source-to-target mappings, data integration, data transformation. Show less

Noida

• Proficiently created and modified Oracle and SQL database objects and supported a Java based messaging application to support real time messaging requirement for the client company including their pickup, drop and interactive messaging services, was responsible for 100% efficient operation of the application and database at the client location.• Modification of Oracle and SQL database objects for the backend of a messaging application. • Java, JavaScript & HTML code modification for… Show more • Proficiently created and modified Oracle and SQL database objects and supported a Java based messaging application to support real time messaging requirement for the client company including their pickup, drop and interactive messaging services, was responsible for 100% efficient operation of the application and database at the client location.• Modification of Oracle and SQL database objects for the backend of a messaging application. • Java, JavaScript & HTML code modification for the application, as per the client’s requirements. • Writing SQL scripts, DDL, DML, Queries, functions for various database requirements. • Supporting the client with database backup, recovery, application monitoring and bug fixing. • Prepare and provide daily reports for the application success-rate to the client. Environment: Oracle, SQL databases, DDL, DML, core Java, JavaScript, HTML, database backup, recovery, monitoring, Bug Fixing. Show less