Principal Database Engineer Resume
PROFESSIONAL SUMMARY:
- Specializing in the fields of finance, insurance and healthcare, 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.
TECHNICAL SKILLS:
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
PROFESSIONAL EXPERIENCE:
Confidential
Principal Database Engineer
Environment: (IBM InfoSphere IDA, IGC), AWS Big Data, Postgres, Node.js, Redshift, MongoDB)
Responsibilities:
- Led information architecture and data solutions in the founding of Stellarport, a highly secure, reliable and responsive portal to the Stellar distributed blockchain
Confidential
Chief Information Architect
Environment: IBM InfoSphere IDA, IGC, FastTrack, QualityStage AWS Big Data, Azure Postgres, Node.js, Azure, Hadoop.
Responsibilities:
- Integrated all enterprise information assets by sourcing disparate, silo applications into a single, cohesive information ecosystem.
- Solved leadership’s business challenges using business intelligence, data mining and analytics insights.
- Formulated and executed all organizational goals related to the storage, transmission, analysis and security of enterprise information.
Confidential
Lead Enterprise Information Architect
Environment: IBM Infosphere IDA, BG, IGC, FastTrack, DataStage, Metadata Workbench, Director, MDM, QualityStage, etc.) AWS, Azure, Hadoop, Netezza, Oracle, Hadoop, Node.js, Java, Tableau, Tibco, HL7)
Responsibilities:
- Led a team of architects, developers and administrators through the systems development life cycle for projects in information governance, master data management, data warehousing and systems integration.
- Created data governance technical framework, and helped lead the Data Governance Council using metamodels, architecture models, enterprise architecture and shared services.
- Wrote proofs of concept, software specifications, statements of work, project estimates and other formal documents.
Confidential
Database Systems Consultant
Environment: IBM Infosphere (IDA, Datastage, Cognos) AWS, MDM, Oracle, SSIS, MongoDB, Teradata, Node.js, Java, Perl, C/C++)
Responsibilities:
- Provided industrial-strength computing professional services to enterprises on a contracted, consulting basis.
Confidential
Lead Data Architect (Erwin, Oracle, Java)
Responsibilities:
- Created and 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.
Confidential
Senior Data Architect
Responsibilities:
- Converted logical and physical data models and data from Oracle and DB2 to Teradata warehouse for Confidential HSBC Merger. Prepared and tested deployments with database administration team.
- Automated dev-ops through software to generate database deltas.
Confidential
Lead Database Architect
Responsibilities:
- 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.
Confidential
Lead Data Architect
Environment: Oracle, OWB, ERWin, Teradata, Datastage, Business Objects, KSH
Responsibilities:
- 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.
Confidential
Data Architect
Environment: DB2, ERWin, Eclipse, Cognos, Java/Spring, XML/XSLT, Perl
Responsibilities:
- 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.