SUMMARY

• Over 6 years of diversified experience in analysis, design, development, testing and implementation in Oracle JD Edwards Enterprise suite and Oracle PL/SQL
• Oracle PL/SQL Developer Certified Associate (OCA) having over 6 years of diversified experience in analysis, design, development, testing and implementation in Oracle JD Edwards Enterprise suite and Oracle PL/SQL.
• Expertise in all phases of the Software Development Life Cycle (SDLC) including Analysis, Design, Code development, Testing, Implementation, End - User Training, Post-production Support activities and Quality Reviews Maintenance.
• Hands on experience in modeling Business Requirements into Technical Requirements, Software Requirement and Technical documentation.
• Good experience is writing SQL queries using table joins (inner, outer, left, right), inline views, correlated and non-correlated sub-queries.
• Good experience in writing SQL queries using aggregate functions like count, sum, avg, max, min to extract data as per business requirement.
• Good experience in writing SQL queries using string functions like length, trim, to char, substr, instr to extract data as per business requirement.
• Good experience in creating database objects like tables, views (simple and complex), constraints, sequences and synonyms.
• Good experience in creating indexes (b-tree, bitmap, function) on tables.
• Good experience in defining keys on database tables (primary, unique, foreign).
• Good experience in working on PL/SQL programming like creating Stored Procedures, Functions, Packages to process data.
• Good experience in selecting, updating and deleting data in tables in different schemas and databases using shema qualifiers and database links.
• Good experience in using cursors, collections and BULK Collect for data processing.
• Good experience in using SQL tools such as TOAD, SQL Developer, SQL*Loader, SQL Navigator and SQL*Plus to work on PL/SQL programming.
• Good experience in creating JD Edwads objects like Data Dictionary item, Business Views, Tables, Interactive Applications, Batch Applications, versions, Processing Option data structure, Media Objects, Work Flow Items and Named Event Rules.
• Good experience of debugging BSFNs and NERs, debugging Business Services objects using Soap UI tool and ER Debugger.
• Significant work experience as an Onsite coordinator in Dubai, UAE which involve direct interaction with the Business Analysts and Business Users.
• As an offshore team lead, managed the day to day activities of the team, project planning, estimation, reviewing deliverables and quality of deliverables.
• Delivered projects for reputed clients such as Confidential, Confidential, GTA, Confidential, CMPi and Al-Naboodah.
• Extensive experience working with MS Word, MS Excel, MS PowerPoint, MS Outloook.
• Experience in various tools like Rally, ClearQuest, VSS, E-Tracker, Citrix, VPN.
• Excellent team player and possess very good communication, analytical, interpersonal and presentation skills.
• Open to learn new technologies and taking up projects which challenge my skills and abilities.
• Strong Logical and Analytical Reasoning Skills, Excellent Management skills, Excellent Communication with good Listening, Presentation and Intrapersonal Skills.

TECHNICAL SKILLS

Database: Oracle 9i/10g

Languages: Oracle PL/SQL, C, C++, JAVA

Oracle Tools: SQL Developer, TOAD, SQL*Plus, SQL*Loader, SQL Navigator

JDE Tech: One World Xe, E812, E9.0, E9.1: Data Dictionary, TDA, ER, RDA, FDA, PODA, ER Debugger, NER, BSFN, Debugging BSFN using VC++, Table I/O, Business Service

Testing Tool: QTP, Quality Center, SoapUI

Other Tools: C2.0, Rally, ClearQuest, VSS, E-Tracker, Citrix, VPN, Remedy

Internet Tech.: HTML, XML and WSDL

Operating Systems: Windows 98/2000/XP/ 7 /8

Desktop Organizational Tools: MS Word, MS Excel, MS Outlook, MS Project, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, LA, California

Technical Lead

Responsibilities:

• Lead the upgrade team from offshore (E8.12 --> E9.0)
• Involved in the process of analysis of ESUs and SARs and preparing object listing to facilitate movement/ retrofitting from E8.12 system to upgraded system (E9.0).
• Development/ retrofitting objects in upgraded E9.0 system, Identifying Baseline SAR and other changes during retrofitting.
• Customization/ enhancement of Business services Objects.
• Debugging & Troubleshooting issues with JDE and Business service objects.
• Created database objects such as tables, synonyms, indexes, constraints, sequences and database links.
• Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures, Cursors, Functions and Triggers.
• Used SQL*LOADER to load data from comma separated files into the database.
• Extensively used stored procedures/functions for report generation and sending data to Java based front end for business users.
• Querying on database from backend to ensure JD applications and BSSV Applications are loading correct data.
• Preparation, Review & Execution of Test Cases. Involved in test data preparation for all releases. Supported during QA/UAT/PROD deployments.
• Review of various deliverables from offshore to ensure quality deliverables.
• Maintained C2.0, Rally, ClearQuest Quality tools, for the fixes/changes.
• Extensive Experience in working under challenging environments.

