SUMMARY

• Over 7 years of IT Experience as Oracle Developer for System Analysis, Designing, Testing Development & Support of Oracle 8i, 9i, 10g & 11g in Production, Staging, Development environments
• Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.
• Involved in all the stages of Software Development Life Cycle (SDLC).
• Experience in financial, retail and telecom domain.
• Expert in creating SQLQueries, PL/SQLpackage, function, stored procedure, triggers, and cursors.
• Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.
• Efficient in Oracle utilities and tools - SQL*loader, Export/Import, TOAD 8.0/8.5/9.0, SQL*plus, iSQL*plus, SQL Developer and SQL Navigator.
• Proficient in advance features of Oracle 11g for PL/SQLprogramming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Experience in SQL and PL/SQLtuning and query optimization tools like SQL Trace, Explain Plan, and DBMS PROFILER.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Ab Initio.
• Used Perl Scripts for scheduling jobs and managing critical paths.
• Extensively used package like DBMS STATS, UTL FILE, DBMS SCHEDULER and UTL SMTP.
• Strong knowledge with PL/SQL Wrapper to protect the PL/SQLprocedures or packages.
• Extensively used Cubes & Rollups for making cross tabular reports.
• Experience in PL/SQL collections, Bulk collections and Exception handling.
• Good knowledge of key Oracle performance related features such asQuery Optimizer, Execution PlansandIndexes.
• Hands on experience in tuning SQL statements using Explain Plan and Procedures for improving the load performance in various schemas across databases using appropriate HINTS. Good Exposure to UNIX shell scripting.
• Extensively used PL/SQL to build Oracle Reports 10g and views for processing data, enforcing referential integrity and needed business rules.
• Experienced in Tuning Queries for better performance with large volume of data. Extensive experience in developing applications using Oracle Forms / Reports (9i/6i).
• Sound knowledge of Data warehousing concepts and Business Intelligence.
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables and star schema modeling and snowflake schema modeling.
• Expertise in using HTML, CSS, JQuery, JavaScript and Ajax in APEX applications to have client side.
• Good experience in PL/SQL and ETL scripting and query optimization and also used Informatica Tool for ETL Process.
• Expertise in Database design, Requirement analysis, GAP analysis, Configuration, Development, Tuning and Testing.
• Have worked in fast paced AGILE environment & attended daily scrum meeting.
• Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
• Excellent interpersonal skills, ability to interact with people at all levels, good communication and presentation skills, good team player.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Unix shell scripts, Java, XML, C and C++

Web Technologies: JSP, Servlets, XML, HTML, JavaScript, CSS

Operating Systems: UNIX (Sun Solaris, LINUX, HP UNIX, AIX), Windows NT/98/95/2000 & Windows XP.

GUI Tools: APEX 4.2,3.2,Oracle Forms 10g,9i,6i and Reports 10g,9i,6i, ERWIN,VISIO,, Autosys Control-M, JIRA and HP quality center.

Databases/API: Oracle 9i/10g/11g, MySQL, DB2, MS SQL Server 2005/2000

Version Controls: PVCS, SVN

Other Tools: Oracle SQL Developer, Toad, SQL* Loader, Workflow, Win Runner, SSIS, SSRS

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr Oracle APEX/ PL/SQL Developer

Responsibilities:

• Migrated project from development to production environment.
• Worked with the existing Shell scripts to make the required changes so as to make it compatible to the current working project.
• Wrote PL/SQL Procedures, Functions and Packages for Insert, Update and Delete transactions and optimized for maximum performance.
• Used various report items like tables, sub report and charts to develop standard and customized reports.
• Designed application framework and developed Oracle APEX Application.
• Involved interfacing with the following tools: PL/SQL, Oracle Forms, Oracle Reports, Crystal Reports, and/or Oracle APEX.
• Formulated SQL queries, functions and processes as per customization requirement for APEX.
• Supported APEX applications and conducted performance tuning for PLSQL..
• Part of a development team for creation and maintenance of custom apps/reports..
• Created TRIGGERS to Audit the changes to data in main Tables.
• Responsible for cleansing the data from source systems using Ab Initio components such as Join, Dedup Sorted, Denormalize, Normalize, Reformat, Filter-by-Expression, Rollup
• The project involved detailed design using E-R Diagrams and Data Flow Diagrams.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data and present it to the Front-End Team.
• Created screens using HTML, JSP and Servlets.
• Worked on Business Objects (BO) to deploy various reports.
• Involved in Unit level testing, Module level testing and System level testing.
• Documented the whole process flow, PL/SQL Packages, log files, locations and description, log tables and possible error messages, process codes and description.
• Optimized, tuned and monitored the procedures using Explain Plan, Indexing and Hints based on the throughput of the results.
• TKPROF to accurately assess the efficiency of the SQL statements and application runs..
• Involved in Huge data migrations, transfers using utilities like SSIS, Bulk Copy Program (BCP) and Bulk Insert.

