Maria Von Kageneck
Software Developer
Experience
Requirements gathering, evaluation, and implementation
- Development of a code-supported tool for end-of-life control of product parts
- Creation of a template
- Evaluation and later creation of various additional codes and extensions
- Preparation of a short documentation
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: cosmetics
Tutor
TH Köln
- Excel VBA tutorial at TH Köln
- Development of the tutorial
- Conducting tutorial sessions
- Creating and distributing handouts
- Being available for students' questions
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: education
Requirements gathering, evaluation, and implementation
- Development of a code-supported function description tool
- Creation of a template
- Evaluation and later creation of various additional codes and extensions
- Preparation of a short documentation
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: consulting
Requirements gathering, evaluation, and implementation
- Development of a code-supported tool for repeated data updates via an SQL database, adding various functionalities to simplify handling.
- Integration of code for repeatedly querying and transferring data into an existing template
- Evaluation and later creation of various additional codes
- Preparation of a short documentation
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: cosmetics
Requirements gathering and implementation
- Programming all processes for a function description tool, branding each tool
- Designing the approach
- Creating the various handling codes
- Branding for different clients
- Skills: Excel, Microsoft Excel VBA
- Products: Microsoft Excel VBA
- Industry: human resources management
Requirements gathering, evaluation, implementation and project management
- Revising the creation processes for various reports
- Reviewing existing reports
- Designing an approach
- Revising the creation processes
- Skills: Excel, Microsoft Excel VBA
- Products: Microsoft Excel VBA
- Industry: Healthcare
Requirements gathering, evaluation and implementation
- Revising various TI processes on a TM1 cube
- Reviewing and organizing structures
- Designing an approach
- Creating & revising various TI processes
- Skills: TM1 programming
- Products: TM1
- Industry: Logistics
Requirements gathering, evaluation and implementation
- Creating a mini tool to gather various data in an Excel file.
- Creating various codes for handling
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Personal
Requirements gathering, evaluation and implementation
- Creating various extensive codes for handling data in an Excel file.
- Reviewing and organizing structures
- Designing an approach
- Creating various codes for handling
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Healthcare
Requirements gathering, evaluation and implementation
- Creating various code-based aids for handling a large Excel file.
- Reviewing and organizing structures
- Creating various codes for handling
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Information Technology
Requirements gathering, evaluation and implementation
- Development of a code-assisted questionnaire.
- Creating a questionnaire with editing options
- Creating a code-assisted evaluation of the questionnaires
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Healthcare and social services
Requirements gathering, evaluation and implementation
- Development of a code-assisted tool to insert images via links. Creating a menu item to open this tool.
- Integration of code to insert images into an existing template
- Creating a custom menu item to open the tool
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Information services
Requirements gathering, evaluation and implementation
- Development of a code-assisted document management system.
- Creating a tool with an interface for document management
- Creating a user manual / documentation
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Healthcare and social services
Requirements gathering, evaluation and implementation
- Development of a code-assisted tool to update data via an SQL database query. Adding history tracking.
- Integration of code to query and transfer data into an existing template
- Automated filling of a history sheet
- Creating brief documentation
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Cosmetics
Requirements gathering, evaluation and implementation
- Development of a code-assisted tool for importing data
- Integration of code to import and transfer data into an existing template
- Creating certain control mechanisms
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Automotive
Requirements gathering, evaluation and implementation
- Expansion and customization of the tool for updating data via a SQL database
- Customization and extension of the query
- Adaptation of the data loading
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Cosmetics
Requirements gathering, evaluation and implementation
- Development of a code-assisted data entry tool
- Creating a template
- Building a tool for reading and transferring the data
- Creating control mechanisms
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Data Privacy
Requirements gathering, evaluation and implementation
- Development of a tool to read data outputs from a database, including visualizing the data in charts with certain control options
- Developing and building a tool
- Developing a visualization
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Machine accessories
Software Developer
- Development of a tool to optimize patio and raised bed decking, including visualization
- Developing and building a tool
- Developing a visualization
- Embedding the tool into the existing environment
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Hardware store
Requirements gathering, evaluation and implementation
- Development of a code-assisted project management tool
- Creating the tool
- Transferring the data
- Creating specific control mechanisms
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Machinery
Requirements gathering, evaluation and implementation
- Created a tool to visualize collected data
- Created a tool to visualize collected data
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Personality diagnostics
Software Developer
- Designed and built a planning tool for the corporate real estate department and supported the planning process
- Created a bottom-up planning tool for entering the full profit & loss and balance sheet for various planning purposes
- Created a tool to read and transfer the planned data into the CORE data model
- Further developed it based on new requirements
- Documented the tool
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Logistics
Requirements gathering, evaluation and implementation
- AnSi reporting of service types at the lease contract and room level for a production area
- Replaced an MS Access database
- Performed data analysis and quality assurance
- Reduced dependency on specific people
- Set up monthly standard reporting
- Created a user manual / documentation
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Logistics
Application Development / Support
- Built a data warehouse for a mid-sized real estate company
- Supported the project manager with requirements gathering
- Developed a custom ETL tool
- Performed data analysis and quality assurance
- Provided support for customer inquiries
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Real estate
Software Developer
- Created a tool for geographic visualization of a worldwide real estate portfolio and its analysis options
- Created a database and automated its updates
- Developed an interface for easy selection of properties to visualize
- Created a user manual / documentation
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Real estate
Application Development
- Developed a reporting tool (including automated monthly updates) for an aviation company
- Analyzed requirements
- Designed and created the report
- Provided extensive filtering options for report generation
- Wrote code to import current data
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Aviation
Software Developer
- Designed and developed a counterflow planning system for the sales department of a telecommunications company
- Created counterflow templates for revenue planning
- Built a tool to import and transfer feedback data into the planning tool
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Telecommunications
Requirements Gathering, Evaluation, and Implementation
- Developed a panel tool for the corporate HR department
- Designed, implemented, and trained users on an internationally used, company-wide tool for evaluating, aligning, and calibrating HR target metrics
- Skills: Microsoft Visual Basic 6.0
- Products: Microsoft Visual Basic 6.0
- Industry: Logistics
Requirements Gathering & Development
- Developed various domestic and international travel expense forms for the corporate HR department
- Analyzed requirements
- Designed and created the forms
- Developed support mechanisms for using the forms
- Prepared the forms for automated import into a database system
- Skills: Microsoft Excel VBA
- Products: Microsoft Excel
- Industry: Banking
Industries Experience
See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.
Experienced in Transportation (9 years), Real Estate (3.5 years), Professional Services (2.5 years), Cosmetics (2 years), Aerospace and Defense (2 years), and Healthcare (1.5 years).
Business Areas Experience
The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.
Experienced in Information Technology (13.5 years), Business Intelligence (13.5 years), Quality Assurance (4 years), Product Development (2.5 years), Finance (2.5 years), and Marketing (2 years).
Summary
I analyze and solve your Excel and VBA problems and challenges.
I bring your data into a structured, custom, and targeted form.
The new, intuitive world saves you time, cost, and stress.
I also don’t shy away from revising or optimizing old code.
You’ll be amazed at what you can do and optimize with Excel and VBA.
Fast, reliable, flexible.
Want to know more? If you're interested, feel free to contact me.
Skills
Design And Development:
- For Microsoft Excel
- For Microsoft Word
- For Microsoft Powerpoint
- With Vba (Visual Basic For Applications)
Data (Including Graphics) In The Form Of:
- Forms
- Tables
- Calculations
- Reports
- Complex Applications
- Interfaces And Integrations
Additional Services:
- Legacy Code Overhaul
- Documentation And User Manuals
- Support And Maintenance
Languages
Education
Institute for High-Frequency Technology, RWTH Aachen
Training as a mathematical-technical assistant · Mathematical-Technical Assistance · Aachen, Germany
RWTH Aachen
Studies, up to preliminary diploma · Romance Studies and Mathematics · Aachen, Germany
Laurensberg School Center
High school diploma · Aachen, Germany
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Maria based?
What languages does Maria speak?
How many years of experience does Maria have?
What roles would Maria be best suited for?
What is Maria's latest experience?
What companies has Maria worked for in recent years?
Which industries is Maria most experienced in?
Which business areas is Maria most experienced in?
Which industries has Maria worked in recently?
Which business areas has Maria worked in recently?
What is Maria's education?
What is the availability of Maria?
What is the rate of Maria?
How to hire Maria?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Requirements gathering, evaluation, and implementation
Nearby freelancers
Professionals working in or nearby Aachen, Germany