SUMMARY

• 7+ years of professional experience as a Business Systems Analysis in Finance and Banking with Expertise in Documentation, UAT and requirement gathering from various applications.
• Worked with Solution team and provided technical support and closely with Functional lead and SME. Always updated the project manager and Functional lead about user issues also help the user.
• Experience in business requirements elicitation, development of technical specifications, change management, gap analysis, risk management, troubleshooting, Compliance and issue resolution. Experience working with vendors and consultants in various systems and interface related enhancements.
• Experience in reviewing key development and design deliverables, including interface specifications, integration requirements, data schemas, and design documentation.
• Strong experience in requirements gathering, analyzing business processes and requirements, creating ETL interface specification and technical design documents with led facilitated workshops and Joint Application Development (JAD) sessions to refine requirements.
• Experience in creating reporting solutions using Teradata Views, Macros, Excel functions, Excel graphs and Pivot tables
• Strong experience in RUP Business Modeling process. Extensive experience in analyzing and requirements gathering and writing business functional specifications including use cases.
• Experience in Creating Production Support Handbooks as part of the Case Management initiative for various Vendor Systems to provide Level 3 Support.
• Good in Computer Systems Validation as well as Internal Audit and Compliance.
• Experienced in techniques such as SPRINT planning, Product Backlog management, Agile estimation, daily Scrum, metrics such as Burn - down & Velocity charts, Sprint summary report, Sprint review/retro meetings etc.
• Good experience in working with multiple teams on different levels of Scaled Agile Frameworks (SAFe).
• Worked closely with audit and compliance team to ensure IT and SOX compliance is covered
• Comfortable in working with different requirement gathering techniques like Brainstorming, JAD sessions, Focus Analysis, Reverse Engineering, Survey, Document Analysis, Interview, Prototyping and Observation
• Strong experience in using Tableau Prep, Advanced MS Excel to analyze the data based on business needs.
• Efficient in writing Business Requirements Document (BRD), Functional Requirement Document (FRD), Use Case Specifications, Functional Specifications and Workflows.
• Experience with Agile techniques: User Stories, TDD, BDD, Continuous Integration, Continuous Testing, Continuous Delivery, Automated Testing.
• Excellent in performing GAP analysis (AS-IS, TO-BE Processes) to check the compatibility of the existing system Infrastructure with new Business Requirements.
• Facilitated User Story grooming session with Development team and documented user stories and acceptance criteria for the team product backlog in JIRA.
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Hands on experience with UML, Use Case Modeling, Swim-lanes, Entity Relationship (ER) Diagrams, Conceptual Diagrams and Requirement Traceability Matrix.
• Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
• Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Extensively worked within varied sectors of the healthcare industry including HMO, PPO, POS, Medicaid, Medicare, Integrated Hospital Systems, Out-Patient Surgery Centers, Dental and Vision.
• Professional experience in business analysis, operations management and development, design, documentation and testing.
• TEMPEffective in executing multiple tasks and assignments ahead of schedule. Created and maintained TEMPeffective budgets.
• Good Communicator, Team Participation skills, Leadership qualities, Analytical skills

TECHNICAL SKILLS

Database: SQL, Oracle, MS Access

Project Management Tools: Microsoft Project, Excel, Word, PowerPoint, JIRA, Axosoft

Modeling and Design Tools: Microsoft Visio, InfoPath, Smart Draw, Wireframe Sketcher

Business Intelligence Tools: Excel, Tableau, SQL Server

Operating Systems: Macintosh, Windows, Linux/Unix

Business Skills: SDLC, Agile, Waterfall methodologies, Requirements gathering, Team management and Documentation.

PROFESSIONAL EXPERIENCE

Confidential, Whippany, NJ

Sr. Business System Analyst

Responsibilities:

• Involved throughout the Software Development Life Cycle, (SCRUM) including sprint planning meetings, review meetings and backlog refinement meetings. Managed Loan Origination Software (LOS) implementation projects with clients. dis included analysis of the client’s business processes, IT networks, and loan documents.
• Work with PMO on Change Management and Governance to ensure project is designed and managed successfully. Follow Change Control submission and approval processes. Manage standard project risks and issues, develop mitigation plans.
• Thorough noledge on POS & LOS workflow within the Origination & Downstream systems supporting Servicing & Scalability.
• Managed technical and multiple lines of business resources for AFS Commercial Loan System, Data Warehouses and Client digital website which helps in migrating to Loan IQ.
• Work with PMO to get the required resources to implement the project. Monitored & track portfolio performance of key Mortgage Banking products & markets..
• Facilitated weekly status meeting(s) with client to coordinate and guide them through the software implementation process. Coordinated with client and internal team members during these meetings to keep status updated and to ensure tasks are completed timely. Acted as liaison to client for product issues during implementation of LOS (Loan Origination System).
• Spearheaded numerous JAD sessions, provided insight to clients on existing case management functionality and how dis functionality would fit identified requirements.
• Worked closely with Data Architects and ETL Leads/Managers and was responsible to perform detailed data Requirements Analysis and create design specifications and operational documentation.
• Worked with a team of ETL interface developers in the design, create and unit test interface code in XMS.
• Applying triage, research, collaboration and technical noledge to resolve transaction and processing issues with the use of supporting technology such as work flow management systems and case management software.
• Worked in mainframe environment and used SQL to query various reporting databases.
• Involved in GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims.
• Involved in writing SQL queries, subqueries and joins to extract data from various source systems.
• Involved in Data mapping specifications to create and execute detailed system test plans.
• Designed & developed various Ad hoc reports for different teams in Business (Teradata and Oracle SQL, MS ACCESS, MS EXCEL)
• Incorporated Agile SCRUM methodology to create business requirement document specifications utilizing MS Visio and MS Word. Developed Use Case diagrams, business flow diagrams, Activity/State diagrams and Sequence diagramsso dat developers and other stakeholders can understand the business process.
• Participated in implementation day “go-live” activities, including post-implementation testing, evaluation, troubleshooting and reporting. Develops a variety of technical and project related documentation including technical manuals, user guides, as well as project management life cycle and software development life cycle
• Created pivot tables in Excel by getting data from Teradata and Oracle.
• Coordinated and updated status document with Project Managers and Senior Level Management to identify the issues and assist to streamline various processes through the use of better manual processes and the creation of automated straight through processes. Responsible for the analysis and evaluation of user business problems and development of system recommendations to meet requirements. Translates high-level business requirements into functional specifications for business application development. Interviews end users to obtain and document the detailed business requirements for projects. Assists in the business process redesign and documentation as needed for new technology. Combines understanding of IT and business processes to recommend solutions.
• Gathered requirements and modeled the data warehouse and the underlying transactional database.
• Gathered requirements from the stakeholders and created BRD.
• Used JIRA to maintain product backlog and sprint backlog and to create and track user stories, Sprint planning, tracking and managing sprints, created Scrum and Kanban boards, status reports and burn down charts.
• Created Process flow diagrams to give overall understanding of the process and system changes to Business and Technical team.
• Assisted the Technical team and provided them clarifications based on business requirements.
• Provided analysis and insight to QA Team in defects and bugs tracking
• Used UML to design various data models including data flow diagrams, work flow diagrams and interaction diagrams.
• Created Excel reports pulling data from SQL Server database.
• Wrote SQL scripts for creating performance evaluation reports.
• Used MS Visio to create use case diagrams, sequence diagrams and activity diagrams

Environment: Agile, SDLC,MS Office Suite(Excel, Word, PowerPoint) SQL, UML,MS Visio, RUP, UAT, Rational Rose, Crystal Report, Rational Clear Quest, Rational ClearCase, Jira, SQL, ETL,Oracle, Rational requisite pro, TDD, SAAS, rational test manager

Confidential, Chicago, IL

Business Systems Analyst

Responsibilities:

• Worked with different IT Business groups to understand and determine the Impacts to the Data Warehouse and/or Data Marts for different projects
• Extensively involved in project documentation including but not limited to, Software Requirement Specification SRS, Detailed Systems Design DSD Document, Use Cases, User Interface Specification, Report Specifications, Letter Specifications, etc.
• Helped to resolve critical control and operational weaknesses, identified problems, recommended improvements and worked in collaboration with middle office, Risk and Finance to implement issue resolutions.
• Plan, design, test, document, and implement various updates for Consumer Lending LOS (LoansPQ).
• Utilized Commercial Lending Banking application and responsible for the design and process flow of the system. Analyzed and translated business requirements into system specifications utilizing UML and Agile/ Scrum methodology.
• Supported the Consumer Lending Department in detailed planning with Project Management for upgrades/disaster recovery tests.
• Gathered Business Requirements, interacted with the Users, Designers and Developers, Project Manager and SMEs to get a better understanding of the Business Processes. worked in requirements gathering, user stories (single sign on, multi-factor autantication), whitepapers, end user and client-facing documentation and test plans
• Used Rational Unified Process (RUP) as the Software Methodology.
• Created user documentation, workflows, and other materials for IT department.
• Analyzed and optimized the process, Prepared Business Requirement Document (BRD) and tan converted the business requirements into Functional Requirements Specification and Technical Specification using Rational Requisite pro.
• Performed daily scrum meetings and evaluated the status of the agile team.
• Designed and developed project document templates based on SDLC methodology.
• End to End support throughout SDLC of each project and ensuring timely delivery.
• Assisted in technology selection for the application, based on Cost-TEMPEffectiveness and Quality with an eye towards the future.
• Executed complex SQL queries on the database and performed data analysis to audit the data being retrieved and generate reports
• Handled and resolved many complex issues and received appreciation from client in Confidential support.
• Communicated with design, development and test team using MS exchange Messaging and Defect Tracking System.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling. Met with users and stakeholders to understand the problem domain, gathered customer requirements through surveys, interviews (group and one-on-one) along with JAD sessions.
• Facilitated User Story grooming session with Development team and documented user stories and acceptance criteria for the team product backlog in JIRA.
• Analyzed SQL stored procedures, functions and database architecture to support analysis efforts and aid in troubleshooting production issues.
• Interacted with the users and logged any defects, enhancements from the UAT.
• Preserved the close association with client management leadership, IT delivery, and business stakeholders.
• Involve in database design and write complex query to generate customize reports in SQL.
• Analyzed the existing reports, reporting system. Worked on exporting data using Teradata
• Creates Data Mapping document for the application after finalizing the attributes and tables with business users
• Develops and maintains SQL queries dat support data warehousing joining data from disparate systems, healthcare analytics, and semantic and business logic application;

