Profile

• 9 years of hands on experience in development, customization, enhancement and localization of Oracle Application using D2K Forms 10g, Reports 10g , SQL, PL/SQL Oracle 11g/10g/9i Database in Windows 2000/2003 Professional environment.
• Worked on Warranty Systems,Healthcare, Retail, and Education Airways domains.
• Expertise in business process engineering and software development life cycle, including analysis, design, development and implementation of software applications.
• Excellent communication skills and ability to work efficiently in onsite-offshore model with cross-functional teams including application super-users, system end-users, functional analysts, business analysts and technical consultants.
• Played the roles of Project lead Tech lead during my stay at the projects.
• Excellent written and inter-personal communication skills.
• Extensive experience in client facing roles and working in multicultural, multi-geographic teams.
• Ability to be an effective team player and work under time constraints.
• Prepared Technical Specification documents based on the documents provided by functional team.
• Used SQL Loader for uploading flat file data into Staging Tables
• Involved in post implementation maintenance and played a key role in performance tuning
• Extensive working experience in applying relational database concepts, Entity relation diagrams and normalization concepts.
• Proficient in Oracle SQL Tuning and PL/SQL debugging.
• Written complex queries to facilitate the supply of data to other teams.
• Technically strong in SQL, PL/SQL, Procedures, Packages, Functions, Triggers, Sql loader.
• In addition to excellent technical abilities possesses strong oral and written communications skills, analytical and interpersonal skills.

Proficiencies:

Project Details

Confidential

Database Analyst/PLSQL Developer

Responsibility:

• Created functional design document for Coding broker module.
• Data Model through Data modeler tools Such as Visio.
• Used SQL loader to load data.
• Created Packages, Procedures functions for Coding broker module.
• Coded, tested, debugged, documented, and maintained application programs.
• Weekly meetings with business users from various regions such as South America, North America to
• Analyze the data gathered for parts from the suppliers.
• Involved in Integration testing.
• Worked with business analysts and business users in analyzing the requirements.
• Participated in the daily stand up SCRUM AGILE meetings as part of AGILE process for reporting the day to day developments of the work done.
• Involved in DBA activities such as creating the DDL's, GRANT Export-import utilities.
• Created Data flow diagrams using VISIO.
• Used shell scripting to load files in the respective tables and invoke the procedures.

Environment: Oracle 11g, PL/SQL, SQL, SQL Loader. LINUX

Confidential

Project Lead Service Delivery Operations

Responsibility:

• Created HLD,LLD for Scorecards Redesign
• Data Model through Data modeler tools Such as Visio.
• Used PL/SQL using external tables to load data.
• Generated reports for Operations Service delivery Team.
• Created Procedures Packages for Service delivery.
• Coded, tested, debugged, documented, and maintained application programs
• Conducted system impact testing for all customizations in approval process
• Used PL/SQL using external tables to load data.
• Worked with cross-functional teams including application super-users, system end-users, financial analysts, business analysts, functional analysts etc
• Delivered daily, monthly reports for the Service delivery and Operations Team.
• Interacted with clients and end-users to do the requirements gathering, carry out analysis and design to meet their business requirement

Environment: Oracle 11g, PL/SQL, SQL, SQL Loader, TOAD

Confidential

Project Lead

• The objective of the project is
• It has various module such as Inbound, HLOP, Claims and Outbound.
• To process the claims and settle the payments.
• Capturing Data from various Health care providers and load into HLSC Database.
• To generate 835 file claims document.

Responsibility:

• Gone through the Requirement document and prepared Analysis document.
• Data Model through Data modeller tools Such as Visio, Erwin
• Generated DDL for all the module Inbound, HLOP, Claims, Outbound
• Created Triggers, Sequence for the Module Inbound HLOP
• Extensive package debugging and customizing
• Coded, tested, debugged, documented, and maintained application programs
• Involved in development and deployment of application on Windows environment
• Conducted system impact testing for all customizations in approval process
• Used PL/SQL using external tables to load data.
• Experience in creating Triggers, Packages, Procedures, Functions, Cursors and Exception Handlers, Record Groups
• Worked extensively to debug extremely urgent Production system critical incidents and concurrent request failures
• Worked with cross-functional teams including application super-users, system end-users, financial analysts, business analysts, functional analysts etc
• Extensively worked on Packages that enable the grouping of related PL/SQL objects, such as Cursors, Procedures, Variables, Functions, Constants, and Type Declarations.
• Involved in creation and updates of several SQL packages and Procedures.
• Worked on Triggers to provide a way of executing PL/SQL code on the occurrence of specific database events.
• Maintained an audit log by setting triggers to fire.
• Developed the forms, Reports to Oracle forms and Reports 11g from the legacy system Oracle Forms and Reports 6i.
• Involved in designing Data flow diagrams, ERD's, Use case diagrams, Process flow diagrams.
• Interacted with clients and end-users to do the requirements gathering, carry out analysis and design to meet their business requirement
• Participated in the daily stand up SCRUM AGILE meetings as part of AGILE process for reporting the day to day developments of the work done.
• Wrote technical design documents for conversions, extensions, interfaces and report

Environment: Oracle 11g, PL/SQL, SQL, SQL Loader, TOAD

Confidential

Sr.PL/SQL Developer

Responsibility:

• Gone through the Requirement document and prepared Analysis document.
• Prepared Low Level Design Documents.
• Developed and also made enhancement in reports.
• Developed PL/SQL Functions, Cursors for various calculations in the application.
• Used bitmap Indexes, materialized views and partition tables to optimize the queries.
• Worked closely with Production support team 24 by 7 format to analyze and fix the production issues including bug fixing, data fixing, etc.
• Involved in Unit testing and Bug fixing.
• Created stored procedures, Functions and Packages.
• To generate RTZ Exit Migration report every month for user migration Analysis.
• Data Loading through SQL Loader into Travel information Database.
• Various report creation for CM FM Team.
• Participated in the daily stand up SCRUM AGILE meetings as part of AGILE process for reporting the day to day developments of the work done.

Environment: Oracle Forms Reports 10g, Oracle Database 10g PL/SQL

Confidential

Team Lead

Responsibility:

• Gone through the Requirement document and prepared Analysis document.
• Prepared Low Level Design Documents.
• Extensively worked on Packages that enable the grouping of related PL/SQL objects, such as Procedures, Variables, Cursors, Functions, Constants, and Type Declarations.
• Involved in creation and updates of several SQL packages and Procedures.
• Worked on Triggers to provide a way of executing PL/SQL code on the occurrence of specific database events.
• Maintained an audit log by setting triggers to fire.
• Involved in designing Data flow diagrams, ERD's, Use case diagrams, Process flow diagrams.
• Developed and also made enhancement in reports.
• Involved in Unit testing and Bug fixing.
• Created stored procedures, Functions and Packages.
• Code Development on the Change Requests

Environment: Oracle Forms Reports 10g, Oracle Database 10g PL/SQL

Confidential

Developer

Responsibility:

• Code Development on the Change Requests and Problem Reports.
• Effectively tuning the performance of the application.
• Gone through the Requirement document and prepared Analysis document.
• Prepared Low Level Design Documents.
• Developed and also made enhancement in reports.
• Involved in Unit testing and Bug fixing.
• Created stored procedures, Functions and Packages.
• Involved in Support Maintenance.

Environment: Development with Oracle 10gDataBase and Oracle Forms and Reports -10g, SQL Developer.

Confidential

Developer.

Responsibility:

• Understanding and analyzing the WMS Yantra product
• Providing Technical support to the Yantra Users and carrying out emergency code fixes.
• Handling of the enhancements, testing and go-live of the new patch codes.
• Developed Stored Procedures, Triggers, Shell scripts using PL/SQL, SQL
• Interacted with Client to capture the requirements of the existing system and regular updating in the requirements as the system has undergone many changes as requested by the users of the system.
• Re-Engineering, bug fixing, enhancements.
• Fine-tuned Database queries for faster performance.
• Developed Forms Reports through the help of end user requirements.
• Day today backup operation Exporting data as DMP files Log files from Oracle 10g database.
• Interacted with end users, performed unit user acceptance testing in specific user database.

Environment: Oracle 9i database, Forms Reports 6i, PL/SQL Developer.

Confidential

Developer.

Responsibility:

• Analyzing the Client requirements and documenting the low level analysis performed.
• Code Development on the requirements and defect fixes.
• Monitoring sessions created by different users AND allocated tablespaces in production environment.
• Day today backups taken from Oracle 9i database.
• Export Import utilities used for updating latest data in application.
• Developed Reports as per end-users requirements.
• Implemented all over the branches in North - India.