Summary
Overview
Work History
Skills
Timeline
Generic

VARSHA GANNAMANENI

Summary

  • 8+ Years of Professional Experience as Business Analyst with retroactive understanding of Business Requirements Gathering, Business Process Flow, Business Process Modeling and have strong knowledge in SQL, Agile, Waterfall Methodologies, Jira.
  • 6+ Experience in Data Analysis, Data mining with large data sets of Structured and Unstructured data, Data Acquisition, Data Validation, Predictive Modeling, Data Visualization, and Web Scraping.
  • Knowledge of using various packages in Python like NumPy, Pandas, matplotlib, and SciPy.
  • Extensive experience in gathering Business problem statements and documenting them into Functional Requirements (BRD & FRD).
  • Expertise in handling SDLC (Software Development Life cycle) processes from requirements gathering to development, Production release and support.
  • Experience in Designing and developing Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using Unified Modeling Languages (UML) and Business Process Modeling.
  • Prowess in using Tableau, Power BI, and other data visualization technologies.
  • Expertise in conducting GAP analysis, Risk analysis, and Feasibility analysis to validate the compatibility of the existing system infrastructure with the business requirements.
  • Handled JAD sessions with management, development team, users, and other stakeholders to refine functional requirements.
  • Has been instrumental in finalizing the business requirements by conducting brainstorming sessions with stakeholders to capture business rules, business processes, and system requirements.
  • Was responsible for Managing Product Backlog to achieve the Sprint objectives, by minimizing the gap between committed and completed.
  • Proficient in creating and managing Requirement Traceability Matrix RTM for tracking and managing changes based on project's evolving needs.
  • Exposed to the technical parts of projects, such as data extraction using intermediate to complicated SQL queries, Source to target data mapping with various layers of intermediary system mapping, the design of the front-end screen, knowing the APIs which supply the front end of the program with data from Web-based services.
  • Extensive experience in data processing, system and business analysis, data mapping, testing, training, conversion, system upgrade, and post-conversion support involving strong analytical and problem-solving skills.
  • Hands on experience over various business functions, including profit and loss reports, budget forecasting, produce periodic reports, including monthly reports and balance sheets.
  • Expertise in ETL, data analysis and data visualization to derive actionable insights.
  • Adept-in creating UML documentation such as written use cases, use case diagrams, activity diagrams, sequence diagrams, state diagrams, business workflow diagrams, swim-lane diagrams, and data-flow diagrams using MS Visio / Rational Rose.
  • A working knowledge of handling business needs, prioritizing, and allocating scheduled releases depending on the importance and prioritization of requirements and defects, by developing new/modified requirements while adhering to the TFS/JIRA defect management procedure and change management method.
  • Experienced in extracting data on Tableau from various source files including flat files, excel sheets, Access files and different databases.
  • Proficient in implementation of data governance, master data management, data warehouse, reporting, dashboard, analytics, segmentation, and predictive modeling.
  • Expertise in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are following the Business Requirements.
  • Experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases.

Overview

9
9
years of professional experience

Work History

Sr. Business/Data Analyst

