SUMMARY

• 10 years of systems and business analysis including meeting with functional and technical personnel to gather and document requirements for Oracle Financials 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
• 5 years of ERP implementation and technical and functional support on Oracle E-Business EBS Releases 10.7 through 11i and Rel. 12 including:
• Financial modules: GL, AP, AR, Cash Management CM
• ProcureToPay P2P modules: PO and AP
• Assets: including Fixed Assets FA and Enterprise Asset Management
• Supply Chain modules: INV, Order Management OM
• Oracle EBS system administrator role to setup users, roles, responsibilities, and menus
• Apps DBA experience with Oracle Enterprise Manager, SQL Loader, TOAD, and SQL Developer
• DBA experience including patching, tuning, system architecture design, and logging SRs with
• Oracle Support
• Experience with SOA, JDeveloper, BPEL, BPA, and Workflow
• 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 Oracle Business Intelligence Enterprise Edition
• 3 years project management/senior experience including managing teams of analysts, delegating and evaluating work, and managing IT projects
• 12 years of accounting experience active CPA license
• Active Secret Clearance - obtained January 2012

PROFESSIONAL Experience

Confidential

Technical and Functional Sr. Oracle Consultant

• Senior Oracle consultant to evaluate the CEMLI/RICE objects present in the Oracle E-Business 11.5.10 system that is currently in production, including making recommendations for business process and technology improvements, finding discrepancies in the code and design, and documenting the technical and business processes for the CEMLI/RICE objects using Oracle Business Process Architect, Word, Excel, and Visio
• Evaluating the functional and technical level of effort for an Oracle ERP R12 upgrade/re-implementation as well as evaluating additional modules in R12 which can replace some of the CEMLI/RICE customizations
• Evaluating and recommending third-party software such as ConfigSnapshot to assist with the upgrade and provide additional information about the system for compliance with OMB Circular A-123 and other regulations
• Modules currently in production: GL, AP, AR, PO, FA, Advanced Supply Chain ASCP , Field Service, Demand Planning, 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

• Lead sessions to interview the clients to determine data and reporting requirements for data warehouses and dashboards
• Analyze data, build Oracle databases, tables and scripts for staging tables and data warehouse tables
• Perform data analysis using SQL and TOAD and write PL/SQL to perform calculations
• Develop and write design specifications, functional requirements and technical requirements
• Implement the data warehouses, build the OBIEE repository, and build the OBIEE dashboards including analyses in BI Answers and reports

Confidential

Business Analyst Lead Oracle Financials

• Part of a team to design, test and, implement Oracle Financials R12
• Participate in client interview sessions to determine business needs and process flows
• Document the client's business process flows in detail for GL, AR, AP, PO, Inv, OM, FA, Projects and HR using Visio

Confidential

IT Controls Analyst

• Part of a team to design, test, and document the IT controls for the Treasury's software applications
• Evaluate the systems to be tested and design test plans for the systems' controls to be tested
• Follow federal policies to determine the necessary tests for compliance

Confidential

Business Systems Analyst Cognos 8

Major Contributions:

• Interview business personnel to determine data and systems information to gather more data and reporting requirements from the MCCS financial and retail systems
• Evaluate the current set of Cognos reports to determine additional reporting and analytical functionality that could be provided by the system
• Analyzed data from the MCCS financial system to map the data from the process to the applicable database tables and fields diagrammed this mapping in Visio format

Confidential

Business Analyst Financials Systems

Major Contributions:

• Evaluated the client's current installation of Oracle Financials 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
• Designed and created reports and forms for SharePoint using MS Infopath and XML programming

Confidential

Sr. Oracle Financials 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 Financials 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
• Extensive use of MS Sharepoint to maintain documentation

Confidential

Oracle Financials Systems Analyst

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 for GL General Ledger , AR Accounts Receivable , AP Accounts Payable , CM Cash Management , and PO Purchasing
• Experience with multi-org and foreign currencies
• Began planning for upgrade to Rel. 12 of Oracle Financials and the Oracle Financials 11.5.10 Fixed Assets FA implementation

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

Major Contributions:

• Successfully supported the Oracle Financials version 11.5.3 and 11.5.9 modules GL, AP, PO, AR, CM, FA
• Project team lead to manage the conversion to 11.5.9
• Logged TARs/ SRs with Oracle Support, performed database maintenance and maintenance on Oracle Applications including managing concurrent managers, printers, revising Oracle report forms, 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
• Cited by finance manager as someone I can depend on to get the job done
• 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 Applications DBA

Major Contributions:

• Performed database tuning, user setup, and maintained Oracle Applications 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 development of
• supporting financial systems and to test new development Documented system enhancements
• and additional database development required
• Reduced the Oracle system downtime to less than 1

Confidential

Staff ERP Consultant

Major Contributions:

• 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
• Installed and configured the software including system security and roles, concurrent managers,
• printers and database tuning

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

Confidential

Senior Accountant

Major Contributions:

• Communicated with clients, IRS, and state agencies in writing and by phone to successfully resolve
• tax issues
• Compiled information for personal financial statements, budgets, and analytical reports using Lotus
• and Excel
• Prepared tax and business projections
• Cut the average compilation time by more than 50 by automating the compilations using
• Accountants' Trial Balance software

Confidential

Accountant

Major Contributions:

• Audited 25 statewide Area Agencies Aging to assess whether their policies, procedures, and
• accounting controls were in compliance with federal and state mandated policies for entities
• receiving government funds Collaborated with agency staff to remedy any discrepancies
• Devised and created a system in dBase III and Lotus to compile the revenue and expense
• information required to be submitted to federal and state entities for monthly, quarterly and annual
• reporting
• Designed, created and maintained a DbaseIII system to maintain information about the agency's
• fixed assets and provide reports that were previously unavailable

Confidential

Accountant

Major Contributions:

• Slashed the time to prepare trial balances by 50 by setting up trial balances on Lotus
• Successfully assumed management of entire audit projects and interfaced with client teams to
• achieve accurate results and meeting all audit deadlines

Confidential

Accountant

Major Contributions:

• Reduced accounting transaction errors to zero resulting in reduced reconciliation time for the
• reconciling accountant