Dan Popescu

*** – **** Bathurst Street 647-***-****

Toronto, ON, M3H 6C7 abqhlg@r.postjobfree.com

Summary of QualificationsExperienced MIS Analyst/ Business Intelligence Analyst and Reports Developer with over fifteen years of experience in delivering high quality analysis and reports from the user requirements stage up to production implementation; using a variety of tools: Cognos Report Net, WEBI, SAP Business Objects, Crystal Reports, OBIEE BI Publisher, MS Access, Excel (Macros/Pivot Tables/Graphs)Expertise in both front and back-end development using Oracle, XML, XDL, XSD version 1.1, HTML. Modeller and developer for multiple corporate data warehousing projects spanning across major departments in the financial industry, including TD Securities, CIBC, Amex, BMO, Merrill Lynch, RBC)Unique and advanced BI development skills and a thorough understanding of the warehouse development life cycleResponsible and likeable with well developed verbal and written communication skills in a business environment; English and FrenchExtremely well organized and good time management skillsVery strong analytical and accounting/financial skills; very oriented to details

Skills and Experience

Areas of Knowledge

Business Intelligence Reporting Tools

Cognos ReportNet, BRIO, Crystal Reports, SAP Business Objects XI, Oracle Business Intelligence Publisher, Siebel, Excel (Macros/Pivot Tables, Graphs), MS Access

Databases

DB2, Oracle, SQL Server

Operating Systems

Windows XP and prior, UNIX, AS400, Novell

ERP: SAP, IFS, Adage

CRM: Siebel Analytics, Siebel CRM Public Sector

Design/CASE Tools

Visio

Methodologies

Kimball Dimensional Warehouse

Modelling Methods

FrameWork Manager, ERWIN, UML

Industries

Petrochemical Materials Maintenance Construction Engineering Finance HR, Investments, Finance, Transportation and Logistics, Manufacturing, Food processing

Real Estate, Government

Report/BI Development

Responsibilities: Designed BI solutions to represent key business data, develop and support guided analysis and provide options and tools for managing business data.Training and practical experience with reporting tools including: Cognos ReportNet, BRIO, Crystal Reports and MS Access, MS Excel Pivot Tables and GraphsExperience with modeling complex metadata using Framework Manager including star schema model, predefined prompts and filters and intuitive Presentation of Database Business Layer designDesigned and developed a wide variety of reports for many departments and C-level management including drill sheets, summary and transaction detail with dynamic JavaScript prompting, conditional formatting and bidirectional hierarchical navigationProduced data mapping; correlated the DB2 IW warehouse database with the Daily, Hourly and PMIX reports specification; designed, SQL(s) and reports using ReportNet, IBM DB2 Client, Siebel Analytics and MS Excel and Access.

BI Business and Data Analysis

Responsibilities: Through conversation with management and business users, identified and translated functional requirements into specifications to guide report design, development, presentation and trainingWorked alongside business managers to design and create functional reporting strategies and delivery methods such as scheduled burst reportsDesigned and produced comprehensive specifications for technical designsInvolved with user acceptance iterations and facilitation of real-time online feedback capabilities to enhance the user experience

Work History

04/12-09/12 Business Data/Reporting Analyst

Minto Communities Inc., Toronto, Ontario

Worked alongside business managers to design and create functional reporting strategies and delivery methods.Reviewed the legacy system data; analyzed the current Prolog, Navision and CLS databases and produced SQL and PL/SQL discrepancies reports, identified the source master data needed to be cleaned for future migration to SAP/R3 using SBO Data Services; suggested data conversion approach strategy; provided GAP analysis; generated MS Excel Pivot Tables summary reports and graphs for the objects to be migratedIdentified the SAP target field and produced data mapping; reviewed the SM and PS modules; analyzed the related data objects and requirements within the SDLCOrganized meetings and presentations for stake holders in order to decide the business rules for data migration; updated the related documentation

01/12-03/12 Business Data /Reporting Analyst

Ministry Of Community and Social Services, Toronto, Ontario

Designed and developed a wide variety of reports for many departments and C-level management including drill sheets, summary and transaction detail with dynamic prompting and conditional formatting.Reviewed the reporting design specifications and business requirements for the Ministry letters and forms; and designed the French templates Generated the translation XML/XDL/XSD version 1.1 corresponding files using OBIEE - Oracle BI Publisher; mapped and modified the report functions for French translation Registered the translation files into Siebel application and associated each template with the required view in Siebel; unit tested the templates and generated the PDF letters and forms; produced record of test results and documented in SharePoint; provided support to the related project streams such as FCMS extracts and reports; designed MS Access interface to import CSV and Excel client payment information files using SQL statements and procedures; used VBA and macros for data manipulation

