Sriyanka Das

Email: adx4fz@r.postjobfree.com

Mob: +1-438-***-****, 959-***-****(WhatsApp)

Address: ****, *** **-*, *********

Rene Levesque Montreal, QC H3H 1R4

Professional Summary

I have completed my PGDCA after Post Graduate and currently working with LightWave Technologies Remotely as a Data Engineer from October 2018.

Working knowledge of MSBI (SSRS, SSIS) Developer &SQL Server 2014/2016/2019.

Developing T-SQL queries, triggers, functions, cursors and stored procedures.

Alter the schema for the required objects.

Used DDL and DML for writing triggers, stored procedures, and data manipulation.

Created views to restrict access to data in a table for security.

Created users and roles for login authentication and validating permissions.

Administering MS- SQL Server, performing day-to-day tasks such as Database tuning by checking indexes.

Developing Package in SSIS and then deploy and create job for that package.

Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.

Wrote Stored Procedures and triggers to capture inserted, deleted and updated data from OLTP systems.

Created Triggers to enforce data and referential integrity.

Created indexes for the quick retrieval of the data from the database.

Defined constraints, rules, indexes and views based on business requirements.

Quick learner and Adjustable according to the team environment

Technical Skills

Type of Skill

Versions or Names

Programming languages

T-SQL, PL/SQL, Visual Basic 6.0,VB.Net

Databases

SQL Server 2014/2016/2019

Operating systems known

Windows 7/10 Windows Server 2008/2012/2016

IDE & BI Tools

SQL Server BI Development Studio (BIDS)

Technologies

Database

Version Control

SVN,GIT

ETL Tools

SSIS

Project Management tools

Jira

Professional Experience:

1.Project Name: Electronic communication device

Description:

The Learning module of ECD Application is the ability to assign employees the mandatory trainings to acquire skills and efficiency. Which will Increase the productivity of employee and they become an asset for the organization. This is the own product of Light Wave and whose data source is currently migrating from people soft to workday environment.

HK Compliance process and send Excel Report for respective person.

Workday Leaver process and send notification.

Migration of PeopleSoft to Workday system.

Responsibilities:

Created and modified database objects like Tables, Views, Synonyms, Indexes, Stored Procedures, Triggers, and Functions.

Designed SSIS Packages to transfer data from workday data feed to SQL Server using Business Intelligence Development Studio with team.

Make sure the Existing Learning module will work as per the expectations after consuming the Workday data feed with team.

Technology Used for Development:

Programming – SQL SERVER 2014, SSIS 2014,Autosys

2.Project Name: Trust Office Integration and Operation Application.

Description:

Trust Office Integration and Operation Application is the centralized application for all Middle Office Operations. This application is used mostly as an information repository having data of accounts, accountants, administrators, branches, Trades, Incoming Cash Receipts etc. To creating this reports, Trust Office Data Warehouse need to load data from various data sources like Main Frame, SQL Server, Flat files, XML files, Excel files, etc. The Integration framework provides generic ETL tool to transfer data from different data sources to Trust Office data warehouse with very minimal code modification.

Trust Office Bloomberg FMV Data upload and DOD calculation Release.

Trust Office Maintance and Other Enhancement

Responsibilities:

Created and modified database objects like schema, Tables, Views, Indexes, Stored Procedures, Triggers, and Functions.

Designed SSIS Packages to transfer data from different sources to SQL Server using Business Intelligence Development Studio with team.

Extensively worked with DBAs towards Performance Tuning with team.

Employment History

Company Name

From

To

Light Wave Technologies

October 2018

Till date

Technology Used for Development:

Programming – SQL SERVER 2014, SSIS and SSRS, XML, HTML, POWER BI.

Languages known

English, Hindi and Oriya

Contact this candidate