Data Management

Ash Mann, B. Eng.

● ** Laurelcrest Street, Brampton, Ontario, L6S 5W3, Canada ● 647-***-**** ● ******@*****.***

Candidate Profile

A proven performer combining strong business acumen with exceptional technical abilities. Analyst of complex databases, systems and processes, with the ability to learn fast and implement change in manageable steps. Proficient at translating complex business needs into concise, tangible requirements. Adept at developing processes and policies that utilize technology to support people in working efficiently. Expert data modeler and architect, specializing in complex data transformation for a range of applications including star schemas, dimensional modeling, data conversion and data migration.

Technical Expertise

Databases – Oracle, SQL Server, MS Access and MySQL Database Tools – Quest TOAD, SQL Loader, SQL Plus, Oracle SQL Developer, ERWIN, PowerdesignerProcess/Flow Mapping - Visio, Enterprise Architect (UML)Programming –SQL, PL/SQL, C++, UML, XML, VBA (Excel/Access Macros), JavaScriptInternet/Web Technologies – SSL, SEO, Payment Systems, Dynamic Content (PHP, ASP), Content Management Systems (CMS), Web Query Language/Web Scraping, FTP, IIS, Apache UI Modeling & Development Tools - Caretta GUI studio, HTML and Adobe CS Suite CAD/CAM/CAE – AutoCAD, Inventor, UG NXProject Management Tools - MS Project, Primavera, SharePoint, RPM Operating Systems – Windows, DOS, UNIX, MacOSGIS Tools – MapPoint, MapInfo, Google Maps, ESRIETL – Datastage, Informatica, SSISBI Tools – OBIEE, Cognos, Crystal Reports, Business Objects, SSRSERP – SAP, Oracle E-Business Suite, Oracle JD Edwards Enterprise OneApplication Customization – e.g. Oracle Self-Service & Java Forms PersonalizationBusiness Intelligence - DMR, OLAP, ROLAP, MOLAP, MIS, CPM, Data Warehouse and Data Mart Design – Star Schemas, Dimensional Modeling & Design (Kimball/hybrid)Data Migration / Conversion – Design/Plan/Build using ETL, Open Interfaces, APIs and Custom Scripts (Dataloader, SQL)Data Validation & Testing – Customized Front End and Database-Level Validation Processes & Scripts

Professional Expertise

Interpersonal Communication, Leadership and TeambuildingIdentifying, Gathering, Documenting, and Managing Business/System Requirements (BRD, SRS)Re-Engineering Processes to Eliminate Bottlenecks & Increase Efficiency (Lean/6 Sigma/ Root Cause Analysis)Formulating Key Performance Indicators (KPI’s) & Identifying Base Metrics for measuring Departmental/Project/Corporate Performance (Balanced Scorecard approach)Experienced in Agile, RUP, SDLC, Oracle AIM and other MethodologiesFacilitating Team Meetings, Presentations and Brainstorming SessionsSelecting, Coordinating and Managing Cross-functional Teams for Complex ProjectsManaging Multiple Projects concurrently in Challenging EnvironmentsDeveloping Project Plans with Tangible Goals, Deliverables, Timelines and BudgetsDefining Program Management Office (PMO) design including Charter, Metrics, Templates, Procedures and PoliciesCommunicating with Stakeholders, Team Members and Senior Management through all phases of a projectCreating Use Cases, Test Cases, Test Scripts to support application testing

Professional Experience

Baxter Healthcare Corporation

2010-Present

Senior Technical Consultant / DW Architect - Healthcare Analytics

