Outsystems, Sql Server, C#

Robert Feliberty-Tirado

**** ****** **. #**** **** Palm Beach FL 33415

787-***-**** **********@*****.*** www.linkedin.com/in/robertfeliberty01

PROFESSIONAL SUMMARY

An experienced and flexible IT professional, excellent business acumen with ample experience designing and implementing commercial and enterprise solutions, systems integrations and web-based software development using low-code platforms to improve business efficiency. Experienced in different industries like banking, insurance, health, and consulting.

TECHNOLOGY SKILLS

Development Tools: Outsystems Service Studio, Outsystems Integration Studio, Architecture Dashboard (AI Architecture Mentor), Visual Studio, Informatica Power Center, Informatica Power Exchange, SQL Server Management Studio (SSMS), MS Access.

Languages: C#, SQL, HTML, CSS, JavaScript, T-SQL, VB.NET, VB Classic.

Web Technologies: REST, SOAP, XML, HTML5, Cascading Style Sheets (CSS), React, Microsoft Internet Information Server (IIS).

Databases: Microsoft SQL Server, Oracle Database, MS Access.

Operating Systems: SoapUI, Postman, JIRA, Visio, Microsoft Office.

Tools: Outsystems Service Center, Outsystems Integration Studio, Outsystems LifeTime, Team Foundation Server, Postman, SoapUI.

Technologies: Agile Methodologies, Data Warehouse, ITIL, Kanban, Lean Manufacturing, Software Data Life Cycle (SDLC), Total Quality Management, INFOR Smarstream.

WORK EXPERIENCE

Scientific Games, LLC, Alpharetta, GA February 2022 - July 2024

Senior Software Engineer (Roles: Developer, Architect)

·Customer: 4 State Lotteries, including their biggest customer (under Non Disclosure Agreement) Project: Outsystems Lottery Application (NDA). Roles: Software Engineer, Senior Architect, Support.

·Worked for Scientific Games as a part of the team to build lottery applications using Outsystems, C#, JavaScript and CSS; following requirements and guidelines

·Modified the solutions Claims module to align with the customer’s business goals:

oReviewed and optimized existing software architectures, improving performance and scalability.

oLed architectural design decisions for application development.

oDeveloped and maintained architecture standards, including API integration, database design, and application layout.

·Use of Outsystems to create or maintain user interfaces (UI), emails, web blocks, server actions and REST/SOAP web services, entities, reports, print checks.

·Supported and modified Outsystems extensions using C#.

·Created API’s to retrieve data from external servers into the application.

·Created SQL queries to improve application performance and SSIS packages for interfaces. Use of C# in SSIS packages to expedite input parameters validation and assignments.

·Use of Service Studio for administrative, configuration and deployments.

·Use of Integration Studio to create custom code.

·Use of Architecture Dashboard (AI Architecture Mentor) to improve application architecture.

·Carried out unitary tests and validations against requirements, and supported QA tests.

·Attend daily standup meetings and other required meetings to clarify requirements, with a geographically dispersed team.

·Created a customized claims’ application for a new client.

Persistent Systems, Inc, Santa Clara, CA July 2021 - February 2022

Engineer Lead

Customer: Pharmaceutical Company (under Non Disclosure Agreement), 6 months contract. Project: Compliance Reports.

·Developed user interfaces (React, UI), server side actions and API’s, user interfaces, emails, and the user interface.

·Developed and maintained architecture standards, including architectural layout and database design and cloud solutions.

·Use of Service Studio for administrative, configuration and deployments.

·Use of Integration Studio to create custom code.

·Use of Architecture Dashboard (AI Architecture Mentor) to improve application architecture.

·Developed following requirements and guidelines.

·Composed the required documentation for the formal process of deploying the solution to production.

·Attend daily and weekly meetings as needed, with a geographically dispersed team.

·Created many solutions to automate documentation processes in different drug applications.

Consulting to Success, LLC, Guaynabo, PR November 2016 – March 2021

Senior Consultant (Roles: Developer, Architect, Business-System Analyst)

·Customer: Puerto Rico Police Department (PRPD) Project: Outsystems Compliance Applications

oRole: Outsystems Developer and architect to implement the software solutions in various applications for PRPD.

Managed Outsystems environments:

•User security definition and integration to LDAP.

•Application deploys between environments.

•Coordinate virtual private networks (VPN) definition between customer, Outsystems Platform as a Service (PaaS) and Amazon Web Services (AWS).

Designed and implemented scalable software architectures to enhance system performance and maintainability.

Application development, database modeling and definition.

REST/SOAP services integration: Use of XML, WSDL, and JSON formats.

Process prototyping before development to verify development form.

·Customer: Banco Santander Puerto Rico. Project: Customer Service Stations

oRole: System Analyst.

oCreated a new Customer Service Station project: integrated a group of desktop computers to communicate with Genesys telephone switch using REST calls.

Development lead.

Lead technical team accomplish goals as per project milestones.

Led architectural design decisions for application development, ensuring alignment with business goals.

Developed and maintained architecture standards, including API integration, database design.

Convened meetings with vendors and suppliers, and users, geographically dispersed.

Contact vendor to report and work in problem resolution.

Meet with the customer to discuss progress, future activities and feedbacks.

First contact in most cases, hand-on troubleshooting.

Coordinate and execute UAT tests users and final tests with vendors and users.

Supervised team of 2 IT professionals.

Goal achieved: the customer application was delivered on time.

Documentation: different types of manuals (administrator, supervisor, etc.), system architecture diagrams, hardware diagrams.

oSecurities Division Internet Portal migration - expedite a formal request to allow the project to continue. Required to verify user needs, compose the formal request for migration. This project was stuck due to this formal request.

•Customer: Administración de Seguros de Salud de Puerto Rico (ASES) Project: Puerto Rico Medicaid Management Information System (PRMMIS)

oRole: Technical & Business System Analyst at government agency, Puerto Rico Medicaid Management Information Systems (PRMMIS). Achieved the goals of data migration and successful EDI transfers.

oSupervised interfaces and data conversion operations of PRMMIS:

Verify reported errors, coordinate efforts with programmers to correct process.

Maintain effective communication with the diverse parties and levels n the project: users, customers, outsourcer, contractors, validators, project managers, managers, analyst, and technical and non-technical personnel.

•Collaborated with outsourcers, external clients, and internal development teams to identify and resolve technical issues.

•Organized and led problem-solving discussions, resulting in actionable solutions to solve interface and FTP issues.

Troubleshoot of FTP transfers for cause determination.

Preparation of Unit Test cases and execution of Unit Test cases.

Involved in preparing Technical Specification Documents.

Code deployment in Test, UAT and Production environment.

Achieved data migration.

oComposed formal project documents: data flow diagrams, system architecture diagrams, process diagrams, hardware diagrams. Used of Visio for this purpose.

Standard operating procedures.

oSupported and improved daily EDI execution processes.

Supervised 1 person who worked EDI process.

Took corrective actions, including to communicate with the EDI partners.

Worked extra hours and weekends to support interfaces and FTP processes.

·Customer: Consulting to Success Project: C2S LLC Outsystems Practice.

oRole: Outsystems developer and system analysis.

oDeveloped and supported different customers and different projects, following Outsystems’ best practices and Agile methodologies.

Government and private customers.

Data base modeling and creation.

Modify user security at application level after login.

Dashboards.

Unitary test, using various internet browsers.

As part of a geographically dispersed team, it required communication and coordination with remote (offshore - onsite model) developers in different countries.

oCollaborated with stakeholders to translate business requirements into architectural solutions.

oSupported and modified Outsystems extensions using C#.

oComposed requirements document with the business and performance expectations.

oDesigned Outsystems solutions and data base design to satisfy business requirements following Outsystems best practices in design.

oComposed data flows diagrams, system architecture, process and hardware.

oData modeling and prototype data bases for validation.

oSystem and business analysis to evaluate the implementation time and costs, as per customer’s requirements. It required to consider possible user stories, effort required, estimated Implementation time and recommended team size.

oEstimation used for implementation phase.

oPre-sales Support.

