Jan Davidson Email & Phone Number

Seattle, Wa

Authored new and updated existing detailed level requirements documents for modifications to Oracle’s RMS and SIM packagesDeveloped data validation requirements for conversion testing for software upgrades, including source to target data mappings Triaged and researched conversion incident reports from stores, working with store, business, and development team to resolve issuesWorked with Business users to determine acceptance criteria, thresholds and tolerances for data conversion validation reportsProvided assistance to users and production support on questions and issues regarding software usagePrepared BOL Audit reports for stores, and researched discrepancies between RMS and SIMCollaborated on knowledge base articles and training materials on software upgradesDesigned validation reports for converted data, and presented to stakeholders for approval

Redmond , Wa

Converted user stories into annotated mockups defining functional and technical specifications, business rules, and data requirements for applications on SharePoint and Team Foundation Server platformsParticipated in backlog grooming, prioritizing, and estimating sessions to scope quarterly releases, and updated user storiesConducted impact analysis of new requirements on current and future state of system processesDesigned test plans and test cases for web sites, pages, web parts, upgrades, and forms for bi-weekly sprints for new development and regression testingParticipated in bug triage and prioritization Led mockup review sessions with customer and technical team to ensure requirements are clearly defined, and technically feasiblePrepared and presented demonstrations of new functionality to end usersDesigned master requirements document for UIs and formsDeveloped Release Cycle Process for quarterly release cycleAuthored SQL queries to validate test resultsAdded pages and performed basic administration tasks in SharePoint

Seattle, Wa

Designed test cases for automated test scripts for mainframe conversion projectCollaborated with jail staff on test data requirements, and reviewed test cases to ensure data selected satisfies test case requirementsDesigned tracking documents for test cases and user credentials, and maintained multiple test case lists to ensure test cases are properly tracedDeveloped Excel Macros to perform counts and comparisons between tracking documentsAuthored end-to-end and user acceptance testing test plansAuthored Test Plan for new booking sheet printing process, and trained corrections officers on testing process and proceduresDesigned strategy for security testing

Seattle, Wa

Developed all business, user, functional and non-functional requirements for financial system upgrade;Authored User Stories and maintained linkages; Created gap analyses, workflow and data diagrams;Gathered testing requirements, designed Master Test Plan and related testing deliverables.

Seattle, Wa

Gathered, clarified, and finalized business and technical requirements for new enterprise-wide, Web-based application; Authored business requirements and functional specification documents for both cross-functional processes; Led project to determine and finalize requirements and specifications for data conversion, harmonization, cleansing, and rationalization, and the surrounding business processes to implement the migration strategy; Planned and conducted usability testing sessions for end-users, including instructional materials, practice cases, and functionality demonstration; provided feedback to the Project Team; Researched and authored functional specifications for electronic records storage and electronic signatures in compliance with the FDA’s 21 CFR Part 11 and Part 56; Authored Excel VBA Macros to expedite report generation; net time savings: 3 hours to 2 days per report; Developed and presented Macro Training class for staff; Collaborated with QA team on bug identification, cause determination, and repair requirements, and assigned to developer for fix; Identified database issues, including duplicate entities and properties, data type mismatches, and referential integrity issues, and communicated solutions to data architect for implementationAuthored Use Cases to define user requirements, after holding use case gathering and definition sessions with project stakeholders; Designed user interfaces, including external portals, Web pages, query listings, forms, work spaces, and user dashboards; Contributed to and reviewed technical design document to ensure the technical design captured the functional specifications

Seattle, Wa

Developed SQL queries to extract data from warehouse for analysis of production and operational data for mobile application; created ERD and data dictionary for data warehouse; suggested refinements to data warehouse to improve query performance; created road map for implementation of SSRS

Bellevue, Wa

Authored functional specifications for addition of data elements to Enterprise data warehouses from transactional and other warehouse sources; Authored functional specification for HANA pilot project; Authored functional specification for new Marketing Analytics data repository; Co-designed configuration engine to allow the creation of new Marketing Campaign Take types by Business users; Identified issues with Business processes for campaign metadata, and developed mitigation solutions to create a synchronous update process; Designed solution for Take determination metrics to provide Business users with a process for configuring and maintaining new Take types; Deconstructed metrics for data requirements; Functioned as EIT Marketing Analytics team primary point of contact for internal customers and external software vendors to facilitate and expedite the clarification and definition of business requirements and data availability; Developed initial design of data warehouse for HANA project.

Authored functional specification & database requirements documents for User, Role, & Resource provisioning; designed UI for provisioning; designed Requirements Traceability Matrix; Authored Gap analysis for UI and database;

Redmond, Wa

Designed new reporting workbook, reducing the number of workbooks from 6 to 2, and report generation time from > 2 hours to 30 minutes; developed VBA Macros to process source data and generate report; designed report for new fiscal year and authored instructions on report generation and contents.

Redmond, Wa

Analyzed data sources for latency conflicts in metrics' data & adjusted report algorithms to mitigate conflicts; Identified new data source for report calculation fact to increase reliability of metrics' estimate; trained and mentored new project manager on requirements gathering and documentation; redesigned data mart to eliminate unnecessary data redundancy and reduce referential integrity issues

Redmond, Wa

Audited and documented global business scorecard, its formulas, data and look-up tables;designed process and Excel templates for closing scorecard; collaborated with global field managers on closing process, and scorecard metrics flow and relationships; analyzed data for field managers to determine results causation, and created scenarios for modeling data to determine potential adjustments and their projected affect on the scorecard metrics

Issaquah, Wa

Provided ETL solution for data conversion of ERP project to consolidate and integrate master and application data from legal and existing systems to a newly designed solution of integrated sub-systems; authored functional specifications for data conversion, including source to target data mapping; designed template and instructions for data cleansing and transformation rules; received "Above and Beyond" award

Provided solution to automate, as far as feasible, the data management of an internal-facing customer system; Gathered requirements and business rules for data scrubbing and analyzed existing manual process; Authored combined business requirements, functional, and technical specification; Developed SQL queries to extract data for analysis; Developed VBA for Excel Macro solution to Highlight possible duplicate records; Link parent company to its subsidiaries; and Identify potential revenue records – 20.7% of total records; Designed new business process for data management based on automated solution; Developed metrics framework for records identified and corrected; Implemented solution, including training of Canadian staff

Created initial operational and business metrics scorecard for online advertising services, integrating data from different business sources, allocating data by functional, operational, business, and reporting units, presenting data in a meaningful format allowing access to the raw data, and providing metrics updates if the underlying data changes; Gathered scorecard requirements from managers; Obtained data samples and analyzed extent, contents, meaning and format of existing data; Wrote scorecard specification, with Excel prototype, including algorithms for aggregate and allocated data; Crafted scorecard in Excel, using links to provide both access to and updates from the raw data; Developed SQL queries to pull report data; Authored instructions for monthly scorecard preparation, including data source timeline for receipt and processing of data, reporting workbooks for data providers, and where used listing of all formulae with a description of a formula’s individual members.Developed Web-based solution for Community Service Team to maintain records on events, customer participation, customer base, and customer satisfaction; portable to external events, and accessible to customers for event sign-up; Gathered requirements from business, IT, and Security; Authored business requirements document, functional, and technical specifications; Lead JAD sessions with business and IT; Designed Web-based application, including internal- and external-facing user interface; SQL database schema, application architecture; security framework; and, reports.

Created management scorecard using sources from multiple systems for global metrics on product support engagements; Gathered metrics requirements from senior management; Mined newly implemented data warehouse, using SQL Reporting Services to extract data and export to an Excel workbook; Collaborated with warehouse development team on scorecard requirements inclusion; Developed VBA for Excel Macro to generate scorecard from raw data; Collaborated with worldwide operations staff to craft process that mitigated data errors and redundancies by 90%; Documented scorecard and macro for preparation and support.

Documented and created policies and procedures for test automation lab and provide support to test customers; Authored service level agreement, and processes and procedures documents; Designed on-boarding methodology for new lab customers, decreasing on-boarding time by two weeks and on-boarding errors by 99%; Analyzed machine usage metrics which reduced test scheduling conflicts; Developed metrics for lab operations.

Designed Web site and Web-based application to maintain data on members, volunteers, and contributions for start-up nonprofit organization; gathered and documented requirements; designed SQL database; Created Web site plan and map, featuring customer maintainable content; developed Excel application to collect online contribution data processed by third-party vendor, and upload to server-side SQL database; Designed BI module using both Web-based and Excel reports; Developed application; Authored online help and documentation for application; Managed project.Developed application and database to maintain campaign records; Crafted solution of Access (database and front-end) and Excel (reporting); Designed database schema, user interfaces, and reports.Designed and developed Web sites for customers; Gathered customer’s requirements; Authored project plan; Designed Web site plan and map, featuring customer maintainable content; Collaborated with graphic designer on site aesthetics and image requirements; Trained customer on how to maintain site’s content using TWS’s tool.