Summary

• 7 Years of experience in IT, Financial and Healthcare environments with primary skill on the Analysis, Design, Development and Support of Client/Server application using Microsoft SQL Server 2012, 2008R2, 2008, 2005, 2000 and BI suite.
• 3 years of ETL Developer Experience in SSIS and DTS.
• Expert Knowledge in MS SQL Server 2005, 2008, 2012 with Business Intelligence in SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS and SQL Server Analysis Services SSAS .
• Expertise in Microsoft Reporting Service SSRS with Report authoring, Report management, Report delivery and Report security.
• Expert Knowledge of Reporting Services SSRS , Analysis Services SSAS and Integration Services SSIS
• Experience in Extracting, Transforming and Loading ETL data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Optimized a data mart structure by changing some snowflake schemas to a star schema for better performance and added aggregates and Surrogate keys to the fact tables to link to most of my dimensions.
• Proven ability in Performance Tuning, Query Optimization.
• Experience in using tools like SQL Profiler, Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Experienced in Data Warehouse Modeling with SQL Server Analysis Service SSAS .
• Expert in using tools like Bulk Copy BCP , Data Transformation Services DTS and SSIS.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Experienced in migration from SQL Server 2005 to SQL Server 2008.
• In-depth knowledge of Transact-SQL DDL, DML, DCL , Design and normalization of the database tables and Relational Database Management Systems.
• Proficient knowledge of writing, modifying and implementing Tables, Stored Procedures, Functions, Views, Indexes, Triggers, Cursors, Joins User Defined data types.
• Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Drill-Up, Drill-through, Top N, Summary, Form, Lists, Sub reports, Matrix Reports and formatting them.
• Experienced in integrating the SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager.
• Experienced in migration of Data from Excel, Flat file, Oracle to MS SQL Server using MS SQL Server DTS and SSIS.
• Good understanding of Data Marts, Data warehousing, Operational Data Store ODS , OLAP, Star Schema Modeling, Snow-Flake Modeling.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Experienced in Cube designing to create shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server SSAS .
• Experienced in building and writing MDX Queries, Calculated Members, and KPI's using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence SSAS, SSRS
• Experienced in Logical Data Modeling, ER Modeling, Data warehouse design concepts, Dimensional Modeling using Star/ Snowflake Schemas, Normalized and De-normalized Schemas with respect to query and analysis requirements.
• Experienced in Performance Optimization of SSAS cubes.
• Experienced with working on ProClarity Analytics server to analyze results produced in the Dashboard.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Excellent Communication and interpersonal skills with strong ability and experience in seeking solutions effectively in challenging environments.

Technical Skills

• Operating Systems : Windows NT/ 98/ 2000/ XP/ Vista, MS-DOS, UNIX/ Linux, Windows 2003 Server.
• Programming Language : C, SQL, T-SQL, and PL/SQL.
• RDBMS : Microsoft SQL Server 2012/ 2008R2/ 2008 / 2005/ 2000, Oracle 9i/10g, MS Access.
• SQL Server Tools : SQL Service Analysis Services SSAS , SQL Server Integration Services SSIS , SQL Server
• Reporting Services SSRS , OLAP, Enterprise Manager, SQL Profiler, Query Analyzer, Export Import DTS , Database Tuning Advisor, Security Manager and Service Manager.
• IDE : Microsoft Visual Studio 2008/ 2005/ 2003.
• Web Technologies : HTML, XML, JavaScript, PHP.
• Other Tools : Crystal Reports, ProClarity, ERWIN, MS Access, MS Excel, MS Visio.

Professional Experience

Confidential

Title: SR SQL SSRS/SSAS Developer/BI Developer

Responsibilities:

• Monitor and tuned indexes, stored procedures and Server Performance using Performance Monitoring tools for Microsoft SQL Server 2000.
• Moved the static data from various text files to SQL Server 2005 database using BCP Import and Export, Bulk Insert.
• Involved in migration of SQL Server 2005 to 2008/2012
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
• Experience in Production Support in Mainframes with Autosys monitoring Tools.
• Experience in working with Autosys Admin team to resolve latency issues in Autosys by checking Event Processer logs.
• Experience in working with High Availability environment
• Created Parameterized reports, Cross-Tab reports, Drill down reports Summary reports by using SSRS.
• Provided support to the application developers on the application databases.
• Used Performance Point server 2007 to integrate SSRS reports.
• Configured and Deployed different reports in the Servers using SQL Server 2008 Reporting Services.
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Used Ms Visual Source Safe to handle the files in database
• Created report snapshots to improve the performance of SSRS.
• Creating Reports as per user requirements using MS Reporting Services 2000/2005.
• Created report models using the report model designer to support Ad hoc reporting.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Deployed and processed SSIS Packages and SSRS Reports weekly to update information As per business logic by using SQL Server Agent and windows Scheduler.
• Involved in Partition of cubes in order to increase the performance of cubes.
• Sound Experience and understanding of SSAS, OLAP cube, Data mining and Architecture.
• Involved in Performance Optimization of Microsoft SQL Server stored procedures, Analysis Services and cubes.
• Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services SSAS .
• Used windows Power Shell Script to automate application deployment process.
• Generated dynamic stored procedures, triggers, Cursors, Joins for the database development.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Configure the report server and generated the report models for user interactions.
• Involved in Analyzing, designing, building , testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Created SQL Server Profiler traces and used with Database Tuning Advisor DTA for optimum performance of T-SQL and MDX queries.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
• Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs. Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement. Designing Cubes, Star Schema and Data models for Data Warehousing Applications.
• Experience in Designing and Building the Dimensions and cubes with star schema and snowflake schema using SQL Server Analysis Services SSAS .
• Designed SSIS Packages to extract, transfer, load ETL existing data into SQL Server 2005.

Confidential

Title: SR SQL SSRS/SSAS Developer/BI Developer

Responsibilities:

• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Create and test DTS packages for importing and exporting data from data warehouse.
• Managed the entire ETL process, involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Making a Report as per user requirement using MS Reporting Services 2008 SSRS .
• Involved in developing report using SQL Server Report 2008.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Involved on ProClarity's powerful visualization tools, including the Decomposition Tree, Perspective View and Performance Map, to drill down, cross drill, pivot, chart, and investigate data.
• Performance tuning and optimization of procedures and queries. Involved in the tuning of the existing Database Objects.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio and Database Engine Tuning Advisor.
• Created Business Objects reports Master/Detail, Cross tab, Chart templates .
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed SSIS Packages to extract, transfer, load ETL existing data into SQL Server 2008 from different environments for the SSAS cubes.
• Helped in Designing Business Models as per requirement for SQL 2008 Analysis Services cubes.
• Maintained production OLAP cubes, wrote MDX queries to generate reports using SQL Server 2008 Reporting Services
• Excellent hands on experience with SQL Server Integration Service SSIS , SQL Analysis Services SSAS and Reporting Services SSRS .
• Experience with designing and enhancing OLAP cubes Using SSAS.
• Involved in designing cubes in SSAS environment using Snowflake/ and Star Schemas.
• Involved in creating Dimensions, KPI, Measures and calculations.
• Expert in MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server 2008.
• Created SQL Server Analysis Project using MS SSAS 2008.
• Created cubes in SSAS to be used as data source in the reports
• Good understanding of Data Marts, Data warehousing, Operational Data Store ODS , OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view
• Developing and extending the cubes with around 35 dimensions, about 10 measures, and 25 calculated members, Design Dimensions and using the MDX expressions for the various Optimizations like Optimizing cube schema
• Exceptional hands on working knowledge and recent experience working with SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , and SQL Server Analysis Services SSAS .
• Identified and defined Fact relationships in SSAS, Created cubes and dimensions.
• Involved in developing Life Cycle using Agile Methodology.
• Created the ADO.NET objects to communicate with the database. Created SQL Server Reports using SSRS 2005.Identified the data source and defined them to build the data source views.
• Involved in the design, development and implementation of web user interfaces using C . NET, ASP.NET.