Environment: JD Edwards Enterprise E9.0, Modules - Inventory and Purchase order, Sales Order, Business Services, FDA, RDA, TDA, PODA, ER Debugger, NER, BSFN, Table I/O, SQL, PL/SQL, Oracle 10g, TOAD 9.7, SQL *LOADER, WSDL, Soap UI, Rally, ClearQuest

Confidential, LA, California

Technical Consultant and Lead

Responsibilities

• Involved in all SDLC stages of the project starting from requirement analysis till Production deployment and support.
• Analysis of Functional Requirement documents provided by Onsite coordinator.
• Preparation of technical design documents based on Functional Design Document and get confirmation from client on understanding of requirement.
• Created SQL*LOADER scripts to load data from comma separated files into the database.
• Worked on Oracle PL/SQL stored procedures, functions, packages and cursors to perform data validation and processing.
• Created triggers on database tables to maintain history data in backup tables whenever data is inserted, updated or deleted from the main table.
• Created database objects such as tables, synonyms, indexes, constraints, sequences and database links.
• Customization/ enhancement of various JDE objects in E8.12 system.
• Customization/ enhancement of Business services Objects to get data from third party system and to execute JDE applications and BSFNs on that data.
• Debugging & Troubleshooting JD Edwards application and Business service issues.
• Testing Business Service objects using SoapUI tool.
• Querying on database from backend using TOAD to ensure JD applications and Business Service Objects are loading correct data.
• Preparation, Review & Execution of Unit Test Cases.
• Production support for existing running E8.12 JDE applications and new applications during QA/UAT/PROD deployments.
• Review of various deliverables from offshore.
• Maintain C2.0, Rally, ClearQuest Quality tools, for the fixes/changes.
• Extensive Experience in working under challenging environments.

Environment: JD Edwards Enterprise E8.12, Modules - Inventory and Purchase order, Sales Order, Business Services, FDA, RDA, DD, TDA, ER, PODA, ER Debugger, NER, BSFN, Table I/O, SQL, PL/SQL, Oracle 10g, TOAD 9.7, SQL*LOADER, Soap UI, Rally, ClearQuest

Confidential

Technical Consultant

Responsibilities

• Interact with Functional Consultants and users for requirement gathering. Understanding the business requirement specifications/ Functional Requirement documents provided by the client.
• Developing mappings and Designing the Business Process Documents.
• Preparation of technical design documents.
• Customization/ enhancement of JDE objects in E8.12
• Development of various new applications like Workers Payment Report R550008, Leave Report R55088025A, Document Inquiry P5508020, Address Book BU Update R55060116, and Employee Salary Report R5508001
• Production support for existing running E8.12 JDE applications for Construction department.
• Querying on database from backend tools using SQL Developer to ensure JD applications are loading correct data.
• Writing sql queries to read data from database.
• Providing support to offshore members in development and unit testing.
• Preparation, Review & Execution of Unit Test Cases.
• Querying on database from backend to ensure JD applications are loading correct data.
• Debugging & Troubleshooting issues.
• Supported during QA/UAT/PROD deployments.
• To ensure the product quality in all of its development stages till Production.
• Helping end users to get understanding of applications.

Environment: JD Edwards Enterprise E8.12, Modules - Inventory and Purchase order, Sales Order, Finance, HR, Report Design, Application Design, Data Dictionary, Table Design Aid, ER, PODA, ER Debugger, Named Event Rule, BSFN, Debugging BSFN using VC++, Table I/O, SQL, PL/SQL, Oracle 9i, SQL Developer, C2.0

Confidential

Technical Consultant

Responsibilities

