SUMMARY

• Over 7 years of programming experience as an Oracle PL/SQL developer and Forms/Reports Developer.
• Excellent knowledge in Analysis, Design and implementation of Business Applications using Oracle Relational Database Management System Oracle RDBMS .
• Have good experience in writing PL/SQL scripts for the database objects like tables, views, procedures, functions, packages, database triggers, indexes and sequences, Flashbacks.
• Good knowledge of ERWIN for Data modeling to design the logical model, physical model, Entity relationship.
• Good experience in generating forms using PL/SQL for data validation, processing Oracle Forms 9i/10g and also generating reports in Oracle Reports 9i/10g.
• Written Perl routines to handle daily requests and processes from users
• Expertise in using Oracle 8i/9i and 10g databases and knowledge about PL/SQL programming to develop stored procedures and packages.
• Expertise in using advanced features of Oracle 9i for PL/SQL programming like Varrays, Dynamic SQL, Query Optimizer, Nested Loops, External Tables, Nested Tables, LOBS.
• Used Hints for better performance of the queries and any procedures.
• Very Good Knowledge about the Oracle tools like SQL, PL/SQL, SQL PLUS, Oracle Enterprise Manager, SQL Loader, and data pump utilities like Export/Import.
• Experience in application fine-tuning and database fine-tuning using Explain Plan and TKProf.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.
• Good knowledge of using Flashbacks to recover the data from recycle bin.
• Expertise in all phases of the Software Development Life Cycle SDLC including analysis, Physical and Logical design, Resource Planning, code development, testing, implementing and maintenance
• Expert in creating special Grouped reports, Cross Tab / Matrix Reports, Sub reports in main reports, Drill Down reports, mailing reports using Crystal reports.
• Good knowledge of creating database links and materialized views.
• Good knowledge in design, coding and testing.
• In addition to excellent technical abilities possesses strong oral and written communications skills, analytical and interpersonal skills.

Professional Experience

Confidential

Tech Lead/Oracle/ETL developer

Responsibilities:

• Worked as a Tech Lead for couple of projects.
• Involved in approving SDLC aritifacts. SIT plan,DESIGN,Requirements,SOL REVIEW
• Wrote complex SQL queries to retrieve information from the databases depending on user requirement and used appropriate joins.
• Used Sql Loader ETL Extensively for loading files ASCII into Database tables.
• Developed complex packages and procedures and functions using Record types.
• Worked on SQL Tuning using Explain Plan. Tuned SQL Queries and plsql objects.
• Used Analytic function Over partition by order by clauses for calculations along with RANK.
• Worked with AVG, ROWNUM,TRIM,LPAD,RPAD and some other Aggregate functions for performance and data matching .
• Created PL/SQL packages to perform validations on the imported data from legacy system.
• Created Views and Synonyms for the database objects.
• Assisted the QA team in performing Load Testing and Performance Testing.
• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
• Created PL/SQL packages to perform validations on the imported data from legacy system.
• Involved in Data modelling to come up with physical and logical models to create table and establish the entity relationship using ERWIN.
• Analyzed integrity constraints during development of physical model using ERWIN.
• Developed complex packages and procedures and functions using Record types.
• Worked on Datastage tool and used Plsql Frameworks to implement ETL concepts File loading to tables .
• Worked on priority levels tasks using Unicenter Service Desk software.
• Good knowledge of control-M jobs.
• Extensively used Execute Immediate for building the Dynamic Sql based on the parameters passed.

Environment:

Oracle 10g/11i, SQL, PLSQL Packages, Procedures, Functions and Triggers,ERWIN, TOAD, Unix, Data stage 7,8.1,8.7 , WinCVS , HP Quality Center, WinSCP

Confidential

Plsql/Netezza developer

Responsibilities:

• Worked on Framework called QBM Query Builder Merge internal to IMS.
• Created PL/SQL packages to perform validations on the imported data from legacy system.
• Attended Business meetings and walkthroughs to discuss the status of the project.
• Written shell scripts to generate a report as per Business Requirements.
• Written shell scripts to send an email after the job Failure or Success.
• Worked on the Config properties file to set up the database connection and changed accordingly to reflect the same in the code.
• Assisted the QA team in performing Load Testing and Performance Testing.
• Created PL/SQL packages to perform validations on the imported data from legacy system.
• Scheduled jobs using Mainframe Code.
• Good knowledge of Mainframe jobs.
• Extensively used Execute Immediate for building the Dynamic Sql based on the parameters passed.

