Mario Allwyn Henry Joe

Software Developer

660 Boas St., Harrisburg, PA 17102 | +1(217)-220-6847 |

Portfolio:

Summary

  • Over 3.5 yearsof extensive experience in the System Analysis, Design, Development, Coding and Implementation of various applications based on (OOPS) Object Oriented Programming, Client/Server N-tier architecture, Model View Control (MVC),Model View Presenter(MVP), Web based and Internet Technologies.
  • Extensively used HTML5, Bootstrap, ANGULAR JS and JQUERY and created Single Page Applications (SPA).
  • Experience in developing and consuming services using WCF (REST, SOAP) and ASP.Net Web API.
  • Experience in design and implementation of services using WCF SOAP\REST, creating REST services using ASP.NET Web API
  • Expertise in ASP.NET MVC 4/0/3.0 and developed the features Views, Partial Views, Strongly Typed Views, Sections, Areas etc. and also implemented Controllers and Controller Actions, Filters, Routing.
  • Used Vb, C# extensively to write the business logic file.
  • Extensively worked ASP.NET MVC 5.0 applications using Database-First/Code-First Approach in Entity Framework 4.3/5.0/6.0 and UI in Razor View Engine and client side framework Bootstrap, HTML 5.
  • Expertise in Database design (RDBMS),programming, implementation and development using MS SQL Server 2005/2008/2012, Oracle 11g/10g/9i, MS access,MySQLStrong analytical and conceptual skills in database related work primarily creating complex Stored Procedures, Functions, Views, Triggers, Functions, Indexes, Cursors, Normalization.
  • Developed applications using Microsoft Visual Studio, Adobe Dreamweaver, and Eclipse including the design and implementation of custom web parts and other programs that leverage the object model.
  • Experience in functionality with Entity framework Code First and Database First approaches with ASP.NET MVC 5.0/4.0.
  • Implemented ADO.Net data access techniques i.e. SQL Connection Objects, SQL Command Objects, Dataset Objects, Data Reader Objects and Data Adapter Objects using Data Grid, Data List and Repeater controls.
  • Experience with Software Development Processes & Models: Agile, Waterfall & Scrum Model.

Education

University of Illinois at Springfield, Springfield, IL July 2015.

GPA:3.96

Master of Science in Computer Science

Related Courses:

Big data Analytics, Web Development and Programming, Advance Database Management System, Python Programming, Software testing.

Bachelor of Engineering in Computer Science from AnnaUniversity, India.April 2013.

Technical Skills

Programming Languages: / C#.Net(4.0/3.5/3.0) , HTML, T-Sql, PL/SQL
Web Technologies: / ASP.NET 4.5/4.0/3.5/3.0/2.0, ASP.NET MVC 4.0/3.0, Javascript, Jquery, VB Script, AngularJS
UI Technologies: / Winforms, Jquery UI
IDE Tools: / Visual Studio 2010/2008/2005, Sql Server Management Studio
Databases: / MS SQL SERVER 2012/2008/2005/2000, MS Access2010/2007/2003,Oracle 11g/10g/9i/8i, Cassandra
Reporting Tools: / Sql Server Reporting Services (SSRS 2008/2005),
Version Control Tools: / Team Foundation Server(2008)
Modeling Tools: / UML, MS Visio 2010/2007
Web services: / WCF, SOAP, Web API
Middleware: / ADO.NET 4.0/3.5/3.0/2.0, Web Services,
Servers: / Windows Server 2008/2003/NT, Microsoft IIS(7.0/6.0/5.0/4.0)
Other Utilities / Nlog, FxCop, Style Cop

Key Strengths

  • Team worker with good leadership qualities.
  • Quick and zealous learner who can adapt to any organizational environment.
  • Analytical thinking and problem solving capability peered with strong communication skills.

Professional Experience

Deloitte Consulting LLC, Camp Hill, Pennsylvenia. Mar’ 2016 – Till Date.

.Net developer

Home and Community Service Information Systems.

Client: Department of Public welfare, State of Pennsylvania.

Role/Responsibilities:

  • Involved in Software development life cycle (SDLC) of application from determing the level of effort to design phase to implementation phase, testing, Deployment and maintenance phase.
  • Have written rich and efficient code using VB.Net, ASP.Net, and MVP(Model-View-Presenter) Architecture for creating web applications.
  • Used ADO.NET and Entity Framework4.3/5.0/6.0extensively for retrieving, querying and manipulating data in the databaseusing LINQ.
  • Created and maintained database objects like complex Stored Procedures, Cursors, and Tables, Views, User Defined Functions, in MSSQL Server 2012 for inserting/Updating/Deleting the data into the relational tables.
  • Involved inUnit Testing using Shim, fakes, and stubs, also in Nunit in order to maintain the code coverage.
  • Created Test scenarios in Microsoft Test manager, and performed Integration Testing, and User acceptance testing after the completion of development.
  • Worked on Release phase and Operations phase of the project. Worked on incident tickets, fixed the bugs, data fixes, analysis, performance tuning of SQL.
  • Used Microsoft Team Foundation Server(TFS)as source control, and to manage the tasks and tickets.

