SUMMARY

• Over 8 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of Software Development Life Cycle (SDLC) including analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines
• Experience with Data flow diagrams, Data dictionary and Database normalization theory techniques, entity relation modeling and design techniques.
• Solid experience in the development of PL/SQL Procedures, Functions, Triggers and Packages in Oracle Database to implement business logic
• Effectively made use of Table Functions, Indexes, Table partitioning, Collections, Analytic Functions etc
• Created tables, Views, Sequences, Constraints, Indexes(B* Tree, Bitmap and Function Based)
• Experience in Oracle supplied packages, Dynamic SQL, Records, PL/SQL Tables and Exception Handling, Worked extensively on Ref Cursor, Bulk Collect and External Tables
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB, UTL FILE
• Expertise in Performance Tuning and Query Optimization using various types Explain Plan, TKPROF, HINTS, Partitioning and SQL trained utilities etc
• Good knowledge of key Oracle performance related features, such as Query Optimizer, Execution Plans and Indexes, for faster execution
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Proficient in Data analysis, Data modeling, Database design, Data migration, and Business intelligence solutions.
• Expert knowledge in dimensional modeling, Star Schema modeling, Snowflake modeling, fact and dimension table design, physical and logical Data modeling using Erwin 3.5.
• Extensively worked with DataStage PX for extracting data from legacy systems to stage and then to cleanse, process and loading into data marts and data warehouse.
• Experience in using Composite Data Types in Oracle.
• Expertise in working with Oracle 11g/10g/9i, TOAD, SQL Navigator, SQL * Loader, Forms 10g/9i/6i and Reports 10g/9i/6i/for both development and customizations as per client specifications.
• Knowledge in schema structure design and involved in estimation and optimization of data storage Experience in utilizing Oracle tools and methods like the use of External Tables, Pipelined functions
• Experience in migration and data conversion from Flat File/MS Access/SQL - Server to Oracle using Oracle SQL* Loader and PL/SQL
• Good knowledge on capacity planning and assessment for huge DB applications which includes Server Hardware Capacity, Network Assessment and File System Assessment.
• Good experience in designing and implementing batch jobs for mass updates using Autosys, OpCon, Control-M
• Involved in review and Gap Analysis of Functional Requirement documents. Creation of Technical Documents and related Test Case Document
• Work closely with users to understand and prioritize business goals and information needs, then translate these needs into system requirements and design specifications;
• Refine conceptual systems design requirements into the technical design Involved in review and Gap Analysis of Functional Requirement documents. Creation of Technical Documents and related Test Case Document.
• Great learning skills to adapt the rapid changing technologies and implementing the same at work.
• Strong Analytical, Inter-personnel, Problem-solving and Proven ability to work under pressure.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g, Oracle XML DB, Oracle AIX, MS-SQL Server 2005, MS Access,.

Scripting: UNIX Shell Scripting.

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

ETL Tool: IBM DataStage8.7.

Query Tools: TOAD, SQL* Navigator, SQL* PLUS.

Operating Systems: DOS, Solaris 7.0/8.0,MVS, Windows 2000/NT/XP, Window 95/98, UNIX, LINUX 9.2/9.3.

GUI: Developer 2000, Forms & Reports 10g/9i/6i.

Packages: Micro Soft Office Suite- MS-Word, MS-Excel, MS-Power point.

Other Tools: SQL*Loader, Autosys, OpCon, Control-M, ERWIN, MS-Visio, MS Project Professional 2003.

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

Oracle PL/SQL Developer

Responsibilities:

