SUMMARY
Main technology expertise is with Oracle, SQL, PL/SQL, ETL, Unix and Data Warehousing. Non-technical roles performed are business analyst, system analyst, technical lead, and data quality on global projects for the Department of Defense where customer were military officers including Generals, Eli Lilly Pharma included interfacing with biotech and fermentation manufacturing engineers and at Conseco Insurance applied nationwide data governess, data modeling and business analyst work on terabyte data warehouse and actuarial data mart.

Successful in all projects whether part of a team or working independently as a technical lead. References are available on request. Significant interaction with global quality control, documentation teams, Oracle Forms and Report Developers, Data Architects, Data Base Administrators, Informatica, Mercator and MQSeries ETL developers as well as many more.

Career exemplified by a professional attitude, excited about what I do, a team player, a global leader, and producing quality production of information systems.

Technical Expertise

Oracle 9i, 10g, 11g, Microsoft SQL Server, Informix, MySql

Programming/Scripting:

PL/SQL, Informix 4gl, Visual C++, Oracle Apex, Shell Scripts, Perl, Sed, Awk, PHP, HTML,XML, XSLT, CSS, JavaScript, ADA, XML, vi, TOAD, Business Objects, HL7, Cognos, Erwin

ETL, ERP, MRP:

Informatica, Mercator, MQSeries, SAP, Maximo, Intergraph Assest Capital Management., Initiate

Operating Systems:

HP Unix, Sun Solaris, AIX, XP, VISTA

Professional Experience

Confidential, (Feb 2011 – Sept 2012)

As a technical consultant for IBM configured, designed and developed Master Data Management solutions for the healthcare industry. As an expert in Oracle PL/SQL and Data Warehousing I administered and wrote code to verify accuracy of data loads into Oracle. Leveraging my software development life cycle experience and many years as a technical lead on many global implementations performed as a leader in integrating Business Intelligence solutions in a leading edge technology.
Working in the Healthcare industry developed HL7 knowledge and skills.HL7 is a health care industry data format. Working with hospitals like NorthWestern Memorial and St. Louis Integrated Health Care, was able to implement HL7 data systems into the IBM MDM software called Initiate for data analysis and trending.

• Administered Oracle 11g database tables and views
• Wrote SQL and PL/SQL to verify accuracy of data load.
• Gathered mission critical requirements from client.
• Wrote HL7 data interface into IBM’s MDM server Initiate.
• Configured Initiate’s Data Hub instance to add data attributes, entities and data dictionary.
• Worked directly with client to implement production solution.
• Created interfaces that did not load redundant data only new data points.

Independent Web Consultant (May 2009 – Feb 2011)
As an independent consultant leveraged my 14 years of expertise in UNIX shell scripting, CGI and PERL as well as deep knowledge of relational databases such as Oracle to help freelance web designers complete cutting edge websites.

• Developed forms and reports using PHP to enter and retrieve data from MySQL database tables.
• Incorporated PHP scripts into HTML code.
• Created database objects such as tables, views, procedures, and functions in MySQL.
• Setup Apache web services.

EDS Consultant -- Confidential, (Dec 2007 - May 2009)
As a Software Engineer and Database Administrator had significant impacton the Department of Defense Deployable Cash Disbursing System (DDS). DDS isa cash disbursing system, configured on laptops with personal Oracle Server, Forms 6.0 and Reports 10 which is deployed to soldiers in the field around the Globe. Utilizing DDS soldiers would reconcile daily cash disbursements transactions each day to their superior officer in the field and the data would be consolidated with centrally located Oracle Databases residing on Unix Servers in Indianapolis. Provided 24X7 Technical Support and provided new features for DDS by performing the following tasks.

• Designed and developed data interfaces using Oracle Data Pump, SQL*Loader and C++.
• Created and maintained Oracle packages, procedures, functions, triggers, and database encryption security.
• Wrote new and maintained old Oracle Forms and Reports.
• Was in charge of integrating all software changes and creating new software revisions and releases.
• Created a Data Warehouse using materialized views in Oracle Apex for budgeting studies.
• In charge of Data Governess responsible for Account Receivable and Accounts Payable.

Confidential,DBA (Mar 2007 - Dec 2007)
As an Oracle and Microsoft SQL Server Database Administrator on a commission and sales web portal performed the following database administration roles.

• Was Responsible for day-to-day and 24x7 management of all Development, Test, and Production SQL Server and Oracle databases.
• Performed database administration activities including monitoring and schema management, database configuration, space management, performance tuning, optimization, maintenance, backup/recovery.
• Aided in the Architecture/Data Modeling, Business Analysis and Extraction / Transformation / Load (ETL) development (Microsoft DTS/SSIS and Informatica).
• Lead corporate initiative to replace HP UNIX Servers with AIX Servers.

Confidential,Systems Analyst (Feb 2000 – Mar 2007)
As a data integration specialist working on globally deployed manufacturing maintenance and procurement systems for Eli Lilly researched and discovered industry leading techniques for implementing Maximo and SAP.Part of a team that designed, developed and built Eli Lilly’s Supply Chain data warehouse, operational data stores and staging area databases.

• Developed procurement interfaces between Maximo and SAP using XML, XSLT and Java successfully implementing XML driven Maximo MXES 5.2.
• Constructing the Supply Data Warehouse resulted in the ability to forecast trends in production processes reducing the cost of running and maintaining many production lines.
• Building the Indy Bulk Operational Data Store resulted in the automation of material release and genealogy reporting. This resulted in hours of reduced production down time and costs savings in the hundreds of thousands of dollars a day range.
• Applying a Perl interfacing adapter that called procedures which loaded legacy and SAP data into the Global Material Creation SAD resulted in an integrated and centralized data system which replaced piece milled un-validated systems reducing decision support time and increasing data integrity.
• Applying MQSeires for all data file transfers from legacy systems to data warehouses, SADs and ODS’s resulted in asynchronous data transfer across LAN and WAN.
• Researching and implementing Mercator and Informactica ETL solutions, lead the way in consistent and repeatable data interfacing across corporate IT.
• Constructed Business Object Universe for Data Warehouse Reporting.
• Developed a Manual Data Entry Oracle Data Repository using Erwin to design it.

Confidential,Data Warehouse Architect Consultant (Nov 97 -Feb 2000)
During the process of successful designing, developing and implementing a terabyte data warehouse that feed an actuarial data mart performed the following tasks.

• Architected snow flake schema actuarial data mart.
• Wrote dynamic PL/SQL to load actuarial data mart from 3rd normalized terabyte data warehouse.
• Wrote PL/SQL to cleanse staging area data to 3rd normalized terabyte data warehouse.
• Extracted policy data from 30 plus legacy systems using mostly JCL and loaded data warehouse staging area with combination of Unix shell scripts and SQL*Loader
• Built Reports in Business Objects to report data from Actuarial Data Mart.
• Used Erwin to design the physical and logical Actuarial Data Mart.

Education, Awards & Associations

• B.S. in MIS
• Quality Advocate Award
• Indiana MIS Association.
• Data Warehouse