Richard Riofrio
Specialist, Infrastructure Systems Management at City of Mississauga- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Native or bilingual proficiency
-
Spanish Native or bilingual proficiency
Topline Score
Bio
Lucy Rodionova
Richard is extremely knowledgeable developer. I worked with him on a few projects for finance department. In review sessions he proposed much more than we originally requested. He is very thoughtfull, intellegent and has very approachable personality.
Lucy Rodionova
Richard is extremely knowledgeable developer. I worked with him on a few projects for finance department. In review sessions he proposed much more than we originally requested. He is very thoughtfull, intellegent and has very approachable personality.
Lucy Rodionova
Richard is extremely knowledgeable developer. I worked with him on a few projects for finance department. In review sessions he proposed much more than we originally requested. He is very thoughtfull, intellegent and has very approachable personality.
Lucy Rodionova
Richard is extremely knowledgeable developer. I worked with him on a few projects for finance department. In review sessions he proposed much more than we originally requested. He is very thoughtfull, intellegent and has very approachable personality.
Credentials
-
ArcGIS Insights
Esri CanadaMay, 2021- Sep, 2024 -
Condominium Director Training
The Condominium Authority of Ontario (CAO)Mar, 2021- Sep, 2024 -
McGill Personal Finance Essentials
McGill UniversityMay, 2020- Sep, 2024 -
Foundation Award
The Institute of Asset ManagementOct, 2019- Sep, 2024 -
Grow with Lean Six Sigma Yellow Belt
UdemyMay, 2018- Sep, 2024 -
Lean Six Sigma White Belt
Management and Strategy InstituteMay, 2018- Sep, 2024
Experience
-
City of Mississauga
-
Canada
-
Government Administration
-
700 & Above Employee
-
Specialist, Infrastructure Systems Management
-
Jan 2020 - Present
• Research, recommend and implement new systems for Transportation and Works division• Design and configure Infor Public Sector, the City's Enterprise Asset Management software• Create, maintain and deploy Crystal Reports and publications in Business Objects Enterprise (BOE)• Document and perform user acceptance tests (UAT) • Assist in configuration, training and deployment of Infor Field Inspector• Author user guides and video tutorials for department/user training• Knowledgeable in City of Mississauga's User Fees and Charges By-law Schedule B 1 Transportation and Works Fees and Charges and Collective Agreement for Local CUPE 66• Environment: Oracle, Crystal Reports, BOE, Infor Public Sector, Sharepoint, Camtasia Show less
-
-
Specialist, Systems Technical
-
Apr 2022 - Sep 2022
Infor technical systems specialist
-
-
-
Region of Peel
-
Canada
-
Government Administration
-
700 & Above Employee
-
Building Information Analyst, Real Property Asset Management
-
Jun 2019 - Jan 2020
• Lead Real Property SME for Enterprise Asset Management • Project Manager for Real Estate system procurement• Lead for Real Property intranet transition from RedDot to SharePoint• Design lead for Real Property new interactive Power BI dashboard
-
-
Process Improvement Specialist, TransHelp
-
Jul 2018 - Jun 2019
• Build capacity across specialized transit to understand, identify and improve application processing and complaint management• Identified specialized transit complaint top 80% of problems, performed root cause analysis and recommended solutions from first call resolution to workflow and process changes. • Simplify and automate client services processes. Built interactive dashboard for management to track department workload and program key performance indicators
-
-
Business Intelligence Analyst, TransHelp
-
Nov 2016 - Jun 2018
• Developed an automated daily KPI paratransit operations dashboard • Design, build and administer a paratransit BI data warehouse for reporting and analysis• Reverse engineered transportation system (Trapeze) for data extract, transform and load (ETL)• Worked with team to develop performance indicators for service operations and quality assurance• Created BPMN (business process modeling notation) for client and admin application processing to support change management and recommend a process redesign. Applied UML (Unified Modeling Language) methodologies to design our system• Played a lead role for integration updates of Salesforce and Transportation Scheduling System (Trapeze); collaborated with IT to ensure timely and successful system updates, supported business by creating training materials and delivering training• Business technical advisor for multi-year project Salesforce and Trapeze integration• Automated data collection, preparation and report distribution• Documented, communicated and improved transportation business reporting• Enhanced team members performance through creating new systems, task automation and teaching team members how to use MS Excel and MS Access effectively• Prepared and submitted annual data for CUTA (Canadian Urban Transit Association)• Knowledgeable in Specialized Transportation, AODA, CUPE Local 966 Collective Agreement• Environment: SQL, Trapeze PASS/COM, Salesforce, Wave, MS Access/Excel/Visio Show less
-
-
Data Analyst, Health Services
-
Jan 2014 - Nov 2016
Create dashboards for user to interact with public health data. Develop and deliver business requirements, analysis and technical recommendations for Public Health, Long Term Care and Paramedic projects. • Spokesperson for public health technical and strategic initiatives• Create use case, activity and logical components to extract business process flows and workflows thereby helping IT to understand business requirements• Develop User Accepting Testing (UAT) plans and test cases based on the business requirements/System Requirements• Built ETL (Extract, Transform and Load) processes to use in Business Intelligence (BI) tools• Experience in Change Management Process (Identify, Analyze, Evaluate, Plan, Implement, Review and Close)• Experience in writing complex SQL queries involving multiple tables, inner and outer joins, stored procedures, SSIS scripts• Examples of projects delivered on time and on budget: Paramedic vehicle computer equipment retrofit, wireless solution and implementation in Long Term Care, data migration and new application implementation in Public Health• Analytical and resourceful approach to problem solving, identifying and documenting root causes and corrective actions• Performed Gap Analysis to check compatibility of existing system infrastructure and new business requirements• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Access, MS Visio, Data Warehousing concepts, web design, D3, Qlik Sense, Intellihealth • Experience with Personal Health Information Privacy and Access Act (PHIPAA) and Municipal Freedom of Information and Protection of Privacy Act (MFIPPA)• Trained in Intellihealth system and ICD-10 classification; Provided data analysis for DAD (Discharge Abstract Database) & NACRS (National Ambulatory Care Reporting System)• Working knowledge of union collective agreements CUPE, ONA, UFCW Show less
-
-
-
PRESTO card
-
Truck Transportation
-
1 - 100 Employee
-
Sr Systems Analyst, Presto Metrolinx
-
Sep 2013 - Jan 2014
PRESTO, A division of METROLINX PRESTO Applications Development Responsible for defining and reviewing technical requirements for PRESTO solution • Collaborated with system developers to build a robust payment system for Union Pearson Express • Recommend HMI/MMI changes for TVMs and other interface devices • Prepared requirements documentation on Presto website proposed changes • Performed UATs for upcoming Presto Ottawa/GTHA solution release • Environment: Microsoft Dynamics AX, MS Sharepoint, Aconex Show less
-
-
-
-
Systems Analyst, Health Services (contract)
-
Mar 2012 - Sep 2013
Responsible for process analysis, recommendation, BRD and application design/development, training and documentation • Developed a customizable public survey application to deliver a high quality customer service experience. Used OOP approach to build class objects for clients, surveys and user activities. Designed business process maps, workflow diagrams in MS Visio, and created technical data design and support documentation • Restructured internal facility inspection Crystal Reports for performance and flexibility. Rewrote/optimized functions and setup combination filters; redesigned reports to allow for quicker data returns and accurate data reporting • Designed and created an OHISS file clean up utility for Dental Care. Uses a flat file spec to import school board files into a DB and then run various automated SQL update statements to clean up the student data and prepare it for OHISS imports • Re-engineered traditional handwritten whiteboard for Paramedics to new vehicle/paramedic scheduling software application for Paramedics Services. User interface and database architecture built in MS Access, but also created XML/XSL pages to allow for accessible data on the road. Prepared UAT scripts and supporting documentation for training • Assessed Long Term Care facilities business requirements for policy KPI's. Conducted gap analysis and made technical recommendation for adoption of PCC CQI module already purchased and owned but not used by region. This centralized reporting across all LTC homes and allowed management to setup and track KPI’s • Assisted Project Manager in technical design of centralized scheduling application using MS Outlook for Health Babies Healthy Children dept • Technical Analyst involved in IRIS to Panorama transition project. Created and executed cleanup scripts for IRIS Visual FoxPro tables • Environment: VBA, MS Access 2003, HTML, JavaScript, HTML Help Compiler, AD, Crystal Reports, SQL, PointClickCare, FoxPro Show less
-
-
-
-
Treasurer
-
2008 - May 2013
Abide by standard accounting practices, condominium rules and declaration, and Condominium Act, 1998, S.O. 1998, c. 19 • Prepare and review contracts for condominium maintenance • Designed a Google Sites area for document sharing, polls, and announcements relating to condominium activities • Developed and prepared Google documents and shared on TSCC1560 Google Site from financial statements, fund statements, general ledger and projects for TSCC1560. Abide by standard accounting practices, condominium rules and declaration, and Condominium Act, 1998, S.O. 1998, c. 19 • Prepare and review contracts for condominium maintenance • Designed a Google Sites area for document sharing, polls, and announcements relating to condominium activities • Developed and prepared Google documents and shared on TSCC1560 Google Site from financial statements, fund statements, general ledger and projects for TSCC1560.
-
-
-
-
Business Operations Developer III
-
Apr 2001 - Mar 2012
Senior Developer responsible for SDLC, development lead and project management of software applications • Lead Developer for Canadian end-user billing applications using VB.NET and SQL 2008 R2. Developed technical standard for environmental levy billing for electronic goods sold • Design, developed and managed a multi level Tier1 automated job scheduling system through various iterations of SDLC • Created an environmental levy tracking and reporting system in VB.net. Led corporate development team to transition business process tier into mainframe • Managed a development project for an automated secure ftp server utility to read/download XML sales bid files from external vendors in real-time. Created a user interface for sales reps to trigger customized customer quotes and sales orders creation from the XML data processed; this equated to multi product/thousand dollar value orders created in a fraction of minutes • Designed corporate asset tracking application; enabling management to analyze Days Of Supply, buying trends and PM compensation • Designed and performed UATs and recommended solutions for corporate rollouts of SQL Server, O/S and corporate application upgrades • Environment: VB .Net, .Net Framework, VB 6, SQL 2000/05, XML, HTML, DHTML, JavaScript, VBA. MS Access 97 - 2010, SAP, BEx, FTP, Crystal Reports, Visual FoxPro, DB2, Shell Scripting, Stored Procedures, SSIS Show less
-
-
-
Patheon
-
United States
-
Pharmaceutical Manufacturing
-
700 & Above Employee
-
Systems Administrator
-
Nov 2000 - Mar 2001
Administrator for laboratory servers, computers and equipment • Installed and ISO compliance tested all laboratory PC’s with new Agilent software in Mississauga and Burlington locations • Setup new Oracle server to manage incoming data from laboratory systems • Performed data backups for laboratory server • Designed a remote application to retrieve server usage logs to ease with preparation of FDA reports • Received training to troubleshoot lab equipment: HPLC, LC, UV-Vis and other lab analysis systems. Handled all Tier1 support calls • Environment: Oracle 8i, MS Access, MS Excel Show less
-
-
-
Norigen Communications Inc
-
Technology, Information and Internet
-
Analyst
-
Sep 2000 - Oct 2000
Transitioned sales opportunity tracking MS Excel spreadsheet to a robust and secure MS Access database environment Transitioned sales opportunity tracking MS Excel spreadsheet to a robust and secure MS Access database environment
-
-
-
-
Information Analyst
-
Nov 1999 - Sep 2000
Assumed coverage of North American (US/Canada) reporting in 1999• Collaborated in team development of sales reporting and forecasting applications using Oracle and Crystal Reports• Ad-hoc reporting from Oracle data warehouse
-
-
Quality Assurance Specialist
-
Dec 1996 - Oct 1999
• Successfully converted various logistics applications to comply to Y2K standards• Developed a quality of work tracking application. Measured user productivity and product life cycle from receiving, put away, to picking, packing and shipping and returns• Implemented new automated method of employee time tracking and absenteeism; reduced data entry and improved data accuracy• Provided technical support for Logistics equipment: RF scanners and thermal printers• Managed and updated Unix logistics productivity report scripts Show less
-
-
Education
-
2019 - 2019
The Institute Asset Management
Asset Management Awareness -
2017 - 2017
Trapeze
Para Transit -
2016 - 2016
ESRI Canada
ArcGIS 10.3 -
2015 - 2015
OLTCA conference
Ontario Long Term Care Association conference -
2014 - 2014
Microsoft
SQL 2014 and Power BI -
2014 - 2014
York University
Wireless & Wearable Health Technology Symposium -
2014 - 2014
York University - Schulich School of Business
Project Management for Healthcare and Social Services -
2009 - 2009
Microsoft Tech Days
Windows 7, SQL and SharePoint -
2002 - 2003
Ryerson University
Web Application Developer -
1995 - 1996
CDI College
Diploma, Programmer/Analyst
Community
