Manish Kumar

Manish Kumar
Cognizant Technology Solutions
Emailid: manish2dw@gmail.com
Mob:+91-7795686187
_____________________________________________________________________

Professional Summary:

 Having over 6+ years of IT experience in Data warehousing projects with diverse domains such as Banking, Retail, Insurance and Healthcare with responsibilities of Requirement Analysis, Application Development, Migration, Performance Improvement, and Project Planning/Delivery/Implementation.
 Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
 Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.
 Strong experience in Data Warehousing and ETL using Informatica Power Center 8.6, 9x & IDQ.
 Had experience in data modeling using Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
 Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
 Had knowledge on Kimball/Inman methodologies.
 Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
 Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center 8.x, 9x.
 Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.
 Experience in database programming in PL/SQL (Stored Procedures, Triggers and Packages).
 Well versed in UNIX shell scripting.
 Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the.



Technical skills:

Data warehousing Tools : Informatica Power Center 8.6,9.5, 9.6.1 & IDQ
Databases : Oracle 10g, 11g, Teradata, SQL server
Development Tools : SQL Developer, Toad
Languages : SQL, Unix Shell Scripting
Operating System : UNIX, Windows

Professional Experience:

 Cognizant Technology Solutions, Bangalore from 28 April 2014 to till date.
 Hewlett Packard India Pvt. Ltd. Bangalore from June 2010 to 26 April 2014.

Achievements:

 Received recognition for my performance tuning work done to reduce the total run time for a Dim table update process from 2 hrs. to 30 min.
 Received recognition from my project manager for my quality, on time deliverables and handling complex projects.



Project #1

Title : DWBI McAfee Migration reporting project
Client : McAfee
Role : ETL Developer
Team Size : 4
Duration : Sep2016-till date.
Environment : Informatica Power Center 9.6.1, SQL Server, WinSCP
Organization : Cognizant Technology Solutions.

Description:
The purpose of the project are extracting data based on ‘epo_MonthlyExtract’ and weekly ‘epo_WeeklyExtract’ Also Filter records where Customer Name ‘McAfee%’ or ‘ResCare’ and finally Load the table. Decision was made to generate this reports from OBI based on the reporting tables. For the ‘VSE to ENS migration analysis’ spreadsheet, the raw data, which are currently extracted from Database Darshana.Generated report has published to the User.
Responsibilities:
• Holds good experience in Managing for ETL process which uses for extracting the data from different sources and transforming the data to customer requirement and load the data to different targets which helps the client to manipulate various Risk measurements.
• Gather the functional and Technical requirement.
• Test the mappings and check the quality of the deliverables.
• Extensively working in the performance tuning of the testing, ETL Procedures and processes.
• Assisted the ETL department during Data Mapping, Data Integration, Process Mapping and Process Integration.
• We are extracting the reports based on Target load table.
• Generating the report based on OBI Dashboard.
• Also publishing the report based on the ETL load to the customer.

Project #2
Title : ITSP-PHASE-1
Client : Johnson & Johnson
Role : Senior ETL Developer
Team Size : 4
Duration : Feb2016 - Aug2016
Environment : Informatica9.6.1, Oracle, UNIX
Organization : Cognizant Technology Solutions.

Description:
Johnson & Johnson Group is an integrated Life science product group, catering mainly for health and beauty product. Like a daily upload of running job related work to portal. We are extracting file from the MBOX server and first time loading the records to the four Staging table PROJECT, ROADMAP, TEAMMEMBER and ALLIGNMEMNT. Along with that we are also maintaining the HISTORY. History Load is nothing but insert and Update the Record. Load will be happened along with the stage loading. We are checking the file in the server by using Unix scripting and after load we are sending the file in to the Archive folder. After completion of Stage and History we are starting the Transaction load, here we are Inserting updating and rejecting the records based on the PROJ table records. Based on the Project key we are updating or inserting the records. It is the Daily based Loading. After that we are loading the Downstream Table, it is nothing but the ORACLE Table load. Based on first four File Proj, Team member, Roadmap and Alignments we are loading the data joining with the downstream table, here we also perform the Insert, update, rejects and Duplicate records count. After Deployment we also monitor and validation of QA and PRODUCTION data, also giving support to the production environment.
Responsibilities:
• Analyzing the business requirements.
• Understanding the underlying functionality of the systems.
• Day to day interaction with Business users.
• Develop and deploy ETL job workflow with reliable error/exception handling and rollback frameworks.
• Preparation of Design documents and unit test scripts.
• Adherence to coding standards by doing self-code review.
• Performs debugging and tuning of code for optimization.
• Preparing documents related to code migration.
• Migrating the code to higher environments through Harvest control tool.
• Given session to my team members about the developed functionalities.


Project #3
Title : Corporate Operational Risk Ecosystem (CORE)
Client : JPMorgan & Chase
Role : Senior ETL Developer
Team Size : 7
Duration : Oct 2014-Jan2016
Environment : Informatica9.6.1, Oracle, UNIX
Organization : Cognizant Technology Solutions pvt ltd.

Description:
JPMorgan Chase & Co. is a multinational banking and financial services. Here we are rescheduling Autosys job to extract data from RDI system using shell scripting and Web Service interface. If any mandatory attributes are missing in the feed then we reject the record and write into the error table. We also maintain the integrity and refresh the record using Ref data records. We also implement SCD Type1 like if record exists, there are any change records then we are using MD5 () and update if any changes. If record doesn’t exist then we inter the record into the table.


Responsibilities:
• Analyzing the business requirements.
• Extracting the feeds from the Web Services.
• Developing and running Informatica ETL mappings to load the data first time flat file to CORE staging area then to CORE DIM area and then finally into CORE application tables.
• Implementing suggested business logics to meet business requirements.
• Sending email-notification success, failure through the Informatica process, after success load.
• Validating the loaded data in Data warehouse tables.
• Performing self-code review to ensure code quality.
• Creating Design documents and Unit test cases.
• Maintaining alter/auditing for the loaded records in the application table.

Project #4
Title : Orbitz Teradata Migration Project for Phase-1&2
Client : Orbitz
Role : ETL Developer
Team Size : 7
Duration : May2013-Sept2014.
Environment : Informatica8.6, 9x Oracle, Unix
Organization : Cognizant Technology Solutions.
Description:
We were migrating all the Greenplum objects in to the Database Teradata. Informatica Used as middleware tool. All the jobs have been distributed and created by the help of Sprint planning sheet. We were updating all jobs based on individual Jira no. also raising defects and request with help of Jira number. For that we are using Service now either it would be a new request for the any objects like view table etc. We also deployed the objects based on RFC request.
Responsibilities:
• Loading non-retired tables in greenplum.
• Creating reusable transformations wherever applicable, to load target tables.
• Troubleshooting the mapping/session/workflows for data rectification errors.
• Validating the loaded target table.
• Ensuring coding standards by doing self-review of code.
• Creating design documents and Unit test cases for the developed business logics.
• Taking knowledge transition session on developed logics to teammates.
Project #5
Title : MSS unbundling [Caremark US]
Role : ETL Developer
Team Size : 10
Duration : Jan 2013 –April 2013
Environment : Informatica 8.6, Oracle, UNIX
Organization : Hewlett Packard

Description:
The Member Savings Services (MSS) system was initially developed to enhance the Hercules Initiative process. The clients and associated targeting parameters are entered by Clinical Fulfillment in HCE. The parameters are then passed from Hercules to EDW1 where the MSS application resides. MSS loads the parameter file and then begins the process of pulling the associated member claims that were identified in the Hercules setup. Once the claims are loaded into MSS, the process identifies opportunities for savings with drug changes and channel changes. The opportunities are then processed thru TAD/Non-TAD for drug changes based on the current drug classification and Best Flight will determine the best Alternative drug and Channel.
Responsibilities:
Translate business requirement into Informatica mappings/workflows
Developed mapping and workflow strategy
Migrated development mappings to higher environment
Performs debugging and tuning of code for optimization.
Performing self-code review to ensure code quality.
Supplied mentoring on mapping design, workflow logic and scheduling
Performed unit and integration testing

Project #6
Title : Caremark Migration project
Role : ETL Developer
Client : Caremark (U.S)
Team Size : 10
Duration : june2012 to Dec2012
Environment : Informatica8.6, Oracle, UNIX
Organization : Hewlett Packard


Description:
Like a daily upload of running job related work to portal. First we run the Unix script then we check the monitor runs if errors are caught then how we rectify it. Checking the infa/unfix objects with the data stamp etc.
Responsibilities:
• Analyzing Business requirements.
• Translating business requirements in to Informatica mappings/workflows.
• Performed Sanity checks in Informatica Workflow Manager for path names and in scripts for email ids.
• Develop and implement the code as per requirement.
• Unit testing the designed code.
• Migrated development mappings to higher environment.
• Performs debugging and tuning of code for optimization.
• Day to day interaction with users

Project #7
Client : Aetna Smart Edit Claims and Non-Claims
Team Size : 7
Role : ETL Developer
Duration : Feb 2012- June 2012
Environment : Informatica8.6, Oracle, Unix
Organization : Hewlett Packard

Description:
Aetna uses Smart Edit technology to support many of their clinical edits. Smart Editing uses medical claim data, lab data and prescriber data to satisfy clinical edit criteria as the pharmacy claim is being processed. If smart edit criteria are met for a given claim, then it improves efficiency and reduces hassle for the providers because they would not be required to call or fax the Precertification Unit for approval of a drug.
Responsibilities:
• Translate business requirement in to Informatica mappings/workflows
• Developed mapping and workflow strategy
• Preparation of Design documents and unit test scripts.
• Migrated development mappings to production environment
• Supplied mentoring on mapping design, workflow logic and scheduling
• Performed unit and integration testing
• Adherence to coding standards by doing self-code review.
• Performs debugging and tuning of code for optimization.

Project #8
Title : Smart Edit (Phase-I&II)
Client : Caremark (U.S)
Role : ETL Developer
Team Size : 7
Duration : Nov2010- Dec2011
Environment : Informatica8.6, Oracle, Unix
Organization : Hewlett Packard

Description:
This he requirement is to maintain transition fill information in the data warehouse as supplied by RxCLAIM claims feed. There is also a need to store TF letter print date and mailed letter tag in the data warehouse for the future reporting needs. Receive data file sent by the clinical fulfillment and store print date and letter tag of the claims for which letters were sent in the data warehouse.




Responsibilities:

• Analyzing Business requirements.
• Translating business requirements in to Informatica mappings/workflows.
• Develop and implement the code as per business requirement.
• Troubleshooting the mapping/session/workflows for data rectification errors.
• Validating the loaded data.
• Unit testing the designed code.
• Migrated development mappings to higher environment
• Supplied mentoring on mapping design, workflow logic and scheduling.
• Performs debugging and tuning of code for optimization.

Education Qualification:

• MCA in Computer Application (2009) from SJCE (VTU, University) with 71% marks.


Personal Profile:
• Nationality : Indian
• Date of Birth :28-feb-1984
• Language Proficiency : English, Hindi
• Passport No : G9060423