SUMMARY:

• Proactive, and result oriented Sr. Business Systems Analyst with 8 years of experience in supporting business process including research, analysis, review, development, implementation, testing, maintenance and monitoring, acting as a liaison between financial institutions and IT groups.
• Extensive experience in Software Development Life Cycle (SDLC) methodologies like Waterfall, Agile (Scrum, XP, Kanban, TDD) and Hybrid of Waterfall - Agile methodologies and sound knowledge of SAFe with the ability to work with self-managing, self-organizing, and cross-functional teams of the organization. Good understanding in building, maintaining Responsible, Accountable, Consulted and Informed(RACI) matrix.
• Proficient in networking with individuals at various levels while organizing, conducting and facilitating elicitation sessions such as Brainstorming, Survey/questionnaires, one-one and Group interviews, Focus groups, Reengineering, Document Analysis and JAD sessions with Subject Matter Experts (SME’s) as well as external stakeholders to document decisions regarding future state of the business processes.
• Adept in conducting Feasibility Analysis, GAP analysis, SWOT analysis, Impact Analysis, Risk Management Procedures, Cost-Benefit Analysis, Root cause analysis to map the compatibility of the new system with the requirements and the development of Business Plan, Standard Operating Procedures, Request for Proposals.
• Proficiency in creating various documents including the Business Requirements Document (BRD), Functional Requirement Document(FRD), Systems Requirement Specification(SRS), Strong experience in tracing requirements by Requirement Traceability Matrix (RTM) using and testing documents using MS Word, MS Excel; managed the documents using MS Share point.
• Extensive experience in Unified Modeling Language (UML) diagrams such as Use Case, Activity, Sequence using Rational Rose and MS Visio. Experience in workflows, dataflow diagrams, wireframe and mockups.
• Solid understanding of Database concepts like Data Warehousing, Data Structures, Star and Snow-flake Schemas and ER Modelling and OLTP, OLAP, Business Intelligence using IBM Cognos.
• Proficient at creating Data Mapping Document using Informatica and identifying basic transformations to cleanse the data and improving Data Quality.
• Performed SQL queries using different functions like select, joins, view, unions, group by and aggregate functions to extract data from different databases (Oracle, SQL Server) for timely reporting and validation.
• Experience in developing Test plan, Test scenario, Test cases, in manual and automated test environments.
• Knowledge of Testing Life Cycle, created and assisted in test plans, test scenarios and test cases using MS Word, MS Excel, JIRA. Assisted in Black Box testing, Functional and Non-Functional Testing, Integration Testing, Regression Testing, Performance Testing and User Acceptance Testing.
• Conducted User Acceptance Testing(UAT), manual testing using Test Lab in HP Quality Centre (HP QC).
• Comprehensive understanding of Web-Services (and their documentation) like REST and SOAP Application Programming Interface (API) and XML, WSDL and UDDI, using internet protocol suite like HTTP under Three-Tier Architecture and Service Oriented Architecture (SOA).
• Assisted in project meetings with stakeholders, UX team, developers to gather and prioritize requirements, assign and follow up on deliverables, and address open questions to enable projects to move forward.
• Successful in translating business requirements and user expectations into detailed specifications employing
• MS Excel and tools like JIRA and HPALM; content management using TFS.
• Worked extensively on MS Excel, MS Project, SharePoint, MS Visio, JIRA and Confluence.
• Knowledge in entering various requirements in HP Application Lifecycle Management (HP ALM).
• Extensively used reporting tools like Tableau to create visual representation of Data using Dimensions and measures; pivot tables using MS Excel and IBM Cognos for BI reporting.
• Proficiency using windows-based applications including MS Office applications such as MS Word, MS Excel, MS PowerPoint, SharePoint and Access, working Knowledge of MS Project.
• Professional Domain knowledge of Banking with an aptitude to learn new domains and strong understanding of Credit Cards, Retail Banking, Account Transactions, Wire Transfers, Bill Payment, Risk, Investment and Operational Risk Banking, Payment processing systems.
• Knowledge in sanction lists, Regulatory Compliances, Basel Accords, Anti Money Laundering (AML), Bank Secrecy Act (BSA), AML-Know Your Customer, Customer Due Diligence, Comprehensive Capital Analysis and Review (CCAR), Politically Exposed Persons (PEP), OCC, OFAC and Dodd-Frank Act, Basel Accords.
• Self-starter with ability to work under tight deadlines and multi-task to meet business objectives, schedules, communicating and coordinating with Software Developers, Solution Architects and QA Team.
• Excellent in understanding client requirements, summarizing client needs, and translating into technical options and solutions that meet end-user business needs.

TECHNICAL SKILLS:

Banking knowledge: Anti- Money laundering(AML), Know Your Customer(KYC), Customer Due diligence (CDD), CCAR, Dodd-Frank Act, CCAR, OFAC, OCC, Basel Accords, USA Patriot Act

Database/Cloud: MS Access, SQL, Oracle, Hadoop, Hive, HBase, HDFS, Excel Pivot Tables, MySQL

Project Management Tools/Methodology: Software Development Life Cycle(SDLC), Agile, Waterfall, Hybrid model SAFeMS Project, MS Share Point, JIRA, Scrum ban

Requirement Management: MS Office, JIRA, Confluence, HP ALM, Version One

Reporting Tools: Tableau, MS office Suite, SSRS (SQL Server Reporting Services), IBM Cognos

Office Tools: MS Access, MS Word, MS Excel, MS PowerPoint, MS SharePoint, MS Project, MS Visio

Modeling Tools: Rational rose, MS Visio, Balsamiq Mockups, Lucid Chart, UML

Data Warehouse: Data Modelling, Data Marts, OLTP, OLAP, Data Mining, Slicing/Dicing, Drill Up/Drill Down, Pivot, Informatica Power Centre

Testing Tools: HP QC / ALM, Load runner, SOAP UI and Cucumber, Bugzilla

ETL Tools: Informatica, Tableau, SQL Server Management Studio.

Web Technologies: XML, HTML, CSS, JSON, Java script, SOAP, REST, Ajax, WSDL, XSD

Languages: Java, SQL, HTML, XML, C.

Operating Systems: Windows 7,8,10, XP/Vista/Mac OS X

WORK EXPERIENCE:

Confidential, Wilmington, DE

Sr. Business Systems Analyst

Roles and Responsibilities:

• Ensured Customer Identification Program (CIP), Customer Due Diligence(CDD) and Enhanced Due Diligence(EDD) policies are followed based on KYC norms and reviewed its monthly reports for accounts with suspicious or unusual activity. Conducted AML investigations and Suspicious Activity Reports (SAR) and maintained a track of all the reports.
• Elicited requirements for reporting on potential illicit activity that includes KYC, CDD, Currency Transaction Reporting (CTR), Suspicious Activity Report (SAR), watch-list filtering.
• Responsible for ensuring all required AML Regulatory requirements for existing clients are still in place. Liaise with Clients, Front Office, Legal and Operations as necessary as part of the AML enhancement process.
• Worked on Agile Scrum methodology. Acted as a Liaison between the business community and IT development teams to resolve functional and technical issues related to business applications.
• Conducted extensive GAP analysis by identifying AS-IS and To-BE process models and process flows. Elicited requirements by interacting with the banking business users using JAD sessions, process analysis, business rule analysis and structured interviews, focus groups, document analysis with direct clients.
• Performed feasibility study along with SME’s and Project Manager(PM) by interacting with primary stakeholders in identifying various dependencies and constraints for business requirements.
• Created documents incorporating components of both Business Requirement Document(BRD/HLD) and System Requirement Specification(SRS/LLD), to keep track of work for efficient management using MS Word.
• Assisted PM in creating Work Breakdown Structure (WBS), project proposal, project charter, RACI matrix, Risk Register.
• Worked with Scrum Master, Product Owner, Agile coach and development teams throughout planning, design, development, testing, and implementation of feature product releases.
• Conducted User Story Writing Sessions to decompose FRD into User Stories and assisted PO in determining Acceptance Criteria and the Definition of Done (DoD) for Potentially Shippable Product Increment (PSPI).
• Used Confluence tool to manage requirements which came out of design sessions and to track action items.
• Created Use Case Diagrams, Activity and Sequence Diagrams using UML modeling tools like MS Visio.
• Created UI Mock-ups using Balsamiq software to help developers visualize the UI components. Handled requirement churn during the project by performing Impact Analysis.
• Scripted business rules for the web service and assisted in drafting agreements for various web methods in XML.
• Assisted developers by creating data mapping document in MS Excel and created business rules for the client-side validations. Responsible for creation of ER diagrams like Conceptual and Logical diagrams and Collaborated with database developer in developing physical diagram for Knowledge Center that stores Alerts.
• Performed SQL queries and used stored procedures involving DML statements to reduce network lag.
• Documented and tested REST API using different methods GET/POST/DELETE. Gathered information about the Request, Response, types of parameters of Application Programming Interface (API). Mapped the designed URLs for the RESTful APIs to the business requirements and operations. Used Service Oriented architecture (SOA).
• Used Swagger for performing REST API documentation for both JSON and YAML as per open API specification.
• Executed system test plans, test cases and test data on MS Excel to perform system testing, smoke, regression testing, black box testing, sanity testing and logged down defects and systematically managed them in JIRA. Assisted the developer in TDD.
• Extensively involved in the User Acceptance Testing(UAT) to ensure the requirements and functionality of the system was in accordance to the users and their feedback was incorporated using Cucumber.
• Generated various fraud and risk reports from Bloomberg using Tableau and MS Excel for the end users.
• Reviewed defect reporting and resolution in HP Quality Centre to track project progress against schedule.

