Lori Wang Corliss

LoriInColorado@gmail.com 719-304-1143 Colorado Springs

PROFESSIONAL SUMMARY

10 years combined experience as Business Analyst, Data Analyst and Technical Analyst. Have performed roles of Application Developer, Development/Test/Production Support, Tester, System Designer, Trainer, Technical Writer, Data Mapping. Strong experience in Business Intelligence, Commercial Information Analysis, Sales Operations Forecasting, Billing & Invoicing, Telecommunications, Insurance Fraud Tracking & Claims Processing including work in the Biotechnology-Pharmaceutical, Well-being, and Healthcare Insurance industries – improving areas through technology and information. Lead Crystal Reports Developer for nearly 7 years.
Strong in Business and Technical Analysis, in dynamic, market-driven environment. Excellent communication, synergy and teamwork skills. Strong internal/external customer service abilities.
Extensive Systems Development Life Cycle (SDLC) experience in Mainframe, GUI, Intra/Internet and SOA Environments.
Highly experienced in translating Business-to-Technical requirements / specifications, workflow documentation, managing project changes and assessments, establishing timelines and work plans, testing and code review, technical documentation, design and development, problem resolution, and technical Training.
Database Analysis – SQL Queries, Entity-Relationship Diagrams, Stored Procedures.

PROFESSIONAL EXPERIENCE

VERIZON BUSINESS – Colorado Springs, CO 3/07 - present
Business/Technical/Data Analyst, Development/Test/Production Support, Tester, Data Mapping Analyst, Trainer, Technical Writer, Project Manager

Exception Handling / Production Support Tool Project (BA) March-May 07
EOM (Enterprise Order Management) Notifications (Tester/Dev Support/BA/PM) May-Aug 07
EOM Networx and Commercial Projects (BA) Aug-Nov 07
EOM Networx Projects and Notifications (Development/Test/Production Support, Data Mapping, BA/PM) Nov 07 - present

Telecommunications – Engineering & Product Development, Order Management/Entry, Billing & Notification, Invoicing and Inventory:

High level of multi-tasking, concentration. Support high volume of projects, overlapping releases.
Work with integrated environment of large scale Order Entry and/or Order Management systems that is part of a complex Service Oriented Architecture environment and is composed of several legacy OM systems.
Work closely with customer and Development team, lead architects and analysts to develop assessments and project phasing.
Define business process flows and work flows within network environment.
Work through approach, business requirement meetings to gather Requirements, plan Timeline, Work Plans, Design, Development, Testing Cycle. Document, organize and distribute session outcomes, requirements, changes, issues, process, workflow
ssess development, test, and support impacts for Order Management (OM) system. As part of the assessment, coordinate and deliver approach and assessment details within the OM system and with external systems and organizations.
Translate business needs into Functional/Technical Requirements and approaches, design documents, report mockups and define technical solutions for developers via EDI (Electronic Data Interchange) and various tools.
Develop and maintain Requirement Tractability Matrices RTMs, and develop design documentation based on assessment, approach, and project RTM.
Manage all requirement and technical approach aspects of projects through entire SDLC.
Represent organization in multi-system approach definition meetings, document meeting outcomes, and coordinate all internal and external follow-ups to close issues in support of the project requirements and system approach.
Communicate project status and issues across the organization and to external customers.
Analyze project request documentation and existing system documentation to develop detailed system flows, scenario flows, approach documents, and assessments including level of effort and system impacts, risks, and dependencies.
Control project scope through change control. Support and drive maintenance and change requests, and enhancements. Work with system architect and development leads to document necessary software changes to meet the project requirements.
Work with Development/Engineering, QA and BA teams to complete testing and user acceptance at design, functional and UI levels.
Provide direction to internal project team and coordinate development activities with external organizations to address project issues.
Support multi system data mapping efforts to define OM impacts.
Work heavily with Data Mapping and BOD (Business Object Document) tools and documents.
Support full System Development Life Cycle (SDLC) with understanding of various technologies and platforms such SOA (Service Oriented Architecture), ESB (Enterprise Server Bus), BOD (Business Object Document), web, client/server and mainframe, entity-relationship diagrams (ERDs) and relational database concepts, and object-oriented programming.
Use numerous XML messaging, BOD Data Mapping, Testing, Research, Troubleshooting and Documentation tools (ex: XMLSpy, Notepad++, WinSCP, Quality Center/Test Director, Excel, Project and Team Management Sharepoints, etc).
Translate Business-to-Technical specs and requirements involving Java, WebServices development (SOAP, WSDL, JMS), WSAD and Websphere Application Server, XML, XSLT, DTDs and Schemas.
Test, research and troubleshoot/support defects using XML messaging software and utilizing data and XML files/logs on mid-range applications / servers.
Work on complex problems where analysis of situations or data requires an in-depth evaluation of various factors. Make decisions/judgments within broadly defined practices, policies and rules for selecting methods, techniques, and evaluation criteria to reach goal and results. Identify strategies needed to fix problems. Use initiative/judgment to handle non-routine matters & ambiguous issues.
Use skills to support Software test, System integration, Quality Assurance, and delivery of technical solutions while focusing on business products and customer satisfaction.
Support all phases of testing by clarifying requirements, researching detailed issues, and defining solutions in support of project requirements and system architectural direction.
Efficient computer skills and proficiency (ex – using short cut keys, functions, very fast and accurate typer, utilize Sharepoints/Wikis, etc).
Excellent/fluid communication, support, relationships and synergy with internal/external customers and team (from Development and Testing group to Management/Executives). Very strong ability to communicate requirements, needs, defects, issues and motivate development teams to complete work, development, defect fixes and package, implement, document and present back to customers.
Drive projects to completion and perform Post-Implementation Review.

