format of professional cv

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, Quality, Inventory and Dispatch. HR and Payroll activities were excluded from the scope of the project.
• The following modules of Oracle Applications were selected to handle the functions of the selected business areas:

-         Oracle Process Manufacturing Financials: General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, and Cash Management.

-         Oracle Process Manufacturing: Purchase, Inventory, Order Entry, Formula Management, Material Resource Planning (MRP), Production, Cost Management and Quality Control (Q/C).

My role includes:

·         To prepare the data conversion templates for various modules.

·         To prepare the user manuals for various modules.

·         Identify the areas of customizations needed for effective and smooth implementation of the Modules. Customization of Reports, Testing, Integration and Documentation.

Environment

Windows NT, Oracle 8i, Oracle Process Manufacturing, Oracle Financials and Oracle Logistics R11i, PL/SQL, and Developer 2000 (Forms 6i & Reports 6i)

Project #05

Title	Development and customization of Forms/Reports for Oracle Application Rel. 11.0.3	July 01 – Jan 02
Client	New Vine Logistics, Oakland California, USA

Role: Technical Consultant

This client was in Wine selling business. Client used to get orders for wine from different sources (web sites like Amazom.com, E-bay etc.) Now the client’s main work was to process the orders by asking the availability of Wine from different Wine Vendors like Robert Mandavi and others.

And then they used to sell the wine to different sources in multiple states, including others entity like Wholesaler, Retailer of Wine, and finally to consumer.  They were using the oracle application 11.0.3 and their customized systems as well. Customized system was used for order pre-processing and cash dispersement between the various entities involved in the business.

I was involved there in Designing/developing of the Customized system for Cash dispersement.

My role includes:

·         Interacting with users for business requirement analysis, design and enhancement of reports.

·         Develop the forms for lookup and transaction data entry by using Forms4.5

·         Design and develop a package for cash distribution between various entities involved.

·         Analyzed & customized various reports using Reports 2.5/Forms 4.5

·         Performance tuning of the custom reports and other batch programs.

·         Registration of Concurrent programs using AOL.

·         Wrote PL/SQL Script to extract and upload data

·         On-going user support, application troubleshooting

·         Wrote PL/SQL Batch processes for Data Conversions and interfaces.

·         Wrote technical Specifications based on given Functional Documents.

Environment

Oracle Applications 11.0.3 OE, INV, AP, GL, AR, PO Forms 4.5, Reports 2.5, PL/SQL, Oracle v 8.x, and SQL*Loader.

Project #06

Title	Customization in oracle application 11.0.3/11I	Jun 00 – Jun 01
Client	JDS Uniphase San Jose California, USA

Role: Technical Consultant

This project involves customization, implementation of Supply Chain Planning, BOM, WIP, INV, OE reports Workflow notifications, iStore for Oracle Applications 11.0.3/11i and later migration of all the custom reports to JDS Uniphase instance after merger on ETK Dynamics and JDS Uniphase.  JDSU is using Oracle CRM (iStore) to give the facility to their customer to view about order/quotes data.

I was involved in developing this solution using Oracle 11I tool iStudio for mapping between 11.0.3 / 11i tables.

My role includes:

·         Interacting with users for business requirement analysis, design and enhancement of reports.

·         Develop the Horizontal Plan report (Planners workbench to see supply/Demand after MRP/MPS run)

·         Designed and developed the Forecast Upload program to load the forecast from flat file to Oracle Apps.

·         Customized the Requisition workflow notifications

·         Analyzed & customized various reports using Reports 2.5/Forms 4.5 for Oracle manufacturing and Financials Applications

·         Performance tuning of the custom reports and other batch programs.

·         Registration of Concurrent programs using AOL.

·         Wrote PL/SQL Script to extract and upload data

·         On-going user support, application troubleshooting in modules like Supply Chain Module, BOM, WIP, OE, INV, AR, GL)

·         Wrote PL/SQL Batch processes for Data Conversions and interfaces.

·         Wrote technical Specifications based on given Functional Documents.

·         Wrote SQL Script to create a data file for Data Extraction

Environment

Oracle Applications 11.0.3/11i NCA, SCP, MRP, BOM, WIP, OE, INV, PO, GL, AR, Forms 4.5, Reports 2.5, PL/SQL, Oracle v 8.x, and SQL*Loader.

Project #07

Title	Customization and Migration of Oracle Applications Rel. 10.7 to 11.03	Aug.99 – May 00
Client	GE Capital Services Integrated Business Solutions

Role: Technical Consultant

GE Capital services is financial institution operates in different financial operations. Initially they were having the Oracle application 10.7 NCA implementation. This project consists of customization and migration of reports and interface programs from Oracle Applications 10.7 to Oracle Applications 11.0.3.

My role includes:

·         Interacting with users for business requirement analysis, design and enhancement of reports after migration.

·         Migration/Customization of reports using Oracle Reports 2.5.

·         Re-Registration of Concurrent programs using AOL.

·         Develop Year-end consolidation program.

·         Develop lease rent interface program.

·         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.

·         Wrote SQL Script to create a data file for Data Extraction

·         Ongoing Production supports to Oracle Users.

·         Some customized reports were Customer outstanding report, Transaction register, Order shipped report

