CAREER SUMMARY:

• Sincere, diligent & competent professional with more than 12 Years of strong Data Warehousing experience.
• Involved in the data analysis for source and target systems. Good understanding of Data warehousing concepts, Business Intelligence, Star schema and Snow - flake schema.
• Experienced in developing Mappings and Transformations using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets. Also can perform Informatica support activities to ensure smooth execution of scheduled jobs.
• Experience indifferent phases of SDLC like requirements analysis, development & testing.
• Experience in knowledge management & training.
• Proven ability to quickly adapt to customer’s project execution methodology and in building rapport with project stakeholders.
• Excellent presentation, analytical, documentation and interpersonal communication skills
• Excellent organizational skills including ability to multi-task and prioritize and manage increasingly complex issues.
• Good ability to quickly grasp and master new concepts and technologies

TECHNICAL SKILLS:

Data Warehousing: SSIS, Informatica Power center 8/9.5.1/9.6/10. x, Informatica MDM,SSRS, Business Objects, AbInitio, OLAP, OLTP, Star & Snowflake Schema, FACT & Dimension Tables, Physical & Logical Data Modeling,

Databases: Oracle 8i, Oracle 9i, Oracle 10g, SQLServer, Netezza

Operating Systems: Unix, Windows

Software Engineering Methodologies/Tools/Technologies: Mercury Quality Center, Software Testing, software design, Rational Rose UML, Structured Modeling, Waterfall model, Agile methodology, Remedy, Service now, Control-m, Autosys

Development/Productivity Tools: Mercury Test Director, SQL*Plus, Toad, SQL Server Data tools

PROFESSIONAL EXPERIENCE:

Confidential, Boston

Onsite Informatica Technical Lead developer

Responsibilities:

• Point of contact to interact with Business for requirement.
• Primary role of an informatica developer to create mappings to read the edi file formats available as 852 and 867.
• Creating B2B transformations to read each row of edi file and push it into stage tables.
• Creating mappings and mapplets to push data from stage to ODS layer.
• Extensively using xml transformations.
• Creating mappings and sessions to push data from ODS to datawarehouse layer.
• Creating complex queries in SQL to fetch data from existing wholesaler distribution center tables.
• Involved in one on one sessions with business and other stakeholders to understand the requirements.
• Delivering the requirements to the offshore team mates.
• Involved in preparing design document
• Involved in preparing functional requirements specification document.
• Involved in unit testing, alpha testing and beta testing with customers.
• Mentoring team mates at offshore and reviewing their code.
• Debugging the informatica mappings to remove errors in the code.
• Creating service requests for migrating informatica objects, sql server database objects, cognos reports etc
• Performing end to end testing to ensure data gets populated from edi files through ETL to cognos reports.
• Scheduling jobs in goanywhere scheduler to run jobs in SIT and production.
• Preparing alpha test log evidence document to be shared with client to obtain sign off.
• Preparing weekly status reports to share with the management.

Technology/Tools: Informatica PowerCenter 9.6.1, Toad for Oracle, SQL server 2012, Autosys, Cognos, Goanywhere, service now

Confidential, NJ

Onsite Technical Lead

Responsibilities:

• Point of contact to interact with Business for requirement.
• Analysis the VLS tables and the existing system.
• Creating document to map VLS to MSP tables and fields. Attending JAD session with the vendors and other stakeholders for the same.
• Routing data from existing source system to ecosystem.
• Consuming data from ecosystem to Loan Data Hub and creating necessary canonical structure.
• Producing the staging like structures to provide data to existing stratification process.
• Replacing the staging structure with canonical structure to run the stratification process.
• Creating SSIS package which will download data from the respective source and will push into loan data hub.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Compressing the extracts provided at each step. The compression happens in Bond Studio transformation, FICO, HFI transformation etc.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Developed, deployed, and monitored SSIS Packages.
• Creating jobs in Autosys to schedule the jobs.
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Changing existing informatica jobs to pull only mortgage data. Applying filters to remove HELOC loans.
• Creating SQL server scripts for creating daily and monthly tables.
• Creating partition schemes, partition functions etc for monthly tables.
• Involved in Testing and Test Plan Preparation, Process Improvement for the ETL developments.

Technology/Tools: SQL Server Data Tools, Informatica PowerCenter 9.6.1, Toad for Oracle, SQL server, Autosys

Confidential, NY

Informatica Technical Lead

Responsibilities:

• Point of contact to interact with Business for system improvement, bug fixing and enhancements.
• Provide timely resolution to Service Tickets, Incidents and Problem tickets.
• Experience in Data Warehouse/Data Mart design, System analysis, Database design, ETL design and development, SQL.
• Created mapping between the databases and identified the possibilities of incorporating the new business rules with the existing design.
• Prepared High level design (HLD), LLD, Project functional Specification Document and Business Requirement documentation (BRD).
• Participated in Design team brainstorm and user requirement gathering meetings.
• Involved in Architecture and design of Data extraction, transformation, cleaning and loading.
• Involved in Requirement gathering and source data analysis for the Data warehousing projects.
• Involved in the Logical and Physical design and creation of the ODS and data marts.
• Involved in all phases of SDLC from requirement, design, development, testing, pilot, training and rollout to the field users and support for production environment.
• Implemented mapping techniques for Type 1, Type 2 and Type 3 slowly changing dimensions.
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center.
• Involved in Testing and Test Plan Preparation, Process Improvement for the ETL developments.
• Involved in Data Quality Assurance, created validation routines, unit test cases and test plan.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica mappings.
• Lead and coordinate team activities.
• Approve and follow up change requests, status calls with clients & business users, attending operations calls to discuss production database related activities.
• Coordinate and perform Informatica migrations.
• Perform analysis on the performance of ETL jobs to meet the defined Service Level Agreements.
• Performing Informatica support activities. If the job fails analysis is performed to understand the root cause of the same and the corrective action is taken in order to ensure the load is resumed and completed successfully.
• Analyzing Informatica components to understand data flow for solving issues.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Monitor and troubleshoot batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Data Validation has been done for various sources to target mappings.
• Migrated ETL objects from DEV to UAT to PRD environments using Repository Manager.
• Perform GFIS year-end activity successfully.
• Monitoring the sql server jobs and if the job fails, analysis is performed to understand the root cause of the same and the corrective action is taken in order to ensure the load is resumed and completed successfully.
• Performed analysis to understand the data issues by drilling down the logic behind the sql server procedures and packages which supplies the data.
• Has good understanding of Control M through which the jobs are scheduled to run.
• Worked in the archival project to move data to history database.
• Providing 24*7 on call support for the application.
• Manually running the mappings to provide the missed files to the downstream applications.
• Involved in interviewing candidates to form the team.

Technology/Tools: Informatica PowerCenter 9.6.1, Oracle, SQL server, control-m, service now

Confidential

Sr. ETL Developer

Responsibilities:

• Hands on experience in implementing Slowly Changing dimension types (I, II &III) methodologies
• Provided timely resolution to Service Tickets, Incidents and Problem tickets.
• Experience in Data Warehouse/Data Mart design, System analysis, Database design, ETL design and development, SQL.
• Created mapping between the databases and identified the possibilities of incorporating the new business rules with the existing design.
• Prepared High level design (HLD), LLD, Project functional Specification Document and Business Requirement documentation (BRD).
• Participated in Design team brainstorm and user requirement gathering meetings.
• Involved in Architecture and design of Data extraction, transformation, cleaning and loading.
• Involved in Requirement gathering and source data analysis for the Data warehousing projects.
• Involved in the Logical and Physical design and creation of the ODS and data marts.
• Involved in all phases of SDLC from requirement, design, development, testing, pilot, training and rollout to the field users and support for production environment.
• Implemented mapping techniques for Type 1, Type 2 and Type 3 slowly changing dimensions.
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center.
• Involved in Testing and Test Plan Preparation, Process Improvement for the ETL developments.
• Involved in Data Quality Assurance, created validation routines, unit test cases and test plan.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica mappings.
• Perform analysis on the performance of ETL jobs to meet the defined Service Level Agreements.
• Performing Informatica support activities. If the job fails analysis is performed to understand the root cause of the same and the corrective action is taken in order to ensure the load is resumed and completed successfully.
• Analyzing Informatica components to understand data flow for solving issues.
• Perform GFIS year-end activity successfully.
• Understand and discuss the ETL requirements with the Business Unit and preparing the detail design documentation according to the standards.
• Good understanding of Control M through which the jobs are scheduled to run.
• Worked in the archival project to move data to history database.
• Providing 24*7 on call support for the application.
• Manually running the mappings to provide the missed files to the downstream applications.
• Involved in interviewing candidates to form the team.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

Technology/Tools: Informatica PowerCenter 9.0.1, Oracle, SQL server, control-m, service now, SSIS

Confidential

Sr. ETL Developer

Responsibilities:

• Worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.
• Understand and discuss the ETL requirements with the Business Unit and preparing the detail design documentation according to the standards.
• Created number of complex Mappings, Mapplets, Reusable Transformations, Workflows, Worklets, Sessions using Informatica Power center 9/8.6.1 to implement the business logic and to load the data incrementally.
• Participated in requirements gathering and gap analysis with business analyst
• Designed ETL strategy and mapping design.
• Developed mappings for the generation of flat files for various back office systems
• Designed and developed mappings for the complex AML module and Archiving
• Created reusable mapplets, dynamic parameter files etc.
• Prepared ETL Design-Document and Implementation Plan documents.
• Involved in Unit Testing and created various test cases and reviewed and fixed issues in the ETL code.
• Supported UAT and resolved issues. Also, worked on CR’s (change request) by the business.
• Performed code deployment using PowerCenter Team based development to ST, FAT environments.
• Monitor and troubleshoot batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Technology/Tools: Informatica PowerCenter, Oracle/Teradata, SSIS

Confidential

Module Lead

Technology/Tools: Abinitio, Business Objects XIR2, Mercury Test Director, Autosys, Informatica

Responsibilities:

• Development/Review/Testing of the ETL/Reporting modules and Leading a 4 member team offshore.
• Project Life Cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets.
• Involved in detail design and development of mappings using Abinitio.
• Extracted data from ODS and loaded into EDW using Abinitio.
• Performed Repository object migration from Development to testing and testing to production Environments.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Performed Unit Tests and tested Mapping logic by passing sample messages.
• Responsible for Self and Peer Review of Informatica mappings under Development Phase.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Scheduled the tasks to be run using the Workflow Manager.
• Created Informatica users, maintained folders and given user privileges based on role.
• Scheduling jobs using Autosys.
• Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Planning and managing the deliverables, coordinating the activities with the client project manager and interacting with the business team, status reporting.
• Interacting with business users, business owners for requirements gathering, analyzing business process and translating business requirements into analytical applications. Also provided suggestion to perform necessary changes to cope with the business requirement. Also was leading the team and the main point of contact with client for the execution of the project.
• Conducting training programs to users across the globe for making awareness of the enhanced functionalities available in Business Objects.
• Preparing the Test case and Test Scripts for Unit testing.

Confidential

Business Objects developer

Responsibilities:

• Part of the requirements Analysis phase of the project & could contribute to the system studying phase.
• Carrying out detailed planning, scheduling and coordinate with internal & external partners to ensure execution of projects as per the defined technical & functional specifications.
• Designing and modelling using UML.
• Analyzed SQR code files to decipher the business logic involved to help in the design of Data warehouse.
• Created Universes for helping business users to build adhoc Reports.
• Involved in the testing of these universes by running the Acceptance test case for each of these universes.
• Involved in bug fixing of these adhoc universes based on the review comments given by the client after the UAT.
• Involved in the enhancement of BO Universe using designer as a part of report generation to meet the customer requirements.
• Created canned reports using Crystal Reports XI based on the business requirements & testing the reports based on the test cases.
• Created Complex BO reports using functionalities like combined queries, sub queries, unions & intersections, slice and dice, drill down, cross tab etc. to help the management to track and lead the initiates to run the process smoothly.
• Participated in all design/ CUT phase discussions with the client. Was involved in the customization part of the reports which was done in Java.
• Part of the ETL team to get the data loaded in the target systems.
• Following the production implementation, I was involved in support & maintenance of the project deliverables.
• Tracking project progress in terms of cost, resource deployment and time over runs and quality compliance and proactively identify and rectify problems to ensure adherence to delivery time-lines.

Technology/Tools: Informatica, Business Objects XIR1, Universe design, Agile methodology

Confidential

Business Objects developer

Technology/Tools:Business Objects 5.1,Oracle,Sybase

Responsibilities:

• Development/Testing/Scheduling of reports & the building of the functional & design documents.
• Involved in writing macros in VB for the customization & formatting part of the reports, to make sure that the reports run on their scheduled time & produce the desired results, to investigate the cause of minor bugs which happened while running the report & rectifying them, running the report with dummy data to see if the data matches the clients requirements.
• It involved analyzing all the existing data loads to identify the cause of the performance issue and data inconsistencies and redeveloping the reports.