Provided support and troubleshooting for financial-report application of Putnam investment company located in Boston.
Created SLA (Service Level Agreement) Tracking Tool, which keeps time track of autosys jobs which are running to maintain the life cycle of Vision database. The application consists of 3 parts:
1) Backend Daemon Java Process - for updating Oracle database with the information about autosys jobs. The daemon consists of 2 parts managed by separate Autosys jobs: first process runs soon after midnight, and the second process starts after the first one succeeded and runs every 10 minutes.
2) SLA Web – for output of updated by the daemon database in the browser (based on Struts framework)
3) Charting Service (J-Chart Java component). The server provides charting services to clients through web services. Jakarta Axis framework and its implementation for SAAJ (SOAP with Attachment API for Java) are the building blocks for the web services implementation. A client’s request is a HTTP/SOAP request, which contains both charting data and chart/graph specifications; the corresponding HTTP/SOAP response contains chart images, which are implemented as SOAP attachments. A client generated an XML file containing charting data and specification according to Sitraka’s DTD.
- Made database design, created stored procedures.
- To update & call Stored procedures / functions from Java beans used callable statement
- Created graphical reports, used J-Chart Java component, created Java client to generate an XML file containing charting data and specification according to Sitraka’s DTD
- Developed java beans, servlets, JSPs, java scripts.
- Configured project in Eclipse environment: class path, project properties and references, ant build scripts, debugging environment.
- Developed Action and ActionForm classes, struts-config and web XML configuration files, used Struts tag library, developed dynamic Action forms.
- To develop persistency and mapping in beans to metadata used Hibernate framework.
- Using JNDI, LDAP, NTLM created user authentication for Sun One Directory LDAP server.
- Created C shell wrapper script, which started Java Daemon Backend process.
- Developed basic graphic images like icons, used Adobe Photoshop.
- To deploy web application used Ant, created build.xml configuration file.
- Using SQL*Loader, Korn Shell, C Shell & Autosys jobs automated Oracle updates.
- To test application created test cases, used JUnit framework.
- Provided support of autosys jobs for Vision database.
Environment: JBoss, Tomcat 5.0.28, WebLogic 8.1, Eclipse 3.0, MyEclipse, Ant, TOAD, CVS, J2SE 1.4, JSP, Servlets, Java Beans, Struts 1.2, Java Script, HTML, PL/SQL, JAXP, SOAP, XML, C-shell, Korn Shell, SQL Loader, J-Chart, Perl, AWK, Adobe Photoshop, Oracle 8i, Unix Sun Solaris, Windows NT.