CORLISS CONSULTING, Inc - Colorado Springs, CO 12/06 – 3/07
Crystal Reports Developer, Technical Business Analyst

Small Business Consulting, Business Intelligence Reporting:

Worked on two-person team to consult with Small Business customers to enhance and accelerate their business (ex: Building/Contractors, Electricians, Photography, Massage Therapy, Magazines, Beauty/Hair Salon, Sports, etc).
Helped design websites and hosting.
Gathered all information, requirements, business goals (small-to-large) via customer interviews (customized to customer type) and documented business plans. Worked with customer on pricing/budget, timeline, user acceptance, etc. Received optimal feedback from customers regarding increased business from website, visibility, online marketing/advertising.
Created Crystal Reports sourced from Excel and MS-SQL database. Data varied from customer and company information, rate/price sheets, to revenue/profit. Created adhoc reports and canned/recurring reports (ex: daily, monthly, annual) from simple drilldowns to complex summaries with charts/graphs, cross-tabs, running totals, multiple sections, etc.

ZANTAZ, Inc - Pleasanton, CA / Colorado Springs, CO 6/06 - 12/06
Technical Business Analyst, Crystal Reports and DB2 SQL Developer

Information Retention & Discovery Management Solutions – Engineering & Product Development:

Work closely with customer and team to translate business needs into Functional/Technical Requirements, design documents, report mockups and defining technical solutions via EDI (Electronic Data Interchange). Work through approach, business requirement meetings to gather requirements, plan Design, Development, Testing Cycle. Document, organize and distribute session outcomes, requirements, changes, issues, process, workflow.
Work with Engineering, QA and BA teams to complete testing and user acceptance at design, functional and UI levels.
Lead research for solutions, debugging, and enhancements with business objects.
Work heavily with relationship database models, schemas & entity-relationship diagrams (ERM) to create Technical/System Design Documents, develop DB2 SQL Stored Procedures and Crystal Reports.
Work with Engineering & BA team to design and develop Zantaz’s Security, Auditing and investigation reports, later to be integrated into customer UI via Java Reporting Component (JRC) SDK.
Work daily using Crystal Reports Designer XI R2 and JRC Viewer, DB2 stored procedures, tables, relational database.
Managing & uploading Stored Procedures/Reports on associated servers/UI using SecureCRT and Win Command Prompt.
Modify CSS (Cascading Style Sheets) code and files to debug Crystal design bugs.
Develop complex reports – multi-functioned, leveled and grouped, summary functionality in main reports providing detailed drilldown through OnDemand Sub-reports, dynamic link labeling, complex functions, cross-tabs, charts, shared variables, imported parameters and record sets from stored procedures, conditionally suppressed sections, error handling/messaging, clean and attractive designs, user friendly with instructional ToolTips.

GENENTECH, Inc - South San Francisco, CA 2/06 – 6/06
Technical Business Analyst, Crystal Reports and ORACLE SQL Developer

Commercial Information & Sales Operations/Business Intelligence:

