Rohit Barar
Power bi Developer
Hyderabad,TG
Summary
To play a key role in implementing and developing Software in-turn learning and enhancing my technical skills to deliver excellent services.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Power Bi Developer SQL Server ,Spark SQL
Infosys Ltd.
06.2022 - Current
- Created custom APIs for seamless integration with third-party services, expanding application functionality and compatibility.
- Worked closely with clients to gather requirements and translate them into technical specifications for implementation.
- Continuously updated skills through training courses, workshops, and self-study—staying current on industry trends and emerging technologies.
- Debugged complex software issues, leading to a more stable product release.
Power Bi Developer
Aeries Techonolgy
11.2021 - 04.2022
- Extracting data from Databricks (data lake) into Power query and then cleansing the data by applying business logic and metric
- Created Enviromental setup between Data bricks and power bi
- Created complex SQL queries, views in databricks to import the data from databricks to power bi
- Created new columns, new measures and conditional columns using DAX functions
- Created different filters like visual level filters and page level filters and report level
- Created Calculated Columns, Calculated Measure and Calculated Table based on the business requirements
- Created Measure and columns using various dax functions such as Aggregate, Date and time, Text function, Mathematical functions
- Publishing reports to Power BI server and providing the access to required users
- Performed performance tuning of stored procedures using SQL Server Profiler
- Supported development effort by providing T-SQL statement tuning and optimize data loading processes
- Designed different types of reports like drill down, drill through, And Sync Slicer
- Designing and developing power BI scripts for importing data from source
- Working on Power BI desktop and service development
- Working on the Power BI reports & dashboards with SQL Server/Tabular SSAS sources
- Using DAX for data transformation in Power BI Desktop
- Created various Customized and interactive Reports and Dashboards in Power BI
- Worked on On-Premises Gateway to refresh the data sources and scheduling the data
- Publishing the data source into Power BI Server and scheduling the data sources
- Implemented Role Based Security as part of user level security in Power BI
- Designing and developing power BI scripts for importing data from source.
Associate
Wipro Technologies
10.2020 - 10.2021
- Created SSIS package to get data from different sources, consolidate and merge into one single source
- Created functional requirement specifications and supporting documents for business systems
- Extracted data from various sources like SQL Server 2008R2, CSV, Excel and Text file from Client servers
- Created Mail Tasks with the error file attachments using package Variable
- Performed tune to optimize SQL queries using SQL profiler and query analyzer
- Created Indexes, Constraints and Rules on database objects
- Involved in end-to-end documentation of all the processes including aggregation and all the relevant customizations made in the system
- Working on Power BI desktop and service development
- Working on the Power BI reports & dashboards with SQL Server/Tabular SSAS sources
- Using DAX for data transformation in Power BI Desktop
- Created various Customized and interactive Reports and Dashboards in Power BI
- Publishing reports to Power BI server and providing the access to required users.
Senior Software Engineer
HSBC Electronic Data Processing
03.2017 - 02.2020
- Involved in end-to-end documentation of all the processes including aggregation and all the relevant customizations made in the system
- Worked on creating the Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications
- Worked with improving the performance on SQL, TSQL and procedures and provided the recommendation on server related tuning issues
- Performed performance tuning of stored procedures using SQL Server Profiler
- Created SSIS package to get data from different sources, consolidate and merge into one single source
- Created functional requirement specifications and supporting documents for business systems
- Extracted data from various sources like SQL Server 2012, CSV, Excel and Text file from Client servers
- Created Indexes, Constraints and Rules on database objects.
Systems Engineer
ICICI Bank
03.2015 - 12.2016
- Supported system users, educating employees on troubleshooting and problem-solving protocols.
- Delivered helpdesk service and support to customers.
- Streamlined troubleshooting processes to improve system support and enhance communication between support team and end-users.
- Contributed towards continuous improvement initiatives aimed at streamlining internal processes and enhancing overall service delivery quality.
Education
B.com computers -
Osmania University
Skills
Power bi developer
Projects
Molina, USA, Dec 2022 to Till now, Databricks, Power BI Desktop, Power BI Services, DAX, SQL Server & Excel, BI Developer, Extracting data from Databricks (data lake) into Power query and then cleansing the data by applying business logic and metric. Created Environmental setup between Data bricks and power bi. Created complex SQL queries, views in databricks to import the data from databricks to power bi. Created new columns, new measures and conditional columns using DAX functions. Created different filters like visual level filters and page level filters and report level. Created Calculated Columns, Calculated Measure and Calculated Table based on the business requirements. Created Measure and columns using various dax functions such as Aggregate, Date and time, Text function, Mathematical functions. Publishing reports to Power BI server and providing the access to required users. Performed performance tuning of stored procedures using SQL Server Profiler. Supported development effort by providing T-SQL statement tuning and optimize data loading processes. Designed different types of reports like drill down, drill through, And Sync Slicer. Designing and developing power BI scripts for importing data from source. Working on Power BI desktop and service development. Working on the Power BI reports & dashboards with SQL Server/Tabular SSAS sources. Using DAX for data transformation in Power BI Desktop. Created various Customized and interactive Reports and Dashboards in Power BI. Worked on On-Premises Gateway to refresh the data sources and scheduling the data. Publishing the data source into Power BI Server and scheduling the data sources. Implemented Role Based Security as part of user level security in Power BI. Designing and developing power BI scripts for importing data from source. Pediatric Associates, US, Sep 2018 to March 2020, MS SQL Server, SSIS, Power Bi Desktop, Power BI Service & DAX, SQL & Power Bi Developer, Created SSIS package to get data from different sources, consolidate and merge into one single source. Created functional requirement specifications and supporting documents for business systems. Extracted data from various sources like SQL Server 2008R2, CSV, Excel and Text file from Client servers. Created Mail Tasks with the error file attachments using package Variable. Performed tune to optimize SQL queries using SQL profiler and query analyzer. Created Indexes, Constraints and Rules on database objects. Involved in end-to-end documentation of all the processes including aggregation and all the relevant customizations made in the system. Working on Power BI desktop and service development. Working on the Power BI reports & dashboards with SQL Server/Tabular SSAS sources. Using DAX for data transformation in Power BI Desktop. Created various Customized and interactive Reports and Dashboards in Power BI. Publishing reports to Power BI server and providing the access to required users. BBC, UK, May2014 to Aug 2018, MS SQL Server, SQL & SSIS Developer, Involved in end-to-end documentation of all the processes including aggregation and all the relevant customizations made in the system. Worked on creating the Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications. Worked with improving the performance on SQL, TSQL and procedures and provided the recommendation on server related tuning issues. Performed performance tuning of stored procedures using SQL Server Profiler. Created SSIS package to get data from different sources, consolidate and merge into one single source. Created functional requirement specifications and supporting documents for business systems. Extracted data from various sources like SQL Server 2012, CSV, Excel and Text file from Client servers. Created Indexes, Constraints and Rules on database objects.
Disclaimer
I hereby declare that the above-mentioned information is true to the best of my knowledge.
Certification
Microsoft azure fundamentals
Timeline
Power Bi Developer SQL Server ,Spark SQL
Infosys Ltd.
06.2022 - Current
Power Bi Developer
Aeries Techonolgy
11.2021 - 04.2022
Associate
Wipro Technologies
10.2020 - 10.2021
Senior Software Engineer
HSBC Electronic Data Processing
03.2017 - 02.2020
Systems Engineer
ICICI Bank
03.2015 - 12.2016
B.com computers -
Osmania University
Similar Profiles
NAVED ANWAR MAULAVINAVED ANWAR MAULAVI
Digital Specialist Engineer L2 (JL5) at Infosys Ltd.Digital Specialist Engineer L2 (JL5) at Infosys Ltd.
Manish KumarManish Kumar
Senior Consultant at Infosys Ltd.Senior Consultant at Infosys Ltd.
Vamsi GorribandaVamsi Gorribanda
Network Analyst at Infosys Ltd.Network Analyst at Infosys Ltd.
SREEJAI K PILLAISREEJAI K PILLAI
Technology Analyst at Infosys Ltd.Technology Analyst at Infosys Ltd.
Manoj GuduguntlaManoj Guduguntla
Principal Consultant at NgSupplyChain Solutions Pvt LtdPrincipal Consultant at NgSupplyChain Solutions Pvt Ltd