SATHIANATHAN Selvaraj

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

E : ad45xa@r.postjobfree.com

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 more than fifteen years of experience in IT, with nine years focused on working in Production, Staging, and Development Environments. I specialize in managing Enterprise Edition MS SQL Server databases from versions 2016 to 2000. I'm skilled in using MSBI ETL tools like SSIS for tasks such as Data Warehouse management, Database Administration, Data Modeling, Analysis, Cleansing, Designing, Testing, Data Mapping, End-to-End Implementation, Business Intelligence, and OLTP and OLAP processes, including Informatica PowerCenter ETL Tool.

Moreover, I am somewhat familiar with ERWIN Data Modeler and have gained a bit of experience using it. I am skilled in various tasks including Normalization, Monitoring Jobs, Scheduling Tasks, SQL Profiling (Trace), SQL Query Optimization, Performance and Database Engine Tuning Advisor (DTA), Analyzing Query Execution Plans, Indexing, and Message Queues (MSMQ). Additionally, I specialize in T-SQL Programming.

Additionally, I have experience in Physical and Logical design, Patch Release, and Deployment using Agile / Water Fall methodology. I have knowledge and a bit of experience in using SQL Azure Cloud Service and Informatica – IICS (Intelligent Cloud Services) & Informatica - BDM (Big Data Management) for development purposes.

Involved Database on SQL Server, Oracle, Sybase,MySQL, SAP Hana DB, MS-Access, PostgreSql, GreenPlumDB

Over 3+ years experience in SAP HANA–BI / BODS 4.0 & BO Design Studio on Development

Over 6+ years of experience as an ORACLE activities & Creating Database objects, PL/SQL and Data Analysis, Database Design, Migration, SQL Loader Script, Views, Constraints, Index, Stored Procedures, Functions, Packages and Triggers.

1 year experience in SYBASE T-SQL, MySql T-SQL Programs, Web site Configuration of IIS

Specialist in Crystal Report Designer in different 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 worked more than 3 years in Citi Bank project-Chennai out of which one year in Bahrain-Citi Bank Project

I have worked 4 months in PROVEN - Saudi Arabia (Arabian Company) for Visa Processing project and the client is TAMKEEN Technologies - Semi Govt.

I spent three months working at AL-RWAJH AL-ALMYT LLC (Parent: Software Systems LLC) in Muscat, Oman and client is NBO- National Bank of Oman on various BI projects, where I designed Data Marts in Oracle and SQL Server databases, incorporating SAP Tables.

SAP – HANA / BODS ( Data Transformation only) :

Used Attribute View, Analytical view and Calculated view

Created ETL Jobs in BODS and Specialist in Crystal Reports Designer

Involved on SLT & SDA – Extraction Structure/Unstructured Data from Different Source Systems into HANA DB

Load Data from SAP ECC (ERP Central Component) to SAP HANA using SAP BODS

Expert in SQL Script, Function, Procedure Calls, Designing tables and Data loads

Extract the data from MS SQL Server Database into HANA Database using BODS

Analyzed the existing queries for real time reporting requirements

Knowledge and Intermediate level experience in SAP Information Steward data quality improve tool

Core Competencies:

Team Work,Training and Development,Decision Making,Work Standards,Testing – Load,Problem Solving Solutioning,Database Designing,Reporting,Migration,Upgrading,Optimization

Domain:

Health Care,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

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

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, including SQL Server, MSBI (SSIS), and Oracle (PL/SQL)

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

Created User login and granted access to designated databases

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

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

Fixed the Data issues & other Backend related issues.

Involved and provided support for Power BI Services & Tables

Engaged in utilizing Informatica ETL for transmitting data between servers and converting XML with XSD to data format

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 )

Involved in Informatica PowerCenter 10.4 for ETL processes, utilizing Mapping Designer, Workflow Manager, Designer, Monitor, Mapplet Designer, and creating Tasks, Sessions, and Repository Manager activities. Developed Deployment Groups, Packages, and Worklets, establishing Parameter Text files to pass parameter values. Leveraged various source files, including Text/CSV, XML, WSDL, and Web Service Providers, importing data from SOAP/REST APIs. Formulated SQL scripts for use in Mapping Designer within Source Analyzer, and implemented command Tasks for automated retrieval and import of multiple CSV/Text files from a Shareable location (BICC - BI ORACLE Cloud data - SAAS) into Target Tables. Incorporated the Winscp Tool for accessing shareable locations and facilitating the transfer of files between locations through Informatica PowerCenter

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

Discussed with User for Business requirements and Designed Data Mart Mapping in Oracle & Sql Server Databases with SAP Tables

Created document for which is involved Packages, Procedures, Functions, Mapping tables & Columns and Servers

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

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

Project : Visa Processing Client : Tamkeen Technologies

Applications : Musaned, Ajeer, MOL

Handled Databases including SAP HANA, 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’s Moved through BODS from Sql Server to SAP HANA DB

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,SSRS,SSAS, SAP HANA-BODS/BI, 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 provides health and community services to thousands of people every day of the year through its service groups – UnitingCare Community, UnitingCare Health, Blue Care and ARRCS (Australian Regional Remote Community Services) Blue Care is one of Australia’s leading not-for-profit service providers of residential aged care, community care and retirement living, operating in more than 260 centres in 80 communities across Queensland and northern New South Wales.

Handled Database SQL Server, MSBI - SSIS,SSRS, SSAS, Informatica Power Center

Monitoring Database Mirroring, Disk Space, Scheduled Job, Alert Email and other Production Server Issues