Meet with potential customers as technical advisor.

Write the business requirements and expectation.

Translate business requirements into proposed solution: prototype database definition, diagrams required to assess the complete requirements.

·Customer: Regional Supermarket Chain. Project: SAP Hana integration.

oRole: C# Developer

oDesign and implement interface for warehouse transactions between SQL Server to SAP Business One.

oUse of Visual Studio, C#, T-SQL.

·Customer: Consulting to Success Project: SAP Support

oSAP support: User and user groups security and access tasks

Define user groups privileges.

Assign user to groups.

Reorganize the groups access to minimize the number of groups.

·Achievements:

oImplemented the applications following Agile methodologies and Outsystems’ best practices.

oAs System Analyst successfully implemented and delivered many solutions to our customers using my specifications; and many proposals for potential customers.

Interactive Systems Inc., San Juan, PR October 2011 – September 2016

Programmer

·To Develop, maintain and improve client-server and web applications, using VB.NET, SQL Server, SQL Server Reporting Services (SSRS), SQL Server Integration Services SSIS) and IIS.

oSQL Database designing and modeling; TSQL, stored procedures, data base creation and indexing.

Debug, and performance troubleshoots using traces.

Created complete development and testing environments.

oCreated and maintained reports using tools like SQL Server Reporting Services (SSRS) and MS Access.

oUse of VisualBasic for Applications to improve use of MS Access.

oSQL Server Integration Services (SSIS) use for data extractions.

oCreation and maintenance of tables, indexes, queries, complex queries, views, stored procedures, triggers, constraints and cursors.

oIdentified and wrote indexes against query.

oUse of Serena Business Manager, previously known as PVCS Version Manager.

oIntegration with: SQL Server version 2008 and 2012; Oracle 11g and 12c.

•Use of Waterfall SDLC.

•Support of Electronic Timesheet and Telephone Book applications using ASP.NET, Visual Basic .Net, C#. It also required end user support.

•Support to INFOR SmartStream ERP:

oConfigure SmartStream clients and MS Access connection to the databases.

oMaintaining and developing new reports, using SQL Server Reporting Services (SSRS) and MS Access. This included to maintain and troubleshooting the integration between MS Access to SQL Server.

oSmartStream client installation, configuration, and troubleshoot, including updates to tax tables.

oPlan, document and install INFOR Smartstream new version.

·SAP Project: Converted data from SmartStream and other systems to SAP ECC: developed, implemented and supported Informatica Power Center and Informatica Power Exchange to extract, transform and load data (ETL) to a SAP system. Composed formal documentation of Informatica ETL processes.

·Supervised 1 programmer in project to comply with (OFAC) regulations using of Bridger Insight, (LexisNexis).

·Support all users of Accounting and Human Resources departments regarding the use, modification and reports.

•In the Project Manager role, integrated SALUS, a Triple-S subsidiary, to the data infrastructure.

•End user support for the supported applications and products.

•Meet with users and customer for activity planning, testing and solution validation.

·Achievements:

oSuccessful integration of financial data to SAP using Informatica as the ETL tool.

oUpdated INFOR SmartStream (previously GEAC ERP):

Upgrade to version 7.0.3.

New SSRS reports and prompt problem resolution.

Up to date tax tables, stored procedures and MS Access components.

oIntegration of SALUS to comply with the Office of Foreign Assets Control (OFAC) regulations.

LANGUAGES

English – Expert-level writing, reading, and speaking.

Spanish – Expert-level writing, reading, and speaking.

Portuguese - Basic level writing, reading, and speaking.

CERTIFICATIONS

Scrum Fundamentals Certified (SFC)

ScrumStudy, August 2024

Expires: no expiration date.

Outsystems Associate Reactive Developer Certification Version 11

Outsystems, June 2021

Expires: no expiration date.

Outsystems Associate Web Developer Certification Version 9

Outsystems, December 2016

Expired: December 2018

EDUCATION

University of Puerto Rico, Rio Piedras Campus, PR - Juris Doctor (Law)

Bachelor of Science – Major in Mathematics, Minor in Computer Sciences, Cum Laude

Contact this candidate