SUMMARY:

• Business Analyst professional with over 20 years experience in IT technology projects in Airlines - Travel, Insurance (Property & Casualty, Commercial Lines), Personal/Commercial Banking, Sports Cable Media, Pharmaceutical, Healthcare, Consumer Products, and Insurance industries focusing on Data Marts/Warehouse, Ecommerce applications, Vendor applications, and System consolidations.
• Skilled in all phases of software development life cycle (SDLC), Project Management, Requirement Management, UML, Use Cases, Test Cases, Data analysis and Data/Process Flow design, Service Contracts, and Project Design documents.
• Proven ability to manage complex projects and collaborate with both functional and technical business teams. Research and identify gaps in existing and proposed solutions that are required to realize the of business goals and objectives.
• Project Management expertise includes: Collaborating with senior management and project sponsors to establish scope and vision, manage and mentor business analyst resources and budgets, handling multiple projects and systems to support development process and ensure project deliverables are met based on business needs.
• Experienced and proficient in Requirement Management Process: requirement elicitation, document, change, negotiate, sign-off of business, user, data, reporting, out of scope, system, functional & non-functional requirements, also utilizing Prioritization Matrix, Traceability Matrix, Diagrams, and analyzing Entity Relationship diagrams (ERD).
• Experienced in developing business requirement document (BRD), system requirement document (SRD), functional requirement document (FSD), documentation of business rules for current and future state, and development of Testing Strategy documentation for various projects.
• Experienced in developing Business Process Modeling As-Is, To-Be documentation, Context diagrams, data flow diagrams (DFD), and Decomposition diagrams.
• Management Expertise includes Finance (Banking), Human Resources (Payroll & Benefits), Insurance products (Healthcare/Property & Casualty), Sports Cable Media, and Project/Product life cycle management, Business process modeling / re-engineering.

TECHNICAL SKILLS:

Technology and Tools: IT Expertise in Teradata SQL Assistant, SQL, Business Objects, MS-Office (Visio, Project, Word, Excel, Access, Publisher, PowerPoint, Outlook, Office Communicator, PL/SQL, QMF, SQL Plus, TOAD 10.5.1.3, RDBMS (Oracle), DB2, Sybase, SAS, Web Analyzer, SharePoint, Documentum, CA-Clarity PPM, Planview PPM, AQT, SNAG-IT, Axure RP Pro 5, SOAPUI 4.0, Trillium Software, HP Quality Center, Business Objects / Crystal Reports, Rational Requisite Pro, Rational Quality Manager, Rational Clear Quest, Rational Clear Case, Mainframe & utilities: COBOL, COBOL II/MVS, IMS, CICS, File-AID, Ezytrieve, Syncsort, EDIFACT, HIPPA-276, 837, EDI ANSI, XML, HTML.

PROFESSIONAL EXPERIENCE:

Confidential, Wallingford, CT

Sr. Business Systems Analyst

Responsibilities:

• Primary accountability for gathering business & functional requirements for Confidential Data Exchange team for enterprise-wide third-party vendor and State Mandate APCD extracts by assuring requirements meet the SDLC standards, templates, and requirement process according to RUP methodology updating requirements in Requisite Pro.
• Ability to guide incoming/outgoing vendor and State Mandated extracts’ business/technical requirements and data mapping for small requests (SSCR’s) and large scale projects (POR’s) on an enterprise-level.
• Lead facilitation meetings with Technology and the Business to review scope, high-level strategic, business / technical requirements, and any outstanding questions for clarifications and agreements.
• Assisted in capturing vendor outreach information and status for ICD9-10 Remediation project and document issues relating to technical requirements, development, and testing needs.
• Created UAT Test Plans, Test Scenarios documentation for Data Exchange project implementations.
• Provided status reports on various service requests and projects showing progress against milestones, status, issues, risks, and dependencies.

Confidential, Bristol, CT

Sr. Business Analyst

Responsibilities:

• Primary accountability for gathering business & functional requirements for Major League Professional Baseball, College Baseball, and other baseball leagues (World Baseball Classic, Caribbean World Series, & Little League Baseball) from legacy applications and third party systems & tools to new development application tool for capturing Baseball Sport Statistics & Data, assuring requirements meet the standards, templates, and requirement process for Statistics & Analysis department.
• Ability to guide software development business analysis and drive large scale projects, as well as hands on requirements gathering and work with developers to wire frame conceptual designs.
• Developed & Documented SDR Baseball project scope with approval from PMO, Technical and Business Stakeholders.
• Lead BA resources in the development of a Requirements Process and Business Analyst project plan & estimates for other BA resources assigned to business and functional requirements gathering, and coordinating product components.
• Elicit requirements using shadowing, interviews, existing systems and document analysis, requirements JAD sessions, use cases, business analysis and workflow analysis.
• Interpret and analyze information across functional areas needs to ensure operational and functional requirements are well planned.
• Lead facilitation meetings with Technology and the Business to review requirements, workflows, design mockups, issues, and outstanding questions for clarifications and agreements.
• Provided status reports on project showing progress against milestones, status, issues, risks, and dependencies.

Confidential, Atlanta, GA

Sr. Business Analyst

Responsibilities:

• Primary accountability for gathering requirements for business requirements for various projects and/or systems from initial phase to final implementation, assuring requirements meet standards for SOA governance & engagement team.
• Interfaced with users, other portfolios, vendors, and Delta Technology for full life cycle of project utilizing the SOA engagement process.
• Participate in JAD discussions with company Partners to discuss product specifications for website(s), including UI requirements (Wireframes), product benefits, customer service protocols, system interfaces to mainframe services and reporting.
• Develop use cases and functional specifications and coordinate the capture of process models and functional testing, ensuring system is functionally appropriate, technically sound, and well integrated.
• Develop project level design solution specification with SOA architects to document project highlights of SOA services rendered to Delta consumers.
• Assist in the development of project definitions, cost/benefit and risk analysis, work plans, progress reports, and presentations.
• Transition product support to systems operations.
• Assist in maintenance and communication of project status reports and tracking.
• Provide user support and coordinate resolution of issues to include change management, root cause analysis, and appropriate escalation as needed.

Confidential, Norwalk, CT

Business Analyst

Responsibilities:

• Primary accountability for gathering requirements for business requirements documents and functional requirement documents for Ecommerce web applications.
• Interfaced with Marketing, Product Operations, Customer Service, Development, and QA areas, covering Acquisition, Billing & Fulfillment, and back-end Sales transaction processing.
• Participate in JAD discussions with company Partners to discuss product specifications for website(s), including creativity, product benefits, billing processes, customer service protocols, system interfaces to mainframe services and reporting.
• Development of use cases for assisting in the development of test case scenarios and test execution of functional end-to-end and QA testing.

Confidential, Hartford, CT

Sr. Business Analyst

Responsibilities:

• Primary accountability for incorporating a blend of business analysis along with a strong technical acumen in support of Middle Market, Select and Specialty business segments by developing business and system requirements for Pricing and Scoring monitoring, Pricing model applications effecting Actuaries, Underwriters, and Customer Service Representatives.
• Develop test requirements and test plans for manual testing to support test cases and scenarios for the major invest projects.
• Create SQL queries and scripts to validate data for test scenarios for client applications feed by upstream mainframe systems to back-end reporting applications.
• Coordinate, execute and verify results using SQL in Teradata Assistant & Administrator.
• Participated and lead test planning with all test cycles using proven testing techniques.
• Develop test plans, test cases and conditions from business requirements for Business Intelligence and Information Management teams.
• Develop documentation for adherence to internal quality assurance procedures within the Pricing group by organizing daily tasks and work requests by applications/resources that will assist in monitoring, evaluating, and verifying standards and quality.
• Developed Pricing Audit recommendations for the Actuarial department, documenting mainframe codefor Commercial Lines Data Warehouse requirements’ transformation rules as well as documenting utstanding audit issues for various LOB’s.
• Assist in developing test case scenarios and test execution of functional end-to-end and production testing for new Pricing Models for each line of business (Auto Pricing Model, Property Pricing Model, and General Liability Pricing Model) investment projects, to support the strategic business initiatives for the Underwriters and Actuaries.
• Developed Testing Strategy template for current and future IDS projects relating to new pricing models for various Lines of Businesses, to enable better testing results and production implementation.
• Primary production support of Quarterly Middle Market Staffing Model Tool (ACCESS/EXCEL), which assist Underwriters and Customer Service Reps to determine the resource staffing needs for FRE policies by LOB.

Confidential, Bridgeport, CT

Sr. Business Analyst

Responsibilities:

• Primary accountability for providing client support and consultation on the development of business requirements in the designing of over 200 new and modified Lotus Notes forms for Sharepoint development forms for the New England branches and headquarters.
• Developed Change Control forms to document new business requirements, tracking request priority, request development time, and management signoff.
• Assist Project Manager in preparation for Senior Management status meetings by preparing presentations for project status, resources, and timelines.
• Resource Manager for outsource development team on project, consisting of tracking status reports, resource tasks, resource time, client-related issues, and interviewing new resources for client projects.

Confidential, Hartford, CT

Sr. Business Analyst (Commercial Lines Data Warehouse)

Responsibilities:

• Primary accountability for providing Actuarial client support and consultation on the development of business and system requirements in the design and delivery of a single comprehensive data store by consolidating relational databases residing on Teradata, Oracle, SAS, and other platforms into an enterprise data warehouse by eliciting business and technical needs from Corporate Actuarial clients, translate and document needs into understandable requirements and manage scope and solution design to those requirements.
• Lead in meeting facilitation for requirements gathering sessions with Business SME’s (Subject Matter Experts) and IT, in gathering business and system requirements.
• Work collaboratively with Data Enterprise Architecture group to deliver best possible requirements solutions by demonstrating a comprehensive understanding of business tools & strategies, products, functions and processes, along with current and emerging IT products, services and methodologies, utilizing Agile Methodology and IBM’s IIA (Insurance Application Architecture) models, specifically “IIW” (Insurance Information Warehouse) Business model named “Bus Matrix” - Dimensional modeling approach.
• Trained in Agile Methodology and SCRUM process utilized for rapid project deliverables and development.
• Co-developed project management tool to track project sub-track tasks, hours, priority, % complete along with gantt chart to display task start and end dates.
• Translated business needs to business, data, and reporting requirements, by working closely and effectively with customers, development teams and outside services.

Confidential, Farmington, CT

Sr. Business Analyst

Responsibilities:

• Attended weekly client meetings with project leader and developer to discuss new project status, production issues, and requirements needed for upcoming software releases.
• Analyzed all client support documentation to assist in gathering business and functional requirements for documentation.
• Developed business and functional specifications for client website redesign integration, website password resets, and client single sign-on.
• Performed system and regression testing, requirement analysis, and automation strategy and scripts.
• Worked with developers, UAT & QA teams to discuss web changes and Use Case testing for software releases based on business and functional requirements documented.
• Participated in meetings with outside vendor to discuss web guidelines and standards for redesign integration project.

Confidential, Bridgeport, CT

Sr. Business Analyst / Jr. Project Manager

Responsibilities:

• Lead in the development of reporting requirements specifications for Business Objects development for Consumer loans vendor package.
• Review Data Warehouse designed data models for new customized reporting data needs and to analyze the entity relationships between databases within the enterprise DW for future Business Objects reports.
• Developed new reporting requirements template for People’s Bank Business Analysts to support in best practice and process methodologies for IT.
• Independently lead communication with outside vendor in the facilitation of enterprise wide business reporting requirements gathering work sessions with business users and IT. Assisted capturing business purpose/needs and field requirements of over 1,700 existing production reports and new customized reports.
• Lead in the development and enhancement of Implementation project Operational Reporting Issues database for issue prioritization and resolution.
• Responsible for analysis and documentation of Business Objects production reports.
• Lead JAD facilitation sessions between vendor and business areas for reporting requirement specifications, discuss and documented open issues for future specification meetings with business areas and develop meeting minutes to send to facilitation meeting participants.
• Reviewed reporting sub-project deliverables from vendor and internal IT, to identify and discuss issues in a timely manner with Steering Committee.
• Participated in and support the signoff of deliverables from vendor and PUB stack holders.
• Monitored overall activities of the project to provide status to Steering Committee.
• Managed detailed assignments of Business Analyst team members, to ensure that assignments are sequenced properly and that team members understand project milestones.
• Independently lead JAD facilitation sessions on technical application requirements and data requirements.
• Lead the facilitation process of project activities and ensure they are on schedule, within budget, and completed with acceptable quality.
• Generated administrative documents (e.g. Status reports, timesheets) as required by the project.

Confidential, Bristol, CT

Sr. Business Analyst

Responsibilities:

• Assisted in the development of functional requirements documentation and overview for Confidential ’s Business Analysis team.
• Developed the functional requirements template for Confidential Business Analysts to support a Research pilot project and enterprise project delivery documentation standard.
• Lead in the development of OOAD documentation of Use Case techniques for Confidential ’s Business Analysis team.
• Lead in the development of a Business & User IT Assessment for gathering knowledge of new technologies, business process methodologies and approaches that aligned with the business initiative Project Phoenix.
• Assist in analyzing and evaluating Use Cases for Research pilot project.
• Lead in the development of Vendor Assessment overview procedures and requirements for Confidential senior management and business steering committee.
• Lead in the development of JAD session facilitation meeting materials standards and formats for business requirements gathering sessions.
• Lead JAD facilitation sessions for Confidential functional areas for requirements gathering meetings, to review multiple business functional area’s current workflow processes, discuss and document new system requirements needed for participation in a Vendor Assessment, develop current/updated business context process flows, perform scribe functions for other JAD sessions, document action items, open issues for future review meetings with clients, and develop meeting minutes to send to facilitation meeting participants.
• Lead in the development of the Customer site Evaluation materials for the Vendor Assessment to be utilized by Confidential senior management.
• Assisted in the development of the Vendor Assessment system process scripts for vendor demonstrations at Confidential corporate site.
• Assisted in the development of the Vendor Assessment’s vendor demonstration evaluation scoring data statistics and presentation for Confidential senior management.
• Managed business analyst project deliverables and track time and status of workload.
• Assisted in evaluating Requirements Tracking Tools, such as RequisitePro, and present results to management.abbatical
• Attended IT Project Management web seminar course
• Attended Life Insurance Producer and received State of CT Insurance Producer License.
• Developed and documented business, technical requirements, including cost-benefit analysis of a church website for Immanuel Missionary Baptist Church in New Haven, CT. Facilitated meetings and reviewed requirements with presiding Pastor and leaders of the church. Generated meeting minutes and discuss next steps in the project.
• Committee Member of New Haven Academy High School - Strategic Planning & Management Committee.

Confidential, North Haven, CT

Sr. Programmer Analyst

Responsibilities:

• Develop and documented business requirements and functional specifications for Healthcare Insurance Case Management and Financial systems, by providing analysis, design, coding, testing, and change management controls for a series of deliverables that supported the strategic business initiatives to consolidate acquired business systems.
• Actively involved in all aspects of business processes and implementation design.
• Lead the processes in the development of functional specifications and supporting documentation for a vendor data validation module, which evaluated data received into a usable format for processing to be utilized by any system to support the processing of claims.
• Provided production support for Case Management and Premiums financial systems through research, testing, problem solving, and interacting with customers, and other interdependent areas.
• Actively involved on HIPAA team to developing requirements and workflow changes for Provider Request & Response HIPAA 276 (TX) transactions.
• Ability to support multiple systems and tasks concurrently, while meeting deadlines to support project deliverables and timelines.

Confidential, rumbull, CT

Lead Business Analyst

Responsibilities:

• Lead project for customer service support departments, to define the business project scope and objectives based on user needs and a solid understanding of the web application and industry requirements to properly translate the business requirements for the technical system requirements, while providing an enterprise-wide business impact.
• Responsible for the development of business requirements gathering and supporting documenting technical system specification creation, analysis, design, and testing all user test case scenarios for configuration and design.
• Lead cross-functional team communication for Marketing, Customer Service, and Information Systems in coordinating current Ecommerce projects and identifying key links required between business users and functions to achieve goals.
• Contribute to develop documentation for automation and testing web application for customers and IT.
• Analyze web performance Web Analyzer tool and present results to management.

Confidential, Bridgeport, CT

Data Analyst

Responsibilities:

• Actively involved with Data Warehouse modelers to develop logical and physical table designs, metadata, and user acceptance testing procedures.
• Developed SAS, mainframe, and utility programs to extract operational systems that contain the source customer data for the extraction, translation, and load (ETL) process into the warehouse.
• Produced data field frequency using SAS, for data validation techniques across operational systems, which required field-by-field comparison, mapping fields in the data mart using transformational rules to populate the data mart.

Confidential, Hartford, CT

Information Systems Analyst

Responsibilities:

• Developed and maintenance Cobol-II, CICS, and DB2 mainframe programs for ACH customer EDI transmission activity processing, reporting and remediation testing procedures.
• Responsible for creating Easytrieve client reports for daily and weekly EDI transmission processing.
• Participated in remediation testing of CICS table maintenance and batch system reporting of EDI Gentran system for Y2K business initiatives.

Confidential, West Haven, CT

IT/Business Project Manager

Responsibilities:

• Established and maintained project plans for all functional areas and departments within Marketing, tracking all project business and IT resources, tasks and deliverables, assuming a leadership role in all project components.
• Worked with IT architecture groups and outside Vendor to develop project technical architecture frameworks and standards using RUP Use Case methodology, hardware and software requirements, capacity planning and performance management to ensure an innovative solution utilizing new technologies.
• Lead and promoted cross-functional communication, by identifying key links required between people and functions to achieve goals.
• Participated in Vendor JAD sessions for new strategic project with marketing business user and IT, to identify business and functional requirements and data for new application.
• Interviewed resources and attended briefings with Vendor to discuss project objectives, deliverables status, contractual obligations, level of service, consulting and services, and whether the vendor is consistent with the strategic goals and objectives of the business area.
• Attended OOAD with IT personnel to establish RUP methodology and standards for use-case modeling of business functions.
• Coordinate and participate in use case analysis and design with client project teams and technical development teams.
• Provided on-going system support to analyze and implement technical solutions to resolve business issues.
• Developed RFP standards for vendor contracts and project plans for senior management.
• Responsible for co-leading a Strategic Contracting re-engineered business process project budgeted estimates ($3 million) and a major senior management strategic initiative.
• Strategic Contracting new development project utilized multi-tier architecture (Oracle 8.0, VB, Netscape Browser and OOAD process & tools).

Confidential, New Haven, CT

Sr. Programmer Analyst

Responsibilities:

• Develop and support new and existing customizations using Cobol II, CICS, MS/Access, Easytrieve Reports, and Interfaces to Payroll & Benefits application systems, including Paid-Time-Off sub-system.
• Provided 24/7 on-call system support to proactively address and resolve all production issues, configuration modifications and design of all HRMS application systems.
• Ability to work independently with Payroll clients and functional team members for problem resolutions, understanding of payroll process and sub processes including time entry, payroll calculation, distribution and reporting, and updates to the system for governmental regulatory changes.
• Responsible for installing, configuring, documenting and of Payroll check writing system for printing to multiple organizations.
• Responsible for designing, testing and implementing EEO executive reporting and statistics.
• Responsible for configuring, implementing, documenting and of Human Resources CICS based report writer.