SUMMARY

• 13+ years of experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Having 3 years of work experience in software development for Informatica Data Quality (IDQ 10x).
• Excellent knowledge in SQL, PLSQL, Linux Scripting, IDQ, Oracle Forms, Oracle apps 11 and R12
• Knowledge of Unix, HTML, Business Objects, Xml, JavaScript, Oracle E - Business Suite 11.5.9, R12(Oracle Apps), Golden Gate, Qlik sense, AWS EC2, Teradata
• 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 Concepts with 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 ESP Agent

TECHNICAL SKILLS

Operating Systems: Windows 10, XP, RHEL Linux

Databases: Oracle 12C/11g/10g/9i, Postgre, Teradata Languages Oracle SQL, PL/SQL, Unix Shell Scripting, HiveQL ETL Tools Informatica Data Quality10.2 Reporting Tool Qlik sense

Development Tools: SQL * Plus, SQL Developer, PLSQL Developer, Toad, Super putty, IDQ 10.2 developer-Analyst

Configuration Management Tools: Stash, PVCS, SVN

Defect Tracking Tool: Jira, HP QC

PROFESSIONAL EXPERIENCE

Confidential, Irving TX

Sr. Oracle PL/SQL Developer

Responsibilities:

• Written PL/SQL Procedures, Functions, Packages, and SQL Scripts using Oracle SQL and PL/SQL sync data between oracle DRM and PeopleSoft systems.
• Created database triggers, sequences, stored procedures, and other database objects using Toad.
• Developed data model, PL/SQL Queries, SQL Query tuning process, and Schemas. Create Oracle external tables which will read data from GPH file feeds
• Writing PLSQL package to compare GPH feed with previous month feed.
• Developed UNIX scripts to generate the delta file with help of Oracle procedure and mail the delta file to user community
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Performed SQL, PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, TKPROF and DBMS PROFILER.
• Used AUTONOMOUS TRANSACTIONS to create procedure which was used to debug the failures.
• Created ROW LEVEL triggers to log the changes wherever there is any new INSERT/UPDATE happens on the event table
• Implemented Constraints on tables for maintaining Data Integrity
• Provided Read only grants on the tables to reporting schemas.
• Creates List PARTITIONS to make the data deletion faster by swapping the partitions
• Schedule Linux script in ESP scheduler.
• Involve in Spinning AWS - RDS instance which we might need to use for quick resting. Also, the dehydration of EC2 instances.
• Involve in SIT and UAT code promotion and support testing.
• Involve in Production code migration and post production support.
• Used SQL*Loaders to download the data into database from the text files and spread sheets
• Developed UNIX scripts for sending mails to the business team
• 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 Qlik Sense for monthly validations
• Created and monitored the Oracle DBMS JOBS as a part of weekly tasks
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance
• Design, develop, implement, and assist and in validating ETL processes using Informatica Data Quality to write new business rules and mapping.
• Did unit testing and development testing at ETL level in custom mappings

Confidential, Cary, NC

Sr. Oracle PL/SQL Developer, ERP developer

Responsibilities:

• Quoting system allows Confidential Partners to get the quotes for their deals. System also allows Distributers, Account managers, Customer support representative to login and book the deals.
• Analyzed and created the functional (FSD)& technical specification document (TSD) 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 database triggers, sequences, stored procedures, and other database objects using Toad as mentioned in TSD
• Write PL/SQL Procedures, Functions, Packages using PL/SQL which will be consumed by the JAVA applications
• Developed dynamic validations for entire application using EXECUTE IMMEDIATE and master table
• Developed emailed notification package for the entire project with the help of DBMS XMLGEN and enabled GOLDEN GATE to the notification table so that data will be replicated in Notification system
• Optimized procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, Partitions and RESULT CACHE
• Performed SQL, PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, TKPROF and DBMS PROFILER.
• Used AUTONOMOUS TRANSACTIONS to create procedure which was used to log and debug the failures.
• Involve in SIT and UAT code promotion and support testing.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching Between SQL and PLSQL
• Involve in Production code migration and post production support.
• Loaded Data from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
• Used Tortoise SVN version management to manage various versions of the procedures and functions of the application.
• Developed several back-end Packages, Procedures, Functions and Triggers to use in multiple Forms and series of other backend programs using PL/SQL.
• Involved in supporting/fixing production defects and day to day business transaction issues
• 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 analysed business functionality with the client and the developers
• 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 Qlik Sense for monthly validations
• Scheduled Oracle procedures using DBMS SCHEDULER-JOBS as a part of daily updates
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance of procedures which are being used at UI level for Faster data fetch

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Flexcube is a core banking Solution for retail Banking. Account Officer field was developed for the Customer accounts which was helpful in tracking the customers in FLEXCUBE by an account officer. Dormancy Days maintenance was developed at the customer account which will make the
• Created technical specification document (TSD) for various objects involved in the project.
• Discuss with business users, BA's and UI Architects to finalize requirements and scope of the project
• Worked on the functional requirements and performed GAP analysis and provided alternative solutions including changes to database
• Created database triggers, sequences, stored procedures, and other database objects using Toad as mentioned in TSD
• Client has requested for an interface which should be able to receive the Incoming Swift Messages Mainly Customer Transfer type (MT103) through Flexml Interface. The Advantage of this was both FLEXML and SWIFT will use the same QUEUE’S to receive the information, the same is being achieved by writing PLSQL procedure and scheduling the same with DBMS Function.
• Implemented Flexml, EMS Interface, Funds Transfer Module, Payments Module of Flexcube. Developed Cross currency transfers feature in Payments module
• Involved in the development of below Units for Flexcube.
• 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
• Supported Flexcube, EMS interface, Flexbranch Interface and ATM
• Developed test plan documents for all back-end database modules
• Wrote Database triggers for audit and to implement complex business logic
• Discussed and analyzed business functionality with the client and the developers
• Was involved in giving solutions to Critical issues.
• Created Materialized view in Flexbrach remote database to read the data from Host database\
• Extensively worked on Explain Plans and various hints for Performance tuning
• Write PL/SQL Procedures, Functions, Packages using PL/SQL which will be consumed by the JAVA applications
• Involve in SIT and UAT code promotion and support testing.
• Involve in Production code migration and postproduction support.