SUMMARY

Insightful, results-driven IT professional with more than 14 years of Software Development experience, around 8 years of Oracle Applications Technical experience in implementation, customization and support of various modules of CRM/Manufacturing/Financial. Hands-on work experience in a global client environment, with through knowledge and experience of systems analysis, full life cycle of soft ware project management, leading all stages of system development efforts, including requirements definitions, architecture, design, testing, and support of ERP product analysis, and implementation of solutions in support of business objectives. Outstanding Technical and Programming skills, project and program leader; able to coordinate and direct all phases of project-based efforts while managing motivating, guiding and supporting teams.

Areas of Expertise:

• Oracle Applications Techno Functional
• Expert in Development and Customization of Forms, Reports/XML Publisher and Workflow.
• Well experienced in Develop Interfaces and Conversions using Seeded APIs.
• Experience in R12 implementation. Technical and Solution Architect.
• In depth knowledge of database concepts and SQL, PL/SQL with skills in a variety of scripting and programming languages
• Data Integration and Data Extraction
• Strong in Application Database Design and Exposure to AIM methodology
• Experience in creating Packages, Procedures, Functions, Materialized Views, Triggers using PL/SQL
• Expertise in Application and SQL Performance Tuning
• Designing, developing and testing the RICE components (Reports, Interfaces, Conversions, Extensions)
• Through knowledge of System Development Life Cycle (SDLC)
• Team and Project Leadership
• Expertise in Database Design; Data Model for OLTP application
• Prepare Technical Specification and Design documents
• Complete understanding of Oracle Trading Community Architecture (TCA)/Exposure on CDH.

Technical Proficiencies

ERP:

Oracle Applications 12i/11i/11.5.9/10.7; CRM (Service Contracts, Installed Base, Field Service, TeleService, iSupport, Customer Data Hub (CDH), Product Data Hub(PDH)); Tele Sales, Incentive Compensation(OIC), Advanced Inbound/Outbound Telephony, Email Center, Interaction Center, Computer Telephony Integration(CTI), Scripting, Core Contracts, Order Management, Purchase Order(PO), Inventory, Bill of Material (BOM), Pricing, Supply Chain Management(SCM), General Ledger (GL), Account Receivables(AR); HRMS; System Administration, Application Object Library (AOL), AIM Methodology.

ORACLE Tools:

SQL* Plus, SQL* Loader, SQL Navigator, SQL Developer, Toad
Developer2000 (Oracle Forms 9i/6i/4.5, Oracle Reports 9i/6i/2.5, Oracle Graphics), XML Publisher 5.0.0/5.6.2, Designer 2000, Workflow Builder 2.6.3, Oracle HTML-DB/APEX; Sql Trace and tkprof, export(exp), import(imp), fndload, Oracle Application Manager (OAM) and Oracle Enterprise Manager (OEM)

Database:

Oracle 10G/9i/8i, Ingres 6.4, MS-SQL Server 7.0, MS-Access, ODBC, FoxPro, dBase.

Programming Languages:

C, C++, SQL, PL/SQL, COBOL, PASCAL, FORTRAN, Java, Pro*C/ESQLC, Perl/UNIX Shell Scripts

Internet Tech.:

HTML, DHTML, XML

O/S:

UNIX, Linux, Solaris, WINDOWS, DOS

Tools:

Unix Vi editor, MS Office Suit (Word, Excel, PowerPoint, Outlook), Access, MS Project, MS Visio, Object Version Management- VSS, PVCS, Perforce; Object deployments - Kintana, PPM; Defect Management - Mercury Test Director, Mercury Quality Center, JIRA Bug/Defect Tracker; Project Planning and Magmt. - XPlanner, Rally, MS Project; Scheduler -Unix CRON, $U Scheduler.

Professional Experience

Senior Consultant 2009 – Present
Confidential,Fremont, California

Oracle ERP products implement, Customize, Develop, maintain, and upgrade the product to suite the business needs of the customers. Coordinate design and implementation of applications, collaborating with project managers, offshore development teams, and client representatives to ensure ontime completion of project deliverables. Provide technical leadership to junior Engineers, developing Overall project architecture. Design and prepare technical specifications for the deliverables and maintain Oracle Application Products. Selected projects included...

• Client: Confidential,California

ERP Minor Enhancements(Nov’09- Still working):
Minor Enhancement team works on all the new enhancements and change request from business users and some of the non critical production issues on all the implemented ERP modules OM, INV, Pricing, Service Contracts, Support, Service Requests, Customer Data Hub and Product Data Hub.
Responsibility as Business Analyst:

• Understand the user requirement, prepare Business Requirement Document, Get approval from the stake holders, Assign job to development teams at India and Argentina, Complete Unit Testing, Coordinate QA and UAT testing.
• Defect tracking, work assignment and update status.
• Prepare unit test cases and perform Unit testing in both 11.5.8 and R12 application environments before QA testing.
• Coordinate Testing team for QA testing, UAT team for Business Acceptance and re-assign all the defects to respective development team.
• Object version control using PVCS, Coordinate Migration/Deployment team for object deployment to QA, UAT, and Production environment.

Responsibility as Technical Consultant:
(Oracle Application version 11.5.9/R12 -Senior Functional/Technical Analyst.)

• Support and fix workflows issues in production (OM header and lines, service request, and custom workflows).
• Develop and setup custom concurrent programs and reports for custom service requests (iSupport).
• Use change management methodology to implement new and changed programs in production.
• Prepare Design documents adhear to AIM methodology MD70.
• Prepare Interface programs to CDH an R12 application using TCA model.
• Order capture to Service Contract and Installed Base.
• Performed requirements gathering, functional gap analysis, oracle application configuration and modules setup, writing documentation, and production support.
• Modify, Create workflow processes and PL/SQL packages.
• Developed database objects (packages, procedures, triggers, views, etc.) to provide custom functionality within the Oracle Applications to suit the customer need on Order Create form.
• Client: Confidential,Palo Alto, California

Self Service Support Portal (S3P)(Oct’ 08- Jun’ 30):
Spearheaded the development of Oracle APIs to facilitate a web based interface for the VMware customers across the globe to manage online their Contracts, Order, License, Contract Renewal and Contact data management and also for internal users (CSRs) to act upon customer requests.

• Responsibilities include Participate in understand and analyze the requirement, Evaluate and finalize on Solution approach, Technical Design, Development, Code Review, Test Case preparation, Execution, Update JIRA Defect Tracker, fixing the Performance issue, Source code maintenance through PERFORCE Object Version/Source control tool, Prepare Object deployment packages using PPM/KINTANA, Coordinate Offshore-Onsite team for Development/Defect handling, Coordinate with Middleware and Front-end development team, Address and fix complex issues/defects, Coordinate Deployment team for object migration, Post deployment verification, Coordinate DBA team to streamline the issues related to Workflow, Sys Admin, Profile option value and Out-bound mail setups; Preparation Technical and User Documents, Upload all the documents into Share drive, Daily Status update to the team and the client management.
• Participated in Requirement gathering, Design and prepare Technical specifications (MD 70), publish API signature to FMW (Oracle Fusion Middleware Team), Test case preparation. Coordinated offshore development team, review, and Testing.
• Active participation with internal client teams to define and implement solutions that improve internal business processes.
• Developed Custom Workflow to handle Complex Sync. & Asynchronous to create / update / delete contact Roles on a Service Contract. The process includes i. Create email contact-points, ii. Create customer-party relationships, iii. Create cust_account relationship and iv. Add/Update/Delete contacts using standard Oracle APIs of OKC, HZ modules.
• Developed onetime Data fix scripts for TCA Relationship issue.
• Implemented Audit/Trail using Oracle Applications.
• Developed PL/SQL package to send mails with attachment.

Modules: Oracle Apps 11.5.10.2, Order Management, Core Contracts, Service Contracts, Installed Base, Accounts Receivable (AR), INV, TCA; Oracle 10G

