Lavey Strauss

Chief Information Architect

ac5t6t@r.postjobfree.com

843-***-****

PROFESSIONAL SUMMARY

Specializing in the fields of finance, insurance and health care, Mr. Strauss leads enterprise information systems planning, design, development, integration and operations. With hands-on expertise in Model Driven Architecture and Business Intelligence, he executes from the top down, from the business capabilities and processes, through the conceptual, logical and physical models to production delivery, by designing, specifying, coding and supervising the implementation of each phase in the systems' life cycle, delivering maximum business value to the bottom line.

SKILLS

LEADERSHIP

Information Governance

Program and Project Management

Contract Negotiation

ARCHITECTURE & DEVELOPMENT

Enterprise Information

Software and Systems

Business Intelligence

DATA

Big Data Development

Master Data Management

Data Security

ACCOMPLISHMENTS

Led enterprise information architecture and development teams in the design, coding, testing and delivery of:

Real-time, complex event processing systems;

High-volume, highly-optimized and highly available transaction processing (HVTP) systems;

Very large, enterprise dimensional data warehouses, Big Data marts and data lakes;

Master data management systems to master a variety of entities such as parties and accounts;

Metadata and technological data management systems to integrate data governance, glossaries and lineage;

Administration of large database systems, including users, core code, security, recovery and replication.

PROFESSIONAL EXPERIENCE

2018 – Present, Stellarport.com, Evanston, IL

Co-founder (AWS, JavaScript, Node.js, Postgres, Infosphere Data Architect, Visual Studio Code, Git)

Architected, led development and deployment of highly secure, reliable and responsive website portal the Stellar financial network.

2016 - 2018, Illuminate Healthcare, Evanston, IL

Chief Information Architect (IBM Infosphere, Postgres, Node, React, AWS, Azure, MongoDB, SQLServer, HL7, LDAP/AD, Tableau)

Integrated all enterprise information assets by sourcing disparate, silo applications into a single data warehouse.

Created Business Intelligence dashboards to provide data mining and analytics insights to executive leadership in all departments.

Formulated and executed all organizational goals related to the storage, transmission, analysis and security of enterprise information.

2014 - 2016, University of Chicago Medicine, Chicago, IL

Lead Enterprise Information Architect (IBM Infosphere, MDM, Node, AWS, Netezza, Oracle, MongoDB, SQLServer, Postgres, Tibco, HL7, Java, Tableau)

Led a team of architects, developers and administrators through the systems development life cycle for projects in

master data management, data warehousing, information governance and systems integration.

Wrote requests for proposals, statements of work and specifications for contracted systems implementations.

Created metamodels and reference architecture models for enterprise architecture and shared services.

1994 – 2014, L J Strauss & Company, Chicago, IL

Enterprise Information Consultant (Infosphere, Erwin, AWS, MDM, SQLServer, Oracle, Postgres, MongoDB, Teradata, Node, Java, Perl, C/C++)

Provided industrial-strength computing professional services to enterprises on a contracted, consulting basis.

Clients included:

2014, Mesirow Financial, Chicago, IL

Lead Data Architect (Erwin, Oracle, Java)

Created enterprise ontology for fund of funds business model

Created enterprise conceptual, logical and physical data models.

Designed and executed SDLC processes to deploy physical models through development, test and production environments.

2013, Capital One, Mettawa, IL

Senior Data Architect (Erwin, Teradata, Java)

Converted logical and physical data models and data from Oracle and DB2 to Teradata warehouse for Capital One HSBC Merger. Prepared and tested deployments with database administration team.

Automated dev-ops through software to generate database deltas.

2011 – 2013, Allstate Investments, Northbrook, IL

Lead Database Architect (Erwin, Oracle, Informatica, Eagle Pace, Blackrock Aladdin, Java)

Logically and physically architected data warehouse for the capital markets domain, securities, holdings, trades, etc.

Integrated BNY Eagle Data Hub (ODS) with Blackrock Aladdin, Maximis, DSS, Microstrategy and all other applications.

Designed company-wide investments LDM and metadata management solution using Informatica metadata repository.

Tuned ETL, aggregation and reporting SQL, database objects and code.

2010, Walgreens, Northbrook, IL

Lead Data Architect (Oracle, OWB, ERWin, Teradata, Datastage, Business Objects, KSH)

Architected a DSS warehouse for pharmaceutical benefits management both logically and physically.

Tuned Oracle, Datastage and Business Objects code to optimize performance.

Created enterprise standards and automated processes to manage database schemata version control for all environments.

2008 – 2009, Blue Cross Blue Shield, Chicago, IL

Data Architect (DB2, ERWin, Eclipse, Cognos, Java/Spring, XML/XSLT, Perl)

Modeled OLTP and OLAP schemata LDMs and PDMs.

Drafted and reviewed technical design specifications, from business requirements through LDM & PDM and data access components’ specifications.

Renovated SOA applications data access layers in DB2 and Oracle.

2007, AT&T, Chicago, IL

