RAVILAL KHATRI

914-***-**** ac0ivb@r.postjobfree.com

Tarrytown, NY 10591

SUMMARY

Enterprise architect and developer with over 32 years of IT experience in the US. Have technical expertise that encompasses a range of hardware platforms, programming languages, databases, and application development and BI tools. Further, have experience working across many industries, including Healthcare, Entertainment, Consumer Goods, Transportation, Government, Education and Financial Services.

Professional Goal: To use my technical expertise, business acumen and organizational skills to solve BI and data warehousing challenges on time and within budget.

Dynamic learner who has continuously mastered new technologies, from mainframe to object oriented systems and BI tools

Self-starter with the established history of designing robust systems solutions that are easy to maintain and scalable for future enhancements

Demonstrate great interpersonal skills and the ability to act as a conduit between the business and IT

Excellent at building detailed and accurate project work plans

Experienced Enterprise Data Architecture covering logical and physical data models

Possess the skills to considerably improve the performance of existing applications

PROFESSIONAL EXPERIENCE

Food Bank for Westchester, Westchester, NY June ’16 – Present

BI Architect and Developer (Part time Assignment)

At present, 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 dashboarding. Extensively using 'geo mapping' feature of Tableau for data presentation.

Consumer Reports. Yonkers, NY Nov ’16 – Mar ‘17

Oracle ETL Developer (Consultant)

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

FairHealth, New York, NY May ’15 – Dec ‘15

Sr ETL Developer

PL/SQL procedures developed and implemented for integrating in ODI processes.

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.

Visiting Nurse Service of New York, New York, NY Apr ‘08– Jan ‘15

Data Warehouse Engineer & BI Specialist

In-house technical lead for Enterprise level BI projects that provide analytical solutions for VNSNY’s Finance, Operations, and Clinical departments.

oPlay 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 Tool

oDesigned 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 reporting. Implemented many processes using PL/SQL procedures and functions. Where relevant analyzed the processes for performance – examined V$VIEWS and worked with DBAs.

oDesigned 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 service

oManage ETL Servers where ODI is installed, MicroStrategy App Servers & MicroStrategy Web Servers

oMonitor Production and Development Oracle Database Servers

oCreated logical and physical data models for the project covering all business functionalities

oImproved performance of various processes related to Databases and reports

Team player who serves as a mentor and guide to team of junior analysts

Univision Online, New York, NY Dec ‘04 – Mar 08

Lead Developer

Sales Applications & BI Project

Developed many packages, procedures and function using Oracle PL/SQL. Integrated these with other Oracle Applications and Salesforce.

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

oEvaluated BI tools using a framework for proof of concept: Microstrategy, Cognos, Oracle and Business Objects

oEstablished Oracle BI environment for development and Production. Worked with DBA group to set up Oracle Database 10gR2, Oracle Warehouse Builder (OWB). Installed Oracle BI Discoverer App Server, Oracle Discoverer Admin and Desktop and Analytical Workspace Manager (AWM) for OLAP

oImplemented BI solution for Sales Insertion Order system. ETL tasks were done in Oracle Warehouse Builder (OWB). Reports development was done in Oracle Discoverer. Continued to support the solution by providing upgrades and enhancements

Led Salesforce.com deployment, from evaluation to development to implementation

oCreated interfaces using Professional version set up to transfer master data and existing orders from Sales data

o Integrated salesforce.com into existing Univision sales system: stored unique Salesforce.com ID in the Sales System for data management, installed Outlook edition of Salesforce.com for contact and email, and participated in generating relevant reports

oProvided user support, including the addition of custom fields to accommodate user requests

Object Edge, Walnut Creek, CA Sep ‘04 – Nov ‘04

Lead Developer

VA Administration Project

Worked as the lead developer on a Veteran Administration Project where Object Edge participated in the development of Enterprise Service Bus architecture

Utilized WebLogic App Server, Java and Oracle technologies

Participated in developing database model, populating data tables and testing various interfaces for the project

Avon Products, Rye, NY Jan ‘03 – Aug ‘04

Senior Technical Specialist

Data Standardization & Marketing

