P.H.Patel

acy71u@r.postjobfree.com

270-***-****

Professional Summary:

. Overall IT experience as MS SQL Server Developer 2014/2012/2008

R2/2008/2005/2000 in various Industry verticals like Insurance,

Finance, Retail.

. Strong experience in Stored Procedure, User Defined Function, TSQL

coding, Performance Tuning and Query Optimization.

. Highly proficient in the use of T-SQL for developing complex Stored

Procedures, Triggers, Tables, User Defined Functions, views, indexes,

user profiles, Relational Database models, Data integrity, query

writing and SQL joins.

. Wrote and modified stored procedures/Triggers (DML/DDL) to implement

complex business rule.

. Involved in developing stored procedures, triggers for the

application.

. Expertise in Creating, Configuring and Fine-tuning ETL workflows

designed between Homogenous and Heterogeneous Systems using SSIS of MS

SQL Server 2008 and MS SQL Server 2005 respectively.

. Extensive Knowledge in creating complex SSIS and DTS packages for ETL

purposes. Implemented complicated transformations to be used in SSIS

packages.

. Expert in Data Conversion, Normalization and Data Modeling, Multi-

Dimensional Modeling and involved in creation of Fact Tables,

Dimension Tables, Star Schema and Snowflake dimensional schema using

Erwin Tool.

. Expertise in developing SSIS Packages and using data transformations

and deploying them on various production servers.

. Proficient in creating On-demand and Scheduled reports, handling sub

reports and defining query for generating drill down reports using MS

SQL Server Reporting Services 2008/2005 (SSRS).

. Highly skilled in writing Parameterized Queries for generating Tabular

reports and Sub reports using Global variables, Expressions, and

Functions, Sorting the data, Defining Data sources and Subtotals for

the reports using SSRS 2008/2005.

. Expertise in Developing Reports using Crystal.

. Experience working with c# and .net

. Adept in defining referenced relationships and calculated members in

SSAS and used MDX queries.

. Expert in using tools such as Bulk Copy (BCP) and Data Transformation

Services (DTS).

. Extensive knowledge in developing and implementing Disaster Recovery

Model, and Replication Models.

. Expert in using tools like MS SQL Profiler, Index Tuning Wizard,

Windows Performance for monitoring and tuning SQL Server performance.

. Maintained positive communications and working relationships at all

business levels.

Education:

Bachelor of Science

Technical Skills:

SQL Server 2012/2008R2/2008/2005, SQL Server Enterprise Manager, Transact-

SQL (T-SQL), SQL Server Reporting Services (SSRS), SQL Server Analysis

Services (SSAS), MS SQL Server Integration Services (SSIS), Data

Transformation Services (DTS), SQL Server Management studio (SSMS),

Business Intelligence Development Studio (BIDS) MS Access, MS Visual

Studio, Microsoft Office, MS Visio 2003/2007/2010, ASP.NET, C#, VB.Net,

HTML, XML, Perl, VBScript, Java Script, XSL, Oracle 11g/10g, Crystal

Reports 8.5/9/10/11, Erwin Data Modeler 7.3/4.1/4.0, Experience with ASP.

Net, C# and VB .Net

Professional Experience:

Client: SEI Investments,PA

Duration: Feb2016 - Feb2017

Role: Crystal/SSRS Developer

The project involved developing of custom reporting solutions for SEI's

Global Fund Management for Investors.

Reporting solutions are developed over underline SUNGARD's proprietary

solutions, INVESTIER and INVESTRAN integrated capabilities, to help meet

their needs in the entire investment life-cycle, including relationship

management, reporting, monitoring, accounting, fund raising and deal

pipeline management.

Responsibilities:

. Modifying the current reporting structure for SEI which includes

changes in stored procedure, Crystal reports and SSRS.

. Worked as a Solution developer. Deliver the project artifacts.

. Designing of the applications and database modeling. Responsible for

fixing Production data issues and providing a Root Cause Analysis

(RCA) and permanent solutions to recurring issues in production

environment.

. Providing reporting solutions to clients on an Ad-hoc basis based on

the client requirements.

. Coach, mentor and lead personnel within a technical team environment.

. Coordinating onshore and offshore activities.

. Daily status meetings.

. Integrating NTTDATA's Custom reporting solutions with SunGard's

reporting solutions/databases.

. Developed Unit Test Plans for SSIS packages for checking the

functionality of each component.

. Modified the existing SSIS packages to meet the changes specified by

the users.

. Trained on building Conceptual, Logical and Physical data model.

. Have used c# in script task and script component.

. Created the conceptual model for the data warehouse with emphasis on

insurance (life and health)

. Reviewed and implemented the naming standards for the entities,

attributes, alternate keys, and primary keys for the logical model.

. Scheduled Jobs for executing the stored SSIS packages, which were

developed to update the database on Daily basis.

. Performance tuning of database objects and procedures for Release

Products.

. Preparing POC's for new modules.

. Worked on Existing C# Program to run the report through Windows

Application.

. Responsible for the maintenance and support in the production

environment, Bug fixing, Technical and Functional documentation of all

the applications developed.

. Participate in the integration testing and review the integration

defects and suggest the release plan for the defects.

. Generated parameterized reports, sub reports, tabular reports using

SSRS-2008.

. Designed, Developed and Deployed reports in MS SQL Server environment

using SSRS-2008.

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

parameterized reports using SSRS 2008.

. Created reports to retrieve data using Stored Procedures that accepts

parameters.

. Scheduled the monthly/weekly/daily reports to run automatically onto

the Dashboard

. Responsible for Monitoring and Tuning Report performance.

. Configured the report viewing security for various users at various

levels using Report Manager

. Scheduled report and exported in PDF format.

Tools & Technologies:

SunGard Investier/ Investran, NTTDATA Business Intelligence/Data

Warehousing (BI/DW) Framework, C#.Net, SQL Server 2014/2012/2008R2/2008,

Crystal Report 8.5/10,13, NTTDATA VIEW Framework, NTT DATA's Application

Management.

Client: Synovus Bank, Columbus, GA

Duration: Mar2015 - Jan2016

Role: BI/MS SQL Developer

Synovus is a universal bank and is organized within two business clusters:

Corporate and Investment Banking and Wealth and Investment Management and

Retail and Business Banking. The project involved designing a new database

schema and migrating databases to Production environment, modifying

database structures, providing support and guidance to operational models

by checking for data quality and its consistency.

Responsibilities:

. Planned, Defined and Designed data based on business requirement and

provided documentation.

. Gathered data and documenting it for further reference.

. Designed Database using Erwin data modeler.

. Applied various data transformations like Slowly Changing Dimension,

Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and

Derived column etc.

. Developed SSIS Packages using Look Up Values & implementing rules

provided by Business in the mapping document.

. Developed SSIS packages using Fuzzy Look Up and Fuzzy Grouping for

data cleansing purpose.

. Used SSIS Variables for storing the values, which are used in various

components of Data Flow Task.

. Developed Unit Test Plans for SSIS packages for checking the

functionality of each component.

. Modified the existing SSIS packages to meet the changes specified by

the users.

. Trained on building Conceptual, Logical and Physical data model.

. Have used c# in script task and script component.

. Created the conceptual model for the data warehouse with emphasis on

insurance (life and health)

. Reviewed and implemented the naming standards for the entities,

attributes, alternate keys, and primary keys for the logical model.

. Scheduled Jobs for executing the stored SSIS packages, which were

developed to update the database on Daily basis.

. Created SSIS Packages by using advance transformations (i.e. Pivot

Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term

extraction, Aggregate) and also used Custom components such as Audit

on Pre-Execute, Audit On Post-Execute, Custom Email Task and

Statistics Logging Component.

. Created Dynamic SSIS packages using complex expressions, variables and

control flow components such as For Each Loop, For Loop to loop over a

Directory to load inbound files coming daily.

. Reviewed the conceptual EDW (Enterprise Data Warehouse) data model

with business users

. Created the Load packages for loading the CSV files from DB2 into SQL

Server using SSIS 2008.

. Generated parameterized reports, sub reports, tabular reports using

SSRS-2008.

. Designed, Developed and Deployed reports in MS SQL Server environment

using SSRS-2008.

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

parameterized reports using SSRS 2008.

. Created reports to retrieve data using Stored Procedures that accepts

parameters.

. Scheduled the monthly/weekly/daily reports to run automatically onto

the Dashboard

. Responsible for Monitoring and Tuning Report performance.

. Configured the report viewing security for various users at various

levels using Report Manager

. Scheduled report and exported in PDF format.

Tools & Technologies:

SQL Server 2014/2012/2008R2/2008, Server Integration Services 2008, SQL

server Reporting Service 2008, Microsoft Visual Studio, SQL Server

Management Studio, MS Excel, T-SQL,ERWIN 7.2, C#

Client: Chamonix, Edison. NJ

Duration: Aug 2014 to Feb 2015

Role:BI Developer

The purpose of this project is to develop applications to integrate data

from different data sources to destination databases and generate different

kinds of reports using SSRS for inter user's.

Responsibilities:

. Planned, defined and designed data based on business requirement and

provided documentation.

. Actively participated in gathering Business Requirements and System

Specification. Participated in implementing the logical design to the

physical design by creating tables.

. Analyzed the existing data and performed the appropriate changes from

SQL Server 2008 to SQL Server 2014 by following the Normalization

standards to maintain data consistency and by performing data

validation.

. Involved in the design of new schema, new tables, field definitions

and mappings, stored procedures, views, indexes.

. Prepared the Migration document showing the paths for input and output

files, configuration files, table scripts, stored procedures and SSIS

packages.

. Tested, Cleaned and Standardized Data to meet the business standards

using Fuzzy and Exact lookups and String manipulations.

. Enforced the Business Rules to filter bad data from the system by

using Complex T-SQL Statements, and implemented various Constraints

and Triggers for Data Consistency.

. Responsible for creating the reports based on the requirements using

SSRS 2008.

. Built effective queries for high-performance reporting and rendered

them to HTML, XML, PDF and Excel formats using Reporting Services

(SSRS).

. Created different type of reports which include: Cross-tab,

Conditional, Sub report, Drill-down and Parameterized and deployed and

scheduled Reports in Report Manager using SSRS to generate all daily,

weekly, monthly and quarterly Reports.

. Monitoring performance and optimizing SQL queries for maximum

efficiency

. Developed reports using complex formulas and to query the database to

generate different types of ad-hoc reports using SSRS

. Deployed and upload the SSRS reports to SharePoint Server for the end

users and Involved in Enhancements and modifications

. Administrated the created Reports by assigning permission to the valid

user for executing the reports.

. Develop reports using complex formulas and to query the database to

generate different types of ad-hoc reports using SSRS

. Developed SSIS packages using Fuzzy Look Up and Fuzzy Grouping for

data cleansing purpose.

. Used SSIS Variables for storing the values, which are used in various

components of Data Flow Task.

. Developed Unit Test Plans for SSIS packages for checking the

functionality of each component.

. Modified the existing SSIS packages to meet the changes specified by

the users.

Tools & Technologies:

Microsoft SQL Server 2012, SQL Server Reporting Services (SSRS), SQL

Server Integration Services (SSIS), SQL Server Analysis Services (SSAS),

Query Analyzer, Microsoft SharePoint, Erwin

Client: Francesca's, Houston, Texas

Duration: Jan 2013- July 2014

Role: MS SQL Server SSIS/SSRS Developer

The aim of the project was to design and develop customer profile reports

and customer transaction reports using SSRS.

Responsibilities:

. Developed complex Stored Procedures to generate various Drill-through

reports, Parameterized reports, Tabular reports, Matrix reports and

linked reports using SSRS.

. Created various jobs using SQL Server Agent.

. Created Documents of understandings and Remedy Tickets for Deployment

process.

. Used SQL Server Profiler to trace the slow running queries and the

server activity.

. Actively participated in review meetings with Project Manager to

ensure that the development of projects meet business and system

requirements.

. Planned, Defined and Designed data based on business requirement and

provided documentation.

. Worked on SQL Server Integration Services (SSIS) to integrate and

analyze data from multiple homogeneous and heterogeneous information

sources (CSV, FTP Server, Excel, DB2 and SQL 2008R2).

. Developed Custom Logging so user can know when a row is inserted in

custom logging table by every SSIS package that executes.

. Used For-Each Loop Container, Sequence Container, Script task,

Expressions, Execute SQL task, Variables, Send Mail Task, FTP Task

Package Execution task to achieve business needs.

. Created SSIS packages to Extract, Transform and load data using

different transformations such as Lookup, Derived Columns, Condition

Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension,

Merge Join and Union all.

. Wrote and modified various Stored Procedures used in the application

using T-SQL.

. Scheduled and maintain packages by daily, weekly and monthly using SQL

Server Agent.

. Responsible for creating partition function and schema for the table

partitioning.

. Involves in creating counter logs and trace logs using windows server

2008 for advanced performance analysis and data logging over a period

of time.

. Created SSIS Packages to perform filtering operations and to import

the data on daily basis from the OLTP system, Staging DB to Data

warehouse and Data marts.

. Wrote SSIS Packages to migrate user's logins, stored procedures, and

functions.

. Responsible for implementation of data viewers, SSIS Logging, error

configurations for error handling the packages.

. Deploying, Testing and Scheduling SSIS packages using SQL Agent.

Tools & Technologies:

SQL Server 2008R2, SSIS, SSRS, Report Builder, Java Script, Oracle, T-SQL,

ETL, ASP.Net, C#.Net, Erwin r 7.3,.Net 4.0/4.5.,TFS 2010.

Client: Progressive Insurance, Cleveland, OH

Duration: Mar 2011 - Dec 2012

Role: MS SQL Server Developer/SSIS/SSRS

The Project is to extract data from various sources like DB2, Oracle and

load into SQL Server 2008 using various transformations in SSIS. Project

was to develop and load data warehouse and maintain ace of it.

Responsibilities:

. Designed data architecture, data model and Mapping Process to load

data based on business requirement and provided documentation.

. Implemented Table, Views, Function, Stored Procedures and Triggers for

load data and validation purpose.

. Worked with Agile Methodology tracking the product backlog and

resolved the defects/Solution assigned in daily scrum.

. Created SSIS package to load data from XML Files, Excel, CSV file, Ftp

server and SQL Server to SQL Server 2008 by using Derived Columns,

Condition Split, Data Conversion, Ole DB Command, Term Extraction,

Aggregate, Pivot Transformation, Execute SQL Task and Script Component

Task.

. Used SSIS to create ETL packages to Validate, Extract, Transform and

Load data to Transaction and Data Ware House.

. Converted DTS Package to SSIS package for synchronizes existing

process (DTS migrations).

. Used Team Foundation Server to retain Project code during deployment

process.

. Part of Code review during Production deployment and QA deployment.

. Designed SSIS Package step process to load data, validate data and

Recommending task to resolve performance issue with loading data in to

the Data Ware House.

. Created Process for Error Details in Application system, SQL agent Job

to easily identify Issue for Support and Solution.

. Identified slow running query and optimization of stored procedures

and tested applications for performance, data integrity using query

optimization tools.

. Monitored and explained plan assessment, SQL scripts, stored

procedures for databases.

. Designed index, statistics and optimized queries by using execution

plan for performance tuning of the database.

. Created Tabular and Matrix Reports with all aggregate functions and

expressions in SSRS.

. Created dashboard SSRS reports under report server projects and

publishing SSRS reports to the reports server.

. Developed functional and technical documentation to assist in the

design, development and/or maintenance of deliverables.

Tools & Technologies:

MS SQL Server 2008, SSIS Package, SQL BI Suite(SSMS,SSIS, SSRS,SSAS), XML,

MS Excel, MS Access 2007 & Windows Server 2008, SQL Profiler, Erwin r

7.3,.Net 4.0/4.5.,TFS 2010.

Contact this candidate