Professional Summary:

• Experience of 15 years as a Senior Technical Consultant in Information Technology primarily in Oracle SQL, advanced PL/SQL, Database Performance Tuning and Data warehousing.
• Around 6 years in Data warehousing Business Intelligence Technologies using Informatica, Business Objects and Unix.
• Experience in leading and managing teams with multiple roles as Technical Lead, Team Lead, Module Lead and Developer.
• Diverse experience in areas of Requirement, Analysis, design, coding, testing, implementation, maintenance production support.
• Strong in Designing, Development coding , Testing, Implementation and Documentation as per Industry standards.
• Proficient experience on Oracle client/server application tools.
• Involved in various phases of the projects that include requirements analysis, data Assessment, design and development for end-to-end IT solution offerings.
• Experience in Logical Modeling, Physical Modeling, Conceptual Modeling, Dimension Data Modeling, Erwin 4.2/4.0/3.5.5/3.5.2 , Microsoft Visio, Ralph Kimball Methodology, Bill Inmon Methodology, Star Schema, Snowflake Schema, Enterprise Data Warehouse, Data Mart, FACT tables, and Dimension tables.
• Expertise in Oracle Partitioning concepts ,advanced PL/SQL packages with advance features using bulk, bind variables, ref cursors, SQL, Procedures, Triggers, Hierarchical Queries, Aggregate Functions, Analytical Functions, etc.
• Proficient knowledge and a good experience on Oracle Database Performance Tuning using TKProf and analyzing the explain plan.
• Extensive experience on UNIX shells scripting.
• Author technical design document of functional specifications and progress the solution from design through the software development life-cycle to implementation.
• Handled production support of applications in production by trouble shooting issues, proposing solutions, develop and tests fixes.
• Hands on experience in design of Business Objects universe for analyzing the business requirements.
• Extensive support to UAT/BAT/QA Team during testing phase of Project life cycle.
• Having excellent experience on Onsite and offshore model.
• Good team player and able to lead and mentor other developers onsite and offshore.
• Very good interpersonal skills with excellent oral and written communication skills.
• Experience in directly working with onshore clients from various countries and providing system and client support.
• Experience in performing knowledge transfer and coordinating with clients.
• Experience in working in an Agile Team

Confidential

Oracle Technical Consultant

Responsibilities:

• Ad hoc reports as per the business requirement.
• Worked on the Autosys Jobs in running the batch process and resolve any issues during the batch.
• Involved in the Autosys upgrade activities and addressing the issues.
• Involved and supported in the issues during the Oracle Database upgrade to 11.2.0.4
• Worked on UNIX-shell Scripting.
• Provided support during the UAT/BAT/QA phases.
• Working on onsite /offshore model.
• Worked on the version control tool to check in and check out the source code and migration of the code into stage and production environments using SVN.
• Worked on resolving the tickets raised by the End users.
• Worked on the Change requests/Work Requests/Problem tickets.

Environment: Oracle 11g/10g/9i, PL/SQL, TOAD, Microsoft Visio 2007, Unix Shell Scripting, Autosys Job scheduler.

Confidential

Application Analyst/Module Lead/ Senior Oracle Consultant

Responsibilities:

Worked on the Proof of Concept Model and released the same to production.

• Extensively involved in System Study Business Requirements Analysis.
• Involved in the preparation of Functional Specs as part of the solution team.
• Co-ordination with the Business for the requirement and translate the business needs into Technical design.
• Strong analytical skills in resolving and providing solutions.
• Co-ordinate with the team in technical discussion
• Responsible in Designing and development of Logical Physical Data models, Forward and Reverse engineering using Microsoft Visio.
• Developed PL/SQL Packages, Functions and Procedures to implement the Business Logic using Bulk collect ,bind variables ,Ref cursors, dynamic SQL's
• Created Oracle Partition tables like Range/List/Hash/Composite
• Developed shell scripts for batch processing and database transactions.
• Tuned complex queries using Query Optimizer hints, joins and indexes.
• Generated trace files using TKProf and analyzing the explain plan.
• Work on the solution designing and giving inputs to handle complex solutions.
• Work on Informatica workflows/sessions/mappings /transformations.
• Work on queries using Teradata SQL assistant.
• Provide support during the BAT/QA phases.

Environment:: Informatica Power Center 9.5.1/9.1.0/8.6 Designer, Workflow Manager, Workflow Monitor, Repository Versioning, Repository Manager , OBIEE10g, Oracle 11g/10g/9i, Teradata 13 , PL/SQL, TOAD, Microsoft Visio 2007, Unix Shell Scripting, U scheduler.

Confidential

Application Analyst/Module Lead /Senior Oracle Consultant

Responsibilities:

