SUMMARY:

• 8+Years of strong experience in designing and implementing Data Warehouse applications using ETL tools INFORMATICA Power Center 9.6.1, 9.5.1, 8.6, 8.5 (Designer / Workflow Mgr.) and Power center to transfer the data from legacy systems (Mainframes) to common/ different targets and Oracle PL/SQL.
• Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, also created Mappings and Workflow’s for Claims in Healthcare Dept.
• Experience in Debugging and Performance Tuning of targets, sources, mappings and sessions.
• Proficient in using Informatica Workflow manager, Workflow monitor, pmcmd (Informatica command line utility) to create schedule and control Workflows, tasks and sessions.
• Extensively worked on database applications using DB2, Oracle, SQL Server, T - SQL, PL/SQL, SQL*Loader.
• Experience in Data Design and Development on Microsoft SQL Server 2012/2008R 2/2008/2005/2000, T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing.
• Experience in using Business Intelligence tools(SSIS,SSAS,SSRS) in MS SQL Server 2008
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• 1+ years of experience implementing Data warehouse/Business Intelligence using OBIEE.
• 1+ years of experience on Business Objects and Xcelsius.
• Basic Knowledge of Advanced Programming for data transformation (JAVA, C++, C)
• Experience on Oracle BI Apps customization & implementations
• Functional knowledge of one or more BI Apps applications modules
• Experience in administration and implementation of BI Apps including Financials, Procurement and Spend, Supply Chain and Order Management, HR and Project analytics.
• Experience in creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
• Expertise in utilizing ETL tools including Oracle Data Integrator, Informatica and RDBM systems like Oracle and Teradata.
• Experienced in development of ELT and ETL Interfaces/Mappings in Oracle Data Integrator.
• Experience in Oracle Business Intelligence Applications OBIA /BIApps with expertise in gathering user requirements, designing, developing and Production support.
• Experience in Oracle Data Integrator with expertise in building data extraction routines for Data Warehousing and Code tuning.
• Knowledge in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Knowledge in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems
• Experience in UNIX shell scripting.
• Involved in migration of the maps from IDQ to power center
• Knowledge in IDQ, hands on with IDQ.
• Applied the rules and profiled the source and target table's data using IDQ.
• Experience in incident management, problem management and change management
• Experience in developing logical and physical models and implementing them in Oracle.
• Experience in integrating data from various sources Oracle, DB2 UDB, Sybase, and SQL Server.
• Experience in creating entity relational & dimensional relational data models with Kimball Methodology (Star schema and Snow flake schema architectures, Fact/dimension tables)
• Documented design procedures, operating instructions test procedures and troubleshooting procedures.
• Experience with Informatica Admin console.
• Used partitioning in Informatica to improve session performance for very large data loads.
• Knowledge in design and development of Business Intelligence reports using BI tools Business Objects, Cognos and knowledge in micro strategy.
• Worked as On-Site coordinator for an off-shore development team in India.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
• Followed Agile methodology, interacted with Integration Team on daily basis.
• Solid time management and multitasking skills, which help in conducting project meetings, reviews, walkthroughs, and customer interviews according to the varied needs of the people involved
• Excellent written and oral communication skills and a results-oriented attitude

TECHNICAL SKILLS:

ETL Tools: Informatica (Power Center 9.6, 9.0.1,8.6, 8.5), IDQ 9.1/9.5.1 OBIEE 11g/10g, Oracle Data Integrator 12c/11g, OBIA/BI APPS11g

Data Base: Oracle 12g/11g,9i/8i/8.0/7.0,MS SQL Server 2000, 2008, DB2, MS Access 97/2000, Sybase, Teradata, Netezza.

Data Modeling: Erwin 3.5/4.0

Operating System: Windows 98/NT/2000/XP, UNIX (Linux, HP-Unix, Solaris)

Other Software: Aginity, WinSQL, TOAD7.3, MSOffice, MS Visio, Autosys.

Scripting Languages: Korn Shell Scripting (Kshell), Perl, Python, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Owings Mills, MD

ETL Informatica Developer

Roles & Responsibilities:

