CONTACT INFORMATION:
View contact information...
In-pursuit of assignments in Software Development with an organisation of repute.
SYNOPSIS
ĉ A logically sound & stable professional with over 9+ years (Total IT) of extensive experience in Business Applications development, of which Oracle Application Financial (4+ Years) using various suite of Oracle products on UNIX and MS Windows 2K/XP/NT platforms with Technical/Functional Support in Oracle Applications 11i Financials Modules AP, AR, GL, CM, PO, INV, AOL, Oracle alerts, System administration and Manage the Oracle E-Business Suite using Oracle Applications Manager active involvement in complete life cycle of ERP Development and its implementation.
ĉ Currently associated with Suhail Bahwan Group (Holding) LLC, Sultanate of Oman as Sr. Analyst
ĉ Rich experience in covering project management, multiple development models, quality assurance and resource deployment.
ĉ Adroit at Custom Screens, custom Reports, Interface, Manage the Oracle E-Business Suite using Oracle Applications Manager, Technical Support in Oracle Applications 11i Financials Modules AP, AR, GL,CM, PO, INV, AOL, System administration, Oracle alerts and Manage the Oracle E-Business Suite using Oracle Applications Manager. Prepared technical design documents for customizations and conversions using AIM documentation methodology.
ƒâ Expertise in managing the complete SDLC; gained functional skills in analyzing the client requirements: translating new ideas into clients¡¦ solutions including requirements development, delivery, support & analysis and documentation.
ĉ Excellent project management capability, superior problem-solving, teamwork, and leadership ability. Astute planner/ leader with exemplary communication, relationship management, analytical and organizational skills.
AREAS OF EXPERTISE
Program / Project Co-ordination
* Case / system / Process Study. Project planning, scoping, estimation, tracking.
* Implementing project plans within pre-set budgets and deadlines.
* Delivery Management for technical deliverables of projects.
* Defining escalation / response / resolution time for reported problems on the basis of criticality.
* Team mentoring, deployment, monitoring and development.
* Very good knowledge of GL Setup, AP Setup, AR setup and CM
ORGANISATIONAL DETAILS
Since May¡¦03 working with Suhail Bahwan Group (Holding) LLC, Sultanate of Oman as Sr. Analyst (Technical)
The Company: It is one of the largest business houses is the leading information technology consulting, services providing Hardware, Software, Networking, Security and Enterprise Solutions to the customers in the Sultanate of Oman. The team comprises professionals with experience in providing Solutions to all kind of customer requirements. The group has diverse business interests spread over 35 manufacturing, trading, and service companies, representing more than 100 world-renowned brands.
Title #1: Manufacturing and Fabricating Units
Client: Bilad Oman LLC, Muscat
Team: 2
Environment: Oracle 9i, Forms 6i, Reports6i, SQL*PLUS, PL/SQL, TOAD, Oracle Apps 11i
Description
− This Project is developed as per Oracle Apps Standard and using Oracle apps Template Form, User Exits. Project deals with Marketing People take order and make quotation, creating job number and that job number makes many work order. WO for fabrication, WO cancel by Fabrication, WO for QA, WO cancel BY QA, WO Approval, finished Goods Receipt, finished Goods Issue to Customer, Finished goods cancel by Customer, Manufacturing EIS, Estimated Job Expense, Job Final Close
Role
− Designed and Developed new Forms/Reports (extensions) as per Oracle Apps Standards using APIs and Registering with the Application for OM Module
− Gather Information from User designed and developed screens and Reports for OM Module.
− Oracle developed custom reports and forms to meet functional business requirements
Title #2: Oracle application financial 11.5.9 (Technical) Bahwan EHA-WPI (Services)
Client: Bahwan Trading Company LLC, Muscat
Team: 2
Environment: Oracle 9i, Forms 6i, Reports6i, SQL*PLUS, PL/SQL, TOAD, Oracle Apps 11i
Description
− This Project is developed as per Oracle Apps Standard and using Oracle apps Template Form, User Exits. Project deals with Service Agreement, Service Job Entry, and Material Issue against job day-to-day, which Stores data and generate Job number.
− We can maintain service Job Invoice, Material Return against Job, Service Job Invoice Reversal, Excess Discount approval and various Reports for Pending for Completion of Jobs/Invoice.
Role
− Designed and Developed new Forms/Reports (extensions) as per Oracle Apps Standards using APIs and Registering with the Application for OE Module
− Customize Oracle standard reports, and develop custom reports and forms to meet functional business requirements
− Gather Information from User designed and developed screens and Reports for OM Module.
− Developed in creating Forms for the end users to check the details and errors, Gather Information from User: Service Agreement - Custapps, Service Job Card - CustApps, Approval service Job card, Material Issue against Job, Material return against Job, Service Job Invoice, Service Job invoice Reversal, Cash Purchase, Quick Invoice to Dealer, Quick Return from dealer with Auto MIT.
Title #3: Employee Attendance and labor Cost Maintenance
Client: Arabian Caravans Furnishing and Trading Company (ACFT) LLC, Muscat
Team: 2
Environment: Oracle 9i, Forms 6i, Reports6i, SQL*PLUS, PL/SQL, TOAD, Oracle Apps 11i
Role
− Designed and Developed new Forms/Reports (extensions) as per Oracle Apps Standards using APIs and Registering with the Application for OE Module.
− Customize Oracle standard reports, and develop custom reports and forms to meet functional business requirements
− Gather Information from User designed and developed screens and Reports for OE Module.
Description
− This Project is developed as per Oracle Apps Standard and using Oracle Apps Template Form, User Exits. Project deals with day-to-day Employee's Timesheet, which stores number of hours, worked for assigned task.
It gives Total labor cost for a particular job also keeps track of In house and Contractual Labor's Standard and Over Time Hours maintenance.
Title #4: Oracle application financial 11.5.9 (Technical) -Quick Invoice
Client: Bahwan Electronics LLC, Muscat
Team: 4
Environment: Oracle 9i, Forms 6i, Reports6i, SQL*PLUS, PL/SQL, TOAD, Oracle Apps 11i
Description
− This Module Helps the Organization to manage the Orders and perform the Logistics in an effective manner, for faster processing of orders, it was decided to develop a new user friendly customized module for enabling the Warehouses/show rooms to make quick invoices, for all the type of sales. User can enter Cash / Credit sales and print the same immediately.
− Once the quick invoice is generated, it is stored in the Customized tables of Quick Invoice Module and later on Interfaced to Inventory / receivable tables for further steps.
− Quick Invoice module is specifically developed for our Organization's requirement.
− To enable the showrooms / Warehouses to create and generate Cash / Credit Invoices promptly. This is not part of the standard modules of Oracle Applications. Quick Invoice has been integrated with Oracle Application modules.
− Hence, as a batch process, Quick Invoice Interface program scheduled thrice a day or on user request to run as and when required in order to bring the Quick Invoices to your Receivables and deplete the inventory from Oracle Inventory.
Role
− Gather Information from User designed and developed screens and Reports for Quick Invoice Module.
− Designed and Developed new Forms/Reports (extensions) as per Oracle Apps Standards using APIs and Registering with the Application for OE Module.
− Written script for Direct / Pending Delivery to Inventory Interface [This is for DD/Dispatch interface to inventory] and Quick Invoice to Inventory Interface [Inventory and AR Interface] This Program is Scheduled to run every night as a concurrent Request
− Involved in creating some Custom reports and Forms for the end users to check the details and errors, Gather Information from User: Enquiry, Quotation, Customer Order, Loading Slip, Quick Invoice, Stock reservation, Customer Order Cancellation - Cust Apps, Order Cancellation - Partial Dispatched, Requisition of Stock Requirement, Stock Requirement Cancel, Material Dispatch against, Dispatch Instruction, Material Receipt against Requirement, View - Reserved Orders, RMA - Order, Quick Return - New, Enter Quick Return - Without Reference, Enter Quick, Return - DRC, Quick Cash Refund to Customers, Quick Invoice Lot Serial Detail, Quick Invoice Overheads Default, User Access - Cust Apps
Title #5: Oracle Applications (Financials)
S/W Environment: Oracle Apps 11.5.10 AR Customer Interface, AR Auto invoice, TOAD
Client: Delta, Muscat
Description
− Analysis of current functioning of the existing modules in the legacy system and mapping to oracle system.
− Performed data mapping, conversion and validation of historical data
Title: Automatic Bank Transfer (GL)
Description
− This Customized Module is developed and registered under Oracle General Ledger, which caters the transfer of the required funds between different Bank Accounts across or within the Banks.
− Journal Vouchers are created using GL interface and imported automatically into GL Letter of fund transfers will be printed to transferor banks.
Title: Post Dated Cheques (GL)
Description
− This Module tracks correct information about Customer's outstanding balance as per Status of Post dated cheques like deposited, cleared or bounced. Entered Data is interfaced to Oracle Receivables using Auto Lock Box Interface.
− Worked on GL Interface and automatic Journal Import program.
Title: Custom Reference /Custom Permit Numbers Module
− It is used to assign a Custom Reference Number for many vehicles imported under a Bill of Lading Number, which is assigned during entering GRN.
− Different Custom Permit Number is assigned to each vehicle for a Custom Reference Number.
Title #6: Car Costing
Client Client: Al Jenaibi International Automobiles L.L.C, Muscat
Team Team Size: 2
Software tools Environment: Oracle 9i, Forms 6i, Reports6i, SQL*PLUS, PL/SQL, TOAD, Oracle Apps 11i
Description
− This project is developed to automate costing process of Vehicles imported which Takes Data from Oracle Application's Financial Modules viz. Oracle Payables, Oracle Purchasing, Inventory and General Ledger in the form of flat file and Upload into this System, which is required to track actual cost and overheads of a vehicle.
Role
− Designed and Developed new Forms/Reports (extensions) as per Oracle Apps Standards using APIs and Registering with the Application for PO Module.
− Gather Information from User designed and developed custom screens and Reports for PO Module.
− Various Customized Reports for PO module for different Organization
PREVIOUS ASSIGNMENTS
Aug¡¦01-Nov¡¦02 Badar Almulla & Brothers Co. W.L.L. KUWAIT as Programmer Analyst; handled project on Car Sales and Rental; involved as module leader analysis of existing system, gather information from user, designing and new developing forms and report as per client's request, new develop PLL, Menu, VA and Object Libraries
Dec¡¦99-Jul¡¦01 TATA CONSULTANCY SERVICES SEEPZ, MUMBAI as Software Engineer; handled projects for GE Capital Fleet Services, Migration of Garage System, Character Mode to GUI Mode & GE Silicones Web Enabling
May¡¦98-Nov¡¦99 I.B. Solutions, Mumbai as Software Engineer; handled projects including: Inventory Control System, Lufthansa German Airlines & Chemist Inventory Management System (CISM)
TRAININGS ATTENDED
- Quality Improvement program - Casual Analysis techniques 2 days From TCS
- Six Sigma Awareness 3 days From TCS - CMM Awareness 2 days From TCS
- SLA Training 1 day From TCS - Oracle 9i DBA from TCS
IT SKILLS
Process Manufacturing: Software Engineering Analysis, Design, Development, Testing, Implementation & Support
Operating Systems: MS-DOS 6.22, IBM Aix 5.2, Windows 2000/xp
Database: Oracle Database Server 7.x/8/8i/9i
Programming Languages: SQL*PLUS, PL/SQL, HTML, DHTML, Java-script
Principles: Multi-tier, Client/Server and Web based Applications 11i (ERP), RDBMS/ORDBMS Analysis
Utilities: SQL*PLUS, SQL*Loader, Explain Plan, TOAD
Development Tools: Developer 2000 (Forms 4.5/5.0/6i, Reports 2.5/3.0/6i) and Oracle web server 4.0.3.1
Oracle e-Business (ERP): Oracle Applications 11.0.3, Oracle Applications 11.5.10 Modules GL, AP, AR, CM, PO, INV, AOL, Oracle alert, Ad utility(Adadmin, adpatch, adctrl,
Adsplice) and System administration. JInitiator (1.1.8.16) on the PC Client, Database Server (9.0.2) on Aix 5.2.0.0 Server
ACADEMIA
* B.E (Electronics & Power Engineering) from Nagpur University (India) in 1994.
* P.G.D.B.M (MBA) (Marketing) from School of Management Sciences, Varanasi (India) in 1997.
* Oracle 9i Database Administrator Certified Professional (9i OCP DBA) Oracle Education-Oracle Corporation.
PERSONAL DETAILS
Date of Birth: December 4, 1972
Address: c/o Mr. S.K. Ranjan, INDIAN BANK OFFICER Quarters, Sector -8B
Near Gurudwara CBD Belapur, Navi Mumbai (MS) INDIA
Current: Suhail Bahwan Group Holding LLC, ISD, PO-169, PC-113, Muscat, Sultanate of Oman
Alt. E-Mail: 7diwakar@gmail.com
Driving License: Valid Gulf Driving License issued in Oman
Passport No: A-9001823
ANNEXURE-1
At Badar Almulla & Brothers Co. W.L.L. KUWAIT
Title: Car Sales and Rental Leasing
Client: In-House
Team: 3
Environment: Oracle 8.x, Developer 2000 (Forms 6 and Reports 6)
Role: Involved as module leader analysis of existing system, gather information from user, designing and new developing forms and report as per client's request, new develop PLL, Menu, VA and Object Libraries
Description
− Car Sales System is completely server based, real time system covering The whole functionality of the Car Sales System.
− The Car Sales System allows For integration across the Order Processing (Supplier) of the Company and Provides for interfaces to Rental, Leasing, and Financial Accounts.
− The various Car Sales System within a company to interact with each other as well as independently carry out all the Functionality.
− This Corporate System has all Information and operation mode required for a car rental & leasing business in Kuwait. Major modules are Booking of Cars, Opening/Closing of Rental Agreements, Tariff of Vehicle, Changeover of Vehicles, Vehicle Fleet Maintenance, driver Collections, and Invoicing and generate various MIS Reports For management.
At TATA CONSULTANCY SERVICES
Title: GE Capital Fleet Services
Client: GE Capital Services (Japan/USA)
Team: 7
Environment: Oracle 7.x, Developer 2000 (Forms 4.5, Reports 2.5)
Role: Analysis, designing, developing and implementing system
Description
− GE Capital Fleet Services is a worldwide Organization providing vehicle Leasing and fleet management services GECFS. With headquarters in Eden Prairie, Minnesota is one of the largest fleet management companies in the world with more than one million commercial cars and Trucks under lease and services management
Title: Migration of Garage System Character Mode to GUI Mode
Client: GE CORPORATE, Schenectady NY, USA
Team: 2
Software tools: Oracle 7.x, Developer 2000 (Forms 4.5, Reports 2.5)
Role
− As Team Leader analysis of existing system, converting character mode to GUI mode, developed Menu, PLL, VA for new application and successfully implement system
Description
− This Corporate System has all information & operation mode required For maintaining system, this was already developed using character Base oracle tools (Forms3.0 & Reports 1.1) and in distribution database Environment. Features Include Job Order, Auto parts, stock, Job card Preparation, Vehicle details, gate pass and generate various MIS reports for Management Converted the full system in GUI mode using oracle Tools.
Title: GE Silicones Web Enabling
Client: GE Plastics, Pittsfield, MA, U.S.A
Team: 8
Environment: Oracle 7.x, Developer 2000 (Forms 4.5, Reports 2.5)
Role
− As a team member analysis of existing system, designing table structure for new application develop in developer 2k (forms 4.5 and reports 2.5) and successfully implementing.
Description
− GE Silicones Web Enabling system will replace the existing eight Different MS Access client /server application with one consolidated Oracle database and web Enabled forms.
− The scope of work includes Design of Oracle database, design and coding of web enabled forms to Replace MS Access front-end forms, one time data migration from MS Access database to GESWE Oracle database and Building interface Between a GE Silicones data warehouse and the GESWE Oracle Database, which will run on a weekly/daily basis.
At I.B. Solutions, Mumbai
Title: Inventory Control System
Client: Blue chip Solutions Pvt. Ltd., India
Team Size: 3
Software tools: Oracle 7.x, Developer 2000 (Forms 4.5, Reports 2.5)
Responsibilities
− As Team member developed and implemented the following modules For the Inventory Control System package Purchase Order Module - Creating, View, Modify, Cancel, Close POs Vendor Maintenance Module - Create Vendors, Vendor Sites, Vendor Contacts Material Receiving Module Receive, Inspect, Approve Materials Inspection of goods Reports - Report on Goods Receipts and Inspection Comparative quotation statement generator.
Title: Lufthansa German Airlines
Client: Lufthansa German Airlines Mumbai
Team Size: 5
Environment: Oracle 7.x, Developer 2000 (Forms 4.5, Reports 2.5)
− As Team member Analysis, designed, developed and implemented different module as requirement of clients.
Title: Chemist Inventory Management System (CISM)
Client: Private Hospitals
Team: 4
Software tools: Oracle 7.x, Developer 2000 (Forms 4.5, Reports 2.5)
Responsibilities: As Team member Analysis, Design and implementation of different Requirement Including user Interface
Description
− CISM is a Windows based application. The application is divided into two Parts, Inventory and accounts of chemist's management System.
− It can maintain Records for many shops in different databases it includes maintenance of stock, Sales, purchase, sales return, purchase return, records of suppliers, doctors, Patient's accounts, Reports for balance sheets, receipts, profit & loss and other Account was prepared.
View contact information... |