Paterno V. Siazon

Mobile #: 630-***-****

E-Mail: actgwz@r.postjobfree.com

Summary of Qualifications

An accomplished Software Engineer specializing in Object Oriented Design and Analysis with extensive experience in the full cycle of the software design process including requirement definition, prototyping, proof of concept, design, interface implementation, testing and maintenance.

More than fifteen years of experience in developing and delivering solutions on the Microsoft technology stack and is a Microsoft Certified Solution Developer (MCSD .NET). Highly skilled with Oriented Architecture, Software Design Patterns, UML diagrams and use cases, N-tier and agile software development, system analysis and effective coding practices.

Able to deliver a project from a concept through deployment. Experienced with capturing and documenting requirements from business users, managing project expectations and scope. Able to communicate effectively with different teams and can write technical documentations of the project.

Technical Skills

Languages

C#, VB .NET, ASP .NET, Visual Basic 6.0, T-SQL, Classic ASP, XML/XSLT, HTML

Databases

MS SQL Server 2012 & 2008, Oracle 8i, MS Access, SQL Lite, FireBird 2.0

Development Tools

Visual Studio 2013 & 2012, SQL Analyzer, Toad, RedGate, SOAP UI,

SQL Server Management Studio, Telerik Controls, JSON .NET, Newtonsoft

Source Control

Team Foundation Server, Tortoise SVN, MS Visual Source Safe

Frameworks

MVC, MVVM, WCF, WPF, Web API 2, SilverLight, .NET Framework 4.0/3.5, LINQ, Entity Framework, Red Gate Software, XML Spy, jQuery, Angular JS,

Service Oriented Architecture, Microservices, Web API, JSON

Certifications

Microsoft Certified Professional (MCP)

Microsoft Certified Application Developer (MCAD .NET)

Microsoft Certified Solution Developer (MCSD .NET)

