Description
This Ecommerce analytics solution provides Analytics information about user target audience provides user with insights into customers' geographic location, age, gender, and perhaps their interests or product preferences. Acquisition, this data informs user how exactly customers found his /her store, and how they arrived at customer site. This information indicates which marketing channels user brand should focus on. Behaviors, this data shows user how customers respond to information on user ECommerce site. Customer behavior relates to the content customers click, the products that interest them, and what they buy. The data could include how long customers spend before making a purchase or leaving the site
Roles and Responsibilities
Performed Data Enrichment jobs to deal missing value, to normalize data, and to select features. Extracted data from Twitter using Java and Twitter API. Parsed JSON formatted twitter data and uploaded to database. Developed Hive queries for analysis, and exported the result set from Hive to MySQL using Sqoop after processing the data. Structuring the Data Marts to store and organize the customer's data. Maintained PL/SQL objects like packages, triggers, procedures etc. Mapping flow of trade cycle data from source to target and documenting the same. Performing QA on the data extracted, transformed and exported to excel. Participated in all phases of Data Mining; Data Collection, Data Cleaning, Developing Models, Validation, Visualization and performed Gap Analysis. A highly immersive Data Science program involving Data Manipulation & Visualization, Web Scraping, Python programming, SQL, GIT, Unix Commands, NoSQL, MongoDB. Used Pandas, NumPy, Matplotlib in Python for developing various operation. Worked on different data formats such as CSV, JSON, XML.
Technologies: Python, Fast API, SQL, Postman, Docker, ETL, Statistical,Analysis
Industry: Ecommerce