Summary:

• Over 18 years of experience in the full project life cycle development of large-scale and mid range information systems for the effective implementation of enterprise applications to suit the business needs of Fortune500 companies.
• Over 5 years of experience as Business Intelligence Administrator. Strong administration skills OBIEE 11g RPD , ETL Informatica 8.6.0 , Cognos IBM TM1 Architect and IBM TM1 Perspectives 9.5.1, Cognos 8 Report Studio, Microsoft SSIS, SSRS, SSAS. Tableau Admin , Desktop and Public.
• Data Modeler / Data Warehouse professional with over 4 years of applied Information Technology IT experience, specializing in the development of Data Warehouse/Business Intelligence architecture that involves data integration and the conversion of data from multiple sources and platforms. Strong data modeling following Kimball methodology as well as physical/logical/dimensional modeling skills.
• Over 12 years of experience in developing and customization of forms and reports using Oracle Developer Suite Forms with Object Libraries and Templates , Oracle Discoverer 10g/6i/4i/3i for Oracle BI in Oracle ERP modules.
• Over 8 years of experience writing techno-functional MD50s of Oracle Financial 11i/11.03.
• Excellent skills in designing, development and implementation of application using Oracle 7i/8i/9i/10g/11g utilizing PL/SQL, SQL Plus, SQL Loader, Developer 2k/6i and Discoverer 3i/4i/10g on Win/Unix platforms.
• Strong experience in interacting with users from different segments, business analysts and developers to analyze the user requirements, functional specifications and system specifications. Experience acting as the primary Business Analytical Liaison between customers and development staff by assessing and communicating user needs, establishing priorities, and preparing needs for Development when needed.
• Worked extensively in large team environments with strong trouble-shooting, analytical, interpersonal and communication skills.
• Highly proficient developing, testing, and migrating IT deliverables. Senior adjustment to the lifecycle of technical development from technical design, unit testing to user testing, QA and production migration. Proven leader on high profile projects. Consistently demonstrates ability to communicate well with different organizational levels, from end users and technical staff to the executive level. Consistently meets tight deadlines and focuses on quality results.

Skills:

ERP: Oracle Financials Release 11i/101.03 GL,AP,AR, HRMS, FA, INV, ADI, FSG and System Administration .

Business Intelligence: Oracle Discoverer 10g/6i/4i/3i, OBIEE aka Siebel Analytics OBIEE RPD 7.9.6, ETL Informatica 8.6.0 , Cognos TM1 8 Business Intelligence Report Studio , TM1 Architech v9.5.1. Tableau Public Admin and Visualizations . Microsoft SSIS, SSRS, SSAS. Talend

Development Platforms: Oracle Development Suite, SQL-PL SQL, PHP, C/C , Unix Shell Scripting, Cobol AS400, Power Builder 8.0,

RDBMS: Oracle 7i/8i/9i/10g/11g Enterprise Edition, Microsoft SQL Server, Microsoft Access., MySQL, UNIFY 2000

Data Cleansing: Trillium v7.5

Software Tools: Oracle Forms Developer 2000 6i/5.0/4.5, Oracle Report Writer 6i/5.0/4.5, Oracle Discoverer Administration and User Edition 10g/4.146 , Noetix Views, XML Publisher,Oracle 9iAS Portals, Oracle SQL Loader Import/Export, I2-TMS, Hyperion, Crystal Reports 8.5, BIRT, SQL-Station Coder version 4.1.2, Toad, SQL Developer, SQL Navigator,Erwin, Business Objects, Citrix, Electronic Data Interchange EDI, ETL, XENCO LIMS

Version Controllers: WinCVS,Object Cycle and PVCS.

Desktop: Microsoft Office, HEAT, Remedy, Remote Desktop, Dameware, Net Meeting, Terminal Services . Smart FTP, VERITAS Backup, , VNC.

Web Technology: IIS, LAMP, HTML

