• Analyzed current data environment and began working with invested parties to create a Data Governance Policy.• Architected multiple solutions that focused on improving the data maturity model by bringing Excel spreadsheets into a data warehouse and moving the reporting process off Excel and into Tableau.• Performed in-depth analysis of the current Carinata Proof of Sustainability process including the Green House Gas models. Then modeled a new database and architected a new process away from Excel and into a OLTP database that uses SSIS to automatically import data from delimited files.• Implemented a data warehouse model that imports data into a staging area and moves through the model to a reporting area, verifying and cleansing data along with populating fact and dimension tables.• Performed a gap analysis on data modeling tools, and presented findings to the Architectural Review Board, and purchased suggested solution.• Collaborated and created a team that crosses business entities to establish better communication and to implement best practices for data across the enterprise.

• Architected Jefferson Health Plans Azure Environment utilizing Microsoft’s Azure Landing Zone Architecture as a guide.• Implemented Azure architectural design in Azure Environment, creating Managed Groups hierarchy, Subscriptions, Resource Groups, and assisting in the implementation of the platform managed group resources. • Responsible for implementing naming conventions, Tagging policies, Azure Policies, Azure Alerts, Cost Alerts, Service Health Alerts, and Azure Advisory’s.• Created and Chair of the Architectural Review Board, establishing guiding principles, developing standards documents, hosting weekly meetings, reviewing designs, and building relationships between vested parties.• Perform a GAP analysis between Azure Synapse and Snowflake, performing a GAP analysis and executing a POC that compared on-prem Microsoft SQL Server, Azure SQL Database, Azure Synapse, and Snowflake.• Responsible for the research, analysis, and architectural designs of multiple solutions for on-prem and cloud.• Hosted weekly learning sessions on Azure, helping others by sharing knowledge and building a rapport.

• Research, architected, and performed POC for a solution that utilizes Azure Data Factory pipelines to integrate the Azure App Insights data into Azure SQL Database, along with additional on-prem data. The data is then blended into Azure SQL Database for analytics and presented in a de-normalized view in Microsoft Power BI.• Architect, engineer and implemented a solution that utilizes Dell Boomi integration processes encapsulated in API’s that enable external clients to interact with internal databases, transferring call data to the Cisco IVR. Screen Pops are performed utilizing API calls to clients Sales Force API. Dell Boomi stores interactions in a SQL Server 2019 db.• Architect, engineer, and implemented solution that interacts with a vendor’s API’s that performs multiple calls to integrate data to and from the vendor. The solution utilizes Dell Boomi for integrations, SQL Server and IBM DB2 as database engines, and a custom file management system to store images associated to the accounts.• Architect and engineer multiple integrated (ETL) solutions in Dell Boomi, SQL Server (2012 – 2019), and DB2 that provide interactions between externally hosted solutions, internal cloud solutions and on-prem solutions. • Simultaneously managing up to 14 projects, architectural designs, data models, and engineering solutions that utilize a variety of technology, such as: Azure SQL Data Warehouse, Azure SQL Server, Azure Log Analytics, Azure Data Factory, Azure App Insights, Dell Boomi, SQL Server (2012 – 2019), and DB2.• Performed POC and architected solution to utilize Azure Data Factory to pull data from OData objects to be stored in Azure Data Lake as raw data, then merged with on-prem data in Azure SQL Data Warehouse, utilizing Analysis Services layer for analytics, and reported on by Power BI.

• Architect, design and implement transaction processing, data mart, and data warehouse database schemas.• Conduct design reviews with team members to ensure product quality, mentoring where applicable.• SQL Server Upgrades, including databases, SSIS, and SSRS.• Archive 60+ million accounts with 287 billion records and over 7 TB from IBM DB2 to SQL Server, creating a dynamic solution utilizing SQL Server, SSIS, C# Classes, and MVC Web Application.• Worked closely with clients, executives, and users to provide complete and accurate solutions.• Utilized advanced features of SQL Server to provide best design which includes: In-Memory Tables, Clustered Columnstore indexes, Table Partitioning, and Native Compiled Stored Procedures.• Created curriculum and taught a course on Querying SQL Server 2012 to over 30 employees of Afni.• Designed, developed and implemented a dynamic solution that empowered the customer to identify any flat file layout, map it to a SQL table, apply business rules, and import/ export the data utilizing the solution without requiring additional development. Solution utilizes SQL Serve with a Visual Studio MVC Web Application.• Engineered over 100 SSIS packages that import/ export data from multiple types of data sources, including SQL Server, CSV files, IBM i5 DB2, fix length record files and delimited flat files.• Built many web sites utilizing Visual Studio MVC, utilizing C# after engineering database in SQL Server. • Administered 100+ databases across multiple servers, multiple environments. Administered databases up to 7 TB.• Built C# class libraries to interact with Microsoft’s Dynamics CRM in the cloud, loading new leads, provide reporting and auditing data on outbound dialing business, which is controlled by SSIS packages and SQL Server jobs.• Re-engineered SSIS packages to execute small batches of data that utilized web services, enabling multiple execution of the same SSIS package in parallel increasing throughput 800%.

• Designed and developed tools in Visual Studio C# and Oracle to assist the administrators in proactively solving problems with the NuGenesis SDMS (Scientific Data Management System) application.• Validated NuGenesis SDMS applications against scientific instruments residing in laboratories.• Played a major role in performing the Periodic Review of the NuGenesis SDMS system, which includes validating user and group access, support documentation, system design and architecture, and Standard Operating Procedures.• Assisted in training users in a classroom setting on the NuGenesis SDMS application.• Completed first phase of Six Sigma business management strategy training.• Trained in many aspects of the pharmaceutical environment and FDA rules and procedures.• Validate Microsoft Patches against test lab instruments prior to implementing patches in production.

• Proven as the “Go-To-Guy” when in a crunch, and a reliable, accurate, efficient system needs developed yesterday.• Served in multiple roles, including Senior Systems Analyst, Project Manager, Programmer, and DBA on many projects and tasks over the last 4.5 years utilizing SQL Server 2000, Visual Basic 6.0, .Net, and Crystal Reports.• DBA tasks completed over the last 4.5 years: Data Modeling, Backups/ Restoration of multiple databases, replication management, SQL Job development and administration, data integrity checks, index de-fragmentation, load requirements recommendations, performance tuning, and security administration. • Sole designer, developer, and implementer of CDR processing system, which processes over 29 million records per month with a total of 69 GB of data per month utilizing 11 different carrier layouts. The system utilizes SQL Server 2000, DTS packages containing VBScript, SQL connections, text file connections, Access Database file connections, transformations, and global variables, along with over 23,000 stored procedures that process, identify, and rate telecommunications records.• Lead Software Engineer on an invoicing application developed using SQL Server 2000 and Visual Basic 6.0 that enables accountants to invoice customers and then integrate the invoices with Great Plains accounting software.• Lead Systems Analyst/ Programmer on the re-design and development of our CDR processing, which utilizes automated file transfer from multiple types of sources, such as FTP sites, emails, and servers on our LAN, and automated execution of DTS packages that process multiple files within a folder. • Served as the Project Manager for a system migration project, which included the research of clustering, replication, and linked servers to share databases. The project moved daily backend processing to a separate server utilizing replication, and was completed with zero downtime.

• Assisted in the design, development, and implementation of an N-Tier telecommunications application utilizing Visual Basic 6.0, SQL Server 7.0, dynamic DTS packages, and MTS.• Responsible for the development of an application that processes ASCII files into SQL server, and then performs comparisons, calculations, and concatenating strings on upwards of 1,000,000 records per day.• Served as Project Manager for a Document Management/Document Imaging System integrated into the Teachers Certificate Information System (TCIS) for two years at the Illinois State Board of Education.• Designed, developed, implemented and supported the Document Management system utilizing Visual Basic, Microsoft SQL Server, and Diamond Head Software custom controls for Document Imaging.• Completed an in-depth analysis identifying an agency wide Document Management/Document Imaging system that would be easily integrated into any of the agency’s applications. Design specifications included: Database Table requirements, identification of Visual Basic design techniques, Internet/Intranet requirements, Network load requirements, and custom control purchase recommendations.• Assisted in updating the TCIS system including: adding True Grids, TList Pro Controls, Stored Procedures, and SQL Server Table modification, creation, and conversion.• Designed, developed and implemented Crystal Reports for the administrators and privileged users of TCIS. All reports received data from MS-SQL Server Stored Procedures, selecting records based on the parameters of the Stored Procedures.• Initiated and implemented a 26-million page image backlog conversion including importing pages and data into the TCIS Document Management System and utilizing multiple Microsoft SQL Servers and Storage Servers. The import application utilizes Visual Basic 6.0 Object Oriented programming techniques, along with multiple Active X objects.

** Employed with Decision Consultants Inc. from February 1996 – July 1996 on a “Contract for Hire” position to JM Family Enterprises, Inc.• Responsible for the support, maintenance, and custom application development of a 1000 + user Document Management/Document Imaging system powered by Identitech’s FYI Document Management software.• Performed maintenance and support to four remote geographic locations traveling to various sites to complete mandatory maintenance and disaster recovery testing.• Identified, implemented, and tested "Disaster Recovery" plans, which could be completed within a 12-hour window; the plan included the relocation of 12 jukeboxes’ and up to 22 servers and scanning stations.• Designed, developed, implemented and supported an application that would monitor key systems, alerting technicians of any problems that may occur, notifying personnel via email and by pager of the exact system and error.• Assisted in the upgrade of the existing Document Management/Document Imaging system, requiring upgrade of vendor software, 7 Object Servers, SQL Server from version 4.21 to 6.5, and re-development of custom applications, including scanning applications, and import applications.

Hired by JM Family Enterprises• Responsible for the support, maintenance, and custom application development of a 1000 + user Document Management/Document Imaging system powered by Identitech’s FYI Document Management software.• Performed maintenance and support to four remote geographic locations traveling to various sites to complete mandatory maintenance and disaster recovery testing.

• Served as the Project Manager in a full life cycle application, which manages the operations for the Security Department.• Designed, developed, implemented and supported multiple MS-Access databases for department operations. • Converted old database systems from dBase III and dBase IV into MS-Access databases and Visual Basic applications.• Developed several technical documents, user manuals and performed training sessions for users on new systems.• Researched applications for departments, providing documentation on each product and comparisons of key features.• Extracted, verified and imported medical data from the current medical system, Meditech, into the new SMS system, utilizing Allegra tools and the Magic language.

• Installed and supported Novell Network servers and workstations, along with office applications.• Assisted in the installation of imaging workstations, object servers, and jukeboxes for an agency wide Document• Management/Document Imaging/Workflow solution utilizing I. Levy and Associates Navigator 2000 system.• Managed and maintained a custom application that maintained the full life history of low level radioactive waste, and calculated the radioactivity of each isotope. • Converted the low level radioactive waste application from a dBase IV system to a Microsoft Access system.