Summary
Overview
Work History
Education
Skills
Timeline
Generic

NAVEEN KUMAR MURUGAN

Jersey City,NJ

Summary

Accomplished Microsoft SQL Server Database Developer with over 12 years of experience in software development and application design, specializing in advanced database management systems such as MSSQL Server, SSIS, SSAS, and SSRS. Proven expertise in crafting complex ETL packages, writing efficient stored procedures, and developing scalable data pipelines using Azure Data Factory and Azure Databricks to optimize data workflows. Strong analytical skills combined with a results-driven approach facilitate effective collaboration with business stakeholders to translate data requirements into actionable solutions. Recognized for adaptability to dynamic project needs while consistently delivering high-quality performance and impactful business intelligence outcomes, including sourcing data from SQL, JSON, and Snowflake databases using Python.

Overview

13
13
years of professional experience

Work History

MSBI Developer

Asset liability management system
11.2022 - Current
  • Developed views, stored procedures and Complex queries
  • Worked in SSIS Task as Table difference, lookup, variables, Merge and union.
  • Involved in writing SQL Functions for Calculating stocks.
  • Developed Scripts using Joins, Subquery and implementing Index
  • Real time experience in SQL Debugging, Unit Testing and Performance Tuning
  • Created Scheduler Jobs using SQL Server Agent to pull the total Stock for the period
  • Involved in writing CTE Scripts and designing databases objects
  • Worked on Python Scripts to load data from SQL server to Snowflake database
  • Good experience in T-SQL and ETL scripting, User Defined Functions and Query Optimization.
  • Environment : MSSQL-2016/2019,SSIS-2016/2019,SSAS-2016,SSRS 2017,GIT,SNOWFLAKE,PYTHON,ADF, Databricks, Azure SQL database
  • Developed and optimized ETL processes using SQL Server Integration Services (SSIS) for data extraction and transformation.

Software Engineer

HR Reporting and Analytics
05.2021 - 10.2022
  • Develop SSIS packages for fetching data from different server, in spite of any formats and columns client provide.
  • Worked in SSIS Task as Table difference, lookup, variables, Merge and union.
  • Handled performance improvement by adding index, tuning SQL joins Logic, improving statistics time/IO.
  • Analyzing the performance on the execution plans.
  • Involved in data visualization and Analytics through Qlik
  • Maintaining TFS for each deliverables post every Sprint deployment in Azure.
  • Peer reviewing the scripts and SSIS packages from the team.
  • Experience as Conditional split, Lookup transforms, Looping-over files, For-each
  • Loops, Sequence Containers, Script Tasks, Expressions, Event Handlers, Breakpoints, Variables, Bulk insert, Backup Database & Maintenance cleanup task & Record-set.
  • Performed data comparison using Fuzzy grouping, Fuzzy lookups
  • Worked on Star Schema Modeling, Snow-Flake Modeling for fact and Dimensions Tables using Analysis Services for the employee roles that are created
  • Developed Cubes using SSAS and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX)
  • JIRA Board for assigned tasks and GitHub for source maintenance
  • Generating reports using SSRS with Data source and Data set for chart controls
  • Created Tablix and Matrix report for the Fact attributes
  • Created SSRS reports using groups and drill down reports for the Roles opened and created
  • Involved in all the calls with the clients and given KT to the team members
  • Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views
  • Agile development software to report bugs and to track the status of User Stories and participated in Scrum calls every day
  • Various clustered/non-clustered indexes, triggers, check constraints and functions
  • Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation
  • Developing and optimizing Spark notebooks (Python, SQL) for data processing and analysis.
  • Building ETL/ELT processes within Databricks.
  • Integrating Databricks with ADF for end-to-end data workflows.
  • Environment : MS SQL 2016/2019, SSIS 2016/2019, SSAS 2016, SSRS 2017

Software Engineer

Subscription Management
09.2018 - 05.2021
  • Develop packages for importing data to DB, in spite of any formats and columns client provide.
  • Designed and Implemented Tables, Functions, Stored Procedures and Views.
  • Have worked on SSIS package to migrating data from all type of subscription order to our system.
  • Customizing the Stored procedures and package as per time being bespoke issues
  • Performance tuning of existing stored procedures, SQL scripts, T-SQL, Indexes, and complex queries.
  • Writing SQL stored procedures, functions and triggers to implement business rules of a product.
  • Scheduling SSIS packages in SQL Server agent and deployment SSIS using XMLA scripts
  • Analysis & implementation of better performance strategies, Scheduling the jobs in SQL Server Agent
  • Peer reviewing the scripts and SSIS packages from the team
  • Involved in usage of various SSIS components like Slowly Changing Dimension, Conditional Split, Merge, Merge Join, Multicast, Union All, Sort, Derived column, SQL execution task, Variables, and Error Handling before loading data into the Data warehouse.
  • Used various SSIS tasks such as Data Conversion, Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Created Tabular models using related Tables
  • Knowledge in writing MDX queries with members and measures, Tuples and sets
  • Environment : MS SQL 2016/2019, SSIS 2016/2019, SSAS 2016, SSRS 2017

Software Developer

