Job Title: Oracle - Associate Lead Consultant

Experience

8-10 Years

Job Description

Job Description

1. At least 5-8 Years of Experience in Design, Development, Implementation, Upgrade, Customization and Maintenance of Oracle EBS  covering Complete  System. Execute Techno Functional role on Oracle EBS.

2. Contribute to the development and customization of reports, forms, interfaces, concurrent programs, PL/SQL,Experience in developing Reports using XML/BI Publisher and WorkFlow.

3. Developed and customized RICE components like Reports, Forms, Interfaces, Conversions, Extensions  as per client requirements.

4. Strong programming experience in developing Procedures, Packages, APIs,Functions, Triggers,  and other database objects using SQL and PL/SQL.

5. Utilize Oracle Apps Tech-no Functional Knowledge to address challenges in Financials, SCM Modules.

**Required Skills and Qualifications:**

1. Proficiency in Oracle (SQL/PLSQL), Oracle Builder 10g (Reports, Forms), SQL*Loader, XML Publisher, UTL_FILE Utilities, and experience in report development and customization.

2. Strong grasp of Work Flow.

3. Extensive experience in developing new reports and customizing existing reports.

4. Thorough understanding of Oracle EBS and the ability to work effectively as part of a collaborative team.

5. Proven track record in handling complex queries, exception handlers, and technical documentation preparation.

6. Effective stakeholder management including the internal as well as external stakeholders for the project

7. Lead a team to deliver the expected business results

8. Execute unit testing to ensure the sanity of his/her developments.

9. Realistically estimate the requirements from an effort and cost perspective.

10. Realize the development/requirement as per the technical specification provided.

11. Adhere to all coding standards and performance measures, as per customer/organization guidelines.

12. Coordinate with the functional team for requirement gathering/understanding and convert functional specifications to technical specifications.

13. Handle Internal and External stakeholders of projects.

14. Mentor junior consultants on the team and provide assistance if needed.

15. Participate in testing activities along with functional counterparts and provide quick resolutions.

16. Coordinate with functional/business POCs for requirement analysis and to provide appropriate technical solutions.

Good-to-Have

1.Hands on experience in developing Technical Specification Documents, Gap Analysis, Application Design (MD, CV) using AIM Methodology.

2.Expertise in performing Data export, Import and various operations using TOAD/SQL Developer.

3.Expertise in troubleshooting and query performance tuning by using EXPLAIN_PLAN, SQL Trace and TKPROF Utilities, hints provided by oracle.

4.Good understanding of oracle Data Dictionary and Normalization Techniques.

5.Excellent team player with Good Communication and Interpersonal skills.

Required Technical/ Functional Competencies

Customer Management:

• Specialized knowledge of customers' business domain and technology suite.
• Use latest technology, communicate effectively, demonstrate leadership, present technical offerings, and proactively suggest solutions.

Projects Documentation:

• Has In-depth understanding of documentation involved in Project like BBP & Solution Design, FS etc.
• Able to build into require project documentation and can do a Peer review for team members documents.

Domain/ Industry Knowledge:

• Working knowledge of customers' business processes and relevant technology platforms/products.
• Ability to prepare process maps, workflows, and business cases with application of industry standards and practices.
• Creation of medium to complex business models.

Functional Design:

• Specialized knowledge of solution design, scope analysis, and building blocks for business cases.
• Identifying key business drivers and translating them into solution components
• Creating diagrams from use cases and updating design specifications
• Understanding functional specifications and designing flexible solutions
• Collaborating with stakeholders to explain the solution approach
• Offering solution options based on research and coordinating process playbacks and reviews for business solutions.

Requirement Gathering and Analysis:

• Specialized knowledge of requirement management processes and requirement analysis processes, tools & methodologies.
• Extract requirements for complex scenarios and prototype independently.
• Identify modules impacted, features/functionalities impacted and arrive at high level estimates.
• Develop traceability matrix and identify transition requirements.

Test Management:

• Able to perform unit testing & perform comparison testing for rehosting, report testing status and create iteration, system integration test plan and develop integration test cases as required.
• Execute automation test scripts/manual test cases as per test plan, record findings and DIT Test Cases against the baseline code provided.
•  Identify, report and document defects identified and perform defect fix/ deviations from expected results
• Create test cases, test scenarios and test data and perform Development Integration Testing.

Required Behavioral Competencies

Accountability:

• Takes responsibility for and ensures accuracy of results and deadlines of the function and/or team and in completing own work.

Collaboration:

• Reaches out to others in team to ensure connections are made and team members are working together.
• Looks for ways to integrate work with other teams, identifying similarities and opportunities, making necessary changes in work to ensure successful integration.

Agility:

• Demonstrates openness to the possibilities that change presents and begins to plan for how role may change.
• Works with others to prepare for change.

Customer Focus:

• Identifies trends and patterns emerging from customer preferences and works towards customizing/ refining existing services to exceed customer needs and expectations.

Communication:

• Communicates well-organized ideas, information, and data to broad and diverse audiences across the Organization (through formal and informal presentations).
• Helps others identify their appropriate audience.

Drives Results:

• Sets realistic stretch goals for self & others and perseveres to follow through with resilience and remains calm in a crisis or stressful situation to exceed organization/client expectation.

Resolves Conflict:

• Identifies and understands the source of conflict, addresses, and overcomes.

Certifications

Mandatory

