Jay Chandra Email & Phone Number

• 15+ years of IT experience in experience architecting PL/SQL applications and technically lead the team for realization of high level design in Oracle PL/SQL code with the following:o Heavy use of PL/SQL Collections & Bulk collections.o Heavy use of oracle analytical functions.o Object oriented programming with PL/SQL- Oracle Object Types.o Materialized Views.o OLTP environment experience.o Validating output results then doing detailed unit testing.o Heavy PL/SQL debugging.o Sound experience in Oracle performance tuning, Optimizing SQL queries to improve performance for PL/SQL codes using Explain Plan and TKPROF.o Experience in Developing ILM Data Archival Entities, Jobs, retention Archive Restore.• Strong understanding and experience of Logical and conceptual data modelling using ER Win Tool• Worked with star, snowflake schema and OLAP modeling.• Experienced in Designing Database with prominent activities like maintaining sequences, index, primary key, foreign key, manipulating columns and tables.• Responsible for evaluating various RDBMS like OLTP modelling, documentation, and metadata reporting tools including Erwin, Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.• Updated data model as per the requirement and generate DDL and deploy it using SQL developer.• Responsible for Dimensional Data Modelling and Modelling Diagrams using ERWIN.• Worked with reversed engineer Data Model from Database instance.• Self-motivated and strong analytical and inter-personal skills.• Ability to learn fast, keen listener and dedicated towards achieving set goals and meet deadlines. • More than year Onsite experience for Client Bupa UK as technical Lead for their ongoing SCRUM.• Extensive experience in Healthcare Finance ( Account Payable/Receivable), Healthcare domain, Document processing, Investment banking and Retail banking.• Sound hands on working experience in Agile Methodology. • Quick understanding of project within Managed Services along with Incident Management, Problem Solving, and Change Management. • Ability to Lead Team and deliver high quality solutions within the set deadlines• Hands on preparing HLD (High Level Design) and LLD (Low Level Design)• Writing and Review Unit Test cases• Performing Integration Testing in Development environment.• Hands on Jason scripting using Postman

Listed skills include Oracle Sql, Sdlc, Pl/Sql, Oracle, and 26 others.

• 

  Guru Ghasidas University,Bilaspur

  Information Technology