We provide IT Staff Augmentation Services!

Senior Oracle Consultant Resume

SUMMARY:

Over 17 years of experience in Information Technology including both large and small projects. Over 12 years of experience in Oracle financials r12 and 11i with more than 14 modules (AR, AP, PA, GL, PO/iProcurment, OTM, iTime/OTL, iExpense, INV, OM, WMS, WSH, CS and HR). Around 7 years of Oracle Discoverer experience with both discoverer as standalone and integrated with Oracle Apps 11i. Some of the significant projects include Financial, Networks & Telecommunications, Energy, Publishing, Utilities, & Construction (Civil Works).

TECHNICAL E XPERTISE

Applications: Oracle Transport Management (OTM formerly GC3 v5.0 Glog), Oracle Applications (vR12, v11i, v10.7, INV, OM, WMS, Shipping (WSH), Customer Service (CS), Sourcing, HR, PA, AR, AP, PO/iProcurement, GL, GIS iTime/OTL, iExpense, iStore), PeopleSoft (CRM, AP, ePro, GL), PropWorks (Airport Billing system), Banner (R2.2) Utility CIS System.

Languages: XSU (XML SQL Utility), SQL, SQL * LOADER, PL/SQL, Unix Shell scripting, VMS Shell, Pro*C, HTML, JavaScript, C, PASCAL, ASSEMBLY LANGUAGE and BASIC.

Data Modeling Tools: Designer/2000 vR6i, vR1.3, ERWin v (4.14, 3.5), Assent

Databases: Oracle 10g, 9i, 8i, v8.0.5 (64 bit), v7. X, MS - Access.

GUI’s: JDeveloper 10g, Oracle Forms (v9i, 6i, 4.5 &3.0), TavizETL/DWH Informatica Toolset, NoetixViews (BI Views for Data warehousing), Discoverer 4i, 6i, 9i, 10g, Oracle Warehouse Builder

Reporting: Noetix Web Query, Noetix Query Server, Crystal Enterprise XII, Oracle Reports (v9i, 6i & 2.5), SQL * Reports. Business Objects.

Operating Systems: VAX OPEN VMS, UNIX (AIX v4.2, SunOS v5.6, HP), MS-Windows (7, Vista, XP, 2000, NT, 98, 95), and MS-DOS.

Development Tools: TOAD, SQL* Navigator, Embarcadaro, Rapid SQL, MS OFFICE, Microsoft Project, LOTUS 123, Word Star.

Testing Tools: Test Director.

Hardware: Sun Solaris, HP 9000, RS 6000 and Pentium (IBM PC Compatibles).

Version Control: Tortoise, Perforce (P4), CCC Harvest, PVCS (Windows based), SCCS (UNIX based), CMS (VMS Based).

WORK EXPERIENCE:

Confidential

Senior Oracle Consultant

Applications: Oracle Applications r12 12.1.3 & (11i) v11.5.10.2 (AP, iExpenses, GL, GIS, AR & FA)

Responsibilities:

  • Implementation of business tasks for Integration of 23 Oliver Wyman Group (OWG) countries into Confidential .
  • Carried over tasks in accounts payable module setting up Banks, Internal Bank accounts, Payment documents and related program setups.
  • Performed configuration tasks, which include but not limited to setting up Financial Options, Payables options and profile options.
  • Setup of open GIS interface for intercompany transactions into global intercompany system (GIS) module.
  • Analyzed and developed reconciliation scripts for validating Supplier conversion/load.
  • Analyzed, designed & developed functional specification for employees & suppliers EFT solution using Royal Bank of Scotland (RBS) in countries Germany, France and UK.
  • Analysis & design of solution for user requirements “Invoice approver query tool”.
  • Wrote functional specification and tested end to end custom solutions developed.
  • Setup of test data, Invoices, payments, GL transfers etc for newly implementing operating units and performing sanity checking of configurations and program setups etc

Confidential

Project Lead Consultant

Applications: Oracle Applications (11i) v11.5.10.2 (Project Costing, OTL, iExpenses, INV, iProcurement, PO, OM, GL, GIS, AR, AP etc.)

