Senior Data Analyst Resume
2.00/5 (Submit Your Rating)
Seaside, CA
TECHNICAL SKILLS:
- SQL/T - SQL/PL-SQL/SQL*PLUS Python
- HTML/CSS/JS SVN (version control)
- SSRS (SQL Server Reporting Services) Web Development
- Microsoft Excel JIRA
PROFESSIONAL EXPERIENCE:
Confidential
Senior Data Analyst, Seaside, CA
Responsibilities:
- Identified and resolved potential duplicate identities using IBM Initiate
- Discovered bulk opportunities via SQL that identified duplicate identities
- Overhauled and optimized unclear and unstructured SQL code that ran on big data
- Developed PL/SQL scripts using SQL PLUS
- Automated manual reports using VBA, Excel macros, and Powershell
Confidential
Data Scientist, San Jose, CA
Responsibilities:
- wner, providing analytical consulting services
- Created company website and web based billing system from the ground up
- Created a Python reporting web application
- Developed web based interactive dashboards
- Investigated data issues with reports and as a result uncovered issues with the back end system, which led to an improvement to the system
- Liaison with both business and technical users
- Audited reports to verify accuracy and report execution success rate
- Implemented new functionality to existing reports and led the efforts in strategically testing the reports to verify their accuracy
- Taught students about Pandas and the IPython/Jupyter Notebook
Confidential
Business Intelligence Developer, Gainesville, FL
Responsibilities:
- Automated the daily auditing of the companies set of financial core reports
- Created a set of reports that monitor the entire reporting landscape, which allowed the team to instantly put out fires before the end user is even aware of the problem
- Overhauled and optimized unclear and unstructured SQL code
- Created a system to track table and/or column changes that have occurred in the system, which allowed the team to quickly determine if any changes were needed on the reporting end
- Developed a set of metrics that monitored the performance of the reporting catalog
- Main developer of the ORACLE Data Interface for the SunTrust and Wells Fargo bank migration
- Introduced the department to the python ecosystem (Python, Pandas, and IPython), an open source tool that will allow us to perform from simple to complex data analysis
Confidential
Data Analyst, Miami, FL
Responsibilities:
- Increased the efficiency of the ordering process by automating repetitive tasks, eliminating unnecessary steps, creating an alternate ordering process, updating old data, combining queries, and improving profit reports using Microsoft Excel, ACCESS and Visual Basic, which led to a 30% increase in efficiency.
- Reduced the manual process of checking incoming shipments by building a process using Microsoft ACCESS that automatically reduced tasks by 50%.
- Improved the company’s sales report which is used to track orders, cash flow, inventory level projections, estimating profitability by adding various pivot tables/charts and smart formulas that update automatically as new data is available.
- Created and updated my department's procedural manuals which are currently being used for training of new team members.
