Shiv Jat
Surat
Summary
A results driven Data Analyst with more than a year of experience in data analysis and decision support. . Adapt at using analytical tools and technical skills like SQL, Pyspark dfs, Advanced excel along with US healthcare data like IQVIA to solve business problems and support informed decision making
Overview
3
3
years of professional experience
1
1
Certification
Work History
Entrepreneur
Kisan Agronet
05.2022 - Current
- Sourced initial funding to get business up and running while planning initial structure and making strategic first hires.
- Built business to 50+ traders by implementing effective marketing and customer engagement plans.
- Generated revenue of more than 27 million in first year of establishment
- Managed work force of 10+ people to get timely and quality production
- Used Tally to record day to day transaction data
- Managed purchasing, sales, marketing and customer account operations efficiently.
- Effectively tackled situations like production halt due to machine failure, workers unavailability,
- Generated additional revenue streams through constructive partner and client relationships.
- Tracked employee attendance and punctuality, addressing repeat problems quickly to prevent long-term habits.
Decision Analytics Associate
ZS Associates
01.2021 - 04.2022
- Served as the cornerstone for most of the data pulls as well as insights & analytical activities for mature brands team of one of the biggest US pharma company
- Utilized databricks platform with SQL and Pyspark dfs to extract and manipulate different pharma datasets like Xponent, Plantrack, Sampling, Promotional activiities, demographic, call plan and execution
- Used advance excel functions to analyze raw data and informed decision making insights with the help of visualization charts and dashboards
- Improved existing processes into automated reports for daily use
- Worked closely with client to address queries of several ad-hoc asks as well as advanced analytics processes of different LOE products
- Worked with reporting team to develop new system using excel and VBA
Education
Bachelor of Technology - Civil Engineering
Institute of Technology, Nirma University
Ahmedabad, Gujarat05.2021
Skills
- Budget development
- Inventory management
- Business Development
- Relationship building
- Business planning
- Revenue Generation
Projects at ZS Associates
- Reversed sales negative growth (-5% to -3%) of a US market OIC drug by tracking and targeting lapsed prescribers
- Gathered sufficient archival data using SAS to support digital campaign claim for a major GERD drug
- Performed a deep segmentation of a LOE GERD drug using lapsed prescribers with sales data to improve reach for promotional campaigns
- Performed root cause analysis to identify the reason behind small market share of a LOE COPD drug and suggested a mailing campaign with the top covered plans for high valued customers
- Assessed sales impact of 1.5 million dollars worth promotional campaign in a joint venture with Pfizer for 8 different brands by test-control analysis
- Built an advance analytical process by improving the existing test-control process to measure the impact of MRCM campaign for different drugs
- Provided target list of HCPs for digital campaigns to companies like Dr. First, MCRM campaign, Pfizer
Skills - ZS Associates
- SQL, Microsoft Excel, Basic Python, Pyspark dataframes, Databricks platform
- Data extraction, Data manipulation, Data visulaization, Data storytelling
- Team management, Time management, Critical thinking, Problem solving
Certification
- Data analytics course by Trainity (Ongoing)
- BridgeIT at Aaakar competition by IIT Bombay
Hobbies
Cricket, Football, eSports, Workout
Languages
English
Upper intermediate (B2)
Hindi
Upper intermediate (B2)
Timeline
Entrepreneur
Kisan Agronet
05.2022 - Current
Decision Analytics Associate
ZS Associates
01.2021 - 04.2022
Bachelor of Technology - Civil Engineering
Institute of Technology, Nirma University
Similar Profiles
Luiz Gustavo dos santosLuiz Gustavo dos santos
Recepcionista atendente at AGRONETRecepcionista atendente at AGRONET
Ekta ChovatiyaEkta Chovatiya
Farm tele advisor at KISAN CALL CENTER, MINISTRY OF AGRICULTURE AND FARMERWELLFAREFarm tele advisor at KISAN CALL CENTER, MINISTRY OF AGRICULTURE AND FARMERWELLFARE
Sheikh Arham ChishtiSheikh Arham Chishti
Sr. Android Engineer at Mera Gaon (Previously Kisan Network)Sr. Android Engineer at Mera Gaon (Previously Kisan Network)
GAURAV PATELGAURAV PATEL
Assistant Manager B2B at Bharti AirtelAssistant Manager B2B at Bharti Airtel
Jigneshkumar VaghasiyaJigneshkumar Vaghasiya
Electrical Engineer at DN EternalElectrical Engineer at DN Eternal