Anchal Gupta Email & Phone Number

Seattle, Wa, Us

Data Scientist focusing on building decision models to help make the right tradeoffs between speed, delivery accuracy and cost under various operational situations.

Seattle, Wa, Us

Business Analyst - ACES QuBIT• Statistical analysis of current patterns in various fulfillment processes across hundreds of Amazon fulfillment centers in order to derive business insights for improving the fulfillment processes and provide improved customer experience.• Developing mathematical models for optimizing fulfillment processes in order to deliver products to our customers faster in a more efficient and sustainable way.

Redmond, Washington, Us

Worked on engineering satisfaction survey project for gaining insights about the satisfaction of Microsoft engineers with their engineering tools. The sample population is selected based on statistical analysis and calculations.• Calculate Net Satisfaction Score on different levels such as manager level, department level, experience level.• Performing hypothesis testing based on the sample population to whom the survey was sent.• Working on creating interactive Power BI dashboard and report which provides deep insights about the engineering satisfaction and present results monthly to the EVP of the org.• Also going to start working on cohort analysis project which focuses on categorizing engineers based on the kind of work they do instead of their job titles or teams. Using unsupervised machine learning techniques such as clustering to perform the categorization.

Oakland, Ca, Us

Developed a cloud-based consumer review analytics solution to turn online review data into insights by applying text analytics techniques like topic modelling, part of speech tagging, sentiment analysis etc. Consumer reviews and comments are collected from various online platforms such as amazon.com,walmart.com. Analytical solution is being developed using R, SQL and data visualization is being donein Tableau.• Independently developing the end-to-end product without much mentorship.• Researching and validating advanced text analytics techniques/APIs such as Google NLP and LIWC- to validate which API works best with customer reviews collected from the web.• Integrating R and Tableau to present the results of the analysis in the form of an interactive dashboard with excellent slice and dice capabilities.• Completed the data extraction, cleaning and transformation and exploratory data analysis within 3 weeks of starting the project.

Opportunity analysis project for increasing capacity utilization of the operating rooms across all CHI Franciscan hospitals. Extracted data using SQL and stored in SQL Server Management studio.• Analyzed about 500k records and developed a predictive model to predict the capacity utilization of operating rooms of CHI Franciscan hospitals after consolidating surgical specialties to specific locations.• Provided three recommendations for increasing the current operating room utilization by 30%.• Presented results to senior leadership on Power BI dashboards.• I was also the manager of my team of 3 people. Had multiple meetings with the client to gather business requirements, understand their pain points, translate data insights into business opportunities and give estimates.

Great Neck, New York, Us

Development and enhancement of Flextrade Suite of products .Developed customized proprietary algorithms while maintaining the confidentiality of the trading strategies.• Implementing trading algorithms like Multi Leg spreads, MxN baskets, Market Making Quoter, Volume Weighted Average Price (VWAP), Volume Participation while making sure the system has low latency and high throughput.• Wrote high quality code ensuring all requirements are met.• Delivered the project in 3 months with 100% certification testing.• Built metric dashboard to monitor KPIs for measuring health of the system.

Chesterfield, Mo, Us

Designing and development of robust billing solutions for tier I telecom and cable Industries using C++ and SQL. Owned complete software development life cycle from development to testing to deployment.• Participated in requirement gathering and also updated the clients with the deadlines and ongoing issues.• Mentored new college hires in my team and imparted project knowledge to bring them up to speed.

Armonk, New York, Ny, Us

Development and maintenance GMIA Powerhouse Direct Delivery System using IBM powerhouse and Shell Scripting for managing after sales business of General Motors.• Owned full-cycle development of a module for generating invoices and deployed the project successfully without any missing requirements.• Successfully migrated legacy system from Solaris to Fedora with zero downtime.• Awarded IBM’s Eminence and Excellence Award for outstanding contribution to one of the most critical projects.

Master Of Science - Ms, Business Analytics

Bachelor Of Technology (B.Tech.), Computer Science