Sheron Ali
Hamilton,WKO
Summary
Highly competent Data Engineer with background in designing, testing, and maintaining data management systems. Possess strong skills in database design and data mining, coupled with adeptness at using machine learning to improve business decision making. Previous work resulted in optimizing data retrieval processes and improving system efficiency.
Overview
17
17
years of professional experience
Work History
Data Engineer
Fletcher Building
03.2023 - Current
- Collaborated with cross-functional teams, including data analysts and business stakeholders, to gather requirements and ensure data solutions met business needs Developed and maintained ETL processes to integrate data from various sources into centralized data systems
- Troubleshot and resolved data-related issues, implemented enhancements to improve data quality and system performance
- Maintained existing data systems, identifying improvements to reduce recurring issues
- Stayed up to date with emerging data engineering technologies and best practices to drive continuous improvement
- Identifying and recommending enhancements to reduce recurring support issues and enhance data platform performance
- Participating in the BAU support rotation, ensuring data platform stability and availability
- Assisted in designing, developing, and implementing scalable data solutions
- Creating pipelines in Azure data factory for data ingestion from source databases and into Snowflake while adhering to CI/CD practices
- Assisted stakeholders with data testing and validating in DEV environments prior to PROD deployment
- Proficient in Microsoft SQL, data management, analysis, and complex query writing for data querying and manipulation and creating code in Snowflake for end-user utilization
- Knowledge of database and technical architecture concepts.
- Proficient in troubleshooting and applying problem-solving techniques
- Skilled in data quality assurance and data governance
- Understanding of DevOps and DataOps processes
- Working closely with stakeholders on projects and ensuring business requirements are documented within the correct platforms
- Data testing and validating with existing systems before passing onto end user testing
- Working on data discovery and creating data models for the building of the physical data model by the senior data engineers
- Updating code on Snowflake as per user requirements to ensure that the requested new data flows accurately when queried for reporting purposes
Data and Insights Analyst
Fletcher Building - Mico Distribution
08.2022 - 03.2023
- Identified and documented business requirements in confluence
- Conducted data discovery activities to identify data sources and perform data quality assessments for the data engineering team
- Collaborated with the data engineers to design solution, and ensure consistent data engineering practices are used and remains aligned with other business units
- Collaborated knowledge share sessions with the end users by presenting the use of the built visualization on Qlik dashboard
- Collaborated with the Product owner to understand business requirements, identify dependencies and managed delivery expectations
- 1
- Created visualizations in Qlik to enable story telling with the distribution business data and generating meaningful insights
- Used best practice when developing dashboards to ensure the most efficient way of delivering to requirements
- Ability to write SQL queries and scripts to extract, integrate, and shape the data into models that will be easy to use in Qlik applications
- Contributed to continuous improvement of analytical repositories
- Analyzed and ensured that the quality of existing data and collection of new data is within the guidelines and principles of data quality
Data Quality Analyst/Data Analyst
HealthShare
06.2021 - 08.2022
- Work with the project team for the gathering and documenting of requirement specifications
- Analyzing and mapping of system messaging data for new project implementation
- Ability to work with large data sets and applying ETL processes for user-friendly reporting
- Knowledge of preparing feasibility and business requirements document
- Perform gap analysis task to capture data gaps or incomplete data sets
- Contribute to functional and non-functional testing in relation to data and system messaging
- Investigate and document issues for assigned JIRA tickets for further escalation
- Maintaining data dictionary in alignment of the Data Quality Framework
- Work with stakeholders to document current state business processes and identify gaps
- Working on team projects where Agile methodologies is key to the success of each sprint
- Ensure any risks are identified, documented in the risk register and managed in line with best practice guidelines
- Collate and update code-set data relating to current procedures with new legislative code sets for reporting
- Perform data mapping exercises as per business requirements
- Work with stakeholders to verify the quality and terminology of mapped data
- Ensuring that accuracy and integrity of data is managed and maintained
- Collaboratively work on the Health data standards in accordance with the HISO Standards
- Contribute to Data Governance meetings
- Collaboratively work with my team 1
- Document SOPS for key processes vital for health services
- Creating data class models which is key starting point when working on data standards
Revenue Coordinator
Hamilton City Council
10.2015 - 05.2021
- Analyze water-by-meter raw billing data
- Correct anomalies with the data and the billing system if any prior to finalizing the water- by meter accounts
- Work with the field officer to carry out further investigations of Ad-hoc meters where the data supplied is questionable
- Ensure that all calculations for invoicing are documented and are traceable as per standards in our document library for Audit NZ
- Ensure on-time billing for thousands of water-by-meter accounts
- Responsible for an annual revenue of over $10 million
- Manage water-by-meter customers account queries in a timely manner and in accordance with the Hamilton City Water Supply Bylaw 2013
- Responsible for the water meter master data in relation to new connections and asset replacements programme
- Work with IS to create Enterprise User Reports by using correct database tables
- Ensure historical connections are compliant
- If not, work with the field officer and the compliance team to take appropriate action
- Managed a GPS project for water asset location data and worked with the asset team in City Waters unit to ensure GIS asset data locations are accurate and up to date
- Create monthly financial analysis report of the water-by meter revenue
- Assist with the review of all Actuals Vs Budgets with the Revenue Team Leader
- Provide on time sundry reporting and analysis to assist with management budgeting requirements
- Induct new staff with health & safety guidelines, arrange for safety gear for field work and arrange required traffic safety training
- Arrange for buddy-up work arrangement with field officer to understand the practicality of training skills acquired
- Foster and maintain stakeholder relationships
- Contributions to special projects as required for the improvement of systems and new technology being introduced
- This is achieved by User Testing in a test environment and providing feedback
Revenue Team Leader
Hamilton City Council
09.2017 - 02.2019
- Manage staff by having regular catch-up meetings
- Providing support, feedback and training
- Ensure group invoicing and other revenue stream invoicing is completed on time
- Provide support to staff to ensure timely completion of queries and billing
- Ensure contract and PSP payments have been loaded onto the system and documentation for finalizing the payments have been sent to procurement
- Ensure data assurance reviews are completed annually including customers identified with High Water Use Agreements and Individual Trade Waste Agreements
- Assist with improvement initiatives to maximize data efficiency and revenue generation for the business support revenue team
- Maintain and analyze water revenue data to ensure that variances within financial reports can be easily explained or tracked to ensure proactive management of budgets within agreed parameters
- Ensure the integrity of data and identified improvements including follow up actions are proactively managed to completion within required timeframes
- Ensure all water by meter customers are managed as per the 'Customer Promise' and requirements of the Water Bylaw
- Ensure health and safety always remains a focus in my team
- Monitor any contractors and/or sub-contractors engaged by our unit
- Prepared reconciliation of contractor works invoiced versus actual works completed
- Prepared payment authorization documentation for contractor payment
- Secondment
Capital Programmes Coordinator
Hamilton City Council
11.2016 - 09.2017
- Assist project managers with the preparation and delivery of the monthly PMO reporting for the City Development and City Transportation Unit projects
- Ensuring monthly financials reported for project reporting is accurately coded to the right G/L in Dynamics AX and that the budget vs cost is reflected in the PMO reports
- Ensure that wrongly coded transactions are traced, communicated to the finance team for correction using the appropriate journal transfer forms
- Work together with the unit managers to ensure that the phased budgets and deferrals are assigned to the correct projects
- Document new processes and create new project templates as per the new PMO reporting system
- Work together with the project managers on the outstanding work in progress balances (WIP) by ensuring that the required asset management processes are followed
- Asset Capitalization Following up with key internal and external stakeholders to ensure service contracts are created with the correct asset value and have been entered into IPS with correct project cost values
- Reconciliation of the Asset Renewal Programme spreadsheet of works completed against AX G/L balance
- Work with the IPS engineer to ensure cost relating to a specific asset data is captured within IPS service contracts and all supporting documents such as the are As-Built Data, Datasheet and DXF files are accurate and attached for review by the City Waters Asset Team
- Once the service contracts are fully complete and to the satisfaction of all teams involved, asset is then escalated to finance for capitalization
- Assist with the completion of the WIP transfer forms for asset capitalization
- Ensure Steering Group meeting minutes are distributed in a timely manner and actions from the PMO meetings are followed up on with the person responsible
- Proactively support the Programme Manager in delivery of their programmes of work, including setting up and implementing programme tools, systems and processes and continuously maintaining, reviewing and improving these
- Secondment
Payments Coordinator - Accounts Administrator
Waikato District Health Board
04.2014 - 10.2015
- To coordinate and deliver day to day technical and operational support for accounts payable team
- Review payments and analyze financial data
- Correcting errors, anomalies prior to finalizing the payment run
- Create and process invoice batches for specific vendors
- Generate EFT payment runs on a weekly basis via Oracle
- Ensure direct credit remittance advice for Waikato District Health Board have successfully created to vendors
- Resolve vendor issues and queries
- Support A/P staff and other DHB staff with payments queries
- Manage petty cash float and reconciliation
- Support the mental health unit staff by helping support patients with their funds
- Provide support to the manager of payments and revenue with ad hoc duties
- Provide backup to Accounts Payable Clerk's
- Release invoices on hold and liaise with purchasing staff where there are issues with PO and receipting
- Billing of recurring invoices and contacts with the Ministry of Health and HealthShare for national travel and accommodation assistance
- Write off bad debts for management approval, create appropriate journal entries for clearing debt of the billing system and prepare documentation for debt collection agency
- Management of IPM and Oracle databases containing non-resident addresses and contact details
- Reconciliation and completion of month-end processes as per month
- Create Forex payments for overseas vendor and order bank drafts
- Process Forex invoice batches accounting for FX gains/losses and bank fees
- Ensure all stakeholder relationships managed by providing good customer service is provided to both internal and external stakeholders
- Debit Collection of non-resident medical accounts
- Attention to detail and high accuracy required when creating invoices s requested by different departments of the DHB
- Contract
Bookkeeping
Slater Chartered Accountants
08.2013 - 04.2014
- Maintain financial records
- Setup new clients on XERO and ensure that appropriate bank forms are sent to the client to get their bank-feeds activated
- Backload missing bank data
- Manage document library in accordance to Audit NZ
- Daily bookkeeping and reconciliations individual client accounts
- Generate ledgers and export to excel
- Review coding and ensure transactions have been allocated correctly
- Support the accountants with ad-hoc requirements for a client's financial year end
- Create journal entries to correct discrepancies with coding
- Sort through client documents, invoices receipts for GST portion
- Code GST transactions
- Contract
Cash Management Officer
Fonterra
08.2007 - 07.2013
- Import bank files into SAP and JDE Oracle
- Code transactions to the correct G/L codes and ensure that daily reconciliation is completed
- Ensure funding is available of each region and account currency
- Drawdown funds from treasury funds and arrange for sweeps to be placed so that excess funds are sent back to treasury
- Ensure correct FX documents have been prepared when buying and selling foreign currency
- Liaise with Treasury and Market Bankers accordingly
- Ensure correct vendor and customer bank account templates have been setup on the online banking system
- Payments made as per value date
- Investigate rejected payments and take appropriate action to correct and re-make payment to the beneficiary
- Track progress of issue to ensure resolution
- Create journals for AR/AP deposits/payments & monthly intercompany payments Managing restrictions around sanctioned countries- restricted currencies
- Perform month end reconciliations for managed entities as part of the management accounting month-end
- Ensure that the correct audit processes are adhered to
- Support co-workers with month end and/or workload
- Process confidential and sensitive payments
- Ensure data being processed is protected
- Ensure tight time deadlines during Fonterra Business Services month end whilst maintaining business as usual processes
- Prepare month-end accrual journals for Treasury deposit balances and unallocated amounts on all managed entities
- Query unallocated amounts with stakeholders
- Communicate daily with key stakeholders
- Ensure that customer service level standards are maintained at all time
- Resolve enquires in a timely and professional manner
- Participate in project work such as testing of new reporting tools and system upgrades for continuous improvement initiatives
Education
Bachelor of Business - Accounting
Open Polytechnic
01.2015
Bachelor of Information Technology Degree -
PRINCE 2 Foundation Certification -
Skills
- Data Analysis & Reporting
- Data Insights & Visualizations
- UA Testing
- Data Modelling
- Data & Process Flow Mapping
- Gap Analysis
- Forecasting and Budgeting
- Month-end Processes & Accruals
- Financial Reporting
- Data Querying & Investigating
- Transactional Services
- Customer Services
- Accounts Payable/ Receivable
- Accounts Reconciliation
- Contract Management
- Authority Billing System
- JDE
- SAP
- CRM
- Advanced Excel
- Office 365
- GIS
- XERO
- Qlik
- Power Bl
- Confluence
- Agile Project Fundamental
- C#, Python, HTML, XML, SQL
- Power BI
- Oracle Business Intelligence (OBI)
- Oracle Data Warehouse (ODW)
- Snowflake
- Azure Data Factory
- WhereScape Red
- Excellent verbal & written communication skills
- Ability to work collaboratively as part of a team
- Problem-Solving Capabilities
- Leadership
- Attention to detail
- Excellent Organizational skills
- Ability to work under pressure
- Can do attitude
- Fast Learner
- Positive
- Customer focused
- Hard working
- Approachable and Friendly
- Great Personality
- Strong analytical skills
- Dedicated in delivering high quality service
- Understand business process requirements and translate them into technical solutions
- Collaborative team player with a passion for problem-solving and self-improvement
- Effective time management and prioritization in managing multiple work requests
- Willingness to learn and desire for self-development and improvement
Timeline
Data Engineer
Fletcher Building
03.2023 - Current
Data and Insights Analyst
Fletcher Building - Mico Distribution
08.2022 - 03.2023
Data Quality Analyst/Data Analyst
HealthShare
06.2021 - 08.2022
Revenue Team Leader
Hamilton City Council
09.2017 - 02.2019
Capital Programmes Coordinator
Hamilton City Council
11.2016 - 09.2017
Revenue Coordinator
Hamilton City Council
10.2015 - 05.2021
Payments Coordinator - Accounts Administrator
Waikato District Health Board
04.2014 - 10.2015
Bookkeeping
Slater Chartered Accountants
08.2013 - 04.2014
Cash Management Officer
Fonterra
08.2007 - 07.2013
Bachelor of Business - Accounting
Open Polytechnic
Bachelor of Information Technology Degree -
PRINCE 2 Foundation Certification -
Similar Profiles
Ruth SamsonRuth Samson
Business Analyst at Fletcher BuildingBusiness Analyst at Fletcher Building
Agatha ChiuAgatha Chiu
PMO & Quality Assurance Manager at FLETCHER BUILDINGPMO & Quality Assurance Manager at FLETCHER BUILDING
Tim BroxhamTim Broxham
Executive General Manager (Director) at Stramit Building Products ( Fletcher Building)Executive General Manager (Director) at Stramit Building Products ( Fletcher Building)
Yuvrajsinh VansiaYuvrajsinh Vansia
Website & System Administrator at Indian SupermarketWebsite & System Administrator at Indian Supermarket
Anuja GanpuleAnuja Ganpule
Customer Service Representative at Dominoz Pvt LtdCustomer Service Representative at Dominoz Pvt Ltd