SUMMARY:

• 19+ years of technical and systems/business analysis including Oracle EBS support and implementation, data warehouse projects, business/systems improvements, testing, software evaluation and enhancement, and project management
• 9+ years of implementation and technical and functional support on Oracle E - Business (EBS) Releases 10.7 through 11i and R12
• 5+ years of Oracle DBA experience on Oracle EBS systems and non-EBS Oracle databases (versions 7 through 11g and 12c)
• 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
• 2+ years project management/senior experience including managing teams of analysts, delegating and evaluating work, and managing IT projects
• Oracle Database12c Administrator Certified Professional (OCP)
• Oracle R12 Apps Certified DBA (OCP)
• Security + Certification
• Active Secret DoD Clearance

PROFESSIONAL EXPERIENCE:

Confidential, Stafford, VA

Technical and Functional Sr. Oracle Consultant

Responsibilities:

• Technical review of the technical and functional documentation written for the R12 upgrade (Oracle EBS, SOA, OIM/OAM, and OBIEE) and documentation of the customizations made for the EBS R12
• Technical analysis of level of effort and requirements for upgrading the 11g databases to 12c
• Built out demo system of Oracle EBS R12, Oracle Enterprise Manager (OEM) 13c, and the Oracle Application Management Pack (AMP) to demonstrate the capabilities of the OEM and AMP

Confidential, Stafford, VA

Technical and Functional Sr. Oracle Consultant

Responsibilities:

• Technical review of the technical and functional documentation written for the R12 upgrade (Oracle EBS, SOA, OIM/OAM, and OBIEE) and documentation of the customizations made for the EBS R12
• Technical analysis of level of effort and requirements for upgrading the 11g databases to 12c
• Performed data migration from the GCSS-Harvest CM system database in an Oracle 11g database
• Used Oracle Data Pump to extract the relevant data from the Oracle 11g database
• LIS data migration project included standing up a complete replica of the clients’ VMs including rebuilding their Linux VMs to improve performance for the data extraction; data extractions were then uploaded to the Serena Dimensions system
• Linux system administration including installation and configuration on Red Hat Linux 6 (RHEL 6) and Centos 7
• Oracle Virtual Machine (VM) installation, configuration, and re-building VMDK storage

Confidential, Fort Belvoir, VA

Oracle DBA

Responsibilities:

• Reviewed and updated STIGs to reflect changes in the databases
• Monitored database and made changes as needed for Oracle 11g and 12c databases

Confidential, Alexandria, VA

Sr. BI/Data Analyst

Responsibilities:

• Reviewed and updated technical design documents for this BI project which extracts data from various sources including Oracle R12
• Monitoring the schedule of jobs in Ab Initio software and documenting the job schedule to pinpoint any conflicts and synchronize the jobs in production and testing environments
• Review Ab Initio job run times to highlight possible resource issues as well as justify increased processing power for environments
• Use of Oracle SQL Developer and Oracle Data Modeler to maintain the data model
• Wrote Oracle SQL queries to verify the data being extracted, for data analysis, and to troubleshoot any issues with the data warehouse data
• Used Oracle12c database for all databases used on Windows and Solaris

Confidential, Charleston, SC

Oracle Apps DBA

Responsibilities:

• Rapid cloning and restored clones of the Oracle EBS 11.5.10 and R12 on RHEL 5 and 6
• Applied patches and security updates (PSUs) to the Oracle EBS 11.5.10 and R12 systems and 10g, 11g, and 12c databases
• Upgraded the 10g database with Oracle EBS 11i to 11g and then upgraded the 11g to 12c database
• Part of a R12.2.4 upgrade team upgrading a cloned EBS 11i instance
• Performance monitoring and tuning on OEM 10g and OEM 12c; set up, monitor, and troubleshoot OEM jobs
• 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
• Experience troubleshooting issues with the Oracle EBS 11i, Oracle EBS R12.2.4, and WebLogic
• Used RMAN to take backups of the 10g and 11g databases
• Experience with Remedy help ticket system and Oracle Support

Confidential, Stafford, VA

Technical and Functional Sr. Oracle Consultant

Responsibilities:

• 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, Kearneysville, WV

Systems Analyst

Responsibilities:

• Lead Oracle consultant on a team to evaluate and make recommendations for optimizing the core accounting systems (Oracle EBS 11.5.10) for the Confidential ; 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, Chantilly, VA

Sr. Data Warehouse Analyst

Responsibilities:

• 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, Reston, VA

Business Analyst Lead

Responsibilities:

• 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
• Part of team to write the test scripts and test cases needed

Confidential, Washington, DC

IT Controls Analyst

Responsibilities:

• 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, Washington, DC

Business Analyst - Financials Systems

Responsibilities:

• 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, Richmond, VA

Sr. Oracle Systems Design Analyst

Responsibilities:

• 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, Norcross, GA

Oracle Financials (EBS) Systems Analyst/PL/SQL

Responsibilities:

• 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
• Tested any changes before implementation

Confidential, Atlanta, GA

Supervisor/Manager

Responsibilities:

• 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, Atlanta, GA

Financial Systems Analyst/Project Manager

Responsibilities:

• 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, Richmond, VA

Sarbanes-Oxley (SOX) IT Auditor

Responsibilities:

• 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