SUMMARY

• Senior Data Architect/Engineer, Database Analyst/Developer, DBA, and Report/Dashboard Developer with 20+ years of database experience both conceptual and physical modeling, Enterprise solution development and implementation, SQL tuning of complex queries, stored procedure, functions, and triggers. Bi Dashboard design, development, and deployment.
• Software configuration and implementation has included systems for CRM, Personal Attribution Tracking, BI Data Cube Analysis Systems, Inventory Tracking and Auditing, Contract personal scheduling, payment and invoicing, and general accounting.
• Extensive Report and BI dashboard development background includes SSRS and Crystal Reports v 8 - 10 and dynamically refreshable Excel documents and BI Dashboard with Power BI and Sisense, moderate exposure to Tableau and Microstrategy.
• Complex query development to include extensive data manipulation, parsing and data scrubbing.
• Complex ETL development and migration utilizing SSIS and Powershell.

TECHNICAL SKILLS

• MS Office Professional Suite 2016, MS Visio 2016, MS Project
• Adobe: Master Creative Suite
• MS SQL Server 7 - 16(cdc)
• Sybase, Informix, Progress, Hyperion, My SQL, Oracle
• Power BI Reporting Server
• SSMS, SSIS(SSDT-BI), SSRS,
• SSAS (some exp)
• Sybase Power Data Architect
• Filezilla and Putty FTP Tools
• Powerbuilder(6-10)
• Sisense, Tableau, Microstratigies
• Crystal Report 8 - 10
• Microsoft TFS 2014
• Toad for SQL Server, ApexSQL Refractor
• SQL - (MS SQL Server, Sybase, Informix, Progress, My SQL), XML, VB (for use in SSIS and Excel solutions), Powershell, DAX (some exposure)
• Windows 2000 - Windows 10, Mac OS X, (some) Linux

PROFESSIONAL EXPERIENCE

Confidential

Sr. Data Engineer

Responsibilities:

• Developed parameter driven Gen2 reporting system by building hybrid scripts that based on parameters will modify the internal business logic to satisfy different reporting needs which resulted in the consolidation of reporting scripts lessoning the maintenance and cataloging work load.
• Took the parameter driven Gen2 reporting process and built and necessary ETL to support replacing existing hard reports with dynamic Power Bi dashboards.
• Took the parameter driven Gen2 reporting process and continued the development to enable:
• Process and info structure to stored and cataloged results sets.
• Result based data sets ready for use with numerous BI dashboard tools that provided fast load times of dashboards and reports.
• SSRS report available off same result set also allowing to generation of .csv files for external client import for specific reports.
• Reporting security established based on aligning reporting folders with Active Directory Groups.
• Setup reporting server to support both reports and dashboards distribution with service accounts to satisfy Sorbain Oxley security requirements.

Confidential

Sr. Data Architect/DBA/SQL Developer

Responsibilities:

• Lead Sr. Data Engineer for Trizetto Qnxt data migration and implementation.
• Lead Sr. Data Engineer for the redesign of all ETL processes and the exchange of data between State and Federal governmental agencies and local healthcare providers.
• Developed SSIS packages to support monthly Governmental reporting requirements and third party data submissions.
• Sr. SQL Analyst/Developer
• Developed complex SQL queries increasing efficiencies on existing batch processing.
• Develop SQL processes to pull necessary data metrics to measure departmental effectiveness and overall company performance.
• Tuned complex SQL queries developed by other staff programmers often decreasing process from hours to minutes.
• Developed and enhanced existing ETL processes to reflect business rule changes and governmental reporting requirements.
• Lead designer on Metric Informational Dashboard providing the daily statistics of claim inventories and metrics of claims processed.
• Developed processes to report companies existing provider network to state and governmental agencies in an effort to expand company’s approved service area.
• Lead analyst for the implementation of Milliman Medinsight - third party BI-cube reporting tool utilization. Worked with outside vendor to define production, UAT, and development environments and configuration.
• DBA
• Developed Maintenance plans for all development and production database.
• Developed specifications for new server that was then implemented by the networking team
• Monitored all development and production servers to maintain efficient processing times, recognize and remove system blocks, and monitor memory and disk space.
• Work with networking team to add additional resources as database growth dictated.

Confidential

Sr. SQL Server DBA/SQL Developer

Responsibilities:

