SUMMARY

• 10 Years of IT experience working in MS Business Intelligence products, SQL Server, Microsoft .NET technologies and SharePoint product.
• Good experience in developing solutions using Microsoft BI technologies like SSAS, Azure Analysis Services, SSRS, SSIS, Power BI Cloud and Power BI report Server.
• Experience in Designing Multi - Dimensional Analysis Cubes (Configured Cubes, Dimensions, Measures, MDX Queries following Star and Snowflake schema) using SQL Server Analysis Services (SSAS).
• Experience in designing tabular models (Measures, DAX Queries, 1200, 1400 and 1500 compatibility levels) using Azure Analysis Services and SQL Server Analysis Services Tabular mode.
• Have a very good understanding of Multi-Dimensional and Tabular architecture and Internals of formulae and storage engines.
• Have administrative experiencing in configuring scale-out environments, deployments, capacity planning and troubleshooting complex performance issues.
• Experience in designing paginated reports and Power BI reports using Reporting Services and Power BI Report Server.
• Have very good understanding on Reporting Services Architecture and working experience in Report Scheduling, Schedule refreshes, programmatic access of reporting services web service.
• Experience in developing Power BI Datasets and Reports (Import mode and Direct Query mode) using Power BI Desktop and managing schedule refreshes for Import mode reports).
• Experience in developing SSIS packages and have a very good understanding of different control flow tasks and data flow transformations.
• Good understanding of working with Power Query inside the Power BI Desktop when it comes to transforming the data retrieved from multiple data sources.
• Solid understanding on .NET fundamentals and have a working experience of developing applications using ASP.NET and ADO.NET technologies.
• Experience in developing SharePoint solutions like creation of custom webparts, content types and using SharePoint object model.

TECHNICAL SKILLS

Operating Systems: Windows Server 2003 and later

ETL Tools: SQL Server Integration Services SSIS, ADF Basics

Reporting Tools: SSRS, Power BI Report Server and Power BI Cloud

Analytical tools: SSAS, Azure Analysis Services

Development Skills: T-SQL, PL/SQL, HTML, XML, ASP.Net, CSS, Power Query etc.

Programming: C#.NET, T-SQL, MDX, DAX

Cloud Technologies: Azure

Databases: MS SQL Server, Oracle

Office products: Excel, SharePoint

Scripting languages: JavaScript, PowerShell

PROFESSIONAL EXPERIENCE

Confidential, Dallas-Tx

Senior BI Developer

Responsibilities:

• Designing and developing Tabular models, creating measures and calculated columns using DAX.
• Designing and developing multi-Dimensional cubes, creating measures, calculations, partitions, Aggregations etc.
• Worked on creation on calculation groups, perspectives and have good understanding of working with relationships.
• Performance tuning of the on-prem SSAS (both Tabular and Multi-Dimensional) and Azure Analysis Services models and queries.
• Worked on provisioning Azure Analysis Services and automating using ARM templates.
• Created Azure Automation script to process the models and check the status against Azure Analysis Services using REST API's.
• Worked on administrative activities like automating backup, automating processing, deployments for both on-prem SSAS and Azure Analysis Services
• Have configured environments with query replicas and processing servers and fine tuning server properties to make sure they perform the respective activities better by utilizing maximum resources.
• Designing of paginated reports like drilldown, drill through, matrix parameterized reports and Dashboard's using SQL Server Reporting Services.
• Worked on Mobile reports and Power BI reports(Import and Direct Query) using Power BI Report Server.
• Worked on creation of Power BI cloud reports, Dashboards and configuring scheduled refresh.
• Worked on Data modelling using Power BI Desktop and use Power Query to transform the data retrieved from heterogeneous data sources.
• Created Subscriptions, configured reports caching and snapshots.
• Worked on Reporting Services and SharePoint integration, using Report Webparts, Power View reports in SharePoint etc.
• Designing the ETL architectureforincremental loadto keep old and new applications in sync.
• CreatedSSIS packagesfromscratchto performETLprocess and loaded the data into destination table.
• Validatingandloopingthrough variousfile sourcesand loadingdynamicallyinto the database usingSSIS taskslikeScript Task,For Each Loop Container,ForLoop Container,
• File System Task, FTP task, Sequence Container, ExecuteSQL etc.
• ImplementedError Handling,Isolation Levels,Precedence Constraints,and Expressionsin SSIS packages.
• Extensively usedSSIS transformationslikeData Conversion,Lookup,Fuzzy Lookup,Merge,ConditionalSplit,DerivedColumn,OLEDB command,Union All,Cacheetc.
• Involved in writing T-SQL queriesandstore proceduresto perform data transformations.
• Created application using C#.NET, ASP.NET and ADO.NET technologies.
• Worked on SharePoint products and Technologies.

Environment: Azure Analysis Services, SSAS, SSRS, SSIS, Power BI, C#.NET.

Confidential, Detroit

Technical Consultant

Responsibilities:

• Implemented SharePoint timer jobs, which pulls the HTML content from any public external content store based on the URL.
• Customized Portal Content by Query web part, which display’s the content based on the tagging, content type, user profile values and custom XSL styles.
• Programmatic creation of content types, site columns and their associations. Retaining the site column property values and changes on multiple re deployments.
• PowerShell scripts to create the 250 nested sub sites and related data.
• Mobile redirection implementation when opened from a mobile device.

Environment: ASP.NET, SharePoint 2010, C#, XSL, jQuery, SQL Server 2008, IIS 7.0 and Windows Server 2008.

Confidential, Austin - Texas

.NET Developer

Responsibilities:

• Extensively involved in the design and development of dynamic web pages using Web Forms, HTML and Server Controls.
• Managing multiple modules/ sub applications and guiding the peers in completing the tasks.
• Gathering the requirements from the client.
• Implementing windows services and the web services for the Workers Comp and BOP application(s).
• Implemented the Multi select multi file upload functionality.

Environment: C#,.NET 1.1,.Net 2.0, Ajax, Jquery, SSRS, SQL Server 2005, IIS 6.0 and Windows Server 2003.

Confidential, Austin, TX

.NET Developer

Responsibilities:

• Extensively involved in the design and development of dynamic web pages using Web Forms, HTML and Server Controls.
• Developed Webparts for Sharepoint Portal Site Using Visual Studio 2005
• Deploying the site and placing the build in production and staging environments.
• Extensive end user interaction for gathering requirements, design and UI approvals and User acceptance testing.
• Involved in generating the reports using SQL Server Reporting Services and integrating the generated reports in the .Net Application using the Report Viewer Control.
• Performing the Code Reviews and involved in the internal Audits.
• Implemented Single Sign On for third party application to access the Data Specs Application.

Environment: C#, ASP.NET, SharePoint Server 2007, MS Visual Studio.NET, SQL Server 2005, IIS 6.0 and Windows Server 2003.