SUMMARY

• Eighteen Plus (18+) years of total IT experience in Requirements Analysis, Application Design, Coding, Development, Testing and Implementation of Business applications. Expertise with RDBMS, Data Warehouse, ETL, OLAP, and Client/Server applications. Companies/Clients worked for include Confidential (catalog sales), Confidential (data warehouse/Logistics), Conagra (Food/Logistics), Skillsoft (Educational), Pactiv (Packaging), Circle International (Shipping), McDonald’s (Food), MTI Vacation (Travel), and Allstate (Insurance).
• Ten Plus (10+) years of ETL using Informatica PowerCenter 8.5/8.1/7.1/6.2, (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Informatica server), ETL, OLAP, OLTP
• Nine Plus (9+) years of experience working on implementation of Data Warehouse applications and Strong understanding of Data Warehouse concepts, ETL, Star Schema, FACT & Dimensions tables
• Strong programming experience in Transact SQL, SQL, PL/SQL, Complex Stored Procedures, and Triggers
• Ten Plus (10+) years of Database experience using Oracle 9i/8i/8.x/7.x, DB2/400, MS SQL Server 2000/7.0/6.5, MS Access 7.0/2000, PL/SQL, SQL*Plus, SQL*Loader Win 3.x/95/98/2000, Win NT 4.0 and Sun Solaris 2.x., TOAD & ODBC interfaces to Oracle
• Ten Plus (10+) years experience in performing all functions of System Development Life Cycle including writing Design documents and Test plans and conduct Unit and System testing.
• Three Plus (3+) years of Hands on Experience working with scheduling tools like Control M, FTP Connect Direct, Autosys, Clearcase, Clearquest, Unix scripting.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 8.5.x/7.1/6.2/6.0/5.1 (Workflow Manager, Workflow Monitor, Worklets, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations,), ETL, OLTP, OLAP, Control M, Connect Direct

EDI / Integration: EDI transactions including 943, 944, 945, 947, and 852 transactions plus flat files on varying formats

Business Intelligence: Cognos Series 6.0 (Impromptu & PowerPlay)

Programming: SQL, PL/SQL, SQL*Plus 3.3/8.0, Visual Basic 6.0/5.0, Unix Shell Scripting, Cobol, RPG, CL

Data Bases: Oracle 9i/8i/8.0, SQL, PL/SQL, SQL*Plus, SQL*Loader, IBM DB2/400 MS SQL Server 2005/2000/7.0/6.5, DB2, MS Access 7.0/2000

PROFESSIONAL EXPERIENCE

Confidential

Architect

Responsibilities:

• Monitored a job scheduler call Tidal. Addressed and job that failed.
• Installed an instance of Informatica 9.1
• Used debugging techniques and log information to determine why a job failed
• Coded all workflows, sessions, and mappings involved in Investments project
• Used SDLC as the methodology to create and promote all code.
• I did a great deal of coding using the job scheduler Tidal

Confidential

Developer

Responsibilities:

• Analysis, design and implementation of Talend job that will import data into the current web based search engine. Extensive development of Talend jobs and subjobs that included the following characteristics:
• MYSQL Server Table Inputs into SOLR.
• Use of numerous Talend components including: lookup, custom components, and flat files.
• Documentation and maintenance of all procedure and work instruction documents related to training, support, and admin procedures.
• Used Agile methodology.

Confidential

Technical Analyst

Responsibilities:

• Analysis, design and implementation of numerous Talend jobs that will import legacy data into the current MDW. Extensive development of Talend jobs and subjobs that included the following characteristics:
• SQL Server Table Inputs into DB2.
• Use of numerous Talend jobs including: lookup, expression, and filter.
• Designed, developed, saved, tested and exported Talend ETL java code
• Performed unit, integration and system testing of the Talend ETL jobs.
• Documentation and maintenance of all procedure and work instruction documents related to training, support, and admin procedures.

Confidential

Technical Analyst

Responsibilities:

• Analysis, design and implementation of numerous Informatica workflows that will import legacy data into the current MDW. Extensive development of Informatica mappings and workflows that included the following characteristics:
• Flat File Inputs and outputs from various sources in DB2.
• Intermediate Work Files or staging tables
• Use of numerous Informatica transformations including: connected and unconnected lookup, expression, router, joiner, and filter.
• Development of mapplets as reusable code when appropriate and update of worklets and workflows to create new sessions.
• Documentation and maintenance of all procedure and work instruction documents related to training, support, and admin procedures.
• Unix scripts. Informatica 8.6

Confidential

Technical Analyst

Responsibilities:

• Analysis, design and implementation of numerous RPG programs.
• Main responsibility was Advanced Shipping Notification. 856
• Embedded SQL in RPG4 Some CL programming.

Confidential

Project Lead / Architect

Responsibilities:

• Analysis, design and implementation of numerous Informatica workflows that will create the data interfaces to communicate with vendors. Extensive development of Informatica mappings and workflows that included the following characteristics:
• Flat File outputs from various sources including Oracle.
• Oracle Server Staging Tables
• Intermediate Work Files or staging tables
• Use of numerous Informatica transformations including: connected and unconnected lookup, expression, router, joiner, and filter.
• Development of mapplets as reusable code when appropriate and update of worklets and workflows to create new sessions.
• Documentation and maintenance of all procedure and work instruction documents related to training, support, and admin procedures.
• Ran SDF, Maestro scripts, and Unix scripts.

Confidential

Informatica Analyst

Responsibilities:

• Analysis, and implementation of numerous Informatica applications and data interfaces involving the data conversion. Extensive development of Informatica mappings and workflows that included the following characteristics:
• Flat File outputs from various sources including Oracle and Hyperion.
• Oracle Server Staging Tables
• Intermediate Work Files or staging tables
• Outputs formatted for Star scheme.
• Use of numerous Informatica transformations including: connected and unconnected lookup, expression, router, joiner, and filter.
• Development of mapplets as reusable code when appropriate and update of worklets and workflows to create new sessions.
• Documentation and maintenance of all procedure and work instruction documents related to training, support, and admin procedures.
• Ran Autosys, jils design and Unix scripts.
• Wrote jils and scripts to execute the DAC and query the DAC status.

Confidential

Informatica Analyst

Responsibilities:

• Analysis, and implementation of numerous Informatica applications and data interfaces involving the data conversion. Extensive development of Informatica mappings and workflows that included the following characteristics:
• Flat File outputs from various sources including Mani frame and SQL server.
• SQL Server Staging Tables
• Intermediate Work Files for Routing
• Outputs formatted for SAP database.
• Use of numerous Informatica transformations including: connected and unconnected lookup, expression, router, joiner, filter.
• Development of mapplets as reusable code when appropriate and update of worklets and worklows to create new sessions.
• Documentation and maintenance of all procedure and work instruction documents related to training, support, and admin procedures.

Confidential

Informatica Analyst and Developer UNIX Scripting

Responsibilities:

• Analysis, design, and implementation of numerous Informatica applications and data interfaces involving data warehousing. Extensive development of Informatica interfaces that included the following characteristics:
• Flat File inputs from various sources including Japan data warehouse, SMART (bill of materials), US data warehouse
• Oracle Staging Tables
• Intermediate Work Files for Routing
• Outputs formatted for various data warehouses
• Use of numerous Informatica transformations including: connected and unconnected lookup, expression, router, joiner, filter, aggregator, and update strategy
• Development of mapplets as reusable code when appropriate and update of worklets and worklows to create new sessions.
• Extensive Unix Shell Script Development to run Informatica jobs and to implement needed job streams
• Documentation and maintenance of all procedure and work instruction documents related to training, support, and admin procedures.

Confidential

Informatica Analyst, Lead, Developer

Responsibilities:

