Using my deep professional experience as an Oracle Developer combined with my Oracle DBA background to obtain
- Over fifteen years of working experience in solution design and development of complex business applications, including PL/SQL, Oracle Forms, Reports, Data Warehouse (ETL) and Business Intelligent (BI) technology.
- Over six years of design, development, integration and administration of Oracle Applications 11i/r12 (Financial, HRMS, Manufacturing ) including inbound and outbound feeds, customisations of forms and reports, creation automated processes using Application Program Interfaces (API) and Oracle Workflow.
- Over five years in Oracle database administration.
- Expertise in installation, database space management, performance monitoring and tuning, automating and shell scripting operational procedures, administration of user accounts, general troubleshooting and problem resolution.
RDBMS: Oracle Server 7.3/8.0/8i/9i/10g/11g/12c.
Principles: Multi - tier, Client/Server and Web based Oracle applications 10.7/11i/R12 (ERP, CRM), RDBMS analysis, OLTP and DSS systems, Data Warehousing, ETL and OLAP.
Database Tools: Oracle Forms 4.5/5/6i/10g/11g, Oracle Reports 2.5/3/6i/10g/11g, ERwin, SQL*Plus, Data Pump, RMAN, Workflow Builder, ODI, Informatica, UNIX/Linux Shell scripts, SOA architecture.
Web Technology: Oracle JDeveloper 9i/10g, Oracle ADF/OAF, J2EE, Java scripts, JQuery, XML, JSON, Oracle XML (BI) Publisher, APEX, BPEL.
Oracle 11i/r12: ERP(GL, AP, AR, FA, PER, PAY, OE, ONT, WSH, WIP, INV, QP, PA, PO, OKC, OKS, GMI) CRM (JTF)
Mortgage Application Developer Sr.
Confidential, Cleveland, OH
- Design, develop complex OLTP PL/SQL Transaction processes for Mortgage Management System.
- Create ETL processes for legacy data and complex query for OLAP reports.
- Modify and develop data infrastructure for liability, property liquidity and risk analyse.
- Maintain and Resolve Oracle technical issues on production system.
Independent Incorporated Oracle Database and Applications consultant
Confidential, Richfield, OH
- Design, develop, implement and document ETL processes from Web services, FTP and local various format sources for GM Catalogue publishing.
- Design and develop PL/SQL, ETL and forms for tax collection and distribution applications.
Confidential, Akron, OHOracle Developer
- Design and develop Oracle extensions for Confidential (Transportation Management System) and inbound and outbound interfaces between Confidential and SAP financial and manufacturing modules.
- PL/SQL and Data Model development for Java web applications.
- Create extract data files for ETL and XML reporting.
Confidential, Orrville, OHOracle Developer
- Develop custom hierarchical Category management application and integrate it in Oracle Inventory.
Confidential, Richfield, OHOracle Developer
- Design and develop ETL components for Data Warehouse.
Confidential, Cleveland Area, OHOracle Developer
- Design and develop custom PO Search form.
- Design and develop data conversion programs for Banner ERP system.
Confidential, Elyria, OHOracle Developer
- Design and develop custom Application extensions for Financial, OTC and Manufacturing groups of modules.
- Modify, change and correct previously developed custom programs.
- Provide production support for Financial Applications.
Confidential, Cleveland, OHOracle Developer
- Develop and modify custom Oracle forms, reports and PL/SQL scripts for ERP system.
Confidential, Akron, OHOracle Developer
- Design and develop custom Print label Application for shipment execution.
- Integrate custom applications into Oracle Process Manufacturing.
- Develop and modify custom Oracle forms, reports and stored procedures for ERP system.
Confidential, Rochester, NYOracle Developer
- Design, Development, Implementation and Technical support of complex business custom extensions for Oracle Financial, Manufacturing modules. Designed and recommended solution for custom processes flow integrated with standard applications.
- Created, modified and supported custom AR LockBox Interface Cash Application processes for US and Mexican projects.
- Developed inbound and outbound interfaces, custom built reports, forms, menus and WorkFlow processes integrated with Oracle Applications structure, customized standard forms by the CUSTOM library. Automated manual applications processes by using API.
- Designed and developed JDeveloper Web Applications. Create Business components, Struts framework application process flows and data bounding, Oracle ADF UI components.
- Provided customer support for Oracle standard and custom built applications. Created technical documentation.