Spotfire, Power BI

Company Name          : GSK Vaccine.( Amsterdam Netherlands) (Jan-2018 till now)
Designation                  : Spotfire Consultant
Analytical Tool            : TIBCO SPOTFIRE V7.0 (Business Intelligence Tool)
Domain                       : Health and Life Science
Client Name                : GSK Vaccine

• Developed spotfire dashboard on Risk based monitoring (RBM) for the CRA’s.
• Used algorithms like Poisson sigma lookup table, chi square, Wilson one sided lookup table and Wilson two-sided lookup table to calculate upper and lower control limit for identifying risk in different key risk indicators.
• Developed a dynamic report (template) which was used for different studies at the same time.
• Developed dashboard on Medical Review Listings (Data Listings)
• Developed the patient profile dashboard on spotfire.

Company Name          : GENPACT. (JANUARY-2017 TILL NOW)
Designation                  : Business Analyst
Analytical Tool          : TIBCO SPOTFIRE V7.5,7.6/ Tableau v10.1 (Business Intelligence Tool)
Domain                      : Health and Life Science
Client Name               : Pfizer

• Developed Spotfire dashboard on Information about overlapping colleagues “Colleague Information Dashboard”
• Worked on the development and maintenance of Global Content library Dashboard which was linked to the SharePoint list.
• Experience in working with multiple spotfire dashboard and providing support.
• Worked on Scheduled updates of the spotfire webplayer Reports
• Experience in maintaining and updating multiple dashboards.

Company Name          : PPD PHARMACEUTICAL LTD.
Designation               : HRIS SPECIALIST (JUNE-2015 to JANUARY-2017)
Analytical Tool          : TIBCO SPOTFIRE Version 6.5, 7.6
Other Tools               : Crystal Reports
Language                     : SQL, Iron Python
HR Tool                       : Lawson

• Developed multiple Spotfire dashboard for calculating headcount and Turnover based on country and department, and department wise dashboard
• Knowledge of Lawson tool used by HR and ability to write SQL query to pull data from different Lawson screens
• Created scheduled and ad hoc reports as requested.
• Assisted HR project team with technical issues related to the HRIS system.
• Developed Spotfire dashboards for HR and executives
• Improved workflow and processes through system integration, streamlined reporting, and security.
• Designed and Implemented Crystal reports based on the requirements.

Automated leave card system used by HR team by writing VBA code and using macros and formulas to speed processes and maximize accuracy.



Company Name        : INFOSYS LTD (Mar 2012 – MAY-2015)
Designation               : SR. PROCESS EXECUIVE (Mar 2012 –SEP 2014) 
                                       PROCESS SPECIALIST (OCT 2014 – May-2015)
Project Name                       : 1) Strategic Revenue Management (SRM - RP)
                                       2) DOS - Data Operations and system
                                       3) HHP -House Hold Panel Data
Client Name              : PROCTER & GAMBLE (P&G)
Analytical Tool         : TIBCO SPOTFIRE (Business Intelligence Tool)
Domain                      : Retail
Description:

• Creating and Analyzing the Strategic reports for SRM drivers (Price, Promotion and Mix) based on the Trade Panel data, Point of sales data.
• Creating Spotfire matrix, visualizations and providing business insights to the end users and resolving the issues in Frontend (Spotfire) and Backend (SQL)
• Developed Spotfire dashboard to compare the pricing of company’s product with the competitor’s  product based on LCL and UCL values
• Driving the strategies by comparing P&G products with the benchmark products using the corridor limits based on the current market trends, historical data and product performance of FYTD/IYA.
• Support to the entire BA's for Revenue Pulse Global templates on Spotfire.

                        
                                 :