Sukesh Sangaraju
Power bi developer
Bengaluru
Summary
Dynamic Power BI Developer with a proven track record at GIGABYTE Technology, adept at transforming complex datasets into insightful reports. Excelled in collaborative environments, enhancing team efficiency and problem-solving. Skilled in Power BI, SQL, and advanced analytics, with a keen ability to multitask and optimize data-driven decision-making processes.
Complex problem-solver with analytical and driven mindset. Dedicated to achieving demanding development objectives according to tight schedules while producing impeccable code.
Overview
5
5
years of professional experience
2018
2018
years of post-secondary education
3
3
Languages
Work History
Power BI Developer
GIGABYTE Technology
05.2023 - 03.2024
- Preparing and submitting billing data and medical claims to insurance companies
- Ensuring each patient's medical information is accurate and up to date
- Preparing bills and invoices and document amounts due to medical procedures and services
- The primary responsibility is to analyze complex medical billing data and create visually appealing and insightful reports using Power BI
- I used to transform raw medical billing data into a format suitable for analysis
- This involves data cleansing, modeling, and creating relationships between different data sources to ensure accurate reporting
- Develop interactive dashboards and reports that provide key insights into medical billing operations
- This includes designing intuitive user interfaces, implementing interactivity features like filters and drill-downs, and ensuring the reports meet the specific needs of stakeholders
- Worked on all types of transformations that are available in Power BI Query Editor
- Integrate data from various sources such as billing systems, electronic health records (EHR), and financial systems into Power BI for comprehensive analysis
- This may involve using Power BI connectors or custom data integration solutions
- Created Workspace and content packs for business users to view the developed reports and configured users to the created workspace with suitable privileges
- Optimize the performance of Power BI reports and dashboards to ensure they load quickly and provide a smooth user experience, even with large datasets
- This may involve techniques such as data model optimization, query optimization, and using efficient visualization techniques
- Created Workspace and content packs for end users to view the developed reports
- Collaborate with stakeholders including medical billing teams, managers, and executives to understand their requirements and translate them into actionable reports
- Effective communication skills are essential for gathering requirements, presenting findings, and providing ongoing support
- Monitor the performance and usage of Power BI reports and dashboards, identifying any issues or areas for improvement
- Perform regular maintenance tasks such as data refresh scheduling, updating data sources, and resolving any errors or issues that arise
- Project Name: National medical billing service
- Team Size: 5
- Technology – Power BI, SQL Server, Sap HANA, Data marts, Data warehouse, Azure Synapse, ADF, Azure BLOB, Tableau, power Apps, Power Automate, Advance Excel
MIS Executive
Wow Momo Food Private Limited
09.2022 - 03.2023
- Here we used to collect, analyzing, and interpreting data related to sales, customer behavior, operations, and other key metrics within the restaurant chain, using tools like Excel, Power BI, and SQL, to identify trends, provide insights, and support strategic decision-making for improving efficiency and profitability across Wow Momo outlets
- Attending the Client meetings taking the Power BI requirements, after we shared the MOM, BRS and Design documents to clients and taken the sign-off for those documents
- Analysis the client requirements and start the development met the client expectations
- Attending the Internal meeting for getting source data from Integration team
- ETL Team Pull the Data from Vertica DB load to Azure ADLS storages through ADF and Team was performed the All transformation in ADF and moved to Synapse Analytics
- For CASA report Data source is Az Synapse (SQL Pools) and BI team pull the data from Az Synapse to Power BI desktop
- BI Team was performed the all transformation in Power Query editor and load to PBI Desktop
- In PBI Desktop Developed and Design the different Dashboards are PAN India, Segment wise, Geographical and KPI's are Current Year, Last Year, FTD, MTD, QTD & YTD Summary Report & Detailed Reports
- Implemented the Dynamic Row Level Security for above reports
- Published the designed reports into Dedicated Dev
- Workspaces
- After that testing team done the Testing activities and moved to production workspaces
- Configure the Data sources to On-premise gateway & Schedule the above reports in Power BI service as per Client needs
- We are created the Power App in Prod
- Workspaces for distributing the reports to larger audience (BM's/BH's/RH's) in secure manner
- Technology: Power BI, Advanced excel, SQL
Executive
Amnesty International India Private Limited
05.2019 - 09.2020
- An Amnesty International India Data Analyst would be responsible for collecting, analyzing, and interpreting large datasets related to human rights violations in India, using data analysis tools to identify trends and patterns, and then presenting these insights to inform Amnesty International's research, advocacy, and campaigning efforts on human rights issues
- The primary responsibility is to analyze complex medical billing data and create visually appealing and insightful reports using Power BI
- I used to transform raw medical billing data into a format suitable for analysis
- This involves data cleansing, modeling, and creating relationships between different data sources to ensure accurate reporting
- Develop interactive dashboards and reports that provide key insights into medical billing operations
- This includes designing intuitive user interfaces, implementing interactivity features like filters and drill-downs, and ensuring the reports meet the specific needs of stakeholders
- Worked on all types of transformations that are available in Power BI Query Editor
- Integrate data from various sources such as billing systems, electronic health records (EHR), and financial systems into Power BI for comprehensive analysis
- This may involve using Power BI connectors or custom data integration solutions
- Created Workspace and content packs for business users to view the developed reports and configured users to the created workspace with suitable privileges
- Optimize the performance of Power BI reports and dashboards to ensure they load quickly and provide a smooth user experience, even with large datasets
- This may involve techniques such as data model optimization, query optimization, and using efficient visualization techniques
- Created Workspace and content packs for end users to view the developed reports
- Collaborate with stakeholders including medical billing teams, managers, and executives to understand their requirements and translate them into actionable reports
- Effective communication skills are essential for gathering requirements, presenting findings, and providing ongoing support
- Monitor the performance and usage of Power BI reports and dashboards, identifying any issues or areas for improvement
- Perform regular maintenance tasks such as data refresh scheduling, updating data sources, and resolving any errors or issues that arise
- Technology – Power BI, SQL, Advanced Excel
Education
B. TECH - Electronics and Communications Engineering
JNTUK
Skills
- Teamwork
- Collaboration
- Problem-solving
- Time management
- Quick learner
- Multitasking
- Power BI
- Advanced excel
- SQL
- Azure Synapse
- ADF
- Data warehouse
- Data marts
- Power apps
- Power Automate
Personal Information
- Date of Birth: 01/21/95
- Gender: Male
- Nationality: Indian
- Marital Status: Single
Timeline
Power BI Developer
GIGABYTE Technology
05.2023 - 03.2024
MIS Executive
Wow Momo Food Private Limited
09.2022 - 03.2023
Executive
Amnesty International India Private Limited
05.2019 - 09.2020
B. TECH - Electronics and Communications Engineering
JNTUK
Similar Profiles
Arvin ZhangArvin Zhang
Accountant at Gigabyte TechnologyAccountant at Gigabyte Technology
Rosemarie CanatuanRosemarie Canatuan
Factory Worker at GIGABYTE TechnologyFactory Worker at GIGABYTE Technology
Vanessa PengVanessa Peng
Channel Marketing Analyst at Seagate TechnologyChannel Marketing Analyst at Seagate Technology