Narendra Pandya

Director Business Intelligence at Western Governors University


Office Hours

How does this work?

Narendra Pandya has over 20+ years of experience in Business Intelligence and IT. Presently working with Higher Education - Western Governors University. Created Enterprise Data Warehouse for all the executive reporting needs at WGU. The journey started with the role of faculty and subject matter expert in Business Intelligence Reporting - BusinessObjects and Cognos. Custom based training for customers and clients tools. Moved on to Lead the Center of Excellence (CoE) for BI competencies. Architecting and developing Enterprise data warehouse solutions for companies that feeds the Business KPI and Dashboards. In the current role as Director of Business Intelligence, Narendra is leading a team of BI developers and architect working on data acquisition and presentation. Managing and reporting business KPIs and operational reporting for all departments at WGU. Next in the line is architecting and developing cloud based EDW 2.0 for the growing needs of the organization. Specialties: Reporting Tool: Tableau, Apache Spark -Databricks, BusinessObjects XI , Administration, Cognos 11 Oracle APEX 4.x, Xcelsius 2008, Crystal Reports 2008, Oracle BI Enterprise Edition (OBIEE – Answers, Interactive Dashboard, Delivery), BO performance Management, SAP integration with BusinessObjects,BIRT. ETL: BusinessObjects Data Serverices 3.2 (BODI), Informatica, DataStage Enterprise Edition 7.5x2, TALEND Open Source BI Tools: SPAGOBI , Cloudera HADOOP , HIVE Database: Oracle 11g, MSSQL svr, Microsoft SQL Server

Work experience

Jul 2017 - Present

Western Governors University

Director Business Intelligence


Nov 2012 - Jun 2017

PurePredictive, Inc.

Director Profession services & Product Development

Presently working with Higher Education client - Western Governors University. Created a Enterprise Data Warehouse for the Institutional Research team. This ware house caters to all the reporting and information need of the university. Created 9 dashboards - one for each individual function/ department. Marketing, Enrollment, Student Services, Evaluation, Program Development. The EDW is single version of truth and central location for all data needs. EDW gets data from all Internal and external sources. Publisher data that covers student interaction. Performance assessment data from third party vendors. Survey data for students. I worked as a Team Lead right from the beaning of this project. Build the architecture, created ETL design, Development schedule and deployment plans. Worked with team of Business Analyst and ETL developers to implement the complete EDW. Responsibilities: 1. As a team lead I am responsible for providing solution architecture for data need of IR department 2. Manage and maintain day to day reporting needs. EDW daily jobs and Audit monitoring. Total 120+ Jobs that run nightly that refresh the EDW data sets 3. Delivery of Monthly reporting package on every 10th of the month to all the top management, department heads and VCs 4. Deploying code from DEV to PROD 5. Facilitating Ad-hoc report requirement using Cognos 6. Cloudera Hadoop, big data handling and making it available in summary format in EDW 7. Application administrator for Talend ETL, Cognos Reporting and Hadoop cluster on AWS. Handling total 10 application servers in production and dev 8. Managing and maintaining Python environment for development and production deploy 9. Transforming and integrating data from various source system - SalesForce, JSON,XML etc


Feb 2011 - Nov 2012

One on One Marketing

Manager Data Acquisition

Working in BI division as Manager Data Acquisition, building the data warehouse that feeds the Business KPI and Dashboards needs Responsibilities: 1. EDW - architecture and development. The EDW is based on unstructured data input processing and providing relation output for reporting and statistical analysis 2. Using Talend Open Studio as a ETL tool. Managing Job scheduling and notification using Shell Scripts. Created a process for managing all ETL functionality with shell scripting. 2. Setting up and administration of Oracle 11g environment 3. Implementation of Open Source BI platform SPAGOBI 4. Defining the Metrics process 5. Capturing unstructured file logs in Hadoop eco system and then making it available for reporting and processing with EDW data 6. Designing interal ERP application for Vendor and Client Management using Oracle Application Express


Jan 2009 - Feb 2011

O.C. Tanner

MSAT Contractor

Lead Architect for designing the ETL policies for the large project - Analyzing the tool set fitment - Designed the Architecture for handling large files - Developed the file upload process using Business Objects Data Services - Created the BI environment with setting up of 8 servers, DEV, TEST and PROD environment - Conducted end user training for using the system - Unix Shell Scripts to automate the file initial checks and cleansing process - Facilitating Self service BI reports for end users by training them on Crystal Report XI

Feb 2007 - Feb 2011


BusinessObjects CoE Lead

Working as a Center of Excellence lead for BI tool BusinessObjects.

Jan 2007 - Feb 2011

Mahindra Satyam

Project Lead

Worked on BI projects with BusinessObjects technologies. BO Data Services ETL, BusinessObjects Reports, Crystal Reports. Setting up the SAP BO server environment. Sizing and planning for scalability Integration of BO with other systems Troubleshooting server problems LDAP authentication setup


Jan 2007 - Apr 2009

Satyam Computer Services Ltd

Project Lead


Sep 2006 - Jan 2007

Reliance Retail

Sr. Manager - IT

Worked as a IT manager for implementing LMS for Reliance Retail

Jan 2001 - Sep 2006

Patni Computer Systems


Data Warehousing and Business Intelligence consultant. Worked with BI COE for providing technical support to projects on BusinessObjects, Informatica and Cognos tools set. Installation and configuration of BI environment for production systems and performing operational Admin tasks. Sr. Software Specialist Conducted Training and provided technical support to projects on: Oracle DBA Oracle 8i Unix Administration and shell scripting

Dec 1997 - Dec 2000

Boston Computer Education

Technical Coordinator

As a Lead Technical Coordinator Mumbai Region

Talk to Narendra

@ Copyright 2020 OfficeHours Technologies Co.