Rakesh Kumar Email & Phone Number

Hyderabad, Telangana, India

In my role, I conducted a thorough business analysis by collaborating with end users and stakeholders to identify system and operational requirements. This involved proposing enhancements aimed at improving efficiency across various processes. I created Data Stage jobs to extract, transform, and load data from diverse sources, including relational databases and flat files, ensuring seamless integration into data warehouses. To guide project development, I gathered business requirements from… Show more In my role, I conducted a thorough business analysis by collaborating with end users and stakeholders to identify system and operational requirements. This involved proposing enhancements aimed at improving efficiency across various processes. I created Data Stage jobs to extract, transform, and load data from diverse sources, including relational databases and flat files, ensuring seamless integration into data warehouses. To guide project development, I gathered business requirements from users, such as insurance policy managers, and drafted comprehensive Business Requirement Specifications (BRS). Additionally, I performed requirement analysis and developed Use Cases and Activity Diagrams using UML, clarifying requirements and enhancing communication among stakeholders.To optimize database performance, I utilized Query Analyzer and Execution Plans, enhancing SQL queries to reduce response times for end users. I identified necessary Business and System Narrative Use Cases, creating UML diagrams, including Use Case Diagrams and Activity Diagrams using Microsoft Visio. My understanding of business logic and user requirements enabled me to develop effective Test Plans and Test Cases that aligned with project goals. Furthermore, I converted SQL statements into stored procedures, which reduced database accesses and improved application performance. By leveraging tools like SSRS for report generation and Excel for data analysis, I provided valuable insights to stakeholders. I also integrated Salesforce for customer relationship management and utilized Google Analytics to track user engagement, ultimately creating interactive dashboards with Power BI for real-time access to key performance indicators. Throughout the project, I employed JIRA for project management and collaborated using Google Docs, XMind, and SharePoint to enhance documentation and information management. Show less

Hyderabad, Telangana, India

I efficiently elicited and translated business requirements into detailed user stories and epics, utilizing JIRA for effective tracking and management of project progress and stakeholder feedback. This process involved creating comprehensive user stories that included acceptance criteria, prototypes, and business value, ensuring clarity and alignment with project objectives. I conducted AS-IS and TO-BE analyses of current workflows to design effective business solutions, making strategic… Show more I efficiently elicited and translated business requirements into detailed user stories and epics, utilizing JIRA for effective tracking and management of project progress and stakeholder feedback. This process involved creating comprehensive user stories that included acceptance criteria, prototypes, and business value, ensuring clarity and alignment with project objectives. I conducted AS-IS and TO-BE analyses of current workflows to design effective business solutions, making strategic recommendations based on data insights from SQL and SAS. By leading requirement-gathering meetings and facilitating planning sessions, I captured diverse stakeholder perspectives and clarified requirements, enhancing team productivity and alignment with project goals.To support project transparency and accountability, I delivered key requirement documents such as use cases and process flows. I conducted gap, scope, and impact analyses on business processes using UML and BPMN, identifying opportunities for workflow optimization. I developed wireframes and mockups with Balsamiq to visualize system design, enabling timely stakeholder feedback and ensuring alignment with user needs. Utilizing Power BI for data visualization and reporting, I created dynamic dashboards that presented key performance indicators in an easily digestible format. Throughout the project lifecycle, I maintained effective communication with stakeholders, coordinated with cross-functional teams, and championed user acceptance testing (UAT) processes, ensuring that solutions met user needs and quality standards before deployment. Show less