Sql Server Data
Resume:
Matang Patel
Professional Summary:
> Over * years of experience with MS SQL Server Developer in Financial,
Banking and Retail industries.
> Extensively experienced in database activities like Data Modeling,
Database Design and Development, Implementation, Maintenance and
Performance Monitoring and Tuning using tools such as Index Tuning
Wizard, SQL Profiler and Replication.
> Highly experienced designing standards for the database table, column,
procedure and views. Optimized the performance of queries with
modification in T-SQL queries, removed unnecessary columns, eliminated
redundant and inconsistent data, normalized tables, established joins
and created indexes wherever necessary.
> Involved in Data Modeling using Erwin 7.0/6.5 and Unified Modeling
Language (UML) 2.5/2.0 tools.
> Experienced with aggregation using OLAP analysis services cube.
> Proficient in implementing surrogate key generation strategy in the
Data warehouse and Involved in Migration from heterogeneous sources
including Oracle to MS SQL Server.
> Exhaustive experience in Data Extraction and Transforming and Loading
(ETL) using DTS package in MS SQL Server 2000 and SQL Server
Integration Services (SSIS) in MS SQL Server 2005 with .NET,
Import/Export data, Bulk insert and BCP.
> Adept in installing, upgrade, troubleshooting and configuration of MS
SQL Server 2005/2000 Database.
> Excellent in report generating using Crystal reports and SQL
2005/2008 Reporting services.
> Developed Drill through and Drill down reports using SQL Server
Reporting Services (SSRS).
> Experienced in using Business Intelligence Development Studio (BIDS)
Graphical User Interface (GUI) to design SQL Server Integration
services (SSIS) packages for Data Management applications.
> Successfully created Fact Tables, Dimensions and joined them to
extract meaningful data.
> Worked with SQL profiler for checking performance of data base, so
actively involved in performance tuning and monitoring of Data Base.
> Transformed data from various data sources using OLE DB connection by
creating various DTS packages.
> Experienced in providing 24x7 support and trouble shoot production
issues on high availability systems.
> Extracted data from various sources and load it to SQL 2005 with the
help of SSIS and Experienced in creating Jobs, Alerts, SQL Mail Agent,
Scheduling DTS packages.
> Excellent communication skills, experience with client interaction,
providing technical support and knowledge transfer and take new roles
in minimum time and little training.
> Good business and Systems Analysis skill to understand the
requirements customize the client application.
Education Qualifications:
MS in electrical and computer engineering
Skillset:
MS DOS, Unix, Windows XP/2000/NT/98/95, MS SQL Server 2008/2005/2000, MS-
Access, SQL Profiler, SQL Query Analyzer, Oracle 9i/8i, Enterprise Manager,
SQL Server Management Studio, Business Intelligence Development Studio
(BIDS), Backup Server, Replication Server, SQL Agent, Service Manager,
OLAP, Data Transformation Services (DTS), SQL Server Integration Services
(SSIS), Import/Export Data, Bulk Insert, BCP, Visual Source Safe Code
management tools 6.0., C, C++, Java Script, T-SQL, HTML, XML, VBScript,
OLAP, SQL Server Reporting Services (SSRS), MS Access, MS-Excel
(XP/00/98/97)
Projects Summary:
KPMG, Montvale, NJ
1/2009 - Present
MS SQL Server BI Developer/SSAS/SSIS/SSRS
KPMG is one of the leading providers of Audit, Tax and Advisory services.
KPMG member firms respond to clients complex business challenges with a
global approach to services that spans industry sectors and national
boundaries. The scope of the project using audit online application create
the bugs reports based on OLTP roster database for the ticket management
system database and the analysis of the user inter action application.
Hardware/Software:
MS SQL Server Reporting Services, SQL Server Integration Services, MS SQL
Server 2008/2005, C++, Visual Studio 2005, MS Access, MS Excel.
Responsibilities:
> Responsible for logical and the physical design of the data mart for
the use reporting services with the use of the OLTP Roster Database.
> Designed the data mart with the use of the fact and dimension table
model. Also designed the aggregate table for the usage summary
reports.
> Used various dataflow and control flow controls for the ETL and
Implemented Data Transformation Services Packages in SQL Server
Integration Services (SSIS) for transferring data and Data Loads.
> Responsible for the validation of the aggregate data from the ODS and
the OLTP Database.
> Stored configuration information in SQL Server table for the migration
from development server to the production server.
> Optimized the performance of queries with modification in T-SQL
queries, removed unnecessary columns, eliminated redundant and
inconsistent data, normalized tables, established joins and created
indexes wherever necessary.
> Return the stored procedure for the ETL functionality from ODS to Data
mart in SQL Server. Created Alerts for successful or unsuccessful
completion of scheduled Jobs.
> Designed the usage summary and detailed reports in SSRS from the
requirement document and the old report Mock-Up in MS Excel.
> Scheduled jobs and alerts using SQL Server Agent.
> Developed the ER diagram using ER win tool for the created the data
mart ticket management system database and mapped the data into
database objects.
> Responsible for report generation using SSRS based on business
requirements.
> Responsible for the reports deployment on the reporting services
website and created subscription for the windows file share. Returned
the stored procedure and the UDF for the reports.
> Generated periodic reports based on the statistical analysis of the
data using SQL Server reporting Services (SSRS), and Crystal reports.
> Experience in working with SSAS in creating cubes, data source views,
named queries, dimensions and deploying of analysis services projects.
> Monitored the database to identify and resolve the performance issues
using SQL Server Profiler.
ETS (Education Testing Services), Princeton, NJ
6/2007 - 12/2008 MS SQL Server/SSIS
Developer
ETS conducts assessment and policy research and develops assessments and
related services to advance quality and equity in learning worldwide. The
project is all about integrating into a centralized database with dynamic
design and user friendly application to keep track of various Educational
systems across the nation.
Hardware/Software:
MS SQL Server 2005, T-SQL, MS Excel, MS Access, ASP.Net, Visual Basic, SQL
Server Integration Services, SQL Server Reporting Services.
Responsibilities:
> Determined the SQL Server 2005 Installation. Installed SQL Server
Management tools using SQL Server 2005 setup program.
> Designing standards for the database table, column, procedure and
views. Optimized the performance of queries with modification in T-SQL
queries, removed unnecessary columns, eliminated redundant and
inconsistent data, normalized tables, established joins and created
indexes wherever necessary.
> Created degenerative dimension within OLAP environment. Successfully
created Fact Tables, Dimensions and joined them to extract meaningful
data.
> Wrote custom T-SQL stored procedures and triggers to improve
performance, preserve referential integrity and provide additional
application functionality. Created Database, creating tables, views,
indexes, stored procedures, triggers and constraints.
> Analyzed the requirements and fine tune the stored procedures to
improve performance.
> Data transferred between various servers using BCP and Data
Transformation Services in SQL Server Integration Services.
> Implemented Data Transformation Services Packages in SQL Server
Integration Services (SSIS) for transferring data and Data Loads.
> Involved in writing T-SQL programming for implanting stored procedures
and functions for different tasks.
> Used profiler to find badly performing queries and deadlocks
> Worked on Client/Server tools like SQL Server 2005 Enterprise Manager
and Query Analyzer to administer SQL Server 2005..
> Resolved various performance issues and running DBCC command.
> Used SSRS to write complex formulas and to query the database
different to generate different types of ad-hoc reports.
> Worked on DTS Package in SQL Server Integration Services (SSIS), DTS
Import/Export for transferring data from heterogeneous database.
> Generated ad-hoc reports using MS-Access and Crystal Reports.
First National Bank, Omaha, NE
4/2006 - 5/2007 MS SQL Server Developer
First National is the largest privately owned banking company in the US.
The project was about migrating the existing database from SQL Server 2000
to SQL Server 2005 and on improving the performance of the system. Reports
are also created for the banking process on the daily and weekly basis.
These reports are reviewed by directors and analysts to calculate different
categories like banking calculation etc.
Hardware/Software:
Windows XP, Microsoft SQL Server 2005/2000, Microsoft Excel, ODBC, SQL
Query Analyzer, Erwin, Visual Source Safe, Crystal Reports and SSRS
Responsibilities:
> Created database objects like tables, views, indexes etc.
> Migrating of database from MS SQL 2000 to MS SQL 2005.
> Modified existing database by adding tables and relationship to
existing data model. Wrote custom T-SQL stored procedures and triggers
to improve performance, preserve referential integrity and provide
additional application functionality.
> Optimized the performance of queries with modification in T-SQL
queries, removed unnecessary columns, eliminated redundant and
inconsistent data, normalized tables, established joins and created
indexes wherever necessary.
> Data transferred between various servers using BCP and Data
Transformation Services in SQL Server Integration Services.
> Created views and scripts to convert business logic for different
reports. Utilized pivot tables to provide structure to reports in
proper format.
> Used temp tables to reduce the number of rows for joins, to aggregate
data from different sources for different reports.
> Created stored procedures for about SQL Server Integration Services
(SSIS) which are used in the report to customize the report data and
to make data analysis efficient.
> Created various dynamic reports by using formulas in Crystal Report 9
as part of enhancement.
> Moved logic from crystal report into stored procedure to improve
performance and keep crystal report as simple as possible by balancing
workload between crystal report and SQL Server 2005.
> Worked with BCP and DTS to load text files to SQL Server. Maintained
the data, database backups and restoration, backup strategies,
scheduled backups.
> Involved in complete backing up of Database and restored the database
from Disaster Recovery.
> Configured SQL mail agent for sending automatic emails when a DTS
process is failed or succeed using SQL Server Integration Services.
> Involved in testing, bug fixing and documentation for the project.
Smith Barney, Boston, MA
6/2005 - 4/2006
MS SQL Server Developer
Morgan Stanley Smith Barney is recognized as one of the industry's global
wealth management firms. The project involved application for the customers
to register and access their accounts online from WMS (Wealth Management
System) and worked on SQL queries and improved of the system.
Hardware/Software:
MS SQL Server 2000 Enterprise Edition, T-SQL, Crystal Reports, ERWIN, MS
Office and Windows 2000 platform.
Responsibilities:
> Determined the SQL Server 2000 Installation. Installed SQL Server
Management tools using SQL Server 2000 setup program.
> Wrote custom T-SQL stored procedures and triggers to improve
performance, preserve referential integrity and provide additional
application functionality.
> Involved in ER diagram (logical design) and mapping the data into
database objects. Worked with BCP and DTS to load text files to SQL
Server. Maintained the data, database backups and restoration, backup
strategies, scheduled backups.
> Actively involved in Normalization and De-Normalization of database.
> Scheduled jobs and alerts using SQL Server Agent.
> Worked closely on database tuning, performance planning, backup
planning and database administration.
> Adept in installing, upgrade, troubleshooting and configuration of MS
SQL Server 2005/2000 Database.
> Configured merge replication using snapshot agent and merge agent
(created distribution database, updated publishers, created and
managed publications, managed replication monitors).
> Transformed data from various data sources using OLEDB connection by
creating various DTS packages.
> Used Crystal Reports and MS Access to write complex formulas and to
query the database to generate different types of ad-hoc reports.
Accenture Info Ltd. Bangalore, India
2/2004 - 5/2005
MS SQL Developer
Accenture is a global management consulting and technology services
company. Accenture collaborates with its clients to help them become high
performance business and governments. Accenture developed a comprehensive
from high-level strategic planning to improved customer service. This
project is involved in installing and configuring MS SQL server 2000. Also
includes designing, creating and maintaining databases in SQL server 2000.
Hardware/Software:
MS Sql server 2000, Windows 2000, HTML
Responsibilities:
> Determined the SQL Server 2000 Installation. Installed SQL Server
Management tools using SQL Server 2000 setup program.
> Configuring tuning and optimizing T- SQL. Responsible for performing
basic developer task like creating, altering and dropping tables.
> Designing standards for the database table, column, procedure and
views. Optimized the performance of queries with modification in T-SQL
queries, removed unnecessary columns, eliminated redundant and
inconsistent data, normalized tables, established joins and created
indexes wherever necessary.
> Successfully applied schema change scripts to existing objects to
synchronize with changing business rules.
> Actively involved in gathering user requirement and online system
specification.
> Created complex stored procedures, triggers, views and Insert/Delete
tables for data load and transformation and data extraction.
> Performance tuning by tuning existing indexes and creating new indexes
where necessary.
> Participated in different testing and debugging of the system.
Monitored the database to identify and resolve the performance issues
using SQL Server Profiler.
Contact this candidate