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 / AXF16026
profile image
Beig R AXF16026 Active
Data Analyst in Hyderabad
I'm a data enthusiast specializing in Power BI, SQL, and Excel. With a knack for transforming raw data into actionable insights, I thrive on leveraging technology to drive informed decisions and business growth.
Industries : Oil and Gas
Share
Hire Beig R
Download PDF
Availability
Full-time
Total experience
4 years
Technical skills
POWER BI
4 Years & 2 Months
Excel VBA
2 Years & 5 Months
SQL Server
2 Years
Power apps
6 Months
Power Automate
6 Months
Power BI,SQL
Projects
Gallons By Territory
December-2023 to February-2024
Description
The "Gallons By Territory" report for NOCO focuses on analyzing the distribution of fuel across various territories within the company's operational scope. It provides detailed insights into the volume of fuel consumed in each territory, allowing stakeholders to assess consumption patterns and trends effectively. By examining the gallons of fuel used per territory, the report aids in optimizing fuel allocation strategies and identifying potential areas for improvement in fuel management practices. This information empowers NOCO to make data-driven decisions aimed at enhancing operational efficiency, reducing costs, and ensuring optimal utilization of resources across territories. Ultimately, the report plays a vital role in supporting NOCO's efforts to manage its fuel resources effectively and drive sustainable business growth
Roles and Responsibilities
 Creating dashboards by connecting to the SQL Server, flat files in Power BI.  Extensively used DAX to achieve different functionalities within the visuals.  Publish reports in Power BI Report server environment.  Controlling the access for users by implementing role level security and managing the admin activities of report server.  Involved in fixing the change requests for the application developed.  Creating Staging Database for temporary Processing of data, consolidating data and Loading database using Integration Services.  Developed Stored Procedures and views.  Used Control flow tasks like for loop container, execute SQL task and data flow task, extensively used derived column, data conversion and aggregate.  As per the requirements, rendering the reports in the form of Excel and .csv formats for each module with credentials.  Created transformations and mappings using data flow tasks. Also, created event handlers for the package using Event Handler Tab.
Technologies: Power Bi
Industry: Oil and Gas
Operations Dashboard
September-2023 to December-2023
Description
Designed and developed an Operations Dashboard for NOCO, offering insights into fuel delivery operations. Tracked deliveries, Point of Deliveries (PODs), and key metrics for real-time monitoring. Incorporated interactive visualizations and KPIs for analyzing delivery performance and driver efficiency. Implemented year-on-year comparisons to identify trends and areas for improvement. Contributed to enhanced delivery processes and customer service through data-driven decision-making.
Roles and Responsibilities
 Developed complex DAX logic for the report to achieve various functionalities within Power BI visuals.  Implemented efficient data processing by migrating complex logic from Power BI Desktop to SQL Server.  Created Common Table Expressions (CTEs) and temporary tables in SQL for optimal data manipulation and storage.  Designed and developed stored procedures in SQL Server to encapsulate data processing logic.  Scheduled SQL jobs to automate the execution of data processing tasks.  Ensured data security and access control by implementing role-level security in Power BI.  Managed administrative activities for the Power BI Report Server environment.  Resolved change requests and addressed issues related to the application development.
Technologies: Power BI,SQL
Industry: Oil and Gas
Soft skills
Effective Communication
Teamwork
Problem-solving
Adaptability
Time Management
Leadership
Emotional Intelligence
Critical Thinking
Conflict Resolution
Education
Bachelors degree in B.com Computers
Acharya Nagarjuna University
2013 to 2016
Language
English - Advanced