SUMMARY

• Over 9 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.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Shell Programming (Bourne, Korn), C, C++, JAVA.

Databases: Oracle 8.0, 8i, 9i, 10g, MS Access, SQL SERVER 2000.

Reporting Tools: Crystal Reports 9.5, oracle reports 10g, 9i, forms 10g,9i.

Tools: ERWIN 4.0, Oracle Enterprise Manager, TOAD 8.5, Oracle SQL, Developer, Database Configuration Assistant, Net Configuration Assistant, F-Secure 5.3, MS-OFFICE (2007).

DB Utilities: SQL Loader, Export / Import, Data pump, TKPROF, Stats pack.

Operating Systems: UNIX, LINUX, Sun Solaris 5.6/5.8/5.9, Windows NT, Windows 95/98/2000, Windows XP, Windows Server 2003.

Web Technologies: HTML, Macromedia Dreamweaver MX, MS-FrontPage, JavaScript, Macromedia, Fireworks MX, XML.

PROFESSIONAL EXPERIENCE

Confidential, Wilmington DE

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.
• Involved in mapping the data from one layer to another (staging, source, target mappings) as per Line of business.
• 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,9.1), WinCVS, HP Quality Center, WinSCP

Confidential, Collegeville, PA

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.
• Nzsql cmd is used to execute the select queries either directly from the cmd line or by passing a file(which consists of the sql query)
• Written shell scripts to generate a report as per Business Requirements.
• Used other NZsql cmds like \dt,\dv,\d to describe the table structure and to find the tablenames and views.
• Used GENERATE STATISTICS command to collect statistics at the table level, so that optimizer uses the efficient way to execute the query.
• 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, Wilmington DE

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, Irving TX

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, Atlanta GA

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

Confidential

Oracle Developer

Responsibilities:

• Created Korn Shell scripts which act a wrapper for various tasks like for executing the SQL*Loader command lines, for refreshing the materialized views and for updating the Fact and the Dimension tables.
• Wrote database PL/SQL Triggers and Procedures, Functions, Packages to provide backend security and data consistency.
• Involved in coding, testing and documenting various Packages, Procedures and Functions for various Libraries Stored Procedures
• Worked on user exit, Dynamic SQL and PL/SQL block in PL/SQL.
• Responsible to maintain the dependencies of all Procedures, Function, Packages, Views and Triggers in a Script file.
• Developed Java Server Pages, Servlets that interact with back end Oracle Database.
• Implemented complex business rules with the use of integrity constraints and Database Triggers also Handled Exceptions.
• Worked on Power Builder tool for drawing user interfaces, reports and accessing the web content.

Environment: Oracle 7.3, SQL, PL/SQL, SQL*Loader, Windows98, UNIX Shell Scripting, Java, Java Server Pages, Servlets, Apache Web server, Power Builder