Objective

A qualified, trained and a seasoned IT Professional with Management qualification and having over 9 years of rich and insightful experience, involved in Management/Leadership of Projects for Product Development in Airline Industries domain, gaining extensive expertise in Software Development Life Cycle, Project Lifecycle Management as well as People Management

Experience Summary

• Technical and Functional Knowledge of Manufacturing, IProc, Purchasing, Inventory,BOM, Work in Process and MRP functions.
• Extensive Project Life Cycle Management experience through Business Function Study, Requirement Finalization, Project Scoping, Task Break down, Effort & Time Estimation, Resource Allocation, Scheduling, Risk Management and Execution Control Planning/Monitoring
• Equal expertise in Solution Customization Cycle involving Business Requirement Study & Problem Identification (AS IS); Business process mapping with product; Gap Analysis & Customization Finalization (TO BE); Change Management for Customization; Solution Implementation, UAT & Support
• Proficient in all phases of Software Development Life Cycle including Analysis & Study of Business Requirements, Technical & Functional Specifications, Data/Interface/Process Design, Module/Interface Development, Testing, Integration, Implementation along with Service Support
• Team Development & People Management through consensus building, promotion of positive environment, & teamwork spirit, competence development, providing vision & efficiency, issue resolution, motivation and mentoring
• Cohesive Team Player with Fast Learning Curve along with strong analytical, problem solving, innovation, planning, organizational, communication & interpersonal skills

Academics

Master of Science in Information Technology

Technical Skills

ERP:

Oracle Applications 11i/R12

Modules:

Iproc, Inventory, Bill of Materials, Purchase Order, Work In Process, Application Developer, System Administrator, Material Planning, Engineering, iStore

Frontend:

Developer 2000 (Forms & Reports 6i/9i), Visual Basic6.0

Case Tools

SQL*Plus, Toad, SQL*Loader

Operating Platforms:

Linux, Unix, Win 2000/XP/NT

DBMS/RDBMS:

Oracle 9i and oracle 8i

Languages:

C, C++, Java, PL/SQL

GUI:

Developer 2000 (Forms & Reports 6i/9i)

Work Experience

Project Experience Profile Project

Upgrade of Oracle Apps R12 (R12.1.3.)

Environment

Oracle Applications 11i - Inventory (INV), Accounts Payable (AR), Accounts Receivable (AP), Work In Process (WIP), Purchase Order (PO), Application Object Library (AOL), General Ledger, Toad, Pl/Sql, SQL*Plus

Role

Team Lead

Company

Confidential,

Client

Confidential,

Duration

Dec 2011 to Till date

Responsibility Lead a team of 10 resources in an On-site and Offshore. Worked closely with the users during the requirement gathering and design phases. Involved in the configuration of the Setup for Oracle Purchasing, Inventory and IProc Involved in the code review and performance tuning of the programs. Worked closely with offshore team (oracle) and lead them during the Development, Testing and Implementation phases of the project. Supporting the interfaces and customizations as the Support Coordinator.

• Interacting with Key users to understand current Business Processes
• Conducting workshops for R12 features
• Preparation of project plan, effort estimation, Risk Management Plan and develop detailed project plan for the activities.
• Involve Steering committee for anything out-of-scope and requires change request
• Ensure that all problems/ issues during upgrade are identified, tracked, reported, and resolved in a timely manner

Project Experience Profile Projects

• Support of Oracle Apps 11i (11.5.10)
• RUP 7 Upgrade
• Upgrade from 11.5.9 to 11.5.10
• Data Archival

Environment

Oracle Applications 11i - Inventory (INV), Order Management (OM), Accounts Payable (AR), Accounts Receivable (AP), Work In Process (WIP), Purchase Order (PO), Application Object Library (AOL), General Ledger, Toad, Pl/Sql, SQL*Plus

Role

Sr. Techno Functional Consultant

Company

Confidential,

Client

Confidential,

Duration

Dec 2007 – Till date

Responsibility

Oracle Consultant for Emirates Group IT (Emirates Airlines Information Technology
division), Dubai, United Arab Emirates since December 2007 to till date.

Associated with Emirates Group, IT division of Emirates group and was involved actively in the Implementation of Oracle Application system for Emirates airlines and also implemented Oracle E-business Suite to other external clients like SAFI Airline (Afghanistan)

The project involves implementation of major modules of Oracle Applications 11i, i.e., Inventory, Purchasing, iProcurement, Fixed Assets, Accounts Payable, Accounts Receivable, General Ledger Modules. On P&L (Procurement & Logistics) part, the Project involved a huge Customization Process, which includes Custom Modules like Uniform Stores, In-Flight Service (IFS), General Stores and Accommodation.

• Business requirements gathering and mapping it to the functional solution with oracle e-business suite.
• Familiar with functionality extensions to bridge gaps in requirements and product features.
• Liaise with oracle and business users for applying software updates and open technical assistance requests with oracle support and follow up to resolution.
• Data migration from legacy systems to oracle e-business suite.
• Upgrade Oracle E-Business Suite to the latest version.
• Technical and Functional assistance to the users.
• Involved in upgrade activities from ERP version 11.5.9 to 11.5.10
• Developing Custom.pll as per business requirements.
• Developing reports using Oracle discoverer and oracle reports tool.
• Coordinate with Oracle Support, DBAs, System Administrators and Business Users.
• Re-design, Develop, Implement & Support Bespoke Systems within Oracle APPS. ( Interfaces and Inquiries)
• Developing alerts as per emirates airlines business requirements.
• Actively involved in month end & yearend closing activities with business users.
• Technical Design, Solution design documentation, Testing and Promoting the requirements.
• Customizing & Supporting the Inventory, Purchasing, , I-proc modules and Creating Custom Modules
• Creating ad-hoc extract reports as per user requirement.

