Dale Cuenca Email & Phone Number

Te Kauwhata, Waikato, Nz

Auckland, New Zealand

Responsibilities:- Created and maintained new and existing data models and ETL pipelines.- Identified and fixed data issues in the data warehouse.- Developed data sources (stored procedures and table-valued functions) to be consumed by dashboards.- Created new dashboards as per user requirements.- Designed and created new reports as requested by customers and as part of homologation requirements.- Performed bug fixes on reports to ensure data correctness.- Modified existing reports for better performance, usability and data presentation.- Provided help and support to other teams who have reports and data warehouse specific issues and enquiries. - Created release notes and documentation to ensure better knowledge transfer.

Auckland, New Zealand

Responsibilities:- Acted and responded timely on New Zealand and Malaysia based users on issues, enquiries and requests.- Performed data checks and data fixes when necessary to ensure data correctness and integrity of the tables used by our applications.- Monitored daily the health of the automated jobs in SSIS, CRM system, and other critical applications.- Provided monthly after hours support of our applications and systems.- Implemented bug fixes, new functionalities and enhancements on different company applications.- Coordinated with the users with their requirements of building, enhancing and/or fixing of applications and systems to improve business operations and support.- Created new applications and services as per user requirements.- Created and provided data extracts regularly and when requested to assist with the company's decision making and strategy.- Implemented a middleware where automated Windows services and SQL jobs are run and where the interface files between CRM system, Oracle and Salesforce.com are processed and archived. - Converted data and built automated interfaces in SSIS to Oracle.- Supported team mates in the migration of data and building automated interfaces in SSIS to Salesforce.com.- Implemented and modified web services and API's used in different company applications.- Conducted peer checks when a teammate is releasing changes to production and/or doing updates in live database. - Given training and user guides on the new applications and enhancements to the target users.- Implemented the company's initiatives on information security (ISMS), J-SOX compliance, sustainability and environment-friendly practices.- Helped the company recognise well-performing employees by being part of the committee that manage and review employee-submitted peer recognition and appreciation testimonials.- Helped the company manage and promote employee-submitted suggestions that aims to improve business processes and operations

Auckland, New Zealand

Responsibilities:- Provided support on issues, enquiries and requests of clients based in New Zealand and overseas.- Fixed software and integration (Xero, Magento and Unleashed API) issues and bugs.- Added functionality, performance and reporting enhancements.- Implemented functionality screens including enquiry report pages and exports (PDF and CSV formats), entry, maintenance and transactional screens.- Created and performed unit tests on different areas of the software.- Migrated data from the old to the latest version of Unleashed for some clients.

Manila, Philippines

Responsibilities:- Resolved bugs.- Implemented functionality enhancements based on client requirements.- Created test scenarios for the bug fix/enhancements made.- Created and implemented functional and technical designs for new batch applications.- Performed unit and regression testing on different areas of the software.- Conducted knowledge transfers to the team.- Implemented the company’s initiatives on employee engagement and information security.