Business Analyst Analytics

TEJASWI SOMU

www.linkedin.com/in/tejaswi-somu-b**803211 ● 678-***-**** ● *************@*****.*** ● Plainfield, IL SUMMARY:

Pursuing master’s degree in Business Analytics, equipped with hands-on experience in using analytical tools and techniques to derive actionable business insights. Certified Google Data Analytics and detail-oriented Business Analytics professional with a strong foundation in data analysis, statistical modelling, and business intelligence.

Demonstrated ability to solve complex problems through data-driven decision-making and effective communication. Eager to leverage academic knowledge and practical skills to contribute to data-driven strategies in a dynamic business environment.

KEY SKILLS:

Data Analysis and Visualization MS Office SQL R Python Tableau & Power BI Statistical Methods Database Management Business Understanding Data Collection, Cleansing, & Preprocessing Data Quality and Accuracy Data Insights Business Intelligence and Analytics Stakeholder Management INTERNSHIPS:

HRM Intern June 2022 – August 2022

T-Works (India’s largest Prototyping Center), Hyderabad, Telangana, India

• Managed various aspects of the recruitment process, including posting job openings, screening resumes, and scheduling interviews, contributing to the successful onboarding of new employees.

• Coordinated and scheduled 16 interviews, ensuring a smooth and efficient interview process.

• Collected and maintained employee data, utilizing MS Excel for accurate leave tracking and record- keeping.

• Fostered employee engagement through participation in team-building activities and initiatives.

• Collaborated with a team of 20 members to organize and execute a successful workshop, enhancing team cohesion and professional development.

HRM Intern July 2021 – August 2021

ITC Limited PSPD, Bhadrachalam, Telangana, India

• Implemented diversity and inclusion initiatives to promote a more inclusive workplace culture.

• Spearheaded the implementation of employee feedback mechanisms to gather insights and improve organizational processes.

• Developed and implemented employee recognition programs to acknowledge outstanding performances.

• Led cross-functional teams to address employee concerns and improve overall employee satisfaction.

• Managed the organization's employer branding efforts to attract top talent and enhance the company's reputation in the industry.

• Stayed updated on HR best practices, trends and provided recommendations for continuous improvement in HR processes and policies.

SKILLS:

Python, R programming, Tableau, HTML, SQL, MS Excel, MS PowerPoint, MS Word, MS Access, ETL process, Power BI, Pandas, NumPy, Plot.ly, Matplotlib, Seaborn, Jupyter, HTML5, CSS3, Google Analytics, RStudio, Excel (Pivot, Graphs, Charts, VLOOKUP, Macros), SQL Server Management Studio, MySQL, MySQL Workbench, Software Development/ Test Life Cycle, Linear & Logistic Regression, Statistical Analysis, Predicative Modeling, A/B Testing, Hypothesis Testing, Data Visualization, Dashboard creation TEJASWI SOMU - 2

PROJECTS:

Airtel Advertisement Analytics

• Analyzed Airtel's advertising evolution spanning over 20 years, assessing strategic shifts in branding elements such as logos and taglines to stay relevant in the market.

• Evaluated the effectiveness of iconic advertising campaigns and strategic partnerships, contributing to over 10 successful branding initiatives and enhancing consumer engagement.

• Examined Airtel's advertising strategies emphasizing speed, technology, and connectivity, resulting in a 20% increase in brand recall and consolidating its market leadership position. Amazon Sales 2024

• Spearheaded an extensive business analytics study analyzing Amazon Sales of the year 2024, processing over 10,000 data points from major exchanges to discern trends and identify key performance indicators.

• Ensured data accuracy and consistency by handling missing values, duplicates, and errors.

• Conducted comprehensive analyses, unveiling insights from over 129,523 observations, resulting in actionable recommendations to improve sales, and enhance customer management of Amazon Sales.

• Developed and presented visual analytics dashboards showcasing patterns to analyze sales trends, shipping performance, product popularity, and geographical distribution for the customer base. Employee Attrition in US Healthcare

• Analyzed US healthcare sector employee attrition with a Kaggle dataset, processing 100,000+ records in Excel and creating 20+ visualizations in Tableau.

• Identified factors like age and overtime impacting attrition, with a 20% higher rate among younger employees (25-34) and 15% lower job satisfaction.

• Found top influences were monthly income, age, and overtime, noting a 25% increase in attrition in the Maternity department and among employees with <5% business travel.

• Conducted comprehensive data analysis, created data dictionary defining over 10 key variables, and developed over 20 visualizations (including lollipop charts, pie charts, and heatmaps) to identify attrition patterns.

EDUCATION:

Master of Science in Business Analytics

Lewis University, Illinois, USA GPA: 4/4 August 2023 – May 2025 Bachelor of Business Administration

IFHE - IBS Hyderabad, India GPA: 8.88/10 September 2020 – June 2023 EXTRA CURRICULAR AND VOLUNTEERING ACTIVITIES:

• Atlanta Community Food Bank. Coordinated with a team of students to serve food to the less fortunate, addressing food insecurity and hunger in the Atlanta area.

• Vice- President, IFHE-IBS Hyderabad, BBA Placement Cell. Improved the placement cell at ICFAI Business School, increasing student placement rates through effective coordination and organizing recruitment events.

Contact this candidate