• System: Unix, Linux, Windows Database: Oracle 11g, Netezza, MS-SQLServer, MySQL, Teradata on NCR, Informix 8.x, Vertica Languages and BI Tools:
• Informatica PowerCenter 9.x, Netezza SQL, Oracle PL/SQL, utPL/SQL, T-SQL, K-shell w/vi editor, Business Objects Web-Intelligence WEBI , Business Objects Universe Designer, Tableau 8,
• Control-M, Maestro TWS, ERWin, TOAD, AquaData Studio, ServiceNow, Rational ClearCase, Rational ClearQuest, MicroFocus Cobol. IBM Mainframe, CICS, DB2, Cobol II, JCL.

EMPLOYMENT HISTORY

Confidential

Sr. Informatica Specialist

• Informatica 9.x Data Integration Design, Development, Maintenance
• Support Experian's Brazil Me Prejora DOS. Nightly Load to
• Develop Functional, Technical, Test Plan documentation
• Troubleshoot failed data transport interfaces
• Support DataMigration SQL-Server to Netezza

Confidential

Consultant Employee Sr. Informatica Specialist

• Informatica 9.x Data Integration Design, Development, Maintenance
• Support EAI Framework components within the company to facilitate data transport middleware infrastructure
• Make use of SAP BAPI/RFC Informatica Transformations
• Develop Functional, Technical, Test Plan documentation
• Troubleshoot failed data transport interfaces

Confidential

Contract Consultant Sr. Informatica Specialist

• Informatica Sub-Contractor employed by Charter Global Inc. supporting Deloitte Consulting's engagement with the Federal Government to support their IRDM/AUR projects.
• Informatica 9.x Data Integration Design, Development, Maintenance
• Developed an Informatica 'Continuous Integration' process that incorporate Informatica command-line utilities, Rational ClearCase command-line utilities, utPL/SQL, shell-scripting in order to support a continuous and synchronized Informatica Unit Test environment with multiple release versions and the flexibility to select from several release versions for promotion to the Informatica SAT System Acceptance Test environment.
• Developed Informatica Based automated unit test process for executing sessions and scoring results based on business rules stored as parameter variables. Results are versioned for reference when needed as part of a build release.
• Developing a solution for Dynamic Source definitions.

Confidential

Employee Sr. Business Systems Analyst

• Support the company's TurboTax Consumer Group Business Analytics initiatives using the latest Database and Business Intelligence technologies.
• Gather, understand, procure approval of Business System requirements
• Business Objects 3.1 Universe Design, Develop, Maintenance
• Business Objects WEBI XI Report/Dashboard Design, Develop, Maintenance
• Informatica 9.1 Data Integration Design, Develop, Maintenance
• Informatica Cloud with Salesforce Integration
• Translate SSIS mappings to Informatica mappings.
• Design, Develop, Test and Deliver Business Intelligence Solutions to various BUs
• SDLC
• Manage customer engagement
• Big Data exploration Intro to Hadoop, NoSQL, Pig, Hive, ODBC Business Intelligence layer
• Predictive Analysis initiatives.

Confidential

Contract Consultant

• Project Enterprise Data Warehouse Finance
• Sr. ETL Architect/Programmer/Analyst
• Support the company's Enterprise Data Warehouse ETL for Finance reporting
• Informatica 8.6.1 ETL Extraction-Transform-Load Architect, Design, Code, Test, Implement, and support mappings and workflows.
• Oracle 11g PL/SQL Development within ETL
• Data Warehouse Design, Star Schema, including dimensional modeling.
• Production Support. Rotating Support of Informatica Batch DW Loads

Confidential

Contract Consultant

Sr. Data Analyst/Architect

• Support the company's TurboTax customer loyalty initiatives via
• Design and develop Netezza SQL Analysis on over 8T and growing database
• Familiarized with internal processes to quickly identify and resolve filer issues with software releases so that customer relationships can be improved.
• Predictive Analysis initiatives.

Confidential

