RAFAEL PRAXEDES SOARES

email: ac47eu@r.postjobfree.com

Linkedin: http://ca.linkedin.com/in/rafaelpraxedes

Phone: +1-604-***-****

Vancouver, BC

SUMMARY OF QUALIFICATIONS

Business Systems Analysis: over 15 years of experience working with several clients (over 50) and industries (manufacturing: 6 years; health care: 2 years; wholesales: 2 years, finances: 1 year, retail: 6 months). Extensive knowledge in system integration (ERP and applications), system transformation (legacy to new systems), system modeling (UML, OOD, E/R, RUP, Requirements Management) and process management (BPM).

IT Project Management: over 10 years of experience working in more than 70 projects. Most of projects (80%) were delivered achieving the main parameters (scope, time and cost) and stakeholder satisfaction. Certified PMP (Project Management Professional) of PMI (Project Management Institute).

Team Leadership: extensive experience building and leading teams. Also, great experience (around 7 years) in leading projects and teams through SCRUM and Agile Methods.

IT Management: Full management experience of IT business operations (projects and services) in IT Company. Management of an infrastructure software’s team in complex client’s environments.

Development: over 18 years of experience: advanced skills in SQL and Oracle PL/SQL. Good experience in Microsoft (VBA, Visual Basic, and SQL Server). Good understanding of Web Development (JavaScript, HTML 5, CSS, jQuery, Bootstrap). Very good knowledge of Object-oriented programming (OOP).

Software Process: Manager and main business analyst of implementation of model CMMI level 2. Implementation of process improvements and of best practices in software development (CMMI, Agile, SCRUM, SDLCs, UML, RUP, BPM, SOA);

Languages: Portuguese native speaking and English as a second language.

PROFESSIONAL EXPERIENCE

Manage Petro

Product Manager / System Analyst

06/2017 – Present

Manager and main System Analyst of a Fuel Delivery System. The system was developed in Symfony / PHP and manages the supply chain (orders, deliveries, invoices) for companies which the business is provide large amounts of fuel from refineries to their end-customers (eg.: Supermarkets).

Document the system: BPMN, User Stories and Data Model (OOD using UML)

Manage the software process and the development team: Agile / SCRUM approach;

Development of features in Symfony to support the team and the API to integrate the system with the Driver s Mobile App (Restful Web Services)

Definition of a solution architecture to transform the current system in a real SaaS (multitenancy in the cloud, considering tenant isolation, multi DB for same source code, security, PaaS provider evaluation).

System Roadmap management and research and analysis for new modules, like Drivers Performance and Fleet Management.

Main results: Received a prize from the owner due to my performance, I did all the documentation within one month and he was expecting it for 3 months (considering learning curve).

Technologies: PHP, Symfony 3.6, Restful APIs, BPMN, OOD, UML, ETL, SaaS.

Environment: Reporting direct to company’s owner; management of 3 people in average;

Moving to Canada

Langara College - International Student

01/2016 – 05/2017

In 2015 I decided to have an experience abroad, so I applied to study at Langara College, Vancouver. I graduated in the “Internet and Web Technology” program in August/2017. This program gave me the right to work part-time during my studies and full-time after graduation (the current situation). I could find a part-time IT position only in June/2017 (my current employer, full-time permanent position since I graduated). Before it, I didn’t find a part-time position in IT, so I worked as dishwasher, cleaner and beer vendor. That s the reason I have a career gap during this period. From 1997 to 2015 it s possible to notice a very strong and consistent career, which I could resume from June/2017.

Control Store / Brazil

Software Developer (consultant)

01/2017 – 04/2017

Development of a new module for a Taylor made Surveillance / Security System, which controls gates and people access to company’s facilities and buildings. This module integrates to Digifort LPR (plate recognition system) through Web Services (Restful), so the system can automatically recognize truck plates and control trucks entrance; it also stores plate information in the database (SQL Server). This system is developed in Visual Basic 6 / SQL Server.

Main results: The system’s owner lost the contact of his only developer and it didn’t have any documentation. I could understand the system fast enough to implement the new module in time for the owner not to pay a fine due to compliance issues.

Technologies: Visual Basic 6.0, SQL Server 12.0, Restful APIs.

Environment: Reporting direct to company’s owner; As a consultant, I worked by myself;

Monet Project / Canada

Co-owner (startup company)

07/2016 – Present

Architecture definition, analysis and development of an App for the Finance Education industry, using concepts of banking integration, gamification and artificial intelligence.

We are using for MVP JavaScript technologies (Cordova, Phaser.js, jQuery, Lodash.js), Bootstrap (CSS, HMTL) and Firebase NoSQL database.

