pulgams1988 shivaji — Data Engineer

visitor@portfolio:~$whoami

Results-driven Senior Data Engineer and ETL Developer with 9.6+ years of experience designing scalable database solutions, high-performance ETL pipelines, and insightful BI dashboards across financial services and healthcare domains. Proven track record delivering for enterprise clients including Wells Fargo and Barclays at Capgemini. Deep expertise in Microsoft SQL Server, SSIS, Azure Data Factory, T-SQL performance tuning, Tableau, and SSRS. Experienced in end-to-end cloud migrations (on-premises to Azure) and Agile delivery. Open to Senior SQL Developer, Azure Data Engineer, ETL Developer, and BI Developer opportunities across any work mode.

Hyderabad, TG

visitor@portfolio:~$> cat README.md

visitor@portfolio:~$> experience --list

Senior Consultant@CAPGEMINI TECHNOLOGY SERVICES

May 2023 - Jul 2025[Hyderabad, TG]

Clients: Wells Fargo, Barclays
Projects: CcaaS, Tech Refresh, BPFDWH
Led the design and development of complex database schema objects, including tables, indexes, and stored procedures, to support high-volume financial data processing.
Designed and developed new database schema objects such as tables, indexes, views, stored procedures, functions, triggers, jobs, etc.
Altered, Created T-SQL complex queries involving multiple tables, Joins, Sub queries, Derived queries.
Designed, developed, and optimize SQL queries, views, stored procedures, and functions and Table Variables.
Created packages by testing and cleaning Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
The packages and data mapping are extensively designed using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS
Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
Architected and optimized end-to-end ETL pipelines using SSIS and Azure Data Factory (ADF) for seamless data movement across on-premises and cloud environments.
Implemented robust data transformation logic using advanced SSIS components like Conditional Split and Script Tasks to ensure high data quality and accuracy.
Managed large-scale data migrations to Azure SQL Data Warehouse and Blob Storage, leveraging Linked Services and Pipeline orchestration for enterprise-grade solutions.
Automated monthly and weekly data feeds using SQL Server Agent jobs and Service Now for change request management and task implementation.
Spearheaded performance tuning initiatives for complex T-SQL queries and SSIS packages, significantly improving data processing efficiency and reliability.
Directed the migration of legacy ETL systems (e.g., DTS to SSIS or on-prem to Cloud) and successfully upgraded SQL Server environments with zero downtime.

Senior Software Engineer@PRIMERA MEDICAL TECHNOLOGIES

May 2020 - Oct 2021[Hyderabad, TG]

Client: PRIMERA
Projects: Medical Group
Designed and developed interactive Tableau dashboards utilizing parameters and calculated fields to monitor and improve customer unit KPIs by 12% within a month.
Orchestrated the automation of medical group data extraction from diverse sources into centralized SQL Server databases through sophisticated SSIS packages.
Developed comprehensive database architectures featuring staging tables, master tables, and dynamic T-SQL queries to support healthcare data specifications.
Managed project deliverables and deadlines by facilitating regular requirement gathering and data specification sessions with onshore technical teams.
Executed complex data transformations using SSIS Lookup, Derived Column, and Aggregate components to facilitate high-quality healthcare reporting and analysis.
Established robust error handling and debugging protocols to troubleshoot and resolve production coding issues within the ETL development lifecycle.
Experience in Error handling and debugging coding issues and troubleshooting production problems.
Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task, script component, union, merge, merge join etc.,
Created Loggings, event handler, checkbox, breakpoints, error handling in SSIS packages.

Senior software engineer (Bi)@IKS HEALTH

Feb 2016 - May 2020[Hyderabad, TG]

Projects: T-Systems, USMD, VIRTUA, AMKAI, PROLIANCE, CMM
Designed and implemented daily provider and payer summary reports using SQL Server and SSRS to provide critical business intelligence to stakeholders.
Developed sophisticated analytical dashboards, such as "AR Deep Drive Analysis," using T-SQL, CTEs, and advanced joins for monthly performance mapping.
Managed the end-to-end lifecycle of work order preparation and inventory management for multiple healthcare projects within strict TAT requirements.
Engineered automated data flows using SSIS Control Flow and Data Flow tasks, including For Each Loops and Execute Package tasks for data integration.
Created comprehensive SSRS reporting solutions for Contract Analysis and CMM Inflow/Outflow reports to support executive-level decision-making processes.
Collaborated with internal operational teams to ensure the timely delivery of data models and stored procedures necessary for high-volume healthcare data processing.

ASSOCIATE (BI)@IKS HEALTH

May 2013 - Aug 2014[Hyderabad, TG]

Developed basic T-SQL queries and stored procedures to support internal Business Intelligence reporting requests and data extraction requirements.
Monitored daily ETL job executions and performed initial troubleshooting for data loading failures in the development environment.
Conducted data profiling and validation tasks to ensure the accuracy of source data before integration into the primary data warehouse.
Documented technical specifications for data mapping and reporting requirements to support senior engineering team members in project delivery.
Maintained and updated existing SSRS report layouts to reflect changing business branding and formatting requirements for healthcare clients.
Participated in Agile team meetings to understand healthcare domain workflows and data requirements for revenue cycle management projects.

visitor@portfolio:~$> npm install --save-dev

+Database Engineering: Microsoft SQL Server

+T-SQL

+Performance Tuning

+Stored Procedures

+Indexing

+Views

+Triggers

+MS SQL

+Tableau

+Business Intelligence

+Azure

+ETL & Data Integration: SSIS

+ETL Development

+Data Migration

+Error Handling

+Logging

+Data Quality

+Bulk Insert

+BCP

+Cloud & Modernization: Azure Data Factory (ADF)

+Azure Blob Storage

+Azure Data Lake

+Cloud Migration

+Business Intelligence: Tableau Developer

+SSRS

+Data Visualization

+Dashboard Design

+Parameterized Queries

+KPI Tracking

+Tools & Environments: SQL Server Management Studio (SSMS)

+Service Now

+Git

+SQL Server Agent

+Visual Studio

+XML

+Domain & Process: US Healthcare RCM

+Agile/Scrum

+SDLC

+Data Integrity

+Stakeholder Management

+Technical Documentation

visitor@portfolio:~$> cat /etc/education

MASTER OF COMPUTER APPLICATIONS

MANPOWER DEVELOPMENT PG COLLEGE, Osmania University

Jan 2010 - Jan 2013 | Hyderabad, TG

visitor@portfolio:~$> cat .contact

[email protected]

8019755779

visitor@portfolio:~$echo "Thanks for visiting!"