SUMMARY
Education
BE, Electronics and Communication Engineering, India
Certifications/Training
Oracle Certification in XML Publisher
Oracle Certification Training on 11i EBS Financials & Distribution modules
Oracle Certification Training on 11i/2.6 Implement Oracle Workflow conducted
PMP Certification Training Course conducted
BRIO Advanced Course conducted
Technical Skills
Hardware: Sun Solaris 10, HP 9000, IBM Sequent, Unisys 6000, Dell, DPX 2000, IBM PCs
OS: Windows XP/2000, UNIX, Linux, Novell Netware 3.11, DOS
Languages & S/W: Oracle Forms 10G/6i/4.5/2.3, Reports 10G/6i/2.5/1.1, PL/SQL, SQL* Plus, Unix,
XML Publisher, OA Framework, Jdeveloper 9i, SQL* Loader, PeopleCODE 8.8,
Query Analyzer, Oracle9i Lite, Pro*C, HTML, Java, Esql, 4GL, C, COBOL, WEBDB, BRIO, Application designer, Procedure Builder, Microsoft Visio, Optio
Applications: Oracle Apps 12.0.4, Oracle 11i E-Business Suite, 11.0.3, 10.7NCA & SC, CRM, PEOPLESOFT 8.8, Mobile Sync Server, PORTAL 3.X
Database : Oracle 10G/9Ias/8.1/ 7.x, Ingres 6.4
Methodology: AIM
CASE Tools: EDI, TOAD, Turbo Analyst
GUI\'s: MGP, WebToGo, SQL navigator, Telnet/FTP
Skills Trained In: Oracle Applications, Discoverer, UPK, D2K, PeopleSoft, Project Management
Professional Summary
Accomplished Oracle Applications Programmer/Analyst with extensive related experience. Highlights include:
10 years of Oracle Applications experience (versions 12.1.1, 11i EBS, 11.0.3, 10.7, 10.SC, 10.7NCA), serving in various techno-functional roles. Primary strength lies in Oracle Application development. Extensive experience in the analysis, design and development of business applications in a client/server environment including experience in Oracle Financials, Oracle Manufacturing, Supply Chain, Distribution, Oracle HRMS, CRM, BI Publisher, Discoverer, FSG and PeopleSoft. Worked on different Oracle Modules: Order Management, Accounts Receivables, Purchase Order, General Ledger, WMS, WIP, BOM, AP, HRMS, Projects and Inventory. Strong experience in customizing Oracle Forms, Reports, and PL/SQL programming. Strong experience developing interfaces/conversions and mapping. Well-versed with the preparation of project proposals, presentations, and gap analysis.
Experience
Confidential,Fremont, CA 9/2010 – 10/2010
Oracle Apps Consultant
Utilized the following platform and technologies: Oracle Apps R12 (12.1.1), Oracle 11G, SQL*Plus, Discoverer 11G, PL/SQL, Oracle Alerts, SalesForce, OM, MRP, WIP, BOM, INV Developed and modified many Discoverer Reports Worked on Interfaces, SQL Loader program Publish Discoverer reports to Portal, create batch files Oracle Alerts modification Confidential,Torrance, CA 4/2010 – 9/2010
Oracle Apps Consultant
Utilized the following platform and technologies: Oracle Apps 11i EBS(11.5.10), Oracle 10G, SQL*Plus, PL/SQL, BI Publisher, Reports, OA Framework, Jdeveloper 9i, Optio, Unix, OM, Distribution Management, TeleSales, Workflow, Toad, BMC. Working on Production Support Issues related to OM and DM Developed many Data scripts and data fixes to Order Management. Interface issues with AR and BMC migration. XML Publisher Templates creation for multiple countries OA Framework Page development and Workflow Modified HL INTERNATIONAL PROBLEM ORDERS DETAIL REPORT Confidential,CA 9/2009 – 4/2010
Oracle Apps Consultant (Techno Functional)
Utilized the following platform and technologies: Oracle Apps 12.0.4 (R12), Oracle 10G, Reports 10g, SQL*Plus, PL/SQL, Linux, WIP, BOM, OM, INV, Oracle Projects, MRP, ASCP, PO, iProcurement, HRMS, OTL, AR, AP, GL, Shipping, Workflow, Discoverer 10G, Data Loader, Toad. Worked in Scheduled to Build, Award to Order, Quote to Cash Working in Order to Cash, Supply Chain, Forecast to Plan Project Accounting & Billing, Costing and Manufacturing, Procure to Pay Working in HRMS, OTL issues Desktop Integrator, Configurator Forms Personalization, PL/Sql Package, Conversions Working on Reports UPK development and administration Confidential,Fontana, CA 7/2008 – 8/2009
Oracle Applications Programmer / Analyst
Utilized the following platform and technologies: Oracle Apps 12.0.4 (R12), Oracle 10G, Reports 10g, Forms 10g, PL/SQL, SQL*Plus, Unix, OM, PO, AR, AP, GL, INV, WMS, Advanced Pricing, FA, iProcurement, HRMS, Workflow, Alert, Discoverer 10G, ADI, BI Publisher, EDI. Worked in Production Support, Post Implementation Issues. Order to Cash Issues, Procure to Pay Working in many SR’s with Oracle Warehouse Pick Slip, Delivery, Shipping, Packing, BOL Pricing Modifier, Qualifier, Formula Created Order Shipped not Invoiced procedure, API, Packages Resolved multiple PO, Requisition Issues Automation of EDI files to Japan, conversions and Interfaces Developed Physical Inventory reports & Excel o/p using XML Publisher Developed & Customized many Oracle Reports, FSG Reports. Customization & Personalization of Oracle Forms Created multiple Setups New Payment Terms implementation Modified pre-printed(XMLPublisher reports) Print Invoice, Warranty CM, Account Analysis reports Worked in Discoverer 10G, Workflow, UPK Confidential,Torrance, CA 4/2008 – 6/2008
Oracle Applications Programmer Analyst
Worked with the following technologies: Oracle, OM, Oracle Applications 11i E-Business Suite, XML Publisher. Toyota Kirloskar Motors, Bangalore 4/2007 – 1/2008
Oracle Forms and Reports Programmer/Analyst
Project: Suggestion, VMS
Utilized the following platform and technologies: Oracle 9i, Forms 6i, PL/SQL, SQL*Plus, Reports 6i, HR/Payroll, and Oracle 11i E-Business Suite. Implemented the Suggestion module. Designed and developed the Visitor Management System. Developed Oracle Forms and Reports. Confidential,California 4/2003 – 10/2005
Client - Project: Confidential,Atlanta, GA (5/2005 – 10/2005)
Business Analyst
Worked on the following platform and technologies: UNIX, Oracle Applications 11i, Oracle Project Accounting, Microsoft office Visio, PowerPoint, and Excel. Performed solution design for modules GMT, GOET, ePN and GTDI. Gathered requirements, performed business analysis and defined scope. Held regular meetings with users to understand the Requirement and provide feasible Business solution. Design of Functional document (CF250) for each module. Recommendations for technical considerations. Defining As Is and To be processes. Client – Project: Confidential,Oracle Workflow Upgrade (4/2005 – 5/2005)
Oracle Apps Consultant
Worked on the following platform and technologies: Unix, Oracle Applications 11i E-Business Suite, Oracle Workflow 2.6.2, Oracle 9i, PL/SQL, and SQL*Plus Upgraded project to Oracle Workflow 2.6.2 from the old version of Workflow. Customized different stored procedure, functions, database entities. Client - Project: Confidential,PeopleSoft Finance Implementation (12/2004 – 4/2005)
Worked on the following platform and technologies: Intel, Windows, PeopleSoft 8.8, AP, AR, GL, MS SQL Server 2000, Application Designer, Query Analyzer, SQL*Plus, SQR, and People Code. Implemented PeopleSoft modules AP, AR, and GL. Worked on different setups (Ex: ChartFields, Combo Rules, Open Period, Vendor, Customer, Market Rate, etc). Collected the User requirements and trained Finance users. Migrated from Tally system to PeopleSoft. Uploaded Vendor data from Excel into PeopleSoft tables using App Engine migration program. Exported and imported of data using Data Mover. Client – Project: Confidential, (1/2004 – 7/2004)
Oracle Apps Consultant
Worked on the following platform and technologies: IBM, UNIX, Oracle Applications 11i, PO, AR, AP, Inventory, Oracle 8i, Forms 6i, PL/SQL, SQL*Plus, and Reports 6i. Implemented Oracle Apps modules PO, AP. Designed Technical Specification as per the client requirements (MD70). Designed and developed Vendor Returns Forms. Designed the AP Interface API. Designed and developed the Customer Item Import. Developed different aging reports in AR. Worked on the Inventory module. Conducted reviews of different forms and reports. Client - Project: Confidential,Mobile Sync Server Application (10/2003 – 12/2003)
Oracle Apps Consultant
Worked on the following platform and technologies: IBM, Unix, CRM, Sales, Service Contract, Marketing, WorkFlow, Oracle9i Lite, Oracle 8.1, MGP, Web-to-go, PL/SQL, SQL*Plus, Reports 2.5, and Toad. Implemented Mobile Sync Server Application under CRM applications platform. This Technology for Palm Pilot project is being implemented successfully for the first time in this world. Performed analysis and design of Mobile Server Application. Designed and developed Table structures, Snapshots, Database Triggers, and Materialized views. Performed synchronization from Application Tables to Mobile Task tables and vise versa. Developed API’s, Refresh programs, and Interfaces. Created CRON jobs, Service Contract and install base Prepared proposals and PPT Presentation. Confidential,San Jose, CA 7/2002 – 11/2002
Oracle Applications Consultant (contract)
Utilized the following platform/technologies: Sun Solaris, Unix, Oracle Applications 11i/ 11.0.3, PO, AR, Fixed Asset, Inventory, Oracle 8i, PL/SQL, SQL*Plus, Reports 2.5, and Forms 6i. Performed automation of PO creation based on requisition. Developed different reports for Inventory and Fixed Asset. Developed form for PO creation and cancel requisition. Printed Invoice and Receipt reports. Performed PO printing report for Germany. Confidential,Seattle, WA 11/2001 – 3/2002
Oracle Applications Consultant (contract)
Utilized the following tools/technologies : IBM Sequent, Unix, Oracle Applications 11.0.3, GL, PA(Projects), AR, HR, Oracle 8.1, PL/SQL, SQL*Plus, and Reports 2.5. Involved in the Production support to different modules. Developed report showing GL Balances for different accounts based on given period ending. Worked on projects module to General Ledger Reconciliation. Supported Payroll and HR. Extracted procedures for Receivable Invoices, Payments and Adjustments. Confidential,San Jose, CA 1/2001 – 10/2001
Oracle Applications/Portal Consultant (contract)
Project: WARD
Worked on WARD (Worldwide AR Database), a single repository for its AR Collections data to consist of data originating from both Oracle AR based in the US and SUN Accounting based in the international regions. Utilized the following tools/technologies: Sun Solaris, Unix, Oracle Applications 10.7, AR, GL, Oracle 9i/8.1/7.3, PL/SQL, SQL*Plus, SQL Loader, PORTAL Web Forms and Reports, WEBDB, and BRIO. Implemented Ward EDI Project over worldwide. Analyzed the system to collect proper information and requirements from different users. Designed and developed different packages, Interface/control programs, screens, and reports. Used logic to upload the information from different SUN source files to Ward and Archiving database. Automated upload process and created some alerts that send emails to users. Supported Ward system and also had extensive interaction with different users and performed documentation. Developed Accounts Receivables detail report. Supported Revenue Database system, MD70 documentation Involved in the project migration to Oracle Portal. Design, development of many Portal Forms, Reports, Menus, LOV and Links
Confidential,San Jose, CA 1/2000 – 1/2001
Oracle Applications Consultant (contract)
Project Name: Customs Module, Royalty Revenue
Created the Customs module for the Customs Department of the Treasury to asses and collect all duties, taxes, and fees on imported merchandise, enforce customs and related laws, administer certain navigation rules, treaties for Nafta and HTS. Worked on the following platform/technologies: Sun Solaris, Unix, Oracle Applications 10.7, Inventory, BOM, AR, PO, Oracle 7.3, Forms 6.0, Reports 2.5, SQL Forms 2.3, PL/SQL, SQL*Plus, and SQL Loader. Designed and developed different packages, d/b triggers, screens, and reports. Used logic to get the top level part from BOM, Country of origin for items. Programmed to categorize part numbers under HTS classifications. Automated process for Buy America assessment and Serial number. Analyzed the new enhancements and provided support to system. Had direct interaction with users. Modified Royalty GUI Forms and posted in the Web. Developed programs to get old data from Archive database into ERP and consolidated it to report to IRS the tax on Royalty paid within the company.
Privacy Policy
