Working as a Lead Data Engineer with Snowflake Cloud as a primary skill. My expertise lies in designing, building and optimizing data products.In my current role, I am working on the data products related to sourcing functional area where the data comes from multiple source systems which needs cleansing by ETL method and in some cases we directly use ELT method. Along with these we use BIML Flex tool to generate a data vault model and I have created a tool to do the same using open source tools where the entire process from column naming to view creation as well as ETL procedure creation is automated.

Worked with LTI Snowflake CoE team and was part of the team that developed LTI PolarSled. LTI PolarSled is a framework developed by LTI(Our team) that helps enterprises accelerate their migration to Snowflake's cloud data platform.LTI PolarSled has been recognized by Snowflake as a Global Innovation Partner of the Year.Specifically, lead the program's automation of migrating SAP BW and SAP HANA objects to Snowflake artifacts.

Gathering and documenting requirements: This involves working with stakeholders to understand their needs and expectations for a project.Analyzing data: This involves using data analysis techniques to identify trends and patterns that can help inform decision-making.Designing solutions: This involves creating solutions that meet the needs of stakeholders and align with the organization's goals.Communicating with stakeholders: This involves keeping stakeholders informed of the project's progress and ensuring that their needs are met.Managing projects: This involves planning, tracking, and executing projects to ensure that they are completed on time and within budget.Providing training: This involves training stakeholders on how to use new systems or processes.

- Responsible for conducting design work shops involving customer and cross functional teams.- Responsible for all phases of the project cycle from Blueprinting, Design Architecture, Configuration, Development, Documentation, Integration Testing and Go Live.- Worked on multiple tasks like studying the Business Process and understanding the whole Landscape and Architecture for BW configuration, Analyzing issues, finding RCA, fixing issues, debugging, etc.,- Studied system landscapes to isolate issues related to business practices and performance.- Responsible for safeguarding customer systems at the time of crucial phases like upgrade, project go live etc.,- Implemented multiple BW system from scratch be it BW on HANA or- BW4HANA for different customers operating in domains FMCG, Power transmission and generation, Oil and Gas and Aviation.- Conducted training sessions on various topics of BW to customers, actively participated in KT sessions.

- Represent team in customer discussions, in different phases of project viz requirement gathering, GAP analysis, design, testing, deployment and L3 support.- Involve in discussions with cross functional teams to understand customer requirements in a better way.- Responsible for monitoring the work done by the team and review the same before taking it to the quality system.- Responsible for conducting the training session on the recent advancements related to BW to the customer as well as the team.- Proactively worked on various aspects of performance improvement for which me and my team has been highly appreciated by the customer.- Worked on data volume management and was responsible for releasing 500Gb of data from one cube alone and in whole close 2tb.- Developed data flows and reports as per the business needs.

- Collaborated with cross-functional development team members to analyze potential system solutions based on evolving client requirements.- Involved in the different phases of project life cycle like design, develop, test, deploy and support.- Designed and developed data flows and reports.- Worked on the performance improvements of query and improved the average navigation time of the query from 40 sec to 16 Sec.- Written various ABAP programs like DVM, compare objects from different systems etc.,- Involved in BW 7.4 version upgrade.

- Partnered with team members and developed BW objects and data flows.- Worked closely with L2 and L1 teams in resolving the issues related to data loads, logics, data etc.,.- Worked closely with support teams to understand the customer queries and provide the resolution.- Debug the data or logic related issues.- Write the different kinds of routines to cater the business requirements.

Learn how to implement a project in a team