Sql Server Ms

SONAM SHAH

SQL Developer/ BI Developer/ DBA

Tel: 631-***-****

E-mail: *******@*****.***

Professional overview:

* ***** ** ** ********** in SQL Server Database Administration, Design, System Analysis, Testing, Development and Support of MS SQL Server 2014/2012/2008 R2/2008/2005 in PRODUCTION and DEVELOPMENT Environments

Experience in database administration and development activities such as Installation, Configuration, Database design & development, Data modeling, Backup & Recovery, Data Transformation Services and Database Security.

Generated Transact SQL (T-SQL) Quires, Sub quires, Co-related sub quires and Dynamic SQL quires and Creating Tables.

Programming in SQL Server using the indexes, stored procedures, views, triggers and user defined functions and Common Table Expressions (CTEs).

Expert in Implementing High Availability Solutions such as for Log Shipping, Mirroring and Replication (Snapshot & Transactional) in MS SQL Server Environments

Experiences in troubleshooting issue, Performance Tuning using SQL Servers for Index Fragmentation, Query Plans, and Deadlocks.

Highly proficient in high-level design and develop of ETL SSIS and DTS packages for integrating data from heterogeneous sources (Excel, flat file, Text Format Data) to MS SQL Server.

Experience in MS SQL Server Migration from SQL Server 2000 to SQL Server 2005 and SQL server 2005 to SQL server 2008 by creating ETL package from Scratch.

Worked on SSRS to create Tabular, Matrix, Drill down and Drill through Reports using SQL BI 2005, 2008 and 2014.

Worked on SSRS Report Model project for ad-hoc query so user can create their own version of reports using Report Builder application.

Created SSRS reporting security so end user only access specific reports and report model which they intend to.

Experience in Data legacy mart.

Experience in creating Jobs, Alerts on SQL Mail Agent, and scheduled DTS/SSIS Packages.

Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.

Good understanding of Normalization/De-normalization, Normal Form and database design methodology.

Experience in creation of logins, users and configuring permissions and assigning roles to users.

Worked in Clustering environment and configured SQL server cluster groups as a High Availability Solution

Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

Experience in management of Database Space, Growth Monitoring of Data & Transaction log files.

Strong troubleshooting and organizational skill, independent, self-managing and teamwork.

Technical Skills:

Operating System

Windows 10/8/7, Windows Server 2003/2008/2012

Languages

MS SQL Server 2005/2000/2008/2012/2014, T-SQL, PL/SQL

Databases

MS SQL SERVER 2012/2008/2005 MS Access, Excel

Database Tools

T-SQL, MS Enterprise manager, SQL profiler, Query Analyzer, OLTP, DBCC, BPC, SQLCMD, SQL Agent, MS DTS (export and import), Index Analyzer, DTS Backup Server, SQL Alerts, SQL Jobs, Microsoft office

Development Tools

DTS, SSIS, SSAS, SSRS

Modeling Tools

Microsoft Visio, DB Designer, Front Page, Erwin

Other Tools

MS Office 2013/2007/2003/2000/XP, MS Outlook 97/2000/2013

Education & Training:

Bachelor in Electrical & Computer Science July’05 -June’09

Geetanjali institute of technical studies, Udaipur

SQL Server TSQL and Database Administration Training Sept’09-April ’10

Comprehensive SQL Server 2016 BI Training Sep’14-Dec’14

Professional Experience:

OptiSource International, Long Island Dec’15- Present

SQL Server Developer/ BI Developer

OptiSource has been a leading provider of lens processing supplies and eyeglass accessories for Opticians, Optometrists, and Wholesale Laboratories. Our extensive product line includes exclusive products such as: Snapit patented frame screws, Cobalt King blocking pads, All Off progressive marking ink remover, OptiPets eyewear holders, Titanium hand tools, and The Clear View family of personalized lens cleaning products

Roles and Responsibilities:

Exhaustive experience in Data Extraction, Transforming, and Loading (ETL) using SSIS package in MS SQL Server 2008r2, Import/Export data, Bulk insert and BCP.

Developed Triggers, Stored Procedures, Views and Functions for the custom database objects using SQL Server 2008r2

Created Stored Procedures and functions, and experienced in writing high performance code.

Created physical and logical structure of the new data warehouse (SQL database) and process workflow by using MS Visio 2007.

Experience in creating SSIS packages using different type of task, with Error Handling on the control flow task and dataflow task, use logging to log the events and Worked on package configuration to run package in different server.

Used different transformation like Pivot Transformation, Look up, Conditional Split, Data Conversion, Aggregation, Merge Join, Union, Union all, Multicast< Sort, OLE DB command, Fuzzy Lookup and Derived Columns, to export cleansed data from SQL Server 2005, Excel Spreadsheets, Text files and CSV files to data warehouse.

Used Sequence Container, Execute SQL Task, Send Mail Task, Precedence Constraint, Script Task to achieve business requirement in the control flow.

Developed the Slowly Changing Transformation to maintain The Historical Data.

Experience in Delta Load for Data Warehouse after finish initially process full load using ETL process.

Designed Data model for Data Warehouse (Logical and Physical model) using Star Schema.

Created configuration files in order to deploy packages in different environments.

Created various ETL Packages to load data from transactional system DB2 to staging (ODS) and staging to Enterprise Data-warehouse.

Experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.

Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.

Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data.

Created Matrix reports, Tabular Reports, Parameterized Reports, Drill down and Drill Through for various applications.

Generating Couple of Report in Power BI Tool like geographical Report.

Environment: MS SQL Server 2005/2008r2, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting service 2005/2008r2, MS SQL Server Analysis Service 2005/2008r2, MS Access, MS Excel, MS Visio 2007, and T-SQL.

General Trading Mar’15–Dec’15 MS SQL Server Developer

GT, the one of largest distributors company, continues evolving its architecture, a leading provider services for delivering food related products.

Roles and Responsibilities:

Gathered requirements from the business users

Created/modified SQL Joins, sub-queries, and other T-SQL implement business rules

Designed and implemented Stored Procedures and Triggers for automating tasks

Managed all indexing, debugging, optimization and performance tuning using T-SQL

Wrote T-SQL queries, Store Procedures and used them to build packages

Planned, designed and documented the optimum usage of space requirements and distribution of space for the Data Warehouse

Created configuration packages in SSIS to move the package from development server to production server

Used Event handlers to run send mail tasks in the background upon success or failure of a package in SSIS

Installed MS SQL Server and Management tools using MS SQL Server Setup Program

Designed and developed packages for a data warehousing and Data Migrations projects using Integration services. (SSIS) on MS SQL Server

Run and tested required queries and reports before publishing

Published the reports and scheduled the reports in different formats (Email, Public folder)

Scheduled the reports on different servers to run on daily/weekly monthly basis and email the results to the business users in the required format.

Scheduled tasks to run every day to update changes in the base tables

Environment: MS SQL Server 2008, SSRS, SSIS, SSMS, T-SQL, Access and Excel

Secure Meter Pvt ltd. Udaipur, India Nov’10– Sept’11

Jr. SQL Developer / DBA

Secure Meter is a manufacturer of secure energy metering systems, prepayment meters and test benches. Secure Meter strives to build a future that uses energy responsibly. We provide end-to-end solutions from smart grid metering to intelligent heating controls - to markets.

Roles and Responsibilities:

Created database objects such as tables, procedures, triggers, indexes and views

Developed processes, automation of maintenance jobs, tuning SQL Server, administered SQL Server security and SQL Server automatic e-mail notification

Worked on project planning, scheduling for database module with project manager

Managed SQL user logins, database user accounts, server roles, database roles and its permissions

Tested to optimize the procedures and queries to be used in production

Helped analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements

Configured replication servers and transactional replication between production and standby server for disaster recovery

Did performance tuning to optimize the SQL queries using query analyzer

Installed and Upgraded from SQL Server 2005 to SQL server 2008 on Various Production Servers.

Responsible routine DBA jobs like Backups and Restores

Managing Databases spread across multiple servers in Production, Development, staging & testing environments.

Monitored and modified Performance using execution plans and Index tuning

Environment: MS SQL Server 2005/2008, T-SQL, DTS, Windows 2003 Server

Contact this candidate