Software Tools: Workflow, Discoverer v10g, Oracle Reports 6i, Oracle v10g, TOAD, etc.

Responsibilities:

  • Configured workflow and set best practices for AECL according to their policy guidelines.
  • Interfacing intercompany transactions into Global intercompany system through external sources.
  • Fixed workflow issues with OTL & iExpenses.
  • Gathered user requirements, did analysis & developed functional & technical specifications
  • Handled support tickets and resolved issues with all modules across AECL.
  • Designed & developed Custom reports in various Oracle modules using Reports 6i.
  • Used Manufacturing Open Interfaces/API & developed process to update all item cost by adding 10 Material Overhead.
  • Designed / architected Discoverer reporting and extraction of data from various sources including Oracle Apps 11i modules.

Confidential

Technical Project Manager / Consultant

Applications: Oracle Applications r12 v12.1.3 & (11i) v11.5.10.2 (GL, AR, AP)

Software Tools: Oracle Development toolset (Workflow, Reports, Forms, jDeveloper etc).

Responsibilities:

  • Using Oracle provided Benchmarks and standard practices for r12 ebusiness suite implementation/upgrade designed solution for clients environment.
  • Successfully performed pre-upgrade and post upgrade tasks based on oracle checklist and clients environment
  • Smooth commissioning of all RICE components in r12 environment as they were working in earlier 11i version.

Confidential

Techno-Functional Lead Consultant

Applications: Oracle Applications (11i) v11.5.10.2 (Project Costing, GL, AR, AP, PO etc.)

Software Tools: Discoverer 9i, Oracle Reports 6i, Oracle v10g, TOAD, etc.

Responsibilities:

  • Designed & developed project status and budget status change workflow.
  • Designed / architected Discoverer reporting and extraction of data from various sources including Oracle Apps 11i Project Costing module.
  • Designed and developed EUL for project costing module and underlying objects.
  • Developed security modal based on project costing module and client’s reporting security architecture and implemented same.

Confidential

Sr. Technical Consultant

Applications: Oracle Applications (11i) v11.5.10.2 (GL, AP, AR, FA, OM, INV, PO etc.)

Software Tools: Noetix WebQuery Reporting, Discoverer 4i, Oracle Reports 6i, Oracle v10g, SQL Server, TOAD, etc.

Responsibilities:

  • R12 Assessment for migration of current custom reports in various technologies at Rogers.
  • Reviewed current reporting technologies used. And suggested which are best for client needs.
  • Streamlined process of request for reporting and various steps to make the deliverable to production instances.
  • Created Functional & Technical documentation templates. Used for detailing out what has been agreed upon and delivered in detail.
  • Administration & security compliance of Noetix Web Query & Discoverer 4i.
  • Gathered user requirements, did analysis & developed functional specifications
  • Designed & developed Noetix WebQuery reports for various Oracle Modules .
  • Modified existing and created new Oracle Reports v6i for Finance group.
  • Designed & development of Concurrent programs for complex query based reporting / data extracts
  • Performance tuned existing reports for faster data results and less processing times.

Confidential

Sr. Techno-Functional Consultant

Applications: Oracle Applications (11i) v11.5.10.2 (PO, AP, AR, OM etc.)

Software Tools: Oracle v10g, TOAD etc.

Responsibilities:

  • Designed & developed EDI Interfaces between Oracle 11i Purchasing and Harris Suppliers using e-Commerce Gateway .
  • Did gap analysis and requirements for additional extensions and interfaces.
  • Documentation for Technical Design, Functional Design and business process flow.
  • Prepared UAT test cases, Made users to work on UAT schedule.
  • Managed Project on the whole in Business and Technical aspect.
  • Smooth Knowledge transfer and post production support.

Confidential

Sr. Techno-Functional Consultant

Applications: Oracle Applications (11i) v11.5.10.2 (GL, AR, AP, FA, OM, etc.)

Software Tools: Oracle v10g, TOAD, PL/SQL Developer.

