Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Sai Buddhavarapu

Dallas,TX

Summary

  • 11+ years of IT experience in Design, Development, Testing, Implementation and Support.
  • Involved in full lifecycle development of various assignments including Data Warehouse projects. Extensive experience in Business Intelligence Reporting tools like Business Objects, Tableau and PowerBI reporting.
  • Extensive experience in OLAP and OLTP technologies. Created Proof of Concept to compare various BI Tools like Tableau, PowerBI and Business Objects.
  • Good grasp of Decision Support Systems and data warehousing concepts and exposure to Data Mining methodologies and tools.
  • Involved in multiple integrations and Migration Projects.
  • Experienced in CRM Salesforce Projects. Strong experience in client interaction, understanding business applications and business data flow.
  • Experience working with Sales/Service clouds, Lightning, Data Migration and administration activities like creating Profiles, Roles, Users, Permission Sets, Record Types, Page Layouts, assignment rules, Search Layouts, Field-Level Security, Custom Tabs.
  • Extensive experience in designing of custom objects, custom fields, Picklist, rolebased page layouts, Workflow Alerts & Actions, Validation Rules, Approval Processes, Custom Tabs, design of Visual Force Pages, Record Types, Dashboards, AppExchange Package & Custom Application, Sandbox data loading and Email generation according to application requirements.
  • Experienced in integrating Salesforce with 3rd party applications like MuleSoft, DELLboomi, SAP.
  • Worked with various Devops Tools for SF, Bitbucket, Github, Jenkins, Azure.
  • Experienced in working with lighting components and designed strategy for Lighting migrations
  • Experience in Project Management activities of planning, scoping, monitor and control using tools such as Rally, Clarity, JIRA.
  • Creating Custom reports and Dashboards by Einstein (Wave) Analytics.
  • Experience in preparing Test Strategy, creating Test Plans, Test Cases, and Test Reports for Manual and automated testing for various business applications. Experience in performing UAT testing with business users and documenting the training manual.
  • Strong understanding of SDLC and Agile Methodologies.
  • Well-versed in Agile and Scrum methodologies focused on culminating business need and technology, leading to a wide range of product development initiatives.
  • Extensively involved in project coordination activities by keeping track of various project milestones and organizing weekly project reviews throughout the entire SDLC.
  • Excellent Verbal and Written Communication Skills. Have proven to be highly effective in interfacing across business and technical groups.
  • Excellent interpersonal, project management, communication, and documentation skills. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
  • Accomplished Consultant drives organizational improvements through leveraging expertise in research and system enhancement.
  • Well-versed in collaborating with employees and leaders to resolve control and procedural problems negatively affecting business operations.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Senior BA (CRM Analyst)

Penfed
06.2021 - Current
  • Lead business process analysis and workflow design to upgrade Credit Loss Mitigation application to a more current version of CRM Application.
  • The consumer Loss Mitigation Project is to convert existing old access databases to use new CRM System Applications
  • Worked on Sales/Service cloud applications and managed stakeholder requirements and provided solution(s) to businesses.
  • Lead and facilitate JAR, JAD sessions with business line SMEs to capture detailed business requirements for various workflows required to research fraudulent issues
  • Create process flows for better visualization and understanding of the proposed solution
  • Worked on Financial Service Cloud Implementation project
  • Analyze current reports and dashboards to identify process that can utilize AI powered Einstein Analytics
  • Importing Data Sets, Creating Lens & Dashboards
  • Create Data mappings, Data dictionaries, Data flow and segmentations for Member360 org
  • Worked on many Integrations(FICO, Hogan) using MuleSoft and created SOAP and REST API’s
  • Create detailed use cases for user–system interaction and business rules documentation
  • Interacted with business users in gathering, analyzing, and documenting business requirements and translating them into technical specifications
  • Coordinate with project managers/scrum masters/team leads on the status of all development tasks and any risks/issues/impediments
  • Worked with various external agencies to communicate requirements
  • Trained End Users on the application and participated in UAT testing
  • Ensure a quality level of documentation is produced and maintained regarding data solution architecture.

Salesforce Consultant

IBM, AT&T
05.2018 - 10.2020
  • Worked on Service cloud applications and manage stakeholder requirements and provide solution(s) to business
  • Contributed in defining and governing coding standards, developing custom code, implementing design patterns, and refactoring and/or simplifying existing code
  • Manage development, testing, release, support, and feature enhancements for both custom applications and managed packages
  • Utilized Azure DevOps, GitHub and JIRA
  • Provided solutions to business users for Salesforce configuration & development
  • Worked with various external agencies to communicate requirements
  • Worked on Service Cloud: Service Console, Call center/Customer Service Portal, Case Feed, Knowledge Base and Articles
  • Actively participated in Sprint Planning, Sprint Review & Sprint Retrospective meetings
  • Delegated work to QA team and helped them understand the requirements and changes in the code/application
  • Coordinate with project managers/scrum masters/team leads on the status of all development tasks and any risks/issues/impediments.

Senior Business Analyst

Pepsico
09.2016 - 05.2018
  • Gathering high-level requirements from clients and analyze feasibility with the technical team
  • Interacted with business users in gathering, analyzing and documenting the business requirements and translating them into technical specifications
  • Preparation of Software Requirements Specifications and obtaining sign off from SMEs
  • Creating User Stories/Product Backlog Item and obtaining sign-off from product owners
  • Conducting estimation meetings (Hours & Story Points) with the DEV & QA tea
  • Creating Story Cards and tracking them in Agile story board
  • Actively participated in Sprint Planning, Sprint Review & Sprint Retrospective meetings
  • Conducted / Participated in daily stand-up meetings
  • Delegated work to QA team and helped them understand the requirements and changes in the code/application
  • Preparation of Daily and Weekly Status Reports for senior management to track the System Test execution
  • Identifying the Scope of each release with Business and Operations team
  • Conducted Final Inspection Audit with QA Team for the client deliverables
  • Extensively worked with Business Users on regression testing the Monthly/Quarterly Reports and convey the errors/issues to Developers and get them fixed on tight deadlines.

Business Objects Developer/Sr Dev/Lead

Kaiser Permanente
08.2010 - 08.2016


  • The Present project KPIT-DSS is a Decision Support System helps businesses understand profitability analysis for various regions
  • Project also deals with the Membership, Patient, Encounter, Charge Item, ICD and DxCG code reporting
  • Project SCMDW – Supply Chain Management Data Warehouse involves the vendor-buyer invoice details for KP
  • Project ITCM- involves all the financial reporting for the employees.
  • Gathering Business Requirements – Gathered and captured all existing Customization/enhancements in available BO system, Involved in preparation of BRD (Business requirement document) and GAP analysis in order to include each enhancement during Upgrade
  • Understand the business data flow; worked with Business Analyst in preparing TDS (Technical Design Specifications) from SDS
  • Development: Design and develop of various reports using BO tools, Involved in Designing and Building of Universes, Classes and Objects.
  • Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes
  • Exported the Universes to the Repository to make resources available to the users
  • Developed Desk I Reports using functionalities like cross tab, master detail, drill down, using filters, breaks, alerter and formulae
  • Inserted drill filters in the Web-I reports which help the end users to run a report based on multiple selection criteria
  • Provided end user training for basic and advanced reporting skills on how to use templates to create their own reports and explained the hierarchy levels and incompatibility between the objects to make sure users take advantage of the existing universes
  • Designed, developed, tested and maintained highly complex reports
  • Trained users in viewing/scheduling the reports using the Info view and Designed security model for users to access the report
  • Developed crystal reports, which include the following features – parameter fields, formulas, conditional formatting, multiple grouping, running totals, Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts
  • Responsible for Universe Designing, Hierarchy Building for Data Analysis and applied conditions in Business Objects
  • Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle RDBMS in accordance with requirements and specifications
  • Actively involved in building the system test environment and migrated mappings from Development to System Test environment and executed code in QA environment
  • Monitored the performance and identified performance bottlenecks in ETL code as in need
  • Stress-tested the Business Object Enterprise servers to determine the ideal configuration for the best performance
  • Migrate, upgrade and test the Business Object XIR3/4.0 content/environment
  • Setup, execute, and test the assigned programs utilizing BO XIR3/4.0 WebI and DeskI tools
  • Responsible to support the issues with reports on the Business Objects Enterprise environments (Development, UAT, Test and Production)

Education

Bachelor’s - Electrical and Electronics Engineering

JNTU

Master’s - Software Engineering

WIU

Skills

  • TECHNICAL SKILLS
  • O/S: UNIX (Solaris 9), Windows NT/XP/2000/98/95
  • RDBMS: Oracle 10g/9i/8i/7x, MS SQL Server 2000/70, MS-Access, DB2 UDB, SQL
  • Plus
  • ETL Tools: DataStage 751/71/60, QualityStage V 75, DataStage PX (Parallel
  • Extender), Informatica
  • BI Tools: Business Objects 651/60/51x/40/41/42 (Supervisor, Designer, Reporter), Web Intelligence, InfoView, 3 Tier Business Objects, BO XI R2/R3 (CMS, CMC, Designer, Deski, Web Intelligence), Performance Manager (EPM), Import wizard, Report Conversion Tool, Data Source Migration Wizard, Crystal Reports, Xcelsius 2008, Tableau, PowerBI 28
  • Languages: SQL, PL/SQL, XML, HTML, Apex (Salesforce)
  • CRM Applications: Salesforce, Forcecom
  • Salesforce Technologies: Salesforcecom Platform, Apex Language, Apex Classes /Controllers, Triggers, Visualforce Pages, Apex Web Services, Workflow & Approvals, Dashboards, Reports, SOQL, SOSL Analytic Snapshots, Custom Objects, Batch Apex, Partner WSDL, Enterprise WSDL& GitHub
  • Custom Integration: Outbound Messages, Workflow & Approvals, Field updates, Reports, Custom Objects, Custom settings, Custom labels and Tabs, Email Services, Role Hierarchy, Dashboards, Security Controls, AppExchange Package & Custom Application and Sandbox data loading, Fast Forms, Conga Composer, DELL Boomi
  • Forcecom Tools: Apex Data loader, Forcecom Apex Explorer, Forcecom Migration Tool, Forcecom Excel, Forcecom Eclipse IDE Plug-in
  • Others: TOAD 76, PL/SQL Developer 70, MS Office, MS Project Plan, Github, Azure Devops, JIRA, Clarity, ServiceNow, MuleSoft

Certification

Salesforce Administrator

Timeline

Senior BA (CRM Analyst)

Penfed
06.2021 - Current

Salesforce Consultant

IBM, AT&T
05.2018 - 10.2020

Senior Business Analyst

Pepsico
09.2016 - 05.2018

Business Objects Developer/Sr Dev/Lead

Kaiser Permanente
08.2010 - 08.2016

Bachelor’s - Electrical and Electronics Engineering

JNTU

Master’s - Software Engineering

WIU
Sai Buddhavarapu