Summary of Qualifications:

. **+ years information technology industry experience

. Financial industry experience in banking, futures and options trading

and clearing

. Healthcare industry experience in document control

. Knowledge of star, snowflake schemas and multidimensional databases

. Hands on experience and knowledge of technologies including Oracle.

Informatica, Business Objects and Crystal Enterprise

. Long term development and business experience, communicate well with

all stakeholders, optimize objectives,

. Leverage state of the art tools and best practices, integrate into

corporate systems and deliver on time

. Relational (OLTP) and dimensional (BI/Data Warehouse) data modeling

experience

. Hands-on development

Technical Skills:

Languages: SQL (Oracle, DB2, Sybase, Informix), Java, EJB, JEE, C++,

XML, HTML, JSP, Perl, shell scripting, TCL

Development/Modeling Tools: Oracle GoldenGate, Oracle ODI,

Informatica, ERWIN, Rational Rose, Oracle SQL Developer,

TOAD, Oracle GoldenGate, OBIEE, Crystal Reports, Business

Object, MS Access, MS Excel, Visio, Eclipse, WSAD, MS Visio,

MS Project, Agile Methodology

Operating Systems and Concepts: UNIX (Linux, AIX, Solaris, SunOS,

BSD), Weblogic, WebSphere, MS-DOS, X-Windows, Windows

98/2000/XP/7, Macintosh O/S, Mainframe

Industry Experience:

Bank of America, Manhattan, NY

7/2013 - 12/2013

GoldenGate Lead Architect

. Global Credit Data Warehouse

. Lead the final design of the Global Credit Data Warehouse system

. The design involves an Active/Active configuration

. The data is loaded in Near-Real-Time

. Trained people in-house on Oracle GoldenGate

. Made recommendation for growth of system which involves the use of

an Oracle Exadata system

. Involve in selection and hiring of GoldenGate developers

Citco Fund Services, Jersey City, NJ

2/2008 - 7/2013

Data Warehouse Lead Architect

. Operation and Support

. Analyzed and built Proof of Concept on different Replication

Systems

. Help in the selection of Oracle GoldenGate as the new replication

tool

. Implemented and deployed a replication system for Data Warehousing

(3+ TB), Auditing and DR

. Trained people in-house on supporting Oracle GoldenGate

. Involved on POV for an Oracle Exadata system

. Initiated the migration to Exadata

. Claris Application and Claris Reporting

. Supervises the design by a team in India of the Data Model for the

application

. Works extensively with the Business Analysts

. Interfaced with the QA analyst throughout the project lifecycle

. Manages a team based on Salvador, Brazil, including a Team Lead,

Data Architect and ETL developers

. ODI was selected to load data into data warehouse

. BOXI Crystal Report was selected for reporting

. Aexeo Data Warehouse.

. Overlooked the design and development of the system by a team based

in India

. Involved in the selection of the technology for the data warehouse

. ODI was selected to load data into data warehouse

. OBIEE was selected for reporting and data mining

. Reviewed the project at the major milestone

. Corporate

. Involved in selecting Oracle Data Enterprise Edition as the

business standard for the next 6 years

. Involved in selecting OBIEE as the business standard for the next 6

years

. Provides direction and guidance to the different groups in the

company

ICE Futures US (Formerly NYBOT), New York, NY

6/2004 - 2/2008

Data and System Architect

The Common Framework provides the basis of enterprise architecture and

model based development. It is a set of Banking Industry specific

foundation-, data-, process- and object-models.

. Billing System

. Designed System Architecture based on the Common Framework

. Structured business requirements, designed conceptional data model

and integrated with the data warehouse

. Calculated efforts and compiled Project plan

. Interfaced with the QA analyst throughout the project lifecycle

. Compliance System.

. Overlooked the design and development of the system by a team based

in India

. Lead the design of the data model and integrated with the data

warehouse

. Interfaced with the QA analyst throughout the project lifecycle

. Market Surveillance System

. Gathered the requirements and designed the system architecture

based on the Common Framework

. Lead team of 7 developers to implement the system

. Designed the object and data model and integrated with the data

warehouse

. Financial Surveillance System

. Gathered the requirements

. Designed the system architecture by extending the Market

Surveillance system

. Extended the Market Surveillance System object and data model

. Data Warehouse for Market Analysis

. Lead data modeling for corporate data warehouse

. Structured business requirements and designed conceptional data

model

. Selected Informatica to load data into data warehouse

. Selected Crystal Report for reporting and Business Object for data

mining

Diversified Investment Advisor, Purchase, NY 11/2001

- 06/2004

Data and System Architect

The framework provides the foundation for an enterprise pension system. All

applications are built on top of it in order to make maintenance and

changes easier.

. Plan Conversion System

. Started as senior developer and became Data and System Architect

after some changes were done to the department.

