SUMMARY:

• Around Six years of experience in IT industry with an emphasis on Business Analysis, Software Quality Analysis, GUI, System and Integration Testing, Functional/Regression Testing, Data Migration, Interface, Data Upload, Data Integrity/End to End testing of Web and Client/Server based applications
• Experience in the creation of use cases and the development and maintenance of test specifications, test cases, test scripts and test data
• Extensive knowledge of SDLC (Software Development Life Cycle) methodologies.
• Experience in working with Agile methodologies and active participant of SCRUM meetings.
• Experience in various types of testing including Functionality Testing, Integrated Testing, System Testing, Security Testing, Stress Testing, Regression Testing, UAT of Standalone, Web Based and Client - Server applications
• Performed User Acceptance Testing (UAT) Manually.
• Organized many Joint Application Developments (JAD) sessions and Joint Requirement Planning sessions (JRP), walkthrough, Interviews, Workshops and Rapid Application Development (RAD) sessions with end-user/clients/stake holders and the IT group.
• Experience in configuring data mapping between different Databases.
• Experience and Good knowledge in Business Process, Risk Analysis, Risk Management / Mitigation, Portfolio Diversification, Financial Analysis. Knowledge of Basel, Dodd Frank, CCAR, SOX regulations etc and in Best Practices on ISO 2000 Standards.
• Proficient at drawing Business Process Diagram, Workflow Diagram.
• Experienced in conducting JAD sessions meeting reviews and walkthroughs.
• Created documents for validation and verification against business unit requirements.
• Understanding of the AS-IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans.
• Participated in design review meetings with production team of Business Analysts, SMEs, PMs and developers in order to understand the critical business functions of the project applications
• Attended requirements and design meetings, review and analysis of requirements and design documentation.
• Working knowledge of creating different types of test reports through HP Quality Center such as Test Execution Status/Summary, Defect Status/Summary, Defect Injection rate etc.
• Participated in design walkthroughs and verified Quality Center Test Scripts and results.
• Advanced excel skill including Pivot Tables, Slicers, V-Lookup, H-Lookup, Macros, Formulas, Data Sorting & filters
• Expert in MS Office Products such as Word, Excel, Project, Power Point, Access, Visio etc.
• A team player with excellent Presentation, interpersonal & analytical skills with ability to manage, coordinates and works independently in a cross functional time sensitive environment.

TECHNICAL SKILLS:

• SDLC
• Agile/ Scrum
• Waterfall
• RUP
• Windows
• MS Access
• Project
• & Excel
• SAP
• Murex
• Loan IQ
• ICI Repo
• PeopleSoft
• Hyperion Essbase
• Lotus
• Bloomberg
• Axiom
• Informatica
• Order Audit Trailing (OATs)
• Bluesheets
• Sierra
• SharePoint
• Web Services
• XML
• HTML
• HP ALM/ Quality Center
• JIRA
• Visio and Clarity
• Microsoft Office Suite
• BPEL
• MS Visio
• MS Share Point
• Outlook
• Clear Quest
• Lotus Notes
• SDLC
• UNIX
• SQL
• JIRA
• Quality Center
• Test Director

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

Business Analyst

Responsibilities:

• Documented As-Is processes, To-Be processes and identified gaps by conducting Gap Analysis, and documenting impacts to different groups and systems.
• Developed the Requirements Management Plan and gathered user and business requirements through open-ended discussions, prototyping and guidance of the compliance department and work environment.
• Worked with the technical team to ensure that the data collected could be sent across the web services via the API to Pershing
• Conducted JAD Sessions with Infrastructure management team, SME, policy holders and stakeholders for issues which were open and pending.
• Conducted brainstorming sessions with Infrastructure/ SRMS project groups.
• Collected Business requirements through interviews with already enrolled policy holders, SMEs, surveys and observations.
• Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering)
• Wrote User Requirement Specification Document (URS) and Technical specification documents, used Rational Requisite Pro in managing requirements
• Gathered requirements for the listed options Risk management system, specifically for index options Risk management spreadsheet. Defined requirements for product control and Risk management end of day feeds.
• Followed the RUP methodology for the entire SDLC.
• Educated clients team and stakeholders on the benefits and Risks associated with the project.
• Validated Requirements in Developers environment as well as production environment and documented the results.
• Maintained project modules in Clarity which included resource schedules, project plans, status reports, and Risks/issues management
• Used SQL Server to write queries, procedures to insert, update, select and delete data from database.
• Collaborated with the Development and Testing Teams throughout the SDLC.
• Received Test Scripts and Test cases created by QA team to make sure all requirements are covered and Conducted User Acceptance Testing (UAT) on the application.
• Executed manual scripts during regression testing phases.
• Performed manual front-end testing to ensure that all functionalities of enhanced application behaved as per the business process.
• Communicated with SRMS users regarding expected changes, time frame and downtime of the new Application.
• Participated in bug review meeting with developers and QA team members and updated requirements documents based on feedback from QA team members and developers.

Environment: Windows, VISIO, MS Project, UML, HTML, JavaScript, Java, J2EE, SQL, Rational Tools, MS Visio, MS Word, Excel, PowerPoint, Access.

Confidential, Harrisburg, PA

Business Analyst

Responsibilities:

• Gathered Requirements from Users, Technical Team and Sales Executives.
• Worked on creation of policies and doing a financial transaction like reserves in Guidewire
• Developed functional requirement for Configuration, mapping systems with ClaimCenter data dictionary, new and modified rules.
• Worked on Configured check, claim transaction, claim details, financial, user profile, activity patterns and contact center screens as per business needs.
• Documented and tracked all product defects with use of SQL (reporting).
• Review and gain understanding of existing functionalities introduced to GW system through User Story reviews and hands on system use.
• Implemented a structured system development methodology with emphasis on Systems Development Life Cycle (SDLC) that dramatically improved productivity and reduced errors.
• Create requirements for new functionalities for Guidewire System currently in development.
• Wrote Use Cases and produce Activity diagrams, Develop requirements specifications and Documentations
• Analyze current data stores and generate UML diagrams of logical and physical data.
• Identified opportunities for business process improvement and initiate efforts to make improvements.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation
• Performed Business Process Modeling using Visio. Performed customer data analysis.
• Updating the loss costs rates in the system for the auto Personal and Commercial property and General Liability lines of business per the actuarial department's direction.
• Identify research, investigate, analyze, define and document business processes.
• Conduct workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Interacted with management, system analysts and technical developers for setting project goals and writing Complex SQL queries and optimizing SQL Queries
• Analyzed operating procedures and policies on an ongoing basis and recommended and implemented improvement plans where appropriate.
• Conducted Joint Application Development (JAD) sessions with IT groups. Responsible for updating changes in functional specification documents and on-boarding document of each application.
• Daily interaction with various system teams, development teams, front office business managers and client service representatives.
• Gathered requirements using Agile/Scrum Methodology.
• Created data mapping document to load data from XML files to SQL table.
• Developed SQL queries using SQL Navigator to extract data from the target tables to prove the data mapping.
• Used Quality Center documentation management and defect tracking.
• Developed tables, Views, Stored Procedures and Triggers using SQL Scripting
• Strong understanding of Data Modeling Techniques, Use Case Modeling and UML Concepts (including activity, state, sequence diagrams)

Confidential, Downingtown PA

Business Systems Analyst

Responsibilities:

• Gathered Requirements from Users, Technical Team and Sales Executives.
• Gathered transactional information from the High Level Management and Technology Department.
• Conducted Various Research work on user enhancements.
• Developed UML Use Case model for the application using MS Visio and assigned to prepare the detailed Work flow diagram based on the proposed enhancement for the system.
• Design call flows, and provide Voice User Interface specs for new and updated caller experiences.
• Business Architecture: Working with users to identify business requirements.
• Performed and administered SQL queries validation via SQL, which sustained data integrity.
• Experience in Interactive voice response (IVR) Software Development Life Cycle (SDLC) aspects such as Requirements Analysis, Design, Development, Testing and Deployment and Quality Assurance Life Cycle (QALC) aspects such as creating test Plans, test cases to perform different types of testing and validation Involved in gathering Premium Processing Requirements.
• Converted Business specification in Functional Specification.
• Analyze current data stores and generate UML diagrams of logical and physical data.
• Identified opportunities for business process improvement and initiate efforts to make improvements.
• Supporting Design, Development and Test plans for IVR.
• Performed Business Process Modeling using Visio. Performed customer data analysis.
• Identify research, investigate, analyze, define and document business processes.
• Conduct workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Documented and tracked all product defects with use of SQL (reporting).
• Worked on IVR Speech tools: Sound Forge, Voice Path, and VoIP, Tracer Tool, Text to Speech, Total View, Voice Call Log and IVR Simulator.
• Tested the Call Handling Speech application (also known as Speech Recognition IVR).
• Interacted with management, system analysts and technical developers for setting project goals.
• Identifying the test data for the test cases & worked on writing the complex SQL queries using Flow Control, bulk INSERT, and CREATE, DELETE and UPDATE statements.
• Created workflow diagrams, UML diagrams, process models, activity diagrams, use cases, for incorporating design changes in the system.
• Created different Traceability views to maintain the Traceability of the requirements.
• Analyzed operating procedures and policies on an ongoing basis and recommended and implemented improvement plans where appropriate.
• Daily interaction with various system teams, development teams, front office business managers and client service representatives.
• Writing Complex SQL queries and optimizing SQL Queries
• Participated in Triage Meetings, weekly status meetings with IT and business people

Confidential, Warren, NJ

Business Analyst

Responsibilities:

• Analyzed and wrote documents for validation of FINRA reporting requirements for data ware house for trade settlement issues
• Created and maintenance of project charters, project plans, milestones, RAID log, and change management procedures for CCAR initiatives for spanning Capital Adequacy, Internal Controls, and Modeling for scenario stress testing
• Supported work stream project managers on data modeling analysis for Balance Sheet, PPNR, and RWA focused around Credit, Counterparty, & Market Risk forecasting for Trade Desk Liquidity planning for Capital Adequacy
• Ensure quality reviews and compliance of the deliverables to the clients; Managed the PMO document library and documented the lessons learned artifacts.
• Manage scope, time, costs along with stakeholder expectations in order to manage issues and risks related to implementation of CCAR regulatory reports including (FR-Y9C, FR-14M, FR-Y14A) based on 9-Quarter forecast of projections
• Worked with Business team for ISO 2000 standard to ensure good quality service to upheld Co. business.
• Developed and executed test cases test Scenarios using HP Quality Center and followed-up defects in JIRA.
• Performed Database testing using SQL queries
• Followed the UML based methods using MS Visio to create Use Case, Activity/State Chart, Sequence, and Collaboration Diagrams.
• Served as UAT lead of regression testing of FR-Y9c/FR-Y14Q/FR-Y14A reports, testing data journey and accurateness from source ledger to final Axiom report output for over 70 schedules. Resolved MDRM breaks by identifying root cause logic

Confidential, Golden Valley, MN

Business Analyst

Responsibilities:

• Conducted and participated in System Requirements gathering sessions with Business Partners.
• Involved in maintaining Test Matrix and Traceability Matrix and performed Gap Analysis
• Created user stories and visual design supporting the system functionality
• Verified, entered, and updated data for internal tracking system and enterprise wide system ServiceNow.
• Identified processes for developing and documenting detailed business requirements. Data was collected from end-users, and analysts.
• Created Use-Cases and Requirements documents to document business needs.
• Conducted Use-Case reviews and identified gaps, leading to improvements/enhancements in the same.
• Created and maintained the Requirements Traceability Matrix (RTM).
• Involved in design and development of standard and ad-hoc reporting using SQL.
• Monitor all alerts and escalate all issues through ServiceNow Issue Tracking System.
• Implemented new policy changes, legal requirements by creating Business Requirement, Detailed Technical Requirement, User Requirement documents etc.
• Executing SQL Queries for the reports before mass and after mass reports to check for claims routing
• Identified and analyzed the data requirements for the various site teams and made sure that the required data is available in the testing environment.
• Worked directly with software engineers to ensure clear communications on requirements and defect reports.
• Designed and developed scenarios based on business requirements.
• Assigned project tasks to Network & Infrastructure resources via ServiceNow.
• Followed the RUP methodology for the entire SDLC.
• Streamlining the commission calculation system and add business value by analysis of agent demographics and members information
• Interacting with other teams through walkthroughs, teleconferences, meetings, etc. to resolve various issues.

