Ashwin Tapsey

Experience

• 

  Satyam Computers

  Jun 2007 - Feb 2009

  Software Engineer

  Project Sales Assignment Management SystemsRole Developer/Test AnalystDuration June 2007 - Feb 2009Responsibilities:Worked as a Test Analyst for the release Manage Resume details.Have been individually responsible for the release (AIMS-update) to enhance power of attorney related changes of Agent related data for a particular job.Handled a team responsible for testing the Web application for release (R14439).Providing training to the associates related to project.Coding of PL/I and COBOL modules for Agents authorizations for a specific line of business for release (R13819).Testing the resume management application for roles like agent and agent team member Developed many Automation tools in EXCELTo replace and format SQL in the test scripts used for unit testing.To generate a RECON report from a mainframe Physical Sequential file.To Estimate the time required depending on the criticality of the project and also the number of associates. Show less

• 

  HTC Global Services

  Mar 2009 - Oct 2010

  Senior Software Engineer

  Project: Sales Assignment Management SystemsRole: Senior Software Developer/Test AnalystDuration: March 2009 - Nov2010Responsibilities:Worked on the Analysis and implementation of modules with Enterprise PLI Worked as a Test Analyst Technical for Updating SFLMS Feed.Responsible for execution of batch Jobs and verification of data from People Soft to Associate register tables.Responsible for execution of Stored Procedures in DB2 development center.

• 

  Infosys

  Nov 2010 - Feb 2015

  Supporting the existing instance of the Merced/NICE- Incentive Compensation Management for Nationwide’s ‘Variable Compensation’ LOB.Understand the administration of various compensation plans.Help the business users in trouble-shooting the commission processing interruptions & monitoring the application.Work closely with the ETL team in getting the Monthly Data in the ICM Staging tables and Monitor the Calculated Values are pulled by the Views of SDM for Reporting purpose.Monthly load of data from staging tables to the core tables (Transactions).Maintain and enhance bonus compensation plans for Nationwide exclusive agents using the Merced/NICE ICM tool.Worked on creation of Plans and calculators for Agents and FSM (Personal lines, Commercial lines, Field Sales managers etc).Patching the Environment with the newer Version provided by the Vendor.Done end to end testing of the new versions of the tool.Worked on creation of reports for bonus details, Agent statements etc.Worked on payment Adjustments and release payments and Release Statements.Worked on Views for the reports using Toad to modify them as per Business requirements.Creation of Dataports and executing of the same to move data from staging to transactions, Worked on changing of API files for Reports ,XSLT style sheet (PDF and HTML)Configuration of Payee profile for changing the Payee fields and transaction Profile for changing the Transaction fields.Creation of Users ,Authorization rules for the users using templatesMonthly release activities to move the code to Production using the Code Move Scripts.Upgrading the tool from Version 3.2.9 to 4.2 and thoroughly testing it to check that the functionality is intact.Creation of Sales Hierarchy.Worked closely with business to make them understand the flow and process for the Monthly Activities..Discussions with the vendor on the issues of tool . Show less Project: Exclusive & Independent Commission ComponentsRole: Technology AnalystDuration: Dec 2010-Oct 2012Responsibilities:Worked on the Analysis and implementation of modules with Cobol (SOS modules) for Independent(IAC) and Exclusive Channel(EAC)Understood the existing commission system in all the Lines of business and have modified the code to consolidate all the commission components separatelyWritten a JCL tool to compare the old and new commission rates which helped in unit testing for all the 7000 Agent records.Created many modules to consolidate the data in different DB2 tables to single tables.Created many JCL’s as part of load and unload process.Actively involved in planning, documentation and administrative tasks.Responsible for execution of batch Jobs and verification of data from systems like Allied and THIResponsible for execution of Stored Procedures in DB2 development center.Reviewed and provided feedback on Unit Test scenarios, Unit test case/scripts, and data to offshore resources as well as other team members Show less

  • Incentive Compensation Management Configuration Consultant

    Nov 2012 - Feb 2015

  • Technology Analyst

    Nov 2010 - Nov 2012
• 

  Canidium

  Mar 2015 - Mar 2021

  Role: SAP Commissions Consultant Solutions: Callidus and Xactly (Different Projects) Data Integration and software configuration specialist for incentive compensation systems,Callidus Commissions suite and Xactly Connect.Develop and manage SQL to programmatically extract, transform, and load source data to a form readable to system feed.The responsibilities include:Gathering requirements into a FRD from clients, configuring and testing the scoped requirements.Provide end-to-end expertise to new and existing clients in the incentive compensation (ICM) space. Data Integration design and implementation,Integrating with Cloud applications for HR and Sales Data like Netsuite,Workday etc.Compensation rule writingOracle query customizationIndustry: Travel, Health Care, TelecommunicationRole: Technical Analyst Solution: NICE ICMWorked on getting the existing 3.1 application on the new Server.Installed the ICM Application 6.3 on to the Windows Server.Upgraded the Database schema from version 3.1 to 3.2 and then to version 6.3Worked on the Calculation issues and resolved them as there are some difference due to version changes.Changed some of the Data ports as per the 6.3 version and resolved many date issues and file loading issues.Created scripts to update the format of Reports from back end.Worked on SSO implementation. Written Oracle PLSQL functions to replace some of the function calculator logics.Sync of Payees the portal.Modification of API as per 6.3 formatCreation of the Payment process which includes payment batch, approval, scheduling of the Output Report and file Format as per company StandardsWritten Oracle PLSQL procedure for the customized archival process of several tables.Created Oracle before and after Triggers around the calculator functions.Worked on creation of delete and recreate scripts for tables ,indexes, triggers to move them to a different location with correct logging settings Show less

  • Technical Architect

    Jan 2019 - Mar 2021

  • Technical Analyst

    Mar 2015 - Jan 2019
• 

  Nationwide

  Mar 2021 - Feb 2022

  Consultant, IT Applications
• 

  Motive

  Feb 2022 - now

  • Manager, Sales Compensation

    Jul 2023 - now

  • Sales Compensation Manager

    Feb 2022 - Jul 2023