SAI Greeshma Malla
Kellyville,NSW
Summary
IT Professional with 7 years of experience in Data/ Technical Business Analysis where I specialise in applying statistical techniques, data mining methods, and visualization tools to analyse data sets and uncover meaningful insights. I have the strong ability to bridge the gap between Technical and Business stakeholders by communicating effectively and facilitating collaboration. I have a good understanding of software development life cycles and working in Agile methodology.
Overview
7
7
years of professional experience
Work History
Data Analyst /Power BI Developer
ORIX Australia Corporation Limited
01.2023 - Current
- Residual Value Prediction & Power BI Dashboard Creation)
- Produced monthly reports using advanced Excel spreadsheet functions.
- Worked on create views and tables from database to crate power Bi dashboards and reports.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Identified, analyzed and interpreted trends or patterns in complex data sets.
- Collaborate with stakeholders to identify business needs and requirements for creating dashboards for visualization reporting using Power BI
- Developed and maintained project documentation for 12 dashboards created as part of the project serving as blueprint for developers using confluence
- Extensively analysed large data sets from 5 different data sources by executing SQL queries to understand the technicalities for Meaning insights and better translation with stakeholders
- Working on complex SQL queries involving joining multiple tables, filtering databases on multiple criteria and aggregating data to create summary reports
- Bases on the data extracted from SQL querying working on identifying and solving problems related to data quality and accuracy and completeness
- Worked in Python and Power BI to build reporting and Visualization solution to help test the business forecast files and validate them before they can be used to drive decisions
- Worked on reports Predicting growth and progression by applying formulas using Data
- Analysis Expression (DAX) queries
- Reassuring with stakeholder to make sure data reported in the dashboards is accurate, reliable and timely
Business owner
Amma Pindi Vantalu
03.2019 - Current
- An Indian Sweet startup established in Australia catering to customers across Australia
- Managed the digital portal, order processing, resource allocation, procurement, shipment, and logistics
- Performing business review and planning new product releases and marketing
- Created PowerBI reports to track the order and inventory connecting to snowflake database
- Write ad-hoc SQL queries to perform analysis on portal data
- Bookkeeping for accounting and taxations
Data Analyst/Developer
Resolution Life, RLA
11.2021 - 12.2022
- (Snowflake Migration Project)
- Worked on migrating the daily and monthly PAS feeds from hyperscale to snowflake
- Good understanding of PAS data load, data quality rules in Informatica IICS that are critical to the operation of RLA
- Built Informatica IICS Mass Ingestion Jobs to bulk load data from hyperscale to snowflake for initial data load
- Analyzed IICS task flows and converted IICS Mappings/Mapplets/Task flows as part of the hyperscale to snowflake migration
- Migrated the field mappings and expression logics and joins as required wherever there are compatibility issues from hyperscale to snowflake
- Performed source file validations to staging layer to Make sure that files are loaded as per the expected sequence
- Based on the transformations applied on the data, as part of data quality testing checked all the veiled records are processed to conformed layer and then to
- Consumption layer on the bases of validation rules embedded per PAS
- Worked on creation of test cases as part of regression to make sure that data loaded post the code conversion from hyperscale to snowflake is consistent and all the records are loaded as per the business expectations as part of Data Quality checks
- Reconciliation of results hyperscale vs snowflake to make sure the data is accurate and documented the results as part of Business Readiness testing
- Identifying data formats and patterns to create schemas, views, tables and performing data type transformation to suite Snowflake Database
- Creating Test cases and Performing unit testing for the IICS components modified
- Assisted Operation team with Extended Support to preform PAS Catch Up
- Document details around identified data issues (current state), proposed remediation recommendations and the detailed rationale for each
- Engaging with business SME’s, solution architects to understand the business requirements
- Collaborated with business-unit leaders to identify and prioritize problems.
- Tested data prediction algorithms based on historical data.
- Creating relevant confluence pages for the IICS Component Build/test
- Supporting in planning, designing, and development of business processes
- Providing recommendations in enhancing and expediting business activities
- Conducting clients' meetings, understanding, and integrating their business needs into technology
- Analyzed transactions to build logical business intelligence model for real-time reporting needs.
- Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
Technical Business Analyst
Blackbaud Pacific
04.2017 - 03.2019
- A Software company that sells CRM application to non-profitable organisation
- Performed research and provided valuable inputs in data management process for
- NetSuite
- Assisted in the development of market research analysis
- Performed data cleansing which was necessary for few of the predictive models by accessing information from multiple customers in NetSuite
- Collaborated with Data Analysts, Data Developers and project managers during my tenure
- Supported data gathering and analysis of data
- Participated in data quality control and validation
- Examined user operations inquiries and outlined business specifications
- Managed projects within our project management system and interfaces with team members on final approval for campaign elements
- Played a key role as a functional expert during client requirements gathering
Business Analyst
Samsung Australia Pty Ltd
03.2016 - 04.2017
- Supporting in planning, designing, and development of business processes
- Providing recommendations in enhancing and expediting business activities
- Conducting clients' meetings, understanding, and integrating their business needs into technology
- Developing test procedures, test plans, and test cases for clients
- Analysed and coordinated data scoping, collation, validation, and formatting processes required for a successful data preparation
- Conducted Gap Analysis and developed data relationships diagrams to define the impact of the new requirements on the existing system
- ACCOMPLISHMENTS
Education
Bachelor of Science - Information Systems and Business Analysis
Macquarie University
Sydney, NSW2022
Skills
- SKILLS
- Data Analysis
- Data Migration
- Requirement Gathering
- Stakeholder Management
- Confluence and Jira
- Technical Documentation
- Communication Skills
- Advanced Excel
- Python
- BPMN Tools
- Snowflake
- Power BI
- Basic Linux
- SQL Server Management Studio
- Informatica (IICS) (ETL)
- NetSuite (CRM System)
- Task Capture (UiPath)
Timeline
Data Analyst /Power BI Developer
ORIX Australia Corporation Limited
01.2023 - Current
Data Analyst/Developer
Resolution Life, RLA
11.2021 - 12.2022
Business owner
Amma Pindi Vantalu
03.2019 - Current
Technical Business Analyst
Blackbaud Pacific
04.2017 - 03.2019
Business Analyst
Samsung Australia Pty Ltd
03.2016 - 04.2017
Bachelor of Science - Information Systems and Business Analysis
Macquarie University
Similar Profiles
Eric WongEric Wong
Fleet Credit Analyst at Orix Australia Corporation Pty LtdFleet Credit Analyst at Orix Australia Corporation Pty Ltd
JUSTIN L. NOBLADOJUSTIN L. NOBLADO
Dealer Relationship Manager at Orix Metro Leasing and Finance CorporationDealer Relationship Manager at Orix Metro Leasing and Finance Corporation
ALFREDO ESPIRITUALFREDO ESPIRITU
Fleet Service Advisor Supervisor at ORIX RENTAL CORPORATIONFleet Service Advisor Supervisor at ORIX RENTAL CORPORATION