Brian R. Kramer Email & Phone Number

Cleveland, Ohio, United States

Cleveland, Ohio, United States

Participation in efforts to migrate sourcing solutions.

Columbus, Ohio

AUTOMATED CLASSROOM SECURITY APPLICATION - 5/2019 to 11/2019Increased facility management capacity with delivery of a C# application that automates locking and unlocking of classrooms. Functionality:• Read start and end dates and times of scheduled classes from Google Calendar utilizing provided APIs.• Update programmable logic controller (PLC) with class start and end dates and times, driving the automated unlocking and locking of classroom doors. • Identify individuals entering facility with security badge utilizing security system's provided API and update PLC.

Cleveland/Akron, Ohio Area

Forms parterships with multiple buisness and technlogy teams to deliver process improvements within the supply chain of various product lines. Positive impact provided to business teams through deconstruction of a complex environment of processes, process reconfiguration, functional and technical requirements documentation, and quality assurance and regression testing of end to end information technology solutions. Success driven through forming partnerships with, and being accountable to, IT management, project managers, product owners, and software developers through all phases of the project life cycle.• Delivered a new global purchase card product line by identifying, capturing, and implementing new business processes (origination, credit, accounting, reconciliation, foreign exchange, finance, operations) and documenting the supporting software solution’s functional requirements.• Provided a commercial purchase card product line with a streamlined origination process and minimized its commercial operations resources with the identification and documentation of business processes and functional requirements for an online application solution.

Cleveland, Ohio

Project leadership and delivery of efforts with budgets between $50K and $750K. Managed multiple teams and efforts through all aspects of the software development life cycle.• Lowered processing cycle times with the implementation of a centralized account receivables application and the installation of new high speed document scanning hardware at multiple lockbox facilities.• Reduced system outages and manual data correction cycle times by delivering an automated bill pay correction and validation solution for consumer and mortgage loan accounting applications.• Expanded investigation capabilities to financial crimes teams with a fuzzy-logic wire transfer enhancement solution.• Provided capital structure compliance with Basel III accords through the implementation of a new deposit product.• Delivered annual product pricing changes to a centralized product and service billing application.

Cleveland, Ohio

• Provided process enhancements in partnership with a origination team. Reduced cycle times by 45%, without technology enhancements, through the capture and analysis of current-state process flows and the delivery and governance of future-state process flows that included a strategy of implementing parallel operational efforts. • Reduced balance and control resources by providing process definition, functional requirements, and performance testing to a centralized general ledger accounting solution allowing the cost-center accounts to reconcile against the general ledger in an automated fashion.• Shortened loan processing cycle times and reduced support resources with the delivery of a paperless, document-driven, loan servicing workflow application. • Modernized five enterprise content management and workflow applications with vendor platform upgrades by providing requirements documentation, management of client verification testing, and automated performance testing.• Reduced process cycle times, payment errors and support resources by providing requirements documentation and managing client testing of a new mutual fund sales commission payment application.• Eliminated a separately managed account product by delivering lifecycle analyses showing the product was not profitable.• Reduced support resources through delivery of functional requirements for a Web-based ecommerce solution allowing customers to perform on-line securities lending transactions.

Cleveland, Ohio

Developed and supported Asset Management, Commercial Banking and Loan Services applications.• Provided a marketing team improved ability to deliver dynamic Web-based content to customers with the development of a full-stack solution utilizing a database, SOA middleware, and Web front end technologies.• Automated document scanning volume reporting through development of a T-SQL program that retrieves job volume data from a SQL Server database and sends it to comma separated value files for MS Excel consumption.• Consolidated disparate task management applications through delivery of a C# solution that transfers workflow task data between one workflow application’s Oracle database and another’s SQL Server database.• Avoided financial penalties through support activities during disruptions of automated system operations, ensuring customers’ 401(k) fund trades were submitted within industry established deadlines.• Provided clients with enhanced 401(k) balancing and account reporting functionalities using UNIX, Oracle and SQR reporting solutions.• Delivered enhanced insight to customers’ 401(k) distribution information through conversion of the customer portal to WebSphere.

Columbus, Ohio

AUTOMATED LIGHT FIXTURE QUALITY TESTING APPLICATION - 4/2017 to 12/2017Saved ongoing warranty expenses by providing a C# / SQL Server solution to automate LED fixture programming and quality verification. Delivered requirements include:• Scan order barcode to retrieve quantity, vendor, required internal component, and ROM chip configuration data.• Scan each fixture’s barcode and internal components’ barcodes to validate fixture assembly to order specifications.• Program components’ internal ROM chips to specified configuration.• Interface with proprietary VISION quality test solution to validate ROM chips are programmed to specification.• Notify line workers of the success or failure of each fixture’s ROM chip programming and quality test results.• Log results of each fixture’s programming and quality test results to client’s database.• Interface with and support assembly line safety protocols (GFCI, Ground Continuity, etc.).DALI LIGHT FIXTURE PROGRAMMING APPLICATION - 4/2015 to 7/2015Increased assembly line capacity by creating a C++ application to automate programming of scene and dimming curve values into DALI standard LED light fixtures. Solution delivered the following functionality:• Select required configuration file to program the dimming curve and scene values into the fixtures’ ROM chips.• Allow manual modification of a subset of the sixteen scene values to be programmed into the fixture.• Switch between decimal and hexadecimal display of scene values.• Store user-defined scene values for the selected configuration file.• Execute programming of the fixture’s ROM chip with dimming curve and each of the sixteen scene values. • Notify assembly line worker of success or failure of each fixture’s programming sequence.• Log result of each fixture’s programming sequence.