Interfaces

Interface Program to Load the Credit Card statement Data from Other System to Oracle payables Interface Tables to generate the Invoices in Payables, Interface Program to Load Lease rent data in Oracle Payables.

Environment

Oracle Applications 10.7 SC, 11.0.3 NCA, AP, AR, GL, OE, Oracle Alerts, Forms 4.5, Reports 2.5, PL/SQL, Oracle v 8.xand SQL*Loader

Project #08

Title	Off Shore development of Forms/Reports Oracle Applications Rel. 10.7	Apr. 99 – Jul. 99
Client	Reuters, Switzerland

Role: Technical Consultant

The project scoping and development of Forms using Standard template were done onsite. This Form defines the technical components required to implement Revenue Interface Mapping Screen. This screen allows user to enter or change the mapping used by the revenue interface.

The off shore development of reports and forms were done at offshore development lab at Noida, India which included leading the team for development and customisation of forms and reports for the client in Switzerland.

My role includes

·         Development of forms and reports onsite

·         Leading the offshore development team

·         Managing deliverables on time

Environment

Oracle Applications 10.7 SC, 11.0.3 NCA, AP, AR, GL, OE, Oracle Alerts, Forms 4.5, Reports 2.5, PL/SQL, Oracle v 8.xand SQL*Loaded

B. Other Projects

Project #09

Title	FERMS (Foreign exchange and risk management system)	Nov. 98 – Mar. 99
Client	Samtel Corporate office Defense Colony

Role: Team Leader

Foreign exchange and risk management system monitors exposures and Forward cover for achieving complete control of companies risk involved in foreign currencies.

It has following functionality

·         Capture daily exchange rates of different currencies from Reuters Screen

·         Maintain Exposures data given by Units of Samtel group.

·         Automatic calculation of Benchmark rate against. Exposures

·         Maintain data of booked/cancel forward cover with different bank and for different currencies

·         Calculate P/L on Booking/cancellation of forward covers to measure the Risk involved while dealing in foreign currency.

·         Various graphical reports required by management to see the trend of Forex market

My role includes:

·         To Analysis, Design the system

·         Wrote technical Specifications based on given Functional Documents.

·         Development, testing of Forms, reports, Graphs in the system using forms4.5/Reports2.5

·         Wrote SQL Script to create a data file for Data Extraction

·         Loading of daily Exchange rate Data through SQL Loader

·         To take Backups through Export Utility.

·         To do Documentation of user manual and Final analysis reports.

Environment

Oracle 7.3, Developer 2000, Designer 2000, HP UNIX and Windows 95

Project #10

Title	ISAP (Integrated System Application Package)	Jan. 97 – Oct. 98
Client	Samtel Group of Companies

Role: Team member/Team Leader

ISAP has designed and developed on the lines of ERP to facilitate in different operations for the Samtel Group of Companies. It has the following three Modules:

Materials Management System

·         It has the various functionality i.e. MRP, Bill of material, Enquiry and vendor development, indent system, Auto PO, Copy PO, Receipt Entry through Material Inward Note, Goods Return Back Certificate, Returnable Gate Pass, Keep track of dept wise Issue of material, Material consumption report department wise, item wise and various report required for management.

Financial Accounting System

• It integrates with other module of ISAP. It includes all types of ledgers like General ledger, sub ledger, voucher generation, books like Cash book, Bank book, Sales book, purchase book, Trial balances, Balance sheet Profit & loss A/c, s Reconciliation of Bank entries against Bank statements, interest calculation, control of bank limits etc.
• Pass the supplier bills against various purchases, making payment and keeps the track of payment on due date, Printing cheque etc.
• Pass the supplier bills against Import purchase, it is linked with the consignments monitoring system, by which we keeps a track of various documents like Commercial invoice, bill of entry, CHA bill, freight bill and making payments against these bills.
• Generating different kind of work orders for job processing release by the company for contractors and making payment against those.
• Calculate the inventory value at the end of each month by using weighted average rate technique.
• L.C.'s generated for various Import purchase & sales & Overhead budget monitoring.
• Check the expense against budgeted expenses assigned to each Cost-Centre monthly/ annually

Sales and Marketing System

• Customer Registration and Order Entry
• Sales Invoice generation, Invoice Printing and Sales Voucher Posting into financial system
• Debit/Credit Advice preparation and Debit/Credit Note generation
• Sales Analysis Report, Daily Stock position Report, Customer Outstanding Report
• Maintain different Excise registers i.e. RG23 Part1, Part 2 RG23 C Etc.

My role includes:

·         Involved in Development of Forms and reports using forms4.5/Reports2.5 for Financial Accounting module.

·         Involved in the Implementation of ISAP at 4 different sites of Samtel Group

·         Involved in Creation of Stored Procedures, Database Triggers, Sequences, Indexes, Views, Temporary Tables.

·         Customizing forms and reports according to client's need

·         Wrote SQL Script to create a data file for Data Extraction

·         Loading of Data through SQL Loader. Backups through Export Utility

·         Ongoing Production supports to Oracle Users.

Environment

Oracle 7.3, Developer 2000, Designer 2000, SQL*Loader, SCO UNIX and Windows 95

Download Resume Format