Business Intelligence Specialist
Page |1
Javier Rodriguez
M6E2S2. Toronto (ON)-https://ca.linkedin.com/in/jrodprof
-
Career Summary
I am a Business Intelligence specialist where I can offer 14+ years of experience in IT and 12 of them
in Business Intelligence field. Additionally, I hold a CAPM certification of Project Management
Institute. Experienced, flexible and international profile. Currently working for The City of Toronto as
a full time System Senior Integrator (Business Intelligence and Data Visualizations Specialist).
I love teaching and sharing my knowledge with my students. In April 2020 I delivered my first course
in Udemy:
https://www.udemy.com/course/lumira-discovery-professional
Key Skills and Attributes
•
Technologies: Tableau (Desktop, Prep and Sever), SAP Business Objects 4.3, Lumira 2.x
(Discovery and Designer), SAP Analytics Cloud, Information Design Tool (Integration with
Teradata, Oracle, Excel and SAP BW), Web Intelligence (Webi), Data Services, Analysis for
Microsoft Office, Analysis for OLAP. SAP BW (7.0, 7.3, 7.x on HANA. Integration with SAP BO,
Bex Query Designer, Open hub, BEx Analyzer, ABAP). Other technologies: JAVA, JavaScript,
SQL and Visual BI for Lumira Designer.
• Project management and leadership: Capable of overseeing projects as proven through
previous on the job experience and completing projects within time frames and budgets.
• Professional: Possess a personal commitment to exceed client expectations through attention
to detail, and the ability to thrive in time-driven environments.
• Communication skills: Excellent communicator with the ability to clearly understand and
impart information while finding common language with other team members.
Business Intelligence Consultancy Experience
The City of Toronto
Toronto (Canada)
Business Intelligence Services Team
www.toronto.ca
Senior System Integrator
March 2020 to date
Responsibilities:
• Supervisor of Business Intelligence team. As of today: 18 employees.
• Leading Tableau at enterprise level: developing dashboard for multiple divisions and
providing training to business users.
• Implements detailed plans and recommends policies/procedures regarding program specific
requirements.
JAVIER RODRIGUEZ |-
Business Intelligence Specialist
•
•
•
•
•
•
•
•
•
•
•
•
Page |2
Supervises, motivates and trains assigned staff, ensuring effective teamwork, high standards
of work quality and organizational performance, continuous learning and encourages
innovation in others.
Supervises the day-to-day operation of all assigned staff including the scheduling, assigning
and reviewing of work. Authorizes and co-ordinates vacation and overtime requests.
Monitors and evaluates staff performance, approves salary increments, hears grievances
and recommends disciplinary action when necessary.
Provides input into and administers assigned budget, ensuring that expenditures are
controlled and maintained within approved budget limitations.
Leads, facilitates and contributes to the design, creation, development and sustainment of
corporate standards for Information Technology, including formalized project management
and methodology, data warehousing architecture, data modelling, metadata, change
management, and application development and migration.
Provides leadership in the area of enterprise BI & Data Analytics at tactical, project and
operational levels including data integration, data modelling, Reporting and Analytics.
Lead BI design, development, testing to ensure applications meet the needs of the business
and compliant to SDLC best practices.
Provides leadership in the evaluation, selection and recommendation of technical solutions
and professional services; manages vendors and contractors in the overall solution delivery
process.
Negotiates with senior management, clients and various stakeholders often with competing
and conflicting goals, objectives and priorities.
Provides assessments and recommendations of new technology trends on the effective use,
acquisition and integration of technology by the City.
Provides leadership to design, develop and/or acquire, test, and implement applications, and
sustain information technology solutions to meet business objectives and client needs.
Evaluate and improve existing BI systems and selection for new BI tools based on the
company strategy.
Recommends, implements and practices on BI & Data Analytics design and development,
privacy and quality assurance requirements consistent with MFIPPA, legislation and
corporate standards regarding storage retention and processing of confidential personal,
corporate and application data and information outputs.
Corporate Application Technical Leader
June 2019 to March 2020
Responsibilities:
• Implements developments regarding program specific requirements.
• Analysis and design duties as well as programming, modelling and scripting, testing,
documentation and deployment preparation.
• Leads, facilitates and contributes to the design, creation, development and sustainment of
corporate standards for Information.
• Technology, including formalized project management and methodology, data warehousing
architecture, data modeling, metadata, change management, and application development
and migration.
• Completes preliminary analysis, system and functional design, workflow diagrams for quality
systems development.
• Designs, codes, tests, implements and maintains enterprise systems.
JAVIER RODRIGUEZ |-
Business Intelligence Specialist
Page |3
•
Lead BI design, development, testing to ensure applications meet the needs of the business
and compliant to SDLC best practices.
• Coordinates and develops program specifications and documentation.
• Participates as a team member in the execution of EPM project plans providing technical
expertise and advice re: architecture, development tools, work effort estimates.
• Provides development support to users by providing technical assistance and
troubleshooting.
• Provides leadership in the area of enterprise BI & Data Analytics at tactical, project and
operational levels including data integration, data modelling, Reporting and Analytics.
• Provides development support across several project in sustainment team.
• Conducts research, investigates and recommends best practices for information and
application services.
• Provides assessments and recommendations of new technology trends on the effective use,
acquisition and integration of technology by the City.
• Provides leadership to design, develop and/or acquire, test, and implement applications, and
sustain information technology solutions to meet business objectives and client needs.
• Evaluate and improve existing BI systems and selection for new BI tools based on the
company strategy.
• Technical tasks: making reports with SAP BO 4.2 suite, Lumira 2.2 (Lumira Discovery and
Designer). Using Visual BI extensions for Lumira Designer. SAP BW developments (7.5 on
HANA). BEx query development including calculated and restricted key figures. Considerable
experience in Power BI.
• Training Staff: training business users from several divisions on SAP Lumira Discovery. Creation
of current Lumira Discovery course on ELI Platform.
System Development Specialist
April 2017 to May 2019
Responsibilities:
• Analysis and design duties as well as programming, modelling and scripting, testing,
documentation and deployment preparation.
• Completes preliminary analysis, system and functional design, workflow diagrams for quality
systems development.
• Designs, codes, tests, implements and maintains enterprise systems.
• Coordinates and develops program specifications and documentation.
• Participates as a team member in the execution of EPM project plans providing technical
expertise and advice re: architecture, development tools, work effort estimates.
• Provides development support to users by providing technical assistance and
troubleshooting.
• Provides development support across several project in sustainment team.
• Conducts research, investigates and recommends best practices for information and
application services.
• Technical tasks: making reports with SAP BO 4.1 and 4.2 suite, Lumira 2.2 (Lumira Discovery
and Designer) and SAP Design Studio. Using Visual BI extensions for Lumira Designer. SAP BW
developments (7.5 on HANA). Some BODS work.
• Working on several proof of concepts for FPARS project such as open data, section 37 and City
about results.
JAVIER RODRIGUEZ |-
Business Intelligence Specialist
Page |4
Everis
Madrid (Spain) and Bogota (Colombia)
Consulting, IT & Outsourcing professional services
www.everis.com
BI Project Leader
Prosegur
Spain
September 2015 to July 2016
Responsibilities:
• Working with data and reports in SAP BO (Web Intelligence) in several KPI’s of the company.
• Analyse the current situation to improve the management of reports. Diagnosing and
rectifying performance issues.
• Responding quickly to client requirements.
• Analysing data to identify business problems.
• Technical tasks: making reports with SAP BO 3.1 and 4.1. Web Intelligence, IDT and Lumira.
Maintenance and new universes in IDT. Queries in Oracle 10g.
• Management tasks: manage my team, conduct business meetings, and give SAP product
presentations to Prosegur.
• Used Agile Methodology.
BI Team Leader
BBVA Bank
Spain
June 2015 to September 2015
Responsibilities:
• Working in a dashboard in SAP BW to get information from SAP MM, FI and CO (connect to
Microstrategy through Bex Queries).
• Combined management tasks with technical tasks.
• Management tasks: management people, business meetings, requirements definition.
• Technical tasks: Modelling in SAP BW 7.0, data test, maintenance and new Bex queries, ABAP.
BI Project Leader
Ecopetrol
Colombia
July 2014 to May 2015
Responsibilities:
• Project leader of an up-to-5 member team. Automation of 17 KPI’s (financial, downstream
area and human resources area).
• In charge of the BI project with SAP BW 7.31 on HANA, SAP BO 4.1, SAP DS, SAP SSM and SAP
Lumira.
• Giving SAP Business Intelligence training to others.
• Mentoring less experienced work colleagues.
• ASAP Methodology.
JAVIER RODRIGUEZ |-
Business Intelligence Specialist
BW Senior Consultant
Pacific Rubiales
Colombia
Page |5
April 2014 to July 2014
Responsibilities:
• In charge of the upgrading of SAP BW 7.0 to 7.3 on HANA.
• Technical tasks: improving BW environment, stress test, charging data after the update,
diagnostic tests, user testing.
• Technical documentation.
• ASAP Methodology.
BI Senior Consultant
Ecopetrol
Colombia
December 2013 to March 2014
Responsibilities:
• In charge of analysing of Financial KPI’s. Financial performance solution. Analysis of financial
and petroleum indicators. Analysis Oil&Gas industry to provide Ecopetrol with a list of the
best KPI’s.
BI Team Leader
Ecopetrol
Colombia
December 2013 to April 2014
Responsibilities:
• In charge of developing of 10 KPI’s in SAP BW and SAP BO.
• Management tasks: team leader of an up-to-2 member team. Scheduled task, reporting my
project leader.
• Technical tasks: modelling in SAP BW 7.1, making reports in SAP BO 4.0 (webintelligence).
• Used ASAP Methodology.
BW Senior Consultant
Ocensa
Colombia
October 2013 to December 2013
Responsibilities:
• In charge of developing of a dashboard in SAP BO.
• Financial, general, and transport KPI’s.
• Working as a SAP BW consultant and team leader of an up-to-1 member team.
• Combined management tasks with technical tasks: BW 7.0 and BO 4.0, Web Intelligence and
Dashboard.
• Utilised Agile Methodology.
BI Senior Consultant
REPSOL
Spain
February 2013 to September 2013
Responsibilities:
• Responsible for developing several reports to be integrated in a CRM solution.
JAVIER RODRIGUEZ |-
Business Intelligence Specialist
Page |6
• Management tasks: as a senior consultant, I had to make documents about my hours, my work
and monitoring documents to provide my supervisor.
• Technical tasks: modelling in SAP BW 7.0, several reports BO 4.0 and Data services to transfer
data between Oracle and Teradata.
• Utilised Agile Methodology.
BO Consultant
AXA – Direct Insurances
Spain
April 2012 to October 2012
Responsibilities:
• In charge of developing approximately 80 reports with SAP BO (Web Intelligence).
Requirements analysis and making reports with SAP BO 4.0.
• International project in English: Member of a multicultural team with associates from Poland,
France, Germany, Spain and Portugal.
• Utilised Agile Methodology.
BI Consultant
Helvetia
Spain
January 2012 to April 2012
Responsibilities:
• In charge of data warehouse and reports. Making financial and insurance reports with SAP
BO 3.1 (Web Intelligence) and modelling data in SAP BW 7.0.
BI Consultant
Enagas
Spain
June 2011 to January 2012
Responsibilities:
• Charged with developing data warehouse and reports.
• Technical tasks: modelling in SAP BW 7.0, Query Designer and WAD repots.
Software Development Consultancy Experience
Junior SAP Netweaver Developer - Everis
Metro of Madrid
Spain
June 2008 to June 2011
Responsibilities:
• As a team member, I have involved in building SAP Web Dynpro JAVA components.
• Working in life cycle involving development, documentation, testing and maintenance (defect
fixing).
• Utilised Metric Methodology.
JAVIER RODRIGUEZ |-
Business Intelligence Specialist
Page |7
Indra
Spain
Spanish information technology and defense systems company
www.indracompany.com
Junior Software Developer
Bankia
May 2007 to May 2008
Responsibilities:
• Team member as Java software developer in Bankia’s systems migration projects. Bankia is
one of the biggest banks of Spain.
Education
CAPM Certification
Project Management Institute
Number-
March 2016
Master’s Degree in Computer Science Engineering
Polytechnic School of Caceres
Caceres, Spain
2000 - 2007
JAVIER RODRIGUEZ |-
