PROFESSIONAL SUMMARY:

• About 8+ years of experience in IT, as MS SQL Server Database BI Developer in Windows environment, current experience with SQL 2012/2008 r 2/2008/2005.
• Extensive noledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Worked on all activities related to teh development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SQL Server SSIS /2005.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from /2012.
• Experience in migration of SSRS reports from SQL 2005 to SQL 2008 and SQL 2012.
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience in Performance Tuning and Query Optimization.
• Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience with logical and physical data modeling and database design using Erwin.
• Extensive experience in using SQL Server Profiler to monitor teh SQL server for deadlocks, long running queries and tunes teh same to improve performance.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Expert in creating teh cubes and dimensions in SSAS.
• Extensive Experience in creating different types of reports like Drill down, Drill through, Parameterized etc.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQLServerReporting Services (SSRS) in Business intelligence development studio (BIDS).
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

TECHNICAL SKILLS:

Databases: SQL Server 2012, 2008/2008 R2, 2005, Oracle 8i/9i/10g, MYSQL, Tera Data.

Database Tools: SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio(BIDS), SQL CMD.

Languages: T-SQL, MDX, C, C++, VB 6.0, PL/SQL, C# 4.0, Shell Scripting, LINQ, ASP.NET, UML, XML, XMLA, MS SharePoint

DWH / BI Tools: SQL Server Integration Services (SSIS) 2012/2008/2005, SQL Server Reporting Services (SSRS) 2012/2008/2005, SQL Server Analysis Services (SSAS) 2012/2008/2005, Business Intelligence Development Studio (BIDS), Crystal Reports 9.0/8.5.

Change Management Tool: Tortoise SVN, Visual Source Safe (VSS), Team Foundation Server (TFS)

Operating Systems: Windows Server 2000/2003, 2008, 2008 R2, Windows NT 4.0 Windows 7/XP, Linux.

PROFESSIONAL EXPERIENCE:

Confidential

MSBI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across teh organization.
• Designed Data Mapping documents, DDL scripts and Meta data of teh models and maintained them.
• Developed SQL scripts for administration task.
• Maintained SQL scripts, indexes, complex queries for data analysis and extraction.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call teh packages and Stored Procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading teh data into teh Data warehouse.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule DTS/SSIS Packages.
• Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures.
• Developed SSIS packages for File Transfer from one location to teh other using FTP task
• Used ETL to implement teh Slowly Changing Dimensions, to maintain Historical Data in Data warehouse.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS. Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Experienced in creating SSAS OLAP Cubes and Partitioning Cubes.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs.
• Identified Key Performance Indicators (KPI) and Metrics for Business needs in SSAS
• Created Multi-Dimensional Cubes using SSAS for teh Data Warehouse.
• Created Production Deployment Scripts for SSAS Cube & Roles
• Developing OLAP cubes by identifying tables (fact and dimension), data source and data source views attributes and dimension members using SQL Server Analysis Services (SSAS).Created SSAS storage and partitions, and Aggregations, calculation of queries with MDX.
• Developed many MDX queries for creating measures dat fits business logic.
• DefinedCalculated members,named sets, and executed other script commandsusingMDXexpressions.
• Conducted weekly Crystal Reports session for teh reports team.
• Developed a dashboard solution for analyzing STD statistics by building SSAS 2012 cubes and Tableau
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Used MS Report Designer to provide a Report Data pane to organize data used in teh reports.
• Performed T-SQL tuning and optimization of queries for reports dat took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients, and managers
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQL.
• Maintained teh table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Troubleshooting and fixing Bugs/issues in teh enterprise level web application using C#.NET, ADO.NET, ASP.NET and HTML.
• Design and implementation of stored procedures and triggers for automating tasks.
• Interacting with teh users and troubleshooting teh problems involved with teh development of stored Procedures, triggers and problems related to teh privileges.
• Involved in De-Normalization of existing tables for faster query retrieval.
• Involved in development, enhancement, testing and performance tuning of teh application.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis services (SSAS).
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: Windows 2007 Server, SQL Server 2008 R2/2012, SQL Integration Services (SSIS) 2012, SQL Server Reporting Services (SSRS) 2012, SQL Server Analysis Services (SSAS), Business Intelligence Studio, C#, HTML, Visual Studio 2008 R2/2012, OLE DB, Crystal Reports, Erwin 4.0.

