Anandi Kiran Yalavarthi
Louisville, KY 513-***-**** *********************@*****.***
PROFESSIONAL SUMMARY:
● Results-oriented Data Analyst with 3+ years of experience leveraging SQL, Python, and statistical methods to extract insights and content optimization.
● Skilled in collaborating with cross-functional teams to translate complex data into actionable business intelligence.
● Adhere to best business practices of SDLC for Requirement gathering, Analysis, Design, Code Construction and Testing.
● Possess good verbal and written communication skills. TECHNICAL SKILLS:
● Programming Languages: C, C++, Java, Python, SQL, PL/SQL
● Scripting Languages: JavaScript, HTML, CSS
● Databases: SQL Server
● ITSM Tools: ServiceNow, Jira
● Software Methodologies: SDLC, Agile, Scrum
● Cloud Computing: AWS, GCP
● Data Tools: PowerBI, Tableau, MS Excel, Snowflake
● RPA Tools: UiPath
● Others: Machine Learning, MS Office, GitHub
PROFESSIONAL EXPERIENCE:
502 MP Systems, USA
Data Analyst Oct 2023 to Current
● Delivered actionable insights on program effectiveness and identified opportunities for operational improvement through ad hoc reports, regular datasets, and interactive dashboards.
● Utilized PL/SQL to integrate data from multiple sources, ensuring data accuracy and meeting business needs.
● Maintained and enhanced reporting infrastructure, including report forms, formats, data generators, and user portals.
● Created report specifications based on business requests, demonstrating a strong understanding of departmental and organizational goals.
● Identified the best course of action for complex data requests, following established guidelines while also adapting to meet specific situations.
● Collaborated with cross-functional teams (sales analytics) to generate data-driven reports and insights, leading to a 15% reduction in expenses.
● Created dashboards with charts to highlight reports, communicate insights to stakeholders. The News Voice, India
Creative Writing Team Lead Jan 2021 to Jun 2022
● Implemented writing strategies, assessed content performance, identified trends and opportunities for optimization.
● Achieved 20% increase in reader engagement and 10% increase in content shares through strategic and production planning and data-informed content creation for digital advertising.
● Created data-driven charts to outline trends, communicate insights and recommendations to stakeholders.
● Leveraged Python, SQL on Google Cloud Platform to analyze supply chain datasets, identify bottlenecks, optimize asset inventory management, resulting in 10% reduction in lead times.
● Collaborated and assisted the sales and marketing analytics team to align creative content with data-driven insights.
● Conducted a sentiment analysis on a large dataset to gain insights into audience opinions and sentiments in order to develop new content based on informed data-driven decisions.
● Adapted natural language processing (NLP) techniques and machine learning (ML) algorithms to categorize reviews as and visualized the data with matplotlib and seaborn libraries.
● Evaluated the performance of the model using relevant metrics such as accuracy, precision, recall and F-1 score.
● Optimized the model parameters to enhance its predictive capabilities and generalization of unseen data.
Cognizant Technology Solutions Ltd, India
Program Analyst Jan 2020 to Dec 2020
● Conducted big data analysis on the financial history on the data extracted using SQL queries to derive actionable insights and aid in making data-driven decisions on ServiceNow Platform.
● Performed stockroom asset analysis to uncover patterns, trends and insights which helps in optimizing costs.
● Optimized inventory levels based on the comprehensive analysis of the stockroom assets using SQL, resulting in a 10% cost reduction.
● Contributed to cost reduction by analyzing minimal stock thresholds in stock rooms.
● Created data reports to outline trends, communicate insights and recommendations to the sales analytics team.
● Performed data cleaning and data transformation to ensure data accuracy for analysis and reporting.
● Reduced resolution time by 10% by identifying recurring issues and collaborating with the IT team to implement targeted solutions.
● Analyzed financial data using SQL queries to identify trends and patterns in service ticket resolution times.
CERTIFICATIONS & TRAINING:
Data Analytics and Visualization Job Simulation by Accenture North America on Forage
● Completed a simulation focused on advising a hypothetical social media client as a Data Analyst at Accenture
● Cleaned, modeled and analyzed 7 datasets to uncover insights into content trends to inform strategic decisions
● Prepared a PowerPoint deck and video presentation to communicate key insights for the client and internal stakeholders
Home Automation IOT with AWS using Raspberry Pi
● Developed python scripts to automate sensors to detect anomalies for burglar monitoring system
● Designed home automations using multiple sensors on the embedded system and mini computer EDUCATION:
● Master of Science in Information Studies – Trine University, Detroit, USA
● Bachelor of Engineering in Computer Science – Sathyabama University, Chennai, India