Sql Server Team Lead

JIGAR BADGUJAR

Hartford, CT Mo: +1-832-***-**** *****.********@****.*** LinkedIn

1

SUMMARY

Strategic Technology Leader with 19+ years of experience driving enterprise-scale digital transformation across financial and insurance domains. Proven expertise in cloud-native architecture, data modernization, database management & migration with SQL Server, PostgreSQL. Adept at leading cross-functional global teams, managing complex data ecosystems, and delivering scalable solutions using AWS Glue, Snowflake, PostgreSQL, and DBT. Certified AWS Cloud Practitioner and GitLab CI/CD Specialist with a strong foundation in Agile delivery, stakeholder engagement, and performance optimization. Recognized for mentoring high-performing teams and aligning technology initiatives with business goals to maximize ROI and operational efficiency TECHNICAL SKILLS

Programming & Frameworks

• C#, ASP.Net, .NET Framework, Python, VBA Script

Cloud & Database

• Microsoft SQL Server, MS Access, DBT, Snowflake, PostgreSQL

• ETL/ELT: SSIS, AWS Glue, Informatica, Tableau

Integration & Messaging

• Service-Oriented Architecture (SOA) principles and patterns DevOps & Tools

• GitLab CI/CD, Git, JIRA, Kanban, TortoiseSVN, Autosys, Control-M CERTIFICATIONS

• AWS Certified Cloud Practitioner

• GitLab Certified CI/CD Spe

EXPERIENCE

Cognizant Technology Solutions US Corp: Project Manager Nov’14 - Present LPL Financial – TBAR EOD Batch Optimization & Modernization Hartford, CT Team Lead Jul’25 – present

As part of the optimization of the current database objects and modernization of the legacy processes this project focused on transforming legacy EOD batch processes—including DIS, SSIS, SQL Server objects, Informatica, and non-DIS jobs—into modern, cloud-native optimized solutions.

ROLES AND RESPONSIBILITIES

• Led the discovery phase by analyzing each batch process and its components to define the scope of work. Identifying all the SPs and functions getting utilized by legacy system and getting the list ready of all the tables and fields affecting dur to those objects.

• Documented legacy processes and collaborated with Solution Architects to determine the most effective modernization strategies and technologies.

• Conducted technical assessments of existing systems, identified design bottlenecks, and refined approaches in collaboration with the team.

• Designed and developed cloud-native solutions using AWS Glue, Snowflake, and PostgreSQL, ensuring optimized and scalable outcomes.

• Performed SQL performance tuning through execution plan and profile analysis.

• Data configuration, validation, and issue resolution, including production support and backend code fixes. LPL Financial – ACE Batch Modernization Hartford, CT Team Lead Jul’24 – Jun’25

As part of the Atria Scale initiative, the ACE Batch Modernization project focused on transforming legacy batch processes— including DIS, SSIS, Informatica, and non-DIS jobs—into modern, cloud-native solutions. JIGAR BADGUJAR

2

ROLES AND RESPONSIBILITIES

• Spearheaded modernization of legacy batch processes into cloud-native solutions using AWS Glue, Snowflake, PostgreSQL, and DBT to enhance scalability, performance, and maintainability.

• Led discovery and impact analysis across DIS, SSIS, Informatica, and non-DIS jobs to define modernization scope.

• Collaborated with architects to design scalable data pipelines and optimize SQL performance.

• Directed release planning, production validation, and cross-functional coordination across onsite-offshore teams.

• Maintained detailed JIRA documentation for traceability and audit readiness. LPL Financial – LPLE Remediation (Prudential Migration) Hartford, CT Team Lead Nov’23 – Jun’24

Following LPL’s acquisition of Prudential Wealth Management, a new sub-firm, LPLE. This initiative focuses on integrating LPLE into the ecosystem with minimal disruption and maximum efficiency. ROLES AND RESPONSIBILITIES

• Managed integration of Prudential Wealth Management into LPL’s IT ecosystem, supporting over 12,000 db objects across 100+ databases.

• Designed and implemented SPs, triggers, and SQL Agent jobs to support business logic & data migration.

• Conducted performance tuning and collaborated with SMEs to map jobs to applications for seamless onboarding.