Chewy
05.2022 - Current
  • Gathered Business Requirements and documented into System Requirements to Identified, analyzed, researched, defined, investigated, and documented business processes for Use Case Scenarios
  • Applied the Agile methodology for the project, guided the team to document epic, stories and requirement maintenance using tools like JIRA
  • Acted as the primary liaison between the business line, operations, and the technical areas throughout the project cycle
  • Performed Gap analysis to get BRD’s business requirements through surveys, prototyping and observing from portfolio managers and UI (User Interface)
  • Actively worked during analysis phases and supported the development team during design and implementation phases of the project
  • Worked on the established Scrum methodology processes to ensure that developed capabilities met the documented requirements
  • Developed strategic partnerships with the business unit to prepare a solid knowledge base of the business line, including the business plan, products, and process' and revenue streams aimed towards problem solving
  • Assisted Project Manager to perform various project management activities such as developing & maintaining Project Plan, monitoring & controlling project tasks, scheduling iterations, identifying project key milestones, and managing change requests
  • Performed data analysis and data validation by writing simple SQL queries and used Query Analyzer, Execution Plan to optimize SQL Queries
  • Work on predictive analytics use cases using Python language
  • Conduct Statistical Modeling of data on how providers submit outpatient authorizations using Pivot Tables in Excel
  • Generating various capacity planning reports (graphical) using Python packages like NumPy, Pandas, Matplotlib, SciPy, and ggplot2
  • Create action filters, and parameters and calculate sets for preparing dashboards and worksheets in Tableau
  • Implement long-term pricing experiment that improved customer value by 25%.Use R statistical software for effective analysis by hypothesis testing to validate data and interpretations
  • Built data models and maps to generate meaningful insights from customer data, boosting successful sales efforts by 12%
  • Create functions, triggers, views, and stored procedures using MySQL
  • Integrate Tableau with google analytics to track and report website traffic users’ behavior and content value
  • Involved in creating different reports based on the change request and ad hoc requirements using Tableau, Power BI desktop and Prepared financial deliverables for funding agencies; as well as proof of concept, and solution mockups
  • Managed Parameters in Power BI Desktop for changing the source with different environments such as development, test, and production
  • Minimized defects in software application by collecting, reviewing, managing, and monitoring software application defects in JIRA through resolution as reported by various internal and external customers as Defect Manager
  • Worked with various bug tracking tools like HP Quality Center and Rational Clear Quest for the good understanding of the SDLC (System development Life Cycle)
  • Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process
  • Worked closely with Quality Assurance (QA) and testing team to facilitate and undertake User Acceptance Testing (UAT).

Healthcare Business/Data Analyst

WellMed Medical Management
05.2020 - 04.2022
  • Hands on experience running SQL queries for submission of rejected claims
  • Work with business side to keep track on claims such as voided, rejected, spliter, and misdirected claims
  • Formulate and finalize test cases with test teams
  • Created test cases for UAT, IVT and ERT
  • Most of the testing was
  • Done around healthcare insurance, dashboards, and XML reporting
  • Created XML into X12
  • Work on projects to improve the claims processing performance and efficiency
  • I have independently improved 35%
  • On success rate and reduced cost by 12%
  • Strong experience and understanding with the process flow of 837 claim encounters correction and submission on
  • Weekly basis
  • Experience with workflow configuration, design, and implementation
  • Gather new features which were then developed and implemented
  • Experience with Provider Electronic Solution (PES) Application: Claims Processing, Recipient Eligibility, Medical
  • Plan, Provider, Utilization Management
  • Analyze and work with X12 HIPAA specific EDI transactions for claims, member enrollment, billing transactions
  • Involved in TruCare authorization validations by monitoring performance and authorization
  • Document, create and update process flows, documentation, and diagrams
  • Gather Business/Functional user requirements, created Use Cases as per user requirements, developing/designing
  • Diagrams such as Activity, Class, and or Sequence diagrams, and in addition to creating Business Requirements
  • Document (BRD)
  • Facilitate meetings with stake holders, Business owners, developers, system analyst and testers to collaborate
  • Resource allocation and project completion using MS Project
  • Write SQL scripts to extract data from the SQL Server for data clean-up
  • Prepare custom reports and performed SQL query, data analysis and verification on MS Access
  • Design mock-ups of various reports and the UI to communicate visual data flow to the Business Users via
  • Presentations
  • Track progress and notified management of issues that require escalation, and resolved the resolution of system and
  • Process issues
  • Perform feasibility & gap analysis, adaptability & risk analysis; document to identify business critical & high-risk
  • Areas
  • Coordinate various projects and conducted daily Scrum meetings, Planning Sessions and Retrospective Sessions
  • With offshore and on-site teams present in multiple locations
  • Coordinate with QA Team for testing activities across multiple systems and managed Conversion test execution
  • Work with the business Team to review UAT validation scenarios and execute the UAT test cases
  • Resubmit the rejected claims to manually fix the errors and placed them to the FTP location for business to pick for
  • Adjudication process
  • Create and execute a detailed UAT Test Plan aimed at capturing the client's core requests
  • Develop and maintain strong relationships with both internal/externals customers at the senior management and
  • Executive level in order to influence project teams and gain consensus on selection of the most viable solutions
  • Translate business requirements into functional requirements and approaches for developers
  • Provide management support to the off-shore End to End integration/ Regression Test Team
  • Workflow documentation and comprehensive training to the healthcare clients
  • Provide support for the Successful Releases of Multiple Projects.

Sr. Business/Data Analyst

CBRE
09.2019 - 04.2020
  • Organized requirement gathering sessions with business stakeholders and development teams to review functional and technical requirements
  • Responsible for documenting the requirements for the project, features, defects, and enhancements
  • Conducted GAP Analysis by brainstorming with Architects, Business users and SMEs, to identify research, analyze and define key issues of the Business flow
  • Wrote user stories using agile/scrum methodology and performed tasks and backlog intervals
  • Used JIRA for Sprint story creation, tracking and updates for the entire sprint
  • Involved in the inception phase to understand the Scope of the Project, feasibility of the implementation and define the risk factors involved in the project
  • Performed JAD session with both technical and non-technical sides to understand and finalize the exact need of Business
  • Implemented different methodologies for the project, worked with the Product owner to create product backlog and requirement maintenance using tools like JIRA
  • Performed Root Cause Analysis on issues found in production, tracking the data flow to identify where the issue is arising
  • Involved in Developing and maintaining the project plan using MS Project and JIRA
  • Created Reports/Visualizations/Dashboards in Power BI using filters at Visualization level/page level/report level
  • Involved in preparing test scripts and testing the application
  • Reviewed the data model and reporting requirements for Congo’s Reports with the Data warehouse and Reporting team
  • Worked in a Waterfall environment allowing teams to deliver projects piece-by-piece and make rapid adjustments as needed
  • Used NumPy, Pandas, matplotlib, and SciPy in Python for developing various algorithms
  • Utilized Weka to split the dataset into training and test sets
  • Created Reports and Charts using Data visualization tools such as Power BI
  • Involved in writing, testing, and implementing triggers, stored procedures, and functions at the Database level using MySQL
  • Used Excel in setting up pivot tables to create various reports using a set of data from an SQL query
  • Performed slicing and dicing of data using SQL and Excel for data cleaning and data preparation
  • Developed root cause reports to address problems with customer conversions, successfully revealing insights that boosted conversions by 32%
  • Analyzed the customer web trail on a real-time basis by using Google Analytics to get insight regarding pages per visit, average visit duration
  • Worked with SQL team to test various reports and ETL load jobs in development, QA, and production
  • Responsible for submitting the bugs into the Test director depending upon their priority
  • Participated in regular status update meetings with the Project Management team and QA Team meetings
  • Responsible for performing Functional, Regression and User Acceptance testing reports.

Business Analyst

Ditech
10.2018 - 08.2019
  • Interacted with the Business Stakeholders and marketing team to identify customer requirements and documented the requirements that can enhance ALLY's market position
  • Documented BRD’s (Business requirement documents) and converted them into FRD’s (Functional requirement documents) to Solve Online Transactions Issues for End Users
  • Teamed up with both internal and external software development groups to provide functional requirements specifications in form of use cases, business process flows, and prototypes and management reporting requirements
  • Conducted JAD sessions with business users and SMEs to understand current state, gathered customer requirements through surveys and interviews (group and one-on-one)
  • Formulated and defined systems scope and objectives through research and fact-finding combined with an understanding of applicable business systems and industry requirements following RUP
  • Developed Use Cases (UC), system specifications, navigation flows and coordinated with the design team
  • Actively involved in validating the processes and applying the framework throughout the agile
  • Worked with diverse clients including Depositories, Global Custodians, and Investment Banking Institutions
  • Prepared FRDs that help drive the design of the infrastructure necessary for the organization to meet new CCAR reporting requirements
  • Monitored the LOBs functional Issues in the wholesale application and provide them the solutions for how to move forward
  • Worked with the ETL team for the elicitation of data and involved for various operations to retrieve data, etc
  • Prepared Logical Data Models that contain a set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the relationships between the data elements to analyze and document the Business Data Requirements
  • Involved in implementing the Data Warehouse process to replace the current process of using Excel to query transactional databases
  • Reviewed loan applications and analyzed data required to process loan documents and performed validation to ensure loan documents are transmitted to appropriate departments
  • Generated data mapping documents from production databases to the warehouse and from the warehouse to the policy and claims marts
  • Responsible for managing Test cases to cover overall quality assurance using Quality Center and provide status reports to Sr
  • Management and project team
  • Worked extensively on designing Test Plan, Test Cases for the User Acceptance Testing and performed manual testing of the application as part of stress and performance testing
  • Worked closely with development team and ensured that all the requirements are handed off to UAT and provided the constant support to these team whenever any issue has aroused
  • Interacted with Quality assurance team for Integration & ensured code delivered on time.

