SUMMARY:

• I have over 17 years of experience in systems consulting for the private sector, public sector and abroad.
• I understand the position of both service provider and client.
• My multicultural experience allows me to work efficiently with people from different nationalities and cultures.
• On this basis I can guarantee results in different areas of systems such as transactional systems development, implementation of Business Intelligence solutions, Data Analyst, Data Marts and Data Warehouse design.
• Occupying a position of high responsibility in a company’ Confidential System Division where I can place information technology as an enabler in achieving the tasks of both operational and executive level users.

TECHNICAL SKILLS:

Technology adn Tools: Office, MSProject, PowerPoint, SPSS, OUM (Oracle Unified Method), ERWin, SQL Developer, TOAD.

PROFESSIONAL EXPERIENCE:

Senior Consultant

Confidential

Responsibilities:

• I was in charge of the whole development life cycle of a medical praxis operation system; I set all the necessary meeting with the client in order to gather user requirements.
• The system should schedule pacients appointments and follow client’ Confidential visits to doctor’ Confidential praxis. The system also controls medical fees and Confidential t total and partial payments.
• I also designed a control for all medical lab studies and Confidential t’ Confidential medical history.
• I was also in charge of data modeling, user interface design, forms and reports programming. It was developed using oracle forms 11g over Oracle Application Server.

Skills used: Data Analisys, Data Modeling, Oracle Forms Development, Oracle Reports DevelopmentSQL, Data Base Objects Creation (Tables, Indexes, Users).

Oracle Principal Consultant

Confidential

Responsibilities:

• During the implementation of "Demantra" in Confidential in Austin, Minnesota, developed in PL / SQL a number of critical procedures for extraction, transformation and loading of information (ETL’ Confidential ) in an extremely short time frame, since the project was delayed upon my arrival and the budget did not allowed time extensions.
• I also implemented a procedure that reduced the processing time of critical programs using parallel processing with data ranges parameters reducing processing time from 50 minutes to 4 minutes. Enhanced a number of existing programs to include the functionality to receive parameters to enable them to perform the same task by ranges of information reducing processing time in all of them in more than 80%. Mapped in ODI source tables to populate specific staging tables used by Demantra’ Confidential engine for forecast generation poupuses.
• During my assignment to the internal DWH project "Impact" I was named "POC" (Point of Contact) between users and the Confidential ´ Confidential Data Warehouse Service Desk.
• Designed a process manual intended to solve user´ Confidential SR' Confidential (Service Request) expeditiously.
• This enabled the SR' Confidential outstanding list to be reduced to 50%; favorably impacting average response time in this division.
• During a DWH hands on, I led a group of three consultants and designed the entity relationship diagram representing the transactional data source.
• I also defined the Star Schema for a Confidential, defined a hierarchy in the RPD and finally integrated the created reports into a OBIEE Dashboard.
• Documented the unit and functional tests performed over thePL/SQL code procedures.
• During my stay in the DWH project for Confidential in Iowa City, Iowa,
• I eliminated Cartesian products in wrongly defined extractions in ODI mappings.
• I coded a parametric discrimination of individual values in concatenated data string.
• Mapped source - target data and created workflows from source systems to staging and Data Warehouse tables using ODI.
• During my assignment in an internal oracle IIS project I used Oracle APEX and solved failures in a series of executive reports, migrated the corrected version to Test, QA, Staging and Production environments.
• Built installation packages containing installation manual, source code, database scripts and the necessary images for successful migrations of developed applications.
• In NAFIN I developed a system for "money market" which replaced the former one.
• In the absence of source code for the Oracle forms "Exchange Market" system, I had to add the required functionality through the use of Database Triggers.
• Prepared the functional design and Entity Relationship layout for the financial instrument called "Futures".

Skills used: Requirement Gathering, Data Analisys, Data Modeling, PL/SQL Coding (Stored Procedures, Functions, Packages, DB Triggers), Oracle Forms and Reports Development, Data Base Objects Creation (Tables, Indexes, Views).

Business Intelligence Consultant

Confidential

Responsibilities:

• I started the BI area of the company, where participated in the development of a DWH (Data Warehouse) to cover the supply chain process of Confidential Co.
• During this project I worked with OBIEE, RPD and INFORMATICA-DAC for the ETL' Confidential development.
• I reviewed the workflow, mapping and maplets to assure DWH’ table population used for specific group of dashboards.

Skills used: Troubleshooting in a Oracle Performance Management Implementation Using OBIEEInformatica and DAC.

Senior Consultant

Confidential

Responsibilities:

• I was responsible for ETL´ Confidential processes reengineering (Extraction, Transformation and Load) for the DWH of the General Office of the Ministry of Finance and Public Credit ( Confidential ).
• I evaluated the extraction methods accuracy and tuned their performance through the implementation of stored Data Base Procedures programmed in PL / SQL.
• For National Lottery made 80% of the analysis and 100% of Data Modeling and design for the new substantive lotteries system, leading a 7 people team.
• Completed integration scripts for the unification of two cloned systems operating separately at National Lottery. I set up the necessary mechanisms of migration through “control numbers” to ensure quality and reliability of the integration.
• Added new functionality to existing software systems. I used Erwin for the design and Forms9i for construction.

Skills used: Mantainance, Data Modeling, Oracle Forms Development, Data Base Objects Creation (Tables, Indexes, Constraints, Views, Users).

Business Analyst

Confidential

Responsibilities:

• Analyzed, designed the Data Model and programmed in PL/SQL the necessary Forms and Reports for UAF (Fiduciary Adminstration Unit) creating a configurable system capable of covering the operation of any type of Fiduciary and financial resources investment, allowing the configuration of concepts and its effect on equity.
• It made possible to create Fiduciary with different porpuses, and configured amounts definition, frequency and restrictions on payments.
• Made the fiduciary system migration to the Integrated Universal Collection environment; this was the first successful case in the Integration of Universal Collection Business strategy.
• Coordinated maintenance activities for Universal Collection System, and the integration of insurance products such as individual life and individual major medical expenses.

Skills used: Project Management, User Requirement Analisys.

Data Architecht Consultant

Confidential

Responsibilities:

• Validated the DataMart model against source system data mapping documents. Identified and documented inconsistencies in the data mapping definitions. Designed recommendations for the Data Model

Skills used: Dimentional Data Modeling, Data Analisys, Documentation.

Application Support Manager

Confidential

Responsibilities:

• Interpreted Confidential requirements and regulations for new creation and modification of different modules of Pension Fund Management System and created the specifications needed.
• For Afore Capitaliza I development the commission payments module using PL/SQL, Forms and Reports (Developer/2000),
• I also modified and developed for Afore Inbursa the Affiliation, Sales Force and Marketing modules. Trained users in the operation of the modules as they were released.
• Provided telephone support to users. Planned, organized and led a group of 6 developers in charge of developing requested changes and new features. I was in charge of the Systems development life-Cycle, Quality Asurance of the Data Modeling, PL/SQL coding, Forms and Reports look and feel, and time release of the modules.

Skills used: Project Management, Resource Management, QA, Service Desk.