Stewart Jeremiah Email & Phone Number

Remote

* Spearheaded database development and architecture for the leading large-scale Clinical Communication and Collaboration Platform, servicing 500+ hospitals, 45k+ practices, 250k+ physicians, 600k+ nurses, and care team members providing 99.9% operational uptime.* Achieved optimal performance through meticulous analysis of current queries, index utilization, query plans, and extensive use of tools such as dynamic management views, SQL Profiler, activity monitoring, error logs, and in-house… Show more * Spearheaded database development and architecture for the leading large-scale Clinical Communication and Collaboration Platform, servicing 500+ hospitals, 45k+ practices, 250k+ physicians, 600k+ nurses, and care team members providing 99.9% operational uptime.* Achieved optimal performance through meticulous analysis of current queries, index utilization, query plans, and extensive use of tools such as dynamic management views, SQL Profiler, activity monitoring, error logs, and in-house monitoring solutions.* Orchestrated the design and maintenance of an extensive OLTP database infrastructure, comprising 2500+ stored procedures, 250+ tables, 1000+ triggers, constraints, and indexes, and managed over one million schedules and rules.* Pioneered the development of a patented Dynamic Intelligent Routing Architecture, delivering an impressive average response time of 2-25ms.* Managed, developed, and oversaw data replication for a 10-terabyte on-premises data warehouse and data marts, instrumental in data analytics, permanent data archival, SSRS, ad-hoc reporting, and QlikView dashboards.* Designed and maintained SSIS packages for HL7 patient data import, streamlining data integration processes.* Led the development and support of over 200 SSRS reports and QlikView dashboard, providing essential quantitative analytics and qualitative data sets through 500+ subscriptions.* Architectured a Clinical Scheduling Service, accommodating over one million schedules, and reduced event determination time to less than 10ms.* Successfully navigated a dynamic work environment, transitioning from a traditional SDLC (Waterfall) to an Agile/Scrum/Kanban methodology, collaborating with cross-functional teams across different countries and time zones, working remotely.* Worked on a small team prototyping the migration of SSRS reports and the QlikView dashboards into a LookerML on Azure environment, employing FiveTran replication and change tracking within on-premises databases. Show less

* Managed Team of Six SQL Server Developers to Handle New OLTP Development and Expansion of Datawarehouse* Mentored Others to Understand the Complexities of the Perfectserve Platform* Position Eliminated Due to Reorganization to Agile/Scrum

Nashville, Tennessee, United States

* Designed and developed a robust Data Warehouse to facilitate the Internal Financial Group's operations, utilizing (SSAS) Analysis Services and (SSIS) Integration Services. Additionally, created cubes for integration with Excel add-ons.* Led the database development efforts and architected the ETL daily processing system, optimizing data transfer and processing to meet business requirements effectively.* Acted as a key liaison between the organization and major clients, including… Show more * Designed and developed a robust Data Warehouse to facilitate the Internal Financial Group's operations, utilizing (SSAS) Analysis Services and (SSIS) Integration Services. Additionally, created cubes for integration with Excel add-ons.* Led the database development efforts and architected the ETL daily processing system, optimizing data transfer and processing to meet business requirements effectively.* Acted as a key liaison between the organization and major clients, including Sprint, AT&T, and others. This involved gathering client requirements, analyzing, and creating ETL/data management solutions, functional specifications, and requirement documents.* Took charge of designing, coding, and testing SQL Server modules crucial for ETL and data management processes, ensuring smooth data flow and transformation. Show less

* Served as a Senior SQL Server Developer, contributing significantly to the development of Health Maintenance Reminders, Bulk Enrollment Order Reminders, Order Scheduling, and Patient Worklists helping to reduce response time to the customer.* Successfully completed more than 30 complex development tasks with minimal supervision demonstrating a high degree of proficiency and self-reliance working remote before remote was a word.* Managed and optimized performance within the primary… Show more * Served as a Senior SQL Server Developer, contributing significantly to the development of Health Maintenance Reminders, Bulk Enrollment Order Reminders, Order Scheduling, and Patient Worklists helping to reduce response time to the customer.* Successfully completed more than 30 complex development tasks with minimal supervision demonstrating a high degree of proficiency and self-reliance working remote before remote was a word.* Managed and optimized performance within the primary database, encompassing over 525,000 lines of SQL code distributed across 2800 stored procedures, 1000 tables, and 120 functions, ensuring its efficiency and reliability. Show less

