Vijayashri Bolla

• Involved in requirement analysis, technical design and documentation.
• Involved in SAP Commissions design, plan change, rules, formulas, dashboards and Comp plan Documents
• Involved in Creating PL/SQL packages/procedures
• Involved in ETL Development for Organization Data, Plans & Transaction Data loads using Informatica
• Involved in creating Procedures in HANA for pre-processing Organization data, Transaction data and outbound payroll report
• Involved in SAP Commissions standard reports and custom reports development and enhancement using Crystal reports
• Involved in Workflow development
• Environment: SAP Callidus Commissions, SAP HANA, Workflow, Oracle 12c, Informatica, and Crystal Reports.

• The role involves to development and Service maintenance (Production support) for various clients (Village Care Max, Genesys, Lumentum, Icertis, Ivati..)
• Role: SAP Callidus Commissions, Data Integration and Reports Developer
• Design and developing the plans, formulas, rules, lookup tables, rate tables, plan documents, dashboards
• Data integration for organization data uploads, classifications & transactions
• Creating procedures in SAP HANA for data integration and outbound reports generation
• CDL Inbound/Outbound Integration
• Created Oracle tables with Partitions and indexing in internal staging area
• Created procedures and functions to apply the business logic, validations and cleansing rules
• Involved in creating PL/SQL packages, procedures, functions pull data to custom database for reports and transfer to upstream system
• Writing PL/SQL Package, Procedures in custom database to generate the data for reports development
• Involved in SAP Commissions standard and custom Reports development with Crystal Reports
• Coordinating with cross functional and offshore teams
• Environment: SAP Callidus Commissions, SAP HANA, Oracle 12c, Informatica 10.4, IICS, Crystal Reports and UNIX

• Requirement and feasibility analysis of commissions system implementation for partner commissions.
• Reverse engineering the existing functionality to get high-level requirements out of it.
• Prepared graphical flow diagrams using Lucid Charts.
• Involved in analyzing data integration design process.
• Created data integration design documents.
• Implementation of Callidus application for Channel partners, which includes plans, formulas, rules design, plan documents, dashboards.
• Data integration, source from Snowflake to staging area(Oracle db) using SnowSQL ( and Oracle db (SQL, PL/SQL, Informatica/IICS) to SAP Cloud db.
• Creating procedures in SAP HANA for data integration and outbound reports generation
• Created Oracle tables with Partitions and indexing in internal staging area.
• Created procedures and functions to apply the business logic, validations and cleansing rules.
• Stagehook Configuration.
• Involved in ETL development to load participants, position, lookup tables, quotas, orders & transactions and other reference data into SAP Callidus Commission cloud database.
• Worked on Informatica installation and installation of secure agent for IICS.
• Writing PL/SQL packages, procedures, functions pull data to custom database for reports and transfer to upstream system.
• Writing PL/SQL Package, Procedures in custom database to generate the data for reports development.
  Used collection objects and bulk binding
  Creating Temp tables and Dynamic SQL to to build report queries.
  PL/SQL Performance check using DBMS_Profiler and tuning the code.
• Worked on JIRA, GIT, GitHub and Bitbucket to implement the continuous Integration (CI) and Continuous Development (CD)
• Complex reports development with Crystal Reports & Business Objects
• Coordinating with cross functional and offshore teams.
• Created Migration document and reviewed with stakeholder and cross functional teams.

Environment: SAP Callidus Commissions, SAP HANA, Oracle12c, Snowflake, Informatica 10.X, IICS, Jira, Git/Github, Bitbucket, Crystal Reports 2016 and Unix

Role1: SAP Commissions and Database/ Data Integration Developer

• Engaging business users in requirements discovery and documentation discussions.
• Implementation of Callidus application for Channel partners, which includes plans, formulas, rules design, plan documents, dashboards
• Proposed and provided solution for data integration to transfer the participants, positions, quotas, lookup tables and transactions data upload.
• Landing Pad Configuration.
• Stagehook Configuration.
• Secure Agent install and configuration.
• ETL Development for Organization Data, Plans & Transaction Data loads using Informatica Power Center
• Data integration development with Oracle SQL, PL/SQL Code along with Informatica Power Center.
• Involved in developing Compensation statement report, Order detail report, Quota report, Payroll report, Customer summary report using Crystal reports.
• Created graphical representation of reports such as Bar charts, 3D charts and Pie charts for the order detail and customer detail reports.
• Developed Web Intelligence reports making use of several Queries (JOINS and Set operators)
• Involved in test case preparation and unit testing.
• Created migration cut-over plans, reviewed with cross functional teams and obtained approvals.
• Involved in end-to-end Infrastructure, environment setup and code migration.
• Post production support and maintenance.
• Analyzing CR’s. Issues, coding and bug fix and migrating to production (CD/CI).
• Team lead, collaborating with cross functional teams.

Environment: SAP Callidus Commissions, Oracle 12c, SQL, PL/SQL, Informatica power center 10.X, IICS, Crystal Reports, BO XI 4.2 and Unix

Role2: MS SQL developer for CRM Billing Manager.

CRM Billing manager follows all sorts of agile ceremonies (user story grooming, sprint planning, sprint retrospective).

• Developed MS SQL procedures, Functions, SQL scripts for CRM reports.
• Created visually compelling and actionable interactive reports and dashboards using Tableau and obtained

insights into large data sets

• Created procedures using Dynamic SQL to integrate with cross functional applications.
• Created reports using Tableau features like complex calculations, active filters and cascade filters, Dynamic

Parameters, joins and data blending.

• Generated Tableau Dashboards with quick/context/global filters, parameters and calculated fields on Tableau.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of

analysis

• Involved in test case preparation and unit testing.
• Code checkin - checkout into GitHub.
• Post production support and maintenance.
• Analyzing CR’s. Issues, coding and bug fix and migrating to production (CD/CI).
• Involved in code migration process

Environment: MS SQL Server 2018, SQL, T-SQL, Tableau 10.x, Slack, JIRA, GitHub.

Role1: Data Integration/ETL and Reports Developer, SAP/Callidus Commissions implementation and support.

• Involved in requirements analysis, BRD reviews and FSD reviews.
• Involved in Technical design and reviews.
• Development of Compensation Plans, Rules, Formulas, Lookup tables, Dashboards.
• Stagehook Configuration.
• Landing pad configuration.
• Created Oracle tables with partitions in NetApp Landing Zone database.
• Created Procedure, functions, views in NetApp Landing Zone database.
• Involved in ETL development for STTC batch processes using Informatica Power Center.
• ETL and PL/SQL development for EDW Data loads to SAP Commissions.
• ETL Development for Landing Zone to ODI Integration with Oracle SQL, PL/SQL, Informatica Power Center and Unix Scripts
• Created MVIEWS and developed ETL workflows to refresh the data in Datamart.
• Validating data and make sure to consume it by upstream and downstream systems.
• Performance tuning in the Datamart database with Partitions, indexing and applying the optimization techniques.
• Informatica Backups, User access provisioning, password management.
• Involved in developing Compensation statement report, Order detail report, Quota report, Revenue report, Subordinate report using Crystal reports.
• Created graphical representation of reports such as Bar charts, 3D charts and Pie charts etc. Comp data DataMart.
• Involved Web Intelligence reports making use of several Queries (JOINS and Set operators).
• Created and maintained HTML page for Portal Landing Page updates and deployed in ASW server, which included the monthly maintenance and banner update.
• Involved in test case preparation and unit testing.
• Coordinating with cross functional and offshore teams.
• Code check in – checkout in Perforce.
• Involved in Code deployment from Lower evn (Dev) to TST/UAT env.
• Prepared Code Migration documents from UAT to Prod.
• Created migration cut-over plans, reviewed with cross functional teams and obtained approvals.
• Involved in end-to-end Infrastructure, environment setup and code migration.
• Post production support and maintenance (CD/CI).
• Involved in planning and execution of services maintenance activities (CRs, patching, SAML certification migration, etc.)
• Accomplished the successful transition of TrueComp on-premise implementation to Cloud hosted TrueComp SaaS model.
• Involved in Application Upgrade of Customized Callidus TrueComp from v5 to v7.
• L2 support for On premise V5 and v7 Callidus TrueComp - production support and maintenance.
• Technical issue analyzing, resolving and root cause analysis the issue.
• Applications performance checks and rebooted when necessary in the server side to clear the stale processes after obtaining the stakeholder approvals.
• Database instance and application password reset.
• Encrypt the new password and update in application server.
• Redeployment of war/build after the password rest.
• Migration plan preparation, review with stakeholders and cross function teams
• Production code migration in Cloud application, Informatica , Database and Unix.
• QTD/ YTD Sales credit & Revenue recognition report queries performance tuning by applying the optimization techniques, able to tune the queries complete in 15 minutes which were taking 15 -18 hours.
• Developed YTD revenue reconciliation and recognition reports and dashboard for auditing using Tableau.

Environment: SAP Callidus Commissions/Callidus TrueComp(3/5/7/cloud), Oracle11g, Informatica Power Center 10.x, BO XI 3.1, Crystal Reports, Tableau 10.x, UNIX, Perforce P4V and Service Now.

Role2: Technical Consultant: SQL Server Database Developer.

• Proposed and provided solution for STTC batch process for loading the data from SMART to TC.
• Involved in requirement analysis, BRD reviews.
• Technical design and reviews.
• Involved in enhancement of SMART database code (Procedures and Functions)
• Involved in writing SQL Procedures to generate STTC batches
• ETL Development for STTC Batch processes to TrueComp Landing Zone in Informatica Power Center.
• Created different types of reports such as Master/detail, Cross Tab and Charts in Crystal Reports
• Created complex queries for Participant detail report and participant comp components report.
• Code Checkin - Checkout into Perforce & Git
• Involved in preparing migration plan and post migration validation check list.
• Involved in CR’s & issues analysis, resolving and root cause analysis.

Environment: Java, MS SQL Server, Informatica Power Cener 10.x, Crystal reports, Service Now, JIRA, Perforce P4V, and Git.

• Description: LEAP- BOARD is support project with the technologies Oracle Apps, Oracle 10g, SAP and Informatica
• Leap is ERP application and BOARD is reporting data warehouse for Leap
• Role: Oracle PL/SQL Developer/Technical Support
• New requirements analysis for enhancement
• Provided technical oversight of significant configuration Changes, including review and quality assessment of complex action plans
• Served as the Environments' technical authority for complex Problem resolution involving various technical inputs
• Enhanced the existing stored procedures to improve the performance
• Batch process monitoring and troubleshooting
• Involved in planning and execution of services maintenance activities (CRs, patching, etc.)
• Involved in Root Cause Analysis and issue fixing with corrective actions
• Involved in enhancement and bugs fixing of PL/SQL code
• Involved in performance tuning with partitioning and indexing
• Access granting to Leap schema for new business admins.

• Involved in BRD reviews, DSD reviews.
• Involved in logical data modeling and physical data modeling
• Prepared ER Diagrams for the new system(NGCCRM).
• Designed TDD for Manual Adjustments (Customized Screens) made from CCRM to GL

Accounts.

• Involved in TDD reviews - walk through the TDD with internal leads and client.
• Database Design, development and deployment.
• Created tables with partitions and indexs.
• Created PL/SQL Packages, Stored Procedures, Functions, Pipline Functions.
• Developed PL/SQL API’s to integration with GL.
• Involved in performance tuning.
• Created DB links to push and transactions from NGCCRM to GL and update back to the custom application.
• Involved in Data Migration development from Legacy CCRM to NGCCRM
• Code checkin-checkout and deployment using PVCS and KINTANA
• Involved in TCA & TCB and dispatch of the code into test environment
• Involved in successful Go –Live
• Supported at normalization phase after go-live
• Tech lead for group of 6.

Environment: Oracle10g, ADF, Oracle OWB, Oracle Apps (OM, AP, AR, GL), Workflows, Unix, Oracle Reports, SQL Loader, PVCS, KINTANA.

• ETL (SSIS, Informatica), SSRS, Description: The ED Dashboard product is a vital portion of the HCA Patient Safety initiative
• ED Dashboard is to provide the service to capture and evaluate the wait time and other information in the HCA Emergency Department
• Role: Database and ETL Developer
• Involved in requirement analysis and data flow process diagrams using MS Visio
• Involved in FDS preparation and reviews
• Created technical design document
• Involved in designing the Logical Data model using Erwin
• Involved in physical data model & prepared the DDL scripts to create the tables in Staging and Target database
• Created source to target mapping columns sheet
• Created complex SQL, T-SQL programs (Procedures & Functions) to integrate with Teradata
• Involved in the end to end ETL development using Informatica
• Involved in Teradata objects developments
• Involved in test case preparation and unit testing as part of of the development
• Involved in successful Go –Live
• Environment: MS SQL Server 2005, Informatica 8.6, Teradata and UNIX, Erwin, MS Visio

• SmartStream’s TLM Reconciliations
• Role, , ETL Developer and TLM Dashboards development
• Involved in requirement analysis and reviews
• Involved in technical document designs
• Involved in writing Matching rules and Data loading
• Worked with external tables, SQL
• Loader and Oracle Import/Export utility to load and unloaded data for various file/data sources
• Created column mapping sheets for from source to target database
• Created DDL script to create the tables, sequence in the target database
• Developed SQL, PL/SQL code for Dashboards and reports
• Involved Creating TLM Dashboards and Workflows
• Created the reports using Crystal Reports, Sub Reports, Drill down, Crosstab, Formulas, Parameters along with Dropdown lists etc
• Environment: SmartStream’s TLM Reconciliations software, Oracle 10g, Crystal Reports 9.

• Project: Process Automation of ICFAI (PAI), application consist of 4 modules
• Accounting Engine: This module is to automation of accounts department
• Inwards: Module is to Business Process Automation of Distance Education Programs
• Student Alerts: This module is to send email alerts to the students about results, payments, dues and so
• Subscriptions: This module is to automate the ICFAI subscriptions
• Responsibilities:
• Involved in requirement analysis
• Involved in developing and coding the Automation application front end with Visual Basic
• Involved in Database design which includes SQL queries, Stored procedures, functions and triggers (T-SQL)
• Created the reports using Crystal Reports functionalities like Add Queries (Command), Sub Reports, Drill down, Crosstab, Formulas, Parameters along with Dropdown lists etc
• VB 6.0, MS SQL Server 2000/2005 and Crystal Reports 9