• Oversaw deployment cycles and maintained comprehensive documentation for compliance and support.

• Coordinated cross-functional release planning and maintained audit-ready documentation in JIRA. Lincoln Financial Group for Group Protection - Under Writing & Control Work Bench Hartford, CT Sr Developer Sep’21 – Oct’23

Project focuses on enhancement and automation of Group Benefits Underwriting and Policy Admin systems to support Mid- Market policy and proposal changes.

ROLES AND RESPONSIBILITIES

• Engineered enhancements for underwriting and policy admin systems supporting mid-market proposals.

• Developed SQL Server components and ETL logic to integrate internal and external data sources.

• Resolved production issues and optimized backend processes for data integrity and performance.

• Worked on multiple applications including Underwriting Workbench, Contracts Workbench, Account Change Management, and Evidence of Insurability.

Lincoln Financial Group for Illustration Team – DesignIt & LifeComp Hartford, CT Sr Developer Oct’19 – Sep’21

Initiative for development and enhancement of DesignIt, a web-based insurance illustration platform used by agents and brokers to generate life and term insurance proposals.

ROLES AND RESPONSIBILITIES

• Modernized insurance illustration platforms, transitioning desktop functionality to web-based architecture.

• Built microservices and CI/CD pipelines to support automated deployments and scalable delivery.

• Migrated source code from SVN to Git and implemented robust version control strategies. Lincoln Financial Group for Party Data Management - FAST Integration Hartford, CT Technology Lead Nov’17 – Oct’19

Design and development of the FAST integration system under the Party Data Management (PDM) initiative to modernize beneficiary data handling. The project aimed to build a unified, digitized data foundation to improve operational efficiency, data accuracy, and decision-making across business units. ROLES AND RESPONSIBILITIE

• Led FAST integration to digitize beneficiary data, improving accuracy and operational efficiency.

• Designed ETL pipelines reducing load time from 11 hours to 27 minutes.

• Collaborated across departments to align data governance and security standards. Lincoln Financial Group for Executive Benefits - EBPedia Portal Development Hartford, CT Lead Developer May’17 to Nov’17

JIGAR BADGUJAR

3

Development and enhancement of EBPedia, a centralized web portal supporting Lincoln’s Executive Benefits products, including COLI (Corporate-Owned Life Insurance) and BOLI (Bank-Owned Life Insurance). ROLES AND RESPONSIBILITIES

• Developed centralized portal for Executive Benefits products, streamlining fund tracking and compensation data delivery.

• Acted as onshore coordinator, managing offshore teams and stakeholder communications. Lincoln Financial Group for Executive Benefits Business Application Support Hartford, CT Sr Developer May’17 to Nov’17

LincolnEB.com, the core web application for Lincoln’s Executive Benefits (EB) business, which provides 24/7 access to COLI and BOLI product information for brokers, administrators, vendors, and internal operations teams. Ensured high availability and performance of the platform critical to business continuity. ROLES AND RESPONSIBILITIES

• Provided 24/7 production support for mission-critical EB applications.

• Managed Autosys job scheduling and vendor integrations with ANDESA.

• Coordinated onsite-offshore efforts, managed escalations, and ensured timely issue resolution. Lincoln Financial Group for Executive Benefits – DB Migration Hartford, CT Sr SQL Developer Jul’17 to Apr’17

Lincoln’s Finance Modernization initiative by migrating the Executive Benefits (EB) data platform from MS Access to a modern, scalable SQL Server environment. The project aimed to enhance data integrity, reporting capabilities, and operational efficiency across EB systems.

ROLES AND RESPONSIBILITIES

• Migrated legacy EB databases from MS Access to MS SQL Server, ensuring data consistency and system reliability.

• Developed ETL processes and historical data load scripts to support seamless data integration and transformation.

• Scheduled and maintained SQL Server Agent jobs to automate data workflows and ensure timely execution.

• Reengineered legacy macros and implemented equivalent logic in Informatica for improved automation and maintainability.

Lincoln Financial Distributor for Sales Performance Reporting Management Radnor, PA Sr SQL/Tableau Developer Dec’14 to Jul’16

Contributed to Lincoln’s Finance Modernization initiative by supporting the Life Data component, which aimed to build a unified, analytics-ready data foundation. The project focused on improving operational efficiency, product margins, and decision-making through enhanced data integration and reporting.

