Atharva Sawant Email & Phone Number

Mumbai, Mh, In

Hyderabad, Telangana, India

Healthcare Analytics Engineer:--Analytics Solutions for a Therapeutics company-Sales and Specialty Distributors data analysis and reporting-Brand Planning and Market Opportunity Analytics-Ad-HOC Analytics on Promotional activities effectiveness and competitors drug impact-Market Sizing and Line of Therapy Analytics-SQL scripts for automating recurring workstreams-Mentoring Junior Associates and Guide them on Pharma Analytics Use cases and Data sets-Ad-HoC Claims Analytics Tools and Technologies:-Excel, SQL, Snowflake, Python, PowerBI, AlteryxDatasets:-IQVIA Claims, KOMODO Claims, EDI 867, DDD Sales, Veeva Calls and RTE, Promotional DatasetsTherapy Area:-Breast CancerTeam:-Gaurav Soni, Umang Bhoutika, Polomi Patel, Srikanth Bharatam, Nandan Mishra, Shital Gadekar

Bangalore Urban, Karnataka, India

Project:-Retail Industry Customer Reporting and Visualisation Responsibilities:-1.Propose solution for reporting migration from PHP based reporting to DOMO reporting2.Business Intelligence CoE - Build demonstration dashboards for Customer POCTools/Technologies:-SQL,DOMO, Business IntelligenceTeam:-Kiran Cheruku, Sussanna Pabbineedi, Santosh Marka, Brucelin Kithion, Rajiv DattaManager:-Subramanya BapatOther Responsibilities:-1.Deliver Snowflakes, Azure Data Factory and Power BI KT sessions to the team2.Building internal status reporting and planning tool using BI Tools

India

Project:Analytics Solution for US Healthcare Product CompanyTools/Technologies:-SQL,DOMO,Alignstar,AlteryxWorkstreams:- Alignment,Goal Setting,Targeting,Sizing,IC PayoutsResponsibilities:-1. Providing Sales and Commercial operations analytical support. 2.Developing backend dataflows using SQL & ETL Jobs in DOMO Tool.3. Incentive Compensation Payout analysis for Sales Consultants/Reps.4. Visualizing the Sales, Targeting, Payout Insights in DOMO Dashboards.5. Conducting Sales, Alignment & Ad-HOC Analysis for Client across entire USA.6.Analytical support for Growth metrics, Bonus payout and helping client in designing the strategies to increase productivity.Team:-Raunak Jain, Tushar Choudhary, Chandan Gembali, Saurabh GandhiManager:-Gaurav BhattProject:-Analytics solutions to answer business question for US Pharma giantTools/Technologies:-Alteryx, Python, ExcelWorkstreams:- SegmentationResponsibilities:-1.Answering key business questions by analyzing the data2.Competitor product analysis3.HCP Stability and Profiling analysisTeam:- Raunak Jain, Kshitij Singh, Rahul DuttaManager:- Gaurav BhattProject:-Claims Data AnalyticsTools/Technologies:-SQL, Alteryx, Excel, PythonWorkstreams:- Patient Journey, Patient Treatment Insights, line of TherapyResponsibilities:-1.Writing SQL Scripts for data extraction and analytics2.Ad-HOC Analytics request based on the requirement3.Treatment wise counts of patients from the Claims data-YoY summary counts4.Patient Journey Insights5.HCP Specialty Distribution6.Payer Type analysisTeam:-Raunak Jain, Darshan Jhunjhunwala, Kshitij SinghManager:-Akhil Bafna

Mumbai, Maharashtra, India

Project:-Delivered BRD and RFP for one of the Largest Banks in India and assisted in SI onboarding.Responsibilities:-1.Carrying out As-is Assessment through series of Workshops to Deliver Functional, Non-Functional and Technical Requirements.2.Delivering To-be state Architecture and Suggestions on Possible Improvements in Current Reporting, Operations in Bank.3.Assist Bank in Selection of SI with help of Technical Evaluation.Manager:-Rituparna KadamTeam:-Amit Khurana,Ajinkya MukhedkarProject:-Application Maintenance for Largest FMCG companyTools/Technologies:-Azure ADF, PowerBIManager:-Shanmugaraj NatrajanTeam:-KN Chetan, N Vighnesh,Sulagno RoyProject:-Analytics DashboardTools/Technologies:-Talend Open Studio, PostgreSQL, Apache supersetResponsibilities:-1.Data Model Design2.Developing Talend ETL jobs3.Visualize data using Apache supersetManager:-Niharika AnandTeam:-Keerthika P,Ishika Pal,Ashitha Senthil, Nideeksha B.KFirm Contribution:-Working for Hiring Initiatives for Hire and Upskill Campaign and Australian ProjectsManager:-Chirayu Chavda & Sudharma GargeProject:-Analytics DashboardTools/Technologies:-Talend Open Studio, PostgreSQL, Apache supersetResponsibilities:-1.Data Model Design2.Developing Talend ETL jobs3.Visualize data using Apache supersetManager:-Niharika AnandTeam:-Keerthika P,Ishika Pal,Ashitha Senthil, Nideeksha B.KFirm Contribution:-Working for Hiring Initiatives for Hire and Upskill Campaign and Australian ProjectsManager:-Chirayu Chavda & Sudharma Garge

Bachelor Of Technology, Electrical And Electronics Engineering, 8.43/10

Major Focus on 1.Electronic circuit design 2.Neural network 3.Communication Techniques

Hsc Science, Electrical And Electronics, 87.20%

Major Focus on 1.Electronic circuit design and it's analysis 2.Testing and implementation of various basic electronic circuits

Ssc, Secondary School Education, 97.20%

Major focus on 1.Extra curriculars and sports activities 2.Learning life values which will help in long term