SUMMARY:

• Principal Informatica ETL Architect Data Engineer of overall system design, development of source extraction, cleansing, conversion, & loading of data to/from various systems such as ERP / Databases / Mainframe Systems / Operating Systems / Scripting / Programming languages / Business Intelligence Tools used to identify real time & historical data patterns to maximize a corporation’s profitability as well as to identify new streams of revenue.
• Handling of Data feeds, Large Data Sets and VLDB.
• 23 years of real world hands - on professional systems development experience. 20 years of Informatica internal product knowledge and experience gained through real world hands on experience.
• Possessed System / Database Administrative & Application Development Life Cycle skill sets before learning Informatica to form a solid technical foundation and become effective.
• Excellent Analytical, Problem Solving, & Interdisciplinary Skills with Mathematics / Physics / Probability & Statistics Training.
• Two decades of Corporate experience providing
• Creative & Innovative Solutions.

TECHNICAL SKILLS:

Informatica: PowerCenter 1.xx - 9.xx, PowerExchange, Metadata Manager, Data Warehouse Profiling

Databases: Oracle 7.xx - 12g RAC, SQL Server, Teradata, Mysql, Sybase, Informix,, DB2

Operating Systems: Unix (Solaris, HP-UX, AIX), Linux, Win 2000/XP/2003/2008, IBM / Unisys / MVS Mainframes

ERP/MRP: Siebel, SAP, Peoplesoft, Oracle Financials

Programming: C++, C, Java, Python, Php, Perl, Visual Basic, SQL, PL/SQL, ABAP, korn/bourne/c/sed/awk, ODBC, Tidal, Maestro, Autosys Enterprise Schedulers

Web: Apache, HTML5, CSS3, Javascript, XML, Git

Micosoft Office: Excel, Project, Visio, Word, Powerpoint, Access

Industries: Energy Trading, Investment, Financial, Internet, Telecommunication, Government, Pharmaceuticals, Transportation, Automotive

PROFESSIONAL EXPERIENCE:

Confidential

Principal Informatica ETL Architect Data Engineer

Responsibilities:

• Architected Informatica ETL XML ERP Benefit focus System for 834 Membership Enrollment for E-business group. Java transformations. Access Mappings.
• Developed Informatica mappings to/from Oracle 11 Operational Data Store and Sql Server 2005, C++, Java, Performance tuning for low latency.
• Operations/Support Win 2003/sql server 2000/Informatica 6.xx-8.xx for Energy Trading / Credit Risk Algorithms Data warehousing for Major Oil Company
• Architected Informatica Installation, Configuration, Supporting in Algorithm Design for High Frequency / Scalability / Availability for low latency applications.
• Sun Solaris Oracle 9/10g RAC Environment
• Informatica Development of Master Data Portal from Siebel and Global Data Conversion, C++, Performance Tuning for low latency. Access Data Mappings.
• Architected Installation /Configuration / Administration of Informatica Powercenter on Solaris, NT, Win2k on Oracle PowerConnect SAP
• Informatica Development of various clinical trial data for multiple data marts
• Data integration / Migration / Warehousing from Oracle Clinical & other Legacy systems into Oracle Data Marts
• Informatica Metadata Administration and Data Mart Security
• Brio validations, building reports and assisted with Business Specifications and Rules. Web development Reports

Confidential

Senior Informatica ETL Architect Data Engineer

Responsibilities:

• Installation/Configuration/Administration of Informatica Powercenter/Powermart on HP-UX, Solaris, NT, Win2k on Oracle 8/9
• Development of various data warehouses such as Transportation centralized data warehouse, Income/Revenue/Expense Enterprise Data Warehouse, Credit Collections Data Warehouse combined w/ PL/SQL
• Data integration/migration/warehousing from Informix, SAP & other Legacy systems into a Oracle/Informix Staging Data Warehouse which fed into the Centralized Data Warehouse on Oracle / Teradata / Informix
• Extraction from IBM and IMS mainframes sourcing fixed width, delimited, line sequential files in binary and EBCDIC formats into an Enterprise Data Warehouse
• Modified COBOL to include wrappers to import copybooks. Transformed using occurs clauses.
• Modified SAP ABAP code for extraction, C++, VC++, VB custom code
• Informatica metadata administration and Performance Tuning of Informatica data warehouse loads

Confidential

Senior Informatica Data Engineer, San Diego, CA

Responsibilities:

• Design/Developoment/Administration/Installation/Configuration/Performance Tuning of Informatica Powermart
• Development/Administration of Powermart Server on Solaris with Oracle 7/8
• Data migration/conversion into a MRPII packaged application on HP-UX/ Oracle feeding a Centralized Data Warehouse using combined w/ pl/sql, C++, VC++
• Extractions using fixed width Confidential data as line sequential from Unisys and IBM mainframes

Informatica Data Engineer

Confidential

Responsibilities:

• Informatica Architecture and metadata exchange with Business Objects, Brio, Microstrategy
• Installation/Configuration/Performance Tuning of Powermart/Powercenter at numerous client sites throughout the country.
• Development/Administration of Powermart/Powercenter for Data Warehousing, financial, investment, and other applications using SAP, Oracle Financials, Peoplesoft, Oracle, Sybase, MS Sql Server, Informix,DB2,mainframes
• Informatica extractions from IBM, DB2, MVS mainframes using Occurs clauses and Cobol wrappers around copybooks/copylibs loading into Red Brick data warehouse via flat files

Confidential

Technical Associate, San Jose, CA

Responsibilities:

• Performed views, joins and queries of tables for sales and financial applications on an ERP package.
• Development of Crystal Reports running on a NT server with Oracle database running on HP-UX.
• Applications Development on a Digital UNIX platform with Sybase
• Performed maintenance of database tables, data dictionary, and SQL programming on a Materials Management packaged application.
• Customer enhancements written in C / C ++
• Proposed, planned, designed, and implemented migration from a centralized printing operation to a distributed operation. Saved customer $20,000 in maintenance.
• Development/Administration of Web pages for an Intranet.Installation/Configuration of Netscape’s Web Server.
• Identified bugs and suggested improvements on a UNIX platform running an Astea client/server packaged application.
• Processed backlog of financial transactions with the customer.