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.
• 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.
• Using Excel spreadsheets, reduced clients’ time to enter company data. Increased data auto filling, to prevent human error.

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.

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.
• 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.
• 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.
• 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.
• 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.

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.

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

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 from.

High School

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