Data Analyst Sql Server

SATHIANATHAN Selvaraj

SQL SEVER, Oracle Databases with MSBI –SSIS / ETL / DWH, Developer,Data Modeler, Data Mart, Testing, Integration, Migration, Informatica PowerCenter

E : **********@*****.***

M : +91-984**-*****

India, Tamil Nadu, Chennai

Passport

Valid Upto : 06/06/2033

Issue @ : India, Chennai

Onsite Experience

Citi Bank - BAHRAIN

(2010 – 2011)

Proven - Arabian Company

RIYADH, Saudi Arabia

(Jan ‘ 2019 – Apr ‘2019)

National Bank of Oman –

NBO, MUSCAT, Oman

(Aug‘ 2019 – Oct ‘2019)

IT FORTE

DOS, LAN,Unix

Windows NT/2003

MS SQL Server 2016/2008/2000

SSIS,SSRS,SSAS (BI / ETL)

Oracle, Sybase, MySQL

SAP HANA-BODS/BI 4.0

Erwin Data Modeler Tool 9.x

Power BI,

Tableau 9.x

Informatica Power Center

Sql Compare Tool

SQL Lite Speed

Eclipse,

TOAD

ER Studio,Biztools

IIS,

Crystal Report

Visual Basic,VisualFoxpro

Interactive SQL 11.0

Event Control Server 5.5

PC Anywhere 10.5

Install Shield

Biztools, ER Studio 7.5,

Farpoint Spread Control

Web Sphere Application Server Ver.5

TFS (Team Foundation Server)

Visual Paradigm Standard Tool

(DWH – Designed)

Career Summary:

I have over Sixteen years of IT experience, with nine years specializing in Production, Staging, and Development Environments. I focus on managing Enterprise Edition MS SQL Server databases from versions 2000 to 2016. My expertise includes using MSBI ETL tools like SSIS for Data Warehouse management, Database Administration, Data Modeling, Analysis, Cleansing, Designing, Testing, Data Mapping, End-to-End Implementation, Business Intelligence, and OLTP/OLAP processes. I am also proficient in Informatica PowerCenter ETL Tool.

I have moderate experience with ERWIN Data Modeler and possess strong expertise in database-related tasks including data normalization, job monitoring, and task scheduling. My skills extend to SQL profiling using SQL Trace, as well as query optimization and performance tuning through tools such as the Database Engine Tuning Advisor (DTA). I am proficient in analyzing query execution plans, implementing effective indexing strategies, and working with Microsoft Message Queuing (MSMQ). Additionally, I have a strong command of T-SQL programming for developing and optimizing database solutions.

My experience also includes physical and logical database design, patch releases, and deployment using both Agile and Waterfall methodologies. I have knowledge of Data Lakes, SQL Azure cloud services, and Big Data Management (BDM). Additionally, I have some hands-on experience with Informatica IICS (Intelligent Cloud Services) for development purposes

Worked with databases including SQL Server, Oracle, Sybase, MySQL, SAP HANA, MS Access,

PostgreSQL, and Greenplum DB

I have moderate experience in development using SAP HANA–BI /BODS 4.0 Design Studio.

Over 6 years of experience in Oracle database activities, including creating database objects, PL/SQL development, data Analysis, database design, migration, SQL*Loader scripts, and working with views, constraints, indexes, stored procedures, functions, packages, and triggers

1 year of experience in Sybase T-SQL and MySQL T-SQL programming, along with website configuration using IIS

Specialized in using Crystal Report Designer across various projects.

Academics :

Masters of Sciences in Information Technology from Alagappa University – Karaikudi, India, Dec’2008

Diploma in Java Programming from Loyola Institute of Business Administration, India, Dec’2000

Diploma In Oracle from Software Solution Integrated Limited, India, Feb’1995

Bachelor of Economics from University of Madras, Jun’1991

Overseas Experience ( Bahrain, Saudi Arabia, Oman ) :

I have over 3 years of experience working on the Citi Bank project in Chennai, including 1 year of onsite experience with the Citi Bank project in Bahrain

