cache mumps sql database

Nikul Bhai Patel

***A, Dafrack Drive, Lake Hiawatha,

NJ 07034, USA

Phone: +1-973-***-****(M)

E-mail: **********@*****.***

LinkedIn: http://www.linkedin.com/in/nikul-patel-22735333/

Objective

To sustain myself in IT industry where I can get chances for my personal and professional growth by applying my logical and analytical skills

Career Summary

Over 8 years of experience in Analysis, Design, Development, Management and Implementation of client-server based applications.

More than 8 years of programming experience in Intersystems Cache(Object script, Cache studio, global, System Management Portal), SQL

8 Years of experience in application integration

More than 4 years of programming experience in VB 6.0, Crystal Reports v10.0/9.0/8.5.

Over 4 years of experience in Cache Server Pages(CSP), Java Script, Web Development

Over 3 years of experience in Data warehouse, Data mining, Business Intelligence(Extraction, Transformation and Loading(ETL), Business terminology setup(BTS), Key Performance Indicator(KPI),analyzer(Pivot table), Dashboard design)

More than 1 years of experience in Ensemble production server

Over 8 years of experience in Healthcare(EMR, EPR), ERP(Inventory management, Accounts Payable, Accounts Receivable)

Good experience & understanding of the Software Development Life Cycle such as Requirement analysis, Design, Development and Testing.

Thorough practical knowledge of Creating and Managing database objects like Stored Procedures, Functions, Triggers, Views, Schemas, and Constraints.

Expertise with backend programming using PL/ SQL Stored procedures on databases like Cache 5.0, Familiar with other databases like MS SQL Server 2000, MS Access.

Knowledge of C / C++.

Worked with Documentation for System Analysis and Design.

Expertise in debugging, logical analysis and Data Migration.

Ability to apply new concepts and technologies to enhance the work environment.

Ability to produce well-documented designs and code.

Extensive experience in on-site and production support and ability in handling and coordinating multiple tasks in team environments.

Very good Analytical, Problem Solving and Teamwork Skills and ability to quickly adapt to complex environments, technologies and new concepts.

Excellent communication and interpersonal skills.

TECHNICAL SKILLS

Programming

Intersystems Cache` Object Script, Cache Server Pages(CSP), MUMPS, Structured Query Language (SQL), Hypertext Markup Language (HTML), DHTML, Java Script, Microsoft Visual Basic 6 (VB6), Core Java, C Language (C), Web Technologies

Databases

Intersystems Cache, MS SQL Server, MS Access, Database Concepts

Operating Systems

WIN XP, Windows NT/2000/2003

BI Tool

Speedminer 6.0

Reporting Tools

Crystal Report 8.5

Application

Intersystems Trakcare(HIS), CERNER

PROJECTS SUMMARY

Patient Medical Record Distribution System

2 Months

Company Name

Speedminer Sdn. Bhd., Malaysia

Client Name

INSTITUT JANTUNG NEGARA(IJN), Malaysia

Roles In the Project

Project Member – Developer, Implementer, Post implementation support

Technologies

Intersystems Cache databse, Cache object Script, Cache server pages, Java Script, HTML, Speedminer Reporter

Description

Developed system to get staff performance and KPI (Key Performance Indicator), to track Patient Medical Record (PMR) in Medical Record Department internally to auto-distribute the workload fairly by system. Whole system is called Patient Medical Record (PMR) distribution system

Real Time Data Warehouse

1 Month

Company Name

Speedminer Sdn. Bhd., Malaysia

Client Name

Fatimah Hospital, DEMC(Medical Center), Pantai Premier Pathology

Roles In the Project

Project Member – Developer, Implementer, Post implementation support

Technologies

Intersystems Cache object Script, Intersystems Cache shadow server configuration, Intersystems Cache background job

Description

Developed and implement Real Time indexing(Real Time data warehouse) for Speedminer BI tool

Stock Module(Inventory management)

6 Months

Company Name

Speedminer Sdn. Bhd., Malaysia

Client Name

Oratis Pharmaceuticals Sdn. Bhd.

Roles In the Project

Project Member – Developer, Implementer, Post implementation support

Technologies

Intersystems Cache databse, Cache object Script, Cache server pages, Java Script, HTML, Speedminer web framework, Speedminer Reporter

Description

Developed and implemented Stock ERP module which consist of PO, GRN, Stock Transfer, Stock Consumption, Stock Adjustment, Inventory workbench and stock Reports

Medical Document Tracking Systems

4 Months

Company Name

Speedminer Sdn. Bhd., Malaysia

Client Name

Selayang Hospital

Roles In the Project

Project Member – Developer, Implementer, Post implementation support

Technologies

Intersystems Cache databse, Cache object Script, Cache server pages, Java Script, HTML, Speedminer web framework, Speedminer Reporter

Description

Developed and implemented Medical Document Tracking System

Intersystems Trakcare(Billing) and SAP integration

4 Months

Company Name

Speedminer Sdn. Bhd., Malaysia

Client Name

DEMC(Medical Center)

Roles In the Project

Project Member – Developer, Implementer, Post implementation support

Technologies

Intersystems Cache object Script

Description

Integrate Trakcare patient billing Receipt(Deposit) with ERP(SAP)

Centralized Intersystems Trakcare Implementation

1 Years

Company Name

HCL Infosystem, NOIDA, India

Client Name

FORTIS Healthcare Ltd, India

Roles In the Project

Project Member – Developer, Implementer, Post implementation support

Technologies

Intersystems Cache databse, Cache object Script, Cache server pages, Java Script, HTML, Ensemble production server, Crystal Report, cloud architecture

Description

Implemented centralized Hospital information system (Intersystems Trakcare) and integrate with ERP (Oracle Apps) across 7 hospital.

Prodigious ERP Solution

4 Years

Company Name

Mtech India Pvt Ltd, Gurgaon, India

Client Name

India

●Sir Gangaram Hospital, New Delhi

●Fortis Hospital, Mohali, Jaipur, Vashi

●Pushpanjali Crosslay Hospital, Ghaziabad

Thailand

●Hua Chiew General Hospital, Bangkok

Indonesia

●Ramsay International Group of hospital

Roles In the Project

Project Member – Developer, Implementer, Post implementation support

Technologies

Intersystems Cache databse, Cache object Script, Visual Basic 6.0, Crystal Report

Description

Prodigious suite of application is the flagship product of MTech India Pvt. Ltd. It is developed using Caché technology as the database. The product is an integrated back office application designed primarily for the Healthcare sector. The suite of applications consists of, Financial Management System, Purchase and Inventory Management System, Fixed Asset Management System & Human Resource Management System. Prodigious integrated with Intersystems Trakcare HIS, and it is running successfully across India, Thailand and Indonesia.

WORK EXPERIENCE SUMMARY

IT Consultant Speedminer Sdn. Bhd., Malaysia

Consultant HCL Infosystems Ltd., NOIDA, India

Sr. Programmer Mtech India Pvt. Ltd., Gurgaon, India

Speedminer Sdn. Bhd., Malaysia

Jan 2013 – Oct 2015

Technology: Intersystems Cache Object Script, Cache Server Pages(CSP), HTML, DHTML, Java Script, Speedminer BI tool

Responsibilities:

Involved in the client requirement, analysis, design and development of the new modules

Understanding current architecture, Database and modifying the design to support new requirements.

Ensured compliance with all reporting and portfolio management regulatory requirements, as identified during the requirements phase of the project

Involved in debugging and troubleshooting of User interface screen design Called and/or participated in periodic meetings with the Project Manager in order to assess and identify main risks to the project and put in place processes to minimize them

Responsible for speedminer(BI Tool) upgradation process

Client support

HCL Infosystems Ltd., NOIDA, India

Aug 2011 – Dec 2012

Technology: Intersystems Cache Object Script, Cache Server Pages(CSP), Java Script, Ensemble Production server

Responsibilities:

Part of implementation team for FORTIS NXT project(Implement centralized HIS Intersystems trakcare and Oracle Apps.(ERP) Across 7 hospital)

Involved in the analysis, design and development of inventory and patient billing interface between centralized HIS(Intersystems Trakcare) and ERP(Oracle Apps) using Ensemble 2010 production server

Developed OPD, IPD administration report, clinical reports for multi hospital environment

Involved in client requirement Gathering and development of MIS report(Daily Business Report, Gross Contribution, Monthly Revenue Flash, Quarterly Revenue Flash,Revenue Spilt) for multi hospital

Involved in Customization of Intersystems trakcare according to client requirement

Part of implementation team for FORTIS NXT project(Implement centralized Intersystems trakcare and Oracle Apps. Across 17 hospital)

Site visit for maintenance of system

Mtech India Pvt Ltd, Gurgaon, India

Jun 2007 – Aug 2011

Technology: Intersystems Cache Object Script, Microsoft Visual Basic 6.0, Crystal Report

Responsibilities:

Involved in the analysis, design and development of the new modules of Prodigious(ERP)

Wrote queries using SQL to retrieve data from the Cache 5.0 database

Wrote Routines in Cache 5.0 database for data processing

Developed and implement Intersystems Trakcare and Prodigious(ERP) interface

Involved in debugging and troubleshooting of User interface screen design

Involved in client support

Site visit for updating software

TRAINING

Intersystems Cache 5.0

Content

Caché ObjectScript,CSP, Object-oriented programming, SQL

Location

Mtech India Pvt. Ltd., India

Year

2007

Prodigious ERP

Content

Inventory, Accounts Payable, Finance(GL) Module

Location

Mtech India Pvt. Ltd., India

Year

2007

Intersystems Trakcare P7

Content

Stock Module

Location

Mtech India Pvt. Ltd., India

Year

2008

Intersystems Ensemble 2010 System Management

Content

Installation, Configuration of Ensemble(Conducted by Intersystems)

Location

HCL Infosystems Ltd, India

Year

2011

Intersystems Trakcare 2010

Content

Billing, Stock Module

Location

HCL Infosystems Ltd, India

Year

2011

Speedminer(Business Intelligence Tool)

Content

Architect, Analyzer, KPI, Dashboard management, Form Designer Framework, Administration

Location

Speedminer Sdn. Bhd., Malaysia

Year

2013

EDUCATIONAL BACKGROUND

Master of Computer Application(With First Division)

University

Uttar Pradesh Technical University, Lucknow, Uttar Pradesh, India

Completion Date

Jun-2007

Post Graduate Diploma in Computer Application(With Distinction)

University

Punjab Technical University, Jalandher, Punjab, India

Completion Date

Oct-2003

Bachlor of Computer Application(With Second Division)

University

Saurashtra University, Rajkot, Gujarat, India

Completion Date

Oct-2003

Contact this candidate