Environment: Agile - Scrum, Windows 8/10, Microsoft Office Suite, SOA, Microsoft Visio, Apache Hadoop, Rational Requisite Pro, Confluence, JIRA, SharePoint, Tableau, RESTful API, HP QC, SQL, XML.

Confidential, New York City, NY

Sr. Business Systems Analyst

Roles and Responsibilities:

• Gathered CCAR PPNR and supplementary metrics (FY 14) forecast from various business units.
• Assisted in analyzing CCAR (FR Y-14A/Q/M & 9C schedules of the Income statement and balance sheet) report requirements which provided seamless and flexible data drill-down to the exposure level details with flexible Report Position Adjustments.
• Supported CCAR and BASEL data acquisition teams to validate and reconcile data coming from various systems.
• Assisted in developing good practices for risk modeling procedures related to CCAR/DFAST.
• Effectively gathered requirements based on the CCAR regulation for Financial Statements, Interest Rate, Credit Ratings by JAD Sessions, Structured Interviews and Questions/ Surveys, Requirement workshops.
• Interacted with the SME's and Technical Architects to analyze the data extracts from legacy systems and determine the element source, format and its integrity within the system.
• Performed GAP analysis, identified AS-IS and TO-BE business processes and technology, potential pitfalls, risks, and issues. Drafted and maintained BRD, FRD, and RTM.
• Conducted User Story Writing Sessions to decompose FRD into User Stories and assisted PO in determining Acceptance Criteria and the Definition of Done (DoD) for Potentially Shippable Product Increment (PSPI).
• Assessed Business Requirements and categorized them into high level and low-level use cases and created Activity, State Chart Diagrams (UML) using MS-Visio. Assisted UI/UX team in creating mock-ups, wireframes using Balsamiq screens.
• Assisted in performing source (digital banking discipline) to target (enterprise-level data reports) data mapping based on the common metadata structure. Assisted the Data Analyst in data modeling, data analysis related to Credit Risk. Worked with the Database team to assist in implementing all stages of development processes including extraction, transformation, and loading (ETL) data from various sources into Data warehouse and Data Marts using Informatica Power Center Designer.
• Assisted in implementing basic SQL JOIN queries for QA testing and validated generated reports. Created SQL queries in RDBMS to verify, validate the technical project requirements/integration mappings.
• Assisted in loading the data into database tables using SQL*loader from TXT and CSV files. Involved in writing stored procedures, views, cursors and triggers using SQL Server. GIT was used for source code management.
• Used SOAP UI to test and document SOAP API using methods such as GET/POST/DELETE/UPDATE in XML by implementing Service Oriented Architecture(SOA).
• Assisted in using Tableau for BI reporting as data visualization tool to communicate the information clearly and efficiently through the statistical graphics and to create executive dashboards, weekly reports, monthly reports on the status of the key business measurements.
• Worked extensively in JIRA to upload Requirements, Test plans, Test Steps, Log defects.
• Assisted the QA team in writing and maintaining regression testing and functional testing using a data-driven framework. Assisted QA team to write Gherkin automation test scripts to execute in Cucumber and to create Cucumber feature files comprising of various Test Scenarios and definitions for BDD. Engaged User Acceptance Testing (UAT) and recorded the observations.

Environment: Waterfall-Scrum Hybrid, Eclipse, SOAP, Tableau (v-9.0), MS Visio, Oracle 12c, JIRA, SQL, Confluence, GIT, MS Office suite, Informatica Power Centre v9, SOA, Cucumber 2.0, HTML5.0, CSS 3.0, Java.

Confidential, San Antonio, TX

Sr. Business Systems Analyst

Roles and Responsibilities:

• The methodology used for the project was Waterfall and had a deep understanding about the requirement gathering. Provided clear and consistent information about project status both IT team and stakeholders.
• Understood the processes by interacting with the stakeholders and conducted document analysis and performed GAP analysis to assist the Project Manager in planning the transition.
• Conducted structured walkthroughs using workflow diagrams to identify, understand and conduct process analysis for the business process improvement (BPR).
• Conducted root cause analysis and SWOT analysis to fully understand the current state of the system.
• Interacted with users and stakeholders to Identify business needs, evaluated solutions for business problems.
• Elicited business requirements by participating in focus groups, brain storming, JAD sessions, interviewing business users and stakeholders, conducting one to one sessions and consulting existing systems documents. Worked closely with Project Manager for any change requests and helped SME’s to do Impact Analysis.
• Prepared Business Requirement Document (BRD/HLD) and drafted Systems Requirement Specification document (SRS/LLD). Analyzed, modified and validated these artifacts.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams. Proficient in creating Use Cases, Sequence Diagrams, Activity Diagrams, Use case diagrams and Class Diagrams
• Created dataflow diagrams, data mapping from source to target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Developed Conceptual and Logical ER diagrams for the database. Created Data dictionary.
• Identified Data sources from internal systems, external systems, silos on legacy systems.
• Understood problem definition through interviews with Data and Enterprise architects, Solution advisors.
• Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries
• Integrated various OLTP to the OLAP by using SSIS/SSAS as an ETL tool and used SSRS as reporting tool.
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data. Performed Data Mining to find correlation and pattern in existing data.
• Used ETL to map data and assemble data repository and assisted in creating data marts with Bus Architecture.
• Used Data Center for Integrating Legacy system and supporting in decision making. Identified Source systems for banking data profiling of the legacy system.
• Assisted in implementation of Enterprise DW with individual data marts to address areas of business interest.
• Assisted with SNOW-flake schemas in the Dimensional model architects to providing business rules.
• Assisted and worked with QA team to design and develop Test Plans and Test Cases.
• Performed User Acceptance Testing (UAT) and assisted in Functional Testing and Regression Testing.
• Worked on RESTful APIs, data mapping for the REST API's, analyzing their Request-Response XMLs. Used Swagger for performing REST API documentation for both JSON and YAML as per open API specification.
• Assisted QA team to write Gherkin automation test scripts to execute in Cucumber and to create Cucumber feature files comprising of various Test Scenarios and definitions for BDD.
• Involved in using IBM Cognos for effective visual representation of Business Intelligence(BI) to facilitate expenditure tracking using various matrices critical to decision making.
• Assisted the Project Manager in setting realistic project expectations, in evaluating the impact of changes. Developed timelines for project delivery, and managed projects and resources to successful completion.

Environment: SDLC Waterfall, SOA, RESTful APIs, Cucumber, Eclipse, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS Project, MS SQL, SSIS, SSRS, SSAS, HP ALM.

Confidential, Indianapolis, IN

Sr. Business Analyst

Roles and Responsibilities:

• Facilitated the process of capturing and documenting the business/system requirements including functional and non-functional requirements, use cases, business process redesign as needed for enhanced technologies using document analysis, one to one interviews, prototyping sessions with the banking business users.
• Conducted JAD sessions with management, SME, users and other stakeholders for open and pending issues.
• Translating high-level business requirements into functional specifications for the development and technical teams, clarifying and managing changes to such specifications and documented BRD, FRD, RTM.
• Assisted the Project Manager in creating proposals and project budget allocation and worked on Gantt Chart, Project charter and Work Breakdown structure(WBS) using MS Project.
• Conducted User Story Writing Sessions to decompose FRD into User Stories and assisted PO in determining Acceptance Criteria and the Definition of Done (DoD) for Potentially Shippable Product Increment (PSPI).
• Created high and low fidelity wireframes and mockup using Balsamiq screens in requirements gathering phase.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
• Scheduled meetings with developers and testers to collaborate resource allocation and project completion using MS Project. Reviewed the system testing plan/results from requirements perspective.
• Tested and logged defects using JIRA. Assisted in the implementation of Confluence as the documentation space of choice, which allowed us the flexibility to integrate seamlessly with JIRA and forge a collaborative workspace.
• Assisting Project Manager in developing project schedule/scope and creating various status reports.
• Prepared Requirement Traceability Matrices (RTM), managed change requests effectively throughout SDLC.
• Provided inputs to create, maintain SQL queries. Involved in fetching and displaying data using SQL queries. Effectively executed exporting table data in MS Excel and flat files to SQL Server. Testing and executing SQL queries to access data from database.
• Worked with RESTful API's that allow sophisticated, effective and low-cost application integration. Used gap analysis to do the API mapping document which is most essential in determining the request and response of API's for any business rule requirements or changes to fulfil the scope of a project.
• Used Swagger for performing REST API documentation for both JSON and YAML as per open API specification.
• Documented test cases, test scenarios, test scripts, test plans. Assisted in performing functional testing, performance testing and end to end testing. Assisted in QA phase planning, coordination and implementation of QA strategy for the overall project. Extensively involved in User Acceptance Testing (UAT). Assisted the developer in TDD.
• Used SharePoint for Content Management and Document Management.
• Used Tableau to generate dashboards, statistical reports and created a portal using the Tableau JavaScript API
• Analyzed and accurately identified business risk, baseline and deliverables.

