Mitchell Wrobel Certified Master Developer
Certified Master DBA
2774 North Cobb Parkway
Suite 109-321
Kennesaw, GA 30152 Noetix Certified Professional
Cell: 678-480-8263
mwrobel@mindspring.com Informatica PowerCenter Developer (v 8 and 9)
Oracle OBIEE (v 10 and 11) Repository developer
Oracle OBIEE (v 10 and 11) Report developer
Oracle EBS Applications Developer (v 11i and R12)
Oracle Application Express (APEX) Developer
Oracle Discoverer Developer
Oracle Workflow Developer Oracle XML Developer
Oracle Pl/SQL Developer Oracle BI Publisher/XML Publisher
Oracle Reports Developer Oracle RICE Developer
Work History
August 2010 through Current
SWM International, Inc. - Global Business Intelligence Report Developer and Administrator
Managing, Administrating, and Developing for a global Oracle R12 OBIEE and Discoverer roll - out.
We have locations in Brazil, Poland, France, New Jersey, New York, South Carolina and Atlanta.
Oracle modules used: HRMS, PO, AP, AR, ONT, WIP, WSH, BOM, INV, FA, GL, Advanced pricing, Planning, Cost management, Trade management, Quality.
Software used : TOAD, SQL PLUS, Oracle rdbms 10G, rdbms 11g, Oracle Apps R12, Noetix Views, Oracle Discoverer, Oracle PL/SQL, Oracle SQL, Oracle
Reports, Oracle BI Publisher, Oracle OBIEE. Informatica PowerCenter
My primary functions have been to
1. Design and manage the global reporting strategy utilizing Oracle OBIEE, Informatica, Oracle BI Publisher, Oracle Discoverer and Noetix Views for the global
R12 implementation.
2. Work with end users and location management to gather reporting requirements and develop custom reports for the needs
3. Develop all custom reports
4. Use the Discoverer Administrator product, OBIEE Repository , and Informatica PowerCenter to manage data sources and security for the reporting solution.
5. Develop custom extensions to the Oracle R12 applications to accommodate the special functional needs of the customer. In this case, it is a manufacturing extension
to meet the additional data capturing needs of the customers manufacturing procedures.
6. Train customer location employees to run the reporting tools.
Reports Developed (via Oracle Discoverer, OBIEE, SQL, Oracle Reports)
Finance - Inventory Transactions Bom - Job Close Variance Report. Us Customer Service- Inventory By Org By Subinventory
Finance Overhead Rates Bom - Bom List Us Database Audit - Gl Wand Users
Finance Resource Rate Cycle Count Listing By List Price Per Unit_ Us Database Audit - Oracle Responsibilities - All Users
Finance Sbn Conversion Dsz-Open Orders Report With Job Us Finanace - Ap Trial Blanace Report
Finance Uncosted Transactions Eta Verification Against Gl Date Us Finanace - Ap Trial Blanace Report – Capital Spending
Inventory – Slow And Obs Fa - Assets By Department And Book Us Finanace - Om Customer Aging Reports
Item Attributes Report Set Finance Rm Consumption Us Finance - Lot Control Inventory Aging Report
Us Ar - Customer Credit Report Finance-Month End Inventory Report Us Finance - Sales And Use Tax Report
Us Finance Job Data Inter-Co Pos Pl With Drop Ship Tab Us Finance - Waste By Product Line
Us Finance Job Data By Item Inv - Additional Item Information Us Finance - Com
Us Finance Job Info Inv - Inventory Planning Method Us Finance - Inventory Summary Report By Product Line
Us Intransit Transactions Inv - Item Information Us Finance - Je Report With User Id's
Us Inv License Plate Numbers (Pallets) View Inv- Customer Item Cross Reference Us Finance - Open Po Report
Us Inventory Transactions W Amounts Inventory Age Us Finance - Pallet Production By Product Line
Us Oracle Responsibilities And Users Inventory Sfg-Pfg-Fgi Us Finance - Po Invoice Report
Active Pricing Item Attributes Report Us Finance - Po Open Requisitions
Active Pricing (With Customer Item Info) Item Cost Us Finance - Po Receipt Report
Ap - Credit Memo Listing Item Set Up Check Us Finance - Po Review
Ap - Accrual Reconciliation Manufacturing And Engineering Report Us Finance - R&D Cost Summary
Ap - Accrual Reconciliation Report Material Cost Check 1 Us Finance - Rm Wip Job Information
Ap - Audit Info By Date Range Material Cost Check 2 Us Finance - Shipments By Priduct Line
Ap - Employees Set Up As Suppliers Material Utilization Report Us Finance – Stores Inventory
Ap - Errors - Employees With Incorrect Terms Monthly Sales Summary Us Finance - Vendor Info Report
Ap - Holds - No Po Holds Om - Customers, Items And Descriptions Us Fpa Expanded Cost
Ap - Holds - Price Holds To Be Released Om - Orders, Customers And Salesreps Us Hr - Medical And Dental Coverage And Premiums
Ap - Holds By Buyer Om - Sales Quantities By Order Date And Invoice Us Inventory- Inventory By Account
Date
Ap - Invoice Distributions Us Purchasing - Vendor Addresses
Om - Sales Quantitiesfor 2010 By Product Line
Ap - Invoice Payments By Vendor Us Sales - Detailed Sales Reports - By Customer By Item
Ont - Order Info With Lot
Ap - Invoices For Defined Period And Vendor Us Sales - Sales Reports
Oracle Super Users
Ap - Month End - Ap Forecast Report.Dis Us Sales - Sales Reports (Open, Shipped, All Orders)
Ap - Monthly Vendor Activity Report Orders And Shipments Us_ Finance - Us Finance Job Variance Summary
Ap - Payables Distribution Report Cm Orders And Shipments - By P.O - Dlvy Date Us_Commom_Inventoryproduction-Transactions
Ap - Payables Non Validated Invoices Po- Open Po Report For All Locations Us_Common - Descriptive Flexfield Segments
Ap - Payables Unvalidated Invoices Po- Po Report For All Locations Us_Common - Responsibility Inclusions
Ap - Po Distribution Detail Report With Amounts And Production Waste Report Us_Common All Menus, Apps And Functions By
Vendor Responsibility Report
R12 Orders And Shipments
Ap - Po Service Receipt Report Us_Common Menu Exclusion Report
Receipts By Product
Ap - Service Po Confirmation Us_Common- Po Approval Limits Report
Sales And Use Tax Report
Ap - Service Po Exposure Report Us_Common_Inventory By Lot And Product Line
Sales Volume Ar And Om
Ap - Service Po Exposure Review Us_Common_Requisitions For Projects
Service Po Fulfillment Status
Ap Monthly Review Us_Common-Financial Budget Set
Sy - Responsibility Access Changes
Ar - Us Customer Credit Check Us_Common-Open Orders Report
Universal_Inventory Sfg-Pfg-Fgi
Ar - Aging Buckets Report Us_Common-Responsibility And Menus Report
Us - - Purchase Order Report
Ar - Cogs Us_Common-Responsibility Exclusions
Us - Production Transactions By Item
Ar - Custom Aging Buckets Report- Us_Finance - Item Setup 999 Account Coding
Us - Waste Reports
Ar - Customers And Contacts Us_Finance - Reclaim Inventory
Us - Electronic_Packing_List
Ar Cash Forecast Us_Finance - Item Cost
Us - Inventory_By Item With Lot Detail
Ar Credit Customer Reports Us_Finance - Zero Cost Item
Us - Nventory_Repor
Ar Customer Data Us_Finance- Ap Payables Distribution Report
Us - Open Order By Status
Ar Daily Freight Transaction Report Us_Finance-Month End Inventory Report
Us - Open Orders By Product Line
Ar Daily Invoice Transaction With Packing List Info Us_Sysadmin-Responsibility_By_User
Ar Monthly Invoice Transaction Report- (For All Us - Open Price List
Transaction Types) Us - Production Transactions By Lpn & Lot Detail
Ar_ Custom - Daily Invoice Transaction With Packing List
Us - Responsibility Access Changes
Info
Us - Shipped Order Report
Ar_Freight Report
Us Common - Intercompany Invoice Report
The Berry Companies – September 2009 through Aug 2010
Oracle Developer and DBA – Oracle PL/SQL, OBIEE (Oracle Business Intelligence Enterprise Edition, BI Publisher, Answers, Delivers and Dashboards ), Oracle Application
Express, TOAD, SQL Developer, Oracle EBS 11.5.10 and R12. AR, Financials, GL, AP, AR. Oracle RDBMS v 9i, 10g, 11. Infomatica, Oracle Reports, UNIX, FTP, SQL,
PL/SQL, XML.
April 2009 through Sept 2009.
City Of Chattanooga. Chattanooga, Tennessee
Oracle Workflow Developer
Modified the seeded PO Approval, PO Requisition approval, HRMS and HRMS self service workflows in Oracle Applications 11.5.10 and r12 to accommodate a complex
hierarchy of approvals, with complex secondary, tertiary and timeout logic.
Developer- Oracle Workflow Developer, OBIEE (Oracle Business Intelligence Enterprise Edition, BI Publisher, Answers, Delivers and Dashboards ) BI Publisher developer,
XML Developer, Oracle Discoverer Developer, Pl/SQL, Oracle Reports and Interfaces.
Developed Oracle Discoverer, Workflow, BI Publisher, RICE Components, XML, XML Path, Xpath, XSL Style Sheets, XSL Schema, XLIFF, XML Tree, XML Namespaces,
XML DB, OBIEE (BI Publisher, Answers, Delivers and Dashboards). JDeveloper. Pl/SQL, Oracle Application Express, Oracle Reports and Interfaces, Administrated Oracle
Discoverer.
Software used - Oracle Discoverer 10g, Admin, Plus, Viewer and Desktop. Oracle database version 10g v2. OA Framework, BPEL, Oracle Applications EBS version 11.5.10,
HRMS, Self Service, Payroll, Benefits, GL, AP, AR, PO, PO Requisitions, Toad, Sql Developer, Textpad, Sql Plus, Sql Naviagator, OEM, JDeveloper, BI Publisher Enterprise
Edition
Harvard Business School - January 2009 through March 2009
Instructor/Lecturer on Oracle Business Intelligence. Specifically Oracle Discoverer (Client and Admin), Oracle BI Publisher, OBIEE. Conducted Demonstrations and lectures on
the theory and application of the different flavors of Oracle Business Intelligence tools. Prepared documentation, presented PPT presentations and conducted demonstrations and
moderated class discussions.
Flowserve November 2008 through June 2009.
Oracle Discoverer Developer, Administrator and Trainer, OBIEE developer, BI Publisher developer, DBI developer, XML Publisher Developer, RICE Components
Modules used: Projects, Manufacturing, OM, AP, AR, GL, WIP, BOM, HR, Costing modules. Customized Oracle DBI screens to accommodate the customer needs.
Conducted Code Reviews, Developed Standardization practices, Taught Discoverer Client and Admin classes to the end user.
Gathered requirements, tested, migrated, administrated all facets of Oracle reporting using BI Publisher, OBIEE, Discoverer and Oracle Reports.
Software used – OBIEE, BI Publisher, Oracle Discoverer 10g, Admin, Plus, Viewer and Desktop. Oracle database version 10g v2. Noetix Views and Administration.
Oracle Applications EBS version 11.5.10, Toad, INFORMATICA ETL Powercenter version 8.6 , Sql Developer, Textpad, Sql Plus, JDeveloper, BI Publisher Enterprise Edition,
OBIEE XML Path, Xpath, XSL Style Sheets, XSL Schema, XLIFF, XML Tree, XML Namespaces, XML DB.
March 2008 through Nov 2008.
City Of Chattanooga. Chattanooga, Tennessee
Developer- Oracle Workflow Developer, BI Publisher developer, XML Developer, Oracle Discoverer Developer, Pl/SQL, Oracle Reports and Interfaces.
Developed Oracle Discoverer, Workflow, BI Publisher, RICE Components, XML, XML Path, Xpath, XSL Style Sheets, XSL Schema, XLIFF, XML Tree, XML Namespaces,
XML DB, PL/SQL, Oracle Reports and Interfaces, Administrated Oracle Discoverer.
Software used - Oracle Discoverer 10g, Admin, Plus, Viewer and Desktop. Oracle database version 10g v2. Oracle Applications EBS version 11.5.10, HRMS,
Self Service, Payroll, Benefits, GL, AP, AR, PO, PO Requisitions, Toad, Sql Developer, Textpad, Sql Plus, JDeveloper, BI Publisher Enterprise Edition
Workflows Modified… Interfaces Developed… Oracle Reports Developed…
Colonial Life
PO Requisition – Hartford HVAD Employee Pay Override Adjustment
Approval ICMA deferred comp HR Change Report - Add New Employee
PO - Approval ING-Aetna deferred comp HR Change Report - Name Change
AP - Approval Nationwide 401k contributions HR Change Report - Position, Pay Change etc…
Nationwide deferred comp
Savings bond purchase
Developed the following Oracle Discoverer Reports/BI
Publisher Reports … 34. Trial Balance Detail Report 68. Detailed Overtime Report
35. Employee Roster on Pay Plan 69. Summary Overtime Report
1. Leave Tracking Report 36. General Pension Plan Enrollment 70. QTD/YTD Register
2. Personal Leave Summary Report 37. Employee maintenance report 71. Multiple Worksite Supplement
3. Employee Statistics by P/R Unit and Emp Name 38. List (New Hires), Terminations, Etc. 72. Payroll Taxes from GL
4. Employee Sex and Race Report 39. Employees XX Years Old & Over 73. Colonial Life Rpt & data file
5. Employee Age & Sex By Position, ORG 40. EEO4 Position Report 74. Employee Court Deductions
6. Holiday Time Cards Missing for Date Range 41. ING Deferred Comp 75. Employee Deduction Report
xx/xx/xxx to xx/xx/xxxx 42. ICMA Deferred Comp 76. Court Termination/Stop Letters
7. Leave Balance for Inactive Employees 43. Fire and Police interface 77. Deduction History Report
8. Personal Leave Summary Days 44. Nationwide Deferred Comp 78. Monthly Deductions by Fund
9. labor distribution report 45. Years of Service 79. Operating Engineers Pension Report
10. Employees with COMP Leave 46. Listing of Temporary Employees 80. Form W-2
11. EEO4 Employee Details Report 47. Payroll auth form to sign 81. Life Insurance Discrepancy Report
12. Listing of Negative Leave Accrual 48. Employee Address Report 82. Basic Life Insurance Report
13. Human Services Annual Leave Report 49. Payroll Checklist 83. Long-Term Disability Report
14. Personnel Listing by Name 50. Employee Address Change 84. Retiree Costing Report
15. New Hire File 51. Health Savings Account 85. Employee Who Have Stopped Benefit
16. Employee Diversity Report 52. Hartford 401A Contributions Deductions
17. Employee Position Roster 53. Deferred comp report 86. Blue Cross Dental Reconciliation
18. Employee Count by Position/Org 54. Payroll Register Detail 87. Employees Not Paid Report
19. Head Count by Organization 55. Check Register Selection 88. Benefit Discrepancy Report
20. Position Detail by Fund 56. Deduction Preview Report 89. H.S.A. Premium Status Report
21. Position Detail By Department 57. Warrant And Journal Vouchers 90. Employee Cafeteria Enrollment
22. Employee Detail by fund 58. GL Posting RECONCILIATION REPORT 91. Injured on Duty Leave Report
23. Employee Detail By Department 59. PAYROLL RUN SCHEDULE 92. Blue Cross Monthly Reconciliation
24. Fund Summary 60. GL Posting SUSPENSE TRANSACTIONS 93. Health Insurance Premium to Claims
25. Dept Summary 61. WARRANT VOUCHER Comparison by Organization
26. Department and Position Title Summary 62. Check distribution Journal voucher 94. EMPLOYEE PAY OVERRIDE
27. position title , fund and org summary 63. Labor Distribution Journal Voucher ADJUSTMENT
28. Fund, Dept and Pos Title Summary 64. Payroll Time Card Detail 95. LEAVE SUM HOURS
29. Employees with Position by Dept. 65. Create ACH Tape & Report 96. Hartford HVAD
30. Headcount by Position Type 66. Earnings History Register 97. Savings Bond Contributions
31. Employee Grade/Annual Salaries 67. Pay Detail by Employee Check Date 98. Payroll to Financial Posting Details
32. Position Stats by Pay Grade
33. Average Annual Salary by Position
Deloitte ConsultingNovember 2007 through June 2008
Developer- Oracle Workflow Developer, Oracle Discoverer Developer, Oracle BI Publisher developer, RICE Components , XML, XML Path, Xpath, XSL Style Sheets, XSL
Schema, XLIFF, XML Tree, XML Namespaces, XML DB
Software used - Oracle Discoverer 10g, Admin, Plus, Viewer and Desktop. Oracle database version 10g v2. Noetix Views and Administration. Toad, Sql Developer,
INFORMATICA ETL Powercenter versions 7.1.2 and 8.6 , Textpad, Sql Plus, JDeveloper, BI Publisher Enterprise Edition Oracle ERP implementations, version R12. HRMS,
Self Service, Payroll, OAB, Oracle Advanced Benefits, Benefits,
Multiple HRSSA (HR Self Service) Workflow modifications…
1. Termination workflow,
2. Change Pay,
3. Change Manager,
4. New Employee,
5. Approvals
6. Workflow Migration and setup using AME and Workflow Builder.
Developed HR Discoverer Business Areas, Folders and Reports. worked with Oracle Discoverer Admin tool, PLUS, Viewer and Desktop versions 4 and 10.
Developed the following Discoverer reports…
Payroll and Benefits Discoverer, Oracle reports and BI Publisher
Reports Developed…
Workers Comp Summary Report
Workers Comp Earnings By State Payroll Distribution Report
Costing Splits Labor Distibution Report
Salaried Employees with timecard = Yes Expense Report
Employees On LOA with timecard = NO Payroll Detail Report
Employees with no active salary The Neo Report
Salary Change not Approved Internal Promotions
No Active Salary Element in Current Pay Period New Hire Audit
On Leave with Hours Employee Roster Report
SSN Check for Newhires Hourly Structured Report
Gross Wages Over $_____ Cobra / Vacancy Report
Over 15 hours Overtime Earnings and Voluntary Deductions Report
GRE Not Equal To Payroll Cobra Report
Payroll Alternative Tax Audit Report OC Tanner Anniversary Report
Earnings And Deductions Report Termination Report
Employee Listing Report New Hire Report
Payment Register Report EEO Report
Payroll Management Report Bonus Earnings Report
ROE Report Job Code Listing report
State local Tax Info Report Monthly Anniversary Report
Tax audit report Monthly benefits Listing Report
Termination Report Cobra / Vacancy Report
Workers Comp Report Sick And Vacation Accrual Report
Flowserve October 2006 through November 2007
Oracle Discoverer Developer, Administrator and Trainer, DBI developer, XML Publisher Developer, RICE Components
Developed over 100 Discoverer reports from the Projects, Manufacturing, OM, AP, AR, GL, WIP, BOM, HR, Costing modules.
Customized Oracle DBI screens to accommodate the customer needs.
Conducted Code Reviews, Developed Standardization practices, Taught Discoverer Client and Admin classes to the end user.
Gathered requirements, tested, migrated, administrated all facets of Oracle Discoverer. Conducted Noetix Views administration, adding columns to Views etc…
Software used - Oracle Discoverer 10g, Admin, Plus, Viewer and Desktop. Oracle database version 10g v2. Noetix Views and Administration.
Oracle Applications EBS version 11.5.10, Toad, Sql Developer, Textpad, INFORMATICA ETL Powercenter versions 7.1.2 , Sql Plus, JDeveloper, BI Publisher Enterprise
Edition, XML Path, Xpath, XSL Style Sheets, XSL Schema, XLIFF, XML Tree, XML Namespaces, XML DB.
Sample of Oracle Discoverer and Oracle BI Publisher Reports Developed …
On Time Performance Percentages Overview by Date
Part Routing Report All Open Orders Detail Report
Number of items manufactured by date Order Management Price List Gap Analysis report
Jobs Completed by Date Order Management Quotes Details Report
Jobs in Testfield Check Billing Report Broken Down by Currency
Number of WIP Jobs Completed Customer Account Summary Report
Late WIP Job and Items by scheduled Completion date Customer AR Revenue Report
Jobs Released to Assembly by Date Customer AR Trial Balance Detail Report
Jobs Released to Manufacturing by Date Detailed Backlog Report
Last Movement Per WIP Job Active Vendors & Liability Account (US GAAP)
Tester Picklist PO Open Invoice Details Report
Number of Items Picked For Shipping By date Incomplete PO’s
Number of Items Shipped By date Incomplete Requisitions
All Total Paid Invoices summed and Grouped by vendor Late open PO’s by promise date
Amount Spent Detail By Vendor, by Invoice Late open PO’s by need by date
All Open PO’s Po’s with missing promise date
All Open PO’s Without Promise Date by Material Type GL Interface Check
OTD Detail by Vendor Report, by Promise Date Versus Delivery Date MFG Demand history
OTD Summary By Vendor and Commodity Code, by Promise Date Versus MFG Outside processing Report
Delivery Date PO Purchasing “Move in And “Move Out
OTD Summary By Vendor, Based on Promise Date Versus Delivery Date PO Invoicing Split by Vendor
OTD Detail by Vendor Report, by Required Date Versus Delivery Date Parts Booking Metrics
On Time Delivery Summary By Vendor and Commodity Code, by Requested Parts Booking Report over 50K By Customer
Date Versus Delivery Date Parts Group Purchasing Metrics
OTD Summary By Vendor, by Requested Date Versus Delivery Date Receipts Awaiting Inspection
Shows the invoices that are received from transporters in the specified period Inventory Royalty Report
Shows the sum of the invoices received from transporters by month by New item Report (Attributes, CrossRefs and Categories)
transporter New item Report (Attachments)
Scheduled Shipments in a Period Engineering Pending Items
On Time Performance details by Customer OTD Detail by Vendor Report by Request Date
Medco, Accredo Health Group – Memphis, TN. May 2006 through October 2006.
Workflow developer - Managed, maintained, modified and developed additional functionality to existing complex order processing workflow processes.
Troubleshot bugs, documented requirements, developed pl/sql code, developed workflow functions, attributes, design, architecture, lookup types, processes, messages, business
events, conducted testing, final documentation and code packaging and registration.
Data Architect – architected complex database structures to accommodate requiems of XML data types 270, 271, 276 and 277. Devised logical architecture from DTD’s,
architected physical architecture and developed (and packaged) code to create and validate new database objects to support EDI architectures. Wrote code to import code from
XML transmissions into the database, and wrote code to extract data from database for external xml transmission.
Software utilized – Oracle 9i, Oracle 10g, Oracle Workflow Builder 2.6, Jdeveloper 10g (release 3{10.1.3}), Oracle PL/SQL ( packages, functions, triggers and Procedures),
Visio, Toad, SQL Navigator, SQL Plus, HP Unix, Textpad, Rational ClearCase, Oracle Reports 6i and 9i, Oracle Discoverer 10g,, Microsoft Powerpoint, Word, Excel, Telnet,
Hummingbird telnet and ftp, XML, BI/XML Publisher, XML Path, Xpath, XSL Style Sheets, XSL Schema, XLIFF, XML Tree, XML Namespaces, XML DB
Lawrence Livermore National Laboratory - December 2005 through May 2006.
Peoplesoft 8.01 to Oracle Applications 11.5.10 Conversion
Oracle Applications HRMS and Payroll developer. Developed extensions, Workflows, RICE Components and Discoverer reports for the following components…
1. Detail and Summary Earnings report for Workers compensation insurance premium report in Discoverer
2. Bond Purchase report in discoverer
3. Direct Deposit transmittal process in PL/SQL with discoverer report
4. Leave of absence report in discoverer
5. Leave of Absence Billing process in Workflow
6. Charitable deductions process in Pl/SQl, forms and Discoverer reports
7. Miscellaneous Payments processing in PL/SQL and Discoverer for reporting
Software used: TOAD, Secure Shell FTP, Secure Shell Telnet, SQL PLUS, PL?SQL, Oracle 9i, Oracle 10g, Oracle Applications 11.5.10, Workflow Builder, Textpad, SQL
Navigator, OEM.
Oracle Corporation. Pittsburgh, PA. And Baltimore , MD August 2005 through December 2005.
10g Discoverer Developer. Created Administrative layer objects, RICE Components , database objects and client report creation. Designed and implemented business wide rollout
of Discoverer across corporate seven corporate locations. Worked with management to define Discoverer business requirements and expectations. Implemented Discoverer 10g
company wide, including 10g database, administrative layer and client viewer and plus products.
11i Applications Workflow Developer for 11.5.10 upgrade from 11.0.3.
Conducted requirements gathering meetings with end user groups. Advised end users on workflow functionality during requirements gathering and documentation phase.
Developed RICE Components, and extensive modifications to the PO APPROVAL Workflow to accommodate 10 different custom checkpoints with multiple complex approvals
per checkpoint. Also modified seeded AP EXPENSE REPORT APPROVAL, PO ACCOUNT GERNERATOR, AP ACCOUNT GENERATOR. Conducted
troubleshooting and maintenance of existing Discoverer reports. Loaded workflows, replaced seeded workflows, ran workflow maintenance scripts against database.
Software used: TOAD, Secure Shell FTP, Secure Shell Telnet, SQL PLUS, PL?SQL, Oracle 9i, Oracle Applications 11.5.10, Workflow Builder, Textpad, Informatica ETL tool.
SQL Navigator, OEM.
Los Alamos National Laboratory, New Mexico. October 2003 through August 2005.
Workflow developer, Data Architect, Discoverer Developer and Reports 6i and 9i Developer.
Project 1 Architected and Developed a Process Navigator Oracle Workflow (v2.6.3 Business Event System) application within Oracle Applications 11.5.9 to
process AFP/MARS funding data that is received monthly from the DOE. Modified and customized Oracle Workflows, reports to satisfy customer
needs. Wrote 20 separate PL/SQL packages and shell scripts to support workflows. Performed 11i Applications administration tasks for Federal
Financials users reports and workflows. Worked with Oracle Applications 11.5.9 modules: AP, AR, GL,Manufacturing, RICE Components, WIP, HRSSA, HR.
Other
software used: IBM AIX, Kintana, PVCS, SSH/Telnet, Domino. Concurrent Manager, Program and executable definition, Setups for apps, reports,
extensions, events and Workflows. Exceed, Oracle Enterprise Manager, FTP, Telnet, TOAD, SQL Navigator, Quest Spotlight on Oracle And Spotlight
on Oracle Applications. 11i Patches. Modified HRSSA workflow including Compensation Distribution. Oracle 11i Applications Federal Financials.
Also have a C level security clearance. Projects at LANL: EP, STARS, SWIMS, BASIP, MEPP.
Project 2 Designed and architected a Bar code scanning and printing application to work with the Inventory and Manufacturing modules of Oracle Applications version
11.5.10 Designed printing of Lot Control, Revision Control, serial Control, no control bar, and locator bar code labels.
Developed the Hand Held application to interact with Oracle Apps to conduct Account Alias Issue, Account alias Receipt, Sub inventory transfer,
Intransit shipment and Cycle Count Entries. MTL Transactions interface API and Cycle count API.
Developed requirements, design documents, reports, forms, PL/SQL, testing documentation.
Used Oracle Forms 9i, Reports 9i , Discoverer 4i and 10g, PL/SQL, Workflow, TOAD, Kintana (Mercury) , PVCS, Oracle 9i RDBMS, Handheld devices- Intermec
and Symbol models. WIP, BOM , INV, ONT, Manufacturing Modules.
Midmark Corp. Versailles, Ohio. August 2004 through July 2005.
Oracle Discoverer Developer . Oracle Applications version 11.5.10. Developed hundreds of Oracle Discoverer reports and RICE Components for Order Management,
Manufacturing, GL, AR, education, Sales and HR Modules. Worked closely with customer to give them a customized solution that was performance tuned for fast results.
Developed using both the administrative layer and client layer of both Discoverer versions 4i and 10g.
CMD Services, Atlanta, Georgia. August 2003 through Present.
Oracle v4 and v6i Discoverer Developer, Workflow 2.63, RICE Components , Reports 6i and 9i. Developed administrative layer and over 100 client Discoverer reports for Oracle
11i Applications. Also produced many reports using Oracle Reports 6i. Modules used: Order Management, WIP, Manufacturing, Inventory, GL, AP, PO, HR, Sales, Financials,
Shipping, Oracle DB ver 9.0.2. Oracle 9iAS. Discoverer 4 and 6i, Oracle Reports 6i.
Alcoa Inc. August 2002 through July 2003
Global Oracle 11i Applications installation. Converted 100 legacy Order Management and Manufacturing, Oracle Quoting & Contracts database reports and charts into 11i
Applications. Used Oracle IDS (Internet Development Suite) version 6i, Oracle Database version 8.1.7, Reports 6i and 9i , Workflow 2.6, Oracle Discoverer 4.0, 6i Forms, RICE
Components , SQLPlus, PL/SQL, TOAD, SQL Navigator, Sun Unix, HP Unix, Oracle 11i Applications Suite version 11.5.7 .Modules: Manufacturing, Order Management, Order
Entry, AP, AR, Inventory, WIP.
British Aerospace Engineering Systems Inc. September 2001 to August 2002
Oracle 11i Applications Technical consultant. (Versions 11.3.4, 11.5.3 , 11.5.4 and 11.5.5) Oracle custom report conversions and troubleshooting, Workflow Builder v2.5 and 2.6,
billing extension reports conversion & migration & troubleshooting, Reports Builder 6i for UNIX and NT, Concurrent Manager, Program and executable definition, Setups for
apps, reports, extensions, events and Workflows. FNDLOAD, WFLOAD, Process Navigator, Application lookup definition, RICE Components , Oracle Workflow, Oracle
Discoverer, Oracle RDBMS DB v 8.1.6 and 8.1.7. AD Patch, SQL, PL/SQL, SQL Plus v8.x, Sun OS and Sun Unix, Exceed, Oracle Enterprise Manager, FTP, Telnet, TOAD, SQL
Navigator, Quest Spotlight on Oracle And Spotlight on Oracle Applications. 11i Patches. Worked with Oracle Project Contracts, Oracle Financials (FA, AP), Order Management,
Oracle Quoting & Contracts, Manufacturing (Quality, WIP) issue, reverse issue, Discrete jobs creation (standard and non standard) , Issue parts to Discrete jobs , Inventory
modules, Report Builder, Designer 6i, Extensions, conversion.
Workflows Reports
Modified or Developed Modified or Developed
Project Supplier Invoice Account Generator PA Progress Payment 1443 report
FA Account Generator AP Check Form (from Evergreen)
OM Generate Cost Of Goods Sold PA Billable Cost by Burden Center – Project
PO Account Generator PA Billable Cost by Burden Center – Task
PO Change PA Cost Ledger by Contract – Project
PO Requisitions Account Generator AR Aging Statement - by FBU, Prod Line, and
PO Requisitions Approval Program
WIP Assembly Removal (Process Navigator) AR Aging Statement
PO Line Creation AR Aging Statement - Invoice Details
HRSSA AR Aging Statement Miscellaneous Invoice
AFP/MARS Funding Data Processing (Process PA CTD Billing Status
Navigator) PA Contract-To-Date Cost Of Sales
PA Revenue By Worksite Report
PA Billing Detail by Work Order
Extensions PA Billable Cost by Project
Modified or Developed
PA: Cost of Sales Transaction Import Batch Delete
PA: Cost of sales interface
PA: Cost Plus Fee
PA: Progress Payment
Billing T&M Withholding
Shipment Billing
April 2001 to August 1, 2001
Oracle Applications DBA/functional
Installed and configured Oracle Applications 11.5.3. for an Oracle CRM, Order Management project. Installed 8.1.6. RDBMS, Forms server, Reports server, Admin server,
Concurrent processing server, HTTP web server and Apache server.
Oracle Workflow Builder. Designed new workflows and customized standard workflow diagrams. Oracle 11i (11.5.3) System Administration. Created users, menus,
responsibilities, functions, set up printers etc… Some experience with Oracle 11i Order Management, RICE Components , Inventory, invoicing, Sales orders, created items and
customers, cross referenced items, created customer profiles, basic pricing etc…
June 2000 to April 2001
Oracle Data Architect and DBA
Installed and configured Oracle Applications 11.5.3. for an Oracle CRM, Order Management project. Installed 8.1.6. rdbms, Froms server, Reports server, Admin server,
Concurrent processing server, HTTP web server and Apache server. Oracle Workflow Builder. Designed new workflows and customized standard workflow diagrams. Oracle 11i
(11.5.3) System Administration. Created users, menus, responsibilities, functions, set up printers etc… Oracle 11i Order Management, Inventory, invoicing, Sales orders,
created items and customers, cross referenced items, created customer profiles, basic pricing etc…
Oracle 8i (versions 8.1.5, 8.1.6 and 8.1.7 (beta). PL/SQL Procedures, Packages, triggers and functions. Completely redesigned current reporting application and databases (order,
webgui, netlink/realtime and preorder). Six Sun Enterprise Servers (24 processors, 3 terabytes of storage, 12 gigs ram each). By implementing my design , I Reduced processing
time from 3 hours down to 10 minutes.
Redesigned total database application from SQLloader to database processing to web page reporting . (Oracle Database objects and Stored Procedures). Performance Tuning, SQL
tuning, Materialized Views, Data Migration, Table Partitioning, Local and global indexing, SQL Hints, Parallel Query Option, Tuning Initsid.ora, SQL and Procedure tuning, Shell
Scripting, Procedure scripting, Complete installation and configuration of Oracle 8.1.5, 8.1.6 and 8.1.7. and 9i app server and 9i DB (Beta). Oracle Parallel Server, Oracle
Replication, Oracle Parallel Fail Safe. Veritas file system duplication.
Sun v2.6 e4500, e6500 and e10000’s. EMC Frames. Veritas volume manager, Oracle Enterprise Manager v2i, Designer v6i., TOADsoft, SQL Navigator, Textpad, Visio
Professional, Erwin, SQLPlus. Dreamweaver, HTML. EDI. PVCS Tracker.
Ernst and Young - January 2000 to June 2000
Oracle DBA and Data Architect/Modeler.
Oracle versions 8.0.4.3, 8.0.5 and 8.1.6 . PL/SQL Procedures, Packages, triggers and functions. Constructed, migrated and maintained 10 databases (development, Test and
Production) on a 3 Terabyte Data Warehouse (DSS) on Sun E10000 Server hardware with 24 processors and 12 gig of ram with an EMC 3 Terabyte storage system. Sun Solaris
v2.6. Xwindows (Exceed), Sun E10000 hardware, Best 1 Software, Veritas Filesystems and back up etc…PL/SQL and SQL scripting, debugged procedures, package bodies,
functions and packages, daily Oracle maintenance. Capacity Planning. SQL Navigator, TOAD, OEM, ERWIN, RedHat Linux v 2.6. Database planning, capacity, installation,
database migration. created synonyms, procedures, tables, partitioned tables and indexes, users (schemas), datafiles, tablespaces, granted rights etc… Supported 25 developers.
February '98 January 2000
Education
Master Certified 11i Oracle Applications IT Professional
Master Certified Oracle Database Administrator
Instructor Led Training:
Oracle XML 10G
Oracle BI Publisher 10g
Oracle Advanced PL/SQL Units
11i Oracle Workflow Development
11i Oracle Workflow Administration
11i Oracle Applications System Administration
11i Install, Maintain and Patch Oracle Applications
r11i Oracle use and install Order Management
6i Oracle Report Builder
6i Oracle Forms Builder
Oracle Discoverer v 4.0
Oracle Discoverer Administrator v4.0
Intro to Oracle - SQL
Oracle Data Modeling and Database Design
Oracle Performance Tuning
Oracle Backup and Recovery
Oracle Network Administration
Oracle Database Administration
Oracle PL/SQL
Oracle Developing PL/SQL Program Units (Packages, Procedures, Functions and Triggers)
Oracle Parallel Server
Oracle Discoverer 10g Administration
Oracle Discoverer 10g Develop Reports
Cisco Router Certification Classes
December, 1997 ICRC Cisco Router Configuration
Novell C.N.E.
v 4.1 1995-1996 Novell Inc.
v 3.12 1993-1994 Honeywell Allied Data Comm.
Microsoft NT 4.0 Training
Windows NT 4.0 Server
Windows NT 4.0 Workstation
Bachelor Of Arts
2001 Masters Degree in Oracle 11i Applications (Oracle)
1999 Masters Degree in Database Administration (Oracle)
1986-88 University of North Florida
1983-86 Jacksonville University
AFFILIATIONS- 4/1996 – Present Oracle Users group
1/2000 – Present Oracle Applications User Group