Business Intelligence Developer

• Nov 2020 - Present

Business System Analyst | BI Developer

• Aug 2019 - Aug 2020

Project Delivered: 1) Vital Sign (Power BI Reports and Dashboards Project)Description: Vital Sign is the transition of old reporting methodologies and systems (SQL Server, SSRS and Excel) to current tools and platforms (Hadoop Data lake and Power BI). A certified dataset has been created in Hadoop data lake with the help of Impala, Hive, and Hue. Using these certified datasets, the Power BI dashboard has been developed.Achievements: Designed and develop Vital Sign dashboard which captured the top 20 company KPI’s represent the operational health of the business. 2) Ecosima Modernization:Description: Ecosima datasheet is used to supports restaurant capacity and route optimization initiatives. The current datasheet was developed 12 years ago with the help of Excel Macros. The current architecture was very complicated and contains a lot of complex code. Few processes in the current solution are broken and need to be done manually. Achievements: Recreated Excel data-sheet in the required format to feed to CAT software used to calculate restaurant capacity and route optimization initiatives. This Ecosima datasheet is built with TSQL as it is easy to maintain going forward and aligns with Martin Brower new BI reporting strategies and future architecture. Projects Technologies: SQL Server 2016, SQL Server Management studio, SSRS, MS Visual Studio 2017, Hadoop Data lake, Impala, Hive, Hue, Azure SQL Database, Azure Data Factory (ADF) and Azure Data Lake Storage (ADLS)Stakeholders: Managing Director, Strategy Director, Field Service Consultants, National Operations Support Analyst, Reginal Infrastructure Manager, Operational Support Manager, External vendors, IT Department

Report Developer/Business Intelligence Specialist

• Jan 2018 - Aug 2019

1) Project: Vacancy to Re-occupancy (V2ROC) project -April 2019- Current The Vacancy to Re-occupancy (V2ROC) project is being implemented in Uniting Retirement and Independent Living (R&IL) business and will deliver a reduction in the average number of days taken from vacancy to a new resident occupying a vacated unit from 341 days to the industry average of 194 days, resulting in a tangible financial benefit of $2.7 million per annum. Involved in designing and developing Tabular cube and Power BI reports/dashboard as part of new integrated system solution.2)Project: Hybrid cloud ETL migration Project - Jan 2019-March 2019 Hybrid cloud ETL migration Project is part of Hybrid cloud migration Project. This project moved Uniting on-premises SharePoint sites to online.Identified and modified all SSIS Packages and Power BI reports that currently access on premises SharePoint list directly.Performed end to end testing by running ETL in UAT or SIT environment.3)Project: Worksmart Dynamics: Jan 2018-Dec 2018 Involved with Datawarehouse and reporting team in an agile development framework to deliver an integrated system that will upgrade uniting existing AX 2009 finance, procurement & billing systems to Microsoft Dynamics 365 for Finance and Operations.Responsible for working with the Business stakeholders and DXC Eclipse functional consultants to identify report requirements for MS Dynamics 365 in an Azure cloud-based environment. Also Analyzing production, staging databases along with Datawarehouse and create environment for New ERP Microsoft Dynamics 365 for Finance and Operations by writing complex TSQL scripts, developing and enhancing SSIS Packages, Multiterminal Tabular Modelling, DAX, Management Reporter, SSRS and Power BI Reports.

Business Intelligence Developer

• May 2017 - Dec 2017

