SUMMARY:

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 (TSQL), MySQL, SQL Server 2008-2013, PL-SQL (basics), advanced stored procedures, user-defined functions in MSSQL and MySQL, XML queries, optimization. 10 + years with MS Access development, complex interfaces and ODBC/MSSQL- MS Access integration (samples on request)

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

Web and programming: Front end web HTML, CSS, JavaScript, HTML Canvas, JQuery, AJAX, other JS libraries, XML | Server side C#.NET, VB.NET, ASP Classic, Php (basics), ActionScript 3, MXML, PowerScript (basics), ActivePDF | Desktop C#.NET WinForms, MS Access, VB Script | CMS WordPress, Drupal, Intranet Dashboard | API’S Google Maps API, Facebook (some), GBIF

Tools: Windows 10, MS Office, Visual Studio, Acrobat SDK, Firebug, Dreamweaver | Ticketing ZenDesk, FogBugz, JIRA

Media and other areas: Photoshop, Adobe Flash (timeline animation), ActionScript Flash animation, Image Ready, Image batch processing (Photoshop Actions), HTML Canvas/JS, Vector graphics, image optimization, editing, compositing, Goldwave (sound), MovieMaker, in-depth documentation of Information Systems

Original Applications (ask me): Action Scripter (ShipMate), SiteBlocks, InterReader, Color Muddles

PROFESSIONAL EXPERIENCE:

Senior Programmer

Confidential, Culver City, CA

Responsibilities:

• Authored complex MSSQL procedure to complete email extraction steps, other reporting SQL procs, 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.

Analyst / Developer

Confidential

SQL Developer

Confidential

Business Analyst

Confidential, Hollywood

Developer/Analyst

Confidential, Santa Monica

Data Engineer

Confidential, El Segundo, CA

Responsibilities:

• 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..

Business Analyst

Confidential, Manhattan Beach, CA

Responsibilities:

• 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.
• Short/Mid Term Contract Work via Agencies

Developer/Data Analyst

Confidential, Hollywood, CA

Responsibilities:

• 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.

Data Analyst/Programmer

Confidential, Beverly Hill, CA

Responsibilities:

• 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.

Data Analyst

Confidential, El Segundo, CA

Responsibilities:

• 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.

Data Analyst/Metrics

Confidential, Los Angeles, CA

Responsibilities:

• 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.