SUMMARY:

• Having 12+ years IT experience as an Oracle developer with expertise in Enterprise Resource Planning viz. Procurement, Material Management, Sales, Human Resource Management System (HRMS), Financials, Production, Planning, Statutory Requirements, ERP Security and Administration.
• Extensive experience in Requirement Analysis, Design, Development, Implementation and Support of custom applications. Oracle Database programming experience includes extensive usage of SQL and PL/ SQL in creating Schema, table spaces, tables, queries, triggers, procedures, functions, packages, indexing .
• Design, Develop, Implement and Manage Oracle Projects. Part of team in entire SDLC with emphasis on application development using Oracle technologies. Experience in designing FRS, technical documentation, gap study, effort estimation, writing Unit Test cases.
• Sound knowledge of Design and Development of commercial application using Client/Server and Web logic Technologies.
• System study, ER Modelling, Normalization, Designing, Development Implementation and Maintenance of large scale real time projects.
• Sound knowledge of Design and Development of commercial application using Oracle Forms and Reports.
• Proficient in backend programming using PL/SQL and Pro*C. Experienced in writing interfaces, triggers, stored procedures and PL/SQL. Expertise in writing Challenging Codes using SQL, PL/SQL .
• Experience in building Decision Support Systems and writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts.
• Expertise in Design and Development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader etc.
• System Integration Testing with other modules.
• Awareness of Quality Standards and procedures especially CMMI and strictly following client standards.
• Proven ability to quickly learn and apply new technologies with strong technical background. Good analytical, problem solving skills and ability to follow through with projects from inception to completion.
• Complete expertise in system integration, data consolidation and data migration between vendor's and client's legacy applications.

TECHNICAL SKILLS:

RDBMS: Oracle 11G/10G Rel 1&2/ 9.X/8.X/7.X, MS SQL Server 7.x/2000, MS Access, MySQL, FOXPRO 2.6, DBASE IV.

Technologies: Oracle Forms 10G/6i/4.5, Reports10G/6i/4.5/2.5, Discoverer 10g/4i/3i., TOAD, SQL*PLUS, IIS, Export/Import/SQL*Loader, SQL*PLUS, PL/SQL Developer 7.2, XML Publisher 5.6.2, Javascript, Visual Basic 6.0, Visual C++ 6.0, Active Server Pages 3.0 (ASP), VB Script, Photoshop, Authorware, Flash, 3DS Max.

O/S: Windows Vista/XP/2000/NT/98, Redhat Linux, UNIX, MS - DOS

Languages: PL/SQL, Pro*C, C, C++, COBOL, Java, HTML, XML.

Networking: LAN, WAN, Computer Networks, Networking Devices, TCP/IP Fundamentals, wireless networks, Intranet, VPN.

VersionControl: Visual Source Safe, SVN Tortoise

Planning Tools: MS Project, UML, MS Visio, MS Word, MS Excel, PowerPoint.

BI & ETL Tools: Oracle SQL*Loader, Packages, Oracle Import & Export utilities.

Analytical & Reporting Tools: Business Report Designer, Crystal Reports XI.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Module Leader

Responsibilities:

• Problem identification of the current system, documentation of system deficiencies.
• User interaction, major & minor problem identification.
• Define scope & objective of the new system.
• Database design (Tables/views/database objects).
• Preparing Program Specification.
• Technical Documentation of the Business process.
• Database development.
• Front-end development using Forms 10G and Backend using PL/SQL, Pro*C and Shell scripts.
• Repots development using Reports 10G and Pro*C batch programs.
• Module testing.
• Code review of team members, Program testing and unit testing.
• User Training of all modules.
• DBA activities especially creation of oracle user, granting roles and privileges, doing Backup, taking Import/Export.
• Program Documentation.
• Flat file to Oracle data conversion using SQL*LOADER.

Environment: Oracle 11G, Forms 10G, Reports 10G, PL/SQL, Pro*C, Oracle 10G Application server, TOAD, PL/SQL Developer 7.2, SQL*Plus, SQL*Loader, HTML, Red Hat Linux, Shell scripting, VSS.

Confidential, NJ

Oracle Applications Developer

Responsibilities:

• Worked on enhancements to the existing business/functional requirements that cater to the needs of Accounts Receivables Desktop application, Accounts Reporting and Global Invoicing groups to one of its client.
• Various daily and monthly Unix shell scripts are created or modified to include the new enhancements, accordingly Oracle stored procedures, functions and packages are either created or modified to meet to the business user's expectations.
• Actively ensuring the production implementation of the new enhancements with smooth transition of the project by adding value to the team in filling the gap where required as an analyst, programmer.
• Providing IT expertise and Involving in the complete life-cycle of the development, support and maintenance of the project.
• Some critical jobs that I have undertaken were related to the creation and modifications of shell scripts which includes calls to various business processes that are executed using Oracle stored procedures, functions, packages and DML operations.
• Proactively participating in the project discussions concerning new implementations to other countries like Canada, Europe, UK, Asia, Netherlands, and Germany.
• Developed and customized reports in Install Base, Inventory, Order Management and Account Receivables modules.
• Followed ADP Coding and Quality Standards for Development.
• Customized various XML Publisher reports using RTF templates, defining their respective Templates and Data Definitions and adding parameters.
• Generated Master/Detail summary reports depicted in a collapsed/expanded views. Customized reports by allowing end users to enter valid input in a prompt window to view corresponding data there by reducing overhead.
• Created a package that contains different procedures and functions using Pl/Sql to cross validate invoice information and load automatically invoices in to auto invoice interface tables.
• Designed a generic parameter form for a set of web based reports and to dynamically select the required parameters for the corresponding report.
• Developed PL/SQL Packages to populate the data in to customized tables which were used to create reports.
• Responsible for troubleshooting, training the offshore team and resolving the day-to-day issues regarding XML output generation. Rapid Application Development using XML.
• Coordinated with users to ensure that the User Acceptance Testing is done successfully and the code was moved to production without any defects.

