Manager Cognos
Resume:
Consultant Profile: Cornelius Goodwin
Solutions Architect /Principal BI Consultant
**************************@*****.***
Professional Summary:
●Cognos Systems Architect with over thirty years of experience in designing and managing application systems and development projects for a variety of hardware and software operating systems and database platforms.
●Technical Manager and Consultant for several Fortune 500 Companies presenting demonstrations, and teaching line staff, and clients.
●Successfully designed and implemented over 200 major projects including, Cognos FrameWork Manager and Cognos System Migrations
●Several presentations at International and Regional IBM Business Analytics Performance Events.
●15 years’ experience using Cognos Report Studio.
●6 Plus years’ experience using Cognos Work Space and Workspace Advanced.
●25 years experience developing Dashboards/Metrics/Complex Reports
●5-7 years of experience with Life cycle manager
●Experience in creating reports, portal customization and performing unit testing.
●4 Certifications with Cognos 10
●Motio CI and Persona experience
Experience:
Goodwin Computer Consultants LLC.
Client:IBM Watson Health Division `03/2020-Present
Designed and developed reports and dashboards for State of Missouri Health Services.
Migrated reports using old business requirements for the new version of Cognos 11.1.7.
Rewrote Business requirements for new system.
Goodwin Computer Consultants LLC.
Client: Ultimate Software- BI Consultant/ETL consultant 11/2019-3/2020
Cognos and MS SQL ETL consultant
Troubleshoot client Cognos Reports for the Company software Ultipro.
Wrote and designed Ms SQL stored procedures scripts using MS SQL 2012 for ETL jobs on the
Data integration team. Stored procedures where used for data input for Ultipro software
Goodwin Computer Consultants LLC.
Client: American Energy and Power 07/2018-10/2019
850 Tech Center Dr, Columbus, OH 43230
oCreated enterprise wide Cognos Framework model.
oConverting Business Object reports into Cognos reports.
o SQL analysis of Data and table relationships.
oData mining. for reporting analysis for back end Maximo conversion.
o Created Data modules and reports for enterprise customers and users.
oCreated User interface for ad hoc reporting and canned reports.
oInstallation, support, and migration from Cognos Café to IBM Cognos PAX or Planning Analytics for Excel.
oIBM Planning Analytics for Microsoft Excel is a Microsoft Excel-based add-in that professional report authors use to build reports using data sources from IBM Cognos TM1. It’s used to compare data, such as details to summaries, or actual results to budgeted reports.
07/2017-11/2017
Goodwin Computer Consultants LLC.
Client: Performance Food Group
8720 Stony Point Parkway,
Richmond, VA
Solutions Architect/Principal Consultant
●Installation and configuration of Cognos Analytics 11.0.9.
●Upgrading Cognos 10 environment to Cognos Analytics 11.0.9.
●Installation and configuration of Cognos Analytics Gateway using IIS 8.0.
oActive Directory SSO Configuration in IIS 8.0 Environment.
●Installation and configuration of Cognos Analytics Framework Manager 11.0.9
●Develop Data Models in the reporting environment Cognos 10/11 Framework Model
●Migration of 2000 reports, objects and security from Cognos 10.2.1 to Cognos Analytics 11.0.9
●Migration of 25 FM models reports from Cognos 10.2.2 CQM (Compatible Query Mode) to Cognos Analytics 11.0.9 DQM (Dynamic Query Mode)
●Report analysis using Motio and Cognos Analytics Life Cycle Manager
●Installation of TM1 10.2.2 and Web API for Cognos Analytics 11.0.9
●Migration, Test, and analysis of TM1 10.2.2 Reports to Cognos Analytics 11.0.9
●Recent hands-on experience with Netezza 7.02, and MS SQL Server 2012
●Report analysis using Motio and Cognos Analytics Life Cycle Manager
●Develop Dashboards/Metrics reports using the Cognos 10 and Cognos 11.
●Develop Complex reports using Cognos Report Studio and Workspace Advanced
●Troubleshoot and resolve issues regarding reports generated.
●Develop Data Models in the reporting environment Cognos 10/11 Framework Model.
●Tableau and Qlik view support and report development
Goodwin Computer Consultants LLC.
Client: Lennar Home Builders, 12/2016 – 10/2017
700 NW107th Ave.,
Miami, FL
Lead Cognos Solutions Architect:
●Coordinator and architect for the Lennar Enterprise utilizing Cognos Analytics 11.0.5. and 11.0.6.
oInfrastructure Design incorporates the IBM SaaS Solution (Software as a service) and on prem (Iaas).
oI design, write, and implement best practices for (Onshore and offshore) developers using Cognos Analytics. Oversee application design solutions and recommend specific best practices. Design migration and deployment strategies between IBM platforms. Application coordination and development governance throughout the Lennar International enterprise.
oTest and develop POC test cases of specific corporate use case implementations using Cognos Analytics 11.0.5. and 11.0.6.
Goodwin Computer Consultants LLC
Client: Performance G2 -
8528 Davis Blvd., #134-371
North Richland Hills, TX 76182
Solutions Architect/Principal Consultant. 8/2016- 12/2016
●Client:Baycare Clinical Health LLC.
oInstallation and Configuration of Cognos Analytics version 11.0.4 – SSO Configuration in IIS 8.5 Environment.
oDesigned company wide Cognos Best Practices documentation and installation documentation.
●Client:Heartbase LLC.
oConfiguration and migration from Cognos Express 10.1 in a SSL environment from TM1 and Contributor to base Cognos 10.2.2. Creation of FM models and reports.
oConfiguration and Installation of Cognos 10.2.2 fix pack 6 for SSL-IIS 8.5 configurations for Production and QA environments. Remotes Lead developer in Cognos 10.2.2 report development on a Windows operating system /MS SQL Database Environment.
oDevelop and present training in Cognos report development and Administration.
oDesigned company wide Cognos Best Practices documentation and installation documentation.
●Sintec LLC
Cognos Analytics – Cognos 11 Installation and configuration
Assist in an advisory capacity, in the installation and configuration of Cognos 11.0.4.
Goodwin Computer Consultants LLC
Client:1st Insurance of Hawaii, 11/2015 –8/2016
Honolulu, Hawaii
Senior Lead Cognos Developer.
●Lead a team of developers on site and overseas in Cognos 10.2.2 report development on a Windows operating system /MS SQL Database Environment.
●Cognos development and support for International users.
●Designed company wide Cognos Best Practices documentation, for Cognos users within 1st Insurance of Hawaii.
Goodwin Computer Consultants LLC
Client: AIG Insurance 4/2015 - 11/2015
NYC, NY
Senior Solutions Architect
●Installation, Migration, and Configuration of Cognos 10.2.2 on a Windows/Linux Environment.
●Cognos development and support for 4800 International users.
●Backup administration support for Qlikview and Tableau on a Windows Environment.
●Hosted and designed a companywide Cognos Best Practices presentation, for Cognos users within AIG.
●Tableau Development and Qlikview development
●Administration of several hundred Qlik sense users
Perficient Consulting, 7/2014 - 4/2015
Chicago, Ill
Solutions Architect
●Client:VibraHealth, Vibra Healthcare LLC,4550 Lena Drive, Mechanicsburg, PA 12/2014 - 4/2015 Designed and created a Cognos 10.2 ad hoc reports and dynamic prompting.
●Client:THR Health Resources, Dallas, TX Cognos 10.1 to Cognos 10.2 Migration 8/2014- 12/2014
●Client:MTD products, Cleveland, Ohio 7/2014 - 8/2014
InfoSphere Data stage 9.1, Metadata Manager, Installation and Configuration, Operational linear reporting
Ironside Group Consulting, F/T 1/2013 - 6/2014
Cambridge, MA
Senior Business Intelligence Consultant
●Client: American Eagle Outfitters, Pittsburgh, PA 4/2014 - 6/2014
Cognos 7 to Cognos 10 migration of Cognos Series7 Access Manager LDAP Namespace and groups and role to Active Directory using Motio Persona IQ.
●Client: Hartford Insurance Company, Hartford, CT 10/2013 -3/2014
Designed and created a Cognos 10 Dashboard utilizing Bursting of reports and dynamic prompting.
●Client: Kenyon College, Gambier, OH 7/2013- 9/2013
Created and designed and admission ETL/Data warehouse using Star Scheme for Cognos reporting. Taught and designed Framework model for replacement of the original Ellucian-Sungard Advancement Analytics for Cognos application.
●Client: XL Insurance, Stamford, CT 6/2013- 7/2013
Cognos Reporting migration from a transactional data source and DMR data source and Powerplay Cubes.
●Client: Michigan State University, East Lansing, MI 4/2013- 6/2013
Cognos 10.1 Report writing for the Analytic analysis of campaign funding using Ellucian-Sungard Advancement Analytics for Cognos application. Installation and configuration of Cognos Metric Studio/Designer 10.1 for an Analytics/Metrics Dashboard for Fundraising campaigns. Remotely, taught Cognos Report Studio and FrameWork Manager Courses to students and line staff at MSU.
●Client: DTE Energy Co. (NYSE: DTE) 1/2013- 3/2013
Prepared and presented a POC (Proof of Concept) as an introduction to Ironside Group services. Created the Framework Model against their ETL system and several reports for POC. Prepared evaluation and Cognos development road map for DTE management to be used as a template to build their Business Intelligence Infrastructure.
Pragmatek Consulting Group, 3/2012 - 12/2012
Minneapolis, Minnesota
Cognos System Architect
●Client: Church Mutual Insurance, Merrill, WI
DataStage Migration from 8.5 to 9.1 and DataStage Health Check. Cognos 10.1 Health Check (Overall system and application diagnosis).
●Client: Midwest Cognos user group organizer/presenter of new enhancements within Cognos 10.
Cognos/IBM Employment History (Software Development Services/GBS-Global Business Services) 2003 - 2012
IBM Principle Cognos Consultant within the Software Developers Group and the Business Analytics Organization contracted at various clients.
●Client: AIG Insurance Company, New York, NY
Designed a migration strategy for Excel reports to be defined and converting into the clients’ ETL-DataMart. Designed and implemented the strategy to view Cognos reports using Go Mobile to access the reports on a dashboard using the IPad or Iphone.
●Client: First Data Corp., Memphis, TN
Developed a reporting Dashboard for forty reports and a Framework Manager Model for Cognos to interact with their existing CRM system. Acting as liaison for several overseas vendors and managed their progress during the project, resolved any and all issues concerning the customization and configuration of the Cognos Framework Manager model. Designed the Cognos security Structure and language cross reference configuration within the FM model for translation of reports and GUI into different languages and currencies.
●IBM – Centennial Celebration, Philadelphia, PA
Cognos CCI BI Analyst and Consultant
A New Product, Called Cognos Consumer insight, is built upon IBM”S Cognos business intelligence technology along with Hadoop to process the piles of unstructured public social media data. Worked on the taskforce, established to devise a presentation to be given at the IBM centennial celebration, in Philadelphia, Pennsylvania.
●Client: Custom Border Patrol – Homeland Security, Washington D.C.
Worked on the delivery of 1000 reports and redesigning Cognos 8 Framework Manager. Support and consult using best practices. Defining the Cardinality within the ETL for report Optimization.
●Client: Moody's, New York, NY
Designed and implemented a project converting Sybase data to DB2. Recreating production reports and creating the Frame Work Model using an Oracle data warehouse.
●Client: Partners Health Insurance, Boston, MA
Created portlet HTML for connection to the SAP/BW Cubes to execute Cognos parameterized reports.
●Client: California Department of Corrections, Sacramento, CA
Rewrite and Redesign reports created with Cognos-SAP/BW for a Proof of concept.
●Client: US Army-Ardec, Picatinny Arsenal, NJ
Worked with users to install, configure and migrate Cognos Version 8.4. Installation and configuration of Cognos Go Mobile, Cognos Go Office, Cognos Go Dashboard, Created 3 dashboards. Metrics Manager Application dashboard, Query studio and Report studio. Design and implementation of FrameWork manager modeling and configuration. Designed Bex Cubes for reporting from SAP\BW cubes to Cognos.
●Client: Viterra Corp, Saskatchewan, Canada
POC- Proof of Concept- Installation/Documentation of Cognos 8 and creation of the Framework model against SAP/BW and Oracle Database. Demonstrate and explain how to create the reports, Dashboards, and custom browser templates and skin design.
●Client: Vanguard Financial systems, Valley Forge, PA
BI Consult on LDAP Security, SAP Web portal development using Cognos.
●Client:First Energy Utility Company, Akron, OH
SAP –BW Reports and FM Manager creation. SSO - Single sign on security implementation and configuration.
●Client: Wellington Financial, Boston, MA
BICC documentation
●Cognos Performance Conference, Ontario, Canada
Presentation Coordinator
Client presentation to Cognos clients on Cognos Series 7 Migration to Cognos 8
●Cognos Performance Conference, Philadelphia, PA
Presentation Coordinator
Client presentation to Cognos clients on Framework Manager modeling and best practices.
●Client: Pall Corp., Anne Arbor, MI
Migration and design of customized reporting system using Cognos 8 and javascript.
●Client: Sephora Cosmetics, San Francisco, CA
POC-Proof of Concept- Installation/Documentation of Cognos 8 and creation of the Framework model against Ms SQL Database. Demonstrated how to create the reports they need and how to redesign the model, for predictable results.
●Client: EMC = MC2 corp., Brunswick, NJ
Created Cognos Metric Manager Scorecard for demonstrations incorporating the entire C8 Bi Suite, for Business Edge Solutions Inc, NJ. Created several dashboards for Rogers Wireless Inc. using advanced C8 Report Studio/Cognos Metrics manager techniques.
●Client: Hertz Corporation, Park Ridge, NJ
Installation of Cognos C8, Report Studio, Cognos Metric Manager and Metric Designer in production and test system environments including creating reports and dashboards.
●Client: Hershey Corporate, Hershey, PA
Worked on a special project utilizing SAP-BW Cubes. Designed FM Model and reports, for internal scorecard.
●Client: Organon Inc, New Jersey
C8 Consulting and client review of Powerplay cubes, and FM Model.
●Client: BI/EP Cognos for the University of Alabama, Alabama,
Fm Model and CRN reporting against Contributor for financial reports.
●Client: IBM-CIGNA, Philadelphia, PA
Special project-Designed Security for Cognos 8 against Active Directory LDAP for Cognos 8 Workforce Analytics Performance application.
●Client: New York State Division of Budget, Albany, NY
Consultant at New York State Division of Budget - installation and configuration of Cognos 8 with a DB2 database and Linux OS system.
●Client: Wilkes University, Wilkes-Barre, PA
Consultant at Wilkes University
Installation of Cognos 10 Development and Production environments to create CRN reports and Framework manager models against Banner/Sungard Database (Oracle DB).
●Client: Thomson Financial Inc., Stamford, CT
Thomson Corporation Reports, Security and Framework model against Contributor and Powerplay cubes for BI reporting.
●Client: Staples Inc, Framingham, MA
Created Financial reports using Cognos EP Analyst Models interpreted through Framework Manager and presented through a Dashboard for the CFO.
Metropolitan Life Insurance Company 12/1982- 12/2003
Senior Consultant; MetLife Ins. Co., New York, NY
Installation and configuration of MVS/DB2 and VM/SQL-DS.
Installation and configuration of Cognos Impromptu and Powerplay.
Lotus Notes Administrator
Microsoft OS2 Administrator and MS SQL DBA
EDUCATION:
BBA in Management Information Systems
Pace University, New York
IBM CERTIFICATIONS:
C2020-622: IBM Cognos 10 BI Administrator - 277047674
C2020-612: IBM Cognos 10 BI Author - 278665465
C2020-632: IBM Cognos 10 BI Metadata Model Developer – 278985381
C2020-645: IBM Cognos 10 BI Multidimensional Reporting
References:
Name: Amit Gupta Manager - Director TCS (Tata Consulting Services)
Contact info: 305-***-****
Anthony Politano Manager: Director AWS
Contact info: 908-***-****
Mark Lockhart Manager: Performance Food Group
Contact Info: 804-***-****
Contact this candidate