. Designed replacement Data Model for pension plan as part of the

Data Architect Team

. Designed with System Architect Team the framework for the Pension

Plan.

. Responsible for one of the teams that built the plan conversion

system.

. Access Control System.

. Worked with Enterprise Data Architect Team to design Data Model

. Met with development teams to gather business requirements.

. Designed physical object model and general architecture

. Calculated efforts and compiled Project plan.

. Worked with development team and performed testing

. Customer Support System

. Gathered the requirements from Customer support and designed the

system architecture.

. Designed the Data Model by meeting frequently with the Data

Architect Team.

. Managed the development team throughout the development lifecycle.

. Portfolio Management System

. Gathered the requirements from the business analyst and company

representatives.

. Enhanced the Data Model and built a Data Mart as needed.

. Worked with system architect of remote team to design the system

architecture.

. Responsible for development by local team.

. Talked with remote system architect on a daily basis to track

development lifecycle

U.S. Trust, Jersey City, NJ 11/1999 -

9/2001

System Architect / Team Leader

. Responsible for system architectures of a Web Site for Investment

Banking.

. Managed senior and junior developers.

. Interface with the users in gathering the requirements, wrote

technical documentation using UML, RUP.

. Interface with vendors, evaluated products and made recommendations

on products

. Implemented change management system.

. Documented procedures for developing application modules and

trained team members

. Hands on development. Designed and wrote the framework for the

system using Servlets and EJBs.

. Designed the Data Model and database schema.

. Provided business/system support for the Investment Banking system.

. Architecture of the system was based on J2EE and Visual C++. Used

IBM WebSphere for first phase and BEA WebLogic for second phase.

Citibank, Queens, NY 6/1999 -

9/1999

System Architect

. Spent six weeks in Dallas with the system engineers to learn the

internals and understand to functionality of the server they

developed. The server is part of the Global servers, written in C++

on HP/UX

. Wrote technical documentation using UML and Rational Rose.

. Interface with vendors, evaluated products and made recommendations

on products

. Spent six weeks in Queens:

o Evaluating deployment and integration options

o Evaluated different architecture for the system

o Built a prototype with the system

o Made recommendation on deployment of the system

o Train local users on the system

Standard & Poors, New York, NY 7/1998 -

6/1999

System Architect / Team Leader

. Responsible for system architecture of a framework for the

corporate intranet and extranet.

. Managed senior and junior developers.

. Interface with the users in gathering the requirements, wrote

technical documentation using OOAD

. Interface with vendors, evaluated products and made recommendations

on products

. Hands on development. Designed and wrote the framework for the

system.

. Developed a Java application server, which acted as a socket server

and RMI server.

. The application server was designed to received documents from

various sources, convert them as needed and deliver them the

different clients.

. Developed a parser and transformer for SGML and HTML templates.

. Provided business/system support for the distribution system.

. Developed client applications in C and C++ on VAX VMS, open VMS and

Sun Solaris.

Chase Manhattan Bank, New York, NY 12/1997

- 6/1998

Data and System Architect

. Researched and gathered knowledge on security issues in the banking

industry.

. Designed a Data Model to store user profiles and security

resources.

. Designed system architecture of the framework for a Global Sign-on

and an Access Control System on the corporate intranet.

Oracle Corp, Redwood Shores, CA 3/1997 -

11/1997

System Architect / Team Leader

. Responsible for architecture of the framework for a Web based

training system on the corporate intranet.

. Met actively with users, business partners and senior level

management to gather the requirements, design the system and the

data model.

. Wrote the technical documents used as a binding contract for the

interface between the different business partners.

LifeScan, Inc. (a Johnson & Johnson Company), Milpitas, CA

2/1996 - 2/1997

Programmer / Analyst

. Performed another phase of changes to the document change control

system for manufacturing of bio-medical devices

. Worked extensively with the users and the vendors

. Implemented the changes to the system and wrote stored procedures

and database triggers

. Provided business and system support for the system.

Oracle Corp, Redwood Shores, CA 9/1995 -

1/1996

Programmer / Analyst

. Designed the system architecture for a failover/failsafe system for

the Oracle database

. Worked closely with the users to gather the requirements and with

vendors on available tools

Providian Bank, San Francisco, CA 6/1995 -

8/1995

Programmer / Analyst

. Designed and implemented batch processes for a credit card accounts

maintenance system

. Wrote processes as daemons in C using embedded SQL, database

triggers and stored procedures to access an Informix database.

LifeScan, Inc. (a Johnson & Johnson Company), Milpitas, CA

12/1994 - 5/1995

System Architect

. Responsible for the architecture of a document change control

system for manufacturing of bio-medical devices

. Gathered the requirements from the users; met with the vendors to

specify the requirements for the development tools

. Designed and implemented the data warehouse

. Provided business and system support for the system.

