EXPERIENCE SUMMARY:

• About 10 years of experience in Oracle technology including Oracle SQL, PL/SQL, MOD PL/SQL, Oracle D2K Forms and Reports Development and Oracle DBA.
• 5 years of experience of client - server and n-tier software development and maintenance using Oracle Forms reports and Oracle SQL, PL/SQL.
• 3 years of experience as Oracle DBA. 1 yrs experiencein in MS/SQL DBA and developemnt.
• 9.7 yrs of experience in Oracle PL/SQL.
• 1.6 years of experience in MOD PL/SQL for n-tier application.
• Strong knowledge of database and application design.
• Good knowledge in database design and modelling.
• Good experience on Manufacturing (ERP ORION), Financial Services Sector (client server ERP application for trade processing - Confidential, Web based application for Kit punching and several reports - IBOSS, Core Banking - System Access), Healthcare and billing (Carelogic system) Education Sector.
• Good knowledge in retail and corporate banking.
• Good knowledge in healthcare (Electronic clinical record, Service document Billing).
• Strengths include excellent interpersonal and communication skills, meets deadline, team player, ability to complete work without supervision.
• Analytical thinker that consistently resolves ongoing issues or defect, often called upon to consult on problems that have eluded resolution by others
• Possesses excellent analytical, problem solving, and quick learning skills as well as keen interest in emerging technologies.
• Good knowledge on CMMi level 5 standards
• Good knowledge in Agile methodologies.

AREAS OF EXPOSURE:

• Good knowledge of carelogic healthcare system.
• Oracle 9i, 10g DBA. Materialized view, Table and Index partitioning, Backup and recovery using Export/Import, Data Pump and Cold Backup, Performance Tuning.
• Good knowledge of Confidential .
• API Development in PL/SQL
• Good knowledge in Term Deposit account. TDA opening, pretermination, redemption and TDA maintenance.
• Familiar with deposit module.
• Setup and transactions like BOM, purchase order, Inventory, MRP, etc.
• Good understanding of Production and Manufacturing.
• Good understanding of General Ledger and PSI (Purchase Sale Inventory) setup and interrelations.
• Accounting Setup.
• Good knowledge of AR/AP/GL.
• Good exposure of Orion an ERP, finance
• Good knowledge of securities related financial transactions.
• Identifying existing employee, resigned employees.
• Management of Employee reporting to employee particularly in Sales employees

TECHNICAL EXPERTISE:

Language: Oracle SQL, PL/SQL, HTML, XML, Java Script, Linux and DOS Shell Script

GUI: Oracle D2K 6i, 9i Forms, Reports

ERP: ORION, Confidential

APIs: System Access API

Concepts: OOAD

Tools: TOAD, SQL Developer, PL/SQL Developer, Confidential, VSS, SVN XML to API, BIRT, MS Office, Crystal Report, Pentaho report

Database: Oracle 9i, Oracle 10g, Oracle 11g

App. Server: Oracle 9i Application server

Operating System: Windows 2003 Server, Linux

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead

Responsibilities:

• Support all channels like (IVR, ATM, Internet Banking, WAP, Seible, E- corp, Systematics, call Centre etc) request logs.
• Design and maintain Package, Procedures, Functions, Tables, Views, Materialized Views etc. Using of SQL Loader to load data into ODS from legacy system.
• Performance tuning of Procedures and queries.
• Creating scripts to deploy changes in all the environment.
• Used ER diagram and DFD for design.

Environment: s: Oracle SQL, PL/SQL, Forms, Reports etc. Windows

Tools: PL/SQL Developer, D2K Forms and Reports, Clear Case, Clear Quest, Toad, Golden Gate

Confidential, Nashville, TN

Project Management, Technical Lead

Responsibilities:

• Overall owner of entire deliveries including requirement gathering, work allocation in team, development and deliveries.
• Web based application support which required creation of tables, stored function, procedures, Indexes, sequences etc.
• Creating scripts to deploy changes in all the environment.
• Used ER diagram and DFD for design.

Environment: s: Oracle Mod PL/SQL, SQL, XML, Windows

Tools: PL/SQL Developer, Oracle Reports

Confidential, Nashville, TN

Project Management, Technical Lead

Responsibilities:

• Overall owner of entire deliveries including requirement gathering, work allocation in team, development and deliveries.
• Web based application enhancement which required creation of tables, stored function, procedures, packages, Indexes, sequences etc.
• Creating scripts to deploy changes in all the environment.
• Used ER diagram and DFD for design.

Environment: s: Oracle Mod PL/SQL, SQL, XML, Windows

Tools: PL/SQL Developer, Pentaho Reports

Confidential

Senior DBA

Responsibilities:

• Management of database which includes database installation, Creation of tables, stored function, procedures, triggers, Indexes, sequences etc.
• Creating scripts for database installation which includes SQL Loader, DOS Scripting, Shell scripting.
• Used SQL Developer for database development
• Used ER diagram and DFD for design.
• Support Java developers for SQL queries and database related development and issues.

Environment: s: Oracle PL/SQL, SQL, XML, Linux, Windows XP, Windows 2003 server, Windows 2008 server

