Sonu Sharma

Freelance Consultant & Operations Manager

Location:London, London, United Kingdom
Phone: 00447866126245
2 Skills
Dear Sir/Madam
I am currently working in capacity of Oracle Application Consultant - Customer Relation Management (CRM) Techno-Functional in IBM. I am responsible for handling all user queries and understanding there requirement and helping team to complete these requirement technical or functional.
I was associated with like IBM, Yamaha, NCR in last 5-6 years. I worked as ERP Techno –Functional Consultant in Financial Domain. When I was in Yamaha I joined as a fresher and with in nine month I was acting as senior member there due to my performance. I developed n number of reports for management and also part of implementation team in finical module.

In NCR I joined in finical and after review of my credentials I associated with one of the biggest project for NCR (CRM Migration of R12).

I have very good exposure and knowledge of ERP as well as CRM as Techno-Functional; Consultant. What ever assignment assigned to me I completed with full dedication and honesty.
In review of possible openings, I believe that my experience is in perfect line with current needs of the organization, I am confident that I possess these skills, which will help me to perform the job efficiently and effectively.
My goal is to transit my enthusiasm, creativity & experience into a position, where I continue to provide the strategic and tactical leadership critical to retaining valued customers of an organization.
Enclosed is my resume for your perusal.


Valid HSMP(UK Work Permit)
Mobile : 00447866126245
Address: House 613,Bath Road,Longford,West Drayton, Middlesex

? First class Engineering graduate.
? Around 6 years of Experience in Oracle applications (11i) as an Apps Consultant
? Worked on Financials Modules GL, AP, AR., CM, PO,INV,Commercial,OM.
? Worked on CRM Modules Sales, TeleServices, Scripting.
? One full life Cycle Implementation Experience .
? Extensive Experience in Reports, Forms, Conversion Programs & Interface Programs using SQL*Loader
? FSG (Financial Statement Generator) Reports
? OFA (Oracle Financial Analyzer) Reports
? OAF (oracle Application Framework) Personalization, New Development
? Support for Month end and Year end closing
? Support for Daily Tasks
? Exposure of R12(Tele services ,Financials)
? Basic Knowledge of Workflow

Technical Skills:
Operating Systems : MS-DOS, UNIX, MS-Windows 95/98/NT, 2K
Programming Languages : C, SQL, PL/SQL, C++
RDBMS : Oracle 8i / 9i,11g
Tools : Toad, SQL*Loader
GUI : Developer 2000 R6 / R6i / 9ids
ERP Package : Oracle Apps (Financials),CRM(Services) 11i ,R12

Experience Summary:
Company Designation Experience
YMInfotech Pvt Ltd Faridabad
Apps World consultancy
NCR Corporation India Pvt. Ltd
Filix Consulting Pvt.Ltd.
IBM India Pvt. Ltd Software Engineer
Software Engineer
Software Engineer
Team Lead
Senior Software Engineer Jul 05 – Sep-06
Oct-06 – Nov-06
Dec-06 – Apr-08
May-08 –Aug-09
Sep-09 – Nov-10

B.E Computer Science from Lingaya’s Institute of Management and Technology with 67% in 2004.

Projects Details:

Project 1:
Project Name : Bharti (Airtel)
Technology used : Oracle CRM

Role & Responsibility:
? Supporting Team for Technical Issues
? Customer Support for Functions issues in CRM Services, Sales
? Handling Major Workflow configurations for products
? Design Custom forms for Application
? Develop Interfaces for Importing Assignment & SLA data in application.

Project 2:
Project Name : Omaxe Financial Support
Technology used : Oracle Applications 11.5.10 (With Multi Org Concept)

Role & Responsibility :

