Summary
Overview
Work History
Education
Skills
Certification
Milestone Projects
Technical Skill Summary
Timeline
Generic

Subba Papireddy

Sydney,NSW

Summary

15 Years of professional experience in Information Technology industry. In-depth, hands-on knowledge of Business Analysis, ETL, Data warehousing / Business Intelligence. Worked with cross-functional teams to understand business objectives and translate them into technical requirements. Proficient in gathering, documenting, and analyzing business requirements and Skilled in data analysis and interpretation to provide valuable insights for decision-making. Experience in process mapping and As-Is & To-be. Competent in creating clear and comprehensive business requirement documents (BRDs) and functional requirement documents (FRDs). Worked on PI planning for project deliverables and resource / budget requirements. Continuous learner keeping track of new and cutting edge concepts/technologies. Dependable team player with excellent relationship building skills. Experience with Agile development technologies, methodologies and practices. Seasoned Business Analyst offering [Number] years of [Industry] industry success. Expert on business and systems requirements, user acceptance testing and end-user training. Accomplished at leveraging past lessons to inform future decision-making.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Senior Business Analyst

Westpac
12.2021 - 12.2023
  • SRDE is an SAS-based platform that provides a holistic solution to source, conform, enrich and aggregate data for Group Credit Risk
  • The use cases are primarily analytics, reporting and model execution
  • It also enables manual inputs to adjust for sourcing issues and fine-tune calculation results
  • SRDE is owned by Data Platforms, which is embarking on a journey to provide Westpac with a robust, efficient, cost-effective environment using concepts such as data mesh and data product with an integrated platform for data pipeline, data model and analytics framework, known as Data Driven Experience Platform (DDEP)
  • The Chief Technology Office (CTO) has also provided a future roadmap highlighting the Target State Architecture (TSA) for Group Credit Risk
  • Part of the goal is to migrate from SAS ETL to a model environment that provides better capability.

Business/Data Analyst

NSW Department of Communities and Justice
02.2020 - 11.2021
  • As part of FACS (Family and community services), this project assists with the enhancements and maintenance of the tracking of the health and support of the children wellbeing
  • This is achieved through a Sales force application called “Child Story” which provided a seamless and end to end view of each and every activity of a case logged
  • This is primarily accessed and updated by front line case workers who work hand in hand with the Data Management team who continuously work with them to ensure the forms is relevant as well as ensure the data integrity of these cases.

Business/Data Analyst- Data warehousing

Icare NSW
04.2019 - 12.2019
  • Enhancement and maintenance of the Data warehouse application’s data architecture, solution engineering and production delivery in support of icare Enterprise Data warehouse operations like claims management, reviews and audits, data privacy and metadata management
  • Identify and drive opportunities for performance improvements and automation in line with organizations overall goal of simply and improve.

Business/Data Analyst

ING
07.2018 - 03.2019
  • EFS (Economic and Financial Statistics) project is to build a framework to generate reports for APRA as per government regulations
  • Identifying the data elements that can be used from data warehouse and find the gap for missing elements
  • Third-party tool OneSumX is used to generate report.

ETL Integration Lead - Data warehousing

Rabobank
03.2018 - 06.2018
  • Develop data model, data marts and Integration rules to support Business objects reporting
  • Using agile project delivery, plan the development activities and deliver the data integration solutions
  • Merging of two different source data systems and provide singular view for reporting
  • Develop Informatica mapping and reusable mapplets for data integration.

Data Integration Lead

AstraZeneca
04.2015 - 12.2017
  • CRM Integration Platform provides an end-to-end integration framework that integrates systems of the local Business Units (BU) of BI with Veeva CRM System, i.e
  • System such as customer master, ERP, digital content and sales/call activity data
  • Create Informatica Mapping/Sessions/Workflow to load data to Veeva (SFDC)
  • Implemented incremental loading and error handling logic
  • MD5 encoding on non-key columns to implement CDC (Change data capture)
  • Various transformations are used to develop mappings like source qualifier, joiner, connected lookup, dynamic lookup, unconnected lookup, normalizer, filter, router, update strategy, sorter, and aggregator.

Education

Bachelors of Engineering- Information Technology -

JNT University
12.2006

Skills

  • Data Mining
  • Quality Assurance
  • Product Management
  • Trend Data Analysis

Certification

Certified ScrumMaster (CSM), https://bcert.me/scfgjznme

Milestone Projects

  • Westpac (Risk And Regulatory) – SRDE (Strategic Risk Data Environment), 2021-23, Westpac have their risk models and reports to support their Basel 3 APRA regulatory requirements. To support these models a lot of business rules to be applied on data and sourced to the models. Risk customer management is implemented to access the risk associated to banks’ lending. SRDE is an SASbased platform that provides a holistic solution to source, conform, enrich and aggregate data for Group Credit Risk.
  • NSW Department of Communities and Justice (Transformational), 2019-21, ChildStory project was a major transformation journey that the FACS embarked on aimed at internal process improvement and significant technology upgrade. This involved establishing and implementing ChildStory application build on salesforce and Migration of data from legacy systems.
  • NSW icare (Data Migration), 2019-19, General lines project is to build icare Enterprise Data warehouse and it is a road map to build data lake. Implement all the validation rules for the claims process and build daily reports using qlik sense reporting tool.
  • ING (Regulatory), 2018-19, Incorporation and implementation of necessary data migration for EFS (Economic and Financial Statistics) reporting for APRA, using existing data warehouse. This encompassed data gap analysis, sourcing of additional sources/attributes, establishment/modification of distribution within the warehouse which was one among the Authorized data sources (ADS) within the bank acting as the single sourcing point of customer data.

Technical Skill Summary

Tools, Project Management Methodologies, Databases, Project Management Tools, Technology, Oracle, Teradata, SQL Server, Big data, SDLC- Waterfall, Agile, JIRA, Confluence, HP Quality Center, Salesforce, Informatica, SAS, MuleSoft, AWS, Azure

Timeline

Senior Business Analyst

Westpac
12.2021 - 12.2023

Business/Data Analyst

NSW Department of Communities and Justice
02.2020 - 11.2021

Business/Data Analyst- Data warehousing

Icare NSW
04.2019 - 12.2019

Business/Data Analyst

ING
07.2018 - 03.2019

ETL Integration Lead - Data warehousing

Rabobank
03.2018 - 06.2018

Data Integration Lead

AstraZeneca
04.2015 - 12.2017

Bachelors of Engineering- Information Technology -

JNT University
Subba Papireddy