PROFESSIONAL PROFILE

• Extensive hands - on experience for over three years on ORACLE FLEXCUBE, a universal banking product.
• Worked on Oracle10g, Oracle11g, and Oracle12c for over 3.5 years in windows and UNIX environments.
• Experience in configuring application servers like Oracle Weblogic11g and Oracle Weblogic12c.
• Experience in handling cloud banking environments of Confidential and Weatherbys Bank
• Involved in implementation of FLEXCUBE 12.0.3 on CLOUD database server (Oracle12C) and application server (Weblogic12C).
• Experience in handling production support for various top European banks like Confidential, Vietin Bank for over two years.
• Worked as single point of contact for all production issues/non-production issues for Confidential for around 18months.
• Extensive experience in SQL database development for various customizations according to the banks requirement.
• Proficiency and expertise in database Server Replication, Backup/Recovery
• Expertise in ORACLE MANAGED SERVICES delivery for cloud and non-cloud customers.
• Data Import/Export using data pump operations on database platforms like Oracle11g, Oracle12c.
• Creation of scheduled jobs in database.
• Experience in designing solution approach, functional specification and program specification for the customization request by the client.
• Extensive knowledge on Funds Transfer module in Flexcube with experience on handling SWIFT and SEPA payments.
• Working experience in preparing deployment package for monthly fixes deployment into production using ORACLE MANAGED CLOUD SERVICES.
• Adept in performance tuning of queries in database.
• Experience in monitoring End-of-Day, End-of-Month, End-of-Year operations for Confidential .
• Denmark, for over a period of 18 months.
• Proven ability to deliver productivity and quality improvements through well-managed, on-time Projects.
• Experience in Oracle OBIEE and Oracle BI publisher reports development.
• Expertise in using Microsoft office tools.
• Experience in version control of sources using Tortoise SVN and Visual SVN server.
• Extensive experience in Flexcube RAD for development.
• Facilitated project status meetings and provided weekly status reports to all stakeholders.
• Experience in troubleshooting weblogic application servers.

TECHNICAL SKILLS

Databases: Oracle 12c,11g/10g, SQL, PL/SQL, RDBMS Concepts

REPORTING Tools: BI publisher, OBIEEE

Tools: Oracle SQL Developer, PLSQL Developer, SQL*Plus, Weblogic, MS OFFICE, Oracle JDeveloper, Flexcube RAD

Scripting: Unix shell scripting, Java Script(Intermediate)

PROFESSIONALEXPERIENCE

Confidential

Senior Consultant

Responsibilities:

• Implementation of Flexcube on Cloud environment.
• Experience in handling ORACLE CLOUD team (OMCS) for monthly production deployments.
• Requirements gathering from Business Analysts and end users.
• Worked on cloud database (Oracle 12c) and cloud application servers (Weblogic12c).
• Involved in writing Test Cases and Unit Analysis and Testing (UAT) to test each and every issue reported before the fix deployment.
• UsedExplain Plan, SQL Trace, TKPROF, Indexes, and Hintsetc to improve the Performance of the code.
• Helping bank resolve operational issues during the day
• Delivering data patches and work arounds for smooth functioning of production.
• Handling Application server issues.
• Built queries for using in BI publisher reports.
• Highly skilled and experienced in Agile Development process for diverse requirements.
• Coordinated with Business Analysts in meetings to analyzethe requirements and explore potential solutions.
• Involved in weekly status meetings with the bank to give inputs on where the issues stands and share estimated time of delivery and gather information from end user about if any performance issues are observed.
• Worked in development, QA as well as production environment.
• Analyzing the performance of the SQL queries and created the scripts for indexes.
• Actively involved in team meetings both on and offshore.
• Created customized job intervals using DBMS JOBS to start and stop at specified intervals
• Handled package preparation for customizations/fix deployments.
• Built queries for using in BI publisher reports
• Refresh of database for every two months on test environments.

Environment:Flexcube, Oracle 12c, SQL Developer, SQL*PLUS, PL/SQL,BI publisher, Weblogic12c, Version Control, Tortoise SVN, Visual SVN server, UNIX, Windows, Winscp.

Confidential

Senior Consultant-2

Responsibilities:

• Increasing the performance and throughput of outgoing payments.
• Worked on solution approach for meeting the bank’s requirement.
• Worked in development, QA as well as production environment.
• Involved in the preparation of Technical and design Specification Documentation.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Coordinated with the team in the daily status meetings to check the status and report the same to the project manager.
• Managed version control of the whole project.
• Enhanced the system to handle 25000 payments per hour from 5000 payments.
• Also handled customizations for outgoing payments according to the bank requirements.
• Tuned and optimized SQL queries as and when required to improve the performance.

Environment:Flexcube, Oracle 12c, SQL Developer, SQL*PLUS, PL/SQL, Weblogic12c, UNIX, Windows, Winscp.

Confidential

Senior Consultant-2/Analyst

Responsibilities:

• Worked as senior consultant cum analyst for this project
• Implementation of Flexcube on Cloud environment.
• Experience in handling ORACLE CLOUD team (OMCS) for installation of database and weblogic domain.
• Setup Flexcube application from scratch on cloud schema.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Involved in performance testing and analysis of time taken for payment processing.
• Customized screens for the bank using Flexcube RAD tool.
• Built queries for using in BI publisher reports.
• Trained bank personnel on Flexcube product.
• Presented PRODUCT WALK THROUGH on Flexcube for FUNDS TRANSFER module.
• Deployed monthly patches into test environment.
• Handled version control of all sources going into the development and test environments.

Environment:Flexcube, Oracle 12c, SQL Developer, SQL*PLUS, PL/SQL, BI publisher, Weblogic12c, Version Control, Tortoise SVN, Visual SVN server, UNIX, Windows, Winscp.

Confidential

Senior Consultant-2

Responsibilities:

• Enhancing the product from handling country specific IBAN to handle multiple IBAN formats in a single branch.
• Handled version control of all sources going into the development environment.
• Enhancement made bank to cater to customers, other than Denmark, who prefer local IBANs to deal with charges on local payments.

Environment:Flexcube, Oracle 12c, SQL Developer, SQL*PLUS, PL/SQL, BI publisher, Weblogic12c, Version Control, Tortoise SVN, Visual SVN server, UNIX, Windows, Winscp.

Confidential

Oracle Developer/Consultant

Responsibilities:

• Implementation support for vietin bank.
• Testing of production fixes in the test environments to ensure they have resolved given issue as well as ensure production fixes do not cause other application issues.
• Develop and review deliverables including requirement, design and test documents Collaborate with functional and technical teams to resolve technical database related issues.
• Review of the performance testing results and providing input to the testers or Production support team.
• Directly involved in process improvement plans and implementing business change
• Wrote PL/SQL Stored Procedures, Functions and Packages and Triggers with extensive use of cursors, date functions and string handling functions to implement business rules into the application.
• Created customized job intervals using DBMS JOBS to start and stop at specified intervals
• Managed version control of the whole project
• Worked on solution approach for customized payment processing.
• Implemented SWIFT/SEPA customizations done for bank business requirement
• Offshore support for smooth movement of customizations into production.

Environment:Oracle 11g, SQL Developer, SQL*PLUS, PL/SQL, UNIX, Windows, Winscp, Weblogic11g, Tortoise SVN, Visual SVN server.

Confidential

Oracle Developer/consultant

Responsibilities:

• Offshore support for bug fixes.
• Imaging sample branch image into windows server2003
• Handled customizations in the funds transfer module.
• Part of implementation team which handled migration to higher version of FLEXCUBE
• Handled schema creation and application deployments.
• Index creations and data migration.
• Import and export using data pump.
• Imaging onto windows server using VM player.
• Query optimization and Flexcube unit testing.

Environment:Flexcube, Oracle 10g, SQL Developer, SQL*PLUS, PL/SQL

Confidential

Junior SQL developer

Responsibilities:

• Fixing the bugs, in SQL, raised during testing phase
• Handled documentation of fix and test cases.
• Database performance testing done and queries optimization done wherever needed.
• Handled internal unit testing during development phase and raise issue with the team if any change to be done in the design.
• Supported onsite testing

Environment:Oracle 10g, SQL Developer, SQL*PLUS, PL/SQL