Archana Selvaraj

623-***-****

ac8a42@r.postjobfree.com

Profile Summary:

• Have 6 years of experience in Software Development.

• Experience in Developing and Testing Oracle PL/SQL (Stored Procedures, Functions, Packages) and SQL queries based on User Stories or Business and Functional Requirements.

• Experience working on Agile and Waterfall Software Development Model.

• Experience working in Insurance and Networking domain.

• Experience working in query Turning in order to enhance the performance.

• Have very good experience working in onsite-offshore model.

• Excellent communication, analytical, interpersonal and presentation skills.

• Active participant in code reviews, design discussion meetings on design, enhancement, new design patterns.

• Research-oriented, self-motivated, proactive, quick learner with strong technical, analytical, interpersonal and communication skills. Technical Skill Expertise:

Databases Oracle 9i, Oracle 11g, MySQL

Programming Languages SQL, PL/SQL, SQR, Oracle Reports, Perl, Oracle forms Domain Insurance, Networking

Operating Systems Windows XP, Windows10, Unix, Linux. Tools Toad, Sql plus, Oracle Forms, Oracle Reports, Beyond Compare, Microsoft Office, PowerPoint, Excel, Visio, Putty.

Professional Work Experience:

Brillio LLC

Client: Verizon

Senior Software Developer Oct2018 to Present

Project – 5G Planning

Migrate existing customer databases and also create database objects like tables, views, store procedures, packages and functions to facilitate the hosting of wireless 5G connection. Responsibilities:

• Participated in Tech Review and Sprint Planning Sessions and identified development scope for user stories.

• Involved in development and enhancement of Oracle SQL, PL/SQL, MySQL.

• Participate in daily stand ups, code reviews, sprint retrospective meetings.

• Set up and monitor continuous integration batch job runs.

• Capably coded and reviewed the coded scripts to ensure zero defects

• Efficiently interacted with testing team in order to test the application successfully.

• Tuned SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization

• Provided support in Testing phase and closed all the defects on time.

• Efficiently coordinated with team and involved in management activities such as status report generation, attending meetings and organizing fun events.

• Involved in successful implementation of project in production environment. Also, provided support to monitor and to give quick turnaround for newly implemented production runs.

Environment: Oracle, MySQL, SQL Developer.

Cognizant Technology Solutions

Client: MetLife

Software Developer Aug 2015 to Feb 2016

Project – Hedge

Development and enhancement of Sql and Pl/Sql codes to run valuation processes to manage the risk and investment of funds for variable annuity products with guaranteed riders for all the services used in Hedge application.

Responsibilities:

• Participated in Tech Review and Sprint Planning Sessions and identified development scope for user stories.

• Involved in development and enhancement of Oracle SQL, PL/SQL, Perl and PowerShell codes.

• Participate in daily stand ups, code reviews, sprint retrospective meetings.

• Set up and monitor continuous integration batch job runs.

• Capably coded and reviewed the coded scripts to ensure zero defects

• Efficiently interacted with testing team in order to test the application successfully.

• Provided support in Testing phase and closed all the defects on time.

• Efficiently coordinated with onsite/offshore team and involved in management activities such as status report generation, attending meetings and organizing fun events.

• Involved in successful implementation of project in production environment. Also, provided support to monitor and to give quick turnaround for newly implemented production runs.

• Worked closely with Administrator for proper backup and recovery plans Environment: Oracle, Perl.

Cognizant Technology Solutions

Client: Hartford

Software Developer Mar 2013 to Aug 2014

Project – GB Corporate tax LP

Development and maintenance of oracle scripts for user interfaces used to create reports. Responsibilities:

• Involved in all the phases of the project.

• Worked in Oracle SQL, PL/SQL, Oracle Reports, Perl and SQR.

• Worked with onshore team to gather requirement and design based on business requirements.

• Reviewed code developed by peers, merged and integrated code developed by peers to mainline.

• Worked with the tech leads, domain lead and business team to walkthrough the developed code and scenarios.

• Worked with onshore team to write design documents and to develop and test the code.

• Provided support in SIT/BAT phase and closed all the defects on time.

• Efficiently coordinated with onsite/offshore team and involved in management activities such as status report generation, attending meetings and organizing fun events.

• Fine-tuned SQL queries using hints for maximum efficiency and performance.

• Prepared and Presented daily, weekly and monthly Status Reports to the different Stake holders of the project.

• Involved in successful implementation of project in production environment. Also, provided support to monitor and to give quick turnaround for newly implemented production runs.

Environment: Oracle SQL, PL/SQL, Oracle Reports, Perl and SQR Cognizant Technology Solutions

Client: Hartford

Software Developer Nov 2012 to Jan 2013

Project – GBD Solar Migration 11g

Migrate oracle 9i codes to oracle 11g compatible version. Responsibilities:

• Involved in Analysis, Design, Code, Test and Documentation of new modules and enhancement of existing codes based on business requirements.

• Involved in development and testing of Oracle Stored Procedures, Functions and Packages based on design document.

• Involved in query turning of already existing Oracle Sql and pl/Sql codes.

• Worked in Oracle Forms and Perl changes to run the batch jobs.

• Efficiently understood the key difference between Oracle 9i and 11g and performed the necessary code changes in the application.

• Involved in application server and batch server setup for 11g.

• Worked in password changes of the database and security features like oracle wallet.

• provided support to monitor the Quality center to give quick turnaround and to close the defects.

• Worked with onshore team to write design documents and to develop and test the code.

• Provided support in SIT/BAT phase and closed all the technical defects related to 11g depreciated keywords.

• Provided weekly management status reports and coordinated meetings between development team and test team to review defects.

Environment: Oracle 9i, Oracle 11g, Oracle Forms, Perl Cognizant Technology Solutions

Client: Hartford

Software Developer Feb 2011 to Feb 2012

Project – PrIME

Development and maintenance of Oracle codes for Agent/Firm data in all Hartford Life companies and administrative business lines.

Responsibilities:

• Involved in requirements gathering and walked through the team on the requirements

• Involved in Analysis, Design, Code, Test and Documentation of new modules and enhancement of existing codes based on business requirements.

• Involved in development and testing of Oracle Stored Procedures, Functions and Packages based on design document.

• Involved in query turning of already existing Oracle Sql and pl/Sql codes.

• Creation of High Level, Low Level design documents, Development Class diagrams & Sequence diagrams as part of system design

• Designed complex Relational database Tables and normalized the data structure

• Worked in Onsite-Offshore model through emails, daily stand-ups and handoff calls. Environment: Oracle Sql, Pl/Sql

Achievements:

Completed B.E in Computer science First Class With Distinction

Received “The Shining Star” award for best performance of the team.

Received “The champion of the Quarter” for the year 2012.

Received “The Exemplary Performer” from Cognizant for the year 2013

Received “Employee of the Year” from Cognizant for the year 2013 Educational Qualification:

• Bachelor of Engineering – Computer Science - May 2010. Professional Certification/Training:

• Oracle Certified SQL Developer

Contact this candidate