Brendon Claussen Email & Phone Number

Chandler, Az, Us

Chandler, Arizona, United States

Claussen Consulting, led by a seasoned IT professional with over 20 years of experience, provides comprehensive IT solutions and support, including automation, reporting, Power BI, development, Power Stack, SQL, workflow automation, and project management. The firm's expertise spans a wide range of industries, including criminal justice records management, banking fraud prevention, healthcare analysis, and federal background checks. With a talent for rapidly learning and adapting to new programming languages and writing complex scripts for automation, Claussen Consulting excels at transforming and optimizing systems to integrate data sharing and optimize operational processes across diverse stakeholder organizations. As a collaborative leader, the team applies industry knowledge and advanced analytic techniques to deliver critical business intelligence, insights, and recommendations.

• Design, develop, and implement robust database solutions and models to efficiently store and retrieve company data.• Lead the data tier architecture and design initiatives for the accounting team, ensuring alignment with business goals and objectives.• Collaborate with senior product owners and end-user groups to define business requirements, and guide the technical development and support of databases, query tools, and reporting dashboards.• Assess and identify database structure requirements by analyzing client operations, applications, and programming needs.• Evaluate and optimize existing systems and processes to enhance data sharing and streamline operational workflows.• Prepare comprehensive and accurate database design and architecture reports for management and executive teams to support informed decision-making.• Foster cross-functional collaboration among accounting, development, and business teams to ensure seamless integration of database solutions.• Monitor system performance by conducting regular tests, troubleshooting issues, and integrating new features to maintain optimal performance.• Train and support staff members in database-related tasks to improve overall efficiency and understanding.• Provide timely assistance by addressing and resolving system-related issues as they arise.

Phoenix, Arizona Area

Work closely with 194 municipal courts, serving as the sole SQL Server Developer, charged with compiling data from separate records management systems into a central State repository for access by multiple third-party stakeholders, including the DPS, FBI, and US Secret Service. Hold ownership for database design, SSIS projects, ETL processes, and applications development to facilitate reporting requirements for diverse end-users, and meet all legislative mandates. Employ MS SQL Server to create stored procedures, administer security, and other common elements. Collaborate with business users and other developers to evaluate current workflows, refine requirements, and update internal/external software and web-based tools. Make critical contributions to quality assurance programs, troubleshooting emergent errors/issues, implementing robust solutions, and reinforcing best practices. Author documentation detailing designs, structures, and processes, in addition to creating/maintaining conceptual, logical, and physical database models to ensure system continuity. Respond to ad-hoc requests, write and performance-tune T-SQL/SQL code and environments, deploy SQL agent jobs, and analyze orphaned database processes to inform functionality enhancements.Designed the state’s National Instant Criminal Background Check Systems (NICS) Felony Conviction Process, automating reporting to DPS and NICS for Federal background checks, and providing critical data on persons with disqualifying criminal records to prevent access to firearms, Developed an E-Access platform allowing attorneys to purchase and download documents electronically, in lieu of in-person retrieval from court archives, effectively decreasing processing time, and increasing court revenues. Maintain Judge Performance Review (JPR) data, performing biennial data compilation, ETL, and analysis of judge ratings to be published on the JPR website to inform constituents ahead of general elections.

Scottsdale, Az

Oversaw the full development life cycle for a new analytical model designed to integrate multiple state systems, successfully overhauling an antiquated platform, and facilitating data transfer, processing, analysis, and reporting for tens of thousands of state/federal Medicare and Medicaid prescription transactions/claims. Interfaced with business users to gather requirements, author functional and technical documents, and design pilot/demo as well as final models, including schema, tables, views, stored procedures, triggers, functions, columns, and indexes. Innovated SQL Server macros, ETL processes, and complex queries to eliminate 100s of hours of work previously expended on compiling state flat/text files. Coded business logic/scripts to create Excel reports and SharePoint dashboards, reducing KPI reporting activities from over a week to real time updates.Employed macros and .bat files to develop SSIS packages, schedule jobs, and plan error logging to maintain deployed analytical models, and execute periodic updates. Spearheaded various IT initiatives related to database, member/client platform, and source system migrations/consolidations.Identified and resolved a persistent data-flow error, recovering over $2M in lost profits, and significantly increasing future revenues potential for the company.

Chandler, Az

Utilized SQL Server, Teradata, and Oracle databases to develop IT tools/queries, and analyze debit card transactions and claims data, identifying patterns, and linking multiple fraud events. Evaluated associations between phone numbers and comprised accounts to support internal investigation teams and law enforcement agencies. Introduced systems to automatically reroute suspicious account calls to fraud representatives, assign propensity scores to various data transmitted to the bank, and measure risk based on criteria. Flagged a fraud ring opening multiple accounts using arbitrary changes in the owner’s identification from a Nigerian passport to a TN driver’s license, and more; consistently monitoring the accounts for over two months, leading to the successful dissolution of a fraud ring, and saving the bank millions of dollars.Developed a custom query to track key stroke data and log employee activity to identify possible employee links to fraudulent accounts. Researched/recommended the use of voice biometrics as a fraud prevention tool, leading to over $29M in savings. Introduced standard operating procedures, security policies, and anti-money laundering (AML) strategies to manage risk exposures, combat fraud, and comply with all Bank Security Act (BSA) and Regulation E (Reg E) requirements.

Worldwide

Bachelor Of Science - Bs, Information Technology/Database Management

Associate Of Arts - Aa, Accounting