Internal work / test projects
Duties
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://68.100.47.11:1000/cidreno [alternate: http://www.cidreno.com:1000/cidreno]
Accomplishments
(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
Overview:.
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.
Tech used:
Angular 1.6, MVC (Razor), Entity Framework, Sql Server 2015, Web Forms (GridView), Linq, jQuery, Ajax
Overview:.
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
Tech used:
MVC (Attribute routing), Razor, Sql Server 2015, C#.Net, Web.Api (picture stream and Json list), CSS
Overview:.
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#).
The client will then use JavaScript, Ajax, jQuery, Mvc, Entity Framework, Razor, web-grid for the selection of the image list and for the Ajax rendering of the selected images to the page.
C#.Net)
(Cidreno) PROJECT: MVC (with Sql Server update)
Description: Website to track rechargeable batteries and any tests done.
Tech used:
C#.Net, Mvc, CSS + bootstrap, razor (with sign in security and update capability, model value check), Linq, Entity Framework db first.
Overview:
Multiview website that has the following views.
batteries (inventory).
brands (energizer,).
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
Tech used:
C#.Net, WCF (state and stateless, stream picture and enumerable string), Mvc, CSS, razor, partial view
Overview:
This C#.Net service uses non-restful to supply the image list and restful to supply a streamed image.
Images gotten from file directory.
The client will then use JavaScript, Ajax, jQuery, Entity, Linq, Mvc, razor, views, partial view to display a vertical check box list and display one selected picture as the background for the page.
Cidreno) PROJECT: SSRS Report
Description: SSRS report using mapping file
Tech used: VB.Net, Sql Server 2012, ssrs
Overview:
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
Tech used:
C#.Net, webforms (heavy usage of events to direct actions to be performed in code behind), CSS, JavaScript.
Overview:
In this case I constructed a sudoku game.
All logic is in the code behind.
Cidreno) PROJECT: VSTO
Description: VSTO (word add-in)
Tech used:
VB.Net vsto, creation of ribbon, icon creation (for the ribbon)
Overview:
In this word add-in, you can select a table in word and be able to minimize it (keeping only the first row <as the header>).
VSTO (this is the new way to create add-ins through visual studio).
Creation of icons, ribbon, and tying the icons to certain actions.
VB.Net) Html5 canvas, JavaScript
Overview:
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.
Sub, 03/2017 to 03/2017 Carestream – Rochester, NY,
World Bank) PROJECT: Excel dashboard
Description: Use of Excel to present data for decision making.
Tech used:
Excel (pivot charts/tables, slicers) and temporary vba (for data cleanup).
Overview:
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)).
Contractor, 06/XXX8 to 09/2016 Alchemy Systems – Essington, ,
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.
Duties
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.
Consulting Engineer, 06/1997 to 06/XXX8 Dexter Systems – City, STATE,
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.
Duties
Writeup of proposal, development, db design, publish and daily admin.
Accomplishments
(DEXTER) PROJECT: MANY WATERFALL PROJECTS
Languages:
vb3456, classic asp, sql (sql server), excel(vba)
Details:
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
Languages:
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).
Accomplishments
IADB) PROJECT: METRIC INFORMATION COLLECTION (CPC)
Description: Website that would get and display metrics for the company.
Methodology: Agile
Tech used:
VB.Net XXX8 (windows / webforms, tree, gridview, master page, language files, timer, windows authentication), Sql Server XXX8, oracle (read), windows scheduler, IIS, CSS, session variables
Overview:
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.
Details:
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
Methodology: Agile
Tech used:
VB.Net (winforms, webforms, user controls, gridview, timer), Excel (front/back(vba)), JavaScript, Sql Server XXX8, oracle (read calls), windows scheduler, CSS, JavaScript, Dot Net Nuke (for user links to the books), windows authentication, directory permissions (for the Excel books).
Overview:
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.
Education
BS: Mathematics, Expected in 06/1996 to Central Connecticut State University - , GPA: Status - Mathematics Degree Pursued (2) Secondary Education Teaching
Date Degree gotten
or number of full time school years
MS: Telecommunication, Expected in 1996 to Pace University - Manhattan, NY GPA: 3.17 Status - 3.17 Strong emphasis on math and science
Location New Britain Telecommunication or number of full time school years Degree not finished
24 credits
CT Secondary Teachers Certification: , Expected in XXX3 to - , GPA: Status -
Tax Preparation 1993-1997
Aerospace Quality Control: , Expected in 1996 to - , GPA: Status -
Summary
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)
*Use of Angular/jQuery/Ajax/JavaScript.
*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, ...)
Technology Summary
Programming
Services
Database
*Asp.Net (14 years)
*Net Framework (ver 1.1 - 4.
Tables, Store Procedures, Functions, Indexing, Security, Normalization. Triggers, .
Table/Stored Procedure/ Index Optimization
DTS,
SSIS (test project done)
Server Configuration
Oracle
Querying
MS Access
DSN, Forms, Reports
Internet Development Skill Set
Reporting
Version Control
VB.Net, C#.Net
Webforms, MVC - Razor
CSS
HTML (tables, up, .)
JavaScript, Angular 1.6, Ajax
Bootstrap 4
jQuery
DNN (Dot Net Nuke)
Net Webform
rdlc / gridview
Excel (pivots / charts / slicer)
Crystal Reports(Windows)
Flat Files
XML
SSRS (test project done)
Cognos Bi
Source Safe (19 years) / Serena Pvcs
Team Foundation Server (Version Control Portion)
Comments
Reporting
Version Control
Used in Short Project Test
Currently enhancing mastery over this
Increasing Exposure
Some Exposure
Currently in use, expect mastery if used in next position
Will post test project on website using asmx in the coming days. Visual Studio XXX8, and Sql Server XXX8, Excel (forms, pivots, vba, events).
Developed VB.Net app, VB.Net web form app, interactive excel workbook (event driven vba)
Major pieces to sale:
Excel Workbook
Event Driven vba, forms (for projection adjustments), pivots tables, auto update of code module.
Worksheets (Projection, Actual, Report, Time and labor hours, ..)
VB.Net Winform program to read workbooks and store data in Sql Server + get information from oracle data-warehouse to update workbooks with current budget information.
VB.Net webform site to display and present different snapshots of the data for analysis by the budget officers and myself.
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.
Resume Overview
School Attended
Central Connecticut State University
Pace University
Job Titles Held:
JavaScript
Sub
Contractor
Consulting Engineer
Degrees
BS
MS
CT Secondary Teachers Certification
Tax Preparation 1993-1997
Aerospace Quality Control