Robert Perez Email & Phone Number

Port Moody, BC, CA

Planned, designed, developed and managed the data warehouse architecture, data acquisition, and business intelligence functions. Oversaw policy and standards development, ensuring data and reporting is organized to maintain coherence, availability, quality and integrity to meet the information needs of the ministry.

Vancouver, BC, CA

• Developed Data Science models and frontend dashboards in PowerBI and Microsoft Azure Databricks in Python to provide timely data to business users, thereby assisting in their data experimentation process.
• Optimized system and platform performance capabilities in the most efficient way possible, thereby improving report performance by around 25%.
• Solved challenging data integration problems, utilizing optimal extraction transformation load patterns to reach resolutions.
• Assessed programs to identify risks or problems to determine appropriate responses.
• Provided primary operational support for high-volume financial institution in 24/7 uptime environment.
• Developed CI/CD DevOps release processes to assist in deployment of Databricks, Microsoft ADF pipelines and Data Warehouse code.

San Jose, California, US

• Managed a QA framework using Fitnesse/TestNG/Selenium against Firefox, Chrome and Internet Explorer, as well as various MySQL Enterprise databases.
• Designed and implemented various automated test cases covering all aspects of the company’s API management portal/gateway application, including UI, security and database QA.
• Optimized test cases to run within specific specified runtime thresholds, thereby reducing the runtime of many test cases by half.
• Defined and designed overall QA process, thus ensuring consistency of testing workflow and maximizing test case efficiency.
• Produced testing framework documentation for internal and external audiences as required.
• Mentored and trained new staff on testing framework as required.

• Provided independent IT consulting to various small, local clients.
• Modeled and designed web database applications in MySQL and PHP, translating their requirements into technical solutions.
• Used agile software development methodology to deliver applications in half the time of traditional software development environments.
• Liased with clients on a regular basis to ensure that applications continue to meet their ever-changing requirements.

• Managed a QA framework in Testlink, SQL Server/MySQL, SQL/C# to design and implement test cases for the deployment of Automated Passport Control (APC) kiosks at the Vancouver International Airport (YVR) for US Customs.
• Tested the integration of 3M passport scanners, Crosspointe FBI-approved fingerprint readers and other equipment to kiosk systems running on SQL Server 2008/2012 database servers.
• Translated APC kiosk text from English to French, Spanish and German.

• Designed and executed database design, performance and data conversion test cases for a major project converting terabytes of insurance plans and claims data from IDMS and Oracle legacy systems to a SQL-Server based.
• Analyzed functional design and SQL code to create and execute relevant test cases for all new and updated functionality in the data conversion process.
• Optimized SQL code and databases by utilizing efficient indexing strategies, resolving database locking conflicts and analyzing required data, thereby improving performance by as much as 50%
• Automated comparisons and synchronization of large database tables between legacy and target systems
• Managed test cases and defects, providing required feedback to developers and business analysts as needed.
• Documented test results, finalized closure activities and ensured defects are correctly identified, resolved, escalated and fixed.

• Managed SQL Server and Raiser’s Edge development, support and training to users of fundraising applications on data import/export, reporting, performance, data integrity and integration with third-party systems.
• Maintained and tested Raiser’s Edge SQL Server OLTP databases, as well as other satellite databases, thus enhancing performance by an average of 10%, and maintained backups, security and data integrity
• Modeled and developed a data warehouse and a OLAP/MDX with SSRS/ASP.NET and UML, helping users carry out various data management tasks using a more streamlined interface, and used SSIS to carry out needed ETL loads
• Liaised with user representatives and internal staff to gather reporting and data update requirements and translate them into tangible results quickly and within budget.
• Led a team of developers in designing and implementing the appropriate reporting and data warehousing deliverables to internal clients, thereby managing resources, priorities and schedules in an efficient manner.
• Designed, implemented and maintained a data warehouse using SSIS and SSAS to generate summary financial fundraising and campaigning information for reporting and modeling purposes.

Redwood City, CA, US

• Responsible for providing advanced database development and support (SQL, T-SQL, PL/SQL) for many of the company’s clients, primarily using Oracle 10g/11g and Microsoft SQL Server 2000/2005/2008.
• Analyzed clients’ database technical and performance issues and provided innovative solutions, using T-SQL and PL/SQL scripts, Oracle Forms/Reports and stored procedures, providing increased client satisfaction
• Trained clients on Halogen’s web application solutions and database maintenance, helping them optimize their database processes and improve efficiency by as much as 40%
• Assisted DBA group in backups, tuning/optimization and clustering/replication for high availability
• Performed automated data transformation services for different clients using DTS or SSIS from Oracle or Excel files with XML to SQL Server databases, or vice versa.
• Carried out regression test cases and automated data transformation services for different Halogen clients using DTS or SSIS from SQL Server to Oracle databases, or vice versa.

Morristown, New Jersey, US

• Provided database design and software development services for various VOIP telephony application databases.
• Designed and implemented OLTP database schemas and data access layers for IP telephony applications using ERWIN and UML, and various database technologies, mainly in Oracle and MySQL using SQL or PL/SQL scripts.
• Monitored and analyzed performance of said databases by analyzing appropriate indexing, tablespace allocation and query tuning strategies.
• Designed an automated VOIP telephony-testing framework using SIPUnit/HTTPUnit to test application performance under simulated call loads.
• Implemented a SQL testing tool using OO Perl to assist in performance tuning of SQL or PL/SQL statements and inserting SIP test data.
• Developed a common database access layer with plug-and-play architecture for VOIP telephony applications using Java DAO design patterns, Hibernate and SQL scripts using several database servers, thus reducing project.

CA

• Responsible for designing and developing web-based portals in SQL and Java/J2EE for different government departments, as well as modelling, designing and administering the databases (Oracle, MS SQL Server 2000).
• Planned, designed, implemented and maintained the web portal database schema using ERWIN and Oracle 8i
• Developed and implemented the portal and content management system using Java/J2EE using the BEA Weblogic Server platform and ASP/VB using IIS, as well as Microsoft SQL Server 2000
• Devised a new user security model, which became a standard for future web applications.

Ottawa, On, CA

• Taught operating systems (Windows, UNIX), computer programming (Java, C++, Perl, PHP) and relational database courses (Oracle, MySQL, MS SQL Server) for the college’s Advanced Technology department.
• Developed and upgraded curriculums as needed, thus ensuring students are up-to-date with the latest course materials and tools in the IT industry
• Planned and designed a variety of activities to help students gain the analytical thinking and problem-solving skills, allowing them to support the day-to-day operation of an enterprise's software systems or in the.
• Provided students lab sessions to help students learn the different development tools and debugging techniques used to design, code and test integrated applications and software systems
• Provided assistance to students during office hours and via electronic communications using the Moodle Learning Management System as needed
• Designed and marked a variety of assignments to assess student learning of the material.

• Responsible for software and database development in many projects using languages such as Java, SQL, Perl, C++, Informix-4GL, in many different database platforms, such as Informix, MySQL and Oracle.
• Led and trained a team of developers in the development of a Java-based Weblogic portal
• Maintained different web-based e-commerce web sites in OO Perl or Java using MySQL databases
• Maintained and enhanced an online purchasing Informix database deployed worldwide within Nortel, providing second-level support when needed and enhancing customer satisfaction.

Master’S Degree, Distance Education

Certesl, English As A Second Language

Bachelor Of Commerce Honours, Management And Information Systems