Email: Microsoft Exchange Administration, PAM

Operational System: Win2008,Win2003, Win2000 Server, Windows NT, Workstation, 9x, XP Pro, DOS, Unix. Linux RedHat 4ES, UBUNTU

Hardware: LAN-WAN Configuration/Administration.

Telephony: Avaya IP Office phone system, TrixBox.

Fluent in English, French and Spanish.

Prior Experience

World Fuel Services INT Services

Senior Programmer/Analyst

Implementation and Administration of the OBIEE Suite Managing RPD in MUD environment . Back up support in ETL Informatica, DAC, Data warehouse back end. Second tier of support in Cognos TM1. Discoverer Administrator, created business structures and define End User Layer EUL for Discoverer 10g. Trained the end users of the business areas and provide guidance for Discoverer 10g environment. Defined security and granted privileges to users as Discoverer Administrator. Built Business Areas BA with joins, conditions and calculations. Prepared work books based on custom folders in BA's. Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, Slowly changing dimensions, foreign key concepts, referential integrity. Experienced in OLTP, OLAP, GUI, Relational Database Management Systems RDBMS and Report Development. Extensive Experience in creating repository, source, target databases for Extraction, Transformation and Loading ETL using Informatica Power Designer. Successful participation in the upgrade of Oracle 10g to

Confidential

Senior Programmer/Analyst

Create business structures and define End User Layer EUL for Discoverer 4i. Train the end users of the business areas and provide guidance for Discoverer 4i environment. Define security and grant privileges to users as Discoverer Administrator. Build Business Areas BA with joins, conditions and calculations. Prepare work books based on custom folders in BA's. Conversion of Oracle 11.Define and maintain the data cleansing processes for all the customer environments in the company. This data matching procedure gather a data set of different platforms such as Oracle 11i and Informatica to produce a cleansed file based on business rules. Confidential

Programmer/Analyst

Development and maintenance of Profits application to support the supply chain application of the company Oracle-Back End and Power Builder-Front End . Support the international user community Spain, NA, UK, Latin America, Japan, HK for the company in different environments such as Oracle 11i AP, AR, GL, 4 years , Discoverer 4.146 4 years , Data warehousing, Hyperion, I2-TMS, Crystal Reports 8.5. Responsible for the support of the Oracle Interfaces between AP, AR and GL in the main supply chain application. Implementation of the Transportation Management System I2-TMS solution for the business. Development and support of the interfaces of I2 with Oracle 11i. High level of customization, reporting and configuration effort Development and support of the Data warehouse environment In house ETL tool . Development and support of the Vendor Invoice System AP In house solution interfacing with Oracle 11i, platform in Developer 2K 6i . Create relational structures and define End User Layer EUL for Discoverer 4i.

Migration of the existing Oracle Discoverer 3i reports into 4i. Train the end users of the business areas and provide guidance for Discoverer 4i environment. Define security and grant privileges to users as Discoverer Administrator. Build Business Areas BA with joins, conditions and calculations. Prepare work books based on custom folders in BA's.

Confidential

Programmer/Analyst

Maintenance and implementation of the Market Prominence application software for the marketing department. This application handles the lead process, sales operation, contact, commissions, media control and is based on Oracle and Power Builder architecture.

Confidential

Programmer/Analyst

Support of the Global Billing Engine for Citibank USA. This software is composed by a Back End in Microsoft SQL Server, Middle Tier in Visual C , and a Front End in Power Builder. The communication platform is supported by ODBC and PC/DCE, the main goal is to calculate banking commissions handling any structural and organizational level.

Confidential

System Analyst

Design, development and implementation of a real estate system based on Oracle Developer 2000 Forms, Reports, SQL Report Writer, repository object navigator, Diagram generator Design, development and implementation of a loan system for the Employees Fund of a food products company in Colombia. This application included the management of loan and cash business transactions. The environment was PB and Informix Back End.