Data Analyst with SQL,Tableau Expertise
Resume:
Krishnaveni Vipparla
PERSONAL INFO
****.********@*****.***
Phone
Address
*** ******* ** ******* **** TX 78642
PROGRAMMING SKILLS SQL
Python
DATABASES
Teradata
Oracle
SQL Server
SnowFlake
Redshift
DATA TOOLS
SnowFlake
DataBricks
PySpark
REPORTING
Tableau Desktop/Server
SDLC
Agile Waterfall
Other MS Word
MS Excel
MS PowerPoint Jira
Sonar
PROFESSIONAL SUMMARY
8+ years of professional experience in data cleansing, analysis and reporting
Used analysis and visualization tools such as SQL, Excel and Tableau to analyze data and draw reliable conclusions for providing insights to upper management
Extensive experience with requirements gathering, consolidating and analyzing data thoroughly to come to clear conclusions for recommendations.
Experience working with clients, business analysts and collaborating with technical teams in a complete software development life cycle (SDLC)
Experience working with different databases such as Oracle, SQL Server, Teradata and SnowFlake
Experienced in writing complex SQL queries for ETL to and from databases such as SnowFlake and Teradata
Used S3Fs and Pandas to read data from S3 and analyze in Python
Experience integrating relational databases and hive/impala with Tableau for building different types of visualizations
Used DataBricks and PySpark for transforming database tables and columnar files such as parquet and ORC for analysis and ETL
Partitioned huge files based on most frequently used columns to optimize data reads
Used Python libraries such as NumPy and Pandas for data analysis and MatPlotLib for visualizations.
Used internal and external stages in SnowFlake for loading and downloading data
Strong communication and presentation skills with great attention to detail
WORK HISTORY
Data Analyst Jun’2020 – Dec’2021
Client: Apple, Austin TX Employer: Modis
Enhanced Apple’s carrier and consumer store data using internal tools such as GMACC, TM and GBI
Used Excel functions such as vlookups, match, pivot tables to do data mapping, cleansing and validation for generating adhoc and periodic reports
Extracted and loaded data from/to SQL Server database tables from/to flat files
Aggregated complex store transaction data using databricks and pyspark to create visualizations in Tableau
Exported DataBricks notebooks to html for showing detailed analysis in presentations
Data Analyst
Employer: Brighter Bites, Houston TX Jan’ 2019 – Oct’2019
Created a data pipeline to load data from CSVs and flat files into SQL server tables
Experienced in writing SQL queries on Snowflake to analyze and summarize data
Analyzed data from multiple sources such as excel sheets, JSON data using Snowflake
Managed the backend SQL Server on Microsoft’s Azure cloud
Automated daily jobs to load data into backed tables using shell scripts
Data Analyst Apr’ 2018 – Nov’ 2018
Client: Target Corporation, Minneapolis, MN. Employer: RKCS Inc.
Migrated Teradata tables to hive as part of the enterprise-wide big data migration process
Created dashboards using Tableau and published them to Tableau Server
Support Registry’s ETL and reporting jobs to ensure no discrepancies and gaps are found in the reports
Policy Analyst Jul’2013 – Mar’2016
Client: Google, Hyderabad IN Employer: SERCO Private Ltd.
Created reports for business users using SQL on geo-location and presented address accuracy metrics
Created SQL queries to load/unload data into Google’s address databases created
manually by Google users via map maker
Tested if addresses inserted on Google web forms is captured correctly in the DB
EDUCATION
Bachelor of Technology, Jawaharlal Nehru Technological University, India
Contact this candidate