Banner Image

Skills

  • Data Analysis
  • VBA
  • Advanced Excel
  • Analytics
  • Dashboard Design
  • Data Management
  • iMacros Scripting
  • Macro
  • Microsoft Excel
  • Reports
  • VBA Macros
  • Writing

Services

  • Data Analytics specialist

    $8/hr Starting at $30 Ongoing

    Dedicated Resource

    I have hands on experience working on different reports and dashboards on Excel. Can write VBA macros as well. Have developed many VBA based tools to get the work automatically done.

    Advanced ExcelAnalyticsDashboard DesignData AnalysisData Management

About

A yardstick of quality where excellence is expected

Expert knowledge of (Excel & Advance Excel) and experience in reports creation using MS Office (MS Excel, MS PowerPoint and MS Word). Knowledge of advance excel functions (not limited to VLOOKUP, Sumifs, Countifs, Index, Match etc.)
Understanding of the data & reports MIS reporting by using MS Excel & VBA (Macro) at Operational and Client level.
Generate timely and accurate reports for analysis. Creating MIS/ Dashboard report and presenting it to the concerned Teams.
Built out novel reports and migrated rebuilt legacy reports into new centralized reporting to meet reporting needs company-wide.
Design/develop the agreed upon solution using VBA coding in MS Excel.
Deliver end products, maintaining quick turnaround times and highest quality standards so as to execute quick turnaround work in MS Excel which involves VBA coding.
Consistently self-managed and independently motivated ahead of expectations in providing new data solutions to company.
Guided and mentored junior staff and provided expertise to concerned teams.
Managing the Monthly, Weekly & Daily Report creating in MS-Excel through in depth analysis and producing the actionable information.
Generating & maintaining day to day MIS Data and updating the management.
Extensive usage of formulae’s (Sumifs, Countifs, Averageifs, Sum-product, Index-Match, Vlookup/Hlookup, Match, Choose, datedif, Left/Right/Mid, IFerror/ISerror/ISna, text to column, IF, NestedFunctions, MAX, MIN, LARGE, Dynamic Pivot table/Calculated Fields, Data validation, Conditional formatting, Advanced filter etc.

Work Terms

I can work 8 hours on weekends and 2 hours daily on weekdays.