Business Analyst

James McDonough

James V. McDonough

*** ******* ***** 847-***-****

Algonquin, IL 60102 acd9tb@r.postjobfree.com

Business Analyst

Summary

IT professional with experience that includes Systems Analysis, Business Analysis, and Development. Have focused on

achieving strategic business goals through development of applications and IT system integration. Strengths include

superior technical aptitude, sound judgment and problem-solving, fiscal management, and a sense of urgency balanced

with a long-term vision for future needs and growth of the organization. Have worked with business users, customers,

and application teams to gather requirements to assure the application and system needs are being met. Have

excellent communication skills to accompany strong technical background.

Experience

Consulting at Gallagher Bassett, Itasca, IL. - employee of TEK Systems.

Business Analyst December 2013-

February 2014

• Gather requirements for adding new vendor to Managed Care systems and applications.

• Gather requirements for retention of claim data for minors and incompetent claimants.

• Interface with users to create Business Requirements documents.

• Rewrote the Business Requirements Document.

• Participate in multiple requests to gather and retain policy data.

Consulting at BCBSA, Chicago, IL. - employee of Strategic Staffing Solutions.

Business Systems Analyst September 2010-

November 2013

• Support ITS and Blue2 enhancements and production defects to ensure client

satisfaction with planning, communication and service.

• Provide support and assistance to the Provider Data Operations Team by creating

functional specifications using Word, PowerPoint and Visio.

• Maintain and enhance Outlook email systems.

• Create functional specs for ICD-10 conversions and 5010 conversions of business

processes and data using Word.

• Manage Incident Management processes. Lead, coordinate, and resolve issues with BCBS Plans utilizing

Association’s Inter-plan Teleprocessing Service (ITS) and Blue2 Systems.

• Make work plan presentations to the National Programs Business Applications Workgroup (NPBAW) using

PowerPoint.

• Expedite problem resolution using call center technology and software to ensure service support. Includes Service

Now and Infra.

• Participate in the Defect Assessment Team (DAT).

• Maintain and create Blue Web documentation for functional specifications, release notes, and project

documentation using Word and Visio.

• Communicate and coordinate with BCBS Plans regarding system rollouts, release management, quality issues,

capacity and integrity issues within ITS.

• Review and inspect mainframe software to support ITS. Review application code and SQL queries.

• Wrote SQL queries to validate functional specification solutions.

• Collaborate in JAD Sessions for understanding the business requests and their ability to fit in current operations.

These included the business stakeholders and users, the business analysts, developers, system programmers,

data base administrators, and testers.

• Manage and maintain Sharepoint integrity for release management.

Consulting at WPS, Madison, WI. - employee of Exacta Corporation.

Business Systems Analyst

December 2009- June 2010

1

James McDonough

• Support and enhance the 5010, 837 and 835 transaction sets.

• Gather requirements for claims systems by interviewing clients, reviewing the

statement of work, the business plan, and the project plan. Follow the standards of

CMMI. Used JAD sessions for identification of business requirements.

• Create functional and nonfunctional requirements for cross functional teams.

• Create product designs including narratives, Visio documents, Word documents, and

Excel spreadsheets, use cases, and test scripts for Dev, QA, and UAT test

environments.

• Recommend process solutions and system technical solutions.

• Integrate requirements and solutions throughout various projects following SDLC processes.

• Create technical specifications and test requirements.

Allstate Insurance Company, Northbrook, IL June 1998- July 2009

Business Analyst in Claims support team and Incident Resolution, 2007 - 2009. In

response to identified errors and enhancements to system needs, interface improvements,

application problems, and error alerting software, gathered data for functional

requirements, collaborated with systems programmers, DBA’s, and application system

analysts to create resolutions. Designed requirements documents, process design

documents and product specifications, use cases, test plans, and queries for Oracle and

DB2. Monitor progress in test director. Collaborate with release management. Resulted

in reduced down time due to outages saving $1M/Hr per outage.

• Gathered requirements for problem resolution efforts. Included interviewing application areas, collaborate with

technical support groups, system architects, test teams, and business clients. Drive requirements to

implementation. Manage resolution progress in service management software and service management

databases.

