Jacob Keecheril
Harrisburg,PA
Summary
Senior Database Developer with extensive experience in database design, ETL development, and SQL optimization. Proven track record in performance tuning and report generation, leading to improved system efficiency and data-driven decision-making. Collaborative team player adept at managing diverse datasets across multiple platforms.
Overview
19
19
years of professional experience
Work History
Senior Database Developer
VA Electronic Health Record (EHR)
08.2025 - Current
- Design, build, and maintain stored procedures, functions, and triggers in PostgreSQL.
- Designed and developed advanced T-SQL stored procedures, functions, and triggers to support business logic and reporting.
- Optimized complex SQL queries and execution plans on relational database systems, improving performance across large datasets.
- Designed and developed an ETL Pipeline to load data from PostgreSQL, MySQL, SQL Server, CSV files, and Oracle.
- Reviewed database design and integration, providing actionable recommendations that enhanced system performance.
- Contributed to decreasing the need for downtime by developing and improving procedures for automated monitoring and proactive interventions.
- Hands-on experience working with HL7 v2.x (ORU messages) for processing, parsing, and integrating healthcare data within relational database and ETL environments.
- Created complex reports and dashboards in Power BI, facilitating data-driven decision-making for stakeholders.
- Worked on a project for the U.S. Department of Veterans Affairs (VA) through VetsE
- Environment: PostgreSQL, MySQL, Power BI, DAX, SSIS, ETL, Oracle, SQL Server, and GIT
Lead Database Engineer
Chubb Insurance
Remote, NJ
04.2022 - 06.2025
- Worked extensively with SQL Server 2016+ for building and optimizing enterprise data solutions.
- Designed and fine-tuned T-SQL (Stored Procedures, Advanced Queries, Performance Optimization) for performance and scalability.
- Tuned database performance and indexed relational databases to enhance system efficiency and scalability.
- Designed, built, and maintained stored procedures, functions, and triggers.
- Developed ETL pipeline and scheduling to load data from SQL Server, CSV files, and fixed-length record files using SSIS.
- Created complex reports and dashboards using Power BI.
- Developed interactive Power BI dashboards and reports.
- Implemented data analysis solutions for Global Actuarial Systems.
- Environment: Oracle, EXCEL(VBA), MySQL, Power BI, DAX, ETL, C#, SSIS, and GIT
Lead Software Engineer
FAA(Fed. Aviation Admin.)
07.2020 - 02.2022
- Created complex stored procedures and functions.
- Enhanced stored procedures for improved accuracy and performance.
- Managed source code repositories and branching strategies using Git.
- Migrated and cleansed server-side data to Microsoft cloud using SSIS, ensuring data integrity.
- Developed interactive Power BI dashboards and reports.
- Managed grant-related data input, updates, and maintenance to ensure accuracy for reporting and analysis.
- Assisted in financial analysis for support services
- Environment: Oracle and ETL, Power BI, SSRS, Git, SSIS.
ODHH & MEDIATION
Department of Labor and Industry
Harrisburg, PA
08.2018 - 05.2020
- Created Web forms using ASP.NET.
- Developed complex reports using SQL Server and SSRS, presenting them to users via VB.NET and ASP.NET for enhanced data visibility.
- Developed numerous complex reports to enhance data analysis and decision-making. using SSRS and SQL Server.
- Designed and implemented SSIS jobs for efficient data transfer across diverse platforms, ensuring data integrity.
- Created complex stored procedures and user-defined functions using SQL Server.
- Performed Data Analysis and Data validation by writing SQL queries.
- Created indexes and optimized stored procedures to enhance query performance and accuracy.
- Environment: SQL Server 2016, SSIS, TFS, VB.NET, ASP.NET, SSRS, XML Web Forms.
Lead Developer
Department of Health
Harrisburg, PA
01.2016 - 06.2018
- Led data migration from Oracle to SQL Server, ensuring successful transition of critical applications.
- Developed and deployed SSIS packages for data processing and migration between Oracle and SQL Server, enhancing data integrity and accessibility.
- Created New functionalities using Dot net for the NEDSS Application.
- Developed and supported advanced web-based and client/server applications for the PA-NEDSS.
- Support, maintain, and deploy large-scale, mission-critical internet technologies for use by more than 200 Hospitals and more than 250 Commonwealth-licensed laboratories.
- Resolved escalated support tickets for MS Azure IaaS platform, achieving timely closure and maintaining service continuity.
- Ensured data security and compliance (HIPAA, PHI/PII, CDC standards) while handling sensitive public health and patient data.
- Environment: SQL Server, ORACLE, TOAD, SSIS, TFS, VB.NET, ASP.NET, SSRS, XML, Web Forms.
File Processing System (Team Lead/Sr Developer)
NRA
Harrisburg, PA
04.2015 - 12.2016
- Designed and implemented an SSIS package to efficiently export local database tables and files to SQL Server Database.
- Optimized existing stored procedures and created indexes to enhance query performance and ensure data accuracy.
- Created stored procedures and user-defined functions using SQL Server.
- Developed data flow diagrams and mapping documents outlining source tables, columns, data types, and transformations to ensure clear data migration and adherence to business rules.
- Developed user-friendly screens to project data to the user using VB.NET and ASP.NET.
- Environment: SQL Server 2012, SSRS, SSIS, Azure Cloud, Git, VB.NET, ASP.NET, XML, Web Forms, Win Forms.
Lead Software Engineer
Department of Environment
Harrisburg, PA
03.2014 - 04.2015
- The Resource Conservation and Recovery Act (RCRA) gives the US Environmental Protection Agency (EPA) the authority to regulate the generation, transportation, storage, treatment, and disposal of hazardous wastes.
- Under a US Department of Energy/EPA interagency agreement, the Oak Ridge National Laboratory was assigned the responsibility of designing a distributed information system for EPA to facilitate reporting of RCRA data from implementers to program management.
- One of the core automation needs was to develop an automated event tracking system for the RCRA compliance monitoring and enforcement (CM&E) program.
- Developed ETL processes using Stored Procedures, PL/SQL, and Functions to load data from various data sources to the staging table and automated it using Oracle Cloud.
- Developed ETL processes with Stored Procedures, PL/SQL, and functions to automate data loading from diverse sources to staging tables using OpenNode2 and RCRA Standard.
- Created services in OpenNode2 to automate data processing with RCRA XML Schema, enhancing efficiency in data handling.
- Created data flow diagrams and mapping documents detailing source to staging and staging to target transformations, clarifying source tables, columns, data types, and required business rules.
- Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.
- Created an SSIS package to export local database Tables. and other files to Azure Database.
- Environment: Oracle 12c, Shell Scripting, OpenNode2, SSIS, TFS, VB.NET.
Vital Record System
Department of Health
Harrisburg, PA
04.2013 - 02.2014
- This is an online system to track the Local Registrar Reconciliation, including Geographic, Inventory, Payroll, Reconciliation, Audit, and the Fatal Death system, which includes Creation/Updating Death records.
- Compiled and organized certification records to ensure compliance with regulatory standards., Collected and documented parental data for health records., Recorded and maintained detailed information on fetal health and development., Medical History, Gathered and stored essential hospital information for patient records., Investigated and documented causes of death to support accurate statistical reporting., Collected and maintained parental information for medical history., etc. Loading and extracting data and the corresponding reports.
- Designed and developed technical documents for the system.
- Developed User Interface using ASP.NET, VB.NET, and web services.
- Involved in Performance Tuning of SQL Queries, Sources, Targets, and sessions by identifying and rectifying performance bottlenecks.
- Developed complex stored procedures and user functions in SQL Server.
- Created SSIS package to efficiently load data from flat files and Excel into SQL Server.
- Developed user-friendly report modules using SSRS. i.e., Drill Down, Drill Through, Sub Reports, Charts, Table.
- Examined functional requirements by collaborating with external and internal customers.
- Environment: SQL Server 2012, SSRS, SSIS, TFS, VB.NET, ASP.NET, WCF, Web Services, XML, Web Forms, Win Forms.
Sr. NET Developer/Lead
PASSHE
01.2013 - 03.2013
- Developed user interface with ASP.NET, VB.NET, and web services to enhance user experience.
- Developed complex stored procedures and user functions in SQL Server.
- Created SSIS package to efficiently load data from flat file and Excel to SQL Server 2012 using Lookup, Derived Columns, Condition Split, and Term Extraction.
- Implemented MS SQL Server security measures and database permissions to ensure data integrity and access control.
- Environment: SQL Server 2012, WCF, SSRS, SSIS, GIS, TFS, VB.NET, ASP.NET, Web Forms.
Lead Software Engineer
Department of Health
PA
06.2012 - 02.2013
- Managed Environmental Public Health Tracking program, overseeing collection, integration, analysis, interpretation, and dissemination of data from environmental hazard monitoring and human exposure and health effects surveillance.
- Created complex reports (tabular, bar, and map) for cancer, lead poisoning, birth defects, asthma, heart attacks, and carbon monoxide using SSRS 2008 R2 and SQL Server.
- Developed SSIS packages to streamline data export from CSV and Excel files.
- Ensured data security and compliance (HIPAA, PHI/PII, CDC standards) while handling sensitive public health and patient data.
- EPHT
- Environment: SQL Server, SSRS, SSIS, VB.NET, GIS Reports, TFS, ASP.NET.
Lead Software Engineer
State of Delaware Project
01.2012 - 06.2012
- ASSIST is a website that allows individuals and community-based organizations access to screen and apply for a broad range of social service programs like Long Term Care, Health Care Coverage, Food Supplement Program, Cash Assistance, Child Care Assistance, National School Lunch Program, Low Income Home Energy Assistance Program, Food Bank, etc.
- Developed a service gateway for the retrieval of information of status and corresponding details of cases from their mainframe using VB.NET.
- ASSIST
- Environment: SQL Server, SSRS, SSIS, VB.NET, ASP.NET.
Sr. Net Developer
Department of State (Sec of State’s office)
PA
03.2009 - 12.2011
- The SOSKB provides architecture designed to support the various functions of the Department of State.
- SOSKB is a framework for database applications that benefit from use of a common Name and Address (Entity) database.
- It incorporates a dynamic Security System, Imaging, Data Access, and Research.
- It was built for large, scalable applications (millions of records and images) and allows for viewing images over the Internet.
- Filings are sent to the filing engine from B2B customers, the Online filing website, and the internal application.
- SOSKB (Sec. of State Knowledge Base)
- Environment: SQL Server, DTS, Win Forms, VB.NET, SSRS, VB6, COM+, VB.NET, ASP.NET.
Tyco Electronics
12.2008 - 02.2009
- Developing new modules and modifying their Global Complaint System(TECHS).
- Duties involve Designing New Tables/writing complex stored procedures/ Functions, Coding using ASP.NET/VB.NET/ ASP.NET and Classic ASP, and documentation.
- Environment: ORACLE, Win Forms, SSRS, SSIS, Web services, VB6, Classic ASP, C#, ASP.NET.
Sr.NET Developer/Lead
Department of Public Welfare(DPW)
Harrisburg, PA
03.2007 - 12.2008
- Worked on porting existing Internet/intranet application to Portal (BEA AquaLogic).
- Created and maintained community pages and folders.
- Worked on designing of the portlets.
- Environment: BEA AquaLogic, SQL Server 2005, Web services, PL/SQL, Stored procedures.
Education
BSc - Physics
Kerala University
01-1987
Skills
- SQL optimization
- ETL development
- Database design
- Performance tuning
- Report generation
- Data integration
Personal Information
Citizenship: US Citizen
Timeline
Senior Database Developer
VA Electronic Health Record (EHR)
08.2025 - Current
Lead Database Engineer
Chubb Insurance
04.2022 - 06.2025
Lead Software Engineer
FAA(Fed. Aviation Admin.)
07.2020 - 02.2022
ODHH & MEDIATION
Department of Labor and Industry
08.2018 - 05.2020
Lead Developer
Department of Health
01.2016 - 06.2018
File Processing System (Team Lead/Sr Developer)
NRA
04.2015 - 12.2016
Lead Software Engineer
Department of Environment
03.2014 - 04.2015
Vital Record System
Department of Health
04.2013 - 02.2014
Sr. NET Developer/Lead
PASSHE
01.2013 - 03.2013
Lead Software Engineer
Department of Health
06.2012 - 02.2013
Lead Software Engineer
State of Delaware Project
01.2012 - 06.2012
Sr. Net Developer
Department of State (Sec of State’s office)
03.2009 - 12.2011
Tyco Electronics
12.2008 - 02.2009
Sr.NET Developer/Lead
Department of Public Welfare(DPW)
03.2007 - 12.2008
BSc - Physics
Kerala University