Data Analyst Business Intelligence

MANIDEEP PIPPARI

Data Analyst

872-***-**** ********.*@***********.*** LinkedIn

SUMMARY

Data Analyst with 4 years of experience transforming raw data into strategic business intelligence through advanced analytics and visualization. Expert in Python, SQL, Tableau, and cloud-based data warehousing solutions. Specializes in predictive modeling, ETL pipeline development, and creating actionable insights that drive operational excellence and informed decision-making across organizations. SKILLS

Methodologies: SDLC, Agile, Waterfall

Programming Languages: Python (Pandas, NumPy, SciPy, Matplotlib, Seaborn, TensorFlow), SQL, R Database: Microsoft SQL Server, PostgreSQL, MySQL

Data Visualization Tools and Platforms: Tableau, Power BI, Advanced Excel (VLOOKUP, Pivot Tables) Statistical Analysis: A/B testing, Descriptive Statistics, Predictive Analytics, Hypothesis Testing, Regression Analysis, Time Series Analysis Cloud Platforms: AWS (S3, EC2, Redshift), Microsoft Azure, Snowflake ETL Tools: Alteryx, Talend

Version Control: Git, GitHub

Soft Skills: Critical thinking, Problem-solving, Attention to detail, Communication Skills, Team Collaboration, Stakeholder Management EDUCATION

Master of Science in Business Analytics December 2024 Sacred Heart University

Bachelor of Business Administration December 2020

Dr Narayana College of Commerce, India

PROFESSIONAL EXPERIENCE

Data Analyst PNC, Virginia August 2024 - Current

Performed comprehensive data mining and statistical analysis using Python (pandas, NumPy) and SQL to identify customer spending patterns, enabling targeted campaigns that generated $2.3M revenue growth.

Conducted full lifecycle analysis gathering business requirements from stakeholders, designing complex Tableau dashboards using star schema and dimensional modeling that improved executive decision-making efficiency by 25%.

Developed advanced SQL queries with stored procedures and optimization techniques on OLAP databases, creating automated SSRS reports that reduced manual reporting time by 8 hours weekly.

Collaborated with cross-functional engineering and finance teams to implement ETL workflows in Snowflake, establishing data governance standards that improved report accuracy.

Designed performance monitoring dashboards tracking KPIs and SLAs using Tableau, implementing automated alerts and documentation standards that enhanced operational response times by 22% cost effectively. Data Analyst Vivma Software Inc, India September 2020 – August 2023

Conducted data quality assurance using SQL for querying and Python for cleansing customer subscription datasets, reducing error rates by 18% while ensuring data integrity for the Customer Churn Prediction project.

Designed a predictive model in Python to identify high-risk customer segments, analyzing historical usage patterns and support interactions, resulting in targeted retention strategies that improved customer retention by 12%.

Created an IT Services Revenue & Customer Growth executive dashboard in Power BI, visualizing subscription growth trends and financial KPIs, enabling data-driven decisions, improving resource allocation.

Collaborated with product teams in an Agile environment to analyze user engagement metrics across subscription-based IT services, conducting A/B testing on pricing models that informed feature prioritization and marketing strategy adjustments.

Maintained data pipelines collecting information from multiple sources into AWS Redshift for the KPI dashboard, version-controlling analysis scripts with Git while ensuring compliance with data security protocols for sensitive customer information. PROJECTS

Online Movie Ticketing Database Management:

Extracted customer insights from 10M+ records using SQL to support campaign performance reviews.

Built a relational database platform using PostgreSQL for scalable data handling. • Developed data pipelines for test data provisioning and system validation.

Led a 5-students team using Jira for sprint planning and task tracking with Jira ticket management.

Worked on performance tuning of SQL queries for faster data access.

Simulated real-world practices with stakeholder communication and SDLC adherence. CERTIFICATIONS

Introduction to Data Analytics by IBM and Coursera

Contact this candidate