SQL, PL/SQL, Oracle Apex, UNIX
Resume:
Bobby jebaraj D ************@*****.***
Objective
To become a part of an organization implementing knowledge and experience explored the career challenging and creative.
Professional Summary
•Have over 4 years of progressive and dynamic experience in Oracle SQL,PLSQL production support and development.
•Have experience in IT industry with broad knowledge on development and support projects.
•Created, changed Code using Data Definition and Data Manipulation Languages.
•Exposure in writing complex SQL queries and PLSQL sub-programs.
•Have used SQL loader for transferring data from files to Databases.
•Worked in Teams writing Joins, Sub queries and Set operators.
•Highly skilled in creating SQL objects like Tables, Views, Sequence, Synonyms and Indexes.
•Written code for developing Materialized views and Simple views.
•Have experience using Cursors and Exception handling as per the requirement on project requests.
•Have a knowledge and experience on Triggers, Collections with its Methods.
•To create and work with Stored procedures, Stored Functions, Packages and Ref cursors.
•Technical expertise working with developer and ticketing tools like Service now.
•Knowledge about doing a proper checkout in Tortoise SVN(Version Control Tool) for any changes in the code.
•Have experience on Performance tuning concepts and its methods.
•Have a good communication, motivated, team playing, initiative and quick learner.
•To attend Code Reviews and CAB(Change Advisory Board) for deploying Code in production environment.
•Analyze and resolve requests in Service Now through tickets received.
Work Experience
•Worked as a process associate at Iazo Technologies Pvt Ltd From 4th Aug, 2012 to 14th Aug, 2015.
•Worked as a Software Engineer at Rednautix Software Solutions Pvt Ltd from 18th Sep, 2015 to 20th Mar, 2020.
Project summary
•Company name - Iazo Technologies Pvt Ltd.
Client name - AT&T
•Company name-Rednautix Software Solutions Pvt Ltd.
Client name- Prognos Health Inc.
Front end - Java
Back end - Oracle 10G/11G
Database - enh_prog_db
Tools used –Autosys 1.05, SQL loader, PL/SQL developer 13.0.6.1911,Version control
tool(SVN) Tortoise 1.14.0, ServiceNow Eureka, Putty release 0.73, Toad 3.1, SQL*plus.
End user – Client and Patient’s Insurance Companies.
Language Used – Unix shell scripting 4.0, Oracle 10G,11G and 12C, Oracle APEX 5.0.
Description
With 16 billion records for 185 million patients, the Prognos Registry is the the largest integrated database of multi-sourced clinical diagnostics data. Prognos aggregates, normalizes, and provides clinical interpretation of clinical diagnostics data using HIPAA-compliant infrastructure. It is cross-linkable to prescription and claims data. This Artificial Intelligence platform uses clinical algorithms across more than 30 conditions to enable early prediction of disease onset, plot therapy needs, present clinical trial opportunities, reveal care gaps, and indicate risk. These resources can be combined to provide alerts that help get the best treatments to patients at the earliest possible time, improve case management and speed advances in clinical studies.
Roles and responsibilities :
Company name - Iazo Technologies Pvt Ltd
Project name - AT&T Scope - Network & Services
4th Aug, 2012 to 14th Aug, 2015 AT&T, Team Size-35
•To sell and assist customers to render network services for their home and commercial needs like TV, Internet and Telephone.
•To up sell and cross-sell services for customers on the basis service availability at their premises.
•To Raise requests for new services to be installed at the customer's place with the field technician on the available slot in pre-fixed appointment at their convenience.
•To follow-up on the appointment fixed for the services to be installed within SLA(Service Level Agreement).
Company name - Rednautix Software Solutions Pvt Ltd
Project name - Prognos Scope - Healthcare & services
Prognos, Team Size-4 18th Sep, 2015 to 20th Mar, 2020
•Involved in the whole life cycle of the project.
•Written SQL statements to show the pending verifications and eligibility information from the database.
•Programmed Packages, Stored procedures, Functions and SQL Queries.
•Understanding the requirements and carrying out impact analysis.
•Convert the functional requirements into technical documents.
•Make ensure to follow the correct procedures, policies and documentation requirements across project phases.
•Liaise with vendor for movement of the enhancement to production.
•Tracking of all Application related calls/queries
•Managing DR (Disaster Recovery) synchronization at application level.
•Conducting DR testing in regular intervals to ensure applications working as usual on DR server & DR invoked within SLA in contingency situation.
•Following Change Management Process for implementing a change into Production
environment.
•Raising RFC (Request for Change) for production changes & presenting to CAB
(Change Advisory Board) with proper justification, impact analysis & approvals from
related stakeholders.
•In scenario of contingency, raising Emergency RFC & presenting to CAB with proper impact analysis & approvals.
•Managing Incident tickets and tracking the Incidents.
•Install, test and troubleshoot regular and custom made applications and train clients on different functions of the application.
•Database and manual testing on UAT (User Acceptance Test) before implementing any patch or release in production environment.
Academic Details
B.E-CSE(2008-2012) from The Rajaas engineering college. (Affiliated to Anna University, Chennai).
Declaration
I hereby declare that all the above furnished information is true to the best of my knowledge and belief.
Place : Yours truly,
Date : Bobby jebaraj D
Contact this candidate