Data Analyst Power Bi

RAMYASRI BALIJEPALLI

Cincinnati, Ohio ***** +1-513-***-**** **********************@*****.*** LinkedIn PROFESSIONAL SUMMARY

Dynamic Data Analyst with 3+ years of experience designing enterprise data solutions, ETL pipelines, and predictive analytics. Proficient in AWS (Redshift, DynamoDB, Glue), SQL, Power BI, and Python, optimizing query performance and dashboard insights. Experienced in handling structured and semi-structured data, improving reporting efficiency. Developed machine learning models for demand forecasting, boosting accuracy and reducing stock costs. Skilled in customer behavior analysis, NLP, and statistical modeling, driving business growth. Adept at integrating data from CRM, ERP, and IoT sources, ensuring seamless analytics workflows. TECHNICAL SKILLS

Methodologies Software development life cycle (SDLC), Agile/ Scrum, Waterfall Language & Database Python, SQL, NoSQL, MongoDB, Postgres, PL/SQL, MySQL, MSSQL, Azure SQL Database Python Packages Pandas, NumPy, Matplotlib, SciPy, Scikit-Learn, SeaBorn, PyTorch, TensorFlow, ggplot2 Cloud & IDES AWS, Azure, GCP, RStudio, PyCharm, Jupyter Notebook Data Analytics Skills Data Manipulation, Predictive Analysis, Data Cleaning, Data Mining, Data Visualization, Statistical Modeling, Exploratory Data Analysis (EDA), Data Modelling, Web Scraping Tools Tableau, Power BI, ETL, SQLite, Cron Tasks, SharePoint, ServiceNow, Microsoft Excel, Visual Studio Data Tools, Talend, Microsoft Office Suite, Jira, Git, GitHub WORK EXPERIENCE

Data Analyst Novatore, DE, USA May 2024 – Present

• Designed and developed Data Marts and Data Warehouses using Star and Snowflake Schemas, handling structured (SQL tables) and semi-structured (JSON) data from 5+ sources (CRM, ERP, APIs), achieving a 35% increase in query performance for reporting.

• Architected large-scale enterprise data solutions on AWS (Spark, EMR, RedShift, DynamoDB, Lambda, Glue, Snowflake), monthly processing 12TB of transactional and log datasets, integrating predictive analytics with Python to forecast trends.

• Authored over 100 SQL constructs (stored procedures, views, CTEs, UDFs, indexes), improved Tabular Models with dynamic roles and time-based hierarchies, managing variables to support 60+ users, reducing report generation time.

• Streamlined ETL processes by developing 50+ SSIS packages and ADF pipelines, gathering unstructured (text logs) and structured

(Excel, CSV) data from S3 and on-premises databases, incorporating statistical analysis, and cutting data processing time.

• Transformed and modeled 8GB+ sales and operational datasets in Power BI using Power Query and DAX, adding new forecasting features with time-series variables, and delivering 20+ predictive dashboards, improving insight delivery by 30%.

• Integrated Google Sheets and Google Data Studio with AWS pipelines, managing relational (PostgreSQL) and NoSQL (DynamoDB) data types from IoT and web sources, introducing automated KPI tracking and backup workflows, ensuring 99.9% data uptime. Software Engineer Accenture Solutions, Hyderabad, India January 2022 – May 2023

• Managed and analyzed large e-commerce and supply chain datasets from internal ERP systems (SAP), CRM databases, and external sources (Google Analytics, web scraping tools), reducing errors through comprehensive data validation processes.

• Engineered prediction models using Python (Pandas, Scikit-learn), achieving 62% forecast accuracy in demand prediction, optimizing inventory management, reducing excess stock by 15%, and lowering holding costs annually.

• Created dashboards in Power BI to monitor real-time KPIs, including sales performance, inventory turnover, and lead times, improving delivery timelines and reducing stock-outs.

• Performed statistical and clustering analysis to identify customer behaviour patterns, driving a 25% increase in conversion rates through targeted product bundles and improving average order value by 8% with a recommendation engine.

• Implemented NLP for customer sentiment analysis, leading to product improvements that increased customer satisfaction by 10%, while optimizing marketing budget allocation to boost ROI by 15%. Jr. Data Associate Cybernest, Bangalore, India January 2021 – January 2022

• Collected and cleaned datasets from SQL, APIs, and Excel, managing data types like numerical, categorical, and textual for up to 2 million rows, ensuring data accuracy and integrity.

• Monitored KPIs (CLV, conversion, retention), driving a 10% increase in CLV and 8% improvement in retention, contributing to a 5% rise in annual sales.

• Made interactive visualization reports in Power BI, delivering insights on KPIs and customer behaviour, improving decision-making and operational efficiency.

• Streamlined ETL processes, reducing data processing time, and developed a sales prediction tool that boosted forecasting accuracy. EDUCATION

Masters of Engineering Computer Science (CGPA: 3.83/4.0) August 2023 – April 2025 University of Cincinnati Cincinnati, Ohio

Bachelor of Technology in Electronics and Communication Engineering (CGPA: 4.0/4.0) July 2018 – June 2022 Vignan’s Foundation for Science, Technology and Research University Guntur, AP, India

Contact this candidate