Project Manager Customer Service

Marcelo Blumetti

Home 973-***-****

Mobil 973-***-****

***************@*******.***

EXPERIENCE SUMMARY

A data processing professional with extensive experience in business

analysis, application design, specifications, data formatting, all level of

testing, development of automated batch/online processes, conversion

projects and production support. Industry experience: Retail, Finance,

Banking, Telecommunications.

TECHNICAL SKILLS

Hardware: IBM System 9000, 30xx, 43xx, 370, 360.

Software: COBOL, COBOLII, CA-7, OMEGAMON II, NDM, FTP, SFTP/PGP,

RSA/Encryption, VSAM, DB2/SQL, TMON, MQSeries, STORED PROCEDURES, IDCAMS,

ISAM, ICCF, CICS Commands, VM/CMS, VOLLIE, MVS/TSO/ISPF, INTERTEST,

PLATINUM, DOS/MVS, DOS/VSE/SP, XPEDITER, IBM CPCS, VISIO 4.0, MS PROJECT,

CHANGEMAN, ENDEVOR, LIBRARIAN, EASYTRIEVE, FILE-AID, ABEND-AID, MICROSOFT

EXCEL, WORD, ACCESS, POWERPOINT, IMS/DB.

EMPLOYMENT EXPERIENCE

November 2005-May 2010 Verizon Wireless, Sr. Programmer/Analyst/Project

Leader (Contract)

. As part of VISION (Virtual Information System Integrated Online

Network) Conversion team, I successfully integrated large and small

scale company acquisitions into the Verizon Wireless billing system,

including Alltel Wireless, Unicel Cellular Corporation and AT&T

divested markets totaling upwards of 13 million new customers.

One of my assignments was to merge various billing systems into one.

Verizon Wireless acquired many small wireless companies though out the

US and wanted to make all billing centralized. This project had 12

regions to convert, we successfully converted all regions. We got

unloaded table data from 'SOURCE' and 'I2K', which we massaged and

applied Cross-reference data to eventually map into new billing tables

one of 3 VISION instances. Analysts for various markets provided

cross-reference data. The whole process went through a control, edit,

validate, transform and load phase using flat files, VSAM files and

DB2 tables. Each phase reported error thresholds and checkpoints to

make sure that the process was working to satisfaction. This

processing report was provided to Analysts to verify the transformed

data. To improve conversion through put high volume data tables were

partitioned by either Customer or Invoice numbers to load by

partitions.

I managed this project with 4 developers.

. Also responsible for System Development Life Cycle methodology

including system analysis, program development, database

modifications, Functional/Manual/Regression and Parallel test as well

as coordinating UAT Testing to meet Quality Center requirements.

Implementation and production support of several programs in Cobol II

Batch, CICS, MQ, DB2/SQL as well as the use of IBM and BMC utilities.

Also setting up new data file transmissions (NDM) between internal

users and FTP TCP/IP to external clients. Lead CA7 testing/production

team of four for all acquisitions/integrations jobs. Also use of

VISIO, MS Project, MS Access, MS Excel and MS Word.

. Accomplishments: Project accomplished a 100% billing accuracy and 80%

increase in customer satisfaction as well as reduction of company

operating expenses by $750,000.

Marcelo L. Blumetti

Feb 2005-November 2005 UPS, Senior Programmer/Analyst/Project Leader

(Contract)

. A key member of the Conversion/Integration team for the Teams Rel. 2.

One of the Rel. 2 requirements was to convert 3 UPS Sub data into

Teams application. Responsible for developing, testing and executing

system test procedures to validate incoming data, format the data

according to desired layouts and loading thought BMC utility.

. To satisfy one of the integration requirements of the project,

designed and developed procedures to modify a user key on the existing

Contact and Party tables as well as coordinating with the DBA team to

keep the referential integrity. This integration interface involved

the creation and modification of several Cobol, CICS, DB2/SQL,

MQ/Series and Store Procedures programs as well as VSAM Defines, and a

number of procedures in order to accomplish the new business rules.

. Accomplishments: Each phase of the project has been implemented on

schedule.

March 2004-November 2004 Sony Corporation, Senior Programmer/Analyst

(Contract)

. As part of the SOAR Data Integration team for the electronic division,

I was responsible for the analysis, modification and testing of the

Daily Sales and Data Warehouse systems. This integration interface

involved the creation and modification of several IMS, DB2/SQL,

MQSeries and Easytrieve programs as well as a number of Store

Procedures in order to re-classify the Product Category for main

models and accessories.

. Documentation system was performed in the existing Q&A database.

. Accomplishments: Increase of user time productivity 40% to 80%.

1998- 2004 Prudential Securities, Senior Programmer/Analyst/Project Leader

(Contract)

. Key team member in the analysis, coding and testing of the European

Monetary Union (EMU) system, which involved the creation, and

modification of several Batch, CICS & MQseries programs. Lead of 5 in

the conversion of Dividend system from VSAM to DB2/SQL, and in the

analysis, coding, documentation and maintenance of Statement and

Tracking systems.

Responsibilities included the design and coding of Back & Front DB2

stored procedures, to simplify application maintenance and security.

. Accomplishments: Reduction of company expenses by $ 500,000.

1998. American Express, Senior System Programmer Analyst/Project Leader

(Contract)

. Responsible for the overhaul of several IMS and DB2/SQL programs from

the Tracking, and Multibank Processing systems, and the revamping of

the Financial Capture System for Argentina, Brazil, and Uruguay. This

task involved the creation and modification of customized programs as

well as follows the system completion schedule using MS Project.

. Accomplishments: 15% faster turnaround time for business customers.

1996-1997 A&P Supermarkets, Senior Programmer/Analyst (Contract)

. Participated in the analysis, design, coding, testing, and

implementation of a new customer service system. I also structured and

established standard operating procedures for system implementation in

more than 15 sites. This included CICS and Batch programs using COBOL

II, and VSAM files.

. Accomplishments: Customer complaints decreased 30% and TAT for

customer request decreased from 1 week to 2 days in average.

Marcelo L. Blumetti

1989-1996 Journal of Commerce: Senior Programmer/Analyst/Project Manager

(Permanent)

. In charge of the design, programming, implementation, and testing of

an on-line Trade Rate and Tariff retrieval system.

. Designed and implemented CICS screens with pop up windows for system

through extensive user interface. Application provided update

capability to all files and maintained data integrity throughout the

system.

. Other responsibilities included the complete documentation of the

system's flow and supervised up to 10 programmers. This project was

implemented in COBOL, CICS, DB2/SQL, VISIO on an IBM 3090 under

DOS/MVS/XA.

. Accomplishments: By offering customized service, and improving

customer distribution operations, we saved over $ 500 million in

various operations and warehouse costs.

1987-1988 American Reinsurance Company: Programmer/Analyst (Contract)

. Participated in the implementation of the Domestic Division into the

on-line Treaty System.

. The on-line system managed Clients, Submissions, Declinations,

Abstract, Retrocession's and Accounting information. Other

responsibilities included analysis, design, coding and modification to

the Interface System programs and complete documentation of the

system's flow. The work was done under DOS/VSE on an IBM 4381 using

CICS, IMS, COBOL, and VSAM files.

. Accomplishments: Each phase of the project has been implemented before

schedule.

1984-1987 City Hall Argentina: Programmer/Analyst (Permanent)

EDUCATION

. Diploma in Computer Programming.

. Certificate in Application Design.

. Various IBM courses in CICS Command Level, IMS and VSAM data

structures.

Contact this candidate