GENERAL APPLICATION/BUSINESS EXPERIENCE

Manufacturing, Distribution, Inventory, A/R, A/P, G/L, Job Costing, Purchasing, Retail, Direct Mail, Marketing/Sales, CRM, Healthcare, Property/Casualty/Life Insurance, Infusion (Pharmacy), Change Management, Call Center/Dialer Integration, Academia (Financials, Enrollment/Student Tracking/Tuition, BI, etc.), Banking, Data Warehouse/Analytics, Healthcare.

SOFTWARE / ARCHITECTURE / OS / LANGUAGE EXPERIENCE

SQL Server 2000-2019/AZURE, ORACLE, DB2, MS BI stack, SQL AGENT, MS Office, VBA, VB 6.0, ADO/DAO, OLE, VS, MS WINDOWS (desktop, server), SAP Data Services/HANA, FTP, HTML, CRYSTAL, RPG-II through RPG-ILE, ASP.NET / C#.NET, AGILE/SCRUM/DevOps, SAS, AQT, Snowflake, PowerShell, Power BI, AI Fundamentals.

EMPLOYMENT/ACTIVITY EXPERIENCE

2023/03 – Taking time off to decompress, do new Tech training and upgrade skill set,

Present seeking appropriate long-term remote/hybrid opportunities.

Studied/Trained for AZURE AZ-900 Certification Exam, cleared on 2023-06!

Completed 10+ IBM course on AI Fundamentals on 2024-01.

Currently studying/training for AZURE AZ-104 Certification Exam…

2022/11 – University of South Florida (USF) / Application III Developer & DBA (fulltime)

2023/03 Develop and maintain extracts for Marketing / Alumni Association Donations, query tuning/performance, refactor SQL code, general DBA-related tasks including indexes, backups-restores, collaborate with front-end developers, mentoring junior SQL developers, etc., using Microsoft BI Tech; also demonstrated Power BI strategic potential for dashboards, provided working PBI templates, proved MS RBAC security model satisfied business needs.

2022/07 – Bridge Tech Talent for Blount Fine Foods. / Sr. Data Engineer (contract)

2022/09 Develop and maintain Data Marts for manufacturer using Microsoft BI stack data conversion.

2021/11 – AMITECH Solutions, Inc. for ABCBS / Sr. Data Engineer (contract)

2022/06 Contract with AR BCBS to assist with EBI project and legacy DWH upgrade – provide solutions, suggestions for upgrade and tech training, mentoring or junior consultants; using DB2/SQL, AQT, SAS, developed Metadata Repository for data, business logic, cross-referenced to SAS code, also using Power BI.

2021/07 – APEX Systems for WPS Health Services / Sr. ETL Developer (contract)

2021/10 ETL Development, maintenance, troubleshooting, peer review, etc., using the MS BI stack with particular emphasis on SSIS and T-SQL.

2021/01 – Trellance / Database Administrator (promotion)

2021/06 Support of 12 Development and QA SQL Servers; user access permissions; implementation of File Groups for load balancing of clustered and non-clustered indexes for performance enhancements and disk space efficiency via DATA PAGE Compression; client-facing consultation on provisioning/setup of SQL Server databases; help developers with query performance tuning; complex SQL Agent Jobs monitoring and reengineering; work with Implementations and Product Support teams to troubleshoot server issues; assist Cloud Development team with understanding metadata and logical structures to migrate on-prem or ‘lift-and-shift’ SQL instances into native AZURE SQL databases; developed T-SQL scripts for monitoring index health/statistics; wrote custom SQL scripts to validate index fragmentation, page splits, etc.

2019/07 – Trellance / Lead ETL Developer, Assistant DBA

2020/12 New development and maintenance of data analytics solution for credit unions, utilizing T-SQL (2012, 2014, 2016, AZURE) and SSIS, capturing performance statistics and making recommendations to improve query performance, process documentation, interviewing / onboarding / mentoring, miscellaneous DBA tasks, help Data Analysts with impact analysis, mentoring, migration from old 2012 AZURE server to newer cloud-based servers for development and QA instances and rollout support for new local development environments.

