Sr. Oracle Plsql Developer Resume

SUMMARY

• Over nine years of IT experience as an SQL, PL/SQL Developer on a variety of Windows 2000/2003/Xp platforms with Sybase and Oracle 9i/10g.
• Experience as MS SQL Server Developer 2012/2008/2005 and Business Intelligence solutions using SSAS, SSIS and SSRS.
• Expertise in developing SSIS Packages to Extract, Transform and Load ETL /DTS data into the Data Warehouse from heterogeneous databases such as Sybase ,Oracle, Excel and MS Access.
• Knowledge in creating cubes with dimensions and facts tables using SQL Server Analysis Services SSAS .
• Expert in creating and deploying SSRS reports on the portal for user accessibility.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
• Experience in all phases of the project Life cycle- Requirement gathering and Analysis, Database design, Database development, Application development, Test and Support.
• Very Good Knowledge about the Oracle tools like TOAD, SQL PLUS and SQL Navigator.
• Proficient in Query/application tuning using Optimizer hints, Explain plan, SQL trace, TKPROF.
• Created table partitions to improve performance and data management.
• Experience in data modeling using Erwin and Visual studio.
• Experience in creating Materialized Views.
• Experience with locally managed and dictionary managed tablespaces.
• Expert in Creating Public Synonyms, DBLinks.
• Managing security by creating and granting roles and privileges to users.
• Knowledge of DBMS JOBS, DBMS PROFILER, DBMS SCHEDULER packages.
• Experience in developing External Tables, Stored Procedures, Table Partitions, Functions, Packages, Views, Joins, Indexes, Cursors and Database Triggers, Collections.
• Proficient in advance features of Oracle 9i for PL/SQL programming like Using cursor variables, Ref. cursors, nested tables and Dynamic SQL.
• Analyzed tables and indexes for Cost Based Optimization CBO to work efficiently.
• Experienced in writing UNIX shell scripts.
• Have written scripts involving table level triggers to monitor table transactions and maintain history.
• Expertise in handling errors using Exceptions.
• Experience in database application development using Interactive SQL, SSMS, Aqua Data Studio, TOAD, and SQL Developer.
• Good experience in sending the request to web service and getting the response from web service.
• Experience in parsing of XML's using DOM Parser i.e. DBMS DOM.
• Knowledge of Oracle 9i and 10g Database Architecture.
• Making structural changes to the database.
• Documentation of projects and databases.
• Work with software developers to develop and enhance applications.
• IT experience in Software Development Life Cycle SDLC , which involves Requirements Gathering, Analysis, Design, Development, Testing, Implementation and support with extensive exposure in database.
• Experience in performance tuning, normalization and denormalization, partitioning of data and indexing of partitioned tables.
• Clear communication and documentation of technical specifications.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills.
• Expert Skills in time management, prioritizing tasks.

TECHNICAL SKILL

PROFESSIONAL EXPERIENCE

Confidential

Oracle PL/SQL developer

Confidential is a global service company, providing customers with access to products, insights and experiences that enrich lives and build business success.A leader in global payments, American Express is the largest card issuer by purchase volume and operates a worldwide network that processes millions of merchant transactions daily. We offer the broadest array of payment, expense management and travel solutions for consumers, small businesses, midsize companies and large corporations.

Confidential

• The GMS team monitors the financial stability and exposure of merchants who have a proprietary contract with American Express.
• Merchant exposure arises out of non-delivery of goods and services to card members and disputes/returns for which American Express has already made a payment to the merchant. This exposure can be partly or fully mitigated through collaterals which would include pending payments to merchants, holdbacks, and other forms of collateral i.e. lien, letters of credit .
• Currently Enterprise MIS has segmented MIS capabilities whereby reports are generated via SAS, SQL scripts and then emailed to users across the globe. These reports are then aggregated and analyzed by each team member using Excel and other local applications. This process results in numerous issues such as missing data or requires significant user effort to make changes to the report structures. Furthermore, we have significantly expanded the available merchant information both financial and non-financial along with the frequency of the data which requires new reports to be developed.
• The purpose of this project is to develop a robust reporting database for Enterprise MIS which includes 12 standard reports into a single database, providing the risk team with the necessary information to make accurate and timely decisions. The database will standardize each report while allowing users the flexibility to generate user specific criteria. Additionally, this project will satisfy one of the Bank Holding Company requirements for the Enterprise MIS team as specified in the Ernst Young Report on AEXP BHC Readiness.

Role: Oracle PL/SQL developer

Responsibilities:

• Develop/maintain from simple to complex reports that might include sub-reports and drill down capabilities and other features supported by SSRS.
• Created OLAP cubes and calculating measures and dimension members in SQL Server Analysis Services SSAS .
• Develop/maintain from simple to complex reports that might include sub-reports and drill down capabilities and other features supported by SSRS.
• Involved in various stages of SDLC like low-level design, Coding, Testing.
• Designed SQL SSIS Packages to extract data from various data sources such as Sybase, Excel spreadsheet, and flat files into SQL Server 2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
• Involved in Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using Analysis Services.
• Wrote Package containing several Procedures and Functions in PL/SQL to handle sequencing issue.
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Created temporary tables to load the test data into the temporary tables.
• Extensively involved in writing SQL queries Sub queries and Join conditions , PL/SQL programming.
• Logical and Physical data modeling using ERWIN.
• Good knowledge of Oracle RDBMS
• Created the indexes and analyzed the table for better performance.
• Experience in building Indexes.
• Wrote both Cursors to capture many rows within a PL/SQL block.

Environment: Sybase, UNIX, SAS, SSMS

Confidential

Client Description:

• Confidential is a global service company, providing customers with access to products, insights and experiences that enrich lives and build business success.
• A leader in global payments, American Express is the largest card issuer by purchase volume and operates a worldwide network that processes millions of merchant transactions daily. We offer the broadest array of payment, expense management and travel solutions for consumers, small businesses, midsize companies and large corporations.
• Confidential contract with American Express. Merchant exposure arises out of non-delivery of goods and services to card members and disputes/returns for which American Express has already made a payment to the merchant. This exposure can be partly or fully mitigated through collaterals which would include pending payments to merchants, holdbacks, and other forms of collateral i.e. lien, letters of credit .
• The purpose of this project phase is to develop a robust reporting database for GMS risk which includes 2 reports - Executive Summary and the Daily Exposure, providing the risk team with the necessary demographic, hierarchy, Charge volume, probability of liquidation/default, exposure and recovery information in order to make accurate and timely decisions.

Role: Developer

Responsibilities:

• Involved in various stages of SDLC like low-level design, Coding, Testing.
• Design and develop complex and efficient queries and stored procedures written in T-SQL 2008R2/SQL2012, which will be used for reports, developed and deployed with SSRS 2008 or later. This includes development and support of additional data structures tables and indexes to solve the assigned tasks
• Develop/maintain from simple to complex reports that might include sub-reports and drill down capabilities and other features supported by SSRS2008 and above
• Create and maintain report subscriptions
• Develop and maintain SSIS 2008R2/2012 packages
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Created temporary tables to load the test data into the temporary tables.
• Extensively involved in writing SQL queries Sub queries and Join conditions , PL/SQL programming.
• Logical and Physical data modeling using ERWIN.
• Good knowledge of Oracle RDBMS
• Created the indexes and analyzed the table for better performance.
• Experience in building Indexes.
• Wrote both Cursors to capture many rows within a PL/SQL block.

Environment:

Confidential

Client Description:

• A hosted design time service known as the Contivo Enterprise Integration Migration Server EIM Repository .
• A Java-based graphical user interface GUI called the Contivo Analyst.
• Confidential is a global research-driven pharmaceutical company dedicated to putting patients first. Established in 1891, Merck discovers, develops, manufactures and markets vaccines and medicines in over 20 therapeutic categories. The company also devotes extensive efforts to increase access to medicines through far-reaching programs that not only donate Merck medicines but help deliver them to the people who need them. Merck also publishes unbiased health information as a not-for-profit service. With approximately 60,000 employees, Merck conducts research at 11 major research centres in the United States, Europe, and Japan, manufactures products in 32 facilities and sells products in approximately 150 countries.
• Confidential understand relationships that exist between integration metadata.
• The Contivo product is a mapping tool which is comprised of two elements:
• The Contivo Analyst is an intuitive graphical interface that is used to complete and customize maps visually. Once the map is completed, the Contivo Analyst outputs transformation code, which is then used as a roadmap for information flows in a runtime environment.
• EIM Server is the Repository, which provides subscribers the ability to share maps and manage changes.

Role: Mapping Expert

Responsibilities:

• Involved in various stages of SDLC like Requirement gathering, low-level design, mapping and testing.
• Extensively involved in Mapping between source and target systems.
• Developing functions for rule editor using procedures, functions and packages.
• Involved in testing of developed Maps.
• Involved in QC support.
• Participated in IT support.
• Involved in UAT support.

Environment: Contivo Analyst, Contivo Repository

Confidential

Project Description:

• Confidential is a product which provides the incremental data from the source system to target system. The inbound and outbound system both together forms the Match Merge product.
• Sequencing is implemented to ensure logical consistency of data. No child data is flowed without the parent record.
• Sequencing can be enabled/disabled whenever required. The value for Sequencing is set in the global context variable. Also project requirement was to improve the performance of generating incremental data.

Role: Module Lead and Oracle PL/SQL developer

Responsibilities:

• Documented test cases and test logs.
• Extensively used TOAD for database access and PL/SQL Development and SQL tuning.
• Used PRAGMA AUTONOMUOS TRANSACTION to avoid mutating problem in database triggers.
• Worked extensively on Exception handling to error handling and tracking.
• Use of Optimizer Hints to tune the Sql Queries.
• Experience with Pl/SQL Tuning using DBMS PROFILER.
• Used Explain plan for Tuning the SQL statements by creating indexes.
• Wrote both Cursors to capture many rows within a PL/SQL block.
• Experience in building Indexes.
• Experience in using packages like DBMS JOBS, DBMS SCHEDULER to schedule tasks
• Created the indexes and analyzed the table for better performance.
• Good knowledge of Oracle RDBMS
• Logical and Physical data modeling using ERWIN and Visio.
• Extensively used the advanced features of PL/SQL like collections and Dynamic SQL.
• Extensively involved in writing SQL queries Sub queries and Join conditions , PL/SQL programming.
• Wrote Materialized views and complicated queries using SQL.
• Created temporary tables to load the test data into the temporary tables.
• Involved in Creation of tables, Partitioning tables, Join conditions, correlated sub queries, and nested queries, views for the business application development.
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Wrote Package containing several Procedures and Functions in PL/SQL to handle sequencing issue.
• Created basic reports in Java.
• Involved in various stages of SDLC like low-level design, Coding, Testing.
• Involved in unit testing, integration testing and UAT.

Environment:

• Confidential EPDI will address importing trial data into CDR from all types of external vendors and will support both incremental data loads that are received through the in-life portion of a trial as well as one-time, or milestone, bulk loads.
• EPDS will accept data from non-preferred vendors, process the data and then feed it to CDR.CDR accepts data only from preferred vendors. In order to reduce the overhead on CDR EPDS system is designed.

Role: Module Lead and Oracle PL/SQL developer

Responsibilities:

• Documented test cases, test logs, and user guides.
• Good interaction with the front end application developers to understand their requirements and do the backend coding appropriately.
• Extensively used TOAD for database access and PL/SQL Development and SQL tuning.
• Used PRAGMA AUTONOMUOS TRANSACTION to avoid mutating problem in database triggers.
• Wrote shell scripts to interact with the files on the Unix server.
• Worked extensively on Exception handling to error handling and tracking.
• Use of Optimizer Hints to tune the SQL Queries.
• Experience with Pl/SQL Tuning using DBMS PROFILER.
• Used Explain plan for tuning of SQL statements by creating indexes.
• Wrote both Cursors to capture many rows within a PL/SQL block.
• Experience in building Indexes.
• Created the indexes and analyzed the table for better performance.
• Good knowledge of Oracle RDBMS
• Logical and Physical data modeling using ERWIN and Visio.
• Extensively involved in writing SQL queries Sub queries and Join conditions , PL/SQL programming.
• Wrote Materialized views and complicated queries using SQL.
• Created temporary tables to load the test data into the temporary tables.
• Extensively used the advanced features of PL/SQL like collections and Dynamic SQL.
• Experience in using packages like DBMS JOBS to schedule background processes.
• Worked on UTL FILE package for reading the text files and extracting data into tables.
• Extensively worked on parsing of XML's using DOM parser. Used DBMS DOM package for parsing.
• Wrote Java stored procedures in Oracle PL/SQL to interact with the front end applications.
• Wrote code to send the request to web service and get the response from web service.
• Involved in Creation of tables, Partition of tables, Join conditions, correlated sub queries, and nested queries, views for the business application development.
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Wrote Package containing several Procedures and Functions in PL/SQL for business application development.
• Created basic reports in Java.
• Involved in various stages of SDLC like low-level design, Coding, Testing.
• Involved in unit testing, integration testing and UAT.

