Lucas is available for hire

Lucas Miranda Andrade

Verified Expert in Engineering

Architect and Software Developer

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

Toptal member since August 24, 2020

Expertise

Full-stack Web Development Integration Algorithms API Multithreading System Security ServiceNow Visual Studio Development .NET C#SQL JavaScript ERP Development RPA

Bio

Lucas is a developer with several years of experience delivering excellent results to his clients and in the IT field. Throughout his career, Lucas has contributed to developing many projects across various IT technologies and industries, including distribution, manufacturing, biopharmaceuticals and life sciences, international trade, and credit card processing. Lucas loves to code and excels at designing complex systems with cutting-edge technologies.

Portfolio

Woven

ServiceNow, Cloud Architecture, Architecture, IT Support, Operations...

Avanade

Business Process Modeling Notation (BPMN), ServiceNow, Bootstrap...

Butantan Institute

SQL Server Analysis Services (SSAS), SharePoint, ASP.NET MVC, Entity Framework...

Experience

C#.NET - 15 years
JavaScript - 11 years
ASP.NET MVC - 8 years
RESTful Microservices - 4 years
ServiceNow - 4 years
Node.js - 2 years
Vue - 2 years
React - 2 years

Preferred Environment

MacOS, Linux, Windows, Visual Studio Code (VS Code), Visual Studio

The most amazing...

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

Work Experience

ServiceNow Expert

2023 - PRESENT

Woven

Drove ServiceNow platform engineering, achieving company-wide adoption, empowering self-service, enforcing CSDM/CMDB governance, scaling automation, and integrating enterprise systems.
Engineered Service Catalog items leveraging Flow Designer automations to deliver self-service.
Enforced CSDM and CMDB governance aligned with the organizational structure.
Deployed Advanced Work Assignment (AWA) with skill-based routing for ITSM tickets across support groups.
Built custom-scoped applications integrating GitHub repositories and the ServiceNow company app repository.
Created Service Graph Connectors and device discovery patterns with IRE and IntegrationHub ETL to onboard sources like Microsoft Intune, JAMF, Puppet, Tenable.io, Microsoft Defender, and Google MDM.
Orchestrated scheduled enterprise data integrations with Oracle Financials and SAP SuccessFactors.
Supported procurement process development on ServiceNow using the Sourcing and Procurement Operations for the Arene team.
Integrated ServiceNow with Slack messaging system. Streamlined ServiceNow master data integration with downstream systems such as SAP SuccessFactors and Oracle Financial Cloud.
Administered ServiceNow user and group provisioning through Microsoft Entra integration. Deployed ServiceNow authentication using OAuth 2.0, a secure authorization method.

