Data Analytics Analyst

Gomya Chowdary kollu

ad5p9l@r.postjobfree.com 937-***-**** Linkedin:gomya-chowdary

SUMMARY

Certified Google Data Analytics professional with 2+ years of experience in delivering actionable business solutions through statistical analysis, data analytics, and data visualization by utilizing SQL, Tableau, and Excel. Expertise in creating user stories, gathering input from stakeholders on business requirements, and running daily sprint meetings.

SKILLS & CERTIFICATIONS

●Programming languages/Tools: SQL, Python (NumPy, Pandas, Matplotlib), Tableau, Power BI, Excel

●Technical skills: Data Analysis, ETL, Data Visualization, Statistical Analysis, Hypothesis Testing, EDA

●Others: Microsoft SQL Server Management Studio, Azure Databricks (Spark SQL)

●Certification: Google Data Analytics Professional by Coursera

.

WORK EXPERIENCE

Vtech Infotech LLC, Dallas, US Nov 2023 - Present

Role: Data Analyst

Client: US Retail Chain

Performance Dashboard:

Created Tableau dashboards to track item, brand, and store performance using key performance indicators (KPIs) such as net gross profit, brand penetration, average basket size, etc.

Wrote SQL queries and scheduled them for weekly data refreshes in Azure Databricks, resulting in an 80% reduction in data operations.

Incentive Offer Campaign Analysis:

Implemented a customer retention campaign by targeting individuals with a decrease in shopping frequency over the past two years and offered them with promotion codes; resulting in a 13% increase in sales and an 8% improvement in customer retention.

Wright State University, Ohio, US Jan 2023 - July 2023

Role: Business Analytics Consultant

Client: Recruiting Industry

Performed EDA on 50k job listings using SQL and Excel and identified a list of customers to target for improved profitability based on KPIs like % Clicks, Cost Per Click, etc.

Segregated the above customer list in the form of user profiles like customers who are wary about cost, who are not, etc. and presented the findings to the marketing team.

Randstad, Hyderabad, India Dec 2020 - Dec 2021

Role: Business Analyst

Facilitated daily team stand-up calls to track project progress; discuss project milestones, key accomplishments, ongoing risks and how to mitigate them.

Collaborated with the stakeholders to gather requirements, breakdown those requirements into user stories, and assigned them to team members based on priorities.

Automated multiple recurring and ad-hoc reports of key reportable metrics to increase efficiency and reduce the risk of manual error using Excel analytics like VLOOKUP, pivot tables, charts, etc.

OTHER EXPERIENCE (DATA ANALYTICS PROJECTS)

Developed a Tableau dashboard on global tourism with insights on key indicators like year-over-year growth, average yearly growth, and inbound/outbound tourism at various geographic levels.

Designed interactive Tableau dashboard showing 50% annual rise of unicorns in India over 10 years along with KPIs.

EDUCATION

Wright State University, Ohio, US July 2023

Master of Science, Computer Science

Course Work: Data Structures, Algorithm Design and Analysis, Advanced Database Systems, Big Data with Hadoop

BV Raju Institute of Technology, Hyderabad, India May 2021

Bachelor of Technology, Electronics and communication Engineering

Contact this candidate