Shari Campbell

Senior Business Systems Analyst

Linkedin: www.linkedin.com/in/shari-campbell-BSA

Dedicated Professional with comprehensive Information Systems, Client Services and Project Management background in aerospace, insurance, accounts payable, manufacturing and healthcare applications. Application development, design, implementation and support including data analysis, workflow analysis, gap analysis, EDI mapping, project management, ITT and UAT support, trouble-shooting, customer support and special projects. Worked as FTE and Contractor.

Excellent interpersonal skills with peers (offshore and onsite), management and clients

Talented in building client relationships

Excellent documentation and training skills

High technical aptitude with dedication to accuracy

Strong analytical and problem solving skills

Conscientious, organized and detail oriented

Determined worker with a desire to excel

Work with HIPAA compliancy

Held secret DOD clearance

- TECHNICAL EXPERTISE -

Software: MS Access, MS SQLServer, Adobe Pro, MyPHP, MySQL, MS Office Suite Pro, Outlook, FileZilla, SmartFTP, PGP encryption, ssh, Salesforce, Rally, JIRA, Facets, Service Now, Altova Spy

Op Systems: MS Windows, Linux, DOS, IBM, IMS, TSO, Isilon OneFS, AS400

Languages: SQL, VBA, SAS, DB2, JCL, Cobol, Focus, Paradox, HTML, SSH

Protocols: FTP, SFTP, HTTPS, TCP/IP, SOAP UI, WinSCP, REST API

Tools: Explorer, Endevor, Subversion, Xpediter, UltraEdit, ERWIN, MF Cobol, MS Office Pro Suite, Edifecs, TOAD,

MS SharePoint

Databases: Oracle DB2, IBM DB2, SQL Server, Access, AS400, SAS, VSAM, IMS, XML, Linux

Methodologies: Critical Path, Waterfall, Agile/Scrum

- PROFESSIONAL EXPERIENCE -

T-Mobile, Bellevue WA September 2017 to Current

Senior Business Systems Analyst (contract thru Covestic)

Work in Enterprise Content Management group utilizing OpenText document design for development and integration in transitioning legacy SOAP services to digital architecture including REST API Microservices.

Facilitate document design sessions with customers including Legal, Finance, Marketing, Tax and Business Integration teams.

Manage developer sessions to determine system and programming requirements as well as provide technical documentation.

Create test plans and corresponding documentation (Use cases, test cases, acceptance criteria, etc.).

Utilize Sharepoint and Rally for all SDLC workflow and documentation requirements.

Milgard Manufacturing, Fife WA September 2014 to January 2017

Senior Business Systems Analyst (contract thru Mobius)

Work within Information Systems as a Data Integration Analyst mapping xml data from new front-end web-based quoting application as the source to existing canonical data structure in the target AS400 Manufacturing system. This interim solution would then be utilized to make a cross-over to the new Oracle ERP system.

Responsible for understanding the company’s product lines, models and various materials well enough to be able to translate data components properly in order to generate required key structure to pass to the manufacturing system.

Design and document technical solutions for SharePoint portal company requirements.

Communicate data needs to vendor (owns XML) as required to meet integration requirements.

Design, plan and perform unit and integration testing to ensure solution quality.

Work with AS400 developers in creating special programs for manipulating data based on rules and requirements.

Utilize Service Now for all SDLC workflow and documentation requirements.

Work in an agile environment.

Cambia Health Solutions (IBM) at Regence, Seattle WA** March 2014 to June 2014

Senior Business Systems Analyst (contract thru Collabera and IBM)

Work with Accountable Health Strategy (AHS) to assist in implementation of systems supporting Regence provider agreements which strive for the “triple aim” of lowering the cost of care, improving patient experience and improving the quality of care.

Work in an agile environment including daily scrum and attend all management-level Story Grooming (story card writing) sessions.

Responsible for understanding policy and business requirements in order to support development efforts supporting all aspects of member attribution through compilation of data coming from claims and payments.

Develop Physical Data Maps (PDMs) and transform rules to map data to and from various databases (Oracle, SAS, Sybase) that build the infrastructure for the AHS system and reporting.

