CVS CAREMARK, MONROVILLE, PA Sep 2015 to Present
Jr PL /SQL Developer and Tester
Responsibilities:
· Requirement gathering and worked according to the CR.
· Worked under the senior level guidance.
· Data validation/Reconciliation report generation.
· Code Development as per the client requirements.
· Involved in the development backend code, altered tables to add new columns, Constraints, Sequences and Indexes as per business requirements.
· Perform DML, DDL Operations as per the Business requirement.
· Creating views and prepares the Business Reports.
· Resolved production issues by modifying backend code as and when required.
· Used different joins, sub queries and nested query in SQL query.
· Involved in creation of sequences for automatic generation of Product ID.
· Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor and Triggers.
· Testing of code functionality using testing environment.
· Basic knowledge in FORMS
· Testing the Application Intensively