Mitchell Wrobel DBA, C

Mitchell Wrobel DBA, C

Mitchell Wrobel

2774 North Cobb ParkwaySuite 109-321
Kennesaw, GA30152
Cell: 678-480-8263
/ Certified Master Developer
Certified Master DBA
Noetix Certified Professional
Informatica PowerCenter Developer (v 8 and 9)
Oracle OBIEE (v 10 and 11) Repository developer
Oracle OBIEE (v 10 and 11) Report developer
Oracle EBSApplications 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 Discovererroll - 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 andmanagethe global reporting strategy utilizingOracle OBIEE, Informatica, Oracle BI Publisher, Oracle Discoverer and Noetix Views for the global R12implementation.
  1. Work with end users and location management to gather reporting requirements and develop custom reports for the needs
  1. Develop all custom reports
  1. Use the Discoverer Administrator product, OBIEE Repository , and Informatica PowerCenter to manage data sources and security for the reporting solution.
  1. Develop custom extensions to the Oracle R12 applications toaccommodatethe special functional needs of the customer. In this case, it is a manufacturing extension tomeet the additional datacapturing 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
Finance Overhead Rates
Finance Resource Rate
Finance Sbn Conversion
Finance Uncosted Transactions
Inventory – Slow And Obs
Item Attributes Report Set
Us Ar - Customer Credit Report
Us Finance Job Data
Us Finance Job Data By Item
Us Finance Job Info
Us Intransit Transactions
Us Inv License Plate Numbers (Pallets) View
Us Inventory Transactions W Amounts
Us Oracle Responsibilities And Users
Active Pricing
Active Pricing (With Customer Item Info)
Ap - Credit Memo Listing
Ap - Accrual Reconciliation
Ap - Accrual Reconciliation Report
Ap - Audit Info By Date Range
Ap - Employees Set Up As Suppliers
Ap - Errors - Employees With Incorrect Terms
Ap - Holds - No Po Holds
Ap - Holds - Price Holds To Be Released
Ap - Holds By Buyer
Ap - Invoice Distributions
Ap - Invoice Payments By Vendor
Ap - Invoices For Defined Period And Vendor
Ap - Month End - Ap Forecast Report.Dis
Ap - Monthly Vendor Activity Report
Ap - Payables Distribution Report Cm
Ap - Payables Non Validated Invoices
Ap - Payables Unvalidated Invoices
Ap - Po Distribution Detail Report With Amounts And Vendor
Ap - Po Service Receipt Report
Ap - Service Po Confirmation
Ap - Service Po Exposure Report
Ap - Service Po Exposure Review
Ap Monthly Review
Ar - Us Customer Credit Check
Ar - Aging Buckets Report
Ar - Cogs
Ar - Custom Aging Buckets Report-
Ar - Customers And Contacts
Ar Cash Forecast
Ar Credit Customer Reports
Ar Customer Data
Ar Daily Freight Transaction Report
Ar Daily Invoice Transaction With Packing List Info
Ar Monthly Invoice Transaction Report- (For All Transaction Types)
Ar_ Custom - Daily Invoice Transaction With Packing List Info
Ar_Freight Report
/ Bom - Job Close Variance Report.
Bom - Bom List
Cycle Count Listing By List Price Per Unit_
Dsz-Open Orders Report With Job
Eta Verification Against Gl Date
Fa - Assets By Department And Book
Finance Rm Consumption
Finance-Month End Inventory Report
Inter-Co Pos Pl With Drop Ship Tab
Inv - Additional Item Information
Inv - Inventory Planning Method
Inv - Item Information
Inv- Customer Item Cross Reference
Inventory Age
Inventory Sfg-Pfg-Fgi
Item Attributes Report
Item Cost
Item Set Up Check
Manufacturing And Engineering Report
Material Cost Check 1
Material Cost Check 2
Material Utilization Report
Monthly Sales Summary
Om - Customers, Items And Descriptions
Om - Orders, Customers And Salesreps
Om - Sales Quantities By Order Date And Invoice Date
Om - Sales Quantitiesfor 2010 By Product Line
Ont - Order Info With Lot
Oracle Super Users
Orders And Shipments
Orders And Shipments - By P.O - Dlvy Date
Po- Open Po Report For All Locations
Po- Po Report For All Locations
Production Waste Report
R12 Orders And Shipments
Receipts By Product
Sales And Use Tax Report
Sales Volume Ar And Om
Service Po Fulfillment Status
Sy - Responsibility Access Changes
Universal_Inventory Sfg-Pfg-Fgi
Us - - Purchase Order Report
Us - Production Transactions By Item
Us - Waste Reports
Us - Electronic_Packing_List
Us - Inventory_By Item With Lot Detail
Us - Nventory_Repor
Us - Open Order By Status
Us - Open Orders By Product Line
Us - Open Price List
Us - Production Transactions By Lpn & Lot Detail
Us - Responsibility Access Changes
Us - Shipped Order Report
Us Common - Intercompany Invoice Report
/ Us Customer Service- Inventory By Org By Subinventory
Us Database Audit - Gl Wand Users
Us Database Audit - Oracle Responsibilities - All Users
Us Finanace - Ap Trial Blanace Report
Us Finanace - Ap Trial Blanace Report – Capital Spending
Us Finanace - Om Customer Aging Reports
Us Finance - Lot Control Inventory Aging Report
Us Finance - Sales And Use Tax Report
Us Finance - Waste By Product Line
Us Finance - Com
Us Finance - Inventory Summary Report By Product Line
Us Finance - Je Report With User Id's
Us Finance - Open Po Report
Us Finance - Pallet Production By Product Line
Us Finance - Po Invoice Report
Us Finance - Po Open Requisitions
Us Finance - Po Receipt Report
Us Finance - Po Review
Us Finance - R&D Cost Summary
Us Finance - Rm Wip Job Information
Us Finance - Shipments By Priduct Line
Us Finance – Stores Inventory
Us Finance - Vendor Info Report
Us Fpa Expanded Cost
Us Hr - Medical And Dental Coverage And Premiums
Us Inventory- Inventory By Account
Us Purchasing - Vendor Addresses
Us Sales - Detailed Sales Reports - By Customer By Item
Us Sales - Sales Reports
Us Sales - Sales Reports (Open, Shipped, All Orders)
Us_ Finance - Us Finance Job Variance Summary
Us_Commom_Inventoryproduction-Transactions
Us_Common - Descriptive Flexfield Segments
Us_Common - Responsibility Inclusions
Us_Common All Menus, Apps And Functions By Responsibility Report
Us_Common Menu Exclusion Report
Us_Common- Po Approval Limits Report
Us_Common_Inventory By Lot And Product Line
Us_Common_Requisitions For Projects
Us_Common-Financial Budget Set
Us_Common-Open Orders Report
Us_Common-Responsibility And Menus Report
Us_Common-Responsibility Exclusions
Us_Finance - Item Setup 999 Account Coding
Us_Finance - Reclaim Inventory
Us_Finance - Item Cost
Us_Finance - Zero Cost Item
Us_Finance- Ap Payables Distribution Report
Us_Finance-Month End Inventory Report
Us_Sysadmin-Responsibility_By_User

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…
  • PO Requisition – Approval
  • PO - Approval
  • AP - Approval
