Resume

Sign in

Data Test Cases

Location:
Toronto, Ontario, Canada
Posted:
February 09, 2018

Contact this candidate

Resume:

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.



Contact this candidate