SUMMARY

• Over 8 years of experience as Oracle PL/SQL developer with extensive knowledge on Oracle RDBMS 9i/10g/11g, SQL, PL/SQL, Forms and Reports 6i/9i/10g and UNIX Shell/Perl Scripting.
• Experienced in RDBMS design, data modeling, data normalization and SQL tuning using Indexes.
• Good conceptual knowledge in Data warehouse especially focused on Star/Snowflake Schemas.
• Excellent knowledge in Data modeling with utilities likeER/Studio,Erwin and Visio. Worked on OLAP,Logical and Physical Database Designs.
• Involved in various phases of System Development Life Cycle (SDLC) such as analysis, design, development, testing, implementation and support with exposure in database.
• Developed SQL Loader control programs, interfaces and PL/SQL validation scripts to transfer flat file data into oracle database.
• Knowledge on Oracle Database Architecture and design.
• Strong Experience in enhancing performance by performing query tuning, PLSQL Code tuning and Database tuning using utilities like, Explain Plan, Partitions, TKPROF, Indexes, Optimizer statistics, Hints, etc.,.
• Experience in writing and tuning of complex SQL statements, complex joins and sub - queries.
• Used SQL Trace, Explain Plan and TK Prof for Better performance.
• Implemented PL/SQL advanced topics like Bulk Collect, Ref Cursors, Dynamic SQL, Collections, and UTL FILE to read and write the files.
• Extensively worked on design and generation of different Database Objects like Tables, Views, Materialized Views, Synonyms, Sequences, Stored Procedures, Functions, PLSQL Packages, Database Triggers, etc.,
• Working experience in data extraction, transformation and loading operations into oracle using SQL Loader, External tables, DB links, Export/import and UTL FILE.
• Extensively worked with various database tools like TOAD, SQL Developer & PL/SQL Developer.
• Good experience in version control of documents and database objects using tools like VSS and SVN.
• Knowledge in Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Prepare/Maintain documentation on all aspects of ETL processes, definitions and mappings to support knowledge transfer to other team members.
• Good understanding of Data modeling concepts like ER Diagrams, UML, Use Cases, Normalization and De-normalization of Tables.
• As a whole worked on building ETL Processes with sources from Flat Files, Mainframes, SQL Server and Oracle, And played a vital role in the Team to get the things done.
• Experience in developing reports and forms using Crystal Reports, Oracle Forms Builder, Reports Builder and XML Publisher.
• Experienced in data analysis and testing and documentation of projects. Authored various documents including, BRD, Training Documents, Technical Specifications, Migration Documents, etc.,
• Experience in creating test scripts and performed Unit and Systems tests. Also provided, User Acceptance Testing Assistance and fixed bugs on the fly during testing.
• Extensively worked on Onsite-Offshore models. Participated in requirements gathering in onsite and transferred the knowledge to offshore.
• Organized and efficient to prioritize and manage multiple tasks even in a stressful environments with stringent deadlines.
• Excellent logical and analytical skills and strong ability to perform as part of a team.
• Proficient in shell scripting, unit testing, code migration/deployment, Pre and post production support, extensions, customizations and Maintenance.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, SQL Server 2000/2005.

DB Tools: TOAD, SQL*Plus, SQL*Loader, PLSQL Developer

Oracle Tools: Oracle Reports 10g/6i, Oracle Forms 11g/10g/6i.

Language: SQL, PL/SQL, C, C++, Java.

ETL tools: Informatica Power Builder 8.6/9

Data Modeling Tools: MS VISO, ERWIN, SSIS, and SSRS

Web Technologies: HTML, JSP, Servlets, VBScript

Scripting Languages: UNIX shell (Bourne and KORN) Scripting, Perl.

Test Automation Tools: Win Runner, Load Runner, QTP, Test Director and Quality Center.

Operating Systems: Windows 98/2000/XP, HP UNIX, Sun Solaris, AIX and LINUX.

Version Control: CVS, SVN.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr. Oracle Developer

Responsibilities:

