Business and Data Architect Resume

Summary

Over 15 years of IT experience in application development.
Over 10 years of data modeling; including facilitating business requirements sessions, building and validating conceptual, logical and physical models.
Over 10 years of Master Data Management (MDM); including meta data management and domain management.
Over 10 years of experience with data modeling tools; including Erwin and XMLSpy.
Over 8 years of establishing and mentoring data architecture guidelines and standards.
Over 10 years project experience in eCommerce and Customer Loyalty.
Self - starter. Able to drive projects and initiatives from start to finish with little or no supervision. Able to coach and guide team members to better and faster solutions.

PROFESSIONAL EXPERIENCE

Confidential

Business and Data Architect

Responsibilities:

Performing business process, data architecture and modeling for the major regional retailer in San Antonio. Developing and mentoring project team members on enterprise architecture best practices.
Collecting, analyzing and disseminating tasks to the managers of data integration, data governance and data modeling. Transforming operational data models (OLTP) into OLAP data warehousing models (star schema and 3NF).
Mapping project needs to primary data sources via corresponding integrations (data abstraction layer). Master Data Management (MDM) includes Product, Location (Store and Warehouse) and Customer Loyalty.
Designing data layer messages and corresponding XSDs. DBMS software supported include DB2, MySQL, SQL Server and Oracle. Major roles and projects include:
Lead Data Architect for the Customer Data Warehouse (CRM marketing tool included). Implemented in both Teradata and SQL Server.
Sole Data Architect for the Refunds system. Implemented on SQL Server, which comprises a 1 TB (terabyte) data mart.
Sole Data Architect for the new pricing system.
Sole Data Architect for many OLTP systems, including Incentives, Coupons and Demonstrations, Production Planner, Customer and Partner.
Lead Data Architect for eCommerce.

Confidential

Sr. Database Administrator

Responsibilities:

Mentored and led junior administrators. Collected requirements from business partners for the design and building of a Master Data repository for policy form and endorsement data.
Provided DB2 design and support for Java based Insurance systems using various DB2 V8 tools, including BMC Changeman and Administrative Products. Collected requirements logically modeled, transformed to physical model and implemented multiple structures; modeling performed using Erwin. Performed DB2 structure changes and migrated them through the SDLC.
Performance tuning efforts yielded 10 percent reduction of CPU consumption. On a rotation on-call for 24x7 support. Major projects included:
Lead DBA/Modeler for the eCommerce system which handled 95% of the company’s new business via agents.
Sole Architect/DBA/Modeler for the Customer Access system which processed all web-based applications and changes.
Sole Architect/DBA/Modeler/Analyst for the enterprise-wide Endorsements and Coverages service (SOA initiative).
Sole Architect/DBA/Modeler for the Java-based Policy Administration service (SOA initiative) and Agency Administration system.

Confidential

Sr. Database Administrator

Responsibilities:

Provided DB2 performance tuning for PeopleSoft financials, using various DB2 V5.1 tools, including BMC Apptune and Administrative Products. Scheduled and maintained DB2 utilities.
Performed DB2 structure changes and migrated them to various environments/instances. Participated in a team effort to upgrade PeopleSoft financials from version 6.5 to 7.52. On a rotation on-call for 24x7 support.

Confidential

Database Administrator

Responsibilities:

Provided DB2 performance tuning for various applications, using various DB2 V5.1 tools, including Platinum Technologies DB/2 tools, Omegamon, Strobe and Performance Monitor.
Coded and supported stored procedures for C/S application. Designed, developed and implemented a DBA expert system for the analysis and maintenance of over 5,000 DB2 objects. Scheduled and maintained DB2 utilities.