Summary:

• Skilled software professional over 7 years of IT industry experience with Microsoft SQL Server, Integration Services SSIS , Reporting Services SSRS and Analysis Services SSAS environments.
• Expert in developing T-SQL DDL, DML statements, data integrity constraints and worked on validation issues.
• Extensive work experience in normalization and de-normalization techniques on both OLTP and OLAP systems in creating database objects like tables, constraints primary key, foreign Key, unique, default, check , indexes.
• Expertise in writing T-SQL queries, dynamic-queries, sub-queries and complex joins for generating complex stored procedures, triggers, user-defined functions, views and cursors.
• Excellent command over managing alerts, operators and jobs through SQL server agent.
• Thorough knowledge of addressing performance issues and involved in index tuning, performance tuning, query optimization, database optimization, data profiling and database consistency checks using DBCC commands.
• Expert in data extraction, transforming and loading ETL using various tools such as SQL server integration services SSIS , DTS, bulk insert and BCP.
• Experience in extraction and migration of data from heterogeneous data sources like Excel, MS Access, oracle, flat files and DB2 to MS SQL server by using import export wizard and SSIS.
• Well-versed in usage of SSIS control flow items.
• Experience in creating SSIS packages using active X scripts, providing logging and error handling by using event handler and custom logging for SSIS Packages.
• Experience in loading facts and dimensions using SSIS Packages on data warehousing projects.
• Experience in performance tuning in SSIS packages by using row transformations, block and unblock transformations.
• Experience in enhancing and deploying SSIS packages from development server to production server.
• Strong experience in developing parameterized, drill down, drill through, chart, matrix, Ad-Hoc, sub-reports using SSRS.
• Experience in working with report snapshots, linked reports and used report manager for deploying reports in SSRS.
• Expertise in creating data driven subscription reports by using report builder in SSRS.
• Experience in working with MDX queries and developing reports using SSRS.
• Created Crystal Reports on daily, weekly and monthly basis for manager's review.
• Experience in SQL server analysis services SSAS /OLAP design and implementation in building OLAP cubes, multi-dimensional cubes, and data modeling and calculate the metrics that were revealed in the functional analysis.
• Experience in designing and building the dimensions and cubes with star and snowflake schemas using SSAS.
• Created and configured data source and data source views, dimensions, cubes, measures and MDX queries using SSAS.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills and has ability to handle multiple tasks can take initiative to handle responsibilities independently as well as a proactive member of a team.

TECHNICAL SKILLS:

Professional Experience:

Confidential

MS SQL Server SSRS/SSIS Developer

Responsibilities:

• Debugged and deployed reports in SSRS.
• Used SSRS to create, execute, and deliver tabular, matrix and charts reports.
• Designed, developed, modified and enhanced the database structures and database objects.
• Created several SSIS packages in Microsoft SQL Server 2005.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
• Used SSIS to create ETL packages .dtsx files to validate, extract, transform and load data to data warehouse databases
• Wrote several complex stored procedures for the ease of application.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Generated various Report models on Views due to security issues and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.

Environment: Microsoft SQL Server 2000/2005, Business Intelligence tools SSIS, SSRS, SSAS, DTS, ODBC, Oracle 8i, MS Access, T-SQL programming.

Confidential

SQL Server BI SSRS/SSIS/SSAS Developer

Responsibilities:

• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Wrote store procedures to generate account statements for different types of accounts.
• Worked on SQL Server Integration Services SSIS to integrate and analyze data from multiple heterogeneous information sources Oracle Sybase .
• Created SSIS packages to load data into Data Warehouse using various SSIS Tasks like execute SQL task, bulk insert task, data flow task, file system task, execute package task.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Designed cubes with star schema using SQL Server Analysis Services SSAS .
• Experience in SQL Server Analysis Services SSAS for data mining to identify rules and patterns in the data.
• Experience with SQL Server Reporting Services SSRS to author, manage, and deliver both paper-based and interactive Web-based reports.
• Upgrade enhancements, maintenance, production support and bug fixes for the project.

Environment: SQL Server 2008 Enterprise Edition, SSIS, SSRS, SSAS, Windows Server 2008, Oracle 10g.

Confidential

SQL SSRS/SSIS Developer

Responsibilities:

• Responsible for creating reports based on the requirements using SSRS 2008-R2/2012. Worked on generating reports using Crystal Reports, SQL Server Reporting Services and Excel spreadsheet. Created complicated reports like parameter based reports, graphical reports, excel reports, drill-down chart and tabular report using SSRS 2008-R2/2012.
• Continuously interacted with users together the business requirements.
• Created design specification documents for the new reports developed through SSRS.
• Published ad-hoc reports through Report Manager.
• Used complex expressions to calculate, group, filter, parameterize, and format the contents of a report.
• Data driven subscription both email and windows file sharing.
• Deployed and uploaded the SSRS reports to SharePoint server for the end users to look at them.
• Fine-tuned existing reports by running execution plan on queries and identifying tables that need indexes.
• Designed and created databases, tables, views, stored procedures and triggers.
• Modified existing database by adding tables and relationships.
• Creating Star and Snow Flake Schema design using Visio, defining relations between tables Primary keys, foreign keys .
• Designed, modified and troubleshoot SSIS packages.
• Control Flows, which include tasks and containers that execute when the package runs. Organized tasks in sequences and in loops during creation of package in SSIS.
• Utilized SSIS checkpoint, loading dimension with the SSIS slowly changing dimension wizard and used different SSIS control flows.
• Created ETL in DTS packages by using Data Transform Task, VBScript task, SQL task and send Email task to migrate data from different functional databases into SQL Server 2008R2/2012.
• Established ETL design practices for optimization and performance of packages, and parameterized SSIS packages with the use of environment variables. .
• Created notifications, alerts to let support team know in case there are any failures.
• Migrated database from SQL Server 2008-R2 to SQL Server 2012 using both Copy Database Wizard, and Detach and Attach method.
• Configured Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, TRY and CATCH Blocks.

Environment: MS SQL Server 2008-R2/2012, Management Studio SSMS , ETL, ASP.NET, Crystal Reports 9.0, Data Modeling, OLAP, Data warehousing, T-SQL, DB2, SSIS, SSRS, SSAS 2008-R2/2012, ASP.NET.

Confidential

MS SQL Server BI Developer SSIS/SSRS

Responsibilities:

• Involved in upgrading the instance of development environment of SQL Server 2005 to SQL Server 2008 with appropriate hot fixes and service packs.
• Wrote several scripts such as finding long running queries, blocking sessions, archiving data from production server to archive server and populating reporting.
• Created stored procedures to perform calculation and update of data in the database.
• Created stored procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Generated server side T-SQL scripts for data manipulation and validation, and created various snapshots and materialized views for remote instances.
• Maintained SQL scripts for creation of database objects.
• Designed a report on the monitoring of server performance using Task Manager. This report gives a detail report to the management on the performance of the server.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Maintained reliability and availability of existing MS SQL environments.
• Generated Daily, Weekly and Monthly scheduled based reports regarding assigned projects to designated Managers and Clients.
• Used SharePoint for deploying .rdl files and uploading of the internal business documents.
• Suggested cost saving Techniques. Designing/Implementing backup policies for databases.
• Created web forms using .NET components, on SharePoint to show live data from underlying data-sources like SQL Server to Clients enabling them to edit the data and update the data in the underlying data-sources and allowing the users to insert data into the underlying data-sources.

Environment: Microsoft SQL Server 2005/2008, SQL Server Business Intelligence Development Studio BIDS , SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , Oracle 10g, Visual Studio 2005, C , ASP.NET, T-SQL.

Confidential

SQL Server Developer

Responsibilities:

• Created and modified procedures, triggers and functions.
• Used profiler to monitor the performance, debug Transact-SQL statements and stored procedures in existing application to identify slow running query etc.
• Modified store procedure for performance tuning.
• Used DTS packages to do file operation to apply business rules.
• Extensively used ultra-edit to verify the text file provided by employer/agency and keep trace of files provided by employer/agency.
• Transformed data from text file to SQL server using OLE automation objects.
• Deployed database objects from development/testing environment to production environment.
• Created DTS package to export and import data from SQL Server to text files and data files.
• Worked with Application Developers to support development activities and achieve optimal efficiency.
• Monitored and scheduled existing/new jobs on production environment.
• Created all administration tasks of SQL Server.
• Used system stored procedures and DBCC commands.
• Kept trace of version of store procedure in Visual SourceSafe.
• Responsible for keeping system and databases up-to-date by making necessary changes.

Environment: MS SQL Server 2005/2008, MS SQL Server Integration Services 2005/2008, MS SQL Server Reporting Services 2005/2008, T-SQL, Business Intelligence Development Studio BIDS .