Use SQL (TOAD) to query systems and databases to understand data relationships and system architecture in order to provide data mapping and business rules.

Partner with cross-departmental teams (Strategic Finance and Health Informatics) to determine best solution for reporting to Providers in support of AHS initiatives.

Participate in ITT of all system integration and assist in UAT of the same.

Cambia Health Solutions (IBM) at Regence, Seattle WA** April 2013 to March 2014

Senior Business Systems Analyst (contract thru Collabera and IBM)

Work with Middleware Enrollment Development Team to assist in implementation of all components necessary to prepare Cambia to handle Exchange enrollment as a result of the Affordable Care Act aka "Obamacare".

Work in an agile environment including daily scrum. Participated in management-level Story Grooming (story card writing) sessions.

Responsible for understanding policy and business requirements coming from the Federal and State-based exchanges (WA & OR) and developing technical artifacts including Physical Data Maps, Data Flow Diagrams, Flow Charts, User Stories, Use Cases, Test Cases, Business Requirement Documents and Technical Specs.

Develop Physical Data Maps (PDMs) for inbound and outbound X12 834 enrollment and audit files. Mapping includes 834 to canonical XML and transform rules for systems and formats required to map to and from Oracle database components in issuer enrollment systems. In addition, mapping required to extract data from enrollment systems (Facets) to required format used by Datastage and Edifecs developers.

Use SQL (TOAD) to query systems and databases to understand data relationships and system architecture in order to provide data mapping and business rules.

Use SQL to query databases during integration testing to confirm enrollment components are working as expected.

Attend all Exchange webinars representing Cambia as an Issuer and act as a SME on 834 Enrollment EDI.

Participate in ITT of all components and phases of Exchange enrollment implementation and assist in UAT of the same.

Helped design and maintain team Sharepoint site.

EMC Isilon (Advantage Technical Resources), Seattle WA Oct 2012 to April 2013

Senior Business Systems Analyst (contract thru Advantage) **

Work with Isilon Global Services subject matter experts to generate use cases and other artifacts required in the development of a Log Analyzer for troubleshooting and configuring Isilon systems for their customers.

Interact with Isilon personnel in an agile environment to fully understand workflow and functionality for each log analyzer component, command input/output, and data flow.

Present ideas and lead effective meetings to stimulate creative ideas from others.

Collaborate with technical resources to provide input into technical design and identify technical implementation requirements.

Interpret technical documentation to meet business needs and correctly identify system / functional interdependencies.

Evaluate business process implications of system requirements and make appropriate design recommendations.

Identify test scenarios, define test plans, author scripts and complete execution of test plans to ensure business requirements are met.

Partner with the business to define and manage user acceptance testing.

Imagenet LLC, Kent WA** April 2008 to May 2012

Project Manager / Business Systems Analyst

Serve as Special Projects Systems Analyst and Project Manager reporting directly to CEO.

Drive business participation in understanding project deliverables using Agile/Scrum development methodologies.

Collaborate with stakeholders and business teams in order to set and manage project scope for quality, on time and on budget.

Develop project definition, project plan and SoW. Create functional specs and process flow diagrams as required.

Serve as liaison to development teams using Agile/Scrum methodologies. Document detailed programming requirement specifications and effectively communicate all project details to IT team members in the US and Offshore.

Escalate issues as necessary to manage and resolve while considering priority and customer impact.

Work closely with clients to interpret business requirements in order to implement and maintain personalized web sites for image hosting, document retrieval and EDI processes. Design and develop training materials for proprietary SaaS systems.

Translate client business requirements for imaging and data capture of documents in order to convert to electronic data interchange (EDI X12) in both healthcare (837I, 837P, Encounters) and accounting formats (810, 820, 838, 850, 860, etc.). Performed extensive data mapping including data quality analysis to insure data accuracy and consistency for the downstream ERP applications. Help determine data validation requirements for front-end applications based on client and application business rules.

