SUMMARY

• Over 6 years of experience as Oracle Developer with Extensive knowledge and work Experience in design and development of Database applications in Client/Server environment using Oracle Database and PL/SQL Programming.
• Experience in Design and maintenance of Telecommunication, Retail, Healthcare, Insurance, Banking, and Financial Data Warehouse applications/Domains.
• Expertise working with various versions of Oracle Database including 11g, 10g, 9i, and 8i, with proficient SQL and PL/SQL Development abilities.
• Experienced in various application Development tools like TOAD, SQL Developer, Oracle Forms 11g/10g/9i/6i, Reports 10g/6i, XML Publisher and Discoverer.
• Extensive experience as Oracle Developer in developing and utilizing PL/SQL procedures, functions, packages, triggers incorporating advanced PLSQL techniques like analytical functions, Dynamic SQL, BULK techniques, Collections, regular expressions etc.,
• Proficient in shell scripting, unit testing, code migration/deployment, Pre and post production support, extensions, customizations and Maintenance.
• Working experience in data extraction, transformation and loading operations into oracle using SQL Loader, External tables, DB links, Export/import and UTL FILE.
• Involved mostly in the complete SDLC (Software Development Life Cycle) of application development including design, analysis, development, documentation, deployment and Support.
• Experience in performance tuning and SQL optimization using (Hints, Explain Plan, Auto Trace, and TKPROF), restructuring tables, de - normalization tables.
• Adept Knowledge in various Oracle Utilities like UTL FILE, DBMS SQL, TKPROF, SQL*LOADER, DBMS JOB/DBMS SCHEDULER, etc.,
• Adept Knowledge in using the tool Oracle Applications Express (Oracle APEX) for building interactive web Applications.
• Have extensively worked in developing ETL tool usingInformatica Power Center .
• Involved in project planning and scheduling, System design, Functional Specification, Design specification, preparation of impact analysis, Coding, system test plan, Testing, code review, coordinating user testing and user, Project demonstration and Implementation.
• Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena.
• Ability to work independently and also can be a great team player.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g,Informix 10/11/11.5, DB2 9.5/9.7

Operating Systems: HP-UNIX 11i v2, Sun Solaris, LINUX, Windows, IBM AIX

Program Languages: SQL, PL/SQL, XML, T-SQL, Java Script, C, C++, UNIX KSH

System Networks: Oracle Net, OLAP/MSMQ series, ODBCHTML/DHTML

Database Design Tools: Oracle Forms 6i/9i/10g/11g, Reports 6i/9i/10g, TOAD 9.7, 10.1, ER-win, Power Designer 5.0, Informatica 8.6,Oracle APEX.

Version Control: VSS (Visual SourceSafe), Clear Case/Clear Quest, CVS.

DB Utilities: SQL*Loader, PL/SQL Developer, Export/Import, DBMS SQL

PROFESSIONAL EXPERIENCE

Confidential, AZ

Senior Oracle Developer

Responsibilities:

• Involved in design, development and Modification of PL/SQL stored procedures, functions, packages and triggers to implement business rules into the application.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, triggers, packages, stored procedures, roles and granting privileges.
• Participated in gathering new requirements from user for resolving database issues.
• Created database objects like Tables, Indexes, Sequences and Views etc.
• Extensively worked on Performance tuning by using Explain plans and various hints.
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Used UTL file package to read and write to external files.
• Involved in remediating the unsecured DBlink across all the Schemas over the databases.
• Migrated DBMS JOBS to CONTROL M JOBS where CONTROL M is the Standardized secured optionalized third party tool.
• Migrated the FTP To SFTP using Shell Script.
• Involved in Removing Direct Grants and Implemented the role based grants for privileged access.
• Using ETL tool extracting the data from the Flat Files and Relational databases into staging area.
• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement using Informatica Power Center.
• Used existing ETL standards to develop these mappings.
• Designed and developed a rapid web Application using tool Oracle Application Express (APEX) according to client requirement.
• Generated a interactive reports by using Oracle Application Express (APEX).
• Mostly involved in Application diagnosis and performance tuning in Application Express(APEX).
• Involved in creating documentation for migration and performed extensive testing during the various phases of implementation.

