SYED SAQLAIN

• Exposure/Experience: Information Technology- Supply Inventory Management & Pricing , 2 Projects
• Analytical Solution Building: Collaborative Planning, Forecasting & Replenishment (CPFR):
  Helped the top level executives in planning the supply & sales for Consumer Small business across North America & EMEA region. Also, helped them with various KPI's & Metrics to gauge where we are comparatively to the current market which showed a drastic drop in inventory costs and there by increase in the actual sales.
• Helped them understand the current market scenario and sales run rate in order to plan the sell-in(Order for procuring & Manufacturing) and gauge the current weeks of supply inventory.
  Cultivated relationships with industry leaders and within company to share Insights and Recommendation regarding the current state of our Supply chain cycle.
• Furthermore, Enhanced interfaces to promote better functionality for users.
• Discovered root causes of problems and identified appropriate solutions for the Supply Inventory Management team.
  Performed quality assurance to meet appropriate standards and facilitate improvement of processes.
• Assessed data modeling and statistics to integrate high-level business processes with data rules.
  Recommended process improvements to continually identify, analyze and fix constraints and challenges.
  Analyzed unstructured information to derive key insights.
  Tools used : Microsoft Excel, Macros, SSIS, MS SQL Server, Power BI.
• Retail Market Model:(WIP)
  Currently building a tool for Consumer Small Business retailers, which will help the pricing & other team's in the organization understand pricing variation across various products of same category from different competitors being sold across different retailers in North America. This will help the team in understanding the performance of Dell products with respect to its competitors and what is the opportunity gap for Dell across individual retailers.
• Providing various insights and recommendation regarding the factors influencing retailer for or against dell products, which will help the team in designing more campaigns for different retailers individually and a Monthly report in terms of Increase/Decrease in Revenue/Units across all retailers which will help them in deciding price of the products compared to its competitors.
  Tools used : Excel, SSIS, MS SQL Server, Python & Power BI

• Exposure/Experience: Customer Intelligence platform, 1 Industry (AdTech), 3 Projects
• Analytical Solution Building: Revenue reports analysis :

Built the first in house tool to record the revenue generated across various countries, products, pricing model’s, clients and also track Daily CPM revenue which helped the C-Suite and Sales executive in focusing on missed gap’s, client acquisition and client retention. Majorly Client acquisition increased by ~60% and Revenue growth increased by a whopping
75% YoY.(GCP, Postgre SQL, Tableau)
• Marketplace reporting : Built a framework which helped the C-Suite executives in understanding marketplace business and revenue generated across agency, Brand or Publisher which helped in analyzing and differentiating clients based on their desired business model’s which led to an increase in marketplace revenue by ~30% and converting ~30% of existing clients to Subscription business model. (GCP, Postgre SQL, Tableau)
• Data Partner Cost analysis and reporting : Helped the C-Suite executive to understand the cost (Data partner Share) incurred for consuming data from various telco and non-telco Data partners which helped in analyzing and reducing the cost incurred on inactive data partners and motivating active data partners by providing new business model (Fixed fee and Minimum guarantee) depending on various factors which led to cut down costs by almost ~15%.
(GCP, Tableau , Postgre SQL)

various factors which led to cut down costs by almost ~15%.
(GCP, Tableau , Postgre SQL)

• Exposure/Experience: 2 Fortune 250 clients. 2 Industries (Convenience stores & ecommerce), 4 Projects
• Client engagement: Actively engaged with C-suite Clients in setting expectations,planning and delivering solutions. Prepared and presented monthly and quarterly business reviews to stakeholders.
• Analytical Solution Building: Delivered several high-visibility projects including :
• Sponsored products-SKU analysis: Helped the top-level executives of leading e-commerce industry in identifying missed opportunities which showed an average increase of 40K$ per month by creating a tool enhanced with an ability to visualize 100K top-performing SKU for a rolling year along with qualitative & quantitative details. helping them in tracking the performance of these SKUs across various levels. (Hive, GCP, Teradata, Tableau)
• Search key word analysis: Helped top level executive In identifying the trending keywords by traffic, sponsorship, bidding and other related metrics by providing an analytical framework which will increase the revenue generated through keyword sponsorship by ~20K$ per month and also help them in taking better business decisions in terms of marketing, advertising, key word bidding,
keyword sponsorship etc. (Hive, GCP, Teradata, Tableau)
• Vendor Portal: Collaborated with leading convenience store to build a tool for the purpose of monetizing data which helped their vendors in identifying the performance of SKU's, promotions, untapped potential and forecasting future sales and units for a specific vendor as a part of POC which showed an increase of ~22K$ and helped them in optimizing the inventory at different outlets.(MS
SQL ,PowerBI, Python)
• Campaign measurement: Built a reporting framework for gauging the effectiveness of campaigns by developing relevant KPIs and aligning with all stakeholders (Ms SQL, PowerBI)
stakeholders (Ms SQL, PowerBI)igning with all
stakeholders (Ms SQL, PowerBI)

• Exposure/Experience: 1 Fortune 100 clients, 1 Industries (Automobile), 1 projects
  • Analytical Solution Building:
  • Serial Data Verification: Worked with a leading US automobile client to help
  them in testing the viability of automating verification of ECU's test which
  results in a reduction of manual effort & time by 40%, set up a centralized data
  gathering process which parses structured and semi-structured data and
  executes test case-specific complex processes and saved $300K per year for the
  client.
  • Responsibilities: Responsible for problem definition, data cleaning, analysis, insight
  generation, visualization, and presentation.
  • Recognition: Recognized as a go-to person for storyboarding and Business
  intelligence tools related queries.
  • Public speaking: Frequent public speaker on organizational forums covering topics
  such as Trends in technology, Effective client engagement etc.