Responsibilities:

  • Designed & developed Interfaces between Oracle 11i GL and WEBCAS (Home Grown Oracle Application).
  • Did gap analysis and requirements for additional extensions and interfaces.
  • Developed Workflow related changes for Order management.
  • Developed reports output in EXCEL format on Concurrent Manager using PL/SQL Packages.
  • Designed & developed Reports in Reports 6i.
  • Developed Interfaces/Extracts Loads into Oracle 11i.
  • Documentation for Technical Design, Functional Design and business process flow.

Confidential

Sr. Techno-Functional Consultant

Applications: Oracle Applications (11i) v11.5.10.2 (INV, OM, WMS, Shipping (WSH), Customer Service (CS), AR, AP, GL), and 10.7 Smart Client.

Software Tools: Oracle v10g, 9.2.0.5., TOAD, JDeveloper, OAS v10g.

Responsibilities:

  • Designed & developed Interfaces between Oracle WMS module to ScanCode Application. Used Web Services for integration to & from Warehouse Management / Order Management. Extensively used XSU XML SQL Utility for parsing XML messages.
  • Did gap analysis and requirements for additional extensions and interfaces.
  • Developed Workflow related changes for Order management and Shipping.
  • Developed Webservice Endpoints using JDeveloper, Oracle enterprise Manager on OAS10g and PL/SQL Packages on Oracle Apps 11i.
  • Designed & developed Reports in Reports 6i and Business intelligence.
  • Designed & developed Custom Oracle Screens for Oracle Service module 10.7.
  • Developed Interfaces/Extracts to Oracle 10.7 SC from NCS (Signal Control Computer in Sybase database).
  • Documentation for Technical Design, Functional Design and business process flow.

Confidential

Business / Data Analyst

Applications: Oracle Applications 11i (AR, AP, GL), Phoenix ( Confidential Internal App).

Software Tools: ERWin 4.1.4, Oracle v9.2.0.5, TOAD

Responsibilities:

  • Identified and implemented subject areas according to reporting requirements and divided reports among the different subject areas.
  • Designed detail Data-marts (Models) for different subject areas identified. Developed Star Schema & Slowly changing Models
  • Designed of ETL specifications for ODS objects & Data-marts in detail with source and target mapping, Logic etc.
  • Walk through of ETL Specs with ETL developers to better understanding the design concept and model.
  • Managing & coordinating ETL Team with their work assignments by answering / advising to their queries.
  • Developed Validation SQLs for all the ODS objects from Oracle Applications & Phoenix to MCAS Data warehouse.
  • Did gap analysis to figure out additional extensions and interfaces.

Confidential

Techno-Functional Lead Consultant

Applications: Oracle Applications 11i (AR, AP, Sourcing), Oracle transportation Management (OTM formerly known as GC3/Glog v5.0).

Tools: & Environment: Oracle v9.2.0.5, Oracle iAS 10g, INFORMATICA, Crystal Enterprise Reports, jDeveloper, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, XSU (XML SQL Utility), AIX UNIX Servers, Windows XP.

Responsibilities:

  • Designed & developed Interfaces between OTM/GC3 (Oracle Transportation Management) and Oracle Application using Web Service integration in OTM. Extensively used XSU XML SQL Utility for parsing XML messages from OTM.
  • Did gap analysis to figure out additional extensions and interfaces.
  • Developed and configured OA framework Customization for Sourcing module. Workflow related changes for PO creation from Sourcing.
  • Developed Webservice Endpoints using JDeveloper, Oracle enterprise Manager on OAS10g and PL/SQL Packages on Oracle Apps 11i.
  • Designed & developed Reports in Crystal Enterprise XII. Designing and Configuring of Info View folders for business users and Publishing of reports using Central Management Console of Universe.
  • Designed & developed Interfaces/Extracts from Oracle Applications & OTM to Canadian Wheat Board (CWB) Data warehouse using Informatica ETL toolset.

Confidential

Techno-Functional Consultant

Applications: Oracle Financials 11i (AR, AP, PO, GL), PeopleSoft, ACCPAC.