• Responsible for developing and testing of client application code related to US Business applications.
• Worked with Business Systems Analysts and Database Administrators to understand and implement functional and non-functional requirements into the project.
• Created and developed various DB objects like tables, views, materialized Views, partitioning tables, indexes, sequences, synonyms using TOAD. For the business application development.
• Involved in writing PL/SQL packages, procedures, and functions.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases
• Developed ETL process (Extraction, Transformation and Loading of data into Data warehouse).
• Involved in developing scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
• Interacting with the users and troubleshooting the problems involved with the development of Stored procedures, Triggers and with the privileges.
• Modify existing ETL scripts to fix defects at the root cause as enhancement part of project.
• Exported reports into various formats like XML, PDF, HTML, EXCEL, and MS-Word.
• Developed PL/SQL Procedures and UNIX Scripts for Automation of UNIX jobs and running files in batch mode.
• Involved in Database Tuning and Improved Application performance using Explain Plan, TKPROF and SQL trace.
• Created Mail Scripts in UNIX to send notification on successful completion or failure of various Interfaces and Jobs, with Customized Subject and Text.
• Created JILs for scheduling the jobs in Autosys.
• Extensively used Putty to login into UNIX environment
• Extensively used software configuration management system, such as Subversion
• Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
• Designed and developed Oracle Monthly Reports.
• Scheduled the execution of PL/SQL Procedures using UNIX Shell scripts for updating of Base tables from Transaction Tables.
• Automated data loading, extraction and report generation using UNIX Shell Scripting.
• Responsible for the Production Support and Code Fixing
• Worked on UNIX environment and shell scripting for creating Batch Jobs using UNIX KORN, AWK UNIX Shell Scripts and API’s Using PERL Scripts.

Environment: Oracle 11g, PL/SQL, SQL, TOAD, Windows XP, UNIX, SQL*Loader, SQL*Developer, Putty, Tortoise SVN, Informatica Power Builder 9.

Confidential, MI

Sr. Oracle Developer

Responsibilities:

• Gathered business requirements from end users and authored requirement and specification documents.
• Used various Optimizer Hints to speed up the SQL queries.
• Used SQL*Loaders to download the data into warehouse database from the flat files and other data files across different platforms.
• Developed SQL and Shell scripts to create temporary tables and developed SQL*Loader scripts to load data into the temporary staging tables.
• Designed and developed forms using Oracle Forms 10g to allow the end users to manage the customer relation effectively and efficiently.
• Worked on creating Materialized Views to maintain copy of the remote data at local node.
• Mostly involved in code reviewing and performance tuning with optimization techniques in PL/SQL.
• Solving the complicated run time errors while running the process along with DBA team members.
• Involved in the development of database objects in both OLTP and OLAP databases.
• Addressing day-to-day issues with business users using tools like TOAD.
• Having good knowledge on Claims, Benefits, Provider and Contract affiliations.
• Created documentation for migration and performed extensive testing during the various phases of product implementation.
• Designed and developed the logic for handling Slowly Changing Dimension tables load by flagging the record using update strategy for populating the desired
• Developed reusable map-lets and transformations for reusable business calculations
• Used exception handling logic in all mappings to handle the null values or rejected rows
• Tuned the ETL components to gain the performance and to avoid business continuity.
• Worked with Persistent Caches for Conformed Dimensions for the better performance and faster data load to the data warehouse
• Involved in performance tuning and optimization of Informatica Mappings and Sessions using partitions and data/index cache to manage very large volume of data
• Performed query overrides in Lookup Transformation as and when required to improve the performance of the Mappings
• Design, develop, implement, and assist and in validating ETL processes.
• Did unit testing and development testing at ETL level in my mappings
• Involved in the Daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.
• Performed Unit Testing and Integration Testing of the Application. Involved in preparing documentation and user support documents.
• Load balancing of ETL processes, database performance tuning and capacity monitoring
• Developed and customized existing reports as per client specific requirements using Oracle Reports Builder 10g.
• Used Clear case for version controlling and Clear Quest for ticketing system.

Environment: Oracle Database 11g/10g, Oracle APEX 3.2, AIX, SQL Loader, TOAD, Oracle Forms 10g, Oracle Reports 10g, Discoverer10g, XML, SQL, PLSQL, VSS, Informatica Power Builder.

Confidential, CA

Oracle Developer

