Bhanvi . Email & Phone Number

Noida, Uttar Pradesh, India

Chandigarh, India

Gurugram, Haryana, India

Proficiently designed and managed ETL (Extract, Transform, Load) processes using Microsoft SQL Server Integration Services (SSIS).  Downstream Application Monitoring and Conflict Resolution: Works closely in data integration and preserving seamless operations.  Created Master Pipelines in ADF to have logical grouping of child pipelines in order to cater different data load scenarios like missing source files, etc.  Optimizations- Conducted data collection, cleaning, and preprocessing to ensure data accuracy and consistency.

Gurugram, Haryana, India

ITD Reconciliation Automation & Performance Tuning: Support data transformation, integration, and reconciliation by automating the process using SQL.  Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI.  Designed and developed SSIS Package to import and export data from MS Excel, SQL Server 2012 and Flat files.  Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.  Experience of optimizing queries by analyzing the query execution plan to identify performance bottlenecks and improve the performance for better tuning of the database.  Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services.  Scheduled and collaborated on over 10 SQL Server Agent Jobs, translating requirements into technical specifications.  Snow SQL Queries Automation and Actuarial Workstations: Analyzed Cloverleaf Analytics (CLA) warehouse data to create Snow SQL-based solutions for actuarial processes.  Created ready-to-run Snow SQL views, including Actuarial Workstation, Claims Triangle, Premium Triangles, for nontechnical users.  Engaged in peer code reviews to maintain coding standards and best practices.  Utilized dimensional modeling techniques to design efficient data models for reporting and analysis.  Performed exploratory data analysis (EDA) to identify trends, anomalies, and insights.

Executive Mtech, Big Data And Blockchain

B.Tech In Cse (First Class With Honours), Computer Engineering, 81.6

Diploma Of Education, Computer Science First Class With Distinction, 76.4