Summary
Overview
Work History
Education
Skills
Additional Information
Timeline
Work Preference
Affiliations
Work Availability
Languages
Generic
Deepak Kumar

Deepak Kumar

Associate Technical Architect
Noida

Summary

  • SQL database administrator with 17+ years of experience in designing, implementing, and maintaining complex database systems to ensure optimal performance of critical business data, maintenance and implementation of Software System.
  • Expertise in designing, implementing, and optimizing data solutions using Azure SQL, Azure Data Factory (ADF), Azure Databricks, PySpark, and (ADLS G2) Azure Data Lake Storage.
  • Expertise experience in Installation, Configuration, and Management of SQL Server, Backup and recovery.
  • Experience in Database Sharding (Horizontal and Vertical) of large databases. Splitting into small chunks of database based on data driven or selection.
  • Designed and implemented partitioning strategies for large-scale databases, resulting in a 35% improvement in query performance and reduced maintenance windows.
  • Monitored database performance and optimized queries, ensured high availability of databases by executing database mirroring, reducing unexpected downtime
  • Spearheaded role-based access control and encryption security measures that recorded zero data breaches from 2015 to 2022.
  • Support tickets and resolved database-related technical issues, boosting customer satisfaction
  • Strong knowledge of performing administrative tasks: database file management, backup/restore, Database Mirroring, Log Shipping, Replication, data integration and synchronization. Extensive use of Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing Server and Clients.
  • Perform all database management responsibilities in Microsoft Azure for production and non - production workloads Good knowledge and experience on Cloud Computing like Azure, ADF, Databricks.
  • Expertise experience in Performance Tuning using Execution plan | Extended Events | Data Collector | Resource Governor | DMV’s.
  • Implemented new Sql Server 2019 mechanism like data compressions | online indexing | Contained Databases | Securities principals
  • Strong fundamental concepts in T-Sql, SSIS, SSRS, SSAS, Dynamic SQL, Query Optimization and Performance Tuning, Scheduler, Database Designing and having hands-on experience in complete project life cycle, with domain knowledge in Healthcare and Banking (Credit Card Business). Developed modularized applications with database procedures using database objects such as procedures, functions, packages and triggers. Good Knowledge of understanding composite data types and cursors. Experience on Database migration from Lower to Higher version on Sql Server.
  • Hands on experience using Extract Transform Load (ETL) such as Azure Data Factory (ADF), SQL Server Integration Services (SSIS), SSAS analysis services for OLAP cube creation.
  • Ability to be creative and take self-initiatives and execute/ manage multiple projects in parallel during time critical situations.
  • Very good Team player, Self-motivated, hardworking professional with good organizational, leadership, interpersonal and communication skills.
  • Worked on HL7 (Health Level 7) transaction-based protocol that is driven by events such as the admittance of a patient to a hospital. Also worked on HL7-supplemental standards like Clinical Document Architecture (CDA), Electronic Health Records (EHR), Fast Health Interop Resources (FHIR).

Overview

18
18
years of professional experience
2
2
Languages

Work History

USMED EQUIP
09.2023 - Current
  • Company Overview: USMED EQUIP deals medical equipment for sale for hospitals and medical facilities. USME giving the quality-inspected equipment for sale including hospital beds, hospital monitors infusion equipment, respiratory equipment, critical care equipment, NICU.
  • Designed and implemented data pipelines using Azure Databricks and Spark, improving data processing efficiency by 35%.
  • Managed and optimized Azure SQL databases, rewritten the stored procedure for better performance, ensuring high availability and performance.
  • Developed and maintained data lakes in Azure Data Lake Storage, facilitating scalable data storage solutions.
  • Implemented robust data security practices, including encryption and access control, to safeguard sensitive information.
  • Responsible for providing 24 x 7 critical production support, Development and Clustered Servers.
  • Responsible for Performance tuning- Identify the SQL bottleneck queries and tune the queries for performance using DMV’s, Sql Profiler, xtended events.
  • Resolved locking conflicts/blocking and resource utilization. Worked with database developers and engineers to analyze database performance and identify problems in area such as: execution plans, index coverage, and SQL Server statistics. Resolved complex database administration problems.
  • Involved in Database Backup and recovery and Monitoring.
  • Actively engaged in design discussions for all Business Intelligence and database initiatives.
  • Designed and implemented a comprehensive sharding strategy for a multi-tenant application, significantly improving scalability and handling a 50% increase in traffic without performance degradation.
  • USMED EQUIP deals medical equipment for sale for hospitals and medical facilities. USME giving the quality-inspected equipment for sale including hospital beds, hospital monitors infusion equipment, respiratory equipment, critical care equipment, NICU.

