Professional Summary:

• 8 years of experience as an Oracle Database Developer with a strong background in UNIX . Experienced in database and application full development life cycle SDLC , analysis and implementation of new technologies, procedural declarative code design and construction, performance tuning and the provision of twenty-four hour application support on large enterprise environments.
• Extensive experience in designing and developing Packages, Stored Procedures, Functions and Triggers using PL/SQL .
• Expertise in building applications from scratch such as defining Schema Objects, Users, Roles, Views, Materialized Views and Indexes as per the application requirement.
• Efficient in writing complex SQL queries, Hierarchical queries, use of analytical functions, Regular expressions and also aware of new features in oracle 11g.
• Experience in using Oracle in-built packages like UTL FILE, DBMS SQL etc.
• Effectively made use of PL/SQL features such as Bulk Collections/Exceptions/Inserts, Bulk Binding, Ref-Cursors, Multi Table inserts, SQL Types in Bulk Operations for better performance and readability
• Expert in database skills using SQL, TOAD for debugging applications.
• Experience creating DDL and DML scripts for data modeling changes.
• Very proficient in identifying performance bottlenecks analyzing explain plan.
• Designed and implemented various generic frameworks to Automate maintenance tasks as well as similar processing task using Shell Scripts, PL/SQL and Configuration.
• Effectively made use of Table Functions, Pipelined Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views Query Re-Write
• Extensive experience in Data Migration, ETL implemented various Extraction, Transformation and Loading architectures involving tools and technologies such as Informatica, XML, XMLDB, XML Schema, XQuery, SQL Loader, PL/SQL, Materialized views.
• Possess excellent oral / written communication and interpersonal skills.
• Good ability to quickly grasp and master new concepts and technologies.
• Strong problem solving technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.

TECHNICAL SKILLS:

Professional Experience:

Confidential

Sr. PL/SQL Developer

Description: Maujim is the fastest growing premium polarized sunglass maker in the world, Maui Jim got its start in 1980 as a small company selling sunglasses on the beach in Lahaina, Hawaii.

Responsibilities:

• Played key role in designing and implementing Strategic and Tactical sourcing of data from various systems, processing it and feeding into Data marts and various external systems.
• As part of implementing rules, developed generic shell scripts, procedure, functions, packages, table and index definitions, partition schemes considering optimal performance in terms of storing and retrieving the data.
• Extensively made use of Sql-Loader, Shell scripting, PL/SQL and Automated ControlM jobs to automate the entire Strategic Batches which were run one per region AMS, EUR PAC
• Redesigned and Developed Table partitioning maintenance framework, which in conjunction with the new tablespace strategy achieves optimal space utilization.
• Use UTL FILE to insert the data into files and stored in appropriate server path.
• Implemented parallel direct path load for loading huge files into Staging tables, which saved 20 to 30 minutes on certain jobs as part of tuning the Strategic batch to meet the SLA.
• Implemented Basel III functional rules by coordinating with BA's to understand functional specifications and prepared technical specs and given demos to Data Mart users
• Extensively involved in analyzing and tuning long running jobs in production.
• Review and modify DDL/DML scripts produced by the data modeler as per project requirement.
• Responsible for creating and managing deployments scripts and managing code merges using SVN.
• Developed the stored procedures using PL/SQL Tables and records to generate the output in XML format and pull data from Web services and from XML format and parse it and load it into tables.
• Enhancing the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Used Bulk processing for performance enhancement.
• Created UNIX shell scripts using SQL Loader, SQL Plus and PL/SQL programs that run as nightly interfaces.
• Develop and reviewed technical design documents to ensure the changes fit into existing architecture and, follow all the guide lines and all programming changes are recorded for audits and future reference
• Work closely with Testing FT and UAT teams in resolving issues while testing

Technologies: Oracle 11G, SQL, PL/SQL,Framework design, Erwin, Toad, SVN, SQL Loader and Data Modeling Shell scripting.

Confidential

Role: Oracle PL/SQL Developer

Description:

Genpact Limited is a global provider of business process and technology management services, offering a portfolio of enterprise and industry-specific services. Genpact serves clients in various industries including banking and financial services, insurance, capital markets, healthcare, life sciences, consumer goods, retail, aerospace, automotive, energy, hitech, transportation logistics, and hospitality.