Responsibilities:

• Analyzed business requirements and coordinated with the business analyst to develop ETL procedures that confirm to the enterprise standards while maintaining consistency across all applications and systems.
• Generated oracle forms and reports in oracle developer 6i and 10g.
• Upgraded forms and reports from 6i to 10g.
• Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards. Developed Unit Test Plans.
• Prepared Business Requirement Specification that gives the comprehensive details about the requirements.
• Developed / modified Oracle PL/SQL codes like stored Procedures, Functions, Triggers etc based on technical and functional specification documents.
• Used Sub-queries, Merge statements and Joins extensively in stored procedures.
• Developed / modified scripts to create tables, views and executed them using SQL Plus.
• Created SQL*Loader control files for moving the data from Flat Files to staging area tables.
• Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process and Oracle Objects including Collections, Types and creating objects.
• Tuning the performance of SQL statements using HINTS and using TKPROF utility & Explain Plan Table
• Prepared the procedures to update the internal structures to reflect the newly loaded data.
• Used batch scripts to loop from database to database, to perform system-wide functions.
• Worked under the supervision of a DBA and created database objects such as tables, views, sequences, synonyms, and table/column constraints, indexes for enhancement.

Environment: Oracle 9i/10g, Oracle Developer 6i/10g, TOAD, SQL Navigator, ER-Win, Sybase, Windows.

Confidential, MA

Oracle Developer

Responsibilities:

• Created Stored Procedures and tuning SQL for maximum performance.
• Created new Tables, Indexes and Sequences where needed.
• Wrote procedures to calculate calendar year returns & trailing year returns both Annualized & Compounded.
• Created Oracle schema i.e., tables, indexes, constraints, triggers, synonyms, database links, roles etc. in development database.
• Extensively used BULK SELECTS and BULK INSERTS in migration stored procedures for enforced data migration.
• Created normal views and materialized views where business requirements needed.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
• Incorporating all the build rules, writing the code using SQL*PLUS, PL/SQL.
• Used SQL Navigator, a popular tool which increases user productivity and application code quality to manage database objects, develop and debug PL/SQL and create, execute and optimize SQL queries.
• Documented changes and enhancements in code.
• Communicated issues and progress to project manager.
• Data migration and conversion done utilizing Oracle Export & Import utility.
• Developed packages for processing data in the staging tables according to the Clients requirements.
• Used SQL*Loader to load data into different tables.
• Verified the data in addition to re-designing the database, front end using Forms 4.5 and Reports 2.5.
• Generated PL/SQL reporting and Unix Scripts to notify process failure/success.
• Involved in solving day-to-day problems, giving support to the users.
• Involved in production support and maintenance.

Environment: Oracle 9i, Forms 6i, Reports 6i, PL/SQL, SQL*Plus, Exp/Imp, UNIX, Quality Center, Windows XP.

Confidential

PL/SQL Developer

Responsibilities:

• Prepared program Specification for the development of PL/SQL procedures and functions.
• Created Custom Staging Tables to handle import data
• Created custom triggers, stored procedures, packages and functions to populate different database
• Developed SQL* loader scripts to load data in the custom tables
• Run Batch files for loading database tables from flat files using SQL*loader
• Created UNIX Shell Scripts for automating the execution process
• Created indexes on tables and Optimizing Stored Procedure queries
• Design, Development and testing of Reports using SQL*plus
• Created Indexes and partitioned the tables to improve the performance of the query
• Involved in preparing documentation and user support documents
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance

Environment: Oracle 9i,PL/SQL, SQL*Loader, SQL Navigator, SQL*Plus, UNIX, Windows NT 4.0/2000/XP Windows2000

Confidential 

PL/SQL Developer

Responsibilities:

• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Involved in the enhancements and fixing of production problems.
• 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.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Developed and customized several forms including Tabular, Mailing Label, Matrix, and Matrix with groups.
• Developed various UNIX Shell Scripts to generate ad hoc reports.
• Performed manual testing on the application and involved in defects fixing team.
• Involved in developing Extraction-Transformation-Loading (ETL) process, using SQL*Loader and PL/SQL package UTL FILE.
• Used ERWIN to develop logical and physical database models.

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