Now you can Instantly Chat with Vijay!
About Me
Around 11+ years of Technical & Management experience as a Sr SQL Server DBA, Architect, Team Lead, Database design, Production and development support DBA Operations related to Health care, Pharmaceutical, Insurance and Manufacturing databases on SQ...
Show MoreSkills
Positions
Portfolio Projects
Description
- Working as Senior Microsoft specialist DBA/Architect provided production support for 50 Servers out of which 20 servers are production servers and remaining development and test servers.
Ø Perform Migration of projects between various environments (dev, test, production) and maintain change control.
Show More Show LessDescription
Smart management of the revenue cycle process is critical for the growth and success of your healthcare business. Whitespace's configurable and interactive cloud-based BI platform From performance reports, to scorecard views gain quick real-time insights to take important decisions for your business.
Show More Show LessDescription
Pfizer-Japan is a pharmaceutical company. CDB is one of its applications that come under Platform application portfolio. CDB (acronym for Customer Data Base), is the batch application developed to load the master data in centralized repository (Database) so that different application (Sales and Marketing Business Technology applications) can access/view the master data related to Hospitals, Doctors, Institutes and Medical Universities etc. CDB application, developed in Unix Shell scripting, which interns calls COBOL programs and Stores data in Oracle database. PL-SQL programs (Batch files & stored procedures) and SQL loaders (.CTL) used to load the data.
Show More Show LessDescription
Pfizer-Japan is a pharmaceutical company. “CDB” is one of its applications that come under Platform application portfolio. CDB (acronym for Customer Data Base), is the batch application developed to load the master data in centralized repository (Database) so that different application (Sales and Marketing Business Technology applications) can access/view the master data related to Hospitals, Doctors, Institutes and Medical Universities etc.
Show More Show LessDescription
Performance Optimization from 1 hours run time to 40 seconds run time. Implementation of SQL code in R programming. Split .CSV file into two using R language with certain criteria using packages(data.table) Use subset() function to filter out the records as per business requirement, Export the two variables to two csv files.
Show More Show Less