SUMMARY

• Over 15 years of IT experience in Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Financial and Telecom sectors.
• Strong Experience in Sales Performace Management (SPM) Solution SAP Callidus Cloud such as Commissions, Reporting & Analytics.
• 8 Years of experience working in Callidus Tools such as Truecomp Manager (5.2/7.0) and SAP Commissions (Version 1911.1, Build 185)© 2020 CallidusCloud.
• Expertise in Callidus Database Architecture.
• Extensive experience in Callidus Cloud such as Importing the Transaction/Order/Assignment Batches, Participant and Position batches,Position Relations, Lookup Tables, Fixed Line of Business values such as Goals, Pipeline Execution, Report Generation using Sap Crystal Reports, Users and roles management, BO User Sync.
• Experience in Configuring Rules/Outputs in the Database based on the Measurement/Credit/Deposit rules present in Callidus to calculate payouts accurately in terms of incentives and Commissions.
• Experience in designing the Paystatements using SAP Crystal Reports 2016 by creating Complex Crystal Reports and implementing Multi Level Grouping, Sub Reports Linkage, Hyperlinks.
• Experience in developing SAP Business Objects Web Intelligence Reports(WebI Reports).
• Experience in SAP Business Objects CMC (Central Management Console) such as Deploying the Crystal Report, Creating/scheduling a publication by delivering the Paystatements via portal, Creation of User Groups/Profiles, User Access, Security Levels.
• Expertise in Informatica Powercenter (8.6/9.1/10.1.0/10.2.0 ) and built many Informatica Workflows, Mappings.
• Experience in Oracle PL/SQL with usage of Stored Procedures, Functions, Packages, Cursors, Views, Indexes,Triggers and Partitioning Tables.
• Strong Experience of UNIX Shell Scripting in developing scripts to send Email Notifications, Job Scheduling, automate the ETL and Oracle jobs, FTPing the files, generating the reports, Data Cleansing/Filtering, Load Data through SQL Loader.
• Experience in Perl Scripting, built scripts to generate the reports in the Excel Format with multiple Tabs.
• Having Extensive experience in UNIX commands right from the Basic through Advanced commands. Was able to work with Huge Data using awk command without any difficulty.
• Worked on Version Control tools such as SVN, TFS.
• Good Experience in creating/scheduling the jobs in Dollar Universe (Automic Univiewer Console 6.8.41).
• Worked in both Agile and Waterfall Models.
• Business Analysis skills and experience working with various lines of business.
• Effective communication skills, spontaneity, great work ethics and grasping power.
• Work experience is combined with professionalism, determination.
• Excellent analytical and interpersonal skills. Ability to work both in team and independent job environments. Proficient in acquiring new concepts, applications and technologies quickly, and utilizing the same in a productive manner.

TECHNICAL SKILLS

Programming/Scripting Languages: Oracle, PL/SQL, SQL Server, Shell Scripting, Perl Scripting,Java

ETL Tools: Informatica Powercenter 8.6/9.1.0/10.1.0/10.2.0

Reporting Tools: SAP Crystal Reports 2016,SAP BO Web Intelligence Reports(WebI)

Special Tools: SAP Callidus Cloud, SAP Business Objects CMC

DataBase Tools: PL/SQL Developer, TOAD, MS SQL Server2008/2012

Incident/Defect Management Tools: Service Desk,SQUIDS,qtest

Operating System: MS Windows 7/XP/10,UNIX,LINUX

Version Control Tools: SVN,TFS

Job Scheduling: Dollar Universe, Cron Jobs

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead/Application Developer

Responsibilities:

• Participated and involved in gathering User requirements/Specifications.
• Worked on High level and low level design of the components.
• Developed Informatica workflows/Mappings to extract the data from multiple sources, transform the data as per the business logic and load the transformed into Callidus Truecomp Tables.
• Involved in Migrations from Informatica 8.6 to Informatica 9.1.0.
• Invloved in the Complex Cloud migration project from end to end when Callidus Onpremise is migrated to Callidus Cloud such as redesigning the Informatica mappings/Shell Scripts/SAP Crystal Reports,WebI Reports,PL/SQL Procedures.
• Also created Informatica Workflows/Mappings to stage all the Transactions/Orders/Assignments in the form of ODI files, sending them Callidus dropbox and then the batches can be imported into Callidus Cloud.
• Developed Custom Packages to fetch the Truecomp Data into Reporting Tables.
• Developed and migrated Complex SAP Crystal Reports that includes 150+ subreports to show the calculations effectively in the PayStatements.
• Developed Web Intelligence Reports (WebI) for Adhoc Reports required by Business.
• Worked in the Callidus Cloud Tool such as Pipeline Runs, Report Generation using Crystal Reports and Import Batches such as Transaction/Order/Participant/Position Relation/Lookup /Fixed Value, Purge Data, Reset and Validate the Data.
• Worked in getting the User Groups created and BO User Sync.
• Developed UNIX scripts to run the pipeline and import the Batches using ODJB.xml
• Developed PL/SQL Packages, Procedures, Functions, Triggers, Views, Indexes that are required to process data before it is sent to Truecomp /Stage Tables.
• Developed Shell Scripts for FTP File Transfers so that we can use them in the Informatica Mappings either to get the source files from the FTP locations or to place files in the FTP locations.
• Developed Shell/Perl scripts to generate the reports in excel format.
• Testing the data using test cases and sent the data to business team for approval.
• Improving quality of the application by using performance tuning concepts and automation
• Resolving defects raised by clients during SIT and UAT phases.
• Involved in the Production Turns.
• Ensured Project Release schedules are met without any delay.
• Once the Unit Testing and Review is done, Given the Demoes to the Business and Testing Team before the Story is added to the Release Schedule.
• Involved in Monthly Production Activities right from loading the Data from the Source, generating reports,importing the Data into Callidus Cloud, till the payroll file is sent and paystatements are generated.
• Participation on daily scrum call to update the progress and completion of task
• Facilitate the transition of work to TCS facilities at offshore.

