TECHNICAL SKILLS:

Languages/Technologies: Current: MS SQL Server, T - SQL, REST APIs, WorkatoPrevious: postgreSQL, plpgsql, mySQL, PHP, COM/ActiveX/OLE, .NET (C#, VB, ASP), PL/B, C, XML(DOM, XSLT, etc.), HTML, CSS, JavaScript, AJAX, extjs, scriptaculous

Platforms: Windows (10, 7, XP, 2003, 2000, NT, 95/98), MS DOS

Tools: Current: SSMS, SSIS, Jira/Confluence, Slack, Workato, IPSwitch, Bitbucket/SourceTreePrevious: SSRS, Business Objects XI, Crystal Reports XI, Corda, Visio, Sharepoint, BaseCamp, Quickbase, dotProject, Tortoise SVN

PROFESSIONAL EXPERIENCE:

Senior Database Developer

Confidential, San Francisco, CA

Responsibilities:

• Migrated corporate customer service database from Salesforce to Zendesk
• Created migration scripts, cleansed data, & shepherded files to Zendesk for initial import
• Developed an asynchronous refresh engine, comprised of T-SQL stored procedures, jobs, & Workato Recipes for maintaining data freshness between order/billing system & Zendesk.
• Extensive Workato Recipe development, using REST APIs
• Performed all corporate Workato account administration
• Developed streamlined database automation processes, eliminating numerous manual systems
• Credit Refund Request - dynamically determined credit refunds, applied credits, and dispersed funds. Included options for manual overrides/submissions, for full flexibility.
• Order Integration - robust system that dynamically places accessory orders throughout the day. Developed for full extensibility.
• Account Adjustments - system that allows easy insertion of account adjustments into billing system
• Various smaller projects
• All processes included full reporting
• MS SQL Server database development using T-SQL, stored procedures, SSIS
• Extensive development with minimal supervision
• Supported both OLTP & OLAP systems
• Extensive ETL processing, using both SSIS & FTP/BCP methodologies
• T-SQL and code refinement for other departments
• Optimization of Marketing systems, greatly reducing processing time
• Data analysis
• Project Management
• Performed business analysis, requirement gathering, and management for personal projects, interacting with all organizational tiers

Senior Database Developer/Reporting Manager

Confidential, San Francisco, California

Responsibilities:

• Spear-headed newly formed Data QA Team
• Supervised Business Intelligence/Reporting Developer
• Designed and implemented a resource management matrix in order to remove siloed tasks, and provide full client coverage; leading to faster task resolution
• Provided mentorship/ to junior developers; increasing team productivity
• Performed code review for junior staff, ensuring data integrity and an organized code base.
• Acted as point of contact for all data quality issues
• Managed client facing ticket system.
• All administration functions
• Resource & scope management
• Point of contact for all development
• Primary developer - T-SQL, SSRS, SSIS, Business Objects, ETL
• In first year doubled the number of tickets processed, and cut in half the average days-to-completion.
• MS SQL Server database development using T-SQL, stored procedures, packages
• Extensive development with minimal supervision/ - acting as a jack-of-all-trades
• Extensive ETL processing, including ongoing refinement, depending on evolution of data streams
• Automation of all repetitive processes
• Ongoing optimization of all processes to increase speed and reduce redundancies
• Database Architecture
• Designed and implemented client facing databases, utilizing both star schemas as well as highly de-normalized schemas
• Report Development
• Extensive report/universe development in Business Objects & SSRS
• Ongoing performance monitoring of all reporting interfaces
• Directed migration from Business Objects to MS SSRS
• Project Management
• All Reporting projects and all projects coming through the task queue
• Created and maintained documentation for all processes

Developer - Contracting

Confidential, Oakland, CA

Responsibilities:

• Provided ongoing support for the ERP system developed for them when I was a full-time employee.
• Enhancements,/fixes
• System for new staff

Report Analyst/Database Developer

Confidential, San Francisco, California

Responsibilities:

• Executed full life cycle of client reporting: project management, implementation, maintenance
• Developed processes using T-SQL stored procedures & SSIS packages
• Data Extraction, Transformation & Loading
• Table denormalization for reporting purposes
• Optimized inherited T-SQL code base, reducing nightly processing time by half
• Lead all Business Objects development
• Business Analysis
• Universe & Web Intelligence report creation
• BO Administration: account maintenance, upgrades/SP installs, troubleshooting
• Transformed client reporting via monthly dashboards, dynamic email/HTML reports, Business Objects Web Intelligence, Crystal Reports & Corda
• Developed/maintained all underlying code: T-SQL stored procedures, PHP, C#, Excel/COM
• Consolidated disparate reporting databases
• Served as back-up for other development teams

Senior Analyst/Programmer

Confidential, Berkeley, California

Responsibilities:

• Drove corporate technology transformation via a combination of aggressive project management and web/database development
• Created variety of web applications using PHP, AJAX, extjs & postgresql that eradicated several paper based systems and saved substantial staffing time.
• Designed relational database architecture, replacing an antiquated flat file system
• Implemented stored procedures/functions/triggers
• Jump started Analytics team which lead to acquisition of several new clients
• Created streamlined ETL data processing system for client file analysis using variety of tools: PostgreSQL, MS Access, PHP, PL/B, etc.
• Created varied templates/methodologies for analytics reporting: Excel/COM, Crystal Reports XI, Power Point
• Researched/recommended technology options
• Performed as Report Lead, moving from tabular reports to high level data visualization tools
• Hired and directed an array of assistant report developers
• Managed entire project within time/budget
• Provided Business Analysis for all database/development projects

Project Manager/Developer - Contracting

Confidential, Oakland, CA

Responsibilities:

• Bridged technologies between two separate organizations
• Managed/performed conversion of multiple databases
• Re-mapped and re-designed a legacy dBase system to an existing relational database
• Developed & implemented suite of conversion applications
• Developed/maintained Project Plan & Conversion documentation
• Provided follow up assistance and support
• Re-designed & re-programmed all standard reporting

Business Analyst/Project Manager - Contracting

Confidential, Berkeley, California

Responsibilities:

• Created corporate strategy to free organization from obsolete systems
• Analyzed opportunities for streamlining business systems/processes
• Created executive and detail level requirements/documentation: flowcharts, use cases, requirements, etc.
• Created a menu of alternate technology solutions
• Developed automated system architecture, using a custom designed relational database
• Provided partial implementation for scenario testing: Salesforce, Quickbase, BaseCamp, dotProject, etc.
• Provided executive level strategic development scenarios
• Steered formation of new technology team
• Developed Project Plans
• Coached staff on implementation of Project Management concepts

Senior Developer/Project Manager

Confidential, Oakland, CA

Responsibilities:

• Transformed a small series of command line programs into a comprehensive suite that leveraged automation in order to drastically cut costs. Introduced/implemented modern project management philosophies.
• Development
• Designed, developed, documented, tested, deployed & maintained in-house ERP system
• Performed as DBA for custom relational database
• Created reporting suite
• Provided on-going code maintenance
• Authored numerous snippets of sample code for development community
• Mastered new technology on a per needs basis
• Management
• Managed interdepartmental & multi-organization projects: Feasibility studies, Requirements gathering, Database development, Developed/maintained Project Plans
• Acted as primary liaison between IT & Sales departments
• Managed/developed web-based application suite
• Served on an executive strategic development committee
• Mentored/managed new developers

Programmer/Analyst

Confidential, San Francisco, CA

Responsibilities:

• Redefined/implemented customer service metrics
• Provided tech support to assigned client base
• Performed fixes/enhancements
• Release testing
• Developed materials
• Performed customer
• Mastered new technology on a per needs basis