SUMMARY

• 5+ years of experience in Database development interact with the business users; created business design document and technical design document for the applications.
• Experience working in all phases of SDLC from analysis, estimate, design, coding, unit testing, system testing and user acceptance testing.
• Experience working in an Agile and Waterfall development environment for Insurance projects.
• Extensively involved in making detailed program specifications, develop test cases, document test results, interface with QA/ Test teams and other IT teams for deployment into production.
• Skilled at PL/SQL, INFORMATICA & UNIX Shell scripting.
• Extensive coding in PL/SQL and very strong in performance tuning and database design expert level Oracle 11g.
• Created and used Functions, Indexes, cursor, Table Partitioning, Collections, REFCURSOR, Views, materialized views, indexes, Packages, Exception handling, Dynamic SQL and Triggers, Stored Procedures in PL/SQL.
• Extensive knowledge of ETL including with Informatica PowerCenter (9.1) in developing and administering ETL mappings with Designer (Source Analyzer, Target Designer, Transformation Developer, Mapping designer, Mapplet Designer), Repository Manager, Workflow Manager & Workflow Monitor.
• Wrote Unix Shell Scripts for scheduling jobs and executing PL/SQL objects.
• Experience in DBA activity, SQL performance tuning using explain plan, query Optimizer and Cost - Based Optimization (CBO).
• Experience in using Oracle development tool such as Toad for Oracle Application Development, SQL developer and PL/SQL Developer.
• An expert in creating documentation for unit testing and requirement gathering.
• Worked on AUTOSYS scheduler to monitor and run the ETL jobs.
• Worked for report creation in PDF and Excel reporting using XML reporting tool for Oracle Database data.
• Acting as POC for Application Development projects.
• Maintaining all the documentation related to developed objects which involve a code review checklist, technical specification, unit test document, FD (functional design) checklist.
• Provided support in various phases of testing (Unit testing, System testing and Integration testing, UAT).
• I conducted class room trainings sessions for new joiners to share my knowledge and bring them up.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Experience in evaluating and performance testing the database applications. Implemented indexes on tables for better performances on data retrieval from oracle.
• Good understanding of the Oracle database, related utilities and tools.
• Good team player with excellent communication, analytical, written and presentation skills with strong aptitude towards learning new technologies.

TECHNICAL SKILLS

• UNIX
• PL/SQL, Informatica, SQR, SQL, SSIS
• Domain Experience
• Oracle 10g, PL/SQL, SQL server
• Insurance & Banking
• SQL, PL/SQL, UNIX
• GUI/ Dev /QA
• TOAD, Putty, PL/SQL Developer, Salesforce, Autosys, Informatica (PowerCenter 9), SSIS

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer

Responsibilities:

• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.
• Development of Packages, Procedures, Functions, Indexes, Triggers and Packages.
• Dealt with SQL Trace, Hints and understanding the SQLT Extract and AWR reports to identify the performance issues.
• Worked on Policy Center, Billing Center and Claim Center DWH and analyzing /extracting/transforming data into common data model and generating the extracts which accepted by ISO/MSO/AAIS Bureaus.
• Developed ETL packages using SSIS/Informatica Power Designer for various customers to fetch data from different EDW sources.
• Loading (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sysbase and SQL server.
• Worked on different LOBS related to insurance which are Personal Lines (Homeowners, Dwelling, FAL and Farm Owners) and Commercial Lines (General Liability, Crime, Inland Marine, Commercial Auto Liability/No Fault/Physical damage and Fire and Allied Lines).
• Worked on UNIX shell scripting in automation of ETL Jobs.
• Creation of logs from the UNIX shell scripts for auditing the automated Workflow process.
• Working on Agile Methodologies with daily scrum meetings and share point/Microsoft Planner to update and monitor tasks.
• Processing the Interface Data using the SQL Loader by loading the data using Flat Files.
• Working on Adhoc Reports by writing Complex SQL’s using TOAD and SQL Developer.
• Enhanced the existing ECA (Error Correction Application) application based on the client requirements.

Environment: SQL server Management Studio for different client Database, Visual Studio Management Studio, Cisco Any Connect with client Database, JIRA

Confidential

PL/SQL Developer

Responsibilities:

• Created and tested all PL/SQL objects like Procedure and Packages to implement business rule and process the data.
• Attended all knowledge transfer session about new product and created word documents for new joiners.
• Used collection, view, cursor, exception, index, partition while creating process to deal with banking transaction data.
• Creating report for all end user having detail about transaction related to credit card and other process using SQR.
• Created numbers of jobs using SQR to generate LIS report and text file.
• Develop, test and generate report using SQR language. This SQR is the reporting language to define the value to end users
• Ensured that all components are integrated and implemented.
• Used explain Plan to optimize query and tuned accordingly.
• Implemented processes for debugging of defects, errors and troubleshooting problems relating to database objects.
• Strong client-oriented communication skills.

Environment: UNIX, PL/SQL developer, DNA Application

Confidential

PL/SQL Developer

Responsibilities:

• Responsible for processing the data and generating reports for customers in PDF using Online/Offline applications which will take the data from ORACLE database.
• Includes in working for Application development and Application maintenance.
• Assisted DBAs on support needs and provided guidance on architectural issues.
• Developing the objects packages, triggers, views, functions and indexes, stored Procedures in PL/SQL based on functional description to process the data.
• Extensively used Joins and sub-queries for complex queries involving multiple tables.
• Created UNIX shell scripts triggered by PL/SQL stored procedure.
• Created scheduler for all script mentioning dependency and order of trigger.
• Understanding the issue faced by client and reply with a satisfactory explanation within the first response SLA.
• Performed Query optimization and PL/SQL tuning to maximize performance.
• Involved in creating Indexes, using hints, analyzing the table statistics and Table.

Environment: Oracle 11g, UNIX Shell Programming, PL-SQL Developer.