Professional Summary:

• Around 6 years of extensive experience using MS SQL Server 2005/2008 R2/2012 in Programming, Development and Implementation of Database and Data warehouse systems.
• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, Change Data Capture CDC , OLAP, OLTP, BI suite, Reporting and Analytics.
• Experience in Data warehousing, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Data Vault Modeling, FACT and Dimensions Tables.
• Experience in logical and physical data modeling of the database using ERWIN.
• Experience in Database design, Performance Analysis and Production Support for large and Complex Databases.
• Experience in requirements gathering, analysis design of ETL processes using SQL Server Integration Services SSIS and SQL Server Reporting Services SSRS .
• Experience in SSIS SQL Server Integration Service package design, constructing, and deployment.
• Transformed and loaded the data from one server to other servers using tools like SSIS 2005 , 2008 ,SQL Server Data Tools 2010 .
• Experienced in extraction migration of data from heterogeneous data sources like Excel, Oracle, MS Access, flat file to MS SQL Server by using import/export wizard as well as third party connectors and creating ETL packages in SSIS.
• Experience in extraction consumption of XML objects into a Data Warehouse from external apps through Talend.
• Extensive experience in creating ETL packages using SQL Server Integration Services SSIS and scheduling packages, validating data using SSIS.
• Experience in providing Logging, Error handling by using Event Handler for SSIS Packages.
• Good experience in Development, Deployment and Troubleshoot SQL Server Reporting services using SSRS 2005/2008/2010 across various environments.
• Experience in creating data driven subscriptions for reports, linked reports, and ad-hoc reports by using Report Builder in SSRS.
• Expertise in generating drill down reports, parameterized reports, linked reports, sub reports in SSRS 2005/2008/2010.
• Experience in creating dashboards, scorecards and building reports using Performance point server 2007.
• Experience in creating business specific tabular reports and crosstab reports using Crystal Reports 11.
• Experience in creating effective dashboards with critical business values to assist in decision-making ability.
• Experience in supporting huge databases, troubleshooting problems, and documenting root cause analysis.
• Extensive experience in database migration and upgrade from SQL Server 2005 and 2008.
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Experience in MS SQL Server configuration, performance tuning, query optimization, back-up/recovery.
• Experience in creating effective data mining structures to predict key business performance indicators.
• Experience in creating MDX query in SSAS cube for various calculated members, KPI and various actions such as drill through, reporting etc.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

Technical Profile

Professional Experience:

Confidential, Sr. SQL Server BI SSIS/SSAS/SSRS Developer

Description:

CONFIDENTIAL provides retail and commercial banking, securities brokerage, mortgage and insurance products and services. The project also deals with the Mortgage where it aims at achieving financial goal with the usage of SQL Server Integration Services and SQL Server Reporting Services that provides for improved quality and increased productivity.

Responsibilities:

• Involved in the designing, development, modification and enhancing the database structures and database objects
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Created multiple SSIS packages / procedures as a source to be consumed by SSAS cubes as well as by business for analytics and reports in downstream purposes.
• Developed multiple tabular models in SQL Server Data Tools SSDT for analytic reporting as well as aggregated data reports.
• Extensive use of DAX expressions in tabular models as per business requirements.
• Created complex SSAS cubes with multiple data partitions to selectively refresh smaller subsets of data to save on processing time in terms of heavy transactional data.
• Extensive use of perspectives and hierarchies in models to efficiently serve reporting needs.
• Created complex Multi dimensional SSAS cubes to reduce overhead of complex queries on operational databases.
• Use of Multidimensional expressions MDX to query multi - dimensional objects and return with result set for reports.

• Used various OLAP operations like slice / dice, drill down and roll up as per business requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Use of linked servers and Open query to enable the SQL Server Database engine to execute commands with the OLEDB data sources outside of the instance of the SQL Server.
• Extensive use of SQL Server Agent and Control M to set up various jobs.
• Use of SSRS in SharePoint integrated mode to better serve business users.
• Extensive use of Pivot Tables and Power Pivot Excel for reports.
• Scheduled the Reports to run on daily and weekly basis in Report Manager.
• 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.
• Used SSRS Report Manager to assign roles, permissions and to create report schedules.

Environment: SQL Server 2012, SQL Assistant, SQL Server Data Tools SSAS, SSRS , Control - M, SharePoint 2010, XML, T SQL, Git, TFS, MS Excel Power Pivot, OLAP.

CONFIDENTIAL

Sr. SQL Server BI SSRS/SSAS Developer

Description:

CONFIDENTIAL has built a reputation for exceptional clinical quality, preventive care, disease management and member satisfaction and has consistently rated among the top plans in the country. Harvard Pilgrim is a full-service health benefits company serving members throughout Massachusetts, New Hampshire, and Maine and beyond. Our mission is to improve the quality and value of health care for the people and communities we serve.

Responsibilities:

• Involved in the designing, development, modification and enhancing the database structures and database objects
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Created multiple Oracle views / procedures as a source to be consumed by SSAS cubes as well as by business and reports in downstream purposes.
• Developed multiple tabular models in SQL Server Data Tools SSDT for analytic reporting as well as aggregated data reports.
• Extensive use of DAX expressions in tabular models as per business requirements.
• Created complex SSAS cubes with multiple data partitions to selectively refresh smaller subsets of data to save on processing time in terms of heavy transactional data.
• Extensive use of perspectives and hierarchies in models to efficiently serve reporting needs.
• Created complex Multi dimensional SSAS cubes to reduce overhead of complex queries on operational databases.
• Use of Multidimensional expressions MDX to query multi - dimensional objects and return with result set for reports.

• Used various OLAP operations like slice / dice, drill down and roll up as per business requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Use of linked servers and Open query to enable the SQL Server Database engine to execute commands with the OLEDB data sources outside of the instance of the SQL Server.
• Extensive use of SQL Server Agent and Control M to set up various jobs.
• Use of SSRS in SharePoint integrated mode to better serve business users.
• Extensive use of Pivot Tables and Power Pivot Excel for reports.
• Scheduled the Reports to run on daily and weekly basis in Report Manager.
• 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.
• Used SSRS Report Manager to assign roles, permissions and to create report schedules.

Environment: SQL Server 2012, Toad, SQL Navigator, SQL Server Data Tools SSAS, SSRS , Control - M, SharePoint 2010, XML, T SQL, Oracle 11g, Git, Source Tree, MS Excel Power Pivot, OLAP.

CONFIDENTIAL, Sr. SQL Server BI SSRS/SSIS Developer

Description:

CONFIDENTIAL is a nation-wide provider of low-cost electricity and natural gas offering significant savings to homes and businesses from CONFIDENTIAL . Job included implementation and migration from existing data warehouse to a new, modeled according to data vault methodology for a new Customer Information System vendor. Implementation adequately supported BI needs of the organization with thorough knowledge of data warehousing concepts, BI tools and ETL systems using CDC.

Responsibilities:

• Actively involved in design of a new normalized data store NDS based on Data Vault Methodology as well as a De normalized Data Store DDS per Dimensional Model.
• NDS was designed to be used as a system of truth for long term historical storage of data coming in from multiple operational systems while DDS was used by Business users and for BI reporting purposes.
• Convert business requirements into actionable technical requirements for the project.
• Created SSIS packages to SQL Server instances in SSIS 2010 using CDC feature.
• Created several SSIS packages for performing ETL operations to transform data from NDS to DDS systems.
• Created multiple views as a source to be consumed by DDS as well as by business and reporting requirements in downstream purposes.
• Developed multiple stored procedures having merge statements used in Upsert operations.
• Designed and implemented backend for downstream accounting and energy supply and risk apps per new data warehouse entity relations.
• Designed and supported ETL for data pull into reporting and downstream apps as one by merging data sets from existing and new data warehouses.
• Designed the ETL for merge operation as migration was to be done in phases with the view of shutting down old processes as transition happens to new data warehouse, old becoming void eventually.
• Challenge being conforming two sets of data with different hierarchy, to be presented to the users as one.

