OBJECTIVE

Challenging position in business and technical analysis, data analysis, planning, implementation and testing that would best utilize my expertise in business systems development.

SKILLS

Microsoft Project, Visio, Microsoft Word, Excel, Cobol, RPG IV, HTML, XML, Java, JavaScript, DB2, ISPF/QMF, Access, FoxPro, SQL, SAP, Oracle 8, Easytrieve, Crystal report, OS400, Windows XP, Windows NT/2000 Server, Unix, shell scripting, AIX, VSAM, File - aid, Calligo, Daptiv, Abendaid, Endeavor, JCL, CL, Crystal Report, Informatica, BO, Expediter, SunGard EAS, EPIC, Changeman, Turnover, HP quality center, MS Project, MS PowerPoint, UML, Visio, Designer 4.0, IBM iServers, OS/390, z/390, RS/6000, IBM 3033, AS/400, SOA, SDLC, Structured & Agile methodologies.

EXPERIENCE

Confidential, Columbia, MD

Business Analyst

• Perform requirement gathering and elicitation from business clients- CMS (Physician Quality Measures reporting)
• Responsible for creation and update of PQRS Submission Portals Functional Specification
• Develop use cases, process flow, user story, identify DB impacts and other code impacts
• Develop Wireframes and other activities as appropriate for Software Engineers
• Develop mockup Wireframes using HTML, JavaScript and PHP for clients JAD sessions
• Creates Interface Control Documents (ICD) using CMS XLC designed templates
• Involved in analysis and redesign of PQRS Submission Reporting System Portal using J2EE JSP, JSTL, J2EE Servlet and Ajax technologies. Wrote redesign functional specification

Platform: Oracle 11g, SQL, PL/SQL, Java, JavaScript, PHP, XML, HTML, Cognos

Confidential, Silver Spring, MD

Sr. Business Systems Analyst

• Support Business Users in KMATE - TMS (The Membership System) and MBE - (Medicare/Medicaid Business Engine) application systems error and resolutions
• Wrote system specifications for Medicare membership enrollment delivery process solution to CMS
• Wrote functional requirement specifications and perform logical solution design for implementation of VA Medicaid management information systems engine
• Conduct requirements determination with business user onshore/offshore
• Conduct data research and analysis to resolve healthcare Medicare/Medicaid eligibility, enrollment and billing issues
• Resolve Kbridge interface issues between TMS and EPIC HealthConnect
• Generate Quarterly Audit Reconciliation report for compliance department
• Extract, Transform and Load - data for business users to manipulate into reports

Platform: SQL, DB2, RS 6000 servers, Cache, Mumps, EPIC/HealthConnect

Confidential, Woodland Hills, CA

Sr. Business Systems Analyst

