OBJECTIVE

• Seeking a position wif a team of talented technology professionals where I may bring my skills to teh table, and also expand upon them, in a joint effort to produce high quality software products and technologies on Database Development or Administration

SUMMARY

• 6 years of experience in Creating complex SQL Stored Procedures, Triggers and User Defined Functions to manage incoming data as well as to support existing applications.
• Expert in planning, modeling, designing, developing, implementing, administering, and maintaining Microsoft SQL Server 2008/2005/ 2000 and Access 2007 databases.
• Highly proficient in teh use of T - SQL for developing complex stored procedures, triggers, tables, user defined functions, relational database models and data integrity, and SQL joins.
• Experienced in logical and physical database design and development, data conversion, normalization and data modeling using SQL Server Enterprise manager.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Implementation of .NET (C#) Web application, SOAP services, and WPF utilities
• Expertise in working on all activities related to teh development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS) and SSIS wif MS SQL 2008/2005.
• Experienced in generating on-demand and scheduled reports for business analysis or management decisions using MS SQL Server Reporting Services 2008/2005 (SSRS).
• Expert in writing parameterized queries for generating tabular reports and sub reports using global variables, expressions, and functions, sorting teh data, defining data sources and subtotals for teh reports using SSRS 2008/2005.
• Expert in designing complex reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad-hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Strong experience in stored procedure/TSQL coding, performance tuning, and query optimization. Expert at installation, upgrade and configuration of Microsoft SQL Server and databases.
• Expert in using tools like MS SQL Profiler, index tuning wizard, windows performance for monitoring and tuning SQL Server performance. Extensive knowledge in developing and implementing disaster recovery model, and replication models.
• Experienced in creating Sub queries, CTEs and Distributed queries.
• Expert at Microsoft SQL Server database administration including planning, backup, and recovery strategies.
• Experienced in development/staging/production environments and used Team foundation server /visual source safe for version controls and communication's well as defining Actions, translations and perspectives.
• Excellent communication and inter-personal skills wif ability to develop creative solutions for challenging client needs using agile methodologies.
• Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.

TECHNICAL SKILLS

• MS SQL Server 2008/2005/2000
• SSIS 2008/2005
• SSAS 2008/2005
• SSRS 2008/2005
• T-SQL
• PL/SQL
• MS Visual Studio 2008/2005
• MS Access 2007/2003
• Windows 9x/NT/2000/XP/Server 2003
• Unix
• Linux
• RedHat
• MS SQL Profiler
• SQL Query Analyzer
• C
• C++
• Visual Basic 6.0
• .Net
• VB.NET
• Visual C++
• HTML
• XML
• VBScript
• JavaScript
• MS Office 2007/2003
• MS Visual SourceSafe
• Adobe Suite CS4
• Flash Action Script
• Shell Scripting
• Routing Protocols RIP
• OSPF
• IGRP
• EIGRP
• IP

PROFESSIONAL EXPERIENCE

Confidential, Norman, OK

MS SQL Server Developer/ System Administrator

Responsibilities:

• Administration of MS SQL database server and IIS web server
• Implementation of .NET (C#) Web application, SOAP services, and WPF utilities
• Design and Implementation of database front-end using MS Access (VBA)
• System Administration of MS Windows network utilizing Active Directory
• Administration of Perforce source control management system.
• Setting up modular storage arrays and server hardware running Linux
• Server virtualization technologies such as Vmware Server
• Managing OpenLdap, Kerberos, NFS, Apache, MySql RDMS, and Linux/Windows integration wif Samba NT Domain Controller
• POP3 and Sendmail email server configuration
• Firewall configuration

Confidential, Oklahoma City, OK

MS SQL Server Developer/ SSIS/ SSAS Developer

Responsibilities:

• Used teh SSIS to migrate databases such as Access and SQL Server database, flat files to centralized IT destination.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2005/2000 environment, and deploy teh data. Used Event Handlers for Exception Handling in SSIS packages.
• Used SSIS transformations to implement teh Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Generated reports on wealth information, account information, research reports using ad-hoc reporting to be used by teh clients and advisors.
• Identified and worked wif multivalued parameters for parameterized reports in SSRS.
• Created Queries in T-SQL, Stored Procedures, and Views to store teh data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to teh tables dat has least updations to improve teh query performance.
• Performed T-SQL tuning and optimization of queries for reports dat took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.
• Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on teh fly.
• Scheduled, maintained, and supported teh distribution and access to reports through Crystal Server.

Environment: MS SQL Server 2005/2000, SSIS, SSRS, T-SQL, Crystal Reports 10, Visual Studio 2005, MS SQL Profiler, MS Office 2007.

Confidential, San Jose,CA

MS SQL Developer

Responsibilities:

• Created stored procedures, scripts, created SQL Database, tables, stored procedures, indexes, and views,
• Created User Defined Functions, Stored Procedures, and Triggers.
• Suggested creating Clustered and Non Clustered indexes on tables.
• Used DTS for data population from different sources and create DTS packages for data conversions and load data from flat flies or excel files.
• Fine tune complex SQL queries and Stored Procedures to increase performance.
• Created & used stored procedures for database transactions in SQL Server.
• Created database maintenance plans for teh performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Experience in Database Capacity Plan.
• Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.
• Worked on DTS Package, DTS Import for Transferring data from Oracle and Lotus notes.
• Looked at teh reports and fixing bugs in stored procedures, tables and ETL process.
• Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler.

Confidential, MOUNT LAUREL, NJ

Sr MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Actively participated in interaction wif users, team lead, DBAs and technical manager to fully understand teh requirements of teh system.
• Created ETL metadata reports using SSRS, reports include like execution times for teh SSIS packages, Failure reports wif error description.
• Developed an automated report subscription process using SSRS.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts using SSRS.
• Created Stored Procedures and T-SQL code for complex business logic.
• Created Views to restrict access to data in a table.
• Optimized teh database by creating various clustered, non-clustered indexes.
• Developed ETL jobs to load information into Data Warehouse from different relational databases and flat files.
• Configure SSIS Package for run time Parameters and Configuration file.
• Developed some scripts in C#.Net used in ETL Process dat works as transformation.
• Created complex scripts to do chucking and massaging of legacy data in staging area of DTS and SSIS package.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading teh data into teh Data warehouse.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using DTS, BCP
• Enhanced teh functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services.
• Implemented cell level security in cubes to restrict users of one region viewing data of another region using SSAS.
• Involved in writing MDX queries and manipulating teh multidimensional data in OLAP cubes.
• Worked wif Installation/Management of MS Team Foundation Server and TFS Migration processes
• Used BCP command and T-SQL command to bulk copy teh data from Text files to SQL Server and vice versa
• Implemented Type 2 Slowly Changing Dimension to maintain Dimension History.
• Worked extensively wif Slowly Changing Dimension and lookup Transformation for implementing Insertsand Updates.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task.
• Created Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Designed and developed matrix and tabular reports wif drill down, drill through using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).

Environment: MS SQL Server 2008/2005, SQL Server Reporting Services (SSRS 2008/2005), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), OLAP, XSLT, XML, C#, ASP.Net, Informatica, MDX, Shell Scripting, DTS, MS Visio, UDB, Erwin