SUMMARY:

• Over Fifteen years of total IT Experience wherein ten years of extensive ETL and database development, Data warehousing and SQL
• Expericince with a strong B.I. focus within the insurance, manufacturing, healthcare and foodservice distribution industries.

PROFESSIONAL EXPERIENCE:

Confidentialm, San Francisco, CA

Senior Database Developer/ DWH Developer

Responsibilities:

• Provide instruction and documentation for SSIS 2014 upgrade to other developers including deployment method and variable usage as well as other configuration issues. Analyze SQL code base for breaking changes for 2014 upgrade and develop plan for necessary changes
• Analyze business requirements and correlate with research performed on existing code to re - engineer into SSIS ETL and technical specs, recommend data modeling changes to accommodate new data source integration
• Optimize performance including: index and statistic maintenance, performance tuning, stored procedure optimization
• Production support, deliverables troubleshooting with automated FTP processes
• Design complex ETL solutions for disparate data sources’ homogenization, cleansing, and presentation for new application
• Train junior DBA: SSIS, ETL best practices, documentation, and master data concepts
• SQL 2008 and 2014, Visual Studio 2013, Agile

Confidential, San Francisco, CA

Senior B.I. Engineer, Data Scientist

Responsibilities:

• Translate business requirements into ETL and automation technical specs, recommend data modeling changes to accommodate new data source integration
• Optimize servers including: index and statistic maintenance, disk usage analysis, performance tuning, stored procedure optimization, data archival and DR
• Production support on 24/7 basis: troubleshooting, performance monitoring, vendor coordination
• Design complex ETL solutions for disparate data sources’ homogenization, cleansing, and presentation including SSAS/OLAP solutions, complex SSRS report deliverables and PowerPivot. Created robust auditing system for ETL execution and reconciliation
• Train junior ETL developer: SSIS, ETL best practices, documentation, star-schema model, conformed dimensions, data profiling and analysis, transaction and master data concepts
• SQL 2012, TFS, Agile

Confidential, Raleigh, NC

Data Warehouse Developer/DBA

Responsibilities:

• Design and build automated ETL solution for very labor intensive annual Agency Contingency Bonus program, including data collection, reporting needs, and minimized manual business involvement.
• Implemented salesforce.com for Sales/Agency Relations Dept. within very short timeframe. Built 20+ SSIS packages within an ETL solution to provide 2-way data synch between source systems, Data Warehouse, and salesforce.com database (API).
• Analyze and document current Reinsurance processing throughout company, coordinate all cross-departmental requirements and eliminate extremely labor intensive Access and Excel documents to remove manual business intervention. Design automated solution to provide all necessary treaty definitions, data feeds, invoicing and GL reconciliations and reporting for approximately 66 reinsurers.
• Train junior ETL developers in data analysis, project management, documentation, SSIS and sound database design principles.

Confidential, Rocky Mount, NC

Data Warehouse Architect

Responsibilities:

• Sybase PowerDesigner: Perform all Data Modeling, data dictionary documentation and object generation
• SSMS: Data Mining and extensive TSQL query development including stored procedures, views, triggers and adhoc queries
• SSIS: Build conformed dimensions and fact tables from disparate data sources (AS400, GL,SQL UPS GPS system etc) adhering to Kimball methodology star schema design
• Robust data auditing and SSIS package tracking system built for quality assurance and to aid in troubleshooting
• SSRS: Develop and implement on-demand and scheduled reports
• SSAS: Cube design and implementation for a planned phased roll out of SSAS on a wider basis, MDX for calculated measure development, hierarchy and aggregation tuning
• DBA: index optimization, replication, partitioning and performance tuning

Confidential, Bradenton,FL

ETL Developer

Responsibilities:

• Design and build Kimball-method Data Warehouse (Staging, MDS/ODS and EDW) using SSIS as ETL tool and PowerDesigner to design and generate database objects. Coordinate production issues with DBA across Development, QA and Production environments. Design specifications with Master Data Steward, Data Architect, DBA and management.
• Rolled out SSRS 2005 implementation, trained report writers on development of RDL files and set in place development standards. Coordinated report requirements, testing and data verification with users and executive management. Developed reporting and data mining tools for newly implemented CRM system, assist Project Manager with data quality issues

Confidential, Sarasota, FL

Database Analyst

Responsibilities:

• Develop and maintain custom reports using SSRS. Develop Claims Adjuster performance reporting for senior finance executives
• Create complex stored procedures for development of reports, data conversions and SSIS packages.
• Developed new modules using VB.NET for an in-house data maintenance utility.

Confidential, Sarasota, FL

Software Engineer

Responsibilities:

• Develop health care electronic data interchange (EDI) applications based on federal, state and county agency standards across several states.
• Extensive use of SQL stored procedures, triggers and views.
• Engine Development was accomplished using VB.NET, and HTML.
• In-depth analysis of customer business practice and workflow to develop specifications for application needs. Work very closely with customers to define needs, resolve data and process gaps and successfully implement applications. Prepare detailed documentation for customer in an easy-to-use format.
• Leveraged the benefits of VB.NET and SQL Server in order to produce easily modified applications used to interface a rapidly evolving enterprise data system.

Confidential, Sarasota, FL

Software Engineer

Responsibilities:

• Developed Workers Compensation Policy Management enterprise data system in VB6.
• Designed, developed and implemented in-house application and database for management of client requests and development releases, to include conversion and migration of data from MS Access to Oracle database.