Charlotte Robinson Email and Phone Number

• Work with various business units to define, develop and deploy views with proper access, data freshness and logic calculations.• Work with multiple product teams to bring data available from API into access controlled views. • Create data source to destination mapping documentation with applied business rules for views.• Provide business user support to facilitate user adoption and usage of global enterprise warehouse.• Complete data validation across multiple sources, systems and timeframes for multi-year analysis - triaging through resolution any gaps or discrepancies.

• Translate business needs into business requirements document (BRD) and detailed requirements.• Triage eCommerce queue and resolve payment processing issues, access changes and requests.• Work with application teams and vendors to address integration issues and provide data findings.• Facilitate User Acceptance Testing and training sessions, including business approval.

• Translate business needs from strategy team into requirements and technical specifications.• Collaborate with architects, UX design team and leads to design and document feature solutions.• Lead hand-off meetings to provide solution specifications to teams for implementation.• Complete acceptance testing using front end as well as Postman for API calls.

Dashboards and Reporting • Develop queries and reports needed to complete ad hoc requests from business users.• Compile, aggregate, and communicate daily metrics for executives, customer and the field. • Investigate and find root cause of data discrepancies to ensure data integrity and accuracy. • Review, validate and publish Power BI dashboards and apps.• Verify reports/dashboards are refreshed and distributed as scheduled. Triage and correct issues.• Gather requirements from users and translate into user stories and requirements in Agile approach. • Review issues and requests from users and create Jira tickets as needed.• Document business rules and data mapping for migrating dashboards from QlikSense to Power BI. • Assist with migrating reports from Business Objects to Pentaho Report Designer.• Coordinate migration of customer reports from legacy system into new system.• Identify data and functional gaps between source and destination systems for migration.• Create project planning documents including project schedule, tasks and assignments.Data Warehouse• Coordinate across teams to define fields, logic and data for internal and external reporting.• Document source to target, field level definitions and usage of warehouse in Confluence. • Validate data migration/Pentaho ETLs from Postgres and Oracle databases into data warehouse.Process Improvement• Identify candidates and implement automation solutions to reduce manual processes.• Streamline reporting process by reducing manual steps and interventions. • Create business and data flows using Draw.IO and Visio.• Develop, document and complete audit procedures to comply with SOC 2.

Lender Integration• Develop and implement test strategy/plan for life cycle of applications for electronic submission.• Define data mapping and corresponding scenarios from initial application through lender decision.• Coordinate testing efforts with vendor to review supported changes within various systems.Reconciliation Project• Worked directly with business end users to refine data and system criteria.• Execute SQL queries to validate accounting data extracted and imported into vendor system.Paperless Invoicing/Operations• Participate in reviews to define requirements and workflow.• Defined pass/fail and acceptance criteria for vendor.• Completed integration testing for upstream and downstream systems.• Complete testing using internal, external and mobile setups.Online Reservation System• Provide Strategy, Level of Efforts and direction for test effort.• Provided direction, assistance, mentoring and estimates for onsite and offshore QA members.• Completed integration and data validation for desktop, mobile and native app.Employee Access Management• Worked with end users to define system requirements and workflow.• Partnered with developers to conduct testing in agile iterative approach.• Completed full end to end integration testing across multiple in-scope systems.Websites (Customer Portal/Sun Resorts/Sun Communities)• Developed and implemented Test Plan for websites based on business requirements.• Conducted internal and vendor data validation as well as Web Services validation using Soap UI.• Completed full end to end integration testing across internal and external systems.• Executed security validation test scenarios based on permission and business rules.• Completed end to end, system testing, reporting and data transition from legacy system. Process Improvement• Certify releases for production readiness and provide supporting metrics.• Implement templates and recommendations for process improvements across projects.

Incentive Programs for Automotive Client• Develop and implement Test Strategy and scenarios for project based on wire frames, process flows and business requirements.• Collaborate with project team as part of Agile Iterative approach.• Participate in release planning, review and retrospective.• Complete end to end, integration, report, system and regression testing for web based configurable incentive program via database and front-end. • Validate eligibility, accurate payments and tracking for individual programs. • Conduct messaging validation ensuring compliance via website/email/sms.• Validate re-certification process updates according to new guidelines.• Develop strategy with client for User Acceptance Testing.

eCommerce• Develop, obtain sign-off and implement Test Strategy and Plans for all releases based on user interactions and/or functional specifications.• Collaborate with project team as part of Agile Iterative approach for rapid deployment cycles.• Participate in sprint planning, review (Red/Green) and retrospective.• Coordinate and assign tasks for projects and maintenance releases.• Certify release for production readiness and provide supporting metrics.• Track and communicate progress, issues and milestones for QA effort.• Provide direction, assistance, mentoring and estimates for QA team.• Validate data/functionality transition from custom legacy system to Interwoven TeamSite for each of the four Brand Websites.• Facilitate inspections and sign off on all project documentation (Business Requirements, Functional Specifications, Technical Specifications, Test Strategy, Test Scenarios/Scripts) to find defects earlier in the life cycle.• Ensure QA Standards and Best Practices are being followed by team.• Oversee Release Process and ensure phase gate (Entry/Exit) criteria met.• Track and identify ways to improve defect removal efficiency rate using root cause analysis and post mortems.• Execute test plans and scripts for Maintenance and Emergency releases.• Design and implement HP Test Director/Quality Center structure for use with eCommerce applications. Ensure smoke scripts using Quick Test Pro are executed. Ensure load scripts using Load Runner are executed.• Provide and employ recommendations for process improvements for QA effort.• Coordinate integration testing among various systems and groups.Decision Support System (DSS)• Validated data migration from various systems into data warehouse.• Converted manual queries to batch files, greatly reducing validation time between environments.• Tracked, noted trends and reported changes between data updates.• Created Ad-Hoc Reports using COGNOS tool to simulate business use.

• Developed, obtained sign-off and implemented Test Plans for projects associated with external facing website and large corporate initiatives.• Provided high level QA direction, test plans and assistance for other teams. • Defined and tracked key Quality Assurance metrics; Gathered and compiled data in distributed monthly summary.• Decreased the number of documented defects found in production. • Conducted QA reviews for major projects, communicated results and provided recommendations for improving project status.• Coordinated test efforts among various groups and systems.• Managed multiple releases and coordinated the associated QA effort.• Interfaced with business client regarding requirements and standards.

• Developed, documented and implemented complete test suite for web based interfaces/databases for On-Site Cross Sell Project for Sears.com.• Analyzed test cases to define critical path and planned test strategy.• Executed and documented the complete system and regression test suite. • Documented procedures for Real-Time Miner as well as E.piphany.

• Defined and executed typical customer routines as test scripts.• Developed call scripts used in conjunction with network entity simulator.• Identified areas of possible overlap with other sections of the organization.• Verified customer documentation and Internet based help.• Identified openings (Escaped Defect Analysis) within current test cycle, which allowed software defects to reach customer.