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
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
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
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.
Senior Software Architect
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.
Senior Systems Architect
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.
Senior Systems Architect
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.
Senior Systems Analyst
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.
Senior Systems Analyst
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).
Experience
COD | Digital Certification of Origin
I worked on designing and implementing the multilayered ASP.NET and SQL databases for this solution.
Education
Bachelor's Degree in Computer Science
FIAP | Faculdade de Informática e Administração Paulista - São Paulo, Brazil
Certifications
Micro-Certification - Service Portal
ServiceNow
Micro-Certification - UI Builder
ServiceNow
Suite Certification - ITSM Professional
ServiceNow
Micro-Certification - Virtual Agent
ServiceNow
Micro-Certification - Predictive Intelligence
ServiceNow
Certified Implementation Specialist - IT Service Management (CIS-ITSM)
ServiceNow
Certified Application Developer (CAD)
ServiceNow
Certified Implementation Specialist - Platform Analytics (CIS-PA)
ServiceNow
Certified Implementation Specialist - Data Foundations (CMDB and CSDM) (CIS-DF(CMDB and CSDM))
ServiceNow
Suite Certification - Data Foundations (CMDB and CSDM)
ServiceNow
Micro-Certification - CMDB Health
ServiceNow
Micro-Certification - Configure the CMDB
ServiceNow
Micro-Certification - Integration Hub
ServiceNow
Micro-Certification – Automated Test Framework
ServiceNow
ServiceNow Certified System Administrator
ServiceNow
Micro-Certification - Platform Analytics
ServiceNow
Micro-Certification - Flow Designer
ServiceNow
Micro-Certification - Welcome to ServiceNow
ServiceNow
Full-stack Web Development with React
Coursera
001x: MongoDB Basics
edX | MongoDB University
Exam 483: Programming in C#
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)
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
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring