Developer Analyst

RESUME OF

EMMANUEL G. DIMALIBOT

PROFESSIONAL PROFILE

Emmanuel has over Twenty (23+) years of experience in Information Technology with a high level of competency in system analysis, design, development and deployment. Highlights include: (7+) Seven years in AS400/Synon (Cool 2/E), (10+) Ten years in AS400 RPG/RPGLE/SQLRPGLE/RPG-XML/CL/CLLE) programming, (6) Six years in client server application using Visual Basic and SQL Server. He is proficient in Help File, SQL scripts, views, trigger, and stored procedures, plus strong programming capabilities in Visual Basic 5.0 & 6.0, Visual FoxPro, PL/SQL, and TSQL. He is also skilled in Crystal Reports, SQL Server 2000 Reporting Services, and with 2 years of teaching experience in computer schools. He has six (6) months development experience in VB.Net and SQL Server 2000 Reporting Services. Additionally competent in Business Objects 6.1, specifically in Universe Design/Development, and Reporting Writing.

With high knowledge and proficiency in SQL Programming.

SPECIALIZED TRAININGS

Synon 2/E(Advance)

RCG IT Philippines, Inc.

June 22, 2005 to July 7, 2005

Synon 2/E

RCG IT Philippines, Inc.

November 17, 2004 to December 17, 2004

Business Objects 6.1

RCG IT Philippines, Inc.

December 16 to 19, 2003

TECHNICAL SKILLS

Operating Systems Windows 95/98/NT/2000/XP/7, MS DOS, OS/400.

Database technologies MS SQL Server 6.5, 7.0 & 2000, MS Access 97/2000, Oracle 8, dBase III+, FoxPro, Clipper, AS/400.

Programming Languages VB.Net(XML transformation, XSLT), Visual Basic 5.0 & 6.0, Visual Fox-pro, Visual C++, C-Language, Clipper 5.2, Fox-pro for DOS, PL/SQL, Pascal, dBase III+, Synon 2/E, RPG/RPGLE/SQLRPGLE/CL/CLLE/POI(HSSF), RPG-XML

Application Development Tools Business Objects 6.1, SQL Server 2000 Reporting Services(SQR), Crystal Reports 7.0, 8.0 & 9.0, Microsoft SQL Server Query Analyzer, DBArtisan 4.2 & 5.4, MS Office (Word, Excel and PowerPoint), Microsoft Visual SourceSafe and Help File.

EMPLOYMENT HISTORY

RCG INFORMATION TECHNOLOGY INC. Jan 2014 TO PRESENT

Team Lead/Senior Analyst Programmer

PharMerica

RPGLE/CLLE/SQLLE Developer

Working as production Support.

RCG INFORMATION TECHNOLOGY INC. Jan 2014 TO Feb 2018

Team Lead/Senior Analyst Programmer

PharMerica

RPGLE/CLLE/SQLLE Developer

As onshore developer, I created a technical detail design for PVT In SAP Project.

As onshore developer, I developed a recovery mechanism in case of DDM failure from Site into CORP.

Also develop a recovery mechanism in case of failure in sending a flat file in SAP Sever.

As offshore Lead Developer, I created a technical design for FFS In SAP project.

As offshore Lead Developer, I developed the FFS Daily Transaction and Customer Master extract in Site Level.

And using a DDM file, Customer Master and Daily Transaction were consolidated in CORP by saving it in a flat file and before sending it in SAP Server.

Also involved in the development of CDDM (Controlled Drugs Dispensing Maintenance) project. As a programmer, I developed a maintenance program for Controlled Drugs Dispensing. Also developed a DDM (Distributed Data Management) program using CLLE for the distribution of corporate files into the pharmacies.

I’m also involved in the development of FFS Facility Invoice Redesign Project(FIRD). As offshore lead/programmer, I created a Technical Detail Design based on the functional requirement provided by Pharmerica for FFS Facility Invoice project.

Engages in the revision of the PharMerica Billing and Claim Adjudication system in compliance with the new HIPAA Regulatory requirements. Performs analysis, database design, coding, and unit testing of system enhancements using RPG/400, SQLRPGLE, RPGFREE, RPG/ILE AND CL. Completes analysis and resolution of production problems through program fixes and/or other work-around solutions/ recommendations.

Also takes in Census Management Application using RPG-XML (ABI Phase I & II). Knowledgeable in creating WSDL, proficient in creating module and service program.

CANON BUSINESS PROCESS SERVICES, INC. 09/12 TO 01/14

Senior Analyst Programmer (AS400)

Supported CANON user’s for request like creating new report, program bug fixing, investigation and program enhancement. Performed analysis, database design, coding and unit testing. Used RPGLE, SQLRPGLE and CLLE to do the programming. Developed reports in excel using AS400 RPG-POI (HSSF).

Technologies Used:

RPGLE, SQLRPGLE, CLLE, AS400 RPG-POI (HSSF)

RCG INFORMATION TECHNOLOGY INC. 06/02 TO 09/12

Senior Analyst Programmer

PharMerica 08/11 to 09/12

Senior Analyst Programmer

