Uploaded File
add photo
Branden
woods.branden@gmail.com
310-993-4161
Anaheim, CA 92804
Business Analyst II
12 years experience W2
0
Recommendations
Average rating
29
Profile views
Summary

Summary of Qualifications

  • Provide robust modeling and reporting to facilitate executive-level decision making.
  • Strong analytical skills; support operations through analysis of key performance indicators and trends.
  • Consensus-driven communicator; liaise across various business units and promote organizational success.
  • Rapidly adapt to new technologies and possess expertise with MS Word, MS PowerBI, Visio, PowerPoint, Excel, Access, and SQL.
  • Data Management
  • Pivot Table Development and Management
  • Ad-Hoc reports and dashboards
  • Process Improvement

Accomplishments

  • Collaborated with different departments and management teams to standardize new processes.
  • Analyzed and compiled extensive survey data across all Molina Healthcare plans.
  • Completed an extensive ITIL Foundation training.

Education

  • California State University, Fullerton - Fullerton, CA
  • Bachelors of Science in Information Systems Degree Anticipated: In progress
  • Orange Coast College and Golden West College - Orange County, CA.
  • Associates in Science, completed 90 units of coursework
  • Comprehensive coursework in business fundamentals, accounting, finance, and computer science.

Experience
Business Analyst II
Banking/Financial
Nov 2019 - Jun 2020
Irvine, CA
(Contract)
  • Assessed current state of operational procedures within the PBM to propose improvements to current processes and procedures.
  • Worked with other PBM colleagues as well as external department staff to capture business needs in order to provide and implement solutions for PBM reporting and analytics.
  • Captured impact of new procedures and report to leadership in order to demonstrate success and areas of opportunity.
  • Created just in time/ad-hoc client analysis of pharmacy activity in order to provide clients with reports.
  • Developed reports that demonstrate impact and progress of PBM processes in order to show success and areas of opportunities for the process.
  • Created and deliver daily, bi-monthly, monthly, and yearly analytics reports for business performance, client metrics, member impact, internal key performance indicators (KPI), claims performance, and financials.
  • Performed analytics for files provided by external or internal.
  • Created internal audit procedures for reporting and analysis.
  • Provided audit and reporting data around internal customer service.
  • Worked with the Director of Pharmacy Operations to manage current projects.
  • Assessed the current state of PBM Operations to develop projects.
Business Analysis
Remove Skill
Business Analyst
Banking/Financial
Nov 2018 - Jun 2019
Irvine, CA
  • Defined and built data collection, analysis, and reporting capabilities and developed and maintained reports and dashboards.
  • Developed projects to solve for data related challenges.
  • Researched and analyzed Medicare and Medicaid claims to determine the financial impact.
  • Developed a project plan, resourcing plan and obtained alignment from stakeholders. Collaborated on projects and managed and executed deliverables, worked independently to develop options and recommendations and implement solutions.
  • Provided technical and project management support in the selection and development of the criteria in the selection of business partners.
  • Review BPO proposals & renewals, draft preliminary outlines, and perform statistical analysis.
  • Responsible for compilation of data and information analysis.
  • Drafted flowcharts and operational workflows as required for Lean initiatives, process improvement, and audit requests.
  • Reported analysis findings as required.
  • Took a lead role in the development, maintenance, and publishing of internal/external policies and procedures.
  • Worked on system and software projects while using Agile Methodologies. Worked with product owners, scrum masters and client to execute all projects.
Business Analysis Process Improvement
Remove Skill
Business Systems Analyst
Information Technology
May 2015 - Nov 2018
Long Beach, CA
  • Works with business unit leaders and SMEs to understand and document current state, the challenges that exist within the operational infrastructure, including identification of business and technical gaps.
  • Imported and exported data from text files, saved queries, or databases used automatic outlining, inserted subtotals, created advanced filters, and used database functions in SQL and Excel.
  • Lead projects that involved system implementation/improvement of QNXT and Trizetto systems while using Agile methods. Worked with scrum masters and product owners to execute all projects timely.
  • Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, and refreshed and formatted pivot tables in Excel.
  • Conduct preliminary investigation for all project requests review requirements, specifications, test, support and training plans to ensure they are in line with business objectives on projects
  • Act as a liaison between IT and the business making recommendations for product enhancement conduct interviews and perform analysis to create cases for projects
  • Manages day-to-day operational aspects of all assigned projects and gains consensus from stakeholders to ensure successful implementation.
  • Acts as primary point of contact for the project team during development to clarify business requirements, resolve issues, and make recommendations as needed where business impacts may arise.
Agile Methodology BSA Microsoft Excel Scrum Scrum Master SQL System Analysis
Remove Skill
Business Analyst
Healthcare
Sep 2013 - May 2015
Long Beach, CA
  • Performed ad-hoc reporting requests using existing reports, writing a SQL query and or working with other departments to obtain data.
  • Generated and distributed routine reports in Excel to support data and improvement of initiatives; provided analytical, problem solving expertise, including: definition, documentation, and specifications; recognized, identified and documented changes to existing business processes and identified new opportunities for process developments and improvement
  • Developed and maintained a variety of reports types, including but limited to pivot, tabular, drill down, matrix, charts in Excel
  • Worked on projects involving root cause analysis and process improvement using Excel for data analysis and Swim lane flow chart for building out processes.
  • Worked with vendors and procurement for purchase order creation, review, approval processing and supplier performance tracking
Business Analysis Microsoft Excel Process Improvement SQL
Remove Skill
Project Manager
Information Technology
Mar 2010 - Sep 2013
Irvine, CA
  • Established project management processes and methodologies to ensure assigned projects were delivered on time, within budget and met high quality standards and Leadership expectations using the appropriate tools.
  • Synthesized information from multiple sources into informational documents and diagrams with purpose.
  • Tracked costs and performance, service levels and other metrics required to ensure project goals and objectives are met.
  • Analyzed business workflow and system needs for conversions and migrations to ensure that encounter, recovery and cost savings regulations are met
  • Continually explore opportunities to improve processes in the ongoing development of analytical tools and models, ad-hoc reports, dashboards and analysis
  • Lead a team of over 30 which included; cross training, assigned work, monitored productivity, on/off boarded, vendor relations, processed, revaluated, and renewed Purchase Orders.
Project Management
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Science in Information Systems Degree
California State University
Information Systems Degree Anticipated
Orange Coast College and Golden West College
Minor: progress
Orange Coast College and Golden West College
Skills
Microsoft Excel
2018
5
SQL
2018
5
Agile Methodology
2018
3
BSA
2018
3
Project Management
2013
3
Scrum
2018
3
Scrum Master
2018
3
System Analysis
2018
3
Business Analysis
2020
2
Process Improvement
2019
2