SUMMARY

• Seasoned Solutions & Data Architect with a track record of successful execution resulting from thorough planning, solid management, & high quality assurance.
• Specialties include - Oracle eBusiness Suite, Master Data Management & other financial / back office applications; Sarbanes-Oxley (SOX) compliance;
• Oracle Enterprise Governance, Risk & Compliance Controls Suite; Migration & Environment Management; Implementations, Integrations & Upgrades; Testing, Configuration,
• System Administration & Security; Staff Mentoring & Development

TECHNICAL SKILLS

• Business Analyst
• Business Requirements, Use Cases, Functional Requirements
• Systems Analyst
• System Requirements, Test Plan, Test Cases, Test Data
• SDLC
• AIM Methodology, Waterfall, RAD, Agile
• Data Architecture/Modeling
• TOAD Data Modeler, ERwin, Oracle Designer, System Architect, Embarcadero
• Process Automation/Workflow
• Oracle Workflow
• Oracle ERP
• GL, AR, AP, iExp, CE, FA, PA, PN, PO, iProc, Self Service, HR, OTL, EIB, INV, OM, PIM, BOM, iSupplier, AME, TM, UPK, WMS
• Oracle Hyperion
• Hyperion Data Relationship Management
• Hyperion Financial Management
• Hyperion Performance Management
• Hyperion Enterprise Planning & Budgeting
• System Administration
• System Admin, MOAC, RBAC, GRC, Audit Support, UMX
• Configuration & Environment Management
• Responsible for Data & Configuration Management in Controlled (SOX InScope) Environments, Managed Refresh Schedule, Team Lead for Resolution of Test Data Issues
• Documentation & Test Tools
• Doors, Quality Center, Turnkey, Test Rail, Jira
• Reporting - BI (Business Intelligence)
• Cognos, Oracle Discoverer, OBIEE, BAW, Noetix
• Other Interests / Experience
• Oracle GRC, Data Architecture, Data Governance

PROFESSIONAL EXPERIENCE

Confidential Clarksville, MD

Oracle Apps Financials Functional Consultant

Responsibilities:

• Working on the OSI Digital US team for a multi-national client reviewed current as-is process flows & procedures to identify future to-be process flows including requirements & gap analysis.
• Proposed significant new functions including Multi-Org structure, on-demand Margin Calculation & Reporting,
• Costing Methods, & Chart of Accounts modifications. Documented to-be design.
• Reviewed design changes & demonstrated new functionality for end user decision makers.

Confidential Corp. Carlsbad, CA

Senior Business Systems Analyst

Responsibilities:

• Implemented Oracle eBusiness Suite R12 for a $500 million a year, national electrical construction company.
• Participated in data conversion activities associated with migrating legacy system data to the new EBS system. Primary support for GL, AP, AR, FA, PA, PO, ancillary support for HR & PAY.
• Designed & implemented 2 new Operating Units for joint venture operations.
• Designed & implemented iExpense prototype. Participated in implementation of Transcepta front-end for AP, Concur for expense reporting, and Salesforce for support services division.
• Supported Accounting & Finance teams for month- & year-end close activities, budgets, audits, & transaction processing issues. Partnered with Accounting & Finance to guide regional staff through accounting & reporting issues.
• Developed SQL queries for ad hoc reporting, data mining, trouble-shooting, & reconciliation purposes.

Confidential, San Diego CA

Oracle Applications Consultant

Responsibilities:

• Participated on development projects for multi-national, multi-currency developer of life sciences and material sciences applications.
• Responsibilities included planning, testing, & production cutover of new Operating Unit implementation as well as implementation of Bill of Materials module & integration with legacy applications including Salesforce.com.

Confidential, San Diego CA

Senior ERP Analyst

Responsibilities:

• Managed various aspects of an Oracle EBS R12 implementation for multi-national, multi-currency client. Responsibilities included planning, design, configuration, testing, build plan development & management, environment management, system administration, security, training,
• Discoverer report development & administration, & production support.
• Developed overall security strategy, security rules, created over 300 custom responsibilities using Multi-Org Access Controls (MOAC), forms personalizations, custom menus, and exclusions. Responsible for change control & quality assurance in controlled environments.

