TECHNICAL SKILLS:

SOFTWARE: ADABAS/NATURAL, NATURAL CONTRUCT, NATURAL CONNECTION, SUPERNATURAL, NATURAL OS2, PREDICT/PREDICT Case, ADABAS Online Services, NATURAL Security, Replicator, COMPLETE, REVIEW, DFA/PEEK/tRelational/DPS, Entire - X, COBOL, Direct Call, CICS, VSE/VSAM, TSO/ISPF, OS/JCL, RACF, SDSF/IDF, ICCF/Vollie, Panvalet, SAR, Librarian, Xpediter, VSAM, File Aid, FTP, UNIX, SAP R/3, ABAP/4, ORACLE, SQL, Powerbuilder, Visual Basic, Netpass, SAR/RDS/Document Direct, Filenet, IDMFind, CSExplorer, JIRA, ServiceNow, Crystal Report, MS Access, MS Office, MS Project/Powerpoint/Visio, Informix/Foxbase/Dbase

Hardware: IBM z 800/2066/3090/9672, zOS OS/390 MVS/ESA

Software: ADABAS/NATURAL, COMPLETE, COBOL/CICS, PREDICT, Natural SecurityEntire-X, TSO/ISPF, OS/JCL, FileAid, FTP/Filenet/RDS/SAR/Document Direct Oracle, Client Server/SQL/Visual Basic, Unix, MSAccess

Application: COUNTY RECORDING SYSTEMS (ROSI, eROSI, Document Mgmt, RecordingImaging & Archiving, etc)

WORK EXPERIENCE:

Confidential

Senior IT Application Systems Analyst

Responsibilities:

• Performs the entire SDLC from analysis to development to implementation to project management, for both development of new projects as required by both state and federal mandates for Department of Human Services (DHS-CPS systems) and Department of Labor and Internal Relations (DLIR-Tax & Unemployment Insurance), as well as maintenance of existing mainframe systems. Periodically interacts with customers and maintenance support teams in relation to interfaces with existing systems. Responsible for development, testing and implementation of new projects. Also performs as backup data and systems administration.

Confidential

Responsibilities:

• Highly proactive involvement on all encompassing Software Development Life Cycle (SDLC) including, but not limited to project management, planning, analysis, design, development, testing, implementation, documentation and maintenance. Managed several projects. Worked alone with several systems as well as with a team on several other systems. Performed data conversion for over 75M records from mainframe platform to client server SQL platform.

Confidential

Project Manager/Senior Information Technology Analyst

Responsibilities:

• Provides project management, analysis, support, assistance, consultation and advisement on IT solutions in a wide range of technical areas of the department’s integrated and multi-platform systems evolving with technology at an ever-accelerating pace. Reengineered, enhanced, maintained, and support the County’s Recorder and Vital Statistics (Birth, Death and Marriage) systems. Work includes CCR’s mainframe and client server systems’ design, analysis, engineering, maintenance & documentation. Provides custom data entry application support in imaging and document management, web services, workflow, cashiering.
• Represents department in county change control and IT governance committees (Tax Steering, Imaging, Web Content Management, eGovernment, etc.) Acts as a liaison in IT-related matters between MIS & customers. Acts as customer support on daily operational activities including Document Management, Security Administration, etc. Created test plan and performed systems testing for new Data Entry System. Developed RFP’s for several projects.

Confidential

Senior Information Technology Analyst

Responsibilities:

• Developed, maintained, supported and managed the Property Tax Systems that includes several of the county’s most complicated financial systems. Develops IT requirements and interfaces directly with the customers on Dept of Finance (Tax Collector, Auditor, Accounting, Business License, etc) and Assessor. Performs the whole system applications development/maintenance cycle as required by the systems and customers, from project management, systems and data analysis and design, systems development and testing, maintenance, customer, to implementation, troubleshooting and documentation. Work includes orientation, mentoring and of newly hired staff.

Confidential

Systems Test Analyst / Data Analyst

Responsibilities:

• Developed an understanding of each application. Developed system test methodologies, project work plans and deliverables. Analyzed the existing test and production data. Discussed data requirements with customers and Systems Test team. Developed ERD for various system projects. Designed and populated test beds and facilitated use of test data. Responsible for data integrity. Constructed conversion, remediation and bridge programs. Ensured quality assurance. Conducted to project staff consultant in the use of ADABAS, Natural, Predict and Complete.

Confidential