• Senior Database Administrator providing 24/7/365 high availability database support for critical US and international systems.
• Maintained the daily operation of 8 SQL Server databases systems located in both the US and United Kingdom servicing 9 different countries.
• Migrated all databases from SQL Server 2000 to SQL Server 2005. Prepped and migrated a test version of the production systems to SQL Server 2008 for proof of concept and system testing resulting in proof of 100% functionality.
• Designed and maintain both US and UK secondary databases and disaster recovery databases generated using both log shipping and publisher/subscriber replication.
• High availability production databases existed in both VM Ware and Clustered environments.
• Extensive work in SSIS development, rewriting existing ETL DTS jobs to run under SSIS.
• Worked in Crystal Report v.9, 10 and SSRS consisted of testing specific capabilities concerning the web deployment of reports containing graphics and the ease of development. Reporting was accomplished by the combination of stored procedures feeding data to Crystal Reports where the primary job of crystal to do formatting for client server and web viewing and printing.
• Provided Ad-hoc T-SQL development to improve enterprise processes, decision support, and business intelligence.
• Designed and maintained T-SQL, SSIS, SSRS version libraries.
• Maintained striped down versions of the production database to satisfy contractual agreements for specific clients meeting their disaster recovery requirements.
• Maintain documentation on all operational, maintenance, and disaster recovery procedures utilizing corporate standard format.

Confidential

DBA/SQL Programming

Responsibilities:

• Created numerous simple to complex queries involving self joins, correlated sub-queries and XML techniques for diverse business requirements. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.
• As part of a team, analyzed the business requirements and systematically designed a bank database that stores Customers’ and their Account information for a multi-tiered Bank Teller Application. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers. As part of a team, created various reports according to the business requirements. Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• As part of a team, developed a backup and recovery plan based on the data availability requirements of the business and on the potential impact of data loss on the business after considering and analyzing the different backup and recovery strategies. As part of a team, designed database maintenance plans to set up core maintenance tasks to make sure that the database performs well, is regularly backed up in case of system failure and was checked for inconsistencies.
• Employed the Database Engine Tuning Advisor to analyze the performance effects of workloads against the Recruiter database and implemented its recommendations wherever appropriate.
• Used the SQL Server Profiler tool to monitor the performance of SQL Server - particularly to analyze the performance of the stored procedures. As part of a team, analyzed the different high availability solutions and implemented database mirroring and replication for the Recruiter database
• As part of a team, established security policy using windows domain accounts and implemented a security strategy to protect against threats and attacks. Familiar with employing Service Brokers, enabling HTTP support and establishing Notification Services.

Confidential

DBA/Programmer Analyst/Consultant

Responsibilities:

• Analyzed several PowerBuilder applications and assess numerous versions of source code to recreate a working executable. Migrated source code from PowerBuilder 6.5 to 10.0, debugged and tested.
• Developed estimates for application enhancements and fixes per list of required needs and implemented on a per clients choices.
• Provided SQL Server 2000 DBA support for database modifications, and DTS process refinement.
• Provided DBA day to day support for SQL Server 2000, in the absence of an in-house DBA.
• Trained in-house developer in the basic navigation and use of the PowerBuilder development tool and application maintenance.
• Document all codes changes and enhancements.
• Develop conversion feasibility paper documenting the current state of the end user applications and the pros and cons for upgrading to a .Net environment.

Confidential

Consultant

Responsibilities:

• Provided remote support to several small business owners/clients. Developed shipment tracking system to interface with existing order tracking system on SQL 2000.
• Performed data transformation cleansing, and migration from commercial databases to in-house database for the support of CRM and direct mail marketing systems. Provided day-to-day computer operational support when problems were beyond the abilities of the business owner.
• Provided necessary documentation of procedures and changes.

Sr. Database Developer/Consultant

Confidential

Responsibilities:

• Worked on the migration of an end-user application from PowerBuilder 6.5 to PowerBuilder 10, system back-ended by Sybase database.
• Member of the test team responsible for testing preliminary upgraded versions of the end-user application prior to full migration and implementation.
• Continued maintenance and enhancement to the migrated application version, stored procedures and triggers.
• Changes and enhancements were made in the actual code modules conforming to and established format.

Confidential

Senior Database Developer

Responsibilities:

• Enhanced third-party system by providing database interfaces to expand data filtering for direct mail processes. Databases: SQL Server 2000 and Sybase. Provided necessary documentation of procedures and changes.
• Extended reporting capabilities by providing additional reports on SQL Server and Sybase database.
• Develop data extraction utilities for importing data from Patient Tracking System into CRM System development to support direct mail marketing.
• Provided necessary documentation of procedures and changes.