RESUME
***** ****** *****, *******, ** *****, Phone: 909-***-**** Cell #: 909-***-****
Email: ******@***.***
Femi Ayetiwa
Main Objectives Sr. Business Systems Analyst
Challenging position in Business systems analysis, data analysis, planning, implementation and testing that would best utilize expertise in business systems development. This position should have opportunities for an aggressive, dedicated individual with leadership abilities.
Areas of Expertise
Analytical and problem solving skills
Business Impact Analysis
Risk Assessment Analysis
Systems analysis and design methodologies
SQL, DB2, AS400 QUERY
Project management
Computer Skills: Microsoft Project, Visio, Microsoft Word, Excel, Cobol, RPG IV, HTML, XML, Java, JavaScript, DB2, 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, Endevor, JCL, CL, Crystal Report, SunGard EAS, Expediter, Changeman, HP Quality Center, Turnover, MS Project, MS PowerPoint, Visio, Designer 4.0, IBM iServers, OS/390, z/390, RS/6000, IBM 3033, AS/400, SOA, structured methodology.
Experience
6/2005- 4/2012 Life Care Assurance Company, Woodland Hills, CA 91367
Sr. Business Systems Analyst (Contractor)
• Worked on analysis and design of LifeCare insurance claims processing and payment system, clients web application systems requirement determination and development, writing specifications and test plans, and on various smaller projects such as clients’ data feed, web development requirements, agents’ internal replacement commission, premium billing, web content management, PDA insurance package support & maintenance, reporting systems using Crystal Report
• 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. Write specifications for system changes
• Performed fact-finding, data gathering and writes Systems Requirements Specifications for various projects. Conduct JAD sessions to elicit requirements
• Create physical and logical models of existing and new systems with DFD
• Create data models (ERD), build data dictionary, Use Case, Class & Interactions Diagrams
• Perform system design and writes program specifications. 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
• Engage in Business Continuity and Disaster Recovery planning analysis
• Develop Business Continuity Plan
• Conduct Business Impact Analysis
• Perform Risk Assessment and recommended improvements at various IT security levels
• Develop DR Test Scripts
• Implement DR tests
• Develop project management lifecycle and system development lifecycle standards by designing templates, including Object-Oriented Analysis for LifeCare Assurance Company
• Use SQL, AS 400 Query for data extraction from databases to support my analysis effort
• 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 for data analysis
• In all cases, uses either/both simple or complex queries/SQL
• Use Visio to create artifacts: DFD, ERD, HLD, Workflow diagrams
• Perform requirements elicitation through interviews, surveys, questionnaires, system study, site observation, use cases, process modeling, business analysis, workflow analysis, document analysis, and data analysis. Mentor junior Business Systems Analysts
• Platform: AS400/i5/OS v5R3, IBM/HP Servers, 2003 Server, EZ View, RPG IV, Cobol, SQL/400, JAVA, C#, HTML
2/2004-5/2005 EDS Corporation (Trinity), Rancho Cordova, CA
Sr Systems Engineer (Contractor)
• Perform research, fact-finding and business system analysis, enhancement and
maintenance of Claims application processing of CA-MMIS med-ical and medi-care
information system.
• Conduct research on problem statements to determine causes and solution to California Medicaid/Medicare application systems’ problems. Write program specifications for systems changes and perform project management activities.
• Platform: OS/VS Cobol, VS Cobol II, CICS, DB2, IBM z/390.
6/1997-12/2003 PMS Corporation/Mac Environmental Systems 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). Provide 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 process and data models, entity relationship diagrams, and data flow diagrams.
• Platform: AS400 COBOL, V/Basic, V/FoxPro, HP Server, 2003 server, IBM Workstation.
3/1994-5/1997 EDS Corporation (Tri-ad Systems), Cypress, CA
Systems Engineer (Contractor)
• Perform system design, program specification writing and coding of car dealership sales, accounting, and inventory application system for a major car manufacturing company. Code and tested 18 update, processing and report programs.
• Programming Language: 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
1/1988 – 4/1993 Ernst & Young & CO. 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.
• Platform: OS/VS Cobol, VS Cobol II, CICS, IMS, DB2, Easytrieve, IBM 3033.
Education Pratt Institute Brooklyn, New York
B.S. Information Systems Management
M.S. Computer Science
References: Available Upon Request