Vandana Hange

+1-786-***-****

adchnz@r.postjobfree.com

Pleasanton, CA

Professional Summary

Over 15 years of experience in Design, Development, Customization and Support in Oracle applications (Oracle E-Business Suite EBS) supply chain and finance modules like Order Management (OM), Account Receivables (AR), Bills of Materials (BOM), Inventory (INV), Purchase Order (PO), Oracle Payables (AP), General Ledger (GL), Oracle Payables (AP), CRM modules like Services (CS), Service Contract (SC) and Human Resource Management System (HRMS - CWB) and integration of EBS entities to OTM.

Extensive experience using Agile and Waterfall development methodologies, which includes full-cycle implementations in Procure to Pay (P2P), Order to Cash (O2C), Service Contracts.

Experienced in project tracking platform JIRA and ServiceNow.

Having rich experience in Oracle EBS 11i & R12 solutions devlopment, support and enhancement projects.

Excellent knowledge of AOL (Application Object Library) and System Administration Modules.

Strong knowledge in Oracle ADF 11g Application Development (ADF Faces, ADF Page Fragments, ADF Regions, ADF Task Flows and ADF Business Components) and web services.

Involved in Complex SQL Queries and writing PL/SQL programs API's (Packages, Functions, Triggers, procedures).

Expertise in implementing RICEW (Reports, Interfaces, Conversions, Extensions, Workflow) components in the area of technical design, development, Integration testing and deployment.

Experience in design, analysis, development, testing and implementation of applications in Oracle E-Business Suite R12/11i, Oracle 11g/10g, Oracle Forms 6i/10g, Oracle Reports 6i/10g, XML Publisher 5.6, JDeveloper10g/11g OA Framework.

Experience in SQL* Loader, Oracle API’s and UTL_FILE Packages for data conversion and interfaces.

Excellent programming skills in stored procedures and Oracle (PL/SQL including Triggers and Functions) and expertise in database Performance Tuning by implementing parallel Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, rebuilding indexes and also used the Explain Plan, TkProf and SQL Tracing and Exposure to UNIX shells scripting.

Experience in Application System Administration activities like managing concurrent managers, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues.

Building Data extract, Validate, Transform, and Load inbound / outbound processes within Oracle data sources EDI like EDI 856 ASN, EDI 810 Invoice, EDI 854 Purchase Order.

Worked on Advanced PL/SQL Concepts (PL/SQL Tables, Record type, Bulk Collects).

Expert in preparing following documentation using oracles AIM methodology Technical specifications (MD070), Functional Specification (MD050), Conversion Mapping Documents (CV050), Conversion Data Mapping (CV040), Conversion Technical Design Document (CV060), Installation Document (MD120), Test Case Document (TE040), and user training manuals.

Ability to manage multiple tasks, work independently and quickly adapt to new technologies.

Good communication and interpersonal skills.

Technical Skills

ERP

Oracle Applications R12/11i, OM, AR, AP, GL, INV, BOM, SC, Field Service HRMS.

Application Tools

Oracle Forms 6i/9i/10g, Reports 6i/9i/10g, XML Publisher 5.6.2/5.6.3, Work Flow Builder 2.6, JDeveloper10g/11g, OBIEE 11g, ADF11, SOA11g, Discoverer, Microsoft Office

Database Tools

TOAD, SQL* Loader, SQL* Plus, SQL* Developer, SQL * Navigator

Languages

SQL, PL/SQL, Java, C, C++

Web Technologies

HTML, XML, Web Services

RDBMS

Oracle 10g/11g/12c

Operating System

Windows NT/XP/2000/98, UNIX, Linux

Education

Bachelor of Engineering in Computer Science from Pune University (2004), India

Key Projects

Company: Infosys, Pleasanton, CA Aug 2019 – till now

Role: Solution Analyst - EBS

Responsibilities:

Work closely with the business user and partners to design and develop business requirements and enhance existing business processes.

Create key documentation for each phase of SDLC using Oracle's AIM methodology including business requirements, functional specifications, technical specifications, and testing documents.

Well versed with oracle configurator and defining rules for ATO items.

Development and customization of Procedures and Packages according to new Oracle standard tables in R12.

Requisition Details loading using SQL*Loader and PL/SQL. Developed validation routines to validate values for each requisition line.

Provide two tier support for Oracle Finance modules PO, AP, GL and provide assistance to all end users and identify any issues in production.

Maintain schedule jobs and perform troubleshoot on processes and resolve all issues (Oracle and unix jobs in finance module).

Participate and test production implementation.

Contribute to the research and resolution efforts during all Incidents.

