PROFESSIONAL SUMMARY:

• Six years of experience in Development and Operational Support of ETL Jobs, Business Intelligence & Data Ware Housing with Hyperion Intelligence Reporting/ BRIO, Informatica and DM Express.

TECHNICAL SKILLS:

Scripting: Java Scripting, UNIX, Linux

Database: Oracle, DB2, Sybase, Teradata, SQL Server 2008

Tools: /Utilities: Informatica Power Center, Sync Sort DM Express, COGNOS, Hyperion Brio/ Interactive Reporting Studio, SSIS

Other Skills: Business Intelligence and Data ware Housing

PROFESSIONAL EXPERIENCE:

Confidential

Skill Summary: Sync Sort DM Express 7.5.0, Oracle 11g, Linux, winscp, puttyProject Description:

Responsibilities:

• Worked on Onsite Offshore model.
• Worked as a Team Lead and a Tech Lead for the ETL DMX Project team, which has four offshore ETL resources.
• Worked on understanding the architecture and the requirements for the Project.
• Breaking down the requirements to the technical user stories in JIRA.
• Worked on developing the Sync Sort DM Express Jobs and testing them.
• Worked on writing the shell scripts in Linux for executing and parameterizing the DMX Jobs in Linux.
• Conducting code walkthrough for every deliverables after the two weeks sprint and meeting the definition of done.
• Delegating the work to offshore, tracking the tasks, providing the technical guidance to the team and driving the project from Onsite Client’s location.

Confidential

Skill Summary: Teradata, Business Objects Reporting, SQL Server 2008, Sync Sort DM Express, winscp, putty,SSIS.

Responsibilities:

• Worked on creating the SSIS packages (Full Load and Incremental Load)
• Creating and Scheduling Jobs to run the SSIS packages on the SQL Server.
• Worked on supporting the DM Express Supply Chain Legacy Jobs and Teradata BTeq Scripts.
• Creating doclibs for adding jobs to the ZEKE database and creating CRQs for code move or for any other change request.
• Worked on Creating Business Objects reports for EDW Confidential team.

Confidential

Skill Summary: Teradata, SQL Server 2008, Informatica Power Center, Sync Sort DM Express, winscp, putty.

Responsibilities:

• Creating Informatica On Demand CRM replication tasks and Supporting these Jobs. Daily/ Monthly/ Quarterly Jobs monitoring and abend resolving.
• Migrating Legacy data to SFDC (one time load). Loading the MDM objects in SFDC and Replicating the SFDC objects and loading the Reporting EDW database.
• Worked on development activities on Informatica, DM Express and writing Teradata B.Teq Scripts.
• Automation of physician sales dashboard, Physician Targeting process and working on the SFDC Adhoc requests from business.
• Migrating and testing the Informatica mappings/workflows in the Legacy tool to DMX conversion project.
• Creating doclibs for adding jobs to the ZEKE database and creating CRQs for code move or for any other change request.

Confidential

Responsibilities:

• Worked on creating mappings in Informatica for slowly changing dimensions. Prepared B.Teqs in Teradata for change data capture.
• Prepared Unit Test Cases (UTC) and Unit Test Plan (UTP) for testing.
• UAT in QA.
• Involved in the code migration activities from DEV to QA, QA to Prod.

Confidential

Skill Summary:Sybase, Informatica

Responsibilities:

• Analyzing the functional specifications document provided. Involved in system analysis, requirement determination, feasibility study, documenting existing system and entity identification. Preparing the ADS from the FSD. Identifying all the possible test cases.
• Involved in designing, developing and testing Informatica mappings/workflows.
• Preparing Unit Test Cases and Unit Test Plan. Involved in Unit testing and bug fixing during QA testing.
• Involved in the code deployment activities.

Confidential

Skill Summary: Oracle, Informatica

Responsibilities:

• Analyzing the functional specification document provided. Involved in system analysis, requirement determination, feasibility study, documenting existing system and entity identification. Preparing the ADS from the FSD. Identifying all the possible test cases.
• Involved in designing, developing and testing Informatica mappings/workflows and preparing DDLs in Oracle.
• Preparing Unit Test Cases and Unit Test Plan. Involved in Unit testing and bug fixing during QA testing.
• Involved in the code deployment activities.

Confidential

Skill Summary: DB2, Java Scripting, Hyperion BRIO/ Hyperion Intelligence Reporting, Hyperion Work Space

Responsibilities:

• Involved in developing various types of Reports in Hyperion BRIO/ Hyperion Interactive Reporting Studio.
• Designed new screens and coding the dash boards for the reports using Java Script.

Confidential

Skill Summary: DB2, Java Scripting, Unix, Hyperion BRIO/ Hyperion Intelligence Reporting, Hyperion Work Space, Informatica Power Center, Winscp, putty, IBM DB2 Tools and Utilities

Responsibilities:

• Creating mappings in Informatica for loading dimension and fact tables.
• Creating Hyperion Brio/ Hyperion Intelligence Reports as per the requirements.
• Working on the GUI of the reports using Java scripting. Publishing the reports on the Hyperion work space.
• Preparing Unit Test Cases and Unit Test Plan. Involved in Unit testing and bug fixing during QA testing.
• Involved in the code deployment activities.