Environment: Oracle Database 11g/10g, Windows XP, UNIX, SQL Loader, TOAD, Oracle APEX Application 4.2, Informatica Power Center 8.6,XML, SQL, PLSQL, UNIX, VSS, HP QC

Confidential, Framingham, MA

Senior Oracle Developer

Responsibilities:

• Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.
• Validated & loaded data into Oracle Database using DB links and external tables.
• Used various Optimizer Hints to speed up the SQL queries.
• Performed various activities like creating, debugging and modifying Stored Procedures, Functions, Packages, Triggers, Tables, Views and User defined functions etc.
• Designed and created tables generating the ER diagrams, enlightening foreign key and primary key constraints.
• 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.
• Gathering Static information for the test data then Testing and preparing the Test cases based on the business.
• Designed and developed forms using Oracle Forms 10g to allow the end users to manage the customer relation effectively and efficiently.
• Developed and customized existing reports as per client specific requirements using Oracle Reports Builder 10g.
• Mostly involved in code reviewing and performance tuning in PL/SQL.
• Worked on creating Materialized Views to maintain copy of the remote data at local node.
• Solving the complicated run time errors collaborating with DBA team members.
• Used ETL tools to extract and load data from SQL Server and flat files to Oracle database.
• Created Test Scripts, Test Plans and Perform the testing for data conversion process.
• Involved in the development of database objects in both OLTP and OLAP databases.
• Developed ETL mappings, transformations using Informatica Power Center 8.1.
• Developed various reports using Oracle Discoverer, EIS and XML Publisher, as per client specific business requirements.
• Having good knowledge on Claims, Benefits, Provider and Contractaffiliations.
• Created documentation for migration and performed extensive testing during the various phases of product implementation.

Environment: Oracle Database 11g/10g, Windows XP, UNIX, SQL Loader, TOAD, Oracle Forms 10 g, Oracle Reports 10 g, Informatica Power Center 8.1,XML, SQL, PLSQL, UNIX, VSS, HP QC

Confidential, Basking Ridge, NJ

Senior Oracle Developer

Responsibilities:

• Assisted in database designing by creating database objects such as Tables, Views, and Indexes.
• Worked with Sub-queries/Correlated Sub-Queries in Different areas of the database.
• Received data from source (Market data & Communications) and imported the data to the interface table using SQL * Loader.
• Designed, developed, tested and implemented User Interface or forms using Oracle Forms 10g.
• Responsible for Designing, development, testing and deployment of Oracle Alerts, Triggers and debugging for Oracle Forms.
• Used Cron Jobs to schedule various reports.
• Coded various processes to meet functionality requirements in PLSQL.
• Developed various database objects including PL/SQL packages, procedures, functions and database triggers as per the client specific business needs.
• Involved in design, development, testing, implementing, various reports using Oracle Reports 10g.
• Migrated various reports and Forms from Oracle 6i to 10g, by recompiling in the 10g environment, migrating to client server environment for single sign-on access, and fixing the un-compiled objects by tweaking the custom code.
• Worked on Migration of process from servers to different upgraded servers.
• Developed custom reports like Non Moving Product, Over Stocked Product Report.
• Developed Revenue reports like Monthly and weekly Revenue, Total Revenue and Monthly Transaction and Revenue Comparison Reports
• Addressing day-to-day issues with business users using tools like TOAD and SQL Developer
• Worked on various ticketing systems including MKS and HP Service Center. Resolved various production issues and migrated the code fixes on a Monthly release schedule based on approvals.
• Fixed various one off issues with integrations for third party systems.
• Created new aggregation tables for the data warehouse enhancement using synonyms, DBA links and Materialized Views.
• Responsible for fast and full refresh of Materialized views as per the predefined business schedules on to the development and user Analysis instances.
• Automated multiple file loading process by designing new shell script for feeding the data file to the loader code, after validating number of files and performed encryption and archived the files depending upon the loader program outcome.

Environment: Oracle 10g/11g, SQL, PL/SQL, Oracle Forms 10g, Oracle Reports 10g, UNIX, MKS, HP Service Center, Rational Clear Case, TOAD, SQL Developer, SQL*Plus.

Confidential, Austin, TX

