Professional Summary:

• Overall 7 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

Client: Confidential, New York, NY Jan 09 - Present
MS SQL Server Developer/Reports Developer

Description: Confidential, 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

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

Description: Confidential, 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.

Client: 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.

Client: Confidential, IL Jan 07 - Dec 07
SQL Serve/ETL Developer

Description: Archer-Daniels-Midland Company procures, transports, stores, processes, and merchandises agricultural commodities and products in the United States and internationally. The company's Agricultural Services segment purchases, stores, cleans, and transports agricultural commodities, for the agricultural processing industry. This segment also processes and distributes edible beans, formula feeds, and animal health and nutrition products. In addition, Archer-Daniels-Midland providing brokerage and foreign exchange services, participates in third-party reinsurance arrangements; and sells crop insurance to American farmers.

Responsibilities:

• Involved in installation and configuration of SQL Server 2005 and SQL Server 2008 with latest Service Packs.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Developed, implemented and supported SQL Server integration services (SSIS) packages to replace DTS packages.
• Created several SSIS packages to perform varies business functions.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created various Multidimensional cubes using SSAS.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services with the help of some XSTL Style sheets.
• Created multiple reports in Drill mode using tables, financial tables, crosses tabs and charts using Reporting Service (SSRS).
• Experience in MOLAP (Multi dimensional Cube) and ROLAP (RDBMS) to develop customized reports in MS SQL Server database.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• Designed and implemented Parameterizedand Cascading Parameterized reports using SSRS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Using C# activities performed like Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Hands on Experience in Filtered Indexes and Data Compressions for Performance and Optimum space utilization inSQL Server 2008.
• Developed database objects using Common Language Runtime (CLRs) to interact with .NET application.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Provided production support for the ETL jobs and also to the code deployed into the production environment.
• Used Microsoft Team Foundation Server (TFS) to get the lists of bugs that do not have test cases, regressions on previously passing tests.

Environment: SQL Server 2000/2005/2008, oracle 9i, MOSS 2007, DTS, SSIS, SSRS, SSAS, Erwin, Microsoft Visual Studio 2005/2008, Teradata V2R5, SQL Server Management Studio, MS Office, Excel,ASP.NET 3.0,C#,WCF,Web Services, Windows 2008 Server.

Client: Confidential, Minneapolis, MN Jan 06 - Jan 07
SQL Server/ETL Developer

Description: Successfully developed and maintained ETLs to Extract, Transform and Load data from various data sources to the Enterprise Data warehouse called PMS (Product Management System). The data warehouse contained information regarding sales data, purchase data, valued customer information, employee information. The project aims to help make decisions for new product improvements, analysis of existing products and improve customer service.

Responsibilities:

• Involved in installation and configuration of SQL Server 2000 and SQL Server 2005 with latest Service Packs.
• Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.
• The project is related to database application which uses SQL Server database and stored procedures/triggers etc for execution.
• Installed the SQL Server database and created Reports using SQL Server Reporting Services (SSRS).
• Create database objects in SQL Server 2005 including Tables, Triggers, Views, Stored Procedures, Functions and Indexes.
• Created SSIS Packages using SSIS Designer for export heterogeneous data, Excel Spreadsheet to SQL Server 2005.
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Developed SQL Server Integration Services (SSIS) Packages for transforming data from different data sources using various transformation controls.
• Created Reports using SQL Server Reporting Services (SSRS) and created Multidimensional cubes for analysis using Server Analysis Services (SSAS).
• Performed Database consistency checks at regular intervals.
• Created accounts/directories/permissions from operating system for the various users.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Used shell scripts and PERL scripts for automating the processes.
• Taking care of day-to-day related issues; importing/loading huge amount of data, user related, performance tuning.
• Extensively involved in OLAP cube design, OLAP performance issues, OLAP Database maintenance, DTS package development, Extraction Data from various types of files which includes FLAT files, SQL coding and MDX coding.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created and maintained Database Maintenance plans and also created logins and assigned roles and granted permissions to users and groups.
• Worked with different types of Replication Models like Snapshot, Merge and Transactional.
• Performed tune to optimize SQL queries using SQL profiler and query analyzer.
• Created Indexes, Constraints and Rules on database objects.
• Actively participated in (UAT), preparation of user manual and technical support manual.
• Involved in end to end documentation of all the processes including aggregation, metrics and all the relevant customizations made in the system

