PROFESSIONAL SUMMARY:

Over 7 years of experience in Analysis, Design, Development and Tuning of Relational Database Management Systems (RDBMS) for domain specific Business Intelligence (BI) applications in Online Transaction Processing (OLTP) environment and all phases of Software Development Life Cycle (SDLC) with a thorough understanding of Object Oriented Principles(OOPs) Conceptual, Logical and Physical database modeling, Normalization, Data mapping, ER Diagrams, Extract, Transform and Load process(ETL) and creating precise Reports in terms of observing business rules.

TECHNICAL SKILLS:

Databases: SQL Server 2012/2008 R2/ 2005, MS Access 2007.

Programming Languages: T - SQL(DDL&DML), Basics of C#, VB.Net, ASP.Net, XML and HTML

Operating Systems: Windows 98/2000/2003/ XP/NT/Vista, Windows 2003 Enterprise Server.

IDE & Business Intelligence Tools: SQL Server Management Studio (SSMS), MS Visual Studio 2008/2010/2012 , SQL Server Integration Services (SSIS) for ETL and SQL Server Reporting Services (SSRS), SQL Profiler and Database Tuning Advisor.

Version Control: Visual Source Safe, Team Foundation Server, SVN

Data modeling Tools: MS Visio 2003/2007, Rational Rose, MS Office

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Business Intelligence Developer

Responsibilities:

• Designed and developed the database schema (Conceptual, Logic and Physical Models) in coordination with the database administrators.
• Created database objects (Tables, Views, Functions, Triggers, Stored Procedures, Temp Tables, Table Variables, CTEs, etc.) using different methodologies (JOINS, CURSORS, CASE, IF-ELSE, DYNAMIC SQL, AGGREGATIONS, IN-BUILT FUNCTIONS) in TSQL Coding.
• Implemented error handling using TRY-CATCH BLOCK and Implicit transactions.
• Fine-tuned slow running queries and stored procedures using SQL Profiler.
• Reorganize and Rebuild Indexes with appropriate Fill factors according to the Internal and External Fragmentation levels.
• Created, Configured and deployed SSIS packages with Lookup transformations, Merge joins, and Fuzzy Look Ups and Derived columns with Checkpoints for multiple Data Flow tasks.
• Got an opportunity to work on Slowly Changing Dimensions task to keep track of historical changes to Merchants and their cities.
• Created Error Handling, Logging and fine-tuned existing SSIS packages.
• Created SSRS reports (Tabular, Matrix, Sub, Charts, List, Toggled, Drilled Down) using Cascading Parameters and conditional expressions.

Environment: Visual Studio 2012, SVN 3.0.4, MS Outlook 2010, SQL Server 2008/2008R2/2012, Windows 7.

Confidential, New York

SQL Server/SSIS/SSRS Developer

• Gathered business requirements from the users and translated them as technical specifications and design documents for development.
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Temp tables, Table variables, Functions, Triggers, Joins, Sub-Queries, Constraints, Indexes, Views, Rules, Defaults and complex SQL Queries with proper Error handling using Try Catch methodology.
• Created File Groups, Files, Partition Functions, and Partition Schemes to split the table data horizontally to boost the Performance.
• Created Trace files using SQL Profiler and used it as workload in Database tuning advisor
• Designed, developed and deployed Tabular, Matrix type Drill Down, Linked and Sub-Reports with Cascading parameters, Groupings, Expressions and Dashboards in SSRS with Data Driven Subscriptions for sending Emails to the users in different formats.

Environment: Visual Studio 2012, SVN 3.0.4, MS Outlook 2010, SQL Server 2008R2/ 2012, Windows 7.

Confidential, New York

SQL Server/SSRS Developer

• Created Scalar Functions and incorporated them in Computed columns and created appropriate Indexes on them for better performance.
• Created Tables, Temp Tables, and Views, Functions, Triggers, indexes and Stored Procedures to populate data into the SSRS reports
• Recreated TSQL Scripts by replacing the cursors with Joins and Case statements.
• Handled Errors in Stored procedures with Try Catch Blocks and implicit transactions.
• Created instead of triggers for updating the Views with multiple Tables.
• Detected and resolved the Locking and Blocking issues with different Isolation levels and Hints
• Designed, developed and deployed Tabular and Matrix type List, linked and Sub-Reports with Charts and Document maps using SSRS.
• Created and deployed Tabular drill down and List reports with Drop Down Multi Parameters, Grouping, Toggling, Document maps, Gauges and Charts
• Created, Configured and deployed SSIS packages for importing legacy data from different sources to SQL server destinations.
• Provided support to the end users for any Bugs and inappropriate data in the Reports

Environment: Visual Studio 2010, Windows 7.0, SVN, MS Outlook 2010, SQL Server 2008R2, SSRS.

Confidential, Wisconsin

Junior SQL Server Developer

• Created Tables, Functions, Views, Joins, Indexes and Stored Procedures using TSQL.
• Enhanced and modified the existing Database Objects (Tables, Views, and Stored Procedures).
• Got an opportunity to create and deploy simple Tabular Reports using SSRS
• Performed System Integration Testing for the all the tasks.
• Provided support to the customers for Bugs and created tickets in the system.
• Created Technical Documents for all the tasks.

Environment: Windows 2003 Server, Visual Studio.Net 2.0, SQL Server 2005, Team Foundation Server.

Confidential, Ashland, Oregon

Junior SQL Server Developer

• Created Tables, Stored procedure, Functions, Triggers and Views using TSQL.
• Fixed the Bugs in the existing Stored Procedures, TSQL Scripts.

Environment: WindowsServer2003, Visual Studio 2005, SQLServer2005, Tortoise CVS.