SUMMARY

• 8+ years of IT experience as a MS SQL Server developer specialized in database design, development and administration in SQL Server 2005/2008/2008 R2/2012 and worked in different domains like Financial, Banking, Investments, Insurance and other business domains.
• Good experience in Transact - SQL (DQL, DDL, DML).
• Experience in writing complex queries involving Multiple Table Inner and Outer Joins, Temporary Tables, and Table Variables.
• Experience in implementing business logic using Triggers, Views and Stored procedures.
• Involved in optimizing code and improving batch efficiency with databases including re-indexing, updating statistics and recompiling stored procedures.
• Data migration using SSIS Services across different databases like DB2, Oracle, MS access & flat files.
• Good experience in Query Optimization and Performance Tuning of Stored Procedures using SQL Profiler and Database Tuning Advisor, upgrading from DTS SQL Server 2005 to SSIS SQL Server 2008 packages.
• Experience in SSIS/DTS script task, look up transformations and data flow tasks using T- SQL, C# code and Visual Basic (VB) scripts.
• With Reporting Services (SSRS), experienced in creating tabular, matrix, ad hoc reports based on predefined models and interactive reports from relational, multidimensional or XML data sources and publishing reports, scheduling report processing, or accessing reports on-demand.
• SQL Server Analysis Services (SSAS) 2005/2008/2008 r2/2012 design and build experience that covers the following advanced features required ensuring high-performing, scalable solutions: multi-tier infrastructures, partitioning, aggregations, proactive caching, actions, and role and data-level security.
• Extensively worked with Multi-dimensional Expressions (MDX) to add calculated members and other dynamically calculated values to the Analysis Services cubes (SSAS Cubes).
• Hands on experience in analyzing existing Data-Warehouse and multidimensional structures, for identifying opportunities for redesigning to meet changing business needs.
• Experience in working of UAT and production environment.
• Experience in transforming the design of Relational Databases (OLTP) to the Data Warehouse (OLAP).
• Well acquainted with high availability solutions like Database mirroring, Fail over clustering, Log Shipping, Replication, Scalable shared Databases.
• Strong written and verbal communications. Interested in a challenging technical track career in an application development environment.
• Strong analytical skills and ability to create and maintain a database environment to support business requirements.
• Good experience on bug tracker and version control tool, VSTFS, SVN

TECHNICAL SKILLS

SQL Server Tools: MS SQL Server 2008R2/2008/2005, SQL Profiler, Query Analyzer,Export & Import, DTS, Replication, BIMS.

Application Development and Integration Tools: C#,VB.NET

Data warehouse Tools: SSIS, SSRS, SSAS

Database: MS SQL Server 2008R2,2008,2005, 2000, 7.0, MS-Access 97/2000/2003/2007 , Db2 v8

Operating System: Windows Server 2003R2, Windows 2003/XP/2000/NT/98/95, Unix, DOS

IDE Tools: Microsoft Visual Studio 2008/2005/2003 , Visual Basic 6.0

Architecture: Relational DBMS, OLAP, OLTP, Client-Server Architecture

PROFESSIONAL EXPERIENCE:

Confidential, NJ

MS SQL/BI Developer

Responsibilities:

• Developed and Optimized database structures, stored procedures, Triggers and Functions for the application.
• Handled the migration of SQL Server 2008 to SQL Server 2008r2.
• Responsible for SQL Server 2008 to SQL Server 2008r2 to SSIS Migrations, designing and maintaining SSIS packages.
• Designed and developed SSIS Packages to pull data from Access, Excel and Flat files to SQL server 2005
• Responsible for developing, monitoring and deploying SSIS packages.
• Responsible for analyzing/gathering the user requirements to generate reports using SSRS 2008r2.
• Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
• Developed Query for generating drill down and drill through reports in SSRS 2008r2.
• Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor.
• Involved in creating SQL server Analysis Projects using MS SQL Server 2005.
• Created SSRS reports from Analysis Services using MDX and DMX Queries.
• Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Responsible for disaster recovery planning for SQL Servers. Implemented database mirroring for constant availability.
• Used Database Maintenance Wizard to make necessary changes and to keep the performance of the server at acceptable levels.
• Analyzing and fixing bugs in DIT, SIT and Production environments.
• Providing RCA for priority bugs in VSTF

Confidential, Holtsville, NY

MS SQL/BI Developer

Responsibilities:

• Create new tables, views, indexes and user defined functions.
• Actively designed the database to fasten certain daily jobs and some stored procedure.
• Created SSRS reports for Franchise Health Reports.
• Created User list first title played reports.
• Created reports by retrieving the data from cube using MDX reports.
• Designed reports, Graphs and deployed reports to web applications using SSRS.
• • Used Caching (Cache Technology) for fast retrieval of data to generate reports against data warehouse.
• Designed MDX queries to retrieve data from SSAS cubes.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Designed Cube partitioning and incremental synchronization for SSAS cubes.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Optimized query performance by creating indexes.
• Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users and roles.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
• Use the SQL Analyzer, and Profiler for studying the SQL statements and procedures
• Developed complex stored procedures to create various reports.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Designed Star Schema and Snow flaked schemas in the process of data modeling.
• Access SQL Server using front end applications like VB.

Environment: Windows 2003 Advanced Server, MS SQL Server 2005, MS Outlook, TSQL, Erwin, ETL SSRS, SSIS, SSAS and VBScripts, C# etc.

Confidential, Augusta, GA

MS SQL/BI DEVELOPER

Responsibilities:

• Designed SSIS packages to import the data from DB2, flat files, excel documents and CVS files to the Staging Area in SQL server 2008r2
• Expertise in Using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Worked on Huge Data Transfers from & to SQL Server Databases using SSIS, and used configuration files and Environment variables for production deployment
• Developed drill down and drill through reports from multi-dimensional objects like star schema and snow flake schema using SSRS and performance point server.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Designed and developed various types of Reports using SSRS and rendered them in front end applications like Excel and .net.
• Analyzed database performance with SQL Profiler and Optimized indexes to improve query performance.
• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008 and 2008r2.
• Scheduled Packages using SQL Server Agent Jobs.
• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using Erwin.
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML and CSV using SQL Server 2008r2 Reporting Services (SSRS) and Crystal reports.

Confidential, Little Rock, AR

SQL Developer

Responsibilities:

• Requirement gathering for ETL and Analysis specifications.
• Installing and Configuring SQL Server 2008r2 and giving to access on request.
• Created new complex Stored Procedures, Functions, Indexes, Tables, and other T-SQL code for necessary requirements in 2008r2 server.
• Created new packages to extract data from 2005 server to 2008r2. Automatic Restart of SSIS packages after Failover or Failure
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008r2.
• Creating packages to create, export and import flat files from server.
• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Worked on Complete backing up of Database and Restored the Database from Disaster Recovery.
• Performance improving for different databases in server.
• Scheduled Packages using SQL Server Agent Jobs.

Confidential

SQL Developer

Responsibilities:

• Involved in gathering requirements from business users.
• Involved in transformation of data from various sources and legacy systems like SQL Server 2000 and Excel into SQL Server 2000 using DTS.
• Created triggers that capture the claims and wrote complex formulas that calculate the amounts related to those particular claims.
• Created number of complex formulas to calculate the amounts related to different claims in sub reports using different types of variables like shared variable and retrieved them from master report
• Created complex stored procedures to fetch and manipulate data in the databases.
• Created Tables, Stored Procedures, Views, Constraints and User Defined Functions.
• Wrote and Optimized Triggers, Stored Procedures and Queries in T-SQL.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Customized reports by adding new features such as report alerts, cross-tabs, running total, sub-reports and drill-down fields.
• Modified report content and exported reports in multiple formats based on user input.
• Designed/modified database schema objects to support existing and new business related application development for a global-application. Write/test SQL scripts to perform application specific data manipulation

Environment: MS SQL Server 2000, T-SQL, DTS, Excel.