Business analyst

Joa*** ***** (XX años)
Business Data Analyst Lead en Sogeti (outsourced for HP Inc.)
Universidad Ramon Llull - Instituto Qímico de Sarria (IQS)
Barcelona,
Barcelona
|
Experiencia
Business Data Analyst Lead
Sogeti (outsourced for HP Inc.)
jun 2013 - Actualmente
COORDINATION:

•  Team Lead. Responsible of organizing and providing guidance to eight additional business analysts.

REPORTING:

•  Reporting Structure Enhancement. Identification of Business reporting improvement areas, workshop with information stakeholders and creation of custom solutions/reports in order to cover those gaps

•  KPI Report creation. Developed a set of in-depth reports based on business-requested metrics, while also building a KPI Scorecard to provide a summarized overview to the management.

•  Qlikview and Power BI report design and development. Responsible for the creation of both deep-dive data models and Manager-oriented Scorecards

•  Ad-hoc Reporting: supporting Customer Assurance, Marketing, Operations, Engineering and R&D departments

•  Database reliability validation. Working along with different departments in order to verify, identify and correct possible gaps/mismatches on key-business databases.
EMEA Hardware and Services Business Analyst
Ferre Trenzano (outsourced for HP Inc.)
mar 2009 - feb 2013
REPORTING:

•  Reporting Structure Improvement. New view and tools creation for the reports in order to give a clearer view of the business for the Management. 

•   Qlikview report design and creation.

•   Coordination of responsibilities within the reporting team and with the Customer Care Center in order to accomplish customer needs.

•   Reporting Business evolution in a weekly basis, identifying growth and gaps versus Quota.

•   Quota setting process: Support in the FY10 calculations for a product line of the business at a sub-region level.

•   Ad-hoc Reporting: supporting Marketing, Sales and Finance Departments.

PLANNING:

•   Supply Chain Planning, based on future deal info, ensuring Spare Part Kit stock availability and fast response.
Business Analyst (Worldwide)
Ferre Trenzano (outsourced for HP Inc.)
ago 2006 - feb 2009
REPORTING:

•   New Sellout Reporting tool development, unifying the data of the different regions for its analysis.

•   Developer of a new tool for Hardware products, based on Access, giving additional detail and improving the reporting output for that product line. 

•   Management of customer response card database. 

•   Ad-hoc Reporting: supporting Marketing, Sales and Finance Departments.

•   Quota setting process: Support in the FY08 and FY09 top-down calculations for one of the main product lines at a Region level (Europe Middle-East and Africa / North America / Latin America / Asia Pacific and Japan).

TRAINING:

•   In charge of the training of new recruits for reporting department.
 
PRODUCT MANAGEMENT:

•   Product manager of a new accessory for a large format printer.
Channel Product mgr. Junior
Grupo Editorial Planeta
jun 2005 - jul 2006
REPORTING:

•   Access Database creation in order to provide a repository of the business information and a better view of the results.

•   Tracking and analysis of a new business daily sales and monthly results.

COORDINATION:

•   Responsible of the coordination of the Marketing department with external call centers in order to provide the required output information.
Finance Trainee
Unilever
sep 2004 - feb 2005
ANALYST:

•   Costing Analysis for new products and creation of different scenarios for marketing department.

•   Contributor on Fiscal Year 05 Sales plan creation, working with the different marketing Product Managers in order to build the mix of sales.
Formación
Business Administration Graduate
Universidad Ramon Llull - Instituto Qímico de Sarria (IQS)
sep 2000 - jun 2004

          
        
Idiomas
Catalan - Native/Bilingual
Spanish - Native/Bilingual
English - Full professional proficiency
French - Limited working proficiency