Eric Methot Email & Phone Number

Geneva, Switzerland

Design, develop and maintain hybrid/cloud applications using Amazon AWS services, terraform and a variety of programming languages that best suits the task at hand (Go, Rust, Python, NodeJS) and using a complete CI/CD pipeline.

Les Acacias, Canton Of Geneva, Switzerland

Gland

For Salt Mobile:I have integrated some of Salt Mobiles internal systems with Mailchimp through their Rest APIs and provided a custom web interface to facilitate the creation of multilingual email marketing campaigns.● Designed an integration solution between Salt Mobile et Mailchimp. ● Perform the technology selections for the proposed solutions. ● Develop integration scripts and a web app to facilitate the campaign creation process. Keywords: Javascript, React.js… Show more For Salt Mobile:I have integrated some of Salt Mobiles internal systems with Mailchimp through their Rest APIs and provided a custom web interface to facilitate the creation of multilingual email marketing campaigns.● Designed an integration solution between Salt Mobile et Mailchimp. ● Perform the technology selections for the proposed solutions. ● Develop integration scripts and a web app to facilitate the campaign creation process. Keywords: Javascript, React.js, Node.js, Mongo DB, HTML, CSS, Cloud, AWS, Heroku, REST API, Web Services, Mailchimp, Oracle 11g, PL/SQL, Bash, sshFor Orange Communication:I developed the latest generation of the Direct Marketing campaign management system. The system is used for both analytics and customer targeting and provided vast performance improvements over the previous generation. It also allowed for an large increase in the number of outbound campaigns with faster time-to-market and more timely and relevant segmentation variables. Furthermore, it opened the road for a brand new class of outbound campaign further increasing the teams profitability.● Gather stakeholders requirements in the design of a new “Direct Marketing” data mart. ● Design the data mart to meet most of these requirements. ● Develop the PL/SQL ETL scripts for the entire data mart. ● Create an Excel interface to this data mart for campaign performance reporting. Keywords: Oracle 11g, PL/SQL, Star Schemas, Ruby, Bash, Visual Basic, ExcelFor Nuascent (internal projects):I have developed a multi-dimensional data visualization application for Mac OS X. It allows a user to see information in up to six dimension (including time) using a two dimensional chart. Charts are easily configured and exported to video. The app is now on sale in the App Store. I have also contributed a number of open source projects related to AMQP based micro services.Keywords: Objective-C, Cocoa, UX, C, HTML, CSS, Javascript, Gulp, Amazon S3, CDN Show less

Lausanne, Switzerland

For Orange Group, I was the Project Manager for the “Central Customer Data Mart” (CCDM), an analytics platform collecting information from 9 member countries. With a team of 3 to 5 developers, we deployed new functionality once per quarter. I have also coordinated 2 major updates to the extraction process in all member countries each different schedules and with BI maturity levels.• Mobile Telecom, Customer Insight• Team management

For Orange Group, I delivered two generations of performance measurement systems for outbound direct marketing campaigns in their effort to optimize the Marketing process. I deployed these systems in 3 countries. I lead the development of “Customer Core”, the heart of the new “Central Decisioning” system in Orange Romania. ● Produce functional and technical analysis documents. ● Map source systems to a dedicated data mart for “Direct Marketing KPIs” reporting. ● Deploy BO based… Show more For Orange Group, I delivered two generations of performance measurement systems for outbound direct marketing campaigns in their effort to optimize the Marketing process. I deployed these systems in 3 countries. I lead the development of “Customer Core”, the heart of the new “Central Decisioning” system in Orange Romania. ● Produce functional and technical analysis documents. ● Map source systems to a dedicated data mart for “Direct Marketing KPIs” reporting. ● Deploy BO based Direct Marketing KPIs dashboards in three countries. ● Deploy the Oracle based backend in three countries (Switzerland, Belgium et Netherlands). ● Lead the development of the “Direct Marketing” data mart for Orange Romania (Oracle 9i). Keywords: Oracle 9i et 10g, Business Objects 5, BO-Xi. Show less

Montreal, Canada Area

(as an independent consultant)For Microcell Telecom (acquired by Rogers) and as part of a data warehouse optimization project, the mission was to increase system availability by at least 6 hours. With three other consultants on my team, we were able to reduce ETL time by 70% and gained an extra 11 hours of up-time. The success of this project rested on two pillars: communication and analysis. On one part, some communication barriers needed to be removed in order to properly map the various… Show more (as an independent consultant)For Microcell Telecom (acquired by Rogers) and as part of a data warehouse optimization project, the mission was to increase system availability by at least 6 hours. With three other consultants on my team, we were able to reduce ETL time by 70% and gained an extra 11 hours of up-time. The success of this project rested on two pillars: communication and analysis. On one part, some communication barriers needed to be removed in order to properly map the various business processes and data flows. Then a thorough analysis of all processes and data structures lead to an optimization strategy and execution plan, which were then refined through a series of focus groups of 5 to 8 people. These focus groups further increased the buy in on the part of each party, which in turn facilitated their implementation.Keywords: Oracle 9i, PL/SQL, ETL, Optimization Show less

