A Senior Business Systems Analyst available to leverage your systems and applications with my Analytical, Database, Development and Programming skills.
+ Analytics experience utilizing advanced Excel (Pivot tables, VBA/Macros, formulas) ; SQL Server, MS Access and Tableau; Forecasting; Data Warehousing; Direct Marketing testing/analysis.
+ Over three years’ experience as a Supply Chain / Procurement / Business Intelligence Analyst; providing analysis, reporting, alerts and support for Spend tools. Integrated data from multiple Spend systems and supported Oracle Spend Analytics application.
+ Background as a Programmer/Analyst with COBOL, SQL and other languages. Data modeling and analysis with very large datasets, databases, CRM and data warehouses.
+ Adept at working independently as part of a cohesive team.
+ Turning data into information, and information into solutions and actionable results.
+ 4-year education with 2 Associates degrees – Data Processing & Business Administration; currently engaged in a Bachelor’s degree, with a Supply Chain Management focus.
+ Customer Service orientation; Strong attention to detail, while maintaining a focus on the big picture; excellent troubleshooting and issues resolution skills; analytical thinker.
+ Support cross-functional teams as an analyst, with business partners, in both strategic and tactical groups. Able to relate with both technical and user communities, including senior and executive management.
I am well poised to help your organization support your systems, and take them to the next level and beyond.
Development: COBOL, CLP, Query/400, PDM, SEU, SDA, DDS/DDM, SQL, VBA, Oracle(v7), HTML Exposure to: C, RPG, XML, Java
Environments: IBM iSeries(AS/400, i5, System i )[OS/400], VAX[VMS], PC [Windows/DOS]
Utilities: MS Office/Excel/Access, Group-1(Postal), FTP, Mailtool, PKZip, pgp, Kana(CRM), Visio
Applications: Direct Marketing (Travel/Tourism, Gaming, Software, Financial), Real Estate Information
Language: basic Spanish, learning German.
Procurement / Business Intelligence Analyst Contractor via Chipton-Ross April 2012 – December 2015 Boeing, Renton, WA SSG: Supplier Management: Business Intelligence; Systems & Tools + Business/Market Intelligence Analyst for Procurement and Category Management Non-Production Procurement spend data, from both internal and external sources. + Supplier Alert Bulletins for critical events; Supplier Executive Summaries and Profiles. + Data Analysis, including Categorization, Classification, Summarization, and Reporting. + Spend Analytics tool Lead / SME; Spend Classification; Data Management; User Support. + Strong utilization of MS Access, Advanced Excel including PowerPivot (Power BI), PowerPoint, Tableau and SQL Server. + Analyst support/lead role for cross functional teams in development and implementation of Category Management strategies; spend SME for MRO, Facilities, Education and Construction. + Maintain data security and compliance following company and government regulations, processes and guidelines.
Data Analyst April 2011 – October 2011 Efinancial, Bellevue, WA Analytics department + Life Insurance brokerage data and applications, including a large call center in two locations + Developed and enhanced SQL Server 2008 queries and reporting utilizing Excel 2007 with Pivot reports, including utilizing advanced functions (vlookup, sumif, filters, etc…) + Contributed to Data Warehouse design and performed user acceptance testing in collaboration with Information Services development. + Tableau was utilized for Dashboards, reporting and geographic analysis; with either imported data or linked to Excel and/or SQL databases. + Report scraping and bulk data loads. Data modeling of new sources, extracts & enhancements.
July 1996 – September 2009 (also Programming Supervisor since June 2000) Programmer/Analyst Supervisor Bowne and Company, Kent, WA; Vestcom International, Kent, WA Manus Direct, Seattle, WA + Maintained position through two acquisitions, promoted to Supervisor in June 2000. + Direct Marketing databases, data warehouses, data marts and fulfillment systems + Reporting and Analytics and supporting systems. + In-house tools and utilities dealing with email/postal address enhancements and cleansing. + Data analysis, statistics and systems monitoring, administration and 24x7 on-call support. + iSeries (AS/400) mid-range system with COBOL, Query/400, CL and other tools. + Data processing for Web and CRM application systems. + Supervised a small, but cohesive team of developers, ranging in size from 3 to 5 individuals. + System Administration and Systems Programming tasks in support of a secure environment.
March 1986 - November 1995 Programmer/Analyst TRW REDI Property Data, Seattle, WA; Washington Real Estate Register, Seattle, WA + Maintained the same position through an acquisition. + Real Estate Information databases and products - On-line system, Microfiche and printed. + Updated databases from various divergent data sources, including county government files. + Products and applications supported Title Companies, Real Estate Agents, Appraisers, County governments, Mortgage Companies and anyone else with interest in Real Estate Property, Title, Deed and Sales information. + On-line system ran on a VAX/VMS minicomputer and an Oracle database. + Developed with SQL and Pro*COBOL code using Oracle Forms. + Some aspects of the business were developed in COBOL and Clipper/xBase on PC’s. + Trained as an Oracle Database Administrator.
Computer Lab Supervisor - Edmonds Community College, Lynnwood, WA + Supervised the student computer lab. + Assisted students in software and programming projects on Personal Computers. + Assisted in computer seminar instruction for by Edmonds Community College and Central Washington University.
Programmer - Reynolds Corporation, Lynnwood, WA + Various applications included; sales analysis, inventory valuation, and other manufacturing related systems. + Programmed and maintained BASIC programs on a MAI Basic Four minicomputer.
Programmer - Snohomish County Public Utility District #1, Everett, WA + Used CONDOR and CMS EDGAR for on-line programming. + Used COBOL and FORTRAN on a DOS/VSE 4341 + Programmed and maintained statistical and load forecasting programs.
Highline Medical Center - Clerical computer specialist
Genealogy research assistance to researchers at the local library genealogy collection, both online and hardbound resources. Through the local genealogical society.
General Business Administration, Bachelor of Science, Central Washington University Extended Degree Center, Lynnwood, WA 3 years toward degree, Full-time employment precluded completion. IN PROGRESS Expected completion 2017.
Business Administration, Associate of Arts and Sciences Pre-professional Transfer degree, Edmonds Community College, Lynnwood, WA
Data Processing, Associate of Technical Arts, Everett Community College, Everett, WA Some classes taken at Edmonds Community College
What Colleagues Say About Me
"Worked with Dan for 8 years at Manus/Vestcom/Bowne, both as a subordinate and as his manager, and was always impressed with his attention to detail while still able to keep the big picture in sight. Dan was an effective programming supervisor, who was able to keep the entire team's schedule on track while consistently getting his own tasks done on time and budget, and constantly dealing with end-user interruptions and producing professional client project estimates. Dan would be a great addition to any IT team, with his dedication to quality and process improvement. Would love to hire him again!" Lyle Behm - Bowne & Co.
“Dan was effectively both a technician and a business analyst, able to communicate well with both non‑technical clients and software developers…Dan is a quick learner and an excellent problem solver. He was a principled, valued employee of this company. I particularly recommend Dan for work requiring analysis, attention to detail and creative problem‑solving.” Graeme Curtis – Bowne & Co.
“Daniel is very competent and a hard-working person. His math is strong. His work is done quickly and correctly. He can contribute greatly to data processing production…He learns new procedures very quickly“. Maryhelen Hudson – Snohomish County PUD
“Dan Volkmann is a dependable employee and well-liked by his co-workers. He is a hands-on supervisor and does whatever it takes to get the job done and insure that deadlines are met.” Shirley Zaic – Bowne & Co.
“Dan was a valuable asset to our company. A very talented programmer with the specific attention to detail and forethought that solves problems during initial stages of a project. Additionally, Dan always succeeded in meeting deadline in the face of difficult workloads and deadlines.” Kevin Lynch - Bowne & Co.
“As programming supervisor at Bowne, Dan developed the reputation as someone who could integrate data from client transactional systems into hi-quality data marts. He excels in collaborating with cross-functional teams to define business rules and translate those rules into effective IT solutions that benefit the client's bottom-line. His focus, discipline and patience under pressure was an inspiration to all those on his team.” Jason Johanneck - Bowne & Co.