Installed, maintained and enhanced Standard Data Application deployed on Websphere Application Server. Application was developed using Java beans, JSPs, Java Servlets, and Oracle database 8i and 9i

Designed and implemented complex interface between two Oracle applications using Oracle packages, stored procedures and functions. Oracle version used was 8i and later migrated to Oracle 9i

Enhanced and maintained Global Marketing Product Management System. The repository was Oracle 9i and it deployed Oracle Packages, Stored Procedures & Functions. It received data from front end Domino system

Nanji Software Builders, Inc. (Independent Consultancy), Tarrytown, NY 1990 – 2002

Technical Consultant Aug ’02 – Dec ’02

Avon, Rye, NY: Marketing Information System

Enhanced product development planning and scheduling workflow system to populate a central database

Technologies utilized: Oracle Database 8i and 9i, Oracle SQL, Oracle Packages, Procedures & Functions

Technical Consultant Jan ‘00 – Aug ‘02

Transamerica Leasing, Purchase, NY: Billing Systems

Enhanced and maintained EDI feeds written in Gemstone Smalltalk, including exception handling and application enhancements, and wrote the output to Oracle database tables

Technologies utilized: Gemstone Smalltalk, ASP, JavaScript, Oracle

Technical Consultant April ‘99 – Dec ‘99

Stony Brook University, Stony Brook, NY: Accounting Systems

Developed enterprise wide interface solution to transfer data and control between Oracle PeopleSoft and Mainframe CICS system, using triggers and stored procedures to extract PeopleSoft data from tables

Technologies utilized: Oracle Database Version 8i, CrossPlex (gateway)

Technical Consultant Jan ‘99 – March ‘99

NBC, New York, NY: Y2K Proofing

Developed Workflow and Test Scripts for testing Financial Applications of Y2K conditions

Technology utilized: SQA

Technical Consultant Oct ‘98 – Dec ‘98

Prudential, Valhalla, NY: Real Estate Systems

Used Visual C++ and COBOL for a Real Estate Relocation Program to populate mainframe feed into SQL Server 6.5, and wrote stored procedure and ActiveX Data Objects to load tables

Technologies utilized: SQL Server 6.5, Visual C++, MQ Series, COBOL

Technical Consultant April ‘98 – Sep ‘98

NBC, New York, NY: Accounting Systems

Designed and developed Sales Recognition and Receipt Tracking Systems

Technologies utilized: PowerBuilder 5.0, CornerStone Class Library, Sybase 11

Technical Consultant Oct ‘97 – Mar ‘98

CNBC, Fort Lee, NJ: Contract Billing

Identified deficiencies in the business logic and code for cable Network Contract, Contact and Billing Systems, and applied correction using SQLs, program changes and user data entry.

Technologies utilized: SQL Server, PowerBuilder 4.0, SQR, Business Objects, Siebel (Oracle CRM)

Technical Consultant Feb ‘94 – Sept ‘97

NBC, New York, NY: Network Operations & Financial Systems

Created a sophisticated Receipt Tracking System to analyze and review sources of advertising revenue, migrating data to new hardware (Windows), software (PowerBuilder), and infrastructure (Sybase)

Modified Profit Planning and Control System to PeopleSoft Accounting Code Structure and provided data feed to the PeopleSoft Financial System

Implemented Head Count & Payroll Model system to provide a variety of functionality to Planners to execute what-if scenarios for finalizing departmental budgets

Rewrote application environment using Visual Basic and Sybase after generating a detailed technical specification document to bring out all relevant mapping between program modules, functions, and data structures

Technologies utilized: Sybase, PowerBuilder, Objectory (tool for requirement analysis and design), Erwin, C, VisualWorks 2.0, ObjectLens, MicroFocus COBOL, Visual Basic, SQA

Technical Consultant Aug ‘93 – Jan ‘94

Medco, Montvale, NJ

Generated reports related to Drug Utilization Review by extracting data from DB2 & loading into Sybase

Technologies utilized: Sybase, PowerBuilder, C, DB2, VSAM

Technical Consultant April ‘93 – July ‘93

PepsiCo, Purchase, NY: Sales Systems

Developed a Customer Order Fulfillment System

Technologies utilized: PowerBuilder, Sybase, Novell