Expert in data transformation services like BCP / Bulk Loads / Bulk Insert with SSIS - ETL operations with MSBI – DQS & Data Cleansing

Worked on logical and physical data base modeling & Tested with ERWIN tools

Used Citrix Server for login Remote Server Access

Handling of different Databases and Different Environments across 20 Servers

Handled ServiceNow (ITIL) Ticket Tool System (like Incident, Request, Release process)

User Access given to Procura application based on confirmation from superior

Created SQL, PL/SQL, SQL Plus programs required to retrieve data using cursors and exception handling

I played a modest role in modifying Power BI reports.

Used ETL- Informatica process for Data Transfer from Server to DB Instances and also handled existing ETL process

Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.

Message Queue Task used in SSIS

Based on business requirement Created different kinds of T-SQL Script and given output in the 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

Involved Development Activity in ETL- Informatica Power Center /Enterprise Data Warehouse / Data Analysis, Data Modeling, Data Architect and MS Business Intelligence – SSIS,SSRS,SSAS

Expert on Creating, Build and Deploying for Different type of Packages in SSRS

Used Table, Matrix, Bar, Card, Gauge, Slicers visualizations in Power BI

Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.

I played a modest role in Tableau visualizations and dashboards using Data Blending in Tableau Desktop

Configured SAP HANA Database Schema in SQL Server via Linked Server and get the their Objects details

Creation of Attribute View, Analytical view and Calculated view and Tested in SAP HANA

Created scripts to create new tables, views, queries for new enhancement in the application using Oracle – TOAD

SAP Lumira - Created & Tested data visualizations and stories from multiple data sources

Used DDL/DML commands and Code reviewed and Tested as per Insurance standards

Involved Testing, Data Quality, Data Profiling, Data Processing and Data Warehouse Monitoring in BODS

Involved DB constraints checking and find out which is not have Primary keys and Foreign Keys relation tables

Involved Project related Discussion with QA and Development Team

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, IBM DataStage Tool, SAP - HANA 1.0 /BODS 4.0, Informatica Power Center,

Power BI, Tableau, Talend, Microstrategy, 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 all about flexibility and the freedom to take the holidays that suit. It's about a lifetime of great holiday experiences that will broaden your mind, excite your senses and enrich your lifestyle. Club Infiniti allows you to choose the size and type of accommodation that suits, as well as giving you the flexibility to take multiple holidays in a year.

Involved Databases SQL Server, Oracle, MySQL, SAP - HANA with Testing, Data Modeling & MSBI- ETL/Data Warehouse

Performed Database Refresh tasks from production to Development and Staging Servers

Involved in Testing, Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology

Scripted OLAP database backup and scheduled a daily backup using SQL Server agent job.

ETL Created & Tested for multiple packages mapping and scripts for different Resorts

Involved on MSBI Development, Testing and SQL Server Database Objects Import into SAP HANA

Published reports and dashboards using Power BI

Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week

PL/SQL and T-SQL Handling of different Development / Production Databases in Different Environments across 20 Servers

Implementation and release of database changes according to agreed timescales and costs

Environment: Windows Server 2008, MS SQL Server 2012 / 2008 – SSRS, SSIS, SSAS, SQL Profiler, ORACLE, MySQL, Toad, SQL Loader, Dot Net. Crystal Report, SQL Compare, SAP- HANA, BODS 4.0, Power BI, Tableau, Microstrategy, Toad

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

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

FXLMconnect is the new internal FXLM web based information portal that consolidates Citi’s internal position and business reporting. All MIS and P&L reports previously accessible across desperate Citi web portals FXCentral, FXEye and Citi Treasury can now be viewed through this single access point.

Databases : MS SQL Server and Oracle, Sybase, SAP HANA

DBA and Development Support in MS SQL Server with ETL/DW, Oracle, Sybase, SAP - HANA

Effective Change Management of around 500 GB Size Database across Test, Development and Production Environments

Handled Oracle SQL Loader - Moving data from external files into the Oracle Database

Involved Interface with MS SQL / Oracle Databases

Troubleshooting and problem solving of Databases, PL/SQL and T-SQL development issues

Migration, Performance Tuning, Analyzing Indexes and Existing / Creation of new T-SQL Store Procedures, Views, Functions, Triggers and Packages

Released of Application of DB Script / Package Deployed on Production Databases

Written SSIS packages in 2005 and did conversion of DTS packages from 2005 to 2008

Utilized T-SQL on a daily basis in creating customs view for data and business analysis

Created parameterized reports, Drill down and Drill through reports using SSRS

Resolved complex issues and Error Handling in SSIS

Handled on MSBI Development and Data Export from MS SQL Server Databases into SAP-HANA Database

Creation of Attribute View, Analytical view and Calculated view in SAP HANA

Created Schedule job in SAP HANA

Handled ETL / SSIS multiple packages mapping, scripts and Data process & Transferred to Report Server

SQL Loader - Moving data from external files into the Oracle Database

Single point of contact with team and 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, SAP – HANA, 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

DTS/SSIS packages Tool to Import/Export the data Text/Excel file and Server to Server

Created complex stored procedures, Triggers and user defined functions using joins and cursors

Stored Procedures to Extract and Transform data from various data sources and Load to the Transactional/ Dimensional Databases

Analyze user requirements, functional and technical specifications, preparing test plans.

Execution of batch file Build & Deployment and hosting of Web Application Servers

Execution of Oracle Trigger through FTP

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

Code review as per Client standards

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)

Conversion of existing Oracle reports to Seagate Crystal Reports

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

Implementation & User Training at Client place

Interacting with the client and the onsite coordinator for issues and queries in the project

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