Confidential, San Diego CA

IT Quality Assurance Lead,

Responsibilities:

• Managed overall test planning & execution across Oracle EBS, Rapid Response (including Demantra), & Business Intelligence teams for major program initiative.
• Responsible for IT & Business test scope, entry & exit criteria, environment build plan & management, data staging & coordination, test tools, metric & progress reporting, defect resolution. Managed team of cross functional QA Coordinators.

Confidential, San Diego CA

Principal Architect, EBS & Financial Applications

Responsibilities:

• Designed & Implemented custom Master Data Management application for Enterprise Physical Addresses
• Implemented Oracle Enterprise Governance, Risk, & Compliance Controls Suite (GRC) (CCG) (AACG)
• Implemented Oracle Inventory Management (IM)
• Implemented Oracle Order Management (OM)
• Implemented Oracle Product Information Management (PIM) - Item Master Data
• Implemented Hyperion Enterprise Planning & Budgeting Suite, Performance Management Applications, & Data Relationship Management (DRM) for Enterprise Locations
• Implemented Oracle Time & Labor for Project Accounting
• Implemented Oracle iExpense
• Implemented & Retired Operating Units within the Set of Books for various Joint Venture Operations
• Implemented Oracle Business Intelligence Enterprise Edition (OBIEE)
• Implemented Oracle Business Analytics Warehouse (BAW)
• Migrated client base to Web Discoverer
• Migrated client base to Web Oracle Data Integrator (ODI)
• Developed & Maintained library of Use & Test cases for reusability
• Developed & Maintained User Documentation in User Productivity Kit (UPK)

Senior Manager,

Confidential

Responsibilities:

• Implemented Oracle Time & Labor
• Upgraded to Oracle EBS R11.5.2
• Implemented Oracle Enterprise Install Base (EIB) with Fulcrum CATS application
• Implemented Oracle Human Resources Management System
• Performed first year Sarbanes-Oxley 404 Remediation & Established Standards
• Designed & implemented custom SOD functions, menus, & responsibilities

Confidential, San Diego CA

Consultant - Oracle eBusiness Suite Operations

Responsibilities:

• Solution Architect for Oracle EBS re-implementation
• Managed Enterprise Close Process
• Maintained Application Configurations
• Authored custom SQL queries & views
• Authored custom Discoverer reports & administered Discoverer Instance, Security & Content
• Performed first year Sarbanes-Oxley 404 Remediation

Confidential Financial San Diego CA

Senior Business Intelligence Analyst

Responsibilities:

• Identified Master Data
• Externalized Business Rules
• Participated in cross-functional design for meta data publication via a web service

FICO San Diego CA

Senior Oracle Applications Support Analyst

Responsibilities:

• Responsible for validating that the existing design would meet the Business Requirements of the acquired Company
• Developed Functional & System Requirements
• Functional Design, Conversions including Conversion Template Development, Testing, Training, & Migration to EBS 11i
• Production Support through 1st quarter close

Confidential, San Diego CA

Senior Business Intelligence Analyst

Responsibilities:

• Designed, Developed, & Implemented custom Finance Data Mart & Operational Data Store to support executive & management reporting needs
• Designed, Developed, & Supported custom Budget/Forecast & Capital Budgeting applications
• Maintained, Enhanced, & Extended Legacy Accounting applications using standard ETL tools
• Implemented Management Planning & Control (Comshare) software for 75 Executive & Senior Management users

Confidential CA

Senior Manager, Corporate Systems

Responsibilities:

• Oracle Financials & Manufacturing
• Oracle Financial Analyzer (OFA)
• Finance Data Warehouse
• PeopleSoft HR (upgrade & custom interface to external payroll system)
• Mail Order & Catalog System (MACS)
• Direct Marketing Database (Informatica)
• Managed Corporate Y2K Remediation Team

Senior Manager, Oracle Applications Systems

Confidential

Responsibilities:

• Managed upgrade to R10.7
• Implemented Kanji instance in Japan & integrated with US operations in 2 sets of books with 2 functional currencies
• Implemented Oracle Financial Analyzer (OFA)