Nicholson Valerio Email & Phone Number

Melbourne, Victoria, Australia

Australia

Australia

Melbourne, Australia

• Participate in building CrownBet's enterprise data warehouse solution • Participate in the development and translation of user requirements into specifications for complex logical data models, source data capture, dictionary design, data integrity and overall BI reporting design• Develop and support Tableau Dashboards• Create business as usual reports using SSRS to support enterprise wide reporting• Work closely with business and technical teams to define solutions• Support security and authorisation management in the BI environment• Ensure consistency between development, quality and production environment• Follow defined change management procedures

Melbourne, Australia

• Validate ETL design and ensure technical specifications are complete, consistent and achievable.• Develop ETL code as per technical specifications following the established IM processes• Proficient in data integration between Teradata and MS SQL using SSIS and handle large data volumes• Performance tuning using SSIS and SQL• Conduct Unit Testing and code reviews.

Victoria, Australia

• Provide data analysis through SQL queries for reporting purposes• Manage existing Powershell scripts to identify bugs or improvements• Enhance existing Qlikview reports• Update existing warehouse to include data from different source systems

• Manage and maintain in-house built Data Vault model data warehouse • Create SSIS packages for data transformation, cleansing, caching, aggregation, staging, and transfer. Plan and coordinate data migrations between systems• Lend support to various business and technology teams as necessary during design, development and delivery to ensure solid, scalable, robust data solutions• Development of stored procedures, functions, views, triggers, constraints, ensuring compliance to coding standards and best practices as well as maximum performance• Create deployment and rollback scripts for all database objects manually or auto-generated• Develop, implement, and maintain change control and testing processes for modifications to databases• Provide level 3 BAU support• Support resolution of data access and performance issues on test and production systems as and when required• Perform performance tuning and troubleshooting as and when required, which will require analyzing access patterns to the database and proposing the best combination of indexes, constraints, foreign keys, and queries

Singapore

• Build reports using SQL Server Reporting Services (SSRS)• Responsible for migrating data from different source systems to MS SQL for report creation using SQL Server Integration Services (SSIS)• Develop .NET applications to be used by batch jobs

• Responsible for the development, analysis & design, coding and testing of software.• Support the development, debugging and user’s acceptance testing.• Responsible for Research and Development.• Evaluate software and components.• Responsible for Research and Development.• Application support, handling and resolving customers issues (Windows/UNIX Environment).• Liaise with Data Centers for Disaster Recovery.• Supervised subordinates with individual tasks.• Authorized to give instructions for everyday’s tasks.• Workout and analyze user and application requirements.• Consult with management, staffs and customers on how work is done in an organization.• Prepare documentation and training materials and conduct application systems training.