Summary

Extensive experience in data warehouseETL development (financial, billing, supply chain, and inventory). Forte has been to streamline current systems optimizing efficiency significantly increasing system performance. Committed to quality thorough work with minimal defects and adaptable to fluid business needs. Adept at generating formal documentation throughout the project life cycles.

Professional Work History, Analytical Skills and Accomplishments

Confidential, ( FTE Sr Programmer Analyst Modesto, CA Linux, Netezza, Oracle, Datastage ETL, Data Warehouse, UC4

• DataStage ETL development work on new processing (wine management application, product tracking) to fit approved business rules or load new tables
• Worked with datastage admin and IBM to get the 8.5 configured for Netezza conversion and development
• Teach other developers new to Datastage and Netezza and assisted DBAs setting up promotion process on new Netezza server
• Table design for new loads using Oracle or Netezza
• Sharepoint admin training class

Confidential,(Sept 2010 contract end 12/31/10) Contract position - - Client Confidential,

Sr Software Engineer Unix, DB2 UDB, DataStage ETL, Oracle PL/SQL

• DataStage ETL development work to augment/fix current data warehouse processing (retail application) to fit approved business rules for 300+ mill row tables
• Agile software development
• Set up development and QA/UAT environments refreshing with production Datastage/Qualitystage job copies,unix job scripts, refreshing all interfacing input data, running batch cycles for User Acceptance Testing. Had admin rights to QA and DEV datastage environments to react to other developer environmental changes as needed.
• Participated in all datastage team code walk throughs
• Participated in setting up team ETL standards and promotion process

Confidential, (Mid ) (Full Time position)

Data Warehouse Developer, Redmond, WA Unix, Oracle, PL/SQL, DB2, DataStage ETL, mainframe, Business Object reports/universe, Crystal reporting, Web Intelligence,Sharepoint, unix scripting

• Developed new mainframe, Zeke scheduling, Unixscripts and DataStage ETL process productquotes used to send as emails. This has an estimated savings of $400K a year postage and handling. Received a corporate award for this work.
• Modified severalDatastage process to run from 6 hours to half hour
• Developedbusiness object, Web Intelligence and crystal reports for supporting manufacturing/marketing business decisions.
• SAP Business Object universe admin, development and maintenance
• Unix production support to check for files, logs, trigger or OK files
• Data warehouse production support
• Sharepoint document and report publishing
• Conducted datastage training sessions for other Univar developers new to datastage. Responsible for technical documentation and team standards documentation for DW sharepoint project site. Worked with unix admin, security admin and dba to set up a more efficient promotion process.
• Attended several IBM datastage classes, SAP Business Object report classes.

Confidential, (Mid June 2007 2/8/08) Contract position -- Client Arizona Public Service (utility co. ) - COBOL, DB2, SQL, JCL, Microsoft ACCESS, Changeman, Control M, Fileaid, Expediter, Sharepoint

• Utility Billing Developed mainframe job tracking pulling job schedules, run statistics, and file information to build database for easy access to critical job dependency/successor, data flow or impact analysis. Modified two long running COBOL/DB2 month end reports cutting run time in half. Supported the CASS certification Finalist application (USPS compliance software).
• Sharepoint department/team documentation project and support

Confidential, ( ) Contract position - Client US Airways

Data Warehouse Developer

• Airline Revenue Acctg Project Redesigned several long running COBOL/DB2 accounting Datawarehouse Oracle feeds, reducing run-time and/or resources from 50%-80%, new development work against complex accounting system to bring in expanded feeds for reservation data from EDS conversion project

Confidential, ( ) Contract position -- Client Honeywell (Aerospace)

Sr. Consultant- DB2, Oracle, PL/SQL,Informatica (ETL), SAP conversions

• ESA SAP data warehouse project work on converting sales order data to SAP Oracle PL/SQL data warehouse, working with business customers to identify data sources, data mapping, organize meetings, coordinate with SAP/Oracle technical team developers, wrote Informatica ETL jobs to load IW Oracle tables retirement project developed system to pull Honeywell data from many sources (libraries, scheduler dbs, jcl, files) to document data flow for systems analysis substantially cutting down data gathering time by 80%

Confidential, ( ) Full Time position

Sr. Programmer Analyst COBOL, DB2, GL app

• Developed Walker financial balance sheet and income statement in company specific format/breakdown saving the entire department two weeks manual work quarterly using COBOL against DB2 tables.
• Modifications to COBOL Walker General Ledger system, including DB2 optimizing and program code database call changes speeding up run time (some from 10 hr run time to 2 hrs) aiding in department’s monthly close process
• Worked directly with the corporate financial department to support their on-going needs; acted as liaison between IT department and finance as well as other Amerco companies relating to the hundreds of data feeds throughout the month
• Created system documentation both technical and end-user application on previously undocumented, complicated processes for month-end closing

Confidential, ( ) Full Time position

Data Warehouse Developer - ORACLE

• Coordinated creating an Oracle-based test system for use as rapid development tool to provide faster turnaround on development efforts for mandated legislative reporting
• Reviewed contractor VB programming work to ensure it met State contractual and mandated reporting requirements
• Participated in reporting requirements gathering meetings as set forth in legislative mandated procedures/policies

Confidential,(1998) Contract position Client:Confidential,

Sr. Data Warehouse Consultant

• Redeveloped mainframe conversion analysis/requirements for a Capital One credit card data warehouse
• Participated in meetings at all levels; management, technical, business and client (end-user)

Confidential, ( ) Client Confidential,

Data Warehouse Developer-- Pharmacutical Data Warehouse Oracle

• Streamlined complicated COBOL/DB2 mainframe weekly RX edit & warehouse feed process (1.25 mill transactions/wk) from 48 hours to 8 hours enabling quicker turnaround for end-customer provider reports ($15 mill contract) housed in an Oracle data warehouse
• On-call support with dial-in capabilities and responsible for all mainframe maintenance requirements for the RX process (COBOL/DB2)

Systems Proficiency

Hardware Unix, Linux, IBM MVS Operating System, scripts, sftp

Programming Languages/database/utilities Data Warehouse (14 yrs), DataStage8.5 (ETL 4 years), Netezza (1 year), Oracle (8 years), DB2(13 years), Clearcase, SVN, UC4 Scheduling (1 yr), Zeke scheduling, Oracle PL/SQLEducation

Masters Business Administration Technology Management

Master of Science Computer Information Systems

Bachelor of Science, Business Information Systems