Experience of Development and Support of Oracle

Available
Serial No: 8939
Skills keywords: finance functional, oracle sql

Short Bio:

I have sound domain Business Accounting Experience and industry knowledge of Finance Functional for development of Accounting
Software and maintaining Business Accounting Transactions.

Experience of Development and Support Projects for top US,UK clients on Oracle core (SQL,PL/SQL) and Some of Oralce Apps components
like Forms and Reports,SQL Loder on extensive level, API,Workflow etc.

Past Experience of two Oracle EBS 11i (11.5.10) projects with D2K Forms and Reports 6i for development and Support.
Further interested to get into Oracle Apps project or any other Lead Roles.

Current location:  Maharashtra, India - View on map
Preferred Sector of Employment:  accounting and finance
Spoken languages: english, Hindi, marathi
Location I am interested in working: Anywhere

EXPERIENCE SUMMARY

• 9+ years in CMM level IT companies prior experience in Manufacturing and Trading Industry in EDP department.

• Transition, Release, Project and Delivery Management Experience in managing small to medium size teams for Development and Support Projects. Experience of Release, Incident, Stakeholder / Vendor Management and Environment Management.

• As a Lead Participated in Project Initiation Talks, Pre-Sales Support (Proposals, Estimations, Presentations to Client), Requirement Gathering, Due Diligence, Gap Analysis, Data Analytics for MIS, Resource Planning etc.

• Experience in handling onshore and offshore Interactions related to project work

• Worked with Recruitment as an Empanelled Technical Interviewer for laterals and fresher and SME for Team Assessment and Trainings.

• Technical skill sets includes Oracle core (SQL,PL/SQL), Oracle Apps Techno Functional Finance, Developer (Forms and Reports), SQL Loader, TOAD, DBA Activities, Software Testing, Data Analysis, Mapping, and Database Migration for Telecom ERP Softwares.

• Functional Experience of Finance Sub Ledger Accounting and Production Flow in Manufacturing Industry.

ACADEMICS

• Bachelor of Commerce Pune University 1990.

• ADCSSA (Adv. Diploma in Computer Software System Analysis and Applications) from BTE Bombay 1992-93 in First Rank.

WORK HISTORY

Duration Organization Designation Role

Jan 2013 – Till date Geeks Solutions Manager Project Management

July 2010 – Dec 2012 Accenture Mumbai Team Lead Project Management

Jan 2007 – Jul 2010 Tech Mahindra Mumbai Sr. Technical Associate Technical PM

Nov 2004 – Dec 2006 Reliance Infosolutions Pvt. Ltd. Mumbai Manager IT Technical Architect

Dec 2003 – Jun 2004 Crystal Solutions Pvt. Ltd. Mumbai BA Consultant Technical Architect

Jan 2001 – Dec 2003 Digilog Systems & Peripherals Pvt. Ltd. Executive EDP Systems Executive

Jan 1998 – Nov 2000 Apex Computer Academy Nashik Business Consultant Development & Training

ACHIEVEMENTS

• Awarded for achieving first rank in BTE’s Adv. Diploma in Computer Software System Analysis and Applications by Institute of Management Research and Technology Nashik in the year 1992-93.

• Appreciated by offering Celebrating Points for performance shown in Accenture for project CAMS cycle-6, Project CXL Reports (client CONOCO PHILIPS US) to complete the work satisfactorily and within a time frame, Participation given for Organizational IDC level and project level Interviews and SME Work for Oracle Capability.

• Worked in the OSS Applications Team as a Technical PM forced to implement Object Library and Attached Library Oracle D2K features which reduced the overall project development time and maintained uniformity in design.

• Delivered Oracle PL/SQL training for Reliance Infosolutions Jamnagar, TechMahindra and Accenture Mumbai.

COMPETENCY TECHNICAL AND GENERAL

Programming Environment Oracle, SQL, Pl/SQL, SQL Loader, TOAD Oracle Applications 10.7,11i C,Pro*C, Developer 2000 Forms & Reports, DBA activities, VB, .Net

Version Control VSS, AccuRev, Quality Center

Methodologies PMP

Industry / Domain Knowledge Mfg. Industry Finance, Production Planning, Telecom, Insurance, Energy, IT Training

