Resume of Lead Business Systems Analyst

Title
Lead Business Systems Analyst

Primary Skills
business analysis, SDLC, MS Office, Visio, MS Project, RUP/UML, HTML, XML, Website analysis, QA, technical analysis, PM

Location
US-SC-Columbia (will consider relocating)

Posted
Jun-01-07


SOFTWARE/LANGUAGES:

MS Project, MSOffice, MSAccess, Enterprise Architect, SQL Server, SDLC/BPE, .NET, JavaScripts. DB2, SQL, QMF, HTML, XML, UML/RUP, Microsoft Directory Smart, VISIO, TDS/Eclipsys (RFT and Matrix coding), MQ Series, LDAP, Crystal Reports, MVS, JCL, TSO/ISPF, UNIX, TSP/IP, Oracle, VSAM, CICS, Expediter, Internet Explorer, Powerbuilder, McAfee Help Desk, Storyboard, VSE, ADW (ER diagrammer and DFD), Word Perfect, CLIP, SAPIENS, EasyFlow, Peachtree Complete II, Dreamweaver, COBOL, COBOL II, SAS, ADCycle.


EDUCATION:

MBA, University of South Carolina. Concentration in Accounting and Finance.
B.S., Administrative Management, Clemson University. Minors in Accounting, Computer Science, and Law.
PMP, performing self-study classes to sit for PMP exam.


PROFESSIONAL EXPERIENCE:

04/06 - 05/06 SEA STAR LINE, LLC.
Project Manager/Business Analyst
• Managed web-based and hand-held software solutions for port intranet operations.
• Implemented project management software (MS Project) at port and instructed/trained employees on functions of the tool.
• Automated EDI ASC x12 transactions for error identification, tracking and resolution within back end (IVSS) systems. Identified EDI errors by using SQL to query the Oracle database to determine problem.
• Managed functions and personnel to include business and technical specification documents.
• Analyzed and developed use cases and activity diagrams in conjunction with clients and developers using Rational and Enterprise Architect.
• Managed subcontractors in development of Oracle and web-based systems.

11/04 -- Present LEAD CONSULTANT/SYSTEMS ANALYST
CorpWorx
• Currently working as a consultant/analyst on ad hoc basis via telecommuting.
• Marketed and implemented audit software developed for Sarbanes-Oxley compliance employing a unified corporate business model for definition of operational and financial performance objectives to include gap analysis, corporate systematic monitoring and government reporting using Oracle and Access.
• Gathered and documented industry-specific requirements (e.g., P&C and managed healthcare insurance) to create skeletal chart of accounts for product adaptation by business line. Implemented PDA/EDI transaction processing and error resolution.
• Authored technical and functional specifications to define system and environment requirements.

4/04 -- 7/04 ENVIRONMENT/INFRASTRUCTURE MANAGER
Blue Cross Blue Shield of Florida
• Primary contact for managed care health insurance environment infrastructure issues for Customer Relationship Management (CRM) web site development and supervision of test teams and business units. Provided senior management with performance reports by using SQL to query Oracle corporate database for related metrics.
• Developed and lead software implementation of processes and procedures for CRM/UML environment management strategy with technical developers as well as end-user business clients.
• Used TSO to edit and submit JCL for execution of billing programs.
• Managed the promotion of program code throughout all phases of SDLC (development, unit/system/Q/A, prod).
• Introduced EDI software into various user groups for tracking projects, management and accounting, actuarial and billing functions as well as error processing.
• Facilitated weekly meetings for environment pipeline to gather and author requirements and technical specification documents. Ensured release dates were being established and achieved on schedule. Monitored server loads for managed healthcare business systems (CRM, rating/premium, actuarial and billing).
• Developed and managed project plans and resource allocation for technical developments and enhancements.
• Created enterprise architecture diagrams reflecting all systems, databases, servers, interfaces as well as their connectivity and storage capacities. Created process flow diagrams, use cases, activity diagrams and testing matrices using Visio and RUP.
• Created and maintained environment documents (requirements, technical specs) for functional areas within CRM.



4/03 -- 11/03 LEAD WEB ANALYST & PROJECT COORDINATOR
Blue Cross Blue Shield of South Carolina
• Authored business requirements documents and technical specification documents for clients to develop commercial lines managed healthcare self-service web site.
• Wrote requirements for HIPAA EDI X12 transaction processing for managed healthcare regulatory compliance.
• Mapped enrollment, billing and capitation/provider remittances/advices and claims payment/advices for EDI ANSI X12 transaction processing.
• Functioned as primary business analyst liaison throughout all product development life cycle phases of .Net Systems self-service managed care commercial web sites and social security conversion project implementing in connection with HIPAA requirements.
• Translated end user client Web needs into technical solutions including design of Web pages utilizing Visio, development of use cases and process flow diagrams using RUP tools, data flow diagrams, interfaces, network reliability, and security.
• Trained and managed technical web and mainframe testing staff utilizing Rational Rose and MS Project and evaluated individuals on a performance level at required review times. Developed use cases and instructed clients/team members on their usability.
• Performed analysis, mapping, and translation of functional requirements; investigated and documented solution risks and barriers; recommended project approaches; prepared project plans; and produced client documentation (e.g., scope, requirements, and design documents and storyboards consisting of Web pages and business logic).
• Integrated architecture by developing solutions to bridge gaps in overall system structure and submitted validation jobs using TSO to include mainframe architecture, LDAP structure, Access database, INFOrm system and MQ formats.

8/01 -- 4/03 RETAIL CONSULTANT
• Ralph Lauren/Polo consultant for Strawbridge's national retail corporation in Philadelphia.
• Regional recipient of Ralph Lauren sales award and bonus for exceeding projected sales December 2002.
• Implemented inventory control and accounting measures and developed theft prevention processes (Strawbridge's -- Philadelphia).

4/99 -- 12/00 CLINICAL ANALYST/PROGRAMMER
Children's Hospital of Philadelphia
• Successfully managed Y2K QA clinical testing and implementation including development of test matrices, validation of results and implementation of programming changes utilizing DB2.
• Developed unit/system/integrated test matrices for clinical systems upgrades. Managed all phases of testing, re-coding, and validation.
• Performed requirements analysis and implemented software programming to clinical inpatient systems to create order sets, nursing and patient care summaries and online radiology reports and lab results using TDS Matrix coding and RFT coding.
• Functioned as liaison between programming staff and clinicians to determine system requirements and translation to system functional code. Clinical inpatient systems representative on Nursing Informatics team.
• Led problem resolution efforts when acting as Staff Duty Officer on call.
• Implemented TSO (formerly using Mountain Lakes) and trained clinical team on syntax and uses.

4/98 -- 3/99 SENIOR SYSTEMS MANAGER
Independence Blue Cross & Blue Shield
• Managed off-site subcontractor programming staff to implement software for statutory and ad hoc reports and managed care system production changes for the Government Programs business area.
• Began and implemented enforcement for HIPAA regulations for Medicaid and Medicare areas.
• Analyzed all user systems requests and assigned and managed programmer responsibility utilizing MS Project and other home-grown systems for accounting purposes. Prepared reviews and evaluated individual performance.
• Developed test matrices for Medicare and Medicaid requirements and supervised testing and subsequent implementation.
• Led implementation of state-managed Medicaid programs in Vermont and Texas.
• Authored RFP documents for submission to states for approval for Medicaid and Medicare programs.
• Conducted JAD sessions with users to gather and document system requirements for government programs.
• Designed Microsoft Access database for capture and reporting of provider, capitation, and billing data and developed SQL queries for successful monthly reconciliation of capitation and billing files.
• Developed Crystal reports to track managed healthcare metrics for Medicare and Medicaid.


12/95 -- 3/98 SENIOR PROGRAMMER/ANALYST
Reliance Insurance Company
• Functioned as project leader for redesign of COBOL and CICS legacy systems to relational database (DB2) systems.
• Responsible for programming, troubleshooting and maintenance of all statutory reinsurance, accounting and actuarial reports using COBOL/COBOL II/JCL and wrote ad hoc SQL queries using QMF to query DB2 tables.
• Performed month-, quarter- and year-end programming to reconcile financial statements for reinsurance, accounting & actuarial departments.
• Led JAD sessions with actuarial department to obtain reporting requirements and utilized Crystal to produce reports to meet actuarial needs (e.g., loss development triangles)

3/95 -- 12/95 SENIOR DATABASE ANALYST
Prudential Insurance Company of America
• Project leader for development and implementation of DB2 internal systems and software development for managed healthcare insurance applications (provider, eligibility, membership and billing).
• Responsible for maintenance and troubleshooting, requirements analysis, design, programming and installation of additional phases, user and system documentation and training using MSOffice, SQL with QMF, COBOL II, CICS and TSO/JCL on MVS.
• Facilitated client-IS JAD sessions to identify managed healthcare insurance systems data requirements. Documented requirements, business process flows and data modeling.

9/94 -- 3/95 SENIOR PROGRAMMER/ANALYST
Wachovia Bank of North Carolina
• Developed and implemented metrics EIS to measure internal bank statistics.
• Authored business requirements document and business processes documents and published internally.
• Primary liaison between business units and programmers developing data requirements and processing functionalities for the Metrics system.
• Programmed, scheduled and implemented DB2 utilities to support the Metrics system.

12/93 -- 9/94 SENIOR PROGRAMMER/ANALYST
Pennsylvania Manufacturers Association
• Team leader responsible for the re engineering and deployment of the workers compensation software.
• Performed and documented requirements analysis and led JAD sessions to develop new property and casualty insurance systems.
• Established test scenarios and led QA activities for workers comp programming.
•
7/90 -- 12/93 SYSTEMS ANALYST
Policy Management Systems Corporation
• Developed and deployed DB2-based managed healthcare insurance applications to capture provider, enrollment, membership and billing data for Blue Cross Blue Shield of Connecticut. Prepared business scope and business requirements documents. Analyzed data requirements from client JAD sessions and documented using ADW ER Diagrammer and DF Diagrammer.
• Developed test matrices and led QA activities for PMSC property and casualty insurance host and workstation systems for Management Decision Support and Reinsurance.
• Developed, documented and taught user and technical system design classes for IMIS, Reinsurance, RMF (4GL) and Interactive Bureau Facility reporting.
• Created, loaded and maintained DB2 tables for insurance company clients and created customized queries using SQL via QMF on MVS/TSO.
• Performed sales/marketing demos of systems products to insurance executives.


Accounting Experience:
Riverland Development Corporation, Inc., May 1988 - June 1990, General Manager.
Investors Title Insurance Company, April 1987 - February 1988, Assistant Branch Manager.
C&S Trust Company, June 1986 - February 1987, Bond Account Administrator.

Professional Designations:
Realtor's License, South Carolina 1990.
Certified Property Manager's License, South Carolina, 1990.

Volunteer Work:
Jacksonville Museum of Modern Art Junior League
Make-a-Wish of Northern Florida AIDS Benefit Foundation of South Carolina
Jacksonville Humane Society Cooperative Ministries (SC)
Providence Hospital (SC)

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-SC-Columbia »
View all resumes in US-SC »

View other Lead Business Systems Analyst resumes, IT Manager resumes