Environment: Oracle 11g, SQL, PL/SQL, APEX(4.0,5.0), SQL*Loader, Forms, Reports, MS Visio, Business Objects,Ab intio.

Confidential, Towson, Maryland

Oracle APEX/PL/SQL Developer

Responsibilities:

• Responsible for the installation, configuration and maintenance of Oracle 10g database on different platforms.
• Involved in upgrading the database Oracle9i to Oracle10g.
• Migrated Oracle9i Data Transformation Services objects to Oracle10g environment.
• Used Oracle APEX 4.0 for designing application structure.
• Contributed with database designs and assisted in increasing response time for APEX reports
• Involved in the Tuning of APEX reports includes PL/SQL, SQL scripts using Explain Plan TKPROF.
• Data migration and conversion done utilizing Oracle utilities: SQL*Loader, Export/Import.
• Create and maintain tables, views, procedures, functions, and packages.
• Coordinate with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Developed complicated graphs using various Ab Initio components such as Join, Rollup, Lookup, Partition by Key, Round Robin, Gather, Merge, Dedup sorted, Scan and Validate
• Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Forms Developer 9i
• Developed screen layouts, report layouts using Forms and Reports and participated in implementation.
• Designed logical and physical data models for star and snowflake schemas using Erwin.
• Identified source systems, their connectivity, related tables and fields and ensure data suitable for mapping.
• Discussions with business groups about the data quality results and future steps to develop business rules to ensure efficient data quality check and validation.
• Designed the documentation that involves functional specification, user Manual and technical review.
• Wrote control files to load data from csv and xml files obtained from various interfaces using SQL*Loader.
• Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, Explain Plans and Trace Sessions.
• Worked with Bulk Collects to improve the performance of multi-row queries.
• Handled errors using system defined exceptions and user defined exceptions like INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Wrote shell scripts in Crontab to automate Backend Jobs.
• Worked on minimizing CPU overhead by Tuning SQL Statements, Tuning Subprogram Invocation and Tuning computation-intensive PL/SQL Code.
• Partitioned tables based on data using LIST partitioning, Range Partition.
• Involved in go live meetings, cut over planning and post go live support.

Environment: Oracle 10g, PL/SQL, SQL*LOADER, SQL PLUS, APEX(4.0,5.0),ASP, HTML, PVCS, TOAD, Java, Developer Suite 6i/9i (Forms, Reports), Windows NT 4.0/2000, UNIX shell scripting.

Confidential, Warsaw, IL

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages, Views, Stored Procedures and Functions specific for project implementation.
• Developed the reports from scratch according to client specifications - Delivery and ship dates, Open Deliveries, Daily Closed Orders, Allocated Delivery, Internal Shipments By Customer, Orders Requiring Scheduling, Past Due Scheduled Shipments, Scheduled Shipments, Internal Order Backlog, Customer Audit, Supplier Audit, Sales By Customer, RDT Sales Summary, TMD On Time Promise date etc.
• Upgraded reports from 11.0.3 to 11.5.10 - Order Dollars, QPL Shipments, Sales by Item, Inverted DC Scheduled Shipments, Inverted PC Scheduled Shipments, and Shipments by Product Line etc.
• Worked on modifying and performance tuning of oracle reports.
• Worked on performance tuning of the SQL queries to improve data conversion process.
• Done Configuration Management using VSS.
• Tuned SQL queries and performed code debugging using TOAD.
• Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query factoring etc
• Customer Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
• Developed several Packages, Procedures, Functions and Triggers to use in multiple series of other backend programs using PL/SQL.
• Involved in Logical and Physical Database design and Star Schema design. Identified Fact tables, Transaction tables for Small Business and Consumer Markets (SBCM) customers.
• Written SQL scripts to create database objects like tables, views and sequences.
• Constant monitoring and performance tuning of Oracle10g database, checking the most queries.
• Developed batch programs using UNIX shell scripts to generate reports daily, weekly & monthly for Customers Markets.
• Created Korn Jobs to perform regular updates to database tables to keep in sync with the data coming from other sources.
• Performed review and analysis of deadlocks and database performance tuning. .
• Communicating/Coordinating with the people working on different systems in order to make sure that the newly setup inventory organizations are functioning according to the requirements.

