SQL Server Resume Malvern, PA - Hire IT People

SUMMARY

Experienced Professional with 8 Years of IT Experience into Development, Support and Testing.
5+ years of experience on Sales Performance Management/Compensation Management tool Varicent/IBM Cognos ICM and SQL Applications also developed Discovery dashboards in Varicent 10.
Experience in implementing compensation solutions in different versions of Varicent including V8, V9.0.2 and V10.
Experience working in version upgrade project from V9 to V10 which involves modifying calculations for V10 PPO, webforms for new jquery libraries and calc performance tuning.
Experience in utilizing REST APIs in external python scripts. Experience in creating saved query publications to retrieve data from Cloud Object Storage.
Working on three different Varicent application Modules (CX, Agent and LDPOC) with different kind of Sub projects in them also gave support for those Modules.
Built many Compensation Plans and Presenter Reports for agent’s commissions.
Gather the requirements from the clients and prepare the BRD’s and get the approvals.
Worked on ETL tools to pull the Payee and Transactional data from different systems.
Worked on the Estimation of the BRD’s and submit the details to Higher Managements to get the approvals to work on the Project’s.
Assign the Change Requests and Incidents within the team members based on the bandwidth between the team members.
Worked on PowerBuilder and PL/SQL languages to Create Stored Procedures, Triggers also worked on the Manual Testing in early stages of IT career.

TECHNICAL SKILLS

Tools: Varicent/IBM Cognos ICM 7.2 to V10

Languages and Technologies: Python, Power Builder, PL/SQL.

Bug Tracking tools: HP ALM, Bug Tracker and BMC Remedy.

Databases: SQL Server, SQL Tools, Oracle 11G.

Version control tool: SVN.

PROFESSIONAL EXPERIENCE

Confidential, Malvern, PA

SQL Server

Tools: Varicent/ Cognos ICM 8.1.3 to V10, SQL Server, Python, PowerCenter, SAP

Environment: Windows

Responsibilities:

Created reports using Presenter, tested them in the web, peer reviews with Business to make sure everything is covered.
Worked on Calculation Performance areas and Crated Various Data Stores and Communicate with third party members to fix the Prod Issues.
Involved in Varicent Upgrade from IBM Cognos ICM V9 to Varicent 10 by doing integration changes.
Involved in requirement discussions and analysis of requirements to prepare BRD’s.
Created various structural, custom and data tables as per the requirement.
Created web tabs, portal access groups, trees and assignments.
Built various levels of compensation Calculations at transaction level and Payee Level to calculate the commissions for Agents and Sales Managers.
Created Portal Access groups and Trees and created assignments to presenter reports and webforms. Also created portal access rules in Task Manager.
Built the Compensation plans for Commissions as well as Special performance incentives.

Confidential

SQL Server

Tools: Varicent/ IBM Cognos ICM 8.1.3, SQL Server 2008

Environment: Windows

Responsibilities:

Created numerous Configuration and reference tables in Cognos ICM 8.1.3 based on business requirements.
Built the saved imports to retrieve data for Transactions and Configuration data thru pipe delimited text file feeds.
Worked on creating plan components and calculations for counts and commissions at transaction level as well as Payee level.
Worked on categorization and grouping of calculations into various levels of components and established Inbound and Outbound connectors.
Created several Varicent views and publications to generate payout data at transaction level.
Developed the Presenter report for Commission statement for Internal and external view.
Extensively worked on creating several data stores and presenter sources for reports.
Created several Accounting and Management reports using Presenter Reports.
Migrated the components and reports from DEV to QA and migrated workflow groups and created web enabled logins for users.

Confidential, Florida

SQL Server

Tools: PLSQL, PowerBuilder, Oracle

Environment: Windows

Responsibilities:

Developed various stored procedures, Triggers scripts as per the business requirement.
Including new features like separating existing functionality as a separate application, calling new functions through window’s API and calling other application functions through DLL files.
Fixing issues by getting the required information from the client.
Having knowledge in Creation of MSI, EXE using Install Shield and in Preparation of Release KIT.

We provide IT Staff Augmentation Services!

Sql Server Resume

Malvern, PA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship