System Analyst And Development Specialist
Current(05/2007 – Current) System Analyst and Development Specialist with Prudential Responsible for the development and maintenance of Prudential’s group insurance billing system and its interface with the Sungard vendor package Compass. Included are Prudential’s web enrollment and beneficiary services provided to each group client.• Created a process to automate WEB enrollment processing for our in-house clients. Previously they had to contact operations to enter a variety of parameters on an individual customer basis in order to send customer data to the WEB for annual enrollment and updates. Automation now bypasses this step and our clients can now enter those parameters themselves and run WEB enrollment processing directly. This has significantly reduced the chances of error.• Key role in developing a process which allowed our users the ability to transfer client data to a self-editing, excel spreadsheet and feed that spreadsheet through to our group insurance systems. Involved the extensive use of Oracle SQL.