We provide IT Staff Augmentation Services!

Senior Data Architect Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • I have significant experience (25+) in developing data architectures.
  • This includes both OLTP schemas and warehouse schemas suitable for deployment utilizing technologies like CloudBase, NOSQL, etc.
  • I know that the best architecture means the best code.
  • My experience as a developer has made this clear.
  • My expertise includes being able to distinguish the differences between processing data and utilizing data.
  • I have demonstrated an understanding that the term cloud computing means networks, hardware, storage, and services provided in a more standardized way.
  • Furthermore I understand that architectures exist independent of deployment and this is the advantage they hold.
  • The ultimate deployment of the architectures I have developed always reflects conformance to the unique needs of the enterprise.
  • I have a rare ability to produce the architecture but also aid in the development of the administration needed to support and evolve the architecture over time.
  • My current duties include the development of a standardized API to expose the underlying CRUD database procedures.
  • I have extensive experience in both deploying and configuring all aspects of DBMS servers (Oracle, DB2, SQL Server) to include developing tablespace architectures that properly leverage the physical database design.

SPECIAL SKILLS:

I possess a bachelors degree from an accredited college with over 20 years or more of professional experience; I am considered an expert / authority in the data management discipline

TECHNICAL SKILLS:

  • Oracle 10G
  • APEX
  • PL SQL
  • OEM Console
  • SQL Developer
  • ODBC
  • JDBC
  • JAVA
  • Eclipse
  • JavaScript
  • ERWin
  • PowerDesigner
  • MapForce
  • XML Spy

WORK EXPERIENCE:

Confidential

Senior Data Architect

Responsibilities:

  • Provided enterprise architecture data modeling support
  • Implemented physical database architecture
  • Provided MDM architecture design support
  • Provided data analysis services in support of several cloud architecture initiatives, This included converging element universes via myriad data correlating activities
  • Designed and implemented ETL in support of an enterprise MDM hub
  • Provided DBMS performance tuning services
  • Developed nd implemented a warehouse / decision support reporting architecture

Confidential

Senior Data Architect

Responsibilities:

  • Architected both the OLTP and warehouse layers of the information architecture
  • Worked with Oracle SA to configure OHS to utilize CASPORT
  • Developed SOAP envelopes and processes to utilize CASPORT services
  • Managed project from vision to implementation
  • Designed the conceptual architecture
  • Designed and implemented the physical architecture
  • Gathered business rules
  • Translated business rules into user requirements
  • Translated user requirements into system requirements
  • Developed the application interface using Oracle APEX
  • Developed the business layer using PL SQL and JAVA,
  • Created design artifacts using ERWin

Confidential

Senior Data Architect

Responsibilities:

  • Data Warehouse Architecture Development (Oracle) /Data Model Development Utilizing Popkin System Architect
  • Physical Model Implementation …
  • Business Translation Into Logical and Physical Data Models
  • Data Conversion Tasks Utilizing Informatica
  • Overall Data Management Strategy Development and Implementation
  • OLTP Schema Development
  • Heterogeneous ETL Strategy Development
  • Comprehensive Data Analysis
  • Business Rule Development

Senior Data Architect

Confidential

Responsibilities:

  • Data Conversion Tasks Involving VSAM and DB2
  • Development of logical databasedesigns
  • Transition logical database designs to physical database designs
  • Provide end user/database consultation support
  • Knowledge Management
  • Enterprise Data Warehouse
  • Architecture Development (Oracle Platform)
  • Data Model Development Utilizing ERWin Enterprise Business Analysis to include Business/Subject Area Identification and Definition
  • Conducted Data Management Presentations
  • Designed the database architecture for Air Cargo’s large scale modernization project utilizing CA’s ErWin modeling tool set.
  • Created the next generation of Air Cargo’s database environment. This included creating SQL Server 2000 subject area databases (8 Accounting, Contracts, etc…) to house the database objects tables, views, and stored procedure for those functional areas. This architecture supports Web based applications in all the tiers of N - Tier architecture. wrote wrapper classes in VB.net for stored procedures.
  • Created a migration warehouse that included SQL Server databases under NT 4.0, FoxPro DBFs, XML Files and Access databases so that these heterogeneous sources looked like on migration staging database in SQL Server 2000.
  • Devised and implemented the DBMS security strategy utilizing trusted connections, MS OS 2000 Groups and SQL Server roles.
  • Configured DBMS for maximum performance. Prototyped the physical server architecture for fail-over server topology and a disk configuration that took advantage of SQL Server’s physical abstraction layers.
  • Installed the DBMS (SQL Server) software
  • Configured DBMS
  • Develop and implement procedures to maintain the DBMS environment
  • Transition logical database designs to physical database designs
  • Implement physical database structures
  • Provide query optimization support to application developers