Environment: Oracle 10g/9i, SQL, PL/SQL, UNIX, UML, Business Objects, Windows XP, SQL*PLUS, SQL*Loader, Erwin, SSRS.

Confidential, Miami, FL

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages, Views, Stored Procedures and Functions specific for project implementation.
• Involved in Design, Development and Testing of SQL Queries.
• Developed the reports from scratch according to client specifications - Delivery and ship dates, Open Deliveries, Daily Closed Orders, Allocated Delivery, Internal Shipments By Customer, Orders Requiring Scheduling, Past Due Scheduled Shipments, Scheduled Shipments, Internal Order Backlog, Customer Audit, Supplier Audit, Sales By Customer, RDT Sales Summary, TMD On Time Promise date etc.
• Upgraded reports from 11.0.3 to 11.5.10 - Order Dollars, QPL Shipments, Sales by Item, Inverted DC Scheduled Shipments, Inverted PC Scheduled Shipments, and Shipments by Product Line etc.
• Worked on modifying and performance tuning of oracle reports.
• Worked on performance tuning of the SQL queries to improve data conversion process.
• Done Configuration Management using VSS.
• Tuned SQL queries and performed code debugging using TOAD.
• Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query factoring etc.
• Prepared and updated design specifications.
• Customer Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
• Developed several Packages, Procedures, Functions and Triggers to use in multiple series of other backend programs using PL/SQL.
• Involved in Logical and Physical Database design and Star Schema design. Identified Fact tables, Transaction tables for Small Business and Consumer Markets (SBCM) customers.
• Written SQL scripts to create database objects like tables, views and sequences.
• Constant monitoring and performance tuning of Oracle10g database, checking the most queries.
• Developed batch programs using UNIX shell scripts to generate reports daily, weekly & monthly for Customers Markets.
• Created Korn Jobs to perform regular updates to database tables to keep in sync with the data coming from other sources.
• Performed review and analysis of deadlocks and database performance tuning.
• Created technical design documents.
• Communicating/Coordinating with the people working on different systems in order to make sure that the newly setup inventory organizations are functioning according to the requirements.
• Interacting directly with client to have a better understanding of the requirements of the project.
• Designed and developed Custom reports according to the client's specification.

Environment: Oracle 9i, SQL, PLSQL, SQL*Loader, KORN Shell script, Erwin, TOAD, Web Logic, HTML, Java, J2EE

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Assisted in database designing by creating database objects such as Tables, Views, and Indexes.
• Developed Packages and customized functions and Triggers based upon the business logics.
• Assisted in Installing Application Server, Report Server and Database Server.
• Worked with Sub-queries/Correlated Sub-Queries in different areas of the database.
• Used SQL*LOADER for bringing the legacy data into Oracle pre-interface tables. Developed SQL*Loader scripts.
• Development of feeder programs using SQL*LOADER and PL/SQL procedures to transfer data from legacy systems to Auto Invoice Interface Tables.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Designed, developed, tested and implemented using Oracle Forms.
• Responsible for Designing, development, testing and deployment of Oracle Alerts, Triggers and debugging for Oracle Forms.
• Created the index for increasing the performance of data conversion process.
• Performed Unit Testing, Integration Testing and Performance Testing.
• Load the data from Excel file to oracle database.
• Involved in the Migration of Data from Online system to Data Warehouse System for data analysis.
• Involved in design, development, testing, implementing, various reports using Oracle Discoverer and Oracle Reports.
• Implemented parameters, condition, filters and calculations in reports through Oracle Discoverer Desktop.
• Worked with front end team on developing the application in ASP.NET.
• Conducting business analysis, project assessment, feasibility determination, and analysis of technical and functional requirements and ensuring on-time delivery with great quality.
• As an Off Shore lead Responsible for full life cycle Implementations, Rollouts and Post production support covering Fit-Gap analysis, Process design, Interfacing, Conversions and Data migrations.

Environment: Oracle 9i/8.x,PL/SQL, SQL*Loader, SQL Navigator, SQL*Plus, UNIX, Windows NT 4.0/2000/XP Windows2000.