Work closely with team to translate business needs into Functional/Technical Requirements, Report Mockups, and defining technical solutions via EDI (Electronic Data Interchange). Requirements/Issues Meetings to gather Requirements, plan Design, Development, Testing Cycle. Document session outcomes, requirements, changes, issues, workflow in network environment.
Work with Developer, QA, BA teams for testing and User Acceptance at design, functional and UI levels.
Work daily using Oracle stored procedures, materialized views, tables, data warehouses, Data Marts, and Crystal Reports Designer and Server/Enterprise. Developed complex reports w/ similar features as above (Zantaz project).
Work heavily w/ relationship database models, schemas & entity-relationship diagrams (ERM) to create technical design documents, and develop Oracle SQL Stored Procedures and Crystal Reports.
Worked with main CISO/BI Developer group to develop Genentech's Product Sales, Forecasting, Case Investigation Reports.

EDS (DHS/Medi-Cal) - Rancho Cordova, CA / Plano, TX 8/98 – 2/06
Business/Technical/Data Analyst, Lead Crystal Reports Developer
**Account SME Crystal Reports Developer/analyst on 4 critical projects for State of CA/Dept of Health Services for >6 YRS.

Business/Tech/Data Analyst, Lead Crystal Reports Developer, Database Analyst
Medi-Cal PlanView / Billing, Resource & Project Management Project 04–06
Denti-Cal Surveillance and Utilization Reporting System (SURS) + Denti-Cal MS Project Server (MSPS) Projects 05–06

Worked closely with customers, upper level and project Management, BA/SA, Development, DBA, Network and QA team to translate Business needs into functional/technical requirements, design documents, report mockups and defining technical solutions via EDI (Electronic Data Interchange).
Worked through approach, issues/assessment, business requirement/JAD meetings to gather requirements and plan design, development, testing cycle, SDLC steps/Phasing/timeline. Document, organize and distribute session outcomes, requirements, changes, issues, process and workflow.
Worked with customer, Developer, QA, BA teams for testing and User Acceptance at design, functional, UI levels.
Worked heavily with relationship database models, schemas & Entity-Relationship Diagrams (ERMs) to create technical/system design documents, develop ORACLE, DB2, MS-SQL stored procedures and Crystal Reports.
Performed large amount of SQL querying/coding to complete major and time critical changes on ORACLE SQL database for account billing and all report, database, system troubleshooting.
Developed and transformed many advanced reports using complex relational database methods, and developing ORACLE, DB2, MS-SQL scripts/queries/views for all EDS/Medi-Cal and Denti-Cal accounts’ Project & Resource Management, Time Reporting, Billing, Invoicing, and Denti-Cal’s utilization surveillance reporting to track provider & recipient abuse and fraud.
Researching web integration methods using Java technology (JSP, JSF tags, ASP and Java Reporting Components) and Crystal Enterprise/CR Server, working with network/DBA team to debug problems.
Proficient in MSPS & PlanView project management portfolio tools for business/technical analysis, troubleshooting.
trained team in complex crystal report development, relational database work, SQL scripting.
Greatly improved customer business processes for multi-level EDS management and customer (CA Dept of Health Services, Medi-Cal, Denti-Cal). Transformed tedious, budget/time costly, manual Excel/Access reports into dynamic, powerful Crystal Reports, exportable to numerous formats through automatic scheduling.
COST SAVINGS – thousands of man hours and dollars per year, and increased accuracy.

Mainframe Business/Technical/Data Analyst, Tester, Trainer, Technical Writer, Mainframe Application Developer
Medi-Cal Mainframe Reports To Web Project 03-04
COST & TIME SAVINGS. All Mainframe applications support Medi-Cal Claims Processing and functions (Claims Adjudication, Case Management, Denial of Claim, Explanation of Benefits, etc), all Reports mainframe based. Team completed major transformation of Medi-Cal Report format, system, user usage and process – transforming users’ use of green-bar hardcopy reports into online/digital OnDemand reports. Completed all SDLC steps, from business/user level/current process, to code standards creation, development, testing, code review, user manual/training documentation, implementation, training.
Lead team through JCL coding, code review phases, troubleshooting within iterative phases implementations.
Lead team & performed all testing (Unit, System, User Acceptance) and code review phases via use cases.
Wrote important Coding Standards/Technical Guide for all account’s programming teams.
Massive project & changes for Medi-Cal - trained customers and team on coding standards and testing process.
Worked closely with customer and Mainframe team to translate business needs into functional/technical requirements and defining technical solutions. Worked through approach, business requirement and JAD meetings to gather requirements, plan SDLC steps/project phasing, manage problems, risks, impacts, dependencies and assessments. Document, organize and distribute session outcomes, requirements, changes, issues, process and workflow within network environment.
Developed and modified COBOL, DYL280, and SAS Mainframe programs and modules using TSO/IPF, File-Aid, Panvalet, CHAMP, Endevor, Utilities, etc.
Set up and Indexed reports for web display using IBM OnDemand Reporting and Content Management.
Carried out On-Call Cycle duty for Mainframe job maintenance/queue system (‘01-Apr ‘02) using COBOL, JCL, Utilities.
Participated on Kaizen Team to complete Kaizen process for claims processing and operations for Medi-Cal.
Helped review and test with key data entry/claims processing team as a volunteer on key data entry team to process thousands of Medi-Cal claims, flag errors, and help account reach volume goals.
Applications and reports on Medi-Cal/Medicaid Management Information System (MMIS) and ensure compliance with Health Insurance Portability and Accountability Act (HIPAA) standards