BMS Practice Solutions
08.2020 - 09.2023
  • Company Overview: BMS Practice Solutions client, Revflow is a web-based Physical therapy practice management platform that provide Electronic Medical Records (EMR) solutions to complement its comprehensive A/R management, Practice Management and reporting services.
  • Built and maintained ETL processes using SQL, ensuring accurate and timely data integration.
  • Collaborated with cross-functional teams to design data models and optimize database performance.
  • Ensure compliance with data security standards and best practices, mitigating risks and vulnerabilities.
  • Production database support to confidential applications.
  • Performance tuning and deadlock analysis.
  • Development support and BCP (Business continuity) using database mirroring and log shipping.
  • Managed DDL and DML changes through the SDLC.
  • Designing and coding database Tables, Views, Functions, Stored Procedures.
  • Reviewing query performance and optimizing code.
  • Working with application developer to create optimized queries.
  • Creating table indexes to improve database performance.
  • Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
  • Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
  • Validating and creating the Weekly Release database scripts for delivery.
  • Designed and implemented partitioning strategies for large-scale databases, improvement in query performance and reduced maintenance windows.
  • Fixing Devops tickets, task, and Improvement assign by the Client.
  • Database schema comparison between QA and Dev box using Visual Studio and ReadyRoll.
  • Created various jobs to monitor resources on various servers and to mail the necessary information when threshold reached.
  • Involved in Database Backup and recovery.
  • Created SSIS packages to extract data from various heterogeneous sources like Sql Server.
  • Extract Transform Load (ETL) development using Azure data factory (ADF).
  • Advanced extensible reporting skills using Power BI.
  • Reports are creating like tabular, matrix, drill down, drill through, and cascade types.
  • Work directly with the clients on new implementations of our software platform.
  • BMS Practice Solutions client, Revflow is a web-based Physical therapy practice management platform that provide Electronic Medical Records (EMR) solutions to complement its comprehensive A/R management, Practice Management and reporting services.

APAS (ASPEN Patient Administration System)
03.2018 - 08.2020
  • Company Overview: APAS is a cloud-based application, which help the hospital in managing Patients.
  • Involved in designing the architecture for the application.
  • Involved in database design using SQL Server compact edition database.
  • Managed security on Production and Development environments.
  • Created various jobs to monitor resources on various servers and to mail the necessary information when threshold reached.
  • Installed SQL server 2005, 2008, 2012 and 2014 on a test environment to be the future production environment.
  • Upgraded legacy 2000 databases to SQL server 2008/2012/2014.
  • Involved in Database Backup and recovery.
  • Implemented high availability on the various servers using replication/mirroring/Log shipping.
  • Tuned databases for better performance.
  • Developed T- SQL Stored Procedures, Views, Functions.
  • Working in creating SSRS Reports like Inpatient/Outpatient Admission Analysis Report, Daily Admission, Equipment Usage, Choose and Book Appointment Slot, Status Reports, Healthcare Professional Appraisals, Demographics Details Reports.
  • Created SSIS packages to extract data from various heterogeneous sources like Sql Server.
  • Fetch the Data from Source files and load it to Pre-Staging, Staging, Dimension, and Fact Tables using SSIS 2012.
  • Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
  • Advanced extensible reporting skills using SQL Server Reporting Services (SSRS).
  • Reports are creating like tabular, matrix, drill down, drill through, and cascade types.
  • Custom ETL solutions using T- SQL stored schedules as job procedures.
  • Active participant of a team of database developers to support the Business Intelligence and data services needs to enterprise.
  • Work directly with the clients on new implementations of our software platform.
  • Actively engaged in design discussions for all Business Intelligence and database initiatives.
  • APAS is a cloud-based application, which help the hospital in managing Patients.