Environment:

Confidential was to build a system called Match Merge which gets the data from source and provides the incremental data to the target system. Match Merge is a product. This product acts as interface between various systems. If the product acts as interface on the source side then it is called as Inbound system and if it acts as interface on the target side then it is called as Outbound system. The inbound and outbound system both together forms the Match Merge product.

Role: Oracle PL/SQL developer

Responsibilities:

1. Involved in various stages of SDLC like Coding, Testing.

• Documented test cases and test logs.
• Extensively used TOAD for database access and PL/SQL Development.
• Worked extensively on Exception handling to error handling and tracking.
• Wrote both Cursors to capture many rows within a PL/SQL block.
• Experience in building Indexes.
• Created the indexes and analyzed the table for better performance.
• Good knowledge of Oracle RDBMS
• Extensively involved in writing SQL queries Sub queries and Join conditions , PL/SQL programming.
• Created temporary tables to load the test data into the temporary tables.
• Extensively used the advanced features of PL/SQL like collections and Dynamic SQL.
• Experience in using packages like DBMS JOBS to schedule background processes.
• Involved in Creation of tables, Join conditions and views for the business application development.
• Worked on sequences, functions, synonyms, triggers, packages, stored procedures.
• Wrote Package containing several Procedures and Functions in PL/SQL for business application development.
• Involved in unit testing.

Environment:

Confidential organizations. They operate globally and deliver locally to most of the world's large multinational corporations. Adding depth to their global capability, they challenge the incumbent operator in a number of key markets for services to national businesses and governments. They are the leading providers in UK.

Project Description:

In current competitive scenario every business establishes quality process to increase their efficiency as well improves their productivity.This project deals with common data which are required by every business organisation and it also deals with inventory system of British Telecom. This project contains four types of databases i.e. Portfolio, Proposition, Order and Inventory BFG . Portfolio database contains network products related information of the British Telecom. Proposition database deals with quotation of the particular network products. When the particular quotation has been selected by the BT customer, the Order is placed and in Order Database and there after inventory is created using Inventory Database i.e. BFG.

Role: Oracle PL/SQL developer.

Responsibilities:

• Design Low Level Design documents from HLD.
• Wrote Package containing several Procedures and Functions in PL/SQL for business application development.
• Worked on sequences, functions, synonyms, triggers, packages, stored procedures.
• Involved in Creation of tables, Join conditions and views for the business application development
• Resolving ITS issues by using AR-System.
• Involve in various GAP Analysis work for different products.
• Involve in Releases for different network products of BT.
• Involved in preparing release notes and release scripts for various releases.
• Actively participate in various Conference Calls and CCB calls.

Environment:

Project Description:

This is a pricing tool, which provides quotations to the customers for various products like Cell stream, Frame Stream, Ipclear, and VPN. It gives the rental and connections charges for the customers based on the product he/she selects. It also takes into account the nearest exchange to the site. Based on the product selected and the nearest exchange, it calculates the rental and connection charges.

• The objectives of developing the Quick Quote are as given below
• To provide quotations to the customer for various products.
• To provide rental and connection charges for various products like Cell stream, Frame stream.
• To provide with the best connectivity and rental charges from the site to the nearest exchange.
• Finding out the nearest possible exchange to the site.
• To provide discounts to the existing customer based on the term and the type of product.

Role: Oracle PL/SQL developer.

Responsibilities:

• Design Low Level Design documents from HLD.
• Wrote Packages containing several Procedures and Functions in PL/SQL for business application development.
• Coding for 100M Ethernet distance based charges.
• Coding for changing the non-distance based products to distance based products.
• Converting all Non-ADSL rental charges to distance based rental charges.
• Written Script in VB for automated test combination generation.
• Written script in VB for row distance calculator test case generation.
• Exporting from front end application to CSV contents of web page to Excel sheet .
• Involved in debugging of code.

1. Involved in Testing.

Environment: Oracle 9i, VB, SQL Navigator and VSS.