Project Details: 3. Project: Title : Pfizer Environment : MS Excel, Power BI, Microsoft SQL Server Role : Power Bi Developer Description: Pfizer-BioNTech COVID-19 Vaccine is a monovalent COVID-19 vaccine that is authorized for emergency use to prevent COVID-19 as the first two dose of the three-dose primary series for children 6 months through 4years of age. A two-dose primary series for individuals 5years of age and older. A third primary series dose for individuals 5years of age and older who have been determined to have certain kinds of immunocompromised. Responsibilities: ✓ Gathered reports requirement; collaborated with the business users using mock-ups ✓ Utilized complex SQL join statements to represent relationship between facts and dimensions ✓ Organized dashboards in Power BI to analyse monthly targets across organization ✓ Structured the dashboard with a consistent layout with visuals chart at the top and bottom ✓ Customized the tooltips and labels, to user understandable format, the numerical measure was changed to its ✓ appropriate formats like representing the revenue, expense and margins as currency values ✓ Computed margins using calculated field following pre-defined business rules ✓ Modelled all the dashboards with appropriate filters for comprehensive analysis by portfolio, application and Page 3 of 4 Kishore 2. Project: Title : Energy Sales and Trading Environment : MS Excel, Power BI, Microsoft SQL Server Role : Power Bi Developer Description: Uniper Energy Sales offers individual electricity and natural gas supplies for industrial Customers and energy partners such as municipal utilities or regional suppliers. We supply customers throughout Germany and also in neighbouring countries. The range of services extends from standard products such as timetable deliveries to individual supply concepts that are tailored to the special needs of our customers. Responsibilities: ✓ Involved discussion with business users and provide technical guidance for Power Bi Desktop and Power BI Service. ✓ Interacting with design & analysis team to understand business requirement and complexity of Reports. ✓ Created different types of reports using Power BI desktop, like vertical and cross tab reports and dashboards. ✓ Created reports types of reports using Power BI desktop which includes drillings, sorts etc. ✓ Driving calls with Clients to update the progress of project activity. ✓ Created filters and applied conditional formatting based on the user requirement. ✓ Created charts like Lines, Pies, Scatter, Tree Map, Slicer, Bar Chart, Funnel Chart etc. ✓ Created Measures and columns in Power BI Desktop. ✓ Created scheduling the reports using Data Gateway. ✓ Ensure timely delivery & quality of delivery by adhering to Quality Process.