Business Intelligence Analyst Python advanced SQL Machine Learning

PAYAL MISRA

+1-714-***-**** New York, NY

adgqa3@r.postjobfree.com linkedin.com/in/payal-misra-875735146/ https://notebooks.azure.com/payal-misra Highly analytical and result-oriented Analyst with four years of real-world experience in data interpretation, modeling, and visualization to solve challenging business problems using SQL, Python, Power BI, Tableau, Excel, and Machine Learning. ACADEMIC DETAILS

California State University Fullerton, CA

Master of Science in Information Systems and Data Science August 2017 – May 2019 St. Aloysius College Jabalpur, India

Bachelor of Commerce (Economics and Statistics) July 2013 – May 2016 KNOWLEDGE PURVIEW

Certifications: Certified Data Scientist by Codecademy, Machine Learning A-Z by Udemy, Google Analytics IQ by Google.com Tech Skills: Python, SQL Server, Tableau, Power BI, DAX, PowerQuery, Excel, PostgreSQL, Pivot Table, Macros, VBA, VLookup Data Science Skills: Data Mining, Data Wrangling, Data Visualization, Forecasting, Statistical Analysis, Hypothesis Testing, A/B Testing, Business Intelligence, ETL, Marketing Mix Models, Probability, Quantitative & Qualitative Analysis Machine Learning: k-NN, Naïve Bayes, Regression, Support Vector, Ridge, Lasso, K-Means, Arima, Classification Trees, Holt Linear Business: Marketing Analytics, Digital Marketing, Project Management, Business Analysis, Market Research Business Tech: CMS, CRM, Google Analytics, MS Access, MS Project, Qualtrics, MS Visio, MS PowerPoint, MS Dynamics, Azure DevOp WORK EXPERIENCE

Golden State Medical Supply, Incorporated Camarillo, CA Business Intelligence Analyst August 2019 - Present

• Designed and maintained database schema and transformed raw data into structured production level tables using advanced logical functions and stored procedures.

• Worked with the data team in transitioning to an Entity Data Warehouse and move existing pbix files to Azure Analysis Service.

• Performed ETL using SSIS from data sources like Microsoft Dynamics, and iContracts into SSMS.

• Developed forecasting models like Arima, Holt Linear, SES – Additive and Multiplicative, 3-6 MAT to project the future market demand using Python and Machine Learning modelling; resulted in better accuracy of the unconstrained demand plan.

• Automated monthly VA Data upload using Python replacing Excel and saving over 3 days of manual work.

• Managed, developed, and implemented the management and support of custom Business Intelligence dashboard, reports & data sets across the matrix for stakeholders in Sales Operations, Marketing, Business Development, and senior executives. California State University Fullerton, CA

Data Science Assistant January 2018 – May 2019

• Created and maintained course-enrollment limit relational databases in SQL Server Management Studio with over 5000 rows using JOIN and GROUP-BY functions; resulted in better-querying speed.

• Implemented machine learning clustering models like k-Means and Hierarchical Clustering to segment students requiring extra attention by analyzing their mid-term scores; resulted in better performance in finals. Universal Engineering and Scientific Works Pune, India Data Analyst January 2016 – June 2017

• Predicted the return on investment of planned marketing campaign using Python and SQL by evaluating Key Performance Indicators and metrics like potential reach, click-through rate, and approximate cost per acquisition.

• Created visually impactful graphs, charts, and dashboards for the marketing team in Tableau and Excel to showcase demographics, marketing performance, regional data segmentation, and marketing benchmark.

Contact this candidate