AMIT KUMAR
Data Engineer
New Delhi
Summary
Dynamic professional with over 11 years of experience in analytics, specializing in the development and maintenance of data delivery applications for business users. Expertise in advanced cloud technologies, including Amazon Web Services, Snowflake, and big data platforms, with a proven track record in managing enterprise-wide data delivery operations across diverse data science projects and machine learning models. Skilled in end-to-end automation processes, from requirement gathering to the delivery of high-quality reports while optimizing resource utilization. Proficient in agile project management methodologies and tools such as LeanKit, Jira, and Confluence, with a strong focus on enhancing efficiency through automation.
Overview
13
13
years of professional experience
2
2
Languages
Work History
Data Engineer
Natwest Group
07.2022 - Current
- Data operations: Development of architecture for departmental data flow. Management of productionized applications, and maintenance of data pipelines. Enablement of platform upgrades and disaster recovery events.
- Cloud migrations: Supported the migration of on-premises applications to the cloud and owned the discovery phase for fraud and financial crime areas.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
- Automated routine tasks using Python scripts, increasing team productivity by 30% and reducing manual errors by 50%.
Analytic Consultant 4
Wells Fargo
06.2021 - 06.2022
- Detection Strategies Development: Development of detection strategies related to consent for internal fraud. Automation of alerts when an application has a missing signature (consent). Also helped in the periodic review of existing strategies and scenarios for credit cards and personal loans. It includes validation of business rules applicability, updating documents to reflect the necessary changes, and checking for alerts disposition notes.
- Sales Practice Report: This has been built to identify any internal unfair sales practices for consumer and business banking. My role was primarily in refining the metrics, enhancing the data quality, and including other uncovered areas.
- Streamlined data collection and analysis processes, resulting in significant time savings for the team.
Lead Analyst (Associate)
Natwest Group
03.2018 - 06.2021
- Continuously updated knowledge of industry best practices and emerging trends, sharing insights with colleagues to drive continuous improvement within the team.
- Anti-Bribery and Corruption (ABC) Executive Reports: Developed automated executive reports in Tableau, using SAS and Teradata for data processing, and implemented data sensitivity controls.
- Reconciliation Reports: Created Gift and Entertainment Reconciliation reports to track compliance with ABC policies.
- Detective Payment Control Report: Introduced a payment monitoring report for associated parties, later extended to cover corporate donations, and charitable activities.
- Product Monitoring and Risk Analytics: Automated product monitoring using SAS and Teradata, and replaced legacy data with reliable sources.
- Ad-hoc Analysis: Conducted specific analyses, including overseas transactions and budget shortfall investigations.
- Risk Reporting Setup and Framework Enhancement: Collaborated with risk and regulatory teams to establish reporting for conduct risks. Enhanced reporting and minimized risk by automating processes and strengthening data security controls.
Senior Business Analyst
Evalueserve Pvt. Ltd.
09.2016 - 03.2018
- Advance Analytical Support and Customer Insight
- Promotional sensitivity analysis: It was done to understand the promotional impact on brand sales over time. SAS and SQL were used for data processing, and Excel and PowerPoint were used to finally present the outcome of the study.
- KOL Clustering and Mapping: Created a dashboard using SAS VA to showcase the influence area of KOLs on a map.
- Analytical support and sales reporting for the Europe region, mainly for the ophthalmology market.
- Data Management, Sales Reporting, and Patient Tracker:
- Assisting the Global Business Unit with data management needs using the MS SQL platform as a database server and Excel VBA for streamlining, automation, and quality checks for the processes involved.
- Developed a Master Sales reporting tool to showcase all the relevant KPIs, covering all the markets and their respective products. Additionally, we developed a patient tracker having longitudinal, anonymized patient-level data.
Analyst
Novartis Healthcare Pvt. Ltd.
08.2015 - 09.2016
- Data Management and Reporting
- Worked on Field Analysis Data System that included managing and processing of data from various sources using SQL and SAS platform
- Maintained and enhanced SAS based dynamic system to generate hundreds of reports with various KPIs
- Worked on segmentation of target universe for specific brands and quota setting using defined module and simulation techniques
- Developed parallel tool for Incentive calculator (VBA based) that was extremely helpful for the field to understand and use.
Analyst
Cognizant Technology Solutions
04.2013 - 07.2015
- Monthly Sales Reporting and Market Analysis:
- Worked toward automating the report using SQL and VBA, which reduced the turnaround time by about 75%.
- Incentive Compensation: This includes studying the client's quarterly incentive plan, its business rules, and implementing them accurately. This requires a high level of accuracy, as it relates to actual dollars. This enables the sales force team, as well as their top management, to track their performance.
- Analysis of sales and activity data for various product and market combinations.
- Solve business problems, gather data, transform databases, interpret data, and publish/generate reports.
Education
Ph.D. - Artificial Intelligence
Indian Institute of Technology, Patna
Patna, India 04.2001 -
Post Graduate Certificate - Data Science & Machine Learning – Data Engineering
Indian Institute of Technology, Roorkee
Roorkee, India05-2022
M.Tech - Biotechnology
Center For Biotechnology, Anna University
Chennai, India 04.2001 -
B.E. - Biotechnology
Institute of Engineering & Technology, DBRA University
Agra, India06-2010
Skills
Frameworks: Hadoop (5) Hive & Impala (5) Teradata (4) Magellan
undefinedExtra-Curricular Achievements
- Organizing member of GurugramX - initiative at NatWest for fun and outdoor events
- Active member of “Nation First”, an Art of Living initiative
- Committee member for Cognizant Gurgaon Team outings
PAPERS PRESENTATION, CONFERENCES AND HACKATHON
- Participated and won the 2nd place in the Data Science hackathon organized by IIT, Roorkee (April 2022).
- Contributed in Spike organised to create a model for better detection of Money Mule case for Financial Crime Department at NatWest Group (July 2023)
- Reviewed and presented a poster on ‘Development of Plant Expression System for the production of filarial proteins’ at Bharathidasan University, Trichy (Feb 2012).
- Attended and organized the seminar, National Conference on Parasitology held at Anna University, Chennai (November 2011).
- Represented Anna University in Chennai Science Festival conducted by Government of India (January 2011).
Personal Dossier
- Permanent Address: Sohsa, Arwal, Bihar - 824127
- Date of Birth: 1987-01-25
- Fathers Name: Mr. S.K. Sharma
- Nationality: Indian
- Reason for Change: new opportunity that offers broader exposure to modern data platforms, cloud technologies, and end-to-end data solutions
Timeline
Data Engineer
Natwest Group
07.2022 - Current
Analytic Consultant 4
Wells Fargo
06.2021 - 06.2022
Lead Analyst (Associate)
Natwest Group
03.2018 - 06.2021
Senior Business Analyst
Evalueserve Pvt. Ltd.
09.2016 - 03.2018
Analyst
Novartis Healthcare Pvt. Ltd.
08.2015 - 09.2016
Analyst
Cognizant Technology Solutions
04.2013 - 07.2015
Ph.D. - Artificial Intelligence
Indian Institute of Technology, Patna
04.2001 -
M.Tech - Biotechnology
Center For Biotechnology, Anna University
04.2001 -
Post Graduate Certificate - Data Science & Machine Learning – Data Engineering
Indian Institute of Technology, Roorkee
B.E. - Biotechnology
Institute of Engineering & Technology, DBRA University