Peter Malath

• Gathers stakeholder needs to produce business and technical requirements.
• Develop Healthcare report in SSRS/Report builder and build weekly/monthly subscription, as well as pulling raw data for quick answers.
• Consistently attended meetings with Client subject matter experts to acquire functional business requirements to build SQL queries that would be used in dashboards to satisfy business's needs.
• Responsible for developing provisioning reports for various groups and upper management, reducing reports production time by 20%.
• Collaborates effectively with teammates and business leaders influencing outcomes through effective verbal and written communication skills including planning and facilitation, developing compelling senior-level presentations and other highly visible communications.

•Designed and built dashboards out of power BI, and report Builder to monitor business performance, and compile, integrate, and analyze data from multiple sources to identify trends, expose new opportunities, and answer ongoing business questions.
•Worked with team of Data Analysts and Business Analysts, Build, customize and publish interactive reports and visualizations in Power BI
•Demonstrated translating question into visualization which provides insight and answers question.
•Develop ad-hoc analytics and reporting based on analysis of existing data sources, utilizing variety of tools (Power BI, Report Builder) reflecting global real estate markets and operations of real estate assets for Latin America and North America.

• Wrote complex SQL Queries, Stored Procedure, Triggers, Views & Indexes using DML, DDL commands and user defined functions to implement the business logic.
• Attending onsite discovery sessions to help clients' requirements, assist in design of suggested solution for client's Iridium BI
  •This includes implementing SQL data warehouse and Iridium BI, Implemented, and developed SSRS dashboards and decreased report return time by 45%.
• Maintained positive communication and working relationships with all business levels. Coordinating with onshore/offshore & stakeholder's team for task clarification, fixes and review.
• Reviewed, analyzed and implemented necessary changes in appropriate areas to enhance and improve existing systems.

•Leveraged power BI to optimize visibility of key operation metrics.
•Devised power BI reporting solution that increased efficiency in report generation by 45%.
•Automated regular data extraction, reporting in 25%-time expenditure reduction.
•Published Power BI Reports in required originations and made Power BI Dashboards available to Web clients.
•Explore data in variety of ways and across multiple visualizations using Power BI
•Used Power BI Gateways to keep dashboards and reports up to date.
•Published reports and dashboards using Power BI
•Automated Power Query refresh using power shell script and windows task scheduler.
•Wrote calculated columns, Measures queries in power bi desktop to show good data analysis techniques.
•Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily
•Worked on all types of transformations that are available in Power BI query editor.
•Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Power BI
•Develop data structures and pipelines in Azure Data Factory and SSIS to organize, collect, cleanse, and standardize data to generate insights and addresses reporting needs.
•Identify and troubleshoots data integration and integrity issues in cooperation with appropriate CBRE business units, Designs workflows and procedures.

•Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required
•Created Reports using Charts, Gauges, Tables, matrix.
•Created Parameterized Report, Dashboard Report, Linked report, Sub Report by Year, Quarter, Month, & Week
•Created Drill Down Reports, Drill Through Report by Region
•Defined best practices for Power BI report development.
•Used Power BI PRO to publish content to other workspaces, share dashboards, subscribe to dashboards and reports.
•Create Stored procedures and other one-off request SQL codes to extract data in SQL Server and export in excel (pivot tables, pivot chart) in preference of SMEs.
•Validate, and deploy created SSRS reports, as well as creating dashboards in Sisense (BI) for Marketing, Finance teams and Directors.
•Produced these reports to support nine agency locations for Finance, Clinical Directors, and VPs to have different levels of dashboard self-service access.
•Provide data analysis support to healthcare providers by developing reports and/or dashboards to monitor program and operational performance.
•Identified trends and opportunities for growth by analyzing complex data sets and presenting data to management doing YOY to compare performance overtime.

•Created, maintained, and modified SSRS reports, and Casino Marketplace Systems
•Created prizes, promotions, and tag codes within Player Tracking System for both Video Gaming Devices and Table Games
•Developed and maintained enterprise Applications using Microsoft stack, with emphasis on power BI, Power Apps and Power automate.
•Created and revised Power BI dashboards in line with data model, increasing efficiency by 20%.
•Tracked revenue and expense accounting for special events, promotions, Preferred Players Club, VIP Parties, direct mail, and entertainment programs, and worked with marketing vendors regarding print, design, and email projects.
•Social Media Manager in promoting and analyzing content through social advertising, including social media, while monitoring monthly budgets against return on investment and competitors