PROFESSIONAL SUMMARY

• Having 4+ years of strong IT experience in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2012/2008/2005 with various business domains like Banking, Insurance and Health care.
• Exceptional hands on working knowledge with SQL ServerIntegration Services(SSIS), SQL Server Analysis Services (SSAS) andSQL ServerReporting Services(SSRS).
• Expertise in Data Warehouse Modeling with SQL Server Analysis Services (SSAS).
• Expertise in creation and deployment of dimensions, partitions, aggregation and cubes on SSAS.
• Created reports that have been defined by business architect and generated canned reports in a Crystal format of Crystal Reports.
• Hands on experience and outstanding knowledge in building and deploying the reports by using SQL Server Reporting Services - SSRS.
• Worked on predefined, developed stored procedures for automation and scheduling in crystal reports.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in Importing/Exporting Data from various heterogeneous data sources to SQL server using transformation of OLTP data to the Data Warehouse using SSIS.
• Expertise in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER.
• Having a good Experience in Designing and Developing the SQL Server Integration Services-SSIS Packages with different Control Flow Tasks and Data Flow Transformations, logging the Packages.
• Experience inenhancing and deploying the SSIS Packagesfromdevelopment server to production server.
• Good Hand on Resolving complex issues and Error Handling inSSIS.
• Very good knowledge of MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Implemented complex business logic with User-Defined-Functions, Indexed Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Expert in T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.
• Experience in providingLogging, Error handling by using Event Handler, and Logging for SSIS Packages.
• Working with SQL Server Job scheduling to execute Integration Services packages and to send reports to the client.
• Experience in Performance tuning and SQL Profiler of SQL Server.
• Hands on experience in execution of Parent and Child package execution.
• Implementation of scheduling for SSIS package executions and SSRS subscription
• Experts in generating drill through reports, drill down reports, parameterized reports, linked reports, Crystal reports, sub reports, table, matrix, charts in SSRS 2005/2008.
• Ability to work in-groups as well as independently with minimal supervision.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Technologies: Microsoft Business Intelligence Tools (MSBI)

Operating Systems: Windows 8, 7, Windows Server 2003.

Databases: SQL Server 2008/2008 R2, 2012

ETL Tools: SQL Server 2008/2012/2014 Integration Services

Reporting Tools: SQL Server 2008/2012/2014 Reporting Service

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Roles & Responsibilities:

• Creating Data bases, tables, views, indexes, Writing Stored Procedures.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations usingSSISpackages.
• Creating SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins, Temp tables for applications.
• Used various Data Flow Transformations like Lookup, Lookup Plus, Union All, Multicast, Cache Transform, and Conditional Split while developing the packages.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Build efficientSSISpackages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes using the TF Dimension Merge Slowly Changing Dimension (Task Factory Tool).
• Identified the potential Issues that occur during the package execution by redirecting the rows from source component to Error Output by TF Error Output Description (Task Factory Tool).
• Handled the database components (Code migration, Change control) for application releases.
• Monitoring Jobs and Investigate Failures.
• Create and update SSIS Packages to pull data from source to destination database.
• Migrated DTS packages from SQL Server 2012 to SQL Server 2014 asSSISPackages.
• Worked On Bug Fixing.
• Involved in Deployment and Administration on SSIS packages with Business Intelligence Development Studio.
• Generating drill through reports, drill down reports, parameterized reports, linked reports, Crystal reports, sub reports, table, matrix, charts in SSRS 2012.
• Scheduling the jobs to send the reports.

Confidential, Boston, MA

Sr. ETL/MSBI Developer

Roles & Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. Configured performance tuning settings using indexes, SQL profiler
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS andSSISservices.
• Created packages inSSISwith error handling.
• Worked with different methods of logging inSSIS.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Filtered data from Transient Stage to EDW by using complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
• Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.
• Maintaining jobs for data messaging from development server to test server for generating daily reports.
• Used some data conversion tasks inSSISto load the data from flat file to SQL Server database.
• MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services cubes& Reporting Services.
• Configured Report Server and SharePoint, and Deployed SSRS Reports, Report Models, Shared Data Sources to the Document Library of SharePoint.
• Created reports that have been defined by business architect and generated canned reports in a Crystal format of Crystal Reports.
• Created share point pages, master pages, navigation and security, charts, score cards, KPI, SSRS reports and lists and also worked on Excel 2010, Power Pivot for providing ad-hoc reporting for the clients.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Developed, monitored and deployedSSISpackages.
• Created ETLSSISpackages both design and code to process data to target databases.
• Created document for Self-Service Deployment and Execution process forSSISpackages.
• Constructed OLTP and OLAP Databases.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.