SUMMARY

• Over 7+ years of experience in SQL Server database development and administration, extensively worked in OLTP, OLAP, Client - Server & Enterprise Data warehouse Environments.
• Strong experience in Microsoft Business Intelligence Tools including Integration Services, Reporting Services and Analysis Services.
• Skilled at developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and indexes with T-SQL.
• Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services ( SSIS ), Log Shipping, DTS, Bulk Insert and BCP.
• Developed, monitored and deployed SSIS packages.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Experience in SQL Server 2012 Self Service BI tools like Power view, BISM Tabular models and SQL Server Data tools.
• Strong experience in Oracle database, worked with versions Oracle 9i, 10g, 11g.
• Solid experience in converting legacy MS Access and Crystal Reports to Reporting Services 2008/2008 R2.
• Strong experience in creating dashboards using gauges and charts for analysis using SSRS 2008 R2.
• Experience in integrating SSRS reports into external applications using report viewer controls and custom URLs.
• Hands-on experience in using self service BI tools such as power view, report builder and BIDS
• Experience in Designing, Building Dimensions, Cubes with Star schema and Snow-flake schema using SQL Server Analysis Services (SSAS).
• Involved in developing reports from SSAS cubes using client tools like SSRS 2008, Excel 2007 and Report Builder.
• Experience in installing, configuring and monitoring MS SQL Server 2012/2008/2005/2000 installations.
• Hands-on experience in Upgrade/Migration of MS SQL Server using any suitable approach.
• Strong experience in performance tuning and query optimization using tools like SQL Server Profiler,
• Database Tuning Advisor and Index Tuning Wizard.
• Good knowledge and exposure to Database Mirroring, Replication, Log shipping, backup and restore procedures, disaster recovery and performance tuning.
• Strong knowledge in implementing Transactional, Merge and Snapshot replications.
• Good understanding of high availability SQL Server solutions using active-active and active-passive Clustering modes.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Sound knowledge of software development life cycle (SDLC) models like Agile and RUP (Rational Unified Process) along with substantial experience with object oriented analysis and design methodologies.
• Solid experience in version control tools such as Team Foundation Server (TFS) and Sub version (SVN).
• Experience in dimensional modeling using Star schema (identification of facts, measures and dimensions) and Snowflake schema for designing a Data Warehouse using tools like Erwin and E-R Studio.
• Expertise in writing DML and DDL Code, Dynamic SQL as well as Query optimization & performance tuning
• Expert in using Complex Stored Procedures, User Defined Functions (UDFs), Common Table Expressions (CTEs), SharePoint 2010 development and Performance Point Services (PPS).

PROFESSIONAL EXPERIENCE

Confidential, Boston,MA

BI Developer (SSRS/SSIS/SSAS)

Responsibilities:

• Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE's, Views, Joins and Triggers.
• Developed SSIS Packages and Stored Procedures to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse.
• Participated in the design and development of the Data Warehouse using Star Schema and Snowflake Schema.
• Developed SSAS Cubes by creating Measure Groups, Dimensions, Aggregations, Hierarchies, Partitions, and Perspectives using SSAS 2008 R2.
• Setup and monitored jobs for loading and processing SSAS Cubes.
• Troubleshoot issues with ETL load (SSIS and Stored Procedures) and Cube processing.
• Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating proper Indexes using SQL Profiler and Database Tuning Advisor.
• Created SSRS reports such as tabular, matrix, charts, dashboard and sub-reports using SSRS 2012/2008R2.
• Developed stored procedures, cascading parameters and custom code for developing complex SSRS reports.
• Created SSRS dashboards using charts, gauges, indicators and data bars.
• Deployed SSRS reports in native and SharePoint mode.
• Used SSRS reports with parameters from PerformancePoint Services deployed in SharePoint 2013.
• Developed MDX queries for SSRS reports from SSAS Cubes.
• Developed powerview reports using Tabular Models in SQL Server Data Tools.
• Created standard and data driven subscriptions for weekly, monthly and daily reports.
• Extensive used Team Foundation Server to implement version control for MSBI (SSIS/SSRS/SSAS) projects.
• Training business users on using Excel 2013/2010 to create ad-hoc pivot tables and charts from SSAS cubes and using Performance Point Services (UI).
• Participated in code-review sessions on existing SSRS report's performance and Dataset query tuning.
• Worked with business analysts on creating new SSRS reports with requirements like data source, parameters, formatting, printing and subscriptions.
• Created script tasks and components with C# and VB.NET in SSIS as part of ETL load.

