Summary

• Educator, solutions/software architect, and software developer of information systems since 1988, managing software development for government and private sector in Puerto Rico and in Continental US since 1990.
• Mainly worked as a Software Architect engaging with the Client and Project Manager PM designing and documenting the solution, negotiating and managing required feature set, and the overall application structure and database schema while leading and managing the development team. Work closely with the PM to maintain the project documented, on schedule, on the budget and on time. As needed role up my sleeves and code or unit test/validate side - by-side with the team.
• Strong experience in MS-SQL TSQL, Visual Studio, Team System, Native C, Managed .Net and others Microsoft products and technologies. Knowledgeable in ASP.Net MVC 3, 4, Web-API, SPA Single Page Applications, jQuery, Knockout, WCF Communications Foundation, WEB-API, WPF Presentation Foundation, Silverlight and related technologies. Started working in MS-SQL and TSQL since v6.5 in the nineties and in .Net since early /- 2002 Betas. Extensively worked on native and managed automated systems, information/data exchange solutions based on standards/protocols including EDI, and XML based such as GJXDM, LEXS/N-DEx and NIEM initiatives.
• Has been a contractor through all professional practice and compensation has varied based on the amount of contracted period, responsibilities and work conditions. For the past 10 years the rate for professional services has been in the neighborhood 75 USD p/h. On my last assignment I was billing at 100 USD p/h for a relative short period of time less than 160 h/m . Will consider any contract option with compensation in the neighborhood of 75 USD p/h for less than a year contracts that should be negotiable based on employment / contract period, benefits, expenses paid, responsibilities and work conditions.

Work Experience

• CEO and Founder of Open Knowledge DBA openk by 1990. Incorporated as Confidential. DBA as Open Knowledge by 1999 in Puerto Rico. Over the years openk hired professionals of diverse talents to manage the work load and projects engagements.
• Work as Confidential, Team Leader, Project Coordinator, senior consultant on information systems, software designer and developer primarily working with Microsoft Technology including VS, MS-SQL all versions, TSQL, Analysis Services, TFS, WCF, ASP.Net, WPF, Silverlight 3 5, C, VB.Net, C /CLI, C native, and other MS related technologies other tools used include, Stylus Studio, XML Spy, and Crystal Reports.
• . Architect and Developer of the Confidential base class libraries that are used as a starting Framework for openk projects engagements based on Microsoft .Net related Technologies. The framework provides a collection of:
• Reusable helper classes to manage common Application tasks including session management, user privilege handling, error and exception handling, encryption and data protection among other common tasks
• Reusable C classes targeting ADO.Net Db-Common and related provider factories that has been useful to simplify the database access to various data sources including, MS-SQL and Oracle
• Reusable C /CLI classes to manage application driven reporting that supports both Crystal Reports and Reporting Services
• Reusable C classes to manage BLOB's storage and graphical representation if applicable
• C /CLI library of reusable classes that targets commonly used Inter-Process Communication IPC's, TCP/IP, and helper classes to manage working with POP3, SMTP, FTP, HTTP, MSMQ, and other protocols
• C /CLI and C code to support Windows Communication Foundation WCF, POCO Plain Old CLR Object data access, Entity Data Model/Framework EDM/EF, Domain Services, and in C RIA Services
• Reusable Components that include MVVM WPF and Silverlight controls and helper classes to MVVM
• Reusable classes and helpers to manage XPS reporting generation and printing
• Reusable ASP.Net MVC UI controls including user login, lists items selection control among others
• C/C native classes that implements ODBC, OLEDB, and Oracle OCCI database connectivity and many other useful class helpers to manage encryption, text file scanning and parsing, IPC's and other common tasks.
• Openk have used the above libraries in must projects since VS 2003, and earlier versions of VS for the C native code.

Confidential