Durham Public Schools, Durham, North Carolina. Sep’ 2015 – Feb 2016.

.Net developer

Risk Management Services

Role/Responsibilities:

  • Involved in Software development life cycle (SDLC) of application from design phase to implementation phase, testing, Deployment and maintenance phase.
  • Participated in daily Scrums with the whole team to discuss about the progress of the application development, specks to be taken care and specks that already completed.
  • Rich development experience creating web applications using ASP.Net, C# and MVC (Model-View-Control) Architecture.
  • Used ADO.NET and Entity Framework4.3/5.0/6.0extensively for retrieving, querying and manipulating data in the databaseusing LINQ.
  • Migrated the application business logic from Vb.Net to C#.
  • Wrote business logic code in C# code behind files to read data from database stored procedures.
  • Implemented CRUD functionality with Entity framework in ASP.NET MVC and implemented sorting, filtering and paging with Entity framework Code First in MVC.
  • Implemented the Identity Assess management using Rolemanager and Membership in Web.config, and Users are managed from ActiveX Directory.
  • Created grids to show the reports retrieved from database.
  • CreatedClient-side JavaScript Library for various standard control validations using regular expressions and DOM methods.
  • Responsible for Designing and Developing the Reusable UI Components Like MVC Master Pages “Layouts and Nested Layouts”, “View Start” and MVC User Controls “Partial Views” using HTML5, CSS3, Bootstrap in Razor engine and Telerik Kendo UI Complete.
  • Connected the ASP.NET5.0/4.5/4.0/3.5 project to the SQL Server 2012 database using ADO.NET Entity framework model for various .NET Framework 4.6 namespace.
  • Created and maintained database objects like complex Stored Procedures, Cursors, and Tables, Views, User Defined Functions, in MSSQL Server 2012 for inserting/Updating/Deleting the data into the relational tables.
  • Performed DOM manipulations, create Templates, Directives, Factories, Controllers, and established tow way Data binding using Angular JS.
  • Implemented the Autocomplete using typeahead, and timeoutsessions using Jquery AJAX.
  • Used JSON to transmit data between Server and Web Application, an alternative to XML Serialization.
  • Developed REST APIs that allow sophisticated, effective and low cost application integration and multi-tier web applications with the use of Web Services using ASP.Net Web API.
  • Implemented Event logging system for the project in order to record the error logs using Nlog from Nuget Packages.
  • Deployed the project using IIS manager, tested in QA environment and moved it to Production.
  • Working with Team Foundation Source Control (TFS) as the source for version control and project / issue management.

Ugam Solutions Pvt LTD, Coimbatore, India. Jul’ 2013 – Aug’ 2014

Software Developer

Ipsos NA

Description: This project is to maintain the established Customer Relationship Management (CRM), which will help Ugam in getting a single view of its customers and access to critical customer information. This included resolving tickets raised by the end users regarding the reports, validity of the data and other enhancements.

Responsibilities:

  • Involved in Software development life cycle (SDLC) of application from design phase to implementation phase, testing, Deployment and maintenance phase.
  • Participated in daily Scrums with the whole team to discuss about the progress of the application development, specks to be taken care and specks that already completed.
  • Implemented abstract, sealed classes, interfaces and classes to construct the business and data tier using C# and Entity Framework.
  • Implemented CRUD functionality with Entity framework in ASP.NETMVC and implemented sorting, filtering and paging with Entity framework in MVC.
  • Rich development experience creating web applications using ASP.Net, C# and MVC (Model-View-Control) Architecture.
  • Responsible for designing the ASP.NET application authentication using .NET Framework, Model View Controller MVC and IIS security model.
  • Developed Action Filters in MVC(Model-View-Control ) and used Angular JS for client side scripting
  • Worked on Code First approach and Database First approach for the MVC and Entity Framework for designing the models.
  • Angular JS was used to make the web applications dynamic and is used for making DOM manipulation.
  • Angular JS was used for creating the controllers, Factories, Services, Custom Directives.
  • Experience in working with JavaScript frameworks like Bootstrap and Angular JS.
  • Worked with JSON to pass the JavaScript objects from server to web application.
  • Created WCF, WCF REST Services and also used different bindings to make it available to different types of clients
  • Worked on creating Rest Services using ASP.NET Web API and C#.
  • Created Stored Procedures, Indexes, Functions, Packages, Triggers, and Views using T-SQL in Development and Production environment for SQL Server 2005.
  • Developed SSIS packages to export data of flat file source to SQL Server Database.
  • Used SQL Server Reporting Services (SSRS) for generating reports populated by data in databases.
  • Involved Unit Testing, Integration Testing and Regression testing in a regular basis to improve the performance of the application
  • Used Microsoft Team Foundation Server (TFS) to manage the team's software development lifecycle including deriving product backlog items, assigning sprint work items to developers and conducting sprint review meetings

