1 · web view+49 69 95155585+49 176 32656755lucian@ lucian comanescu dwh/bi/cognos consultant...

Lucian ComanescuErna-Pinner-Straße 86, 60438 FrankfurtMobile: +49 176 32656755Home: +49 69 95155585Email: [email protected]

Lucian Comanescu – Profile BI/Cognos Consultant

Lucian ComanescuDWH/BI/Cognos Consultant

PERSONAL DETAILS

Address: Erna-Pinner-Straße 8660438 Frankfurt

Phone: +49 176 32656755 (mobile)+49 69 95155585 (home)

Fax: +49 (0)3212 2662637Email: [email protected]/place of birth 25.03.1974, Brasov, RomaniaNationality RomanianExperience 10 years (Cognos), 6 years (java)Last position Senior BI/Cognos Consultant

MAIN AREAS OF EXPERTISE:

Business Intelligence with IBM Cognos 8 BI Framework Manager (versions ReportNet, 8.1, 8.3, 8.4.1 and 10.2.1) Cognos 8 BI Transformer (Windows and UNIX, version 6.5 to 8.4) Software Development Kit (SDK), Macro Editor PowerPlay Enterprise Server and PowerPlay Transformer (Windows/UNIX, v. 6.5 to 7.4) Cognos Connection with Studios: Report / Query / Event / Analysis and PowerPlay Studio Cognos Insight 10.2.1 Older Components and/or Tools (Cognos Architect, Cognos Query, Upfront, Impromptu)

Design of relational and multidimensional models with Framework Manager und Transformer (PowerCubes), Microsoft Analysis Services, SAP BW und SAP HANA

Modeling metadata relational and multidimensional (OLAP) Cognos SDK and SAP BO SDK Java programming Report Authoring (requirements, design, techniques) with Cognos Report Studio,

SAP BO Webi, Microsoft Reporting Services, PowerPivot, PowerQuery und Power BI

SQL and MDX, PL/SQL (Oracle) and database design UNIX/Linux and MS DOS shell scripting HTML and JavaScript, XML and XSLT



Overview

Working in BI/BA Competence Centers

I was working, in the last ten years, in two Cognos/BI Competence Centers for two big banks – the Risk Intelligence Infrastructure (RII) department of WestLB and Release Cluster DWH/BI at Commerzbank) and the regional business analytics team of a big company in the consumer goods industry (Nestle, Regional Globe Office), being responsible for the development, maintenance and deployment of Business Intelligence Solutions for several projects, covering different aspects of Risk Management and Reporting, integration of 3rd parties solutions and/or applications into the reporting landscape (ex. DataNet, JasperReports, cocoon) and developing and maintaining different inter-project interfaces.

Cognos Know-how and the Diversity of Cognos Roles

The biggest advantage of working in different projects is, of course, the diversity of roles I had to cover in the same time:

consumer, using the IBM Cognos Connection Portal, SAP Portal or SAP BO Launchpad to view personal reports, for business support, and/or on behalf of the users

business support: build simple queries, both SQL and MDX, to focus on variances, shift through large amounts of data, and investigate different areas of business through interactive analyses, ad hoc reports and/or data extracts

report author: build sophisticated reports for consumers by gathering report requirements and creating the reports for distribution

designer/architect: responsible for developing/designing databases (data marts) on Oracle and SQL Server, designing relational and multidimensional/OLAP Framework Manager models and SAP BO Universes, Transformer PowerCubes, Microsoft Analysis Services OLAP cubes and SAP BW InfoProviders and BEx Queries

developer of SDK applications and scripts for Cognos and SAP Business Objects trainer: concept, materials and user trainings in Düsseldorf, London, York, Vevey, Sofia and

Frankfurt administrator: manage the deployment of IBM Cognos 8 Business Intelligence, including

installation, configuration, maintenance, content management, security and system optimization

Business Knowledge and Support

My former education and all the years of experience of working close with the business department have developed a very good business basis - not only that I am able to understand and communicate effectively with business users, but also developed an interest and understanding for the business processes themselves. I have a very good experience in gathering business requirements and translating them into technical specifications, negotiating and modifying those requirements to match the development/IT or company strategy, evaluate the costs and implications of different alternatives into the IT or business processes and/or evaluate the effects of different solutions into the general IT landscape (e.g. how changes in a certain project will affect other projects or the interfaces to other projects). And I take my permanent invitation to the most important reorganization, planning and regular business meetings as a confirmation of the above.



This very good understanding of business logic and knowledge of pre and post systems coupled with good knowledge of Java, SQL, SSIS and PL/SQL allow me to easily and effectively trace and find implementations problems, answer business questions and solve different data quality issues from the front-office systems, through data warehouse and risk engines, to the reporting data marts. These analysis and investigation skills were quickly recognized and are, probably, one of the main reasons for my long lasting relationship with WestLB and Nestle and I consider it a big advantage compared with other consultants.

Cognos Related Knowledge and Second Level Support

Another strong point I have is my excellent knowledge of "around" DHW/Cognos/BO technologies:

My excellent SQL and PL/SQL knowledge allow me to quickly analyze the performance of different modeling options and/or report designs, via exported SQL, directly in database or, based on an optimized SQL to change the model or report for better performance. My database knowledge was also highly appreciated during test phases (compare reports results with data extracted directly from database), for support (mainly tracing and finding implementation problems or data quality issues) and for ad-hoc reports and data extracts (non-standard time series or data requests that had to be extracted directly from database).

The years of experience as java developer not only that allowed me to easily understand and effectively use the Cognos and SAP BO SDK, but also understand the Cognos internal processes and sometimes to find workarounds. Worth mentioning are at least Web Services and SOA architecture, database connectivity (JDBC), java logging and related technologies like HTTP protocol, HTML and java script, experience with Apache Web Server and Tomcat.

I also have very good experience with XML and related technologies (XSLT, XPath, XQuery, Web Services) - my automated xslt tool for package/reports extraction and documentation being quickly generalized to all Cognos projects, both by WestLB and Nestle

Another Cognos related area were I can provide an excellent expertise is Security and LDAP: from the protocol itself to query, design (schema, hierarchy), architecture and topology (with replication), installation and configuration, administration, ldap java APIs (Netscape, jldap, JNDI), ldap clients, ldap servers: Netscape/iPlanet/SunOne/Sun DS, OpenLDAP, Active Directory, different SSO strategy and Trusted Signon Provider and Cognos Namespace implementation. The fact that I was member of the security redesign team, organized by WestLB User Management, having different presentations and discussing different alternative strategies, is a proof of those knowledge and skills.

And I cannot close this point without mentioning my UNIX, Linux and Windows skills: from administration and tools to excellent scripting skills. My cube generations scripts and RII Queue were highly recognized and appreciated by my current customer.

One of my best Achievements

A very challenging task was PoRiDa redesign: after less than two years of project life, with performance problems, in September 2006 I was appointed as member (of a three men team) of the task force for the project redesign. The expectations were small, but the results overwhelming.

We completely redesign the database schema and the Framework model, creating a very performant multi-star schema with the minimum needed indexing strategy - only exactly those needed for reporting, completely removed the materialized views, consolidate the portfolio hierarchy, automatically generated the most important (most used) reports - introducing reports burst and other improvements that leaded to improving the ETL-Process with almost 40% (under 3 hours), report execution times from 15 to less than 2 minutes, cube generation times from 8 to 2 hours. This not only that allowed online analysis (the generation of the original cubes was stopped, cubes being generated too late), but offered also a dramatically improved user experience:



cube browse time decrease drastically because, using a cube group, was possible to generate 6 smaller cubes, one for each KRI (Key Risk Indicator) group with drill through from one cube to another and to the master cube;

very fast drill through reports for detailed information, already pre-filtered with the cube selection (and database indexes following very tight this selection);

ready for download reports: pre-generated standard reports (bursted per portfolio groups) and scheduled data extracts

faster report execution due to a parameter map with portfolio version id and run id (the database partitions keys)

Personal skills

I was also very appreciated, at WestLB and Nestle, for my interest in the internal processes and my ideas and contributions to improve those processes. The Cognos Cockpit, Package Documentation Tool, RII Queue and Report Validation and Migration Tool were some of the most remarkable improvements. My open personality and communication abilities help me develop excellent relationships with colleagues, peers from other projects, business users and production support team as well as with team and department leaders. My excellent analytic skills and abilities to locate problems determined lots of colleagues and peers to ask my help in solving problems. Because of my abilities to learn quickly and digest new things, I was almost always selected to test new Cognos versions, check their features and evaluate their usefulness for the client and take part into several research groups and task forces.

Summary

Probably the main gain of working in multiple projects is the exposure to different aspects of business, different project requirements and targets and different types of problems I had to solve during different points in the projects' life cycles. Each project had its own set of different user and technical requirements, different targets and constraints, different types of day-to-day problems and support issues. All those, together with my knowledge and experience with the main Cognos Products, databases and SQL, Security and LDAP, UNIX and shell scripting, Cognos scripting, java and XML and my personal skills and abilities will allow me to easily integrate into your projects and teams and quickly become effective.



WORK HISTORY

Nov 2009 – Nestle Globe Center Europe GmbH, BI/DWH Consultant

designer/architect, responsible for data warehouse and cube changes and design of the relational Framework Manager model and BO Universe

technical specifications and coordination of offshore development for new markets implementations

report and dashboard design for different markets trainer for different advanced Cognos topics and user

workshops

Oct 2009 – Oct 2010 Commerzbank AG, BI/Cognos Consultant

consultant: manage the deployment of IBM Cognos 8 Business Intelligence, including installation, configuration, maintenance, content management, security and system optimizations

development of java SDK applications for synchronization between Cognos and the bank’s internal security system

Jan 2004 – Sep 2009 WestLB AG, BI/Cognos Consultant

development, maintenance and deployment of Business Intelligence Solutions for several risk management projects from Risk Intelligence Infrastructure (RII) department

report author: gathering report requirements and creating sophisticated reports for consumers

designer/architect: responsible for developing databases (data marts), designing relational and multidimensional Framework Manager models, modeling metadata and creating OLAP models

developer of SDK applications, Cognos script and Decision Stream scripting language

trainer: concept, materials and user trainings in Düsseldorf and London

