V K Prasanthi Sistla

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

Junior Data Analyst with experience in seeking and collecting relevant data and documenting the information. Gathering data, interpreting the statistics utilizing SQL, Python, Excel to analyze large sets, writing reports, designing charts, graphs using tools like Tableau, Power BI and working with cross- functional teams for designing and implementing data quality checks. EDUCATION

Post Graduation Diploma in Business Analytics and Business Intelligence University of Texas, Austin 2019-2020

Bachelor of Technology (Mechanical Engineering)

Jawaharlal Nehru Technological University, Kakinada 2007-2011 TECHNICAL SKILLS

Languages/ Databases: SQL, Python (Pandas, NumPy, Statsmodels, Matplotlib, Seaborn), R, JavaScript, C#.Net, VB.Net

Tools/ Frameworks: Tableau, PowerBI, Excel, Google Colab, Jupyter Notebook, Windows, VS Code, R Studio, SSIS, SSRS

PROFESSIONAL EXPERIENCE

Data Analyst Intern at KPMG (Remote) Mar2023

• Managed to help the organization to improve their marketing strategy for new customers based on the deep analysis of the existing customer data.

• Suggestions were given as there were data quality concerns like data accuracy, completeness, consistency, currency, relevancy, validity and uniqueness on the given data.

• Implemented methods in Excel for data cleaning, removing duplicates, formatting, VLOOKUP, HLOOKUP to summarize the data.

• Transformed the final data based on Age, Wealth segment, state of residence, gender of the customers using Pivot Tables.

• Dashboards were prepared using bar graphs, pie charts and line graphs in POWER BI to summarize to present the analysis.

Projects at University of Texas, Austin 2019-2020

• Loan Prediction - Python: EDA (Exploratory data analysis) has been done on the data using python and all the missing values and null values were handled using statistical data. Using Predictive analysis techniques 68% of the applicants were qualified for getting a loan.

• Classification of Diabetic Patients: Analyzed and interpreted the data to identify the trends and patterns using Python to provide insights that are helpful for providing precautions for the patients regarding their health.

• Almost 77% of the patients are identified as non-diabetic depending on their Glucose and blood pressure levels.

• Customer and Revenue analysis in Tableau: Built out the data and reporting structure from the ground using Tableau and SQL to provide real-time insights of the restaurant data and business KPIs.

• Operational reports were generated in tableau providing the statistics of frequently visited customers and some special discounts provided to them basing on their visit to increase the business revenue by 30%.

• Analyzing Airlines data in Power BI: Imported raw data in excel sheet to PowerBI cleaned and modified the data with appropriate statistical values and created a dashboard showing around 17% of total flights are travelling least distance and finding the airline providing more than 50% of their services.

Xerox Corporation 2013-2015

TCS Hyderabad – Systems Engineer

• Improved the performance of the application by 30% using SQL Queries, stored Procedures, functions, triggers, view and scripts to get the shipments data into dashboards.

• Automated pipelines (SSIS) for processing the shipment data through different sources (CSV, Excel, Flat files etc.) and feeding them into the related fields in the MS SQL database and aggregated results to multiple BI dashboards for different stakeholders which improved the performance of the application by 60%.

• Minimized the response time by 50% to rectify the errors that encounter while the running the packages and reporting them through e-mails.

• Analyzed and automated the process of generating reports on weekly and daily basis using SSRS. Apollo Hospitals 2011-2013

TCS Hyderabad – Asst. Systems Engineer

• Analyzed large volumes of medical data which includes validating and consolidating large datasets and created a new module. All the emergencies in the hospital are consolidated and maintained as a dashboard for quick medication which improved the functionality of the hospital by 50%.

• Improved the performance of existing modules for other services of the hospital by 30% with enhancements, change requests and bug fixes.

• Worked on gathering requirements, understanding the business requirement and developed a web application with 3-tier architecture.

Contact this candidate