Selina Yang

selinayanganlan722@gmail.com

Experienced Data Analyst with 5 years of experience in end-to-end delivery of large-scale data-driven customer remediations across Commonwealth Bank, Westpac, and Macquarie Bank. Produced proof of concepts and prototyping, while contributing to developing BI reports and dashboards at NSW Health and NSW Transport.

Liaised with non-technical stakeholders such as Chief Operating Officer, Managing Directors, Executive Directors, Remediation Managers, Marketing Managers, Product Managers, and Client Development Managers. Maintained strong trusted relationships with Data Analytics Managers, Business Analysts, and other Data Analysts.

Passionate about using Microsoft Power Platforms and Robotic Process Automation (RPA) to automate repetitive tasks. Well-known for reliability and consistently delivering with a strong growth mindset attitude.

CV  /  LinkedIn  /  GitHub  /  Tableau Public

• Executed complex data extraction, transformation, and calculation on pricing and billing discrepancies for customer remediations, ensuring compliance with regulatory standards and reducing potential revenue leakage.

• Developed and delivered data-driven insights using Tableau for various payment products in Global Transactions Services (GTS), driving a 12% improvement in product performance metrics, enabling product managers to monitor key performance indicators, and enhancing decision-making processes and client engagement, resulting in increased revenue and operational efficiency.

• Collaborated with non-technical stakeholders across Product and Client Engagement, analysing and transforming large amounts of data to resolve business challenges, resulting in the delivery of actionable information that improved client satisfaction by 20%.

• Scoped and designed data analysis methodologies tailored to specific customer remediations, reducing quality assurance turnaround time by 25%.

• Spearheaded an automation of a manual client onboarding process using SharePoint, Power Apps, and Power Automate, resulting in a 40% reduction in manual efforts.

• Provided operational support and maintenance for various data products supporting all modes of NSW Transport, ensuring continuous and efficient data flow.

• Conducted timetable validation for Bus, Light Rail, and Metro, monitoring data for school/non-school terms, event routes, and trackwork, ensuring data accuracy and reliability.

• Automated the manual timetable validation process using Azure, Power BI, Power Apps, and Power Automate, streamlining the validation process and reducing manual efforts.

• Proactively followed up with non-technical stakeholders such as Contract Managers and Operators to resolve timetable data issues and other trip-related queries.

• Performed daily operations health checks that include monitoring real time feed of Bus, Light Rail, and Metro in internal data systems and third-party apps.

• Logged tickets with vendors, operators, and relevant team members upon issue notification, streamlining issue resolution.

• Deployed accurate and clean data utilizing SAS and Teradata SQL for Business Lending BAU Remediations, ensuring precise analysis and decision-making.

• Collaborated with Remediation Owners and non-technical stakeholders from Product, Marketing, Compliance, Legal, and Tax to align data analysis with business needs.

• Facilitated fortnightly Sprints involving Executive Managers, Senior Remediation Managers, Senior Change Managers, Data Testers, and Senior Data Analysts, ensuring seamless project progression.

• Incorporated advanced SAS and SQL skills to analyse and rectify incorrect charges, such as Loan Service Fees and Bank Guarantees, resulting in customer satisfaction.

• Led cross-functional discussions and meetings to translate technical data insights into actionable recommendations for improving remediation processes.

• Developed detailed performance reports, highlighting the impact of remediation efforts, and showcasing quantifiable improvements to internal stakeholders.

• Engaged with Commonwealth Bank and Macquarie Bank, leading large-scale regulatory-committed business remediations involving system double charge and fee rate discrepancy issues.

• Expertly translated complex business requirements related to customer eligibility rules into efficient technical solutions using Teradata SQL and DBeaver.

• Coordinated in working group meetings, contributing insights and expertise to discussions involving Partners, Directors, Associate Directors, Managers, and Senior Consultants.

• Led the data analysis phase of regulatory remediation projects, ensuring accurate identification and resolution of system double charge discrepancies and fee rate issues.

• Streamlined across departments to ensure effective coordination and communication, facilitating alignment on remediation strategies and project objectives.

• Advised technical guidance and consultation to cross-functional teams, enabling the successful implementation of remediation solutions and meeting regulatory commitments.

• Implemented data validation processes, identifying, and resolving discrepancies that led to a 30% reduction in data errors.

• Conducted regular data audits, ensuring data accuracy and compliance with privacy regulations.

• Transformed Sybase SQL in SAP to T-SQL in Microsoft SQL Server, facilitating a smooth transition from SAP Business Objects to Power BI.

• Liaised with stakeholders, developers, and product owners to identify data points and departmental data requirements, reducing redundancy by 15% and improving project alignment.

• Operated daily Scrum meetings, converting business requirements into technical proposals on Azure DevOps, leading to a 10% enhancement in project delivery timelines.

• Communicated technical aspects, challenges, and rollout plans to non-technical stakeholders, fostering understanding and satisfaction.

• Created and monitored a comprehensive KPI Matrix in Power BI, integrating data for different departments, resulting in a 20% increase in data-driven decision-making accuracy.

• Presented data-driven insights to executive stakeholders, resulting in strategic decisions that led to a 10% increase in profitability within a fiscal quarter.

• Revamped data governance policies and procedures, leading to a 25% reduction in data duplication.

• Enhanced HR processes (onboarding, learning and development, performance evaluation, and exit process) by 50% by developing Power BI dashboards, resulting in streamlined operations and efficiency.

• Guided 2 junior interns in identifying HR process improvements and automating repetitive tasks using Power Automate, achieving a reduction of over 10 hours of HR time per week.

• Designed an HR management app using Power Apps, leading to an efficiency gain of over 80% and a substantial increase in employee engagement.

• Formulated business requirements and executed data migration from Microsoft Dynamics 365 to HubSpot, facilitating seamless data transfer and enabling business processes.

• Liaised closely with the Data Analyst team to facilitate data migration and integrate external data sources, ensuring a comprehensive and accurate data set for analysis.

• Certificate: Special Chairman Award  /  Most Valuable Professional  /  Making a Difference

• Analysed performance insights based on onboarding and first-month data for a cohort of over 40 new hires each month.

• Transformed data collection processes by transitioning from paper-based attendance forms and assessments to efficient digital spreadsheets, streamlining analysis and reporting procedures.

• Orchestrated end-to-end training and onboarding programs for a total of 150+ new hires, collaborating closely with senior management, fellow trainers, and other stakeholders.

• Ensured seamless training delivery, fostering an engaging and informative onboarding experience for new hires.

• Analysed large data sets to extract actionable insights and trends, contributing to informed business decisions.

• Conducted comprehensive analysis of lending records and approvals, translating complex financial data into actionable insights for Personal Loan Managers.

• Prepared strategic guidance to managers by presenting data-driven insights and facilitating informed decision-making in the lending process.

• Demonstrated a keen eye for risk assessment by identifying potential risks within commercial lending and evaluating over 500 credit applications to ensure sound financial decisions.

• Collaborated closely with cross-functional teams to facilitate essential IT processes, including data backup and documentation, to enhance operational efficiency in Commercial Lending.

• Developed and maintained dashboards to track KPIs, providing real-time visibility into business performance.

Business Analysis

Analysed Teo Taxi's business strategy, business model, value proposition, challenges and ecosystem. (Presentation Slides)

• Identified Telsa's key challenges in Australia. (Presentation Slides  /  Report)

• Provided recommendations on Telsa's positioning, targeting and marketing programs (price, product, place and promotion) after conducting a factor analysis using SPSS. (Presentation Slides  /  Report)

• Created a perceptual map using Python by cleaning and transforming the data collected from a designed survey. (GitHub)

Profiled the data and came up with inferences and analysis for predicting the overall star rating for the businesses in Yelp. (Certificate of Achievement  /  SQL Query  /  GitHub)

Designed ACURA (Acquire, Cross-sell, Up-sell, Retention and Advocacy) strategies for the key CRM issues and opportunities of Raiz's 2 key customer segments after Exploratory Data Analysis in Tableau. (Presentation Slides  /  Report)

Developed a business plan of how to attract Indian Med-tech/Health-tech companies to establish their businesses in Australia by background research and data analysis. (Presentation Slides)

Initiated a 12-month marketing strategy plan for Trac-Car’s Waste to Energy technology, conducted business requirement analysis, background research, risk and financial assessment, and presented recommendations to 3 business stakeholders including the CEO. (Certificate of Achievement)

Advised on how to improve Qantas’ 300-flight network after Visual Data Analysis in Tableau and statistical network analysis in Gephi (network analysis software), resulting in a potential revenue increase by 10%. (Report)

Devised a proposal that includes requirements analysis, user story, use case, BPMN, data structure (ERD) and system architecture for an IT system that aims to give customers optimal door-to-door mobility service options and seamless combinations with the option to plan, book and pay. (Presentation Slides  /  Report)

Proposed 2 potential recommendations on how Flight Centre Travel Group could expand into China successfully by analysing their internal strategy and capabilities and evaluating opportunities and threats in the external environment. (Presentation Slides  /  Report)

Data Visualization

