Usha D Email & Phone Number

Dayton, Oh, Us

Developed various T-SQL stored procedures, triggers, views, and adding/changing tables andTable valued Functions for data extraction, data load and transformations.  Created Reports with different Output formats such as Excel file, fixed width text file, PDF, tab-delimited and pipe-delimited.  Worked on several State Reports and used SSIS to create multiple destination files fromsingle/multiple sources.  Designed and developed various Service Management Reports, utilizing Dynamic and CascadingPrompts, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS2012.

Nashville, Tennessee, Us

The project is designed in two phase's data gathering and reporting, the data gathering part isdone using SQL Server Integration Services (SSIS) and the reporting portion is built on SQLServer Reporting Services (SSRS) platforms● Responsible for Data Modeling based on the client requirements, daily maintenance andperformance tuning.● Developed Tabular Reports, Matrix Reports parameterized Reports Subreports, Snapshot andAdhoc reports (SSRS).● Developed physical data models using ERWIN/ ER Studio and created DDL scripts for databaseschema and objects.

Involved in Gathering end-user requirements, developed applications, and different auditfunctionalities depending on the requirement acting for both system analysts and applicationdeveloper. Composed user requirement documents, created technical specs, and design documents for variousprojects. Generated complex T-SQL queries, sub-queries, co-related sub-queries, dynamic SQL queriesetc. Programming in SQL server using stored procedures, triggers, views, user-defined functions