We provide IT Staff Augmentation Services!

Senior Bi Developer Resume

Dallas-tX

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.

Hire Now