Business/Technical/Data Analyst, Tester, Trainer, Technical Writer, Lead Crystal Reports Developer
Medi-Cal Audits & Investigations / Department of Health Services (DHS) Project 00-02
Billions of $$$ lost from Medi-Cal Fraud. Governor pushed for Medi-Cal Reform and highly increased Audits & Investigations, through major INITIATIVE - new, complex Fraud Tracking System, Repository and Reporting system. Team worked closely with all 3 Branches – Financial Audits, Medical
Review, Investigations Branch – to accomplish initiative. Completed all SDLC steps, from business/user level/current process, to code standards creation, development, testing, user manual/training documentation, implementation, training.
Performed most roles through entire systems development life cycle in iterative phases – planning process/workflow and requirements gathering during approach, issues/assessment, business requirement/JAD meetings, technical research and determining technical solutions, managing risks/assessments, impacts/dependencies, business to functional/technical translation, design & development, debugging, testing, training, system migration, post implementation, documentation (business, risks, design, technical, testing, issues, training).
Developed strong verbal/written communication skills through high level of interaction and strong relationships with customers, development team, and management.
Coded and developed large number of complex Crystal Reports for all 3 Branches of audits & investigations department.
Worked heavily w/ relationship database models, schemas & entity-relationship diagrams (ERM) to create Technical/System Design Documents and Crystal Reports.
Lead team & performed all testing (Unit, System, User Acceptance) and code review phases via Use Cases.
Trained customers and team members on Crystal Reports development using SQL relational databases through full-day training courses. Created all curriculum, training materials and manuals.

EDS (DHS/Medi-Cal, Children’s Med Svcs) – Sacramento & Rancho Cordova, CA 8/98 – 4/00
Business/Systems Analyst, Claims Processing, Claims Tester

Conducted Medi-Cal CLAIMS TESTING for all Claim Types (HCFA1500/UB 92 - Medical, LTC, In/Outpatient, Vision, X-Over, Pharmacy), Functions (Claims Adjudication, Case Management, Denial of Claim, Explanation of Benefits, etc), Provider/Beneficiary Master Files on Medi-Cal/Medicaid management Information System (MMIS), using TSO/IPF, File-Aid, etc.
Completed Business/Systems Analysis, research, problem analysis, testing, customer interviews, documentation for Problem Statements.
Designed multiple functions for Children’s Medical Services system (CMS Net). Completed Design and Testing DOCUMENTATION for CMSNet functions. Facilitated and scripted for Business Process Flow, Workflow, approach definition Meetings, and managed Problems and Change mequirements.

UCDAVIS MEDICAL SCHOOL & CENTER – Davis/Sacramento, CA 96 - 97
Oncology Research – Data/Tech/Systems Analyst, Cell Culturist, Writer, Trainer

Worked with Oncology Team to study chemotherapy induced prostate cancer cell death. Very strong teamwork ability.
Very strong Data/Trend Analysis, technical/scientific analysis, research skills to determine conclusions, trends, and required change in direction/methods. Strong technical writing and documentation skills – aided in Literature Publication, completed detailed Scientific Reports, Scientific bookkeeping.
Record, analyze, plot, graph/chart, document, report all steps/cycles, research discoveries w/ DeltaGraph, QuattroPro, WordPerfect, pharma and molecular modeling software.
Extreme concentration, meticulousness, detail-orientation, discipline, strict timing/cell cycle. Cell culture, transfection, cell counting, genetic engineering techniques.
Trained students on cell culture techniques. Strong leadership, training, oral/written communication.

EDUCATION

