Robert M. Chirco

**** *********** ***** * Glen Allen, VA * Phone: 804-***-**** * Email: ab93yf@r.postjobfree.com

SUMMARY OF QUALIFICATIONS

Bob Chirco most recently performed as an Informatica Data Warehousing Specialist. He has over 30 years of

consulting experience on large data integration and business intelligence projects. His vast experience includes application

design, business analyst, database design, data conversions, data integrations, data modeling, data warehousing, ETL, problem

solving, process improvement, project management, quality assurance, software installation, software configuration, software

proof of concept, software training, software upgrades, production support, programming, systems architecture, systems

implementation, testing, and training.

.

PROFESSIONAL BACKGROUND

Mr. Chirco’s accomplishments include:

Analyzing and implementing technological solutions that support user and management business goals,

•

reduce overhead, decrease costs, shorten processing time, increase customer satisfaction, and improve performance;

Planning, managing, and coordinating projects, resources, and task time schedules;

•

Teaching and training technical and non technical staff in the understanding and use of new technologies;

•

Providing hands on technical and managerial support through all phases of the project life cycle;

•

Meeting with people from all business levels to gather and accurately document requirements;

•

Designing relational and hierarchal databases models;

•

Creating specifications including data diagrams, relationship models, on line and batch programs, systems

•

interfaces, system and program flow charts, data conversions and mappings, detailed design documents, business use

cases, test plans, quality enforcement, user interfaces, user reports, and maintenance and support;

Providing on going support and guidance between business users and technical developers;

•

Learning new technologies, tools, standards, and business needs quickly and easily;

•

Reporting on progress of projects to management and users;

•

Working independently and working with many different roles in a team environment;

•

Defining, coordinating, tracking, and reporting milestone progress along with risks, issues, and action items;

•

Providing on call support of production systems;

•

Ensuring standards are met and results are perfect prior to implementation;

•

Creating modular sub programs that can be reused by many other programs;

•

Performing with excellent written and oral communication skills with diverse people in different levels of

•

authority inside and outside of the company.

Senior Data Modeler – Insight Global – February 2013 Present

Performing as a Senior Data Modeler with SunTrust bank in their MIS department, Mr. Chirco is their hands on team leader

responsible for creating an Enterprise Data Warehouse that will be used as the Business Intelligence Repository for all MIS

reporting. The goal of this project is to replace the existing production ad hoc reports created using a multitude of software

languages with a consistent front end reporting tool accessing current quality data using governed meta data from a current

clean data in a data warehouse.

Data Warehouse Specialist Udig – June 2012 – October 2012

While on contract Mr. Chirco used his expert knowledge and experience with Informatica and data warehousing to ensure the

success of the projects that he was responsible for. One of the projects was to convert from Oracle to Microsoft SQL Server,

where he was able to overcome the differences in the data types between the two database management systems using ETL.

The other project was the automation of manual efforts to build reports where he was able to import the manual data as a

source into an Informatica mapping and using ETL transformations was able to duplicate the manual effort resulting in huge

savings for the client.

Principal Software Specialist Informatica Corporation – May 2005 – May 2012

Mr. Chirco has very strong IBM mainframe technical skills along with communication skills that allow for quickly

comprehended technical knowledge transfer. Mr. Chirco has installed and configured Informatica products to support many

different configurations including: MVS DB2, MVS IMS, MVS IDMS, MVS DATACOM, MVS VSAM, MVS CICS, AS400

DB2, Microsoft SQLSERVER, and Oracle for both bulk load processing and real time (CDC) Changed Data Capture. Mr.

Chirco has worked with clients to configure Informatica products for both performance and reduced CPU costs. He received a

perfect customer satisfaction survey from a client where he taught them how to reduce their CPU consumption by over 50%.

Mr. Chirco has successfully completed many of the most technical challenging Informatica Power Exchange engagements for

the Informatica SEAL team. He has developed and delivered custom Informatica training programs for clients. Mr. Chirco is a

results oriented and innovative professional skilled in interpersonal relations and communications. He is a perceptive and

pragmatic problem solver with a reputation for high standards of quality, performance, integrity and loyalty. His diverse areas

of application programming experience include: banking, claims processing, education, engineering, financial, government,

health care, manufacturing, marketing and sales. Mr. Chirco is a proven problem solver with exceptional business analysis

and system design skills. He has implemented numerous process improvements that saved millions of dollars and have

substantially shortened the time it takes to get the job done. Mr. Chirco has used the Informatica tools from version 4.6 thru

the current version 9.5 and all versions in between.

Software Engineer / Technical Project Manager – Unisys Health Systems Sept 2002 – Nov 2004

Mr. Chirco planned, designed and managed a development team for a web based Resource Management System utilizing SQL

Server and ASP.NET. He assisted in the development of the Kentucky MMIS UniPAS transition plan. Created a DSD for

New Jersey MMIS Phase II Enhancements which involved the re engineering and converting of the existing systems to a

relational database system utilizing DB2 and SQL. Mr. Chirco developed Use Case documents for the Kentucky MMIS POS

Drug Utilization Review relational database system. He developed Informatica ETL transactions for the Kentucky MMIS

based upon gap analysis. He provided support and maintenance for the Louisiana KidMed and Community Care MMIS online

CICS and batch systems.

Senior Consultant / Technical Project Manager Compuware Corporation Nov 1997 – July 2002