DEPREC (Depreciation & Reconciliation), GE Capital
01.2016 - 03.2018
  • Company Overview: DEPREC is the Income Tax Application System of GE Capital provides leasing, lending and access to capital solutions that help businesses of all sizes to grow and be more efficient.
  • Developed T- SQL Stored Procedures, Views, Functions.
  • Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Generated several drill down and drill through reports using SSRS.
  • Configuring and deploying SSRS Reports in Report Server and administrating the user access, scheduling reports using Subscription in Report Manager.
  • Created SSIS packages to extract data from various heterogeneous sources like Sql Server.
  • Fine Tuning and optimizing the stored procedure, function, views and T-Sql Queries.
  • Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
  • Created various Cubes, using KPI, Calculated members, Partitioning, aggregations based on Deprec database.
  • Design the Data Warehouse scope document for Deprec database.
  • Create ER-Diagram using Oracle Sql Developer from Deprec database.
  • Work directly with the clients on new implementations of our software platform.
  • Actively engaged in design discussions for all Business Intelligence and database initiatives.
  • Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
  • DEPREC is the Income Tax Application System of GE Capital provides leasing, lending and access to capital solutions that help businesses of all sizes to grow and be more efficient.

Static Loss Pool (SLP), GE Capital
08.2015 - 01.2016
  • Company Overview: The static pool-loss reserve methodology represents expected losses during the next twelve months based on the historical loss percentage and the aging of the static pool.
  • Involved in designing the architecture for the application.
  • Developing reports using SSRS as per the client requirement.
  • Involved in fixing Clients Issues.
  • Involved in database design using SQL Server compact edition database.
  • Developed T- SQL Stored Procedures, Views, Functions.
  • Support and Maintenance.
  • Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
  • Implemented the DBUnit.Net in SLP Project.
  • Configured and Tested the Jenkins MSBuild and Integrated with NUnit and DBUnit.
  • Advanced extensible reporting skills using SQL Server Reporting Services (SSRS).
  • Custom ETL solutions using T- SQL stored schedules as job procedures.
  • Active participant of a team of database developers to support the Business Intelligence and data services needs to enterprise.
  • Work directly with the clients on new implementations of our software platform.
  • Actively engaged in design discussions for all Business Intelligence and database initiatives.
  • The static pool-loss reserve methodology represents expected losses during the next twelve months based on the historical loss percentage and the aging of the static pool.

eForms (Hyperion Planning (HP), Hyperion Financial Management (HFM), Finance System), ANZ Bank
12.2014 - 08.2015
  • Company Overview: eForms system is used to populate Service Transfer Pricing (STP) revenue and expense intra-group service transactions for Forecast and Budget directly into Hyperion Financial Management and Hyperion Planning (HP).
  • Data modeling.
  • Database design and architecture;
  • Migration from MS-Access to SQL Server 2008 R2.
  • Writing Advance VBA Programming for Macros in MS Excel.
  • Responsible for producing a detailed data model of a database to contain all the necessary logical and physical design choices and physical storage parameters.
  • Creating Schema and schema objects with final physical view.
  • Writing Query, SQL, PL/SQL, Procedure, Triggers.
  • EForms system is used to populate Service Transfer Pricing (STP) revenue and expense intra-group service transactions for Forecast and Budget directly into Hyperion Financial Management and Hyperion Planning (HP).

FiRM Builder (Credit Risk Platform, Finance System), ANZ Bank
08.2014 - 12.2014
  • Company Overview: Risk reference data is important, as it is use to define the inputs for the Credit Risk Platform, which produces internal, APRA and RBNZ and market reporting, capital measurement and credit metrics calculations.
  • Data modeling.
  • Involved in complete project Life Cycle methodology (SDLC).
  • Database design and architecture;
  • Integrated the application database with data Warehouse.
  • Developed the UNIX scripts using KORN shell to automate jobs.
  • Tuned the application code using the Tkprof, Explain Plans.
  • Writing Query, SQL, PL/SQL, Procedure, Triggers & Function.
  • Risk reference data is important, as it is use to define the inputs for the Credit Risk Platform, which produces internal, APRA and RBNZ and market reporting, capital measurement and credit metrics calculations.

SSRT (Solar Site Reporting Tools), GE Infra
08.2013 - 07.2014
  • Company Overview: The business objective is to create an integrated tool, which will merge data from Solar Project Sites, thus creating one central application for site manager reporting.
  • Data modeling.
  • Database design and architecture;
  • Application design, e.g. Building application.
  • Responsible for producing a detailed data model of a database to contain all the necessary logical and physical design choices and physical storage parameters.
  • Creating Schema and schema objects with final physical view.
  • Writing Query, SQL, PL/SQL, Procedure, Triggers.
  • The business objective is to create an integrated tool, which will merge data from Solar Project Sites, thus creating one central application for site manager reporting.

