SUMMARY

• Around 8+ years of IT experience as a PL/SQL, Oracle developer, Oracle Forms/Reports Business Objects Reports Developer.
• Excellent command on Oracle SQL, PL/SQL, SQL*LOADER, HTML, DHTML.
• Experience in Data warehousing concepts and Data mart building, Decision Support Systems using ETL Tools.
• Experience in Design and maintenance of Telecommunication, Retail, Insurance and Financial Data Warehouse applications/Domains.
• Advanced knowledge in ETL, Data warehousing with OLAP technology, ETL Tools.
• Strong Business Intelligence Skills with experience in Oracle reportsand Business Objects.
• Experience in using Oracle Forms, Reports, Discoverer for developing end user screens and reports and also adept in using Oracle Tools like SQL* Plus, Toad, SQL Developer, SQL Loader, Data Loader, SQL navigator.
• Good knowledge in creating DDL, DML and transaction quires in Oracle SQL and SQL Server Database.
• 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.
• Expertise in Database PerformanceTuning, Performance Monitoring and Optimization using Oracle Hints, SQL Trace, Explain plan and TKPROF.
• Proficient in developing and maintaining of packages, functions, application procedures, stored procedures, triggers, tables, indexes, views using Oracle PL/SQL database programming language and maintaining the DDL scripts.
• Used supplied packages to extend the functionality of PL/SQL programs such as DBMS JOB for scheduling, UTL FILE to read and write from database, DBMS SQL to write Dynamic SQL etc.
• Lead SDLC activities including architecture, analysis, design, development, testing, implementation & maintenance of application software in the Client/Server and multi - tiered environments. Extensively worked/supported Unit, System and Integration testing and Functional testing.
• Highly motivated team player with good communication skills and excellent problem solving abilities. Would be willing to work independently or as part of a team.

TECHNICAL SKILLS

Operating System: Windows 2003/NT/XP/7, HP UNIX, Solaris, Linux, IBM AIX

Programming Languages: C, C++, Java, Unix Shell Scripting, .NET SQL and PL/SQL.

RDBMS: Oracle 11g/10g/9i/8i, SQL Server 2003

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK

SQL Editors: Toad, SQL Navigator and PL/SQL Developer.

Development Tools: Developer 11g/10g/9i/6i suite (Forms 10g/9i/6i, Reports 10g/9i/6i), Oracle Designer 2000/6i, Discoverer 9i, Erwin, SQL*PLUS, SQL*Loader, Oracle Enterprise Manager.

PROFESSIONAL EXPERIENCE

Confidential, Nyc, NY

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.
• Extensively used PL/SQL Developer for creating database objects, running the command scripts for inserting the configuration data items.
• Created databases, tables, views & schemas. Involved in the Database design and application development to support the creation and management of online business units for business users and customer’s usage.
• Troubleshoot jobs using the debugging tool.
• Worked on materialized views, DBMS SCHEDULER for scheduling jobs and UTL MAIL to send mails using oracle 10g.
• Involved in reverse engineering of the application using Erwin.
• Used Erwin to transform data requirements into data models.
• Involved in moving the code to production using Change Management Procedures.
• Designed, developed and documented all the packages, procedures and functions involved in ETL process.
• Written many database triggers for automatic updating the tables and views.
• Created Batches and executed the batch jobs usingReveleus.
• Created Database Scheduler scripts and applications using UNIX shell scripts.
• Actively involved in capacity planning, creating views, materialized views, partitioning tables and creating indexes etc. for optimization process.
• Responsible for back end stored procedures development using PL/SQL predefined procedures.
• Used Explain Plan and hints to tune the SQL
• Loaded and unloaded data sets from or to Oracle Databases using various kinds of data loading tools such as SQL*Loader and Oracle Import/Export Utility.
• Involved in creating user documentation and providing End user training.

Environment: ORACLE11g/9i, Erwin, SQL* Plus, UNIX, Reveleus, PL/SQL Developer, Windows 7, SQL * Loader, TOAD, PVCS.

Confidential, CO

Sr. Oracle PL/SQL Developer

Responsibilities:

• NBRIC2 application includes csr, managementand warehouse and fee processing modules.Involved in writing the SQL queries using Analytical functions.
• Worked on modules like csr, managementand warehouse.
• Wrote about 200 SQL queries for the front-end reports using joins, subqueries and inline views.
• Involved in design, development and modification of PL/SQL stored procedures, functions, packages and triggers to implement business rules into the application.
• Involved in writing procedures and cursors for loading the tables.
• Migrated data from legacy data base (NBRIC1) to target data base (NBRIC2) using PL/SQL procedures, SQL* Loader and insert statements.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries.
• Attended business meetings and knowledge transfer sessions with off shore team.
• Involved in giving demos to the client.
• Validated the newly build target reports with the data from legacy application reports snapshots.
• Involved in performance tuning the SQL queries using Explain plan,TKPROF and SQL trace.

Environment: Oracle 10g, SQL, PL/SQL, Oracle SQL Developer, TOAD, SQL*LOADER, Java, Java Script, JSP, Servlets, HTML, Eclipse, Beyond Compare,Quality center, Windows XP.

