Nirajan Rimal

Summary

An experienced Business Analyst with over 8 plus years of recognized success in Business Requirement Gathering, Data Analysis, Data Modeling, Warehousing and Business Process Modeling. Exceptional skills in delivering results in demanding corporate environments.

Skills:

Specialties: Business/Technical Analysis and Documentation, Data Analysis, Data Management/Governance, Process Engineering, Regulatory Reporting, Data Mapping, Change Management, SDLC

Processes/Technologies: Agile Scrum, Rational Unified Process (RUP), Waterfall, Use Cases and Workflow

Application Management Tools and Partner Systems: Jira, Confluence, TFS, Azure DevOps, Microsoft Dynamics CRM 365, Tableau, MS Project, Balsamiq

Productivity Software: Microsoft Office (2003, 2007, 2010, SharePoint, Access, Excel, Power Pivot, Power Point, Word, Visio, Outlook)

Relational Databases: MS SQL Server, Oracle, MS Access

Operating Systems: Windows NT/2000/2003/XP/Vista, Unix

Quality Assurance Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, Quality Center, Rational Functional Tester

Languages: JAVA, C#

Professional Experience

Wells Fargo, Des Moines, Iowa Business Systems Consultant January 2019 - Present

Managed/monitored individual merchant services products throughout their Software Development Life Cycles (SDLC), supporting the product’s development process and executing cost-effective, quality product strategies to contribute to profitability and growth.

Worked closely with various teams including product, platform, operations, IT and various lines of business to help define, design, and document both Functional Specification Document (FSD) and Business Requirement Document (BRD) in support of Wells Fargo Merchant Services and partnerships that delivered business solutions to market.

Created and prepared documents including presentations, procedures and process flows pertaining to project’s key milestones leveraging tools such as Microsoft PowerPoint, Visio, and Project for socialization amongst stakeholders and distribution to business leaders.

Collaborated cross functionally with Enterprise BSA/AML Analytics team, Product Owners, Legal to implement businesses risk-based controls associated with KYC/CIP/CDD policy.

Assisted Technology Team leaders in Project Sizing in a multi project environment accounting for duration, cost, complexity, plans, and activities are relevant, and that resources are properly used and allocated.

Handled data modelling with the design of new databases to meet application requirements; supported design and implementation of ETL processes between disparate systems.

Kicked off, architected, and lead data integration projects between .NET and Microsoft Dynamics CRM 365 systems, documented current and future data requirements via comprehensive overview of data content, quality, structure.

Lead an initiative enhancing the overall CRM lead referral process by restructuring the lead routing workflow to properly funnel leads through Sales Channels for successful customer onboarding.

Lead, defined, maintained requirements and data mapping for an API project called Data Queuer that tied communications between in-house applications.

Played a key role in introduction of a new Business Process Flow to penetrate B2B and B2C market from initiation to its successful implementation.

Collaborated with Technology Manager, Infrastructure Manager and Operations to successfully phase out manual customer onboarding process to digital resulting in the improvement of turnaround time for customer onboarding.

Supported User Acceptance Testing (UAT) efforts to independently validate the changes and support defect-free implementation of the changes to production environment.

Developed and delivered reliable, scalable, and efficient reports, trends, and key insights to senior leadership utilizing custom CRM reporting function.

Fannie Mae, Reston, Virginia Senior Business Analyst

June 2016 – December 2018

Facilitated Joint Application Development (JAD) sessions, gathered business requirements using interviews, document analysis, requirements workshops.

Analyzed current and future compatibilities and workflow of inhouse applications by interviewing analysts, users at all security levels and security support teams.

Facilitated Product Backlog Grooming sessions, utilized JIRA and Confluence to write User Stories, Acceptance Criteria and High-Level Requirements in support of the Agile Scrum team.

Assisted Infrastructure team in Data Integration project between Sybase and Dynamics CRM systems utilizing Scribe.

Coordinated with AML Analysts to determine businesses adherence to the US Patriot Act, BSA and KYC regulations, focusing on businesses AML policies and procedures.

Assisted application analysts, system managers and departmental leads to create resource documents essential for successful EPIC implementation.

Interviewed end-users to understand IT complexities regarding application workflow changes and created job aids to help mitigate discovered complexities.

