Oracle EBS Consultant

*

Manas Prakash Gupta Email: *****************@*****.***

Oracle Apps Consultant Mobile : +1-651-***-****

PROFESSIONAL SUMMARY:

More than 7 years of experience as Techno-Functional in Oracle Applications 11i & R12.1.3 Financials(Sourcing,PO, AP, GL) & HCM(Core HRMS, Compensation workbench and basics of Payroll) and Inventory.

Over 3 years of leading, Mentoring, coordinating with teams in an Onsite-Offshore model.

Good Technical Development skills in developing PRICE Components of Oracle Applications E- Business Suite using SQL, PL/SQL.

Expertise in Developing Procedures, Packages, Triggers and Workflows.

Involved in Two Full Life Cycle Implementations of Oracle Applications R12, with hands on working experience on Reports including EiS Reports, Interfaces, Conversion.

Extensively worked through the phases of Software Development Life Cycle (SDLC): analysis, design, development, testing, implementation, enhancement and Maintenance.

Experience in writing Design documents, programming specifications, Unit Test Cases and System Test cases.

Extensively involved in Production Support (24x7) and fixing the problems.

Proficient in Prioritizing, Decision making, Problem solving, Time management, process improvement.

Strong technical background and excellent interpersonal skills with an ability to interact with individuals at all levels.

Self-motivated with an ability to work independently to meet operational deadlines in a demanding fast-paced environment.

Good intercommunication skills to work with all levels of management. EDUCATIONAL QUALIFICATIONS:

Bachelor Degree in Information Technology from Uttar Pradesh Technical University AWARDS AND CERTIFICATIONS

GEM OF THE QUARTER award for Q2’14 for innovation.

WOW OF THE MONTH award for developing a defect tracker tool and resolving critical production issues

1st OCA certification with 100% marks.

TECHNICAL SUMMARY:

ERP - Oracle EBS, Oracle Applications 11i/R12

Modules - INV, PO, AP, GL, Sourcing, Core HR, Compensation workbench and Basics of payroll, Advanced Benefits (OAB) and Self Service HR modules Database - Oracle 9i, 10g

Langages - SQL, PL/SQL

Tools & Utilities - TOAD, SQL Loader, Oracle Workflow Builder, WinSCP, UNIX Shell Script, Basic of Oracle Applications Framework (OAF), Oracle Forms, Oracle Reports GUI Tools - Reports 10g, Forms 10g

Reporting Tools - BI/XML Publisher, EiS Reports, RDF Reports Code Migration Tool - HP PPM

Ticket Tracking Tool - HP Service Centre, HPQC, Service Now Code Repository Tool - MKS integrity tool

2

Cognizant Technology Solutions (Consultant - ERP) [Sep’11 to Till Date] Project Type Implementation

Role Oracle Apps Technical Developer

Client Ingersoll Rand

Description Ingersoll Rand (NYSE:IR) advances the quality of life by creating comfortable, sustainable and efficient environments. Our people and our family of brands including Club Car®, Ingersoll Rand®, Thermo King® and Trane® work together to enhance the quality and comfort of air in homes and buildings; transport and protect food and perishables; and increase industrial productivity and efficiency. Period Jan’15 to Till Date

Responsibilities Coordinated with various stake holders to document Business and functional requirement

Responsible for creating technical design document to capture data mapping between legacy systems and Oracle

Interacted with clients and assess needs, identify key challenges and define project scope and deliverables.

Involved in conversion (data loading) related activities

Involved in Code changes and testing Oracle Stored Procedures, Functions and Packages.

Involved in Code review, Test results review and documentation. Project Type Support/Enhancement Project

Role Oracle Apps Technical Developer

Client TJX Companies

Description

The TJX Companies, Inc. is the leading off-price retailer of apparel and home fashions in the U.S. and worldwide, ranking No. 125 in the most recent Fortune 500 listings. With over $23 billion in revenues in 2011, more than 2,900 stores in six countries and over 168,000 Associates, we see ourselves as a global, off-price value retailer. Period Apr’12 to Dec’14

Responsibilities Managed team of 3 associates

Responsible for interacting with Business Users for gathering requirements and providing optimum solution.

Responsible for Development, maintenance and support (24X7) to achieved the highest level of customer (end user) acceptance and satisfaction within Service Level Agreements (SLA).

Involved in developing and testing Oracle Stored Procedures, Functions and Packages.

Innovated and managed the development and implementation of automatic file transfer process, reducing manual effort by 100% and reducing ticket counts by 25% which directly translates into cost and efficiency optimization for the project.

Involved in development of EiS Reports.

Involved in Code review, Test results review and documentation.

Involved in UAT and helped business users to test the solution before implementation.

Involved in fixing issues for Workflow and AME.

Involved in debugging of basics OAF issues.

PROFESSIONAL EXPERIENCE:

3

Project Type Implementation Project

Role Oracle Apps Technical Developer

Client Wyndham

Description Wyndham Worldwide is the holding company for Wyndham Hotels & Resorts, Group RCI and other lodging brands. It was spun off from Cendant Corporation in July 2006. Wyndham Hotel Group is the world's largest provider and franchiser of a diverse field of travel-related products and services for businesses and individual consumers, with brands in lodging franchising, vacation ownership, vacation rentals and vacation exchange.

Period Sep’11 to Feb’12

Responsibilities Involved in developing and testing Oracle Stored Procedures, Functions and Packages.

Pear review of the code/packages and documents developed and tested by the team to confirm with standards

Involved in development of XML reports.

Worked in form personalization and tuning of SQL queries.

Created unit test cases and performed unit testing.

Responsible for code migration from one instance to higher instances. Zensar Technologies Ltd. (Software Engineer) [Sep’08 to Aug’11] Project Type Implementation Project

Role Oracle Apps Technical Developer

Client Expedia

Description Expedia is an Internet-based travel website based in the US with localized sites for 21 countries. It books airline tickets, hotel reservations, car rentals, cruises, vacation packages and various attractions and services via the World Wide Web and telephone travel agents.

Period Apr'11 to Aug'11

Responsibilities Responsible for interacting with Business Users for gathering requirements and providing optimum solution.

Involved in developing and testing Oracle Stored Procedures, Functions and Packages.

Involved in development of XML reports.

Involved in Code Changes/review, Test results review.

Involved in tuning of SQL queries.

Involved in documentation like MD60, TE.050 and migration documents.

Responsible for code migration from one instance to higher instances. 4

Project Type Implementation Project

Role Oracle Apps Technical Developer

Client IFFCO

Description IFFCO is a United Arab Emirates based business house, which manufactures and markets a well-integrated range of mass-market consumer products. Their segments are: Food and Beverage, Personal Care and Cleaning, Packaging & Industrial Products and Logistics.

Period Jan'10 to Mar'11

Responsibilities Involved in developing and testing Oracle Stored Procedures, Functions, Packages and Reports.

Involved in Code Changes/review, Test results review.

Involved in tuning queries in Oracle SQL.

Involved in documentation like CV.060, MD.070, TE.050 and migration documents.

Responsible for code migration from one instance to higher instances.

Pear review of the code/packages and documents developed and tested by the team to confirm with standards

Project Type Support Project

Role Oracle Apps Technical Developer/Oracle Apps DBA Client Videojet

Description Videojet Technologies Inc. is considered to be a world-leading manufacturer of coding, printing and laser marking products, fluids, and accessories for the product identification industry. Videojet comes under Danaher Corporation. Period Nov’08 to Dec'09

Responsibility Involved in developing and testing Oracle Stored Procedures, Functions, Packages and Reports.

Involved in DBA activities like patching, database up-gradation (9.2.0.8 – 10.2.0.4) and (10.20.0.4 – 11.1.0.7).

Involved in pre-analysis of application up-gradation from 11.5.10.2 to 12.1.1.

Responsible for ADPATCH prerequisites analysis.

Pear review of the code/packages and documents developed and tested by the team to confirm with standards.

Prepared the test data and performed unit testing and system functional testing based on business requirements, technical specifications and/or product knowledge.

Thanks & Regards,

Manas Prakash

Contact this candidate