Ravi Khatri Email & Phone Number

New York, Ny, Us

• Developing BI Dashboards for Charges and Visits. Work with power users to implement functionalities required. Closely work with Data Warehouse Group for object selection and performance managements for both Oracle and SQL Server• Training other developers to expand the usage of Tableau as more areas need BI Reports.

Elmsford, Ny, Us

As a FB4W Volunteer, I am enhancing Tableau Application and its related performance improvement for Food Bank for Westchester. Their back end database is Microsoft SQL Server 2008. Tableau Software has connectors for various data sources and it can merge data from various sources for analytic reporting and dash boarding. Extensively using mapping feature of Tableau for data presentation.

Yonkers, Ny, Us

• The project is to migrate eCommerce application to a newer application software. The back end uses Oracle. Two activities where I participate are data mapping and data migration.

New York, Ny, Us

• Using ODI 12C, developed mappings, procedures, functions and workflow for healthcare claims. Data from various inputs were mapped to external tables and then applied encryption algorithms for certain entities before storing initial transaction data in raw format. Then applied algorithm to these data to prepare it for Data Warehouse use. Various status were recorded for the data control as it progressed through various stages. Developed workflow to handle multiple input processes for parallel execution. Performance related features of ODI were used. Also additional logic developed to make use of partitioning and sub partitioning implemented by the database group.

New York, Us

• In-house technical lead for Enterprise level BI projects that provide analytical solutions for VNSNY’s Finance, Operations, and Clinical departments. o Play key role in the implementation of Reports Metrics that include the design and development of reports and dashboards, ETL processes and metadata management using Oracle’s Discoverer BI Toolo Designed a Data Warehouse in Oracle 10g in which the staging area is populated from heterogeneous sources like DB2, SQL Server, SalesForce and external Flat file feeds. Then used the staging area data to build Dimensions and Facts for reportingo Designed and automated in-bound and out-bound processes from Oracle Data Warehouse• Participated in the transformation of Patient Accounts Application from Essbase/Hyperion System which operated on UDB Release 7 to Essbase/Hyperion (Release 11). Led in-house maintenance and enhancement of the system by understanding the details related to ODI and Essbase processes• Guide and participate in migrating Windows-based Oracle 10g database and its associated tasks and schedules to Unix-based Oracle 11gR2. Some of the processes used Shell Scripts.• Lead infrastructure management to ensure continuous availability and operational efficiency of serviceo Manage ETL Servers where ODI is installed, MicroStrategy App Servers & MicroStrategy Web Serverso Monitor Production and Development Oracle Database Serverso Created logical and physical data models for the project covering all business functionalitieso Improved performance of various processes related to Databases and reports• Team player who serves as a mentor and guide to team of junior analysts

Miami, Florida, Us

• Led a process to satisfy Univision’s reporting needs by evaluating a number of BI tools, ultimately choosing an Oracle tool set and developing BI applications on those tools - Technologies utilized: Oracle Database 10gR2, Oracle Warehouse Builder, Oracle BI Discoverer App Server, Oracle Discoverer Admin and Desktop and Analytical Workspace Manager for OLAP• Led Salesforce.com deployment, from evaluation to development to implementation

Northampton, Gb

Enhanced product development planning and scheduling workflow system to populate a central database. Installed, maintained and enhanced Standard Data Application deployed on Websphere Application Server.

Consultant assignments in various industries, including NBC, MTV, PepsiCo, Medco, CNBC, Prudential, Stony Brook University, and Transamerica Leasing.

Worked as a group leader at NBC, managing many applications, including realtime scheduling of tv show line-ups.

Led the development of a Budgeting, Data Entry, and Benefit Production applications for the NYC Public Assistance, Food Stamp, and Medicaid programs.

In house systems development and turn key projects