2014/05 – University of South Florida/ IT BI & Analytics, Senior Database & ETL Developer, DBA

2019/07 Design / develop tables, indexes, MS SQL T-SQL Procedures, UDF’s, SSIS Packages,

SSRS reports, modified/loaded/reprocessed SSAS CUBES; access/process ORACLE data; SAP BO technologies, e.g., WEBI, Data Services (ETL) and HANA (memory resident database architecture).

From a business standpoint, added substantive value:

Developed standardized forms and procedures compliant with best practices

Developed system-level and user documentation, creating knowledgebase in JIRA/CONFLUENCE

Lead DBA / developer on migration from SQL SERVER 2008 R2 to 2016 virtual database servers – coordinated workflow, wrote documentation, migrated data & code, assist other developers and Support team to setup/configure services (SSIS, SQL AGENT, etc.), configured SSAS servers for HTTPS access

DBA for SSAS servers – maintenance, integrated SQL Agent Jobs to REPROCESS CUBES after nightly rebuilds of DIM & FACT tables, ongoing group/user access to MOLAP structures

DBA / liaison between BIA team, management, other departments users and IT Security teams

Lead developer on numerous and complex ETL’s/reporting initiatives for various colleges and departments - Controller & Budget/Planning offices, collecting/merging/transforming Financials and Student Enrollment data from various data sources (ORACLE, MS SQL, EXCEL, HANA) for medical and main campus college reporting, convert OLTP data to SSAS CUBES

For Controllers Office, used MS BI stack to automate tuition reporting, eliminated approximately 40 hours of clerical work (monthly) to manually compile reports.

2011/07 - University of South Florida/Media Innovation Team, SQL Developer/Business Intelligence (BI) Specialist

2014/05 Designed and developed table and index structures, SQL Server T-SQL procedures, UDF’s, SSIS Packages, MS EXCEL ACCESS, SSRS reports, to facilitate and track data cleansing / transfer between FL school districts and Positive Behavioral Support (PBS) and Response to Intervention Behaviors (RtIB) systems. Functioned as point person for data transfer functions for RtIB, helped to develop / document rules and procedures to facilitate data quality control, error checking/resolution, accurate communications between USF technical staff, RtIB staff, and school district staff; designed/developed online roster upload/download system and administrative reports ETL using SSIS, T-SQL stored procedures, SQL Server Agent; actively worked with USF/FMHI (Florida Mental Health Institute) on coding/testing/implementation of backend RtIB Tier-2 & 3 core data layers.

2010/11 - Self-employed IT Consultant

2011/06 Used T-SQL, VBA, C#, ASP, MS OFFICE, SSIS, and SSRS providing consulting services to several clients.

2008/02 - AGR Group, Inc. (dba “Utilities Marketing Group”) Database Programmer / IT Director

2010/11 Utilized skills in system design, ACCESS/VBA and SQL SERVER 2005/2008 to aid call center with transitioning from paper-based ordering system to paperless model, saving tens-of-thousands of dollars monthly in productivity and costs; coordinated efforts with California office for data exchange to procure multi-million-dollar contract; developed http post data-exchange with third-party verifier saving time and money during sales verification process. Tech/project lead on pilot program to initiate new line-of-business in third party verification (TPV) resulting in new subsidiary “The Sales Verification Co”. Responsibilities included: BSA; report/app prototyping; SQL Server 2008 set-up/configuration/admin, managed/supported 2-node SQL Cluster, programming; developed/maintained solutions using T-SQL (views, SPROCS, UDF’s, dB mail, SQL Agent), VBA, ASP/VBS, HTML, ADO, FTP, SSIS, SSRS; project management/support; technical interviews; project estimates for clients/sales programs; hardware/software purchase recommendations; reported directly to owners/executives.

2007/06 - Worldwide Entertainment Ventures, Inc/Wow-Flix, Partner and Consultant

2008/02 Visualizing, building, implementing, and operating an Internet-based entertainment media business. I was lead point person to develop/establish: the corporation; vendor/ partner relationships; LAN/wireless networks; new database applications using SQL 2005, ACCESS/VBA 2003, FTP, and limited classic ASP; integration of internal systems with Channel Advisor Merchant, eBay, Ship Works, vendor data (FTP, data import/cleansing via DTS); email blasts/marketing; tax compliance/accounting; etc. Negotiated contracts, managed daily operational tasks.

