Sql Server Manager
Resume:
Pavan
Summary:
. Over ** Years of Information Technology experience primarily with
Database Development, Data warehousing, Client/Server Development and
Web Development.
. 9 years of MS SQL Server Developer/ Application DBA experience using
Microsoft SQL Server 6.x/7.0/2000/2005.
. Strong SQL Server Integration Services(SSIS) and SQL Server Reporting
Services (SSRS) experience.
. Expertise in Linked server configuration.
. Strong experience in creating SSIS packages and migrating DTS packages
to SSIS packages
. Strong experience in upgrading MS SQL server 2000 to 2005
. Strong experience in MS SQL server 2008
. Expertise in Data Modeling, Database Design, Database Programming.
. Strong experience in Data Modeling for OLAP and OLTP systems.
. Strong experience in writing ETL scripts in DTS/SSIS packages for
Dataware house systems in SQL server 2000/2005/2008.
. Experience on SSAS 2005
. Strong experience in creating and maintaining OLAP cubes
. Expertise in coding in C# & .Net in.Net framework 2005
. Strong experience with Windows Active Directory.
. Strong experience in using XML.
. Strong experience in data analysis
. Experience with Long View Trading System (LVTS)
. Strong experience in trading system.
. Good understanding of the SOX compliance (Sarbanes Oxley Act).
. Strong experience as application DBA for SQl server
. Strong experience in writing the complex stored procedures, UDFs,
Triggers.
. Strong data analysis experience.
. Experience with Microsoft Clustering Service and SQL Server
Clustering.
. Strong experience in Microsoft Web Development Technologies and Visual
Basic.
. Strong experience in Crystal Reports development and Crystal Reports
Server.
. Ability to learn new technologies quickly and evaluating their
architectural applicability.
. Self motivated with ability to work independently and in the team
environment.
. Strong leadership qualities with excellent communication & people
skills
Education: BS in Engineering
Technical Skills:
Database: MS SQL Server 6.0,6.5,7.0,2000,2005 and 2008,
Oracle 7.x, 8.x,9 I, MS Access 2007, Sybase
Database Tools: T-SQL, SQL Management Studio, Enterprise manager,
Query Analyzer, DTS, isql, SQL Digger, SQL Agent,
Red Hat for SQL packaging, SQL Mail, Web
Assistant, SQL Trace, SQL Profiler Performance
Monitor, Client Configuration Utility, Server
Configuration Utility, ERWIN, VSTS for database
professionals, SSRS,SSAS & SSIS in SQL server
2005/2008, Microsoft Visio 2003, DB Artisan 7.0,
Microsoft upgrade Advisor 2005,SQL Formatter,MDX
GUI Tools: Visual Basic 4.0/5.0/6.0, Visual InterDev 6.0/.
NET, Crystal Reports 6.0, 7.0
Web Active Server Pages (ASP) /ASP.NET, IIS
Technologies: 4.0/5.0,HTML, DHTML, CSS,XML
ETL Tools:
Informatica 6.1,Data stage 7.0
Languages: Visual Basic, VBScript, Java Script, VB Script,
VBA, C#, VB.NET
Data ODBC, DAO, RDO, ADO, RDS
Connectivity:
Operating
Systems: Windows 2003 Server, Windows XP Professional
2003, Windows NT 4.0, Windows NT 3.51, Windows NT
WorkStation, Windows 9.x
Remote Tools: Microsoft Terminal Server, VPN
Version Visual Source Safe 2005, CVS, StarTeam 2008(10.1)
Control:
File Transfer
Tools: Gentran, FTP
Trading
Systems:
LONG VIEW TRADING SYSTEM 6.3.5 / 6.6.3(LVTS),
PORTWARE
PROFESSIONAL EXPERIENCE
C I T Financials, Livingston, NJ Sep'10-Current
Sr SQL Server Developer
CIT Group Inc. is a commercial and consumer finance Company with a focus on
middle- market Companies. I had been involved in 2 projects called
Regulatory Reporting & Fresh Start Accounting (FSA). I'm responsible for
writing SSIS packages for loading dataware house from different sources
which are supporting several business sources creating Reports using SSRS.
I'm involved in data analysis writing technical test cases for implementing
regulatory requirements.This is my second term in C I T.
ROLE:
. Responsible for creating reports using SSRS.
. Responsible for writing complex SS IS packages for loading the FSA
datamart
. Involved in writing the complex stored procedures, UDFs, Triggers,
Views.
. Created dynamic SSIS packages and stored procedures in SQL server 2008
. Responsible for creating and implementing SSIS packages on SQL server
. Responsible for creating OLAP cubes using SSAS
. Extensively used the Derived column, Look up and Script
transformations in SSIS 2005
. Responsible for creating and testing stored procedures as per the
business requirements
. Wrote the test cases to follow the Regulatory requirement standards
. Responsible for transferring large data files across environments
using GENTRAN,
. Worked extensively on data modeling for data warehouses using star and
snowflake Schema
. Worked extensively on both OLTP and OLAP databases
. Responsible for testing reports and front end application.
. Responsible for creating and updating data models using Erwin as per
the requirements
ENVIRONMENT: SQL Server 2005/2008, SQL Management studio, SSIS, SSAS,
SSRS, Windows 2003 server, IIS 5.0, SFTP, .NET, Microsoft Visio 2003, SQL
Profiler 2005/2008, Platinum Erwin 4.5, Enterprise Manager 2000, Query
Analyzer 2000,Gentran,MS Access 2007
WELLS FARGO Bank, San Francisco, CA Feb'09-Aug'10
Sr SQL Server Developer
Wells Fargo Bank is one of the largest financial services company in US. I
have been working as SQL server Data Analyst/Developer for MTCV (Merger
Transition Customer View) Project. MTCV is Merger transition between
Wachovia and Wells Fargo customer data. This project needs high expertise
of SQL server.
ROLE:
. Responsible for running the MTCV batches in SQL server 2005.
. Involved in writing the complex stored procedures, UDFs, Triggers,
Views.
. Created SSIS packages and stored procedures in SQL server 2008
. Responsible for creating cubes using Analysis services 2005
. Developed complex ETL routines for the Merger Data warehouse
. Extensively used variables and created dynamic SSIS packages
. Responsible for creating and implementing SSIS packages on SQL server
. Responsible for creating OLAP cubes using SSAS
. Created complex SSIS packages for data transformations
. Extensively used the Derived column, Look up and Script
transformations in SSIS 2005
. Responsible for creating and testing stored procedures as per the
business requirements
. Worked extensively to create reports using SSRS2005 for MTCV project
. Responsible for transferring large data files across environments
using NDM,
. Responsible for creating SQL jobs for MTCV.
. Worked extensively on data modeling for data warehouses
. Worked extensively on both OLTP and OLAP databases
. Responsible for testing reports and MTCV application.
. Analyzing and implementing the requirements and writing SSIS packages
for data loading and complex data transformations
. Responsible for creating and updating data models using Erwin as per
the requirements
. Creating and scheduling SQL jobs for the Batch processes for
processing the merger data
ENVIRONMENT: SQL Server 2005/2008, SQL Management studio, SSIS, SSAS,SSRS,
Windows 2003 server, IIS 5.0, SFTP, .NET, Microsoft Visio 2003, SQL
Profiler 2005/2008, Platinum Erwin 4.5, Enterprise Manager 2000, Query
Analyzer 2000,Gentran,MS Access 2007
TIAA - CREF, NJ Mar'08-Jan'09
Sr SQL Server /SSIS Developer
TIAA-CREF is one of the largest financial services company in US. TIAA-CREF
offers services like Traditional and Rollover Individual Retirement
Accounts, Roth IRAs, mutual funds, after-tax annuities and life insurance.
I had been involved in upgrading LVTS6.3.5 to LVTS 6.6.3. LVTS is a Long
view Trading System used for trading Fixed Income and Equities. I worked on
upgrading database from SQL server 2000 to SQL server 2005. I'm responsible
for writing new complex stored procedures, testing Asset management reports
and testing LVTS application. I'm involved in migrating SQL server 2000
databases & DTS packages to SQL server 2005.
ROLE:
. Involved in Data loading from flat files to SQL server 2005.
. Involved in writing the complex stored procedures, UDFs, Triggers,
Views.
. Created SSIS packages and stored procedures in SQL server 2005
. Responsible for creating SQL jobs for LVTS application.
. Responsible for testing Asset management reports and LVTS 6.6.3
application.
. Responsible for implementing the Routing rules in new LVTS 6.6.3
. Responsible for creating OLAP CUBES using SSAS 2005
. Created complex SSIS packages for transforming the data and loading
into data warehouses
. Analyzing and implementing the requirements
. Implementing requirements on production servers
. Involved in creating the indexes, tuning SQL queries in procs &
views for
Better performance and testing for the heavy loads on development server.
. Good understanding of the SOX compliance (Sarbanes Oxley Act)
. Involved in modifying the existing designs as per the new requirements
. Worked extensively on migrating DTS packages to SSIS in 2005
. Worked extensively on Integration services, Analysis services in SQL
server 2005.
. Tuned the report queries & stored procedures for performance.
. Developed scripts, procedures and SSIS packages for data conversion
. Involved in redesigning the Logical and physical models using Erwin
. Testing FIX connections for trading and Microsoft Message Queues
. Worked extensively on creating file transfers across the servers using
Gentran
ENVIRONMENT: SQL Server 2000/2005, SQL Management studio, LVTS 6.3.5/6.6.3,
SSIS, SSAS Windows 2003 server, IIS 5.0, StarTeam 2008(10.1), SFTP, .NET,
Microsoft Visio 2003, SQL Profiler 2000/2005, Platinum Erwin 4.5,
Enterprise Manager 2000, Query Analyzer 2000,Gentran,MS Access 2003
CIT Financials, NJ Jun'07-Mar'08
Sr SQL Server Developer
CIT Group Inc. is a commercial and consumer finance Company with a focus on
middle- market Companies. I had been involved in project called FORKLIFT
which is acquired by CIT from CITI group. I'm responsible in loading data
into SQL sandbox and involved in data analysis. I'm responsible for
implementing new requirements, Month end & archive process. I had
remarkable achievement of rewriting entire data load process for better
performance. I'm involved in migrating SQL server 2000 databases & DTS
packages to SQL server 2005.
ROLE:
. Involved in Data loading from flat files to SQL server 2005.
. Involved in writing the complex stored procedures, UDFs, Triggers,
Views.
. Responsible for creating SQL jobs on UDBs (User databases).
. Analyzing and implementing team track tickets on production
servers
. Involved in creating the indexes, tuning SQL queries in procs &
views for
better performance and testing for the heavy loads on development server.
. Involved in requirement meetings with business analysts for gathering
the requirements.
. Worked individually for rewriting entire load process. This change
brought significant performance improvement of UDB loads.
. Involved in 24 / 7 support for FORKLIFT project which is acquired from
CITI.
. Responsible for month end and archive process of UDBs (user
databases).
. Involved in modifying the existing designs as per the new requirements
. Worked extensively on migrating DTS packages to SSIS in 2005
. Worked extensively on Integration services, Analysis services in SQL
server 2005.
. Worked extensively with off shore team in India.
. Tuned the report queries & stored procedures for performance.
. Developed scripts, procedures and DTS packages for data conversion
. Involved in redesigning the Logical and physical models using Erwin
. Involved in creating data mart.
ENVIRONMENT: SQL Server 2000/2005, SQL Management studio, SSIS, SSAS
Windows 2003 server, IIS 5.0, Visual Source Safe, SFTP, .NET, Microsoft
Visio 2003, SQL Profiler 2000/2005, Platinum Erwin 4.5, Enterprise Manager
2000, Query Analyzer,MS Access 2003
United Health Care, NJ Feb'07-May'07
Sr SQL Server Developer
United Health Care (UHC) is a diversified health and well-being company .I
worked in product development division for Health Numerics (HNR) and Data
Load Utility. HNR is a Web based application to evaluate the Risk Scores
for patients. This product has been widely used by several European
clients. I had been involved in writing complex algorithms into SQL server
stored procedures, Data migration, implementing the new requirements,
testing and coordinating with Off Shore team in India.
ROLE:
. Involved in writing the complex stored procedures, UDFs, Triggers,
Views by interpreting SAS code.
. Implemented whole Risk Scoring and Cost Model calculation in
short time.
. Involved in requirement meetings with business analysts for gathering
the requirements.
. Involved in modifying the existing designs as per the new requirements
. Worked extensively on SSIS for data transformation and data migration.
. Worked extensively with off shore team in India.
. Tuned the report queries & stored procedures for performance.
. Involved in Data modeling for OLAP system.
. Worked as a lead SQL developer for implementing Risk Module.
. Leading off shore team in India for the Builds and tracking the
project plan.
. Created dynamic queries for Data load Utility which is used for Data
migration From Access to SQL server
ENVIRONMENT: SQL Server 2000/2005,SAS, DB Artisan 7.0, SQL Management
studio, SSIS, Windows 2003 server, IIS 5.0, Visual Source Safe, Rational
Rose, .NET, Microsoft Visio 2003, SQL Profiler 2000/2005, Platinum Erwin
4.5, Enterprise Manager 2000, MS Access 2003
Deutsche Bank, NY Aug'06-Jan'07
Sr SQL Server Developer
Deutsche Bank is a leading global investment bank with a strong and
profitable private clients franchise. I worked for Long View Trading System
(LVTS), LV Web Projects - Private Wealth Management IT division. LVTS is a
trading system for Deutsche Bank clients. The Vendor for LVTS application
is Line Data. LVTS is a migration project from Sybase to SQL server with
new requirements and LV Web is a DB own project. I was involved in
migration from Sybase to SQL server and implementing the new requirements.
I was responsible for creating Windows users & desks and coding routing
logics in SQL server 2000.
ROLE:
. Involved in writing the complex stored procedures, UDFs, Triggers,
Views.
. Involved in creating the indexes for better performance and testing
for the heavy loads using SQL profiler.
. Worked extensively on Sybase
. Involved in migrating the stored procedures from Sybase to SQL server
. Involved in writing stored procedures for Routing logics for trades.
. Responsible for creating users in LVTS and maintaining the users.
. Modified Stored procedures for new requirements in LVTS.
. Tuned the stored procedures for performance.
. Involved in preparing the unit test cases for the application from
database stand point of view
. Involved in work group meetings for gathering the requirements.
. Worked with different project teams for data migrations/testing/DTS
packages.
. Good understanding of the SOX compliance (Sarbanes Oxley Act) as this
is needed for the project.
. Involved in modifying the existing designs as per the new requirements
. Writing DTS scripts and stored procs in SQL server 2000 for loading
data.
. Involved in redesigning the Logical and physical models for Long View
Application using Erwin
. Worked with DBAs for SQL Server related issues/trouble shooting,
server installations and software installation.
ENVIRONMENT: SQL Server 2000/2005,Sybase 7,DB Artisan 7.0, SQL Management
studio, SSIS Windows 2003 server, IIS 5.0, Visio 2003, Visual Source Safe,
Rational Rose, .NET, Microsoft Visio 2003, SQL Profiler 2000/2005, Erwin
4.5, Enterprise Manager 2000
Deloitte & Touch , Princeton, NJ Sep'05-
Aug'06
Sr SQL Server Developer
Deloitte delivers services in professional areas - audit, tax, consulting,
and financial advisory services. I was working for an internal project
called "Deloitte Audit". This Application facilitates business users
(Auditors) for performing audits for various industries across the globe. I
worked as a Senior SQL server Developer and Data Analyst.
ROLE:
. Involved in writing the complex stored procedures, UDFs, Triggers,
Views.
. Involved in Data modeling and designing the critical parts of the
application
. Involved in creating the indexes for better performance and testing
for the heavy loads using SQL profiler.
. Involved in migrating the stored procedures from SQl Server 2000 to
SQL server 2005
. Worked on VSTS (Visual Studio Team Suite for database professionals)
. Responsible for Package creation using Red Hat tool
. Involved in trouble shooting, performance tuning, query tuning, index
tuning using DBCC command, Wizards and SQL Profiler
. Involved in backup of Application data in the development phase
. Involved in preparing the unit test cases for the application from
database stand point of view
. Writing DTS scripts and stored procs in SQL server 2000 for loading
data.
. Worked on SQL Server Integration Services(SSIS in 2005)
. Designed the Logical and physical models using Erwin, Visio
. Worked extensively on XML in stored procedures
ENVIRONMENT: SQL Server 2000/2005, VSTS for database professionals, SQL
Management studio, SSIS Windows 2003 server, IIS 5.0, Visio 2003, Visual
Source Safe, Rational Rose, .NET, Microsoft Visio 2003, SQL Profiler
2000/2005, Erwin 4.5, Enterprise Manager 2000
Lincoln Financials, Cranbury, NJ
May'05-Sep'05
Sr SQLServer /DTS Developer
Lincoln Financials is an Asset management company, which provides various
financial products to the end customers. I am primarily involved in Data
analysis and writing ETL scripts, Stored Procedures and setting up DTS
packages for data that is coming from data sources like flat files, Oracle.
ROLE:
. Migrating the data from data sources to the target boxes.
. Responsible for converting the data from legacy systems for initial
load.
. Tuned the report queries & stored procedures for performance.
. Involved in testing the application for different data loads before
production
. Involved in writing the complex stored procedures
. Involved in modifying the existing designs as per the new requirements
. Involved in Data modeling for OLAP system.
. Writing DTS and Store proc in SQL server 2000.
. Designed the Logical and physical models using Erwin, Visio
. Installed SQL Server 2000 Servers, multi instances and service packs
for existing 7.0/2000 servers.
. Worked closely with different groups in the project.
ENVIRONMENT: Erwin 4.5, SQL Server 2000, Windows 2003 server, IIS 5.0,
Oracle, Rational Rose, .NET, Microsoft Visio 2003, SQL Profiler
Sodexho Financial Services USA, Buffalo, NY
July'03-May'05
Sr Sql Server Programmer/Application DBA
Sodexho Services USA, North America's leading provider of food and
management service is fully owned subsidiary of Sodexho Alliance S.A, the
world leader in food and management services.
ROLE:
. Tuned the report queries & stored procedures for performance.
. Defined & Implemented UDFs (User Defined functions -47) in SQL Server
2000.
. Designing databases for complex B2B, B2C applications.
. Designed the Logical and physical models for various applications
using Erwin.
. Designed the Star and snow flake schemas for Dataware house systems
. Worked with Analysis services in SQL services.
. Installed SQL Server 2000 Servers, multi instances and service packs
for existing 7.0/2000 servers
. Installed and Configured Microsoft Cluster Service and installed SQL
Server 2000 on the cluster.
. Managing database backup and recovery
. Managing database maintenance jobs and data load jobs
. Involved in trouble shooting, performance tuning, query tuning, index
tuning using DBCC command, Wizards and SQL Profiler
. Developed DTS packages to load the data from Mainframe, Access, Flat
files to SQL Server
. Developed scripts, procedures and DTS packages for data conversion
. Involved in SQL server recovery.
ENVIRONMENT: Erwin 4.5, SQL Server 2000/7.0/6.5, Windows 2000, IIS 5.0,
Oracle, Rational Rose, .NET
Marsh & Mclennan, NY Mar
'02 - Jul '03
SQL Server Programmer/Application DBA
Involved in design, development, administration and testing of Global
Brooking System for the Brokerage firm JHM&M using SQL Server System 6.5 on
Windows NT 4.0. Extensively coded stored procedures, triggers, table
creation, and indexes using SQL Server 6.5. Extensively coded SQR for
report generation.
Responsibilities:
. Installation, Configuring SQL Servers.
. Upgrading SQL Servers and perform problem determination,
. Designed the data model of various applications using Erwin.
. Performance and tuning of SQL servers and application issues related to
migration.
. Testing of applications for performance, data integrity and validation
issues.
. Writing the stored procedures, checking the code for efficiency
. Database monitoring using system tools.
. Responsible for Data model walk through to the new employees
. Responsible for the production environment
. Copied data from Sybase to MSSQL Server 6.5
. Data modeling for OLTP and OLAP systems.
Environment: SQL Server 2000/7.0/6.5, HP-UX, Win NT/95, Erwin 4.5,
Crystal Reports 7.0
Kemper Environmental Insurance Co. NJ Nov '01 - Mar '02
SQL Server Programmer/Application DBA
Kemper Environmental is one of the leading environmental insurance company
and doing the business In environmental sector all over USA. Kemper 's
entire Policy tracking starting from submission to till End of the workflow
is automated with SQL Server 7.0 and VB 6.0.
Responsibilities:
1. Created Tables, Stored procedures and Batch Scripts.
2. Used BCP to import and export data from a flat file to SQL Server
database.
. Written Instead of Triggers to update multiple base tables from views.
. Worked with DTS Package and BCP Utility for exporting and importing
data to and from SQL Server to any OLEDB Provider.
. Creation and monitoring of all SQL tasks (DTS packages) and scheduled
daily jobs using Agent Scheduler both through Enterprise Manager and
code in Visual Basic. Includes implementation of necessary batch
processes for periodic updates.
ENVIRONMENT: Erwin 4.5, SQL Server 2000/7.0/6.5, Windows 2000, IIS 5.0,
Oracle, Rational Rose, .NET
INVESTORS BANK & TRUST, New York Nov '00 to Nov
'01
SQL Server Programmer/Application DBA
INVESTORS BANK & TRUST is one of the leading providers of financial
services to institutional investors and having branches all over USA and
their entire database is running on 30 SQL Servers with a 6000-user
network.
Responsibilities:
. Creation of Databases, Tables, Indexes, Views, Database Triggers and
writing Stored Procedures.
. Testing Stored Procedures and tuning them for better performance.
. Transferring the data using BCP utility.
. Initialization of devices. Creation of logins and user ids, setting up
privileges for the protection of data.
. Created and populated summary tables based on the existing data in the
reference tables from different databases according to the client
requirements.
. Extensively worked on stored procedures to select the data from different
databases for each and every summary table to be populated and to perform
the calculations for the numeric fields and to extract the values based
on the client requirements for character fields and insert them into the
summary tables.
. Used BCP to transfer the data from summary tables to flat files.
. Involved in supporting SQL Server based applications
ENVIRONMENT: Erwin, SQL Server 2000/7.0/6.5, Windows 2000, IIS 5.0, Oracle,
Rational Rose, VB 6.0, Microsoft Visual Interdev.
CitiGroup, India Feb '00---Nov
'00
SQL Developer
The Existing Design of the E-trans Module had been tailored according to
the client requirements. Involved in modifying the existing design and
creating the Procedures, Triggers for the new design
ROLE:
. Involved in re-designing the database.
. Data Conversion within various units of the company to SQL Server 7.0
by using SQL
. Server Tools like DTS utilities.
. Extensively developed and utilized stored procedures and functions in
T-SQL.
. Worked on Database Triggers to enhance the performance of database.
Environment: SQL Server 7.0, T-SQL, Views, Stored Procedures, Triggers,
Visual Basic 5.0, and Windows NT.
Contact this candidate