NIVEDHA SABANAYAGAM

ETL Developer

ITZEL LLC

Summary:

•Over 6+ years of experience in ETL and database development especially in requirement gathering, designing, developing and implementing ETL and Data Warehouse solutions.

•Experience in implementing Type 2 Dimension Data models and data warehouse ETL techniques for historical data.

•Developed ETL using SSIS for data flow from source files like Excel, flat files, Tables and External Database Servers with proper mapping and high volume of data by using multiple transformations provided by SSIS.

•Experience in developing complex data warehouse implementation.

•Very good expertise in SQL Server Integration Services (SSIS),Azure SQL,Data factory and SQL Server database objects.

•Experience in understanding current implementation and re-write nested complex SQL/HQL script.

•Experienced working on management tools like team foundation server (TFS) and DevOps.

•Expertise in back ends testing and writing SQL queries, Joins, procedures using Oracle and MySQL.

•Strong knowledge of Software Development Life Cycle (SDLC) methodologies such as Agile, SCRUM and waterfall models and TDD.

•Created and maintained databases, tables, views, Indexes, check constraints, and business rules using T-SQL. Responsible for Performance tuning the queries, stored procedures and tables by using SQL Profiler, Execution Plans and Index Tuning Wizard.

•Experience working on SSAS Cubes (development & design), along with troubleshooting performance and processing issues.

Professional Experience:

Client: T-Mobile Bellevue, Washington

Role: Sr. ETL Consultant Apr 2019 to Present

Responsibilities:

•Developing ETL using SQL server Integration services (SSIS) for data flow from source files like Excel, flat files, Tables and External Database Servers with proper mapping and high volume of data by using multiple transformations provided by SSIS.

•Creating master and child packages, package configurations, error handling and logging.

•Working on all activities related to the development, implementation, administration and Support

of ETL processes for Data Warehouses using SQL Server 2012 SSIS on daily basis in Development, Staging and Production environments.

•Working Extensively with SSIS to import, export and transform the data between the linked servers and Involved in day-to-day database maintenance operations, creating and Maintaining jobs and schedules, email notifications on failures and server maintenance in a real time production and Staging environments.

•Troubleshooting and fixing the loading issues with ETL packages and files.

•Writing SSIS Packages to transform daily, weekly and monthly jobs, to transfer data from SQL server to different files and external databases.

•Creating and maintaining databases, tables, views, Indexes, check constraints, and business rules using T-SQL. Responsible for Performance tuning the queries, stored procedures and tables by using SQL Profiler, Execution Plans and Index Tuning Wizard.

•Creating and Modifying Triggers and Cursors in T-SQL for maintaining SQL server databases.

•Working in team environment in gathering project requirement with clients for new application development process.

•Developed & fixed bugs and validated

•Working on Microsoft Azure SQL PaaS environment,Data Factory and data Lake.

•Interacting with client directly and helping the possibilities and feasibilities for the new requirements.

Client: Walt Disney World, Lake Buena Vista, Florida Jan 2016 to Mar 2019

Role: Sr. BI Consultant

Responsibilities:

•Creating and maintaining databases, tables, views, Indexes, check constraints, and business rules using T-SQL. Responsible for Performance tuning the queries, stored procedures and tables by using SQL Profiler, Execution Plans and Index Tuning Wizard

•Reviewing developer code in pre-production environments, analyzing long running queries, and make recommendations and suggestions for performance improvement.

•Did unit testing and code review.

•Deployment on Spotfire Reports on Report server using library to view on Tibco Web player

•Managing SSIS packages performing complex ETL on heterogeneous data sources, composite workflows using loops, containers, lookups, etc.

•Manage Replication involving SQL 2008/2005 databases.

•Documenting knowledge-based articles on processes, fixes, etc. for the team in SharePoint.

Client: 365 Media India

Role: Database Developer Nov 2015-Dec 2016

Responsibilities:

Created Logical diagram for dynamic Database structure (3-Dimensional DB Structure)

Created Stored Procedures, Triggers, and Functions

Created Tables and Relationship between tables using constraints and Relationship between the entities

Data import from source file SQL Server Express using DTS/SSIS Wizard and queries and Source file can be many forms like Excel, Notepad and MS access Database

Testing and Tracking the BUGS using 365 Media Project Tracker

Creation of test databases in testing environments, Installing of MSSQL Server & Clients.

Database and Transaction log backups & restoration, backup strategies scheduling backup system for test Databases

Running query show plans and recreating clustered indexes according to show plans.

Performance monitoring and tuning MS SQL Server.

Creating logins and managing permissions to user logins.

Created DTS packages to transfer data between databases.

Client: Pentasoft, India

Role: Database Developer May 2012-Nov 2015

Responsibilities:

Created Stored Procedures, Triggers, and Functions

Created Tables and Relationship between tables using constraints and Relationship between the entities

Design and Development, Integration and Testing if needed.

Creation of test databases in testing environments, Installing of MSSQL Server & Clients.

Database and Transaction log backups & restoration, backup strategies scheduling backup system for test Databases

Running query show plans and recreating clustered indexes according to show plans.

TECHNICAL SKILLS:

SQL Server Tools Management Studio, Enterprise Manager, SQL Profiler, Query Analyser, Perfmon, DTS, SSIS, Replication monitor, Index Tuner, SQL Activity Monitor, etc.

Databases MSSQL Server, MS Access, SAS, Oracle

ETL SSIS, DTS

BI / Analytics Tools Tibco Spotfire, Power BI

Source Control Microsoft Team Foundation Server (TFS)

Operating Systems Windows Server, Win XP/Vista/7, Linux

EDUCATION & CERTIFICATIONS:

•Bachelor of Engineering in Computer Science from Anna University –India

•Master of Engineering in Computer Science from Anna University – India

Contact this candidate