PEOPLETECH GROUP PROFILE

SUMMARY

• Java developer with around 9 years of experience in developing applications across various platforms.
• Experience with UNIX, Linux. Windows, AS/400 platforms.
• Expertise in databases with focus on DB2, Oracle, Sybase, SQL Server and Netezza.
• Experienced with writing stored procedures, triggers and complex SQLs.
• Experienced in analysis, design, development, testing and implementation of application software.
• Comprehensive knowledge of physical and logical data modeling, performance tuning.
• Understanding of financial domain Market Risk and Insurance knowledge commercial personal line of business
• Good communication, quick learner, good interpersonal skills, energetic with positive attitude towards work and excellent team player.

TECHNICAL SKILLS

• Languages:Core Java, JSP, Servlets, JDBC, PL/SQL, TSQL, Perl, shell, RMI, EJB, python, Web Services, SOAP, C, C , C , ASP, ASP,VB, VB.NET, ASP.NET, Java Script, VB Script, UML, HTML, XML XSL and XSLT , UML, CSS, AS400, Synon, COBOL400, CL400
• Database:Sybase, Netezza, Oracle, SQL Server, DB2, ADO.NET
• Operating System:UNIX, Linux, Windows XP, Windows 2000, OS/400, OS X
• Methodology:Software Analysis and Designing
• Application Servers:Tomcat, Jboss, ServletExec
• IDE:Eclipse, NetBeans
• Tools:CVS, SqlDBX, ant, TOAD, Aginity Workbench, isql, nzsql

PROFESSIONAL EXPERIENCE

Confidential

Role:Java Developer

Description:

Presently working as a Java developer with feeds team in Market Risk technology group, which is responsible for calculating and managing Bank of America Merrill Lynch's risk exposure. The feeds group is responsible for data collection, feed monitoring, error detection, error correction, data signoff, data acquisition and control tools to manage risk data, which is used in generation of VaR Value at Risk .

Responsibilities:

• Creating system solutions that allow the Market Risk Group to focus on the potential impact of fluctuations in interest rates, exchange rates, equity and commodity prices, credit spreads, credit derivatives, mortgage risk and other systematic risk.
• Work with risk managers to gather requirements, resolve issues and deliver solutions.
• Solely responsible for a UI based position level data editing and correction tool known internally as positionViewer. The tool was implemented in JSP, Servlets, java beans, and connected to both Sybase and Netezza databases.
• positionViewer is being utilized by market risk managers to view their respective positions, and perform corrective actions such as edits and copy forward of the data. The tool gave the risk managers a consolidated viewer across all positions for all product types.
• Worked on the feeds processing engine, also known as FeedServer, to bring in position level scenarios from front office to Market Risk, and transform the data to be utilized in VaR. FeedServer is implemented in core java, is multithreaded, and uses XML, JDBC, iBatis etc., to parse, process and persist the feeds.
• Implemented simple caches using HashMap in core java to optimize the reference data lookup while processing position level scenarios.
• Responsible for migrating book level VaR back test scenarios which were being persisted in Sybase to position level scenarios in Netezza Cash Balance .
• Implemented stored procedures to calculate Index Single Name Basis for credit risk in Sybase and Netezza.
• Implemented stored procedure to copy forward fill forward mortgage position level data in Sybase. This procedure was executed on holidays using AutoSys, and the data generated was used in VaR.
• Implemented stored procedures in Netezza to copy forward credit position and aggregates when the risk managers kicked-off the copy forward operation via UI. This was done for performance optimization for Netezza.
• Worked in high volume data environment, where in the volume of positions received for a day runs in millions of records.
• Due to high volume data, the queries written in both Sybase and Netezza had to be optimized. Techniques such as proper join conditions, index searches, showplans, etc., were utilized for performance optimizations.
• Worked on migrating feeds related SQLs from Sybase to Netezza.
• Wrote shell perl scripts to perform utility functions such as data migration, invocation of stored procedures, etc.
• Worked on a feeds' system scorecard report, which summarizes the daily activities of risk managers in relation to the received feeds.
• Wrote ad-hoc SQL scripts Sybase and Netzza to add risk metrics such as risk factors, shocks, tenors, currencies, commodities, etc.
• Provided level II support to troubleshoot production issues.

Environments:

Java 1.4/6.0, Sybase 12.5.1/15.7, Netezza 6.0/7.0, JSP, Servlets, iBatis, shell, perl, ant, eclipse, Apache, Tomcat, UNIX/Linux, AutoSys, CVS

Confidential

Role:Java Developer

Description:

Enhance the Commercial Package product, so that a user will be able to select multiple forms of the same name at different levels and add the capability to select these forms all at the same time for the Property and Liability products. Also, provide the capability for the user to save the forms they have entered and be able to return to the same transaction and continue adding forms from where they last saved. The ability to add more than one form at a time, without entering them in a specific sequence, will significantly decrease the process time for creating a Commercial Package policy. The sequential order, in which the forms will display, will be determined programmatically by the Calligo Print Order and the Section number of the product.

Responsibilities

• Developed JSP, Servlets and Java beans to add functionality to Property and Liability products.
• Developed a session management system to manage the user sessions to continue where the user left using JSP and Java
• Utilized DB2 to persist the operations performed by users like adding new forms, selecting policies for the commercial package etc.
• Developed stored procedures in DB2 to augment functionalities to the front end.
• Developed reporting tools to report on user transactions using shell scripting and DB2.
• Fixed the performance of SQL queries used in Java or reporting scripts.
• Collected business requirements to generate specifications and solutions for various modules.

Environments:

Java 1.4, DB2 UDB, JSP, Servlets, Ant, Eclipse, Tomcat, shell

Confidential

Role:Java Developer

Description

PCG requires enhancements to create the Homeowners, Private Collections and Excess Liability products for Canada. This project involved developing rating programs, documentation and testing as per the rules and regulations of Canada. Work on code for rating programs.

Responsibilities:

• Developed insurance rating programs for CHO Canadian Homeowners , CPI Canadian Personal Inland Marine and CPE Canadian Excess Liability using Java.
• Wrote stored procedures in SQL server to augment ratings program written in java.
• Used Java API calls to invoke various other ratings modules to generate risk ratings for various risk profiles.
• Generated various reports for policies and their ratings using perl and SQL.
• Developed various screens using JSP and Servlets to invoke the rating modules to generate customer specific insurance policies.
• Collected business requirements and converted them into complex rating modules written in Java.
• Performed unit and system testing of the various programs involved in creating the insurance policies.
• Coordinated with offshore teams for day to day activities.

Environments:

Java 1.4, SQL Server, Ant, Eclipse, perl, JSP, Servlets, Tomcat.

Confidential

Role:Java/COBOL Developer

Description:

• Maintenance of the various Hereford programs for reporting Workers Compensation statistics to the NY Board and supporting the deployment of the BEEP, PEEP, FISERV and FREEDOM reports. Also developed new reports for merged premium and reporting of Premiums Written, Inforce, and Earned/Unearned by Line and Freedom Upload and update of Check numbers. Development of new Balance reports for merged premium and reporting of Premiums Written, In-force, and Earned/Unearned by Line.
• Created new programs for First Reporting, Subsequent Reporting and Correction Reporting for BEEP and screen design for Correction reporting.
• Produce a report of direct business only for 'Cost Containment' for the Illinois state bureau for particular products, for each Line and Class to determine the earned premium, paid and outstanding losses, paid and outstanding ALAE Allocated Loss Adjustment Expenses and number of paid and outstanding claims.

Responsibilities:

• Responsible for generating reports from SQL Server database using Java, shell and perl scripts.
• Responsible for automation of BEEP report submissions using shell, perl and Sybase.
• Responsible for processing data pertaining to worker's compensation using Java and SQL Server.
• Automated BEEP submission reports using Autosys.

Environments:

Java 1.4, SQL Server, Ant, Eclipse, shell, perl, Sybase, Autosys, COBOL, AS/400

Confidential

Role:Java/COBOL Developer

Description:

• The project involved maintenance work/issues for WINS for The RLI. The tasks included analysis, coding and testing of the issues. The issues were related to Policy, Claims, Accounting, Reinsurance and reports.
• The project involved maintenance of Producer and Sub-Producer file maintenance programs. This module included toggle screen displays for producer subproducer, lookup search for producer subproducer, status view on the basis of status its type , selection of producer subproducer, and print producer sub-producer details.

Responsibilities:

• Maintain existing code in COBOL and WINS.
• Write code in Java and COBOL to develop software for new policies, claims system etc.
• Maintained screens using WINS for file maintenance programs