SUMMARY:

• Around 8 years IT experience in Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2008, 2005, 2000 in Production, Test and Development
• Experience in installation, configuration of MS SQL Server 2000, 2005, 2008,2012
• Knowledge of Relational Database Management systems.
• Experience in Database Backup, Recovery and Disaster Recovery procedures
• Experience with SSIS, Data Transformation Services, Batch processes, Import/Export and Backup/Restore.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Experience in supporting large Databases.
• Experience in working all phases of the Software development life cycle.
• Good experience in creating SQL server Analysis Projects (SSAS) using SQL Server 2000/2005/2008.
• Hands on experience in Troubleshooting database issues.
• Good Knowledge working with Facts, Dimensions, Multi - Dimensional Cubes.
• Hands on experience on creating procedures in T-SQL
• Experience in writing and debugging Stored Procedures and triggers using
• Excellent in writing SQL queries along with stored procedures and functions
• Experience in Data Modeling using Erwin Design Tool
• Knowledge of Networking Concepts and Object Modeling Technology.
• Good interpersonal, Analytical and Communication skills and a team player
• Can-Do, Will-Do Attitude, Problem solving, Self-directed, Ability to learn new tools and use them.
• Install and Configure SQL Server 2005 on Virtual Machines.
• Experience in Object Oriented Analysis concept implementation, design and programming technical skills.

TECHNICAL SKILLS:

Languages: VB6,SQL, Web Services - C#, C, C++, Java, Perl

Operating Systems: Windows (XP NT 3.x- 4.0 ) and UNIX

Databases: MS SQL Server (2008, 2005, 2000, 7.0, 6.5, 6.0), MS Access, FoxPro, DTS, SSIS

Reporting: Crystal Report, SQL Server 2005 Reporting Services (SSRS)

DBA Tools: SQL, Erwin, TOAD, PL/SQL, T-SQL, VMware

PROFESSIONAL EXPERIENCE:

Confidential, New York

Senior SQL Server/ Business Intelligence Developer

Responsibilities:

• Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages.
• Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert).
• Involved in error handling of SSIS packages by evaluating error logs.
• Successfully extracted transformed and load data into data warehouse.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Created tabular, matrix, chart, drill down reports, parametric, cascaded reports, dashboards and score cards reports (SSRS) according to business requirement.
• Created reports by dragging data from cube and wrote MDX scripts.
• Used SSIS 2008 to create ETL packages( dtsx files) to validate, extract, transform and load data to data warehouse, data mart databases, and process SSAS cubes to store data to OLAP databases
• Improved the performance of long running views and stored procedures.
• Improved performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data.
• Identified slow performing views, stored procedures and queries using SQL Profiler, by running simultaneously while browsing the application.
• Tuned the queries using Execution plan, to get index seek from table scan and index scan. Improved the performance of many queries by 90%.
• Worked with Erwin data modeling tool
• Created Database objects including Tables, Views, Stored Procedures and UDF.
• Developed User defined functions, stored procedures, indexes, Triggers.
• Extensively involved in writing database scripts.

Environment: SQL Server 2008, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), SQL Server Analysis Services (SSAS), IIS, VB.Net, Erwin, MS Excel, XML, SQL Profiler.

Confidential, Washington DC

SQL Server Developer

Responsibilities:

• Working as SQL Server Analyst / ETL Analyst using SQL Server 2008 for CMH Project.
• Source Controlling using IBM Rational Clear Case
• Developing and Management Database for Collateral Management and Hedging
• Writing Triggers, Stored Procedures, Functions, define User Defined Data Types, TSQL, and Create and maintain physical structures.
• Working with Dynamic Management Views, System Views for Indexing and other Performance Problems
• Create / Manage Table Indexes, Query Tuning, Performance Tuning, Deadlock Management
• Defect tracking and closing by using HP Quality Center
• Design and Deploy SSIS Packages
• Creating SSIS Packages, Configure SSIS packages for different environments using DTSConfig
• Produce CSV, utilize CSV files as part of ETL Process
• Used .Net Scripts in SSIS
• Produce XML Files for Tibco (Real Time Data Transfer)
• SSIS Error Handling, Event Handling, Logging, Batch Checks for data accuracy
• Code deployments / configurations/ config management in various environments
• Implement Security, Roles, Logins, and Permissions
• Extract-Transform-Load data into SQL Server 2008 Normalized database from various sources
• Maintain Users / Roles / Permissions, Security
• Scheduling SSIS packages using Autosys, writing JIL Scripts
• Enhance existing applications to meet new business requirements
• L3 Production Support on Rotation basis
• Enhance existing stored procedures, views, functions, database objects to meet additional requirements of latest releases
• Capacity Planning DBs, Disk Requirements
• Deploy the code in various environments i.e. DEV/SIT/UAT
• Create and maintain DB Change Log to track the state of the DB in each environment(Dev, Test, UAT, Pre-Prod)

Environment: SQL Server 2008 R2, 2012, VB.NET, Oracle 10g, Sybase, Clear Case 7.1, Autosys, Share Point, SQL Server 2008 Integration Services, Quality Center 10.0, Compass Point

Confidential, Charlotte, NC

Senior SQL Server Developer

Responsibilities:

• Working as SQL Server Analyst / Developer / DBA using SQL Server 2008 for Atlas Data warehousing Project.
• Manage and update the Erwin models - Logical/Physical Data Modeling for Consolidated Data Store (CDS),
• Actuarial Data Mart (ADM), DB according to the user requirements.
• Source Controlling, environment specific script deployment tracking using TFS
• Export the current Data Models into PDF out of Erwin and publish them on to SharePoint for various users.
• Developing, Administering, and Managing corresponding databases: Consolidated Data Store,
• Database (Source for the Code/Values of the Legacy Source Systems), and Actuarial Data Mart
• Writing Triggers, Stored Procedures, Functions, Coding using Transact-SQL (TSQL), Create and maintain
• Physical Structures.
• Working with Dynamic Management Views, System Views for Indexing and other Performance Problems
• Analyze the Legacy Data, Import the data into DB that was verified and published by DMRB (Data
• Management Review Board)
• Liaison with ETL Team to convert ETL requirements as Standard Database solutions to boost the performance.
• Creating ETL mappings using Informatica Power Center
• Day to Day maintenance of DBs, Staging, Backup / Restores of DBs.
• Deployment of Scripts in different environments according to Configuration Management, Playbook requirements
• Create / Manage Files/File group - Table/Index association
• Query Tuning, Performance Tuning
• Defect tracking and closing by using HP Quality Center
• Maintain Users / Roles / Permissions.
• Capacity Planning DBs, Disk Requirements
• Creating Range and Hash(by using MOD function) Table Partitioning, Index management
• Create and maintain DB Change Log to track the state of the DB in each environment(Dev, UAT, T02, T03,
• Conversion, Pre-Prod, etc.)

Environment: SQL Server 2008 R2, Team Foundation Server, Erwin 7.3, Model Mart 7.3, Share Point Server, Informatica 8.6, Cognos, Quality Center

Confidential, Glen Allen, VA

Senior SQL Server Developer

Responsibilities:

• Generate Dash Board Reports for Internal Users using SQL Server 2005 Reporting Services and Dundas Reporting
• Application Testing, Debugging SIT, UAT, Test Clusters, Test Load Balancers
• App Testing in Development, Production, DR
• UML Use Case diagrams, Conceptual Flow Diagrams, ER Diagrams by reverse engineering the databases using Visio 2003
• Deploy various reports on SQL Server 2005 Reporting Server
• Tuning the Databases, Auditing, Dynamic Management Views
• Database Capacity Planning, Maintenance Plans, Backup, Restore
• Data Modeling, Conceptual/Logical/Physical Modeling
• Create and maintain database for Incident, Problem Tracking, Metrics
• Working with SQL, and T-SQL
• Design Reports as of Internal User needs
• Access SharePoint Server using Web Services to deploy reports on Reporting Server
• Working with Stored Procedures, functions, triggers, Views
• Involved in creating tables, stored procedures, indexes
• Creating and Maintain users
• Creating / Running jobs with SSIS packages
• Design, Creating and Deploying various SSIS Packages (for ETL - Extraction, Transformation, Loading)
• Configuring the Database Mail, Mail Operators using SQL Server 2005
• Creating Jobs, Job Notifications
• General Day to Day Database Administration
• Importing Data from various sources like DB2, Oracle, Excel, XML
• Ensuring Data Consistency, Analyzing the Data
• Detailed Documentation of all the existing and new processes, Create and Update Data Dictionaries
• Business Analysis, Understanding Requirements, Converting Business Requirements into Technical Solutions

