SUMMARY

• Over 8 Years of Experience in teh field of Software Design, Development and Implementation with Proficiency in Oracle, SQL, PL/SQL that includes complete SDLC including architecture, analysis, design, development, testing, implementation & maintenance of application software in teh Client/Server and Internet/Intranet environments.
• Oracle Certified Associate - Oracle 9i Certification
• Very strong in SQL Query Tuning, Database Triggers, Stored Procedures, reducing time for night batch jobs by reviewing PLSQL code, working with DBA for optimization.
• Writing Stored procedures, Functions, Packages, Database triggers, Shell-Scripts and SQL*Loader scripts.
• Strong Trouble-shooting, Problem solving, Analytical & Design Skills.
• Expert in RDBMS including Conceptual/logical & physical Database Design and Model using Erwin modeling tool.
• Expert level experience in Oracle 10g, 9.x, 8.x, 7.x
• Expertise in performing logical backups using export/import utilities and various operations using TOAD
• Performance Tuning of SQL statements and Database using tools.
• Good Understanding in implementing high-performance PL/SQL code.
• Experience working in Oracle Forms and Reports
• Involved in Designing, writing Algorithms and Specifications for various modules of teh Banking projects.
• Experience in UNIX shell programming in various UNIX environments like Sun Solaris, HP-UX and AIX.
• Experience in librarian activities like maintaining source codes using Star team, PVCS and VSS.
• Experience in implementing various Production rollouts of application.
• Worked as a part of team in 24x7 production environment and provided on-call and day-to-day support.
• Strong Domain noledge of Banking Industry
• Possess good communication skills and quick learning ability
• Excellent team player with leadership qualities and coordinating abilities

TECHNICAL SKILLS

Database: Oracle 10g/9i/8i/8.x, Sybase, MS Access

Languages: SQL, PLSQL, C++, Java, XML

Developer Tools: Toad, SQL Programmer, PLSQL Developer, SQL Navigator

ETL Tools: Informatica Power Center 6.1

GUI: Developer 6i (Forms and Reports), Visual Basic 6

Operating systems: MS Windows 95/NT/2000, UNIX, Sun Solaris, MS DOS

PROFESSIONAL EXPERIENCE

Confidential, WI

Oracle PL/SQL Developer

Responsibilities:

• Initial design phase included teh detail analysis of teh current data mart and identification of Fact and Dimension tables and how they are related.
• Worked with teh data mart users to find out their requirements and designed teh data mart tables accordingly to meet teh user’s demands.
• Extensively used PL/SQL programming in backend and front end Functions, Procedures, and Packages to implement business logics/rules. Developed stored Procedures, Functions and various Packages.
• Extensively used PL/SQL programming in functions, procedures, packages to implement business rules, worked closely with DBA for SQL query tuning using Explain Plan, Hints and optimizing teh query.
• Involved in Extraction and teh Cleansing of teh data from flat files using SQL scripts, and used SQL Loader and PL/SQL for loading teh data into Oracle 9i.
• Developed UNIX shell scripts as part of teh ETL process for scheduling.
• Extensively used Informatica Power center for extracting, transforming and loading into different databases.
• Designed, developed and tested teh different Mappings according to Requirements.
• Extensively created database objects like Tables, Indexes, Triggers, Stored Procedures, sequences, synonyms, clusters, views
• Created Materialized views for enhancing teh performance of complex business intelligence queries
• Provided production support to schedule and execute production batch jobs and analyzed log files.
• Extensively involved in unit testing and UTC.
• Involved in creating various documentation like Design document, Unit test plan, integration test plan etc.

Environment: Oracle 11i, PL/SQL, SQL and SQL*PLUS, SQL*LOADER, ERWIN, UNIX Shell Scripting, XML, Workflow Manager 7.x/8.x, TOAD,JAVA.

Confidential, Arizona, AZ

Sr. PL /SQL Developer

Responsibilities:

• Identifying teh information needs within and across functional areas of an organization.
• Modeling teh process in teh enterprise wide scenario.
• Identify teh integration points between functional areas in an enterprise wide model.
• Identifying benefits of cross-functional integration in an enterprise-wide system.
• Worked on optimizing existing PL/SQL packages, procedures, functions and views to suit business needs. Used parametric cursors and ref cursors for performing DML operations involving multiple records.
• Managed database optimization and table-space fragmentation.
• Tuned teh performance of queries by working intensively over indexes.
• Used teh dynamic SQL to perform some pre and post session task required while performing Extraction, transformation and loading.
• Used PL/SQL tables and records in transaction processing.
• Created shell scripts to execute PL/SQL procedures and packages.
• Created different source definitions to extract data from flat files and relational tables for Data mart.
• Created different target definitions.
• Created, modified, deployed, optimized, and maintained Cubes using Cognos.
• Designing teh ETL process using Informatica in order to populate teh Data Mart using teh flat files to Oracle database.
• Writing Unix shell scripts to automate teh processes Performed testing and QA role: developed Test Plan, Test Scenarios and wrote SQL Plus Test Scripts for execution on converted data to ensure correct ETL data transformations and controls.
• Created complex mappings in order to populate teh data in teh target with teh required information.
• Created workflows and sessions in order to perform teh required transformation.

Environment: Windows Server 2003, Oracle 11g,XML, Repository Manager, Workflow Manager, TOAD,JAVA.

Confidential, Northbrook, IL

Sr. Oracle Developer

Responsibilities:

• Gatheird teh requirement from Business users.
• Designed and created logical data models, schema objects, validation code and performance-tuning strategy using various types of Indexes
• Wrote Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes.
• Extensively used SQL*Loader scripts to load legacy data into Staging tables and relevant Packages to validate and cleanse data.
• Developed Several Packages, standalone stored procedures and functions for various requirements from Business.
• Extensively worked with SQL scripts to validate teh pre and post load data.
• Involved in migration, metadata validations, configuring autosys jobs in different environments.
• Create and schedule jobs as per new requirements, if any, support existing jobs.
• Involved in designing teh logical and physical model of database objects using ER-Win
• Normalization of teh Data Models for teh applications
• Involved in Migration of Databases from One version to another version
• Worked with Oracle Enterprise Manager and Toad
• Designed and developed stored procedures/packages/triggers.
• Involved in performance fine-tuning of teh queries/report using PL/SQL and SQL Plus
• Involved in writing complex queries to generate ad-hoc reports as per client request as a part of production support
• Involved in transporting and storing data using XML and HTML.
• Involved in teh design and development of Forms and Reports using Developer2000.
• Conducted requirements gathering meetings to determine how to integrate teh operational data store feeds into teh data warehouse.
• Used PERL to write Web server programs for such tasks as automatically updating user accounts and newsgroup postings, processing removal requests, synchronizing databases and generating reports.
• Involved in Trouble shooting teh loading failure cases. Day-to-Day Production support.

Environment: Oracle10g/9i, PL/SQL, Dynamic SQL, C, C++, UNIX Loader and SQL Navigator, XML.

Confidential

PL/SQL Developer

Responsibilities:

• Monitoring existing SQL code and performance tuning if necessary.
• Created indexes for retrieving data quickly.
• For better performance used EXPLAIN PLAN, HINTS to tune queries.
• Created Temporary Tables in procedure to achieve performance issues.
• Used TOAD for faster application design and developments.
• Wrote complex SQL queries using joins and sub queries.
• Wrote Procedures and Functions using oracle.
• Based on teh requirement developed necessary forms and reports.
• Created indexes to improve teh system performance.
• Wrote scripts for creating Views.
• Read data from flat files to oracle tables using SQL*loader.
• Developed Unix Shell scripts

Environment: Oracle 9i/10g, SQL*Plus, SQL Loader, Toad, Forms 6i, reports 6i & UNIX (Solaris).