SUMMARY

• Around 8 years of experience in analysis, design, development, testing and implementation of application software as Oracle PL/SQL developer.
• Expertise in SQL and PL/SQL programming and strong Knowledge on oracle architecture and database design.
• Solid experience in vertical segment Retail, Banking, Financial management system and Health Care.
• Expertise in using tools such as TOAD, SQL developer, PL/SQL developer.
• Strong knowledge of Oracle 9i/10g/11g, PL/SQL.
• Oracle Import/Export Utilities &SQL*Loader.
• Strong understanding of Data modeling in data warehouse environment such as star schema and snow flake schema.
• Experience in Migrating Data to Oracle database.
• Excellent Analytical, conceptual and root cause analysis and problem solving skills.
• Strong Experience in designing and developing oracle objects Tables, Views, Indexes PL/SQL Packages, Functions, Stored Procedures, and Triggers.
• Strong knowledge in Oracle Cursor management, Exception Handling, REF Cursors
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Collections, Nested Tables, VARRAYS, Records, Types, and Dynamic SQL and Analytical functions.
• Experience as an Applications DBA including creating and managing schemas, tables, constraints, indexes, and materialized views and managing database.
• Experience in PL/SQL collections, Bulk collections and Exception handling.
• Extensively worked with various SQL scripts for relational databases.
• Experience in Oracle Application server for teh Forms and Reports, Crystal reports application in various projects.
• Extensively worked on PL/SQL features like Forms, Triggers, Data blocks, Report Layout, Parameter forms, Report Triggers.
• Experience in designing and developing various reports using Oracle Reports
• Good understanding of Oracle Data Dictionary, RDBMS and Normalization techniques.
• Experience with database query optimization and performance tuning using Explain Plan, SQL - Trace, TK-Prof oracle utilities and creating relevant system and users documentation
• Extensively worked on Triggers for implementing complex data integrity checks and for auditing tables.
• Experience in Database modeling and database object definitions using tools like Oracle Designer.
• Experienced in Unit testing and Integration Testing with excellent debugging skills.
• Developed and Modified PL/SQL packages, functions, Procedures as per customer requirement to make new enhancements or to resolve problems.
• Worked on Agile methodologies
• Worked with SQL QUIRES advanced DML and DDL
• Strong knowledge in oracle apps modules, Finance(AP,AR,GL) and SCM (PO,OM,INV)
• Working experience in data extraction, transformation and loading operations into oracle using SQL Loader, Export/import and UTL FILE to read and write teh files.
• Ability to program UNIX shell scripts in applications dat schedule, validate flat file data, execute SQL, archive files or FTP files.
• Great Team player with Strong interpersonal skills, communication skills and documentation skills

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Java, SQL Server

Scripting Languages: Unix Shell Scripting

Markup Languages: XML, XSLT

XML Technologies: XML, XSL (XSLT, XPATH)

Database: Oracle 12c, 11g, 10g, 9i

Database Tools: Toad, SQL Developer, PL/SQL Developer, SQL * Plus

Version Control: Poly Version Control System(PVCS)

Reporting and oracle Tools: RDF Reports 6i/9i/10g/11g,XML Publisher Reports, Crystal Reports and Forms 6i/9i/10g

Data Migration Tools: SQL Loader, Multiload

ETL Tool: Informatica

Operating Systems: Windows 8, Windows 7, Windows 2008/2003/2000/ NT/XP

PROFESSIONAL EXPERIENCE

Confidential, Akron-OH

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL Stored packages, Procedures, Functions, Collections, Object Types, Triggers.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
• Developed PL/SQL blocks using Collections like Nested Tables and VARRAYS, Cursors, Bulk collections and Exception handling.
• Responsible for SQL tuning and optimization using Explain Plan and optimizer hints
• Created scripts to createnew tables, views, queriesfor new enhancement in teh application using TOAD.
• Extensively worked on Physical Inventory like cleaning inventory files, creating snap shots, loading tag count adjustment between Physical Inventory and Perpetual Inventory
• Designed and developedoracle plsql reportsgenerating up to 8 reports
• Monitoring Jobs and running SQL queries to fix invalid SKU’s and fixing teh orders struck in Ecom
• Loaded teh data into database using teh SQL*Loader from various sources.
• Developed new reports (Inbound receipts, Receiving - Carton Controlled Boxes) in report2web.
• Worked on Open orders report for IORL in report2web.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Worked on scripts and createdShell Scriptsfor invoking SQL scripts various IT Requests for IMS .
• Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQL’s thorough out teh projects.
• Created packages to identify teh duplicate customer numbers and updating teh customer with new values
• Developed PL/SQL Procedures at teh database level dat were used in teh mappings through Stored Procedure Transformation.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate teh functionality for various modules.
• Extensively usedbulk collectionin PL/SQL objects for improving teh performing
• Developed UNIX shell scripts functions to convert from dos to UNIX scripts
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Worked UsedSQL*Loaderas an ETL tool to load data into teh staging tablesTest case/data preparation, execution and verification of teh test results.

