SUMMARY:

Senior Database Developer with over 15 years of experience in database support and development, including extensive experience with Oracle PL/SQL, ETL development, and performance tuning. Also experienced in data modeling, database design, data warehousing, technical support, and quality assurance.

TECHNICAL SKILLS:

• Advanced PL/SQL Development & SQL tuning
• Oracle 8i/9i/10g/11g/12
• Exadata
• ANSI SQL
• MS Access
• SQL Loader
• SQL Server
• Uniface
• Unix kornshell
• Unix VI
• SQLPlus
• SQL Navigator
• Toad
• PL/SQL Developer
• CVS version control
• CASE Studio
• PVCS Version Manager
• PVCS Tracker
• Pentaho Data Integration
• Subversion
• JIRA
• MS Office tools. Experience with Netezza
• Java
• Visual Basic
• C++
• C#

PROFESSIONAL EXPERIENCE:

Engineer

Confidential

Responsibilities:

• Modified, deployed, and tested Oracle database objects and Unix scripts in new development environment
• Deployed and configured Pentaho Data Integration jobs and processes in new development environment
• Coordinated Pentaho upgrade from version 4.2 to 7.1, and configured upgrade environment
• Modified, tested, and deployed existing Unix shell scripts for Pentaho version upgrade

Lead Database Developer

Confidential

Responsibilities:

• Designed and developed Oracle PL/SQL ETL processes for loading Data Warehouse structures for health care enrollment, claims and related data in Oracle 11g / Linux environment
• Supported production load processes used to merge and match health insurance issuer data with data repository
• Designed and developed new security program to grant appropriate database access to different user groups
• Created complex ad - hoc SQL scripts for urgent data analysis and/or repair requests on very short timelines
• Architected and lead project to create new Oracle database and processes for conversion of existing MS Access payment processing database
• Performed database administration tasks including user access management, schema export and import, and large volume data transfers

Lead Developer

Confidential, Scottsdale, AZ

Responsibilities:

• Lead development projects in enterprise transaction and batch processing systems in Oracle PL/SQL / Linux / Java environment
• Supported Oracle EBS financials custom PL/SQL interface processes, troubleshooting production issues, development and maintenance of stored procedures, and performance tuning
• Designed and documented new source control system and define team processes
• Mentored team members in advanced Oracle development and tuning techniques.

Sr. Oracle Software Engineer

Confidential, Phoenix, AZ

Responsibilities:

• Migrated complex Pharmaceutical data reporting database from Netezza to Oracle Exadata on a very brief development schedule, converting SQL scripts to PL/SQL packages
• Tuned complex SQL to achieve acceptable performance for large volume aggregations (7 billion + rows)
• Designed and documented system architecture for conversion, including thorough process step functionality and restartability

Sr. Oracle Developer

Confidential, Scottsdale, AZ

Responsibilities:

• Designed, documented, coded, and tested custom PL/SQL ETL packages to load and refresh healthcare data in a 7+ terabyte EDW including fact tables and type I / type II dimension tables.
• Reworked existing ETL code to improve performance using various optimization techniques including worktables, bulk processing, global temporary tables, indexing, and partition specific code design. DW total monthly refresh time improved from 10+ days to less than 12 hours.
• Assisted in design of system changes to ensure acceptable performance of new processes and procedures
• Assessed and resolved urgent batch load issues in the production database
• Assisted in planning and implementation of automated scheduling system for DW loading
• Played a key role in planning, testing, and performance tuning for the EDW upgrade from Oracle 10g to 11g
• Trained offshore development team on design, operation, maintenance, and troubleshooting of the EDW.

Oracle Software Engineer

Confidential, Mesa, AZ

Responsibilities:

• Designed, coded, and tested custom PL/SQL & Unix kornshell ETL processes to extract helicopter parts data from various sources and load into supply chain decision support database
• Utilized Oracle External tables to stage data for ETL processing
• Worked with Business Analysts, Asset Managers, and other users to design and test software enhancements
• Coded PL/SQL scripts and procedures to utilize APIs for loading data into the GOLD system

Oracle Software Developer

Confidential, Scottsdale, AZ

Responsibilities:

• Developed, tested, and implemented custom PL/SQL ETL processes to transform and load financial data from clients
• Worked with business analysts and technical consultants to analyze and document customer requirements
• Created new schemas and managed user permissions for new development and test projects
• Developed, analyzed and tested new data models to improve referential integrity
• Rewrote existing PL/SQL procedures using bulk processing, collections, and SQL optimization to improve performance

Confidential, Scottsdale, AZ

Programmer Analyst

Responsibilities:

• Coded bug fixes in Uniface, PL/SQL, Unix ksh and Pro C in JDA’s host system, Portfolio Merchandise Management
• Wrote, tested, and executed test plans to validate code changes
• Analyzed technical design documentation to determine appropriate resolution

Senior Technical Support Engineer

Confidential

Responsibilities:

• Wrote, tested, and implemented custom modifications and interfaces in PL/SQL and Uniface, including custom ETLs
• Analyzed and resolved software & database performance issues in high volume transaction processing system
• Promoted to team lead to coach and mentor analysts on technical and functional aspects of the products.
• Wrote, tested, and implemented PL/SQL scripts to generate data to simulate client environments

Quality Assurance Analyst

Confidential

Responsibilities:

• Developed and executed test plans and test cases for complex client/server retail merchandise management applications
• Debugged PL/SQL and Uniface code to assist programmers in issue identification
• Created and executed PL/SQL scripts and stored procedures to simulate data integration from external systems