BHARGAVI VIJAY
737-***-**** • adznwi@r.postjobfree.com
PROFESSIONAL SUMMARY
Over 5+ years of experience in Data analysis and Quality assurance
* ***** ** ********** ** design and development of reports using Tableau, SQL and Data analysis with excellent problem solving and strong technical skills.
Expertise in creating dashboards and reports.
Utilized multiple Tableau tools including Tableau Desktop, Tableau Public and Tableau server.
Created and maintained various reporting dashboards to consolidate multiple views for internal and external purposes.
Wrote SQL scripts and queries to extract data from various data sources into the BI tool, Visualization tool.
Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
Along with Reporting, Possess good knowledge of Software Testing.
Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop.
TECHNICAL SKILL S
Data Analytics Tool
Tableau, Power BI, Google Data Studio, Excel
Database Administration
SQL Server, DB2
Programming Language
SQL, Python
Project management Tool
JIRA, Confluence
EXPERIENCE
Data Analyst Astreya Partners - Bangalore, India
Nov 2021- May 2022
Converted data into actionable insights and built out reporting infrastructure to provide real-time insight into the product and business KPIs.
Strong experience on building dashboards in Tableau and Google Data Studio. Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.
Created and maintained various reporting dashboards to consolidate multiple views for internal and external purposes.
Reviewed Business requirements and prepared the dashboards as per the requirements and extracted data from different sources connecting them and used the same to create dashboard.
Reported monthly data analysis findings to upper management to use in making
organizational decisions.
Present detailed reports about the meaning of gathered data to team and help them identify scenarios utilizing modifications in the data.
Created different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
Experience in writing SQL scripts and queries to extract data from various data sources into the BI tool
Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
Operations Analyst Aeronautical Development Agency - Bangalore, India
Dec 2020- Nov 2021
Collected and Analysed data to identify trends, forecast, and provide additional insights using advanced analytical methods
Prepare and deliver data visualizations based on performance to leadership team, translating analytic insight into actionable recommendations
Strong Experience in using of Tableau Desktop and Powe BI for creating dashboards and data visualization.
Providing accurate reports and presentation using both internal and external data, highlighting the findings and recommending changes.
Worked closely with all SDMs/Project manager to understand and maintain focus on their analytical needs, identifying critical metrics and KPIs and delivering actionable insights to relevant decision makers.
Preparing weekly, monthly and quarterly performance metric reports, including graphs, charts, and analysis
Proficient in working with large data sets
Strong experience with querying relational database systems to collect data.
Experience in all Microsoft office packages and Google suite for effective report, tracking and database management.
Graduate Student at University of Arkansas, Operation Management Aug 2018 - May 2020
Reduce process time of logging-in to client/Virtual network through local desktop using Lean Six Sigma DMAIC process: Prepared project charter, Measurement plan, SIPOC Diagram, Stratification Metric. Analyzed data using histogram, pareto chart and pivot table. Selected solution and implemented the solution using pilot test plan.
Developed project plan for Online video streaming website development: Created charter, risk plan, work breakdown structure with time and cost using MS project planner, change registry, procurement plan etc.
Tested web application (University of Arkansas Fundraiser Website) using Selenium WebDriver with JAVA and TestNG framework: Analyzed the requirements, Developing Test Scenarios, Test cases and Test Data, Applied Page Object Design Pattern for writing automated test cases in Java, Performed Smoke, Regression and Acceptance testing.
Quality Assurance Engineer HSB Soft Technologies - Bangalore, India
Oct 2011 - Nov 2015
Gather and understanding the business requirements
Preparation of test scenarios, test cases, test executions and test reports.
Strong Experience in Automation web application testing using Selenium WebDriver with JAVA and TestNG framework.
Experience in Automation Testing of different applications using Selenium, WebDriver across multiple Web Browsers and Operating Systems platform.
Managing test management tools ALM for uploading requirements, mapping test cases, logging bugs/defects and reporting test executions
Managed Defect tracking and Bug Reports using Bug Tracking Tools.
Preparation of test plans, test strategy and test effort estimation
Expertise in writing, maintaining, executing test cases and test scripts, analysing bugs and interacting with development team in fixing the errors.
Create and maintain automated test scripts to support regression test library using Selenium WebDriver
Participate in the defect triage/resolution calls and testing status meetings
Good exposure to STLC and SDLC and experience in understanding the business requirements to deliver.
EDUCATION
University of Arkansas
GPA 3.5/4
Arkansas, USA
M.S. in Operations Management
Coursework: Supply chain, Lean Six sigma, Strategic and Project Management, Data Analytics, Finance, Advance Excel Analysis, Operation Research.
Visvesvaraya Technological university (VTU)
Bengaluru, India
B.E. in Electronics and communication
GPA 3.2/4