ANAND KUMAR
BANGALORE,Karnataka
Summary
ETL Data Consultant with 14+ years of professional experience with in-depth knowledge of system management, analysis, design, development, testing, performance tuning, production implementation and maintenance of the projects in the area of Data Integration, Data Warehouse, BI in BFSI & IB. Highly Proficient in designing and developing ETL and Data integration solutions. Looking forward to contribute in challenging environment with my knowledge & skills.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Associate Consultant
CGI
04.2021 - Current
- Responsible to manage team of 13 developers and 4 production support resources with sprint planning and task assignment
- Good exposure to Financial Group and Investment banking in Accounting area to generate reports provide client queries regarding data processing
- Experience in Data Profiling, Designing & Developing simple to complex ETL & ELT jobs
- Have worked for all phases of project life cycle (Initiation à Design à Development à Testing à Production à Warranty Support)
- Have worked on Unix Shell scripting for validation and processing of files when required
- Good knowledge on Jira, sprint process and retrospective process, created multiple dashboards for sprint work tracking and have been performing task of agile master
- Handling quality checks for team to review codes, test results and documentation to reduce and eliminate risks and errors
- Having project experience on PowerBI to create reports for DataStage jobs performance and analysis
- Having project knowledge of Kafka setup and API calls using DataStage, Unix and curl commands
- Learning Azure & Snowflake to move into cloud area and know more about data warehouse as a service for cloud based storage
- Conducted Knowledge Transfer & Community sessions in the company for Freshers & non-ETL resources
- Manage ETL projects, including resource allocation, timelines, and budgets
- Set goals, provide guidance, and evaluate team performance
Senior Associate/ Lead ETL Developer
J.P. Morgan Services Pvt Ltd
01.2017 - 04.2021
- Business As Usual activities and upgrades
- On boarding new clients to VPR
- Helping Production support with failures and documenting process
- Analyze and understand the Technical Specification Document (Source to Target matrix) for all mappings and clarify the issues with Data Architects
- Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet designer, Informatica Repository Manager and Informatica Workflow Manager
- Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target
- Monitored transformation processes using Informatica Workflow monitor
- Provided few enhancements to the existing etls as per the requirement
- Migrated code from one environment to other
- Automated Healthcheck script ( for Informatica, Datastage, MQ client, Autosys etc) to monitor the environment and all applications and alert for any issues
- Created single job flow which can shutdown and startup all applications at a time in 15mins
Senior Software Engineer
Mindtree
07.2014 - 12.2016
- Company Overview: AIG - LEAN, Actuarial, CRDS
- AIG - LEAN, Actuarial, CRDS
Data Specialist: ETL DataStage
IBM India Private Limited
10.2013 - 06.2014
- iKnow DB Upgrade
- Campaign Enhancement
Project Engineer
Wipro Technologies
06.2010 - 09.2013
- Company Overview: LLOYDS Banking Group
- LLOYDS Banking Group
Education
B.Tech - Information Technology (IT)
Sathyabama University
Chennai01-2010
Intermediate - PCM
Mrs. K.M.P.M Inter College
Jamshedpur01-2006
S.S.C -
Bishop WestCott Boy's School
Ranchi01-2004
Skills
- ETL Integration (On Prem, Cloud)
- Data Analysis
- Data Cleaning
- Data Modeling
- Reporting
- Team Management
- Task assignment
- Decision making
- Communication
- Multi-tasking
- Agile
- Scrum Master
- Data collection and analysis
- Planning and execution
- Problem-solving
- Change management
- Quality assurance
- Team collaboration
- Attention to detail
- Issue troubleshooting
- Process improvement strategies
- Conflict resolution
Certification
- Azure Data Engineering Associate - DP 203
- Azure Fundamental Certified - AZ 900
- DataStage v8.5
Accomplishments
- CGI Star Performer 2023
- CGI APEX SILVER Award for excellent work done for client and managing team
- JPMC- Outstanding contributor for delivery excellence
- Received 'Feather In My Cap' Award and was presented with certificate of appreciation for delivery excellence In Wipro
Learning in progress
- Azure Data Factory
- HDInsite
- Azure Blob
- Data Lake
- SnowFlake
Tools and technologies
C, C++, Unix, SQL, Curl, Clear Case, Quality Center, Service Manager 7, Putty, DataStage 8.x, 9.x & 11.5, Informatica 9.x, Teradata SQL Assistant, Mainframe, TOAD, RTC, Control-M, Oracle SQL Developer, PVCS, WebSphere MQ, Tortoise SVN, GIT, CICD, MettleCI, PowerBI, Oracle 10g, 11g, 12c, DB2, Kafka, Amazon S3, MQ, Rest API, Azure, Snowflake
Personal Information
Name: Anand Kumar
Designation: Associate Consultant
Passport: V7543234
Current Location: Bangalore
Hobbies: Cooking and Travelling
Timeline
Associate Consultant
CGI
04.2021 - Current
Senior Associate/ Lead ETL Developer
J.P. Morgan Services Pvt Ltd
01.2017 - 04.2021
Senior Software Engineer
Mindtree
07.2014 - 12.2016
Data Specialist: ETL DataStage
IBM India Private Limited
10.2013 - 06.2014
Project Engineer
Wipro Technologies
06.2010 - 09.2013
- Azure Data Engineering Associate - DP 203
- Azure Fundamental Certified - AZ 900
- DataStage v8.5
B.Tech - Information Technology (IT)
Sathyabama University
Intermediate - PCM
Mrs. K.M.P.M Inter College
S.S.C -
Bishop WestCott Boy's School
Similar Profiles
Benjamin WeilerBenjamin Weiler
Software Developer Consultant at CGISoftware Developer Consultant at CGI
Satyendra SinghSatyendra Singh
Software Engineering Lead at CGISoftware Engineering Lead at CGI
Marius Meulaje KengmogneMarius Meulaje Kengmogne
Bilingual IT Help Desk Technician at CGIBilingual IT Help Desk Technician at CGI