SUMMARY:

• 10 years of experience in MS SQL Server suite of products like SSRS, SSAS, Tabular Cube, Tableau and SSIS of MS SQL Server 2005/2008/2012 create a new tabular model project by importing the metadata from an existing tabular model
• Impersonation (SSAS Tabular) how logon credentials are used by Analysis Services when connecting to a data source to import and process (refresh) data.
• Ability to gather requirements and take control of what needs to be done within the Development without a team lead telling them what to do
• Manually process data for a single table or all tables in a model and process data for one or more
• Excellent in High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Expert in developing, deploying packages and extracting data using SSIS from OLTP to OLAP.
• Expert in Data Analysis Services OLAP Cubes, MOLAP and Mining.
• Extensively worked in Migration for MS SQL 7 to 2000 and MS SQL 2000 to MS SQL 2005.
• Expert in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL Server 2000 and MS SQL Server 2005 respectively.
• Good software engineering hygiene: source control, test - driven development, etc
• Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Highly proficient in the use of SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity, SQL joins and query writing.
• Excellent experience in Designing, Maintaining and tuning various RDBMS like T-SQL & MS SQL Server 2000/2005 and MS Access databases.
• Expert with the Enterprise Manager and hands on experience with Business Intelligence tools.
• Experienced in generating on-demand and scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/2008 (SSRS).
• Expert in working with Rational Clear Case and Clear Quest for revision control of source code and software development assets.
• Highly proficient in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP),Data Transformation Services(DTS) and SSIS with MS SQL 2005.
• Expert in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.
• Extensive knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Visual Analysis, Visual Perception
• Tableaus Product Family, Connecting to data sources and View Terminology

SKILL SET:

MS SQL Server 7/2000/ 2005/2008/2012 , SQL Server Reporting Service 2005, SQL Server Analysis Services/ Tabular Cube, Tableau 2012,MS SQL Server Integration Service 2012, MS Access, .NET, C++, Visual Basic 6.0, ASP, C#, Developer 2000, ERWIN 4.0/4.1/4.2, Windows 9x/NT/2000/XP/Server 2003, T-SQL,PL-SQL, HTML, VBScript, UNIX, Crystal Reports 8.5/9/10,HTML,XML,VBScript, ODBC, Confidential Dynamics AX

PROFESSIONAL EXPERIENCE:

Confidential

SQL BI Developer

Responsibilities:

• Familiarity with Business intelligence technologies (Power BI, SQL Server Analysis services, SQL Server Reporting Services).
• Used linked server to access the objects from the data source for mapping of source tables to destination tables
• Creating partitioned tables, complex stored procedures, cursors, Function, triggers, SSIS packages, index, ad hoc queries etc.
• Teradata Experience
• Knowledge in Widows Azure, COSMOS and HDInsight.
• Developing SSIS packages to fetch data from various sources, staging it, performing calculations, Configuration and deployment.
• Ability to pull information from the Data Warehouse
• Populate Staging tables by using link server from different server data sources
• Create Targate tables under production DB, and populat by using SP Proc .
• Create SP to migrate data from Staging to targate tables in production
• Create reports to retrieve data using database code objects, such as Stored Procedures, views
• Cerate Views for Power Bi Reprt and retrive those views to constrct Dashboard report in Power Bi Desk Top
• Power Bi installation in VM
• Create Power Bi report, Dasboard and Data sate in production server
• Create content pack and publishe report on power Bi Server.

Key Technologies/Skills: MS SQL Server 2014, MS SQL Server Integration Services 2014, MS SQL Server Reporting, SQL Server Analysis Services SSIS, SSAS, SSRS, SQL Server, SQL Server Data Tools, Azure, Power BI, MS SQL Server Tabular cubes

Confidential, Washington, DC

SQL BI Developer

Responsibilities:

• Created SQL server Reports using SSRS 2012 for the manager and the brokers involved. create a new tabular model project by importing the metadata from an existing tabular model
• Impersonation (SSAS Tabular) how logon credentials are used by Analysis Services when connecting to a data source to import and process (refresh) data.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
• Excellent in High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Highly proficient in the use of SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity, SQL joins and query writing modify a database data source connection
• Tables and Columns (SSAS Tabular) Add Columns to a Table, Delete a Column, Change table, column, or row filter mappings, Add a Table, Delete a Table, Hide or Freeze Columns
• Create a Calculated Column DAX Formulas in Calculated Columns, Measures, and Row Filters
• Create and Manage Measures
• Deploy a Tabular Model Solution in Analysis Services instance
• Analyze a Tabular Model in Excel
• Develop reporting/dashboards with Power Pivot, Power View, Performance Point
• Confidential BI integration with SharePoint
• Expert in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL Server 2012
• SQL Loader, PL/SQL, Oracle Spatial, Oracle 11g/12c, Python, Confidential Team Foundation Server