Confidential, KOP, PA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs.
• Developed back end interfaces using PL/SQLstored procedures, packages, functions, Object Types, DB triggers, Indexes and Collections.
• Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system.
• Involved in accomplishing automated data extraction from various RDBMS via scripts, ETL in database usage and especially in data warehousing.
• Involved in development of User Interface Objects (Forms9i and Reports9i) and Testing of entire module.
• Analyzed, designed and developed Oracleforms 10g queries, layout, report triggers, parameter form, data models etc.
• Hands on experience working with error handling and performance tuning in TERA data queries and utilities.
• Developed Database objects like tables, Indexes, triggers for Reporting Database.
• Documented all the packages, procedures and functions involved in ETL process.
• Maintained performance tuning by using SQL-Related Performance Tools like EXPLAIN PLAN, SQL Trace and TKPROF, Indexes and Clusters.
• Worked in Oracle Cursor, Exception Handling, Collections like REF, Nested tables, VARRAYS & IOTs.
• Create reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae.
• Created reports using data providers like universes, freehand SQL.
• Good in optimizing SQL queries by reading Explain plan statistics.
• Used UNIX Shell scripts to deploy the Oracle forms and reports to production servers.
• Implemented SQL*Loader direct path option for bulk inserts into database.
• Involved in designing new universes and modify existing universes using features like aliases, loops, contexts, joins. Creating dimensions, measures and detail objects which are grouped into classes.
• Involved in Unit testing the Oracle developed scripts.
• Used Oracle defined packages DBMS JOB, DBMS SCHEDULER for job scheduling.
• Modifying existing scripts for query performance using TOAD.
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.

Environment: Oracle10g, SQL, PL/SQL, UNIX, Toad, SQL * Loader, Forms 9i, Reports 9i, Business Objects XiR3, Visual Studio, UNIX Shell Scripting, Microsoft Office Tools.

Confidential, Louisville, KY

Oracle PL/SQL Developer

Responsibilities:

• Created and maintained Oracle schema objects like Tables, Indexes, Sequences and Synonyms.
• Wrote 60 packages for different modules.
• Involved in writing procedures, functions and cursors.
• Involved in creation of databases, moved databases by creating control files, export/import, and complete backups.
• Involved in writing complex SQL queries.
• Wrote SQL*Loader scripts to migrate the data from the text files, CSV files etc. and populated the intermediate tables.
• Utilized Qwest tool (Toad 8.0) for database monitoring and tuning.
• Delivered custom ETL solutions for extracting legacy data from more than 200 files and from CSV files, Text files and Oracle data sources.
• Used external tables to manipulate data obtained daily before loading them into the tables.
• Involved in ETL processes to load data from Flat files, XML, Access and CSV files into the target Oracle database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Worked on Performance tuning by using Explain Plan and various Hints.
• Involved in creation of about 100 reports using Reports 6i.
• Involved in data gathering, analyzing and defining data requirement needs.
• Designed Logical and Physical data, defined relationships, and implemented business rules as constraints for normalization / denormalization of entities.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Involved in Unit Testing, System testing and UAT Testing.
• Documentation of all modules for user level and system level maintenance.

Environment: Oracle 10g, SQL, PL/SQL, TOAD, SQL*LOADER, Forms 6i, Reports 6i, Erwin, UNIX, UNIX shell scripting, Java, Java Script, JSP, HTML, Quality Center.

Confidential, Columbus, OH

Oracle Developer

Responsibilities:

• Gathering business requirements from end users.
• 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.
• Used Clear case for version controlling and Clear Quest for ticketing system.

Environment: Oracle Database 11g/10g, Oracle APEX 3.2 Windows XP, UNIX, SQL Loader, TOAD, Oracle Forms 10g, Oracle Reports 10g, Discoverer10g, XML, SQL, PLSQL, VSS, InformaticaPower Center 8.1

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed Oracle forms, database triggers, cursors, stored procedure
• Developed PL/SQL Packages, Functions
• Utilized SQL*Loader to load flat files database tables.
• Responsible for SQL tuning and optimization using Analyze, EXPLAIN PLAN, TKPROF utility and optimizer hints
• Utilized PL/SQL developer tool in developing all back end database interfaces
• Worked on responsible for performing code reviews.
• Developed user documentation for all the application modules. Also responsible for writing test plan documents and unit testing for the application modules
• Worked in Oracle Cursor, Exception Handling, Collections like REF, Nested tables, VARRAYS and IOTs
• Developed graphical interface of Adobe Designer enables users to quickly design forms and maintain form templates.
• Created database scheduler scripts and applications using Unix shell scripts, SQL *Plus script
• Maintained performance tuning by using SQL-Related Performance Tools like SQL Trace and TKPROF, Indexes and Clusters etc.
• Worked on Report generated for Inventory, Sales and Material Planning
• Analyzed data flow in the business process
• Upgraded, maintained and troubleshooter for Oracle Forms and Reports
• Oracle Forms created the back-end system for administrators
• Worked on Screen designed, table designed, preparation of user manual and development of the Program using Developer Forms 6i, Designer 6i, Reports 6i, PL/SQL.

Environment: Windows 2000, Oracle 10g, PL/SQL Programming, Web logic 9, 9.1, 10, Oracle Forms 6i/10g, Oracle Reports 6i/10g, Unix/KORN/Perl, Data Modeler, SQL, SQL*Loader, EXPLAIN PLAN and TKPROF tuning utilities.