Sql Server Manager
Resume:
Summary
. More than * years of experience in the IT field which includes Database
Design,
Analysis, Development and Administration of MS SQL Server
****/****/****/*.* in Production, testing and development environments.
. Created and managed Schema Objects such as Tables, Views, Indexes, Stored
Procedures, Triggers and maintained Referential Integrity.
. Experience in SQL Server performance tuning, rewriting existing SQL
code to meet business needs and quality standards.
. Experience in assisting the Application Developers in creating conceptual
database
designs that meet the business and technical objectives of various
projects.
. Experience in Performance Tuning, Query Optimization for slow running
queries and stored procedures Experience in Data Modeling using ERwin
tool.
. Skilled in writing Transact-SQL in Query Analyzer and SQL Server
Management Studio (2008/2005) to handle database objects.
. Hands on experience in writing and debugging Stored Procedures and
Triggers.
. Transformed data from one server to other servers using tools like Bulk
Copy
Program (BCP), Data Transformation Services (DTS) and SQL Server
Integration Services (SSIS).
. Experience in Database Backup, Recovery and replication.
. Experience working with Windows NT/2000/2003 Server.
. Generated Reports using Microsoft Access 2007, SQL Server Reporting
Services (SSRS), Crystal Reports 10, Analytics Server 4.7.0.
. Worked closely with management and users on database solutions to
business
problems Defined and administered database standards, controls,
procedures and
documented the same.
. Good team player, quick learner and detail oriented, strong technical,
organizational
and report writing skills combined with self-motivation
Technical Skills
SQL Server Tools SQL Server Management Studio, SQL Server Business
Intelligence Development Studio, SQL Server
Integration Services(SSIS), Enterprise Manager, Query
Analyser, Import & Export (DTS), Profiler, Data
Profile Viewer
Databases MS SQL Server 2008/2005/2000/7.0, MS Access
2007/2003/2000, Oracle9i/10g
Languages T-SQL, PL/SQL, SQL*PLUS
Tools Erwin, MS Office 97/2000/XP/2003/2007, MS Outlook
97/2000/2003/2007
Operating Systems Windows Server 2003, Windows 2000 Advanced
Server/Professional Server, Windows NT 4.0, Windows
XP/Vista
Reporting Tool MS Reporting Services (SSRS), Analytics Server 4.7.0,
Business Objects, Crystal Reports 10/11/12.
Education
Masters in Science (Statistics), M.S. University, India
Bachelors in Science (Statistics), M S. University, India
Certification for SQL Developer from NIIT, India
Work Experience
Marshall & Swift/Boeckh MSB, Princeton, NJ
June 2008 - Present
MSB is the leading provider of property valuation and related business
information to government agencies, real estate, lending, investing, and
insurance markets. Utilizing state-of-the-art databases, systems, and
proprietary technologies, MSB enables enterprises to access and manage
large volumes of mission-critical data.
Role: Sr. Database Analyst
Responsibilities:
. Review code, packages, and report definitions created by other SQL
developers.
. Created documentation for database schemas, data flows, database object
definitions. Reverse-engineered and took responsibility for existing
database systems
. Learn systems from front to back and create/maintain tables, views,
indexes, stored procedures, ETL processes using SSIS.
. Develop appropriate indexing strategies for new and existing database
systems.
. Design and develop stored procedures, user-defined functions, and
triggers to ensure the best possible maintainability and performance.
. configure new client setup based on the source files provided by the
clients
. Develop SQL Server Integration Services (SSIS) packages for ETL
processes, and other data tasks.
. Develop database reports using SQL Server Reporting Services and other
tools as needed
. Maintain SQL Server 2000 Data Transformation Services (DTS) packages.
Port packages to SSIS as needed.
. Basic DBA tasks: backup/restore, create physical databases, database
maintenance plans.
. Work with Production DBAs to move completed database objects into
production. Assisted Database Administrators in maintenance and
troubleshooting of databases.
. Import/Export data to and from disparate data sources using SSIS.
. Created detailed design of system including Tables and Views to update
and clean the old data
. Made modifications and fine tuned existing code to meet business needs
and quality standards.
. Responsible for writing scripts for Database Tasks, T-SQL Stored
Procedures and Triggers to check the data entry and payment
verification
. Used DTS to transfer files from MS Access database to SQL Server
database
. Developed various queries as requested by the various departments for
report generation in SQL Server Reporting Services
. Designed and developed various reports for end-users
. Used visual source safe for securing the code being changed by other
user at the same time
Environment: MS SQL Server 2008, T-SQL, MS SQL Reporting Services (SSRS),
SQL Server Integration Services (SSIS), MS Access 2007, Windows 2000
Server, Visual Basic.Net, ASP.Net, Visual Source Safe, Microsoft Office
Workspace, Microsoft SharePoint, Microsoft Project
Sungard, Birmingham, AL
Feb 2007- May 2008
SWS provide Business Process Management (BPM) solution for financial
institutions to various clients across USA and Worldwide. This is workflow
solution software designed for financial domain. It will automate the
process of assigning user define task to different user define departments.
There are number of predefine action steps has to perform to get the task
done. This entire configuration is done by Administration application and
operator can get assigned task on client application so that they can work
on task to get complete. Software follows client/server architecture in
which database is MS SQL server and C++, C#. Net and JAVA base middle tier
and front end.
Role: Sr.Database Developer
Responsibilities:
. Installed and configured SQL Server 2000 and 2005, Enterprise Edition on
Microsoft
2000 Server and SQL server management studio for 2005.
. Created and Maintained Stored Procedures, Views, Triggers and Indexes
. Created database upgrade scripts requested by clients to upgrade existing
database
. Created and managed Schema Objects such as Tables, Views, Indexes, Stored
Procedures and Triggers.
. Monitored and tuned slow and long running SQL scripts and Stored
Procedures.
. Created Entity Integrity, Referential Integrity Constraints.
. Designed and developed various reports for end-users using Analytic
Server, Microsoft Access 2003
. Gathered requirements from users and internal staff and converted into
technical
Specifications
. Used Visual Source Safe for securing the code being changed by other
user at the same time
. Supported the front end developers for back end database design and
data access issues
Environment: MS SQL Server 2005/2000, Windows 2000 Server, T-SQL, Analytics
Server, Java, C++, C# .Net, Visual Source Safe, MS Access 2003, SQL Server
Business Intelligence Development Studio, SQL Server Management Studio.
Verizon Inc. Tampa, FL
Oct 2005-Jan 2007
Verizon is leading telecommunication provider in USA and I have worked
across their products iFinal, iCredit and RMI Console. I have worked on
back end SQL server 2000 and 2005 development and maintenance.
Role: Database Programmer
Responsibilities:
. Developed various queries requested by clients for report generation
. Created and maintained Stored Procedures, Triggers, Views, Indexes
. Did Testing, Debugging and Performance Tuning for slow running Stored
Procedures and SQL
Queries
. Installed and configured SQL Server 2000 and 2005, Enterprise Edition on
Microsoft
2000 Server and SQL Server Management Studio for 2005.
. Database design, creation of users databases, and helping installation of
MS SQL Client
software.
. Did coding and maintained Stored Procedures, Triggers and Views.
. Monitored and tuned long running Stored Procedures and SQL Scripts.
. Importing and Exporting of database using DTS Import, DTS Export.
. Designed and developed various reports for end-users using Analytic
Server and Crystal Report.
. Gathered requirements from users and internal staff and converted into
technical
specifications.
. Synchronized testing database with production database for better
testing.
. Monitor and schedule job in production environment.
. Created Entity Integrity, Referential Integrity Constraints.
. Did Debugging of the application and production support.
. Actively involved in migrating the application from development to
production
Environment.
Environment: MS SQL Server 2005/2000, T-SQL, Query Analyzer, Enterprise
Manager, SQL Server Business Intelligence Development Studio, SQL Server
Management Studio, C++, ASP. Net, Visual Source Safe, MS Access 2003.
GE Corporation, India
Jan 2004 - July 2005
GE Corporation Ltd. is a leading transformer and electrical services
provider company, Worked in the development team to create objects using T-
SQL in Query Analyzer for their internal projects of Sales, Service and
Accounts department automation. It was sort of small ERP for their need.
Role: SQL Developer
Responsibilities:
. Created and maintained Windows NT user profiles
. Installed and configured MS SQL Server 7.0 on NT machines
. Created and managed Tables, Functions, Indexes using T-SQL in
development and Production environment
. Created stored procedures and triggers using T-SQL in Query Analyzer
. Developed SQL Queries to fetch complex data from different tables in
remote databases using Joins
. Responsible for setting up the monitoring performance counters and
alerts on Windows NT for SQL Server database
Environment: MS SQL Server 7.0, T-SQL, and Windows NT 4.0
Contact this candidate