MOHIT GUPTA
Mobile No- +91-989*******, Mail at - **********@*****.***
BACKGROUND/EXECUTVE SUMMARY
A result oriented professional with 3.6 years of experience in Oracle Apps
EBS Implementation, Enhancement, Rollout & Production Support in leading
Companies like [pic]PUNJ LLOYD LTD [pic] SAPIENT Gurgaon and
[pic]Mitsubishi Electric
PROFESSIONAL ACCOMPLISHMENT
> Experience in problem solving of Oracle application with expertise in
E-business suite 11i Procure to Pay cycle i.e SCM and Finance Modules
(Purchasing, Inventory, AP, GL, FA, India localization)
> Identifying Client's Pain areas in Business Processes Study and mapped
it to Oracle e-business suite using implementation methodologies like
AIMS
> Providing Post Implementation support to the client's entities in the
form of business process re-aligning & Application consulting.
> Involved in preparing the Business Requirement Documentation, Process
Mapping, Configuration Documents and Testing Documents.
> End to end full life cycle experience in oracle application E business
suite.
> Providing post Implementation support to the client's entities in the
form of Reconciliation A.P, INVENTORY, P.O with G.L.
> Involved in value added activities like assessment, data migration,
preparation of test scenarios and testing data validity
> Also worked on preparation of UAT scripts, user manuals and giving the
end user training.
> Relevant knowledge of Forms Personalization for making security rules.
> Have good knowledge of backend database tables concerning various
modules like PO, INV, AP, GL and their required dataflow.
NOTABLE ACHIEVEMENTS
> Implemented Procure to Pay Cycle (PO, INV, AP, GL) as per requirement
in established companies like PUNJ LLOYD LTD and SAPIENT
> Working knowledge of Oracle Configurations/setups for 11i E-Business
Suite functional module setups profile options, flex-fields,
functional module interfaces.
> Handling more than 1200 end users in various modules by solving their
day to day problems and providing solutions.
> Trained more than 280 professionals in both modules till date.
> Created process documents (like MD50, BR100) as per Oracle AIM
process for improving quality and reducing error.
> Helping in Audit by PO closing activity from time to time.
> Experience with gathering user requirements and understanding and
interpreting requirements specifications.
PROFESSIONAL HISTORY
Client Name : [pic]MITSUBISHI ELECTRIC
Employer Name : TI INFOTECH
Designation : Functional Consultant
Team size : 5 (FIVE)
Duration : 1 JUNE 2010 TO TILL DATE
Client Name : [pic] SAPIENT GURGAON
Employer Name : DATACORE TECHNOLOGIES
Designation : SENIOR SOFTWARE ENGINEER
Total Team Size : 14
Duration : 1 SEPT. 2009 TO MAY 2010
Company Name : [pic]PUNJ LLOYD LTD.
Designation : ASSISTANT ENGINEER
Duration : JUNE 2007 TO AUGUST 2009
JOB RESPONSIBILITIES
Key Result area Major Activities
Team Management . Ensures key track roles and responsibilities are defined for the
team
. Helps resolve issues and dependencies within the team
. Actively shares knowledge and lessons learned from project
experiences
. Mentors the team on the best techniques to debug and troubleshoot
design and implementation defects and issues
Planning and . Create mid level and low level plans for the team.
Tracking Track . Track the progress of modules using traceability matrix
Progress . Identifies & escalates issue that might delay the work.
. Report progress and issues to the Manager in a timely manner
. Works with team on the development of standards, processes and
procedures related to application security, upgrade management,
capacity planning, application deployment, performance monitoring.
Implementation of . Defining various setups for SCM & FINANCE Modules (PO, INV, AP,
various Modules GL)
.Defining various setups for the Purchasing module starting from
defining of Approval Groups & Position Hierarchies, Jobs, Purchasing
Control Options and Document and period closing process.
.Defining various setups for the Inventory module starting from
definition of Inventory organization, sub inventory, location, items
UOM's, item catalog, item attribute controls, and controlling &
planning of items and period closing process.
.Defining various implementation setups for Account Payables like
defining payment terms, PO matching tolerance, Payable options,
financial options, Localization Tax setups, defining banks,
supplier, intercompany accounting and period closing process.
.Defining various implementation setups for General Ledger like
defining chart of accounts, accounting flexfileds, flexfiled
structure, defining hierarchy, set of books, multicurrency,
conversion rates, Period closing process.
Post . Responsible for testing of workflow of various modules after
Implementation implementation
Support
.Get the UAT done from clients and get sign off from them within
given time frame.
.Period closing in Purchasing, Inventory, Account Payables, GL and
closing of old organizations by finally closing 3 way matched PO's
thus help in auditing procees.
. Solving the Technical & Functional Problems either consults with
Oracle Support or with my own efforts.
. Provides support for the production environment.
Client Interaction . Interacts with client (client senior developers and architects) to
& Management create technology specifications from business requirements across
various Oracle App. modules
. In some scenarios, collaborates with client developers to design,
build, test and deploy the module components and integrate with the
rest of the modules.
. Raises and drives to closure with the client any technical design
and implementation issues in various module
. Formulates strategies and methods in coordination with the
Architect to gather functional requirements and capture them in
standard notations like UAT, Test Scripts
PROJECTS UNDERTAKEN
Project details Project Details and job responsibilities
Implementation and . Studying the Enterprise, its Operations and basic business
Support for Leapfrog flow. Understanding Client's Business Processes and redesigning /
Release 3 (Pyramid optimizing them as per the desired functionality.
Retirement ) Project . Considering Client's Pain areas in Business Processes and
in SAPIENT mapping / customizing it to Enterprise applications suite using
implementation Methodologies like AIMS.
.Requirements gathering, functional gap analysis, Module setup,
test script generation, writing training guides, training end
users and production support.
. Preparation of Setups Document & Profile Options
. Data Migration from CRP instance to Production instance which
included Items transitions total, Supplier balance, Costumer
balance, Assets & Trial balance migration, various setups in
Inventory, Projects, A.P, A.R, Purchase & G.L.
. Implementing SCM & Finance Modules (PO, INV, AP, GL)
. Create MD 50, BR100 and other process documents
. To do various testing like pre post matching testing, sniff
testing, Regression testing UAT bugs and enhancements, Report
testing, Performance testing etc.
. Worked on 'Scope Change Order Track' i.e. to replace SCO
functionality of PYRAMID by Oracle APPS using various SCM and
Finance modules (PO, INV, AP, GL)
Implemented Oracle . Responsible for setup of various modules (PO, INV, AP,GL)
Apps 11i for
Sembawang .Defining set of books, purchasing, receiving and financial
Infrastructure India options, document control options
Pvt. Ltd.
(Duration: Aug 08 - . Defining position hierarchy, approval document limit,
Oct08 organization, location, sub inventory, shipping network, items
defining UOM, item catalog, item attribute controls, and
controlling & planning of items.
. Creating UAT (User acceptance Test) Scenarios, MD50, BR100
docs.
. Follow up with clients from time to time to know their changing
needs and let them know the feasibility of proposed solution.
. Deployment of proposed solution in system and get them approved
from clients.
. Testing inter modular Workflow
. Besides this I was project coordinator for this whole
implementation due to which I got exposure with clients and came
to know about their requirements and our compatibility with them
regarding various issues.
Implemented Oracle
Apps 11i for SIMON . Responsible for setup of various modules (PO, INV, AP,GL)
CARVES INDIA LTD (a
Pun Lloyd subsidiary) .Defining set of books, purchasing, receiving and financial
options, document control options
(Duration: Oct 07 - . Defining position hierarchy, approval document limit,
Dec07 03 months) organization, location, sub inventory, shipping network, items
defining UOM, item catalog, item attribute controls, and
controlling & planning of items.
. Creating UAT (User acceptance Test) Scenarios, MD50, BR100
docs.
. Follow up with clients from time to time to know their changing
needs and let them know the feasibility of proposed solution.
. Deployment of proposed solution in system and get them approved
from clients.
. Testing inter modular Workflow
COMPANY PROFILE
[pic] SAPIENT
Sapient is leading IT services firm that plans, designs, implements,
and manages information technology to improve business performance for
Global 2000 clients.
Sapient's integrated delivery centers are located across the United States
and in Canada, the United Kingdom, Germany, and India.
[pic]PUNJ LLOYD LTD.
Punj Lloyd Ltd. (PLL) is a Global E.P.C.(Engineering, Procurement and
Construction) Company with turnover of 12000 crore this year working in
diversified sectors viz. Cross Country Pipelines, Refineries, Tankages,
Petrochemicals, and Heavy Industrial Civil Engg. & Construction, Water
Treatment Plants, Highways, Road Over Bridges, Telecommunication and
Infrastructural Projects.
It is spread across the Middle East, the Caspian, the Asia Pacific, Africa
and South Asia, Kazakhstan and Indonesia, and has 12 project and marketing
offices, including in the United Kingdom, Libya and Saudi Arabia.
Academic qualification
. Graduation in Mathematics from Christian Degree College.
. Currently doing MBA - IT from MDU
. DOEACC "O" Level from UPTEC
. Intermediate with P.C.M. from C.M.S. with 76%
. High school with P.C.M. from C.M.S. with 75%
TECHNICAL SKILLS
PROGRAMMING LANGUAGES C++, SQL, HTML
OPERATING SYSTEMS WIN XP, WIN98, WIN2000, MS -DOS
DATABASE ORACLE 7i & 8i
AUTOMATION TOOL QTP, SCIMITAR
OTHER ACTIVITIES:
> 75 PERCENTILE IN NIIT NATIONAL IT COMPETETION
> ESCORT IN QUANTA 2001(INTERNATIONAL EVENT)
> 75 PERCENTILE IN KABIR PEACE MISSION EXAMINATION.
PERSONAL PARTICULARS
DATE OF BIRTH : 18 MARCH 1984
FATHER'S NAME : MR. MAHESH CHANDRA GUPTA
CURRENT ADDRESS : 333/16, FRIENDS COLONY, SECTOR 15,
GURGAON
HOBBIES : SWIMMING, COMPUTER GAMES,
CHESS, BADMINTON
PLACE: GURGAON[pic]