SUMMARY

• 8 years of experience in MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server 2005,2008
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Excellent in High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Access,Excel, CSV, Oracle, flat file, Text Format Data).
• Expert in Data Analysis Services OLAP Cubes, MOLAP and Mining.
• Extensively worked in Migration for MS SQL 7 to 2000 and MS SQL 2000 to MS SQL 2005
• Expert in calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user - defined functions
• Highly proficient in the use of SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity, SQL joins and query writing.
• Fluency with the Enterprise Manager and hands on experience with Business Inteligence tools.
• Hands on experience in working with UML documentations like class diagrams, use cases, sequence diagrams and ERDs
• Highly proficient in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP),Data Transformation Services(DTS) and SSIS with MS SQL 2005.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools
• Experienced in data loads, database integration/conversions, performance tuning and optimization.
• Expert in data/file security, security scripts, user logins, database role and database permission
• Marvelous communication skills blended with interpersonal and conflict resolution skills.
• Versatility and adaptability with new emerging technologies are the essence for my success as MS SQL Developer.

TECHNICAL SKILLS

• SQL Server 7/2000/2005
• SQL Server Reporting Service 2005
• SQL Server Analysis Services 2005
• MS SQL Server Integration Service 2005
• MS Access
• FrontPage
• C#
• .NET
• C++
• Visual Basic 6.0
• ASP
• C#
• Developer 2000
• ERWIN 4.0/4.1/4.2
• Windows 9x/NT/2000/XP/Server 2003
• T-SQL
• PL-SQL
• HTML
• VBScript
• UNIX
• Crystal Reports
• ODBC
• MS Visio 2003
• Sharepoint

PROFESSIONAL EXPERIENCE

Confidential, Mason, Ohio

MS SQL Server Developer/SSAS/SSIS/SSRS/SharePoint(MOSS)

Environment: MS SQL Server 2005, SQL Server 2005 Analysis Service, MS SQL Server Integration Services 2005, MS SQL Server Reporting Services 2005, T-SQL, MDX, SharePoint(MOSS)

Responsibilities:

• Extensively worked with the Business Users gathering their requirements and actively cataloging and supporting various issues and providing their solution.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing and transferring the data from different systems.
• Used linked server to access the objects from the Oracle data source for the mapping of source tables to destination tables.
• Experienced in generating reports like matrix, parameterized and drill through reports using SSRS and developed stored procedures using functions to generate various kind of reports using SSRS.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view
• For the users automation exported the SQL Database to Access and migrated the Access Database from users into SQL 2005
• Used SharePoint for deploying .rdl files and uploading of the internal business documents.
• Designed Partitions in Cubes on time for improvement in performance using SSAS.
• Published reports on to Share-Point and created Web Parts in Share-Point to show various reports generated from Excel and SSRS in one Page.
• Created web forms using .NET components, on share-point to show live data from underlying data-sources like SQL Server to Clients enabling them to edit the data and update the data in the underlying data-sources and allowing the users to insert data into the underlying data-sources.
• Experience in developing Life Cycle using Agile Methodology.
• Experience in optimization of queries, improving the performance and Maintaining the database consistency with DBCC at regular intervals
• Supported the front application developers for queries for development hierarchies, file upload and validations using ASP. Net.
• Extensively used T-SQL statements and created multidimensional cubes for the analyzer and used pivot table to help the end-user get familiar with cube.
• Created the structure of the model and cube in SSAS and reviewed Cube with end user and changed the cube and documentation according to their requirements
• Used indexes to enhance the performance of individual queries and enhance the stored procedures.
• Optimized by assigning relative weights to the tables in the Catalog and Query Performance.
• Provided information and assistance to the database administrator on physical models, setup and maintenance of database

Confidential, Des Moines, IA

MS SQL Server Developer/Data Analyst/SSAS/SSIS/SSRS/ SharePoint(MOSS)

