Sign in

Sql Server Data, ETL, Data analyst, SSIS/SSRS, SSIS developer

Charlotte, North Carolina, United States
February 26, 2018

Contact this candidate

Dr. Muthukumar Murugesan

Executive Summary

Data Analyst/Engineer and ETL specialist experience with encompassing a wide range of skill set, roles, industry verticals and specialized in Microsoft Technologies. Strong focus on research and development, unique set of skills and exposures in SDLC lifecycle process.

14 years of experience in Information Technology which comprised of analysis, design, development and enhancement in business intelligence, data warehousing and web application solutions of large & medium applications.

Strong hands on experience in various versions of MSBI tools (SSIS and SSRS), SQL Server, T-SQL and zeal to learn new tools and latest technologies.

Expertise in design and implementing ELT processes, complex business rules, dynamic packages, migration, SSIS catalog and reports.

Exceptional exposures in database design, migration, writing complex queries, T-SQL, troubleshooting, performance optimization using various versions of SQL Server.

Knowledge in C#, ASP.NET, ASP, HTML, CSS and BizTalk Server programming.

Comprehensive knowledge in business domains likes Oil and Gas, Trading and Brokerage, Insurance, Banking, Training and Asset Management.

Proficient in analyzing and translating business requirements to technical design.

Strong technical leadership capabilities with highly motivated, dedicated, quick learner and result-oriented lead with good communication and interpersonal skills.


Primary Skill Set: SSIS, SSRS, SQL Server, T-SQL, Data Quality Services, Data Warehouse, Business Intelligence, Oracle, MySQL, C#.NET

Secondary Skill Set: ASP.NET, ASP, HTML, CSS, BizTalk Server, Visual Basic, Java Script, VB Script, PERL Script, Visual FoxPro

Technical Expertise

Business Intelligence

SSIS, SSRS, Visual Studio.NET, SSDT, Report Builder


SQL Server 2016, Oracle 11g, MySQL, MS Access

Web Technologies

ASP.Net 3.5, ADO.Net, ASP3.0, HTML, CSS, XML, XSLT

Programming Languages

C# 3.0/2.0, VB6.0, FoxPro

Scripting Languages

Java Script, VB Script, T-SQL Script, Batch Script

Middleware Technologies

BizTalk Server 2010, Web Services

Version Control tools

TFS, SVN, Git Hub, VSS, Source Offsite, PVCS, SCM

Knowledge in

Entity Framework 5.0, LinQ, jQuery, Agile Scrum

Ticket Management Tools

BMC Remedy, QC10, JIRA, Peregrine 6.12, HP SM7

Workload Automation Tool

Tidal Scheduler 6.2.1, Control-M Enterprise Manger 6.4

UI Design Tools

Microsoft Expression Web, Mock Flow

Educational Qualification

Ph.D (Doctorate) in Computer Science, Karpagam University, India (2009 - 2014)

M.Phil in Computer Science, MS University, India (2002-2004)

MCA (Master of Computer Application)- Bharathidasan University, India(1997-2000)

Professional Profile

Apr’17 – Present

Domain: Oil and Gas

California Resource Corporation, Long Beach, CA

Data Analyst / ETL Lead

CRC Universe is a data warehouse application that integrates the data’s from various internal applications (Open/Closed Wells, Property Master, ODS, TOW, OSI PI) and data’s received from Department of Conservation’s (DOGGR) into centralized SQL server database. It processes Ingres and non-Ingres data’s from different zones and maintains the various status of oil, natural gas, and geothermal wells which handles by CRC.

Software Used: SSIS 2016, SQL Server 2016, SSRS, Data Quality Services, BizTalk Server 2010, Oracle 11g, Data Warehouse, Business Intelligence

Tools Used: SSDT, VS.NET 2015, Report Builder, GitHub, SQL Server Agent, Quality Center, PLSQL Developer,

Roles and Responsibilities:

Consult with customers, team members, and stakeholders to understand the business strategy, requirements and provides the technical design/solution.

Collaborate effectively with architects, modelers, data scientists, analysts and customers to maximize user experience and product quality.

Skilled in design and implementing ELT processes, complex business rules, dynamic packages, handling various data sources like SQL Server, Oracle, MS Access, Flat File, Excel using SSIS.

Proficient in design, construct, deploy the efficient and robust ETL workflows.

Expert in implementing custom components, logging, error handling, troubleshooting, analyzing performance bottlenecks, code optimization and automation in SSIS.

Skilled in data manipulation, data extraction and implementing data quality process like data validation, cleansing, profiling, mapping and transformation.