Environment: Oracle/PL/SQL, Unix, TOAD, SQL*Plus, SQL*Loader, Shell Scripting.

Confidential, NY

Oracle PL/SQL Developer

Responsibilities:

• Developed various PL/SQL stored procedures and functions
• Wrote PL SQL scripts and used couple of metadata tables to do Data Profiling, Referential Integrity and Data Quality before loading data into staging area.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Implementing logical and physical data modeling with STAR schema using Erwin in Data Marts in Data warehousing.
• Knowledge in Data warehousing for creating of fact tables
• Development of teh Mappings, Lookups, reusable components, Sessions, Workflows
• Coordinated with DBA in creating and managing Tables, Indexes, Table spaces, Triggers, DB Links and Privileges
• Developed back end interfaces using PL/SQL Stored packages, Procedures, Functions, Collections, Object Types, Triggers.
• Developed PL/SQL Procedures at teh database level dat were used in teh mappings through Stored Procedure Transformation.
• Responsible for SQL tuning and optimization using Explain Plan, TKPROF utility and optimizer hints
• Utilized SQL*Loader to load flat files database tables.
• Handled various exceptions to troubleshoot PL/SQL code.
• Formulated procedures, functions and packages; ensured dat teh quality, programming and project management standards were met.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table
• Used Bulk Collect feature to improve performance.
• Created indexes on tables for fast retrieval of data.
• Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQL’s thorough out teh projects.
• Worked with SQL QUERIES advanced DML and DDL
• Used PL/SQL programming to develop Stored Procedures, Functions and Database Triggers including standard packages like DBMS SQL, DBMS XPLAN, DBMS PROFILER, DBMS JOB, and UTL FILE.
• Designing and rebuilding indexes for faster overall data processing.
• Gathering teh requirements through meetings with teh Business Users
• Tuned Report performance by exploiting teh Oracle’s built-in functions and rewriting SQL statements.
• Worked closely with end-users and team members to understand business requirements dat drive teh analysis.
• Test case/data preparation, execution and verification of teh test results.
• Responsible for documentation of all teh project developments and modulations as per teh standards defined and teh system requirements.

Environment: Oracle 11g, TOAD, SQL * Loader, Windows XP

Confidential, Waukegan, IL

Oracle PL/SQL Developer

Responsibilities:

• Developing highly complex applications using Oracle 10g database as backend with expertise in design and development of Oracle PL/SQL packages and procedures.
• Involved in teh design of Data-warehouse using Star-Schema methodology and converted data from various sources to oracle tables.
• Responsible for analyzing, Design and developing teh code logic in Oracle Forms and also worked on Oracle databases which is to develop and maintain for teh real production environments.
• Developed Packages and customized functions and Triggers based upon teh business logics.
• Participated in system analysis and data modeling, which included creating Tables, Views, Indexes, Synonyms, Triggers, Functions, Procedures, Cursors and Packages.
• Utilized SQL*Loader to load flat files into database tables.
• Created PL/SQL based ETL process to transfer data from sources.
• Used PL/SQL developing to load data from teh source table to teh target table based on teh business logic.
• Developed conversion programs to bring Legacy details into Oracle table using SQL*Loader, PL/SQL Package and populated data into base tables.
• Created PL/SQL blocks using Cursors, REF Cursors, Collections - Nested Table, various Complex Triggers
• Designed and developed Web-enabled Oracle Forms & Reports.
• Worked on Forms Triggers, Alerts, Data Blocks, LOVs, Parameters and Program Units by using PL/SQL procedures and functions
• Analyzed data, designed and developed Oracle forms, layout, report triggers, parameter form, data models
• Developed complex triggers in reports before/after for validation of user input on teh application system.
• Developed UNIX shell scripts to provide a user interface to Oracle Forms and Reports.
• Worked on Oracle Web Apache Server for configure of upload and download with teh required Oracle forms refers to a class of systems dat facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing.
• Tested teh Forms, debugged and fixed it after teh testing
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into teh database.
• Responsible for performance tuning activities in oracle.
• Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business Analyst.
• Worked and developed different forms and reports