Business/Data Analyst

Brio Technologies Private Limited
11.2015 - 06.2018
  • Served as a liaison between the business team and the technical team by identifying, understanding, and documenting their needs
  • Documented various Business Requirement Documents for Current account, Savings account, and Term Deposit account in newly developed application for identifying the gaps as per the requirements
  • Conducted workflow, process diagram and GAP analyses to derive requirements for existing system enhancements
  • Responsible for the analysis of customizing the BPS (Basis points) Risk Management product with involvement through the whole SDLC
  • Prepared High Level Logical Models and supporting documents containing the essential business elements, detailed definitions, and descriptions of User to analyze
  • Involved on different modules like Loan Transaction, savings Management and Recurring Deposit and Fixed Deposit Transaction systems for stakeholder interactions
  • Worked with other LOB on initiative of identifying gaps and discrepancies in regulatory reporting application
  • Designed and Developed ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems feeds
  • Performed Data Cleaning, Feature Scaling, and Feature engineering using Python packages such as Pandas, NumPy, Matplotlib, and Scikit-learn
  • Utilized Power BI to create various analytical dashboards that help business users to get a quick insight into the data
  • Worked on Stack driver to Monitoring, log, and diagnostics for applications on the Google Cloud Platform
  • Used Spark shell for interactive data analysis and process using Spark SQL to query structured data
  • Performed database testing on the data warehouse by using complex SQL queries in SQL Server to validate the data present in it
  • Created Source to target data mapping documents like Data warehousing, Data mapping and data modeling
  • Strong experience in conducting Functional Testing, User Acceptance Testing (UAT), and System Integration testing (SIT)
  • Prepared Test plan, Test Scenarios, Test Scripts and ensuring accurate test coverage of requirements and business rules as mandated by the QA process.

Business Analyst

Careator Technologies Pvt Ltd
07.2014 - 10.2015
  • Gathered User and Business level requirements for Stakeholders from various departments like Accounting /Finance and Information Systems
  • Designed the business requirement collection approach based on the project scope using AGILE methodology
  • Interacted with the compliance department and SMEs in the laws/act of compliances
  • Conducted KYC/AML investigations ensuring that risk details are complete, accurate and current with a comprehensive understanding of investment products and global/local procedures
  • Effectively conducted AML /KYC formality reports on questionable accounts and transactions
  • Performed the required KYC screenings on customers documenting the information obtained on the client's as required by global KYC procedures
  • Performed additional tasks as assigned, improving the effective administration of the AML and KYC Policies
  • Gathered Functional specs to help compliance officers to implement CIP (Customer Identification Program), CDD (Customer Due Diligence) and EDD (Enhanced Due diligence) process
  • Ensured that information obtained is consistent with BSA/AML policy
  • Prepared the ETL mapping specifications to extract data from the existing system to the AML compliance data marts
  • Provided Data Mapping Documents by MS Excel for the automation rating risk score purpose
  • Implemented Workflow Diagrams and Use Case Diagrams by MS Visio to help IT team to get a better understanding of the customized requirements
  • Coordinated in writing test plan, test cases and test scripts in HP Quality Center
  • Assisted the QA team in reviewing test cases, test plans and tested the final application for usability testing to verify whether all the requirements were met.

Skills

  • Technical Skills:
  • Project Methodology:
  • Waterfall, Agile and SCRUM
  • Visualization and architecture Tools: Microsoft Visio, Power BI, Tableau
  • Database Tools: SQL Server, Oracle, DB2, MS access
  • MS Office Proficiency
  • MS Project Proficiency
  • Testing Tool: HP ALM, JIRA, HP QTP, Load runner
  • Others Skills: Data Cleaning, Data Wrangling

Timeline

Sr. Business/Data Analyst

Chewy
05.2022 - Current

Healthcare Business/Data Analyst

WellMed Medical Management
05.2020 - 04.2022

Sr. Business/Data Analyst

CBRE
09.2019 - 04.2020

Business Analyst

Ditech
10.2018 - 08.2019

Business/Data Analyst

Brio Technologies Private Limited
11.2015 - 06.2018

Business Analyst

Careator Technologies Pvt Ltd
07.2014 - 10.2015

Similar Profiles

CREATE PROFILE
VARSHA GANNAMANENI