Contract Consultant

Sr. ETL Architect/Programmer/Analyst

• Support the company's Firethorn Data Warehouse ETL and BI reporting initiatives, executive dashboard, KPI, etc.
• Informatica 8.6.1 ETL Extraction-Transform-Load Architect, Design, Code, Test, Implement, and support mapping and workflows.
• Oracle 10g PL/SQL Development within ETL
• Data Warehouse Design, Star Schema, including dimensional modeling.
• Data Warehouse Design, Star Schema, ER-Win.
• Control-M Development and Support
• Production Support. Rotating Support of Informatica Batch DW Loads

Confidential

Employee - Sr. Data Warehouse Analyst/Architect

• Support the company's IRIS Data Warehouse and BI reporting initiatives, executive dashboard, KPI, etc.
• Informatica 8.6.1 ETL Extraction-Transform-Load Architect, Design, Code, Test, Implement, and support mapping and workflows.
• Informatica 8.6.1 Administration monitor system, ensure continuous availability.
• Install, upgrade, and apply patches and version updates across Dev, QA and Prod environments.
• SQL-Server 2008 T-SQL
• Translate SSIS mappings to Informatica mappings.
• Data Warehouse Design, Star Schema, including dimensional modeling.
• Business Objects Universe Development, Web-Intelligence Report Development and Central Management Console Administration
• Microsoft Analysis Services Executive Dashboard KPI cube design

Confidential

Employee - Sr. Data Analyst/ETL Architect

• ETL Extraction-Transform-Load data integration team
• Spearhead and contribute to data integration systems projects using Informatica 8.1.x, Informatica 7.1.x, Oracle 9i, 10g, PL/SQL
• Design, code, test, deploy, support data integration systems and subsystems using disparate data feeds to maintain a large Customer/Account OLTP system, FEDR Data Warehouse and provide time critical DSS reports
• Experience with Informatica 8.x Data Quality and Data Profiling modules
• Production Support, Monitor, Troubleshoot, Recover and Tune Informatica Workflows
• Informatica 8.x Administration monitor system, ensure continuous availability. Install, upgrade, and apply patches and version updates across Dev, QA and Prod environments.

Informatica Support Liaison

Confidential

Employee - Sr. Data Analyst/ETL Architect

• ETL Extraction-Transformation-Load data integration team member
• Spearhead data integration systems projects using Informatica 7.1, Oracle PL/SQL and BMC Control-M.
• Design, code, test, deploy, support data integration systems and subsystems using disparate data feeds to maintain a large Customer/Account OLTP system and supply downstream systems.
• Production Support, Monitor, Troubleshoot, Recover and Tune Informatica Workflows

Confidential

Contract Consultant

• ETL Extraction-Transformation-Load development with Informatica 7.1 and Oracle PL/SQL for data integration of web-based vehicle order management system.
• Develop K-shell scripts to invoke Informatica Sessions programmatically
• Support TOMS database development using ER-Win
• Support Oracle Stored Procedures and Functions to support Informatica Transformation
• Support nightly Subset Upload production load process
• Support Informatica production builds
• Project TOMS November 2002 to Oct 2004
• ETL Extraction-Transformation-Load development with Informatica 6.x/7.x and Oracle PL/SQL for data integration of new OLTP, Object-Oriented relational database, web-based claim/warranty system.
• extract RDBMS data, transform it, and send it back up to VSAM Legacy environment
• Create, Support, Monitor, Troubleshoot, Recover and Tune Informatica Sessions with Informatica Repository Manager, Designer, Server Manager.
• Set up and execute Informatica Sessions in batch and stand-alone.
• Develop Oracle Stored Procedures and Functions to support Informatica Transformation.
• Develop K-shell scripts to invoke Informatica Sessions programmatically

Confidential