03/09-12/11 Business Data /Reporting Analyst

Toronto Transit Commission, Toronto, Ontario

Designed BI solutions to represent key business data, develop and support guided analysis and provide options and tools for managing business data.

Reviewed the reporting specification of the new IFS ERP/Oracle application for the Purchasing, Inventory and Stores process in order to replace the old MMS system based on SQL Server; produced data analysis, data testing and mapping for the new IFS business process; provided estimates for the reports migration; resolved the issues from the deficiency list and notified the testers for retest and Issue Log updatesAnalyzed the current end user BOE Crystal Reports; and evaluated them against IFS reporting capabilities; developed new Cognos 8.4.1/10.1 ReportNet reports, Report Studio, Query Studio; tested the reports and used XML for reports comparison; developed metadata models using FrameWork manager and generated reports with Report StudioStudied the opportunity to replace the reports in use by creating new and more meaningful IFS queries and reports using the PL/SQL in Oracle production database

12/08-03/09 Business System Analyst – Reporting/Tester Siebel Analytics

GlaxoSmithKline, Mississauga, Ontario

Involved with user acceptance iterations and facilitation of real-time online feedback capabilities to enhance the user experience

Reviewed the business requirements for world wide Siebel 7.8 and Siebel Analytics 7.0 roll out; analyzed the current Siebel Interface; and executed regression and integration tests using Mercury for OLAP and OLTPWrote the test cases for Analytics for the necessary change requests, standard and ad hoc reports; used PL/SQL to verify the data within Oracle Data Warehouse database; recorded the errors in QCProvided input for reporting subject areas; designed reports and validated the results; designed testing strategy plan diagrams; participated in international status meetings; performed reports testing for export to MS Excel

04/08-12/08 System/Business Analyst – Business Intelligence Reporting

Hain Celestial Canada, Toronto, Ontario

Analyzed the current process feed from ADAGE ERP to ORACLE and SQL Server; produced system architecture flow charts, reports development estimates and documentationGathered the user requirements, designed SQL and PL/SQL queries and reports to validate the data accuracy using Business Objects 5.1; data testing and migration from version 5.1 to release XI3 for WEBI reports; into the Business Object server in USA; generated GAP analysis for the new reporting process; published reports metrics and score cards on the BO DashboardReconciled the GL:M and sub-ledger accounts in regards of sales amounts and client information; documented the reconciliation process using Excel

10/07-04/08 Treasury Business Data/Reporting Analyst

CIBC World Markets - TBM Treasury Middle Office, Toronto, Ontario

Analyzed the current process feed from OPTEX/Sybase to GL:M Gathered the user requirements, designed queries and reports to validate and test the data accuracy using Crystal Reports, Cognos 8.4.1/10.1 ReportNet Report Studio, Query Studio, FrameWork Manager, SQL and MS Access; verified the OPTEX transactions information; created user interfaces for reports automation ; data testing and manipulation using MS Access and Excel macros; updated the data/metadata dictionaries; produced MS Excel flow diagrams and related AF and FX risk documentationReconciled the GL:M balance sheet and sub-ledger accounts in regards of the trades amounts entries; documented the reconciliation process

02/07-08/07 Business System Data/Reporting Analyst

PriceWaterhouseCoopers Management Services LP, Toronto, Ontario

Analyzed the current interfaces for migration from Oracle/ PeopleSoft to SQL Server/iPOWER and data marts for HR and WLM using SQL Server Management Studio 2005 and TOAD; designed queries and reports to validate the data/metadata accuracy using SQL, MS Access/Excel, Reporting Services and MS Visual Studio; analyzed the XML data feed files; tested the BizTalk Server 2006 integration layer compared with SSIS; analyzed the DTS

packages; produced data mapping; tested and validated the business rules; updated the Lotus Notes databaseGenerated and updated the Issue Log for the PeopleSoft interface integration Reviewed the current process feeds from PeopleSoft staff information and AMEX to Profit application and compared with the new requirements

11/06-02/07 Data/Reporting Analyst

BMO Nesbitt Burns – IBG/Capital Markets, Toronto, Ontario

