Winnie Scranton

Winnie Scranton

Power BI Developer

Princeton, Texas, United States.

About  

I am a Business Intelligence professional experienced in data analysis, data visualization and database development. I am confident in querying in SQL and DAX languages. I am seeking a career opportunity to bring detail and precision into data analysis. I have experience developing effective data visualizations and reports using Power BI and other Microsoft tools. I am detail oriented, quality driven, and able to shift quickly to new tasks. I possess strong leadership, organizational and communication skills from working with teams and directly with senior managers.

Hours Available / Wk - 40 hrs

Watch Video Pitch

Employment History 

  • Power BI Developer/SQL

    Colaberry Inc
    March 2019 - Present

    • Generating on-demand reports for business analysis using Power BI desktop and service
    • Extract data from various sources like Excel, Text/CSV, SQL server database, transform and clean them
    in power query and load them to Power BI desktop
    • Performed data modeling using power pivot
    • Developed dashboard and reports using Power BI
    • Generated drill down and drill up reports, development of various KPI’s in data visualization using
    various DAX functions and publishing reports in Power BI service
    • Adapted software development life cycle, specifically Agile methodologies, when working on complex
    projects, breaking them into sprints and user stories
    • Implemented Row-level security (RLS) to securely create user specific reports
    • Daily progress updates during scrum meetings

  • Business Intelligence Developer

    Bank of America
    April 2011 - February 2019

    • Extracted data from different sources using Power BI, transformed the data, and added visualization for
    reporting purposes
    • Used Power BI to create reports and dashboards for managers for decision making
    • Developed and implemented reporting, analytics, data visualization solutions using Power BI in
    providing KPIs with insights
    • Performed data extract, transform and load (ETL) from different sources using SSIS to develop jobs for
    extracting, transforming, validating, and loading data into ODS database
    • Prepared the complete data cleansing, mapping for all the migrated jobs using SSIS
    • Designed SSIS Packages to transfer data from SQL Server, Excel, and Text/CSV into the Data
    Warehouse loading Dimensional and Fact tables