Tools: and Technologies: SQL Server 2014/2012/2008 R2/2008, SharePoint 2013/2010, SQL Server Data Tools, T-SQL, SSIS, SSRS, SSAS, Tabular, Excel 2013, XL-Cubed, Power view, Power pivot, Performance Point, MDX, Report Builder 3.0, DTS, C#, VB.NET, Erwin 4.0, XML, SVN, Rally, Windows Server 2008,.NET 3.5.

Confidential, Rochester, MN

Sr. Technical Analyst (SSRS/SSIS)

Responsibilities:

• Design, create and regular tuning of physical database objects (tables, views, indexes) to support normalized and dimensional models.
• Requirements analysis, data assessment, business process reengineering.
• Coding using Teradata Analytical functions, BTEQ SQL of TERADATA, write UNIX scripts to validate, format and execute the SQLs on UNIX environment.
• Index maintenance & analysis.
• Working with ETL leads to formulate ETL approach and appropriately uses Teradata Tools and Utilities.
• Worked on loading various tables using Teradata Parallel Transporter.
• Worked on OLELOAD to load tables and to export tables into spreadsheets.
• Participate in Data Modeling sessions to identify data warehouse requirements.
• Involved in design, data modeling.
• Create and Maintain Teradata Databases, Users, Tables, Views, Macros, Triggers and Stored Procedures.
• Create and Maintain Users Profile Definition to determine the Performance.
• Worked on complex queries to map the data as per the requirements.
• Populate or refresh Teradata tables using Fast load, Multi load & Fast export utilities for user acceptance testing and loading history data into Teradata.
• Designed delta load on all fact tables.
• Worked on Fast load, Multi load for loading the data into the Teradata database.
• Involved in working with PMON, monitoring the usage of the users.
• Involved in Performance tuning for the long running queries.
• Explored ways to optimize existing ETL processes and enhance their performance.
• Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata) and SQL*Plus, SQL*Loader (Oracle).

Tools: and Technologies: SQL Server 2008 Enterprise Edition, SQL Reporting services, SQL Server Data Tools, T-SQL, SSIS, SSRS, Visual Studio 2008, SSRS, T-SQL, Windows Server 2008 R2, SharePoint 2010, MS Access, MS Visio.

Confidential, St. Petersburg, FL

SQL BI Developer

Responsibilities:

• Installed and configured SQL Server 2008.
• Installed & configured SQL Reporting services Add-in for SharePoint 2010.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server 2010.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, and Multi Valued Parameters and deployed on SharePoint 2010.
• Created variety of reports from SSAS cubes and deployed on to SharePoint 2010.
• Created reports using stored procedure and also involved in scheduling, creating snapshots and subscriptions for the reports SSRS.
• Generated Tabular, Sub reports, Parameterized reports, pie charts and bar charts for the Business users and created report models to support AD HOC REPORTING.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• 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.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Experience in Programming AMO OLAP advanced objects like KPI’s and Perspectives.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services.
• Installed and configured share point 2010.
• Activated performance point services in share point 2010.
• Experience in Planning and Monitoring reports in Performance Point Server.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.
• Used Performance Point Server to identify KPI ‘S, build score boards, reports and dash boards
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects
• Migrated database and performance point reports from one server to another.
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors.
• Created Views and Index Views to reduce database complexities for the end users.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.

