Jane Koleosho MSc.

Experience

• 

  SisterHood Boutique

  Sept 2014 - Dec 2014

  Web Presence and Email Marketing

  Class Project: Evaluated different website options and then created a unique website for a local non-profit business. Setup and execution of targeted email campaign.Software: Google Adwords, Microsoft Word, Microsoft PowerPoint

• 

  Augsburg College

  May 2015 - Jan 2016

  Student Assistant , Registrar Office

  • Purged Filed to eliminate duplication of data.• Verified student account data for data accuracy.• Maintained data entry requirements by following data techniques and procedures.• Maintained student confidence and protected operations by keeping information confidential.• Compiled, verified accuracy and sorted information according to priorities.Software: Agresso Database, Microsoft Excel, Microsoft Word.

• 

  Nonviolent Peaceforce

  Oct 2015 - Jan 2016

  IT Support Intern

  • Provided support, including procedural documentation and relevant reports.• Extensively used SharePoint Designer to create, modify and implement consistent look and feel for new and existing web pages.• Created data-driven web parts using SharePoint and Office 365• Created, set-up and Updated User Account profiles using SharePoint and Office 365Software: SharePoint, Microsoft Word

• 

  Modacto

  Jan 2016 - Apr 2016

  Database Marketing Intern

  • Organized spreadsheets to be loaded into CRM database• Conducted Data cleanses and merged supporting data to better support sales and Marketing efforts.• Conducted online research to verify contacts to determine credible leads• Supported the sales phase processes to optimize sales and marketing projects.• Developed meaningful reports from the data to emphasize key lead indicators.Software: Microsoft Word, Microsoft Excel, Salesforce

• 

  Tennant Company

  Feb 2016 - Apr 2016

  E-Commerce Distribution Channel Analyst

  • Identified territories of key distributors by zip/postal code and brand of product.• Worked with IT and other team members to set up a system to store that information, making it accessible to on-line system processes.• Determined and documented a process to update the information relating to key distributors level.Software: Microsoft Excel, Microsoft Word

• 

  Fairview Health Services

  Aug 2016 - Dec 2018

  Data Reporting & Analytics Analyst, Information Management

  • Developed and Tested extraction transformed and Load (ETL) processes.• Designed DataStage jobs that automated the FTP process of loading flat files posted on the FTP server.• Designed and Developed Data mapping based on business user requirements and business rules to load data from source flat files and Oracle tables to target tables.• Interacted with third-party vendors and identified various sources, extracted and integrated data from flat files, Oracle sources and loaded to staging areas and Database tables.• Extracted data from various source systems like CSV, Flat-files, Oracle into the staging area for Data warehouse.• Provided on-call support to the ETL/Information Management team.• Created ETL IBM-DataStage parallel jobs to extract and reformat the source data so it can be loaded into the new data warehouse schema.• Designed, Compiled, tested, Scheduled, and Run DataStage jobs using IBM Infosphere tools.Software: Oracle SQL Developer, Crystal Reports, Microsoft Excel, IBM DataStage, IBM Infosphere Show less

• 

  Best Buy

  Dec 2018 - Feb 2020

  Sr. Analyst Data Reporting & Analytics

  Responsibilities: Manipulation of data, running pivot tables, V-lookups and formulas in Excel, creating reports that cross-functional teams consume. Analyze business data to develop Key Performance Indicators and building dashboards to visualize important trends and goals for decision making. Provide strategic recommendations to managers.Tools: Excel, Teradata, Power Bi, Alteryx● Led the design and development of reporting data module for a Distribution Planning team.● Gathered and documented business requirements for analytical reports. Participated in requirements meetings and data mapping sessions to understand business needs. Identified and documented detailed business needs.● Developed at least four- five visual options for each report for discussion with the Distribution and Logistics stakeholders and customers.● Developed complex calculated measures using Data Analysis Expression language (DAX).● Drive efficiencies across analytics and reporting processes by use of automation and implementation of industry best practices.● Developed Complex SQL queries to support Power Bi reports.● Utilized Power Bi to create various analytical dashboards that depicts critical KPIs such as claims, transfers and billing along with slicers and dicers enabling end-user to make filters.● Integrated custom visuals based on business requirements using Power Bi desktop. Show less

• 

  State of Minnesota

  Feb 2020 - now

  Data Engineer