Systems Manager/Consultant 2000 – 2008
Confidential,Bangalore, India; Mountain View, California.

• Client: Confidential,San Jose

Cisco Goal 2 Commission – R12 Oracle Incentive Compensation(OIC) (May’ 07 – Oct’ 08):
Involved in Customization, Development of Interface, Conversion scripts, Development of Custom Workflow and support the customization of OIC implementation for Cisco that facilitates set up and maintain compensation plans for the commissioned sales people.

• Designed, Developed custom workflow for the approval of compensation plan and rate table/Goal Sheet approval which has been integrated OIC to achieve the approval functionality. Implemented workday calendar functionality to hold the workflow notification delivery on holiday and week-ends to suite all the employees scattered across the Globe with different time zones of various countries and territories using oracle Time and Labor.
• Implemented workflow Notification Templates. Incorporated 12i advanced features of OAF screens into Oracle Workflow Notification by embedding the OAF regions.
• Developed Conversion scripts using UNIX scripts and PL/SQL programming for data migration from various oracle instances/legacy applications to Oracle OIC instance (implemented $U Scheduler jobs to streamline the process).
• Developed many XML Publisher Reports, Converted existing RDF reports of Visibility and Compensation into to XML Publisher. Created Concurrent JOBs and Registered the reports as A Data Definition with XML Publisher.
• Developed Resource Interface/Conversion (Employee, Assignment, LOA, Job data) extract employee data from external PeopleSoft HR and ongoing Oracle HRMS implementation.
• Developed/Customized the Resource Mgmt. screen, Assignments, Currency Rate and Compensation Plan screens using Oracle Forms.
• Developed Oracle Alerts to notify the referring master data changes of external Database systems
• Developed Oracle Application Custom Responsibility, different kinds of Value Set for report parameter validations in Oracle Applications

Modules: Oracle Applications 12i CRM suit, Oracle Insensitive Compensation (OIC), CRM Resource Manager, General Ledger, Human Resources (HRMS).; Oracle 10G; Forms 9i; Workflow 2.6

• Client: Confidential,Boston, MA

Galaxy Oracle Application Implementation (Jun ‘04 – May’ 07)
Worked as Oracle Technical/APPS DBA resource to support 9i RAC architecture implementation of NSTAR Oracle CRM suit for their Call Center application.

