Microgen Aptitude Accounting Hub v19.3 and v21 developmentOracle 12c and 19c SQL and PL/SQL developmentASG Zena job schedulingControl-M Job SchedulingJenkinsUrbanCode DeployFlywayJIRA agile sprint projectsGitHub repositories

Microgen Aptitude Accounting Hub developmentOracle 12c SQL and PL/SQL developmentASG Zena job schedulingJIRA agile sprint projectsSonarQube data quality GitHub repositories

Oracle PL/SQL developmentAptitude Accounting Hub developmentUNIX scriptingASG-Zena task scheduling

• Lead developer of the JDA Inventory Optimization 8.0 safety stock implementation of stores and distribution centers.• Developer on the JDA Demand and Fulfillment 8.0 implementations of stores and distribution centers.• Developed enhancements to JDA Demand, Fulfillment, and Inventory Optimization.• 24/7 on call rotation support.• Implementation of frequent ETL files into and out of Oracle 12g database.• Development of UNIX scripting using VI.• Development of SQL*Plus scripts, PL/SQL procedures, functions, and packages.• Tuning of large volume SQL queries using Explain Plan analysis.

• Began as contract to hire consultant and was hired March 2011 as Programmer Analyst.• Promoted to Senior Solutions Developer in May 2012.• Technical team lead of largest client, managing a team of 4 developers.• Implementation of frequent ETL files into and out of Oracle 11g database.• Development of UNIX scripting using VI and PERL.• Development of SQL*Plus scripts, PL/SQL procedures, functions, and packages.• Tuning of large volume SQL queries using Explain Plan analysis.• Monitoring of Oracle 11g database and concurrent work with the DBA group.• Manage the proprietary job scheduling application for the client.• Documentation of new requirements, existing processes, and enhancement requests.• Engineered priority de-duplication process of records from 4 large B2B Customer vendors into Oracle database.• Designed, developed, and integration tested a new business keying service process for B2B customers.

• Designed, developed, and implemented Oracle R12 Customers Online module technical upgrade from Oracle 11.5.10 Accounts Receivable Customers for College of American Pathologists.• Designed and created test plan for conversion of legacy systems to R12 Oracle Customers TCA Party Architecture for College of American Pathologists.• Trained College of American Pathologists employees on Oracle EBS Applications modules and gathered legacy requirements.

• Technical team lead for the successful data conversion of 3 legacy systems (Novell, Platinum, and a custom website system) into Oracle EBS 11.5.10 for Kaplan Professional Texas, New Mexico, Colorado, Nevada, and California schools.• Managed, designed, developed, and tested the custom PL/SQL development of 11 data conversions (Customers, Students, Classes, Sessions, Resource Bookings, Products, Bill of Materials, On-hand Quantity Inventory, Open/Closed Orders, Invoices/Credit Memos, and Student Enrollments) for a new implementation of Oracle EBS 11.5.10. • The implementation of 8,000 customers, 125,000 students, 18,000 classes, 80,000 sessions, 90,000 resource bookings, 18,000 products, 15,000 bills of material, 300,000 orders, 600 invoices, and 280,000 enrollments officially went live January 4, 2006.• Directed an on-site team of 3 developers and a team in India of 5 developers. • Configured Accounts Receivables, Legacy Training Administrator, Order Management, Inventory, Telesales Agent, and Bill of Materials modules.• Owner of version control of all custom tables, packages, procedures, functions, and sql scripts using the version control software PerForce.• Interviewed contractors and potential employees for custom development positions on the team.• Produced custom 6i forms and modified existing Oracle forms through Forms Builder and personalizations in Oracle EBS Applications 11i. • Developed custom Discoverer 4.1 reports to meet business requests.• Supported the Kaplan Professional Schools Oracle user base for the states of Texas, New Mexico, Nevada, Colorado, Wisconsin, and California.

• Directed a team of 2-7 people on 3 different projects.• Ensured a successful project work plan for a team of 2-7 people on 3 different projects.• Promoted from technology analyst to technology consultant after 2 years.• Designed, developed, and tested Oracle EBS Applications solutions for 7 different clients.• Project work was in the software, retail, government, publishing, and energy sectors.Project Roles:• 6/01-11/01 McGraw Hill Publishing Company. Served as a technical designer, developer, and tester. Designed, developed, unit tested, and system tested 2 custom PL/SQL interfaces from the legacy system to Oracle AR. • 12/01-6/02 TIBCO Software Company. Served as a technical designer, developer, and tester. Designed, developed, unit tested, and system tested 1 interface from Peoplesoft HR to Oracle HR, 3 interfaces from the legacy system to Oracle AP, and 5 custom reports for AP, GL, and HR modules.• 7/02-9/02 U.S. Department of Commerce. Served as a technical designer, developer, and tester. Designed, developed, unit tested, and system tested 3 custom Developer 2000 forms for AP and GL modules and 8 custom Developer 2000 reports for AP and GL modules.• 10/02-8/03 U.S. Department of Education. Served as a functional designer, technical designer, developer, and tester. Designed, developed, unit tested, and system tested 3 custom interfaces from the legacy system to Oracle AP, AR, and GL, 3 custom Oracle 6i forms for the Oracle AP module, and 3 custom Oracle 6i reports for the Oracle AP module.• 8/03-2/04 U.S. Postal Service. Served as a functional designer, technical designer, developer, and tester. Designed, developed, unit tested, and system tested 3 custom interfaces from the legacy system to Oracle FA and 3 Oracle 6i reports for the Oracle FA module.• 2/04-6/04 Best Buy Corporation. Served as the project lead over a team of 4 remote developers and 3 onsite developers. The project involved the implementation of Oracle HRMS and Payroll.