Job Title: Oracle - Associate Lead Consultant

Experience

8-10 Years

Job Description

Job Description

1. At least 5-8 Years of Experience in Design, Development, Implementation, Upgrade, Customization and Maintenance of Oracle EBS  covering Complete  System. Execute Techno Functional role on Oracle EBS.

2. Contribute to the development and customization of reports, forms, interfaces, concurrent programs, PL/SQL,Experience in developing Reports using XML/BI Publisher and WorkFlow.

3. Developed and customized RICE components like Reports, Forms, Interfaces, Conversions, Extensions  as per client requirements.

4. Strong programming experience in developing Procedures, Packages, APIs,Functions, Triggers,  and other database objects using SQL and PL/SQL.

5. Utilize Oracle Apps Tech-no Functional Knowledge to address challenges in Financials, SCM Modules.

**Required Skills and Qualifications:**

1. Proficiency in Oracle (SQL/PLSQL), Oracle Builder 10g (Reports, Forms), SQL*Loader, XML Publisher, UTL_FILE Utilities, and experience in report development and customization.

2. Strong grasp of Work Flow.

3. Extensive experience in developing new reports and customizing existing reports.

4. Thorough understanding of Oracle EBS and the ability to work effectively as part of a collaborative team.

5. Proven track record in handling complex queries, exception handlers, and technical documentation preparation.

6. Effective stakeholder management including the internal as well as external stakeholders for the project

7. Lead a team to deliver the expected business results

8. Execute unit testing to ensure the sanity of his/her developments.

9. Realistically estimate the requirements from an effort and cost perspective.

10. Realize the development/requirement as per the technical specification provided.

11. Adhere to all coding standards and performance measures, as per customer/organization guidelines.

12. Coordinate with the functional team for requirement gathering/understanding and convert functional specifications to technical specifications.

13. Handle Internal and External stakeholders of projects.

14. Mentor junior consultants on the team and provide assistance if needed.

15. Participate in testing activities along with functional counterparts and provide quick resolutions.

16. Coordinate with functional/business POCs for requirement analysis and to provide appropriate technical solutions.

Good-to-Have

1.Hands on experience in developing Technical Specification Documents, Gap Analysis, Application Design (MD, CV) using AIM Methodology.

2.Expertise in performing Data export, Import and various operations using TOAD/SQL Developer.

3.Expertise in troubleshooting and query performance tuning by using EXPLAIN_PLAN, SQL Trace and TKPROF Utilities, hints provided by oracle.

4.Good understanding of oracle Data Dictionary and Normalization Techniques.

5.Excellent team player with Good Communication and Interpersonal skills.

Required Technical/ Functional Competencies

Customer Management:

• Specialized knowledge of customers' business domain and technology suite.
• Use latest technology, communicate effectively, demonstrate leadership, present technical offerings, and proactively suggest solutions.

Projects Documentation:

• Has In-depth understanding of documentation involved in Project like BBP & Solution Design, FS etc.
• Able to build into require project documentation and can do a Peer review for team members documents.

Domain/ Industry Knowledge:

• Working knowledge of customers' business processes and relevant technology platforms/products.
• Ability to prepare process maps, workflows, and business cases with application of industry standards and practices.
• Creation of medium to complex business models.

Functional Design:

• Specialized knowledge of solution design, scope analysis, and building blocks for business cases.
• Identifying key business drivers and translating them into solution components
• Creating diagrams from use cases and updating design specifications
• Understanding functional specifications and designing flexible solutions
• Collaborating with stakeholders to explain the solution approach
• Offering solution options based on research and coordinating process playbacks and reviews for business solutions.

Requirement Gathering and Analysis:

• Specialized knowledge of requirement management processes and requirement analysis processes, tools & methodologies.
• Extract requirements for complex scenarios and prototype independently.
• Identify modules impacted, features/functionalities impacted and arrive at high level estimates.
• Develop traceability matrix and identify transition requirements.

Test Management:

• Able to perform unit testing & perform comparison testing for rehosting, report testing status and create iteration, system integration test plan and develop integration test cases as required.
• Execute automation test scripts/manual test cases as per test plan, record findings and DIT Test Cases against the baseline code provided.
•  Identify, report and document defects identified and perform defect fix/ deviations from expected results
• Create test cases, test scenarios and test data and perform Development Integration Testing.

Required Behavioral Competencies

Accountability:

• Takes responsibility for and ensures accuracy of results and deadlines of the function and/or team and in completing own work.

Collaboration:

• Reaches out to others in team to ensure connections are made and team members are working together.
• Looks for ways to integrate work with other teams, identifying similarities and opportunities, making necessary changes in work to ensure successful integration.

Agility:

• Demonstrates openness to the possibilities that change presents and begins to plan for how role may change.
• Works with others to prepare for change.

Customer Focus:

• Identifies trends and patterns emerging from customer preferences and works towards customizing/ refining existing services to exceed customer needs and expectations.

Communication:

• Communicates well-organized ideas, information, and data to broad and diverse audiences across the Organization (through formal and informal presentations).
• Helps others identify their appropriate audience.

Drives Results:

• Sets realistic stretch goals for self & others and perseveres to follow through with resilience and remains calm in a crisis or stressful situation to exceed organization/client expectation.

Resolves Conflict:

• Identifies and understands the source of conflict, addresses, and overcomes.

Certifications

Mandatory