Profileimage by Marcelo Moraes Systems Analyst COBOL; Analyst ETL PowerCenter; BI Consultant;PL/SQL Developer from RiodeJaneiro

Marcelo Moraes

available
Contact

Last update: 02.09.2017

Systems Analyst COBOL; Analyst ETL PowerCenter; BI Consultant;PL/SQL Developer

Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Full Professional) | Portuguese (Native or Bilingual) | Spanish (Limited professional)

Attachments

marcelo-nunes-de-moraes---cv---english.docx

Skills

EXPERT

COBOL, CICS, DB2, IDMS, JCL, VSAM, TSO, ENDEVOR, ECCOX, Z/OS, OS-400;
ETL, PL/SQL, POWERCENTER, SHELL SCRIPTS, ORACLE
 
 GENERAL KNOWLEDGE
 
PowerCenter | Unix, Shell Script | COBOL, COBOL II,COBOL III, COBOL/DB2, COBOL/CICS, COBOL/IDMS, ADS, EASYTRIEVE, EASYTRIEVE PLUS | databases IDMS, DB2, ORACLE, PL/SQL, SQL | AS-400, CL – Control Language | Mainframe AS/SET, KEY/MASTER Data entry for mainframes, ROSCOE, CHANGEMAN, QMF, REXX, JCL, MVS, VSAM, TSO, ENDEVOR, ECCOX, Erwin, TRACEMASTER | Interface analysis, Requirements Engineering, UML | J2EE, STRUTS, HIBERNATE, MVC2 | Java, C#., IIB(IBM Integration Bus)
 

Project history

PROFESSIONAL HISTORY
 
Provider-IT – October 2013 to April 2017
Systems Analyst | Client: Bradesco Insurance and pension
 
2016 Olympics Project – creation of Maps, preparation of chains of JOBs for the CONTROL-M, unit testing and Integrated testing. Project Sales Organization Data Warehouse sales organization, acting on data extraction to provide sales information from various branches for managerial analysis. Technologies: Computer PowerCenter, PL/SQL, Oracle, UNIX, Shell Scripting, CONTROL-M.
 
Marketing Project. TSO, COBOL, DB2, QMF, CICS (CECI, CEDX, CEDF), ECCOX, TRACEMASTER, SPUFI, FTP, Shell scripting, Oracle, ERWIN data modeling, PL/SQL. Analysis, distribution and client demands; Integrated tests making artifacts for implementation of changes and corrections requested by the client; administrative activities for testing, approvals and production deployments.
 
Mongeral Aegon/Triscal -November 2010 to September 2013
SR. Systems Analyst | Client: Mongeral Aegon Insurance and pension
 
Environment: AS400, COBOL400, COBOL/DB2, CL, SQL, PROCEDURES, FUNCTIONS. Support tools: Rational Developer for Power Systems, VIVAZ, PROJECT BUILDER. Preparation and maintenance of programs, specific fixes, SQL service at customers ' requests.
 
Cpmbraxis | Capgemini -October 2009-August 2010
SR. Systems Analyst | Client: Bradesco Insurance and pension
 
Warning System of claims and payments system AUTO/RE. Service client requests as creating new routines/programs, system fixes, performance improvements in access to DB2 database with COBOL, CSP programs, creation of CICS transactions, evolutionary changes, emergency corrective. Tests of programs, new implementations, approval and implementation in production. Environment used ROSCOE, CHANGEMAN, QMF, TSO, ECCOX, Erwin, TRACEMASTER. Communications between the WEB (Java), CICS, DB2 via CSP, CTG and SERVTRAN. Integrated tests.  of changes and corrections requested by the client; Testing, approvals and production deployments etc.
 
DBA Engenharia de Sistemas -March 2008 to June 2009
SR. Systems Analyst | Client: Caixa Econômica Federal
 
Development of COBOL / CICS, COBOL / DB2, COBOL / DML (COBOL ACCESSING IDMS) and ADS Dialogs so that PIS registration can be carried out directly by companies via WEB. Development of a load program in the WEB MANAGEMENT system that will account for the migration of the cash registers to the companies. Responsible for communications between WEB (Java), CICS, DB2, IDMS. Coordination of integrated tests. Punctual maintenance in COBOL / IDMS batch / online programs. Accompaniment of homologation. Making of artifacts for implementation of changes and corrections requested by the client
 
Rede Reis | Feedback Languages | Consuelo Pinheiro Institute – Aug/2006 to Feb/2008
Free Lancer, developing user support of low platform systems
 
TMPC CONSULTANTS IN INFORMATION -January 2004-August 2006
Systems analyst
 
Maintenance of the payroll system, support to users. ORACLE-building scripts, procedures and functions. COBOL, PL/SQL Programming
 
Course Interaction Ltda -November 2000-September 2003
Systems analyst/DBA
 
Replacing system developed in Clipper no longer answer the needs of the company. I was responsible for the definition of Server and workstation equipment deployment of new School management system (Developed in ASP/MS-SQL), IIS configuration, installing and configuring the MS-SQL and doing periodic maintenance. Also working on support for users of the system.
 
EDS | HP Enterprise Services -October 1989 to June 1996
Systems analyst | Client: General Electric of Brazil
 
Development, maintenance and production support; support to users of various systems on the client, GENERAL ELECTRIC, being among them: billing system, freight Calculation system, purchase order and machine manufacturing system. Active participation in various processes of migration systems data entries.

Time and spatial flexibility

I'm available for travel and change

Contact form

Contact details