PepsiCo Iberia IT OPS APP MGT - ESSA APPS IBERIA

Strands is a Fintech company. I work in DATA department, as a pool for different projects of our different banks/customer that uses our software.I was doing development in pl/sql, to make new functionalities and for bug fixing. I work in oracle 11 and 12 environments. Creating, monitoring and making new shell files, I use stash, Jenkins maven in our environment as tools to make auto deploys. Use of Jira for ticketing and confluence a as s documentation

1-Maintenance project with user environment. Use of pl/sql. Toad. MicroStrategy web version 9.Extraction of huge amount of data from DWH to make data analysis and reporting for internal use of the Bank.Making databases and programming in VBA in MS Access 97 and 2003.2-Maintenance project in Datawharehouse department of Banc Sabadell. Use of pl/sql, unix(hp-ux), mainframe IBM, making all cycle from host to datawharehouse conversion.Finally managing microstrategy and making datamarts for end users.Participation in the migration process from Oracle 10g to Oracle Exadata.

Proximity Barcelona, an online marketing company from BBDO Group. The final client is VAESA (Volkswagen-Audi España), the importer and distributor of Volskwagen, Audi and Skoda in Spain.Obtain data from VAESA DWH with sort of stored procedures to have data segmentation due to the client´s needs for CRM. All procedures are developed in Oracle 11g Database. In a Unix environment, use of simple scripts,and also I make some DBA tasks.Use of Sap APD. Use of ETL and BI tools like Kettle from Pentaho (http://kettle.pentaho.com/) in order to make data transformation and to generate reports in Excel or PDF format. Use of time control tools and resources like manymoon, do, redmine and slimtimer. Track projects using SCRUM.Development and implementation of APD's (Analysis Process Designer) in SAP XPRESS.Advanced user of SAP CRM.Small developments of ABAP routines.

Maintaining and developing of the project in Insurance company MC Mutual. Forms and reports11g, reporting, making views, scripting in Pl/Sql on Oracle 10g database. Tuning of queries to improve availability of data resources.Solving isues in Oracle Application

For Indra in two projects:1-Zeus project for Gas Natural Fenosa company. Work in database group, executing script, import/export. Support to project developers, 400 users.2-CaixaBank maintaining project for financial risk applications, to report to Spanish Central Bank. Pl/sql in Oracle 11G. Maintaining and new developments, creations of tables, views, procedures, preparation of loader from mainframes with use of KSH and CTL files.

I worked in three projects:1-Maintenance and support for a insurance companya (Mutua) in Oracle Forms/Reports 6i/10G and Pl/Sql.2-Via Everis in ADPl. Maintenance in BPM Metastorm. Pl/Sql packages procedures, views. Tunnig of Oracle database 10g.3-Project for Iecisa at "Departament d'Educació de la Generalitat de Catalunya"(Education system department of Catalan Goverment). Development in pl/sql, tunning of Databases.Creations of packages, views in Oracle 10g enviroment.

Collaboration with EVERIS for Ono an Spanish telecommunications company.for maintenance project called "SIRED" developed in Oracle Forms 6i. Using an 9i Oracle DatabaseIntensive use of Pl/Sql.

Project for ICF(Instituc Català de Finances) , it's the catalan "public" bankMaintenance and new developments in Oracle Forms & Reports 10GUse of Pl/Sql.

Suport project in Danone.Using ESSBASE, EIS also in Oracle Datawharehouse with Microstrategy.InformaticaOracle doing some Pl/Sql procedures.

In a cementer company, established in the industrial belt of Barcelona. Maintenance and evolutionary of a huge range of applications done in Forms and report in oracle 6 environment and also in Oracle 10 g. (Near Technologies SL)

Programmer analyst in CRM of Oracle. Forms Reports, packages, Discoverer. Migration of versions.

01.2006-04.2006 Evolutionary and corrective maintenance of applications for CATSALUT (catalan health agency), 40 applications in environment Oracle HPUX 10g and Forms and Reports 9i.04.2006-08.2006 Project in Mutual Cyclops (private health) for integration with Mutual Midat. Creation of scripts for the integration of data, packages.

Developing in Designer 9i, Developing of Forms and reports 9i, an application's management of budget for Universitat Pompeu Fabra. Design of reports in the Discoverer against a data base Oracle 10G. Creation of views, packages, triggers, procedures as much at level of forms/report as in the nucleus.

Managing of the project in Hospitable Sector in Oracle environment in Unix/SqlFormsSqlReports, operation of data, development in php to mysql. Developer 6i, Reports.

Technician in Oracle/Developer 6i DBA 8i/Teacher of Developer 6.Training of a group of four people. Project in Developer 6 for an Insurance company.

Hospital application in UNIX. SQLForms, SQLReports.Maintenances of a hospitable application in SQLFORMS 3.0, development of reports and screens in Developer 2000 4.5 to convert into SQLFORMS.

Junior Oracle DeveloperDevelopment of an application of management for a staple fibre company. Development inOracle Developer 2000 Forms 4.5 Reports 2.5. Building the application from beging until final version, after that we made maintance of that application.