Usman Ali

Web Application Pro Seller Tools A MERN stack-based application designed to help Amazon sellers optimize their business through integrated data analysis, automated reports, and ad performance optimization. Developer Usman Ali Designation Associate Software Engineer Project Date Octuber 2023 - Feb 2023 Introduction Pro Seller Tools is a MERN stack-based application designed to help Amazon sellers optimize their businesses through integrated data analysis, automated reports, and ad performance optimization. The application provides robust features such as time-based COGS management, fee tracking, and business report generation by pulling data from Amazon Seller and Advertising APIs. This report outlines the development, features, and impact of Pro Seller Tools, demonstrating its value in enhancing operational efficiency and driving business growth on Amazon. Project History • Background: Increasing need for Amazon sellers to manage and optimize their business operations through comprehensive data analysis and automation. • Objective: To create a tool that integrates data from Amazon Seller and Advertising APIs, providing insightful reports and optimizations to grow businesses on Amazon. • Scope: Development of a service-based application with modules for authentication, dashboard, products, summary snapshots, jobs, user management, etc. Requirements • Data Integration: Pull data from Amazon Seller (SP API) and Advertising (Adv API). • Data Processing: Mix data from both sources to provide comprehensive insights. • Cost of Goods Sold (COGS): Manage COGS as a time-based metric for future scalability. • Fees Management: Integrate and manage various Amazon fees. • Business Reports: Generate business reports from Seller Central. • Automated Reports: Provide automated reporting capabilities. • Bids & Optimizations: Tools for optimizing ad bids and performance. Technologies and Tools • Tech Stack: ⚬ Frontend: React.js Challenges and Solutions • Problems Encountered: ⚬ Data synchronization issues, ⚬ Backend: Node.js, Express.js handling large volumes of data, ⚬ Database: MongoDB ensuring real-time reporting. ⚬ Other Tools: Amazon SP API, Amazon Adv API • Solutions: • Rationale: The MERN stack was chosen for its efficiency in handling data-intensive ⚬ We are implementing efficient data processing algorithms. applications and providing a seamless user ⚬ Optimizing database pipelines. experience. ⚬ Using other mechanisms. Modules • Auth: User authentication and authorization. • Dashboard: Overview of key metrics and insights. • Products: Management and analysis of product data. • Summary Snapshots: Quick summaries of business performance. • Jobs: Schedule tasks for data integration and report generation. • User Modules: User management and role-based access control. Auth Module The Auth module in Pro Seller Tools employs JWT tokens for secure authentication and authorization. Upon login, JWT tokens are generated and stored on the client side, providing access to protected routes based on user roles. Robust error handling ensures a seamless user experience, while password hashing and HTTPS encryption bolster security. User registration includes validation for data integrity, and token expiry and refresh mechanisms maintain user sessions. With these features, the Auth module ensures secure access to application resources, enhancing user trust and safeguarding sensitive data. Dashboard The Dashboard module in Pro Seller Tools offers users a comprehensive overview of key metrics and insights crucial for informed decision-making. Users can track sales trends, monitor ad campaign effectiveness, and optimize product listings through intuitive visualizations and customizable dashboards. Advanced features include predictive analytics for forecasting sales and identifying market trends, empowering users to strategize and adapt their business strategies effectively. With its user-centric design and actionable insights, the Dashboard module is a vital tool for Amazon sellers to drive business growth and maximize profitability. Products The Products module in Pro Seller Tools facilitates comprehensive management and analysis of product data. This module displays detailed information for all products, enabling users to track performance and trends. Key functionalities include downloading COGS (Cost of Goods Sold) and ACOS (Advertising Cost of Sales) data, as well as generating detailed product reports. By integrating these features, the Products module provides critical insights that help users optimize their inventory, manage costs, and improve advertising efficiency, ultimately enhancing overall business performance. Jobs The Jobs module in Pro Seller Tools is designed to schedule and manage tasks for data integration and report generation. Utilizing Node.js, various agenda jobs are written to synchronize data with the database at different intervals, ensuring that the information is always up-to-date. These scheduled tasks automate the process of pulling data from Amazon Seller and Advertising APIs, processing it, and generating comprehensive reports. By running on specified time frames, the Jobs module ensures efficient data handling and timely updates, enabling users to access accurate and current insights without manual intervention. User managment The User Modules in Pro Seller Tools provide comprehensive user management and role-based access control. This module includes detailed user profiles, user rights management, and control over which modules each user can access. Users can invite others to connect their stores, manage data, and adjust settings. Invitations are seamlessly integrated, allowing new users to join and configure their access based on predefined roles. By implementing these features, the User Modules ensure secure and efficient management of user permissions and access, enhancing collaboration while maintaining data integrity and security. Summary • Developed to meet Amazon sellers' needs by integrating data from Amazon Seller and Advertising APIs. • Provided robust features including: ⚬ Automated reporting ⚬ Time-based COGS management ⚬ Ad performance optimization • Successfully delivered a comprehensive tool enhancing business decision-making and operational efficiency. In summary, Pro Seller Tools was developed to address the needs of Amazon sellers by integrating data from Amazon Seller and Advertising APIs to provide robust features like automated reporting, time-based COGS management, and ad performance optimization. The project accomplished its objectives by delivering a comprehensive tool that enhances business decision-making and operational efficiency. About me With one year of experience as a Full Stack Engineer, I specialize in NodeJS development and integrating with frontend frameworks such as React. I excel in designing dynamic web solutions that combine robust server-side logic with user-friendly interfaces. I have successfully delivered custom tools for platforms including Amazon (MWS, Selling Partner SP API), Amazon Product Advertising, eBay, Walmart, Etsy, and Shopify. My technical skills encompass frontend technologies like Bootstrap, React, and JavaScript; backend technologies such as Node.js (ExpressJS), NestJS, and GraphQL; databases including MongoDB and PostgreSQL; and tools like Git, Jira, and Docker. My expertise in AWS and various web services, coupled with a talent for innovative problem-solving and a collaborative approach, enables me to effectively manage complex projects and Usman Ali Associate Software Engineer deliver efficient web solutions. -- Thank You