With data from the Australian Prudential Regulation Authority (APRA), identified the causes and impacts of the decrease in insurance uptake since June 2015 for a provider of acute private care. (Data Source  /  Problem Statement  /  Power BI Report)

• Identified the trends of orders, products and customers by generating complex SQL queries and visualizing data in Power BI for specific business questions. (Power BI Report  /  SQL Query  /  GitHub)

• Optimized discount rate to increase sales using Python. (GitHub)

Investigated why different countries experience so vastly different death rates by processing the COVID-19 data from GitHub, gathering other relevant data and conducting data analysis in Tableau. (Tableau Dashboard  /  Report)

Attended the Inter-University Tableau Competition sponsored by Tableau, presented the insights of COVID-19 & Financial Impacts after gathering data from various sources and processing data in Python. Selected as one of the Top 10 finalists. (Tableau Dashboard)

Data Science

Automated web scraping of multi-page Amazon Best Sellers in Books into a dataframe. (GitHub)

• Investigated the contents of the live tweets of Supercars racing, examined the impact on online user engagement and TV rating, and provided recommendations to Supercars' management. (Presentation Slides  /  Report  /  GitHub)

• Regression Analysis, Topic Modelling, Sentiment Analysis

Produced a summary for the definition of "Machine Learning" from Wikipedia using NLP techniques. (GitHub)

• Provided recommendations on how to improve Sydney Swans' business performance by investigating their fans' love and its impact based on the data collected from a questionnaire and the results from 4 supervised learning models. (Report  /  GitHub)

• Logit Model, Random Forests, Gradient Boosting, Support Vector Machine (SVM)

• Developed 3 recommender systems for the movie provider IMDb. (GitHub)

• Popularity-based Recommender, Content-based Recommender, Collaborative Filtering Recommender

• Predicted the nightly prices of Airbnb listings by 5 supervised learning models. Ranked 9th out of 73 in the Kaggle competition. (Kaggle Leaderboard  /  Report  /  GitHub)

• Decision Tree, Random Forest, XGBoost, AdaBoost, Stacking

• Forecasted the daily confirmed cases of COVID-19 of a country given its historical daily confirmed cases by 6 predictive models. (Report  /  GitHub)

• Drift, Seasonal Naive, Holt-Winters Smoothing (Multiplicative), Seasonal ARIMA, Feed Forward Neural Networks (FNN), Forecast Combination

• Categorised the questions in Quora into 20 topics using NLP techniques. (GitHub)

• LDA (with bag of words), NMF (with TF-IDF)

• Predicted whether the product of an online clothing retailer will be recommended based on customer reviews and other numerical product features. (Report  /  GitHub)

• Logistic Regression

Problem-Solving / Leadership

Joined the LPC program held by The University of Sydney Business School, led a team of 5 to choose "Women in Executive Leadership" as the critical challenge and design an action plan that includes political, economic, commercial, community and personal aspects. Selected as one of the Top 7 finalists. (Presentation Slides  /  Certificate of Achievement)

Given "Women in Executive Leadership" as a challenge in the organisation, led a team of 5 to pitch a solution that would be implemented to the board. (Presentation Slides)

Attended the hackathon held by ACS foundation, worked with other industry professionals in a team of 5, built a companion bot within 48 hours, a solution for the mental health problem, one of the complex challenges brought by COVID-19. Selected as one of the Top 8 finalists. (Demostration Video  /  Presentation Slides  /  GitHub)

Handed out 2 full trays of rosemary sprigs on Anzac Day as a symbol of remembrance, which helped raise generous public donations in support of veterans and commemorative efforts.

Helped at the St.George Foundation Ball by welcoming guests, distributing name tags, selling raffle tickets, creating a warm and organised guest experience and supporting the event’s fundraising efforts.

Assisted with clothing selection, packing, and selling, contributing to female customers' professional development and self-confidence by providing good-quality work-appropriate attire.

Collaborated with a team of 14 to support the Sea Turtle Conservation Centre by feeding 100+ sea turtles and maintaining hatching pools, enhancing animal welfare and habitat cleanliness. Developed a labour division strategy based on time and resource efficiency, resulting in smoother daily operations for the Conservation Centre. (Volunteer Certificate)

Provided individualised psychological support to 5 autistic children through emotional encouragement and companionship, fostering improved social interaction, self-confidence, and emotional well-being. (Volunteer Certificate)

Communication

Agile

Stakeholder Management

Excel

Power BI

SQL

Power Automate

Azure

AWS

Web Development

Web Counter     unique visitors since Feb 2021

© Selina Yang

(Theme Courtesy: Jon Barron)