| Candidate Information | | Title | Database Administrator Data Architect | | Target Location | US-PA-Plymouth Meeting |
| | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateAn accomplished Information Architect and Database Administrator with demonstrated success in designing, developing, and implementing information solutions that have greatly improved business functionality. A well-seasoned technical background spanning multiple types of information systems including structured and unstructured data. I am a gifted professional with an enormous amount of experience in the design, development, and implementation of Traditional, Big Data and Cloud Systems. I also possess the ability to handle multiple tasks, manage, and mentor teams. I am also accomplished at decreasing overall information system cost and improving enterprise productivity.QUALIFICATION HIGHLIGHTSExpert Information Architect with 34 years of experienceExpert Database Administrator utilizing Oracle, SQL Server, Sybase, MongoDB, Amazon RDS (DynamoDB, MySQL, Postgres, and Redshift) Azure DB, IRIS DBExpert Decision Support Architect. Responsible for designing, administrating, and implementing Big Data, Data Warehouse, Data Lakes, Lakehouse, Data Mart, and Data Mining applications.Certifications:TECHNICAL EXPERTISEDatabases Oracle (Version 5 through Version 21c),SQL Server (Version 6.5 through Version 2019),Sybase (Version 4 through Version 12), Azure DB, Cassandra,MongoDB (Version 2.6.4), Netezza (Release 7.2.1.4)AWS RDS, AWS Redshift, Snowflake, Google BigQuery, IRISCloud Platforms AWS, Azure, GCP, OCISoftware Erwin, Oracle Designor, Oracle Enterprise Manager, OracleRMAN, PowerDesignor, Informatica PowerCenter,Informatica Data Quality, SSIS, SSRS, IBM MQ Series,MS Office, MS Project, System Architect, SAP, GIT, JBOSS,TIPCO, Siperian. Quest Toad, Quest Shareplex, Essbase,Autosys, Hyperion, BMC Patrol, Microsoft Data Quality\Services, Data Quality (FirstLogic). AWS (Glue, Athena, S3, Streams, EMR, EC2, ML, Lambda, Redshift Spectrum)Operating Systems Sun Solaris, MS Windows, Red Hat Linux, HP/UX,SCO UNIX, IBM AIXLanguages Python, Spark, Scala, C, Java, SQL, PL/SQL, T-SQL,Perl, Shell Scripting, Numerous 3GL Programming LanguagesEXPERIENCEFontanelle Software Services, Oreland, PA November 2014 PresentSenior Solutions Architect and Data/Database ArchitectSenior Solutions Architect of a software consulting firm. Specialized in Information Systems Architecture, Relational Database Administration, Relational and Object Data Modeling, Data Warehousing and Decision Support Design (OLAP and Data Mining), Database Programming and SAP, PeopleSoft, and Oracle Applications Database Administration.Senior Data Architect for MAS (JPMC) ProjectResponsible for the following:oParticipated in initial proposal to JPMCoDeveloped architecture for data pipeline connecting Cassandra to AWS RedShift.Accomplished utilizing DB Triggers, Kafka Messaging, and Lambda FunctionsSenior Data Architect for Broadridge Inc. (WMAP) ProjectResponsible for the following:oLogical models of 22 subject areasoClient/Search data model and ETL of all staging tablesoScala programs for high volume and high-speed loading operations utilizing AWS GlueSenior Data Architect for Mortgage ConnectResponsible for following:oLong-term and medium-term data strategiesoConversion of application data projects from on-premises dev-ops to a cloud-based Azure dev-ops strategy.oDevelopment of database pipelines utilizing Azure DB, open-source repositories, and MS Database ProjectsoImplementation of Azure DB converting from on-premise databasesSenior Solution Architect for Sanofi Pharmaceuticals SURF (Sanofi Upgrade to Revitas Flex) ProjectResponsible for the following:oOversight over the technical delivery of the projectoReview and monitor relational data structures, data and process models for all environments together with internal Sanofi teams and external application teamsoReview and analyze boundary system dependencies and ensure the data flows are in good standing.oResponsible for the effective coordination, communication, planning and/or validation of SDLC activities and reportingoPrepare documentation including but not limited toUnified Cutover PlanUnified Data Migration PlanPerformance Testing PlanDisaster Recovery PlanHigh Availability PlanPre-go live signoffPost go-live signoffPost go-live infrastructure check listoPerform quality control and process and technical documentationoCreation of technical design and operations documentationoKnowledge transferoAWS Services utilized (EC2, S3, and ElasticSearch) as on-cloud deployment option.Data Architect for Wiley Publishing Business Management Information System (BMIS) Project(Netezza Release 7.2.1.4, Erwin 9.64, Cognos, Qlik)Responsible for all data architecture tasks related to BMIS project. The BMIS projects included:oExtraction and Mapping from an SAP systemoCreation of multiple star schemas includingSalesInvoicesRevenue RecognitionSales TargetingoCreation of conversion layer star schemas that incorporate legacy data with the above-mentioned star schemasoCreation of aggregate level tables and cubes used to support BI developmentoAWS Services utilized (Oracle, EC2, S3, Glacier, Redshift)oHadoop Loading and querying of large volumes of data.Data Architect and Database Administrator for PHH Mortgages Technical Transformation Project(Oracle 9, 11g, 12c, SQL Server 2014, Sybase 12, Erwin 9.64, SQL Developer, Quest TOAD)Responsible for all data architecture, data mapping and database administration tasks related to Technical Transformation projects. The Technical Transformation projects included:oNew LOS (Loan Origination System)oEnterprise Data Dictionary RepositoryoESMS (Enterprise Software Management System)oLG (Lead Generation), Data Archiving using Mongo DBoCL (Scoping and prototype for Correspondent Lending)oEstablishment of ERwin Metamodel RepositoryoAWS Services (Oracle, EC2, S3, and ElasticSearch)Computer Sciences Corporation, Berwyn, PABig Data and Data Warehousing Group, Principal Consultant April 2005 October 2014Principal Consultant Level database expert. Database expert position encompasses Big Data, Data Warehouse architecture, ETL Architecture and Programming, Database Administration and Data Modeling.ETL Architect for AECON Project (Informatica PowerCenter, Informatica Data Quality, Microsoft SQL Server, Microsoft SQL Server Integration Services SSIS, SAP). Team lead for ETL group, group encompasses six people located in three different countries. Group is responsible for migrating multiple data sources into a new SAP environment.Source systems included:oSQL Server DatabasesoIntuit QuickBooks SystemsoIBM ISAM FilesoUnstructured Data Documents of multiple formats (Big Data concepts used)Project Manager for Shire Pharmaceuticals Database Re-Architecture initiative. Shire is a specialty biopharmaceutical company that focuses on meeting the needs of the specialist physician. Shire focuses its business on attention deficit and hyperactivity disorder (ADHD), gastrointestinal (GI) diseases, human genetic therapies (HGT) and regenerative medicine (RM), as well as opportunities in other therapeutic areas. I was responsible to lead and manage a group of twenty-seven people (DBAs, Process Designers, Testers, etc.) spread across three different countries. The group was responsible for re-architecting 2400 Oracle and SQL Server databases. The group concentrated on the following areas:oMonitoringoBackup and RecoveryoDatabase LaboStandard Installation and Creation ConfigurationsoAWS Services (EC2, S3, RDS)ETL Architect for CONED Project (Informatica PowerCenter, Oracle, PL/SQL). Team lead for ETL group, group encompasses seven people spread across several continents.Technical Lead for Data Integration Layer (DIL) (Informatica PowerCenter, Informatica B2B, SQL Server, Web Services) for American Life Insurance Company (ALICO). ALICO is a subsidiary of Metlife Corporation. ALICOs primary business is delivering and managing life insurance to non-US countries. The DIL was created to automatically manage the distribution and flow of data sets between internal and external ALICO partners.Source systems included:oSQL Server DatabasesoUnstructured Data Microsoft Work Documents (Big Data concepts used)Team Lead for Database Administration for United Launch Alliance (ULA) Corporation. ULA is a company that was created to combine the rocket launching capabilities of both the Boeing Corporation and the Lockheed Martin Corporation. I was responsible and lead a group of twelve DBAs spread across four different time zones. The group was responsible for managing 400 databases residing on one hundred different servers. The databases that were managed consisted of Oracle, SQL Server and Sybase databases. The team was also responsible for managing all data warehousing activities.Team Lead for Master Data Management, Data Warehousing, Data Analytics and Data Governance project for Hess Corporation, group encompasses multiple people. Project utilizes Data Maturity Models, Data Governance Models, product selection for Master Data Management (Siperian MDM, IBM WCC), Data Quality (Business Objects Firstlogic, Trillium) and Business Intelligence (Microstrategy, Business Objects, Cognos) tools.Team contributor for a performance engineering group, group encompasses 10 people and was responsible for a major DOD application performance improvements. Project utilized (Sybase, JBoss, Java, Powerbuilder, CA Introspec, PL/SQL, and Shell Scripts). Obtained Top-Secret clearance.Team Lead of Multi-dimensional cube development group for Verizon Financial Project, group encompassed five people. Project utilized (Oracle 10g, PL/SQL, Shell Scripts, Hyperion Essbase, and Hyperion MDM)ETL Architect for DLL Project (IBM Datastage, IBM Metastage, Oracle, PL/SQL, Oracle Portal)Team lead for ETL group, group encompasses seven people spread across multiple continents.Lockheed Martin, Valley Forge, PADatabase Architect Staff April 2004 April 2005Staff level database architect. Database architect position encompasses database programming, database administration and data modeling.Database Architect for IR&D Project for Message Routing Service for Guards (MQ Series, Oracle, Messaging)Database Architect for TMOS Proposal (Oracle, Messaging, Multilevel Security, SOA)Database Architect for UCIDS Proposal (Multilevel Security, Adhoc Networks)Project Leader for Formal Training Curriculum (Various Subjects)Database Architect for the Evolutionary Environment Project (SQL Server, Expert Systems)Database Administrator for the Charitable Giving (United Way) Project (Oracle, PL/SQL)Database Architect for the GRID Project (internal capabilities project) (SQL Server, DTS)Mentor of Junior Level co-workersFontanelle Software Services, Oreland, PA September 1995 March 2004Senior Database Architect and Senior Database AdministratorSenior Database Architect of a software consulting firm. Specialized in Information Systems Architecture, Relational Database Administration, Relational and Object Data Modeling, Data Warehousing and Decision Support Design (OLAP and Data Mining), Database Programming and SAP, Peoplesoft, and Oracle Applications Database Administration.Boeing Corporation Senior Database Architect and Senior Database Administrator(Oracle 9i, SQL Server 2000, Oracle Designer,Data Warehousing, Datastage)Drexel University Adjunct Teacher Oracle 9i Certification Curriculum(Oracle 9i)VIPS Corporation Senior Database Architect(Oracle, Erwin, Informatica)Computer Science Corporation Senior Database Architect(Oracle, CA Unicenter, Quest Shareplex)True Position Senior Database Administrator and Team Lead(Oracle, Erwin)Automated Data Processing Senior Database Administrator(Oracle, Erwin, Oracle Applications)Susquehanna Investment Partners Senior Database Architect and Senior Database AdministratorAnd Team Lead (Oracle, SQL Server, Data Marts, Tivoli)Wyeth-Ayerst Laboratories Senior Database Administrator and Team Lead(Oracle, PowerDesignor, SAP, Peoplesoft,Data Warehousing)IMS Incorporated Senior Database Architect (Oracle, Data Warehousing)Bentley Systems Senior Database Administrator (Oracle, SQL Server, Erwin)First USA Bank Senior Database Administrator and Team Lead(Oracle, Erwin, Data Warehousing)Premier Solutions, Malvern, PA October 1994 September 1995Senior Database Architect and Senior Database AdministratorResponsible for database architecture and relational database administration in a multi-platform environment consisting of Alpha OpenVMS, HP9000 and Pentiums PCs, running the OPENVMS, HP/UX and MS-DOS (Windows) operating systems, respectively.Senior database architect for a large monetary trust management system. System included over 600 tables and 2300 indexes. The system incorporated a generic data model that was customizable for multiple customers.Senior database administrator responsible for implementing and customizing physical database design.Walklett Burns Ltd., Great Valley, PA October 1993 October 1994Senior Software EngineerResponsibilities included database administration, software development and project leadership in a multi-platform environment. The environment consisted of VAX clusters (Oracle Parallel Server), and 386/486 microcomputers, running the VMS, MS-DOS (Windows) operating systems.Database Administrator of FIX Development TeamTeam leader of FIX Data Conversion ProjectNaval Ship Systems Engineering Station October 1988 June 1994Philadelphia, PAComputer Engineer and Project LeaderResponsibilities included project leadership, software development and database administration in a multi-platform environment. The environment consisted of VAX Clusters (Oracle Parallel Server), Hewlett Packard, SUN and 386/486 microcomputers, running the VMS, UNIX and MS-DOS (Windows) operating systems.Database Administrator of Central VAX/VMS ORACLE SiteProject Leader of Aegis Information SystemProgrammer of Specialized Naval Inventory SystemProject Leader of Ship Maintenance Cabling SystemProject Leader of Knowledge Based Authoring SystemProgrammer of Integrated Survivability Management SystemProject Leader of Flooding Casualty Control SystemEDUCATIONLa Salle University, Philadelphia, PABachelor of Arts in Computer Science (1988)Currently Attending:Penn State University, Great Valley, PAMaster of Science in Information Sciences |
