SUMMARY

• Around 8 years of total experience as an Oracle PL/SQL developer with design, development, and testing of business applications such as OLTP, OLAP, Enterprise, web based, Client/Server architectures.
• Expertise in SQL and PL/SQL programming and strong Knowledge on oracle architecture and database design.
• Strong knowledge of Oracle 9i/10g/11g, PL/SQL, SQL Server.
• Solid experience in vertical segment Investment Banking, Retail management system, Financial management system, Manufacturing, Engineering and Insurance.
• Good knowledge in RDBMS concepts and constructs along with writing SQL, PL/SQL modules like functions, stored procedures, cursors (Implicit, Explicit, REF) packages, triggers, indexes, collections(Nested tables and Varrays) and materialized views.
• Expert in Oracle Import/Export utilities, Oracle SQL* Loader, SQL Developer, SQL*Plus, TOAD, ETL Process and Data Migration.
• Experience in optimization of SQL statements using SQL Trace, TKPROF and Explain Plan.
• Experience in performance Tuning using various types of Hints, Partitioning and Indexes.
• Providing assistance in logical/physical data modeling using ERWIN.
• Experience in source systems analysis and data extraction from various sources like Flat files, Oracle, DB2, and MS SQL Server.
• Extensive experience developing External tables and using Oracle utility tools like SQL*Loader, Import and Export on UNIX platforms.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
• Experience in developing and modifying existing UNIX shells scripts and scheduling the jobs using Autosys, Control - M and monitor the batch processing.
• Experience in providing 24x7 production support.
• Experience in Unit testing and Integration Testing with excellent debugging skills.
• Strong understanding of Data Warehousing (Including Star Schema, Snowflake Schema) and Extraction Transformation Loading (ETL).
• Experience in SQL Server DTS package design, development, and deployment.
• Assisted DBA in performing various DDL works like Creation of Schemas, tables, Indexes, Materialized Views, and Partitioning tables.
• Implemented various Error/Exception handling methods using system defined exceptions and user defined exceptions.
• Knowledge on Core JAVA concepts like multithreading, Exception handling, JAVA collection framework.
• Expertise in Java technologies like Servlet, JSP, JDBC, XML, HTML, CSS and JavaScript
• Experience in using IDEs Eclipse, Net beans.
• Good Understanding System Development Life Cycle (SDLC) experience adhering SO5 Complaint with Agile Scrum Methodology.
• Good Knowledge on Data Virtualization tools Denodo Platform in design and building Virtual Data Services
• Excellent experience in creating Test Cases, Test Plans, Technical Design Documents and Functional Design Documents.
• Proficient in UML methodologies in preparing use case, sequence, class and interaction diagrams.

TECHNICAL SKILLS

Databases: Oracle 9i, 10g, 11g, SQL Server 2000/2005, MySQL, Microsoft Access

Oracle Software: TOAD, SQL *PLUS, SQL*Loader, SQL Developer

Software's: MS Visio, MS Office, Informatica, Eclipse, JIRA.

Scripting: HTML, CSS,XML, UNIX Shell Scripting

Operating System: Windows 2003/XP/VISTA, Linux, UNIX.

Programming Languages: PL/SQL and SQL, Java

Version Control Tools: CVS, Clear Quest, Clear Case, Subversion (SVN), Perforce

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

Sr. Oracle PLSQL Developer

Responsibilities:

• Developed various database objects like tables, schemas, views, packages, stored procedures, triggers, functions etc., using TOAD.
• Developed SQL*Loader scripts to load the data from external flat files that are exported from SQL Server.
• Debugged existing code for business logic issues.
• Involved in developing scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
• Created several Materialized views and refreshed them as per the customer requirements.
• Developed UNIX scripts to save Oracle concurrent program outputs and sending them as an email attachments.
• Developed materialized views which are used by the Customer Web User Interface to enter their transactions.
• Developed various Custom PLSQL reports, Customized existing reports according to the functional specifications.
• Developed several XML Publisher reports and developed custom shell scripts to email the report outputs.
• Involved in XML parsing and loading XML files into the database.
• Involved in using of new features of Oracle 11g like Analytical functions, flash back Query, regular expressions etc.
• Involved in the restructuring and fine tuning of the existing SQL Queries according to the new requirement using TKPROF, AWR.
• Used UTL FILE package for writing DBMS OUTPUT messages to file.
• Developed a custom code to send time sensitive notifications as text messages to the customer’s mobile device.
• Created complex Stored Procedures and PL/SQL blocks with optimum performance using Bulk Binds (BULK COLLECT & FORALL), Inline views, Reference cursors, cursor variables, dynamic SQL, v-arrays, external tables, nested tables, etc.
• Create Triggers, Functions, Packages to provide backend security and data consistency.
• Create tables, indexes, sequences, other constraints as per the Client Standards into the correct Schema and Table Spaces.
• Involved Copying data from Production to Lower environments replacing all customer sensitive information with dummy data.
• Coordination with the access control team to grant the correct roles/grants to the user belonging to different groups.
• Developed new Forms and customized existing forms as per Client requirement in Custom modules.
• Provided production support for critical business issues and training to end users.
• Writing Adhoc reports for the support of day to day activities in Production.
• Write Data Fixes and Migrate for the fixing of the issues.
• Responsible for performing Code Reviews.
• Extensive knowledge in performance tuning the queries and development, built indexes as part of tuning and optimization.
• Worked with dynamic SQL, developed many procedures and function with dynamic SQL.
• Worked in resolving the production issues. Developed lot of new scripts and changed few existing scripts to solve the issues.

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

