Rahul Avvaru
Ashburn,VA
Summary
Experienced Information Technology professional with over 20 years in analyzing, designing, and testing data warehousing and web-based applications. Skilled in the Software Development Lifecycle, encompassing requirements analysis, data modeling, and system integration. Strong analytical capabilities and effective communication drive collaboration and adaptability in diverse environments.
Overview
1
1
Certification
23
23
years of professional experience
Work History
Project Manager
DHCF – DC Govt.
10.2022 - 05.2026
- Led large projects with diverse technical and non-technical teams, guiding them through deadlines, constraints, and release schedules to ensure timely delivery.
- Developed and maintained PMO documentation, including project charters, project management plan, and project communication, risk, and quality management plans to support project governance.
- Managed and coordinated project scope documents in collaboration with functional, business and technical stakeholders.
- Developed and monitored project schedules and communicated milestones from start to finish.
- Mapped and documented team-level process workflows to clearly define tasks and responsibilities with the goal to enhance team productivity, accountability, and collaboration towards shared objectives.
- Managed, and tracked on project RAID items by providing analysis and mitigation plans.
- Worked to foster open communication and cooperation among team members and documented lessons learnt after every release.
- Environment: IBM Curam, MicroStrategy, HP Exstream
Lead Business Analyst
Fannie Mae
01.2022 - 05.2022
- Analyzed and documented P2P (Path to Production) journey for Cloud assets under current governance framework.
- Collaborated with stakeholders to define and document checkpoints, findings, and permits for assets along development journey, enhancing clarity and compliance.
- Created and managed User Stories for key deliverables on Jira and reported on metrics and progress to leadership.
- Presented analysis on risk scoring and tolerance thresholds to stakeholders for agreement and sign-offs on various forum decision defining criteria.
- Collaborated with team and helped design an Aggregated Risk Framework scoring model to serve as a guiding post for Go/No Go decisions at the Cloud Governance Forum.
- Designed, documented, and socialized tools for forum, including templates, workflows, and training documents, improving operational efficiency.
- Facilitated identification and quantification of risks with SMEs for integration into Aggregated Risk Framework, strengthening risk management processes.
- Developed high-level requirements for compliance and monitoring reports for senior management.
- The Cloud Governance Forum was proposed to be established to unify stakeholder engagement and decision making by aggregating risk from across the product life cycle for all cloud assets. As a key member of team to operationalize the forum, duties included assimilating and implementing the key planned objectives and ensure smooth operations.
Sr. Business Analyst/Project Coordinator
Washington Metropolitan Transit Authority (WMATA)
Washington, DC
08.2017 - 01.2022
- Conducted current state assessments and documented future state recommendations with application/data architects to inform strategic planning.
- Collaborated with key stakeholders to define and document WMATA IT standards and product guide.
- Documented use cases and requirements for inter departmental application integration efforts involving Oracle SOA platform.
- Coordinated project plans, tracked milestones, and maintained progress reports, approvals, and workflows in IBM Jazz platform to ensure project alignment.
- Led requirements gathering session, user acceptance testing, and system acceptance with the client senior staff. Reviewed functional test cases and supported System Integration testing
- Worked on multiple integration projects including integration of PeopleSoft HCM with the Kronos Time Entry system, integration of the Bus Stop Maintenance portal with the GIS system and IBM Maximo.
- Created high-level and detailed business and system process flows along with functional requirements to support integration initiatives.
- Designed step-by-step processes for key SOA Standard Operating Procedures (SOP's).
- Participated in internal and external ISO audit review meetings and ensured project documentation met department guidelines.
Business Data Analyst
Freddie Mac
McLean, VA
02.2017 - 08.2017
- Collaborated with Primary Market Loan Application Provisioning Point (PMLAPP) team to map data between Loan Product Advisor and PMLAPP, ensuring data integrity and alignment.
- Working on developing mapping and business rules to convert the data from MISMO to CDM Standard
- Analyzed XSD schema file to create web service request and response attribute data mapping to Support development of SOAP UI responses.
- Validated the XML request and response data after the development to ensure it sticks to the XSD Schema.
- Developed a mapping document to connect user interface data points with back-end database, facilitating seamless data flow.
- Coordinated with business stakeholders and offshore developers during User Acceptance Testing phase to validate system functionality and user requirements.
- Environment: Java/JEE, SOA/Web Services (SOAP), Spring Framework, WebLogic, JMS, Visio, Solaris, Agile/Scrum, GIT, Jenkins, Maven, VersionOne.
Business Data Analyst
College Board
Reston, VA
04.2016 - 12.2016
- Designed and implemented processes, conducted data analysis and mappings to facilitate spring 2017 State Contracts implementation for CO, MI, OH, CT, and IL.
- Developed functional specifications and process flows to support State Contracts, streamlining operational business processes for successful SAT and PSAT implementation in spring 2017.
- Designed the functional requirements document for Test Materials Return process, Materials Ordering and Order Processing based on business requirements.
- Designed the process flows for Testing Centers to support virtual offsite testing locations for schools and Customer Service supplemental ordering process. Prepared the scope statement, process flow diagrams and the supplemental Bill of Material to support offsite testing
- Performed Data Cleansing, Data Analysis, data mapping and data validation to map states data to enrolment counts and order data for all the states, Spring break schools analysis, Implementation Planning kit orders, Offsite Test centers, back order analysis, district assessment coordinator analysis and Intent to Test Communications
- Performed user acceptance testing (UAT) for the Vendor ordering system and prepared its user guide.
- Environment: Informatica, Oracle 11g, Flux, RESTful Web Services, Cognos & UNIX.
Sr. UAT Analyst
Fannie Mae
Herndon, VA
07.2014 - 03.2016
- Analyzed and reviewed OLTP/OLAP systems, applied Slowly Changing Dimensions (SCDs), and developed E-R and dimensional models (Star and Snowflake) for LAI Data Model.
- Maintained Source to Stage and Stage to Target mapping document based on Facts & Dimensions and validated the Counts, Duplicates, & business rules to be applied on target tables.
- Continuously monitored the Business Data Glossary to ensure sync with the source to target mapping and transformations.
- Worked with the Reporting solution team to create the universe mapping document for the BOBJ reports.
- Created and published detailed statistics on ETL execution flows, controls and failures.
- Collaborated with Financial Controllers and IT teams to understand processes and data sources, identifying data populations to ensure accuracy and timeliness of report delivery.
- Conducted tests on complex Management, Analytical, Disclosure & Exception Business Objects reports, validating results using SQL queries on the database.
- Analyzed data flows and mapped ETL and reports for new Reporting Solution supporting rebuilt loan accounting capabilities to meet enterprise and regulatory needs.
- Environment: Oracle SOA, ABACUS, IBM Jazz, Visio, PeopleSoft HCM, ArcGIS
Functional Analyst
Federal Employee Program Operations Center (FEPOC)
Washington, DC
02.2011 - 06.2014
- As a functional analyst I was involved in the integration project designing business level process flows (and) solutions architecture to provide a seamless member experience across multiple related customer facing applications.
- Created functional specifications, use case, analysis and user interface specification documents
- Created an analysis document capturing the existing sign on behavior between the MyBlue portal and the Customer eService application.
- Worked with Medullan (vendor) to capture the user experience and business rules for MyBlue application.
- Documented the user experience and business rules for the Customer eService application.
- Compared the business rules between the MyBlue and Customer eService application and came up with a gap analysis document.
- Outlined user experience and process flow diagrams of expected system behavior, capturing all scenarios including member experience for single application registration (MyBlue/Customer eService).
- Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT)
- Handled defect meetings with UAT/Development during Plan Test (UAT phase).
- Extensively tested and analyzed daily usage logs and system events/alerts sent to external vendors for analytical reports.
- Designed risk assessment forms to evaluate and mitigate project risks.
- Convened JAD sessions with internal teams.
- Conducted weekly and monthly project status meetings, documenting and distributing meeting minutes to keep stakeholders informed.
- Developed training manuals for system configuration and maintenance, enhancing knowledge transfer for the TE team.
- Addressed inquiries from various BCBS Plans to clarify specifications.
- Environment: HP ALM, AbInitio, Informatica, SAP BusinessObjects, Netezza, Oracle 11g, Autosys, TIBCO GEMS & UNIX.
UAT Analyst
Fannie Mae
Herndon, VA
10.2005 - 12.2010
- Responsibilities include Business requirement Analysis, Use Case Preparation, Functional specifications, Data Mapping and change requests.
- Worked in various teams including FAS 91 Securities (System & UAT), Gfee, SCBSL (System & UAT) & EVLAS (Non-Performing Loans) application.
- Captured integration requirements for Evolv and company data systems.
- Validated Evolv reports in MicroStrategy, ensuring accuracy and compliance with business needs.
- Extensively tested Analytical & Business Validation reports in BOXI / Webi platforms.
- Automated the testing of ETL’s using UNIX shell scripts with embedded SQL and HTML reports.
- Executed tests on Ab Initio graphs to verify the ETL process.
- Validated interfacing with multiple systems including with external vendors including Bloomberg and Andrew Davidson.
- Designed, planned and validated Amortization schedules for Single Family and Multi Family loans.
- Worked with externally auditable forecasting models in generating Amortization schedules for Securities and Gfee items (Bloomberg and Andrew Davidson).
- Tested AM Interface for the Fair Value Hedge process.
- Worked on OMAS (Online Manual Adjustment System) and Accounting Model Reports.
- Created strategies to maintain SOX compliance for all UAT procedures and practices.
- Conducted Joint Application Development (JAD) sessions with stakeholders throughout SDLC to resolve open issues.
- Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met.
- Coordinated testing efforts in HP Quality Center, improving testing efficiency and communication among teams.
- Scheduled smooth ETL execution using Autosys.
- Fannie Mae is the largest institution in the secondary mortgage market serving to expand affordable housing and bring global capital to local communities in order to serve the U.S. housing market. As a Business Analyst in the Restatement Project we were involved in restating Fannie’s books according to federal and GAAP guidelines.
- Environment: AbInitio, ClearCase and ClearQuest, JavaScript, SQL/PLSQL, HTML, BOXI, Visio, Oracle 10g, Micro Strategy
QA Analyst
Freddie Mac
McLean, VA
07.2004 - 09.2005
- Worked in PE, OnTrac, MSOF, SS&TG and Single Family (SF) projects in Freddie Mac.
- Performed analysis of business requirements, identified gaps, and prepared test plans and test scripts.
- Documented and communicated issues and defects to enhance quality assurance of business applications.
- Worked extensively on translating high level Business Requirements to Use Cases & Functional specifications.
- Validated technical designs created by IT developers against functional specifications.
- Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).
- Documented Test Cases in Test Manager.
- Carried out execution of test cases to ensure software met specified requirements. and documented defects in ClearQuest.
- Facilitated daily triage meetings with business, development, and quality teams to prioritize and resolve issues effectively.
- Conducted Application Readiness Review meetings to evaluate potential risks before project implementation.
- Collaborated with QA and UAT teams to execute regression tests for system releases, analyzing and reporting daily test metrics to assess application stability.
- These Autosys jobs had embedded SAS programs to process monthly job runs.
- Freddie Mac is a giant in the secondary mortgage market with a mission to increase homeownership in the United States. As a Business Analyst, I worked on multiple projects across the company and was involved with Online Trading platforms (Trade Web), customized file comparison applications, accounting engines, pricing engines, data migration, data modeling applications and other Back-end systems.
- Environment: Rational ClearQuest, Rational Test Manager, Rational Rose, ClearCase, Robot, Mercury LoadRunner, DOORS 7.1, JSP, Java Script, WebMethods 6.1, Autosys, Crystal Reports 7. x/6.x, Visio, Sybase, DB2, OLE/ODBC, AIX and Mainframes.
Quality Assurance Analyst
Aetna Inc.
Hartford, CT
06.2003 - 04.2004
- Involved in Business requirement Analysis, Functional Requirement Preparation, Test script Preparation & analysis
- Formulated strategies to align QA practices with CMM level 2 compliance, enhancing consistency across all QA procedures.
- Developed QA procedures and policies for system design, evaluation, and reporting deliverables, improving overall quality assurance processes.
- Developed high-level test plans to verify functionality of the new system.
- Created a regression test suite in WinRunner.
- Executed test cases and documented defects in ClearQuest.
- Coordinated regression testing for each system release post-update, analyzing and reporting test metrics daily to ensure thorough verification of corrections and enhancements.
- Executed performance testing of the application with LoadRunner.
- Tested both user and server (Web and Mainframe) Environments.
- Trained and mentored new team members on the system
- Followed-up and verified defects with project managers and developers. Handled daily Triage meetings involving business, development and quality teams.
- As a Quality Assurance Engineer I was responsible for planning Acceptance and Integration test scenarios and scripts for Aetna’s Physician’s Web Site (PWS). The PWS allows healthcare workers to submit and to access real-time eligibility, referral and claim transactions and more. It also provides periodic reports on various transactions, which were till date only available only in paper format. The Website was developed using JSP/HTML, JavaScript and Servlets using Struts.
- Environment: Rational ClearQuest, Rational Test Manager, Rational Rose, ClearCase, Robot, Mercury LoadRunner, DOORS 7.1, JSP, Java Script, WebMethods 6.1, Autosys, Crystal Reports 7. x/6.x, Visio, Sybase, DB2, OLE/ODBC, AIX and Mainframes.
Education
M.B.A - IT & Finance
Missouri State University
Springfield, MO12-2002
Post Graduate Diploma - Computer Applications
Computer Maintenance Corporation Ltd.
Hyderabad, India12-1998
Skills
- Project management
- Project planning
- Project scheduling
- Project tracking
- Data analysis
- Data analysis
- Process Improvement
- Software lifecycle
- Systems implementation
- Database management
- Data Warehousing Tools: AbInitio, Informatica
- GUI/Tools/Others: Rose, ClearCase, ClearQuest, DOORS 96, Business Objects, Evolv 241/251
- Process Improvement
Certification
- EXIN Agile Scrum Foundation
- Scrum Alliance Certified ScrumMaster (CSM)
- Scrum Alliance Certified Scrum Product Owner (CSPO)
SPECIFIC EXPERTISE
- Excellent understanding of the Software Development Life Cycle
- Extensive experience in Risk and Quality Management, and developing Process improvement and governance practices.
- Experience in Financial, Insurance, Transit and government organizations
- Worked extensively on user requirements gathering, gap analysis, and development of functional specs.
- Excellent communication and interpersonal skills.
CURRENT LOCATION
Ashburn, VA
WORK STATUS
US CITIZEN
Timeline
Project Manager
DHCF – DC Govt.
10.2022 - 05.2026
Lead Business Analyst
Fannie Mae
01.2022 - 05.2022
Sr. Business Analyst/Project Coordinator
Washington Metropolitan Transit Authority (WMATA)
08.2017 - 01.2022
Business Data Analyst
Freddie Mac
02.2017 - 08.2017
Business Data Analyst
College Board
04.2016 - 12.2016
Sr. UAT Analyst
Fannie Mae
07.2014 - 03.2016
Functional Analyst
Federal Employee Program Operations Center (FEPOC)
02.2011 - 06.2014
UAT Analyst
Fannie Mae
10.2005 - 12.2010
QA Analyst
Freddie Mac
07.2004 - 09.2005
Quality Assurance Analyst
Aetna Inc.
06.2003 - 04.2004
Post Graduate Diploma - Computer Applications
Computer Maintenance Corporation Ltd.
M.B.A - IT & Finance
Missouri State University