Sql Server Data
Resume:
Shefali Setia
*******.*****@*****.***
EMPLOYMENT OBJECTIVE
Programmer Analyst positions in which I can help a dynamic organization
achieve its mandate, by utilizing and building-on my three years of
experience in diverse application areas performing: systems analysis,
development, maintenance, and project co-ordination functions.
Summary
Over 3 years of experience in the field of software development.
. Working experience with Microsoft SQL Server 2005/2008, OLTP as a
Database Developer.
. Experience in Database Architecture, Design, Coding, Implementation
and Production Support.
. Excellent knowledge in RDBMS concepts and constructs along with
Database Objects creation such as Tables, User Defined Data Types,
Indexes, Stored Procedures, Views, User Defined Functions, Cursors and
Triggers.
. Experience with SQL Server 2000 and MS SQL Server 2005 and worked
extensively on Integration services (SSIS), Reporting services (SSRS)
and Analysis services (SSAS).
. Expert in writing T-SQL in SQL Server Management Studio and Query
Analyzer to handle database objects, working on DTS, SSIS, SSRS, SSAS,
Data Cleansing, Data Scrubbing and Data Migration.
Technical Skills
Operating Systems: Windows NT/2000/XP/Vista Enterprise, UNIX,
Linux, Solaris
RDMS: MS SQL Server 2000/2005/2008, Oracle 8i/9i
Database Tools: SQL Query Analyzer, SQL Enterprise Manager,
Management Studio, SQL Server Business Intelligence
Development Studio (BIDS),SQL Server Analysis
services ( SSAS), Database Engine Tuning Advisor
ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration
Services (SSIS), Import Export Data, Bulk Copy
Program (BCP)
Reporting Tools: SQL Server Reporting Services (SSRS)
Data Modeling: MS Visio
Programming Languages: C, C++, Java, JSP, HTML, VB, UML, Perl
Application Packages: MS Office suite (Word, Excel, Access, Visio,
Power Point, Outlook,
Project)
Key Areas of Expertise
Functional Analysis
Excellent ability to perform independent preliminary analysis of user
requirements and develop effective solutions that satisfy user
requirements.
Software Development and Testing
Extensive experience in designing, developing, testing and implementing a
variety of IT applications in a number of different development,
operational, and industry environments.
Project Coordination
Proven ability to perform as a technical leader; training and directing
small to medium size project teams engaged in developing IT applications
for client organizations.
Software Maintenance and Support
Significant experience in performing day-to-day maintenance and support of
existing applications in parallel with the analysis, design, development
and co-ordination activities for new applications.
Education
Masters of Science from New Jersey Institute of Technology, Newark, NJ
Bachelors of Technology from Rajasthan University, Jaipur, India
Professional Working Experience
New Jersey Institute of Technology, Newark, NJ September
2008-Januray 2010
University Computing Services
Programmer and Analyst
Responsible for programming, unit testing, user acceptance testing, and
implementation in a project involving reengineering and development and
maintenance.
Activities included: clarifying and editing analyst specifications, coding
and user acceptance testing, modifications, and final application
implementation.
Roles and Responsibilities:
. Creating Database objects - Tables, Views, and Functions and
developing Procedures for implementing application functionality at
the database side for performance improvement.
. Created complex T-SQL Queries, Stored Procedures and Functions to
support efficient data storage and manipulation.
. Involved in Data base modeling using dimensional models and designed
using star and snow flake schemas and also involved in Data Base
Normalization.
. Involved in Migration of data from SQL Server 2005 into SQL Server
2008 Data Ware House using SSIS Packages.
. Created dynamic packages in SSIS to meet the requirements and created
Database Maintenance Plans for the various data Sources and
centralizing the data using SSIS.
. Used Error handling and Error logging techniques to capture data in
SSIS in various ETL solutions.
. Created and managed SQL Server login, database users and Roles.
. Performance tuning of SQL queries and stored procedures using SQL
Profiler and Index Tuning Wizard.
. Documented all processes involved in maintaining the database for
future reference.
Enviornmet: MS SQL Server 2008, 2005, SSIS, SSRS, SSAS, SQL Profiler.
Magus Infotech, Pune, India August 2007-
July 2008
Client: Life line Insurance
Database Developer/DBA
Life line insurance company acts like a third party insurance company to
the customers. The system was created to capture the data of the customers
and provide various letters, reports and graphs required by management. The
data submitted by life line insurance to the main insurance company was
also captured in the database and analyzed
Roles and Responsibilities:
. Actively involved in gathering User Requirement and Online System
Specification.
. Developed ER diagrams and mapping the data into database objects as
well as scheduled jobs for backup, and created alert for error
reporting.
. Created views as required by front end Java developer for easier
implementation on web pages, and triggers on those views to provide
efficient data manipulation.
. Created stored procedures and functions to support efficient data
storage and manipulation.
. Transformed data from various data sources by creating various DTS
packages.
. Optimized the performance of queries with modification in index system
for online system.
. Monitored the growth of the database objects for capacity planning.
. Successfully applied schema change scripts to existing objects to
synchronize with changing business rules.
. Participated in different testing and debugging of the system.
. Created and managed SQL Server login, database users and Roles.
. Used SQL Server Reporting Services to generate different types of ad-
hoc reports.
Environment: MS SQL Server 2005, Visual Basic6.0, MS Office.
Contact this candidate