| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
EducationJames Madison UniversityMay Street Address | BBA Business Management with Minor in Business Analytics Major GPA: 3.Street Address
Minor GPA: 3.Street Address
SkillsPower BI, DAX, PL/SQL, Oracle (Toad), SSIS, Tableau, Data Visualization,
Microsoft: Excel, VBA, Power Query, Power Apps, SharePoint, Visio, Project, AccessWork ExperienceAnalyst | Virginia Linen ServiceJanuary 2018 | Present Sole analyst for company with 13 branches and 1000+ employees Created and maintain various Power BI dashboards and set them up to update automatically Sole Admin Managing user roles and security access of Power BI platform Used Power Query to transformed and merge various datasets for use in ad hoc and continuous report generation Wrote VBA Macros to refresh data pulls and transform data into final usable report Used VB Scripts and Batch Scripts to automate macro runs for recurring reports Utilized Excel, VBA, VB Scripts and Batch Scripts to automate a daily task which saved branch managers a collective 20-25 hours each week Worked with sales, marketing and GM s to create a pricing tool which assesses contract profitability in the field and expedite customer sign up process Pulled data from various sources into Excel to reshuffle inventory among branches. Reducing inventory shortages by 30% in region 1 and 26% in region 2 Created branch performance dashboards in Excel and prepared slides in PowerPoint for manager s meetings Troubleshot various existing Access databases Created inventory forecasting tool for certain special items with particularly long lead times Provided Excel related troubleshooting for majority of the non-technical users in companyData Analyst | Dept of Juvenile JusticeJanuary 2019 | August 2019 Wrote PL/SQL scripts in Toad to pull data and export it to Excel for further analysis Documented data pull processes in Word for non-technical users Maintained monthly population report in ExcelVolunteer Data Analyst | Chesterfield County ISTFebruary 2017 | May 2017 Spearheaded Power BI dashboard project to visualize and segment department and project manager efficiency and effectiveness using timesheet and project management data
Piloted the Twitter stream analytics project- This helped to analyze the sentiment of various keywords related to the county. After finding an open source sentiment analysis package I set up a data pull into event hub and then a stream analytics job in Azure to transform data into useable format, moved it into long term data lake storage and then created dashboards Gave demonstration of Microsoft Azure s Machine Learning Workspace and data mining techniques to deputy CIO of Chesterfield County Spent free time working on a variety of datasets to get better acquainted with Azure s Machine Learning Workspace and machine learning techniques as a whole Creating SCD (slowly changing dimensional) table packages (historical and changing) in SSIS Data aggregation, table creation, joins and creating views in SQL server 2016Executive Assistant l Lawyer StaffingJune 2012 l January 2018 Updated jobs listing page on company s WordPress and documented process for future use Analyzed and Summarized candidate resumes and created an Excel Spreadsheet with relevant information Wiped hard-drives and reinstalled drivers to prepare computers for charitable donationCoursework Descriptive analytic methods- Used pivot tables, descriptive statistics and data visualization to quantify various business metrics Quantitative business modeling- Built models using a combination of: linear, nonlinear and evolutionary optimization techniques to solve a variety of business techniques. We would run simulations on customer demand to forecast sales and help decide price points for a portfolio of products, followed by writing a report with various suggestions based on manager s acceptable risk tolerance (plan A 90% chance of making $100,000, 3% chance of losing money, plan B 70% chance of making $250,000, 10% chance of losing money etc). We did similar projects with financial portfolios. A particularly interesting project was the final project which involved building a model for an internet caf to find optimal number of workstations to have open and the ideal hourly rate in order to maximize profit. First I fit a Poisson distribution to customer arrival data. Then I ran a simulation to assess variation in queue length and minutes a customer spends waiting. From there I ran evolutionary solver to find the optimal values and wrote a managerial style summary report breaking out a few different options and their respective average return and risk levels. Data Mining- Used linear regression, logistic regression, classification/regression trees, neural networks, na ve Bayes, hierarchical analysis, k-nearest neighbors, association rules, etc. in Excel s XL Miner add-in to extract potentially important patterns and targetable business opportunities from large datasets. Applied Linear Regression- A deep dive into various regression techniques using R |
