Software Developer

SUMMARY ** years of extensive work experience in business analysis, systems design, programming, testing, system management and operational support. Hold a Bachelor Degree in Information and Computer Science. Proficiency account in C#, ASP.NET, VB.NET, WSDL, Web Service, XML for Web Development Applications and carried out responsibilities in Database Design, Schema and Programming in SQL Server.

.NET Framework C#.NET, VB.NET, ASP.NET, ADO.NET, Web Services, WSDL, SOAP 1.1, COM/COM+

Technologies: Interoperability, Window Forms, ASP.NET AJAX, LINQ, Windows DNA, JavaScript, JQuery, TFS Framework, Visual Studio 2005/2008/2010, CodeSmith

RDBMS: SQL Server 2000/7.0/2005/2008/Express/MSDE, Oracle 8i, MS Access

Reporting: Crystal Reports, SQL Server Reporting Services (SSRS), Cognos Powerplay, Impromptu, MicroStrategy

Other Tools / Visual Basic 6.0, ASP, COM+, COM, DCOM, XML, XSLT, VBScript, VBA, JavaScript,

Technologies: CSS, DHTML, Visual Source Safe, Microsoft Visio, Debug View, Progress v.6, Client Access/400 for Windows 95, Microsoft Office

Operating Systems: Windows XP/ 2000/NT/98/95/Vista

EXPERIENCE

08/11 – present Project: AllSector Technology Group, New York City

Software Developer

• Sendtrac Administration Case Management System - web-based portal, designed to provide workflow processes for purchasing, facilitate, human resources and more.

Modify web pages (Credentials, Employment Position, Job Description, Inbox) by replacing Ajax controls using knockout JS (MVVM Pattern) and Web service. Use Entity Framework context to store and update tables and stored procedures, LINQ to Entities in joining queries.

Environment: .NET Framework 4, VB.Net, Knockout JS (MVVM Pattern), JQuery, SQL Server, Visual Studio 2010,LINQ, Entity Framework

08/10 – 08/11 Project: BANK OF AMERICA (Merrill Lynch), Jersey City

C#/ SQL Developer

• Solve production issues and continuous website development of the following market risk workflow systems:

New Product Review (NPR): This workflow system and database application consolidates review and approval procedures per bank regulatory requirements. Key functionalities of NPR include tracking of the NPR process, external reporting capabilities, and role-based security.

The Model Workflow Too (MWT)l: Introduced to address several regulatory and internal audit findings in the model validation process. MWT helps to increase transparency in model documentation, prioritize models in the pipeline, enhance release controls and provide customized search and reporting capabilities to the business.

The Approved Product List: (APL: A new initiative in 2010 Q4. At its core, APL houses all products in Global Markets that are approved and used by front office traders. Key features of APL include import from Excel, export to Excel, dynamic search and access controls based on line of business.

• Developed the applications in a multi-layer architecture in C# in ASP.NET and .NET Framework 3.5. All user interfaces are in the Presentation Layer. Use Master Pages and Master Detail Pages, GridView and Repeater Controls for data results, AJAX Controls and User Controls to reuse existing user interface elements and codes. Generic classes for data retrieval, validation and posting in Business Logic Layer and other objects are deployed as individual web services. Uses customized classes to connect to heterogeneous data sources wherein only entity classes are allowed to communicate with the database to provide data security in the Data Access Layer. Uses Façade Layer for the contact point between presentation layer and business logic layer so presentation layer will not directly access the business entity.

• Optimized Search and Report Tool using ProxyLists to eliminate database round trips and retrieve data rapidly without burden to the users. Store all email notifications in XML database triggered by stored procedure in SQL Server to send email Alerts to the recipients.

• Responsible for the Product Demos, Coding, Releases, Documentation and Troubleshooting

Environment: C#, .NET Framework 2.5/3.5, ADO.NET, SQL Server 2005/2008, LINQ

Javascript, JQuery, WebServices, SOAP, XML, HTML, AJAX Control, TFS Framework, Codesmith, Visual Studio 2005/2008/2010

02/08 – 6/10 BDC VIRTIFY INC., CA

Senior Software Engineer

• Worked in a web-based application system, I.R.I.S. International Regulatory Information System Project. It records precisely how and under which circumstances a product or medicine has been made. Tracks regulatory filing and change assessment with correspondence to various governmental agencies for GENZYME client. It guarantees production process is carried out in an accurately prescribed and controlled way documents by approval and sign-off in different officials before it reached an official status.

• Effectively design and properly document inter-class/module interfaces using the multi-layer architecture approach. In the presentation layer, user controls are introduced for code reusability. Telerik RadControls such as RadGrid to display data results in a Master and Details gridview. RadWindowManager for the Executive Dashboards and quick links to the users. Mix the user interface with AJAXControls and JavaScripts functions to eliminate overhead of sending back the page to the server. User Controls are used for the following entities:header, pagination, sitemaps, buttonsets, CMCWorkflow, Commitment, Regulatory Filing and AdProm Concepts. Applies the OOP Principle for Business Logic Layer for each entity objects. Data Access Layer to communicate solely to the database and thus provide data security.

• Developed some functionalities in CMCWorkflow that are encapsulated in WebServices.

• Normalize database tables and stored procedures for the Advance Query Builder in the Search Page

• Productively synthesize effective technical solutions to problems encountered in a specific project

• Mentor and guide Junior Engineers

• Provide accurate and complete task estimation of the project

• Fix defects, diagnose problems involving component code

Environment: C#, .NET Framework, ADO.NET, COM Interop, VBScript, SQL Server Express, SQL Server Reporting Services (SSRS) 2005/2008, CSS, Visual Studio 2005/2008, HTML, WebService, SOAP, XML

02/16/06 – 01/01/08 NXP SEMICONDUCTOR (formerly Philips Semiconductor), Philippines

Software Deveoper - I.T. Consultant

• Responsible for the entire software development life cycle for various projects from system requirements, business analysis, design, development and testing, end-user training, system management and operational support.

• Developed a web-based application workflow tool and electronic specs for Total Quality Management(TQM) Team and Internal Quality Department. Build a web service to publish employee information and QA documents.

• Go for paperless Online Request Approval System (O.R.A.S.) to manage hardware, software, account shared resource, telecommunications and I.T. Accountability.

• Developed On-line Text Messaging Application for Support Engineers via Internet

• Developed Intranet Applications to remotely reserve a conference room (Conference Booking System)

Environment: C#, .NET Framework, ASP.NET, ADO.NET, VB.NET, Ajax, Classic ASP, CSS, JavaScript, Oracle, Crystal Report, Visual Studio 2005

12/01/02 – 03/31/05 PHILIP MORRIS INC., Philippines

MIS Consultant

• Use Visual Basic and OPC Siemens PLC to track each bin status, blend name used, NET, Gross, Tare and Lot Number of the machine and assign bin number to the storage area. The Bin Management System dumps data to Microsoft Access. Write a scheduled program to download data from MS Access to SQL Server.

• Gather requirements and develop a tool called PSS-Paradigm Interface that consolidates data collected from the primary and secondary production. Use Visual Basic and SQL Server to provide the Production and Consumption Report and Work-In-Progress on a weekly basis. Use the Data Transformation Services (DTS) to download data from SAP in textfile format and upload to the SQL Server. Integrate drill-down report in Crystal Report 8.5.

• Create a Web-based Report using WebChart in ASP called Downtime Analysis Report. It computes the duration of the downtime occurred per machine and category in Cigarette Manufacturing Production Floor.

• For HR Related projects, developed the SIPASS-ERIC Interface System using VB and SQL Server as a timekeeping system that automatically computes the overtime, work hours rendered and validation of IN/OUT entry of an employee. Along with this is the HR Time Attendance and Payroll Report which provides a drill-down of the employee’s posted and unposted overtime and leaves.

• Compliance with the SDLC

Environment: Visual Basic 6.0, VB.NET, Classic ASP, ASP.NET, SQL Server 2000, MS Access, Crystal Report, VBScript, HTML,CSS, WebChart

11/16/96 – 12/09/02 AMKOR TECHNOLOGY, Philippines

System Analyst/Programer

General Electronic Die Release Order System:

Provides solutions to improve the cycle time of die-release transactions and automate transaction for all Amkor's Die-Banking customers.

• Built COM Components using Visual Basic 6.0

• Developed OOP Business Logic Layer Module hosted in MTS Server and retrieve/saved data from SQL Database using the Middle-Tier Layer

• Created scripts of Database Schema, Stored Procedures, Views, Back-up in SQL Server 7.0

• Built and deployed ActiveX Document DLLs using Visual Basic in providing a reporting tool for the customers over the web

Electronic Manpower System / ATPNet Site:

Provides on-line solution for HR to update the Personnel System and at the same time reduce cycle time in generating Headcount, Team Member Roster and Demography.

• Developed data pulling program in SQL Server 7.0/8.0 using Data Transformation Services and use Linked Server to read data from AS400 and Paradox. The SQL Script and VBScript consolidate all the data on a scheduled task to SQL Server Tables.

• Built COM Components using Visual Basic and Developed ASP pages with VBScript

• Utilized DHTML and JavaScript extensively, with the Cascading Style Sheets specification used to control the appearance of the site.

Oven Cell Controller System:

Monitors the heat temperature profile and acts as central point of control on sending and reading oven parameter settings to the oven controller based from the lot transaction downloaded from the MESA System.

• Developed an Object-based application in Visual Basic 6.0 Environment. Reads data from the oven cell controller using PLC Controller connectivity and use COM, Active X and OPC to write and send the parameter settings

Electronic Invoicing System:

Captures AS/4400 generated text-based Japanese invoices and transmits to customers thru Lotus Notes Email.

• Responsible for designing, building and deploying Remote Components using DCOM in the form of Active X Executables in Visual Basic

• Generates TPT Computation Report using Seagate Crystal Report

• Developed VB code that calls Word and Excel Object Library and Export and saved file in PDF format.

Knowledgebase System, Spare Parts Budget System and Management of Tools and Spare Parts System:

• Utilized DAO/ADO object Libraries inside VB classes to access data.

• Database Access System which is the compilation of engineer's skills and expertise in troubleshooting machine. Monitors and controls expenses of each spare part used and tracks the items purchased. Created an OOP module of the inventory, usage and consumption.

• Created a time-based system using the SQL Server Scheduled Tasks to download data from AS/400 via Client Access/400 for Windows 95 and upload to SQL Server 7.0.

• Built On-time delivery, Assembly and Test Report using Cognos Powerplay and Impromptu

Environment: VB 6.0, DCOM, ActiveX Documents ASP, SQL Server 7.0/8.0/2000, MS Access, Cognos, Powerplay and Impromptu, HTML, Client-Access/400 for Windows 95

EDUCATION Bachelor of Science in Information and Computer Science

Academic Excellence

St. Paul University, Philippines, 1993

Contact this candidate