Responsibilities:

• Involved in analysis, system design documentation.
• Created and maintained Tables, views, procedures, functions, packages, DB triggers, and Indexes.
• Successfully manipulated Stored Procedures, Functions, Triggers and Packages using TOAD and SQL Developer.
• Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors using oracle 10G.
• Tuned PL/SQL Packages and PL/SQL Stored Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, Explain plan and analyzing the tables.
• Involved in creating DYNAMIC SQL that will update or insert data into the tables on the run.
• Implemented Exception handling, Autonomous Transactions, Pragma Exception In it, Locks, used save points, commits rollbacks to maintain Transactional consistency database integrity.
• Wrote complex in-line Views which summarized the business needs to the fullest.
• Generate DDL/DML scripts for Table and column addition and data-type changes and implement it in the database.
• Involved in using UTL FILE Package in moving data from legacy system to Oracle Base tables.
• Involved in Migrating the entire database setup from test environment to production.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL in oracle 10g and UNIX utilities.
• Involved in the continuous enhancements and fixing of problems.
• Involved in creating Detail Design Documents for the requirements.
• Involved in formulating general methodologies, Naming conventions and Coding standards for various procedures and packages

Environment: Oracle 10g, SQL, PL/SQL, Windows/Linux, Toad, PL/SQL Developer, SQL PLUS, ERWIN, SQL Loader.

Confidential

Role: PL/SQL Developer

Description:

Michigan-based Priority Health offers a nationally recognized HMO and other group and individual health insurance plan options. Individual and family plans include MyPriority, Medicare Advantage, Medigap Medicare Supplement insurance , Michigan Medicaid and MIChild, and COBRA plans. Project Deals with maintaining all the insurance coverage's of the customers.

Responsibilities:

• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Provided ad-hoc reports for Pricing and Financial Department.
• Extensively involved in providing multi flavored Financial Packages.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL and SQL Plus.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Manipulated PL/SQL tables and VARRAYs with BULK BINDS and BULK COLLECTS.
• Tuning of I/O, which includes Separating of Data files and Redo log files on different locations, Striping of table data, and separating of tables and indexes on different locations. Reducing Disk I/O Contention etc. Applications Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS. Oracle query tuning and optimization
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed PL/SQL Procedures, Functions and Packages for Business Intelligence.
• Extensively used PL/SQL Procedures and Functions to transform data before the loading process.
• Created various ER diagrams and Dataflow diagrams using Oracle Designer.
• Responsible for creating ETL technical design for all dimensions and facts in data mart.
• Solved many call tickets which is of higher priority in the production Department.
• Extensively used ETL to load data from Oracle database.
• Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level.
• Created and tested PL/SQL blocks and UNIX shell scripts.
• Created data validation scripts in UNIX to verify the loading process.
• Created and modified SQL Plus, PLSQL and SQL Loader scripts for data conversions.

Environment: SQL, PL/SQL, Oracle 10g/11g , TOAD, SQL Navigator, Informatica, SQL LOADER, UNIX.

Confidential

Role: Oracle PL/SQL Developer

Description:

New breed is a third party logistics company that brings new levels of visibility and control to complex lo logistics. Operations with the intelligent application of systems to reduce and automate process steps across supply chain.

Responsibilities:

• Involved as a key team member for Requirement Analysis during the design phase and interaction with the client.
• Involved in writing backend Packages extensively in PL/SQL.
• Involved in Code Reviews and preparing Unit test cases.
• Used Quest code tester for Oracle, a component of Toad used to identify and eliminate the costly bugs and functional errors and used right data model for the data mart based on the requirements.
• Used web services manager for policy management and security of service infrastructure.
• Maintained the data integrity and security using Integrity Constraints and Triggers.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Used Oracle Exadata database storage servers to reduce IT costs through consolidation, store up to ten times more data, improve performance of all applications, deliver a faster time-to-market by eliminating systems integration trial and error, and make better business decisions in real time.
• Defining and reviewing the coding standards besides reviewing the code.
• Created, debugged and modified Stored Procedures, Triggers, Tables, Views and User-Defined Functions.
• Extensively involved in preparing Detailed Technical Documents from the functional specifications.
• Used Key files to hide certain parameters from users and added key mapping entries to a key map file.
• Preparation of Checklists, identification of Test Cases and preparing Test Plans.
• Actively Involved in Integration and Deployment in Production Environment.
• Customization of code as per the user requirements.
• Involved in the analysis of the existing database.
• Designed and extensively worked on Project Documentation.
• Separating Tables and Indexes on different locations for reducing Disk I/O Contention.
• Extensively used EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE and HINTS.
• Used Bulk Binds and Bulk Collect.
• Designed Pragma Autonomous Transactions.
• Implemented External tables and created Sequences to generate numbers on the fly.
• Co-ordination between Development, Testing and Production teams and attending bridge calls and technical discussions regarding future developments and releases.

Environment: Oracle Database 11g, TOAD, Microsoft Windows Server 2008 R2, UNIX, PUTTY, PVCS, WinSCP, UNIX.

Confidential

Role: Oracle PL/SQL Developer

Description:

Confidential is one of the industry leaders with an estimated seven per cent of the world's pharmaceutical market with a huge selling force grouped into several layers collectively called Territory Universe. The Customer Alignment Table CAT will identify the Total Territory Universe or Compensation Universe for each territory in each selling team, i.e. an explicit listing of all customers physicians and/or accounts, depending upon the selling team that are within each territory's alignment for compensation purposes.

Responsibilities:

• Responsible for Development, Enhancement, Support and Maintenance of the aCAT, pCAT and CDF applications
• Effectively Re-factored existing Code/Design and various Process to meet the system specifications and fit into weekly, Monthly and Quarterly cycle windows leaving certain amount of Buffer to investigate or re-run when necessary
• Responsible for Enhancing and maintaining CAT UI screens for monitoring jobs, and provided various monitoring and activity reports
• Responsible for maintaining and running Informatica mappings and Sessions to extract and load data from CAT to central repository.
• Extensively worked on UTL FILE Packages in Reading and Writing Data to Flat files.
• Made use of advanced features such as Analytical Functions, Model Clause and Table Functions, Multi table inserts of 10G to improve Efficiency, Readability and maintainability of Code
• Effectively made changes to DATA-MODEL to support various weekly and Ad-Hoc reports by gaining significant increase in performance
• Defined Views and Materialized views for simplifying reporting queries and performance also effectively made use of Query re-write where that change in view or objects has a significant impact on downstream system
• Performed Query optimization and PL/SQL tuning to maximize performance
• Created rerun able shell scripts for meta data creation and maintenance
• Responsibly followed build and release process
• Prepared test data, test cases

Technologies: Oracle 10G, SQL, PL/SQL, JAVA, JSP, JS, WebLogic10, Table Partitioning, TK-PROF, Informatica, Shell Script, Erwin, Toad, Clear Case, SQL Loader

Confidential

Role: Sr. Oracle PL/SQL Developer

Description:

This project involves developing and maintaining various complex PL/SQL jobs. Developed Oracle Stored procedures to build and execute the Global Functions Allocation model, which is critical for CITI's expenses modeling for a large Business group. Achieved good understanding of financial modules and heir process flow. This proved pivotal as gathering requirements and understanding the business model was critical for the final delivery.

Responsibilities:

• Designed and Developed Global Function Allocation model for POC system using Oracle PL/SQL.
• Involved in data Maintenance and Support which uses Oracle 10g database, SQL, PL/SQL, SQL Loader, Shell Scripts, Business Objects in windows NT and Unix environment.
• Extensively involved in using PL/SQL to built Oracle Packages, stored procedures, functions, triggers, cursors, Oracle Reports10g and views for processing data, enforcing referential integrity and needed business rules.
• Code optimization/Performance tuning Involved in performance management of various PL-SQL reports queries.
• Developing various reports using Oracle Pl/sql. Also fine tuned the reports queries to help save redundant database queries and thus save report execution time.
• Working directly with reporting to Customers to understand the requirements.
• Production support for Allocations Processing system.
• Developed database compare tool to negate manual intervention for database object comparison during data copy to data warehouse/reporting environment. It provides a list and DDLs of Tables, Indexes and Views, which are different among the source and target systems, thus saving considerable time.
• Implemented various process improvements within the team to enhance customer-vendor relationship.

