Ø Participated in the planning of the new Branch Technology Architecture that is supposed to become the new Client/Server business platform to account managers of the bank. Budget: US$ 14 million - estimated 2 years

Ø Participated in the specification of 300+ branch transactions for the new platform

Ø Evaluated development plans upon Microsoft WDNA platform presented by vendors of banking solutions according to the specification designed

Ø Built reports and comparative summaries for executive analysis, recommending the best vendor

Ø Established contacts and relationship with vendors, such as: Unisys and Procomp

"Call Center System"

Ø Planned and analyzed the Client/Server Call Center System which allowed the bank customers to access and deal with their accounts by telephone, totally integrated to the new Branch Systems

Ø Evaluated development plans upon Microsoft WDNA platform presented by vendors of banking solutions according to the specification designed

Ø Built reports and comparative summaries for executive analysis, recommending the best vendor

Ø Established contacts and relationship with vendors, such as: Unisys and Procomp

Ø Tested applications implemented in Windows NT 4.0, SQL Server 6.5, Visual Basic 5.0, MTS 1.0, DCOM

Ø Constructed database load software using Visual Basic 4.0 and SQL Server 6.5

"Help Desk Project"

Ø Evaluated a set of solutions presented by vendors of Help Desk frameworks

Ø Built reports and comparative summaries for executive analysis, recommending the best tool

Ø Established contacts and relationship with vendors, such as: IBM, Unisys, Remedy, Peregrine, etc.

"Web Interface for IBM Mainframe"

Ø Evaluated a Web tool for deploying mainframe applications through HTML interface

Ø Built reports and comparative summaries for executive analysis

Ø Deployed and supported the Leasing System database which was the first leasing product in Banco Mercantil do Brasil. It was also the first Client/Server environment at the bank

Ø Installed and configured Microsoft SQL Server 6.0 and 6.5

Ø Created and maintained databases, tables, indexes and security in Microsoft SQL Server 6.0 and 6.5

Ø Migrated databases from 6.0 to 6.5 version

Ø Analyzed and monitored performance of data manipulation through ODBC connections

Ø Supported the development of Visual Basic 4.0 applications for specific database tasks

"Insurance Database"

Ø Supported the Insurance System database that has been created for downsizing purpose in Minas-Brasil Insurance Company

Ø Acted as a consultant for the management staff about enhancements and reorganization of the database structure in the company

Ø Evaluated and designed replication solutions

Ø Installed and configured Microsoft SQL Server 6.0

Ø Created indexes and security accounts in Microsoft SQL Server 6.0 and 6.5

Ø Analyzed and monitored performance of data manipulation through ODBC connections

Ø Analyzed and monitored performance of data bulk load

Ø Supported the development of Visual Basic 4.0 applications

Ø Designed a Systems Planning and Development Methodology with 4 analysts from the other companies of the holding

Ø Designed a DBMS Evaluation Methodology with 2 analysts from the other companies of the holding

Ø Acted as a consultant for executive staff about the unified IT architecture for the holding, integrating the platforms and systems used by the companies

"Inventory System"

Ø Planned, analyzed, designed and developed the Inventory System which was used to keep the material management updated with the production necessity

Ø Implemented and maintained programs in Sterling ZIM at Unix Platform

Ø Analyzed, designed and implemented the Inventory database model

"Income System"

Ø Implemented and maintained programs for the Income System in Sterling ZIM at Unix Platform

Ø Maintained the Income database structure

Ø Planned, analyzed, designed and developed the Loan Liberation System which allowed the liberation process to be faced as a corporate workflow process and used by many areas of the company

Ø Implemented and maintained programs in IBM CSP and SQL/DS

Ø Participated in the analysis and design of Utilities® Material Management System in partnership with IBM consultants

Ø Implemented and maintained programs in IBM CSP and SQL/DS

Ø Evaluated IEW Case Tool

Ø Programmed in IBM COBOL and REXX

Ø Monitored SQL/DS database access performance through query analysis over CSP and COBOL programs constructed by other systems analysts

Ø Developed the Sheet Builder Software in FoxBase and Clipper, transforming Unisys mainframe data into VP-Info sheets

Ø Programmed in SADS for Unisys mainframe