Analyzed the CODA GL system process flow ; produced DTS packages to import CODA reports into SQL Server 2000; designed queries to validate and test data for the P&L and Trial Balance amounts for various companies, reconcile the results within MS Excel files based on Pivot Tables summaryUpdated the Hyperion Enterprise data reports for the fiscal year 2007; compared the result with the SAS reports Reviewed the process feeds documentation and provide suggestions for performance improvement; administered the IBG PVCS site

10/06-10/06 Risk Loss Prevention/Reporting Support Analyst

Shoppers Drugmart. Toronto, Ontario

Analyzed the Loss Prevention application architecture and process flow and current data mapping; generated queries for data testing validate the fields and metadataUpdated the SharePoint directories with the LPA related documentsReviewed the Remedy ViaTIL LPA incidents to establish the root cause for the reporting errors and documented the common issues and resolutions

09/04-10/06 Business Data Quality/Business Intelligence Reporting Analyst

McDonald’s Restaurants Of Canada Ltd., Toronto, Ontario

Produced data mapping; correlated the DB2 IW warehouse database

with the Daily, Hourly and PMIX reports specification; designed SQL(s)

and BI reports using Cognos 8.4.1/10.1 ReportNet Report Studio, Query Studio, IBM DB2 Client, Siebel Analytics and MS Access; generated, database and business view models in FrameWork manager metadata; developed ad hoc reports using Report Studio; analyzed ERWIN and UML models; verified the Hyperion Essbase data feeds for the reportsExecuted unit and regression data tests; recorded, analyzed and fix the errors within reports and Transformer Cubes; verified them before deployment ; performed data analysis with Analysis Studio

Evaluated the Informatica 8/9/9.5 Power Centre ETL tool; Examined the DataStage Director for the ETL job status and performanceGenerated Data Warehouse stores sales information reports using ProfileStage for all Canadian stores; Conducted presentations and group training sessions for the reporting process

01/04-09/04 Business System/Database/Reporting Analyst

Ministry Of The Attorney General, Central West Division, Ontario

Gathered the user requirements for the province wide roll-out/conversion from Q & A and MS Access 97 database to MS Access 2000 and Oracle Produced data mapping; correlated the old fields and data types with new database fields/structure and functionality; designed and run ad hoc queries

and reports; performed data testing and cleansing for five lines of business: family, criminal, civil, divisional and small claims; produced documentation Executed unit and regression tests; recorded, analyzed and fix the errors Conducted presentations and group training sessions for TOTS database

11/03-12/03 HRMS and Survey Database/Business Reporting Analyst

KPMG Inc. – Technology and Knowledge Management, Toronto, Ontario

Gathered the user requirements and analyzed the Excel data files extracted from HRMS database and assurance, re-assurance, finance, tax CSV files from the Survey application, stored in SQL Server 2000Run ad-hoc SQL statements; performed data testing and cleansing and validationAutomated the data files import from Excel to Access 2000 tables; developed

the necessary working/user interfaces and requested customer/firms information reports, according with the business case; performed unit testing, documented the process flow and trained the end usersPerformed GAP and statistical analysis; produced the reports design documentation; analyzed the reports design using Crystal Reports

08/03-09/03 Business Database/Reporting Analyst

CIBC - Edulinx Canada and Hudson’s Bay Company, Toronto, Ontario

Reviewed use cases and gathered the user requirements for Student Loan Origination departmentAnalyzed the Work Flow SQL Server database/tables and produced the student information and loan status reports, using Enterprise Crystal Reports 8.5, MS Access and MS Excel; compared the result with the SAS ReportsMigrated Project Management Office reports data from MS Excel to SQL Server 2000 and MS Access; designed the requested user interfaces; developed the new PMO reports, tested and documented the process

02/03-07/03 Data/Marketing Reporting Analyst – Customers and Business Intelligence

Direct Energy, Toronto, Ontario

Analyzed the current Ontario/Manitoba Electricity and Gas SQL Server tables from the warehouse database; run ad-hoc SQL(s) against Data Warehouse using query analyzer Gathered the user requirements; generated custom queries and performed data cleansing; designed Brio/Access/Excel weekly customers account information and OLAP reports; used ETL/DTS for data manipulationProduced data mapping; correlated the price and postal codes extract, with the postal codes from Canada Post addresses naming convention and commercial and residential standard price table; designed flow diagramsMaintained the SQL/MS Access Do Not Contact database/listDownloaded the weekly incremental UAT energy extracts from Peace Energy Oracle database, using FTP/UNIX commands; produced customers’ list requests for various marketing campaigns: door to door, direct mail, etc.

01/03-02/03 Data Tester/Reporting Analyst

Hudson’s Bay Company, Toronto, Ontario

