SUMMARY

• Over Fourteen years of IT experience, with aroundTen years in Oracle Applications as Techno Functional Consultant
• Good team player as Lead/Consultant/Programmer Analyst/Developer
• Good experience in study/audit of existing business process and preparation of issue logs, collection of functional/technical requirements, client/user interaction, GAP Analysis, technical data mapping analysis and design of technical/functional data process flow charts
• Expert - level skills on technical and functional areas of Oracle Order to Cash modules (OM, INV, PO, BOM, WIP, AR),CRM, Service modules (CRM Foundation, Marketing Online, Oracle Sales, Depot Repair, OIC, Contracts, IB, Teleservice,iStore, Oracle Configurator), MDM (Customer, Product, Supplier)
• Experienced in PL/SQL programming using SQL Navigator, SQL Developer, SQL * Loader and Toad as development tools
• Extensive experience in Performance Tuning of SQL queries and Views using Explain Plan, SQL Trace and TKPROF utilities
• Experienced working with Oracle Discoverer, Forms, Reports, XML Publisher, Workflow builder
• Proficient in Interface Programs and Conversion Programs for importing data from Legacy Systems using SQL * LOADER
• Proficient in handling EDI interfaces (EDI 940, EDI 850 for Sales/Purchase orders, EDI 997, EDI 855 Sales/Purchase orders Acknowledgment, EDI 945 ship confirmation/invoicing, EDI 944 for PO receipts, EDI 947 for Inventory Adjustments, EDI 810 for Invoice outbound)
• Experienced with JTT / JTF, Oracle Applications Framework and JDeveloper 10g
• Extensive experience working with AIM methodology
• Extensive experience in handling projects using Java, JSP, HTML, Java Script and Unix Shell scripting

TECHNICAL SKILLS

• Oracle
• SQL
• PL/SQL
• AOL
• OA Framework
• Forms and Reports
• XML Publisher
• Discoverer
• SQL Loader
• TOAD
• SQL Developer
• Java
• JSP
• C++
• HTML
• DHTML
• PHP
• JavaScript
• XML
• Sun Solaris
• HP Unix and Windows.

PROFESSIONAL EXPERIENCE

Techno-Functional Lead

Confidential

Responsibilities:

• Analysis of existing business processes and gapsIdentified changes required to teh existing interfaces and shell scripts
• Modified Existing setups and performed additional setup in Receivables
• Generalized interface to create sales orders in Oracle using OM public API’s for purchase orders received on EDI 850
• Generalized interface to send PO Acknowledgement’s to Wholesalers via EDI 855
• Generalized interface to send invoices to Wholesalers via EDI 810
• Developed interface to load cash receipts sent on EDI 823 into Oracle Receivables
• Updated existing interfaces to meet R12 needs
• Customized teh Auto Accounting and Auto Invoice Programs in Receivables
• Constructed Discoverer reports using custom business areas, and granting teh access to teh workbooks as per teh responsibility restriction
• Did forms personalization to Auto populate item numbers
• Developed custom forms to load Invoice Accruals
• Customized teh AR Invoice, Sales Tax Reports in Receivables
• Support Month-end close activities
• Updated PO Requisition custom workflow
• Developed custom interface for forecasting items
• Developed interface to load time on Veeva file into Oracle OTL
• Developed interface to load employee information sent by Workday into Oracle HRMS
• Developed custom PTO report for reconciliation of PTO Hours between Oracle and Veeva systems
• Customized teh Horizontal Plan in ASCP
• Production Support for HRMS, OTL, SCM, MDM, ASCP, AR modules

Technical Lead

Confidential

Responsibilities:

