MEKALA VEERA KUMAR

With 5+ years of hands-on experience in Power BI development and SQL services integration, expertise lies in tackling complex data projects. Ability to interpret data effectively and build BI solutions that drive significant business growth. Developed a real-time data processing system that greatly enhanced efficiency and decision-making capabilities.

Client :The Coca Cola Company: Power BI Developer Roles & Responsibilities :

The Coca Cola Company is an American multinational corporation founded in 1892. It is best known for its flagship product, Coca Cola, a sweetened carbonated beverage that has become a cultural icon in the

United States and a global symbol of American tastes. The company's mission is to "refresh the world and make a difference," and it operates in more than 200 countries and territories.

Coca Cola offers a wide range of beverage products, including soft drinks, water, juices, and energy drinks.

• Extracting data from different Kind of source systems into Power query and then cleansing the data by applying business rules and loading it into Power Pivot.

• Building the relationships between the various dimension and fact tables in power pivot.

· Involved in creating power BI reports in Direct Query Mode.

· Create the Calculated columns and measures with the use of DAX Expressions.

· Involved in creating data visualizations like Bar charts, Tree Maps, Line charts, Scatter plot, Mapping Visualization etc. with Power BI

· Accessed and used various Custom Visuals available in Power BI

· Sharing of Power BI reports and managing workspaces in Power BI service.

· Accessed various data sources to pull data for reporting and analysis

· Creating PowerApps page to get inputs for RLS mapping sheet.

· Creating flow to make event-based refresh.

• Creating calculated measures And columns with DAX in Power Pivot.

• Developed custom report tool tips for different reports to showcase the multiple data points in one report.

• Used Table, Matrix, Bar, Card, Gauge, Slicers and Line charts visualizations.

• Creating Database objects - tables, views, functions and developing procedures for implementing application functionality at the database side for performance improvement.

• Responsible for building the reports and deploy into Power BI Service.

• Responsible for building dashboards in Power BI service.

• Published reports into Power BI publisher and schedule the data sets.

• Sharing the Dashboards to end users.