Loren Cahlander
Software Engineer
New Richmond,WI
Summary
Dynamic and results-driven consultant with a proven track record at Optum, specializing in API design and data modeling. Expert in Java and strategic planning, I have successfully enhanced platforms and streamlined processes, driving significant improvements in efficiency and performance. Passionate about leveraging technology to deliver impactful solutions.
Overview
32
32
years of professional experience
1
1
Certification
Work History
Consultant
Optum
Minneapolis, Minnesota
03.2020 - Current
- Enhanced functionality of Easymetahub Magellan platform by implementing user feedback.
- Analyzed client needs to develop tailored health solutions.
- Facilitated workshops to improve team collaboration and communication.
- Managed project timelines to ensure timely delivery of services.
Principal
EasyMetaHub LLC
New Richmond, Wisconsin
01.2016 - Current
- Developed server-side architecture using Java, JDBC, SQL, PL/SQL, XQuery, RESTXQ, and XQDoc for microservices as RESTful APIs.
- Executed ETL processes to extract models from data sources, transforming and loading data into data lakes in XML or JSON formats to support data analysis.
- Constructed user interface with Polymer 3, Vaadin AJAX calls to RESTful APIs, and D3.js for dynamic visualizations.
- Packaged project with Gradle, streamlining deployment and management processes.
- Maintained open-source XQDoc documentation project, upgrading grammar from ANTLR2 to ANTLR4 to enhance documentation capabilities.
- Transformed grammar files into Java classes and created visitor classes for processing parsed source code into XQDoc XML files.
Data Architecture and API Consultant (contractor)
Allstate
Charlotte, NC
07.2019 - 11.2019
- Supported canonical models while developing enterprise model and platform for comprehensive product integration.
- Developed tool for converting OpenAPI JSON files into accessible PDF documents, streamlining documentation.
- Utilized Erwin, OxygenXML, XMLSpy, and XQuery for data modeling and transformation.
- Utilized XML Schema, JSON Schema, and DocBook to improve clarity and consistency in documentation processes.
API Consultant (contractor)
American Medical Association
Chicago, IL
10.2018 - 03.2019
- Created tool to generate OpenAPI JSON files from RESTXQ annotations and XQDoc documentation, enhancing documentation efficiency.
- Ensured synchronization between source code and OpenAPI specifications for consistent API documentation.
- Developed searchable XML repository of AMA journal components using easymetahub project accelerator.
- Environment included RESTful API, OpenAPI, microservices, MarkLogic, OxygenXML, XML, JSON, Java, JavaScript, Polymer, Vaadin, XQuery, Node.js, XSLT, RESTXQ, and SOA.
Data and API Architect (contractor)
QSSI
Columbia, MD
10.2017 - 09.2018
- Analyzed external OpenAPI documents, validating XML schemas to align with API specifications.
- Ensured synchronization of business documents, XML schemas, JSON schemas, and OpenAPI annotations for cohesive data architecture.
- Maintained and modified XML schemas for healthcare.gov, ensuring compliance with regulatory standards.
- Developed proof of concept for JSON schema, enhancing data structure validation.
MarkLogic Consultant (contractor)
IEEE
Piscataway, NJ
02.2017 - 09.2017
- Transformed search proof of concept into production-ready platform, enhancing user experience.
- Leveraged MarkLogic and OxygenXML for streamlined data handling, improving accessibility.
Senior Software Architect
GreatLinkUp LLC
Durham, NC
06.2012 - 01.2017
- Collaborated with project team to clarify data and business models, enhancing alignment on project goals.
- Reviewed existing schemas and recommended improvements, streamlining data management processes.
- Defined processes for ingesting and transforming data from diverse formats.
- Recommended tools and technologies to automate data flow processes.
- Suggested solutions for data validation, schema validation, and automated testing.
- Documented processes to facilitate knowledge transfer, supporting team continuity and onboarding.
Principal XML Data Architect (contractor)
Blue Cross Blue Shield of North Carolina
Durham, NC
04.2013 - 12.2016
- Designed and led development of tool transforming erwin model into XML and JSON schemas.
- Created erwin transform to convert export into metadata format, preserving structure and change history for enhanced data integrity.
- Leveraged hierarchical structure to generate XML schema, JSON schema, or both for enterprise use.
- Established schemas as canonical model, facilitating effective communication among various systems in BCBSNC.
- Utilized OxygenXML, Exist-DB, and Java technologies for implementation, streamlining data processing and schema management.
- Integrated XQuery, XSLT, and RESTful API within microservices architecture.
- Developed schema dashboard to edit, maintain, and display hierarchical structure of schemas.
- Employed jQuery and D3.js for enhanced user interface and data visualization.
Senior Software Architect
ZH Computer
Minneapolis, MN
12.2008 - 06.2012
- Architected design and testing processes for advanced SOA content management system, enhancing system reliability and scalability.
- Managed development from concept to release, leveraging XML database with XQuery, XML Schema, and XForms to ensure seamless integration and functionality.
- Designed, modeled, and developed key components of system architecture, contributing to improved system performance and maintainability.
- Implemented microservices as RESTful APIs for security, account, and content management functionalities.
- Adhered to National Information Exchange Model (NIEM) standards throughout development.
- Led a team contributing to codebase of Exist-db, primarily written in Java.
- Developed Java/JDBC tool to harvest ER-metadata from RDBMS and transform it into XML format.
- Created Java-based tool integrating UIMA with HMM tagger for document annotation and storage in XML database.
Senior Consultant/Solution Architect
Parametric Technology Corporation
Hong Kong
12.2002 - 10.2008
- Streamlined Java project performance for seven customers, achieving annual savings exceeding $5 million.
- Assumed lead architect role on Lenovo project, successfully turning around deployment and saving over $100,000 in costs.
- Joined late-stage Huawei project, delivering on time under budget while exceeding performance expectations.
- Conducted health check reviews of product installations, resolving configuration and coding issues in Java to improve system functionality.
- Developed processes to identify and analyze customized system performance health, enhancing overall system reliability.
- Performed code analysis on Java classes, delivering actionable recommendations for enhancements to optimize performance.
- Designed technical solutions adhering to enterprise architecture standards, documenting all configurations and test plans.
- Collaborated with delivery teams to ensure timely solution delivery and post-deployment support.
Senior Technical Consultant/Architect
Ensodex, Inc.
Arden Hills, MN
01.1999 - 01.2002
- Managed delivery of $2,000,000 Java/J2EE n-tiered integration framework, ensuring alignment with project objectives.
- Developed configurable Java connector, improving data retrieval capabilities within integration framework.
- Conducted analysis and design for product variant tracking system Java application for Ford Motor Company.
- Led full project life cycle, from requirements gathering to production rollout.
- Facilitated design meetings, documenting requirements for data modeling team at Ford, enhancing clarity and focus.
- Taught in-house developers design of humidifier sizing and selection application using UML.
- Implemented short-term security fix in Perl for product design system; received customer appreciation certificate.
- Utilized Eclipse and Oracle SQL in software development for multiple projects.
Software Engineer/ OO Developer/Architect
Integrity Solutions/KeyTech, LLC
Eagan, MN
01.1994 - 01.1999
- Led full project cycle, ensuring alignment with stakeholder requirements from gathering through design, coding/testing, and production rollout.
- Spearheaded design, data modeling, and co-development of n-tier SOA order transfer application for packaging orders to legacy systems.
- Directed design and data modeling of NextStep web application, enhancing marketing material creation efficiency.
- Oversaw design and data modeling of NextStep extranet web application, streamlining recording of pacemaker logs for medical device corporation.
- Developed three-tier Java systems using servlets, business objects, JDBC, and RDBMS technologies.
- Isolated order items by shipping locations for enhanced order processing.
- Utilized Java, JDBC, Pro*C, Oracle, Objective-C, Apache Tomcat, and SQL in various projects.
- Consulted for small company specializing in databases within NextStep and Java/J2EE environments.
Education
Masters of Science - Software Engineering
University of Minnesota
Minneapolis, MN01.2011
Bachelor of Science - Computer Science
Northwestern University
Evanston, ILSkills
- API design
- Data modeling
- ETL processes
- Data Governance
- Data Analysis
- Data analytics
- Cloud computing
- Java
- Python
- SQL
- Oracle PL/SQL
- PostgreSQL
- MySQL
- J2EE
- Servlets
- JSP
- JUnit
- Struts
- JavaBeans
- Microservices
- OpenAPI
- XML
- XQuery
- Antlr4
- XSL
- HTML
- Perl
- C
- Objective C
- UNIX Shell Scripting
- Database Design
- ER diagramming
- OLTP and OLAP modeling
- Data Modeling (OLTP and OLAP)
- LDS design
- MarkLogic 9
- EXist-db
- XqDoc
- Ant
- Maven
- Rational Rose
- ERwin
- SVN
- Git
- CVS
- Rational ClearCase
- Development Code Review and Checking
- Test Case Design
- Development Enterprise Application Integration (EAI)
- EXtreme Programming
- RUP
- Client Server Computing
- Rapid development
- Stakeholder engagement
- Team collaboration
- Strategic planning
- Analytical thinking
- Project implementation
- Requirements gathering
- Subject matter expert
- Technical documentation
- Integrity and honesty
- Object-Oriented
- Rapid Application Development (RAD)
- Code review
- UIMA
- Enterprise application integration
- EXtreme Programming
- RUP
- Microservices
- Semantic Web
- UIMA
- Client Server Computing
- E-commerce
- Amazon Web Services (AWS)
Certification
Certified MarkLogic Developer, 05/16
Languages
- Python
- Java
- XML
- XQuery
- Antlr4
- XSL
- SQL
- HTML
- Perl
- Oracle PL/SQL
- C
- Objective C
- UNIX Shell Scripting
Timeline
Consultant
Optum
03.2020 - Current
Data Architecture and API Consultant (contractor)
Allstate
07.2019 - 11.2019
API Consultant (contractor)
American Medical Association
10.2018 - 03.2019
Data and API Architect (contractor)
QSSI
10.2017 - 09.2018
MarkLogic Consultant (contractor)
IEEE
02.2017 - 09.2017
Principal
EasyMetaHub LLC
01.2016 - Current
Principal XML Data Architect (contractor)
Blue Cross Blue Shield of North Carolina
04.2013 - 12.2016
Senior Software Architect
GreatLinkUp LLC
06.2012 - 01.2017
Senior Software Architect
ZH Computer
12.2008 - 06.2012
Senior Consultant/Solution Architect
Parametric Technology Corporation
12.2002 - 10.2008
Senior Technical Consultant/Architect
Ensodex, Inc.
01.1999 - 01.2002
Software Engineer/ OO Developer/Architect
Integrity Solutions/KeyTech, LLC
01.1994 - 01.1999
Masters of Science - Software Engineering
University of Minnesota
Bachelor of Science - Computer Science
Northwestern University