TRAINING / WORKSHOPS PROGRAMMS ATTENDED

ITIL V3 Foundation, PMP (WIP) Oracle Financial Techno Functional (AR,AP,GL)

Oracle Workflow SAP FICO Boot Camp

WORK EXPERIENCE PROJECT DETAILS

01 Jan 2013 – At Present (10 Months) Geeks Solutions

Geeks Solutions is involved in Web Server Hosting and Maintenance for multiple clients.

As a senior person I am working on different lines to streamline the day to day operations and enhance the productivity using optimum resources, development of new projects by giving expert advice.

As a PM looking after setting up the Infrastructure for development team to develop required in house softwares (Attendance System, Payroll, CRM etc.)

Streamline the delivery management and issues related to Incident Management, Problem Management by updating / enhancing new changes, in the existing system for SLA obliged solution delivery to clients. Supervision of Daily Action Items and Completion / Pending logs. Responsibility Distribution etc.

23 Jul 2010 – Dec 2012 (30 Months) Accenture IDC Mumbai

 

Project – Oracle Capability (Oracle SME Peoplesoft) (01/08/2012 to 19/12/2013)

Role Team Leader for Oracle Sales Support Activities and SME activities.

Project Brief Managing Pre-Sales Support project calls and Logs, Participation in ADM Estimator preparation for new client bids, SME support for different Projects on loan basis etc.

Project – Wellington Equity US (13/02/2012 to 30/06/2012)

Role Team Leader for Transition and Production Support for Equity Module

Team Size 5

Environment Oracle 10g, Developer Reports 6i/11i, AccuRev, Quality Center

Project Brief Managing a team for 80% Production Support and 20% Development and enhancement of Migration of Oracle Reports 6i / 11i for Equity module. Transition taking from the client, Understanding client requirements, Estimation, Technical Design and Development, Creating Test Cases, Incident, Stakeholder and Project Management activities. Providing induction to new team members in the project on the business requirements, technology, architecture and the approach methodology of the project.

 

Project – CXL Reports Client CONOCO PHILIPS US (05/09/2011 to 31/12/2011)

Role Team Leader for Oracle Development Team

Team Size 10

Environment MS Windows, MS Office, Oracle 10g, Crystal Reports, Business Objects

Project Brief CXL (commodity) Reports development by managing a team for Oracle backend components development (Package, Procedure and Function) and development of Crystal Reports at front end. Understanding Client Requirements, Technical Design and Development, Reports Data Mapping, Creating Test Cases and EtoE Testing, Project Management activities like resource management / utilization, Creation of status reports etc.

Project – Agency PCS Client New York Life Insurance (14/06/2011 to 30/08/2011)

Role Team Leader for Oracle Development and Support

Team Size 10

Environment MS Windows, MS Office, Oracle 10g

Project Brief Development and Maintenance of the NYL system

Leading a team of Oracle technical support for Transition, Maintenance and Development work for NYL, Project Management activities, Calculation and Estimation of Problem Logs and Change Logs with the help of ADM Estimator.

Project – CAMS (15/09/2010 to 30/04/2010)

Role Team Leader Capability Support for Oracle, People soft, DM, IM, JDEdwd, Siebel

Team Size 10

Environment MS Windows, MS Office

Project Brief L2 Support in CAMS for timely completion of Capability Assessment work by providing Data Analytics and MIS Reporting with assertive communication with different top Management and Stake holder people like Capability Heads, Sr. Managers and Managers of different projects, CIO and infrastructure Team and end users. Leading a Location Specific Support team for generation of base data for different Statistical report, Data Analytics for MIS report.

03 Jan 2007 – Jul 2010 (40 Months) Tech Mahindra Ltd. Mumbai

Project – Andes User Account Management System Client BT (01/09/2009 Jun 2010)

Role Transition Lead

Team Size 5

Environment Oracle 10g, OID Server

Project Brief Transition taking from the client for the UAMS System, preparation of Transition Plan and Schedule, Change over study, Updating team knowledge base for project, Participation in daily calls, Preparation of questions/queries, Recording feedbacks, Completion and achievement of quality gates as per QM process and its documentation, Final sign off and project management activities etc.

