SUMMARY:

• 9+ years of experience as software designer and developer.
• Extensive experience as Oracle PL/SQL Developer.
• Extensive experience and knowledge in Oracle SQL*PLUS, SQL*Loader, SQL Developer, PL/SQL Developer and TOAD Tools.
• Experience in writing Packages, Stored procedures, Functions, and Database Triggers using SQL and PL/SQL.
• Experience with VBA and MACROS.
• Good exposure on application development using ORACLE Forms 6i, Oracle Reports 6i.
• Experience in Performance Tuning using Explain plan and hints.
• Implemented Creation of Indexes and Constraints checks on Data Base Tables.
• Handling of Data flow using Cursors and Pl SQL tables.
• Good knowledge of Data Dictionary Tables for objects information.
• Worked on several Oracle provided packages such as UTL FILE and DBMS JOB.
• High proficiency in Object Oriented Analysis, Design, and implementation.
• Highly experienced in RDBMS Concepts, Database Management Systems, Database Physical and Logical design.
• Expertise in writing Stored Procedures, Triggers, Views on Oracle.
• Experience in using IBM Clear Case for versioning control.
• Hands on Experience in HP PPM Upgrade ITG 6.0 - HP PPM 7.1, PPM7.1 - PPM7.5 .
• Having sound knowledge on production support and maintenance side.
• Expertise in Visual Basic.
• Good exposure on ETL concepts.
• Exposure on Oracle APEX.
• Experience in Demand Management, Time Management, Project Management, Risk and Issue Management through HP PPM tool.
• Experience in leading / mentoring a team.
• Experience in resolving network issues; worked on servers and servers issues.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Java, Visual Basic 6.0

Web Technologies: Oracle Forms 6i, Oracle Reports 6i, XML, HTML

Database: Oracle 9i/10g, Oracle APEX, MS-Access 2003/2007

Application Tool: HP PPM, ITSM, AutoSys

Tools: Putty, Toad, PL SQL Developer, iSQL Plus, Visual Studio 2005/2008

Operating systems: UNIX, Windows NT 4.0/95/98, Windows 2000 and MS-DOS

Version Control: IBM Rational Clear Case

Documentation Tools: MS Office 2000/2007

PROFESSIONAL EXPERIENCE:

Confidential, PA

Senior Oracle Database Developer

• Gather and analyze requirements from business users of the application.
• Provide technical designs along with project plan.
• Understand functional requirements and submit detailed design documents.
• Understand new system (MSPS) and propose new solutions to the team
• Perform detailed review on all deliverables build, test results etc.,
• Design and develop new DB Objects (tables, views) that are required for migration and for application further development.
• Coded Stored Procedures.
• Monitor application performance and migration execution.
• Submit weekly project status reports and project metrics.
• Extract reports from MSPS and submit with client team.
• Design new custom reports based on the requirements.
• Do performance tuning on the custom reports.
• Do the SQL Trace, Explain Plain analysis, TK prof reports.
• Build batch jobs to load data from MSPS to third party applications.
• Do resource management through MSPS.
• Created data base objects through Oracle APEX
• Monitor resource availability and resource utilization based on data available in MSPS.
• Highlight issues and risks with client if any.
• Plan client’s additional value creation based on resource availability.
• Manage the resource’s roll-on and roll-off processes.
• Handle patch management and do patch deployment.
• Perform capacity management and submit monthly report on MSPS, Oracle and PPM applications on capacity and highlight risks if any.
• Responsible for Change Request Management, Problem Management and Incident Management.

Environment: Oracle 9i/10g, PL SQL, VBA, HP PPM, MSPS, IBM Rational Clear Case, ITSM, Oracle APEX

Confidential, MN

Senior Oracle Developer

• Module/Release Coding, Review and Testing.
• Minimizing defects in system and ensuring adequate quality control.
• Coded and debugged Stored Procedures, Packages and Views in Oracle Databases using SQL and PL/SQL, which were called by user-oriented application modules.
• Applied Exception Handling and Validation controls to provide proper data validation and catching exceptions occur during system execution.
• Loaded and unloaded data sets from or to Oracle Databases using TOAD.
• Implemented reusable Procedures/Functions.
• Involved in Requirements gathering from Onsite Managers, suggesting various approaches and providing Infrastructure sizing Recommendations.
• Involved in Scope and Estimate level of effort.
• Design prototypes for various work streams.
• Involved in Process Flow Design (Request Type, Workflow, Reports, Portlets).
• Involved in Code Reviews, Unit Test Cases and Review of Timesheets.
• Preparation of Deliverables for Release (Design Docs, Unit Test cases, RTM, Deployment Checklist, Configuration Guide, Release Notes, Training Materials).
• Working with Production vendor HP to solved product related issues
• Involved in Resource Management, work Planning and Prioritization.
• Enabling resources to understand requirements and product (People Development Management).
• Providing Technical Feasibility for process guidelines and Technical downloads for tech consultants.
• Worked on change, release, problem and incident management processes.
• Worked with Infrastructure team to resolve network issues for our clients.

Environment: Oracle 9i/10g, SQL, PL SQL, TOAD 8.0, SQL*Plus, SQL Developer, HP PPM, ITSM

Confidential

Responsibilities:

• Involved in the Product Enhancements.
• Participated in retro work of Flexcube Product
• Involved in bug fixing of the product
• Participated in the review meeting of DS and FS preparation
• Participated in writing of Packages required
• Backend code preparation (Procedures, Functions, Packages, Triggers)

Environment: Oracle 9i/10g, SQL, PL SQL, TOAD 8.0, SQL*Plus, SQL Developer