About
Innovative and performance data driven with deep passion for technology. Experience in equity research analysis, data visualization, data analysis to uncover insights, statistics and creating dashboards with a story to tell.
Skills & Expertise (12)
Work Experience
Asst. Manager-Data Analyst & SalesAdmin
Celon Laboratories Pvt Ltd
Feb 2024 - Present
Design the Field Incentive and calculate the incentive amount based field employee achievements on Quarterly. Prepare & Automate daily primary sales and outstanding dashboards in Power BI for both divisions at Territory, Zone level and planning the Target Setting. Compile and analyze business sales & Business Review the performance for the Vivilon & Revilon Division. Field Activity monitoring, Dr visit, Coverage Analysis, Compliance parameter, frequency check of meeting with Dr through CRM portal (Hidoctor) and support the continue support to improve all SFE parameter. Developed and publish Power BI dashboards for primary and secondary sales, as well as stock data for both divisions, by the 8th of every month & drawn different insight to understand the Business gap and necessary action has taken. Control the Return from Field and liquidate secondary stock from customer & liquidate inventory stock with proper stock allocation. Prepare zone-wise price groups of each products for both divisions and upload them into the reporting portal in collaboration with the Sales Accounting team with help of power automate. Automate the Power tool to send the mail to all field employees and collecting daily basis sec sales in the ground. Collect weekly secondary sales updates from Zonal Heads through Google sheet and share the weekly secondary tracker with Division Heads for both divisions. Analysis Market data of IQVIA/MIDAS data to understand the market position and set the KPI parameter for Business Decision. Maintain and update master data in the online reporting portal, including doctor list modifications, stockiest creation and mapping with HQs, product creation (division-wise), HQ creation and hierarchy management, field employee updates (new hires and resignations), and holiday list uploads. Coordinate approvals for various marketing activities with BUH and the Compliance Department. Collect and submit pre- and post-event documentation for approval and bill processing in Finance. Implemented Digital field Expense Module in CRM software (Hidoctor)& quick validation of all employee expense done every month. Sales Forecasting at Head quarter& product level done on month on month with help of python tool & ensure the product availability at CFA level.
Senior Data Analyst
Reliance Retail Ltd
Jan 2023 - Jan 2024
Managed inventory by three segments SFM, FM, NFM & creating inventory report for 42 Fc’s which include 7 Lac + SKU’s into four categorizations Pharma, OTC, Generic and Own Brand. Reported to concern team to raise PO when out of stock (OOS) percentage fall below fixed level. Creating Script for Discount and Scheme SKU’s based on inventory FC wise in daily basis by python code and publish in banner. Prepare Report weekly for internal stock transfer by calculating positive margin SKU’s. Published Daily/MOM Order Value at FC level and showing trends, AOV, GM & ABS. Analyzing low and high sales region, state, store wise on daily basis to strengthen the business and send to the concern team. Tracked the fill rate% for all FCs to conclude whether these FCs have maintained the average PAN India fill rate% (i.e., 95.65%). Daily monitoring the trend of short pick items & qty MoM which get minimize from the overall avg. of 33% to 19%. Worked on more of the 1Cr+ inline items of data sets to analyze them using different analytical tools like Excel, Pivot, Power Query, SQL, Power-BI, DAX, creating the relationship between multiple data sets and get the insight of the business as per requirement.
Associate Data Analyst
Muplant Technologies Pvt Ltd
Jan 2021 - Dec 2022
Creating - weekly, fortnightly, monthly, quarterly, yearly P/L Reports for different marketplace like Zalora, Lazada, Esty etc. Managing the inventory on vinculum, co-ordinate with warehouse team for proper dispatch of orders. Created Seasonality report on the bases of pervious sales analyses which help to select the SKUs which are needed to be re-order. Managed the order delivery/ fulfillment in various state within TAT. Co-ordinate with warehouse team members for inventory shifting to FBZ (Fulfillment by Zalora). Tracking top SKU's performance in Daily base and share with WhatsApp group. Created excel formula-based discount percentage selection on the bases of how old the stock is as per stock aging report (E.g., If stock is 100 days old, then it put maximum discount from the given disc slab). Automate Various Reports with help of power BI and update daily/weekly basis and publish to concern team.
Supervisor
Utility Projects and Services Pvt Ltd
Jan 2017 - Aug 2018
Monitoring the chiller unit and keep then temperature of chilled water at below 18 degrees. Conduct preventive maintenance periodically once in a month/Yearly for each AHU and Chiller Unit. Resolve any failure in Chiller, AHU, Ventilation Unit, etc with help of concern vendor. Procure new equipment, materials for keeping proper stock and using whenever failure was arise. Prepare the Daily Running Report send to Head Office. Challenging the power consumption in overall unit and took proper action of preventive maintenance, shutdown unit at proper time, etc and gives better result.
Education
M.Tech, Materials Science and Engg - NIT, Trichy
2018 - 2020 · Afghanistan
B.E., Mechanical Engg. - National Engineering College, Kovilpatti
2012 - 2016 · Afghanistan
Certifications
Full Stack Data Science
AlmaBetter · 2022
SQL Gold Badge
HackeRank · 2022
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (12)
Click a skill to find developers with the same skill
