Interact closely with Vertical teams to provide them with BI & Big Data solutions as part of BI & Big Data Practice objective. Ensuring that the consulting provides the considerable value proposition in BI & Big Data Analytics business. E2E Solution Designer/Lead Data Modeler with 8+ years of industrial experience in enabling BI projects, writing E2E Solution Design document and designing EDW/Data Marts for diverse business clients. Interacts with core Business Users and SMEs for understanding functional requirement, produce and own the E2E Solution Design Document which works as the reference for the technical implementation. Have vast experience in implementing Industrial Data Models like Financial Services Logical Data Model (FSLDM) and Manufacturing Logical Data Model (MLDM). Have designed various Semantic Layer Data Models (Dimensional Models) for BI reporting and analytics. Planed for collection method, data cleansing, and normalization of enterprise data to support decision making and reporting.

BI & Big Data Architect @ Interact closely with Vertical teams to provide them with BI & Big Data solutions as part of BI & Big Data Practice objective. Ensuring that the consulting provides the considerable value proposition in BI & Big Data Analytics business. From December 2014 to Present (1 year 1 month) Data Modeler & E2E Designer @ Interacting with Users, SMEs and BA for gathering requirement and providing end to end solution in HRA. Working with different tower leads to make sure the design follows the standard defined by Unilever. Working as an ETL lead and handling team of 12 resources working on BODS ETL tool and providing ETL design documents and transformation logic for loading EDW (centralized data base for maintaining Unilever Employee related information). From October 2013 to December 2014 (1 year 3 months) Data Modeler @  Interacted with Users, SMEs and BA for gathering requirement for MIP R3B ‘Media Spend’.  Analysis of the existing MIP releases models in EDW to maximize the reusability and deliver MIP R3B with additional concepts modeled.  Worked extensively with business users/SME in validating conceptual and logical models in detail.  Worked with Tower Leads for getting the model reviewed both in terms of business requirement fulfillment and catering EDW standards. From October 2012 to September 2013 (1 year) Data Modeler / ETL Designer @ Worked as Data Modeler for Great Estern Projects (Insurance). • Worked closely with Users (GE Insurance) and SME to gather requirements for Data Model and prepared Conceptual model. • Worked as a Data Modeler for creating Insurance downstream data model (Life and General Insurance). • Designed Logical Data Model for diverse insurance business (Life, GI (Health, Accident, Home, Travel, Liability, and Motor)). • Designed Logical Data Model based on OCBC, Bank specification document and BRD. LDM created after studying detailed URS (User Requirement Specification). Modeled 2000 URS data point (business requirements). • Created 8 Subject Areas (Agreement, Claim, Product, Proposal, Event, Fund, Party and Campaign). • Designed 48 entities with 4000 attributes for incorporating 7 source systems (Life and GI). • Created Physical Data Model. • Done Volumetric Analysis and reporting. • Created Traceability Matrix for providing full details on fulfillment of business requirements. • Created Data Dictionary. • Published Downstream Data Architecture document. • Designed X-Map tables and B-Map. • Designed Party SA, for incorporating SVC (Single View of Customer). From June 2011 to September 2012 (1 year 4 months) SingaporeData Modeller / ETL Designer in Barclays, Pune @ Worked as ETL Designer and Data Modeler in Insurance and Banking Projects. Contribution as Data Modeler, Business Analyst • Working closely with Users (Bank) and SME to gather requirements for Data Model and prepared Conceptual model. • Working as Business Analyst and Data Modeler for creating Income Insurance data model. • Designed Logical Data Model based on Barclays feed specification document and BRD. • Created Physical Data Model for Data Mart and LTDS using ER Studio. • Done Volumetric Analysis and reporting. • Published Master Data Mapping sheet will source to target business mapping logic for AbInitio graph development. • Created Data Dictionary for both Data Mart and Long Term Storage data bases. Contribution as ETL Designer • Published High Level Design for Income Insurance: The design contained project purpose and in scope activities, E2E business flow diagram and description, Business requirements and RAID. • Published Detailed Design: Gathered requirements, created functional specifications and published detail design for implementing the ETL. The design contains the database design description, ETL logic and data archiving strategy, RAIDs. • Created Mapping Design Documents and incorporated Business Transformation logic. • Prepared extended-LDM sheet containing the volumetric analysis. • Worked closely with SI partners (Build Team & Testing Team) for deploying SIT perfectly. • Written Test Cases for A>I ETL graphs testing. From August 2009 to August 2011 (2 years 1 month) Pune Area, IndiaDeveloper (Data Warehousing : Informatica) & Data Modeler @ Worked as ETL Developer for GE projects using Informatica. Contribution as ETL (Informatica 8.1) Developer • Performed extraction, transformation, and load (ETL) programming functions as directed by the user requirements. • Created 16 different complex and medium level mappings for populating data from ERP to Staging Tables, Staging Tables to Dimensional Tables and finally to fact Tables. • Gathered requirements, created functional specifications, implemented and completed projects within establish time frames and resource constraints. From January 2007 to August 2009 (2 years 8 months)

Bachelor of Technology (B.Tech.), Computer Science @ Greater Noida Institute Of Technology From 2002 to 2006 D.A.V. Ara Nilabh Sahai is skilled in: Business Intelligence, Big Data Analytics, Hadoop Eco System, HBase, Hive, Data Modeling, Data Architecture, Data Warehouse Architecture, Data Warehousing, Database Design, Dimensional Modeling, Data Marts, ETL, Informatica, Requirements Analysis