Candidates About

 

                Malcolm Rattliffe                                                                      

Business and Information Technology

SELECTED HIGHLIGHTS

 

Certified Business Analyst Professional (CBAP), with over 14 years of experience gathering and creating business, functional and data requirements for end-to-end analysis, development, testing, and implementation within an enterprise level environment.  

Member of the International Institute of Business Analysis (IIBA).

 

CAREER TRACK

 

Flexion Consulting/Sage Group                                                       November 2017- Current

QBE Insurance

Madison, WI

 

Sr. IT Business Systems Analyst

• Gathering and writing business and functional requirements for the data lake project
• Meeting with global stakeholders to help determine and understand the data lake architecture
• Assisted in gathering data for the Data Governance framework
• Make suggestions to enhance data quality, analytics & accuracy
• Training new data stewards in the understanding of MDM and RDM
• Designed data model for reference data
• Coordinated with stakeholders from Infrastructure team and Orchestra Networks to define Dev, Test, UAT and Production environment needs
• Creating user stories, use cases and acceptance criteria
• Responsible for working with the business to extract information necessary to complete concise requirements
• Establish relationships and business strategies within the organization
• Determine strategies to standardize business processes across the organization
• Responsible for maintaining constant contact with stakeholders
• Responsible for creating project estimates
• Responsible for creating project scope and business cases
• Responsible for tracking project tasks and costs
• Interview stakeholders about their current needs and processes

Environment: Waterfall and AGILE Methodologies, MS Office Suite

 

 

 

Quantum Technologies                                                                     November 2016- June 2017

Milwaukee, WI

 

Sr. IT Business Analyst/Lead Performance QA Analyst

• Gathering and writing business and functional requirements
• Developing ETL test cases for data warehouse
• Creating automated test scripts with Rational Performance Manager
• Creating user stories, use cases and acceptance criteria
• Assisting in building RFP documentation
• Responsible for vendor management
• Responsible for working with the business to extract information necessary to complete concise requirements
• Establish relationships and business strategies within the organization
• Determine strategies to standardize business processes across the organization
• Responsible for maintaining constant contact with stakeholders
• Responsible for creating project estimates
• Responsible for creating project scope and business cases
• Responsible for tracking project tasks and costs
• Writing test cases and test scripts
• Assist business in UAT
• Interview stakeholders about their current needs and processes
• Make suggestions to enhance data quality, analytics & accuracy

Environment: Linux, HP ALM,, Lean 6 Sigma, Rational Performance Manager, Waterfall and AGILE Methodologies, MS Office Suite

 

RCG Global Services (Johnson Controls)                                      August 2016- October 2016

Milwaukee, WI

Sr. IT Business Analyst, Data Analyst

• Participated in a road map study at JCI Power Solutions
• Responsible for aggregating marketing research data for analytical reporting using Tableau
• Study was to come up with a plan to align all Big Data onto one platform
• Supply Chain Management
• Analyzed multiple source systems housed in Salesforce, SAP ERP, QAD EE
• Interviewed stakeholders about their current BI visualization tools and processes
• Made suggestions to enhance data quality, analytics & accuracy
• Established relationships and business strategies within the organization
• Determined strategies to standardize business processes across the organization
• Developed strategies for aligning data within the data warehouse eventually placing data into the data lake
• Responsible for gathering data from multiple source systems using various data gathering techniques
• Responsible for running SQL scripts for data queries
• Responsible for SKU Rationalization Plan
• Responsible for maintaining constant contact with stakeholders
• Responsible for creating project estimates
• Responsible for creating project scope and business cases
• Responsible for project initiation
• Responsible for assigning project resources
• Developed WBS of major tasks
• Responsible for tracking project tasks and costs

 

Environment: SAP Finance, ERP, QAD EE, Netsuite Finance, Logility, Power BI, HADOOP, Python & R Data Retrieval Methods HANA, SAS, Tableau, MS Dynamics AX, COGNOS, Business Objects, Lean 6 Sigma, ITBM, CRM, Sqoop, HIVE, Salesforce, Waterfall and AGILE Methodologies

 

Horace Mann Companies                                                                 March 2015- August 2016

Springfield, IL

Sr. IT Business Analyst, BACOE Lead

