KAIN SUTTON
Canberra,ACT
Summary
Results-driven data analytics and business intelligence professional with extensive experience leveraging advanced skills in Power BI and Cognos to deliver strategic insights and optimize reporting processes. Proficient in developing ETL pipelines and automating data workflows to enhance efficiency and accuracy in data management. Eager to contribute as a BI & Data Engineer, utilizing expertise to foster innovation, drive growth, and support informed decision-making within dynamic environments. Committed to transforming complex data into actionable intelligence that empowers organizations to achieve objectives.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Business Analyst
The APP Group
03.2025 - 06.2025
- Company Overview: Servicing Department of Defence, MDP
- Building a roadmap/strategy on defences capability over the next 3, 5, 10 years and providing insights by presenting the data in a dashboard utilising Power BI.
- Servicing Department of Defence, MDP
Cognos Specialist
KTech/KPMG Australia
06.2024 - 09.2024
- Company Overview: Servicing Department of Defence, 1DDP
- Uplifting current Cognos SLA reporting dashboards for both PR2 & PR3.
- Designing and developing reports and dashboards based upon new business requirements.
- Servicing Department of Defence, 1DDP
Data Engineer
Paxus
01.2024 - 06.2024
- Company Overview: Servicing Department of Defence, Data Division, iSDP & 1DD
- Centralising data from multiple sources by building ETL pipelines.
- Automation of downloading datasets from REST APIs by developing powershell scripts.
- Using Cross Domain Service to allow data to be moved and accessed between the low and the high side of the networks.
- Providing documentation for PICTA accreditation.
- Servicing Department of Defence, Data Division, iSDP & 1DD
BI Architect (Cognos & Power BI)
Ignite
07.2022 - 09.2023
- Company Overview: Servicing Department of Defence, VCDF, IPMB, CapabilityOne
- Leading a team of BI Developers.
- Managing our workload and assigning tasks to my team utilising DevOps.
- Providing business solutions to all of our business areas and clients.
- Performing BI administrative procedures including of updating most up to date BI installations, security measures along with other BAU tasks.
- Building a solid data module to accommodate all of our reporting needs.
- Dimensional data modelling to support our reporting to the data warehouse.
- Servicing Department of Defence, VCDF, IPMB, CapabilityOne
Data Engineer / Power BI Developer
Rubik3
11.2021 - 07.2022
- Company Overview: Servicing Department of Agriculture, Water and Environment, ABARES
- Developing data warehouse to support the Data & Analytics program.
- Building new and enhancing existing Power BI Dashboards and Reporting to assist with Australia’s Trade Export Data.
- Migrating data from a SQL MI to Azure Synapse.
- Responsible for ETL and ELTL processes and pipelines utilising Azure Data Factory.
- Managing workload, code repositories / changes and other data warehouse items by using DevOps and Visual Studio.
- Servicing Department of Agriculture, Water and Environment, ABARES
Software Data Engineer / Consultant
Data reFactory
06.2021 - 11.2021
- Working on a POC for Army which involves implementing an ingestion pipeline using a tailored application to resolve existing data ingestion issues.
- Assisted in the front-end design and development of the application utilising Visual Studio and Angular.
- Provided fully scalable document indexing, entity extracting and data linking capability using a combination of open-source and COTS software.
- Migrated this solution from on-prem to the Azure Cloud instance.
- Responsible for ETL processes and pipelines utilising Azure Data Factory.
- Administration tasks of our Azure Cloud environment.
- Heading up the visualisation of data and analytics using Power BI.
COGNOS 11 Developer / COGNOS Administrator
Ignite
07.2020 - 06.2021
- Company Overview: Servicing Department of Defence, VCDF, IPMB, CapabilityOne
- Upgraded Cognos 10.2.2 reporting environment to Cognos 11.1.7.
- Installation and configuration of the Cognos 11 DEV and PROD environments.
- Configuring SSO for Defence users, customisation of the Cognos UI and setting up strong security protocols and capabilities.
- Administrated both DEV and PROD Cognos Servers.
- Developed and Maintained multiple Cognos reporting data models and packages.
- Migration of Cognos 10 reports to Cognos 11.
- Delivered new and advanced/complex visualisations for Dashboards and Reports.
- Servicing Department of Defence, VCDF, IPMB, CapabilityOne
Business Intelligence Developer
Providence Consulting
09.2016 - 06.2020
- Company Overview: Servicing Department of Defence, JCG, Joint Health Command
- Designed, developed, and implemented reports using multiple BI Tools including Cognos v10 and 11 series, Power BI and Tableau.
- Maintained and helped enhanced metadata model in Framework Manager.
- Enhanced data packages to suit Joint Health Commands business needs and to improve the performance of reports.
- Delivered advanced/complex reporting solutions such as Dashboards and Standardized Reporting.
- Expertise in developing, testing and validating Complex reports (List, Cross tab, Charts, Maps, Drill through, Master-Detail, Cascading) using multiple BI Tools.
- Create complex custom SQL queries and developed stored procedures and database triggers using T/SQL.
- Worked with business analysts and users, to define reporting requirements for various services and processes.
- Experience in writing HTML/ JavaScript for implementing custom functionality to reports.
- Involved in automating reports that are to be delivered regularly to business.
- Provided input into the system analysis, design, implementation, and unit and integration testing of data services for reporting in Joint Health’s reporting environment (Cognos).
- Performed extensive data Validations, unit testing and prepared some Test cases.
- Servicing Department of Defence, JCG, Joint Health Command
Reporting Specialist
Fujitsu – Canberra
05.2015 - 09.2016
- Company Overview: Servicing Department of Defence
- Responsible for interpreting user requirements and building reports using various tool such as Cognos (Version 10.1.1), SQL Server 2008R2, Xtraction and Excel.
- Consulted with Cognos Technical Teams for the development of client specific reporting.
- Create complex custom SQL queries against SM9 database for ad hoc reports.
- Validating Cognos report results against the backend of the SM9 database.
- Created JavaScript’s for implementing custom functionality and client side validations.
- Expertise in developing and testing Complex reports (List, Cross tab, Charts, Maps, Drill through, Master-Detail, and Cascading) and Dashboards using Cognos Report studio.
- Designed and developed business and ad hoc reports to continually improve efficiency, readability, and depth of information to both internal management and providers.
- Provided input into the system analysis, design, implementation, and unit and integration testing of data services for reporting in Cognos.
- Performed system testing and data validation.
- Created Lists, Grouped Crosstab, and Reports with calculated fields, conditional filters and prompts.
- Review and Analyse Business requirements.
- Preparing reports on data quality and progress for continuous service improvements.
- Rebuilt, expanded and improved service level and operational reports using various BI tools.
- Developed and implemented new reporting strategies and procedures to enhance the effectiveness of company operations.
- Troubleshooting issues for Report Requestors and ensuring report requirements are correct and that service delivery met requestor expectations.
- Prepared strategic trend reports to measure KPI’s.
- Trained and mentored all levels of management regarding new reports.
- Acting Manager of a small team as required.
- Servicing Department of Defence
2IC / Reporting Analyst / Tech Lead
Datacom – Canberra
06.2013 - 11.2014
- Company Overview: Servicing the ATO Department
- Designed and developed reports for management to address underlying performance issues.
- Expertise utilising Remedy ITSM for effective Service Management.
- Promoted to 2IC to manage a team of 9 SDA’s in the absence of the Team Leader.
- Managed allocation of resources within the team, provided guidance support and performance management to team members.
- With my leadership and data analytical skills I helped produced the number 1 performing team for Service and Quality Assurance across the entire Service Desk.
- Allocated work to team members to ensure timely and effective response to user needs.
- Resolved Service Desk Analysts issues in a clear, courteous and straightforward manner.
- Resolved and identified IT system problems and escalated to correct areas as needed.
- Provide training and mentoring to Service Desk Analysts to ensure their quality of service is second to none.
- Create, maintained, and update Knowledge Base articles to ensure information is available to Service Desks Analysts.
- Provided level 2 IT Support to non-technical personnel a large Government Department.
- Servicing the ATO Department
Education
School Certificate -
Forbes High School
Forbes01.2002
Skills
- SQL programming
- Python programming
- ETL processes
- Cognos reporting
- Power BI
- Data modeling
- SQL query development
- Data visualization
- Team leadership
- Problem solving
- Attention to detail
- Communication skills
- Data integration
- BI reporting tools
- Data security
- Data warehousing
- Big data technologies
- Teamwork and collaboration
Certification
Information Technology Certificate III
References
References available upon request.
Timeline
Business Analyst
The APP Group
03.2025 - 06.2025
Cognos Specialist
KTech/KPMG Australia
06.2024 - 09.2024
Data Engineer
Paxus
01.2024 - 06.2024
BI Architect (Cognos & Power BI)
Ignite
07.2022 - 09.2023
Data Engineer / Power BI Developer
Rubik3
11.2021 - 07.2022
Software Data Engineer / Consultant
Data reFactory
06.2021 - 11.2021
COGNOS 11 Developer / COGNOS Administrator
Ignite
07.2020 - 06.2021
Business Intelligence Developer
Providence Consulting
09.2016 - 06.2020
Reporting Specialist
Fujitsu – Canberra
05.2015 - 09.2016
2IC / Reporting Analyst / Tech Lead
Datacom – Canberra
06.2013 - 11.2014
School Certificate -
Forbes High School
Similar Profiles
Ranjith PullagurlaRanjith Pullagurla
Analyst at The APP GroupAnalyst at The APP Group
Ranjith PullagurlaRanjith Pullagurla
Analyst at The APP GroupAnalyst at The APP Group
Katherine McIntoshKatherine McIntosh
Senior Urban Planner at The APP GroupSenior Urban Planner at The APP Group
Thomas RobinsonThomas Robinson
Hall Staff Member at HEROSUSHIHall Staff Member at HEROSUSHI
Karen Lorena Pinzon GarciaKaren Lorena Pinzon Garcia
Preschool Lead Educator at St Luke's Early Learning CommunityPreschool Lead Educator at St Luke's Early Learning Community