SUMMARY:

• Over 8 years of IT experience on T - SQL, SSIS, SSRS SSAS along with PPS (Performance point services), Share Point Development and Power-Bi across multiple industry sectors ranging from small, medium to large organizations.
• Strong Transact-SQL query writing skills (DDL, DML, and DCL).
• Extensive database programming Experience in writing T-SQL Stored procedures, User Defined Functions, Constraints using various DDL and DML commands.
• Experience in optimizing the database by creating various Clustered, Non-clustered Indexes.
• Good experience in creating objects such as Databases, Tables, Triggers and Cursors, Constraints, Indexes, Views, Indexed Views in Microsoft SQL Server 2005/2008/2008- R2,2012,2014.
• Good experience in SQL Server Business Intelligence Tools like SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).Strong in Data Extraction, Transforming and Loading (ETL)
• Expertise in generating parameterized reports, linked reports, sub reports, matrix and various chart reports in SSRS.
• Experience in providing Error Logging and Error handling for SSIS Packages.
• Experience in Developing OLAP Cubes using SSAS and develop reports by using MDX.
• Experience in Developing OLAP Cubes using SSAS tabular model reports by using DAX.
• Proficiency at task, Containers, Data Transformations likes Sources and Destinations, Derived Column, Conditional Split, Sort and Merge Join Transformations to load data into Data Warehouse.
• Using all kinds of SQL Server Constraints (Primary keys, foreign Keys, Defaults, and Check, Unique etc) and Generating Transaction SQL (T-SQL) Queries and Sub queries.
• Expertise in designing dashboard reports using Performance Point Service (PPS).
• Expertise in using SVN & Team Foundation Server (TFS)
• Very strong background in disciplined software development life cycle (SDLC) with exceptional Design, Development, Implementation.
• Excited to take on new challenges in a business Intelligence Project - ability to work individually or as a part of a team.

TECHNICAL SKILLS:

Programming Languages: SQL, T-SQL, Oracle

Database: SQL Server 2008,2008-R2,2012,2014 and 2016

ETL Tools: SQL Server Integration Services (SSIS)

Analytic tools: SQL Server Analysis Services (SSAS)

Reporting Tools: SQL Server Reporting Service (SSRS), Power-Bi

Development Tools: SQL Server Management Studio (SSMS), BIDS

Methodology: Kimball Methodology, Agile-Scrum

Other: Performance Point Services (PPS), SharePoint Development

PROFESSIONAL EXPERIENCE:

Confidential

Senior Software Engineer / MSBI Developer

Responsibilities:

• Created OLAP databases using Multidimensional model and calculated measures by writing MDX queries. Dimensional Data Modeling and Cube development in SQL Server 2014 Analysis Services.
• Designed different Types of reports like Drill Down, Drill Through, Sub reports, Parameterized Reports and Cascading reports.
• Designed dashboard reports using PPS (performance point services) and deployed into SharePoint server.
• Actively worked involved on performance tuning activates in OLAP database design and report design.

Confidential

Senior Software Engineer / MSBI Developer

Responsibilities:

• Developed SSIS Packages to migrate the data from Oracle to SQL Server.
• Involved in Report Requirement Gathering and Design of Reports through MDX and T-SQL.
• Involved in Report Developing on SharePoint server
• Involved in SSAS Cube enhancement writing MDX query’s for report build.
• Involved in the deployment activities both in UAT and Production.
• Involved in creation of Map reports in SSRS.

Confidential

SQL Server / BI Developer

Responsibilities:

• Developing and implementation of the ETL using SQL Server Integration Services (SSIS)
• Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load data from online transaction Processing (OLTP) databases to data warehouse databases and involved in Data cleansing in the data transfer
• Performed data conversion from flat file into a normalized database structure.
• Developed custom reports using SSRS SQL Server BI studio.
• Worked on SSRS for creating the reports and created different reports in SSRS like Matrix report and Cross tab reports and also build charts in SSRS reports like bar charts.
• Developed Complex Queries, Stored Procedures and Functions for Report generation using SQL Server Reporting Services (SSRS 2008/2008-R2) for organization requirements.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Involved in OLAP cube creation by using SSAS and writing MDX query's for report build.
• Expert in creating Parameterized Reports, Matrix Reports, and Custom generated reports, Charts, Sub Reports as per Business User requirements.
• Used different options in reports like drill down and drill through.
• Worked on date to day development work for building the reports in SSRS and business objects.
• Created Clustered and Non-Clustered Indexes for improved performance
• Created users list for the specific group and giving access to the users for the group.
• Deployed those reports to the report manager and done subscription in report manager for scheduling of the reports.