Was involved in various phases or ERP implementation like Business Scenarios Validation, System Mapping, Testing, and Support for NASA Project and SAFI Airline Project R 12.

• Interacted with business users to understand modifications to existing forms and designed MD.50 and MD.70 documents accordingly.
• Resolving tickets for workflow issues in Iprocurement Interacting with users and finding out the problems faced by them and resolving.
• Lot of intelligence reports like Top Supplier List, Purchasing activity by year, Supplier/Buyer performance, Spend Analysis by country/Year, Commodity wise spend, Price exception, Supplier liability reports have been developed using Business objects 6.0 to stream line the process of Procurement & Logistics and these reports have been really helpful for the senior management to analyze the business process.

Project Experience Profile Project

Implementation of Oracle Apps 11i (11.5.10)

Environment

Oracle Applications 11i - Inventory (INV), Order Management (OM), Accounts Payable (AR), Accounts Receivable (AP), Work In Process (WIP), Purchase Order (PO), Application Object Library (AOL), General Ledger, Toad, Pl/Sql, SQL*Plus

Role

Techno Functional Consultant

Company

Confidential,

Client

Confidential,

Duration

June 2007-Dec 2007

Responsibility

• Designed and developed returned material transactions between two organizations using Inter org transfer interface
• Developed daily Sales summary Interface
• Designed and developed returned sales summary interface using return material Authentications
• Preparation of technical documents
• Created new request group and attached to Custom responsibility

Project Experience Profile Project

Implementation of Oracle Apps 11i (11.5.10)

Environment

Oracle Applications 11i - Inventory (INV), Bills of Materials (BOM), Work In Process (WIP), Purchase Order (PO), Application Object Library (AOL), General Ledger, Toad, Pl/Sql, SQL*Plus

Role

Techno Functional Consultant

Company

Confidential,

Client

Confidential,

Duration

June 2006-June -2007

Responsibility

• Understanding the various types and functionality of Bill and Routing.
• Development of Bills of Material interface.
• Developed PL/SQL procedure to validate and move data to interface tables
• Customized the Purchase order print program report according to the user requirement
• Designed and developed ASN receipt Interface
• Excellent understanding of purchasing flow and ASN flow
• Registered the Purchase order print report in Oracle Applications.
• Registering forms and reports in front end
• Customized reports using XML Publisher
• Registering concurrent programs for custom procedure and Reports
• Defining Concurrent programs, Request Sets and Request Group.

Project Experience Profile Project

Implementation of Oracle Apps 11i (11.5.9)

Environment

Oracle Applications 11i - Inventory (INV), Bills of Materials (BOM), Order Management (OM), Application Object Library (AOL), Toad, Pl/Sql, SQL*Plus

Role

Technical Consultant

Company

Confidential,

Client

Confidential,

Duration

July 2005-May 2006

Responsibility

• Onhand Quantity conversion from legacy
• Customized Onhand Quantity Report
• Deliver the developed components to the Project Lead
• Code review for other team developed Components
• Day to day enhancements and maintenance of applications
• Enabling Account Alias for frequently used accounts
• Check interface errors and generate report for the user for validation
• Get feedback after user Testing for bug fixing
• Understanding the functionality of custom.pll

Project Experience Profile Project

Support of Oracle Apps 11i (11.5.8)

Environment

Oracle Applications 11i - Inventory (INV), Bills of Materials (BOM), Purchase Order (PO), Application Object Library (AOL), Toad, Pl/Sql, SQL*Plus

Role

Techno Functional Consultant

Company

Confidential,

Client

Confidential,

Duration

Jan 2005- June 2005

Responsibility

• Support for open item interface
• Registered & Maintaining concurrent programs and Request Set
• Check interface errors and generate report for the user for validation
• Created new request group and attached to Custom responsibility
• Form modifications and report development
• Developed item error correction form.
• Registered & Maintaining concurrent programs and Request Set
• Check interface errors and generate report for the user for validation

Project Experience Profile Project

Support of Oracle Apps 11i (11.5.8)

Environment

Oracle Applications 11i - Inventory (INV), Bills of Materials (BOM), Application Object Library (AOL), Toad, Pl/Sql, SQL*Plus

Role

Support Technical Analyst

Company

Confidential,

Client

Confidential,

Duration

May 2004 – Dec 2004

Responsibility

• Support for Po receipt interface.
• Customization of printed purchase order report.
• Registered as a concurrent program and attached to Request Set
• Check interface errors and generate report for the user for validation
• Get feedback after user Testing for bug fixing
• Has been involved in the report generation of on hand value with reference to the DFF field Miscellaneous Issue
• Created new request group and attached to Custom responsibility
• Form modifications and report development
• Follow up of Issue Tickets with respective users and proper closure after user testing
• Migrating code after unit testing and user acceptance testing in test instance

Project Experience Profile

Project

Academic Information Management Systems (AIMS)

Environment

Oracle 8i,Oracle 9i(PL/SQL)

Role

Developer

Company

Confidential,

Client

Confidential,

Duration

Sept 2003 - April 2004

Synopsis

This Project collects the data of overall academic student information. It can be accessed through Intranet ( University Campus) with the help of Oracle Forms Developer 6i and Oracle Reports Developer6i and also configure the Application Server with Database Server using Internet Information Services (IIS). By using this, calculate Grade Point Average System and Cumulative Grade

Point Average processing for more than 10,000 Students per year and also Arrear Processing done through PL/SQL (Cursors, Procedures).

Responsibility

• Designed and Developed Master Forms, Transaction Forms.
• Created Master Menu to call the Forms.
• Developed Reports based on University Requirement.
• Created Tables, Views, and constraints for all the related Modules.
• Wrote DB Procedure.