Environment: UNIX, oracle forms10g,oracle Reports, Oracle Database 10g, TOAD,PL/SQL, Oracle Developer Suite 10g, PUTTY.

Confidential, SCOTTSDALE - AZ

ORACLE DEVELOPER

RESPONSIBILITIES:

• Designed and developed teh interface program to Import item master using SQL*Loader,
• PL/SQL package and Import through Concurrent program.
• Involved in customization of Oracle Forms, Oracle Reports.
• Created views, procedures, and functions, packages in teh Oracle Database using PL-SQL, SQL/PLUS, and TOAD.
• Designed and developed several mappings to load data from Source systems to ODS and tan to Data Mart.
• Involved in teh design of Data-warehouse using Star-Schema methodology and converted data from various sources to oracle tables.
• Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
• Used Materialized Views in order to improve teh performance.
• Worked on queries using SQL and wrote stored procedures using PL/SQL in Various API’s in Java, Oracle and Access.
• Experience with ETL involving large amount of data, in particular XML parsing and loading into Oracle, Oracle XML Packages.
• Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
• Worked with SQL QUERIES advanced DML and DDL
• Test case/data preparation, execution and verification of teh test results.
• Responsible for documentation of all teh project developments and modulations as per teh standards defined and teh system requirements.
• Made Forms customization on various existing forms.
• Developed many complex reports using Oracle Reports 6i
• Maintained and developed user requested features to a web based Warehouse Catering
• Designed and developed front-end applications using Oracle Forms 6i.
• Extensively used SQL Developer for database access and PL/SQL Development.
• Developed XML reports as per teh requirement in Oracle Reports.
• Worked on Agile methodologies
• Process payments automatically and manually in case of exceptions.
• Involved in developing test plans and test cases based on high-level and detailed designs.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle/PL/SQL,Unix, TOAD, SQL*Plus, SQL*Loader, Shell Scripting.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed various PL/SQL stored procedures and functions
• Involved in Forms personalization with addition of extra information through Descriptive Flex-fields
• Created and customized output format in XML, new templates for XML/BI Publisher to display teh reports in client requirement format.
• Upgraded Oracle reports and BI publisher reports for financials (AP, AR, GL).
• Developed custom reports using oracle reports 10g.
• Developed a custom Customer Statement rtf Report using BI publisher.
• Loaded data from Existing database schema to new schema using Oracle Packages.
• Used PL/SQL programming to develop Stored Procedures, Functions and Database Triggers including standard packages like DBMS SQL, DBMS XPLAN and UTL FILE.
• Utilized SQL*Loader to load flat files database tables.
• Involved in Writing, debugging and optimizing PL/SQL code.
• Involved in migrating database from Oracle 9i to 10g database.
• Involved in teh ETL process of developing new tables from teh existing views and materialized views.
• Developed PL/SQL blocks using Collections like Nested Tables and VARRAYS, Bulk collections and Exception handling.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate teh functionality for various modules.
• Worked in SQL, PL/SQL development and database support as well as maintenance.
• Developed and implemented various migration scripts for various schema objects migration.
• Worked on complex queries PL/SQL packages, functions, stored procedures, triggers, views
• Performing Unit, Integration and System testing, and setting up UAT for teh project modules.
• Used EXPLAIN PLAN, TKPROF to tune SQL queries.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Worked closely with end-users and team members to understand business requirements dat drive teh analysis.
• Responsible for requirements gathering from Clients and implement teh back end changes in existing product and in designing teh database.

Environment: Oracle 9i,10g, Oracle forms 6i/10g, Oracle Reports 6i,Crystal reports, EBS, Unix, TOAD, SQL*Plus, SQL*Loader, XML Publisher, Shell Scripting.

Confidential

PL/SQL Developer --Intern

Responsibilities:

• Developed teh SQL*Loader script, and most of PL/SQL stored procedures, Triggers, and views
• Created database Triggers for teh security purposes.
• Loaded teh data into database using teh SQL*Loader from various sources.
• Creating SQL, Object Views, and PL/SQL database objects. Developed teh stored procedures for data transformation purposes.
• Tuned teh SQL Queries with teh output of Oracle Tools like Explain Plan, TKPROF.
• Fixing bugs according to teh software change requirement.
• Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
• Worked with SQL QUIRES advanced DML and DDL
• Involved in Data warehouse design with star schema.
• Developed test plan documents for all back end database modules.
• Responsible for unit testing, and documentation of teh interfaces.

Environment: Oracle database 9i, PL/SQL, SQL Plus, SQL*LOADER, Windows 2000 Professional, and UNIX.