SUMMARY

• Over 7 years of IT Experience in Database Design, BI - Development of Microsoft SQL Server 2012/2008/2005 on various development, test and production environments in various business domains.
• Experience in writing T-SQL (DDL, DML and DCL) scripts in all MS SQL server environments.
• Proficient in creating Triggers, Tables, Stored Procedures, Functions, Views, Indexes, Dynamic SQL, joins, Cursors, CTE and Constraints in T-SQL to facilitate data consistency in MS SQL Server 2012/2008/2005.
• Highly proficient in Tuning SQL queries and improving the query performance.
• Experience in optimization and performance tuning using SQL profiler, Index tuning wizard, Performance Monitor and Execution plan.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Created SSIS packages to Extract, Transform and load (ETL) data from Excel, Database, XML File and Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Experience with file transfer protocols, including standard FTP and SFTP
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Created Configurations to make package portable and created Event handlers for handling package error.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Developed reports using global variables, expressions and functions.
• Expert in Creating and managing roles for security in SSRS reports.
• Expertise in using Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Ability to define and develop Report Structure with data definition, report layout and report definition language.
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and creating report layouts using SSRS 2012/2008.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports, Conditional, List items, Charts, Sub reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created various Complex Formula Reports to query the database for business Intelligence.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Deployed SQL Server Reports on to the report manager and delivering using ‘pulled’ and ‘pushed’ methodologies.
• Expertise with parameterized reports and Cascade Parameterized Reports in SSRS 2005/2008/2012.
• Experience in creating data driven subscriptions in Report Manager.
• Created Dashboards using Performance Point Dashboard designer, added different dashboard items like Scorecards, KPI’s and Filters.
• Created various Performance Point filters like List, Tree and Multi-Select Tree using different filter Templates like Named Set, MDX Query and Custom Table.
• Configured the Dashboard zones and connected different dashboard components to achieve Cascading Parameters and Parameter driven reports in Performance Point.
• Experience in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions & MDX Queries using SQL Server 2012/2008 Analysis Services.
• Excellent hands-on experience with data modeling tool like Erwin and strong knowledge of Relational and Dimensional database modeling concepts with star schema and snowflake schema’s design and implementation.
• Experience using different Version Control Tools like Microsoft Source Safe and TFS.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.

TECHNICAL SKILLS

Languages: SQL, T- SQL, HTML, XML, Java

Databases: SQL Server 2008/2005/2000/7.0 , MS Access

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS)

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data

Web technologies: .Net, ASP.Net, Ado.Net, Silver light, Jquery, Ajax, Javascript, css

Data Modeling Tools: Erwin, Visio

Testing: Unit Testing, Performance Testing, Integration Testing, Stress Testing

Other Software: MS Office- 2007/2003/2000

Operating Systems: Windows / 98/2000/2003/ XP/Vista

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE

Confidential, St Petersburg, FL

SQL Server SSIS/SSRS Developer

Responsibilities:

• Responsible for creating SSIS packages to extract data from different sources to consolidate and merge into one single source.
• Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
• Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-threading Concepts with Synchronous and Asynchronous transactions.
• Created SSIS and SSRS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2012.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Created different types of SSRS reports like linked reports, tabular reports, charts, sub-reports, drill-down and various parameter based reports like drop down, Multi-Valued, Multi-select.
• Developed custom ad-hoc reports by using SQL Server Reporting Services (SSRS).
• Created Ad-hoc reports Using Report Builder, Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Dashboards using Performance Point Dashboard designer, added different dashboard items like Scorecards, KPI’s and Filters.
• Deployed SSRS reports to SharePoint Integrated Server mode and later used these reports on different Dashboard tabs.
• Created various Performance Point filters like List, Tree and Multi-Select Tree using different filter Templates Named Set, MDX Query and Custom Table.
• Configured the Dashboard zones and connected different dashboard components to achieve Cascading Parameters and Parameter driven reports.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Created subscriptions to provide a Daily/Monthly/Quarterly basis reports.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Involved in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2012. Developed reports from OLAP cubes.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool.
• Managed and troubleshoot report server related issues.
• Involved in Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
• Identified Dimensions and Facts, Used MDX to extract data from cubes and created MDX script for representing Cube Calculation.
• Created logging, custom logging and error handling packages.

Environment: s: MS SQL Server 2012. Windows Server 2003/2008 and VM ware. ERWIN, SSRS, SSIS, SSAS, Litespeed, VERITAS netbakups, MS Excel Power Pivot, Windows7 and Windows 8, Performance Point Dashboard Designer, MS SharePoint Server 2010.

Confidential, Swiftwater, PA

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Created packages using SSIS Designer for exporting heterogeneous data from OLE DB Source.
• Migrated packages to SSIS and modified the packages accordingly using the advanced features of Integration Service.
• Configured Server for sending automatic mails to the respective people when a SSIS package fails.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Extensively worked on Data Flow transformations like Foreach Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Created SSRS reports using Report, Drop-Down, Multi-Valued Parameters and Debugging Parameter Issues in Matrix Reports and Charts.
• Designed and developed various complex reports and different types of charts.
• Generated reports that can handle dynamic grouping and dynamic sorting.
• Created drill down, drill through, sub reports and many more complex reports.
• Permitted access to the reports based on designation of the viewer like store manager or district manager or associate extra.
• Involved in creating report models and applying row level security filters for report model.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.
• Used Pivot table to provide structure to Reports in proper manner like months etc.
• Designed different kinds of reports like Linked, cascaded and parameterized reports.
• Formatted the report layout for the requirement of the end users.
• Deployment of the developed reports on to the server for the end users.
• Deployed the developed reports and upgraded the system.
• Responsible for creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports, Linked Reports, and Reports using stored procedures using SQL Server Reporting Services 2012.
• Used SQL Server Agent for scheduling jobs and alerts.
• Written several SQL Scripts such as finding tables with Identity Columns, tables that do not have primary key in order to streamline the process of replication.

Environment: s: Windows server 2000/2003, MS SQL Server 2012,MS SQL Server 2008 R2, SQL Server Analysis Services, Report Builder 3.0, DTS, VMware, SQL Server Reporting Services and SQL Server Integration Services, Performance Point Dashboard Designer, MS SharePoint Server 2010.

Confidential, Ft Lauderdale, FL

SQL Server Developer/ SSAS/ SSRS

Responsibilities:

• Created SQL Server Reports using SSRS 2008 and scheduled data driven subscriptions to automate the monthly/quarterly reports.
• Created parameterized reports for the AE’s and Customers.
• Formatted the report layout for the requirement and deployment the developed reports on to the server for the end users.
• Generated Daily, Weekly and monthly reports for the analysis of managers and end users.
• Supported 24/7 for the production system for post deployment Reports on the server.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
• 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.
• Created Technical Documentation for reports and maintenance/enhancements of existing Reports.
• Built MDX (Multi Dimensional expressions) queries and Data Mining Extensions (DMX) queries for Analysis Services & Reporting Services.
• Calculated members, named sets, and execute other script commands to extend the capabilities of a MS SQL Server 2008 Analysis Services (SSAS) cube.
• Responsible for the deployment of the Cube on the SSAS.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Performed data transfers using BCP and BULK INSERT utilities.

Environment: MS SQL Server 2008, MS SQL Server Reporting service 2008, MS SSIS, T-SQL, Windows XP. SQL Server 2000/2005 Enterprise, SQL server BI development studio, Microsoft Visual Studio 2005

Confidential, Dallas, TX

SQL Server Developer/SSIS Developer/SSRS Developer

Responsibilities:

• Extensive work on SSIS creating all the interfaces between front end application and SQL Server 2008 database, then from legacy database to SQL Server Database and vice versa.
• Integrate the SSIS package, converting all existing packages to SQL Server 2008 by adding extra SSIS task.
• Migrated SQL server 2008 tables into CSV files using SSIS packages.
• Created and executed SSIS packages to populate data from the various data sources and for different data loading operations on many applications.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML etc) and loaded the data into target data sources by performing different transformations using SSIS.
• Install SQL Server Reporting Services (SSRS) and configure the reporting services configuration.
• Perform T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2008.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008 r2.
• Schedule execution of reports in report manager and send them to managers on daily and weekly basis.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Automated daily Database backups, restores and integrity checks using Management Studio and creating or updating indexes using SQL Profiler.
• Involve in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
• Wrote T-SQL code for creating cursor and handling the data validations.
• Develop the Documents for Logging/Error Handling for SSIS Packages.
• Handling the orphan rows in Dimension and Fact tables.
• Participated actively in analysis and discovery phases of data warehouse implementation.
• Handling the errors during data moving and Sequencing the task as per requirements.
• XML result set from Stored Procedures to create custom XML file for third party data export.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required.
• 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.
• Backup, restore of entire system & other databases as per requirements, and also scheduled those backups as part of automation in sql management studio.

Environment: s: Windows server XP/NT2000/2003, MS SQL Server 2008/2005,MS SQL Server 2005, SQL Server Analysis Services, DTS, VMware, SQL Server Reporting Services and SQL Server Integration Services, MS Office 2003/2007.

Confidential, Chicago, IL

SQL Server Developer/SSRS Developer

Responsibilities:

• Written stored procedures to populate final database tables from staging tables and clean inaccurate data
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Created and maintained versions of SQL Scripts for Tables, Indexes, Constraints, and Views etc. for the entire project.
• Providing solutions to improve the existing processes and production support for various batch processes and also created the schedule for newly incorporated batch programs and processes.
• Wrote DDL, DML scripts for Schema, Table space and Cluster creation and alteration.
• Worked with the Program Architect and Technical Architect in design sessions to develop high-level solutions architecture for SQL Server Reporting Services solution.
• Generated Daily, Weekly, and Monthly Reports as per the 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 2005.
• 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.
• Wrote stored procedures for report generation in SQL Server 2008/2005.
• 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.
• Generated different types of Reports (Tabular/Matrix) using MS SQL Server Reporting Service (SSRS).
• Created Technical Documentation for reports and maintenance/enhancements of existing Reports.
• Actively participated in User Acceptance Testing and Debugging of the system.

Environment: SQL SERVER 2005/2008, Microsoft Reporting Services, Toad, T-SQL, Oracle 10g, Visual Source Save (VSS), WIN NT, Erwin.

Confidential

SQL Server Developer /SSRS Developer

Responsibilities:

• Created complex Stored Procedures and Functions to support the front-end application.
• Created database triggers to implement business requirements.
• Monitored growth of database objects for capacity planning and involved in tuning the database and T-SQL queries using Explain Plan.
• Optimize SQL queries for improved performance and availability.
• Worked with Quality assurance to develop test plans and test cases to conduct system testing.
• Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Developed and created data dictionary, advanced queries, views, indices, and functions for databases.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Created reports from database onto excel spreadsheet using DTS.
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Involved in creating Users and Roles, and managing security and permission of database, managing Jobs and error logs.
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.
• Used SSIS transformation for Data Cleansing to remove unnecessary columns, eliminated redundant and inconsistent data and Unnecessary Data like removing empty rows.
• Managed up gradation of DTS packages to SSIS packages.
• Configured server for sending automatic mails on the failure and success of the scheduled job.
• Involved in analyzing MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Involved in designing high level dashboards according to business requirement using SSRS 2005.
• Expertise in creating Reports, Sub Reports, drill down reports using various features like Charts, filters etc.
• Experienced in developing stored procedure driven reports, building custom application on reports and formula writing/editing in reports.
• Created report models for ad-hoc reports using SSRS 2005
• Defined report layouts for formatting the report design as per the need.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Formatted the reports using Global variables, Expressions and Functions using SSRS 2005.
• Generated periodic reports based on the statistical analysis of the data using SSRS 2005.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.

Environment: Windows 2003 Server, MS SQL Server 2000, MS SQL Server 2005, SSRS. SSRS, DB2, Oracle 9i, ASP, ODBC, VBScript, Windows 2000/XP, IIS 5.