Technologies: ServiceNow, Cloud Architecture, Architecture, IT Support, Operations, Asset Management, Discovery, IT Asset Management (ITAM), ServiceNow Software Asset Management (SAM), IT Operations Management (ITOM), ITIL 4, Communication, ServiceNow App Engine Studio, ServiceNow CSM, ServiceNow Integration Hub, ServiceNow Performance Analytics, Algorithms, Solution Architecture, API Development, API Design, Azure Active Directory

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: Business Process Modeling Notation (BPMN), ServiceNow, Bootstrap, Microsoft SQL Server, OpenID, Azure, Azure Functions, Node.js, JavaScript, Architecture, Cloud Architecture, Full-stack Development, .NET Core, Back-end, APIs, REST APIs, .NET 2, .NET 6, Windows Presentation Foundation (WPF), Integration, Third-party Integration, Microservices, Microsoft Copilot, Python, iOS, Android, SQL, Microsoft Power BI, TypeScript, Front-end, SharePoint, SharePoint Online, Office 365, Microsoft Teams, User Workflows, Cloud, Cloud Storage, Azure Files, DevOps, Microsoft Entra ID, File Sharing, Microsoft, File Management, Storage, Automation, Data Fetching, Data Extraction, CSV, JSON, Data, Blazor, MySQL, .NET MAUI, Moment.js, Windows Server, User Authentication, Python 3, Automation Scripting, Scripting, SharePoint 365, Robotic Process Automation (RPA), Azure SQL, Full-stack, REST, Docker, Next.js, CI/CD Pipelines, Amazon Web Services (AWS), Containerization, Angular, Infrastructure as Code (IaC), Transact-SQL (T-SQL), Communication, ServiceNow App Engine Studio, PostgreSQL, Algorithms, Software Architecture, SQL Server, Solution Architecture, API Development, API Design, Azure Active Directory

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.
Built SharePoint applications with workflows and customized web parts.
Developed automated data extraction, transformation, and load processes with SQL Server Integration Services.
Created 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, Architecture, Back-end, Windows Presentation Foundation (WPF), Integration, Third-party Integration, Microservices, SQL, WordPress, Front-end, SharePoint Online, Office 365, User Workflows, DevOps, Microsoft Entra ID, File Sharing, Microsoft, File Management, Storage, Automation, CSV, JSON, Data, MySQL, Moment.js, Windows Server, Microsoft SQL Server, User Authentication, Scripting, SharePoint 365, Transact-SQL (T-SQL), Communication, PostgreSQL, Algorithms, Software Architecture, Enterprise Resource Planning (ERP), SQL Server, Solution Architecture, API Development, API Design, Azure Active Directory

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é, Architecture, Full-stack Development, Windows Communication Foundation (WCF), Back-end, APIs, REST APIs, .NET 2, Integration, Third-party Integration, SQL, Front-end, Office 365, File Sharing, Microsoft, File Management, Storage, Data Fetching, Data Extraction, CSV, Data, Windows Server, User Authentication, Scripting, Transact-SQL (T-SQL), PostgreSQL, Algorithms, Electronic Data Interchange (EDI), SQL Server, Solution Architecture, API Development, API Design, SOAP, Azure Active Directory

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, functional specifications, and use cases.
Implemented domain entities modeling, Oracle 11g, and SQL Server database structure for persistence and ORM mappings on the 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 an NOC processing solution.
Designed, analyzed, and developed workflows for automation of infrastructure tasks on the Network Automation BPA platform.
Contributed to 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 compliance 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, Full-stack Development, Windows Communication Foundation (WCF), .NET 2, SQL, SharePoint, SharePoint Online, File Sharing, Microsoft, Automation, Data Fetching, Data Extraction, Data, Windows Server, Automation Scripting, Scripting, Algorithms, SQL Server, API Development, API Design, SOAP, Azure Active Directory

Senior Systems Analyst

2008 - 2011

Emphasys IT Services

Worked as a multilayer application system analyst, with experience in HTML Web Standards, Ajax, ASP.NET Web Forms, Entity Framework 1.0, WCF, Enterprise Library 4.1, SQL Server 2000-2008, and Oracle 8-10.
Served the following main clients: Danone, CNI (National Confederation of Industries), Ticket, and Rabobank.
Captured and analyzed requirements, functional specifications, and use cases.
Analyzed use case and UML artifacts (diagram of activities, classes, states, and sequence), budget of analysis activities, and software construction.
Handled multilayer application development in Microsoft ASP.NET, C#, Visual Basic .NET, and T-SQL.
Developed SQL CLR assemblies (.NET libraries for use in SQL Server database).
Built stored procedures in Oracle PL-SQL and SQL Server T-SQL.
Developed reports in Microsoft SQL Server Reporting Services and Crystal Reports.
Created import routines of legacy application databases for new formats.
Analyzed software performance with MS Visual Studio 2008 Performance Profiler, including load testing and stress analysis. Developed strategies by refactoring to optimize ASP.NET resources (session, view, application state).

Technologies: Oracle 10g, Oracle9i, Oracle, Databases, ASP.NET Web Forms, Ajax, Web Standards, HTML, Full-stack Development, Windows Communication Foundation (WCF), .NET 2, Windows Presentation Foundation (WPF), SQL, Microsoft, Windows Server, Algorithms, SQL Server, API Development, API Design, SOAP, Azure Active Directory

Experience

COD | Digital Certification of Origin

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

I worked on designing and implementing the multilayered ASP.NET and SQL databases for this solution.

Education

2017 - 2018

Bachelor's Degree in Computer Science

FIAP | Faculdade de Informática e Administração Paulista - São Paulo, Brazil

Microsoft

Skills

Libraries/APIs

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

Tools

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

Languages

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

Frameworks

