Oracle PL SQL Senior Developer

MEHUL MEHTA

Email: ***********@******.***

Mobile: 623-***-****

Oracle PL SQL Senior Developer

PROFESSIONAL SUMMARY:

* ***** ** ************ ********** as a Software Engineer in Databases, Reporting Tool, Web based applications, Product Development and Data Migration.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Extensive exposure in Databases like Oracle 11G & 10G, IBM DB2 and SQL Server 2005.

Expertise in Client-Server application development using Oracle 11g/10g, PL/SQL, PL/SQL developer, SQL *PLUS, TOAD.

Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Ref Cursor, Dynamic SQL, Joins and Exception Handling.

Created Tables, Views, Constraints, Sequences, External Tables, Index (B Tree, Bitmap and Function Based).

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Loaded Data into Oracle Tables using SQL Loader.

Developed Materialized views for data replication in distributed environments.

Expertise in writing the Complex SQL queries.

Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

Experience in query optimization, Performance tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of Global Temporary Tables and Table Partitioning.

Experience in using several built-in database packages such as DBMS_JOB, DBMS_OUTPUT, UTL_FILE, and DBMS_SQL to name a few.

Strong experience in Data Warehouse concepts.

Extensive knowledge on Conceptual, Logical and Physical Data Modeling using normalizing Techniques.

Created Shell Scripts for invoking SQL scripts and scheduled them using Crontab.

Experience in UNIX Commands and Extensive Exposure in defect tracking tools like BMC Remedy and Service Now.

Extensive Exposure in Agile/SCRUM and Waterfall Methodologies.

Extensive Exposure in Maintenance, development and production support projects.

Proficient in analyzing and translating business requirements to technical requirements and architecture.

Experience in the Document Preparation.

Executed software projects for Healthcare, Life Sciences and Banking and Insurance industries.

Extensive exposure to work independently.

Good ability to quickly grasp and master new concepts and technologies. Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

EDUCATION & CERTIFICATIONS:

Masters In Computer Applications (Computer Science and Engineering - Specialization) – 2006 Pass out, Veer Narmad South Gujarat University, Surat, India.

Oracle Certified Associate in Oracle 9i.

TECHNICAL SKILLS:

Primary Skills (RDBMS) : Oracle 11G & 10G, IBM DB2 and SQL Server 2005.

Programming Lagunage : Oracle PL/SQL,T-SQL, Shell Scripting and .Net

Operating Systems : Windows XP, Windows 2007, Windows 8.1, Unix (Sun Solaris

and Linux 5.2)

Defect Tracking Tool : BMC Remedy and Service Now

Other Tools : Toad, Oracle Sql Developer, PL/SQL Developer, Sql*Plus,

SQL Management Studio, Erwin, SFTP, Putty, Microsoft Visual SourceSafe and WinSCP.

Employer and Work Permit:

Employer Name: Cognizant Technology Solutions

Website: http://www.cognizant.com

Work Authorization: Holding Green Card.

PROFESSIONAL EXPERIENCE:

# 1: Project Title: Transaction Repository (TR)

Role: Technical Lead - Oracle

Duration: June 2014 – Till Date

Employer: Cognizant Technology Solutions

Client: Health Net Inc, USA Work Location: Woodland Hills, CA, USA

Project Description:

Transaction Repository (TR) provides real time data related to Provider, Member, Claims, and Billing etc. in the standard format from the core systems. TR gets data feed from the inbound interfaces such as ABS, Unity, Qcare, Kbase, ODW, MC400, HNWeb, GEMS, PSA and Third party vendors. The TR database is used by the outbound interfaces such as PAOS, Magic, IVR, EDI, CORE and HNWeb.

Responsibilities:

Gathered and documented the business requirements. Created the initial conceptual design, entity relationship diagrams and database objects.

Prepared the SQL Scripts, Packages, Stored Procedures, Functions and Views to implement the Business logic.

Created database objects like Tables, Sequence, Synonyms, Views, Materialized Views, Indexes and Collections.

Used Join to write the complex queries.

Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like EXPLAIN PLAN, TKPROF, AUTOTRACE and DBMS_SQLTUNE.

Working on data fixes to update the corrupted data in the production.

Preparing the report to find out the corrupted/in valid business data and share with business.

Writing the Script/Procedure to fix the corrupted/in valid business data in Data base.

Supporting the production deployment for data fixes scripts on daily basis.

Meeting with the Business analysts people to discuss the data fix issues on daily basis.

Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.

Analyzing the Existing data model and modify the data model to implement the New/Enhancement business requests.

Created Shell Scripts for invoking SQL scripts and scheduled them using Crontab.

Used the UNIX Commands.

Extensive Exposure in BMC Remedy defect tracking tool.

Migrating the Existing data into new Source system.

Analyzing the gaps between the old source System and new source system and estimate the time frame to complete the gaps.

Involving the Code review and Unit Testing of the new development.

Preparing the report data for validation for pre and post deployment process.

Coordinating with the Onsite team members about the New/Enhancement Requirement analysis, Design and Development.

Supporting the off-shore development team to understand the problem and the fix that is required for the problem.

Maintenance and support of existing source codes and data.

Technologies and Tools Used: Oracle 11G, PL/SQL, JDK 1.6, Unix, Shell Scripting, Windows 7, BMC Remedy, Oracle PL/Sql Developer, Toad and WinSCP.

# 2: Project Title: Digital Identity Gateway (DIG)

Role: Technical Lead – IBM DB2

Duration: May 2013 – March 2014

Employer: Cognizant Technology Solutions

Client: American Express Location: Phoenix, AZ, USA.

Project Description:

Digital Identity Gateway (referred as DIG henceforth) service is proposed to serve as a single gateway to retrieve and persist any kind of preferences in relation with heterogeneous digital identities. DIG service exposes an unified interface which would enable internal and external clients to persist different identities and attached preferences in the Digital Identity and Preferences database. DIG also enables the client systems to query one or more specific preferences datasets for a given digital identity and associated filtering criteria. DIG enforces fine grain access control on the preference data for a given combination of preference type, client identity and permissible action.

Responsibilities:

Worked in preparing the Stored Procedures, Functions, Triggers, Package, Cursors, Views and Joins.

Worked in Performance Tuning.

Worked in data model preparation.

Worked in Code Review.

Worked in UAT defect fixing.

Worked in writing the complex SQL queries.

Worked with Clients to get the New and Enhancement report Requirements.

Maintained the Existing reports and SQL codes and objects.

Worked in the Document Preparation about the New and Enhancement Requirements.

Worked in Unit Test case preparation.

Worked in Unit Testing using the Unit Test Cases.

Worked with clients to prioritize the current work items.

Convert the functional requirements to Technical specification.

Coordination with off-shore team from onsite.

Ensured the delivery of the New Enhancements and reports to the business in timely manner with Quality.

Weekly updating the work status with the client.

Monthly meeting with the client highlighting the achievements and challenges.

Technologies and Tools Used: IBM DB2, Java/J2EE, PL/SQL, SFTP, Jmeter.

# 3: Project Title: RAAV (Data Migration Project)

Role: Oracle Pl Sql Senior Developer Duration: Sep 2009 – April 2013

Employer: Cognizant Technology Solutions

Client: Merck Inc. Work Location: Pune, MH, India.

Project Description:

RAAV is an abbreviation for Registration, Authentication, Access management and Validation. Legacy Migration is intended to support and facilitate all the legacy users of various countries to be available in the new system RAAV. There are several countries which use legacy Merck portal services including physicians, Surgeons, etc. New system RAAV (Registration, Authentication, Access management and Validation) is designed to address loop wholes found in existing system. All existing legacy data to be migrated into new system RAAV. The application is fully automated and designed in database. It generates various reports for every migration run having statistical information showing actual status in RAAV.

Responsibilities:

Involved Data Migration from CSV Files to Oracle 10g DB through SQL Loader.

Involved in database design.

Involved in preparing the Stored Procedures, Functions and Triggers.

Involved in Unix and Shell scripting.

Involved in Performance Tuning.

Involved in Code Review.

Involved UAT defect fixing.

Involved Document Preparation about the Migration (Detail of Field Mapping).

Involved Document Preparation for Report Module.

Involved in Unit Test case preparation.

Involved in Unit Testing using the Unit Test Cases.

Technologies and Tools Used : Oracle 10G, PL/SQL, Windows XP, Unix, Shell Scripting, Toad, Sql*Plus and SQL Management Studio.

Other Companies Projects in INDIA:

1. ICICI Lombard Health Insurance: The proposed solution will automate, normalize and track the various processes currently being followed in Health Claims workflows at ICICI Lombard. The solution will deploy a complete workflow application to handle the operations of claims for the health Insurance policies issued by the retail and group vertical of ICICI Lombard General insurance company. This application is purely intranet and internet based application for the employees of the ICICI Lombard to carry out the operations in Health Insurance claims. This application in turn integrated with various other applications like policy admin systems to take the policy information and end-user applications to get the claims status to insured.

Client and Duration: ICICI Lombard (Jan 2008 – Sep 2009)

Technology: Oracle 10g (SQL, PL/SQL)

2. Issue Management System (IMS): Issue Management System helps manage the customer support cases from issue logging to issue closure for any organization. It helps create customer case (through which customer might have reported problem(s)) workflow between Customer Support Agents that are part of one or more geographically dispersed Customer Support Centers and back-end office operations personnel.

Client and Duration: Promise Technology (Nov 2006 – Jan 2008)

Technology: Oracle 10g (PL/SQL)

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Participated in the requirement Analysis of the Application,

• Design- Approach note for all the reports.

• Creating packages, writing stored procedures, functions etc. for report development.

• Development of reports.

• Code review and testing.

• Had close co-ordination with testing team.

Contact this candidate