Currently I’m studying Yodlee platform to implement online banking integration.

Technologies: JavaScript technologies (Cordova, Phaser.js, jQuery, Lodash.js), Bootstrap (CSS, HMTL) and Firebase NoSQL database.

Environment: I have a company’s partner.

PMI - Canadian West Coast Chapter

Webmaster (Volunteer)

03/2016 – Present

General management of the chapter website as well as responsible for improvements.

Currently I’m doing general improvements and SEO (Search Engine Optimization).

The website is deployed and managed with Joomla CMS.

Main results: I did a SEO for the “PMP exam preparation course”, which is one of the most important business of the chapter, and the related webpage increased its google ranking from 64th position to 4th position.

Technologies: Joomla CMS, JavaScript, Bootstrap (CSS, HMTL), SEO.

Environment: I report directly to Website director, which is managed by Marketing Portfolio (team of 10).

Portosys Systems / Brazil

System Analyst / PL/SQL Developer

07/2015 – 12/2015

System Analyst and Developer in a deployment project of the ERP IFS for an aluminum manufacturing plant (located in Spain). Portosys is an IFS consulting company, IFS partner network since 2001 and IFS Iberica partner network since 2015.

development of new interfaces between IFS manufacturing module and the production equipments of the plant (using PL/SQL). These interfaces generate production orders, monitor production stages and collect all production notes and quality samples from the machines to the ERP.

development of scripts for the system setup (data entry): collecting data from over 100 excel spreadsheets, organizing, reviewing and inserting the data into the ERP. The data entry into IFS had to be done using External Files module, responsible for the interface between the system and external data. Each interface had to be created manually (each file type and file template), based on excel spreadsheets. With my initiative, we created scripts which read the spreadsheets and automatically created the file types and file templates for IFS external files. After this step, the interfaces were ready to be used (actual data entry).

Main results:

Support the team in development of complex SQL queries (Oracle database), reducing the development time and creating a great team environment.

System setup: conception of scripts that reduced data entry time around 50%.

Technologies: Oracle 11g, PL/SQL, SQL, Excel spreadsheets, IFS 9.0.

Environment: I reported directly to Portosys’s owner and internal project manager. The company’s project had 10 people. The overall Spain project had over 60 stakeholders.

Clinical Hospital of Porto Alegre / Brazil

Business System Analyst / SQL Developer

12/2013 – 06/2015

Responsible for developing new modules within the hospital healthcare and management ERP (legacy transformation and new features). The new ERP was implemented in JEE using Oracle database (from the legacy system).

Definition of a solution architecture for the OPME module (Orthotics, Prosthetics) which was implemented as an automated workflow engine (planning, authorization, consumption, billing);

Also, project manager, main business system analyst and process analyst (using UML and BPMN);

Developer of complex SQL queries (some of them with over 40 tables);

Prototype programs written in PL/SQL for Java developers;

Oracle database was very complex, over 500 table and many relationships;

SOA: we didn’t implement OPME as a service, but we studied SOA practices to try to implement it as a service. As this new module had too many integrations with the Hospital System (not following the self-contained principle), we decided to not provide it as an independent service.

Main results:

My automated workflow engine solution was highly prized and could be re-used in other modules of the ERP.

With my SQL skills, I could understand quickly and accurately the complex relations among many tables to query the OPMEs. This work was prized by managers and senior analysts.

Prototype programs for Java developers accelerated the development time by over 15%.

Through my technical actions and stakeholder management (conflicting), I could manage a positive agenda for the system deployment. This system enables savings of 10% in high-cost materials (the OPMEs) and great operational improvement.

Technologies: Oracle 11g, PL/SQL, SQL, Java, SOA, Agile, Redmine.

Environment: OPME project, I reported to CIO, I managed 4 people and contacted directly 30 stakeholders from different departments. The overall ERP project had over 300 stakeholders.

HP Brazil

Project Manager / SQL Consultant

03/2013 – 11/2013

Responsible for a large project for system transformation of a legacy system to a new web based system, with the most modern concepts of user experience. The project had 30 professionals allocated among business analysts, architect, test analysts, testers, user experience designers and developers. My main responsibilities of the project manager were:

Planning and controlling activities, resources, cost and schedule;

Planning and monitoring risks; Change Management;

Leadership and manages to interface between the sub-teams (development, architecture, testing and analysts);

Weekly follow up with the client through formal status report (project tasks and issues)

Leadership sub-team of business analysts;

Support the team in development of complex SQL queries (MS SQL Server).

Main results: I made it possible for the project to become viable again by re-prioritizing features, revision of the estimates of effort and review the lifecycle (from waterfall to Interactive-incremental). My initiative to help team in the preparation of SQL queries increased the speed of development and created a trust in the team.

