Resume

Sign in

Developer Information Technology

Location:
Dallas, Texas, United States
Posted:
August 27, 2018

Contact this candidate

Resume:

Jean-Philippe Villemalard

Cell. : +1-469-***-****

ac6tr4@r.postjobfree.com

Objectives

After almost seven years within Sopra Group, a European information technology company of over 13000 employees, four years with Notarius as an Oracle PL/SQL Programmer, Oracle Reports and Forms Developer and Data Architect, over 2 years with the National Bank of Canada as a Sybase SQL/UNIX Developer and over two years as a Greenplum developer with Morgan Stanley I have technically portrayed myself as being proficient in batch application development, databases and mainframe applications. I know how to be autonomous and autodidact. My capacity to manage difficult situations on a technical as well as on a management level makes me a humanly reliable and technically qualified person.

As I am always looking ahead, I desire to pursue my evolution and discover new horizons in the information technology environment. My years passed abroad and my technical skills are an asset for any company willing to evolve like me.

My life passed in California and my Canadian professional experience inculcated me a notion of service and quality work whilst my European experience, English and French, brought me open-mindedness and professional rigor.

Professional Experience

Greenplum DBA

02/2018 - today AAFES, Dallas, TX, USA

Implemented new, and managed existing, database objects,

Apply a common methodology of allowing development teams to create objects in the development environment and have the DBAs migrate those objects in the production environment

Created new, and managed existing, database user and service accounts,

Reorganize privileges and roles in the production environment to avoid breaking the database and its objects

Maintained up to date system firmware, DCA and database,

Keep the database and its environment up to date in accordance with End of Support deadlines set by EMC

Developed Python and Shell scripts for reporting and automation purposes,

Create scripts that would automatically run on a defined schedule to allow users visualize the status of the database and its environment in a Sharepoint portal

Monitored user and batch queries to prevent bloating and database from crashing.

Create scripts that would automatically run on a defined schedule to alert users and DBAs on possible database anomalies via email

Greenplum/Python/UNIX Shell Programmer

08/2015 – 02/2018 Morgan Stanley, Montreal, Quebec, Canada

Greenplum developer for the VIPER data warehouse team that generates stock reports,

Collaboratively translated plan requirements and took responsibility for these plans,

Migrated business rules from KDB databases, written in 'q', to Greenplum functions,

Extracted the algorithms from the ‘q’ code and translated it to PL/pgSQL functions

Maintained and improved the ETL process written in Python,

Rendered more efficient the process of copying data over to the staging tables and the process of getting the data to the target tables

Inherited the role as Greenplum expert within the department.

Senior UNIX/SQL Programmer

07/2012 – 07/2015 Financial Group National Bank of Canada, Montreal, Quebec, Canada

Developed SQL scripts for Sybase DB,

Maintained and improved existing stored procedures written in T-SQL for copying data into the database

Developed Unix shell scripts,

Maintained and improved existing shell scripts written in Bash for executing Sybase stored procedures

Developed ETL procedures for Oracle DB,

Created stored procedures written in T-SQL and Shell scripts written in Bash to copy data from Oracle to Sybase

Developed SQL scripts for the timesheet / project management application,

Created stored procedures written in T-SQL to update and manage the application

Coordinated technical releases,

Made use of JIRA to organize and schedule new releases

Led the Dividends and Interests application team.

Oracle Programmer / Analyst

04/2012 – 07/2012 Chambre des Notaires du Québec, Montreal, Quebec, Canada

Implemented application maintenance and performance testing,

Applied quality assurance and test grid conceptions,

Reviewed source code and tested all modifications in a pre production environment

Assisted in implementing new projects,

Designed and modeled Oracle database objects

Customer follow-up,

According to business user needs, fixed or created new Oracle Forms / Reports

ETL conception and development

Implemented Shell scripts written in Bash.

Data architect

08/2008 – 04/2012 Notarius, Montreal, Quebec, Canada

Documented technical and business functionalities in the company Wiki,

ETL conception and scripting,

Utilized and implemented Atlassian Confluence modules,

Business analysis

Conceptualized application data models

Development of information system strategy

Oracle Programmer / Analyst

05/2007 – 08/2008 Notarius, Montreal, Quebec, Canada

Implemented application maintenance and performance testing,

Applied quality assurance and test grid conceptions,

Reviewed source code and tested all modifications in a pre production environment

Assisted in implementing new projects,

Designed and modeled Oracle database objects

Customer follow-up,

According to business user needs, fixed or created new Oracle Forms / Reports

ETL conception and development

Implemented Shell scripts written in Bash.

Project Manager / Coordinator

12/2006 - 04/2007 Infosys Software, Boucherville, Quebec, Canada

Led the development team,

Software follow-up with development team,

Coordinated customer needs with development team,

Customer follow-up,

Business analyst.

Oracle Programmer / Analyst

11/2006 – 12/2006 Notarius, Montreal, Quebec, Canada

Implemented application maintenance and performance testing,

Applied quality assurance and test grid conceptions,

Reviewed source code and tested all modifications in a pre production environment

Customer follow-up,

According to business user needs, fixed or created new Oracle Forms / Reports

ETL conception and development

Implemented Shell scripts written in Bash.

Software Engineer / Development Team Leader

11/1999 - 9/2006 Sopra Group, Paris, France

Development and functional team lead,

Technical and functional documentation,

Use of Sopra documentation templates

Source code versioning,

Implementation of CVS

Testing and quality assurance with development in case of code modification,

Tight collaboration with QA teams

Developed Oracle stored procedures and Oracle ERP modules,

Oracle Applications OEBS (Oracle Enterprise Business Suite) version OPSF (Oracle Public Sector Financial )

Created Shell scripts for reporting and batch jobs

Aided in the development of the daycare website for the City of Neuilly sur Seine using ASP

PL/SQL development in various projects

Education

10/1998 - 6/2000 University of Bath, Bath, UK

MSc. in Management and Strategic and Information Systems

Award: Pass

Project: Investigate the impact of knowledge management based on personal experience and case studies. The project aims to model the importance of establishing a knowledge management system based on published documentation and theories.

10/1995 - 7/1998 University of York, York, UK

BSc. (Hons) in Information Technology, Business Management and Language

Award: Upper Second Class (2:1)

Final year project: Create a 3D model of the Computer Science building, and a database containing information about the staff and students of the department. The database and 3D model were integrated on the Web using HTML, Standard Query Language (SQL) and Virtual Reality Modeling Language (VRML).

Skills

Languages: ASP, Bourne Shell, C, HTML, Javascript, Korn Shell, PHP, PL/SQL Pro*C, SQL, VB, VBA, Cobol, T-SQL, PL/pgSQL

Tools: CVS, SVN, MS Project, Microsoft Office / Visio, Oracle Applications 11.5.10 - 11.5.4, Visual Studio, WinCVS, Talend, Atlassian JIRA / Confluence, Quest Data Modeler / Toad, OpenOffice, Oracle Forms / Reports / Designer, TWS, MAESTRO, IBM Maximo

Databases: DB2, MySQL, Oracle, Progress, Sybase, PostgreSQL, MS SQL Server, Greenplum

Operating systems: Linux, Mac OS, MVS, Unix, Windows



Contact this candidate