Tools: PL/SQL, SOAP

Confidential

Senior DBA

Responsibilities:

• Management of database which includes database installation, Creation of tables, stored function, procedures, Indexes and Index partitioning, sequences, Materialized View etc.
• Data modelling using Confidential Workbench. Creating Models, dimensions, Worksheet, Relations etc.
• Involved in requirement gathering and database design for Line of Business enhancement.

Environment: s: Oracle PL/SQL, SQL, Windows 2003 server

Tools: SQL Developers, Analytics

Confidential

Senior DBA and Senior Developer

Responsibilities:

• Management of database which includes database design, Creation of tables, stored function, stored procedures, Package, partition and sub-partition of Index, sequences, views, Synonyms, Roles, Tablespace, backup and recovery, performance tuning etc.
• Creating scripts for database installation which includes SQL Loader, DOS Scripting, Shell scripting.
• Used SQL Developer, PL/SQL developer for database development
• Monitoring application for performance tuning.
• Design document for (ER diagram and DFD) for new features and enhancement.
• Support Java developers for SQL queries and database related development and issues.

Environment: s: Oracle PL/SQL, SQL, XML, Linux, Windows XP, Windows 2003 server

Tools: SQL Developer, PL/SQL Developer, SOAP, Crystal Report, MS Access

Confidential

Module Lead and Sr. PL/SQL developer

Responsibilities:

• Lead the API team and responsible for delivering the modules Term Deposit, CASA and Product Details.
• Involved in analyzing the requirements.
• API Developments
• Developed bi-lingual reports.
• Maintenance of Shell scripting.
• Creating of Package, Stored procedure, Function, Types, Nested tables, Varrays, temporary tables etc.

Environment: s: Oracle Forms, Reports, PL/SQL, SQL, XML, Linux, Windows XPTools: PL/SQL Developer, SQL Developer, XML2API.

Confidential

Project Lead, Mentor, Sr. Oracle developer and Quality Lead

Responsibilities:

• Lead the 6 member team and responsible for delivering the product.
• Involved in analyzing the requirements.
• Responsible for low level design to GUI process including SRS.
• Ownership on Workshop modules.
• Assigning the works to team and implemented the CMMi level 5 standards.
• Providing technical-functional support to team.
• Involved in analyzing the requirements.
• Create template for Forms, and reports interface. Create Package, Stored procedure, Function, Tables, Triggers

Environment: s: Oracle D2K Forms 6i, Reports 6i, Oracle 9i PL/SQL, SQL, Windows XP

Tools: TOAD

Confidential

Lead, Sr. Oracle Forms developer

Responsibilities:

• Lead the team.
• Architectural involvement for Orion 10.6 looks and feel.
• Design and develop the Orion looks and feel suggested by HFI.
• Reporting to vice president directly for the design changes.

Environment: s: Oracle D2K Forms 6i, Reports 6i, Oracle 9i PL/SQ

Confidential

Module Lead and Sr. Oracle developer

Responsibilities:

• Mentor the team.
• Customization of manufacturing and Production modules.
• Improving performance of reports.
• Directly communication of on-site co-ordinator and customer.

Environment: s: Oracle D2K Forms 6i, Reports 6i, Oracle 9i PL/SQ, SQL, Crystal reports, TOAD tools, Oracle 9i Application Server.

Tools: TOAD

Confidential

Module Lead and Developer

Responsibilities:

• Mentor the team.
• Handling branch request for production support.
• Tuning of Oracle reports. Since daily millions of transactions were performing and thousand of reports request were coming, it was challenge to generate report faster.
• Managing Oracle 9i Application Server.
• Creating design document for enhancement.
• Creating Oracle objects like Table, Table partitioning, Package, Procedure and Function, Synonyms, PL/SQL table, Oracle large object (LOB) etc.
• Maintenance of IBOSS.

Environment: s: Oracle D2K Forms 6i, Reports 6i, Oracle 9i PL/SQ, SQL, Oracle 9i Application Server. HTML, JAVA Beans, Java Script

Tools: TOAD, Crystal reports

Confidential

Developer

Responsibilities:

• Maintaining the applications modules. Developing Oracle Forms and reports based on requirement.
• Handling back office request for production support issues.
• Providing quick and immediate solutions for the back office supports.
• Tuning of Oracle reports.
• Brought the concept of Materialized View in Confidential .
• Creating design document for enhancement.
• Created several Forms, Reports oracle 9i object like table, Table partitioning, Materialized view, DB Link, Package, Procedure and Function, Synonyms, PL/SQL table, Oracle large object(LOB) etc
• Installation of Confidential on user’s machine.
• Follow up with the management for the requirements.
• Generating and providing CSV files.
• Providing solution to the branch office related to trade processing.

Environment: s: Oracle D2K Forms 6i, Reports 6i, Oracle 9i PL/SQ, SQL, Windows 2000 Adv. Server

Tools: TOAD, Crystal reports

Confidential

Developer

Responsibilities:

• Writing PL/SQL stored Procedures, Functions.
• Providing data to IVRS system, based on request.

Environment: s: Oracle 9i PL/SQ, SQL, Windows 2000 Adv. Server, TOAD