Table of contents:

• Section 1. Functional Resume:
• An informal, high-level summary of Mr. Bracale's major professional successes, education and technical skills
• Section 2. Detailed Chronological Resume:
• A formal, comprehensive account of Mr. Bracale's education, skills and professional experience, including detailed descriptions of his duties, responsibilities and accomplishments for each major project and customer, presented in reverse chronological order

SUMMARY

I am a seasoned information Systems Development professional with over 25 years of full life-cycle software engineering experience providing business analysis, data modeling, programming and project management consulting services to clients in the financial services, manufacturing, public utilities and government sectors.

MAJOR PROFESSIONAL SUCCESSES

My career has been project-focused, and I have been retained by my clients -- frequently on multiple engagements -- to help them resolve extremely complex technical challenges in various high stakes business settings where success was essential, often with multi-billion dollar outcomes in the balance. A sampling of these engagements follows:

Hewlett Packard Enterprise Services

• SabreSonic Customer Loyalty Management System Maintenance Contract
• In a highly visible strategic initiative, Sabre Holdings required massive changes to its 20 year old LMS system in order to support a key airline customer's impending affiliation with the STAR airline alliance. STAR is the world's largest airline alliance, and Sabre had no customers among STAR members at that time.
• Designed, coded and tested LMS enhancements to program code COOL:Gen , shell scripts and job scheduler Also served as the project team's Business Analyst
• Wrote and groomed stories agile methodology for LMS team using VersionOne and JIRA
• As a result, Sabre was able to double its target market and remain a leader in airline related software

Confidential

Roadway Characteristics Inventory

• Led, end-to-end, an urgent risk mitigation initiative protecting FDOT's 4 Billion annual Federal Highway Administration funds appropriation process. State of Florida's total annual budget is 70 Billion.
• Developed data and process models allowing system to be re-hosted on a modern, supported DBMS Designed, coded and tested the solution using COOL:Gen
• Added enhancements permitting casual system users internal and web to access RCI data using commonly known identifying criteria instead of the numeric, semi-random internal keys previously required
• Added geospatial data storage capability

Confidential

Customer Service Strategy/Order Processing Project CSS/OP 1

Step Pricing

• Working on an extremely tight deadline with little supervision and incomplete specifications, conceived, designed, coded COOL:Gen and delivered step-pricing functionality by date or quantity
• Step pricing was a key strategic capability not existing in the customer's legacy system
• Step pricing provided critical flexibility for offering customer incentives related to specific inventory and production scheduling opportunities
• Sales Order Conversion
• Led high level and detailed design effort for the conversion of the Motorola Corporation's 3 Billion worldwide sales order portfolio IMS to DB2
• Converted over 600,000 sales orders with only two rejects
• Directed the activities of a five member conversion development team
• Personally designed, coded COOL:Gen and tested the main conversion driver program
• Coordinated all conversion-related activities with the core business system development team to keep conversion business rules in synch with changing core system business rules

Confidential

• Lighting Inventory Control/Inventory Accounting LINC/IA Project
• Re-engineered this GE Corporation business unit's multi-billion dollar world wide inventory accounting system.
• Reduced client's write-off threshold by a factor of 8 Created data 50 entity types and process models
• Formulated the data conversion process, converted 10 million rows of data
• Wrote conversion technical specs, including field mapping and transformation algorithms

Confidential

Branch Divestiture Project

• Branch Divestiture was required by the United States Department of Justice as a pre-condition for allowing the merger of Society and Central National Banks. This was the then largest in-market bank merger ever approved by US DOJ, involving over 9 Billion in combined assets.
• Was the first and only in the IT chain of command to identify fully the implications of the initial draft sales contract on Central Bank's balance sheet and consequently to the scope of divestiture project
• Communicated the urgency to executive management
• Formulated the strategy for selling the deposits and loans of the 17 affected CNB branches
• Led Branch Divestiture Demand Deposit Accounting Check Processing analysis and design effort Established balancing and control procedures for DDA divestiture
• Balanced the 500 million transaction to the penny

STRENGTHS

Excellent oral and written communication skills Accomplished leader and mentor Strong customer-facing presence Outstanding quantitative and analytical skills Highly skilled at managing the user/data processing interface

PROFESSIONAL EXPERIENCE

SKILLS INVENTORY

Methodologies: Information Engineering Methodology

• Business Area Analysis: Data Modeling: creating logical ERDs for OLTP 10 yrs , metadata 2 yrs , dimensional modeling for OLAP 1 yr JAD Facilitation 10 yrs Process Modeling: functional decomposition/AHDs 10 yrs Database: DB2, SQL, QMF and File-AID 15 yrs Oracle DBMS and SQL Tools 8 years MS SQL Server 2 yrs Operating Systems: MS Windows 95 through Win8 20 yrs , MVS / zOS 15 yrs , Linux 5 yrs , shell scripting 3 yrs Programming Languages: C 12 yrs , C 4 yrs , Visual C 2 yrs , COBOL 8 yrs , APL 4 yrs , JAVA < 1 yr CASE Tools: CA Gen formerly known as AllFusion Gen, Advantage Gen, COOL:Gen, Composer and IEF 16 yrs CA ERwin Data Modeler 2 yrs , Report Composer 4 yrs
• Other: VersionOne, JIRA, MS Office, Word, Excel, Power Point, Visio testing methodologies, test data creation, statistical sampling, operations management, stochastic processes, data extract, transform and load, data conversions

SUMMARY

• A seasoned information systems development professional with over 25 years of full life-cycle software engineering experience providing business analysis, data modeling, programming and project management consulting services to clients in the financial services, manufacturing, public utilities and government sectors.
• Areas of expertise include the Information Engineering Methodology, data modeling, testing methodologies and structured analysis/design. Business areas encompass scientific, manufacturing, financial services, sales order processing, customer information, inventory accounting and regulatory reporting.
• Has served as both a user and provider of Information Technology systems. Accomplished in managing the user/data processing interface at all levels of an organization. Highly effective at presenting technical concepts to general audiences in common business language.

TECHNICAL EXPERTISE

• Methodologies: Expert level skills 16 years with the Information Engineering Methodology IEM , Agile 2 yrs
• Business Area Analysis: Data Modeling - creating logical ERDs for OLTP 10 yrs , metadata 2 yrs , dimensional modeling for OLAP 1 yr JAD Facilitation 10 yrs Process Modeling: functional decomposition/AHDs 10 yrs
• Database: DB2, SQL, QMF and File-AID 15 yrs Oracle DBMS and SQL Tools 8 years MS SQL Server 2 yrs Operating Systems: MS Windows 95 thru Win8 20 yrs , MVS / zOS 15 yrs , Linux 5 yrs , shell scripting 3 yrs Programming Languages: C 12 yrs , C 4 yrs , Visual C 2 yrs , COBOL 8 yrs , APL 4 yrs , JAVA < 1 yr
• CASE Tools: CA Gen formerly named AllFusion Gen, Advantage Gen, COOL:Gen, Composer and IEF 16 yrs CA ERwin Data Modeler 2 yrs , Report Composer 4 yrs
• Other: VersionOne, JIRA, MS Office, Word, Excel, Power Point, Visio testing methodologies, test data creation, statistical sampling, operations management, stochastic processes, data extract, transform and load, data conversions

PROFESSIONAL EXPERIENCE - independent consultant to the following organizations:

confidential

Texas Medicaid Healthcare Partnership COR63 Project - Executed regression testing of various servers for migration from Tandem NSK platform to HP blade servers running the NonStop operating system CA Gen Windows, C, Tandem NSK, Report Composer

confidential

Same duties and responsibilities as noted

confidential

SabreSonic Loyalty Maintenance Contract - Agile CA Gen developer, Frequent Flyer Management System FFM . Designed, coded, tested and deployed numerous FFM enhancements CA Gen Participated in daily scrum Developed Linux Korn Shell scripts Autosys Daily Scheduler jobs JILs hand-coded C language Gen externals Developed SQL to create and manipulate test data, establish flat file extracts and identify data-related anomalies Also served as the FFM team Business Analyst Wrote and groomed stories for FFM team using VersionOne CA Gen C, Linux, Oracle, Report Composer

confidential

Texas Medicaid Healthcare Partnership - Created Data Model Change Request establishing National Correct medical Coding Initiative NCCI tables. Programmed enhancements implementing NCCI. Wrote SQL scripts updating and inserting rows into various developer-maintained tables. AllFusion Gen Windows, C, Tandem NSK

confidential

Apply for Benefits Web Application Re-write Project - Facilitated JAD sessions. Gathered, analyzed and documented AFB Unemployment Insurance system requirements -- Use Cases, Page Flow Diagrams, Requirements Matrix, etc. Created high level design required to bring existing stand-alone AFB web application inside TWC's single sign-on portal. Identified and re-designed all affected business processes. Translated functional requirements into technical specifications. Owned and maintained all project documents and design artifacts. Formulated system testing strategy. Wrote test cases, test scripts and detailed test logs. Wrote and executed complex SQL joining up to eight tables in order to pull production data and establish a robust, refreshable test data bed on the development platform.

confidential

Gathered, analyzed and documented system requirements for the client's MetaVance Medical Insurance and Administration Enterprise System. Created high level system design solutions for all requirements identified. Wrote system technical specifications. Coded system changes AllFusion Gen for Membership functional area application programming interfaces APIs used by external customers to interface with MetaVance. Formulated high level test plan strategy, wrote test cases and test scripts. Actively participated in walk-throughs, weekly QA status defects meetings. Mentored three junior AllFusion Gen developers. Platform 1: AllFusion Gen Windows, COBOL, CICS, DB2, Report Composer - Platform 2: AllFusion Gen Windows, C, Unix, Oracle - Development platform: AllFusion Gen Windows, C, Oracle, Report Composer