Analyzed and the current financial and inventory reports for Bay, Zellers and Home Outfitters storesGathered the user requirements; generated custom queries and performed data testing and cleansing; designed Crystal/Access/Excel monthly comparison, shrink and overages reports using VB/VBA; tested and modified Excel/Access macros; analyzed the GL book values against the physical resultsProduced data mapping; correlated the department, category, and store number for North America Bay company

10/02-12/02 SAP/R2/R3 –Business Data/Database/Reporting Analyst

DUPONT CANADA INC./CSC – Mississauga, Ontario

ETL/imported the material master and warehouse data by businesses,

plant and storage location, into MS Access 2000Gathered the user requirements; generated custom queries and performed data cleansing; designed Access/Excel comparison and performance reports, using VBA, between Keystone, data feed application and SAP/R2; Produced data mapping; correlated the material code, base units of measure, divisions and product hierarchy from SAP/R2 files against SAP/R3 system

01/02-07/02 SAP/R3 - Database/Reporting Analyst

OSRAM – SYLVANIA, Mississauga, Ontario

Analyzed and the current inventory text files downloaded from SAP; gathered the user requirements; imported the data into MS Access 2000Designed and automated the marketing, retail, financial, GL balance and PPV reportsDeveloped the accompanying user working screens using Visual Basic Produced data testing, modeling, documentation, testing and performed users training to confirm that the new application meets the requirementsDesigned and generated ad-hoc queries, VB code for budget – forecast MS Access/Excel reportsBuilt the MS Access user/working graphical interface, for updates and print and e-mail reports

1/01-12/01 Database/Reporting Analyst

Canadian Arthritis Network, Toronto, Ontario

Gathered the user requirements for the MS Access 2000, network, members and non-members marketing databaseAnalyzed and recorded inventory software licenses and OS information Designed the necessary user interface, reports and automated the reporting process using VB and VBA Excel macros; kept track of the project using MS Project 2000Produced data modeling, documentation and testing; performed users training to confirm that the new application meets the requirements

10/01-11/01 System/Database Analyst

Royal Bank Investments, Toronto, Ontario

Gathered the user requirements for the MS Access – Message Net investment

database functionality; conducted meetings with the business unitsReviewed the VBA code/macros and the interface/report design Analyzed and documented the current system; produced ad-hoc reportsPerformed the necessary ETL, data feeds tests to confirm that the application meets the requirements for the Reorganization DepartmentAnalyzed and documented other financial and securities databases

08/01-09/01 Database Analyst

The Toronto Board of Trade, Toronto, Ontario

Analyzed the survey database and compared with the records from the

electronic surveys; run specific SQL statements to determine the errors;

downloaded a new database after remediation; performed the necessary ETLProduced MS Access 2000/Excel discrepancy and statistical reports, in order to be correctedLiaison between developers and survey analysts; generated business case specifications; developed GAP analysis and project planningRecorded all the issues and produced documentations

06/01-07/01 Database/Reporting Analyst

Royal LePage Relocation Services, Toronto, Ontario

Configured and installed the ODBC driver, in order to connect with SQL database, running on NT server, for tables analysis and designAnalyzed the financial data/tables and compared with the records from the Tool Kit, real estate application; performed the necessary testsGenerated, general ledger, invoice information, retail and property management reports using MS Access or MS Excel 2000 and Crystal Reports, for clients, such as: Petro-Canada, Molson, CIBC, Bombardier, Hudson Bay, etcProduced user interfaces and automated the financial reports using VB

12/00-06/01 Database Programmer Analyst

Merrill Lynch HSBC, Toronto, Ontario

Created and configured the ODBC for Client Access Express, in order to connect with AS/Trade warehouse database, running on AS/400 for ETLAnalyzed the data model/structure from DBII/AS/Trade database, in respect of accounts type, GL balance and other banking informationProduced referrals, marketing and financial (accounts type inventory, investments and mutual fund) reports, using Seagate Crystal Reports Used SQL Designer, MS Access and MS Excel to develop the necessary user’s interfaces; generated Crystal software licenses inventory reports

11/99-12/00 IT Analyst

MSAS Global Logistics, Toronto, Ontario

Designed the corresponding MS Access databases for the Toronto, Montreal and Vancouver stations and the accompanying interfaces, using VB/VBACreated ODBC’s and DSN files to connect with SQL Server from USA, in order to ETL/ import data information, used in MS Access database designGathered the user requirements; produced marketing and accounting reportsAnalyzed the accounts payables files, from MSR application under UNIX and AS/400 for Toronto, Montreal and Vancouver officesMigrated all the accounts payables/receivable data files, using Reflection FTP for UNIX to MS Access/Windows NT; installed Cognos Transformer and PowerPlay for cubes for deployment and testing; produced OLAP reports for comparison and reports testing

