Manager Data Warehouse

DANIELA JURCAU

*** ***** ****** **. ******** Hill Ontario L4S 2C2

Cell: 416-***-**** Home: 905-***-**** Email: *******@*****.***

Business Intelligence Reporting Data Warehouse

16+ years of IT experience including 9+ years of developing analytical and reporting solutions using Cognos Series 7 and Cognos Series 8 suite of tools. Experienced in system development life cycle including planning, analysis, design, development, testing, maintenance and support. In depth understanding of relational and multidimensional database concepts. Strong team player with excellent interpersonal and communication skills. Result oriented professional, recognized for taking initiative and resolving mission critical issues to ensure bottom line success.

TECHNICAL EXPERTISE

Reporting Tools

Cognos 8 suite of products (Report Studio, Event Studio, Query Studio, Analysis Studio, Transformer, Framework Manager), Cognos Access Manager, Cognos Script Editor, Cognos Impromptu/Impromptu Web Reports 7.0/6.0, PowerPlay Transformer 7.0/6.0, Upfront, Crystal Reports, Actuate Reporting

Databases

DB2, MS SQL Server, Informix, MS Access, Oracle, MS FoxPro

Programming Languages

Visual Basic, VBA

Data Modeling

Erwin Data Modeler

Software

TOADSoft, MS Office (Excel, Access, Word, Power Point), MS Visio

Operating Systems

Windows (all versions), UNIX, DOS

PROFFESSIONAL EXPERIENCE

SEARS CANADA INC. May 2009 to current

Consultant for Corporate Data Warehouse (contract position)

In charge with development and implementation of Business Intelligence web-based reporting solutions for Sears Home Central and Merchandising departments.Designed, developed, implemented, maintained and supported complex scorecard solutions for Sears Home Central using Cognos Series 8 suite of products based on dimensional models, including master-detail, crosstab and drill-through reportsImplemented and supported ETL scripts/processes for loading data into the Corporate Data Warehouse and complex SQL queries in DB2 on UNIX for building de-normalized data marts as per reporting requirementsDesigned and maintained logical/physical data models using Erwin Data Modeler for building relational and dimensional Cognos Framework Manager modelsExperienced in report and query performance tuning; proficient in writing complex DB2 SQL scripts to support and maintain the existing loading processes, reports and cubesDeveloped and published metadata models, both relational and dimensional, using Cognos Framework ManagerDesigned, developed, implemented and supported operational daily reports for Sears Merchandising using Cognos Impromptu 7.3Participated in the preliminary discussions for migrating existing Cognos reporting environment to MicroStrategy

Technical expertise: Report Studio, Analysis and Query Studio, Framework Manager, PowerPlay Transformer, SQL DB2 on UNIX, Erwin, TOADSoft, Cognos Impromptu 7.3

McDONALD’S RESTAURANTS OF CANADA LTD. May 2006 to Mar. 2009

Business Intelligence Reporting Analyst, Information Warehouse

Responsible for development and support of Business Intelligence web-based reporting solutions providing critical financial information to the decision making groups, environment maintenance and user training.Designed, developed and implemented dynamic reporting solutions for the Financial Department with multilingual capability using Cognos Series 8 suite of products (Report Studio, Event Studio, Transformer, Analysis Studio)

Daniela Jurcau Page 2 of 3

McDONALD’S RESTAURANTS OF CANADA LTD. – con’t

Business Intelligence Reporting Analyst, Information Warehouse May 2006 to Mar. 2009Developed and deployed scripts for automating the build process of reports and cubes using Cognos Script EditorImplemented scorecard reporting solutions with bursting capability using both distribution methods, by email addresses and by directory entries Developed, maintained and published metadata models using Cognos Framework Manager using DB2 on UNIX environmentParticipated in migration of existing Cognos Series 7 reports and cubes to Cognos Series 8 by analyzing current business processes, identifying gaps, recommending enhancement opportunities and developing flexible solutionsProvided functionality support for Cognos Series 7 and Series 8 related applications and effectively maintained security using Access ManagerConducted user training sessions on building their own ad-hoc requests using Cognos Query StudioDeveloped and published Reporting User Guides in Cognos Connection; trained users in standard reports and cubes useWorked closely with business users in gathering reporting requirements and preparing design specifications; coordinated data warehouse changes with ETL Team; created and executed test plans/scripts; supported the UAT process Participated in installation, configuration and testing of Cognos environment during the migration from Cognos Series 7 to Cognos Series 8

Technical expertise: Report Studio, Query Studio, Event Studio, Analysis Studio, Cognos 8 Transformer, Framework Manager, Cognos Access Manager, Cognos Script Editor, Cognos Impromptu/IWR, Upfront, Cognos ReportNet, DB2 on UNIX, TOAD