/ Interfaces Developed…
  • Colonial Life
  • Hartford HVAD
  • ICMA deferred comp
  • ING-Aetna deferred comp
  • Nationwide 401k contributions
  • Nationwide deferred comp
  • Savings bond purchase
/ Oracle Reports Developed…
  • Employee Pay Override Adjustment
  • HR Change Report - Add New Employee
  • HR Change Report - Name Change
  • HR Change Report - Position, Pay Change etc…

Developed the following Oracle Discoverer Reports/BI Publisher Reports …
  1. Leave Tracking Report
  2. Personal Leave Summary Report
  3. Employee Statistics by P/R Unit and Emp Name
  4. Employee Sex and Race Report
  5. Employee Age & Sex By Position, ORG
  6. Holiday Time Cards Missing for DateRange xx/xx/xxx to xx/xx/xxxx
  7. Leave Balance for Inactive Employees
  8. Personal Leave Summary Days
  9. labor distribution report
  10. Employees with COMP Leave
  11. EEO4 Employee Details Report
  12. Listing of Negative Leave Accrual
  13. Human Services Annual Leave Report
  14. Personnel Listing by Name
  15. New Hire File
  16. Employee Diversity Report
  17. Employee Position Roster
  18. Employee Count by Position/Org
  19. Head Count by Organization
  20. Position Detail by Fund
  21. Position Detail By Department
  22. Employee Detail by fund
  23. Employee Detail By Department
  24. Fund Summary
  25. Dept Summary
  26. Department and Position Title Summary
  27. position title , fund and org summary
  28. Fund, Dept and Pos Title Summary
  29. Employees with Position by Dept.
  30. Headcount by Position Type
  31. Employee Grade/Annual Salaries
  32. Position Stats by Pay Grade
  33. Average Annual Salary by Position
