Java mentor for the ADP and IDP software engineers

ACATS PROJECT

Modified the Customer Account Transfer screen to include additional parameters to add user and business functionalities

• The capability of the end users was previously restricted to only retrieve customer account transfer

information for the last 30 days

• Modified the application functionalities on backend (JAVA) code to provide a more flexible

selection on various date parameters

• Established JDBC Connectivity to pull data from SQLMX/MP (Mainframe servers) and pass it as a

JSON response based on the request received

• Developed several REST web services supporting both XML and JSON to pull Financial Advisor

Information

MASS ACCOUNT TRANSFER PROJECT (MAT)

Successfully executed the MAT Account Opening process to open 3000 accounts at Raymond James using data sent from a contra firm

• Created stored procedures and views for numerous ETL processes to consume data received from

the contra firm, converted into RJ Proprietary format and sent to multiple downstream applications

• Learnt Centerprise Data Integrator Tool to perform mappings between two different environments

• Performed data cleansing techniques such as scrubbing and created various validation reports to

ensure the quality of the data

• Awarded by the management for identifying bottlenecks and redesigning the process flow to reduce the technology costs, as a part of a special operational review and cost bench-marking project.

• Leveraged Agile and Scrum Methodologies to deliver complex, structured solutions.

• Awarded with “EXTRAMILE Award” and “Best of Class Award” by Bank of New York Mellon as a token of recognition for being the top performer in the firm.

• Actively involved across the SDLC lifecycle – creating design documents, technical specs, coding, preparing unit test cases, performing unit/regression testing and finally helping the modules into production.

• Tuned complex SQL queries to improve performance and CPU cycles and thus reducing the cost involved by $45,000 per year, as part of IT Transformation project.