Data Analyst Power Bi

RESHMI JR

Data Analyst

******.*********@*****.*** +1-563-***-**** LinkedIn GitHub

SUMMARY

Detail-oriented Marketing Data Analyst with 3+ years of experience transforming complex data into actionable insights to drive marketing and business strategies. Proficient in statistical analysis, A/B testing, and predictive modeling, with hands-on expertise in Tableau, Power BI, SQL, Python, R, and Excel. Demonstrated success in analyzing multi-channel campaign performance, conducting Exploratory Data Analysis (EDA), and optimizing customer acquisition and conversion rates. Adept at collaborating with cross-functional teams to solve business problems, automate reporting workflows, and enhance operational efficiency.

TECHNICAL SKILLS

Databases: PostgreSQL, RDBMS, Neo4j, Amazon Redshift, Google BigQuery, MySQL

Programming Languages: Python, R, SQL, DAX, Hive SQL, Java (OOP), PySpark

Data Visualization: Power BI, Tableau, Looker, Data Studio, Matplotlib, Plotly, MicroStrategy, Grow BI

Workflow & ETLTools: Apache Airflow (DAGs), DBT Cloud, Excel VBA

Cloud Platforms: AWS (S3, Redshift, DynamoDB), Google Cloud (BigQuery, Buckets), Snowflake, Zeppelin, Databricks

Mathematics & Statistics: Probability, Regression, Optimization, Hypothesis Testing, p-value, Eigenvalues/Vectors

Machine Learning & Data Science: scikit-learn, TensorFlow, Keras, Pandas, NumPy, Seaborn, Requests, Data Analysis PROFESSIONAL EXPERIENCE

Business Data Analyst Bright Mind (BME) USA Apr2024- Present

Orchestrated a 4% increase in revenue by optimizing product listing accuracy using SQL, Named Entity Recognition (NER), and CNNs, and by automating workflows with Apache Airflow and Amazon SageMaker.

Pioneered a cross-functional transformation that led to a 40% reduction in ad-hoc requests by building scalable data pipelines, ML models, and dashboards using Tableau, Airflow, Presto, Redshift, and MicroStrategy.

Delivered an 8% improvement in user conversion rates by analyzing real-time data via API connectors, BigQuery, Google Analytics, and DAX, and creating actionable Tableau and Power BI visualizations.

Developed 8+ MicroStrategy and Tableau dashboards and emailers in collaboration with business teams, supporting a strategic shift from a state-based to a zone-based supply chain model, increasing demand by 15%.

Integrated Salesforce data with internal analytics pipelines to improve CRM reporting accuracy, identify sales pipeline gaps, and enhance lead conversion rates.

Built and maintained Salesforce dashboards and reports for sales and operations teams, aligning marketing campaign insights with customer lifecycle metrics.

Leveraged Python (Pandas, NumPy) for efficient data wrangling and exploratory analysis, accelerating insights generation and reporting workflows.

Created interactive Tableau and Power BI dashboards and reports, simplifying complex data into clear, actionable insights and boosting data-driven decision-making by 20% across the organization.

Delivered ad-hoc analysis and reporting to sales, marketing, and finance teams, providing targeted solutions to evolving business challenges.

Integrated OpenAI GPT models for automated text generation and summarization, increasing content production efficiency by 20%.

Analyzed sales and marketing data to uncover growth opportunities and cost-saving strategies, resulting in a 15% increase in revenue and 10% reduction in marketing spend.

Maintained and optimized SQL stored procedures and business logic functions to automate recurring tasks and improve system efficiency.

Contributed to ERP and PLM system readiness for campaign operations and reporting by aligning data pipelines and business logic with broader system frameworks.

Collaborated with functional stakeholders to document reporting requirements, design KPIs, and support downstream data validation across BI tools.

Graduate Researcher Iowa State University USA May 2023 – Dec 2024

Executed Agile SDLC to optimize marketing strategies, resulting in a 10% sales uplift by analyzing customer segments and leveraging SQL, DBT, and Looker for precise targeting across Google Ads, Meta Ads, and omni- channel platforms.

Optimized and refined Big Data models via Airflow, utilizing DBT Cloud, S3, Python, and SQL for ETL/ELT processes, improving efficiency across Hive/Presto systems and reducing operational costs by 23%.

Built Data Lakes on BigQuery, Snowflake, and Redshift, cutting data redundancy by 20% and boosting data accuracy from 40% to >95% through advanced data cleaning and transformation.

Spearheaded P&L dashboard development for Amazon sellers, integrating budget, forecasted sales, demand, and COGS data, resulting in a 20% reduction in costs and enhanced business decision-making using Tableau.

Derived insights from unstructured datasets and visualized them using Power BI, enabling more effective business strategy alignment.

Integrated Salesforce Marketing Cloud data with internal BI systems to assess campaign effectiveness, audience engagement, and lifecycle performance metrics.

