SUMMARY

• 8+ years of experience in analysis of large scale business system, predominantly in Finance Sector.
• Experience in working with different Software Development Life Cycle (SDLC) forms like Waterfall and Agile methodologies, for example, Scrum - Waterfall (Hybrid), Kanban and Scrum.
• Comprehensive knowledge of OCC, OFAC, FACTA, FFIEC, FinCEN, SOX and GLBA compliances and integration.
• Authoring Narrative Use Cases, Functional Specifications, and Technical Specifications, reporting and testing.
• Experience in working with risk management team in Risk analysis, risk management and risk mitigation.
• Elicited the requirements using techniques such as survey/questionnaires, Interview sessions, Brainstorming sessions, Focus group sessions, Requirement workshops, Root Cause analysis, Document analysis, and Cost Benefit Analysis and Joint Application Development (JAD) sessions with internal as well as external stakeholders.
• Experience and Accomplished in Business Analysis, Data Analysis, Quality Analysis and Project Management.
• Expertise in creating Unified Modeling Language (UML) diagrams like Use Cases, Activity diagrams, Sequence Diagrams, Class diagrams, Data Flow Diagrams, ERD diagrams converting them into functional requirements.
• Efficient in Prototyping Application User Interfaces using Wireframes and Mock-ups with focused attention to detail in enriching User Experience and User Interaction.
• Facilitated Change Request Management, testing and created and validated Business Requirements documents (BRD), Use-Case Specifications, and System Requirements Specifications (SRS), and verified Requirement Traceability Matrix (RTM).
• Experience in writing User Stories following the INVEST criteria, experience in defining acceptance criteria and prioritizing User Stories based on MOSCOW, KANO. Experience in estimating User Stories using different estimation techniques such as T-Shirt Sizing, Planning Poker, and Relative Mass Value.
• Ability to manage change, track defects and do defects analysis using tools such as JIRA, RALLY and ClearQuest
• Communicate project status and provide timely escalation of issues to the Technology Project Manager (Application Manager, Demand Manager, Portfolio Manager) and ensure timely notification and escalation of possible issues/problems, options and recommendations for prompt resolution.
• Excellent working knowledge of RDBMS such as Oracle, MS SQL Server, MS Access and skilled at writing SQL DDL and DML queries to create Tables, Views, Stored Procedures, Functions, Triggers etc. to retrieve reports.
• Proficient in Database management system, with queries such as Update, Create, Selection. Expert in query optimizations for Joining and Projection.
• Experience with Data warehouse architectures, (Centralized, Federated and Hub and Spoke) experience with ETL processes, cleaning and cleansing data, Data Table structures, Schemas, Data Marts and OLAP operations, for example, Roll-up, Drill-down, cut, and dice and rotate
• In depth experience in Requirements gathering, Functional and Technical design docs, Data Cleansing and Process Flow diagrams, Data Analysis, Linear and conceptual data modelling.
• Thorough understanding of n-tier architecture, understanding of request and response flow. Understanding appropriate technologies for business requirements (SOAP, REST, AJAX, JSON, and XML). Gathered requirements for Client-Side Validation, and Server-Side Validation. Experience in Testing and documenting APIs using Postman and Swagger.
• Experience with Finance specific messaging protocols and formats such as SWIFT, FpML and FIX.
• Understanding of how Business software applications use the SWIFTNet Link (SNL) application programming interface (API) to access and use SWIFTNet services.
• In depth knowledge of User Acceptance Testing (UAT) with experience in creating test cases and test plans & release skill sets. Assisted the Quality Assurance (QA) team to perform Black Box, White Box, Alpha, Sanity, Smoke, GUI testing, Functionality, Regression, System, Unit, Web Service, Performance and Volume testing.
• Experience in Data Warehousing Projects, performing GAP Analysis, creating Software Specific Documents, and assisting the database and security team in back-up and securing the company’s digital artifacts.
• Expert in analyzing and reporting using tools like Tableau, IBM Cognos, Google Analytics. Oracle BI, SSRS.
• Excellent Analytical, Problem solving, Communication and Documentation skills. Self- motivated, Proven leadership capabilities and Time management skills

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business System Analyst

Responsibilities:

