Resume

11/10-Now AllFusion Gen 7.6 Senior Consultant, Kaiser Permanente

¨ Enhanced Foundation System Cool:Gen batch programs in Self-funded, Birth Day billing, Medicare, Membership, finance, CSI, NGT, MBE, CCES, Contract projects to fix problems/inhancements reported in ISDD(Incident Solution Design Document).

¨ Used SAS program to read CSV, Comma delimited Excel File and convert it to standard MF Fixed field format file.

¨ Modified, coded, Unit tested & peer tested of several batch, online GUI and 3270MF programs

¨ Used GuardIEn 7.6, SPUFI, DB2, File manager for DB2, SDFII, Java, StarTeam, SQL Query Analyzer, ChangeMan 5.6.1, MQ, CICS and IBM Main Frame

¨ Got revalidation of my reputation as ZERO Defects, Errors & Bugs Developer, and Analyst.

02/09-10/10 AllFusion Gen 7.6 Senior Consultant, PacifiCorp

¨ Enhanced Customer Service System (CSS), AllFusion Gen batch and on line programs for Net Metering project.

¨ Developed JUNM new CSS on line screen to display Cr Balance for Annualized billing period.

¨ Modified, coded, Unit tested & peer tested of several batch, online 3270MF programs

¨ Used SPUFI, DB2, Platinum, CICS and IBM Main Frame

04/08-Jan 09 AllFusion Gen 7.6 Senior Consultant, Kaiser Permanente

¨ Enhanced Foundation System Cool:Gen batch programs in Self-funded, Birth Day billing, Medicare, Membership, finance, CSI projects to fix problems reported in ISDD(Incident Solution Design Document).

¨ Modified, coded, Unit tested & peer tested of several batch, online GUI and 3270MF programs

¨ Coded and tested CICS, COBOL program from scratch for OCI project.

¨ Enhanced Contract printing, SQL server, VC++ programs for FS core project

¨ Used GuardIEn 7.6, SPUFI, DB2, File-AID, SDFII, Java, StarTeam, SQL Server Enterprise Manager, SQL Query Analyzer, ChangeMan 5.6.1, Xpediter 8.2, CICS and IBM Main Frame

¨ Got reputation as ZERO Defects, Errors & Bugs Developer, Analyst.

¨ Maintained and Enhanced CSES-Child Support Enforcement System.

¨ Maintained, several online and batch programs to fix production problems. Fixed more than twice the production problems than any other person on the team.

¨ Used File Aid, Central Encyclopedia Access. DB2, CICS, SPUFI, Platinum, and IBM Main Frame

10/03-08/05 Cool:Gen 6.0 Senior Consultant, Anheuser-Busch

Developed EOW Sales To consumer Data and EOW Casual Fact Data (Weather) Sub systems.

Designed, constructed and implemented several batch programs to load data from Chain stores to Oracle Database, which feeds Data Warehousing project.

Coordinated work with offshore (India) developers.

Used AIX 4.3, TOAD 7.5, Reflection 8, IBM Main Frame,

Developed several UNIX scripts to automate frequent functions.

5/03-9/03 Cool:Gen 6.0 Senior Consultant, Union Pacific Rail Road

Maintained and enhanced TCS-NG-Train Control System Next Generation system with concurrent High Use Oracle Data base.

Designed, constructed and implemented four batch programs to fix errors in data loading.

Analyzed several production problems and system bugs to improve system functionality.

Used Microsoft Access & Excel, Cygwin, WS-FTP Pro, Telnet, Lotus Notes, Tuxedo, UNIX.

Developed several UNIX scripts to automate frequent functions.

11/99 04/03, CASE Cool:Gen 5.1a Block Mode/GUI Consultant, Kaiser Permanente
Work involved in maintaining and enhancing ARK-Automated Rating for Kaiser system. Worked in designing RACF Security system for Read Only users, ARK to HERA batch interface design using batch QMF. Designed & constructed Multiple Copy Quote window module with backup and restore feature. Designed and Constructed KPSA and Group Blend Reports, in record minimum time, which are initiated from On line GUI Window and the report is displayed in another GUI window. Analyzed several production problems and system bugs to improve system functionality.
Used DB2 File Aid, JCL. Attended Java for Visual Age, Written Communication, Success Through Communication and Team Facilitation training.

7/99 10/99, CASE Cool:Gen 4.1a Block Mode/GUI Consultant, Intel
Work involved in maintaining and enhancing CORE & Product Code systems. Worked in all phases of Cool Gen from design to implementation, including Technical design.
Used DB2 File Aid, JCL

3/98 6/99, CASE Cool:Gen 4.1a Year2000 Consultant, Department of Natural Resources
Work involved in re-engineering Personnel Leave System and making it Year 2000 compliant. Redesigned the PLS system making it more efficient by removing several old system bugs and making it less manual intensive by automating and integrating several old functions. Mentored DNR staff in use of COOL:Gen in developing state of the art systems. Used Focus for producing reports, DB2 Personal Database on PC, Lotus Approach for DB2 test data generation. Designed the system in block mode environment with view to migrate to GUI in near future. Used Windows NT.

4/97 2/98, CASE Cool:Gen/Composer 3 GUI Consultant, Blue Cross Blue Shield
Work involved in developing Client Server GUI pilot project for Financial Classification System. Used QAD Templates. Developed 12 different window programs using Windows NT/95 & OS2 as client with IBM Mainframe as server in DB2 environment. Also enhanced/maintained functionality of Financial Classification system in block mode environment using IMS and DB2 platform.

9/96 3/97, CASE Composer 3 Encyclopedia, Administration Consultant, Tropicana
Work involved in administrating 3 development projects with total staff of 40 developers in a client server encyclopedia environment. Daily tasks included batch downloads, encyclopedia management, client work station support, model migrations, Composer problems and model corruption cleanup coordination with Texas Instrument. Also worked in Data Warehouse Group to develop data warehouse applications prototype using COMSHARE tool. Client work stations use Windows 3.1, Windows 95 and NT4 and server is HP UNIX, Oracle. Fine tuned AEFC, AEFUF, AEFAD for optimum on-line transaction performance. Developed UNIX script & C++, programs.

3/96 8/96, CASE IEF 5.3 Block Mode Consultant, Kaiser Permanente, Target
Work involved in developing and implementing Human Resource Seniority System for Kaiser Permanente. Designed on-line as well as batch IEF programs. Designed automatic on-line initiation of background report generating programs to print reports at user nominated printer. Used CICS, XPEDITER, Change Manager
Work involved in developing and implementing Global Merchandising System (Vendor) for three operating companies i.e. Target, Mervyn, Dayton. Detailed specifications were developed for offshore development.

4/95 2/96, CASE IEF 5.3 Composer GUI Client/Server Consultant, CSWS, MERCK, CHASE
Work involved in developing and implementing Load Analysis System for Central and South West Services. The system has 50 entities, 50 GUI procedures and 10 batch programs. Client uses windows, and server is IBM Mainframe.
Work involved in developing and maintaining MMD Enterprise Data Model with over 800 entities and developing translation system from user requirements, IEF code writing, Parsing to TRANID, and implementing into ODL using ORACLE database and Case Exchange to final implementation in France and other Merck sites.
Work involved in Upper CASE design for GSS/GAA project using IEF 5.3. Developed complete data model with 50+ entities.

11/94 4/95, CASE IEF Block Mode Consultant, SPRINGS
Work involved in lower CASE design for Order Billers project using IEF 5.2. Developed 16 On line PRADs out of 100 PRADs in an on line table maintenance system with team of six. Performed complete mainframe packaging and generation. Used High Performance Option and QMF on IBM ES9000 MF for generating reports.

4/94 10/94, CASE IEF Client/Server Consultant, NASD
Work involved in Upper CASE design for FOCUS (Financial and Operational Combined Uniform Single) project using IEF 5.2 and BAA stage of BSI. Developed complete data model with 100+ entities alone and assisted in process model, Interaction analysis using Event Model, Entity Life Cycle analysis, Process Logic Analysis, and Business Requirements.
Completed pilot system using Client Server design and GUI on PC, OS/2, DBM; Windows / Sequent, Tuxedo, UNIX, Oracle. Performed all the tasks from planning, analysis, design, database transformation, window application design with client and server procedures, database generation, cooperative packaging, code generation, linking, installation and demonstration.

12/92 4/94, CASE IEF/ADW consultant SPRINT, SWBT
Worked on scoping VDI (Voice & Data Integration System) using TOA (Task on Arrow) process modeling using ADW CASE tool for Sprint.
Work involved in developing UPS 2 (Usage processing System 2) On line table management System using IEF 5.1 CASE tool. Also enhanced functionality of standard template PRADs used in UPS 2 system. Guidance to SWBT staff on use of IEF case tool.