Data Architect (Solaris, Oracle, Java/JWS, PERL, KSH)

Developed and maintained a 40+ terabyte Oracle data warehouse to extract, transform, load (ETL), aggregate and analyze wireless network performance metrics.

Designed and developed a Java Web Start application to administer application’s dynamic code generation and model changes.

2005 – 2006, JP Morgan Chase, Chicago, IL

Database Administrator (Solaris, Oracle, PostgreSQL, Java/JWS, ERWin)

Designed and coded OLTP database for Lockbox Remittances Ecommerce application.

Designed and implemented an automated database schema version control system and graphic user interface to control data definition code versions, with their related application code versions.

Modeled database LDM & PDM, and managed their version control.

Installed and configured Oracle Enterprise Server RDBMS for development, test and production.

Coded key data access layer SQL, utilizing Oracle packaged procedures, functions, triggers.

Designed application security utilizing Oracle Vault, privileges, etc.

Tuned database I/O, memory allocation, contention and individual SQL statements.

2003 – 2004, Underwriters Laboratories, Deerfield, IL

Database Architect (HPUX, Oracle, Perl, KSH, ERWin)

Conducted an Oracle database systems audit for globally distributed database system, focusing on six topics: Processing Time Diagnostics, Backup & Recovery, Installation & Configuration, Data Model & Architecture, Security and Memory & IO.

Led the administration team in reconstructing international Oracle replication infrastructure subsequent to systems audit.

2001 – 2002, Takeda Pharmaceuticals, Lincolnshire, IL

Database Administration Manager (HPUX, Oracle, Perl, KSH, ERWin)

Managed Oracle database administration team of three. Projects included:

Installation and configuration of Oracle 8i and 9i;

Design and coding of backup, restore and disaster recovery procedures.

Administration and configuration of SAP environment in Oracle.

Modeled database schemata, logically and physically;

Managed all schemata instantiation and version control.

Automated Oracle monitoring, tuning and integrated with enterprise monitoring systems.

1999 – 2000, Tribune Company, Chicago, IL

Database Administrator (Solaris, Oracle, Perl, KSH, ERWin)

Architected and managed a database HA (High Availability) systems solution to provide failsafe processing and storage for critical database applications.

Developed unified database backup and recovery processes for the many and varied database servers.

Executed recovery of partial and entire databases.

1997 – 1998, Monsanto, Skokie, IL

Database Administrator (Solaris, Oracle, Perl, KSH, ERWin)

Planned and implemented Oracle and OS upgrades and migrations.

Modeled database schemata logically and physically; managed their instantiation and version control.

Installed, configured, upgraded and maintained, enterprise-wide, distributed Oracle RDBMS systems for OLTP and SAP environments.

Created and documented standards for installing and configuring new Unix hosts and their associated database servers.

Restored and recovered entire databases.

1994 – 1996, GATX Corporation, Chicago, IL

Database Administrator (AIX, Oracle, Perl, KSH, PowerDesigner)

Installed, configured, upgraded and maintained, enterprise-wide, distributed Oracle RDBMS systems across AIX hosts across North America, including Oracle Developer components.

Recovered partial and entire databases after device failures.

Wrote key stored procedures and database triggers for data security, reliability and integrity.

Tuned database I/O, memory allocation, contention and individual SQL statements.

1994, Kaplan Hospital, Rehovot, Israel

Database Development Consultant (Oracle, Paradox)

Designed and maintained an operating room scheduling and surgery reporting system, including data modeling, coding, testing and roll-out to production.

1992 – 1994, Optrotech, Nes Tziona, Israel

Database Developer (SunOS, HP-Apollo, C/C++)

Designed and coded real-time data transfer from PCB (printed circuit board) design to PCB flaw detection systems.

1988 – 1991, Yael Software, Tel Aviv, Israel

Programmer/Analyst Consultant (IBM Mainframe CICS, Cobol, Ingres, Fortran, C)

Provided programming services to enterprises as a full-time consultant.

Clients included:

1991, National Healthcare Institute, Tel Aviv, Israel

Programmer/Analyst (CICS, Mainframe)

Developed nationwide purchasing and inventory system for healthcare supplies including pharmaceuticals.

1990, Bank Leumi, Tel Aviv, Israel

Programmer/Analyst (CICS, Mainframe)

1988 – 1989, Ministry of the Interior, Jerusalem, Israel

Programmer/Analyst (Fortran, Ingres, VAX)

1985 – 1987, Chicago Research & Trading, Chicago, IL

Programmer Analyst (C, *NIX/*SH, Oracle, RPG, System32/34)

Developed and supported a trade entry system to distribute trade data to real-time analysis engines.

Developed applications for futures options valuations and margin requirements.

EDUCATION

1985, DePaul University, Chicago, IL Postgraduate Certificate in Business Computing

1984, DePaul University, Chicago, IL Bachelor of Arts in Computer Science

2002, Oracle Corporation, Chicago, IL Certificate in Database Administration

Contact this candidate