Lucas Miranda Andrade, Software Developer in São Paulo - State of São Paulo, Brazil
Lucas Miranda Andrade

Software Developer in São Paulo - State of São Paulo, Brazil

Member since July 22, 2020
Lucas is a developer with several years of experience in delivering excellent results to his clients and in the IT field in general. Throughout his career, Lucas has contributed to the development of many projects using a range of various IT technologies and industries such as distribution, manufacturing, biopharmaceuticals & life science, international trade, and credit card processing. Lucas loves to code, and he excels at designing complex systems with cutting-edge technologies.
Lucas is now available for hire

Portfolio

  • Avanade
    BPMN, ServiceNow, Bootstrap, Microsoft SQL Server, OpenID, Azure...
  • Butantan Institute
    SQL Server Analysis Services (SSAS), SharePoint, ASP.NET MVC...
  • Açotubo Group
    Enterprise Resource Planning (ERP), Team Leadership, C#, ASP.NET...

Experience

Location

São Paulo - State of São Paulo, Brazil

Availability

Part-time

Preferred Environment

MacOS, Linux, Windows, Visual Studio Code, Visual Studio

The most amazing...

...thing I've developed was a system for generation of certificates of origin for international trade and a real estate application for a large outsourced BPO.

Employment

  • Senior Software Architect

    2019 - PRESENT
    Avanade
    • Developed applications using Vue.js, Nuxt.js, Node.js, SQL Server, Azure Functions, Azure Active Directory, Microsoft Graph Services, Azure Event Hub, CDN, and Azure API Management.
    • Developed solutions using ServiceNow custom tables, custom forms, UI actions, UI policies, import sets, export sets, business rules, scheduled jobs, REST outbound integration, and MID Server.
    • Designed the software architecture using a cloud solution and principles and microservices patterns, SOLID principles, and serverless paradigm.
    • Configured CI/CD in Azure DevOps pipelines using deployment integration with Azure Cloud components.
    • Analyzed business processes with BPMN and modeling in Bizagi Modeler to capture and communicate to the end-user all the process details considered in the solution.
    • Constructed an application using the mobile-first and adaptative UI concepts in Vue.js and PWA for Android and IOS devices.
    • Implemented Nuxt.js OAuth provider for MSAL and Azure Active Directory for the authentication and authorization, using all the security structure of Azure AD and Microsoft Graph API.
    • Developed ServiceNow ITSM solutions configuring and/or customizing the service catalog, scripted service for catalog shopping cart automation, order guide, service portal, request and request items, tasks, change order, CMDB, and approvals.
    • Built ServiceNow solutions by customizing components, such as custom tables, domain separations, business rules, scripted REST APIs, integrations with outbound REST APIs, Azure Active Directory integrations with SAML and OAuth2, and scheduled jobs.
    • Developed ServiceNow solutions by customizing the custom UI form and list layouts, UI policies and actions, import sets using the MID Server, export sets using the MID Server, events, and email notifications.
    Technologies: BPMN, ServiceNow, Bootstrap, Microsoft SQL Server, OpenID, Azure, Azure Functions, Node.js, JavaScript
  • Senior Systems Architect

    2016 - 2019
    Butantan Institute
    • Specified the software architecture for multilayer web applications using SOLID principles, Microsoft .NET, design patterns, ASP.NET MVC, and Telerik UI.NET.
    • Implemented domain entities on the SQL Server and Oracle Database using a framework for persistence.
    • Implemented a persistence layer using object-relational mapping (ORM) with the Microsoft Entity Framework 6 and Devart Oracle drivers.
    • Developed web applications using ASP.NET MVC C#, HTML5, Bootstrap, jQuery, and Razor.
    • Developed SharePoint applications with workflows and customized web parts.
    • Developed automated data extraction, transformation, and load processes with SQL Server Integration Services.
    • Developed cubes and MDX reports with SQL Server Analysis Services.
    • Analyzed business processes with BPMN and modeling in Bizagi Modeler.
    • Analyzed requirements and constructed functional specifications.
    • Constructed business process automation in the Bizagi Studio BPMS platform for low-code applications.
    Technologies: SQL Server Analysis Services (SSAS), SharePoint, ASP.NET MVC, Entity Framework, C#, .NET
  • Senior Systems Architect

    2013 - 2016
    Açotubo Group
    • Worked as a systems architect, playing a technical leadership role, in a company predominantly distributor of steel products that had a legacy ERP that needed to be extended, maintained, and part of it still needed to be implemented.
    • Participated in the elaboration, construction, and execution in the company plan to acquire and implement a new market ERP.
    • Constructed an RFP for the selection and acquisition of ERP, focusing on the structural analysis of the software in comparison with the existing business structure and the technical robustness of the available solutions.
    • Analyzed the main ERP modules: distribution, manufacturing, engineering (PDM), enterprise, document manager, business analytics, warehouse data collection, report designer, and developer studio.
    • Captured and analyzed the requirements and functional specification and use cases and served as the scrum master for the scrum development team.
    • Defined the architecture along with analyzing and developing the multilayer software for building web applications with various technologies (Microsoft .NET, ASP.NET MVC, Razor, C #) with the Ext.Net UI components (Ext JS).
    • Handled the functional and structural analysis of ERP IFS Applications 8 modules.
    • Implemented the functional specification for customizing ERP IFS application modules.
    • Held an ERP IFS application fundamentals workshop for the management staff.
    • Researched and tested the Micro Focus automated test platform for applications in ERP IFS applications.
    Technologies: Enterprise Resource Planning (ERP), Team Leadership, C#, ASP.NET, Automated UI Testing, Scrum Master, Scrum, Web Services, Caché
  • Senior Systems Analyst

    2011 - 2013
    Fast Solutions
    • Analyzed, developed, and supported solutions for the credit card management business for the Visa and Mastercard credit platforms.
    • Captured and analyzed requirements and functional specifications and use cases.
    • Implemented domain entities modeling, Oracle 11g, and SQL Server database structure for persistence and ORM mappings on Microsoft Entity Framework 4 platform and Oracle DevArt Oracle connector (database first).
    • Analyzed and developed Microsoft .NET WCF 3.5 web services, ASP.NET Web Forms 4/4.5 applications, batch console applications, and Windows Background Services in C # Microsoft .NET 4/4.5.
    • Analyzed and developed SharePoint 2010 applications with customized lists, workflows, and reports with reporting services, Caml Queries, and InfoPath Forms for SharePoint 2010 for a NOC processing solution.
    • Designed, analyzed, and developed workflows for automation of infrastructure tasks on the Network Automation BPA platform.
    • Worked on stored procedures tuning analysis, SQL queries, and Oracle database indexing.
    • Analyzed and developed a security segregation layer for access to tables protected by PCI DSS compliances by satellite systems in Oracle databases.
    Technologies: Oracle Database, Network Automation, SharePoint 2010, Caml, Windows Services, C#.NET, ASP.NET Web Forms, WCF Web Services, .NET, Entity, Microsoft SQL Server, Oracle 11g
  • Senior Systems Analyst

    2008 - 2011
    Emphasys IT Services
    • Worked as a systems analyst for multilayer applications that involved various technologies.
    Technologies: Windows Communication Framework (WCF), Oracle 10g, Oracle9i, Oracle 8, Databases, ASP.NET Web Forms, Ajax, Web Standards, HTML

Experience

  • COD | Digital Certification of Origin
    https://www.cod.cni.org.br/

    This is an application for all the Brazilian industrial associations to aid the local manufacturers to create all the documentation of certificate of origin and productive process statement for international trade in conformance with the multinational trade agreements.

    I worked on the design and implementation of the multilayered asp.net and SQL database for this solution.

Skills

  • Languages

    C#.NET, JavaScript, XML, T-SQL, C#, SQL, TypeScript 3, C++, Visual Basic .NET (VB.NET), HTML5, CSS, TypeScript, Java 8, PHP, Caml, HTML
  • Frameworks

    ASP.NET Web Forms, ASP.NET MVC, ASP.NET, Bootstrap, Express.js, OAuth 2, Nuxt.js, Windows Communication Framework (WCF), Windows PowerShell, Jest, Redux, Ext.NET, Telerik Kendo UI, React Native, Entity, .NET, .NET Core
  • Libraries/APIs

    Entity Framework, Azure API Management, React, Node.js, Vue, jQuery, ServiceNow REST API, Azure Active Directory Graph API, Fluent API, InversifyJS, Passport.js, LINQ, Formik, OpenID
  • Tools

    Visual Studio, SonarQube, Git, Subversion (SVN), CVS, Crystal Reports, ANTS Profiler, Microsoft InfoPath, NPM, MongoDB Shell, Mongoose, Expo, RabbitMQ, HP Quality Center (QC), HP QuickTest Professional (QTP), Hyper-V, Microsoft Power BI
  • Paradigms

    Dependency Injection, Web Architecture, REST, BPMN, Scrum, Agile, Azure DevOps, Design Patterns, Load Testing, Serverless Architecture, Server-side Programming
  • Storage

    SQL Server Reporting Services (SSRS), MongoDB, Caché, Microsoft SQL Server, SQL Server Integration Services (SSIS), Oracle PL/SQL, MySQL, SQL Performance, Databases, Oracle 11g, Oracle9i, Oracle 10g, Azure Cosmos DB, Redis, SQL Server Analysis Services (SSAS)
  • Other

    Object-based Programming, Web Applications, Web Development, Multithreading, Full-stack, Software Architecture, RESTful Microservices, ServiceNow, Data Quality Analysis, UML Diagrams, PCI DSS, OWASP, Performance Analysis, Content Delivery Networks (CDN), Check Point, KNX, Digital Signatures, Reverse Engineering, APIs, Back-end, Mobile Architecture, Cloud, API Integration, Architecture, Technical Leadership, Software Development, HP UFT, GAMP 5, Multidimensional Expressions (MDX), Hybrid Apps, Mobile Applications, Web Client, App Design, WCF Web Services, Windows Services, Network Automation, Enterprise Resource Planning (ERP), Web Standards, Ajax, Oracle 8, Team Leadership, Automated UI Testing, Scrum Master, Web Services
  • Platforms

    Azure Functions, SharePoint, Bizagi, Docker, Visual Studio Code, Azure PaaS, Azure, Azure Event Hubs, SharePoint 2010, Oracle Database, Windows, Linux, MacOS

Education

  • Bachelor's Degree in Computer Science
    2017 - 2018
    FIAP | Faculdade de Informática e Administração Paulista - São Paulo, Brazil

Certifications

  • Full-stack Web Development with React
    MAY 2020 - PRESENT
    Coursera
  • 001x: MongoDB Basics
    MARCH 2020 - PRESENT
    edX | MongoDB University
  • Exam 483: Programming in C#
    AUGUST 2019 - PRESENT
    Microsoft

To view more profiles

Join Toptal
Share it with others