Human Resource Management System
09.2016 - 09.2018
  • Wrote Stored Procedures For payroll, Workflow with all logic functions and mathematical calculation.
  • Handled logic rule using all T-SQL,SQL query like joins, function ,Index, sub query, loops, cursor
  • Handled dead lock issue and performance by tuning the query with indexes.
  • Handled DB mailer logic using SQL script for absent employees
  • Perform normalization of database.
  • Performance tuning of existing stored procedures.
  • Developed ETL Package with different Data sources (Flat file, Excel source etc) and loaded the files to SQL Server tables in data warehouse.
  • Modified SSIS ETL packages for changed business requirements to load data from different source files to SQL Server tables in data warehouse.
  • Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all, Fuzzy grouping and Fuzzy lookup
  • Wrote Procedures in Leave Management, Workflow Approval, Payroll per Base logic of Ramco Systems
  • Handled stored procedures for logic rule for Leave Entitlements, and leave carry forward logic.
  • Develop T-SQL, and complex queries
  • Using ETL Tool generated Flat file using ADO.net connection
  • Involved in Extracting the Excel and CSV,JSON files from specific source using ETL
  • Environment : SQL Server 2012, Profiler, SSIS 2012

Programmer

Tat Hong, Malaysia - ERP System
12.2015 - 09.2016
  • Developed views, stored procedures and triggers.
  • Involved in writing scripts with DDL, DML statements in MS SQL database.
  • Proficient in writing stored procedures with all SQL developing scripts like joins, function, looping, CTE, cursors, sub queries, views, T-SQL scripts
  • Used SQL Profiler and Index Tuning Wizard for tracing slow running queries and stored procedures and implemented user defined functions
  • Have Tuned the Stored procedures with proper Index & constraints and resolved the deadlock issue by deadlock graph using profiler traces.
  • Have Ability to debug the issue by statement level traces.
  • Have worked in IEDK Reports and iREPORTS.
  • Designed and developed critical screens and Reports as per Requirements of customer.
  • Have provided the core user training and gave technical support till the end of the sign off.
  • Done testing and prepared Test Case results for the Change request and released the same as per the agreed schedules.
  • Using DW developed the Reports for Customers invoices, and handled the Sp’s logics
  • Using IEDK TOOL have customized the screen as per the customers’ Requirements
  • Scheduling the stored procedures in SQL Server Agent Jobs
  • Environment : SQL Server 2008, Profiler, DW EPORTS

Programmer

Supply Chain Management
03.2013 - 12.2015
  • Developed views, stored procedures.
  • Developing Index to the Tables
  • Involved in writing SQL Functions for Calculating stocks.
  • Developed Scripts using Joins, Subquery
  • Created Scheduler Jobs using SQL Server Agent to pull the total Stock for the period
  • Involved in writing CTE Scripts and designing databases objects
  • Environment : SQL Server 2016, SSIS 2016,SSAS 2016

Education

Bachelor - Electronics and communication Engineering

Agni College of Technology
Chennai
01.2012

Skills

  • Database Technologies : SQL Server 2008/2012/2016/2019, Azure SQL Database
  • Development Languages : MS SQL, MDX, DAX queries
  • Programming Tools/Skills : SQL Programming, Python, PySpark
  • ETL Tools : SQL Server Integration Services (SSIS), Azure Data Factory(Pipelines,Data Flows, Linked Services,Integration Runtimes, Triggers)
  • Reporting Tools : Qlik Reports, SQL Server Reporting Services (SSRS)
  • Analytical Tools : Microsoft SQL Server Analysis Services (SSAS)
  • Cloud Technologies : Azure DevOps, Azure Pipelines, Azure Data Factory, Azure SQL, Azure Data Lake Storage, Azure Synapse Analytics, Databricks
  • Other Skills : Scrum, Waterfall, Control M Jobs
  • Domain Knowledge : HRMS, ERP, Subscriptions
  • Source control : TFS, Source Safe, GIT
  • Server : SQL, SSIS Server, SSAS Server, Python, Snowflake
  • Additional Tool : JIRA, Service now, Azure Data Studio, Azure Pipelines (CI/CD)

Timeline

MSBI Developer

Asset liability management system
11.2022 - Current

Software Engineer

HR Reporting and Analytics
05.2021 - 10.2022

Software Engineer

Subscription Management
09.2018 - 05.2021

Software Developer

Human Resource Management System
09.2016 - 09.2018

Programmer

Tat Hong, Malaysia - ERP System
12.2015 - 09.2016

Programmer

Supply Chain Management
03.2013 - 12.2015

Bachelor - Electronics and communication Engineering

Agni College of Technology

Similar Profiles

  • SIVUYISE NCEDO NGWANESIVUYISE NCEDO NGWANE

    Manager, Market Risk at National Treasury (Asset & Liability Management Division)Manager, Market Risk at National Treasury (Asset & Liability Management Division)

  • Brittney BuckelewBrittney Buckelew

    Payroll Coordinator at Employee Liability ManagementPayroll Coordinator at Employee Liability Management

  • Sidharth NavarkheleSidharth Navarkhele

    Assistant Manager at 360 One Wealth And Asset Management (formally Known As IIFL Wealth And Asset Management )Assistant Manager at 360 One Wealth And Asset Management (formally Known As IIFL Wealth And Asset Management )

  • Wadson SimonWadson Simon

    Nursing Assistant at Optima Care FountainNursing Assistant at Optima Care Fountain

  • Cyril BrewingtonCyril Brewington

    360 Photo Booth Operator ( Seasonal ) at Joy's 360 Photo Booth360 Photo Booth Operator ( Seasonal ) at Joy's 360 Photo Booth

CREATE PROFILE
NAVEEN KUMAR MURUGAN