SUMMARY

• Sr. Business Analyst professional with 8+ years of experience in Banking, Retail, Insurance domains.
• Experienced in gathering user requirements, analyzing and preparing Project Deliverables such as Project Charter, Business Requirement Document (BRD) and Functional Requirement Document (FRD) and proposed changes for process improvement using Rational Requisite Pro.
• Demonstrated ability to work actively in different phases of Software Development Life Cycle (SDLC) using Waterfall & Agile.
• Proficient in transforming Business Requirements into Functional Specifications, focusing on workflow analysis and design, business process reengineering, user interface design, portal design, and process flow modeling.
• Highly proficient in working with Users and Stakeholders to elicit, analyze, communicate and validate requirements using JAD, JAR, and Brainstorming sessions.
• Solid knowledge and experience of Business Process Engineering/Re - engineering (BPR).
• Expertise in using various tools like MS Visio for Functional Flow Charts, Business Process Diagrams.
• Comprehensive understanding of the Organizational Framework that help to map the AS-IS and TO-BE model using the GAP Analysis, and plan effective approach to build/buy solutions to the business problems/needs/opportunities.
• Skilled in Object Oriented Analysis and Design with experience in creating Use Cases, Class Diagrams, Activity Diagrams, Object Diagrams, State Diagrams, Sequence Diagrams, Unified Modeling Language (UML) using MS Visio and Rational Rose.
• Expertise in Client Relationship Handling, Project and Release Management, Configuration and Change Management, Defect Tracking and Control.
• Solid experience in defect reporting using Test Director, Quality Center and JIRA.
• Excellent skills in Process Flows and Swim Lane Diagrams.
• Proficiency in writing SQL Queries to extract data from databases.
• Sound knowledge in conflict management and configuration management.
• Proficient in broad range of technologies including business process tools such as MS Project, MS Excel, MS Access, MS PowerPoint, MS Visio and Rational Suite.
• Participated in Sprint Planning, Daily Scrum Stand Up, and Sprint Retrospective meetings.
• Participated in the development and grooming of Project Backlog Stories (Requirements) with business and technology partners.
• Assisted in closing gaps and TARs for associated Stories in each individual Sprint.
• Assisted in entering and updating Issues (Epics, Stories, and Tasks) onto JIRA Agile application.
• Assisted in the development of Project Impact and Process Control Plan documents.
• Assisted in testing associated Sprint Stories for Acceptance Signoff, using Archer RSA (Configuration Management System).

TECHNICAL SKILLS

• MS Word
• MS Excel
• MS Visio
• MS Project
• MS SharePoint
• MS Access
• SQL
• JIRA
• MS SQL Database
• Crystal Report
• TOAD
• Oracle 10g
• DB2
• PL/SQL
• SQL Server
• AQT
• XML
• UNIX
• Rational Rose
• Rational Requisite Pro
• Rational Clear Quest
• TIBCO
• WS-FTP Pro iWAY
• Facets
• PeopleSoft
• BI Cognos
• RUP
• UML
• HP Quality Center
• Win Runner
• Ultra Edit
• DOORS
• Agile
• Waterfall
• JIRA
• Rally
• Oracle DB
• Documentum
• JAVA/J2EE
• JavaScript
• XSD
• XSLT
• Lotus Notes8.5

PROFESSIONAL EXPERIENCE

Sr. Business/Data Analyst

Confidential, Chicago, IL

Responsibilities:

• Responsible for gathering Business & Technical Requirements, Source System Analysis, Gap Analysis, Data Profiling, Requirements Documentation for ETL development and report development.
• Prepared various statistical data analysis reports for corporate clients, provided ad-hoc updates and modified report templates as required.
• Managed implementation of Document Management System meeting requirement deadlines.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Carried out SQL Scripting, Transactional Data Analysis and Reporting on MS SQL database.
• Prepared, gathered and analyzed business requirements, user requirements, design, technical specification documents.
• GWP retail components include modeling, trading, portfolio accounting, client communications and workflows. Lightning is a web-based processing for fixed income capital markets which automates a range of processes, including, trading, sales, funding, accounting, risk analysis and asset/liability management
• Provided Capital Markets subject matter expertise to the IT team throughout the project. Reviewed development and test deliverables as needed
• Worked with various business groups to understand their data analysis requirements and provided appropriate support to reduce the number of reports.
• Provided Capital Markets subject matter expertise to the IT team throughout the project. Reviewed development and test deliverables as needed
• Extensive understanding of capital markets instruments, development methodologies and data base mining via SQL was paramount to the success of the high profile role.
• Interacted with the SMEs and Stakeholders to get a better understanding of client's business processes.
• Analyzed relational data with SQL to quickly understand existing data stores and to validate source/target mappings and transformation logic.
• Created and executed Test Plans and Scripts to verify software functionality and adherence to business requirements.
• Testing of mappings and workflows loading the data into the datawarehouse and validation of Business object reports
• Responsible for Computer Operations of DataWarehouse.
• Created walkthroughs and validations on logical model and created physical data model using forward engineering.
• Handled of FDR file systems along with data elements within various Master files
• Carried out queries from customer data base using SQL.
• Manually performed Back End Testing by extensively using SQL queries to verify the integrity of the database.
• Defined Business Requirements, performed GAP Analysis and Design Systems Solutions.
• Conducted System Integration and User Acceptance Testing.
• Engaged with key stakeholders, technology and operational areas and conducted workshops to gather business requirements and to produce current state analysis.
• Gathered, analyzed and wrote Business Requirements and translated them into Functional Requirements and other supporting artifacts.
• Engaged and managed relationships between internal departments.
• Worked with key stakeholders, technical BA's and IT team during User Acceptance Testing.
• Produced detailed UAT test scenarios and test scripts and executed UAT testing.
• Acted as a primary liaison between the business client, operations and technical areas throughout the project life cycle.
• Involved in project coordinating activities like scheduling meetings, communicating with project resources, preparing and leading presentations, working closely with project stakeholders and it project team.
• Conducted JAD sessions with various teams (Business, development team, QA team) which aids in developing an architectural solution that the application met, to resolve open issues and accommodate change requests.
• Closely worked with Business and Architectural team in defining the business process flow to enhance the underwriting process which involved front-end, back-end systems and web-services for system integration.

Sr. Business Analyst

Confidential, Bloomington, IL

Responsibilities:

• Assisted Project Manager in coming out with a detailed Project Plan, Timeline, and high-level resource allocation and planning.
• Acted as a Point of Contact for the Project Deliverables Roadmap and reported it to the PMO on a weekly basis and presented the progress in the daily Agile Standup meeting.
• Helped the team in identifying and documenting the Risks, Issues, and Dependencies in a dashboard and tracked the status after assigning ownership and target dates.
• Researched and Analyzed Business needs and ways to improve property and casualty specifically policy contracts and processes administration.
• Worked on an application that took care of online account services which included Bill paying, checking the bill history, changing customer profile, ordering auto insurance ID cards Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Closely interacted with business users like Claim and Policy representatives, Examiners, Team Leads, Supervisors, SMC’s, Stakeholders and gathered business requirements and capabilities.
• Demonstrated experience in conducting User Acceptance Testing (UAT) and documenting test cases in both personal commercial line of property and casualty insurance.
• Conducted a thorough AS-IS analysis of the present processes, systems, and organizational aspects and identified potential pain points and high-level business needs.
• Identified the GAP between the current systems and future systems and provided potential recommendations on the business process and systems that later on paved the way for considerable cost reductions and profit realization.
• Wrote Functional Requirements (FRD) and Systems Specifications (SSD) and documented them in the Requirements Traceability Matrix (RTM).
• Assisted the systems in the systems design, build, and code review activities and acted as a single point of contact for all of the clarifications on business and functional aspects of the system.
• Acted as a systems liaison and facilitated efficient delivery and flow of deliverables like BRD, SSD, and Use Cases in the end-to-end Systems Development Lifecycle.
• Designed and created BRD that included changes in the front end of the premiums, claims & financial systems and changes to middleware back end systems to post recoveries, reserves and loses to correct accounts.
• Used SharePoint extensively to collaborate with the development team and Business team.
• Assisted wireframes teams in developing Mock ups for customer landing pages for various LOBs using MS Visio and Axure.
• Collaborated with the testing partners and acted as an integral part of the Test Strategy Formulation, Test Cases Translation, and Test Scripts Review.
• Documented the defects, assigned priorities and ownership for the same. Conducted a thorough Impact Analysis of the new solution and documented the underlying problem, updated process flow, and requirements documents.
• Reviewed the Functional Requirements, Use Cases, and Systems Specifications to the systems and testing partners and was always available as the design, build, and testing phase of the project occurred.
• Performance tuning to reduce the overall weekly batch process.
• Regularly interacted with the Data Management team and provided the right inputs and assistance in building a Data warehouse and reporting.
• Assisted the business users to conduct Early and Final User Acceptance Testing by setting up the environment, meeting the data needs, and navigating them until getting a final sign off and approval.
• Led the team for preparing the end user training manuals, knowledge management, and devised a project plan for post-production support for the business users.

Business Systems Analyst

Confidential, Hoffman Estates, IL

Responsibilities:

• Evaluated and analyzed variances in deadlines, tasks, milestones and resource loading.
• Facilitated project meetings including scheduling, recording and distributing minutes, and following up on action items.
• Interacted with Business Users and executives to identify their needs, gathering requirements and authoring Business Requirement Documents (BRD), Project Charter and Project Approach Documents.
• Understood the Business Logic, User Requirements and Test Objectives to develop Use Case Scenarios.
• Facilitated and conducted Joint Application Development (JAD) sessions with Business Clients to identify business rules, Functional and Non-Functional Requirements.
• Utilizing sales force demand-ware for cloud-based e-commerce platform development and related services for retail products.
• Handled POS application and customer fulfillment projects which makes significant business improvements in retail
• Testing & deployment EMV pin pad for PCI compliance to all retail stores
• Reporting regularly to management on key performance indicators, business trends, leading industry indicators, etc. using business intelligence tool Tableau
• Prototyping in Adobe Experience Manager (AEM), a CMS, for building websites, mobile applications and forms of future product.
• Manage Supply chain, inventory management process, order management and delivery management.
• Implementing Omni between retail store & Ecommerce website to fulfill more efficiently
• Utilize IT supply chain software to optimize route and network design, improve capacity management and simulate forecasted supply and demand scenarios resulting in 10% reduction in network miles.
• Conducted the AS-IS and TO-BE Analysis of the business process using GAP Analysis.
• Analyzed the current system for the performance issues and the size of content stored.
• Identified the issues involved in current system workflow to provide better and efficient workflow solution.
• Provided improvised workflow solutions in the new system.
• Understood the external impacted systems and provided the same functionality in new system with minimum impact to the external systems.
• Worked closely with Business, SME's, and Managers for better understanding of risk/issues involved in document storage.
• Created monthly/weekly status reports to update the project schedules & deliverable plan to Business and Portfolio Project Manager.

Business Analyst

Confidential, Jersey City, NJ

Responsibilities:

• Conducted JAD sessions with project sponsors, subject matter experts (SMEs) and business users to identify the scope of the project and created vision and scope document
• Collaborated with SMEs in DocuSign to understand their requirements and constraints and communicated that with the team
• Conducted impact analysis study to understand the value the project would bring to the organization
• Created detailed BRDs and FSDs and conducted walkthroughs with different departments.
• Created detailed UML diagrams to understand loan origination process from initial contact, to appraisal, evaluation and funding with activity diagrams, use case diagrams, data flow diagrams.
• Assisted in the development of test plans and test cases for functional, integration and system testing
• Created RTM (requirement traceability matrix) to map the test cases to the business requirements.
• Communicated with the IT ops team for setting up the UAT environment.
• Coordinated UAT testing with the business users and trained them on the same, developed user manuals and derived the UAT test cases.
• Facilitate customer meetings and Business design walkthroughs for project scope and status at distinct phases.
• Participated in daily scrum meetings and addressed spikes that were raised.
• Documented test cases to test the web service, alerts for remediation process.
• Coordinated UAT testing with end users to get their feedback, created user manuals and selected UAT test cases.
• Conducted UAT defect calls and engaged entire group to get updates on UAT open defects
• Worked closely with QA, to develop test scenarios and test cases for distinct levels of testing like smoke testing, regression testing, functional and nonfunctional testing before approving it for release.
• Created requirement traceability matrix (RTM) across the project by linking business requirements to test cases

Jr. Business Analyst

Confidential

Responsibilities:

• Interacted with the stakeholders to define the purpose and scope of the project.
• Interviewed users to understand current state of information availability and identify future information needs based on the analysis. Performed gap analysis and elicit requirements.
• Conducted JAD sessions with different groups of users to explore options and make decision on which data with be most beneficial and to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly
• Understood and analyzed the functional areas and identified source systems and data required in data warehouse environment to meet current and future needs.
• Worked closely with business users and decision makers to develop Transformation Logic.
• Worked with the Data Warehouse development team to identify business objects and their attributes and relationships.
• Gathered Business Requirements by interacting with the users, designers, developers, project manager and SME's to get a better understanding of the Business Processes.
• Conducted Functional requirement specification reviews and walkthroughs with the designers, developers and stakeholders.
• Overall coordination of UAT testing and training and provided feedback to data warehouse team so that they can make modifications as necessary.
• Involved with Quality Assurance team to develop and design Test Plan and Test Cases.
• Gathered business requirements through interviews, surveys, and observing from account managers and UI (User Interface) of the existing compliance reporting system.
• Analyzed data feeds from different source systems/applications and on various interfaces like Cash, Wires, ACH (payments) to collect the business process requirements, documented them in Business Requirement Document (BRD).
• Designed Use Cases, Use Case diagrams, Activity diagrams in UML methodology.
• Worked as an interface between the users and the different teams involved in the application development for better understanding of the business and IT processes.
• Worked closely with the UI team to model the screens, which met user defined requirements, organizational and regulatory standards.
• Conducted work sessions with Business Partners and Application Architecture team to help identify all the possible business and system Alerts/Errors and provide suggested contents with the help of BP's.
• Reviewed test plan documents and test case documents created by UAT team and provided input on behalf on Business team