SUMMARY

• Over 10 years of experience and Performed various role in handling multiple technology like Varicent SPM 7.2 & 8.0.1, Oracle Applications R12/11i/11.0.3 and SQL server.
• Varicent Consultant for Compensation Calculations and creation of Presenter reports
• Specialized in Oracle Applications (CRM/Distribution/ Financial) skills wif sound noledge of their integration.
• Designed and developed Conversions, Open Interfaces, Forms and Reports in Oracle CRM/Distributions/Financial applications.
• Strong analytical and technical skills wif good programming experience in SQL, PL/SQL, Developer 6i/2000 (Forms 6i/4.5, Reports 6i/2.5), SQL*Loader, UTL FILE.
• Application tuning using TK - Prof and explain plan.
• Used Standard processes, Application Implementation Methodology (AIM), Six-Sigma Quality initiatives.
• Experience in detailed noledge of end-to-end project delivery which includes Project Initiation, Planning, Executing, Monitoring & Controlling, Closing Phase activities.
• Designed, created, and maintained all databases, scripts, queries, and reports.
• Excellent communication and interpersonal skills, understanding the fundamental business processes of any application, having the right attitude to work in challenging environments, motivate the team members, and work diligently to provide best solutions to the client and as well as meet the time schedules.

TECHNICAL SKILLS

Package tools non: Varicent V 7.2 & 8.0.1

Databases: Oracle 8i/9i/10g/11g and SQL Server 2008 R2

Applications: Oracle R12/11i/11.0.3 Good proficiency in MS Office applications (Word, Excel, PPT, Access & Visio) and Windows Operating Systems:

Misc: Discoverer, TOAD, Putty, Winscp, Perforce, SQL*Loader, MS Visual Studio TFS, ITG and Fortify.

PROFESSIONAL EXPERIENCE

Confidential

Varicent application developer

Responsibilities:

• Working as a Varicent Consultant for Compensation Calculations and creation of Presenter reports
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction wif the data warehouse architect on the development of Varicent models and ERP Models.
• Varicent Application Production Support and Weekly Production Metrics generation on Sales.
• Experience in setup configuration table for Upcoming Compensation Plan periods.
• Experience in creating various tables like Structural, Hierarchy, Data and Custom tables in Varicent
• Created calculations for different Compensation Plans.
• Created Varicent calculations for various Sales Credit business Rules.
• Created reports for Payroll file generation to be supplied to ADP system.
• Scheduler Tasks for scheduling the comp plan run's, managing Workflow for access privileges
• Creation of Quotas based reports for Tracking goals
• Varicent environment support for migrations of content.
• Experience in setup of Calendars and expanding the calendars.
• Experienced in integration of the Varicent web reports wif SSO.
• Experienced in Production support and enhancements for handling change requests.
• Experienced in Presenter reports creation for all the canned reports.
• Involved in Migration of reports, calculations, tables, imports and compensation plans between Varicent models and environments for Dev, AIT, UAT and Production systems
• Production support & enhancements for change requests
• Outbound support for other applications integrated wifin the Sales Systems.
• Experienced in performance analysis and design of Varicent solutions.
• Implemented both fixed grid and data grid based reports.
• Experienced in creation of composer calculations for supporting Varicent reports.
• Daily, Weekly and Monthly Commissions Reporting Generation.
• Created packages using SQL Server Integration Services platform by using Control flow and Data flow components.
• Extracted data from different sources like SQL Server, Flat Files, Excel, and Varicent Views and transformed, loaded onto required database through SSIS.

Confidential

Senior Analyst.

Responsibilities:

• Production support & enhancements for change requests.
• PDS System Retirement Project - This is an integration project dat aims to retire the existing Product Data System (PDS) and its integration wif Oracle R12 Applications. Implemented a new global solution and integrated the application wif the new product system Domino.
• Telmar Project - Traverse part of Dell Force10 business is acquired by Telmar. Working as a Senior Development engineer from offshore and coordinating the efforts wif the onsite team to gather requirements and provide required extracts from different Oracle modules - PO, OM, Inventory, BOM, Service Contracts, IB, AR, AP & GL for conversions.
• Integration Projects: Played a key role in the Oracle integration projects wif Dell Systems. Closely coordinated wif the onsite team on requirement gathering and analysis, designed & managed the technical deliverables to integrate most of the Oracle modules wif Dell systems & SFDC.
• Instrumental in defining, updating the Technical procedures, documentations based on AIM methodology.
• Played a major role in Oracle Financial (Payables/GL) rollout for India Operations. Developed custom objects to support localization dat are specific to India Finance - reports on TDS, Service Tax, Invoice Details, journal details, Trial Balance on Noetix, customized check printing for India.
• Developed interfaces to integrate wif 3rd party Trade beam to make sure Order Management Customers comply wif US Federal laws.
• Configured Oracle ERP to publish Terms and Conditions on Purchase Order Documents and customized the XSL’s to reduce the # of T&C pages.
• Customized Oracle Quote import process to tie-up wif Revenue recognition. As part of this Service items were pulled into Oracle as non-invoice-able lines.
• Streamlined Agile to Oracle interface to (Inventory & BOM) make it more robust, wif extensive error handling capabilities, more automated, thereby reducing the manual intervention.
• Guided the Team members wif their deliverables dat halped to meet project timelines.
• Responsible for resolving Production support issues.

Confidential

Responsibilities:

• Working on SCM modules which involves P2P cycle and O2C cycle and also interact wif upstream team (POS) for data request for various scenarios.
• Validation the ALE GLASS feeds in EBS system for the correctness and the accounting details in GL module.
• Sales Order Import - Developed a program to import all the open sales orders from the legacy system. Sales orders were imported by populating data into the open interface tables.
• Purchase Orders Conversion - Converted all the open purchase orders from legacy system to Oracle. Import Standard Purchase Orders was called to import all the open purchase orders into oracle.
• Item Import - Designed and developed a program for item conversion from the legacy system to oracle. This program imports Items from the legacy system into Oracle.
• Prepared the MD70 and MD120
• Production Support tickets resolution.
• Install Base Conversion - Designed and developed custom program to load to records from the legacy system to Oracle Install Base.
• Service Contracts Conversion - Designed and developed a custom program to load the service contracts from PeopleSoft to Oracle using the standard API’s. Created the contract header, contract service lines, contract covered lines, billing stream and the Price Adjustments to apply the discount or surcharge.
• Service Request Conversion
• Designed and developed a custom Program to validate the data from thelocations, org contacts, and contact points.