Technical summary

Mr. Mohamed possesses over ** years of IT experience, with specialization in Installation, Setup, Deployment, Development and Support of Cognos BI and OLAP tools. He is experienced in all phases of Software Development Life Cycle and has implemented mission critical solutions in key industry verticals such as Banking, Insurance, Financial, Retail and Pharmaceutical.

Mr. Mohamed has a Master’s in Computer Science and is certified as an IBM Cognos Business Intelligence Certified Solution Expert, a highest level of certification from IBM. He has expertise in IBM Cognos Analytics 11.1.7, 11.0.11, Cognos 10.2.2, Cognos 10 BI, Cognos 8.4/8.3 Suite including Active Reports for mobile devices, Dynamic Cubes, Framework Manager, Report Studio, Cognos Workspace Advanced, Query Studio and Analysis studio.

He has over 15 years of experience in Oracle working with SQL, PL/SQL and has expertise in analysis, design and implementation using Oracle and its ancillary tools. He also has strong Database and Data warehouse design skills along with some DBA skills. Mr. Mohamed is also a Microsoft Certified IT Professional.

Skills

BI and OLAP

Cognos Analytics 11.1.7, 11.0.11, Cognos BI 10.2.2, 10.2.1, Cognos 10 BI

Framework Manager

Report Studio, Query Studio, Analysis Studio, Event Studio

Active Reports, Dynamic Cubes

Cognos Workspace Advanced

Cognos 8.4/8.3 Suite, Cognos Series 7

Impromptu

Powerplay 7.3/7.2/ 7.0/ 6.0

IWR, PPES, Access Manager

Upfront, Cognos Scripts

Scheduler and Server Administration

Cognos TM1

Tableau

Power BI

GUI/Languages

SQL, C, C++, ORACLE - Developer/2000, Visual Basic, Power Builder

Databases

Oracle 12cR1,10g / 9i / 8.1 / 7.2

SQL Server, DB2, Teradata, SYBASE 10, FoxPro 2.5, Netezza

Database Tools

Erwin, Developer/2000 (Forms 4.5, Reports 2.5),

PL/SQL 10.2, SQL*Loader, SQL*Plus 10.2 and ORACLE Utilities

TOAD, Rapid SQL 7.4

ETL

Microsoft SSIS

Professional experience

Multiple Clients/Projects - Nov 2012 to Present (Business Intelligence Consultant)

SMBC (Sumitomo Mitsui Banking Corporation) – BHC RWA/SCCL Reporting

Risk Weighted Asset (RWA): The U.S. Regulatory Capital Rule (U.S. base III) requires Bank Holding Company (BHC) to keep a certain level of capital ratio. The capital ratio is derived from capital amount divided by Risk Weighted Asset (RWA). When the bank is established as BHC, the BHC must measure the capital ratio periodically. So, RWA is a major component of the capital ratio. However, there are no systems nor reporting tools for RWA currently.

Single Counterparty Credit Limit (SCCL): As a part of Regulatory Act, SMBC will have to have a capability of calculating each transactions credit exposure and of aggregating them on Ultimate Parent, Control Relationship and Economic Independence basis. SMBC currently have transactional information in CDW but have no functionality to populate their credit exposure amount. Also, there is no place to store the information regarding the identification of Control relationship and Economic Independence based on the single counterparties’ group entities’ identification criteria.

Gathered the technical requirements for creating the BHC RWA/SCCL Reports.

Created the BHC RWA Reporting and BHC SCCL Reporting Models with four-layer architecture (Database, Business, Dimensional and Presentation) against the RWA_CALC_DM, RWA Common Dimension and CDW data marts.

Created the following reports in Cognos Report Studio

RWA GL Summary Report

RWA Exposure Contract and Leg Detail Report

RWA Reconciliation Report

BHC Reconciliation Report

SCCL Exposure Contract and Leg Detail Report

Implemented report bursting and generated the report output in the shared folder.

Created Jobs/Events to schedule the reports for the previous business days.