Montreal, Canada Area

(as an independent consultant)During a series of corporate acquisitions, the mandate consisted in integrating the various operational systems of acquired competitors to those of Protectron. Given the nature of the business and the tense political environment, the performance of the integration process was an important factor. Speed was essential to minimize the impact on ongoing business, on clients and on employee satisfaction. With a team of two domain experts, the source data was… Show more (as an independent consultant)During a series of corporate acquisitions, the mandate consisted in integrating the various operational systems of acquired competitors to those of Protectron. Given the nature of the business and the tense political environment, the performance of the integration process was an important factor. Speed was essential to minimize the impact on ongoing business, on clients and on employee satisfaction. With a team of two domain experts, the source data was cleansed, standardized and mapped to the target system. This systematic process allowed us to raise both operational and legal concerns before integration. The mandate was completed successfully within the given time constraints. In another project the “third party” invoice was redesigned so as to project a more professional image and to reduce the frequency of invoice related complaints.Keywords: Perl/Unix Shell scripting, Sybase PL/SQL Show less

Montreal, Canada Area

(as a consultant for Imagina Solutions Technologiques)The mandate consisted in developing, for the “pro-traders” group, a foreign exchange risk management application. Guided by the vision of the groups Director, and with the assistance of another technical consultant, we developed a web application that allowed a dealer to manage, in real-time, the groups net position with respect to any foreign currency.• Data modeling• Unix shell scripting• Sybase PL/SQL

(as a consultant for Imagina Solutions Technologiques)The mandate consisted in developing a set of complex reports for the finance and strategic planning departments. The data warehouse was not designed to address the specific needs of these reports, which posed a serious challenge to the business. The success of the project rested on the development of a new data extraction strategy. The strategy produced a reduction of 98% in the run time of most reports and lead to development of a new… Show more (as a consultant for Imagina Solutions Technologiques)The mandate consisted in developing a set of complex reports for the finance and strategic planning departments. The data warehouse was not designed to address the specific needs of these reports, which posed a serious challenge to the business. The success of the project rested on the development of a new data extraction strategy. The strategy produced a reduction of 98% in the run time of most reports and lead to development of a new data mart, which incorporated its underlying principles.• Performance optimization• Data warehousing• Oracle PL/SQL Show less

Montreal, Canada Area

The mandate consisted in developing the compilers and interpreters for the languages of the IEC-61131 standard, which are used in industrial automation. Beyond the original mandate, I have designed a framework for a distributed database based on a “publisher/subscriber” model that supplied a consistent image of the system in near real time. Also, the implementation of a profiler within PCP-Virgo, their flagship product, added considerable value in the eyes of the clients. Finally, I have… Show more The mandate consisted in developing the compilers and interpreters for the languages of the IEC-61131 standard, which are used in industrial automation. Beyond the original mandate, I have designed a framework for a distributed database based on a “publisher/subscriber” model that supplied a consistent image of the system in near real time. Also, the implementation of a profiler within PCP-Virgo, their flagship product, added considerable value in the eyes of the clients. Finally, I have coached the team of 20 programmers and analysts on “design-by-contract” development practices.• C/C++ Real-time systems• TCP/IP• Coaching Show less

The mission was to develop the credit report management system. The system generated over 30 types of credit reports and offered an account tracking service to the bureaus clients. Four generations of the corporate transactional web site where also developed. The web site allowed clients to order and see credit reports on-line as well as track their automated alerts. It also hosted discussion forums allowing users to exchange information concerning their own clients (NSF cheques, bad client… Show more The mission was to develop the credit report management system. The system generated over 30 types of credit reports and offered an account tracking service to the bureaus clients. Four generations of the corporate transactional web site where also developed. The web site allowed clients to order and see credit reports on-line as well as track their automated alerts. It also hosted discussion forums allowing users to exchange information concerning their own clients (NSF cheques, bad client, fraud...). A data entry team of 12 people was trained to use both the management system and the web site.• Created the MIS infrastructure• Created new revenue stream with new web-based services.• Microsof Access/SQL Server• Visual Basic Show less

Black Belt (2014-09: Certification In Progress), Lean Six Sigma

Masters, Computer Science

Bachelor'S Degree, Computer Science

College Degree, Science