11/91 11/92, CASE IEF/ADW Consultant, TWA, GE
Work involved in maintaining and enhancing FFB (Frequent Flight Bonus), Ambassadors Club, Business Flyer Club & Business Marketing Systems.
Worked on IMS, DB2, QMF, SQL, TSO/MVS, VM/CMS IBM mainframe. Used IEF model migration, FOCUS & SAS.
Work involved in developing ERM and CDM for GEAS (General Electric Aviation Services) Common system (Suite of 12 different systems, e.g. OSB, BIM, VTA, etc.). Guided team members in use of ADW for data modeling and analysis tasks.

12/89 10/91, CASE IEF Consultant, Roads & Traffic Authority, Australia
Work involved using IEF for DRIVES 90 (Driver licensing & vehicle registration system) project with 30 other analysts.
Total experience in CASE tool IEF using all the facilities such as ISP, BAA, BSD, TD, construction, testing and implementation of the project.
Designed on line & batch procedures. Used all facilities of the tool such as Screen Design, Prototyping, Procedure Action Diagramming, Dialogue flow, Common Action Blocks, Process action diagrams, mainframe subsetting, generation of various model reports on Central Encyclopedia.
Special task of interface analysis with the rest of the world. Interface with organizations such as police, court, REVS, VINS, 13 insurance companies for TPI/CTP etc. Police on line interface using MITECH interface hardware connected the RTA's Fujitsu mainframe to police's IBM mainframe.
Conversion from IBM's 15 year old VSAM data structure to IEF's normalized oracle database with over 300 entities. This required extensive data purification and data translation activities with intricate analysis.
Work involved in conducting an IEF training course for in house Telecom staff in all aspects of IEF tool set usage with hands on experience on IBM mainframe construction. Students constructed 4 complete classroom case studies using all facets of IEF from ISP to construction on IBM main frame with demonstrable class room case study solutions.
Worked on UNIX, Oracle, Fujitsu.

10/88 12/89, Consultant Application Engineer, Westpac Bank, Australia
Worked as project manager on executive information system for Westpac Financial Services Group from user requirements to implementation in a phased development approach. Worked in Investment Accounting & Management system to write market quality business requirements specifications with six other analysts.
Experienced in Westpac's IBM MVS/TSO DB2/SQL environment with variety of PC's. Used Software Engineering Life Cycle & Westpac Project Management Approach methodologies. Extensive use of IEW for data modeling.

3/84 9/88, Senior Systems Analyst, Philips, Australia
Worked on Rentlo, Homecraft Accounts Payable & Service system for multiple divisions. Used data modeling and IEW.
4GL ADABAS / NATURAL EXPERIENCE Conceived & developed utilities e.g. program generator, list programs, list files. Member of ADABAS speed up & performance improvement task force. Using APAS (ADABAS Performance Analysis System) data collections and INSIGHT reports improved prime time response from 50 to 2 seconds.

5/83 3/84, Consultant, Mcgirr & associates Pty LTD, Australia
Worked with Advance bank to design & implement a new on line real time application for Property Trust. Work involved in design of a database, on line terminal screen design, specifications of on line as well as batch programs, implementation on phased basis of various on line transactions, coding, testing & user liaison.

2/81 5/83, System Specialist, Unisys Australia
Work involved Pre & Post sale support small, medium & mainly large system users Customer problem solving, consultancy, conversion guidance Hot line telephone support service, Site reviews, Bench Marks

6/74 1/81, Assistant Consultant, Tata Consultancy Services, India
1978 81 Project leader for inter branch reconciliation system for three leading nationalized banks in India.
1976 77 Project leader for system conversion assignment at Casco Bank & Trust Company, Portland, Maine, USA.
1974 76 Project coordinator for the development of IBM1401 autocoder to Burroughs B6748 translator. Imparted training to internal TCS staff & TCS clients in India & overseas (USA & Holland) in COBOL, WFL, CANDE, system analysis & design.

HARDWARE
IBM 30XX, 43XX, Fujitsu M780/10, HP, Burroughs 7000, ICL 19XX, PC
SOFTWARE
Cool:Gen 4.1a, IEF 5.3, Composer 3, Windows 3.1, Windows 95, NT4, Script, Platinum, PROFS, SPUFI, DB2/Oracle, QMF, OS/MVS, MS DOS, WORDS, LOTUS, COBOL, NATURAL, CICS/DL1, ALGOL, FORTRAN, AUTOCODER, WFL, CANDE, GEMCOS, TCL, BASIC, TPS, NDL, PLAN, SNOBOL, LISP, SLIP, SDL, JCL, MANTIS, SQL, VSAM KDR17.DOC