• Customized the eBusiness Screen (Main screen for Call Center Service representatives) to suit the users need. Provided various launch buttons (launch legacy Mainframe applications so that the user can enter data through the Mainframe screen, and other customer based applications including Credit and Collection and Launch of Experian Application).
• Extensively worked on Interface ‘Daily Update(DU)’ for data load from Legacy Mainframe application to Oracle CRM. The process includes around 17 interfaces including Customer Data to Appliances, Premise, Billing, and Usage etc. Fine Tuned and Streamlined the process to meet the customer SLA.
• Developed Custom APIs and many Unix Shell scripts (Interfaces) for data transfer from Mainframe to Oracle CRM and vice versa and developed Concurrent programs and scheduled for daily run.
• Developed complex Unix Shell scripts to read data from both Flat File and Oracle table, compare the data, exclude the duplicate and redundant data, upload into Oracle Tables; Executed through a daily schedule CRON job and Automated the processes.
• Developed scripts to automate the DU data files archive process to compress(zip) the files and store into achieve/backup directory, to avoid the space issue in production servers.
• Solution Architect for IVR-WEB Galaxy Interface. Designed the complete Galaxy (EBS) interface, data stage and process; store-forward mechanism for IVR related all request transactions.
• Major EBS technical contributor for the Galaxy Package2 Go Live. 80% of the Change Requests(approx CRs 130) were addressed as a single technical consultant from onsite.
• Worked on Oracle Scripting technology to customize the customer interaction screen/customer registration. Developed forms based interface to replace Scripting.
• Defined descriptive Flexfields, Developed Custom Forms, Reports using Reports Builder, SQL scripts, unix scripts and customized the Applications Forms and Reports. Created Menus, Responsibilities, Report groups, Functions, Profile option Values, and installing new printer styles System Administrator Responsibility.
• Register Reports, Forms, Define Concurrent JOBs, Define Values sets, Flexfields. Defined Descriptive Flexfields, and also registered PL/SQL, stored procedures, SQL*Plus scripts etc.
• Developed data fix scripts(using seeded apis) to capture the latest customer Telephone number supplied by the 3rd party
• Supported the Galaxy application from offshore as Oracle APPS DBA. Applied various patches and maintained the DB activity to stream line the application for the day to day activities.
• Developed interface programs for eTrack, eBill applications.
• Developed automated script to identify and eliminate/remove duplicate payment issue of eBills process. The process sends a notification mail to the users before it process transfers the file to Bank.
• Weekly maintenance of Production Database and Application (Forms & iAS) servers(Bouncing the database/application servers including 9iAS, Oracle DB, Oracle Application Servers and WB Methods Server..
• Involved in Application Upgrade to 11.5.10

Modules: Oracle Applications 11.5.9/11i CRM suit, Tele Sales, Installed Base, Customers Online, Universal Work Queue, Advanced Inbound, One-to-One Fulfillment and CRM Foundation, Service Request, TeleService, Service Contracts, Field Service, Receivables, Order Management, TCA modeling; Oracle 9i RAC. ;Forms/Reports 6i;

• Client: Confidential,St. Louis

Emerson Motors ITSS Oracle APPS Support (Jan ’03 – Jun ’04):
Worked on application customization, offshore APPS DBA and offshore Support from India, for Emerson Motors Oracle APPS implementation. Offshore Apps DBA support for ITSS Project vision to support all the application enabling and support to Emerson Divisions for Application planning and Support.

• Supported the applications; applied required Patches, Clone the Application Instances and Refresh the Database and fore-see the instances for smooth execution.
• Resolve various technical issues rising from Development, Testing, Training and Production instances.
• Developed and implemented programs as per business requirements. Developed new Reports include Customer Order status Report, Backlog Detail Report, Backlog Summary Report, Backlog by Item (Line Level) Report, Cycle Status Report, Open Work Order Report, Sales Rep Commission Report, Customer Profiles Report, Supplier related data, Invoice Information, Aging Buckets etc.
• Customized Order Line Workflow to setup the send FAX.
• Used AOL components to register generated Reports, Forms, Flex fields. Defined Descriptive Flex fields, value sets and also registered PL/SQL stored procedures, SQL*Plus scripts etc

Modules: Oracle Applications 11.5.7 – Order Management, Account Receivables (AR), Inventory (INV), Account Payables (AP), General Ledger (GL) etc., Oracle 8i, UNIX, Windows

Emerson Motors OM Production support (Jan’02 – Feb ’03)
Worked on Customization of various Forms, Reports and Development of various stored procedures, triggers as part of Support for Order Entry, Inventory, Purchasing, and Receivables

• Triggers to implement over shipments
• Developed IN bound and OUT bound interface programs to captures the customer data.
• Developed validation programs for the interface tables
• Designing of various barcode labels; Customized and Developed Custom Reports as per the business functionality and requirements including the procedure to print barcodes labels.
• Performance tuning to improve the execution time of problem queries

Modules: Oracle Applications 10.7 (Order Management, Purchasing, BOM, AR, INV), Oracle 7.x/8.0

• Client: Confidential,Detroit, MI.

Global Production Information Method (GPIM) (Jan ’00 – Dec ’02):
Worked as Oracle D2K Reports Developer, Data extraction from both SQL Server and Mainframe to Oracle Database, and Oracle DBA to support the GPIM application.

• Migrated one Master and twelve Local Databases data from SQL server, Mainframe to Oracle using SQL Loader facility at EDS Office, Russelsheim, Germany.
• Created shell scripts and automated job to schedule the process.
• Developed around Ninety Reports, embedded with Graphs in reports and Fixed defects/bugs.
• Optimized the report queries to improve the retrieval time.
• Performed DBA activities and maintenance of Stored Procedure, Functions and Packages and enhancements on existing modules.

Environment: Oracle 8i, SQL Server 2000, PL/SQL, Forms 6i, and Reports6i, SQL*Loader, SQL*Plus, UNIX Shell Script, VI.

Assistant Manager Systems 1997 – 2000
Confidential,Mumbai, India.

• Client: Confidential,Jeddah, KSA

Integrated Business Applications for YCC (Nov ’97 – Dec ’00)
Worked as Developer in developing Forms, Reports and build an Integrated Business Applications to suite business for Cement Manufacturing Company for their day to day activity to generate purchase orders, invoice, pay slips, inventory etc. in a single integrated application. New modules include Plant Maintenance, Inventory Management, Purchase Management, Cement Despatch and Accounting System (Sales System), Raw Material Handling System, Finance, Personnel Administration and Payroll.

• Involved in complete System Development Life Cycle (SDLC) from Gathering requirements, System Analysis, Design, Development, Testing and Implementation and Support.
• Extensively worked on Oracle Developer 2000 (D2K) tools of Forms, Reports, Graphics, Procedures, Triggers and Packages for implementing business logic.
• Developed RS232 port reading software using Pro*C to capture the weight reading from the weighbridge.
• Developed FoxPro routine to capture weight, executed through Oracle user exits calls.
• Developed report that generates Qslip, invoices and voucher forms, Pay slips, Check printing , Purchase requisition forms and Comparative Statements for Quotations
• Developed data clean-up of FoxPro data and loading scripts to extract data from FoxPro to Oracle Tables.

Environment: Oracle 8.0/8i, SQL, PL/SQL, Developer 2000 Rel 2.1 Forms 6.0, and Reports5.0/6.0, FoxPro, Windows NT, Windows 98 client.

Software Engineer 1995 – 1997
Confidential,Hyderabad, India.

• Client: Confidential,Hyderabad

Computerised Attendance Recording and Management System (CARMAS). (Feb’95-Oct’97).
Worked as Ingres Application Developer for Cumputerised Attendance Recording and Management System(CARMAS) to generate for Payroll of 10508 Employees of BHEL, Hyderabad, from the Data collected by Badge Readers at the Gates. CARMAS marks and employee Present/Absent based on the Swipe Data (In/Out Punches). CARMAS also takes care of the Attendance Regularization, recording of Late Entries, early Exits and Extra Hours Worked. Based on the Extra Hours Worked data, overtime and Ad Hoc Hours Booking is done. It also takes care of Leave Recording Maintenance, Shift Schedule Recycling, and Data Acquisition from the Central Information Distributor and Generates number of required reports.

• Development various Master and Transactional data entry Screens using Ingres Visual Forms Editor tool as per specifications. These primarily includes Data entry screen for Shift Changes, Leave posting screen, Overtime and Attendance Adjustment screens.
• Developed communication programs to read the data from card readers and Cluster Controllers
• Developed attendance processing program using Ingres ESQLS(Pro*C) tool. The process marks each day as employee present or absent? Also calculates extra hours recorded
• Developed Monthly/Daily shift generation program using UNIX Schell scripts and Esqlc(Pro*C). The shift data enable the employee access control.
• Developed many statistical report for Management using SQL, Report Writer and Unix Shell Scripts.
• Developed Automated Scripts to capture the employee swipe data from Badge readers and Cluster Controllers.
• Developed process using Unix Shell Scripts to export the monthly employee attendance data into a flat file for the Mainframe system. The data is input for the payroll processing system on ICL S39.
• Developed various reports using the tool Ingres Reports Generator and ESQLC(Pro*C)

Environment: Ingres, UNIX Shell Scripts, VI, ESQLC, Visual Forms Editor, MS-Dos.

Education:

Master of Computer Applications