Juan Schaub Email & Phone Number

Sydney, Nsw, Au

Sydney, Australia

Lead the design and development of BI&Analytics systems and processes to ensure solutions developed for designated Metcash pillars are built using contemporary development methodologies, use fit-for-purpose architectures and inspire a collaborative culture within the development teams. Lead a multi–disciplined team of developers to deliver high quality project deliverables and services for internal customers.

Sydney, Australia

Designed solution patterns, strategies and solutions in Informatica BDM for the EIM Project. Leading a small group of Informatica consultants and working closely with the solution architects. - Informatica 10.0 (Big Data Management)- Informatica 9.6- Sap Hana- Oracle- AWS RedShift- MS Sql- Hadoop Cloudera

Sydney, Australia

Motor Repair Model project: Senior Informatica developer, DB2 and Data vault methodology

Sydney Area, Australia

Datawarehouse and ETL consultant specialised on Informatica suite. Zurich Financial Services (March-2012 - current): Responsible for the datawarehouse loading processes of the underwriting application Z-streamXpress. Since the introduction of Z-streamXpress 3years ago Zurich has gone from the 3rd largest packages underwriter to now the largest in the marketKey Responsibilities and Achievements• ETL design • Analysis and delivery of new products or risks from the platform• ETL Batch optimization program and delivery (35% reduction in time to date)• Creation of sustainable support modelLMG (Liquor Marketing Group) (December 2011 - March 2012) - Responsible for the installation and configuration of the Development environment for the Project Access. Key Responsibilities and Achievements• Installation and configuration of Informatica Servers and Tools (Powercenter, B2B, IIR) • Database installation and configurationOther projects:BUPA Australia: Informatica Data Privacy (ILM) - Installation, configuration and Kick off the masking data project for Testing environments.Optus (at Optus, Macquarie Park): BI Reporting Developer. Responsible for design and implementation of in house automated reports, using SQL scripting in Teradata and MS Excel VBA.--- Informatica Developer- ILM Data Subset 5.3.3- ILM Data Privacy 5.3.3- Informatica Powercenter 8.6 & 9.0.1

Responsibilities:● Analyzed and designed custom applications for internal customers● Involved with development for Inventory Solutions Applications Portfolio● Developed ETL processes for inventory applications for Inventory DataWarehouse ● Designed, developed and implemented new multi threaded interfaces● Developed new enhancements using Oracle Pl/Sql● Designed data modelling● Developed Unix Shell Scripts and AWK Scripts as ETL toolPrincipal Achievement during 2008:● Designed and developed new parallel process, which provides 40% faster response time. My professional achievement was recognized by the Verizon’s Ovation Recognition and Reward Program in December 2008.

Responsibilities:● Designed, developed and customized processes in modules: AR, AP,FA, OM and PO● Developed Oracle reports● Customized Oracle forms● Involved with interaction Oracle-Unix● Applied Oracle patches

Responsibilities (Team Leader):● Communicated with clients to address needs on daily bases● Wrote proposals to clients describing analysis of problem with recommendations for alternative solutions● Allocated work and load balance for development team● Technical Trainer (Unix, shell script, awk)

Responsibilities:● Worked in C environment and handled projects related to Credit Card and finance● Developed Unix shell and AWK scripts● Developed, improved and customized ICBS (International Chargeback and Billing System) ● GCMS-IPM Project: Upgraded Mastercard International messaging system from INET (Interbank Network for Electronic Transfer) format to IPM ● Re-engineered processes in order to unify local and international claims system along with temporary credits● Involved with development of SAFE Project (System to Avoid Fraud Effectively)● Developed changes to meet MasterCard International’s requirements in ICBS system to protect and detect fraudulent transactions