Environment: MS Visio, Enterprise Architect, SOA, RESTful API, SharePoint, Advanced MS-Office (MS Excel, MS Word, MS PowerPoint), SQL queries, UAT, ER Diagrams, JAD sessions, Tableau, Waterfall- Scrum Hybrid, Balsamiq screens.

Confidential

Business Analyst

Roles and Responsibilities:

• Assisted and worked with Project manager in creating and assigned task through Work Break-down Structure(WBS). Worked in Waterfall as System Development Life Cycle (SDLC).
• Gathered requirements using JAD, document analysis, focus groups from key stakeholders, customers and SME’s.
• Worked closely with the development team to verify that business needs are fulfilled, and deliverables are produced within specified budget, quality and time.
• Created high and low fidelity wireframes and mockup using Balsamiq screens in requirements gathering phase.
• Defined the context of the system by creating various Use Cases for the development system requirements specifications encompassing Functional and Non-Functional requirements.
• Developed UML Diagrams for modeling static and dynamic aspects of Online Banking System.
• Created Requirements Traceability Matrix (RTM) using HP QC tool.
• Worked closely with Project Manager for any change request and helped to do Impact Analysis.
• Helped creating and modifying SQL queries regarding the requirements. Developed data maps for retrieval of data from existing account systems and outlined measures for accessibility and transmission of information.
• Worked with the QA team for designing Test Plan, Test Cases, UAT and Regression Testing.
• Developed plans for verification and validation of requirements at all levels so that developed software successfully fulfilled user expectations and business needs and the users are satisfied with it.
• Created ad-hoc reports using Tableau, MS-Excel and Pivot tables to do the calculations.
• Conducted Project related presentations to senior management and the team.

Environment: Waterfall, Microsoft Office Suite, SQL, UAT Testing, Tableau, HP QC, Windows XP/7, Microsoft Visio, Balsamiq screens.

Confidential

Business Analyst

Roles and Responsibilities:

• Worked closely with Business stakeholders/SME to map the expectations to the delivery capabilities.
• Assisted in Senior Business Analyst in eliciting requirements through JAD sessions, Interviews and workshops.
• Closely interacted with designers and software developers to understand the application functionality and flow.
• Documented user requirements and prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from stakeholders and used Waterfall methodology in the project.
• Assisted in gathering requirements for the Graphical User Interface(GUI) screens and designing.
• Created high and low fidelity wireframes and mockup using Balsamiq screens in requirements gathering phase.
• Used MS Visio for flow-charting process model and created Use Cases, Activity and Use Case Diagrams
• Responsible for working with the manager, other users and creating Work flow diagrams as per the data analysis.
• Work with the Technical Analyst and development team to ensure that they understand the specifications.
• Extensively involved in coming up with test specifications, test manuals for the application. Assisted the QA team in reviewing the Test Plans and Test Cases to perform functional and system testing.
• Developed Requirement Traceability Matrix and prepared test data for User Acceptance Testing. Assisted developer in TDD.
• Monitored performance testing results for several modules within the application.

Environment: Waterfall, Microsoft Office Suite, Balsamiq, Microsoft Visio, SQL, Windows 2000/XP.

Confidential

Jr. SQL Developer

Roles and Responsibilities:

• Analyzed different user requirements with specifications for the various database applications.
• Involved in developing Class Diagram, Sequence Diagram and Activity Diagrams using MS VISIO.
• Documented and maintained database system specifications, diagrams and connectivity charts.
• Involved in design phase of the development life cycle to design the database prototypes to meet Business Requirements by using MS Access, My SQL workbench.
• Monitored the performance of SQL database and checked on the execution time. Identified Primary Keys in all the tables at the design time. Created functions to provide custom functionality as per the requirements.
• Performed SQL queries operation such as DML and DDL commands for data extraction and manipulation under supervision of Lead Developer. Tested and implemented stored procedures and queries.
• Created Test plans, Test scripts, test scenarios to perform end-to-end testing.
• Performed unit testing using Junit for each block of code and provided the feedback to QA team.
• Analyzed monthly/quarterly performance against plans and forecast and recommended corrective actions.

Environment: JAVA, Eclipse, MySQL, Junit, Java Script, MS Word, MS Power Point, MS Visio, MS Excel, SQL Workbench, JDBC.