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 accomplishment 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.
• 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

Sr. Business Systems Analyst

• Responsible for eliciting requirements and documenting business and functional requirements for WellPoint health insurance Data Exchange team, which provide requirements and mapping specification for WellPoint third-party vendor and State Mandate APCD All Payers Claims Database extracts from WellPoint's Enterprise Data Warehouse.
• Primary accountability for gathering business functional requirements for WellPoint 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

Sr. Business Analyst

• Responsible for eliciting requirements and documenting business and functional requirements for Sports Data Repository SDR data warehouse and its related services which provide the vast majority of real-time sports data for ESPN Studio broadcasts and ESPN.com Digital media departments incl. Mobile . Provide facilitation and JAD working sessions with technical and business teams to assist in requirements gathering and documentation in the discussion of: Sports Feeds, Overnight Loads, Front-end tools, and database processing.
• 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

Sr. Business Analyst

• Responsible for SOA consultation to the internal and/or external customer for Loyalty web-based projects, while providing expert technical knowledge and understanding of the business unit's systems, capabilities, and respective technologies for Delta.com and other web service customers of Delta Airlines. Prepare specified project documentation according to Delta Technology standards. Assist in business process redesign as needed. Maintain communication with customer and team members and promote a team environment.
• 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

Business Analyst

• Responsible for providing business analysis for Ecommerce applications: including requirements gathering, scope definitions for company subsidiary Brand Magnet affinity loyalty web services to online customers. The web services included Eligibility Enrollment, Billing, Reporting Statistics, and Customer Service using .NET and API web infrastructure.
• 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 Membership 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

Sr. Business Analyst

• Responsible for providing business analysis, including requirements gathering, scope definitions, and Test Strategies Plans for Property Casualty Insurance for Commercial Lines of business Actuaries in support of traditional production applications such as Ratemaking, Scoring, Pricing and Profitability monitoring reporting systems using Teradata/Oracle databases.
• 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 code
• for Commercial Lines Data Warehouse requirements' transformation rules as well as documenting
• outstanding 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

• Sr. Business Analyst Responsible for providing business analysis in the design and delivery of conversion and migration of forms, discussion databases, issue databases, team rooms, and document libraries from Lotus Notes to Microsoft SharePoint solutions an enterprise wide-solution in conjunction with migration to MS Outlook.
• 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

• Sr. Business Analyst Commercial Lines Data Warehouse Responsible for providing business analysis for requirements gathering working sessions for Property Casualty Commercial Lines Data Warehouse. The project impacted various customers from Claims, Pricing, Reinsurance, General Liability, and Specialty business for documentation of business and functional requirements.
• 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

• Sr. Business Analyst May 2008 July 2008 Responsible for developing business and functional requirements for the support of several web-client server based healthcare insurance applications. Performed requirement elicitation, analysis, web page prototyping design using Axure RP Pro5, SNAG-IT, and documentation of the business and functional requirements. Coordinate with Quality Assurance team and participate in test plans, test cases, for overall test/requirements to validate web healthcare applications content and process.
• 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

• Sr. Business Analyst / Jr. Project Manager Responsible for developing business reporting requirements for the support of an offshore-vendor Implementation reengineering project of the enterprise banking system, by performing project management, analysis, design, and documentation of business and functional requirements utilizing the Data Warehouse for Mortgage Loans and enterprise Banking systems.
• 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

• Sr. Business Analyst Responsible for analyzing and developing business and functional requirements for a new project process delivery system to support the re-engineering of ESPN's Cable Network Control System for Programming, Advertising Sales, Production, Commercials, Research, and Customer Systems areas. Manage project delivery standards and methodologies, business processes, tools, and techniques to ensure quality enterprise delivery standards utilizing requirements gathering sessions to develop test cases based on Use Case analysis, test plans and conditions to support Request for Proposals/Quotes and Vendor selections and system demonstrations.
• Assisted in the development of functional requirements training documentation and overview for ESPN's Business Analysis team.
• Developed the functional requirements template for ESPN Business Analysts to support a Research pilot project and enterprise project delivery documentation standard.
• Lead in the development of OOAD training documentation of Use Case techniques for ESPN'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 ESPN 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 ESPN 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 ESPN senior management.
• Assisted in the development of the Vendor Assessment system process scripts for vendor demonstrations at ESPN corporate site.
• Assisted in the development of the Vendor Assessment's vendor demonstration evaluation scoring data statistics and presentation for ESPN 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.

Sabbatical

• Consulting contract ended and time was taken off as a sabbatical to help immediate and extended family members with health issues.
• Attended IT Project Management web seminar course
• Attended Life Insurance Producer training 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

• Sr. Programmer Analyst Responsible for generating business requirement analysis, documenting functional specifications, developing, testing, and implementing specifications in Cobol II, DB2, IMS, and HIPAA transactions for Healthcare Utilization Case Management System and Financial Premiums System. The Utilization Case Management System was designed to identify patient authorizations for claims processing. The Financial Premium System was designed to post itemized billed premiums to General Ledger.
• 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

• Lead Business Analyst Responsible for generating functional specifications, analysis, and web design of the Oxford Health's Corporate Internet website, to utilize the Doctor/Provider search tool for external customer and Broker members.
• 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 training documentation for automation and testing web application for customers and IT.
• Analyze web performance Web Analyzer tool and present results to management.

Confidential

Data Analyst

• Responsible for data analysis, data mining, design, and implementation of the initial project phase to provide an enterprise-wide CRM Data Warehouse for Domestic International clients, to support the strategic goals of the business.
• 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

Information Systems Analyst

• Responsible for analysis, design, coding, testing, and implementation for Y2K revisions and remediation testing of Advantage EDI Gentran Commerce application, also provided client ACH processing enhancements for new banking EDI customers.
• 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.

IT/Business Project Manager

• Responsible for project management, analysis, design, and recommending innovative technical solutions for re-engineered business processes of current and future business projects for web-client application under multiple hardware and browser platforms. Responsible for evaluating large, midsize, and small projects, requesting resources and budgets, presenting IT department priorities, maintaining project requests and allocations to senior management for Pharma Division's Customer Products - Sales Marketing clients.
• 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 training services, and whether the vendor is consistent with the strategic goals and objectives of the business area.
• Attended OOAD training 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

• Sr. Programmer Analyst Responsible for generating business requirements, documenting functional specifications, coding, testing, and implementing specifications for Human Resources HRMS Payroll Benefits application systems.
• 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 training 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 training of Human Resources CICS based report writer.