• Used WAMWEB and HP Quality Center to track process improvements, incident management, and problem

records. Followed ITIL standards.

• Member of Change Management Board (CMB) .

• Directed and assessed impact analysis on production systems.

• Created and supported dashboard presentations.

• Wrote SQL queries to validate data and to assist in resolution requirements.

• Published and presented problem metrics, system implications and process improvement recommendations to

management. Required SQL queries to compute metrics and affirm recommendations.

• Performed application health checks by monitoring systems with Compuware alerts developed with OneSight

software.

• Provided customer support by executing incident resolution processes designed to resolve outages within the SLA.

• Directed points of failure identification and mitigation procedures.

• Directed authored solutions.

• Configured and implemented production monitoring components.

• Created and maintained alerting matrices and metrics.

• Facilitated disaster recovery plans.

TIBCO Developer and Administrator for NextGen Claims System, 2006 - 2007. Developed TIBCO integration code

for Next Gen Claims System, the largest Allstate system implemented. Resulted in replacement of 95 independent

claims systems. Net effect is that claim processing is 50% more efficient and quicker.

• System administrator for Tibco test environments. Managed test system TIBCO releases.

• Wrote TIBCO code for integration infrastructure applications and B2B applications.

• Implemented Message Queuing (MSMQ) technology in integration layer.

• Integrated TIBCO Enterprise Message Services with Web services.

• Integrated MQ Series middleware with stored procedures and stored SQL queries.

• Wrote and implemented Oracle SQL and DB2 SQLqueries.

• Created and executed test scripts and wrote test plans for each test environment, including Dev, QA, UAT.

Business Analyst for Claims Systems, 2004 - 2006. Gather requirements for integration layer of new Next Gen

Claims System. Design included B2B applications and infrastructure applications.

2

James McDonough

• In Pursuit Phase, created high level sequential data process flow diagrams in Visio and Word.

• For Requirements Phase interviewed clients, technical architects, application teams, software vendors, and quality

assurance teams.

• Created conceptual diagrams, entity relationship diagrams, integration points matrices, use cases, and testing

documents for Dev, QA, and UAT.

• In Design Phase created product design documents using narratives, Visio, Word, and Excel. Created

supplemental configuration documents, unit test plans, and traceability matrices.

Developer for Claims Systems, Underwriting and Risk Analysis Support, 1998 - 2004. Supported legacy

mainframe applications. Resulted in less manual work and more system driven functions, more efficient claims

handling.

• Wrote SQL queries for application software code.

• Maintained application programs that included the following software: IMS, DB2, CICS, TELON, VSAM, MQ Series.

• Created JCL, Procs, DB2 bind jobs, Sorts.

• Used File-Aid for file transfers, file maintenance, and IMS segment maintenance.

• Debugged COBOL and PLI programs with XPEDITER.

• Created production schedules.

• Major participant in production releases.

• Provided production support 24 X 7.

• Created and executed test plans.

Cooper Lighting, Elk Grove Village, IL. April 1987- June 1998

Systems Analyst and Developer. Supported manufacturing systems, production and

inventory control, shipping, receiving, scheduling, MRP, DRP and shop floor control.

Enhanced and modified customer order processing system including sales, vendor

management, supply chain, return processing.

• Maintained application programs that included the following software: IMS, DB2, CICS, TELON, VSAM, MQ Series.

• Created JCL, Procs, DB2 bind jobs, ACB Gens, Sorts.

• Used File-Aid for file transfers and file maintenance.

• Created production schedules and scheduled production turnover to production.

• Documented production systems and components, and provided production support 24 X 7.

Education/Certifications

ITIL V2 Foundation Certification

TIBCO Certification

APICS – Harper College, Palatine, IL

AA – Data Processing, Harper College, Palatine, IL

BA – Political Science, University of Illinois, Urbana-Champaign, IL

Technical Skills

SQL Oracle DB2 Access CICS IMS TIBCO EXCEL FTP SPUFI SQL Server

Visual Source Safe

Use Cases MQSeries VSAM Business Objects Stored Procedures File-Aid JCL COBOL

PLI

MS Office LOTUS Notes HP Quality Center XML SharePoint Visio Word PowerPoint

Excel Outlook

3

Contact this candidate