SUMMARY

• Over 7 years of programming experience as an Oracle PL/SQLDeveloper in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Experience in design & Development of Client/Server, web server applications using Oracle 10g/9i/8i, SQL, PL/SQL AND UNIX shell scripting, TOAD.
• Experience in loading data from flat files into database tables using SQL Loader.
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience in writing complex SQL queries using joins and PL/SQL procedures to extract data from various source tables.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.Enforcing data integrity using integrity constraints and database triggers.
• Expertise in writingT - SQL Queries, Dynamic-queries, sub-queries and complex joins for generatingComplex Stored Procedures, Triggers, User-defined Functions, Views and Cursors
• Expertise inDynamic SQL, CollectionsandException Handling.
• Experience with Oracle supplied packages such as DBMS SQL,DBMS JOB and UTL FILE
• Enforcing security by creating roles, granting system and object privileges on the tables, stored procedures.
• Knowledge of database architecture for OLTP and OLAP applications, Data Analysis and ETL Process.
• 2+ years of experience in design and development of Unix shell scripts using K shell for invoking SQL scripts and scheduled them using crontab.
• Extensive knowledge in Database query tuning, performance tuning of reports and troubleshooting Oracle Application issues on OLTP and DSS systems.
• Having 1yr of ETL and data integration experience in developing ETL mappings and scripts using Oracle for InformaticaPowerCenter.
• Actively involved in capacity planning, creating views, Materialized views, partitioning tables and creating Indexes etc for optimization process.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows XP, Windows 2007/2008/2010

Languages/Utilities: SQL, PL/SQL, Java, SQL Loader

Development tools: SQL developer, SQL * Plus, TOAD,SQL * Loader, SQL SERVER

Database: Oracle 10g/11g, SQL Server

Scripting tool: Korn Shell Script

Scheduling Tools: Autosys

Others: HTML,XML,Eclipse.

PROFESSIONAL EXPERIENCE

SQL Developer

Confidential

Responsibilities:

• Involved inrequirement gatheringand analysis phase
• Created and managed third party client specific on-boarding project plan.
• Creating new databases as and when required, creating and maintaining database objects.
• Involved in database design with application analyst/design team; and work on database environment and database solution design.
• Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• Working on session management, database locking/blocking issues, hang sessions; monitoring resource intensive queries and optimizing those in production environment.
• Using SQL to query DatabasesPerforming various validations and mapping activities
• Involved in extensiveDATA validation by writing several complex SQL queriesand Involved in back-end testing and worked with data quality issues
• Advance PL/SQL development using dbms packages, xml functions, regexp, directories, For all, bulk collect, table collections, user defined data type etc.
• Tuned SQL queries using explain plan generated in TOAD and SQL Navigator.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Extensively used Cursors, REF cursors, User defined object types, Records, in PL/SQL programming.
• Worked extensively with the Business analyst and involved in discussions with the users in requirements and any change request those were requested by the business.
• Review daily report procedures to maximize efficiencies and minimize reporting risk to client’s portfolio.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Responsible to load various table data, flat file data to populated and processed on daily basis from legacy to online production environment usingSQL*LOADER.
• Wrote Unix Shell Scripts for automation process.
• Designed reports that had complex SQL, PL/SQL code and stored the procedures using Reports 10g.
• Extensively worked with BA and QA team to fix the defects that are logged in Quality Center.
• UsedJirato manage task and to view project deadlines
• Designed and developed specific databases for collection, tracking and reporting of data
• Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, TKprof, Autotrace and DBMS APPLICATION INFO .
• Automated tasks using shell scripting.

Environment: Oracle 9i, SQL Developer, AQT, UNIX, Autosys, WInscp, SQL*LOADER

SQL Developer

Confidential

Responsibilities:

• Created heavy stored procedures for financial transaction by using procedural parameters & worked with packages, blocks & exception handling.
• Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.
• 24/7 production support for both the payment applications.
• Involved in supporting/fixing production defects and day to day business transaction issues.
• Used SQL Navigator, a popular tool which increases user productivity and application code quality with rich features to manage database objects, develop and debug PL/SQL and create, execute and optimize SQL queries.
• Developed scripts to create tables, views, synonyms, sequences, PL/SQL stored procedures, functions, packages and database triggers.
• Developed and maintained database system and performed general database procedures.
• Developed for Data Extraction, Data Mapping and Data Conversion using SQL, PL/SQL and Various Shell Scripts.
• Created bitmap indexeson low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• Extracted data from the XML files transmitted to the bank and loaded them efficiently into oracle temp tables for day to day customer financial transaction reconciliation.
• Developed UNIX scripts for sending mails to the bank and the business team, when the external feeds to the bank are received.
• Wrote complex SQL’s using joins, sub queries and correlated sub queries.
• Used features like PL/SQL record inserts updates and worked with ref cursors.
• Wrote complex SQL’s using joins, sub queries and correlated sub queries.
• Worked as per the Change Request Raised from the end user.
• Convert the functional requirements into technical document as per the business standards.
• Responsible for creating the shell scripts for the batch jobs and for automation process. Setup the batch job execution using Autosys. requirement and applying the changes after creating a change control.
• Tuned procedures/SQL queries for maximum efficiency in various databases usingOracle Hints, for Rule based optimization.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Wrote Test cases and performed data validation and process testing for application moving into production.
• Knowledge in Shell scripting to automate system administration jobs as per Business
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Involved in migrating database from oracle 9i to 11g database.

Environment: Oracle 9i, 11g SQL, PL/SQL,SQL*Loader, SQL Navigator, Crystal

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Wrote complex SQL queries to retrieve information from the database depending on user requirement.
• Created PL/SQL program units to implement DML, DDL statements using dynamic SQL.
• Wrote control files and loaded the data into oracle database with SQL*Loader.
• Wrote complex oracle SQL using joins, sub queries and correlated sub queries
• Handled various Exceptions to trouble-shoot PL/SQL code.
• Performed developed and documented systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality
• Created test documents, performed unit, End to End and User Acceptance Tests
• Involved in importing the production data to lower environments for testing purpose.
• Involved in handling the changes in compiling scripts according to the database changes.
• Created tables, table spaces, schemas, views, packages, stored procedures, triggers, functions etc using TOAD tool.

Environment: Oracle 9i, SQL, PL/SQL,UNIX