SUMMARY

• Prashant Rana is a results - driven Project Manager/ Product Owner/ Business Analyst Professional with over 12 years of professional experience in the mortgage products, Mortgage products, Salesforce implementation Single and multifamily line of business, finance, wealth management and banking industries. He is a certified scrum master who has served in a product owner, Project Manager Role at Confidential and also held the title of agile coach on another project where he was working in 3 and 4 week sprints. He has experience in Agile framework, new product development, digital experience, Project Management, Customer Integration, Business Analysis, Quality Assurance, collaborative team building, handling multiple projects, streamlining processes, building and maintaining client relationships, full software lifecycles, ethics, resource management, metrics and reports development, and knowledge acquisition.

PROFESSIONAL EXPERIENCE

Confidential, Mclean, VA

Project Manager/Product Owner

• Working as Project Manager/Product Owner with mortgage PMO
• Increased the mortgage/Heloc sales to 250 million by successfully implementing new loan application system on Elliemae loan origination system
• Designed new mortgage products and successfully implementing new products
• Working on integration projects with Elliemae Encompass as the Loan origination system
• Design new processes for the mortgage PMO
• Working on Encompass digital lending platform enhancements
• Re-deigned member digital experience on Mortgage products
• Working as a product owner on sales force CRM for one stop solution for all the lead management
• Implemented chat bot and live chat for Salesforce CRM
• Working on Salesforce Einstein for data analytics and machine learning( NLP)
• Working on integration for penfed outlook and calendar scheduler via penfed.org with salesforce
• Working on Loan beam integration for automatic income verification for loan applications
• Creating weekly dashboards for the leadership
• Mentoring new hires and coaching them
• Part of resource planning
• Working on vendor integration and vendor management

Confidential, Mclean, VA

Project Manager/Business Analyst

• The Investor Reporting Change Initiative converts Single-Family investor reporting requirements to be closer to an industry standard and update our remittance cycles. The initiative will also help support the disclosure and buyout requirements of the upcoming Single Security.
• Working as a project manager/project coordinator on IRCI project
• Worked on Freddiemac asset management products, consent tracker
• Working on major areas of the project such as customer integration, UAT, end to end testing Pre-IRCI conversion project and servicer performance metrics
• Extensively engaged with SME’s on customer guidance documentation
• Engaged with legal and compliance divisions for IRCI changes TOB and policies for conversion project
• Created external communication documentation to be published as a servicer guide on FM external site
• Worked on release plan for pre IRCI deployments for the identified customers
• Created customer guidance documentation for IRCI cutover activities
• Published guide bulletin on FM external site
• Developed strategy/approach for internal and external customer training using presentations and webinars
• Responsible for weekly dashboard to be reported to PMO on project progress
• Single POC from business side for End to End testing
• POC for operational controls and sox testing
• Coordinated end to end testing and controls testing for single family business
• Lead the UAT effort from business side

Confidential, Atlanta, GA

Project Manager/Business Analyst

• Worked to achieve objectives of SunTrust by working with their highly experienced Client advisors and private financial advisors. SunTrust performance management team measures the productivity of the advisors on several key financial metrics.
• To measure the performance of advisors across the investment products SunTrust initiated a project to create a self-service portal where key performance data can reside, and performance management team can create ad hoc and canned reports for the senior leadership.
• I was part of an Agile Implementation for Data self-serve portal for SunTrust PWM Division as Agile Business Analyst Consultant
• Coached team of business executives and technical professionals regarding Agile roles, routines and responsibilities resulting in a more thorough understanding of Scrum/Kanban and a faster start up time to developing software
• Interviewed senior leadership, SME’s to understand key metrics and KPI’s for private wealth management advisors
• Documented, coached, and elicited business requirements from subject matter experts by writing user stories resulting in a clearer, more detailed and more complete understanding of project deliverables
• Engaged in defining new processes to increase the productivity of performance management team
• Identified manual reports to be automated which were produced manually by PWM division
• Report automation increased the productivity of PWM division
• Performed gap analysis for PWM data requirements for self-service portal
• Performed data analysis for PWM data requirements
• Created Test Strategy, Test Scenarios and Test Cases documents for integration testing
• Created UAT test scenarios and Test Cases and executed them with the business
• Trained PWM division on the new dashboard (Self-service portal) for reporting purposes
• Environments & Tools: MS Visio, MS-Word, MS-Excel, MS-PowerPoint, MS-Outlook, HP ALM 11.0, Toad, QlikView, Microsoft SQL Server 2012