SEARS CANADA INC. Sep. 2000 to May 2006

Reporting Analyst, Home Central Data Warehouse Jan. 2002 to May 2006

In charge with design and implementation of Home Central Data Warehouse and development of business intelligence reporting solutions for product repairs and maintenance agreements.Designed, developed and deployed end-to-end reporting solutions for Home Central using Cognos Series 7 suite of products (Impromptu/IWR, PowerPlay Transformer), including cubes and crosstab, drill-through and master-detail reportsDeveloped Merchandise Reliability cube to analyze the failure rates of merchandise under warranty, using complex rolling capabilities, alternate drill downs and manual dimensionsDeveloped Warranty Sales cube with statistical analysis for merchandise sold versus maintenance agreements soldDeveloped operational daily reports for Service Incidents Tracking and Charges, Maintenance Agreements Tracking and Cycle Time with prompts and conditional formattingDeveloped summary drill-through monthly and year-end reports for Top 20 Parts Used Inventory and Top 20 Appliances RepairDeveloped complex DB2 SQL queries, views and stored procedures to support and maintain existing reports and cubesParticipated in architecture, design, modeling and ETL process for Home Central Data Warehouse in order to ensure data availability for required business intelligence solutionsDeveloped and maintained Home Central data models using Erwin modeling tool

Technical expertise: Cognos Impromptu/Impromptu Web Reports, PowerPlay Transformer, SQL, DB2 on UNIX, Erwin

Programmer Analyst, Parts Warehouse and Replenishment System Sep. 2000 to Jan. 2002

Responsible for maintenance and support of Vantive application for parts warehouse and replenishment system.Participated in gathering, refining and translating business requirements into functional specificationsMaintained and supported Vantive system by developing Informix stored procedures and VBA scripts based on user requirementsParticipated in Actuate Reporting system upgrade to support XP client workstations facilitating uninterrupted system access and complying with Corporate workstation standards

Technical expertise: VBA scripting, Informix, Actuate Reporting, Vantive Inventory System, Excel, MS Word, MS Visio

Daniela Jurcau Page 3 of 3

CIBC COMERCIAL IMPERIAL BANK OF CANADA May 1998 to Sep. 2000

System Developer, Data Warehouse Build Team Apr. 2000 to Sep. 2000

Responsible for operational support of extracts processes for financial cube generation, in charge of developing data extracts scripts.Provided operational support of batch processes for data extracts and downloads from mainframe into Client Server environment including cube generation processSupported and maintained the batch schedules for data extracts using Sys*AdmiralDeveloped, deployed and maintained new processes for data extraction (UNIX scripting, Oracle and Sybase stored procedures)Participated in testing of downloads from mainframe, loads into databases and cube generation for new projects (SQL-Programmer, Visual Basic, Access)

Technical expertise: Sys*Admiral, UNIX Scripting, Oracle and Sybase stored procedures, Visual Basic, Access, SQL-Programmer

System Developer, Technology Asset Management May 1998 to Apr. 2000

Responsible for the development and support of Reporting System providing financial accounting reports, in charge of supporting the production month-end process.Designed, developed, implemented and supported a Reporting System using Visual Basic 6.0/5.0, Crystal Reports, Informix, Oracle, Access and SQL Server to provide financial accounting reportsDeveloped, maintained and supported production month-end system using Informix-4GL programming language on UNIX platform according to the clients’ ongoing inventory management requirements

Technical expertise: Visual Basic, Crystal Reports, Informix, Oracle, Access, SQL Server, Informix-4GL on UNIX

UBI Soft Romania (branch of UBI Soft Entertainment France)

Consultant (contract position) Feb. 1996 to Mar.1997

Designed, developed and implemented new Human Resources application, support and maintenance of Payroll system.

Technical expertise: MS Access, Visual Basic, Crystal Reports, FoxPro

CITY HALL of BUCHAREST, ROMANIA

Programmer Analyst Oct.1993 to Mar. 1997

Developed database applications for the Town Planning and Human Resources/Payroll departments.

Technical expertise: MS Access, Visual Basic

EDUCATION

Degrees and Certifications:

Cognos Series 8 – Cognos 8 BI: Authoring Professional Reports

2008

Cognos Series 7 – Transformer OLAP Modeling, PowerPlay Report Building and Data Exploration for Client

2006

Oracle for UNIX Developers

1994

University Degree, Polytechnic University of Bucharest, Romania, Faculty of Electrotechnic

1993

Additional courses:

Business Effective Writing (2 days)

2005

UNIX scripting (5 days)

2004

References available upon request

Contact this candidate