SUMMARY:

• 8+ years of comprehensive knowledge of Business Analysis methodologies, Software Development Life Cycle (SDLC) using waterfall and Agile (Scrum) & Data analysis.
• Business System Analyst, Sr. Business System Analyst and Scrum Master in a variety of SDLC methodologies. Certified Scrum master with Excellent analytical and logical skills.
• Extensive hands on Experience with Banking services like Payment processing systems, Enhancement projects AML, KYC, Mortgage, Trade management, Investment banking, wealth management, Mutual fund, Sales force, EDMS Extensive years of experience in Business process re - engineering, business process improvements, Data Reports Analysis by active participation in brainstorming, interviews, focus groups, prototyping, document-reviews, and JAD sessions
• Knowledge of mortgage ( loan origination ) & auto industry.
• Excellent Report creation skills in developing reports like Tabular Reports, Matrix Report, Charts, Custom Reports using Report Designer as well as Report Builder in SQL Server Reporting Services( SSRS ) in Business Intelligent Development Studio ( BIDS ).
• Extensive working knowledge of various Banking compliance, CCAR, FATCH and Guidelines such as NACHA, The Bank Secrecy Act, USA Patriot Act, The USA Securities and Exchange Commission and other related laws and regulations.
• Proficient in industry standard Software Development Methodologies like Waterfall, Agile-Scrum, SAFe and Waterfall, Scrum, Hybrid with an understanding of Extreme Programming, Rational Unified Process and Spiral.
• Expert in facilitating Scrum Ceremonies, playing Scrum Roles and Maintaining Scrum Artifacts.
• In-depth knowledge of Agile process and principles.
• Maintained RAID log to help scrum team.
• Experienced in compiling BRD, FRD, SRS, Use Case Specifications, and Requirements Traceability Matrix (RTM).
• Performed Impact Analysis (business and technical impact) Risk Analysis and Cost benefit analysis.
• Assisted Project Manager in creating Project Charter, Risk Register, and Project Management Plan. Also, recommended changes to projects.
• Collaborated on creating Work Breakdown Structure to define and group project's discrete work elements using MS project.
• Experience in conducting GAP (AS-IS & TO-BE Analysis), Impact Analysis (Business & Technical), SWOT, Cost benefit analysis.
• Root Cause Analysis, Interface Analysis, Feasibility Study, Risk Analysis.
• Expertise in processing Change Request and analyzing the impact of change, creating the impact analysis report and processing it through the Change Control Board (CCB).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Sequence Diagram and Class Diagram using MS Visio.
• Collaborated with QA team in Black box testing, Functional Testing, Smoke testing, Regression testing, User
• Acceptance Testing(UAT), and Performance Testing.
• Proficient with SQL queries, customizing tables from database and implementing ETL through Informatica.
• Assisted QA team in writing Test Scripts, Test Cases and Test Plans.
• Experienced in. System analysis, design, test and implementation. Documented Business Rules, system validations, web services documentation (WSDLs).
• Defined and suggested SOAP, REST, XML based web services, web methods, (API's).
• Configured and design Adobe Campaign to meet business needs by understanding the data models, data integrations, ETL and data flows.
• Work closely with Marketing, Content, Product Management and both internal and vendor Engineering resources to define how we implement on Adobe Campaign to meet business needs.
• Good understanding of communication protocols like HTTP/HTTPS, SMTP, FTP.
• Understanding of web services and their documentation like REST and SOAP using XML, HTML,WSDL and UDDI, using internet protocol suite like HTTP under three tier architecture and service oriented architecture(SOA).

TECHNICAL SKILLS:

Modeling Tools: ALM, Rational Requisite Pro, HP ALM, UML, MS Visio, BPMN, Rational Rose, DOORS, Rational Clear Case, clear quest.

Methodologies / Frameworks: Agile, Waterfall, Scrum

Database: MS SQL Server, Oracle, MYSQL.

BI Reporting Tools: Tableau, OBIEE, Micro strategy, SAP Crystal Reports, Congo’s

ETL Tools: IBM Data stage, Informatics, Power Center, SSIS

QA Testing Tools: HP QC, Load Runner, MS Test Manager 2013, Selenium

Project Management Tools: MS Office Suite, MS SharePoint 10, Data Warehousing Data Marts, OLTP, OLAP, ROLAP, MOLAP, Oracle, Query/Reporting, Multidimensional Analysis, MS Project professional, MS Project Server, JIRA, RALLY

Operating Systems: Windows 7 and above, Mac OS X, Linux, UNIX, UBUNTU, Microsoft Server 2008, 2012 VMware, Visual Studio, BALSAMIQ

Other tools: JAVA SCRIPT, HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, PA

Sr. Business System Analyst/Scrum master

Responsibilities:

• Participated in eliciting business requirements and translating them into Business and Functional Requirements.
• Conducted Requirement analysis and Design Walkthroughs with the designers, developers and management teams
• Followed the UML based methods using MS Visio to create Business flow diagrams, Use Case diagrams, Activity diagrams, sequence diagrams, and Collaboration Diagrams.
• Engaged with stakeholders to gather software requirements to ensure alignment with development team.
• Experience with Salesforce.com Reports, Dashboards, Forecasts, Workflows.
• Expertise in conducting Brainstorming sessions, Interviews, Joint Application Development Sessions (JAD), Focus sessions for requirements gathering, analysis and design with stakeholders, Developers and system architects.
• Well versed in documentation of Business Requirement Document (BRD), Use Cases, Requirements Traceability Matrix (RTM), system Requirement Specification (SRS) and Test Requirement Document (TRD).
• Facilitated GAP Analysis, Impact Analysis (Business/Technical), SWOT Analysis, Cost-Benefit Analysis, Root Cause, Analysis and Risk Analysis along with creating As-Is and To-Be Business Models.
• Collaborated in identifying Key Performance Indicators (KPIs) to accurately analyze the needs of clients leading to optimization of the business processes, which eventually led to value creation for the organization and client
• Created Use Cases, Data Flow diagrams and Activity diagrams using UML tools like MS Visio and Rational Rose.
• Created Prototypes, Wireframes and Mock-Up Screens by assisting the UX team to visualize Graphical User Interface (GUI) according to GUI requirements using tools like Balsamic Mockups and Mockup Screens.
• Worked in close co-ordination with the QA and software testing team in developing test plans and test cases from functional and business requirements for Integration testing, Quality Assurance and User Acceptance Testing
• Involved in client interactions and converting business functionalities into Service Oriented Architecture (SOA) models across heterogeneous IT environments. Extensive knowledge of SOAP/REST full web services.
• Assisted with prioritization and resolution of software defects.
• Interfaced with Program Management Office to ensure project goals and requirements are being met.
• Created and managed project plan and coordinated projects status across a diverse group of stakeholders.
• Managed and communicated a clear vision of the project's objectives, and motivate the project team to achieve them.
• Worked closely with others in project management office to guide efforts toward achieving intended business results.
• Plan, Execute, Monitor and Close projects according to established project life cycle.
• Interacted with team members including Program Manager, Project Manager, Development Lead, Developers, UI lead and developers, QA Manager and Testing team in a matrix organization to ensure the project deliverables.
• Developed WBS, Project Schedule, determining Milestones, Accessing Risk and plan risk response, Documenting Lessons Learned.
• Assisted team to remove impediments by having an understanding the control and release processes.
• Used Fibonacci series and planning poker for estimation and helped team understand their importance.
• Helped the team to Split a big story into independent, acceptable, deliverable and testable stories whenever it required to adhere the agile concept.
• Familiar with DB concepts like Data Structures, Data Marts, Data-Entity Relationships and User Administration.
• Implemented Databases, table structures, mapping Schemas, Data Marts and OLAP operations such as Roll-up, Drill-down, slice and dice and pivoting.
• Executed SQL queries using joins, group by and order by to extract data from different data sources and to perform DDL (Data defining language) operations to create, read, update and delete (CRUD) the data in the database.
• Involved in client interactions and converting business functionalities into Service Oriented Architecture (SOA) models across heterogeneous IT environments. Extensive knowledge of SOAP/REST full web services.
• Managing Scope, Dependency, Resources, Risks, Issues/Conflicts, Stakeholders, Timelines and Cost/Financial aspects of the project.
• Identifying, tracking and resolving project risks/issues using industry best practice problem solving techniques and impact analysis.
• Extracted data using ETL, ODI and performed data Analytics using OBIEE.
• Managed milestones, allocating work based on expertise and availability of resource.
• Ensuring delivery within defined dates with proper testing and sign-offs.
• Participated in Scrum ceremonies like Backlog/Grooming Refinement, Sprint Planning, Daily Scrum Meeting, Sprint Review and Sprint Retrospective Meetings for each sprint in Agile Scrum Methodology
• Experience in recording and maintaining the artifacts like impediments list, sprint burn down charts and sprint burn up charts to track the team's performance and keeping it visible to the team members and owners.
• Develop and present weekly RAG status reports and monthly steering committee / executive updates.
• Prepared various Scrum artifacts such as Burn down charts, burn up charts, product backlog charts, defects log, and PSPI log.
• Extensively used reporting tools like Rally, JIRA, Tableau, Version One, MS Office Suite, share point to create a visual representation of Data Analytics using Dimensions and Measures, MS Excel and IBM Cognos for BI reporting.
• Involved in web services using JSON for creating documents based on the business information using REST API. SQL Probing to check validity of existing data within the databases and to protect the systems from SQL Injection Attacks . Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries.
• Self-Motivated and Objective driven professional with excellent communication and Interpersonal Skills with a sound understanding of the balance that must exist between customer satisfaction and technical excellence.

Environment: - Agile-SCRUM, MS Visio, JIRA 6.3, MS Office 2013, Mockup screens, SharePoint 2013, HP QC 10, MySQL Server 2012, Erwin, HTML, Web Services, SOA, XML,, Eclipse, AJAX, JQuery, RTM, UML, JAD, SQL, MS-Office, MS Excel, MS Project, MS Visio, SDLC, Quality Centre, Windows 2000 Advanced Server, OBIEEE, ETL,

Confidential, New York, NY

Sr. Business System Analyst

Responsibilities:

• Gathered the requirements via JAD sessions, One - to-One interviews with Business stakeholders, Enterprise architect, analyzed the requirements and prepared Business Requirement Document (BRD) & System Requirement Specification.
• Worked with Subject Matter Experts(SME) to capture and understand the business requirements. Reviewed high - level requirements with business to prioritize and define scope of the project.
• Performed Gap and Cost-Benefit analysis to establish the significance of the enhancement for the project.
• Analyzed requirements by prioritizing and tracking to Business case. Took insights with active participation in document-reviews, plan setup, plan configuration and incorporated them in Business process re-engineering, Business process improvements, Business process modeling using activity diagrams and swim-lane diagrams.
• Worked with Product Owner to review the working demo of Potentially Shippable Product Increment (PSPI) in review meeting and helped deciding which features are done and satisfies the acceptance criteria
• Hands on Experience with JIRA for drafting the User Stories and managing the requirements.
• Experience in Creating Use-case scenarios and Sequence Diagrams using MS Visio for Client authentication.
• Created Mock-up Screens and Wireframes using UI Components such as Drop-down list, Check boxes for retrieving data from the user with client-side verification.
• Wrote SQL queries to document and integrate data from various sources for real time collateral monitoring.
• Assisted in Designing Conceptual and Logical Models to capture the entities existing in the system and the relationship between them using E-R Diagrams, keeping in mind the business requirements.
• Created Dimensional Model and helped the architect to select from different types of dimensions i.e. Conformed and Slowly Changing Dimensions, thereby converting user stories into dimensions.
• Reviewed Business Rules written for middle tier and validated XML schema for system data documentation including the requirement data document.
• Used ETL Process to map data from different sources to the target data-mart in IBM Cognos, Data Manager, thereby reporting and analyzing events and metrics.
• Assisted in Creating Data Mapping document for the application after finalizing the attributes and tables with business users.
• Documented REST API via JSON using documentation tools(Swagger), used Swagger Specification and converted it API documentation and used Plugins for integrating with JAVA.
• Reviewed existing stored procedures, supported application developers by tuning SQL queries for better performance.
• Worked with QA team to design and develop Test Plan, Test Cases, to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
• Assisted the QA team to develop the test plan and test cases to perform the testing and involved in Automated User Acceptance Testing (UAT) using Cucumber automation tool.
• Generated Business intelligence report for senior management using the Tableau reporting tool.

Environment: SDLC, Agile-Scrum, Wireframes, MS Office (MS Word, MS Excel, and MS PowerPoint), MS Visio, UML, JIRA, Data Manager v10.2, Web Services, SOA, SOAP, XML, HTML, Tableau, Cucumber, JSON, JAVA, UAT, XML

Confidential, New York, NY

Business System Analyst

Responsibilities:

• Served as a liaison between business and IT team, to research, analyze and validate business solutions to support the project objectives.
• Interacted with SME's in identifying and documenting business needs and created data flow, activity diagrams, and state transition diagrams using MS Visio, and collaborated with production team to identify and map in detail existing processes, identify system gaps and developed user stories that supported overall strategy, goals and objectives.
• Worked with the ETL, QA and the BI team to help them understand the data model and helped them in preparation of Data Element Mapping (Source to Target Mapping)
• Involved in Data mapping for the sell - side Order Management System (OMS), which does pre-trade, post-trade and transform electronic communication of pre-trade and trade messages of financial instruments.
• Worked on AML trade surveillance and compliance by interacting with compliance department and SME experts in the laws/act of compliances.
• Used SSIS to map the data in central data repository and created Data Mart for enhanced Data Management. Used SSRS for generating Data Analysis report.
• Assisted in UI designing and collaborated with User Experience team to build an interactive web application for better user experience.
• Analyzed the physical data model of securities trading system to create report mapping document.
• Coordinated JAD sessions with product owner especially with AML, Compliance and Risk team to analyze the application life-cycle, gather and define the key performance indicators.
• Was involved in extracting, analyzing, merging data from multiple internal and external sources using SQL.
• Drafted design documentations: Requirement traceability matrices (RTM), process, and data flow diagrams.
• Documented test plans and test cases and performed black box testing on the application like functional testing, smoke testing, regression testing, and UAT.
• Coordinate the UAT testing effort including (Front office, Middle office, Back office, Clearing and Booking), obtain sign off and log testing artifacts.
• Provided technical and procedural support for User Acceptance Testing. Tracked testing issues, maintained test matrix.
• Using SQL server management studio, designed various different T-SQL queries to analyze the data from internal & external sources.

Environment: Agile -Scrum, JIRA, SQL server, TM1, MSOffice, MS Project, XML, MS Visio, Share Point, UAT, SQL

Confidential

Business System Analyst

Responsibilities:

• Elicited business requirements for the project using interviews, document analysis, surveys, site visits, use case scenarios and used standard template of the organization to develop requirements.
• Derived Functional Requirement Specifications (FRS) based on User Requirement Specification URS. Understand and articulate business requirements from user interviews and then convert requirements into technical specification.
• Conducted Risk Analysis to identify the risks associated with developing the new system, and formulated a Mitigation Plan to eliminate or reduce risks of high severity and major financial effects.
• Assisted in reviewing test plan based on requirements and defect tracking using Quality Centre.
• Conducted Joint Application Development (JAD) sessions with Subject Matter Expert (SME) sessions.
• Reviewed the business rules with the developing team and modified based on Technical Specification and software requirements specifications (SRS) using Pega Rules Process Commander
• Maintained and build relationships with stakeholders to ensure their performance management and business analysis needs are understood and supported.
• Elicited and documented Functional requirements, business requirements AS - IS and TO-BE business process models.
• Prepared Requirement Traceability Matrix and interacted with QA team to ensure quality of software
• Analyzed and gathered requirements for preparation of Business Requirement Document (BRD), Functional Requirement Document (FRD) and System Requirement Specification (SRS).
• The methodology used for the project was Waterfall. Provided clear and consistent information about project status both internally, IT team and stakeholders.
• Responsible for creating UML diagrams (Use Cases, Activity Diagram and Class Diagram) in order to capture the dynamic behavior of different applications.
• Documented REST APIs and SOAP web services with the URI and description of methods.
• Developed Understanding of SAS for Data profiling and Data modeling.
• Developed Use Cases, Activity Diagrams and Sequence Diagrams for a clear understanding of the vision document.
• Worked Extensively on SQL Server database to extract data and build Business reports
• Designed Test Plans and Test Cases for User Acceptance testing (UAT) with the help of QA teams.
• Generated Business intelligence report for senior management using the Tableau reporting tool

Environment: SDLC Waterfall, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS Project, MS Visio, Pega Rules Process Commander, Tableau, UAT, SQL, SAS, SOAP

Confidential

Jr. Business System Analyst

Responsibilities:

• Worked on multiple projects and facilitated meetings with project stakeholders from all levels.
• Analyzed user problems, including automated and manual business processes and identified, researched, investigated, defined and documented business processes for the system.
• Followed the UML based methods using MS Visio to create Business flow diagrams, Use Case diagrams, Activity diagrams, Sequence, and Collaboration Diagrams.
• Participated in Joint Application Development (JAD) and Rapid Application Development (RAD) Sessions for communicating and managing expectations.
• Produced System Diagrams, Business Requirements, Functional Specifications, Workflows and other documentation as required for Project Analysis, Planning, Design and Development.
• Addressed and documented risks, dependencies, policies and procedures with support of the appropriate Technical and Operations resources.
• Responsible for on boarding clients and managing the overall client relationship.
• Conducted Financial Needs Analysis and Risk Profiling for the customers in the portfolio.
• Worked closely with clients for creation and implementation of their financial plans.
• Monitored financial market trends to ensure that plans are effective, and to identify any necessary updates.
• Researched and investigated new investment opportunities to determine relevance for clients.
• Conducted seminars and workshops on financial planning topics.
• Reviewed various business processes, identified risk factors & provided feedback to policy team.
• Identified and analyzed errors in Retail Banking system Finacle and worked closely with Project management team to get the same rectified.
• Kept a check on various issues pertaining to service standards and ensured regulatory compliance as regard to internal and statutory audits.
• Ensured adherence to standard processes & reported any deviation observed to combat fraud at an initial stage.
• Provided periodic reports to senior management using dashboard reports and presentations.

Environment: SDLC, MS project, MS Visio, UAT, SDLC, MS Office tools