SUMMARY

• Over 6 years of experience as a Senior Oracle Developer with extensive experience in Analysis, Design, and Development of client - server applications using Oracle Relational D Confidential base Management System (RDBMS), SQL, PL/SQL and Business Object Web Intelligence.
• Strong exposure in writing simple and complex SQL and creating PL/SQL Functions, Stored Procedures and Packages.
• Experience with D Confidential flow diagrams, D Confidential dictionary, D Confidential base normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Client-Server application development using Oracle, PL/SQL, SQL *PLUS, TOAD and SQL Developer.
• Effectively made use of Table Functions, Indexes, Collections, Analytical functions, and Materialized Views.
• Thorough Knowledge in creating DDL, DML and Transaction queries in SQL for Oracle and SQL-Server d Confidential bases.
• Experience in preparing several sub queries with group by, having clause using various functions like decode, case, substr, instr and analytical functions like rank, dense rank, lead, lag.
• Experienced in advanced PL/SQL concepts such as Cursors, Bulk Collect and Array.
• Proficient in creating Oracle objects - Tables, Views, Materialized Views, Triggers.
• Strong experience in SQL *PLUS, SQL *Developer.
• Experience in generating EDI files for enrollment and payment.
• Experienced in re-designing PL/SQL procedures and fine tune queries to improve performance.
• Experienced Technical writer - Involved in discussions with Business Users along with Business Analysts and provided feasibility report of business requirement
• Highly experienced in system analysis and translating Software Requirement Specification (SRS) and Business Requirement Specification (BRS) into Technical Specifications and Design
• Working knowledge on UNIX and D Confidential Warehousing/ETL concepts - CreatedShell Scriptsfor invoking SQL scripts and scheduled jobs.
• Experienced in Design and Development of D Confidential warehousing solutions for Extraction, Transformation and Loading (ETL) mechanism using Informatica.
• Sound understanding of D Confidential Warehousing concepts and Dimensional modeling such as Star Schema and Snowflake Schema
• Sound knowledge on SDLC process - Involved in all phases of Software Development Life Cycle- analysis, design, development, testing, implementation and maintenance of applications
• Experienced working in financial processes/areas such as Insurance, Health care, loan system, customer and distributors management, securities and mutual funds.
• Self-motivated and proactive leader with technical and exemplary communication skills.

TECHNICAL SKILLS

Insurance: Life Insurance, Health Care.

Banking: Loans, Investment Banking.

D Confidential bases: Oracle 9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers),MySQL, MS SQL Server, MS Access 7.0/ 97/2000, SQL Server 11.x/12.0DB2/UDB

Programming Languages: SQL, PL/SQL, Unix Basic Commands, XML, JAVA, Struts 2, MVC architecture, JSP, HTML, Web Services, SOAP UI,VB Script, Java Script

Operating System: Unix Sun Solaris 2.6/2.7, Linux 6.X/7.X/8.X, Linux Red hat, Windows XP/7/8

ETL: Informatica 8.x/9.x

Tools: SQL*Developer, SQL * PLUS, TOAD 8.x/9.x, JIRA, QC 10.x/11.x, Zendesk, Power Designer, Maximo, SAP Business Object 4.0 Web Intelligence. Pac2000

Office Tools:MS WORD, MS EXCEL, MS VISIO and MS Power Point (2003,2007,2010)

WORK EXPERIENCE:

Senior Oracle Developer

Confidential

Responsibilities:

• Working in the D Confidential base Governance Team to provide overall management of the availability, usability, integrity and security of d Confidential used in the Lending Grid application.
• Coordinating with on-shore and off-shore team to maintain 77 d Confidential bases at a time.
• Worked on creating the purge script to delete the d Confidential depending on its retention period.
• Coordinating with DBA to maintain the d Confidential base with partition or through the scripts depending on its BLOB / CLOB columns.
• Creating Procedures for providing consistent grants to all the tables, views and sequences depending on the read-only and read-write roles.
• Resolving the d Confidential base issues based on the application requirement.
• Creating the script for export and import of d Confidential bases schemas for Stress Testing.
• Creating tables and indexes for the BPM application to configure Trans log for Stray node Testing.
• Created various d Confidential base objects such as tables, views, materialized views, procedures and packages using oracle tools likePL/SQL Developer.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Generating the script to keep the d Confidential bases in compliance through locking the owner accounts and providing suitable grant privileges to Roles
• Involved in dropping the schemas which are retired with the DBA.
• Worked on creating DML scripts to insert or update the records based on the requirement or for validation purpose.
• Creating Problem Ticket, LCM JIRA request for DBA to execute the script in the d Confidential base.
• Involved in creating CR for DBA to work on any production changes.
• Created the script for creating synonyms for all the tables and views in user schema for maintaining d Confidential base security.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in Unit testing /Stress Testing meetings with Testing teams to resolve the issues.
• Dealing with high priorities issues. Worked on JIRA TICKETS
• Perform PRE and POST validation for each DDL scripts based on complex SQL queries.
• Analyze and troubleshoot system Issue in timely manner.
• Involve in DBA support in resolving the issue during the EACO call.
• Working on AppDynamics and Splunk for analyzing the d Confidential bases performance and generating reports after SPLI testing.

Environment: -Oracle11g, PL/SQL Developer, JAVA, JIRA, Windows 10 Enterprise, SQL Developer, Notepad++, Microsoft Office, AppDynamics and Splunk.

Senior Oracle Developer

Confidential

Responsibilities:

• Working on Production D Confidential fixes including Invoices, Payments and Enrollment.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in Unit testing PL/ SQL Stored Procedures and Functions.
• Providing d Confidential fix to the escalated and medically urgent issues with updating of d Confidential and sending scripts to production on daily basis.
• Performs Oracle d Confidential base troubleshooting and management.
• Dealing with high priorities issues. Worked on JIRA TICKETS
• Analyzed the tickets based on description in JIRA. Written PLSQL scripts to fix the defects.
• Perform PRE and POST validation for each DDL scripts based on complex SQL queries.
• Generated EDI files based on the requirement with send in 834 and send in 820.
• Prepare documentation of each defect and create its template with Zendesk Id and defect description.
• Analyze and troubleshoot system Issue in timely manner.
• Involved in Maintenance and Resolve CR Tickets. Perform Change Request (CR)/ Implementation Request (IR) after bug fixes.
• Involve in DBA support.
• Created many complex queries to monitor the d Confidential and create statistical reports.
• Supported Testing Team in providing d Confidential, loading d Confidential in test environment using SQL Developer, provided SQLs for testing the Test cases.
• Created various d Confidential base objects such as tables, views, materialized views, procedures and packages using oracle tools likePL/SQL Developer.
• Handled system utilization issues, performance statistics, capacity planning, integrity monitoring, and recovery of d Confidential bases
• Responsible for writing high quality and well documented code according to standards and documentation of various processes
• Conducted PL/SQL session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.

Environment: -Oracle 9i/10g/11g, PL/SQL Developer, JAVA, XML, JIRA, ZENDESK, Windows 7 Enterprise, SQL*Loader, SQL Developer, Notepad++, Microsoft Office, MS Visio 2010.