Chairing various conference calls, to track project status and management reviews within the project. Requirement Gathering & Estimation, Identifying and managing project costs and budgets. Billability management of resources during project execution. Maintaining RUS & Metrics Data. Submit project metrics to Quality Management Group (QMG). Relationship Management with all stakeholders like CIO and Infrastructure management group for setting up servers to achieve desired sign offs in timely manner. Management of Performance, Reward and Recognition of Team etc.

Project – Barcelona ANI Oracle ERP Cognos Support Client BT (01/01/2009 to 15/05/2009)

Role Team Lead

Team Size 5

Environment Oracle ERP 11i

Project Brief Project of BT Account NI UK, aimed at migration of the current ERP system from 10.7 to 11i, designing SOW, Technical Specifications for development of Forms and Reports as per organizational requirement; Migrate old systems data in the new Oracle ERP application for the client BT Account NI. Understanding existing system and new change flow. Mapping old system data to new Oracle ERP tables. Modification of different Tables, API Procedures and Functions etc. development of GUI screens using Forms and Reports for new Oracle ERP system.

Project – SPAR Client BT (01/02/2008 to 31/10/2008)

Role Team Lead Data Migration

Team Size 15

Environment Windows NT, Oracle PL/SQL, BT ERP STAR system

Project Brief Designing Solution for Data Migration for Telecom ERP Software and providing Oracle technology support. Understanding BT’s Star System using available documents and give presentations to migrate data from different client Countries. Analysis of data mapping. Participation in a daily conference call with the client to seek required information, mails, and exchange of documents. Creating data mapping upload files for STAR system. Preparing different documents, presentations related to project management activities etc.

 

Project – Department B &PP TI (10/07/2007 to 25/01/2008)

Role Release Manager

Team Size 15

Environment Windows NT, Oracle 9i, Pl/SQL

Project Brief Incident and Release Management related to deployment of Oracle packages for the client BT as per version control in Application Support Group. Maintaing log of all Releases, Synchronization of Release Management team situated in different remote areas. Guiding team members in 2nd and 3rd line support to solve the issues, Problem Management and deliver the solutions within the SLA obligation. Project management activities etc.

Project – EMC Database Extender DBx Suite (14/2/2007 to 06/07/2007)

Role Team Leader

Team Size 5

Environment Oracle Applications 11i (11.5.10), Oracle9i, D2K Forms and Reports 6i

Project Brief EtiSalat, major telecom service provider in the Middle East in setting up BSCS Billing system for prepaid and postpaid mobile connections; Oracle e-business suite used for day to day business implementation, development of Oracle portal for the organizational home page in Oracle Applications 11i, Oracle 9i, Developer 2000(6i) and Unix environment. The typical Production database grows between 30% and 100% per year. Most of this data is inactive. Information lifecycle Management must archive the inactive data and at the same time must include the note of the access to archive data.

Development of one main Form module and different Reports using D2k 6i for showing the status of inactive data and active data as well as archive data and non-archive data. Responsibilities Study the functional documents. Installation and development of D2K Forms and Reports. Study of functional documents and preparation of the technical documents based on the feedback of the functional documents. Responsible for functional testing, integration testing. Maintenance of regular interaction with Business and End Users; development of customized reports, forms and interfaces.

04 Nov 2004 – 25 Dec 2006 ( 26 Months ) Reliance Infosolutions Pvt. Ltd. Mumbai

Project – Reliance Retail (Jan 01 – Dec 20 2006)

Role Technical Project Manager

Team Size 15

Environment Oracle Server on Windows NT, Oracle SQL/PL.SQL, Retalix, Tibco

Project Brief Testing of API created using Oracle Procedures, Functions and Packages Interacting with client and getting the work done from the Team. Development of Oracle Procedures, Functions and Packages to produce base tables by using different Reference tables, which will be used by dot net front-end development team finally for creating reports. PM activities, allocation of work for Testing and Development, preparation of schedule, meetings etc.

OSS Applications (Operation Support System) in Motech software Pvt. Ltd. Mumbai

Project – STP COF (Signal Transfer Protocol Change Order Form) (Jul 10 – Nov 30 2005)

Client Reliance Infocom, DAKC Mumbai

Role Team Leader

Team Size 12

Environment Oracle Server on Windows NT, Oracle SQL / PL.SQL / Developer 2000