University of California, Davis - Davis, CA 9/92 – 6/97:   B.S. Degree in Biochemistry
Ohlone College - Fremont, CA 97 – 98:   Structured Programming, C, C++, Data Structures, UNIX OS, UNIX Shell-Programming
EDS Electronics Data Systems – Plano, TX 2/00-4/00:   C, SQL Programming, UNIX OS, vi-editor, Data Structures
TRAINING in Progress:   ActionScript, FLASH.   Future training: .NET, Java. Toastmasters/Public speaking.
TECHNICAL SKILLS
SQL / DATABASE:
RDBMS Schemas/Models, ERDs, SQL Scripting/Querying, ORACLE PL/SQL, Stored Procedures/Views, DYNAMIC SQL; ORACLE 8i, 9i - Data Warehouses/Data Marts/Materialized Views/Tables, Oracle SQL+/Toad; DB2 SQL, DB2 database, DBVisualizer; MS-SQL database, MS Query Analyzer (for MSPS/MS Project reports); System/DB Troubleshooting. OAGIS BOD, Data Mapping.
APPLICATIONS:
MS Word/Excel/Access, Relational Database - RDBMS Schemas, ERDs, SQL Querying.
ANALYSIS / SDLC / TECHNICAL WRITING:
Analysis - Requirements gathering, Business to Functional/Technical Requirements Translation, customer engagement/meeting facilitation, design specification, technical writing/documentation, research, development, code review, testing (system, unit, user acceptance), debug and troubleshooting, training, implementation, post implementation, service delivery and customer support). Technical Documents - Business to Functional/Technical Requirements Translation, Training Manuals/Guides, Technical System Design, Coding Standards/Technical Guides, Code Review Procedure, Test Scripts/Results Document).
TEAM LEAD:
Design and Development, Code Review, Testing, Customer Support
TRAINING:
Designed/conducted customer & internal Technical Training Courses, Training materials/manuals.
CRYSTAL REPORTS:
Lead Developer and account Subject Matter Expert.Crystal Designer XI/10.0/9.0/ 8.0/8.5/7.0, Crystal Enterprise/Server XI (Console)/Administrator, Java Reporting Component (JRC) Viewer. Relational Databasing – Schemas/Models/Joins, SQL Scripting/Querying/Stored Procs.
PROGRAMMING:
SQL, Oracle PL/SQL, DB2 SQL, MS-SQL, XML, ActionScript, HTML. Exposure: CSS (Cascading Style Sheets), SAS, Schema/Lisp, Adobe Flash Professional 8.0, HTML, Adobe Dreamweaver, Fireworks, Contribute, FlashPaper, Flex, MS Expression, TortoiseSVN (Version Mgmt), MS FrontPage, C++, Java, XSLT
UNIX / LINUX:
VI-editor, Unix-Shell Programming, SQL, C
SYSTEMS:
Windows ’98/NT/2000/XP, Unix/Linux, MS-DOS
SOFTWARE:
Adobe/Macromedia Flash Professional 8.0, Adobe Acrobat, MS Photo Editor, MS Office Suite (MS Excel, Access, IE), Firefox, Visio, Notepad Editor (coding), Command Prompt, FTP, SecureCRT, MS Project Server, PlanView. Oracle SQL+, Toad, DBVisualizer, Crystal Reports Designer, Crystal Enterprise/Server, Crystal Administrator, Turbo/Borland C++, Panvalet, File-Aid, CHAMP, Endevor, IBM Demand. Exposure: MS Expression (Blend/Design/Web), MS Query Analyzer, MS FrontPage, IBM Eclipse SDK.

COMMUNITY INVOLVEMENT

Pianist – Perform piano concerts for Elderly Care, Convalescent Home. Piano competition – Wins/donation toward local Music communities, students, groups.
Organist – Volunteer/play for church.
Triathlete/Runner/Kayaker/Climber/Nature Clean-up – Pikes Peak Road Runners, PP Triathlon Club, PP Whitewater Club. Support Timing/Aid Stations at races when not competing. Race donations to schools/groups. Pikes Peak, River, Park cleanup.
Children’s Health/Sports, Girls On The Run, Big Sibling/Runner – Work with young girls/boys to get active, promote health, nutrition, fun. Childhood obesity/diabetes prevention. Run races with young athletes for mental/team support.
Cancer Research Scientist/Support – Oncology Research, UCMedical. American Cancer Society, LIVEStrong, Komen.
PreMed Team – Sutter ER/ICU, Nursing Home. Provide medical, emotional support. Clean, bathe, feed. Crisis Management.
Global Volunteer Team – Nature/Mtn/River Cleanup, Blood, Food/Clothes Bank, Children’s/Women’s Shelter/WEAVE.