Confidential, Chicago IL

Sr. PLSQL Developer

Responsibilities:

• Developed and Scheduled Auto Sys batch Jobs.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Partitioned the fact tables to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Performing ETL operations using Informatica Power centre.
• Worked on Informatica Power Centre tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting.
• Developed UNIX and shell Scripts.
• Ensure change tickets are in place well in advance of deployment and well documented.
• Ensure code versioning and backups are maintained and in sync with production environments.
• Ensure SLAs are met as per agreed upon timelines with users.

Environment: UNIX, Oracle 11g, Windows XP, Unix, SCM Tool kit, putty, Toad 9.2.1, PLSQL Developer, Informatica Power centre 8.6.1, SharePoint, Perforce

Confidential, NY

PLSQL Developer

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 11G, SQL, PL/SQL, Framework design, Erwin, Toad, SVN, SQL Loader and Data Modeling & Shell scripting, Windows XP.

Confidential

PLSQL Developer

Responsibilities:

• Worked on various interfaces and conversions during this project.
• Designed an interface program using the SQL* Loader program for importing the capital budget information from legacy systems and run the BUDGET import program for loading the data into base tables.
• Developed Packages to validate raw data from Flat Files and insert into tables.
• Involved in the data transfer, coding using PL/SQL Stored Procedures and Packages.
• Developed and integrated number of interface programs for porting legacy data into Oracle Database using SQL, PL/SQL and SQL*Loader as a tool.
• Designed and Developed PL/SQL Packages to import legacy information into Oracle.
• Converted pricing information from legacy systems into Oracle applications using SQL*Loader and pricing API.
• Documented all the conversions according to the AIM documentation standards.
• Designed and developed conversions to sustain Business Rules and Flow.
• Developed back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers.
• Used PL/SQL Tables and Records in payroll generation process.
• Developed Forms (like invoicing, Delivery order) and Reports using Oracle Reports and PL/SQL.
• Involved in database development by creating PL/SQL Functions, Procedures, and Packages, Cursors, Error handling and views.
• Customized Customer Transaction Analysis Report to change its layout like changing size of the fields, adding some extra field into the display, changing the display of the Report. Writing after Parameters Triggers for the Validation of the data.
• Developed various reports like Change order budget distribution report, Change Proposal Request, Change Position Report and AR History by project, Auto Status Report and Invoice Register Report.
• Developed Forms for mass update of customer profiles and profile amounts.
• Customized the Bills Receivable Transaction Batches form.
• Used the FTP commands efficiently to migrate the files and logs have been created successfully in proper directories on completion of the transfer process Defined Concurrent programs, Executable and Request Sets for the SQL scripts and attach the same to proper request group.
• Involved in Troubleshooting production problems and worked effectively with other team members to identify and address problems.
• Involved in Creating oracle database, tables, materialized view, objects with storage parameters based on quarterly growth requirements of the system .
• Altered, modified, Partitioned, dropped, created Database objects daily on a 24 X 7 production, Development, testing environments using TOAD and OEM .
• Worked with MD.050, MD.070 and CV.060 documents for Development work done.
• Involved in design, coding, development, documentation and post production support.

Environment: Oracle Database 10g, Oracle Forms 6i, Oracle Reports 6i, Windows 2000, Windows NT, UNIX, TOAD, Oracle SQL Developer, PLSQL Developer, Putty, Microsoft Outlook, Microsoft office 2000.