Visigenic Software, San Mateo, CA 8/1994 -

11/1994

Software Engineer

. Implemented architecture changes and enhancements recommendation to

new products being developed, a Windows 4GL called V/Forms use to

write COBOL applications on a UNIX platform and porting an ODBC

framework to UNIX

Ask Group, Inc., Alameda, CA 8/1993 - 7

/1994

Technical Support Engineer

. Supported preferred customers and escalated calls on the different

components of Ingres, including Tools for Dos/Windows, OS/2;

Windows 4GL, Embedded SQL, the database server for different

platforms, which included: VAX/VMS, Unix (HP/UX, Sun Solaris, NCR

Unix, Sco Unix, etc), Windows.

Canada Post Corporation, Ottawa, ON, Canada 6/1992

- 7/1993

Data Architect

. Involved in a National Change of Address system for the National

Post Office which manages the mail for the entire country

. Performed Business Analysis with domain experts

. Data modeled the process, referential integrity and security

. Created a large number of tables, views, stored procedures for

OLTP and OLAP

. Setup, administered and tuned Oracle 6 Parallel server on NCR

Parallel server

. Supported the development tram with ad-hoc data query and

manipulation

. Developed batch-processing modules, user tools

. Supported the development team and production operators in SQL

Forms, SQL Plus, SQL Report Writer, PL/SQL, and Pro*C

. Monitored the performance of the database on the HP and NCR

platforms and wrote some scripts to monitor the database in order

to improve the overall performance

. Involved in designing and implementing a backup strategy for a 24

hours/7 days a week system with a 4 hours window recovery time

Statistics Canada, Ottawa, ON, Canada 12/1990

- 05/1992

Analyst / Programmer

. Designed the architecture of a system to gather and summarize the

sales and revenues

. Programmed the system in C++ and shell scripting on Sun Solaris and

provided technical support to the users.

Revenue Canada, Ottawa, ON, Canada 5/1989

- 11/1990

Software Engineer

. Analyzed changes for the Income Tax system due to changes in the

Income Tax act.

. Wrote the function specifications, performed system and functional

testing

. Involved with the users during user acceptance testing.

. Traveled to different district offices to supervise and review

their process and made recommendations for system changes or

improvement to the process.

Paroisse Notre-Dame du Tr s-Saint-Rosaire, Gatineau, QC, Canada

1988

Analyst / Programmer

. Gathered requirements to design and develop a system in DBase to

manage the birth, marriage, death records and all revenues for the

church..

Centre Franco-Ontarien des Ressources P dagogiques, Ottawa, ON, Canada

1987

Analyst / Programmer

. Gathered the requirements from school board members and designed

and developed an object and data model and educational software

using C++ and shell scripting for the French Ontario school boards.

. Provided training in the different schools.

Commission de Transport de la Communaut R gionale de l'Outaouais, Hull,

QC, Canada 1986

Analyst / Programmer

. Gathered the requirements, designed and developed an object and data

model and a set of tools for the city public transportation

organization. The main tool, developed in Fortran on a Prime system,

was used to keep track of the positions of all buses in the city in

real time.

EDUCATION

Bachelor degree in Computer Science - May 1988

Universit du Qu bec Hull (UQAH)

Hull, Qu bec, Canada

3 years of computer science in systems

Coll ge Militaire Royal de St-Jean

St-Jean d'Iberville, Qu bec, Canada

Royal Military College of Canada

Kingston, Ontario, Canada

Oracle GoldenGate - June 2012

Oracle

New Jersey

Oracle Data Integrator - June 2008

Oracle

New Jersey

Informatica PowerCenter 7 Developer- February 2005

Informatica

New York, NY

Ingres Windows 4 GL - March 1994

Designing High Performance System - September 1993

The Server Core - September 1993

Call Handling Methodology - September 1993

Managing Ingres Database - September 1993

The Ask Group Inc.

Alameda, California, USA

Supporting Windows NT - January 1994

Supporting Windows NT Advanced Server - January 1994

Microsoft Corp.

Alameda, California, USA

Introduction to DMR P+ MethodologyTM - September 1992

DMR Group Inc.

Ottawa, Ontario, Canada

Database fine tuning - January 1993

Application fine tuning - January 1993

Database Administration Version 6 - August 1992

Database Administration Workshop Version 6 - Aug. 1992

ORACLE Corporation Canada Inc.

Ontario, Canada

UNIX System Administration - 1991

Ottawa, Ontario, Canada

Applied Prokit & Work-BenchTM - Jun. 1990

Advanced Structured Analysis & Design - Feb. 1990

McDonnell Douglas

Ottawa, Ontario, Canada

Interpersonal Skills for Systems Analysts Workshop - Jul. 1989

Revenue Canada

Ottawa, Ontario, Canada

Contact this candidate