SUMMARY:

• Over 20 years experience working in Information Technology, spanning mainframe, midrange, and microcomputer environments. A seasoned Oracle DBA, Database Developer and Data Architect with over 15 years experience in Business Analysis and Enterprise Systems Implementation; have actively served on multiple successful Oracle EBS Projects. Extensive experience in full life cycle development of applications designed around relational database systems, including special experience in Oracle Managed Cloud Services (EBS) Life Cycle.
• Experienced in large Oracle R12/11i Applications implementations/upgrades and administered Oracle technology products in both production & development environments. Recognized as a hands - on and pro-active troubleshooter, who can rapidly identify and resolve database and application scalability and tuning issues; proficient in Explain Plan, STATSPACK, SQL TRACE, and TKPROF. Expertise that is precious in the Oracle On-demand implementation Production Assessment phase to ensure and prove that all custom codes CEMLI and database configurations meet Oracles performance requirements.
• Demonstrated knowledge of Enterprise Information Management approaches, including data migration and integration strategies.
• Extensive experience and expertise in Oracle Application Express (APEX) to include Managing and Participating in large International development projects, have developed multiple web applications with APEX, Special expertise in Extending Oracle E-Business Suite using APEX. Provided APEX and coaching, migrated Oracle Forms applications to APEX, Application Express audit, Best Practices, Performance Tuning, and Security Review.
• Possess exceptional analytical and problem solving skills along with a solid telecommunications background, excellent personal communications skills, including written and oral presentations, a proven ability to bridge the gap between technical and non-technical people, an outstanding methodologist and an excellent mentor and trainer.

TECHNICAL SKILLS:

Job category experience: Developer, Programmer/Analyst, Software Engineer, Business Analyst, Data Modeler, Database Architect, DBA, Project Manager

O/S: UNIX, LINUX, SOLARIS, AIX, HP-UX MS WINDOWS SERVER

DBMS/APP Servers: ORACLE 11g/10g/9i/9iRAC/8i/8/7.3, MS SQL Server, DB2, INFORMIX, Weblogic, Oracle iAS, MS IIS, JBOSS

Database Tools: Oracle Enterprise Manager (OEM), Toad, Spotlight, SQL Developer, Warehouse Builder, Informatica, SQL*PLUS, SQL*Loader, AD Utilities, Oracle Streams, Data Guard

Data Modeling Tools: Oracle Designer, SQL Developer, ER/Studio, Erwin Data Modeler, Visual Paradigm

Applications: Oracle E-Business Suite 11i/R12, Harper & Shuman CFMS, Design Data Systems’ SQL*Time, PEOPLESOFT, SAP, INDUS EMPAC, Maximo

Application Modules: AP, AR, GL, FA, OM, INV, PUR, WIP, BOM, WMS, SCM, MFG, SOS, RMS, HRMS

Development Tools: ORACLE Designer, JDeveloper, ADF, Oracle Forms/Reports 6i, 9i, 10g, 11g, Oracle Workflow Builder, Applications Express (APEX), BI Publisher

Languages/Platform: PL/SQL, SQL, PERL, C, JAVA, J2EE, OBIEE, OAF, JavaScript, JQuery, AJAX, XML, SOA, VB.NET, ASP/ASP.NET, COBOL

PROFESSIONAL EXPERIENCE:

Confidential, Austin, Texas

Senior Oracle DBA/Developer

Tools: and Methodology: PL/SQL, Oracle Application Express, Microsoft Project, ER/Studio, PL/SQL Developer Platform: Linux, Oracle 11g RAC, Oracle 12c, Data guard, Golden Gate

Responsibilities:

• Designed and Built database objects including Stored PLSQL Procedures, Packages, Functions, Database Triggers to closely support client-side .NET and Apple mobile development teams.
• As Data Architect, translated complex business requirements into tangible data requirements and associated conceptual and logical data models.
• Provided Oracle Database Admin/production support to internal and external customers
• Performed In-depth analysis on Oracle 12c Database Architecture, Multitenant & Pluggable Databases. as part of an 11gR1 production to 12c RAC multi-node/multi-site migration initiative.
• Responsible for developing the migration strategy for 11gR1 Grid Cluster ware RAC database to 4 node 12c RAC with Data Guard and Golden Gate.
• As Data Architect, was responsible for translating complex business requirements into tangible data requirements and associated conceptual and logical data models.

Confidential, Alpharetta, Georgia

Senior Technical Consultant

Tools: and Methodology: PL/SQL, Oracle Forms, JDeveloper, ADF, Oracle Application Express, Microsoft Project, ER/Studio, PL/SQL Developer Platform: Linux, Oracle 11g RAC, Oracle 12c, Oracle EBS R12

Responsibilities:

