SUMMARY:

An IT professional experienced in systems and database analysis, design and development on many platforms, including UNIX, Windows and VMS. Database experience includes Oracle, Teradata, MS SQL and Ingres. Recent focus on Oracle application trouble analysis and correction; View/ Reporting Design; ETL, Unix scripting, Informatica Admin/ install/ analysis/ migration/ User training and support. Strong Analysis, DBA, Performance Tuning, Process, SDLC, BI Development and communication skills allow him to design and deliver quality solutions.

Multiple projects have given him expertise with data analysis, installation, utilities, migrations and integrations, as well as Administration and Lead skills. Successful implementations/ knowledge of LDM/ PDM, performance tuning and BI development make him a valuable resource. He enjoys challenges, brings a positive attitude and the ability to adapt to changing technology and project requirements. Mentoring of team members increases productivity and assures success. In addition, he has expertise with complex SQL, Database storage/ retrieval optimization.

PROFESSIONAL EXPERIENCE

Quality Assurance Support/ Development

Confidential, Evendale, OH

L3/ L2 Helpdesk for Supply Chain Web Center and Digital Engineering Systems: Analyze/ determine actual user issues and provide/execute solutions. Execute/ analyze Informatica WF loading ShopFloor measurements to Proficy Analytics System; Analyze WF errors, generate weekly Dashboard Reports of loads via MS SQL. Analyze/ Test TIPQA application and interface to ERP applications. Analyze TIPQA architecture/ provide customized view emulation of TIPQA forms. Document Requirements, Design solution, Implement views and extracts.

* Develop/ Modify/ Test/ Deploy VMS scripts and Ingres RW routines to extract datasets for transmittal of Shop Floor measurements to the PROFICY Application. Scripts were parameterized to handle multiple report types, files, transmittal methods and scheduling for multiple instances. Data extracted from Ingres databases in multiple remote sites.

ENV:: Oracle, Windows OS, Unix Script, Informatica 9.1, MySQL, SQL Server, FTP, SFTP, Ingres, VAX VMS script

Oracle ETL Developer

Confidential, Oxford, OH

On contract thru Analysis Express, West Chester, OH

Develop/ Modify/ Test/ Deploy PL/SQL Packages and OWB mappings to populate BI datasets. Data is extracted from the HR and Student modules of the BANNER ERP. Perform analysis and coding to maintain deletions and SCD History

ENV:: Oracle 11g, Oracle Warehouse Builder, PL/SQL, Agile Scrum.

Informatica Admistrator

Confidential, Columbus, OH

Administer multiple PowerCenter and IDQ environments on AIX Servers in support of an Integrated Teradata EDW. Environment utilizes multi - node, grid-based domains. Deploy labels, XML and Scripts thru DEV/ QA/ UAT/ PROD. Develop batch Unix scripts deploying updates to Informatica 9.1 folders, connections, permissions as well as file deployment, disc space and cleanup issues. Support BTEQ/ TPT loading, Development. Enforce security and methodology. Analyze and resolve errors. Administer users, and security. Develop ‘How-To’ documentation. Work with developers, testers, managers, DBAs, AIX administrators to resolve technical issues.

ENV:: Informatica 9.1, Teradata 13, Oracle 11, AIX 6.1, Subversion code management, VPN.

Lead Informatica Administrator

Confidential, Fairborn, OH

At WPAFB, OH: Install and administer Informatica on Windows Servers for the USAF ECSS project. Trained/ supported Powercenter developers. Supported mappings/workflows utilizing shortcuts, lookups, parsing, parameterization, routers. Analyzed processes, created Standards, presented demonstrations and resolved user/ application issues. Installed and migrated V8.6 to V9.0.1. Provided analysis of Report data structures. Developed process methodologies and checklists. ENV:: Informatica V8.6 & V9.0.1, Oracle 10g, XML, Windows OS.

Data Analyst/ Designer/ Designer/ Team Lead/ App DBA

Confidential, Fairborn, OH

At WPAFB, OH: Analyzed data flow/sources to define business rules for migration of the SMART application. Served as Team Lead and Application DBA for Supply View project using MICAP and SMART data. Implemented and tuned comprehensive views of inventory, requisitions and backorders. Developed SDLC Requirements, Standards, Design documents, and guided team members.