• Adjourn Professor and Invited Lecturer, taught Object Oriented Software Design and Software Architecture courses as needed.
• Taught computer-related courses at the School of Architecture and Computer Technology applied to Business for MBA students at the Graduate School of Business and Administration. Director of the Computer Laboratory of the School of Architecture for 6 years.
• Participated on the USRA NASA intern program from . Work as summer intern on Houston NASA JCS on 1994 performing some work on the SGI related to 2D GL libraries support on X-Windows.
• SharePoint
• MS-SQL 2010/2012 TSQL and 2014
• TFS 2012.
• Work as project coordinator, team-lead and solutions architect, and senior consultant/developer for the Connecticut Division of CJIS
• Worked with various Project Managers for the various Technical-Team that I lead to schedule, coordinate and execute project plans
• Managed a team of 2 developers to generate the specifications of various data exchanges based on LEXS/N-DEx and NIEM between Criminal Justice Agencies for the State of Connecticut including Incident Arrest, Dispositions and Sentencing, Correctional Status Updates and others
• Manage 2 SharePoint developers targeted to design and implement TeamSites for the Public Defenders Office of the State of Connecticut and various offices of Law Enforcement
• Work on various LOB Line-of-Business applications for the CT-CJIS office

Technologies: Required the use of:

• .Net Framework 2.0 4.0,
• Windows Presentation Foundation WPF and MVVM
• VS 2010 Ultimate
• MS-SQL 2010 TSQL
• COM/DCOM native and .Net Enterprise Services Components
• TFS .
• Also required: the use of Avaya DMCC SDK
• Interaction with the GSA Google Search Appliance .
• Work as project coordinator, solutions architect, and senior consultant/developer for the 311 same as 911 but for everything that is not an emergency Integrated Services Call Center console that provides a single point of contact for all Government Agencies services to citizens to manage information requests and referrals
• Project was developed in a time frame of 2 months
• Created software resources to Manage the Call Center telephony while interacting with the Avaya call modules using DMCC
• Created software resources to allow Call Center Agent to search for citizen information and/or service requests through a GSA Google Search Appliance while managing content using a custom Browser control.

Team Members: Architect, Developers, PM's, QA, Testers, Client Representative

ALM: Subversion and other Open Source tools

My Role: Solutions Architect and Developer

Technologies: Required the use of:

• .Net Framework 2.0 4.0,
• Windows Communication Foundation WCF
• HTML 4,5, CSS, ASP.Net MVC, jQuery, JavaScript
• Windows Presentation Foundation WPF
• Windows Forms
• VS Ultimate
• MS-SQL TSQL
• MS-SQL Analysis Services
• COM/DCOM native and .Net Enterprise Services Components
• TFS
• C, C /CLI, C/C native and other related Microsoft technologies.
• Also require some: mySql, and Sybase schemas definition and development.
• Work as project coordinator, solutions architect, and senior consultant/developer on various projects of the BPPR EBT unit
• Diverse projects developed for Evertec
• Develop Verifone PINpad 1000se SDK to configure and get encrypted customer PIN-block for further host processing
• Develop database and message processing solutions including some EBT Financial transactions
• Architected, designed and developed class libraries to be reused by the Evertec EBT development groups
• Designed and developed various high-demand and mission critical systems Web-Services SOA, SOAP and RESTful based, XML and TCP/IP based bindings
• Created a Native library of classes and DCOM/COM enterprise components to be used as an interface from client managed applications to back-end legacy transaction databases/hosts.

Confidential

Team Members: Architect, Developers, PM's, QA, Testers, Client Representative

Technologies: Required the use of:

• .Net Framework 2.0 4.0,
• Windows Communication Foundation WCF, RESTful services XML and JSON
• HTML 4,5, CSS, ASP.Net MVC, jQuery, JavaScript
• Silverlight v4 5, Domain Services XML and JSON
• Windows Forms
• VS Ultimate
• MS-SQL TSQL
• MS-SQL Analysis Services
• TFS
• VB.Net Visual Basic, C, C/C native and other related Microsoft technologies.
• Also require some:
• Oracle 11g using OCCI and
• XML NIEM v2.x schemas definition and development. For the XML schemas definition VS, Stylus Studio and XML Spy where used.
• During this engagement the following applications and services where developed:
• New CJIS Computerized Criminal History CCH based on NCIC, FBI and others standards
• Sex Offender Registry SOR
• NSOR National SOR data exchanges Web-Services using GJXDM 3.x.x.x
• New Prosecutor Management System PCMS
• IAFIS Fingerprint Interchange System to transfer NIST files to the FBI Triple-I and receive responses. This component was fully developed in VS2005 and ported to 2008/2010 C/C native code
• Domestic Violence Case Management and Monitoring Web Application/Portal to be used by the corresponding office in the Police Department of Puerto Rico PRPD
• Designed and developed the CJIS Xml documents interchange schemas based on Global Justice Xml Data Management GJXDM and NIEM v2.0 standards
• Designed and developed the CJIS CCH data warehouse
• Designed, develop and deploy RESTful web services for information exchange with other local and national agencies and related criminal justice organizations, including the Department of Courts Administration
• Application Lifecycle Management ALM using VS/TFS over the period of .