Involved in the revision of the PharMerica Billing and Claim Adjudication system in compliance with the new HIPAA Regulatory requirements. Analysis, database design, coding, and unit testing of system enhancements using RPG/400, SQLRPGLE, RPGFREE, RPG/ILE AND CL. Analysis and resolution of production problems through program fixes and/or other work-around solutions/ recommendations.

Also involved in Census Management Application using RPG-XML (Phase I & II). Knowledgeable in creating WSDL, proficient in creating module and service program.

Walgreens 01/07 to 07/11

MSAM - Automated Item System (AIS) Project

Technical Lead Analyst / Developer

AIS is a Retail and Distribution System designed to automate the process in purchasing, distribution, and maintenance of goods that are sold in over 5000 Walgreens stores across all states in the USA. The goods consist of almost all products used for different purposes including Rx items.

Offshore – Synon Developer 06/07 to 07/11

Analyzed the requirement of the system and prepared technical requirement specifications. Also prepared Micro Specification Document. Performed coding and unit testing for the following projects:

Walgreens

FNI/CIC (Finish New Item/Catalog Information Confirmation)

Part of AIS FNI/WCM enhancement team that makes analysis based on BFRS created by onshore Team. From the BFRS a structured TRS was conceptualize and submitted to On-shore for their review and final comment. Micro Designs was created based on the TRS, the micro designs will be used in the program revision and development. Program development was done using Synon 2/E and Control Language (CL) as the programming tool for the said project. Assist QA team during the system testing and regression testing before it was released to the onshore team for their User Acceptance Testing (UAT).

Walgreens

AIS Customs Compliance Enhancement

Customs Compliance Enhancement project covers the following: ensuring that item information, including the factory, is complete before an item may be submitted for setup or update; and providing an easy identification of changes to existing import items for Customs Compliance review and approval. Programs were revised using Synon and CL programs.

Walgreens

AIS Assortment and Deal

Assortment and Deal project focuses on providing domestic vendors the capability to setup and update assortment or deal items via AIS (Web).

Requirements that have not been considered during (or a deviation from) the implementation of IOS Phase I & II on the creation of offer sheet for imports assortment or deal items will also be in scope. Also in scope is the assignment of WIC and approval of item attribute changes by the Category Manager via AIS Web. Modifications related to the Precision and Scale Enhancement will be considered in the Component Details section. Programs were revised using Synon and CL programs.

Walgreens

AIS Precision and Scales

This Precision and Scale project intends to synchronize the field definitions (specifically the precision and scale) of item attributes which includes dimension, volume, and price/cost fields. This effort aims to address data inconsistencies between AIS and Item as a result of varying implementation approaches (round up/off, truncate) between these systems. In addition, the project aims to implement changes in AIS & Item with the least disruptions to the other downstream applications that utilize the affected fields/files. Programs were revised using Synon and CL programs.

Walgreens

AIS DC Cost Change Management

Provided CPI (Central Pricing Initiative; the group responsible for retail price modeling) group the List and Invoice cost change, and current Departmental cost information submitted by import and domestic vendors on a daily basis. Created programs that will be used in AIS online screen. The program validates cost changes submitted either via web or EDI. Errors will be detected when you submit duplicate cost changes based on WIC, cost and effective date combination. Programs were done in Synon and CL programs.

Walgreens

AIS Import Offer Sheet Phase II

IOS Phase II is the continuation of Phase I where most of the programs revised where done in Synon programs. The AIS team (AS400) have done new programs as well as modified some programs. There are some CL programs created and revised too.

After the initial programming, helped in the testing of the new and revised program. Also helped in the execution of test scripts given by the QA team. After the execution, defects were gathered and started on correcting those reported program bugs. Once all the bugs have been fixed the whole module was turned over to the onshore team for the final UAT and eventually deployment to the production box.

Onsite Technical Lead/Analyst 01/07 to 06/07

(Deerfield, IL, USA)

Walgreens

AIS

Analyzed the requirement of the system and prepared technical requirement specifications for the following projects:

ADC/ITX (Anderson DC and Item File expansion)

VCI (Vendor Contact Information Enhancement)

ALLWH (All Warehouse)

FNI/CIC (Finish New Item/Catalog Information Confirmation)

WIM 4.0

Technologies used:

AS400, Synon 2E, COBOL

Walgreens 12/04 to 01/07

MSAM -Item Project

Technical Lead Analyst / Developer

The project involves development and maintenance of programs under the Merchandise Systems Application Maintenance (MSAM) using Synon/Cool2E for Walgreens.

Analyzed the requirement of the system/program, prepared Micro Specification Document if there is a request from the client for program development, enhancement, modification and error fixing. Was responsible for the Code Review and System Testing. Also performed coding, unit testing and test plan.

Technologies used:

AS400, Synon 2E

Technologies used:

VB6 as Front-end and SQL Server 2000 as Back-end. And for the reporting tools we used Crystal Reports 9.0

Global Santa Fe (Houston, TX) 05/04 to 10/04

Operation Management System (OMS) Project

Onsite Reports Developer/Programmer