Employment Portal, HDFC Bank LTD
01.2013 - 07.2013
  • Company Overview: To build an integrated solution, which can bridge the gap between the unemployed youth especially at, tier 2 and tier 3 cities and the employment opportunities at corporate/individual employer level.
  • Data modeling.
  • Database design and architecture;
  • Application design, e.g. Building application frameworks within which the other team members could work;
  • Responsible for producing a detailed data model of a database to contain all the necessary logical and physical design choices and physical storage parameters.
  • Creating Schema and schema objects with final physical view.
  • To build an integrated solution, which can bridge the gap between the unemployed youth especially at, tier 2 and tier 3 cities and the employment opportunities at corporate/individual employer level.

Corporate Card, HDFC Bank LTD
06.2011 - 01.2013
  • Company Overview: To build an integrated solution, which can bridge the gap between the unemployed youth especially at, tier 2 and tier 3 cities and the employment opportunities at corporate/individual employer level.
  • Data modeling.
  • Database design and architecture;
  • Application design, e.g. Building application frameworks within which the other team members could work;
  • Responsible for producing a detailed data model of a database to contain all the necessary logical and physical design choices and physical storage parameters.
  • Creating Schema and schema objects with final physical view.
  • To build an integrated solution, which can bridge the gap between the unemployed youth especially at, tier 2 and tier 3 cities and the employment opportunities at corporate/individual employer level.

Payment Offline System of Credit Card Business, HDFC Bank LTD
08.2010 - 05.2011
  • Company Overview: Payment Offline System should facilitate cardholders to make their outstanding payments to HDFC using different sources.
  • Responsible for installation and configuration of SQL Server 2005 database.
  • Involved in data modeling for the application and created ER diagram.
  • Database Objects like Tables, Stored Procedures, View, Triggers, Rules, Defaults, user defined data types and functions for the project.
  • Implemented database standards and naming convention for the database objects.
  • Developed SSIS packages to extract, transform and load into the Campaign database.
  • Developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables.
  • Worked with developers to tune the SQL queries using SQL Profiler.
  • Production support for the database and application issues.
  • Payment Offline System should facilitate cardholders to make their outstanding payments to HDFC using different sources.

De-Duplication, HDFC Bank LTD
07.2010 - 11.2010
  • Company Overview: De-Duplication (Duplicate Detection) is a method by which an input record will matched against a reference database to identify matching data.
  • Installation and configuration of Sql Server.
  • Queries tuning and optimization.
  • Worked with developer and develop Sql Queries and Stored Procedure.
  • DB Design.
  • Modeling with Visio, Erwin.
  • Normalization.
  • DBA activities like schema creation, access matrix, recovery, query tuning, Kill session.
  • Developer Role.
  • Implemented complex business logic.
  • Simple, easy to understand PL/SQL code.
  • Developing set of API (packages), Stored Procedure, Functions, Cursors, and SQL Queries etc.
  • All the performance related constraints take into account like Bulk collect, Use of appropriate Hints, Use of objects, Use of packages.
  • Redundant logic is globally defined (appropriate functions/procedures) under packages.
  • De-Duplication (Duplicate Detection) is a method by which an input record will matched against a reference database to identify matching data.

DBS SSS (Sales Simulation System), HDFC Bank LTD
12.2009 - 06.2010
  • Company Overview: The objective of the Sales Suitability Process is to check whether the customer risk profile matches with the relevant investment risk rating of products.
  • Involved in installation and configuration of SQL Server 2000.
  • Applied patches and services packs to keep the database at current patch level.
  • Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
  • Suggested Disk Capacity, Processors and Memory based on the Capacity Planning.
  • Implemented database standards and naming convention for the database objects.
  • Conversion the legacy systems data into MS Sql server using DTS packages.
  • Developing SQL Queries tuned the SQL queries using SQL Profiler.
  • Involved in developing stored procedures, triggers for the application.
  • Estimating of Table sizes and records sizes.
  • Maintain all the SQL documents include installation and data conversion Procedures documents.
  • Trouble shooting problems by using SQL Server Profiler.
  • Solved critical production problems and performed point in time recovery plans.
  • Interacting with the users and troubleshooting the problems involved with the development of stored procedures.
  • The objective of the Sales Suitability Process is to check whether the customer risk profile matches with the relevant investment risk rating of products.

