OBJECTIVE

• Seeking a position, where my skills and work experience as a Senior Production Support Analyst/Developer in Data Integration/Data Warehousing/ETL/Business Intelligence can be utilized and enhanced.

SUMMARY

• Around 7 years of overall experience in IT Industry with emphasis on Data Warehousing tools using industry accepted methodologies and procedures.
• Technical expertise in ETL methodologies, Informatica 8.x/9.x/10.x - Power Center, Client tools - Mapping Designer, Mapplet Designer, Transformations Developer, Workflow Manager/Monitor and Server tools - Informatica Server Manager, Repository Server Manager, and Power Exchange.
• Expertise in Data Warehouse, Data Migration, Data Modeling, and Data Cleansing.
• Experience in installing Informatica and configuration in windows and UNIX environment.
• Directly responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse. Complete knowledge of data warehouse methodologies (Ralph Kimball, Inmon), ODS, EDW and Metadata repository.
• Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Informatica
• Expertise in Extraction, Transformation & Loading of data using heterogeneous sources and targets.
• Experienced in integration of various data sources like Oracle IBM DB2, MS SQL Server, My SQL, Teradata, XML files sources into staging area and different target databases.
• Expert in Extracting, Transforming and Loading (ETL) data usingInformatica; creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities.
• Used IICS to pull data from various sources like SAP, JSON, SOAP, XML.
• Experience in performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL Queries and DVO validation.
• Expertise in Oracle (SQL/PLSQL) and SQL server performance tuning using optimization techniques.
• Data Modeling experience on Data modeling, ERwin 7.1/4.5/4.0, Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data marts, OLAP, OLTP, FACT & DIMENSIONS tables, Physical & Logical data modeling and Oracle Designer.
• Data Analysis strong experience on Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Expertise in creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Extensive database experience and highly skilled in SQL in Oracle, MS SQL Server, DB2, Flat Files, CSV files.
• Skilled in SQL, PL/SQL, SQL*Plus, TOAD, SQL Assistant.
• Experience in implementing Data Warehousing Applications using Informatica Power Center / Power Mart for designing and developing transformations, mappings, sessions, and for scheduling and configuring workflows.
• Skilled in UNIX, Shell programming on UNIX systems using VI Editor, Windows scripting and in Informatica Sessions.
• Closely worked with Reporting team and built some reports for business needs.
• Worked on Business Objects (SAP) to create and run reports by using the data that has been loaded into data warehouse and monitoring these reports on their daily run.
• Worked on Business Intelligence launch pad for Business Objects
• Loading data from ETL to data warehouse.
• Experience in delivering End-User report generating tools Cognos, Reporting Services.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.
• Self-motivated and able to work independently and as a member of a team.
• Excellent teamwork spirit and capable of learning new technologies and concepts.

TECHNICAL SKILLS

ETL Tools: Informatica Cloud 10 IICS, Informatica PowerCenter 10.x, 9.x, 8.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server, Business Objects

Databases: Oracle 12c,11g/10g/9i MS SQL Server 2012/2008, SAP, XML, JSON

Programming: SQL, PL/SQL, T-SQL, UNIX Shell Scripting, Perl.

Scheduling Tools: ESP, Autosys

Operating System: Unix, Linux, Windows 8/7/2000/XP/ NT

Methodologies: Waterfall, Agile, Scrum

PROFESSIONAL EXPERIENCE

Confidential, Dover, NH

ETL Production Support Analyst/Developer

Responsibilities:

• Analyzed the Business requirements and documented the technical specification documents.
• Provide level 1 support for the production jobs and monitored them. Ensure that the ETL jobs get completed as per SLA.
• Implemented various performance tuning techniques at Informatica and Data base level.
• Used SQL queries to test huge volumes of data onOracle 11gandSQL Server 2008
• Used Informatica PowerCenter/Power Exchange to extract/transform and load into different systems involving Oracle, SQL server, XML, Flat files.
• Developed ETL mappings for Type 1 SCD and Type 2 SCD requirements.
• Implemented various performance tuning techniques on Sources, Targets, Mappings and Workflows.
• Involved in writing stored procedures and shell scripts for automating the execution of jobs.
• Supported the QA resources in SIT and UAT testing phases.
• Using InformaticaPowerCenter10.1and9.6to make the changes to the existing ETL mappings in each of the environments.
• Create change management strategy. Identify, analyze, prepare risk mitigation tactics Identifying and manage anticipated resistance
• Escalate issues and remediation steps effectively and in a timely manner.
• Perform troubleshooting analysis and resolution of critical applications and batch processes.
• Coordinate with vendors to troubleshoot and resolve issues.
• Support the Client Reporting Production Environment as a priority.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Worked on Informatica Data Quality to resolve customers address related issues. Worked on Informatica on Demand to mainly import data from Sales Force.
• Developed data models according to company standards. Used DB2 Connect to extract multiple database source systems to single analytical system for large databases and24*7 Production support for data warehousing
• Involved in the migration ofInformatica9.6workflowsintoInformatica10.1version.
• WrotePL/SQLprocedures which are called fromStored Proceduretransformation to perform database actions such as truncate the target before load, delete records based on a condition and rename the tables.
• Designed Sources to Targets mappings from SQL Server, Excel/Flat files to Oracle using Informatica Power Centre.
• Develop the Perl and Shell scripts to automate the finance billing file.
• Responsible for Detail design of each interface.
• Assisted with implementation/upgrade of AutoSys and JIRA, troubleshoot errors, and documentation/procedures.
• Developed SDE mappings to load large amount of data from different sources to staging area, SID mappings for load the data from staging area to target system.
• Implemented slowly changing dimension Type 1 and Type 2 for Change data capture using Version control.
• Created various Oracle database SQL, PL/SQL objects like Indexes, stored procedures, views and functions for Data Import/Export.
• Have RDBMS concepts experience in Oracle, Oracle PL/SQL, MS SQL Server.
• Installation and configuration of Informatica Server and Informatica Repository Server in Windows-UNIX Operating Systems.
• Data Warehouse Data modeling based on the client requirement using ERwin (Conceptual, Logical and Physical Data Modeling).

