Senior Data Architect Resume
SUMMARY:
- IT consultant with more than 25 years of experience performing professional services on Information Technology Areas.
- He led a professional Team offering support, consulting and training services on Software Infrastructure for Critical Mission Applications having customers from different industries such as Financial, Government, Retail and Manufacturing.
- He had be a member of an architecture team for Ready Mix projects playing a role as DBA Senior, involved on Logical and Physical Database Design, Back End development, Replication Schemas design for distributed databases, performance and tuning database projects.
- He had led Ready Mix Projects for the different development Software Life Cycle phases.
- He had participated on multinational implementations for Ready Mix Solutions, leading local Countries DBA’s teams on implementation, stabilization and support of Applications using Distributed Databases and Data Replication Environments.
- He had Worked on Business Intelligence and Enterprise integration information projects for Near Shore companies as a Data Analyst and Data Architect.
- He had worked on Quality Assurance Software projects coordinating the Software Applications test phases.
- As a team member he had contributed on an active way to the successfully completion of the projects, understanding the urgency sense and always service oriented, keeping in mind the importance of teamwork.
KNOWLEDGE AND SKILLS:
MS SQL Server
Structured Analysis and Design
Sybase Adaptive Server Enterprise
Unified Modeling Language
Sybase Adaptive Server Anywhere
Microsoft Solutions Framework
Sybase IQ
Kimball Dimensional Modeling
Oracle
MS Analysis Services
Sybase SQL Remote
Sybase Replication Server
Sybase DirectConnect
Informatica PowerCenter
MS SQL Server Integration Services
HP/UX
IBM AIX
Sun Solaris
Linux
Microsoft Windows (Windows NT, Windows 2000, Windows 2003, Windows 2008)
Netware OS
PowerBuilde
PowerDesigner
Infomaker
Scribe SQR
Share Point
Transact SQL
ANSI SQL
Quotium Workbench
PROFESSIONAL EXPERIENCE:
Confidential
Senior Data Architect
Responsibilities:
- Coordinate and instrument the Sybase Platform upgrade on a Ready Mix Management Application for CEMEX Germany and CEMEX France at country levels.
- The Sybase Products upgraded were Sybase Adaptive Server Enterprise 12.5 to 15.5 and the Replication Infrastructure, was changed from Sybase SQL Remote to Sybase Replication Server 15.6 and Sybase Mobilink.
- The upgrade scope for Cemex Germany included a Consolidated Server, 4 Distribution Centers and 158 Ready Mix Plants.
- The upgrade scope for Cemex France included a Consolidated Server, 6 Distribution Centers and 314 Ready Mix Plants.
Confidential
Senior DW/BI Architect
Responsibilities:
- Architecture and Data Modeling of Data Warehouse and Business Intelligence solutions on a Near shore project for Lumina IT Services, integrating information from multiple Applications and Data Sources from heterogeneous platforms (Oracle, MS SQL Server, MySQL, Cache Intersystems) to MS SQL Server architecture, providing sales, commercial and performance product indicators.
Confidential
Senior Architect
Responsibilities:
- Coordinate the Cemex USA Applications Tests for the project to relocate geographically the Data Center, more than 40 Applications were moved, including major applications as SAP ECC, SAP CRM, SAP HR, SAP BW, Finance, Logistics, Management and Production applications, running on more than 370 Servers.
- Coordinate the Cemex USA Applications Tests for the Platform migration from HP/UX to IBM AIX for SAP ECC, SAP CRM, SAP BW and SAP HR applications.
- Advisor on the Migration to new Sybase versions and new Replication Technology project used on the Ready Mix Management Solution for CEMEX Ready Mix.
- Quality Assurance project to certify the New Common Operative Environment (COE) infrastructure to be used for the CEMEX Institutional applications, in total 180 Applications were tested.
Confidential
Senior Architect
Responsibilities:
- Near Shore Project for Steel Scape, constructing ETL Processes to integrate Enterprise information, getting information from SAP Master Data Catalogs to load to MS SQL Server for a Products Quotations Application.
- Near Shore Project for AMD, as a Data Analyst to construct a Business Intelligence Solution used by Price Analysts integrating SAP and Market Price Information.
- Technical Project leader for the construction for an application maintenance tool for CEMEX to maintain historical information for Ready Mix plants to reassign to a different Customer Service Branch.
- Technical Project leader for Reorganize Information for Ready Mix Plants from CEMEX to different Regional Zones reallocating 50 Ready mix plants to three dispatch Centers, leading the implementation of the built solution and coordinating the required information changes on each Ready Mix Plant.
- Technical Project Leader for the upgrade to a new version of Ready Mix Solution for CEMEX Ready Mix UK for all the country including Seven Dispatch Centers, 420 Ready Mix, Aggregates and Asphalt Plants.
- Technical Project Leader for the implementation of Ready Mix Management Application for CEMEX Ready Mix from El Salvador.
- Data Architect consultant supporting the migration Project to a new Ready Mix Management Application for CEMEX Mexico, USA and Dominican Republic, and helping to the knowledge transfer to Database Administrators team in order that they could perform the migration for different locations in Mexico, Spain, USA and South America CEMEX s Offices.
- Data Architect for Quality Assurance for new Ready Mix Management Application version for CEMEX
- Data Architect for the Implementation for Ready Mix Management Application for CEMEX Poland and knowledge transfer to the Database Administrators team in Poland involved in the implementation and the continuous operations.
- Data Architect for Quality Assurance for new Ready Mix Management Application version for CEMEX
- Data Architect for the Implementation for Ready Mix Management Application for CEMEX Poland and knowledge transfer to the Database Administrators team in Poland involved in the implementation and the continuous operations.
- Technical Leader for the implementation at Country Level for CEMEX USA for a Software component for transfer Transactional Messaging used as part of the information replication by Ready Mix Management for Distributed Databases.
- Data architect responsible of the Database implementation for Ready Mix Management Application for CEMEX Germany, including Four Dispatch Service Centers, more than 200 Ready Mix and Aggregate Plants and knowledge transfer to the Database Administrators team in Germany involved in the implementation and the continuous operations.
- Senior Database Architect responsible for the Data Architecture for the Ready Mix Management Application for CEMEX, performing Data Design Architecture, performance and tuning Data processes and Data Architecture replication for Distributed Databases
Confidential
Senior Architect
Responsibilities:
- Coordinate the Cemex USA Applications Tests for the project to relocate geographically the Data Center, more than 40 Applications were moved, including major applications as SAP ECC, SAP CRM, SAP HR, SAP BW, Finance, Logistics, Management and Production applications, running on more than 370 Servers.
- Coordinate the Cemex USA Applications Tests for the Platform migration from HP/UX to IBM AIX for SAP ECC, SAP CRM, SAP BW and SAP HR applications.
- Advisor on the Migration to new Sybase versions and new Replication Technology project used on the Ready Mix Management Solution for CEMEX Ready Mix.
- Quality Assurance project to certify the New Common Operative Environment (COE) infrastructure to be used for the CEMEX Institutional applications, in total 180 Applications were tested.
Confidential
Support and Consultancy Manager
Responsibilities:
- Creation for the Authorized Sybase Support Center for Mexico s North Region.
- Leader and Coordinator for the Technical Support Area for Microsoft s High end products.
- Leader for consultancy projects for Sybase s and Microsoft s infrastructure products.
- Support to the creation of the "Microsoft Certified Technical Education Center" (CTEC) for Actium.
- To play an important role to achieve the sign of two Sybase alliances with two very important Mexico Customers (CEMEX and Comercial Mexicana) for two Million Dollar each of them.
- Technical Leader for the most profitable Business Unit for the Group during five years.
Confidential
Technical Support Engineer
Responsibilities:
- Technical Support engineer for Sybase Products mainly Sybase SQL Server.
- Technical Instructor for Sybase SQL Server and Microsoft SQL Server Courses.
- The acknowledge by the customers for the Quality on the Support service provided and preferring it over the service provided directly by Sybase Technical Support Team.
