We provide IT Staff Augmentation Services!

Oracle Technical Consultant Resume

2.00/5 (Submit Your Rating)

NY

PROFESSIONAL SUMMARY:

  • 9+ years of experience in Analysis, Design, Development, Testing, Customization, Enhancement Support and implementation of Oracle Applications 11i and R12.
  • Experience as an oracle apps technical consultant in oracle EBS with major focus on SCM modules inventory (INV), Engineering Module, Purchase order (PO), order management (OM), I Receivables, financial module (AR), enterprise asset management (EAM), core HRMS, Payables(AP), Bill of Material (BOM).
  • Hands on experience in writing Triggers, Procedures, Functions, Cursor, XML and PL/SQL Packages, Bulk Collect, For ALL clause, REF cursor, DBMS packages, SQL Loader, Analytical functions, Hierarchical function, Dynamic SQL, Execute immediate in Oracle.
  • Extensively used Views, Materialized views, Partitions, Collections, Records.
  • Experience in data analysis, requirements management, and business process modeling in Finance, Banking, Healthcare and advertising industries.
  • Experience in RICE components, oracle SQL/PLSQL, Workflow and SQL loader, upgrade, conversion and production support for oracle applications systems.
  • Prepared documents MD050, MD070 (functional, Technical) design documents for the projects as per the standards.
  • Developed reports, interfaces, Conversions & extensions (RICE) in INV, AP,BOM, Engineering, PO, AR, EAM and Core HR.
  • Analyze data quality and report the anomalies to business users using TOAD, PLSQL Developer tools.
  • Extensive experience in creating XML publisher (BI Publisher) reports using various templates to publish the reports.
  • Have a good Team Leading capability, Strong communication Skills, relationship management and problem solving skills.
  • Good experience in all the SDLC life cycle levels with different delivery approaches like waterfall, agile scrum, test - driven development and worked in onshore/offshore model.

Technical Expertise:

Operating Systems: Windows XP/7 and Linux.

Database RDBMS Technologies: Oracle 9i, 10G, 11G and MYSQL.

Languages: Oracle SQL and PL/SQL, Pro*C,XML

TOOLS: TOAD, PL/SQL Developer, SQL Developer, Microsoft Visio, Microsoft Word, PVCS Version Manager, HP Quality Center, Microsoft Excel, Microsoft PowerPoint, PUTTY, WS FTP,BI Publisher.

Development Technologies: Oracle Forms and Reports, Forms personalization, XML Publisher, Oracle Workflow and Alerts Management

Applications: Oracle Applications 11i, Oracle Application 12.1.1.

Defect/Bug Tracking Tools: Mantis, JIRA and SharePoint.

PROFESSIONAL EXPERIENCE:

Confidential, NY

Oracle Technical Consultant

Responsibilities:

  • Gathering the requirements from the business users on regular meetings and converted the MOM’S to design documents. Understand the functional specification and technical aspects of the project.
  • Working as a Core PL/SQL developer in the team, I am responsible to extract open Invoices and Customer data from AR tables.
  • Writing scripts for load data using SQL * Loader.
  • Created technical design documents (MD70) and functional document (MD60) for new enhancements and defect fixes.
  • High volume file loading into database.Package/procedure creation to efficiently process the enriched data.
  • Experience Performance tuning of existing packages/procedures/Views.
  • Build Creation and Source control through PVCS Version Manager.
  • Used Oracle procedures, functions, cursors and packages for Confidential core account receivable system.
  • Developed framework to generate the XML reports using SQL, PL/SQL, existing packages, procedures and Views. These reports are used for customers and invoice data.
  • Developed standard file format (SFF) to export Customer and Open AR Transactions to CSV files.
  • Designed and developed AP Invoice Open Interface for different sources in Oracle Payables.
  • Modifying database objects based on project needs to update the factor flag..
  • Worked on exception handling for the ease of debugging, displaying the error messages in the calling application and stores the logs in auditing table.
  • Performed modifications on existing forms as per change request using Forms Personalization.

Environment: Oracle10g, 11g PL/SQL, SQL, SQL Developer, XML, Windows 7, LINUX, CVS, JIRA, Oracle Applications R12.1.3, SharePoint and Toad.

Confidential, NY

Oracle Technical Consultant

Responsibilities:

  • Worked with the functional team while extracting non-oracle data (PLM) and converting to oracle with validations.
  • Implemented Performance tuning concepts for ORACLE SQL and PL/SQL scripts and indexing strategy.
  • Worked on staging table creation and loaded data through SQL loader .
  • Worked on conversions for importing data into ITEM, BOM and Engineering tables.
  • Modifying database objects based on project needs.
  • Involved in unit testing the code, bug fixing.
  • Initiated an ECO workflow to notify the users that new files have been received from PLM.

Environment: SQL Developer, Oracle10g, PL/SQL, SQL, SQL*Loader, SharePoint, Windows XP, LINUX and TOAD.

Confidential, Houston, NY

Oracle Consultant

Responsibilities:

  • Creating objects like Oracle Partitions, Materialized views, Views, Indexes.
  • Extensive use of ORACLE collection, procedure, function, packages for importing data into EAM tables.
  • Writing scripts for load data using SQL *Loader.
  • Design and development of work order and assets XML reports using XML publisher.
  • Technical documentation (MD070) test cases and implementation documentations (MD120) for the mentioned objects.

Environment: Oracle9i PL/SQL, SQL, XML, TOAD, SQL *Loader

Confidential

Oracle Developer

Responsibilities:

  • Developed complex queries, joins, inline views stored procedures and functions, triggers, packages in PLSQL for various business requirements.
  • Extracting data from the database using SQL queries as per requirements.
  • Participate in the entire lifecycle of the Product - design, documentation, coding, testing and deployment.
  • Build complex Stored Procedures to populate millions of Data from XML Feed into tables and also to transfer the data to other DB nodes.

Environment: Oracle9i PL/SQL, MYSQL, SQL, LINUX, TOAD, SQL * Loader, XML Publisher.

Confidential

Oracle Developer

Responsibilities:

  • Extracting data from the database using MYSQL queries.
  • Involved in development of PL/SQL packages, database triggers and Alerts.
  • Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
  • Developed complex queries, joins, maintenance, monitoring, automation, trouble shooting and maintenance.

Environment: Oracle 9i PLSQL, MYSQL, Linux, SQL Developer, SharePoint and Windows XP.

We'd love your feedback!