Confidential

CrossHorizons

• CrossHorizons represent Microsoft on their effort to manage the Data Centers.
• Presented to MAPFRE a .Net and Visual Studio seminar to their Web Developers.

Confidential

• EBT .Net effort in the role of Trainer, Architect and programmer. Help EBT division to create their framework and support their effort to port a desk top application to ASP.Net.
• For the past 3 years, worked with Oracle 8i, 9i software support and development PL-SQL for the ARPE ODS production, Intranet and Internet and other environments. I have helped to prepare PL-SQL and Transact-SQL stored procedures and query resources for reporting in Crystal Reports v7, 8, 8.5 and 9.0
• Provided support in the design and implementation of the BI and Datawarehouse effort at ARPE.
• Also work with SPS Group, Inc. in various projects including Miss. Puerto Rico Universe government contracts for software development such as ARPE and others. We openk are currently working as the SPS Development Group.

Confidential

Co-develop Meditrack targeted for Medical Billing software system. Royal is today the sole distributor of the software. Work with Royal on other projects including the Urban Consumer Income and Expense studio of the Department of Labor and Human Resources of PR for the past year.

Confidential

Web Site Development

Design and development of the JT Group web site. Participate with them on other software development efforts and support.

Confidential

Call Center Message Transfer / Queue / Broadcast

Celpage is implementing a Call Center with the help of Cumulus an external contractor to prepare a full telephony and agent support system. I was contacted to implement the message transfer from client agents to the paging terminal. I implement two COM objects the first to support message spelling in target language Spanish and message queue into a dependent MSMQ client the second COM object support the management and configuration of output ports to the paging terminal GL-3000 using GLCP Glenayre Computer Protocol . To monitor, configure and manage the available serial line ports I implement a share memory IPC mechanism allowing multiple applications monitors to control the message retrieval from the main MSMQ and the transfer of messages to the GL-3000. To support fast message transfer I coded an NT service ATL based to handle a maximum of 64 simultaneous threaded sessions that can be configured to transfer the messages to the GL. Minimal CPU usage was a prime consideration and all port threads are efficiently controlled and synchronized using events. The Call Center will support 300 simultaneous agents each capable of a maximum of 4 messages per minutes. It is required that the message transfer infrastructure support and sustain a load of 1200 messages per minutes on peak hours and an expected month load of 15 million messages.

Confidential .

System Migration for a Digital Equipment Inc. Compact customer.

This client has about six distribution centers around the island and one location in Venezuela. I was contacted to help them prepare the Corporate IT agenda and later move all current IS environment based on Unix, SBT and Dataflex to Microsoft only environment based on Windows NT servers, Visual Basic, Visual C/C and SQL-Server.

Confidential

Singly design and implement an application that support the connection and communication to MS-SNA server on Windows NT that is used to transfer financial transactions between Banco Popular de Puerto Rico BPPR ATM network to a remote client banking institution. This is the one of the first or the first system that successfully implements the transfer of banking transactions fully supported on Windows NT server on the BPPR ATM network. This project was fully developed in Visual C and uses MFC and relies heavily on kernel and system services, name-pipes, map-files and others.

Confidential

Provide the capability to read subscribers records from the paging terminal Glenayre GL-3000 and transfer those to other prefixes on the same database. This application relies on serial-line I/O and manages sensitive real time timing synchronization to minimize the possibility of transfer failure and system crash. The application was developed on Windows NT using Visual C and MFC.

Confidential

At user request, it scans an input file containing account statements and faxes each statement to clients. Targeted as a collection support application it manages and maintains a customer database with needed information to send messages to the customers by fax, e-mail, or pager. The application was developed in Borland C Builder.

Confidential

Given a POS database Btrieve based / Synchronic Counter Point this small application manages the delivery database to prepare and provide distribution services. The application targeted the back end order entry and distribution for the POS application for the preparation of the gift baskets of liqueurs and gourmet foods for one of the largest PR based liqueur distributor, Mendez Company, Inc.