Environment: Visual Studio 2012,C#4.0, ASP.NET4.0, VB.Net8, MVC 5.0/4.0, .NET Framework 4.0, JavaScript, CSS3.0, ADO.NET, Entity Framework 6.0/4.0, Web API, JSON, HTML5, NUnit , TDD, VBA, LINQ, WCF, AJAX, HTTP, Microsoft Enterprise Library, TFS2010, XML, Angular JS1.5, JQuery2.0, Agile, SSIS, SSRS, SQL Server 2012, SOAP, IIS 7.0 , Windows XP, Windows Server 2003, CRM, Continuous Integration, Windows Server 2008 R2/2008, PL/SQL.

Faith Coalition for Common Good, Springfield. Dec’ 2014 – May 2015.

Web Master Intern

Role/Responsibilities

  • Used ASP.NET Web forms for the development of the application.
  • Used Ms SQL Server 2012 for creating database, tables, stored procedures, functions, complex queries.
  • Utilized Entity Framework technology extensively for data retrieving, querying, storage and manipulation using LINQ.
  • Implemented View Model patterns/ in creating and managing Views, Partial Views, View Models, Web APIs using ASP.NET MVC, HTML5, CSS3, Bootstrap.
  • Experience in working with JavaScript frameworks like Bootstrap.
  • Created Stored Procedures, Indexes, Functions, Packages, Triggers, and Views using T-SQL in Development and Production environment for SQL Server 2012.
  • Used ADO.NET Entity Framework Model as the Data Access Layer (Database First) and implemented the CURD(Create, Update, Retrieve and Delete) operations, Mapping and executed stored procedures
  • Created FxCop rules to analyse .NET assemblies.
  • Deployed the project using IIS manager,tested in QA environment and moved it to Production.

KG Financial Software Pvt. Ltd, Coimbatore, India. July’ 2012 – May 2013.

Application Developer Intern

Document Organization and Retrieval Solution(DOoRS)

Responsibilities:

  • Product development is an Agile (SCRUM) methodology, where progress and task assignment is discussed in everyday meetings.
  • Developing winforms which allows scheduling of automatic downloads of various data feeds at regular period.
  • Developed and modified the production software (multi-tiered web applications) using C#, VB.NET, ADO.NET, ASP.NET. (.Net 1.1 – .Net 3.5 Framework ) AJAX, XML, .Net 1.1 – .Net 4.0 Framework, HTML, JavaScript, CSS, Multi-threading, (Win Forms) technologies.
  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Used ASP.NET Model View Controller (MVC) architectural Design Patterns for the development of the product.
  • Developed system services SOA application platform for use by all web applications utilizing WCF services and the ASP.NET provider model.
  • Developed the Form Classes, Objects and Interface using C# for code-behind depending on the business logic.
  • Involved using bindings to control the construction of the Windows Communication Foundation (WCF) channel stack at runtime.
  • Successfully used Data Contract as the standard mechanism in the WCF for serializing .NET object types into XML.
  • Designing and Developing the User Interfaces using Razor views, HTML, JQuery, Ajax and CSS.
  • Used ADO.NET and Entity Framework extensively for retrieving, querying and manipulating data in the database.
  • Extensively working on LINQ to Object, LINQ to XML etc. to query different data sources.
  • Used ASP.NET MVC4.0 Page Controller pattern to add functionality to individual pages such that to accept input from the page request, invoke the requested actions.
  • Proficient in developing database objects like queries, stored procedures, Packages, PL/SQL Programs, Functions, Cursors, Reference Cursors, Dynamic SQL.
  • Involved in unit testing, integration testing and deployment of the application.
  • Team Foundation server 2010 (TFS) has been used for all the source code maintenance among the whole team members.
  • Involved in all the stages of SDLC and interacted with offshore team. Completely understand the importance of Quality of work in deliverables given to client.

Environment: VisualStudio2010, C#, ASP.NET MVC 3.0,WCF, Entity Framework 6.0, EDMX, JQuery, VB.NET, VB6, TFS 2010, IIS 7.0, AJAX, ADO.NET Entity Framework 4.0, LINQ,XML , Microsoft Enterprise Library, NUNIT, Oracle11g, Windows Server 2008 R2/2008.

Academic Projects

• Big Data Analytics:

  • Developed a project to retrieve the top 10 universities from wikilinks dataset using MapReduce programming, and Pig Script.
  • Mapreduce program will return only the name and pagerank of each university from a large dataset. It returns the university name and ranking.
  • The pig program will eliminate the red links and performs 10 iterations to find the exact page rank.

• Springfield, IL Public Transport Bus Timings:

  • Developed aweb application to enable user to enter boarding and destination place to obtain schedule for next available Buses.
  • I used PHP for front end and MySQL as database platforms.
  • The project got recognized and appreciated by the Marketing manager of Springfield Mass Transmit District, IL.

• Personal Web Portal:

  • Developed a web application using PHP and MySQL to register customer login details, quotes, make sub directory for each user, stores the files uploaded by them in that particular sub directory.
  • Each user can add their own information, reminders. They can upload and save their own documents on servers.
  • Everything is session based, and users can view only their own files.

• P&G Distribution Management:

  • Created a prototype for P&G Distributors to make all their requirements automated using MS-Access.