Jul 2003 – Dec 2004 WestLB AG / Quest Software GmbH, Java Consultant

Architecture, design and implementation of a report engine and web interface for the Risk Management and Reporting

Sep 2002 – May 2003 Start Amadeus AG / AK Business Solutions GmbH, Java Consultant

Middleware Implementation and release support for a big Touristic Portal (TUI)

EJB design and implementation for an online reservation system and integration into company’s portal

Sep 2001 – Aug 2002 IT Vision Systemhaus GmbH (renamed Vision Systems GmbH), Senior Developer

Architecture and server-side implementation of middleware components

Database design and SQL layers



Sep 2000 – Jun 2001 Transylvania University Brasov, Guest-Professor at IT Department

Topic “Programming with Java“, 3rd year Topic “Distributed Applications Programming”, master

programme (6th year)

Aug 1997 – Sep 2001 IT Vision srl Romania (100% German Investment - IT Vision Systemhaus GmbH), General/Project Manager

Project Management for several software projects (or parts of projects) for the mother company

EDUCATION

Sep 1992 – Jul 1997 “Transylvania” University of Brasov, RomaniaInternational Business Relations Department

Sep 1988 – Jul 1992 Computers High-school no. 1, Brasov, Romania

FURTHER EDUCATION and TRAINING

2014 Data Science Specialization – Johns Hopkins University on Coursera

March 2002 TopLink Training, WebGain, LangenMai 1996 European Leadership Seminar, AIESEC, Prague1995 – 1996 Various AIESEC trainings: Leadership, Communication

Skills, Team Building, Project Management

EXTRA-CURRICULA ACTIVITIES

09/2006 – Member of Dietzenbach Bridge Club10/1995 – 10/1996 AIESEC Brasov Local Committee President (LCP)1993 – 1995 Member of AIESEC (www.aiesec.org) at University

Transylvania, BrasovProject Manager of various AIESEC Projects.

LANGUAGE SKILLS

Romanian – nativeEnglish – fluentGerman – fluentFrench – conversational

PERSONAL INTERESTS

BridgeBiking

REFERENCESExcellent references available on request.

BI/Cognos Tools Overview


IBM Cognos Products and Tools

Cognos 8/10 Suite: Framework Manager (versions 8.1, 8.3, 8.4.1 and 10.2.1) Cognos 8 BI Transformer (Windows and UNIX, version 8.3 and 8.4) Software Development Kit (SDK) from ReportNet to 10.2.1 Cognos Connection, Event Studio, Analysis Studio, Query Studio, Report Studio and

PowerPlay Studio (versions 8.1, 8.3, 8.4.1 and 10.2.1) Business Insight Studio 10.2.1 Metric Designer and Metric Studio (version 8.1)

Cognos Series 7 Suite (version 7.x, ReportNet) Framework Manager (ReportNet version) PowerPlay Enterprise Server and PowerPlay Transformer (Windows and UNIX, versions 6.5

and 7.1 to 7.4) Software Development Kit (SDK), Macro Editor Cognos ReportNet with Studios Decision Stream Designer and scripting language

Older Components and/or Tools Cognos Architect, Cognos Query, Upfront, Impromptu and Impromptu Web Reports

Other Cognos Tools Configuration Manager, Access Manager, Map Manager Apparo FastEdit (1.9)

SAP Business Intelligence (BO BI)

SAP Universe Designer (UDT) XI 3.0/3.1, Information Design Tool (IDT) XI 4.0/4.1 SAP Business Objects Web Intelligence (Webi) 3.0 - 4.1 SAP Business Objects 4.0 Analysis for Excel 1.3 SAP HANA Studio 9.6 – 10.2

SAP Business Explorer (BEx) / Business Information Warehouse

Query Designer 3.x - 7.3 Report Designer 3.x - 7.3 Web Application Designer 3.x - 7.3 BEx Analyzer 3.x - 7.3 Modelling Workbench (RSA1), BI Content (RSORBCT), Metadata Repository (RSORMDR) Maintenance (RSD*, RSH), Process Chains / Monitoring



Microsoft SQL Server BI

SQL Server Database 2005 – 2012 SQL Server Analysis Services (MSAS/SSAS) 2005 – 2012 as Multidimensional and Tabular SQL Server Integration Services (SSIS) 2005 - 2012 SQL Server Power View (SSRS) and Power Pivot 2012 SQL Server BID Studio / Data Tools / Management Studio / Profiler 2005 - 2012

Database Systems and Tools

Microsoft SQL Server 9.0, 2005 – 2012 SAP HANA 1.4 Oracle (version 7.x - 10i), IBM DB2 7.2 – 9.1 Sybase ASE 15, Sybase IQ 12.x MySQL (3.x - 5.x), PostgreSQL (6.x - 7.x), MS Access 97, 2000 (with VBA) NCR's Teradata 4.0 SQL, PL/SQL (Oracle), PL/pgSQL (PostgreSQL) JDBC, ODBC, sqlUnit Quest's TOAD (7.x - 9.6), Computer Associates ERwin (3.5.2, 4.0), Oracle SQLPlus, Sybase

PowerDesigner 16.0

Operating Systems

