Laurel Johnson Email & Phone Number

Minneapolis, Mn, Us

Stamford, Connecticut, Us

Arlington, Virginia, Us

In charge of analyzing and implementing data solutions needs for the organization. Interacted with a variety of business professionals to provide data that supports dashboarding and reporting. Managed custom application development and creation of delivery model strategies, as well as provide scalable services related to high performance reporting tools and infrastructure design.

Bloomington, Minnesota, Us

As a Sr Data Architect:• Designed and built out Type II Dimensions and Fact tables for several star schemas around the subject areas of Member Enrollment and Payments. Additionally, created and set data flow patterns utilizing SSIS for these structures. • Reverse Engineer current production SQL Server to document the production architecture and its’ content utilizing Erwin.• Worked with Sr Director to set standards and directions for EDW platforms including Data quality and testing, SLA’s, and setup of Development server on AWS for on-going development work.• Managing the SQL Servers as the acting DBA including production deployments, it’s security (setup of roles in active directory), DB Creations and any performance tuning.

Santa Clara, Ca, Us

Profiled, modeled, designed and developed a staging OLTP database with ETL processing utilizing Pentaho Data Integration jobs and transformations for Initial and Renewal Orders for a cloud-based SalesForce implementation for Hitachi. This project enabled the creation of Assets, Service Contracts and Entitlements to be used by the customer sales and services group. This included Design and Source-to-target (STM) documentation to ensure data flow and information accuracy and to uncover any gaps.• Created Business Analytic reporting and metadata modeling for master data management, operational data validation and error reporting for the data integration information. This integration project serves as a model to pull, transformation and push information in and out of SalesForce using a set of complex jobs and transformations.Upgraded a client from Pentaho 6.1 to 7.1 on a Unix VM platform.Performed a 1-week solution workshop with a 2-week quick-start engagement to mentor and implement a star schema model, Mondrian MDX and components of the Pentaho Software on a test system. DB technology utilized was MariaDB.

St Louis, Missouri, Us

Client: General MillsData/Information architect profiled, modeled, designed and documented the integration of acloud-based external data source into GMI's data warehouse.• Utilized Erwin to reverse engineer the model from a backup of the SQL Server Analytics DB and documentation from the Business Object universes utilized by the cloud-based Analytics reporting system. Created Conceptual, Logical and Physical models to ensure consistency, accuracy and normalization of information.• Led the Data Analysts and ETL developers with the design/STM docs for data movement and integration to ensure meeting the Service Level Agreement and 2 hours or less window for the integration process. As the BI Architect, modeled and created an in-house reporting application utilizing Business Objects.• Produced a roadmap and detailed project plan to map out, prioritize and integrate 70 external data sources into their EDW platform.Client: MedtronicAs a Solution Architect, performed a 6-week assessment of their WorkDay implementation. • Produced a roadmap of small projects to address current issues and gaps with the current work flow and data for the downstream applications.Client: TargetSolutions Architect/Senior BA worked on several Data Foundation/BI Reporting projects including a major Vendor Data Migration Project migrating Terabytes of information.• Migrated Target’s Vendor subject area from the IBM DB2 platform to Teradata platform which included data, ETL processing, MicroStrategy reporting analytics, a Java app and 10 SBE (small business enhancement).Client: UnitedHealth CareDelivered a rescue BI Solution as a Technical Architect for two CRM system data integration projects.These projects employed ETL processes on SQL server employing many complex business rules validations:• Developed, tested, deployed, operated and maintained the solutions thru seven deployment cycles.

Armonk, New York, Ny, Us

Worked within the Cognos Professional Services group for IBM and participated in many different roles including Cognos BI Architect, Cognos BI Modeler - Relational and OLAP/Cubes, Cognos BI Report Developer, Cognos Security and Administration, C8 Migration specialist, Data Architect, Business Analyst, and Data Analyst with several clients. Mentored and trained clients for a smooth transition of my work.

Marlborough, Ma, Us

Worked on several Cognos implementations with multiple versions of Cognos. Main reporting arena was a Sales & Marketing implementation with approximately 2400 users with complex authentication/ data security needs. Performed system architecture, data architecture, system administration, metadata modeling, report development and production support when needed. Performed multiple software upgrades. User community consisted of Upper Mgmt., Sales Force, Product Managers, Business Analyst and more.Led the data modeling and data validation standardization for the Cognos Data Architecture ensure accuracy with the SAP source system to an acceptable variance of less than 1% per month.

Master Of Software Design And Development, Computer Science

Bachelor Of Arts - Ba, Biology Major; Comp Science Minor