Megan Whyman

Summary

Eighteen years of success with Oracle Database Administration, Full ERP Implementation project cycles of Oracle and Mapics, Application Interface development (pl/sql and php), Oracle EBS System Administration, BI development, and Training development and deployment.

Skills

• Oracle Database Administration • SQL PL/SQL Expert

• Oracle EBS System Administration • BI Development

• ERP Implementation experience • Training Development and Deployment

• Application Interface Development • Oracle RMAN expert

Experience

Unified Brands October 2013-present

Application Developer/ Oracle EBS System Administrator

Core team member for Oracle EBS implementation project full ERP suite implementation including financials (GL, AP, AR, Cash, Cost, Tax), manufacturing, customer service, engineering, inventory, and procurement

Oracle EBS System Administration- Security management, concurrent program development and administration

XML Publisher report development

Interface development in pl/sql and php for Global Warranty, Bravo, JP Morgan Supply Chain Finance, and Khalix

EIS (Enterprise Integration Solutions) Administration, report development, and training development and deployment

Oracle EBS Finance support lead

Technical Support- Incident management with users and vendors (Oracle, EIS, Hitachi)

Data extracting, cleansing and uploading from Mapics ERP to Oracle EBS

Loftware October 2012- October 2013

Database Engineer/ Developer

Oracle 11g Database Administration- Installation, configuration, upgrades, patch applications, security management

Developed automated Oracle install and database creation process for software install/ implementation

Development in SQL, PL/SQL and Java

Developed Disaster Recovery Fail Over procedure as an RMAN scripted/ automated process

Designed data models for functionality implementation and scalability

BI Report development

Developed and Delivered training on Oracle Database Administration, disaster recovery, and performance tuning

Unified Brands May 2004- October 2012

Oracle Database Administrator/ Mapics Point.Man ERP Application Administrator

Oracle 10g Database Administration- Installation, configuration, upgrades, security management on Windows and IBM AIX platforms

Administered Oracle 10g production and test databases on Windows and IBM AIX platforms

Developed scripts, queries, and reports in SQL and PL/SQL for data extraction and manipulation

Developed integration procedures and processes for integrating acquired companies ERP data structures and history into the Mapics Point.Man ERP environment

Configured, scripted and managed database backups using RMAN including developing and testing restore procedures

Created new databases, users, roles, tables, views, triggers, packages, procedures, functions, materialized views, directories

Maintained test database environments using rman replicate and datapump export/import

Monitored performance and tuned environments using AWR and SQL

Developed scripts for data uploads and scrubbing using SQL*Loader

Installed, configured, and managed Oracle Client environments on all Windows environments including Windows 7 with ODBC install and configuration

Installed and configured Oracle 11i in testing environments on Windows

Provided database interface assistance for integration with Cognos, Vertex, Optio, Business Intelligence, Crystal Reports, Warranty Central, EM-Web, and various web applications

Created and managed Oracle 10g databases with ASM diskgroups

170 Systems May 2003-May 2004

Applications Developer/ Consultant

Developed training courses and manuals and provided training instruction for MarkView with Oracle Applications Work flow

Developed MarkView to Oracle Applications Workflow interfaces in PL/SQL

Provided customer site implementation technical support and development consulting

Infor January 1999-May 2003

Systems Services Consultant

Installed and configured Oracle Database Software on Windows – versions 7.3.3, 8.1, 8i, 10g

Created oracle databases and set up for production, testing, implementation

Replicated and refreshed databases using export/ import and scripting

Installed and configured Oracle Client software on Interface servers, local PC’s, Terminal Servers

Provided technical support for Oracle database issues, data corruption, disaster recovery

Developed and delivered training on Oracle Database Administration for Point.Man ERP, Business Intelligence Query and Report Development, Point.Man Data Modeling, and SQL scripting

Education and Training

University of Michigan- Bachelor of Arts: Economics Graduation May 1991

Oracle Training- R12 Oracle Applications System Administrator Fundamentals, XML Publisher, Oracle 10g Database Administration, Oracle 8i Database Administration, Oracle 7 Database Administration

Additional Training- JAVA Development, SQL Server, Citrix, Windows, IBM AIX, Business Intelligence (Crystal Reports, BI Query, EIS), C++, COBOL

Contact this candidate