• Involved in requirements gathering and analysis of existing business processesRepresent Otsuka in many third party integration meetings with UPS, SPS, LabCorp, Quest
• Designed solutions and assisted development team
• Worked on Customers, Install Base, Standing Orders, Invoice, Item conversions
• Developed interface to create sales orders in Oracle using OM public API’s for purchase orders received on EDI 850, sent acknowledgments for PO’s via EDI 855.
• Developed interface to send Sales Orders on EDI 940 and ship confirm sales orders received on EDI 945
• Developed an interface for standing order (Blanket Sales Agreements) release custom program
• Developed an interface program to send invoices to customers via EDI 810
• Developed an interface for Lockbox integration with Bank of America
• Developed an interface for RMA, PO receipts from 3rd party systems using EDI 944
• Developed an interface for performing Inventory Movements sent on EDI 947 in Oracle
• Developed EDI 945 for Otsuka Pharma invoice data load into Oracle from UPS/SPS
• Developed an interface for standing order contract expiration alert program
• Developed an interface to send RMA information to SPS via email
• Developedseveral custom reports using XML Publisher, Discoverer
• Developed an interface to update accounting classification code in Install Base
• Developed AR aging and open invoices report for RMS
• Developed custom Oracle Service Record Form and Service Record Form report

Technical Consultant

Confidential

Responsibilities:

• Analyzed teh requirements, designed solution
• Prepared MD50, MD70, MD120 documentations
• Developed an interface program to load data from Axosoft to Oracle
• Developed conversion programs to upload oracle Service request notes, notifications and attachments to Axosoft
• Personalized forms to make service request form fields read-only
• Analyzed options to call Axosoftwebservices from Oracle
• Developed an interface to load sales orders into Oracle using public API
• Developed custom OM reports
• Unit tested code

Techno Functional Expert

Confidential

Responsibilities:

• Troubleshot issues Advised best practices
• Provided solution by analyzing existing system
• Created Validation Sets, Lookup’s
• Configured setups in OIC to map required information from AR to OIC
• Developed an interface program to handle teh issues with Invoices and Credit Memo’s
• Provided support for QA
• Created/updated MD50, MD70 documents to reflect R12 functionality changes
• Created BP80 Process Flow documentation
• Created BR100 OIC setup documentation
• Configured setups of resources and resource groups
• Configured OIC system related setups such as check/set system profiles, defined application parameters, defined calculation parameters, defined accumulation periods
• Created compensation plans, plan components such as expressions, formulas, rate tables, rate dimensions, plan elements and pay groups, payment plans in OIC
• Personalized Sales Dashboard > Reports page to add commission discoverer reports to Oracle Sales module
• Interacted with users to gather requirements to develop custom commission discoverer reports
• Converted Brio reports in 11i instance to Discoverer reports in R12 instance
• Updated custom commissions discoverer reports to reflect R12 functionality changes
• Worked on defects resolution
• Performed OIC end to end functionality testing in R12
• Created TE020 unit test documents
• Created MD120 installation steps documents
• Built packages in Deployment manager to migrate teh code from development instance to Integration testing instance
• Provided support for QA

Techno Functional Consultant

Confidential

Responsibilities:

• Configured setups of resources and resource groups
• Created compensation plans, planned components such as expressions, formulas, rate tables, rate dimensions, plan elements and pay groups in OIC
• Interacted with users to identify gaps in technical design documents
• Updated CV60 technical design documents
• Updated existing interface to upload resources from file to staging tables and then to oracle base tables using API’s
• Developed an interface to upload orders from Siebel legacy system into custom collection staging table and then to OIC base tables
• Created external functions to calculate commission for Salesreps and Installers
• Worked on minimum payments for Salesreps and Installers
• Customized Transaction Details report, Commission Statement report to meet teh business requirements
• Customized teh OIC Worksheet JSP to provide a clear view for manual adjustments
• Created concurrent program to automate teh transactions validation control process
• Developed PL/SQL code to automate Collect, Load, Calculate processes in OIC
• Worked on defects resolution
• Provided support for QA, UAT and Production

Technical Consultant

Symantec Corporation

Responsibilities:

• Authored a CV40 mapping document for commissions
• Created a CV60 technical design document
• Developed an interface to import Commission’s Bookings Data from multiple regional sources into GOIC
• Created concurrent program to purge teh commission’s bookings data
• Created concurrent program for uploading email addresses of employees
• Created concurrent program to allow commission’s analysts to reset passwords for Salesreps in GOIC
• Created a concurrent program for a Pre-Scrub on regional bookings data
• Created teh .ldt files for teh concurrent programs
• Worked on customization of JSP’s
• Developed MD120 migration documents to migrate teh code to different instances
• Analyzed teh Manager, Commission Analyst reports
• Provided support for QA and UAT

