by Peter S. Poneros
Data Architect
- BACKGROUND: data architecture, data modeling, project management, software development, and production support.
- STRENGTHS: management & leadership skills, structured analysis and design, object-oriented analysis, Software Development Life Cycle (SDLC), project scheduling, resource allocation, database application development in both online transaction processing (OLTP) and online analytical processing (OLAP) environments, SQL scripting, PL/SQL programming, and IT Production Support.
- TECHNICAL SKILLS: Oracle RDBMS, MS SQL Server, Sybase, Oracle Designer, ER/Studio, ERwin, Informatica, Agile/Scrum, CMMI Process, SAP BW, Cognos, Remedy, UNIX, VAX/VMS, PL/SQL, C++, Pascal, Microsoft Windows, Office, Project and Visio.
PROFESSIONAL EXPERIENCE
ZuluTime, LLC (2015 – Present)
CEO/Chief IT Consultant
President and Principle Consultant of my own IT Consulting Company. Make all business decisions, maintain the general ledger, manage business opportunities and provide consulting services for:
Great American Insurance Group, Data Architect, Cincinnati, OH (2015 – Present)
Gathered requirements, designed and implemented Great American Insurance Group’s Annuities Enterprise Data Warehouse (EDW).
- Developed an Inmon like Enterprise Data Warehouse, source data Staging Environments and Kimball like Data Marts (star schemas) to support reporting and analysis.
- Captured EDW requirements via an Enterprise Logical Data Model, designed Physical Data Models, produced Database Design Language (DDL) Scripts and implemented all of the database environments.
- Performed data profiling of existing databases to better understand the enterprise’s data..
WhatShe8.com (2013 – 2015)
President, Photographer, WordPress Developer & Admin
Established separate travel and wellness websites to chronicle diverse cultures from around the world. Traveled the world to acquire content for these websites.
- Develop and maintain two websites with distinctly different themes to capture and share experiences gathered during these travels. These sites have a global following with visitors from over 100 different countries.
- Experience different cultures, traditions and cuisine and capture these experiences for the websites.
- Compile eBooks from the blogs, videos and photography collected during my travels.
Citigroup, Warren, NJ (2013)
Sr. Data Architect
Developed Logical Data Model for defining and tracking financial exposure to distinct legal entities in accordance with Dodd-Frank.
- Defined a legal entity.
- Developed a logical data model that represented a legal entity and the total risk exposure to a legal entity and all of its component organizations.
Avon Products, Inc., Rye, NY (2011 – 2013)
Sr. Data Architect
Translate strategic and operational business requirements into database solutions by developing and maintaining logical and physical data models and generating DDL using ERwin.
- Defined and developed an Enterprise Application Data Integration Canonical.
- Supported ETL design and development using Informatica PowerCenter.
- Supported the rollout and integration of SAP into the enterprise landscape.
PR Newswire, Jersey City, NJ (2009 – 2011)
Data Architect
Translated strategic and operational requirements into a usable enterprise information architecture by reverse engineering existing applications and interviewing subject matter experts.
- Established enterprise information architecture standards.
- Used ERwin to reverse engineered physical data models from existing database applications.
- Analyzed physical data models and current business requirements to extrapolated logical data models.
- Consolidated individual application logical data models into a logical enterprise data model.
- Migrated legacy Oracle Database applications from a Sun environment to a virtual servers running Linux, dramatically reducing support costs.
- Supported development and rollout of Oracle and MS SQL Server solutions as the architecture owner for the Agile/Scrum Teams.
Medical Bunker, Saddle Brook, NJ (2008 – 2009)
Data Architect
Lead Architect for an Electronic Health Record Management System development effort.
- Defined a system that used Software as a Service (SaaS) to provide a cost effective solution for managing and distributing patient medical records for small to medium sized medical offices and clinics.
- Created initial Agile Architecture Models to capture the project scope and team direction.
- Served as the Agile Architecture Owner.
McGraw-Hill, The Grow Network, New York, NY (2007 – 2008)
Data Architect
Worked with the sales and product managers to identify and analyze requirements for a new Student Assessment Test Analysis System. Defined a strategic solution that leveraged the integration of new technologies with an existing application infrastructure, minimizing new development costs.
- Guided the strategic decision making process during information architecture development.
- Contributed to an Agile/Scrum effort by generating the Logical and Physical Data Architecture Artifacts.
- Generated Logical and Physical Data Model in ER/Studio.
- Implemented the system in Oracle 10g using Informatica PowerCenter 8.5.1 ETL.
- Provided expert guidance to executives, sales and product development staff on technology / industry trends.
Poneros Client Services, Inc., Lancaster, PA (1997 – 2008)
President/Chief IT Consultant
President and Principle Consultant of my own IT Consulting Company. Made all business decisions, maintained the general ledger, managed business opportunities and provided consulting services to the following companies.
BASF, Data Architect, Rockaway, NJ (2005 – 2007)
Provided technical leadership and guidance to Business Intelligence Organization’s Data Architecture group.
- Established and implemented Data Architecture standards and procedures.
- Implemented Oracle Designer 9i as the core metadata repository.
- Reverse engineered physical and logical data models of SAP’s Sales, Purchasing, Transportation, and Foreign Trade tables.
- Architected, developed and implemented a PL/SQL application to reverse engineer SAP’s internal metadata definition tables into the Oracle Designer Metadata Repository via Oracle Designer’s API.
- Spearheaded multiple projects to migrate Data Warehousing functionality from BASF’s internally developed Enterprise Data Warehouse (EDW) into SAP’s Business Warehouse (BW).
GEICO, Data Architect/Modeler, Chevy Chase, MD (2004 – 2005)
Reverse engineered an existing enterprise environment consisting of a mainframe and UNIX Servers supporting a heterogeneous mix of databases consisting of IMS, DB2/UDB, Oracle, and MS SQL Server.
Freddie Mac, Data Architect, McLean, VA (2004)
Analyzed existing business requirements of quarterly close the books (CTB) process. Proposed new process that leveraged Freddie Mac’s existing data warehouse and reporting environment with the business objectives of providing a completely traceable CTB process in compliance with Sarbanes/Oxley.
- Analyzed existing CTB DB2 and Sybase environments to reverse engineer as-is physical data models and data flow diagrams.
- Designed a physical data model and ETL process to support Freddie Mac’s updated Data Warehouse.
- Shortened the process duration from 6 months to 1 month.
Sterling Financials, Project Manager/Database Architect/Modeler/Developer, Lancaster, PA (2004)
Managed the development and contributed to the analysis, design, implementation and support of Operational and Reporting applications in a Microsoft SQL Server environment.
- Analyzed business requirements and managed project life cycle with MS Project for a Broker Account Portfolio Management System.
- Designed and implemented the Investment Broker Account Portfolio Management System using Microsoft SQL Server, Visual Basic and ADO.Net.
Armstrong World Industries, Project Manager and Data Architect, Lancaster, PA (2003 – 2004)
Designed, implemented, and managed development of SAP BW and APO solutions in Oracle 9i in compliance with CMM Level 3.
- Defined and managed Armstrong’s Demand Planning System development life cycle using MS Project.
- Configured and implemented APO’s Demand Planning Module to meet Global Logistics Requirements.
- Designed and implemented ETL process to load historical sales data from legacy mainframe system
- Designed and implemented ETL process and SAP BW data objects to import Electronic Data Interchange (EDI) flat files into the BW.
Merck Research Laboratories (MRL), Enterprise Information Architect, West Point, PA (2002 – 2003)
Analyzed, proposed and designed an Integrated Enterprise Data Warehouse (EDW).
- Analyzed existing Oracle Data warehouses against current MRL business requirements.
- Developed a prototype Oracle EDW using Informatica and PL/SQL to accomplish the ETL.
- Analyzed prototype results to produce an Enterprise Logical Data Model.
GlaxoSmithKline – Research & Development (R&D), Data Modeler/Architect, Collegeville, PA (2001 – 2002)
Provided analysis, design, and implementation support to the Foundation Data Warehouse (FDW) Project.
- Analyzed, designed, developed and implemented data cleansing and conversion to merge SmithKlineBeechum and Glaxo-Welcome financials into a common GlaxoSmithKline financial data warehouse.
- Performed logical and physical data modeling, and DDL generation using Oracle’s Designer 6i.
United States Navy – Fleet Material Support Office (FMSO), Project Manager and Data Modeler/Architect , Mechanicsburg, PA (1997 – 2001)
Established requirements, produced design, managed and contributed to the implementation, testing and integration of an Oracle Data Warehouse and ETL Processes, implemented in Informatica and PL/SQL, that provided the Navy with an OLAP environment for its logistical data.
Pennsylvania Department of Environmental Protection (DEP), Harrisburg, PA (1995 – 1996)
Project Manager/Technical Lead (Independent Consultant)
Established requirements, produced design, managed and contributed to the implementation, testing, and integration of an Application Processing System in a client server environment for the Pennsylvania Department of Environmental Protection (DEP). The application was designed with Oracle Designer and implemented in an Oracle Forms and Oracle RDBMS environment that included extensive PL/SQL development.
Oracle Corporation, Redwood Shores, CA (1993 – 1995)
Senior Software Engineer / Project Manager
Created Oracle’s first Sales Force Automation laptop configuration, created its first desktop support group and designed the database for an Order Fulfillment System.
- Managed the development, deployment and support of Oracle’s first Sales Force Automation Project, consisting of over 1000 laptops for Oracle’s sales representatives and consultants throughout the US.
- Managed the creation and implementation of a PC Desktop Support organization for over 3000 end-users, including the deployment of over 1000 PCs.
- Established relational database requirements, produced relational database design, implemented, tested, and integrated an Order Fulfillment Database. Created logical and physical data models using Oracle Designer 2000.
- Implemented a self-contained relational database in Oracle that guaranteed referential integrity and enforcement of business rules through built in referential integrity constraints, triggers, and stored procedures.
Varian Associates, Palo Alto, CA (1992 – 1993)
Senior Software Engineer
Established requirements, produced design, implemented, tested, and integrated an Oncology Patient Treatment Database. It was designed using ERwin and implemented in Sybase.