Environment: DB2SQL ServerOracleERWinVB.netTransact SQLPL SQLXML

Confidential

Senior Data Architect

Responsibilities:

  • Reviewed the database design and provided improvement recommendations.
  • Incorporated some improvement recommendations and helped the other data architecture team member (Oracle background) physically implemented the design.
  • Performed schema modification utilizing the ErWin compare facility. ErWin was used to tightly manage the database configuration.
  • Database Management duties included providing support for the development staff after hours and on weekends. Scripts for Constraint Enable/Disable and Identity Column Insert Enable/Disable were developed. A cache of initial data was maintained for initial deployment and this data was subsequently loaded by a script. Participated in devising DTS and single stored procedures to produce a repeatable build process for final deployment.
  • Modified both server and database configurations for DBMS optimization.
  • Developed stored procedures and instructed the COM+ developers in the construction of the same. Devised and implemented stored procedure development guidelines.
  • Worked with team members at all levels to insure that pertinent database considerations were addressed.
  • Capacity Planning for the final deployment environment was devised to include the development of a comprehensive filegroup strategy that utilized SQL Servers abstraction layer to highly leverage parallel processing opportunities as well as disaster recovery considerations.
  • Benchmarked database performance utilizing testing tool that simulated multiple concurrent web users.

Environment: SQL Server 7.0MS Transaction ServerTransact SQLVB6COM+ASPClear Case configuration management)TCPIPOLTP DesignOLAP DesignERWin

Confidential

Senior Consultant

Responsibilities:

  • Performed all data design and analysis work listed below utilized the ErWin modeling tool.
  • Led JAD Team Design session for the administration of negotiated union employee member benefits system.
  • Created the logical design for this system and provided a cross- document outlining the system’s interaction with the database.
  • Reviewed legacy database design and devised revisions to support the FDIC prototype usage of IBM’s Websphere facility (Websphere was to be utilized to make access to FDIC’s mainframe data more N-Tier compatible. Basically the mainframes would look and be accessible like any other server. ).
  • Devised a multi-user MS Access application that warehoused information form files, MVS DB2 Database, and SQL Server databases to evaluate the feasibility of upcoming IT projects.
  • Assessed the resource impact of all upcoming FDIC IT projects (130 +)
  • Revised the FDIC data administration guideline document.
  • Revised the FDIC data analyst and database administration interaction guidelines documentation.

Environment: ERWinFull Life Cycle Planning and ImplementationMVSDB2SQL ServerMS AccessMS Office, and Oracle.

Confidential

Director Of Information Engineering

Responsibilities:

  • Created the architecture for a Association application,
  • A convention logistics application,
  • Created the architecture for a convention/session management application
  • Created the architecture for a conference room scheduling application, and
  • Created the architecture for a billing application.
  • Facilitated Department Directors and VPs participated in the development of the OLAP architectures. All architectures take advantage of the Star Schema topology for excellent dimension scalability. The design of the enterprise architecture stratifies business facts so that deriving pertinent information via warehouse/decision support schemas is accomplished with relative ease.
  • Acted as project lead in the development of the billing system. This included conducting design sessions with department directors.. Working with the comptroller to insure account management functionality and working with the finance and teams to insure system migration accuracy during parallel processing and final production stages.
  • Managed Cold Fusion, VB and ASP outsourcing efforts to include providing database design services for all outsourcing efforts.
  • Implemented database objects (views, stored procedures, tables) for all legacy systems (Several thousand).
  • Provided technical hands-on leadership for the construction of stored procedures, objects, ASP pages etc that utilize the database.
  • Maintained a production database management environment that experienced no outages over a four
  • Managed, supervised, coordinated trained & developed activities of staff (database administrators, systems analysts, and GUI Developers - in-house (3 people) outsourced - (the number varied)).
  • Enforced company policies, analyzed & improved production methods.
  • Led significant DBMS migration efforts