• Involved in Informatica upgrade project from 9.1 to 9.6.
• Migrated informatica objects from old server to the new server, as a part of upgrade.
• Updated jil scripts to update autosys jobs with the new server information.
• Created Informatica Mappings to acquire assets and flows information on competitor products, both US and International.
• Followed Agile methodology, interacted with Integration Team on daily basis.
• Worked on multiple projects using Informatica developer tool IDQ of latest versions 9.1.0 and 9.5.1.
• Involved in migration of the maps from IDQ to power center
• Applied the rules and profiled the source and target table's data using IDQ.
• Loaded monthly file-based Strategic Insight tables into CIP Exploration Oracle database.
• Provided limited change data capture to overwrite recently modified records.
• Provided basic exception handling for potential data issues.
• Provided new ‘Calendar’ dimension for ease of rolling period reporting.
• Performed performance tuning in OBIEE Analytics, Data warehouse, ETL Mappings
• Exceptional Background in administration and implementation of BI Apps including Financials, Procurement and Spend, Supply Chain and Order Management, HR and Project analytics.
• Designed ODI Projects, Packages and Interfaces to extract the data from Oracle EBS R12 database load to Oracle Business Analytics Data Warehouse OBAW.
• Creating and customizing ODI interfaces, mapping, joins, filters lookups to implement business rules.
• Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including Essbase, Relational Database Management servers including Oracle RDBMS, SQL Server, and IBM DB2 and flat files including CSV, Excel, XML file formats.
• Knowledge on Business objects.
• Helped generate Reports for end users using business objects.
• Effective use of advanced reporting and formatting functions in Business Objects reporting.
• Developed Single and multiple dashboards and scorecards using business objects.
• Effective use of advanced reporting and formatting functions used in Business Objects reporting.

Confidential, Balacynwyd, PA

ETL Informatica Developer

Roles & Responsibilities:

• Worked with Integration Team to build intermediate DB.
• Created mappings, workflows to load data into the new tables in intermediate DB Tables.
• Followed Agile methodology, interacted with Integration Team on daily basis.
• Worked with Spire Integration Team to Help load data into intermediate DB for easy access of data through various different systems.
• Created Mapping and Workflows to load appropriate data for billing Center and APPS applications.
• Optimized existing code with performance issues.
• Worked with Teradata 12 utilities like BTEQ, Fast Load, and Multi Load and Query man.
• Have experience on implementing business rules in BTEQ scripts.
• Worked with parameters like UPI, USI and other Indexes.
• Extensively involved in data validation to ensure that the highest levels of data quality and data integrity are maintained.
• Created Staging Tables on the intermediate DB and loaded these tables with appropriate data for different systems.
• Participated in status review team meetings on daily basis.
• Created different Transformations for loading the data into target like Source Qualifier, Expression, Aggregator, Update Strategy, Lookup, Router, Filter, and Sequence Generator transformations.
• Performed unit testing and Involved in tuning the Session and Workflows for better performance.

Environment: Informatica 9.6.1, SQL Server Management Studio 2008 and 2012, PL/SQL, Windows Server.

Confidential, Pittsburgh, PA

ETL Informatica Developer

Roles & Responsibilities:

• Involved in a Project called POLYPATHS.
• Involved in optimization of code and tuning queries for performance.
• Involved in testing and data validation of the reports.
• Created mappings, workflows to load data from FHLB-PGH’s existing DWH into their new POLYPATHS system.
• Worked with FHLB-PGH’s Trade data to analyze bond - pre trade data.
• Helped load Market values correctly into the new POLY system for trade analysis.
• Worked with Flat files like (OF-Generic Curve, Bond-Pre Trade) loaded these flat files into POLY system.
• Worked on both Outbound and Inbound interfaces (POLYPATHS).
• Redesigned and implemented FHLB-PGH’s FAS-133 system, to load INCEPTION and ONGOING outbound Flat files.
• Involved in peer to peer reviews.
• Identifying Bugs and reporting defects.
• Knowledge transition to new team member.
• Created deployment groups to migrate Informatica code from Dev to UAT.
• Followed Agile methodology, interacted with business users on a daily basis.

Environment: Informatica 9.5.1, SQL Server Management Studio 2008 and 2012, Autosys, PL/SQL, Windows XP, UNIX, Secure FX.

Confidential, Philadelphia, PA

ETL Informatica Developer

Roles & Responsibilities:

• Creating Informatica Mappings and workflows to migrate data from one environment to another and data enhancements.
• Involved in optimization of code and tuning queries for performance.
• Involved in testing and data validation of the reports.
• Provided post production support to end-users.
• Worked on ESR Support Project and EM support which are two process in Confidential
• Created Autosys jobs and also involved in monitoring Autosys jobs on daily basis.
• Support end User on a daily basis, with reports and any issues concerning the balance sheet.

Environment: Informatica 9.5.1, SQL Server Management Studio 2008 and 2012, Autosys, PL/SQL, Windows XP.

Confidential, Jessup, PA

ETL Informatica Developer

Roles & Responsibilities:

• Preparation of design document, development for loading data into the data warehouse.
• Designed, Developed and Deployed informatica mappings, workflows from Dev to testing and Production environments.
• Created New Staging tables in Staging DB to store data from client files (CMS, NY
• Medicaid Files etc.)
• Wrote Postgres SQL Queries to work with the data, being loaded from external client files into the Data Warehouse.
• Worked with Shell Scripts (UNIX).
• Worked with existing Python Scripts, and also made additions to the Python script to load data from CMS files to Staging Database and to ODS.
• Worked extensively on SQL Server 2008 and Postgres SQL.
• Worked extensively on Medicaid and Medicare and CMS files, and their corresponding file layouts.
• Prepared design, technical and functional documents from the business requirements gathered.
• Created Mappings to move data from Oracle, SQL Server to new Data Warehouse in
• Green Plum.
• Created different Transformations for loading the data into target like Source Qualifier,
• Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression,
• Router, Filter, Aggregator and Sequence Generator transformations.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target tables using Informatica Workflow Manager
• Parsing high-level design specs to simple ETL coding and mapping standards.
• Involved in data validation to ensure that the highest levels of data quality and data integrity are maintained.
• Used Informatica Partitioning to improve session performance.
• Performed unit testing and Involved in tuning the Session and Workflows for better performance.
• Participated in status review team meetings.

Environment: Informatica 9.1, SQL Server Management Studio 2012, Idle Python GUI 2.5.4, PgAdmin3 (Postgres), PL/SQL, Windows XP, UNIX.

Confidential, King of Prussia, PA

ETL Developer

Roles & Responsibilities:

• Involved in requirement gathering with business team for data feed and report development for the stores Ralph Lauren and Club Monaco.
• Preparation of design document, development of data feed interfaces and reports using Sagent Business Intelligent Tool.
• Design, Development and Deployment of Order, Buyer and Customer Profile data feeds.
• Identifying and resolving performance issues on long running reports and data feeds.
• Coordinating with DBAs to find optimal solutions on complex backend operations.
• Scheduling and automating interface feeds and reports using Sagent Automation Tool.
• Prepare test documents and perform testing to certify for deployment.
• Involved in User Testing, fixing issues and production deployment.
• Resolve high priority production support tickets involving data issues, historical loads and real time data traffic.

Environment: Sagent, Sagent Automation, Oracle 11g/9i, DB2, PL/SQL, Windows XP, SQL Server.

Confidential, Harrisburg, PA

ETL Informatica Developer

Roles & Responsibilities:

• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.0.1.
• Interfaced with various members of the technical and business team to translate the business reporting and data maintenance requirements into functional ETL code.
• Involved in migrating of data from DB2 to Netezza, using Informatica 9.0.1
• Created Mappings to move ETL processes from various systems like DB2, Oracle, SQL Server to CBC’s new Data Warehouse in Netezza.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target tables using Informatica Workflow Manager
• Worked with the DBA to modify SQL from DB2 to Netezza version for already existing code in DB2.
• Parsing high-level design specs to simple ETL coding and mapping standards.
• Extensively involved in data validation to ensure that the highest levels of data quality and data integrity are maintained.
• Experience with Informatica Admin Console.
• Created deployment groups to migrate code for one environment to another.
• Complete understanding of Pushdown Optimization Utility in Informatica.
• Used Informatica Partitioning to improve session performance.
• Used Aginity and WinSQL to run Queries, for testing and validation of data.
• Created mappings to write Infusion data, CPT HCPC codes etc to flat files for Care Centrix for reporting purposes.
• Used transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, and lookup, Rank, Joiner, Expression, Stored Procedure and Update Strategy to meet business logic in the mappings.
• Created reusable transformations and Mapplets to use in multiple mappings.
• Used workflow Manager for Creating, Validating, Testing and Running the sequential and concurrent Batches and Sessions, and scheduled them to run at a specified time.
• Used mapping parameters and variables.
• Created Workflow, Worklet, Assignment, Decision, Event Wait and Raise and Email Task, scheduled Task and Workflow based on Client requirement.
• Migrated ETL code from Dev to QA and then from QA to Prod for new release cycles.
• Developed testing strategies and performed in-depth testing to ensure data quality.

