JOY LANDICHO

**** ***** *** ****** ( Fairfield, Iowa 52557

510-***-**** ( acgge6@r.postjobfree.com (

http://www.linkedin.com/in/landichojkd

SQL DATABASE DEVELOPER

Highly motivated systems analyst and programmer with 7 years of experience

in application development and data management. Exceptional SQL, SSIS,

SSRS, C#.Net, VB.Net and ASP.Net skills. Proven abilities in analyzing,

designing and supporting applications and computer information systems.

Strong development background in stored procedures and data manipulation

queries. Well versed in database design, data integration and query

optimization. Experience developing and implementing applications through

the entire software development life cycle. Adept at delivering quality end-

user support and ensuring successful outcomes.

CORE COMPETENCIES / TECHNICAL SKILLS

System Analysis and Design ( Full Software Development Lifecycle ( Software

Engineering

Database Analysis & Design ( Data Management ( Data Manipulation ( Business

Intelligence ( Data Mining

Module Integration ( Troubleshooting & Debugging ( Testing & Analysis ( End-

User Support

Problem Solving ( Goal-Oriented ( Effective Communication ( Adaptability (

Teamwork

Databases: SQL Server 2000/2005/2008/2012, Oracle 10g, IBM DB2, MS Access

Business Intelligence: DTS, Integration Services (SSIS), SPSS Modeler

Reports: Reporting Services (SSRS), Crystal Report, BO Enterprise

Languages: VB.Net, C#.Net, VB6, T-SQL, PL/SQL

Web: ASP.Net, Web Services, HTML 5.0, Ajax, XML, JavaScript, CSS

Tools: Visual Studio, Management Studio, Toad, HP ALM, PVCS

Framework: .Net Framework 1.1, 2.0, 3.5, 4.0

Platforms: Windows

PROFESSIONAL EXPERIENCE

CAREER NOTE: Completed on-campus studies and currently taking distance

education courses to complete a Master's Degree in Computer Science

(Available for full-time, W-2 employment).

SUN LIFE OF CANADA (PHILIPPINES), INC., Manila, Philippines ( 2012-2014

Leading global financial services institution.

Analyst Programmer

Collaborated on software development and production support. Created design

specifications by evaluating and transforming business requirements.

Oversaw programming, including development, enhancement, maintenance,

testing, and documentation. Partnered with Hong Kong IT team in delivering

Level-2 application-level support.

Key Projects Include:

. Sunsurf Application: Lead developer on C#.Net web application used by

agents and brokers with complex queries and stored procedures on SQL

database to view, query and print insurer, investors, and client details.

. Integrated Payment & Collection (IPAC): Developer and support specialist

for intranet system used in inputting premium payments. Enabled payment

data upload through manual input or batch upload.

. ODS / CustDB: Designed databases serving as repository for data required

in producing reports of data imported from external applications and

wrote stored procedures and complex queries for manipulating data.

. Additional projects include development and support roles for printing

solutions, imaging systems, and database design; details on request.

Technical Skills: Languages: VB.Net, C#.Net, VB6; Web: ASP.Net; Databases:

SQL Server, IBM DB2; Tools: Crystal Report, HP ALM; Platforms: Windows

PHILIPPINE NATIONAL BANK, Manila, Philippines ( 2009-2012

Philippine-based banking organization.

Systems Analyst / Programmer

Key contributor on all assigned projects. Collaborated on full software

development lifecycle process. Conducted testing, identified issues,

debugged code, and created effective solutions. Developed complex

applications, designed modules, and integrated systems to form seamless,

high quality outcomes.

JOY LANDICHO ( Page 2 510-***-**** ( acgge6@r.postjobfree.com

PHILIPPINE NATIONAL BANK, Systems Analyst / Programmer, continued:

Key Projects Include:

. KBI Archiving Project: Created 34 SSIS packages to extract & convert 10

years KBI (mainframe) archived financial data to SQL Server then validate

using stored procedures based on the 34 different file formats.

. KBI Archive Retrieval System: Developed new ASP.Net application for

retrieving requested KBI archives data from SQL server 2005 database.

Enabled customer account statement computing and report generation.

. ADA Online: Built innovative VB.Net application and SQL database for

processing real-time account debits and credits, with report delivered to

client.

. Transaction Alert Program: Designed VB.Net 2005 program generating

selected account transactions from Oracle 10g database. Used ASP.Net Web

Service and sent email transaction detail alert to specified groups.

. Additional projects include RJSin-RJSout Monitoring Program, overseas

reporting, online transaction / inquiry applications, among numerous

others; details on request.

Technical Skills: Languages: VB.Net, C#.Net; Web: ASP.Net, Web Services;

Databases: SQL Server, Oracle 10g; Tools: Toad, Crystal Reports, BO

Enterprise, Reporting Services; Platforms: Windows

SOFTWARE LABORATORIES, INC., Manila, Philippines ( 2007-2009

Information technology services company.

Outsource Programmer

Delivered program development services for major client: Philippine

National Bank. Performed complex software programming. Designed new

programs and modernized existing applications. Performed System Integration

Testing (SIT) and User Acceptance Testing (UAT). Provided post-delivery end-

user and application support.

Key Projects Include:

. Automatic Debit Arrangement (ADA): Created program enabling PNB account

depositors to settle balances. Employed ASP.Net application and VB.Net.

Batch processed transactions from SQL Server database.

. Electronic Payment System (ePay): Developed Windows-based program for

bulk payment processing utilizing VB.NET and SQL Server database.

Generated daily / monthly reports using Crystal Report with Excel.

. SSS Pension: Designed SQL DTS Package to facilitate verify SSS Account

number digit validation on pension file. Generated report for identifying

rejected pension credits from invalid account number per branch.

. Additional projects include electronic tax payments application, Auto-

Debit Arrangement for Loans, and eCollect matching program, among others;

details on request.

Technical Skills: Languages: VB.Net, C#.Net; Web: ASP.Net, Web Services;

Databases: SQL Server, Oracle 10g; Tools: Toad, Crystal Reports, BO

Enterprise, Reporting Services; Platforms: Windows

ACADEMIC PROJECTS

Projects completed at STI College include:

. Computerized Attendance & Monitoring Internet Control System: Lead

developer on 4 member team designing application for recording and

tracking student internet usage within computer laboratory. Oversaw

module integration into a single seamless application using VB.Net,

Crystal Report, and MS Access.

EDUCATION

Master of Science in Computer Science, Maharishi University of Management,

Fairfield, Iowa

In progress via distance education courses, expected completion: 12/2016

Key Courses:

Modern Programming Practices ( Business Intelligence & Data Mining ( DBMS

Data Management Systems ( Algorithms ( Professional C++

Bachelor of Science in Information Technology, STI College, Batangas City,

Philippines

PROFESSIONAL MEMBERSHIPS

Philippine SQL Server User Group (PHISUG) ( Philippine .NET User Group

(PHINUG)

Contact this candidate