(https://mcp.microsoft.com/authenticate/validatemcp.aspx)

Transcript ID : 726538

Access Code : DIETRICH

Professional Experience

(1)Bank of America – Chicago, IL March 2015 - Present

Senior Software Engineer – Contractor

Project: Global Information Security – Access Resource Management

Environment: C# 4.0/4.5, ASP .NET MVC, WCF Web Services, Web API 2, SQL Server 2012, jQuery, SOAP UI, Fiddler, JSON, Microservices architecture, JSON .Net, Web API, WCF, Newtonsoft, AngularJS, Bootstrap

Responsibilities:

Responsible for architecting a Proof Of Concept projects consuming Web API from different consumers/client sources.

Designed a request/response mechanism to secure the Web API endpoints from unregistered clients.

Worked on various web projects, cross browser compatibility issues as well as performance tuning initiatives.

Bug fixes for existing websites & website enhancements.

Build response/request logging mechanism to store incoming and outgoing HTTP requests.

Created proof of concepts to convert Soap Web Services to JSON based Web API.

Created a series of restful API of micro-services that are consumed by external systems.

(2)RSA Medical – Naperville, IL July 2009 – Feb 2015

Senior Software Engineer

Project: MedPort, MedRx, Nationwide Drop Ticket, TeleMed and various 3rd party integrations.

Environment: C# 4.0, ASP .NET, MVC, jQuery, SQL Server 2008, SilverLight 4, WPF, Multi-threading, WCF/XML Web Services,Telerik Controls, Visual Studio 2010, SOAPUI, XML/XSLT, Classic ASP, COM+, SCRUM, TFS

Responsibilities:

Responsible for building windows services that retrieves applicant’s prescription histories from Milliman’s IntelliScript.and MedPoint’s Ingenix.

Created and maintained various website portals where clients can retrieve and view applicant’s Rx History and claims reports.

Designed and developed a back end processing system that verifies applicant’s identity and age. This system connects to VERATAD, a 3rd party data vendor that provides both online and real-time Identity Verification, Age Verification and Knowledge Based Authentication Solutions.

Build an EDI system that retrieves health insurance applications and documents from eHealth. The system converts the documents into internal applications, and generate reports our underwriters. It also sends status updates back to eHealth using XML web service.

Build various tools to monitor application activities, correct applicant’s data and generate PDFs. Developed various websites for internal use by underwriters.

Maintains the company’s legacy systems written in Classic ASP. Re-write some of the pages, converted in-line SQL statements into Stored Procedures to boost database performance.

(3)Realtime Solutions Group – Woodridge, IL April 2008 – July 2009

Senior Software Engineer

Project: United Health Care Tele-Sales and eApp Web Application / American Community Mutual Insurance / American Enterprise Underwriter Workbench

Environment : .NET Framework 3.5, C#, ASP .NET, MS SQL Server 2005, IIS 7.0, WCF, SOAP Web

Services, VS2008, Telerik Controls, SOAPUI, Liquid XML, ACCORD, XML/XSLT

Responsibilities :

Spearheaded the development of UHC Tele-Sales application, a web application used by the company’s underwriters to write down short-term and long-term care policy applications. Developed web service consumers that connect to different 3rd party data sources (Ingenix, IntelliScript and Inspro) for premium quotes and health and medical records.

Worked with a team of 5 in the completion of the American Community Underwriter Workbench application. Focus mainly on data provider integrations, worked closely with third-party counterparts to ensure the accuracy of data between document exchanges. Created Windows services to request physician, clinical, lab reports from different data providers. Created WCF services to receive status updates from providers.

Involved in the completion of the American Enterprise e-Application. This web based application is used by American Community Mutual Insurance agents to request a quote and process applications online. Responsible for fine-tuning slow running queries and converted slow running modules to a multi-threaded process.

(3) Zuellig Pharmaceuticals - Manila, Phils Aug 2007 – Jan 2008

Senior Software Engineer

Project: AsiaRX Mobile

The AsiaRx Mobile application is a PDA-based solution combining the current functionalities of POES and PCOM. In addition to these functionalities, new features are included to make it more efficient and useful to users. The target users of this application are the Sales Representatives and the Bill Collectors.

Environment: C#, ASP .NET, MS SQL Server 2005, MS SQL Server 2005 Compact Edition, SSIS, Biztalk 2006, MS Pocket PC, Compact Framework 2.0, RESCO Mobile Toolkit, HP Mobile Devices

Responsibilities:

Developed the Payment Allocation, Data Transmission and Collection modules.

Maintains the AsiaRx Mobile Web Administration application to control the behavior PDA-based Windows CE Mobile application.

Created MS SQL SSIS Packages to move and transform Purchase Orders from PDAs the to web based reporting modules.

Apply software patches and updates both to the mobile and web applications.

Participate in high level meetings with customers and the third party solution providers.

(4) Emerson Network Power - Westerville, Ohio Mar 2006 - Jul 2007

Principal Software Engineer / Architect

Project: Virtual Ntegrity Platform

The Virtual Ntegrity™ Platform is a set of interoperating software applications whose function is to integrate alarms, events, and performance data from a wide variety of equipment types in such a way as to support the delivery of services remotely. The platform is built on open standards for process communication (SOAP) and data representation (XML). It includes layers of abstraction between functional components to allow expansion and improvement of specific functions while limiting the impact of changes to the system as a whole. This is accomplished by establishing standard interfaces between elements defined by XML schemas, and communicating between components using SOAP-based web services

Environment: C#, VB. NET, MS SQL Server 2005, .Net Framework 2.0, Web Services, ASP .NET, NUnit, UML/Visio, OOP, Microsoft Visual Studio 2005, Biztalk 2006, ADO .NET 2.0, SQLXML 3.0, XML /XSLT

.

Responsibilities:

Lead a team of programmers to build the application suite designed for Liebert Corporation, an Emerson Network Power company.

Traveled to Liebert’s Global Services main office in Westerville, Ohio, to participate in a high level design on the architecture of the project. Review and analyze requirements from business analysts.

Wrote detailed design specifications, class diagrams and use cases that will guide the Manila team during the coding phase.

Extensively involved in building the platform’s DataMart, Virtual Ntegrity’s back end storage system.

Solely developed a web service to be used by programmers, encapsulating business rules and complexities of retrieving XML based data stored in the DataMart.

Reports and coordinates with the US counterparts for the updates and patches on the production environment.

(5) Equitable PCI Bank - Manila, Phils May 2005 - Mar 2006

Senior Software Developer / Architect

Project: Human Resources Management Systems

Environment: C#, VB .Net, ASP .Net, ADO .Net, SQL Server 2000, SQL Server Reporting Services, Microsoft Visual C++, UML/Visio, Active Directory, Macromedia Flash MX, Adobe PhotoShop, ERWIN. HRMS is an intranet based IIS application that is use to automate HR operations of the company. It interfaces with the company’s Payroll and Employee Loan and Text Messaging internal systems.

Responsibilities:

Spearheaded the construction of the company’s HRMS (Human Resources Management System), an intranet based application that will be used to manage HR operations of the company.

Serving as the technical lead, designed the architecture and security features of the application.

Designed and developed modules to consume company-wide SQL Reporting web service. Build a module to consume Text Messaging web service that is used to send text messages to the application's administrator whenever a certain unattended long running process encounters an error.

Design and developed a C# window based program that is used to interface with existing company applications, like the company wide existing encryption and authentication programs. Design and build a multi-threaded module to process month-end employee profile updating.

As one of the pioneer in this large project, involved in the design and architecture of the database. Created monthly running SQL Jobs to pull data from different existing company applications including those from Mainframes.

Created large stored procedures to update employee profiles from different data sources.

Build a C++ objects that is used to encrypt employee salaries and other sensitive information such as passwords, network credentials and application parameters that are stored in the registry.

Created most of the web site’s images using Adobe Photoshop and Macromedia Flash MX.

Wrote technical documents describing the encryption algorithm and security features of the application.

Responsible for fine-tuning slow running stored procedures used by different reports.

(6) Accenture - Manila, Phils Jul 2004 - May 2005

Senior Software Engineer

Project: US Employee Giving System

Employee Giving application is an intranet based IIS application where Accenture employees pledged their donations to different charities. This application is caters only US and Canadian employees. It interfaces with the company wide Active Directory and Lotus Notes systems.

Environment: VB. NET, C#, ASP .NET, MS SQL Server 2000, Active Directory, LDAP, ADO .NET,

Flash MX, Fireworks, Action Script, Adobe Photoshop.

Responsibilities:

As one of the Senior Programmer of the team, developed most of the custom objects such as the Data Layer objects and Security related objects use to authenticate usernames and passwords stored in company wide Active Directory.

Build and designed the application’s database. Developed complex SQL stored procedures used to pull data from the Active Directory database.

Coordinated with the LDAP/AD administrators to fast track the authentication mechanism.

Assist in migrating existing charity records from the old application to the newly built applications.

Created most of the web site's graphic images using Adobe Photoshop and Macromedia Flash MX.

Created detailed and general design documents for each of the objects assigned to me.

(7) Georgesons Shareholder Inc. - Manila, Phils Apr 2003 – Jul 2004

Software Engineer III – Employee

Project: Contact Handling and Response Management System (CHARMS)

CHARMS s an application that handles incoming and outgoing calls to be used by the company’s various call center businesses. This automates caller identification, call routing and escalation of calls to different teams.

Environment: Oracle 8i/9i, ASP, VB 6.0, COM+, Adobe PhotoShop, Rational Suite, Toad, DB Artisan, ActiveReports 2.0.

Responsibilities:

As one of the senior member of the team, developed objects that are used to pull caller's data from a CTI (Computer and Telephony Integration) System.

Design the web site's multi-branding features which enable the system to be deployed to the company's different call center offices around the globe.

Build Oracle packages used by the application's complex reports.

(8) Interhealth Technology, LTD. - Manila, Phils Mar 2001 - Apr 2003

Senior Software Engineer

Project: AsiaRx

Environment: MS VB.NET, Active Server Pages, COM+/DCOM, Visual Basic 6.0, Visual C++ 6.0, SQL Server 2000, Ms Biztalk 2000, IIS 5.0, CDONTS/SMTP/POP3, HitOleDB, IBM Client Access, AS400 Navigator, MS Web Application Stress Tool, SQL Server Full Text Indexing.

AsiaRX is an online ordering for pharmaceutical products. Caters primarily to the pharma and medical supply industry and is unique in its regional scope, multilingual capabilities, tight real-time integration with supplier systems. Supports Simplified and Traditional Chinese, Korean and Thai languages.

Responsibilities:

Developed most of the COM+ objects of the site such as the Ordering, Pricing, Supplier, Catalog and Mailing objects.

Travelled to Weston, Florida to participate in a high level design of the project with the third party solution provider company, I-Reality Group.

Designed and developed a program to download/upload records from various IBM AS400/DB2 (supplier) databases from HongKong, Malaysia, Singapore, Taiwan, Korea, Thailand and the Philippines.

Developed a server application that pushes purchase and sales orders from

MS SQL Serve database to different IBM DB2 databases in different countries

using their respective locales. Developed .NET application to receive order files over the wire from different customers who want to integrate with our system. Integrated with MS Biztalk, this program analyzes the order files and computes for the prices and available discounts.

Wrote technical documentations on the pricing and discounting algorithms. Wrote high level design documentations on the architecture and detailed design on the COM objects.

Responsible for fine-tuning slow running stored procedures used by different reports.

Implemented SQL Server Full Text Index to enable full text search feature of the website.

(9 ) Stag Phils, Inc. - Manila, Phils Aug 2000 – Mar 2001

Programmer / Team Lead

Project: Tutuban Shopping Portal

Environment: Visual Basic 6.0, ASP/HTML/Javascript, Windows 2000, IIS, Advanced Server, COM, Crystal Reports, MS SQL Server 7.0, SQL Stored Procedures

Tutuban Shopping Portal is an e-commerce site for Tutuban Shopping Mall. An integrated e-retailing distribution infrastructure anchored on streamlined order processing, integrated service capabilities, and reduced costs.

Responsibilities:

Lead programmer of the team. Spearheaded the designing of both the database and site architecture.

Developed most of the COM objects of the site like Registration, Catalog, Ordering and Email Notification.

Coordinate with the project sponsors for the layout and design of the shopping catalogue.

Responsible for remotely deploying software patches and updates.

Project: E-2-Door (www.e-2-door.com)

e-2-door is the only community in cyberspace that provides consumers a way to consolidate, simplify, and manage all their online purchases through an Internet to door procurement and delivery service. It addresses the distinct procurement needs of both Business-to-Consumer (B2C) and Business-to-Business B2B) markets through its online shopping and sourcing facilities. It does so by leveraging the strengths and industry expertise of its shipping and logistics arm (Orient Freight International Inc.) and maximizing the relationships of its offshore trading and purchasing office.

