Data Analyst Power BI

Satya Pradeep Kodeboina

Columbus, OH (Open to relocate) ****************@*****.*** +1-857-***-****

SUMMARY

Results-driven Data Analyst with a strong passion for uncovering hidden insights and driving impactful decisions. Proficient in leveraging data analytics technologies like Power BI, Google Cloud Platform, and SQL to empower informed decision-making. A collaborative innovator with a natural curiosity and a passion for storytelling through data.

EDUCATION

Master of Science, Data Analytics Sep 2021 - May 2023

Northeastern University, Boston, MA, GPA: 3.8/4

Courses: Probability and Statistics, Predictive Analytics, Database Management systems, Data Mining applications, Machine Learning, Visualizations

SKILLS & CERTIFICATIONS

Data Analysis: MySQL, SQL, Python (Pandas, NumPy, Matplotlib, Sklearn), R (dplyr, ggplot2, tidyr), SAS, Advance Excel (Pivot, VBA, Macros)

Business Intelligence: Tableau, Power BI, AWS, QuickSight, Snowflake, Jira, Salesforce Analytics, Google Analytics (Tera Desk)

Data Mining: Informatica, Collibra, ETL scripting, Exploratory Data Analysis (EDA), Data Preprocessing, Data Modeling, AWS (S3, EC2, Redshift)

Machine Learning: Predictive Analysis, Random Forest, Logistic Regression, K-NN, SVM, Monte Carlo Simulation, Decision Trees

Certifications: Tableau Data Analyst/Specialist Desktop Certification, Amazon Web Service (AWS) for Data Analytics and Data Warehouses.

WORK EXPERIENCE

Data Analyst Nationwide Columbus, OH Jul 2023 – Present

Collaborated with cross-functional teams to analyze data and drive business outcomes.

Led business intelligence initiatives by assessing control environments, generating insights to support strategic decisions, and addressing control gaps through SQL-based data analysis, aligning outcomes with regulatory standards and organizational goals.

Designed and generated ad-hoc operational and strategic dashboards using SQL and Power BI, utilizing KRIs and KPIs to enable data-driven decisions, drive risk mitigation, and support cross-functional strategic planning.

Developed strategic reports and dashboards in Power BI and Snowflake for enhanced fraud detection and customer insights, fostering cross-functional relationships to streamline data workflows, resulting in a 10% increase in customer retention.

Built and managed interactive Power BI dashboards to monitor transactional data and support data-driven decisions, leveraging prescriptive analytics to improve fraud detection accuracy by 30% and reduce false positives.

Collaborated cross-functionally with the Operations and Data Engineering team to analyze data and custom report generation utilizing Advance Excel (Pivot, VBA), Snowflake, and Alteryx reducing fraud detection, resulting in an improved customer retention rate by 10%

Applied Random Forest and Logistic Regression to identify financial crime, phishing reports, and anomalous transactions improving preventative measures against potential fraud by 14%, leveraging Predictive analysis

Senior Data Analyst Amazon India Dec 2019 – Jul 2021

Collaborated with the Data Engineering team to implement Quality Assurance/Quality Control (QA/QC) procedures for GIS and non-GIS data, utilizing Esri tools, Informatica, Collibra, and custom scripts using Python and R, increasing data accuracy by 18%.

Analyzed GIS (Geospatial Information Systems) datasets utilizing SQL window functions and VBA techniques, visualizing KPIs including fuel efficiency, delivery accuracy, and network coverage resulting in a 15% boost in customer satisfaction and cost savings of over $80,000

Automated data flows between GIS databases (Esri ArcGIS) and AWS S3, optimizing data accessibility and reliability for GIS applications and analytics using Python scripting, leading to a 20% improvement in data retrieval speed and accuracy.

Evaluated KPIs including SLAs, escalation rate, error rate, and ticket backlog using Advanced Excel and Power BI, assisting leadership to rectify bottlenecks and take measures resulting in improving team productivity by 12%

Data Analyst Amazon India Nov 2017 – Nov 2019

Consolidated customer data utilizing SQL and Python (Pandas, NumPy), rectifying data accuracy and data completeness leveraging Exploratory Data Analysis (EDA) and enhancing data quality using Informatica & integrity using Collibra improving data processing time by 15%

Conducted zone picking & packing developing and applying 'Fixit!' tool logic and coverage metrics for scan hygiene using Hubble & ETL tools resulting in 20% error reduction and saving 200+ man hours weekly

Aided Business Intelligence team to visualize KPIs including customer satisfaction, delivery efficiency, etc., translating requirements into actionable tasks, creating user stories and use cases utilizing Jira, improving stakeholder satisfaction by 10% and project timelines by 18%

Administered Social Media Escalations project using Salesforce Analytics and QuickSight, resolving 400+ customer issues raised on social channels of Returns, Delivery, and Quality, increasing customer retention and reducing average response time by 15%

Digital Marketing Analyst Orange Leaf (NGO) India Jul 2016 – Oct 2017

Visualized KPIs including web traffic, unique visitors, and email click-through rate using Google Analytics, optimizing digital marketing strategies using SEO and email marketing increasing online donations by INR 20,000 monthly

Optimized Pay-Per-Click (PPC) for “Educate the Child” campaign using Google AdWords and Facebook Ads, boosting campaign ROI by 30%

PROJECTS

Employee Attrition Rate Jan 2023 – Apr 2023

Leveraged Exploratory Data Analysis using R to centralize the attrition data based on business organization analyzing employee behaviour

Predicted employee attrition rates by designing a BI dashboard in Power BI and applying ML models (Logistic Regression, Clustering, Random Forest, SVM), enabling data-driven HR decisions and achieving 91% prediction accuracy.

Contact this candidate