Lui Randall Vidal Email & Phone Number

Adelaide, Sa, Au

Adelaide, South Australia, Australia

- Involved in the cost optimization process of various data pipelines in Azure Data Factory by introducing parameterized Databricks cluster - Involved in the PowerBI data model revamp that removed SQL DB dependency and drove cost savings to the client- Responsible for data ingestion from disparate data sources using a combination of Azure Data Factory, Logic App and Databricks- Migrated validation scripts used in T-SQL to Databricks- Created delta tables in Databricks to be used in Power BI

- Created Implementation plans, release details and schedules to the business - Provided all end-to-end EDW and BI enhancements, managing the design, development and delivery of ETL and BI components- Acted as development lead during release cycles- Performed code reviews to ensure quality and requirements are met- Attended project meetings to determine impacts from upstream and work with stakeholders on requirements, ensuring reporting and downstream needs are considered- Created and maintained the necessary queries to produce requisite data for reporting using Oracle BIP

- Created and applied fixes to existing SSIS packages in production- Created SSIS packages as necessary- Created and applied fixes to existing reports (SSRS) in production- Performed query optimization on existing stored procedures that are used by SSRS reports- Monitored daily processing of SSAS cubes- Monitored daily ETL jobs running in production servers- Monitored Azure Web services running in both production and test environments- Managed Azure Storage - Configured SQL Azure Database backup job schedules- Created daily status reports of ETL jobs that are submitted to clients- Conducted application trainings with clients upon request- Created fix for packages, stored procedures and views deployed in the Production Environment using Oracle PL/SQL- Created fix for views that are being used in Qlikview Reports

- Maintained Corporate Information System - Processed Monthly and weekly data coming from different distributors and customers of UNILAB nationwide. - Provided support to Professional Sales Representatives' and District Managers' access to the system- Configured yearly territorial configuration for each division of UNILAB. - Debugged and fixed existing SSIS packages that are used in processing Monthly and weekly data - Created SSIS packages for migrating data in various projects

Performed Data Migration to Clients- Performed Third Party Conversion and Database Upgrades to Navitaire's Clients- Ensured data are accurate and complete during and after Client's Data Migration- Set up and maintained Replication of databases during Migration process- Created Check Scripts and Fix Scripts if necessary- Developed new process of Converting data of Third Party Clients using SSIS (SQL Server Integration Services)- Took ownership of the project especially during the Development Phase- Performed team initiatives by enhancing and optimizing scripts and creating documentations regarding new processesCommunicated with Client and other Project Stakeholders- Coordinated with other Project Members (Project Manager and Business Analysts) to ensureClient's data are migrated in line with their Business Requirements- Coordinated with other Development teams to ensure Client's issues are resolved/fixed as soon as possible- Provided support(Pre-Migration and Post-Migration) to clients by developing and delivering fixes for issues to ensure successful UAT Cycles and cutovers- Coordinated with DBAs during Client's UAT to ensure successful Data Refreshes

Bachelor Of Science (B.S.), Computer Science

Activities and Societies: Association for Computing Machinery Member

Education record