Rajkumar Sukumaran
Sydney,Australia
Summary
Senior Business Analyst experienced in data migration, integration, and warehousing, driving deployment of applications and system solutions through thorough analysis and testing of business requirements. Delivered impactful decisions through data analysis, process improvement, and stakeholder engagement while fostering team collaboration and adaptability to changing needs. Demonstrated ability to translate complex data into actionable insights, consistently achieving results across projects.
Overview
1
1
Certification
22
22
years of professional experience
Work History
Senior Data Business Analyst (Pulse to HSI Donesafe Safety Platform Data Migration Program and System uplift program)
Woolworths
Sydney, NSW, Australia
01.2024 - Current
- Executed end-to-end data discovery across the enterprise to catalogue existing health and safety information, ensuring all data assets were mapped to specific business use cases.
- Collaborated with business stakeholders to identify the Business requirements for data migration and define the data migration approach from current safety system Pulse to the target Safety system HSI Donesafe.
- Coordinated with insurance vendors GIO and DXC and IT team in defining data requirements for processing insurance claims.
- Mitigated data privacy risks through the systematic discovery and classification of PII, creating a centralized data inventory to support regulatory audits.
- Increased system scalability by identifying and removing redundant data, which led to a significant improvement in claims processing.
- Collaborated with technical teams to design and implement data solutions using SQL in Big Query.
- Analyse complex datasets to identify trends and help prevent injuries at Woolworths stores.
- Detected data quality issues at source and cleaning of data to ensure the quality and accuracy of data before migrating to Target System.
- Define data retention and disposal policies for Group’s data assets based on company policies.
- Partnered with SMEs to document comprehensive SOPs for the new health and safety system, ensuring alignment with Woolworths group’s regulatory standards.
- Collaborated with stakeholders to translate complex datasets into high-impact dashboards, replacing manual reporting processes with automated visual narratives.
- Orchestrated source-to-target data mapping for health and Safety data migration, maintaining 99.9% data integrity.
- Coordinated with testing team in defining test cases and acceptance criteria.
Senior Data Business Analyst (WFC to UKG Pro migration of People Management Data and system uplift)
Woolworths
Sydney, NSW, Australia
09.2023 - Current
- Collaborated with business to identify requirements for data migration scope.
- Analyzed source data structure and quality to prepare data for migration.
- Work with IT integration team to define transformation logic to transform source data (Time & Attendance, Rostering & Scheduling and Volume forecasting) to target format.
- Defined scenarios for business validation testing in collaboration with business.
- Work with change manager in defining data migration steps in Production Run-Sheet and ensure steps are executed accurately for production cutover.
Senior Data Business Analyst (Digital Hub Grants Management Program capability uplift)
Department of Education
Sydney, NSW, Australia
07.2023 - 12.2023
- Led the system uplift of the Early Childhood Education (ECE) Grants management system by identifying critical gaps and documenting requirements for a scalable, human-centric digital solution to meet the department’s growing needs.
- Identified data assets to enhance data management strategies., Classification of PII and Non-PII data, complete access policies, set up SLA requirements and set up end to end Data Governance Framework for the new digital solution.
- Identify and finalize data fields from source systems that are required to cater needs of digital Hub and documenting data fields in data dictionary.
- Document key non-functional requirements, including data retention and disposal policies, to ensure compliance and alignment with project goals.
- Research and evaluate potential software vendors to collect data in collaboration with procurement and IT teams.
- Prepare process mapping and source to Target mapping of data fields.
- Facilitate program increment planning with senior managers and stakeholders to align project deliverables with strategic objectives and ensure stakeholder engagement.
- Perform impact analysis of the project, identify, raise and manage delivery risk.
Senior Technical Business Analyst (CBB EPC FY2023 Data remediation Program to address data quality issues identified in the Master product list maintained in MDM STIBO)
Westpac
Sydney, NSW, Australia
12.2022 - 07.2023
- Identified gaps in data availability (Master product list) and proposed recommendations to address data quality and product granularity issues, enhancing integration with downstream systems.
- Conducted investigations to find practical solutions for data granularity issues in the Master product list, facilitating better integration with downstream systems.
- Managing 3rd party vendors, external developers and stakeholders throughout solution design and development.
- Facilitate various Agile processes with Scrum Master such as Iteration / Release Planning, Backlog Refinement, Retrospective, and Sprint Review.
- Confirm data requirements documented and create source to target system data mappings to support data initiatives.
- Performed comprehensive data profiling and cleansing to ensure 100% data integrity, identifying and resolving anomalies before data migration.
- Work with security consultant in setting up the data governance policies and act as data SME of data technology professionals.
- Review and approval of functional specifications and technical design documentation to confirm alignment to business requirements.
- Translating functional requirements and business logic / rules into user stories for execution by developers.
- Managed requirements traceability throughout all planning project phases, ensuring alignment with business objectives.
- Manage dry run data migration activities before the go-live.
- Lead data team in updating data model to reflect new changes.
- Work with data team in setting up ETL framework and prepare data for migration by performing data cleansing and transforming using ETL tool Alteryx.
- Work with data team in setting up reconciliation framework to reconcile data before and after migration.
- Set up monthly data reporting using SSRS tool and transition to BAU with proper documentation.
Senior Technical Business Analyst (Hubble Data integration program)
ASX
Sydney, NSW, Australia
04.2022 - 12.2022
- Developed user stories and acceptance criteria for data services integrating Kafka messages with data store.
- Analyzed business requirements to create technical specifications for seamless integration of applications sourcing data.
- Writing non-functional requirements like Performance, Scalability, Supportability, Capacity etc for Data services that inject and persist trading data in data store.
- Writing user stories and acceptance criteria for data services that fetch data from Kafka messages and write into data store.
- Re-pointing ETLs to fetch trading data from newly created tables in data store.
- Conduct and facilitate requirements gathering workshops with both business and technical stakeholder.
- Presenting user stories to Product owners, Business and IT stakeholders and seek approval.
- Facilitated 3 amigos sessions with developers and testers to clarify user stories, address queries, and obtain estimates.
Business Analyst (Data Management Capability and Controls DMCC)
Westpac
Sydney, NSW, Australia
04.2022 - 04.2022
- Identified and documented risk controls and lineage to clarify critical data element (CDE) requirements.
- Analyzed data lineage for critical data elements (CDE) and documented business data flow (BDF) in MS PowerPoint.
- Work with risk groups to deep dive into controls analysis, completeness, risk assessments and compliance.
- Analysing Data Lineage for critical data elements (CDE) and documenting the business data flow (BDF) using MS PowerPoint.
- Tracked data lineage to identify potential risks in critical data elements., assessing associated data risk associate with the CDE in data flow.
- Collaborated with finance, risk, and business stakeholders to define and assess data requirements and address data control gaps.
Technical Business Analyst / Data Analyst (Migration of data from Excel spreadsheet to Enterprise Product Catalogue (STIBO MDM) to address risk and limitation of bank’s product data management capability)
Westpac
Sydney, NSW, Australia
01.2021 - 01.2022
- Defining scope and requirements for migrating product data (Mortgage, credit card and home loan) from Excel spreadsheet to banks Master Data Management system.
- Understanding the data requirements for the Banks Mortgages, Credit cards and Home loan division and proposing data solutions for better reporting.
- Creating BRD, writing user stories for the sprint
- Data profiling, validating, filtering, and cleaning of data to ensure the quality and accuracy of data.
- Create source to target system data mappings to support data initiatives.
- Conducted root cause analysis of data quality issues, designing actionable plans to remediate identified gaps.
- Performing technical reconciliation between source data and data uploaded into MDM (STIBO).
- Sending monthly reports to business and stakeholders using SQL Server reporting tool (SSRS) and Power BI.
- Manage and coordinate processes to ensure all critical business functionality is tested, delivered, and accepted by key stakeholders
- Advised stakeholders on strategies to enhance efficiency and reliability of data products and services.
- Developing ETL framework using Alteryx to bring in data consistency and data have an end-to-end data lineage.
Data Analyst (SMARTS Data migration from IDC to Refinitiv)
Nasdaq
Sydney, NSW, Australia
10.2019 - 12.2020
- Managed stakeholder expectations by updating on project status, risks, and providing actionable insights and recommendations.
- Identify areas of improvement in current data pipeline and present the findings to senior managers.
- Cleansing and pre-processing and transformation of Data using Nasdaq’s inbuilt ETL tool before feeding them into Nasdaq’s trade surveillance tool SMARTS.
- Facilitate workshops with the business to understand requirements
- Developing business requirements documents and other project artefacts
- As project manager, manage vendor to deliver quality service, identify and communicate any potential risk to stakeholders and thereby manage stakeholder expectation.
- Identify, analyze, and interpret trends in trading data and draw conclusions on market trading pattern based on the findings.
- Identified and analyzed areas for improvement in data pipeline, presenting findings to senior managers to inform decision-making.
- Ensure data management practices are conducted in line with Regulator, Audit and Risk expectations.
Technical Business Analyst (Clearing and Settlement)
Deutsche Bank
Sydney, NSW, Australia
09.2017 - 09.2019
- Extracting, manipulating, and analysing data using Perl to provide insights and recommendations in a format suitable for presentation to seniors.
- Extracted, manipulated, and analysed data using Perl to deliver actionable insights and recommendations for senior stakeholders.
- Prepare documents showing logical data models, data mappings and data flow diagrams.
- Identified strategic opportunities for improving As-IS processes and collaborated with development team on data-driven decisions, including alternative methods and technologies.
- Coordinated with product owner, development, and testing teams throughout development, UAT, and go-live phases to ensure project alignment and successful delivery.
- Handling any post release business queries raised by production support team.
Technical Business Analyst (Market Risk Management)
UOB
Singapore, Singapore
03.2015 - 05.2017
- Interpreted and analyzed data, suggesting actionable steps to enhance data quality for development team in Agile environment.
- Created Risk Visualisation Dashboard using Tableau for Risk Managers to analyse VaR Trends.
- Extracted and pre-processed trading data from different front end trading platforms using Perl and Python before feeding data into banks Risk System.
- Extracted and pre-processed trading data from various front-end trading platforms using Perl and Python, ensuring accurate input into bank's risk system.
- Management of projects end to end, from briefing with stakeholders to gather requirements, data extraction, manipulation and analysis, to providing insights and recommendations and assisting on UAT.
- Work with data stewards to ensure data is handled securely within internal and external teams.
- Present impact of current business processes on users and stakeholders from data analysis and recommendations in a clear way for business to action and evaluate potential areas for improvement.
- Work with data stewards to ensure data is handled securely with in internal and external teams.
- Interpret and Analyse Data and suggest steps to improve data quality to development team in Agile environment.
Technical Business Analyst (Market Risk Management)
Barclays Capital
Singapore, Singapore
02.2011 - 03.2015
- Gathered business requirements and worked with solution architect to built system to process data from different trading systems and enrich them before entering banks' Risk Engine.
- Collaborated with market risk engineers and risk managers to document comprehensive SOPs for new digital risk management system, ensuring alignment with operational needs.
- Analyse, and interpret trends or patterns in trading data using excel and banks inbuilt tools to draw conclusion and alert trading desk when breaches are identified.
- Draw insights and conclusions about trading activity from sudden spikes or skewed data and suggest solutions for improvement.
- Gathered and documented requirements to maintain historical trading data in banks data warehouse and use this data to produce insights on Var Trends.
- Gathered and documented requirements to maintain historical trading data in banks' data warehouse and use this data to produce insights on Var Trends.
- Analyse, and interpret trends or patterns in trading data using excel and banks inbuilt tools to draw conclusions and alert trading desk when breaches are identified.
- Mapped current business and operational processes, providing actionable recommendations for improvement to enhance overall efficiency.
Application Support Manager (Market Risk Management)
Barclays Capital
Singapore, Singapore
11.2009 - 02.2011
- Managed a 4-member team providing 2nd level support to Market Risk VaR and Limit monitoring system dealing with asset classes like FX, FI (Fixed Income), Equities, Money Markets and OTC Derivatives.
- Monitored loading of trade data onto Risk Application for any errors and performance using Splunk.
- Decreased system errors through discovery of redundant data within database, which led to significant reduction in batch processing time.
- Developed bug fixes and enhancements for existing market risk applications.
- Collaborated with vendor and key stakeholders to establish service level agreements for deliverables.
- Provided documentation on SOD and SOW checks to L1 team to ensure availability of the market risk system.
- Conducted root cause analysis of issues, coordinating with internal teams and vendors to implement necessary corrective actions.
- Ensure availability of market risk system at all times and any loss of service is restored in a timely manner.
- Performed root cause analysis of issues and ensured necessary steps are taken internally as well as vendors and teams outside of the risk system.
- Decreased system errors through discovery of redundant data within the database, which led to significant reduction in batch processing time.
Application Support Analyst (Market Risk Management)
UBS AG
Singapore, Singapore
12.2006 - 11.2009
- Supported and enhanced bank’s risk management system to generate accurate VaR and P&L reports.
- Monitor batches and alert trading desks and senior management of potential risk and changes after significant events.
- Reported market risk exposure to local and functional managers, ensuring timely awareness of risk status.
- Developed scripts in Perl to check for upstream feed quality and alert L2 team via email, thus reducing the manual effort by support team.
- Developed scripts using Perl, which could query the oracle database and generate reports showing positional data and setting them to run from jobs.
- Provided weekend coverage and worked closely with developers and infrastructure teams to ensure successful roll out of market risk releases into production.
Application Developer
Tech Mahindra Limited
Mumbai, Maharashtra, India
11.2004 - 11.2006
- Gathered and defined customer requirements, developing organized project plans aligned with specifications.
- Enhanced Telecom giant BT’s system to capture network traffic and display online statistics in real time to customers.
- Developed Real Time Monitoring system on Linux using Perl, writing data to Oracle Database and displaying real-time statistics via Apache for BT.
Education
Master of Technology - Information Technology
National University of Singapore
Singapore, Singapore01.2016
Bachelor of Technology - Information Technology
Cochin University of Science and Technology
Kochi, India01.2004
Skills
- Data analysis
- Data mapping
- Data cleansing
- Data Profiling
- Requirements gathering
- Use Cases Modelling
- Financial analysis
- Transaction analysis
- Data governance
- Risk assessment
- Agile and Waterfall models
- Gap analysis
- Process mapping
- Process improvement
- Workflow Analysis
- KPI tracking
- Quality assurance
- Data validation
- SQL and databases
- Database management
- Data and analytics
- Data visualization tools
- JIRA, Confluence
- Investment banking
- Database systems
- Test case scenarios
Certification
- Scrum Alliance certified Scrum Master
- ITIL v3 Foundation certified professional.
Interests
Loves playing tennis and keeping fit during leisure time
Trainings
- Applied Machine Learning with BigQuery on Google Cloud Platform – by Cloud guru
- Google Certified Associate Cloud Engineer 2019 – by Cloud guru
Timeline
Senior Data Business Analyst (Pulse to HSI Donesafe Safety Platform Data Migration Program and System uplift program)
Woolworths
01.2024 - Current
Senior Data Business Analyst (WFC to UKG Pro migration of People Management Data and system uplift)
Woolworths
09.2023 - Current
Senior Data Business Analyst (Digital Hub Grants Management Program capability uplift)
Department of Education
07.2023 - 12.2023
Senior Technical Business Analyst (CBB EPC FY2023 Data remediation Program to address data quality issues identified in the Master product list maintained in MDM STIBO)
Westpac
12.2022 - 07.2023
Senior Technical Business Analyst (Hubble Data integration program)
ASX
04.2022 - 12.2022
Business Analyst (Data Management Capability and Controls DMCC)
Westpac
04.2022 - 04.2022
Technical Business Analyst / Data Analyst (Migration of data from Excel spreadsheet to Enterprise Product Catalogue (STIBO MDM) to address risk and limitation of bank’s product data management capability)
Westpac
01.2021 - 01.2022
Data Analyst (SMARTS Data migration from IDC to Refinitiv)
Nasdaq
10.2019 - 12.2020
Technical Business Analyst (Clearing and Settlement)
Deutsche Bank
09.2017 - 09.2019
Technical Business Analyst (Market Risk Management)
UOB
03.2015 - 05.2017
Technical Business Analyst (Market Risk Management)
Barclays Capital
02.2011 - 03.2015
Application Support Manager (Market Risk Management)
Barclays Capital
11.2009 - 02.2011
Application Support Analyst (Market Risk Management)
UBS AG
12.2006 - 11.2009
Application Developer
Tech Mahindra Limited
11.2004 - 11.2006
Bachelor of Technology - Information Technology
Cochin University of Science and Technology
Master of Technology - Information Technology
National University of Singapore