Conducted comprehensive product training sessions and software demonstrations for Internal departments/teams and core users.

Built SharePoint content utilizing SharePoint Designer for best practices and lessons learned to improve efficiency of the team’s SDLC process.

Created process flow diagrams for TO-BE process flows and AS-IS process flows utilizing Microsoft Visio.

Maintained project visibility to leaders and stakeholders through SharePoint documentation, MS PowerPoint and MS Project providing real-time statuses on project’s key milestones.

Designed and developed project templates based on SDLC AGILE Methodology including Business Requirement Document (BRD), Functional Specification Document (FSD) and Project Intake Request.

Performed Data Validation and functionality Testing on OOB (Out of Box) solutions implemented in Microsoft Dynamics CRM 2013 against requirements and business scenarios.

Zion’s Bank, Salt Lake City, Utah Business Analyst

October 2014-May 2016

Analyzed existing credit card processing system, mapping phase according to functionality and data conversion procedure.

Performed Gap Analysis to examine the compatibility of the existing system infrastructure against new business requirements and advised appropriate solutions.

Worked as a Business Analyst to manage & deliver various CRM projects that incorporated scoping, resource planning, and process definition.

Interacted with SMEs of different divisions (Information Technology, Risk and Operations) and helped establish a new SDLC process modeled after the RUP (Rational Unified Process).

Utilized SharePoint for Document Management and Dimensions for version control.

Worked with cross-functional teams including subject matter experts from various departments and conducted gap analysis, requirements gathering sessions and documented business needs in the form of Business Requirements Document (BRD) and Functional Specifications Document (FSD).

Planned, implemented, and supported small and medium scale SharePoint 2007 and 2010 solutions deployments and post release monitoring.

Planned and created SharePoint 2007 and SharePoint 2010 Workflows.

Created Custom Forms using InfoPath 2007 and 2010.

BCBS Dallas, Dallas, TX Business Analyst

June 2012-September 2014

Gathered requirements from clients and developed crosswalks for 820, 834, 835, 837 P/I claim.

Assisted Project manager and BA Manager for project intake, cost estimation, approval, and funding.

Developed test cases based on crosswalks and compliance guidelines for 270/271, 276/277, 820, 834, 835, 837 Professional, Institutional and Dental claims and 270/271 eligibility, benefit inquiry and response.

Set claim processing data for different Facets Module.

Designed and overlooked the implementations of HIPAA 835 Payment Advice Transaction, 837 Health Care Claim Transaction processing solutions.

Populated ICD-9-CM, EDI X-12 transaction sets 835, 837, 270, 271, 276 and 277 responsible for Claims processing, coordination of benefits and pricing process.

Designed, analyzed, and performed Integration and System testing on industry leading health care software such as FACETS, MedPlus and QNXT’s software components under one complete system.

Assisted testing team in validating technical designs created by IT developers against functional specifications.

Collaborated with the QA team to design test plans and test cases for User Acceptance Testing (UAT).

Ally Bank, Charlotte, North Carolina Business Analyst

June 2011-May 2012

Conducted one on one interviews with the Portfolio Manager to gather Business Requirements and assisted documenting Business Requirement Documents (BRD) and Functional Requirement Documents (FSD).

Effectively communicated with the Project Manager, senior business management and project sponsors to identify and prioritize requirements, articulate business impact, and evaluate business solution options.

Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plans, Business Processes and Products helping implement enhanced processes, products, and solutions.

Managed the overall coordination, status reporting and stability for the business side of project-oriented work efforts.

Assisted implementing a new workflow automating communications to customers for customer profile data updates to enhance LOB’s communication standards.

Collected business requirements and created mapping documentations to set well defined rules for successful data migration from Data Source to Data Target in various Data migration projects.

Developed and maintained reporting utilizing MS Excel queries, SQL in Teradata, and MS Access.

Documented team procedures and created team support process model.

Education

Bellevue University, Bellevue, NE

Bachelor of Science – BS, CIS/Business Intelligence, Bellevue University, NE, 2011

LinkedIn:

www.linkedin.com/in/nirajanrimal

Activities and Societies:

Travel and Culture, Football

Contact this candidate