Professional Summary:

• Overall 5 years of experience in design, development of various commercial applications using client/server and Internet technology
• 5 years of experience in SQL Server 2000 and 2005 Database Design and Programming using SQL Server Enterprise Manager, Query Analyzer, and SQL Server Management Studio
• Hands on experience with scripting in T-SQL in constructing stored procedures, triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity, optimized indexes and statistics in relation to reporting data model
• Experience in installation, Upgrade and configuration of MS SQL Server database.
• Experience in analysis, design, development, implementation of business requirements, Building, Migration, Training, Deployment, Production Support, Help Desk support with SQL Server Database System in the client/server environment as SQL Server Developer.
• Experience in writing complex stored procedures, Indexed views and triggers for data consistency and manipulation.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Experience in configuring and installing SQL Server 2008 in Development environment.
• Expert in creating views, stored procedures, triggers and functions to facilitate efficient data manipulation and consistent data storage.
• Experience in writing complex stored procedures, Indexed views and triggers for data consistency and manipulation.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Experience in creating Multidimensional cubes using SQL Server Analysis Service (SSAS).
• Experience in Microsoft SQL Server Database Administration including planning, implementing, backup, and recovery strategies.
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP, Data Replication and DTS Packages.
• Experience in Crystal Reports, Reporting Services for MS SQL Server and SQL Server Agent in Support Services.
• Experience in MOLAP (Multi dimensional Cube) and ROLAP (RDBMS) to develop customized reports in MS SQL Server database.
• Expert in creating, deploying, processing and maintaining Cubes using SQL Server Analysis Services (SSAS).
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005).
• Worked with improving the performance on SQL, TSQL and SSRS procedures and provided the recommendation on server related tuning issues.
• Worked with using SSRS and SSIS package extensively produces massive OLAP reports.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

Certifications:

• Microsoft Certified Professional in ASP.NET 2.0 Windows Application Development.
• Microsoft Certified Professional in Business Intelligent Development (2008).

Technical Skills:

RDBMS : MS SQL Server 2008/2005/2000/7.0, Oracle 10g/9i/8i/7.x, 
MS Access 2007/2003/2000/97. 
Database Tools : SQL Profiler, SQL Query Analyzer, DTS, Import/Export, Enterprise 
Utility Manager Query Analyzer. 
GUI : TOAD, SQL Navigator, SQL Developer, Excel, Visual Studio.
Data modeling tools : Erwin 4.0, Visio 5.0, Star Scheme, Snowflake Modeling.
OLAP/Reporting tools : SSRS, SSAS, Cognos.
ETL Tools : DTS, Integration Service (SSIS), Data Stage 7.5.
Operating Systems : Windows 95/98, Windows 2000/NT/XP.
Languages : T-SQL, PL/SQL, C, C#, AJAX.
Internet Technology : HTML, JavaScript, ASP.NET 2.0/3.0, Web Services, XML, UML.

Professional Experience

Confidential, New York, NY Jan 09 – Present 
MS SQL Server Developer/Reports Developer

Description: Instinet is one of the largest electronic trading companies. The project is to develop reports for ECN (Electronics Communications Network) maintenance database system that provides the total solutions for maintenance, performance, quality and inventory.

Responsibilities

• Gathered details of all the tables in the database.
• Defined requirements and comprehended the complex business rules required for writing the code.
• Created temporary tables, table variables and indexes required for the application.
• Created Stored Procedures, User Defined Functions and Tables for the reports.
• The task involved writing a lot of T-SQL Code, including use of complicated joins.
• Written T-SQL statements to retrieve data.
• Optimized query performance by creating indexes.
• Used Query Profiler to optimize the queries and worked on improving the performance of the system.
• Designed and deployed various complex reports using MS Reporting Services.
• Created reports in SQL Server using SSRS as per the requirements provided by the Front End users.
• Created queries and stored procedures for generating drill down reports.
• Generated reports using global variables, expressions and functions for the reports.
• Identified and worked with parameters for parameterized reports.
• Responsible for scheduling the subscription reports with the Report Manager.
• Involved in converting reports from MS Access 2003 to SQL Server 2005.
• Involved in documentation of the Reports, Tables, Stored Procedures and User Defined Functions that were used in the reports.
• Fixed issues in the existing reports and exported reports in multiple formats based on the business requirements.
• Performed unit testing after developing the reports.

Environment: MS SQL Server 2005, Windows XP Professional, T-SQL, SQL Server Reporting Services, Report Definition Language and Visual Source Safe 8.0

Confidential,San Francisco, CA Aug 2008 – Jan 2009 
Crystal Reports/ MS SQL Server Developer

Description: Amgen, World’s largest biotechnology company, with more than 20,000 staff members worldwide, pioneered in development of novel products and advances in recombinant DNA and molecular biology. Amgen offers staff members a total rewards package which includes salary programs, excellent benefits. The project is about developing performance based plan and long term incentive program, employee stock purchase plan deferred compensation plan personal effective ness program, supplemental retirement plan etc

Responsibilities:

• Developed logical and physical data models, designed data access strategies and wrote SQL code to access and manipulate data stored in relational databases
• Created reports that included formatting options such as Grouping, Sorting, Drill-down, Parameter prompts.
• Created different type of reports including Drill-down, OLAP and Sub reports.
• Created the cross-tab reports with employee details, plan details related to employees, current status of the employees in different tabs.
• Created the conditional reports based on employee designation, basic salary of the employees and employee performance.
• Created the procedure to update the details of the plans and used the procedure in different reports.
• Generated reports using Crystal Reports XI.
• Created Static, Dynamic and Dynamic Cascading Prompt parameters.
• Published, tested and scheduled reports in the Business Objects Enterprise Server.
• Gathered user requirements, drafted specifications, designed, documented and wrote test script for testing of all the report.
• Involved in Writing SQL Queries, Views and Stored Procedures on SQL Server 2000.
• Designed databases for applications with requirements for large numbers of transactions, heavy access and high availability.
• Optimized T- SQL code.
• Worked with Logical and physical models in Erwin
• Expertise in forward and reverse engineering using Erwin

Environment: Crystal Reports XI R2, Crystal Enterprise X, SQL Server 2000, T-SQL.

Confidential,Chicago, IL Dec 2007- Aug 2008 
Sr. .NET Developer

Description: This complete medical insurance solution is used both by insurance agents and the insurers. Application consists of modules insurance policy, premium, individual insurers & groups, dependents, claims, hospitalization & domiciliary details, medical opinion & case summary.

Responsibilities:

• Created the SSIS packages for extracting data from OLTP to OLAP
• Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).
• Developed Full Analysis Life Cycle Project.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Created Multi Dimensional Expression (MDX) and OLAP cubes.
• Implemented data mart, facts, dimensions, star schema and OLAP cubes based on Kimball’s dimensional modeling standards using SQL Server Analysis Service.
• Created calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Upgraded DTS to SSIS.
• Upgraded from SQL server 2000 to SQL Server 2005
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Wrote T-SQL code for creating cursor and handling the data validations.
• Designed and implemented stored procedures and triggers for automating tasks.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Managed index and optimized queries using execution plan.

Environment: Windows XP, T-SQL, MS SQL Server 2000/2005, MS SQL Server Analysis Services 2005, MS SQL Server Integration Services 2005, ERWIN.

Education:

• Bachelors Degree in Engineering