Confidential

Customer support, trouble ticket, POS, Inventory, and resources management system for the service and retail industry. This software provides integrated modules to manage medium Size Corporation. We use it to quickly integrate and ensemble business application that integrate to existing applications used by customers. The software was developed in Borland Delphi, C Builder and MS-Visual C .

Confidential

Design and implement a business support system to manage subscriber database to support paging service reseller operation. Automatically support pagers, numbers, and capcode inventories for a large database of subscribers. Software was developed on Linux and gnu C and fully portable to Windows NT, Visual C or Borland C Builder.

Confidential

For a wireless communication corporation and service oriented industry I specifically design and development an information system that included areas such as customer support, POS, sales support collections, telemarketing, and others serving about 10 island wise stores. I participate on this effort from the preparation of the functional specification document to its deployment. I implement the customer support, contract management, billing and participated on POS, invoicing and cash register related development.

I singly design and developed a full message handling system that included a call center live operator software to gather the alphanumeric message, transfer the message/s via TCP/IP to another component that match it against a subscriber database Informix, Oracle, and prepare it in a particular paging-protocol TNPP, GLCP, and send it to a dump paging-terminal Glenayre 3000 . The message and traffic statistics are then stored on the database for later retrieval and analysis. The system did have a load of about 10,000,000 million messages per month on a real time and continuous basis. The system included a combination of HPUX Unix Hosts and Windows NT servers and was fully developed in C/C .

Confidential

Consultant of CODE-COMM Atlanta based paging company on the MIPS to their customer support system PBX to customer support business applications integration .

Confidential

Help BPPR on its initial Facilities Management efforts. Prepare CAD and inventory databases to support FM environment. The system included the documentation of the inventory procedures and methods to manage about 150 structures, sites and infrastructure around the island.

Confidential

Provide system integration, software development and support services to Top-Hat operation with around 5 stores located on the metropolitan area. Information System uses Informix and AT T Unix to manage business operations.

Experience

Professional practice in the past 17 years included systems architecture, design, analysis, and has worked extensively supporting development/documentation efforts, project planning and implementation. Particularly experienced with the following technologies / development tools / systems:

I/O Serial communications

• TCP/IP and related Internet Networking
• Paging protocols TNPP, TAP, BBL, GLCP
• EDI ASC X12N 10X098A1 Professional, METRO2
• Large volume/Real time production systems
• RDBMS MS-SQL, Informix, Oracle
• Data Access ODBC, OleDb, Db-Lib, .Net Managed Providers
• Business Intelligence MS Analysis Services
• Windows Technologies Win32, System Services, COM/COM, Message Queue
• Web Development SOAP, IIS, Asp.Net
• C/C, C /CLI, C, .Net Visual Basic, Fortran, Object Pascal
• Crystal Reports v 8 v 12
• Delphi, C Builder, MS Visual Studio .Net Team System
• Stylus Studio Enterprise XML Schemas Editor
• Microsoft Expressions Suite Silverlight v1.0 5.0
• Unix HPUX, Solaris, Linux and others Windows XP, Vista, Windows 2003 Server
• Has been working in .Net related Technologies since Beta's circa 2001 and highly knowledgeable in:
• Native:
• C/C, C /CX using VS-11 Beta and RC
• Managed:
• C /CLI, C, VB.Basic
• Experimental: gaining experience in C /CX, CasaBlanca and other Native WinRT related Technologies
• IPC:
• WCF, WCF-RESTful, WCF TCP bindings TCP/IP Native and Managed
• RIA-Services Entity Domain POCO
• Presentation:
• Windows Forms ASP.Net MVC WPF, Silverlight v1-5, MVVM
• Reporting:
• Crystal Reports Reporting Server and hand coded WPF Fixed/Flow Documents XPS reports
• Automation: knowledge of DSL T4
• Schema Design:
• Extensive work done with NIEM v.x IEPD using VS
• Architectural: knowledge of VS 2010 VS 2012 Architectural and ALM Features
• Team:
• TFS including TFS 2012
• Alternatives:
• MONO / XAMIAN

While working with a design and development team I have helped others to organize and manage the work load toward particular goals.