Manager Project

Francis Makinde

*** ****** ******, ******** ****, ON L4E 4N7

Res: 905-***-**** Cell: 647-***-****

abosr4@r.postjobfree.com

An energetic self-starter with excellent management, analytical, organizational and development skills. Possesses an exceptional capacity to work within an ever-changing environment to finding solutions.

Areas Of Expertise

Staff & Team DevelopmentExperience in migrating Reports & Packages from Cognos 7 series to Cognos 8 BIStrong knowledge of various components within Cognos and how they interact with each otherStrong Knowledge of Data Warehousing, OLTP, OLAP concepts Strong understanding of Dimensional Modeling (Star and Snowflake Schemas)Sound knowledge in SQL Queries and databases conceptsStrong analytical and Problem Solving CapabilityExperience in Troubleshooting production issues and Data AnalysisKnowledge of Informatica WorkflowInvolved in various activities of the Software Life Cycle in Cognos suite of productsSelf-starter with drive, initiative and a positive attitude Experience with Business Intelligence tool Cognos 8 BI Suite (Framework Manager, Report studio, Query Studio, Analysis Studio, Upgrade Manager), Transformer, Cognos Report Net v1.0/1.1, Cognos 7 series (PowerPlay Transformer), Created Models for reporting and published packages in Cognos Connection using Framework ManagerCreated Multi-Dimensional Cubes using the Cognos TransformerDeveloped several reports in Cognos 8 Bi, Cognos ReportNet, MS-ExcelExpertise in developing and testing Complex reports (List, Cross tab, Charts, Maps, Drill through, Master-Detail, and Cascading) and Dashboards using Report studioStrong analytical & good communication skills

Technical Skills

Operating Systems: Solaris 8, Windows 3.11, 95/98, NT/2000/2003/XP/VISTA and Windows 7

Windows Server 2003 and 2008.

Software: MS Office 2000/03/07/10, MS Visio and SAP client interface. SQL Presentation server;

Adobe Software; IBM Cognos 8 / 10; Crystal Reports, Java, VMware and Citrix Presentation Server. FTP, IIS, and Telnet

Professional Experience

St. Mary’s Cement, Toronto, ON 2008 – Present

COGNOS DEVELOPER

Involved in the entire project life cycle from analysis, installation, development, testing, production and end user supportWorked closely with business users while gathering requirements Developed models and published packages in Cognos connection using Framework ManagerCreate Models by creating various joins between query subjects and also resolved various types of joins between themUsed Framework Manager to model metadata from different data sources and published packages to Cognos ConnectionInvolved in building Multidimensional Cubes using TransformerCreating/Modifying reports as per requirementsDeveloped Reports like list, chart, cross tab, cascading, burst,Master–Detail, Drill Through in Report StudioUsed Cascading prompts, Filters, Bookmarks to create efficient reports in Report StudioExperience in creating Ad-hoc reports using Cognos Query StudioCreating and setting privileges on Users/User GroupsInvolved in Testing and improving Report PerformanceScheduled reports using the Schedule Management tool, Event Studio in Cognos ConnectionPerformed content/portal AdministrationImplemented package level, object level and data level security in the reports.Worked on Production Support and fixing report/package/data issues.Worked on Data Analysis,Validate reports and find data quality issuesApplied security on data level and in the package level in a manner that only the relevant users were able to see those packages and reports createdPrepared Weekly Status Reports (PMO) and shared with the ManagersProduction Support which involves solving user problems and Provided End User Training and SupportPrepared User documentation to train users and functionality of each report

Technical Environment: Cognos 8 BI Framework Manager, Report Studio, Query Studio, SQL, Windows Server 2003

Microage ltd., toronto 2005 – 2008

COGNOS AND SQL DEVELOPER

Created and performed the Unit and Integrity test cases and assisted the testing team in System Test and Production move processInvolved in the complete Software Life Cycle Development of the projectCreated functions, procedures for inserting, updating data based on conditionsWrote the database triggers for the complex business rule validationsInvolved in testing the packages developed by co-developersInvolved in SQL Query OptimizationPrepared User documentation to train users and functionality of each reportInvolved in troubleshooting and data gathering during the business analysis and planning phase of the projectCreated Stored Procedures, Functions and Troubleshoot database related issuesCreated Star Schema using fact and dimension Tables, also created dimensions, levels and hierarchiesParticipated in requirements gathering to bridge gap between user needs and tool functionalitiesUnderstanding existing business model and user requirementsInvolved in upgrading Cognos 8.2 BI reports to Cognos 8.3 BI series using Upgrade ManagerDeveloped models and published packages using Framework ManagerDesigned star/snow flake schemas and dimensional models using Framework managerCreated different layer’s to hide the data complexity for end users Developed list, chart, burst, master-detail, drill through, repeating, and multi-page reports in Report StudioCreated complex reports that involve query prompts, layout calculations, conditions, and filters in Report StudioCreated cross tab reports to summarize and compare complex data in Report StudioImproved the performance and usability of the reports by creating appropriate prompts and filtersDeveloped Multi page reports with prompt pages and conditional variables according to the end user requirementsDeployed Reports and Models from one Environment to Another Customized Cognos Connection Portal to personalize the homepageManaged scheduling of reports, distribution lists, users, groups and roles using Cognos ConnectionTrained business users in Framework Manager, Report Studio, and Query studioDeployed the Ad-hoc Model and Reports from Development to Testing and to Production environment.Production Support and prepared documentation of each report created

British Airways, Heathrow, London 1999 – 2004

Report Developer – Junior / intermediate role

Involved in the System Analysis, Design and Development of the projectUsed SQL tools like TOAD to run SQL queries and troubleshootCreated Data Source connection from front end HTML Pages to SQL Server 2000Created Database and Tables structures for storing user information in SQL Server 2000Developed Stored Procedures and functions to accomplish several computationsCreated user-friendly GUI interface and Web pages using HTML Created forms in HTML for Add, Modify, Delete and Search user informationInvolved in Testing and DebuggingDeveloped Architecture roadmap for all aspects of Cognos EnvironmentDeveloped Cognos reports and dashboardsProvided routine status of activities to the project manager

GLAXOSMITHKLINE (PHARMACEUTICAL) – London - UK 1997 - 1999

SUPPORT ANALYST

Pre-installation audit; Data migration from Dos, Win3.11 and Win95 to NT4. Software installation and configuration with laboratory equipments. Using "Ghost software" for PC imaging or reimaging.Year 2000 pharmaceutical software testing issues and compliance.Backing up laboratory pc configurations onto CD’s in case of hard drive failure. Documenting problems and escalating to appropriate internal resources and external vendorsBacking up client’s old hard drives (using Seagate Backup Exec) MS Office 97, Lotus Notes 4.6.1 and in-house application installation.Backing up rollout server and setting up network printersSMS (Systems Management Systems) installations on client computersWorking in restricted environments like animal testing area by using special clothing.

EDUCATION & Professional Development

IBM Certification: Cognos 10 Business Intelligence Author

Cognos 8 and Microstrategy - Business Intelligence Dev. and Maintenance – Toronto

SQL Server 2008 - Business Intelligence Developer Training

Certification: ITIL V3 Foundation in IT Infrastructure Service Management

Software Testing Quality Assurance – Hi-Tech Institute, Toronto, Canada

Sun Certified Systems Administrator (SCSA) – Solaris 8 Dba

IBM Certification on desktop and mobile systems support; Comptia A+ certification

MCP - Server, Workstation, Server in the Enterprise & Network Essentials

Microsoft Access and SQL Database Course – Brunel University, London

Introduction to PC networks – City University, London – U.K

Bachelor of Science – Bsc Hons. Land Survey - University of Lagos

Hobbies: Soccer, table tennis, travelling and listening to music

Contact this candidate