Jessica Johnson

Experienced Business Intelligence Professional Data Analyst Technical Lead Data Engineer SQL Developer

Resume

Professional Overview And Experience

Facts About Me

Status:

Open to Offers

Desired Salary:

To be Discussed

Education Level:

Master of Science, Health Informatics
Bachelor of Science, Computer Science

Availablity Type:

Part-Time Contract, Freelance

Mobility:

No Relocate or Travel (except Greater Pittsburgh Area)

Personal qualities

Leadership

Lead effectively with a high degree of emotional intelligence, patience, and working knowledge of human resources to successfully interact with colleagues, clients and others in the workplace.

Critical Thinking

Draw reasonable conclusions from a set of information and differentiate between useful and less useful details for solving a problem or making a decision.

Communication

Convey information to people clearly and simply in a verbal or written way to a variety of audiances.

Perspective

Easily adopt a different perspective with a broader and more team-oriented mindset, as well as an eye for impact on the enterprise-level.

Professional Timeline

Working hard and making the success
  • Feb 2017 - Present

    Pragmatic Works

    Business Intelligence Consultant

    Consulting engagements nationwide covering various components of the Microsoft BI Stack (SSIS, Power BI, SSAS). Instruct multi-day onsite client Power BI workshop reviewing development concepts and delivering POC solution. Lead testing for consulting engagement by developing test strategy and patterns utilizing Pragmatic Works LegiTest.

  • Oct 2016 - Feb 2017

    MedExpress

    Senior Business Intelligence Developer

    Aided in the implementation of an Agile BI/DW methodology through collaborative project planning activities. Led cross-functional team working sessions to translate business requirements into business intelligence solutions. Mentored junior team members on business intelligence/data warehouse concepts and methodologies. Spearheaded an ETL Framework strategy to standardize SSIS packages utilizing best practices. Created functional/technical documentation (Target mapping, Functional Business Requirements Document (FRD), etc.). Architected a dimensional model to integration multiple source systems: Athena, DocuTap, Salesforce and SharePoint. Implement advanced SSIS ELT processes (Lag/Duration Facts, Periodic & Accumulating Snapshot Facts). Participated in the selection, evaluation and interviewing process for all business intelligence openings.

  • Mar 2016 - Oct 2016

    OpenArc (Duquesne Light Company)

    Microsoft Business Intelligence Contractor

    Contract role focused on designing and implementing big data solutions utilizing Microsoft's Azure technologies and Business Intelligence Stack. Developed an Executive Time Management Dashboard sourced from custom Time & Attendance system. Organized and conducted Enterprise Date Warehouse (EDW) Testing strategy, test case development and execution. Created and maintained EDW Documentation (Functional Requirements, Test Strategy, Physical and Logical Design). Conducted Business User BI Training (Data Model overviews, Visualization Tool Training). Developed Oracle BI Publisher Reporting (Data Models & Reports) sourced from Oracle Utilities Suite: Customer Care & Billing, Meter Data Management, Mobile Workforce Management and Work & Asset Management. Actively collaborated in EDW Project Planning tasks and responsibilities. Utilized Kimball multi-dimensional design principles to create various BI data models in SSAS, PowerBI and PowerQuery. Designed and implemented enterprise data solutions utilizing Microsoft Azure SQL Data Warehouse (MPP) and Azure Blob Storage. Developed and maintained advanced SSIS ELT processes (SSIS: ELT, Slowly Changing Dimensions, Timespan Aggregating Facts, etc.)

  • Sep 2014 - Jan 2016

    UPMC (Prodigo Solutions)

    Product Data Analyst, Lead

    Primarily tasked with the planning, design and implementation of an Analytical Engine and reporting environment using data warehousing techniques to meet enterprise client analytic needs in the areas of compliance, operations, data profiling and quality. Developed extraction processes from various Enterprise Resource Management systems using techniques of data cleansing, replication, and change data capture. Created various agile project plans to manage tasks, aligned business requirements and promoted communication between all project stakeholders.

  • Jan 2013 - Sep 2014

    UPMC (Via Oncology)

    Data Warehouse Data Modeler

    Aided in task organization and the development of a project roadmap for the expansion and optimization of an existing data warehouse. Utilized the Microsoft Business Intelligence toolset to develop and maintain ETL packages for data cleansing, staging and loading for client-facing and internal analytics. Implemented an automated ETL build and deployment process using Maven, PowerShell, SSIS API and Team Foundation Server.

  • Oct 2011 - Jan 2013

    West Penn Allegheny Health System

    Associate Data Warehouse Developer

    Created enterprise-wide IBM Cognos actionable analytic reporting packages, dashboards and OLAP data cubes. Responsible for user and developer training sessions for core reporting packages, as well as the Cognos reporting toolset. Aided in the modeling of a financial data warehouse through supporting ETL processes and IBM Cognos SDK interfacing.

  • Aug 2011 - Oct 2011

    Synergy Staffing (West Penn Allegheny Health System)

    Business Intelligence Contractor

    Created enterprise-wide IBM Cognos actionable analytic reporting packages, dashboards and OLAP data cubes. Responsible for user and developer training sessions for core reporting packages, as well as the Cognos reporting toolset. Aided in the modeling of a financial data warehouse through supporting ETL processes and IBM Cognos SDK interfacing.

  • Jan 2007 - Aug 2011

    Other IT Experience

    Developer

    [Nov 2010 - Aug 2011]
    Technosystems Service, Corp. - .Net Software Developer
    [Feb 2009 - Jun 2010]
    CedarStore.Com - .Net Web Developer (P/T)
    [Jan 2007 - Feb 2009]
    United Steelworkers of America - Information Systems Developer (P/T)