Research, develop, and manage the approaches to improve data reliability, quality, and performance.

Skilled in using T-SQL, joins, sub queries, temp tables, bulk insert, cursors, indexes, views, stored procedures, triggers, logging, functions and SQL agent/job scheduling.

Extensively worked on handling various SQL server tools like SQL Profiler, Index Tuning Advisor, SQL Server Migration Assistant (SSMA), Lite Speed and Open DBDiff.

May’16 – Apr’17

Domain: Trading and Brokerage

TD Ameritrade, New Jersey, USA

ETL Lead / Sr. Developer

Trust Enterprise Data Mart (EDM) is an integral nightly load process that loads the daily feed for trading and brokerage. This process is most critical and many of the business applications are using this database. EDM consists of two databases SQL Server (ETL) and ORACLE (applications). The entire legacy system was revamped to accommodate the source structural changes, improve the performance, eliminate the dependency with PERL Script, SQL Server and various middle layers.

Software Used: SSIS, SSRS, SQL Server 2012, Oracle 11g, PERL Script, Data Warehouse, Business Intelligence

Tools Used: SSDT, VS.NET 2012, Report Builder, Attunity, SVN, Cisco Tidal Enterprise Scheduler 6.2.1, BMC Remedy, Quality Center, Alarm Point, MoveIt, CyberArk, PLSQL Developer, Oracle SQL Developer, Software Configuration Management (SCM), JIRA

Roles and Responsibilities:

Closely worked with SMEs and business/clients to translate the business requirements into design and technical solution.

Responsible for building and managing data warehouse, data mart, data mining, dimension and fact tables and star schema.

Extensively used SSIS 2012 features like project parameters, deployment, environment variables, writing custom queries on SSIS catalog, SSIS DB reports.

Proficient in using various SSIS concepts like checkpoints, transactions, parallel execution, data taps, project template and auditing.

Involved in creating complex custom reports, dashboard, performance tuning, implementing security, scheduling and publishing reports using reporting tool SSRS.

Responsible for database design, writing complex SPs, business rules, troubleshooting, logging, query optimization and database maintenance activities.

Extensively used T-SQL scripts and stored procedures to migrate the data from various sources like MySQL, SharePoint, MS-Access, Active Directory to SQL Server.

Responsible for identifying the areas of reusable codes and implementing the innovative ideas to improve the business process and productivity.

Strong hands on experience in level3 development activities like adding new features, fixing priorities bugs and provides value added technical solutions.

May’13 - May’16

Domain: Training

Hewlett-Packard Enterprise (HPE), CA, USA

Lead / ETL Senior Developer

Online Report Engine (ORE 2.0), is an HP proprietary internal web based reporting, analytics and reporting tool which deals with entire customer support operations details under one roof. Aim of ORE 2.0 is to provide the engineers technical, career and operational information’s to leadership team to define and measure their ability. Rich interactive tool has 60+ exceptional reports based various internal applications. Various business units (Mission Critical, Pro Active Delivery, Training Excellence and etc.,) across the globe are using this tool to analyze, budgeting, planning and forecasting their business and future growth.

Software Used: SSRS, SSIS, ASP.NET, Entity Framework 5.0, Linq, jQuery, CSS, HTML, ASP, JavaScript, SQL Server 2012, VS.NET 2012

Tools Used Report Builder, SSDT, TFS, Resharper 8.1, EF Power Tool, Expression Web, MySQL Workbench 6.2, SSMA, Open DBDiff

Roles and Responsibilities:

Involved on various project related activities like predevelopment (30%), development/post development (60%), team handling/mentor (5%) and process improvement/organizational activities (5%).

Experienced in analysis, design, architecture, estimation, development and implementation of data warehouse/BI project initiatives.

Responsible on design and architecture, defining the rules and approaches involved in various levels (staging, ODS, warehouse, datamart).

Extensively used various ETL approaches to implement bulk insert, data cleansing, data transformation, business rules, schema mapping and data load to warehouse.

Skilled in work with PoC to define best practices, patterns, design, principles, task, component, techniques to optimize SSIS package performance.

Involved in development of various types of reports (Ad-hoc, parameterized, matrix, drill down, sub reports), dashboards and automate the reports using SSRS.

Responsible to identify complex manual activities/process and provide the tangible user friendly solutions to simplify and automate the business.

Jul’12 - May’13

Domain: Insurance

American International Underwriter (Chartis AIG), USA

Module Lead / Senior Developer

