Khyati Patel

Phone: 732-***-**** Email:acozbh@r.postjobfree.com

Professional Summary:

Over all 3 years of MS SQL Server Developer experience in Healthcare and Bank domains with

expertise in MS SQL Server 2008/ 2005 suite of products like SSRS, SSIS. Strong

communication, problem-solving and multi-tasking abilities, expert in planning, modeling,

designing, developing, implementing, administering, and maintaining Microsoft SQL Server

2008/2005 and Access 97-2010 databases. Some experience with Oracle and MYSQL Databases.

• Proficient in the use of T-SQL for developing complex Stored Procedures, Triggers,

Tables, Views, User Defined Functions, Relational Database models and Data integrity,

and SQL joins.

• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and

creating Effective Functions and appropriate Triggers to assist efficient data manipulation

and data consistency.

• Experienced in Logical and Physical Database design & development, Data Conversion,

Normalization and Data modeling using Erwin and SQL Server Enterprise manager.

• Expertise in working on all activities related to the development, implementation,

administration and support of ETL processes for large-scale Data Warehouses using Bulk

Copy Process (BCP), Data Transformation Services (DTS) and SSIS with MS SQL 2008.

• Proficiency in creating many complex SSIS packages with complicated transformations

using SQL Server Integration Services.

• Strong knowledge of Data Warehousing methodologies and concepts, including star

schemas, snowflakes, dimensional modeling and reporting tools

• Expert in designing complex reports like Cascading parameters, Drill-Through Reports,

Parameterized Reports and Report Models and ad-hoc reports using SQL Server

Reporting Services (SSRS) based on client requirement.

• Proficient in Database performance optimization, debugging and tuning using the Query

Analyzer, SQL Profiler and SQL Server Debugger.

• Demonstrated experience seamlessly learning new technologies in a short span of time,

integrating well into any environment, and working well under pressure.

EDUCATION QUALIFICATIONS:

Bachelor of Engineering in Information Technology, Gujarat, India

SKILL SET:

MS SQL Server 2008/2005, SSIS 2008/2005, SSRS 2008/2005, T-SQL,PL/SQL, MS Visual

Studio 2010/2008/ 2005, MS Access 2010/2007/2003, MS Word, MS Excel, Windows

9x/NT/2000/XP/Server 2003, IIS, UNIX, MS SQL Profiler, SQL Query Analyzer, Erwin Data

modeler 7.2/4.2, Crystal Reports11/10/9/8.5, C,C++,C#, Visual Basic 6.0, Ultra Edit. VSS, TFS,

SharePoint, Visual Basic.NET, XML, VBScript, Oracle 7.x/8i/9i.

Projects Summary:

CVS caremark [GalaxESolution], Somerset,NJ September 2013-

Present

SQL Server Developer

CVS Caremark is reinventing pharmacy to provide caring expert guidance, new cost effective solutions,

and even more convenient access to care to their members. The project was to apply business rules for

capturing the client raw files in an automated way, converting them into DM46 format, Eliminate the need

for Manual Processing by applying standard edits and client based edits and dropping the file for

Voluntary Disenrollment Extract (VDE) for manual processing.

Responsibilities:

• Participating in meetings with business users to gather the requirements and to identify

the business needs.

• Interact with business users and collect the business requirement documents for

developing Business Rules.

• Based on business requirement, developed the Complex SQL queries with Joins and T-

SQL, Stored procedure, Views, Trigger to implementing the business rules and

transformations.

• Created indexes on selective columns to speed up queries and analyses in SQL Server

Management Studio.

• Reduced the T-SQL overhead successfully by avoiding unnecessary use of the union

statement & using the TOP operator to limit the Select Statement in certain Queries.

• Created views to restrict access to data in a table for security.

• Migrated data from various sources like Excel, text, CSV file into SQL database as per

business need.

• Designed SQL SSIS Packages to extract data from various data sources such as Access

database, Excel spreadsheet, and flat files into SQL Server 2008 for further Data Analysis

and Reporting by using multiple transformations provided by SSIS such as Data

Conversion, Conditional Split, Bulk Insert, Merge and Union all.

• Modified and Update Store Procedure according to requirement.

• Create unit test cases based on Requirement Specifications and Functional design

documents.

• Update Technical Specification document

• Update code review document on daily basis.

Project Environment

MS SQL server 2008, MS SQL server Integration Services (SSIS), MS SQL server reporting

services(SSRS), Excel, MS SQL Management studio

ADC Bank, Ahmadabad, India July 2010 – March 2012

MS SQL Server Developer

ADC Bank is One Financial Corporation specializing in credit cards, home loans, auto

loans, banking and savings products. This project was about collecting information about

different client belong to different categories pertain in to demographics, industry, annual income

for staging post extraction from various sources & provide daily reports.

Responsibilities:

• Gathered functional requirements and Business requirements and wrote the technical

specifications for building the Data model.

• Worked closely with end users in designing and creating the Data warehouse for

management group using SSIS and Erwin.

• Implemented logical and physical database modeling using Erwin tool.

• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients,

advisors.

• Created User Defined Functions, Triggers to store data into appropriate tables as and

when data arrives and created indexes to the tables that have least updating to improve

the query performance.

• Wrote complex SQL queries using joins, sub queries and correlated sub queries to

retrieve data from the database.

Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and

●

staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split,

Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server

Integration Services.

Successfully implemented SCD transformation in SSIS and performed security.

●

Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.

●

Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports

●

using SSRS.

Performed T-SQL tuning and optimization of queries for reports that take longer execution time

●

using MS SQL Profiler in MS SQL Server 2005.

Project Environment:

Microsoft SQL Server 2005 Enterprise Edition, Windows Server 2003, SQL Server Management

Studio(SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services

(SSRS),Business Intelligence Development Studio(BIDS), Oracle 10g, Microsoft Visual Studio

2005.

Contact this candidate