Environment: MS SQL Server 2005/2008, Windows 2003,Enterprise Manager, Management Studio SSMS , Integration Services, BIDS,SSAS, SSRS, OLAP, Agile, Data Modeling, Analysis Services, T-SQL, C .Net, DB2, Windows 2003, Tuning Advisor, ETL, SQL Profiler, SQL Server Agent, Data ware Housing, BCP, and Visual Basic 6.0, Crystal Report9.0, MS Access.

Confidential

Title: SR SQL SSAS/SSRS Developer

Responsibilities:

• Create joins and sub-queries for complex queries involving multiple tables.
• Generated dynamic stored procedures, triggers for the database development.
• Experience in Extracting, Transforming and Loading ETL data from Excel, Flat file to MS SQL Server by using BCP utility, SSIS services.
• Involved in Report writing according to business requirment using SSRS and Crystal Reports.
• Generated database monitering and data validation reports in SQL Server Reporting Service SSRS .
• Using SSRS, creating well-formed reports and web-based reports for financial applications and transactions.
• Worked on .Net data access layer and ADO.Net and developed various clauses to connect to database with the front-end pages.
• Deployed SSRS Reports in SharePoint for web based access for multiple end users.
• Responsible maintaining UNIX upgrades and configuration.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Configure the report server and generated the report models for user interactions.
• Configuration of Snapshot and Transactional Replication.
• Deployed designed PPS dashboards reports in MOSS site using PPS Dashboard viewer Web Part for web based access for multiple end users.
• Experience in creating SSIS packages using different type's task and with Error Handling.
• Assisted Oracle DBA in writing scripts for automating Oracle tasks on the UNIX Server.
• Used SharePoint views for the end users to do modifications to the data through SharePoint designer
• Fine tuned the complex database stored procedures and increase performance up to 5 .
• Taking weekly database backup and schedules job using SQL Agent.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Designing OLAP cubes, Data Modeling, Dashboard Reports according to the business requirement.
• Designing Cubes, Star Schema and Data models for Data Warehousing Applications
• Experience in Designing and Building the Dimensions and cubes with star schema and snowflake schema using SQL Server Analysis Services SSAS .
• MDX Coding and MDX object modeling using analysis service

Environment: SQL Server 2008, Query Analyzer, SSIS 2008, Performance Point Server, .NET, C , T-SQL, Excel, Microsoft SQL Reporting Services 2008 SSRS , OLAP, OLTP, ProClarity, SSAS, SharePoint Server, Erwin.

Confidential

Title: SR SQL SSRS Developer/BI Developer

Responsibilities:

• Designed and Developed Database Objects Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data jtypes and functions for this project.
• Performed PL/SQL T-SQL programming to create Stored Procedure, Functions, Cursor and Triggers.
• Expert in Query Optimization and tuning the query, creating Indexes to improve query performance
• Generated database monitering and data validation reports in SQL Server Reporting Service SSRS .
• Created multiple Tabular reports, Matrix reports, List Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports SSRS according to business requirements with various security standard.
• Wrote complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Managed the day-to-day activities to ensure the completion of deliverables on time by providing a weekly status Reports on progress made using SSRS
• Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services SSAS
• Involved in developing UNIX scripts for a higher level of Automation for the Data loading process of the research database.
• Enhanced the existing UNIX scripts to achieve better performance and throughput.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Good exposure or knowledge working on VB.NET framework and SharePoint 2007 portal.
• Developed security application for maintaining Id's and user names and modifying files using VB script.
• Extracting XML data to SQL server using SSIS ETL on VB .Net framework.
• Tested the Task Factory Components in SSIS Transformations for Implementing Type1 and Type 2 Dimension Tables.
• Created the ADO.NET objects to communicate with the database. Created SQL Server Reports using SSRS 2005.Identified the data source and defined them to build the data source views.
• Involved in the design, development and implementation of web user interfaces using C . NET, ASP.NET.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Designed SSIS packages for synchronizing the data between two different servers.
• Created Ad-hoc reports and cascading reports for historical data using SSRS 2008.

