Home

Gouthami - Business Analyst III

[email protected]

Location: Ashburn, Virginia, USA

Relocation:

Visa: USC

CANDIDATE INFORMATION: Name: Gouthami Current Location & Visa Ashburn, VA 20148 US / Citizen Phone Number 6143505050 ext 101 Email [email protected] / [email protected] SUMMARY: SAFe POPM Certified Business Analyst with a background in healthcare, financial services, and regulatory reporting. Proven track record in requirement gathering, agile methodologies (and project lifecycle management, specializing in automation and data processing solutions. Proficient in applying SAFe principles to drive agile practices, fostering collaboration across cross-functional teams to ensure alignment, streamline delivery, and optimize value. Skilled in facilitating PI planning, promoting Lean-Agile leadership, and supporting continuous improvement initiatives to enhance project outcomes Extensive experience in gathering and analyzing user requirements, translating them into clear, actionable system specifications to align development with business objectives and user needs. Ability to implement recommended modifications and enhancements on project plans and other forms of documentation to communicate business initiatives to a broader workgroup. Highly skilled in preparing comprehensive documentation, including Business Requirement Documents (BRD), Functional Specification Documents (FSD), Scope Documents, and various technical diagrams such as Context, Data Flow, Sequence, Component, Use Case, and Activity Diagrams. Proficient in defining Non-Functional Requirements to ensure thorough and precise project specifications Experienced in facilitating and actively participating in key agile ceremonies, including PI Planning, Sprint Planning, Backlog Refinement, and Retrospectives, ensuring alignment and continuous improvement throughout the development lifecycle Proficient in deconstructing high-level requirements into manageable features and crafting well-defined user stories with clear, detailed specifications to ensure seamless development and alignment with business goals Extensive experience in developing and executing test sets, ensuring thorough test coverage and reliable validation of system functionality to meet quality standards Experienced in data collection, analysis, and reporting, with the ability to extract and analyze data from diverse sources, including databases, manual files, and external websites, to provide actionable insights and support informed decision-making Skilled in developing and managing comprehensive project communication deliverables, such as roadmaps, planning lists, change requests, timelines, budgets, scope, and requirements, ensuring seamless coordination and alignment with project objectives and stakeholders Experienced in performing Gap Analysis to modernize legacy systems, evaluating the compatibility of existing infrastructure with evolving business requirements to drive seamless transitions and optimize system performance Proficient in using Jira for project management and collaboration, with experience in writing SQL queries to analyze and validate data, ensuring accurate testing and reporting Managed JIRA workflows to streamline tracking of project milestones, enhancing transparency and improving team collaboration and efficiency Strong proficiency in MS Office, with advanced skills in MS Excel, PowerPoint, and Word, enabling efficient data analysis, presentation creation, and documentation EDUCATION: School Degree Completed JNTU, Hyderabad, India Bachelors of Technology in Engineering Yes CERTIFICATIONS: Details Status Year Acquired SAFe POPM Certified Active 2022 Skills Software Development Life Cycle (SDLC) Scaled Agile Framework (SAFe) Business and Requirements Analysis Data Analysis and Reporting Documentation (BRD, FSD, UAT) Features and User Story Development Backlog Grooming and Prioritization JIRA Project Management SQL Query Writing and Data Testing MS Office Suite (Excel, PowerPoint, Word) Tableau PROFESSIONAL EXPERIENCE: Fannie Mae, Reston VA May 2022 - Present Business Analyst III Corporate Finance, Financial Planning and Analysis The FP&A product management team is responsible for managing the technology that supports administrative expense budgeting and planning cycles, primarily serving the BUCFOs within the finance organization. The team also collaborates with stakeholders such as the finance technology and accounting teams. It oversees data governance of the Enterprise Data Management Cloud Services(EDMCS) application, which maintains hierarchies including cost centers, spend categories, projects/initiatives, and capacity-based planning (CBP) codes. A key responsibility includes managing the Deputy Chief Finance Office (DCFO), an AWS-based centralized data repository that integrates financial data from upstream systems like Workday (via FRAS), CDH, JIRA, and HR into the Enterprise Data Lake (EDL). This data is stored in AWS S3 buckets and accessed through redshift spectrum for BI tools and Anaplan modules such as Admin Expense, Corporate Forecast, and Cost Allocation. The team supports automated data ingestion and integration for Anaplan, enhancing the FP&A data model to improve executive reporting and data quality. It also designs and maintains dashboards to streamline BUCFO key extracts (Admin Expense All scenarios, Enterprise Utilization, and 2000 to Date Admin Expense) through daily, quarterly and annual validation cycles. Responsibilities Conducted daily validations of actual and current working forecast metrics in tableau extracts, ensuring alignment with Anaplan data Executed month-end validations on the last business day, verifying updates to prior and prior-prior working forecast metrics in tableau flows, and reconciling Admin Expense and Enterprise Utilization extracts with Anaplan Performed month-close validations on business day 2 and 3, confirming updates to current working forecast and actuals metrics in Admin Expense and EU extracts, and obtaining final confirmation from Workday Carried out quarterly validations in mid-January, April, July and October, updating forecast calculations in Admin Expense and EU data extracts Completed annual plan validations in mid-January to ensure consistency between Annual Plan metrics in the All-Scenarios extract and Anaplan Processed monthly Budget Transfer Requests (BTRs) received via email by updating corresponding entries in Anaplan As a submitter in EDMCS, submitted requests for updates to Core and Non-Core work tag hierarchies Participated in bi-weekly FDM Governance Hypercare calls, contributing to discussions on EDMCS ticket submission and approvals Created, Updated and maintained version-controlled job aids for Core and Non-Core worktag hierarchies in EDMCS Designed power point presentations for governance topics including Program/Initiative, Project Codes, Cost Centers, and Capacity Based Planning (CBP) Developed and maintained data dictionaries for Enterprise Utilization and User Profile Views to support the data science team Responsibilities for EmPowerHR data integration EmPowerHR is a strategic data migration initiative focused on transitioning HR system data into Workday and downstream platforms. The project focused on migrating hey HR system data -including open requisitions from Smart Recruiters and employee information from HRFusion- into Workday, followed by integration with downstream systems such as DCFO and Anaplan. This initiative replaced the legacy data pipeline that previously routed data from HR Home to the Corporate Data Hub, introducing a more streamlined and centralized Workday-based architecture. The project aimed to enhance data accuracy, consistency, and accessibility across enterprise platforms to support efficient HR operations and strategic planning. Validated EmPowerHR data from Corporate Data Hub (CDH) in DCFO tables, including user profiles, payroll, timesheets, fringe, and blended rates. Compared attribute lengths and data types between ACPT and PROD environments Verified workday source files against DCFO tables in ACPT and PROD, ensuring consistency in value lengths and data types across datasets such as reported time blocks, project spend details, invoice details, and FNMA expense reports Cross-checked DCFO actuals and forecast values in Redshift tables with the Enterprise Utilization (EU) view to ensure data integrity Conducted discrepancy analysis on data flowing from CDH to DCFO across different environments, identifying and resolving inconsistencies to support accurate reporting and forecasting Responsibilities for Strategic Portfolio Management (SPM) The Strategic Portfolio Management (SPM) framework aligns delivery with Fannie Mae s strategic priorities by connecting budgets, resources, and operational work to divisional goals and enterprise outcomes. It enables data-driven decision-making around work prioritization through key SPM tools, including JIRA DC, JIRA SaaS, and Apptio Target Process (ATP), ensuring transparency and strategic alignment across initiatives Validated data flow between Apptio Target process (ATP) and DCFO to ensure data integrity across systems Validated key agile artifacts in ATP, including initiatives, epics, features, risks, and dependencies Verified stories, tasks, sub-tasks, and defects within Jira SaaS for completeness and accuracy Ensured successful epic and feature integration between ATP and Jira cloud Conducted life-cycle testing for features, epics, enterprise initiatives and divisional initiatives within the ATP container Reviewed DCFO tables to confirm accurate representation of sample epics and features from ATP Validated the Teams Management dashboard for various team related requests, including new team creation, team information change requests, team retirement, and TOT (Team of Teams) requests Performed budget validation testing within ATP to support financial planning and tracking Office of Minority and Women Inclusion (OMWI), D&I, VA Business Analyst III The Housing and Economic Recovery Act of 2008 (HERA) established the Federal Housing Finance Agency (FHFA, or the Agency) to oversee the safety and soundness of the Federal National Mortgage Association (Fannie Mae). The regulated entities include the Enterprises, the Federal Home Loan Banks. HERA requires each regulated entity to establish an Office of Minority and Women Inclusion (OMWI) that promotes diversity and ensures inclusion in all business and activities at all levels, including employment, management, and contracting. Each regulated entity is required to submit the Procurement, Finance and Counterparty, Board of Directors (BOD) and Workforce reports to FHFA OMWI during the submission period. The amounts for vendor services supporting these expected functions must also be reported. The OMWI at Fannie Mae is required to report the contract and spend data to FHFA on a quarterly and annual basis. The automation of the reporting process for the Quarterly Data Reports (QDR) to the Federal Housing Finance Agency (FHFA), transitioned from a manual process to an automated solution. The project involved system integration of various data sources, including EDI, Procure One, Legal Analytics, FRAS/FDL, RWDL, and Supplier.io. Additionally, Tableau and Workiva reports were generated to enhance data visualization and reporting accuracy. The project utilized AWS Cloud, Python, DBeaver, Postgres, and Redshift as the core technologies for data integration, automation, and efficient reporting by leveraging cloud technologies, including AWS Lambda for serverless computing, EMR for scalable data processing, and S3 for secure data storage, optimizing performance and scalability across the system Contributed to the compliance efforts under the Housing and Economic Recovery Act (HERA) by supporting the Federal Housing Finance Agency's (FHFA) oversight of Fannie Mae s diversity and inclusion initiatives through the Office of Minority and Women Inclusion (OMWI). Assisted in the preparation and submission of quarterly and annual Procurement, Finance and Counterparty, Board of Directors (BOD), and Workforce reports, ensuring accurate reporting of contract and spend data, in alignment with FHFA requirements. Responsibilities: Led the analysis of business functions and data processing requirements for the development of a new data application component, ensuring alignment with organizational goals and technical specifications Directed the gathering and documentation of functional requirements for the SCRUM team, ensuring clear and actionable user stories to drive successful development and delivery Collaborated with internal customers to gain a deep understanding of their business environment and needs, ensuring alignment with project goals and successful delivery of solutions Facilitated the creation of detailed requirements by breaking down the product owner's priorities into manageable components, ensuring clear and actionable tasks for the development team Offered technical support and expertise in analyzing project objectives, ensuring alignment with business goals and optimal solution design Collaborated closely with the Product Owner, data analysts, and developers to plan and prioritize sprints, ensuring alignment with project goals and efficient delivery Facilitated discussions with the development team to ensure a clear understanding of internal customer requirements, fostering alignment and effective solution development Utilized JIRA extensively to document epics, features, and user stories, ensuring clear and organized tracking of project deliverables Conducted a thorough analysis of the project to identify gaps and assess potential impacts, ensuring alignment with objectives and mitigating risks Contributed analysis and feedback during retrospectives on development sprints, identifying areas for improvement and promoting continuous process enhancements Revised priorities as needed, in collaboration with the Product Owner, to ensure alignment with evolving project goals and business needs Participated in Agile Release Train (ART) meetings with cross-functional teams, ensuring alignment and collaboration across all stakeholders to drive project success Conducted in-depth data analysis from multiple sources, created and tested user stories, and prepared test documentation, including test sets and execution plans in JIRA, for successful release management Created and maintained agile testing documentation as Confluence pages, ensuring up-to-date project artifacts and streamlined collaboration across teams Uploaded files from various sources via Dropbox to the landing folder, then analyzed AWS Lambda functions and EMR processing to generate and validate the output Tested the outputs from AWS Lambda and EMR processing of files in the land and prepare folders to ensure accuracy and proper data flow Analyzed and tested Procurement, Finance, Counterparty, and Workforce data to ensure accuracy, integrity, and alignment with business requirements Conducted extensive analysis and testing of raw data to verify the accuracy of spend amount mapping to contracts, along with name standardization of supplier names in procurement, counterparty, and finance reports, ensuring alignment with the trusted source, Party Master Performed end-to-end analysis of workforce files, including active employees, new hires, promotions, and terminations, by uploading files to Dropbox and testing the input data against the data in separate workforce tables for accuracy and consistency Validated supplier diversity data, vendor risk levels, and criticality in the quarterly Procurement Files ensuring alignment with Third Party Vendor Reports for accurate and timely submissions to the FHFA Analyzed data in database tables using DBeaver, writing queries for Redshift and PostgreSQL to extract, validate, and manipulate data for accurate reporting and analysis Tested application modules in both development and acceptance environments to ensure functionality, stability, and alignment with project requirements Managed defect triage for identified bugs in both manual and automated reports, ensuring timely resolution and accurate submissions to FHFA Tested Tableau reports based on the data reported for the respective quarters, ensuring accuracy and consistency with the underlying data Created context diagrams and PowerPoint presentations illustrating the current and future state of various modules in the project, ensuring clear communication of project evolution Conducted extensive analysis and testing of data in quarterly procurement, financial, counterparty, and workforce reports to ensure accuracy and compliance with FHFA submission requirements Collaborated closely with the Scrum Master and Product Owner to prioritize the product backlog, participated in PI planning, and prioritized user stories for each sprint within the PI to ensure alignment with business objectives FEPOC, CareFirst, BlueCross BlueShield, VA Jan 2018-May 2022 Business Analyst The Service Benefit Plan Administration Services Corporation (SBPASC), an affiliate of CareFirst, Inc., provides business processing and technology infrastructure for the Blue Cross and Blue Shield Service Benefit Plan, a health plan offering to Federal employees. The organization provides creative technology solutions to maintain enrollment data and provide claims adjudication systems support on millions of claims annually. Claims Audit Monitoring Tool (CAMT) The claims audit monitoring tool (CAMT) in FEPDirect provides an online display and reporting of the FEPDO program assurance reports used to support post payment claim review. This application provides the plans with a means to review and respond to claims that have been selected for post payment review. The Federal Employee Program Director s office (FEPDO) uses this tool to monitor and track plans progress to ensure the plans investigate and collect overpayments in a timely manner. The CAMT is comprised of different claim functions such as the SWCR (System Wide Claims Review) roster, OPM roster, OIG roster, OIG roster, Duplicates roster, Retro roster, UCM roster, SI Suspense, FEP Global and FBO rosters which are displayed as individual tabs within the application. There is also an upload tab where the plans can upload the files for review. The CAMT application will send an automated notification once every month to the user if the status of a claim is in pending review or system adjusted status within the UCM, Duplicates, and the Retro roster. The project is a user interface modernization (Mod UI) effort for the legacy application with the idea of migrating applications into more modernized technologies (Angular/React/Java/Spring framework). Plan Profile Plan Profile is an application within FEPDirect that provides a user interface for plans to update and delete information. This project is part of the ongoing modernization effort to replace and enhance the capabilities of the legacy application. CAMT Enhancements The CAMT Enhancements project was launched to implement continuous improvements and upgrades to the modernized application, transitioning from the legacy system. These enhancements were guided by feedback and requirements from external customers at FEPDO Responsibilities: Analyzed legacy applications to identify migration gaps and supported developers in the modernization effort, ensuring a smooth transition to the new system Collaborated weekly with external customers from the Director s Office (FEPDO) to gather new requirements for the modernization of the legacy application and drive subsequent enhancements to the modernized system Developed key project documentation, including the Business Requirements Document (BRD), Functional Specifications Document (FSD), and Vision and Scope Document, ensuring clear alignment with business objectives and technical requirements Evaluated information from multiple sources, breaking down high-level requirements into manageable components, including features and user stories, with clear acceptance criteria and supporting details for effective implementation Gathered requirements through weekly business meetings with the Director s Office, facilitated requirement workshops, analyzed business processes, and developed use cases and workflow diagrams to ensure comprehensive understanding and alignment Collaborated with design engineers to create mockups and wireframes, ensuring clear visual representation and alignment with project requirements for comprehensive documentation Developed use cases and context diagrams to effectively communicate business requirements to internal customers, ensuring clarity and alignment across teams Developed a comprehensive project roadmap and conducted gap analysis between current ("As-Is") and future ("To-Be") states, aligning strategic goals and uncovering key areas for improvement Facilitated and actively engaged in essential Agile ceremonies, including PI Planning, Sprint Planning, Backlog Refinement, Sprint Reviews, and Retrospectives to drive effective team collaboration and foster continuous improvement Led weekly backlog refinement sessions to prioritize and clarify sprint backlog items, ensuring stories were properly story-pointed and assigned for timely execution. Continuously enhanced user stories based on feedback from weekly business user meetings. Partnered with the Product and Project Managers to manage and prioritize the product and sprint backlogs, ensuring alignment with project objectives and on-time delivery Developed PowerPoint presentations for Director s Office conferences, highlighting functional and non-functional requirements, and included feature mockups for upcoming releases Presented Business Requirements Documents (BRDs) and Functional Specification Documents (FSDs) to external clients, obtaining approvals and signoffs to confirm alignment with business objectives Conducted application testing in development and acceptance environments, actively participating in User Acceptance Testing (UAT) with internal and external users to ensure functionality met business requirements Collaborated with the testing team to develop test strategies and detailed test plans for each release, ensuring thorough documentation and alignment with project objectives Maintained requirements traceability by creating a Requirements Traceability Matrix (RTM) to accurately link requirements to test cases, enabling the Product Manager to monitor and track project progress effectively Prepared comprehensive project artifacts and documentation for internal users, ensuring clarity and alignment with project goals and requirements Collaborated with technical writers and the end-user documentation team to communicate and review functional requirements, ensuring the publication of user guides on Blue Web, a portal for project-related documentation and artifacts across the organization Presented Functional Specification Documents (FSDs) to plan users, addressing their queries and ensuring clear understanding of the requirements Actively participated in defect triage meetings to identify, prioritize, and resolve defects, ensuring timely resolution and minimal impact on project timelines Collaborated with the testing team to clarify requirements, analyze identified defects, and maintain a detailed defect log in Jira for efficient tracking and resolution Facilitated daily stand-ups and served as Scrum Master for a period, ensuring smooth team collaboration, timely issue resolution, and adherence to Agile practices Participated in SAFe Agile training with the product team and worked closely with the Agile Coach to implement best practices and optimize Agile processes Keywords: user interface business intelligence sthree information technology microsoft mississippi Virginia