Carlos Perez

email : ad2bvh@r.postjobfree.com Phone: 438-***-**** (Mtl, QC)

ETL Developer: knowledgeable in several ETL applicative solutions

BI Analyst / Developer: Specialized in: - MS SQL Server - Oracle PL/SQL – Terada

ERP software: Trilingual English, French, and Spanish

EXECUTIVE SUMMARY

•Experience (DevOps) in the analysis, development and support of applications for US, Canadian and French companies’ Anglophones and Francophones

•HyperIA3, Desjardins Financial Group, Morgan Stanley, Bank Of America- Merrill-lynch, BNP Paribas, Société Générale, TCS, Nikon, DuPont de Nemours, Pratt & Whitney, Bombardier, HP, GFI Solutions) Locations: Jersey City & NYC (USA), Paris (France), Toronto and Montreal (Canada).

•Support experience in 3 languages (English, French, Spanish)

•System administration and Applicative Technical Support Experience

•Experience in analysis, design and development of ETL, Business Intelligence applications and ERPs’

•Natural Traits: Discerning, analytical, meticulous, attention to detail.

Methods

•Resolution of problems, requests and analysis demanded by clients on Oracle PL/SQL, MSSQL Server, IBM Informix SQL developer, DB2, Teradata

•Development of databases, on IBM DB2, Teradata, PL/SQL, SQL, MS SQL (Creation of queries, stored procedures, functions, packages, and troubleshooting, Query and Environment performance optimization)

•Quality Assurance and Integration of ETL / BI / ERP Systems

•Technical support proprietary application

•Contact for different teams; infrastructure, networks, Data Warehouse, Quality Assurance, business

•Team Coordination / follow-up / Organization / Mentoring / Agile-Scrum Methodologies

•Processus Monitoring.

•Configuration and Administration of Networks systems / routers under Unix and Windows

•Drafting of functional and technical specifications documentation and user manuals / guides

Technologies

Systems

Windows, UNIX/Aix, Linux Red hat, OS/2

Languages

SQL, PL/SQL, T-SQL, C, C++, VB, XML,

Troubleshooting abilities of JAVA code, MS PowerShell, Python

RDBMS

MSSQL Server 2005/2008/2012/2014 ORACLE 9/10g/11g/12c, IBM DB2 TERADATA 16.20

(Interactions with: SAP SYBASE, INFORMIX, MS Access)

Oracle Tools

SQL Developer, SQL*Plus, PL/SQL, TK PROOF, Explain Plan

Net Protocols

Windows Server 2003/2008, development of data communication protocols, DSL, TCP/IP, configuration routers / hub / switches

ETL/BI –Tools

IBM InfoSphere DataStage 11.5, 11.7 Morgan Stanley ETL (in House Developed / Similar to Informatica) ETL ETI*Extract, MS SSIS, SQL Loader, Ksh Scripts. BI Platforms, Micro Strategy 7.5 / 8.1 / 9.2, SAP BO XI 3.1 Deski / Webi, IBM Cognos 10, Cognos Analytics 11.2

Batch scheduling

Autosys, AutosysR11, Control-M

Scripting

KSH(bash), Perl, MS PowerShell,

Other tools

IntelliJ, CWB(Reporting Tools Morgan Stanley(.net)) SQL Server Management Studio (SSMS), MS Visual studio 2012/2017 VMWare 5.5, Lotus/Notes, 4/R5/R6/R7/Social Edition, MS Outlook, Terminal Service, VPN, Dame Ware IEE 5+, Active Directory, Zone Labs, Integrity client, Ultra Edit, FileZilla, Clear Case (versioning), TFS(Team Foundation Server) ARS Remedy, Putty, Git (under an Agile Env)

EDUCATION AND TRAINING

2023 Azure SQL Server, AWS Certified Solutions Architect Associate SAA - C03

UDEMY. Online in PROGRESS