Solaris (8 - 10), Linux (GNU, Red Hat, SUSE), Windows (starting from 3.5) Shell scripting for ksh, bash, Windows/DOS (with NT/2000 extensions)

LDAP Servers, Tools and APIs

SunOne/iPlanet/Netscape Directory Server OpenLDAP Active Directory Cognos Access Manager, ldapbrowser, ldapsearch as clients Cognos Series 7 Namespace structure and schema Cognos SDK, J2SE JNDI, Netscape LDAP API

Application/Web Servers

Apache Web Server (2.0, 2.2) Jakarta Tomcat (3.x - 5.5) Sun Java System Application Server (SunOne 5.x - GlassFish) BEA WebLogic (5.5 - 7.0) JBoss Application Server 2.x - 3.2.5 Inprise (Borland) Application Server - 4.1, 4.5



Other Reporting Tools

Jaspersoft BI Suite, iReport, JR eclipse plugin Apache Cocoon web publishing framework

Programming Languages

Java/J2EE (1.2 - 1.5) with Servlets/JSP, LDAP API, JDBC (see below) R (3.x) Perl and PHP (basic) VB (and VBA) HTML and Java Script

Java APIs and Tools

J2EE APIs: Enterprise JavaBeans (EJB), Java IDL, JavaMail, Java Message Service (JMS), Servlets/JavaServer Pages, JDBC, RMI, JDOM, SAX, Swing

Java Webstart Java IDEs: Eclipse IDE 2.x - 3.0, Borland's JBuilder (3.x - 8), Symantec Visual Café 2.5,

WebGain's Visual Café 4.5 Jakarta's Struts Framework (1.0.4, 1.1) log4j 1.1.3, 1.2 ant 1.4.1

XML

XML (XSD/DTD, Namespaces), XSLT, XPath, XQuery WSDL (Apache Axis) JXP and Apache Cocoon web publishing framework Standard Java APIs: SAX, DOM, JDOM, JAXP, Xpath, XQuery Data Binding: JAXB, Quick 3-4, Castor 0.9, BorlandXML Others APIs: XML:DB Altova XMLSpy, Liquid XML Studio, Eclipse XML

Testing Software

Rational XDE Mercury WinRunner 6.02 jUnit framework 3.7, jxUnit 3.1.x, Abbot 0.9, httpUnit 1.4 - 1.5.x, sqlUnit

Job Scheduling

TWS (Tiwoli Workload Scheduler) Control-M Integration Suite and Advanced File Transfer UC4 (including UC4 script language)



Others

OOAD software: Rational Rose 2000, microTool's objectiF, Eclipse UML, Poseidon UML, MS Visio

Project management: MS-Project 98 – 2010 Change Requests and Reporting & Process Management Tools: TeamTrack, Mantis CRMS Workflow, Document management, collaboration: CA NIKU OR mapping tools: WebGain's TopLink and Mapping Workbench 3.6, JBoss Hibernate 2.0.3 Version Management: CVS (WinCVS, Eclipse plugin, JBuilder 6-8 integrated CVS client),

Visual Source Safe, Git/GitHub Packaging: ant (1.4 - 1.6), RPM 2.x, 3.0 Office software: Microsoft Office 95, 97, 2000 - 2010 (Word, Excel, Outlook, PowerPoint,

Access, FrontPage), StarOffice 5.2, IBM's Lotus Notes 4.5, 4.6 (incl. Domino Server), KDE and GNOME

Graphics: Paint Shop Pro 4.1 - 7.0, Corel Draw 7, 8

BI/Cognos Projects Overview


Sales Force Automation (SFA) Data Warehouse

System OverviewCustomer / Industry Nestle Globe Center Europe / Consumer GoodsPeriod Nov 2010 – Dec 2015Team Size 8 (core team)Position Cognos / DWH ConsultantTechnology SQL Server 2005/2008 database, Analysis Services

(MSAS/SSAS), Integration Services (SSIS);IBM Cognos 8.4.1/10.2.1;Excel with Power View and Power Pivot; Tivoli Workload Scheduler (TWS) 8.5/8.6,Sybase Power Designer 16.0, Microsoft Team Foundation (TFS)

System SummarySFA is a mobile sales force application that covers all aspects of the field sales team - management of activities, order taking, customer management, product introductions, campaigns, budget management and others pre/post sales related activities. The reporting warehouse was split in 7 segments covering 39 countries on 5 continents, over 4000 reporting users and more than 2000 productive reports.

Main Responsibilities design and prototyping of several changes in the SSAS cubes (local calendar, relative

time categories, several new dimensions/hierarchies and measures, incl. MDX code) the complete redesign of the reporting security model – instead of Framework

Manager, the security was moved to database level (using views). This was not only simplifying the model, but also improve the performance of all the reports

specifications, design and implementation of 14 template (global) reports with complex prompting and conditional layout

Implementation of a customizable management dashboard that provided immediate feedback on the unique goals of each sales person and team from both territory and product perspective (flexible layout, drill down / drill through to details).

redesign and maintenance of a very complex Framework Manager model Java SDK scripts to automatically update and validate over 2000 reports on new