Developed detailed technical and functional specifications for BI platform to be used across Canada, USA and Latin America (LATAM).Built conceptual BI architecture for a Cognos layer on top of existing EDW and JD Edwards ERP.Developed Extract, Transform & Load (ETL) procedures in PL-SQL to pull data from disparate sources.Designed the new Data Warehouse required to support reporting and analysis needs for the entire LATAM region, based on the Kimball approach. Created star schemas and dimensional models along with all required data mapping.Defined new KPI's to measure operational performance related to management of home patients (adopted as new global standard)Conducted regular audits to identify data quality and integrity issues.Aided in development of Master Data Management (MDM) strategy.Developed a fully-functional, complete pilot Cognos reporting application covering Canada - including all ETL, database management, Framework Manager, Report Studio, Metric Studio, Event Studio, Analysis Studio work.Spearheaded the development and implementation of regional (LATAM + Canada) BI tool, in conjunction with external vendor.Created advanced PL-SQL procedures for ETL, data auditing and validation.Designed new operational reports and created specifications for executive dashboards.Shared knowledge with colleagues from other parts for the world (LATAM, APAC, Europe).Designed the security layer for the new application to control access to sensitive data by role and responsibility.

Technical: Cognos 8.4 & 10.1, Oracle 11g, Oracle 10g, TOAD, SQL Developer, Sybase PowerDesigner, ERWIN, MS Project, JD Edwards 7 & 8 ERP, Peoplesoft, IBM Datastage, Oracle BI Publisher, SSIS, Apache, SalesForce

Countries: Canada, USA, Mexico, Brazil, Chile, Guatemala, Columbia, Ecuador

Consulting Partners: IBM, Deloitte, WIPRO, Kaxan (Mexico)

National Express Corporation

2007-2010

Project Lead - Business Intelligence & Balanced Scorecard

Partnered with capability SME's and senior management representatives to lead the creation of a new BI capability.Identified 120 key performance indicators across 22 business capabilities during business transformation project.Developed a complete balanced scorecard for the entire organization, tying base metrics to capability KPI's and corporate KPI's.Designed executive dashboards for all parts of the business - HR, Operations, Asset Management, Finance, Sales, Marketing.Defined the requirements for future BI needs and led technical BI team through the system selection phase.Built conceptual BI architecture for an OBIEE environment on top of Oracle EBS R12 ERP.Designed data interfaces to share data with corporate financial tool (Hyperion) and legacy applications.Mapped scorecard metrics to data fields in Oracle EBS backend tables for dimensional modeling (Kimball).Created proof-of-concept sample dashboards using Business Objects, Cognos and Tableau.Conducted data quality audits to determine reliability of data and data cleansing requirements.Planned the design and implementation of the new Corporate Data Warehouse and Oracle BI Applications.

Project Lead - Data Migration

