SUMMARY:

• Solid technical experience of 8 + years in full software life cycle using Database tools for industries including Oracle design, development, Modeler, testing and implementation of various software projects, applications and database management systems in a variety of environments.
• Highly experienced in Planning, Analysis, Design, Development, Testing, and Deployment in a demanding and challenging environment.
• Experience working with relational databases Oracle, MySQL Experienced in UNIX Shell
• Expert in Oracle backend developer includes PL/SQL, SQL, Performance Tuning Analyst and Database Administrator.
• Experienced in creating Stored Procedures, Packages Database Triggers, Functions, Views, Synonyms, Indexes, Materialized Views, Complex queries.
• Resolving complex performance issues, Performance monitoring and SQL Tuning.
• Good experience in executing Database Administrator jobs like Database creation, Upgradation, Backups, Restore, Recovery and User security.
• Experience in Data migration Projects.
• Experience working on MySQL Server Installations, Databases, Backups, Restore, Replication and Administrative activities.
• Worked on PostgreSQL databases administrative activities.
• Experience on Redshift & AWS - RDS admin activities.
• Experience using ERdiagram, Dimensional datamodeling, Logical / Physical Design, StarSchemamodeling, Snow-flakemodeling using tools like Erwin.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelling and designs techniques.
• Decisive, energetic, focused team leader / player who lead high-performing teams through execution under the pressure of fast-paced, time-sensitive environments.
• Experience in developing new components in an AGILE environment.

TECHNICAL SKILLS:

Programming Languages: PL/SQL, Unix shell scripting, Java Script, Core Java, HTML, Oracle Forms, Reports

Database: Oracle 8i /9i /10g /11g/12c, MS-Access, Sybase, MySQL, PostgreSQL, Redshift & AWS-RDS

Database Tools: TOAD, SQL Developer, SQL *Loader

Source Control: Clear Case, Git

Others: SQL Loader, SQL * Plus, Toad, SQL Developer, SQL DBX, eclipse

WORK EXPERIENCE:

Confidential, Tulsa, OK

Oracle PL/SQL Developer

Responsibilities:

• Responsible for Gathering Requirements, Code Development and End-to-end Unit and User Acceptance Testing and Production Roll-out of Data Migration.
• Developed Complex queries on Database and developed PL/SQL Procedures to extract data from multiple tables
• Responsible for Gathering Requirements, Code Development and End-to-end Unit and User Acceptance Testing and Production Roll-out of New Loans.
• Used several Oracle predefined functions NVL, NVL2, DECODE, CASE STATEMENT, REGEXP REPLACE, REGEXP SUBSTR.
• Tuning Complex queries by converting derived tables to Common Table expressions (CTE) which will enhance query throughput.
• Tuning sql queries to enable Database process huge set of migrated Loans into NSM.
• Development, Testing of Java Code to meet business requirement and to resolve issues.
• Performance monitoring and tuning using tools like AWR, ADDM, SQL tuning advisors, SQL profiles, SQL Plan Baselines, Stored outlines, SQLT, SQL monitoring, Statspack and Oracle performance views.
• Experience in using various Oracle PL/SQL collections VARRAYS, NESTED TABLE.
• Creating or modifying existing DB objects (Procedures, Packages, Triggers, Views and Tables, etc.) on Business Enhancement projects and keep the current business running by participating in maintenance of DB.
• Performed Unit testing and Functionality testing of the financial module based on test scenarios and validating the data.
• Involved in the analysis, design, and development and testing phases of Software Development Lifecycle ( SDLC ).
• Experience using ERdiagram, Dimensionaldatamodeling, Logical / Physical Design, StarSchemamodeling, Snow-flakemodeling using tools like Erwin.
• Experience in Data migration Projects which uses SQL Developer, PL/SQL programming, coding Procedures, triggers and functions
• Have hands on experience in Data migration, Analysis, Validations and Reconciliation.

Environment: Oracle 12c , SQL Developer tool, SUN Sparc 5.10, Java,UNIX

Confidential, Atlanta, GA

Oracle PL/SQL Developer

Responsibilities:

