Angelo Fernandes

National Boi-Medical Conmputer System ARC group
Consultant for Cornell Technical Services
Sterling, VA 20164
Tel: (703)848-6648 Fax:(703)848-5727
Email: fenandesa@usa.redcross.org

EDUCATION EXPERIENCE

  • M.C.A.(Masters' in Computer Application), Taleigao, Goa University, GOA, INDIA, 1993

Advisor: Professor Yma Pinto/Ramdas

(Thesis: Development of Payroll/Accounting System for Mormugao Dock Labour Board, Goa, India.).

  • BSc.(Physics-Mathematics), Goa University, Goa, India, 1989.

PROFESSIONAL EXPERIENCE

  • Analyst/Programmer, IBM Global Services, Herndon VA, 1999 (Feb)-1999 (July).
  • Analyst/Programmer, AT&T Herndon VA, 1997 (September)-1999 (Jan).
  • Software Engineer, National Plastics and Building Material Industries, Sharjah, U.A.Ei, 1995 (Jan)-1997 (April).
  • Software Developer, Mormugao Port Trust, Goa, India, 1993 (Feb) - 1995 (May) (Jun).

SKILLS

  • Platforms: Intel Servers/Workstations/PCs, Sun SparcStation, HP-PA RISC, Data General Unix Servers.
  • Languages: C, C++, SQL, SHELL, HTML, CGI, PERL, JAVA, Javascript
  • Operating Systems: Windows-NT, Solaris/Sun OS, DG/UX, HP/UX, IBM/AIX, Windows98
  • RDBMS: Informix, Oracle ver7.3-8i, Unify
  • Tools: Pro*C, OCI, PL/SQL, RMI, Servlets

SUMMARY

  • Extensive experience in developing applications involving Oracle and Informix RDBMS
  • Experience in Oracle Developmental tools: PRO*C, PL/SQL, Forms and Report Writer.
  • Experience in developing applications using Informix-SQL,ACE, Formbuilder-4GL
  • Expertise in C, C++, Shell and SQL programming
  • Working Knowledge of PERL, CGI, Tuxedo.
  • Knowledge of IIS, Apache, Java, RMI, JDBC and Servlets
  • Basic knowledge of Unix, Windows-NT, Informix and Oracle Administration

WORK EXPERIENCE

  • February '99 - July' 1999: Programmer Analyst, IBM Global Services. Developing and maintaining applications in UNIX/C/INFORMIX RDBMS. System : OBS-OON (Outbound Switched/Outbound Order Negotiation) OBS-OON is a UNIX and Mainframe (MVS) based application. OBS-OON (Unix) sends transaction type messages to the Mainframe(MVS) where the information from the request is formatted into an ORDER for processing by TOPAS(MVS system) and other downstream Legacy systems.
    • Release: 99.04 Project : Developed Real-Time Interface to IDTO(Integrated Desktop Ordering) This project puts the billers SBS and LION in sync so that the local service can be successfully billed. Local service is maintained as a seperate "leg" of data under the LD account structure established and maintained by IDTO/Local-TSO/SRP-CADM flow. The LD Account structure is maintained by OBS-OON -TOPAS/Subaru-CADM flow. Since these are two different legs, when the LD-portion of the account strucuture was modified, follow-up to maintain the local portion of the account does not occur. This project was successfully implemented and is in a production environment on 04/24. Role : Design/Development, Integration Testing and Sub System Testing support. Release 99.07 Project : Expand SMT to include Local This project does the validation checks for the Account migrations which take place in OBS-OON system. The Accounts having Local line service provider other than TCG are not allowed to migrate to ALL-IN-ONE service. Nt : All In One is one of the new services offered by AT&T to its customers. This project was successfully implemented and is in the phase of Sub-System Test. Role : Design/Development, Integration Testing and Sub System Testing support.
  • June '97 - January '99: Programmer Analyst, AT&T Virginia. Developing and maintaining applications in UNIX/C/C++/ORACLE RDBMS. System : IDTO (Integrated Desktop Ordering) IDTO is a Tier III architecture system with Front end developed using C++. Backend/Middle is under C/Tuxedo/Oracle RDBMS. The user has a single place to view and establish account data and customer linkages. It has a GUI front end that integrates the data collection and distribution for viewing and establishing customer accounts. IDTO also includes a navigator GUI front end that will provide an intelligent cut-through to pass high level account data to the legacy ordering systems. Redundant keying of data is alleviated. It includes Bundler functionality that allows the user to mark any two or more accounts as bundled for single bill, or associated together to create customer structure.
Release 98.04
Project: Edits on critical credit fields
This project affected the  Readyline,Masterline and UniPlan Lead services  offered in
IDTO. It involved the modifications  to two credit related windows  and addition of
new rules and edits to the entry of credit related information.

Role : Back-end modifications   to the Rules engine to add new rules for the validation
of the credit realted data.

Release 98.07
Project: STO Phase IV
STO is a web-based system which utilizes IDTO system to transfer  the data to OBS-OON.
IDTO  does the filteration  of data via  the EDIT server and also the  handling of staus
of the order depending on which it may be required to resend to  STO.
As part of the on-going enhancement to STO sytem, this particular release  handled/enhanced
the following activities for Outbound Services.
- Add Location
- Disconnect Location
- Change customer information(Name,Address,Customer contact)
- Change billing address
- Add a Line
- Change a Line option
- Remove a Line
Role : Handled the validations of the data passed to IDTO from STO front end so as
 to pass the filtered data to  OBS via DEC MesgQ.
  • January '96 - June '97: Programmer Analyst, Major Manufacturing Company, Sharjah, U.A.E Developed many systems using Informix and Oracle RDBMS. Billing System Ported a billing system from Unify to Oracle. The Unify system used the Unify Forms Manager and used the C-API for database access. The Oracle system was implemented using Oracle Forms 3.0. Converted all Unify C programs to Oracle PRO*C programs. Implementation was done using Oracle 7.0 on a Data General machine running DG/UX.
Accounts Receivables Package
Developed an Accounts Receivables Package using Informix RDBMS Version 7.0. This was integrated with the other Accounting Modules, which existed before. Developed several sub-modules such as invoicing
, receipts (both cash and checks), receivables reports and cash flow analysis reports. Informix 
tools used were Informix-SQL, Informix-ACE, Informix-ESQL/C and Informix-4GL.
Also did performance evaluation and optimization on the Informix-ESQL/C and 4GL programs using Quantify.
  • July '93 - December '95: Programmer Analyst, Mormugao Port Trust, India Was involved in developing the following applications:
Payroll system
Designed and developed a payroll system for Dock workers. This involved the generation of
subsequent accounting details such as Trial Balances and Ledger reports. Also data was
kept in a 'Data Wharehouse' so as to handle the arrears of the Goverment employees and
the varied change in the rate of payment  to the workers.

Supplier Rating System
For the Purchasing Department, developed a Supplier Rating system. This system was used by purchasing agents f
or rating a supplier over a period of time. Every issue with the supplier was entered in the system and a profile
would be generated to rate the supplier. The information that was entered consisted of both direct and 
indirect performance. Categories included the level of responsiveness, the professionalism of the supplier's staff,
the quality of the material delivered, the promptness of delivery, etc.
Extensive reporting modules were written so that the supplier could be profiled both on a stand-alone basis and 
on a comparative scale in his category. The entire system was developed on a Sun System running SunOS 4.1.3.
The RDBMS used was Oracle 7.0. Oracle Forms 3.0 were used as data entry screens and Oracle Report Writer and
Oracle PRO*C programs were written for printing supplier profiles.

Quality Assurance System
Was part of the team that designed and developed a Quality Assurance System. This system was used to log probl
ems reported on any component or part purchased by the company. Any part or component purchased which was found
defective would be analyzed and information on it would be entered into this system. The system kept track of the
origin of the problem, the usage of the component, the failed component, duration of use, etc. This would
be used to track the supplier performance. The entire system was developed using Oracle RDBMS Version 7.0 on
a Sun platform running SunOS 4.1.3. Used Oracle Forms 3.0, PL/SQL, PRO*C and Oracle Report Writer.

Back to Angelo's Homepage