SUMMARY

• Worked on Oracle10g, Oracle11g, and Oracle12c for over 7(seven) years as SQL developer in both windows and UNIX environments.
• Worked as an ORACLE employee for over 4(four) years as SENIOR CONSULTANT.
• Extensive hands - on experience for over 4(four) years on ORACLE FLEXCUBE, a universal banking product.
• Worked wif US clients for over 3(three) years on Database management and enhancements.
• Experience in configuring application servers like Oracle Weblogic11g and Oracle Weblogic12c.
• Experience in handling cloud banking environments of Confidential and Confidential
• Involved in implementation of FLEXCUBE 12.0.3 on CLOUD database server (Oracle12C) and CLOUD application server (Weblogic12C).
• Experience in handling production support for various top European banks like Confidential, Confidential 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 teh 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 teh customization request by teh client.
• Extensive knowledge on Funds Transfer module in Flexcube wif 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 18months.
• Proven ability to deliver productivity and quality improvements through well-managed, on-time Projects.
• Experience in using SOAP UI for testing various web services.
• Experience in doing UI changes in Javascript.
• Experience in modifying java units and deploying teh same on application server using Jdeveloper
• Experience in Oracle OBIEE and Oracle BI publisher reports development.
• Expertise in using Microsoft office tools mainly on EXCEL.
• 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 & ETL Tools: BI publisher, OBIEEE, SSRS, Informatica PowerCentre

Tools: Oracle SQL Developer, PLSQL Developer, SQL,Plus, Weblogic, MS OFFICE, Oracle JDeveloper, Flexcube RAD,SOAP UI, Qlikview

Scripting: Unix shell scripting, JavaScript(Intermediate)

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, Illinois

Oracle Developer

Responsibilities:

• Created packages and stored procedures to load data from staging tables into transaction tables.
• Created triggers to auto generate teh load date and time when teh data got loaded into teh staging table.
• Created views, materialized views, tables, functions to meet business requirement.
• Developed SQL and PL/SQL scripts to transfer tables across teh schemas and databases.
• Extracted data from transaction tables as well as loaded data onto teh transaction tables from excel sheets, .csv files.
• Worked in development, QA as well as production environment.
• Worked on number ofFormsand Reports for various modules.
• Worked on data validation and data cleansing between different sites and teh back end.
• Tuned and optimized SQL queries as and when required to improve teh performance of teh tool.
• Used various join conditions in SQL query to create views, tables, and materialized views in an efficient manner.
• Participated in teh migration of teh tool from development to production and supported teh issues which occurred due to migration.
• Handled large sets of data which contained more TEMPthan 3,000,000 rows
• Performed unit testing on various modules involved in teh application.
• Added various files to teh Mercurial version Control by using UNIX Shell Script and created a directory in UNIX to store teh version control files.
• Created back up files in mercurial version control by using UNIX shell script.
• Worked on Oracle Discoverer to perform automation scheduling and created scheduling reports.
• Involved in data analysis and data clean ups and prepared monthly reports.
• Created customized job intervals using DBMS JOBS to start and stop at specified intervals
• Worked on enhancing and tuning SQL Queries.
• Prepared technical design/specifications for Data Extraction, Data Transformation, Data Cleansing and Data Loading.
• Involved in meetings wif Business Analysts and end users on application issues for gathering teh requirements and communicating teh same to development teams.
• Implemented agile development practices according to teh application requirements.
• Actively involved in team meetings both on and offshore.
• Wrote scripts to merge data from one system to another system.
• Communicated wif Business Analysts to gather teh requirements and essential enhancements, and ensure alignment wif development teams.
• Coordinated wif teh team in teh daily status meetings to check teh status and report teh same to teh project manager.

Environment: Oracle 11g, SQL Developer, SQL*PLUS, PL/SQL,Oracle Forms/Reports 11g, Mercurial Version Control, Oracle Discoverer, UNIX, Windows.

Confidential, Santa Clara, CA

Oracle Developer

Responsibilities:

• Coordinated wif DBA in creating and managing table, indexes, table spaces, triggers, database links and privileges.
• Implemented physical database models wif Oracle 10g and developed stored procedures, packages and created functions, triggers using Oracle PL/SQL.
• Identified and documented attributes for entities and defined domain for all attributes.
• Develop and review deliverables including requirement, design and test documents Collaborate wif functional and technical teams to resolve technical database related issues.
• Prepared and documented teh Technical Design according to teh business requirements.
• Prepared technical design/specifications for Data Extraction, Data Transformation, Data Cleansing and Data Loading.
• Worked in “Software as a Service” (SaaS) architecture, to design and develop teh applications business logic in teh Oracle 10g/11g databases
• Review of teh performance testing results and providing input to teh testers or Production support team.
• Supported teh testing team wif Defect Management, Requirement Analysis and SQL development for back-end and regression testing.
• Directly involved in process improvement plans and implementing business change
• Extracted data from various sources performed Data transformations and loaded teh data from teh various sources into teh target Oracle database using SQL*LOADER.
• Wrote PL/SQL Stored Procedures, Functions and Packages and Triggers wif extensive use of cursors, complex joins, date functions and string handling functions to implement business rules into teh application.
• Created complex PL/SQL packages for business operations using various PL/SQL records and collections.
• Wrote complex SQL & PL/SQL scripts for database object management and space management (to rebuild indexes/tables) and reporting packages.
• Testing of production fixes in teh test environments to ensure they have resolved given issue as well as ensure production fixes do not cause other application issues.
• Participated in designing and development of software using agile development practices.
• Actively involved in preparing training document for application development and QA, UAT teams.
• Was part of daily stand up meetings and weekly project progress meetings wif teh project manager and teh development team.

Environment: Oracle 10g/11g, SQL Developer, SQL*PLUS, PL/SQL, Oracle Forms/Reports 10g, UNIX.

Confidential, Denmark

Senior Consultant-2 (ORACLE)

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 teh fix deployment.
• Used Explain Plan, SQL Trace, TKPROF, Indexes, and Hints etc to improve teh Performance of teh code.
• Helping bank resolve operational issues during teh 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 wif Business Analysts in meetings to analyse teh requirements and explore potential solutions.
• Experience in using SOAP UI for testing various web services.
• Experience in ETL tools like Oracle Data Integrator and also worked on Informatica PowerCentre on client systems for extracting teh data from production to test environments.
• Experience in doing UI changes in Javascript for funds transfer module screens.
• Involved in weekly status meetings wif teh bank to give inputs on where teh 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 teh performance of teh SQL queries and created teh 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
• Worked on SQL reporting services on client system for designing flexible report views
• Refresh of database for every two months on test environments.

Environment: Flexcube, Oracle 12c, SQL Developer, SQL*PLUS, PL/SQL, SOAP UI, ETL tools, Informatica PowerCentre, SSRS, Jdeveloper, BI publisher, Weblogic12c, Version Control, Tortoise SVN, Visual SVN server, UNIX, Windows, Winscp.

Confidential, Denmark

Senior Consultant-2 (ORACLE)

Responsibilities:

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

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

Confidential, UK

Senior Consultant-2/Analyst (ORACLE)

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 teh schemas and databases.
• Involved in performance testing and analysis of time taken for payment processing.
• Customized screens for teh bank using Flexcube RAD tool.
• Built queries for using in BI publisher reports.
• Carried out data migration from Apex database using Informatica PowerCenter.
• Used PowerCentre for importing data from excel and flat files.
• Trained bank personnel on Flexcube product.
• Presented PRODUCT WALK THROUGH to clients on Flexcube for FUNDS TRANSFER module.
• Deployed monthly patches into test environment.
• Worked on SQL reporting services on client system for designing flexible report views and also used QlikView BI tool for creating flexible visualizations depending on teh requirement.
• Handled version control of all sources going into teh 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, SSRS, Informatica PowerCenter Qlik View.

Confidential, Denmark

Senior Consultant-2 (ORACLE)

Responsibilities:

• Enhancing teh product from handling country specific IBAN to handle multiple IBAN formats in a single branch.
• Handled version control of all sources going into teh development environment.
• Enhancement made bank to cater to customers, other TEMPthan Denmark, who prefer local IBANs to deal wif 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

Senior Consultant-2 (ORACLE)

Responsibilities:

• Implementation support for Confidential .
• Testing of production fixes in teh 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 wif functional and technical teams to resolve technical database related issues.
• Review of teh performance testing results and providing input to teh testers or Production support team.
• Experience in using SOAP UI for testing various web services.
• Directly involved in process improvement plans and implementing business change
• Wrote PL/SQL Stored Procedures, Functions and Packages and Triggers wif extensive use of cursors, date functions and string handling functions to implement business rules into teh application.
• Created customized job intervals using DBMS JOBS to start and stop at specified intervals
• Managed version control of teh 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, SOAP UI, Weblogic11g, Tortoise SVN, Visual SVN server.

Confidential

Senior Consultant-2 (ORACLE)

Responsibilities:

• Offshore support for bug fixes.
• Imaging sample branch image into windows server2003
• Handled customizations in teh funds transfer module.
• Part of implementation team which handled migration to higher version of FLEXCUBE

Environment: VMplayer, Flexcube, Oracle 10g, SQL Developer, SQL*PLUS, PL/SQL, Weblogic10.3.6, UNIX, Windows server 2003, Winscp.

Confidential

Senior Consultant-2 (ORACLE)

Responsibilities:

• 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

SQL developer

Responsibilities:

• Fixing teh 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 wif teh team if any change to be done in teh design.
• Supported onsite testing

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