PROFESSIONAL SUMMARY:

• Over 8+ years of experience as MS SQL Server Developer.
• Strong experience in Design, Development, System Analysis and Support of MS SQL Server 2012,2008, 2005 and 2000 in standalone as well as MS clustered environments.
• Strong SQL Server Developer skills including writing triggers, functions and stored procedures.
• Extensive knowledge of Relational Database Management Systems (RDBMS).
• Expert on Star and Snowflake star schema, Normalization and De - normalization.
• Expert in designing drill down, crosstab, parameterized reports using SQL Server Reporting Services (SSRS).
• Experienced in designing Excel Pivot table based on OLAP cubes using SQL Server Analysis Services (SSAS).
• Expert in Configuring, Managing and optimizing transactional replication in OLTP environments.
• Strong Knowledge in Data Warehouse concepts.
• Hands on SQL tools including SQL Profiler, Red-Gate, SQL Diagnostic Manager, and Ignite for performance tuning and Query Optimization of database.
• Hand on experience with managing Indexes and locks, resolving deadlocks and analyzing query plans.
• Expert in High Level Design of ETL/ DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) using SSIS Packages.
• Writing scripts to convert various forms of data into required form using SSMS and Visual Studio.
• Implemented database mirroring and log shipping with SQL Server 2005/2008.
• Experienced in migrating data using Bulk Copy, backup, restore and disaster recovery procedures.
• Administered SQL server security including data loading, data unloading, and batch jobs.
• Performance Analysis and Production Support for Large (VLDB) and Complex Databases.
• Experience in Data Modeling using Toad, ERWIN and MS VISIO.
• Hands on Microsoft Team Foundation Server (TFS) to manage the team's software development lifecycle.
• Experience in Modifying/Generating Functional and Technical Specifications, documentation and approvals for promote-to-production.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.

TECHNICAL SKILLS:

Databases: RDBMS, SQL Server 2000/2005/2008/2012 and MS Access.

ETL Tools: SQL Server Integration Services (SSIS), DTS.

OLAP Tools: Microsoft SQL Server Analysis Services (SSAS).

Reporting Tools: SQL Server Reporting Services (SSRS).

Programming Languages: C language, T-SQL.

Operating Systems: Windows NT/ 2000/2003/2007/ XP/Vista.

Web Tools: ISS, HTML.

Packages and Tools: SQL Management Studio, SQL Red-Gate, Query Analyzer, Erwin, Enterprise Manager, MS Visio, MS Office, Litespeed, SQL Diagnostic manager, Ignite, Free Mind, AWS, SQL Delta.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

MS SQL Server Developer

Responsibilities:

• Development and administration of Digital Publishing Technology Services of the organization using SQL Server 2005/2008 R2 and tools.
• Working closely with business users, product owners and business analyst to understand the requirement and prepare functional and technical design.
• Administrating the SQL Servers instances across the various domains along with setting up the Alerts using monitoring tools like Ignite and diagnostic manager.
• Followed agile methodology in-betweens teams of the organization followed by daily Scrums.
• Performed the migration of SQL Server 2005 to SQL Server 2008R2.
• Validated the migrated packages to ensure that each package run in the production environment individually or as a part of a scheduled Job.
• Created linked server to oracle, db2 and MS Access database instances and fetched the data to local tables and views.
• Designed and Developed extract, transform and load (ETL) code and staging tables.
• Created SSIS packages for database imports from CSV, Excel databases and other ODBC sources.
• Hands on experience in developing views, triggers, functions and stored procedures to accomplish various tasks.
• Created user defined functions, Indexes to speed up the queries.
• Querying Dynamic Management View (DMV) in addition to SQL Diagnostic manager to find out expensive and long running queries.
• Used CLR functions to encrypt and decrypt the redemption codes for one of the eBook application.
• Processing the batch files across cross-domain FTP locations using Mass Transit.
• Used SQL Delta Data Compare tools for generating scripts, schema, and data synchronization.
• Created Indexes for faster data retrieval and rebuild Indexes as part of Performance Tuning.
• Setting up database maintenance plans for backups, restores and recovery of databases using SSMS and Lite Speed tool.
• Hands-experience in setting up transactional replication to ensure high availability of database.
• Generated ad-hoc reports using SQL Server Reporting Services 2008 from different data sources.
• Performed query optimizations using query analyzer and index tuning wizards.
• Used Query Analyzer and SQL Profiler to optimize queries and enhance the performance of databases.
• Rewrite the existing code for long running queries by replacing cursors with various joins and CTEs.

Environment: SQL Server Management Studio, MS Visio, SSIS, SSRS, Query Analyzer, SQL Profiler, Free Mind, LiteSpeed, Ignite, SQL Diagnostic Manager, Amazon Web Services (AWS), Solr, SQL Delta, Toad data Modeler, Mass Transit.

Confidential, Englewood Cliffs, NJ

MS SQL Server Developer

Responsibilities:

• Analyzed and evaluated clients existing software, database systems and information technology needs.
• Responsible for understanding the business, business flow, design, development and unit testing for all the software Modules.
• Master Data Administration (MDA) and Customer Development for gathering, validating and maintaining key elements of Customer Master, Sales Hierarchy, Sales Planned Accounts and their key attributes.
• Design, Develop, and Maintain Sql Server queries, views, store procedures, triggers, cursors and SQL-SSIS/DTS packages required by the Back Office Support Systems.
• Package Validation to ensure successful run in the production environment individually or as a scheduled Job.
• Modify/Generate Functional and Technical Specifications as required.
• Work closely with Business Users and Team lead and assist in database extract and update program using SQL Server (T-SQL) and MS Visio.
• Perform performance-tuning, optimization, Bug Fixing and Enhancement for the MDA application.
• Create/Modify Test scripts and applications to test the functionality with Unit, String and Integration Testing.
• Data conversions and data loads from various databases and file structures using Sql Server Integration Services (SSIS).
• Used Conditional Split, Data Conversion, Derived Column, Row count, Look Up and various data flow transformations while loading data from Flat file, EXCEL, CSV sources into Sql Server based database tables.
• Decided upon the locking strategies which are used for various batch Programming structures & Transactions.
• Created maintenance plan for consistency check (DBCC) and maintained Index statistics of Database Application.
• Installed and configured Analysis service (SSAS), created cubes and dimensions.
• Organized data from a data warehouse into multidimensional cubes with MS Analysis Services to allow the execution of sophisticated reports and complex queries.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of databases.
• Rewrite the existing code to calculate Brokerage for long running queries by replacing cursors with various joins and CTEs.

Environment: SQL Server 2008, Windows 2003, Toad for SQL, Team Foundation Server (TFS), Query Analyzer, MS Office 2003/2007,MS Visio 2003.

Confidential, St Luis, MO

MS SQL Server Developer

Responsibilities:

• Installed SQL Server 2008 and migrated databases from Sql Server 2005.
• Extensively used T-SQL to create views, triggers, functions and stored procedures to update the Sql Server database.
• Created cursors and user defined functions, Indexes to speed up the queries.
• Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.
• Managed day-to-day project activities and coordinate tasks with other team members.
• Designed and Developed all extract, transform and load (ETL) code using Sql Server Integration Services (SSIS) and staging tables to load data from various flat files sourced by SAP/(Business Warehouse)BW.
• Performed data conversion task on existing data to synchronize the new feed/load to support business changes.
• Used several control flow items and data flow transformations to design SSIS packages to pull snapshots data from production to development server for Broker Commission System (BCS).
• Created a Log Database/file to capture the SSIS event and Performed Debugging of package.
• Extensively used SQL Reporting Services and Report Builder Model to generate drill down and crosstab reports.
• Created maintenance plan for consistency checks using DBCC, maintaining indexes and statistics, performing fine Tuning of Database Application.
• Designed Data Warehouse using SSIS packages and OLAP cubes.
• Organized data from a data warehouse into multidimensional cubes with Sql Server Analysis Services (SSAS) to allow the execution of sophisticated reports and complex queries.
• Performed Data integration, Tested database, Stored Procedures, found and tracked defects.
• Worked closely with business users to understand business requirement and developed canned reports as well ad hoc reports with SQL Server 2005.

Environment: SQL Server Management Studio 2008, MS-Reporting services, SQL Server Integration Services, BI development Studio, Toad for SQL, Windows 2003, Query Analyzer.

Confidential, Kansas City, MO

MS SQL Server Developer

Responsibilities:

• Developed SSIS packages for database imports from CSV, Excel databases and other ODBC sources.
• Hands on experience in developing stored procedures, Views to control the database access for ETL purpose.
• Created functions and triggers to ensure the database consistency and maintained using DBCC check.
• Performed data conversions on existing as well newly synchronized data from various sources.
• Used Red Gate’s SQL Compare and SQL Data Compare tools for generating scripts, schema, data synchronization.
• Created Indexes for faster data retrieval and rebuild Indexes as part of Performance Tuning.
• Setting up database maintenance plans for backups, restores and recovery of databases.
• Hands-experience in setting up transactional replication and database mirroring to ensure high available database.
• Implementing and administering database replication of OLTP and OLAP between SQL Server databases.
• Generated reports using SQL Server Reporting Services 2005 from OLTP and OLAP data sources.
• Designed reports with Drill Down, Drill Through and Drop down menu option and Parameterized Reports.
• Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS.
• Implemented logical and physical model of enterprise data warehouse in a multi dimensional environment.

Environment: SQL Server 2005, SQL Server Management Studio, Red-Gate, Query Analyzer, SQL Profiler, Sql Server BI development studio.

Confidential

MS SQL Server Developer

Responsibilities:

• Upgraded to latest version from SQL server 2000 to 2005.
• Wrote various Stored Procedures, Triggers for the purpose of application development and better performance
• Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Developed backup and restored scripts for SQL Server to make the database available at time of lose of database.
• Designed and implemented user log in and security to ensure the security of database.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
• Created many complex Stored Procedures and Functions and used them in reporting services.
• Tuned SQL statements and Stored Procedures using Execution Plan and Profiler.
• Written DTS packages to move data between production, staging and QA environment.
• Designed database schema using Visio 2003 for data modeling.
• Hands on Experience in creating Materialized views, managing locks, resolving deadlocks and analyzing query plans.
• Setting up various notification scripts which will notify if the database is not up and running.
• Performed query optimizations using query analyzer and index tuning wizards.
• Involved in generating various reports using the SQL Server Reporting Services.

Environment: MS SQL Server 2000/2005, T-SQL, Windows 2000/2003, BI Development Studio, MS Visio, SQL Profiler.