Power Bi Data Analyst
Resume:
MOUNIKA MUKKAMALLA
Email: - *******************@*****.*** Contact: - +1-813-***-**** Location: - Detroit, MI LinkedIn PROFESSIONAL SUMMARY: -
I’m a data-driven professional with 3+ years of experience turning raw data into impactful business insights through advanced analytics and intuitive storytelling. Skilled in SQL, Python, Tableau, and Power BI, I craft dynamic dashboards and uncover trends that influence strategic decisions. Blending analyst precision with data engineering expertise, I build scalable data pipelines using tools like Apache Airflow, AWS Glue, and Snowflake. With a strong command of ETL workflows and cloud ecosystems, I thrive in fast-paced environments where data fuels innovation and growth. TECHNICAL SKILLS: -
Data Analytics: SQL, Excel (Power Query, Pivot Tables), Python (Pandas, NumPy), R, Data Wrangling, Statistical Analysis, A/B Testing
Data Visualization: Tableau, Power BI, Looker, Matplotlib, Seaborn, Plotly, Dash Data Engineering: Apache Airflow, AWS Glue, DBT, Snowflake, Redshift, BigQuery, Spark, Kafka, ETL/ELT Pipelines, Data Warehousing
Machine Learning & AI: Feature Engineering, AutoML Tools (Google AutoML, H2O.ai, Azure AutoML), Model Deployment & Integration (TensorFlow, Scikit-learn), NLP Techniques (Text Mining, TF-IDF, SpaCy)
Cloud Platforms: AWS (S3, EC2, Lambda, Athena), Azure (Data Factory, Synapse), GCP (BigQuery, Cloud Functions), Databricks
Collaboration & DevOps: Git, GitHub, Jenkins, Docker, JIRA, Confluence, Trello, Slack, Agile/Scrum Methodologies
Tools & Productivity: VS Code, Jupyter Notebook, Google Sheets, Microsoft PowerPoint, Notion, Postman, REST APIs, SQL Workbench, DBeaver, Linux/Unix Shell PROFESSIONAL EXPERIECE: -
Data Analyst Dec 2023 – Present
Freedom Mortgage Boca Raton, FL
• Analyzed and processed large datasets (10M+ records) from SQL Server and Snowflake, identifying data quality issues and implementing validation rules that improved data accuracy by 30%.
• Developed and upheld over 20+ dynamic dashboards in Tableau and Power BI, enabling real-time visibility into mortgage origination trends, reducing report turnaround time by 40%.
• Automated monthly and ad-hoc reporting workflows using Python (Pandas, NumPy) and Apache Airflow, reducing manual efforts by 25 hours per week.
• United with cross-functional teams including Product, Risk, and Marketing to deliver data-driven insights that increased loan application conversion rates by 12%.
• Built and optimized ETL pipelines using AWS Glue and SQL, supporting seamless integration of disparate data sources across internal systems and third-party vendors.
• Utilized predictive analytics and feature engineering to support credit risk models using Scikit-learn and XGBoost, improving delinquency prediction accuracy by 18%.
• Created and sustained detailed documentation for data models, metrics definitions, and business logic in Confluence and JIRA, enhancing stakeholder transparency and audit readiness.
• Conducted root cause analysis and trend forecasting on loan processing delays, leading to process improvements that decreased average processing time by 9 business days.
• Leveraged NLP techniques (SpaCy, TF-IDF) to analyse customer feedback from 50,000+ reviews, uncovering sentiment trends that informed product strategy and improved satisfaction scores by 15%.
• Ensured data governance and compliance with SOC 2 and GDPR standards, while working closely with IT security to audit access controls across Snowflake and S3 buckets. Data Analyst Sept 2022 – Nov 2023
Kroger Cincinnati, Ohio
• Built and maintained automated ETL pipelines using Apache Airflow and AWS Glue to streamline data processing across marketing, inventory, and customer insights teams.
• Analyzed over 15 million rows of transactional and customer data using SQL and Python to identify key purchasing trends, resulting in a 7% increase in targeted campaign effectiveness.
• Designed interactive Power BI and Tableau dashboards for senior leadership to track daily sales, customer retention, and product performance across 500+ store locations nationwide.
• Partnered with business stakeholders to define and track KPIs across merchandising and supply chain, improving reporting accuracy by 28%.
• Carried out deep-dive analyses using A/B testing and regression models to evaluate the impact of digital promotions, leading to a 12% increase in online conversions.
• Utilized Snowflake and Redshift for managing and querying large datasets, optimizing query performance by over 35% through indexing and partitioning.
• Integrated NLP techniques (TF-IDF, SpaCy) to analyse over 250,000 customer reviews, uncovering insights that drove improvements in product quality and customer satisfaction.
• Collaborated with cross-functional teams using JIRA, Trello, and Slack, ensuring clear communication and agile delivery of analytics projects.
• Leveraged feature engineering and AutoML tools (H2O.ai) to prototype customer segmentation models, contributing to a 10% lift in personalized marketing response rates.
• Ensured data integrity and governance through meticulous validation, documentation, and collaboration with data engineering to align with compliance standards (HIPAA, CCPA). Data Analyst Dec 2021 – Jul 2022
Synechron INC Hyderabad
• Collected, cleaned, and validated over 50,000 rows of raw data using Excel and Python (Pandas) to support internal reporting requirements.
• Assisted in developing 5+ interactive dashboards using Power BI to visualize sales trends, improving stakeholder decision-making efficiency.
• Wrote and optimized SQL queries to extract meaningful insights from relational databases, reducing report generation time by 30%.
• Executed exploratory data analysis (EDA) on customer datasets to identify trends and outliers, contributing to improved customer segmentation strategies.
• Cooperated with a cross-functional team of 4 members to automate weekly reporting using Python scripts, saving 6+ hours per week.
• Supported creation of A/B testing plans and analysed test results using statistical techniques to validate feature enhancements for a client project.
• Documented all data processes, workflows, and project learnings in Confluence, ensuring smooth knowledge transfer within the team.
• Participated in sprint meetings and used JIRA to track progress and manage tasks in an Agile work environment.
• Utilized Tableau to create quick visual mock-ups for data summaries, helping senior analysts present findings more clearly to clients.
• Engaged in internal knowledge-sharing sessions and completed 2 certifications in SQL and Excel analytics, boosting technical capabilities.
EDUCATION: -
Master of Science in Information Systems May 2024
Central Michigan University Mount Pleasant, MI
GPA- 3.81/ 4.00
- Relevant coursework: Excel, Programming in Python, SQL, Database Management, Tableau, Performance Metrics. CERTIFICATIONS: -
• Lean Six Sigma Green Belt
Contact this candidate