SUMMARY

• Over 7 years of experience in Software Systems analysis/ design/ development/ testing/ performance optimization and documentation.
• Extensive experience in developing Stored Procedures, Views, Triggers and Complex Queries on SQL Server 2000/2005/2008 .
• Highly proficient in the use of SQL Server and T - SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity, SQL joins and query writing.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS) and SSIS with MS SQL 2008.
• Experienced in working with .NET technologies C#, ASP. NET AND WPF.
• Experienced in with developing Object Oriented programming applications.
• Excellent in High Level Design of DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Marveled in Query Optimization, Performance tuning.
• Experienced in data loads, database integration/conversions, performance tuning and optimization.
• Experienced in SQL Server Reporting Services.
• Developed and worked on large-scale enterprise projects involving complex business case functions, web integration, and data management.
• Strong experience in T- SQL development with MS- SQL.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, and SQL Profiler.
• Experienced with DTS/ SSIS applications moving data between different data sources.
• Exposed to each of the phases of Software Development Lifecycle (SDLC) with the ability to work as a team member as well as an individual performer.
• Outsourced US projects to Jamaica.
• Highly motivated, reliable, analytical, problem solver and troubleshooter with strong attention to detail.
• Experienced in data modeling tools, e.g., Visio.
• Capable of working under pressure and achieving milestones.

TECHNICAL SKILLS

• MS SQL Server 2000/2005/2008
• SQL Analyzer
• SQL Enterprise Manager
• Confidential Management Studio
• Query Analyzer
• SQL profiler
• Visual Studio 2005
• C#
• PHP
• ASP.NET
• Java
• SSRS
• SSIS
• Confidential Products
• MS Word
• MS Excel
• MS Access
• MS Power Point
• MS Project
• HTML

PROFESSIONAL EXPERIENCE

Confidential, SantaClara, CA

MS SQL Server Developer/SSAS/SSIS/SSRS

Responsibilities:

• Performance tuned stored procedures and Ad hoc queries using table and query hints.
• Wrote complex T-SQL queries using Rank functions, CTE, Sub queries etc.
• Worked with large databases and tables >1TB.
• Created and modified partitioned tables and partition functions to improve query performance.
• Experienced with analyzing SQL Server estimated and actual query execution plans.
• Experienced with creating complex Scalar, In-line and Multi-Statement UDFs.
• Experienced with Confidential TFS for version control and working with Star schema.
• Understood the various complex reporting requirements and created web reports using SQL Server Reporting Services.
• Designed, developed, and deployed new reports and enhancements to existing Reports, for various applications as assigned.
• Created drill through reports, sub reports, dynamic reports using parameters.
• Created stored procedures, triggers, cursors, tables, indexes including covered indexes and views and other SQL joins and statements for applications.
• Wrote linked server queries to extract data from Teradata.
• Designed SSIS Packages to transfer data between servers and databases, performed transformation and configured mapping settings.
• Responsible for creating Packages using SSIS that imported large volumes of data to text files.
• Carried out data quality checks of exported data.
• Added configuration files to Packages, so that various properties like variables, connection managers could be changed when moving the Package from one environment to another

Confidential, Redmond, WA

MS SQL Server Developer/SSAS/SSRS/SSIS

Responsibilities:

• Created databases.
• Developed and implemented Stored Procedures, Triggers, Functions, CLR objects.
• Executed traces using SQL Server Profiler.
• Performed performance tuning.
• Created SQL Server logins and database users.
• Assigned permissions to database users.
• Performed database maintenance task such as database consistency checks backups and Restores.
• Created Stored Procedures and views in SQL Server using T-SQL to collect data for Server Reporting Services 2005.
• Developed reports using Server Reporting Services 2005.
• Designed, developed, modified and enhanced the database structures and database objects.
• Designed and implemented User interface using ASP.NET,C# and WPF
• Debugged issues with C# code and logic to meet user requirements.
• Application testing.
• Prepared necessary documentations required to conform to the SDLC.
• Worked with Data Transformation Service (DTS)/SSIS functionality of SQL Server database.
• Created test procedures for validations.
• Query tuning and database optimization.
• Worked with CLR objects to code complex requirements.
• Worked with xml data, including storing xml in SQL server and manipulating and retrieving this xml data as required.
• Automated informational emails (HTML and other formats) based on triggers in the database.
• Documented database schema.

