Software Developer Resume

SUMMARY:

8 years IT experience in software development, 1 Year in Agile (SAFe) methodology with excellent skills in Analysis of business requirement and PL/SQL Coding.
Currently holding PL/SQL developer position in Medical Domain with Confidential. which is a product company specialized for spinal implants.
Expert in all phase of application development using Oracle 10g to 11g database using almost all advanced features of SQL and PLSQL.
Executed successfully Projects like Spine innovation engine, minimally invasive product line that includes a comprehensive line of technologically advanced spine products.
Strong Application development skills using tools like SQL developer, TOAD & PL/SQL Developer.
Strong working knowledge in Version control using Borland Starteam and GIT.
Involved in New Client implementations, Production / Pre Production / Business Validation support.
Ability to learn very quickly and apply new skills to existing problems.
Commitment to quality from requirements through design, construction, testing, and installation of new and existing products.
Extensively used Rally for logging features, user stories and defects.
Quality Assurance in all phase of software development from unit testing all the way through UAT testing. Proficient in creating test scenarios and writing test cases.
Thorough in different types of black box testing. Used tool like Rally to log the defects .

TECHNICAL SKILLS:

RDBMS: Oracle 10g /11g, PL/SQL, SQL Performance Tuning, SQL Server 2014, MS Access

Data Modelling: ER Studio.

Version Control Tool: Borland StarTeam 7.0, GIT Hub, Stash

Operating System: Windows XP, Windows NT, HP UX, IBM AIX

PROFESSIONAL EXPERIENCE:

Confidential

Software Developer

Environment: Oracle 11g

Responsibility:

Analysing the business requirements from different departments based and translating into PL/SQL Code by creating Packages, Stored procedures & Functions.
Modifying existing Packages based on requirement changes or Rally defects.
Well versed using CURSOR, REF CURSOR, Collections etc as part of PL/SQL development.
Expert in running SQL queries to confirm data quality and SQL Reporting.
Worked extensively with inline views, Correlated query, Global temporary table, Merge statements etc.
Maintaining the database with diverse product range(minimum of 10 new products being introduced every quarter).
Well accustomed to Agile methodology being part of it right from requirement analysis through development and testing.
Developing test cases based on the test Scenarios and also performing different types of testings based on the business scenario, also performs white box testing right from unit testing to UAT.
Involved in daily Scrum standup meeting.

Confidential

Software Developer

Environment: Oracle 11g

Responsibility:

Actively Involved in the project from Requirement, Analysis, Design, coding, Unit and Integration Testing.
Developed Packages, Functions, Stored procedures to provide Services (APIs ) to front end Java Application.
Writing Complex SQL queries for reporting using LEFT / OUTER / RIGHT Joins, subqueries, Inline views.
Created DDL objects like tables, Index, Sequences, Synonyms, Triggers, Views, Materialized view etc.
Used Development tools like TOAD,SQL developer, PL/SQL Developer for PL/SQL development.
Extensively used Subquery, WITH clause, Correlated Query, Analytical Functions like LEAD,LAG,DENSE RANK etc.
Used collection data structure like NESTED TABLE, VARRAY and Global temporary table
Debugging UAT / Production issues.
Extensively used CURSOR, Dynamic SQL ( Execute Immediate), Exception handling.
Involved in daily Scrum standup meeting.

Confidential

Software Developer

Environment: Oracle 11g

Responsibility:

Actively Involved in the project right from analysis, design, coding, all the way through testing.
Used advanced features of PL/SQL like records, tables, object types, dynamic SQL.
Used Pragma Autonomous transaction for Logging and Independent transaction for batch as well as Online.
Exception Error Logging using RAISE APPLICATION ERROR and user defined exception using Pragma exception init etc .
Good Knowledge with Views / Updatable Views / Materialized View / Parameterized View to enhance performance.
Attend daily standup Scrum meeting, grooming sessions for Features, User stories, Tasks and Story Point Estimates.