Environment: SQL Server 2008, Query Analyzer, SSIS 2008, Performance Point Server, .NET, C , T-SQL, Excel, Microsoft SQL Reporting Services 2008 SSRS , OLAP, OLTP, ProClarity, SSAS, SharePoint Server, Erwin.

Confidential Title: SQL BI Developer SSIS/SSRS

Responsibilities:

• Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.
• Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Created Indexes to get the high level performance.
• Responsible for Unit Testing of modules coded.
• Developed data interface layer using ASP.NET and C for data access.
• Modified SSIS ETL package for changed business requirements to load data from different source files to SQL Server tables on VB.Net framework.
• Built MDX queries and Data Mining Expression DMX queries for Analysis and Reporting Services.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Performing the ETL operations to support the data loads and transformations using SSIS.
• Involved in migration from Oracle to SQL Server 2005 using SSMA and SSIS.
• Deployment of SSAS Cubes to the production server.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Designing OLAP cubes, Data Modeling, Dashboard Reports according to the business requirement.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services SSAS and Reporting service SSRS .
• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS.
• Managing Logins, Users, Roles and User permissions.
• Running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

Environment: SQL Server 2005/2008, Query Analyzer, SSIS 2005, T-SQL, Excel, Microsoft SQL Reporting Services 2008 SSRS , SQL Analysis Services SSAS , OLAP, Windows 2000/XP, Oracle 7.0.

Confidential

Title: SQL Server Developer SSRS/SSIS .

Responsibilities:

• Create joins and sub-queries for complex queries involving multiple tables.
• Generated dynamic stored procedures, triggers for the database development.
• Experience in Extracting, Transforming and Loading ETL data from Excel, Flat file to MS SQL Server by using BCP utility, SSIS services.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX
• Involved in Report writing according to business requirment using SSRS and Crystal Reports.
• Generated database monitering and data validation reports in SQL Server Reporting Service SSRS .
• Using SSRS, creating well-formed reports and web-based reports for financial applications and transactions.
• Worked on .Net data access layer and ADO.Net and developed various clauses to connect to database with the front-end pages.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Configure the report server and generated the report models for user interactions.
• Configuration of Snapshot and Transactional Replication.
• Experience in creating SSIS packages using different type's task and with Error Handling.
• Fine-tuned the complex database stored procedures and increase performance up to 5 .
• Taking weekly database backup and schedules job using SQL Agent.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.

Environment: MS SQL Server 2005/2008, Management Studio, ETL, DTS, Notification Services, Crystal Reports, T-SQL, SQL Profiler, IIS 6.0, Windows 2003 Advanced Server, SSIS, SSRS, community server, Erwin.

Confidential

Title: SQL Server Developer

Responsibilities:

• Involved in Data modeling to develop the database design using Erwin 4.0
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Involved in designing Flow charts, office layout for the business users and professionals using VISIO.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• 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.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Managed the entire ETL process, involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Involved in developing report using SQL Server Report 2000.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Performed all aspects of database administration, including data modeling, backups and recovery.

Environment: MS SQL Server 2000/2005, T-SQL, Stored Procedures, SQL Server Enterprise Manager, ETL, DTS, SSRS 2000, IIS 4.0, Visio 2000, SQL Server Query Analyzer, SQL Profiler, ERWIN.

Confidential

Title: SQL Server Developer

Responsibilities:

• Created and maintained database objects.
• Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Created various reports using MS Reporting Services 2000.
• Tuned complex SQL Queries.
• Loading data from various data sources using MS Data Transformation Services.
• Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general trouble shooting.
• Involved in various phases of SDLC.
• Analyzed the estimated execution plan of complex stored procedures and tune the badly or slowly performing queries to improve performance.
• Participated in report authoring, used conditional formatting to make the reports more user friendly.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Wrote and integrated stored procedures to generate the reports.
• Provided on-call support for various projects.

Environment

SQL Server 2000, MS Excel 2003, MS Access 2003, MS SQL Query Analyzer, SQL Profiler, MS SQL Server Reporting Services.