TECHNICAL SKILLS

Machine Learning Algorithm: Logistic Regression, K - Means Algorithm, Support Vector Machine, Naive Bayes, Decision Tree, Apriori

Programming Languages: R, SQL, SPSS, Python (Libraries NumPy, Pandas, MatplotLib, Seaborn, Scikit-Learn, Plotly)

Data Preprocessing: Importing Libraries, Importing Datasets, Dealing with Missing Data and Categorical Data, Feature Scaling

Databases/ Visualization Tools/Big Data: Tableau, Tableau Server, Alteryx, Hadoop, T-SQL, SSIS, SSAS, SSRS, MS Excel, Essbase

PROFESSIONAL EXPERIENCE

Confidential, Cedar Rapids, IA

Senior Business Intelligence Developer/Analyst

Responsibilities:

• Designing and testing several complex Alteryx Macros and Analytic apps to solve finance allocation problems for business/Product lines
• Managing and melding large datasets across multiple databases using SQL and Alteryx that will foster analytical insights.
• Leading and implementing 3 projects for automated analytics figuring product expense, sales and revenue quarter over quarter
• Managing a team of 2 which focus on Forecasting revenue goals with less than 5% margin of error to achieve quarterly corporate goals
• Working with Finance leadership and developing data aggregation strategy for reporting, metrics dashboards, and self-service analytics
• Analyzing data from the weekly business plans and actual statistics to identify profitable revenue growth opportunities/insights
• Prepare, analyze, and distribute recurring and ad hoc reporting/analysis to monitor actual vs. budget results
• Developed and implemented high-performance process and task KPIs, reduced daily reporting time by 20%

Confidential

Marketing Data Analyst

Responsibilities:

• Single handedly developed Two-way cluster model in SPSS for targeted marketing, helped guide decisions for company, raised $4.5M
• Utilized T-SQL to pull insurance data from various databases and created various dashboards, reports to support business decision
• Applied logistic regression model using Python to predict product sales based upon historic data and ongoing marketing campaigns
• Managed and trained an Intern in technologies like Alteryx, Tableau and R while working on multiple projects
• Made solid recommendations based on statistical analysis and provide explanations for reporting results for internal operations
• Extensively used Alteryx, R, SQL for creating predictive models, data blending and preparing list for marketing campaigns
• Developed and managed 8 unique Tableau workbooks consisting of 30 dashboards to track performance of campaigns

Confidential

Data Analyst Intern

Responsibilities:

• Filtered, cleaned & Analyzed large datasets of crash data by connecting Python, SQL with ArcMap GIS using library Arcpy & sqlite3
• Assisted Iowa DOT by finding correlation between accident sites and reasons for crash
• Visualized analytical results—via charts, graphs, tables, etc.—in Tableau

Confidential

Research Assistant

Responsibilities:

• Analyzed Parkinson patients data with 676 attributes of each patient, applied PCA to reduce the dimensionality of the dataset
• Created Logistic Regression model and Visualized multivariate relationships in R to predict patient more prone to the disease
• Led a team of 6 members and prepared weekly agendas and presentations for staff meetings

Confidential

System Engineer

Responsibilities:

• Developed predictive model that were used to deepen relationships, strengthen longevity and personalize interactions with customers
• Analyzed data from the weekly business plans and actual statistics to identify profitable revenue growth opportunities/insights
• Extensively used R, SQL & advance Excel to fulfill analytical requests & drive new acquisition