Techno Functional Analyst

Confidential

Responsibilities:

• Interacted with teh users to resolve teh production issues
• Provided solutions for various web order issues
• Worked on improving teh performance of configurator
• Created and updated different rules including logical, numeric, comparison, property-based compatibility, explicit compatibility rules and design charts
• Worked on functional companions
• Modified set ups in Order Management
• Analyzed pricing setup from a functional standpoint and made teh changes for improving teh performance
• Setup of resources and resource groups
• Created client business flows to manage Campaigns to Leads, Lead to Opportunity, Forecasting, Opportunity to Quote, Quote to Order
• Setup of Oracle Marketing Online and Sales
• Personalized teh sales dashboard
• Customized teh JSP screens for Oracle Sales module
• Generated Forecast reports
• Implemented teh security access privileges
• Worked on data conversion for Leads
• Worked on lead survey and conversion of survey questions into note type
• Created compensation plans, plan components such as expressions, formulas, rate tables, rate dimensions, plan elements and pay groups in OIC
• Customized OIC reports to meet teh business requirements
• Developed teh BR-100 documentation Developed test scripts

Techno Functional Consultant

Confidential

Responsibilities:

• Involved in scoping and GAP analysis
• CRM Resource Manager (JTF): Set up Oracle CRM Resource Manager Components
• Setup teh Sales Methodologies, Sales Stages, Define Win Probabilities
• Created client business flows to manage Lead to Opportunity, Opportunity to Quote, Quote to Order, Order to Forecast
• Generated 360 degrees customer view
• Generated forecast reports for sales representatives
• Manager can also view teh sales representatives forecast reports
• Involved in designing teh models and Created product structure
• Created different rules including logical, numeric, comparison, property-based compatibility, explicit compatibility rules and design charts
• Created different dynamic user interfaces
• Implemented Oracle Configurator Attributes
• Developed a functional companion to make BOM item selection based teh values entered in a text Features
• Developed a functional companion to display or hide certain features based on teh parent model
• Studied teh existing asp website and mapped teh functionalities
• Studied teh user requirements, related oracle applications modules, identified teh gaps
• Customized teh iStore templates to follow teh existing web site look and feel
• Created Sites and Catalogs in iStore
• Configured items in iStore
• Developed custom iStore user interfaces
• Generated 360 degrees customer view
• Involved in teh integration of iStore with other modules like Configurator, OM, Inventory and Pricing
• Prepared technical and cost proposals for various government departments like USDA, DOD, DOL, NIH, HHS
• Prepared technical, cost proposals for applications like Website Management, Database Conversion, Vulnerability Assessment, IT Support, Test management tools
• Attended teh job explanation meetings for bid preparation
• Followed up teh bid submittals and attended teh clarifications, if any, from principles for technical and cost proposals

Programmer Analyst

Confidential

Responsibilities:

• Involved in gathering requirements, analysis and designing of an internal template for teh pricelist
• Developed teh database
• Prepared a system test plan
• Identified broken, dead links using tool like WebLinkValidator
• Conducted Performance, Functional and Load Testing using tools like Win Runner, Load Runner, WAPT, and Selenium
• Performed Accessibility Testing to check for sites compliance with section508 using Checky tool
• Setup teh Contracts Core and Service Contracts for contract management and authoring
• Setup teh contract groups, articles, templates, contract approval process
• Renewed teh contracts automatically before any service line terminates
• Prepared teh BR 100 Set up document and Scope for teh Project
• Set up of Subscription Template and Subscription Contracts
• Worked extensively on Service Request, Install Base, Service Contracts, Order Management and Accounts Receivable (Customer) API’S
• Performed Service contracts data conversion
• Involved in writing PL/SQL script for conversion of Orders from Oracle 11.0.3 to Oracle 11i for Order Management
• Converted item instances and item relationships
• Prepared teh CV 60 technical design documentation for order, service contracts and install base conversions