I worked for 4 months at PROVEN, a Saudi Arabian company, on a visa processing project for TAMKEEN Technologies, a semi-government client

I spent three months at AL-RWAJH AL-ALMYT LLC (a subsidiary of Software Systems LLC) in Muscat, Oman, working on various BI projects for the client NBO – National Bank of Oman. My role involved designing data marts in Oracle and SQL Server databases, integrating SAP tables

SAP – HANA / BODS ( Data Transformation only) :

Utilized Attribute Views, Analytical Views, and Calculated Views for handling data.

Created ETL jobs using BODS and also specialized in Crystal Reports Designer

Involved in using SLT and SDA to extract structured and unstructured data from various source systems

into the HANA database

Loaded data from SAP ECC (ERP Central Component) to SAP HANA using SAP BODS.

Expert in SQL scripting, creating functions and procedures, table design, and data loading processes

Extracted data from the MS SQL Server database into the SAP HANA database using BODS

Analyzed the existing queries for real time reporting requirements

Core Competencies:

Team Collaboration, Training and Development, Decision-Making, Work Standards, Load Testing, Problem Solving

and Solutioning, Database Design, Reporting, Data Migration, Upgrades, Optimization

Domain:

Healthcare,Insurance,Hospitality,Citi Bank – Bahrain,Retirement System,Textiles,Material (ERP) System,Maintenance System,Material Catalogue,Payroll & Finance,VISA Processing – Riyadh, Saudi Arabia, National Bank of Oman – Muscat, Oman,Telecommunication-Batelco, Bahrain

Period & Projects

Feb’2024 – Present

Jul’2022 – Nov’2023

Aug’2021 – Jun’2022

Jul’2020 – Jul’2021

Aug’2019 – Oct’2019

Bank - Finance

Jan’2019 – Apr’2019

Visa Processing

Apr’2017 – Mar’2018

& Aug’2018 – Dec’2018

Apr’2018 – Jun’2018

Health Care

Jul ‘2016 – Mar ‘2017

Insurance

Work Experience

Freelance

My responsibilities included ETL development, data migration, and database support tasks such as job monitoring, normalizing existing databases, optimizing SQL Server queries, and assisting with SQL queries used in Power BI reports

ETL & Data Consultant, Million I Technology Pvt Ltd

Project : Product based Design & Manufactures Machinery Items, Client : Armstrong Fluid Technology – Canada, Toronto-Ontario

Involves in SQL Server ETL processes for transforming data, including migration from Excel to SQL Server, server-to-server transfers, adaptation of existing stored procedures to align with user business needs. Also Involves Informatica ETL Tool to transform data seamlessly across various sources such as Oracle, Excel, XML, and other databases, while also overseeing the routine execution of production jobs.

Managed databases across platforms, including SQL Server, MSBI (SSIS), and Oracle (PL/SQL).

Managed and upheld existing Databases and Indexes, Normalization of SQL query

Created user logins and assigned appropriate database access permissions.

Involved in Data Modeling and created Fact & Dimension Tables with relationship based on key columns

Created user related business requirements for Store Procedures,, Views and Function

Diagnosed and Resolved data-related and other backend issues

Provided support and contributed to Power BI services and data table management

Utilized Informatica ETL to transfer data between servers and transform XML files using XSD into structured data formats.

Used Cisco AnyConnect Secure Mobility Client for Remote Server Database Access

ETL & Informatica Consultant, Saffron Technosolutions Private Limited

(Parent - Kroma Tehnologies LLC, Dubai - United Arab Emirates)

Project : Telecommunication Client : BATELCO, Bahrain (Bahrain Telecommunication Company )

Worked with Informatica PowerCenter 10.4 to build ETL processes.

Used tools like Mapping Designer, Workflow Manager, and Monitor to create tasks, sessions, and manage data workflows.

Focused on maintaining data quality during data transfers.

Created Deployment Groups, Packages, Worklets, and used parameter files to pass values at runtime.

Worked with different data sources such as CSV/Text files, XML, and data from SOAP/REST APIs.

Wrote SQL scripts to transform data and set up automated jobs to load multiple files from BICC (Oracle Cloud - SaaS) into target tables.

