David Rojas, E.I. Email & Phone Number

Remote

Ca

Ca

Ca

Seaside, Ca

San Jose,Ca

Title: Data Scientist► Owner of LLC that provides analytical consulting services ► Created a web based billing system from the ground up ► Created the company websiteProfessional Work Completed for Clients:► 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.

Title: Business Intelligence DeveloperProblems I solved:► Automated the daily auditing of the companies set of Financial core reports.► Created a set of reports that monitor the entire reporting landscape. This 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. This 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.ORACLE Data Interface:► Main developer in the Suntrust and Wells Fargo bank migration.► Main developer in the payments system overhaul to the SSIS package.► Main developer in adding new functionality to the project after the new company merger.Initiatives:► 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. Because of my efforts, the Business Intelligence department has gained the freedom to use python as they see fit.► Introduced "Paperboy", a mini newsletter created in (html, python, javascript) that tells stories using data.► Successfully ported a local version of nbviewer to help meet the data needs of the company. Nbviewer will be the the main medium in which data analysis will be shared among power and business users.Notable changes:* Notebooks are housed and pulled from the company's private repository (SVN)* Added a link which shows the user the entire catalog of analysis* Provided links to data analysis lessons (pandas)Languages/Software: Excel, SQL 2005, SQL 2012, Visual Studio 2005, Visual Studio 2010, SSRS 2005, SSRS 2012, SVN (version control), Python

Title: Data AnalystProblems I solved:► 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 my skills in 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.Research:► Classifying Titles that Hold Value over Time► Customer Trends and Correlations► Data Driven Model to Aid Purchasing Decisions► Process ImprovementLanguages/Software: Excel, VBA, Access

Evaluated ISTEP writing section (Indiana’s Graduation Qualifying Exam) * Graded state required student tests

Business-to-Business Sales in the Health Care and Educational market * Assisted with demonstrations