• Written Batch Program, SQL queries, stored procedures, functions and triggers using Oracle DB
• Creating or modifying existing DB objects (Procedures, Packages, Triggers, Views and Tables, etc.) on Business Enhancement projects and keep the current business running by participating in maintenance of DB.
• Experience in Data migration Projects which uses SQL Developer, PL/SQL programming, coding Procedures, triggers and functions.
• Developed Complex queries on Database and developed PL/SQL Procedures to give in nice strategic plans to higher level of management.
• Have hands on experience in Data migration, Analysis, Validations and Reconciliation.
• Performed Unit testing and Functionality testing of the financial module based on test scenarios and validating the data.
• Experience in using various Oracle PL/SQL collections VARRAYS, NESTED TABLE.
• Used several Oracle predefined functions NVL, NVL2, DECODE, CASE STATMENT .
• Wrote UNIX shell scripts for automated installations, to extract logs using Bash
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Scheduled the Jobs for loading data using DBMS SCHEDULER.
• Job monitoring and doing Reconciliation process for failed jobs.
• Experience with Data flowdiagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• As Architect, responsible to design 20 plus aggregates using tables and migrate the corresponding logic from the present DB's stored procedures.
• Experience in OLTP, OLAP / Data Warehouse and Data Mart. Enhance and maintain the data warehouse that powers reporting and analytics.
• Performance monitoring and tuning using tools like AWR, ADDM, SQL tuning advisors, SQL profiles, SQL Plan Baselines, Stored outlines, SQLT, SQL monitoring, Statspack and Oracle performance views.
• Primarily responsible for support and management of 400+ customized application embedded SQLreports, validation of DB schema changes and Version to Version data accuracy.
• Involved in the analysis, design, and development and testing phases of Software Development Lifecycle ( SDLC ).
• Experience using ERdiagram, Dimensional data modeling, Logical / Physical Design, StarSchemamodeling, Snow-flakemodeling using tools like Erwin.

Environment: Oracle 11g /12c, SQL Developer tool, SUN Sparc 5.10

Confidential

Senior Application Engineer

Responsibilities:

• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from databases.
• Development stored procedures, functions, packages and triggers to implement business rules into the application.
• End to end implementation of product enhancements and fixing production defects.
• Meetings with end customers to understand their requirements and providing solutions for their issues by user trainings.
• Collaboration with QA teams for code fixes before moving the code to production.
• Prepared functional and technical design documents.
• Responsible for following up on bugs reported by users and suggested possible patches.
• Worked on various processes of Order Management like order import, process order API, sales order UI, defaulting etc.,
• Resolutions to customer issues in various areas of order management and order to cash cycle.

Environment: Oracle PLSQL, SQL loader, Oracle forms and reports, toad, SQL developer, Oracle applications, Unix

Confidential

Technical Consultant

Responsibilities:

• Pulled data from multiple sources using Informatica and transformed it into consistent format before loading into Confidential ’s databases.
• Scheduled Informatica workflows on Autosys to run mappings and move the extract files to our servers before further processing.
• Created packages to fetch data from remote database tables using joins, sub-queries and data base links.
• Analysed, optimized the code and fully tested the product with high volumes of data.
• Created complex PL/SQL scripts and did extensive database tuning.
• Filling gaps between required functionality and existing code.
• Developed batch scripts, scheduled them in windows scheduler to automate them.
• Prepared technical design documents, unit test cases.
• Wrote shell scripts for data loading and DDL scripts.
• Bug fixing and trouble shooting.
• Developing batch scripts for silent installation of product.
• Modified SQL and batch scripts.
• Installation of Product suits.
• Data setup for testing the product.
• Preparing Unit test cases and testing the product.
• Understanding the requirements for Confidential Transport v742
• Preparing business requirement document and functional requirement document.
• Involved in daily calls for more understanding.
• Developed the SQL script and integrated with PERL.
• Involved in end to end testing of the script.

Environment: Informatica, Oracle PLSQL, Toad, Autosys, batch scripting, SQL Loader, Unix shell scripting

Confidential

Project Engineer

Responsibilities:

• Requirement gathering for new modules.
• Preparing business requirement document and functional requirement document.
• Created database objects like tables, views, sequences, stored procedures, functions, packages, cursor, ref cursor and triggers.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Developing actuate reports and testing them.
• Preparing Unit Test Cases.
• Analyse and discuss the business requirements with the clients.
• Analysing issues and getting required clarification from the user.
• Optimized and modified the triggers, complex stored procedures, function etc.
• Responsible for the dealing with the problems, bug fixing and troubleshooting.
• Preparing release notes for the fixed bugs
• Doing enhancements as per the user requirement.
• Involved in requirement gathering for some applications.
• Monitored and provided front-line support of daily processes.
• Enhancement and bug fixing stored procedures.
• Developed excel reports eSpreadSheet.
• Prepared unit test cases and tested PLSQL procedures.

Environment: Oracle SQL/PLSQL, SQL DBX, Actuate eRDPRO 9 PLSQL, Toad, Oracle 10g, Actuate eRDPRO(8,9), eSpreadSheet(8,9), Autosys JILs scheduling, Eclipse 3.2. SQL Developer, Actuate, Autosys JILs scheduling.