EXPERIENCE SUMMARY:

• 10 years of experience in IT industry.
• Experience in SQL Server 2005/2008/R2/2012/2014, SSAS (Multidimensional and Tabular), SSIS, SSRS, MDX, DAX, Performance Point Server(PPS), DataZen, Power BI, Excel and Tableau
• Good team player, strong interpersonal and communication skills combined with self - motivation, initiative and the ability to think outside the box.
• Expertise in generating SSRS reports using MDX Queries.
• Expertise skills in Calculating Measures and Calculating Members in SQL Server Analysis Services (SSAS) using multi-dimensional expression (MDX).
• Implementing Cube Security by Using Roles and Dimension security
• Expert in generating parameterized reports, linked reports, sub reports, matrix and charts in SSRS.
• Expert in DataZen and Mobile Reports (SSRS 2016)
• Expertise in developing ETL process and providing Error handling by using SSIS Packages.
• Excellent knowledge in Designing Database Objects like Tables, Constraints, Views, Indexes.
• Extensive database programming Experience in writing T-SQL Stored procedures, User Defined Functions.
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, and Check, Unique etc.) and Generating Complex Transaction SQL (T-SQL) Queries and Sub queries.
• Experience in performance tuning and optimization.
• Experience with Team foundation Server (TFS) as Source Control
• Develop and execute test plans of unit testing thorough integration testing.
• Health care domain knowledge and experience with health care transactions

STRENGTHS:

• Good communication skills,
• Very good team player.
• Problem-solving and trouble-shooting capabilities.

TECHNICAL SKILLS:

Operating systems: Windows 2008/2003

Programming Languages: SQL, T-SQL, MDX, DAX

RDBMS: Confidential SQL Server 2005/2008/R 2/2012/2014.

Reporting Tool: SQL Server Reporting Services (SSRS), Tableau, Power BI

ETL Tool: SQL Server Integration Services (SSIS)

OLAP Tool: SQL Server Analysis Services with MDX (SSAS), DAX(Tabular)

PROFESSIONAL EXPERIENCE:

Confidential

MSBI Developer

Environment: SQL Server 2014, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Hive query

Responsibilities:

• Designed and developed the SSAS multidimensional cubes.
• Designed and developed SSIS 2014 packages to process the cube partitions dynamically.
• Created Performance Point Services dashboards and deployed to SharePoint 2010 portal.
• Data pull from big data into SQL Server, aggregated data is dumped into hive tables and

Confidential

MSBI Developer

Environment: SQL Server 2014, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SSAS Tabular cubes and Power Pivot

Responsibilities:

• Designed and developed the SSAS multidimensional cubes and reporting actions using SQL Server 2014.
• Designed and developed SSIS 2014 packages to process the cube partitions dynamically.
• Designed and developed SSAS Tabular model using SQL Server 2016.
• Created Performance Point Services dashboards and deployed to SharePoint 2010 portal.
• Created self-service excel reports using excel 2013
• Created Tableau Dashoards.
• Designed and developed dashboards using the SSRS 2014 and mobile reporting.
• Migrated SQL BI Components including SSAS, SSIS packages and SSRS from SQL 2012 to SQL 2014

Confidential

MSBI Developer

Environment: SQL Server Management Studio (SSMS 2012), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Power Pivot, Performance Point Services 2010

Responsibilities:

• Designed the Relational Database and developed the Database objects.
• Designed and developed the ETL process using SSIS.
• Created Stored Procedures using T-SQL.
• Designed and developed SSAS Tabular model
• Created Performance Point Services dashboards and deployed to SharePoint 2010 portal.

Confidential

MSBI Developer

Environment: SQL Server 2012, SQL Server Integration Services (SSAS), PowerPivot, Performance Point Services, Power View.

Responsibilities:

• Developed excel reports using Power Pivot.
• Developed Performance point content using SSAS cubes.

Confidential

Senior Software Engineer

Environment: SQL Server Management Studio (SSMS 2012), SQL Server Integration Services (SSIS), Excel (2013)

Responsibilities:

• Developing the ETL packages.
• Maintaining the SQL database
• Created datasets for reports using complex T-SQL scripts.
• Creating Excel reporting, writing the vba code.

Confidential

Senior Software Engineer

Environment: SQL Server Management Studio (SSMS 2008 R2), SQL Server Integration Services (SSIS), SQL Services Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

Responsibilities:

• Developed various SSIS Packages.
• Designed Different Types of reports like Drill Down, Drill Through, Sub Reports and Parameterized Reports.
• Created Stored Procedures using T-SQL to define datasets in the Reports
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports

Confidential

Software Engineer

Environment: SQL Server Management Studio (SSMS 2008), SQL Server Integration Services (SSIS), SQL Services Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SharePoint Server 2007 (MOSS 2007), Performance Point Server (PPS)

Responsibilities:

• Developed various SSIS Packages
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS).
• Designed Different Types of reports like Drill Down, Drill Through, Sub Reports and Parameterized Reports.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports
• Used T-SQL queries to define datasets in drill down reports.
• Created web site in SharePoint 2007 to access SSRS reports and PPS dashboards. Assigned rights to different functional users, created web pages, created custom web parts through the SharePoint 2007 designer

Confidential

Software Engineer

Environment: ASP.NET 3.5, JavaScript, C#, Consumed Java Services, IIS6.x, HTML, JQueryIntegrated Endeca search engine with .net used Tridion CMS.

Responsibilities:

• Designing and integration of Web Pages.
• Development & unit testing of the web pages.