PROFESSIONAL EXPERIENCE

Data and Reporting Manager

Confidential, San Marcos CA

Responsibilities:

• SQL Server: Responsible for administration of all enterprise databases. Maintained high availability and backups for all transactional databases within the company. Responsible for performance tuning of queries, monitoring replication, creating new database interfaces between applications, writing and maintaining ETL jobs, writing large TSQL queries.
• Business Intelligence: Maintained several OLAP reporting databases and was responsible for the oversight of over 500 reports written in SSRS, Crystal, Tableau, and MMR. Responsible for supplying ad hoc queries to Data Scientist teams
• Enterprise Resource Planner Administrator: Responsible for all operational functionality of the Epicor ERP system. System had over 300 users and controlled all aspects of accounting including: Accounts Payable, Accounts Receivable, Purchasing, Inventory, Receiving, Financial Planning, etc.
• Direct manager for three Tier II service desk personnel. Responsible for training and mentoring of these individuals, maintaining team performance goals, and performing project management for team members.

Senior Data Warehouse Administrator

Confidential, Carlsbad CA

Responsibilities:

• Senior administrator and developer for company wide Data Warehouse. Responsible for all elements of an OLAP database that was used by both international and domestic sides of the company. 90% of all ad hoc reporting and managerial accounting originated from this system. SSAS, SSIS, SSRS, SQL Server.
• Principle Database Administrator for all Enterprise applications except company ERP. Responsible for tuning of databases, troubleshooting errors, and maintaining a high availability service level agreement. Performance optimizing tools used: SQL profiler, Query Analyzer, Windows Performance Monitor, Data Engine Tuning Advisor. High availability techniques familiar with: log shipping, backup/restore, mirroring, always on availability, and clustering.
• Principle administrator for Salesforce.com. Created the interface between Salesforce and company ERP. Responsible for Salesforce reporting, customization of Salesforce UI, and general end user administration.
• Developed three enterprise wide dashboard reporting systems. Dashboards were used by all divisions of the company and included KPI’s, graphical drill down capability, parameter passing capability, and subscription capability. Developed multiple SharePoint content management sites and collaboration sites. SSRS, Crystal Reports, Performance Point, Excel, VB, SSAS, SQL Server, SharePoint.
• Developed over one hundred static and dynamic reports for various business units. Responsible for the analysis, development, distribution, and administration of most of the automated - high visibility reports within the company. Business units serviced were: Finance, Marketing, Accounting, IT, Manufacturing, Sales, and Customer Service. SSRS, Crystal Reports, Excel, VB, SSAS, SSIS, SQL Server.
• Principle administrator for automated ETL tasks within company. Developed and/or maintained 80% of enterprise application interfaces. Responsible for all automated alerts and reports. Automate, SSIS, SQL Server.
• Adviser to financial analytics team. Provided guidance to finance group on how to do complex predictive analytics, general statistical analysis, and general financial analysis. Gave regular training sessions to Financial Planning and Analytics group on how to perform such techniques as: regression analysis, data mining, score card creations, variance analysis, decision trees, etc.
• Project Manager for several enterprise projects.
• Responsible for implementation of Salesforce.com within the domestic side of company. Saleforce.com project involved 20 + individuals and took over 7 months. Agile, Pinbok, Jira.
• Responsible for the integration of foreign subsidiary ERP systems into main domestic ERP system. Lead an international team charged with bringing all sales and manufacturing data from Japan and Brazil satellite companies into the ERP of the parent US company.
• Responsible SOX auditing reports. Regularly created quarterly reports on network and application errors, and all change control requests.

Database Administrator

Confidential, San Diego CA

Responsibilities:

• Database Administrator for main company transactional database. Responsible for database tuning, database development, troubleshooting, and maintaining high availability. Database was a high usage system designed to capture home surveillance camera information. 24-7-365 uptime was required. Transactional replication and Linux heartbeat were used to maintain high availability. MySQL, Linux
• Data warehouse administrator and developer for company. Created a rudimentary data warehouse for company. Responsible for administration, training users, and some reporting and analysis. MySQL, 3rd party ETL tools, Crystal Reports, Excel.
• Created and administrated multiple internal applications. Programs included creating several interfaces between disparate applications, creating a camera usage application for customer service, and administration of cloud applications for Finance (Zora), and Marketing (Salesforce, Constant Contact). PHP, MySQL, HTML.
• Salesforce Programmer. Created interfaces linking a financial cloud application (Zora), Amazon, and corporate ERP with Salesforce. Maintained and developed automated email campaigns between Salesforce and Constant Contact. Responsible for mass uploads of data and changes to UI. PHP, Apex, MySQL, ETL.

IT Consultant

Confidential, San Diego CA

Responsibilities:

• Created and administrated multiple lead generation campaigns for real estate investment groups. Examples included: Internet advertising campaigns, email campaigns, organic and paid search engine optimization, craigslist campaigns, referral campaigns, and call center campaigns
• Created and administrated several lead generation web sites. ASP, VPScript, PHP, HTML, JavaScript, MySQL.
• Basic IT support and administration. Printer support, cloud application support, corporate email support, etc.
• Possess CA Real Estate License and acted as loan officer for several residential and commercial projects.

Data Scientist /Database Developer

Confidential, San Diego CA

Responsibilities:

• Performed technical and fundamental analysis on investment portfolios for the bank. Utilized several portfolio management methodologies including: Scorecard development, Regression Analysis, ANOVA, Monte Carlo Simulations, Heuristic techniques, Pattern Recognition, and General Charting and Trending analysis. Part of a team responsible for maintaining a 1.2 billion dollar portfolio of manufactured home loans. SPSS, SAS, XL.
• Applications Development. Acted as project lead and developer for the creation of several internal applications. Examples of applications created include: automated underwriting application, automated charge off request program, credit risk approval programs, multiple content management programs, and multiple reporting dashboards. VB, VBScript, JavaScript, HTML, Excel, Crystal Reports. Methodologies used: Agile, Waterfall.
• Database Developer. Responsible for creating databases, normalizing tables, creating indexes, and ER Diagrams. SQL Server, Oracle.