• Interacted with Business Analysts and Users in requirement gathering, Built complex queries using SQL, wrote stored procedures using PL/SQL
• Worked in Data modeling, Data mapping and Data flow
• Involved in Requirement gathering and writing Functional and Technical documents
• Responsible for writing and modification of PL/SQL stored procedure, functions, packages and Database triggers.
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements
• Created materialized views, Inline Views & normal views where business requirements needed
• Tune the SQL queries and complex procedures to improve performance
• Created database triggers for data security & Consistency
• Involved in testing the scripts by performing Unit testing, System integration testing, Regression testing and helped them deploy from Autosys box.
• Experience in writing procedures, functions and packages for new requirements.
• Used advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for better performance
• Developed PL/SQL and web PL/SQL stored procedures
• Implemented Advanced PL/SQL Concepts for better performance of PL/SQL Applications
• Wrote PL/SQL backed stored procedures for database access and tuned them efficiently.
• Worked in Production Support Environment testing for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Extensively used EXPLAIN PLAN utility to leverage SQL queries.
• Performance tuning of Oracle Databases and User applications.
• Monitoring the schedules and timely escalations to the project management and client in case of any slippages
• Involved in Unit Testing for the application.
• Good understanding of Oracle Data Dictionary and Normalization Techniques.
• Involved in solving day-to-day problems, giving support to the users.

Environment: Oracle11g, TOAD, SQL, PL/SQL, Oracle Developer Suite, SQL*Loader, Autosys, Forms10g & Reports10g, XML, KORN Shell Scripts, Windows XP, ERWIN.

Confidential, Poughkeepsie, NY

Oracle PL/SQL Developer

Responsibilities:

• Worked in all major phases of project life cycles, project planning, customer interaction and gathering requirement specification
• Created Stored Procedures, Functions, and Triggers to maintain various business rules.
• Extensively worked towards optimizing the Queries to enhance the performance.
• Analyzed Indexes on regular basis.
• Created and maintained Database Objects (Tables, Views, Indexes, Sequences, Database triggers, stored procedures).
• Developed SQL* loader scripts to load data in the custom tables.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries for various reports.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Developed and optimized of SQL queries using TOAD Explain Plan utilities
• Tuned SQL queries and performed refinement of the database using tools like EXPLAIN PLAN and TKPROF to significantly improve the system response, time and efficiency
• Run batch jobs for loading database tables from flat files using SQL* Loader
• Used Version Control tools like TFS for Source Control
• Stored data in the audit log tables using the old and new column attributes
• Performed debugging of the PL/SQL codes using the DBMS OUTPUT
• Developed Materialized views and Ref Cursors for reporting purpose
• Developed test plan documents for all back end database modules
• Defined indexes on various tables to improve the performance of the queries for reporting purpose.
• AUTONOMOUS TRANSACTION PRAGMA is used in the framework procedures to log the status when error occurs.
• Thoroughly involved in all the phases of testing UNIT TESTING, PERFORMANCE TESTING and BUG FIXING etc.
• Successfully managed the various structures of Oracle Database including performance monitoring, database security, user management, and backup/recovery techniques
• Worked closely with users and developers team to resolve issues in the developed reports

Environment: Oracle 11g, TOAD, SQL, PL/SQL, SQL*Plus, SQL* Loader, XML, Windows XP,MS-Excel,, Solaris 10, DataStage8.6, Reports Builder 9i.

Confidential, Columbus, OH

Oracle Developer/Designer

Responsibilities:

• Coordinated with clients, Requirements gathering and designing
• Created database objects such as tables, views, indexes, sequences using Oracle 10g
• Was involved in Requirements gathering and system analyzing phase.
• Participated in weekly status meetings and presentations.
• Written and tuned SQL Queries, PL/SQL Stored Procedures, Functions and Triggers
• Actively participated in Designing and implementing the system.
• Preparing Detailed Analysis Document and Test Plans.
• Design and Development of Application Services and Data Access Layer components
• Created DDL scripts to create, alter, drop tables, views, synonyms and sequences.
• Used Toad for developing PL/SQL code.
• Creation of all Stored Procedures for the Data Access Layers.
• Involved in writing Test Cases and Test Scripts.
• Implemented User Acceptance testing.
• Created batch jobs using shell scripting to automate the process of cleansing data and loading data to the system and sending weekly reports to users.
• Coordinate Production / QA release activity.
• Wrote UNIX Shell scripts to automate Batch Jobs.
• Loading data from flat files into to database tables using SQL* loader.
• Automating data loading, extraction, report generation using UNIX shell scripting
• For Optimization Process actively involved in performed database capacity planning created materialized views, partitions, tables, views, indexes etc as Tuned optimized SQL statements.
• Applied heavy formatting for reports and developed reports with necessary formulas and parameter fields and exported these reports to various formats.
• Extensively worked with SQL scripts to validate the pre and post load data.
• Create and schedule jobs as per new requirements, if any, support existing jobs.