Created operational reports by making Stored Procedures, Views, and User Defined Functions. Used SQL Server 2000 Reporting Services to do layout of the reports. Did a Kickoff screen for the operational reports using VB.Net. Also prepared the test cases and string test for the reports.

Technologies used:

VB.Net as Front-end and SQL Server 2000 as Back-end, SQL Server 2000 Reporting Services as reporting tool

American International Underwriters (AIU) 06/02 to 04/04

Adjuster/Examiner General Information System II (AEGIS2 Insurance System)

Adjuster/Examiner General Information System II (Extended Warranty)

Systems Analyst/Programmer

The Adjuster/ Examiner General Information System (A/EGIS II) is the claims processing component of the Strategic Suite of Systems, also known as S3. It is a PC-Based system using a Windows application that operates on a LAN (Local Area Network) and serves as a front-end data capture mechanism to feed claim information to existing corporate back-end systems. It is designed to support day-to-day decision making activities and functions inherent in a claims operation.

The main function of A/EGIS II are: creating and maintaining claims/features, suspended claims, payment transactions, reserve transactions, recovery, batch cheques, policy information, diary and reports.

Worked as a production support Analyst/Programmer for the said project assigned to handle the following countries’ requirements: Australia, Indonesia, Taiwan, Philippines, Thailand and Malaysia. Main responsibilities in the said position included fixing of errors reported by the user(s), making enhancements to the system and preparing the MIS reports.

Technologies used:

Visual Basic 5.0 as Front-End, SQL Server 7.0 as Back-End and Crystal Report 8.0 as reporting tool

WORLD OF INFORMATION AND TECHNOLOGY 01/01 TO 01/02

CITIBANK N.A. SINGAPORE

Systems Analyst/Programmer

Telemarketing Prospects System

Telemarketing Prospects System is about uploading list of customer/applicant written in text file (.txt) into SQL Server Database.

Distributed the uploaded file to the Telemarketing Staff. Routed open cases from one Telemarketing staff to another. Monitored the progress status of customer. Extracted customers accepting the product of Citibank and submitted to AMU for processing. Generated the MIS Reports. Created a Functional Specification and PC User Manual of the system to completely finish the project.

Technologies used:

Visual Basic 6.0 as Front-End, SQL Server 6.5 as Back-End and Crystal Report 7.0 as reporting tool

Credit Control Management System (CCMS)

CCMS is about uploading Legal Bills collected by the lawyers from inconsistent customers for paying credit card bills written in text file (.txt) into the database (SQL Server 6.5).

Extracted and checked all bills account numbers if existing by connecting into the Host (e.g. CARDPAC, SYSTEMATIC Software). Posted Bills in the Systematic and CardPac system. Authorized all posting of data and generate MIS Report. Created a Functional Specification and PC User Manual of the System to completely finish the project.

Technologies used:

Visual Basic 6.0 as Front-End, SQL Server as Back-End and Crystal Report 7.0 as reporting tool

Reconciliation Automation System (RAS)

Uploaded Sales from different cards written in text file (.txt) by getting from the Host (e.g. CARDPAC, SYSTEMATIC Software). Uploaded some reports from COLD System (Report Generating System). Generate MIS Report and Sales Volume Report of Different Cards (e.g. Cathy Pacific, Clear Visa etc.) into excel worksheet.

Technologies Used:

Visual Basic as Front-End, SQL Server as Back-End and Crystal Report as reporting tool

INFORMATICS COMPUTER INSTITUTE 02/99 TO 12/00

Lecturer/Programmer

Taught subjects for short term courses like Visual Basic Module 1 & II, Visual FoxPro Module I & II, MS Word, Excel, PowerPoint and MS Access). Subjects taught for 2 year-course include Introduction to Computers, Pascal, C-Language, FoxPro, Visual FoxPro and Flowcharting.

JEOUNG KUEN LEE 01/00 TO 12/00

Part-Time Private Tutor

Subjects taught include Visual Basic and Microsoft Windows Applications.

INTERFACE COMPUTER COLLEGE 06/97 TO 02/99

Lecturer

Taught various subjects for a degree program in computer science. These include the following: Introduction to Computers, Pascal, C-Language, FoxBASE and Clipper. Also acted as lecturer for the 6- month computer course (subjects covered were Introduction to Computers, Pascal, C-Language, FoxBASE and Clipper).

FREELANCE PROGRAMMING PROJECTS 1997 TO 1999

Jewelry Control System

Developed an Accounts Receivable and Payable including Inventory System for a Jewelry Store. Application development tools used were Visual Basic for the Front-End and MS Access for the Back-End.

Inventory Control System

Designed, coded and deployed an Inventory System for a pharmaceutical store. Application development tools used were Visual Basic for the Front-End and MS Access for the Back-End.

Software for Kids (Math Software)

Developed a tutorial application on mathematics for children, which included interactions with users. Application development tools used were Visual Basic for the Front-End and MS Access for the Back-End.

EDUCATION

Bachelor of Science in Computer Science, 1997

Adamson University, Manila, Philippines

Contact Number: (PHI) +639*********

Email: ***********@*****.***

Contact this candidate