Data Analyst Social Media

SAI KIRTHI ABBURI

Email: **************@*****.*** Phone: +1-512-***-****

Experienced Business/Data Analyst with a demonstrated history of working in the technology industry performing Statistical Data Analysis, using SQL, R, Python and BI tools.

EDUCATION

TEXAS A&M – COMMERCE, TEXAS

Master of Science in Business Analytics Dec 2019 GPA: 3.88/4 ST. FRANCIS DEGREE COLLEGE – HYDERABAD, INDIA

Bachelor’s in management studies (specialization in Marketing) June 2015 GPA: 3.5 ACHIEVEMENTS

• Managed global and local a variety of accounts ranging from F&B chains like Nandos, telecom giants like Airtel Hyderabad Marathon, ET Women’s Forum and CNBC.

• Formulated and devised strategies that ultimately resulted in an organic trending of a campaign on twitter with nearly1.75 million impressions in a day and 75k clicks purely out of organic reach.

• The revamping and reformulating of several strategies pertaining to accounts which led to an 88% increase in lead generation and a 23% decrease in cost per lead.

SKILLS

Coding: Python, R, SQL, Advanced SQL, SPSS, Hadoop, Hive, Salesforce, JavaScript, DAX measures Management and Strategy – Agile, Jira, Content Management, Brand Building, digital media planning and strategy Analytics: Linear Optimization, Decision Modelling Visualization: Power Bi, Tableau, Excel VBA Macros, R-ggplot, Mathematics: Advanced Statistics (Descriptive, Inferential, Predictive, Distributions), Econometrics, Probability Other skills: ETL, Microsite content, Design, Microsoft office suite, A/B testing, Google Analytics, Adobe analytics suite, Azure dev-ops EXPERIENCE

TECHNICAL BUSINESS ANALYST ARROW ELECTRONICS JUNE 2019 – PRESENT

• Built Power Bi dashboards to track status of orders and order volume for arrow.com using data processed from an SQL server, Hadoop. Utilized gateways to update data periodically.

• Successfully recognized and resolved the gaps between new and existing business process and applications by issuing tickets on Jira

• Prioritized and maintained the software backlog with expert examination of data based on ROI and the existing business demands

• Implemented data mining techniques Like Market Basket Analysis, decision trees to track the behavior of premium customers

• Designed and developed interactive Power BI visualizations for business cases

• Generated ad-hoc reports in SQL and Power BI to the decision makers for strategic planning. DATA ANALYST LOCKHEED MARTIN OCT 2018 TO DEC 2018 (ACADEMIC PROJECT)

• Performed a competitive analysis of the successful global commercial sustainable organizations.

• Gathered data, and performed data cleaning and analysis using python libraries

• Created an interactive tableau dashboard from the data analyzed of the global sustainment of military for Lockheed products and large complex systems to build forecasts pertaining to the aerospace industry ACCOUNTS MANAGER RED MATTER TECH SEP 2015 TO MAR 2018

• Developed a website traffic plan, created goals and benchmarks and generated monthly reports on campaign’s performance.

• Formulated branding strategies and allocated client resources to ensure maximum returns on investment.

• Created and managed the websites, microsite development and handled the social media channels for SEO.

• Evaluated the effectiveness of a marketing campaign, provided market analytics and provided insights to senior management.

• Collaborated with product managers and business managers to develop and execute A/B/n and multivariate tests for web apps.

• Provided thought leadership and technical guidance in the area of A/B/n and multivariate testing and site optimization. GRADUATE RESEARCH ASSISTANT TEXAS A&M UNIVERSITY OCT 2018 TO MAY 2019

• Analyzed historical data for understanding the trends in foster care system using R Stat, SPSS.

• Created reports and dashboards, visualizations that best determines the trends and data analysis of the data. COLGATE INDIA PVT LIMITED Research Associate APRIL 2014 TO JUNE 2014

• Studied and analyzed the Point of purchase of the company for in store promotional activity and the impact of it on purchases

• Submitted a list of recommendations with the data gathered to improve the effectiveness of the Point of purchase

Contact this candidate