Curriculum Vitae
Candidate Franco Soldera Oracle Support Consultant
Profile The consultant is a senior Oracle technical supporter and advisor with expert competences in Incident and Problem Management specializing in troubleshooting and data analysis. The consultant is an expert in 2. and 3. level technical support.
Contact Drejøgade 26C, lejl. 203 2100 Copenhagen Ă˜ Denmark mobile: +45 22 86 61 00 fs@fsitaps.dk
The last 2 years the consultant has worked intensively with Oracle OSB and Weblogic with focus on technical support and architecting process in ITIL/Remedy. The consultant has worked with ITIL processes since 2006, also in connection with GxP systems and was ITIL certified in 2009. The consultant is an Oracle database specialist with more than 10 years of experience - including a background as a PL/SQL (SQL) developer from 1999 to 2006. The consultant also has related experience with Oracle operations and administration. The consultant has primarily worked with the following competences/technologies: Oracle, Oracle OSB, Oracle OWB, Oracle EBS, Oracle EMGC, PL/SQL, Oracle Application Server, Weblogic, Siebel CRM, ITIL, Remedy, and Oracle ALSB.
Work Experience Summary Date
Position
Employer/Client
Jan 2012 - Sep 2012
Support manager
2MinuteCV
Feb 2010 - Jan 2012
Senior Oracle Technical Supporter
PFA Pension
Nov 2009 - Mar 2010
Process Architect
NNIT for Alka
Jul 2009 - Nov 2009
Senior Oracle Tech. Supporter
NNIT for Novo Nordisk
Franco Soldera
Page 1 of 13
Curriculum Vitae Jun 2009 - Aug 2009
Support and Implementation Architect
NNIT for Novo Nordisk
Sep 2008 - Dec 2008
EMGC monitoring setup for Siebel
NNIT A/S
Nov 2006 - Feb 2009
Interface coordinator and supporter
NNIT for Novo Nordisk
Jun 2003 - Oct 2006
Senior System Analyst/Developer, Technical Support
BrĂźel & KjĂŚr
Aug 2002 - Apr 2003
Team Leader, Analyst/Developer
ONE-ANS for A.B.I. - Italy
Jul 2002 - Oct 2002
Database Designer
ONE-ANS for Agip - Italy
Jan 2002 - Apr 2002
Project Coordinator, Analyst/Developer
ONE-ANS for Omnitel - Italy
Dec 2001 - Jun 2002
System Analyst/Developer
ONE-ANS for Hewlett Packard - Italy
Jun 2001 - Nov 2001
System Analyst/Developer
ONE-ANS for Same DeutzFahr - Italy
Jan 2001 - Jun 2001
Skill Manager
ONE S.p.A. - Italy
Jul 2000 - Feb 2001
System Analyst/Developer
ONE for Hewlett Packard Italy
May 2000 - Jul 2000
System Developer
ONE for Pricewaterhouse Cooper - Italy
Apr 2000 - May 2000
System Analyst/Developer, System Design
ONE for Ericsson - Italy
Oct 1999 - Apr 2000
System Developer
ONE for Omnitel - Italy
Jan 1999 - Sep 1999
System Developer
Dinamica S.r.l. - Italy
Certifications - ITIL V3 Foundation in IT Service Management - Siebel 7.7 Analytics Data Warehouse Certified Professional - Siebel 7.7 Analytics Server Architect Certified Professional - Under preparation (already attended recommended courses for SOA Suite 11g): Oracle Service Oriented Architecture Infrastructure Implementation Certified Expert
Franco Soldera
Page 2 of 13
Curriculum Vitae Skills Programming languages
SQL, PL/SQL, XML/XSLT, PERL, Java, HTML, Javascript, Cobol
Tools
Test Director/WinRunner, HP Quality Center, BMC Remedy, DataStage, JIRA, Oracle Enterprise Manager, Oracle Workflow, Oracle Warehouse Builder, Oracle Forms, Oracle Reports, Oracle SQL-Developer, VL-Trader, Embarcadero ER Studio, Oracle JDeveloper, MS Visio, Podio
Web services / SOA
Oracle Service Bus, ALSB
Application servers
Oracle Application Server, BEA Weblogic
Oracle Applications
Oracle E-Business Suite, Oracle Applications, Siebel CRM
Databases
Oracle v. 7.3 to 11g, PostgreSQL
Languages Danish
Fluent
English
Fluent
Italian
Mother tongue
Franco Soldera
Page 3 of 13
Curriculum Vitae Work Experience Jan 2012 - Sep 2012 Responsibility
Support manager
2MinuteCV
Advice and implementation of the support cycle (1st and 2nd level) and bug tracking/feature request processes. The consultant's responsibilities/actions were: - Implementation of bug tracking and feature request processes implemented in Podio - Release planning - Test management - Users support. Used technologies: SQL, PL/SQL, PostgreSQL, Podio, HTML, CSS, LESS, Adobe Muse, Linux, JSON, Javascript, J2EE
Achievements
Franco Soldera
The product has been successfully adopted as part of the Copenhagen Career Program organized by Københavns Kommune in collaboration with ITU, DTU and Prosa.
Page 4 of 13
Curriculum Vitae Feb 2010 - Jan 2012 Responsibility
Senior Oracle Technical Supporter
PFA Pension
Senior Oracle technical supporter/troubleshooter, Technical Advisor and Incident Manager responsible for the OSB framework and related tools and helping management to accomplish the transformation of the whole support process to accommodate the future handover of the system operations to NNIT. The system was being migrated from a custom Weblogic service bus to Oracle Service Bus. There were severe performance problems and errors involving the core application and the other components of the messaging service architecture. The consultant's responsibilities/actions were: - Implemented ITIL processes involving the use of BMC Remedy Service Desk to register and document incidents, service requests, workaround and solutions in a structured way, providing the management facts and figures related to the quality of the system releases - Performed Remedy training to the support group - Prepared presentation material to be used by the management at the business level - Identify and solve more than 100 defects affecting the system. Used technologies: SQL, SOA, XML, SOAP, Oracle OSB, Weblogic, VL-trader, HP Quality Center, JIRA, Remedy
Achievements
Franco Soldera
- The OSB cluster has reached a very high level of stability, increasing the overall uptime from 65% to 99% in the latest 2 months - Handover of the support procedures to the new global support group completely documented and without disruption or loss of quality of the delivered support.
Page 5 of 13
Curriculum Vitae Nov 2009 - Mar 2010 Responsibility
Process Architect
NNIT for Alka
Process Architect for the migration of the datawarehouse loading procedures based on Oracle Warehouse Builder. The consultant's role was to understand the current setup and implement new procedures for remote upgrades from NNIT. Alka decided to move their Oracle based data-warehouse infrastructure to NNIT, since the release management was performed locally by ALKA employees. The challenge was to create new procedures enabling NNIT personnel to correctly perform complex release upgrades remotely from NNIT. The consultant's responsibilities/actions were: - Perform test and production upgrades - Produce documentation of the whole new process - Perform training sessions for the colleagues in NNIT support. Used technologies: Oracle Warehouse Builder, SQL, Remedy
Achievements
Franco Soldera
Since the handover of the system NNIT has been able to perform complex, well coordinated and error free releases within the expected service level agreements.
Page 6 of 13
Curriculum Vitae Jul 2009 - Nov 2009 Responsibility
Senior Oracle Tech. Supporter
NNIT for Novo Nordisk
Senior Oracle technical support/troubleshooter for the Register system based on Java (Oracle Application Manager) and PL/SQL (Oracle Database). The support duties were both daily technical support and release deployments driven by industry regulations, all of which had to be documented. The Register application (produced by Aris Global) is used to track the lifecycle and registration of drugs across different countries for regulatory purposes. The 2nd level technical support group for the system needed extra support due to frequent change requests and system errors introduced by new releases. The consultant's responsibilities/actions were: - Daily technical support - Deployment in all the test and production environments of patches and new releases - Troubleshoot an error that had been affecting the system for several months, causing a loss of data with severe consequences for the system's compliance - Produced documentation for the Operations Manual - Performed the technical analysis and found specific problems in many parts of the PL/SQL code. Used technologies: Register, JSP, Java, Oracle Application Server, SQL, PL/SQL, Remedy
Achievements
Franco Soldera
The recommended changes which were put in as patches, and now the system has no data loss and complies with industry requirements.
Page 7 of 13
Curriculum Vitae Jun 2009 - Aug 2009 Responsibility
Support and Implementation Architect
NNIT for Novo Nordisk
Implementation Architect for OrgPlus implementation project. The consultant worked in collaboration with the technical team of the company producing OrgPlus (HumanConcepts) to define the server requirements and perform test installations of the application (IIS + Oracle database schema deployment). NNIT needed to add Orgplus to the service catalogue to include OrgPlus in the offer, as it was a product requested by Novo Nordisk. The consultant's responsibilities/actions were: - Define server requirements - Perform test and production installation - Produce the final installation/configuration and operations manuals. Used technologies: OrgPlus, Microsoft IIS, SQL, Remedy
Achievements
The test and production environments have been very stable with optimal performances and uptime since the deployment.
Sep 2008 - Dec 2008 Responsibility
EMGC monitoring setup for Siebel
NNIT A/S
Setup the Oracle Enterprise Manage Grid Control to monitor a Siebel CRM application. As EMGC have been previously used in NNIT only to monitor Oracle database instances, FS´s task was to investigate how to leverage the new monitoring opportunities at the application level and prepare the configuration of EMGC for the production. The implementation of Oracle Enterprise Manager Grid Control was dictated by the need to reduce the licensing cost of the Patrol monitoring application and monitor with higher granularity and better control of the SLA for the Novo Nordisk Siebel CRM application. The consultant's responsibilities/actions were: - Map the Siebel landscape in EMGC - Configure EMGC metrics and SLA - Configure and create new reports based on standard and custom metrics - Document the configuration steps and produced the operations manual. Used technologies: Oracle Enterprise Manager Grid Control, SQL, PL/SQL, PERL, Remedy
Achievements
Franco Soldera
The reduction of false alarms and the new custom metrics provides the operations team the possibility to be proactive and detect issues before the malfunctions become manifested.
Page 8 of 13
Curriculum Vitae
Nov 2006 - Feb 2009 Responsibility
Interface coordinator and supporter
NNIT for Novo Nordisk
Interface Coordinator, supporter/troubleshooter, optimization of DataStage jobs that were of loading data from different sources into the Siebel CRM system. FS was hired to help the customer's IT department to deal with the complex architecture of the DataStage jobs and the challenges with the coordination with the offshore development group based in India. Novo Nordisk is using Siebel CRM module to manage the customer database (doctors and medical structures). This customer database collects data from several data sources and companies who provide medical data and global sales inputs. The consultant's responsibilities/actions were: - Supported, developed and implemented changes in the DataStage jobs and batch configuration - Mentored the development group and set up of development guidelines - Coordinated release deployments with the offshore development group - Troubleshot and optimized the main daily batch - Produced and organized all the documentation related to the interfaces. Used technologies: DataStage, Siebel CRM, Siebel Tools, SQL, PL/SQL, Visual Source Safe, Remedy
Achievements
Franco Soldera
The execution time of the biggest daily batch went down to the 30% of the original execution time, allowing to run it every day and reducing the number of data corrections and related costs, with a simplified batch structure that was less expensive to maintain.
Page 9 of 13
Curriculum Vitae Jun 2003 - Oct 2006 Responsibility
Senior System Analyst/Developer, Technical Support
BrĂźel & KjĂŚr
Senior System Analyst/Developer, Techical Supporter of the Oracle Applications framework (E-Business Suite), development of new features and interfaces for the EBS instance and 2nd/3rd level support to production/test environments, with also occasional DBA duties. The consultant's responsibilities/actions were: - Perform technical support of production and test environments - Develop XML label printing and barcode scanning interface to EBS for the shipping department - Migrate the Applications database character set from WE8DEC to UTF8, cleaning up 1,2 millions row - Optimize the scripts provided by Oracle with 90% reduction of the execution time - Implement Oracle XML Publisher printing solution for Oracle Applications - Develop new RTF and PDF form documents for XML Publisher. Used technologies: Oracle Apps 11.0.3-11.5.8, Oracle Database, Oracle Forms, Oracle Workflow, Oracle Reports, Oracle XML Publisher, Oracle APEX, SQL, PL/SQL, SQLLoader, XML, HTML, Javascript, Java
Achievements
- The use of APEX removed the additional licensing costs (compared with the Oracle Mobile Application proposed by Oracle) and reduced the development time. The delivery chain time was improved by 30% with a reduction to almost zero errors during the preparation of the shipping and 50% reduction of the time spent in the annual inventory check. - Migration successfully implemented in a completely transparent way for the users and delivered on time. - Improved the flexibility of the preparation of documents (invoices, shipping lists). Faster implementation and modification of layouts adherent to the legal requirements of more than 20 different countries.
Aug 2002 - Apr 2003 Responsibility
Team Leader, Analyst/Developer
ONE-ANS for A.B.I. - Italy
- Perform the coordination of the Java development group - Develop PL/SQL packages interfacing with the Java application - Prepare a proof of concept for the replication of data between the two customer's sites in Milano and Rome. Used technologies: Oracle Database, SQL, PL/SQL, Java
Achievements
Franco Soldera
The project was completed within the original time line and the consultant regained the trust of the customer, which approved a new long term project involving 2 additional developers from the same company.
Page 10 of 13
Curriculum Vitae
Jul 2002 - Oct 2002 Responsibility
Database Designer
ONE-ANS for Agip - Italy
- Design the new database schema - Perform data cleanup before the migration to the new schema - Release to production the new application. Used technologies: Oracle Database, Embarcadero ER-Studio, SQL, PL-SQL, JSP, Java
Achievements
The new version was delivered on time with excellent performance and no data inconsistency issues.
Jan 2002 - Apr 2002 Responsibility
Project Coordinator, Analyst/Developer
ONE-ANS for Omnitel - Italy
- Coordinate Omnitel technical group with ONE-ANS and external consultants - Prepare an architectural study and proof of concept of interface from SMS portal service (Oracle 8.1.7) to the N-Plex (Critical Path) system using PL/SQL stored procedures. Used technologies: Oracle Database, SQL, PL/SQL
Dec 2001 - Jun 2002 Responsibility
System Analyst/Developer
ONE-ANS for Hewlett Packard - Italy
- Develop new customizations in Oracle Forms and Oracle Workflow for the Marketing Online and TeleSales modules - Prepare scripts for testing with WinRunner/TestDirector. Used technologies: Oracle Apps 11i, Oracle Forms, Oracle Workflow, PL/SQL, SQL, WinRunner, TestDirector
Jun 2001 - Nov 2001 Responsibility
System Analyst/Developer
ONE-ANS for Same Deutz-Fahr - Italy
- Design and developed custom forms - Create PL/SQL data interfaces - Develop an e-mail alerts system in PL/SQL. Used technologies: Apps 11i, Oracle Forms, SQL, PL/SQL
Franco Soldera
Page 11 of 13
Curriculum Vitae
Jan 2001 - Jun 2001 Responsibility
Skill Manager
ONE S.p.A. - Italy
- Implement the information flow within project managers and consultants - Interview and technically assess new candidates - Perform resource allocation and management - Organize training courses. Used technologies: Microsoft Office, Lotus Notes
Achievements
Expanded the company's e-Business Division from 28 to 65 consultants.
Jul 2000 - Feb 2001 Responsibility
System Analyst/Developer
ONE for Hewlett Packard - Italy
- Develop new customizations in Oracle Forms and Oracle Workflow for the Customer Profile module - Prepare scripts for testing with WinRunner/TestDirector - Perform training in WinRunner scripting for new consultants assigned to the project. Used technologies: Oracle Apps 11i, Oracle Forms, Oracle Workflow, PL/SQL, SQL, WinRunner, TestDirector
Achievements
Created a custom panel for printer assignment that was then included in a release of Oracle CRM suite.
May 2000 - Jul 2000 Responsibility
System Developer
ONE for Pricewaterhouse Cooper - Italy
Develop PL/SQL data cleansing and data interfaces. Used technologies: PL/SQL, SQL, Siebel2000 eCommunication
Franco Soldera
Page 12 of 13
Curriculum Vitae Apr 2000 - May 2000 Responsibility
System Analyst/Developer, System Design
ONE for Ericsson - Italy
- Collect the user requirements - Design a data model to include the changes to the current system - Develop PL/SQL stored procedures to support the migration and operation of the customization. Used technologies: Oracle Designer 2000, SQL, PL/SQL, Remedy
Oct 1999 - Apr 2000 Responsibility
System Developer
ONE for Omnitel - Italy
- Perform technical support - Create and modify PL/SQL stored procedures. Used technologies: PL/SQL, SQL, Remedy.
Jan 1999 - Sep 1999 Responsibility
System Developer
Dinamica S.r.l. - Italy
- Develop PL/SQL stored procedures - Develop HTML/JavaScript code - Develop Java servlets. Used technologies: PL/SQL, SQL, Java, HTML, JavaScript
Franco Soldera
Page 13 of 13