/
  1. Trial Balance Detail Report
  2. Employee Roster on Pay Plan
  3. General Pension Plan Enrollment
  4. Employee maintenance report
  5. List (New Hires), Terminations, Etc.
  6. Employees XX Years Old & Over
  7. EEO4 Position Report
  8. ING Deferred Comp
  9. ICMA Deferred Comp
  10. Fire and Police interface
  11. Nationwide Deferred Comp
  12. Years of Service
  13. Listing of Temporary Employees
  14. Payroll auth form to sign
  15. Employee Address Report
  16. Payroll Checklist
  17. Employee Address Change
  18. Health Savings Account
  19. Hartford 401A Contributions
  20. Deferred comp report
  21. Payroll Register Detail
  22. Check Register Selection
  23. Deduction Preview Report
  24. Warrant And Journal Vouchers
  25. GL Posting RECONCILIATION REPORT
  26. PAYROLL RUN SCHEDULE
  27. GL Posting SUSPENSE TRANSACTIONS
  28. WARRANT VOUCHER
  29. Check distribution Journal voucher
  30. Labor Distribution Journal Voucher
  31. Payroll Time Card Detail
  32. Create ACH Tape & Report
  33. Earnings History Register
  34. Pay Detail by Employee Check Date
/
  1. Detailed Overtime Report
  2. Summary Overtime Report
  3. QTD/YTD Register
  4. Multiple Worksite Supplement
  5. Payroll Taxes from GL
  6. Colonial Life Rpt & data file
  7. Employee Court Deductions
  8. Employee Deduction Report
  9. Court Termination/Stop Letters
  10. Deduction History Report
  11. Monthly Deductions by Fund
  12. Operating Engineers Pension Report
  13. Form W-2
  14. Life Insurance Discrepancy Report
  15. Basic Life Insurance Report
  16. Long-Term Disability Report
  17. Retiree Costing Report
  18. Employee Who Have Stopped Benefit Deductions
  19. Blue Cross Dental Reconciliation
  20. Employees Not Paid Report
  21. Benefit Discrepancy Report
  22. H.S.A. Premium Status Report
  23. Employee Cafeteria Enrollment
  24. Injured on Duty Leave Report
  25. Blue Cross Monthly Reconciliation
  26. Health Insurance Premium to Claims Comparison by Organization
  27. EMPLOYEE PAY OVERRIDE ADJUSTMENT
  28. LEAVE SUM HOURS
  29. Hartford HVAD
  30. Savings Bond Contributions
  31. Payroll to Financial Posting Details

