SUMMARY

• Close to 6 years of experience wif teh 32bit, 64 - bit Microsoft SQL SERVER as Developer in OLTP and OLAP wif Production, Development and Testing in Clustered and Stand alone Server Environment.
• Strong SQL Developer skills. Expert in writing/Creating Generic Stored Procedures, Functions, Database Triggers, tables, indexes, views, sequences using SQL and PL/SQL.
• Expertise in creating and managing user tables- namespaces, data types, and data dictionaries.
• Designed Conversion and Interface Programs using PL/SQL procedures and packages.
• Extensive experience and noledge in Oracle Forms and Reports, SQL Developer, PL/SQL Developer and tools.
• Excellent working and conceptual noledge of Oracle SQL, PL/SQL, Oracle Forms 6i /9i, Oracle Reports 6i / 9i.
• Extensively worked on SSIS for transferring data from Heterogeneous Database ( OLE DB, Excel, Flatfile,Tables ) to create Data Marts.
• Used all teh major Data Flow Transformations ( Aggregate, character map, condition split, data conversion, derived column, Data Conversion, Lookup, Fuzzy lookup, Merge, Merge Join, Multicast, OLEDB command)
• Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors, Temp tables and Dynamic SQL queries.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of teh database in ERWIN and MSVISIO.
• Experience in analyzing Locks, Dead Locks and Handling teh Isolation Level and Concurrency Effects.
• Experience in comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Expert in analyzing teh execution plan and index management for better Query Optimization.
• Experience in using DMV and dynamic management functions (DMF) Of Tables, Triggers, Stored Procedures etc for finding out long running queries.
• Auditing of database for users transaction, login and database action and removing orphan users.
• Worked wif a team of business analysts, data architects, application developers, ETL developers and testers.
• Experience in Software Development Life Cycle (SDLC), Analyzing and Designing systems using Structured Methodologies (ERD, DFD) along wif extensive noledge of Relational Database Management Systems wif in-depth of T-SQL.
• Actively involved in management of Change Control Requests.
• Excellent Team Player. My objective was to deliver projects wifin scope, time and costs while following department standards, methodologies and guidelines.
• Highly motivated, self-starter wif excellent communication, presentation and interpersonal skills, can perform well both independently and wif a team, always willing to work in challenging and cross-platform environments.

TECHNICAL SKILLS

Databases: MS SQL Server 2000, MS SQL Server 2005, Oracle9i/10g

Operating System: Windows XP/2003/2000/.

Programming Languages: C, C++, HTML, PL /SQL.

Application Development: Oracle 9i/10g Forms and Reports

Office Tools: PowerPoint, Excel, Word, MS Office

Concepts: Object Oriented Programming (OOPS),Database Management System (DBMS)

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, Indiana

SQL Analyst/ Developer

Responsibilities:

• Created and modified SQL scripts for creating various schema objects - tables, views, synonyms, integrity constraints, indexes and views in teh database.
• Designing PL/SQL block modules for classified groups of SQL queries
• Involved in teh implementation of logical and physical database schema changes.
• Developed Stored Procedures, Views, Triggers and Complex Queries.
• Designed and scripted tables, set table relationships, keys and indexes.
• Maintained data integrity by performing validation checks.
• Database Administrator, Database Programming.
• Administered SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users.
• Rebuilt indexes at regular intervals for better performance
• Involved in trouble shooting and fine-tuning of databases for better performance and concurrency
• Monitored and modified Performance using execution plans and Index tuning.
• Recovered databases from backup in disasters
• Maintained database consistency wif DBCC at regular intervals
• Used DTS packages to move logins and jobs from one server to another server.
• Administered SQL Server configuration settings.
• Performed installations & performance tuning, manage user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.
• Designed & developed data models and performed forward and reverse engineering using data modeling tools like ERWIN.

Environment: SQL Server 2005 Enterprise Edition, T-SQL, PL/SQL, Windows XP, Erwin.

