Abhipsha Chatterjee
Tucson
Summary
Self-motivated Data Analyst with over 6 years of experience across various industries skilled in Statistical Modeling, both Cloud based and ODBC specified Database querying, data extraction, collecting, cleaning and interpreting data sets, deploying Analytics and ML tools, and data visualization applications to build actionable insights for both business and end-user needs.
Overview
15
15
years of professional experience
Work History
Data Analyst
University Of Arizona Foundation
Tucson
08.2022 - Current
- Analyzed datasets to identify trends, patterns and correlations for fundraising insights using Blackbaud CRM as the primary donor centric data repository.
- Developed dashboards with Tableau to monitor key performance indicators of fundraisers, and forecast future revenue projections.
- Created predictive models to forecast donor giving behavior by using historical insights, current philanthropic donations, and other pertinent demographic data.
- Maintained documentation of all the processes related to Data Analysis.
- Utilized advanced analytics tools such as advanced Excel Analytics, Power BI, Pivot, to manipulate large volumes of unstructured data sets. Created simple and actionable insights by using existing donor data for improving fundraising knowledge across functional teams.
- Extracted Data from UAccess, created Reports and Dashboards for frontline fundraisers and other end users.
Senior Data Analyst Intern
DRB LLC.
Akron
01.2023 - 01.2024
- Utilized machine learning algorithms to predict customer behavior based on historical purchase behavior, current conversion rate from a single wash customer to a subscription plan member, and predicted churn & capture rate for a car wash operator.
- Conducted market driven experiments to optimize car wash pricing, predict revenue growth, and sustainable scalable solutions for car wash operators.
- Implemented predictive models to forecast market saturation trends for population behavior, migration patterns, and traffic volume data around car wash operator sites.
- Automated daily reporting processes with Snowflake Warehouse reporting using Python, SQL, neural networks, and Machine Learning algorithms.
- Worked with historical and existing customer data from various Point of Sale Systems by utilizing data pipelines to provide actionable insights into customer acquisition, operational behavior patterns, and other key business performance metrics.
- Performed various market research analyses for many car wash operators across the United States and provided insights related to their KPIs (Key Performance Indicators. Worked on promotions, discounts, and other product based selling strategies for overall customer health portfolio analyses.
Associate Business Analyst
Bright Properties
Tucson
02.2020 - 07.2022
- Apply mathematical models daily to calculate and check figures in all areas of accounting requirements and resolved unexpected and complex variances and anomalies.
- Oversaw documentation and reporting of expenses, sales, and other transactions daily.
- Reconciled account information and reported figures in general ledger by comparing them to bank account statements each month.
- Used Quantitative Analytics tools such as Excel, Power BI, and Google Analytics to understand user experience, needs, and risks associated with real estate housing and market scenarios to improve client expectations and needs.
- Maintain and adhere to business protocols and standards to create structured business practice in compliance with vendors and their businesses.
- Processed over 4000 invoices from multiple vendors and applied proper codes to invoices, files, and receipts to maintain organized records by using Quickbooks.
Vendor and Strategic Analyst
Gadsden LLC
Tucson
06.2017 - 12.2019
- Prepared and analyzed reports to enhance and automate accounts payable needs for vendors.
- Processed over 1000 invoices from over 200 local vendors in Arizona.
- Handled digital marketing for corporate events.
- Restructured procedures through online marketing and analysis tools to create and execute projects by Using Mailchimp, Google Analytics, and other Paid Social Analytics Tools.
- Conducted research and investigations into improvements in vendor management.
- Worked with survey instruments and questionnaires to obtain desired research data.
Research Analyst
D. E. Shaw & Co.
Hyderabad, India
07.2010 - 07.2011
- Worked on concurrent global recruiting projects for scientific and business development needs. and oversaw their hiring process.
- Made significant contributions to hiring process, recruited over 75 professionals, and handled tasks involving Resume Workflow System.
- Communicated and liaised between business and technology teams in India and New York.
- Worked on projects involving business intelligence needs by preparing reports and designing analytical solutions with cross-functional team peers. Interpreted data using Excel, Power BI, and SAS.
- Helped develop forecasting models based on historical performance data for future decision making purposes for hiring processes.
Data Analytics Consultant
Deloitte
Hyderabad, India
02.2009 - 07.2010
- Liaise between Deloitte Consulting and LabCorp of America Holding (Revenue Cycle Generation | Extended Business Office Solutions).
- Took resolutions on over 10,000 denied claims and contributed to process enhancement, automation, and accounts receivables contributing to over 75% revenue growth.
- Used data management and analysis tools to predict flaws in business models and implemented statistical projections to offset costs.
- Analyzed project-related data using SQL and Advanced Excel Analysis Tools to provide relevant solutions to clients and their business needs.
- Collaborated with cross-functional teams to scale and automate existing business requirements for business productization needs.
Education
Master's in Data Science - Applied Mathematics
University of Arizona
Tucson, AZCertificate - Data Analytics (Bootcamp - Online)
University of Arizona
Tucson, AZ11-2022
Data Analysis (Nanodegree) -
Dataquest
OnlineBusiness Analysis (Nanodegree) -
Udacity
OnlineMaster of Science - Applied Mathematics
Christ University
Bengaluru, IndiaBachelor of Science - Mathematics, Physics, And Computer Science
St. Francis Degree College For Women
Hyderabad, IndiaCertificate in Data Engineering & Data Science -
Snowflake
OnlineProvisional Degree - Applied Mathematics
University of California - Los Angeles
Los Angeles, CASkills
- P > C, C, Data Structures, JavaScript
- P > Oriented Programming, SQL
- P > R, Python, Matlab, SAS
- P > Google Analytics, SmartSheet, and Excel
- P > Salesforce, Blackbaud, Tableau, Snowflake, and Power BI
- Data Modeling
- Data Validation
- Business Performance Analysis
- Tableau
- Statistical Analysis using SAS
- Data Mapping
- Microsoft Access
Timeline
Senior Data Analyst Intern
DRB LLC.
01.2023 - 01.2024
Data Analyst
University Of Arizona Foundation
08.2022 - Current
Associate Business Analyst
Bright Properties
02.2020 - 07.2022
Vendor and Strategic Analyst
Gadsden LLC
06.2017 - 12.2019
Research Analyst
D. E. Shaw & Co.
07.2010 - 07.2011
Data Analytics Consultant
Deloitte
02.2009 - 07.2010
Master's in Data Science - Applied Mathematics
University of Arizona
Certificate - Data Analytics (Bootcamp - Online)
University of Arizona
Data Analysis (Nanodegree) -
Dataquest
Business Analysis (Nanodegree) -
Udacity
Master of Science - Applied Mathematics
Christ University
Bachelor of Science - Mathematics, Physics, And Computer Science
St. Francis Degree College For Women
Certificate in Data Engineering & Data Science -
Snowflake
Provisional Degree - Applied Mathematics
University of California - Los Angeles
Similar Profiles
CHRIS BAUGHANCHRIS BAUGHAN
Senior Application Support Analyst at University of Arizona FoundationSenior Application Support Analyst at University of Arizona Foundation
BREE BLAIRBREE BLAIR
Executive Assistant to the Chief Executive Officer at University Of Arizona FoundationExecutive Assistant to the Chief Executive Officer at University Of Arizona Foundation
Rufus J. FlomoRufus J. Flomo
Clinical Trial & Regulatory Coordinator at BIOMEDICAL RESEARCH AND EDUCATION FOUNDATION OF SO. ARIZONA, – SOUTHERN ARIZONA VA HEALTH CARE SYSTEM (SAVAHCS)Clinical Trial & Regulatory Coordinator at BIOMEDICAL RESEARCH AND EDUCATION FOUNDATION OF SO. ARIZONA, – SOUTHERN ARIZONA VA HEALTH CARE SYSTEM (SAVAHCS)
ZAID Ali ALJAZZAZIZAID Ali ALJAZZAZI
Investment Banking Analyst at Acquara Management ConsultantInvestment Banking Analyst at Acquara Management Consultant
Kody CampbellKody Campbell
Flight Logistic/Scheduler Coordinator at USAFRFlight Logistic/Scheduler Coordinator at USAFR