Manju Merugu

ad08xe@r.postjobfree.com

+1-937-***-****

PROFESSIONAL SUMMARY

Around 4+ years of experience as a Business Analyst in IT, E-commerce across all Software development life cycles (SDLC) such as waterfall and agile methodologies. Well-versed with Databricks SQL and My SQL.

Hands-on experience with SQL queries, able to write detailed queries for Joins, Views, Stored Procedures, and regular data fetching.

Good understanding of the various development languages and platforms like Python, Java, and C and how they relate to the development of Service-Oriented Architecture in the form of Web Services and Web Methods.

Good understanding of the business processes in the Supply Chain and E-Commerce domain and excellent understanding of Multi-Channel Fulfilment & Warehouse Management operations.

Excellent knowledge of Software Development Life Cycle (DLC) and industry-standard methodologies like Agile, Waterfall, and SCRUM methodologies.

Feasibility Study (SWOT Analysis), GAP Analysis, and Competitive analysis to estimate organization and stakeholder change readiness.

Experience in writing and maintaining the Requirement Definition Document that included Business Requirements (BRD) and Functional Requirements (FRD).

Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs.

Strong Knowledge in creating stories and tasks in JIRA for the sprint.

Certified and Skilled Scrum Master with good communication and interpersonal skills as demonstrated in the facilitation of the various scrum ceremonies such as Sprint.

Expertise in Data Modelling, Data Profiling, and in-depth knowledge of RDBMS and Data Warehousing processes.

Knowledgeable in involved Database Roles such as Data Integration, Data Validation, and Data Mapping.

Excellent work ethics and analytical skills coupled with excellent communication, written and interpersonal skills describe a committed team player.

Extensive experience working with users, technical teams, project managers, SMEs, as well as senior management.

Strong MS Excel skills including making pivot tables, preparing charts, using Goal seek and solver, conditional formatting, Data validation working with different function types, and BA Macro.

TECHNICAL SKILLS

Methodologies

Agile, Waterfall, SDLC, SCRUM

Microsoft Office

Project, Word, Excel, SharePoint, PowerPoint

Languages:

SQL, C++, HTML, UML, XML

Web Technologies:

HTML, CSS, JSP, PHP, Servlet, JavaScript, Angular, Node, React

Databases:

MS Access, Databricks SQL, SQL Server, My SQL, Oracle 10g/11g

Tools:

Git, Maven, spring framework, AWS, Hadoop, Apache, Cloudera, Horton Works, Oracle VirtualBox, RPA

Web Technologies:

HTML, CSS, JSP, PHP, Servlet, JavaScript, Angular, Node, React

WORK EXPERIENCE

Rabobank, St. Louis, MO May ’23 - Present

Business Analyst / Scrum Master

•Proven experience in root cause analysis for problem resolution with the ability to investigate complex issues and make informed decisions.

•Used Rational Rose to designed and develop Use Cases Scenarios, Use Cases Models, Activity Diagrams, Sequence Diagrams, State chart diagrams, OOAD using UML.

•Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized.

•Developed UML Use-Cases and Use-Case diagrams after accessing the status and scope of the project and understanding the business processes using Rational Rose.

•Facilitated Joint Requirement Planning (JRP) sessions with SME's in understanding the Requirements pertaining to Loan Origination to Loan Processing.

•Creating User Stories for Agile SCRUM based development methodology.

•Created requirements analysis and design phase artifacts using Requisite Pro, activity diagrams and Sequential diagrams.

•Technical liaison between System Operations, Operational Security, and Application Development teams in migrating traditional IT “On-Premises” assets to the AWS Cloud.

•Created product design specification document to depict necessary drawings, dimensions, environmental factors, ergonomic factors, aesthetic factors, maintenance.

•Created User Stories and developed other scrum artifacts as part of deliverables.

•Conducted requirement workshops for business users to create a process integration document.

•Communicate the functional requirements to IT team by creating JIRA user stories.

•Conducted one-on-one meetings with the project SMEs to gather the requirements. Facilitated sessions with users and documented their changes in requests.

•Facilitated business requirements gathering sessions with the business and overlooked the creation of Use Cases/Activity Diagrams and Functional Specifications using Visio.