Environment: Informatica PowerCenter 10.1/9.6, MS SQL server 2012, Oracle 11g/10g, Toad, PL/SQL (Stored Procedures, Triggers, Packages), Autosys, JIRA, CSV files, Unix Shell scripting, MS Visio, Windows XP.

Confidential, Pittsburgh, PA

ETL Developer/ Production Support Analyst

Responsibilities:

• Documenting every ETL mapping specification. Preparing documentation for source analysis & ETL design, which are required prior to development.
• Involved in extraction, cleansing and loading of data into database.
• Worked with the Business analysts for requirements gathering business needs analysis, testing, and project coordination
• Moving the data from source systems to different schemas based on the dimensions and fact tables by using the slowly changing dimensions type two and type one
• Architected and designed the ETL solution that included designing Mappings and workflows, deciding load strategies, implementing appropriate error handling and error notification processes, scheduling and designing re-usable ETL pieces through parameterization
• Worked extensively on different types of transformations like source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Union, Stored Procedure and sequence generator
• Conduct training and knowledge sharing sessions for the onsite and offshore developers and testers on investment banking domain and functional areas
• Involved in triaging the issues ahead of reaching to any kind of priority issues hence preventing serious business scenarios and Leading major incident calls, leading problem management and writing post problem reviews.
• Involved in data analysis and handling the ad-hoc requests by interacting with business analysts, clients and resolve the issues as part of production support
• Performed debugging by checking the errors in the mapping using Debugger utility of the Designer tool and made appropriate changes to generate the required results
• Liaison with cross functional teams across the enterprise, including OLTP development team and various data-warehouse teams (on site and offshore team members)
• Developed UNIX shell scripts to run the pmcmd functionality to start and stop sessions and batches
• Developed Test cases for Unit Testing of the Mappings, and was involved in the Integration Testing
• Worked closely with team members and QA team for finalizing ETL Specification documented test scenarios
• Worked with data modeler to create Universe
• Worked on Business Objects with Business Intelligence launch pad
• Created reports to meet the business requirements by using the data loaded into Data warehouse
• Worked on Business Objects (SAP) to make reports and monitoring them
• Provided production support by monitoring the processes running daily at early hours
• Worked in production environment for Finance section in project and took control over the tickets that come daily and processed these tickets with quality.
• Worked with Clients Service Center to follow the tickets raised by various teams and resolved them by inserting or updating or deleting data.
• Managing check and EFT, voids and reissues.
• Worked with Tivoli Workload Scheduler (TWS) for observing scheduled jobs to follow up and fix the failed jobs for production.

Environment: Informatica PowerCenter 9.6, Oracle 10g, XML, flat files, CSV Files, DB2, Toad, SQL Developer, Windows 7, Unix, Winscp, SQL server, Tivoli Workload Scheduler (TWS), Service Center 2.0, Business Objects (SAP), Business Intelligence (BI) launch pad

Confidential 

Informatica/PL/SQL Developer

Responsibilities:

• Based on the requirements created Functional design documents and technical design specification documents for ETL.
• Extracted data from various Source Systems like Oracle, SQL Server and Flat Files as per the requirements.
• Designed and developed mappings and Mapplets using Informatica Source analyzer, Warehouse designer, Transformation designer and Mapplet designer.
• Created tables, views, indexes, sequences and constraints.
• Developed stored procedures, functions and database triggers using PL/SQL according to specific business logic.
• Transferred data using SQL*Loader to database.
• Involved in testing of Stored Procedures and Functions. Designed and developed table structures, stored procedures, and functions to implement business rules.
• Involved in design and development of data validation, load process and error control routines.
• Analyzed the database for performance issues and conducted detailed tuning activities for improvement.
• Generated monthly and quarterly drugs inventory/ purchase reports.
• Coordinated database requirements with Oracle programmers and wrote report SQL's for sales data.

Environment: Informatica Power Center 9.6, Oracle 9i, SQL, PL/SQL, SQL *Loader, Windows.