Confidential, Washington, DC

Lead Business Analyst

• Interacted with Business SMEs and financial officials from IFC for understanding and analyzing requirements for the loan’s operations and financial products
• Gather requirements from Product Owner
• Created Product Backlog, Sprint Backlog and managed User stories
• Led daily stand-up meetings
• Strong understanding of loan operations and trust funds
• Analyzed high-level Business requirements created functional requirement for the project
• Led strategic transformation initiatives
• Performed the role of SPOC for business stakeholders, developers and testing team
• Established training needs and organizational readiness to manage the ‘to be’ processes
• Managed the complete life cycle of the enhancements to be implemented
• Developed UAT test plans, test scenarios and, test cases
• Ensured creation of all the business related and testing related artifacts are created and delivered within the project timelines
• IFC FSRS project is a system designed analysis of financial sustainability based on time and effort management for Confidential employees.
• Worked as a business analyst working directly for the requirements gathering sessions.
• Worked on documenting requirements for employee time management as per the user requirement
• Involved in testing the application
• Created data flow mapping documents for the employee time management system

Confidential, Mclean, VA

Lead Business System Analyst

• Engaged in the project from initiation phase
• Followed Agile/Scrum iterative approach for the project
• Excellent knowledge and understanding of Multifamily loan underwriting process for multifamily cash and bond loans
• Performed reverse engineering on Legacy application for VB and Java applications
• Worked with business and SME’s and documented requirements for all VB and Java Legacy applications
• Worked with SME’S for creating process model and requirement gathering for new enhancement projects
• Documented AS-IS and TO-BE models to identify the Business Requirements and future state of the Applications
• Worked on the impact analysis on upstream and downstream applications
• Developed UAT test plans, test scenarios and, test cases for
• Ensured creation of all the business related and testing related artifacts are created and delivered within the project timelines
• Introduced baseline testing
• Defined SIT test strategy and guided SIT team to performed Baseline and SIT testing
• Performed internal and external quality audits for the artifacts
• Developed RTM’s for ensuring 100 % coverage of the requirements for development, testing and implementation

Lead Business System Analyst

• Thorough understanding of mortgage, loan industry
• The project called as Alternate loan modification program follows Agile methodology for the development
• Met all the time lines for each iteration which was of four weeks and included development, testing, deployment
• Attended daily standup meeting for status update
• Actively participated in project timeline estimation
• Documented user stories by interviewing with the business on daily basis
• Analyzed user stories for acceptance criteria
• Actively performed estimation for development, functional testing, Regression testing, UAT timelines
• Developed UAT test plans, test scenarios for the ALT MOD project
• Developed and executed test cases for each iteration
• Developed RTM for requirements mapping
• Environments & Tools: MS Visio, MS-Word, MS-Excel, HP ALM 11.0, IBM Doors, Rapid SQL

Confidential, Milwaukee, WI

Lead Business Analyst