Confidential

MSBI Developer

Responsibilities:

• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc., to generate underlying data for teh reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created and developed database objects such as tables, indexes, views, procedures, functions, triggers and T-SQL code with proper grants to all teh users and roles using SSMS 2008 R2.
• Created indexes on teh columns recommended by query optimizer to improve teh performance of teh slow running queries and stored procedures.
• Monitored database status including CPU, memory, me/O, space and dead lock using SQL Server Utilities.
• Wrote DTS scripts for data transfer and Involved in System testing.
• Involved in installation and configuration of SQL Server 2008 R2 with latest Service Packs.
• Extracted data from various sources like DB2, Oracle, Flat files, and XML files and Loaded in to Fact and Dimension tables of data warehouse.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 R2and Flat files.
• Experience in writing VB scripts in script component task.
• Used different Transformation in SSIS as per design specifications.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Worked with building teh hybrid data integration to SQL server 2008 R2where teh data source were Access, Excel, Oracle from SQL server 2005.
• Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1 & type 2 changes.
• Involved in extracting teh data using SSIS from OLTP to OLAP.
• Responsible for defining teh complete Data Warehouse architecture (e.g. ODS, ETL process)
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2008 R2 Server to achieve teh efficiency of SQL Server Analysis Services (SSAS).
• Understanding teh OLAP processing for changing and maintaining teh Warehousing Optimizing Dimensions, Hierarchies and adding teh Aggregations to teh Cube.
• Designed, developed and implemented teh Dimension Data Model through multiple expert interviews for multiple fact tables.
• Configured Internet Information Services (IIS) and Deployed Reports and Analysis Project in to server.
• Design, deploy, and maintain various SSRS Reports in SQL Server 2008 R2.
• Involved in teh preparation of detail Unit Cost, Price and Volume Trends, Expense Variances and Profitability Reports using SSRS.
• Generated Daily, Weekly, and Monthly Reports as per teh customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2008 R2.
• Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Performed data transfers using BCP and BULK INSERT utilities.
• Performed performance tuning by studying Execution Plan, Analyzing Indexes.
• Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.

Environment: MS SQL Server 2008 R2,SQL Server Management Studio (SSMS) 2008 R2,SSIS-2008 R2, SSAS, HTML, OLAP, OLTP, Load Runner, SSRS-2008 R2, SQL Server Profiler, Visual studio 2008 R2, SQL Analyzer, Enterprise Manager and SQL Server Agent.

Confidential, Nashville, TN

MSBI Developer

Responsibilities:

• Work closely with management and end-users to create and evaluate business requirements.
• Responsible for teh Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse using SSIS.
• Used differentControl Flow Tasks and Data flow Tasksfor creating SSIS Packages. Designed packages using different types ofTransformationsfor Data Conversion, Derived Columns with Multiple Data Flow tasks
• Experience inError handlinganddebuggingcoding issues andtroubleshootproduction problems.
• Involved in migration and conversion of Reports from Crystal Reports to SSRS 2008R2.
• Involved in CreatingComplex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through and Drill down Reports.
• Experience in writing custom code expressions in SSRS.
• Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level
• Created Report Models for Business Users to create their own reports.
• Designed & created OLAP Cubes with Star schema using SSAS 2008.
• Created Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS).
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Managed security and user access to Analysis Services cubes using creation of Groups and Roles by creating windows AD and also Perspectives within teh OLAP cube.
• Monitoring nightly ETL process from various highly different source systems. Sources included SQL based databases and Excel Files.Also ensured dat nightly backup jobs or cube processing or other ETL jobs didn’t interfere with each other. Managed SQL 2005 and 2008 databases and nightly SSIS Processes.
• Involved in Monitoringand troubleshooting complex packages by using Data Viewers Grids.
• Monitoring teh scheduled SSRS and Crystal reports. Re-running teh reports in case of any failures or data mismatches.
• Involved in deploying teh changes to QA, Staging and Prod environments.
• Managed off shore team in Report migration project.
• Followed agile methodology and coordinated daily scrum meetings.
• Involved in Product Releases and support calls.