• Worked in Scrum environment, where major responsibility included assisting product owner and development team in refining and prioritizing top items in product backlog to be pulled in sprint backlog.
• Worked with the corporate the Cyber Security, Compliance and Fraud monitoring team, and the technical team to understand the end to end process, data security and the compliances documents such as PCI DSS, FACTA, Suspicious Activity Reporting (SAR).
• Interacted with stakeholders and elicited the requirements using different elicitation processes, such as interviews, brainstorming. Conducted JAD session with the SMEs to understand better about the requirements
• Assisted the Risk Manager in Risk Assessment, Management and Mitigation.
• Analyzed business processes and identified process areas where existing data privacy procedures require change.
• Performed a GAP analysis between the legacy system and the imminent system.
• Constructed various UML diagrams such as Use Case diagrams, Class Diagrams, Activity Diagram, by working with the system architect, and development team lead, using tools such as Smart Draw and Microsoft Visio.
• Maintained the required traceability matrix (RTM) for tracking the origin of the project status using Confluence.
• Used JIRA and Confluence for defects tracking and organizing and collaborating teams for meetings and emails.
• Communicate project status and provide timely escalation of issues to the Technology Project Manager (Application Manager, Demand Manager, Portfolio Manager) and ensure timely notification and escalation of possible issues/problems, options and recommendations for prompt resolution.
• Assisted ScrumMaster and Product owner in handling team related impediments.
• Developed and managed implementation and training documentation for new applications for business users as well as technical team for IT support
• Build proofs-of-concept (POC) for potential new solutions and technologies.
• Facilitated meetings with business managers, and subject matter experts for analysis of the project parameters.
• Worked with ETL developers by reviewing and maintaining up-to-date source to target data mapping document.
• Used SQL queries to insert, update, and join data, to validate and modify the database.
• Assisted the Quality Assurance team in performing functionality testing, reliability testing, and utility testing on the web service APIs for FIX, Bloomberg B-Pipe, Reuters web-services using tools Postman.
• Testing and documenting different SWIFT category messages with understanding of how Business software applications use the SWIFTNet Link (SNL) application programming interface (API) to access and use SWIFTNet services.
• Assisted the QA team in writing test cases, logging defects and creating an error repository to support them in testing, tracking defects and systematically manage defects. Assisted the team during continuous integration.
• Assisted the Quality Assurance team in creating manual test cases and plans also in automated testing in Functional System Testing, Integration Testing, and Regression Testing, using Selenium and assisted in performing User Acceptance Test using the test cases before releasing the application.
• Designed and published visually rich and interactive Tableau workbooks and dashboards for further analysis.

Environment: Scrum, .Net Framework 4.5, MS Visual Studio 2012, SQL Server, MS Visio, Postman, Tableau, Selenium, Cucumber, REST, JIRA, Confluence, Windows OS, SWIFT, FIX.

Confidential

Business System Analyst

Responsibilities:

• Functioned closely with the corporate business team, control teams and technology teams to understand the end to end process, data security and Financial Compliance documents (MiFID II), FRTB, JFRS, IFRS, SEC and GAAP.
• Interacted with stakeholders and elicited the requirements using different elicitation processes, such as interviews, brainstorming. Conducted JAD session with the SMEs to understand better about the requirements.
• Created, analyzed, and reviewed the functional and technical artifacts such as Business Requirement Documents (BRD), Functional Requirement Documents (FRD), and Software Requirement Specifications (SRS).
• Build proofs-of-concept (POC) for potential new solutions and technologies.
• Facilitated meetings with business managers, and subject matter experts for analysis of the project parameters.
• Maintained the required traceability matrix (RTM) for tracking the origin of the project status using Confluence.
• Used RALLY and SharePoint for defects tracking and organizing and collaborating teams for meetings and emails
• Acted as a client liaison to review priorities and manage the overall client queue. Provided consultation services to clients, technicians, and internal departments on basic to intricate functions of the applications.
• Identified business directions & objectives that may influence the required data and application architectures.
• Worked with ETL developers by reviewing and maintaining up-to-date source to target data mapping document.
• Used Test Director, QTP, Load Runner for Test management, Functional, GUI, Performance, Stress Testing
• Used SQL Server 11.0 as a backend database, to insert, update, and join data, to validate and modify the database.
• Worked with SOAPUI4.5 to perform load test, reliability test, utility test and document and ensure that proper business requirements and validations existed in the SOAP API.
• Testing and documenting different SWIFT category messages with understanding of how Business software applications use the SWIFTNet Link (SNL) application programming interface (API) to access and use SWIFTNet services
• Assisted the QA team in writing test cases, logging defects and creating an error repository to support them in testing, tracking defects and systematically manage defects. Assisted the team during continuous integration.
• Assisted the Quality Assurance team in creating manual test cases and plans also in automated testing in Functional System Testing, Integration Testing, and Regression Testing, using Selenium and assisted in performing User Acceptance Test using the test cases before releasing the application.
• Developed Tableau based Wealth Advisory dashboards incorporating Waterfall charts, Heat maps and Histograms for relationship managers to effectively advise clients on asset allocation and tax/estate planning strategies.

