Data and Analytics Manager

• Jul 2022 - Present

Manager - Data Engineering

• Mar 2022 - Jul 2022

• Consult for various clients in a variety of domains with Data Engineering and Data Analytics needs. • Primary responsibilities include integrate, transform, and consolidate data from various structured and unstructured data systems into structures that are suitable for building analytics solutions.. • Expertise with tools like Azure Data Factory and Azure Synapse Analytics in building meta data driven ETL / ELTL Pipelines to move data from different sources like SQL DB, Blob Storage etc.,. • Create dimensional model for reporting systems by identifying required dimensions and facts. • Experience with SQL Server and T-SQL in constructing temporary tables, table variables, triggers, user functions, views and stored procedures. • Functional domain experience in Finance, Education and Mining. • Experience with Docker and Deployment to the cloud - Azure. Show less

Reporting Manager

• Jul 2019 - Mar 2022

• Managed, developed and coached a team of analysts who provide analytics, reports and scorecard management for the contact centre through MS Business Intelligence tools (SSRS, Microsoft Mobile Report).• Developed bespoke data engineering solutions using python to perform ETL / ELTL functions from various data sources to a common data model for reporting purposes.• Improved and reviewed of reporting capabilities and processes within Allianz and align with best practice approach• Worked with business users and other stake holders to understand business processes and translate them into functional and technical specifications for BI solutions.• Provided support to internal control teams on risk and compliance activities and build automated controls and reports to support their function. Show less

Senior Performance Analyst

• Mar 2017 - Jul 2019

• Converted and improved existing legacy excel reports to a more automated and scalable BI solution (SSRS) with clear documentation . This included reverse engineering the logic were no documentation was available.• Implemented Data Engineering solution using Python and SQL to generate the standard data model for reporting.• Built new reports to measure operational performance for the contact centre with a wide variety of call queues and sales channels.• Performed in-depth analysis of data to identify service agreement gaps and suggest measures to improve performance• Built key business stakeholder relationships to ensure clear understanding of business requirements, business benefits, budget and delivery timelines.• Reduced the time taken to produce daily reporting in the team by half with the use of Python to automate the ETL process. Show less

Business and Reporting Analyst

• Oct 2015 - Mar 2017

• Data mining and analysis, provided reporting to all parts of the business, clients and subcontractors utilizing SSRS and PowerBI • Built reporting and dashboards solutions for sub-contractors performance management using SSRS and PowerBI • Liaised with technical leads and business stakeholders by being the primary point-of-contact for all project-related activities • Developed Dashboards and ad-hoc reports using MS Power BI and SSRS for senior management team for analysis. • Wrote calculated columns, measure queries using DAX in powerBI Show less

Application & System Analyst

• Apr 2013 - Oct 2015

• Designed and implemented of business processes in the area of Workforce Management and Enterprise Mobility • Built miscellaneous web based applications as required by the business using various technologies like php, JavaScript, Joomla and SSIS • Provided device management and first level support for 400 field technicians. • Designed and implemented of business processes in the area of Workforce Management and Enterprise Mobility • Built miscellaneous web based applications as required by the business using various technologies like php, JavaScript, Joomla and SSIS • Provided device management and first level support for 400 field technicians.

System Administrator

• Nov 2010 - Sep 2011

Responsibilities • Development of multiple software modules in an Adobe Flex solution • Provided Level 1 Support for office workers and photographers across Australia • Configured and maintained Windows Servers as well as designed and implemented a Microsoft Active Directory. • Responsible for coordinating and managing activities of offshore project teams • Prepared user manuals and documentation for different modules of an automation project Accomplishments: • Gained first working experience by successfully implementing software and IT infrastructure solutions Show less