JAYALATHA MANUBROLU
Leppington,Australia
Summary
Highly motivated professional with a growth mindset and exceptional attention to detail, expressing interest in the Data & Reporting Analyst role. Over 14 years of experience in data analytics, visualization, and end-to-end data-driven solutions, resulting in a deep understanding of the industry. Passionate about assisting businesses and individuals in achieving goals through user-friendly technology that eliminates friction. Excited to leverage expertise to contribute to organization's success.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Data Analyst and PowerBI Developer
Westpac Banking Corporation
03.2022 - 05.2024
- Company Overview: Data Analytics and PowerBI Developer role focused on end-to-end data analytical discovery and advanced dashboard reporting
- Performed end-to-end data analytical discovery for integration, Normalization, transformations and data aggregations in Palantir Foundry Cloud Environment using Restful API data connections in Palantir Foundry, Python, Pyspark, SQL and Contour
- Automated data transformations using PySpark and SQL to eliminate manual process, data optimizations and performance tuning
- Developed data transformation pipelines and maintain medallion architecture of Raw, Clean and Reference datasets in Palantir
- Created advanced and complex PowerBI dashboards with rich calculations using DAX, bookmarks with action buttons, row level security and set up alerts using Power Automate to facilitate decision making
- Built data model star schema in Power BI Desktop
- Integrated heterogeneous sources of data from Palantir Foundry Cloud Platform, SQL Server, Sharepoint and Excel
- Worked on complex data models with 50Million+ records datasets
- Improved performance of the dashboards maintaining year long history
- Collaborated with stakeholders to translate business requirements into technical specifications
- End to end thorough data testing to confirm the solution is furnishing the requirements and meeting the expectations
- Mentored reporting teams to share best practices and enhance their technical skills and growth
- Data Analytics and PowerBI Developer role focused on end-to-end data analytical discovery and advanced dashboard reporting
- Projects: Critical Protective Control(CPC): May 2023- May 2024 - Automation of CPC Monthly Report, ISSP, ISG Cyber security - automated the effectiveness of controls and services for the Head of CPC
- CPC Workload Analytics, ISSP, ISG Cyber security (Jul 2023 - Aug 2023) - developed a PowerBI reporting for the Head of CPC to visualize and track the workload by the services managed by the team covering data from Enterprise Jira, and ServiceNow - Incidents, Problems, Changes, Change Tasks, Requests, SCTasks and Vulnerability Items
- Cloud Events Visibility & Integration (CEVI) : Jul 2022 - Apr 2023 - leveraged PowerBI tool to create a dashboard for ISSP(Information Security Services Portfolio) Project Managers to display the corresponding Microsoft service costs of estimated data volume based on the input number of onboarded machines and per device usage
- Cloud Security Controls Assurance (CSCA), ISSP, ISG Cyber security - delivered a security governance capability uplift to improve visibility into the Group's use of cloud services for the Head of SP&R(Security Policy & Reporting) to ensure it is not inadvertently changed, leading to the potential disclosure of sensitive information
- Data Protection Reporting: Mar 2022 to Jun 2022 - leveraged the group wide PowerBI dashboard used by the BCMs(Business Control Managers) across the Westpac Group to support People Leaders and business teams in securing their data
Analyst
Department Of Posts, India
05.2010 - 02.2022
- Company Overview: Department of Posts (DoP) for an end-to-end IT modernization program aimed at equipping India Post with modern technologies and systems
- Analyzed customer insurance claims and prepared investigation reports to higher management in PowerBI
- Used SQL to extract and report on insurance data from McCamish source systems
- Analyzed insurance claims request and investigated the genuineness of the claim based on facts
- Assisted Legal cell teams in investigating the customer cases by providing necessary data from the source systems using SQL which is very critical for the reputation of the organization
- Prepared budget allocations for 13 divisions and prepared forecast annual reports at divisional level to submit to the higher management
- Extracted data from SAP source using SAP ABAP and prepared children education allowance, medical allowance, vehicle allowance reports for the higher management
- On boarded employees data into payroll database which is automated the manual processing of generating paychecks
- Enhanced appraisal process using SQL to update salary increments of the employees based on the yearly incremental allowances provided
- Developed interactive reports using PowerBI and prepared presentations for higher authorities
- Implemented dashboards using all advanced PowerBI concepts such as star schema data model design, dynamic UI functionality using bookmarks and data grouping
- Written complex calculations using DAX
- Created HR data dashboard using PowerBI
- Worked closely with the partnered vendor team to automate the employees service data in the payroll application
- Department of Posts (DoP) for an end-to-end IT modernization program aimed at equipping India Post with modern technologies and systems
- Projects: Fraud Analysis MIS Reporting: May 2018 to Feb 2022
- Financial Planning Analyst: May 2014 to Apr 2018
- Analyst: May 2010 to Apr 2014
Education
B. Tech - Electronics & communications Engineering
Jawaharlal Nehru Technological University
Skills
- PySpark
- SQL
- SAP ABAP
- PowerBI
- Power Automate
- Data flows
- Power Apps
- Tableau
- Code Repositories
- Code Workbooks
- Contour in Palantir Foundry
- JIRA
- Confluence
- Excel
Certification
Microsoft Certified Power BI Data Analyst Associate, 09/02/24, 09/03/25
Sampledashboards
Available upon request
References
Available upon request
Training
- Power Automate, Microsoft, 02/29/24
- PL-300 training, Microsoft through Westpac cloud alliance, 08/15/23
- Advanced PowerBI training, Udemy, 02/01/22
Honours
- GEM (Great Employee Moments) awards, Westpac, Team recognition (Performing), Exceptional work in developing Network Security dashboard using Power BI, 05/14/24, Individual recognition (Helpful), Demonstrating capabilities of PowerBI in an internal developer training session, 03/22/24, Team recognition (Performing), Developing, testing, and visualizing the Data Classification Reporting, 10/27/23, Team recognition (Leading Change), Finding the best solutions in the most efficient way, 12/22/22
- Appreciations, Department of Posts, India, Numerous appreciations from the Postmaster General (PMG), For submitting the budget proposals on time and preparing budget allocations to Divisions, Numerous appreciations from the Postmaster General (PMG), For creating dashboards with more meaningful insights using PowerBI
Timeline
Data Analyst and PowerBI Developer
Westpac Banking Corporation
03.2022 - 05.2024
Analyst
Department Of Posts, India
05.2010 - 02.2022
B. Tech - Electronics & communications Engineering
Jawaharlal Nehru Technological University
Similar Profiles
JIA LUJIA LU
Personal Banker at Westpac Banking Corporation Carlingford branchPersonal Banker at Westpac Banking Corporation Carlingford branch
Susan JacksonSusan Jackson
HR Administrator at Westpac Banking CorporationHR Administrator at Westpac Banking Corporation
Renee TedfordRenee Tedford
Engagement Lead for Learning Services at Westpac Banking CorporationEngagement Lead for Learning Services at Westpac Banking Corporation
Cindy TranCindy Tran
Credit Assessor at Westpac Banking CorporationCredit Assessor at Westpac Banking Corporation
Aaron VoraboudAaron Voraboud
Business Development Manager at Nibav Home LiftsBusiness Development Manager at Nibav Home Lifts