AugmntX

AugmntX is the world’s largest network of pre-vetted talent.

Contact Info

305, IRIS Corporate Centre,
Hiranandani Meadows, 400610.
hello@augmntx.com
+919820045154

Follow Us

Home / Developers / AXF22044
profile image
Borad V AXF22044 Active
Data Analyst in Surat
"As a certified data analytics and visualization enthusiast, I am dedicated to driving organizational growth and seeking professional development in an innovative environment."
Industries : Game, Healthcare, Law Enforcement
Share
Hire Borad V
Download PDF
Availability
Full-time
Total experience
4 years
Technical skills
POWER BI
4 Years
Python
3 Years
SSIS
3 Years
ETL Processes
2 Years & 6 Months
Excel
2 Years & 2 Months
Power BI,SQL Server 2019,Pyhton, SSIS,SQL Server 2019, PowerBI, SSRS, PowerShell
Projects
Gaming Analysis
December-2023 to May-2024
Description
It's an online platform for users to play different games from different providers. The application has 12 different providers with different games to be played
Roles and Responsibilities
Extract data from various sources, including databases, spreadsheets, APIs, and cloud services. Clean, transform, and model data to ensure it is suitable for analysis and reporting. Design and develop data models, including creating relationships between tables, calculated columns, and measures. Optimize data models for performance and usability. Create interactive and visually appealing reports and dashboards using Power BI Desktop. Design user-friendly and intuitive navigation within reports. Implement custom visuals and templates to enhance report aesthetics and functionality.
Technologies: Power BI,SQL Server 2019,Pyhton
Industry: Game
Healthcare Sales Analysis
February-2023 to December-2023
Description
It aims to analyze healthcare sales data to uncover valuable insights and trends. Through data-driven analysis and visualization, this project seeks to provide actionable recommendations for optimizing sales strategies and improving the overall efficiency of the healthcare sales ecosystem
Roles and Responsibilities
Daily Standup Meetings. Create new Power BI reports. Update the existing Power BI reports. Optimize DAX query in the existing Power BI reports. Define key performance indicators (KPIs) with specific objectives and track them regularly. Create charts and data documentation with explanations of algorithms, parameters, models, and relationships. Create and maintain SQL scripts and packages using SSIS. Support ETL processing in support of transforming and loading data into the data warehouse.
Technologies: Power BI, SSIS,SQL Server 2019
Industry: Healthcare
Law Firm Project (NYC-based)
June-2022 to January-2023
Description
The project was for an International Law Firm based in New York City. The Firm guides clients through complex issues, bringing insight and judgment to each situation. They solve clients' most complex domestic and multijurisdictional deals and disputes. They wanted Power BI reports and applications to represent real-time data by combining various data sources and Different connectivity modes.
Roles and Responsibilities
Attended Daily Task Review meetings. Development of rich dashboards for detailed analysis of data using different data sources like SQL, Excel, Live connections with Power BI datasets, etc. Deployment of reports on staging and production after testing. Prepared PowerShell scripts for various Power BI admin activities like deploying Reports, Refresh datasets, Configure parameters, etc. Prepared scripts for Jenkins to execute PowerShell scripts. Created Applications from multiple reports in individual workspaces. Manage User access and row-level security. Added/Updated SSRS reports based on the request received from Management.
Technologies: PowerBI, SSRS, PowerShell, Python
Industry: Law Enforcement
Soft skills
Communication
Problem-solving
Teamwork
Certifications
Microsoft Certified Power BI Data Analyst by Microsoft
2023
Microsoft Professional Power BI by Microsoft
2024
Education
Bachelors degree in Information Technology
Uka Tarsadiya University
2018 to 2022
Language
English - Advanced