Used WinSCP to connect to shared folders and move files for processing in Informatica.

Freelance

Involved in Erwin Data Model for data integration in ETL/BI spanning SQL Server and Oracle Databases. Facilitated the development and deployment of dashboard reports, contributed to the creation and modification of tables, stored procedures, views, and participated in database normalization, SQL queries, and data integration. Utilized the Informatica PowerCenter ETL tool for these tasks, with a focus on Postgresql – Greenplum DB

Technical ETL /BI Consultant, AL-RWAJH AL-ALMYT LLC (Parent: Software Systems LLC) Muscat, Oman

Project : ETL & Data Mart Client : NBO (National Bank of Oman)

Handled Databases : SQL Server, SAP HANA, Oracle

Created and Designed Data Mart mapping for Fact and Dimensional tables relationship in Oracle

Created PL/SQL Stored Procedures, Functions and Packages for moving the Data Transformation from Source Staging area to data mart Target System

Managed Database Tables procedures and Indexes

Used Remote Server Database Access for Data Mart ETL job

Facilitated discussions with users to define business requirements, subsequently designing Data Mart mappings involving Oracle, SQL Server, and SAP table integration

Prepared comprehensive documentation that included details on Packages, Procedures, Functions, Mapping tables and columns, and the involved Servers

Environment: Windows Server 2012, SAP, SQL Server 2016, Oracle, Oracle SQL Developer Tool, Informatica PowerCenter

Technical DWH - ETL/BI Consultant, PROVEN Arabian Company - Riyadh, Saudi Arabia

Project : Visa Processing Client : Tamkeen Technologies

Applications : Musaned, Ajeer, MOL

Handled Databases including, MySQL, SQL Server -MSBI – SSIS, SSAS

Created and Designed, Tested Data Warehouse for which is Fact and Dimensional tables relationship mapping

Created / Designed & Tested New ETL multiple packages for Data Transformation from Source to Target DWH System

Involved on logical and physical data base modeling with ERWIN tool

Important transaction data was transferred from SQL Server to the SAP HANA database using BODS

Involved Oracle PL/SQL and Created new Packages & Procedure in Oracle for Data Transformation from Source to Target System

I was somewhat involved in crafting Power BI reports.

Managed Database Tables procedures, Indexes for Normalization and Scheduled Jobs

Designed ETL flows to extract data from MySQL Database and Stored in MS SQL Server Database – DWH

Create Message Queue, Contract and Service Broker used on the Database and also used message Task in SSIS

Used VPN Connection for Remote Server Database Access

Used TFS for maintaining Version Control of ETL packages

Environment: Windows Server 2012, SAP HANA, MySQL, Oracle,SQL Azure Cloud Server,SQL Server 2016 – SSIS,, SSAS, Power BI, TFS, Talend, Visual Paradigm, Erwin Data Modeler

Freelance

Involved in Erwin Data modeling, Database Design, Normalization, Query optimization, MSBI/ETL/Data warehouse SSIS, Oracle, Build & Deployment of Dashboard Reports, Data Visualization in Power Bi, Tableau Tool

Technical Lead – ETL /BI/DBA, WIPRO – Chennai (Parent: Jconnect Infotech Pvt Ltd)

Project: Health Care Client: UnitingCare Queensland, Australia

UnitingCare Queensland delivers health and community services to thousands of individuals every day through its key service groups: UnitingCare Community, UnitingCare Health, Blue Care, and ARRCS (Australian Regional and Remote Community Services). Blue Care is one of Australia’s leading not-for-profit providers of residential aged care, community care, and retirement living, with operations in over 260 centres across 80 communities in Queensland and northern New South Wales

Handled SQL Server databases and implemented BI solutions using MSBI (SSIS, SSRS, SSAS) and Informatica PowerCenter

for ETL processes

Monitored database mirroring, disk space usage, scheduled jobs, alert emails, and other production server issues

Expert in data transformation using BCP, Bulk Load, and Bulk Insert operations, with extensive experience in

SSIS-based ETL processes, MSBI, Data Quality Services (DQS), and data cleansing

