SUMMARY

• 7 years of experience in design, development, implementation, support and maintenance of business (Unix and Windows) applications using Oracle Client/Server architecture and tools.
• Worked on various projects in banking sector like ATM, POS, card systems, core banking and retail banking applications. And good exposure on emerging technologies like as EMV (Euro, Master and Visa).
• Involved in all the phases of software development life cycle including specification, design, coding, testing, integration, implementation and maintenance of the programs.
• Proficient in development of complex cursors, stored procedures, functions, packages and triggers using Oracle SQL Plus and PL/SQL.
• Experience in tuning SQL queries to improve performance using EXPLAIN PLAN, TKPROF and STATSPACK
• Having good exposure to a wide variety of platforms and shell environments of various UNIX and windows flavors with expertise in scripting development.
• Extensive experience in Client/Server application development, implementation and system design using Oracle Forms, Oracle Reports, Oracle Procedure Builder and SQL Loader.
• Good understanding of different ETL methodologies, OLTP and OLAP processing.
• Excellent RDBMS skills to understand the data model and create database in normalized form by following the three normalization steps.
• Hands on experience in maintaining version control, change management and workflow management using Dimensions.
• Good working experience in data conversion and migration from legacy systems to Oracle using SQL Loader.
• Experience in Oracle DBA activities like table space creation, user creation and grant roles to users.
• Good programming and debugging skills in PL/SQL, SQL and UNIX shell scripting.
• Proficient in Oracle Tools and Utilities such as TOAD and SQL*Navigator.
• Having good working experience on C and PRO*C.
• Exceptional analytical and problem solving skills.
• Proficiency in Developing Technical Specification and Design Documents.
• Strong experience in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.
• Team player with the ability to communicate effectively at all levels of the development process.

TECHNICAL SKILLS

Languages: C, C++, JAVA, SQL and PL/SQL

RDBMS: Oracle 7.x/8.x/9.x/10.x/11.x and SQL Server 2000

Application Dev Tools: Forms 4.5/5.0/6i, Reports 2.5/3.0/6i, Crystal Reports 8.0

Tools: SQL*Loader and Oracle Procedure Builder

Web Technology: Asp 3.0, HTML and XML

Databases: Ms Access, Oracle 7.x/8.x/9i/10g and SQL Server 2000/2005

Scripting Languages: UNIX Shell Scripting and VB script

Operating Systems: MS - DOS, UNIX (Solaris, AIX and HP), Linux (Red hat) and WINDOWS 2000/03/XP

Other Tools: TOAD, SQL Navigator, Dimension version tool, Data Stage and IBM MQ Series

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. Oracle developer / Analyst

Responsibilities:

• Work with end users to understand their business requirements, and translate those requirements into system designs and eventual system implementations.
• Created technical specification document.
• Development, test and implementation of entire business and technology integration initiatives supporting domestic and global financial services processing applications and systems.
• Created complex stored procedures and functions using PL/SQL and Oracle Procedure Builder.
• Creation of database objects like tables, views, procedures, synonyms and packages using Oracle SQL Plus and PL/SQL.
• Created several database triggers in order to enforce business rules.
• Fine Tuned the SQL queries using hints and materialized views for maximum efficiency and performance.
• Designed and developed complex procedures to handle errors and exceptions at both application and database level using PL/SQL and Shell scripts.
• Developed process using packages to perform an upload for the data received on daily basis electronic files from the organization.
• This process includes converting text files received from state using SQL Loader and load into temporary worktables, to further manipulate and load into the actual tables.
• Involved DBA activities like creating different users and grant the roles as part of sanity testing on the application.
• In order to process base 2 settlements with organization, created some additional Forms and modified some of the existed forms using Forms 6i.
• Extensively used PRO*C programs to handle data from front end programs to oracle data base.
• Involved in database Manipulations and Generated reports using Perl scripts and PL/SQL packages.
• As per business unit requirement developed different transaction Reports using Reports 6i.
• Automated the jobs through UNIX shell scripts
• Extensively used SQL*Plus, SQL*Loader and TOAD.
• Wrote complex Shell scripts to automate data loading from flat files into Oracle database.
• Carried out the pre certification with master card and involved in the live certification.
• Coordinated UAT (User acceptance testing) and post live support.

Environment: Oracle 10g/11g, PL/SQL, SQL Plus, Pro *C, C, SQL developer, Master card simulator, TOAD, PERL, Forms 6i, Reports 6i and Unix (Solaris 8).

Confidential, NY

Sr. Oracle developer

Responsibilities:

• Involved in capturing the business requirements and data base design to launch new partners with CITI.
• Created technical specification document.
• Created several PL/SQL Packages, procedure and functions to generate reports for the partners.
• Created several Database Triggers to enforce Business rules.
• Created different database objects like tables, views and synonyms in different schemas.
• Modified existing Packages to generate reports for business unit.
• Worked extensively on performance tuning using oracles features like using Hints and using materialized views etc.
• Worked extensively in implementing Partitioning Techniques.
• Worked on PRO*C to populate data in database.
• Developed user specific reports like Summary Reports using Reports 6i.
• Used SQL Loader to move data across different test environment.
• Wrote several UTPL/SQL (Unit Test PL/SQL packages) to automate unit testing process.
• Wrote several UNIX Shell Scripts in order to schedule the jobs.
• Implemented Java for developing the Web Application.
• Involved in Unit testing, Integration testing and writing Test plan.

Environment: Oracle 9i/10g, PL/SQL, Designer 2000, SQL*LOADER, JAVA, Dimension version tool, Crystal Reports V9, XML, Shell Scripting, Java Script, Test Director, WINDOWS 2000,Unix(Solaris 8).

Confidential

Oracle Developer

Responsibilities:

• Coordinated with users to define and design needs, developed technical solutions ensuring software integrity.
• Converted business logics to logical and then physical design of database systems
• Created complex stored procedures and user-defined functions using PL/SQL and Oracle Procedure Builder for various business operations for data archiving.
• Upgrading databases from earlier versions to the latest versions by protecting integrity of the production data.
• Prepared custom queries and provided management with financial reports as needed. Provided support to end users for various database and application issues.
• Wrote complex business logic triggers for validation and updating of data using PL/ SQL.
• Designed and developed primary database objects using referential integrity rules (tables, views, indexes).
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Extensively used SQL*Plus, TOAD and Wizards
• Analyzed, designed and created reports for users using Business Objects.
• Responsible for application testing and support, version control, production staging and implementation planning, overseeing development efforts, support and training
• Wrote Unix shell scripts for automating batch jobs

Environment: Oracle PL/SQL, SQL Plus, Pro *C, C, Forms 6i, Shell Scripting, Reports 6i and UNIX (Sun Solaris 7).

Confidential

Oracle Developer

Responsibilities:

• Designed the Excel format for each report, along with different column formulae.
• Wrote several complex Macros to populate the data into different worksheets.
• Converted data to appropriate Excel format before importing it to different worksheets.
• Created aggregated tables in particular schema whenever necessary.
• Developed procedures for data queries, data entry, and data updates using C and Pro*c
• Extensively used SQL Navigator, TOAD, and SQL PLUS for writing several SQL queries to pull the data, and for determining the optimization level of the query.
• Used Linux Shell Scripting for encryption of data
• Created complex packages, stored procedures and user-defined functions using PL/SQL and Oracle Procedure Builder for various business operations
• Change current process of producing hardcopy REPORTS by generating .PDF files directly from Excel.

Environment: Oracle PL/SQL, SQL Plus, Pro *C, C, Forms 6i, Reports 6i and Unix (Solaris 7).

Confidential

Oracle Developer

Responsibilities:

• Build high-level design documents for all complex stored procedures, packages and triggers.
• Used SQL*Loader to import data from flat files to Oracle.
• Plan, coordinate and implement version upgrades by protecting integrity of the production data
• Created complex stored procedures and user-defined functions using PL/SQL.
• Database performance tuning for achieving high scalability and speed.
• Developed procedures for Data Queries, Data Entry, and Data Updates using C and Pro*c
• Performed database development, tuning, troubleshooting, and bug fixes of Oracle PL/SQL stored procedures/functions/triggers.

Environment: Oracle PL/SQL, SQL Plus, Pro *C, C, Forms 6i, Reports 6i and Unix (Solaris 7).