? Customization of Forms: Customized three forms through personalization.
? Commercial Module: Support for custom(commercial) module ,developed forms and reports for this module and developed procedures and triggers. Module is attached with Property Manager in oracle apps.
? Financial Support: Support for AP,AR,GL,INV,PO and developed custom forms .
? Report Development : Developed report in XML format in all modules.
? Set Up : Creating New Operating units, Organization and AP,AR Roll out.
? Budget Setup
? Daily & Month Closing Support: Help for resolving daily and monthly closing.
? New Development for OAF: Developed new invoice Entry page in OAF

Project 3:
Project Name : FSD Manufacturing Cost Accounting Requirements.
Technology used : Oracle Applications 11.5.10 (With Multi Org Concept)

Role & Responsibility :
? Customization of Forms: Customized forms through costom.pll and reports
? Cost Data Migration Interface: As part of the migration from legacy systems to ERP, each plant’s cost item records will be extracted from legacy (3 extracts) and needs to be loaded into ERP.
? The proposed colour solution: If anything updates any of any colored or white primed part for any cost type (other than “Frozen”) than for that cost type find all items with the same exact first 7 characters and then update all cost, cost elements and flex fields to be the same exact values as the part that was updated for specific cost type.
Project 4:
Project Name : Implementation and support of Oracle Applications11i
Technology used : Oracle Applications 11.5.10 (With Multi Org Concept)

Role & Responsibility :
? Reports:Devlopment of Reports in AP and AR and applying multi_org Concept in reports and Interfaces
? GL and Budget Interface : Developed Interfaces and for GL and Budget.
? OFA and FSG Reports: Developing FSG(Financial Statement Generator) and OFA Reports in GL.EX: Profit and Loss, Balance Sheet etc.
? System Administrator Jobs:
• Modified and created new concurrent programs as well as executables files when reports were created.
• Register using AOL registering tables ,forms ,reports and pl/sql procedures ,functions and packages, Created executable using AOL in the developed environment
• Defining users and assigning responsibilities as user requirement
• Creating list of values, Enable DFF on form

Project 5:
Project Name : Migrations From 11.0.3 to 11i(11.5.9)
Technology used : Oracle Applications 11.5.9

Roles & Responsibility:
? Migration of Reports: Migration of Reports from 11.0.3 to 11i and Registered them in Apps with the help of API FND_PROGRAM.
? Migration of Vendor Master: Migration of Vendor from 11.0.3 to 11i with the help of DB_LINK. Written PL/SQL Procedure to load the vendor Master from 11.0.3 and validate the record before inserting into Base table PO_VENDORS.
? Migration of Vendor Site and Contacts Details: Migration of Vendor Site and Contacts after loading Vendor Master with the help of DB_LINK. Written PL/SQL Procedure to load and validate data before inserting into base tables PO_VENDOR_SITES_ALL, PO_VENDOR_CONTACTS as there is no interface and API provided by Oracle to load Vendors.
? Migration of Open Invoices: Migration of Open Invoices from 11.0.3 to 11i using Invoice Interface. After Validation we load data into Interface table AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE.
? UTL_FILE: Developed Outbound Interface to generate CSV Files with the help of UTL_FILE.
? Lockbox Interface: Created Receipts in AR Using Auto lockbox.
? Value set Creation: Creation of Value sets of Independent/Dependent/None and table type.
? Invoking Concurrent Programs in PL/SQL Programs
? Defined Executables and concurrent programs
? Registrations of tables for Custom Applications.
? Enable/Disable Flex Fields.

Development of Reports: Developed various reports in GL, AP, AR modules and registered them in Oracle Applications.
Forms Customization: Developed forms from TEMPLATE.fmb and registered them in oracle apps.
Customization of Forms through Custom. pll: Customized of Various Forms using Library Custom. pll. Customization like Enabling and Disabling Fields are done through Custom. pll.


Father’s Name : Sh. Ramesh Kumar Sharma
Date of Birth : 27-December-1982
Marital Status : Married
Passport No. : E6334914
Corresponding Add : House 613,Bath Road,Longford,West trayton,battlesex

Skills (2) Rating
Operations Management