Summary
Overview
Work History
Education
Skills
Timeline
ResearchAssistant

Neelam Goyal

Doonside,NSW

Summary

Personable business professional bringing successful 10+years career in financial roles within large and fast-paced corporations. Release-planning specialist trained in advanced Report Development/Data & Technical Analysis. Highly analytical and detailed with documented track record in full software development life cycle (SDLC) methodologies and Agile techniques. Enthusiastic Data/Technical Analyst & Report Developer and dedicated employee with integrity, strong work ethic.

Overview

16
16
years of professional experience

Work History

Data Remediation Analyst

Westpac Bank
03.2022 - Current
  • Working as Data analyst in Rapid Assessment Team to deliver consumer banking remediation with in average timeline of 40 business days.
  • I have worked on 9 CRO's on products such as Mortgages, Personal Loan, Credit cards, Saving Account submitted between March 2022-April 2023.
  • Working closely with SME's from business, data stewards and Product Owners to assist with resolving data remediation issues.
  • Providing data analytics support using multiple data sources to resolve complex issues for assigned incidents and many of which have regulatory commitments.
  • Understanding of incident/business problem and design data rules scripts required to identify impacted products, accounts and customers and their financial impact assessment.
  • Develop advanced techniques and methods to ensure data accuracy, timeliness, and integration with current technology and make recommendations for improving processes, data quality, and incident correction.
  • Proactively takes part in Data Analyst community across Remediation team to share technical knowledge and work among like-minded colleagues to use consistent approach for standard scripts.
  • Proven ability to learn quickly and adapt to new situations. Communicate any changes or recommendations to management for approval by presenting analytical outcomes at group meetings, workshops, and staff meetings.
  • Document data/calculation rules for QA team to perform checks and provide data extracts to Tax/Marketing/Finance team to seek their approval for impacted customers and ensure documents can be audited.
  • It is my job to conduct peer reviews to identify defects as soon as possible, making rectification quicker and ensuring greater code standards and uniformity across team. Peer reviews also provide me chance to pick up tips from my peers.

Technical Business Analyst

Commonwealth Bank
06.2021 - 03.2022
  • Identified needed business improvements and determined appropriate systems required to implement solutions
  • Provided hands-on troubleshooting for issues at multiple scales, from individual systems to multi-site infrastructure
  • Gathered, reviewed and reported on findings
  • Developed flowcharts and diagrams to describe and lay out logical operational steps
  • Worked in agile development environment
  • All managed in Jira
  • Routinely develop complex SQL queries and stored procedures to support reporting needs of internal customers
  • Providing support to Report Development team to handle and fix production issues on request
  • Perform regressive report testing to make sure developed solution met business requirements.

Business Intelligence Reporting Analyst

Commonwealth Bank
11.2014 - 06.2021
  • Developed and modified programs to meet customer requirements
  • Mapped data between source systems and warehouses
  • Completed quality reviews for designs, codes, test plans and documentation methods
  • Performed systems and data analysis using variety of computer languages and procedures
  • Worked in agile development environment with rapid development methods, conduct development, code review, testing and short deployment cycles, all managed in Jira
  • Proved successful working within tight deadlines and fast-paced atmosphere
  • Extensive experience working on Teradata and SQL server platform
  • Build complex reporting dashboards and drill-down capabilities for Business using SSRS reporting tool
  • Also developed and rendered monthly, weekly, and daily reports as per requirement
  • Experience pulling data from Teradata to Microsoft SQL Server using SSIS and internal ETL application for the reports
  • Ability to identify and work within a multitude of data sources with the additional ability to structure data validation to ensure data integrity
  • Use Team Foundation Version Control and GitHub for source control
  • Worked flexible hours; night, weekend, and holiday shifts
  • Exceeded goals through effective task prioritization and great work ethic.

SSRS Report Developer

Tribal Group
08.2014 - 11.2014
  • Designed and developed a full-scale reporting solution for Student Management System for NSW Schools using MS SQL Server 2008 and MS SSRS 2008/2005
  • Created, implemented and maintained a reporting suite while also customizing many reports to meet individual client needs
  • Created drill down, drill through, sub and linked reports using MS SSRS 2008 as well as managed the subscription of the reports
  • Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports; thus, making them user friendly
  • Assembled and converted user requirements from multiple clients into our standard reporting solution and customized specific client requests when necessary
  • Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS
  • Provided MS SSRS 2008 training to clients in order for them to develop their own ad-hoc reports
  • Developments are progressed adopting an agile approach using daily scrums, 2 weekly sprints using Agile Master Shell (AMS) tool
  • Working experience with Version Control System to release the changes into the builds
  • Offered friendly and efficient service to customers, handled challenging situations with ease
  • Used coordination and planning skills to achieve results according to schedule.

Programmer/Reporting Analyst

RESIMAC
05.2012 - 11.2013
  • Arranged analysis reports and be accountable to answer any queries, complaints or proposal
  • Provided support to staff and students to help out with their enquiries
  • Worked with Virtual machines, Linux and Window Active Directory to set up new user accounts permissions and passwords
  • Setting up Remote Desktop connections
  • Working knowledge of installation, configuration and troubleshooting
  • Incident Management experience
  • Good understanding of its principles, including MS Active Domain Knowledge, MS Office, MS Window 7 networking, including Wireless and IP telephony
  • Good understanding of PC and Peripherals and their interdependences.

IT Support Specialist

Melbourne Institute Of Technology
08.2009 - 09.2010
  • Arranged analysis reports and be accountable to answer any queries, complaints or proposal
  • Provided support to staff and students to help out with their enquiries
  • Worked with Virtual machines, Linux and Window Active Directory to set up new user accounts permissions and passwords
  • Setting up Remote Desktop connections
  • Working knowledge of installation, configuration and troubleshooting
  • Incident Management experience
  • Good understanding of its principles, including MS Active Domain Knowledge, MS Office, MS Window 7 networking, including Wireless and IP telephony
  • Good understanding of PC and Peripherals and their interdependences.

Software Developer

Duke Fashions Ltd
01.2007 - 03.2009
  • Designed and developed Oracle forms & reports
  • Performed modifications on existing form as per change request and maintained it
  • Worked on SQL
  • Loader to load data from flat files obtained from various facilities every day
  • Supported existing clients and resolved critical issues/problems in a timely fashion
  • Involved in the development of D2K and C# project with in targeted completion dates with accuracy and consistency
  • Create and maintain complex reports in MS SQL data sources using Reporting Services, MS Excel and other virtualization tools
  • Develop complex SQL queries to support reporting requirements and SQL Server's stored procedures/functions and verified data accuracy
  • Present data in multiple formats including reports, charts, graphs, aggregates and statistical computations
  • Reconcile discrepancies in reports by validating data and support information technology applications including database application while utilizing analytical and programming skills
  • Ensure technology requirements for capture, manipulation and reporting of information related to clients are carried out
  • Develop programs, design screens and other processes to capture, edit and display data
  • Design edits, check errors and perform validation procedures to reduce keying errors
  • Create automated scripting procedures to speed up the processing of information
  • Utilize programming and reporting tools to provide input and transmit output
  • Create and modify various reports based on user requests
  • Added/updated system transactions and data code tables
  • Convert character based transaction into browser based ones
  • Attached programming edits to ensure data validity
  • Performed system administration duties including adding/deleting users, changing passwords and controlling security access to transactions.

Education

Masters of Information Technology -

Melbourne Institute of Technology
Sydney, NSW
11.2010

Master in Computer Applications -

Desh Bhagat Institute of Computer& Sciences
Punjab
06.2007

Bachelor of Computer Application -

Tara Singh Memorial College
06.2003

Skills

  • Data/Technical Analysis
  • Databases - SQL/Oracle PL/SQL/Teradata
  • Microsoft Visual Studio
  • SSRS/SSIS/ exposure to SAS
  • GitHub/ Team Foundation Version control
  • Agile Work Management Solution - Jira
  • Collaborative Documentation Tool- Confluence
  • Defect Tracking
  • Use Cases
  • Data validation
  • Microsoft Visio

Timeline

Data Remediation Analyst

Westpac Bank
03.2022 - Current

Technical Business Analyst

Commonwealth Bank
06.2021 - 03.2022

Business Intelligence Reporting Analyst

Commonwealth Bank
11.2014 - 06.2021

SSRS Report Developer

Tribal Group
08.2014 - 11.2014

Programmer/Reporting Analyst

RESIMAC
05.2012 - 11.2013

IT Support Specialist

Melbourne Institute Of Technology
08.2009 - 09.2010

Software Developer

Duke Fashions Ltd
01.2007 - 03.2009

Masters of Information Technology -

Melbourne Institute of Technology

Master in Computer Applications -

Desh Bhagat Institute of Computer& Sciences

Bachelor of Computer Application -

Tara Singh Memorial College

Similar Profiles

CREATE PROFILE
Neelam Goyal