2006/01 - IZONE.COM/MEGABUYS, IT Lead

2007/05 Gathering, analyzing, and documenting business/technical requirements from management and vendors; establishing timelines with estimates/costs; weekly status reports.

Projects: Development of new SQL Server 2000 databases with ACCESS VBA 2003 application front ends; corporate reporting; vendor ordering, inventory control; process reengineering of back-order process and data cleanup, automated FTP/data imports/cleansing/back-ups using T-SQL and SQL Agent. Reengineered vendor ordering/inventory-control processes and system, saving 16+ person-hours per day (via process improvement, elimination of redundant data entry, etc.); eliminated many EXCEL spreadsheets used to contain inventory/order data, placed into SQL Server tables using ACCESS front-ends; integrated custom solutions with Channel Advisor and 3rd-party software (ACCPAC, HarveySoft). These improvements greatly enhanced sales capacity and ordering.

2002/08 - Response Mail Express, Software Project Manager/DBA

2005/10 Gathering, analyzing, and documenting business and technical requirements; developing project plans; developing diagrams for developers; establishing project timelines with estimates and costs; preparing weekly status reports for senior management; writing user documentation; user training; designing high-level project presentations and presenting to senior management. Maintenance, support and new development for the Business Management System (BMS), ACCESS enterprise application using SQL Server backend data store; designed/implemented maintenance plans to ensure data integrity and regularly scheduled back-ups of data and transaction logs.

The various process/software improvements I implemented streamlined operations, eliminated redundancies, increased productivity, and saved thousands of person-hours / dollars per month, increasing sales opportunities.

1988/09 – Work history began in this time frame with business experience in Manufacturing, Retail,

2002/07 Insurance/Finance, and Healthcare, on IBM midrange architecture (S/36, AS/400/iSeries) using appropriate Development Tech– more detail available upon request.

FORMAL EDUCATION / TRAINING (summary)

IBM – AI Fundamentals via IBM Skills

AZURE – AZ-104 AZURE Administrator Course- UDEMY and Microsoft Learn

AZURE – Two AZ-900 Fundamentals Exam Prep Courses with practice exams – UDEMY and Microsoft Learn

MS POWER BI – PBI Desktop for Business Intelligence - UDEMY

MS POWER BI – PBI DAX Masterclass – Measures and Calculated Columns - UDEMY

SAS – Beginner to Advanced, UDEMY

SAS – Advanced Cert Course SQL Macros Functions Performance – UDEMY

Power Shell – Basics, UDEMY Power BI Desktop for BI

Snowflake – Data Warehouse and Cloud Analytics Intro – UDEMY

Snowflake – [A-Z] Zero to Hero Master Class – UDEMY

Snowflake – Administering Snowflake – Virtual Online Class by Snowflake Training

AGILE/SCRUM/DevOps – In-house and online training solutions, and hands-on experience

SAP Business Objects (SAP BO) WEBI, Data Services, HANA (courses HA100, HA300)

AppDEV – Interactive DVD/web-based training in various .NET-related technologies

Tech Sherpas - 2073A - Programming MS SQL Server 2000 Database; 2072A - Administering A MS SQL Server 2000 Database; 2609ACP - Introduction to C# Programming with MS .NET; 2071B - Query Microsoft SQL Server 2000 with Transact SQL; 2500AC - Intro XML & Microsoft .NET Platform; 2310B - Developing Web Apps using Visual Studio .NET

New Horizons – CRYSTAL Reports 9.0 (Levels 1 & 2)

Ray Bello, Inc. - Project Management – A Total Perspective

Trans World Diversified Training Services - ACCESS 2000 Development (Levels 1 & 2); VB 6.0

Berks Tech Institute (formerly Lehigh Data Processing Institute) - 500 Hour Accredited IBM Midrange Programming

Salisbury University, Salisbury, Maryland - Liberal Arts, Music Education

= Indicates recent tech training within the last 6 months.

Contact this candidate