MIS Data Analyst
India
Worked as MIS Data Analyst with almost 18 years of Industrial process experience, Projects & Reports Handled -
Sales: Sales Annual Business Plan, Sales Product Forecast Plan, Sales Branch Budget Plan, Sales Incentive / Compensation, Discount Analysis, Order Inflow Daily , Sales Employee Acquisition, Sales Employee Retention, Setting Sales Targets, Area Potential, Area Coverage Map, Product Pricing (Price Realization), Trend - Product,State,Segment, Pipeline Enquiry Report, Top & Bottom Performers, New Customer Growth/Decline, Existing Customer Growth/Decline
Marketing: Monthly Budget vs Actuals, Dealer Campaign, Quality Enquiry (Hot/Warm/Cold), Source of Enquiry , Enquiry vs Order Conversion.
Service: Spares & Service, Dealer Service Performance, Spares Stock & Forecast Analysis,Customer Satisfaction Index.
Production & Logistics- On Time Machine Delivery, Process Time Analysis, Batch Plan, Inventory.
Finance Reports- Receivables - Outstanding, Reconciliation-Customer Ledgers, Sales Vs Collection, Account Reconciliation, Profitability, Quotation Comparison.
Human Resources- Manpower Requisition, Manpower Retention , Head Count Waterfall, Appraisal Workings , KPI Dashboards
Computer Competencies -
Advanced Excel:
Vlookup Data, Picture lookup, Hlookup, Hyperlinks, Visualizations-Pivot Table, Pivot Chart, Dynamic & Logical Graphs, Form Control, Data Validation, Indirect Substitute Formulas, Name Manager, Advanced Charting, Advanced Filter, Grouping, Split Functions, Text Functions, Nested IF, And Concatenate Functions. Conditional Formatting, Protecting Sheets
Excel Macro VBA: Excel Recorded Macros to run Auto Tasks , Auto Reporting, Auto Data Cleaning, Auto Mailers and Auto Updates in Power Point Slide.
Word & PPT: Mail Merge, Alignment for Documentation. Interactive PPT
Power BI: Data modelling & Data cleaning with Query, using DAX calculation, calculated columns, Measures, Reporting in Tabular, Matrix & Chart forms, Multiple Dashboard & Visualizations
Google Certification Data Analytics: Key Aspects, Data Phases, Data-Driven Decision-Making, Data Exploration
Objective for the Report
Who is the Stack holder - Analyses the Data/ Reports - Top/Middle Level/Entrepreneur
Idea how to work with Process / Formula / Logic
Clear requirement of Type of Work / Report Format / Graphs / Visualization / Dashboards
Frequency of Report Generation / Usage
Send bench mark report / dashboards
Proposal for Time to Complete the Project
Esitmated cost is $71.87 & delivery in 1 days
I work on MIS Data Analysis, Visualization Dashboards, Report Structure and Data Management using Power BI, Advance Excel and Recorded Macros. Almost 18 Years of Industrial Experience and Domain Knowledge of Sales, Service, Marketing, Finance, Production, Logistics, HR.
Contact SellerSo here are four main steps to follow when searching for freelancers:
1) Inspect. Before you consider searching for the right freelancer, have a clear vision of what the project is about.
2) Shortlist. Once you've examined each freelancer that is bidding, you can now think about making a short list.
3) Interview.
4) Hire.
Within the service page, you will see a 'Contact Seller' button at right side. We recommend contacting your seller before placing your order, especially if you have specific requirements.
Freelance service is any fixed contract service. Designing, tax filing, software development with no full time commitment comes under freelance service.
Find the best services that help you successfully meet your project planning goals and deadline