Scrum Master Business Objects
Resume:
Carlos Gonzalez
***********@*****.***
English, French (spoken and written languages)
Profile:
Developer with a technical degree diploma in programming, i cumulated more than twenty-four years of experience including twenty-one of those years in the business intelligence area with tools such as IBM Cognos, SAP Business Objects, MicroStrategy, Tableau Desktop, Talend and Microsoft.
It didn't stop there as for I also followed Microsoft SSRS / SSIS, Tableau Software, Power BI and SCRUM master preparation.
Soft Skills
Easily adapts to a new working environment both technically as interpersonally and I get along with pretty much everyone. I always make sure to fulfill the assigned projects even if that means extra paid hours or even sometimes extra volunteering hours by sometimes leaving the office after business hours.
Technical Skills:
IBM Cognos: Analytics v11, Frame Work Manager, Transformer, Report Studio, Cognos Decision Stream, Query Studio, Analysis Studio, Report Net, Impromptu 7, IBM Cognos Life Cycle Manager.
SAP Business Objects: Analytics Cloud, Business Objects webi documents, Universe Designer Tool, Information Design Tool, Business Objects 6.5, Data Integrator, Crystal Reports 7, Crystal Reports 2008
Tableau software: using connection to Google Big Query, using connections to Amazon S3, using connections to Excel spread sheets
MicroStrategy: MicroStrategy Desktop 8 et 9
Databases: Oracle, SQL Server, DB2, Access, MySQL
Web: Web Standards, (X)HTML, CSS
Dell Boomi
Working experience:
June to May of 2024 (remote)
Infotek (TD Bank)
Position: BI Analyst (Tableau)
• Translated Tableau dashboards from English to French for the HR DAR Tableau Bill 96 Translation project.
• Modified SQL code in .twbx files to use appropriate French tables and values.
• Created and published data sources on the cloud (from existing «. twbx » files containing SQL code).
• Translated from English to French the TD Tableau Dashboard how-to-use videos.
January 2023 to May 2023 (remote)
BERGER
Position: BI Analyst
• Received the SAP Analytics Cloud training.
• Analyzed user's STORY needs by gathering their requirements while interviewing them through MS teams.
• created SAP Analytics Cloud Story.
• Performed SAP Analytics Cloud Administration tasks (Security management, SAP Analytics Cloud Application, JavaScript).
• Worked with Snowflake.
September 2022 to November 2022 (remote + Boucherville + St-Georges)
CANAM
Position: BI Developer
• Provided IBM Cognos 10.2 user support and administration.
• Handled DELL Boomi Support Incidents • SQL Navigator.
• MS SQL Server
• Worked with Google Big Query and Tableau Desktop.
• Participated in QA and Scrum meetings.
• Used JIRA (to inform the scrum master of my tasks progress)
• Created technical documentation using Confluence
November 2021 to June 24th 2022 (hybrid mode)
Lassonde
Position: BI Analyst
• Supported Incidents, Service Requests, and Change Requests related to Cognos 10 and Cognos 11 majorly caused by data discrepancy not the application.
• Performed SQL queries to search inside multiple MS SQL Server tables from different data bases in order to find why the reports, Dashboards and cubes were not showing correct data or no data at all. Versions 10 and 11 of Cognos.
• Administered Cognos 10 and Analytics 11.
• Modified existing Cognos Framework Manager models and developed new Cognos 11 Analytics reports.
• SCRUM meetings for the Cognos 10 to Cognos 11 migration project named “LX” (Less than 15% of my time)
• Create appropriate technical documentation for all Cognos 10 report that needs to be converted to Cognos 11 Analytics for the “LX” migration project (Less than 15% of my time)
• Developed new Cognos 11 Analytics reports based on the appropriate technical documentation
• Used JIRA (to inform the scrum master of my tasks progress)
November 2020 to January 2021 (hybrid mode)
ALTEN CANADA (for Dynamite / Garage)
Global fashion retailer with two brands at the heart of its success, Garage and Dynamite.
Position: Contractor - Cognos Analytics (11) Developer
• Analyzed client's reporting/dashboards business needs (Finance, Sales) by gathering their requirements while interviewing them in person.
• Created new Cognos 11 Dashboards and modified existing ones.
• Performed data testing.
• Used JIRA (To inform the manager of my tasks progress)
August 2020 to November 2020 (3 months in hybrid mode)
GDG Informatique et Gestion (Investissement Québec)
Financial Society
Position: Contractor - Cognos 10 Developer
• Developed impactful Cognos 10.2 reports driving key decision-making.
• Provided precise time estimates for Cognos report development.
• Enhanced existing Cognos reports for optimized performance.
• Contributed to all scrum meetings, ensuring seamless collaboration.
November 1fst 2019 to February 2020 (3 months)
Infotek (TD Bank)
Insurance Bank
Position: Contractor - Business Intelligence Analyst
• Converted SAS programs to HQL for seamless integration in HIVE
• Analyzed and debugged SAS code to ensure accurate HQL translation
• Collaborated with internal clients to clarify and document program requirements
• Enhanced code efficiency by directly correcting SAS errors in HQL
March 2019 to September 2019 (6 months)
ALTEN CANADA (for Dynamite / Garage)
Global fashion retailer with two brands at the heart of its success, Garage and Dynamite.
Position: Contractor - Cognos Analytics (11) Developer
• Gathered client requirements for Finance and Sales reporting
• Designed and refined Cognos 11 dashboards
• Conducted data testing to ensure accuracy
• Enhanced user experience through customized solutions
Sept 2018 to March 2019 (6 months)
Infotek (TD Bank)
Bank
Position: Contractor - Cognos Developer
• Revamped existing Cognos 10.2 reports for optimal performance.
• Delivered accurate effort estimates for reporting and dashboards upon request.
• Assisted business analysts in comprehending existing Cognos 10.2 reports for precise functional analysis documentation.
• Supported level 1 support team by troubleshooting report bugs.
• Documented complete implementation process of Cognos reports from DEV to PROD
April 2018 to August 2018 (6 months)
Facilité Informatique (Acquired by CGI in June 2018) – (working at CN)
A Leading North American Transportation and Logistics Company
Position: Contractor - SAP Business Objects developer
• Enhanced SAP Webi docs via universe connections, optimizing reporting solutions
• Revamped SAP Webi docs using BEX connections, driving data accuracy
• Delivered PoC and provided work estimates, ensuring project feasibility
• Analyzed universes with SAP IDT to optimize data source understanding
21 August 2017 to 21fst November 2017 (3 months)
STINGRAY
Stingray Digital Group Inc. is the world-leading provider of multiplatform music services and digital
Position: Tableau Desktop / Talend Open Studio developer
• Developed actionable dashboards with Tableau Desktop using GoogleBigQuery/MySQL
• Enhanced ETL processes using Talend Open Studio for improved efficiency
• Compiled app usage statistics via AppAnnie, AppBots, and AppFigures on-demand
• Updated Excel files monthly with manual new subscriber entries for accuracy
• Generated on-demand subscriber info from MySQL for V.P. requests
• Utilized Slack and JIRA for efficient team coordination
• Leveraged Cloudberry and Cygwin occasionally for specific tasks
June 2017 to mid August 2017 (3 months)
AMG Medical
Company that manufactures, imports, packages, and distributes home healthcare and medical
professional products.
Position: Contractor - IBM Cognos Report Studio
• Identified reporting needs by collaborating with company president
• Crafted Cognos Report Studio dashboards for visualizing 4-year sales
• Enhanced sales analysis with 'Moving Average' metrics for insights
• Assessed requirements for Cognos Event Studio Alert for prompt action
April 2016 to April 2017 (13 months)
Fx Innovation (for National Bank of Canada)
Bank
Position: Contractor - IBM Cognos / SAP Business Objects Analyst
• Identify and document client reporting needs in SAP Business Objects
• Enhance and correct SAP Business Objects webi reports as needed
• Modify SAP BO universes for projects like 'Consumer Goods Financing' using IDT and UDT
• Develop IBM Cognos dashboards for accounting and capital management
• Model data using IBM Cognos Framework Manager with DB2 databases
• Monitor IBM Cognos server for performance, manage groups/roles
• Evaluate impacts of LDAP upgrades for authentication providers
21 March 2016 to 22 April 2016
PLANAXIS (Full time for a month / part time for half a month while also working at National Bank of Canada)
IT Consulting firm now merged with TALAN
Position: Contractor - IBM Cognos Analyst
• Gathered and analyzed Cognos reporting requirements from stakeholders
• Developed Cognos reports aiding Directors and President in revenue analysis
• Created Cognos Event Studio alerts to inform President on performance metrics
• Automated month-end performance reports for timely decision-making
November 2015 to February 2016
ALITHYA (for Desjardins)
Financial Institution
Position: Contractor - IBM Cognos
• Utilized IBM Cognos Report Studio 10 to develop reports based on functional analysis documentation.
• Developed new models using IBM Cognos Framework Manager.
• Provided feedback on functional analysis documentation to optimize development time.
• Conducted data analysis queries to validate report results.
• Created a “Frequently Asked Questions” document to streamline report creation time.
September 2014 to June 2015
UAP Inc.
Heavy Vehicle Piece Division Selling Enterprise - Montreal
Position: BI Analyst
• Interviewed business partners to analyze and meet requirements
• Developed advanced reports using IBM Cognos Report Studio 10
• Modeled and published packages with IBM Cognos Framework Manager
• Administered Cognos security, permissions, and model migration
• Created and managed Cognos cubes using Cognos Transformer
• Provided Level 2 support to assist Level 1 Cognos developers
• Installed IBM Cognos 10 on Windows 2008 servers
• Set up Cognos 10.2.2 for iPad compatibility
• Developed simple database fixes using SQL Server
• Modified stored procedures in SQL Server for optimization
• Updated NAPA Store Sales data mart with Cognos Decision Stream
• Evaluated 10 SSRS reports for potential Cognos migration
• Tested Microsoft SSIS packages to identify and resolve bugs
July 2013 to September 2014 (14 months)
ALITHYA (for UAP Inc.)
Heavy Vehicle Piece Division Selling Enterprise - Longueil
Position: Contractor - IBM Cognos analyst
• Identify client needs; create Preliminary Analysis documentation
• Develop impactful reports using IBM Cognos Report Studio 10
• Successfully upgrade from Cognos Impromptu v7 to Cognos Report Studio 10
• Leverage Excel/VBA for precise monthly report creation
• Utilize Microsoft Access 2010 for data management
• Deliver proof of concept to showcase solutions
November 2010 to end of July 2013 (3 Years)
Lowe’s (formerly known as RONA)
Retail Sale Enterprise (Boucherville)
Position : BI Analyst
• Analyzed customer needs to optimize user meeting outputs
• Created comprehensive proof of concept and functional analysis docs
• Modified SAP Business Objects XI webi and Crystal Reports 2008
• Developed MicroStrategy v8 and v9 reports and reusable objects (facts, attributes, metrics, filters, hiearchy, prompts, etc.)
• Documented test plans and facilitated MicroStrategy object migration
• Resolved MicroStrategy Desktop issues through support ticket management
• Enhanced SalesForce reports as needed
• Existing "Store Procedures" modifications (occasionally)
• SAP BO Universe Designer - Modelling (occasionally)
April 2009 to November 2010 (1.5 years)
ALITHYA (for Métro Richelieu)
Food Retail sale enterprise
Position: IBM Cognos Report Studio developer
• Identified client reporting needs via direct interviews with end users/management
• Developed detailed reports using IBM Cognos Report Studio 8, Analysis & Query Studio
• Deployed 'TM1' cubes to Cognos packages using IBM Cognos Framework Manager
• Ensured uptime for Cognos environments; liaised with support teams for issue resolution
• Report specification documentation
• SQL
Other great accomplishments :
-Develop a traffic management software for the transport companies such as LIMOCAR located in the town of Boisbriand allowing to digitalise the bus driver’s "road sheets" in order for the network directors to take the appropriate decisions.
-Participate from A to Z in an ETL Business Intelligence project for a client named Workopolis (3 months).
Academic training :
College Degree Diploma 2000
Programming, André Laurendeau college, Montréal (qc.)
Additional Education
DELL Boomi 2022
BIG DATA (Hadoop Certification Training) On going
Agiles Methods, Scrum Master Certification Preparation (PSM 1) 2017
Collège de Maisonneuve
Tableau
Introduction (Senturus.com) 2016
Tableau Desktop 10 Training and Certification (www.intellipaat.com) 2019
Tableau Online,Desktop, Tableau Prep, Tableau Cloud 2022
Microsoft
Microsoft Power BI (www.intellipaat.com) 2024
Microsoft MCSA Certification On going
Microsoft SSIS (John Abbott College) 2017
Microsoft SQL Reporting Services (Collège de Maisonneuve) 2017
Microsoft SQL Intermédiaire (Collège de Maisonneuve) 2016
Microsoft SQL Avancé (Collège de Maisonneuve) 2016
Microsoft SQL Reporting Services (Collège de Maisonneuve) 2016
Microsoft SSIS (Technologia) 2015
Oracle
SQL Intermédiaire (Collège de Maisonneuve) 2015
SQL Advanced (Collège de Maisonneuve) 2015
MicroStrategy
MicroStrategy Reporting Essentials + Advance 2010
MicroStrategy Freeform SQL 2010
MicroStrategy Architect + Architect Advance 2010
Cognos IBM
IBM Cognos Framework Manager (Senturus.com) 2015
IBM Cognos Report Studio Expert Authoring (Senturus.com) 2015
IBM TM1 2010
IBM Cognos Power Play Transformer 7 2005
Business Objects
Business Objects Data Integrator 2007
Personal behaviour: On time, well organised, polite, interpersonal skills, easily integrates
Contact this candidate