Data Engineer Senior
Resume:
Anil Kumar G
Hyderabad, Telangana,
*********.******@*****.***
Overall 11 years of experience in IT industry, since 4.9 years working as a Senior Data engineer/ Snowflake Developer and highly motivated individual with proven ability to learn fast and work well under pressure.
Experience Summary:
Proficient in Design and Development of process required to Extract, Transform and Load data into the data warehouse using Snowflake Cloud Database, AWS S3
Expertise in building/migrating data warehouse on Snowflake cloud database.
Expertise in working with Snowflake Multi - Cluster Warehouses, SnowSql, Snowpipe, Internal/External Stages, Stored Procedures, Clone, Tasks and Streams.
Involved in Zero Copy cloning – Cloning databases for Dev and QA environments.
Storage Considerations for Staging and Permanent Databases / Tables.
Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source system which include loading data into snowflake tables.
In-depth knowledge of Snowflake Database, Schema and Table Structures.
Experience in various methodologies like Waterfall and Agile.
Having very good experience working with IICS where I have created multiple mapping/mapping tasks and taskflows to handle the ETL process as per the business requirements.
Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like Flat Files, Oracle, complex files.
Quick learning, implementation and easy adoption to new technologies.
Good team player, very proactive and willing to learn new updates in technology.
Worked closely with Tableau Developer to create dashboards per Business.
Having good knowledge in deployment process to migrate the objects to higher environments.
Used WinSCP tool to place all the source files(.csv) to bring the history.
SnowPro Certified.
Exposure to Matillion, Python, ADF, Airflow and DBT
Educational Summary:
Completed my Post Graduation (MCA) from Osmania University in 2012
Completed my Graduation (B.SC) from Osmania University in 2008
Work Summary:
Working for IBM India Private Ltd as a Senior Data Engineer from July 2022 to Till Date
Worked with Sonata Software Ltd as a Digital IT Specialist from dated Nov 2016 to July 2022
Worked as a Support Engineer at Black knight India Solutions Pvt Ltd (BKFS) from Feb 2015 to Oct 2016
Worked as a Software Engineer in Platinus Technologies Pvt Ltd from Jan 2014 to Feb 2015
Work History:
Company: IBM INDIA PVT LTD
Senior Data Engineer
Client Name: Nestle, Switzerland
Period: Sep 2024 to Till Date
Project Profile:
Nestle is multinational FMCG company which is headquartered in Vevey, Switzerland. Nestle is one of the largest food companies in the world. Nestle using SAP as its ERP system and part of migration from SAP ECC to S4/Hana so we are doing the same from Snowflake side, we have started migrating the reporting objects to Snowflake where we have 3 different layers like STG, INT and PRS, we are handling the data from different regions like SDR and AOA MONO and this AOA means AOA, EUR and AMS regions. Initially we started with SDR data migration to Snowflake, so for this all the SAP ECC data migrated S4 system and whatever the changed happening in the SAP source system we must perform the same kind of operation in Snowflake.
Contribution / Highlights:
Identified the impacted objects from SAP to Snowflake which need to replicate to Snowflake
Took care of Lineage part from Snowflake point of view.
Performed Initial Analysis Impacted objects for 372 table which are around 4000 objects.
Successfully migrated SDR data to snowflake from DEV to Pre-Prod and to Production Environments.
Performed all the Impact Analysis, Remediation Analysis and Remediation Steps in Non-Prod Environments.
Succeffully loaded the data files which exist in Azure to Snowflake Tables.
Performed the Fit Gap Analysis, gathered the required information for the tables and columns.
Company: IBM INDIA PVT LTD
Senior Data Engineer
Client Name: Pfizer Inc, Manhattan, NYC
Period: Aug 2022 to Sep 2024
Project Profile:
Pfizer is a Multinational Pharmaceuticals Company head quartered in New York City, USA. Pfizer’s ERP system is completely managed SAP, so we are in the process of IOA managed services mainly reporting stuff is migrating from SAP to Snowflake this is IOA project where we are dealing mostly with Covid shipments and its relevant plants and how they are transporting with in the USA and across the world based on shipments and go-downs and Pfizer does also use third party courier services apart from their own carriers.
Contribution / Highlights:
Successfully migrated all the reporting work part of phase -1 from SAP to Snowflake.
Implemented procedure for few data flows which carries the data from source tables to target tables of snowflake.
Implemented SAP business logics in snowflake stored procedures.
Used IICS tool to Extract, Transform and Load the data into Snowflake Tables.
Scheduled and monitored the jobs in IICS to check the activities of the Data loads.
Succeffully loaded the data files which exist in AWS S3 to Snowflake Tables.
Performed the Fit Gap Analysis, gathered the required information for the tables and columns.
Developed multiple procedures in snowflake for few data flows which are there in SAP.
Done the testing in each environment like Dev, UAT and Prod.
Involved in data validation, created test document in each stage, created tRSV document for the procedures which I worked on in each environment separately.
Done the repointing from IO_STG to CDM schema for all the tables which are included in the procedure including Look Up tables.
Actively involved in Deployments of my work which consists different teams to coordinate for approval, tools and process.
Created Tableau Dashboard with minimal support for one DP Metric which delas with all the Material, location, plants information etc.
Automated the Excel dashboard to Tableau for Inventory Dashboard related to ECC_Matetial_Movements.
Successfully automated the required dashboards from excel to Tableau and created DP Metric dashboards in Tableau where the source is different like SAP APO and Kinaxis RR Data.
Worked with Tableau Developer to create the Dashboards of our reporting objects in snowflake part of NWA Project.
Used WinSCP tool to place all the source files(.csv) to bring the history.
Company: Sonata Software Ltd
Snowflake Developer
Client Name: Private National Mortgage LLC, Moorpark, CA
Period: May 2020 to July 2022
Project Profile:
PennyMac Correspondent system deals with the funded loans, different correspondents will get the leads which are funded, will be purchased by PennyMac and in turn they will see these loans for profit. BE and Mando are two types of commitments used for buying and selling the loans.
Contribution / Highlights:
Created internal and external stage and transformed data during load.
Designed Staging, Integration, Information and Archive areas on S3.
Used Temporary and Transient tables on diff datasets.
Shared sample data using grant access to customer for UAT.
Created S3 events for job triggering.
Zero Copy cloning – Cloning databases for Dev and QA environments
Time Travel, Data Retention Settings for Storage for Crucial Tables.
Data Sharing from Prod to Stage and Dev Environments.
Worked on Snowflake streams to process incremental records.
Designed Update and Insert strategy for merging changes into existing Dimensions and Fact tables.
Unloaded the data from snowflake to send data to down streams.
Used Snowflake features to handle Upload process and Table Mover process part of our project.
Company: Sonata Software Ltd
Senior Support Analyst
Client Name: Private National Mortgage LLC, Moorpark, CA
Period: Nov 2016 to May 2020
Responded to emergencies and breaking news stories with strong sense of urgency, at any hour.
Collaborated with DBA and Development departments to respond to questions and concerns regarding project details.
Led cross-functional teams to analyze and understand enterprise-wide operational impacts and opportunities of technology changes.
Worked closely with all product development departments to create and maintain client meetings.
Maintained strong knowledge of third-party risk management within vertical industry.
Collaborated with developers, analysts and project managers to expedite incident resolutions.
Provided 24/7 support for web and client-based applications, file and data feeds and batch processes to prevent impact to business.
Conducted and supported implementation delivery with client and internal departments.
Analyzed and mapped data and wrote SQL scripts to extract data from SQL databases.
Developed and maintained effective client communications to guarantee client satisfaction and improve client retention.
Interfaced with customers and developers to diagnose problems and implement configuration requirements and solutions.
Used ServiceNow to track, maintain and update and trouble tickets on daily basis.
Delivered in-depth Software training, imparting knowledge of best practices for protecting data and minimizing errors.
Collaborated closely with upper management to drive strategy through development and implementation of new processes.
Company: Black Knight India Solutions Pvt Ltd (BKFS)
Support Engineer & Developer
Client Name: Amerihome Mortgage LLC, Woodland Hills, CA
Period: Feb 2015 to Nov 2016
Responsibilities:
Need to monitor whether all the services and applications are working fine or not.
Review the loan #s reported by client whichever the having the issues like unable lock, prices are not coming, etc.
Need to analyze the functionality and provide the work around for the loans reported by the client on the same.
If require we will start/stop the services related to app servers by notifying and taking the permission from the client.
Verifying the all the loans are processing the as usual or not and any pended loans are there.
Correcting the required fields/information for the loans reported.
Need to join the bridge call/conference call when client is having issues with an application.
Need to take care about all the loan #s reported on the day and notifying them to the client with a resolution/work around.
Need to handle the situations when the application down, in this case need to take the logs back up and verify all the services are up and running.
Company: Platinus Technologies Pvt Ltd
Support Engineer
Client Name: Horizon Technol, CA, USA
Project: Conrep Portal.
Period: Jan 2014 to Feb 2015
Responsibilities:
Involved in Backend as well Front-end using Html5, Css3, JavaScript, jQuery JSP, Servlets, Spring and Maintained application coding standards.
Have worked on the modules of application like Admin, supplier, distributor, item module.
Have involved in designing the pages using Html5 and Css3.
Have involved in design and developing the screens like Admin/Manager, Sales, Training, Sourcing departments and adding editing the list when new consultant has arrived.
Developed the Home page which displays the all the modules of the Project.
Have fixed all the bugs assigned to me on time.
Involved in Unit testing.
Contact this candidate