The Pfizer Analytical and Statistical Tool which deals with safety data that incorporates Global Safety Data warehouse (GSDW), PfAST Data Mart and a layer of reporting tool (Business Objects) is used to collect and report all adverse events for Pfizer’s products.

PfAST consists of the Safety Data Warehouse (SDW) and a Data Mart. The source systems include ARISg and Argus, which will be extracted, transformed and loaded nightly. Additional source systems include Meds, Medics and Novalert, which will be integrated into the data warehouse and data mart through a single, one-time load of the data.

PfAST consists of mainly sustain and integration tracks. Sustain includes all maintenance activities for successful running of PfAST application .Integration. Apart from these tracks, business occasionally comes up with some modifications for existing designs. Dedup, XML are some of them.

Another point to add about PfAST is that it has spread its application maintenance and support among various MNCs.

HP to Microfocus migration project:

The Micro Focus business model is growth through acquisition of software companies and in 2017, they acquired Hewlett Packard Enterprise. As a result of the HP software acquisition, the combined group is operating on two main enterprise application stacks: 

• Stack A – the applications used by the former HP software business 

• Stack B – the applications used by Micro Focus and its subsidiary business units 

The aim of the Stack C program is to re-platform the entire Micro Focus enterprise onto a single application stack, which is referred to as Stack C.

As part of the migration a new reporting solution is required which can tactically provide the data to allow the CPM and GTM reports to carry on functioning, while strategically provide the stepping-stone towards a data driven future.

JOB RESPONSIBILITIES:

• Writing views for reporting team
• Setting up Environments
• Gathering requirements from clients

Pfizer Incorporated is a pharmaceutical company, ranking number one in sales in the world, based in New York City, with its research headquarters in Groton, Connecticut. The company strives to provide access to safe, effective and affordable medicines and related health care services to the people who need them.

The Project plans to develop a Customer Validation Tool/Customer Pick List (CVT/CPL) for Pfizer's CRM and Task force management.

JOB RESPONSIBILITIES:

• Optimize the size of user DB’s by minimizing situations where assignment rules route large number of customers unnecessarily. The established territory alignment tool (business rule based) is still used for the majority of assignments.
• The ‘CVT-CPL’ caters to 22 countries/BU in Pfizer CRM space.
• Implementing the wild card functionality across the application in all stored procedure
• Empower business users to manage exceptions to territory alignment rules.  By offline user to explicit assign/un-assign customers their offline databases are further optimized and so the performance improved.
• Minimize the effort of taking backup by implementing automatic backup at the end of day daily.
• Helped team in creating the Business requirements Document, review with users and obtain sign-off to start the detailed designs.
• Implementing the sorting functionality across the application in all stored procedure
• Implementing the search functionality across the application in all stored procedure irrespective of whatever the requirement is.
• Will be handling live issues and will take them to the closure as soon as they are raised.
• Analyzed, identified and implemented user roles and assigned relative database access privileges.