• Responsible for Lifecycle Management of MCG Software products.
• Provided Oracle Database Admin support to internal and external customers
• As Data Architect, translated complex business requirements into tangible data requirements and associated conceptual and logical data models.
• Developed physical Data Models, and built the database objects (tables, views, packages, procedures, functions and triggers) for the WORKMINDER system.
• Performed full Life Cycle Development of an Engineering Work Management System (WORKMINDER) using Oracle Application Express (APEX)
• Installed Fusion Middleware and Migrated the MCG Plant Access system from Oracle Forms 6i to Forms 11g
• Performed end to end installation and configuration for an R12 implementation. Served as the lead technical resource for the Linux based back-end. Built Stored PLSQL Procedures, Packages, Functions, Database Triggers, and interfaces between WORKMINDER, Primavera P6, and Oracle EBS Release12

Confidential

Technical Lead/Data Analyst

Tools: and Methodology: PL/SQL, Oracle Forms, Oracle Application Express, Microsoft Project, ER/Studio, MS SQL Server Platform: Linux, Oracle 11g RAC, Oracle EBS R12

Responsibilities:

• Developed a system to manage and monitor the statewide Biometrics/Document data capture of all state employees and pensioners
• Worked with the different ministries to gather and define key report requirements.
• Planned, scheduled, and managed the activities of the development team including assigning and quality checking CEMLI/RICEW items.
• Designed and built database objects (tables, views, packages, procedures, functions and triggers) for the statewide employee biometrics and document capture project.
• Consolidated data from biometric capture workstations into a central Oracle 11g database
• Designed and Built the Statewide Employee verification system featuring Dashboards with reports, charts and gauges with drill down capabilities. Also built a portal for Centralized self-service reporting using Oracle Application Express (APEX)
• Designed and built PL/SQL Packages for interfaces between the Employee Verification system and Oracle HRMS using the HRMS APIs.
• Designed and Built interfaces in and out of the E-Business Suite using open interfaces, PL/SQL and APIs
• Performed Oracle Apps DBA tasks including patching, backup, recovery, cloning, and performance tuning

Confidential

Technical Lead/ Architect

Tools: and Methodology: PL/SQL, Oracle Forms/Reports, Oracle Application Express, Microsoft Project, ER/Studio Platform: Linux, Oracle 11g RAC, Oracle EBS R12

Responsibilities:

• Implemented a GEO ERP solution for the Federal Ministry of Works which included integration of an enterprise level geospatial solution from Israelis based Sivan Design with Oracle EBS R12..
• Worked as an Oracle EBS R12 DBA/Lead Developer.
• Led the EBS implementation technical team including DBAs and Developers.
• Performed Oracle EBS database administration including installing Oracle EBS R12/Oracle 11g RAC with Data Guard on Linux, patching, backup, recovery, capacity planning, and performance tuning
• Planned, scheduled, and managed the activities of the development team including assigning and quality checking CEMLI/RICEW items.
• Gathered technical requirements and developed technical specifications for reports, data conversions, and integrations with Oracle E-Business Suite
• Provided hands-on development of new database objects, reports, and workflows, as well as development of interfaces in and out of the E-Business Suite using open interfaces, PL/SQL and APIs
• Supported/contributed to unit, integration, and user acceptance testing.
• Gathered and user documentation requirements.
• Made sure proper Oracle AIM documentation was created for each deliverable and phase of the implementation project.
• Logged support cases as necessary and worked with Oracle support and other vendors to resolve issues

Confidential

BPR Consultant/Lead EBS Developer

Tools: and Methodology: Microsoft Project, VISIO, Oracle Application Express (APEX), CASEWISE Corporate Modeler Platform: Linux, Oracle 11g, Oracle EBS R12

Responsibilities:

• Managed the Enterprise-wide BPR initiative for client
• Conducted workshops with the BPR team to identify and document/model current processes and worked with in-house analysts and subject matter experts in joint design sessions to identify improvement/reengineering opportunities
• Prepared functional system requirements based on the process models for use as a benchmarking standard against leading enterprise software systems. Evaluated Oracle EBS, SAP, MS Dynamics NAV, Sage, and other industry specific packages
• Developed the transition plan, conducted, prepared and published RFI/RFP Documents, and worked with the transition team to evaluate vendor products
• Supervised and provided technical architect expertise to the Oracle EBS implementation vendor
• Validated technical solutions to ensure they are in keeping with Oracle best-practices and provide a scalable architecture to meet current and future business requirements
• Facilitated communication among project stakeholders to ensure buy-in and an understanding of project objectives, scope changes, and requirements.
• Gathered technical requirements and developed technical specifications for reports, integrations, data conversions, and integrations with Oracle E-Business Suite
• Provided hands-on development of application extensions using Oracle Forms, Reports, and APEX, as well as development of interfaces in and out of the E-Business Suite in PL/SQL
• Worked with the Engineering project management group to define and implement effective program management as a part of a comprehensive solution to ensure successful projects.

Confidential, Phoenix, Arizona

Senior Technical Architect

Tools: and Methodology: Primavera P6, Microsoft Project, PL/SQL, J2EE, Oracle Application Express (APEX), Oracle9i Forms and Reports Developer, CASEWISE Corporate Modeler Platform: Linux, Primavera P6, Oracle 10g

