Headline

Senior Analyst at eClerx with 10+ years of experience

Location

Mumbai

Work experience

Senior Analyst at eClerx

Sr. Analyst at Eclerx Services Limited, May 2019 - Present · 7 yrs 2 mos, New Product launch Marketing: Designed New Model report for new product introduced in the market by the company. Use technical specifications provided by client to search and identify comparable competitor products from websites. Collect prices from worldwide website and create report which provides analysis which enables client to decide the proposed price of the product before launching into market New Product Pricing: Pricing the product prior launching in market on the basis of cost of the product provided by client. Based on the inputs we add margin percentage, country level tax rate, country level freight rate and import duty if applicable to calculate new list price, sending new list price for approval to client review. Post approval we upload the new list price on tool which is directly linked to the client’s website. Arranging web calls with client Handling various Adhoc request by preparing required excel based template Giving weekly and monthly reports to client

Analyst at Rochem Separation systems (I) Pvt Ltd, Sep 2018 - May 2019 · 9 mos, Preparing required Dashboard in Excel though gathering SAP & Operational data Working on Data automation through MS Excel, VBA, Macros make it One-Click Data Preparing different kinds of MIS reports & dashboards as per management requirement Coordinate with Sales, Maintenance/Service team to focus on business Growth and Opportunities Creation of automated & user-friendly template to understand the operational data Provide support for quality assurance testing and defect resolution & handling users queries Preparing weekly dashboard PPT through gathering information from all departments and shared to the MD Preparing dashboard, excel templates as per requirements and present to the MD Conducts meeting with others departments and help them to understand excel based template and excel formulas Attending meeting with department heads to understand their requirements and shared the MOM to MD

Sr. Analyst at Eclerx Services Limited, Aug 2011 - Sep 2018 · 7 yrs 2 mos, Reporting: Market Analysis: Create report by capturing prices from various reseller websites, present summary which gives insights about current position of the company product in the market against competitor product Based on this report bring forth the reasons if Competitor products are in better position compared to company product. List down the factors(Market share, No of unit sold, aggressive Promos) which are affecting the revenue growth of the company Analyze this report and provide the suggestion on price change for product to the client to improve position of the company product into Market Competitive analysis: Perform Competitive analysis with other competitor websites, create PPT presentation to analyze the strength and weakness of Client website interms of Navigation, Availability of data, Interface, Complexity etc. Analyze reseller websites, inter`ms of coverage, World wide website ranking and Catalog Providing Competitive intelligence means defining, gathering, analyzing, and distributing intelligence about products, customers, competitors which needed to support executives and managers making strategic decisions for an organization Customer focus: Handling Client Calls, explaining weekly activities performed by team, presenting Resource utilization slides and projections for the week ahead and also handling client queries regarding report Track various competitors of our client at regular intervals to understand the nature and Strength of the competition Make MIS and analytical reports on market positioning of the client and its product segments Using Ms SQL Server and Advanced Excel functions like VLookUp, Index & match function, Pivots, Filters, etc. Providing analytical reporting to clients on regular basis/adhoc basis Create Daily Work/ Weekly Reports and Metrics of Team Members Preparing clients reports showcasing Quality, Daily transaction processing Providing Adhoc request data to the Managers and Clients Allocating request to Team members Ke

Data Analyst at Datacomp Web Technologies (I) Pvt Ltd, Mar 2010 - Aug 2011 · 1 yr 6 mos, Executing basic SQL queries Providing support on mutual fund database to client Solving issues related to mutual fund database Checking daily updates related to mutual funds and uploading the same on server Uploading data files on server on daily basis

Education

Bachelor of Commerce - BCom, Accounting, kj somaiya college of arts and commerce

B.Com First Class, K J Somaiya College of Arts & commerce