Data Analyst Python

Smridhi Mangla

adfw9s@r.postjobfree.com 203-***-**** linkedin.com/in/smridhi-mangla-4404

Enthusiastic solution finder, astute in the latest technologies bringing strong familiarity with data analysis, data visualization and research skills. Motivated to provide technology solutions and add business value using business acumen. TECHNICAL SKILLS

Programming Languages: Python, R, C++, XML Databases: Oracle, MySQL, Microsoft SQL Server Tools and Technologies: Alteryx, Tableau, Power BI, SAS Enterprise Miner, SAS JMP, AWS Cloud Platform, HP-QC, Advanced Excel, MS Office, Business Intelligence tools, Snowflake, Shell Scripting, Apache Hive, Hadoop, PHP Data Mining: Predictive and Statistical Modeling, Machine Learning, Text-Mining, Forecasting, Time-Series Analysis Project Management: Agile (Scrum and Kanban), Waterfall, JIRA, Project Risk and Cost Management, Cost/Benefit Analysis, SDLC Certification: Alteryx Core Certified, Google Analytics PROFESSIONAL EXPERIENCE

Costco Wholesale, Business Data Analyst, USA May 2020 - Aug 2020

• Conceptualize and craft cohesive data visualization solutions showcasing services’ utilization counts assisting key business stakeholders increasing sales volume by 5%

• Designed scalable and efficient reporting solutions using Alteryx workflows to capture workforce productivity automating the recurring send thereby reducing manual efforts by 20 hours per month

• Deep-dive into member transaction analysis: study and visualize causality analysis to uncover opportunities anticipating 5%-8% improvement in retention rate

• Utilized machine learning algorithms and classification modeling to extract shopping patterns targeting prospective members

(~8M records) and optimize membership acquisition

• Provided segmented member data leveraging complex relational database systems to amplify email campaign results

• Facilitated budget compilation with time series analysis of membership renewal income forecasting future trend with a variance of 4.11%

• Implemented scalable statistical analysis on member base shift and e-comm memberships identifying key metrics to filter out underperforming warehouses

Sopra Steria Group, Senior Software Analyst, India Jul 2016 - Jun 2019

• Extensively leveraged complex SQL queries to support changes in aircraft defect management software decreasing monthly costs by 10%

• Handled large datasets; developed SQL reports; performed data management improving application interaction time by 12%

• Monitored risks and handled change requests through prototype demonstrations for Airbus client

• Carried out cluster analysis using data visualization as a POC for migration of a restrictive to desktop application to a responsive web application improving productivity by 20% bringing down error probability

• Self-starter in requirement gathering, feasibility study, estimations, transitioning requirements into functional specifications to accelerate the development

EDUCATION

University of Connecticut MS in Business Analytics and Project Management - GPA: 3.9 Aug 2019 - Dec 2020 Dr. A.P.J. Abdul Kalam Technical University BTech in Computer Science - GPA:3.9 (Hons.) Aug 2012 – July 2016 ANALYTICS PROJECTS github.com/smmangla

• Predictive Analytics Using machine learning techniques in JMP and Python performed data cleaning, data visualization, sampling, spot-check and k-fold cross validation to predict credit card loan defaulters

• Business Process Modeling and Data Management Designed a YouTube monetization database in Oracle creating PL/SQL procedures to search and calculate derived earnings from multiple sources

• Descriptive Analytics Incorporated statistical analysis using multiple regression techniques, ANOVA, parametric & non- parametric tests in R to predict a trend in life expectancy across countries

• Data Visualizations Built an interactive dashboard in Tableau providing ease of geospatial analysis and trend exploration facilitating COVID vulnerability study

• Data Mining Using text mining analyzed key factors to help streamline the product reviews and devise product review recommendation system using classification modeling in SAS LEADERSHIP EXPERIENCE

UConn Graduate Consulting, VP Client and Business Development, Connecticut Oct 2019 – Present

• Lead the activities of client project team setting strategic direction and conducting regular reviews into project performance

Contact this candidate