Internal work / test projects
This is internal work done for the sole purpose of enhancing current programming related skills.
Screen shots or actual running pages can be seen in my website.
http://184.108.40.206:1000/cidreno [alternate: http://www.cidreno.com:1000/cidreno]
(Cidreno) PROJECT: Mvc Inventory app
Description: Used to control inventory (add/edit/delete), enter inventory tests done.
Sql Server tables with primary and foreign key relations brought into C#.Net by Entity Framework database first.
Several views added to both add/edit/delete from the inventory and to add foreign key entities.
Use of bootstrap, foreign key values used in dropdowns.
Validation done in view and in constructor actions (form validation).
Use of session variable to control sign on validation (uuid/pw).
Cidreno) PROJECT: WPF
Description: WPF windows application to display Virginial park pictures
Tech used: WPF
This application shows pictures from different VA parks.
Screen shot of how the WPF page came out is on my web site.
Cidreno) PROJECT: Tabular Report Comparison
Description: Different technologies used to make an interactive table report.
Angular 1.6, MVC (Razor), Entity Framework, Sql Server 2015, Web Forms (GridView), Linq, jQuery, Ajax
Purpose will be to show the use of the different technologies, not what is easier to implement or more server efficient.
Report shown using - Mvc razor, Angular 1.6, webform gridview.
I will release this in steps (will be seen in my website), Angular will be the first.
Data in sql server, usage of Entity Framework Database first.
Feature implemented will be what is basically available with the technology without doing too much effort (filtering, ordering, update) - update buttons might be shown but will not bother with implementing them.
CSS - will try to make each representation look similar.
Cidreno) PROJECT: Wep.Api
Description: Web.Api picture streaming service
MVC (Attribute routing), Razor, Sql Server 2015, C#.Net, Web.Api (picture stream and Json list), CSS
This C#.Net service gets the image list and the images from Sql Server and respond to the client with a Json list and a stream image.
C#.Net web forms, controls, and classes using Visual Studio 2013(C#).
(Cidreno) PROJECT: MVC (with Sql Server update)
Description: Website to track rechargeable batteries and any tests done.
C#.Net, Mvc, CSS + bootstrap, razor (with sign in security and update capability, model value check), Linq, Entity Framework db first.
Multiview website that has the following views.
battery size (coda,).
Test done on current AH capacity.
Sites takes advantage of Html helpers for dropdown, displaying data from the view and for displaying
Data inconsistency messages.
Before doing update, model check is done.
Session variable is used to keep track if the user is authorized (check done against sql user table).
Cidreno) PROJECT: Wcf
Description: Wcf picture streaming service
C#.Net, WCF (state and stateless, stream picture and enumerable string), Mvc, CSS, razor, partial view
This C#.Net service uses non-restful to supply the image list and restful to supply a streamed image.
Images gotten from file directory.
Cidreno) PROJECT: SSRS Report
Description: SSRS report using mapping file
Tech used: VB.Net, Sql Server 2012, ssrs
In this report I downloaded a country mapping file and then uploaded to sql server, statistics related per country.
The report will then be a color coding of the countries based on the business rules in the report and the information in sql server.
Cidreno) PROJECT: Webform
Description: Webform project used to implement interactive sudoku game
In this case I constructed a sudoku game.
All logic is in the code behind.
Cidreno) PROJECT: VSTO
Description: VSTO (word add-in)
VB.Net vsto, creation of ribbon, icon creation (for the ribbon)
In this word add-in, you can select a table in word and be able to minimize it (keeping only the first row ).
VSTO (this is the new way to create add-ins through visual studio).
Creation of icons, ribbon, and tying the icons to certain actions.
Simulated rotating solar system.
Cidreno) PROJECT: Windows 2012 r2 installation and usage (dns, dhcp, IIS)
Description: Demonstration of ssrs and now as the main host of my test website.
Cidreno) PROJECT: SSIS and Sql Server 2015 Installation
Description: Installation and test of SSIS.
03/2017 to 03/2017
SubWorld Bank － Arlington, VA
World Bank) PROJECT: Excel dashboard
Description: Use of Excel to present data for decision making.
Excel (pivot charts/tables, slicers) and temporary vba (for data cleanup).
Collect and present woman (education, weight, height, marriage, children, nutrition) data for decision making.
Excel was used to present a dashboard - use of pivots and pivot charts was used, data from various sources was manually put into the report.
excel (vba, excel, pivot, slicers, charts)).
06/2008 to 09/2016
ContractorInter-American Dev. Bank － Washington, DC
IADB is a multi-country bank- like the World Bank but smaller.
It provides loans to countries for projects that are to enhance the lives of its citizens.
Writeup of proposal, development, db design Aided the budget division service their clients (all the departments in the company), in activities related to helping control the budget and in collection of data for board presentation.
This entailed getting development requests, doing meetings with stakeholder or with the budget tech group for requirement specifications, presenting possible design with timeline.
If all is approved then designing sql db, start the design process and meeting with stake holders or group leader for the formalization of the design that goes on in agile until the final milestone is reached.
When all development is done, a test scenario and test ticket is made for business specialists.
Once testing is completed, the current application is backed up and the new(enhanced) application is then published from SourceSafe.
The project ticket is then closed.
Then comes the task of daily monitoring of application and data for any kind of aberrant behavior.
06/1997 to 06/2008
Consulting EngineerDexter Systems － Manhattan, NY
Winforms program to reading of data form data warehouse and updating Sql Server.
Collection of data from users for their expected expenditure by activity.
This would be used for calculation (distribution of benefits by activity based on the ratio of the pc amounts supplied), and for upload into Essbase.
Dexter supplied their services to Verizon.
Working of Verizon buildings, Dexter used a multitude of servers and personnel to aid Verizon with its data.
Writeup of proposal, development, db design, publish and daily admin.
(DEXTER) PROJECT: MANY WATERFALL PROJECTS
vb3456, classic asp, sql (sql server), excel(vba)
Discussion with the customer; breaking down the business process that is to be emulated; deciphering and constructing what the final report from application should be.
Writing the programming code.
Designing the database schema and creating the necessary tables, stored procedures, jobs, views.
Getting access to Verizon's legacy systems for Dexter, Ftp, web and/or sfttp
(DEXTER) PROJECT: MANY AGILE PROJECTS
vb3456, VB.Net, transact sql, sql (sql server), excel(vba) and other external programs like Attachmate for interacting with Verizon's legacy systems.
Winforms and webform applications (.Net).
IADB) PROJECT: METRIC INFORMATION COLLECTION (CPC)
Description: Website that would get and display metrics for the company.
VB.Net 2008 (windows / webforms, tree, gridview, master page, language files, timer, windows authentication), Sql Server 2008, oracle (read), windows scheduler, IIS, CSS, session variables
This is multi-webpage website that gets metric information for the company.
Users input Oracle queries for what they want to measure.
These queries would be run against the Oracle data warehouse and the daily results would be stored in Sql Server and shown in the web site.
VB.Net - Web forms, Menu control, User control, server-side session variable, View grids/template fields, Rdlc report control, Sql server/oracle, Style sheets, Region files (for displaying labels in different languages), Master page, CSS
The website made use of a master page to keep both the top and left side of the page consistent (the same).
The body of the master page would then be determined by the menu item that the user chose.
The main page made use of the gridview control to show a report of the collected information.
The other pages were for input of queries, thresholds, and other information needed for the system to either function.
IADB) PROJECT: PERSONAL COST PROJECTION (SALE)
Personal Cost projection
Sale was designed for the departments to be able to project their personal spending for the year.
This is the expense related to the salary and benefit of their employees.
In sale over 25 interactive excel workbooks were given to the departments (one per department).
Managers would use the book to do their personal cost projection for the year and to see if they are still within their budget.
Interactive in that it had dropdown for the different actions.
Most of the actions initiated an excel form to come up, which the user would then use to put new projection information.
Once the form is updated/submitted, the projection worksheet would then be updated.
The user can then go to the report worksheet and see how their current projections compare with their current budget.
BS: MathematicsCentral Connecticut State UniversityMathematics Degree Pursued (2) Secondary Education Teaching
Date Degree gotten
or number of full time school years
MS: TelecommunicationPace University － Manhattan, NYGPA: 3.173.17 Strong emphasis on math and science
Location New Britain Telecommunication or number of full time school years Degree not finished
CT Secondary Teachers Certification
Tax Preparation 1993-1997
Aerospace Quality Control
SENIOR PROGRAMMER | .Net Developer Proven track record of 19 years programming with Microsoft Stack (VB.Net, C#.Net, sql server, SourceSafe(Serena/TFS), excel, word, MS Access, ..
*Developer lead; Small internal Web/Windows Projects. Talk to stakeholders, system design/ architecture, presentation, and continuous discussions during agile development. Monitoring and administration of finished product.
*Development of Web (C#.Net, VB.Net, Html), Windows (VB.Net, C#.Net, VB6, vba), Excel, MS Access applications and creation of Script(VBS/Bat), and word add-ins (vba and vsto).
*Experience in full Software Development Life Cycle.
*Use of SourceSafe (Serena, TFS) for version control.
*MVC projects (Entity Framework (Database First), Razor, attribute routing).
*Web.Api/WCF projects (both streaming and ienumerable information were serviced)
*Sql Server - versions 1997 to 2015. Design, maintain. Use of stored procedures, all functions, views, indexing, permissions, database movement, table constraints.
*Oracle - Extensive querying of Oracle Data Warehouse.
*Interaction with both IIS (virtual and non-virtual applications, app-pools) and windows server 2012r2.
*Flexible in the needs of the customer (versatility with various technologies Vba, Cognos, MS Access, Vsto, SSIS, SSRS, ...)
*Asp.Net (14 years)
*Net Framework (ver 1.1 - 4.
Available for Relocation
Open to relocate
1 | Page
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
Companies Worked For:
Inter-American Dev. Bank
Central Connecticut State University
Job Titles Held:
BS : Mathematics MS : Telecommunication CT Secondary Teachers Certification Tax Preparation 1993-1997
Aerospace Quality Control
Create a job alert for [job role title] at [location].