Technologies: .NET, SQL Server 11.0, MS Project.

Environment: I reported to HP local manager, I managed 30 people and contacted directly 20 stakeholders.

VIAFLOW Consulting / Brazil

IT Manager

11/2011 – 02/2013

Responsible for IT department, which was divided in projects and services (administration of client’s infrastructure software). For projects, we had system development and ITIL change management projects. For services, we had 1nd and 2nd level support and ongoing maintenance (systems and client’s infrastructure software). Responsible for 15 people on average. Briefly, the responsibilities are as follows:

Planning and optimized allocation of resources (ongoing control of capability and availability);

Coaching and team management (interface with HR department);

Project management of system development projects and infrastructure software projects;

Management of support contracts (systems and infrastructure) through an ITIL compliance process;

Improvement of operational processes (IT processes and cross-functional processes) and implementation of tools to increase processes performance.

Management of security policies and company IT infrastructure governance;

Tactical and strategic management with company directors (financial and commercial directors);

Operational and tactical management with HR department (people management).

System analysis / requirements using UML and BPMN; Team training in Advanced SQL (ANSI).

Main results:

The company’s main client increased the support contract for 200% of the value as a direct result of improved deliveries under my management;

Sales increase by 15% due to my action to create new standards for specification and process for pre-sales activities. The increase in quality of documentation was noticed by the customer.

30% reduction in idleness, through resource planning and optimized allocation;

Management of approximately 60 projects: 90% executed within the agreed time and cost;

Increased staff satisfaction (100%) and reduced turnover by more than 50% due to my proactive management and maintaining a positive work environment.

Technologies: Lotus Notes, IBM Domino, MS Project, SQL, UML, BPM, Agile, ITIL.

Environment: I reported to CFO, I managed 15 people and contacted directly over 40 clients / users.

ilegra / Brazil

08/2003 – 08/2011

Business Processes Manager

01/2007 – 08/2011

Responsible for the department of “business processes and governance” of the company, dealing with technical processes improvement (core-business) and corporate management best-practices. Duties also included functional responsibilities in the budget, resources, costs, and management of personnel and projects. I reported directly to the board of directors and was responsible for a team of 4 people.

Implementation of process improvements and of best practices in software development (CMMI, Agile, SCRUM, UML, RUP, BPM, SOA); Implementation of CMMI Level 2; I reported to CFO and managed around 25 people. This project took 13 months.

Management of a team of process analysts, dealing with the ongoing improvement of practices and processes that also involves support processes (Commercial, Financial, Marketing and Human Resources). Coordination and implementation of process automation using BPM (Bizagi tool).

Management of the project which implemented administration best practices through the Rummler-Brache and Gartner models, with additional duties as a process analyst, team instructor and facilitator

System Analyst and Developer of company’s ERP, developed in Oracle version 9i (SQL, PL/SQL, Forms and Reports).

In addition to management, I performed analysis and development of new features. automation of Purchase Process using Bizagi Studio (process automation tool), which also had SOA concepts (modeling business tasks as services). I had a formal training in this tool.

Main results:

Increased precision and delivery quality in more than 20% (reflecting customer satisfaction).

Consolidation of company’s ERP as a reliable and compliant tool to the business.

Technologies: CMMI, Agile, SCRUM, UML, RUP, BPM, SOA, Bizagi, SQL, PL/SQL, Oracle 9i.

Environment: I reported to board of directors and I managed 4 people directly. CMMI project was 25 people.

System Analyst / PL/SQL Developer

08/2003 – 12/2006

Rubber factory client: System Analysis, maintenance and development of a plant management system for rubber manufacturing. The system was called SGF and was developed with Oracle Developer 6i (SQL, PL/SQL, Forms, Reports). Main projects: system deployment in a new plant and system integration (in all plants) to newly acquired ERP (SAP R/11). For both projects, I was the technical leader, main system analyst and SQL – PL/SQL Developer.

SGF Implantation at company’s headquarters (08/2004 to 04/2005): A highly important project involving the implantation of the plant system at the company’s headquarters. Before deployment, we did a gap analysis to check the system's adherence to the business. We met and talk to over 20 stakeholders from many departments and production steps. For that plant, we needed to develop a new critical and complex module: rubber blending. This module was responsible to collect over 80 sample analyses / minute from steps behind the production line in order to estimate the product quality and warn for adjustments when needed. We also developed a dashboard to display the information in a friendly and visual way. I reported to CIO and managed a team of 3.

