Importing data from the SharePoint and power bi semantic model
Implementing row-level security on data along with an understanding of application security layer models in Power BI
Creating Dax Queries to generate new columns and measures to reach the requirement in Power BI
Developing reports for Import/Export data to/from .CSV File
Creating manual parameters with and making changes in M Query to get the structured data into datasets
Creating Dynamic Parameters to trigger the data from one data set to another dataset
Developing the report and publishing in Power BI Server
Sr. Software Engineer
Tech Mahindra
01.2020 - 04.2024
Importing data from Rest API's, Excel, share point to Power BI to generate reports
Design, develop, and implement data models in Snowflake to support Power BI reporting and analytics
Developing visual reports, KPI scorecards, and dashboards using Power BI desktop
Implementing row-level security on data along with an understanding of application security layer models in Power BI
Creating Dax Queries to generate new columns and measures to reach the requirement in Power BI
Developing reports for Import/Export data to/from .CSV File
Using postman tool for API data analyzing
Creating manual parameters with and making changes in M Query to get the structured data into datasets
Creating Dynamic Parameters to trigger the data from one data set to another dataset
Developing the report and publishing in Power BI Server
Creating workspace as per the client requirement and maintaining the report
Scheduling automatic data refresh, giving access to user and sharing the reports to users, and monitoring the dashboards daily basis
Power BI Developer
Vida Labs
11.2017 - 12.2019
Company Overview: Established in 2004, Vida Labs are Specialty finished formulation manufacturing pharmaceutical company
Having 100% export-oriented unit having our corporate office in Bangalore, India
One of the largest exporters of sterile formulations from India
Understand business requirements in BI context and design data models to transform raw data into meaningful insights
Create dashboards and interactive visual reports using Power BI
Identify key performance indicators(KPIs) with clear objectives and consistently monitor those
Analyzing data and present data through reports that aid decision-making
Convert business requirements into technical specifications and decide timeline to accomplish
Create relationships between data and develop tabular and other multidimensional data models
Chart creation and data documentation explaining algorithms, parameters, models, and relations
Design, develop, test, and deploy Power BI scripts and perform detailed analytics
Perform DAX queries and functions in Power BI
Analyze current ETL process, define and design new systems
Redefine and make technical/strategic changes to enhance existing Business Intelligence systems
Create customize charts and custom calculations as per requirements
Established in 2004, Vida Labs are Specialty finished formulation manufacturing pharmaceutical company
Having 100% export-oriented unit having our corporate office in Bangalore, India
One of the largest exporters of sterile formulations from India
Microsoft Power BI and SAP Security Consultant
E-Exchange Services Pvt. Ltd.
03.2015 - 12.2019
Importing data from SAP BW and excel to get datasets and developing reports Using Bex Analyzer to analyze the data
Monitor the performance of the SAP BW system, ensuring efficient data loads and query executions
Work with the business and reporting teams to design and develop SAP BW reports using BEx Query Designer and other reporting tools like Power BI
Collaborate with business stakeholders to gather and analyze requirements, translating them into technical specifications
Develop and maintain ETL (Extract, Transform, Load) processes using SAP BW, including data extraction, transformation, and loading from various source systems (SAP and non-SAP)
Creating Live Connection to report to teams with the help of share point
Implemented Visual Level, Page level, report level filters and pinning in dashboards
Written simple DAX calculation as per the requirement to maintain business measures
Worked on report permissions and dashboard permissions to provide access to different users
Managing Relationship tabs to get the data into correct format
Used Quick insights to get various types of visuals to match the requirements
Experience on relationship tab to provide cardinality between fact and dimension tables
Involved creating effective reports, dashboards, and publishing into Power BI service
Develop best practices for database design and development activities
Connect, import, shape, and transform data for business intelligence (BI)
Experience in developing Visualization reports and dashboards using Power BI
Visualize data, author reports, and schedule automated refresh of reports
Power BI Consultant and SAP Security Consultant
Noble Biocare
03.2015 - 09.2017
Company Overview: The core business of the company is the manufacture of dental implants and related products used to treat tooth loss, such as abutments, crowns and bridges
Creation of SAP User Accounts, Creation of Access Roles/Jobs
Amendments to Users Access Levels, Amendments to Access Roles/Jobs
Handling queries from Support teams on a wide range of SAP issues
Delivery of daily support tasks, change requests, large changes request and ad hoc unplanned changes
Preventative maintenance tasks to ensure IT systems are operational and secure, and to prevent future incidents
Troubleshooting incident and problem resolution, maintaining the highest levels of customer satisfaction possible
Power BI development and administration
Building Analysis Services reporting models
Developing the front-end Power BI reports
Using different kinds of visualizations and using drill down functions
Supporting to the team with continuous learning and accepting challenging tasks
Interaction with the clients and providing the customized dashboards based on requirement
The core business of the company is the manufacture of dental implants and related products used to treat tooth loss, such as abutments, crowns and bridges