Systems Analyst (Consultant) (Revenue Recovery System)

Responsibilities:

• Solely responsible for systems analysis, design and construction of a data conversion project from existing mainframe system to customer/vendor package. Involved in migration of all necessary data, gather data for the files according to the new conversion layouts, created test plan and data. Analyzed related subsystems and impact of conversion to existing subsystems. Performed cross referencing of tables, validation and downloading/uploading of data between Adabas and conversion files. Analyzed user test and production data and performed unit and system testing. Responsible for application implementation and documentation.

Confidential

Sr. Systems Analyst Programmer

Responsibilities:

• Performed systems analysis tasks and conducted Joint Application Development sessions with the User Analysts. Prepared logical and physical design specifications, file design and layouts, and technical specifications. Constructed programs and link modules with other subsystems. Organized file accesses and entity relationship matrices and application systems documentation. Performed analysis and prepared recommendations for production implementation and interface to other subsystems.

Confidential

Principal Systems Analyst / Data Base Administrator

Responsibilities:

• Started as Senior Systems Analyst and was promoted as Principal Systems Analyst. Was also assigned to be the Data Base and Systems Administrator. Even after becoming a DBA, had to remain as Principal Systems Analyst upon the demand of marketing management as being responsible for development, implementation and maintenance of the biggest and most complicated critical system of the company that interfaces with Shell’s main HQ systems in Netherlands.
• As Principal Systems Analyst, performed the role of Project Manager and Technical Project Leader for several complex and large projects, most notably the Data Interface Processing Systems that processes all the marketing data and for output submission to main headquarters in Shell Netherlands. Performed systems analysis, technical design and program construction. Developed and maintained application system/programs. Conducted system testing, parallel run and implemented systems. Assisted users in all phases of systems development cycle. Organized and prepared technical documentation. Supervised, developed, directed execution and review of analysis, design and programming tasks of analyst/programmers. Responsible for systems that were used as prototype of Shell Companies in other countries in Asia.
• As Data Base/System Administrator, maintain overall mainframe DBMS environment particularly database integrity, security and recoverability; carried out DBMS performance monitoring and tuning activities to maintain the system at optimal efficiency. Responsible for installation and upgrades of database components. Managed production change control. Involved in the Disaster Backup and Recovery plan of mainframe systems and databases. Acted as System and Data Administrator backup for Oracle databases. Conducted Adabas/Natural/Predict s to analyst/programmers.
• Was instrumental in accreditation/reaccreditation for ISO 9001 for both Applications Development and Data Base Administration. Started project management for preliminary conversions and development of mainframe systems to SAP R/3 / ABAP/4 platform.

Confidential

Sr. Systems Analyst Programmer

Responsibilities:

• Involved in systems analysis and design. Discussed systems requirements with customers and prepared systems and program specifications and documentation. Responsibilities include file design and creation, model coding, building and generating program skeleton frames, program development and assisted programmers in program generation. Developed and implemented test plans and test data requirements. Conducted and coordinated systems testing and technical walkthroughs of the systems.

Confidential

Sr. Systems Analyst Programmer

Responsibilities:

• Developed and maintained application systems for both batch and online operations. Job tasks encompassed investigation and analysis of business functions for conversion to computer operations, preparation of user requirements, documentation and system specifications, development of program segments and related testing, verification and debugging, and implementation. Maintained and enhanced several existing subsystems. Was also stationed briefly at Confidential London, and Hongkong to implement and troubleshoot systems.

Confidential

Systems Analyst/Lead Programmer

Responsibilities:

• Involved in the bank’s full scale analysis, development, maintenance and implementation of several systems. Responsibilities include systems and data analysis, program development and testing, documentation and maintenance of both on-line and batch programming. Converted systems from Natural 1 to Natural 2. Involved in bankwide system testing and imentation. Acted as lead programmer analyst. Conducted user s and acted as user support upon maintenance.

Confidential

Senior Programmer

Responsibilities:

• Developed online and batch programs. Activities performed included program analysis, coding, test data preparation, testing, debugging, revisions, maintenance, and documentation of programs. Involved in implementation, user and support. Acted as lead programmer in several systems. Assisted the systems analyst in preparing procedure, user and operation manuals and other system documentation materials.

Confidential

Programmer

Responsibilities:

• Started as programmer trainee and later worked as programmer involved in the development and maintenance of various online and batch programs. Responsibilities include coding, testing and debugging programs.