SUMMARY

• Technical Lead with 9+ years of Data warehousing experience in various phases of Data modeling, Design, Development and Testing.
• 5+ years US client interaction and 2+ years of onsite work experience at Confidential, Zurich NA & Confidential
• 7+ years on Informatica and other ETL and BI tools and over 6+ years of database experience.
• Experienced in handling larger team.
• Experienced in Salesforce Reporting to analyze the business trends.
• Worked in 12+ projects consisting of Data Integration, Data migration, Development & BI projects.
• Responsible for Requirement Gathering & Analysis, High Level and Low Level Designs, Source - to-Target Mapping Development, Unit Testing, UAT and Implementation of various Data Warehousing projects.
• Worked on various assignments with Confidential
• Involved in Installation and configuration of MicroStrategy and created various schema objects using MicroStrategy Desktop & Web and generated reports in MicroStrategy using Templates, Filters, Prompts, Consolidations and Custom Groups.
• Integration of various heterogeneous source and target systems like JSON files, XML files, Oracle, Teradata, ExaSol, SQL Server, SAP BW, Netezza, DB2, CSV and Text files for data load using Power Center Mappings.
• Developed Re-usable components for efficiency & worked with parameterization in Informatica mappings for better performance
• Implemented Error Handling Routines and notifications following the Informatica Best Practices and also involved in Performance Tuning of various ETLs
• Familiarized with MongoDB and JSON files for data extraction.
• Experienced in creating Data flow diagrams and architecting ETL designs according to the data model and business requirements provided.
• Work along-side Business Analysts & DBAs and perform data profiling and validation on the ErWin data model.
• Implementation of Slowly Changing Dimensions (Type I and Type II)
• Expanding my learning to Informatica Cloud, IDQ, Big data tools (HBase, Pig, Hive)
• Good understanding of Conceptual, Logical and Physical data models.
• Experience in coping with stress and able to multitask effectively and can quickly learn and adapt to new technologies.

TECHNICAL SKILLS

ETL & BI Tools: Informatica Power Center 9.5.1, Informatica Power Center Express version: 9.5.1, MicroStrategy 9.3, Business Objects XI R2, Cognos 8, DAC, IDQ, Datastage 8.1

Databases: Mongo DB, Teradata, Oracle 11g, ExaSol 4.0, SQL Server 2000, SAP BW - SAP Logon720, Oracle Application Express 11g, Netezza, DB2

Query & Programing Languages: SQL, PL/SQL, Core Java, JSP, Python, HTML, C, C++, Shell Scripting

Versioning & Scheduling Tools: SVN; Informatica Scheduler, UC4, Autosys

Ticket Management Tool: JIRA, Clearquest

Data Modeling Tools / Methodologies/Concepts: ERwin Data Modeler, Entity Relationship and Dimensional Modeling

PROFESSIONAL EXPERIENCE

Confidential, Lone Tree - CO

ETL - Technical Lead

Responsibilities:

• Translating requirements to load Marketing data from Source systems to CRM system for reporting.
• Working with BA, Data Modelers & Architects to finalize on the Data model and to create an ETL framework
• Create ETL design to help developers build the Informatica mappings
• Working on integration projects handling Weblog data, Salesforce data, JSON, XML and text files.
• Actively involved in daily SCRUM to enable efficient deployment & to integrate new requirements
• Provide estimates for the ETL developments by analyzing the business requirements
• Validate the results at every phase to ensure correctness of data.
• Co-ordinate code deployment between Development, QA and Production environments.
• Work as a Technical & Team lead to perform Onsite - Offshore co-ordination to manage and assign work.

Environment: Informatica Powercenter 9.5.1, Teradata

Confidential, Schaumburg - IL

ETL - Technical Lead

Responsibilities:

• Salesforce Integration with MDM and Netezza DB using Informatica Powercenter.
• Build reports on Salesforce for finding data anomalies and fix the same in the ETL logic.
• Supported Salesforce application and handed the cases for Underwriters, resolving a maximum of 85 cases per month.
• Work with the Data Modelers to provide the solution design.
• Provide estimates for ETL enhancement requests by analyzing the business requirements.
• Develop, Test and Maintain Informatica workflows to load data from the Netezza/SQL Server/XML source system to the target Netezza data warehouse.
• Work alongside Architect to move data between DB2 and IBM PLCM application.
• Make use of Autosys scheduling tool to schedule Informatica workflows.
• Co-ordinate code deployment between Development, QA and Production environments.
• Work as a Technical & Team lead to perform Onsite - Offshore co-ordination to manage and assign work.

Environment: Informatica Powercenter 9.5.1, Salesforce, Netezza DB, Autosys scheduler, Clearquest

Confidential

Responsibilities:

• Complete Informatica Powercenter installation and setup with folder creation and database connection configuration.
• Based on the Business Requirement Document or high level technical documents provided, data mappings are developed to enable the functionality.
• Apart from the basic transformations, transformations such as HTTP, connected & un-connected Stored procedure are used
• Developed a reusable mapplet to dynamically handle the parameterization without the use of parameter file.
• Developed mappings to capture records that have undergone soft delete and hard delete.
• Worked with relational tables, flat files and zip files as source and targets.
• Oracle Express Database set up for Metadata repository and source/target database.
• Unit testing and xml export of mappings and workflows.

Environment: Informatica Powercenter 9.5.1, Oracle Express 11g, 7 zip utility, Windows 7

Confidential

Module Lead - Informatica

Responsibilities:

• Provided estimates for this enhancement project by analyzing the requirements gathered.
• Worked alongside MSTR team to understand the data validation, data representation and business rules.
• Implemented mapping changes to reflect the flow of footwear related data.
• Developed Informatica mappings to load data from the Oracle source system to the target Oracle data warehouse.
• Included the new attributes and logic change in the mapping according to the change requests.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Implemented workflow and session related changes and include the parameter file with the new filter conditions.
• Implemented e-mail notification as part of error handling.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Performed Unit tests on all the mappings developed and documented the test cases and test results.
• Migrated the code into QA (Testing) and supported QA team and UAT

Environment: Informatica Power Center 9.1, Oracle 11g, and Windows 7

Confidential

Module Lead

Responsibilities:

• Provided estimates for this enhancement project by analyzing the requirements gathered.
• Architected the ETL flows required for the same and technical design documents have been developed.
• Have worked on Data modeling of Source system (Eclipse) and Data mapping to the Target Gold database.
• Developed new packages and procedures to integrate the source system Eclipse(new Trade Exchange) data into the existing downstream system for reporting.
• Written Unix scripts for data & source file such as file transfer between server, concatenation of multiple files, removing white space, managing the headers and appending the file with the previous trade date.
• Created and scheduled the packages and procedures using process flows in UC4 scheduling tool.
• Unit Testing and Implementation

Environment: Oracle 11g, SQL Developer, UC4, Putty and Windows 7

Confidential, NYC

Module Lead - MicroStrategy

Responsibilities:

• Requirement Gathering & Analysis
• Architected & Created a Data Model in Oracle DB and incorporated the same in MicroStrategy.
• Developed reports with drill down and drill across features.
• Integration of ESRI maps with the reports for data representation in maps.
• Unit Testing and Implementation
• Enabling the ESRI maps reporting in mobile devices.

Environment: MicroStrategy9.3, Oracle 11g, Windows 7

Confidential

Team Lead - Informatica

Responsibilities:

• Provided estimates by being part of Requirement Gathering & Analysis.
• Worked alongside MSTR team to understand the data validation, data representation and business rules.
• Architected & Designed the ETL flows for individual tables to handle full or delta load.
• Developed Informatica loads for 34 tables.
• Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.
• Performance tuningof the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Have worked closely with clients in every stage of this project being their single point of contact for technical developments.
• Taken initiative to create High Level and Low Level design documents for the same.
• Implemented failure e-mail notification process in every workflow developed.
• Single handedly handled this project for a whole month and also helped in the process of deployment of the same.
• Providedknowledge transferto the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Involved in Unit test plans and Performing Unit Testing like Quantitative Testing and Qualitative Testing.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).

Environment: Informatica Power Center 9.1, SQL Server 2000, SAP Logon 720 and Windows 7

Confidential

Team Lead - Informatica

Responsibilities:

• Provided estimates by being part of Requirement Gathering & Analysis.
• Worked alongside MSTR team to understand the data validation, data representation and business rules.
• Understanding the Business Data Mapping requirements and preparing the Tech. Design documents.
• Involved in designing and development of 22 Informatica workflows.
• Informatica mappings were developed to enable data load from the SAP Logon source system to the SQL Server target.
• Worked with proper coordination with other teams as there was dependency due to the global applications involved. Implemented SCD type II.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Towards the deployment phase, I have helped in managing the project single handedly with direct client interactions and other groups involved.
• Designed a flow to generate output files dynamically into a particular server location; with the file name changed dynamically according to the distinct input values; on a successful load.
• Efficiently taken care of all the CRs(change requests) which came up at that point.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).

