SUMMARY

• 10+ years of IT experience in Analysis, Design, Development, Implementation and Support Projects of RDBMS in Production, Development and Test environments using Oracle, My SQL Tools in client server and Web and Windows based applications PHP.
• Experience in developing and enhancing PHP (OOPS Oriented PHP Programming, Codeigniter, CakePHP, Symphony2, Laravel, Smarty Template, LAMP, WAMP and XAMP environments, JavaScript and jQuery).
• Experienced in all stages of System Development Life Cycle (SDLC): Analysis, Design, Coding, Unit Testing, System Integration Testing, User Acceptance Testing, Postproduction Support and Maintenance.
• Experience with database SQL development and excellent knowledge working with relational database systems such as MySQL, MSSQL and Oracle.
• Proficient in Web Services, REST, SOAP, XML, XSL, XSLT, XPath, XSD, DTD, CSS, DOM, AJAX and JavaScript and jQuery.
• Expertise in Web and Windows application development in PHP and database design and development on client/server applications using Oracle 9i, 10g, 11g, 12c - SQL, PL/SQL, My SQL on UNIX/Windows environment.
• Expertise in developing, enhancing and tuning of Oracle and My SQL Server database objects and advanced PL/SQL programs.
• Experience in creation of various Database objects like Tables, View, Indexes and Types.
• Experience in maintain repository using SVN, GIT Hub, JIRA etc.
• Expertise in developing Packages, Procedures, Functions, Triggers, Cursors using PL/SQL in UNIX/Windows environment.
• Expertise in Oracle advanced features like Ref Cursors, Native Dynamic SQL, Analytic functions and PL/SQL Collections.
• Experience in Performance Tuning using Explain plan, SQL Trace, TKPROF, SQL Profiler and various types of Hints, table partitioning and indexing.
• Expertise in SQL and PL/SQL programming, developing complex code units, database triggers and using the latest features to optimize performance (Bulk Binds, Materialized views, Joins, Inline views, Global Temporary Tables).
• Strong experience in Data Loading/Data conversion/integration from Legacy systems and external systems into Oracle Applications using PL/SQL, SQL*Loader, SQL* Plus, UTL FILE etc.
• Experience in Banking, Utilities & Healthcare, Enterprise Resource Planning (ERP), Insurance Solutions domain based applications.
• Extensive experience working in Waterfall and Agile Methodologies.
• Experience in managing global projects, Onsite and Offshore model projects, coordinating and leading offshore team.
• Experience in Content Management System (CMS) Tools Drupal, Joomla & Wordpress themes developing custom modules, resolving configuration issues.
• Extensively worked using Amazon AWS services, AJAX features along with wide and in depth understanding of each one of them.
• Extensively worked using RESTFUL micro services and API features of Java and other technology along with wide and in depth understanding of each one of them.
• Extensively worked on Client scripting languages. Such as Angular 2/4/5/6 and JavaScript classes.
• Extensively worked Node JS.
• Strong Technical background with excellent problem solving and communication skills. Strong time management skills and excellent team player with reputation of integrity and an ability to work on multiple technologies. Experience in working with cross-cultural team.
• An astute planner and leader with exemplary communication, relationship management, analytical and organizational skills.

TECHNICAL SKILLS

Operating Systems: Windows 7/2000/NT/XP, Unix.

Databases: Oracle 9i, 10g, 11g, 12c.

Programming Languages: SQL, PL/SQL, PHP5, PHP7, Unix Shell Scripts, My SQL, Angular2/4/5/6, Node JS, HTML5, CSS3, Javascript, Web Services, Web API(Java API - Spring Boot), Restful, Curl, CakePHP, S ymfony2, Laravel, Codeigniter, Wordpress, Drupal, Tonic.

Tools: TOAD, PL/SQL Developer 6, Tortoise SVN, GIT hub, Bit Bucket, JIRA, SQL * PLUS, AUTOSYS, Eclipse, IntelliJ, Net Beans, PHP My Admin, SQL Navigator, Apache, IIS, Nginx Web Servers, HP Quality Centre.

Testing: Unit Testing, Manual Testing, System Integration Testing, User Acceptance Testing, Knowledge of complete Testing Process (Test Plan, Test Case Preparation, Test Execution).

PROFESSIONAL EXPERIENCE

Confidential

Senior/Lead PHP and Oracle PL/SQL Developer

Responsibilities:

• Gathered the Requirement from the business user and prepared the program specification and design document for the development.
• Involved in analyze the functional & technical requirements.
• Extensively worked in the design, development and testing through the creation of test cases and test scripts.
• Used all aspects of PHP7 (object-oriented PHP), Laravel Framework in LAMP environment and Oracle as Database
• Developing PHP7, HTML, CSS, JavaScript, jQuery, Angular 6, Node JS application pages according to project requirements
• Extensively used java environment micro services (RESTFUL API - Sprint Boot) to upload the documents to the Oculus and updating the database based on the API response.
• Worked on CI/CD with the OTIS team for continuous integration and deployment.
• Created the Tables, Indexes, Views, Materialized Views, Table Partitions, Packages, Stored Procedures and Functions.
• Extensively used PL/SQL Collections, BULK Collect, For ALL, Table Types, and Record Types.
• Extensively used Execute Immediate for dynamic sql, Analytical functions Row Number,Rank,Dense Rank for complex reporting purposes and hierarchical data.
• Extensively worked on Cursor, RefCursor for data processing.
• Used Exception Handling to handle runtime & user defined exceptions.
• Code Review of Deliverables.
• Training and Mentoring.
• FoxPro Database code analysis and development.
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Deploy code base to TEST, VAL, dry-run environments.
• Plan production deployment activities.
• Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
• Attending Design Review and Status meetings.
• Created the test scripts and complex queries to test the application and to quality assurance of the data.
• Anticipates and takes proactive measures to resolve potential gaps/conflicts and issues that could inhibit success.
• Creating Process Improvements in the project level.
• Loading data needed for testing in the test schemas.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Deployment and Performance Measurement.
• Monitoring the various program level metrics like SLA compliance, Downtime, Bad fixes, schedule slippage etc.
• Tracking and status reporting, Risk planning and mitigation.
• Track effort, timeliness and deviations from the original project schedule.

Environment: IBM Machine powered by Intel Processor, Windows NT/XP operating system, PHP 7, Laravel, HTML, CSS, JavaScript, jQuery, Angular 4, Node JS, Bootstrap, Oracle 12c databases, SQL, PL/SQL, SQL * PLUS, SQL Developer, Appian BPM, JIRA, Toad for Oracle, FoxPro Database.

Confidential

Senior/Lead PHP and Oracle PL/SQL Developer

Responsibilities:

• Gathered the Requirement from the business user and prepared the program specification and design document for the development.
• Involved in analyze the functional & technical requirements.
• Extensively worked in the design, development and testing through the creation of test cases and test scripts.
• Used all aspects of PHP7 (object-oriented PHP), Laravel Framework in LAMP environment and Oracle as Database
• Developing PHP7, HTML, CSS, JavaScript, jQuery, Angular 4 application pages according to project requirements
• Extensively used java environment micro services (RESTFUL API - Sprint Boot) to retrieve the desired information of the Rates proposed and updating the database based on the API response.
• Worked on CI/CD with the OTIS team for continuous integration and deployment.
• Created the Tables, Indexes, Views, Materialized Views, Table Partitions, Packages, Stored Procedures and Functions.
• Extensively used PL/SQL Collections, BULK Collect, For ALL, Table Types, and Record Types.
• Extensively used Execute Immediate for dynamic sql, Analytical functions Row Number,Rank,Dense Rank for complex reporting purposes and hierarchical data.
• Extensively worked on Cursor, RefCursor for data processing.
• Used Exception Handling to handle runtime & user defined exceptions.
• Code Review of Deliverables.
• Training and Mentoring.
• FoxPro Database code analysis and development.
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Deploy code base to TEST, VAL, dry-run environments.
• Plan production deployment activities.
• Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
• Attending Design Review and Status meetings.
• Created the test scripts and complex queries to test the application and to quality assurance of the data.
• Anticipates and takes proactive measures to resolve potential gaps/conflicts and issues that could inhibit success.
• Creating Process Improvements in the project level.
• Loading data needed for testing in the test schemas.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Deployment and Performance Measurement.
• Monitoring the various program level metrics like SLA compliance, Downtime, Bad fixes, schedule slippage etc.
• Tracking and status reporting, Risk planning and mitigation.
• Track effort, timeliness and deviations from the original project schedule.

