Professional Summary

• Over 7+ years of experience in various phases of Software Development life cycle, including Design, Development and Testing using Oracle Technologies and Data Warehousing.
• Strong technical expertise on databases Oracle (11i/10g/9i/8i) on both Windows NT / UNIX environments. Also proficient in taking advantage of both Visual Basic and Unix Shell scripts.
• Proficient in translating business requirements into logical, physical data models and ER Diagrams.
• Expertise in SQL, PL/SQL development and adequate knowledge on Oracle Forms (6i, 10g), Reports (6i, 10g), Oracle Database Administration.
• Expert level skills in Oracle Development (SQL scripts, Functions, Stored procedures, Cursors, Triggers and Packages, Advanced PL/SQL objects, Bulk collections, etc.)
• Extensively used the utilities like TOAD (9.6.1/9.1/8.5/7.4), SQL Developer, SQL Navigator (5.5/5.4), SQL*Plus.
• Experienced in working with SQL*Loader, External Tables, Import, Export to extract and load large volumes of data.
• Hands on experience with Starteam Borland – source control, versioning and change tracking version control tool.
• Experienced in Extraction Transformation and Loading (ETL) processes.
• Extensively involved in Performance tuning in Oracle using Explain plan, SQL_Trace.
• Worked on Production Support, attending production calls, troubleshooting the application and resolving bugs.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Ability to work in teams and independently with minimal supervision to meet deadlines.
• Strong management, administrative and leadership skills to work in team.

• Master of Business Administration in Technology Management
• Bachelor of Engineering in Computer Science

Databases: Oracle 11i/10g/9i/8i, MS Access, Microsoft SQL Server, IBM – DB2
Languages: SQL, PL/SQL, T-SQL,
Database Utilities: TOAD (9.6.1/9.1/8.5/7.4/7.1), SQL*Plus, SQL Navigator (5.5/5.4), SQL*Loader, Oracle Developer 2000(Forms, Reports)
Operating Systems: Windows XP/2000/Vista, Sun Solaris, Red Hat Linux 5.0
Applications: Remedy, Humming Bird – Exceed, Autosys 4.5, Putty, Borland Star Team,
HP-QC, IBM – WebSphere, Microsoft Office IIS 6 version,
RDBMS Tools: Oracle Enterprise Manager (OEM), RMAN, SQL*Plus, Toad 8.0, SQL*NET8
Assistant, SQL*Loader
Oracle DB/Apps: 10g/11g Administration, General Ledger module in Financials
Web Related: HTML, Javascript

CERTIFICATIONS

• Oracle 9i Certified Professional (OCP) in developer track
• Oracle 9i/10g Certified Professional (OCP) in Database Administration
• Red Hat Linux Certified Engineer (RHCE) Version 5.4

Client: Confidential,Citizens Bank, RI July 2012 – Till date
Role: Oracle Lead / L2 Production support
Project: Online Banking (OLB)
Team Size: 11

Responsibilities

• Being a team leader of Online Banking project, I have been handling a team of 11 across Onshore and Offshore managing knowledge transition from the client to Accenture.
• Includes management of client websites and Online Banking Applications of Citizens Bank.
• Co-ordination with various third party vendors during business impacting changes and deployments.
• Attending calls with the Business and Offshore team on daily basis for Requirement clarifications and delivery Issues.
• Identifying risks proactively and proposing solutions to resolve them.
• Sending Weekly status reports to Onsite and Offshore leads.
• Developed several custom Forms to interact with data tables and schema.
• Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables (using both UTL and SQL Loader – for different cases).
• Explain Plan, Tkprof was used for checking the performance of queries.
• Modified and updated existing custom forms to adapt to new database schema.
• Modified Reports to suit client requirements.
• Involved in creation and updates of several SQL packages and Procedures.
• Created SQL scripts for conversion of legacy data (including validations) and then load it into the tables.
• Used UNIX shell scripts to automate and systemize the load process at nightly cycles.
• Developed several reports that help track down an order.

Environment: Oracle (11i/10g), SQL Navigator (5.5), SQL Developer, SQL* plus, SQL* loader,
TOAD 9.6.1, Excel (2003, 2007), IBM – Web sphere, SSH Thick Client and Putty.

Client: Confidential,NJ Jan 2011 – Jul 2012
Role: Sr Oracle Developer

Responsibilities

• Played the role of Oracle developer – Senior Software Engineer from Offshore for Finance Data Warehousing (FDW) application, Bank of America.
• Monitoring the successful completion of the jobs daily which were scheduled for accurate flow of data from one application to another.
• Building complex Structured Query Language (SQL) queries for the various bank applications.
• Debugging the packages, functions, procedures and triggers.
• Tuning the SQL queries for performance improvement.
• Preparing, updating and uploading Knowledge Transfer documents in the project share point folders.
• Addressing the issues raised by the users and providing relevant information to them as needed.
• Involved in the replication of Meryl Lynch (ML) Oracle environment to CORP/UK Oracle and its successful execution to automate the jobs on both the environments.
• Mentored junior resources in the project creating awareness on project specific applications and company standards.
• Writing Autosys Jobs to automate Unix Shell Scripts.

Value additions to the client

• Initiated Banking Interest Group (B.I.G) at Division Unit (DU) level leading the group and its activities. Received Raising Star Award for initiating this group across all Center of Excellence (COE).
• Conducting sessions on Oracle SQL/PLSQL to Graduate entries in the organization.

Environment: Oracle8.0/8i, Developer 2000 (Forms 4.5, Reports 3.0), Designer 2000, Visual Basic 6.0, SQL * Loader, UNIX, Shell Scripting, Oracle Reports, ETL tool – Informatica Power Center 8.1.

Confidential,NY Oct 2009 – Jan 2011
Role: Oracle Application Developer

Responsibilities:

• Actively played the role of Oracle Developer in the technical area of Foreign Exchange domain at Bank of America.
• The responsibility includes monitoring of daily UNIX jobs, Calculation of SPOT Edges, FORWARD Edges, SWAP Edges for the counterparty trades that happen with the customers of Bank.
• Building complex Structured Query Language (SQL) queries for the bank applications.
• Interacting with the team members as needed for the successful completion of tasks assigned.
• Debugging the packages, functions, procedures and triggers.
• Tuning the SQL queries for performance improvement.
• Writing Autosys Jobs to automate Unix Shell Scripts.

Presentations:

• Presented sessions on Technology Management to the teams on various occasions.
• Delivered functional knowledge on banking sector and finance to the peers and other teams.

Environment: Oracle 9i/10g, PL/SQL, TOAD, SQL*Plus, Windows NT, UNIX

Client: Confidential,Canada Jul 2006 – Sep 2009
Role: Oracle Developer

Responsibilities:

• Actively played the role of Oracle developer for the clients Nortel Networks, General Dynamics Land Systems by handling the applications like Synch booker, Electronic Minute Booker, and Global Litigation Systems.
• Gained opportunity to act as Junior Oracle DBA taking care of Oracle Database for one of the internal projects.
• Involved in writing Stored Procedures / Functions / Packages / Triggers/advanced objects like V-arrays, Nested Tables, Records and PL/SQL tables in Oracle.
• Data Migration / Loading / Export / Import/SQL*Loader.
• Distributed Databases (Database Links).
• Scripts for Data Migration From Text files to Oracle
• Advanced PL/SQL Programming using built in Packages.
• Writing Unix Shell Scripts to automate backend jobs
• Loading non-oracle data Converting into the Oracle Database using SQL*Loader.
• Taking cold & hot backups and recoveries for local databases
• Received many project specific awards for timely delivery and contribution to project specific activities.

Environment: Oracle 9i, Oracle Discoverer 4i/10g, PL/SQL, TOAD, SQL*Plus, Windows 2000 Professional.