SUMMARY

• More than 8 years of experience in Application Development using Oracle PL/SQL.
• Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
• Experience with Software Development Life Cycle (SDLC) with good working knowledge, disciplines, tasks, resources and scheduling.
• Good Knowledge on Oracle Architecture and Database Design.
• Excellent conceptual knowledge of Oracle10g/11g, PL/SQL and SQL.
• Experience in different phases of Oracle Applications Implementation life cycle including Technical Design, Data Conversion, Oracle Forms development, Oracle report development, Unit Testing, Integration Testing, End User Training, Production Support.
• Experience in designing business requirements and modeling using oracle designer.
• Experience in developing External Tables, Joins, Indexes and sequences.
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Extreme Use of Exception Handling methods
• Expertise in loading data from legacy systems using SQL*Loader.
• Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export, TKPROF and SQL*Navigator v.4.5.
• Good experience in Oracle Forms and Reports.
• Participated in collecting the requirements, analyzing the System Requirements.
• Experience with Star Schema Modeling and knowledge of Snowflake Dimensional modeling.
• Experience with Data Modeling using ERWIN 4.0/3.5.2, SQL Server, Toad data modeler.
• Extensively worked on Design, Development, Deployment & Maintenance of ETL process to Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML SQL/ Oracle) to different targets (DB/Files).
• Extensive experience in developing complex mappings with Custom Transformations.
• Experience in Performance Tuning of sources, targets, mappings and sessions.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Good experience working on End - To-End implementation of data warehouse and strong understanding of Data Warehouse Concepts, ETL, Star schema, Data Modeling, experience using Normalization, Business Process Analysis, Reengineering, Dimensional Modeling, FACTS &Dimensions tables

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g.

Scripting: UNIX, PERL.

Languages: SQL, PLSQL, HTML, UNIX, JAVA.

Tools: SQL Developer, TOAD, SQL plus, SQL Navigator, Informatica.

OS: Windows 7, Windows XP, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Sr.Oracle Developer

Responsibilities:

• Worked with the Business analysts, Business and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Developed procedures, functions, packages, views, and materialize views etc to meet the business requirements.
• Involved in daily monitoring of EDI transactions, troubleshooting and fixing them.
• Data loaded from flat file sources using PL/SQL and SQL*Loader.
• Modified existing/created new PL/SQL blocks for doing the validations on data and to generate response to the trading partners accordingly to meet the technical specifications.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Used UTI FILE PACKAGES for creating/opening of files.
• Used oracle utility DBMS UTILITY for the compilation of Invalid objects like packages, functions, procedures, triggers etc.
• Performing DML operations for daily activities.
• Developed database objects: tables, views, procedures, packages and other database objects using Oracle tools like SQL* Plus, SQL*Developer and TOAD for Oracle.
• Extensive use of performance tuning by creating indexes, providing Hints, modifying tables, analyze tables and estimate stats using explain plan utility.
• Improved execution of queries by using Bulk Collections, Indexes, and Materialized Views.
• Developed re-usable transformations, mappings and Mapplets conferring to the business rules.
• Designed and developed complex Informatica mappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of the data between various applications.
• Updated the mappings according to the changed requirements.
• Creation of Sessions and executing them to load the data from the source system using InformaticaWorkflow Manager.
• Developed and documented Data Mappings/Transformations, and Informatica sessions as per thebusiness requirement.
• Involved in modification/troubleshooting of batch jobs to meet the requirements and scheduling tasks.
• Coordinated with all the stake holder involved for the quick resolution of issues and also providing technical solutions to the client.
• Documented recurring issues and it's fixes to avoid delays.

Environment: Oracle 11g/10g, SQL, PL/SQL, Informatica, TOAD for Oracle 12.7, SQL*Loader, UNIX Shell script, Windows XP/2003, Oracle forms and reports 10g, Windows Task scheduler.

Confidential, Raleigh, NC

Sr.PL/SQL Developer

Responsibilities:

• Participated in project planning sessions with business analysts and team members to analyze business IT Requirements and translated business requirements into working model.
• Worked extensively on Data migration for new merchant acquired by First Data from the competitors.
• Custom reports generation based on the requirements.
• Involved in Initial designing and developing web pages for various requirements.
• Generation of reports and analysis.
• Enhancements in existing reports and PL/SQL blocks.
• Extensive use of performance tuning.
• Usage of Unix commands for transferring files to merchants.
• Using import and export utilities for large data transfer.
• Worked with Business in full development life cycle for Prepaid Business project. And involved in developing procedures, functions, packages, triggers, views, and materialize views etc.
• Created and ExecutedWorkflowsandWorkletsusing Workflow Manager to load the data into theOracle Database.
• Developed re-usable transformations, mappings and mapplets confirming to the business rules.
• Involved in Performance tuning, which included creating indexes, providing Hints, modifying tables, analyze tables and estimate stats using explain plan utility.
• Designed ER diagram using Erwin, to set the logical and physical relationships of database.
• Involved in walkthrough sessions with business users during Analysis and Designing phase. Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQL and TOAD.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.

Environment: Oracle 11g/10g/9i, SQL, PL/SQL, Informatica Power Center 8.6, SQL*Loader, UNIX Shell script, TOAD, UNIX, Windows XP/2000.

Confidential, Franklin Lakes, NJ

Sr. PL/SQL Developer

Responsibilities:

• Handling the data requests from multiple clients.
• Handling complex SQL scripts for data retrieval.
• Generating files based on daily requests.
• Using UNIX for file transfer to client side.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Performing DML operations for daily activities.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems using PL/SQL and SQL*Loader.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
• Involved in designing ER diagram using oracle designer, to set the logical and physical relationships of database.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD.

Confidential

Sr. PL/SQL Developer

Responsibilities:

• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Created SQL*plus reports as per client's needs, and developed business objects.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in pl/SQL blocks and even have experience with exception handling..
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.

Environment: Oracle 11g/10g/9i, SQL, PL/SQL, SQL*Loader, UNIX Shell script, JAVA, MS Access, TOAD, Oracle Forms 10g, Reports10g, Oracle Designer, UNIX, Windows XP/2000.

Confidential 

Sr. PL/SQL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Created Indexes and partitioned the tables to improve the performance of the query.
• Involved in SDLC including designing, coding and testing.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval frommultiple tables.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.

Environment: Ordacle 10g/9i/11g, SQL, PL/SQL, SQL*Loader, UNIX Shell script, MS Access, TOAD, Oracle Forms 10g, Reports10g, Oracle Designer, UNIX, JAVA, Windows XP/2000.