SUMMARY:

• Oracle Agile PLM 9.3.0.1 Load Runner
• Oracle eBusiness Suite HP PPM Demand and Deploy
• PL/SQL Programming SQL Query Tuning
• Oracle Database 10g, 11g Oracle Developer Suite
• SQL Server, T - SQL, SSIS X12 830, 850, 835 and 837 SQR

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, SQR, Bourne Shell, HTML,ANSI SQL., T-SQL, SSIS.

Development Tools: T.O.A.D., SQL*Plus, Oracle Forms, Oracle Reports, Oracle Alerts, Brio Report Builder 6.0, Perforce Versioning Software

Operating Systems and Platforms Familiarity: UNIX - Solaris, Linux - Red Hat

RDBMS: Oracle 7.3, 8i, 9i, 10g and 11g

Oracle Modules: Agile PLM 8.5 and 9.3, Engineering, Fulfillment Services, Manufacturing, Master Planning and Scheduling, Marketing Online, Order Management, Purchasing, Service and Support, Shipping, Receivables, Financials.

Other: HP (Mercury) PPM Modules Demand and Deploy, SQL Server Development.

User of the following: Microsoft Office, Microsoft Project, Microsoft Access, Load Runner

PROFESSIONAL EXPERIENCE:

Architect/Developer

Confidential

Responsibilities:

• Architected proprietary Revenue Cycle Solution software to efficiently analyze claim and remittance data for lost revenue on behalf of health care providers.
• Developed solution capable of importing and processing millions of X12 837 claims and 835 remittances into SQL Server, within minutes, and outputting analyses and reports with 95% accuracy.
• Generated reports have identified over $370 million in potential revenue.
• Designed a front end solution to storyboard the life of a single claim, providing the user with a complete timeline and all claim details in a single, dynamic interface.
• Consulted closely with clients to validate claim and remittance data and prepared mediation/litigation attorneys to aid in the collection process when necessary.
• Ensured all communications and reports delivered strictly adhered to HIPAA standards for ePHI.
• Developed a process to categorize claims into the CORE Code combinations using data from remittance files.

Senior Data Conversion Specialist

Confidential, Austin, Texas

• Worked with hospitals and health plan organizations to analyze, design and develop complex processes that transform, enhance and load client data.
• Transformed large volumes of complex data from varying client source database systems into Confidential ’ databases utilizing complex SQL stored procedures and SSIS packages.
• Developed a process to evaluate and store explain plan information in SQL server, enabling the ability to map source data to its end use.

Database Integrator Independent Contractor

Confidential, Austin, Texas

• Developed a proprietary data integration product which evaluated prompt payments and identified delinquent payments from insurance providers, allowing clients to pursue potential lost revenue.
• Architected a solution allowing healthcare data from a wide variety of Practice Management Systems to be mapped into a standard data model that could then generate detailed claims analysis, focused on identifying late and underpaid claims, and calculating penalty and interest per the Texas Prompt Pay statute.
• Systems mapped included Centricity, Greenway, E-MD, Nextech, Nextgen, McKesson, Medisoft, Healthland, Medical Manager, ADVANTX.
• Evaluated results for duplicate and missing data, and worked with clients to validate and correct discrepancies.

Programmer/Analyst III

Confidential, Austin, Texas

• Improved Agile Automated Upgrade Utility runtime from 80 hours to less than 12 hours, thereby allowing for completion of entire database upgrade in less than 24 hours with zero business downtime.
• Upgraded Oracle Agile 8.5 to 9.3.0.1 and implemented concurrent integrations between Agile and Oracle ERP version 11.5.8, 11.5.9 and 12.1.2, and Agile and Perforce to enable automatic code deployment.
• Primary development liaison with 3rd Party Integration vendor, working closely with their developers to assist in the development of critical customizations to their product.
• Technical lead for a team of 8 global programmers.

Programmer/Analyst III & Team Lead

Confidential, Austin, Texas

• Implemented HP’s PPM Demand Management Solution to track hardware and software defects and enhancement requests for all of National Instrument products globally.
• Used Load Runner to load test and tune PPM so all user interactions completed in 6 seconds or less.
• Developed real time analytical/performance reporting queries and portlets with HP PPM for 1500 engineers worldwide, enforcing a single, corporate wide standard for tracking request metrics.
• Architected HP’s PPM Deployment Management Solution for our Corporate IT Department.
• Technical lead for a team of 8 global developer, overseeing all R&D Oracle applications - Oracle Projects, Oracle Time and Labor and Oracle’s interface with General Ledger.

Programmer/Analyst III & Team Lead

Confidential, Austin, Texas

• Designed and developed a custom Weight Based Shipping Process using Oracle Pricing and custom external tables, to automate $6M of global shipping calculations.
• Re-architected critical custom application that loads contact data into Oracle Sales & Marketing dramatically improving performance and data integrity.
• Designed and implemented a Custom Relationship Management (CRM) Search utility using Data Quality Management (DQM), improving search efficiency and accuracy by 30%.

Programmer/Analyst III & Team Lead

Confidential, Austin, Texas

• Re-architected all Financial customer facing documents (including Invoice, Dunning Letters and Sales Order Acknowledgements) for 22 countries, using a single dynamic report written in Oracle Reports.
• Primary Oracle technologist providing technical directives and assistance on the Financials 11i upgrade.

Programmer/Analyst III & Team Lead

Confidential, Austin, Texas

• Designed hardware architecture and deployed Oracle 11i Configurator, allowing customers to easily configure complex systems, which increased system related revenue by more than 20% in the first 2 years.
• Developed a custom import tool that allows configured items created outside of Oracle to be imported into Oracle Order Management.
• Implemented one of the Board of Director’s top revenue generating projects - a new process to categorize customer service levels in 3 worldwide data centers. Revenue from the project was $5M in the first year and $37M in the first 5 years.
• Converted process that integrates custom Item Management System between to Oracle 11i, across 3 global data centers, using Oracle Forms Developer.

Programmer/Analyst II & Team Lead

Confidential, Austin, TX

• Implemented mass Routing Updates to match the new i2 Factory Planning model.
• Developed key tactical/strategic business reports including Forecast Plan Validation, Projected On Hand Inventory, EDI 830's and Hard Reservations Process required by the implementation of i2 Factory Planner.
• Completed development efforts to improve Oracle Forecast Processing by reducing total runtime from 3.5 hours to 25 minutes..

Programmer/Analyst II

Confidential, Austin, TX

• Implemented Oracle Memory Based Planner which decreased runtimes from 12 hours to 2 hours.
• Developed an automated Min/Max Planning Process for Planners to accurately and efficiently maintain Min/Max item attributes.
• Served as subject matter expert in the areas of Oracle Engineering, Work in Process, Master Planning and Scheduling Bills of Material and Purchasing.