Business Analyst
Hanover, Md, Us
Providing analyst expertise for the companies digital transformation into an Enterprise Information Warehouse (EIW). Responsibilities include collecting requirements and documenting them via BRD's or User Stories, which include business, expected results, source to target data mappings, data transformations, and reporting needs. Coordinate with Technical team members to build out the requirements, identify gaps or issues, and unit test changes before migrating to QA. Create and review QA and UAT test cases for each functional requirement/user story and coordinate system testing as well as assisting business during UAT testing. Troubleshoot defects found in testing to determine root cause and fix. Identify requirements to extract source system data from; S21 (Canon Inc. built ERP), IBM Websphere, and other business critical systems into EIW staging layer. These systems contain data for: Contracts, Customers, Invoices, Orders, Parts, Products and Repairs.Document transformation rules to be applied to data loaded into Data Warehouse layer. These rules include business and data standardization logic that normalizes the data. The data contained in this layer is used to create business specific data views and to build the Business Objects Universes upon.Canon had the need for sales related data for Sales Planning purposes. As we had the data already sourced, I worked to identify data mappings and transformation rules, which established the ETL process to extract the needed data and drop the results into a Google Bucket for the Sales Planning team to pickup. Depending on the data, the team established daily and near real time loads to continuously to provide updated data.