Environment: SQL Server 2005/2000, SSIS, SSRS, SSAS, T-SQL, SQL Query Analyzer, SQL Profiler, Erwin, XML, Hyperion Intelligence Designer 8.3, Visual Studio 2005, VB, DB 2, Oracle 9i/10g, Crystal Reports.

Confidential, Deerfield, IL Mar 05- Jan 06
SQL Server Developer

Description: The main objective of the project was to collect data from various database sources to perform analysis and then integrate them with the existing systems.

Responsibilities:

• Participated in developing logical model and implementing requirements on SQL Server 2000.
• Created the database for the reporting team.
• Migrated the data from various sources using DTS
• Solved various T-SQL issues using Query Analyzer.
• Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers.
• Created ad hoc T-SQL Queries.
• Created Backup and Restore operations.
• Created Database Triggers to implement business requirements
• Created complex Stored Procedures and Functions to support the front-end application.
• Optimized SQL queries for improved Performance and availability
• Monitored Strategies, Processes and Procedures to ensure the Data Integrity, Optimized and reduced Data Redundancy, maintained the required level of security for all production and test databases
• Ensured Data Recovery, Maintenance, and Data Integrity and space requirements for physical Database.
• Replicated the data.
• Reorganize database structures as needed, automate procedures at regular intervals.
• Optimized long running Stored Procedures & Queries for effective data retrieval.

Environment: SQL Server 2000 (Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler, Index Tuning Wizard), Windows XP, MS Access, MS Word, Crystal Reports.

Confidential, Libertyville, IL Feb 04- Mar 05
SQL Database Developer/Administrator

Description: Confidential, is an innovator and leader in wireless and broadband communications. They are committed to helping you get and stay connected simply and seamlessly to the people, information and entertainment you want and need. The project that I worked on was Sales Tracking System.

Responsibilities:

• Actively involved in different stages of Project Life Cycle.
• Actively participated in gathering of User Requirement and System Specification.
• Created new database logical and physical design to fit the new business requirement and implemented the same using SQL Server.
• Created tables, views and indexes on the database, roles and maintained database users.
• Followed and maintained standards and best practices in database development.
• Involved in tuning of database by creating efficient stored procedures and T-SQL statements.
• Provided assistance to development teams on tuning data, indexes and queries.
• Conducted deployments of objects and data through development, testing, replicated pre-production and replicated production environments.
• Developed new procedures and functions, triggers for various tasks to be conducted in the database based on the design of the front-end.
• Development and implementation of backup and recovery strategies. Tested the back up and recover methods.
• Actively participated in User Acceptance Testing, and debugging of the system.
• Documented the data flow and the relationships between various entities.

Environment: SQL Server 2000, T-SQL, Windows XP, .NET

Client: Confidential, INDIA Jan 03 - Feb 04
SQL Developer

Description: The project was an intranet based Customer Service application which deals with the billing calculation and adjustments.

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Defined relationship between tables and enforcing entity referential integrity.
• Involved in Implementation of database design and administration of SQL based database.
• Upgraded the systems from SQL Server 6.5 to SQL Server 7.0.
• Extensively used enterprise manager (MMC) and query analyzer.
• Established connectivity to database and monitored systems performances.
• Performed installation and upgrading MS SQL Server 6.5 to SQL Server 7.0.
• Daily monitor the systems and check the performance of systems.
• Generates the report into Excel Spreadsheet form from SQL server6.5/7.0.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.

Environment: SQL Server 6.5/7.0, Oracle 8i, Windows NT, C++, HTML, T-SQL, PL/SQL, SQL Loader.

Education:

• Bachelors Degree in Engineering