Confidential, Montvale, NJ

Business Analyst

Responsibilities:

• Responsible for workload assessment, resource allocation, scheduling and coordinating testing team activities.
• Involved in reviewing and verifying the Business Requirements Documents and Test Plans
• Developed Test cases and Test Scripts to fully validate the functionality, and ensured that the application meets all the security requirements
• Conducted business process analysis and created business Process Models and Business Process Flow Diagrams.
• Documented detailed business requirements and functional specifications into User Stories and Use cases with Scrum and Agile/Iterative methodology.
• Analyze Business Rules and defined data elements.
• Expected and Actual results were maintained in a live Test Matrix throughout the Testing life cycle
• Worked on Screen Payment / SWIFT Messages in accordance with Policies, procedures, and practices to ensure compliance with laws and regulations
• Responsible for creating User Acceptance Testing (UAT) scenarios. Responsible for System, Integration, and Regression testing
• Created and published Test Plan, Test Strategy documents on SharePoint for project team members.
• Performed backend testing using SQL queries to ensure that the data is being sent correctly and the files are being generated correctly.
• Walked all project stakeholders thorough requirements and obtained their sign offs on the requirements/User stories.
• Performed Data Validation of the data flow from the front-end to the back-end by executing SQL scripts.
• Developed and modified SQL queries and stored procedures with cursors and functions to create & load test data TOAD.
• Maintained requirement traceability and keep project team informed on any changes in the requirements through defined Change Management Process.
• Coordinate User Acceptance Testing (UAT) including reviewing user acceptance test cases and environment/data set up.
• Analyze and help resolving user support issues
• Participate in weekly stand up team lead meetings, provided test status, and updated the test team members with the status on the project.

Confidential, Wayne, NJ

Business Associate

Responsibilities:

• Consult with clients, develop financial plans, and deliver viable solutions, with targeted investments and mortgages per quarter
• Maintain up-to-date knowledge about bank products and services with other departments, including Compliance, Policy and Procedure, Fraud Prevention, and the Loan department
• Work with team to achieve target under a high- pressure environment to accomplish and surpass the goals
• Served as liaison to internal & external Units, clients, and assist in account opening, closing, operations and loan processing activities
• Developed customer outreach and retention and growth strategies, with deposit growth for the bank
• Used Excel for Pivot tables, V Lookup and graphs for analyzing data seamlessly; create accurate employee schedules while reporting to Manager and District Executive
• Defined, prioritized business requirements, Determine which business subject areas provide the most needed information; prioritize and sequence implementation projects accordingly
• Experience in Credit Cards Originations, Acquisitions and Authorizations
• Created UML use case, activity diagrams for the interaction between report analyst and the reporting systems
• Responsible for interfacing with Development and other impacted workgroups to review and explain business requirements so they can be correctly sized for implementation
• Work with this diverse set of stakeholders to resolve requirements, design, test, implement and support appropriate technology solutions to business needs.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Created full life cycle documentation from product requirements in the developmental stage to functional specifications for the completed modules of application components.
• Managing requirements and mapping them to test plan and test cases.
• Document, review, analyze and evaluate business processes, systems and user needs
• Educated clients team and stakeholders on the benefits and risks associated with the project.
• Used MS Project to maintain the project schedule and track its status.
• Communication management, status reporting and creating implementation plans.
• Analyzed the “As is” and “To be” system documents to show the current and proposed functionalities of the system using MS VISIO.
• Collaborated with the Development and Testing Teams throughout the SDLC.