Manage and lead development of Data warehouse and Business Intelligence Solutions that meet customer requirements and exceed their expectations.
Experience
Sabre Holdings
Principal Data BI Architect, Sabre Hospitality Solutions Division
Currently working on establishing Business Intelligence Strategy for SHS, studying current reporting state, tools, needs of different business units, determining gaps, opportunities and laying vision, integration strategy, tools and road map for future.
Developing Enterprise Dashboards using QlikView for Senior Management.
Led Data Model development, Database Design, ETL Design and Development for loading these data into Teradata Warehouse using Oracle ODI.
Established Data Integration strategy across Salesforce.com, Avaya and RedX Booking systems and worked with their teams to load data into Teradata Data warehouse.
Led architecture, development and implementation of Call Center Reporting Solution using Teradata and Cognos BI
Led Cognos BI development - Building Framework Model and Report Studio / Event Studio components for reporting to hundreds of customers worldwide.
Principal Data Architect , Sabre Holdings
Led design and implementation of Travelocity's Enterprise Reporting.
Development of Data Model, Design of Aggregation Strategies Summary tables, Join and Aggregate indexes, Partitioning strategies in Teradata database.
Establishment of Data Security Model in Teradata/ Cognos Framework Model to ensure that reports are accessed by Sabre worldwide customers without data infringements.
Development and deployment of Cognos Framework Model and Report Studio Reports to be sent in an automated fashion to thousands of customers worldwide.
Led TDQM Total Quality Data Management of the Teradata Warehouse a strategy of a combination of ETL metadata capture to defining and setting of data alerts by Source System to alert Quality Issues of data flowing into the Data warehouse.
Data Architect/Developer for Traveler Analytics defined strategies to integrate data from Ticketing, Service History, Customer Profiles and Reservations systems into Teradata Data warehouse. Helped develop Cognos Powerplay app for use by Airline Customers to view/slice/dice integrated data for driving operational decisions.
Built consensus across Marketing users on definition and reporting of Dimensions and Measures and to form algorithm to score customers Life Time value.
Created unified data model across Airlines/Hotels ERWIN with flexible scoring options to enable product to conform to different Data Privacy practices across world.
Developed Teradata Macros for scoring customers and Business Views for use by Cognos applications.
Worked with Vendor Vistrio in merging Travelers data in warehouse with demographic public domain data and used segmentation analysis using Teradata TRM to create 17 different Customer Segments for use by Sabre applications.
Senior Data Architect/DBA
Architecture, design and development of Sabre Virtually There Website Reporting
Design of Data Logging standards for use by Website development team.
Design and development of ETL Process using PERL, Shell Scripts.
Installation and design of tables for Oracle database using 3NF/ERWIN Data model tool.
Development of GUI Interface for Internal users using Cognos Impromptu / Powerplay.
Built Data Content Management System a set of views/scripts/processes that consolidates data from three different sources Worldview Oracle database, WCities XML data content and Zagat Access database into a single Oracle Content Store and enable Marketing Users of Sabre to select content dynamically for use by Sabre applications.
Set up standards for reporting of Sabre Virtually There Website metrics to external organization ABC Interactive and established audit policies for generating the numbers reported.
Database administration of Informix 7 databases for Sabre Energy Network project tables, indexes, backup / archival, establishing HDR replication between two instances for 24x7 operation, development of automated scripts to promote releases of scripts across different instances.
Database administration of Oracle database 7/9 for Navy Training project tables, indexes, backup / archival, user and rights administrations, roles setup and admin, tablespaces, RAID storage
Database administration of Sybase database 4.8 for Avis project tables, indexes, backup / archival, user and rights administrations, Development of Stored procedures, triggers, user-defined datatypes. Also performed extensive performance tuning on all Sybase applications.
Privacy Policy
