Professional Summary:

• Over 7 years of MS SQL Server Development experience in Pharmaceuticals, Finance, Telecommunications, and Health Insurance domains with expertise in MS SQL Server 2000 and MS SQL Server 2005/2008 suite of products like SSIS, SSAS, and SSRS.
• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL Server 2000 and MS SQL Server 2005 respectively
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Expertise in Developing and Extending MS SQL Server Analysis Services 2005 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/2008 (SSRS).
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2005.
• Strong experience in Stored Procedure/TSQL coding, Performance Tuning, and Query Optimization.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Experienced in Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using ERwin and SQL Server Enterprise manager.
• Excellent experience in Designing, Maintaining & Tuning various RDBMS like T-SQL & MS SQL Server 2000/2005, MS Access databases and strong knowledge of SDLC principles.
• Involved in all phases of software development life cycle: design, implementation and testing.
• In-depth knowledge of working and implementation of Crystal Reports, converting Crystal reports to SSRS Reports and in upgrading crystal reports 8.5/9.0/10 to XI.
• Expert in database creation, maintenance, monitoring, backups and recoveries.
• Specialized in analyzing, coding, implementing and creating complex query reports using Oracle 8i/ 9i/ 10g, SQL Server 2000/2005/2008, Sybase and DB2.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills.

Education Qualifications:
Masters in Computer Science

Skillset:
MS SQL Server 2000/2005/2008, T-SQL, ODBC, DTS, SSAS, SSIS, SSRS, Crystal Reports 8.5/9/10, Crystal Reports XI, Business Object XI, Crystal Enterprise 10, Oracle 8i, 9i, 10g, MS Access-97/2000, Excel, Flat File, MS Visio, Erwin Platinum, HTML, XML, Windows NT/2000/XP/2003 server.

ProjectsSummary:

Confidential Waltham, MA 11/2009 - Present

MS SQL Server Developer/SSRS/SSAS
Syrinx is a software development and consulting firm that brings a deep understanding of Microsoft technologies. As a Microsoft Gold Certified Partner, the company has developed solutions within the financial services, Internet, call center, real estate, publishing, health care, and biosciences industries. Gilbane Building Company is a leading construction management firm, providing a full slate of facilities-related services for clients in the healthcare, education, government, convention/cultural, mission-critical, corporate, sports/recreation, life sciences, transportation, and criminal justice markets.

Hardware/Software:
MS SQL Server 2000/2008, SQL server Reporting Services 2008, SQL Analysis Server 2008, VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL.

Responsibilities:

• Fixed the bugs present in already existing reports.
• Developed many Tablix Reports, Tabular Reports, Matrix Reports, Drill Down Reports and Charts using SQL Server Reporting Services (SSRS).
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Deployed the generated reports directly on the client’s workstation.
• Created many multi valued parameters in the reports.
• Created many Cascaded parameters in the reports using MDX and T-SQL.
• Improved Report Performance and performed unit testing.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data ,normalized tables, established joins and created indexes whenever necessary.
• Created the structure of the model and cube in MS Analysis Services (2008).
• Analyzed and designed software and database solutions.
• Reviewed Cube with End user and changing the cube and documentation according to their requirements.
• Defined relationships between Measure groups and Dimensions.
• Generated automatically grouping attribute members.
• Implemented the calculations to aggregate physical measures.
• Created MDX queries to retrieve data from the cube and also to display SSRS reports.
• Used Caching (Cache Technology) for fast retrieval of data to generate reports against data warehouse.
• Created reports to generate them through Email for the administrative using MDX Queries.
• Designed Cube partitioning and incremental synchronization for SSAS cubes.
• Modified existing reports according to requirements of the end users.

Confidential Lexington, MA 3/2008 – 10/2009
MS SQL Server/ Business Intelligence Developer
Fresenius Medical Care North America (FMCNA) is a major provider of kidney dialysis services and renal care products. More than 39,000 employees share a commitment to deliver the highest quality services for patients and health care partners. FMCNA is a wholly owned subsidiary of Fresenius Medical Care AG & Co. KGaA, located in Bad Homburg, Germany.
Hardware/Software:
MS SQL Server 2005 Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), Microsoft Performance Point Server 2007, Microsoft Share Point Server, T-SQL, NET, C# MS Access and Excel.

Responsibilities:

• Analyzed the existing reports in Report.Net, Actuate and their data sources
• Analyzed & designed the business rules for data cleansing that are required by the staging & OLAP and OLTP databases.
• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• 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 Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Sub reports for top selling equipment in the company, top sales based on region and sales based on season.
• Wrote queries for Drilldown reports to get the complete details of the sales sold in particular region.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports of each quarter onto the Report Server to access it through browser.
• Created various geographical and time dimension reports of fiscal year, quarter month, week and daily reports for all domains and published through Report Server.
• Created various reports by comparing the growth of sales based on each quarter by using bar charts.

