SUMMARY:

• I have years of experience in the IT industry, first as a developer and then as a DB Analyst/Developer, Project Manager and finally BI/SQL Architect.
• I have successfully shepherded businesses through upgrading and integrating disparate technologies in various business units or integration due to acquisitions.
• I have also authored and managed the development of applications which allowed for more understanding of the client’s data and allowing for significant cost - savings.
• I have been an integral member in the successful implementation of SAP, conversions between MS SQL and Oracle and developing BI tools for ease of data access while maintaining the proprietary nature of the client’s data.
• While being technology-agnostic, I have experience re-architecting systems to give the client the most “bang for the buck” from their data and technologies.

TECHNICAL SKILLS:

MS: SQL Server development 6.5, 7.0, 2000, 2005, 2008R2, 2012, 2014; MS BI Stack (SSIS/SSRS/SSAS)

ETL tools: Alteryx, Pentaho,Tableau, Splunk, Crystal Reports,Oracle 10g, 11g, 11i, R12, MySQL 5.6, MariaDB, INNODB

Various development tools: TOAD, Eclipse, Visual Studio, etc.

Strong SQL: T-SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential

Senior BI Developer/Architect

• Clients include Confidential, Confidential, the Atlanta Housing Authority, Confidential, and Confidential . Projects ranged the gamut from simple data presentations to data quality initiatives to creating ad-hoc query tools for website visitors using SSAS/SSRS.
• Database, Data warehouse and datamart design and implementation
• ETL/ELT development using T-SQL, MySQL, SSIS, Alteryx and Pentaho.
• Developed reports and dashboards for various clients using SSRS, Tableau and Splunk.
• UI/UX projects utilizing ColdFusion/JavaScript/JQuery/AJAX or ASP/ASP.NET.

Confidential, Seattle, WA

Senior BI Developer

• Created and updated various ETL processes against a MySQL 5.6 back-end to either MySQL or Google’s BigQuery/Analytics; developed customized logging and checkpoints at appropriate stages. at each stage.
• Created, deployed and optimized multi-stage ETL processes in Alteryx and Pentaho.
• Performed multiple root-cause analysis tasks between various database sources to correct for shifts of perspective and basic data issues.
• Implemented changes to data base objects (tables, stored procedures, etc.) as necessary.
• Created visualizations utilizing parameters and custom calculations in Splunk and Tableau which allowed management to see technology utilization, customer usage and life-time value trends, aiding in decisions on company resource allocation.
• Set up and configured Tableau Online server; administered user access; published report/dashboard packages.

Confidential, Federal Way, WA

Senior SQL/BI Developer

• Re-architected manual T-SQL ETL processes as SSIS/SQL Agent jobs implementing checkpoints allowing for automatic recovery; implemented logging standards and reporting procedures.
• Implemented standards of coding, logging and documentation previously unknown to the development group, including data transformations, which allowed for traceability and eased interaction with PMs and various stakeholders.
• Developed SSRS and Tableau reports and dashboards to show distributions of enrollments across states/counties to various insurance providers, trends, market saturations, etc.
• Mentored junior team members and helped long-term employees refresh their perspectives on enjoying coding and see that as part of a larger picture rather than as a one-time quick-fix.

Confidential, Seattle, WA

Data Integration Engineer, BA and SQL/BI Developer

• Worked pre- and post-sales with various clients implementing complex data relationships.
• Designed and implemented large data cubes consolidating disparate client data for marketing analysis, predictions and campaigns.
• Designed and implemented many EDQ monitors and reports to ensure long-term accuracy of client data; resolved data integrity issues in various stages of the ETL processes.
• Negotiated co-development and partnership agreements with international travel software vendors.

Confidential, Federal Way, WA

Business Analyst / Lead BI Developer

• Developed requirements and technical documentation for Oracle customizations using AIM methodology;
• Managed internal and off-shore resources.
• Authored, trouble-shot and optimized PL/SQL packages, procedures and ETL processes.
• Aided data architects troubleshooting various T-SQL / SSIS issues.
• Developed parameterized SSRS and Tableau marketing reports and trend analyses of giving/donation trends.
• Led team members (internal & off-shore) in automating National Change of Address services with third-party vendors, automated data extractions and upserts.
• Defined DQM strategies and business architecture/processes.
• Implemented Oracle Enterprise Data Quality tool use and ongoing data cleansing and enriching. Created 3 million enriched records for marketing purposes from over 10 million records that were previously considered unusable by WorldVision.

Confidential, Woodinville, WA

Team Lead/Analyst

• Led 3 team members in developing a credit card processing Java servlet to allow for real-time credit authorizations for POS processing; coordinated efforts with credit card processing vendor’s staff for implementation; implemented integration with Oracle’s sales modules to eliminate redundant efforts and allow for more accurate account reporting.
• Led team in Agile application development using Workflow Client and the XML Gateway to export/import cXML data from warehouse pick lists to the third party Clippership weigh station to create shipping manifests. This allowed for more accurate billings with an overall uplift of 10% in revenue from shipping.

Confidential, Atlanta, GA

Senior BI Developer - Team Lead

• Led team of 5 to rework a number of internal web applications using a combination of ColdFusion, JavaScript and AJAX using Agile/Scrum methodologies, often as the “Scrum Master” as well as team leader.
• Documented and refined business processes across multiple business groups to create consensus on the current state and the common goals.
• Rebuilt data access architecture to take advantage of processing and performance advantages in MSSQL 2005. Database development duties included design and architecture; creation and tuning of T-SQL stored procedures and functions from user specifications, and created, modified and improved a number of DTS/ETL/SSIS packages that extracted and transformed data from Access, Excel and a Siebel data warehouse.
• Created various data cubes for reports and reporting dashboard utilized across business groups.

Confidential, Duluth, GA

Programmer/Analyst & DBA

• Re-architected a resource management application to Visual Basic 6.0/MS SQL Server 2000, increasing both performance and planning accuracy for the allocation of personnel and resources. Reporting for the application is done with Crystal Reports 9.
• This application is used across many business units and has become invaluable in the day-to-day business of FSG.
• Was part of the team to create architecture for the application in .NET and initial prototyping.
• Developed reporting dashboard using ColdFusion and JavaScript.