PROFESSIONAL SUMMARY:

• Overall 10 years of IT experience, 7+ years of expertise in core java with collections, multi - threading and garbage collection.
• 8 years of financial development experience in electronic trading systems to receive market data, order and trade management for commodities and commodities and Settlement between different counter parties. Products including fixed income and Equity and Foreign Exchange, Payment processing.
• 5 years of expertise in hibernate, spring for building financial applications.
• 4 years of expertise in developing applications using EJB, EJB3, JPA.
• 10 years of expertise in SQL, RDBMS (oracle, Sybase, SQL server, DB2).
• 5 years of expertise in JMS for processing asynchronous messages using Message Driven Beans.
• 5 years of expertise in integrating different applications using MQ Series, TIBCO, WebLogic JMS Provider and Jboss MQ Provider and sending messages to the different systems.
• 4 years in developing applications using Web services and SOAP using AXIS and JBOSSWS.
• Strong in designing and architecting the applications using various JAVA, J2EE design patterns and RUP methodologies.
• 2 years of expertise in developing applications using JBoss Cache Coherence and Replication of data between different nodes in Application
• Expertise in using Java design patters creational, Structural, Behavioural patters
• 4 years of expertise in developing applications using XML, XSLT, DOM, SAX, STAX, TRAX, XPath, Xquery.
• 10 years of expertise in writing Stored Procedures Using PL/SQL and TSQL.
• 5 years of expertise in developing applications using Struts, Web Work, JSF, Oracle ADF, GWT.
• 2 years of expertise in developing applications using EAI Technologies Sprig Integration, Tibco BW
• 5 years of expertise in develop and deploy applications using Jboss, WebLogic, WebSphere and Apache Tomcat.
• Proven skills in relationship management with clients and effectively guiding teams during the project development life cycle and delivering the product within time cost and quality parameter.
• Attend internal reviews and provide status of current work in progress as necessary.
• Assist other team members, with assigned tasks or project issues, wherever possible
• Having good understanding of standards and basic concepts related to SSL.

TECHNICAL SKILLS:

Windows-98, Windows NT/2000, UNIX, MCP, Linux, C, Java 1.4,PL/SQL,TSQL, XML,XSLT,HTML, and DHTML, UML, MQSeries, TIBCO Rendezvous, J2EE 1.4 (Servlets, JSP, EJB, JMS, JTA), RMI, EJB2.0/3.0, JMX, JDBC, JFC, OOAD, RUP, 3-DVE, Tomcat 4.0/5.0, Struts1.2/2.0,WebWork,Spring 1.2, Hibernate2.0/3.0, Axis1.3,Ant, Tomcat 4./5.0, Weblogic 6.1/8.1, Websphere,Jboss3.0/4.0, Eclipse 3.1/3.2,TogertherJ5.5/6.0,RAD 6.1,Strutes Studio 4.5, Visual Basic 6.0,Swing, Oracle 9i & 8i, MS SQL Server, JCS, JBOSSCache, Ehcache, Coherance DB2,DMS-II, VSS 6.0, CVS, Subversion, Rational clear case, Git, Maven

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Designed and developed multi-tier, custom web application to place trades, monitoring trades in trade blotter, checking status of trade from OMS in order browse screen.
• Core Java with Concurrent API is used extensively for parallel processing and chunk processing used for validate and submitting trades to OMS service update stastus in the blotter .
• XSLT and Trax API used to convert different formats of XML to our Standard XML format and StAX API used for parsing XML messages
• Spring JDBC used retrieve and update, inserting data in oracle database with use of stored procs.
• JSON request/response from UI is processed using Spring Boot, Spring MVC Restful features with micro services Architecture and Hibernate/JPA framework is used to save/retrieve the data in the backend
• EhCache used to store Reference Data.
• Retrieving data from database, converted in json format and mongo DB to generate Advisory growth report.
• Maven is used for build and deploy the application in Apache Tomcat
• Created Splunk dashboards with latency alerts
• Created AppD dashboard to monitor application CPU and memory utilization.
• Spring Scheduler is used to run batches at different schedules to fetch booking data .
• Spring Integration (Message Bus) is used to interact with various external systems to send and receive MQ messages and Web Service (soap) requests/responses.
• Spring Batch ItemReader, ItemProcessor, ItemWriter used to process files

Tools: Java 1.8, concurrent package, lambda expressions, streams, J2ee, web services, JMS, XML(Dom, Sax, Xpath, Stax, XSLT), Websphere 7.0, Tibco EMS,, Tibco BW, Spring Boot, Spring Integration, Spring Batch, Spring Data JPA, EHCache, Jprofiler, AngularJs,, Eclipse3.4,WebStorm, GIT/Stash(Bitbucket), SDP Jenkins, Confluence, Jira, Crucible, SourceTree, Udeploy, XL Deploy, Maven, Windows, Linux, Oracle, Mongo DB, SQL Server

Confidential

Responsibilities:

• Designed Use case diagrams, Class diagrams and sequence diagrams using UMLet and Magic Draw.
• Participated in designing work flows and implemented algorithms for the system along with the team.
• Implemented the Project structure based on Spring MVC pattern using spring boot.
• Extensively used Spring IOC module, spring Core Container module, spring web module to develop business layer and implemented scheduled batch jobs using Spring Framework.
• Implemented Asynchronous messaging between System Integration components using Spring JMSTemplate.
• Developed exception logging aspects and auto emailing features using Spring AOP.
• Designed the application using Micro-services Architecture (based on Spring Boot) and Angular framework.
• Configured session timeout with Spring Boot in server side and implemented auto logout functionality.
• Developed Business components using core java concepts and classes like Interface, Polymorphism, Collections, Serialization and Multithreading etc.
• Implemented web services with Apache CXF, JAX-WS (SOAP), JAX-RS (REST) and JAXB framework.
• Implemented EhCache for caching results of RESTAPI
• Consumed REST based Microservices with Rest template based on Restful APIs.
• Implemented Hibernate to access data base layer and designed data models for projects.
• Developed custom queries using hibernate criteria, native SQL and HQL. Developed inheritance domain objects using table per class hierarchy strategy.
• Configured EhCache to load the cached data into secondary storage area
• Developed application service components, configured beans using Spring IoC, created Hibernate mapping files and database schema.
• Deployed components on Web Logic application server.
• Developed unit test cases using Junit and Selenium to automate the integration and functional tests
• Implemented build automation, dependency library management and continuous integration using Maven and Hudson.
• Used Test Driven Development (TDD) as the development strategy in order to build the core engine module.
• Developed Data Access Objects (DAO) for accessing records using various specification files.
• Used JIRA for creating and managing the scrum stories, tasks and defect tickets.
• Consumed REST based Microservices with Rest template based on Restful APIs.
• Developed the application using agile methodology and Scrum method of project management

Tools: Java 1.8, concurrent package, lambda expressions, streams, J2ee, webservices, JMS, XML(Dom, Sax, Xpath, Stax, XSLT), Websphere 7.0, Tibco EMS,, Tibco BW, Spring Boot,Sprig Integration, Spring Batch, Spring Data JPA, EHCache, Jprofiler, AngularJs,, Eclipse3.4,WebStorm, GIT/Stash(Bitbucket), SDP Jenkins, Confluence, Jira, Crucible, SourceTree, Udeploy,XL Deploy,Maven, Windows, Linux, Oracle, Mongo DB, SQL Server

Confidential

Responsibilities:

• Design the database to support High Frequency trading. Redesign the database to address the complex option trading issues.
• Redesign DB objects to accommodate advisor’s values of up to 5 characters, current one support only 3 code advisors, which TDA will be running out by end of October, 2016.
• Redesign to support trade load of up to 8000 advisors in one bulk trade process.
• Gathered requirements for the new OMS and existing application and issues. Analysed the strength and weakness of the existing database and addressed the weakness in the system.
• Modify the procedures and SSIS packages to support advisors for 5 character. Identified close to 1000 procedures and 100 packages, which requires changes.
• All the business logic and validation are stored procedure driven; no adhoc queries are allowed. Restrict the access and implemented stricter Permission roles.
• Deliver milestones and signoff, address project issues, team management. Meet and work with the downstream application resources/team leads to identify, address issues and deliverables.
• Design and develop deliverables for project measurement and success.
• Implement the Distributed replay. Replay the PROD load on PTE and BETA environments, scale up the test cases and get it signed off by the UAT, PEG Teams.
• Automate the SSIS & SQL deployments (Maven & Ant Builds)
• Implemented continuous integration - Closely worked with SCM team to implement Jenkin Jobs, XLDeploy jobs to deploy to test environments upon the proper approvals
• Migrated the Tibco BW jobs from Tibco AMX to Tibco 5.10, re-designed the utilization of DLQ
• Implemented tibco deployments to use centralized cloud configs
• A DB team size of 6 is assembled to execute the development and support testing.
• Used Postman, SoapUI 5.2 tools to test/Verify SOAP/Rest services.
• Extensively used APPD, SPlunk to analyse performance/Application issues.
• Rewritten about 1000 stored procedures, which supports around 16 applications and prepared test cases to make sure not only the changes work for OMS application, but do not break the other applications.
• SQL performance tuning, database tuning and optimization to increase the performance of OMS application and data retrieval. Achieved the target hit rate of maximum 3 second hit per page.
• Design and implementation of SSIS framework and templates for ETL efficiency. Implemented BI express for monitoring.

Technologies Used: T-SQL, Microsoft SQL Server 2012/20005, SSIS 2012, SQL Profiler,Distribute Replay, Tidal, BI Express, Spotlight, APPD, Splunk, Postman, SoapUI 5.2, Tibco BW, Maven, ANT, SVN, GIT, SSMS, PLSQL Developer, pgAdmin 4, MS Tools (Word, Power point, Excel, Project Planner).

Confidential

Responsibilities:

• Redesign, develop, and implement conceptual and physical data models for highly scalable high performance, and secure database systems. Goal is to support 10 million customers from the current 1 million customers in a day
• Gathered requirements, understood the existing application and issues. Analysed the strength and weakness of the existing database and addressed the weakness in the system.
• Implemented Always On Available Group as the new DR. Implemented File Streaming to address one of the pain point in the system. The database handles 65K portfolio files every day, which are delivered to the clients.
• Applied the 2012 features (New datatypes, Date and TVP). Change the joins from character based to integer based (registry comparison)
• Migrate from the Legacy ETL applications to SSIS pkg. Implement File based to Database based SSIS deployment.
• Address problem functional areas (e.g.: Management Fees, Cost Basis, Bulk Upload, FIX)
• All the business logic and validation are stored procedure driven; no adhoc queries are allowed. Restricted the access and implemented stricter Permission roles.
• Deliver milestones and signoff, address project issues, team management. Meet and work with the downstream application resources/team leads to identify, address issues and deliverables.
• Designed and developed deliverables for project measurement and success.
• Implemented the Distributed replay and replay of the PROD load on PTE and BETA environments, scale up the test cases and get it signed off by the UAT, PEG Teams.
• Jobs and dependencies are implemented using Tidal. Interdependencies set at tidal, jobs parallelism is implemented to bring down the batch timing.
• Redesigned the existing Data Load frame work; redesign the input/output files for better efficiency. Develop the packages in SSIS and implement BI Express Framework for monitoring.
• Revisit the Query joins, functions in where class, aggregates (move from constantly deriving the aggregates to aggregate tables).
• Fixed indexes. Most used queries are fine-tuned and indexes are modified to make the calls as covered query. System created planes been removed and required plans are converted into indexes.
• Normalize the larger OLTP tables to 3rd normalization. De-normalize historical data tables for reporting.
• Addressed data fragmentations issues and tables been redefined to have minimal fragmentation going forward.
• Rewritten close to 1300 stored procedures, which supports close to 16 applications, implement new 2012 features.
• Perform SQL, database tuning and optimization to increase the performance of application and data retrieval. A hit rate of maximum 3 second hit per page should be met.
• Redesigned the tables, views, indexes, functions for better performance.
• Nightly(daily) batches took 6-8 hours of operation. Redesigned them to complete in 2 hours, which are now written to use SSIS packages.
• Data files are redesigned from fix size based to actual size based, to reduce the network traffic and increase the DB load time. E.g.: A file of 6 GB of security data had become 1.5 GB actual data size.
• Designed, developed, and implemented SSIS framework and templates for ETL efficiency. Implemented BI express for monitoring.

Technologies Used: T-SQL, Microsoft SQL Server 2012/20005, SSIS 2012, SQL Profiler,Distribute Replay, Tidal, BI Express, Spotlight, APPD, Splunk, Postman, SoapUI 5.2, Tibco BW, Maven, ANT, SVN, GIT, SSMS, PLSQL Developer, pgAdmin 4, MS Tools (Word, Power point, Excel, Project Planner).

Confidential

Responsibilities:

• Account View is Confidential ’s primary portal for client access to account information and statements. The system was built in 1998 and had changed little since. The requirement is to scale up the system to support 10K advisors and 300K+ clients along with the new business and applications features proposed.
• Involved in the RPF, requirement and design of the system. A team of 50 users worked on this. DB team size is 8 to migrate the database from DB2 to SQL server and coding
• Designed the database to support the application to be accessible from Confidential Advisor Websites, Advisor Square Websites, the Wealth Vision Client Portal, or AX online.
• Key changes implanted Changes proposed and implemented on the account level data to support primary and secondary accounts holders, ownership and including the ability to turn off paper statements, delayed quotes and market data,
• Used SSIS for ETL jobs, SSMS for coding, SQL profiler for performance analysis. Application was designed to be a thin layer with all the load like business logics, validation, data manipulation on the procedures.
• Created the jobs for system monitoring the databases and ETL Jobs.
• Attributes mapping document prepared and used for data migration between, due to database design changes and support new business features.
• Prepared and used the validation checklist document to validate all the mapping. Prepared and used the unit test cases to compare the data.
• Prepared and used test scripts and Unit test the mappings and for data validation and data integration.
• Roles have been implemented for the application use based on the user level.
• As part of Managing the team, assigning the tasks, updating the status to Onsite & Offshore Managers, managing the team to adhere to meet the deadlines of the tasks.
• Requirement was to keep the down time 24 hours. Implemented multi-layered approach and brought down the down time to 12 hours.
• Skelton approach was proposed so that App team can continue working in parallel with the DB development.
• Used SQL Server Migration Assistant (SSMA) tool to migrate the data from DB2 to SQL server in a multi lawyered approach.
• Since the App development and the DB development in parallel due to timelines, proposed the skeleton approach (which is basically creating the SP structure with the hardcoded data).

Technology: SQL Server 2008, DB2, SSMS, SSIS, SQL Profiler, SQL Tuning Advisor, MPP, Excel, ER Studio 8.x, Microsoft Office products

Confidential

Responsibilities:

• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts.
• Designed the Mapping Technical Specifications and Design Document on the basis of Functional Requirements.
• Travelled to the client place in order to handle the client in absence of onshore PL
• Created reusable mapplets and transformations starting concurrent batch process in server and performed backup, recovery and tuning of sessions.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time.
• Tested the Informatica mappings with manual testing and assisted QA team.
• Performed Code and Technical Review with team members.
• Involved in writing $U scripts to run Informatica workflows.
• Involved in unit and integration testing.
• Administer the repository by creating folders and logins for the group members and assigning necessary privileges.
• Extensively used Informatica 8.5 client tools - Source Analyser, Warehouse designer, Mapping designer, Mapplets Designer, Informatica Repository Manager and Informatica Workflow Manager.
• The Objective is to extract data stored in different databases such as Oracle 9i, SQL server, Flat files and to load data into staging tables first and then into Oracle.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc. to load the data into staging tables and then to target. Aggregator, Lookup, Expression, update Strategy, Joiner, Router, processes, test cases, and error control routines Sequence generator etc. transformations in the mappings.
• Involved in performance tuning by optimizing the sources, targets, mappings and sessions.
• Monitored transformation processes using Informatica Workflow monitor.
• Used SQL tools like TOAD to run SQL queries and validate the data loaded into the target tables.
• Used Oracle Stored Procedures, Functions, and Packages.
• Prepared test scripts and Unit test the mappings and checked for data validation and data integration.
• Responsible for raising the Migration requests and cross checking the migrated code in Production with read only access to confirm the successful migration of all objects