• Responsible for designing the foundation of the BI program at FlexCare.• Creates data pipelines using both internal and external data sources with Python, Tableau, MuleSoft, and SQL.• Designs, Builds, and Deploys RESTful APIs using MuleSoft.• Writes automation scripts as stop-gap solutions for delays in System Integration issues using Python, SQL & VBA.• Assesses whether automation requests are appropriate for a stop-gap solution or if they should be included in the long-term architecture goal of our integrated systems.• Assists CFO and VP of Finance with analysis projects that have high financial risk and impact.• Trains end users, administrators, and analysts on BI technology like Python, Tableau, Lucid Chart, Git, and SQL.• Writes detailed data-flow and process documentation in Confluence and company intranet.• Triages analytics JIRA tickets to analysts with appropriate skillset.• Member of the data governance committee that standardizes policies, roles, permissions and processes of data.• Works collaboratively with Business Systems Analysts, Architects, and Project Managers to ensure analytics needs are met before solutions are implemented.

• Created automation scripts that reconcile data between Salesforce and NetSuite.• Audited information between systems to ensure accuracy.• Advised senior leaders and IS on process flow improvements and data governance• Assisted Payroll, Client Billing, and Accounts Receivable Departments on resolving data issues.• Identified checks and balance audits that need to be performed and automate them.• Created NetSuite Saved Searches, Datasets, and Workbooks

Enhance the skills of students towards building a software application. Assist students to land a job that they want or implement the skills they would gain throughout their career.• HTML/CSS, Bootstrap, Sass• Javascript, NodeJS, React• MySQL, MongoDB• Git Version control, Linux commands, Windows configurations• Data structure/algorithm and Big O notation• Restful services• Excel, VBA, Pivot tables• Python Scripting, Flask server, Anaconda distribution• Numpy, Pandas, Matplotlib, Plotly• D3.js, Plotly.js, Leaftlet JS• Tableau• Predictive Analysis• Sci-kit learn, Tensorflow

Analyzed data to create the most efficient and cost-effective routes for drivers. Created data driven applications that automated data entry and minimized human error. Produced customized reports that allowed customers to make predictive decisions and maximize their market share. Monitored driver safety, identified potential risks, and implemented a reward system for safe drivers.• Lead the company through a difficult routing software implementation. Successfully connected new software's API to existing ERM. Trained staff on use of new software and implemented best practices. The new software allowed for a 20% reduction in total drive time between accounts and allowed the company to quickly expand into new territories.• Automated the process for billing audits. This task took normally required several days to complete between multiple staff and still had human errors. This was automated using Python and caught several thousands of dollars in billing errors that would have otherwise been missed.• Started a driver safety reward system that used GPS data to encourage safe driving. This reduced our number of at-fault accidents and ultimately was able to reduce insurance costs.• Reduced the number of office staff needed for data-entry positions by writing Python scripts that automated the process.

• Prepared leads for sales team by making preliminary graphic representation of the solar panels we intended to install on the customers home, along with a detailed savings analysis.• Bookkeeping, payroll, purchasing, and job costing.• Coordinated and scheduled projects.• Human Resources/Hiring

• Entered meter readings for billing.• Invoiced customers, collected payments, and prepared deposits.• Prepared new contracts for the Sales Manager.• Automated import of meter readings and toner orders of devices connected to the Kyocera database.• Answered phone calls on billing questions, toner orders and service issues.