Joe Bialkowski Email and Phone Number

Established in 1817 Westpac is Australia’s oldest bank and is ranked in the top 10 listed companies by market capitalisation on the Australian Stock Exchange. The LTRI project was established to identify and remediate long term risk issues in dealing with data exchanged between various product systems such as Calypso and Murex and the reconciliation platform TLM (Transaction Lifecycle Management).As the stream lead I was responsible for designing and implemented documentation standards, templates and methodologies for use by the LTRI project which were subsequently adopted by other project teams as well. To overcome limitations within existing documentation for ETL mappings I developed functionality to interpret the XML extract from Informatica PowerCenter mappings and present the details in more readable form using Microsoft Excel. This role also included coordinating the development and testing efforts necessary to facilitate production deployments. Regular meetings with business owners and group assurance were also conducted to ensure all stakeholders approved the documentation and production changes.

The Customer Static Data project was part of a business process improvement program for the Westpac Institutional Bank (WIB). As a senior solutions designer I worked with the project architect on the Technical Solution Design which incorporated the integration of IBM’s BPM solution and various in house applications that interfaced through TIBCO and the corporate ESB. I also produced various white papers on the design options available to the project.The Nostro project involved implementing a software solution for the management of foreign currency accounts held by Westpac with foreign correspondent banks. I was in responsible for producing a feasibility study on available solutions and the Technical Solution Design. The proposed system will go live in October 2014.The ETL3 upgrade project involved upgrading the Informatica run time framework and the introduction of a browser based user interface for the configuration and control of batch processing. I was also responsible for the delivery of a Unix based file pass through function which went into production August 2014.

Centralised Collateral Management Services project (CCMS), was developed in conjunction with CMAX and AustaClear to provide a mechanism for participants to lodge securities through CHESS as collateral against loans. Developed numerous application infrastructure components and functionality to process transfers and lodgements. ASX Managed Funds Service project (AMFS), provided training to the test team and imparted practical knowledge of the ASX settlement system (CHESS). Improved the procedures and capabilities of the test team where testing CHESS was involved. Developed test plans and tested various AMFS function such as Switch and Regular Payment Plans. Redesigned and rewrote the main enquiry function used by CHESS operations to investigate participant queries related to AMFS

Developed the framework in which the EIG production support team operated. Employed new team members and developed the team’s UNIX skills to a point where they could become self-sufficient. Developed new and improved exiting support functions to a point where they could be taken on by Westpac’s outsourcing partner. All positions in the team were eventually outsourced.

Provide support for the Enterprise Information Gateway application. EIG is an integration application developed using Informatica’s ETL toolset. Provide services in the project charged with the remediation of Single Points of Failure within the EIG application architecture with included the feasibility study through to testing the recommended solution.Developed procedures for the use of Rational ClearCase within the project team. Provide ClearCase administration and support to the team.

CitiStreet (CSA Retirement Services) Provides comprehensive superannuation fund administration and professional services to industry fund and master trust clientsGained knowledge of the OMNI platform and contributed to the design and development of new functionality as part of a refresh program.

INGA is a joint venture between the global ING Group and ANZ bank. INGA is one of Australia’s leading fund managers, life insurers and superannuation providers. Design, document and develop solutions across the front office and back office components of the Gatekeeper application which is a core applications that supports INGA’s local retail business.

Worked closely with the various business units on a variety of projects ranging from client migrations to assisting with evidence in legal casesAssisted in the development and documentation of the divisions SDLC Designed and developed complex functionality to produce Periodic Statements both OSCAR and TRUST systems. Worked with outsourcing partners to conduct Disaster Recovery test and define procedures in the event of a site failureProvided assistance in the resolution of production application and infrastructure issues, often involved in debugging code

Manage the 5 development and support teams responsible for OSCAR in Australia and New ZealandManage the migration of current and historic data for new clients coming from competitors systemsProvide technical and architectural support for the OSCAR infrastructureMentoring and technical training of staff

Successfully Implemented OSCAR (Online Shareholder Communications and Registry System), a green fields development.Messages based system utilising a 3 tier architecture comprising of a J2EE web based front end, IBM MQ series middleware layer using XML messaging and a COBOL Oracle backend.Designed and implemented the MQ Series queue structure, developed message routing functionality.Developed programming standards resulting in consistency of code and easier problem resolution.Ensured that OSCAR was as dynamic using application metadata to generate message formats and validation rulesDeveloped a utility to generate SQL for standard database access routines using Oracle system tables. This saved considerable development time allowing developers to focus on application code rather than SQL.Developed scheduling functionality to control the online and overnight processing cycles.Developed Unix scripts using KornShell that controlled OSCAR application execution.

Manage the development and production support teams responsible for CHESS

Significant contribution to the design, development and implementation of CHESS As project DBA I designed and implemented the CHESS database on a VMS/RDB platformDeveloped utilities to generate code for standard database access routinesDeveloped Securities lending functionality Developed Securities maintenance Developed Payment facility maintenance Developed Takeover processingInfrastructure design and implementation