Mayank Gupta Email & Phone Number

Noida, Uttar Pradesh, India

Ultragenic brings together Life sciences domain expertise, Third party system knowledge and Deep technology to develop well-defined solutions, which address challenges across the Pharmacovigilance function.Our solutions are agile, flexible and scalable, developed using advance technologies such as AI, Machine learning and Robotic process automation that.

Noida, Uttar Pradesh, India

Noida Area, India

 Writing PL/SQL scripts Configuring and validating the Argus Safety system Design and development of PL/SQL scripts as part of configuration changes related to new reporting rules, Letters and Auto Narratives, Post and Pre-save etc. in Argus database Design and scripting of custom PL/SQL packages for upgrades and interfacing with other medical.

Noida Area, India

• Collected User Requirements by participating in meetings and studying existing System.
• Created database objects like tables, views, sequences, stored procedures, packages, cursor, ref cursor and Triggers.
• Involved in modifying various existing packages, procedures, functions and triggers according to the new business needs.
• Involved in writing Technical Specification Documentation.

Bengaluru Area, India

• Data Management – Data Collection, Data Parsing, Data Processing, Rating and Loading in Database, Correction process to correct Fraud Management issues.
• Is well versed in resolving application errors, file parsing and data load failures and Alarms execution.
• Coding Experience as enhancement during Application maintenance in Oracle Pl/SQL and UNIX shell scripting.
• Worked on CRs to develop new requirement raised by customer.
• Involved in code review and bug fixes for patch enhancement of application.
• Involved in Parser Creation using Diamond Tool for various formats that include: ASCII, Binary (Fixed / variable length), ASN.1 and transformation as per client transformation.

Noida Area, India

• Key Roles & Responsibilities:
• Collected User Requirements by participating in meetings and studying existing System.
• Created database objects like tables, views, Sequences, Directories, stored procedures, function, packages, Cursor, Ref Cursor and Triggers.
• Interacted with the business users and understanding the request.
• Involved in modifying various existing packages, procedures, functions and triggers according to the new business needs.
• Written optimized SQL/PL SQL queries and extract data from data warehouse as per business user requirement.