SUMMARY

• Around 12 years of IT experience in software development, maintenance and support of various web based applications using Oracle 10G/11G, Pl/Sql, Forms, Reports, Pro*c, Oracle ERP.
• Expertise in Interfaces, Conversions, Customizations and Extensions in Oracle Applications.
• Ability to work on completely custom applications.
• Extensive experience in Oracle 8i/9i/10g/11g/12c, PL/SQL, SQL and SQL*Loader.
• Extensively worked on Forms Personalization’s.
• Having good exposure on PL/SQL advanced concepts like collections, varrays, nested tables, bulk collect, table type objects, REF cursors etc.
• Hands on experience with cursors and ref cursors for PL/SQL objects
• Experienced in using Tables, Views, Complex views, Synonyms, Indexes, Sequences, Constraints, Functional Based index, External tables, DB links.
• Involved in activities including requirement analysis, design, coding, testing and implementation of business logic using PL/SQLtechnologies.
• Ability to support and assistance development team in the design and development
• Peer review ofPL/SQLcode and shared effective feedback to the team members.
• Good knowledge on Object Oriented Concepts, java/j2EE technologies, Oracle Applications.
• Experience on Unix & shell scripting
• Having the good knowledge on Banking and financial domain
• Have experience in Customization of Oracle Application features.
• Proficient in writing PL/SQL Stored Procedures, Functions, Packages and Triggers.
• Strong Conceptual, Analytical and problem solving skills. Highly motivated team player with immense ability to grasp new concepts and apply them.
• Excellent verbal, written, communication and presentation skills.
• Highly proficient in creating Business Requirement Documents (BRD), Functional Requirement Documents (FRD) and Technical Detailed Design Documents.
• Adept at Designing Conceptual, Logical, Extended Logical and Physical data models in Oracle database environments

TECHNICAL SKILLS

Oracle Applications: Oracle Applications (PO, INV, OM,PA)

Operating Systems: Unix, Linux, Windows XP/7.

Languages: SQL, PL/SQL, C, C++, HTML, JavaScript

Databases: Oracle 8i/9i/10g/11g/12c

Tools: Oracle Forms 6i, Reports 6i, TOAD, SQL*Plus, SQL*Loader, Data loader, Kintana, PVCS, Quality Center, Putty

Utilities: MS - Office (Word, Excel, Outlooks)

Scripting Language: Shell, Java Script

PROFESSIONAL EXPERIENCE

Confidential

Data Architect /Data Modeler

Responsibilities:

• Designing Conceptual, Logical, Extended Logical and Physical data models in Oracle database environments
• Manage Production support team and provide solutions for production issues.
• Manage team for data processing, migrations.
• Very strong hands on experience on Oracle DB, Unix based systems, job scheduling tools etc..
• Maintained the internal forums for techno-functional questions.
• Handled many performance optimization bugs. Dealt with SQL Trace, Tkprof, Hints,
• Histograms and Statistics.
• Monitoring the SR’s and tracking of the statuses.
• Mentoring team members in their assigned tasks and helping them for any issues.
• Bug fixing Customers logged bugs in Stored Procedures, Oracle Forms, Oracle Reports and Pro*C.
• Preparation and execution of Unit Test Cases.
• Providing Knowledge transfer to the new team members when required.
• Coding and resolving defects raised by QA.
• Bug reviewing, patch Creation of the bugs.
• Conducting Weekly Team meetings in which we discuss about the monthly targets.
• Writing Oracle PL/SQL Stored Procedures for enhancements.
• Conducting Support meetings which we discuss about the customers satisfaction related to our support.
• Working on SR’s timely providing the resolutions in efficient manner.

Confidential

Data Architect /Data Modeler

Responsibilities:

• Designed daily load of feed data using oracle technologies (Job Scheduler, PL/SQL, SQL-Loader).
• Successfully designed and implemented daily data transfer from internal and external systems through various technologies.
• Managed the project with offshore and onsite resources.
• Involved in the design and implementation of data architecture for the OLTP and Data transformations.
• Preparation and execution of Unit Test Cases
• Involved in writing PL/SQL blocks which implement business logic.
• Involved in code reviews for the code written by other team members.
• Involved in Exporting and Importing tables.
• Coding and resolving defects raised by QA.

Confidential, CA

Data Architect /Data Modeler

Responsibilities:

• Requirement analysis
• Coordinated with business and BAs.
• Involved in the setting up of a new team offshore and onsite.
• Created and maintained the data design artifacts such as diagrams and design standards.
• Using SQL Loader, loading the data from Old System to New System and performing
• Data validation on staging tables then loading into main tables.
• Preparation of FD review check list, Technical Design Document,
• Preparation and execution of Unit Test Cases
• Coding and resolving defects raised by QA team using Quality Center
• Creation of Kintana Packages for the migration of code to various test environments.

Confidential

Data Modeler

Responsibilities:

• Writing Oracle PL/SQL Stored Procedures (Procedures, Functions, Packages)
• Writing Database Triggers
• DCR’s raising and approving when raised by the team.
• Involved in Claims and guarantees module, which is heart of the project.
• Job scheduling the batch processes.
• Involved in the Development of reports and required changes in the Business Objects (BO) reports.
• Involved in Analysis, Design and Implementation of functional.
• Change Requests for BO Reports.
• Configured new Business requirements in the BO Reports
• Preparing UTP and SIT test cases, Impact Analysis, effort estimates.
• Involved in deployment activities for BO Reports.
• Interaction with the Clients to find the Business Requirements.
• In addition to development, taken responsibility of DBA role.
• Activities involved in DBA
• Export and Import Activities.
• Preparation of release packages which we send to the client
• Weekly Backups
• Looking into locking issues.
• Utl smtp setup in Mail box
• Build Deployments in various databases.
• Database space monitoring
• System Date changing, giving necessary privileges as requested by the user.
• Technical guidance to the team
• Generation of trace file as requested by the user.
• Bringing old data by flashback recovery concepts.

Confidential

Software Developer

Responsibilities:

• Developed all forms of objects (Table, View, Triggers, Stored Procedures, SQL-Loader, etc).
• Writing Oracle PL/SQL Stored Procedures.
• Created both the Physical and Logical Data Model.
• Development of forms /Reports.
• Coordinated and worked in the design with global teams to create Database with new Database Architecture in Oracle 9i from multiple database systems.
• Created both the Physical and Logical Data Model.
• Prepared BRD for the maintenance system.