• Designed extraction consumption of XML objects into a Data Warehouse from external apps through Talend.
• Implemented functionality to sync via Talend to common database systems used internally by all apps.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Generated Reports using datasets or views from NDS directly or DDS for the reports using SSRS 2010.
• Performing the tasks of data conversions, adding derived columns in SSIS.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager.
• 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.
• Used SSRS Report Manager to assign roles, permissions and to create report schedules.

Environment: SQL Server 2008 R2/2012, Business Intelligence Studio SSAS, SSIS, SSRS , Performance Point Server, SharePoint 2007, XML, T SQL, Erwin, Oracle 10g, Talend, MS Excel, ASP.NET, ETL, OLAP.

CONFIDENTIAL, Sr. SQL Server BI SSRS/SSIS Developer

Description:

CONFIDENTIAL is a mid-sized and commercial insurance company that provides dependable, competitive priced insurance coverage to farm and ranch families since 1984. It's mainly located in six areas WA,, OR, ID, WY, CO CA with CONFIDENTIAL covers our customers through the following insurance entities: CONFIDENTIAL CONFIDENTIAL and Casualty Company and Mayflower Corporation.

Responsibilities:

• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Created cubes and dimensions and measures and calculated measures according to the business requirements.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Processing the cubes and dimensions on a daily basis using the SSIS tasks.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2008.
• Created several SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems.

• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Performing the tasks of data conversions, adding derived columns, sending results in mails is done by making use of various tasks in SSIS.
• Worked with vb.net developers to create reports which can be accessed by portals.
• Deployed SSIS packages and Reports to Production Servers.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Deployed Reports using SQL Server Reporting Services SSRS and ProClarity.
• Created Data warehouse Cubes in SQL Server Analysis Service SSAS .
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 SSAS .
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Configured SSRS with MOSS 2007 for directly deploying the report in sharepoint 2007.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• 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.
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Created SSIS Packages from various data sources.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Extracting the data from the different sources CSV files, oracle, and MS SQL 2000 and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Developed T-SQL queries and stored procedures with multiple parameters to created data sets for reports.
• Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS SharePoint , Business Scorecard Manager, Dashboards, Performance Point Server
• Developed reports in SSRS 2008 and deployed reports into SharePoint Server 2007 MOSS .
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• 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.
• Used SSRS Report Manager to assign roles, permissions and to create report schedules.

Environment: SQL Server 2008 R2, Business Intelligence Studio SSAS, SSIS, SSRS , Performance Point Server, SharePoint 2007, Proclarity, T SQL, Erwin, Oracle 10g, MS Excel, ASP.NET, ETL, OLAP,MDX.

CONFIDENTIAL

SQL Server BI SSRS/SSIS/SSAS Developer

Description:

CONFIDENTIAL a global provider of real estate and relocation services, has a diversified business model that includes real estate franchising, brokerage, relocation and title services. Realogy's world-renowned brands and business units include CONFIDENTIAL

Responsibilities:

• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Developed and extended SSAS Cubes, dimensions and data source view SSAS- Data Mining models and deploying and processing SSAS objects.
• Involved in complete Software Development Life Cycle SDLC process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2005 2008 SSAS
• Involved in daily batch loads Full Incremental into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services SSIS .
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments Development and Production .
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Experience in developing reports using SSRS.
• Advanced extensible reporting skills using SQL Server 2005/2008 Reporting Services SSRS .
• Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and called various stored procedures from SSIS to make the flow of SSIS effective
• Developed a High-level dashboard using SSRS 2008/2005.
• Experienced in Designing stylish report layout.
• Designed and created Report templates, bar graphs and pie charts based on the financial data using SSRS 2005.
• Used Performance Point Server to identify KPI 'S, build score boards, reports and dash boards.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designing Parameterized Reports and Report Models for generating Ad-hoc reports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Involved in designing Web based ASP.NET applications.
• Coordinated with front-end for implementing logic in Stored Procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2000 to SQL Server 2005/2008.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Created SQL Server Reports using SSRS 2005.Identified the data source and defined them to build the data source views.
• Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.