Project Brief Client Interactions, Requirement Gathering, System Analysis, Development, Testing, Project Documentation (LLD, UTP, and User Manuals), Implementation and support. The purpose of the system is to load data from flat file into different Oracle Table and redisplaying it with Master Detail’s relationship to the end users with new functionality of Adding New Data, Modifying Data, and Deleting Data with color representation and complex validations for different IP’s. Setting up Oracle Server for offshore development team and DBA Activities.

Project – HLR (Home Location Register) (Mar 01 – May 31 2005)

Client Reliance Infocom, DAKC Mumbai

Role Team Leader

Team Size 12

Environment Oracle Server on Windows NT, Oracle SQL / PL.SQL / Developer 2000

Project Brief Understanding client requirements, System Analysis, Planning and allocation of work to team members with Support in development. The purpose of the system was to load data from different HLR system to Clarity System. Creating Forms and Reports to provide abstract view of the loaded data. The screen is Form like layout with Master-Detail feature for different IP’s. Maintaining latest version of history data for all tables. To view history data, separate screens and reports was provided with same functionality of main forms. Setting up Oracle Server for offshore development team and DBA Activities.

 

 

22 Dec 2003 – 30 Jun 2004 (6 Months) Crystal Solutions Pvt. Ltd. Mumbai

Project – Interconnect / ITU Tata InfoTech project for onsite support to VSNL

Client VSNL Dadar Mumbai

Role Consultant onsite client support

Team Size 10

Environment Windows, Oracle 8 SQL / PL.SQL / D2K Forms and Report 6i

Project Brief As per the client request providing support to Create, Maintain D2K Reports, Forms, Menus and SQL, PL/SQL coding for its intermediate objects like Base Tables, Views, Procedures and Functions. Data Management and Calculations, Presentation of Reports operator wise and Call wise (BSNL, MTNL, Reliance, AT&T etc.) for local and foreign calls.

VSNL is India’s well-known Government Telecom Organization providing services in telecom domain. Tata InfoTech providing support on various projects of VSNL. I worked in Interconnect / ITU project and got training related to this project and product Interconnect ITU Ver. 5.2, CDR processing, pricing, reconciliation, different call accounting process etc. In VSNL Switches record different calls and CDR (Call Detail Record) is prepared automatically SAP R-3 used for accounting Oracle 8 database is used for backend and D2K as a front-end tool.

01 Jan 2001 – 20 Dec 2003 (36 Months) Digilog Systems & Peripherals Pvt. Ltd. Nashik

Digilog is well known IT and Telecommunication products showroom in Nashik, dealing in manufacturing PLCs and Industrial Automation products. I have to look after IT development and Financial Accounting using Tally Accounting.

Project – ERP System for Production Inventory

Client Sparkle Diamond Pvt. Ltd. Seepz Mumbai

Role Consultant

Team Size 5

Environment Oracle Server on Windows NT, SQL / PL.SQL / Developer 2000

Project Brief Understanding the requirements from the Business owner, interacting with Department Heads/ Employees. Development Testing and Implementation of the system. Sparkle Diamond is 100% EOU in gold jewellery article manufacturing approximate turn over of 800 cores. The menu driven software is developed for jewelry manufacturing process and keeping track of material movement and loss inventory in various departments.

Project – ERP System for Service Department (Mar 03 – May 03)

Role Sr. Programmer / Analyst

Team Size 5

O. S. Windows NT, Oracle 8i SQL / PL.SQL / Developer 2000

Project Brief Understanding Service Department and Owners Requirements, System Analysis, Development, Testing and Implementation. The software was developed for total operations of service department. of electronic IT products for the brands like TVSE, Compaq ,Samson, LG etc. The software helps to keep track of products received for servicing / repairing within or after warranty period and produces quick track of product position status to engineers and customers, billing and accounting.

 

Project – ERP System for Orders Planning (Nov 02 – Dec 02)

Role Sr. Programmer / Analyst

Team Size 5

Environment Windows NT, Oracle 8i SQL / PL.SQL / Developer 2000

