Summary
Overview
Work History
Education
Skills
Timeline
Generic

VAMSI PETLURI

Alpharetta,GA

Summary

7+ years of experience as a Data Analyst using Oracle, Tableau Solid working experience with SQL queries and optimizing the queries in Oracle, SQL Server Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling Excellent knowledge in Data Analysis, Data Validation, Data Cleaning, Data verification and identifying data mismatch Strong experience in using Excel and MS Access to dump the data and analyze based on business needs Experience in testing and writing SQL and PL/SQL statements – Stored Procedures, Functions, Triggers Excellent knowledge on creating reports using Tableau and Excel Proven ability in working individually or as part of a team Quick learner with the ability to grasp new technologies Strong Communication and interaction skills

Overview

17
17
years of professional experience

Work History

Data Analyst

Tennis Warehouse
02.2018 - Current
  • Converted, Cleaned, analyzed, Organized and documented large data files
  • Performs data Visualizations, data extract from different databases to create complex reports
  • Created complex visualizations using tableau for business requirements
  • Query data from database to create standardized reports
  • Analyzed operational initiatives to measure their effectiveness and impact on key performance indicators (KPIs) for both the functional department and the overall business
  • Utilized Tableau Desktop to create multiple rich dashboards that appropriately told stories of business status and success, strengths and weaknesses, and potentials; also offered at a glance, visual representations of profitability, products, and customers
  • Used advanced chart visualizations in Tableau—such as dual axis, box plots, bullet graphs, tree maps, bubble charts, and waterfall charts—to solve complex problems and to create interactive dashboards and visualizations
  • Developed and reviewed simultaneous SQL queries in Tableau Desktop to validate both static and dynamic data for data validation.
  • Setting data key constraints, testing for duplicates
  • Writing stored procedures in SQL
  • Extensively used Inner and Outer Joins, Select statements and aggregate functions
  • Performed verification and validation for accuracy of data in the monthly/quarterly reports

QA Analyst

Quality Health Solutions
02.2012 - 12.2017
  • Participated in technical reviews and walkthrough starting from the initial phases of the Software Development Life Cycle
  • Performed testing in agile scrum methodology
  • Prepared Test cases based on business requirements and tested each module of the application
  • Involved in Manual Testing to develop test cases, test scripts and various reports
  • Conducted Black Box testing on the application and validated the dataflow in the application
  • Conducted Positive/Negative Testing, Integration Testing and System Testing for different modules of the application
  • Involved in Regression Testing and UAT
  • Performed back-end testing by extensively using SQL commands to verify the database integrity
  • Working experience with Medicare, Medicaid, Vision, Dental, Pharmacy and behavioral health benefits projects
  • Experience with ICD-9 and ICD-10 codes
  • Developed and maintained the Traceability matrix between requirements and test cases
  • Tested the application for cross browser compatibility
  • Reported bugs in HP Quality Center for Issue resolution
  • ENVIRONMENT: Agile, SQL, HTML, .NET, UNIX, Oracle

QA Analyst

West Virginia Medical Institute
06.2008 - 06.2011
  • Responsible to develop system test plans, ensure that software quality assurance (SQA) standards are met and validate that business goals are accomplished
  • Performed User Acceptance, Functional, Regression and Performance testing
  • Involved in design, development and execution of Test Cases for all the testing stages
  • Maintained QA process and test methodologies to deliver better quality in shorter cycle
  • Participated Bug review, QA and Project status meetings with cross-functional teams
  • Responsible to achieve milestones in the project in respect to QA team under high pressure with tight schedules & Submit project statuses & bug reports to the QA Manager
  • ENVIRONMENT: Agile, SQL, HTML, Visual Basic, .NET, UNIX, Oracle

Education

Bachelors - Mathematics, Statistics & Economics

Masters - Mathematics

Skills

  • Database: MS SQL Server, MS Access, Oracle
  • Languages: R, SQL, PL/SQL, HTML, Python
  • Methodologies: Agile, Waterfall
  • Statistical Methods: Hypothetical Testing, ANOVA, Time Series, Confidence Intervals, Regression Analysis
  • Reporting Tools: Tableau, MS Excel
  • Testing Tools: Quality Center, QTP, Selenium, JIIRA
  • Environment: Windows, Unix
  • Other Tools: Microsoft Office (Word, Excel, Access, Power point)

Timeline

Data Analyst

Tennis Warehouse
02.2018 - Current

QA Analyst

Quality Health Solutions
02.2012 - 12.2017

QA Analyst

West Virginia Medical Institute
06.2008 - 06.2011

Bachelors - Mathematics, Statistics & Economics

Masters - Mathematics