Coordinate with business stakeholders to capture requirements and convert them into technical tasks.

- Creating JIRA – Stories/Epics to capture the requirement with optimum details, use cases and workflows.

- Coordinating with scrum team/s during requirement handover and addressing their queries.

- Assisting QA team in writing testcases and with business users during UAT/BAT.

- Creating Book of work for multiple teams and do impact analysis for complex features and setup a timeline.

- Conducting Roadmap calls with various stakeholders(Business and Technical both) to discuss upcoming changes

and assist them in planning their requirements.

- As a Scrum Master Drive Daily scrum, Sprint Planning, Sprint Demo, Sprint Retrospective and Scrum Of Scrum

meetings.

- Reviewing JIRAs of other BAs to ensure the correctness of information and its overall structure.

- Assist QA and Dev team to understand requirements and break down the same into subtasks and also help the

team in estimation.

- As an Oracle developer, coordinating with front-end design team and provide them with DB objects like Tables,

Partitioned Tables, Views, Materialized Views, Synonyms, Packages, Procedure, Functions and Indexes as per

requirement, insight to the data and test data preparation for Dev Testing.

- Involved in the continuous enhancements and fixing of production problems.

Creating reports using Oracle BI Publisher and customizing existing reports.
- Creating Materialized views for the faster generation of BI Reports.
- Creating Packages/Procedure/Functions for complex reports and Pre/Post ETL steps.
- Performance tuning of critical reports and Suggestions for ETL and Datamart design Optimization.
- Training the team of 5 on Oracle BI Publisher and its best Practices.
- Code Reviews, Technical and functional Documentation of requirements.

Evaluating Current Database Design and redesigning the same based on trend of queries and growth rate of data.
- Evaluating the reports/queries to be optimized and make necessary changes for performance improvement of
above 70%.
- Performance tuning of all Reports and queries using explain plan, better indexing, partitioning strategies,
Datamart creation to gain improvement of more than 70%
- Redesigning ETL process for parallel execution of mappings using OPC scheduler, changing loading criteria and
reorganization of Index for improved fetch response.
- Requirement gathering, Analysis, Estimation and E2E Delivery of Reports generated from the Data Warehouse.

Evaluating Current Database Design and redesigning the same based on trend of queries and growth rate of data.
- Evaluating the reports/queries to be optimized and make necessary changes for performance improvement of
above 70%.
- Performance tuning of all Reports and queries using explain plan, better indexing, partitioning strategies,
Datamart creation to gain improvement of more than 70%
- Redesigning ETL process for parallel execution of mappings using OPC scheduler, changing loading criteria and
reorganization of Index for improved fetch response.
- Requirement gathering, Analysis, Estimation and E2E Delivery of Reports generated from the Data Warehouse.