Confidential, Chicago, IL

MS SQL Server Developer

Responsibilities:

• Designed and scheduled execution of DTS packages.
• Designed and implemented databases.
• Coordinated and discussed with the users to gather requirements.
• Developed and implemented Stored Procedures, Triggers, and Functions.
• Carried out database performance tuning.
• Created SQL Server logins and database users.
• Assigned permissions to database users.
• Performed database maintenance task such as database consistency checks and backup.
• Documented backup and recovery plans.
• Created Stored Procedures and views in SQL Server using T-SQL to collect data for the crystal reports.
• Developed reports using SQL Server Reporting Services 2005.
• Created adhoc reports and sub reports and deployed those reports.
• Used Business Intelligence Development Studio to build reports using the wizards and designers, and deploy them to Report Server.
• Modified report content and export reports in multiple formats based on user input.
• Created matrix reports, drill down reports and developed reports with graphs.
• Created reports with different type of properties like chart controls, filters, SQL parameters etc.
• Designed, developed, modified and enhanced the database structures and database objects.
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Worked with large databases with high transaction volume.
• Prepared necessary documentations required to conform to the SDLC.
• Worked with Data Transformation Service (DTS)/SSIS functionality of SQL Server database.
• Designed both logical and physical data models.
• Created test procedures for validations.
• Handled development escalations that require data manipulation on high volume production servers.

Confidential, Janesville, WI

MS SQL Server Developer

Responsibilities:

• Gathered user requirements, drafted specifications, designed, documented and wrote test script for testing of all the report.
• Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Carried out performance tuning.
• Created reports that included formatting options such as Grouping, Sorting, Drill-down, Parameter prompts.
• Modified report content and exported reports in multiple formats based on user input.
• Involved in Writing SQL Queries, Views and Stored Procedures on SQL Server 2000/2005.
• Designed databases for applications with requirements for large numbers of transactions, heavy access and high availability.
• Optimized T- SQL code.
• Generated reports using Crystal Reports 8.5/10.
• Created linked, unlinked and on-demand sub Reports.
• Worked with Logical and physical models.
• Created different type of reports including Cross-tab, Conditional, Drill-down and Sub reports.
• Created a numbers of complex formulas in sub report using different type of variables likes shared variable and retrieved them from master report.

Confidential, Kingston, WI

MS SQL Server Developer

Responsibilities:

• Created database objects such as tables, indexes, stored procedures, functions, and triggers.
• Designed, developed, and tested stored procedures, views and complex queries
• Developed database triggers and stored procedures using SQL cursors and tables.
• Managed all indexing, debugging, optimization and performance tuning, Profiler and SQL Server Agent.
• Served as a Crystal Enterprise Reports Developer/Administrator and SQL Server Developer.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports.
• Developed and tested complex Transact SQL on MS SQL Server.
• Designed and developed Data Transformation Process.
• Built and performed user acceptance testing on new and modified reports.

Confidential, Kingston, WI

MS SQL Server Developer

Responsibilities:

• Designed, developed and tested processes that include the creation of SQL views, scripts, stored procedures and DTS packages.
• Tuned complex T-SQL queries.
• Extracted data using Query Analyzer and DTS packages.
• Understood the existing system and designed modifications to the system to support new requirements.
• Tuned and optimized SQL statements, stored procedures and views.
• Wrote complex SQL queries and could quickly understand requirements for complex queries and procedures.
• Designed database and database normalization.
• Involved in writing Custom Functions to be used in other Functions.