SUMMARY:

• 13 + years of Software Development & Production support Experiences
• Technical expertise in Java & Database Technologies
• Strong domain knowledge of Financial / Capital / Energy Markets
• Hands on to 3 Trading Platforms(Endur Open Link, Solar Right Angel & Cxl Triplepoint)

WORK EXPERIENCE:

Senior Endur Open link / Java Developer

Confidential

Responsibilities:

• Endur (AVS / JVS)
• Core Java
• I am working on the Mifid reporting (Regulatory Reporting) for the Commodities Team which manages the Confidential Banks compliance requirement.
• I had implemented the Java Messaging service code to sync the trade data between 2 different systems. These are the Trade messages (xml data) placed in the queues to be picked up by another system and the updated messages were placed back in another queue to be picked by us for sync purpose.
• I had developed and enhanced the various reports and functionalities in AVS scripting including the Mifid regulatory report, Storage fee & Trade summary report.
• I had converted AVS scripts to JVS scripts, which is the same functionality but re - written in JVS.

Senior Database / ETL / Hadoop Develope

Confidential

Responsibilities:

• IWay / Datastage (ETL / B.I Tool)
• Oracle Pl/Sql
• Hadoop-Hive
• Core Java
• Working for the Brokerage Surveillance Team which manages the Scotia Banks compliance requirement to restrict the access on individual Portfolios based on certain criteria. It also manages the Security ratings for most of the listed securities for Scotia’s internal purpose.
• I had enhanced the CSM & KYC processes to in corporate the new requirements / new source Data coming from Upstream system and is intended to be flown down to Portfolio Aid application.
• Processes are being enhanced using iWay (ETL Tool) and the Java Application to accommodate the new fields.
• All the ETL Processes (jobs) are getting moved from iWay to Datastage. Hive is being implemented to read and write the Data from Hadoop clusters.
• Also did Production Support for the Applications already developed & went live in Production by the Predecessor team members.

Senior Java Developer

Confidential

Responsibilities:

• Core Java, Spring, Hibernate, Jms
• Oracle Pl/Sql
• Talend (ETL / B.I Tool)
• Working for Monet Team which manages the Margin Calls & Collaterals Management System of Citi Banks OTC Derivative Desk. By Trade life cycle Terminology it becomes part of Middle Office stage. This System also collaborates with other Upstream / Downstream systems for various Straight through Process implementation.
• I had developed new processes / code like Euro Clear Allocation processing, failed payment message re-processing & Agreement Contacts migration.
• New code is being developed in Core Java, Spring, Hibernate & Talend (ETL) Technologies. Make use of Executor Framework for Agreement Contacts migration piece. The development of new code requires thorough understanding of the existing Frameworks and the Service layer’s API’s.
• Also did Production Support for the Applications already developed & went live in Production by the Predecessor team members.

Senior Java / Database Developer

Confidential

Responsibilities:

• Core Java, Spring
• Oracle Pl/Sql
• Sybase
• Worked for GR Team which manages the in house developed Trading System known as GR. This system integrates with Bloomberg Trading System & Market Data and All the Trades flows down to GR on instant basis and then End of Day reports/feeds are being sent from GR to downstream systems. This System integrates with other internal systems using the Java Messaging Service (JMS).
• I had picked a half cooked (coded) application (named as Reef) from my Predecessor. Reef integrates with the main stream GR System as well. This application is to provide the Security thresh hold alerts based on current Market prices. The user / traders sets the thresh holds for different kinds of securities and the application provides the Red/Amber/Green alerts. The Application being heavily Multithreaded and makes good use of java’s Concurrency Framework (Executor Framework).
• I contributed towards lots of Enhancements to the existing processes / code base of GR. All enhancements were in Core Java & Spring Technologies.
• I had also done Sql Performance Tuning of many queries for this Project.
• I was also part of doing an intensive POC (Proof of concept) in Hadoop / Big Data to showcase how the Historical Trade Data along with Market Data can be used to come up with Trade recommendations.
• Also did Production Support for the Applications already developed & went live in Production by the Predecessor team members.

Business Analyst / Endur Open Link & Java Developer

Confidential

Responsibilities:

• Endur (AVS / JVS)
• Core Java
• I did the in-depth Analysis for the Data Model’s between Endur and Solarc (Right Angel), as Confidential was looking forward to merge the two different Trading Systems into 1 single System.
• I did the development work of converting the existing functionality from AVS scripts / code to the JVS scripts / code.

Senior Oracle Pl/Sql Developer

Confidential

Responsibilities:

• Oracle Pl/Sql
• I implemented the major enhancements / change requests in the existing Data Management application of Wellington known as “Company Security Master”.

Endur Open Link / Java Developer

Confidential

Responsibilities:

• Endur (AVS / JVS)
• Core Java
• I had developed the 3 Shipnet reports (Bunker, Tanker & Time Charter Reports) in Endur. These reports are regarding the Invoicing details for different counterparties with whom BG shares the Transportation facility for the transportation of different commodities.

System Analyst / Database Developer

Confidential

Responsibilities:

• Oracle Pl/Sql
• Data Stage (ETL Tool)
• Business Objects
• This Project was in the initial Analysis phase to work out how to send the Emails containing the Net Asset Values of different funds to different groups of clients. The main consideration was to perform the Proof of concept with Data Stage and Business Objects for overall System Integration. I had developed all the required Proof of concepts to demonstrate the Confidential ’s ability to the clients.

Business Analyst / Database / ETL Developer

Confidential

Responsibilities:

• MS SQL Server 2008
• SSIS (ETL Tool)
• I had developed an Automation Testing system (Hand full of SSIS Jobs) in which the user can insert different Test cases and it will run them in a pre-defined sequence & generate the test Reports.

ETL / Database Developer

Confidential

Responsibilities:

• MS SQL Server 2008
• SSIS (ETL Tool)
• I had migrated their existing DTS Packages to the SSIS Packages. Migration was carried out with the help of the Tool named DTS xchange. Also tested the functionality of the newly converted packages in comparison to the existing DTS packages.

Java / Database / Etrm Developer

Confidential

Responsibilities:

• Oracle Pl/Sql
• Unix Shell Scripts
• Core Java, Spring, Hibernate
• CXL Triple Point - Etrm / Trading Application
• Talend (ETL Tool)
• I along with 2 other team members implemented the CXL Triple Point (ETRM, Electronic Trading & Risk Management System). This involves moving the existing Data (All kind of Data including Agreements, Counter party details, etc) to CXL, Integrating the Market Data sources Morning Star to Cxl and also integrating the Bloomberg Trade flows to it.
• Post release I fixed the Bugs in the End of Day Run Processes. I also developed Add-on Reports for Back Office team which were not part of the Standard CXL Product.
• Another phase of the same Project required me to create the Regulatory Reporting processes for different Regulators like DTCC & CFTC. This process was developed in Core Java & Spring Framework. The movement of Data between the different systems for these reports was build with Talend ETL Jobs.
• Another phase of the same project required me to Integrate the CXL System with the (In-House developed) Algorithmic Trading system which facilitates Capturing the Trades initiated by the Algorithmic logics (Decided by the Quant’s team).

Senior Java / Database Developer

Confidential

Responsibilities:

• Oracle Pl/Sql
• Core Java
• Perl Scripts
• I was part of the Production Support team, Supporting Fixed Income Analytics Team of Wellington (U.S)), I had primarily worked as a Senior PL/SQL Developer for fixing Production Issues and Enhancing the FIQS Application from Database side.
• I had also contributed with adding new piece of code for generating New Reports and Automating manual process for generating Existing reports with Perl Scripts.
• I had also worked as Sql Performance Tuning Specialist and had fine tuned many existing queries of this Project.

Business Analyst / Database Developer

Confidential

Responsibilities:

• Oracle Pl/Sql
• Xml
• I was part of TCT Project, which basically is about creating a System to help the Business Analyst in analyzing the Risk, calculating the MTM & P&L for Physical and Derivative Deals.
• I did the Analysis for the Stock Parcels (i.e. Physical Shipment Parcels & their measurements) for their valuation calculation purposes.
• I had also contributed with an ETL program (which includes creating a local ORM database cache as well) written purely in PL/SQL for migrating Stock Parcels to their GOPS Schema. From their onwards the Shipments, Parcels & Measurements Tables will be used for calculating the valuation of the Stock Parcels.

Business Analyst / Database Developer

Confidential

Responsibilities:

• MS SQL Server 2008
• SSIS (ETL Tool)
• This project is about Trading & Risk Management services. This includes different Reporting applications for different business users. I / We fetched Data from legacy system like ICTS & also through Solarc Right Angel (S10 & S11) and finally generate different Business Reports.
• I did the analysis of the Confidential ’s Trading Systems and to come up with a Design that helped the GARM Application to pull the Data from different source systems rather than the existing approach under which the client performs a Schedule Data push for our GARM Application to Import.
• I had developed / coded the process which picks the granular level Data like Deal Details, Portfolio’s / Strategies etc and Generates the top level reports for the top level Management. I developed Stored Procedures, SSIS packages & SQL Server Job scripts to move the refined Data to the desired Publish Schema and from there onwards the same Data was consumed by other Team to Generate the COGNOS Reports.

Senior Java / Database Developer

Confidential

Responsibilities:

• Talend (ETL Tool)
• Oracle Pl/Sql
• Core Java 1.5
• Xml / Xslt
• I did the Migration of xml feeds into the Oracle Database, so that the same Database can be used by the Web Application for displaying the travel related information extracted from the xml source feeds.
• I had developed the migration application in Talend & Core Java. Core Java was used to implement the business logic & validations, Xslt to flattened the source xml’s and Pl/Sql stored Procedures to perform the back filling where ever required.

Database Developer

Confidential

Responsibilities:

• Oracle Pl/Sql
• Xml
• This project was about calculating the Risk for different Energy Contracts traded in different European Markets. I handled the existing RMDS application and had made enhancements to it. I also had resolved the Issue tickets raised by different clients against this application.

Java Developer

Confidential

Responsibilities:

• Core Java
• Web Services
• Struts
• I had developed the Java web services for ordering flows of O2 to be used by external channel partners. I had created 8 web services like create order web service, get order details web service etc, which were supposed to call the O2’s service layer API’s, which deals with ordering process for new broadband orders.
• Also I had worked on implementing and analyzing the use of Daemon Threads.
• I created a separate Batch job for the cleaning of old records for the Member Get Member Project of O2.

Java Developer

Confidential

Responsibilities:

• Core Java
• Portal / Portlets
• I did the Web development in this Project. The aim of this project is to break the existing Application i.e. www. Confidential .co.uk into small clusters for better maintainability purpose. The Project is all around Refactoring the existing code base deployed on web logic 8.1 into new architecture of web logic 9.2(Consumer-Producer).

Sql specialist / Java Developer

Confidential

Responsibilities:

• Core Java
• Oracle Sql
• Struts
• I created new Sql queries & enhanced / fine tuned existing Sql queries as per the requirement of Q.A Team. My Job profile was to assist the Q.A Team in testing the different permutation combinations of Test Analysis which are highly Data Base intensive.
• I had also developed an Internal Project in Core Java, Struts and My Sql to do the effective Vacation management of the team of more than 300 people at that time.

Java Developer

Confidential

Responsibilities:

• Core Java
• Oracle Pl/Sql
• Jsp
• I along with another team mate had developed an application which is for the purpose of providing Parallel Implementation to WCS order processing System to avoid Downtime during rush hours. The application was developed in Jsp with Oracle being the Database.

Senior Database Developer

Confidential

Responsibilities:

• Oracle Pl/Sql
• Oracle Developer
• I had Enhanced & Added vast amount of additional PL/SQL code in all the 3 modules namely Inventory, Accounts & AFD-1.
• Set up databases and applications
• I was involved in data mining.
• Debugged original forms and reports
• Coordinated with employees for technical assistance

Junior Support Associate

Confidential

Responsibilities:

• Oracle 7.3 (PL/SQL)
• Unix
• Pro C
• Set up databases and applications
• Applying the application patches
• Migrated data from proprietary systems to Oracle systems
• Minor code fixes