Chandan kumar

SQL server Architect | Lead developer with 13 years of experience 

Philips Designation: Sr. Database specialist (Architect Level) 21st Aug 2024 - till date
Bangalore
Technology : SQL Server 2017, 2019 on On-premise, RDS, Managed & Amazon Cloud SQL & MySQL
Project details : Healthcare Equipment and Software to maintain Heart health monitoring

SQL Server Database code development, impact analysis and deployment

Monitoring tool suggestion , DB Infra review and ensuring best practices are met

Team leading, collaborating with teams, guiding team on DB related information

Performance Tuning - Query Tunning, Database migration
General Electric Designation: Sr. Staff Engineer (Sr. Tech Lead) 5st Oct 2020 – 19th Aug 2024
Bangalore
Technology : SQL Server 2014, 2017, 2019 on On-premise, RDS, Managed & Amazon Cloud SQL & Azure Platform
Project details : Healthcare Equipment and Software to maintain image processing related

SQL Server Always On – POC, Troubleshooting

RDS SQL Development , management and POC to reduce cost

Performance Tuning - Query Tunning, Implementing Table Partitioning & Indexes

T-SQL Development, SQL Queries, Stored Proc, Function development

DBA Activities – Backup Restore, SQL Server monitoring, finding bottleneck and root-cause

Implementing Monitoring product and help in resolving issues with 80% faster than earlier.

SQL Server maintenance routines, such as backups Index and Statistics maintenance and strategy

Working on SQL Server to Postgres technology Migration

Architecting DB related developments & Activities , Mentoring Juniors and Leading team

Handling Datawarehouse SQL Query in SQL Server , Datawarehouse db design, management, performance Monitoring and performance Tuning

Dimension and Fact table development in Datawarehouse
Teksystem (Flipkart) Designation: Database Lead 5th Mar 2019 – 1st Oct 2020
Bangalore
Technology : SQL Server , SSRS , Hive, C#, Omniture
Description : Data Quality check between 2 data source for DQ Project
Clients : Flipkart

Architecting and Developing an automation product to compare analyze Omniture VS Flipkart data

Design and development Database, SSRS report

T-SQL programming development, SQL Query, Views, stored procedure, function in SQL Server

Pulling data from Hadoop using hive

Processing file from email attachment to database server using my own code written in C#

Database migration, Back up, Restore

Performance improvement of SP / Function & SQL queries

Using tools like Execution plan, SQL profiler, Tuning Advisor

Developing stored procedure, function, views, query, Indexes, Trigger
American reprographic company Designation: Sr. Software Engineer 4th Aug 2013 - 5th Jun 2018
Salt lake, Kolkata
Project name : Abacus
Team Size : 11
Database : MS SQL 2008 R2/2012/2014/2017 server
Soft. Tools : MS SQL 2008 R2/ 2012 server, MySQL, Postgres, SQLite, Red gate SQL compare, Erwin
Description : This project is under development, Abacus project is a kind of application that provide solution for printing documents and tracking solution. Here we maintain and monitor prints of document made by user on particular printing machine and capture them under particular project or its sub phases.
Role :

Data Modelling using Erwin data modeler and T-SQL programming development in SQL Server

Evaluation on features & Development on RDBMS software in MySQL, Postgres, SQL Lite, SQL2014, 2016

Suggestion on data Flow / architecture on given requirement

Database Design using Erwin, Database migration, Back up, Restore

Developing stored procedure, function, views, query, Indexes, and involved in several performance tuning.

Conducting interviews, Guiding juniors
Indecomm Global service Designation: Sr. Software Engineer 13th Aug 2012-8th Mar 2013
MG Road, Bangalore
#1 . comscore client
Project name : Orange
Team Size : 6
Database : MS SQL 2008 R2 server, vertica , SSIS
Soft. Tools : MS SQL 2008 R2 server, Toad for Data Analyst, SSIS
Description : This project is under support in Indecomm , Orange is a telecomm company and the dashboard included in this project provides the management to analyze on various part like the most tariff plan used, data consumptions by users , devices, OS etc.
Role :

Support on resolving the bugs.