Environment: IBM Machine powered by Intel Processor, Windows NT/XP operating system, PHP 7, Laravel, HTML, CSS, JavaScript, jQuery, Angular 4, Bootstrap, Oracle 12c databases, SQL, PL/SQL, SQL * PLUS, SQL Developer, Appian BPM, JIRA, Toad for Oracle, FoxPro Database.

Confidential

Senior/Lead PHP Developer (CakePHP)

Responsibilities:

• Knowledge in entity framework, also implemented code first method for entity framework.
• Research on new technologies and recommend implementing them into the project.
• Follow up with QA team to fix the issues and update.
• Responsibilities include database design, code profiling and extensive documentation.
• Worked on implementing webservices.
• Worked majorly on backend coding and implemented core logic for all the projects.
• Used all aspects of PHP (object-oriented PHP), CakePHP Framework in LAMP environment and Oracle as Database
• Developing PHP, HTML, CSS, JavaScript, jQuery, Telerik, Angular4 and Amazon AWS, application pages according to project requirements
• Worked as PL/SQL Developer for MACPRO project. Development, bug fixes, Production Support, Reporting etc.
• Gathered the Requirement from the business user and prepared the program specification and design document for the development.
• Involved in analyze the functional & technical requirements.
• Extensively worked in the design, development and testing through the creation of test cases and test scripts.
• Design the Database and Amazon AWS
• Created the Tables, Indexes, Views, Materialized Views, Table Partitions, Packages, Stored Procedures and Functions.
• Extensively used PL/SQL Collections, BULK Collect, For ALL, Table Types, and Record Types.
• Extensively used Execute Immediate for dynamic sql, Analytical functions Row Number,Rank,Dense Rank for complex reporting purposes and hierarchical data
• Extensively worked on Cursor, RefCursor for data processing.
• Used Exception Handling to handle runtime & user defined exceptions.
• Code Review of Deliverables.
• Training and Mentoring.
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Deploy code base to TEST, VAL, dry-run environments.
• Plan production deployment activities.
• Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
• Attending Design Review and Status meetings.
• Created the test scripts and complex queries to test the application and to quality assurance of the data.
• Anticipates and takes proactive measures to resolve potential gaps/conflicts and issues that could inhibit success.
• Creating Process Improvements in the project level.
• Loading data needed for testing in the test schemas.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Basic Understanding of Appian BPM.
• Deployment and Performance Measurement.
• Monitoring the various program level metrics like SLA compliance, Downtime, Bad fixes, schedule slippage etc.
• Tracking and status reporting, Risk planning and mitigation.
• Track effort, timeliness and deviations from the original project schedule.

Environment: IBM Machine powered by Intel Processor, Windows NT/XP operating system, PHP, CakePHP, Telerik HTML, Javascript, jQuery, Bootstrap, Oracle 12c databases, SQL, PL/SQL, SQL * PLUS, SQL Developer, Appian BPM, Bit Bucket, JIRA, Toad for Oracle, FoxPro Database.

Confidential

CMS Developer

Responsibilities:

• Used Drupal 7 (CMS) for the modules
• Worked on Unix/Linux, MVC, Subversion, Git, Zend, Laravel and LAMP/WAMP/XAMP environment.
• Research on new technologies and recommend implementing them into the project.
• Responsibilities include database design, code profiling and extensive documentation.
• Worked on implementing web services(Restful).
• Worked majorly on backend coding and implemented core logic for all the projects.
• Closely work with UI team for the look and feel of an application and for UI validation.

Environment: Windows NT/XP operating system, PHP5.6, Drupal 7, Angular 4, HTML, Javascript, jQuery, Bootstrap, MySQL databases.

Confidential

CMS Developer

Responsibilities:

• Used Joomla for the modules
• Worked on Unix/Linux, MVC, SVN, Git and LAMP/WAMP/XAMP environment.
• Research on new technologies and recommend implementing them into the project.
• Responsibilities include database design, code profiling and extensive documentation.
• Worked on implementing web services(Restful).
• Worked majorly on backend coding and implemented core logic for all the projects.
• As a developer, responsible to develop the Change in requirement or enhancement in the existing application.
• Participating in the daily requirement and status meeting with Onsite and Offshore team members.
• Closely work with UI team for the look and feel of an application and for UI validation.

Environment: Windows NT/XP operating system, PHP5.6, Joomla, HTML, Javascript, jQuery, Bootstrap, MySQL databases.