Objective:

To work in an environment that provides a challenging and rewarding career ensuring a high level of job satisfaction in the areas of ERP and Client/Server technologies.

Experience Summary:

• Having 8 years of total experience, five years of experience in oracle applications with expertise in full life cycles implementations, presently working as a Sr. Systems Analyst in Satyam Computer Services since June 2004.
• Involved in design, development, customization and support of various business applications using Oracle Applications 11i.
• Technical expertise in development tool like Oracle Developer 2000 Forms( 6i/5.0/4.5), Reports(6i/3.0)
• Extensively worked on PL/SQL Procedures, Packages, Functions, Triggers and other database objects using SQL and PL/SQL.
• Worked extensively on ERP Modules - AP, PA INV, OM modules.
• Hard working, excellent in handling the team, aggressive in acquiring new skills, very innovative in programming methodology, debugging skills and client interaction.

Conversant With:

Operating Systems : Windows 2000/NT 4.0/ 95 and UNIX
Languages : C, C++, PL/SQL
RDBMS : Oracle 8.0/8i/9i
ERP : Oracle Applications 11i (AP, PA,INV,OM)
GUI : Developer 2000(Forms 5.0/6i, Reports 3.0/6i)
Reporting Tools : Oracle Discoverer

Certifications:

• Oracle Certified Professional (OCP) 1Z0-001 (SQL & PL/SQL)
• Oracle Certified Professional (OCP) 1Z0-101 (Build Program Units)

Academic Studies:

• Master of Computer Applications (MCA)

Customer Appreciations:

Received IT Service Excellence award in Electronic Arts for the delivery excellence and SOX Compliance.

Experience Summary

Project 12#:

Oracle AMS /POR Transition May 08 – Till to date

Client : Confidential, USA
ERP : Oracle Applications 11i (11.5.9).
System Environment : ERP, Oracle8i, Developer2k
(Forms 6i & Reports 6i)
Role : Onsite Lead
Modules : AP, PO, INV, OM

Project Description:
Electronic Arts is the world\'s leading interactive entertainment software company. Company develops, publishes, and distributes interactive software worldwide for video game systems, cellular handsets and the Internet. Currently working as an onsite Lead to provide L3 production support to provide smooth working of EA business.

Contribution:

• Onsite day to day activities for issue resolutions, status reporting to client on issues.
• Monitoring and providing timely resolution of issues in compliance with SLAs.
• Ensuring the day to day activities adhering to SOX compliance.
• Requirements Gathering, Onsite and Offshore coordination for the smooth running of the engagement.
• Estimations, solution design, Code walk through and UAT support for enhancement requests.
• Preparation of Design documents (MD070/TE030) Test cases and run books.
• Working closely with EA IT team for implementing various business needs.
• Developed Custom module (Month End Reporting) to meet the reporting needs of the business for applying various discounts to EA customers using Forms/Reports/PLSQL.

Project 11#:

Agilent Strategene Project Jan’08 – Apr’08

Client : Confidential,-USA
ERP : Oracle Applications 11i (11.5.10).
Modules : OM,PO,INV
System Environment : ERP,Oracle8i, Developer 2k(Forms 6i & Reports 6i)
Team Size : 12
Role : Project Lead – Onsite/offshore
Project Description:

Agilent Technologies is on the leading edge of every major trend in communications and life sciences. The scope of the project is to restructure the functions by creating a common operating unit by de-scoping existing two operating unit and entities. Tax structures, Inventory Items, existing static entities like customers, sites, suppliers etc and dynamic entities (Purchase Orders , Sales Orders etc). Will be migrated under new operating unit.

• Requirements Gathering and co-ordination offshore with Team
• Status Meetings with Client.
• Code Walk through.
• Review of Technical Design documents.
• Preparation of run books for required entities to be migrated as per plan.
• Resolving of tickets (WITS) after the Conversion was done in test environments during MOC1, MOC2 and stabilization phases

Project 10#:

Thermodyn Implementation Jan’07 – Dec’07

Client : Confidential,Italy
ERP : Oracle Applications 11i (11.5.10).
Modules : PA,PO,INV
System Environment : ERP,Oracle8i, Developer/2k(Forms 6i & Reports 6i)
Team Size : 10
Role : Project Lead – Onsite/offshore

Project Description:
General Electric Oil & Gas, headquartered in Florence, Italy, is a leading provider of complete solutions for production and product handling for the Oil and Gas industry. The team has participated in third Phase of the multi-generational project with GE Oil and Gas and Thermodyn project teams. This third phase is specific to include the Thermodyn sub-business (operating unit) under the same Oracle 11i Financials, Projects and Purchasing platform.

• Requirements Gathering and co-ordination offshore with Team
• Status Meetings with Client
• Tracking and monitoring the project deliverables as per the plan
• Development of Custom Interfaces & Conversions in PO,PA Modules
• Code Walk through.
• Preparation of initial Technical Design Documents (MD070s).
• Review of Technical Design documents.

