2013-2017
B.tech(IT)
Maharaja Surajmal Institute of Technology
B.tech(IT)
Maharaja Surajmal Institute of Technology
Have 4.4 years of full-time experience in Business Intelligence as BI Developer in developing BI applications using Microsoft Business Intelligence (MSBI) Tools- SQL Server Integration Services (SSIS), SQL Server Analysis Service (SSAS), SQL Server Management Studio (SSMS), Power BI and Azure Data Factory, Azure Synapse, Key Vault, Logic App, Spark SQL, Data Vault 2. O, AWS, Matillion, and Snowflake.
Projects: -
Senior System Engineer at GlobalLogic Pvt. Ltd. (Feb 2021 – Current)
CONA: - 1. Design the whole warehouse in Data Vault Model from the beginning.
2. Built Error Notification to capture error at run time and send it through Amazon SNS
service.
3. Design an Email with the help of Python and Amazon SES service.
4. Working for a US client as an individual member.
5. Won Monthly award from GL side.
Data Engineer at Neal Analytics. (Apr 2020 – Feb 2021)
EBC/MTC: - 1. Build the pipeline for EBC and MTC Project using Azure Data Factory.
2. Built Data Model for EBC Report and developed multiple power bi reports.
3. Analyze requirements and develop ETL/BI report.
4. Worked on the triggered, automatically send notification for pipeline using the logic app.
5. Recognize for Q2, Q3- Reward in Neal India Company.
Senior System Engineer at INFOSYS LTD. (Nov 2017- Mar 2020)
Forecasting: - 1. Proficient in writing SQL queries for reporting and data analysis.
2. Data modeling and implementation of ETL Procedures, data cleansing functions, load
automation.
3. Daily work involves creating or updating jobs and implementing them for scheduling SSIS
packages with the environment variables.
4. Analyze requirements and develop ETL/BI reports and dashboards.
5. Works with Data Scientists to Infer tends from a variety of data sources and confidently
delivers their interpretation and makes recommendations to executives.
6. Created dashboards and various types of reports using Power BI.
7. Worked on tabular model using SQL Server Analysis Services 2012 (SSAS). Development
of packages according to the ETL specifications for the staging area & Warehouse data
loading using SQL Server Integration Services (SSIS) & SQL Server 2015.
Data warehouse Design.
Build a warehouse as a single source of truth.
Built automated notification email for any data issue in any table.
Building a mechanism to evaluate goals and target for Client Sales
CONA: - 1. Design the whole warehouse in Data Vault Model from the beginning.
2. Built Error Notification to capture error at run time and send it through Amazon SNS service.
3. Design an Email with the help of Python and Amazon SES service.
4. Working for a US client as an individual member.
5. Won Monthly award from GL side.