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.
• 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.
• 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.
• 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.
• Proficiently worked with complex data sets such as JSON format, nested structures, and with big volumes of data.

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.
• 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
• 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.

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.
• 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.
• Actively… Show more
• 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.
• 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.

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
• 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.

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.
• Modification of Oracle and SQL database objects for the backend of a messaging application.
• Java, JavaScript & HTML code modification for… Show more
• 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.