Environment: MS Power BI, Power BI Pro, SQL, Windows 10.

Description: Liberty Latin America (NASDAQ: LILA and LILAK, OTC Link: LILAB) is a leading telecommunications company operating in over 20 countries across Latin America and the Caribbean under the consumer brands VTR, LCPR,LLA,CWC

Roles & Responsibilities:

• Using SQL and Share point as data source imported data to Power BI Desktop and performed Data conversions and Data cleansing in Power Query like using Append Query, Merge Query, Table Extend, remove null and replace with empty space etc.…
• Creating relationships as per the requirement in Data Model and using standard visuals like Table, Matrix etc., created interactive reports in Power BI.
• Created calculated columns, measures and tables using DAX expressions as per the requirement
• Implement RLS( Row Level Security) in Power BI Desktop
• Have gone through Formatting options of various visuals like Conditional Formatting, Field Formatting, Selection Controls, Icons, and Filters.
• Publish into Power BI service and Create Workspaces

Environment: MS Power BI, Power BI Pro, SQL, SSMS, Snow flake.

Description: Greif is a global leader in industrial packaging products and services and is pursuing its vision: In industrial packaging, be the best performing customer Service Company in the world

Roles & Responsibilities:

• Using Snowflake data source create datasets and published into service and connect that source using Power BI Desktop.
• Creating relationships as per the requirement in Data Model and using standard visuals like Bar Charts, Pie Chart, Donut, Scatter Chart, Waterfall Chart Slicers, Cards, Multi Card, Table, Matrix etc., created interactive reports in Power BI.
• Created calculated columns, measures and tables using DAX expressions as per the requirement
• Have gone through Formatting options of various visuals like Conditional Formatting, Field Formatting, Selection Controls, Icons, and Filters.
• Develop Power BI reports & Effective dashboards after gathering and translating end user requirement.
• Created Buttons for reset and added Bookmarks, Selection Pane and updated.
• Implemented RLS as per the requirement and shared report access to the users accordingly.
• Published Report to Power BI Service and shared to various users who exists on Power BI Service.
• Installing Power BI gateways and Schedule Power BI reports.
• Identified complex bug in data modelling and fixed it by creating Power BI table using values function and relating it as per the business requirement.
• Documenting every report that has been developed.
• Create Forecast reports for feature analysis

Environment: Microsoft Power BI, Tableau, Tableau Server 9.3, SQL Server 2012, Excel, CSV

Roles & Responsibilities:

• Designed and documented the entire Architecture of Power BI Poc.
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Used various sources to pull data into Power BI such as MS Sql Server, Excel, and CSV.
• Implemented RLS by creating roles in Manage Roles and assigned roles to users on Power BI Service as per the requirements.
• Develop Power BI reports & Effective dashboards after gathering and translating end user requirement.
• Experience in resolving the client tickets.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked and delivered all types of Report/Dashboards such as Insurance, Re-Insurance, Corporate, A&H.
• Worked on all types of transformations that are available in Power BI query editor.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Designed and created data extracts, supporting POWER BI or other visualization tools reporting applications.
• Created Reports using Charts like Pie-Chart, Donut, Bar Chart, Word Cloud, Multi Row Card, Card, Map, Hear Map, Table, Matrix, Scatter Chart, Line Chart, Slicers etc.,.
• Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.
• Created Drill Down Reports, Drill Through Report by Region.