* Spearheaded the design, development, and deployment of an automated letters generation process for radiological authorizations of medical requests. This innovation resulted in a significant reduction in manual processes, improving overall efficiency. * Took on the role of the chief developer for the SQL Server environment, responsible for managing the verification of authorizations through a PeopleSoft interface application. * Developed SQL Server implementation scripts to handle the… Show more * Spearheaded the design, development, and deployment of an automated letters generation process for radiological authorizations of medical requests. This innovation resulted in a significant reduction in manual processes, improving overall efficiency. * Took on the role of the chief developer for the SQL Server environment, responsible for managing the verification of authorizations through a PeopleSoft interface application. * Developed SQL Server implementation scripts to handle the definition of extractions within various development, testing, and production environments, ensuring smooth data handling and transfer. * Successfully led a software project that exceeded client expectations and streamlined daily workflows between MedSolutions and participating doctors, facilities, and patients. * Maintained a strict project schedule, oversaw functional requirements, and managed the deployment of production services, ensuring the project's success. Show less

* Served as a Senior SQL Server Developer, overseeing the development of new features, enhancements, and correction of functional deficiencies for eight primary Multiple Listing Service Clients and 18 secondary Multiple Listing Service Accounts. * Created, monitored, and maintained more than 250 DTS packages and scheduled jobs on our production servers.. These DTS packages were instrumental in performing data imports and exports, object movements, and hourly/daily data migration to/from… Show more * Served as a Senior SQL Server Developer, overseeing the development of new features, enhancements, and correction of functional deficiencies for eight primary Multiple Listing Service Clients and 18 secondary Multiple Listing Service Accounts. * Created, monitored, and maintained more than 250 DTS packages and scheduled jobs on our production servers.. These DTS packages were instrumental in performing data imports and exports, object movements, and hourly/daily data migration to/from external systems, managing databases exceeding 1 TB in size. * Recognized by management for expertise in reviewing system performance and identifying application bottlenecks. - Addressed complex data issues, which included standardizing a monthly activity report stored procedure, reducing execution time from 2 hours to less than 1 minute. * Continuously monitored system performance, identifying and reworking web-based initiated queries to reduce CPU utilization. Show less

* Successfully identified and resolved bottlenecks within the ETL (Extract, Transform, Load) process, significantly improving system performance. These improvements were made as part of Six Sigma training, showcasing a commitment to process optimization and efficiency.* Streamlined a data loading process, facilitating the transfer of data from a UNIX server to a Windows 2000 Oracle 9i server. Achieved this through the implementation of external tables and merge functionality within Oracle… Show more * Successfully identified and resolved bottlenecks within the ETL (Extract, Transform, Load) process, significantly improving system performance. These improvements were made as part of Six Sigma training, showcasing a commitment to process optimization and efficiency.* Streamlined a data loading process, facilitating the transfer of data from a UNIX server to a Windows 2000 Oracle 9i server. Achieved this through the implementation of external tables and merge functionality within Oracle, using Unix Shell scripts. Show less

* Led the development and served as the Chief Software Engineer for the implementation and administration of production database systems. These OLTP (Online Transaction Processing) databases supported a real-time communication system featuring 350+ tables, 900+ stored procedures, triggers, and views, handling over 3,000,000 transactions daily.* Engineered relational OLAP reporting databases containing 400+ million records and 110GB of storage, managing ETL (Extract, Transform, Load) of… Show more * Led the development and served as the Chief Software Engineer for the implementation and administration of production database systems. These OLTP (Online Transaction Processing) databases supported a real-time communication system featuring 350+ tables, 900+ stored procedures, triggers, and views, handling over 3,000,000 transactions daily.* Engineered relational OLAP reporting databases containing 400+ million records and 110GB of storage, managing ETL (Extract, Transform, Load) of 300MB of data daily using DTS scripting and custom stored procedures. All databases utilized dynamic SQL, vertical and horizontal data partitioning, distributed query processing, data conversion, and aggregation of detail data. * Orchestrated a project to generate Data Dimensions and Data Cubes through Analysis Services, facilitating the reporting of results to the company's top executives, including the President, CTO, and CFO, as well as company-wide managers. * Served as the Task Leader for a team of five developers, responsible for requirements gathering, design, development, testing, and deployment of data-intensive systems. * Provided technical and strategic direction, oversaw scheduling and planning of software-related tasks, and actively participated in the software Change Control Board (CCB). Authored technical memorandums and documented database design. * Managed transaction definition, software optimization, performance tuning, and proactive monitoring of production and development systems. Show less