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 - Financials Systems

• 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

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

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

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

Confidential

Financial Systems Analyst/Project Manager for Cognos Migration

Major Contributions:

• Primary contact for all security, configuration changes, and master data maintenance on SAP 4.6 FI/CO and legacy systems
• Designed and built cubes in Cognos 7 Transformer and designed reports in the Cognos 7 PowerPlay reporting tool after collaborating with end users to determine their data and reporting needs
• Managed all aspects of the Cognos migration project to move the Cognos data warehouse database from Access to MS SQL Server
• Interviewed accounting executives and staff to evaluate software acquisitions and design new methods of extracting report data
• Created a data warehouse decision support system using the Oracle 10 database to achieve increased tax benefits through the Like-Kind exchange tax provisions Project included business requirements gathering, documentation, SQL and PL/SQL programming.

Confidential

Sarbanes-Oxley SOX IT Auditor

• Interviewed IT staff to understand and document their IT controls
• Tested the effectiveness of the IT controls by stepping through the IT control processes with IT staff
• Obtained electronic and physical documentation of the controls' effectiveness and design
• Documented, in a narrative format, the design and testing of control effectiveness in IT audit workpapers
• Extensive use of MS Sharepoint to maintain documentation, test results, and project plans

Confidential

Systems Analyst/Apps DBA/Re-implementation Project Manager

Major Contributions:

• Successfully supported the Oracle Financials version 11.5.3 and 11.5.9 modules GL, AP, PO, AR, CM, FA as apps DBA and
• Project team lead to manage the re-implementation on 11.5.9 so the chart of accounts could be reconfigured and the system installed on new hardware
• Logged TARs/ SRs with Oracle Support, performed database performance tuning and maintenance on Oracle Applications including managing concurrent managers, printers, revising Oracle report forms, managing users, and troubleshooting system problems
• Met with end users to resolve any system or training issues
• Designed and created a finance data mart on Oracle 9i database which slashed the time to generate critical reports by 80 Extensive use of Visio to document the database development
• Reduced the Oracle Financials system down time to less than 5

Confidential

Programmer Analyst

Major Contributions:

• Created programs using SQL, PL/SQL, and Unix scripts to automatically load data,
• perform complex calculations, and then, produce reports from this data warehouse data
• Calculated run time metrics and structured the code for the most efficient run time
• Reduced time to generate data warehouse reports by 50 .

Confidential

Oracle Apps DBA

Major Contributions:

• Performed database tuning, user setup, and maintained Oracle Applications EBS 11 for the GL, AP, PO, and custom AR modules on a Sun Solaris Unix system
• Worked with Oracle programmers and end users to support the on-going customization
• Development Documented system enhancements and additional database development performed

Confidential

Oracle Financials EBS Consultant

Major Contributions:

• Part of the team to install and configure the software including system security and roles,
• concurrent managers, printers and database tuning
• Interviewed upper management and key users to document business processes and accounting
• system requirements using Oracle AIM methodology with Visio and successfully resolved problems
• with Oracle Support
• Configured the AP module and part of the GL module setup

Confidential

Technical Writer

Major Contributions:

• Consistently met or exceeded all writing deadlines and, being one of the more prolific writers on the team, wrote more than initially scheduled
• Served as an accounting subject matter expert for other writers on the team

Confidential

Student - Programmer Analyst

Major Contributions:

• Played key role in SDLC by specifying the business requirements for this application as well as the
• creation of the data structure for the underlying database
• Creation of new application on the Oracle 7.3.4 database using Oracle Forms 4.5 and Reports 3.5
• Participated in the database system modeling and creation using ERwin
• Assumed additional responsibility by assisting the Project Manager to monitor the project status
• and deadlines in MS Project