Understand client EMR systems in order to generate solutions for implementing paper documents and bridging with legacy systems. Worked to define and build Master Patient Index files by determining key data and locating primary data sources. Identified information gaps against new requirements or conflicts across multiple legacy databases.

Write SQL statements to examine data for inconsistencies and verification. Use SQL for data manipulation and ETL processes.

Key Accomplishments

Collaborated with large Seattle dairy company in the development of a proprietary invoice front-end processing solution for their Oracle system. Serve as project manager and backlog owner as well as perform all business requirements and analysis tasks. Coordinated all aspects of business process implementation from paper invoice pick up and emailed invoices to system and EDI delivery. Implemented over 1000 invoice templates for OCR and data extraction. Developed mapping document and business rules for vendor verification and 3-way matching. Lead joint application development sessions to create web workflow for invoices that did not pass PO matching processes and validations (3-way). Workflow includes invoice routing for coding and approvals to final EDI 810 creation.

Collaborated with large distribution client in designing intricate online trade vendor management system to include vendor creation and maintenance as well as a complete approval routing process with automated email alerts. Analysis of existing manual workflow to produce AS-IS and TO-BE documentation. Conducted gap analysis to ensure all requirements are met or exceeded with the new system implementation. Defined data input edits based on business rules, data definition documentation and workflow diagrams.

Played a key role in the transition from vendor dependency to the launch of data entry and application processing operations to our Manila, Philippines office.

Successfully restored an Outpatient web site repository for a mental health hospital client that saved our business relationship and gave the client confidence to trust us with additional business services. Involved in deep data evaluation and careful data scrubbing in order to track the issues and then correct them while ensuring data integrity during and post-migration. Successfully transitioned all charge slip processing (IDX) from US to offshore teams. Decreased costs and increased efficiency in processing.

Helped design and implement a secure online request function allowing clients quick retrieval of their paper patient charts in electronic version via “Scan on Demand” procedures.

Collaborated with client and developers in designing and launching an online patient forms management system for entering healthcare medical records and Service Activity Logs. Client utilizes system to integrate existing paper documents into a new EMR (Sigmund) system.

Successfully and seamlessly integrated data from company’s new web-based quoting software to existing manufacturing system which generates 80% of all manufacturing business. This implementation provides the first step in a strategic cross-over to a new Oracle ERP system.

Federal Way School District, Federal Way WA Oct 2006 to April 2008

Emergency Substitute Teacher

Rainier Assessment Group, Consulting Jan 1999 to April 2008

Student Writing Assessor

SAFECO Home Office, Seattle WA 1990 to 1995

Programmer Analyst II – Corporate Systems

Key team member in design and development of Safeco’s Agency system. Convert legacy COBOL/IMS system to DB2 using data modeling analysis and object oriented design (ERWIN). Write data definition language (DDL), create DB2 tables and populate from data in existing IMS databases. Create embedded SQL statements within enterprise systems in order to utilize new RDB’s. Create user interface and reporting systems as required. Create training documentation and update company standardized documentation. Serve as project lead on multiple projects.

Programmer Analyst – Network Management Systems

Maintenance and enhancement of a IBM mainframe Network Management System that tracks all aspects of Safeco’s network structures. Generate test scenarios for all programming installations. Help develop department-wide off-site disaster recovery plans.

Northrop Grumman Advanced Systems Division (B-2 Bomber) Palmdale, CA 1986 to 1989

Programmer Analyst – Secret DOD Clearance

Design, program and implement engineering release tracking system replacing previous labor intensive manual procedures. Create ad-hoc SAS batch reports and charts as required for management. Develop automated JCL procedure using SAS programming to generate statistics and “write” GDDM programs that generated graphic charts.

Rockwell International, Palmdale, CA 1984 to 1986

Mfg Systems Programmer – Operations Change Control

Design, program and implement SAS batch system for monitoring and maintaining commitment compliance on all design contract changes on the B-1B Bomber program. System replaces previous labor-intensive manual procedures. Produce system description, procedures and training program. Develop ad hoc batch reports as required.

- EDUCATION -

California State University, Northridge

Bachelor of Arts: Journalism

Contact this candidate