Created a report prototype in the sandbox environment to leverage the Data Table feature in the new Cognos Analytics version of 11.1.7. This feature enables expanding/collapsing of dimensions, and filtering data interactively.

Created data sets with large volume of data with the flexibility of using Join/Union/Intersect queries and noticed that the data sets were created much faster than the prior versions that helps increase the performance and reduce the workload on databases.

Successfully tested the feature of running an individual page on a multi-page report, a functionality restored, and an enhancement towards developer productivity.

Built visualizations leveraging the new search in the data field functionality and exported the data to a CSV fie.

Environment: Cognos Analytics 11.0.11 (Framework Manager, Report Studio), Oracle 12cR1

Environment for POC/Sandbox: Cognos Analytics 11.1.7 (Framework Manager, Report Studio), Oracle 12cR1

SMBC (Sumitomo Mitsui Banking Corporation) – BHC Reporting

To support future strategic acquisitions, Sumitomo Mitsui Banking Corporation ("SMBC") is preparing to establish a voluntary US Bank Holding Company ("BHC"). With this SMBC will be subjected to additional financial and regulatory reporting requirements which should be considered in conjunction with the development of a Consolidated General Ledger for BHC. A list of GL reports will be created for BHC to facilitate various business needs. Also, the Regulator requires BHC to create Intraday Liquidity Reports, Cashflow Projections and Liquidity Stress Test Reports. The entities in scope for BHC include Manufacturers Bank (MB), SMBC Capital Markets (CM), SMBC Nikko Securities America Inc (Nikko America), SMBC Leasing & Finance Inc (LF) and Bank Holding Company (BHC).

Gathered the technical requirements for creating the BHC Liquidity Risk Reports. This includes Intraday Liquidity, Cashflow Projection and Liquidity Stress Test reports for BHC.

Created the BHC Reporting Model with four-layer architecture (Database, Business, Dimensional and Presentation) against the Liquidity Risk and CDW data marts.

Created the following reports in Cognos Report Studio

BHC Affiliate Summary/Detail Report

BHC Liquidity Stress test Detail Report

Environment: Cognos Analytics 11.0.11 (Framework Manager, Report Studio), Oracle 12cR1

SMBC (Sumitomo Mitsui Banking Corporation) – EPS Reporting

The Enhanced Prudential Standards (EPS) for Foreign Banking Organizations (FBO) requires SMBC New York Branch and the consolidated US Operations to conduct liquidity stress testing at the consolidated level. The result of this stress test will inform the size of the liquidity buffer that must be held to offset the net stressed cashflows over a 30-day stressed horizon. This process has been performed by RMDAD through a manual process involving Excel, Access and is prone to possible operational deficiencies. The scope is to create an automated liquidity stress test report incorporating New York Branch, Capital Markets, Nikko SI, Manufacturer's Bank and Manhattan Asset Funding. The scope also included creating the automated Cashflow Projections report on a previous business day basis that will source the data from New York and Cayman branches as well as the subsidiaries MB, SI, CM, LF, RS, SMFL.

Gathered the technical requirements for creating the EPS Liquidity Stress Test Reports and Cashflow Projections reports.

Created the EPS Reporting Model with four-layer architecture (Database, Business, Dimensional and Presentation) against the CDW data warehouse to support the reporting and ad-hoc analysis requirements and published the EPS Reporting Package.

Created the eMRG Dashboard (Enterprise Model Risk Governance) that will assist SMBC in regulatory submissions on the status of the model risk management at the bank. The dashboard will help senior management in making decisions regarding the management of model risk at the bank.

Created the following reports in Cognos Report Studio

Liquidity Stress Test Summary/Detail

LST OBS Cashflow

LST Products X Time Buckets

Liquidity Risk Dashboard

Cashflow Projections NY/Cayman Summary/Detail

Cashflow Projections for All Other Entities

Intraday Liquidity Reports

Collateral Monitoring Reports

Derivative/FX/Collateral Cashflows Control Tool

Reports were scheduled to run daily using Cognos schedules and the report output were copied to File System.

Email notifications were sent to the key users for any report failures.

Created the Historical versions of the reports for Liquidity Stress Test, Cashflow Projections, Collateral Monitoring and Intraday Liquidity reports.

Environment: Cognos 10.2.2 (Framework Manager, Report Studio, Workspace Advanced), Oracle

CVI Coopervision – Supply Chain Logility Reports

Discuss the Logility Report Requirements

Design metadata and develop the FM model for Supply Chain Logility Datamart from Netezza tables following Cognos best practices.

The following reports (charts/visualizations) were created in Cognos Report Studio and Workspace Advanced

Inventory Health Actuals # SKU’s / # Lenses

Inventory Health Planned # SKU’s / # Lenses

Exception Messages and Short Supply

Forecast Error Coefficient – Product/Country

Forecast Error Coefficient – Product/Country Trend

Demand Review Forecast Statistics

Environment: Cognos 10.2.2 (Framework Manager, Report Studio, Workspace Advanced), Netezza

Prudential Insurance – ILIAD Surveillance Metrics

Goal was to create a Cognos reporting environment to switch from manual/Excel reporting into a self-served and automated reporting environment

Working with Compliance department staff in defining the reporting requirements

Data gathering from different systems/databases

Design metadata and develop the FM model for ILIAD Metrics from DB2 tables following Cognos best practices.

Developed Cognos BI summary, detail and drill-through reports that involved using complex calculations and statistical functions such as standard-deviation etc.

Followed Prudential’s QA & UAT process in migrating the reports and package to production

The following reports were created in Report Studio

ILIAD Complaints - Top Level Report (by Product, Representative, Firm, Office) By Year/Quarter by Received/Closed Date

ILIAD Complaints - Ranking Report (by Product, Representative, Firm, Office) By Year/Quarter

ILIAD Complaints - Conditionally Formatted Report (by Product, Representative, Firm, Office) By Year/Quarter By Received/Closed Date

ILIAD Complaints - Detail Extended (by Product, Representative, Firm, Office) By Received/Closed Date

Environment: Cognos 10.2.2 (Framework Manager, Report Studio), DB2

VSP/Marchon – Mobile Dashboard Project

Design metadata and develop FM model for the IBM Cognos Mobile PoC based on the aggregated DB2 tables.

Convert MyMarchon views into more intuitive, interactive Active Report that leverages the capabilities of the IBM Cognos Mobile iPad app.

Build the Active Report with three levels of view - Regional, Representative and Brand.

Build a drill-through detail report for Representative by Account.

Design metadata and develop the FM model using the Power cube as data source for the Sales dashboard.

Development of management dashboards in Cognos BI 10.

Develop Sales Dashboard Active Reports for mobile devices such as iPad and online dashboards for Sales and Supply Chain groups.

Environment: Cognos 10.2.1 (Framework Manager, Report Studio, Active Report for mobile device/iPad)

Arch Insurance – Dynamic Cubes Project

Defined and developed Cognos BI Dynamic Cubes to take advantage of performance and volume capabilities

Gathered the technical requirements for creating the Cognos BI Statutory Dynamic cube against the FRD 2.0 database.

Install and configured the Cube Designer.

Installed SQL Server 2008 client.

Design the metadata and develop the cube designer model for the Statutory Dynamic Cube.

Design the dynamic cube with 30 dimensions, 35 measures and 30 calculated measures.

Create three independent dynamic cubes for CY, CQ and ITD time periods.

Create two Virtual dynamic cubes, Intermediate Statutory Cube and Statutory Cube combining the CY, CQ and ITD dynamic cubes.

Developed reports and enabled client to leverage Dynamic cubes.

Did report analysis for migrating the Cognos Group Exhibit Reports from Cognos 8.4 to Cognos 10 BI

Design metadata and Develop FM model against the new FRD 2.0 database.

Develop the Cognos Group Exhibits against the new database FRD 2.0 and scheduled it to run daily.

Environment: Cognos 10.2.1 (Dynamic Cube Designer, Framework Manager, Report Studio), Cognos 8.3 (Framework Manager, Report Studio), SQL Server 2008