Confidential - Wilmington, DE

SQL Analyst / Developer

Responsibilities:

• Installed and configured MS SQL Server and Clients.
• Involved in Database design, Logical and Physical Data modeling using Erwin. Transformed logical model into Physical SQL Server Database. Created SQL tables using scripts and Erwin Forward Engineering Utility.
• Created and Managed schema objects such as tables, views, clusters, indexes, procedures, triggers and maintained Referential Integrity
• Performed Data migration (import & export BCP) from Text to SQL Server. Data transfer using BCP and DTS
• Managed Disk space, memory and User connections
• Generated Script files of teh databases whenever changes were made to stored procedures or views.
• Excellent noledge in Import / Export using DTS and BCP utility.
• Performed query tuning and reduced response time.
• Performed query plans and enforced indexing in each and every query
• Designed DTS packages to refresh data on Development and QA/Staging
• Wrote dynamic stored procedures to create Database Roles and grant permission to roles and adding logins to specified roles
• Designed new schema for data partition and creating Partition views for better performance.
• Implemented Performance Tuning, Analysis, tuning and optimization of SQL Server Applications using performance monitor.
• Assisted teh SQL Developers in query tuning and optimization.
• Created updatable partitioned views.
• Created Stored Procedures and triggers to perform automated rules and updation of related tables.

Environment: MS SQL server 2000, Windows XP, Enterprise manager, Query Analyzer, SQL profiler.

Confidential -- Basking Ridge, NJ

SQL Analyst / DBA

Responsibilities:

• Database Administrator, Database Programming.
• Rebuilt indexes at regular intervals for better performance.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Involved in trouble shooting and fine-tuning of databases for better performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Maintained database consistency wif DBCC at regular intervals.
• Used DTS packages to move logins and jobs from one server to another server.
• Coding which involved development of stored procedures, functions, triggers and packages.
• Administered SQL Server configuration settings.
• Monitored SQL server performance using profiler to find performance and deadlocks.
• Responsible for Maximum performance and uptime in production environment.
• Analyzed long running slow queries and tune teh same to optimize application and system performance.
• Performed daily tasks including backup and restore etc by using SQL Server 2005 tools like SQL.
• Performed installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.
• Designed & developed data models and performed forward and reverse engineering using data modeling tools like ERWIN.

Confidential -- Basking Ridge, NJ

SQL Analyst / DBA

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio (2005), SQL Server Enterprise Manager (2000) and Query Analyzer to Administer SQL Server.
• Created Stored Procedures, Triggers, Views and Functions for teh Application.
• Migrated SQL server 2000 databases into SQL server 2005 databases.
• Migrated DTS packages into SSIS packages
• Maintaining SQL Script for creation of Database Objects.
• Planned teh Complete Backing up of Database and Restoring teh Database from Disaster Recovery.
• Used DTS packages to move logins and jobs from one server to another server.
• Optimized queries tuned and monitored server performance.
• Created views as per design needs.
• Identifying teh database tables for defining teh queries for teh reports.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Monitoring SQL server performance using profiler to find performance and deadlocks.

Environment: T-SQL, MS SQL SERVER 2000/2005, Management Studio, Profiler, Visual Studio 2005, Windows Server 2003, SSIS.

Confidential

SQL Analyst

Responsibilities:

• Developed teh inbound and outbound file interface wif various subsystem
• Menu driven programs for various subcomponents of time card and payroll Management system
• Various MIS reports to track
• Time sheet tracking by cost center / work center / Project, etc
• Expense report tracking by cost center / work center /project, etc
• Vacation management reports and process
• Used SQL programming for stored procedures and queries to interact wif SQL server.
• Manage database performance, capacity, replication, backup and security.
• Created SQL scripts for creating various schema objects - tables, views, synonyms, integrity constraints, indexes and views in teh database.
• Designed and created databases, tables, views, store procedures and triggers.

Environment: SQL Server 2005 Enterprise Edition, Windows XP.