SUMMARY

• Over twenty (20) years of diversified data processing experience as Data Architect, Database Analyst, Database Administrator, Programmer Analyst, Systems Integrator, and Technical Lead.
• Oracle systems specialist with demonstrated expertise in data and process analysis, data modeling, physical database design, capacity planning, installation and configuration, and performance tuning.
• Extensive experience delivering high - volume On-Line Transaction Processing (OLTP), Decision Support Systems (DSS), Data Warehouse, Data Mart, and On-Line Analytical Processing (OLAP) systems.
• Experience migrating legacy systems to client/server and the Internet, as well as integrating mission-critical legacy data with new Oracle-based systems.
• As an expert in Oracle Designer, emphasis is placed on the use of CASE technology to realize the full benefits of Rapid Application Development while improving long-term life cycle support for automated systems.
• Other notable areas of expertise include such diverse areas as Oilfield Services, Customer Management, Energy and Utilities, Social Services, General Accounting (Receivables and Payables, Inventory, Billing, Payroll), Legislative Affairs, Imaging and Document Management, Insurance Claims and Processing, Juvenile Justice, Personnel and Payroll, Maintenance Management, Military Intelligence, and Digital Signals Processing.
• Proven management ability and project leadership. Strong verbal, written, and interpersonal

TECHNICAL SKILLS

Operating System: MVS/ESA, VMS, AIX, SCO UNIX, Linux, WindowsNT/2000/XP, MS/DOS, Windows 3.x/95/98, OS2, NETWARE, Banyan

Hardware: IBM 3090, RS6000, DEC VAX Cluster, HP 3000, PC, Macintosh, SUN, RAID Storage Arrays

Database: Oracle, SQLServer, Teradata, CA/IDMS, TurboIMAGE, Watcom, R BASE, dBase III and IV, FoxPro, Access

Language: SQL, PL/SQL, Java, JavaScript, HTML, C, COBOL, FORTRAN, Pascal, LISP, RPG III, Ada, Basic, JCL, MACRO 11 Assembler Case Oracle Designer, Embarcadero ERStudio, Computer Associates ERwin

OLAP/BI: Oracle Essbase, Oracle Discoverer, SAP Business Objects

ETL: Oracle Warehouse Builder, Informatica PowerCenter, SAP Business Objects Data Integrator

Software: Oracle Developer (Oracle Forms, Reports, and Graphics), Broadvision, i2, JDeveloper, JBuilder, SQL*Forms, SQL*ReportWriter, SQL*Plus, SQL*Menu, Powersoft PowerBuilder, Visual Basic, Oracle Card (PLUS), MS Project, MS Word, Word Perfect, Ami Pro, Excel, Lotus 1 - 2-3, SuperCalc IV, Freelance Graphics, PowerPoint, Corel Draw, Harvard Graphics, Ventura Publisher, Aldus Pagemaker

Oracle: Versions 10.6, 10.7, 11i. Applications GL, AP, AR, INV, PA, FA, OE, HR, Oracle Utilities, Oracle Energy

Networking: Ethernet, Token Ring, DECNet, TCP/IP, IPX/SPX, SNA, Internet/WWW, FDDI, LU6.2

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Senior Principal Consultant

Responsibilities:

• Data Architect. Worked with users to identify system dependencies and data flows for Commercial MillerCoors applications in order to optimize maintenance and identify applications to be decommissioned.Designed and developed database changes for the Targeted Distribution System, or SmartSKU, a SQLServer and Teradata based application supporting MillerCoors marketing efforts.
• Data and Application Architect and Modeler. Provided emergency Oracle analysis and development for implementation and customization of a new Tax Portal application. Designed and developed new Enterprise Data Warehouse (EDW) for Business Intelligence requirements, consolidating information from disparate enterprise data sources including Oracle JD Edwards, SAP, and Hyperion enterprise systems as well as Tax, Legal, Real Estate, and other departmental systems.
• Data Architect for Halliburton’s Battle Red project. Worked with other teams to define data requirements for new business system development. Developed standardized approach and methods to data modeling, data access, data services, data capture, and data migration. Developed Conceptual, Logic, and Physical data models to support a new service-based Oil and Gas “Upstream” application. Transferred knowledge to allow Halliburton employees to support and maintain the data model.
• Data Modeler and Strategic Data Consultant for Exxon Mobil’s Global Strategic Services Group. Worked with application analysts to ensure data designs and data integration issues are identified and resolved for projects interacting with the various corporate SAP Enterprise Resource Planning systems. Delivered Informatica mappings to support large SAP migration, personally delivering a four man-month estimated work effort in three weeks.
• CenterPoint Energy, 4/10 - 7/10. Data and Application Architect for Disaster Recovery analysis project. Gathered information from information technology sources and systems to identify integration points, system dependencies, and application capabilities to provide business continuity recommendations for key critical applications.

