JOB OBJECTIVE:

To succeed in an environment of growth and excellence and earn a job which provides me job Satisfaction and self development and help me achieve personal as well as organization goals.

SUMMARY:

• Have a total experience of 5.5 years in Business Intelligence and Data Warehousing as an ETL Designer and Developer, Data Modeler.
• Senior Consultant at Confidential and with a total experience of almost 2 years with Onsite experience and direct client communication.
• Currently working with Confidential in BI assignment as onshore coordinator.
• Systems Engineer at Confidential with a total experience of 3 years as an associate with leading Insurance, Healthcare sector clients.
• Was responsible for requirement gathering, Designing and development.
• Have excellent exposure in ODI (11g), Informatica Powercenter (8.1, 8.6, 9.1 and 9.5) , to in corporate various ETL Logic, Transformation, Workflow and Session properties. Also worked in Tableau to generate reports from the custom data warehouse.
• Have worked in Confidential India for Data migration and Tax reporting project. Functioned as the designer and developer to achieve the objective.
• Functioned as the offshore lead and responsible for onsite offshore co - ordination.
• Have used OBIA as the comprehensive business platform Accounts Payable (AP), Procurement and Spend (PO) Analytics, General Ledger (GL) and Fixed Assets (FA).
• Have excellent exposure Microsoft SQL Server 2008, Oracle (11g), Confidential Big Query to develop various scripts for tables, views and Store Procedures.
• Have good exposure in both Windows and UNIX .
• Appreciated by client and internally for delivering quality product.

TECHNICAL SKILLS:

• Database
• MS SQL Server 2008
• Oracle 10g,11g
• Confidential Big Query
• ETL Tool
• Informatica Powercenter (8.1, 8.6, 9.1, 9.5)
• Oracle Data Integrator (11g)
• Windows
• Unix
• Applications
• OBIA 11.1..1.8.1

PROFESSIONAL EXPERIENCE:

Confidential

Onshore coordinator, Designer

Responsibilities:

• Report requirement Gathering
• Determine the strategy to move the HCM data in Oracle Cloud
• Determine suitable BI tool for reporting by comparative analysis of various reporting tool available in market
• Providing demo to client by constant research in data load
• Design ETL Load strategy
• Take key role in presentation with client.
• Integrate and automate the whole system.

Solution Tools and Environment:

• Visio 2013
• Microsoft Excel 2013
• Oracle Data Integration 11g
• BIACM
• OBIEE 11g

Confidential

Onshore coordinator, Designer, Developer

Responsibilities:

• Building System Architectures, Data Model, Functional document, and Design document.
• Designing and determining loading strategy as per the requirement.
• Developing ETL code as per the requirement.
• Take key role in presentation with client.
• Unit testing and Integration Testing.
• Performance Tuning to reduce the execution time.
• Integrate and automate the whole system.

Solution Tools and Environment:

• Informatica 9.1
• Oracle 11g
• Unix

Confidential

Data Modeller, Designer, Developer

Responsibilities:

• Building System Architectures, Data Model, Functional document, and Design document.
• Installation of the SQL server ODI and OBIEE
• Developing ETL code as per the requirement.
• Take key role in presentation with client.
• Unit testing and Integration Testing.
• Performance Tuning to reduce the execution time.
• Integrate and automate the whole system.

Solution Tools and Environment:

• Tableau
• Confidential Big Query
• Oracle 11g
• Confidential Cloud Environment

Confidential

Data Modeller, Designer, Developer

Responsibilities:

• Building System Architectures, Data Model, Functional document, and Design document.
• Installation of the SQL server ODI and OBIEE
• Developing ETL code as per the requirement.
• Take key role in presentation with client.
• Unit testing and Integration Testing.
• Performance Tuning to reduce the execution time.
• Integrate and automate the whole system.

Solution Tools and Environment:

• ODI 11g
• OBIEE 11g
• Oracle 11g
• Unix

Confidential

Data modeller, Designer, Developer

Responsibilities:

• Understand requirement from client by written and direct communication
• Building System Architectures, Data Model, Functional document, and Design document.
• Installation of the SQL server ODI and OBIEE
• Developing ETL code as per the requirement.
• Take key role in presentation with client .
• Unit testing and Integration Testing .
• Performance Tuning to reduce the execution time .
• Integrate and Automate the whole system .

Solution Tools and Environment:

• ODI 11g
• OBIEE 11g
• Microsoft SQL Server 2008
• Windows 7

Confidential

Developer

Responsibilities:

• Understand requirement from Business Requirement Document and built design document by analyzing the data.
• Developed Informatica code to store data and accommodate changes in the database from flat files and databases..
• Developed Stored Procedure to store data and accommodate changes in the database.
• Developed needful UNIX script to comply with the Powercenter code.
• Reduce some job execution time by performance tuning.
• Unit Tested all the code and done integration testing.

Solution Environment:

• Informatica Powercenter 8.1,9.1
• Oracle 11g
• Aginity (Netezza)

Confidential

Developer

Responsibilities:

• Developed Informatica code to store data and accommodate changes in the database from flat files and databases..
• Developed needful UNIX script to comply with the Powercenter code.
• Introduced to Admin console and other Administrative activities through Repository manager and Workflow manager.
• Unit Tested all the code and done integration testing.

Solution Environment:

• Informatica Powercenter 8.6
• Oracle 10g
• UNIX

Confidential

Developer

Responsibilities:

• Developed informatica code for creating flat files for derivatives from the data mart with all the ETL Logic and Transformation required by the business and provided to Blackrock.
• Developed Informatica code for creating flat files for derivatives from the data mart with all the ETL Logic and Transformation required by the business and sending them back to Confidential .
• Developed MS SQL Server scripts for creating some Store Procedures to modify some records having comma separated values into different records having the value after each comma.
• Developed code for sending warning and error messages to the business for the records.
• Gathered the requirement and data analyze it to provide solutions.
• Developed Mainframe (Zeke) jobs and tasks to schedule all the Informatica workflows.
• Unit Tested all the code and done integration testing.
• Resolved all the defects and support given while UAT testing by the testers.

Solution Environment:

• Informatica Powercenter (8.1)
• MS SQL Server 2008
• Microsoft Windows
• Quality Center (QC)