Environment: SQL Server 2005, SharePoint 2007, .NET, Windows XP, Excel, XML, DB2, Oracle, Reporting Services(SSRS), Integration Services, Dundas Reporting, Dash Boards

Confidential, VA

SQL Developer

Responsibilities:

• Create and maintain database for Server Inventory, Performance Inventory
• Working with SQL, and T-SQL, VBA
• Involved in creating tables, stored procedures, indexes
• Creating and Maintain users
• Creating / Running jobs with SSIS packages
• Design, Develop, Deploy SSIS Packages with WMI Queries
• Importing Data from various sources like Excel, SQL Server, Frontbase
• Collecting Server Inventory data from users using InfoPath 2003/2007 into SQL Server 2005
• Creating Linked Servers to other ODBC databases like Frontbase, and import data
• Using Linked Servers
• Ensuring Data Consistency, Analyzing the Data
• Generate Dash Board Reports for Internal Users using SQL Server 2005 Reporting Services
• Backing up the Database
• Rack/Stack HP Proliant Servers, installing base operating system
• Publishing PDF Reports obtained from Report Server on to SharePoint Portal
• Deploy various reports on SQL Server 2005 Reporting Server
• Design Reports as of User Requirements
• Involved in migrating servers i.e. physical to virtual, virtual to virtual
• Installing and Configuring SQL Server 2005 on Virtual Machines
• Migrated hundreds of Physical Machines to Virtual Machines (P2V) by using VM Converter, P2V Assistant, Ghost and Virtual Machines (2.x) to Virtual Machines (3.x) - V2V by using ESX Migrator
• Conduct System Testing and functionality after virtualization
• Monitor the migrated System for next 48 hrs.
• Closely work with UAT team

Environment: SQL Server 2005, Windows 2000, 2003 Server, MS Access, Excel, Frontbase, InfoPath 2003/2007, ESX 2.X, 3.X, SSIS, Reporting Services (SSRS)

Confidential

SQL Developer/ DBA

Responsibilities:

• Create and maintain databases after logical and physical database design.
• Create database objects including tables, triggers, views, stored procedures, indexes, defaults and rule.
• Set database access privileges for different users and user groups.
• Perform optimization of SQL queries in SQL Server and Sybase system.
• Maintenance of clustered and non-clustered indexes.
• Create jobs and monitor job history for maximum availability of data and to ensure consistency of the databases.
• Develop DTS Packages to transform data from excel/Access file to SQL Server database.
• Perform database consistency checks at regular intervals.
• Monitor SQL Server activity through profiler.
• Analyzing the Data
• Develop backup & restore scripts for SQL Server as needed.
• Monitor server space usage and generate reports.
• Restore Development and UAT databases as and when needed.
• Design and implementation of database maintenance plan
• Performance optimization and normalization of database
• Tuning and optimizing queries and indexes.
• Job, Scheduling, batch, alert and E-mail notification setting.
• Maintain Disaster recovery strategies for the database and fail-over methods.
• Monitor SQL Server log files.
• Migrate data using PL/SQL T-SQL and DTS.
• Design and Develop reports in Crystal reports 8.5 for the various in-house systems.

Environment: SQL Server 2000 7.0, Windows 2000,2003 Advanced Server,.Net (Vb.Net, C#), Visual Source Safe, Excel Macros (VBA), IIS 5.0 6.0, VB 6,MS Access, Web services, Active Directory, VBScript, TCPIP,FTP,COM,COM+.