SUMMARY

• Over 8+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using teh Oracle Relational Database Management System (RDBMS).
• Involved in all phases of teh SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Client - Server application development using SQL, Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS. IN UNIX,AIX UNIX, LINUX AND WINDOWS ENVIRONMENT.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Excellent experience in Designing, Maintaining and tuning various RDBMS like T-SQL & MS SQL Server 2005/2008/2008 R2/2012 and MS Access databases.
• Proficient in writing and implementing SQL Queries (DDL, DML, DCL), Stored Procedures, Views, Triggers and Cursors in Oracle database.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.Netezza database administration noledge.
• Expertise in handling errors in PL/SQL program using Exceptional Handlers.
• Experience in Dynamic SQL, Exception handling and Analytical Functions.
• Experience in database development and hands on experience working on various database activities like Tables, Views, indexes, sequences, materialized views, nested tables, types, Bulk Collect Functions, Procedures, Packages and Triggers.
• Excellent expertise in writing different types of SQL queries like Sub queries, Hierarchical and co related sub queries along with set operators.
• Extensive usage of Oracle collections and standard API’s like DBMS LOB, UTL FILE etc. for business logic in user defined API’s.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of Confidential team.

TECHNICAL SKILLS

Database: Oracle 11g/10g/9.x/8i/7.x, SQL Server 6.5/7.0, MS Access 7.0, DB2 8.0

Operating System: MS-DOS, Linux, UNIX, Windows XP/ NT/2000/ME

Languages/Utilities: SQL, PL-SQL, C, C++, Java, UML, UNIX shell scripting

Web Technologies: HTML, Java, JDBC, EJB, Servlets, XML, JSP,Python

Tools: Oracle Forms9i/6i/4.5 and Reports9i/6i/3/2.5, APEX, SQL*Plus, SQL*Loader, Toad, InformaticaPowerCenter/PowerMart5.1/6.1/6.2, Erwin, Actuate, Designer2000, Discoverer3x/4x, Autosys, MSOffice.

PROFESSIONAL EXPERIENCE

Confidential, Montvale, NJ

Oracle Forms Developer

Responsibilities:

• Gathering teh requirements from Business analysts for MHS to Retail Merchandise system conversion implementation.
• Developed New Interfaces using PL/SQL packages, Data migration,Business Intelligence,Procedures, Functions and triggers as per teh requirement.
• Experience with data modeling techniques, including 3rd normal form, dimensional data models, star/snowflake schemas, etc.
• Created Databse tables, Views, synonyms, indexes, sequences and database directories.
• Used External tables and Sql loader to load files into database staging tables.
• Developed New Forms for teh Warehouse Inventory Management using Oracle forms 10g.
• Customizing Purchase order and Receipts history forms for inventory status.
• Developed and tested UNIX shell scripts to call teh PL/SQL packages and ftp teh reports to client server.
• Worked on performance tuning and testing of Oracle PL/SQL Packages, procedures and triggers of various applications.
• Created/Modified Indexes as necessary to increase teh performance and Data migration.
• Used Hints, Joins and advanced SQL Programming techniques like analytical techniques and WITH statement to increase teh performance of teh reports.

Environment: Oracle11g/10g,.NET,PL/SQL, UNIX, Oracle Forms10g, TOAD,Tableau, SQL*Loader, External Tables, PVCS, Performance tuning, Unix shell scripting, Windows XP.

Confidential, Columbus, OH

Oracle Developer

Responsibilities:

• Interacted with teh business users, collected teh business requirements and analysed it based on Software Development Life Cycle standards.
• Worked with teh Business Analyst to define business needs and delivered teh comprehensive technical specifications.
• Modified teh database, added new tables, and views to accommodate Confidential new functionality as per teh user requirements.
• Involved in load processing of teh external client eligibility file into database tables using sql loader.Experience with data modeling techniques, including 3rd normal form, dimensional data models, star/snowflake schemas, etc.
• Created and modified pl/sql programs, packages and procedures for specific client load program.
• Optimized and tuned PL/SQL reports to reduce teh load process and Data migration.
• Automating data loading, extraction and report generation using UNIX shell scripting.
• Used Quality centre and RTC (Rational team concert) for project management, planning, process track and project reporting.
• Developed batch programs using UNIX shell scripts to generate daily, weekly & monthly ATP reports
• Used Maestro scheduling tools to schedule and run Oracle Batch jobs.
• Performed teh uploading and downloading flat files from UNIX server using FTP.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Worked on application development projects as well as enhancements and maintenance of existing applications in Business Itelligence.
• Used Subversion for check in and checkout of source code from Tag, branch of teh svn repository.Experience with .NET, Crystal Reports, and Team Foundation Server
• Conducts code reviews of application components developed by other staff for standards adherence, efficiency and use of best practices.
• Performed performance tuning of ATP reports using optimization techniques and hints.
• Modified Join queries for effective cost optimization and used bulk collections for better performance.
• Supported operations during teh build/deployment of Confidential new release to teh Integration, QA and Production environments.
• Performed Unit test, System integration test to make sure teh deliverables are match with business requirement.
• Responsible for handling production support tickets and defect fixing.

Environment: Oracle 9i/10g, SQLPLUS, PL/SQL, UNIX, SQL*Loader, Quality Centre, Lotus Notes, Tortoise Subversion, Maestro,ETL, JAVA,RDBMS, Performance tuning, UNIX shell scripting, Windows XP, Solaris and HP-9000.

Confidential, Mason, OH

Oracle Lead developer

Responsibilities:

• Designed and Modified Database tables, Keys, Indexes, Triggers, Oracle Packages, Procedures and Functions.
• Extracted, Transformed and Loaded OLTP data from sources like Delimited Flat files into teh Staging area and transformed teh data according teh business requirement and then Loaded into teh Oracle Database
• Involved indeveloping and maintaining teh sales data mart for Data warehouse.
• Designed and developed Load programs and packages usingPL/SQL.
• Involved in creatingpartitioning,indexeson partitions to improve teh performance of data warehouse tables.
• Extensively involved inperformancetuning SQLscripts.
• Usedexternal tablesfor Data Conversions and to load teh flat files from other different sources.
• UsedExplain Plain and hintsfor performance tuning.
• Involved inunit testingof teh packages and developed objects.
• Modifiedshell scriptsfor executing batch jobs.
• Reviewed data transformation rules and provided technical suggestions in data transformation logic.

Environment: Oracle9i, PL/SQL, DataWarehouse, TOAD, RDBMS,ETL,Apex, External tables, Shell Scripting, Unix, and Windows.

Confidential, New York

Oracle Developer

Responsibilities:

• Designed and implemented teh login management tables.
• Implemented Security by creating different Users, and assigning Roles to Users.
• Involved in Design and Development of data entry screens.
• Created Data Structures including Tables and Views, and applied referential integrity.
• Participated in designing of data conversion/interface with teh use of SQL*Loader, and Open Interface.
• Experience with data modeling techniques, including 3rd normal form, dimensional data models, star/snowflake schemas, etc.
• Created Form level objects i.e. Libraries, property classes,Telcom.
• Created Triggers, Stored Procedures, Packages, Data migration and SQL Scripts.
• Developed SQL*loader scripts to load data in teh custom tables.
• Create stored procedures using dynamic SQL based on J2EE user parameters.
• Developed PL /SQL code for updating payment terms.
• Developed UNIX shell scripts for extracting data from flat files and loading them using SQL loader,importing and exporting databases.
• Responsible for loading and processing client data feeds into an Oracle 8i database using Perl.
• Developed contact database application using Perl scripting.
• Created and tested numerous Reports using Actuate reporting tool.
• Involved in documentation of User requirements and Testing of developed modules in Business Intelligence.
• Worked in teh Production Support team and fixed high priority bugs.
• Developed SQL scripts to create database tables, synonyms, sequences, and also created users, roles, and granted privileges to them.

Environment: Oracle 10g, Java, TELCOM,ETL,RDBMS,Developer/2000,Actuate, PL/SQL, Shell scripts, Perl, SQL *Loader, Unix and Windows 2003

Confidential

Oracle Developer

Responsibilities:

• Design, configure and plan run of performance tests, collect performance data, profile teh code, design architecture and change code to improve performance, implement code changes or work with other developers to implement changes as appropriate.
• Applied Database Tuning and Optimization, Normalization in teh new database design.
• Proposed SQL Tuning within applications for optimized database access.
• Wrote Queries, Stored Procedures, functions and triggers.
• Monitors and tracks quality related issues and problems through to resolution.
• Creation of users, roles, schemas, tables, indexes etc.
• Wrote programs in Forms 6i (Developer 2000).
• Created reports & maintained other existing programs.

Environment: Oracle 9i, Oracle Reports 6i, Oracle Forms 6i, PL/SQL.