Peter Koebel Email & Phone Number

Global

Business Intelligence Analyst: We design spreadsheets and dashboards that turn your business data into usable information. Enabling you to easily view the health of your business and make confident, smarter business decisions.Selected Projects:• Enhanced a client's spreadsheet, by having their data flow more efficiently and perform needed calculations to track business progress.• Designed multiple business dashboards, enabling the owner, VP, etc. to visually track KPIs, such as revenue and expenses.• Using high-level Excel and data visualization techniques also designed an executive dashboard to easily view their business goals, such as Profit Margin, Budgets, and monitor the health of their business.• Created a spreadsheet for a client, for their staff to log their activity. This helps our client view conversion rates between sales activities and contracts signed. Plus, allows the client to see where staff need more training or where they excel.• Using Excel spreadsheets, reduced clients’ time to enter company data. Increased data auto filling, to prevent human error. • Developed and designed a variety of Pivot Tables and Dashboards, to turn their business data into easy to understand information. Enabling clients to view the health of their business and make better business decisions.

Winnipeg, Manitoba, Canada

Data Sciencing Consultants collaborates and consults with Hilltop Partner Network on client projects.Selected projects:Data Analyst - Client: 3sHealth• 18-month project helping merge multiple separate databases into one.• Ensured the data collected was cleaned and formatted to specifications before being uploaded into Oracle. • Using a variety of spreadsheet techniques, I verified what data was already uploaded to avoid duplicate records. Increased data integrity and validation process.• During parts of the project, I took on a leadership role. Managed a group of team members for specific elements of the project.Business Analyst - Client: HEB Manitoba • 6-month project testing system and process upgrades.• Performed User Acceptance Testing (UAT). Tested changes to records, to ensure the generated change code files were accurate and worked as expected when imported by one of the clients. • Investigated multiple sources to solve any issues or concerns that popped up, such as Spec documentation, technical team, business, and architectural analysis departments. • Analyzed and reported on the status of the project, enabling decision-makers to understand ongoing progress

Winnipeg, Manitoba, Canada

Scheduling and conducting interviews with independent consultants interested in joining Hilltop Partner Network (HPN).

Zurich, Zurich, Switzerland

Data Sciencing Consultants collaborates and consults with AlphaZetta on client projects.Selected project:Business Intelligence Analyst - Client: Swiss Re• 5-week project updating Tableau dashboards used by their HR and IT departments.• Enhanced and optimized 15 Tableau dashboards for the client, including designing a Main Menu.• Utilized technical skills and soft skills to learn how the dashboards were being used by employees, then determined optimal methods to improve the user experience.

Winnipeg, Manitoba, Canada

Data Sciencing Consultants collaborates and consults with Auxesys on client projects.Using data science and business intelligence tools to help businesses overcome challenges.Helping clients grow their business by strengthening their digital presence.

Winnipeg, Manitoba, Canada

• 12-month project helping the company switch ERP systems, working directly with the company Controller and often the company CEO• I used Microsoft SQL Server Management Studio to code SQL queries used for customizing and modifying search functions in the Seradex OrderStream ERP system, based on requests from department managers and the company Controller • After gaining feedback and information from the Controller and department managers, I used database management, SQL, statistics and visualization skills to create and modify reports between Microsoft Access, Seradex OrderStream and Telerik Reports• Using various ETL techniques, I migrated data between Microsoft Dynamics (NAV) and Seradex OrderStream ERP systems• To provide accurate pricing while accommodating multiple item and customer discounts, I utilized advanced Microsoft Excel techniques. As a result, the Controller can update pricing on one Microsoft Excel file, which then automatically updates pricing in other required Microsoft Excel files and the Seradex OrderStream ERP system• Used advanced Excel techniques and formulas to connect inventory management with product costs, as well as customer facing price lists.

Winnipeg, Manitoba, Canada

• Collaborated one-on-one with the CFO on a variety of Finance and Database management projects; As well as implementing new discounts and mark-up values for products.• Maintained multiple databases of products in Dynamics NAV (Navision) and AVAware; performing data migrations and ETL, between different programs; Worked in various aspects of the database including tables, reports, and pages.• Generated reports in Excel for the Operations Manager using Pivot Tables, Charts, Slicers, etc.; Worked with the Chief Sales Officer on updating and maintaining Vendor information on SharePoint.• Provided co-workers with software support for Dynamics NAV (Navision) and AVAware, for all 12 branches across Canada; Including screen sharing over Skype and talking on the phone.• Provided training and instructions for co-workers on procedures and software knowledge for Dynamics NAV (Navision) and AVAware; Developed scripts for training videos and work instructions.• Added and maintained user profiles in Dynamics NAV (Navision); including working on permission sets and custom filters in Easy Security.• Improved User Interfaces and functionality to enhance efficiency.• Conducted research on products, through communicating with Vendors, co-workers and online search engines.• Updated and added new items to the databases on request from co-workers or when Vendor prices and descriptions changed.• Maintained and modified group default profiles.Selected Project:• Part of a 12-month project switching ERP systems for the company.• I was the main bridge between the ERP consultants and the company. • Assisted with training employees on the new system, getting feedback, and advising what paths the company should take for options in the ERP system.• Worked on redesigning reports and ETL processes in the new system.

Winnipeg, Manitoba, Canada

I worked in Accounts Payables using Microsoft Excel spreadsheets to audit invoices from a variety of clients. To make the process more efficient I employed techniques such as Vlookups and creating formulas to find and replace keywords.

Winnipeg, Manitoba, Canada

I am a graduate from the University of Manitoba, with a Bachelor's of Science degree. My Major was Applied Mathematics with Statistics option and minor was in Anthropology.Started University in 1999, then took a break in 2002. I got married and had two kids. Then in 2006 I went back to University. During that time we had two more kids. I graduated in 2011 with a Science Degree.For 2 years I ran the Math club.

Winnipeg, Manitoba, Canada

• Worked on the CONTACT Community Information project, which is now 211.• Accurately conformed information to set standards, used various resources including data mining to gather accurate information• Modified Microsoft Access reports page to save time and reduce paper waste of a monthly process• Using Microsoft Access and Excel adapted client's feedback to various formats• Took calls from public requesting information and referral, helped them in finding solutions• Recorded daily calls and statistics• Coordinated website updates and new entries of Database, for use on website and "Community Resource Guide" publication• Sorted and processed profile Excel sheets and followed up on messages from voice mail and email• Wrote and forwarded correspondence to clientele

Undergraduate, Mathematics, Statistics And Minored In Anthropology

Activities and Societies: I organized events for the Math Club during a period of 2 years.•Educated in logic and analytical thinking.

High School

I was primarily enrolled in Advanced Placement classes. Such as Math/Calculus, Physics, Chemistry, Computer Science, and German Language.