Environment: MS SQL Server 2005, SQL Server 2005 Analysis Service, MS SQL Server Integration Services 2005, MS SQL Server Reporting Services 2005, T-SQL, MDX, SharePoint

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Defined attribute properties in a Parent Child Dimensions.
• Defined Dimension Granularity with in a measure group and drill through actions.
• Sorted attribute members based on a secondary attribute. Specified the named sets for calculations.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.
• Identified and defined the Key Performance Indicators (KPIs).
• Deployed SQL server Analysis Projects using MS SQL Server 2005.
• Identified the database tables and their relationships for defining the queries for the Reports.
• Establishing connectivity through ODBC data sources.
• Created various packages in SSIS for the designing and creating various reporting Data marts specific to the project requirements from various sources like Oracle,Excel, Access, CSV,SQL
• Extensively worked with various data transformation techniques in SSIS by creating SQL as well as VB scripts, various data transformations and data flow tasks.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS.
• Experienced in developing data access layer using C# classes and ADO.NET and supported application using C#.NET, ASP.NET and HTML
• Developed Stored Procedures, Functions, Views and Triggers.
• Created Indexes, Constraints and Rules on database objects.
• Transformed the complex business logic and calculations into coding.

Confidential, Westborough, MA

MS SQL Server Developer/ SSRS, SSIS

Environment: MS SQL Server, MS SQL Server Reporting service, MS SSIS, T-SQL, Windows, OutlookSoft.

Responsibilities:

• Responsible for Technical analysis and design for functional requirements.
• Designed coding and testing of new and enhanced application components on the Data warehouse.
• Responsible for extracting data from huge database to manipulate and analyze the data for the end users.
• Performed extract, transform, and load data into the repository and Created Complex Store procedure, Functions, Views, Indexes for the Logic package
• Designed system test plans, assisting in execution, recording results and ensuring that the solution meets the functional requirements.
• Worked with multidimensional architecture (Hyperion, Cognos, SAP, OutlookSoft), MS EXCEL, SQL stored procedures.
• Designed and analyzed the document business processes, systems processes and data flow and impacts.
• Performed updation to the technical requirements documents
• Performed task at development environment, analyzing, testing, and implementing systems. Designed User-Interface for the testing using DTS packages
• Created Packages using ETL tool for the users to check the codes.

Confidential, Iselin, NJ

MS SQL Server Developer/ SSRS,SSIS,SSAS

Environment: MS SQL Server 2005, MS SQL Server Reporting service 2005, MS SSIS, T-SQL, Windows 2003, ASP.NET,C#.NET

Responsibilities:

• Gathered Requirements from the end user and checked the structure of the schema and data with the Data Modular.
• Created cube structure for the analysis of business condition and for creation of report.
• Created SQL server Reports using SSRS 2005 for the manager and the brokers involved.
• Expert in developing, deploying packages and extracting data using SSIS from OLTP to OLAP.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view
• 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, data dictionary and Metadata
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Created parameterized reports and adhoc reports using Report builder for the brokers and clients.
• Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users.
• Experienced in developing data access layer using C# classes and ADO.NET and supported application using C#.NET, ASP.NET and HTML
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.

Confidential, McLean, VA

MS SQL Server Developer/ SSAS,SSIS,SSRS

Environment: MS SQL Server 2005, MS SQL Server Analysis Services 2005, MS Access, SSIS

Responsibilities:

• Gathered Requirements from the end user and checked the structure of the schema and data with the Data Modular.
• Imported Metadata and created Presentation Layer, Business Layer and DataSource layer, Physical Layer.
• Created the structure of the model and cube in MS Analysis Services.
• Reviewed Cube with End user and changed the cube and documentation according to their Requirements.
• Involved in developing, deploying packages and extracting data using SSIS from OLTP to OLAP.
• Gave training to the End User to familiarize them about how to use the Cube.
• Used MDX for querying and manipulating the multidimensional data stored in OLAP cubes
• Prepared end user documentation, Technical documentation, dimension map, Contact list and published into the Production.
• Migrated various DTS packages to SSIS
• Supported the front application developers for queries for development hierarchies, file upload and validations using ASP. Net.
• Defined aggregations required and granularity available and required in DW.
• Created various Table and Views to ensure the increase performance of application
• Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions