Home

Ravi teja - J.M. Smucker, Orrville, Ohio (Business analyst)

tejaravitx@gmail.com

Location: Abbeville, Georgia, USA

Relocation: yes

Visa: stem opt

Ravi Kumar tejaravitx@gmail.com (703) 574-2495 x 8053 Visa Stem opt SUMMARY Qualified professional with 5+ years of extensive experience in the field of Business Analysis In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D). Extensive knowledge in Software Development Life Cycle (SDLC), Project Management Life Cycle (PMLC) and software development methodologies such as Agile/Scrum, RUP, Waterfall etc. Expertise in collaborating with stakeholders, developers, and QA teams to ensure seamless SDLC execution. Adept at collaborating with stakeholders to translate business needs into visually structured workflows. Create detailed Business Requirement Documents (BRD) and Functional Requirement Documents (FRD). Experienced Business Analyst with in-depth knowledge of SDLC methodologies, including Agile, Waterfall, and Hybrid models. Skilled in writing complex SQL queries, stored procedures, and optimizing database performance. Experienced Business Analyst with expertise in Microsoft Office 365 and Copilot, driving data-driven decision-making and process automation. Collaborate with cross-functional teams, including developers, QA, and business stakeholders. Experienced Business Analyst with expertise in SSRS and Power BI for data visualization and reporting. Skilled in requirement gathering, stakeholder communication, and process optimization, utilizing Microsoft tools for seamless collaboration. Perform data analysis to support business decisions and process improvements. Coordinate with development teams to ensure accurate implementation of business needs. Experienced Business Analyst with expertise in SSRS for generating customized reports and data visualizations to support business decision-making. Maintained and updated process diagrams in MS Visio to reflect business and system changes. Successful in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) using Rational Rose & MS Visio. Strong knowledge of SQL queries and data modeling to extract insights from structured databases. Highly proficient in working with users to gather requirements, analyze them and subsequently use the Rational project and design tools to model the requirements. Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements. Experienced Business Analyst with a strong background in Power BI for data visualization, reporting, and business intelligence solutions. Document business processes, workflows, and system interactions. Experienced Business Analyst with a strong background in Oracle and SQL Server databases. Proficient in SQL querying, data analysis, and database management to support business decisions. Strong experience in Software Development Life Cycle SDLC methodologies such as Agile, RUP and Waterfall. Performed GAP Analysis to check the compatibility of the existing system infrastructure with the new business requirements. management system. Skilled in SSRS report development, including parameterized and drill-down reports for enhanced decision-making Business Analyst J.M. Smucker, Orrville, Ohio Dec 2023 Till date Performed GAP Analysis to check the compatibility of the existing system infrastructure with the new business requirements. management system. Analyzed business requirements and translated them into functional and technical specifications for Oracle and SQL Server databases. Prepared UAT Materials, including the UAT Process, UAT Test document which would include step-by step process for UAT as well as all the tests that would cover all requirements. Develop and optimize Power BI data models to improve performance and ensure efficient data retrieval. Work with IT and business teams to integrate SSRS reports with other reporting tools and business intelligence solutions. Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall. Held weekly meetings with developers and QA/testers to ensure project deadlines were being met. Gather and analyze business requirements to design and develop SSRS reports for data-driven decision-making. Used MS Visio for Process modelling and Business Process flow diagrams. Collaborated with cross-functional teams to gather, analyze, and document business requirements. Utilized SQL and other analytics tools to extract and analyze large datasets for actionable insights. Utilized Microsoft Office Co-Pilot to streamline document creation, data analysis, and reporting for business requirements. Documented gap analysis and impact assessment diagrams in Visio to support strategic decision-making. Collaborated with stakeholders using Outlook Co-Pilot, automating meeting scheduling and follow-ups for project updates. Created detailed reports and dashboards for stakeholders using data visualization tools. Gather and analyze business requirements to design and develop Power BI reports and dashboards that meet stakeholder needs. Used Microsoft Visio to illustrate user journey maps and enhance user experience (UX) understanding for development teams. Provided training and documentation on Visio best practices, ensuring consistency and accuracy in process documentation. Automated repetitive tasks using Excel Co-Pilot, enhancing data processing efficiency for business insights. Used Teams Co-Pilot to transcribe and summarize meetings, ensuring clear communication of project objectives. Business Analyst General Mills , Minnesota, U.S. June 2020 Nov 2023 Gathered and documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders. Presented and demoed the completed stories and features to the Stakeholders, Scrum team, leadership teams during Sprint Review and communicate the incremental progress of the product to the stakeholders and making sure the increments are in alignment to the business value and the overall product vision Managed all the requirements in RequisitePro, making requirements available to all team members. Used Crystal Reports to design a complex, on the fly, report that displayed complete charts based on the parameters. Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration testing, functional testing, alpha & beta testing. Identified/documented data sources and transformation rules required populating and maintaining data warehouse content. Prioritized and maintain technical product backlog. Develop interactive dashboards and reports using Power BI, ensuring data accuracy and usability. Conducted requirement elicitation sessions, including interviews, workshops, and JAD sessions, to refine business needs at each SDLC phase. Experience in Facilitating Specification walk-through and Joint Application Design (JAD) sessions with stakeholders as required Work closely with database developers and data analysts to extract, transform, and present accurate data in SSRS reports. Expert and highly familiar with a wide variety of engineering, development, project management, release management, change management, business analyst, operating system software, testing. Created detailed process flow diagrams and workflow charts using Microsoft Visio to document business processes and system interactions. Developed use case diagrams, sequence diagrams, and entity-relationship diagrams (ERD) in Visio to support functional and technical requirements. Collaborate with stakeholders to define reporting needs and ensure alignment with business objectives. Develop and maintain SSRS reports, dashboards, and visualizations to support operational and strategic goals Business Analyst Simmons Pet Food, Arkansas, United States of America Feb 2018 May 2020 Ability to work with functional teams in an Agile/SCRUM and SAFe environment. Experience in business analysis and project management, various SDLCs- Agile, Scrum and Waterfall, UI, UML Use Cases and Focus Groups Performed Manual Testing, Regression Testing, System Testing, Usability Testing and Validation Testing on different mobile and web applications and also documented the result report according to the required standards. Derive feature and story grooming to identify high value items and prioritize them in the backlog accordingly within team sprint planning session. Experience in developing UAT Plan and UAT Cases. Expert at using Microsoft Office Tools like MS Word, MS Excel, MS project and Power Point for Documentation, Reporting and Presentation Maintained and updated process diagrams in MS Visio to reflect business and system changes. Created and managed detailed BRD and FRD documents in Word with Co-Pilot, ensuring accuracy and completeness. Conduct data validation and testing of SSRS reports to ensure accuracy, completeness, and compliance with business requirements. Strong technical and communication skills, ability to take direction, handle multiple-tasks and work well in a team environment Document Power BI report specifications, data models, and business logic for future reference. Provide user training and support on Power BI dashboards and report functionalities. Work with SQL databases to fetch and manipulate data for Power BI reporting. Extract, transform, and load (ETL) data from multiple sources into Power BI for analysis and reporting. Collaborated with stakeholders to define project scope, objectives, and deliverables following Agile, Waterfall, and hybrid SDLC methodologies. Gather and analyze business requirements to design Power BI reports and dashboards for data-driven decision-making. Designed and documented business process flows using MS Visio to visualize workflows and system interactions. Create and optimize SQL queries for SSRS reports to ensure efficient data retrieval and processing. Document report specifications, data sources, and business logic to facilitate knowledge transfer and maintenance. Designed dynamic dashboards in Excel with Co-Pilot, enabling real-time decision-making and trend analysis. Gathered, analyzed, and documented business requirements throughout the SDLC, ensuring alignment with stakeholder expectations. Keywords: quality analyst user interface user experience business intelligence information technology microsoft Colorado