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.

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.

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.

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.

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.

■ 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.

■ 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.

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.

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.

■ 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.

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