SUMMARY

• 13 years of systems and business analysis including meeting with functional and technical personnel to gather and document requirements for Oracle EBS support and implementation, data warehouse projects and other IT projects also, extensive documentation of business process improvements, testing, software evaluation, and providing support and instruction to other team members
• 8 years of implementation and technical and functional support on Oracle E-Business EBS Releases 10.7 through 11i and R12
• 3 years of Oracle DBA experience on Oracle EBS systems and over 3 years of DBA experience on non-EBS Oracle databases versions 7 through 11g
• 4 years of Oracle data warehouse experience including data analysis and conversion, system design, database and table creation, extensive SQL and PL/SQL, and testing experience with Cognos 7 8 administration, cube building and report generation and Oracle OBIEE 11g
• 3 years project management/senior experience including managing teams of analysts, delegating and evaluating work, and managing IT projects
• 12 years of accounting experience and active CPA license
• Active Secret DoD Clearance

PROFESSIONAL Experience

Confidential

Oracle Apps DBA and SOA Consultant

• Part of a contract to provide DBA and SOA support for the Marine Corps' GCSS Logistics system on Oracle EBS 11.5.10 and SOA 10g
• Restored clone of the Oracle EBS 11.5.10 apps tier and database tier for a training instance
• Applied patches and security updates to the Oracle EBS 11.5.10 system and 10g database
• Part of the R12.2.4 upgrade team on training instance applied apps tier and database tier patches and upgrades
• Installed and configured a new training instance SOA 10g middleware including BPEL, Oracle Web Services Manager OWSM , and B2B also installed the Oracle 10g database for use with the middleware
• Installed SOA 11g middleware including WebLogic Server, B2B, Oracle Service Registry, and configured the systems as needed also installed the Oracle 11g database for use with this middleware
• All systems were on Red Hat Linux worked from the command line as well as through GUI interfaces such as OEM, SQL Developer, SOA 10g OEM console, and WebLogic for SOA 11g

Confidential

Technical and Functional Sr. Oracle Consultant

• Part of a contract to support the Marine Corps' GCSS Logistics system on Oracle EBS 11.5.10
• Analyzed the CEMLI/RICE objects present in the Oracle E-Business 11.5.10 system to prepare for the R12 upgrade
• Prepared whitepapers and briefs on:
• The projected technical needs for the R12 upgrade as well as the projected resources needed for the upgrade
• Recommendations on upgrade vs. a re-implementation
• Documented discrepancies in the custom code and impact on the upgrade
• Briefs on suggested solutions for business process improvement including replacing some custom code with R12 functionality
• Made recommendations for business process and technology improvements, found discrepancies in the code and design for SOA components, and documented the technical and business processes for the CEMLI/RICE objects using Oracle Business Process Architect, Word, Excel, and Visio
• Evaluated additional modules in R12 which could replace some of the CEMLI/RICE customizations
• Modules currently in production: GL, AP, AR, PO, FA, Advanced Supply Chain ASCP , Field Service, Demand Planning, Oracle Access Manager and Identity Management OAM/OID , and other modules

Confidential

Systems Analyst

• Lead Oracle consultant on a team to evaluate and make recommendations for optimizing the core accounting systems Oracle EBS 11.5.10 for the US Coast Guard recommended R12 modules and functionality
• Gathered business and operational requirements for a new system
• Identified data interfaces, data integrity issues, and began to formulate possible solutions

Confidential

Sr. Data Warehouse Analyst

• Led sessions to interview the clients to determine data and reporting requirements for data warehouses and dashboards
• Analyzed data, built Oracle databases, tables and scripts for staging tables and data warehouse tables
• Performed data analysis using SQL and TOAD and wrote PL/SQL to perform calculations
• Developed and wrote design specifications, functional requirements and technical requirements
• Implemented the data warehouses, built the OBIEE repository, and built the OBIEE dashboards including analyses in BI Answers and reports

Confidential

Business Analyst Lead

• Part of a team to design, test and, implement Oracle Financials R12
• Participated in client interview sessions to document business requirements and process flows
• Documented the client's business process flows in Visio for Procure to Pay, Sales to Cash, and for Modules: GL, AR, AP, PO, Inv, OM, FA, and Projects Costing

Confidential

IT Controls Analyst

• Short-term contract - Part of a team to design, test, and document the IT controls for the Treasury's software applications
• Evaluated the systems to be tested and design test plans for the systems' controls to be tested
• Followed federal policies to determine the necessary tests for compliance

Confidential

Business Analyst

• Short-term contract to evaluate the current financial systems to determine ERP system replacement or improvements
• Evaluated the client's current installation of Oracle Financials EBS Rel. 11.5.10 GL, AR, AP, PO, FA and CM to evaluate whether the system should be replaced or upgraded to Oracle R12
• Interviewed system users to determine any functionality that is missing or incorrectly configured, desired reports, and other business and system needs
• Wrote brief on the results of my analysis and made recommendations for improvements

Confidential

Sr. Oracle Systems Design Analyst

Part of a team to design new systems for most of the DMV's functions

Major Contributions:

• Participated in business process re-engineering BPR sessions to document business process
• flows using UML software Enterprise Architect/SPARX
• Evaluated current business and accounting procedures surrounding the client's current installation
• of Oracle EBS 11.5.10 GL, AP, PO, Inventory to determine the implementation of Rel. 12 and additional functionality to be added from the Oracle E-Business suite as well as evaluating COTS products for business rules, business intelligence BI suites, and other software to replace/complement other DMV software
• Interviewed business users and other personnel to clarify process, business and system requirements

Confidential

Oracle Financials EBS Systems Analyst/PL/SQL

Short-term contract to evaluate the company's need to move to R12 or not and to help clear a backlog of EBS issues

Major Contributions:

• Met with end users to evaluate and determine proposed configuration changes and customizations, made and tested configuration changes in Cash Management CM , Payables AP , and Discoverer with Noetix Built SQL and PL/SQL queries for ad hoc reports and system queries
• End user support system admin role for GL General Ledger , AR Accounts Receivable , AP Accounts Payable , CM Cash Management , and PO Purchasing
• Programmed PL/SQL extracts to resolve some data issues they were having
• Experience with multi-org and foreign currencies
• Analyzed system and made recommendations for their planned upgrade to Rel. 12 of Oracle Financials and to add the Fixed Assets FA module in R12

Confidential

Supervisor/Manager Financial Reporting Systems

Key Manager for this highly-visible team at this large international retail company providing SAP R/3 FI/CO and SAP-BCS consolidation system support

Major Contributions:

• Successfully charged with maintaining all master data, configuration changes, and security for the entire company US, Canada, and Mexico for the SAP FI/CO modules
• Extensive interaction with global system users to identify issues and prioritize system change requests and other systems analysis projects Interviewed personnel at all levels and departments to determine business requirements, issues, and configuration requests
• Partnered with information systems support to implement, test, and enact process and system improvements to all systems interfacing with the SAP R/3 FI/CO 4.6 and SAP BCS
• Managed a team of five financial systems analysts to align resources with company initiatives
• Instrumental in reducing hours during month-end close by 25