Power Bi Azure Data
Resume:
Vijay Kumar POWER BI Lead/DEVELOPER
Contact No: 651-***-****
Email ID: *******@*****.***
HIGHLIGHTS:
** ***** ** *********** ********** experience, especially Business Objects, Power BI, Tableau and Crystal reports.
Extensive experience in implementing Microsoft BI/Azure BI solutions like Azure Data Factory, Azure Data Bricks, Azure Analysis Services and SQL Server integration services.
Experienced creating Power BI apps for the purpose of distributing reports to users as well as creating multiple apps in Power BI Service.
Additional experience working on Power BI Desktop, Power BI Service and Power BI Mobile, as well as some limited hands-on experience using Power BI Report Server to build paginated reports.
Skilled in working with users to understand requirements and produce dashboards, reports, etc. to drive actional business insights.
Understanding the data that will be available in BW in business terms
Identifying the way end users want to analyze the data in BW
Designing the data access solution to satisfy defined business requirements
PROFESIONAL SUMMARY:
Experience in BI (Business Intelligence), Analytics, and Data warehouse solutions using Power BI, Sap Business Objects.
Designed and developed Analytics solutions using Power BI and Business Objects.
Additional experience working on Power BI Desktop, Power BI Service and Power BI Mobile, as well as hands-on experience using Power BI Report Builder to build paginated reports.
Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
Design and develop automated processes, workflows, and APIs using Microsoft Power Automate
Experience in implementing Microsoft BI/Azure BI solutions like Azure Data Factory, Azure Data Bricks, Azure Analysis Services and SQL Server integration services.
Administered and configured Power BI workspaces, ensuring optimal organization, naming conventions, and permissions for over [number] teams across the organization.
Configured and maintained on-premises data gateways for seamless data refresh from [databases/systems].
Implemented row-level security (RLS) across [number] datasets to ensure data privacy and proper access control for business users.
Skilled in working with users to understand requirements and produce dashboards, reports, etc. to drive actional business insights.
Proficient in Data Warehouse concepts, OLTP, OLAP, Star Schema, Snowflake Schema, Fact and Dimension tables
Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
Optimize and update logical and physical data models to support new and existing projects.
Maintain conceptual, logical and physical data models along with corresponding metadata.
Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
Good Knowledge and experience on Power BI Gateways (Personal and Enterprise gateways).
Expertise in designing Visualization, dashboards/reports with complex, multiple data sources (SQL, Excel, Flat files), relational design and optimizing applications.
Expert in writing MDX transformation for creating new column and existing columns in power query.
Expert in writing DAX queries for creating calculated columns and measures in Power BI Desktop.
Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.
Experience in creating Customized and ADHOC reports using Business Objects Rich Client and Web Intelligence (WEBI).
Expertise in Business Objects Enterprise Products (Universe Designer, Desktop Intelligence, Web Intelligence, Info View, CMS, CMC, CCM, Qawas & Live Office) and its deployment.
Worked in all phases of BI full life cycles including analysis, design, development, testing, deployment, post-production support/maintenance, documentation and end-user training.
Expertise in building BI components like info objects, data sources, Transformation.
Strong understanding of project life cycle and Agile methodology.
Ability to work independently and as a part of team and possesses excellent communication, interpersonal and client facing skills.
designing and building dashboards and reports tailored to financial operations, regulatory reporting, risk analytics, and performance monitoring
CORE COMPETENCIES:
Database Design
Interpersonal Communications
Best Practices/Standard Procedures
Team Leadership
Technical Documentation
Organizational Skills
Project Management
Problem Solving
Strategic Analysis
Data Warehousing
Agile/Scrum, JIRA
PROFESSIONAL EXPERIENCE:
WIMT Management Services, Wells Fargo May 2024 to Till Date
Power BI Lead/Developer
Power BI premium capacities administration and monitoring.
Power BI Security (Object level and Data Level, Datasets security for shared datasets) using Ad groups and database tables.
Design interactive Power BI dashboards for traders, analysts, portfolio managers, and compliance officers.
Create calculated measures for financial KPIs like Sharpe Ratio, Alpha/Beta, Duration, Convexity.
Clean and transform trade, position, and pricing data.
Translate business logic into DAX measures and filters.
Developing visual reports, dashboards and KPI scorecards using Power BI desktop by using DAX.
Implementing row level security on data and understand application security layer models in Power BI
Expert in writing MDX transformation for creating new column and existing columns in power query.
Proficient in making DAX queries in Power BI desktop
Progressive experience in data warehouse architecture design, logical and physical data modelling, prototyping, data security & ETL process modelling in Microsoft BI stack. (MS SQL Server, SSIS, SSAS, Power BI)
Optimize and update logical and physical data models to support new and existing projects.
Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
Building the required transformations by using the Azure Data factory Pipelines for migrating the data from source to target database
Hands-on experience using Power BI Report Builder to build paginated reports.
Created Row Level Security (RLS) and Integrated with Power BI Service portal.
Responsible for scheduling jobs for weekly, daily data refresh on different Power Bi reports.
Designed and developed Power BI Reports and Dashboards.
Migrated the code from Dev to test and to prod after testing. Tested for the Data counts, Data Quality.
Testing and dashboards performance testing.
Proficient in carrying out administrator activities such as creating and managing security groups, assigning user permissions monitoring usage metrics for dashboards
Design and develop automated processes, workflows, and APIs using Microsoft Power Automate
Designing the data access solution to satisfy defined business requirements
Monitored and reported device and user compliance using Intune dashboards and integrated Power BI reports, improving audit readiness and real-time visibility.
Provided first-line support to over [number] users, troubleshooting Power BI issues, including report publishing errors, data refresh failures, and permission issues.
Administered deployment pipelines for smooth transitions from development to production for over [number] reports and dashboards.
Regularly communicated updates, new features, and best practices to users, leading webinars and training sessions to ensure consistent Power BI adoption.
Environment: MS SQL Server, Windows server, Power BI, Excel.
Nestle, Argo Insurance and Anixter Incl-Minnesota Feb2023 to Apr 2024
Power BI Lead/Developer
Power BI administration and general support.
Power BI premium capacities administration and monitoring.
Power BI gateway servers’ administration.
Power BI Security (Object level and Data Level, Datasets security for shared datasets) using Ad groups and database tables.
Developing visual reports, dashboards and KPI scorecards using Power BI desktop by using DAX.
Implementing row level security on data and understand application security layer models in Power BI
Expert in writing MDX transformation for creating new column and existing columns in power query.
Proficient in making DAX queries in Power BI desktop
Progressive experience in data warehouse architecture design, logical and physical data modelling, prototyping, data security & ETL process modelling in Microsoft BI stack. (MS SQL Server, SSIS, SSAS, Power BI)
Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
Optimize and update logical and physical data models to support new and existing projects.
Maintain conceptual, logical and physical data models along with corresponding metadata.
Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
Experience in Microsoft SSAS tabular model with proficiency in writing complex DAX scripts to support PowerBI KPIs
Building the required transformations by using the Azure Data factory Pipelines for migrating the data from source to target database
Hands-on experience using Power BI Report Builder to build paginated reports.
Created Row Level Security (RLS) and Integrated with Power BI Service portal.
Responsible for scheduling jobs for weekly, daily data refresh on different Power Bi reports.
Designed and developed Power BI Reports and Dashboards.
Migrated the code from Dev to test and to prod after testing. Tested for the Data counts, Data Quality.
Testing and dashboards performance testing.
Proficient in carrying out administrator activities such as creating and managing security groups, assigning user permissions monitoring usage metrics for dashboards
Design and develop automated processes, workflows, and APIs using Microsoft Power Automate
Understanding the data that will be available in BW in business terms
Identifying the way end users want to analyze the data in BW
Designing the data access solution to satisfy defined business requirements
Experience with ServiceNow to establish Incident Management, Change Management, Problem Management, and Service Request Management to support the project
Environment: MS SQL Server, PL/SQL, Windows server, SAP BW, Oracle, SAP HANA, SSRS, Power BI.
Sonoco Products - South Carolina(HCL Technologies) Mar 2019 to Jan 2023
Power BI – Contractor
Responsibilities:
Gathering the requirements analysis with business users to identify and finalize requirements for Power BI solution.
Supported business users in realizing their needs for in-depth data analysis.
Working Collaboratively within and across development and project teams in a fast-paced work environment, utilizing agile BI Design.
Participating in the development lifecycle activities, including estimations, coding, unit testing, deployment, and maintenance.
Created Row Level Security (RLS) and Integrated with Power BI Service portal.
Responsible for scheduling jobs for weekly, daily data refresh on different Power Bi reports.
Designed and developed Power BI Reports and Dashboards.
Expertise in writing Complex DAX Functions in Power BI
Installed and configured enterprise gateway and personal gateway in power BI Service.
Developing Workbooks and Hyper Extracts on Tableau Desktop.
Publishing Workbooks and Data Sources to Tableau Development and QA sites.
Migrated the Tableau dashboards in to power bi
Experience in implementing Microsoft BI/Azure BI solutions like Azure Data Factory.
Experience in implementing Azure Data Bricks, Azure Analysis Services and SQL Server integration services.
Interacting with users and deliver the results up to their requirements.
Create, design, and develop Crystal Reports based on business requirements
Develop complex formulas using Crystal Reports’ built-in formula editor to perform calculations or transformations on data.
Deploy Crystal Reports to the production environment and ensure reports are available to end users.
Extensively involved in resolving the issues in the production environment.
Migrated the code from Dev to test and to prod after testing. Tested for the Data counts, Data Quality.
Testing and dashboards performance testing.
Understanding the data that will be available in BW in business terms
Identifying the way end users want to analyze the data in BW
Designing the data access solution to satisfy defined business requirements
Experience with ServiceNow to establish Incident Management, Change Management, Problem Management, and Service Request Management to support the project
Environment: MS SQL Server, PL/SQL, Windows server, SAP BW, Oracle, SAP HANA, SSRS, Power BI, Crystal Reports
Wolters Kluwer – Philadelphia (HCL Technologies) Mar 2017 to Feb 2019
BI & Analytics Developer
Responsibilities:
Gathering the requirements analysis with business users to identify and finalize requirements for Power BI solution.
Involved in BI tool evaluation for the project portfolio data management project prototyping/modeling and dashboards in Power BI.
Developed ad hoc reports in Power BI.
Supported business users in realizing their needs for in-depth data analysis.
Created design documents which Outlines the approach of the Power BI Implementation.
Demonstrated translate a question into a visualization which provides insight and answers the question.
Created dashboard designing with effective data visualization of large data volumes from various data sources (SQL server, Oracle, Spreadsheets etc.).
Experience in implementing Microsoft BI/Azure Data Bricks, Azure Analysis Services and SQL Server integration services.
Prepared Dashboards using calculations, parameters, created calculated fields, groups, sets and hierarchies in Power BI.
Used SAP HANA, Hadoop Hive, Oracle, SQL Server as data sources for designing Reports and Dashboards.
Set up Collaboration Platforms
Applied best practices in dashboard design development.
Migrated the code from Dev to test and to prod after testing. Tested for the Data counts, Data Quality.
Testing and dashboards performance testing.
Environment: MS SQL Server, Windows server, SAP BW, Oracle, SAP HANA, SSRS, Power BI.
USAA - San Antonio, TX(HCL Technologies) Aug 2015 to Feb 2017
Sr. BI Consultant
Responsibilities:
Monitoring the report scheduling and creating new schedules.
Finding the Root causes of the bugs raised by the user for reports and universes. Fixed them to work as per the business needs.
Involved in preparing the Business Requirement Document, functional design documents and Release supported documents.
Reporting the consolidated daily/weekly status to the PM.
Involved in Peer review activities for Code & Testing.
Generated the Reports Weekly and Monthly wise as per the Client.
Interacted with Business Users, Business owners to know their issues to fix the incidents and to know the Business requirements for CR in developing and modifying Universes and Reports accordingly.
Involved in Business Objects Universes and Reports.
Created configuration blocks in Spotfire and set up guided analysis to carry the filter selections from one analysis to other.
Migrated the code from Dev to test and to prod after testing. Tested for the Data counts, Data Quality Interface.
Resolve issues with Crystal Reports servers, such as connectivity issues, report failures, or server crashes.
Validate that Crystal Reports are accurate and meet the business requirements
Maintain version control for report templates and modifications.
Worked on LCM to promote the code from one environment to other environment and used the version control to maintain the version of code for each release.
Environment: BO XIR4.1,Crystal Reports, BEX, SAP HANA, Service Now.
Wolters Kluwer - Hyderabad, INDIA(HCL Technologies) Jan 2013 to July 2015
BI Consultant
Responsibilities:
Worked on day-to-day production support issues and resolved within the SLA time line.
Handling monthly production release activities and performing UAT and Production support.
Creating Analysis for office reports and analysis workspace reports.
Worked on the Change Requests based on the user requirements.
Finding the Root causes of the bugs raised by the user for reports and universes. Fixed them to work as per the business needs.
Involved in preparing the Business Requirement Document, functional design documents and Release supported documents.
Reporting the consolidated daily/weekly status to the PM.
Involved in Peer review activities for Code & Testing.
Generated the Reports Weekly and Monthly wise as per the Client.
Interacted with Business Users, Business owners to know their issues to fix the incidents and to know the Business requirements for CR in developing and modifying Universes and Reports accordingly.
Involved in Business Objects Universes design and Reports development.
Developed Web I Reports using Web I Rich Client and Info view.
Worked on promotion management to promote the code from one environment to other environment and used the version control to maintain the version of code for each release.
Environment: BO XIR3.1, Informatica 9.X, Oracle 11g, Service NOW, Win NT
Intel Sap BO - Hyderabad, INDIA(HCL Technologies) Jan 2011 to Dec 2012
Sr. Business Objects Developer
Responsibilities:
Requirements gathering and analysis.
Propose Technical design approach for Information Design Tool universe and reports development.
Develop Web Intelligence reports.
Perform Unit testing and provide support for UAT and Production.
Code development and conducted validation and Unit Testing (UT).
Provide assistance to the team for the Production setup.
Assigning Role based restriction to the users.
Xcelsius Dash boarding
oAnalyze and gather requirements to create dashboard for Perfect Order group.
oCreate and Configure Development environment.
oCreate Dashboard off perfect order Data mart using Xcelsius.
oProvide Technical approach and design documents.
Test and deploy Xcelsius dashboard (.SWF) in UAT and Production.
Environment: Business Objects XI 4, Xcelsius Dashboard, Teradata.
Contact this candidate