SUMMARY

• 8 years of programming experience as an Oracle Developer/ PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System.
• Strong skills in Oracle including SQL, PL/SQL (Packages, Functions, Stored Procedures and Database Triggers and Cursors).
• Hands - on Data warehouse experience, creating procedures and packages to extract, transform and load data into Fact and Dimension tables.
• Strong Data Modeling skills using UML.
• In-depth knowledge of designing and building of reports using XML publisher.
• Work experience in Discoverer 10g/4i with proficiency in User, Viewer and Administration edition
• Proficient in Oracle Tools such as TOAD, SQL*LOADER.
• Worked on all kinds of dynamic SQL formats, Connectivity and exception handling in PRO*C programming.
• Expert knowledge in writing UNIX Shell scripts and scheduling and troubleshooting batch loads.
• Expertise in Data Migration, Data Conversion, Data Validation and Interface programming.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Skilled in performance tuning techniques like generating explain plans, creating indexes, running statistics, partitioning, creating materialized views, etc.
• Proficient in several Web Technologies such as HTML, CSS, DHTML, XML, Java Scripts.
• Experience with software Development life cycle (SDLC) process performing detailed analysis, collecting requirements, documents requirements, coding and unit testing, integration and system testing.
• Strong problem solving and analytical skills.
• Excellent verbal and written communication skills.
• Good team player.

TECHNICAL SKILLS

Operating Systems: Windows XP/2000/NT/98/95, Ms-DOS, HP-UNIX, LINUX.

Languages: SQL, PL/SQL, C, C++, Pro*C, UNIX Shell Scripting, XML.

Database: Oracle 10g/9.x/8.x,/7.x,SQL Server 2000, MS ACCESS.

Reporting Tools: XML Publisher, Business Objects, Crystal Reports.

ETL Tools: Informatica, Data stage.

Other Tools: TOAD, SQL*Loader, PL/SQl Developer, Forms Builder, Reports Builder.

PROFESSIONAL EXPERIENCE

Confidential, JN

Sr PL/SQL Developer

Responsibilities:

• Created stored program units like functions, triggers and procedures for implementing complex database intensive business rules.
• Developed Unix Shell Scripts to automate backend jobs and load data into the database using SQL* Loader.
• Built and maintained SQL scripts, indexes, reports and queries for data analysis and extraction.
• Involved in data modelling and design (physical and logical) as per the requirement given by business.
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Executed and maintained the data warehouse extract transform load (ETL) process.
• Developed procedures using native dynamic SQL (EXECUTE IMMEDIATE), dynamic SQL, Ref cursors.
• Used PL/SQL collections like PL/SQL tables,Varrays and nested tables.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database. Created Partitions on the tables to improve the performance.
• Extensively used Bulk Binds (BULK COLLECT and FORALL) wherever applicable.
• Made use of performance tuning utilities like explain plan, SQL Trace and dbms profiler to reduce the run time of complicated queries on Oracle 10g.
• Used performance tuning techniques like Partitioning, Partition pruning, Index by Tables, Bulk Collect, Pipelined Functions, Insert All, Global Temporary tables.
• Performed DBA activities for faster retrieval of data using various optimizer hints such as Parallel, Ordered, Append and Use Hash and used customized v$ scripts to monitor the database processes and performance.
• Used analytical functions like RANK, LAG, LEAD and PARTITION BY.
• Analyzed business requirements, preparation of source-target mapping documents, conducted unit testing and code walkthroughs to ensure there are no missing elements, and performed integration testing.
• Constructed complex SQL queries with sub-queries, inline views as per the functional needs. Create SQL scripts to perform unit and component testing.
• Handled code defects, enhancements and release management using tools like Rational Clear case and Rational Clear quest.
• Wrote Proc*C programs to handshake data with other projects.

Environment: Oracle 11g, PL/SQL Developer, HP-Unix, Oracle Enterprise Manager, SQL*Loader, SQL*Plus, Pro *C, UNIX Shell Scripting.

Confidential, Warren, NJ

Oracle PL/SQL Developer

Responsibilities:

• Involved in analysis, design and coding of Oracle processes in PL/SQL to build packages.
• Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Oracle 11g.
• Used SQL*LOADER and UTIL file loader to upload bulk data by writing scripts for the Control file.
• Worked on the ETL side of the process to load data into database from different servers.
• Created partitions for parallel processing of data.
• Designed and Developed several reports using Oracle Reports 10g.
• Developed UNIX Shell scripting for job automation and daily backup.
• Worked on performance tuning using with DBMS Profiler and Explain Plans.
• Documentation of the business process through Designer.
• Writing backend stored procedures.
• Developed Procedures, Functions and Triggers to be implemented in the Reports.
• Developed data models for adding new tables and fields to the data warehouse.
• Writing event driven triggers, functions, and packages as needed
• Writing SQL queries, Cursors using embedded SQL, PL/SQL.
• Worked on production support, and receive production calls, and working on trouble reports which are received from clients

Environment: Oracle 11g, Pro*C, Oracle Application Servers, UNIX Server 4.3, Windows NT, SQL*LOADER, and TOAD.

Confidential, Marietta GA

Sr. Oracle Developer

Responsibilities:

