We provide IT Staff Augmentation Services!

Senior Business Intelligence Developer/analyst Resume

Cedar Rapids, IA

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

Hire Now