• Project lead for the analysis and design of Life Care insurance claims processing and payment system, including California healthcare Medicare Part D and Medicare supplement. Wrote BRD, SRS, SDD, assist in implementation, QA and UAT
• Assisted in the analysis and design of a web portal “Quoting Facility Application”. Responsible systems requirement determination, writing systems requirement specifications and test plans.
• Worked on billing subsystem problems. Investigate, analyze and resolve issues with monthly premium billing. System is supposed to carry forward premium that are past due to next billing cycle, send notices before payment due date and not lapse policies. Create BRD and wrote specifications (SRS) for system changes
• Performed fact-finding, data gathering and wrote Systems Requirements Specifications for various projects, ex - Data Feed design, extraction & Data Warehouse Implementation.
• Involved in projects enhancing PDA system to improve data reconciliation to supporting daily/monthly/ad hoc reports for Marketing, POS, Claims, Compliance, Accounting and client companies. Conducted JAD sessions to elicit requirements
• Created physical and logical models of existing and new systems with Data Flow Diagrams.
• Created processes & data models (ERD), built data dictionary, Use Case, Class & Interactions Diagrams
• Performed system design and wrote program specifications.
• Involved in Data Feed design, extraction & Data Warehouse implementation.
• Participated in projects enhancing PDA system to improve data reconciliation to supporting daily/monthly/ad hoc reports for Marketing, POS, Claims, Compliance, Accounting and client companies
• Performed gap analysis, data mapping & conversion for implementation of EAS accounting system. Created Excel spreadsheet containing data elements of old GL data and new GL data. Identify obsolete, valid, blank data elements and data to be migrated. Wrote specifications for interface data migration/integration.
• Engaged in Business Continuity and Disaster Recovery planning analysis. Wrote Business Impact Analysis Report. Develop DR Test Scripts. Implement DR tests.
• Perform Risk Assessment and recommended improvements at various IT security levels
• Develop project management lifecycle and system development lifecycle standards by designing templates, including Object-Oriented Analysis for Confidential
• Create SQL programs to extract and create data feed files that are FTP to third party clients for data warehousing and mining
• Generate ad-hoc reports for Users using SQL, AS/400 queries, and Crystal Report on database files.
• Generate and extract data using SQL queries for data analysis.
• In all cases, used either/both simple or complex queries/SQL
• Used Visio to create artifacts: DFD, ERD, HLD, UML diagrams, Workflow diagrams
• Perform requirements elicitation through interviews, surveys, questionnaires, system studies, site observation, use cases, process modeling, business analysis, workflow analysis, document analysis, and data analysis. Mentor junior Business Systems Analysts

Platform: SQL, DB2, AS400/i5/OS v5R3, IBM/HP Servers, 2003 Server, EZ View, RPG IV, Cobol, SQL/400, JAVA, C#, HTML

Confidential, Rancho Cordova, CA

Sr Systems Engineer

• Perform research, fact-finding and business system analysis, enhancement and maintenance of Claims application processing of CA-MMIS Medicare and Medicaid information system.
• Conduct research on problem statements to determine causes and solution to California Medicaid/Medicare application systems’ problems. Wrote program specifications for systems changes and perform project management activities.

Platform: OS/VS Cobol, VS Cobol II, CICS, DB2, IBM z/390, MVS, TSO/ISPF

Confidential, Costa Mesa, CA

Sr Systems Analyst

• Perform system analysis and design to implement Hospital Management Systems (HMS), and Relational Database design and modeling for a hospital clinic. Applications include: Patients Record Administration, Staff Administration, Work and Ward Scheduling, Operations Scheduling, Patient Billing System, and with implementation of HIPAA compliance regulation requirements (837).
• Provided system support for PMS insurance software packages.
• Consult with user and vendors for need assessment
• Conduct JRP/JAD session to determine information requirements
• Write systems specification and documentation including processes and data models, entity relationship diagrams, and data flow diagrams.

Platform: AS/400, AS 400 COBOL, V/Basic, V/FoxPro, HP Server, 2003 server, IBM Workstation.

Confidential, Cypress, CA

Systems Engineer (Contractor)

• Perform systems analysis and design, program specification writing and coding of Automotive car dealership sales, accounting, inventory and costing application systems for a major car manufacturing company. Code and tested 18 update, processing and report programs.
• Programming Language: AS/400, AS400 Cobol, RPG IV, & DB2.
• Perform computer programming and maintenance of telephone billing and accounting system. Provide file transfer and on-call supports for applications processing for EDS clients.

Platform: Micro Focus COBOL, SQL & PL/SQL, C, Sun Sparc 2000

Confidential, Houston, TX

Systems Consultants

• Conducts business systems investigation/feasibility studies, evaluation and analysis of an existing business and accounting systems procedures, operations for various business clients, including computerized systems.
• Perform technical design, functional, program specifications writing and CICS programming of Sales and Debtors Accounting System for an oil Company.
• Code 36 validation, update, inquiry and reporting programs: batch and CICS online programming of account receivables, payables, costing, general ledger and payroll systems, and for various clients.
• Perform analysis and design, coding and implementation of cash management system - treasury, COT processing for a commercial bank.

Platform: OS/VS Cobol, VS Cobol II, CICS, IMS, DB2, Easytrieve, IBM 3033.