Environment: Agile, Java, SQL, UML, SDLC,MS Word, Visio, PowerPoint, Excel (Pivot Tables), and UAT.

Confidential, Cambridge, MA

Business Data Analyst

Responsibilities:

• Understanding the current business process, defining scope of the project along with vision statement.
• Met with users and stakeholders to understand the problem domain, gathered customer requirements through surveys, interviews (group and one-on-one) along with JAD sessions.
• Developed process and business reengineering documentation based on system requirement.
• Created business use case, user requirement document (URS), functional (FRS) and technical documents for trading system.
• Worked with SME on clinical trial data capture and worldwide data collection systems for various therapeutic areas.
• Applied Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams and Sequence Diagrams in Rational Rose.
• Analyzes clinical data sets like administrative data, claims data, patient/disease registries, and clinical trials data for maintaining payer records. Wrote documentation for all aspects of the computer systems validation lifecycle, in accordance with FDA regulations, particularly CFR 21, part 11, including: Validation Plan and Protocol, Installation Qualification (IQ), Operation Qualification (OQ), Performance Qualification (PQ).
• Additionally, worked on business application projects in Commercial Pharma, Clinical & Life science Analytics domain.
• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application and managed them using Rational Requisite Pro.
• Developed the project plan with assistance from the management and included provisions for project scope changes and issues and initiated efforts to make improvements.
• Designed the UI of the application, prototyping and wire framing in MS Visio for better illustration of the application.
• Requirements Elicitation, Analysis, Communication, and Validation according to Six Sigma Standards.
• Resolved issues and improve the process to ensure a stable and accurate solution.
• Used MS Visio for Process modeling and Business Process flow diagrams.
• Involved in analysis of requirements for Medical and Commercial pharma line of business.
• Used UML notations for Object Oriented Design and Documentation.
• Performed cost-benefit analysis, generated reports for analyzing various investments and their profitability and also for analyzing various lost opportunities due to time delay in investing.
• Validated business rules and all artifacts with users, approval and sign off.
• Created and managed custom objects, page layouts, fields and reports within Veeva.
• Analyzed data, logical data modeling, created class diagrams and ER diagrams in Rose for designing databases.
• Worked with the team on security features: web, encryption, autantication and SSO possibilities
• Updated and modified progress and resources allocation in MS project for the team.
• Created test plans and scripts, facilitated user acceptance testing and tested strategies with developers and testing team.
• Performed manual front-end testing to check all functionalities of different modules.
• Ensured dat the application met user and management expectations.
• Suggested measures and recommendations to improve the application performance.
• Designed and created Excel sheets to provide market analysis charts.

Environment: Agile, Java, SQL, UML, SDLC,MS Word, Visio, PowerPoint, Excel (Pivot Tables), UAT,and ETL,Oracle, SQL server Management Studio

Confidential

Financial Data Analyst

Responsibilities:

• Responsible for Acquiring data from primary or secondary data sources and maintain databases/data systems as well as performing data profiling and data mining on available data
• Created data Metrix document for the projects dat consists of - current state and future state source to target mapping, data transformation applied, business rules involved, data definition for each data elements, defaults values, involved part, data formats, etc.
• Acted as a liaison between the technical, businesses and testing groups to provide them with required specifications/documentation and to resolve any issues in between.
• Worked in all phases of Agile Methodology (SDLC), including project preparation/scoping, user story, development, testing and go-live procedure.
• Held meetings and discussions with business users and subject matter experts for detailed requirements gathering.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Communicated with Stakeholders and Senior Management at times of resolving issues.
• Involved in System testing, Integration testing and User Acceptance Testing.
• Worked with the Lab Sales team in tracking the opportunity pipeline and scheduling the Interface set up timelines for each Implementation.
• Generated and maintained status reports for Executive Leadership.
• Prepared the team for SIT, QUA and UAT testing cycle by executing team meetings, scrum calls, and daily standups.

Environment: Agile, Java, SQL, UML, SDLC, MS Word, Visio, PowerPoint, Excel (Pivot Tables), and Project, Share Point, UAT, Data Warehouse, Oracle,,