Coopervision – Active Reports

Created the Territory Insight Report using the Active Report functionality in Cognos 10.2 with charts displaying key metrics like Revenue by Product, Segment, and Profile.

Created multiple page active report to display details on Product Performance, Customer Analysis and Rep Performance.

Created the Customer Insight Report using the Active Report functionality with charts displaying key metrics like YTD Sales, YOY Growth and Growth%.

Created multiple page active report to display details on Customer Performance, Customer History and Customer Quality.

Environment: Cognos 10.2 (Report Studio, Active Report)

Excellus – Business Intelligence

Setup the data mart in DB2 for the Excellus Dashboard PoC.

Create the staging tables in DB2 and load the staging data from the text files

Create the reporting tables and write SQL scripts to load the reporting tables.

Write stored procedures to retrieve the result set for the performance by port and volume.

Designed metadata and developed the FM model for Excellus Dashboard PoC reporting requirements.

Implemented data security on the FM model.

Created the Storage Performance Exception Report

Create table indexes for improving the report performance.

Environment: Cognos 8.3 (Framework Manager, Report Studio), DB2

Single Entry – Expert Insure Reporting

Designed metadata and developed the FM model for Expert Insure Reporting requirements.

Created the following Report Studio Reports

Production Summary Report

Premiums Summary Report

Submissions Summary Report

In-force Summary Report

Dynamically set the date range on the date prompts depending on the date type selected (YTD, Last Week, Last Month, Custom etc) using Java Script.

Drill through links was setup from main report to dynamically drill to the intermediate coverage report or to the final detail report depending on the filter/sub-filter prompt selection.

Build TIS Bordereau Reports from the TIS reporting model.

Environment: Cognos 10.2 (Framework Manager, Report Studio), Java Script

BBH – SSI Securities and Cash

Designed metadata and developed the FM model for SSI Securities and Cash reporting requirements.

Implemented data security on the FM model.

Created the following Report Studio Reports

SSI Securities Report

SSI Cash Report

Created the technical design document for the SSI Securities and Cash FM Model.

Environment: Cognos 10.2 (Framework Manager, Report Studio), Oracle 10i

MetLife – Active Reports

Gathered reporting requirements for a BI proof-of-concept at MetLife.

Created tables in the SQL Server database based on the sample data provided by the client and designed the FM package.

Created AHS Event Distribution Report in Cognos 10.2 based on the sample Excel report provided.

Created AHS Event Distribution Dashboard Report using the Active Report Functionality in Cognos 10.2

The Active Report was developed using Crosstabs, Bar and Pie Charts and included various measures summarized by Event Date and Event Type.

A version of the Active report was developed for iPad Users.

Created the Report Studio Hands-On Training Material for the Business Users.

Environment: Cognos 10.2 (Framework Manager, Report Studio, Active Report), SQL Server 2008 R2

Bank of America – Active Reports

Gathered reporting requirements for a BI proof-of-concept at Bank of America.

Created the Cognos Dashboard Report with Active Report Functionality in Cognos 10.1.1 (using the existing FM package) that was later integrated with Compass platform.

The Active Report included key metrics like Daily, Weekly, MTD, QTD, and YTD Production grouped by Region, Top 6 Productions by Country using Lists, Column and Pie charts.

Created Drill Through links from Active Report to Cognos 10.1.1 to get the detailed data.

Environment: Cognos 10.1.1 (Report Studio, Active Report), Oracle 10g

UBS – Business Intelligence and OLAP

Gathered the reporting requirements for UBS.

Created the following Report Studio Reports involving various MDX calculations with Cognos Powercube as the data source.

Daily Insurance and Annuity Report

YTD Annuity Sales by Division Region and Complex

Insurance and Annuity Big Ticket Report

Regional Summary - YTD Annuity Market Share by National Sales

Market Sales Report by Carrier by Region

Worked on improving the performance of few Cognos reports.

Environment: Cognos 8.3, Oracle 9i

Metlife - Custom Training

Created custom training content for Cognos BI end-users and report developers

Delivered training to Cognos BI end-users and report developers

Prevent Child Abuse NJ, Oct 2012 to Nov 2012 – Cognos Express Implementation/Cognos Consultant

Installed and Configured Cognos Express 10.1 (Manager 10.1, Reporter 10.1, Cognos Framework Manager 10.1) and setup the Cognos users.

Installed SQL Server Express 2008 R2 and restored the SQL Server database.

Gathered user requirements for metadata modeling in Framework Manager.

Created the PCA Reporting Framework Model and published the package to the Cognos Portal.

Environment: Cognos Express 10.1 (Manager 10.1, Reporter 10.1, Cognos Framework Manager 10.1), SQL Server Express 2008 R2

Education Affiliates, Jan 2012 to Sep 2012 – EA Reporting/Cognos Consultant

Created the EA Reporting Model with four layer architecture (Import, Consolidated, Dimensional and Presentation) to support the reporting and ad-hoc analysis requirements and published the EA Reporting Package to Cognos 10 portal.

Setup Cognos Roles (BI Enhanced Consumer, BI Advanced Business Author, BI Professional, BI Administrator) for Cognos Capabilities.

Created Cognos Groups (Executive, Marketing, Education, Finance, Accounting etc.,) to setup the folder/report access and linked it to appropriate User Groups/Roles in the Active Directory.

Enabled the Data Level Security in the Framework Model based on the list of Schools the user group can access.

Developed Cognos Reports to get the trending of key metrics like Leads, Contact Positives, Interviews, Enrollments, Starts etc. Developed drill-through reports for the detailed information.

Enhanced the FM model by setting up key dimensions and measures (DMR functionality) for the users to drill up/down to get the highly summarized or detailed information. Some of the dimensions are GL Programs, NDOA High School, RVP, and Accrediting Agency.

Created some Dashboards using Active Report functionality.

Created Cognos Reports with a capability to randomly select the grouping and hide/show the report columns based on the selection.

Created Export/Import Deployment specifications to migrate Cognos Reports/Packages/User Groups/User Roles from Development to Production.

Environment: Cognos 10.1.1 (Framework Manager, Report Studio, Query Studio, Analysis Studio), SQL Server 2008 R2

Prudential, Aug 2011 to Dec 2011 – Compliance Global Metrics/Cognos Consultant

Created the GCM Model with multi-layer architecture and published the GCM Package to Cognos 10 portal using Framework Manager.

Enabled the Data Level Security in the Framework Model using the User’s Login ID.

Developed the Quarterly CCO Compliance Dashboard with all the critical compliance metrics highlighting trends, events, and/or patterns. Defined the drill-through on charts to provide detailed information for investigation

Enhanced the charts with DMR functionality for the users to drill up/down to get the highly summarized or detailed information.

Created the Key Metrics Dashboard report for various Business Groups using Active Report functionality.

Created the Top G & E Provided and Received Report with the ability for the user to select their own Top-N entities for Current and Last Year.

Created Import and Export Deployment specifications to migrate Cognos content from Development to QA and Production.

Used Microsoft Visual Source Safe for Model Versioning.

Environment: Cognos 10 BI (Framework Manager, Report Studio, Query Studio, Analysis Studio), DB2, Microsoft Visual Source Safe

Chartis Insurance (AIG), Jan 2010 to Jul 2011 – Intercompany Pooling System (ICP)/Cognos Consultant

Involved in the requirements gathering and met with the Business Users for the reporting needs.

Prepared the Business Requirement Documents (BRD), Detailed Requirements Documents (DRD) and Technical Specification Documents.

Developed a process using Cognos Impromptu/Macro to generate the “SAP Back Feed” to provide Intercompany Pooling (ICP) balances to SAP CFP platform. The balances/activity in SAP is not at the detailed level, so the feed has to be provided from Cognos ICP data marts. The following feeds were provided:

US Pre-pool and Pool for Balance Sheet Accounts.

US Pre-pool and Pool for Profit & Loss Accounts.

Canada Balance Sheet and Profit & Loss Accounts.

Developed a process using Cognos Impromptu/Macro to generate the quarterly “Manchester Feed” required for the NAIC filing (National Association for Insurance Commissioners) by the regulatory department of New Hampshire. Every insurance firm in the US is required to report premiums and losses incurred for each quarter to NAIC.

Developed a process using Cognos Impromptu/Macro to generate “BUDPROD Extract” required by the Finance Planning & Analysis and Budget Forecasting Groups.

Developed and automated a process to reconcile the numbers between SAP BI and Cognos Data marts on a daily basis. Currently this a manual and time-consuming process.

Created and published Packages and cubes to Cognos 8.3 portal using Framework Manager.

Created Ad-Hoc Reports using Query Studio and Analysis Studio based on user requirements.

Extensively worked on Cognos Transformer Model to build the Operating Expense cube.

Published IWR reports and PowerPlay cubes on the portal using Cognos IWR Admin and PowerPlay Enterprise Server (PPES).

Provided production support for the Cognos Downstream Applications during quarter closing.

Environment: Cognos 8.3 Suite (Framework Manager, Report Studio, Query Studio, Analysis Studio), Cognos Series 7.0 (Transformer, PowerPlay, Impromptu, IWR, PPES, Cognos Scripting/Macro), SAP BW/BI 7.0, SAP NetWeaver 7.0, Oracle 10g, PL/SQL 10.2, SQL Server 2005, Cognos TM1

Pepsi Co, Sep 2009 to Dec 2009 – Cognos Reports Migration/Cognos Consultant

Upgraded Cognos content from 8.1 to Cognos 8.4 involving FM Models, Reports and Queries

Analyzed upgrade related issues in 8.4 Framework Manager Models and complex Financial and Sales Reports developed in 8.1 using wide range of calculations and functions

Customized the FM models generated by Enterprise Planning to fix the issues arising due to DMR functionality

Created Import and Export utilities to migrate Cognos content.

Migrated Report Studio reports from Cognos 8.1 to Cognos 8.4

Debugged and fixed issues on the upgraded reports

Analyzed complex queries on migrated reports and fixed issues with UNION and join queries that were used on the reports.

Resolved Issues relating to prompt display and sorting on reports.

Tuned existing reports by applying optimization techniques like Query Execution method, used slicers to filter dimensional data as opposed to detail filters.

Designed new Report Studio reports, report views for report consolidation

Updated reports with Cognos 8.4 features relating to drill down and chart techniques.

Environment: Cognos 8.4 Suite (Framework Manager, Report Studio, Query Studio, Analysis Studio), SQL Server 2005

Marsh & McLennan, May 2009 to Aug 2009 – Cognos Dashboard Reporting - Query Issues/Cognos Consultant

Analyzed the functionality requirements and the gaps in the report design.

The Cognos 8.3 Report Studio report was expected to show Top 20 vendors for CY and their expenses for LY. But the report was pulling Top 20 vendors for CY and then Top 20 vendors for LY, combining them and displayed the final results. This issue was solved by splitting the single query into multiple queries and combining them and displaying the final results with correct Ranking.

The pro-rated amount of billable hours was not calculated properly because, the calculation was happening at a row level data. Summarized the data to the highest level possible and passed this data as an input to the new query. Calculated the pro-rated amount on the final query solved the problem.

Performed the unit and integration testing on the dashboards to validate the fixes made to the report

Moved the Reports to production after reconciliation.

Provided recommendation on best practices of C8 Reporting.

Environment: Cognos 8.3 Suite (Framework Manager, Report Studio)

Touchstone Healthcare, Jan 2009 to Apr 2009 – Cognos Income Statement Cube Update/Cognos Consultant

Finalized the requirements for Income Statement Cube Updates with the key stake holders

Analyzed the tasks required for adding the new dimensions

Analyzed the tasks required for updating the impromptu reports

Added new dimensions and updated existing dimensions to the Income Statement Cube using Cognos Transformer 7.3

Loaded data into the cube and reconciled the data against data sources ensuring accuracy and consistency

Tested (Integration and UAT) and published the cubes to the upfront

Modified the IWR reports to add new dimension columns and reconciled them, assisted in UAT and published the reports to the Upfront.

Documented the tasks performed and provided transition to the maintenance team.

Environment: Cognos Series 7.3 (Transformer, PowerPlay, Impromptu, IWR, PPES), Upfront, Access Manager, SQL Server 2005

Bank of America, Apr 2008 to Dec 2008 – Management Reporting Database for the Research Tech. Group/Cognos Consultant

Initial Requirements Analysis, meetings with Project Sponsors, Business Users, Client Technical Team

Detailed analysis of report requirements, preparing a list of data elements required and identifying sources for those data elements

Detailed analysis of data from different sources, meetings with source system owners and Subject Matter Experts

Creating different type of documents, including Business Requirement Documents, Technical Design Documents and Report Requirement Specifications.

Development of Cognos Framework Manager Model and Packages for Canned Reports, Ad-hoc reporting, Exception reporting etc.

Development of MRD reports using Cognos Report Studio

Customized the Year and Month prompts by selecting appropriate year and month from the dropdown list according to the business rules. This was achieved only using JavaScript.

Environment: Cognos 8.3 Suite (Framework Manager, Report Studio, Query Studio), Oracle 10g, PL/SQL, Informatica, Embarcadero ER Studio, JavaScript

BASF Chemicals, Dec 2005 to Mar 2008 – BW-Reporting/Lead Implementation Consultant

Developed numerous Impromptu, IWR, Report Studio, Analysis Studio and Drill-through reports and published them to the Portal.

Developed PowerPlay Reports and published them to Upfront for the Finance and other user communities. Very experienced in Cognos PowerPlay Transformer.

Used Framework Manager to create models and publish packages.

Developed a complex report called Weekly Business Report using Report Studio in the Cognos 8 environment for the Sales & Marketing community and published them to the Cognos Connection.

Developed a tool called Model Conversion Utility using Cognos Script that can convert any given transformer model to point the database from Quality to Production or vice-versa.

Successfully completed the testing of Cognos Series 7 reports & cubes and Cognos 8 Reports for the database server move from Anderson to Germany. The usage of Model Conversion Utility for this project was a highlight and has saved considerable man-hours.

Designed and Implemented the Mercury Performance Monitoring PowerCube for the Architecture Group, adhering to all the PowerPlay guidelines of BASF.

Combined Finance Inventory and Product Inventory Trend Cubes into one single cube that not only saved load on the database server but also reduced the cube build times into half.

Played a huge role in the production support of the Cognos BW-Reporting System adhering to the Change Management procedure for all the new requests or enhancements.

Worked on mission critical Financial PowerPlay cubes to support the necessary Year-To-Date time dimension Preventative Maintenance changes every year.

Gathered the report specifications and created the design document for ECO OEM Cube which is the special variation of existing Income Statement cube.

Developed Weekly Gross Sales cube for the Sales and Marketing users that had very complex logic involving a custom created JP Calendar.

Worked on four financial cubes in moving the Currency dimension to Measure folders thereby reducing the cube build times to as little as one fourth.

Followed all the Guidelines from BASF in developing the cubes and reports.

Environment: Cognos 8 Suite (Framework Manager, Report Studio, Query Studio, Cognos Configuration, Cognos Connection), Cognos Series 7.3 (PowerPlay, IWR, Impromptu, PPES), Upfront, Access Manager, Cognos Script, SAP-BW 3.5, Oracle 9i, PL/SQL

Organon Pharma/Akzo Nobel, Feb 2004 to Dec 2005 - EDW -Reporting/Lead Implementation Consultant

Installed Cognos Series 7.2 on Development and Production servers.

Designed and developed KPI Reports, Query Tracking Reports using Impromptu for CTO/Clinical users and published it to the Upfront.

Created the

Contact this candidate