Alain Bedi

**** * ********* ***

Chicago, IL ****6 630-***-****

adj6j9@r.postjobfree.com

Highly analytical and process-oriented data analyst with over 9+ years of professional experience coupled with in-depth knowledge of database types; research methodologies; and big data capture, curation, manipulation and visualization and team management. Furnish insights, analytics and business intelligence used to advance opportunity identification, process reengineering and corporate growth. Strong experience with Machine Learning techniques.

Key Skills:

Project Management Organization & Leadership

Risk Assessment Critical Thinking

Time Management Teamwork & Collaboration

Clear writing Customer Service & Quality Assurance

Data Management: Database Design & Management, Data Quality Assessment, Data Analysis, Pattern & Trend Identification, Visualization of Data Insights

Computer Science: System Administration, Advanced Microsoft Excel Functions, SQL Server, SharePoint, MySQL, Oracle,

R, SAS Enterprise, Python, Regression Analysis, Statistical Computing Methods, Quantitative Methods, Business Intelligence (BI), Minitab, SPSS, Unix scripting, Weka Data Mining, Enterprise Guide and Enterprise Miner

Research: Research Data Management, Data Science Research Methods, Data Warehousing, Advanced Data Mining, Survey Creation, Focus Groups, Experimental Design & Analysis

Professional Experience

Senior Analyst, Ancillary Revenue (Great Wolf Resorts)

February 2020 – September 2020

Project manage recurring senior review and recommendations across all three lines of business as well as Commercial teams, including web, app, and creative

Develop new, and enhance current, tracking and measurement tools to ensure senior initiatives progress on schedule and are accelerated where possible to deliver on targets

Provide regular reports to stakeholders of impacts of most recent price changes

Perform ad hoc analysis on price opportunity or impact for specific lodges and/or outlets

Collaborate with corporate LOBs to understand their strategies and tailor senior recommendations in order to drive performance

Adhere to and promote the use of data administration standards. Create and populate meta-data into repositories.

Various Short-Term Contracting Engagements

Dialysis Care Center, Allstate, GHP, Insurance Auto Auctions.

October 2017 – February 2020

Support data selection, extraction, and cleansing for corporate applications, including data warehouse and clinical data marts.

Create and sustain processes, tools, and on-going support structures that enable reuse and efficiency.

Investigate and resolve data issues across platforms and applications, including discrepancies of definition, format and function.

Responsible for coding, testing, and creating customer-level tables that can be used to generate reports and ad-hoc analyses.

Bundle data where information must be compiled on multiple consumer products.

Create data models, including robust data definitions, which may be entity-relationship-attribute models, star, or dimensional models.

Employ data mining techniques to achieve data synchronization, redundancy elimination, source identification, data reconciliation, and problem root cause analysis.

Owned and developed all aspects of analytics initiatives on clinical data and reporting tools for various short term clients.

Using SQL, Excel, BI tools. Designed ad-hoc analysis of key trends. Wrote and developed programs and deep learning algorithms.

Senior Data Science Consultant (Cole Parmer)

October 2016 – June 2017

Developed customer acquisition modeling to transform into high client value using SAS. Used programming and data manipulation languages (Python).

Developed media/marketing mix automation across a variety of channels. Developed and built out testing and implementation strategies.

Operated with little supervision in a complex and dynamic, matrixed environment.

Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines.

Automated Daily Reports issues and resolved problems with workflow process and modules.

Designed and wrote programs for data extraction, segmentation and statistical analysis using languages such as R, SAS, SQL, Hive.

Delivered analytic insights and recommendations in concise and compelling presentations for internal and external customers and an executive audience.

Developed integrated customer solutions supported by the company.

Fostered a high performance culture and cultivated an environment that promotes excellence.

Senior Data Scientist (Kemper Insurance)

June 2014 – June 2016

Developed GLM models for Auto Rating Plan filings using SAS and Excel. This led to improving the previous model maintaining cash premiums of $200 million.

Mined large data sets utilizing SAS and provided actionable insights to help understand and price the highly volatile insured.