Created Salesforce CRM dashboards to support lead nurturing and campaign attribution analysis, improving engagement tracking by 25%.

Automated operational workflows using R and SQL, reducing manual efforts by over 70%.

Conducted market segmentation analysis and created KPI-driven analytics reports to support decision-making processes.

Generated and analyzed surveys and reports via Qualtrics, presenting statistical results using advanced tabular visualizations.

Managed Career Center projects using project management tools like Asana, ensuring timely delivery and collaboration.

Supported functional specs documentation for analytics dashboards, integrating data transformation pipelines into business-aligned reporting layers.

Assisted with cross-functional stakeholder engagement for validation of reporting KPIs across academic and financial departments.

Data Analyst Infosys Ltd Mar 2021 - Nov 2022

Managed the validation 20+ business reports for accuracy in high-stakes reviews, enhancing decision-making effectiveness

Assisted in developing project timelines and milestones for 5 initiatives, ensuring 100% on-time delivery and improving project efficiency

Designed interactive Power BI dashboards to streamline metric monitoring, resulting in a 15% increase in efficiency

Applied regression modeling to predict trends, enhancing customer retention by 10% through proactive engagement strategies

Led customer segmentation analysis, which increased marketing effectiveness by 20% and contributed $200,000 in revenue

Partnered with analysts to develop data models, enhancing forecasting accuracy for better budgeting

Championed a customer segmentation project using advanced data analytics to identify key customer groups, enhancing marketing strategies and driving a $150,000 increase in product sales within six months

Administered SWOT analysis to identify strengths, weaknesses, opportunities, and threats, facilitating informed strategic planning

Extracted insights from large datasets using SQL and Power BI, leading to a 30% improvement in resource allocation efficiency.

Contributed to Oracle ERP module documentation and assisted in testing upgrades by validating KPI dashboards and system enhancements.

Provided business support for ERP-related configuration updates and reconciled functional gaps with engineering teams during quarterly releases.

Implemented data governance practices to enhance data security & quality, resulting in improved compliance & reliability of data assets

Orchestrated advanced data mining and visualization with SAS while introducing a data correction process, leading to a 20% increase in ad revenue and a 15% reduction in data discrepancies

Conducted supply chain analysis, optimizing procurement through vendor negotiations, achieving an 18% cost reduction

Business Analyst Capillary Technologies Pvt. Ltd Jan 2019 - Dec 2020

Delivered a 4x ROI as an intern by orchestrating data-driven campaign plans, collaborating cross-functionally with teams such as brand marketing, campaign delivery, finance, and legal, to execute successful campaigns in the retail industry.

Mitigated fraud transactions by 17% in offline retail environments through the implementation of real-time, data-driven rules using SQL, Association rule mining, K-means clustering and predictive modeling.

Drove a 20% increase in CRM growth by deploying advanced models incorporating RFM, Demand Forecasting, and Market Basket Analysis for customer retention, and cross-sell product analysis through real time campaigns using Ads.

Retained 6+ clients by computing new metrics like CSI, NPS by leveraging 20+ SQL logics by incorporating inputs from Economics, Finance stakeholders and clients feedback to understand the fundamentals of the B2B and B2C systems.

EDUCATION

Iowa State University Iowa Dec 2024

Master of Science in Computer Engineering

APJ Abdul Kalam Technological University India May 2019 Bachelor of Technology in Information Technology

ACADEMIC PROJECTS

AI-Driven Customer Churn Prediction Model Python, R, Tensor Flow May 2024 - Aug 2024

Crafted an AI churn prediction model with Random Forest and Gradient Boosting, processing 100K+ customers

Deployed the model in a real-time dashboard, reducing customer attrition by 18% and enabling the marketing team to act on 85% of high-risk customers Operational Efficiency Dashboard Tableau, Power BI Jan 2024 - Apr 2024

Built an interactive Tableau dashboards to monitor KPIs, tracking 50+ metrics across departments

Conceptualized Tableau and SQL to automate reporting, reducing manual effort by 40% across 10+ data sources

Achieved a 30% improvement in decision-making speed by providing real-time actionable insights to stakeholders META Stock Analysis & Prediction Linear Regression, Finance Sep 2024 - Dec 2023

Established a stock prediction system with YFinance, refined accuracy by 25% using technical indicators & diverse data

Trained models with Ridge Regression for predictions, attaining RMSE of 0.0321 & $322 profit over 541 sessions Food Delivery Management System Apache Airflow, Power BI Sep 2023 – Dec 2023

Leveraged Airflow DAGs for creating an ETL pipeline to automate data extraction from 5 distinct AWS S3 sources

Incorporated data preprocessing techniques like cleaning, normalization, and transformation for over 50,000 records into Google BigQuery

Automated reportgeneration using Power BI while customizing DAX queries to reduce preparation time by 30%

Contact this candidate