Summary

I have over 24 years of IT experience. Six years in agile development as scrum master. Four years spent in ETL/Data Warehouse development. Five years spent in Oracle ERP applications development. Thirteen years spent in overall Oracle Database development Four in ETL Data Warehousing and nine in OLTP . I am experienced in all phases of the systems development life cycle to include requirements gathering, design, development, test, and implementation. I currently serve as Scrum Master of a web development team, which support ERP systems, homegrown web applications, and mobile applications.

professional Experience

Confidential

Senior Systems Programmer

• Administered an Oracle 7.3.4 database for a Patient Care Enhancement application, which included:
• Automation of process through UNIX scripting and cron
• Operations management and support of daily batch processes
• Creation and maintenance of Perl/OraPerl programs in Sun Solaris UNIX environment
• Backup and Recovery logical , performance tuning, space management, and archiving
• Creation of Oracle PL/SQL stored procedures, packages, functions, triggers, and table design
• Improved the programs with complete automation, error handling, and operating system garbage cleanup
• Took advantage of using stored procedures and functions to eliminate code redundancy and hiding, which allowed the department to offer data services beyond the original scope of the department and increased revenues

Confidential

Oracle Applications Technical Team Lead

• Led a team of 1 system analyst and 3 programmers in the customization, maintenance, and production support of the Oracle Financials 10.7 application modules to include Order Entry, Inventory, Purchasing, General Ledger, Accounts Receivable, Accounts Payable, and Fixed Assets in a UNIX environment
• Customizations included integration with our billing system utilizing a custom GUI for equipment order entry, a GL Transfer interface from the billing system to the Oracle General Ledger written in PL/SQL stored procedures, and interfaces through EDI to send purchase orders, receive shipping information, and receive customer purchase orders written in Pro C and PL/SQL
• Developed enhancements to serial number scanning application written in Forms 4.5. Drove functional and technical design, construction, unit testing, peer reviews, production implementation, user training, and project scoqing

Senior Programmer

• Developed business reuuirements, conducted end-to-end project management, maintained project documentation, coordinated user acceptance testing, and managed software vendor relationship
• Worked with Oracle Corporation consultants to set up a multiple warehouse configuration in Oracle Manufacturing 10.7 application to support inventories and shipment of equipment from 5 different warehouses
• Gathered requirements, prepared functional specs, and managed the development of an Oracle Forms 4.5 application to capture serial numbers using a bar code scanner
• Identified and provisioned resources to complete projects on time
• Developed Oracle Financials Reports in Oracle Reports versions 2.0 and 2.5
• Received Oracle Corporation training in Application System Administration, PL/SQL programming, SQL statement tuning, Oracle Forms 4.5, and Oracle Reports 2.5

Confidential

Senior Consultant

Application Development

• Developed a financial analysis application in Microsoft Access based on a PC, which was migrated to a file server where multiple users could view current financial reports, personnel information, and more

Data Warehousing

• Led a team of five individuals in which 20 operational systems were reviewed and 10 systems were sourced for operational data to occupy a major telecommunication company's enterprise-wide data warehouse in 4 months.

Consultant

Data Warehousing

• Led a team of three individuals to design, code, unit test, migrate to production, and conduct walkthroughs for 33 data extractions from the operational legacy systems to an HP T500 UNIX platform for a decision support system used to determine product profitability for a major telecommunications company

QA Tester

• Facilitated the development of a test environment for a telecommunications fraud detection system in a client/server UNIX environment.
• Over 100 test scripts made up the test plan using Mercury test tools and SQL Plus scripts
• Developed a problem tracking system using SQL Forms
• Automated data integrity validation tests using UNIX C and UNIX shell scripts
• Automated 50 test scripts using Xrunner

Systems Testing

• Utilized Comparex utility to validate application files and data integrity
• Built SAS programs to assure data integrity with statistical and error reports

Confidential

System Engineer

System Maintenance/Troubleshooting

• Investigated problems daily and implemented system fixes into production in a COBOL PL/I shop. The industry was media fulfillment.

Systems Development

• Worked with health insurance client to develop user requirements for a real-time Membership System. Designed, organized, and reviewed the user acceptance testing with the client. Built JCL and EZTrieve scripts to automate the test procedures.

Confidential

Computer Programmer

• Developed Rexx programs to automate database update tasks and create database reports. Developed Pascal programs to create data structures and linked lists for inventory selection. Created and tested command-level programs on the Digital Multiplexor Switch to transfer requested switch data from tape to an IBM mainframe disk and from disk to tape.
• Education AND CREDENTIALS Bachelor of Science in Computer Science
• Minor in Mathematics
• University of North Carolina at Charlotte - Charlotte, North Carolina
• Oracle Certified Associate Developer