Created strategic technology platform vision through partnering with Executives that seeks to expand revenue.

Developed programs, codes and deep learning algorithm.

Worked closely with operations, and marketing teams to completion.

Developed processes and solution improvements.

Designed ad-hoc analysis of key trends.

Identified and executed on opportunities to optimize prices, reduce expenses, and found areas to grow the service contract business.

Serviced custom reporting and ad-hoc analysis.

Underwriting Pricing Analyst Manager (Sears Holdings Corporation)

July 2013 – March 2014

Mentored team of analysts while managing multiple projects with an emphasis on productizing analytical reports. Developed, owned and managed all aspects of pricing and underwriting for the service contract business. Identified and executed on opportunities to optimize prices, reduce expenses, and found areas to grow the service contract business.

Worked closely with operations, finance, and marketing teams to drive initiatives to completion.

Led a team in their ability to examine and develop work processes, created solutions, and measured improvements.

Designed repeatable processes for producing client-ready analysis of online and industry trends.

Supported Sales and Client Services teams by producing ad-hoc analysis of key trends in the financial services sector.

Serviced top tier credit card client in data capture, custom reporting, and ad-hoc analysis.

Extracted, transformed, and analyzed data from data warehouse, generated reports, insights, and key conclusions.

Identified gaps in data quality, coordinated with internal problems to address root causes.

Applied strong analytical and predictive modeling techniques to inform Senior Management of key trends to acquire and keep company clients adding value by more than $1 million dollars.

Senior Strategy Lead Analyst (OfficeMax)

June 2012 – July 2013

Trained, supervised, supported and coordinated the activities of team members to ensure departmental goals and objectives were met.

Used time series analysis and forecasting method to develop company’s class elasticity model determining the impact of a price change on products sold.

Mined pricing and customer buying patterns and submitted recommendations to adjust strategies to promote a more profitable product selection.

Worked as the primary research consultant for the Pricing and Strategy Team.

Developed customized research solutions and translated the results into actionable strategies or business decisions for internal and external clients.

Created and modified programs, codes and deep learning algorithm.

Provided management reports on a weekly basis of individual and team activities in support of customer service level objectives and commitments.

Transformed large amounts of raw public records data from a variety of sources into searchable databases for customer access on a timely basis consistently attaining 95-98 % availability goal.

Identified and resolved any processing and/or procedural issues as they occurred minimizing any customer impacts.

Analyzed and implemented any enhancements related to assigned processes to reduce processing time to improve customer service.

Manager, Data Mining (Catalina Marketing, Inc )

April 2010 – April 2012

Extracted data from the database using SAS SQL procedures, R and python and created SAS data sets, analyzed and output results in several MS office applications. Coded SAS programs with the use of SAS/BASE and SAS/Macros, and Machine Learning for ad hoc projects.

Collaborated with Principal Data Scientist and clinical operation protocol development (objectives, study design).

Strong UNIX scripting.

Built predictive model to predict highly likely users of various grocery products.

Presented results and statistical reports in PowerPoint for sales and marketing staff.

Used regression model to select loyalty card owners most likely to buy and assigned them coupon incentives.

Transferred and migrated data from one platform to another to be used for further clinical analysis.

Built predictive models that were implemented to increase new acquisitions for credit card companies.

Trained new Analysts to support Analytical team.

Experience working with pharmaceutical data and clinical data to target health oriented candidate for medical products.

Wrote and developed programs and deep learning algorithms.

Compiled and validated data from six different aircraft units. Provided KPIs, analyzed metrics and generated reports that were used at the highest levels of executive management to make decisions for all units.

Created Access database and Excel macros that improved data sharing across multiple DB locations.

Assessed end-user requirements and communicated customer's technical needs to development team. Effectively served as a communications interface between the two parties.

Education

DePaul University, Naperville, IL

Master in Applied Statistics (2010)

University of Saint Francis, Joliet, IL

Bachelor in Mathematics and Actuarial Sciences

Contact this candidate