SUMMARY

• A highly motivated Business Intelligence (BI) Professional with 6+ years of experience in the industry.
• Extensive experience in the design, development, implementation, testing, and maintenance of Power BI solutions.
• Proficient with other Microsoft Business Intelligence (BI) platforms including SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC).
• Expert in writing DAX, SQL, and M queries.
• Very good communicator, listener, and team player.
• Passionate towards learning and suggesting best practices in the area of Business Intelligence.
• Vast experience in the development of Power BI reports and dashboards using Power BI Desktop.
• Strong command over all visual types, data modelling, ETL using Power Query Editor, measures calculated columns, and M queries.
• Expert in creating performance tuning methods on calculated measures/columns using DAX studio.
• Ability to create paginated reports using Report Builder.
• Publish the reports and dashboards to the Power BI cloud service and Report server for end user consumption.
• Experienced in configuring and maintaining Power BI service (app.powerbi.com) for content sharing; and managing the Premium Capacity of Power BI service.
• Expert in installing and maintaining On - premises gateway to provide secure data transfer between on-premises data and the cloud service.
• Proficient in carrying out administrator activities such as creating and managing security groups, assigning user permissions, monitoring usage metrics for dashboards, and auditing logs using O365 Security & Compliance Center.
• Automation of various Power BI related jobs using PowerShell Scripts and MSFT Flow/Power Automate.
• Experienced in creating Tables, Views, Stored Procedures, Triggers, Functions, and Indexes with extensive use of T-SQL.
• Strong Command over Dimensional Modeling and Designing of STAR, SNOWFLAKE Schemas.
• Capable of tuning queries for optimized performance.
• Proficient in the design, development, and implementation of Tabular Data Models in SSAS.
• Comprehensive knowledge of building Cubes, defining Referenced Relationships and creating Hierarchies and partitions.
• Used to deploy the SSAS cubes to SQL server database and create Power BI reports utilizing the Tabular Model via Analysis connector.
• Worked on report generation using Server Reporting Services (SSRS) from relational databases and OLAP cubes.
• Capable of creating parameterized, cascading, drill through, summary and sub reports.
• Experienced in the deployment of SSRS reports to the reporting server and providing assistance in troubleshooting deployment problems.

TECHNICAL SKILLS

Database: MS-SQL Server

Reporting Tools: Power BI Desktop, Power BI Report Builder, SSRS, PowerPivot for Excel

Analysis Tools: SQL Server Analysis Services (SSAS)

Languages: SQL, DAX, M-Query, Powershell Scripting

Automation: Power Automate/Flow, Powershell

IT Processes: Software Development Life Cycle (SDLC), Project Management

Productivity Applications: MSFT suite

Operating System: Windows

Performance Tuning: DAX studio

Development: Visual Studio, PowerShell ISE, Power GUI, Power BI Helper, Notepad++

Administration: Active Directory for Users and Computers, PowerBI Admin Portal, Office 365 Admin Portal, Power Platform

PROFESSIONAL EXPERIENCE

Confidential

POWER BI Developer/Admin/Architect

Responsibilities:

• Plan and deploy Power BI in the organization.
• Develop and maintain Tables, Views, and Queries in SQL server as data sources for Power BI reports.
• Design, implement and develop reporting and analytics solutions using Microsoft’ Confidential Power BI technology to suit the best of business needs.
• Transform and model data to create interactive visualizations that provide insights into the organization’ Confidential data with Power BI Desktop.
• Create and optimize advanced queries, data models and report designs to standardize dashboards throughout the organization.
• Configure and maintain Power BI service (app.powerbi.com) to share content with business users.
• Publish the reports into Power BI service by creating and managing app workspaces and apps.
• Configure and manage Premium Capacity in the Power BI service to share apps to the business users.
• Install and maintain On-premises gateway to provide secure data transfer between on-premises data and the Power BI service.
• Assist and Train other developers in accessing the enterprise gateways.
• Implement an efficient refresh process using REST API instead of the traditional Scheduled Refresh process.
• Upgrade legacy workspaces to new workspaces for better management of content access.
• Create more centralized datasets in order to reuse the existing datasets in the service thereby avoiding the refresh of duplicated datasets.
• Carry out various Power BI service administrator activities such as configuring governance policies, creating and managing security groups, monitoring usage metrics for dashboards/reports, auditing Power BI logs using O365 Security & Compliance Center, and provisioning of licenses, capacities, and organizational resources.
• Automate various Power BI related jobs using PowerShell Scripts.
• Create performance tuning methods on report level metrics using DAX studio.
• Participate in different levels of Testing (Unit testing, QA testing and UAT testing) to deliver quality data in the Dashboards.
• Design and develop paginated reports using Power BI Report Builder.
• Embed Power BI reports into a web application for external customers.
• Setup PBI report subscriptions to business users with pre-defined filters according to requirements.
• Create data-driven alerts in PBI service and automate these alerts using Power Automate/Flow.
• Refresh PBI reports based on data updates to the source using Power Automate/Flow.
• Embed Power BI reports into web applications for external customers.
• Perform Power BI Admin related activities in Azure Active Directory in Azure portal.
• Meet with business stakeholders to clarify and document reporting requirements.
• Meet with technical stakeholders to perform code reviews and elicit feedback.
• Provide training to business user Confidential on how to use Power BI dashboards and its self-service capabilities.
• Provide support services for Tickets submitted by business users on a daily basis.
• Recommend data architecture and engineering structures necessary to support reports and dashboards.

Confidential

POWER BI/SSAS/SSRS Developer

Responsibilities:

• Coordinate with business users in gathering requirements for data deliverables to ensure an understanding of their purpose and provide a technical perspective on requirements.
• Work with ETL team with the efforts to populate the Data Model.
• Create new database objects like Tables, Views, Procedures, Functions, Packages, Triggers, and Indexes using T-SQL in SQL Server.
• Develop Tabular Model infrastructure in SSAS for various Lines of Business and created over 30 different interactive Dashboards using various visualizations in Power BI Desktop.
• Create multiple dimensions, perspectives, hierarchies, and dynamic measures (DAX) to analyze performances of each KPI.
• Develop Custom Visualizations to suit the best of business needs.
• Worked on producing Monthly and Daily reports in Power BI.
• Perform technical analysis to identify options for providing functionality. Presented the strengths and weaknesses of various options, propose an approach that best addresses requirements and constraints, and estimate effort to deliver.
• Create performance tuning methods on measures (DAX) for the reporting team using Dax Studio and SQL Profiler.
• Create designs and process flow on to how standardize Power BI Dashboards to meet the requirements of the business.
• Work with other team members (Data Analysts, Data SMEs and Data Architects/Modelers) to design the source of data required and details about the meaning and structure of the data necessary to properly use it.
• Involve in the Unit testing, Quality Assurance testing and User Approval testing of Power BI reports and modifying the code accordingly to match user’ Confidential business requirements.
• Prepare and distribute Financial Reports using SSRS to internal and provide recommendations for client’ Confidential strategic decision making
• Resolve production issues related to the SSRS reports and create ad-hoc financial reports for the clients
• Reconcile general ledger and various revenue and expense accounts on monthly basis.
• Perform scenario analyses to align operational and financial resources with growth objections.

Confidential

Analyst

Responsibilities:

• Work closely with IT Team and make necessary recommendations to the BI platform.
• Responsible for the ongoing maintenance and change management of the BI application.
• Create and update new database objects like Tables, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server.
• Create views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Assist in modifying database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Responsible for deploying the application for the Integration, Functional and User Acceptance Testing.
• Participate in testing of the platform from development to production.
• Coordinate and communicate production schedules within development team.
• Assist with various ad hoc requests.
• Migrate data in various formats like text-based files, Excel spread sheets to SQL Server.
• Tune T-SQL queries to improve performance.