VAISHNAVI BOLLABOINA

adx8j8@r.postjobfree.com +1-972-***-****.

Analytics professional with 5+ years of working experience in various domains and providing business intelligence to stakeholders. Delivering end-to-end analytical projects and acting as a BI expert by providing solutions related to forecasting, statistical analysis, building data pipelines, project management, stakeholder management and dashboarding.

Professional Experience

Dynamic Technologies- IBM Aug ‘22- June ‘23

Client: Kaiser Permanente

Pleasanton, CA.

Data analyst and BI report developer

Worked on CRIZ Cyber Recovery Isolation Zone to analyze the data and identify applications that are currently breached or are vulnerable for a breach. Dashboards and reports for DR Enablement adhering to HIPAA compliances and check if they are ready for migration to cloud.

Analyze large and complex datasets, identify anomalies, trends, risks, and provide useable insight to improve internal controls and operations.

Extensively worked in writing complex SQL and analytical queries, data engineering, relational data modeling, data cleansing, data discovery and data manipulation.

Creating and maintaining various database objects and sql queries including logical and physical data models, DML, DDL, DCL, tables, views, synonyms, users, sequences, materialized views.

Wrote several complex sql queries, inline queries, co-releated and non-co related sub queries utilizing various group and analytical functions.

Performed Data visualization, Data reconciliation, quantitative analysis and data validations, created and managed numerous ad-hoc Power BI reports, dashboards, scorecard and visualizations for stakeholders and administrative staff that effectively and efficiently provide summarized results, analysis, conclusions to decision makers, with supporting details.

Developed Power BI data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, etc. using Power BI functions like calculations, parameters, filters, calculated fields, groups, sets and hierarchies etc.

Collaborated with various teams Network, DB, App Owners, Integrated Medical System (IMS) teams and other internal teams to understand, plan, analyze and execute the reporting requirements.

Worked to a great extent with the design and development of BI reports / dashboards using DAX Functions and visualizations like Dual Axis, Bar Graphs, Scatter Plots, Gantt Charts, Pie-Charts, Bubble Charts etc.

Trained new staff on App data dictionary and reports.

Prepared analysis, presentations and reports to explain data and findings to the project team.

Developed and optimized numerous SQL queries for ad-hoc reports.

Performed performance tuning, troubleshooting on SQL queries, wrote several complex queries and subqueries.

Participated in scrum planning, scrum retrospective, sprint and other scrum activities.

Wrote several DML, DDL statements and scripts to create database objects like tables, views, indexes etc. and to manipulate date. Involved in project planning and execution including requirements sessions, technical design, development, testing and delivery of BI solutions.

Extensive experience in gathering and clarifying requirements and verifying requirements in both face-to-face with Business as well as in virtual meeting envs.

Have excellent interpersonal, verbal, and written communication skills.

Ability to work independently as well as a team player.

Identifying data quality issues and their cause. Discuss issue with user and propose data quality check rule to highlight impacted items.

Presented the data in a meaningful, understandable visual format to the users.

Verifying the new identified business rules with the business/CAs.

Integrating the new identified and validated rules in the automated process for generation of analytical report.

Working with Business users to identify root causes for data gaps and negative patterns of data and developing corrective actions accordingly.

Understanding the BI Reporting needs of users and implementing them in the design and code.

Identifying, Analyzing and interpreting the patterns of data issues in the complex data sets of various modules of the system.

Finding the technical solution and business logic for fixing the missing or incorrect data issues identified.

Writing & maintaining the Data Mappings and Transformation logics to fix missing and incorrect data.

Writing SQL scripts to implement the logic to fix the data issues and enhance the data quality.

Assisting programmers with writing ETL logic and resolve any data or business process related question they have.

Enhancing PBI reports and dashboards analyzing its query and modifying the queries as per business need.

Addressing data issues identify data and clarifying with Business about the strategy to fix the issues and presenting complex identified data information in an understandable manner for the Business creating Ad hoc data reports.

Intellisoft Jan ‘19 – July ’21

Role: BA/Data Analyst

The objective of this project was to enhance the dashboard of DataMorphix.ai so that they can provide services along with the platform for data analysis to the customers in various sectors such as banking, insurance, hospitality and some other ones.

•Used Jira keep track of the User Stories, tracked the progress of the sprint by maintaining Burn Down and Burn Up Charts.

•Planned for sprints by calculating the Estimated Velocity using Commitment driven planning and Velocity driven planning techniques as per the requirements.

•Helped improving the process and practices by identifying improvement areas through retrospective meetings.

•Ensured positive and frequent interaction between the Development Team and the Product Owner.

•Facilitated Planning, Daily Standups, Reviews, Retrospectives and conducted sessions to make sure the development team understands all the Ceremonies.

•Coached and guided the dev team on values, pillars, and principles of Scrum.

•Used JIRA for Project Management and visualization for KPI’s, Burndown, Burnup charts.

•Assisted Product Owner in setting up Acceptance Criteria for the user stories, created test plans, and recorded test results for all the user stories.

•Facilitated Agile games for better collaboration among team members.

•Worked with PO for Product Grooming/Refinement in re-prioritizing user stories.

•Assisted the Product Owner in prioritizing backlog.

•Identified Dependencies among other teams including external and internal dependencies and participated in several scrum of scrum meetings to resolve the dependencies.

•Created numerous user stories, bugs and epics on Jira. Generated burndown charts.

•Utilized Power BI to analyze and present demographical analysis of user information using functions in Power Query and graphs like bar, chart, pie, column and multi-axis graphs.

•Used MS Visio and lucid charts to create Mockups, wireframes.

•Used HTML/CSS, Python, SQL, Tableau.

•Helped integrating Data Machine learning pipeline for Dynamic and interactive UI pages.

•Strong understanding of Web services and helped in testing web services.

•Removed impediments for the teams and escalated the issues as appropriate.

•Played a role in executing functional Testing, System Integration Testing and User Acceptance Testing.

•Maintained Scrum artifacts like Sprint burn down chart, Sprint burn down up, and Impediment List.

•Analyzed the Iteration Burn Down charts and tracked and reviewed defects.

•Coached and mentored team to adopt agile practices, adopted agile and various practices to ensure team understands agile practices and values.

•Worked on challenges and impediments like team issues where the team is supposed to be self-organizing, but the cultural background of the team members made hard for everyone to share responsibility without being authoritative.

•Facilitated the estimation of efforts required using Planning poker technique along with Scrum team.

•Worked with the product owner during the Sprint Review Meeting for the Potential Shippable Product Increments (PSPIs) and helped decide which features are DONE as per the acceptance criteria.

•Provided orientation for newly on-boarded business resources on understanding user stories and acceptance criteria, the requirement hierarchy (Themes-Features-Epics-Stories), backlog maintenance (prioritizing, grooming).

•Worked closely with the Business DevOps Domain including the regression team, performance testing team and change management team to ensure timely releases and to create cadence and get approval for Ramp up plans.

•Identified dependencies and documented the existing workflows, IT systems, user profiles, groups and permissions, reporting needs and all processes end-to-end.

•Worked with the environment team to identify and resolve the environment issues that the Devs/QAs raised.

•Extensive understanding and knowledge of value stream mapping.

•Worked extensively with PM tools like JIRA and content management tools like Confluence

•Address ad-hoc analytics requests and developed various complex reports in excel and Power BI as per requirement using DAX functions, formulas, Vlookups and pivot tables.

•Wrote several functional and technical documents and SOP's.

Amazon.com Aug’14- Aug’16

Role: Business Analyst/Transaction Risk Investigator

Chargeback Management Systems

Scope: Is to Enhance the legacy Chargeback Management Application by integrating Merchant Profile and Fraud Analyst Application enhancement includes Accounts Chargeback Prediction for prevention, Customer Account charge back pattern, suspicious and fraud patterns using ML Predictive Models along with a few more features so that the time consumed for working on one account or chargeback was reduced increasing the efficiency and productivity i.e Task resolution time was reduced by 50%.

•Functioned as the liaison between the line of business and the technical teams throughout the project life cycle. • Conducted Joint Requirements Planning (JRP) sessions with the Subject Matter Experts (SME) and the key stakeholders to understand business processes and the functionalities in detail.

•Conducted Walkthroughs and Meetings involving leads from Development, QA, Database and Technical Support teams to validate the Budget Planning.

•Conducted GAP analysis for identifying improvement areas from legacy systems to the current processes.

•Analyzed the risks involved by conducting SWOT and Cost-Benefit Analysis in Microsoft Office Environment

•Validated data to ensure the quality, accuracy, completeness and integrity of data obtained from various sources

•Facilitated JAD sessions, Questionnaires, Document analysis and Interviews with the stakeholders for the requirements elicitation.

•Conducted Brainstorming sessions for refining the requirements in coordination with multiple teams.