2005 Preparation for the CCNA (Certifications Cisco & CompTIA Linux)

Cisco Certified Network Associate (CCNA), Dawson College in Montreal (Academy

Cisco Certified)

1996 - 2001 bachelor’s degree in computer sciences

Major Software Engineering and Development

Minor in Mathematics Concordia University Montréal, Canada

1996 College Studies Certification, Programmer-Analyst, Delta College Montreal, Canada

DESCRIPTION OF INTERVENTIONS

Sep 2022 – Present HyperIA3 Montreal

Oracle DB Developer / MS SQL Developer / IBM Cognos C10 & Cognos Analytics C11.2 Developer

The DB SQL Developer is required to participate in designing databases and their components ensuring their stability, reliability, and performance.

The main tasks for this position would require me to develop all necessary Database objects from tables, views, indexes, procedures, packages etc. In both Database applications Oracle 12c and/or MSSQL server 2017. Also, support, evaluate and engineer components for use in the company’s enterprise data warehouses.

Regarding IBM Cognos C10 and IBM Cognos analytics C11(ongoing process moving from C10 to C11) developments tasks of new reports and recreating old reports on new infrastructure

The main tasks I am involved in and that are part of my responsibilities are to Improve application's performances. Find and fix any issues related to database performance and provide corrective measures. Those measures could be part of a later development put in the backlog for later, or if immediate action is necessary a hot fix will be implemented.

As a regular task when not providing support to the production lines, I will create complex functions, packages, scripts, stored procedures, triggers tables, views etc. to support application development.

I will develop and perform maintenance on database schemas, and dictionaries. I will also ensure data quality and integrity in databases.

Furthermore, I Provide authentication and authorizations for Database, and I will develop best practices for database design and development activities. We try as a team effort to keep all documentation up to date.

IBM Cognos C10 & Cognos Analytics C11.2 Upgrade project is an ongoing effort for Lassonde Client.

This client is upgrading all their infrastructure from the C10 version to the C11.2 analytic platform version.

The two versions are running in parallel in production as business must continue. This only adds to the complexity of the exercise as both versions infra are completely different even if the data is the same. All the transformation is done as a one-by-one report for all the corporation departments Finance, HR, Production etc.

I participate in the upgrading and translation effort by converting one report at a time on the basis of priority, reports have to be produced and supported in both official languages English and French.

I take part in all cycle of the agile process: analysis, requirement acceptance, development, test and deployment even if some of these steps are perform by other groups.

Skills required for the Oracle / MSSQL / IBM Cognos Analytics Developer

•Support and troubleshoot production incidents/problems, optimizing performance.

•Provide technical advice and development support for the development team.

•Good understanding of SQL Development Best Practices in design and implementation.

•Occasional weekend and after-hours work are required to implement software upgrades. Support

Technical environment: Windows 10/11 MTF (Microsoft Team Foundation), Oracle 12c, MS SQL 14/17 Ultra Edit, Notepad ++, Citrix VM, MS PowerShell, MS Active Directory, AutosysR11, All within an Agile scrum environment.

April 2021 to Sep 2022 Desjardins FCDQ Montreal

Fondation Echange et Integration des Donnees

DataStage Administrator / SQL Developer

As a DS Administrator, I would support, evaluate and engineer IBM: Infosphere/DataStage products for use in the company’s enterprise data centers.

The main responsibilities amongst other are:

•Developing DataStage installation and support guides that are consistent with IT security policy.

•Providing third level support regarding DataStage product related issues.

•Developing new tools and processes to ensure effective use of DataStage product.

•The position will also be responsible for administrating and maintaining a DataStage shared environment, this includes:

•Designing and sizing the environment.

•installing patches when required.

•Monitoring and analyzing the audit usage data to ensure the optimal usage and efficient performance of the infrastructure.

•The position will work with the application administrators and development teams to ensure the shared environment resources are optimally utilized.

Among other tasks we also:

Provide infrastructure operations support and administration of the 11.5 and 11.7 DataStage environments. This includes setting up and testing new installations of DataStage, Quality Stage and Information analyzer.

Engineer and install/upgrade Information Server product suite. Post install Configuration, various data sources configuration for the plug-ins, connectors as well as ODBC configurations.

Document Runbooks for the installations, Disaster Recovery plans etc...

Stop/start services, monitor logs, setting up Security, assigning roles, project permissions, Create/Delete projects, create/modify environmental parameters etc.

Monitor the Infosphere suite (Data Stage/Quality Stage) servers. Kill/assist release job locks, shared memory locks, hung processes etc...

Apply fixes, patches and service packs as required. Ensure infrastructure and application stability through preventative maintenance, monitoring, troubleshooting, and implementing long term solutions.

Capacity planning for new projects in the shared environment.

Liaises with product vendors and technical specialists to resolve issues.

Also provided the necessary development and support to migrate schedule tasks/jobs from Autosys R11 to Control-M, test and deploy in all the required environments.

Skills required for the DS Administrator

•Support and troubleshoot production incidents/problems, optimizing performance.

•Provide technical expertise and development support for the ETL development team.

•Good understanding of ETL Best Practices in design and implementation.

•Onsite resource required due to frequent interaction with other engineering, operations and development teams.

•Occasional weekend and after-hours work are required to implement software upgrades.

Technical environment: Virtual Citrix Env: Windows 7/10 and UNIX AIX Bash 5.3. Linux RedHat, GitHub (Win versioning), DB2 / Oracle, Putty, Ultra Edit, Notepad ++, Citrix VM, KSH Shel Scripts, MS PowerShell, AutosysR11, All within an Agile scrum environment.

July 2018 to March 2021 Morgan Stanley (Montreal / NYC)

Corporate Funding Technology (CFT)

BI Analyst - Developer / SQL Developer

Detail Sub Ledger – Application (DSL- Loans)

Part of the DSL-Loans team, I am entirely committed to developing and improving data transformation processes, I also participate in the development of Shell KSH scripts. I improved Stored Procedures and Teradata / DB2 database / MS SQL 2012 components: stored Procedure, Functions, indexes, triggers etc. This with the goal of improving the data Transformation processes and/or data integration processes into data warehouses. I also, participated on the development of a new solution to incorporate data in the several tables and Datawarehouse for manual accounting adjustments done thru the moth, such a system required several months of planning, engineering, development and effort from several team members. I am also presently collaborating in the development of a new reporting solution to implement new accounting standard regulations: FASB issued Accounting Standards Update (ASU) 2016-13, Financial Instruments—Credit Losses (Topic 326). (CECL)

• One of my responsibilities has also been to solve production problems in our integration processes as well as data transformation and data problems.

• Our team is responsible for monitoring the databases of our application perimeter and their proper functioning. We also troubleshoot technical problems of the batch executing during the day, and month end.

• I also worked closely with the bank’s Business Analysts (BAs) in NYC and New Jersey. I collected the prerequisites and proceeded to the functional study of the requirements and developed the necessary solution to the application evolutions, and new features.

• Finally, we deliver in QA, UAT and production environments, our solutions and improvements

• Once all these steps are completed and accepted by the customer. I proceed to create the documentation of the solution for its deployment in production as well as its maintenance and for support purposes.

Technical environment: Virtual Citrix Env: Windows 7/10 and UNIX AIX Bash 5.3. Linux RedHat, GitHub (Win versioning), MS SQL Server 2012 / 2014 / DB2 / Teradata, ELCABALLO (In House ETL Developed, CWB Controllers Workbench reporting Tools (.net)), Putty, Ultra Edit, Notepad ++, Citrix VM, KSH Shel Scripts, MS PowerShell, AutosysR11, IntelliJ, Scala (Java). All within an Agile environment.

November 2017 to June 2018 Société Générale SGCIB (Montreal)

Corporate Investment Banking

BI Analyst - Developer / SQL Developer

BORDER Application - AMER Trading Data Consolidation and Reporting

At the heart of the BORDER team, I was exclusively committed to the team to develop and improve data transformation processes (Data Ingestion) I also participated in the development of Shell KSH scripts. Most importantly, I was assigned to enhanced Stored Procedures and MS SQL 2012 Functions. This was to improve the processes to transform the data integrated into the data warehouses. I also, developed a system of archiving and purge for a specific data module - Platon including data real time and night batch of consolidation of the production data of the day. I improved by different techniques the time response and execution of the different processes.

One of my responsibilities has also been to solve production problems in our integration processes as well as data transformation.

Our team is responsible for monitoring the databases of our application perimeter and their proper functioning. We also troubleshoot technical problems of the batch executing during the day.

I also worked closely with the bank’s Business Analysts (BAs) in NYC and New Jersey. I collected the prerequisites and proceeded to the functional study of the requirements and develop the necessary solution to the application evolutions.

Finally, we deliver in QA and production environments, our solutions and improvements

Once all these steps were completed and accepted by the customer. I proceed to create the documentation of the solution for its deployment in production as well as its maintenance and for support purposes.

Technical environment: Windows 7 and UNIX AIX Bash 5.3. SVN (Win versioning), MS SQL Server 2012/2014, SSIS, SSRS, FileZilla, Putty, Ultra Edit, Notepad ++, Citrix VM, KSH Shell Scripts, MS PowerShell, Autosys, TIBCO BW, TFS.

September 2016 to September 2017 Bank of America / Merrill Lynch – Margin Risk Management

(JC NJ, NYC NY, U.S)

BI Analyst – Design and Development

Margin Risk Management for Bank of America – Merrill Lynch

As part of the ARCTIC Team I provided functional and development of the ETL Processes. I also participated on the KSH shell and SQL script to transform the data once integrated on our databases.

One of my responsibilities is also to produce and create solutions for production issues of our processes.

Our team was responsible for the DB operations within our perimeter. We had to troubleshoot any arising Database technical issues and find solutions to communicate to the DBA team.

The range of my responsibilities comprehended also the requirements gathering process and functional study of the solution passing through the development of the required software solution or evolution.

Finally, we deliver in the production environments our enhancements and solutions.

Once all these steps are completed and accepted by the client. I proceed to the documentation drafting of the solution provided for its deployment in production and for recording and supporting the context of the application and its evolution.

Technical environment: Windows 7 and UNIX AIX Bash 5.3. CVS (Win versioning) and TFS (Team Foundation Server) MS SQL Server 2012 / 2014, SSMS, SSIS, FileZilla, putty, Ultra Edit, Citrix VM, KSH Shell Scripts, Python

February 2015 to August 2016 BNP PARIBAS CIB – Risk Management (Paris)

BI Analyst – Functional study engineer, design and development

Corporate & Investment Banking (CIB) - Risk Management for BNP Paribas

As part of the GTA Team I provided functional and development of the ETL Processes. I also participated on the KSH shell and PL/SQL script to transform the data once integrated on our databases. One of my responsibilities is also to produce and create BO reports on SAP BO XI 3.1. The range of my responsibilities comprehend from the requirements gathering process and functional study of the solution passing thru the development of the required software solution or evolution. Finally, we proceed to the delivery in the production environments. When all these steps are completed and accepted by the client, I proceed to the drafting of the required documentation. The documentation for the solution provided will describe its deployment in production and for its recording and supporting the context of the application and its evolution (SDLC)

To provide a more concise and point by point description of my tasks in this environment I describe next those steps:

•I collaborate in the drafting and/or modification of the documents in the requirement gathering from client. To proceed to the functional study of the request for the application’s evolution and/or development. Subsequently, under the conduct of the business analysts’ and the scrutiny of the client’s requirements, I draft new technical or new organic analysis documentation.

