Ian Mullins Email & Phone Number

California, United States

San Leandro, California, United States

•Provided team managers with guidance in making product, marketing and operations decisions from an analytical perspective. •Designed, ran, and interpreted A/B tests on product changes. •Collaborated on model design and implementation with Data Science team. •Worked with SQL, R, python, git and data visualization with Looker, Tableau, R/Python packages, others. [UNDER NDA]

San Francisco Bay Area

Project lead on key data analytics initiatives.• Daily use of Python, R, SQL(mysql + sql server), and Advanced Excel to perform analysis.• Responsible for Monthly and Quarterly Reporting along with data importing/exporting processes. • Lead Customer Life cycle study performing the full process of pulling, cleaning, merging, and analyzing a large data set consisting of multiple years of Phone Records, Client Contact records, and Client Outcome data.• Worked Directly with… Show more Project lead on key data analytics initiatives.• Daily use of Python, R, SQL(mysql + sql server), and Advanced Excel to perform analysis.• Responsible for Monthly and Quarterly Reporting along with data importing/exporting processes. • Lead Customer Life cycle study performing the full process of pulling, cleaning, merging, and analyzing a large data set consisting of multiple years of Phone Records, Client Contact records, and Client Outcome data.• Worked Directly with Department heads to develop smart dashboards with Looker and Tableau that answered common query requests heavily reducing workload and dependence on data analytics team.• Saved data analytics team 30 man-hours monthly by automating data cleaning previously performed manually in excel and automating the use of email to distribute the reports.• Developed internal tools to integrate data insights with the daily workflow of line employees and management.•Developed an Agency wide system to support client follow-up tracking:Created real-time connections from multiple databases to a single screen that summarized participant contact information and follow-up call history for Case Managers. While another view provided summary KPIs at both the program and agency level for Program Managers or above. Converted formal policies and informal heuristics into an algorithm that determines the appropriate type of follow-up for each client and suggests ways to improve contact rate (ie " X Client Needs A Six Month and One Year Follow up, the last 3 contact attempts were made unsuccessfully by Phone. Try contacting participant by email") Show less

San Francisco Bay Area

Primary responsibility was overseeing reoccurring client survey and reporting results to management:• Used Google Sheets to create dynamic master list of survey recipients and programmatically created individualized sheets for each employee responsible for administering surveys• Trained non-technical employees in the use of dynamic spreadsheets to improve data entry timeliness and accuracy. • Raised survey response rate from 55% to 87%• Produced extensive documentation for the… Show more Primary responsibility was overseeing reoccurring client survey and reporting results to management:• Used Google Sheets to create dynamic master list of survey recipients and programmatically created individualized sheets for each employee responsible for administering surveys• Trained non-technical employees in the use of dynamic spreadsheets to improve data entry timeliness and accuracy. • Raised survey response rate from 55% to 87%• Produced extensive documentation for the maintenance of automated systemsAnalysis:Used Python (Anaconda; Jupyter notebooks) and Microsoft excel for statistical analysis of survey data• Performed regression analysis. Multiple regression, logit, and linear probability models• Performed qualitative coding of survey data for classification and clustering• Create visualizations with Tableau, Matplotlib, R ggplotAdditional responsibilities & Accomplishments:• Assisting in preparing Monthly and Quarterly Reporting as part of Data Analytics team• Used Python & Selenium browser automation to completely automate certain monthly reports• Performing ad hoc Queries to databases at the request of various department leads Show less

Berkely

• Developed dynamic Microsoft Excel spreadsheets and improved performance of existing spreadsheets• Automated administrative processes such as report generation, saving 10 hours of work weekly• Used Python and Microsoft Excel to collect, clean, and format data from 7 years of unstructured Excelfiles.• Performed statistical analytics to create summaries and visualizations for use by senior staff.• Worked with team leaders to identify and target key client groups based on data… Show more • Developed dynamic Microsoft Excel spreadsheets and improved performance of existing spreadsheets• Automated administrative processes such as report generation, saving 10 hours of work weekly• Used Python and Microsoft Excel to collect, clean, and format data from 7 years of unstructured Excelfiles.• Performed statistical analytics to create summaries and visualizations for use by senior staff.• Worked with team leaders to identify and target key client groups based on data insights.• Developed individual client pricing models based on their prior transaction history. Show less

San Francisco Bay Area

Started by building computers for my classmates in high school.Solved the school faculties technical headaches so frequently I was hired upon graduation.Learning new things with each project keeps me passionate about what I do.Currently Automating the filing system of an entire company. Not open to additional clients at this time.

Martinez, Ca

• Provided classroom technological integration services along with web development and general I.T.• Increased participation in lesson plan digitization program from 10% to 25%

Master Of Science - Ms, Economics

Activities and Societies: Recreational Math and Computer Science Club, Statistics Tutor, Graduate Data Science Club. Degree Focus.

Bachelor Of Science - Bs, Economics

Activities and Societies: Analytics Club, Real Estate Club, Merritt Community Capital Scholar