ayushibhojasia Profile | Freelancer

0.0

(0 reviews)

You're now following

Error following user.

This user does not allow users to follow them.

You are already following this user.

Your membership plan only allows 0 follows. Upgrade here.

Successfully unfollowed

Error unfollowing user.

You have successfully recommended

Error recommending user.

Something went wrong. Please refresh the page and try again.

Email successfully verified.

$6 USD / hour

$6 USD / hour

It's currently 7:23 PM here

Joined October 16, 2016

0 Recommendations

ayushibhojasia

@ayushibhojasia

0.0

(0 reviews)

0.0

0.0

0%

0%

$6 USD / hour

$6 USD / hour

N/A

Jobs Completed

N/A

On Budget

N/A

On Time

N/A

Repeat Hire Rate

Business Analyst @Amazon

Business analyst by profession, currently working with Amazon and having 16 months of experience in one of the biggest analytics service startups Musigma. I like to keep doing new things and broadening my knowledge and skill set. Particular about time lines and quality of work I deliver

See all Python Developers in India

Contact ayushibhojasia about your job

Log in to discuss any details over chat.

Portfolio

My client was facing an issue with analysis of scattered data and find correlation among various factors. Also, time taken to pull data to answer adhoc questions was too long

Created Analytical dataset and UI, highlighting the key trends, correlations and
impact of various factors
 Facilitated intelligent deep dives on various risk regions and accelerated data pulls
for adhoc analysis
 Discovered unexpected reason for decrement in drug share contributing ~$0.23 M
to Quarterly Revenue.
 Applied root cause analysis to design new marketing plan to recover the deep.

Analytical Dataset

Sales Force Impact Analysis

3424294

Analyse the impact of a sales campaign.
 Inspected a leading promotional scheme, discovered its futility thereby saving ~$30
M for the client.
 Worked on the enhancements that can be made to the promotional scheme for
better impact generation

Promotional Analysis

3-4 days in a month of a skilled resource was consumed to asses the quality of a report to be be consumed by ~500 sales representative.

 Provided complete automation for quality checking of weekly and monthly QlikView
dashboard using VB scripting in Excel
 It helped in reducing repetitive manual efforts and increasing resource throughput
by 97%
 Identified other pain points and helped the clients to make their other similar processes efficient

Quality Check Automation : QlikView Reports

 Designed At-a-glance view of the important key performance indicators of a million
dollar drug to be used by ~200 medical representatives, managers at district and
regional levels and tier 1 and tier 2 clients,
 Used on daily basis to make informed decisions for planning, execution and tracking
data that is critical to client's business.

Building QlikView Dashboard

 Automated Generation and distribution of weekly monthly reports
 Helps the clients to keep track of performance and trends for their drugs and competitor
drugs

Performance reports

My client was facing an issue with analysis of scattered data and find correlation among various factors. Also, time taken to pull data to answer adhoc questions was too long

Created Analytical dataset and UI, highlighting the key trends, correlations and
impact of various factors
 Facilitated intelligent deep dives on various risk regions and accelerated data pulls
for adhoc analysis
 Discovered unexpected reason for decrement in drug share contributing ~$0.23 M
to Quarterly Revenue.
 Applied root cause analysis to design new marketing plan to recover the deep.

Analytical Dataset

Sales Force Impact Analysis

3424294

Analyse the impact of a sales campaign.
 Inspected a leading promotional scheme, discovered its futility thereby saving ~$30
M for the client.
 Worked on the enhancements that can be made to the promotional scheme for
better impact generation

Promotional Analysis

3-4 days in a month of a skilled resource was consumed to asses the quality of a report to be be consumed by ~500 sales representative.

 Provided complete automation for quality checking of weekly and monthly QlikView
dashboard using VB scripting in Excel
 It helped in reducing repetitive manual efforts and increasing resource throughput
by 97%
 Identified other pain points and helped the clients to make their other similar processes efficient

Quality Check Automation : QlikView Reports

 Designed At-a-glance view of the important key performance indicators of a million
dollar drug to be used by ~200 medical representatives, managers at district and
regional levels and tier 1 and tier 2 clients,
 Used on daily basis to make informed decisions for planning, execution and tracking
data that is critical to client's business.

Building QlikView Dashboard

 Automated Generation and distribution of weekly monthly reports
 Helps the clients to keep track of performance and trends for their drugs and competitor
drugs

Performance reports

Reviews

Changes saved

No reviews to see here!

Contact ayushibhojasia about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer

Identity Verified

Payment Verified

Phone Verified

Email Verified

Facebook Connected

Top Skills

Browse Similar Freelancers

Python Developers in India

Python Developers

Browse Similar Showcases

Invite sent successfully!

Thanks! We’ve emailed you a link to claim your free credit.

Something went wrong while sending your email. Please try again.

Loading preview

Permission granted for Geolocation.

Your login session has expired and you have been logged out. Please log in again.