Led the migration of data from legacy ERP and different operational systems into Oracle E-Business Suite R12.Created detailed project plans outlining each step of a multi-phase, multi-stage, multi-site data migration effort.Developed architectural plans detailing the movement of data across different interfaces out of legacy systems and into Oracle EBS.Mapped all future-state data fields to existing legacy data.Designed "smart" data collection templates to collect and validate data not available in any legacy application.Conducted data quality studies to determine data cleansing requirements.Planned the migration process for moving asset-management and maintenance data for 18,000 vehicles spread across 50+ sites in the US and Canada.Conducted regular audits of data to ensure accuracy of financial data and asset information.Facilitated meetings with key executive and operational stakeholders to discuss project status and data issues.Created data migration procedures utilizing automated data interfaces (Oracle Open Interface, API's)Built customized data-entry macro scripts to automate data entry into ERP through the front-end where no back-end facility was available.Developed SQL procedures for data loading, validation and testing.Contributed as a Business Advisor in regular sessions with Oracle Development – focusing on Inventory and eAM modules.

Project Lead - ERP Security

Designed the overall security matrix for enterprise applications based on Sarbanes Oxley principles.Created Role Based Access Control (RBAC) design to define different roles for using different applications.Built custom back-end procedures to create new users and assign required roles & security settings.

Technical: Cognos 8.4, JIRA, MS Project, Oracle 10g EE, Dataloader, OBIEE +, EBS R12, ERWIN, OWB, MapInfo

Countries: Canada, USA

Consulting Partners: Price Waterhouse Coopers (PWC), IBM, Oracle, DataLoader (UK)

LDS / Telecomratings

2001-2006

Founding Partner

Conceived and developed an advanced, B2B and B2C platform to deliver real-time information (virtual) products.Defined detailed requirements for the administration, front-end, security, data exchange and other aspects of the web application.Designed the back-end architecture, database structures and data exchange interfaces to enable efficient storage/retrieval of information.Led the system selection and vendor sourcing process to compare leading online solution providers.Partnered with off-shore software vendor (Australia) to lead development of an all-new electronic product delivery online store.Partnered with leading on-line security firms and payment gateway service providers to implement a secure, fast payment system.Identified key business measurement goals and developed KPIs to measure performance.Designed executive and administrative dashboards to enable Business Intelligence functionality.Planned and supervised the migration of data from MySQL to Oracle backend.Led the design, development and implementation of the Customer Reviews and Customer Rewards modules.Supervised and guided all Search Engine Optimization and online advertising and marketing campaigns.Led external vendors and internal resources through implementation evolution from development to production.Spearheaded the expansion of the business model to offer user reviews as a separate B2B service.Implemented an advanced Content Management System (CMS) to manage e-store content.

Technical: Crystal Reports, Informatica, Sybase Powerdesigner, MySQL, Oracle 10g, TOAD, MapInfo, Primavera, SSIS, SSRS, IIS

Countries: Canada, USA.

Consulting Partners: Internetsecure, Smartwin, Google, Microsoft

Purolator Courier

2003-2005

Implementation Lead

Led the implementation of a leading-edge, custom-built automated vehicle routing system across Ontario and Quebec (total 12 sites).Developed data conversion plan to migrate data from legacy applications into new routing software.Built custom applications for data collection/cleansing/validation.Programmed custom interfaces to extract data from legacy applications into flat files.Developed interfaces to allow movement of data between routing application and other operational systems (e.g. PIN tracking). Contributed to SAP ERP implementation – expense management, user portal.Built customized reports and dashboards for various levels of operations and management (District Region down to Line Supervisor) based on dimensionally-modeled data (Kimball).Managed multi-disciplinary teams (Operations, IT, Management, Dispatch, Maintenance) through all phases of implementation.Created quality test plans and scripts for SIT, UAT.Partnered with external vendor to define requirements for future system upgrades.

Technical: MS SQL Server, SAP R/3, Crystal Reports, MapInfo, Dashboard (proprietary BI), Web Technologies, Geocom Transportation Management (proprietary), AS/400, MS Project, SSIS, SSRS, IIS

Countries: Canada, USA.

Consulting Partners: IBM, Geocom, CGI, Innovapost

Magna International

1997-2002

Process Engineering / Data Management

Planned the conversion of blueprints and other hardcopy documents into an electronic format.Developed standards and best practices for electronic data management.Implemented several real-time automated process quality control checking systems such as digital vision systems, cross-section measurement and related IT record management and storage infrastructure.Assisted the Y2K compliance team with disaster recovery action plans and procedures.Developed KPI's and metrics to measure performance levels of several manufacturing/quality processes.Investigated possible upgrades for legacy MRP and ERP systems.Managed cross-functional teams (IT, Manufacturing, Quality, Maintenance, External Contractors) to implement projects focused on process optimization, and efficiency.Utilized key concepts from six sigma, lean manufacturing, FMEA, DFA/DFM, Root Cause Analysis to solve quality issues.Led the system selection and vendor sourcing process for system upgrades.Developed SQL scripts for data validation, auditing and other ETL processes.Designed new architecture to replace legacy design systems. Led external vendors and internal resources through implementation evolution from development to production.Identified training requirements and developed related training material (electronic, online and print).

Technical: SAP, MS SQL Server, Access, ERWIN, Autodesk, Excel, Unigraphics UGS, EASi-Seal, Business Objects, MS MapPoint, MS Project, AS/400

Countries: Canada

Consulting Partners: IBM, SAP

Education

Bachelor of Engineering (Ryerson University, Toronto)Ontario Secondary School Diploma (Earl Haig Secondary School, North York)

Professional Training

Advanced Professional Negotiation SkillsMaynard MOST Work Measurement & Modeling SystemValue Analysis, Value EngineeringFMEA - Failure Mode and Effects AnalysisOracle Business Intelligence Enterprise Edition (OBIEE+)

References

Contact this candidate