Professional Summary:

• Over 7 years of IT Experience in Data Warehousing BI Solution Design, Development and Administration with Microsoft SQL Server 2008/2005/2000 in Development, Test and Production Environments.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis services SSAS , Microsoft Reporting Services SSRS , Microsoft Integration Services SSIS , Performance tuning, Designing Logical/Physical databases and Troubleshooting.
• Extensive Knowledge of all major international standards used in Healthcare like HIPAA 4010/5010, HL7, PCS, ICD 9/10, CPT Codes.
• Expertise in Implementing and managing organization wide BI solutions in SQL Server 2005 / 2008 and Business Objects.
• Experience in SQL Server DTS and SSIS Integration Service package design, constructing, and deployment.
• Worked on SQL BI solution integration with Microsoft SharePoint Server MOSS .
• Strong knowledge in Performance Point Server 2007 to designing dashboards and scorecards in highly complex scenarios with multiple KPIs, OLAP Charts and SSRS Reports
• Proficient with Microsoft Excel, especially pivot tables, reports, and charts.
• Thorough understanding of Kimball's' theory, KPIs, SQL 2005/2008 Architecture, Data mining, working with slowly changing dimensions.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS 2007 SharePoint , Business Scorecard Manager, Dashboards, Performance Point Server for easy data access.
• Worked in Data modeling, creating star and snowflake schemas in SSAS.
• Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, OLAP and Sub reports, adhoc reports, parameterized reports, custom reports and formatting them.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.

SQL Server Administrator:

• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005/2008.
• Responsible for managing a database environment leading to documentation, database backup and recovery methods, manage automation of database administration, performance monitoring, tuning, and capacity planning.
• Hands on experience of high availability SQL Server solutions using replication, Mirroring, Log shipping and SQL Server clustering and installation of physical server hardware and other peripheral devices.
• Experience in space allocation, database migrations and database security along with solving code compatibility check issues during the migration from 2000 and 2005.
• Responsible for standards and design of physical data storage, maintenance, access and security administration.
• Responsible for design and correct functioning of backup and recovery on DBMSs.
• Optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.
• Evaluates and implements new initiatives on technology and process improvement.

Professional Experience

Confidential

Role: BI Developer/Analyst

• Developed new reports using SSRS 2008. Used table control, matrix control for cross tab reports.
• Converted the reports from SSRS 2005 to 2008.
• Performance tuning, query optimization of stored procs for better performance.

Confidential

Role: Database Programmer Analyst -BI Developer/Analyst

Responsibilities:

• Analyzing the SAS Programs and writing the Business Requirements for the Reports and Developing SQL Stored Procedures and Reports Using SSRS2005/2008.
• Developed the Stored procs to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• DDL Scripts for generating Tables, Views, Functions for Reports.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Extensively used T-SQL to create triggers and stored procedures used by the enhancements modules to update the SQL Server database.
• Performance tuning, query optimization and execution plan of queries for better performance.
• Created Tabular reports, Matrix reports, List Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment
• Designed and created Report templates, bar graphs and pie charts based on the Claims data.
• Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• Writing Complex MDX for the Reports that Uses OLAP Cubes.
• Developing OLAP, HOLAP and ROLAP Cubes to have a better Analysis for the Business Needs.
• Experience in using Performance Point, Power Pivot and SharePoint Designer.
• Training and Mentoring the Business Users to help them Understanding OLAP Cubes.
• Managed SharePoint end user accounts, permissions, access rights, and storage allocations in accordance with best-practices regarding privacy, security, and regulatory compliance.

Environment: Visual Studio 2005/2008, SSMS , T-SQL Stored Procedures, SQL Server reporting services SSRS , SQL Server Analysis Services SSAS , ProClarity 6.3 ,Power Point, Office, Excel Power pivot 2010 ,Performance Point services, ER Studio

Confidential

Role: SQL BI Developer/Administrator

Responsibilities:

• Work with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Migrated databases from SQL Server 2000 to SQL Server 2005.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Implemented the new SQL Server 2005 concepts like Data partitioning ,Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• Migrated DTS packages to SSIS packages.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Designed OLAP cubes with star schema and snow-flake schema using SSAS.
• Created Cubes and performed Cube Partitioning in SSAS.
• Understanding the OLAP processing for changing and maintaining multi dimensional data Warehousing, Optimizing Dimensions and Hierarchies and adding the Aggregations to the Cube.
• Created various complex reports and manage them using SQL Server Reporting Services SSRS 2005/2008 .
• Created Tabular reports, Matrix reports, List Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to client's need.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, FuzzyLookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components
• Developed and unit test SSIS load processes for performance check.

Environment: Windows 2003 Server, SQL Server 2008 Enterprise Edition, SSRS, SSAS, SSIS, Performance Point Sever 2007, MOSS 3.0, EXCEL2007, MOSS 2007

Confidential

Role: SQL BI Developer

Responsibilities:

• Developed data model based on the BA's and the reporting Team using SSAS, SSRS.
• Designed cubes with star schema using SQL Server Analysis Services SSAS .
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measure groups and KPIs to analyze performance of strategic business units as well as corporate centers.
• Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes.
• Experience in SQL Server Analysis Services SSAS for data mining to identify rules and patterns in the data.
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Experience with SQL Server Reporting Services SSRS to author, manage, and deliver both paper-based and interactive Web-based reports.
• Created maintenance reports by using various components like Grouping, Sorting, Filters, and Navigation.
• Developed Linked reports and Sub reports as per user and business specifications.
• Highly involved in creating, structuring, formatting the reports using Report Designer and Report Builder.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Wrote store procedures to generate account statements for different types of accounts.
• Involved in migration of SSRS from SQL 2000 to SQL 2005.
• Worked on SQL Server Integration Services SSIS to integrate and analyze data from multiple heterogeneous information sources Oracle Sybase
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Building UAT and Test environments using Production backups.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, MOSS 2007

Confidential

Role: SQL Developer/ Administrator

Responsibilities:

• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Managed the migration of SQL Server 2000 databases to SQL Server 2005
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Environment: SQL Server 2005 EE, SSRS, SSAS, SSIS, Windows 2003

Confidential

Role: SQL Developer/DBA Intern

Responsibilities:

• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database Oracle and Text format data to SQL Server.
• Data migration import export BCP from Text to SQL Server
• Regularly monitored the system for bottlenecks CPU, RAM, Disk IO and Networking
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Performed development support, document reviews, test plan, integration of the system.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights
• Creation/Deletion of Linked Servers.
• Managing historical data from various heterogeneous data sources i.e. Excel, Access .

Environment: SQL Server 2000, T-SQL, PL/SQL, TOAD.