Data Analyst

SAIPAVAN GATTIKOPPULA

BOSTON, MASSACHUSETTS 857-***-**** *************@*****.*** https://www.linkedin.com/in/sai-pavan-gattikoppula- 1a5114297/

PROFESSIONAL SUMMARY

Data Analyst and Master's graduate in Information Technology (GPA: 3.8) from the University of Massachusetts Boston with 3+ years of experience turning complex datasets into clear, actionable business insights. Proficient in SQL, Python (Pandas, NumPy, Scikit-learn), Tableau, Power BI, and Statistical Modeling, with hands-on expertise in data cleaning, exploratory data analysis (EDA), A/B testing, feature engineering, predictive modeling, and KPI dashboard development. Experienced across retail, technology, and healthcare sectors, with a strong ability to bridge the gap between technical findings and business strategy. Skilled at translating data into data-driven recommendations that support strategic decision- making and drive operational efficiency for both technical and non-technical stakeholders. SKILLS

Languages & Querying: Python (Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn), SQL (PostgreSQL, MySQL, BigQuery, SQLite), R Visualization & BI Tools: Tableau, Power BI, Google Data Studio, Excel (Advanced: Pivot Tables, Power Query, VLOOKUP/XLOOKUP, Advanced Functions, Conditional Formatting), Jupyter Notebooks, PowerPoint (Data Storytelling) Machine Learning & AI: Scikit-learn, TensorFlow, PyTorch, XGBoost, Logistic Regression, Classification Models, Feature Engineering, Model Evaluation (Precision, Recall, F1-score, R, RMSE), Predictive Modeling, Neural Networks Cloud & Data Platforms: Google BigQuery, AWS S3, Snowflake, Google Analytics, Salesforce (reporting) Data Management & Engineering: ETL/ELT processes, Data Cleaning & Wrangling, Data Modeling, Data Validation, Relational Databases, Data Integrity, EDA

Statistical & Analytical Methods: Descriptive & Prescriptive Analytics, Hypothesis Testing, Regression Analysis, Correlation Analysis, A/B Testing, Cohort Analysis, Funnel Analysis, Trend Forecasting, Predictive Analytics Tools & Collaboration: Git/GitHub, VS Code, JIRA (Agile/Scrum), Confluence, Notion, Microsoft Office Suite, Google Workspace EXPERIENCE

Signature Aviation, Boston Data Analyst June 2024- Present

§ Queried and analyzed merchant sales data using SQL and BigQuery across 5M+ records, identifying revenue trends and customer behavior patterns to support quarterly product roadmap decisions.

§ Built and maintained 8 Tableau dashboards used daily by product, marketing, and operations teams to monitor GMV, merchant churn, conversion rates, and campaign performance in real time.

§ Conducted A/B testing on 10+ product feature rollouts using Python (SciPy, Pandas), applying t-tests and chi-square tests to determine statistical significance, contributing to a 12% increase in merchant activation rate.

§ Automated recurring weekly and monthly Excel/Python reports for stakeholders, reducing manual reporting effort by 8 hours per week and improving data delivery turnaround by 50%.

§ Performed customer cohort analysis and churn modeling to identify at-risk merchant segments, enabling the customer success team to proactively reduce churn by 9% over two quarters.

§ Partnered with the Data Engineering team to document data dictionaries, table schemas, and reporting logic in Confluence, improving data discoverability and team onboarding speed.

Mancio Tech, Hyderabad Junior Data Analyst Jan 2023- Dec 2023

§ Developed and maintained SQL queries in PostgreSQL and MySQL to extract, transform, and load sales pipeline data for the South India commercial division, supporting reporting for 50+ sales managers.

§ Designed Power BI dashboards that visualized sales funnel metrics, win/loss rates, and quota attainment across regions, replacing 3 legacy static Excel reports and saving 6 hours of manual work weekly.

§ Cleaned and validated large-scale datasets (1M+ rows) using Python (Pandas) for quarterly business reviews, resolving data quality issues that previously led to a 15% reporting error rate.

§ Conducted exploratory data analysis (EDA) on customer purchase history to uncover upsell opportunities, directly informing a targeted outreach campaign that generated $20K in additional pipeline.

§ Collaborated with cross-functional teams, including Sales, Finance, and Marketing, to define KPIs and build standardized metrics frameworks adopted across the entire South India division.

§ Supported ad hoc data requests from senior leadership using Excel and SQL, delivering analysis on pricing trends, market share, and competitive benchmarking within tight turnaround timelines. MotoResQ, Hyderabad Data Analyst Associate DEC 2021 – DEC 2022

§ Wrote SQL queries to pull and analyze point-of-sale transaction data from a retail client database with 2M+ records, identifying top-performing SKUs and seasonal demand patterns for inventory planning.

§ Created Google Data Studio and Excel reports for 5 retail clients summarizing weekly sales performance, foot traffic trends, and promotion effectiveness, delivered every Monday morning with zero missed deadlines.

§ Assisted in building a Python-based data pipeline to automate ingestion of daily sales CSV files into BigQuery, reducing manual upload time by 4 hours per day for the analytics team.

§ Performed market basket analysis using Python (MLxtend) to identify product affinity pairs for a retail client, informing a store layout change that increased average basket size by 7%.

§ Cleaned and standardized inconsistent customer demographic data across 3 disparate source systems, achieving a 95% match rate after deduplication and improving the accuracy of campaign targeting reports.

§ Presented findings from monthly analysis to non-technical stakeholders using clear visualizations in Tableau, receiving consistent positive feedback for translating data into actionable business recommendations. EDUCATION

Master’s, Information Technology DECEMBER 2025

University Of Massachusetts-Boston Boston, Massachusetts, USA CERTIFICATIONS

§ Google Data Analytics Professional Certificate

§ MTA: Java – Microsoft Technology Associate (Microsoft)

§ Introduction to Cyber Security – Cisco Networking Academy

§ HTML Fundamentals – Great Learning

Contact this candidate