• Extensively involved in System Study Business Requirements Analysis.
• Involved in the preparation of Functional Specs as part of the solution team.
• Co-ordination with the Business for the requirement and translate the business needs into Technical design.
• Strong analytical skills in resolving and providing solutions.
• Handling Major /Minor Enhancements for the application.
• Involved in MIGRATION of source systems from Oracle to Teradata.
• Responsible in Designing and development of Logical Physical Data models, Forward and Reverse engineering using Microsoft Visio.
• Developed PL/SQL Packages, Functions and Procedures to implement the Business Logic using Bulk collect ,bind variables ,Ref cursors, dynamic SQL's
• Create Oracle Partition tables like Range/List/Hash/Composite
• Developed shell scripts for batch processing and database transactions.
• Tuning complex queries using Query Optimizer hints, joins and indexes.
• Generating trace files using TKProf and analyzing the explain plan.
• Worked on the solution designing and giving inputs to handle complex solutions.
• Worked on the design of Business Objects Universe and developed the web intelligence reports as per the business requirement.
• Worked on UNIX-shell Scripting.
• Prepare the technical document as per the Functional specifications
• Worked on Informatica sessions/mappings /transformations.
• Worked on queries using Teradata SQL assistant.
• Provided support during the UAT/BAT/QA phases.

Environment:: Informatica Power Center 9.1.0/8.6 Designer, Workflow Manager, Workflow Monitor, Repository Versioning, Repository Manager, Informatica Administration Console , OBIEE 10g, Oracle 10g/9i, Teradata 13 , PL/SQL, TOAD, Microsoft Visio 2007, Unix/Linux Shell Scripting, U scheduler.

Confidential

Senior Oracle Developer/ Team Lead/SME

Responsibilities:

• Extensively involved in System Study Business Requirements Analysis.
• Handled Major /Minor Enhancements for the application.
• Co-ordinated with the Business for the requirement and translate the business needs into Technical design.
• Attended Weekly Conference Call meetings with clients/counterparts to discuss team tasks, staffing, issues and other concerns.
• Designed specifications and complies with project standards
• Supervised team members and supported the team in any technical issues.
• Managed Code and Development Reviews to ensure that the deliverables satisfy the requirements
• Ensured assigned deliverables are on time and within the assigned budget
• Provided individuals with positive and development feedback and creating Performance Feedback Forms for team members
• Developed PL/SQL Packages, Functions and Procedures to implement the Business Logic using Bulk collect ,bind variables ,Ref cursors, dynamic SQL's
• Created Oracle Partition tables like Range/List/Hash/Composite
• Developed shell scripts for batch processing and database transactions.
• Tuning complex queries using Query Optimizer hints, joins and indexes.
• Generated trace files using TKProf and analyzing the explain plan.
• Worked on the solution designing and giving inputs to handle complex solutions.
• Worked on the design of Business Objects Universe and developed the web intelligence reports as per the business requirement.
• Worked on UNIX-shell Scripting.
• Prepared the technical documents as per the Functional specifications
• Provided support during the UAT/BAT/QA phases.
• Worked on onsite /offshore model.
• Worked on the version control tool to check in and check out the source code and migration of the code into stage and production environments using Kintana.
• Worked on resolving the tickets raised by the End users.

Environment: Oracle 10g/9i, PL/SQL, TOAD, Microsoft Visio 2007, Unix/Linux Shell Scripting

Confidential

Team Lead /Senior Oracle Developer

Responsibilities:

• Involved in the Enhancement in some of the modules like Bank Reconciliation Master forms like employee master, Let-out property master, Deposit master, Transaction forms like Cheque Printing, Bulk Processing Pay Batch , TDS Certificate Generation Printing , Cheque Dishonor, TA, LTA, Claim Payments/Receipts , Pay slip Generation Process, Monthly Process
• Supported the team members in resolving the issues.
• Developed Back end procedures, functions and packages, triggers using SQL, PL/SQL ,Bulk Collect, Ref cursors
• Developed complex reports Using Oracle reports 9i using ref cursors.
• Developed Forms using Forms 9i for various master forms, transaction forms and created PLL library forms.
• Generated fmx, rep files, pll and deployed in the Apps Server.
• Developed Oracle reports 6i for policy schedule, premium register for Underwriting Module, Claims Module in processing claims against a risk/loss/damage for the various class of business using pre-printed formats.
• Created Complex packages and Oracle Reports using ref cursors and printing in pre printed format
• Backend procedures, packages, triggers for the various modules for the application Supported the team in technical Issues and understanding the requirements. Co-ordinated with the team members in resolving issues.

Environment: Forms 4.5/6i/9i,Reports 2.5/6i/9i,Oracle 8i/9i, Oracle 9iAS,Windows,Linux

Confidential

Senior Oracle Developer/Developer

Responsibilities:

• Involved in the Analysis, Design, Development, unit testing of software application.
• Conversion of forms 4.5 to forms 6i and Reports 2.5 to Reports 6i
• Developed Oracle forms 6i and Reports 6i for the various modules for the application.
• Wrote Complex queries.
• Involved in the upgradation of Oracle database from 7.3 to 9i.
• Worked on the export and import of data
• Co-ordinated with the team members in Technical design document reviews and provided solutions.

Environment: Forms 4.5/6i,Reports2.5/6i,Oracle 7.3/8i