SUMMARY:

• About 8 years of experience in Application Development using Oracle SQL and Oracle PL/SQL
• Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
• Strong Knowledge on Oracle Architecture and Database Design.
• Excellent conceptual knowledge of Oracle 10g/11g, PL/SQL and SQL.
• Experience in Database design using Normalization and E/R Diagrams.
• Experience in writing SQL Queries, Views, Materialized Views, PL/SQL Procedures, Functions, Packages, Triggers, Cursors, Collections, Ref Cursor, Cursor variables, System Reference Cursor, Dynamic SQL, Exceptions.
• Experience in designing business requirements and modeling using oracle designer.
• Experience in developing External Tables, Joins, Indexes and sequences.
• Experience in query optimization, performance and tuning PL/SQL using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Experience in Use of Exception Handling methods along with Pragma Exception init in order to associate our own created exception names.
• Experience in using several built-in database packages such as DBMS JOB, DBMS OUTPUT, UTL MAIL, UTL FILE, and DBMS SQL to name a few.
• Experience in using DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance.
• Expertise in loading data from legacy systems using SQL Loader.
• Good knowledge in front end development using Oracle Forms/Reports6i/9i/10g.
• Experience in Deploying Forms and Reports on the web.
• Experience in Developing Forms based on Views, Tables and Procedures in tabular and form layouts.
• Experience in developing both Web Layout and Paper Lay out Reports in various styles based on the user requirements.
• Extensively worked with third party database tools like TOAD PL/SQL Developer.
• Strong knowledge of Extraction Transformation and Loading ETL processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Experience in customizing OBIEE dashboards and reports.
• Experience in writing Technical Design Documents and Developing Unit Test Documents.
• Good knowledge in Java, PERL, HTML, XML.

Tools:

• Languages: PL/SQL, SQL, Java, SAS, Perl
• Web Technologies: HTML, JavaScript, JSP, CSS, XML
• Database Environments: Oracle 8i/9i10g/11g
• Tools: Oracle Forms/Reports, JDeveloper, Oracle Application Express, SQL plus, SQL Navigator, SQL Developer, Eclipse, Exceed, Adobe Web Premium CS3, Macromedia Dreamweaver, Oracle Enterprise Manager
• File Transfer Tools: FTP, Putty, Humming Bird, WinSCP
• Software: Microsoft Office Excel, Word, Power Point, and Access , Visio
• Operating Systems: Unix, Solaris, Windows

Experience:

Confidential

Sr. Oracle Developer

Responsibilities:

• Gathered and documented business requirements. Created the initial conceptual design, entity relationship diagrams and database objects
• Worked in fast paced Agile/SCRUM environment, with good interaction with Project managers, business analysts and QA team to understand and implement business rules and to ensure that defects are rectified in a timely manner.
• Involved in designing ER diagram to set the logical and physical relationships of database.
• Created database objects like Tables, Sequence, Synonyms, Views, Materialized Views, Indexes and Collections.
• Developed stored procedures for various validations while inserting data into the tables and developed PL/SQL packages for incorporating the business rules.
• Used cursors, Ref Cursors and Exceptions in developing packages, procedures and functions.
• Used UTL FILE to read and write files that are located on the server optimized the performance using PL/SQL table types and record types.
• Optimized and tuned PL/SQL programs to reduce the loading process Utilized SQL Loader to perform bulk data loads into database tables from external data files.
• Loaded the data into database tables using SQL loader from text and excel files.
• Developed slowly Changing Dimension Mapping for Type1 and Type2.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Developed Tivoli Work Load Scheduler TWS scripts and deployed to Tivoli Job Scheduling Console JSC to automate the jobs.
• Responsible for creating Information Technology Service Management ITSM / Work Request Management WRM requests and working with Application Operations team for promoting the code to UAT and Production regions.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 6i and Oracle Forms builder 6i respectively.
• Created SQL plus reports as per client's various needs, and developed business objects.

Environment: Oracle 11g, UNIX, WinSCP, Putty, Tortoise SVN, Tivoli Workload Scheduler TWS , PL/SQL, SQL Developer, SQL Plus, Teradata SQL Assistant, Asset Repository Management ARM .

Confidential

Sr. Oracle Developer

Responsibilities:

• Responsible for gathering business requirements from clients, prepare the Business Requirement Specification document, User Manuals and Application Support Guides.
• Worked in fast paced Agile/SCRUM environment, with good interaction with Project managers, business analysts and QA team to understand and implement business rules and to ensure that defects are rectified in a timely manner.
• Worked Closely with Data Architect to design and create scripts for objects such as tables, indexes, views, sequences, object types, collections.
• Involved in creation of database objects like tables, views, materialized views, indexes, constraints, synonyms, sequences and Database Links using Oracle tools like SQL plus, SQL Developer.
• Involved in writing and managing PL/SQL stored procedures, functions, triggers and packages to meet the business requirements and update the existing objects based on change requests.
• Writing complex SQL Queries using joins, sub queries and inline views to retrieve data from the database.
• Developed complex PL/SQL packages to load, update, insert into the large databases using features such as implicit/explicit cursors, bulk collect and bulk limit.
• Developed Tivoli Work Load Scheduler TWS scripts and deployed to Tivoli Job Scheduling Console JSC to automate the jobs.
• Responsible for creating Information Technology Service Management ITSM requests and working with Application Operations team for promoting the code to UAT and Production regions.
• Conducted review meetings and walkthroughs to discuss the status of the project and for change requests.
• Creates scripts for Validating extracted data from Legacy systems before loading into target system.
• Created SQL Loader scripts to load data into the temporary staging tables.
• DBMS developments include building data migration scripts using oracle SQL Loader and UTL packages.
• Used shell scripts and Perl scripts for automating the processes.
• Wrote shell scripts for calling functions to automate the loading and extraction process from legacy system.
• Performances tuning using Explain Plan, TKPROF and Stats Pack.

Environment: Oracle, UNIX, WinSCP, Putty, Tortoise SVN, Tivoli Workload Scheduler TWS , PL/SQL, SQL Developer, SQL Plus, Teradata SQL Assistant, Asset Repository Management ARM .

Confidential

Sr. Oracle Developer

Responsibilities

• Interacted with Business Analysts and Users in requirement gathering Built complex queries using SQL and 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.
• Used advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance
• 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.
• 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.
• Provided 24/7 on call production support.

Environment: Oracle 10g, 11g, TOAD, PL/SQL, Explain Plan, SQL including ANSI standard, UNIX

Confidential

Sr. Oracle Developer

Responsibilities:

• Designed ER diagram using Erwin, to set the logical and physical relationships of database.
• Created database objects like tables, views, materialized views, indexes, constraints, synonyms and sequences to meet business requirements
• Developed PL/SQL procedures, functions, packages and triggers based on business logics to facilitate the functionality of various modules.
• Created database triggers for Audit module for various tables in the system.
• Developed PL/SQL triggers to monitor the database activities.
• Developed and optimized of SQL queries using SQL Navigator Explain Plan utilities.
• Maintained all the database environments like Production, Testing, Development and staging databases.
• Created and maintained database objects, roles, users and granted roles to application users.
• Extensively worked on developing KORN shell scripts for scheduling the jobs using Cron jobs.
• Performed code reviews to ensure coding standards are followed.
• Provided administrative support and system usage to the users on daily basis in the Production environment.
• Involved in Troubleshooting Performance issues and bugs within packages and stored procedures using dbms output and Explain Plan.
• Performance of the queries is enhanced by executing optimization techniques such as Index Creation, Table Partition and Coding Stored Procedures.
• Responsible for management of the queries, enhancements, production support service issues and release management process.
• Develop and maintain the documentation to support the team and business.
• Designed, developed and documented oracle forms and reports in 10g/11g.
• Responsible for the modification/enhancements/maintenance in the existing forms and reports to established standards and the deployment to production environment.
• Involved in creating Interactive and SQL reports using Oracle Application Express.
• Performed Unit level and System level testing process of the entire application.
• Refreshed Development/Testing databases with Production database.
• Involved in documenting user requirements, technical specifications, release notes, training materials reporting manuals and work flow diagrams.

Environment: Oracle 10g/9i, Forms, Reports, PL/SQL, SQL Navigator, Oracle Enterprise Manager, Exceed, Humming Bird, JSP, Java Script, HTML

Confidential

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.
• 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.
• Prepared the procedures to update the internal structures to reflect the newly loaded data.
• 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 8i/9i, TOAD, SQL Navigator, ER-Win, Sybase, UNIX Shell Scripting.