• Responsible for generating annual reports based on the growth of sales with respect to customers.

• Created calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Used Visual Source safe for repository and maintaining versions.
• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T_SQL code and SQL joins for applications.
• Extensively used formula fields, parameter fields, Running Total, Group selection and record selection in Crystal reports for writing new formulas.
• Conducted user training sessions and supported the requests for enhancements, modifications and new reports.

Confidential, Newark, NJ 6/2007 – 3/2008
MS SQL Server/SSIS/SSAS/SSRS Developer
Prudential Financial Company serves individual and institutional customers worldwide. The project involved designing a new database schema, migrating data from SQL Server 2000 to SQL Server 2005, performing analysis and then generating various types of reports.
Hardware/Software:
MS SQL Server 2005, SSRS, SSIS, SSAS, Crystal Reports XI, Business Object XI, Oracle 9i, DTS, T-SQL, VisualSourcesafe.

Responsibilities:

• Transformed data from MS SQL Server 2000 to MS SQL Server 2005 using OLE DB connection by creating various SSIS packages.
• Used the Execute DTS 2000 package task to execute DTS packages.
• Created Data Transformation tasks like BCP, BULK INSERT to import/export data from clients.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Designed a new schema for the Data Mart databases.
• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis.
• Created MDX queries to extract data from the Data Mart.
• Generated Dynamic reports from Cubes (SSAS) using SSRS-2005.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.
• Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
• Created simple data entry applications using C#.Net 2005 and SQL 2005 Server.
• Used HTML code to make Report manager more functional & customizable.
• Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.

ConfidentialSan Francisco, CA 4/2006 – 5/2007
MS SQL Server Developer/ SSRS/SSAS/SSIS
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 effectiveness program, supplemental retirement plan etc
Hardware/Software:
T-SQL, MS SQL Server 2005, MS SQL Server Analysis Services 2005, MS SQL Server Integration Services 2005,MS SQL Server Reporting Services 2005.

Responsibilities:

• Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Developed logical and physical data models, designed data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Created calculated measures and dimension members using multi dimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports using SQL Server Reporting Services (SSRS).
• 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 2005.
• 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

Confidential Reston, VA 1/2005 – 3/2006
MS SQL Server /SSIS/SSRS Developer
Sprint Corporation is a communication company offering a range of wireless and wireline communications products and services for individuals, business and government customers. The project is to extract data from the databases and to develop various reports for the billing department based on their requirement.
Hardware/Software:
MS SQL Server 2000/2005, T-SQL, MS SQL Server Integration Services 2005, MS SQL Server Reporting Services 2005, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005, Erwin v4.1, Windows XP, MS Office 2003/2007, MS Access, Crystal Reports 9/10.

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Upgraded MS SQL Server 2000 databases to 2005, using Detach/Attach, Back up & Recovery and by Replication.
• Incorporated the DTS Packages into MS SQL Server 2005 Integration Services by using Package Migration Wizard and Execute DTS 2000 Package task .
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created Views to reduce database complexities for the end users.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Maintained the table performance by following the tuning tips like Normalization, Creating Indexes etc.
• Used the HTML code to make the Report Manager more functional and customizable.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Confidential Green Bay, WI 6/2002 – 12/2004

MS SQL Server/ Reports Developer

Associated Bank-Corp is a reputed bank with long and rich tradition of providing superior financial services to the communities combined with exceptional customer service. The main focus of the project was to gather requirements from business users in developing reports and in coordinating with the tools to allow OLAP reporting capability of bank source systems and to facilitate ETL of source system data.

Hardware/Software:
MS SQL Server 2000, Crystal Reports 8.5, Erwin 3.5, Oracle 8i, T-SQL, DTS

Responsibilities:

• Involved in requirements gathering, analysis, design, development, deployment and user training.
• Created numbers of complex formulas in sub reports using different type of variables likes shared variable and retrieved them from master report.
• Involved in writing Custom Functions to be used in other Functions.
• Understood an existing system and designed modifications to the system to support new requirements.
• Designed, developed and tested processes, which include the creation of SQL views, scripts, stored procedures and DTS packages.
• Published Reports on the web using Crystal Enterprise Wizard and CMC (Central Management Console).
• Created numbers of complex formulas in sub reports using different type of variables likes shared variable and retrieved them from master report.
• Involved in writing Custom Functions to be used in other Functions.
• Understood an existing system and designed modifications to the system to support new requirements.
• Designed, developed and tested processes, which include the creation of SQL views, scripts, stored procedures and DTS packages.
• Extracted data using Query Analyzer and DTS packages.
• Tuned and optimized SQL statements, stored procedures and views.
• Wrote complex SQL queries and could quickly understand requirements for complex queries and procedures.
• Configured, patched, tested, and supported all MS SQL Server database instances.