Sesha

Project #1:

Description     :

FirstService Residential provides property management services to private

Residential communities, such as condominiums and homeowner associations. It manages

Approximately 8000 communities in Canada, Nevada, Florida,Austin, Boca and Broward etc.

Responsibilities:

·        Gathering the requirements From Business Analyst and Team Lead

·        Analyzing the data files and preparing the scripts for data migration

·        Expertise in Creating tables and Constraints

·        Expertise in writing T-SQL queries, stored procedures, cursors, functions, indexes, Derived Tables, SQL joins and Triggers. And Dynamic SQL Queries also

·        Performance tuning of stored procedures and slowly running queries.

·        Expertise in Debugging of SQL Serverfor supporting of Application Team

·        Having Experience in creating the Reports like Tabular, Matrix, Drill Down, Drill Through, List with Tabular Reports and Sub Repots according to client Requirement. and as well as Created CSV Rendered format Report with different pattern.

·        Supported on POWER BI Reports and SSIS Packages

·        Deploying Report into Different Servers.

·        Preparing the unit test cases. And Performing Unit testing to ensure if implemented solution meets client’s business requirements effectively. 

·        Working actively with team members for not having the Possibilities of rework.

Project #2:

Description    :

Turnberry: Turn berry is a real estate development company which operates in the commercial, residential and hospitality space.

The organization owns and operates the Aventura mall, town center Aventura, Destin commons Marriott Nashville and an array of select services hotels like the residence inn by Marriott Aventura mall and the courtyard by Marriott Aventura.it has developed over $7 billion worth of properties

Responsibilities:

·        Accountable of developing and creation of database from scratch to end

·        Creating database and perform the data modeling

·        Writing the stored procedure, function, triggers to load the data from one server to another server

·        Accountable to create the SSRS report and POWER BI Reports