releases (model changes) advanced Report Studio training (OLAP reporting, Advanced Techniques, Performance

Improvements in both relational and multidimensional models) and workshops, in Frankfurt, York (UK), Vevey (CH), Sofia and Bratislava



SFA Migration to SAP BW / HANA with a SAP BO Front-End

System OverviewCustomer / Industry Nestle Globe Center Europe / Consumer GoodsPeriod Jul 2014 – Dec 2015Team Size 7 (onshore) / 8 (offshore)Position DWH Consultant / DesignerTechnology SAP HANA 1.4, SAP BW 7.3 – 7.4, SAP NetWeaver 7.3, SAP

BODS 4.1, SAP BO BI 4.1, SQL Server 2012

System SummaryMigration of the SFA data warehouse from SQL Server to SAP BW/HANA based on a multi-layer architecture with more than 2000 InfoObjects, 400 InfoPackages and 12 InfoCubes with 5 multi providers and a BO Universe based on generated SAP HANA external views for self-service reporting. Data extraction and initial validation was done with BODS using over 150 jobs and a flexible design to allow parallel loads from 40 different data sources.

Main Responsibilities data warehouse design for InfoObjects, Data Store Objects, MultiProviders and

Composite Providers and the partitioning concept database design for BODS staging layer and ETL requirements for parallel loading design of one global BO Universe (OLAP) based on global BEx queries design of one global BO Universe (relational) based on HANA views several BEx queries for global reporting and web templates design business and technical requirements for offshore development support markets to implement local BO Universes based on local queries (DSO)

SFA Implementation in North America

System OverviewCustomer / Industry Nestle Globe Center Europe / Consumer GoodsPeriod Oct 2012 – Jun 2013Team Size 5 (onshore) / 8 (offshore)Position DWH ConsultantTechnology SQL Server 2012, PowerPivot, SAP BO BI XI/4.0

System SummarySFA implementation in USA and Canada for more than 600 sales representatives and 800 reporting users, creating a complete new data warehouse segment and prototyping SAP BO BI as front-end for standard reporting.

Main Responsibilities design and implementation of the global Business Objects Universe support local market to implement a local, self-service, Business Objects Universe technical specifications for local requirements coordinate and support for offshore development of local and self-service Business

Objects Webi reports



Release Cluster DWH/BI

System OverviewCustomer / Industry Commerzbank AG / BankPeriod Jan 2010 – Nov 2010Team Size 7 (Cognos Team)Position ConsultantOperating system Windows 2003 ServerTechnology Cognos BI and Transformer 8.4/8.4.1, Cognos TM1 (9.5),

Apparo FastEdit (1.9), SQL Server 9.0, DB2 8.1/9.1, Sybase ASE (15.x) und IQ (12.x), Oracle (10i), SDK Applications (Java and .NET)

System SummaryVery complex Cognos Environment with 2 parallel production environments (one with 11 Servers and one with 5), test/pre-live system and 3 development environments, with different Cognos products (BI, Metric, TM1 and Transformer), for more than 20 projects (Data marts or Reporting Systems).

Main Responsibilities Design and implementation of a production environment– a distributed Installation on 4

Servers with terminal server (Citrix) clients Proof of Concept for connecting SAS data as Cognos data sources Upgrade to Cognos 8.4.1 and DB2 Version 9.1 Development of several SDK Tools for triggering Cognos jobs/events remotely from

other servers and different administrative tasks (constraints on report output versions, corporate design usage and other scripts for automatic changes to the content).

Audit for BI projects – analysis of Framework Manager models and the most used reports to solve performance problems or find optimizations

User support for developing new reports and/or changing current ones Second Level Support

Credit Watchlist

Project OverviewCustomer / Industry Commerzbank AG / BankPeriod Jan 2010 – May 2010Team Size 11 (2 Cognos Developers)Position Consultant and DeveloperOperating system Windows 2003 ServerTechnology Cognos 8.4/8.4.1, SQL Server 9.0, Apparo FastEdit (1.9),

Sagent ETL, UC4 (5.0)

Project SummaryThe project was setup as a warning system for the credit evaluation process. The whole portfolio was monthly analyzed and several criteria checked in order to extract a list of possible defaults. The watchlist was company wide and the credit officers where allowed to



see only parts of it (depending on a complex security concept) in order to comment, delete or add new credits to the list.

Main Responsibilities Development of reports with Report Studio and Query Studio and changes to very

complex reports Development of Apparo Business Cases to allow users to write the comments back to

the database and manually change ratings User support for changing personal reports and creating new ones Technical Support

Cognos Sync (SDK)

Project OverviewCustomer / Industry Commerzbank AG / BankPeriod Oct 2009 – Dec 2009Team Size 3 (1 Developer)Position Developer, external ConsultantOperating system Windows 2003 ServerTechnology Cognos 8.4/8.4.1 Software Development Kit (SDK), Active

Directory 2003, Company’s Security Management System, Java (1.5), Eclipse (3.0), UC4 (5.0)

Project SummaryFor the integration of the Cognos portal into the existing IT architecture was necessary to connect the Cognos Security with the company’s security management system. This was realized with a java application, based on Cognos Software Development Kit (SDK) that retrieved the users, groups and roles from the company’s wide system and synchronized it with Cognos internal security.