ENV:: Teradata V2R5, ERwin and MS Office.

Data Analyst / Developer/ Modeler -

Confidential, Evendale, OH

Migrated engine-lifecycle databases from Oracle to Teradata warehouse. Analyzed and modified logical & physical models. Profiled incoming data with Teradata tools. Loaded Oracle data into TD schemas with Fload/ Mload. Analyzed original QA processes using Oracle and Access to develop a repeatable QA process. Validated ETL staging sources via SQL.

ENV:: Teradata V2R5, MLDM, Oracle 10g, PL/SQL, ODBC, ERwin/ Model Mart, Excel, MS Access.

Data Analyst / Developer/ Modeler

Confidential, Beavercreek, OH

At WPAFB, OH:

ENV:: System Architect, TOAD, Excel, Informatica V7.1, Teradata V2R5 and Oracle 9i on UNIX servers.

Data Analyst/ Developer & Application DBA

Confidential, Fairborn, OH

Q303 migration to Teradata EDW. Created/ administered Teradata databases, developed Informatica Workflows to load Oracle sources with expressions, routers, joins, lookups, parameterization, etc. Wrote SDLC documentation. Modified Business Objects Universes. Q303 Logistics DataMart: Modified PL/SQL routines, created specifications, mappings, complex SQL, shell scripts. Created/optimized tables, views, indexes, MVs. Build Cognos BI reports and cubes, administer Cognos catalogs. Work closely with customers and Functional Analysts while developing reports and cubes. Perform integration and OLAP analysis. ENV:: Teradata V2R5, Oracle 9i, PL/ SQL, Erwin, TOAD, Cognos, BO, Informatica 7.1, Excel and MS Access.

SOFTWARE ENGINEER

Confidential, Dayton OH

Professional Services: Analyst, Developer, Supervisor and ETL specialist implementing Teradata ETL processes in Repair Logistics (time/ parts/ cost), Customer Profiling systems. Conferred with SMEs to determine requirements and develop models, mappings, SDLC documents. Performed design reviews and supervised contractors. Translated European currencies, de-normalized data for optimal access, developed BTEQ, Fload, Mload routines and MP-RAS UNIX shells. Optimizing architecture performance was a critical function for supporting applications and BI systems.

ENV:: Teradata V2R4, Erwin, Excel.

CONTRACTOR

Confidential, Cincinnati, OH

Analyzed/ modified COBOL programs accessing Oracle, adding functionality to the ERPS system. ENV: COBOL, Oracle, UNIX on HP9000 servers.

TECHNICAL SKILLS

Tools: /Protocols SQL, QUEL, Teradata V2R5, 13.0, Oracle 9i/ 10g, Ingres, System1022, MySQL, COGNOS Administration/ Impromptu/ Powerplay, Informatica Administration/ Powercenter and IDQ, Erwin, TOAD, Teradata BTEQ/ MLOAD/ FLOAD/ OLE, TPT, SQLdeveloper, SQL+, UNIX shells, HTML, PHP, Perl, AWK, SED, Word, XML, Excel, PowerPoint, Visio, Fortran, C, Cobol, MS Access

Platforms: AIX 6.1, HP-UX, Solaris, MP-RAS, VAX VMS, RT-11, IBM 30XX DOS/VSE & OS, Windows 3.1 thru 7, 2003.

Methods: Client/Server, SDLC, Inmon, Zachman, Dimensional/ Star, ETL, SQL optimization, Enterprise Warehousing, MLDM (Teradata’s Manufacturing Logical Data Model)

Functional Areas: Confidential systems methodology/ relationships and Support methodology, TIPQA methods/ relationship, GE Helpdesk and Change-Tickets, Air Force Logistics and Financial G021, D200A, D043 (MIICS), G004C, G337, D035 Stock Control, G081, MICAP, SMART; Deficiency tracking, Engine life-cycle tracking, XML, OLAP reporting, BI analysis and development, data warehousing, application development, order management, Payroll, Payables, Receivables, General Ledger, Student and Employee HR.