Created logical and physical database models using ERwin Data Modeler and deployed them to the corresponding databases

Used Citrix Server for login Remote Server Access

Managed multiple databases and environments across 20 servers

Handled ServiceNow ITIL Ticketing System, including Incident, Service Request, and Release Management processes

Granted user access to the Procura application upon receiving approval from a supervisor

Developed SQL, PL/SQL, and SQL Plus programs to retrieve data, incorporating cursors and exception handling

I played a modest role in modifying Power BI reports.

Utilized Informatica ETL processes for data transfer from servers to database instances and maintained existing ETL workflows

Message Queue Task used in SSIS

Created various T-SQL scripts based on business requirements and exported the results to Excel format.

Environment: Windows Server 2012, SQL Server 2016 / 2012 – SSIS,SSRS,SSAS, SQL Profiler, Oracle, Power BI, Talend, Procura, Citrix Server, Informatica Power Center, .Net

Technical Lead - ETL /BI/DBA, FUTURE FOCUS InfoTech Pvt Ltd, Chennai

Project: CBMS (Client Benefits Management System) – Insurance, Client: Keenan Associates, California

The Client Benefit Management system is developed to cater the needs of group Insurance Brokers, Insurance Providers, Employers and Employees. Employers who need to manage their Employees Insurance Policies & Rules are always looking out for ways and means to simplify the tedious task of maintaining huge amount of data. Employees need to setup their insurance within their company defined rules and regulations.

Handled Databases SQL Server/ Oracle/ SAP HANA

Contributed to ETL development with Informatica PowerCenter, Enterprise Data Warehousing, data analysis, data modeling, and architecture, along with MS BI tools such as SSIS, SSRS, and SSAS

Developed interactive Power BI dashboards using visualizations such as Table, Matrix, Bar, Card, Gauge, and Slicers

Developed complex SQL queries based on business requirements using stored procedures, functions, views, and Common Table Expressions (CTEs)

Supported the creation of dashboards and visualizations in Tableau Desktop using data blending

Configured a linked server in SQL Server to connect with the SAP HANA database schema and retrieved object details

Created and tested Attribute Views, Analytical Views, and Calculated Views in SAP HANA, and also contributed to ETL processes using BODS

Developed scripts to create new tables, views, and queries for application enhancements using Oracle TOAD

Executed DDL and DML commands, carried out code reviews, and tested code following insurance application standards

Performed database constraint checks to identify tables missing primary key and foreign key relationships

Participated in project-related discussions with the QA and Development teams

Environment: Windows Server 2008, MS SQL Server 2012 / 2008R2 – SSIS,SSRS,SSAS, SQL Azure Cloud Service, SQL Profiler, Dot Net, SQL Compare Tool, Crystal Report, SAP - HANA 1.0 /BODS 4.0, Informatica Power Center, Power BI, Tableau, Talend, Toad

Apr ‘2014 – Jun ‘2015

Hospitality

Apr‘2010 - Nov’2013

CITI Bank, Bahrain

Oct‘2005 - Apr’2010

Sr.Software Lead – ETL /BI/DBA, CROTUS TECHNOLOGIES, Chennai

Project: Petchey Leisure – Hospitality Client: Portugal & Spain

Petchey Leisure’s Club Infiniti is designed to offer flexibility and the freedom to enjoy holidays that suit your lifestyle. It provides a lifetime of enriching holiday experiences that inspire, excite, and broaden your horizons. With Club Infiniti, members can choose the size and type of accommodation that best fits their needs and enjoy the flexibility of taking multiple holidays throughout the year.

Involved in working with databases such as SQL Server, Oracle, and MySQL, along with data modeling and MSBI for ETL and data warehousing.

Executed database refresh operations by restoring production data to development and staging servers for testing and validation purposes.

Involved in testing, installation, configuration, and deployment of SSRS reports using a scale-out topology.

Scripted OLAP database backups and scheduled daily backups using SQL Server Agent jobs.

Designed and tested ETL packages, mappings, and scripts for multiple resort data integrations.

Involved in MSBI development and testing, and performed SQL Server database object imports across different databases and instances.