For a major financial institution, Mr Chirco performed analysis, design and programming for their solicitation processing

systems. Responsibilities included: providing support for their production systems, troubleshooting, documenting solutions,

re engineering processes, designing cost saving standards, and training. In a batch, COBOL II, Oracle environment Mr. Chirco

designed, analyzed, programmed, tested and implemented programming solutions that saved millions of dollars annually and

trimmed a two week process down to a few days.

Senior Consultant / Technical Project Manager PRT Group of America May 1994 – Nov 1997

For a major manufacture in an APS, CICS, COBOL II, DB2 environment Mr.Chirco managed multiple teams and

planned, analyzed, designed, scheduled, programmed, tested, and implemented a sales force application, which

computed and tracked the goals and objectives for the complete sales force. He turned around a failing project into a

successful implementation within the existing budget and schedule. He managed a Sales Force Automation &

Promotional Ordering development project, which included a new hardware and software distribution to all sales

offices and field personnel.

Senior Consultant Computer Horizons Corporation Oct 1992 – May 1994

For a major telecommunications company Mr. Chirco performed as an APS administrator and a project manager, installed new

releases of APS on both DOS and OS/2 workstations, developed standards, trained a team of 20 data processing professionals

in the understanding of APS, On line Express, & APS Report Write, and analyzed, designed, programmed, tested, and

implemented a fraud detection system. Mr. Chirco trained consultants in the understanding and use of APS/PC, On line

Express, Microfocus Animator/CICS/COBOL/Workbench and XDB. Programmed and tested an APS CICS DB2 real time

equity system for a major financial institution.

Project Manager Medco Containment Corporation July 1990 – Oct 1992

Mr. Chirco planned, scheduled, coordinated, and directed the Financial Applications Team through the design, coding,

testing and implementation of the following: Claims Adjudication System, Paid and Rejected Claim EDI Systems, and

custom client financial software systems including, Check Printing Systems, Billing Systems, Bank Account

Reconciliation Systems, Point of Sale Systems, and Statement Printing Systems, in a CICS, COBOL, VSAM

environment. Mr. Chirco designed a Customer Information System using CICS, COBOL II and DB2. Managed and

coordinated the activities of a DBA, two senior PA's and a PA responsible for maintaining Marketing's DB2 inquiry

and reporting systems. He assisted in the analysis of Platform Automation Systems, and Voice Response Systems.

Project Manager – Lockheed Electronics Corporation July 1985 – July 1990

Mr. Chirco planned, scheduled, coordinated, directed, and worked with, the Management Systems Team through the

analysis, design, coding, testing, and implementation of the following applications utilizing APS/IMS CASE, COBOL,

DB2, and IMS/DB/DC technologies: Quality Control System, Logistical Support System, LEC Purchasing System,

Engineering Document Control System, an Inventory System, and a Calibration Control System.

.

EDUCATION and AWARDS

Mr. Chirco has a Bachelors of Science in Computer Science from Rutgers University.

Informatica – Infa Star award received for best performance in the company

Unisys award received for leading the RMS project.

Philip Morris – T.E.A.M. award received for turning around the troubled STEPUP project.

Medco Containment Services, Inc. – MVP (Most Valuable Programmer) for saving hours of batch processing time

within their medical claims processing cycle.

Lockheed – Employee of the year award for a successful implementation of a Logistical Support System and Quality

Control System.

General Dynamics – Cost Savings Bonus Award for identifying excessive processing within their printing servers.

SKILLS SUMMARY

Data Integration and Business Intelligence Programming Languages & Environments

ACCESS, APS, ASP, ASP.NET, BMS, BTS, CASE

• Data Warehousing Architectures

• Data Conversion Architectures TOOLS, CHANGEMAN, CICS, CLIST, COBOL,

• Business Intelligence Architectures COBOL II, DBASE, DB2, DEBUG AID, DL1, DOS,

• Portal Architectures EXCEL, EZTRIEVE, FILE AID, FORTRAN, HTML,

• Data Modeling IMS DB/DC, IMS UTILITIES, INFORMATICA ETL,

• Informatica PowerCenter ISPF, JAVA, JCL, JES2, JES3, LIBRARIAN, LINUX,

• Informatica PowerExchange MFS, MICROFOCUS (ANIMATOR, CICS, COBOL,

• Complete Systems Development Life Cycle(SDLC) IMS, WORKBENCH ), MICROMAN, MICROSOFT

OFFICE, MICROSOFT PROJECT, MVS UTILITIES,

NETEZZA, ORACLE, PANVALET, PL/1,

POWERPOINT, QBE, QC, QMF, ROSCOE, SAS,

SQL, SQL SERVER, TERADATA, TSO, UNIX,

VISIO, VISUAL BASIC, VISUAL SOURCE SAFE,

VSAM, VSAM UTILITIES, WORD. (Note: Many

additional software skills are known but not listed.)

Database and Operating Systems Project Management

• Oracle Database • Project Scope Definition

• DB2/UDB • Issue Management

• Teradata • Training and Development

• Netezza • Microsoft Project, Excel

• Microsoft SQL Server

• Microsoft Access

• IBM IMS DB/DC

• DOS, DOS/VSE, Linux, Mac OS, MVS, OS/2,

Windows, Unix, z/OS

Contact this candidate