Anshu Makkar
Sr. Database Developer
Pune,Maharashtra
Summary
Enthusiastic Data Engineer eager to contribute to team success through hard work, attention to detail and excellent organizational skills. Skilled in working under pressure and adapting to new situations and challenges to best enhance the organizational brand. Recognized consistently for performance excellence and contributions to success in banking industry.
Overview
4
4
years of post-secondary education
9
9
years of professional experience
Work History
Sr. Application Developer
CitiCorp Services
Pune, Maharashtra
12.2017 - Current
- Experience in Client On-boarding for AML/KYC domain and actively participated in designing Database model following normalization and data integrity concepts.
- Reviewed existing programs to refine, reduce operating time and improve techniques related to Database.
- Automated manual process for Banker for pre-periodic review process for KYC team and reduced MTP by 75%.
- Creating optimized queries using indexes, explain plan & hints and helps in integration with service layer to DB layer.
- Experienced in end-to-end testing and handling defect calls for team.
- Working in other modules as shadow resource to understand ETL pipeline using informatica when data is moved from one region to another for cross border clients.
- Automated Certain processes like Maker checker process when any client profiles change.
- Data clean-up strategy for all contact details registered for On-boarding.
- Interacting with end users for their feedback.
Consultant
Capgemini
Mumbai, Maharashtra
02.2015 - 12.2017
- Performance tuning of SQL Queries using hints and explain plan saving up to 40 -60 % of CPU utilization.
- Automated table creation using excels formula.
- Structured Process to load data from file to table.
- Created active batch jobs to load file on specific time. Reduced time to move data using BULK COLLECT. Analyzing data as per requirement and report issue to BSA.
- Liaised with customers, management and Business to better understand customer needs and recommend appropriate solutions.
Software Developer
l&T Infotech
Mumbai, Maharashtra
07.2012 - 02.2015
- Automated loading process using SQL and UNIX.
SQL scripts for manipulating data as per business requirement. - Used PL/SQL and SQL*Loader to load flat files and error capturing into log tables, also fixed security hole in control file of SQL*loader.
- Developed control files to load various sales data into system via SQL*Loader. Interacted with release management (RFC), change management (CCS), DBA and application teams.
- Provided support during production implementation of changes in application. Involved in documentation for every change and preparing RFC's using service now.
- Created purge script to remove more than one-year old data.
Education
B.TECH - Electronics And Communications Engineering
Chandigarh Engineering College
Chandgarh 08.2008 - 07.2012
Skills
SQL
PLSQL
ETL
JAVA
OOPS
SQL Loader
Informatica
Unix Shell scripting
Autosys
SQL Query Tuning
Indexing Techniques
Tools
Jira, Confluence, BitBucket, Jenkins, Git, SQL Developer, Putty, Eclipse, Intellij IDEA
Timeline
Sr. Application Developer
CitiCorp Services
12.2017 - Current
Consultant
Capgemini
02.2015 - 12.2017
Software Developer
l&T Infotech
07.2012 - 02.2015
B.TECH - Electronics And Communications Engineering
Chandigarh Engineering College
08.2008 - 07.2012