•Participated in the development and grooming of Project Backlog Stories (Requirements) with business and technology partners.

•Understood and articulated business requirements from user interviews and converted requirements into system requirements.

•Entered and updated Issues (Epics, Stories, and Tasks) onto JIRA Agile application.

•Created Use Cases and Business requirement document after accessing the status and scope of the project and understanding the business processes.

•Documented Requirement Traceability Matrix to map requirements - System Test Cases and performed Gap Analysis.

•Elicited User stories and created Test plans, Test Strategy Document, Test cases, developing and maintaining Test scripts, Analyzing bugs, UAT Summary Reports.

•Conducted JAD sessions with end-user community ensuring that the software addressed all business needs.

•Involved in Feasibility, GAP and Risk Analysis to identify the business critical and high-risk areas of the application.

•Created user guides and operation manuals for quality team and business users.

•Evaluated information gathered from multiple sources, and reconciled conflicts.

•Conducted Performance analysis after data integration to Cloud.

• Analyzed trends and statistical information, developed reports, and provided recommendations for improving the workflow efficiencies and effectiveness.

Concentrix Hyderabad India Dec 2018 – July 2021

Business Analyst

Responsibilities

Worked with the account managers, managements, and report requestors to gather requirements and get report requests.

Wrote Business Requirements, analysed them and tested them.

Actively involved in SDLC process as the project followed Agile Scrum methodology.

Analysed trading partner specifications and created EDI mapping guidelines.

Involved in designing the process flow diagrams for flow of information and report creation process.

Conducted JAD sessions for the report users, requestors, and the developers. Prepared Need Analysis Documents of the requirements gathered through JAD sessions.

Used MS Office for creating Vision, Use Cases, and Supplementary Specification Documents. Reviewed Requirements & deliverables for delivery timeline.

Used MS Visio to create Flow diagrams and Use Case Diagrams.

Created presentations explaining the entire report development process, while drawing a comparison between the legacy & the new report.

Coordinated with the developer, on day-to-day basis, during the development process.

Involved in determining test strategies based on requirements and architecture.

Engaged in analysing requirements, identifying various individual logical components, expressing the system design through UML diagrams.

Communicated results by sending implementation notice to the stakeholders while keeping the developers closely updated on all documented refinements.

Constructed complex SQL queries to retrieve data, conduct data analysis, and perform data validation.

Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.

Accenture Hyderabad India Apr 2017 – Dec 2018

Business Analyst

Responsibilities

Involved in preparing project plans and identifying major milestones for each stage as per the SDLC model (Agile Methodology).

Coordinated with the development and testing team to conduct white box testing on the new application and database systems using HP Quality Center.

Worked heavily on SQL Server database to extract data and build business reports.

Delivered documentation for the above including Business Cases, BRD, FRD, Use Cases, Business Rules, and Process Flows.

Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.

Facilitated Joint Application Development (JAD) session for communicating and managing expectations with SMEs whose customers were going to be the final users of the product.

Performed Gap Analysis to identify the deficiencies of the current system and identified the requirements for the proposed system.

Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.

Maintaining Windows/UNIX servers across and provide the infrastructure support for front line Production role in Java/.NET based GS frameworks, applications, and services.

Utilized strong technology skills to capture and document key business requirements, risk metrics, insights, and trends to assist in the long-term decision-making and reporting process.

Perform a comprehensive review of the risk control framework to align internal processes with organizational objectives.

Web Server Installation and configuration of Applications in Microsoft IIS and develop new tools to enhance the current applications by adding new features and automation to ensure better services for the users and Managed multiple and concurrent projects to make sure about the completion of work within the defined scope, budget, and time.

Ensured smooth code release cycle from Development through UAT and Production in co-ordination with development team.

Calculating Risk Matrix and segregating them into Business Risk, Non-Business Risk and Financial Risk.

Co-ordinate weekly status call with Dev team on pending issues in the application.

Used Scrum Agile Methodology in my work along with Microsoft Office, JIRA, MS Teams tools.

MS, Business Analytics

Wright state university, Ohio, USA

MBA, Human Resource

MLR Institute of Technology, Hyderabad, India

Bachelor of Science

Mathematics, Statistics, Computer science

Rishi UBR Degree College for Women’s, Hyderabad, India

Contact this candidate