Jared Bruns Email & Phone Number

Kansas City, Mo, Us

Columbia, Missouri, Us

• Work with product teams to properly implement data standards on new and evolving projects.• Design and develop the response processes related to California Consumer Privacy Act (CCPA) requests. Execute data analysis to identify CCPA-relevant data throughout VUHL systems. Develop a process to determine the presence of a customer in VUHL systems based on name, address, phone number and email search inputs. Develop a process to collect and provide relevant data to VUHL audit and legal departments.• Lead the selection process for company-wide data modeling tool, including defining selection criteria, evaluating candidate software for fit, and making final recommendation.

Bentonville, Arkansas, Us

Central Operations• ETL Designer / Developer – Design, develop, implement, and support complex processes to extract data from Teradata, IBM DB2, Hadoop Hive, Google Cloud Platform, Quickbase, and Microsoft SQL Server database environments; transform data using Alteryx, SQL Server Integration Services, and Talend; and load data to SQL Server environments. Evaluate source and target system database designs to optimize utilization of existing indexes by the ETL process.• Data Architect – Create relational data models and star schema designs for Teradata, SQL Server. Analyze data requirements to create database designs that address the identified needs. Analyze use cases to refine database designs to meet performance expectations. Ensure compliance with naming standards and overall design approach. Tools include ERwin.• Database Administrator – Design, develop, implement, and support SQL Server stored procedures and table partitioning strategies to facilitate efficiency and minimal end user impact by ETL load processes. Implement database designs. Create database sizing estimates. Monitor and manage disk space utilization. Create and implement data backup and archival strategies.

Ashburn, Virginia, Us

Clients and roles included:Walmart Stores (Asset Protection)• ETL Designer / Developer• Data Architect• Database Administrator• Project ManagerWalmart Stores (Store Operations)• Project Manager• Business AnalystThe Walt Disney Company• Project ManagerAmgen• Data Modeler• Business AnalystWalmart Stores (Information Systems Division)• Business Analyst / Subject Matter ExpertWalmart Stores (Store Operations)• Test ManagerDevon Energy• Project Manager• Business AnalystVale INCO• Team Lead• Business Analyst Blue Cross Blue Shield of Michigan• Project Manager• Data Modeler• Business AnalystBritish Petroleum• Project Manager• Technical Team Lead• Data Modeler• Business Analyst

Houston, Texas, Us

Sprint Wireless• Data Analyst / Business Analyst – Gather and analyze requirements to include wireless customers in a billing system conversion project. Create and maintain a project plan. Complete gap analysis to determine how existing conversion processes must be modified. Facilitate meetings with representatives from external systems to review the conversion process and identify impacts. Facilitate meetings with vendors to discuss requirements. Create process flows to detail conversion requirements for application developers. Create test cases.• Data Architect – Create logical and physical data models to support the input and tracking of test cases, detailed test conditions, and testing results for a billing system conversion project.• Data Architect – Create logical and physical data models to support auditing and progress reporting for a billing system conversion project. Tools include ERwin 3.5 and Oracle 8i.Sprint Long Distance• Data Architect – Create a dimensional data model utilized to track the provisioning process of incoming orders for a home-based broadband product. Facilitate requirements gathering workshops. Create source-to-target mapping and report data element mapping documents. Conduct data model walkthrough sessions to facilitate knowledge transfer to business users, application / report developers and database administrators. Assist report developers with user acceptance testing issues. Discuss and recommend approaches utilized by the ETL team.• Data Architect – Create logical and physical data models to support a circuit inventory database. Interview business and technical subject matter experts to gather data requirements. Conduct data model walkthrough sessions to facilitate knowledge transfer to business users, report / application developers and database administrators.

Miami, Florida, Us

Verizon• Data Architect – Create, validate, and document the dimensional database design for a financial data warehouse at a Global 500 telecommunications company. Gather and document data requirements through interviews and workshops. Negotiate and create written interface agreements with source system subject matter experts to establish flat file formats for all pushed data.

Madrid, Es