PROFESSIONAL SUMMARY:

• Over 7years of IT Professional experience in Development, Client Analysis, Database Design, and Presentation using SQL Server 2012/2008/2005/2000.
• Involved in relational data modeling normalization, Relations and multi-dimensional modeling using De-normalization, Fact tables, Dimension tables, Star schema for OLTP/OLAP systems.
• Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and effective experienced in implementation of strong referential integrity and auditing by the use of triggers and SQL Scripts.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled DTS and SSIS Packages.
• Involved in heavy data migration/ETL activities using BCP, Data Transformation Services DTS and SQL Server Integration Services SSIS 2012/2008r2/2008/2005 .
• Experience in SQL Server DTS and SSIS Integration Services package design, development, and deployment using SQL 2008 advanced features in Control flow, data flow, Error Handling and event handling.
• Experience in SSIS package scripting, scheduling, monitoring, deployment and production support.
• Real time Experience in Modify SSIS Package Create SSIS Package by using different sources like XML, SSAS cube, Web-service.
• In-depth knowledge of Transact-SQL and PL/SQL DDL and DML .
• Strong knowledge in Performance Point Server 2005/2007/2010 to designing dashboards and scorecards in highly complex scenarios with multiple KPIs, OLAP Charts and SSRS Reports.
• Extensive experience in SSRS Reporting services and proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Form, OLAP and Sub reports, and formatting them.
• Migration of SSRS reports from SQL 2008R2 to SQL 2012.
• Developing reports on SSAS SSRS on SQL Server 2000/2005 . Good Experience and understanding of SSAS, OLAP cube and Architecture.
• Worked on SQL BI solution integration with Microsoft SharePoint Server MOSS . Expertise in Ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Expert in developing and modifying Multi-dimensional cubes using SQL Server Analysis Services SSAS 2012/2008/2008R2 .
• Hands on experience in implementing Key Performance Indicator KPI Objects and partitions in SSAS 2012/2008.
• Experience in designing Database Models using MS Visio and ER-win.
• Knowledgeable in planning and implementing MS SQL Server Security and database Permissions.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

Skillset:

PROFESSIONAL EXPERIENCE:

Confidential

MS SQL Server/SSAS/SSIS/SSRS Developer

The aim of the project was to design and develop Enterprise Data warehouse and migrate the data from different sources into the databases using SSIS and generating customer profile reports and customer transaction reports using SSRS and SSAS.

Responsibilities:

• Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through report, Sub report, Parameterized report using SSRS 2012. Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created AD HOC reports with the report builder for the end users. Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services SSRS in Business intelligence development studio BIDS . Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Designed and developed SSIS ETL packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Data Staging to SQL server.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Developed and implemented partitioning and security in cubes based on user roles.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression MDX to access them.
• Designed and implemented Data Marts, facts, dimensions and OLAP cubes having star schemas using dimensional modeling principles in SSAS.
• Implemented Member properties, virtual Dimensions, Dimension custom rollups, write back, action and drill through.
• Designed MDX expressions/queries for accessing cubes involved in query structuring and performance optimization..

Environment:

Visual Studio 2012, Microsoft SQL Server 2008/2012, SSIS 2012, SSRS 2012, SSAS 2012, JIRA, Team foundation server, SQL Developer, MS SQL Profiler,SQL Server Database Engine Tuning Wizard, Windows Server 2008R2 , MS Office 2010, MS Access, MS Visio.

Confidential

BI Developer/Data Modeler

The main objective of the project was to collect data from various database sources to perform analysis and then integrate the various source databases into a centralized database.

Responsibilities:

• Gathering Requirements from Client and Understand current Database and system environment and then integrate it with business logic and made documentation on it.
• Based on my documentation I started work on generate different data model for my Data Warehouse and worked on Data mapping/Data Profiling create hierarchy as per business requirements.
• Start working on specification and transformation meanwhile start working to create new structure of DW and other objects like ETL Store Procedure ,
• Required Sys tables, lookup tables and also link server to fetch data from different servers.
• Hand on experience to create complex store procedure and ETL SSIS Packages to load records into DW tables, also need to maintain referential integrity between DW tables.
• I generated SSIS Package for ETL Process and develop source to Client data mappings using SSIS various tasks such as Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated sub-query, complex Stored Procedures and ad-hoc TSQL statement.
• Created Views and Synonym to reduce complexity of end user.
• Involved in performance monitoring and tuning of TSQL queries using SQL Profiler and database engine tuning advisor.
• Created Cluster and Non Cluster Index to optimize performance of TSQL queries.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008R2
• Generated Sub-Reports, Drill down reports, Drill through reports, Tabular Report and Parameterized reports using SSRS.

Environment:

