We provide IT Staff Augmentation Services!

Oracle Technical Consultant Resume

SUMMARY

  • Oracle Techno - Functional Consultant, having nearly 8 years of working Experience in Implementation, Upgrade, Support, Roll-outs, Customisation, Debugging and Testing multiple Oracle e-Business Suite R12 projects
  • Designed and developed RICEFW (Reports, Interfaces, Conversion, Extension, Forms and Workflow)
  • Development and Enhancement of Programs using Oracle Development Tools (Forms, Reports, Discoverer, BI Publisher, Workflow Builder)
  • Expertise in developing packages, functions, procedures, stored procedures, triggers, tables, indexes, customized views utilizing Oracle PL/SQL database programming language.
  • Hands on experience with OAF, PLSQL, XML, Java/J2EE, Workflow, BI Publisher. UNIX, Linux, Shell Scripting. Experience with REST and SOAP Web Service Integrations.
  • Extensively worked on BI Publisher reports, Migration and Workflow components
  • Having strong experience with the Oracle Relational Data Base Management System, Oracle Application Development Framework ADF and Fusion Middleware.
  • Relevant experience in Performance Tuning, Data loading using SQL *Loader, and Creation of CRUD (Create, Read, Update, Delete) Rest API using Spring Boot 2.
  • Proficient in programming languages including Solaris shell scripts, Python, APEX, GPG encryption command tools, TLS certificates.
  • Familiarity in programming thin and thick applications in Java using Struts and equivalent MVC-2architecture, Hibernate frameworks, J2EE technologies (Web Services, JSP/Servlets/Tag Libraries, JDO, JNDI, JDBC, SWT), Tomcat, JBoss and SunOne/IPlanet server experience.
  • Implementation experience with Oracle Web Logic middleware, Java, PGP standards, http services, Oracle EBS and related databases Oracle 11g or 12c
  • Good understanding of Oracle Service Oriented Architecture, SOA, BPEL, BAM, WSM, OSB, ODI, OIM, OAM. Working knowledge of Oracle WebLogic Server, Oracle AS (OC4J).
  • Knowledgeable in JavaScript, HTML, XHTML, DHTML, XML, XSLT, XSL-FO, Doclet, Ant, PHP
  • Excellent communication, inter-personal, analytical and documentation skills. Exposure to writing MD050, MD070 and MD120 documentations

TECHNICAL SKILLS

Oracle Applications: EBS R12 (Core HR, CWB, Payroll, SSHR, GL, AP, AR & System Administration)

Operating Systems: Windows, Unix, Linux, Oracle Cloud (SaaS and PaaS), IBM Watson (AI)

Languages: SQL, PL/SQL, Unix, Java, J2EE, XML, Perl, JSP, JSF, CSS, XSLT stylesheet

RDBMS: Oracle 11g and Oracle 12c, Microsoft SQL Server, IBM DB2, MariaDB, Postman

IDE: Oracle J Developer, TOAD, SQL Developer, Oracle Visual Builder, Eclipse, IntelliJ

GUI Tools: Developer 11g, Reports Builder, Forms Builder, Discoverer, Maven, Gradle

Exposure To: XML Publisher, Oracle Web ADI, AME, OAF, Oracle Enterprise Manager (OEM), Oracle Database, Oracle Web Services, SOA & BPEL Technologies Oracle Framework Development, Oracle EBS API's

Tools: & Utilities: Putty, TortoiseSVN, WinSCP, OpenScript, Selenium, Tomcat

PROFESSIONAL EXPERIENCE

Confidential

Oracle Technical Consultant

Responsibilities:

  • Create/modify financial reports thru Oracle EBS using Reports Builder and XML Publisher
  • Analyze financial data of Confidential ’s public sectors (sovereign) and private sectors (nonsovereign).
  • Modified a custom PL/SQL program to insert into a custom subledger table before inserting into the oracle standard GL interface table.
  • Troubleshoot and fix existing issues on monthly financial reporting system (PL/SQL) for bank reconciliation.
  • Creates/modifies Database Functions and Packages based on the client’s requirements to perform business processes.
  • Develops Oracle Workflows for transaction approvals and notifications.
  • Creates and/or modifies OAF pages based on business requirements
  • Uses SQL Developer to load data from a legacy source to Oracle database
  • Design, customize and optimize dynamic banking systems on large financial institutions.

Confidential

ERP Technical Specialist

Responsibilities:

  • Designs, enhances, and implements custom modules and reports.
  • Extends standard modules for customization requirements.
  • Cater production support using Oracle Forms 10g, Oracle Reports 10g, Oracle Workflow, Toad for Oracle and Putty.
  • Works closely with functional partners to understand further the Oracle EBS Financial module.
  • Modified a custom PL/SQL program to insert into a custom subledger table before inserting into the oracle standard GL interface table.
  • Develops reports using Oracle BI Publisher based on the client’s requirements
  • Developed Fine-tuned reports for automating reconciliation of General Ledger and customer transaction records using SQL Analytic Functions
  • Designed creation of optimized DB objects such as tables and views through table partitioning and indexes
  • Manages projects, provides data extraction and resolve tickets Documents technical design, unit tests and migration for each project developments Uses ticketing system to monitor, update progress, and escalate each development phase
  • Support implementation of Web Service, using Oracle Integrated SOA Gateway, for interfacing master data to third party Application (OTM) eliminating redundancy and maintenance of data.

Confidential

Senior Application Developer

Responsibilities:

  • Create and review technical design, performs coding and database development, quality assurance (unit testing, component testing, system testing and integration testing).
  • Provides day-to-day product support and technical liason on the client’s Sales and Commission system.
  • Works closely with business partners to understand business requirements to design quality technical solutions.
  • Provided coaching on Oracle PL/SQL coding, Core Java and Web Services Development.
  • Created Shell scripts and performance tuned procedures to load data from interfaced report data from other applications
  • Worked on industrialization initiatives such as code review automation, integration automation, and entry-exit automation.

Confidential

Software Engineering Analyst

Responsibilities:

  • Analyze, design, develop, test and deploy reports, interfaces, conversions, extensions, and workflows using Oracle technology tools such as SQL Developer, Oracle Workflow, Forms Builder, Oracle Reports Builder, XML Publisher, WEB ADI, and JDeveloper.
  • Work closely with the team lead, business and IT to support Production, maintain interfaces from Third Party systems, propose and develop solutions to extend the functionality of Oracle EBS. Maintain Oracle eBusiness Application and fix related errors.
  • Build PLSQL packages, UNIX installation scripts and implementation plans, unit test plans, adhoc SQLs and BI Publisher templates
  • Troubleshoot and resolve issues by providing effective and optimized solutions.
  • Follow established SDLC process and best practices for code development and release management
  • Automated build and deployment using Jenkins (Migration Tool) to reduce human error and speed up production processes
  • Support for Oracle Fusion (User management, Rating Scales, Performance Process Flow, Template

Confidential

Software Engineer

Responsibilities:

  • Create/modify concurrent program from custom package.
  • Create/modify custom Web Applications Desktop Integrator (WebADI)
  • Create/modify UNIX Shell script as Concurrent Programs in EBS.Troubleshoot and resolve issues by providing effective and optimized solutions.
  • Setup employees and assignment, positions, locations, organizations, compensation workbench, audit trails, valuesets, concurrent programs, concurrent request sets, messages, fast formula
  • Make/generate Oracle report concurrent program and send the output to client. Automated build and deployment using Jenkins (Migration Tool) to reduce human error and speed up production processes
  • Create Oracle E-Business Suite Single Request/Request Set Job to run via CA WA Agent
  • Acted as Key functional coordinator maintaining the configuration of Advance Benefits module including management of employee’s bonus eligibility and total compensation statements
  • Ensures quality of data interfaced from third party data warehouse by analyzing data discrepancies and providing resolution to prevent occurrence of encountered mismatched data

Hire Now