Administer and implement new features and ensure transition of plans to production.

Document all production applications and resolve all application issues and answer all requests.

Monitor all performance metrics for various production systems for all technical issues and recommend solutions.

Maintain effective relationships with various system administrators and development teams (cross functional).

Participate in periodic meetings and maintain all applications for productions and plan appropriate various strategies, outages and upgrades.

Manage user account activations, setup, and deactivation.

Communicate with users, business partners on the status of requests and/or incidents.

Provide full operations support; identifies recurring issues and provides solution options to support teams.

Technical Environment: Oracle Applications EBS R12.1.3 modules (PO, AP, GL and iExpense), Oracle R12, Toad for Oracle 12.6.0, CAWA 11.3, Datastage, Unix, SOA.

Company: Subaru of America, Camden, NJ Aug 2018 – Aug 2019

Role: Lead Programmer Analyst - EBS

Subaru of America is one of the most trusted brands in the automobile industry. As a lead programmer analyst, was responsible for conceiving and executing critical projects, influencing departmental objectives and providing strong leadership and project management expertise. All solutions are targeted at leveraging the investment in our Oracle EBS platform.

Responsibilities:

Analyze current business process and define future business processes in Vehicles business in IT department. Work closely with the business user to design and develop business requirements and enhance existing business processes.

Create key documentation for each phase of SDLC using Oracle's AIM methodology including business requirements, functional specifications, technical specifications, and testing documents.

Worked on customization of OM Sales Order Workflow for different vehicle order type.

Performed the whole O2C in Order Management (OM), which includes Booking, Pick Release, Ship Confirming, and Interfacing to Receivables, Complete Line and Complete Order of a vehicle lifecycle.

Work on shipping modules to ensure cars delivery to dealers is accurate and in time.

Developed Sales Order conversion in Order Management (OM) to import Sales Orders from Legacy system using SQL * Loader.

Enhance application on ADF 11g, Java and JSF.

Developed Auto Invoice Interface API which imports invoices, credit memos and debit memos into Oracle Receivables (AR) module using SQL*Loader and PL/SQL validations.

Create reconciliation billing report to ensure cars price in OM and AR is matching.

Worked on design, development and deployment of projects like dealer accessory repository, File automations, automation scripts, enhancements of important custom business processes.

Trained in Oracle Fusion Middleware (BPEL) and Application Development Framework (ADF).

Application setup for concurrent programs and oracle forms.

Testing (Unit, Performance and integration) of all the objects.

Provide knowledge transitions to business users.

Technical Environment: Oracle Applications EBS R12.2.6 modules (OM, INV, IB, and BOM, AR), Oracle R12, SQL Navigator 6.5

Client: Cross Country Home Services, Sunrise, FL Oct 2014 – Dec 2016

Role: Oracle EBS Techno Functional Consultant

CCHS provides home services to its customers and connecting them with top service providers. Their commitment to partners and homeowners goes beyond warranties, providing budget protection from the unexpected, plus tools and information to proactively maintain the home.

Responsibilities:

Worked as techno functional consultant for EBS R12 CRM modules Services and Service Contracts.

Providing development estimations by analyzing the development objective and technical complexities involved.

Worked on design, development and deployment of service requests, service request assignments, deductibles calculations and service checks.

Developed complex API’s for assignment and reassignment of service partners to service requests, calculate and prorate deductible amount proportionately between claims, perform checks on claims etc.

Built claims business application using Pega Business Process Management Platform.

Used TCA API's for creating Parties, Party Accounts, Contacts, and Account Sites.

Developed PL/SQL Procedures to convert data in custom tables to service requests using Service (CS) APIs.

Development and enhancements of Warranty Work Order form.

Development of oracle reports using BI Publisher to send notification of Warranty Denial letter, Warranty Work Order and OwnerCo Instructions to customers.

Application setup for concurrent programs and oracle forms.

Testing (Unit, Performance and integration) of all the objects.

Creating Functional Design MD050, Technical Design MD070, Installation Document MD120 and Test Case Document TE040 for all objects.

Interacting with business and functional owners for requirement gathering, creating functional and technical design document, test case and installation documents.

Provide knowledge transitions to end users.

Technical Environment: Oracle Applications EBS R12 modules (CS, SC, IB, and AR), Oracle 11g, SQL developer

Client: FCO, Pune Aug 2012 – Sep 2014

Role: Team Lead

As a part of this assignment, I have worked on financial modules like Fixed Asset, Oracle Cash Management, General Ledger, Payables and Receivables.

Responsibilities:

Working as team lead on Order management system (OMS) application which is developed using oracle PL/SQL.

Responsible for requirement analysis, creating project plan and estimation, design and development and deployment of the application software.

Assigning project tasks to team members and testing the project deliverables to ensure the client standard are met and quality of the deliverables is excellent.

Involved in writing the SQL scripts using SQL analytical functions and aggregate functions on aggregate data like first purchase 6 months sales, discount, cost etc. Created PL/SQL Functions and procedures for distance calculations of the customers and prospects data.

Involved in creating PL/SQL procedures to load the data from data warehouse tables to oracle data mart tables.

Technical Environment: Oracle 10g, SQL, PL/SQL, Oracle SQL Developer, Oracle Report, SQL*LOADER.

Company: Deloitte

Client: Electronic Arts, Redwood City, CA Apr 2011 – Jan 2012

Role: Oracle EBS Techno Functional Consultant

This project was upgrade project in which there was need to convert static and transactional data from Oracle Apps 11i instance to R12. Being part of conversion development team, I was responsible for conversions of Item Routing, Item categories and Item Category Assignment.

Responsibilities:

Responsible for Analyzing, Designing, Development and Implementation of conversions in AR and INV applications.

Designed and implemented the plan for upgrade from 11.5.10.2 to 12.1.3.

Experienced in converting Item Routing using Routing Interface.

Experienced in converting Item Categories and Item Category Assignment using standard Item Category API’s.

Responsible for creating staging tables and loading the staging tables with the legacy data using SQL Loader and dblinks.

Responsible for creating CV040, CV060, MD120 documents for all above objects.

Developed the Shell Script Program to move the files between different Servers.

Responsible for unit testing and performance testing of above objects.

Responsible for training Users and designed training documents for users.

Technical support during production deployment and data migration across instances.

Technical Environment: Oracle Applications EBS 11.5.10.2, Oracle Application12.1.3, PL/SQL, Oracle 10g

Client: Lancashire County Council Mar 2010 – Mar 2011

Role: Oracle EBS Techno Functional Consultant

In this project, HR and Payroll data from the existing Midland Delphi HR and Payroll system is migrated to the new Oracle HR and Payroll system. As part of the development in new HR system, new reports, alerts and concurrent programs were developed in Oracle Applications 11i environment.

Responsibilities:

Lead the development team for Oracle Discoverer Reports.

Design and develop Discoverer Reports like Employee’s Absence Report, Qualification Details Report, and New Starters Reports in HRMS and Payroll system for Lancashire County Council.

Creating custom EUL, database folder and custom folders.

Creating database objects such as view and materialize views.

Design and develop the technical objects like extensions, oracle alerts, and concurrent programs for new HRMS system.

Develop concurrent program to create Element Links for payments using SQL Loader.

Application setup for concurrent programs and oracle forms.

Testing (Unit, Performance and integration) of all the objects.

Creating Functional Design MD050, Technical Design MD070, Installation Document MD120 and Test Case Document TE040 for all objects.

Data migration across instances.

Technical Environment: Oracle Applications EBS (11.5.9) HRMS, Oracle 10g, Discoverer 4i, SQL*Loader

Client: Activision Blizzard, Santa Monica, CA Nov 2009 – Feb 2010

Role: Oracle EBS Techno Functional Consultant

Project: Activision Blizzard

Client publishes interactive entertainment software products such as pure-play online and console games. The scope of the project was to Design and Implement the technical objects like extensions, oracle alerts, Fast Formulas, User Hooks and Concurrent Programs including development, documentation of (technical specifications, unit testing, integration testing), and production deployment in the Compensation Workbench module of Oracle HRMS.

Responsibilities:

Lead the efforts of development.

Design and Implement the technical objects like extensions, oracle alerts, Fast Formulas, User Hooks and Concurrent Programs including development.

Development of concurrent program for creating Special Information Type (SIT) Performance Rating in Compensation Workbench module (CWB) of HRMS.

Worked on Form enhancement by adding addition fields to SIT.

Development of concurrent program to upload the legacy data available in CSV file into Special Information Type (SIT) ‘Performance Rating’ in Compensation Workbench module (CWB) of HRMS.

Application setup for concurrent programs and oracle forms.

Testing (Unit, Performance and integration) of all the objects.

Creating Functional Design MD050, Technical Design MD070, Installation Document MD120 and Test Case Document TE040 for all objects.

Involved in knowledge transfers to offshore resources and helping them in solving the issues.

Technical Environment: Oracle Applications EBS (11.5.9) HRMS, Oracle 10g, SQL*Loader, PL/SQL developer

Client: BCI Inc., Brea, CA Sep 2008 – Oct 2009

Role: Oracle EBS Techno Functional Consultant

BCI implemented Oracle Transportation Management (OTM 6.1) in the North American distribution facilities and Oracle’s Warehouse Management in their two largest USA distribution centers. This project involved integration of WMS with the Pick to Light (PTL) and Warehouse Control Systems (WCS) and integration of OTM with a small parcel manifesting system for rating and manifesting.

Key Responsibilities:

Worked as an Integration consultant for EBS OTM Integration.

This project involved integration of WMS with the Pick to Light (PTL) and Warehouse Control Systems (WCS) and integration of OTM with a small parcel manifesting system for rating and manifesting.

Responsible for integration of WMS entities like Items, Deliveries and Locations from EBS 11.5.9 to OTM 6.1.

Development of PL/SQL procedures using collections.

Converted five years of historical data from EFRS system into OTM which allowed BCI to run historical reports out of Fusion Transportation Intelligence (FTI) and phase out EFRS reporting.

Create OBIEE reports and Run Reports using Fusion Transport Intelligence FTI in OTM Dashboard.

Application setup for concurrent programs and oracle forms.

Testing (Unit, Performance and integration) of all the objects.

Creating Functional Design MD050, Technical Design MD070, Installation Document MD120 and Test Case Document TE040 for all objects.

Technical Environment: Oracle Applications EBS (11.5.9) module INV, Oracle 10g, PL/SQL developer, OBIEE 10g

Client: Spartech St. Louis, MO Mar 2008 – Aug 2008

Role: Oracle EBS Consultant

This project specifically deals with mapping and design of conversions like Item, Item Categories, Item Catalogs, Formulas, Recipes, Purchase and Sales Orders.

Responsibilities:

Responsible for mapping and design of conversions like Item, Item Categories, Item Catalogs, Formulas, Recipes, Purchase and Sales Orders.

Developed complex Multi Batch form using TEMPLATE.fmb and customized existing forms in the OPM module according to the client’s requirements.

Played a key role in design and implementation of multi-batch and Batch Output functionality by customizing Multi Batch forms functionality.

Development extensions and concurrent programs in PL/SQL.

Development PL/SQL procedures using collections.

Application setup for concurrent programs and oracle forms.

Testing (Unit, Performance and integration) of all the objects.

Creating Functional Design MD050, Technical Design MD070, Installation Document MD120 and Test Case Document TE040 for all objects.

Involved in knowledge transfers to offshore resources and helping them in solving the issues.

Technical Environment: Oracle Applications EBS (11.5.10) modules (INV, OPM, OM), Sun OS 5.8, Oracle 10g, Forms 6i, PL/SQL, Toad

Company: Patni computer systems

Client: Motorola, Tempe, AZ Jun 2005 – Feb 2008

Role: Oracle Applications EBS Technical Consultant

Responsibilities:

Oracle E Business Suite Up gradation from 11.5.10.2 to 12.1.3

Modifications of Procedures and Packages according to new Oracle standard tables in R12.

Requisition Details loading using SQL*Loader and PL/SQL. Developed validation routines to validate values for each requisition line.

Developed CTL files for loading CSV files from shared drive to server using SQL * Loader into Staging Tables.

Developed packages to validate and to load data from staging table to tables. Then, using standard Item Import program to load Items into Inventory.

Developed the program to import invoices into receivables using AR Auto invoice program.

It also includes summarization of the Hardware and Software parts and generates an EDI report.

Read PO’s in EDI Format and create ATO and standard orders through standard order interface.

Creation of out bound EDI 810 format report for Consolidation and Summarization of invoices.

Application setup for concurrent programs and oracle forms.

Testing (Unit, Performance and integration) of all the objects.

Creating Functional Design MD050, Technical Design MD070, Installation Document MD120 and Test Case Document TE040 for all objects.

Technical Environment: Oracle Applications EBS 11.5.10.2/12.1.3 (AP, AR, PO, OM, INV), Oracle 11g PL/SQL, Oracle Forms 10g, UNIX.

Company: IIMV, Pune, India Dec 2004 – May 2005

Role: Software Developer

Responsibilities:

Requirement Analysis to build a system that helps to maintain the appropriate statistics that are required by the Octroi.

Requirement Analysis on developing DLL using VB .Net

To automate the day-to-day workflow of Octroi Nakas located in the PCMC premises.

Form Development using VB.Net.

Web Development using ASP.

Unit testing, performance testing and integration testing of the objects.

Technical Environment: Oracle 8i (PL/SQL), VB.Net

Contact this candidate