Database /BI Reports: Developed an in-depth understanding of underlying data, data structures and supported the BI Department in the design, development, testing and support of complex operational, Financial and analytical reports and dashboards. > Identified business reporting requirements, worked with stake holders to develop the new reports in Microsoft BI platform. > Performed design and analysis for a reporting solution to measure care home KPIs against Bupa’s operating model. > Running data extracts for users using TSQL on Ad-hoc bases. Creating custom SQL to provide detailed results. > Successfully delivered 20 formatted reports with a series of automation process by using TSQL, SSRS, Agent Jobs and SharePoint on time all in 2-month delivery cycles. >Managed complicated reporting projects few examples are Clinical and Operational KPI Dashboard: A dashboard which captures different operational and clinical KPI’s.Appointment Reminder System: This system shows total no of days until patient appointment is overdue.Managed BI Portal:  >Created repository, users and groups, assigned rights to users and groups. . >Created standard and data driven subscription for reports distribution.Support: Monitored the Bupa Service Management suit queue for any requests or incidents assigned to BI Department and Resolved tickets posted by service deskMonitoring and Processing Data: . >Received monthly data for Focus Scorecard KPI’s from different departments and processed this data into data warehouse with the help of SQL server import wizard and SSIS packages and published these KPI’s on company BI portal. >Monitored jobs which have been created in Data Governor to orchestrate the data extraction on a daily basis and take necessary actions if these jobs failed. Documentation: Prepare and updated documentation i.e. BI Report catalogue, Monthly scorecard processing document, How to process weekly survey files

Business Intelligence Developer

• Oct 2015 - Apr 2016

Cirrus Media is Australia's leading B2B media and publishing company located in Sydney. The project involved Data Migration for New Business Entity using their own migration methodology. I was part of the DWH team in an agile development framework. My key roles was analyzed production, staging databases along with data warehouse and create environment for New Business Entity by writing complex TSQL scripts, developing and enhancing SSRS reports, and SSIS Packages.• Managed and maintained a complex data warehouse and business intelligence system (comprising of facts and dimensions) to facilitate business stakeholders to analyze current and historical data to take effective and informed decisions. • Seamless integration of new systems and maintenance of legacy code. • Managed version control and ensured version tracking is maintained.• Managed and monitored BI server activities residing in AWS. • Ensured up time of Report Server. Project: Data Migration for new Business EntityBusiness Stakeholders: Management, ClientsResponsibilities Before doing any migration, by using the various functions of log shipping backup, copy and restore the database to different kind of servers. Developed documentation of all components and processes for future maintenance. Created numerous simple to complex queries involving joins, self joins, store procedures, correlated sub queries and CTE’s techniques for diverse business requirements. Identified and modified the data warehouse with proper fact and dimensions.  Created, identified and modified SSIS packages required.  Created, identified, modified and configured SSRS reports i.e. based on the page view and click through data reports were created for displaying the number of visitors to different product and items like email, inquiries and publications.  Created new repository in TFS for version controlling of the SSIS packages and SSRS report

Business Intelligence Developer

• May 2013 - Jun 2015

* Gathered and analysed user requirements, converted requirements to specifications, designed, implemented, tested and deployed solution* Maintained a data warehouse and business intelligence system to facilitate business stakeholders to analyse current and historical data to take effective and informed decisions* Maintained complex data warehouse system comprising five large cubes.* Using SSRS, developed new and enhanced existing reports using TSQL and complex MDX using multiple cubes, tables, charts, dashboards* Managed security control for users, roles and groups in SSRS.* Uploaded SQL Server Reporting Services (SSRS) RDL files to SQL Server.* Using SSIS, maintained data uploads from internal and external sources.* Developed and implemented the SQL Server Integration Services (SSIS) packages to populate the data into the Enterprise Data Warehouse from various sources like Flat File, Excel spreadsheet and access into OLEDB Destination (SQL Server)* Using SSAS developed cube for analytical analysis consisting of facts and dimensions like sector, client, time and geography * Maintained SQL server environment relevant to the warehouse system.* Design and Develop Data Model by importing Data into Excel from different data sources, Extended Data model relationships using Excel, Power Pivot and DAX. Created Powerview reports from these data model.  Developed documentation of all components and processes for future maintenance

Business Intelligence Specialist

• Sep 2011 - Oct 2012

Work with business users both internal and external to refine their requirements to develop prototype views and build complex reports and dashboards using different business intelligence platforms. Work with business users both internal and external to refine their requirements to develop prototype views and build complex reports and dashboards using different business intelligence platforms.

Regional Report Designer

• Jun 2009 - Aug 2011

Worked closely with business analyst, data modeler and other report developers to design Business Intelligence and operational reporting solutions.

Account Officer/Technical Support

• Jun 2006 - Jun 2009

Support accounting department with miscellaneous technical projects and assignments.