Environment: Oracle 10G Rel 2, PL/SQL, Oracle Forms 10G, Oracle Reports 10G, Discoverer 10G, TOAD,PL/SQL Developer, XML Publisher 5.6.2, HTML, SQL*Loader, Shell Scripts, RedHat Linux, SVN Tortoise.

Confidential, CA

Oracle Technical Consultant

Responsibilities:

• Created various logical and physical data models interacting with the business team, leads and developers using MS Visio.
• Analysis, Low Level designing, creating Data Flow Diagrams and flowcharts. Involved in the preparation of FRS for Security and System Administration. In corporation of latest Data Encryption techniques
• System study, capturing of requirements, preparation of gap analysis, scheduling, customization, project tracking, testing and sign off.
• Customisation/implementation of ERP baseline product.
• Developed new functionalities like character mode printing, Inter-branch transfer of payment/receipt vouchers.
• Conversion of reports to Excel from Report Builder and from a Form.
• Bar code generation using Oracle forms and reports.
• Developed Management Information System (MIS).
• Developed Warehouse Management System.
• Implemented Pluggable Java Components in the forms. Used J2EE to create Java Beans.
• Used webutil functionality to populate data into excel files
• Developed and customised reports by using Oracle Discoverer.
• Developed and customised reports using HTML scripts.
• Developed PL/SQL Packages to populate the data in to customized tables which were used to create reports.
• Migration of Oracle forms and reports from 6i to 10G. Used Pluggable Java Components, webutil package and data encryption methodologies.
• Responsible for troubleshooting, training of team members and resolving the day-to-day issues
• Coordinated with users to ensure that the User Acceptance Testing is done successfully
• Effectively used webutil functionalities, implemented Pluggable Java components to improve the look and feel.
• Created comprehensive documentation for the data mapping elements by identifying the various data sources and mapping each line item within the reporting requirements to the specific database column thus deriving stand-alone SQL queries for each of the same as developer's notes.

Environment: Oracle 11G, Forms 10G, Jdeveloper, Discoverer 10G, Reports 10G, Oracle 10G Application server, J2EE, TOAD, SQL, PL/SQL, SQL*Loader, HTML, Windows 2K Server, Oracle Application Express 3.0, VSS

Confidential, CA

Oracle Application Developer

Responsibilities:

• Customization of existing modules of ERP, analysis of the customer requirements and to work for their feasibility into the system, interaction with the end-users, design and development of forms, reports and interfaces of HR & Payroll, Sales and Finance modules based on Oracle architecture according to the organization requirement.
• Used Oracle packages to extract data from oracle database to flat files. Used Materialized views to replicate Sales data at different locations. The data is horizontally fragmented and refreshed at regular intervals. The reports designed as part of the Management Information System (MIS) are Sales Analysis- Quantity and value-wise, monthly sales-target turnover-wise, Consignment delivery analysis etc
• Analyzed, designed, optimized and tuned PL/SQL Procedures, Oracle Stored Procedures and used SQL*Loader to load the Historical data into the data warehouse.
• Construct complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD). Create SQL scripts to perform unit testing financial calculations such as, Weighted-Average, Portfolio Walkforward dollar amounts, roll up of dollar amounts for Y-T-D and M-T-D calculations.
• Ability to create a centralized data mart that could support drill down analysis, drill through analysis, and management reporting for helps in deriving expected financial/accounting data using Oracle.
• Coding of Stored procedures, functions, packages in PL/SQL.
• Implementation of barcodes in Oracle Reports.
• Design of package to send automatic email from database to alert users about the status of orders.
• Setting up application level access privileges to users in Oracle AS Portal.
• Coding, Developing and Testing of Forms and fixing the bugs encountered in Unit Testing.

Environment: Oracle 10G, Forms 10G, Reports 10G, Jasper Report, Oracle JDeveloper, TOAD, SQL, PL/SQL, SQL*Plus, SQL*Loader, Sun Solaris Unix, PVCS

Confidential

Oracle Forms, Reports and Portal Developer

Responsibilities:

• Designed and created Entity-Relationship diagrams, data models and other database related information by reverse engineering defined data dictionary, database entities, parent child relationship keys, identifying primary and referential integrity constraints, sequences, stored procedures.
• Writing PL/ SQL packages, stored procedures and trigger to maintain organization Rules.
• Responsible for the entire SDLC of the project.
• Responsible for user training and preparation of documentation.
• Prepared and normalized schema of database, created tables and indices for better throughput.
• Developed module for capturing the daily attendance of 1200 employees Using Oracle forms and reports.
• Developed Statement of Case (SOC) Time-bar Sanction, Honorary commission, Meritorious Service Medal, Conduct & Awards modules for the Human Resource Management System
• Managing multiform applications, error handling, navigation and validation.
• Analyzing System errors, logs, query optimization and creating scripts.
• Providing end user day to day support.
• Designing various reports using Oracle Reports.
• Installed and configured Oracle Forms and Reports (Oracle application server 9i).
• Design, development, customisation and implementation of Banner Student System of the Air Force Schools and Affiliated colleges.
• Data porting from legacy Student system developed in COBOL.
• Manually built Undergraduate and Graduate Course Catalog with pre-requisites, co-requisites, restrictions. Populated manually more than fifty validation Tables to Banner.
• Defined all Academic Rules like Curriculum Rules, Academic Status rules, Student Honors rules in Banner.
• Built manually more than forty degree plans and rules for all Majors in CAPP (Curriculum, Advising & Program Planning)
• Implemented more than fifteen crosswalk tables required for data migration from SIS Plus to Banner.
• Resolved duplicate IDs of Students & Faculty by combining them with one ID.
• Populated data for all Academic Buildings & Class Rooms.
• Working closely with other team leads and their technical teams to ensure delivery of database services within the performance targets set.

Environment: Oracle 9i, Forms 6i, Reports 6i, TOAD, SQL* Plus, PL/SQL, SQL*Loader, Windows 2K Server . Oracle 9i Application Server.

Confidential

Programmer Analyst

Responsibilities:

• Analyzed / studied existing Functionality & Business Rules. Implementation Software Model (Water Fall Methodology). Reviewed Functional Specification & Created Context level DFD’s, ER Diagrams. Conducted feasibility analysis, Operational & Technical feasibility. Gathered Resources for the assignment. Normalized the database model to 3NF. Created PL/SQL Scripts (Packages, Stored procedures, Functions, Triggers & Cursors).
• Work closely with development managers in designing data models based on functional specification.
• Design and translate business requirements into technical design documentations.
• Migration to a new data warehouse project and responsible for implementation of business information solutions including analysis, documentation, and ETL development.
• Provide recommendations to new data extraction development processes to ensure performance optimization of data loads.
• Work with Sr. Systems Analysts to identify various databases where the information/data needs to be extracted from, understand the complex business rules that need to be implemented
• Work with DBA team to migrate the changes to production.
• Periodic check on database performance and analyze /suggest application tuning solutions.
• Documentation
• Work coherently with web development teams and participate actively in all database interactions.
• Assisting the DBA, Quality testers in developing scripts, test scripts and documentation.
• Implement database fixes and defects.
• Adhere configuration management policies and follow SDLC process in all phases of project life cycle.
• Perform unit testing, integration testing and participate in system testing of all projects and applications.
• Document best practices/lessons learnt and share the information across the team.
• Provided development and maintenance of an Order Processing system. System was designed to support daily orders from over 500 corporate customers across 3 states. System enabled the user to enter and edit orders, create automatic reordering patterns, manage order status; process authorized orders, and produces various daily, weekly, and monthly reports. Responsibilities included creating stored procedures and functions in PL/SQL, design, coding, testing, implementation of a number of forms and reports to support various system functions .

Environment: Oracle 8i, Forms 6i, Reports 6i TOAD, SQL, PL/SQL, SQL*Loader, Citrix Mainframe Server, Explain Plan.

Confidential

Programmer Analyst

Responsibilities:

• Problem identification of the current the system, documentation of system deficiencies.
• Define scope & objective of the new system.
• Technical Database design
• Preparing Program Specification.
• Technical Documentation of the Business process.
• Database development, Migration of Data from the Legacy system which was in COBOL and Foxpro 2.6
• Worked as Analyst for Aircraft Spares Provisioning (Import) module.
• Created data dictionary tables on the basis of system tables.
• Front end coding both in character and GUI mode.
• Created complex reports using oracle reports.
• Code review of team members, Program testing & unit testing
• User interaction, major & minor problem identification
• User Training of all modules, demo presentations.
• Designed, developed and implemented financial reports for accounting department.
• Created and modified Oracle functions, stored procedures, reports, SQL scripts.
• Developed Production Monitoring System for Aircraft spares in Foxpro 2.6
• Performed SQL Server database development tasks including installation, security, Import/Export, and performance tuning by creating indexes on temp tables, and maintained the development, production and test instances of the database. Scheduled various program tasks to perform various jobs on a regular basis and created the appropriate technical documentation for the operational environment. Utilized Data warehousing, data mining, and OLAP technologies to implement all projects.

Environment: MS SQL Server, COBOL, Foxpro 2.6, PERL, Crystal Enterprise, Active Server Pages 3.0 (ASP), IIS 4.0,Cold Fusion, Windows NT 4.0 Workstation.