• Analysis, design, and implementation of numerous Informatica applications and data interfaces involving warehousing, inventory, and product data.
• Extensive development of Informatica interfaces that included the following characteristics:
• Outputs formatted for Manugistics, Numerous SAP Instances, and RedPrairie
• Implementation of EDI transactions using Informatica interfaces including 943 Warehouse Stock Transfer Shipment Advice, 944 Warehouse Stock Transfer receipt Advice, 945 Warehouse Shipping Advice, 947 Warehouse Inventory Adjustment Advice, and 852 Product Activity Data transactions
• Informatica Development using versions 6.2 and 7.2 (Designer, Workflow Manager, Workflow Monitor, and Repository Manager).
• Use of numerous Informatica transformations including: connected and unconnected lookup, expression, router, joiner, filter, aggregator, and update strategy
• Development of mapplets as reusable code when appropriate and update of worklets and worklows to create new sessions.
• Extensive Unix Shell Script Development to run Informatica jobs and to implement needed job streams
• Extensive development of PL/SQL stored procedures to assist in research and transaction tracking
• Participation in meetings with business users to identify, document, and implement their business requirements
• Documentation and maintenance of all procedure and work instruction documents related to training, support, and admin procedures.
• Monitoring of batch execution job schedules
• Immediate response from 7am * 7pm (Monday * Friday) on system alerts, ticket requests, and user requests.
• After hours and weekend coverage for mission critical production applications. (On call rotation)
• Response to emergencies and escalation as appropriate internally and to external vendors.
• Migration of changes, enhancements, upgrades, etc. through the various environments.
• Confirmation that all support requests are properly approved, documented, and communicated using the appropriate tools. As well as documentation of common issues and resolution procedures.
• Open, dispatch, and close cases in ticketing system.
• Analysis and consultation regarding the potential impact new projects or proposed functionality enhancements might have on current applications.
• Troubleshooting of complex issues in Oracle (database and SQL).
• Preparation of ongoing status reports to communicate to technical and business managers the status of work undertaken

Confidential

SR. DW DEVELOPER

Responsibilities:

• Collection of requirements from business users and analysis based on the requirements.
• Design and development of Data marts using Star Schema.
• Creation of Data Acquisition and Interface System Design Document.
• Creation of Source and Target Definitions in the repository using Informatica Source Analyzer and Warehouse Designer.
• Identification of source systems, connectivity, tables, and fields to ensure data suitability for mapping.
• Collection of data from source systems into database.
• Design and development of complex Informatica mappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of the data between various applications.
• Creation of sessions and execution of them to load the data from the source system using Informatica Workflow Manager.
• Development and documentation of Data Mappings/Transformations, and Informatica sessions as per the business requirements.
• Assistance to other ETL Developers in resolving complex scenarios.
• Research sources and identification of key attributes for Data Analysis.
• Development of Complex mappings in Informatica to load the data from various sources using different transformations like Custom, Union, Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations. Used debugger to test the mappings and fix any bugs.
• Development of Mapplets using corresponding Source, Targets and Transformations.
• Execution of sessions, sequential and concurrent batches for proper execution of mappings and sending of e - mail using server manager.
• Documentation of the mappings used in ETL processes.
• Design of source qualifier from File, Relational and Normalize Systems. Assisted in Migrating Repository.
• Design and development of the Informatica workflows/sessions to extract, transform and load the data into Target. Created database triggers for Data Security.
• Development of Informatica Mappings/Sessions to populate the Data Warehouse and Data Mart.
• Error checking and testing of the ETL procedures and programs using Informatica session log.
• Development of canned and ad hoc reports using Cognos
• Design and development of Oracle PL/SQL Procedures and creation of SQL, PL/SQL script code for extracting data to system
• Integrated testing for various mappings. Testing of the data and data integrity among various sources and targets.

Confidential

DW DEVELOPER

Responsibilities:

• Work with Business analysts for requirement gathering, business analysis, and testing and project- coordination.
• Analysis of source data and gathering of requirements from the business users.
• Enhancement and support of shipment and forecasting reports, and data cubes using Cognos tools and products.
• Preparation of technical specifications
• Guidance of the Testing team to understand the business logic.
• Creation of Test cases and completion of unit, integration, functional and regression tests for sales and marketing data mart system.
• Liaison between the Testing Team and the Mappings Developments Team.