
Kristopher Adams
Verified Expert in Engineering
Database Programmer and Developer
Cleveland, OH, United States
Toptal member since July 3, 2024
Kristopher is an accomplished senior database programmer with two decades of specialization in database development, ETL processes, and data architecture. His proficiency extends to SQL Server, SQL Server Integration Services (SSIS), and assorted data integration technologies. Renowned for architecting and fine-tuning intricate databases for peak performance, Kristopher excels in partnering with diverse teams to deliver innovative solutions and ensure data integrity.
Portfolio
Experience
- Process Improvement - 20 years
- Data Modeling - 20 years
- Data Integration - 20 years
- Data Analysis - 20 years
- Query Optimization - 20 years
- T-SQL (Transact-SQL) - 20 years
- SQL Server Management Studio (SSMS) - 20 years
- SQL Server Integration Services (SSIS) - 18 years
Availability
Preferred Environment
SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), Visual Studio, T-SQL (Transact-SQL)
The most amazing...
...thing I've done is build data architecture, databases, and ETL for a new trivia app startup from scratch and lead SQL developers to improve data integration.
Work Experience
Senior SSIS | Database Developer | Consultant
Progressive Insurance
- Served in the telecommunications department, seamlessly bridging teams to deploy innovative solutions and enhance various data integration initiatives.
- Collaborated with multiple teams to facilitate data integration among SQL, Hadoop, PDW, and Snowflake environments using SSIS, SQL, and Python.
- Oversaw code reviews, builds, and promotions across development, QA, and production environments in the software development lifecycle (SDLC), coupled with testing and data analysis responsibilities.
Senior Database Developer | Consultant
Prospect Medical Holdings
- Created reports to detect data anomalies company-wide, enabling corrections and ensuring enhanced accuracy of medical records.
- Devised solutions to rectify data irregularities, thus improving medical record accuracy, compliance, billing, and call center operations with precise hospital data.
- Tracked project status, fixed bugs, and proposed new features using Agile.
Senior SQL Database Developer | Consultant
TrueSense Marketing
- Analyzed and documented a legacy ETL process, advising on modernizing and automating this patchworked ETL process spanning 20 years, consequent to a merger/acquisition.
- Acted as an intermediary between companies, legacy developers, new development teams, and management.
- Guided and executed a new data architecture to underpin diverse systems, encompassing data warehousing, reporting, and transformations with external entities like phone dialers and clients.
Senior SSIS Developer | Consultant
Medical Mutual of Ohio
- Employed SSIS and Microsoft Management Studio to craft a standardized template, streamlining new solutions and enhancements for existing ones and automating manual processes for team-wide use.
- Designed adaptable SSIS solutions for project and package deployment models, utilizing configurations to modify processes without code changes, enabling seamless transitions between development, test, and production environments.
- Facilitated the transformation of internal data between SQL and Db2 systems, external vendors, flat files, and Excel reports.
Senior SQL Database Developer
Speedeon Data
- Managed ETL operations using Redpoint—a tool with built-in and custom components for rapid data processing and automation from flat files and databases—to meet client data requests.
- Handled massive datasets ranging from 250 million to over 1 billion records, extracting potential customer data using data science models to identify likely new client prospects.
- Maintained data integrity via internal analysis, Coding Accuracy Support System (CASS), and National Change of Address (NCOA) verification to standardize and ensure mail deliverability and email and phone number verifications.
Senior SQL Database Developer
Talis Clinical
- Used SQL Server Management Studio (SSMS), Visual Studio, and TFS to build databases, tables, views, procedures, triggers, and indexing. Logged and overhauled code to guarantee real-time accuracy and efficiency within a live hospital data setting.
- Utilized modern SQL features, like temporal (system-versioned) tables, for a persistent audit trail while optimizing space and speed. Applied Columnstore indexes for data compression and expedited query performance where applicable.
- Crafted and deployed a SQL-based clinical data quality metrics database. Managed data to measure patient care through documentation and surveys. Transformed SQL data into JSON for middleware and reparsed JSON back into SQL for detailed analysis.
- Developed SQL procedures to reallocate patient data when misassigned, enabling the merger of disparate datasets into a singular patient record for accuracy enhancement.
Data Warehouse Architect | Consultant
International Knowledge League
- Created a fresh install of SQL Server, SSMS, and Visual Studio to initiate our development and production environments.
- Evaluated raw data. Designed and architected all facets of our staging and production databases alongside our ETL workflows using SSIS and SQL procedures crafted in SSMS, with source control managed via Visual Studio TFS.
- Managed ETL processes, including loading raw data, normalizing it into a database, and creating a repository for front-end use. This SQL data was converted to JSON and MariaDB formats.
- Headed a team of SQL developers to use the tools I developed to integrate additional data into our system and enhance the data repository. Collaborated with middleware and front-end developers to meet deadlines and maintain transparent communication.
- Handled diverse data from sources like TiVo in delimited and JSON formats, Oxford dictionaries in XML, definitions from Webster dictionary, automotive data from Kelley Blue Book (KBB), and curated Q&A sets in Excel, flat files, and JSON.
Data Integration Architect | Consultant
iVHR
- Built an ETL process using SSIS and SSMS to transfer Cleveland Clinic EPIC data from Clarity EMR/EHR (Oracle) into our SQL server data warehouse, facilitating analysis and software suite support.
- Integrated our data repository with the MicroStrategy analytics tool for generating interactive reports and self-service capabilities for advanced users.
- Oversaw up to 15 offshore developers to align front- and back-end development. Overhauled SSRS code via SQL procedures for greater speed and precision, resulting in a leaner team and faster product development.
- Collaborated with experienced EPIC clinicians and nurses to grasp electronic health record data relationships and business rules, mastering the extraction of data relevant to our business requirements.
Senior Programmer | Data Analyst | Consultant
CVS Health
- Deployed and automated ETL operations that complied with Sarbanes-Oxley and HIPAA using SSIS and SQL Server. Handled requirements, testing, documentation, and production migration while upholding requisite audit trails.
- Developed and managed drug formulary, benefits, enrollment, PlanFinder, and claims processing. Established an SSIS and SQL ETL process for First Databank maintenance and MediSpan data conversion across the company.
- Crafted and refined complex, normalized SQL data warehouses, automating ETL processes for population, upkeep, and validation. Ensured data integrity and error management with comprehensive logging.
- Established multiple enterprise-grade ETL processes in SSIS, producing templates that enable reuse with minimal adjustments, made possible by configurable settings and dynamic expressions.
- Handled data integration, normalization, analysis, reporting, management, and manipulation, including data cleansing and validation. Focused on performance tuning and optimization within large data sets.
Senior Business Analyst | Programmer Analyst | Consultant
University Hospitals
- Converted existing DTS packages to SSIS while optimizing and automating processes to enhance ETL speed and accuracy, reducing manual intervention through data integrity verifications and logging.
- Served as a business analyst between the quality institute and IT solutions department, collaborating with analysts, nurses, and pharmacists to extract and analyze data from SQL warehouses and vendors, evaluating patient outcomes and care quality.
- Managed data encompassing patient demographics, diagnoses, procedures, outcomes, doctor credentialing, and financial details for UH's seven core hospitals. Handled external systems like Consortium, Premier, Midas, and Soarian Financials.
Senior Programmer | Data Analyst
MemberHealth
- Implemented and automated ETL processes with SSIS and SQL Server, ensuring Sarbanes Oxley and HIPAA compliance.
- Managed requirements, implementation, testing, documentation, and migration to production, maintaining audit trails per standards and regulations.
- Developed and managed drug formulary, benefits, enrollment, PlanFinder, and claims processing. Established an SSIS and SQL ETL process for First Databank maintenance and Medi-Span data conversion across the company.
- Created and optimized complex normalized SQL data warehouses, including automated ETL processes to populate, maintain, and validate data based on business rules and IT integrity checks with error trapping and logging.
- Developed enterprise-level ETL processes in SSIS, designing reusable templated packages adaptable through configurations and dynamic expressions within the components.
- Focused on data integration, normalization, analysis, reporting, management, manipulation, cleansing, scrubbing, and validation. Tackled large datasets where performance tuning and code optimization were crucial.
Business Analyst | Developer
Proximity Marketing
- Worked on SQL data warehouse design, data collection, web forms creation and design, and email campaigns. Created in-house web tools to quickly build simple to complex web forms blending ASP, HTML, DHTML, DOM, and JavaScript.
- Liaised with customers to fully comprehend their requirements, enabling precise project scoping and tailored implementation.
- Oversaw data management and quality control, ensuring data integrity through client-side (JavaScript) and server-side (SQL) data validation processes.
Programmer Analyst
FirstEnergy
- Introduced to data management and programming using SAS, PROC SQL, data marts, and BrioQuery, a GUI-based data mining tool.
- Partnered with multiple departments to merge data from diverse origins to establish the inaugural DataMart, which became the central data source for our department's project planning.
- Collaborated with senior analysts to build an electric load forecasting model and a mock billing system. Provided daily, on-demand reports for executive management to support rate calculation strategies and PUCO hearings, utilizing SAS and BrioQuery.
- Streamlined efficiency by automating manual processes, reducing turnaround time, and curtailing human error through reverse engineering reports to their origin data sources.
- Specialized in data warehousing, integration, normalization, analysis, management, manipulation, as well as data cleansing, scrubbing, and validation.
Experience
New Trivia App
Created a fresh install of SQL Server, SSMS, and Visual Studio to establish development and production environments.
DATABASE DESIGN
Analyzed raw data to design and architect staging and production databases from scratch, including ETL processes using SSIS and SQL procedures in Microsoft Management Studio with source control in Visual Studio TFS.
ETL PROCESSES
Developed ETL processes to load raw data, transform it into a normalized database and create a data repository for front-end applications. Converted data from SQL to JSON and MariaDB formats.
DATA SOURCES
Integrated diverse data sources such as TiVo for entertainment, Oxford dictionaries in XML format, Webster dictionary, KBB for automotive data, and a variety of curated question/answer collections.
TEAM LEADERSHIP
Headed a team of SQL developers to integrate additional data into the system, expanding the repository. Collaborated with middleware and front-end teams to align with targets and timelines.
Skills
Libraries/APIs
ODBC
Tools
Visual Studio, TFS, Microsoft Excel, Microsoft Word, Google Sheets, IBM Data Studio, GitHub, WinSCP, Trello, Jira, VersionOne, Microsoft Access, Microsoft PowerPoint, Microsoft Power BI, Microsoft Visual SourceSafe (VSS), DTS, BrioQuery
Languages
T-SQL (Transact-SQL), SQL, XML, JavaScript, HTML, Python, SAS, Snowflake
Paradigms
Agile, Unit Testing, Functional Testing, Automation, HIPAA Compliance, ETL, Business Intelligence (BI), HTML DOM, Continuous Deployment
Storage
SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), Data Integration, Database Modeling, Database Integration, Microsoft SQL Server, SQL Server 2012, NoSQL, Data Validation, Data Pipelines, Microsoft Parallel Data Warehouse (PDW), SQL Server Reporting Services (SSRS), JSON, MySQL, MongoDB, MariaDB, PostgreSQL, IBM Db2
Frameworks
Hadoop, Windows PowerShell, ASP.NET
Platforms
Oracle, Salesforce
Industry Expertise
Project Management
Other
Data Modeling, Documentation, Integration Testing, Performance Testing, Regression Testing, Data Integrity Testing, Task Automation, Process Improvement, Performance Tuning, Data Analysis, MediSpan, First DataBank, Waterfall Methodology, Normalization, Data Warehousing, Data Warehouse Design, Back-end, Data Engineering, Data Processing Automation, Data Analytics, Data Reporting, Business Analysis, Data Architecture, Data Migration, Large-scale Data Migration, Data, Data Strategy, Database Optimization, Query Optimization, Harvest, Epic, Electronic Medical Records (EMR), MicroStrategy, Claims, Sarbanes-Oxley, DHTML, Middleware, Remote Team Leadership, Data Visualization, Dashboards, BI Reporting, Excel Macros, RedPoint, Content Management Systems (CMS), Mainframe Systems, APIs
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring