SARAVANAKUMAR GURUSAMY VBA Excel Expert / Power BI / RPA UiPath Developer
No reviews yet

Freelancer/Trainer (RPA UiPath / VBA Excel Macro) Automation

Hello,

I am passionate about adding value to your life, by streamlining the business processes through automation. Giving tailored solution for your systems is my first priority. For me, this means working closely with you to ensure that you receive the user-friendly software at budget-friendly pricing. I enjoy thinking outside the box and finding just the right solution for your business needs.

For over 18+ years, I have been serving as RPA Developer – UI Path / VBA Macro Expert in part time and freelance roles on different platforms. RPA UiPath and VBA based automation is my primary expertise. I’ve successfully delivered automation along with backtesting functionalities.

My Expertise Areas -

• Web Scraping
• PDF download and extract Invoice Details from emails or Web
• Visual Basic (Creation of Macros)
• Advanced MS Excel, Access, Power Point, MS Word, Outlook and Publisher VBA Programming
• Automation of Reports
• Automation of spreadsheet
• CSV Rowdata to Report generation
• Graph, Report & Dashboard Generation
• Pivot table and Pivot Charts
• Lookup functions including Vlookup, Hlookup, Index and Match

I also teach student based on real life scenario and industry based live data experience and requirements.

Happy Automation...!
Hope To Work together,

Subjects

  • VBA & Macro Expert

  • VBA automation Expert

  • RPA UiPath Expert


Experience

  • FREELANCER / TRAINER (Mar, 2015Present) at DHL logistics private limited
    Hello,

    I am passionate about adding value to your life, by streamlining the business processes through automation. Giving tailored solution for your systems is my first priority. For me, this means working closely with you to ensure that you receive the user-friendly automation-friendly pricing. I enjoy thinking outside the box and finding just the right solution for your business needs.

    For over 18+ years, I have been serving as RPA Developer – UI Path / VBA Macro Expert in part time and freelance roles on different platforms. RPA UiPath and VBA based automation is my primary expertise. I’ve successfully delivered automation along with backtesting functionalities.

    My Expertise Areas -

    • Web Scraping
    • PDF download and extract Invoice Details from emails or Web
    • Visual Basic (Creation of Macros)
    • Advanced MS Excel, Access, Power Point, MS Word, Outlook and Publisher VBA Programming
    • Automation of Reports
    • Automation of spreadsheet
    • CSV Rowdata to Report generation
    • Graph, Report & Dashboard Generation
    • Pivot table and Pivot Charts
    • Lookup functions including Vlookup, Hlookup, Index and Match
  • Senior Business Analyst (MIS Executives-VBA Excel Macros developer) (Aug, 2011Feb, 2015) at Evalueserve Tech. Pvt. Ltd.
    • Generate timely and accurate reports for analysis. Creating MIS/ Dashboard report and presenting it to the concern Department.
    • Developing numerous macros using VBA with Excel and MS Office Suites (Excel, PPT, Word, Access, Visio, Outlook and Internet explorer) to solve day to day activities of Business Analyst/Research/Associate/Executives /Manager/Group Manager and Upper management in globally.
    • Developing various Excel tools, dashboards, pivot tables, financial reports, complex formulas, charts, templates and WebCrawler (web based) through VBA Excel Macros code.
    • Responsible for all project lifecycle phases, from specifications, coding, testing, documentation, deployment and maintenance.
    • To retrieve the data from SQL Server and MS Access for analysis (Using ADODB) and preparing final financial report or dashboard in client specific format.
    • Analyzing raw data and provide the metrics and meaningful data to the stockholders and end users.
    • Assisted with automation of finance department’s manual processes by writing VBA code and formulas to speed up the processes and maximize accuracy.
    • Create various daily, weekly, monthly, quarterly and yearly reports.
    • Automation of Internet Explorer (Newsletter, RSS, Web Crawlers, Fetching data from web sites).
    • Analyze, redesign (Re-engineering) and maintenance of existing macros.
  • VBA EXCEL EXPERT (Jun, 2007Jul, 2011) at Syven global services
    • Analyze the information and data faxed/mailed by the bankers who are located across the globally, communicate with them over phone for clarifications and create meaningful and client-ready
    “Business Presentations” using PowerPoint, Excel, Word and Visio in Client specific format
    • Specialized in creating and processing financial spreadsheets, legal documents and business presentations
    • Ensured projects are handled to the highest degree of precision, keeping in mind client specifications and deadlines with high standards of accuracy and quality
    • Managed the process flow of the projects and organizing the job, thus ensuring meeting deadlines and maintaining timeliness along with exceptional quality and Created organization charts, flow diagrams in PowerPoint
    • Worked done for under the high sensitive bankers (San Francisco, Chicago, Boston, New York & Hong Kong)
  • Document Specialist (Jun, 2004May, 2006) at RR Donnelley Global BPO – Chennai
    • Documentation of Company Annual Reports, Semi-Annual Reports, Quarterly Reports, for filing purposes in Security and Exchange Commission (SEC) using MS Word, MS Powerpoint, MS Excel
    • Data Conversion, Documentation, Proof Reading, Edit Incorporation, Quality Checking and Conversion.
    • Documentation of Company Information for Publication and Printing purposes
    • Proofreading documents and Create & Edit Financial Documents, Presentations, Spread sheets, Charts. This involves copy editing, style editing, proofreading as well as comparing documents for uniformity
    • Manipulating existing documents per client templates, creating new styles and formats based on client requirement
    • Job Analyzing, Identify and correct typographical errors, punctuation errors, spelling and formatting inconsistencies

Education

  • VBA MACRO (Jun, 2020Oct, 2020) from CERTIFIED IN VBA AUTOMATION EXPERTscored FIRST CLAS
  • RPA UIPTH (Jun, 2020Oct, 2020) from RPA DEVELOPERscored FIRST CLAS
  • MBA (Jun, 1997Jun, 2003) from MADURAI KAMARAJ UNIVERSITY, Maduraiscored 65

Fee details

    500750/hour (US$5.267.89/hour)


Reviews

No reviews yet. Be the first one to review this tutor.