• Continued establishment of the Business Analysis Center of Excellence
• Continued development of the BA’s within the company
• Establish relationships and business strategies within the organization
• Standardize business processes across the organization
• Working closely with marketing, business partners, stakeholders and third party vendors to business gather requirements for commission’s software to capture information which consisted of agent commissions (calculators, fees, etc.)
• Decomposition of Epics and User stories
• Provide Sr. level leadership support for all phases of testing
• Led User Acceptance Testing (UAT) effort for Release 2.5 for new line of annuity products
• Working with all Lines of Business, ie. Property & Casualty, Life products, Whole, Term and Indexed Universal Life
• As Lead IT BA developed the requirements and led the acquisition and implementation for the ITBM (Digital Fuel) software
  • Project Scope
  • Current State/Future State Analysis
  • Vision Documents
  • Stakeholder Communication Plan
  • Business Requirements
  • Functional Requirements
  • Process Flows
  • Developing RFP documentation
  • Managing vendor sessions

 

• Led the New Commissions project from E2E, developed all BA project artifacts
  • Project Scope
  • Current State/Future State Analysis
  • Vision Documents
  • Stakeholder Communication Plan
  • Business Requirements
  • Functional Requirements
  • Process Flows
  • Developing RFP documentation
  • Managing vendor sessions
  • Business Process Definition
  • Data Governance
  • Use Cases
  • UAT Test Plans
  • Implementation Plan
  • Worked extensively with the business area and data architecture team to identify processes needed throughout the enterprise architecture

·         Responsible for gathering information to support business rules

·         Documented process flows

·         Responsible for developing high level business requirements as well as functional requirements

·         Creating SOW’s

·         Use Cases, User Stories, Business Cases

·         Created documentation for end users

·         Responsible for creating Requirements Management Plan, risk management documentation, vision documents, scope document, interface documents, functional specs

·         Assisted in creating the SOW for different phases of the project

·         Wrote MS SQL Queries for data extraction

• Worked closely with business, technical and solution design groups for requirements elicitation
• Responsible for creating current state and future state documents for conversion efforts
• Responsible for process improvement activities
• Responsible for developing workshops and RFP’s
• Responsible for working with the Data Warehouse team to flush out requirements for the BDW

 

• 2016 HM Marketing Campaign
  • Responsible for creating surveys to attract new customers
  • Responsible for gathering and managing source data for new customer capture
    • Demographic
    • Survey
    • Current behavior
  • Responsible for creating reports, charts, graphs using Tableau, PowerPoint, and Excel

 

Environment: ITBM, FINANCE, McCamish VPAS, Guidewire, Salesforce, MicroSoft Dynamics (ERP), AGILE/SCRUM Methodology, COGNOS TM1, COGNOS 10, Tableau, Business Objects, MS Excel, MS Dynamics, Mainframe, DB2, SQL Server, ETL,  Informatica, Selinium, Lean 6 Sigma

 

NTTDATA                                                                                           May 2013 – March 2015

Bloomington, IL

 

Sr. Business Analyst / Data Warehouse Analyst

Tennessee Farmers Insurance (September 2014 – February 2015)

·         Responsible for gathering business requirements for conversion to technical requirements and integration efforts for Data Warehouse team.

·         Responsible for data migration from legacy BI to SAP ERP

·         Responsible for all project documentation needed for onboarding new analysts and testers; ie. Requirements document, Risk Management documentation, Vision documents, Interface documents, functional specs

·         Worked with data warehouse team analyzing data during conversion efforts

·         Created integration documents for testing strategy and test planning.

·         Assisted in creating the SOW for different phases of the project

• Used Lean Six Sigma methodology to audit processes
• Created automated test scripts with QTP
• Used QuerySurge to help automate ETL and Big Data processes within the Data Warehouse
• Assisted with writing test plans and test cases using HP ALM to integrate with Quality Center

 

Environment: Guidewire, AGILE/SCRUM Methodology, SAP Financials, Use Cases, Business Cases, Crystal Reporting, Business Objects, MS Dynamics, Power BI, HP ALM, Python, Mainframe, DB2, Oracle, Brio-Hyperion, SQL Server, HP/Mercury Quality Center, ETL, DMFI, Informatica, SAP ERP, QuerySurge, Big Data, Sales Force, Duck Creek Software

 

Sr. Data Warehouse Business Intelligence Analyst, Data Analyst  - Property and Casualty/Commercial Lines

State Farm ( May 2013 – September 2014)

• Met with business partners and stakeholders to gather business requirements for reporting systems. 
• All reports designed in Business Objects and COGNOS 10 BI
• Specified and analyzed business goals/requirements, functional requirements, system interface requirements, reporting requirements, data requirements, non-functional requirements and business rules
• Supported data warehouse team analyzing incoming data from third party vendors
• Created functional requirements for data warehouse team
• Assisted Technology Solutions teams in documenting scope, defining gaps and updating implementation estimates
• Assisted in scope management and change control
• Supported all implementation teams for the life of the implementation.
• Supported development activities for new and existing clients

Scrum Master

• Scrum Master Base Requirements
• Support the product development process
• Facilitate project planning
• Daily stand-up meetings
• Reviews, retrospectives
• Sprint and release planning
• Demos, and other activities as needed
• Track and communicate team velocity and sprint/release procedures

 

Environment: AGILE/SCRUM Methodology, Informatica, Oracle, SQL SVR, Use Cases, SAP, Business Cases, COGNOS TM1, Business Objects

Software Business Analyst                                                            November 2012 – January 2013

Phoenix, AZ

Project ended due to lack of support from business partners

CVS/Caremark  

• Met with major parties to gather business and technical requirements for Medicaid/Medicare health care reform for system conversion
• Served as liaison between business and development for functional requirements elicitation
• Created traceability matrices, use cases, context and relationship diagrams
• Created SQL scripts

 

Environment: UML, AGILE/SCRUM Methodology, Use Cases, Manual Testing; Automated Testing, Visio; MS Visual Studio, HP Quality Center 10.0, DB2/COBOL, MS SQL, Team Foundation Server, VS Test Professional 2010, Duck Creek, Rational Quality Manager, ClearQuest, Clear Case, Requisite Pro

 

KFORCE                                                                                   November 2010 – November 2012

Milwaukee, WI

Software Business Test Engineer

True Process (July 2012 – November 2012)

• Analyzed and developed test estimates for mobile infusion devices.
• Developed test approach, strategy and scope.
• Created test cases and scripts for web testing and applications.
• Created automated test cases and scripts using Quality Center/LoadRunner.
• Participated in testing process improvement efforts.
• Assisted in requirements review for testability.
• Wrote MS SQL scripts to access test data.

Environment: IHE/HTML7, UML, AGILE/SCRUM Methodology, Use Cases, Manual Testing; Automated Testing, SILK, Visio; MS Visual Studio, HP Quality Center 10.0, MS SQL, Team Foundation Server, VS Test Professional 2010, .NET Framework, J2EE Test Environments, DB2 scripting (SPUFI)

IT Test Manager

Assurant Health (July 2011 – July 2012)

• Worked on HIPAA 5010, ICD10 and Medical Loss Ratio (MLR) Rebate Automation projects.
• Led a team of 4 BA’s and 11 QA Analysts
• Provided leadership and direction for testing project(s)
•  Partnered with Release/Program Manager and Test Leads on overall test approach, tasks and assignments for a project
• Provided leadership for data analytics
• Developed overall estimate for project(s) with estimates from Test Leads and Business Analysts; ultimately accountable for overall test estimate of project
• Reviewed and analyzed estimates provided by test leads for coverage and resource needs
• Experience in creating requirements through story boards (RTC) within an AGILE environment.
• Developed overall test strategy and approach for project (including all testing types-system, UAT, performance, end-to-end, etc.) with input from test leads and systems analysts
• Developed master test plan and obtain appropriate approvals
• Managed resource allocations for project(s)
• Ensured appropriate project/release meetings are scheduled (e.g., test lead, status)
• Partnered with other test managers/leads to ensure appropriate test coverage at the release level, including minor releases and production support
• Created Risk Management Plans
• Ensured project testing issues are resolved in a timely manner
• Reported overall test status of project
• Participated in testing process improvement efforts
• Ensured team is using AH testing best practices and following AH established testing processes
• Coached and provided direction to test leads and testers
• Experience in post-deployment activities for the project/release
• Created SQL test scripts to retrieve data
• Interfaced with BA’s and data architecture team on ETL procedures for data warehousing
• Experience with creating procedures for change data capture events, full and incremental data extractions with updates from OLTP’s to data warehouse

Environment: Data Modeling, UML, AGILE/SCRUM Methodology, Use Cases, .NET, Rational Quality Manager, ClearQuest, Requisite Pro, manual and automated testing, Visio, ORACLE SQL, AS/400, COBOL, DB2, File-Aid, ABEND-AID, CICS, HP Quality Center

