CURRICULUM VITAE
MOHD AMJAD
Al Nahda, Sharjah (UAE)
Profession: Analyst
E-mail: -************@*****.***
Mobile no: +971*********
SUMMARY: -
I am a highly versatile and self-motivated professional, experienced as MIS analyst and Sales Analyst. In profession I do executing and managing operational activity on daily basis as well as correspondence budgeting & forecasting. Core competency find out the meaningful business output with accurate analysing & summarizing multi retail business reports while using advance level of Microsoft Excel and MS Power BI. I am looking ahead to pursue a challenging career in an organization with positive enthusiasm and fast faced learning ability.
ACHIVEMENT KEY SKILLS: -
Excellent proficiency on advance Microsoft Excel even knows how formulas work
Providing a proper business insight to the wider stakeholder
Strong analytical thinking and quantitative analysis skills, as well as presentation skills
Generating business tracking reports under and over performance
Interaction and collaboration with several internal departments
Executing & managing promotions entire regions within UAE
Compiling data from multi department and find out the meaningful business output
Strong evaluation on numbers and detail oriented
Correspondence budgeting and forecasting
Executing & monitoring all trade spends rebates, FGR, VGR, Listing Fee, Opening Fee, Schemes etc.
Managing and evaluating multi-channel / region sales and trade spends
Assigning target to sales team under identifying target segment
Familiar with data extraction in Microsoft Excel from several business tools
Ability to handle multi task with minimal guidance and supervision
Taking initiative and keep strong follow-up
Enthusiastically proactive & fast faced learner
Driven ethically in profession
CURRENT WORK EXPERIENCE: -
Seville Products Ltd – UAE Sales Analyst (Dep. Trade Marketing S&D Planning)
Jan 2019 till now
Prepare and execute Chocolate, Confectionery, Wafer sales plans and investments plans across the UAE within coverage all channel/region
Prepare annual operating plans (AOP) distribute and revalidate on monthly basis
Executing promotions for the entire regions/channel under approved budget
Prepare sales analysis reports in terms of budget Vs achievement daily/weekly/monthly/quarterly/yearly
Generating products/sub products/ brands/ regions/channels/ LOB/ customers and SKUs sizes, location wise business reports
Generating cost of doing business report (CODB), daily sales report, trade investment report, salesmen business tracking reports etc.
Execution of the business development plans area wise with very clear objectives & target
Assigning credit notes, FOC & discount to the MT/GT/FS customers and keeping accurate evaluation
Collect, analyse, evaluate data in order to increase sales productivity and profitability
Prepare product wise sales analysis and report on fast and slow -moving products
Interprets results of over-all sales to identify elements of under and over performing areas
Provide the product details, pricing and availability to sale team
Monitoring & managing key account reports and report to concern management
Tracking distribution sales performance in terms of budget & forecast
Executing & managing rebates, progressive Rebates, FGR, VGR, listing fee, opening fee, schemes etc,
under approved trade budget
Managing and updating key performance indicator (KPI) reports
Finding measure market potential channels/regions wise and segmentize the target
Assigning the targets to the sales team on SKU level, net sales volume and net sale amount
Keeping correspondence coordination with internal departments category, sales and finance etc. through emails & meetings
Keeping periodic gap analysis on customer product holding total sale and total investment
I do use advance Microsoft excel formulas while generating and analysing the business reports
PERIVIOUS WORK EXPERIENCE: -
Nokia Network - India MIS Analyst (Dep. Finance)
Jun 2016 till Sept 2018
Created and managed MIS finance reports in Ms excel on daily, weekly, monthly basis
Invoicing and filing of various business expenses of senior management
Import Invoicing data from SAP and CRM and verifying up to date and report to top management
Checking daily payment and follow up for invoices
Record keeping of daily invoices files
Worked with different type of reports like, cost saving reports, revenue reports, vendor invoice verification reports
Extracting data from various business tools in Ms excel and generating report globally
Data analysis & management for various business reports with advance Ms excel by, V-lookup, H- lookup, all If conditions with OR & AND, pivot table, pivot chart, subtotals, and conditional formatting, data validation, protection, Consolidation of data, and excel table etc.
Compile the data from multiple Ms Excel sheets and report the summary to top management
Providing the training and resources needed for new joiners
Using MS Access or visual basics while preparing and analysing the reports
Well versed with Microsoft outlook to communicate with all clients globally
EDUCATIONAL QUALIFICATION: -
Bachelors in Commerce in 2015
Intermediate school in Commerce in 2012
Secondary School in 2010
ADDITIONAL CERTIFICATION: -
MIS course in computer applications M.S. Office, Advance Excel, Power point, Word
PERSONAL PROFILE: -
Passport No : R4863327
Date of Birth : 25 Apr 1995
Gender : Male
Nationality : Indian
Language Known : English and Hindi Marital Status : unmarried
Visa Status : Employment Visa
I solemnly declare that all the above information is correct to the best of my knowledge and belief.