Technical Consultant Mar ‘93

MTV, New York, NY: Network Operations

Modified AS-RUN Log Reconciliation System of a cable network using PowerBuilder and SQL Server

Technologies utilized: PowerBuilder, SQL Server, Novell Netware API

Technical Consultant Dec ‘90 – Feb ‘93

NBC, New York, NY: Various Applications

Played a key role in designing and implementing an enhancement to the Automated process of data transfer from the Network Commercial Sales system to Switch To Air Routine system

Designed and implemented functions of a Corporate Front End system for Payroll using IDMS & ADSO

Enhanced various NBC systems, including their Scheduling System, Human Resource Information System, and Accounts Receivable Subsystem

Technologies utilized: IDMS, ADSO, FOCUS, CICS

TLM Inc, Port Chester, NY Mar ‘86 – Nov ‘90

Independent Consultant

Carried out functional enhancements and trouble shooting for a variety of application areas including TV Network Inventory, Revenue Billing and Compensation, Station Clearance, Sales Plan, Contract Management, TV Network Routine Generation, Local Station Feed, Program Scheduling and Data Collection Systems

Technologies utilized: UNISYS DMS-1100, ISAM, IBM 3090, IDMS

TEK Enterprise, Inc., New York, NY Feb ‘82 – Feb ‘86

Independent Consultant

New York State Department of Social Services

Developed Budgeting and Benefit Production applications for NYC Medicaid, Public Assistance, and Food Stamps Programs

Technologies utilized: Sperry DMS-1100, TIP-1100, COBOL, UTS COBOL

ORG Systems, India 1973-1982

Technical Consultant

Lead developer for in-house sales and accounting system, also implemented turn-key projects for external customers including Air India Reservation

Technologies utilized: Sperry 1100 Series Mainframe systems, ECL, COBOL, DML

EDUCATION

B. S. Mechanical Engineering

Oracle Discoverer Admin and Developer Tool

VisualAge Smalltalk Certified Developer

PowerBuilder CPD

Novell CNE

Microstrategy Tool Training (one week)

Essbase BootCamp (2014)

MongoDB Certified from SimpiLearn

Tableau Version 9.2 Certified from SimpiLearn

Learning Qlikview

Learning AWS

Technical and Infrastructure Expertise

Databases

Oracle 7, 8, 9i, 10gR2 and 11Gr2, Essbase Rel 11, Sybase, SQL Server, Access, DB2, UDB, MongoDB, IDMS, DMS-1100, VSAM, FOCUS, ISAM

Application Servers

Essbase Application Server Release 11, Oracle Data Integrator, Microstretegy App Server, Microstretegy Web Server, Oracle BI Application Server, Salesforce.com, Websphere Application Server, Smalltalk Gemstone Server

Programming Languages

SQL, PL/SQL, Perl, Java, IBM Smalltalk, SmallTalk-80, PowerScript, PeopleCode, SQR, XML, C, Visual C++, C#, MF COBOL, COBOL, Visual Basic, VBScript, JavaScript, Shell Script, FORTRAN, FOCUS, ASSEMBLER

Application Tools

Development Software: Oracle Data Integrator (ODI 11, 12c), Oracle Warehouse Builder (OWB) 10gR2 and 11gR1, Oracle Workflow (OWF), Oracle Discoverer Admin and Development Tool, MicroStrategy, Tableau 9.2, Analytical Workspace Management (AWM) for OLAP, OBIEE, Oracle BI Publisher, Visual Studio 2003, Websphere Software Application Development (Java IDE), VisualAge Smalltalk, VisualAge Java, VisualWorks, Gemstone, Powerbuilder, Visual Studio C++, TOAD, Objectory, Erwin, SQR, MQ Series, PeopleSoft

Hosted Service: Salesforce.com

Operating Systems: MVS, OS-1100, HP-UX, AIX, SUN Solaris, OS/2, Windows

Scheduler: Windows, Maestro, CA-7

Change Control: Source Safe, PVCS, MKS, Endevor

Connectors: Connect Direct, Lotus Enterprise Integrator, Xtalk, CrossPlex, Hyperchannel, Xcom, ODBC, JDBC

Testing: SQA

Contact this candidate