Glenn M Carroll
Yarrawonga,VIC
Summary
Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills. Detail-oriented designs, develops and maintains highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design and implementation stages.
Overview
26
26
years of professional experience
Work History
Database Engineer / Data Analytics
Services Australia
07.2018 - Current
- Involved in development and design of the mongoDB data model and integration
- Responsible for migrating DB2 data to MongoDB collections and Postgresql databases for the Pega application
- Involved in design and development of the mainframe DB2 data extracts into JSON files for the mongoDB collections
- Contributed to the Data Migration strategy and methodology for the MongoDB / PostgreSql / DB2 databases
- Experience in MongoDB and PostgreSQL architecture
- Proficient in comprehensive documentation, analysing, testing, deployment and resource management abilities
- Design, developed and maintained ETL processes to extract, transform and load data from DB2 into MongoDB and PostgreSQL
- Working with business analysts to design and document data requirements and provide technical solutions for data reports
- Data modelling / Analysing and translating business requirements into data models via the Hackolade design model tool
- Provide Production support via data patch fixes and investigating data issues
- Write SQL to query DB2/PostgreSQL fixes to correct data and resolve production issues
- Produce MongoDB NonSQL pipelines to investigate production issues, data querying and produce JSON/Excel reports
- Optimise data structures and indexes for performance and query efficiency
- Experience using Git, Gitlab, CI/CD pipelines, Visual Studio Code and Node.js script writing for MongoDB data fixes
- Postgresql enquiries/data reporting and data migration to lower non-production environments
- DB2 enquiries/investigations to support production issues
- Write complex sqls to replace mainframe decom screen replacements
- Datalake queries to investigate historic production issues
- Experience with JIRA task tracking and Sharepoint collaboration tools
- MongoDB basics and aggregations, MongoDB for SQL pros and MongoDB data modeller certifications
- Studied and completed the Pega System Architect (CSA) v8.6 course.
Application Programmer
Department of Human Services (Services Australia – Medicare)
04.2010 - 06.2018
- Analyses, Design and implement batch and online Cobol/Delta/JCL/DB2 programs for DHS mainframe systems
- Administer ad-hoc emergency data fixes or technical code fixes for production batch problems
- Technical design and documentation of system solutions for the batch and online systems to meet the business requirements
- Very experienced in COBOL, Delta, DB2, SQL, Endevor, SPUFI, QMF, DBVis, SDSF, JCL, JINDEX, BMC, Infoman and TSO/ISPF expertise
- Designing, building, testing and implementing new batch and online mainframe systems for the Superannuation Clearing House (SCH) payment system, National Health Funding Pool (NHFP) payment system, Living Organ Donor (LOD) payment system, Training Assistant Scheme (TAS) payment system, Green Rewards Scheme (GRS) payments system, the Financial Assistance Scheme (FAS) payment system and most recently the Australian Immunisation Registry (AIR)
- Working with business analysts to design and document functional requirements for the mainframe systems and provide technical solutions
- Provide Production support for both batch and online mainframe systems
- Analyse batch job failures and write SQL to do DB2 fixes to correct data and resolve them
- Change Management and Migration Control for new releases of application enhancements
- Presented with the Australia Day Achievement Award January 2013 for ‘exceptional work performance’ for the successful implementation of the NHF Payments System
- Presented with the Prime Minister’s Award in 2011 for ‘Recognition of delivering the Small Business Superannuation Clearing House system’
- A massive achievement to successfully implement such a complex superannuation payment system.
- Improved overall system reliability through rigorous testing procedures, identifying potential vulnerabilities, and addressing them proactively.
- Provided technical support by troubleshooting and resolving software-related issues efficiently.
- Analyzed, reviewed and revised programs to increase operating efficiency.
Technical Consultant
UXC – QSP - Canberra
02.2007 - 03.2010
- Development and Support Role – Develop new COBOL programs/reports and maintaining client-specific code for QSP financials application
- Both on-line and batch Cobol programs for the particular client – DAFF, Telstra, Customs, DVA, MAS, DoFD, MSD and Qantas
- On-call Production support for priority incident fixes across all finance modules
- Unix, Vi, SQL and unix scripts on Sun Solaris machine with Oracle DB and TOAD experience
- System designer/developer for new module applications
- DB2, SQL, SPUFI, QMF, COBOL, SDSF, JCL and TSO/ISPF expertise
- Diagnose, resolve and provide advice on process and functionality defects within the QSP financial E5 system
- Write technical specifications and test documents for system solutions
- Conduct monthly support meetings with our clients to meet their needs
- Configuration, testing, loading and debugging programs
- Solution implementation, maintenance and support for each client
- Support the new Travel Management system via Java mods using MyEclipse, JSP Struts, Websphere and XML.
Technical QSP/Cedar System Administrator
London Borough of Camden Council – London, UK
08.2004 - 10.2006
- System Administrator for the QSP/Cedar Financial system and Camden’s purchasing card system
- 1st line support for client users on all GL, PL, SI, SL and POP modules
- Create/manipulated many Cobol reports and foreground user exits on unix/Oracle to suit clients needs
- Design and tested the new Budget/Forecast system
- Wrote design documents and test cases/schedules to meet the budget team’s requirements and performed the system/function testing
- Administrator of Cedar’s security, amendment of Cobol reports and batch programs, maintenance of over night batch runs
- Maintain daily, weekly and monthly system routines
- Collaborated in the development of the new Budget/Forecast system
- Tested and supported existing legacy system and insured they were available in parallel until legacy system was retired
- Responsible for the maintenance of Camden’s personnel credit card system and monthly statement runs.
Technical QSP Consultant
London Borough of Hammersmith & Fulham council – London, UK
03.2004 - 07.2004
- Analyst/Development work on the major upgrade from QSPF 4.6.1 to E5
- Worked on the new ALMO housing project implementing a new separate company into QSPF
- Involving creating/manipulating/testing many reports, Cobol programs, User Defined Tables, Screens and User exits
- Involved in implementing the Purchase Order Processing POP relaunch project and the go-live planning
- Unix and Vi experience on Sun Solaris machine with Oracle DB
- Responsible for coding/testing of User Exits, reports and clients Cobol Interface programs
- 1st line support for system & user acceptance testing
- Responsible for the creation of the many new reports/QED’s specific for the ALMO project to be company and ledger specific.
Senior QSP Analyst/Programmer
Norwich Union – London, UK
09.2001 - 03.2004
- Worked on the QSPF to Oracle migration project
- Manipulating and re-directing the many PL and GL interface feeds from QSPF to Oracle
- Excellent experience in developing Cobol interfaces into QSPF
- Experience in enhancing QSPF online validation via Cobol user exits and enhancing reports
- Experience in developing COBOL on-line and batch programs on the IBM Mainframes environments
- DB2, SQL, SPUFI, COBOL II, SDSF, FILE-AID, JCL, Control/M, Control/D and ISPF experience
- Involved in all stages of the full life cycle of implementation
- Extensive analyst skills on PL and GL QSPF interfaces
- Development of Functional and Technical design documents based on Finance and Treasury requirements to suit their specific requirements
- Developing and maintaining Cobol code to suit both QSPF and Oracle requirements
- Key support through System and User Acceptance testing before migration to Production
- Designed testing scripts using TestDirector and carried out system and integration testing using Control/M and Control/D.
Technical Consultant
QSP – Canberra, Australia
08.1999 - 08.2001
- Experience in developing COBOL On-line and batch programs on both Unix and IBM Mainframes environments
- DB2, SQL, QMF, SPUFI, MICROFOCUS COBOL, SDSF, FILE-AID, JCL and ISPF experience
- Unix, Vi and Emacs experience on Sun Solaris machine with Oracle DB
- Excellent communication and liaison skills
- Certified as a Sun Certified Java Programmer for the Java Platform – Java 2 platform (SCJP2)
- Developing and maintaining core and client-specific Microfocus Cobol code for various accounting/finance QSP clients
- Specifically Telstra, Department of Finance and Administration (DoFA), Agricultural, Forestry and Fishery Association (AFFA), Customs and Department of Veteran Affairs (DVA)
- Development of Functional and Technical designs based on user requirement specifications to suit customer requirements
- Worked on the Year 2000 compliant upgrade and then the GST changes upgrade for specific clients
- Worked in a large team analysing Telstra’s specific requirements, writing and testing On-line, Background and report programs to improve operational performance of Telstra’s Accounts Receivable (AR) Debtors management system.
Programmer/Analyst
Mincom – Canberra, Australia
09.1998 - 08.1999
- DB2, SQL, QMF, SPUFI, MICROFOCUS COBOL, SDSF, FILE-AID, JCL, Control/M, Control/D, Endevor and ISPF experience
- Programming experience in Delphi
- Unix and Emacs experience on Sun Solaris machine with Oracle DB
- Coding and rectifying programs in Cobol for ADF (Australian Defence Force) and the Canadian Defence Force
- Writing Test scripts, Technical Specifications and FDD’s (Functional Design Documents) for ADF requirements
- Provided system and integration Testing support
- Worked on MIMS upgrade project (LOPAS)
- MUI and Reportlink tools used.
Education
Bachelor of Science -
Chales Sturt
Skills
- SQL and Databases
- ETL development
- SQL Programming
- Data Migration
- Data Quality Assurance
- Database Design
- Advanced analytics
Securityclearance
NV1 Security Clearance
Technicalskills
COBOL, 20, DB2 SQL, 20, QMF, 20, SDSF, 20, JCL, 20, Endevor, 20, OPCA, 20, SPUFI, 20, TSO/ISPF, 20, Squirrel SQL, 5, DBeaver, 5, PgAdmin, 5, PostgreSql, 5, MongoDB Compass, 5, Erwin Modeller, 5, MongoDB, 5, Git, 5, Gitlab, 5, CI/CD pipelines, 5, Visual Studio Code, 5, Node.js, 5, DB2, 15, PostgreSQL, 5, MongoDB, 5
Personal Information
- Title: Database Engineer / Data Analytics
- Date of Birth: 07/08/75
- Nationality: Australian
Timeline
Database Engineer / Data Analytics
Services Australia
07.2018 - Current
Application Programmer
Department of Human Services (Services Australia – Medicare)
04.2010 - 06.2018
Technical Consultant
UXC – QSP - Canberra
02.2007 - 03.2010
Technical QSP/Cedar System Administrator
London Borough of Camden Council – London, UK
08.2004 - 10.2006
Technical QSP Consultant
London Borough of Hammersmith & Fulham council – London, UK
03.2004 - 07.2004
Senior QSP Analyst/Programmer
Norwich Union – London, UK
09.2001 - 03.2004
Technical Consultant
QSP – Canberra, Australia
08.1999 - 08.2001
Programmer/Analyst
Mincom – Canberra, Australia
09.1998 - 08.1999
Bachelor of Science -
Chales Sturt
Similar Profiles
Vishnu PriyaVishnu Priya
Services Delivery Officer APS4 at Services AustraliaServices Delivery Officer APS4 at Services Australia
EMMA KEENANEMMA KEENAN
Compensation Recovery Officer at Services AustraliaCompensation Recovery Officer at Services Australia
Tracey BlundellTracey Blundell
APS4 (SO4/LPS), Health Services Delivery Division at Services AustraliaAPS4 (SO4/LPS), Health Services Delivery Division at Services Australia