SUMMARY

• IT professional with Seven years of experience working in fast - paced environments.
• Experienced in all phases of the software development life cycle (SDLC) with experience leading, analyzing, designing, developing, testing, and supporting IT initiatives, as well as building and maintaining customer relationships.
• A proven developer with excellent track record widely recognized for excellent technical knowledge, quick learning capabilities, high quality work products, on-time delivery, risk analyzing and providing solutions.
• Extensively worked in Oracle environment using Oracle SQL developer, SQL*Plus, SQL*loader, UNIX, Toad and Oracle Forms/Reports.
• Expert in creating PL/SQL Packages, Subprograms, Triggers, Views, Indexes, Constraints, Sequences, Exception Handling, Collection Types, Record Type, Object Type using SQL Developer.
• Knowledge in UNIX shell scripting.
• Hands on experience on socket Programming.
• Good knowledge in data flow diagrams, data dictionary techniques, Entity Relation modeling, database normalization.
• Excellent communication and interpersonal skills and ability to work independently and in a team with minimal supervision to meet the deadlines.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8I

Tools: SQL *Loader, SQL* plus, TOAD, SQL Navigator, SQL Developer, Autosys, UTL FILE, SharePoint, WebEx, VI Editor, SSH, Erwin, Forms10g and Reports 10g.

Programming Languages: SQL, PL/SQL, C, C++, JAVA, UNIX shell scipting

Operating systems: UNIX, SUN Solaris, HP UX, AIX Windows NT/2000/XP, MS DOS.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr Oracle PL/SQL Developer

Responsibilities:

• Worked with BA to collect and document database design requirements and do data modeling with DB architect using Erwin.
• Implement the back end changes in existing product and in designing the database by gathering and understanding requirements from Business / System Analysts.
• Analyzed the functional specs provided by the data architect and created technical specs for all the projects.
• Developed Oracle database objects including tables, views, functions, procedures, packages, etc.
• Written queries using a lot of aggregate functions, joins, sub-queries, etc.
• Checking execution plan using explain plan.
• Created Indexes on selective columns to optimize queries.
• Developed triggers for auditing and error handling.
• Written Stored Procedures for effective inserts and updates of the data to the tables aimed to reducing the network traffic especially when the application is online.
• Wrote and modified Oracle PL/SQL statements, Procedures and Functions
• Used BULK COLLECT, BULK INSERT and FORALL to decrease query execution time.
• Reproduce Oracle schema objects includes tables, temporary tables, views, indexes, triggers and procedures, based on customer requirement.
• Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.
• Created ODI design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages.
• Good understanding of ODI architecture and installation of Topology, Security Manager, agents, Designer, Operator, Master repository and Work repository.
• Created test cases and test reports and worked with QA team to validate the data and scenarios.
• Solved issues during testing and production phase.
• Provided on call production support during production roll outs.

Environment: Unix, Oracle 11g, Oracle Data Integrator 10.1.3.5, Informatica 7, MS SQL server management studio 2008, Toad, PL/SQL, Erwin.

Confidential, Portland, OR

Sr. Oracle PL/SQL Developer

Responsibilities:

• Analyzed requirements, designed, developed, deployed and documented software components.
• Designed ER diagram using M.S.VISIO, to set the logical and physical relationships of database.
• Developed the SQL*Loader script, and most of PL/SQL stored procedures, Triggers, and views to handle the Online and Batch processes.
• Wrote complex SQL queries using Joins, Sub queries and Group functions.
• Involved in modifying various existing packages, procedures, functions and triggers according to the new business measures.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Created database Triggers for the security purposes.
• Used Oracle snapshots for replication between various sub branches.
• Loaded the data into database using the SQL*Loader from various sources.
• Creating SQL, Object Views, and PL/SQL database objects. Developed the stored procedures for data transformation purposes.
• Developed complex procedures to handle errors and exceptions at database level using PL/SQL.
• Creation of users, granting privileges and roles, maintaining objects, gathering statistics in the database used by java application. Also resolved few performance issues by recommending partitioned tables.
• Performed RMAN full, incremental backups and restored/recovered databases during failures.
• Extensively used cursors, collections and advanced PL/SQL in the business logic wrapper.
• Responsible for implementing the complex queries to support the various reports development.
• Involved in data discovery phase to find the source definition of each and every dimension involved in reporting domain.
• Developed test plan documents for all back end database modules.
• Responsible for unit testing, and documentation of the interfaces.
• Used performance tuning utilities like SQL Trace to improve the performance by reducing the run time of queries on the database.
• Planned version control of production source code using Concurrent Version System (CVS).
• Prepared end user manuals for the developed GUI.

Environment: Oracle 10g, PL/SQL, SQL Plus, Toad, Java, Oracle DBA, Windows 2000 Professional, and UNIX.

Confidential, Reston, VA

Oracle PL/SQL Developer

Responsibilities:

• Generated DDL statements for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures. Developed Database Triggers to enforce security also used ref cursors.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links.
• Designed, Partitioned, Developed and Maintained the database.
• Worked to define the project implementation strategies.
• Designed and developed Oracle Forms & Reports using Forms10g and Reports 10g. Including Forms based on stored procedures.
• Developed ETL’s for Data Extraction, Data Mapping and data Conversion using SQL, PL/SQL and various shell scripts in Data stage.
• Involved in writing Oracle PL/SQL functions, procedures and packages in Oracle RAC environment.
• Written Bash Shell scripts that were used for staging, transformation and loading of the data into base tables.
• Used CRONJOB for job scheduling on UNIX as well as tools like Autosys to run regular day to day administration scripts and setting up batch scripts.
• Developed the stored procedures using PL/SQL Tables and records to generate the output in XML format and pull data from Web services and from XML format and parse it and load it into tables.
• Enhancing the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Created UNIX shell scripts using SQL*Loader, SQL*Plus and PL/SQL programs that run as nightly interfaces.
• Responsible for development and testing of conversion programs for importing data from text files into Oracle database utilizing SQL *Loader.
• Managing Metadata Using the Dependency Manager and administering the Warehouse Using the Repository Browser.
• Created and modified SQL*Loader scripts for migrating flat file data into target.
• Responsibilities include design, development, testing & Implementation of EDW daily receive pre-processing (UNIX Shell Scripts), de-normalization for reporting purpose, data security issues, development of ETL Process, development of ETL

Environment: Oracle database 9i, PL/SQL, SQL Plus, Erwin 7.3,SQL Navigator, XML, Shell Scripting, SQL*Loader, Shell Scripting, AIX, SQL developer, Data stage, CSS, AutoSys, UNIX.

Confidential

PL/SQL Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created newProcedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Created and modified severalUNIX shell Scriptsaccording to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.

Environment: Oracle 9i, SQL, PLSQL, SQL*Loader, UNIX, TOAD, Erwin, UTL FILE