Abhay Yadav
Noida
Summary
Dynamic IT professional with a proven track record at Pinnaxis IT Solutions & Consulting Pvt. Ltd., specializing in data migration and system optimization. Excelled in developing robust PL/SQL procedures and ensuring seamless data integration. Adept at problem-solving and providing round-the-clock support, demonstrated by solving over 400 challenges in Mathematics and Computer Science at Chegg. Skilled in SQL and collaborative teamwork.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Consultant
Pinnaxis IT Solutions & Consulting Pvt. Ltd.
Noida
03.2023 - Current
Safety System (Manage Services , Tier 1 Pharma Company)-
- Developed patches for document uploads and extractions in Argus Safety.
- Built SQL queries for audit-related line listings required by regulatory agencies.
- Performed Meddra Upgrade in the client Production environment.
- Troubleshoot and resolved production issues related to case routing, workflows, and user access.
- Automated routine SQL tasks to improve efficiency and reduce manual effort.
- Configured reporting rules, user access, and system settings in Argus Safety.
Migration Tool Development -
- Developed a data migration tool to transfer data from other safety systems to Veeva Vault.
- Created dynamic PL/SQL procedures and functions to support various business requirements.
- Designed and implemented business logic for multiple data migration scenarios.
- Created views and triggers to support the front-end functionality of migration tools.
Validation (Tier 2 Pharma Company) -
- Authored and executed validation scripts (IQ/OQ/PQ) for compliance and data integrity.
- Performed dry runs for validation and data migration testing in collaboration with clients.
Subject Matter Expert
Chegg
Remote
01.2023 - 03.2024
- Solved 400+ new problems related to Mathematics and Computer Science
- Actively provided 24/7 doubt support to students
Education
Master of Computer Applications - Computer Science
Indraprastha University , 9 CGPA
Paschim Vihar, Delhi06-2023
BSc Physical Science - Science
Delhi University , 7.5 CGPA
Delhi, India06-2021
Skills
- Languages : Java, Python, PL/SQL
- Applications : Argus, Veeva
- Domain : Pharmacovigilance
Certification
Web Development Intern, Nagarro, 2022
Personal Projects
Academia Assistant | Complaint Management System
- A Query and Complaint Management System for College students where they can ask their queries related to admission process or raise a complain about any issue faced by them in their academics.
- Tech stack- (HTML, CSS, JavaScript, NodeJS)
TarvelsMate | Carpooling Web Application
- A web-based application for two or more unknown people to travel together in a economically and eco-friendly way. Tech stack- (HTML, CSS, PHP)
Achievements
Client Appreciation
- Outstanding Performance
- Extended support
- Timely Deliverables
Timeline
Consultant
Pinnaxis IT Solutions & Consulting Pvt. Ltd.
03.2023 - Current
Subject Matter Expert
Chegg
01.2023 - 03.2024
Master of Computer Applications - Computer Science
Indraprastha University , 9 CGPA
BSc Physical Science - Science
Delhi University , 7.5 CGPA
Similar Profiles
Harini BalaguruvanHarini Balaguruvan
Inside Sales Manager at Appizion Consulting & Solutions Pvt LtdInside Sales Manager at Appizion Consulting & Solutions Pvt Ltd
Anand DiwediAnand Diwedi
Business Development & Sales Manager at URJIKA CONSULTING & ENGINEERING SOLUTIONS PVT LTDBusiness Development & Sales Manager at URJIKA CONSULTING & ENGINEERING SOLUTIONS PVT LTD
Amit Kumar DasAmit Kumar Das
Chief Executive, Global Partnerships & Alliances at JITMED Coding & Consulting Solutions Pvt LtdChief Executive, Global Partnerships & Alliances at JITMED Coding & Consulting Solutions Pvt Ltd
Richa SharmaRicha Sharma
Deputy Manager at Optum Global SolutionsDeputy Manager at Optum Global Solutions
Mohak SaxenaMohak Saxena
Customer Service Associate at Niftel Communications Pvt. Ltd.Customer Service Associate at Niftel Communications Pvt. Ltd.