• Roundy's Supermarkets (Roundy's) is a Milwaukee, Wisconsin-based supermarket chain with 154 stores in Minnesota and Wisconsin, and 4 stores in Illinois, with estimated sales of $3.9 billion. Roundy's has undertaken transformation journey from wholesaler to a retailer and as part of this transformation wants to enhance operational efficiency of its Pharmacies. These pharmacies run on a mix of three pharmacy dispensing applications, resulting in maintenance and data inconsistency issues. This leads to customer dissatisfaction and operational losses (actual as well as loss due to missed opportunities). To overcome these issues, Roundy's has undertaken the task of modernizing its Pharmacy dispensing/management application. To this effect, it has identified Enterprise Rx (ERX) from McKesson that meet Roundy's criteria.
• Facilitated requirement gathering sessions with the Business Users, Project Manager and SME’s to get a better understanding of the Business Processes.
• Conducted JAD/JAM Joint Application Development/Modeling) sessions with the Business Users, Stakeholders to identify the future system requirements.
• Designed/modified Functional requirements documents.
• Designed user requirements, attended periodic meetings for changes in the application requirements and documents.
• Prepared Requirement Traceability Matrix for the application.
• Worked closely with user team and understood the AS-IS and TO-BE models to identify the Business Requirements.
• Worked as a Sr. I T Analyst with Roundy’s Inc. for Implementation of Enterprise Rx Pharmacy system
• Created Business requirement documents for Roundy’s Specific requirement
• Conducted JAD sessions with stakeholders to elicit requirements
• Conducted interviews and questioners to gather requirements
• Created test strategy document for UAT
• Created test data to test the Enterprise Rx Pharmacy system
• Complete understanding of revenue cycle from patient intake to payment posting
• Worked with PBM (Pharmacy Benefits Managers) for claims
• Performed User Acceptance Testing to ensure that all business expectations are achieved within
• Performed data validation for converted data from legacy system to Enterprise System
• Successfully implemented Enterprise Rx System on five Pilot stores in a timely manner
• Environment & Tools: MS- Word, MS-Excel, MS-Project, J2EE, SQL, WIN GPG, MS-Visio, MS - SharePoint

Confidential, Pasadena, CA

Senior Business Analyst

• Confidential Permanente is a 44 Billion revenue company and they have taken an initiative to implement Enterprise Pharmacy System by PDX Inc. Confidential ’s major part of the revenue for Pharmacy business comes through KPHC known as Confidential Pharmacy health connect.
• This project known as OPPR (Out Patient Pharmacy Record) is the initiative to automate the process of Enterprise Pharmacy System for Confidential Permanente serving more than 8.9 million end users further for their healthcare and pharmacy need.
• Worked as a Business Analyst for interaction between Business Users, stakeholders, testing team, offshore team
• Involved in performing BAT (Build Acceptance Testing)
• Worked on onsite offshore model for implementation and support of Enterprise pharmacy system
• Worked on core functions of the health system's Revenue Cycle applications to enable cost-effective, high quality, efficient, and safe patient care
• Trained offshore team on various modules, processes of Pharmacy and health care
• Trained offshore on executing the test cases
• Created RACI document for the EPS project
• Created complete process flow to resolve tickets in pre-production and production
• Actively participated with the business user in training environment to train the Pharmacist on the EPS application
• Worked with Business users and key stakeholders directly in understanding the user stories and share the same with offshore team to create test plans and test cases
• Worked on user stories to create test plans and test cases
• Executed test cases in end to end testing

Confidential, Woonsocket, RI

Business Analyst

• Worked as a Senior Business Analyst with Confidential Caremark
• Followed evolutionary methodology for the entire project life cycle
• Created business requirement documents for the project
• Worked with the onsite and off shore team during the development phase to understand the business and technical requirements for the Rx connect project
• Participated in meetings with clients, development team to finalizing the requirements.
• Participated in team meetings for the design phase once the requirements were freeze
• Participated in user acceptance testing
• Creation of test cases, test scenarios, and test data

TECHNICAL SKILLS

Methodologies and Concepts: Agile / Scrum, RUP, Waterfall, UML, Interactive

Requirement Management: IBM Rational Requisite Pro, IBM DOORS, HP ALM

Version Control/Change Management Tools: IBM Rational Clear Quest

Business Modeling Tools: Microsoft Visio

Repository Tools: IBM DOORS, Microsoft SharePoint

Testing Tools: HP ALM, JIRA

Project Management: Microsoft Project, Microsoft Office / 2003

Operating Systems: MS-DOS, Windows95 / 98 / NT / / XP, 7, UNIX, Linux

Languages: C, C++, Java, SQL, PL / SQL, HTML. .Net, VB

Pharmacy Systems: PDX (PDX Inc. ), EPS (PDX Inc. ), Enterprise Rx (McKesson), Pharmaserv

Other: Adobe Photoshop, Adobe Acrobat, Crystal Reports, HIPAA, Remedy, Putty, WINSCP