Project 9#:

Safaricom EPMS Implementation (EPMS) Sep’06 – Dec’06

Client : Confidential,Kenya
ERP : Oracle Applications 11i (11.5.10).
Modules : EPMS Suite, Bill of Quantities (BoQ) Bolt on
System Environment : Oracle8i, Developer/2000(Forms 6i & Reports 6i)
Team Size : 6
Role : Technical Lead – Onsite

Project Description:
Safaricom Limited is Kenya’s current leading Mobile Telephone Operator. Safaricom implemented Oracle EPMS suite to enhance their internal processes. Project scope encompasses Implementation of Oracle Enterprise Project Management Suite in 11.5.10, development and testing of around 50 plus custom components which include interfaces, reports, Bolt on (BoQ) module and implementation of Property manager and Cash Management.

• Integration of Cell Tracker DB with Oracle Apps
• Design and Development of Bill of Quantities(BoQ) bolt on module

(Database design, development of custom forms, reports and interfaces)

• Development of Custom Interfaces.
• Unit testing and integration testing

Project 8#:

Campaign Management Solution (Oracle CRM) Apr’06 – Aug’06

Client : Confidential,Bahrain
ERP : Oracle Applications 11i (11.5.9).
Modules : Tele Sales, Marketing
System Environment : Oracle9i, Developer/2000(Forms 6i & Reports 6i)
Team Size : 5
Role : Technical Lead – Onsite

Project Description:

MTC is the pioneer of mobile telecommunications in the Middle East and a major player on the African continent providing a comprehensive range of mobile, voice and data services. MTC’S Campaign Management solution, enabling business users in automating the collection call process where in the contact centre agents can have access to the collections information from the billing system for executing collection calls.

• Requirements Gathering
• Integration of CRM Data base with Billing Database
• Customization of standard forms, development of custom forms and reports
• Development of Custom Interfaces.
• Unit testing and integration testing

Project 7#:

Recurring Business Engagement (RBE) Jan’05 – Mar’06

Client : Confidential,USA
ERP : Oracle Applications 11i (11.5.5).
Modules : Inventory, OM, Planning
System Environment : Oracle8i, Developer/2000(Forms 6i & Reports 6i)
Team Size : 18
Organization : Satyam Computers

Project Description:

Agilent Technologies is on the leading edge of every major trend in communications and life sciences. From optical and wireless communications to disease discovery and drug development research. Agilent Technologies, Inc. delivers product and technology innovations that benefit millions of people around the world. RBE project is simulates likes a maintenance model of enhancement and customization of the existing System.

• Requirements Gathering and interaction with client.
• Development of Custom Interfaces using Concurrent Programs
• Development and customization of Forms, Reports
• Preparing MD070,TE30 documents
• Code walk through

Project 6#:

CISCO QTC MIGRATION Jun’04 - Dec’04

Client : Confidential,USA
ERP : Oracle Applications 11i (11.5.9),
System Environment : Oracle9i, Developer/2000(Forms 6i & Reports 6i)
Modules : AR, OM
Team Size : 220
Organization : Satyam Computers

Cisco Systems, Inc. is the world wide Leader in Networking. Cisco’s IP networking solutions are the foundation of the Internet and most corporate, education and governments around the world. The Cisco 11i QTC initiative is aimed to integrate and enhance Cisco\'s Enterprise Resource Planning (ERP) backbone to create a more agile business structure decrease total cost of ownership and improve customer satisfaction using Oracle 11i. The QTC business flow will integrate, enhance and streamline Cisco\'s Quoting, Ordering, Order Management, and Pricing.

• Developing and Upgrading of Packages, Procedures.
• Development & up gradation of Reports.
• Conversion of SQL Reports to Oracle Reports.
• Preparing AS-IS, Technical Design functional documents
• Writing Unit Test Cases, Unit Test Results docs.

Project 5#:

DYNEGY Jan’04 - Jun’04

Client : Confidential
System Environment : Oracle8i, Developer/2000(Forms 6i & Reports 6i)
Team Size : 23
Organization : Accenture India Pvt. Ltd

Description:
Dynegy Inc. provides electricity, natural gas and natural gas liquids to customers throughout the United States. Dynegy Inc. is mainly into Power Generation & trading. Dynegy\'s natural gas liquids business is engaged in the gathering and processing of natural gas and the fractionation, storage, transportation and marketing of natural gas liquids i.e. downstream to upstream. Nucleus is a product developed using Developer 2000 (Forms 6i and Reports 6i), and which is designed and developed to caterer the needs of Dynegy in trading of Gas and Power. This system has developed in a phased approach and will continue to evolve, which supports in Trading, scheduling, volume pricing of the Gas and Power trading business. This system also provides the generation of Invoices and reconciliation of invoices.

