SUMMARY

• 7+ years of Industry experience as a Business Analyst with solid understanding of business requirement gathering and data management
• Diverse experience in Banking (Credit, Liquidity & Market Risk) and Healthcare domain
• High level of expertise in all phases and methodologies of Software Development Life Cycle (SDLC) including Waterfall, Agile/Scrum
• Extensive experience in Business Process Modeling using Visual modeling tools and UML Modeling like Activity Diagrams, Sequence Diagrams, Use Case Diagrams, Process Workflow Diagrams, Interaction Overview Diagrams, Timing Diagrams, and Class Diagrams
• Expertise in creating project artifacts such as Business Requirements Document (BRD), Use Case Documentation, Requirements Traceability Matrix (RTM), Business Rules Spreadsheet (BRS), Functional Requirements Document (FRD), Data Mapping Document, Systems Requirements Specification (SRS), and GUI Mockup Screens
• Expertise in Project Management, i.e., Project Scoping, Planning, Estimating, Organizing, Directing, Budgeting and Drafting Remedy Procedures
• Excellence in Analysis, Design, Development, and Implementation of ETL and reporting components
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies
• Involvement in Data/Dimensional Modeling, Data Extraction/Transformation/Loading (ETL), Data Privacy, and Business Intelligence Reporting using Tableau
• Coordinated with architects in various architectural designs like conceptual design and logical design
• Proficient in conducting Requirement Gathering Sessions like Joint Application Development (JAD), Joint Requirement Planning (JRP) and Interviewing Stakeholders with superior organizational and presentation skills
• Worked closely with Stakeholders, SMEs and Staff to understand and document Business, Functional and Software Requirements
• Executed many projects from scratch to deployment phases across diverse domains
• Skilled in conducting GAP Analysis, SWOT Analysis and Cost Benefit Analysis
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are adhering to business requirements
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases.
• Expertise in designing and developing Test Plans and Test Scripts

PROFESSIONAL EXPERIENCE

Sr. Business Analyst

Confidential

Responsibilities:

• Conducted requirement gathering session with multiple stakeholders from Global Market Credit, Credit Risk management department
• Created Business requirement document based on the requirement gathering sessions
• Transformed business requirements into functional requirements / specification document
• Worked with various data vendors such as Bloomberg, Electrum, Z inc and Wholesale Credit Systems to procure EOD transactional data on daily basis
• Worked with internal reference data vendors to receive reference trade and lending data
• Assisted in performing data extract, transformation and loading the Wholesale data covering Trading and Lending Products into Risk environment
• Performed extensive GAP Analysis to identify data issues
• Performed System integration Testing & Unit Testing
• Coordinated with the Stakeholders and assisted in performing the User acceptance testing
• Ensured by working with the developers to make sure data warehouse complies with the Enterprise Data Management (EDM) policies and standards
• Created Dashboards (Using Tableau) to report the Direct and Indirect Exposure for the bank through an automated process
• Developed regression test scripts to ensure data validation is performed in an automated manner
• Worked on risk trends predicted by the bank thereby converting billions of user records into business decision making predictive models and showcasing them in Dashboards (Using Tableau)
• Assisted project managers with the development of project schedules

Environment: MS Visio, Agile/Scrum Methodology, MS SharePoint, Toad for Oracle Data point, Tableau, JIRA

Sr. Business Analyst

Confidential

Responsibilities:

• Conducted requirement elicitation sessions with multiple stakeholders from Treasury and Capital Markets department
• Gathered business requirements to ensure Loans, Deposits, Credit Cards, Payments, Derivatives and HQLA data pertaining to the bank are captured
• General Ledger data, Foreign Exchange transactions data, Loan data, Deposits data, Derivatives data, Account settlement data has been extracted, transformed and loaded to calculate LCR
• Participated in the logical and physical design sessions
• Worked closely with the developers and testing team to ensure the business requirements are transformed into real time application
• Performed Unit Testing and System Integration testing of the LCR engine

Environment: MS Visio, Agile/Scrum Methodology, MS SharePoint, SQL Navigator 5.1.1, SQL Server 2003/2005