Credit Risk System (CRS) is used by the Chartis International Credit Risk Group and various Chartis International Business units (Surety, Trade Credit, Global Energy, Risk Finance, AIU and etc.,) in order to establish administration and managing the credit functions including development of credit policies and procedures. It also serves as a repository for credit related information. The system helps to manage International Risk Management portfolio and provides various important functionalities like:

Provides the option to create application and enables approval work flow for various role categories, like Credit Officer, Managers, Admin and etc.,

Maintains all program data for Risk Management deals.

Maintains corporate compliance data. e.g., Risk Transfer Validations and Deal Sheet and Legal documentation records.

Used for tracking the process flow and enables compliance management.

Software Used C#.NET, ASP.NET, ASP, XML, HTML, JavaScript, VBScript, CSS, SSIS, SSRS, Excel Macros, SQL Server 2008 R2 and Windows 7

Tools Used HP Quality Center 10, Visual Source Safe, PVCS, SSH Tactica, Aqua Data Studio 4.0, Cisco WebEx

Roles and Responsibilities:

Closely worked with clients, users and SME’s to gathering the requirements, involved in technical designs and development activities.

Proficient in troubleshooting, identify the bottleneck, event handler, custom logging, using various SSIS reports.

Hands-on experience in data profiling, schema mapping, package migration, trouble shooting, Extraction, Transformation, and Load (ETL) on multiple platforms.

Responsible for loading the data from various data sources to SQL Server database using SSIS.

Strong hands on experience in development activities like adding new features, fixing priorities bugs and provides value added services to simplify the business operations.

Proficient in designing frontend GUI, developing custom controls, translates the requirements into technical and creating the complex reports.

Skilled in writing and debugging complex SPs, business logic & tuning the query performance.

Skilled in requirement documents and other project related configurable items (BRD, RCL, Estimation, RT, WPR and Release Plan).

Skilled in creating design, functional, technical guide and process related documents.

Projects Handled

Client and Project JP Morgan Chase, USA

Software Used C#.NET, ASP.NET, JavaScript, Perl Script, Crystal Report, HTML, XML, SQL Server 2008

Tools Used Control-M Enterprise Manager 6.4, Tortoise SVN 1.6.4, HP Quality Center 9.2, Peregrine 6.12, Alarm Point

Roles and Responsibilities Module Lead / Senior Developer

Duration Aug 2010 – Jun 2012

Client and Project Seawell Corp, Stavanger, Norway

Software Used C#.NET, ASP.NET, Winforms, BizTalk Server 2006 R2, SQL Server 2005, VB 6.0, HTML, ASP 3.0, XML, Java Script,

Tools Used HP SM7, VSS, LogParser, BizTalk Documenter, VISIO

Roles and Responsibilities BizTalk Server Consultant

Duration Mar 2010 – Aug 2010

Client and Project JONES LANG LASALLE, USA – IPMP and JDEVerisae

Software Used BizTalkServer 2006, C#, VB.NET, ASP.NET, ASP 3.0, HTML, Java Script, Visual Basic 6.0, SQL Server

Tools Used ManageNow, SourceOffSite, LogParser, DevPartner, AviCode

Roles and Responsibilities Analysis-Design-Development-Support and Maintenance

Duration Aug 2007 – Feb 2010

Client and Project KPMG, UK - TIME2 K WORLD

Software Used C#, Win Forms, Visual Basic 6.0, ORACLE9i, VSS, DTS, MSAccess, TOAD, VISIO

Roles and Responsibilities Development-Enhancement-Bug Fix-Support and Maintenance

Duration Aug 2006 – Jul 2007

Client and Project Microsoft, USA - BAM (Billing & Account Management)

Software Used C#, ASP.NET, Echo+ Framework, WTT, Product Studio, SPK

Web, SQL Server 2000, Visual Studio .NET, Windows XP

Duration Sep 2005 – Jul 2006

Client and Project Euro RSCG, USA, - Media Tracking System

Software Used C#, Win Forms, ASP.NET, ASP, Visual Basic 6.0, Visual Foxpro, SQL Server 2000, Visual Studio .NET, Quality Center

Duration Dec 2004 – Aug 2005

Client and Project Jainsan Garments and Exports (P) Ltd, Pune - EXMAS

Software Used ASP, HTML, VB Script, Java Script, SQL Server 2000, Photoshop, Windows XP

Duration Dec 2002 – Dec 2004

Microsoft Technical Certifications

Developing Business Process and Integration Solutions using BizTalk Server 2006

Designing and Implementing Databases with Microsoft SQL Server 2000

Developing and Implementing Web Applications with Microsoft Visual C#. NET

XML Web Services and Server Components with C#. NET

Contact this candidate