Resume

Sign in

Database developer, data analyst

Location:
Marina del Rey, California, 90292, United States
Posted:
August 13, 2019

Contact this candidate

Resume:

Matt Herman – Data Analyst / Software Developer

Marina Del Rey, California 90292

Home: 424-***-****, Email: ac92ok@r.postjobfree.com

Professional Qualities

Highly inventive thinker and problem-solver. Enthusiastic learner who can rapidly absorb and synthesize information and ask the right questions. A seasoned, versatile programmer who is a specialist in finding better, more efficient ways of doing things. Superb written and verbal communication skills with experience in writing and editing. Communicates at the appropriate level of detail in knowledge transfer. Effective trainer and project leader. Enjoys documentation of Information Systems. Fosters computer independence in users and co-workers. Able to evolve and adapt to diverse situations and personalities.

Technical Skills

SQL / Database development MSSQL, MySQL, PostgreSQL, PL-SQL (basics), advanced stored procedures, user-defined functions in MSSQL, MySQL, PostgreSQL, XML queries, query optimization, 10+ years MS Access development, complex interfaces and ODBC/MS Access integration with MSSQL/MySQL

Business Intelligence / Reporting SQL Server Reporting Services (SSRS), SSIS, ETL operations with MSSQL/MySQL/PostGres, advanced Excel pivot tables, advanced MS Access reports, Crystal Reports, data parsing, scrubbing, validation with MSSQL/MySQL, programmatic output and management of MS Office documents with VB and C#.NET, in-depth documentation of Information Systems

Web development / Programming: Front end web: HTML5, CSS3, JavaScript, Bootstrap, JQuery, other JS libs, HTML Canvas Server side: C#.NET, VB.NET, ASP Classic, PHP (basics) CMS: WordPress, Drupal, Intranet Dashboard Ticketing: JIRA, ZenDesk, FogBugz API’S: Google Maps API, Facebook (some), Tools: PowerShell, MS Office/VB, Visual Studio, SSMS, SSMS Developer Tools, Acrobat SDK, Firebug, Dreamweaver, MXML, ActionScript 3

Media / Graphics / Other Photoshop CC 2019 – image editing (intermediate) and timeline animation (basics), Adobe Premier/Aftereffects CC 2019 (basics), knowledge of vector graphics, layers, compositing, image optimization Earlier systems: Adobe Flash (timeline animation), Script-driven animation (ActionScript 3), Image batch processing (Photoshop “Actions”) Sound: Recording, GoldWave, Audacity, NyQuist script

Original Applications (ask me): Action Scripter (ShipMate), IPRI, SiteBlocks, Color Muddles, InterReader, Beat Explorer (NyQuist script-generator)

Education/Training

2017 Coursera – JavaScript Certification

2009 UCLA Extension--Certificate in Web Technology (in progress) Coursework:

Business Reporting (BI, Microstrategy) Fall 2009; C#.NET and OOP, 2009; MS SQL Server 2008 (T-SQL), Spring 2009; .NET Dev. (CSLA Framework), Winter 2009

2000 SQL Server, Oracle PL/SQL, Learning Tree International, Los Angeles, CA

1996 CNE, CNA DataComm Networking Technologies, Palos Verdes Estates, CA

1993 BA, English Literature/Education, California State University Long Beach, Long Beach, CA.

Work History and Accomplishments

2/2018 - 3/2019: Data Analyst, Hispanic Scholarship Fund (HSF), Torrance, CA

Transformed 150+ unique, complex data-sets from “raw” ETL output into reportable data via PostGres queries, authored PowerShell scripts working with AWS client to copy\rename files, wrote SQL scripts for automating lengthy, tedious schema info extraction process. Advocated for critical changes that were accepted.

3/2017 - 11/2017: Consultant/Business Analyst, CCEO Youthbuild, Lennox, CA (part time)

Detailed evaluation and specs for Community Service/AmeriCorps data tracking app and for HRRP Housing Rehab/Remolding program tracking app, evaluate previous tracking system for training cycle updates

3/2016 - 2/2017: Senior Programmer, Avalon Transportation LLC, Culver City, CA

Modified SSRS reports, Ad-hoc SQL queries, and some SSRS admin, periodic: CSAT, Paychex and company intranet admin tasks, Vertical Response surveys, WordPress on corporate site, C#.NET/Webforms form filler prototype, other apps in MS Access, pre-implementation Intranet Dashboard as replacement solution. Authored complex MSSQL procedure to complete email extraction steps, other reporting SQL procs,

