Royal Ojha
Northville
Overview
1
1
Certification
Work History
MCKESSON PHARMACY SERVICES
- DEVELOP AND IMPLEMENT SALESFORCE SOLUTIONS FOR MCKESSON PHARMACY SERVICES USING SALESFORCE LIGHTNING EXPERIENCE
- DESIGN AND DEVELOP CRM CALL CENTER FEATURES INCLUDING SERVICE REQUESTS, ESCALATION, ACTIVITIES, ASSETS, PRODUCTS FOR MPS-PHARM2 CALL CENTER APPLICATION USING APEX IN FORCE.COM PLATFORM
- USE CONTAINERIZATION TECHNOLOGIES INCLUDING DOCKER TO AUTOMATE DEPLOYMENT OF MCKESSON PHARMACY SOLUTION
- USE KUBERNETES AND DOCKER SWARM TO ENSURE SCALABILITY AND RESILIENCE OF MCKESSONS INFRASTRUCTURE AS THEY ARE USED BY VARIOUS PHARMACISTS.
- DEVELOP INTEGRATION PACKAGES FOR CUSTOMER DATA FLOW BETWEEN MPS AND PHARMA2 APPLICATIONS THAT HELPS CALL CENTER AGENTS SERVE AND SUPPORT CUSTOMERS OF MCKESSON ENTERPRISE-RX PHARMACY MANAGEMENT SYSTEM
- USE KINGSWAY SOFT SSIS INTEGRATION PACKAGE TO DEVELOP REALTIME INTEGRATION BETWEEN SAP - SIEBEL AND SALESFORCE APPLICATION FOR TRANSACTION OF PHARMACY CUSTOMER RELATED DATA
- UPGRADING THE SIEBEL APPLICATION FROM IP2014 TO VERSION 25.0.1 TO ENSURE COMPLIANCE AND MAINTAIN SECURED APPLICATION THAT SERVES PHARMACY CUSTOMERS USING ENTERPRISE-RX PRODUCT.
- CUSTOMIZE, AND DEVELOP NEW FEATURES IN SIEBEL CALL CENTER APPLICATION USING SIEBEL WEB-TOOLS, E-SCRIPTING FOR CUSTOMER ASSET MAINTENANCE AND RETURN AUTHORIZATION PROCESS OF ENTERPRISE CUSTOMER ASSETS
- THESE ASSETS ARE USED IN PHARMACY CHAIN OUTLETS.
- DEVELOP PARAMETERIZED, DRILL-DOWN, CHARTS, MATRIX, SUB-REPORTS USING MICROSOFT SSRS REPORTING TOOLS FOR DATA DRIVEN REPORTS THAT HELPS MCKESSON TO TRACK ASSET INVENTORY, CUSTOMER SERVICE REQUESTS, PHARMACY CREDIT RELATED DATA, PHARMACY PRODUCT VERSIONS INCLUDING PRODUCT VERSION EXPIRATION AND GA AVAILABILITY INFORMATION.
TCS
- DEVELOPING SALESFORCE LIGHTNING CONSOLE FOR MANAGING ASSETS AND RETURNS, CREATING APEX CLASSES, SERVER SIDE COMPONENTS, VISUAL FLOWS, PROCESSES BUILDERS HELPER CLASSES, CONTROLLERS.
- CREATE SALESFORCE SOQL PACKAGES FOR DATA LOADING AND BULK DATA IMPORTS
- USE KINGSWAY SOFT INTEGRATION PACKAGE AND SALESFORCE APEX CLASSES IN DEVELOPER CONSOLE FOR SALESFORCE INTEGRATION.
- DEVELOPMENT, IMPLEMENTATION AND BUG FIXING IN SIEBEL UCM PRODUCT SUITE CAPABILITIES, CONFIGURATION OF ENTERPRISE DATA QUALITY TOOLS (EDQ) AND SURVIVORSHIP RULES IN SIEBEL UCM
- PERFORM DATA MIGRATION IN SDH TABLES, LOADING CROSS REFERENCES
- PERFORM DATA CLEANSING, ADDRESS STANDARDIZATION, RECORD MATCH-MERGE AND DATA PROFILING
- CODING AND CUSTOMIZING SIEBEL CALL CENTER APPLICATION THAT INCLUDES SCRIPTING, APPLICATION INTEGRATION AND SIEBEL WORKFLOWS.
- OPTIMIZING SIEBEL QUERIES FOR IMPROVING SIEBEL PERFORMANCES, CREATING PDQS TO AUTOMATE USER OPERATIONS, WRITING COMPLEX QUERIES TO IDENTIFY DATA ISSUES, CREATE EIM JOBS, CONFIGURATION FILES AND COLUMN MAPPINGS
- PERFORMING SIEBEL VERSION UPGRADES FOR SIEBEL ON PREMISES TO SIEBEL CLOUD APPLICATION
- USE SIEBEL E-SCRIPTING AND EAI TO CUSTOMIZE CALL CENTER APPLICATION BASED ON CUSTOMER BUSINESS REQUIREMENT.
Wipro
- SIEBEL CALL CENTER APPLICATION IMPLEMENTATION FOR MULTIPLE CLIENTS AND VERTICALS INCLUDING PHARMACY, RETAIL, TELECOM AND SHIPPING.
- USE SIEBEL TOOL SKILLS INCLUDING CONFIGURATION, SCRIPTING, CREATING OF BUSINESS SERVICES, STATE MODELS, AUDIT TRAIL, TASK BASED UI, DATA MATCHING AND MERGING RULES TO DELIVER SIEBEL CRM SOLUTIONS FOR ENTERPRISE AND SMALLER CUSTOMERS.
- DEVELOPMENT OF SIEBEL BIP REPORTS TO BUILD DATA DRIVEN AND INTERACTIVE REPORTS FOR CLIENTS THAT HELPS THEM WITH THEIR BUSINESS NEEDS.
- CUSTOMIZE SIEBEL OBJECTS INCLUDING ACCOUNTS, CONTACTS, SERVICE REQUESTS, ASSETS, ACTIVITIES ORDER MANAGEMENT, PRODUCTS, DEMOGRAPHICS FOR BETTER MANAGEMENT OF CUSTOMER DATA FOR VARIOUS NEEDS.
- WORK ON VARIOUS FULL LIFE CYCLE IMPLEMENTATION PROJECTS INCLUDING ANALYSIS, DESIGN, DEVELOPMENT AND PRODUCTION SUPPORT
- CREATE SIEBEL UCM RULES INCLUDING MATCHING MERGING, DEDUPLICATION AND SURVIVORSHIP RULES
- CREATE ETL JOBS USING INFORMATICA POWERCENTER TOOL FOR DATA LOADING INTO SIEBEL BASE TABLES.
- CREATE SIEBEL EIM JOBS FOR LOADING LEGACY DATA INTO SIEBEL BASE TABLES.
Education
Master of Science - Information Technology
University Of Cumberlands
Williamsburg, KY06.2022
Bachelor of Engineering - Computer Science And Engineering
Institute of Technical Education And Research
Bhubaneswar02.2007
Higher Secondary - Science Education
Ravenshaw Junior Collage
Cuttack, Odisha 03.2000
Skills
Salesforce Service Cloud
Siebel - CRM
Azure Docker Cloud
Azure Application Cloud Gateway
CRM Integration
Certification
Salesforce Admin 201
Languages
English
Full Professional
Hindi
Full Professional
Odiya
Native or Bilingual
Timeline
MCKESSON PHARMACY SERVICES
TCS
Wipro
Master of Science - Information Technology
University Of Cumberlands
Bachelor of Engineering - Computer Science And Engineering
Institute of Technical Education And Research
Higher Secondary - Science Education
Ravenshaw Junior Collage
Salesforce Admin 201
Similar Profiles
Darlesha HollandDarlesha Holland
Intake Specialist/Patient Access Specialist at MCKESSON SPECIALTY PHARMACYIntake Specialist/Patient Access Specialist at MCKESSON SPECIALTY PHARMACY
SAM MATARSAM MATAR
Team Lead (Sales & Operations) at McKesson - Advanced Care Specialty PharmacyTeam Lead (Sales & Operations) at McKesson - Advanced Care Specialty Pharmacy
Darlesha HollandDarlesha Holland
Intake Specialist/Patient Access Specialist at MCKESSON SPECIALTY PHARMACYIntake Specialist/Patient Access Specialist at MCKESSON SPECIALTY PHARMACY
Nishi KikaniNishi Kikani
Clinical Home Infusion Pharmacist at Trinity Health- Ann Arbor Home InfusionClinical Home Infusion Pharmacist at Trinity Health- Ann Arbor Home Infusion
Emily CheekEmily Cheek
Neonatal Intensive Care Unit Registered Nurse at Henry Ford Health SystemNeonatal Intensive Care Unit Registered Nurse at Henry Ford Health System