Data Oracle
Resume:
Lavey Strauss
Chief Information Architect
********@**********.***
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