Rss

UDAY T

Database Designer - 5 Years of Experience - Near 07601

Occupation:

Database Designer

Location:

Hackensack, NJ

Education Level:

Master

Will Relocate:

YES

CollapseDescription

PROFESSIONAL SUMMARY * Over 4+ years of experience as a SQL Developer in IT Projects involving Business Intelligence (BI), Data Warehouse Implementation/development and Data Conversion for Banking, Finance, easHealth Care, Pharmaceutical, Telecommunications, B2B and Sales (POS) business sectors. * Experience in Database Normalization, Designing, Creating Indexes, Developed Queries and T-SQL Scripts in MS SQL 2016/2014/2012/2008/2005/2000. * Experience in Creating Tables, Views, Complex Stored Procedures, User Defined Functions (UDF's), Triggers to facilitate efficient data manipulation, data integrity, Views and other T-SQL (DDL, DML) statements for various applications. * Involved to develop the VB Script, C#, and ASP.Net, VB.Net and .Net framework creation IN SSAS and SSIS. * Extensive experience in monitoring and tuning SQL Server database performance using tools like Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. * SQL Profiler, Index Tuning Wizard, Database Engine Tuning Advisor, Enterprise Manager. * Experience in using custom code (vb.net), variables, expressions, and functions for the reports and in handling Parameterized reports, in writing sub reports and parameterized Queries for generating reports in SSRS . * Experience in creating, Cubes, Multidimensional cubes using SSAS, Multi-Dimensional Expressions (MDX) queries and Data Mining Extensions (DMX) queries for Analysis Services & Reporting Services. Implemented cell level security in cubes. * SQL Server RDBMS database development including T-SQL programming. * Experienced in creating different types of Tabular, Matrix, Drill-Down, Cross Tab, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS). * Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling. * Worked on administration tasks such as Data loading, Batch Jobs, Data unloading, Backup & Recovery, User and Application Table Management, upgrades, creating Databases/File groups/Files/Transaction logs. * Strong experience in using the Microsoft Suite (Management Studio, Business Intelligence Development Studio) (SQL) Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS). * Experience in deploying packages to Integration Services Catalog in SQL Server 2012,2014. * Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.

Right_template4_bottom

CollapseAccomplishments

Highlights:

Left_template4_bottom

CollapseKeywords

Left_template4_bottom