Data Analyst Power Bi

Harshini Nimmala

Data Analyst

Houston, TX *****************@*****.*** 806-***-**** Linkedin

PROFESSIONAL SUMMARY

Experienced Data Analyst with 4+ years of hands-on work in financial and e-commerce analytics, including fraud detection, customer segmentation, and reporting automation. I’ve built and optimized ETL pipelines, automated manual reporting using Python and SQL, and developed dashboards that support real-time decision-making. My work has helped reduce fraud losses, improve compliance, and save hundreds of hours in manual effort. I bring strong knowledge in financial regulations and focus on delivering practical, data-driven results. TECHNICAL SKILLS

Methodologies: SDLC (Agile, Scrum, Waterfall, Kanban) Programming Language: Python, R, SQL, VBA, Shell Scripting IDE’s: Jupyter Notebook, R Studio, Visual Studio Code, PyCharm Python Packages: NumPy, Pandas, Matplotlib, SciPy, ggplot2, Scikit learn, PySpark, Keras, TensorFlow Visualization & ETL Tools: Tableau, Power BI (Power Query, DAX), Excel (Pivot Table, Pivot Chart, VLOOKUP,XLOOKUP, VBA) Database: Snowflake, PostgreSQL, MySQL, SQL Server, Oracle RDBMS Cloud Technologies: AWS (S3, RDS, Glue), AZURE Fundamentals, Databricks, SSIS, Apache Airflow Domain Knowledge: Financial regulations (PCI-DSS, GDPR), risk management, customer segmentation Other Tools: Docker, MS Excel, Git, Looker, GitHub, MS Visio, Qlik, Jira, CI/CD, Git Bash Operating System: Windows, macOS

WORK EXPERIENCE

Data Analyst PNC Financial Services, Dallas - TX October 2024 – Present Project Title: Customer Transaction Analytics and Fraud Detection Platform

● Analyze over 10 million transaction records to support fraud detection, compliance, and report improvements.

● Clean and validate large datasets using Python and Alteryx, improving data accuracy to 98% for better decision-making.

● Collaborate with data engineers and risk teams to automate data workflows, reducing processing time by over 60%.

● Develop and apply data models to detect suspicious transactions, contributing to a 25% reduction in fraud losses.

● Design dashboards in Tableau and Power BI to track real-time fraud alerts and compliance metrics, enhancing reporting speed and usability.

● Optimize data queries to streamline dashboard performance, reducing load times from 8 seconds to 2 seconds.

● Partner with IT teams to maintain data security and ensure adherence to AML, GDPR, and PCI-DSS standards.

● Participate in Agile sprints, providing updates in daily standups and collaborating with cross-functional stakeholders.

● Leverage cloud tools like AWS and Snowflake to manage large-scale data securely in a regulated financial environment. Data Analyst WebCode IT, Hyderabad - India March 2020 – July 2023 Project: E-Commerce Customer Insights & Forecasting Platform

● Extracted, cleaned, and transformed 15M+ sales transactions from PostgreSQL and AWS S3 using Python (Pandas, NumPy) and SQL, resolving 15% data inconsistencies (missing session IDs, duplicates) to improve accuracy to 97%.

● Designed and deployed ETL pipelines using Talend and AWS Glue, reducing data processing time by 75% (from 10 hours to 35 minutes).

● Automated reporting workflows using AWS Lambda, Shell scripts, and Python, eliminating 30% of manual effort and enhancing operational efficiency.

● Created 10+ interactive Tableau dashboards and 6 Power BI reports tracking sales trends, customer behavior, and campaign performance.

● Automated 70% of manual reporting tasks using Python scripts and VBA macros, saving 30% effort.

● Documented workflows in Jira and MS Visio, ensuring compliance with SDLC and Agile (Scrum/Kanban) methodologies.

● Achieved 95% accuracy in integrating multi-source data (sales, marketing, inventory) through Talend and AWS Glue, resolving major data silos.

EDUCATION

Masters in engineering in Data Science University of Houston - Houston, TX Bachelor of Engineering in Computer Science Stanley College of Engineering & Technology for Women - Hyderabad, India CERTIFICATION

SQL and Relational Databases – CognitiveClass.ai

SQL Fundamentals – Solo Learn

Microsoft Azure Fundamentals (AZ-900)

Contact this candidate