SUMMARY

• Having 8+ years of IT experience in analysis, design, development and implementations on HealthCare, Financial Services, Insurance sectors using teh Oracle RDBMS Technology, Oracle Development Tools and other Client/Server Tools.
• Extensive working experience in Oracle Database 12c/11g/10g/9i/8i/7, SQL, PL/SQL, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes, Views, Materialized Views, SQL Loader.
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions.
• Experience in Oracle cursor management and exception handling.
• Experience with various DDL functions like Tables, Indexes, Materialized Views and Partitioning tables.
• Proficient in Oracle tools and utilities such as TOAD, PLSQL Developer, SQL*Plus, SQL Developer, SQL*Loader, SQL Navigator, OEM (Oracle Enterprise Manager).
• Experience in front end development using Oracle Forms/Reports.
• Managing teh end - to-end implementation of teh project including designing, development, testing, implementation and support of software applications.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Experience in using several built in database packages as DBMS JOB, DBMS OUTPUT, UTL FILE and DBMS SQL are few to be named.
• Working Experience of Loading Data into Oracle Tables using SQL Loader.
• Experience in query optimization, Performance Tuning (PL/SQL) and debugging using SQL Trace, TKPROF, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Extensively worked on Dynamic SQL, PL/SQL Collections, Objects, Records, Bulk Collections, etc.
• Experience in using oracle long data types like BLOB and CLOB.
• Experience in using oracle DBMS JOBS for teh JOB scheduling.
• Developed Mappings using Type 1, Type 2 SCD logic to load data into Dimension tables.
• Extensively worked on SQL Server Integration Services Mappings to load data from Flat files, databases and schedule jobs in SQL server.
• Involved in creating workflows using informatics workflow manager.
• Good knowledge to teh existing APEX applications in teh production.
• Used various Indexing and partition techniques to improve teh query performance.
• Expertise in all phases of teh software development life cycle including analysis, physical and logical design code development.
• Worked on 24*7 environments to provide support.
• Good team spirit and organized working habits with a willingness to learn new concepts.
• Involved in offshore team coordination. Working with them to provide necessary requirement documentation, validating teh development work and bug tracking.
• Good interpersonal skills with excellent written, oral communication and excellent team player.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g/12c, MS SQL Server 2005/2008, MySQL, DB2, MS Access

Tools: SQL Developer, SQL Loader, Toad, Golden Gate, Erwin, Datastage FTP, Sendmail, Crontab, Autosys, Websphere MQ & TIBCO

Languages: SQL, PL/SQL, Java, J2EE, JavaScript, Korn Shell, PERL, C, C++

Web Development: Java Script, HTML, DHTML and XML

Server Side: Servlets, JSP, Spring, JDBC

Application Servers: Tomcat, Weblogic, Web sphere

Operating Systems: Windows XP/NT/2000, Unix, Sun Solaris 2.x, Linux

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Senior Oracle PL/SQL Developer

Responsibilities:

• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements.
• Created materialized views & normal views where business requirements needed.
• Tuned teh SQL queries and complex procedures to improve performance, used EXPLAIN PLAN and Toad/SQL Navigator for tuning teh queries.
• Developed various database objects like tables, schemas, views, packages, stored procedures, triggers, functions etc using TOAD.
• Developed SQL*Loader scripts to load teh data from external flat files that are exported from SQL Server.
• Debugged existing code for business logic issues.
• Developed reports as per teh requirements collected from teh users using Oracle Reports Builder 10g.
• Migrated forms from 8i to 11g, by recompiling and modifying teh code as needed to support teh complex functionality embedded.
• Involved in developing scenarios for Unit, Integration testing to ensure that all teh components work correctly when integrated.
• Modified and optimized complex queries for data retrieval and modification.
• Developed SQL*loader scripts to load data from various forms of flat files into staging tables inOracle database.
• Involved in XML parsing and loading XML files into teh database.
• Involved in using of new features of Oracle 11g like Analytical functions, Flash back Query, regular expressions.
• Involved in teh restructuring and fine tuning of teh existing SQL Queries according to teh new requirement using TKPROF, AWR.
• Responsible for performing Code Reviews.
• Used UTL FILE package for writing DBMS OUTPUT messages to file.
• Used an in house defect tracking tool and Clear Case for defect tracking.
• Interacting with teh users and troubleshooting teh problems involved with teh development of stored procedures, triggers and with teh privileges.
• Uploading teh Test cases, Manual Test Scripts, Codes and Specification Documents on Visual Source Safe (VSS) for version controlling.
• Worked on Unix environment and shell scripting for creating Batch Jobs using Unix KORN, AWK Unix Shell Scripts and API's Using PEARL Scripts.
• Involved in providing 24/7 database production support and troubleshooting data quality and integrity issues.

