SUMMARY:

Senior Oracle Applications Engineer with comprehensive knowledge in Oracle Databases, Oracle Applications technology, Oracle development tools and UNIX operating systems. Over 12 years of commercial IT experience in Oracle Development. Exceptional analytical and problem-solving skills. Excellent verbal and written communication skills. An enthusiastic and highly motivated professional with a positive outlook with rich in-depth exposure to planning, developing and implementing Business Requirements. E-Business Suite 12.1.3 Upgrade - 11i to R12. Experience in Oracle 10g/9i/8i, SQL, PL/SQL Programming, VB 6.0, Developer/2000, Forms10g/ 9i/6i, Reports 10g/9i/6i , Pro C, Performance Tuning. Solid expertise in writing PL/SQL database triggers, stored procedures, functions and packages backend to handle validations for various data loads. Good experience with UNIX platform and UNIX development. Experience with Agile software development, Scrum Master, Test Driven Development TDD and Behavior Driven Development BDD . Expertise in the development of real-time projects 3-tier systems, client/server technologies, RDBMS under UNIX and Windows Web designing, strong Coding and Debugging skills. Good understanding of SOA Components like BPEL, Adapters, B2B, BPM, Business Rules. Developed lots of ER Diagrams and expertise in identifying entities and its attributes. Developed complex Perl scripts and UNIX scripts. Created Multi-dimensional SQR reports.

• Provide on-call support to production system to resolve any issues.
• Extensive knowledge in Extract, Transform, and load ETL . Expertise in Crystal Reports, develop lot of complex crystal reports.
• Used XML for interchanging of data over the internet.
• Knowledge of XSQL. XSQL is new language with the combination of SQL and XML. To provide a language and database independent means for storing SQL queries, clauses and query results.
• Strong in testing methodology including manual and Automated Testing. Involved in complete Software Development Life Cycle SDLC . Basic knowledge of Pro C, C, C , JAVA, COBOL and other programming languages. Knowledge in TCP/IP, Client Sever Model, DNS. Expertise in Internet, Intranet and database related projects.
• Strong leadership skills and ability to handle complex project with junior developers.
• Excellent interpersonal and communication skills. Good team player and can easily adopt new systems and technologies with always can do attitude.

• Oracle 10g/9i/8i/7i/6i, SQL Server, DB2, Sybase.

• Oracle ERP R12/11i, Forms 4.5/6/9i/10g, Reports 4.5/6/9i/10g, Crystal Reports, Discoverer Desktop, Discoverer administration and Graphics, JDeveloper, Visual Basic, Power Builder good exposure, efficient in using power designer , Forms Tool, Putty, WinSCP, Query Builder, Graphics Builder, RCS version control system, Reflection, Reflection X.

• SQL LOADER, SQL PLUS, SQL Net8, TOAD Tool for Oracle Application Developers , JDBC/ODBC, TKPROF, EXPLAIN PAIN.

• PL/SQL, SQL, UNIX/Shell Scripting as a user and not as an administrator , PERL, Basic Knowledge of C, C , VC , JAVA, COBOL.

• TCP/IP, Client Server Model, DNS, Internet, Intranet, Extranet, SDLC, PVCS.

TECHNICAL SKILL:EXPERIENCE:

Confidential

Sr. Oracle Developer

Responsibilities:

• Customize the Oracle ERP application to process multiple demands in a single master work order. Developed the oracle forms from scratch to support the business requirement.
• Fixed most of the issue in both standard and custom objects for Finance, Purchasing, O2C and D2B Modules while R12 Upgrade.
• Created transactions to populate the Oracle Interface tables to load the data from customized tables to base oracle tables.
• Created customize tables, view, procedures, functions and packages to support the customized ERP Application.
• Provided support for Inventory, Purchase, OM, BOM, WIP Quality modules.
• Wrote scripts for creating tables, Indexes, Grants and Synonyms in different schemas and made modifications for the existing tables as per business logic
• Developed a PL/SQL Interface Program to validate the data and load the data into the INTERFACE tables
• Used standard oracle API's to submit the concurrent program from PL/SQL to load the data from interface tables to base tables.
• Developed control files for SQL Loader and PL/SQL programs for loading and validating the data into the interface tables from the EDI flat file
• Performed Unit testing in development environment and had a close interaction with system test and user acceptance team to complete technical and functional testing.
• Involved in requirement gathering meetings and developed design and demo documents
• Involved in Functional document MD50 review and preparation of Technical document MD70 based on the business requirement.
• Agile Management and Software Development with Sprint Meeting, Daily Scrums, Cross Training, Load Sheets, Burn Down Charts, OTE, TDD and BDD.
• Experience as a Scrum Master and attending Scrum to scrums.

Environment: Oracle EBS R12.1.3/Oracle EBS R11.5.10, Oracle Database 11g/10g, Forms builder, Reports builder, TOAD, PL/SQL, SQL, Procedure, Package and Database triggers, PlUnit, Oracle ATS, Jenkins, Subversion, Serena Mash ups, PVCS, Unix, Unix shell scripts, Kintana.

Confidential

System Engineer

Responsibilities:

• Managed projects as Team Lead and conducted meetings with all levels of management.
• Lead the team of 6 who work on multiple technologies and in multiple locations.
• Database design and codification: functionally and technology lead for application design, Forms, Reports Design, PL/SQL Coding etc.
• Involved in writing complex SQL Queries to implement the business requirements.
• Developed PL/SQL Procedures, Functions and Packages and used PL/SQL ETL Table functions to load data into the database.
• Work with large data, process millions of records every data.
• Involved in creating Specification Documents, Mapping documents, Data Flow Diagrams, ER Diagrams, Dependency documents.
• Made use of DML triggers for updating sequences.
• Experience with Oracle analytical functions, table functions and hierarchical queries.
• Used EXPLAIN PLAN, TKPROF to tune SQL queries.
• Used ROW function, LEAD function, PIVOT function, RANK and DENSE RANK functions.
• Developed Process Flow diagrams using Microsoft Visio.
• Implemented Complex functionality by merging records.
• SQL Developer and SQL PLUS were used for PL/SQL Development.

Environment: Oracle 11g Data warehouse, PL/SQL, SQL, Procedure, Package and Database triggers, SQL Developer, JIRA, Table Functions, Analytical Functions, Microsoft Visio, Communicator.

Confidential

Technical Team Lead

Responsibilities:

• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Oversaw unit and system tests and assisted users with acceptance testing.
• Implemented complex transformations by creating custom transformations in addition to using built-in ones.
• This job also included fair amount of database tuning, analysis of the application design and performing performance analysis of the existing applications by using TKPROF
• Extensive knowledge in Discoverer Administrator version 9.0.2 and Oracle 9i Discoverer Desktop.
• Involved in business development life cycle, Oracle Forms, Oracle Reports and Oracle PL/SQL programs and UNIX Shell scripting.
• Involved in the designing and creation of the database.
• Developing project scope budgets, timelines delivery dates , customer relationships, continuous design improvements, conducting status meetings and customer reviews.
• Lead cross functional teams with diverse technical backgrounds. offers outstanding talents in resource loading recruiting/staffing ,resource leveling sharing resources , team building, team consensus,
• Handled the change requests coming from end user.
• Used TOAD extensively to create and modify procedures, packages, tables, indexes etc. Also used for session info, tuning, schema browsing etc.
• Played role in design of scalable, reusable, and low maintenance ETL templates.
• Analysis, requirement gathering, documentation, business requirements, functional requirements, development, deploying and testing.
• Generated seeker services reports using Crystal Reports.

Environment: Oracle 10g/9i, Forms Builder 10g/9.0, Report Builder 10g/9.0 PL/SQL, SQL, Procedure, Package and Database triggers, TOAD, Crystal Reports, Discoverer Administrator, Discoverer Desktop, Windows 2000/XP, UNIX, PVCS version control system, Forms tool, Pro C.

Confidential

Sr. Oracle Developer

Responsibilities:

• Developed UNIX jobs and Perl script to convert the file from customer file format to the BACIS file format and BACIS file format to the banks file format.
• UNIX scripts where developed to perform the date checks, load the trailer records in the BACIS tables, compare the balance in the file and the table and call the Perl scripts for file conversions.
• Worked as production support developer and closed lots of critical tickets every day.
• Developed Oracle forms with complex functionality. Many SQR reports where developed to display transaction information and electronic funds.
• UNIX Scripts are used to zip and tar the processed files.
• Involved in the requirements meetings and helped the business analysts to understand the technical functionally behind the code and fill the requirement gaps.
• Developed design documents with the back end work flow with diagrams for easy understanding. Helped users with demos to understand the new functionality.
• Trained production support developer with the new procedures and script developed.
• New back end functions, procedures, triggers, cursors and packages where developed.
• Reflection X is used to develop Oracle Forms through UNIX.

Environment: UNIX, Shell Scripting, Oracle 10g, Forms Builder 10g, SQR, PL/SQL, Data modeling, ER Diagrams, Performance tuning SQL, PL/SQL, TOAD, SQL Plus, PERL Scripting, Reflection for UNIX, Reflecting X for running Oracle forms Designer on Unix server, RCS Revision Control System ,Citrix Server, TKPROF, EXPLAIN PAIN.

Confidential

Application Specialist

Responsibilities: Automated the manual reports by using Crystal reports, Complex Procedures and UNIX shell scripting. Requirement changes are done to the complex batch processes. Created Functions, Procedures and Packages. Multiple upgrades and reengineering of existing project in Oracle Reports, Crystal Reports Extensive Use for SQL plus and TOAD to access the database objects.

Environment: RETEK, Oracle 10g, Forms Builder 6i, Report Builder 6i, PL/SQL, SQL, Procedure, Package and Database triggers, TOAD, TKPROF, SQL Plus, Crystal Reports, Query Builder, Graphics Builder Windows XP, UNIX, PVCS , Putty, WinSCP.

Confidential

Environment: Oracle 9i, Forms Builder Version 9.0, Report Builder Version 9.0 PL/SQL with strong use of Stored Procedure/Package and Database triggers, Performance Tuning, SQL LOADER, Windows 2000/XP, UNIX.

Confidential

Oracle Developer

Environment: Oracle 8i, SQL Plus, PL/SQL, Developer 2K, Forms 6i, Reports 6i, Crystal Reports, TOAD, PL/SQL Developer, UNIX, Windows 98/00/NT,.