Sr. Business Analyst

Confidential

Responsibilities:

• Worked with the business unit to define business requirements and analyze the possible technical solutions
• Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring, and Asset Management
• Articulated business requirements from User interviews and brainstorming workshops, and then converted requirements into Technical Specifications from developers
• Documented business artifacts utilizing industry best practices to ensure usability, scalability and maintainability
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration diagrams
• Collaborated with development architect and the business to develop both high level and detailed application architecture to meet the business needs
• Participated in the logical and physical design sessions
• Helped the testing team documenting the system requirements and testing system development
• Designed screen mockups for changes in system functionality using iRise, MS Visio and MS Paint
• Coordinated with development team to help them better understand the requirement and corresponded management of project on MS SharePoint

Environment: MS Visio, Agile/Scrum Methodology, MS SharePoint, SQL Navigator 5.1.1, SQL Server 2003/2005, Toad for Oracle

Business Analyst

Confidential

Responsibilities:

• Understood and assessed the current EDI Transactions used and the existing Pharmacy Transactions from an NCPDP 5.1 perspective
• Created standards/guidelines for Business Process Modeling, Use Cases, Workflows, Data Dictionary and Requirements Specifications
• Mentored end - users on requirements specifications techniques and the software development life cycle
• Assisted with building the EDI 837(I, D, P), 835, 277-U, 270/271, 276/277, 278, 820 and 834 transactions processing flow from the Trading Partners to the translator
• Scheduled meetings with technical personnel to determine technical parameters for EDI and other related processes including communication, security, and privacy. Created transaction sets requirements, usually with MS Excel for transactions such as HIPAA 270/271, 276/277, 835, 837-(I, P, & D), 835 Remittances and others.
• Resource for UB92 and HCFA1500 billing format, transaction sets requirements, EDI development and Design, X12 protocols through Version 4010 A1 and newer, conversion needs and understanding of legacy EDI formats, such as UB92 Versions 4, 5, 6 and NSF
• Gathered and analyzed requirement for ICD 9 to ICD 10 changes
• Involved in up-gradation of HIPAA X12 4010 transaction to HIPAA X12 5010 and ICD 9-CM (Clinical modification) to ICD-10-CM/PCS (Clinical modification/procedure coding system) simultaneously
• Converted the Business Process Requirements (BPR) into System Specification requirements
• Created various Use Cases and Workflow Diagrams, Sequence Diagrams, and Class Diagrams using MS Visio and used UML methodology to define the Data Flow Diagrams (DFD)
• Maintained Traceability Matrix in Excel
• Used IBM Rational ClearQuest as Version Control/Change Management Tools
• Created requirements analysis and design phase artifacts using Requisite Pro and MS Visio

Environment: MS Office Suite, MMIS, POS, GEMS, Document Analyzer, SharePoint, XML

Business Analyst

Confidential

Responsibilities:

• Gathered the business requirements from stakeholders and users by meeting them personally and by interviewing them. Utilized Requisite Pro to prepare a BRD by complying with the HIPAA regulations
• Developed functional specs, gathered requirements and communicated with the developers
• Developed Use Case Diagrams, using ERD depicted clear relations associated between the entities
• Prepared Work Breakdown Structures (WBS) to comply with the triple constraint; time, cost and scope
• Prepared a roadmap for a product that can exceed market and user expectations
• Followed Prototype model of SDLC in developing software
• Designed User Interfaces and mock-up screens using HTML to validate the requirements
• Created and implemented a Test Plan and thereby assisted Quality Analysts to test the product
• Interacted with Quality Analysts for Unit, Integration, System and User Acceptance Testing
• Communicated with top management to ensure IT initiatives and involvement are clearly understood
• Mitigated risks all the time; motivated the team members to meet the deadlines
• Reviewed and analyzed the business environment and identical process improvements
• Evaluated alternative solutions and recommended solution that best meet the needs of the business
• Defined and planned software releases in accordance with other software applications

Environment: MS Visio, MS Office Suite, .Net, VB.NET, ASP.NET, Java, PHP, XML, HTML, DHTML