Experience

NTC - A Covius Solution

• United States
• Financial Services
• 100 - 200 Employee

• Web Developer

  • Jan 2021 - Present



Toho Water Authority

• United States
• Utilities
• 100 - 200 Employee

• Program Analyst

  • Dec 2019 - Jan 2021

  Water Provider Company Applications • Developing multiple web pages, using C#.NET framework with MVC. • Creating and implementing databases and tables in MSQL with the integration of multiple applications. • Constructing stored procedures, views, and triggers in conjunction of complex queries, to manage big data. • Maintaining, upgrading, and enhancing third-party applications: Infor EAM, Hach Wims, CIS Infinity. • Building big data reports with SSRS, Crystal Reports, PowerBI and Excel.



Novalian Solutions

• Remote

• Business Intelligence Developer

  • Oct 2017 - Nov 2019

  Software Technology Solution Provider Generated Monthly, Quarterly, Bi-Yearly, Yearly numerous type of reports using SSRS. • Extracted data from internal data warehouse system to SSRS. • Tracked end users ticket request for troubleshooting and fixing multiple software bugs. • Generated stored procedures, user defined functions, views T-SQL scripting for complex business logic, using aggregate strategies to aggregate data, sorting, and joining tables. Use CTE tables for optimization purposes. • Analyzed and optimized data models, data relationships, and dependencies. • Performed functional and performance QA testing. • Designed multiple dashboards applying Power BI to display information required by different departments and upper level management. • Developed unit tests for API projects, using MS Test project (ASP.Net Core (2.2)). • Created unit tests using different approaches as Moq, and InMemory databases. • Established the integration tests for API projects creating environments with variables, and preset headers; using applications best practices.



MMM Holdings LLC

• Puerto Rico
• Insurance
• 700 & Above Employee

• Software Developer 2

  • Jun 2016 - Oct 2017

  EOB Project • Develop project using Microsoft SSIS(Integration Services) and IBM tools WORKLOAD and DATASTAGE, that manage and transform data from Delegate Entities, to export it to the database of MMM. • Develop a report in SSRS(Reporting Services) to manage the exceptions of the EOB Project. EOB Project • Develop project using Microsoft SSIS(Integration Services) and IBM tools WORKLOAD and DATASTAGE, that manage and transform data from Delegate Entities, to export it to the database of MMM. • Develop a report in SSRS(Reporting Services) to manage the exceptions of the EOB Project.



Assertus

• Guaynabo

• Software Developer 2

  • Mar 2015 - Jun 2016

  • Work with HL7 to integrate the software of the company with Electronic Medical Records. • Creates a Windows Service application in C#.net to send and receive HL7 files, using TcpClient. • Creates an application in C#.net with SQL Server 2012 to handle applications running different processes: (Integration Services, Visual Basic.net) and turn them into one. • Works on MVC project(back-end and front-end), with the login page and the services(IIS). • Work with HL7 to integrate the software of the company with Electronic Medical Records. • Creates a Windows Service application in C#.net to send and receive HL7 files, using TcpClient. • Creates an application in C#.net with SQL Server 2012 to handle applications running different processes: (Integration Services, Visual Basic.net) and turn them into one. • Works on MVC project(back-end and front-end), with the login page and the services(IIS).



Sabiamed

• Software Developer

  • Aug 2011 - Mar 2015

  Programmer Provided enhancements and new features in the following Health Care systems: Clinnet (Visual Basic 6) • Created over 30 solutions in C#.NET to administer (add, edit, delete) MSSQL tables through simples User Interfaces (UIs). • Worked in a team-work environment providing solutions to problems found in the application. • Built and enhanced reports made in Crystal Reports. Clinnext (C#.NET) • Integrated different devices used for digital signing forms. • Built and improved reports made in HTML and CSS. • Fixed and extended custom controls for the UI. • Fixed infrastructure issues. • Improved the overall process in how digital reports are displayed. Clinnet.net (C#.NET) • Worked in an integrated team to migrate an application from Visual Basic 6 to C#.NET. • Provided solutions to common issues found during the migration. Radiology (C#.NET) • Added new features and fixed issues to the application. • Worked in Web Services with ASP.NET and IIS. • Built and customized MSSQL Stored Procedures. Web Doctor (HTML, CSS, JavaScript) • Fixed and improved the overall appearance and functionality of the application. Audit Log (C#.NET) • Worked with MSSQL integrating and enhancing Triggers and Stored Procedures. • Added new features and fixed issues to the application.