Post Job Free
Sign in

Oracle Project Manager

Location:
Northampton, MA
Posted:
August 03, 2017

Contact this candidate

Resume:

VIJAYA LAKSHMI

Oracle Apps EBS Techno-Functional / Project Manager & PL/SQL Developer

Phone: 732-***-****

Email: ********.******@*****.***

PROFESSIONAL SUMMARY:

Over 10+ years of experience as a Certified Oracle E-Business Essentials R12 in requirement analysis, design, development and implementation as a Techno-Functional Consultant for various product versions of Oracle Applications e-Business Suite ranging from 11.0.3, 11.5.9, 11.5.10.2 to 12.1.3.

Experience in diverse roles across my career as Implementation Specialist, Techno-Functional Consultant, Production Support Executive and Oracle Developer.

Expertise in Oracle Applications 11i and R12 Supply Chain modules Order Management (OM), Inventory (INV), Accounts Receivables (AR), Warehouse Management System (WMS), Mobile Supply Chain (MSC), Purchasing (PO), Accounts Payable(AP), General Ledger (GL), Shipping (WSH), Cash Management (CE), Fixed Assets (FA), I procurement, I expenses.

Experience in Oracle HRMS R12 modules Oracle Advance Benefits (OAB)

Experience working in designing and developing custom solutions using application interfaces and APIs.

Experience working in data conversions between different versions of Oracle EBS and migration from legacy applications.

Project Manager for several IT projects, including an Oracle EBS project.

Experienced in loading data into Oracle Database using Data Loader.

Extensive experience with the Order to Cash (O2C) and Procure to Pay (P2P) business flows.

Design validation & setup of HR, GL, AP, AR, INV, OM, Advanced Pricing and PO modules.

Knowledgeable in Oracle table structures, schemas, APIs and open interfaces.

Proficient in SQL to pull up the data and use these data for migration and configuration purposes.

Proficient in SQL tuning and optimization of queries.

Good experience in Oracle XML / BI Publisher reporting.

Expertise in customizing and creating new forms and reports using Oracle Forms & Reports.

Extensive knowledge on PL/SQL components like Procedures, Functions, Cursors, Packages, Triggers and other features such as VARRAYS, Nested Tables, Index by tables, Bulk Collections, Database Triggers using features like Cursors, Collections, Exception Handling and Bulk binding.

Experience with oracle and other utilities like PLSQL developer, SQL Navigator and Toad.

Hands on experience working on UNIX platforms in developing shell scripts.

Proficient in Oracle Tools and Utilities such as TOAD, SQL Plus.

Experience in working with Oracle Utilities like UTL_FILE Package and Interfaces.

Expertise in Oracle Integrated SOA and web services technology.

Proficient in preparing documents based on Oracle AIM and Oracle OUM standards.

Have strong experience in leading the team and handling critical production issues.

FUNCTIONAL SKILLS

Application Version: Oracle Applications e-Business Suite 11.0.3, 11.5.9, 11.5.10.2, 12.1.3

Applications:

HRMS: Oracle HR, Oracle Payroll, Oracle Advance Benefits, Oracle Time & Labor

SCM: Order Management (OM), Inventory (INV), Purchasing (PO), Advanced Pricing, Warehouse Management (WMS), Mobile Supply Chain

CRM : Install Base

Finance: General Ledger (GL), Account Receivables (AR), Account Payables (AP), Cash Management (CE), Fixed Assets (FA), Cash Management (CE),

TECHNICAL SKILLS

Oracle Apps Modules : Financials (GL, AP, AR, FA, CA); O2C (OM, INV, WIP, BOM, WMS); P2P (PO,iProcurement,)

Databases : Oracle 11g, 10g, Oracle 9i, Oracle 8i

Documentation : AIM and OUM Methodologies

Third Party Tools : Vertex and Pitney Bowes

Code Control Tools : CVS, TFS, Clear Case, KINTANA, SVN

Development Tools : Oracle SQL, PL/SQL, UNIX Shell Scripting, Oracle Forms, Macro

Agile Tool : Rally Enterprise Edition

Reporting : Oracle XML/BI reports, Oracle Reports

Office Tools : MS Office, MS Project

Development Tools : SQL*Plus, SQL Developer, PLSQL Developer, SQL Navigator, TOAD

EDUCATION:

Bachelor of Science in Information Technology – 2008 ( Pondicherry University )

CERTIFICATION

1Z0-204 - Oracle EBS R12: E-Business Essentials

1Z0-521- Oracle E-Business Suite 12 Supply Chain Certified Implementation Specialist: Oracle Order Management

PROFESSIONAL EXPERIENCE:

Vonage, Holmdel NJ Oct 2015 – Present

Oracle Techno-Functional Consultant (Finance & HRMS)

Responsibilities

To Provide Production Support for Oracle Inventory, Purchasing (iProcurement, ASCP), Pricing, Oracle Finance (AR, AP, GL, FA) and Advance benefits.

To Integrate new financial and Inventory to Oracle applications during new acquisitions.

To migrate data into oracle from external sources.

Building new programs to connect & exchange data between third party applications using Web services call (Oracle Integrated SOA) and UTIL FTP process.

To help business user during UAT and extended production support for automatic invoice processing using AP Web Center.

To create new or to customize existing forms and reports using Oracle Forms and Reports, XML / BI publisher report as per business needs.

To personalize and customize existing OAF pages.

Configuring setups new instances for SIT.

To prepare custom queries for business users according to their ad-hoc needs.

Worked with Fifth third and PaymodeX vendors to implement PaymodeX for Vonage. Solely competed setups, development and integration.

Additional Responsibilities:

Create and manage data base objects such as Tables, Views, Indexes, Sequences, and Synonyms, procedures, packages.

Create PL/SQL packages, procedures, functions applying the business logic to load the data to relevant tables.

Work towards SQL Tuning and applying hints for faster and better performance of the SQL queries.

Prepare functional, user documents, process flow diagrams and flow charts.

Developed views to facilitate easy interface implementation and enforce security on critical customer information.

Prepare test plans and perform unit testing, CRP and SIT testing and assist users during UAT.

Interacted daily with business users and functional resource to gather requirements for dashboard.

Constantly interact with third party application IT and business team during new merger and to gather technical business requirements.

Environment, Tools & Software’s

Oracle 11g, Oracle Applications E-Business Suite R12.1.3, Oracle Forms and Reports, PL/SQL, TOAD, UNIX, SOAP UI, JDeveloper

McGraw Hill Construction, Princeton NJ Feb 2014 – Oct 2015

Oracle Project Manager & Tech Lead

The Project deals with capturing the issues and requirements reported by business users and to propose appropriate solutions and to implement the changes and/or to create a new process if required and support Month-End closing activities at the end of every month.

Responsibilities

To interact with users and to gather inputs on various business requirements and problems.

To propose appropriate solutions and to develop solutions for business requirements and to fix/apply corrective actions for the issues as stated by the users.

Analysis of the Database, various components in the Application and Third Party applications. Capturing the Analysis in BP010 and BP040.

Capture the requirement in BR030 document and coming up with BP080 (Future Process Model / Future state architecture).

Preparing BR100 document to capture the setups in future state application and preparing MD060 and MD070 design documents & Oracle R12 EBS Financial Models.

Participated in business planning and requirements review of Oracle Financials, Discrete Manufacturing, Order Management / Shipping and Inventory (Warehouse - WMS), Advanced Supply Chain Planning, Customer Relationship Management, Logistics Management and Enterprise Asset Management solutions.

Delegate and track task assigned to offshore team using Rally (Agile tool) and assist them with the day to day activity.

Integrating third party application with Oracle Application.

Migrating Data to new environment.

To help business by supporting in-house ‘Horizon’ application and ease up their day-to-day activities.

To process transactions, post, verify and correct journal entries and generate financial statements at the end of each month and assist with period closure

Additional Responsibilities:

Create and manage data base objects such as Tables, Views, Indexes, Sequences, and Synonyms, procedures, packages.

Create PL/SQL packages, procedures, functions applying the business logic to load the data to relevant tables.

Work towards SQL Tuning and applying hints for faster and better performance of the SQL queries.

Prepare functional, user documents, process flow diagrams and flow charts.

Developed views to facilitate easy interface implementation and enforce security on critical customer information.

Prepare test plans and perform unit testing, CRP and SIT testing and assist users during UAT.

Interacted daily with business users and functional resource to gather requirements for dashboard.

Hands-on experience in scheduling batch jobs in UNIX.

Create deployment scripts to deploy changes in production environment.

Monitoring and submitting custom UNIX jobs for the business users during UAT.

Create and maintain deployment scripts to deploy changes in production environment.

Environment, Tools & Software’s

Oracle 11g, Oracle Applications E-Business Suite R12, Oracle Forms and Reports, PL/SQL, TOAD, UNIX, Rally Agile Development software, Vertex Q series, Pitney Bowes Spectrum 10.

McGraw Hill Financials, Princeton, NJ Jul 2013 – Feb 2014

Oracle Project Manager

The Project deals with data sync ups such as syncing up master data, setups and look ups between Oracle Applications R12 Production and Development Environment.

Responsibilities

To interact with users and to gather inputs on various business requirements and problems.

To propose appropriate solutions and to develop solutions for business requirements and to fix/apply corrective actions for the issues as stated by the users.

Worked as a Functional Analyst in Implementations, Upgrade and Post Production Support of Oracle EBS in various industries.

Coordinate with offshore in the development and support for interfaces for data sync up

Create and maintain BR100 application setup document for all licensed applications in R12.1.3

Additional Responsibilities:

Design and develop VB macros for data-sync up activities and other reporting results

Create and manage data base objects such as Tables, Views, Indexes, Sequences, and Synonyms, procedures, packages.

Create PL/SQL packages, procedures, functions applying the business logic to load the data to relevant tables.

Work towards database optimization for better application performance

Prepare functional AN100 and technical DS140 documents and also other user documents and process flow diagrams as per OUM Methodology

Create IM90 deployment scripts to deploy changes in production environment.

Environment, Tools & Software’s

Oracle 11g, Oracle Applications E-Business Suite R12, TOAD, Oracle Forms and Reports, PL/SQL, UNIX

Client: Motorola Solutions Inc. Schaumburg, IL Jan 2013 – Jul 2013

Oracle Techno Functional Consultant

The Project deals with data conversion from Oracle Applications 11.5.10.2 to 12.1.3 in SCM and CRM modules and re-implementation of application interfaces.

Responsibilities

To interact with key stakeholders for gathering requirements specific to data migration and to propose appropriate conversion strategies.

To design technical solutions including code and documentation (CV40 and CV60) for the conversion components

Migrate solutions across instances and version management using ‘KINTANA’ and ‘Clear Case’

Generate statistics and other reports post conversion on data accuracy and quality

Additional Responsibilities:

Create and manage data base objects such as Database Links, Tables, Views, Indexes, Sequences, and Synonyms, procedures, packages.

Create PL/SQL packages using public APIs, procedures, functions applying the business logic to load the data to relevant staging and interface tables.

Work towards database optimization for faster conversion and smaller downtime windows during migration

Prepare functional and technical design documents for data conversion.

Create deployment scripts to deploy changes in production environment.

Environment, Tools & Software’s:

Oracle 11g, Oracle Applications E-Business Suite R12.1.3, R11.5.10.2 PL/SQL, UNIX and Excel Macros, VB Script for Reporting

Client: Century Telecom, Minneapolis, MN Dec 2012 – Jan 2013

Oracle Technical Consultant

The Project deals with data conversion from Oracle Applications 11.5.10.2 to 12.1.3 in SCM and CRM modules and re-implementation of application interfaces and AK Pages to Oracle Applications Framework pages.

Responsibilities

To interact with key stakeholders for gathering requirements specific to design and development of OAF Pages

To design technical solutions including code and documentation (AN100 and DS140) for the development components

Additional Responsibilities:

Create Oracle Applications Framework web pages using J-Developer IDE.

Work towards database optimization for faster conversion and smaller downtime windows during migration

Prepare functional and technical design documents for data conversion.

Create deployment scripts to deploy changes in production environment.

Environment, Tools & Software’s

Oracle 11g, Oracle Applications E-Business Suite R12.1.3, R11.5.10.2 ‘J-Developer’, PL/SQL, UNIX

Hutchison Three Telecom Plc, UK Mar 2010 – Dec 2012

Oracle Applications Technical Lead

The Project deals with the integration of 3rd party systems like SAP and Red Prairie WMS with Oracle Apps 11.5.10 and a parallel upgrade from 11.5.9 to 11.5.10.2 as a Global Single Instance (GSI).

Responsibilities

To interact with key stakeholders for gathering requirements specific to design and development of integrating Oracle EBS with other industry applications via a messaging broker

Perform map and gap analysis to integrate the enterprise applications together in sync with the day-to-day business processes

To design technical solutions including code and documentation (MD050 and MD070) for various development components by Oracle AIM Methodology

To prepare TE20, TE50 test scripts, execute tests, monitor and fix defects.

Additional Responsibilities:

Develop PL/SQL code using Interfaces and APIs for various business requirements.

Prepare CV40, CV60 migration documents and develop code for migration of data from Oracle E-Business Suite 11.5.9 to 11.5.10.2

Design and Development of APEX 4.x applications and integrating them with Apps.

Prepare BR100 documents, maintain versions and migrate code across database instances.

Design TE20, TE50 test scripts, execute tests, monitor and fix defects.

Reporting and other managerial activities.

Environment, Tools & Software’s

Oracle 11g, Oracle Applications E-Business Suite R11.5.10.2, R11.5.9, Oracle Application Express (APEX) 4.1, PL/SQL, UNIX

Client: Motorola Mobility Inc., Mar 2008 – Feb 2010

Oracle Applications Production Support Executive

The Project deals with incident tickets, to respond and address various issues reported by customers, vendors and manufacturing units and assisting them in handling orders through various stages, managing inventories, creating invoices, generating advance shipment notices.

Responsibilities

Incident Management - To identify, analyze, and correct issues reported by customers, vendors and the manufacturing units across geographies and assist them in handling orders through various stages, managing inventories, creating invoices, generating advance shipment notice (ASN) and support them during period end activities.

Change Management - To perform updating and deletion of the data in production instance, after carefully tested in support or test instance.

Problem Management - To provide permanent fixes for the re-occurring issues and bugs in existing processes or code.

Additional Responsibilities:

Monitor queues and incident tickets, assigning it to the right teams and to perform hand over for persistent issues.

Develop PL/SQL code using Interfaces and APIs for fixes and new business requirements.

Environment, Tools & Software’s

Oracle 9i, Oracle Applications E-Business Suite 11i, PL/SQL, TOAD, UNIX

Sure Soft Technologies, Pondicherry Mar 2007 – Mar 2008

Developer

The project deals with implementation of Shopping application, which Oracle database in back-end.

Responsibilities

Work towards database optimization for better application performance

Develop the Data Loader scripts to load data into the staging tables from the flat files.

Design and develop VB macros for data-sync up activities and other reporting results

To propose appropriate solutions and to develop solutions for business requirements and to fix/apply corrective actions for the issues as stated by the users.

Create PL/SQL packages, procedures, functions applying the business logic to load the data to relevant tables

Environment, Tools & Software’s

Oracle 11g, Custom Forms & Reports application, PL/SQL, UNIX, Excel Macros



Contact this candidate