confidential, Indianapolis Analyzed system requirements, documented business processes and developed a high level design for establishing a B2C web sales portal for client. Wrote system use cases, functional specifications and technical specifications. Formulated and executed system test plan. Facilitated periodic walk-throughs, QA status defects meetings. Directed product testing and evaluation cycle.

• confidential, Tallahassee, Roadway Characteristic Inventory II Project - Analyzed existing system technical architecture and business processes for client's Roadway Characteristic Inventory re-engineering/re-hosting initiative RCI2 . Created high-level database and user interface design. Analyzed and re-engineered existing business processes to work efficiently with new data structures/design. With minimal impact to twenty existing DB2 data warehouses having 200 known OLAP application interfaces, formulated a comprehensive information solution replacing an obsolete transactional database running on an unsupported version of IBM's IMS
• DBMS. Facilitated data modeling JAD sessions 40 SMEs, 8 Data Analysts . Created the RCI2 logical data model, including the critical meta-data repository. Wrote RCI2 functional and data conversion specifications. Translated functional specs into system technical specifications. Wrote RCI2 transactional DB to OLAP DB loader technical specs. Formulated system test plan. Led RCI2 design team, supervising four developers. Designed, coded, tested and implemented user-friendly data access indexes and methods not previously available, permitting users to query the database via commonly known external criteria instead of the numeric, semi-random internal keys required in the legacy system. This enhancement provided query capability for casual system users from junior staff up to the department Secretary. Release platform: Advantage Gen Windows, COBOL, CICS, DB2 Development platform: Advantage Gen Windows, C, DB2 Universal
• The RCI2 meta-model allowed DOT to capture information about the location, design, composition and characteristics of 40,000 lane miles of state-maintained roadways, plus all maintenance items signs, striping, traffic lights, guardrails, bridges, etc. associated with them. Information as simple as the location of a STOP sign and as complex as the engineering specifications of any given roadway segment were stored in the same seven tables. Converted 30 million rows of data. RCI2 data is the basis for all FDOT compliance reporting to the US Federal Highway Administration, the source of 5 billion of FDOT's 6.5 billion annual budget.

confidential

• International Trade Data System Project - Obtained USCS highest non-law enforcement security clearance. Analyzed and documented business processes supporting the USCS Risk Assessment Consolidation Business Area for the customer's ITDS project, a key component of the Reinventing Government initiative.
• Analyzed the risk assessment identification business processes of multiple federal agencies USCS, INS, FDA, DOT, USDA, etc. and created a high level design for gathering and consolidating all known risks associated with any specific import goods declaration. Created real-time risk assessment reports for Customs Inspectors at all US ports of entry. Developed and wrote Risk Assessment test plan. Coded various Cool:Gen PrADs and C language external action blocks. Mentored junior level Cool:Gen and C language developers. Cool:Gen Windows, UNIX, Oracle, C, MQSeries

SABRE DECISION TECHNOLOGIES, Designed and coded ten new Cool:Gen GUI client server PrADs for SABRE's airline revenue accounting system QUASAR . Designed and coded enhancements to several other PrADs. Analyzed and documented the impact on QUASAR resulting from changes to the fuel surcharge proration process adopted by the Air Transport Association. Fixed production incidents as assigned. Cool:Gen UNIX, COBOL, Oracle

MEDICAL MUTUAL of OHIO Led analysis and high level design effort required by Corporate Membership Systems CMS for implementing a new Medicare risk product WISECARE while mentoring two junior programmer analysts. Facilitated JAD sessions. Created WISECARE business area data model. Analyzed system requirements and wrote high level test plan, test cases and test scripts. Actively participated in walk-throughs, weekly QA status defects meetings. Coded and implemented WISECARE Cool:Gen PrADs. Cool:Gen CICS, COBOL, DB2

COMPUTER ASSOCIATES formerly Sterling Software ,Gen Product Development Group - Regression tested various features of client's integrated CASE software development toolset Cool:Gen version 5.0 prior to its commercial release. Updated regression test cases and related automated testing facility as directed. Primarily targeted MVS IMS/DB2 and CICS/DB2 using both Windows NT and OS/2 front ends.

BANK OF AMERICA formerly MBNA - Facilitated data modeling JAD sessions. Developed a meta-model capturing information about legacy COBOL application systems. Evaluated and documented the utility of McCabe Tools for this major credit card company's core transaction system re-engineering effort. Devised methodology for applying McCabe to various project tasks, emphasizing testing related activities, including test case development and test data definition. Conducted data driven testing examining various sets of data using McCabe. Wrote test cases and performed testing of various Card Issuer interfaces.