Tools: & Environment: Oracle v9.2.0.5, SQL, PL/SQL, TOAD, XP Servers

Responsibilities:

  • Analyzed Gaps between PeopleSoft Accounts Receivable and Oracle 11i Accounts receivable and designed solutions / fixes.
  • Developed Extracts for AR Customers, Transactions, Payments and Adjustments as per the client’s criteria.
  • Analyze PeopleSoft AP & PO structures and design data mapping between Oracle 11i and PeopleSoft for development of Data extracts.
  • Developed Data Extracts for AP Vendors, Invoices (Headers and Distributions), payments and schedules.
  • Developed Data extracts for PO headers, lines, locations and distributions.

System/Business Analyst

Confidential

Applications: Custom CRM.

Tools: Oracle Forms & Reports 6i, Oracle DB v9.2.0.5, SQL, PL/SQL, TOAD, XP Servers.

Responsibilities:

  • Identified Gaps in CRM application and proposed enhancements.
  • Developed Requirement and Functional specification for gaps.
  • Solution / Technical Design for enhancements/modifications proposed.
  • Recommended various solution approaches
  • Analyzed feasibility of enhancements and made recommendations for solutions.
  • Developed Front end screens with complex functionality. Made my code very flexible for re-usability.

Confidential

Technical Consultant

Applications: Oracle Financials 11i (v11.5.9), AR, AP, GL, iProcurment, OE (Custom), OTL.

Tools: Oracle v9.2.0.5, Forms v6i, Reports v6i, SQL, PL/SQL, PeopleSoft CRM/HR, XP Servers, Sun Solaris UNIX.

Responsibilities:

  • Developed interfaces between Custom OE to AR. Workflow related enhancements and development in OTL, iProcurment and Web expenses.
  • Development/Configuring Oracle 11i to fit Business needs.
  • SOX compliant related reports and processes development.
  • Good amount of documentation related to development life cycle.

Confidential

Technical Consultant

Applications: Oracle Financials 11i (v11.5.8), Modules AP, PO, GL

Tools: Oracle v9.2.0.5, Forms v6i, Reports v6i, SQL, PL/SQL, XP Servers, HP UNIX.

Responsibilities:

  • Updating Custom Objects which include but not limited to Reports and Forms/Screens to work under Multi-Org architecture.
  • Production support for issues related to Interfaces to third party applications.
  • Remodelling of Oracle AP Utility Refunds Interface to IBM for reducing of Manual work @ IBM cheque printing centre.
  • Customized Cheque format report/process to accommodate IBM needs.

Confidential

Technical Consultant

Applications: Oracle Financials 11i (v11.5.9), Modules AP (iExpense), HR and PAYROLL

Tools: Oracle v8.1.7.4, Forms v6i, Reports v6i, SQL, PL/SQL, XP Servers, SUN Solaris UNIX.

Responsibilities:

  • Developed EFT Interface to RBC, setting up environment, like configuring DFF, Lookups etc.
  • Technical analysis of Notification on EFT completion sent to Employees/Suppliers intimating funds credited.
  • Developed Workflow for Notification handling.
  • Documented Technical Design for functional requirements of Payroll to HR interface of Employee Bank account information.
  • Developed Interface for external Payroll to Oracle HR for bank account info update.

Confidential

Technical Consultant

Applications: Oracle Financials 10.7 (Char) 11i (latest v11.5.10).

Software Tools: Oracle v9.2.5i, Forms v6i, Reports v6i, SQL, PL/SQL. Modules AR, GL and AP

Environment: MS-Windows 2003, AIX 5.1 UNIX(RS6000).

Responsibilities:

  • Analysis and conversion of present Interfaces and other feeds (from & to) Oracle Applications.
  • Documenting all the work performed and client for final implementation.

Confidential

IT Consultant

Applications: Oracle Financials 11i (v11.5.3).

Software Tools: Oracle v8i, Forms v6i, Reports v6i, SQL, PL/SQL. Modules GL, AP & AR

Environment: MS-Windows 2000, HP UNIX.