•Performed Interface Analysis to understand the dependencies among the various distributed teams.

•Dealt with loosely coupled system and used SOA architecture to interact with other Web Services and databases.

•Analyzed the Databases of the various teams using SQL Queries and performed Data Mapping.

•Performed Risk Analysis to identify the project critical success factors and prioritize functional requirements.

•Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance testing.

•Conducted Triage calls, tracked, logged and prioritized the defects based on the severity and criticality.

•Created Unified Modeling Language (UML) diagrams including Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Entity relationship diagrams and Use Case Diagrams.

•Created Static Prototypes using HTML and CSS for an overview of the Graphical User Interface.

•• Developed high level requirement documents Business Requirement Document (BRD) and consulted the technical team and developed the detailed System Requirement Specification (SRS) document.

•Used UDDI to identify and study relevant web services and web methods required for the application.

•Modelled complex Web Orchestrations involving multiple web services from distributed teams.

•Implemented OLAP techniques, performed Drill analysis, Slicing & dicing on the data using SQL Server and created Reports using Tableau.

•Designed and implemented SQL queries for QA Testing and Report / Data Validation.

•Designed the Test Plan and Test Cases for all processes and Web Services.

•Used ServiceNow for main ticketing and managing change, worked through service requests and incidents, and made tasks.

•Host CAB meetings, data analytics, reporting, and overall Change Management maturity

•Collaborated with the Quality Assurance team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured that appropriate documentation is in place.

•Supported during UAT and deployment. Environment: MS Office, Windows 7, SQL Server Management Studio, Oracle, Service Now, Excel, HTML, Visio XML, VB, WEB Services, Postman, TFS, Java, .Net, Python, JIRA, Tableau

Environments:

Toad, APC (oracle Advance Product Catalog), MS Excel, Visio, Power point, QuoteEdge (quoting tool), Windows Task scheduler, Sharepoint (for publishing analytical reports), ALM(for Issues and enhancement tracking). My Sql, JIRA, SVN PL/SQL, TOAD, ERStudio Data Architect 8.5, TRUmigrate (ETL tool), SQL server,11g, Integrated Medical System (IMS), Power BI, SQL Developer, MS Office ( Excel, Word and Power Point), Github, Data Morphix, Confluence,Visio

Internship IIT or Indian Institute of Technology

Role: Intern

Worked as an intern on a live project – Built and published Tableau reports utilizing Data Blending, multi-level hierarchy, Table Calculations, Parameters, Graphs and Actions.

• Built Tableau advanced charts using geo maps, Gantt charts, Pareto charts, scattered plots for providing multidimensional views.

• Experienced in creating filters, quick filters, data source filters global filters, context filters, user filters, actions and creating.

• Dashboards for key performance indicators.

• Expertise in developing Reports / Dashboards with different Analytics Views Drill-down / Dynamics, Pivot table, Chart, using MSExcel.

• Worked on csv, excel different types of files for the data cleaning and data analysis.

• Interpreted statistical test result and model results and communicate key findings to the market team to facilitate data driven decision making. • Analyzed the data file and checked for any missing values - Data wrangling, EDA.

Education

Master of Sciences: Aug ’16 — Dec ‘19

Statistical Analytics Computing and Modeling

Texas A&M Kingsville

Bachelor of Technology:

Information Technology Aug ’10 — May ‘14

Jawaharlal Nehru Technological University

Research paper

• Contributed a Chapter to the Book Ranked Set Sampling, by Carlos Bouza-Herrera. Published by Elsevier. The chapter is Forced Quantitative Randomized Response Model Using Ranked Sets. • IBM Data Analysis with Python Certification: https://www.linkedin.com/feed/update/urn:li:activity:6790155620675833856/

Skills: Data/Schema preparation, Data Exploration, ETL, Domain expertise, Statistical knowledge, Problem Solving, Software Skill Set.

Database

SQL Server, MySql,DBMS

Tools

Power BI, Jupyter, Integrated Medical System (IMS), SQL Developer, Toad, Microsoft Office ( Excel, Word, Powerpoint, Access), Tableau Desktop, Google Suite, Excel proficiency, Visio

Operating Systems

MS DOS, Windows

Programming languages

SQL, MYSQL, Stored Procedures, Triggers, Views, HTML, R, Python, Machine learning Algorithms Supervised and Unsupervised, Spark, Pandas, Scikit learn, NumPy, SciPy, Matplotlib.

Contact this candidate