Published reports and dashboards using Power BI

Experienced in developing dashboard reports, parameterized reports, linked reports, and sub-reports segmented by region, year, quarter, month, and week.

Performed PL/SQL and T-SQL operations on development and production databases across 20 servers and multiple environments.

Implemented and released database changes within agreed timelines and budget

Environment: Windows Server 2008, MS SQL Server 2012 / 2008 – SSRS, SSIS, SQL Profiler, ORACLE, MySQL, Toad, SQL Loader, Dot Net. Crystal Report, SQL Compare, Power BI, Toad

Senior Technical Lead – ETL /BI/DBA, POLARIS FINANCIAL TECHNOLOGY Limited, Chennai

Project: FXLM – (Functional Exchange Local Markets) Client: Citi Bank, Bahrain

FXLMconnect is Citi’s new internal web-based information portal that consolidates position and business reporting for the FXLM division. It centralizes all MIS and P&L reports that were previously spread across separate Citi portals—FXCentral, FXEye, and Citi Treasury—into a single, unified access point.

Involved Databases : MS SQL Server and Oracle, Sybase

Supported DBA and development activities for MS SQL Server (ETL/DW), Oracle, and Sybase

Managed effective Change Management processes for a 500 GB database across Test, Development, and Production environments

Utilized Oracle SQL*Loader to import data from external files into the Oracle Database.

Involved in troubleshooting and resolving issues related to database migration, performance tuning, index analysis, and both the enhancement of existing and development of new T-SQL stored procedures, views, functions, triggers, and packages

Developed SSIS packages in SQL Server 2005 and performed conversion of DTS packages to SSIS in SQL Server 2008

Created parameterized, drill-down, and drill-through reports using SQL Server Reporting Services (SSRS)

Resolved complex issues and implemented robust error handling in SSIS packages

Handled on MSBI Development and Data Export from MS SQL Server Databases into other Databases/Instances

Served as the single point of contact between the team and the onsite client coordinator

Environment: Windows Server 2003, UNIX, Java, MS SQL Server 2008 / 2005 – SSIS,SSRS,SSAS, Sybase, Oracle, SQL Loader, Toad, Eclipse, SQL Litespeed, Crystal Report, Toad

Senior Engineer – DBA / ETL, COMPUTER SCIENCE CORPORATION India Private Limited, MEPZ, Chennai

Esurance :

The system developed by Esurance is specific to automobile insurance based on the compliances of all the states in America. The system helps in creation of new policy, endorsement of an existing policy, cancellation of an existing policy and renewal of the policy. The system also helps the customer to collect their SRF (State Required Forms) acceptance through online.

Jclarety ( Public Employees Retirement Association ) :

Public Employees Retirement Association (PERA) is a New Mexico (NM) & Michigan State Government agency. It is basically a retirement system. Over 600 state and local government agencies provide pension benefits to their employees through PERA. There are five major funds governed by PERA, like Legislative, Magistrate, Volunteer Firefighters, education and public

GAP:

The Gap is a specialty retailer, which operates stores selling Casual / Fashion apparel for men, women and children under five brand names like GAP, GAPKIDS, BABYGAP, BANANA REPUBLIC and OLD NAVY Clothing Co. GAP has outlets throughout the United States, Canada, United Kingdom, France, Germany and Japan. COVANSYS is responsible for the Maintenance and Enhancement of IT operations of GAP

May’1997- Oct’2005

Material System - MAVERIC

Maintenance System -

IMPACT

Material Catalogue – CDK

Clients

IMPACT :

Nuclear Power Corporation of India Ltd, Kaiga, India

CDK:

IOCL -Indian Oil Corporation Limited, Delhi, B R P L - Bongaigaon Refinery & Petroleum Limited, Assam

(A Group of IOCL)

CSM MAVERICS:

Aberdeen, UK,

City Investing Company Ltd, Quito, Ecuador, British Borneo, Houston, Azerbaijan International Operating Company - Baku

I have installed & implemented Material & Maintenance product in the below clients place in India

Clients

MAVERIC:

Proctor & Gamble

Bharat Shell

