Michael D Lapenna Email & Phone Number

Greater Toronto And Hamilton Area, Ontario, Canada

Contributing to Data focussed initiatives at medium sized companies and participating in the Data/BI section of Technology Due Diligence engagements.

Toronto, Ontario, Canada

Currently designing and implementing a metadata repository to collect (crowd source) and analyze data governance assets. The solution captures detailed data lineage from multiple data movement profiles (file, streaming messages, databases). Enables BAs to specify source to target mappings without IT dev. Front end includes React and Material UI. Server side includes Postgres, Rest API in Nodejs and Java. Will be integrating with Collibra, Hive, and a semantic graphing tool. Also planning a data lineage harvest tool on existing ETL scripts. Having lots of fun on this project.

Toronto, Canada Area

Working with talented individuals to completely modernize Manulife's Investment Division operational and information systems. A major development piece involves establishing a data lake on Hadoop. I am currently working with Simcorp Dimension, Bloomberg PolarLake and Hortonworks for big data (Hive, Atlas, Nifi, Sqoop, Oozie). My role is information and solution architect for the enterprise data lake ecosystem.

Toronto

Worked closely with a talented team on delivering a Risk Data Aggregation platform for regulatory reports, management reports and data analysis. ■ Implemented a Bitemporal Data Model, which records all business changes and corrections over time■ Designed and implemented a flexible Reference Data Solution on Informatica MDM for applying data standardization■ Worked with the Data Management Office to fulfill BCBS 239 principles – designed the data model for timeliness, accuracy and completeness of risk data■ Wrote DDL generators to automate the application, back out, and validation of database changes■ Interfaced with Oracle Golden Gate to achieve micro batch (near time) data warehouse updates■ Operated in a semi agile environment using Microsoft Team Foundation Server■ Guided and mentored several data modelers and data analysts throughout the program■ Technologies included Erwin, IBM Netezza, Informatica MDM

Toronto

■ Worked with Market and Counterparty Credit Risk teams to build a new platform to satisfy Canadian and United States regulations on risk aggregation principles (BCBS239) as well as Basel III.■ Led the Data Team (4 individuals) for data modelling, data policies, data quality, data lineage, and data governance. ■ Advised software development teams on effective ETL/ELT, metadata driven solutions for flexibility and assisting in data mapping from source systems (internal and external) into the core data model.■ Through a collaborative process (data governance sessions) I developed a Product Catalog for traded products - for use within limit monitoring, authorized product list and report aggregations.■ Worked with the Lending group to integrate their risk data, as well as Enterprise Data Modelling team to incorporate Liquidity Risk Management, Trade Surveillance and Anti Money Laundering ■ Technologies include PowerDesigner, IBM Netezza, Pivotal HD (Big Data) Oracle, Spotfire

San Francisco

I work closely with clients to determine and implement Enterprise Data Strategy.■ Worked with recent client to analyze more than 10 databases containing security master data■ Developed a consolidated security data model (ER diagrams, established design patterns and naming standards, provided table and column descriptions)■ Mapped all security related vendor feeds into the the client's master security data model■ Led analysis and recommendation for the new multi-level Security Classification – unifying several unaligned classifications■ Collaborated with multiple teams to organize, construct and execute business and technical use cases for a Proof of Concept with two major MDM vendors■ Delivered presentations to the client's management providing insight on their data landscape and recommended strategies for data management and data quality programs■ Technologies included Erwin, Oracle, DB2, Aqua Studio

■ Developed the Data Conversion Strategy for Manulife’s global accounting system (Portia)■ Established a company-wide meta data repository for data elements and system mappings; implemented over 50 system interfaces using this infrastructure (converted code to data)■ Created a data warehouse of MFC Asset Management’s data, becoming the consolidated master data source for all other AM systems■ Instituted a data quality measurement program to identify business processes needing revision■ Conducted data profiling, evaluated findings and presented analysis and recommendations■ Researched and recommended data and technology architecture for new Third Party division■ Technologies included Erwin, SQL Server 2005, Informatica IDE, IDQ, IMM, Aqua Studio

■ Created and implemented data model for the new e-channel system■ Business domains included matrix pricing, trades with allocations, tiered inventory, RFQs■ Data Model was subsequently expanded to multiple business lines. ■ Assisted in the application design which employed SOA approach■ Employed 3rd normal form (OLTP) in the ODS star schema (OLAP) in the data warehouse■ Designed and wrote resilient ETL (Sybase stored procedures, auditing, dependency checks) ■ Responsible for designing reports/dashboards to mine the data■ Owned the data cleaning process: normalizing, profiling, cleansing, categorizing■ Major key success factor was instituting a data quality dashboard for each subject area■ Entrusted with program and project management because of strong leadership and organization■ Technologies included Erwin, PowerDesigner, Sybase ASE and IQ, Siebel Analytics (Oracle BI), XSDs, FPML, FIXML

Toronto, Canada Area

■ Led development team (i.e. UI, Wireless delivery) in Toronto and Vietnam (combined size 40)■ Participated in requirements gathering, architectural decisions, code reviews■ Handled project management, technical problem resolution, resource allocation and hiring■ Mentored team in problem solving, improving quality and work estimation■ Technologies included J2EE (JSPs, JavaMail, JSSE), Tomcat, Junit, Cactus, LDAP

Toronto, Canada Area

Designed and built Canada's first ATS for fixed income products (including futures). Two major components were the anonymous exchange and the RFQ/IOI capability, with ranked and timed responses. ■ Designed and implemented a new real-time web-based trading application for brokers■ Hired the team, formulated the IT strategy, conceptualized the product and built it! ■ Turned the concept into a concrete project plan and managed it through to prototype to production■ Ensured success through prototyping, rigorous testing, industry involvement■ Participated in formulating the marketing strategy with the sales team and the CEO■ Built the team from 4 to 18 developers and QA staff, managing a budget of $2M annually■ Collected and analyzed business requirements; designed and implemented the data model ■ Personally developed calculation libraries, populated the database schema, built the trading engine■ Participated in compliance and control procedures during the partnership with the ME■ Technologies included J2EE (JMS), FIX protocol, Oracle, Apache/Tomcat, XML, TogetherJ, Eclipse CBID Products are now owned and managed by Perimeter Markets (www.pfin.ca).

■ Designed, developed, implemented a complete overhaul of E-BOND’s website and data repository ■ Handled database modelling, population, tuning and query optimization■ Responsible for project management, product development, network administration (web site hosting)■ Constructed responses to RFQs from the federal government and E-Trade■ Led the business analysis, managed the vendor relationships, software selection and technical direction (with presentation to management)■ Participated in steering committee meetings as equal partner with business owners■ Technologies included JSPs/Servlets, Oracle 8i, Apache on Solaris and Linux

Software design for the trading floor.

Software developer for Investment Banking group

Mba, Ecomonics And Strategy

Activities and Societies: Business Case Competition

Bba/Cs, Business, Computer Science