MICHAEL H. TOPEL

** ********* ******* ********, *** York 10546

914-***-**** ac85ew@r.postjobfree.com

PROFILE

Business Intelligence professional with proven record of implementing large scale BI implementations, both on time and within budget for mid-market and Fortune 500 corporations. Possessing a strong combination of technical, analytical and management skills with the ability to apply those strengths to manage and implement BI projects. Skilled at working with all tiers of client management and user groups to insure project success at all phases of implementations.

CORE COMPETENCIES

BI Implementation and Integration

Data Architecture

Project Leadership, Staff Mentoring

Client Training

SAP Data Services (BODS) ETL processing - net change and continuously fed (CDC) methodologies

ORACLE - PL SQL and CDC (synchronous and asynchronous) data replication

Experience with SAP HANA, Teradata

Hit Software – DBMoto Data Replication, Attunity iSeries DB2-CDC

Microsoft – SQL Replication, SQL CDC, VBA, Access and Excel

Areas of expertise – Sales, Inventory, General Ledger, Human Resources, and Real Estate

PROFESSIONAL EXPERIENCE

Magnitude Software March 2002 to Present

Business Intelligence Program Manager

Accomplishments of Note

oManage SAP CFIN initiative – Facilitates loading of SAP ECC, EBS and external Data Sources to SAP CFIN environment.

oMerged multiple release versions of Peoplesoft HR related data from multiple instances into a single coalesced reporting environment in a manner to facilitate reporting and distribution requirements for one of nation’s top three Automobile manufacturers.

oConceptualized and implemented SAP Business Objects Data Services ETL to capture slowly changing dimension information from Change Data Capture (CDC) source files eliminating the requirement of full table comparisons.

oConceptualized and implemented ETL to support Fact Summary tables by utilizing CDC source tables eliminating costly database and reporting processes.

oConceptualized and implemented SQL processing to allocate inventory costs to Manufacturer’s Open Orders based on individual Item Bill of Materials.

oDesigned and implemented process to update dimensional attributes which are dependent on secondary table changes via post update CDC processes.

oEmployed advanced Oracle techniques (Logical Columns, Star Query Transform) to aid in the upgrade of a product release for a major Multi-tier US Marketing firm which resulted in lower overall costs and development time.

Responsibilities

oAccountable for building and maintaining client relationships by meeting with appropriate client C level and management personnel.

oResponsible for Identifying and implementing services opportunities with installed client base

oParticipate in Pre-Sales meetings with potential clients

oDesign, code, and implement ETL processes to perform Inter/Intra system data movement both in batch, net change and continuously fed (CDC) BI environments.

oDesign and deploy validation jobs and procedures to ensure data integrity across systems.

oParticipate in the design and implementation of Business Objects Universes over custom Data Marts.

Lend Lease REI, New York, NY Sept 1995 to Sept 2001

Business Analyst, NY

oParticipated in an Enterprise project which was created to provide consistent data availability across multiple operating divisions by implementing an Oracle General Ledger/Data Warehouse solution.

oMerged legacy corporate data into an existing MS Access application to enhance Portfolio and Property performance reporting.

Boston Financial [Mar 1999 – Jan 2000, acquired by Lend Lease REI]

Business Analyst, NY

oSupported an existing network environment encompassing both NetWare and NT operating systems.

oManaged a project for the migration of an IBM midrange Real Estate reporting system to an MRI Real Estate software package utilizing MS SQL.

oParticipated in hardware and software product analysis for Y2K compliance.

Schroder Real Estate Associates [Sept 1995 - Mar 1999, acquired by Boston Financial]

Senior Programmer/Analyst

oIntegrated IBM S/36 and AS400 General Ledger data into a Microsoft Access front end utilizing, DDM, ODBC, and MS Access VBA.

oMaintained and enhanced a proprietary Real Estate Leasing and General Ledger system while insuring data and program consistency with eight remote sites.

oDesigned custom MS Outlook forms for task entry and distribution.

AUDIO VISUAL WORKSHOP, New York, NY 1993 - 1995

IT Manager

oDesigned and implemented an Order Entry and reporting system incorporating all facets of sales and rental of inventory items for over thirty users.

oDeveloped specifications for producing management level income projections and related financial reports.

oProduced a Product Catalog utilizing various PC scanning, and desktop publishing packages.

INTERACTIVE BUSINESS SYSTEMS, New York, NY 1984 - 1993

Systems Analyst

oEvaluated manual systems and created specifications to facilitate their migration to automated systems.

oDeveloped various custom distribution and point of sales software solutions for a variety of clients utilizing AS/400 COBOL, RPG400, IBM S/36 BASIC and RPG II languages together with system utilities.

oIntegrated IBM DMAS/MAPICS data with custom reporting processes to produce consolidated reports.

NEW YORK HEALTH & RACQUET CLUB, New York, NY 1979 - 1984

IT Manager

oDesigned and implemented solutions for a Health Club membership tracking and financial system.

oSupervised data processing personnel and implemented auditing standards to enhance data integrity.

oActed as a liaison with accounting department to compile system specifications.

oConducted training sessions for computer and operational personnel.

Staff Accountant

oReconciled daily cash collection and monthly bank statements.

oManaged ADP automated payroll for four hundred employees.

EDUCATION

Pace University, Pleasantville, New York

BBA Public Accounting - September 1979

Contact this candidate