Business Analyst Application Development

Kirven Dunham, Jr

Senior Business Analyst

************@*****.*** • 916-***-****

LinkedIn • Rancho Cordova, CA 95670

Accomplished professional with extensive experience in gathering and documenting business requirements, conducting gap analysis, creating detailed workflows, and developing comprehensive functional and technical documentation.

Well-versed in driving system improvements and processes to ensure timely project delivery aligned with both business and user needs. Competent in leading high-impact projects at BTIS Inc. and Cordoba Corp, including company integrations, email processing automation, and application development. Excel in database design and development, with background at Health Net in designing ETL processes and database models for Auto Error Correction System. Possesses in-depth knowledge of database management, with hands-on expertise in Oracle, SQL Server, and PL/SQL. Skilled in managing and integrating complex systems to meet business goals and propel operational efficiency. Resourceful in overseeing complex projects and system integration efforts, accelerating user satisfaction. Recognized for leadership in major projects such as California High-Speed Rail and Amdocs database management initiatives, as well as for holding patent in software development and data integration. Proficient in project management tools such as JIRA and Azure DevOps, and business analysis tools like Axure and Visio. Adept at UI/UX development, vendor management, and quality assurance, committed to devising scalable solutions to support business growth and technical excellence.

Areas of Expertise

● Vendor & Stakeholder Management

● Prototyping & UX Workflow Design

● Data Management & Warehousing

● Business Requirements Gathering

● Systems Integration & Application Development

● Integration Projects & Process Automation

● Cross-functional Team Management

● Database Design & Optimization

● Data Processing & ETL Development

● Testing, UAT, & Quality Assurance

● Project & Team Leadership

● Business Systems Analysis

Professional Experience

BTIS Inc., Rocklin, CA

Business System Analyst II

2022 — Present

Lead requirements gathering, system integration documentation, and UAT coordination for successful deployments with minimal post-release issues. Automate daily email workflows to reduce manual effort by over 50% and increase accuracy. Manage stakeholder engagement through regular meetings to align solutions with business goals and accelerate decision-making. Direct cross-functional collaboration with third-party vendors and internal teams to deliver high-quality solutions on schedule. Oversee backlog grooming, user story creation, and task prioritization to improve delivery timelines and development focus. Identify and resolve software issues to boost application stability and performance.

●Spearheaded integration of newly acquired companies by defining business and technical requirements, resulting in streamlined operations and lowered transition time.

●Enhanced quality and completeness of requirements through collaborative validation sessions to decrease rework and minimize post-production defects.

●Supervised team of developers and QA analysts for prompt resolution of production issues and adherence to coding standards.

●Developed 13 interactive applications using EasySend to amplify improved customer experience and operational efficiency.

●Created and maintained detailed user stories and conducted gap analysis to align development efforts with business goals.

●Designed end-to-end workflows and proposed system enhancements for elevated cross-functional process efficiency.

Cordoba Corp, Sacramento, CA

Business System Analyst II (California High-Speed Rail Project)

2016 — 2022

Coordinated UAT and authored detailed test scripts for solution quality and alignment with business needs. Crafted testing and training plans to support seamless rollouts and user adoption. Consolidated and prioritized requirements; created vendor evaluation frameworks to enable objective, data-driven decisions. Facilitated vendor demos and scoring by delivering actionable insights to inform executive technology selection. Aided software configuration and headed joint testing sessions with vendors for timely issue resolution. Formulated high-fidelity Axure prototypes to promote stakeholder alignment and lessen development rework. Executed current-state assessments and gap analyses to determine process inefficiencies and advance strategic improvements.

●Elicited and documented complex requirements from cross-functional teams to ascertain successful design and implementation of up to 13 system modules and optimize collaboration across six business units.

●Authored detailed functional design documents and contributed to maintenance and operations (M&O) planning to guarantee long-term system sustainability.

●Served as Lead Business Analyst across 2–3 concurrent projects to effectively guide competing priorities and attain timely delivery of high-quality solutions.

●Translated business needs into actionable user stories and functional use cases to increase clarity for development teams and delivery timelines.

●Steered high-profile environmental initiative (EMMA), resulting in gaining recognition and interest from multiple state agencies for potential adoption.

●Mapped current/future-state workflows to detect process inefficiencies for informed redesigns and smooth system integration.

PowerSchool, Folsom, CA

Senior Application Engineer

2007 — 2016

Designed scalable database schemas and led end-to-end implementation for improved data integrity and system performance. Modernized routine database tasks through scripting to cut manual effort and system downtime by 30%. Cleansed and formatted customer data sets for development and demonstrations to enhance prototyping and stakeholder feedback cycles. Administered servers with 5–30 databases for optimal uptime, performance, and compliance with organizational standards. Conducted scheduled server maintenance to ensure database reliability, data security, and sustained operational efficiency.

●Captured and interpreted business requirements from six stakeholders into actionable technical specifications to elevate project alignment and stakeholder satisfaction.

●Collaborated cross-functionally with UI and support teams for seamless integration and rapid issue resolution, thus accelerating overall user experience.

●Fueled front-end validation by revising UI components with SQL and JavaScript, preventing data entry errors and support tickets.

●Engineered efficient ETL processes via Oracle PL/SQL to drive data integration and processing speed across multiple systems.

●Formulated and maintained custom reporting solutions to enable clients to gain timely insights and make informed decisions.

●Directed SQL Review and Improvement team to significantly maximize query performance and lower report generation time.

Additional Experience

System Analyst, Health Net, Rancho Cordova, CA

Senior Software Engineer, Amdocs, El Dorado Hills, CA

Programmer & Analyst, Intel, Folsom, CA

Education

Bachelor of Science in Computer Science, Purdue University, School of Science, West Lafayette, IN

Technical Proficiencies

Databases & Query Languages: Oracle, SQL Server, PL/SQL

Project Management & Methodologies: Agile, Scrum, JIRA, Azure DevOps

Business Analysis & Modeling Tools: Axure, Visio, EasySend

Productivity & Data Tools: Microsoft Excel (Advanced)

Contact this candidate