William Onososen Email & Phone Number

Saint John, Nb, Ca

•Assess and translate business requirements into systems requirements, define strategy, technical architecture, develop, deliver and support Cognos cubes, reporting and data warehouse projects, ensuring that recommended solutions are compatible and meet the standards set by the organization. Prepare necessary documentation, including, but not limited to, high level and detail specifications, process and data flow diagrams, report definitions•Participate in the evaluation of most appropriate technical methods of coding computer programs to solve specific business requirements. Actively participate in meetings, feasibility studies / gap analysis and propose options and recommendations for system design of required business processes.•Identify gaps between the current deployment of applications and future requirements that have evolved due to organizational growth, changes, or strategy. Translate business requirements into system definitions and solutions.•Work with business community to document functional test scenarios, test plans, and end-user acceptance testing criteria •Participate in technical design sessions, working with technical resources, to provide insight during solution •Design and develop new reports and report modifications in Cognos •Support planning, budgeting and forecasting process in Cognos •Provide technical consultation associated with the use of Cognos •Identify opportunities for improvement (standardization, simplification, etc.)

**Analyze and design new systems and processes to enhance Cognos applications and Budgeting / Planning processes. Prepare, present, implement recommendations for data integration initiatives, development of dashboards, scorecards and different reports for the organization. Analyze, determine, recommend, prepare and deliver training where appropriate**Assess and translate business requirements into systems requirements, define strategy, technical architecture, develop, deliver and support Cognos cubes, reporting and data warehouse projects, ensuring that recommended solutions are compatible and meet the standards set by the organization. Prepare necessary documentation, including, but not limited to, high level and detail specifications, process and data flow diagrams, report definitions**Provide project leadership, or other roles within a project team. Evaluate progress and results, providing written and verbal summaries, recommendations, and documentation as determined by the project and the project team**Authorize the promotion of programs into the production environment once tested. Provide direction to junior staff and contract programmers / consultants. Participate in the evaluation of most appropriate technical methods of coding computer programs to solve specific business requirements. Actively participate in meetings, feasibility studies / gap analysis and propose options and recommendations for system design of required business processes.

•Independently or as a member of a development group, performs system analysis, design, programming, testing, documentation, installation, user training and system maintenance and support.•Consult with user management and staff throughout all stages of the development cycle to ensure that systems achieve the user’s business objectives.•Develop systems observing professional system design concepts and office standards and conventions.•Assist users in the evaluation, selection and implementation of vendor software and services.•Analyzing the specifications provided by the clients and Developing specification document for the report as per client requirements•Install and configure the Cognos 8.4 BI Environment, Administering the Servers, Troubleshooting, and Performance Tuning.• Develop and Publish Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects•Used Dimensional modeling (DMR) and Snow flake Schema modeling technique to develop models•Use Informatics 8.x (Source Analyzer and Warehouse Designer) to import the source and target database•Designed and developed BI report solutions using Report Studio and Framework Manager•Worked with data BI team to analyze data sources•Design and develop Multidimensional Cubes using Power Play Transformer

•Worked with data BI team to analyze data models•Worked with data warehousing team to perform data analysis and provide data warehouse solutions•Design, implement and develop the business intelligence reports.•ETL job implementation and development•Designed and developed BI report solutions using Report Studio and Framework Manager•Used Workflow Manager/Monitor for creating and monitoring workflows and worklet in Informatica for ETL•Used transformations like Aggregators, Sorter, Dynamic lookups, Connected & unconnected lookups, Filters, Expression, Router, Joiner, Source Qualifier, Update Strategy, sequence Generator.•Extensively used Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, and Informatica Server Manager.•Extracted source data from Oracle, SQL Server, Flat files and XML using Informatica, and loaded into Oracle or flat file targets.•Installed Cognos 8 BI Suite on UAT and SIT environments•Migrated Cognos ReportNet to Cognos 8 and Cognos 7 to Cognos 8•Installed and configured, tested/deployed the Informatica PowerCenter Server and clients•Designed and developed the stored procedures, packages, SQL statements and shell scripts used by the project•Involved in designing and development of data warehouse environment, liaison with business users and/or technical teams gathering requirement specification documents and presenting and identifying data sources, targets and report generation

Advance Diploma In Data Warehouse, Data Modeling/Warehousing And Database Administration

B.Ed, Computer/Mathematics

B.Sc, Computer Science