Deloitte Consulting November 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 EditionOracle 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 Earnings By State
  • Costing Splits
  • Salaried Employees with timecard = Yes
  • Employees On LOA with timecard = NO
  • Employees with no active salary
  • Salary Change not Approved
  • No Active Salary Element in Current Pay Period
  • On Leave with Hours
  • SSN Check for Newhires
  • Gross Wages Over $_____
  • Over 15 hours Overtime
  • GRE Not Equal To Payroll
  • Payroll Alternative Tax Audit Report
  • Earnings And Deductions Report
  • Employee Listing Report
  • Payment Register Report
  • Payroll Management Report
  • ROE Report
  • State local Tax Info Report
  • Tax audit report
  • Termination Report
  • Workers Comp Report
/
  • Workers Comp Summary Report
  • Payroll Distribution Report
  • Labor Distibution Report
  • Expense Report
  • Payroll Detail Report
  • The Neo Report
  • Internal Promotions
  • New Hire Audit
  • Employee Roster Report
  • Hourly Structured Report
  • Cobra / Vacancy Report
  • Earnings and Voluntary Deductions Report
  • Cobra Report
  • OC Tanner Anniversary Report
  • Termination Report
  • New Hire Report
  • EEO Report
  • Bonus Earnings Report
  • Job Code Listing report
  • Monthly Anniversary Report
  • Monthly benefits Listing Report
  • Cobra / Vacancy 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 …
  • Part Routing Report
  • Number of items manufactured by date
  • Jobs Completed by Date
  • Jobs in Testfield
  • Number of WIP Jobs Completed
  • Late WIP Job and Items by scheduled Completion date
  • Jobs Released to Assembly by Date
  • Jobs Released to Manufacturing by Date
  • Last Movement Per WIP Job
  • Tester Picklist
  • Number of Items Picked For Shipping By date
  • Number of Items Shipped By date
  • All Total Paid Invoices summed and Grouped by vendor
  • Amount Spent Detail By Vendor, by Invoice
  • All Open PO’s
  • All Open PO’s Without Promise Date by Material Type
  • OTD Detail by Vendor Report, by Promise Date Versus Delivery Date
  • OTD Summary By Vendor and Commodity Code, by Promise Date Versus Delivery Date
  • OTD Summary By Vendor, Based on Promise Date Versus Delivery Date
  • OTD Detail by Vendor Report, by Required Date Versus Delivery Date
  • On Time Delivery Summary By Vendor and Commodity Code, by Requested Date Versus Delivery Date
  • OTD Summary By Vendor, by Requested Date Versus Delivery Date
  • Shows the invoices that are received from transporters in the specified period
  • Shows the sum of the invoices received from transporters by month by transporter
  • Scheduled Shipments in a Period
  • On Time Performance details by Customer
/
  • On Time Performance Percentages Overview by Date
  • All Open Orders Detail Report
  • Order Management Price List Gap Analysis report
  • Order Management Quotes Details Report
  • Check Billing Report Broken Down by Currency
  • Customer Account Summary Report
  • Customer AR Revenue Report
  • Customer AR Trial Balance Detail Report
  • Detailed Backlog Report
  • Active Vendors & Liability Account (US GAAP)
  • PO Open Invoice Details Report
  • Incomplete PO’s
  • Incomplete Requisitions
  • Late open PO’s by promise date
  • Late open PO’s by need by date
  • Po’s with missing promise date
  • GL Interface Check
  • MFG Demand history
  • MFG Outside processing Report
  • PO Purchasing “Move in And “Move Out
  • PO Invoicing Split by Vendor
  • Parts Booking Metrics
  • Parts Booking Report over 50K By Customer
  • Parts Group Purchasing Metrics
  • Receipts Awaiting Inspection
  • Inventory Royalty Report
  • New item Report (Attributes, CrossRefs and Categories)
  • New item Report (Attachments)
  • Engineering Pending Items
  • OTD Detail by Vendor Report by Request Date

Top View