Chetana Alekhya Reddy Data Analyst
*******@***********.*** 616-***-**** Michigan, USA LinkedIn
Profile
Dynamic and results-oriented Data Analyst with over 4 years of extensive experience in leveraging advanced data analytics techniques to drive business decisions and enhance operational efficiency. Adept at communicating complex analytical findings to non-technical stakeholders, fostering cross-functional collaboration, and continuously improving processes to support strategic business goals. Professional Experience
Data Analyst, Lowe's 08/2023 – present Remote, USA
•Utilized Python and its libraries (Pandas, NumPy) for data cleaning, preprocessing, and transformation to prepare datasets for analysis and model development.
•Conducted thorough exploratory data analysis (EDA) to uncover underlying patterns, trends, and anomalies in the data, guiding the forecasting strategy.
•Developed an interactive, real-time dashboard using Tableau for monitoring inventory levels, forecasting insights, and alert notifications, significantly enhancing the decision-making processes for inventory management.
•Provided comprehensive reports and presentations to stakeholders, offering actionable insights for optimizing inventory levels and improving supply chain efficiency. Data Analyst, Infosys 05/2019 – 07/2022 Hyderabad, India
•Utilized BI Publisher to create dynamic, data-driven reports and dashboards. Delivered actionable insights through complex data analysis, supporting strategic planning and operational improvements.
•Engineered seamless data integration solutions, automating data transfer and reporting mechanisms. Leveraged PL/SQL for sophisticated data manipulation and analysis, enhancing data accuracy and reporting capabilities.
•Processed and analyzed datasets encompassing over 1 million client interactions per month, employing Python with Pandas and NumPy, to prepare for advanced analytical processing and insights generation.
•Developed and maintained an SQL-based data dictionary and schema documentation for over 200 tables, significantly improving team efficiency in data understanding and report generation by 25%.
•Developed and fine-tuned predictive models that achieved a 25% improvement in predicting client needs and service issues, leading to a 20% reduction in client churn and a 10% increase in cross-sell opportunities.
•Designed and deployed an interactive Power BI dashboard that is used by 200+ account managers and facilitated a 30% reduction in response time.
Skills
Programming Languages: Python (Pandas, NumPy, SciPy, Matplotlib), R, SQL Database & Big Data Technology: MySQL, PostgreSQL, MongoDB, Microsoft SQL Server, Hadoop, Spark, Hive, Pig Tools & Technology: Power BI, Tableau, WS Redshift, Google BigQuery, Snowflake, Scikit-learn, TensorFlow, Keras, PyTorch
Others: Data wrangling, Feature engineering, Handling missing data, Hypothesis testing, regression models, ANOVA, Statistical Analysis, Critical Thinking, Quantitative Analysis Education
Master of Science, Grand Valley State University 08/2022 – 12/2023 Grand Rapids, USA Applied Computer Science
Bachelor of Technology, JNTU 06/2015 – 04/2019 Bhimavaram, India Electronics and Communication Engineering
Projects
Dynamic COVID-19 Vaccine Tracker Dashboard, Python (Pandas Library), Tableau, Excel
•Utilized pandas in Python to programmatically gather, explore, and assess CDC COVID-19 Vaccine Tracker data.
•Created 5 Tableau visualizations with set actions, dynamic parameters, and calculated fields, revealing vaccination trends and distribution patterns.
T20 world cup cricket data analytics - Cricket Analysis, Web scrapping, Python (Pandas Library), Power BI
•This project involved creating a Power BI report utilizing web-scraped data from ESPNcricinfo to analyze T20 cricket players & performance, enabling strategic player selection and assembling a team with a 90% estimated win probability.