SUMMARY:

• Working in Banking and Financial Services Industry BFSI domain for past 7 years.
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.
• Strong experience and Technically sound knowledge in Oracle 10g/11g, SQL, PL/SQL, Stored Procedures, Complex SQL, Collections, Dynamic SQL, Bulk binding techniques , table partitioning and Unix Shell scripting.
• Experience in query optimization, performance and tuning PL/SQL using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages and creation of Oracle Objects - Tables, Materialized views, Nested Tables and Collections.
• Good understanding of new features of Oracle 11g for PL/SQL programming e.g. External table, analytical functions and dynamic SQL enhancement and virtual columns and Pipelined Table functions.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in Task Automation using UNIX Scripts, Job scheduling and Communicating with Server using pmcmd. Extensively used Autosys for Job monitoring and scheduling.
• Experience with DBA activities like creating table spaces, granting and revoking privileges on database objects, export-import, and gather statistics on table.
• Have Full Life Cycle experience for software products that includes: Analysis, Design, Development, Testing and Maintenance.
• Experienced in Implementation, Upgradation and Production Support of Oracle Applications.
• Knowledge on preparing functional documents which are related to change requests and customizations.
• Total experience in Corporate banking Modules like Loans and deposit, Interest and charge, Funds transfer, GL General ledger , Check Clearing, SI module of FLEXCUBE.Knowledge on Account Operations, GL reconciliation, Data Entry, Journal Teller Operations and End of the Day cycle and Begin of the day operations.
• Worked on Oracle Forms 6.0/6i/10g.
• Experience in INFORMATICA 9.x applications. Designed and developed the Workflows, Worklets, Complex Mappings, Mapplets, Sessions, Tasks, Transformations and schedule the Workflows and Sessions.

TECHNICAL SKILLS:

Database Systems : Oracle 11g/10g

Database Development Tools : PLSQL Developer, TOAD, 9i-10g Developer Suite, SQL Loader

Operating Systems : UNIX Sun Solaris, HP-UX/UX, IBM AIX/AIX 6.1, Windows 2008/XP/Vista/7, LINUX.

Language : Java script, PERL

Tools : INFORMATICA Power Center 9.x/8.x, Oracle Forms

PROFESSIONAL EXPERIENCE

Confidential

Oracle Sql Developer

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Developed FRD Functional requirement Document and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
• Used SQL loader to load the data from the files provided by the interfacing applications.
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
• Developed PL/SQL scripts using complex queries to generate ADHOC business report and for new enhancement in the application using TOAD.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created analysis of source systems, business requirements and identification of business rules.
• Worked on complex mappings, mapplets and workflow to meet the business needs ensured they are reusable transformation to avoid duplications.
• Extensively used ETL to transfer and extract data from source files Flat files and Oracle and load the data into the target database.
• Extensively used Autosys for Scheduling and monitoring.
• Designed and developed efficient Error Handling methods and implemented throughout the mappings. Responsible for Data quality analysis to determine cleansing requirements.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Prepared Unit/ Systems Test Plan and the test cases for the developed mappings.
• Involved in analysis and review of User manuals for the developed enhancements.

Environment: UNIX Solaris 10, Oracle 11g, INFORMATICA Power Center, PL/SQL, TOAD, Autosys, Anthill, SVN, SSH Secure Shell, Putty, FTP, and Windows Vista/7.

Confidential

Oracle Developer

• As an Implementation Consultant, and was involved in the all activities related to implementation Involved in analysis, design and coding of Oracle processes in PL/SQL to build packages.
• Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.
• Developed web service application based on Java. This application is user authentication software for core banking application users.
• Developed Flexcube feed for the MANTAS system AML feature in a very short span of time.
• Created the PL/SQL procedures, functions and worked on collection bulk collect, binding, and exception , ref cursor in order to apply the business logic to update the database.
• Created custom triggers to automatically populate different tables and also to restrict the data being inserted to the timesheet tables.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Provided Troubleshooting assistance to all issues and concerns related to Oracle Forms.
• Performed various Oracle DB Performance Tuning using collaborative working practices with DBA.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF and AUTOTRACE.
• Involved in testing the application for Oracle 9i to 10g upgrade.
• Developed Forms Screens used by Oracle Developer Suite for forms procedures, functions and packages generate to end product of forms.
• Oracle Forms developed and deployed in all UNIX environment through Dev, Test, and Prod in an Oracle Applications environment.
• Created sessions and batches for various mappings and automated using UNIX shell scripts.
• Wrote the shell scripts to process the PL/SQL procedures and wrote the PL/SQL program units.
• Created UNIX processes using with KornShell to run automated DBA jobs, and Oracle processes.
• Developed UNIX scripts using VI editor to create FTP Jobs and to schedule the jobs.
• Maintaining Daemon process in UNIX to send error mails if any FTP problems are arising when Data sending to other teams or, another Servers
• Handled various bugs and defects raised in Test and Production Environments.
• Responsible for performance and stress testing.
• Review of Technical change requests and gaps
• Defining Jobs in Tivoli/OPC scripts, which includes scheduling and testing also.
• Strong Knowledge on Data modelling.
• Trouble shooting of all technical problems like slowness, memory leaks, hardware failure etc.
• Customization or implement and production support for Core modules of Flexcube.
• Involved in Analysis/Coding, testing, implementation of new process defined as regulatory changes of CITIBANK to Flexcube.

Environment: Oracle 10g, Form 10g, Report 6i, PL/SQL, TOAD, Java, HP-UNIX , Solaris, XML, Pro C, SQL Plus, Shell Scripts, ETL, Toad 9.0, SSH Secure Shell, Putty, FTP, and WindowsVista/7.

Confidential

• Understanding existing business model and customer requirements.
• The System was developed using Oracle PL/SQL, Oracle 10g developer suite Forms Reports , UNIX.
• Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers, ref Cursors using Oracle 10g.
• Depending on the requirements created and modified database objects like tables, indexes, views, stored procedures, functions, packages, Triggers, synonyms, Materialized views, analytical functions to make new enhancements or resolve problems.
• Since the system was scalable through multi-instancing, was involved in developing a synchronization module between multiple instances.
• Extensively worked with Dynamic SQL, Composite data types Global Temporary Tables. Used UTL JOB to automate the PL/SQL procedures and packages.
• Developed Master Detail reports in Reports 6i to meet the requirements of end users within the system.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Developed many simple and complex ad-hoc reports using SQL Plus and TOAD for the business users. Transformed complex business rules to Oracle PL/SQL.
• Involved in analysis and coding of Interest and Charges, Loans and Deposits, Fund transfer, messaging, Interface Module.
• Involved in preparation of Unit Test Plan.
• Involved in developing help files creation for the complete enhancement.
• Involved in preparation of Test case execution reports for the given enhancements.
• Involved in analysis and review of User manuals for the developed enhancements.
• Was involved in developing one of the crucial modules in the system is error log generation and audit trail.
• Was involved in Design and development of a Message Router System called CTMH which routed messages between multiple systems based on user configurable routing profiles. This extensively used STL to handle various messages and the routing partners.
• Performance Tuning for improving time and space efficiency
• Shell scripting for all kind of system health monitoring, File transmission and system maintenance. Handled various bugs and defects raised in Test and Production Environments.
• Responsible for performance and stress testing.
• Review of Technical change requests and gaps
• Trouble shooting of all technical problems like slowness, memory leaks, hardware failure etc.
• Customization or implement and production support for Agency and Originations module of Flexcube.
• Involved in analysis and coding of loan Syndication and Loan-Commitment Module.
• Involved in preparation of Release Notes of given assignments for loan Syndication and Loan-Commitment

Environment: Oracle 9i/10g, Form 9i, Report 6i, PL/SQL, TOAD, Java, , SQL Developer XML, Pro C, SQL Plus, SQL Loader, Shell Scripts, ETL, Toad 9.0, SSH Secure Shell, FTP, MS- Office MS- Office and Windows.