Chandan Kumar Email & Phone Number

Mumbai, Maharashtra, India

VP at Wealth Management Technology for Data Platforms with focus on Cloud Migrations

Gurugram, Haryana, India

Data Specialist with 14+ Yrs experience serving FSI, Health Care and Public Sector clients.

Davenport, Iowa, United States

Davenport, Iowa, United States

Gurgaon, India

Senior Consultant on Business Intelligence and Data Warehouse

Informatica Senior developer and Module Lead.

TARDIS Implementation (LTCB.001 Pension Re- Price and Active member Discount)Client :Aviva UK LifeThe LTCB.001 project mainly involves creation of four new variables related to pension products, one part of which is used to evaluate the different pension schemes operating under AVIVA UK Life and the other part is related to providing discount to the customers on the basis of their active membership in the Insurance business. Responsibilities:Participated in call with client and contributed valuables input in initial stage of logical data model.Analyze the business requirement and understanding the functional specification and business logic.Preparing Build estimation for new developments and work instruction.Reviewing technical artifacts.Worked on Informatica code development like mappings, workflows, session mapplets etc.Responsible for Unit testing and regression testing.Peer Review of code and unit test cases and results.Prepare Quality Metrics for the code development during development life cycle.Prepare design, specification and Deployment documents, release notes and implementation plan for new application as well as enhancement and upgrade.Preparing support hand over documents.

Environment : Informatica Power Center 8.1, Oracle 9i, Windows 2000Tools : Informatica 8.1

Environment : Informatica Power Center 8.1, Sybase IQ 12.6, Windows 2000Tools : Informatica 8.1

Environment : Informatica Power Center 8.1, Oracle 9i, Sybase IQ 12.6Tools : Informatica 8.1

I was part of ICICI DWH team, and was Involved in various Data Integration projects.I have worked on almost 25 different projects Involving Informatica 8.1, Sybase IQ 12.6/7, Oracle 9i/10g and Unix AIX.

Data Warehouse developer

Worked as an Assistant Manager in ICICI BANK Ltd from Nov 2007 to till 18th March’2011 in Data Warehouse on different Data Integration projects.

Project # 2Title : NACS (New Application Capturing System) data Integration to DWH.NACS (New Application Capturing System) is the sourcing system for Credit Cards in ICICI Bank. Any new customer applying for a new Credit Card, his application has to get through this system and then as per his credibility and company terms and conditions he is approved or rejected. Post approvals it is decided whether what will be the credit limit of a customer. Hence, it's a very important application of bank which drives its Credit Card Business. In this project first all the Credit Card related demographic details of a customer was captured. It also included application approval, rejection details. This helped in deciding customers credit limits and also in tracking his behavior by looking at his history.Responsibilities:Understanding existing business model and customer requirements.Analyzing the Source and Target Data.Using Source Analyzer to Load data from Flat Files and OLTP Systems into Data WarehouseDeveloping the different types of mappings using Designer Tool.Creating Informatica mappings to build business rules to load data. Most of the transformations were used like the Source qualifier, Aggregators, lookups, Filters & Sequence Generator.Identifying and Observing the Objects like Mapplets and Reusable Transformations.Worked with Tasks, Connections, and Workflows using Workflow Manager.

Project # 3CASA deduplication system is ICICI Bank is an application which helps in obtaining customers multiples relations with bank in context to Current Account and Savings Account holdings. By help of this system it very easy to find out a single customer's various engagements with Bank. In this project basically the Customer Account Relationship defining system was mapped with DWH which helped in getting all the account holdings of a customer and then by help of implementing various businesses rules their relevant linkages was determined. Post DWH the data was fed to the Dedupe system which helped in finding out the multiple account holdings of a customer.Responsibilities:Involved in taking requirements from business users and project planning.Object level Design in the Warehouse by identifying key data points, their dimensions and measures. Identifying Redundancy problems and taking steps to control this problem.Worked extensively with mappings using source qualifier, expressions, filters, lookup and update strategy transformations.Created Informatica mappings to implement business rules to load data. Most of the transformations were used like the Source qualifier, Aggregators, Connected & unconnected lookups, Filters & Sequence Generators.Involved in the development of Informatica mappings and also tuned for better performance.Extensively used Workflow Manager for creation and scheduling various sessions.

IMINT is a group company of ICICI Bank. It basically deals in customer rewarding programs. To reward the ICICI Bank customers on account of their transactions made through Credit card and debit card. Apart from ICICI Bank it has got many more partners like Indian Airlines, Lifestyle, Airtel, Indian Oil Ltd. These big partners make it one of the largest customer rewarding firm, with a customer base of almost 40 Million it has huge database with variety of verticals as per the partners structures. Its basic activity is to add new members as per the increase in the customer base of its partners and reward them as per the transactions made by customers. The system was developed to capture demographic details of the members, their activity (transaction) information and partners' information to build an exhaustive structure in ICICI Bank DWH to suffice the reporting need for higher management, to generate different campaigns for the customers. It has a huge customer base for which always there are different activities taking place.Responsibilities:Defining Source and Target for the dataflow.Developing Required Mappings from source to Target data flowWorking on Informatica tool -Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer.Using Source Analyzer to Load data from Flat Files and OLTP Systems into Data Warehouse.Using warehouse designer to populate data into Staging Area and DWH.Developing Mapplets, reusable transformations to populate the Data into Data warehouse.Developing Informatica mappings for Extraction, validation, Transformation and Loading.Used ETL to load data from Oracle and flat files to Oracle 9i and Sybase database objects.Extensively involved in preparing Unit Test cases and getting the User acceptance test done.

B.E., Electrical

Activities and Societies: NCC,SPORTS,GAMES,TPC

B.E., Electrical Engineering

Have attended professional Training in Administration of Sybase IQ 12.6 from Sybase professionals. Have attended Oracle Certified.

10+2, Science

Activities and Societies: NCC