Confidential, Houston, TX

Senior Application Analyst

Responsibilities:

• Data Architect and Application Consultant. Data Architect responsible for the design and delivery of all Consolidated Operational Data Store and Data Warehouse objects in a 5TB Oracle database.
• Integrated SAP R/3 (FI, CO, HR, SD, MM, PM, PP, PS modules) and SAP Business Warehouse objects with other external data sources for exposure in a pure Oracle environment so it is available for alternative reporting options, including Discoverer, WebFOCUS, Cognos PowerPlay, Business Objects, Crystal
• Decisions, and SAS. Built many multi-tier (Oracle, Java and PL/SQL) applications to extend operational data beyond the capabilities of the SAP ERP. Provided the means to integrate disparate wellsite technical information, job performance data, SAP, and Hyperion financials to provide near real-time feedback for job productivity. Integrated well permit and rig information from major data vendors with Halliburton specific job and financial data for Business Intelligence reporting.

Confidential, Houston, TX

Independent Senior Principal Oracle Consultant

Responsibilities:

• Data Architect and process analysis contract. Gathered information from all information technology sources and provided a consolidated view of all company data dependencies. Recommended changes to enterprise IT practices to streamline data sharing requirements and improve performance.
• Provided object naming standards, Oracle development standards, and Web development best practices to assist in IT process improvement. Designed and developed several data marts, improving company-wide knowledge management in the Procurement, HR and Tax departments.
• Built data correction facilities for common Operational Data Store. Combination of tools used to support this contract included Oracle Designer, JDeveloper, Oracle Warehouse Builder, Oracle Portal, and PL/SQL.
• Extension development and globalization contract. Upgraded extremely large Oracle Financials custom application from Apps version 10.6 to 10.7. Technical lead and data architect for Globalization project to convert American specific Oracle Financials extensions to support international requirements.
• Finished product supported multiple languages and multiple currencies (including Euro). Multiple language architecture developed in the project was eventually adopted by Oracle for use in version 11i. Created development standards for the organization. Developed a code handler structure that allowed customization at individual sites with limited change management controls while maintaining standard functional integrity. Re-generated over 90% of the product using Oracle Designer, significantly reducing the time to delivery.
• Ultimately responsible for quality assurance of the product and all installations and patches. Developed over 150 utilities to support Applications registration and high quality product installation and packaging. Data architect and Java developer for Broadvision-based Electronic Commerce application. This Internet application provides customers direct access to Air Liquide products and safety information. Built interfaces for Web orders to the Oracle Financials ERP as well as generic interfaces for several international affiliates that do not have an Oracle ERP.
• Oracle internal development contract. Project Technical Lead, primary analyst and Data Architect for Oracle Utilities vertical extension to Oracle Applications 10.7. Developed utilities specific functionality to Oracle Assets and Oracle Projects. Introduced Designer/2000 Headstart for Apps to the team, trained developers in the general use of CASE technology, and specifically for enhancing existing complex systems. Dramatically demonstrated the benefits of Designer/2000 based development by providing 95-100% generation of all new AOL compliant Forms modules.
• Developed PL/SQL modules required to create enhanced asset construction in Oracle Projects and interface them to Oracle Assets. Provided Database Administration support and guidance for Applications 10.7 installation and configuration, as well as packaging and tuning of the extension product.
• Technology transfer contract. Assisted Oracle Core Technologies consultant in Applications 10.6 installation. Configured and installed Apps 10SC Prod 16 software. Trained staff in Oracle Networking concepts and software administration with Oracle’s Intelligent Agent architecture. Provided intensive Oracle operations training to newly assigned Database Administrators, including User administration and security, Storage management, and Backup and Recovery.
• Technology transfer contract. Led Data Warehouse Pilot Project team through database design and implementation of an Operational Data Store in an Oracle, HP-UX environment. Trained team in Oracle and Data Warehouse specific design issues. Trained Database Administrator in basic Oracle DBMS operations.

Confidential, Helena, MT

Oracle DBA and Senior Database Analyst

Responsibilities:

• Installed, configured, tuned, and operated multiple Oracle database instances on AIX and WindowsNT platforms. Performed Capacity Planning for new systems. Wrote PL/SQL packages and automated execution using Oracle Job Scheduler processes.
• Wrote PL/SQL Triggers, Procedures, and Functions to enforce business rules. Used CRON and KORNshell scripts to automate execution of batch Pro*COBOL and SQL*Loader processes that shared data with legacy mainframe applications. Responsible for tuning all SQL statements and training developers in optimizing SQL code. Established database development and security standards for the organization.
• Senior Database Analyst responsible for the final design of all Oracle based systems. Trained and mentored junior developers on principles of data modeling, relational database design, specific use of Oracle RDBMS, Designer/2000, Developer/2000, and Client/Server concepts.
• Led planning and programming for conversion of legacy IDMS systems to Oracle. Instrumental in saving a large client/server project from imminent failure and making it one of the most successful major systems ever developed in the state. Accomplished this by using Designer/2000 and Developer/2000 to rapidly redesign poorly constructed and unworkable database, and developed in six months a complete system previously determined too complex for existing PowerBuilder developers, which also convinced management to move into an Oracle exclusive development environment.
• Designed and built a Data Warehouse that integrates budget and accounting information originally generated by many different automated systems to provide a single-source for querying fiscal data. Provided advise to senior management on future computing strategies, including Imaging, Document Management, Workflow, and World Wide Web access to corporate data stores.

Confidential

Project Manager/Lead Analyst

Responsibilities:

• PC and Client/Server based computer systems for the confidential’s Directorate of Computing. Primary Oracle Database Administrator and Database Analyst, specialist in use of Oracle CASE. Installed, configured, tuned, and maintained five Oracle databases within the Headquarters complex and at the confidential.
• Supported many functional areas, including Administration, Air Operations, Armaments, Maintenance, and the Technical Research Library. Developed custom applications in SQL*Forms, Oracle Card, PowerBuilder, FoxPro, Visual Basic, and Visual C++. Trained analysts and developers on principles of data modeling, relational database design, use of Oracle RDBMS, Client/Server concepts, and PowerBuilder development.
• Planned and specified the requirements for accessing legacy IMS and DB2 data on an IBM mainframe and TurboIMAGE data on an HP3000 by using Oracle Server and Oracle Transparent Gateway products. Defined specifications for providing enterprise imaging and document management services to the RSAF Headquarters, including database, optical storage, application software, and network infrastructure requirements.
• Designed and developed integration software to work with MAXIMO Work Management and Inventory System.

Confidential, Helena, MT

Programmer/Analyst

Responsibilities:

• As Senior Programmer for the Department, developed COBOL and Culprit applications in an IBM mainframe environment to support Child and Adult Protective Services, Foster Care, Adoption, Aging Services, Family Preservation, and Administrative requirements. Developed R:BASE and dBase applications to support automated Medicaid Claims submission, Social Security Trust Account administration, and administration of the Interstate Compact for Placement of Children program.
• Developed an integrated mainframe/PC application for performing Random Moment Time studies that gained the agency over $500,000 per year in previously unrecovered funding by documenting performance of federally supported programs by field workers.
• Also performed duties as NetWare LAN Administrator, performing all network troubleshooting and problem diagnosis. Developed Conceptual Design for new statewide Case Management system to provide integrated support to all functional areas of the department, which was later contracted for development.