ASP.NET Web Forms, ASP.NET MVC, .NET, ASP.NET, .NET 2, .NET 6, Bootstrap, Express.js, OAuth 2, Nuxt.js, Windows PowerShell, Jest, React Native, .NET Core, Redux, Windows Presentation Foundation (WPF), Next.js, Angular, Ext.NET, Telerik Kendo UI, Entity, Blazor, .NET MAUI, Common Service Data Model (CSDM)

Paradigms

Dependency Injection, Web Architecture, REST, Business Process Modeling Notation (BPMN), Scrum, Agile, Azure DevOps, Design Patterns, Load Testing, Serverless Architecture, Microservices, DevOps, Automation, Server-side Programming, Automated Testing, Business Intelligence (BI), Search Engine Optimization (SEO), App Development, Visual Design

Platforms

Microsoft, Windows Server, Azure Functions, SharePoint, Bizagi, Docker, Visual Studio Code (VS Code), Azure PaaS, Azure, SharePoint 365, Amazon Web Services (AWS), ServiceNow Software Asset Management (SAM), Azure Event Hubs, SharePoint 2010, Oracle Database, Oracle, Windows, Linux, MacOS, iOS, Android, WordPress

Storage

Microsoft SQL Server, SQL Server Reporting Services (SSRS), Azure SQL, Azure Active Directory, MongoDB, Caché, SQL Server Integration Services (SSIS), Oracle PL/SQL, MySQL, SQL Performance, Microsoft Entra ID, JSON, PostgreSQL, Databases, Oracle 11g, Oracle9i, Oracle 10g, Azure Cosmos DB, Redis, SQL Server Analysis Services (SSAS), Configuration Management Databases (CMDB), Data Integration

Industry Expertise

Web Design

Other

Object-based Programming, Web Applications, Web Development, ServiceNow, Multithreading, Full-stack, Software Architecture, Architecture, Full-stack Development, ServiceNow Integration Hub, Integration, User Workflows, Data Fetching, Data Extraction, Data, User Authentication, Scripting, CI/CD Pipelines, IT Support, Operations, Asset Management, Communication, Algorithms, SQL Server, Solution Architecture, API Design, SOAP, RESTful Microservices, Data Quality Analysis, UML Diagrams, PCI DSS, OWASP, Performance Analysis, Content Delivery Networks (CDN), Check Point, KNX, Digital Signatures, Reverse Engineering, Enterprise Resource Planning (ERP), APIs, Back-end, Mobile Architecture, Cloud, API Integration, Technical Leadership, Cloud Architecture, ServiceNow Performance Analytics, Third-party Integration, Front-end, SharePoint Online, Office 365, Cloud Storage, Azure Files, File Sharing, File Management, Storage, CSV, Automation Scripting, Robotic Process Automation (RPA), Containerization, Infrastructure as Code (IaC), Discovery, IT Asset Management (ITAM), IT Operations Management (ITOM), ITIL 4, ServiceNow CSM, Software Development, HP UFT, GAMP 5, Multidimensional Expressions (MDX), Hybrid Apps, Mobile Applications, Browsers, App Design, WCF Web Services, Windows Services, Network Automation, Web Standards, Ajax, Team Leadership, Automated UI Testing, Scrum Master, Web Services, Windows Communication Foundation (WCF), SQL Server 2015, Digital Signage, ServiceNow Platform Analytics, Platform Analytics, ServiceNow Application Development, IT Service Management (ITSM), ITSM, Predictive Analytics, Predictive Intelligence, Chatbots, Virtual Work, Natural Language Understanding (NLU), Chatbot Conversation Design, Customer Service Chatbots, UI Builder, Event Management, User Experience (UX), User Interface Visual Design, Service Design, Service Portal, Data Visualization, Incident Management, Natural Language Processing (NLP), Application Management, Artificial Intelligence (AI), CSM Workspace, CI Class Manager, CMDB Design, CMDB Governance, CMDB Health Dashboard, CMDB Ingestion, CMDB Management, CMDB Outcomes, Data Architecture, Data Modeling, Information Integration, Security, Now Platform, Source Control, Configuration Management, Problem Management, Catalogs, Service Delivery, Service Request Management, Service Portfolio Management, Data Analysis, Data Literacy, Decision Analysis, Integration Platforms, Key Performance Indicators (KPIs), Electronic Data Interchange (EDI)

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring