SUMMARY:

• Over7+ years of experience as Oracle PL/SQL developerinBusiness Analysis, Design and ImplementationofFinancial Business Applications using Oracle Relational Database Management System (RDBMS).
• In - depth understanding of Software Development Life Cycle (SDLC) and industry best practices.
• Strong verbal and written communication skills. Excellent team player and proven track record working in various team sizes performing cross-functional roles.
• Involved in designing various Applications and Reports by interacting directly with End Users and Business Analysts.
• Worked as a Module lead in multiple assignments and successfully tracking them to closure.
• Involved in all phases of the SDLC (Software Development life Cycle) from Analysis, Design, Development, Testing, Implementation and maintenance with timely delivery against aggressive timelines.
• Experience in building and maintenance of Banking Application Database and Reporting.
• Gathers and documents reporting requirements from business owners and/or business analysts, prepares functional and technical design documents.
• Conduct JAD sessions with end users to gather functional and technical requirements, perform GAP analysis, and documenting business processes and flows.
• Works closely with end-users to gather report requirements and ensure proper testing/validation.
• Supports user acceptance testing on production data loading and new features
• Expert in data analysis using various tools and writing SQL queries against various databases including Oracle
• Scope new projects, interpret business needs, translate technical issues, identify and model data requirements, identifying business rules requirements, and test requirements.
• Expertise in Client-Server Application Development using Oracle11g/10g/9i, PL/SQL, SQL *PLUS, TOADandSQL*LOADER.
• Createdvarious schema objects like Tables, Views, Constraints, and Indexes.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in PL/SQL performanceTuning.
• Exceptional Communications and team building skills with proficiency at grasping news functions and technical concepts and ability to communicate at all levels

TECHNICAL SKILLS:

Modeling Methods: Waterfall, Iterative & Agile

Databases: Oracle 9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers),SQL Developer, MYSQL 5.6

Languages/Utilities: SQL, PL/SQL/UNIX Shell Script, Java Script, XML, HTML, C

Operating System: Windows XP/7/8, UNIX

Reporting Tools: Tableau, iReport

Office Tools: MS Word/Excel/PowerPoint/Outlook

Other Tools: HP Quality Centre/ TOAD, SVN, CVS

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

PL/SQL Developer

Responsibilities:

• Developed user defined functions based on requirements. Developed back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers. Created PL/SQL procedures and packages.
• Extensive query optimization and performance tuning. Created the integrity constraints and Database Triggers for the data validations. Used PL/SQL Tables and Records in payment generation process. Written Test Plans and Involved in unit testing.
• Created relevant staging tables to load the CSV files, identified the business validation rules. Created SQL Loader script generator application using UNIX shell scripting and PL/SQL.
• Experience in creating the tables and sequences for the experimental data load capture. Loaded the data into the tables using TOAD and SQL*Plus. Created metadata validation lookup tables and pre populated them using SQL Loader generator application.
• Designed competent PL/SQL programs using PL/SQL collections, Records types, and Object types.
• Developed and automated the interfaces by using the PL/SQL. Developed user defined stages and common templates.
• Tuned several Oracle SQL statements using Explain plan, Auto Trace utilities.
• Involved in implementing table partitions using Range, Hash, Composite techniques.
• Worked on external hints during the SQL optimization to fast up the SQL process.
• Experience in working a variety of analytical functions, RANK, DENSE RANK, LAG, LEAD, and PARTITION OVER.
• Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling. Created triggers for auditing purpose and created group, tabular and form reports.
• Database security by authenticating users, using logon triggers. Created materialized view on remote database and automated scheduler of refreshing of materialized view.

Environment: Oracle 10g/11g, PL/SQL, SQL Plus, Informatica ETL, SQL Loader, SQL developer, Toad.

Confidential, Bloomington, IL

PL/SQL Developer

Responsibilities:

• Creating the design document from Master Requirement Document, customizing existing functionality available in Finacle to cater the Banks requirement, creating new Menus (Finacle terms) to include the functionality that is not available in Finacle base product.
• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Data Validations and testing with Business Users, fixing data issues
• Worked on SQL*Loader to load data from flat files obtained from various facilities.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Creation of database objects like tables, views, procedures and packages using oracle tools like Toad,PL/SQL Developer and SQL* plus
• Creating or modifying existing DB objects (Procedures, Packages, Triggers, Views and Tables, etc.) on Business Enhancement projects and keep the current business running by participating in maintenance of DB.
• Co-ordinate with DBA for changes in database and data partitioning.
• Involved in data report customization using iReport tool.
• Worked in Production Support Environment as well as QA/TEST environments for projects, maintenance requests, bug fixes, enhancements, data changes, etc.
• Developed PL/SQL triggers and views.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Developed Frontend HTML screens using in-house tool.
• Involved in liquidity reporting with the reporting team.
• Actively involved in system production support to resolve the issue on daily basis.
• Analysis of Issues in Production Runs and Implementing Production Fixes.
• Reviewed the code written by other team members.
• Performed Unit Testing for the developed codes.
• Preparation of daily and weekly status reports
• Created Java Scripts to validate the input Data.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL Developer, SQL*Loader, UNIX, Windows XP

Confidential, Oakland, CA

Oracle PL/SQL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for gathering, business analysis, testing, and implementation.
• Involved in logical modeling and physical modeling of database application and Developed Stored Procedures, Functions, Packages using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from flat files.
• Developed SQL scripts, cursors, tables, views, materialized views as per the business requirements.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, Tk-prof and Auto trace.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Part of a development team for creation and maintenance of custom apps/reports.
• Evaluating new techniques for enhanced functionality.
• Developed Perl scripts for data sources for data migration.
• Experienced with bulk collections and for all operations on tables to improve the performance of manipulation language statements.
• Coordinated with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks.
• Developed UNIX Shell scripts to automate table creation, execute procedures using dynamic SQL statements.
• Worked on Data schema modeling and designed Database Schema using ERWIN tools and implemented Normalization on relational modeling.
• Developed data conversion procedures in PL/SQL. Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation.
• Experience in BI reporting and visualization tools such as: Business Objects, Micro strategy, MSBI (SSAS, SSRS and Performance Point), Cognos, Tableau, Crystal Reports, etc.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing.
• Extensively used Database Query tuning and performance tuning of reports.

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, Oracle Forms 10g, Reports10g, Perl, UNIX, Windows XP/2000.owb 10g.

Confidential, Palo Alto, CA

PL/SQL Developer

Responsibilities:

• Worked on Technical Design Documents/Build of PO Receipts Inbound Interface.
• Created PL/SQL package for different validations, for processing data in order to create Valid PO Receipts and for populating the PO interface tables from staging tables and called the Seeded import programs to populate the data in base tables.
• Created Unit Test Protocols, Installation Documents/Scripts for developed objects and Involved in unit and integration testing of the components and prepared documentation for the same.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in analysis and tuning of SQL queries by using EXPLAIN PLAN and TKProf for faster and better performance of the SQL queries.
• Responsible for writing high quality and well documented code according to standards and documentation of various processes.
• Handled code defects, enhancements and migration activities using tools like Jira.
• Used Configuration management tools like TortoiseSVN's and Wincvs to manage files and other versioning tasks.
• Worked with migration team for maintaining migration activities.
• Ensure jobs and audits are in line with project requirements, service level agreements and security policies

Environment: Oracle 9i, SQL, PL/SQL, Toad, Windows 7,Tortoise SVN, WinCVS.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in SDLC gathering requirements from end users.
• Worked in Agile methodology for software development process.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Preparing unit test cases and reviewing the test cases prepared by teammates.
• Creating or modifying existing DB objects (Procedures, Packages, Triggers, Views and Tables, etc.) on Business Enhancement projects and keep the current business running by participating in maintenance of DB.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Day-to-day development tasks involving creating users, tables, indexes, views and other objects, assigning roles and privileges setting up QA environment.
• Analysis of CR’s.
• Involved in Design, creating Logical Data Models
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Performed SQL and PL/SQL tuning, analyzing queries using EXPLAIN PLAN, SQL*TRACE, TKPROF
• Fine-tuned procedures and optimized SQL queries for maximum efficiency using Oracle Hints.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Developed Database Triggers for audit and validation purpose.
• Migrated data from external sources using SQL*Loader.
• Application setup, Test the application with the data provided from client.
• Done User Acceptance testing along with client team.
• Writing validation packages using PL/SQL and tuning them for performance.
• Developed reusable assets that can be readily used.
• Developed Installation scripts for all the deliverables.
• Performed liquidity operations with the reporting team using Basel II.
• Performed functional testing for the procedures and packages.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Worked along with the production support team.
• Prepared Pseudo code for initiating the design model as per the standards
• Analysis of Issues in Production Runs and Implementing Production Fixes

Environment: Oracle 9i, SQL, PL/SQL, Toad, Windows XP, Sun Solaris