SUMMARY

• Excellent of ETL/DW/BI experience using Informatica PowerCenter 9.5/9.1/9.0.1/8.6/8.5/8.1/7.1/7.0/6.2 (Workflow Manager, workflow Monitor, Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica PowerMart 6.2/6.1/5.1.2/5.1.1/4.7, Datamart, ETL, OLAP, ROLAP, MOLAP, OLTP, IMS Data, Star Schema, Snowflake Schema, Trillium 7.0, FirstLogic, IBM DB2 8.2, DB2 Toad 4.0, FTP - PRO client 32, Windows XP, UNIX, Main frames AIX.. Well versed with Informatica Team based development (Versioning).
• Strong experience with Pentaho in designing, developing, implementing, integrating, customizing, deploying and maintaining BI solution.
• Strong knowledge of various development tools of Pentaho - Pentaho Design Studio (PDS), Pentaho Report Designer (PRD), Pentaho Analyser, Pentaho Workbench, Community Dashboard Framework (CDF), and Pentaho BI Server.
• Experience in IBM CICS, MQ and WebSphere as source/target system.
• Provided technical support to the Teradata project team to help assure that Informatica solutions are designed and developed in the optimal manner and in accordance with industry and Informatica best practices
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man).
• Extensive experience using Oracle 11g/10g/9i/8i, DB2 8.2/7.0,Teradata 13.10/12, MS SQL Server 2012/2008/2005//2000, MS Access 7.0/’97/2000, Oracle Report Writer, SQL, XML, PL/SQL, SQL*Plus, SQL*Loader, Win 3.x/95/98/2000, Win NT 4.0 and Sun Solaris 2.x.
• Extensive development experience for the Extraction, Transformation and Loading of data from multiple disparate sources such as Oracle, MS SQL Server, DB2, Teradata, Flat Files, Cobol Files, XML Files into ODS (Operational Data Store) and EDW (Enterprise Data Warehouse) systems. Solid Expertise in Creating Migration Document and expertise in creating Functional and Technical Documentation for ETL.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Experience working with Real-time Data Integration, proficient in Web Service concept, big data.
• Experience working with Scheduling tools Autosys, Control M and Maestro.
• Experience in Performance Tuning of sources, targets, transformations and sessions.
• Good Knowledge of using ERWIN 7.2/4.5/4.0 to design Data Modeling, Star /Snowflake Schema, FACT & Dimensions tables, Physical & logical data modeling
• Expert in Business Intelligence using Business Objects XI/6.5/6.0/5.1/5.0, Cognos Impromptu 7.0/6.6/6.x, Micro strategy.
• Strong written and oral communication skills. Excellent conceptualization and analytical skills.

TECHNICAL SKILLS

Technical Skills: Informatica PowerCenter 9.0/8.6/8.5/8.1/7.1/7.0/6.2/6.1, Teradata 13.10, Fast Load, Fast Export, Multi Load, TPT, BTEQ, Putty, Informatica PowerMart 6.2/6.1, Datamart, ETL, OLAP, ROLAP, MOLAP, OLTP, IMS Data, Star Schema, Snowflake Schema, Netezza data warehouse appliance, Aginity Workbench for PureData System for Analytics, Web Services consumer and provider technology, Oracle Agile PLM, E-Business Suite, ActiveMQ, JMS Queue, UNIX, Main frames AIX. Business Objects XI/6.5/6.0, Cognos Impromptu 7.0/6.6/6.x, Micro strategy, Erwin 7.2/4.5/4.0/3.5.2/2.x, Visio, Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams. Oracle 11g/10g/9i/8i/8.x/7.x, DB2 8.0/7.0/6.0, Teradata, XML and Cobol files, V2R5/V2R4, MS SQL Server2012/ 2008/2005/2000, PL/SQL, CA Autosys, BMC Control M, Cron tab, IBM Maestro.UNIX (AIX), Windows XP/2003/2000/98, Mainframes, HTML, C, C++, Java, CSS.

PROFESSIONAL EXPERIENCE

Confidential, Massachusetts

Data Integration Lead

Responsibilities:

• Responsible to lead the overall Agile PLM and Oracle EBS Integration project as an Architect/Integration Lead
• Provided technical guidance to the team during the integration
• Oversee Agile PLM Implementation to provide necessary output for the Integration Development
• Ensure all the different pieces to the integration are well coordinated (Agile PLM, Informatica Middleware, Oracle ISG/Web services)
• Lead all the different tracks in the integration and ensure that all the deliverables necessary for the integration and all output of the integration are aligned to the architecture
• Developed in a multi-vendor environment.
• Lead a team in defining the scope of extremely complex projects, understanding a customer s issues / problems, and conceiving customer deliverables.
• Developed business consulting department's capabilities and skills.
• Acted as strong liaison between multiple parties the Agile Implementation partner, Integration team and the client
• Lead team in building strong relationships at the senior leadership levels with customers to improve services and ensure service levels are being met.
• Lead a team who work at the highest technical level of most phases of systems analysis while considering the business implications of the application of technology to the current and future business environment.
• Assisted in the migration of current Informatica ETL job streams to the new ETL environment and make the necessary changes to ensure that incremental and a data transfer jobs work as expected.
• Lead and develop multiple Integration scenarios: Pre-Release Validation, Release Submittal from Agile, Error Correction and Resubmittal from Agile and Synchronization from EBS
• Lead and develop multiple transactions, such as New Single Item W/O BOM, Multiple New Items W/O BOM, Update Item W/O BOM, Add New BOM information to an Existing Part, New Single Item W/ BOM, Update Item W/ new BOM information, Update to an Existing BOM, Mixed New & Updated Items W/ BOM, New Multi-Level BOM, New & Updated Multi Level BOM, Associate Manufacturer Part Number to Agile Item, Release MPN Changes with an MCO.

Tools and Technologies Informatica Power Center/Power Exchange 9.5, (Source Analyzer, Data warehouse designer, Mapping Designer, Mapplet Designer, Transformations Developer, Workflow Manager, Workflow monitor, Repository Manager), Oracle E-Business Suite 12.1.2, Oracle Agile PLM 9.2,ActiveMQ, SOAP UI, Linux, SQL Server 2012 database.

Confidential

Business Intelligence senior consultant /Data Warehouse ETL Senior Developer

Responsibilities:

• Become proficient on all aspects of the current environment.
• Become proficient in the current Informatica ETL job streams.
• Responsible for building ETL streams to validate data loads.
• Assist in the migration of current Informatica ETL job streams to the new ETL environment and make the necessary changes to ensure that incremental and a data transfer jobs work as expected.
• Development Pentaho tasks in designing, developing, implementing, integrating, customizing, deploying and maintaining BI solution.
• Assist in the tuning of the new Informatica job streams to reduce daily load time.
• Code and unit test modules/programs following program specifications and standards.
• Responsible for unit testing including: documenting the test plan and documenting results of executing the test plan - if necessary develop data test sets.
• Participate in various testing assignments including the development of detailed test plans.
• Responsible for bug fixes and the support of end users during User Acceptance and rollout of the solution.
• Lead/facilitate/participate in joint Application Design meetings with users and staff.
• Complete all software configuration/turnover tasks according to documented procedures and best practices.
• Contribute comments and feedback during walkthroughs of specifications, coding and test plans, as well as other construction and implementation deliverables.
• Cleary and concisely communicate status of all assigned tasks to management according to published workflows.
• Keep up to date on job related technical issues, new trends and product direction and be a resource for other team members.

Tools and Technologies Informatica Power Center 9.1, (Source Analyzer, Data warehouse designer, Mapping Designer, Mapplet Designer, Transformations Developer, Workflow Manager, Workflow monitor, Repository Manager), Pentaho Business Analytics 5.0,Pentaho Data Integration (PDI) 5.0.1, Oracle 11g, Netezza data warehouse appliance, Linux, IBM Cognos, ERWIN 7.2, SQL Server 2012 database. Putty and SSH. Aginity Workbench for PureData System for Analytics.

Confidential, Virginia

ETL senior Informatica Developer

Responsibilities:

• Worked with Business Analysts and Data Integration Architect to design the data model of Data warehouse and Claim datamart (Stars Schemas and Snow Flake Schema), using Erwin 4.5, Oracle Data modeler.
• Designed complete ETL solution for the Contract Data Fact load, wrote functional specifications and design documents.
• Provided technical support to the Teradata project team to help assure that Informatica solutions are designed and developed in the optimal manner and in accordance with industry and Informatica best practices
• Designed and developed a series of complex Business Intelligence solutions using Pentaho Report Designer.
• Used Pentaho Data Integration Designer to create ETL transformations.
• IBM CICS, MQ and WebSphere as source/target system.
• Analyzed the sources including Oracle, SAP R/3, SQL Server and Flat file, and used Power Center and Power Exchange to connect them.
• Created mappings to load into the dimension tables, facts tables and aggregated fact tables from staging area by using Transformations including Source Qualifier, Lookup, Filter, Aggregator, Sorted Procedure, Expressions, etc.
• Created and Executed workflows and Worklets using Workflow Manager to load the data into the Target Database in a predetermined manners by using different tasks including Session, Command, Decision, Event Wait, Email and Assignment.
• Used Command Task and Shell Script to communicate the Integration Service in Unix server
• Used tools and methods, such as Session log and Debugger to validate the workflow and mappings, identify bottle-necks, and troubleshoot information about data and error conditions.
• Involved in performance tuning of the ETL process by addressing various performance issues on the source side and Informatica side, such as using sorted data and Pipeline Partitioning.
• Designed and implemented the Incremental loads, including SCD type-1, 2 and 3, by create mappings with Lookup, Expression and Update Strategy transformations, etc.
• Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, COBOL files & XML Files.
• Reviewed offshore team design strategy before submitting to the client for code review and suggested necessary changes in order to meet the client standards.
• Guided and educated the offshore team members regarding the project standards and development standards.
• Reported the overall status of the work directly to the project manager in the weekly status meetings.
• Fixed issues in the mappings whenever reported related to data or a change in business logic.
• All Submission files were designed according to HIPPA standards.

Tools and Technologies Informatica Power Center 9.1/8.6, Teradata 13.10, Pentaho Report Designer 3.5/3.8

Confidential, Bloomington, IL

ETL Informatica Developer

Responsibilities:

• Composed low level design documents of ETL from source (Oracle, DB2, flat file) to target (Oracle 11g).
• Analyzed requirement documents and queried the source systems for ETL design
• Created Informatica mappings using MS Visio 2010 and write SQL override in DB2 Version 9.5
• Involved in the timeline estimation for the design, develop and implementation of the Data Mart application.
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man).
• Used Teradata utilities fastload, multiload, tpump to load data
• Using Teradata manager, Index Wizard and PMON utilities to improve performance.
• Presented the design documents in review meeting to the whole data movement team
• Communicated with testing and coding team to assist their building and testing works.
• Studied and Analyzed the Business requirement and prepared scope document, ETL specification documents according to the business requirements.
• Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, COBOL files & XML Files.
• Designed ETL mappings for the CDC (change data capture)
• Conducted design review meetings with the architect for any new requirement to get the approval and designed the mappings according to the company standards.
• Used MS Visio 2010 to populate the Informatica design flows.
• Developed Complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Sequence Generator, Joiner, Union, Filter, Update Strategy, Rank and Router transformations.
• Worked with Informatica Labels in labeling the designed components for deployment of code to TEST and PROD.
• Used Informatica versioning to check in and check out the objects in designer and workflow manager.
• Troubleshoot problems by checking sessions and error logs. Also used debugger for complex problem troubleshooting.
• Used Golden and also Toad to access the Oracle tables execute SQL queries.
• Designed complex mappings involving target load order and constraint based loading.
• Performed Performance tuning, bug fixing and error handling.
• Created parameter files for the all the designed mappings and used parameter files for defining all the connection values( Source, Target, Lookup) and mapping parameters used in the Informatica sessions.
• Used Delta loading to extract New Claims in Informatica and processed the data and loaded the target data to Oracle tables.
• Used BO for reporting purposes.

Tools and Technologies Informatica Power Center 8.6/8.1, Teradata 12, Flat Files, BTEQ, Putty Business Objects XI, Oracle 11g/10g, XML and COBOL files, Erwin 4.5, MS Vision 2010, HIPAA, ICD/CPT codes.

Confidential, NY, NY

ETL Informatica Developer

Responsibilities:

• Performed Requirement gathering from the Business Unit and end users of the proposed Product
• Designed and creation of detailed Technical Mapping document with information on implementation of business logic
• Associated with Physical and Logical Data Modeling using Erwin.
• Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, COBOL files & XML Files.
• Designed of ETL mappings for the CDC (change data capture)
• Extensively used various transformations like Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Extensively developed Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads
• Worked with slowly changing dimension Type1, Type2, and Type3
• Performed Performance tuning of the process at the mapping level, session level, source level, and the target level
• Worked closely with the project team to formulate and implement a flexible system design that meets functional requirements.
• Guided and Mentored the ETL team in Informatica
• Extensively used mapplets for use in mappings thereby saving valuable design time and effort
• Worked with various tasks like Session, E-Mail, Workflows, Worklets, and Command
• Worked with the Informatica Scheduler for scheduling the delta loads and master loads
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, and Count in the Aggregator Transformation.
• Worked SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
• Used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Focused on various re-usable tasks, workflows, Worklets, mapplets, and re-usable transformations
• Extensively worked with various Look up Caches like Static, Dynamic, Persistent, and Shared Caches.
• Worked with session logs, Informatica Debugger, and Performance logs for error handling when we had workflows and session fails
• Performed Promotion of Mappings, Workflows and other Informatica objects like sources, targets, and transformation between environments like DEV, INT, UAT and PRD-Development, Integration Testing, User Acceptance Testing, and Production.
• Extensively used Repository Manager for Promotion of XML objects from one environment to the other
• Extensively worked with Versioning of objects in Informatica with Check in and Check out options
• Worked with Third party scheduler Control M for Scheduling of Informatica Workflows.
• Worked extensively with the business intelligence team to incorporate any changes that they need in the delivered files

Tools and TechnologiesInformatica Power Center 7.0/6.2, (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Erwin 7.1, Cognos, SQL Server 2000, DB2 8.0/7.0, XML and Cobol files, UNIX, Windows Server 2003, Control M, Business Objects XI, Oracle 9i.

Confidential, Bridgewater, NJ

DW Informatica Developer

Responsibilities:

• Studied and Analyzed the Business requirement and prepared technical documents, ETL specification documents according to the business requirements.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Developed Logical and Physical data models, created the (ER) Entity Relationship diagrams & maintained corresponding documentation for corporate data dictionary with all attributes, table names and constraints.
• Designed Sources to Targets mapping using Informatica PowerCenter for their Sales and Marketing department.
• Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, COBOL files & XML Files.
• Loaded the target tables resided on to Oracle to populate the Sales Datamart.
• Performed Repository manager tasks.
• Used Trillium 7.0 and its components Parser, Geo-Coder, Matcher, Converter for Data Cleansing and Data Profiling. Studied the existing system(s) and Created facts, dimensions for the data mart.
• Analyzed IMS Rx Data using IMS tools such as Xponent and Xponent Plantrak, regarding segmentation & profiling
• Followed Ralph Kimball Methodology in designing the warehouse. Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformations.
• Performed various kinds of transformations to implement simple and complex business logic. Transformations which were used were: connected & unconnected lookups, Router, Expressions, source qualifier, aggregators, filters, sequence Generator, Update etc.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Used Informatica versioning to check in and check out the objects in designer and workflow manager.
• Designed Mapplets and Reusable Transformations to prevent redundancy of transformation usage and maintainability.
• Troubleshooting problems by checking sessions and error logs. Also used debugger for complex problem troubleshooting.
• Created Stored Procedures for data transformation purpose.
• Performed Performance Tuning on Informatica Mappings and Sessions for optimum performance.
• Designed and developed UNIX shell scripts for file watching criteria.
• Scheduled ETL jobs using Autosys.
• Maintained Development, Test and Production mappings.
• Used Cognos to create various reports.

Tools and Technologies Informatica Power Center 6.1/5.1(Source Analyzer, Data warehouse designer, Mapping Designer, Mapplet Designer, Transformation developer, Workflow Manager, Workflow monitor), Oracle 8i, Erwin 4.0, Trillium (Parser, Geo-Coder, Matcher, Converter), Autosys 3, Power Exchange, Cognos 7.0,Mainframes, IMS Rx Data, SQL Server 2000, SQL*Plus, SQL*Loader, XML and Cobol files, Windows NT 4.0, Unix, Shell Scripting.