• Involved in creating data model using ERWIN.
• Responsible for creating use-case diagrams and Relationship Diagrams involving actors and events.
• Responsible for allocation of work to team, assisting the team in day to day development activities and code review process.
• Responsible for providing status of the development to managers and to other teams who are involved in application development.
• Created PL/SQL procedures implementing Oracle collections frame work for cleansing up the stage table’s data using Dynamic SQL.
• Responsible for creating data fixes using PL/SQL procedures and functions implementing cursors and collections.
• Responsible for creating sql queries to SAS users for generating reports and fine tuning the existing queries.
• Responsible for creating statistics of job schedules and generating a report about the source data, target data, throughput, errors.
• Responsible for scheduling the jobs using Autosys as per the requirement in QA Environment and monitoring the job run in PROD environment and taking necessary action for the successful completion of job.
• Responsible for creating UNIX Shell scripts sh) that invokes the informatica workflows when the Autosys job triggers.
• Responsible for creating UNIX CronJob for automation process of workflow run based on requirement.
• Involved in analysis and automation process of Autosys Jobs based on functional and applicationrequirement.
• Responsible for code deployment from DEV to QA and QA to PROD for DDL and informatica changes as per SCR.
• Responsible for checking in files for deployment of code in CVS version control system and to create stage for the same.
• Responsible for performance tuning of existing PL/SQL procedures and functions and performance tuning of informatica mappings and workflows for faster data load.
• Responsible for Error Handling, Data Quality, Data Conversion and Data Retention using ETL Process.
• Responsible for creating the Test cases, Test Data and Test Scenarios and UNIT Testing.
• Responsible for Unit Testing, Integration Testing, Regression Testing, Black Box and White Box Testing.
• Responsible for Code Review and Performance Analysis.
• Responsible for complete implementation of SCR using Team Track System from development to production.
• Responsible for Production Support (24/7 ) and generation of reports.

Environment: Oracle 11g/ 10g, ERWIN Data Modeler, SQL, PL/SQL, SAS, SCO UNIX, TOADCVS Version Control System, SVN, AutoSys Scheduler,Informatica 8.6 power center and Power Exchange.

Confidential, Atlanta GA

Oracle PL/SQL Developer

Responsibilities:

• Created PL/SQL Stored procedures, packages, functions for data upload, bulk loading, Incremental loading.
• Created Triggers to capture the Data manipulation transactions on the Fact tables and Fact history tables.
• Responsible for Oracle Performance improvement activities.
• Implemented the best practices of SQL usage within the project to improve the performance of the SQL.
• Query Optimization for improving the performance of the data warehouse.
• Extensively used TOAD, PLSQL developer to create target tables, PLSQL programs and access data. .
• Worked with various stored procedures to populate data to summary tables.
• Created the transformation routines to transform and load the Incremental Aggregation data.
• Extensively used TOAD, PLSQL developer to create target tables, PLSQL programs and access data.
• Modified bunch of SQL stored procedures that perform income calculations.
• Developed processes for automation of loading data using parameter driven sessions for batch schedule processes, verification and re-conciliation of data stored in several different source systems.
• Involved in generating UNIX scripts to create reports to be sent to ESI Business
• Developed PL/SQL scripts for Data loading and Data extraction.
• Worked with analysts and data source systems experts to map requirements to ETL code.
• Responsible for preparing developed Test Plan, Test Procedures and Test Cases.
• Developed Test Plans and written Test Cases to cover overall quality assurance testing.

Environment: TOAD for Oracle, Oracle10g/9i, PL/SQL, Unix, Sun Solaris 8.0, Shell Scripting.

Confidential, Providence RI

Oracle PL/SQL Developer

Responsibilities:

• Involved in planning, control and implementation of the DBMS using SDLC.
• Developed capacity plan for the database, estimated the table sizes.
• Worked with systems and business analysts to design requirement specifications.
• Implemented data integrity validation checks through constraints and triggers.
• Performance monitoring and tuning of SQL code.
• Responsible for creation of new user ids and setting up privileges and policies for protecting data.
• Wrote functions and stored procedures for order entry and other searching applications.
• Used Borland Delphi to establish connectivity among the various databases.
• Creation of database objects like tables, indexes and views.
• Developed packages for implementing business logic through procedures and functions.
• Developed UNIX shell scripts to automate routine tasks.
• Responsible for SQL tuning using explain plans and SQL trace facilities.

Environment: Oracle 10g, Oracle PL/SQL, SQL, UNIX, Korn Shell Scripting, TOAD, UML, ultra edit.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Responsible for the design, development and import of invoice information into Oracle Receivables.
• Created Records, PL/SQL Tables, Objects, Collections (Nested Tables and Arrays), and Error Handling.
• Complex PL/SQL procedures and functions and packages are developed to adhere to the specifications of the application.
• Responsible for customization of reports according to client requirement in key indicator report and Distribution detail report like Account Status Report, Transaction Detail Report, etc.
• Worked on Query Optimization Techniques for complex SQL Statements. Used Performance Monitor and Explain Plan for performance tuning to enhance the performance of databases.
• Created the data flow diagrams using Microsoft Vision.
• Registration of new forms, Creation of concurrent executable and concurrent programs for reports, Opening up Descriptive Flex fields.
• Written scripts to customize customer needs.
• Extensively worked in the analysis and tuning of the Application code (SQL).
• Monitor all the Production, System Test and developments boxes for any errors in the logs and fix them as needed.

Environment: Oracle8i, Forms & Reports6i, SQL Loaders, SQL, PL/SQL, SQL* Plus, Toad, HTML, UNIX.