SUMMARY

• 12+ years of experience as an Oracle PL/SQL and ETL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Have in - depth knowledge inData analysis, Data warehousingandETL(Extract Transform and Load) techniquesand TOAD.
• Experience in maintenance, enhancements, performance tuningofETL code.
• Has ability to learn and implement new industry leading technologies.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines
• Proficient in database modeling, Data extraction and storage logic building, Convert the business requirement into technical solutions
• Expertise in Client-Server application development on database versions Oracle 11g/10g/9i, Using PLSQL Developer, SQL *PLUS, TOAD and SQL*Developer
• Good knowledge on logical and physical Data Modelling using normalizing Techniques
• Proficient in writing Stored Procedures, Functions, Packages and Triggers using PL/SQL
• Enforcing security by creating roles, granting system and object privileges on the tables, stored procedures
• Proficient in Oracle Data base design with relational models and very good experience in entity and attribute identification and developing the Entity-Relationships
• Expertise in Oracle distributed query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF and Hints provided by oracle
• Expertise in using Oracle PL/SQL Collections, Bulking techniques, Analytical Functions, Hierarchical Queries, Partition utilization to increase performance
• Automating data loading, extraction, reports generation using UNIX Shell scripting
• Efficient in Optimizing, Debugging and testing SQL queries, views and stored procedures written in Oracle and SQL Server
• Developed materialized views for data replication in distributed environments
• Managed project Application End to End and customer interaction for the new business requirements
• Excellent technical and analytical skills with clear understanding of design goals of ER modelling for OLTP and dimension modelling for OLAP
• Good knowledge of Oracle performance related features such as Query Optimizer, Execution Plans &Indexes
• Experience of Database Architecture for OLAP and OLTP Applications, Database designing, Data Migration, Data Warehousing Conceptswith emphasis on ETL
• Actively involved in capacity planning, creating views, materialized views, partitioning tables and creating indexes etc for optimization process
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Created Shell Scripts for invoking SQL scripts and scheduled using AUTOSYS
• Knowledge of Principles of Data Warehouse using Fact Tables, Dimension Tables and Star/Snowflake schema modelling
• Having good knowledge in ETL and OOPs languages
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team

TECHNICAL SKILLS

Operating Systems: Windows XP, NT,2000 Server/Professional, HP Unix, Linux

Databases: Oracle 11g/10g/9i, SQL and PL/SQL SQL Server 2012

Languages: Oracle SQL, PL/SQL, Unix Shell Scripting

Object Oriented Language: Java, C++, .Net

Cloud Integration Tool: Knowledge in Dell-Boomi

Application Integration Tool(ETL): Talend

Reporting Tool: Crystal Report

Development Tools: SQL * Plus, SQL * Developer, PLSQL Developer, Toad

Configuration Management Tools: VSS, Clear Case, PVCS, SVN

Defect Tracking Tool: Jira, Footprint, Clear Quest, Service Now

PROFESSIONAL EXPERIENCE

Confidential, OK

Sr. Oracle PL/SQL Developer

Environment: Java, SQL Server 2012, Oracle 10g, Forms Builder 11g, Reports Builder 10g,PL/SQL, TOAD, UNIX Shell Scripting,WINDOWS XP, MS Visio, Talend.

Responsibilities:

• Created heavy stored procedures for financial transaction by using procedural parameters & worked with packages, blocks & exception handling
• Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.
• Developed PL/SQL packages for generating various feeds from oracle database using UTL FILE utility in the client’s secure data transmission server
• Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes
• Used SQL*Loaders to download the data into database from the text files and spread sheets
• Extracted data from the XML files transmitted to the bank and loaded them efficiently into oracle temp tables for day to day customer financial transaction reconciliation
• Developed UNIX scripts for sending mails to the bank and the business team, when the external feeds to the bank are received
• Involved in supporting/fixing production defects and day to day business transaction issues
• Used SQL Navigator, a popular tool which increases user productivity, to manage database objects, develop and debug PL/SQL code and to create, execute and optimize SQL queries
• Developed various new reports from scratch utilizing Oracle Reports 10g for day to day validations
• Created and monitored the Oracle DBMS JOBS as a part of weekly tasks
• Design, develop, implement, and assist and in validating ETL processes
• Did unit testing and development testing at ETL level in custom mappings
• Created various adhoc reports as of when required for the production analysis and bug fixing.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL
• Used pipelined functions for faster data accessibility
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance

Confidential, IA

Sr. Oracle PL/SQL Developer

Environment: Java, SQL Server 2012, Oracle 9i/11g SQL, PL/SQL, Forms Builder 6i/10g, Reports Builder 10g, SQL*Loader, SQL Navigator, Crystal Reports, Toad, Talend, MS Visio, Unix Shells Scripts

Responsibilities:

• Analyzed and created the functional & technical specification document for various objects involved in the project. Discuss with business users, BA's and UI Architects to finalize requirements and scope of the project
• Created new tables, views, materialized views, Packages, Stored Procedures and functions as per the business requirements
• Created new Informatica Mappings as required
• Perform unit testing, code review and made changes/improvements to the SQL/PLSQL scripts as required for better performance
• Optimized the code to meet SLAs with UI. Used Hints like materialize, parallel, no parallel, etc., to improve the performance
• Maintain SVN repository, deploy code base to SIT, QA, UAT, dry-run environments as requested
• Plan production deployment activities, ITSM processes, raise RFCs and coordinate with various teams including DBA Team, UNIX Administrators, Informatica Administrators and developers etc
• Developed comprehensive test plans, scripts and cases and performed unit and comprehensive testing with system developers to ensure overall functionality and technical quality of deliverables
• Developed UNIX shell scripts with embedded SQL Loader and PLSQL statements to extract data from the legacy application in the form of flat files and load into current database
• Performed activities like troubleshooting technical issues and problems, monitor progress against plan, and communicate status to Leads
• Created tables, Correlated sub queries, Nested Queries, Views, Dynamic SQL for Business Application Development
• Developed back end Confidential using PL/SQL Packages, Stored Procedures, Collections
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc. Designed Database Triggers for audit and validation purpose
• Knowledge in Shell scripting to automate system administration jobs as per Business requirement and applying the changes after creating a change control

Confidential, MD

Sr. Oracle PL/SQL Developer

Environment: .Net Oracle Database 9i, Windows XP, TOAD, SQL*Loader, Oracle Forms Builder 10g, Reports Builder 10g, SQL Navigator, PL/SQL

Responsibilities:

• Prepared Systems Requirement Specification Document and Technical requirement specifications as per the client requirements
• Preparation of class structure and sequence diagrams using Rational Rose
• Used cursors and collections for accessing complex data resulted from joining a large number of tables
• Extracted data into comma or pipe delimited files using UTL FILE package/utility
• Involved in testing backend SQL queries for query optimization
• Developed several packages that are used in oracle forms and reports
• Involved in GUI designing using Oracle Developer 10g (Forms 10g and Report 10g)
• Developed stored procedures and triggers to facilitate consistent data entry into the database
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities
• Developed Installation scripts for all the deliverables
• Performed functional testing for different Oracle Forms application functionalities
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose
• Extensively utilized TOAD for performance tuning by generating explain Plans
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages
• Tuned the applications to enhance the speed by utilizing Indexing, SQL HINTS and Materialized Views
• Developed complex SQL queries to perform the back-end testing of the Oracle database using SQL and UNIX shell commands
• Interacted with the user group on a regular basis to discuss requirements and updates

Confidential, TX

Sr. Oracle PL/SQL Developer

Environment: Oracle 9i, 10g SQL, PL/SQL, Forms Builder 6i, Reports Builder 6i, SQL*Loader, SQL Navigator, Crystal Reports, Toad.

Responsibilities:

• Worked with the client team in understanding the business processes to prepare the business requirements definition document
• Used PL/SQL collections (Nested Tables and Varray) in complex backend packages
• Coded UNIX shell scripts to call SQL scripts and to manipulate the returned data
• Developed test plan documents for all back-end database modules
• Extensively worked on Explain Plans and various hints for Performance tuning
• Wrote Database triggers for audit and to implement complex business logic
• Discussed and analyzed business functionality with the client and the developers
• Involved in the database design for better understanding the relations, associations and dependencies within the data base
• Created bitmap indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space
• Involved in authoring writing functional and technical documents
• Generated SQL scripts for crating tables, Views, Primary keys, Indexes, Constraints, Sequences, views and Synonyms
• Developed and modified PL/SQL packages, procedures, functions as per customer requirement to make new enhancements or resolve problems
• Wrote complex SQL queries to retrieve information from the database depending on user requirement.
• Created PL/SQL program units to implement DML, DDL statements using dynamic SQL
• Wrote control files and loaded the data into oracle database with SQL*Loader
• Implemented Materialized View for extracting the data from remote database and created Database Links as of when required
• Handled various Exceptions to trouble-shoot PL/SQL code

Confidential

Oracle PL/SQL Developer

Environment: Oracle 9i, 10g SQL, PL/SQL, Forms Builder 6i, Reports Builder 6i, SQL*Loader, SQL Navigator, Crystal Reports, Toad.

Responsibilities:

• Created PL/SQL program units to implement DML, DDL statements using dynamic SQL
• Wrote control files and loaded the data into oracle database with SQL*Loader
• Implemented Materialized View for extracting the data from remote database and created Database Links as of when required
• Handled various Exceptions to trouble-shoot PL/SQL code
• Performed developed and documented systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality
• Created test documents, performed unit, End to End and User Acceptance Tests
• Performed developed and documented systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality
• Created test documents, performed unit, End to End and User Acceptance Tests

Confidential

Oracle PL/SQL Developer

Environment: Oracle 9i, 10g SQL, PL/SQL, Forms Builder 6i, Reports Builder 6i, SQL*Loader, SQL Navigator, Crystal Reports, Toad.

Responsibilities:

• Worked with the client team in understanding the business processes to prepare the business requirements definition document
• Used PL/SQL collections (Nested Tables and Varray) in complex backend packages
• Coded UNIX shell scripts to call SQL scripts and to manipulate the returned data
• Developed test plan documents for all back-end database modules
• Extensively worked on Explain Plans and various hints for Performance tuning
• Wrote Database triggers for audit and to implement complex business logic
• Discussed and analyzed business functionality with the client and the developers
• Involved in the database design for better understanding the relations, associations and dependencies within the data base
• Created bitmap indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space
• Involved in authoring writing functional and technical documents
• Generated SQL scripts for crating tables, Views, Primary keys, Indexes, Constraints, Sequences, views and Synonyms
• Developed and modified PL/SQL packages, procedures, functions as per customer requirement to make new enhancements or resolve problems
• Wrote complex SQL queries to retrieve information from the database depending on user requirement.