MS SQL Server 2008R2, T-SQL, SSIS 2008, SSRS 2008, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005, Erwin v7.1,Windows XP, MS Office 2010, MS Access, IBM Rational Clear Quest.

Confidential

MS SQL Server/SSIS/SSRS Developer

BNY Mellon is a leading asset management and securities services company, uniquely focused to help clients manage and move their financial assets and succeed in the rapidly changing global marketplace. The project was migration of data from SQL server 2005/Oracle database to SQL server 2008 database, Creation of SSIS packages to integrate the data contained in various heterogeneous file systems and SQL Server database and creation of SSAS Cubes and creating reports using SSRS 2008.

Responsibilities:

• Responsible for migrating data from staging area to enterprise-wide data warehouse to store reliable data for decision support systems using DataStage.
• Transform data in ODS databases and load in the Enterprise data warehouse using SQL Server Integration Services.
• Used several stages like Transformer, Sequential flat file, Aggregator, Remove Duplicates, Merge, sort, and Lookup during the development process of the DataStage jobs.
• Working to design Dimension model for Business Process during project.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Gathering and analyzing the requirements from both external and internal users.
• Created reports using SQL Server Reporting Services based on the requirements.
• Responsible for transferring the data using SSIS packages.
• Involved in creating web portal for External clients using Microsoft SharePoint 2010.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• SSIS Package Deployment to Production Server as well as Job Scheduling for Package In Daily bases.
• Generate Cubes using SQL Analysis Services SSAS and Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Create Complex SSIS Package from POS/XML Source.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
• Documented the project work in Interface and for all process

Environment:

Microsoft SQL Server 2008, SQL Server Integration Services tools SSMS, BIDS and SQL Server Manager , SSRS, SSAS, Business Objects, Windows Server, MS Visio, Oracle 9i, MS Excel

Confidential

SQL Server Developer

Abbott Laboratories are a global, broad-based health care company devoted to discovering new medicines, new technologies and new ways to manage health. The project was migration of data from MS SQL server 2005 database to MS SQL server 2008 database, Creation of SSIS packages to integrate the data contained in various heterogeneous file systems and SQL Server database and creation of SSAS Cubes and creating reports using SSRS 2008.

Responsibilities:

• Effectively worked on Facts, Dimensions, and Cubes and wrote MDX queries using MS Analysis Services SSAS .
• Planned, Defined and Designed data based on business requirement and provided documentation.
• Developed SQL Server Integration Services SSIS packages to automate the nightly extract transform and load jobs.
• Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
• Used the SSIS script task, look up, cached look up, Fuzzy group transformations and data flow tasks.
• Developed packages to handle slowly changing dimensions, data cleansing, loading multiple files and executing tasks multiple times using For Each Loop
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star schema using dimensional Modeling principles in SSAS.
• Identified and defined Key Performance indicators KPIs for vendor reporting.
• Designed relationships between the dimensions and measures. Resolved complex many to many relationships and referenced relationships between the dimensions and the measures.
• Developed custom selection of reports ordering using SQL Server Reporting Services SSRS
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Set up Partitioned Tables and Indexes for Parallel Processing of queries using SQL Server 2008 Partition functions and schemes.
• Involved in Unit testing integrated testing and System testing.

Environment:

Microsoft SQL Server 2005/2008, T-SQL, SQL SSIS, SSRS, Windows server 2003, Visual Source Safe, Visual Studio 2008, Erwin v7.2.

Confidential

MS SQL Server/SSIS/SSRS Developer

Ambac Financial Group, Inc. is a holding company whose affiliates provide financial guarantees and financial services to clients in both the public and private sectors around the world. Ambac's principal operating subsidiary, Ambac Assurance Corporation, is a guarantor of public finance and structured finance obligations. The project was to clean, transform, migrate and streamline data from different sources to a central destination.

Responsibilities:

• Worked with non-technical colleagues and provide them SQL 2005 queries and store procedures to make their task easy and less time consuming.
• Created complex SQL join queries, views, and store procedures.
• Write Stored Procedures, ad hoc queries, join operations, dynamic SQL to extract the data in smoother and quicker manner out of Database.
• Used SSIS to process the text file data into Database and clean up the file system folders for next day's processing.
• Created SSIS Packages that Transfers Databases from One SQL Server instance to Another Instance
• Worked on data cleansing techniques using look ups, conditional split, and fuzzy lookup.
• Provided efficient error handling to SSIS packages.
• Prepared the reports using SSRS 2005 from scratch.
• Created parameterized, drill down reports and Changed old reports as per requirements using SSRS 2005.
• Create report model to give flexibility to users to create their own reports in SSRS.

Environment:

MS SQL Server 2005, SSIS 2005, SSRS 2005, MS Office 2003/2007, MS Access, MS Excel, MS Windows XP.