Software and Database Syst Analysis, Architecture, Research & Develop
Resume:
Personal Ricardo Jorge Ribeiro dos Santos
Information:
[pic] Rua Quinta de S. Joao, 84 - 3460-210 Molelinhos - Molelos - Tondela
Portugal (Note: I lived in Toronto - Canada for 8 years and have Canadian citizenship, although I am Portuguese)
************.*******@*****.***
Sex Male Date of birth 29/05/1972
Nationality Portuguese (with Canadian citizenship)
Educational Details:
Sep/2010 to Jul/2013: PhD in Information Science and Technology -
Doctorate Degree
***
Result: Subjects: Inf. Systems, Biosignal Analysis and Processing,
Large Scale Concurrent Systems, Advanced Data Analysis and
Processing
Course Grade: 16 out of 20
PhD Dissertation on Enhancing Data Security in Data
Warehouses
Thesis/Dissertation Grade: due September/2013
Sep/2004 to Dec/2007: MSc in Inf. Systems and Decision Support Systems -
Masters Degree
***
Result: Subjects: Research Methods, Project Management, Enterprise
Management, Enterprise Information Systems, Data
Warehousing, Decision and Risk Analysis Theory, Artificial
Intelligence and Knowledge Extraction in Databases
Course Grade Average: 16 out of 20
Master Thesis on Real-Time Data Warehousing
Thesis/Dissertation Grade: Approved with distinction
Sep/1998 to Sep/2001: Lic. in Informatics Engineering - Engineering Degree
***
Result: Subjects: Statistical Methods, Simulation and Optimization,
Teleprocessing, Artificial Intelligence Applications,
Robotics, Operational Research, Math Complements, Database
Applications, Graphs and Algorithms Theory, and Financial
Management
Course Grade Average: 15 out of 20
Course Final Project: Software Development Project for the
Design of Electrical Resistances for Telecommunication
Companies
Final Project Grade: 20 out of 20
Sep/1990 to Jul/1994: BSc in Computer Science, field of Systems Analysis
and Programming - Bachelors Degree
***
Result: Subjects: Linear Algebra and Analytical Geometry, Computer
Programming, Applied Physics, Math, Algorithms, Data
Structures, Statistical Methods, Systems Analysis,
Automation and Control, Production Management, Logical and
Digital Systems, Exploration Systems, Business Economy,
Data Processing, Transports and Distribution,
Teleprocessing and Networks, Commercial Management,
Industrial Management, Databases, Computer Assisted
Projects
Course Grade Average: 15 out of 20
Course Final Project: Software Development Project
focusing on Industrial Production Management for a Large
Company of the Ceramics Industry
Final Project Grade: 18 out of 20
Relevant Experience:
Sep 1994 to Present ***
Software and Database Systems Analyst, Architect &
Developer
For several small, medium and large sized companies
. Consultant, Analyst, Architect and Developer of Intranet and Internet
Front-End and Back-End Software Systems, Applications and Solutions
for well-defined business contexts (such as stock market analysis,
customer-relation management, viral and social marketing management,
data mining, data ETL management, school management, etc)
. Functional Analysis, Hardware and Software Requirements and
Specifications, Solution Design and Planning, Application and Web
Development, Programming, Unit Tests / Integrated Tests, Production
Monitoring, Documentation, Installation, Configuration, Maintenance,
User Instruction, Follow-up meetings
. Software Engineering (both for developing OLTP and OLAP solutions from
scratch and/or performing EAI with legacy systems)
. Data Architect and Database Administrator with the development of
OLTP operational databases along with a ETL Data Warehouse and
Business Intelligence tools and applications
. Technologies used in this role include: Delphi, VB6, VB.NET, ASP,
ASP.NET, PHP, HTML5, CSS3, Javascript, VBScript, SQL (including PL/SQL
and T-SQL), XML, Java, C#, Dreamweaver, Eclipse, NetBeans, Wix,
WordPress, .NET, prototype.js, jquery, etc. Oracle, SQL Server,
MySQL, Access, dBase, Paradox. Agile, Scrum, Microsoft Office,
Enterprise Architecture, BPMN, BPEL, VMWare, Data Mining Techniques
(frequent itemsets, clustering, SVM, etc)
Jan 2004 to Present ***
Researcher in Software and Database Systems
CISUC - Center of Informatics and Systems of the Univ. of
Coimbra
Software and Systems Engineering Research Group
. Active research work, belonging to the Systems and Software
Engineering research group of the Centre of Informatics and Systems of
the University of Coimbra (CISUC). I have published 21 papers and 2
book chapters since 2004, in the fields of Real-Time Data Warehousing,
Data Warehouse Optimization, Data Security in Data Warehousing, Health
Information Systems and Business Intelligence.
. A list of my publications is attached further on, which can be checked
through the following web links:
. DBLP: http://www.informatik.uni-
trier.de/~ley/pers/hd/s/Santos:Ricardo_Jorge.html
. CISUC: https://www.cisuc.uc.pt/people/show/2229
. Technologies used in this role include: Delphi, VB6, VB.NET, ASP,
ASP.NET, PHP, HTML5, CSS3, Javascript, VBScript, SQL (including PL/SQL
and T-SQL), XML, Java, C#, etc . Dreamweaver, Eclipse, NetBeans, Wix,
WordPress, .NET, prototype.js, jquery, etc. Oracle, SQL Server,
MySQL, Access, dBase, Paradox. Agile, Scrum, Microsoft Office,
Enterprise Architecture, BPMN, BPEL, VMWare, ERWin, diverse
Wireframing applications, Data Mining Techniques (frequent itemsets,
clustering, SVM, etc).
Jan 2004 to Dec 2010 ***
Project Leader/Manager for the Development of Industrial
Production Management Systems
For CIFIAL Cer mica, S.A. (ceramics industry belonging to
the CIFIAL Business Group, a large business group in
Portugal)
. Information Systems Architecture and Development for Production
Management.
. Project Leader/Manager and Software Engineer.
. Team Leader (team with 3 developers).
. Development of Industrial Production Management Hardware and Software
System Infrastructures.
. Functional Analysis, Hardware and Software Requirements and
Specifications, Solution Design and Planning, Application and Web
Development, Programming, Unit Tests / Integrated Tests, Production
Monitoring, Documentation, Installation, Maintenance, User
Instruction, Follow-up meetings
. Developed IS included hardware and software infrastructures for
managing plant control, breakdowns, maintenance, MRP, production order
management, production maps and monitoring, integration with SAP, etc.
. Data Architect and Database Administrator with the development of OLTP
operational databases along with a ETL Data Warehouse and Business
Intelligence tools and applications.
. Technologies used in this role include: Delphi, VB, ASP, MySQL.
Jan 2000 to Dec 2003 ***
CEO and Director of the Department of Software and Systems
For GLOBALWARE, Lda. (a small-sized IT company in
Portugal)
. CEO and Director of the Software and IS Development Department.
. Executive Management.
. Director of the Software and Systems Department, responsible for
developing, maintaining and evolving both standard-based and specific
solutions for commercial and industrial enterprises in diverse fields
(General retail sales, Ceramics industry, Insurance, Governmental
entities, etc).
. IS Architecture and Development.
. Team Leader (team with 3 developers).
. Consultant, Architect and Developer of Intranet and Internet Front-End
and Back-End Software Systems, Applications and Solutions.
. Functional Analysis, Hardware and Software Requirements and
Specifications, Solution Design and Planning, Application and Web
Development, Programming, Unit Tests / Integrated Tests, Production
Monitoring, Documentation, Installation, Configuration, Maintenance,
User Instruction, Follow-up meetings.
. Software Engineering (both for developing solutions from scratch
and/or EAI with legacy systems).
. Data Architect and Database Administrator.
. Development of solutions for both standard-based and specific
solutions for commercial and industrial enterprises in diverse fields
(OLTP + ETL Data Warehousing and BI analytical tools).
. Technologies used in this role include: Delphi, VB, HTML, Javascript,
VBScript, CSS, ASP, PHP, MySQL, SQL Server, Oracle.
Oct 1993 to Dec 2000 ***
Software Solutions Development Manager & Sub-Director of
the IT Department
For SECLA, S.A. (a large-sized portuguese company from the
ceramics industry)
. IS Architecture and Development.
. Team Leader (team with 2 developers).
. Analysis, development, maintenance and evolution of integrated
software applications and database management for the whole
factory/company (industrial production management, provision and stock
management, order management, sales, invoicing, cash flow, accounting,
customer care, etc).
. Functional Analysis, Hardware and Software Requirements and
Specifications, Solution Design and Planning, Application and Web
Development, Programming, Unit Tests / Integrated Tests, Production
Monitoring, Documentation, Installation, Configuration, Maintenance,
User Instruction, Follow-up meetings.
. Software Engineering (both for developing solutions from scratch
and/or EAI with legacy systems).
. Data Architect and Database Administrator.
Major Projects:
. 21 research papers published in Class A and B International
Conferences in Real-Time Data Warehousing, Data Security for Data
Warehousing, Data Warehousing Performance Optimization, Business
Intelligence, and Medical Information Systems.
. GCOM Euro - Commercial Management System. General Purpose: Standard
software suite for generic retail sales companies. Description:
Includes integrated modules for managing suppliers and purchasing,
stocks, customer sales and invoicing, supplier and customer budgeting
and ordering, returns, etc.
. CPROD - Industrial Production Management System. General Purpose:
Specific software suite for managing industrial production lines of
companies belonging to the ceramics industry. Description: Includes
integrated modules for managing products and their families,
production results, breakdowns, defects control, workers, individual
worker production control, production order management, backup and
restore, etc.
. GEscolar - Integrated School Management System. General Purpose:
Specific software suite (back-office, front-office and POS) for
managing operational aspects in schools and institutional website with
linked operational functionalities. Description: Includes integrated
front-office, back-office and website modules for managing students,
teachers, classes, school cards, bar, photocopies, borrowing and
returning books and educational resources, meal vouchers, booking of
classrooms and school resources, grades, fieldtrips, secretariat,
expense and income maps, institutional information, schedules,
communications, etc.
. GestHotel - Hotel Management System. General Purpose: Standard
software suite for hotel management operational functionalities.
Description: Includes integrated front-end and back-end intranet and
internet modules for managing guests, price lists, booking, check-
in/check-out, room maintenance, bar, room service, invoicing, expense
and income maps, customer accounting, etc.
. HTP Tool - A Hypotension Monitoring and Prediction Medical Information
System. General Purpose: A back-office + front-office medical system
with mobile functionalities for monitoring and predicting hypotension
for critical-care patients. Description: A HT Predictor (HTP) system,
presenting a set of tools and a real-time database for continuous real-
time monitoring of each patient's historical heart rate and blood
pressure data, and efficiently alerting both detected and forecasted
hypotensive episodes in the next 60 minutes. Additionally, the system
promotes medical staff mobility by taking advantage of using mobile
personal devices such as mobile phones and PDA's.
. Perijoias - Jewellery Sales Webiste. General Purpose: A jewellery
sales website. Description: Online jewellery catalogue, novelties,
promotions and customer ordering.
. Other developed projects:
Standard and Specific Software Solutions
. Stock market analysis and portfolio management
. Industrial maintenance management
. Bank accounts management
. Library management
. Video store management
. Insurance management
. Law office management system
. Accounting
. Customer-care management
. CRM
. Commercial real-time business intelligence
Research and Software Prototypes
. Benchmark development and administration (TPC-H, TPC-DS, other Data
Warehouse performance and security testing, etc)
. Data masking and encryption solutions
. Database intrusion detection systems
. Database backup & recovery
. Real-time data warehousing with 24/7 availability
. Query cache tool for data warehouses
Websites
. Hotel website
. Electric company website
. Cultural institution website
Technical Skills:
. Vast experience and excellent skills in software development (AGILE,
Scrum, etc) of front-end and back-end software with ASP, HTML, CSS,
Javascript, VBScript, Delphi, VB, VB.NET, ASP.NET, C#, ADO.NET, XML in
intranet and internet environments.
. Vast experience and excellent skills in data architecture/design, data
modelling, SQL programming (including T-SQL and PL/SQL), database
administration, performance optimization, triggers, procedures and
functions, indexing, partitioning, materialized views, etc. using DBMS
Oracle (9, 10, 11), SQL Server (2000, 2005, 2008), MySQL (4, 5), etc.
. Vast experience and excellent skills using several diverse platforms
and development tools such as ERWin, Dreamweaver, WordPress, Wix,
SQL*Developer, Crystal Reports, jQuery, prototype.js, backbone.js,
Visual Studio, JSON, etc.
. Vast experience and excellent knowledge in analysis and development of
transactional (OLTP) and decision support (OLAP, ETL, BI, Data
Warehousing) systems.
. Vast experience and excellent skills in face-to-face with customers
and management for executing functional business analysis, IT/IS
architecture, systems analysis, determining requirement and
specifications, solution design, software engineering, systems
maintenance and evolution, EAI, optimization, follow-up meetings, etc.
. Experience and skills in developing real-time data warehousing
solutions.
. Experience and skills in developing data security solutions such as
encryption and database intrusion detection systems.
. Considerable knowledge and experience with PHP, Java, Python, Perl,
AJAX, Silverlight, MySQL Workbench, Eclipse, Paint Shop Pro,
Photoshop, Clementine, SPSS, BPEL, BPMN, Enterprise Architecture
(Zachman, TOGAF, Gartner).
. Experience using server administration tools like IIS, ActiveHTML,
Apache, Windows Server, etc.
Additional Skills:
Excellent reader, speaker and writer in English and Portuguese.
Well developed interpersonal skills.
. Excellent organisation skills.
. Logical and focused, ability to work under pressure and meet
deadlines.
. Vast troubleshooting experience.
. Excellent and proven communications skills.
. Excellent project management and team leadership skills.
Interests and Achievements:
Computers and technology.
Football, travel, reading, film, music and television.
. I have a keen interest in music, especially piano.
. I hold a full, clean driving licence.
References:
Prof. Dr. Jorge Bernardino - Professor of the DEIS of the Superior
Institute of Engineering of Coimbra (ISEC) (*****@****.**).
Prof. Dr. Pedro Furtado - Professor of the DEI of the Faculty of
Science and Technology of the University of Coimbra (FCTUC)
(***@***.**.**, ****************@*****.***).
. Prof. Dr. Marco Vieira - Professor of the DEI of the Faculty of
Science and Technology of the University of Coimbra (FCTUC) and
Responsible of the Systems and Software Eng Research Group - Center of
Informatics and Systems of the Univ. of Coimbra (CISUC)
(*******@***.**.**).
. Prof. Julio Valente - Director of Escola Secundaria de Tondela
(**.*****.*******@*****.***)
. Prof. Dra. Rosa Carvalho - Director of Instruction Center CFAEPB
(******************@*****.***)
. Eng. Ant nio Cancela - Industrial Production Director of CIFIAL
Ceramica (*******.*******@******.**)
. Lic. Adelino Ferreira - General Manager of the Retail Sales Market
Stores Chain Carlo's, in the Tondela area, Portugal
(***********@*****.***).
Published Research:
Publications in Real-Time Data Warehousing (6 conference papers)
. Ricardo Jorge Santos, Jorge Bernardino and Marco Vieira, "Leveraging 24/7
Availability and Performance for Distributed Real-Time Data Warehouses",
in COMPSAC 2012 - IEEE Signature Conference on Computer Software &
Applications, Izmir, Turkey, 2012.
. Ricardo Jorge Santos and Jorge Bernardino and Marco Vieira, "24/7 Real-
Time Data Warehousing: A Tool for Continuous Actionable Knowledge",
in COMPSAC 2011 - IEEE Signature Conference on Computer Software &
Applications, Munich, Germany, 2011.
. Ricardo Jorge Santos and Jorge Bernardino, "Optimizing Data Warehouse
Loading Procedures for Enabling Useful-Time Data Warehousing", in IDEAS
2009 - International Database Engineering & Applications Symposium,
Cetraro, Calabria, Italy, 2009.
. Ricardo Jorge Santos and Jorge Bernardino, "Real-Time Data Warehouse
Loading Methodology", in IDEAS 2008 - Int. Database Engineering &
Applications Symposium, Coimbra, Portugal, 2008.
. Ricardo Jorge Santos and Jorge Bernardino, "A continuous data
integration methodology for supporting real-time data warehousing", in
ICEIS 2007 - International Conference on Enterprise Information Systems,
Funchal, Madeira, Portugal, 2007.
. Ricardo Jorge Santos and Jorge Bernardino, "Methodologies for
Implementing Real Time Data Warehouses", in Data Gadgets 2004 - Bringing
Up Emerging Solutions for Data Warehousing Systems, Malaga, Spain, 2004.
Publications in Data Security for Data Warehousing (7 conference papers and
1 book chapter)
. Ricardo Jorge Santos, Deolinda M. L. Rasteiro, Jorge Bernardino and Marco
Vieira, "A Specific Encryption Solution for Data Warehouses ", in DASFAA
2013 - International Conference on Databases Systems for Advanced
Applications, Wuhan, China, 2013.
. Ricardo Jorge Santos, Jorge Bernardino and Marco Vieira, "Evaluating the
Feasibility Issues of Data Confidentiality Solutions from a Data
Warehousing Perspective", in DAWAK 2012 - International Conference on Data
Warehousing and Knowledge Discovery, Vienna, Austria, 2012.
. Ricardo Jorge Santos, Jorge Bernardino and Marco Vieira, "DBMS
Application Layer Intrusion Detection for Data Warehouses", in ISD 2012 -
Information Systems Development, Prato, Florence, Italy, 2012.
. Ricardo Jorge Santos, Jorge Bernardino and Marco Vieira, "Securing Data
Warehouses from Web-Based Intrusions", in WISE 2012 - Int. Conference on
Web Information Systems Engineering, Paphos, Cyprus, 2012.
. Ricardo Jorge Santos and Jorge Bernardino and Marco Vieira, "A Survey on
Data Security in Data Warehousing", in EUROCON 2011 - Int. Conference on
Computer as a Tool, Lisbon, Portugal, 2011.
. Ricardo Jorge Santos and Jorge Bernardino and Marco Vieira, "A Data
Masking Technique for Data Warehouses", in IDEAS 2011 - International
Database Engineering & Applications Symposium, Lisbon, Portugal, 2011.
. Ricardo Jorge Santos and Jorge Bernardino and Marco Vieira, "Balancing
Security and Performance for Enhancing Data Privacy in Data Warehouses",
in TRUSTCOM 2011 - IEEE International Conference on Trust, Security and
Privacy in Computing and Communications, Changsha, China, 2011.
Publications in Data Warehouse Performance Optimization (3 conference
papers)
. Ricardo Jorge Santos and Jorge Bernardino, "A Bit-Selector Technique for
Performance Optimization of Decision Support Queries", in ICEIS 2009 -
International Conference on Enterprise Information Systems, Milan, Italy,
2009.
. Ricardo Jorge Santos and Jorge Bernardino, "A Query Cache Tool for
Optimizing Repeatable and Parallel OLAP Queries", in DEXA 2009 -
International Conference on Database and Expert Systems Applications,
Linz, Austria, 2009.
. Ricardo Jorge Santos and Jorge Bernardino, "PIN: A partitioning and
indexing optimization method for OLAP", in ICEIS 2007 - International
Conference on Enterprise Information Systems, Funchal, Madeira, Portugal,
2007.
Publications in Business Intelligence (1 paper)
. Ricardo Jorge Santos and Jorge Bernardino, "Intelligent Commerce
Architecture for Real-Time Business Processes", in CAPSI 2004 -
Conferencia da Associacao Portuguesa de Sistemas de Informacao (Conference
of the Portuguese Association of Information Systems), Lisbon, Portugal,
2004.
Publications in Health Information Systems (4 conference papers and 1 book
chapter)
. Ricardo Jorge Santos, Jorge Bernardino and Jorge Henriques, "The HTP
Tool: Monitoring, Detecting and Predicting Hypotensive Episodes in
Critical Care", in EUROCON - International Conference on Computer as a
Tool, Lisbon, Portugal, 2011.
. Ricardo Jorge Santos and Jorge Bernardino and Henriques, J., "A 24/7
Monitorization Tool for Avoiding Hypotensive Episodes in Critical Care",
in IDEAS 2010 - International Database Engineering & Applications
Symposium, Montreal, Canada, 2010.
. Ricardo Jorge Santos and Jorge Bernardino, "Global Epidemiological
Outbreak Surveillance System Architecture", in IDEAS 2006 - Int. Database
Engineering & Applications Symposium, New Dehli, India, 2006.
. Ricardo Jorge Santos and Jorge Bernardino, "Information system
architecture for global epidemiological surveillance", in EHMA 2005
(European Health Management Association) Annual Conference, Barcelona,
Spain, 2005.
Contact this candidate