Ravi Tejpal Email & Phone Number

Noida, Uttar Pradesh, India

Noida, Uttar Pradesh, India

Azure Data factory , PowerBI, Azure Devops

India

Responsible for implementing US healthcare clients into MedInsight data warehouse solution.Extensive experience in SQL Server Database design, Database maintenance, end to end data modeling using SSIS, Sql ,SSRS. Developing T-SQL queries, stored procedures, and Triggers and views. Responsible for verifying accuracy of data, implementing and supporting the data warehouse. Strong Analytics and domain knowledge. Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Keys & Constraints, and Normalization techniques on database Tables. Expert in creating Sub-Queries and Joins for complex queries involving multiple tables. Create, maintain and monitor ETL routines according to the DWH design and architecture. Developed, deployed and monitored SSIS 2008R2, 2012,2014 Packages. Scheduling the Reports Weekly and Monthly basis as per the Client Requirements. Used Control Flow Tasks like For Each Loop Container, Sequence container, Execute SQL Task and Data Flow Task in Designing packages.Experience in Data Flow Transformations like Derived Column, Conditional Split, Data Conversion, Union All, Merge Join, and Lookup and so on. Sql Server Query Optimization using execution plan, parameter sniffing, recompilation. Knowledge on statistics and filtered statistics. Resolving issues in query execution plan and to optimize the queries, procedures.Design SSIS packages to load the data, deploy them on server . Optimizing the SSIS package run time .

India

1. Sql Developer, Analytics ,SSIS, SSRS, SSAS, Tabular and Multidimensional Models Team Management , Client Management, Implementing Data warehouse Solutions for US HealthCare Clients (MSSP, Commercial, Medicare).2. Designing of optimal SSIS packages . Well versed with SSIS control flow and data flow transformations.3. Designed parameterized SSIS packages and well versed with deployment models.4. Testing of SSIS packages before moving them to production.5. Well versed with transactions in SSIS and their implementation.6. Loaded staging tables through SSIS and implemented early arriving facts/late arriving dimensions.7. Troubleshoot ETL failures and performance tuning the SSIS data flow task.