Fernando Scheinkman, RPA Developer in Buenos Aires, Argentina
Fernando Scheinkman

RPA Developer in Buenos Aires, Argentina

Member since April 1, 2019
Fernando has been an RPA developer for over almost two years, including being part of a development team that developed an Automation Anywhere solution for a major retail company in Argentina. He also develops VBA solutions and can handle himself with .Net. He is a good communicator and has worked in both small and large teams.
Fernando is now available for hire

Portfolio

  • Accenture
    Automation Anywhere, VBA, .Net Developer

Experience

Location

Buenos Aires, Argentina

Availability

Full-time

Preferred Environment

Automation Anywhere, .Net

The most amazing...

...thing I've developed was an algorithm that mimics machine learning capabilities in order to download data from SAP in the most efficient manner.

Employment

  • RPA Developer

    2016 - 2019
    Accenture
    • Developed an automated mailer tool for the HR department using VBA.
    • Developed reusable programming objects and suited them for use in different projects in Automation Anywhere and VBA.
    • Developed major robot for client's sales control department using Automation Anywhere. Managed the set up of the RPA environment, stabilized the process, and added a SQL database into the process that saved 40% of time.
    • Automated business processes for client's accounts payable and master data departments.
    • Developed a whole solution using that allows to input and extract data from SQL server, which I developed, using VBA.
    • Automated a monthly finance report using VBA and SAP, which saved three days and ensured data integrity, which allowed the user to focus on adding new value.
    Technologies: Automation Anywhere, VBA, .Net Developer

Experience

  • Automated SAP Downloader (Other amazing things)

    I developed a code that downloads data from SAP. The client needed information from the past four months, which needed to be extracted from five different transactions. Some transactions were small enough to download the 4 months together, for others, it was necessary to download into 2 months, 1 month, or half a month segments.

    I developed a system that downloaded this information in the most efficient way possible, choosing the combination of periods that would be more efficient. To achieve this, the bot first downloaded the five transactions in each possible way. Then it stores how much time it took in each combination. With this information, it proceeds to execute the code in the most efficient way. Every time the code executes, the robot stores how much time it took to download and then averages it against the information it had previously, and thus determine if it needs to change how it downloads the information.

  • Sales Control Bot (Development)

    I was a part of a major RPA project for an international retail company. The bot performed the cash count for 352 stores, allowing the client to reallocate the 15 employees that were involved with this project. The bot downloads excel files from a web portal, which are created by the stores' tellers. Then it inputs the cash register information contained in these excel file to another web portal. Once completed, it proceeds to execute the cash count in the web portal. If a discrepancy is discovered, it sends an email to the Sales Control team. Because of the volume of the data to process, the bot runs on five devices, four virtual machines and one notebook, using a queue. One of the major challenges in this process was logging each execution of the process. Because the client wanted access to this information, they wanted an Excel file. But because there were five devices trying to use this file, the process was both slow and prone to fail. So I decided to develop a small database, to which the client could access through an excel file, which solved the issue.

    One thing I am proud of is that the bot not only inputs the data into the web portal, but it also controls that the data was correctly inputted, avoiding duplicates.

Skills

  • Languages

    Visual Basic for Applications (VBA), Visual Basic .NET (VB.NET), Excel VBA, C#.NET, SQL, Python
  • Tools

    Excel 2016, Automation Anywhere, Visual Studio .NET
  • Other

    Excel Macros, Office 365
  • Platforms

    Visual Studio 2016
  • Storage

    SQL Server 2017

Education

  • Bachelor's degree in Economics
    2009 - 2019
    Universidad de Buenos Aires - Ciudad de Buenos Aires, Argentina

Certifications

  • Automation Anywhere Certified Advanced RPA Professional
    AUGUST 2018 - PRESENT
    Automation Anywhere
  • IGCSE
    MAY 2005 - PRESENT
    Cambridge University

To view more profiles

Join Toptal
Share it with others