* SSRS Reporting tools design and implementation from scratch (Database and report design and implementation)*.Custom c#.net tools using .net entity framework 6.0* Cognos to SQL Reporting Services reports migration.* Created multiple dashboards using PowerBI

Code analysis, code changes design and implementation.

Managed and developed Business reports ● Requirements gathering● Reports Analysis and development in Cognos● ETL using custom programming in C# and ADO.NET● Reports Automation● Dashboards creation in TableauRevamped Business Intelligence reports library and migrated them from Sharepoint to CognosHelped Providers Call Center slash their call time by creating a benefit package search tool in order for them to be able to see all-important member benefit package in one screen.

Based in interviews with CRIM domain experts assessed, analyzed, designed and implemented major changes to SATAS (Sistema Automatizado de Tasaciones con Apoyo Satelital) architecture, interfaces and codebase. Refactoring to get rid of deprecated components (sync framework 1.0) and replacing them with WCF web services. Streamlined process by making a new windows mobile application using .net framework 3.5, GPS.net library, sql server compact to be the gps coordinates entry point and photos and documentation gateway.

As a consultant at CRIM managed all technical aspects from design to implementation of enhancements and changes to their Appraisal management software SATAS (Sistema Automatizado de Tasaciones con Apoyo Satelital).SATAS integrates a web based frontend in ASP.net using JQuery and a Microsoft Sync framework –Windows Communication Foundation service that synchronizes with appraiser PDA’s so they can electronically submit their appraisals, streamlining their appraisal process. As a consultant at Puerto Rico Aqueduct and Sewer Authority, I leaded all efforts to enhance their capital improvement management program. In their .net 2.0 smart client, using ORM software, Created functionality to allow seamless integration with their contract management and federal funds modules. Also revamped all reports used by Board of Directors to analyze and take decisions about their Capital Investment Program.

Eased overall EVDO system maintenance by creating an EVDO performance monitoring system that.1. Extracted RNC and Sector Counter data directly from Cell Sites using TCL/Expect and bash programming. 2. Calculated and stored several Key Performance Indexes (KPI’s). Based on customizable threshold settings, raised alarms for offending RNC or Sector. System was built with perl, and mysql on its backend and perl, html, php and jquery on its front end. Automated and leveraged processes to other departments by creating web interfaces and web applications that allows end users perform tasks on many Open Mobile network components.Leverage revenue assurance tasks by determining bottlenecks and pitfalls in billing process, then designing and implementing solutions for them using ASP.net, ADO.net and either VB.net or c#.Played an important role in service plans creation by creating their supporting commercial plans on commercial platform, and billing infrastructure needed to support marketing offers.

Clinnext 2.0: Medical forms creation, configuration and maintenance via SQL2000 database queries. Developed and implemented UI behavior changes and bugfixes in javascript and in C# code as well. Created and modified SQL stored procedures for data retrieval. XML data manipulation and transformation using XSL. Created application installers using WIX. Gathered and implemented specific workflow changes with a customer in US mainland, being the liaison between programmers and client. Clinnext 3.0: Participated in a team that developed a smart client using .NET Framework 2.0, C# 2005 and SQL server 2005. Created Windows custom controls for medical forms and smart parts printing templates. Debugged, developed and implemented bugfixes to application code.

Validation of a Health Information Management System against functional specifications. Tests included querying SQL Server 2000 and / or create XML data to check data integrity across entire application flow, debug javascript and C# code using Visual studio 2003 / 2005. Document bugs thoroughly including their replication sequences, expected results, and actual results. After test cycle, implement proposed bug fixes and certify application status.

Redesigned their portal using Mambo Content Management System (PHP and MySQL) and custom-programmed it to their specific needs. Integrated Mambo with Horde webmail client, to provide webmail access, agenda, and contacts to each email address. Webhosting Project: Implemented and maintained 2 webhosting servers using Fedora Core 3 and cPanel as a webhosting management application to provide Webhosting and e-mail solutions to clients. Éxito Comercial Project: Worked on customization and implementation of a Pay Per Click (Jomo PPC) search engine with PHP 4, MySQL 3 as backend and Smarty PHP Templating Engine to incorporate an affiliate program not included in the PPC search engine original version. Participated actively in business planning sessions to fine tune the project and to integrate the search engine to the entire plan.