Project Brief Requirement Gathering, System Analysis, Development, Testing and Implementation. The software is used to process orders created by marketing team, show-room counter inquires, following-up the inquires, creating order list, delivery challan, supplying the material, credit limit to sub-dealers etc. and having good reporting features of orders planning list, delivery challan and debtors follow-up by applying several parameters like date, customer, Location, amount etc.

Project – ERP System for online billing and inventory (Feb 02 – Apr 02)

Role Sr. Programmer / Analyst

Team Size 3

Environment Windows 98 Oracle 7.3 SQL / PL.SQL / Developer 2000

Project Brief This software is used to maintain online billing, Stock Inventory, Reorder Level warnings and finding Debtors balances by creating follow-up lists, printing of bills, stock inventory accounting reports etc.

 

01 Apr 1995 – 25 Dec 2000 (35 Months) Apex Computer Academy Nashik

Apex was one of the leading computer training Institute involved in software-development in Nashik area. I worked as a Sr. Faculty for Oracle D2K and Software development assignments and Financial Accounting using Local Accounting Software.

Project – Payroll System (Jan 00 – Mar 00)

Client Digilog Peripherals Pvt. Ltd.

Role Programmer / Analyst

Team Size 3

Environment Windows NT, Oracle SQL / PL.SQL / D2K

Project Brief System Design Development, Testing Deployment and support to client Digilog is well known IT and Telecommunication products showroom in Nashik, also dealing in PLC’s and Industrial Automation. The system is developed for Payroll application it calculates the payroll for 35 employees

Project – Members Accounting Software (Oct 99 – Dec 99)

Client Apex Computer Academy, Nashik

Role Developer

Team Size 3

Environment Windows 98, Visual Basic 6, Oracle SQL, Access

Project Brief Understanding User Requirements and Designing the system. This software is useful for any Educational Institute / Placement Services / Clubs / Libraries etc to maintain members registration process, Member Accounting, Member Status, X-members details etc. Different Reports are designed to fulfil daily accounting needs.

 

Project – Indian Currency figures to character Converter Module (Sep 99)

Client Any Software Developing Firm

Role Developer

Development Tool Used C

Project Brief This Module prints Indian currency in exact character formats. This module can support to any application software in which currency printing is essential like Banks, Accounting systems, Billing / Purchase / Sales etc. With a minimal change this module can support to foreign currency printing styles also.

Project – Result Processing Software (Jan 1995 – Dec 1997)

Client Bhonsala Computer & Management Center

Role Co-coordinator

Project Brief Bhonsala Military School is well known military training school in the country to fulfill its results processing, Fully Menu Driven Software was developed in FoxPro 2.6. This system processes 5th to 12th standard 600 students’ results every year.

Bhonsala Computer and Management Centre is involved in training for CA foundation and main Exams as well as different computer courses. Apart from software developing work as a Co-coordinator I had to support end users on various application software’s like MS Office, Tally Accounting, Receipt and Payment, Bank Transactions, and other daily official work requirements and its fulfilment.

08 Oct 1993 – 10 May 1994 (8 Months) Siemens Ltd. Ambad Nashik

Project – PBIC System, Suggestion Scheme System, Job Card Printing System (Nov 93 to Jan 94)

Siemens Ltd. is well known MNC in electronic products; PLC’s and customized Automation Systems. As a part of Process and Planning in Logistics Department PBIC (Personnel Bonus Incentive Calculation) system was developed in FoxPro 2.6 for calculation of Incentive to workmen for completing the jobs within time schedule and without material loss. Suggestion Scheme is developed to keep track of suggestion data.

In the Process and Planning department apart from software development work I had to look after Production Process activities by using ERP system Prod-Star.

Keeping up the required documents ready for the production line as per the schedule of Process and Planning. It includes creating directory folders for drawings, process-sheet, part-list, creating Job Cards as per the product codes etc. Updating the Documents when amendment occurs in various stages on production shop floor.

1992-93 Project Undertaken as a part of A.D.C.S.S.A Course “Super Market Software”

Fully Menu Driven system in Foxpro2.5 was developed for the client Lucky Super Market, Nasik for Billing and Inventory purpose. Handles Purchase and Sales, Account Receivables, Accounts Payables and produces several reports like Daily, Monthly Sales, Salesman Commission, Stock positions Slow and Fast Moving Items, Reordering Level Alert etc.

 






popup-img