Environment: Oracle 10g, TOAD, SQL, PL/SQL, UNIX, SQL*Loader, Control-M, KORN Shell Scripting, Export, Import, ETL.

Confidential, Plano,TX

Oracle Developer

Responsibilities:

• Extensively worked on Performance tuning by using Explain plans and various hints
• Worked on table partitioning (Range and List) and deploying local indexing on portioned tables
• Involved in Extraction, Transformation and Loading (ETL) of the data in the data warehouse for Oracle 9i database
• Involved in extracting Data from the Heterogeneous databases residing on Mainframe, UNIX
• Used Oracle 9i features such as merge for various transformations
• Used UNIX Shell scripts (KORN) for Extracting and Parsing data from the files
• Used stored procedures in Oracle for retrieving the data from the database for solving complex queries.
• Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application
• Created Stored Procedures, functions and Packages in Oracle 9i using SQL and PL/SQL for the Audit Trail using Oracle 9i as backend
• Involved in writing complex scripts for Data Transformation, ETL process (Extract, Transform & Load)
• Performed the uploading and downloading flat files from UNIX server using FTP
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL)
• Worked on Performance tuning by using Explain Plan, hints and also worked on Partition tables using Range method
• This involves converting data from non XML format to XML format
• Worked on Partitioning and indexing concepts (Local and Global) indexes on partition tables
• Creating Test scripts for the generated final Reports
• Attended meetings and review to discuss current issues and processes to tackle such issues
• Used ERWIN for Logical and Physical database Modeling
• Large scale parallel processing using Oracle PL/SQL.

Environment: Oracle 9i/10g, SQL PLUS, PL/ SQL, SQL*Loader, XML, Korn Shell Scripts, Business Objects, SQL Navigator, Windows XP, MS-Excel, TOAD, Erwin

Confidential, Orlando, FL

Oracle Developer

Responsibilities:

• Involved in requirements analysis, design and development of the system
• The project involved detailed design using E-R Diagrams and Data Flow Diagrams
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements
• Loaded data from flat files into database tables using SQL* loader
• Created screens using HTML and JSP,Servlets
• Wrote complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse
• Tuned SQL queries an performed refinement of the database using tools like EXPLAIN PLAN, and TKPROF to significantly improve the system response, time and efficiency
• Developed stored procedures, functions and packages for updating, inserting and deleting data from the tables
• Developed forms, menus, Object libraries and PL/SQL libraries using Oracle Forms 9i
• Used Oracle Reports 9i to develop daily, weekly and monthly reports for customer details, products supplied, inventory information and details of customer complaints
• Worked on Business Objects (BO) to deploy various reports
• Involved in Unit level testing, Module level testing and System level testing
• Documented the whole process flow, PL/SQL Packages, log files, locations and description, log tables and possible error messages, process codes and description
• Detected and corrected bugs during system integration and user acceptance testing

Environment: Oracle9i/10g, SQL, PL/SQL, HTML, JSP, Servlets, SQL*Loader, Forms 9i/10g, Reports 9i/10g, MS Visio, Business Objects, SQL*Loader

Confidential

Database Developer

Responsibilities:

• Prepared program Specification for the development of PL/SQLprocedures 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
• Developed PL /SQL code for updating payment terms
• Created indexes on tables and Optimizing Stored Procedure queries
• Design, Development and testing of Reports using SQL*plus
• Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions / enhancement on oracle application
• 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/10g,PL/SQL, SQL*Loader, SQL Navigator, SQL*Plus, UNIX, Windows NT 4.0/2000/XP Windows2000