Digital Marketing Data Analyst

Pavana Gangavatiker

PROFILE

* ***** ** **********, **** working professional with passion for understanding customer challenges and

driving business growth in competitive market conditions, and solid understanding of a diverse range of Data analytics, Data Cleaning, Regression, Classification, NLP. Possess advanced proficiency in all aspects of Excel, Python and R Programming.

Data geek driven by opportunities to explore new data and ownership to build data products

Topics of interest: Business Analytics, Data Analytics, Value Engineering in IT Projects, Digital Technologies, Reporting using Tabelau

Areas of Expertise

• Data Analysis and Visualization

• Decision Analytics

• Reporting using Tabelau

• Business Analysis and Requirement Elicitation

• Software Development Life Cycle knowledge

• Computer Programming (Python, R, SQL)

• Predictive modeling and Text Mining

• Natural Language Processing algorithms

CAREER PROGRESSION

Pavana has close to 5+ years of experience in Manual Testing (3 yrs) and Data Analyst (2+ yrs)

Current: Data Analyst – SPEQTA Techonologies Pvt LTD, Hyderabad (Since Jan 2018)

• Started as Data Analyst in and worked for Same

• Analyzed and processed complex data sets using advanced querying, visualization (Tabelau) and analytics tools.

• Identified, measured and recommended improvement strategies f across all business areas.

• Used Algorithms like Regression using Python to work on customer data to arrive at the pain points.

• Working with high performance and highly successful and visible Data Analytics/Value Engineering team.

• Developed analytics solutions based on business requirments to come up with bsuiness solution.

• Participated in all phases of text mining, data collection, data cleaning, validation, and visualization.

Did Market Analysis for a Retail Store in South America

Prob Statement: Some Customers did not Write Review/Expected Increase Revenue/Optimize and Improve Delivery

Performance/Product categories where customers are prone to dissatisfaction

Approach: Used a Dashboard in Excel and Tableau to address each unique Statement.

Prepared Dataset

oCustomer related excel files

oOrder items related variables

oPayments related

oSellers related

oProducts related

Analyze the Dataset using NLP

o Remove the Accent Words

o Remove Stop words

o tokenize

o unigram, bigram or trigram

Present the Result

o Used Tabelau extensively to report.

Length of comments Vs Rating

Order status vs Rating

Visualizing Time Series data for Aggregate

Trend, Seasonality and Noise

Predicated Vs Real Sales

On time dlivery Performace

Test Engineer – SPEQTA Techonologies Pvt LTD, Hyderabad (Jan 2015 to Jan 2018)

Role: Test Engineer

Profile:

Involved in Content Management meetings for better understanding of Dashboard requirements

Validated application tables, Data with BI tool (Tableau)

Preparing reports with proper inputs.

Writing complex SQL queries to fetch Data from multiple sources

Preparing test scenarios/Test cases and circulating to Client/stake holders

Responsible Dashboard maintenance and schedule maintenance

Responsible for designing Test Cases and Preparing Test Documents.

OTHER EXPERIENCE

Freelance Projects on Digital Marketing, Hyderabad (Jan 2019 to Pesent)

Worked with Healthcare IT practice team. Prepared whitepapers titled “SaaS revolutionizing Healthcare delivery in India” and “Market readiness evaluation of Clinical Solution products” in India.

Yoga Teacher (2015 to Present)

Certified in SYASA from Bangalore. Since then have been teaching/training Yoga in the Community and have done some corporate Trainings.

Content Writing for Edureka (2017 to 2018)

Delivered topics on Python.

Boolean,Strings and Type Convertion.

EDUCATION

• Bachelor of Engineering (Electronics and Communication Engineering) - Karnataka University – 1999.

Other Courses & Certifications

Digital Marketing School, 2019.

Tableau from Edurekha 2018

Data Analytics from Analytics Path 2018

Proceding with the twitter data alanysis from web scaping to analysis as personal interest

Training in advanced Microsoft Excel Macros 2017

ISTQB Certified 2017

YOGA: YIC Certified by SYASA in 2015

Tools & Programming Languages

Programming Languages & Technologies: C, Java, Python, R, HTML, VBA, Macros, SQL & PL/SQL Databases: MySQL

Other Technologies: Testing Automation and Tabelau

Business Processes

Business Analysis, Data Visualization

Address: #403 A Block, White Fields, Kondapur, Hyderabad - 500084

Email: adhi9m@r.postjobfree.com

Phone: +91-988*******

Contact this candidate