SUMMARY

• Over 6 years of expertise in issue analysis, coding and implementation using Oracle PL/SQL, SQL tuning, Database Design, Database Administration.
• Experienced in various phases of the projects like gathering requirements, Business Analysis, Gap Analysis, Configuration, Unit testing, Integration testing, Business Accepting testing, End User training and post go live support.
• Experience in migrating oracle database 11g to MySQL 5.6, Amazon Aurora.
• Migrated schema objects like tables, indexes, constraints etc.. using Amazon schema conversion tool.
• Translated business logic in packages and functions to stored procedures and functions in Aurora.
• Comparison scripts for schema and data migration.
• Experience in developing and maintaining applications using PHP, MySQL, HTML, XML and JavaScript.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelling and design techniques.
• Extensive knowledge on database administration for Oracle 10g and 11g.
• Well conversant in translating business requirements into creation of database objects: tables, indexes, constraints, packages, stored procedures, functions, and triggers using Oracle PLSQL tool and also into reports using Oracle BI Publisher.
• Proficient in advance features of Oracle 10g/11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.
• Experience in modelling and design in Mongo DB.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views and Query Re - Write.
• Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables.
• Loaded Data into Oracle Tables usingSQL Loader.
• Partitioned large Tables usingrange partition technique.
• Manage internal databases, from planning and testing stages through implementation and support.
• In-depth understanding of security and backup procedures to ensure database integrity.
• Exposure in VPD (Virtual Private Database).
• Excellent in agile methodology.
• Excellent communication & interpersonal skills with proven abilities in resolving complex software issues.
• Experimenting the freelance project on AWS Dynamo DB.
• Developed freelance application using PHP and Javascript.
• Completed course of MongoDB developer in MongoDB university.
• Knowledge in AWS solution architect.

TECHNICAL SKILLS

Operating Systems: Dos, Windows 98/2000/XP/Vista/7, UNIX.

Languages: Oracle PL/SQL, Performance Tuning, SQL, Core Java, C, UNIX scriptingPHP, JavaScript, Drupal, Bootstrap, Angular JS.

Reporting tools: Oracle BI publisher, Oracle Forms and Reports 6i. Business Objects XI 3.1/3.0, XI R1/R2,6.5, CrystalReports.

Database: Oracle 10g, 11g, MySQL 5.1,5.6, Amazon Aurora.

Tools: Toad for Oracle 9, PL/SQL Developer 7.5, Eclipse, MySQL Workbench.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Responsibilities:

• Analyse System Requirements to create a Technical Design with the assistance of other Sr. Developers/Architects/Tech. Leads.
• Migration of legacy Oracle database 11g to Amazon Aurora.
• Migrated schema objects like tables, indexes, constraints etc.. using Amazon schema conversion tool.
• Automated script for data type conversion like number to int for primary key columns, Sequence to auto increment columns.
• Translated business logic in packages and functions to stored procedures and functions in Aurora.
• Performance tuning of the Aurora database objects like procedures, functions, views etc.
• Automated script for deployment runnable objects in aurora production databases.
• Comparison scripts for schema and data migration.
• Constructed complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document.
• Developing stored procedures, packages, triggers and other database objects using Oracle PL/SQL programming language on Oracle 11 database.
• Analysing performance of database objects and suggesting DBA for Indexes, schema gathering, partitioning, Explain Plan, TK PROF.
• Designed and implemented the MongoDB schema for internal applications.
• Loaded test data into MongoDB Schema.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Bug fixing and enhancements based on the client requirements at database level.
• Implemented PL/SQL to perform application security and batch job scheduling.
• Used SQL* Loader and export/import mechanism for data migration for bulk upload.
• Created Unit and Assembly Test Scripts and performed the test cases
• Created new databases, involving importing and exporting: installing and configured database software for Oracle Application development environment.
• Involved in Upgrading databases from Oracle 10g to 11g.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.

Confidential

Responsibilities:

• Gathering the functional requirements from users and converting them into Technical requirements.
• Analyse System Requirements to create a Technical Design with the assistance of other Sr. Developers/Architects/Tech. Leads.
• Responsible for helping set development standards for database development within PL/SQL
• Constructed complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document.
• Developing stored procedures, packages, triggers and other database objects using Oracle PL/SQL programming language on Oracle 11 database.
• Analysing performance of database objects and suggesting DBA for Indexes, schema gathering, partitioning, Explain Plan, TK PROF.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Bug fixing and enhancements based on the client requirements at database level.
• Implemented PL/SQL to perform application security and batch job scheduling.
• Used SQL* Loader and export/import mechanism for data migration for bulk upload.
• Created Unit and Assembly Test Scripts and performed the test cases
• Created new databases, involving importing and exporting: installing and configured database software for Oracle Application development environment.
• Involved in Upgrading databases from Oracle 10g to 11g.
• Load and Transform data using SQL*Loader and External Tables.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.

Confidential

Responsibilities:

• Understanding the business requirements and design.
• Analysis, design and transaction development.
• Coding as per technical design and coding standards
• Developing stored procedures, packages, triggers and other database objects using Oracle PL/SQL programming language on Oracle 11 database.
• Created Views and Triggers required for the Incident, Investigation, Consequence and Action Items modules based on the business requirements
• Bug fixing and enhancements based on the client requirements at database level.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Performance monitoring and tuning of SQL developed by various developers
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Implemented backup and recovery procedures of databases in Red Hat Linux environment: implemented backup and recovery procedures
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Partitioning and re-organization of table and indexes.
• Maintained development and QA environments.

Confidential

Responsibilities:

• Understanding the business requirements and design.
• Analysis, design and transaction development.
• Coding as per technical design and coding standards
• Developed stored procedures, packages, triggers and other database objects using Oracle PL/SQL programming language on Oracle 10g database.
• Developed and maintained several detail and summary reports according to business requirements Oracle Reports 6i.
• Bug fixing and enhancements based on the client requirements at database level.
• Involved in Logical and Physical Database Design.
• Involved in Migration from Mysql database to Oracle database.

Confidential

Responsibilities:

• Responsible for understanding the business requirements of the client.
• Created different content types (Article, Slide, Slideshow etc.).
• Implementation and Maintenance of Web application in Drupal - PHP.
• Worked on implementing directives and scope values using Angular.JS for an existing webpage.
• Created the initial design to determine the look and feel of the website by creating wireframes, mockup UIs.
• Implemented AJAX to enhance the capability of the system using YUI framework.
• Developed scripts using PHP and MYSQL in Dreamweaver 8 dat are scheduled using CRON to implement matching point calculations and make profile match suggestions every day to users.
• Created front end forms using Drupal.
• Customized the Drupal CMS and extensively worked on themes and Modules.
• Used PHP as the server side scripting language.
• Generated PHP source documentation using PHP Documenter.
• Used PHP session variables and cookies implementation.
• Modified the UI screens created by web designer using HTML, CSS, Bootstrap, Angular and JavaScript in Drupal.
• Took the responsibility to work on story, slide, slideshow and open page migration from Drupal6 to Drupal7.
• Actively involved and responsible for developing the requirements of the client.
• Responsible for fixing the Jira tickets raised by client.
• Involved in developing various CMA controlled features for existing system.
• Coding in LAMP (Linux, Apache, MySQL and PHP) environment.
• Used OOP principals, XML and external Javascript and CSS documents for modular design of code.