Key Technologies/Skills: MS SQL Server 2012, MS SQL Server Integration Services 2012, MS SQL Server Reporting, SQL Server Analysis Services Tabular Cube, Tableau 2012,MS SQL Server Integration Service /2012, T-SQL, SharePoint, TFS,Git 2010/2012, Confidential Dynamics AX.

Confidential, Boston, MA

MS SQL Server Developer/ SSRS, SSIS

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Incorporated the DTS Packages into MS SQL Server 2005 Integration Services by using Package Migration Wizard and Execute DTS 2000 Package task.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.
• Development of varied SSIS packages, SSRS (reporting services), and stored procedures utilizing BIDS and SQL Server 2008 as well as VBA within Excel and Access to manipulate data for reporting purposes and distribution of reports.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables wit
• Developed, deployed, and monitored SSIS Packages.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.

Key Technologies/Skills: MS SQL Server 2005/2008, MS SQL Server Integration Services 2005/2008, MS SQL Server Reporting Services 2005/2008, T-SQL, SharePoint, TFS 2010/2012, Confidential Dynamics AX.

Confidential, MA

MS SQL Server Developer/ SSRS, SSIS

Responsibilities:

• Created reports to retrieve data using database code objects, such as Stored Procedures, views, functions and multiple T-SQL queries.
• Extensively involved in generating reports like matrix, parameterized and drill through reports using SSRS and developed stored procedures using functions to generate various kinds of reports using SSRS.
• Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the
• Prepared end user documentation, Technical documentation, dimension map, Contact list and published into the Production. Involved in training to the End User to familiarize them about how to use the Cube.
• Used MDX for querying and manipulating the multidimensional data stored in OLAP cubes.
• Developed various reports for managing various securities and assets to meet specified investment goals.

Key Technologies/Skills: MS SQL Server 2005/2008, MS SQL Server Integration Services 2005/2008, MS SQL Server Reporting Services 2005/2008, T-SQL, SharePoint, TFS 2010/2012

Confidential, Boston, MA

MS SQL Server Developer/ SSRS, SSIS

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers and used windows security for security purposes.
• Developed various reports for managing various securities and assets to meet specified investment goals.
• Worked Extensively with Business System Analysts who has drafted the requirements for me and helped me in testing the report results.
• Extensively involved in high level design of OLTP and OLAP based Databases.
• Used Extensively MS SQL Server Reporting Services 2008 to develop various kinds of reports and test them with users and finally deploy them.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users.

Key Technologies/Skills: MS SQL Server 2005/2008, MS SQL Server Integration Services 2005/2008, MS SQL Server Reporting Services 2005/2008, T-SQL, SharePoint

Confidential, Smithfield, RI

MS SQL Server Developer/ SSRS, SSIS

Responsibilities:

• Used indexes to enhance the performance of individual queries and enhance the stored procedures.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Designed system test plans, assisting in execution, recording results and ensuring that the solution meets the functional requirements.
• 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.
• Created Calculated Measures and Dimension Members using MDX, Mathematical formulas and User Defined Functions.
• Responsible for Technical analysis and design for functional requirements and Performed updating to the technical documents.
• Created SQL server Reports using SSRS 2005 for the manager and the brokers involved.
• Gathered Requirements from the end user and checked the structure of the schema and data with the Data Modular.
• Formatted the report layout for the requirement of the end users and deploy the developed reports

Key Technologies/Skills MS SQL Server 2005/2008, MS SQL Server Integration Services 2005/2008, MS SQL Server Reporting Services 2005/2008, T-SQL,BIDS.

Confidential, Newark, New Jersey

MS SQL Server Developer/ SSRS, SSIS

Responsibilities:

• Development and tuning of various databases and processes on the SQL Server 2000, 2005 and 2008 platforms including Stored Procedure tuning, SSIS and SSRS tuning. Focuses on index tuning, query modifications, transactional replication, partitioning and hardware optimization.
• Development of SSIS packages including TSQL, Stored procedures, views and scripting as part of a migration effort from MS Access to SQL Server 2005.
• Extensively worked with Very Large Database in order to generate cubes and Reports.
• Involved in providing information and assistance to the database administrator on physical models, setup and maintenance of database.
• Database administration for databases up to 2 terabytes including T-SQL coding, stored procedures, backup/recovery, high availability.
• Front end interface developed utilizing MS Access for data overrides, data imports and FX rate change inputs as well as report generation.