Environment: Informatica Power Center 9.0.1, Oracle 11g/9i, DB2, PL/SQL, UNIX, Windows XP, Win SQL, Tidal.

Confidential, Boston, MA

ETL Informatica Developer

Roles & Responsibilities:

• Involved in data analysis and development.
• Prepared mapping specifications documents, unit testing documents for developed Informatica mappings.
• Prepared mapping documents for loading the data from Oracle database, to staging area.
• Loaded data from staging (ODS) Schema to EXTRACT tables for reporting purpose.
• Defined Target Load Order Plan for loading data into different Target Tables.
• Worked on Informatica Power center 9.0.1 Tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, Worklets and Reusable Transformation.
• Extensively used Router, Lookup, Aggregator, Expression and Update Strategy transformation.
• Worked with Utilities such as BTEQ, Fast Load, Multi Load, Xml import, Fast Export. Exposure to TPump on UNIX/Windows/Mainframe environments and running batch process for Teradata CRM.
• Used Bteq to load data from the flat files delivered on FTP server by Summit Energy Group into target tables.
• Developed Bteq scripts to generate reports for campaigning purposes for the marketing.
• Extensively used Teradata analytical functions such as RANK(), SUM /OVER,
• AVG/OVER, etc. for developing code as per the requirement.
• Performed tuning and optimization of complex SQL queries using Teradata Explain. Created several custom tables, views and macros to support reporting and analytic requirements
• Involved in the design and development of mappings from Oracle database to target database.
• Involved in performance tuning of the mappings by doing necessary modification to reduce the load time.
• Used SQL tools like TOAD to run SQL queries and validate the data.
• Defined test cases and prepared test plan for testing ODS jobs.
• Written Scripts using PERL.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.

Environment: Informatica 9.0.1, Workflow Manager, Workflow Monitor, IDQ Erwin, Oracle 10g, Teradata SFDC, TOAD Version 9.0, Tidal.

Confidential, Mason, Ohio

ETL Developer

Roles & Responsibilities:

• Reading the data from the AS400 systems then written ETL Functional Design documents and ETL technical design documents for program development, logic, coding.
• Reviewed BPD’s (business process documents) and designed functional and tech. design documents.
• Used EDI to exchange process able data to Core FACET tables.
• Interacted with Business gathered Requirements and designed the Business process flow documents.
• Installed Pervasive data Integrator for the ETL processing.
• Worked partially on Oracle eBusiness Suite.
• Mapped broker data, client data of Eye Med from SFDC to FACETS.
• Mapped data from various systems to FACETS core tables.
• Helped in developing Confidential Vision claim’s module.
• Mapped data from core FACETS to Hyper data warehouse.

Environment: Pervasive 5.0 data integrator, Workflow Manager, Workflow Monitor, IDQ Erwin, Oracle 10g, Facets.

Confidential

Oracle-Informatica Developer

• Interacted with end users to gathering requirements.
• Created Database objects including Tables, Synonyms and Indexes
• Created materialized views to increase the performance of queries.
• Performed analysis of the data transformations and data types for transforming business rules into transformation logic to be used in the ETL process.
• Involved in developing source to target mappings and scheduling Informatica sessions.
• Added and modified Informatica mappings and sessions to improve performance, accuracy, and maintainability of existing ETL functionality. Recommended additions and modifications where appropriate.
• Created various UNIX shell scripts for Job automation of data loads.
• Obtain requisite client approval of the test results and migrate the code to the live production environment.

Environment: Informatica Power Center 5.1, Oracle 8i, Toad, UNIX, Windows 2000.