Enterprise Data Architect And Consultant Resume
4.00/5 (Submit Your Rating)
SUMMARY:
- Results oriented, enterprise level IT leader with over twenty years of technology industry experience with solid hands on technical skills and experience.
- Specialized in team building, data conversion, Database Architecture, Design & Administration, Monitoring, Performance Tuning, Script development and development of best practices.
SKILLS & EXPERTISE:
Database support for Oracle, Microsoft SQL Server, Sybase, NoSQL Couchbase and Mongo.
OBIEE, Tibco Spotfire, Tableau.
Enterprise Architecture, Data Migration, Database Design, IT Strategy, High Availability, Integration, SDLC, Business Process Improvement, E - commerce, Quality Assurance
EXPERIENCE:
Enterprise Data Architect and Consultant
Confidential
Responsibilities:
- Develop database models for several industries. Work include creating logical and physical database models and architecture documentation for the management and executive teams.
- Developing Travel industry solution, using Azure cloud, from inception to completion. Efforts include choosing database technology, pricing, auditing, replication and encryption model, designing and building databases (utilizing PaaS and SaaS offerings). Work also includes developing stored procedures, functions, and loading preferences and lookup data.
- Work closely with customers to develop a strategy for choosing the right database platform and subsequently develop best practices for adoption, conversion and implementation.
- Analyze database implementation methods and ensure they are in line with company policies and any external regulations that may apply.
- Provide consultation on changing data and database needs and come up with related solutions.
Managing Director of Data Services
Confidential
Responsibilities:
- Responsible for database architecture, design, development and production support of Confidential Oracle, SQL server, Teradata, Mongo and Couchbase databases supporting internal and customer facing database environments including the company website (confidential), mobile application, kiosk, web check - in, ticketing, payments, merchandizing, revenue management, sales, marketing and finance. Many of these databases are available 24X7 and are very high outage cost environments.
- Responsible for the main Oracle Enterprise database systems responsible for running United’s main website, reservation, ticketing, trip alert and marketing systems. The databases are the operational repositories for all Customers data, Reservations history and Ticketing info. It ran on highly available cluster HP super dome Unix server. Migration efforts were under way to migrate to Oracle Super Cluster utilizing latest technology in Exadata storage cell and cache offerings.
- Established a data governance practice Using Collibra and started the build of United MDM.
- Responsible for the successful merging of United and Continental airlines data after the companies merged in 2011. Developed a migration mechanism that saved United over 5 million dollars in consulting and software purchase saving.
- Planning and budgeting for infrastructure purchase and upgrades, project hardware, software and personnel staffing for on-going support and multi-year development projects.
- Slashed database team payroll budget by 25% by consolidating responsibilities, reducing head count and by offshoring junior level DBA tasks to an offshore company.
Senior Manager/Director of Technology
Continental
Responsibilities:
- Responsible for the overall support of all Continental Airlines SQL Server and Oracle databases.
- Support was focused on the area of maintenance, optimization, security, availability and recoverability.
- Built a great database team, hired the right personnel, trained them effectively and provided a great support model across the company.
- Team received many accolades for the great support, efficiency, and competency.
- Supports of more than 500 SQL Server databases.
- Supports of more than 50 Oracle enterprise databases.
- Developed a log shipping solution (not using MS techniques) to move 35 databases to a new data center with less than one hour of down time. The largest database was 4 Terabyte.
- SupportingBi-directionaland transactional replication in a clustered environment.
- Responsible for upgrading all databases to the latest supported version.
Database Administrator/ DBA Manager
Confidential
Responsibilities:
- Provide total scope of DBA work including design, development, implementation, and performance tuning and production support of all SQL and Oracle databases.
- Played crucial role on the successful migration of Mainframe data into relational databases platform ahead of W2k drop down deadline.
- Monitor servers’ performance and reliability and improve the infrastructure to support scaling to the entire enterprise.
- Evaluate and recommend software and practices to improve the operational efficiency and management of the environment. Work with and manage vendors and consultants with respect to software upgrades, operational tuning and system implementations.
- Develop a set of processes and tools to ensure the protection and integrity of data. Interact with business professionals to assist in the development, testing and implementation of new systems.
System Analyst
Confidential, Houston
Responsibilities:
- Technical lead responsible for re-hosting supporting several Confidential applications
