System Analyst

JUNLENON CERIA

** ********** **., ***********, ** 07621

*******@*****.***?(m) 201-***-****?(o) 845-***-****

TECHNOLOGY SUMMARY:

Web/Client Server/PC - C#, VB.NET, ASP.NET, ADO.NET, Web Services, VB 6.0,

SQL/T-SQL, DHTML/HTML, Javascript, jQuery, Visual Studio

2012/2010/2008/2005, TFS 2010, .Net Framework, Silverlight, Obfuscator, SQL

Server 2008/2005, SSIS/DTS, Oracle, MQ Series/Websphere, Crystal Reports,

Cognos Decision Stream, Cognos Impromptu, XMLSpy, Infragistics

Netadvantage, Windows XP/Vista/7/8, Linux/Unix, Windows Server 2003/2008,

IBM PC & Compatibles, MS Office, Ipad/Ipod, Blackberry, FTP, Hummingbird,

Sharepoint

Mainframe/Mid-range - IBM ES9000, COBOL II, CICS, DB2/SQL, PL/I, VSAM, DB2

Connect,

DB2 Stored Procedures, MDI/Remote Stored Procedures, MQ Series, JCL, SPUFI,

Xpediter, IMS

DB/DC, File Aid for IMS/DB2, HP-Unix, MVS/ESA, DOS VSE/ESA

WORK EXPERIENCE:

SHOPRITE SUPERMARKETS, INC Florida, NY

Sr. Programmer Analyst August 2011 - Present

Served as both Programmer/Analyst and Technical Lead for the specialized

group named Strategic Business Initiatives, which aims at improving

profitability and avoiding potential loss, by monitoring and analyzing

data, identifying errors and trending through online tools/reports that

are built in house and interface with legacy and remote applications.

Designed and developed KPI Dashboard (designed for both iPads and

Desktop) which is a high visibility online application aimed at

monitoring Key Performance Indicators and developed an alerting system to

notify recipients of potential problems and/or business opportunities.

Was involved in developing and implementing an online reporting tool

named New Items Analysis, which is used by the company to monitor new

items that are being sold across the chain and provide loss sales average

if one or more stores sold the new item. This application helps stores

keep track of new items and avoid potential loss because of popular/high

moving items.

Generate adhoc reports and/or Crystal Reports as needed. Optimized SQL

queries to minimize wait times on the front-end. Automated the Coupon

Reconciliation process. Developed data warehouse model to support

dashboard application and consolidate data originating from different

data sources. Served as a Server/Database Administrator on the side and

technical advisor/support for IT Department.

Environment: C#, VB.NET, ASP.NET, ADO.NET, Web Services, AJAX,

Javascript, jQuery, .Net 3.5/4.0/4.5, DHTML/HTML, SQL/T-SQL, Visual

Studio 2012/2010/2008, SQL Server 2008/2005, SSIS/DTS, Windows, Window

Server, IIS, Infragistics NetAdvantage, Crystal Reports, Access, MS

Office, VMWare. FTP, Hummingbird, iPad/iPod, Blackberry

UNITED PARCEL SERVICE, NJ Mahwah, NJ

Sr. Web Developer April 2008 - July

2011

Functioned within a specialized team to establish solutions to monitor

end to end business processes. Designed and developed a real time

dashboard monitoring/alerting web application to detect anomalies on

business processes using multiple charts display of average volume

trending and standard deviation. Developed add on features such us

automatic status changes, color coding, multiple trend lines, adjustable

alert configuration, multiple alert acknowledgements, and drill down

information. Generated reporting tools, adhoc reporting and support

analysis for business analysts to supplement and validate alerts that was

generated by the system. Provided technical support, including

web/database administration, maintenance and enhancements/optimizations

for the application. Certified the application for browser compatibility

with mobile devices such as Ipad, Ipod and Blackberry. Was named as co-

inventor of the monitoring tool for patent application -

http://www.faqs.org/patents/app/201********

Developed and maintained an existing Help Desk application that handles

all online generated tech support tickets being routed within the company

(Tech Cares). Administer enhancements and additional reporting

capabilities to the application that provides the support groups the

information of the effectiveness of each online ticket template and

turnaround time (SLA).

Serve as a technical advisor, performed research and development for new

and emerging technologies that would be beneficial for the group and

mentor junior developers.

Environment: C#, VB.NET, ASP.NET, AJAX, Javascript, jQuery, .Net 2.0/3.5,

DHTML/HTML,

SQL/T-SQL, Visual Studio 2010/2008/2005, Obfuscator, SQL Server

2008/2005, Oracle, MQ Series, IBM Websphere, XML, Web Services, Windows,

Linux/Unix, Infragistics NetAdvantage, XML Spy, Ipad/Ipod, Blackberry,

Sharepoint

CONSOLIDATED EDISON, NY New York,

NY

Sr. Systems Analyst August 2005 -

April 2008

As a Sr. Systems Analyst/Project Lead for HR and Learning Center

applications, was assigned to handle the rewrite of the Learning Center

Portal to be a one stop shop for all training and certification

requirements as required by the Public Service Commission. I designed an

AJAX based, kiosk style front-end that can be accessed from within the

company and remotely. This front-end was designed to interface with

vendor system for seamless access to online training materials. Was

responsible for overseeing the overall design, coding and corporate

standards, SOX compliance, gathering user requirements and meetings.

Administered cost estimate, system reviews and vendor evaluation for the

conversion of paper based exam/test to online testing. Configured server

hosts (Windows 2003 server and ISS 6) and its interfaces to in-house

systems.

Investigated issues on several systems in a timely manner and helped out

on other systems as required by my supervisor. This included (but are not

limited to) database performance tuning, bug fixes, system enhancements,

technical support and system design and analysis. Multitasked user

queries and request. Outfitted and maintained Data Warehouse

Infrastructure.

Sr. Systems Designer January 2005 -

July 2005

Was involved in mainframe systems enhancement using CICS, COBOL and DB2.

Fixed slow running reports by investigating DB2 Access Paths. Investigate

and fixed timing problems on batch jobs. Established FTP process between

web applications and vendors.

Consultant January 2000 - Dec

2004

As a member of the Gas Information System/Emergency Control System team, I

developed new applications and interface programs for work management

system and necessary system enhancement/revisions to Gas Information

System, Outage Systems and Emergency Control System.

Coded, tested and implemented online and batch programs to interface Gas

Inspection System and Emergency Control System with vendor product

utilizing wireless communications and MQ series. Implemented validation and

user interface on web-based mobile display terminal and dispatcher

application.

Spearheaded the first DB2 Connect/Stored Procedure project using VB for the

front-end interface, and designed program templates for use in conversion

of RSP to DB2 Stored Procedures.

Environment: VB.NET, ASP.NET, ADO.NET, VB6, SQL Server 2005/2000,

DTS/SSIS, COBOL II, CICS, DB2/SQL, IMS DB/DC, MQ Series, JCL, FileAid,

SPUFI, XPEDITER, DB2 Connect, Stored Procedures, MDI/RSP, Visual Studio

2005/2003/6.0, HP-Unix, Oracle 8i, HTML, Javascript, MS Access, Crystal

Reports, Cognos DecisionStream, Cognos Impromptu, Erwin, XMLSpy, Telerik

RAD Controls, Intersoft WebUI Studio.Net

WILMINGTON TRUST Wilmington,

DE

Programmer/Analyst (Consultant) October 1997 -

December 1999

As a consultant, I helped developed necessary system enhancements and

revisions for the Global Financial Accounting (GFA). Coded, tested and

implemented batch and online programs to interface with support and enhance

GFA. Also worked on the conversion project that pulls account information

from IMS database and loads data to DB2.

Performed analysis and programming of specific user change requests to

handle new system requirements. Conducted unit and system integration

tests. Resolved production problems both online and batch and responded to

user queries and requests.

Environment: COBOL II, IMS DB/DC, DB2/SQL, Librarian, JCL, FILEAID for

IMS and DB2, SPUFI, XPEDITER.

NYNEX (Off shore project) Makati,

Philippines

Programmer/Analyst January 1997 -

October 1997

As a Programmer/Analyst, provided adaptive and corrective maintenance for

the Billing Order and Support System (BOSS). Gathered user requirements,

analyzed revision impact, coded and tested batch and online programs.

Updated test and production procedures, control cards and JCLs.

Performed 24-hour production support. Resolved PSR's (Production Support

Request) released during the nighttime batch run. Performed quality

control procedures through program, test plan and documentation

walkthroughs.

Environment: COBOL II, VSAM, PL/1, IMS DL/I DB/DC, CICS, Syman,

Endevor, NDM, SMS, ASAP, JOBOOK, File-Aid, MicroFocus COBOL

Workbench.

FGU INSURANCE CORPORATION Makati,

Philippines

Programmer/Analyst August 1994 -

January 1997

Assigned to handle the development and integration of the new Fire

Endorsement System to the existing Fire System. Designed and coded the

extraction of endorsement transactions and uploaded them to the mainframe

for batch processing. Included an additional segment in the HIDAM database

to hold the endorsement transactions. Revised all programs impacted by the

new endorsement segment in the database. Provided documentation manuals,

user/operator training and assistance.

Performed production support for the entire product line (Fire, Motor,

Personal Accident and Casualty) across all district offices including the

head office. The entire system uses Clipper 5.2 as the front end, COBOL,

CICS, DB2, VSAM, HIDAM, IMS DB/DC, DL/I, MicroFocus COBOL Workbench on the

back-end.

Participated in the conceptualization and detailed design of the Basic

Employee Information System (BEIS) which maintains all pertinent employee

information. Responsibilities included development of system design flow,

file layouts, and creation of program specifications. Created a document

generation program that printed computerized TIN and SSS certification.

Developed and implemented the LogBox machine which uses laser technology

to swipe and store the Daily Time Record of all employees. Maintained and

downloaded all data from the Logbox machine and processed them as an

input to Basic Employee Information System. Generated reports for Daily

Time Record for cashiering and performance appraisal using Clipper 5.2

and COBOL.

BANK OF COMMERCE Makati,

Philippines

Internship July 1993 - August

1994

Was assigned the task of handling the PilTel Consolidation. This data

consolidation project involves integration of data from all branches to be

processed at the main branch. Created several report generation programs

using CLIPPER and COBOL. Handled back-up/restore of data from all branches

processed.

EDUCATION:

Bachelor of Science in Computer Science, March 1994

Adamson University, Manila, Philippines

NCEE - GSA Percentile: 702 - 98%

PERSONAL INTERESTS:

Tennis, Mountain/Road Biking, Bowling, Basketball, Baseball, Computer

DIY, Home DIY, Amateur Photography, Guitars and Drums.

Contact this candidate