Enterprise Data Architect Resume
3.00/5 (Submit Your Rating)
SUMMARY
- Enterprise Data and Warehouse Architect with over 20 years of experience in leadership and development of enterprise data models and solution architectures, data warehousing assets, database design and development, business and process analysis, and strategic and tactical plans and solutions.
- Provides in - depth expertise as a trained facilitator leading teams, managing projects, and solving complex business problems with people, process, and systems.
- Full lifecycle hands-on experience with OLTP, data warehouse, business intelligence environments includes many years analyzing business needs, designing and building relational warehouses and dimensional data marts, planning and implementing ETL methods and tools, and covering requirements for Operational and Master Data Stores, Data Warehouses and Data Marts.
TECHNICAL SKILLS
Databases: Oracle, SQL Server, PostgreSQL, DB2 UDB.
Languages: PL/SQL, T-SQL, pgplsql, SQL/DDL/DML, JSON, VB, HTML, XML.
Cloud Platforms: Salesforce, NetSuite, Quickbase, TrackVia
Systems: Linux, Solaris, HPUX, AIX, Windows
Tools: ERWin, ER/Studio, Sparx Enterprise Architect, SSMS, Oracle Data Modeler, Magic Draw, System Architect, Composite Software, TOAD, Informatica Powermart/ Powercenter, Power Designer, Crystal Reports, Oracle Reports, Business Objects, Unica, CVS, Github.
PROFESSIONAL EXPERIENCE
Confidential
Enterprise Data Architect
Responsibilities:
- Key data architect supporting the development of enterprise architecture assets (conceptual/logical/physical data models) and assisting in large migration of in-house CRM/Accounting/Billing to Salesforce / NetSuite solution.
- Uses SQLServer 2014 and Sparx Enterprise Architect extensively supporting Zachman Framework architecture deliverables.
- Performed legacy and new system logical and physical mapping, source of record/master data management, JSON integration development and maintenance, security/data access mapping and management, enterprise data reporting, script building and process improvement for enterprise data management, Also focused on analysis and transition/integration of XMPie marketing solution.
Confidential
IT Solution Architect
Responsibilities:
- Analyzed company processes, data, and user needs while designing and developing enterprise project tracking solution at Confidential .
- Created custom Quickbase project planning, management and tracking solution integrated with estimate data from Comput-Ability software.
- Completed several client development and enhancement projects at ETM, solving a range of strategic architecture needs all the way through specific application improvements using TrackVia and QuickBase platforms.
- Performed full lifecycle stages of capturing requirements, analysis and architecture design, detail design, delivery and client acceptance.