ROLES AND RESPONSIBILITIES

• Developed ETL processes and interactive Tableau dashboards to support finance modernization.

• Ensured SLA adherence and data accuracy across enterprise repositories. L&T Infotech US Corp: Senior Software Engineer from Jan’14 to Nov’14 BHP Billiton for Subsurface Data Audit Management & Automation Houston, TX Ocean/DB Developer Lead Jan’14 to Nov’14

Audit, migration, and integration of subsurface geoscience data (Well, Seismic, Drilling) into enterprise systems to align with BHP’s data governance and quality standards. Development of data audit automation tool to validate and extract the most accurate version of subsurface data using business rules such as completeness, consistency, validity, and uniqueness. ROLES AND RESPONSIBILITIES

• Led audit and migration of geoscience data using InnerLogix and Ocean SDK.

• Developed automation tools with OCR integration to digitize well header data

• Delivered high-performance applications with a 4.7 CSI rating. L&T Infotech India: Senior Software Engineer from Sep’11 to Jan’14 Schlumberger Information Solutions for Petrel Plug-ins Development for SIS Mumbai, MH, INDIA JIGAR BADGUJAR

4

Ocean/DB Developer Sep’11 to Jan’14

Plug-ins development for Schlumberger’s Petrel platform using Ocean SDK and .NET Framework to enhance geophysical and reservoir analysis capabilities. Projects included both proprietary and internal tools for seismic interpretation and data processing. ROLES AND RESPONSIBILITIES

• Designed and developed plug-ins using Ocean SDK for Petrel Studio, including:

• Spectral Decomposition, Wavelet Transformation and, Reservoir Summation and Volumetric Analysis

• Built additional tools under L&T Infotech IP, such as:

• Bandwidth Extension Tool, Dip Calculator to Event Tracker and, Seismic Q Estimation Tool. WebDev Inc: Lead .Net/SQL Developer from Mar’08 to Sep’11 Asset & Portfolio Management System Mumbai, MH, INDIA WebDev Inc. is a software solution provider expert in understanding the dynamics of the small and medium-sized enterprises and cater our services accordingly.

Developed and supported custom software solutions for small and medium-sized enterprises, including systems for account portfolio management, loan settlement, and back-office auditing. ROLES AND RESPONSIBILITIES

• Installed and configured SQL Server 2008 R2; migrated databases from SQL Server 2005.

• Performed database backups, restorations, and performance optimization tasks.

• Designed normalized database schemas to support reporting and operational requirements.

• Developed SSIS packages for automated data loading and transformation from status files.

• Created SSRS reports to visualize performance metrics and operational KPIs.

• Coordinated with offshore teams to ensure smooth project execution and delivery. Pulse Solutions: Web Developer from Nov’07 to Mar’08 E-Commerce Application Development Mumbai, MH, INDIA A dynamic e-commerce platform for an online sports merchandise store, supporting end-to-end shopping and order management functionality.

ROLES AND RESPONSIBILITIES

• Participated in full SDLC, including requirement gathering, system design, and implementation.

• Designed web architecture, data models, and database schema to support business logic and user workflows.

• Developed front-end components using HTML and CSS; implemented back-end logic using ASP.NET.

• Conducted unit testing and deployed the application to the production web server for go-live. DRC Web Creation: Web Developer from Feb’07 to Nov’07 E-Commerce Application Development Surat, GJ, INDIA A custom e-commerce application for Dharamanandan Diamonds Pvt. Ltd., enabling online sales and management of diamond inventory and customer transactions.

ROLES AND RESPONSIBILITIES

• Collaborated with cross-functional stakeholders to gather and analyze business requirements across departments.

• Translated business needs into technical specifications and implemented scalable solutions using the .NET framework.

• Improved system performance and data processing efficiency, achieving a 40% reduction in response time.

• Enhanced user experience through optimized application logic and streamlined workflows. EDUCATION

Veer Narmad South Gujarat University, Surat, Gujarat, India

• Master of Science (M.Sc.) in Information Technology, 2005 – 2007

• Bachelor of Science (B.Sc.) in Information Technology, 2002 – 2005

Contact this candidate