SATARUPA ROY CHOUDHURY

***** ****** **. ***# ****, Rancho Cucamonga, CA91730 313-***-**** ad2t2c@r.postjobfree.com Green Card EAD Holder

Profile Summary

• Have overall 10 years of experience in data analysis, statistical modeling including data extraction, visualization techniques, interpretation, reporting, and forecasting on various projects.

• Have 11 months of professional experience as a data analyst in analyzing and interpreting vast data sets and resolving complex problems and providing key insights and avenues for future research for clients.

• Experience in developing and implementing strategies to optimize statistical efficiency and in providing data mining solutions to resolve complex business problems and provided key business insights.

• Experience in using applied statistical data analysis like multivariate regression models and supervised and unsupervised machine learning (ML) tools like K-means, hierarchical clustering, random forest to build predictive statistical models to extract information from large data sets.

• Experience in using Time Series Analysis to identify, interpret, and forecast trends or patterns in complex data sets.

• Utilized marketing mix modeling (MMM) and marketing ROI (MROI) to optimize marketing campaigns and increase revenue.

• Experience in creating dashboard using visualization tools like Tableau, Power BI

• Extensive work experience using data analytic technologies like Python and SQL

• Advanced level experience in using MS suite such as Excel, Power Point, MS Access to dump data and analyze based on business needs.

• Excellent communication, analytical, problem-solving, and root cause determination skills. Key Skills

Data Analysis Statistical Modeling Marketing Data Mining Data Profiling Data Validation Data Visualization

Time Series Analysis Programming Project Management Spreadsheets creation Dashboard creation Survey Creation Problem Solving Communication Logical and Analytical thinking Technical Skills

• Programming Languages: Python (NumPy, Pandas, Scikit-learn, Matplotlib), SQL

• Statistical knowledge: Sampling/Re-Sampling Methodology, Statistical Modeling and Forecasting model, Regression Analysis, Hypothesis testing.

• Computer: MS suite (Word, PowerPoint, Advanced Excel)

• Software/Tools: Tableau, SPSS, Power BI, Adobe Analytics, Google Analytics, Qualtrics, NodeXL

• AI: Machine Learning (Supervised, Unsupervised and Semi-Supervised)

• Certificates: Google Ads Search Certification, SPSS Professional Experience

Task Impetus Inc. March 2023 – Present Data Analyst Responsibilities

• Gather, preprocess (extract, eliminate irrelevant data, compile, and normalize), analyze and interpret appropriate primary and secondary data to resolve complex business problems and provide key business insights to clients to grow the business.

• Apply statistical data analysis like hypothesis testing, multivariate regression models and supervised and unsupervised machine learning (ML) tools like K-means, hierarchical clustering, random forest to build predictive statistical models to extract information from large data sets.

• Use forecasting to translate analyses into actionable business recommendations.

• Interpret research data to identify patterns and underlying trends that were utilized by a Marketing Manager to identify new market opportunities.

• Create models by applying robust predictive/prescriptive modeling methodologies.

• Provide recommendations and strategic plans based on the analyzed data and market knowledge through presentations, data visualization (using Tableau) and written reports. Environment: Windows, MS excel, SPSS, Python, Tableau, MS project, SQL. Data Analyst Tutor June 2018 – February 2023

Responsibilities

• Independently taught basic and advanced level of data analysis used in Marketing and Economics to over 100 undergraduate students from India in each academic year.

• Taught data cleaning, data visualization, python foundation, and business statistics.

• Taught statistical concepts such as Sampling/Re-Sampling Methodology, Statistical Modeling, Time Series Forecasting model, Regression Analysis, and Hypothesis testing.

• Guided students in doing projects to analyze secondary data by using SPSS.

• Communicated with students to ensure they understand the coursework.

• Helped students in resolving any team conflicts by identifying the source of the problem and then by communicating with team members in person and listening to them. Mike Ilitch School of Business, College of Liberal Arts and Science Wayne State University (Detroit, MI) August 2015 – May 2018 Instructor Responsibilities

• Independently taught Undergraduate level Business Administration courses (Quantitative Method in Probability and Statistics) and Economics courses to over 100 students in each semester.