Developing reports in SSRS and writing T-SQL Codes.
Schneider-Electric Designation: Senior Engineer 22nd Nov 2010 – 30th Jul 2012
White- field, Bangalore
#1 . Schneider-Electric (Denmark Business Partner)
Project name : Efficient Home
Duration : Jan ’2011 to till now
Team Size : 3
Database : MS SQL 2008 R2 server
Soft. Tools : MS SQL 2008 R2 server, Toad for SQL server, Red Gate Tools, SSRS, SSIS
Description : This project is under development to track and getting status of power consumption by Home/ Industries/ Hotels etc . This project helps people to realize the amount of power consumed by them and help them with to save
power with our Home controller devices. Users are given choice to control their power consumption over smart phones and on web portal. Google power-meter is one of utilities chosen to show power used in home on minute/hour/day/weekly/monthly/Yearly basis.
My Role : Database programming, editing database, Design Data-warehouse OLAP.

Analyzing requirements and Designing database.

Development of ETL package to move and refine data to Reporting database from Operational database.

Development of Stored procedure /Functions /Views.

Designed OLAP cubes and Dimension for analyzing power consumption on periodical and country wise.

Performs administrative tasks including backup, recovery, and Tuning database and Query.

Script synchronization across servers.

Developing elegant Reports in SSRS (including Chart), develop & deploy reports in SQL report server and managing and proving security through report manager.

Migrating database from one instance to another, keeping development, test and production server in synch state.

Mentoring / support to junior engineers.

Achieved 70% higher speed on read/write over database/ application operation by modifying current method to enhanced method.

Responsibility of creating “Proof of concept” (POC) programs for new projects to ensure technology meets business requirement effectively & efficiently.

Creating package/script in SSIS to transfer data to remote location.

Database optimization and query optimization.
Trigent Software Ltd Designation: Database Administrator 04th Jan 2010 – 18th Nov 2010
Race Course Road, Bangalore
#1 . Honeywell Technology Solution (Client)
Project name : Archival_Database_DBA_Support
Duration : 4th Jan’2010-18th Nov’2010
Team Size : 22
Database : oracle 8i, 9i, 10g, MS SQL 6.5,2000,2005, 2008 server, MS Access
Soft. Tools : Embarcadero ER Studio 7.5, Toad, SSIS, SVN
Description : projects involve interaction with migration of database and designing database from legacy database (SQL 6.5), oracle 8i to oracle 10g server for reporting and analysis purpose.
My Role : Database programming & editing database design, PL-SQL Coding.

Analyzing and Designing database, Tables in oracle 10g with compatible to data present in legacy database.

Creating package/script in SSIS or SQL LODER to transfer huge data to remote location.

Developed PL-SQL code to generate SQL Loader control file (Script) automatically to load data and contributed to productivity.

Creating link from SQL server to Oracle, MS Access to synchronize database.

Reverse Engineering, Synchronizing SQL server / Oracle database schema with ER studio.

Conducted SQL Server optimization for queries and procedure, achieved a 60%-80% decrease in processing time.

Development of Stored procedure containing transactions that retrieve accurate & right data dynamically for reporting or database updating purpose.

Guiding front end junior developer about T-SQL, procedure and database logic. SQL Server Integration Service (ETL Projects): Bulk Load Project: developing an automated integration project that takes data from different source format such as from text file or access DB or Excel file and loads into SQL server database.

Performs administrative tasks including backup, recovery, load analysis of web and database servers.

Performance and Tuning:
a.
Indexing: Analyzing & Implement index on right column for faster accessing of data in the database.
b.
SQL server profiler: Using this tool to identify to detect dead lock and time consumption of the query.
c.
Query optimization: to avoid overload on the database server, decide which function to avoid and write an optimized query to be executed at minimal time.

MCA (Master in Computer Application)
Punjab Technical University in 2009,
Secured 72.6 %
Microsoft Certified Professional
Microsoft Windows XP installation & conf. (70-270), Since 2007
BSC (Biotechnology)
Bangalore University in 2005, secured 59.7 %
Intermediate (Science)
Bihar Board in 2001, secured 61.3 %