Data Sql Server

MEGALA.R Email:mailto:apremanandan**@addjlb@r.postjobfree.com

Mobile no: +91-975*******

Professional Summary

3.3 years of Professional experience in IT industry.

Good experience with SQL Server 2008/2012/2014, SSIS, SSRS

Experience in Extracting, Transforming and Loading data from Excel, Flat file, and MS SQL Server.

Skilled in error & event handling: precedence Constraints, Break Points, Check points and Logging.

Reporting Requirement- Conditional, Drill down, Drill Through, Charts and Sub Reports.

Involved in all phases of the application development (Designing, Unit testing and Defect fixing).

Having good knowledge on creation and scheduling of T-SQL jobs to run daily

Performance Tuning and Optimization.

Ability to work independently as well as work with teams having varying backgrounds

Self-motivated, creative and innovative individual willing to work hard.

Professional Experience:

Employer : Medall Health Care Pvt Ltd,Chennai

Designation : MSSQL Developer From 22 JULY 2015 – 10 OCT 2016 and 07 July 2018- Till now

Technology

MSSQL Server 2008, 2012,2014,SSIS,SSRS,MS Excel

Tools

Visual Studio 2013/2012

Operating System

Windows Family

Responsible for getting, understanding the business specs, preparing technical Specs.

Designed packages Using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, and Data Flow Task.

Extracted data from sources and transformed the data using different transformations like SCD, data conversion, derived columns, look up, Conditional Split, Aggregate, Union all, merge join and multi cast transformations.

Created Event Handlers for the Packages Using Event Handler Tab for Error Handling

Creating Stored Procedures, Monitoring The existing Job and Resolve the Issue If Any Failures

Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines

Export/Import the data from/to SQL Server

Send critical daily scheduled alerts in html format with pdf or excel attachments.

PROJECTS

Project 1 :Medall WareHouse-SSIS (ETL)

Domain : HealthCare

Customer : Medall Healthcare(Internal Project)

Team Size 5

Environment : SQL Server 2008 /2012/2014

Project Description:-

Medall Warehouse, a Data Warehousing Project using SQL Server Integration Services, It Extracts the Data from more than Seventy-Five Diagnostics Center, and Transforms and Load in to the Warehouse Database at every Five Minutes. Merge Concept is applied for insert and update of Data from various centers.

Project 2 :Medall Financial Accounting System(MAS).-SQL SERVER 2012/2014

Domain : Health care( Banking )

Team Size 4

Environment : SQL Server 2008R2 and 2014

Project Description:-

MAS is a Web application software that deals with accounting transactions. It includes accounts receivables, payables, general ledger, spread sheets, financial planning, and other financial activities. It Uses real time stock data to update your portfolio value minute by minute Watch your net worth grows alongside your other assets, and track your net worth anytime, from anywhere. Users have marker, checker and Authorizer access for making account transaction. It Manage data over different locations and synchronize it and manage payroll. It gets many miss reports which are useful for day today function. Automatic invoice collection through bulk upload from excel(from accounts team). Upload Journal voucher, payments, contra, revenue to database through excel upload and coding for business logic & validation.

Project 3: Uwin Lite

Domain : HealthCare.

Team Size : 5

Environment : SQL Server 2008/2012/2104

Project Description

Ultrasound Wave Integration System- Lite Version, a web based application named UWINLITE. It manages the Patient’s Appointment and Registration, Patient Billing, Image Acquisition from the available modalities and storing those images in centralized DICOM Server, Image Viewing, Post Processing, Diagnostic Reporting and Data Backup. Also it facilities to help decision making by providing various Statistical and Analytical Reports that may be required for given period. This software ensures a full automation of the radiological and administration workflow using Modality Work List HL7 and DICOM services. In this System have Lab machine interface with patient information details.

Project 4 : MPMS(Medall Purchase Management System).SQL SERVER 2014

Domain : HealthCare(Inventory System Mangement)

Team Size : 3 members

Environment : SQL Server 2012/2014

Project Description

MPMS is Web application software that deals with Purchase and Inventory Management automates and monitors procurement process thereby optimizing total purchase and inventory workflow. The solution supports the entire purchase workflow from request through purchasing and receiving the goods, as well as the entire inventory workflow from spare part management to warehouse configuration.

Qualification

Specialization

University / Institution

Year of passing

MCA

Master Of Computer Application

M.I.E.T Arts and Science College

(Gundur,Trichirapalli)

2015

BCA

Bachelor OF Computer Application

Cauvery College For Women(Trichirapalli)

2013

Higher Secondary

State Board

St.Dominic Girls Higher Secondry School

2010

SSLC

State Board

St.Dominic Girls Higher Secondry School

2008

PERSONAL PROFILE

Father Name : K.Rajamanickam

Date of Birth :07.03.1993

Nationality :Indian

Address :20,Anna street,Aranarai,Perambalur(TK)(DT)

Languages Known : English,Tamil

DECLARATION

I hereby assure that all the information furnished above is true to the best of my knowledge

and belief.

Place: Yours Sincerely

Date: (R.Megala)

Contact this candidate