SGF Integration with SAP R/11 and implantation of SAP Project (05/2005 to 09/2006): An even greater challenge was the integration and implantation of SAP in the company. I was responsible to define (and implement) the interfaces between SGF and SAP. Some of the interfaces were: raw-product supplying, production orders, production notes, data analysis and quality control. At the beginning, the SAP team was against our system / company, because they wanted 100% SAP. After they saw our system and quality of our team and work, they began collaborating and we created a positive project environment. The implantation was successful resulting in the implantation and adherence to the business of both systems. I reported to CIO and managed a team of 5.

Main results:

As a solution architect, I developed a whole program inside a query (very well organized in many sub-queries). It was the heart of the rubber blending module, which could forecast the rubber quality / quantity based on many sample analyses. I'm very proud about it, it could reduce the development time, reduce the overall program response time and brought satisfaction for the customer.

The knowledge acquired in negotiating and managing projects provided a smoother implantation for all stakeholders, mainly regarding the client.

Junior partner and Deliberative Advisor

03/2005 – 08/2011

Member of the board of directors (8 members), working as deliberative advisor for strategic and tactical subjects of the company. Participation in the development of bi-yearly strategic planning as well as the appropriate monitoring and review. The strategic planning was breakdown in tactical plans and then executed as projects. I was assigned to two major projects related to governance improvement (described in the process manager session).

Main results: Company growth over 1000% in the period (from 20 people in 2005 to 200 in 2011). Direct actions on the high talent retention and on winning the “Great Place to Work” prize.

Genese Systems

System Analyst / PL/SQL Developer

04/1999 – 08/2003

Systems Analyst and Developer in Oracle Developer 6i (SQL, PL/SQL, Forms, Reports and Discover). I also developed in Java, HTML and JavaScript.

Main results:

Telecom company project (2002 – 2003): maintenance of application which integrated its billing system (Amdocs) to Oracle R11 AR (accounts receivable). I could reduce integration performance dramatically (from 14 to 1.5 hours) and consistency problems (from 30 issues to zero issues). Regarding Oracle R11, I also worked for a short period with the modules Accounting, Inventory and Accounts Payable. I reported to CIO and I worked by myself.

Database migration from SQL Server to Oracle: migration of entire data, metadata and store procedures from SQL Server 7 to Oracle 8i, using Oracle Migration Workbench. This tool was helpful to migrate the data, but I needed to check all fields manually to certify they were according to specifications (data mapping). I also needed to check manually each store procedure (from T-SQL to PL/SQL) if they had the right syntax and whether the functionalities were according to original behavior and specification. I reported to CIO and I worked by myself.

Wholesales car’s parts company (2000 - 2002): As a system analyst, I worked for a car s parts company (it had over 20 branches spread in Brazil). We developed a ERP system from scratch. It fit to all business needs. Personally, I worked with a new CRM system, Ordering, Inventory management, Strategic Planning using Balanced Scorecard, Accounts Receivable and system integration (with third-party accounts receivable application). I reported to CIO and we were a team of 5 peers.

Pulp factory project (1999 – 2000): The company which I worked for had the responsibility to maintain and develop new feature for the custom plant management system (developed in Oracle 7 and Forms 3.0, Unix environment). I was assigned for a year project to upgrade core functionalities in the system (production notes, quality samples). It was very critical because I worked alone and the system should be up 24/7. As the system was already old and its architecture was disorganized (years of maintenance), I decided to refactor the whole system, creating uniform methods (store procedures). This approach helped me to develop the new features, solved historical problems (bugs) and I could deploy the system without any issue. The user considered as the most perfectionist commented “It doesn't get any better than this”. It’s important to mention that my skills as system analyst (organizational, analytical, problem solving) helped me to “see the big picture”, breakdown the scope, understand the user needs. So, they were a critical success factor for that project.

HP

Software Developer (contractor)

0/1997 – 03/1999

Working for Caixa Econômica Federal (second biggest public bank in Brazil) on the development of a new system for the bank (legacy transformation and new features). The project had over 50 people and the system had over 500 features.

Main results:

I started developing back-office functionalities, due to my performance, I was assigned as main developer for the ATM software. I developed the most important functions and I could establish the system (structural correction of the system, correction of bugs and performance improvement).

Technologies: Visual Basic 6.0, SQL Server 7.0, MS Source Safe.

Environment: I reported to HP project manager, I had over 40 peers (developers, testers, system analysist) and contacted directly 5 stakeholders.

ACADEMIC EDUCATION / CERTIFICATIONS

Certificate in Internet and Web Technology – Langara College

Post-Graduate in Finance and Corporate Governance – ESPM-RS

MBA in Business Management – 1st Management – ESPM-RS (incomplete)

Bachelor of Computer Science – PUC-RS

Certified PMP (Project Management Professional) of PMI (Project Management Institute) since 2012.

Contact this candidate