Main Responsibilities Technical specifications and design of the connector to the bank’s main Security

System Design and Implementation of the java application UC4 scripts for the automatisation of the whole process



PoRiDa - Position Risk Datamart

Project OverviewCustomer / Industry WestLB AG / BankPeriod Sep 2006 – Sep 2009Team Size 8 (3 developers)Position Developer, external ConsultantOperating system Windows XP / Sun Solaris 10Technology Cognos 8.1/8.3/8.4 Framework Manager, Report Studio and

Query Studio, PowerPlay Transformer 7.3/7.4/8.4, PowerPlay Enterprise Server, Oracle 9i/10i, SunOne 5.2/Active Directory 2003

Project Summary14 multidimensional cubes, over 200 reports built on a daily basis from over 11 Mio trade information records and over 48 Mio fact records, designed for a quick (but detailed) analyze of the first results from the main risk engine for a first impression of the daily results.

Main Responsibilities see “One of my best Achievements” above several releases including changes into the database and Framework Model minor transformer models changes several changes in the current reports and development of new reports user support in creating and changing personal reports user training (Düsseldorf and London) integration of cubes and reports into the scheduling system

MaRiDa - Market Risk Datamart

Project OverviewCustomer / Industry WestLB AG / BankPeriod Jan 2004 – Sep 2009Team Size ca. 20 (4-6 developers)Position Developer, external ConsultantOperating system Windows XP / Sun Solaris 9/10Technology Cognos 8.1/8.3/8.4 Framework Manager and Report/Query

Studio, PowerPlay Transformer 6.5/7.1/7.3/7.4/8.4, PowerPlay Enterprise Server, Oracle 8/9i/10i, Netscape 4/iPlanet 5.1/SunOne 5.2/Active Directory 2003

Project SummaryWith 63 multidimensional cubes, over 600 standard reports, interactive reports and status/process reporting module, MaRiDa was the main system in Risk Management and Controlling for risk and P&L reporting on a daily basis and historical data, methods back testing and portfolio stress testing. The data mart was an Oracle database containing more than 10 years of data for all bank units (from individual traders to bank level aggregates) with more than 400 measures (mostly with external rollup) available for a single node. The



process of filling the data from the main risk engines and other systems was also very complex and required the cubes/reports being generated multiple times a day.

Main Responsibilities implementation of Best-of concept (unified cube models to display only the best

available figures) that reduced the number of cubes to 39, visibly reducing the maintenance costs

more than 1000 change requests for different cubes and report changes and/or new cubes and reports

migration from Impromptu/Query to ReportNet and later to Cognos8 (8.1/8.3/8.4) design and implementation of the first MaRiDa dashboard report (one pager) and, later,

extending the concept to weekly and monthly executive summary and location executive summaries

developed custom user reports and, later, standard board reports based on a PowerPlay multidimensional model

prestudy for migration to Transformer 8.3/8.4, replace the Series 7 Namespace security with the WestLB LDAP (Active Directory) standard security model and Single Signon

replication of the Series 7 Namespace into a common tree LDAP structure to be used by non-Cognos applications, simplifying User Management tasks (perform changes only in the Cognos Access Manager and replicate them for other projects)

extensive business/user support and adhoc requests replacing the old queuing mechanism with RII Queue and Control-M

CARPE - Central Analysis & Reporting Portfolio Engine

Project OverviewCustomer / Industry WestLB AG / BankPeriod Jun 2007 – Sep 2009Team Size 6 (2 developers)Position Developer, external ConsultantOperating system Windows XP / Sun Solaris 9/10Technology ReportNet, Cognos 8.1/8.3/8.4 Framework Manager and

Report/Query Studio, PowerPlay Transformer and PowerPlay Enterprise Server 7.1 - 8.4, Oracle 9i/10i, iPlanet 5.1/SunOne 5.2/Active Directory 2003

Project Summary13 multidimensional cubes and over 200 Cognos 8 standard reports with data from different data sources for an integrated, web based, analysis, monitoring and reporting tool for Basel II requirements and the internal credit model showing the main KRIs and capital requirements, concentration and diversification per sectors and regions within the WestLB Portfolio correlated with the internal rating procedures.

Main Responsibilities several changes in the cubes and Framework Manager models changes in the current reports and development of new ones user support in creating and changing personal reports technical second level support



DataNet

Project OverviewCustomer / Industry WestLB AG / BankPeriod Jun 2008 – Dec 2008Team Size 4 (Düsseldorf)Position Developer, external ConsultantOperating system Windows XP / Sun Solaris 9/10Technology Cognos 8.3 and 8.4 Framework Manager and Report/Query

Studio, Oracle 10i, SunOne 5.2

Project SummaryDataNet is a reporting module containing a pre-packaged suite of 12 Cognos8 models, queries and reports offered by Misys for its loan management product, Loan IQ.

Main Responsibilities installation and customization of the whole suite including downgrade of Framework

Manager models to 8.1 integrate Load IQ security with Cognos Series 7 Namespace user support and training

Cognos Cockpit

