Summary

An Information Technology Oracle Professional with 10+ years in various roles as a Consultant, Developer/Designer/Architect working for major corporate client on challenging projects, having good understanding and in-depth knowledge of system study, design, development etc. using Oracle 10g/9i/8i/ Forms / Reports / PL/SQL / VB.Net / Crystal Reports etc..

• Expert in Creating Database Triggers, Stored Procedures/Packages, good working knowledge inSQL, SQL*PLUS, PL/SQL Programming, TOAD, SQL Navigator, PL/SQL Developer etc.
• Very strong in Database Triggers, Stored Procedures/Packages, and SQL Query Tuning etc.
• Working knowledge of RDBMS such as Oracle 10g/ 9i / 8i, SQL Server.
• Experience using Partitioning, Materialized Views, Optimizer Hints, Bulk Loading, Parallelism, Analytical Functions.
• Familiarity with issues like Scalability, Performance, High-Availability, Replication, Security and Synchronization
• Strong UNIX and Shell scripting skills., Data Modeling using Erwin
• Identify data discrepancies and data quality issues, and work to ensure data consistency and integrity.
• Extensive source analysis and mapping experience.
• Writing Complex Queries, Complex Stored Procedures and packages, performance tuning etc..
• Good Experience in using scripts in SQL*Plus, Tuning SQL*Plus, SQL*Plus Securities etc.
• Good Experience in Parameterized SQL Query Reporting and strong in SQL*Plus and other Oracle tools, SQL Query Builder for Creating complex queries for Crystal Reporting etc.
• Expert in Creating Professional Reports using Crystal Report (Ver. 8.5, 9, 10 and 11).
• Expert in creating special Grouped reports, Cross Tab / Matrix Reports, Sub reports in main reports, Drill Down reports, Mailing reports using Crystal reports.
• Reports developed with features of report alerts for instant notifications using crystal reports.
• Experienced in Crystal Report Documentation and creating stored procedures for faster processing of reports etc.
• Experience in Database Backup, Database Migration, Writing Complex Queries etc.
• Experienced in handling projects during all aspects of SDLC starting from analysis to Delivery of the project.
• Extensive experience in Software Engineering, Programming, Design Architecture, Flow charting, Documentation, System Analysis, Application Implementation and IT Management. Strong experience in Project management, database and System Administration, legacy to client server system integration, Data conversions and interfaces. Eager and capable of learning new skills and applying them to achieve results.
• Responsible for software architecture that includes key Technical decisions that constrain the overall design and implementation of the solution.
• Capable of Planning and executing data conversion activities, driving test planning, execution etc.
• Core Strengths in leading teams to meet deadlines, and good Team Player with Excellent Communication - Verbal, Written & Analytical skills
• Strong problem-solving and analytical skills, ability to work effectively in a fast-paced environment.

Educational Qualification

• Bachelor of Science in Physics with Computer Science.
• Post Graduate Diploma in Computer Application
• Post Graduate Diploma in Computer Hardware Engineering

Technical Skills

• RDBMS :Oracle 10g / 9i / 8i & 7.3, SQL Server 2000,MS- Access
• GUIs :Developer – 2000 (Forms 10g/9.0/6.0/4.5 andReports10g/ 9.0/6.0/2.5),Designer 9i, Oracle 9i & Discoverer 9i, J Developer, SQL Developer,SOA,ApplicationDevelopment Framework, Enterprise Manager, Visual Basic .Net (2005/2003) / 6.0/5.0.
• Programming Languages :SQL, PL/SQL, Visual Basic, C# ,Oracle workflow, Unix Shell Scripting .Net(2005/2003)/6.0/5.0.
• Reporting Tools: Oracle Reports,Crystal Reports 11.0/9.0/8.5.
• Middle Wares : ADO, RDO, ODBC, OLE etc.
• Network : LAN, WAN, VPN, Wireless etc.
• Other Software Tools : Toad 6, SQL Navigator., Pl/SQL Developer,SQL developer, Microsoft Office 2003 etc
• Web Technologies : HTML, DHTML, JavaScript, Ajax, XSL,CSS, Web Services
• Operating System : Windows –2003/2000/XP/NT/98, UNIX

Professional Experience

Project: Loan Information Management System (LICS) Period: March 2009 Onwards
Role: Oracle Analyst Programmer
Client: Confidential,Jackson, MS, USA

The system involves various emergency and Improvement Loans and Grants for the Water Supply System. Contract Change order Tracking, Construction detail maintenance, Amortization Scheduling for Loan and repayments etc. are the major active modules within the system.

Responsibilities:

• Created, Customized new forms in MDI Application and reports to meet the business requirements. Designed new forms for Amortization, Scheduling, Loan Project Details, Amendments of Loans/Grants etc. using oracle forms10g for Water supply loan management system.
• Applied various business rules for better functionality and better performance.
• Worked with object libraries and API\'s
• Created complex Master detail forms based on procedure based blocks.
• Applied best practice for error handling through user defined exceptions etc.
• Completed data conversion and migrations as per the project requirements.
• Created complex queries for reporting. Analyzed and translated business requirements into reports.
• Developed complex Oracle reports that utilizing the multiple queries, multiple groups and levels of repeating frames, calls to PL/SQL packages, procedures and functions, formula and summary columns, materialized views etc.
• Modified and created new Database triggers, Packages, Procedure and Functions according to the application requirements. Assisted QA teams in their unit testing.
• Wrote various testing scripts and test plans to assist unit testing.
• Also providing support for the existing systems by offering suitable technical design and security standards.

Environment:

Oracle 10g, Forms 10g, Reports 10g, PL/SQL, PL/SQL Developer, SQL Navigator etc., Unix/Windows –2003.

Project: Nuclear Information Management System (NIMS) Period: July 2008 – Dec. 2009
Role: Oracle Analyst Programmer
Client: Confidential,Berwick, PA, USA

This system controls and monitors the whole activities of nuclear related information’s. In this system I have worked through various application modules like Radiation Protection Management (RPX), Decision Support System (DSS), Training Management (TMX), Action Management (AMX), Document Management (DMX), Work Management (WMX), Energy Control Process (ECP), Access Processing (ACX), Component Management (CPX), Workflow Management (WFM) etc.

Responsibilities:

• Converted 6i Application to 10g with new business rules and functionalities.
• Generated .xml files for the forms and extracted Application data for various workflow based activities within the application to provide various securities and controls.
• Completed data conversion and migrations as per the project requirements.
• Created table partitioning, Materialized Views. Tuned SQL queries etc.
• Created complex queries for reporting. Analyzed and translated business requirements into reports.
• Developed complex Oracle reports that utilizing the multiple queries, multiple groups and levels of repeating frames, calls to PL/SQL packages, procedures and functions, formula and summary columns, materialized views etc.
• Created documentation for reports and packages developed.
• Managed Application user settings, created users, grant privileges etc.
• Identified data discrepancies and data quality issues, and ensured data consistency and integrity.
• Modified and created new Database triggers, Packages, Procedure and Functions according to the application requirements. Assisted QA teams in their unit testing.
• Wrote various testing scripts and test plans to assist unit testing.
• Testing and Merging of source code with Source Control Manager (SCM).
• Achieved complete functionalities for various workflow related activities for monitoring and guiding the system throughout various aspects of development and in production.
• Identify data discrepancies and data quality issues, and work to ensure data consistency and integrity.
• Created Stored Procedures and functions using PL/SQL to support the system. Also responsible for user setup etc. meet the operational needs of the business activities.
• Involved in regular discussions with users and team members in maintaining the systems and developing enhancements to meet the business needs.

Environment:

Oracle 10g, Forms 10g, Reports 10g, PL/SQL, PL/SQL Developer, SQL Navigator etc., Unix/Windows –2003.

Project: Pricing Re-write for Production and Sales Management System. Role: Oracle Analyst Programmer
Client: Confidential,Florida, USA Period: Oct. 2007 to May. 2008

This System controls and operates the complete Production, Inventory and sales management system to support the various business transactions of the company. The project was mainly to modify the existing Application according to the new business rules applied in business rules engine.

Responsibilities:

• Completed the maintenance of existing forms and reports. Modified existing applications with new business requirements to meet the business functionalities.
• Completed data conversion and migrations as per the project requirements.
• Modified and created new Database triggers, Packages, Procedure and functions according to the application requirements. Assisted QA teams in their unit testing.
• Testing and merging of source code with Serena version manager and CVS tools.
• Created web reports and forms using developer suite 10g.
• Parameterized SQL Query Reporting in the development of Complex Business Reports.
• Created Complex queries using Inline Views., SQL Query builder etc.
• Roles are created and used with SQL CREATE, GRANT and SET Commands.
• Completed planning and executing data conversion activities, driving test planning, execution etc.
• Involved in developing standards, process, guidelines and ensure compliance with management standards
• Developed complex Oracle reports that utilizing the multiple queries, multiple groups and levels of repeating frames, calls to PL/SQL packages, procedures and functions, formula and summary columns, materialized views, format triggers and layout customization, lexical parameters, export to Excel, and report registration in Oracle Applications.

