Sai Srimanth Garikipati

I come with a robust background in business analysis and data management, I bring a wealth of experience in translating user requirements into comprehensive Business Requirement Documents (BRD) and Functional Specifications. My expertise spans various audits through the extraction and analysis of SAS reports, leveraging statistical tools like Microsoft Excel, SAS, and others to derive meaningful conclusions from data.

In my role, I've excelled in creating Business Workflows based on client requirements, fostering effective communication through organized Joint Application Design (JAD) sessions. I've championed Agile methodologies, coaching and mentoring teams on user story writing, acceptance criteria, and scrum processes, contributing to successful project deliveries.

My skills extend to project governance, ensuring adherence to PMO guidelines, and creating structured Technical Requirement Documents (TRD). I've been instrumental in developing detailed test plans and strategies, utilizing Scrum methodology throughout the Software Development Life Cycle (SDLC). My technical proficiency encompasses a broad range of tools, from Microsoft Project and Visio to SQL queries in Oracle, SQL Server, and DB2 environments for data validation in Data Warehouse/ETL applications.

In BI, I've actively contributed to defining and delivering strategies, creating reports, dashboards, and scorecards using Tableau, SSRS, and Microsoft Visual Studio. Additionally, my experience includes mentoring on business domain intricacies, representing the Product Owner in Scrums, and conducting User Acceptance Testing (UAT).

I've demonstrated proficiency in data modeling, conducting JAD sessions for software requirements, and performing backend testing using SQL queries. With a solid understanding of Business Process definition, Risk Analysis, and SDLC methodologies, I am well-equipped to drive success in complex, data-driven projects.

• Assessed Requirements Analysis, Efforts and Time Estimations, Task Allocations, clarified Business Requirements where needed and Managed the Project's progress.
• Compiled comprehensive UI Refresh Requirements for Web application and Mobile (iOS and Android) by researching & analyzing the existing System in Prod.
• Coordinated UAT/QA testing; training included the subsequent change control Schedule and
  Documentation for production release.
• Worked closely with the Design and Development teams and gave inputs to improve the User experience (Web/Mobile iOS/Android) to finalize the Design Elements.
• Involved in conducting performance tuning of complex SQL queries and stored procedures by using SQL.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Collaborated with developers and subject matter experts to establish the technical vision and analyzed tradeoffs between Usability and Performance needs.
• Collected and analyzed the Test Metrics and submitted Reports to keep track of the status and progress of the Testing effort using JIRA.
• Prepared the Business Requirement Document (BRD) and System Requirement Document (SRD) for the enhancement of the existing services.
• Developed User Stories, Test Scenarios, Tasks, and Bugs using JIRA and uploaded documents in CONFLUENCE.
• Participated in Daily Agile Scrum "Stand-up", Biweekly Sprint Planning and Retrospective Sessions and update the team on status of upcoming User Stories.
• Developed and maintained detailed schedules of project focusing on daily progress, milestones and critical tasks in timelines within MS Project.
• Participated in walkthrough during Business Requirements Document and System Specifications Document stages.
• Setup and maintained automation workflows in HP UFT, written and maintained modularized function Library used for the Automation.
• Liaison between the cross-functional teams, top management clients, users and any stakeholder involved in the project.
• Created and maintained the Object Repository for the Web, Mobile and Thick-Client Application. Performed Data Driven Regression and Smoke Testing for every modification in the application & new Builds using HP-UFT.
• Responsible for dealing with the problems, bug fixing and troubleshooting.
• Experimented with various SDLC methodologies Agile, Scrum and RUP to increase visibility and control during different phases of software development involving global teams.
• Supported the Product Owner in managing customer expectations for project deliverables, managing stakeholder communications, and helping to implement an effective system of project governance.
• Tracked and assisted in determining needed resources for Cost Benefits Analysis with Project Manager and Product Manager.
• Interacted with Developers and other Business Analysts regarding testing status.
• Executed basic SQL commands/queries to verify the data committed to the backend.
• Communicated and worked with both Developers and Testers in a concise and cohesive manner.
• Completed other various tasks assigned by PMO Team, Project Manager and from peer review meetings.
• Prepared the Business Requirement Document (BRD) and System Requirement Document (SRD) for the enhancement of the existing services.
• Served as Communication Bridge between non-technical users and technical solution developers.
• Collaborated as part of the Scrum Team in grooming User Stories and Development of Acceptance Criteria for the User Stories, broke down the Scope of the Project into User Stories which clearly articulated Development Requirements and Acceptance Criteria

• Strong analytical skills, with a desire for continuous improvement and an ability to identify dependencies and root causes within problems
• Proven ability to collaborate broadly with flexible, positive attitude and ability to get results Ability to handle and execute to resolve high profile issues
• Exceptional oral and written communication skills; ability to communicate to the senior executive level SQL development skills stored procedures, complex queries, triggers etc.
• Understand true costs, performance, Global Technology infrastructure quality, applications, and services
• Provided critical insights to help drive Global Technology investment strategies
• Perform complex research and analysis to support business operations and processes and develop recommendations based off findings
• Manage development of new features, components, and processes to compliment and extend the existing technology platform
• Created the JIRA/SQL scripts for demonstrating the prototypes and for verifying the result sets and used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall. Develop and report on project-based Key Performance Indicators (KPIs)
• Project governance, including day-to-day management and resolution of risks, issues and dependencies
• Act as liaison between Stars Data and Analytics Team and functional measure or program performance owners
• Provide architectural assessments, strategies, and roadmaps for one or more technology domains Develop Proof-of-Concept projects to validate new architectures and solutions
• Extracted SharePoint site reports using SCE provided robust tool ACTIVE navigation tool.
• Provided consulting services in taxonomy management and strategy, information architecture, and auto-classification.
• Understand data sources, data structure and data capture and reporting systems in TIAA Asset Management
• Understand data sources, data structure and data capture and reporting systems in the investment boutiques
• Working under a quality management system, learning from the audit regime
• Skilled in collaborating with cross-functional teams to gather process information, document current workflows, and identify areas for improvement.
• Collaborated with stakeholder groups across the organization to ensure business and technology alignment. Proposed solutions meeting defined specifications and needs
• Proven knowledge and proficiency in management and use of databases and associated software Perform group consolidation (quarterly & monthly)
• Assist with customer issues during deployment, configuration, operation, maintenance or compatibility matters
• Develop data mapping, integration and consolidation approach, methodology and tools Implement data mapping, integration, and consolidation.
• Created work products for conducting ROT (Redundant, Obsolete, Trivial) workshops between customer and business stakeholders.
• Involved in Software Development Life Cycle (SDLC) Requirement Analysis, Testing and Implementation.
• Creating Risk matrix on current workflow and elaborate the objectives which leads to custom negotiation to project.
• Perform data reconciliations between multiple platforms with similar data sets
• Exposure to data quality, records management, security and privacy concepts, best practices, and tools/technologies is advantageous.