SUMMARY

• Over 13 yearsof programming experience as anOracle PL/SQLDeveloper in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Significant experience & demonstrated proficiency in all aspects of database programming on Oracle SQL / PL/SQL and/or related technologies that encapsulate SQL, including Cursors, Ref - cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Table Indexing.
• Ability to interpret the requirements and build Logical and Physical Relational Data Models
• Prepare the PL/SQL Requirements and Design documents
• Write/maintain SQL and PL/SQL stored program units/packages and maintain coding standards. Experience in Query optimization, debugging, and performance tuning for improving performance.
• Expertise in Oracle SQL, PL/SQL. Skilled in Application development using Oracle Forms and Reports with knowledge inmaster-detail blocks,forms triggers,system variables, multiple form applications, menus, alertsandLOV's.
• Good knowledge onUpgradingOracle Forms Reports.
• Write unit tests (document and code) for the PL/SQL stored program units/packages
• 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
• 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
• Knowledge in domains like Investment Banking (Security/Money Market), Capital Market, Insurance and Automobiles.
• Have good onshore exposure with clients.
• Certified Agile Scrum Master (EXIN).
• Oracle certified Professional PL/SQL and ITIL Foundation certified.
• MongoDB for Developers (M101P) - Course completed through MongoDB, Inc.
• CRUD (Creating, Reading and Updating Data) - Mongo shell, query operators, update operators and a few commands
• Schema Design - Patterns, case studies and tradeoffs
• Using indexes, monitoring and understanding performance. Performance in sharded environments.
• Goals, the use of the pipeline, comparison with SQL facilities.

TECHNICAL SKILLS

Databases: Sybase, Oralce 11g/12c and MS SQL Server 7/2005/2008/2012, Mongo DB, NO Sql

Languages/Utilities: SQL, PL/SQL, T-SQL, Unix Shell Scripts, XML

ETL Tools: Informatica 9.0.1 and SQL Loader

Scheduling Tools: CA Unicenter 3.0 and AutoSys r11.3

Programming Language: C, Perl and Shell Scripting

Operating System: UNIX (HP and AIX and Linux) and Windows

Database Tool: SQL Developer, SQL Navigator and TOAD

PROFESSIONAL EXPERIENCE

Project/Technical PLSQL Lead/Developer

Confidential -Houston, TX

Responsibilities

• Writing store procedure, function, triggers and packages.
• Created/modified oracle ETL procedures, packages and functions to move the change data across multiple environments using DB links.
• Created bitmap indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space
• Involved in tuning ETL PLSQL packages and SQL queries, views by passing hints and analyzing them using plan table and created indexes if needed.
• Created heavy stored procedures for insurance transaction by using procedural parameters & worked with packages, blocks & exception handling
• Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with invoker’s privileges.
• Develop a best practice or standards document for Oracle 10g/11gForms/Reports application development.
• Performance tuning of existing Oracle forms as well as newly created Oracle forms using different built-in as well as User-defined functions and procedures.
• 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
• Job library table defined through which the DBMS Job handled in a scheduled manner - crontab way for scheduled.
• The mail alert for job failure notification procedure designed to efficiently to meet out SLA.
• Used SQL*Loaders to download the data into database from the text files and spread sheets
• Developed UNIX scripts for sending mails to the bank and the business team, when the external feeds to the third-party data 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
• 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

Environment: Oracle Database 11g, Sybase ASE 12, SQL*Loader, SQL Navigator, PL/SQL, Java, UNIX, Ant, Forms 10g/11g, Form Builder 10g/11g, Reports 10g/11g, Form Builder 10g/11g

Oracle DBA / PLSQL Developer

Confidential, Colorado Springs, CO

Responsibilities

• Data migration script developed to convert Sybase T-SQL to Oracle PL-SQL
• Code refactoring done using the SQL Developer Scratchpad utility for some portion and rest to continue detail code walkthrough.
• Using hints, the performance bottleneck identified handled effectively.
• Preparation of Unit test plan, test cases and helping QA team testing post migration behavior as expected.
• Wrote core java program for data extracted for effective comparison for data quality.
• Identifying the long the running query and arresting the issue permanently.
• Preparing wrapper script using SQL commands to help out QA team for easy testing migration activity.
• 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
• Involved in authoring writing functional and technical documents
• 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
• 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

Environment: Oracle Database 11g, Sybase ASE 12, TOAD, SQL*Loader, SQL Navigator, PL/SQL, Java, UNIX, Sub Version

ETL / PLSQL Developer

Confidential

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
• Developed views to facilitate easy interface implementation and enforce security on critical customer information
• 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 interfaces 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

Environment: Oracle Database 10g, Windows XP, TOAD, SQL*Loader, SQL Navigator, PL/SQL, Unix Scripting, XML, HP UNIX, PowerBuilder 7.0.3 and 11.5, Unicenter 3.0, Autosys r11.3

SQL DBA/Developer/Analyst

Confidential

Responsibilities

• Tracking log shipping activities across servers and implemented in Back office DB server.
• Played application SQL DBA role with server configuration.
• 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
• 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

Environment: Oracle 8, 9i SQL, PL/SQL, SQL*Loader, SQL Navigator, MS SQL Server 7/2000, T-SQL