QA Lead Analyst

Kohl’s Corporate, Milwaukee, WI   (November 2010 - July 2011)

• Prepared and executed functional and regression test cases
• Participated in performance testing
•  Worked with project management team, technical team and business units in the requirements gathering process to determine high level designs for Enterprise Resource Planning (ERP)
• Responsible for gathering requirements for the implementation of Logility (supply chain software)
• Communicated and interacted with different project teams
• Conducted testing and analysis on PeopleSoft General Ledger applications
• Defined test strategy based on the analysis of design document and requirements
• Monitored defects associated with project and worked with developers and project manager to help close defect
• Loaded and maintained requirements and test cases in Quality Center

 

Environment: UML, AGILE, Business Process Testing (BPT) Use Cases, Manual

Testing, Automated Testing, HP Quality Center, QTP/ LoadRunner, Visio, ORACLE SQL, SAP ERP, Crystal Reporting, JAVA Scripting, Mainframe testing, COBOL, DB2, File-Aid, ABEND-AID, CICS

 

Business Analyst Data Consultant Warehouse Team                February 2010 - November 2010

Dean Health Plan, Madison, WI

• Documented business, functional, and data requirements and communicated these requirements to the development team for design and implementation of business solutions
• Data staging and data mapping from source systems to data warehouse
• Communicated business priorities to the technology development teams in order to drive effective business solutions
• Set client expectations on Service Level Agreements, timelines and client tasks
• Summarized analysis from research performed and then presented conclusions to technical and business team members
• Responsible for analyzing test results and problem resolution
• Coordinated the process to analyze, evaluate, implement, and maintain systems developed internally and/or externally with an outside vendor
• Assisted in establishing end user training
• Facilitated JAD sessions

 

Environment: IEEE Standards, UML, Use Cases, Data Modeling, AGILE, Requisite Pro, Taskmaster Insurance Software, Informatica, HDMS, UNIX, LINUX, FACETS, QNXT, Visio, PL/SQL, ORACLE 10 SQL, MS SQL Server, Team Foundation Server 2008 R2

 

QA Analyst                                                                                        April 2009 – September 2009

ING Banking, ING Insurance, Minneapolis, MN

Was asked to return to project for 5 months to assist in testing.

 

Lead Business Analyst                                                                     February 2003 – January 2009

ING Banking, ING Insurance, Minneapolis, MN

• Led a team of 3 BA’s through initial requirements phase and development through final implementation
• Elicited, developed, coordinated, and maintained business and functional requirements for various projects and/or systems from the initial phase to final implementation; assuring requirements meet standards
• Interacted with users, other portfolios, vendors, and IT for full life cycle of a project
• Responsible for consultation to the internal and/or external customer
• Developed and managed user acceptance criteria.
• Communicated discrepancies determined in testing to impacted areas
• Worked with business partners and systems personnel to identify new business workflow or change current processes to enhance their effectiveness
•  Responsible for training users on current documentation for modified systems
• Responsible leading the business units to ISO certification
• Performed root cause analysis assessments
• Analyzed requirements (solution comments, design specifications, and other documentation) and creates test cases to exercise product functionality
• Provided management with requirements coverage analysis reports, test run results, and defect tracking reports.
• Worked with application development teams to participate in solution design to ensure testability of functions and applications
• Identified areas for improving efficiency, shortening of test cycles, and automation of test scripts

 

Environment: Peoplesoft, General Ledger, AR/AP, RUP (Rational Unified Process); Data Modeling; Medicare, Medicaid, UML, Finance, AGILE Methodology, Use Cases, XML, ESB, .NET, and J2EE Project Management, Rational Rose, ClearQuest, Requisite Pro, Manual Testing, Automated Testing, HP Quality Center/ LoadRunner, QTP, Visio, ORACLE SQL, Contract Management, Crystal Reporting, UNIX, LINUX, JAVA Scripting, SAP, Plexis Insurance Software, PL/SQL, AS/400, COBOL II, DB2, File-Aid, ABEND-AID, CICS

 

EDUCATION

Studied Computer Science, South University 2006

Chamberlayne Jr. College   AS CS, 1985

Quality Assurance Institute

Requirements Quest

 

CERTIFICATIONS

International Institute of Business Analysis since 2013

CBAP 2017