• Participated and worked with Functional Analysts in understanding the business requirement, feasibility analysis and assist in generating functional specifications.
• Involved in identifying future content or functionality necessary for JDE System.
• Tracked and prioritized bugs in the current processes and provided alternate technical solutions to solve problems.
• Developed technical design document, including, flowcharts, diagrams, pseudo code to illustrate sequence of steps and describe logical operations.
• Created database objects such as tables, synonyms, indexes, contraints, sequences and database links.
• Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures, Functions and Triggers.
• Used SQL*LOADER to load data from comma separated files into the database.
• Extensively used stored procedures/functions for report generation and sending data to Java based front end for business users.
• Provided support to custom JDE objects. Maintenance of various Order Entry Applications i.e Manufacturing Work Order Entry (P5548013), Service Work Order Entry (P5517714) as per the requirements.
• Handling of CR’s (Change Requests) and enhancements for existing application and followed change management process.
• Debugging & Troubleshooting application and data issues .
• Preparation unit test plan, Review and conduct unit test as per plan.
• Querying on database from backend to ensure applications are loading correct data.
• To ensure the product quality in all of its development stages till Production.

Environment: SQL, PL/SQL, Oracle9i, SQL Developer, SQL*LOADER, Rally, ClearQuest, Windows XP, JD Edwards Enterprise E8.12, Data Dictionary, Table Design Aid, ER, Report Design Aid, FDA, PODA, ER Debugger, NER, BSFN, Table I/O, Remedy

Confidential

Technical Consultant

Responsibilities

• Participated in all phases of the project life cycle including Analysis of Functional Requirement documents, architectural design development and maintenance.
• Identifying standard and custom Data Dictionary items/ tables.
• Involved in creating logical, physical data models for new JDE environment.
• Creating custom Data Dictionary items, tables and Business Views.
• Development of objects as per the requirements.
• Debugging & Troubleshooting issues with system.
• Preparation unit test plan, Review and conduct unit test as per plan.

Environment: JD Edwards Enterprise E8.0, Oracle 9i, Data Dictionary, Table Design Aid, Event Rules, Report Design Aid, Form Design Aid, Processing Option Design Aid, ER Debugger and Named Event Rules

Confidential

Technical Developer

Responsibilities

• Worked from Analysis, Technical Requirements, Detailed Design, Development, Testing, Documentation and Production Support.
• Tracked and prioritized bugs in the current JDE processes.
• Developed technical design document, including flowcharts, diagrams, and/or write pseudo code to illustrate sequence of steps for development.
• Involved in Customization/ enhancement of different JD Objects like application, reports, table, business views, DD items, Processing options, versions and NERs.
• Debugging of NERs and BSFN using VC++
• Provided timely Production Support by quickly analyzing the root cause and by providing alternative solutions to resolve issues.
• Debugging JDE objects for troubleshooting and providing technical solutions.
• Preparation, Review & Execution of Test Cases using testing tool QTP.
• Preparing Technical Design Documents of all modules for system level maintenance.
• Maintaining Quality tool E-Tracker for change requests and sharepoint drive for project documentation during all phases of project.
• Facing frequest internal quality audits and generating required quality reports.
• To ensure the product quality in all of its development stages.

Environment: JD Edwards OneWorld Xe Modules - Inventory and Purchase order, Finance, Application Design, Data Dictionary, TDA, ER, PODA, ER Debugger, NER, BSFN, Debugging BSFN using VC++, Table I/O, E Tracker, Sharepoint Drive, Oracle 9i

Confidential

Technical Developer

Responsibilities

• Prepared technical specifications using FDDs for the customizations required.
• Development/ Customization/ enhancement of JDE Objects in JD Edwards OneWorld Xe and used them to modify Create form Projects/Objects.
• Debugging & Troubleshooting issues with JDE objects and Create form projects .
• Preparation of unit test plan, Review and conduct unit tests as per plan.
• Involved in test data creation during all deployment and testing phases.
• Preparing Technical Design Documents including flow charts and pseudo code.
• Maintaining Quality tool E-Tracker for change requests and sharepoint drive for project documentation during all phases of project.
• Facing frequest internal quality audits and generating required quality reports.
• To ensure the product quality in all of its development stages.

Environment: JD Edwards OneWorld XE, Create form Product Suit Modules - Sales Order Management & Inventory, Data Dictionary, BSVW, Table Design Aid, Index design, triggers on tables, Report/Application Design Aid, Processing Option Design Aid, ER Debugger, NER, BSFN, E Tracker, Sharepoint Drive, Oracle 9i