GNFC - Gujarat Narmada Valley Fertilizers & Chemicals Limited

Vikram ISPAT

Bell Granito Ceramica Ltd

Electrosteel Castings Ltd

Involved in Databases SQL Server/Oracle

Planning and Maintaining Database Backups using Scheduled Jobs, Alerts and SQL Mail.

Change Management across different Test, Development and Production Databases

Creating of Login and restricting the permissions to them

Handling of more than 30 tickets daily basis of development and QA team request on different Databases and different environments across 1500 SQL Servers Instances

Production Server - Monitoring Jobs & Scheduled Task

Developed DTS/SSIS packages to import and export data between text files, Excel files, and server-to-server transfers

Developed complex stored procedures, triggers, and user-defined functions using joins and cursors

Analyzed user requirements, functional and technical specifications, and prepared comprehensive test plans

Performed build and deployment using batch files and handled web application server hosting

Initiated Oracle database triggers through FTP-based file transfers

Involved Migration, Performance Tuning, Analyzing Indexes, Store Procedures,Views and User defined Functions

Code review as per client defined coding standards and guidelines

Environment: Windows 2003, Unix, IBM WSAD5.0, Sql Server 2000 / 2005 - SSIS, Oracle, Toad, ECS (Event Controller Server) for Batch operations, PCAnywhere, PVCS Merant Tracker for Bug tracking, Perforce - Version Control Tool, WebSphere Application Server Ver. 5, Biztools, ER Studio 7.5, Atomate 5.5

Analyst Programmer, HOFINSOFT TECHNOLIGES Private Limited, Chennai

Maintenance System – IMPACT (Integrated Maintenance Planning and Condition monitoring Trend)

As a part of my duties, Team lead for Design and Development of complete Reports Module of Maintenance System and installed software at Kaiga, one of the site of Nuclear Power Corporation of India Ltd., successfully ported existing data from MS Access into SQL Server database using DTS wizard. Creating users and assigning permission is depending on the group. And given training to their IT department to take Backup on daily basis and restoration of database from backups.

CDK - Catalogue Development Kit

CDK – Catalog Development Kit is a materials catalog specifically developed to suit the current global scenario with Standardized codifying methodology. CDK is a world-class, fast track deployment software tool for materials catalog development and its maintenance. CDK can be used while cataloguing items for a new facility or an existing facility. CDK was successfully implemented at BRPL to query the data based on the database received from IOCL - Delhi.

CSM Maveric - (Consolidated Supply Management)

This package caters to Inventory Operations of Oil Exploration Industry. Here we have warehouses geographically scattered. There is a central warehouse located on the shore, where major procurement activities take place and the materials received are distributed to the other warehouses. The end use requirements are taken care by Local warehouses and requirements of the local warehouses are taken care by Central Warehouse. The material in transit is monitored and controlled by the system

MAVERIC - (Material Administration Vendor Evaluation Rating and Inventory Control)

MAVERIC is spare parts management software. It takes care of basic functions of inventory operation like Purchase Indenting, raising Enquiries, processing Quotations, making Purchase Orders, Inspection, Receipts, Material issues and generates related MIS & Reports.

Databases : MS SQL Server, Oracle and Visual FoxPro

Hands on Experience in Programmer, Database Developer, Data Analyst, Administrator Activities & Team Lead

Migrating Oracle database into MS SQL Server database. This includes conversion of existing Tables, Views, T-SQL Store Procedures, Triggers and PL/SQL, Packages

Import & Export Data Loading through DTS

Designed various GUI based Complicated Seagate Crystal reports (Cross Tab Reports, Sub reports, Dynamic reports Creation)

Web site Configuration of Internet Information Server (IIS)

Converted existing Oracle reports to Seagate Crystal Reports

Customizing the software at site according to user requirements and Preparation of Unit Test Plan

Implemented the software application and provided user training onsite at the client’s location

Environment: Windows NT/2000, MS SQL Server 7.0, Oracle, Toad, Seagate Crystal Report 7, Oracle 9i, ASP, HTML, IIS, Toad, Visual Foxpro 5.0, FarPoint Spread 3.0

Contact this candidate