• ETL Extraction-Transformation-Load development with Informatica 5.1 and Oracle PL/SQL for large Parts data warehouse.
• Experience with ODS Operational Data Store , Data Mart Design, and Slowly Changing Dimensions including Data Warehousing development methodologies.
• Create, Support, Monitor, Troubleshoot, Recover and Tune Informatica Sessions with Informatica Repository Manager, Designer, Workflow Manager.

Confidential

Contract Consultant

• ETL Extraction-Transformation-Load development with Informatica 5.1 and Oracle PL/SQL for Very Large CRM database
• Design and Develop Informatica Transformation Logics and Mappings
• Experience with ODS Operational Data Store , Data Mart Design, and Slowly Changing Dimensions including Data Warehousing development methodologies
• Create, Support, Monitor, Troubleshoot, Recover and Tune Informatica Sessions

Confidential

• Employee - Sr. Data Warehouse Administrator/ETL Developer, Oct 1999 to Feb 2002
• ETL Extraction-Transformation-Load development with Informatica 1.6.2 and Oracle PL/SQL for Very Large Over One terabyte CRM database.
• Design and Develop Informatica Transformation Logics and Mappings.
• Experience with ODS Operational Data Store , Data Mart Design, and Slowly Changing Dimensions including Data Warehousing development methodologies.
• Support Monitor, Troubleshoot, Recover and Tune Informatica Sessions with Informatica Server Manager.
• Oracle 7 and 8 DBA for Large CRM database on Sun Solaris platform. Duties include database design, creation, administration, installation, upgrades, backup and recovery, migration, tuning, space allocation, object maintenance, support liaison.
• Support Migration of Oracle Householding DW to Teradata utilizing Informatica and BTEQ scripts.
• Assist in design of Householding DW Structure for Teradata using ER-Win

Confidential

Employee

• Sr. Oracle DBA/Manager Business Systems Support,
• Managed a website production team consisting of Oracle DBAs and Oracle database developers.
• Supported on-sight development and staging database as well as production and standby Oracle instances at the website in San Jose, CA.
• Database design, creation, administration, installation, upgrades, backup and recovery, migration, tuning, space allocation, object maintenance, support liaison.

Confidential

Contract Consultant

Oracle 7 and 8 DBA on various Sun Solaris platforms. Duties include database administration, installation, upgrades, backup and recovery, migration, tuning, space allocation, object maintenance, support liaison. Went perm. see above

Confidential

Contract Consultant

• Retek Retail Software implementation. Converting Pick POS to Retek system on Oracle 8.
• Develop and execute QA Test plans for Oracle/Pick interfaces using Pro-C, PL/SQL, SQL-Plus, HP-UX.

Confidential

Employee - Sr. Database Engineer

• RDBMS design, administration and Oracle PL/SQL programming for Shop Floor 2000, a client/server application used by Boeing and other companies to replace costly paper trail when manufacturing jets or other products produced on the shop floor.
• Font-End programming using in-house development tools with Borland Delphi.
• Work closely with the customer on-site to configure and implement the product on their back-end. Professionalism and communication are vital.

Confidential

Employee - Database Administrator/Cellular Network Analyst

• Designed, built and administrate very large DSS database on Oracle 8.0.4.
• Duties include database installing, creating and maintaining database objects, database tuning including index creation, SQL tuning, backup and recovery, disk space maintenance and planning.
• Provide DSS support including data collection, parsing, storage, queries, reports front end for various Network Elements STP, HLR, SWITCH MPs, SWITCH config files, ICBH, SYSBH, Cluster, etc. .
• Data is used by every department within engineering and throughout the company including finance and customer service departments.

Confidential

Employee - Programmer/Analyst

• Provide DSS support to IS management for trending analysis and presentations to upper finance management regarding performance of company products and services.
• Estimate, design, code, maintain and test subsystems and utilities for an OLTP Client/Server customer management system for over 800 branches nationwide using SQL embedded in Microfocus Cobol on IBM OS/2 platform.
• Coordinate and facilitate the electronic transfer of customer/account data between HQ and branch location and between branch openings, closings and relocations.
• Provide Client/Server LAN system software support to branch users.