SUMMARY

• Over 12 years of Information Technology (IT) and software development experience working with production support, migration, and product development on both open source and various Microsoft platforms that includes .NET framework (C#/VB.NET), web development with ASP.NET (web forms/MVC), and Windows Forms.
• Experienced in working with complete software development life cycle (SDLC) in requirements analysis, application and solutions development, implementation, and documentation with either waterfall and/or Agile methods
• Working experience in various domains such as Compliance, Health, Order Forms and Project Configuration, Travel and various Line of Business Applications
• Adaptable to new technologies in a short span to quickly deliver product and business requirements
• Experienced in working with teams, and vendors in various locations and engaging them in addressing technical challenges and seek working solutions, as needed.
• Experienced mentoring and assisting team members in delivering solutions and to keep them engaged in the development process, and product support continuity
• Excellent interpersonal, customer relationship, leadership and analytical & problem - solving skills.

TECHNICAL SKILLS

Languages: C#, Visual Basic .NET, VB6, C/C++

Web Technologies: ASP.NET Web Forms, ASP.NET MVC, ASP.NET SignalR, ASP.NET Web API, PHP, HTML, Perl, JavaScript, jQuery, ASP.NET Web Services (ASMX), Windows Communication Foundation (WCF), AngularJS, KendoUI

Desktop Technologies: Windows Forms, Windows Presentation Foundation, Windows Store App Development

Cloud Technologies: Windows Azure

Application Servers: Internet Information Services (IIS), Apache

Databases: SQL Server, MySQL, MS Access, Windows Azure Storage (NoSQL), Azure SQL

Reports: SQL Server Reporting Services

Data: LINQ, Entity Framework Code/DB First, T-SQL, Stored Procedures, SSIS

IDE: Visual Studio, Notepad++, SQL Server Management Studio

Source Control: Team Foundation Server, Visual Studio Online, Git

Third Party Controls: Telerik RAD Control, Resharper

Ticketing Tools: Remedy, Service Now (SNOW)

Operating System: Windows, Linux

PROFESSIONAL EXPERIENCE

Confidential

Developer/Programmer Analyst

Responsibilities:

• Performed application enhancements required by the business.
• Implemented Spanish and French localization for users based in Canada and Mexico plants.
• Wrote an application that syncs resource dictionary with English-USA as the base dictionary and append missing keys and remove keys that isn’t present in the base language.
• Ensured single instance run of the program.

Tools: Windows Forms, C#, SQL Server 2012, SAP Hana, Visual Studio, SQL Server Integration Services (SSIS)

Confidential

Developer/Programmer Analyst

Responsibilities:

• End to end ETL-like design and implementation from legacy heterogeneous data sources to SAP Hana and SQL Server
• Performed systems redesign from consuming mainframe data through EntireX .NET wrapper to consuming data changes and equivalencies from SQL Server with SAP Hana Smart Data Integration
• Reduced dependencies on SQL Server Integration Services (SSIS) by performing data transformation using T-SQL and Entity Framework
• Refactored application code base using design patterns to make application easier to test and maintain by separating concerns and reusing code blocks as components throughout the application.
• Removed dependencies on third party libraries such as Enterprise Library and created custom data access project that utilizes native ADO.NET objects.
• Utilized T4 templates for creating new objects that will be used to represent data from new and old data sources that will be used by the application.
• Developed helper libraries and extension methods that are being used across several projects.
• Performed code and SQL query rewriting, cleanup and optimizations as needed.
• Implemented both Entity Framework Code-First and Database-First for the ORM layer of the application
• EF Code-First were used to generate new SQL tables based from the T4 templates, and other custom-made objects that will accommodate the new functionality of the service.
• EF Code-First enables easier migration of newly created SQL tables from one environment to another.
• EF Database-First were used to consume data for price generation and document building functionality for notifications.
• Implemented BulkCopy functionality for both SQL and Hana data sources (SqlBulkCopy and HanaBulkCopy) to move data and to handle price change requests and updates between different platforms.
• Participate in meetings with stakeholders and mentor team mates, as the need arises.

Tools: Windows Service, C#, VB.NET, SQL Server 2012, SAP Hana, Entity-Framework Code First, T4 Templates, Crystal Reports, Visual Studio, SQL Server Integration Services (SSIS)

Confidential

Responsibilities:

• Rewrote application to update references from legacy data to updated equivalencies using cross references and lookup tables.
• Removed unnecessary references and performed clean-up of user interface.
• Implemented customer inclusion list where application admin can control the list of customers who would be receiving the prices based on the regions/market set by the company.
• Performed code and SQL query rewriting, cleanup and optimizations as needed.

Tools: Windows Forms, C#, SQL Server 2012, SAP Hana, Entity-Framework DB First, Visual Studio

Confidential

Systems Analyst

Responsibilities:

• Involved in project life cycle, including planning sessions with project stakeholders (e.g. product owner, market contacts, business analyst, software architects) to analyze business requirements and design flow using Scrum/Agile methods.
• Designed and implemented using ASP.NET MVC with separate projects that will handle data connections, and in the future reports using SQL Server Reporting Services.
• Written stored procedures and executed queries for the data layer using Microsoft SQL Server.
• Implemented ORM with Entity Framework Code First to facilitate database changes versioning to accommodate future market changes/requirements.
• Generated prototype front-end web UI using AngularJS 2 for a possible mobile UI for the application
• Implemented source control for the project using both Git and TFS

Tools: ASP.NET MVC, C#, SQL Server 2014, AngularJS, T-SQL, Entity Framework Code-First, IIS, Visual Studio, Git, nUnit

Confidential

Systems Analyst

Responsibilities:

• Provided L3 production support for Incident Tickets/errors/outage.
• Participated in release and change management calls to in corporate new features proposed under application enhancement and maintenance.
• Worked with various market contacts and server/application teams in identifying root causes of production issues by analyzing error logs reported both by the application and the servers from where the applications were hosted.
• Devised and recommended a standard maintenance window for the web application that the application is using based on the lean operating hours of the markets to reduce application timeouts and refresh of unused web connections.
• Upgraded application to address incompatibilities particularly for third party tools (SftTabs) that prevents users from accessing the application properly when the hosting environment of the application was upgraded from Windows Server 2003 to 2008.

Tools: Windows XP, Visual Basic 6, Galileo, TravelPort SmartPoint, SQL Server, SQL Server Management Studio, Windows XP, Git

Confidential

Technology Specialist

Responsibilities:

• Translated Win32 UI screenshots to WPF based on the application standards provided by the solutions architect of the company based on a custom implementation of MvvmCross.
• Manage work items of the project through Visual Studio Team Services and provide daily reports to Japanese stakeholders about quality and delivery issues.
• Conducted code review and peer review with the team to ensure code quality
• Developed scripts and stored procedures using SQL Server for the reports and data manipulation queries
• Setup and deployed development, test, and QA environments data backend using Azure SQL.
• Implemented source control for the project using both Git and TFS

Tools: WPF/XAML, C#, SQL Server 2014, T-SQL, Entity Framework Database-First, IIS, Visual Studio, Azure SQL,Git, Powershell

Confidential

Systems Analyst

Responsibilities:

• Created initial UI modifications to follow from the base examples of MvvmCross (MVVM) to the company’s standard MVPVM (Model-View-Presenter-ViewModel)
• Created C# objects that will be used for the standard data exchange between the desktop application and the Azure Cloud Service project.
• Developed and implemented custom reusable .NET components for common tasks and processes within the application.
• Created proof of concept on technical requirements on which others can follow and build upon. Provide documentation and guidance based on best practices on developing Windows Presentation Foundation (WPF) applications and how these can be implemented in the project requirements.
• Developed the ASP.NET application that served as the Cloud Service Project where all transactions are being saved to the Azure Table Storage.
• Handled modifications to handling unsupported data types in Azure Table Storage (decimal is not supported) but essential in handling precision in the financial information being handled by the application.
• Monitored and maintained the continuous integration (CI) server for the non-production environments that is being used by both Japan and Manila teams using Team Foundation Server
• Participated in meetings with the team, and Japanese stakeholders on the scheduling of product testing and delivery using Scrum/Agile methods
• Implemented source control for the project using both Git and TFS

Tools: C#, WPF/XAML, Windows Store App Development, ASP.NET, Azure Cloud Service Project, Azure WebJobs, Azure Table Storage, Windows Azure, Visual Studio, Windows 8.1 Embedded, Remote Debugging, Team Foundation Server, Git, nUnit, Powershell

Confidential

Developer and Technical Analyst

Responsibilities:

• On-shore deployment to Confidential Headquarters in San Ramon, California with L1 Visa, as a resource dedicated to work as the developer/Technical Analyst for the STARS project replacement
• Provided an architectural overview of the existing system and help the business understand their requirements and how these would affect future compliance requirements specified either by the legal department and/or US laws.
• Performed proof-of-concept development and testing estimates on the new application on two approaches - rebuilding the application from scratch or building from the existing one. Gave the business flexibility to decide on project options based from either project schedule, cost, and/or resources available.
• Created proof of concept projects that will mimic the existing STARS web application to Archer GRC
• Liaise with the Archer representatives and helped facilitate the installation and deployment of the pre-production environments of GRC Archer in Windows Server 2012 and SQL Server 2008 R2
• Gathered requirements and reported the outcome to the project stakeholders (Chief Compliance Officer, developer, Business Analyst, Product Owners) on the feasibility of the third-party tool based on company requirements and on actual development done.
• Performed architectural review and recommendation based on the existing software specification from 2009 to the then current company mandated-guidelines on software design requirements.
• Created development plan and estimates on migrating the existing application to the latest company specified software versions using .NET 4.5, Visual Basic .NET, SQL Server 2012, SQL Server 2012 Reporting Services, Windows Server 2012, and to Entity Framework 6

Tools: RSA Archer, SQL Server 2008 R2, Windows Server 2012, Scrum/Agile, Powershell

Confidential

Application Developer and Support Analyst

Responsibilities:

• Develop and deploy application changes that support and change fundamental IT business compliance needs. These include deployment of bug fixes/enhancements in accordance to severity and business needs using ASP.NET web forms/VB.NET with backend as SQL Server, and creating new reports as needed by the business
• Conducted application health reviews by coordinating the infrastructure’s team scheduled maintenance windows for the servers of the application with the business analyst to ensure that people are aware of the unavailability schedule of the application.
• Performed migration and updates on the application on the following items:
• Upgraded the application from .NET 3.5 to .NET 4.5
• Rewritten the data layer of the application from LINQ to Entity Framework (EF) Database First.
• Addressed breaking changes in Telerik RAD Controls that was introduced when .NET 4.0 was released.
• Upgraded the database from SQL Server 2008 to SQL Server 2012. This includes upgrade of the SQL Server Reporting Services as well as the enhancements required for IE11 compatibility.
• Reduced the number of lines of code without affecting business process by refactoring the code, taking out commonly used code into reusable ones ensuring consistency in application logic.
• Implemented unified WCF service that abstracts application security through Active Directory with additional filters without the need of creating user groups in the domain.
• Introduced and implemented error reporting by sending e-mails to the technical support team whenever a business process has failed and by providing pertinent details regarding the error occurred such as the file and the stack trace. This will give a better picture to the developer to check if the issue is a major roadblock and needs escalation.
• Designed and implemented an “offline mode” for intranet applications enabling access to certain individuals while restricting access to the rest of the users by modifying behavior of the application.

Tools: ASP.NET 4.5, SQL Server 2012, Visual Basic.NET, Entity Framework 6 (DB First), SQL Server Reporting Services (SSRS), Telerik RAD Controls, Team Foundation Server, Powershell, Active Directory

Confidential

Application Developer and Support Analyst

Responsibilities:

• Develop and deploy application changes that support and change fundamental IT business compliance needs. These include deployment of bug fixes/enhancements in accordance to severity and business needs using ASP.NET web forms/VB.NET with backend as SQL Server
• Conducted application health reviews by coordinating the infrastructure’s team scheduled maintenance windows for the servers of the application with the business analyst to ensure that people are aware of the unavailability
• Performed migration and updates on the application on the following items:
• Upgraded the application from .NET 2.0 to .NET 4.0
• Rewritten the data layer of the application from LLBLGEN to Entity Framework (EF) Database First. Implemented company mandated standards that applications with LINQ should be migrated to EF.
• Addressed breaking changes in Telerik RAD Controls that was introduced when .NET 4.0 was released.
• Upgraded the database from SQL Server 2008 to SQL Server 2012. This includes upgrade of the SQL Server Reporting Services as well as the enhancements required for IE11 compatibility.
• Reduced the number of lines of code without affecting business process by refactoring the code, taking out commonly used code into reusable ones ensuring consistency in application logic.
• Implemented unified WCF service that abstracts application security through Active Directory with additional filters without the need of creating user groups in the domain.
• Maintained and supported data transformation services (SQL Server Integration Services, DTS) job that updates the completions of compliance tests required for their function.

Tools: ASP.NET 4.0, SQL Server 2005, VB.NET, LLBLGEN, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Telerik RAD Controls, Team Foundation Server, Powershell

Confidential

.NET Web Developer / Acting Senior Developer

Responsibilities:

• Supported the Global Liebert Information Systems (Liebert IS) operations as a Manila resource. Performed creation and modification of product configuration (order forms) logic, price changes for use of the company’s resellers and partners.
• Sent to the US as a technical resource to start working on the replacement project in the Liebert office in Westerville, Ohio
• Developed modules for the new system based on the new architecture in ASP.NET MVC 2 and custom Ajax libraries
• Monitored and maintained the continuous integration (CI) server to sync changes with the development teams in Manila and in Ohio using Team Foundation Server
• Managed database mirroring between Manila and US instances of SQL Server using Schema and Data compare tools of Visual Studio
• Participated in KT sessions for onboarding new applications & delivered cross KT to other team members.
• Participated in conference calls with the business to understand requirements and defects reported
• Performed code reviews and creation of test-cases using company-designated application design requirements (coding conventions, framework coherence) before submission to counterparts for testing and deployment.

Tools: /Technologies/Environment: VB.NET/ASP.NET MVC, SQL Server 2008, Team Foundation Server

Confidential

Application Developer and Support Analyst

Responsibilities:

• Create and modify El.Net order components using Visual Basic 5 and package them as ActiveX objects for deployment.
• Handled code versioning using Visual Source Safe hosted in Citrix
• Performed scripts related to price updates for different regions using Excel and SQL Server
• Generated and created new reports for the marketing team using SQL Server Reporting Services
• Managed content for the public facing websites of Confidential Network Power in Classic ASP
• Converted customer management modules of the PartnerWeb website from Classic ASP to ASP.NET for future enhancements

Tools: Visual Basic 5, ActiveX, Visual Source Safe, Citrix, SQL Server, Classic ASP, Microsoft Excel, SQL Server Reporting Services, VB.NET/ASP.NET

Confidential

Web Developer

Responsibilities:

• Translated technical and business requirements into a working product based on deadlines set by the business analysts and marketing department.
• Developed both front and backend code using Dreamweaver
• Performed application releases to test and production environments using CuteFTP
• Provided on-call support for other in-house web applications of the company and that of Confidential 7.

Tools: PHP, MySQL, JavaScript, AJAX, Dreamweaver, CuteFTP, Apache