Febin Francis Email & Phone Number

United Arab Emirates, Dubai

• Lead the design, development, and implementation of complex analytic solutions by applying expert level understanding of Business Intelligence best practices.
• Use the latest Business Intelligence development tools, methods, and technologies to implement high performance, complex analytic solutions
• Overseeing the ongoing development and operations of a business intelligence architecture that enables fact-based decision making and ad-hoc analysis.
• Responsible for consulting with different departments on business needs, translating business needs into analytics/reporting requirements. Responsible for preparing detailed report specifications document.
• Implementation of and the transition to OBIEE as the preferred enterprise reporting software
• Solely responsible for architecting OBIEE solution to analyze Enterprise case management and new risk engine systems

Mumbai Area, India

• Delivery of the data warehouse system for a leading depository in India
• Project management in terms of costing, resource
• Gather Technical and Business Requirements which includes source information analysis and prepare gap analysis
• Design the data model for the warehouse based on the business requirements.
• Design the ETL architecture considering multiple legacy source system and flat files
• Tech support to ETL and OLAP team in during the development

Saudi Arabia

• Responsibilities:
• Assess the current architecture setup and analyze gaps
• Capture Business Requirements
• High level Information Analysis and Prepare gap analysis
• Understand information flow/source data structures/data quality
• Propose high level Logical Data Model

India, Brunei

• Project: Telecom Data warehouse Responsibilities:
• Onsite Coordinator
• Requirements Gathering, Information analysis
• Logical Data model design in Star Schema
• Developed ETL mappings using Hummingbird Genio to populate the data warehouse model from the transactional systems.
• Business Objects (6.5) Universe design and Reports development

India, USA

• Project: IHOP Data mart.Responsibilities:
• Create BO Universe based on the data warehouse data mode and Create BO desktop reports based on the report specification document.
• Implemented optimization techniques to enhance performance of the queries dynamically generated by BO
• Create users and assigned privileges using supervisor module and implement row level security on reports based on the location.Project: Media-base Data martResponsibilities:
• Perform the OLTP study; design the Schema, Logical Data Model (LDM) and Physical Data Model (PDM).
• Writing PL/SQL scripts to populate the data from source database to data mart database tables.

B.E, Mechanical

Education record