Environment:

Oracle 10g, Forms 10g, Reports 10g, PL/SQL, PL/SQL Developer, SQL Navigator etc., Unix/Windows –2003.

Project: Inventory Management System Role: Oracle Developer
Client: Confidential,Florida, USA Period: Jun. 2007 to Sep. 2007

This System controls and operates the complete inventory management to support the various business transactions and trading operations of the company. Alert messages are generated automatically in order to assist the stock Control. This system monitors all the Sales activities for the company within various regions, sales generated by the agents etc.

Responsibilities:

• Preparing the system requirements specifications, Design of Application prototypes, designing database,
• Technical coding to develop various forms and classical, matrix, drill down reports for the operational and functional needs. Also created dynamic reports using Lexical Parameters.
• Created Database Triggers, Stored Procedures and functions using PL/SQL and trained the staff to support the system.
• Created Special report for the management using Crystal reports.
• Created Complex Queries using SQL Query Builder
• Wrote complex queries for Special reports etc.
• Worked closely with BI team members and functional business areas in support of strategic analytics.
• Worked on Extraction-Transform-Load mechanisms (ETL)
• Optimized PL/SQL procedures to load huge tables, Performance tuning etc.

Environment:

Oracle 9i, Forms 6i, Reports 6i, PL/SQL, SQL Navigator etc., UNIX, Windows –2003, Crystal Reports, SQL Server

Project: Manpower Management System Role: Sr. IT Application Developer
Client: Confidential,Saudi Arabia Period: Oct. 2004 to Jan. 2007

This System tracks and records of complete manpower supply for the Engineering Company, with its major multi-national clients. It generates necessary timesheets and invoices to various clients on their preferred format based on project, designation, revision of project, Classification etc. Module includes Accounting module, Project Management, HR and Payroll Application Module etc. System is capable of recording project plan, project design etc in the database through OLE concept.

Responsibilities:

• Developed the System using Oracle 9i and Developer-2000 (Forms 6i, Reports 6i). Also completed maintenance of existing software modules. Jobs include complete software development phases like database designing, System Designing, Coding etc.
• Engineering Project Monitoring System Module integrated with Manpower Management System for complete operation of business activities.
• Responsible for technical coding to develop various forms and professional reports for the management activities and technical assistance.
• Managed Oracle database for functional operations and technical activities.
• Created Stored Procedures and functions using PL/SQL to support the Management system. Also responsible for system Administration, user setup, user support and train the staff according to the operational needs of their activities.
• Created various database triggers and implemented lot of validation controls and constraint checking in the application according to the business needs and policies of the company.
• Performed DBA tasks such as exporting, importing data in between multiple instances, creating database links, creating users, creating roles, creating grants and managing space in tablespaces.
• Load data into ORACLE tables using SQL*Loader from Excel sheet.
• Involved in Requirement Gathering and preparation of Software Requirement Specifications.
• Created Packages, Stored Procedures and functions using PL/SQL to support the Management system. Created various database triggers and implemented lot of validation controls and constraint checking in the application.
• Created partitioned table for performance improvement.
• Write optimized PL/SQL procedures to load huge tables.
• Troubleshooting and debugging the application.
• Extensively worked on indexing and tuning issues.
• Wrote Database triggers in PL/SQL to enable different integrity constraints, for auditing and security purpose.

Environment:

Oracle 9i, Forms 6.0, Reports 6.0, PL/SQL, SQL Navigator etc., Dell 4000 Servers with Raid Technology, Compaq Pentium and IBM Compatibles, UNIX/Windows – 2003 server, Windows XP.

Project: Procurement Management and Payroll System Period: Nov. 2000 to Sep. 2004
Client: Confidential,Al-Khobar, Saudi Arabia
Role: Oracle / Developer-2000/VB.Net Analyst / Programmer

Procurement System controls the all purchase, Issue and stock controls. This software estimates the costs involved in various projects and prepare automatic Job scheduling of projects with all necessary feedbacks. Along with this package a complete payroll Module developed using VB.Net and Crystal Report has been integrated which keeps track of employee pay information and control all accounting activities.

Responsibilities:

• Responsibility includes software support on developed and customized application software, project design and technology in Client Server Environment.
• Administering Oracle database management system & Network Support.
• Software support provided for developing reports using Oracle Report for the complete business Solutions and included in the existing Software module and trained the staff successfully.
• As Technical Lead, coached and guided all developers to create the forms, PL/SQL packages/ Modules and complex Queries, and provided functional and technical expertise. Conducted and participated in Project meetings on a regular basis allowing for timely project tracking.
• Successfully led a team of 4 developers and expert business users on the reports development subproject for different departments, including business analysis and design of the reports.
• Worked closely with other members of the IS team, business users and Oracle Consultant in identifying, diagnosing and resolving complex problems. Managed resources, work and quality during the project implementation cycle. Documented existing and new information Systems for functional and technical users.

Environment:

Oracle 9i, Developer- 2000 (Forms 6.0/Reports 6.0), PL/SQL, SQL Plus, Pentium and IBM Compatibles, UNIX/Windows – 2000, Windows XP, Windows Millennium etc.

Project: Environmental Monitoring Control System Role: Analyst / Programmer
Client: Confidential,Saudi Arabia Period: Apr. 2000 to Oct. 2000

EMC (Environment Monitoring Control System) system keeps record of various gases Concentration levels in the atmosphere to warn and control the industry pollution. This system is operated with the help of analyzers and radio waves and sends the data on wireless network to the Application server. It warns the operators when the concentration of various gases exceeds the limit and necessary warning messages created for informing the factories in the industrialized city. The collected data is used in various reporting purposes to study the Environmental Changes.

Responsibilities:

• I was responsible for developing some special reports using Crystal Reports for the planning and forecasting operation of the Organization based on the data available for daily operation and deployed these reports on application server as a Report module for the management operation.
• Load data into ORACLE tables using SQL*Loader from Excel sheet.
• Created partitioned table for performance improvement
• Responsible for System Administration, Creating Schema, Roles and Users and setting their privileges etc.
• Wrote Database triggers in PL/SQL to enable different integrity constraints, for auditing and security purpose.
• Created Matrix reports using Oracle reports.
• Performance Tuning of the existing programs which effected in reducing processing times.

Environment:

Oracle 9i, Forms and Reports, VB.Net, Crystal Reports, PL/SQL, SQL Plus, Pentium and IBM Compatibles, UNIX/Windows – 2000, Windows XP, Windows Millennium on Wireless Network.

This project is consisting of modules like General Ledger, Accounts Payable and Accounts Receivable being implemented to automate the accounting process of the company and its activities. Also trading system maintains a proper inventory level, manages stocks, purchase and keeps records of all sales transaction in their various business activities.
Responsibilities:

• Designed and developed Oracle Application in Inventory, Purchasing, Accounts payables, Accounts receivable, General Ledger, Order entry, Cash box, Pre-Authorized Payment, Cheque Scanning, Mass and Adjusted Billings for the Finance Department to meet their day to day requirements. The application were built in MS Access and later converted to Oracle system.
• Mapped, developed and migrated all developed application forms and reports from the legacy system to Oracle, resolving sizing, indexing and optimization issues.
• Role includes generating the major financial reports as required by the user and also to automate the various processes involved in the accounting world.
• I was also involved in creating company documentation and help system for users to access on line information that increased efficiency and ease of use.
• Developed Database triggers, stored procedures, Packages and Class Modules for applications.
• Involved in regular discussions with users and team members in maintaining the systems and developing enhancements to meet the business needs.
• Involved in writing database triggers for auditing and security purpose.
• Provided development and technical support for customized database applications to clients. Documented existing and new information systems for functional and technical users.

Environment:

Oracle 7.3, Forms and Reports, PL/SQL, SQL Plus, MS Access., Pentium and IBM Compatibles, UNIX/Windows – NT, Windows 98.

This System controls and operates the complete inventory management to support the various business transactions and trading operations of the company. This system has complete processing of preparing PO, SO, Invoicing, Material Return, Barcode scanning and printing, Lot tracking etc. Alert messages are generated automatically in order to assist the stock Control. This system monitors all the Sales activities for the company within various regions, sales generated by the agents etc. This system also generates the net due from the agents and the incentive due to the agents.
Responsibilities:

• Preparing the system requirements specifications, Design of Application prototypes, designing database,
• Technical coding to develop various forms and classical, matrix, drill down reports for the operational and functional needs. Also created dynamic reports using Lexical Parameters.
• Created Database Triggers, Stored Procedures and functions using PL/SQL and trained the staff to support the system.
• Creating company documentation and help system for users to access on line information that increased efficiency and ease of use.
• Successfully worked with a team of 4 developers and expert business users on the reports development sub-project for different departments, including business analysis and design of the reports.
• Documented and trained the staff for the operation of system.

Environment:

Oracle 7.3, Forms 4.5, Reports 2.5, PL/SQL, SQL Navigator etc., UNIX/Windows – NT