Environment: Informatica Power Center 9.1, SQL Server 2000, SAP Logon 720 and Windows 7

Confidential

Senior Engineer - Informatica

Responsibilities:

• Involved in understanding the requirement and map them to the design.
• Developed a complex mapping using Java transformation for handling multivalued column value split into various rows and columns dynamically.
• Developed Informatica mappings to enable data load from the Oracle source system to the Exasol target database.
• Worked along with the team to develop 120 complex workflows which performs full loads and incremental loads as per the schedule.
• Modified the Unix shell scripts based on the requirement.
• Developed and modified the High Level and Low Level design documents.
• Have written Exasol scripts for bulk updation of a Dimension table and incorporated the same as a Post-SQL.
• Implemented failure e-mail notification process for notification and error handling. Prepared Unit test cases and recorded results.

Environment: Informatica Power Center 9.1, Oracle 10g, ExaSolution 4.0, Java, Unix and Windows 7

Confidential

Technical consultant - Informatica

Responsibilities:

• Have taken responsibility in determining the anomalies in the existing design and developments and helped the team understand the same.
• Helped in building a new design and code to fix these anomalies for the actual requirements provided.
• Used various transformations to develop robust mappings in theInformaticaDesigner.
• Performance tuningof the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Used debugger to test the data flow between source and target and to fix the invalid mappings.
• Developed and tested the new code for its proper functioning and deployed the same with in the specified timelines.
• Implemented parameter files to specify the source and target connections and made the mappings more manageable by using Mappings parameters.
• Performed Unit Testing implemented the code.

Environment: Informatica Power Center 8.6, Oracle 9i, SQL Developer and Windows 7

Confidential

Senior Engineer - Informatica

Responsibilities:

• Used ETL process to Extract, Transform and Load the data from SAP to Exasol staging area.
• Involved in the development of 40+ mappings for data load.
• Handled initial (i.e. history) and incremental loading as part of the ETL automation.
• Created re-usable components like transformations and sessions.
• Developed Low-level documents (LLDs) and Test case documents for the same.
• Performed unit testing with sample data by writing test cases.

Environment: Informatica Power Center 9.1, ExaSolution 4.0, SAP Logon 720 and Windows 7

Confidential

Project Engineer - Datastage

Responsibilities:

• Creating Datastage jobs as per the design document.
• The jobs enabled data load from the Teradata source system to the Teradata target data warehouse.
• Modified the transformation logic to fit in the new requirement.
• Performed Unit Testing on the new and modified datastage jobs.

Environment: Datastage 8.1, Teradata, Unix

Confidential, NYC

Responsibilities:

• Provided production support to the Sony Music customers, which involved understanding the customer requirement and providing them a value added solution within the specified SLAs.
• Involved BUG fixing, enhancements, addressing customer ad-hoc queries, which is issued via the ticket management tool JIRA.
• Involved in generation of reports in different readable formats, which were used in various important DB analysis and auditing purposes.
• Taken up and re-issued the failed orders, issued promotions and sales as per the requirements and managed partner status for order delivery.
• Undergone a training in Cognos for analyzing the reporting capabilities.

Environment: OLTP system from Apple & Sony Music, Oracle 9i, Oracle SQL, PL/SQL, SQL Developer, JIRA and Windows XP, Cognos 8

Confidential

Responsibilities:

• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Worked extensively to implement the data-masking tool ‘WinCrypt’.
• Created JSP pages, which enable the data movement by triggering the Informatica workflow from a GUI environment.
• Performed Unit testing and integrated testing and also was involved in documentation of every development stage.
• Providedknowledge transferto the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Informatica Powercenter 8.1.1 SP2, Tom cat Web server, Oracle 9i, Java, JavaScript, HTML

Confidentia

Responsibilities:

• Involved in data cleansing and created mappings to load dimension and fact tables.
• Involved in Designing, Scheduling & Monitoring of workflows.
• Using the Business Objects, have generated dashboard reports and created universe as per the specified requirement.
• Also involved in updating the dimension tables using reference feeds.
• Prepared the Design Documents, Release Documents, and reviewed Coding Standards.
• Designing and coding, testing and implement of designed Interface.
• Created detailed Unit Test Document with possible Test cases.

Environment: Informatica Powercenter 8.1.1 SP2, Business Objects XI R2, Oracle 9i DB and Windows XP