We provide IT Staff Augmentation Services!

Data And Enterprise Architect Resume

AustiN

SUMMARY:

Enterprise Architect with over 30 years IT experience. Customers include almost all major US retailers and many Fortune 500 companies.

WORK EXPERIENCE:

Data and Enterprise Architect

Confidential, Austin

Responsibilities:

  • Involved in complex Architecture with over 250 MS SQL & Oracle Databases
  • EA Analysis/approval and high - level design of proposals for new projects or enhancements of existing ones
  • Platforms include .NET and Pega, with OSB for SOA
  • PDR (Preliminary Design & Review) based on Epics / Sub-Epics / User Stories Confidential the initial planning stage of projects
  • Cloud (Azure and AWS) Suitability Analysis and Costing, following the VA’s “Cloud First” policy
  • Migration applications from On-Prem to the Cloud
  • Familiarity with TOGAF / DoDAF
  • Contribute to the creation of and adherence to Enterprise Design Patterns
  • Regularly attend scrum / kanban calls on projects that need EA support
  • Participating in the initial stages of the adoption of SAFe
  • Data Architecture with Oracle and MS SQL Server
  • Data Modeling (E-R Diagrams) using TOAD Data Modeler for over 250 DBs
  • Data Models include Conceptual, Logical and Physical Data Models

Managing Consultant

Confidential, Austin, TX

Responsibilities:

  • Technical Architecture and performance tuning for Sterling OMS (including 9.2.x and 9.3) with Oracle and DB2 as the back end
  • Belonged to the Smarter Commerce Practice Confidential GBS
  • Collaborated with teams in India on a daily basis
  • Last worked with a retailer in Boston, MA as Support Lead

Senior Technology Architect

Confidential, Austin, TX

Responsibilities:

  • Technical Architecture and performance tuning for a Java-based suite of supply chain software (Sterling MCFS)
  • Belonged to the Confidential Practice Confidential Infosys
  • Collaborated with teams in India on a daily basis
  • Worked with one of the largest retailers in the world

Technical Architect (Consultant)

Confidential, Austin, TX

Responsibilities:

  • Senior Consultant achieved a high degree of customer satisfaction, with a high billable rate and over 70% utilization
  • Handled many large enterprise installations including Major Retailers and Fortune 500 companies, both domestically and internationally (UK, Brazil)
  • Short, high-pressure on-site autonomous, independent assignments that include interactions with Senior Executives, and produce visible, measurable, demonstrable results every time
  • Technical Architecture and performance tuning for a Java-based suite of supply chain software (MCF), and network business process software (GIS) that handles EDI transactions and B2B communications
  • Many combinations of technology stacks, including WebSphere, WebLogic, DB2 (UDB), Oracle, MS SQL Server, AIX, HP-UX, Linux, Windows, Confidential & Sun JVM’s, MQ Series, Tibco, etc.
  • Coordinated and collaborated with team in India to deliver cost effective, customized solutions

Consulting DB2 UDB DBA (Data Warehouse)

Confidential, San Antonio, TX

Responsibilities:

  • Worked on DB2-UDB/AIX & Windows systems on a 60-day Contract
  • Performance tuning for data warehouse on AIX
  • Solving issues with data residing on a SAN
  • Validating physical design of database
  • Backup / disaster recovery process definition

Application Architect

Confidential, Amarillo, TX

Responsibilities:

  • Data Modeling for an OLTP database
  • DB2 UDB Performance Tuning
  • Helped with coding DB2 UDB Stored Procedures and Triggers
  • Helped with AIX (ksh) Scripting

Database Architect

Confidential, Austin, TX

Responsibilities:

  • DB2-UDB/AIX/Data Warehousing/Java Programming
  • Data Modeling for a Data Warehouse
  • DB2 UDB Performance Tuning
  • Coding DB2 UDB Stored Procedures and Triggers
  • AIX (KSH) Scripts
  • Java Programming using WSAD / WSSD

Seibel Performance Specialist (Independent Consultant)

Confidential, Indianapolis, IN

Responsibilities:

  • DB2(UDB)/AIX Performance Tuning for a Siebel call center implementation.
  • Analyzed Siebel Object Manager logs for performance issues
  • Mentored the client in the use of Siebel OM logs
  • Analyzed slow SQL statements using db2exfmt and explain
  • Slow-running Siebel views increased in performance by 75% due to SQL tuning
  • Examined indexes in the Siebel Data Model and recommended additional indexes as needed
  • Helped define strategy for migrating DB2 7.xx to DB2 8.1
  • Created monitoring database / application using Oracle 9i for troubleshooting

WebSphere and Oracle Specialist

Confidential, Austin, TX

Responsibilities:

  • WebSphere 4.06 and 5 / Java / AIX 5.1 / Rational Suite / Oracle 9i
  • Web performance tuning (WebSphere, Confidential HTTP Server, AIX, Java).
  • WebSphere system administration and monitoring.
  • Oracle 9i database performance tuning
  • Architecting network topology for the agency.

Sr. Consultant

Confidential, Austin, TX

Responsibilities:

  • ASP Production support.
  • Informix Database development.
  • Implemented QA Processes and Managed QA.
  • Wrote complex SilkTest (Segue QA Partner) scripts to automate testing.

Sybase / Facets Performance Consultant

Confidential, Tacoma, WA

Responsibilities:

  • Used Deloitte / BCBS SDLC processes from Business Analysis through Integration Testing.
  • Sybase performance tuning. Reduced time taken to execute some procedures from 3 hours to 30 seconds.
  • Wrote complex stored procedures to provide input to Crystal Reports / Crystal Enterprise.
  • Created reports using Crystal Reports 8.0
  • Database design of Data Warehouse for reporting purposes. ERWin as the data modeling tool.

Application Architect / Team Lead

Confidential, Austin, TX

Responsibilities:

  • Java / WebSphere / DB2 / UNIX Financial application for Confidential Global Finance (IGF)
  • Architected DB2 / WebSphere / Java web application, Account Management Tool World Wide (AMTWW), enabling IGF customers to send remittances, resolve disputes and view account details on the Web, supporting users initially in North America, Europe and Asia-Pacific in 13 languages and multiple currencies. Creates Web front end to legacy AS/400 application.
  • Coded bridge program in Java (JDBC), mapping and moving data between Web and Legacy databases. Handled complex application logic and transformation of DBCS data from the Host EBCDIC character set to UTF-8.
  • Designed Web database and collaborated with Host AS/400 team to define an interface for data exchange between Web and Host.
  • Led team of 6 offshore developers located Confidential Bangalore, India.
  • Sent by Confidential management to Bangalore, India for 2 weeks in March, 02 to review team’s progress and introduce new processes, which resulted in accurate project status reporting, improved monitoring and lesser defects.

Sybase / DB2 DBA

Confidential, Austin

Responsibilities:

  • Sybase / DB2 DBA (part- time), American Cancer Society, Austin ( Confidential )
  • Refined replication strategy between DB2 databases on the Mainframe, 28 SYBASE / NT servers in 11 locations and 7 DB2 UDB databases on Windows NT.
  • Optimization of Sybase queries on Sybase 11.51 databases.
  • Extraction of data from Sybase databases into Sybase tables to support the ACS Siebel effort.
  • Maintained the 7 DB2 UDB database instances and DB2 Connect servers.

IT Architect

Confidential, Austin

Responsibilities:

  • Planned move of Domino servers from NT to AIX. Evaluated Confidential ’s SHARK Storage Area Network.
  • Evaluated other products that could replace existing Domino / Notes based servers.
  • Troubleshot performance problems in an environment consisting of 62 Domino Servers on NT.

Hire Now