• Methodically planned and executed lesson plans by prioritizing and multi-tasking including collecting necessary resources to complete a given lesson to explaining the theoretical and quantitative concepts with apt examples.

• Built relationships, presented, influenced, and communicated with over 100 students and ensured all students felt attended to with personalized feedback, class discussions and encouragement.

• Worked under a fast-paced environment with efficient time management to meet grading and feedback deadlines to hundreds of students.

Additional projects

MARKETING RESEARCH PROJECT - Lincoln’s Carry Outs Marketing Research August 2020 - August 2022

• Designed an online customer survey and analyzed the acquired data using SPSS to find meaningful insights.

• Created informative data visualizations to communicate data insights and actionable recommendations. PRODUCT MANAGEMENT PROJECT – Secondary Data Research August 2020 – August 2022

• Analyzed and interpreted customer consumption data (quantitative) and provided key business insights to optimize customer experience to improve customer relations.

• Observed customer interaction, recommended for new account acquisition, and increase in customer retention rate to promote the product.

• Analyzed the phases of the product lifecycle to lower cost and time to market the new products.

• Conducted portfolio management of newly introduced products which included preparation of ad-hoc analysis.

• Implemented machine-learning based ROI evaluation tool to achieve higher profitability with promotional efforts.

• Benchmarked the company’s performances against competitors to support the development of new pricing structures.

DIGITAL MARKETING PROJECT – Google Online Marketing Challenge (GOMC) August 2020 – August 2022

• Provide marketing consultation for a paired nonprofit organization to evaluate and manage their Google paid advertising campaigns, marketing campaigns.

• Tracked and analyzed performance to help build an effective digital marketing strategy and recommended opportunities for improvement.

• Managed social media channels and designed paid social media content and flyers.

• Created surveys and dashboard using Qualtrics.

• Design and launch Google paid search and retargeting as well as Facebook campaigns for the organization.

• Perform A/B testing for digital ads to maximize their effect and efficiency in terms of CTR and conversions.

• Leveraged all available analytics data sources and effectively translated findings to digital campaign strategy improvements that positively impact the top of the page rank (80%) and average CTR (6%).

• Conducted and analyzed digital marketing report to provide a comprehensive view of marketing performance and proposed optimizations to customers.

• Advised clients on SEO and SEM practices and provided specific methods to increase website traffic and conversions.

HEALTH ECONOMICS PROJECT – Secondary Data Research August 2015 - August 2017

• Constructed and proposed an alternative holistic index measuring both the qualitative and quantitative aspects of health in HDI using OECD Health Statistics 2014 database. DEVELOPEMENT ECONOMICS PROJECT – Secondary Data Research August 2010 - August 2012

• Develop an Inequality Index and a Multi-dimensional poverty index using Rural Household Data (2005) to estimate poverty in rural West Bengal, India and describe the data with the help of the constructed indices.

• Cleaned and analyzed the data set, tested the hypothesis and used the appropriate statistical models to create the index.

Education

MASTER OF SCIENCE, MARKETING ANALYTICS (MSMA) - California State University Long Beach - GPA: 4.0 August 2022

• Marketing Management, Marketing Analytics, Pricing Analytics, Digital Media Marketing MASTER OF ARTS, ECONOMICS – Wayne State University - GPA: 3.48 • August 2017 Specialization: Health Economics and Labor Economics MASTER OF SCIENCE, ECONOMICS – University of Calcutta – First Class August 2012

• Specialization: Advanced Econometrics

BACHELOR OF SCIENCE, ECONOMICS – University of Calcutta August 2010

• Minor: Statistics and Mathematics

Achievements and Awards

• Awarded Delta Sigma Pi Honor Key for achieving the highest grade-point average in the College of Business during MSMA, August 2022.

• Successfully completed multiple basic rock-climbing training courses from Howrah District Mountaineers and Trekkers association (affiliated to Indian Mountaineering Foundation, New Delhi) 2001-2007.

• Certified for ‘Value Education Workshop for Senior Students’ by The Ramakrishna Mission Institute of Culture, Golpark, Kolkata in 2005.

Contact this candidate