SUMMARY

• Proactive, detail - oriented analytical consultant wif 15 years of experience in data analytics and database management wif expertise in analyzing and interpreting data to drive business decisions

TECHNICAL SKILLS

Statistical Analysis: Regression, Decision Tree, Random Forest, K-means Clustering, Neural Network

Language: Python, SAS, VBA, SQL, Power Shell

Reporting: SAS Enterprise Guide, Tableau, IBM Cognos Analytics, SAS Enterprise Miner

Tools: SAS Enterprise Guide, SAS Enterprise Miner, Tableau, IBM Cognos Analytics, Jypyter Notebook, PyCharm, Unica

Database Platform: MS SQL Server, Teradata, T-SQL, MySQL, MS Access, Azure DW, AWS, Oracle, Snowflake

PROFESSIONAL EXPERIENCE

Lead Analytical Consultant

Confidential, Des Moines, IA

Responsibilities:

• Developed wide range of solutions starting from scratch to identify impacted customer population
• Used SQL queries to fetch and store data from legacy transactional systems
• Wrangled data and assessed data quality using native Python, NumPy and Pandas
• Worked wif business to finalize feature set in the data using quantitative and qualitative methods
• Executed exploratory data analyses in Python to find null values, outliers and patterns and correlations in the dataset
• Created complex visualization using Matplotlib and Seaborn
• Written programs/functions in Python to handle missing data and to fix structural data issues. Optimized process using Python pipelines
• Performed extensive features engineering in terms of scaling, encoding and engineering new features
• Presented the findings to management in terms of recommendations based on solid statistical analysis using Jupyter Notebooks and Tableau as tools
• Proficient in various aspects of statistical sampling and Power Analysis. Worked wif statistical SME for creating sampling plans and for various hypothesis testing
• Worked on advanced SQL including Windows function, CTE for data manipulation
• Involved in End-to-End Project Implementation: Problem definition, formulating the analytical approach, segmenting population and creating final impacted population based on the approach for remediation

Tools: Jupyter Notebook, Excel, Tableau 10.0, MS SQL Server Management Studio, SAS Enterprise Guide 7.2

Lead Analyst

Confidential, Itasca, IL

Responsibilities:

• Analyzed large and complex retail data and built predictive model, such as decision tree, optimizing and guard railing margin % for B2B customer wif annual impact of 3MM in contract business
• Validated results and compared Average Squared Error (ASE) between training and validation data, ensuring minimal and established model accuracy
• Compared new model wif other models, like Neural Network, Polynomial regression, Gradient boosting, Regression, and Maximal tree, choosing best model for implementation
• Designed and developed interactive visual analytics in form of dashboards in IBM Cognos analytics, tracking ASP movements wif COGS YOY at Department / Class / Subclass level and publishing to executives to take pricing measures
• Produced timely and other ad-hoc reports, such as category performance, KPIs and other performance tracking reporting, for executives using Tableau 10.0
• Recommended price to more TEMPthan 50K B2B customers wif annual margin impact around 4MM by running Quarterly Automated Price Review (APR) and Automated Custom Pricing process using SAS
• Queried and mined large data sets, connecting data from disparate sources like SQL and Teradata to identify insights and patterns, and applied both statistical and business noledge, ensuring accuracy of insights
• Conducted statistical analysis, such as linear and logistic regression, ANOVA, Hypothesis testing (AB Testing), time-series analysis, and classification models, designing creative analyses to address business objectives
• Developed Microsoft Excel based tool, finding potential margin opportunity for customer under different GPO
• Gained margin opportunity of around 1MM in a year by evaluating risk and opportunity, expanding Private Label Toner penetration into HP toner market share

Tools: SAS Enterprise Guide 7.2, MS SQL Server Management Studio, Tableau 10.0, Excel, Teradata SQL Assistant, Snowflake, IBM Cognos Analytics, SAS Enterprise Miner

Senior Analyst

Confidential, Itasca, IL

Responsibilities:

• Automation of Pricing methodology using advanced feature of SAS such as stored and compiled Macros and Regression model. This covered around 6000 complex contracts there by increasing the efficiency of the existing system.
• Developed Excel based Small Order Implementation tool using VBA programming for consolidating orders across customers to reduce Cost-to-Sale and thereby increasing savings for the customer on day-to-day basis
• Financial Analysis of data to select best alternate for the current bidding Items using SQL programming
• Reduced manual intervention to track sales and margin for new DBD accounts periodically using SAS and advanced SQL programming using windows functions
• Identified opportunities for price increase on private label items resulting in 700K impact
• Involved in automation of scraping TPM data across all the deals using SAS and VBA which is used to pull usage report and tract of accounts against their modelled sales and contribution margin on margin on monthly basis
• Quantify business impact on sales and margin from promotional campaigns using database marketing concepts
• Validated models include time series models, multivariate models, logistics regression, linear models, non-linear models, generalized linear models and other statistical models

Tools: SAS Enterprise Guide, SAS Enterprise Miner, MS SQL Server Management Studio, Excel

Data Analyst

Confidential, OKC, OK

Responsibilities:

• Generate Caseload reports using SAS programming and Enterprise Guide 4.3 to support quality improvement in program areas wifin Community and Family Health Services at OSDH
• Constructed, cleaned, and documented large datasets for various projects using SQL and MS Excel
• Enhance system performance and resolve existing glitches in system by constructing and deploying automated tools
• Provide reports through statistical analysis to management that help them in making critical decisions
• Introduced a stable programming environment that reduced errors considerably in creation of reports
• Implemented statistical sampling techniques in various setting including univariate, bivariate, multivariate methods wif extensive use of logistic regression

Tools: SAS Enterprise Guide, SQL, Excel

Graduate Assistant

Confidential, Stillwater, OK

Responsibilities:

• As a Data Analyst in department of English, analyze and research databases that contain complete information about students, faculties, laptops and other hardware
• Responsible for maintenance of all the inventories and other purchase related information
• Retain data records of all the employees and troubleshoot software and hardware issues

Tools: Excel, MS Access

Technology Analyst

Confidential

Responsibilities:

• Gathered, Analyzed and Prototyped Business requirement based on customer needs
• Experience at Enterprise level ETL development and ETL architecture using Informatica & Teradata
• Create procedures and user manuals, evaluate the risk factors for increased effectiveness of existing loan systems
• Analyze loan data present in relational databases using SQL server
• Skilled in quality control processes involving creation of design documents, testing protocols and performance reports
• Design and execution of multiple projects involving database management system technologies such as Oracle and SQL
• Contributed as a member of application development project team by working wif Client to gather requirements and evaluated the feasibility and usage of all requests put forth
• Lead a team of 7 Engineers and successfully implemented projects to build applications for BANK OF AMERICA using .NET framework and SQL Server for database management

Tools: C, C++, .NET, LOTUS, SQL Server Management Studio, Excel