Responsibilities:

Build and design the User Survey portion where question sets are relative to the user’s demography.

Create complex stored procedures to retrieve user’s demography.

Build COM objects to expose user’s data and save answers to the surveys.

(10) Magsaysay Maritime Corporation - Manila, Phils Feb 2000 - Aug 2000

Programmer / Systems Analyst

Project: Seafarers Recruitment System

Environment: VB 6.0, SQL Server 7.0, Crystal Reports, COM/DCOM, Stored Procedures

Seafarers Recruitment System is an intranet system to automate company’s recruitment system. It is used to handle seafarer’s contracts, embarkation and disembarkation process. Consists of a web based application used for handle new recruits and a form based application used to maintain old records stored in Foxpro data files.

Responsibilities:

As a lead programmer, created major components for the system like database access objects and report generation tools.

Design the user interface of the web application used to process new recruits records.

Involved extensively in redesigning the database schema and the user interface forms.

Create complex stored procedures to generate seafarer’s profile and embarkation history.

(11) Inobbar Technologies Corporation - Manila, Phils Aug 1999 - Feb 2000

Programmer/Systems Analyst

Project: FilGlobal Credit AMI Consumer Loan System

Environment: Visual Basic 6.0, Microsoft SQL Server 7.0, Crystal Reports, Stored Procedures.

FilGlobal Credit AMI Consumer Loan System is client server system to automate loan processing procedures. Modules include billing, registration, and refinancing and report generation.

Responsibilities:

Served as the project team leader of 6 programmers.

Developed most of the core objects of the system which includes registration, re-financing and report generation.

Leads the team in designing the database and user interface.

(12) Fuji Reynolds Fabrication Corp. – Manila, Phils Jun 1998 – Aug 1999

Programmer / Systems Analyst

Project: Implementation of BaaN IV ERP Solution

BaaN is integrated family of client/server applications from Baan. It included manufacturing, distribution, finance, transportation, service, project and features enterprise modeling via its Orgware modules. Earlier versions of the software were named TRITON. It later evolved into BaanERP (later SSA Baan ERP), which was more modular with added components for procurement, order management and warehousing.

Environment: BaaN IV, Informix 7.2, BaaN Orgware, Easy SQL, BaaN Reports

Responsibilities:

Involved in re-engineering the company’s Purchasing, Inventory and Distribution business processes.

Customized BaaN forms, documents and reports as required by the business processes.

Helped in the installation of the ERP.

Wrote users manual for Purchasing and Inventory modules

(13) FarEast Bank and Trust Company – Manila, Phils Jun 1997 - Jan 1998

Programmer/Systems Analyst

Project: Various projects fro Y2K Compliance

Environment: Visual Basic 5, Foxpro 2.6, MS SQL Server 6.5

Responsibilities:

Developed Ledger systems (AP and AR) data retrieving module.

Involved in the completion of CSOC project, a summarized consolidated statements of accounts.

Developed conversion programs that correct and converts data from mainframe systems to SQL Server 6.0 and text file formats.

(14) Corplan Incorporated – Manila, Phils May 1995 - Feb 1997

Programmer/Systems Analyst – Employee

Project: Corplan Accounting and Monitoring Systems

The application is a stand alone application use to monitor projects, accounts and project expenses. It consists of modules that automate the company’s project cost estimation and monitoring operations.

Environment: Visual Basic 4.0 & 3.0, Foxpro 2.5, Novell Netware 3.12, Clipper 5.0, Windows NT 3.5, MacOS

Responsibilities:

Design and develop Accounts Monitoring and Project Monitoring System.

Revised the company’s Cost Estimating and Cross-Media Programming system.

Install the company’s Novell LAN and LocalTalk for Macintosh users.

Education

Adamson University

900 San Marcelino st., Ermita, Manila 1000

Bachelor of Science in Computer Science

Contact this candidate