Project Manager
Resume:
Chittaranjan Thakur
Email: ***********@*****.**.** Cell: +001-262-309-
8044
|Skill / |I have around 10 years of IT and DW/BI experience |
|Experience |in which 8 years as an Informatica Consultant and |
|Summary |2 years as an Ab Initio Consultant. I have also |
| |acquired good Knowledge of Complete Development |
| |Life Cycle of Data Warehouse Projects. |
. Having around 10 years of IT experience in development of Data
warehousing solutions using Informatica 6.1/7.1/8.1/8.6 and Ab Intio
1.14(GDE) 2.14.1 Co-Operating system
. Implemented techniques like slowly changing dimension (type1, type2,
and type3), slowly growing targets, and Simple pass through mapping
with ETL tool Informatica.
. Created complex mappings using Lookup, Joiner, Aggregator, Filter,
Router, Update Strategy and Expression transformations.
. Created and Executed Workflows using Workflow Manager and Workflow
Monitor.
. Used Informatica Workflow Manager & Monitor to create the task,
Schedule the task and Monitor the workflows.
. Developed Ab Initio graph as per business requirement
. Used various Ab Initio components like Lookup, Join, Reformat, Filter
by expression, Rollup, Scan, Redefine format, Merge, Gather,
Replicate, Sort etc.
. Optimized the ETL process using Performance Tuning Methods.
. Involved in unit testing, integrated testing and Regression testing of
project.
. Involved in designing of HLD(High level design), SRS(software
requirement specification)
and Mapping document as per business requirement.
. Interacted directly with the client to know the business requirement
and executed the same in project.
. Knowledge of Complete Development Life Cycle of Data Warehouse
Project.
. Participated in system design and data modeling( Logical and Physical)
. Knowledge of different Schemas (Star and Snow Flake) to fit reporting,
query and business analysis requirements
. Have good experience on RDBMS Oracle 9i/10g, Teradata V2R5 and MS Sql
Server.
. Have good knowledge in SQL, PL/SQL
. Worked with Version Control tools IBM Rational Suite- Clear Case /
Clear Quest, Visual Source safe.
. Exposure to other tools : Control-M Scheduler, Defect logging tools -
Test Director & Remedy.
. Project management tools Integrated Project Management System (IPMS)
. Handled team size of 8 members.
. Interacting with the offshore and Onsite management.
. Resource Management (Selection of New Project Personnel, if required).
. Managing, coordinating, planning and executing project.
. Directly reported to client Manager.
. Overseas (UK/US) Client Site exposure - worked at the Client site on
deputation to the UK (around 3 years) and in USA for 2 year 9 months.
EDUCATION: Bachelor of Engineering in Computer Science
|Technology Experience |Informatica 6.1/7.1/8.1/8.6, Ab Initio |
| |1.14(GDE) 2.14.1 Co-Operating system, Teradata|
| |V2R5, Oracle 9i/10g,MS sql server, Control-M, |
| |Erwin, Business Object, Oracle warehouse |
| |Builder(OWB) |
|OS |Windows NT,/XP/1998,Unix |
|Hardware |Intel Pentium |
|Tools |Informatica 6.1/7.1/8.1/8.6, Ab Initio |
| |Control-M,Erwin, Rational clearcase, Mercury |
| |Test director, BO,Remedy |
|Domain Experience |Sales and Marketing, Services, Manufacturing |
| |,Card Payment, Finance,Healthcare, Customer |
| |experience |
|RDBMS |Oracle 9i/10g, SQL, Pl/Sql, Microsoft SQL |
| |Server, Teradata V2R5 |
Experience Profile - Key Projects
|Project: National Medicare Finance|Duration: Aug 2010 to Till date |
|Department of Kaiser | |
|Customer name: Kaiser Permanente (USA) |
|Project Description: |
|Kaiser Permanente (KP) is America's largest nonprofits health |
|management organization serving over 8 million members throughout |
|United States. The IT division of the company had a business need to |
|extract data from various OLTP systems and cleanse, conform and |
|deliver/load the data into target systems to provide data required |
|for regulatory authorities. As a part of these requirements various |
|ETL systems have been developed and delivered that aligns to the |
|strategic, tactical and federal compliance needs of the company. |
| |
|Kaiser is also responsible for the execution of changes in Medicare |
|program procured by the US government to provide senior citizens and |
|individuals with disabilities with a prescription drug benefit. |
|Beginning with the 2006 contract year several new features will take |
|effect and more choices and benefits will be available to members |
|enrolled in the Medicare+Choice (M+C) program. |
|This requires transformation of Kaiser Member data from its various |
|Source Systems according to defined business rules, and loading them |
|in target systems. After the data loading process all Operational and|
|Analytical Reports are sent to NMF (the National Medicare Finance |
|Department of Kaiser).The subset of the Medicare project in which the|
|ETL Development team worked consists of different extracts on NMF, |
|thus called NMF Project. These ETL extracts have been developed in |
|Informatica. |
| |
|Tools: Informatica 8.6.1 |
|Software:, SQL, Remedy |
|RDBMS :, Oracle 9i/10g, Teradata |
|Responsibility: ETL Lead |
|Role Description: |
|Gathering requirements with business and implementing as per business|
|requirement. |
|Attending daily scheduled Conference calls |
|Creating HLD(High level design), TDD(Technical Design docs)and |
|Mapping document as per business requirement. |
|Implemented techniques like slowly changing dimension (type1, type2, |
|and type3), slowly growing targets, and Simple pass through mapping |
|with ETL tool Informatica. |
|Created various Transformations like Lookup, Joiner, Aggregate, |
|Expression, Filter, Router, and Update Strategy. |
|Participated in system design and data modeling( Logical and |
|Physical) |
|Preparing daily/weekly status report. |
|Daily communication via mail, chat, teleconferences. |
|Internal Quality Auditing of the deliverables before delivery. |
|Assigning the work from functional & technical perspectives. |
|Interacting with the offshore and Onsite management. |
|Resource Management (Selection of New Project Personnel, if |
|required). |
|Managing, coordinating, planning and executing project. |
|Handling team size of 5 members |
|Project: PA Reporting |Duration: Nov 2009 to July 2010 |
|Customer name: APS Healthcare (USA) |
|Project Description: |
|APS works collaboratively with Medicaid Agencies, state and local |
|governments, health plans, employers and labor trust groups to design|
|and deliver services and solutions to meet today's healthcare |
|challenges. Tailored to address the needs and challenges unique to |
|each population, APS healthcare services include disease management |
|and care coordination, clinical quality and utilization review, and |
|behavioral health. By connecting all the players in the healthcare |
|equation - participants, practitioners and payors - APS delivers |
|person-centered, provider supportive services that optimize |
|expenditures and improve health |
| |
|Tools: Informatica 8.6, MS Sql Server |
|Software: SQL,MS SQL SERVER |
|Responsibility: ETL Lead |
|Role Description: |
|Reviewing requirements with business and both onsite/offshore |
|management team. |
|Creating ETL design docs and Mapping document as per business |
|requirement. |
|Created various Transformations like Lookup, Joiner, Aggregate, |
|Expression, Filter, Router, and Update Strategy. |
|Costing and controlling the quality of product/service. |
|Assigning the work from functional & technical perspectives. |
|Interacting with the offshore and Onsite management. |
|Resource Management (Selection of New Project Personnel, if |
|required). |
|Managing, coordinating, planning and executing project. |
|Ensuring proper utilization of human resources. |
|Handling team size of 7 members |
|Project: Clearing and settlement |Duration: Nov 2007 to Nov2009 |
|Customer name: Visa Europe (UK) |
|Project Description: |
|The Clearing and settlement [C&S] is essential for clearing and |
|settlement between Visa members. Each eligible single message |
|transaction processed by the Switch has a clearing record in |
|Universal Message Format [UMF] created containing transaction and |
|member information. These records are processed into UMF on the |
|DFM-C server and fed to the C&S application on a regular basis via MQ|
|Series. The C&S application will take the UMF records processed by |
|the VDPS Switch and generate clearing and settlement information. The|
|C&S application also feeds data to applications that generate reports|
|and raw data for single message endpoints. Messages are sent to C&S |
|for every transaction (including financial, network, file |
|maintenance, and rejects) involving either a Single Acquirer or |
|Single Issuer, or for Dual to Dual ATM Balance Inquiries and |
|Declines. |
| |
|Tools: Informatica 7.1, Unix and Ctree |
|Software: SQL, Rational Clearcase and Quest |
|Responsibility: ETL Lead |
|Role Description: |
|Developed Informatica mappings and workflows to implement the logic |
|of Clearing and settlement [C&S] application. |
|Participating in logical and physical design to build Clearing and |
|settlement architecture. |
|Involved in Unit testing and Integrated testing for the Clearing and |
|settlement Applications |
|Created and executed the workflow in staging environment for testing |
|purpose. |
|Interacted with BA(Business Analyst ) to know the business logic for |
|C&S application and Implemented the same as per business requirement |
|Project: Visa distributing processing |Duration: Dec 2006 to Oct |
|service |2007 |
|Customer Name: Visa Europe (UK) |
|Project Description: |
|VDPS is a core part of Visa. It is application for Authorization of |
|card payment transaction between Visa members that is acquirer and |
|Issuer. It contains two major part known as switch and DFM (data feed|
|manager).DFM is mainly Involve in transforms & loads data from |
|upstream system (e.g. customer online repository) and feeds |
|transaction data to downstream systems such as FTL (Formatted |
|Transaction Logs), RSI (Real-Time Settlement Interface) and WTF |
|(Warehouse Transaction files).Switch is the process which authorizes |
|the card transaction and send information to Visa members and to |
|downstream system to monitor the various transactions. |
| |
|Tools: Ab Initio, Unix and C-tree |
|Responsibility: ETL Lead |
| |
|Role Description: |
|Developed Ab Initio graph as per business requirement |
|Used various components like Lookup, Join, Reformat, Filter by |
|expression, Rollup, Scan etc. |
|Extracts data from the journals file coming from VDPS switch. |
|Done the Unit testing of Ab Initio graph which has been developed by |
|me to implement the Change Request (CR) as per business requirement. |
|Interacted with BA (Business Analyst) to know the business |
|requirement for DFM (Data feed manager) downstream application and |
|developed the code as per Enhancement Request(ER). |
|Involved in defect fixing of system testing and Regression testing. |
|Involved in 2nd level production support to resolve the severity 1 |
|issue. |
|Project: Amex Data Warehouse 2 |Duration : July 2006 to Dec 2006|
|(ADW2) | |
|Customer name: American Stock Exchange NY (US) |
|Project Description: |
|American Stock Exchange (AMEX) has embarked on an initiative under the|
|name of "Amex Data Warehouse 2" (ADW2) to implement a Data warehouse |
|for its business units at Enterprise level in a phased manner. The |
|purpose of the ADW2 project is to replace the existing Amex Data |
|Warehouse (ADW) presently running in AMEX with a more integrated |
|Enterprise level data warehouse for the senior managers of AMEX. This |
|data warehouse supports OLAP applications used to generate business |
|reports. |
|Tools: Informatica 8.1, Control-M, Unix and Teradata |
|Responsibility: Sr. ETL Developer |
| |
|Role Description: |
|Created and executed the Informatica Mapping as per CRS (Customer |
|requirement specification) |
|Implemented slowly changing dimensions (SCD) Type2.Worked with Slowly |
|growing Target (SGT), and Simple pass through (SPT). |
|Created and Executed the Mapping for FACT Loading from various |
|Dimension Tables |
|Preparation of Technical Designs for Informatica mappings. |
|Developing the Mapping components |
|Created various Transformations like Lookup, Joiner, Aggregate, |
|Expression, Filter, Router, and Update Strategy. |
|Used Informatica Workflow Manager & Monitor to Create, Schedule, |
|Monitor workflows to test the mapping in development environment |
|Involved in Logical and physical Data Modeling for Data Warehouse |
|Created BTEQ, MLOAD and FLOAD scripts for loading and processing input|
|data |
|Experience on using SQL Query Assistant (Queryman) |
|Created and executed Micros as per business requirement. |
|Project: Center of Excellence | Duration : Oct 2005 to |
| |Jun 2006 |
|Customer name: Dell Corporation, USA |
|Project Description: |
|Center of Excellence (COE) is a group, which is responsible to do the|
|root cause analysis and fix the issue in Finance, Service, Customer |
|Experience, Manufacturing and Telecom domain raised by our Austin |
|Partner and Business user. Apart from that COE are also responsible |
|to maintain the Oracle data marts which have been created for DELL |
|Premier Customer |
|Tools: Informatica, Control-M and D3 |
|Software: Oracle, Teradata and SQL |
|Responsibility: Sr. ETL Developer |
|Role Description: |
|Designed and executed the mapping as per CRS (Customer requirement |
|specification) |
|Identified and eliminated the bug and Involved in root cause analysis|
|to fix the issue, which has been raised by Austin Partner and |
|Business user. |
|Involve in Table space Reorganizations to Maintain the Oracle Data |
|marts. |
|Analyzing the root cause to fix the issue. |
|Testing of sessions in development environment and move it to in |
|production environment. |
|Involve in Fix on fail Process. |
|Executing and monitoring of the sessions in development and testing |
|environment. |
|Project: Missing Wrong Damaged |Duration: Jan 2005 to Sep 2005 |
|Returned (MWDR) | |
|Customer name: Dell Corporation, USA |
|Project Description: |
|MWDR is the measurement of issues that occur within 60 days of |
|shipment that are caused by: |
|a) The customer not receiving their complete order from Dell. |
|b) The customer receiving their order but the parts received is wrong|
|or perceived wrong by the customer |
|c) The system or system components are damaged. |
| |
|The system is to capture the Cost Impact Metrics vs Customer |
|Experience. The analysis report provides feedback to COE on how the|
|Company is performing against the International Business Planning |
|Strategic Initiatives. The data provides process-level details to do|
|root cause analysis and their metric misses to drive process |
|improvements. |
| |
|Tools: Ab Initio and Control-M |
|Software: Oracle, Teradata and SQL |
|Responsibility: ETL Developer |
| |
|Role Description: |
|Developed Ab Initio graphs as per business requirement. |
|Used various components like Join, Filter by expression, rollup, |
|lookup, sort etc. |
|Developed graphs to Implements business requirement. |
|Developed Teradata macros to implement business requirement. |
|Created and executed the graphs in development environment. |
|Migration from Dev to Test, Production. |
|Project: Business Intelligence |Duration : Feb 2004 to Dec 2004|
|Solutions | |
|Customer name: Arrow Electronics, USA |
|Project Description: |
|Arrow Electronics is a leading manufacturer of Electronics |
|Equipments. The Company is looking for business enhancement and |
|competitive edge using information technology to make better business|
|decision. The Data warehouse developed using Informatica 7.1 |
|generates reports of the business situations. This helps the client |
|to do analysis and to take strategic business decision. |
|The Data Warehouse is meant for executives, senior managers and |
|business analysts with access to accurate, consolidated information |
|for trend identification, forecasting and competitive analysis and |
|targeted market research. This data warehouse supports OLAP |
|applications used to generate business reports. |
| |
|Tool: Informatica 7.1 |
|Software: SQL, Oracle 9i |
|Responsibility: ETL Developer |
|Role Description: |
|Designed the ETL processes using Informatica to load data from File |
|source and Oracle into the target Oracle 9i database. |
|Developed mappings/sessions using Informatica power center for data |
|loading. Developed mapping to load the data in slowly changing |
|dimensions. |
|Created various Transformations like Lookup, Joiner, Aggregate, |
|Expression, Filter, Router, and Update Strategy. |
|Used Informatica Workflow Manager & Monitor to Create, Schedule, |
|Monitor workflows in case of process failures. |
|Project: Sales Analysis System |Duration: March 2003 to Jan 2004 |
|Customer name: Pocino Foods Company, USA |
|Project Description: |
| |
|Pocino Foods Company is one of the supplier of Consumable Meat |
|Products, and leading distributor of specialty food products. This |
|Project involved in creating a Data Warehouse for Sales Analysis |
|System. Data from ODS was Extracted, Transformed and loaded into |
|Data Warehouse Using Informatica. |
| |
|Tool: Informatica 6.1 |
|Software: SQL, Oracle 9i. |
|Responsibility: ETL Developer |
|Role Description: |
|Developed mappings/sessions using Informatica power center for data |
|loading. Developed mapping to load the data in slowly changing |
|dimension. |
|Created various Transformations like Lookup, Joiner, Aggregate, |
|Expression, Filter, Router, and Update Strategy. |
|Used Informatica Workflow Manager & Monitor to Create, Schedule, |
|Monitor workflows in case of process failures. |
|Involved in Unit testing, Regression testing. |
|Done optimization of mapping |
|Project: Profit and Prediction |Duration: Sep 2002 to Feb |
|Management System |2003 |
|Customer name: Bank of Dubai |
|Project Description: |
| |
|This Project was developed for Bank of Dubai, to provide Enterprise |
|Reports for their internal and external use and to support queries |
|for making intelligent banking decisions based on data available over|
|a period of time. Data from ODS was Extracted, Transformed and loaded|
|into Data Warehouse Using Informatica 6.1. |
| |
|Tool: Informatica 6.1 |
|Software: SQL, Oracle 8i. |
|Responsibility: ETL Developer |
|Role Description: |
|Designed the ETL processes using Informatica 6.1 to load data from |
|file source into the staging area. |
|Developed mappings using Informatica for data loading. Developed |
|mapping to load the data in staging area tables. |
Training / Continuing Education Summary
|Program or Course |Coverage |Dates |
|Lean Six Sigma |Lean Six Sigma Listening to the | |
|Listening to the Voice|Voice of Customer | |
|of Customer | |Jan 2012 |
| | | |
|Certificate in |Healthcare and Life sciences |March 2011|
|Healthcare and Life | | |
|sciences L1 | | |
|Rational clearcase and|Rational clearcase and |Jan 2008 |
|clearquest |clearquest overview | |
|Business Intelligence |Business Intelligence for Decision |Oct 2007 |
|for Decision support |support | |
|BIDS | | |
|Mercury test director |Mercury test director overview |Jan 2007 |
|Ab Initio |GDE, Graphs, Components, Sandbox, | |
| |EME, Co-operating system Schedule | |
| |of Draft, Creating and executing of|Jan 2005 |
| |Draft | |
|Control-M |Scheduling Details |Jan 2005 |
|Informatica |Informatica setup, mappings, case |Sept 2002 |
| |studies, Designer, Workflow manager| |
| |and Monitor | |
|Oracle |Oracle internals, SQL,PL/SQL |Sept 2002 |
Contact this candidate