SUMMARY

• Five plus years of IT experience which includes analysis, design, development, testing and implementation of applications, reports and databases (MS SQL Server 2008/2005/2000 ) in development and production environments.
• Extensive experience developing and implementing Microsoft SQL Server Integration Services (SSIS) and Microsoft SQL Server Reporting Services (SSRS) for data warehouse and data mart solutions.
• Extensive experience in writing and debugging complex Store Procedures, Cursors, Triggers, Inner Joins & Outer Joins, Views and User - defined functions (UDF) and Optimizing complex Transact-SQL queries.
• Installed, configured and maintained SQL Server Integration Services (SSIS).
• Experience in Migration of DTS packages to SSIS and Executing DTS packages from SSIS.
• Experience in creating packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files and OLEDB source systems.
• Experience designing and developing applications using Visual Basic 6.0.
• Experience in Data modeling like Logical data modeling and Physical data modeling.
• Good knowledge with .NET framework using ASP.NET, C#, XML and ADO.NET database connectivity.
• Experience in the entire phase of Software Development Life Cycle (SDLC) that includes Analyzing, Designing, Developing and Testing of data.
• Experience in creating new reports and ad-hoc reporting in SQL Server Reporting Services (SSRS).
• Experience in migration of data from Excel, DB2, Teradata, Sybase, Flat file, Oracle to MS SQL Server using BCP and DTS utility and Extracting, Transforming and Loading of data using SQL Server DTS/SSIS.
• Experience in supporting large databases up to a size of five terabytes.
• Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Excellent communication skills that have been put in use to understand client business requirements and converting the same into system fulfilling business needs.
• Experience Working with Development and Production 24/7 Environments including scheduled emergency night and weekend work.

TECHNICAL SKILLS

• MS SQL Server 2008/2005/2000
• Oracle 9i/8i
• DB2
• MS Access
• Sybase
• T-SQL
• PL/SQL
• C
• C++
• Java
• XML
• HTML
• DTS
• SSIS
• SSRS
• TOAD
• ERWIN and MS Visio
• Windows NT
• Windows 2000
• XP
• UNIX
• MS VISUAL STUDIO 2005
• VB.NET
• C#.NET
• ADO.NET
• ASP.NET

PROFESSIONAL EXPERIENCE

Confidential, Grand Rapids, MI

SQL Server Developer/BI Developer

Responsibilities:

• Involved in designing, implementing and maintaining application database code objects, such as stored procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Involved inQuery Optimizationsand Performance Tuning for the Stored Procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Using SQL Server Profiler to trace the slow running queries and Optimizing SQL queries for improved performance and availability.
• Created user logins with appropriate roles, dropping logins, monitoring the user accounts, creation of groups, updating tasks and calendars.
• Implementing techniques like backups, restore, clustering, replication and standby databases to ensure higher availability in Production Environment.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Updated functional specification and technical design documents.
• Used the UDM Model to create Named Queries in the Data Source View.
• Scheduled the SSIS packagefor migration of data from old system to MS SQL 2008.
• Designing SSIS Packages to transfer data from various sources like Text Files, SQL Server, OLE DB, Excel and Access to SQL Server using BIDS 2008.
• Designing and Developing ETL packages (.dtsx files) in SSIS to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Using various SSIS tasks such as Conditional Split, Derived Column on the data retrieved, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
• Interacted with business users and business analyst to understand reporting requirements and prepared System Requirement Specification Document.
• Developing reports in SSRS 2008, with various functionalities like drilldown, cascading prompts.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Used scheduler to schedule a selected report to be run on a particular date.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• In-depth understanding of all stages of software development life cycle (SDLC).
• Involved in Unit testing integrated testing and System testing.
• Worked on conversion of MS Access applications to SQL Server/.NET.
• Used MicrosoftTeam Foundation Serveras a version control tool.
• Provide 24 X 7 supports to all production, development and staging.

Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SSRS, T-SQL, Excel, XML, Windows 7, Team Foundation Server, MS Access, C#, ASP.Net, Query Analyzer, Profiler.

Confidential, Franklin Lakes, NJ

SQL Server Developer/BI Developer

Responsibilities:

• Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams.
• Created DDL Scripts for generating Tables, Views, Functions.
• Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Worked extensively in writing and debugging complex stored procedures, cursors, triggers, Inner Joins, Outer Joins, views and User-defined functions.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Generating reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear viewing the reports using SSRS 2008.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
• Designing and developing Code for Standard Tabular type reports, including Drill Down and Drill through Functionality and Graphical presentations such as Charts and Dashboard type metrics for effective analysis.
• Scheduling Jobs, Backups and Restore database.
• Designing and building data load procedures using MS SQL Server.
• Performance: Analyzed database performance with SQL Profiler and DTA to optimize existing stored procedures and did performance-tuning of indexes to enhance performance of scripts and stored procedures.
• Providing 24*7 on-call support for the Critical issues.

