SUMMARY

• More than 7+ years of experience in Database Design, Business Intelligence and Development and of Microsoft SQL Server 2012/2008/2005 in Energy, Retail, Financial, Insurance, Health Care and Service industries.
• Strong knowledge of Software Development Life Cycle (SDLC) with Analytical, Programming and Problem solving skills.
• Experience in installing, configuring, managing, upgrading, and troubleshooting SQL Server 2012/2008/2005 .
• Expert Knowledge of Transact SQL (T - SQL), Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Expertise in creating Tables, Joins, Indexed Views, Cursors, Indexes, Stored procedures, Effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage according to the business rules using SQL Server 2012/2008/2005
• Experience with Database Tuning Advisor and SQL Profiler for tracing, auditing and Performance Tuning.
• Expertise in developing reports like Tabular Reports, Matrix Report, Charts, Custom Reports and for the end user requirement Ad Hoc Reports using SQL Server Reporting Services (SSRS) in Business Intelligent Development Studio (BIDS).
• Expertise in Developing Parameterized reports, Cascading, Sub Reports, Drill-down reports, Drill-through reports with drop down menu option, web reporting by customizing URL Access.
• Worked with writing complex reports for Batch process using SSRS and worked with building the portal to access all the reports.
• Expertise in Extract, Transform, and Load (ETL) solutions for data warehousing using tools like SQL Server Integration Service (SSIS), Data Transformation Services (DTS) and BCP and implemented Incremental load in SSIS packages.
• Experience in Creating, Maintaining and Deploying SSIS Packages from Test servers to Production servers and migrating DTS Packages from 2000 to 2005/2008.
• Expert in maintaining Error logging using Exceptional Handling in T-SQL and SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, scheduling DTS/SSIS Packages and Backup/Restore of a database.
• Expertise in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Good Knowledge in Logical Data Modeling, Data warehouse design concepts, Dimensional Modeling using Star, Snowflake, Normalized and De-normalized Schemas with respect to query and analysis requirements.
• Expert in defining calculated members, KPI’s, Aggregations with SSAS.
• Performed unit testing of at various levels of the data warehouse lifecycle.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Sr. SQL Developer

Responsibilities:

• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Experience in creating Tablix Reports, Matrix Reports, charts, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Created lot of Ad-hoc reports for Finance, Inventory, and Risk Assessment teams.
• Experience in configuring and deploying SSRS reports on to Microsoft Office SharePoint Server 2010.
• Responsible for creating the reports based on the requirements using SSRS 2008.
• Written complex Tax queries to create our flattening, Aggregations, nightly jobs.
• Developed brand new Cubes using SQL Analysis Services (SSAS).
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• Created new Dimensions in the cube and pulled these new columns in to reports upon financial team request.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2008) and stored the data into the intermediate Staging Database using the SSIS ETL tool
• Developed complex stored procedure using T-SQL to create stored proc and for reports.
• Scheduled the Reports to run on daily and weekly basis in Report Manager on the share point 2010 and also email them to individual teams and analysts to review in Excel and .csv formats.
• Build database queries and test cases for the testing team to test the reports
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Good understanding in Source control concepts. Created Database projects under TFS.

Confidential, Lakeland, FL

Sr. Technical Analyst (SQL)

Responsibilities:

• Installation and configuration of SQL Server Reporting Services (SSRS) 2005, 2008.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server 2010.
• Created report models and applying row level security filters for report model.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Created SSRS reports using Report Parameters, Multi-Valued Parameters and deployed on SharePoint 2010.
• Created reports using stored procedure and created scheduling, snapshots and subscriptions for the reports in SSRS 2008.
• Performance for 30 reports has been increased till day.
• Created use full indexes and removed key lookups and table scans to increase the performance of reports.
• 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.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS.
• Involved in Creation of Dimensions using STAR and SNOWFLAKE Schema
• Used both visual studio 2008 and 2005 for creating and deploying the reports.
• Given training the non reporting team on Reporting Services.
• Communication with the reporting team in Buenos Aires (Argentina) team which has strength of 10 is excellent.
• Communication with the rest of the teams like Testing and functional team was good
• Completed new stories and fixed Defects with in time for every release.
• Had good knowledge about TFS.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Tested queries to optimize the procedures and triggers to be used in production.
• Had good knowledge how agile methodology works.

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.

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.

Confidential, Denver, CO

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 2000 to 2005 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.

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.