Data Analyst - Data Visualization & BI - Python, SQL, Spark, Azure

Aruna Yadav

IL 401-***-**** *************@*****.*** LinkedIn H4 -EAD (no sponsorship required) SUMMARY

Business Data Analyst with 5 years of experience delivering data-driven insights and business intelligence solutions in the financial and retail sectors. Proficient in Python, SQL, Tableau, Power BI, and ETL tools, with expertise in big data technologies like Apache Spark and Databricks. Experienced in building scalable ETL pipelines, performing data wrangling and validation, and ensuring data integrity across cloud platforms such as Azure and cloud data warehouse platforms like Snowflake and Azure Synapse Analytics. Skilled in gathering and analyzing business requirements, conducting gap analysis, facilitating stakeholder workshops, and creating detailed business process models. Adept at collaborating with cross-functional teams using Agile and Waterfall methodologies to implement data solutions aligned with business goals and regulatory standards, transforming complex data into actionable insights that drive strategic decision-making and operational improvements. SKILLS

Methodologies: SDLC, Agile, Waterfall, Requirements Gathering, User Story Creation, Gap Analysis Programming Languages: Python, SQL

Python Libraries: NumPy, Pandas, Matplotlib, Seaborn, SciPy, Scikit-learn Data Analysis & Processing: Data Cleaning, Data Wrangling, Exploratory Data Analysis (EDA), Data Profiling Data Visualization Tools: Tableau, Power BI, Microsoft Excel (Pivot Tables, VLOOKUP, Power Query) Cloud Platforms: Microsoft Azure (Data Factory, Blob Storage, Synapse), Snowflake Big Data Technologies: Apache Spark, Hadoop, Hive, Pig, Databricks, MapReduce Databases: MySQL, SQL Server, Oracle, MongoDB, Snowflake ETL/ELT Tools: Azure Data Factory, SSIS, Azure Databricks Machine Learning Algorithms: Linear Regression, Logistic Regression, Decision Trees, Random Forest, Naive Bayes, KNN, K-Means, SVM, CNN, Classification, Clustering, Supervised/Unsupervised Learning Reporting & Dashboarding: KPI Dashboards, Interactive Reports, Financial and Operational Metrics Documentation & Tools: JIRA, Confluence, Microsoft Office Suite (Word, PowerPoint, Outlook) Version Control: Git, GitHub

Soft Skills: Critical Thinking, Problem Solving, Business Acumen, Communication Skills, Stakeholder Management, Presentation Skills, Team Collaboration

Operating Systems: Windows, Linux

EDUCATION

Master of Technology (MTech.) in Computer Science Engineering June 2012 Banasthali Vidyapith, Rajasthan, India

Bachelor of Technology (B.Tech.) in Computer Science Engineering June 2008 KIET Group of Institutions, Uttar Pradesh Technical University, UP, India EXPERIENCE

PNC Financial Services, IL Nov 2023 – Current Business Data Analyst

• Spearheaded the development of a comprehensive risk analytics framework using SQL and Python, applying predictive modeling and scenario analysis to manage credit risk exposure effectively.

• Designed and deployed interactive Power BI dashboards to monitor key financial KPIs, enabling real-time decision-making for senior management and improving reporting efficiency.

• Collaborated with cross-functional teams to streamline ETL processes, integrating disparate data sources into a centralized Snowflake data warehouse to enhance data accessibility and reliability.

• Utilized logistic regression and decision trees for advanced statistical analysis to optimize loan portfolio performance and support strategic financial decisions.

• Automated recurring financial reports using Python scripts, significantly reducing manual effort and improving report accuracy.

• Led stakeholder workshops to identify business requirements and translate them into actionable data models, enhancing operational efficiency across multiple business units.

• Implemented A/B testing frameworks to evaluate marketing campaign effectiveness, providing data-driven insights to improve customer acquisition strategies.

• Developed and executed SQL validation scripts to ensure data quality and integrity, minimizing discrepancies in financial reports.

• Partnered with finance, risk, and compliance teams to deliver accurate regulatory reports and support internal audits, ensuring adherence to company policies and industry standards. Infinite Infolab, India Aug 2018 - July 2021 Data Analyst

• Developed and maintained complex SQL queries to extract and analyze customer behavior data, improving targeting accuracy for marketing campaigns.

• Built predictive models using Python (Scikit-learn) to forecast sales trends, achieving high accuracy and enabling proactive inventory management.

• Created dynamic Power BI dashboards to visualize supply chain performance metrics, reducing operational bottlenecks through actionable insights.

• Optimized data pipelines by automating ETL workflows with Python, decreasing data processing time, and enhancing scalability.

• Conducted cluster analysis to segment customer bases, enabling personalized marketing strategies that increased customer retention.

• Collaborated with product teams to integrate machine learning models into production systems, improving demand forecasting accuracy.

• Developed interactive Tableau dashboards to monitor key business KPIs, enhancing real-time decision-making and improving reporting efficiency.

• Performed root cause analysis on operational inefficiencies using statistical techniques, proposing solutions that reduced costs across key processes.

• Led cross-functional workshops to gather business requirements and translated them into actionable analytics solutions, improving stakeholder satisfaction and decision-making. CERTIFICATIONS

IBM: DB2 Certification

IIT Bombay: PHP & MySQL, Sci-Lab, Linux

Udemy: Microsoft Power BI Desktop for Business Intelligence, The Complete Agile and Scrum Project Management Course, [Data Analysis SQL, Tableau, Power BI & Excel Real Projects], Python for Absolute Beginners. LinkedIn Learning: ETL in Python & SQL, Power BI Data Modeling with DAX, Deep Learning & Data Visualization with Python, SQL for Testers, Data Analysis with Python.

Contact this candidate