CHARLES ROACH
Summary
Accomplished Business Analyst with over 10 years of experience in analyzing complex business structures and providing scalable solutions that enhance efficiency and productivity. Proficient in Business Intelligence (BI), Data Analytics, and Data Warehousing, complemented by expertise in QlikView and Tableau development. Demonstrated success in evidence-based decision-making through comprehensive data analytics and reporting while adept at business process modeling, requirements gathering, and project portfolio planning. Committed to leveraging analytical skills to drive strategic organizational objectives.
Overview
19
19
years of professional experience
Work History
Ramp Agent
SOUTHWEST AIRLINES
10.2023 - Current
- Performs various tasks related to aircraft operations including loading/unloading luggage and cargo, providing special handling for items when required.
- Performing safety checks and directing aircraft during taxi.
- Reporting all equipment malfunctions while having a strong familiarity with airport safety procedures.
Consultant / Batch Credit Services
TRANSUNION
01.2018 - Current
- Drive and support business operations through acquisition of credit/client data and activities for batch fulfillment.
- Support client marketing campaigns and account risk management.
- Provides a comprehensive understanding to program lifecycle requirements and fulfillment regarding both internal and external customers.
- Develop and execute design concepts, code standards and test plans to validate batch fulfillment system setup/output.
- Analyze data and test results to ensure integrity is maintained throughout program lifecycle.
- Identifying and implementing process improvement measures to increase efficiency of various customer programs.
- Review, analyze, and translate customer requirements into repeatable processes based on customer specifications.
- Provide comprehensive understanding of product knowledge to educate customers regarding their programs, identifying unnecessary products in addition to up-selling, thus saving money based on volumes and delivery intervals.
- Perform detailed analysis of source system data and subsequently model that data in Tableau.
- Manage projects and identifying risk while assisting with removing roadblocks that would potentially delay products and rollout of new initiatives.
- Communicate status updates to stakeholders throughout the delivery process.
- Working knowledge of Unix/Linux operating systems.
- Data manipulation/transformation and Presentation using software utilizes such as AbInitio and Tableau.
- Maintain and Improve relationships with third party vendors to ensure customer programs are executed at the highest level of service.
Business Analyst II / QlikView Developer
INTRINSIQ (AMERISOURCEBERGEN SPECIALTY GROUP)
11.2014 - 10.2017
- Design and develop QlikView data models, scripts, & dashboards to support business reporting needs.
- Perform detailed analysis of source system data and subsequently model that data in QlikView.
- Interact frequently with business owners/stakeholders to gather requirements for new development projects, assist in defect resolution during testing, etc.
- Leads scrum-based project planning initiatives focusing on defining project approaches, work breakdown structures (WBS), timelines, monitoring activities, and decision-making protocols.
- Define, plan, and execute unit and integration testing; complete system testing as appropriate.
- Generate business by creating new and maintaining existing relationships with physicians and other medical professionals.
- Successfully develops project schedules, timelines, statuses, system schematics, and process workflows utilizing agile methodologies.
- Defines full scope and all deliverables for new IT projects that support AmerisourceBergen’s programs for Medicare and Medicaid users, working with cross-functional teams to verify project feasibility and requirements.
- Monitors and tracks planned resource usage by activity pool, and reports on deviations.
- Provide strategy and feedback on physician market and competitors.
- Identify revenue opportunities for gains and losses.
- Establish and maintain a working relationship with the physician staff with respect to their compliance plan.
- Provide assistance to the Project Manager in monitoring project schedules, assignment of tasks, risk management plans, and test strategies.
- Leads project status meetings to review project schedules and project work estimates, reporting progress to the main Project Office.
- Acts as key project liaison for all departments, stakeholders, and offshore teams.
- Validates and tests data through SQL queries, and maps resulting activities.
- Acts as subject matter expert and resource for Tableau and QlikView, creating interactive worksheets and visuals such as scatterplots, heat maps, charts, and diagrams.
- Designs Exact, Transform and Load (ETL) packages utilized to transfer files into SQL Databases, and designed end-user reports.
- Designs extensive process documents, graphical models, and diagrams for business and technical users, utilizing Business Process Modeling Notation (BPMN) for clarity.
- Conducts formal process mapping utilizing BPMN and procedure standardization.
- Generates timely and current project reports using SQL and Access.
Business Systems Analyst Test, Senior
JP MORGAN CHASE
02.2012 - 11.2014
- Main responsibilities for supporting the development, implementation, and on-going enhancements to clients Business Analytics.
- Through my strong analytical skills coupled with the ability to understand the key business issues/complexities I am charged with the development of technical solutions that can inform and drive business goals.
- Created, reviewed, and evaluated test strategies and plans based on business requirements and development design documents.
- Conducted direct testing activities of internally and externally assigned technology, vendor, and business resources.
- Directed the set up and review of Information System Technology (IST) and User Acceptance Testing (UAT) support within Business-as-Usual (BAU) and Enterprise Release projects.
- Executed test scripts and resolved defect issues in coordination with the Systems Administration and Enterprise Release teams.
- Managed the identification and assignment of test accounts across multiple test projects within the same environments.
- Oversaw all defect management including determining severity and priority based on testing and business impacts (HP Quality Center).
- Acted as main liaison with other business units, IT teams, and vendors in support of assigned initiatives.
- Provided post implementation support to clients as needed, including final resolution of reported defects and participation in post implementation reviews.
- Acquired strong experience with test plan creation, automated test scripting, and load/stress testing.
Business Analyst II
JP MORGAN CHASE
07.2006 - 02.2012
- Coordinated the planning, testing, implementation, and execution of a wide spectrum of business initiatives, including correspondence and legal approval updates.
- Provided expertise to project teams on how to prioritize work, develop schedules, size the work effort, prepare plans, work with data and documentation, and resolve issues.
- Conducted gap analyses of business and execution process flows.
- Gathered, organized, analyzed, documented, and reported on information relating to business initiatives and processes.
- Established and sustained productive and credible relationships with internal and external business partners.
- Demonstrated expertise in the management of requirements throughout the software development lifecycle (SDLC).
Education
Bachelor of Business - Business
University of Texas At Arlington
Arlington, TX12-2016
Associates of Arts - Science
Richland College
Dallas, TXSkills
- SSIS
- SSRS
- Data Mining
- Aircraft handling
- Customer service
- Problem solving
- Team collaboration
- Communication skills
- Marshaling aircraft
- Tableau Server
- MS SQL Server 2008
- MS SQL Server 2005
- MS SQL Server 2000
- Microsoft Access
- Querying
- Data Cleansing
- Data Transformation
- Data Loading
- GE Centricity
- MS-Project
- MS Excel
- MS Visio
- SharePoint
- Cognos
- Passport
- Crystal Reports
- Salesforce
- HP Quality Center ALM
- Unix
- Ab Initio
Timeline
Ramp Agent
SOUTHWEST AIRLINES
10.2023 - Current
Consultant / Batch Credit Services
TRANSUNION
01.2018 - Current
Business Analyst II / QlikView Developer
INTRINSIQ (AMERISOURCEBERGEN SPECIALTY GROUP)
11.2014 - 10.2017
Business Systems Analyst Test, Senior
JP MORGAN CHASE
02.2012 - 11.2014
Business Analyst II
JP MORGAN CHASE
07.2006 - 02.2012
Bachelor of Business - Business
University of Texas At Arlington
Associates of Arts - Science
Richland College
Similar Profiles
Jenna PriceJenna Price
Flight Attendant at SkyWest Airlines/Southwest AirlinesFlight Attendant at SkyWest Airlines/Southwest Airlines
Margaret SaveMargaret Save
Freight Agent at Southwest AirlinesFreight Agent at Southwest Airlines
Antwan BranchAntwan Branch
Flight Attendant at Southwest AirlinesFlight Attendant at Southwest Airlines
Pedro HernandezPedro Hernandez
Administration Supervisors at SouthWest AirlinesAdministration Supervisors at SouthWest Airlines
Angelo CaneloAngelo Canelo
Ramp Agent / Lead Ramp Agent at Worldwide Flight ServicesRamp Agent / Lead Ramp Agent at Worldwide Flight Services