Environment: Oracle 10g, SQL, PL/SQL, Linux, C, SQL, and PL/SQL, ORACLE, TOAD, UNIX shell script, Editors and Debuggers.

Confidential

Oracle Developer

Cash Management System eDividends

Description: eDividend provides End-to-End solution to process Dividends. This Product provides Dividends Processing facility to bank on behalf of various customers such as corporate customers and registrars to distribute dividends to their investors/beneficiaries. It interacts with the various systems within the bank such as charges, checks processor, Integrator, Reports for various operations to complete the transactions processing and finally sends the accounting entries to the host system through MQ.

Responsibilities:

• Involved in Requirement Analysis and developing the Project Definition Document.
• Responsible for developing XML documents to generate SQL dynamically for all the business roles.
• Used XDB UTILITY packages to load XML documents into database tables.
• Worked with CLOB and LOB data types to load large XML documents into database tables.
• Responsible for developing PL/SQL database objects like Functions, Procedures and Packages.
• Developed a PL/SQL conversion program and SQL Loader program for validating and migrating the legacy agents information into Oracle base tables.
• Involved in Performance Tuning of various custom PL/SQL reports and PL/SQL packages.
• Extensively wrote PL/SQL code to customize various forms pertaining to Contracts and Data load.
• Highly involved in high-level database design, defining table structures, laying out ER- Diagrams, helped in building the physical Complex PL/SQL procedures and functions and packages are developed to adhere to the specifications of the application.
• Used Dynamic SQL and autonomous transactions for error handling.
• Involved in developing materialized views, views, synonyms and dblinks to access data across schemas, indexed to gain performance.
• Worked on Query Optimization Techniques for complex SQL Statements. Used Performance Monitor and Explain Plan for performance tuning to enhance the performance of databases.
• Created Records, PL/SQL Tables, Objects, Collections Nested Tables and Arrays , and Error Handling.
• Developed UNIX shell scripts for job scheduling.
• Run batch jobs for loading staging tables from flat files using SQL Loader.
• Involved in unit testing the application code and database code for data integrity and application functionality.
• Debugged Packages, Procedures, and Functions and fixed them according to the business requirement.
• Tuned the existing SQL queries to improve the performance.
• Involved in the Data Modeling phase of the application.
• Also written UNIX shell scripts to automate the nightly data load from third party servers.
• Technologies: Oracle10G, PL/SQL, SQL, XMLDB, Java, JSP, XML, HTML, Java Script, JDBC, HP-UNIX, Ant, Web logic8.1

Confidential

Role: Oracle PL/SQL Developer

Description:

Confidential is the company that takes complete charge the overseas marketing and technology transfer of Korean excellent new-technology to overseas. This project is aimed at Customer Information Management System. The system handled new account enrollment and updating existing accounts.

Responsibilities:

• Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables using both UTL and SQL Loader for different cases
• Explain Plan, TKPROF was used for checking the performance of queries
• Modified and updated existing custom forms to adapt to new database schema
• Created SQL scripts for conversion of legacy data including validations and then load it into the tables
• Developed SQL Loader programs PL/SQL scripts to load legacy data into Oracle Apps.
• Developed PL/SQL programs for various modules to validate data while importing into oracle system.
• Participated in database development like creating PL/SQL triggers, packages, procedures function.
• Handling errors using Exceptions.
• Extensively worked on UTL FILE Packages in Reading data from data files and put them in database tables.
• Knowledge of Normalization, and data transfer, documentation, preventive maintenance, code review, automation, store procedures and triggers etc.
• Performed exception handling for data that did not conform to the required format.
• Responsible for making the merged data in turn available to other clients.
• Wrote UNIX scripts to automate loading files into database using error handling and notification.
• Involved in implementing the data integrity validation checks through constraints and triggers.

Environment: Oracle Database, PL/SQL, SQL Loader, SQL.