Bert Swope

Experience

• 

  Deloitte Consulting

  Jan 2010 - Jul 2012

  Information Management, Senior Specialist

  • Served as Senior Information Engineer and Team Lead for Banking Data Warehouse (BDW) and Financials Management Systems (FMS) data warehouse development and Life Cycle Support (LCS) teams.• Served as IBM InfoSphere administrator across development, testing and production environments, enabling, tuning, and installing multiple installations.• Published eminence and subject matter expert documents on information technology best practices, project management, system design, architecture, and system integration to the corporate knowledge management site.• Principle content contributor and administer of Project team Wiki technical process documentation site.• Wrote technical designs and other technical documentation, which were, repeatedly, cited by the customer as a pattern for other projects to emulate.• Developed and provided Life Cycle Support for numerous IBM InfoSphere DataStage environments.• Participated in an InfoSphere production environment tuning special project resulting in a 79% reduction in processing time.• Developed numerous Linux Bash/Korn shell scripts to support IBM InfoSphere administration and ETL requirements. • Administered, modeled and developed SQL Server objects including tables, views, indexes, code migrations, and security.• Created, reviewed, and provided subject matter expertise on system architecture, design, and performance enhancement documentation for implementation of Commercial-Off-The-Self (COTS) and custom solutions.• Created, reviewed, and provided subject matter expertise on COTS system architecture, design, and integration documentation.• Designed & built custom solution to augment COTS tool limitations to consume financial record values from an external SOA services. Show less

• 

  Accenture

  Jul 2012 - Jun 2015

  Associate Manager

  • Lead PeopleSoft Enterprise Performance Management (EPM), Supply Chain Management (SCM), data warehouse Life Cycle Support (LCS) team• Designed and developed Application Engines (AE), PeopleSoft Queries, and Structured Query Reports (SQR), pages, views, and interfaces.• Lead the development of a custom Requirements Management (RM) application and repository. • Created concept, logical and physical application database models and Entity Relation Diagrams (ERD)• Designed IBM InfoSphere solutions for providing and consuming SOA services for system supporting 5,000+ users• Improved Supply Chain Management (SCM) data warehouse batch completion rate by 45%.• Supply Chain Management (SCM) data warehouse • Developed and provided Life Cycle Support for numerous IBM InfoSphere Information Server (DataStage) Extract, Transform, & Load (ETL) processes.• Provide design and development support for PeopleSoft Asset Management (AM) and Supply Change Management (SCM), and Project Costing (PC) applications.• Provided Crystal Reports 2008 reports design and development support.• Created DataStage Developer’s Handbook, ETL Functional Design template, ETL Technical Design Template, Code Review Checklist, and Team Standard Operating Procedures (SOP).• Created, reviewed, and provided subject matter expertise on system architecture, design, and performance enhancement documentation for implementation of Commercial-Off-The-Self (COTS) and custom solutions. Show less

• 

  Mainline Information Systems

  Jun 2015 - now

  Information Architect And Technical Lead

  • Created IIS Datastage And Denodo Developer’s Handbook of standard practices, best practices, and other essential reference materials, governance approach documentation, including a conceptual design job aide and high availability architecture• Developed and performed ETL and data warehouse lifecycle support for salesforce.com, Logility Supply Chain Management (SCM), and multiple custom SQL Server ERPs• Analyzed, parallelized, and optimized existing Information Management infrastructure to improve performance and environment stability, including ETL Architecture, ETL’s, Scheduling, and Database objects (stored procedures, Indexes, views, maintenance practices, etc.) for SQL Server, DB2, Oracle, PostgreSQL, and Netezza databases• Performed data Modeling utilizing IBM Infosphere Data Architect and other tools• Create design documentation including Functional and Technical Designs, Source-To-Target-Mapping (STTM), Object Traceability, and Life Cycle Support Operations Manual• Served as IBM Infosphere administrator across development, testing and production environments, enabling, tuning, and multiple installations.• Updated, and improved stability of existing processes including ETL’S, custom stored procedures, views, and data model• Developed numerous windows batch and Korn shell scripts to support IBM Infosphere administration and scheduler integration• Served as an Information Management Architect for customers in the transportation, retail, manufacturing, insurance industries and academic research• Used Agile Management software suites including GitLab, Azure DevOps (ADO), ServiceNow, and JIRA.• Developed scripts and used R & RStudio application tools• Technical Lead for Observational Medical Outcomes Partnership (OMOP) including ATLAS and Achilles Show less