Environment: SAP Callidus Cloud, SAP Crystal Reports, SAP WebI Reports, Informatica 9.10/10.1.0/10.2.0 , Oracle 11g,SQL Server 2008/2012,Shell and Perl Scripting, TFS, SQUIDS, TOAD, Dollar Universe.

Confidential

Application Developer

Responsibilities:

• Developed Informatica workflows/Mappings to extract the data from multiple sources, transform the data as per the business logic and load the transformed into Callidus Truecomp Tables.
• Developed Custom Packages to fetch the Truecomp Data into Reporting Tables.
• Worked in converting Actuate Reports to SAP Crystal Reports and integrated them with SAP Business Objects CMC, uploading the Crystal Reports to CMC Repository, creating the Publication, creating the User Groups, giving Access levels, and publishing the Paystatements.
• Worked in the Callidus TruecompTool such as executing Pipeline Runs, Report Generation using Crystal Reports and Import Batches such as Transaction/Order/Participant, Reset and Validate the Data.
• Configured the Measurement/Deposit/Incentive rules in the Reporting Database to fetch the data to the PayStatements.
• Developed UNIX scripts to run the pipeline and import the Batches.
• Developed PL/SQL Packages, Procedures, Functions, Triggers, Views, Indexes that are required to process data before it is sent to Truecomp /Stage Tables.
• Developed Shell Scripts for FTP File Transfers so that we can use them in the Informatica Mappings either to get the source files from the FTP locations or to place files in the FTP locations and generating Email Notifications.
• Developed Shell/Perl scripts to generate the reports in excel format.
• Testing the data using test cases and sent the data to business team for approval.
• Improving quality of the application by using performance tuning concepts and automation
• Resolving defects raised by clients during SIT and UAT phases.
• Involved in Troubleshooting the prod uction Issues
• Involved in Monthly Production Activities right from loading the Data from the Source, generating reports,importing the Data into Callidus, till the payroll file is sent and paystatements are generated.
• Participation on daily scrum call to update the progress and completion of task

Environment: Callidus Truecomp, SAP Crystal Reports, SAP, Informatica 8.6/9.1.0, Oracle 11g,SQL Server 2008/2012,Shell and Perl Scripting,VersionOne SQUIDS, TOAD, Dollar Universe.

Confidential

Developer

Responsibilities:

• Involved in Shell scripting/Perl scripting in case of new configurations such as setting the threshold limits and configuring the new hosts, cutting the severity1 tickets for some critical alerts etc..and also in case of any updates required in configuration changes
• Involved in shell scripting such that the notifications has to be sent to the mail lists and also to be notified when the disk space falls below the margin
• Worked on the Remedy Tickets that comes under Monitoring Queue.
• Involved in the Documentation of the Critical Processes such that it will be useful across the team.

Environment: LINUX, HP - UX, AIX, Shell/Perl Scripting, Netcool/OMNIbus 7.0.1,Nervecenter3.8, BigBrother 5.6.2iReportTool

Confidential

Developer

Responsibilities:

• Involved in major rollouts/projects such as 3NCR, MS-EXIT, MNP, GSM (DOCOMO) and 3G implementation of HLR
• Developed Customer Reconciliation module end-to-end like processing of NSN and HUAWEI GSM HLR's and ERICSSON and LUCENT HLR's for CDMA
• Scripts developed for data formatting/processing in the Backend using PL/SQL coding, UNIX, Perl scripting and C programs.
• Developed Frontend Report Server using Servlets and JSPs, Development of New modules of RAS.
• Working on New Requirements, CRs (Change Requests) /Enhancements based on Client requirements within the existing modules of RAS.

Environment: Windows XP, Java, UNIX, Oracle 10g, Shell/Perl Scripting,TOAD