11/99-11/99 IT Analyst

Casino Rama, Rama, OntarioAnalyzed the Budget System written in MS Excel and MS Access, in order to improve the reporting speed and the links updatingTested the budget files and changed the default settings; gathered users information; developed the specification of requirementsProduced reports and made suggestions, for increase the calculations speed and for the necessary system upgradesAnalyzed some Novell 4.x network issues such as: disk space restrictions and disk compressionProvided overview documentation for system upgrades and software tools, helping to ensure model correctness

05/98-07/99 IT Analyst

Toronto Dominion Securities, Toronto, Ontario

Scanned and analyzed all customers’ Excel and Lotus files in order to be

Y2K compatible, using On Mark Year 2000, softwareProduced summary reports, after the scanning process, using Excel/Access Made hardware and software licenses inventory for business units, used in NT roll out processInstalled, tested and evaluated the repair tools; negotiated software’s price with vendorsSearched the VBA code and made 20000 Excel macros written in VBA, Y2K compliant; analyzed the data feed applications, Bloomberg/StarlinkPlanned, coordinated and distributed to the team, the files to be fixedConverted Excel 95 files to Excel 97 version, Lotus 1-2-3 to Excel 97 and Visual FoxPro files Tested the TD Web Server and recorded the performanceWrote small Java applets and modified the code for the Macro schedulerSupported customers and Treasury Trade Floor, for Y2K readiness and Lotus Notes in terms of using and exchanging files criticality; edited Lotus Notes Y2K databaseEnsured that Y2K test plans are prepared, delivered, executed and the spreadsheets functionality meets agreed requirements

Made contingency planning for business units and spreadsheets applications

09/97-04/98 Data Access, Pre-Deployment Logistics and Project Management

Bell Mobility, Toronto, Ontario

Changed the business databases, using MS Access in order to upgrade the Operating System from Windows 3.1 to Windows 95 and Windows NTSolved users problems regarding this migration; software and hardware

troubleshooting and data testing Insured database accuracy in terms of applications, mappings and assetsAssisted and supported the migration process; produced extensive reports using Excel and links within Bell to other Word-based applicationsScheduled customers for conversion; solved system’s problems and supported Outlook and Lotus Notes applicationsProduced weekly status reports for the supervisor; updated the project plan

Project 27 03/97-07/97 System Support Technician

Word N Systems, Toronto, Ontario

Used Colorado Backup Software for backing up files from system onto backup tapes; generated MS Access reports according with the customer’s requirements documentationInstalled software and upgraded systems such as memory and scannersPhone support for clients regarding projects, software and hardwareExposure to Sybase and PowerBuilder; participated to UNIX system operations; within AMOCO Oil and Gas Company- Calgary, for UPS modification; produced status upgrades reports for the supervisor

Project 28 09/85-06/95 Supervisor, Tests Production

Oil and Gas Company, Craiova, Romania

Coordinated tests production activitiesSupervised wells stimulation to maximize oil and gas production Negotiated contracts, with the Drilling and others services companiesConducted interviews for the hiring processLiaison with the overseas companies in the cooperation and production process

Education

Formal Education

1980-1985 Between Bachelor and Master of Science-Petroleum – Accredited by University of Toronto

Institute of Oil and Gas Engineering, Ploiesti, Romania

Professional Training

03/08-03/08 Introduction to Crystal Reports 9 – Reports Development

CIBIC, Toronto, Ontario

11/06-11/16 Reliability Status Security Clearance

2006 Siebel Analytics - Reporting

HAVIGS Global, Toronto, Ontario2005

2005 Cognos ReportNet Authoring

Cognos Incorporated, Toronto, Ontario

1999 Web Development Course / Visual J++

Toronto Dominion Securities, Toronto, Ontario

1996-1997 Computer Support Specialist – Honours Diploma

The Toronto School of Business, Toronto, Ontario

1997 Year 2000 Technician Course

Swansea Computer Specialists Ltd., Toronto, Ontario

1995 Certificate in Career Planning and WordPerfect

Center for Advancement in Work and Living, Toronto, Ontario

1994 Course in Verification and Discount of Petroleum Investment Work

Petroleum Research Institute, Campina, Romania

Contact this candidate