Environment: MS SQL Server 4.21MS SQL Server 6.5MS SQL Server 7.0MS Transaction Server, MS Access, ODBCTCPIP Transact SQLStored ProceduresSQL optimization, View design, TriggersOLAPBCPOLTPERWin

Confidential

Information Engineer

Responsibilities:

  • Constructed data models utilizing ADW and Erwin.
  • Implemented physical databases in INFORMIX in a UNIX environment in support of a DOD executive information initiative.
  • Mentored junior data modelers on logical database design.
  • Facilitated evaluation sessions and conducted analysis review sessions.
  • Conducted model reviews across all military ranks and organization management levels.
  • Produced written deliverable design materials.
  • Presented white paper on Data Warehousing benefits (repository services)

Environment: ERWinIDEFADWMS AccessMS Office

Confidential

Technical Task Leader

Responsibilities:

  • Performed project level DBA duties.
  • Performed logical and physical database design. In a mainframe OLTP environment
  • Transitioned logical design to physically implemented tables and views in an MVS/XA DB2 environment.
  • Acted as technical lead in the implementation of a budget management system utilizing the DB2 database management system.
  • Implemented and constructed applications on a mainframe platform using the DB2 DBMS.
  • Managed a small (2-person) application maintenance and development team.
  • Evaluated the projects database model design.

Environment: DYNAMIC SQLCICS OLTP (Command Level)VSAMADABASE/SQLSQLDBASE IIITSO/ISPFRPFQMFJCLC++ (Borland Object Windows)COBOLCOBOL IIDB2ROSCOEOS MVS/XA

Confidential

DBA / Data Administrator

Responsibilities:

  • Assumed DBA responsibilities for the DIAL 1 call processing division.
  • Transferred Call 1 DBMS resources from one service bureau to a new service bureau.
  • Restructured tablespace to table configurations so that each table had one tablespace.
  • Changed tablespace to table configuration so that individual table recovery was possible.
  • Devised the back-up and recovery schedule.
  • Set up back-up and recovery JCL jobs.
  • Participated in high level product design meetings.
  • Developed logical designs for new product offering and Transitioned those designs to physical implementations.
  • Performed standard DBMS maintenance activities such as running utilities to reclaim space on existing storage volumes as well as designing and implementing databases for new product offerings.
  • Performed capacity planning.

Confidential

Senior Consultant

Responsibilities:

  • On assignment with Confidential, provided consulting support for DB2 development, data modeling SQL evaluation, and data design support.
  • Provided technical expertise in developing on-line and batch DB2, and ADABASE applications in support of Confidential Customer On-line Registration Systems using COBOL II and CICS and involving terminal detached multi-region processing applications.
  • Developed on-line query applications, including the Network Data Mover batch application for transmission of output between data centers.
  • Used Data Manager Data Dictionary for documentation.
  • Performed analysis, database design, programming, testing and implementation of a Pilot and Safety system utilizing CICS, DATACOM DB, COBOL II, VSAM, and TSO.
  • Designed database structures and developed supporting applications. The system ran OS/MVS/XA on an IBM 3084 mainframe.
  • Performed maintenance on the Air Operation System
  • Acted as Team Leader in performance of duties that included modifying a CICS system that was primarily conversational and making it pseudo-conversational using CICS, DATACOM DB, COBOL II, VSAM, and TSO.
  • Performed maintenance on DB2 applications supporting an IBM X12 data transfer application.
  • Created DB2 test environment identical to the one running in the production system.
  • Created table spaces and tables and used DB2 utilities to lead data and produce image copies.
  • Under severe time constraints, applications were modified so that the correct information was produced and transmitted to end users at remote processing sites. This application ran utilizing the VM Operating System.

Environment: DYNAMIC SQLCICS OLTP (Command Level)DATACOM DB/DCVSAMADABASE/SQLSQLDBASE IIITSO/ISPFRPFLOTUS 123QMFJCLSYMPHONYCOBOLCOBOL IIDB2ROSCOEADABASE/SQL

We'd love your feedback!