Headline

Data Analyst at MySmartprice.com

About

5+ years of experience as Data Analyst: Roles and Responsibilities : • Performed Data validation, Report creation, Data extracts, and personnel training. • Analyzed data to identify patterns in user behavior to increase the CTR of promotional Banners & Ad Campaigns from 7% to 12%. • Pullout Illogical Data from Redshift and rectify them and refined the quality for data. • Performed analysis on Non-MSP transactions data and listed out new subcategories to be added in the MSP inventory catalog. This increased the subcategories from 147 to 310 thereby increasing the GMV by 20%. Create GFK reports in which the store's unstructured data need to fetch from the database in a structured data format at a regular interval of time. • Deliverables: Pullout all the eCommerce data from Redshift and rectify them and refined into quality data and fulfill all requirements from the client like product name, price, quantity, OrderId, Order date, Address, etc. Demographics: Created statistical reports on mobiles, electronics, and appliances, etc., based on city, gender, age group. • Created and sent daily dashboard to the team lead, managers & senior management for Education Popups, Inventory GMV, and QA using Excel and Tableau. • Created MIS Reports Monthly & Weekly Basis and reported Analytics of transactions / Revenue Category Wise. Participated in requirements meetings and data mapping sessions to understand business needs. • Created various Excel documents to assist with pulling metrics data and presenting them to give a concise understanding of the best placement for needed resources. • Created Daily Dashboard Report on a daily basis and sent it to Senior Management along with the founder and co-founder of the company. • Created Deals Transactions Report on a daily basis.

Location

Hyderabad

Work experience

Data Analyst at MySmartPrice.com, Jun 2015 - Present · 11 yrs 2 mos, Greater Hyderabad Area

Category Manager at MySmartPrice.com, Jun 2015 - Present · 11 yrs 2 mos, Devipur, Jharkhand, India

Education

Bachelor of Engineering - BE, Computer Software Engineering, JNTUH College of Engineering Hyderabad