10/2015 - 2/2016: Analyst / Developer, Robert Half Technologies (short and mid-term contracts)

1/2016-2/2016: SQL Developer, Gladwell Governmental Services (scrubbing and transforming city housing data, queries in MSSQL and MS Access, formatting results with detailed notes)

10/2015-11/2015: Business Analyst, Musician’s Union Local 47, Hollywood (SQL fixes to MS Access/MSSQL reports, develop requirements for new system)

10/2015: SQL Programmer, Doheny Eye Institute, Los Angeles, CA (Transformations of account information with MSSQL)

07/2015-09/2015: Developer/Analyst, Mercury Media, Santa Monica, (ETL, MSSQL procs, greatly streamlined data processes, .NET prototype, replaced inefficient system of Excel lookups, conducted extensive discovery interviews with staff, authored detailed results report)

2/2013 - 6/2015: Data Engineer (Business Intelligence), Swagbucks/Prodege, LLC, El Segundo, CA

Authoring advanced SQL queries of large MySQL database for end-user reports and data warehousing working with in-house Java-based reporting user interface, SQL re-structuring of online survey and internet marketing data, output of complex month-end reports through SQL/Excel process, creating ad hoc and ongoing Excel pivot tables, servicing in-house reporting-related customer tickets on ZenDesk and JIRA..

2/2012 - 1/2013 Business Analyst (CRM department), SENSA / Intelligent Beauty, Manhattan Beach, CA

SQL-based Projection of Long Term Value of on-line offers in Excel; Serviced SQL-related tickets; Ad-hoc queries of multi-terabyte sales/CMS database (MSSQL); Initiated substantial innovations and improvements: automation of lengthy LTV processes with MSSQL stored procedures, centralized management of Survey Monkey data, Geographical analysis of sales and demographics with census data (MSSQL, Access and Google Maps API3), data warehousing in MSSQL of sales and offer dimensions, email list management.

2010 - 2011 Short/Mid Term Contract Work via Agencies

10/2011 - 12/2011: Developer/Data Analyst, Musician’s Union Local 47, Hollywood, CA

Created original Archive management system (MS Access) for organization’s extensive historical holdings, greatly improving over previous system; Authored detailed documentation of complex in-house accounting and member management system (MS Access, MSSQL, DTS, command-line, FTP); Help with TSQL debugging of business-critical billing procedure and other issues.

03/2011 - 07/201: Data Analyst/Programmer, Hilton Supply Management, Beverly Hill, CA

Created highly-flexible SSRS reports and stored procedures for Program Compliance data; complex T-SQL database documenter application (dbDoc); very detailed documentation on two complex n-tiered C#.NET applications; authored XML/T-SQL queries, modified MS Access rebate application; various changes to other MSSQL stored procedures; other dynamic SSRS reports; C#.NET modifications to WinForms app.

05/2010 - 2/2011: Data Analyst, Campaigners (ASM), El Segundo, CA

Developed reporting application (MS Access/VBA/Excel) to automate output of complex sales reports that increased flexibility, accuracy and efficiency 400-500%; Consolidated and centralized data and data flow; Ad hoc reporting (SQL Server/T-SQL); support of staff in other data tasks.

02/2010 - 4/2010: Data Analyst/Metrics, Yahoo, Inc. Los Angeles, CA

Projects employing, Crystal Reports and SAP Business Objects, Oracle databases and ODBC on Seibel help desk ticketing database. Created VBA “escalations”, various table analysis tools reports.

2008 - 2010 Independent Developer

Clients: CCEO (corporate website, custom CMS, SEO, attendance and competency ratings systems), SBYRC (Drupal development, copy editing), Kavanaugh Construction (web graphics, HTML), ShipMate-consultant (ASP classic, trainee tracking, certification tracking, safety auditing protocol, MS Access/VB development

2002-2008 Programmer/Web Developer, ShipMate Inc., Torrance, CA.

Web projects: “Hdox” website used by clients for accessing and managing safety documents (ASP Classic); Webstore -ecommerce sales of safety equipment (ASP, Americart, Authorize.net); SCDS – client datasheets online (ASP); ShipMate Training animated training and test/



Contact this candidate