Sr. Data Analyst Resume
4.00/5 (Submit Your Rating)
Austin, TX
PROFILE:
Business Intelligence expert - finance, production, and statistics. Interacts professionally with all contacts. Team player, who learns quickly and works independently.
TECHNICAL SKILLS:
- Visual Basic
- SQL
- R
- Python
- HTML
- JavaScript
- CSS
- Tableau
- MS Excel
- MS Access
- MySQL
- SQLite
- R Studio
- Business Objects
- Power BI
- Salesforce
PROFESSIONAL EXPERIENCE:
Confidential, Austin, TX
Sr. Data Analyst
Responsibilities:
- Automate and generate regular sales reporting for 40+ sales executives across the nation
- Streamline and automate report generation, saving 250+ man-hours/year
- Map business process across six functions with Visio
- Enhance sales with dynamic reporting for 40+ executives
Confidential, Austin, TX
Data & Reporting Analyst
Responsibilities:
- Designed and developed custom data mart, integrating 5 diverse data sources to increase scope and value of reporting
- Created 12 recurring reports, tracking various KPI’s for multiple teams
- Automated report generation, saving 2,500+ man-hours/year
- Distributed reports online to a global team of 250+ people
- Proactively streamlined reports to reduce file size and download time by 75%
- Quantified 9 KPI’s, and ranked teams and individuals accordingly, augmenting managerial decision making
- Solved problematic date formatting with custom drilldown feature for 6 reports, allowing leadership to instantly validate outputs
- Scripted Partial Correlation Analysis in R to enhance Net Promoter Score analysis of 100+ recruiters
- Designed interactive reports and analyses, with user-friendly controls
- Formulated conclusions and interpretation of data to be presented to all levels of management
- Provided analytical and technical support on ad hoc projects and requests
- Monitored reporting usage and offered recommendations for consolidation
Confidential, Austin, TX
Excel VBA Developer, Proprietor
Responsibilities:
- Sold 700+ spreadsheets globally online
- Wrote and published book that teaches PivotTables, VLOOKUP, and other MS Excel skills
- Scripted SQL queries for Excel analysis and reporting
- Integrated Access database with Excel via MS Query
- Collected, analyzed, and reported statistical data
- Measured forecasting accuracy with linear regression analysis
Confidential, Beaverton, OR
Senior Financial Analyst
Responsibilities:
- Measured production accuracy with standard deviation
- Conducted SQL queries for Excel analysis and reporting
- Conducted statistical studies toward improving productivity and quality
- Forecasted short term workflow demand and adjusted staffing accordingly
- Created and disseminated Operational/Financial reports to management
- Proactively enhanced reporting for ease and usefulness
- Collected, analyzed, and reported historical data and trends
- Analyzed and reported corporate/treasury finances to upper management
- Extensive use of Excel and relational databases with large data sets
Confidential, Hillsboro, OR
Consultant - Financial Analyst
Responsibilities:
- Collected, analyzed, and reported sales and inventory data
- Streamlined retail operations and inventory management
- Implemented cash control procedures
