Software Engineer
Resume:
Vijayashri Bolla
**********.*****@*****.***
https://www.linkedin.com/in/vijayashri-bolla-25b2021/
Professional Summary
Results-driven IT professional with 17+ years of extensive experience in Oracle SQL, PL/SQL, ETL development using Informatica/IICS, and BI reporting with Tableau, Business Objects, and Crystal Reports. Specialized expertise in SAP Callidus Commissions (SAP SuccessFactors Incentive Management) implementation, cloud-based data integration, database tuning, and business analytics. Proven ability to analyze complex business requirements, design robust technical solutions, optimize database performance, and deliver high-quality, scalable reports and dashboards.
Skilled in Agile methodologies, cross-team collaboration, and mentoring junior developers, with 1+ years of freelance corporate training experience on Oracle SQL, PL/SQL, Snowflake, SAP Commissions, Crystal Reports, and Informatica PowerCenter/IICS.
Expert in advanced Tableau features including calculations, parameters, hierarchical groups, sets, and dashboard development. Adept at proposing and designing data integration solutions to minimize manual intervention and reduce errors.
Technical competencies include:
●Strong SQL, PL/SQL including complex queries using window functions, joins, set operators, and dynamic SQL across Oracle, SAP HANA, Snowflake and SQL Server.
●Expertise in building reusable workflows, parameter files, and scheduling jobs to automate data processing.
●Hands-on experience with IICS cloud integration tasks, mapping configurations, and cloud connectors to facilitate hybrid data integration scenarios.
●Skilled in identifying and optimizing ETL bottlenecks and optimizing Informatica/IICS workflows and admin tasks.
●Strong background in monitoring ETL job performance using Informatica workflow logs, session logs, and server monitoring tools.
●Experienced in Unix shell scripting, application shared password reset, and redeployment.
●Extensive experience in code deployment on WebLogic servers and preparing migration cut-over plans.
●Excellent analytical, problem-solving, and quick learning abilities.
●Self-starter with strong multitasking skills, ownership mindset, and goal-driven attitude.
●In-depth understanding of SDLC and Agile (Scrum) processes, including high-level design, development, testing, debugging, and client support.
●Active participation in Scrum ceremonies and coordination with offshore and cross-functional teams.
Technical Skill Set:
Database
Oracle 12c/11g/10g/9i, MS SQL Server, Teradata, Snowflake, PostgreSQL, SQLite, SAP HANA
ETL Tools:
Informatica Power center, IICS and SSIS
BI Tools
Business Objects, Crystal Reports,Embedded Analytics and Tableau
ERP Package
SAP Callidus Commissions, Callidus TrueComp, SmartStream TLM
Software Tools & Utilities
SQL Developer, Oracle External tables, SQL*Loader, Oracle, EXP/IMP utility, SQL Trace, SQL*Plus, TOAD, JSON, Parquet, HADOOP, PostgreSQL, MySQL, SQLite and Slack, PuTTY, WinSCP, New features of Oracle 18c/19c
Cloud Computing
AWS, MS Azure
Scripting
VB, Unix, Python
Modeling Tool
Oracle Designer, Erwin, SQL Data modeler, Visio
Version control tools
PVCS, KINTANA, Perforce, Git and GitHub
Issue Tracker
Service Now, JIRA
Operating Systems
MS Windows7/ XP / NT/10, MacOS, Linux
EDUCATION:
Bachelor’s Degree in Computer Science in 1999 from Gulbarga University, Karnataka, India.
REWARDS:
●Top Contributor Award: The award in recognition of commendable performance, contributions to the success of the organization and the value added to the clients and their business in a sustained fashion, this award was achieved 3 years in a row, for the years 2013, 2014 and 2015.
●Awarded “Outstanding Individual” Contributor from Client (Cisco) for my development activities where I have developed extremely high performable code with an innovative approach and delivered on time.
●‘Outstanding Performer’ award from client (HCA) for analyzing and graphical presentation of existing database and presentation of new changes.
Certifications:
●SAP Certified Application Associate– SAP Commissions Implementation.
●Professional Certificate Program in Data Engineering – by Simplilearn and Purdue University
●Snowflake 18 hours online training and certification by Udemy
●Machine Learning Certification from Stanford University
●Hadoop Platform and Application Framework Certification from University of California
Professional Experience:
Cisco Systems Inc For SRS Consulting Inc, San Jose, CA 4/2023 - Present
Title: Software Engineer
Role: SAP SuccessFactors Incentive Management/SAP Commissions Development and ongoing Production support.
●Implementing Global Sales Compensation Applications, Data warehouse, back-end automation, application integration, reporting and Insights solutions.
●Design and develop the SAP HANA Analytical, calculation views and SQLScript procedures to support complex commission calculations and reporting needs within SAP Commissions.
●Created complex Procedures to integrate Reference data, Organizational data and transactions loads from Oracle and Snowflake
●Created Virtual tables to refer to the Snowflake tables and Oracle tables in SAP Hana procedures to create inbound Integration.
●New fiscal year requirement analysis, review and update JIRA’s
●Creating Functional and Technical design documents, test case preparation.
●End user training document preparation and walk through the changes implemented to the stakeholders and business/end users.
●Working on the CR’s and Enhancements on the Commissions elements, Rules, formulas, plans, formulas, Plan documents, dashboards
●Workflows development to facilitate the Over Achievers, internal bonus payment adjustments (MIP, ZPP, Rec draw etc), Commissions Calc run automation and Manual uploads.
●Dropbox configuration.
●Working on Stagehook configuration for DI.
●SQL Scripts/Procedures for Data Integration and Stagehooks in SAP HANA Database.
●Design and develop the procedures in Snowflake to create the transaction assignments based on the transactions, Sales reps data and territory-based reference data.
●Workflows development to facilitate the internal bonus payments uploads such as Overachievers, MIP, Rec Draw.
●Developing the Operational reports in Embedded Analytics.
●Working on CR’s and enhancements in ETL mappings and workflows to load participants, position, lookup table cell data, transaction data and other reference data into SAP Callidus Commission cloud database.
●Working on CR’s and enhancing the Compensation statement report, Order detail report, Quota report, Payroll report, Customer summary report using Crystal reports.
●Configuring the Express Data Loader for Inbound and custom outbound reports.
●Creating the SAP HANA SQL scripts/procedures for Outbound reports.
●ETL development for data loads from various sources to targets (Teradata to flat files, Teradata to Oracle, Snowflake to flat files) using informatica.
●Involved in UAT, PAT refreshes and testing pre-go live.
●Involved in preparing the migration cut-over plan and reviewed with cross functional teams and stakeholders to obtain approvals.
●Operational support and issues analysis, troubleshooting and resolution.
●Team management and collaborating with cross functional teams.
Environment: SAP SuccessFactors Incentive Management/ Commissions, SAP Commissions Workflow, SAP HANA, CDL, SDI, Oracle12c, Snowflake, Informatica 10.X, IICS, Embedded Analytics, Crystal Reports and UNIX
New York Life - for IBM 01/2023 – 04/2023
Title: Package Solution Consultant (SAP Callidus Commissions consultant)
Role:
●SAP Commissions design architecture and gap analysis.
●Involved on SAP Commissions participants count/licensing issue.
●Involved in creating Procedures in HANA for pre-processing Organization data,
●Involved in analysis of SAP Commissions custom reports and enhancement using Crystal reports.
Environment: SAP Callidus Commissions, SAP Commissions Workflow, SAP HANA, JIRA and Crystal Reports.
Spectrum Technologies LLC for SRS Consultancy Inc, San Jose, CA 04//2022 - 12/2022
Title: Sr. Consultant (AMS – L2/L3 Support)
The role involves development and Service maintenance (Production support) for various clients (Village Care Max, Genesys, Lumentum, Icertis, Ivati..)
Role: SAP Incentive Management/Callidus Cloud Commissions Consultant, Data Integration and Reports Developer.
●Requirement analysis, prepared use cases, technical document design.
●Client reviews and approvals
●Design and develop 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 the 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 a custom database to generate the data for reports development.
●Involved in SAP Commissions standard and custom Reports development with Crystal Reports.
●Developed the Operational reports in Embedded Analytics.
●Coordinating with cross functional and offshore teams.
Environment: SAP Incentive Management Studio/Callidus Cloud Commissions, SAP HANA, Oracle12c, Informatica 10.4, IICS, Embedded Analytics and Crystal Reports and UNIX
Cisco Systems Inc For SRS Consulting Inc, San Jose, CA 5/2021 - 04/2022
Title: IT Engineer
Role: SAP SuccessFactors Incentive Management/Commissions Implementation and Data Integration Developer (Lead developer).
●Requirement and feasibility analysis of commissions system implementation for partner commissions.
●Reverse engineering the existing functionality to get high-level requirements out of it.
●Involved SAP Commissions design and implementation which includes Customization, creating Rules, Formulas, Rate Tables, Lookup Tables, Classification Data, Variables, Global Values settings, User Setting. Dashboard configuration.
●Data integration, source from Snowflake to staging area (Oracle DB) using Snow SQL
●Creating procedures in SAP HANA for data integration and outbound reports generation.
●CDL Inbound/Outbound Integration.
●Created Oracle tables with Partitions and indexing in the internal staging area.
●Created procedures and functions to apply the business logic, validations and cleansing rules.
●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.
●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.
Used collection objects and bulk binding.
Creating Temp tables and Dynamic SQL to build report queries.
PL/SQL Performance check using DBMS_Profiler and tuning the code.
●Involved in Reports development with Crystal Reports & Business Objects
●Coordinating with cross functional and offshore teams.
Environment: SAP SuccessFactors Incentive Management Studio/SAP Commissions, SAP HANA, Workflow, CDL, SDI, Oracle12c, Snowflake, Informatica 10.4, IICS, Embedded Analytics, Crystal Reports and UNIX
8x8 Inc, Campbell, CA 02/2019 – 04/2021
8x8 Inc. is a US-based provider of Voice over IP products. Its products include cloud-based voice, contact center, video, mobile and unified communications for businesses.
Title: Business System Analyst Manger. (AMS -L2/L3 Lead)
Role1: SAP Callidus Cloud Commissions and Database/ Data Integration Developer
●Requirements gathering, Analysis, Use cases, Technical documents design.
●Implementation of Callidus application for Sales comp and Channel partners, which includes plans, formulas, rules design, plan documents, dashboards.
●Proposed and provided solutions for data integration to transfer the participants, positions, quotas, lookup tables and transactions data upload.
●Prepared the technical design documents.
●Landing Pad Configuration.
●Stagehook configuration.
●Secure Agent Install and configuration.
●ETL Development for Organization Data, Plans & Transaction Data loads using Informatica.
●ODI Data integration development with Oracle SQL, PL/SQL Code along with Informatica Power Center.
●Worked on JIRA, GIT and GitHub to implement the continuous Integration and Continuous Development (CI/CD).
●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.
●Involved in UAT, PAT refreshes and testing.
●Prepared migration cut-over plan, reviewed with cross functional teams and obtained approvals.
●Involved in end-to-end Infrastructure, environment setup and code migration.
●Postproduction support and maintenance.
●End user training content preparation and delivered end user training.
●Incident analysis, troubleshooting and resolutions.
●Team management collaborating with cross functional teams.
Environment: SAP Callidus Cloud Commissions, Oracle12c, Informatica Power Center 9.x, 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 check-in - checkout into GitHub.
●Post production support and maintenance.
●Analyzing CR’s. Issues, coding and bug fix and migrating to production (CD/CI).
●Worked on JIRA, GIT and GitHub to implement the continuous Integration (CI) and Continuous Development (CD)
●Involved in code migration process.
Environment: MS SQL Server Studio, Tableau 10.x, Slack, JIRA, GitHub.
NetApp, Sunnyvale, CA 03/2013 – 01/2019
Title: Business System Analyst Manger. (AMS -L2/L3 Lead)
Worked in On-prem TrueComp environment, involved in upgrading to Cloud and Callidus Cloud environment as Global Sales Compensation Applications architect, with providing the Data warehouse, back-end automation, application integration, reporting and Insights solutions.
Role1: SAP/Callidus Commissions, Data Integration/ETL and Reports Developer.
●Worked as Callidus Application developer of TrueComp V7 and Callidus Cloud and SAP Commissions
●Involved in requirements analysis, BRD reviews and FSD reviews.
●Involved in Technical design and reviews.
●Development of Compensation Plans, Rules, Formulas, Lookup tables, Dashboards.
●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.
●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
●StageHook configuration.
●Landing pad configuration.
●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.
●Code check-in – checkout in Perforce.
●Involved in Code deployment from Lower env (Dev) to TST/UAT env.
●Supported testing in QA and UAT environment.
●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.
●Worked on JIRA, GIT and GitHub to implement the continuous Integration (CI) and Continuous Development (CD)
●Involved in planning and execution of services maintenance activities (CRs, patching, SAML certification migration, etc.)
●Accomplished the successful transition of TrueComp on-premises implementation to Cloud hosted TrueComp SaaS model.
●Involved in Application Upgrade of Customized Callidus TrueComp from v5 to v7.
●L2 support for on premises V5 and v7 Callidus TrueComp - production support and maintenance.
●Technical issue analyzing, resolving and root cause analysis of 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 it on the 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 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.
Proj2: Description: SMART (Sales Management and Reporting Tool) 03/2013 – 01/2019
SMART is a custom application built within the systems infrastructure at confidential Company to enable the Sales Team for business processes like Hierarchy Management, Territory Goal and Forecast Data Management, Compensation Plan Data, Goal Sheet Administration and Reporting, SMART follows all sorts of agile ceremonies (user story grooming, sprint planning, sprint retrospective).
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 Check-in - Checkout into PERFORCE & GIT
●Analyzing CR’s. Issues, coding and bug fix and migrating to production (CD/CI).
●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 Center 10.x, Crystal reports, Service Now, JIRA, Perforce P4V, and Git.
Applied Materials, Santa Clara, CA. - For IBM 05/2012 to 03/2013
Technical Consultant: Oracle PL/SQL database Developer
Description: LEAP- BOARD is a support project with the technologies Oracle Apps, Oracle 10g, SAP and Informatica. Leap is an ERP application and BOARD is a 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 bug fixing of PL/SQL code.
●Involved in performance tuning with partitioning and indexing.
●Access granting to Leap schema for new business admins.
CISCO Systems Inc – for IBM 12/2009 to 04/2012
Architect Solution Engineer (ASE): Oracle, SQL, PL/SQL Developer
Description: NGCCRM (Next Gen-Commitment Compliance and Revenue Manager) is the application for managing revenue deferrals related to non-standard deals, all deals or transactions having compliance terms, which require a revenue deferral, a revenue transfer, or an invoice hold of at least $100,000 must be maintained in NGCCRM.
Role: Architect Solution Engineer (ASE): Oracle SQL, PL/SQL Developer
●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 indexes.
●Created PL/SQL Packages, Stored Procedures, Functions, Pipeline Functions.
●Developed PL/SQL APIs to integrate 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 check-in-checkout and deployment using PVCS and KINTANA
●Involved in TCA & TCB and dispatch of the code into the test environment.
●Involved in successful Go –Live
●Supported at normalization phase after go-live
●Tech lead for a group of 6.
Environment: Oracle10g, ADF, Oracle OWB, Oracle Apps (AP, AR, GL), Workflows, UNIX, SQL Loader, PVCS, KINTANA.
HCA (Hospital Corporation of America) -For IBM, Delhi, India 09/2008 to 12//2009
SQL Server Developer, ETL (SSIS, Informatica), SSRS Developer
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 successful Go –Live
Environment: MS SQL Server 2005, Informatica 8.x, Teradata and UNIX, Erwin, MS Visio
GENPACT, Hyderabad, India 04/2007 to 08/2008
Title: Software Engineer
Project: SmartStream’s TLM Reconciliations
Role: Database Developer, 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 and Parameters.
Environment: SmartStream’s TLM Reconciliations software, Oracle 10g, Crystal Reports 9.
Employer: ICFAI University, Hyderabad, India. 07/2004 to 02/2007
Title: Software Programmer
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.
Environment: VB 6.0, MS SQL Server 2000/2005 and Crystal Reports 9
Contact this candidate