Albert Koenig Email & Phone Number

Tacoma, Washington, United States

Responsible for developing/testing/maintaining a wide variety of complex custom and internally-developed databases, data sets, interfaces, reports, forms and associated business intelligence/training tools that automate end-user workflow/processes and facilitate informed analyses and related decision-making. Determining, from an array of options, how best to build solid applications/programs/reports that meet professional standards and all systems and user requirements. Understanding a wide variety of business systems/applications, data types and range of formats, as well as the business purpose behind data management needs. Addressing and resolving non-compatibility issues between systems/applications and validating the accuracy and appropriateness of complex and multi-dimensional data.

Wichtia, Ks

During my time at the Sedgwick County Developmental Disability Organization (SCDDO), I provided technical support and training to SCDDO staff and aided the management team by creating reports, automating processes, and performing business analysis.Accomplishments:Authored a white paper on the technology needs of the SCDDO.Led a change in SCDDO staff desk manual usage, changing from disparate stand-alone text documents to a centralized wiki-style solution.Authored a Request for Proposal (RFP) aimed at replacing the existing Electronic Medical Records (EMR) system.Served on the RFP response evaluation committee, and provided a perspective that significantly impacted the evaluation results.Wrote a procedure using Used SQL Server (MS SQL) Management Studio to import functional assessment results to the EMR. This saved a coworker from hours of tedious data entry each week and eliminated the chance of manual transcription errors.Created an Access database and user interface for reversible de-identification of persons in the EMR, in compliance with HIPAA regulations.Implemented PsychConsult Managed Care (MCO), a software system used for contract management and quality oversight of a network of medical service providers.Created an Access database and user interface for reports not originally available in MCO, such as a service provider directory (neatly formatted for printing), full histories of quality oversight visits, and pending license expiration lists.Wrote extensive process guide documentation for MCO, and provided usage training to SCDDO staff.

Wichita, Kansas Area

At Wolters Kluwer, I provided a diverse set of skills to the Sales Tax division, including the Agile Software Development team, the Customer Support team, and the Forms Acquisition team. My duties consisted of QA testing for internal processes, analysis of customer-submitted data, writing technical documentation for internal and external users, and creating data-driven reports to guide management and business strategy.Experience:Report Writing- Created scheduled and ad-hoc reports from database exports for varied teams within Wolters Kluwer.Business Analysis- Created reports on the benefits and drawbacks of automating different processes. Created product usage reports for Marketing and Sales teams, improving revenue and increasing retention by guiding clients to best-fit service subscriptions. Created reports summarizing the frequency and severity of recurring customer-raised issues.Data Analysis- Audited raw data to find root causes of unexpected results. Technical Documentation- Created and maintained product guides for use by other teams, and edited customer-facing in-product help files to reflect updated functions. Documented processes to standardize methods and ease training of new personnel.Software QA- Designed and ran test cases for product enhancements, including back-end data processing, database subscription update packages, and customer-facing user interface. Investigated Support tickets to ensure reproducibility and add detailed context.Sales Tax Electronic Filing Subject Matter Expert- Worked closely with multiple state governments on mandatory electronic filing system requirements and testing. Acquired new tax form revisions and submitted samples for government approval. User Interface Design- Created layout for web-based sales tax forms based on a combination of paper form layout and electronic filing requirements.Communications Liaison- First point of contact between Software Development team and Sales, Support, and Form Acquisition teams.

Wichita, Kansas Area

The contract Spherion mediated was for work within Wolters Kluwer. For the first six months, I executed manual test scripts. For the next six months, I also wrote new scripts based on design documents. During the last six months, my duties expanded to include training new software tester contractors. I was ultimately offered a direct position with Wolters Kluwer.