Oracle Developer

Responsibilities:

• Responsible for interacting with Business Users and other development teams for gathering requirements.
• Developed Functional and Technical Specifications.
• Involved in creating SQL loader scripts to load the data from the flat file received from 3rd party vendors into oracle tables.
• Involved in writing PL/SQL program using UTL FILE package.
• Involved in Unit testing, System testing and UAT.
• Worked as production support specialist and resolved production related issues.
• Developed Functions & Procedures to manipulate the data and to load to the tables.
• Used Oracle Advanced concepts like types, PL/SQL tables and V-Arrays and dynamic SQL in generating the complex extracts from database.
• Implemented parameters, condition, filters and calculations in reports through Oracle Discoverer Desktop.
• Involved in tuning using EXPLAIN PLAN and used hints to tune the queries.
• Involved in the creation of database objects like tables, views, stored procedures, functions, Indexes for new requirements.
• Involved in creating users and requests, schedules in Oracle Apps for all interfaces.
• Responsible for Analysis, Design, Development/Customization and Testing/debugging of the reports.
• Involved in Code Reviews and test Reviews.
• Participating in Quality Audits.

Environment: Oracle 9i/8i, SQL, PL/SQL, Oracle Apps SYS Admin, SQL*LOADER, UNIX shell scripting, TOAD, Windows 2003

Confidential, Maryland

PLSQL Developer

Responsibilities:

• Developed Conceptual, Logical and physical data model and scripts to create users, roles and schema objects
• Developed SQL*Loader control files to extract data from flat files, create error, result log files and load data into temporary table to do validations
• Customized and developed several forms using CUSTOM.PLL and TEMPLATE.FMB to meet client’s requirement.
• Developed customized several reports using reports 9ito meet the client requirement and necessities.
• Fine Tuned Procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain Plans and Trace Sessions for rule based optimizer.
• Worked with partition tables and index to improve the performance of data loading and query processing.
• Developed UNIX shell scripts for coping and moving files to and from the server and to schedule jobs.
• Documented test cases and test scripts to test the project units and make necessary modifications.
• Developed customized screens using Forms 6i at the front-end.
• Reports 6i were used for generating reports on the monthly progress of the projects.

Environment: Oracle 9i, SQL*PLUS, PL/SQL, SQL navigator, SQL*LOADER, PLSQL Forms / Reports 9i, UNIX

Oracle Developer

Responsibilities:

• Created complex stored procedures for financial transaction by using procedural parameters & working with packages, blocks & exception handling.
• Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.
• Extensively developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance.
• Developed PLSQL packages for generating various feeds from oracle database using UTL FILE utility in the client’s secure data transmission server.
• Used SQL*Loaders to download the data into database from the text files and spread sheets.
• Developed UNIX scripts for sending mails to the bank and the business team, when the external feeds to the bank are received.
• Worked on creating Materialized Views to maintain copy of the remote data at local node.
• Solving the complicated run time errors while running the process along with DBA team members.
• 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 various new reports from scratch utilizing Oracle Reports Builder for day to day validations.
• Created various adhoc reports as of when required for the production analysis and issue fixing.

Environment: Oracle Database 9i, Toad, SQL*Plus, SQL* Navigator, SQL*LOADER, UNIX, Forms6i, Reports 6i.

Confidential

PL/SQL Programmer

Responsibilities:

• PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
• Various features of PL/SQL such as Dynamic SQL and parameter passing of PL/SQL tables were evaluated
• Developed SQL Applications for extracting the data from the Oracle tables.
• Extensive testing was done on the programs for achieving accuracy, timely processing of data.
• Involved in the development of backend procedures by using PL/SQL for ledger posting and for reversing the journal ledgers.
• Used Oracle Forms 6i was used to design and develop the interface for the system.
• Oracle Reports 6i was used to create reports.
• Created Reports like Ledger, Profit and Loss statement, Balance Sheet and Trial Balance.
• Used Forms 6i to create Group, Ledgers, Vouchers and Bank Reconciliation statements
• Created front-end procedures and functions with Forms 6i to calculate reorder level and reorder quantity.

Environment: Oracle 9i, PL/SQL and Developer 2000(Forms6i, Reports 6i).