Tools: & Technologies: SQL Server 2008/2005, Visual Studio 2008, SSRS, SSAS, SSIS, T-SQL, Windows Server 2008, SharePoint, Performance Point Server 2010, SQL Reporting services Add-in, Report Builder 2.0.

Confidential, Des Moines, IA

SSIS-SSRS-SSAS Developer

Responsibilities:

• Migrated from SQL Server 2005 to SQL Server 2008 and worked on the transition.
• Using SQL server reporting services (SSRS) and crystal Reports delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 and 2008(using SSRS, T-SQL, scripts, stored procedures and views).
• Created different types of reports such as Cross-Tab, Drill-down, Top N, Summary, Ad-Hoc, Tablix Reports, Matrix Reports, Parameterized Reports, Cascaded Parameters, Gauges, Interactive Charts OLAP and Sub reports, and formatting them using both SSRS 2008/2005.
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
• Implemented Data Cleaning, Incremental Data Loading, Event Handling and Error Handling.
• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and responsible for Deploying and also Scheduling the SSIS packages and Jobs.
• Performed database transfers and queries tune-up, integrity verification, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services (SSAS) and performed partitions, and Aggregations, calculation of queries with MDX.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Involved in project planning, scheduling for database module with project managers.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Performance tuning to optimize SQL queries using query analyzer and DMV.
• Tested to optimize the procedures and triggers to be used in production.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.

Tools: & Technologies: SQL Server 2005/2008, SSAS, SSIS, SSRS, T-SQL, Micro strategy, Performance Point Server 2007.

Confidential

SQL Programmer Analyst

Responsibilities:

• Actively participated in Gathering User Requirement and Functional Specification.
• Defined Indexes, Views, Constraints and Triggers to implement business rules.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Experience in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Identified and defined the Datasets for the report generation and wrote the queries for the drill down reports, sub reports.
• Installed and configures Internet Information Service (IIS) for Reporting purpose.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle, Sybase, Seibel, Flat files, Excel etc ;)
• Converting all existing DTS package of MS SQL by adding extra SSIS task.
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS and scheduled, executed packages using SQL Server Agent.
• Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment and partitioned cubes in order to increase the performance of cubes.
• Involved in Creation of Dimensions using STAR and SNOWFLAKE Schema
• Configured and mapped each KPI with Multiple data sources, threshold values, bending methods, and indicators.
• Used Performance Point Server to identify KPI ‘S, build score boards, reports and dash boards.
• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS.
• Participated in the Design, Creation and Maintenance of SQL Server database.
• Created Joins, Sub-Queries, Views and User Defined Functions for complex queries involving multiple tables and developed User Defined Functions.
• Involved in Optimization and Performance of queries and Used DBCC command to free SQL cache memory.

Tools: & Technologies: Windows 2003 Server, T-SQL, SSIS, SSRS, SSAS, MS SQL Server 2005, BIDS Visual Studio (BI) Tool.

Confidential

Programmer Analyst

Responsibilities:

• Created new tables, written stored procedures for application developers and some User- defined functions. Created SQL scripts for tuning and scheduling.
• Created Triggers to enforce data and referential integrity.
• Defined Check and default constraints, Indexes, and Indexed Views.
• Developed reports using SSRS and created drilldown, matrix, Ad-Hoc reports for business users using SSRS.
• Import/Export using MS Access, Excel and Text file to/from SQL Server
• Transformed data from various data sources like Excel, Flat file using OLE DB connection by creating various DTS packages.
• Perform daily database backup & restoration and monitor the performance of Database Server
• Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.
• Involved in logical and physical modeling based on the requirements.
• Configured mail profile for sending automatic mails to respective people when job is failed or succeed.

Tools: & Technologies: SQL Server 2005/2000, T-SQL, VB 6.0, DTS, SSRS, SSAS XML, Visual Source Safe, MS Office