Sample Template Example of Excellent CV / Resume / Curriculum Vitae with Career Objective & Work Experience for MCA CV Freshers & Experienced Professional in Word / Doc / Pdf Format
SHOHAN AGRAWAL
9876543210 (cell)
SUMMARY
8+ years of total Oracle experience, including 6+years of extensive experience in Oracle Applications, as a Project manager, technical lead, quality analyst and developer in many implementations and customization project, on-site as well as offshore.
Worked in all phases of software development life cycle.
Have extensive experience in building extensions to Oracle Applications, implementations and support.
QUALIFICATION
·
Master of Computer Science and Applications. (MCA),
Aligarh
Muslim
University
(AMU),
India
1997
·
Bachelors in Science from
Agra University
,
India
1993
TECHNICAL SKILLS
Skills
Details
Hardware:
Pentium Server with Pentium nodes, IBM compatible PC/AT
Operating Systems:
SCO UNIX5.x, Window3.x/Windows95/98/2K, and Windows NT 4.0
Languages:
PL/SQL, SQL*Plus, Visual Basic, Unix Scripting
Tools
Developer2000 (Forms4.5 & Reports2.5), Developer 6i (Forms 6i & Report6i), Discoverer 3.0/3.1/3i, Designer 2000, SQL*Loader, Data loader Import, Export, Workflow builder, iStore, TOAD, SQL Navigator
Database:
Oracle7.x/8.x/8I
ERP
Oracle Applications 10.7 to 11i
WORK EXPERIENCE
Designation
Company
Duration
Senior Consultant
Polaris Software Lab Ltd., Gurgaon
India
Jan-05 – Till Date
Consultant
Polaris Software Pty Ltd., Sydney Australia
Nov03 – Dec-04
Consultant
Polaris Software Lab Ltd., Gurgaon
India
Feb02 – Oct 03
Associate Consultant
Polaris Software Lab Ltd.,
USA
Jun00 – Jan 02
Associate Consultant
Polaris Software Lab Ltd., Noida
India
Mar 99 -- May 00
System Analyst
TGK India Ltd.
New Delhi
India
Jan 97 – Feb 99
PROJECTS SUMMARY:
Sr. No.
Project
Client
Duration
Role
1
Oracle Application 11i Customizations and support (offshore)
Toshiba Australia Pty Ltd, Sydney Australia
Jan-05 – Till Date
Project Manager
2
Oracle application 11i implementation(11.5.9)
Toshiba Australia Pty Ltd, Sydney Australia
Nov-02 – Dec-04
Technical Lead
3
Oracle applications migration (10.7/11.0.0 to 11i )
GE Capital Services, Gurgaon
India
Apr-02-oct-02
Sr. technical Consultant
4
Oracle applications implementation(11i)
Winsome Textiles and Yarns –
India
Feb 02 -Mar-02
Technical Consultant
5
Customization in Oracle applications 11.0.3
New Vine Logistics,
Oakland
California
,
USA
July 01 – Jan 02
Technical Consultant
6
Customization/migration in Oracle applications 11.0.3/11i
JDS Uniphase
San Jose
California
,
USA
Jun 00 – Jun 01
Technical Consultant
7
Customizations in Oracle applications 10.7
GE Capital Services, Gurgaon
India
Jul 99 – May 00
Technical Consultant
8
Customizations in Oracle applications 10.7
Reuters,
Switzerland
Apr 99 – Jun 99
Offshore Technical Consultant
9
FERMS (Foreign exchange and risk management system)
Samtel Group of companies
Nov 98 – Mar 99
Team member
10
ISAP (Integrated System Application Package)
Samtel Group of companies
Jan 97 – Oct 98
Team member
PROJECT DETAILS:
A. Oracle Applications Projects
Project #01
Title
Oracle Applications Customization and support 11.5.9
Jan-05 –till date
Client
Toshiba Australia Pty Ltd, Sydney Australia
Role: Project Manager
Team Size: 5
This was the offshore development work on the Planning and Receivables modules.
We did the analysis phase on-site and developed the requirement in offshore and finally went on-site to deliver the planning module development.
My Role includes:
Responsible for managing the project at the highest level of customer satisfaction.
Involved in the Requirement analysis at on-site.
Tracking the project progress by project plan for the customization development.
Tasks allocation/tracking in the technical team.
Technical specifications writing for the various custom developments
Unit test plan writing for the testing of the customization.
Making Data conversion strategy
Assisting the technical team.
Environment
Oracle Applications11i,Forms 6i, Reports 6i, PL/SQL, Oracle v 8.x and SQL*Loader.
Project #02
Title
Oracle Applications Implementation 11.5.9
Nov-02 –Dec-04
Client
Toshiba Australia Pty Ltd, Sydney Australia
Role: Technical Lead
Team Size: 12
Toshiba Australia Pty Ltd is the large manufacturer of electronic goods like Laptop, PDA’s, Fax machines photocopiers and medical equipments. Our client was already having oracle application 10.7 implemented. We implemented the oracle applications 11i (11.5.9) using phase wise approached in four main phases for the five divisions of Toshiba.
My Role includes:
Responsible for the entire data conversion and custom developments in the project.
Managing the plan for the customization development in the project.
Tasks allocation/tracking in the technical team.
Technical specifications writing for the various custom developments
Unit test plan writing for the testing of the customization.
Making Data conversion strategy
Assisting the technical team.
This project involves implementation of various modules like OM, INV, PO,
WMS
,
AR
, AP, GL, TM CRM, MRP, ireceivables, iprocurement and HRMS modules
The technical development includes workflow, forms, interface, and reports, alerts, packages, procedures and functions customization. We use standard Interfaces for the data conversion from Oracle apps 10.7 for creating Items, Customers, sales orders, and purchase orders and receivables and inventory transactions in Oracle apps11i. API has been customized for the conversion of install base and service contract module.
Environment
Oracle Applications11i,Forms 6i, Reports 6i, PL/SQL, Oracle v 8.x and SQL*Loader.
Project #03
Title
Customization and Migration of Oracle Applications Rel. 10.7/11.0.0 to 11i
Apr-02– Oct 02
Client
GE Capital Services Integrated Business Solutions
Role: Sr. Technical Consultant
GE Capital services is financial institution operates in different financial operations. Initially they were having the Oracle application 10.7/11.0.3 implementation and were having the separate instances for the different business. Now they have decided to for the multi-org structure and one consolidated instance having different company, set of books for each business. This project consists of customization, consolidation and migration of reports and interface programs from Oracle Applications 10.7/11.0.3 to Oracle Applications 11i.
My role includes:
·
Interacting with users for business requirement analysis, design and enhancement of interfaces/reports after migration.
·
Migration/Customization of reports using Oracle Reports 2.5.
·
Re-Registration of Concurrent programs using AOL.
·
Wrote PL/SQL Script to extract and upload data
·
Performance Tuning of the Reports and other batch programs.
·
Wrote PL/SQL Batch processes for Data Conversions and interfaces.
·
Wrote technical Specifications based on given Functional Documents.
·
Ongoing Production supports to Oracle Users.
Interfaces
·
Auto invoice Interface Program to Load the invoice from the Web based billing system.
·
Interface to create the Oracle payables invoice for the car expenses of the employees.
·
Expense report interface Program to Load Lease rent data in Oracle Payables.
Environment
Oracle Applications11i, AP, AR, GL, FA, Forms 6i, Reports 6i, PL/SQL, Oracle v 8.x and SQL*Loader.
Project #04
Title
Implementation of Oracle Application 11i
Feb.02 – Apr 02
Client
Winsome Textiles and Yarns –
India
Role: Technical Consultant
Winsome Textile is a company primarily engaged in production of Textile Yarn and Textile Fabric. The company is based out of
Chandigarh
,
India
. The production is both for export and domestic market.
The objective of the project is to implement Oracle Process Manufacturing in different business functions of the company. The following business areas that were chosen were:
Financial Accounting, Procurement, Production, Planning, Formula Management, Qua