Project OverviewCustomer / Industry WestLB AG / BankPeriod 2008/03 – 2008/06Team Size 4 (Düsseldorf)Position Developer, external ConsultantOperating system Windows XP / Sun Solaris 9/10Technology Cognos 8.1/8.3/8.4, Cognos Software Development Kit (SDK)

Project SummaryAdministrative web pages (add-on to Cognos Connection), based on a collection of different SDK servlets, to perform administrative tasks in a very convenient way. The most used functionality was: remove reports output, change cube and cube views gateways (before or after deployment), list the content store based on different filters (like package, user role/group, views on a selected cube/report), change folders access permissions (e.g. add a new user group to a folder and all subfolders that do not inherit parent's permissions or replace one user role/group with another).

I have also developed a set of scripts (based on Cognos SDK) to trigger jobs and/or reports from shell scripts and allow the integration of Cognos reports into the scheduling system of the bank (RII-Queue and Control-M).

Main Responsibilities wrote the most part of the functionality (JSP and Java Servlets with Cognos SDK) integrate the cockpit into p2pd (make it a web application that shared the same login

with Cognos connection) integration in the Job Scheduling (RII-Queue and Control-M)



Trusted Signon Provider and Single Signon (SSO)

Project OverviewCustomer / Industry WestLB AG / BankPeriod 2008/01 – 2008/03Team Size 1Position Developer, external ConsultantOperating system Windows XP / Red Hat Enterprise Linux 5Technology Cognos 8.3, Cognos Software Development Kit 8.3, Java 1.5,

OpenLDAP 2.2/Active Directory 2003

Project SummaryCustomer authentication and authorization solution for the Common Data warehouse Platform (future unique bank wide Cognos platform). CDP was the first project that moved away from the Cognos Series 7 Namespace, using the company standard Active Directory infrastructure. Due to the large number of users and groups in the 4 separate Active Directory servers, the performance on Cognos was very poor. My solution was a replication tool to replicate only CDP relevant users and groups and implementation of a custom Java Trusted Signon Provider that authenticate the users against the master Active Directory, but uses, for authorization, the lighter OpenLDAP replica.

Main Responsibilities the complete design and implementation (SDK interface

INamespaceTrustedSignonProvider) and integration into Cognos portal pre-study for a full implementation of the Cognos INamespace interface pre-study for SSO with Apache NTLM module and Active Directory native security

(Cognos gateway and content store on Windows machine with IIS Web server)

RoR - Return on Risk

Project OverviewCustomer / Industry WestLB AG / BankPeriod 2007/01 – 2007/06Team Size 18 (2 Cognos Developers, 2 PL/SQL Developers)Position Developer (Cognos and PL/SQL), MaRiDa technical consultantOperating system Windows XP / Sun Solaris 9/10Technology Cognos 8.1 Metric Designer, Metric Studio and Report Studio,

Framework Manager 8.1, PowerPlay Transformer 7.3 - 8.4, Oracle 9i, SunOne 5.2

Project SummaryDatamart for Economic Capital key risk indicators calculation and appropriate control of the Credit Risk Model: fine tuning of the stand-alone risk assessments and the model, regional and sector weights based on an internal rating model, providing board and management with a full range of Scorecards to help monitor, measure and manage corporate performance. Very complex, graphical oriented reports with drill-down or drill-through to detail reports and analysis for additional information or context, conditional formatting and exception highlighting draw users' immediate attention and exception-based alerts to



monitor performance on a daily, weekly, or monthly basis and get immediate visibility of key performance indicators (KPIs) for corrective action and rapid decision-making.

Main Responsibilities technical requirements and design of the ETL Process to load metrics from MaRiDa design and implementation of a new complex multidimensional cube design and implementation of a very complex scorecarding environment, with several

metric types and metrics, grouped on in a regional perspective design of new Report Studio reports (migration of old reports from the old java-based

application)

Cognos License Management and Housekeeping

Project OverviewCustomer / Industry WestLB AG / BankPeriod 2006/09 – 2006/12Team Size 1Position Developer, external ConsultantOperating system Windows XP / Sun Solaris 9/10Technology Cognos SDK 8.1/8.3/8.4, Netscape 4/iPlanet 5.1/SunOne 5.2/

Active Directory 2003, Java 1.4/1.5, Netscape SDK, Java JADAPI

Project SummaryIntegration of the Cognos Audit sample package with custom extensions for Cognos License Management (statistics on licenses usage and separation on different projects, disable/delete users that did not logged on in the last x months) and Content Store Housekeeping (list/delete reports output older than x days, list/delete reports and report views not used in the last x days).

Main Responsibilities integration of Cognos Audit sample into the production environment XML data source to read all reports and cube view from Content Store ldap extraction (java) and xslt transformation to assign users/licenses per projects



CAFE - Cognos Automated File Extractor

Project OverviewCustomer / Industry WestLB AG / BankPeriod 2006/01 – 2006/06Team Size 1Position Developer, external ConsultantOperating system Windows XP / Sun Solaris 9/10Technology Cognos SDK 8.1/8.3/8.4, Java 1.4/1.5

Project SummarySDK tool to export the generated reports from the Content Store and made them available, in a more convenient way, to users and, in the first hand, to other systems for further processing. The two main advantages were the easy integration into the job scheduling systems and the big flexibility in choosing the export destination: file system (both UNIX and windows over ftp/sftp/Connect Direct), email, and http remote call to other systems.

Main Responsibilities idea, the technical concept and specifications wrote scripts for ftp, sftp and http client download deployment into the productive environment

Scheduling System (RII Queue)

Project OverviewCustomer / Industry WestLB AG / BankPeriod 2005/03 - 2005/06Team Size 1Position DeveloperOperating system Sun Solaris 9/10Technology Oracle 9i, TOAD 8, ERWin 4, bash

Project SummarySimple, but very reliable and powerful, job scheduling system for cube/report generation, batch processing and other automated tasks. A very simple event-trigger model architecture, implemented only with shell scripts and PL/SQL, offering basic scheduling functionality: event (file marker, database, external) trigger, time and user triggers, and resource capacity and build priorities. The shell-based design made it possible, with minimum efforts, to migrate it, after 2 years, to Control-M.

Main Responsibilities the idea and the complete design and implementation (using only a couple of PL/SQL

procedures and functions and shell scripts) migration of all tasks to Control-M



Processing Overview

Project OverviewCustomer / Industry WestLB AG / BankPeriod 2004/06 - 2004/09Team Size 1Position DeveloperOperating system Sun Solaris 9/10Technology Oracle 9i, TOAD 8, ERWin 4, bash

Project SummaryWeb application for internal process monitoring and reporting. It had a quick overview with all important information on one page (Warnings/Errors, currently or soon processing, last processed MaRiDa Run, external files that contained errors and or missing/invalid user actions), Cube and Report Status Information (cube/reports start and end time, processing status and so on), external file delivery towards MaRiDa (are all files delivered, what is in the files, when were they delivered, are there problems, what are the error messages).It was initially implemented in Cognos Query. Then, due to the limitations of Query, in Apache Cocoon and later integrated in Cognos 8 (as xml data source).

Main Responsibilities create a generic workflow that from any xsp page can create a html/xls/xml output integrate WestLB look and feel (standard styles for web applications) retrieve processing data in a Cognos xml data source format and integrate it into the

main package

Package Documentation Tool

Project OverviewCustomer / Industry WestLB AG / BankPeriod 2004/01 - 2004/03Team Size 1Position DeveloperOperating system Windows XP / Sun Solaris 9/10Technology ReportNet, XSLT, Java 1.4, Xalan XML Parser

Project SummaryXSLT transformation sheets to extract all the reports and models from a deployment archive, commit and tag them into CVS and generate a summary html documentation for the whole package - reports list with all their queries, prompts, filters, author and other statistics.

Main Responsibilities create a xslt transformation sheet to extract the model and reports from a package scripts for cvs (source repository) interaction xslt sheets to extract and write to html the most important parts of reports undergo modifications so as to fit to Cognos 8 (initially developed for ReportNet)



JasperReports Engine with web front-end

Project OverviewCustomer / Industry WestLB AG / BankPeriod 2003/06 - 2003/12Team Size 1Position Developer, external ConsultantOperating system Windows XP / Sun Solaris 9/10Technology Java 1.4, Eclipse IDE, JDBC, Impromptu Web Reports

Project SummaryCustom, java/xml based solution, as replacement for Impromptu Web Reports, for standard reports and data extracts. The JasperReports Report Engine was generating pdf, xls and csv reports and the complex web application was responsible for managing reports output (save, email, print) and distribution (allow user, based on complex permissions, to download the reports.

Main Responsibilities Architecture and design of the entire Report Engine and web interface Implementation of most of the server components Integration of Jasperreports framework and several extensions migrate reports from Impromptu and later migrate reports to Cognos 8

Older java projects details in a separate file (LucianComanescu.profile.java.en.doc) or available on request.



Teaching and Training

Mar 2001 – Jul 2001, guest professor at University “Transylvania”, BrasovTopic „Distributed Applications Programming“Audience master programme, 6th yearHours/week 4Topics covered Java sockets / RMI, EJB, CORBA, (DCOM)

Sep 2000 – Feb 2001, University “Transylvania”, BrasovTopic „Programming with Java“Audience 3rd grade, IT DepartmentHours/week 2Topics covered Java, OOP, Networking, Threads, Streams, Swing,

JDBC, RMI, Applets, Servlets

1998 – 2001 Java related training inside the company, in English and RomanianWriting very didactical and visual training materials, together with creating examples and exercises designed to help trainers learn and teach Java quickly, and to help trainees gather, in a short time, all the necessary knowledge to program under Java.

The materials cover the following topics: Java basics (object oriented design, Java language, streams, applets, networking, threads, AWT), Java advanced (serialization, JFC-Swing, JDBC, RMI), JavaBeans, Enterprise JavaBeans, Servlets/JSP), CORBA for VisiBroker Java.

2004 – 2009 Cognos related training, in English and GermanWriting very simple and intuitive training materials, together with creating examples and exercises designed to help trainees learn quickly and reuse, in real life, the topics just learned.

The training covered the following topics: Cognos Query, Cognos Report Studio, PowerPlay Web basics and different project related topics.

1 · web view+49 69 95155585+49 176 32656755lucian@ lucian comanescu dwh/bi/cognos consultant...

Documents