Environment: SQL Server 2008/2005, Enterprise Edition, SQL Server Business Intelligence Development Studio SSAS, SSIS, SSRS , .Net framework, MDX,OLAP, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

CONFIDENTIAL

SQL Server Developer

Description:

CONFIDENTIAL is one of the leading companies in hospitality industry for individual and various companies. This project involved maintaining data warehouse with respect to different types of properties across the globe - Grand, Select, Regency and Resorts, running campaign management and thank you/Reminder emails using data warehouse. Data from heterogeneous operational systems is extracted, transformed and loaded into a data warehouse built on SQL Server Database. Integration and Analysis services are carried out using MSBI.

Responsibilities:

• Standardized way of writing stored procedure following a specific pattern and naming conventions.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Involved in Data migration Import Export using BCP from text to SQL Server2005.
• Created SSIS packages to migrate data from Oracle DB to SQL Server 2005.
• Involved in Creating Stored Procedures for Reports generation.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Performed Documentation for all kinds of reports and DTS and SSIS packages.
• Designed and implemented stored procedures and triggers for automating tasks.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Involved in Report Authoring, Report Delivery using both Pull and Push strategy and Report Management for various types of reports.

• Participated in creating reports that deliver data based on stored procedures.
• Experience in creating snapshots of static reports and configure subscription.
• Developed Multi dimensional Objects Cubes, Dimensions using MS Analysis Services SSAS .
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
• Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse ETL .
• Encapsulated frequently used SQL Statements into stored procedures thereby reducing the execution time.
• Involved in developing triggers to audit schema changes at the database level.
• Created Transactional Replication, Pull Subscription and defined publications to transfer data from branch to head office and vice versa.
• Created sub-reports to present more detailed information about the summary.
• The task involved writing a lot of SQL Code, including use of complicated joins and cursor loops.
• Lead the team of developers to write efficient code.
• Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment.

• Involved in design and development of logical and physical database models.
• Developed various Stored Procedures, constraints and views in SQL Server 2008.
• Developed SSIS packages to move data between staging, development and QA Environment.
• Involved in ad-hoc report generation using SSRS
• Involved in analyzing, identifying and implementing user roles and their relative database access privileges.
• Enhanced performance of databases using optimization techniques-normalization, indexing, Transaction Isolation levels and processes.
• Maintained and resolved bugs in the T-SQL queries.

Environment: SQL Server 2008/2005, MS Excel 2003, MS SQL Query Analyzer, SQL Profiler, ETL, MS SQL Server Reporting Services, MS SQL Server Analysis Services.

CONFIDENTIAL

MS SQL Server Developer

Description:

CONFIDENTIAL OBC has more than 100 branch offices in India and abroad. The project involved analysis, technical design and production implementation tasks. These tasks include Software Installation, Database Performance Tuning Maintenance, Database Backup and Recovery, Export/Import of Data, Replication.

Responsibilities:

• Designed dynamic SSIS packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Generated database monitoring and data validation reports in SQL Server Reporting Service SSRS .
• Deployed SSIS packages and Reports to Production Servers.
• Upgraded databases from SQL Server 2000 to SQL Server 2005.
• Designed and developed .Net web applications for firm's Solutions.
• Migrated data using ETL Tool in SSIS.
• Maintained system monitoring jobs and provide high availability support.
• Created partition table for very large database for good performance.
• Worked on migration of packages from DTS to SQL Server Reporting Service SSIS .
• Participated databases architecture and data modeling design.
• Performed DBA functions, installing, configuring and supporting database systems.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Fully supported change management procedures.
• Reviewed and developed data models and database designs with development teams.
• Wrote store procedures for some job automations.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Wrote SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS.
• Designed and developed OLAP cubes using MS SQL Server Analysis Services.
• Designed and developed MS SQL Server Reporting Services SSRS under SQL Server 2000 and SQL Server 2005.

Environment: SQL Server 2000/2005, MS Excel 2003, MS SQL Query Analyzer, SQL Profiler, ETL, MS SQL Server Reporting Services, MS SQL Server Analysis Services.