SUMMARY:

• Over Fifteen Years of IT experience and Six plus Years with professional work experience in Data Warehouse/Data Mart/Data Integration/Data movement ETL design, development and support using Informatica Power Center.
• Expertise in implementing complex Business rules by creating robust Informatica mappings, mapplets, and reusable transformations using Informatica Power Center.
• Extensive project development experience using Oracle (8.0 to 10g), DB2, Informix as the main RDBMS under many platforms and using different combination of tools. ave used Ralph Kimball methodology in data warehouse/mart development.
• Working Knowledge on different data sources as Flat Files, Oracle, DB2, Power Exchange for Mainframe.
• Experience with complex mappings and mapplets using Expression, Filter, Sorter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank.
• Experience in creating Sessions, Workflows, and Worklet by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer.
• Deep experience in creating the mapping, workflow, testing the flow and monitoring the job.
• Experience in Unix/Linux Shell scripting, scheduling cron jobs, Informatica PowerCenter scheduling, Tivoli workgroup(TWS).
• Used Debugger to validate/test/debug the mappings and gain troubleshooting information about data and error conditions.
• Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance.
• Experience with pre - session and post-session Scripts/SQL commands.
• Excellent problem solving skills with a strong background and good interpersonal skills.
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.

TECHNICAL SKILLS:

ETL Tools: Informatica (Power Center 9.5.1/8.6.1/8. X/7.X), Power Exchange 8.6.1, Power Exchange Navigator

Operating Systems: Windows 2000/NT/98/95, Linux, Sun Solaris 2.x, HP-Unix, IBM Z/OS, IBM OS/390

RDBMS: Oracle 8i/9i/10g(SQL, PL/SQL, Stored Procedures, Functions), DB2 LUW, Teradata, DB2, Informix, SQL Server, MS Access

Data Base Tools: TOAD, SQL Plus, PL/SQL Developer, Teradata SQL Assistant

Data Modeling: Erwin

Reporting Tools: Business Objects, Cognos

Scripting: Unix/Linux Shell Scripting.

Languages: COBOL, PL/SQL,, C, JAVA, C#, HTML

Mainframe Skills: IBM OS/390, Z/OS, COBOL/390, DB2, CICS, VSAM, JCL, TSO/ISPF, QMF, SPUFI, Expediter, Intertest, Endevor, Changeman, Infoman, CA-7, NDM, etc

Informix RDBMS, Informix: 4GL, Informix SQL.

Functional Areas: Property & Casualty, Healthcare, Credit Card, County Welfare, Child Support Enforcement, Workers Compensation, Inventory and Manufacturing, Medicaid Overpayment Recovery

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Developed, tested and implemented Confidential VLS to MSP migration of Confidential loan data.
• This project was done on a Agile (Scrum) framework in two week sprints.
• Developed several Informatica mappings/mapplets/session and other tasks/workflows and worklets/scripts.
• Also involved in analyzing Oracle Stored Procedures of MSMIT, to identify data not getting loaded into several of their tables.
• This involved going through different levels of table loads in stored procedures.

Environment: Informatica-Power Center 9.5.1, Linux, JIRA, Microsoft Office, Oracle 11g, Oracle SQL Developer, etc

Confidential, Dallas, TX

Informatica ETL Developer

Responsibilities:

• Developed and tested the Intraday changes to Confidential system jobs (linux shell scripts and Informatica workflows/mappings).
• Migration tested Confidential shell scripts and informatica workflows from Informatica 8.6.1 to Informatica 9.5.1.
• The informatica server moved from Unix Solaris to Redhat Linux. Involved in correcting the shell scripts, informatica workflows/worklets/mappings for this migration.

Environment: Informatica-Power Center 8.6.1 & 9.5.1, Unix, Linux, Microsoft Excel 2010,Oracle 11g, PL/SQL Developer, etc

Confidential, Garland, TX

Informatica ETL Developer

Responsibilities:

• Worked for the Enablon project dealing with migration of Confidential (Environmental, Health and Safety) data from diverse databases to one Global Enablon platform(Windows Server based).
• My main responsibility as a Informatica ETL Developer Analyst being to understand the structure of the source data usually as a Confidential file, the transformations that need to be done based on the data mapping document, and develop the ETL Mappings/Workflows, test and execute the ETL workflows to create the Confidential load files.
• Many times it is iterative in nature as the requirements changed and need to modify the ETL drastically.
• Transformations used include Source Qualifier, Exprssions, Filter, Router, Sorter, Aggregator, Joiner, Sequence Generator, etc.

Environment: Informatica-Power Center 8.6.1, Linux, Microsoft Excel 2010,Oracle 11g, SQL Developer, etc

Confidential, Irving, TX

Informatica ETL Developer

Responsibilities:

• Requirement and Design of ETL process for Account Receivable functionality to load AR tables with data extracted from OLTP database tables.
• Completed loading of the main AR table at grain level and four Summary tables based on Medicare Contracts.
• Various Complex transformations and PowerExchange sources were used.
• Created PowerExchange Datamaps from Mainframe production datasets for SAS to Database loads and created Mappings/Worflows for old AR loads.
• Pipeline partitioning used in sessions- Database in Source and Targets, Pass through or Round Robin in transformations.
• Created post session shell scripts to do post session linux server level tasks or send emails.
• Command, Decision, Event Raise, Event Wait tasks created in different workflows.
• Enhancement and programming support for AR, Daily Carrier, Monthly Carrier, COB Match, MSE, Resource Loads and Master File loads implemented in Informatica.
• Many of these load using Power Exchange from Mainframe files to DB2 tables.
• Used PowerExchange to create datamaps and Relational Connections.
• Production support provided as needed for AR, COB Match and MSE loads.

Environment: Informatica-Power Center 9.5.1 & 8.6.1, Informatica Power Exchange 8.6.1, Power Exchange Navigator, DB2 LUW, Linux, SQL, TOAD, Tivoli (TWS), Harvest, Endevor, TSO/ISPF, JCL, etc

Confidential, Monroe, LA

Data warehouse ETL Developer

Responsibilities:

• As a Informatica ETL developer, I was involved in creating a datawarehouse for the Day1 project dealing with combining the operational and historic data from the three disparate entities and providing a combined business intelligence analytical reporting.
• Involved in implementing Informatica ETL workflows to source Embarq Customer & Billing data housed in Teradata database and to load into Oracle Target staging tables.
• Developed SCD Type2 work flow to refresh the Customer Dimensional table from the staging tables both housed in Oracle 10g databases.

Environment: Informatica-Power Center 8.6.1, Oracle 10g, Teradata, Unix, SQL, PL/SQL, PL SQL Developer, Teradata SQL Assistant, Windows

Confidential, Dallas, TX

Data warehouse ETL Developer

Responsibilities:

• Used Informatica Powercenter ETL to standardize data from various sources and load into Data Stage area, which was in Oracle.
• Worked on Informatica Power Center tools - Source Analyzer, Target designer, Mapping and Mapplet Designer, Transformations Developer, Informatica Repository Manager, Informatica Workflow Manager, Workflow Monitor.
• Developed PL/SQL Stored Procedures/Functions.
• Informatica Designer tools were used to design the source definition, target definition and transformations to build mappings.
• Designed and Developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (Fact/Summary) data identified by dimensions using Informatica Power Center tool.
• Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy.
• Created and scheduled workflows based on demand, run on time and run only once using Workflow Manager.
• Monitored Workflows and Sessions using Workflow Monitor.
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Precise Documentation was done for all mappings and workflows.
• Used Debugger in troubleshooting the existing mappings.

Environment: Informatica-Power Center 8.x, Oracle 10g, DB2, Unix, SQL, PL/SQL, Windows NT, Power Exchange.

Confidential, DALLAS, TX

Data warehouse ETL Developer

Responsibilities:

• Involved in development of various Informatica mappings.
• Various transformations (Source qualifier, Aggregators, Connected &unconnected lookups, Filters &Sequence) were used to handle situations depending upon the requirement.
• Called stored procedures perform database operations on post-session and pre-session commands.
• Performed Unit Testing and tuned for better performance.
• Involved in writing UNIX shells scripts to run the workflows.
• Precise Documentation was done for all mappings, workflows.

Environment: Informatica PowerCenter 7.x, Oracle 10g, PL/SQL, TOAD, MS OFFICE.