Contribution:

• Code Walk through.
• Involved in Product enhancements
• Developing and enhancement of Packages, Stored Procedures.
• Development and enhancement of Forms and Reports using Reports 6i
• Writing of Unit Test Cases and Involved in Unit testing, integration testing.

Project 4#:

Client : Confidential, (SSA)
System Environment : Oracle8i, Developer/2000(Forms 6i & Reports 6i)
Team Size : 13
Organization : Wipro Technologies

Description:
This systems supports the functionality to plan, manage and track high volumes of cargo and equipment as they are loaded or discharged to and from the vessel and received or released through the gates. It has up-to-the minute information available about the status and position of the cargo and equipment inside the terminal. This system has been designed and developed in a phased approach and will continue to evolve with additional functionality throughout its life. The initial and largest phase encompasses all the required functionality to manage and operate a multi-user container terminal, including: 1. Import Processing (including full integration with US Customs) 2. Export Processing 3. Gate Operations 4. Yard Operations 5. Customer Support
Contribution:

• Code Walk through and reviews.
• Development and enhancement of Forms and Reports
• Developing and enhancement of Packages, Stored Procedures.
• Involved in Unit testing, integration testing, Acceptance Testing.

Project 3#:

PHOENIX-OFF Dec’02 – Apr’03

Client : Confidential,UK
System Environment : Developer 2000 (Forms 6i & Reports 6i), Oracle 8i
Team Size : 12
Organization : Wipro Technologies

Description :
Stat oil ASA is an integrated oil and gas company with business operations in 25 countries. Statoil ASA is one of the world\'s largest net sellers of crude oil, and a substantial supplier of natural gas to Europe. The Contract & Billing module has developed as a part of SMS (Sales and Marketing System) system application. It will interact with the existing modules of SMS system to get the Company, Gas-Sites, Meters, and Readings. The Contract & Billing module will source the required information via the interfaces and calculate the charges as applicable. User will have the facility to create invoices from this module and transfer the same to SAP for accounting purposes using the existing mechanism within SMS system. The module provides the functionality of invoices and backup reports to be sent to the customer through email as attachments also.
Contribution: -

• Development and Modification of Forms and Reports
• Developing Stored Procedures.
• Involved in Unit testing, integration testing, and System Testing
• Writing of Lower Level Design Docs (LLD) and Unit Test Cases.

Project 2#:

Versatile Online Information for Citizen Empowerment (VOICE) Oct’01 - Nov’02

Duration : 13 months
Client : Confidential
System Environment : Developer 2000(Forms 6i & Reports 6i), Oracle 8i
Organization : CMC Limited
The objective of VOICE Project is to provide transparency in governance and provide good service for Citizens by placing public access terminals across the City. The whole project consists of 20 different modules, each indicating an activity of Municipal Corporation. I am involved in Development phase of such module namely.
Property Taxation Module (PTM) :

PTM is one of the major modules of VOICE project. One of the Main tax collected by NDMC is Property Tax .The PTM facilitates for capturing new property assessments, Capturing of Objections, Vacancy Remission, Handling Court Cases, raising demands and recording of Property tax collected and integration with Financial Accounting Module. The module takes care of generating Demand Notices periodically with the arrears if any included. Generation of Various Types of MIS reports (DCB) and Registers like ADR and CDR.
Contribution:

• Developed Forms & Reports of various types
• Writing of Stored Procedures and Packages
• Involved in Integration Testing
• Preparation of UTC, SDS documents

Project 1#:

Vijayawada Online Information CEnter (VOICE) Dec’00 - Oct’01

Client : Confidential
Team Size : 22
System Environment : Oracle 8.0, Developer 2000 (Forms 5.0 & Reports 3.0)
Organization : CMC Limited

The primary purpose of Vijayawada Online Information CEnter (VOICE) is to develop and maintain a community information network which provides open and free access to online information for the citizens of Vijayawada. The whole project consists of 9 different modules, each indicating an activity of Municipal Corporation. I am involved in Design & Development phase of such modules namely

• Revenue Taxation 2. Dangerous & Offensive Trades (D&O Trades)

Module #1: Revenue Taxation Module (RTM) :

RTM is one of the major modules of VOICE project. The various taxes Collected by Vijayawada Municipal Corporation are Property Tax, Water Tax, Sewerage Rents, Vacant Land Tax. The RTM facilitates for capturing new property assessments, new water connections, new sewerage connections, raising demands and recording of collected taxes. The module takes care of generating Demand Notices periodically with the arrears if any included.
Contribution:

• Development of Various types Forms and Reports
• Writing of Stored Procedures.
• Writing of Software Design Documents (SDS) ,User Manuals and Unit Test Cases (UTC)
• Involved in Unit testing, integration testing.
• Involved in System Maintenance and 24 x 7 supports.
• 2nd line support on call basis.