PROFESSIONAL SUMMARY:

• More than 5 years of IT experience with exceptional skills in Database administration, Business Intelligence application development and Maintenance using, SSRS, SSIS and SSAS.
• Responsible for Database Backup’s recovery, ETL Jobs administration, Installation of SQL server Software. Hands on experience developing stored procedures functions and triggers using T - SQL.
• Experienced in Transact-SQL (DDL and DML) queries including Views, Triggers, Stored Procedures, User Defined Functions and Common Table Expressions (CTE’s).
• Expertise in Performance Tuning - Performance Monitor, Activity Monitor, SQL Profiler, Database Tuning Advisor (DTA), System Stored Procedures and DBCC commands, Dynamic Management Views (DMV’s), Dynamic Management Functions (DMF’s).
• Sound Experience and understanding of SSAS, OLAP cube, and multi-dimensional modeling on Multi-terabytes database.
• Proficient in developing, debugging, deploying SSIS Packages using SSIS designer in Business Intelligence Development Studio (BIDS) for integrating data from heterogeneous sources (MS Excel, Oracle, Flat Files etc.).
• Expertise in Administration of SQL Server Reporting Services (SSRS) including installation, configuration and managing security.
• Experienced in creating and deploying Standard and Ad-Hoc SSRS reports including Drill Down, Drill Through, Parameterized, Linked Reports, Crystal Reports and SAP BO Stack.
• Motivated, enthusiastic and project oriented team player with excellent written and verbal communication skills.
• Hands on experience in development and implementation of high-end applications with Microsoft .Net Framework 3.5/4.0/4.5 and SSRS, SSIS development using MSBI and T-SQL.
• Excellent understanding of full SDLC Models (Waterfall, Spiral and Hybrid) and excellent communication skills.

TECHNICAL SKILLS:

Languages: C#, C, C++, SQL

Web Technologies: .NET Framework 3.0/3.5/4.0/4.5 , ASP.NET, ADO.NET, Web Services, XML and HTML/XHTML

Database: SQL Server 2012/2008/2005 , Oracle 11g/10g and DB2

ETL: SSIS, SAP BODS

Version Controller: Team Foundation Server (TFS), GIT

Analysis Tools: SSRS, SSAS, Crystal Reports 10.0/9.0

Web Servers: Internet Information Services (IIS) 7.5/7.0

Operating System: Windows 7/XP/Vista, Windows Server 2003 R2/ 2008/ 2008R2/ 2012.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Developer/DBA

Responsibilities:

• Creating Packages using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) and mostly working on SQL Server Analysis Services (SSAS) for the Data warehouse Cube and Report Analysis.
• High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all. Responsible for backup’s, restores and granting access to SQL server databases and Instances.
• Good experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, Flat file, and Text format data.
• Gathered business requirements, converted it into robust SQL stored procedures, automated most of the existing process, and even updated the maintenance process.
• Hands-on experience on PostgreSQL and Vertica Database
• Worked closely with both the offshore Application and Database teams to regularly monitor system for bottlenecks and implement appropriate solutions.
• Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures and Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case.
• Performed data transfers using BCP and BULK INSERT utilities. Was involved in the design and implementation of Disaster Recovery.
• Managing the use of disk space, memory and connections.
• Optimizing the report generate timings, scheduling the jobs not affecting the DTS Time, Data integration to various other databases and testing in several environments were few projects I worked on.

Environment: MS SQL Server 2008R2/2005, windows server 2008 R2, SSIS, SSAS, T-SQL, SSRS-2008/2005, Erwin, C#.Net, Access, Excel, Visual Studio 2008/2005 and XML.

Confidential

MSBI Developer

Responsibilities:

• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Experience in configuring checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Transferred data from various data sources/business systems including MS Excel, MS Access, and Flat Files to SQL Server using SSIS.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop and developed Tableau workbooks from multiple data sources using Data Blending.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load (CDC).
• Experience on using control flow tasks like check database integrity task, backup database task, transfer jobs task, transfer logins task, transfer mastered stored procedures task.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS.
• Generated multiple Enterprise reports (SSRS/Crystal) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Report parameters included single valued parameters, multi-value parameters that also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Worked on all types of report types like tables, matrix, charts and sub reports.
• Created Linked reports and Ad-hoc reports based on the requirement and Linked reports are created in the Report Server to reduce the repetition the reports.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Data analysis and Reporting with extensive use of power pivot and pivot tables.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Created Tables, Views, Stored Procedures, Triggers and Created efficient Stored Procedures for the optimal performance of the system.
• Responsible for creating and modifying T-SQL stored procedures\triggers\functions for validating the integrity of the data.

Environment: Windows Server 2012, SQL Server 2008R2/2012, SSRS, SSIS, SSAS, T-SQL, Excel (Power pivot, pivot table), power view, share point server, MDX

Confidential

DBA/BI Developer

Responsibilities:

• Extracted data using SSIS packages (ETL) from different server locations and data sources. Created packages to validate, extract, transform and load to centralized SQL Server using OLEDB providers from the existing diversified data sources.
• Installation of SQL server 2008 R2 on 2 node cluster. Responsible for Backup and restores on staging and QA environments.
• Responsible for backup’s, restores and granting access to SQL server databases and Instances.
• Responsible for Promoting the code to the PROD SQL server. Create scripts for deployments and conduct reviews on schema changes and Impact on application working.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, Flat file, and Text format data.
• Designed high-level SSIS architecture using Dimensional modeling for overall data transfer from the source server to the Enterprise services warehouse. Analyzed and designed the business rules for data cleansing that are required by the staging & OLAP and OLTP databases.
• Designed and implemented parameterized and cascading parameterized reports using SSRS.
• Deployed generated reports on to 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.

Environment: MS SQL Server 2008R2/2005, windows server 2008 R2, SSIS, SSAS, T-SQL, SSRS-2008/2005, Erwin, C#.Net, Access, Excel, Visual Studio 2008/2005 and XML.

Confidential

MSBI Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Created SSIS Packages to import and export data from Excel, Text files and transformed data from various data sources using OLEDB connection by creating various SSIS packages.
• Designed and implemented ETL processes based in SQL, T-SQL, stored procedures, triggers, views, tables, user defined functions and security using SQL Server, SQL integration service.
• Identified slow running query and optimization of stored procedures and tested applications for performance data integrity using SQL profiler.
• Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, using defined objects, chart.
• Created stored procedures for inserting, updating and deleting records in SQL server and maintained.
• Created different parameterized reports (SSRS 2008R2) which consist of report criteria in various reports to make minimize the report execution time and to limit the number of records required.
• Report parameters included single valued parameters, multi value parameters that also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Created a variety of charts like drill through, drill down, parameterized, cascaded and sub reports, pie, and line worked on KPI’s using SSRS.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance in SSRS.

Environment: s: SQL Server 2008R2, SQL BI Suite 2008R2 BIDS(SQL Server Integration Services, SQL Server Analysis services, SQL Server Reporting Services), C#.NET, Windows Server 2003, SQL Server Report Builder, Windows server 2008 R2, Team foundation server(TFS), Oracle JD Edwards, Dashboard, Data Warehouse.

Confidential

SQL Database/BI Developer

Responsibilities:

• Identified various data sources, formulated data dictionaries, design and develop data models (Physical/ logical data models) based on the given specs and requirements.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Experience in end-user reporting definition, development and platform support using SQL Server Reporting Services (SSRS) and Performance Point.
• Performed ad hoc queries, design and deployed reports using SSRS and resolved any issues related with it.
• Created Logical and physical Data models for SQL server 2008.Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Created complex Stored Procedures, Triggers, Cursors, Tables, Views, Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.

Environment: s: SQL Server 2005/2008 Enterprise Edition, .NET 3.5, SQL BI Suite (SSAS, SSIS, SSRS), PPS, XML, MS Power point, MS Project, Windows server 2003 R2, Microsoft Dynamics, Crystal Reports, SharePoint, MOSS 2007,