Resume
Hathiram Bhukya
hathi174@gmail.com
Mobile: +91 8552921123
Professional Summary:
Having 3.4 years of experience in Analysis, Design, and Development, Testing and Implementation of
Client Server Applications and Data warehousing ETL tool Informatica Power Centre 8.6/9.1.
Good Understanding and hands on Data warehousing experience using ETL Tool-Informatica
Power Center (Source Analyzer, Mapping Designer and Transformations).
Extensive experience in extraction, transformation and loading of data directly from different
heterogeneous source systems like flat files, Oracle.
Strong Experience on Workflow Manager Tools - Task Developer, Workflow Designer.
Involved directly and indirectly along with clients in various researches towards development of new
process /methods for the project.
Used mapping parameters and variables.
Involved in the Debugging & Performance Tuning of the Informatic mappings.
Experience working in Migration Projects.
Having Good Understanding of Dimensional Modeling like Star Schema, Snow Flake Schemas.
Strong knowledge in SQL and Data Warehouse Concepts.
Experience working on Tools Like Toad, DB Artisan and Putty.
Prepared and validated Test Cases for the mappings developed and Responsible for doing
Integration System Testing and User Acceptance Testing (UAT).
Hardworking self-starter who can prioritize in order to meet deadlines.
Education Qualification:
Master of Computer Applications (MCA - 2010 pass out) from Jawaharlal Nehru Technological
University (JNTU).
Professional Experience:
Worked as a Systems Engineer for Tata Consultancy Services (TCS) from July 2011 to Nov 2014.
Technical Expertise:
ETL Tool: Informatica Power Center 9.1.0/8..6
Databases & GUI Tools: Oracle 10g/9i SQL plus, MDM Hub Console, Autosys, TOAD, Workload
Automation, Remedy, Service Now, Jira, Quality Centre, VSS, Falcon Queue, DB Artisan, i-Alert and
SQL Server 2004.
Operating Systems: Windows, XP and Unix.
Domain Experience: Life Science and Heath Care (LSHC) and BFS.
Programming language: C,C++.
Hardware: Local Area Network (LAN), Sun Solaris, IBM
Project #1:
Mainframes.
Resume
Project Name: Single Client Index - offshore
Client: Morgan Stanley
Role: Production Support Executive & Developer
Period: August 2013 Nov 2014.
Technologies: Informatica MDM 9.5, Informatica, Unix, Autosys and DB2.
Description: Morgan Stanley is a leading global financial services firm providing a wide range of investment
banking, securities, investment management and wealth management services. The Firm's employees serve
clients worldwide including corporations, governments and individuals from more than 1,200 offices in 43
countries.
Morgan Stanley (NYSE: MS) is an American multinational financial services corporation headquartered in the
Morgan Stanley Building, Midtown Manhattan, New York City. The corporation formed by JP Morgans.
Responsibilities:
I have a role of Production Support Executive
My Roles and Responsibilities are towards:
Monitoring our regular delta cycle process through Autosys job scheduler tool.
Analyzing Autosys job failure reason and need to send notification to business users.
Executing following processes through MDM hub Console (IDD).
1.
2.
3.
4.
5.
Extract Process
Land Process
Staging Process
Load Process
Match and Merge Process
Incident Management
Problem Management
Knowledge Management
Risk Management
Change Management
An application has been used:
Ariba, Smaart, Concur, Ariba Datamart, AP Datamart, CMS (Contract Management System), FAST
(SIP), CAH (Central Approval Hierarchy) and MSMER.
Project # 2:
Project Name: Full Customer TVA
Client: Eli Lilly and Company
Role: ETL Developer
Period: March 2012 July 2013
Resume
Technologies: Informatica 9.1, UNIX, Oracle
Description: The objective of this project is to add the information of Health Care Professionals (HCP) and
Health Care Organizations (HCO) as well as affiliations between them extracted from Brazil and SAP affiliates
along with adhoc request from the On Demand source. Following sources are the up streams for global
customer operational data store as part of this project.
Roles and Responsibilities:
Used Informatica 9.1 Designer to create mapping for Extraction and loading.
Developed and tested the required ETL processes.
Modified the Existing Shall Scripts.
Migrated for mappings Load and Extract Processes from 8.6 to 9.1
Involved in System Testing and End-to-End Testing.
Created the Test Scripts (Test Cases) and Executed in Quality Centre (QC).
Extensively used Mapping parameters and mapping variables.
Analyzed Mappings and various transformations for better performance.
Project # 3:
Project: MDM Program for GCI OFF
Client: Eli Lilly and Company
Role: Informatica Developer
Period: July 2011 Feb 2012
Technologies: Informatica 8.6, UNIX, Oracle
Description: The objective of this project is to create Global Customer Operational data store (GCO) which
will store information of Health Care Professionals (HCP) and Health Care Organizations (HCO) as well as
affiliations between them extracted from global Lilly affiliates. Following applications are the up streams for
global customer operational data store.
Roles& Responsibilities:
Identified and created different source definitions to extract data from input sources and load into
relational tables using Informatica Power Center 8.6.0.
Responsible for Extracting, Transforming and Loading data from Oracle, External Source Flat files
And placing it into data warehouse
Extensively used expression, lookup, and update strategy, Router and other transformations using
Designer Client tool.
Extensively used Mapping parameters and mapping variables.
Created sessions and workflows in order to maintain the integrity of the target database.
Involved in System Testing and End-to-End Testing.
Created the Test Scripts and Executed in Quality Centre (QC).
Responsible for Preparing Test Case Documents on deliverables and involved in testing.
Assisted users at UAT stage.
Resume
