Mayuri Patel Email & Phone Number

Mayuri Patel is a SQL Developer at PSM Tech LLC.

• 

  Sql Developer

  Psm Tech Llc

  Jul 2015 - Present

  Designed and created SSIS packages to extract, transform and load data from Excel and Text to SQL Server destinationusing various complicated transformations like conditional split, look up, derived column, data conversion and slowlychanging dimensions.Worked with T-SQL to create tables, stored procedures, triggers and user defined functions for complex business logic.Used SQL Server Profiler and Database Tuning Wizard for Performance tuning and query optimization.Created indexes on selective columns for the fast retrieval of data in SQL Server Management Studio.Used Event handlers to capture the run time error messages by using send mail tasks in the background upon success orfailure of a package in SSIS, carried out scheduling and administering of SSIS packages.Involved in error handling, creating package configuration and log details using SSIS logging.Generated and consolidated monthly reports to drive forecast production plan with SQL report services (SSRS).Designed, developed and deployed Summarized, Matrix and Tabular reports with drill down and drill through featuresusing SSRS in Business Intelligence Development Studio BIDS) as per the client requirements.Scheduled reports using SSRS to generate daily, weekly, monthly and quarterly reports.Involved in analyzing, designing, building and testing of OLAP cubes with SSAS and in adding calculations using MDX.Created and maintained databases, tables, views, user logins, indexes, check constraints and business rules using T-SQL.