Dedupe, DSB Bank
07.2009 - 11.2009
  • Installation and configuration of Sql Server.
  • Queries tuning and optimization.
  • Worked with developer and develop Sql Queries and Stored Procedure.
  • Involved in Collecting requirements from the Client, Analysis the Dedupe Phase-III Enhancements requirements.
  • Preparing Test Cases, Conducting Project Reviews and Analyzing the Code Developed.
  • Developed the Procedure and Function according required in Dedupe Phase-III Enhancements.

Computerized Tax System, DSB Bank
10.2007 - 07.2009
  • Company Overview: Quality Assurance of designing and featuring of US Tax forms using client software I-32 on various platforms like Oracle, SQL and PL/SQL.
  • Installation and configuration of Sql Server.
  • Queries tuning and optimization.
  • Worked with developer and develop Sql Queries and Stored Procedure.
  • Developed Data-Entry Forms for Master Tables.
  • Module Level Testing and Writing PL/SQL Code for Triggers and Stored Procedures and Report Generation.
  • Quality Assurance of designing and featuring of US Tax forms using client software I-32 on various platforms like Oracle, SQL and PL/SQL.

Education

Master of Computer Applications - Computer Science

IGNOU
New Delhi
05.2001 -

Master of Science - Electronic Science

B.R.A.B.U.
Muzaffarpur, India
05.2001 -

Skills

Development Tools: T-SQL, PL/SQL, PowerShell

Data Platforms: Azure SQL, Azure Databricks, PySpark, ADLS

Framework/Library: Microsoft Net Framework

Programming Languages: Python, SQL

Data Security: Data encryption, access control, compliance (GDPR, HIPAA)

Data Analysis: Data wrangling, data visualization, statistical analysis

Relational Databases: MS SQL Server 2018/2016/2014/2012/2008/2005

Database Administrations Tools: Sql Server Management Studio, Enterprise Manager, Sql Profiler, Control – M, Microsoft Visual Studio, Business Intelligence Development Studio

Data Model Tool: ERWIN, Visio

Database Sharding: Horizontal Sharding, Vertical Sharding, Range-Based Sharding, Hash-Based Sharding

Database Partitioning: Range, List, Hash, Composite Partitioning

Tools & Technologies: Azure Synapse Analytics, Power BI, GIT, Devops

Additional Information

2015-08 - Current

  • Associate Technical Architect

R Systems International Ltd, Noida, U.P.

2012-02 - 2015-08

  • Technical Leader

Birlasoft India Ltd, Noida, India

2007-10 - 2012-02

  • Lead Consultant

Saksoft Ltd, Noida, India

2006-01 - 2007-10

  • Software Engineer

NH Consulting, New Delhi, India

Timeline

USMED EQUIP
09.2023 - Current

BMS Practice Solutions
08.2020 - 09.2023

APAS (ASPEN Patient Administration System)
03.2018 - 08.2020

DEPREC (Depreciation & Reconciliation), GE Capital
01.2016 - 03.2018

Static Loss Pool (SLP), GE Capital
08.2015 - 01.2016

eForms (Hyperion Planning (HP), Hyperion Financial Management (HFM), Finance System), ANZ Bank
12.2014 - 08.2015

FiRM Builder (Credit Risk Platform, Finance System), ANZ Bank
08.2014 - 12.2014

SSRT (Solar Site Reporting Tools), GE Infra
08.2013 - 07.2014

Employment Portal, HDFC Bank LTD
01.2013 - 07.2013

Corporate Card, HDFC Bank LTD
06.2011 - 01.2013

Payment Offline System of Credit Card Business, HDFC Bank LTD
08.2010 - 05.2011

De-Duplication, HDFC Bank LTD
07.2010 - 11.2010

DBS SSS (Sales Simulation System), HDFC Bank LTD
12.2009 - 06.2010

Dedupe, DSB Bank
07.2009 - 11.2009

Computerized Tax System, DSB Bank
10.2007 - 07.2009

Master of Computer Applications - Computer Science

IGNOU
05.2001 -

Master of Science - Electronic Science

B.R.A.B.U.
05.2001 -

Work Preference

Work Type

Full TimePart Time

Location Preference

RemoteOn-Site

Important To Me

Work-life balanceWork from home option

Affiliations

  • Best Employee of the Year 2020

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Languages

English
Advanced (C1)
Hindi
Bilingual or Proficient (C2)
Deepak KumarAssociate Technical Architect