Environment: MS SQL Server 2008/05, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T-SQL, MS Access, Excel, C#, ASP.Net, Query Analyzer, Profiler, Windows 2003/2000/XP

Confidential - Louisville, KY

SQL Server Developer/BI Developer

Responsibilities:

• Created views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected.
• Generated and debugged complex stored procedures and functions for better performance and flexibility.
• Optimized SQL queries for efficiency and assisted the front end developer with their queries and procedures.
• Scheduled and maintained routine jobs and alerts.
• Performed performance tuning by studying execution plan, analyzing indexes and using SQL Profiler.
• Actively supported business users for change requests.
• Established joins and created indexes to assimilate client information from multiple tables.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using ER Win.
• Responsible for creating the reports based on the requirements using SSRS 2005.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Identified and defined the Datasets for report generation.
• Wrote queries for drill down reports.
• Maintained data integrity by performing validation checks.
• Created T- SQL queries for data retrieval.
• Fine-tuned the database objects and server to ensure efficient data retrieval.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Designed and build data load procedures using MS SQL Server.
• Involved in Performance tuning with the help of Profiler Tuning advisor & windows performance monitor and fine-tuned the logic in stored procedures, Functions and Triggers for Optimum performance.
• Involved in resolving Dead Lock issues and Performance Issues.
• Run DBCC consistency checks and updated statistics for databases on regular basis.
• Building and maintaining SQL scripts, indexes, and complex queries for data analysis and extraction.
• Installed, configured and maintained SQL Server Integration Services (SSIS).
• Develop the ETL for the warehouse and other applications using SSIS.
• Imported data from Text Files, Excel Spreadsheets and OLEDB sources into SQL Server 2005 databases using SSIS.
• Developed New SSIS packages based on business requirement and also executed DTS packages from SSIS.
• Migrated DTS packages to SSIS Packages.
• ConfigureSSISPackage for run time Parameters and Config file.
• Provided 24/7 support to all production, development and staging.
• Developed ASP.Net with C# applications to support user offices.

Environment: SQL Server 2005/2000, SQL Server Integration Services (SSIS), SSRS, Visual Basic 6.0, DTS, T-SQL, Oracle 9i, Active X, C#.NET, XML, MS-Access, Windows 7/2003/XP, Erwin

Confidential, East Hanover, NJ

SQL Server Developer/BI Developer

Responsibilities:

• Participated in database logical and physical design to fit new business requirement and implemented new design.
• Design/Build Extract Transform Load procedures in SQL Server 2000 to import/export data feeds to/from data warehouse.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database and implemented stored procedures and Cursors according to the requirement.
• Involved in upgrading the SQL Server 2000 to SQL Server 2005.
• Imported, standardized and validated data on a timely basis using DTS.
• Enhanced the existing packages and also created new DTS packages which executed stored procedures that would populate tables and perform other data manipulation tasks.
• Performed data migration using Data Transformation Services (DTS) and bulk insert.
• Configured the DTS packages to run in periodic intervals.
• Migrated few objects from SQL Server 2000 to SQL Server 2005.
• Worked with SSIS to import, export and transform the data between the linked servers.
• Created few Packages using SQL Server Integration Services.
• Querying of source and target database for unit testing.
• Involved in creating different types of reports such as sub reports, Ad-Hoc reports and chart (for trend analysis) for easy-to-use benefit information system by using Crystal Reports.
• Modified the format and structures of the reports according to the end-user requirements.
• Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.
• Involved in optimizing code and improving efficiency in databases including assigning proper indexes, Re-indexing, Recompiling stored procedures and performing other maintenance tasks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Supported front-end applications under .Net framework.
• Provided on - call 24/7 provide support.

Environment: MS SQL Server 2005, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Oracle, VB.net, MS Visio, OLAP Services, MS Access, Excel, Query Analyzer, Profiler, Windows 2003/2000/XP

Confidential

.Net Developer/SQL Developer

Responsibilities:

• Actively involved in Gathering and analyzing client requirements and information about manual system to implement into TCMS
• Estimated the cost and the time of period to develop TCMS project
• Designed logical and physical database and overall structure of TCMS
• Implemented the presentation layer in the ASP.NET web-forms.
• Created stored procedures, tables, view, functions and triggers in the SQL Server 2005
• Implemented database standards and naming convention for the database objects.
• Implement and maintain database security.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Maintaining records in Excel Spread Sheet and exporting data into SQL Server Database using SQL Server Integration Services.
• DDL Scripts for generating Tables, Views, Functions.
• Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.
• Scheduling Jobs, Backups and Restore database
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Analyzed and designed software and database solutions.
• Optimized the performance of queries by fine tuning the T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, and normalized tables.
• Created DTS packages for uploading of various different formats of files into SQL Server 2000 using Data Transformation Services.

Environment: Asp.Net 1.0, VS.Net 2003, C#, Ado.Net, XML, MS Visio, SQL Server 2005, MS-Excel, Flat Files, Windows 2003/2000,SQL Profiler, BCP, Management Studio, Query Analyzer, SQL, T-SQL.