Strong decision-maker with 9 years of experience in Oracle Argus Safety, Oracle SQL, PL/SQL, OBIEE, Tableau and IBM Cognos Reports. Strong skills in SQL development and an in-depth grasp of SQL analytics, reporting and business intelligence.
Experience
2025 — Now
2025 — Now
Alameda, California, United States
2024 — 2025
2024 — 2025
Alameda, California, United States
• Serving as an administrator for Argus, BIP, and Axway systems within the field of Pharmacovigilance.
• Engaged in the production and delivery of meticulously structured periodic reports (SUSAR, PSUR, DSUR and PBER) as well as aggregate reports (CIOMS I, II and Case Listing).
• Formulating intricate adhoc queries using SQL and PL/SQL in accordance with user specifications and guaranteeing their punctual delivery within the stipulated SLA period.
• Possessing expertise in managing E2B R2 and R3 reports fields, transmission logics, and rules within the Argus system.
• Configuring user accounts, clinical studies, and code lists within the Argus Console, while also helping users by addressing their requests within Argus Safety.
• Producing novel OBIEE reports and furnishing concurrent assistance for their implementation.
• Conducting training sessions for newly onboarded personnel on the operational functionalities of the Argus system.
• Utilizing JIRA as a platform for diligent monitoring and management of issues.
• Functioning within the Veeva Quality Docs system as a proprietor, approver, and author for quality documents.
2023 — 2024
2023 — 2024
Delhi, India
Working in Pharmacovigilance Industry.
Working as Argus Administrators.
Handling the ICSR Reporting.
Handling the routing of E2B reports in Argus Safety.
2020 — 2023
2020 — 2023
Noida, Uttar Pradesh
● Worked in Pharmacovigilance Domain.
● Worked on delivering efficient SQL and PL/SQL codes.
● Developed complex Adhoc queries as per user requirements and delivering them within the SLA duration.
● Worked in all three databases Oracle Argus Safety, Argus Insight and Argus Mart.
● Supported user requests in Argus Safety and Insight.
● Created new OBIEE Reports and providing support for same.
● Worked on creating new PL/SQL functions as per requirements for new reports.
● Worked in the ETL execution and scheduling through Oracle ODI tool.
● Trained new employees for the Argus system functions.
● Worked on JIRA and Service Now for the issue monitoring.
2016 — 2020
2016 — 2020
Noida Area, India
● Largest American Pharmacy's URAC accreditation project.
● Developed PL/SQL Procedures and logics.
● Developed complex Cognos Reports for their manufacturers.
● Worked on Composite (CIS Studio) tool for efficiency of views.
● Data loading done through Talend Open Studio for Data Integration.
● Created more than three Cognos Reports in a week within the deadline.
● Created efficient SQL Views in Composite (CIS Studio).
● Trained three individuals for the effective Cognos report creation.
● Got hands-on Talend Open Studio in Data Integration.
● Have an effective hands-on experience in Tableau.
● Know Unix script handling procedures.
Migration from One System to Another
● Worked as "Technical Lead" for this project.
● Created new SQL and PL/SQL views and procedures.
● Created efficient Views and Triggers in Composite (CIS Studio).
● Data loaded in the system through SQL Loader.
Federation of New System into Existing System
● Worked as "Technical Lead" for this project.
● Made new SQL views to cater the new changes of the system.
● Handled Triggers and scheduled for data loading.
● Changes to the existing reports impacted due to federation.
● Trained three individuals to make up the change in reports.
Education
APJ Abdul Kalam Technological University