Spurthi Patnam
Chicago,IL
Summary
Accomplished Data Analyst with a proven track record leveraging Python, SQL, Excel, and Tableau to uncover actionable insights and drive revenue growth across healthcare and financial industries. Skilled in ARIMA modeling and advanced statistical techniques, I excel in transforming complex datasets into strategic recommendations that enhance campaign effectiveness and organizational planning . Adept at collaborative problem-solving and presenting findings to both technical and non-technical stakeholders, ensuring data-driven decisions are clearly understood and implemented.
Overview
8
8
years of professional experience
Work History
Data Analyst
Affinity Solutions
06.2022 - Current
- Analyzed large volumes of bank and retail data using Python, SQL, and Excel to uncover trends in customer purchase behavior, enabling data-driven business decisions.
- Developed and maintained interactive Tableau dashboards, providing real-time visibility into marketing campaign performance and budget alignment for banks and merchants.
- Designed an ARIMA-based machine learning model to accurately forecast sales for loyal retailer brands, enhancing strategic planning and revenue growth potential.
- Created Excel-based tools and monthly reports employing advanced spreadsheet functions, streamlining the extraction of key metrics for stakeholder presentations.
- Applied statistical methods to derive actionable insights from complex datasets, guiding cross-functional teams in optimizing card usage and campaign effectiveness.
- Utilized data visualization techniques to communicate findings clearly, driving consensus and informed decision-making across business units.
Data Scientist Intern
Ironwood Pharmaceuticals
02.2021 - 07.2021
- Applied advanced statistical methods to IBM Watson MarketScan (Truven) data to determine anxiety and depression prevalence among IBSC-C patients, analyzing insurance claims from health insurers and large employers.
- Developed and optimized Python programs for claim-level and patient-level analysis on Medicare data, integrating hypothesis testing to reveal a 20% higher probability of anxiety and depression among IBSC medication users.
- Performed exploratory data analysis (EDA) with NumPy, Pandas, and Seaborn, categorizing results by disease CPT codes to inform data-driven decisions.
- Collaborated closely with department heads and cross-functional teams to ensure quality assurance of existing Python programs, maintaining meticulous detail when updating ICD-9 to ICD-10 codes.
- Presented findings to stakeholders, data science teams, and non-technical audiences via PowerPoint, and documented methodologies and outcomes in SharePoint for future reference and reproducibility.
Data Analyst Intern
Quadrant Resource
05.2017 - 11.2019
- Created and retrieved information from relational databases.
- Gained insights by normalizing data up to 3NF and utilized joins, CTE, and window functions to solve complicated MySQL queries.
- Performed exploratory data analysis using python pandas and numpy packages on employee demographics to observe the root cause of
- Created clear and understandable Tableau dashboards and reports.
Education
Master of Science - Analytics, Statistical Modeling
Northeastern University
Boston, MA04-2022
Bachelor of Technology - Computer Science And Engineering
Jawaharlal Nehru Technological Institute
Hyderabad,India08-2019
Skills
- Programming & Scripting: Python (NumPy, pandas, Seaborn), SQL
- Data Visualization: Tableau, Matplotlib, Seaborn, PowerPoint presentations
- Machine Learning: ARIMA modeling, predictive analytics
- Statistical Analysis: Hypothesis testing, advanced statistical methods
- Data Analysis: Exploratory Data Analysis (EDA), Data Cleaning, Transformation,Validation,Data Wrangling, Forecasting, Dashboard Creation, KPI Tracking
- Databases & Tools: AWS, Excel (advanced functions, pivot tables)
- Business Impact: Customer Purchase Behavior Analysis, Marketing Campaign Optimization, Revenue Growth Strategies
Timeline
Data Analyst
Affinity Solutions
06.2022 - Current
Data Scientist Intern
Ironwood Pharmaceuticals
02.2021 - 07.2021
Data Analyst Intern
Quadrant Resource
05.2017 - 11.2019
Master of Science - Analytics, Statistical Modeling
Northeastern University
Bachelor of Technology - Computer Science And Engineering
Jawaharlal Nehru Technological Institute
Similar Profiles
Nathaniel InosantaNathaniel Inosanta
Lead Technician at Affinity SolutionsLead Technician at Affinity Solutions
Jason FrostJason Frost
Director of Operations at Affinity Waste SolutionsDirector of Operations at Affinity Waste Solutions
ANSH MALHOTRAANSH MALHOTRA
Mortgage Broker at Affinity Mortgage SolutionsMortgage Broker at Affinity Mortgage Solutions