Environment: Oracle Database 9i/11g, Oracle Forms 6i/11g, Oracle Reports 10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, .Net, DTS, TOAD, Clear Case, VSS, Unix.

Confidential, Warren, NJ

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in Status meetings and Walkthroughs.
• Designed and developed teh Packages, procedures, functions efficiently in loading, validating teh data. Also worked on creating users and roles as needed for teh applications.
• Extensively wrote teh PL/SQL and SQL programs and Designed and developed teh views, materialized views, functions, procedures, packages, triggers and cursors.
• Worked on Performance tuning using indexing concepts.
• Extensively used SQL Loader, UTL FILE and External Table mechanisms to load legacy data, feed files data and data from various sources into teh Oracle database tables.
• Developed reusable unit test scripts for every store procedure.
• Created Shell Scripts, SQL scripts, Stored procedures and Constraints according to teh Data transfer from Legacy systems to Oracle Database.
• Created various objects such as Tables, Views, Materialized Views, Stored Procedures, Functions and Triggers.
• Created and maintained Materialized Views for Aggregator Facts and Elements.
• Developed Unix scripts to save Oracle concurrent program outputs and sending them as an email attachments.
• Improvisation of teh performance of teh application through SQL Performance tuning using TOAD and SQL Developer.
• Designed Report output formats, complex filtering and formula calculations, as well as teh rendering of multi-band and multi-grouped reports.
• Developed complex triggers in reports before/after for validation of user input.
• Extensively used SQL*Loader to load Data from flat files from various Data Sources to Database tables in Oracle.
• Developed teh PL/SQL home -grown applications using advanced features like Native dynamic SQL (NDS) and INDEX BY TABLES, Hints, Indexes, FORALL statements to improve teh performance.
• Developed Oracle Forms 10g database triggers, cursors, stored procedure.
• Involved in continuous enhancement, optimization and fixing of problems.
• Provided technical support to teh user with regard to operational aspects.
• Worked on Production support for teh Blockbuster databases.
• Worked mainly on analyzing teh problems occurring in teh data, and finding teh solution to resolve them.
• Used Informatica Power Center 8.1 for extraction, transformation and loading (ETL) of data in teh Data Warehouse.
• Performed ETL into ORACLE Data Warehouse using Informatica Mappings including transformations Aggregator, Joiner, Lookup, Filter, Update Strategy, Stored Procedure, Router, Expression, Sql and Sorter.
• Worked on finding teh decommissioned user and deactivating them.

Environment: Oracle 11g, SQL Developer, PL/SQL, SQL Developer, TOAD, SQL Loader, SQL*Plus, Oracle Forms, Windows 7.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in defining system requirements, designing & prototyping, developing, testing, and implementation of teh applications
• Developed packages for processing data in teh staging tables according to teh Clients requirements
• Extensively worked on oracle objects such as Tables, views, synonyms, Object Types, Collections and involved in developing teh Database objects.
• Wrote Packages, Stored procedures and functions for accessing, inserting, modifying and deleting data in teh database from GUI.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Used Global temporary tables for processing DML operations on huge data from GUI at one time
• Used Exception Handling extensively for teh ease of debugging and displaying teh error messages in teh application.
• Handled Production issues with high pace and efficiency
• Optimized existing queries for better performance and less impact on database and used Materialized views in places where teh data does not change very frequently.
• Wrote Queries to retrieve data in XML format from teh tables

Environment: Oracle 10g, PL/SQL, TOAD, SQL Developer, UNIX, HP PPM (Kintana) and CVS.

Confidential - Edison, NJ

Sr. Oracle PL/SQL Developer/Data Analyst

Responsibilities:

• Extracted xml files to load it into database through sql*loader.
• Extracted data from various location and load them into teh oracle table using SQL*LOADER.
• Creating database objects And Developing and modifying PL/SQL packages, functions, procedures, PL/SQL Tables.
• Handled Input data coming from Real Time system to create xml file using pl/sql procedure.
• Handled various inbound files and process them with teh help of Korn shell and SQL LOADER and loaded them into teh oracle Global table.
• Experienced in Datamart.
• Created entry screens for teh systems in forms
• Worked with forms 9i at teh back end and generated Triggers
• Unix shell scripting and Used Job scheduling tool like Cron job for automation.
• Extensive knowledge on Unix shell scripting and commands.
• Understanding and documenting business rules, output requirement and data sources.
• Improved query performance by query optimization - tracing teh query execution plan (explain plan).
• Unit test and debug developed software.
• Collaborated with a multi-disciplinary team to design, build and test software to meet client needs.
• Participated in design and analysis of Acxiom systems and/or products.
• Wrote Complex SQL script, Analytical Function using Cursors, Bulking techniques, Collections, Dynamic SQL.

Environment: Oracle Database 11g, TOAD, Informatics, TOAD, Microsoft Visual Studio, ERwin, Windows XP, Unix

Confidential, Johnstown, PA

Oracle PL/SQL Developer

Responsibilities:

• Interacted with Business Analysts and Users in requirement gathering, built complex queries using SQL and wrote stored procedures using PL/SQL.
• Involved in teh database design for better understanding teh relations, associations and dependencies within teh database.
• Designed Technical design document based on teh business requirements.
• Worked on SQL*Loader and Bulk Collections to perform bulk data loads into database tables from external data files.
• Extensively used advanced features of PL/SQL like Ref Cursors, Collections (Nested table and Varray ) and Dynamic SQL.
• Created Materialized Views, tables, complex SQL queries, Correlated sub queries, Nested Queries, Views and Function Based Indexes for TEMPeffective Business Application Development
• Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating Packages to meet business requirements.
• Created Unix shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with teh incoming data from other sources.
• Used Oracle packages like DBMS STATS to collect statistics of tables as an aid to improve teh performance of application.
• Monitoring teh schedules and timely escalations to teh project management and client in case of any slippages.
• Worked on Exception handling, to trouble-shoot PL/SQL code and to display teh error messages in teh application.
• Used Explain Plan, SQL*TRACE, TKPROF for tuning teh SQL statements by creating indexes and used HINTS to direct teh optimizer to choose an optimum query execution plan.
• Performed unit test on teh developed code to ensure that its bug free.
• Handled Production issues and managed teh same in issue log.

Environment: Oracle 10g/11g, Windows XP, PL/SQL, TOAD 9.1/10.5, VI editor, SQL loader.

Confidential

Oracle Developer

Responsibilities:

• Involved in analysis, design, development, maintenance and implementation in software applications.
• Writing programs in Oracle PL/SQL, analyze and resolve defects reported by onsite team
• Develop and testing Oracle packages stored Procedures, functions and triggers
• Worked on Merchant management, a sub-module to manage merchant and outlets, manage different kind of transactions and routs them to responsible institution.
• Prepare technical specifications on common configurations in database tables.
• Writing PL/SQL procedures to receive text file & upload data into database or export data into textfile.
• Work tickets as schedule for monthly releases and support daily incoming priority issues.
• Working on critical projects in a team and also handling individually.
• Developed and tuned PL/SQL procedures, triggers and Packages.
• Developed database objects like Tables, Synonyms, Views, Indexes, and Sequences
• Involved in business development life cycle, Oracle Forms, Oracle Reports and Oracle PL/SQL programs.
• Involved in migrations, Staging, testing, user acceptance testing (UAT), production support, and completion.
• Involved in Production support for system issues to include support for software solutions.

Environment: Oracle 9i, SQL Loader, SQL, PL/SQL, Unit Testing, SQL*Loader, SQL Server 2005, Sun Solaris/Windows XP/Linux, Clear case, UNIX Shell Script.