Responsibilities:

  • Communicating with users for gathering evidences and sign offs.
  • Refreshing Toolkits with new evidences for time stamped outdated evidences.
  • Analysis of Toolkits and GAPs and providing reports of the same.
  • Extracting reports from Production system as evidence for some GAPS/Toolkits.
  • Preparing Toolkits as per auditors request.

Confidential

Interface/Analyst

Applications: Oracle Financials 11i (v11.5.8).

Tools: Oracle v9i, Forms v6i, Reports v6i, SQL, PL/SQL, Taviz . Modules GL and AP, MS-Windows 2000, HP UNIX.

Responsibilities:

  • Coordinating with all Wave 5 ministries for System Integration Testing and answering their FAQs.
  • Production support for ministries went live with Confidential .
  • Analysis and design/configuration of new interfaces.
  • Link Testing production & go live issues.

Confidential

Programmer/Analyst

Applications: Oracle Financials 11i (v11.5.7), PropWorks & Oracle Discoverer 4i

Software Tools: Oracle v9i, v8i, Forms v6i, Reports v6i, Workflow, SQL, PL/SQL, Taviz, Noetix Views for Discoverer. Modules HR, PA, AR and AP

Environment: MS-Windows NT, HP UNIX.

Responsibilities:

  • Creating and maintaining HR reports in Oracle Discoverer. Built Interfaces from and to HR module using Standard HR APIs.
  • Support and development of interfaces between Oracle Apps 11i and PropWorks an Airport Billing application using Taviz a middleware (Integration Studio).
  • Writing embedded SQL for Taviz .
  • Setup of environment for OAR Autoinvoice open interface to work which include Transaction Flex Fields mapping of the columns, lookups etc.
  • Day to Day support on ongoing issues. Analyzing the gaps in the interfaces and developing new procedures and functions to fill up the same.

Confidential

Programmer/Analyst

Applications: Oracle Financials 11i (v11.5.8).

Software Tools: Oracle v8i, Forms v6i, Reports v6i, Workflow, SQL, PL/SQL

Environment: MS-Windows NT, HP UNIX.

Responsibilities:

  • Designed and developed packaged procedures to convert/interface to Oracle AR 11i from legacy (11.0.2), which included Customers Header/Site records, Invoices (Project & Non-Project).
  • Development and registration of Billing Extensions (packaged procedures) for converting summarized Project Accounting (PA) Billing/Revenue by project, by period and detailed open AR project invoices.
  • Setting Up the environments for API’s and open interfaces to work which include Descriptive Flex Fields (DFFs) mapping of the columns, lookups etc.
  • Extensively used Oracle delivered API’s and Open Interfaces in developing these interfaces.
  • Developed, custom PA Billing Extensions for ongoing AECL billing needs as per their business requirements.
  • Analyzed the legacy code to evaluate percentage of code re-usability, and additional 11i enhancements, which can be used to achieve business requirements.
  • Re-used the legacy (11.0.2) code wherever applicable and improved quality and added new functionality for better control and flexibility provided in 11i.
  • Developed an Interface to Oracle HR from PeopleSoft HR application for Oracle Projects and Financial modules to share employee’s data.

Confidential

Sr. Programmer/Analyst

Applications: Oracle Financials 11i (v11.5.2), Oracle Financial Analyzer (6.4), Oracle Discoverer 4i.

Software Tools: Oracle v8i, Forms v6i, Reports v6i, Workflow, SQL, PL/SQL.

Environment: MS-Windows 2000, HP UNIX.

Responsibilities:

  • Bug fixing and enhancements on iTime / iExpense modules using workflow builder and Interfaces.
  • Administering and Maintenance of Oracle Discoverer Application pointing to Reports server. Created new Business areas, Developed Views pointing standard tables with certain criteria, for security purposes.
  • Maintaining, Oracle Financial Analyser a different application attached Oracle Financials.
  • Enhancement and maintenance of Interfaces to integrate Oracle Modules, PeopleSoft HR application and third party applications (PRO Business) Payroll etc.

Hire Now