Amit Kumar
Bangalore
Summary
To proudly associate with your organization where my knowledge will be enhanced & my professional experience will be of increased value. I aim to contribute to the organization through proactive approach, leading capabilities and self-development along with deep sense of commitment.
Overall 16+ years of experience in IT Industry in the field of Data Warehousing/Data Engineering in Banking, Electronic Payment, Insurance, Telecom and Healthcare Domain. I have been extensively working in the ETL Tool Ab Initio, UNIX, Hadoop and SQL. I am currently working as AVP in Citi in Pune.
Overview
16
16
years of professional experience
1
1
Certification
Work History
ETL Lead
Citi
05.2020 - Current
- Transformer is created with the objective to create all kind of extracts from the Citi futures booking which are required by the OCC systems (regulatory systems) along with other internal BI systems
- Worked as a Designer to design the End to End process of Extracting, Transforming and Loading the Data which was implemented using Ab Initio
- Loading data in HDFS for the analytical purpose
- Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
Ab Initio Designer/ Hadoop Migration Developer
INFOSYS LTD
05.2015 - 12.2019
- GMR (Global merchant repository) is created with the objective to generate a SSOT(Single source of Truth) in merchant space which can be used by all the teams (inside or outside) which are using Visa Merchant information
- For creating this, It extracts data from multiple sources, do a fuzzy matching on Name, address attributes of merchant, and ultimately identifies the uniqueness of the Merchant Store
- Worked as a Designer to design the End to End process of Extracting, Transforming and Loading the Data which was implemented using Ab Initio
- Loading data in HDFS for the analytical purpose
- Moving the Ab initio modules to Big data framework
Ab Initio Designer
RS SOFTWARE
05.2012 - 11.2014
- ATM Locator project is an initiative taken by VISA to create an in-house repository, which will contain the entire visa card accepting ATM machines with their location and with their geocodes
- Also it include services which return the Nearest ATM to a particular location
- Worked as a Designer to design the End to End process of Extracting, Transforming and Loading the Data which was implemented using Ab Initio
Ab Initio Designer
IBM
12.2011 - 04.2012
- Solvency II is based around the need for European Insurers to calculate their solvency according to international rules, evaluate and manage their risk and report on solvency to the local regulators
- Standard Life Group as per other European Insurers will need to adhere to the Solvency II directive
- Worked as a Designer to design the End to End process of Extracting, Transforming and Loading the Data which was implemented using Ab Initio
Senior Developer/Team Lead
Capgemini India
06.2010 - 12.2011
- Interface application has been developed for system integration purpose where different systems of Mobistar (Comverse, SAP, Loyalty) has been integrated using Ab initio code
- Worked as a Developer to design the End to End process of Extracting, Transforming and Loading the Data which was implemented using Ab Initio
Tech Lead; Senior Developer
Genpact
08.2009 - 06.2010
- MEDB application is to provide Patient, pharmacy and provider data from the Information Warehouse (Teradata Tables) of Medco to different platform called BIP which will be using that data for marketing purpose
- It will create a 360º view of the Patient and all of their medical products
- Worked as a Developer as well as tech lead to design the End to End process of Extracting, Transforming and Loading the Data which was implemented using Ab Initio
- Having the responsibility of preparing the LLD after understanding the requirements from the client, developing Ab Initio graphs and mentoring junior developers
Senior Developer
TCS
07.2008 - 08.2009
- CMR application is to provide consistent customer to account/role linkage across functions and LOBs creating a 360º view of the customer and all of their products
- CMR’s capabilities were designed to help address the global issues of: Customer Privacy and Regulatory Compliance, Customer Management, Profitability and Financial Management
- Worked as a Designer to design the End to End process of Extracting, Transforming and Loading the Data which was implemented using Ab Initio
- Worked as Team Lead in Ab Initio Development Team having the responsibility of preparing the LLD after understanding the requirements from the client, developing Ab Initio graphs and mentoring junior developers
Education
Bachelor of Engineering -
Manipal Institute of Technology
Manipal, Karnataka01.2005
Skills
- Ab Initio GDE 402
- Ab Initio Enterprise Meta Environment (EME)
- Express IT
- Metadata Hub
- Hadoop
- Map Reduce
- HDFS
- Hive
- Python
- DB2
- Oracle
- Agile Methodology
- Waterfall Methodology
- Scripting languages
Languages
English
Hindi
Training
- Training on Ab Initio ETL Tool organized by Ab Initio Corporation.
- Training on Data Warehousing organized by TCS.
- PL/SQL training organized by TCS.
- Hadoop training organized by EDUREKA.
- Python and ML training by Coursera.
Disclaimer
I hereby declare that the information given by me is true to the best of my knowledge and belief., 05/09/22, Bangalore, Karnataka
Personal Information
- Passport Number: H0440332
- Passport Expiry Date: 03/08/28
- Date of Birth: 01/07/81
- Gender: Male
Certification
python
Timeline
ETL Lead
Citi
05.2020 - Current
Ab Initio Designer/ Hadoop Migration Developer
INFOSYS LTD
05.2015 - 12.2019
Ab Initio Designer
RS SOFTWARE
05.2012 - 11.2014
Ab Initio Designer
IBM
12.2011 - 04.2012
Senior Developer/Team Lead
Capgemini India
06.2010 - 12.2011
Tech Lead; Senior Developer
Genpact
08.2009 - 06.2010
Senior Developer
TCS
07.2008 - 08.2009
Bachelor of Engineering -
Manipal Institute of Technology
python
Similar Profiles
Misty WalkerMisty Walker
Learning Experience Designer at CitiLearning Experience Designer at Citi
Damien BurksDamien Burks
Cloud Security Engineer - SVP at CitiCloud Security Engineer - SVP at Citi
Jan Vince UlandayJan Vince Ulanday
Financial Analyst at CitiFinancial Analyst at Citi