SUMMARY:

• Solid managerial and administrative skills with good business understanding and excellent versatility and adaptability to manage multiple tasks.
• Ability, willingness, and passion to learn new technologies and acclimatize to diverse work cultures.
• Worked on 24 7 environments to provide production support.
• Used Cursor Variables Ref Cursors to pass query results sets between PL/SQL programs and client application.
• Moved columns of data into and out of database tables using PL/SQL program units by passing collections as parameters to program units.
• Implemented Autonomous transaction and Distributed transaction processing in PL/SQL Non-Distributed transactions, Distributed transactions, Remote transactions.
• Developed complex triggers using PL/SQL for data integrity and enforcing business rules.
• Supported Advance PL/SQL using Cursors, REF Cursors, and Native Dynamic SQL.
• Solid experience in writing and debugging stable and robust PL/SQL code, handling various kinds of Exceptions, SQL, Dynamic SQL, C, and UNIX shell scripts.
• Extensive experience in Data Modeling Conceptual, Logical, and Physical , Data warehousing and Database Design for OLTP Relational and OLAP Star Schema system using various design tools Visio, ER-Win Tools
• Expertise in leading a team of 5 resources. Proficient in developing concurrent programs using SQL, PL/SQL and UNIX Shell Scripting.
• Worked on Oracle Forms 5/6.0/6i/10g/11g, Reports 5/5/6.0/6i/10g/11g
• Involved in development, Enhancement and Maintaining of applications in Oracle 8i/9i/10g using SQL, PL/SQL, Oracle Forms and Reports in windows environments.
• Extensive knowledge and work experience in System Analysis, design and development of database applications in Client/Server applications using Oracle 11g/10g/9i/8i, SQL, PL/SQL, SQL Loader.
• Over 8 years of extensive experience in all phases of software development life cycle SDLC that includes Requirement Analysis, Design, Development, Integration, Documentation, Testing, Deployment, Code Management, Maintenance, Enhancements in Enterprise Application Integrations.
• Proficient in PL/SQL programming Stored Procedures, Functions and Packages, SQL performance tuning, and creation of Oracle Objects Tables, Views, Materialized Views, Triggers, Synonyms, Database Links, User Defined Data Types, Nested Tables and Collections.
• Involved in project planning and scheduling, System Design, Functional specification, Design specification, Preparation of impact analysis, Coding, System Test Plan, User Acceptance Testing UAT , Quality Assurance, Code Review.
• Designed database schemas using Entity relationship modeling with ER diagrams database normalization principles.
• Good understanding of oracle Data Dictionary, RDBMS and Normalization Techniques.
• Functional knowledge in individual and group General Ledger, Account Receivables, Banking and Telecom domain.
• Experience working with Production and Development environment.
• Experienced in Query Optimization, Debugging, and Performance Tuning of the applications.
• Experience in working with Sequence and Indexes.
• Proficient in working with Hints and Table Partitioning.
• Hands-on experience on APEX tool.
• Good Understanding of GUI using JavaScript, HTML.
• Strong knowledge on ETL process.
• Involved in preparing Integration test, Database Test for TOAD.
• Experience in Unit and Integration Testing.
• Experience in UNIX, and Shell Scripting.
• Knowledge of DB2 Database
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills and a Very Good Team Player.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle Pl/SQL Developer

Project Description:

Fulfillment Services:

Fulfillment Services: Fulfillment Services internally has different modules like payment, billing, B2B, accounts, Event services, order management, order services, organizational service and zip to tech services. The main goal of the application is to create services using SOA, Ecommerce, Oracle App's, and Pl/SQL programming. In order for the customer to order, make a payment, recurring payment, invoice, billing etc. Different procedures, packages and functions Created to process the data according to business logic. So that SOA team can call these PL/SQL Objects for the services. Received input data as parameters from SOA, Implemented the Business logic and sent the required data to SOA services team. Collections Used for major development.

Responsibilities:

• Worked on CVS to monitor the PLSQL code changes, CVS versions also used for deployment process.
• Created ER diagrams for the database objects for different projects and maintained them.
• Developed SQL Loader scripts to migrate the data from flat files into database tables.
• Expertise in writing Check SQL's and transactional quires to run in production to monitor data integrity.
• Involved in SDLC gathering requirements, creating detailed Documentation HLD and TDD which includes all Business requirements and technical specifications.
• Involved in database schema designing, development and testing process.
• Developed stored procedures, functions and packages to facilitate consistent data entry into the database.
• Participated in system analysis and data modeling, which included creating Tables, Views, Materialized Views, Indexes, Synonyms, Triggers, Functions, Procedures, Cursors and Packages.
• Expertise in working with Records, Collections and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose. Used pipelined functions for faster data accessibility. Writing validation packages using PL/SQL package.
• Used advanced Bulk techniques FOR ALL, BULK COLLECT to improve performance. Developed Installation scripts for all the deliverables.
• Involved in working with IMPLICIT CURSORS, EXPLICIT CURSORS, and REF CURSORS.
• Involved in SQL query Performance tuning.
• Experience in using various oracle PL/SQL collections VARRAYS, NESTED TABLE, ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2
• Involved in working on Oracle Pseudo columns like ROWID, ROWNUM, SYSDATE, SYSTEMTIMESTAMP, USER etc.
• Create various user defined EXCEPTIONS to control the process based on the business requirement.
• Involved in generating numbers for PRIMARY KEY VALUES using Oracle SEQUENCE objects.
• Used several Oracle predefined functions NVL, NVL2, DECODE, CASE STATMENT.
• Extensive experience in design, development, and enhancement and managing applications oracle PLSQL.
• Designed and developed scripts for Packages, Procedures, Functions and other objects to deploy to different database schemas and environments.
• Developed front end applications using Oracle Forms and report generation using Oracle Reports.
• Worked on customization of forms and reports as per the requirements.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Expertise in working with APEX tool to provide business functionalities.
• Involved in integration of the data with SOA, OFS and JAVA team according to the business specifications.
• Testing the system integration closely with SOA, OFS and JAVA team and resolve the issues as per the business rules.
• Expertise in import and export MS Excel data to Pl/Sql Objects.
• Expertise in MS Excel functionalities.
• Worked in all deployment processes to SIT, QA and Production Environments. Handled various errors thrown throughout the integration process and coordinated with the team.
• Worked in agile environment with more than 10 people as a team Which includes SOA, OFS team members .
• Strong Knowledge on ETL process and SOA.
• Involved in scrum meetings, Business requirements meetings.
• Updated status of the development on daily basis.

Environment: Oracle 11g, SQL, PL/SQL, Toad, Oracle RDBMS, SQL Developer, CVS, QC, Forms 10g, Reports 10g

Confidential

Oracle Pl/SQL Developer

Project Description:

Information Management System IMS : Information management is a database application which receives data from SAP ERP system and the data is flowed to different interfaces and down streams from this system. The system receives the raw data from SAP system and the data gets manipulated to meaningful data in IMS and sends to different applications, interfaces services etc. This system contains the complete employee data, company data and behaves as a central system to send data to different instances and interfaces.

Responsibilities:

• Involved in creating detailed Documentation HLD and LLD which includes all Business requirements and technical specifications.
• Leading team of 5 resources.
• Created data mapping files for the data coming from different web services.
• Knowledge and experience in structured systems analysis and design techniques.
• Developed database objects including Tables, Indexes, Views, Sequences, Packages, Triggers and Procedures to troubleshoot any database problems.
• Extensively used stored procedures to apply validation logic for the data in staging area to load into catalog Database.
• Extensively worked on PLSQL composite data types Records, Collections.
• Used Explain Plan, HINTS for performance tuning of SQL, PL/SQL queries.
• Worked with ETL team and architect to build data model for staging area.
• Worked with business experts to understand the source data in web service systems.
• Prepared the Mapping document which details out the mapping of source to the target data model with application of business rules.
• Importing and exporting the data into multiple environments.
• Supported for code integration and system integration testing for this application.
• Worked with Java and J2ee development team and worked for Hibernate mapping and Provided SQL Queries.
• Involved in designing of required end user forms and reports using Oracle forms Reports.
• Customization of existing forms and development of new forms using different form built in's.
• Developed different UNIX scripts as per the business requirements.
• Worked with ETL team involved in loading data to staging area. Provided all business rules for the database for loading data.
• Worked for ETL process of data loading from different sources and data validation process from staging area to catalog database.

Environment: Oracle 10g, SQL, PL/SQL, Toad, Oracle RDBMS, Oracle Form/Reports 6i, SQL Developer, Toad.

Confidential

Sr. Oracle Pl/SQL Developer

Project Description:

• RISM Repository for Information Management system: Repository for Insurance management
• System RIMS is a robust internet and intranet Web application. This system deals with insurance
• Policy, proposal, premium, endorsement, renewal and receipt this system also deals with the insurance claim information according to health damage, accident. System generates different reports for their operations such as New Policy, Premium, Accident claim and various summary reports. Claim Management is primarily used by the insurance sector inter company personnel like Inspectors, Claims specialist, supervisor, and managers. This Intranet application also features a powerful search engine and also helps keep track of claims and various corporate activities like report generation, status maintenance etc. It supports access to centralized repositories from any company location, for all IT users. The tool contains various modules like financial data management, project management, Application management, time entry, project estimates, prioritization, and purchase and work initiation.

Responsibilities:

• Involved in creating detailed Functional Documentation which includes all Business requirements and Technical specifications.
• Worked for designing Logical and Physical data models for Master Data and Transactional Data.
• knowledge and experience in structured systems analysis and design techniques
• Developed database objects including Tables, Clusters, Indexes, Views, Sequences, Packages, Triggers and Procedures to troubleshoot any database problems.
• Worked with ETL team and architect to build data model for staging area.
• Importing and exporting the data into multiple environments.
• Supported for code integration and system integration testing for this application.
• Worked with ETL team involved in loading data to staging area. Provided all business rules for the database for loading data.
• Involved in handling the changes in compiling scripts according to the database changes.
• Developed reports using complex queries as per client request as a part of production support
• Performed SQL Performance tuning using Explain Plan, Hints and indexes
• Involved in handling the batch jobs using UNIX shell scripting.
• Responsible for performing code reviews.
• Created SQL Loader scripts to load data into temporary staging tables.
• Utilized SQL Loader to load flat files into database tables.

Environment: Oracle 11g/10g, SQL Server Reports 2008, SQL, PL/SQL, Toad, Oracle RDBMS, SQL.

Confidential

Oracle Pl/SQL Developer

Project Description:

ThyssenKrupp is the world's premier manufacturing firm with global presence and is organized globally operating business sectors namely Laundry and Home Care, Cosmetics and Toiletries, and Adhesive Technologies. It uses a wide variety of systems such as SAP, Oracle databases, and Business intelligence reporting tools. The central management system application contains the information regarding the company and employees to process to different applications.

Responsibilities:

• Involved in Requirement Analysis, System Design, Preparing Functional Specifications, Preparing Design.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Created SQL Loader scripts to load data into the temporary staging tables.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
• Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Worked on various backend Procedures and Functions using PL/SQL.
• Developed the forms and Reports as per the requirements.
• Involved in Requirement gathering and creating Dataflow Diagrams, ER diagrams and database diagrams using Oracle Designer.
• Involved in Shell scripts to automate the loading, balancing and extraction process
• Check the functionality of data in the front-end whether it is displaying properly or not.
• Managing Version Control Tool like Clear Case and Start Team.

Environment: Oracle 9i/10g, PL/SQL, SQL Loader, TOAD, Java, HTML, MS Office

Confidential

Software Engineer

Project Description:

Finale software implemented at bank side for providing core banking solutions. This project is for doing the new enhancements given by the bank on quarter basis. The back end is Oracle and front end is in character as well as web-mode. The enhancements were in the form of generating Reports, Uploading batch files, Product menu automation, and automated transactions. Project also included the AML Reports to be developed for Deutsche Bank Germany .

Responsibilities:

• Customization for the Bank involves following roles and responsibilities:-
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
• Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Development for enhancements using technologies like PL/SQL, UNIX. Configuration Management of all the files and Process Documentation.
• Involved in Shell scripts to automate the loading, balancing and extraction process
• Check the functionality of data in the front-end whether it is displaying properly or not.

Environment: Oracle 9i, PL/SQL, TOAD and Windows 2000 server