Marlon Godoy – 647-***-****
ac4emr@r.postjobfree.com
Summary of Cognos Experience
Process creation to ensure data conversion is properly handled
Work-related, verified tests and final data conversion testing
Cognos BI Development Version 10.2 creating Drill Through, Dashboards and Active Reports
Strong skills in Cube and Report Development from different data sources
Dashboard designing, creation and Development experience
Data Integration from different sources into Framework Manager
Communication and Presentation experience of progress during projects
Cognos Code promotion to various environments and quality assurance testing
Experience skill with Cognos, including Framework Manager, Reports, Cubes and Dashboards;
Knowledge with technologies including Microsoft SQL Server and Cognos (version 10.2 and higher);
Data collection, processing, conversion process experience
Demonstrated experience with Cognos Framework Manager using OLAP Cubes
Experience with developing Cognos reports, dashboards, storyboards, and data visualization techniques
Experience with developing Cognos Cubes, developing in Cognos Query Studio and Cognos Framework
Extensive and strong experience editing and writing SQL scripts for production purposes
CIBC April 2017 to September 2017
Data Analyst
Developed and generated reports in Cognos version 10.2
Created data testing procedures to detect data purity
Design steps plans for the data conversion tasks
Created data sources to implement data delivery
Created test cases to ensure data conversion procedures deliver the correct data
Planned all concerned data processing steps to be used in data conversion
Programmed data conversion, SQL scripts and procedures to automate the migration plans
Developed and managed conversion control totals
Managed data conversion processing schedules to ensure instinctive data delivery
Created presentation charts with data driven sources from different database sources
Created a Simple Chart Showing Sales over Countries and Product Lines
Projected and delivered Multiple Measures on Charts and Other Refinements
Nesting Items in a Chart, Filtering, and Some More Properties
Chart inside a list & Master-Detailed Relationship
Enable Chart Properties and Create a 3D Bubble Chart Created Simple and Advanced List Reports
Created a Simple and complex List Reports for different financial departments
Added Data Formatting, Grouping, and Sorting Features
Applied Simple to Advanced Conditional Styles
Examined Query Subjects and the Generated SQL
Added Filters, Prompts, and Calculations
Generated custom Calculations to a List
Parameterized the Filter and Adding Prompts
Adding Query-driven Value Prompts
Created Simple to Advanced Crosstab Reports
Used Crosstab Reports to Show Orders against Cities and Products
Added Crosstab Totals (Summary), Zero Suppression, and Date Range Prompts sponsors) with the objective of ensuring the successful delivery of project deliverables
Conduct meetings/presentations as required to communicate project objectives and manage client expectations across many business unit teams
Analyze, gather and develop detailed, structured and complete test documentation and manage the execution through the data warehouse project lifecycle
Test Planning - Work with Business, Project Manager and System Integration Test team to develop a test plan, test Strategy, detailed test cases and test scripts.
Test Execution - Perform comprehensive functional, integration, system and performance testing.
Defect Management - Log test results using HP ALM, coordinate and conduct defect variance meetings.
Change Control - Follow established change control processes to promote changes between different environments (Development, SIT, and UAT).
Ministry of Health and Long-Term Care October 2016 to March 2017
Data Developer
DesingDesigned ETL procedures from extraction to data conversion
Design steps plans for the data conversion tasks
Created data sources to implement data delivery
Created test cases to ensure data conversion procedures deliver the correct data
Planned all concerned data processing steps to be used in data conversion
Programmed data conversion, SQL scripts and procedures to automate the migration plans
Developed and managed conversion control totals
Tested and supported Cognos reports and Cubes using Quality control procedures
Supported user acceptance testing of front and/or back end software as needed
Examined Query Subjects and the Generated SQL processing scripts to create optimized queries
Created and added Filters, Prompts, and Calculations in Cognos Report
Generated custom Calculations to a List for financial applications
Parameterized the Filter and Adding Prompts to create interactive Cubes
Adding Query-driven Value Prompts in SQL server to be utilized in Cognos reports
Created Simple to Advanced Crosstab Reports
Used Crosstab Reports to Show Orders against Cities and Products
Acquired and validated all data pertaining to data transformation to evaluate software performance
Applied Simple to Advanced Conditional Styles
Examined Query Subjects and the Generated SQL
Added Filters, Prompts, and Calculations
Developed complex script to create data tables destined to Financial applications
Conduct data validation and reconciliation processes following completion of data movement
Gathered all required data with data elements from different databases, tables and views
testing purposes
Design comprehensive test scenarios to make sure corresponding business requirements are fully tested
Create test cases using pre-defined template
Create traceability matrix between requirements and test cases modify or update the test cases per UAT Lead's feedbacks or comments if any
Defined data quality in Metrix and validation rules consistent with policies and designs
Record individual test result and submit defect report(s) in pre-defined template and submit to UAT Lead, IT team and Project Manager
Retest reported defect(s) to ensure issues are truly resolved/fixed
Update web based issue tracking tool in a real-time fashion during all project stages
Participate in regular UAT team meetings for communication and status updates
BMO Bank of Montreal - Contract June 2015 to September 2016
Data Developer
Managed data conversion cycles and design test steps
Managed data preparation procedures from data extraction to convertion
Created Simple to Advanced Cross tab Reports
Design steps plans for the data conversion tasks
Created data sources to implement data delivery
Created test cases to ensure data conversion procedures deliver the correct data
Planned all concerned data processing steps to be used in data conversion
Programmed data conversion, SQL scripts and procedures to automate the migration plans
Developed and managed conversion control totals
Managed Reports to Show Orders against Cities and Products
Formatted Cross tab Totals (Summary), Zero Suppression, and Date Range Prompts
Create Additional Levels and Measures by Nesting Rows or Columns
Drilled through From a List Report to Another List Report
Created a Drill-through from a List Report to Another
Formatted Multiple Parameters in Drill-through From a Chart to a List
Enabled Drill Up and Drill Down in Dimensional Models
Created and embedded conditional Drill-through Definitions
SQL Developer
Conduct data validation and reconciliation processes following completion of data movement
Perform data profiling and cleansing techniques to maintain consistent accurate information
Laid out and created test plans and tested scripts for SQL Server platform
Created reports, tools, or another system to provide feedback to project client on master data functions
Created Simple and Advanced List Reports
Created a Simple List Report
Added Data Formatting, Grouping, and Sorting Features
Applied Simple to Advanced Conditional Styles
Examined Query Subjects and the Generated SQL
Added Filters, Prompts, and Calculations
Generated custom Calculations to a List
Parameterized the Filter and Adding Prompts
Adding Query-driven Value Prompts
Created Simple to Advanced Crosstab Reports
Used Crosstab Reports to Show Orders against Cities and Products
Added Crosstab Totals (Summary), Zero Suppression, and Date Range Prompts Organized Data Efficiently distributed in various databases
Implemented all the relationships between tables
Implemented a data warehouse using SQL Server database engine
Delivered logical design to the data warehouse from tables to databases
Drill Through From a List Report to Another List Report
Creating a Drill-through from a List Report to Another
Passing Multiple Parameters in Drill-through: From a Chart to a List
Enabling Drill Up and Drill Down in Dimensional Models
Drill Through to Itself to Mimic Exporting to Excel or PDF
Conditional Drill-through Definitions
Prepare data to be processed for different application destinations
Manage all data pertaining to Salesforce from inception to deployment for different users
Create extensive macros to transform data from different sources to MS Excel 2013
Prepare temporary and up to date using MS Access to make flow of data smooth
Import data from different systems in order to incorporate information packages and incorporate to systems information
Prepare reports for different departments in order to maintain upper management up to date with all important enterprise information.
ETL functions on data from text to MS SQL 2012 according to requests from management in proper manner
Create KPI indicators for performance uses in concept to maintain performances operators
Accomplished using: FileMaker 13, SSIS, MS SQL Server, Jira and C#
Rogers Communications - Contract November 2013 to May 2015
Data Analyst
Responsibilities:
Created proper data diagrams to ensure team accuracy during data extraction
Archived Test General Ledger results to conform with requisites
Managed all solutions built in FileMaker v13 and managed updates
Design steps plans for the data conversion tasks
Created data sources to implement data delivery
Created test cases to ensure data conversion procedures deliver the correct data
Planned all concerned data processing steps to be used in data conversion
Programmed data conversion, SQL scripts and procedures to automate the migration plans
Developed and managed conversion control totals
Prepared all UAT scenarios, Regressions, Integration and E2E testing activities
Ensured that test results adre as expected scenarios/test cases.
Logged and proposed solutions of defects in Tracking and documented testing activities
Report test results to Manager, Scrum Masters and test Lead
Held meetings with Developers and Lead Analyst to brainstorm and fix bugs
Review specifications. and designs documentation to verify testability
Coordinate testing activities on multiple platforms and provide data to be tested
Verify/Validate actual results to ensure that it achieved requirements goals
Created Simple and Advanced List Reports
Created a Simple List Report
Added Data Formatting, Grouping, and Sorting Features
Applied Simple to Advanced Conditional Styles
Examined Query Subjects and the Generated SQL
Added Filters, Prompts, and Calculations
Generated custom Calculations to a List
Parameterized the Filter and Adding Prompts
Adding Query-driven Value Prompts
Created Simple to Advanced Crosstab Reports
Used Crosstab Reports to Show Orders against Cities and Products
Added Crosstab Totals (Summary), Zero Suppression, and Date Range Prompts and confidential customer information to be loaded into MS SQL 2012 data warehouse
Created process for data from Data sources, Data Transformation, Data staging and data granularity
Create special ETL rules and packages to incorporate wide request in French Language
Assisted other Data Architects in creating different models in both official languages
Manage all data pertaining to Salesforce from inception to deployment for different users
Mapping Data in order to create effective Enterprise Reporting
Assist to different IT teams with time sensitive deadlines in order to increase production
Create extensive macros to transform data from different sources to MS Excel 2013
Prepare temporary and up to date using MS Access to make flow of data smooth
Install and deploy MySQL throughout the enterprise to ensure robust application uptime
Developed MS SQL 2012 scripts and queries in order to extract data from different data sources and different server locations
Developed SSIS Data Transformation packages to transform staging data
Created both snowflake schema and schema design
Created error handling errors in an SSIS Packages
Extracted data from legacy and mainframe sources
Modified and loaded data using SSIS packages
Implemented the data flow charts to ensure documentation Assist in configuration, installation and maintenance of MS SQL 2000, 2005 and 2008
Trained IT personnel in installation of MS SQL 2012 server enterprise edition
Perform maintenance duties with MS SQL Server 2012 in order to maintain services in optimum attributes for different complex queries
Design extraction packages from different data sources for different customer driven applications for analysis services
Accomplished using: FileMaker 13, MS SSIS, MS SQL Server and Jira
CARSWELL Thomson Reuters September 2002 – October 2013
SQL Developer/ QA Analyst
Configured advanced SSIS production settings
Design steps plans for the data conversion tasks
Created data sources to implement data delivery
Created test cases to ensure data conversion procedures deliver the correct data
Planned all concerned data processing steps to be used in data conversion
Programmed data conversion, SQL scripts and procedures to automate the migration plans
Developed and managed conversion control totals
Ensured quality and accuracy of software deliverables Documents
Optimized Data quality services using SSIS data flow
Created, managed and distributed reports using SSRS
Created error handling errors in an SSIS Packages
Added Data Formatting, Grouping, and Sorting Features
Applied Simple to Advanced Conditional Styles
Examined Query Subjects and the Generated SQL
Added Filters, Prompts, and Calculations
Generated custom Calculations to a List
Parameterized the Filter and Adding Prompts
Extracted data from legacy and mainframe sources
Modified and loaded data using SSIS packages
Created multiple dimensions consistent with sales reports
I worked along the team editing and writing the proper documentation for users.
Managed groups of users to transfer expertise based on our designed interfaces.
Created and transferred structured architecture of objects from initial MS Access 2007 into exporting them to MS SQL server versions: 2000, 2005 and 2008 Release 2.
Published reports to a main server using Microsoft SharePoint 2007 and 2010.
Involved in the conception and deployment of applications that ensured the data is entered according to table formats: namely creating rules, triggers and validation procedures.
Data Collection
Collect samples of Data dispersed in different servers throughout departments
Wrote reports with suggestions of all data available, data with issues, quality of data, granularity of data and formats of data origin
Entered Data in a Standard Layout to ensure all processes are working as requested
Created different list values from multiple tables and formatted Value Lists
Created triggers for validation purposes with Value Lists
Worked together with AS400 operators and users to define the data to be collected and suggest structure of scripts used to extract data into text files
Verify/Validate actual results to ensure that it achieved requirements goals
Testing front end and back end applications on mobile gadgets (iPad and iPhones)
Create/Execute Use Cases, Test Cases and Test Data
Installed SQL Server 2000 in computers in order to create stages for Data
Wrote instructions for processing data from extraction, temporary depository and final server destination.
Created data marts using MySQL to prove that using a more sophisticated software will be better adapted for better performance
Data Extraction
Identified and tested software to be used for data extraction
Wrote the scripts that worked on the data extraction procedures
Submitted documents to other departments instructing the output format of data collected
Tested procedures on all servers to ensure that the work is being properly done
Incorporated MS Excel and MS Access to work properly in data extraction process
Developed documentation for team member in the procedures to be followed when extracting data
Involved in the description of data through proper labels of data to avoid improper information
Created the destination Databases and Tables for all extracted Data
Data Preparation
Wrote the proper scripts to cleanse data with issues and field transformation
Prepared Excel-based interfaces to be used in ensuring granularity of data
Normalized data when necessary based on the structure of departmental data
Created diagrams displaying structures of data to be used for different purposes
Creation of infrastructure for displaying data
Created report templates with Crystal Reports based on submitted suggestions
Designed user interfaces for display of data in Data Marts using SSRS
Implemented script tasks and executed SQL tasks that populated databases and tables using SSIS
Manipulated data with SSAS to conform to structure of Data Marts as required by different departments
EDUCATION
Database Application Developer, Seneca College, Toronto September 1999 to August 2000
B.S. Computer Systems Engineering, Mexicos
LANGUAGES
Fluent in three languages: English, French and Spanish.