Environment: MS Visio, Mock Up, SQL Server 11.0, SOAPUI 4.5, MS. SharePoint, MS Office, Selenium, SSRS 2012, Star-UML, JIRA, Java, Angular.js, Spring MVC, Apache JBoss, Swagger, Cucumber, Post Man, Swagger, JSON, XML, SWIFT, FIX.

Confidential

Business System Analyst

Responsibilities:

• Worked in Scrum-Waterfall methodology assisting senior Business analyst for gathering requirements, business analysis, key stakeholders, customers and SME’s to define the scope and requirements
• Worked closely with Risk Analysts for facilitating Margin Mechanics with compliances like ESMA, SOX, FINRA, and CFTC.
• Interacted with Risk Managers and Project Architects along with the Business Owners, to gather client specific business requirements and translate them in a various business artifact for the technical team.
• Interacted with stakeholders and elicited the requirements using different elicitation processes, such as interviews, brainstorming. Conducted JAD session with the SMEs to understand better about the requirements.
• Created Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams using MS VISIO.
• Performed Marking to Market (MTM) as a part of Margin Mechanics by periodically adjusting the margin account by adding or subtracting funds based on changes in market value to reflect the investor’s profit or loss.
• Performed Collateral Management to control margin accounts.
• Determined Net Asset Value (NAV) of Collateral placed and updated on periodic basis.
• Prepared and reviewed documents like functional requirement documents using XML, product backlog, sprint backlog, user stories, project reports and status reports.
• In depth experience in Agile methodology wherein I participated in various sprint and scrum meetings.
• Represented process flows by creating activity and sequence diagrams, coming up with pre and post conditions, performance estimates, swim lane diagrams and business rules.
• Performed data validation with use of SQL queries and functionalities like cardinalities, joins, views, aliases, aggregate etc and made reports using SSRS.
• Designed datawarehouse on Power center using extraction, Transformation and Loadingdatafrom heterogeneous source systems into the target MY SQL database
• Involved in User Acceptance Testing phase providing them with user guide user manual and was responsible for creating Requirements Traceability Matrix to track the requirements with different functional areas.
• Testing and documenting different SWIFT category messages with understanding of how Business software applications use the SWIFTNet Link (SNL) application programming interface (API) to access and use SWIFTNet services
• Involved in developing the test strategy document and assisted in developing test plans, test case objectives and test Helped in developing QA Test plans for Functional, Integration and System Testing. Performed Black Box Testing. Assisted in GUI testing, smoke testing, regression testing cases.
• Developed Test Scenarios for black box testing scenarios for Collateral and Margin accounts to check whether the actions and dependent functions were reflected properly.
• Involved in generation of test data inputs for both positive and negative data to enhance Recovery or Fail-over testing.
• Coordinated work plan between project manager and client with Microsoft Project
• Established Incident Reporting and Change Control procedures using ClearQuest.
• Provided technical leadership and expertise in reorganization of a complex End-to-End Testing effort and performed System analysis and organizational review of existing QA process.

Environment: Agile, Microsoft Office Suite, Microsoft Visio, UML, XML, Windows Vista, SQL Server 16, Sybase Power Designer, Microsoft Project, IBM Rational Clear Quest, SWIFT, FIX.

Confidential

Business System Analyst

Responsibilities:

• Facilitated JAD sessions and conducted interviews for eliciting requirements for various Business Intelligence reports and created documents for analyzing and visualization of data collected from disparate source systems.
• Worked with the corporate the Cyber Security, Compliance and Fraud monitoring team, and the technical team to understand the end to end process, data security and the compliances documents such as PCI DSS, FACTA, Suspicious Activity Reporting (SAR)
• Documented elicited requirements in Functional Requirement Document (FRD) and System Requirement Specification (SRS). Created a sample of data prototypes for approval from sponsors and business owners.
• Assisted the Product Owner (PO) in transforming Business requirements into User Stories. Participated in Product Backlog grooming sessions and assisted PO in slicing epics into stories and prioritizing the stories.
• Created Data/ Process Flow Diagrams, Sequence Diagrams using UML in MS Visio for ease of understanding.
• Assisted in creating Conceptual, and Logical entity relationship (ER) diagrams. Also, developed data dictionary.
• Collaborated with Data Analyst in Data Profiling. Assisted the development team using Informatica Power Center’s Data Quality for Data Cleansing and Data Analysis before loading the data onto the Enterprise Data Warehouse.
• Facilitated meeting between development and technical team in deciding the batch processing method for extracting, transforming, and loading (ETL) the data into the target area using Informatica Power Center.
• Worked with the ETL developer to create Source to Stage and Stage to Target Data mapping documents indicating the source tables, columns, data types, transformations required and, business rules and logic to be applied.
• Regularly reviewed the data mapping and transformation logic applied to data to check if requirements are met.
• Used Dimensional modelling like Star Schema and Snowflake Schema in designing the data warehouse to define the relationship between the fact tables and dimension tables, identifying primary and foreign keys.
• Created SQL queries in Toad to perform data analysis, data validation and data manipulation operations.
• Used Tableau for data reporting, studying the trends and patterns and for data forecasting.
• Assisted the Project Manager and the development team in all phases of the development (SDLC).
• Assisted in creating Test strategy, Test Plan and Test Cases, and exit strategy by working closely with QA team.
• Assisted in User Acceptance Testing (UAT) efforts by conducting UAT and logging defects in HP ALM.

Environment: Waterfall-Agile Methodology, Oracle 10g, Toad, Socket Programming, MS Visio, MS Office Suite, Java, XML, SSMS 2014, Jira, HP ALM, Informatica Power Center, Tableau.

Confidential

Business System Analyst

Responsibilities:

• Interacted with stakeholders and elicited the requirements using different elicitation processes, such as interviews, brainstorming. Conducted JAD session with the SMEs to understand better about the requirements.
• Analyzed and gathered requirements for preparation of Business Requirement Document (BRD), Functional Requirement Document (FRD) and System Requirement Specification (SRS).
• Prepared Requirement Traceability Matrix and interacted with QA team to ensure quality of software.
• Responsible for creating UML diagrams (Use Cases, Activity Diagram and Class Diagram) to capture the dynamic behavior of different applications and how they interact in the environment.
• Performed a GAP analysis between the legacy system and the imminent system.
• Communicate project status and provide timely escalation of issues to the Technology Project Manager (Application Manager, Demand Manager, Portfolio Manager) and ensure timely notification and escalation of possible issues/problems, options and recommendations for prompt resolution.
• Designed Test Plans and Test Cases for User Acceptance testing (UAT) with the help of QA teams.
• Prepared Business process models; used Visio to create process flow diagrams for management and mapping the logical aspects of the process.
• Created interactive dashboards and generated reports using IBM Cognos for further analysis.

Environment: WAN, LAN, .Net Framework, Visual Studio, Wireframes, Servers, Windows OS, Firewalls, Routers, Swagger, IBM Cognos.

Confidential

Python developer / Jr. Business System Analyst

Responsibilities:

• Using MS VISIO, conducted user-interviews for requirements gathering, analyzed requirements, and created Business requirement document (BRD), functional requirements (FRD), UML diagrams.
• Setting up the Sybase databases in all three environments (DEV, TEST, PROD) and developed the mappings in such a way that the external data is converted as per team’s data warehouse.
• Downloaded the files on UNIX server, running the Informatica Power center 9.6.1 workflow, which consumed the UNIX files, and gave the o/p files in UNIX itself.
• Created mappings using SQL Codes and used transformations like expressions, routers, lookups, filters, sorters and running workflow for proper time and session management.
• Uploading the files back to mainframe for the use by the business team and different client vendor teams. This process was fully automated in PROD but in DEV, it was manually done.
• Sending the vendors data (weekly/bi-weekly/monthly as per the requirements) for any change in the enrollment information for the participants.
• Providing details of plan change information, full information i.e. change plus the ongoing participants’ information lists whose plans have been discontinued for various reasons.
• Implemented Elevation logic as per requirement by the client.
• Performed manual Testing of O/P data flat files to fix any bugs, errors or redundancy in any o/p data files.

Environment: MySQL, MS SharePoint, Selenium, SOAP UI, IBM Cognos.

Confidential

Python Developer

Responsibilities:

• Add new sales markups for base metal carries, Asian swaps and Averaging products
• Add new fee rules structure for Exchange Reference orders and fixing orders
• Optimize historical trade blotter export by distributing and parallelizing Cassandra queries
• Auto populate Sales book lookup using the most frequently used sales book for a corresponding client book.
• Used user authentication and authorization for between multiple systems and environments.
• Used fundamental design principles behind scalable application.
• Integrated event driven programming in python.

Environment: Python