Environment: SQL Server 2005/2008, Windows Server 2003/2008R2, T-SQL, SSIS, SSRS, SSAS, Crystal Reports, Share Point 2010, BIDS

Confidential

SQL Server /SSIS Developer

Responsibilities:

• Used SSIS to migrate databases such as Oracle and Access database, flat files to centralized SQL server destination.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Designed DTS/SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy teh data. Used Event Handlers for Exception Handling in SSIS packages.
• Generated reports on wealth information, account information, research reports using ad hoc reporting to be used by teh clients and advisors.
• Distributed workloads across multiple computers, network links, and central processing units by using Load Balancing as a computer networking.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created Queries in T-SQL, Stored Procedures, and Views to store teh data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to teh tables dat have least updating to improve teh query performance.
• Conducted performance tuning by using SQL Profiler and index tuning wizard. Involved in Creation of Crystal Reports, Created ODBC Connections and database Connections.
• Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on teh fly Scheduled, maintained, and supported teh distribution and access to reports through Crystal Server.

Environment: SQL Server 2008/2005, BIDS 2008/2005, Integration Services 2008/2005, TFS, T-SQL, MS Access, Windows XP/2003 Server, SSIS, SSRS.

Confidential

SQL Server/SSIS Developer

Responsibilities:

• Involved in teh Requirement gathering, documenting and delivered functional specification document to teh project team.
• Migrated data from Heterogeneous Data Sources and legacy system (Access, Excel) to centralized MS SQL Server databases using MS SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Create packages to validate, extract, transform and load data to a centralized MS SQL server from teh existing diversified data sources.
• Performed Data Cleansing by creating staging tables to eliminate invalid data using SSIS
• Involved in performing incremental loads while transferring data from teh legacy systems and using different data flow and control flow tasks in SSIS.
• Maintained log tables and error logging tables to handle errors using event handlers.
• Migrated packages from development server to production server using package configuration.
• Extensively used MS SQL Server Reporting Services with relational data.
• Created several reports using SSRS for teh monthly claims and details of all locations.
• Most of these reports had multi-level drill downs and charts.

Environment: MS SQL Server 2008R2/2005, SSIS, SSRS, T-SQL, Visual Studio 2005, MS Office, Windows2000/2003

Confidential

SQL Server/ DBA Developer

Responsibilities:

• Created new tables, written stored procedures, triggers for Application Developers and user
• Defined functions
• Created SQL scripts for tuning and scheduling jobs. Setup backup jobs and performed restores to test and production environments.
• Defined Check constraints, Business Rules, Indexes and Views Involved in performing data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Created Talend Mappings to populate teh data into dimensions and fact tables.
• Used Talend joblet and various commonly used Talend transformations components like tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator, tSetGlobalVar, tHashInput & tHashOutput and many more.
• Worked with Configurations on teh Server for sending automatic emails to teh respective people when a DTS process failure or success.
• Developed database objects such as DTS Packages, Procedures, Functions, Tables, Triggers,
• And Indexes using TSQL, SQL Analyzer and Enterprise Manager.
• Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Performed development support, document reviews, test plan, integration of teh system
• Monitored teh Database Growth and Space Requirement, Handling Users/Logins/User Rights.

Environment: MS SQL Server 2000/2005, TSQL, DTS, Microsoft Visual Source safe 6.0,Talend Integration Suite 4.1.2SQLServer 2005 Management Studio, Windows 2003 Server, SQL Server Reports, Excel and Access.