Senior Oracle Apex Solutions Architect/consultant Resume
SUMMARY:
- Over 18 years of Hands on Oracle Technology Experience in the U.S with progressive career track and technical consulting experience in Designing, Developing, Architecting Enterprise Scale solutions using Oracle Database 19c, 12c, 11g, Oracle Development Tools & Strong in Oracle Application Express (Apex)
- Over 10+ years of Solution Design, Hands on Development and Leadership roles in writing Apex applications on e - Business Suite and Custom Solutions - Application Express (Apex) - 19.2.x, 18.x, 5.x, 4.x, 3.x
- Solutions Design, Technical Leadership Experience involving Database Architecture, Design, Development, Digital Transformation of Enterprises, and Systems Integrations.
- Over 10 years of hands on Technical Leadership and Consulting Roles involving Oracle E-Business Suite R12.x Reporting, Integrations, Customizations and Extensions.
- Relentless focus, leadership skills, ability to sort out & work around challenges with customer success goal throughout the entire career. Completed every project undertaken.
- Strong Work Ethics to complete projects with outmost commitment, customer success focused, agile approach to delivery and excellent team player.
- Over 18 years of progressive software and applications development experience in the U.S. as a Senior Technology Implementation Consultant, Senior Oracle Applications Developer, Project work experience on Agile Scrum and Waterfall Methodologies, Complete SDLC Development Cycles; Enterprise Applications Integrations.
- Over 10 years of Combined Experience developing Oracle Applications Express Apex 19.2.x, 19.1.x, 18.1.3, Apex 5.2.x, 4.2.x, Apex 3.x - Solid hands on development expertise spanning full project lifecycles in Agile Development Environments.
- Oracle Certified Professional in Apex.
- Customized and developed end to end solutions involving entire database architecture, database modeling, and design. Extensive PL/SQL Coding
- Over 15 years in Database Architect Roles , Data Modeling , Conceptual, Logical and Physical Design, Oracle Applications Programming, Development Tools, Developing the supporting framework for applications. Industry wide Experience in both OLTP and OLAP applications development.
- Oracle Forms, Oracle Reports, OA Framework, Workflow, Apex, HTML5, CSS3, JavaScript, XML/JSON RESTful Web Services, ORDS, jQuery. On-Prem and Public Cloud Environments.
- Over 12 years of Technical Development Experience and exposure to Oracle e-Business Suite R12.x - OM, PO, INV, BOM, GL, AP, AR, PA, FND
SKILLS SUMMARY:
- Oracle Database 19c, Oracle 18c, Oracle 12c, Oracle 11gR2 EE, Oracle 11gXE
- Expertise in Oracle Application Express Apex 19.2.x, 18.1.3, Apex 5.2.3, Apex 4.2 HTML5, CSS3, JavaScript, jQuery, JSON, Shell Scripting, BI Publisher Oracle REST Data Services (ORDS) Web Services integrations.
- Expertise level and Advanced skills in PL/SQL, SQL, SQL Developer SQL Data Modeler, TOAD, SQL Loader
- Oracle OLAP, Data Warehousing Architecture Star Snowflake Schema Design
- Oracle Data Integrator ODIEE 12c, 11g, OBIEE 12c
- Architected Master Data Management (MDM) Solutions, ETL and ELT frameworks.
- Oracle e-Business Suite R12.1.x - Manufacturing, Financials Oracle Projects, Supply Chain Management (SCM) Customer Relationship Management (CRM) Human Capital Management (HCM)
- RICEW Components - Reporting, Integrations, Data Conversions, Customizations, Extensions
- Technical Experience and Functional Exposure to SCM, O M, PO, PA, GL, AR, AP, HRMS, HCM, CRM, FND, AOL
- Agile Scrum development methodologies
- JIRA, GIT, AccuRev, SVN, VSS, Collaboration Tools
WORK EXPERIENCE:
Senior Oracle Apex Solutions Architect/Consultant
Confidential, Walnut Creek, CA
Responsibilities:
- Hands on Solution Design, Development, Documentation, Implementation of over 100 pages apex applications to support Credit Risk, Federal Reporting and Financial reporting application - CRF and CLF 2052a federal FRB reporting solutions.
- Enhanced Application features to leveraged customizations to meet corporate standards - Universal Theme, Apex new IG/IR features
- ORDS integration of data access to eBusiness suite for Axiom Financial reporting upgrade project.
- Extensive hands on development work using Oracle Apex 19.1, ORDS, PL/SQL, JSON, Shell scripts automation with Informatica AutoSys, RESTful Web Services
- Modern Responsive User interfaces and Corporate standardization of Apex solutions.
- Integration with Axiom SL Financial Reporting and successful project completion of 2052a regulatory reporting features.
Technologies: Oracle 12c, Oracle Apex 19.1.x, Extensive PL/SQL, SQL, ORDS, JSON, JavaScript, jQuery and HTML5/CSS3 within Oracle Apex. Shell Scripting, Automations for job scheduling and data integration. Axiom SL Financial Reporting.
Senior Oracle Apex Solutions Architect/Consultant
Confidential, Miami, FL
Responsibilities:
- Hands on Solution Design, Development, Documentation, Implementation of over 500 pages apex applications that provide user access management custom interfaces.
- Enhanced Application features to leveraged customizations to meet corporate standards - Universal Theme, Apex new IG/IR features
- ORDS integration of data access to eBusiness suite for third party vendor management systems
- Extensive hands on development work using Oracle Apex 19.1, 18.x, ORDS, PL/SQL, JSON RESTful Web Services, Modern Responsive User interfaces and Corporate standardization of Apex solutions.
Technologies: Oracle 12C, Oracle Apex 19.1.x, 18.x, Extensive PL/SQL, SQL, ORDS, JSON, JavaScript, jQuery and HTML5/CSS3 within Oracle Apex.
Senior Oracle Apex Solutions Architect
Confidential, Washington, DC
Responsibilities:
- Senior Technical Oracle Apex Consultant in migration of Apex 5.1 to Apex 18.x Universal Theme, Interactive Grids - Master/Detail/Detail type of Apex pages redesigned.
- Enhanced Application features to leverage Universal Theme, Apex new IG/IR features
- Extensive hands on development work using Oracle Apex 19.1.x, 18.x, 5.1.3, PL/SQL, JSON, Restful Web Services and integration with Oracle Portal/SOA layer.
Technologies: Oracle 12c, Apex 18.x, PL/SQL, SQL, JSON, JavaScript, jQuery, HTML/CSS, Oracle Rest Data Services (ORDS), Oracle Portal Integration
Senior Oracle Apex Developer/Consultant
Confidential, Walnut Creek, CA
Responsibilities:
- Worked as a Senior Technical Oracle Apex Consultant in improving application functionality, User Interfaces Enhancements, Apex Upgrade to Universal Theme, Menu Navigations and Application UI enhancements.
- Migrated Four MS Access Applications to Oracle Apex. Lead role for data migration, new Apex UI interfaces.
- New Interface design for Federal File JSON/XML Formats files generation, file interchanges, reporting, New Screens UIX development.
- Extensive hands on development work using Oracle Apex 5.1.3, Apex 4.2.6, PL/SQL, XML.
- Enhanced, Upgraded and Refactored 400 pages application from Apex 4.2.6 to Apex 5.2.x, Apex 18.1.x - Universal Theme upgrade, JS Code migrate to Dynamic Actions, Code Refactored.
Technologies: Oracle 12cR2, Oracle Apex 18.x UT, 5.2.x, Extensive PL/SQL, SQL, JSON/XML, JavaScript, jQuery and HTML5/CSS3 within Oracle Apex.
Senior Oracle Apex Solutions Consultant
Confidential, Livermore, CA
Responsibilities:
- Provided Senior Technical role in Oracle Apex User Interfaces Enhancements, Apex Application Upgrade to Universal Theme, Menu Navigations and UIX enhancements.
- Migrated Four MS Access Applications to Oracle Apex. Lead role for data migration, new Apex UI interfaces.
- User Interface Improvements, Responsive Design Improvements
Senior Oracle Apex Consultant
Confidential, Los Alamos, NM
Responsibilities:
- Provided Senior Technical Leadership role in Data integration with external IBM voucher feed data sources with Oracle E-Business Suite. Solution Design, Hands on Development, Architecture, Implementation and Support of Custom Oracle Apex System.
- Custom Built a Workflow Approvals Engine using Oracle Apex, Solution designed multiple charts/graphs showing summary and drill down data on dashboards.
- Defined and Implemented various security layers based upon roles and responsibilities.
- Significant cost savings, modern technology enabled thus allowing CFO group to decommission a 30-year-old IBM voucher data feed of GL and PA data sets into E-Business Suite PA and GL Interfaces.
Technologies: Oracle 12c, Oracle Apex 5.1.3, JSON RESTful Web Services, Extensive PL/SQL, SQL and JavaScript, jQuery, HTML5/CSS3 development within Oracle Apex.
Senior Oracle Consultant
Confidential, Livermore, CA
Responsibilities:
- Provided Senior Technical Leadership role in Data integration with external data sources in the lab, to exchange data between Oracle Apex SIMS Project using RESTful Web Services/JSON.
- Extensive user interfaces design, development of new UI, Enhancements to current Apex UI to provide new functionality, integration capabilities and better workflow to the application. Application Migrations from Oracle Forms/Reports to Apex.
- Upgrade existing Apex applications to Apex 5.x stack - Oracle REST Data Services.
- Converted Several Oracle Forms, Oracle Reports based legacy applications to Oracle Apex 5.1.2
Technologies: Oracle 12c, Oracle RESTful Data Services, Oracle Apex 5.1.2, Apex 4.2.6, JSON RESTful Web Services, Extensive PL/SQL, SQL and JavaScript, HTML5/CSS3, Angular JS Integration with Oracle Apex.
Senior Oracle Consultant
Confidential, Salt Lake City, UT
Responsibilities:
- Provided Senior Technical Leadership role in Data integration with third party vendors to exchange data between Oracle Project Workbench using RESTful Web Services/JSON. Enhanced Apex user interfaces to provide integration capabilities to key users.
- Enhanced Apex UI significantly for better flow, performance and efficiencies.
- Extended capabilities of the application for offline web Mobile Solutions
Technologies: Oracle 11gR2, Oracle Apex 4.2.4 UI, JSON RESTful Web Services, Extensive PL/SQL, SQL and JavaScript, HTML5/CSS3
Senior Oracle Solutions Architect
Confidential, Sunnyvale, CA
Responsibilities:
- Undertook and Delivered end to end solution for DevOps and DBA team in Designing, Building an Enterprise wide Servers and Asset Management Solution on Oracle Apex 4.2.x and 11gEE
- Full Project lifecycle, Data Modeling, Solution Design, UI Development, Deployment
Technologies: Oracle 11gR2, Oracle Apex 4.2.4, jQuery Mobile, Extensive PL/SQL, SQL and JavaScript, HTML5/CSS3
Senior Oracle Apex Solution Architect Consultant
Confidential, Phoenix AZ
Responsibilities:
- Re-Architect, Migrate Design and Develop a portfolio of over 120 In House Oracle Apex Applications that run internal Mortgage Banking Operations.
- Undertook Lead Role and Hands-on Development using Oracle Technologies 11gR2, Extensive PL/SQL, SQL Coding, Apex 4.2, 3.2, JavaScript, jQuery, HTML5, CSS3