SUMMARY:

• .NET Senior Developer with 7+ years industry experience in System Design, Creation, Development and Maintenance with Microsoft Technologies. Have worked side by side with .NET Technologies (Visual Studio 2008/2010/2012/2013/2015/2017, C#, Visual Basic, .NET 4.6/4.5/4.0/3.5/3.0/2.0, ASP.NET, AJAX Control Toolkit, AJAX Extensions, Web Controls, ASCX User Control and Custom Control implementation, ADO.NET, Dataset, Entity Framework with Database First, LINQ, ASPX/Razor MVC3, ASPX/Razor MVC4, Web Forms, Windows Forms, WPF, Web API, Web Services 2.0, WFC 4.0, Windows Service, Microsoft Enterprise Library), SQL Server Technologies(SQL Server 2008R2/2012/2016, Transact - SQL, Stored Procedures, Transaction implementation, Triggers, Views, Error Handling implementation, Query design and optimization), Reporting Technologies(SAP Crystal Reports 13) and Client Side Programming Technologies(Angular 2, Angular 4, Polymer 1.0, Angular Js 1.4+, JQuery 1.4+, ExtJs 3.0+, HTML/HTML5).
• Implemented client-side interfaces with JavaScript Technologies like Angular 2, Angular 4, Polymer 1.0, Angular Js 1.4+, JQuery 1.4+, ExtJs 3.0+.
• Experienced in asynchronous programming and data retrieval with AJAX requests, handling information in JSON and XML format.
• Experienced in Rapid Application Development controls implementation.
• Experienced in Web and Desktop Applications development with .NET in different Frameworks versions like: 4.6, 4.5, 4.0, 3.5, 3.0 and 2.0.
• Developed Web Applications with ASP.NET with MVC3 (Razor/ASPX engine) and MVC4 (Razor/ASPX engine) project architectures. Experience in Views and Partial Views implementation through C#.
• Expertise in Web Forms Application development through C# and Visual Basic.
• Experience in WPF for desktop based app development through Visual Studio 2010/2012 and Expression Blend 4.
• Experience in Windows Forms for desktop based applications development through C# and Visual Basic.
• Experienced in ASCX user and custom controls and WPF User controls and custom controls implementation.
• Expert application development and implementation through ADO.NET technologies using DataSet and DataReader for data retrieval through Microsoft Enterprise Library and Entity Framework 4.0+ (DataBaseFirst).
• Experienced in implementing EF with Stored Procedure for complex query processing in applications.
• Experience in implementing transactional management to ensure data integrity when doing CRUD operations with EF implementations.
• Proficient in Language-Integrated Query (LINQ to EF, LINQ to Objects, LINQ to DataSet, LINQ to XML) for data retrieval, CRUD operations, data filtering, sorting, among others.
• Experience in implementation of Web Services 2.0 and WCF Services 4.0 for method publishing across network.
• Proficient use of Web API for HTTP Request handling to implement asynchronous functionality
• Proficient use of CSS/HTML5 for web page design to achieve the creation of built-in browser functionality.
• Expertise in DataBase Management System tools such as MSSQL Server Enterprise Edition 2008R 2/2012/2016.
• Expertise in Database Analysis and Design used for data model definition (databases, tables, schemas, columns, etc.) through Data Definition Language (DDL).
• Expertise in Data Management Language (DML) for managing data within schema objects through select, update, insert or delete statements, among others.
• Expertise in Transaction Control Language (TLC) to manage changes created by DML statements and for grouping them into the same transaction to grant data integrity in a database.
• Expert in SQL query design and optimization through SQL Execution Plan tools. Experienced in Stored Procedure implementation.
• Expertise in report design and implementation with SAP Crystal Reports 13 for organizing and retrieving sensitive data in a very specific format (report).
• Great teamwork, social and communication skills.

TECHNICAL SKILLS:

Languages: Spanish language. (Native), English language. (Fluent)

Programming Languages: Microsoft Visual Basic, Microsoft C#, Visual Studio 2008-2010-2012-2013-2015-2017, Expression Blend 4, HTML/HTML5, JavaScript, Transact-SQL, Extensible Markup Language (XML), Extensible Application Markup Language (XAML), Cascade Style Sheet Language (CSS)

.NET Technologies: WPF, .NET Windows Forms, ASP.NET Web Forms, ASP.NET Web Services (ASMX) 2.0, ASP.NET User Controls (ASCX), ASP.NET AJAX Suite, MVC 3/MVC 4 (Razor/ASPX engine), ADO.NET: Dataset and Entity Framework 4.0+ (Database First), Language-Integrated Query (LINQ to EF, LINQ to Objects, LINQ to DataSet, LINQ to XML), WCF 4.0, Web API, Windows Service, Microsoft Enterprise Library, Release Management.

JavaScript Frameworks: Angular 2, Angular 4, Polymer 1.0, Angular Js 1.4+, JQuery 1.4+, ExtJs 3.0+

Reporting Tools: SAP Crystal Reports 13

Source Version Control Tools: Team Foundation Server 2010, 2012

Database Management Systems: Microsoft SQL Server 2008R2-2012-2016

Methodologies: Object Oriented Programming, AGILE, User Experience Oriented

Operating Systems: Windows XP, Windows Vista, Windows 7, Windows 8 and Windows 10

Office Suite Tools: Microsoft Office 2007, 2010, 2013 and 365

Others: Self-taught, tenacity, team worker, objectivity, analytic, methodic, optimistic, equanimity, helpful, proficient, systematic vision, curiosity, quick learner, creative, perfectionist, good empathy.

PROFESSIONAL EXPERIENCE:

Confidential

Project Lead

Responsibilities:

• Defined architecture and technical specifications of the project.
• Defined the strategy to follow to fulfill the integration of ASP.NET MVC5 and Angular 2 routing .
• Defined strategy to maximize code reusability by creating Angular wrappers over Polymer elements to avoid code repetition and to ease the Polymer elements implementation.
• Defined file structure for Angular files based in Angular IO documentation along with a previous experience with Angular JS 1.4
• Defined the modularization of the Angular application. Divided the application in smaller applications to avoid loading unnecessary code.
• In charge of code and project optimization . Bundling and minifcation through gulp, browserify and uglifyjs .
• Evaluated the UI wireframes created by the BA team and detected UX design flaws that resulted in redesigning.
• In charge of code reviews for the developer team.
• In charge of tutoring new developers that joined the project.
• Troubleshooter. Defined an implementation path for the developer team and took care of the toughest obstacles that the team faced during Angular and Polymer implementation.
• Participated in the web application development using Angular 2 and Polymer on the front end, C# in the backend and SQL for the stored procedures needed by the application.
• Language - Integrated Query implementation for data transformation.
• T-SQL query creation, implementation and optimization. Experienced in using Stored Procedures for query portability and reusability; experienced in Explicit Transactional Management implementation and Error Handling through try/catch block.
• Repository Pattern, N-tier implementation and Object Oriented Programming .
• Source Version Management through Team Foundation Server 2012.

Environment: Angular 2, Polymer, MVC5 (RAZOR engine), SQL Server 2016, CSS, LINQ, Visual Studio 2015, C#, JSON, HTML, TFS 2012, Release Management.

Programmer Analyst

Responsibilities:

• Defined strategy to fulfill integration between Polymer elements and Angular Js by implementing a directive that was able to communicate from to Polymer to Angular Js when a change was done in the Polymer element.
• Evaluated and corrected the implementation of Angular Js 1.4 in Forms project. A code revamping was needed because there were a lot of bad practices already implemented with Angular Js that were creating issues in the application.
• Implemented a Polymer element which functionality was to be able to retrieve a data source by setting the name of the data base view as a value of an element attribute. The view contained the data used to render as options. Because Iron was not used along with Polymer, a JavaScript method that implemented a Promise was written for the component.
• Participated in the web application development using Angular Js and Polymer on the front end, C# in the backend with Unity and SQL for the stored procedures needed by the application.
• T-SQL query creation, implementation and optimization. Stored Procedures, Error Handling and Transactional Management implementation included in the project.
• Repository Pattern, N-tier architecture and Object Oriented Programming implementation.
• Source Version Management through Team Foundation Server 2012.

Environment: Angular 1, Polymer, MVC4 (RAZOR engine), Unity for Dependency Injection pattern, Entity Framework 6, SQL Server 2016, CSS, LINQ, Visual Studio 2013, C#, JSON, HTML, TFS 2012, Release Management.

Programmer Analyst

Responsibilities:

• Implementation of Web API to retrieve the information of the valid recipients that eScripSafe delivers to, to send the electronic transcript to eScripSafe and to retrieve the status of the processing of a previously sent electronic transcript. The last one was also implemented in a WCF service.
• Implementation of SHA1 to provide credentials to eScripSafe for access validation.
• Implementation of WebForms with AJAX through JQuery . Updated ASCX implementation to reflect the new delivery order method.
• Implementation of an automatic re-tries method to send the electronic transcript again to eScripSafe in case of failure.
• Participated in the development using ASPX, ASCX and JQuery on the front end, C# and Visual Basic in the backend and SQL for the stored procedures needed by the web application.
• T-SQL query creation, implementation and optimization. Stored Procedures, Error Handling and Transactional Management implementation included in the project.
• Repository Pattern, N-tier architecture and Object Oriented Programming implementation.
• Source Version Management through Team Foundation Server 2012.

Environment: ASCX, ASPX, Web Forms, Console Application, WCF 4.0, JQuery 1.4+, SQL Server 2016, CSS, LINQ, Visual Studio 2012, C#, VB, JSON, HTML, TFS 2012, Release Management, Web API, SHA1.

Programmer Analyst

Responsibilities:

• Defined database design in coordination with DBA team.
• Defined file structure for Angular JS files based in Angular IO documentation.
• Participated in the web application development using Angular Js 1.4 in the front end, C# in the backend and SQL for the stored procedures needed by the application.
• T-SQL query creation, implementation and optimization. Stored Procedures, Error Handling and Transactional Management implementation included in the project.
• Repository Pattern, N-tier architecture and Object Oriented Programming implementation.
• Source Version Management through Team Foundation Server 2012.

Environment: Angular 1, MVC4 (RAZOR engine), Entity Framework 5, SQL Server 2016, CSS, LINQ, Visual Studio 2013, C#, JSON, HTML, TFS 2012.

.NET Developer / Database Designer and Analyst

Responsibilities:

• Imp lemented Model-View-Controller (MVC3) architecture with ASPX engine through C# 2010/2012 . For the view part, ExtJs Framework was selected as the asynchronous technology to go, for the model part Entity Framework 4 was implemented. With the use of ExtJs Gridview control and with implementation of forms with client side functionality; we avoided the View per Method Basis that is built-in when you select to create a non-empty controller. Designed, implemented and maintained several views, and implemented their respective controller with error handling included, like a drag and drop implementation between Gridviews, to insert data from teachers to their correspondent school, to finally create lists of teachers for each school.
• Hands on experience with Sencha CMD to perform minifying, compiling and building actions for the EXTJs files that need to be generated and deployed in the production environment.
• Entity Framework 4 implementation for model part of the project with Database First approach. Experienced in getting updates from database to model about tables or stored procedures definition. Mapped several tables and stored procedures within the project.
• Language- Integrated Query to Entity Framework implementation for data retrieval. Implementation of Stored Procedures via Entity Framework to manage report data source and to minimize impact with high complexity LINQ queries. Designed and maintained Stored Procedures via Entity Framework for transcript printing for Elementary, Junior High, High School
• Transaction management in LINQ queries for Create - Update - Delete operations with TransactionScope implementation. Definition of transaction isolation level, ranging for select statements that needed ‘Read Uncommitted’ level to Create - Update - Delete Transactions that required ‘Read Committed’ level.
• Dataset design, creation and implementation. Created data source definitions for SAP Crystal Reports to give them the capability of receiving the list of objects retrieved by LINQ to EF queries. Designed and maintained Dataset with different Datatables for each report that was needed.
• Web Service creation and implementation for giving access to student, teacher and school data for other projects within the institution.
• WCF 4.0 creation and Implementation. Implemented endpoints for other projects within the institution, which needed data from our projects database.
• Windows Service creation and implementation for automatic data calculation. The service is going to manage process schedule to perform Create-Update-Delete activities when needed. Used to calculate specific statistics that heavily impact in database like the percentage of students grades that have been processed into system, for each school, by group, by grade.
• T-SQL query creation, implementation and optimization, for reporting and non-reporting purposes. Stored Procedures and Transactional Management implementation included in the project. Optimized old queries that were created for reporting purposes to new ones getting a performance gain from 8 minutes execution time to less than 2 seconds. Experienced in using PIVOT statement for rearrange order of the results for reporting purposes.
• Table design, creation and optimization with MSSQL 2008R2. Index creation included when needed. Designed, created and updated tables in the project, like ComprensionLectoraPrimaria and ComprensionLectoraSecundaria that were tables that held data about how skilled the students were at their reading skills. Added indexes to tables that needed them like Inscripcion, to boost search operations for data. Performed index rebuilding activities to low fragmentation.
• User interface ( views ) design and development with ExtJs 3.0+ Framework. Created views with ExtJs controls as Gridview, Datepicker, and ItemSelector . Implemented drag and drop functionality to pass data from one Gridview to another to perform update operations. Implemented ItemSelector control to pick data from one list and put it into another.
• View design and visual effect animation implementation with Cascade Style Sheet (CSS). Customized controls appearances with CSS implementation.
• Project was built to be 90% asynchronous . With ExtJs, the most of the data retrieval implementation was made by Ajax calls with Json format or with the “sync()” function provided with the framework, when it applied to.
• Report Design and implementation with SAP Crystal Reports 13. Created transcript reports with sub-report implementation for complex reporting and code reusability. Created reports with good-looking design and dynamic behavior depending on the data that was sent to them.
• N-tier implementation and Object Oriented Programming.
• Technical Support for users that access to the system.
• Source Version Management through Team Foundation Server 2010.

Environment: MVC3 (ASPX engine), Entity Framework 4.0, ExtJs 3.0+, SQL Server 2008R2, TFS, CSS, SAP Crystal Reports 13, LINQ, Visual Studio 2010/2012, C#, AJAX, JSON, WCF 4.0, Web Service, Windows Service, TFS 2010

Sistema Integral de Control de Correpondencia Interna en Web

Responsibilities:

• ASP.NET Web Forms implementation through Visual Studio 2010/2012 and Visual Basic . Implemented Master Page to achieve code reusability. Created several pages with Gridview control implementation for catalog management for update, delete, add, and edit operations.
• Design and implementation of ASP.NET User Controls (ASCX) for code reusability. Created controls with custom functionality, mainly to perform searching data activities to the server in different pages. Created control for custom error messaging. Have implemented web controls like Textbox, Label, Dropdownlist, Gridview among others
• Microsoft Enterprise Library 5 implementation for database connection.
• Created data source definitions for SAP Crystal Reports to give them the capability of receiving the list of objects retrieved, first via DataSet / DataReader so they could be then transformed to their object equivalent and finally added as data source to the report.
• T-SQL query creation, implementation and optimization, for reporting and non-reporting purposes. Stored Procedures, Error Handling and Transactional Management implementation included in the project. Designed several queries, including some with Dynamic SQL, to have the capability of configuring the statement to execute depending on the parameters that were sent.
• Client side validation with JQuery 1.4+ . Implemented client side event handling through JQuery code.
• User interface design, User Control and visual effect implementation with JQuery 1.4+ Framework. Animated controls with show/hide functionality. Implementation of web server hidden field controls to maintain client side state though postback action.
• Report Design and implementation with SAP Crystal Reports 13 . Created reports with good-looking design and dynamic behavior depending on the data that was sent to them.
• Table design, creation and optimization with MSSQL 2008R2. Analyst assistant within the design and creation of tables in the project.
• Page design and visual effect animation implementation with CSS. Experienced in autocomplete, fade in, fade out functionality among others.
• Repository Pattern, N-tier architecture and Object Oriented Programming implementation.
• Technical Support for users that access to the system.

Environment: ASP. NET Web Forms, ASCX User Controls, SQL Server 2008R2, TFS, CSS, SAP Crystal Reports 13, Visual Studio 2010, Visual Basic, Web Service.

Responsibilities:

• Transition implementations in user interface. Implemented ProgressBar control, animated change of state like when changing from window, custom states from Button control like when it was clicked or hovered with Expression Blend 4 and Visual Basic. Functionality debugging tests were performed in Visual Studio 2010, because Expression Blend 4 capabilities are limited in that purpose.
• ResourceDictionary implementation for design code reusability. Like a CCS file, it contained all the code corresponding to the format of the controls within the application.
• Creation of User Controls and Custom Controls with Expression Blend 4 . Created a control that consisted in a group of DropDownList controls for search functionality, that depending on what type of search you were expecting it would change it appearance and number of options to use. Experienced with Tunneling / Bubbling Events implementation.
• Database analysis and design for Codex Project. Database creation, update and maintenance for Codex Project . Along with client’s needs, tables that fitted the domain of their business where created and updated when they discovered that it was required.
• Data migration from .CSV files to database. The data that the customers wanted to use for the application wasn’t synthetized at all. In order to define a database model, there were meetings with the clients to define a database model.
• Provided the .CSV file structure to clients, for data synthesis. Performed data conversion from this .CSV files to database with SSIS .
• Entity Framework 4 and Language - Integrated Query to EF implementation for database connection and data retrieval.
• In charge of Codex Project Documentation in every stage of the development life cycle. Reviews and dated annotations were done
• WPF Telerik RAD Control Implementation. Have implemented WPF controls like TextBox, TextBlock, ListView, DataGrid among others. Implemented different charts for reporting purposes like Bar Chart, Line Chart, Radial Chart and Point Chart among others.
• Object Oriented Programming implementation.

Environment: WPF, Entity Framework 4.0, SQL Server 2008R2, Visual Studio 2010, Visual Basic, Expression Blend 4, WPF Telerik RAD Controls.