Key Technologies/Skills: MS SQL Server 2005/2008, MS SQL Server Integration Services 2005/2008, MS SQL Server Reporting Services 2005/2008, T-SQL., Power Builder 11.1.

Confidential, Springfield, MA

MS SQL Server Developer/ SSRS, SSIS

Responsibilities:

• Responsible for Monitoring and Tuning Report performance by analyzing the execution plan of the report.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Performed extract, transform, and load data into the repository and Created Complex Stored procedure, Functions, Views, and Indexes for the Logic package.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.

Key Technologies/Skills: MS SQL Server 2005/2008, MS SQL Server Analysis Service 2005/2008, MS SQL Server Integration Services 2005/2008, MS SQL Server Reporting Services 2005/2008, T-SQL.

Confidential, Morristown, NJ

MS SQL Server Developer/ SSRS, SSIS, SSAS

Responsibilities:

• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Extensively used T-SQL statements and created multidimensional cubes for the analyzer and used pivot table to help the end-user get familiar with cube.
• Upgraded MS SQL Server 2000 databases to 2005, using Detach/Attach, Back up & Recovery and by Replication.
• Generated Dynamic reports from Cubes (SSAS) using SSRS-2005.
• Created the structure of the model and cube in SSAS and reviewed Cube with end user and changed the cube and documentation according to their requirements.
• Used linked server to access the objects from the Oracle data source for the mapping of source tables to destination tables.
• Extensively involved in high level design of OLTP and OLAP based Databases.
• Extensively involved in migration of data from MS SQL 2000 to MS SQL 2005.
• Monitored performance and optimized SQL queries for maximum efficiency using SQL Profiler.

Key Technologies/Skills: MS SQL Server 2005/2008, MS SQL Server Analysis Service 2005/2008, MS SQL Server Integration Services 2005/2008, MS SQL Server Reporting Services 2005/2008, T-SQL, MDX,ASP.Net

Confidential, Newark, New Jersey

MS SQL Server Developer/ SSRS, SSIS

Responsibilities:

• Performed task at development environment, analyzing, testing, and implementing systems. Designed User-Interface for the testing using DTS packages.
• Created Packages using ETL tool for the users to check the codes and responsible for extracting data from huge database to manipulate and analyze the data for the end users.
• Involved in thinking about investing and asset allocation, diversification, and correlation and generating various kinds of reports.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Migrated the entire schema as well as data into MS SQL Server 2005 and also validated the migration process to ensure that it has been successfully migrated.
• Used linked server to access the objects from the Oracle data source for the mapping of source tables to destination tables.
• Designed coding and testing of new and enhanced application components on the Data warehouse.
• Designed and analyzed the document business processes, systems processes and data flow and impacts.
• Designed and implemented user-interface screens using .Net technologies: ASP.Net, C# and VB.Net.

Key Technologies/Skills: MS SQL Server 2005, MS SQL Server Reporting service 2005, MS SQL Server Integration service 2005, T-SQL,DTS,C#,.Net, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005,MDX.

Confidential, Wilmington, Delaware

MS SQL Server Developer/ SSAS, SSIS, SSRS

Responsibilities:

• Created parameterized reports and ad hoc reports using Report builder for the brokers and clients.
• Involved in transferring old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2000 using DTS Packages.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata.
• Created Cube reports that can be browsed at Summary level and can be drilled down to the detail level.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.

Key Technologies/Skills: MS SQL Server 2005, MS SQL Server Reporting service 2005, MS SSIS, T-SQL, Windows 2003, ASP.NET,C#.NET.

Confidential, McLean, VA

MS SQL Server Developer/ SSAS, SSIS, SSRS

• Migrated various DTS packages to SSIS and involved in developing, deploying packages and extracting data using SSIS from OLTP to OLAP. Gathered Requirements from the end user and checked the structure of the schema and data with the Data Modular.
• Imported Metadata and created Presentation Layer, Business Layer and Data Source layer, Physical Layer.
• Created parameterized reports and ado reports using Report builder for the brokers and clients.
• Supported the front application developers for queries for development hierarchies, file upload and validations using ASP. Net.
• Defined aggregations required and granularity available and required in DW.
• Created various Table and Views to ensure the increase performance of application.
• Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions.
• Created the structure of the model and cube in MS Analysis Services.
• Reviewed Cube with End user and changed the cube and documentation according to their Requirements.

Key Technologies/Skills: MS SQL Server 2000/2005, MS SQL Server Analysis Services 2005, MS Access, MS SQL Server Reporting services 2005, MS SQL Server Integration Services 2005.