Proficient in using SQL Server Integration Services (SSIS) and ADF to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) applications
Design and develop data model and data warehouse in Snowflake.Create and maintain tables,views and other database objects. Create pipelines to migrate data from different sources to Snowflake DB
Excellent T-SQL Developer skills including Stored Procedures, Indexes, User Defined Functions, Triggers, and Transactions.
Data import and Export by using DTS Wizard and SSIS and SSRS
Experienced in requirement gathering/analysis, design, development, and testing and production rollover of reporting analysis projects.
Have experience in package configurations, logging, debugging and deploying the packages using File system deployment and SQL Server deployment.
Expertise in generating reports using SQL Server Reporting Services.
Experienced in Drill down, Drill through, Drill Down, Parameterized reports, Cascading reports and Sub Reports using Report Designer in SSRS.
Have worked on creating Power BI reports (intermediate level)
Overview
12
12
years of professional experience
Work History
Data Specialist
Larsen & Turbo Infotech
08.2021 - Current
Optimized quality of data by developing and continuously improving data collection and automated upload strategies.
Validated incoming data against quality standards to eliminate irrelevant or unusable information.
Prepared demonstrations showing product configurations and data handling capabilities.
Tested and refined data management systems to scale with increasing load demands.
Helped develop and maintain deliverables.
Reviewed and updated client correspondence files and database information to maintain accurate records.
Lead the offshore team to ensure timely deliveries.
Principal Consultant
Mercedes Benz Research and Development India
06.2018 - 07.2021
SharePoint
Creation of Nintex workflows to automate the processes.
Orchestration for driver/Software/Image packages works via sharepoint.
Reporting
Provide custom reporting solutions to Customers across regions.
Provide data to various reporting platforms.
End to end responsibility of all ETL jobs.
Lead Consultant
ITC Infotech
05.2017 - 06.2018
Project Details: Eurofins PMBI -Marlow
Senior Systems Engineer
CGI
11.2015 - 05.2017
Project Details: Scotia Bank -Marlow (Nov 2015 to Till date)
It's a back office application for Marlow team that reduces their manual effort to a great extent.