Responsibilities:

• Provided support for the Director of Site Programs to manage Information Technology (IT) related process improvement projects associated with the PVNGS Integrated Improvement Plan
• Researched emerging and enabling technologies and developed, documented, and presented technical solutions addressing specific business needs consistent with PVNGS Long Range Plan
• Served as the enterprise data architectural owner for application and platform development reviews; led strategic technology initiatives, project architecture reviews, and systems design
• Managed Site-wide Implementation of Primavera P6 in an Oracle 10g environment
• Worked with subject matter experts to define key requirements.
• Designed interfaces between Primavera P6 and the Oracle based Work Management System (WMS) using PL/SQL and Java
• Designed and Developed the PVNGS Procedure Workflow system to standardize and streamline the site’s procedure change process, and Engineering Work Management/Change Management system in APEX.

Confidential, Phoenix, Arizona

Implementation Technical Team Lead

Tools: and Methodology: Oracle Forms/Reports, Discoverer, XML Publisher, PL/SQL, AIM/EBSO Platform: Oracle On Demand Linux, Oracle 10g, Oracle EBS 11i

Responsibilities:

• Led the technical team (Oracle Database Administrators (DBA), System Administrators, and Oracle Developers) in the implementation of Oracle e-business suite on-demand (EBSO).
• Was responsible for creating and executing a data migration plan for the conversion of disparate legacy systems to a new Oracle enterprise business system.
• Created EBSO CEMLI compliant MD.070 technical design documents from functional design documents.
• Designed and Developed custom modules in Oracle Forms, Reports and PL/SQL
• Was responsible for producing, publishing, and enforcing database development standards, and data best practices.
• Designed and built data conversion programs for AP, AR, GL, FA, OM, INV, PUR, WIP, BOM and HRMS
• Created and executed a data management roadmap focusing on database performance, data retention, and data analytics.
• Provided Applications technical support through User Acceptance Test (UAT) and GO-LIVE to complement Oracle ON-DEMAND (OOD) DBA support
• Developed instance and CEMLI (Configuration, Extensions, Modifications, Localizations, and Integrations) plans for the project. Scheduled and managed Database refreshes for all instances.
• Designed and developed multiple EBS/Legacy Systems interfaces via open interfaces, PL/SQL and APIs
• Conducted CEMLI performance tests and prepared all documents required for Oracle On-Demand Production Assessment

Confidential

Technical Consultant

Tools: and Methodology: Microsoft Project, Oracle Collaboration Suite, PL/SQL, Oracle Application Express (APEX) Platform: Oracle On Demand Linux, Oracle 10g, Oracle EBS 11i

Responsibilities:

• Led a team of technical consultants in the migration of e-Room databases to Oracle Collaboration Suite using Oracle Application Express (APEX).
• Worked with project members and users in USA, China, Singapore and Germany to gather requirements and design solutions.
• Designed and built solutions using Oracle APEX and Oracle Collaboration Suites with single-sign-on (SSO) authentication.
• Designed and implemented a multi-terabyte data migration plan for Agilent/Verigy migration
• Served as Verigy’s single point of contact on the project.
• Managed interfaces/interactions with IT Department and functional groups in USA, China, Singapore and Germany regarding Progress Report, performance, initiatives and project issues.
• Supported conversion and migration of business modules from Agilent to Verigy.
• Conducted Oracle Apex for in-house developers

Confidential

Technical Team Lead

Tools: and Methodology: Microsoft Project, PL/SQL, Oracle Developer, AIM/EBSO Platform: Oracle On Demand Linux, Oracle 10g, Oracle EBS 11i

Responsibilities:

• Led a team of technical consultants in the implementation of Oracle e-business suite on-demand (EBSO).
• Completed the courseware and earned the EBSO Implementation Champion to support the implementation process.
• Was responsible for all Data Conversion, Integrations, and Modifications.
• Worked with functional team to Setup WMS Rules and strategies for Picking and Put away and produce MD.050 functional design documents for the required extension to support Device Integration.
• Designed and built workflows for Project Approval, Order Management, and Quote Pricing.
• Conducted functional design walkthrough with functional designers and created EBSO CEMLI compliant MD.070 technical design documents from MD.050 functional design documents.
• Designed and built data conversion programs for AP, AR, INV and BOM.
• Led the functional and technical team to gather business requirements, designed and built extensions for managing Oracle Trading Community Architecture (TCA) in context of Service Contracts and OKS billing
• Designed and built conversion and interface programs for legacy Customer and Prospects systems to Oracle data hub (Trading community Architecture TCA) using the TCA APIs.
• Designed and built conversion and interface programs for legacy HR/Payroll systems to Oracle HRMS using the HRMS APIs.
• Work with Functional team to ensure customer data formats support address validation and tax requirements
• Recommend best practices for managing HZ customer schema, Customer Master Data, customer related areas of Receivables/Payables, Data Quality Management tools, and the Oracle Customers Online module