Deployed at client site Nomura India Private Ltd as a database lead to migrate implemented capital market regulatory reporting system onto other system that calculates risk inherent in trading activities perform by Nomura across the countries on day to day basis and provide the report of the same to the Financial Government Regulators in countries where Nomura has its presence.

NPS Housing holds comprehensive data about people, tenancies and properties, helping you to better understand income, arrears, voids, repairs and tenant behavior. It builds a complete view that enables action to be taken fast, keeping tenant support at the heart of what you do.Housing software helps you understand the true value of your assets through asset management, payment management and housing advice etc. These 360views help you to streamline compliance and stay focused on the future, like new tenure strategies and property improvements. You can design surveys, input data in bulk and capture information on the move, as well as analyses whole-life costs. And with the right data on repairs and maintenance always available, you can maximize value and deliver better homes. Housing software used by local municipalities or bodies and corresponding online software by end customers of local municipalities or bodies.

I had a role of lead software engineer working with following responsibilities:

· Perform analysis regarding the handover of the requirement took it from business analyst and help business analyst to prepare design using Oracle APEX.

· Perform estimation of the requirement from development aspect going through design and E-R diagram.

· Write Oracle SQL, PL.SQL scripts and objects during development phase. Also, UNIX shell scripts for batch processing.

· Guide the team of 4 people for the said activities and in doing estimations. Also, guide the team members of another module leads.

· Perform code review, unit testing and system integration testing. Also, code check in and check out into PVCS.

· Interact with client product owner for product review via show and tell concept.

In order to align with the larger objective of Bank Network Management HUB (BNM) to build a centralized and scalable platform, of which ABACUS will be an integral part of, ABACUS should be able to support average volumes and huge number of potential downstream stakeholders to facilitate intelligent decision making.

The components of the strategic BNM HUB (i.e. Workflow & Bank Balance Tracking System) are on Oracle platform while the ABACUS is currently on Sybase platform, which is creating hindrance to achieve the overall BNM HUB strategy. Migration of ABACUS from Sybase to Oracle will pave the way of greater operation control and scalability.

I had a role of database lead working with following responsibilities:

· Explore in terms of selecting the tool for Sybase to Oracle database migration. Perform proof of concept work for the migration using the selected tool.

· Perform analysis regarding challenges involved in the migration in terms of data migration, code translation.

· Resolve the conversion issues of database code that cannot be translated identified by Oracle SQL Developer MIGRATION WIZARD.

· Setting up the DEV and UAT database server using translated scripts with data movement from Sybase to Oracle.

· Interact with client stake holder for functional knowledge during migration.

· Guide the team of 3 people for the above said activities and in doing estimations.

· Perform code review, unit testing and system integration testing.

Roles and Responsibilities:

· Involved in Design Team: (April 2010 to April 2011)

Since January 2010 I am working as a component designer for the two projects mentioned above. I am getting very good experience of solution designing, direct customer interaction and working with the external personals other than teams’ members. I am working independently on the new requirements and responsible for driving the requirement end-to-end.

· Module Team Lead: (July 2009 to April 2010)

For this period, I was leading a development team of 2 to 3 PL/SQL developers. My team was responsible for handling CRs allocated to us right from the handover of high level requirement till the deployment on LIVE servers and also the post deployment issues, if any. I have got the taste of leading the team having mixture of senior team members and freshers for the time critical CRs with tight and challenging delivery schedules with target of zero defect deliveries.

· Involved in Design, Development: (October 2007 to July 2009)

For this period, I was actively working as a PL/SQL developer. My role includes end-to-end responsibilities of CRs which comes under scope of development team. I was actively involved in taking requirement handover from the design team, generating and implementing the Low-Level Design, and driving the CR till its deployment on LIVE servers. I was also responsible for addressing the issues that arrives during the testing rounds of the CR and resolving the issue by taking the required measures within timelines. I was also involved in addressing the issues that may pop up post deployment on LIVE servers and fixing the bugs if required. Being the senior developer in the team I had conducted several Knowledge Transfer sessions for new team members.

I got a very good experience of creating the low-level designs and development in SQL, PL/SQL and web-PL/SQL. I was also involved in administering the database servers and application servers which includes server built for the applications, configuring the Oracle Application Server, creating the Database Access Descriptors (DAD), etc. I also have got a good taste of unit testing, system testing and acceptance testing during this period.

· Involved in Configuration Management (June 2008 to May 2009)

While working in design and development team I was also solely responsible for configuration management activities for 4 projects. My role involved taking baseline on StarTeam for all the 4-5 applications apart from day to day CM activities, merging the ASG fixes with pipelined CRs, etc. I have got a good exposure and hands on experience of CM tools like Borland Star Team.