•Draft files on cost and estimates for developments and evolutions

•Draft exploitation documents

•I develop packages for data Extraction, Transformation and Loading (ETL processes), the process is done by several means starting by Shell KSH scripts and Oracle technologies: PL/SQLv3.20 via scripts, packages, ORA stored procedures and functions, SQL Loader

•I assist and follow-up the functional validation phase from Analyst

•I provide correction of anomalies to issues at the functional audit, and deployment testing phase

•I take part to the hot fixing of incidents in production

•I supervise and certify the chronogram processing delivery

•I play a part in the improvement of the overall software solution operations

•I draft documentation of the development process

•I produce BI reporting solutions and development on the SAP Business Objects (BO XI) platform

The knowledge required to perform my tasks are:

Knowledge of relational databases (SQL), in particular Oracle 10g, 11g (PL/SQL). A knowledge of

•Environment and Queries Optimization (database 20TB)

•Master of Oracle tools (SQL Plus/SQL Loader)

•UNIX environment and development shell (ksh) expertise

•Knowledge of the versioning tool Windows and command line Tortoise

•Knowledge of ETL tools (ETI*extract, MS SSIS)

•Understanding of SAP BO XI, WEBI and DESKI

Among the skills that help me to excel on this position are:

•I efficiently manage oral communication and written in English and French between partners and stakeholders

•I am reactive to switch subjects as required, passing from::

Development phase to

•management and fix of anomalies of the QA phase to

•Researching, solving and applying hot fixes in production etc.…

•I have good negotiation skills to: be able to propose technical solutions to optimize the processes and to propose the best technical solution

•I have a good interpersonal skills: which assist me in collaborative work within the department and inter-operational groups

•I am capable to manage multiple projects at the same time

•I am Autonomous. Particularly I know how to find the information using the documentation and existing tools as well as the web

Technical environment: Windows 7 and AIX Bash 5.3. Tortoise (Win versioning) SQL developer, PL/SQL, Oracle 10g, 11g, SAP BO XI, FileZilla, putty, UltraEdit, Citrix VM, Autosys, SAP Sybase IQ, Shell/Perl Scripts

October 2012 to February 2015 Société General ME EDC – BDDF(Paris)

BI Developer, engineer of functional analysis, design and development (ME-EDC) Commercial Data Warehouse and Datamart’s at Société Générale. Supervision, organization and development of ETL processing and integration of data in the Data Warehouse and DataMart. The process began from the code development as well as the deployment of the final application and the supervision of the daily and month end process in production

Within a development team I participate under the responsibility of the project leader to:

•The drafting of functional documents DCDI (Dossier de Conception Détaillé en Informatique) under the conduct of Business Analysts reflecting the client’s requirements into technical documentation

•The study of the impacts and the costs estimates

•The drafting of the documentation of exploitation

•The Development of application of data loading and data extraction of the data warehouse (predominantly by an ETL, the rest of the development uses shell scripts KSH and Oracle technologies: PL/SQL via stored packages ORA, SQL Loader)

•The assistance and follow-up of the functional validation phase

•The correction of anomalies after return of functional verification, integration tests

•The hot fix of incident in Production

•The supervision and the Chronogram validation of delivery

•The application optimization

•The documentation of the process of development

•End of Mission Contributed to the migration to new technologies Teradata DW, and ETL Data Stage

The knowledge required for this position are:

•Knowledge of relational databases (SQL), in particular Oracle 10g, 11g (PL/SQL). A knowledge of query optimization is desirable (volumetric of the database to 6TB)

•Master of Oracle tools (SQLplus / SQLLoader)

•Master of the UNIX environment and development shell (ksh)scripts

•Knowledge of a tool of versioning command line (Clear Case)

•Knowledge of an ETL (ETI*Extract)

The qualifications required for this position are:

•Reactivity and flexibility be able to move, without any specific order, from:

•To the functional Analysis and document drafting phase

•To the development phase

•To the management of anomalies returns of the QA process

•To the correction of issues in production

•Capacity of Proposal: To be able to recommend technical solutions to optimize the treatment and to suggest the best technical solutions

•Good relationship: collaborative work within the department and inter-operational groups

•Adaptability: the skill to manage multiple projects in parallel

•Autonomy: especially identify the required information using documentation and existing tools as well as the web.

Technical environment: Windows 7 and AIX Unix Bash 5.3.12.1, Hummingbird, Clear Case(versioning) SQL developer, PL/SQL, Oracle 10g,11g, Shell/Perl Ksh Scripts, FileZilla, putty, Ultra Edit, C/C++ Programming languages

July 2012 to August 2012 BNP Paribas (Paris)

Analyst ASF Department messaging inter-banking System - Plasma (BNP Paribas MOE plasma)

Supervision and organization of the Plasma Application life cycle from the development as well as deployment and technical support. The Plasma application is used everywhere in the world

Within a development team I participated in:

The technical support of the integration tests of plasma, on the environments of development, qualification, and production.

The Develop and analysis of the requirements, creation of environments, interfaces with other applications such as SIBES (mainframe application)

Guarantee the coordination of the technical teams of development, qualification and deployment in the framework of the recurring activities: installation, upgrade, qualification, benchmarks, tests, detection and reproduction of anomalies and incidents.

Improve the management of the technical environments by the adoption of suitable governance and the enrichment of the documentation of plasma for its installation and operation.

Validation of the technical documentation

Create and manage the documentation for the project and support (document of installation, deployment and exploitation)

Collaborate in the Project steering.

Follow contacts with suppliers/publishers.

Technical environment: Windows 7 and AIX Bash, SQL.PL/SQL Oracle 10g, FileZilla, Putty, Notepad++

February 2010 to May 2012 NIKON Inc. Montréal

Analyst / Developer, Business Intelligence - Data warehouses within a team of 7 people. Point of contact for the Business analysts, developers and the technical support as well as any other activity related to the various technologies (architecture and software) of the Internal Nikon BI department. Admin/Developer of MicroStrategy

•Solve / analyse / research issues or problems, related to the BI MicroStrategy system or to improve queries in reports that are too slow or too complex under MS SQL server.

•Responsible of the BI MicroStrategy technologies software and hardware infrastructure as well as of their maintenance and upgrades

•Ensure the validity of the technical choices regarding the BI platform and its components

•Maintenance and evolution of the life cycle of the applications, process under my responsibility more in particular the BI Platform: MicroStrategy BI platform and VMware virtual environment (Windows Server 2008).

•In my role as the MicroStrategy administrator I managed the licenses pool for exploitation,

creation, deletion and maintenance and troubleshooting of user’s pool.

•Technical support for complex problems of 2nd and 3rd level issues, regarding the BI Platform.

•Participate in the development and improvement of standards and procedures for application infrastructure

•I participated in the implementation of the required MicroStrategy environment components (like: functions, filters, KPI, etc.) for the reports analysis and creation.

•I gather and analyze client’s requirements and requests for new MicroStrategy reports, charts, dashboards. within the scope of MicroStrategy platform

•I created the required MicroStrategy reports in assistance with business analyst to model and translate technical client’s requirements into financial reports and also production reports for the company’s CFO office consumption.

•I lead a MicroStrategy technical team for the platform environment upgrade for two different upgrades from version 7.5 upgrading to version 8.1

8.1 upgrading to version 9.2

•Participate in the planning and implementation of special technical projects: Introduction, research and selection of an ERP tool for integrating of all system of NIKON

Technical environment: Windows and Linux, SQL.SERVER 2005/2008/2012, T-SQL, MS SSIS, MS SSAS, MicroStrategy BI Platform, ERP, VMWARE

Contact this candidate