Environment:

SVN,Netezza, Mainframe,Oracle 10g/11i, SQL, TOAD, Unix.

Confidential

Oracle/ETL developer

Responsibilities:

• Wrote complex SQL queries to retrieve information from the databases depending on user requirement and used appropriate joins.
• Created PL/SQL packages to perform validations on the imported data from legacy system.
• Developed complex packages and procedures and functions using Record types.
• Worked on SQL Tuning using Explain Plan.
• Created Views and Synonyms for the database objects.
• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
• Assisted the QA team in performing Load Testing and Performance Testing.
• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
• Wrote complex SQL queries to retrieve information from the databases depending on user requirement and used appropriate joins.
• Created PL/SQL packages to perform validations on the imported data from legacy system.
• Involved in Data modelling to come up with physical and logical models to create table and establish the entity relationship using ERWIN.
• Analyzed integrity constraints during development of physical model using ERWIN.
• Developed complex packages and procedures and functions using Record types.
• Got familiar with Datastage tool and WinCVS.
• Worked on priority levels tasks using Unicenter Service Desk software.
• Good knowledge of control-M jobs.
• Extensively used Execute Immediate for building the Dynamic Sql based on the parameters passed.
• Environment:

Oracle 10g/11i, SQL, PLSQL Packages, Procedures, Functions and Triggers,ERWIN, TOAD, Unix, Data stage , WinCVS , HP Quality Center

Confidential

Oracle Developer/Reports developer

Responsibilities:

Involved in requirement gathering and development of the application.

Involved in migrating all the database objects Tables, Views, Triggers, Procedures, Functions, Packages from 10g to 9i.

• Involved in migrating Oracle Forms from 10g to 9i

• Involved in migrating all the UNIX shell scripts from one server to another.
• Generate SQL scripts for altering, inserting, creating the tables.
• Created Views and Synonyms for the database objects.
• Assisted in scheduling the everyday activity of data purging using CRON jobs.
• Migrated forms from one server to another using the version control tool VSS Microsoft Visual Source Safe .
• Used the WITH clause to rewrite the Sql query for faster Performance.
• Performed debugging of the PL/SQL codes using the DBMS OUTPUT.
• Performed debugging in Oracle Forms using MESSAGE.
• Extensively used 'vi' editor in UNIX.
• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
• Worked with the team members in developing the Test Plan and Test cases for Unit testing for validation of the code.
• Assisted the QA team in performing Load Testing and Performance Testing.

Environment: Oracle 9i/10g, SQL, PLSQL Packages, Procedures, Functions and Triggers, TOAD, Unix.

Confidential

Oracle Programmer Analyst

Responsibilities:

• Involved in requirement gathering and development of the application.
• Wrote complex SQL queries to retrieve information from the databases depending on user requirement and used appropriate joins.
• Created PL/SQL packages to perform validations on the imported data from legacy system.
• Developed complex packages and procedures and functions using Record types.
• Used UTL FILE to import the data from database tables to flat files.
• Used External Tables for Data Conversions to populate the data from spreadsheets to a base table.
• Created a DBMS SCHEDULER job to write the data from a table to a flat file on a daily basis.
• Worked on SQL Tuning using Explain Plan.
• Worked with Analytical functions like OVER, LAG, LEAD, PARTITION BY and familiar with the MODEL, RANK etc.
• Extensively used Strong Ref cursors for manipulating the large amount of data and reducing the coding and error margin and wrote some scripts in UNIX.
• Good familiarity with the concepts of partitioning the database and Materialized Views.
• Good knowledge of data model design Logical data Model and Physical data Model , Star Schema and Snowflake schema.
• Extensively used Execute Immediate for building the Dynamic Sql based on the parameters passed.
• Created Views and Synonyms for the database objects.
• Used the WITH clause to rewrite the Sql query for faster Performance.
• Created indexes on some of the columns on the tables to increase the application's performance.
• Developed Landscape and portrait Reports using Oracle Reports 10g.
• Created Tabular reports, Group Above reports for the Clients as per the requirement.
• Generated Spread Sheet, XML, PDF format reports.
• Attended review meetings and walkthroughs to discuss the status of the project and for change requests.
• Assisted the QA team in performing Load Testing and Performance Testing.

Environment: Oracle 9i/10g, SQL, PLSQL Packages, Procedures, Functions and Triggers, Oracle Forms and Reports 6i,9i,10g SQL Loader, HTML, CSS, Java scripts, TOAD