SUMMARY

• Over 8 years of experience as a Business System Analyst in Finance and Banking domains in various areas like wealth Management, Asset Management, Online Trading, Portfolio Management, Fixed Income, Financial Market, Bond Pricing, Trading life cycle, H - Funds.
• Strong understanding in Capital Markets,Fixed Income, Equities,Risk management Over the Counter (OTC) Trading life cycle, Trading floor applications, Loan Processing Applications andPortfolio Management, Financial Assets such as Equities, Bonds, Mutual funds, ETFs, Derivatives.
• Expertise in Software Development Life Cycle (SDLC) methodologies like Waterfall, Scrum-Waterfall Hybrid, Agile (Scrum, Kanban, Extreme programming) and Scaled Agile Framework (SAFE 4.0).
• Highly skilled in various requirements Elicitation Techniques such as Brainstorming, Document Analysis, Interview, Requirements workshops, Focus group and Joint Application Session (JAD).
• Point of contact for all phases of Software Development Life Cycle(SDLC) for Requirement Gathering, Design, Development, Testing and Implementation phases on behalf of the Business.
• Excellent analytical skills to understand the business processes, functionalities, requirements and then translate them in Requirement Specifications Documents and by Motivating team players with excellent business, analytical, communication, presentation, and management, technical and written skills.
• Expert in GAP analysis, Impact analysis, SWOT analysis, Cause & effect analysis, Cost benefit analysis, Feasibility analysis, Risk analysis, Net Present Value (NPV) and Return on Investment (ROI).
• Excellent in Communication, Problem-solving, Critical thinking, Conflict resolution, Facilitation, Documentation skills and good in Process management skills to Gather Requirements.
• Created various artifacts including Business Requirement Document (BRD), Software Requirements Specification (SRS), Functional Requirements Document (FRD), Test Plan, Test Scenarios, and Test Cases.
• Expert in Tracking and Managing the Requirements using Requirement Traceability Matrix (RTM) that controls numerous artifacts produced by the teams across the deliverables for a project.
• Assisted product owner in Backlog Refinement and Prioritized Requirements according to the Business Value and other prioritization techniques. Acted as Proxy to product owner as required in planning meetings.
• Extensively worked in agile environment in story writing session to INVEST criteria, Profound knowledge in scrum activities, worked with Product Owner in managing Product Backlog and Broken-down requirements into user stories, Expert in JIRA by tracking Requirements, Bugs, Issues, and helping front desk tickets.
• Translated high level business / data requirements into Process, Workflow, and Data Flow Diagrams using BPMN towards facilitating clear understanding of the business process.
• Acquainted in UML Modeling and Business process modelling and notations (BPMN) like Activity Diagrams, Sequence Diagrams, Use case Diagrams, Process work Flow Diagrams.
• Handled Change Requests by taking upon the role of Change Owner, Interacted with Change representatives, CCAB to review Impact Analysis and documented Change Request Form.
• Managed all phases of SDLC using HPALM and Managed requirements and tracking defects using HPQC. well versed in conducting various types of Testing like Regression Testing, and User Acceptance Testing (UAT), also Involved in Manual and Automated scripting of Performance Testing in Load Runner. created UI/UX wireframes, mockup screens, and prototypes in MS Visio, Balsamiq and Mockup Screens.
• Extensive knowledge in Data Warehouse architecture, implementation approaches, schemas and dimensional modeling, Seasoned in Creating Data Models, such as Conceptual model and Logical model.
• Performed ETL using Informatica to load the data into the data warehouse from disparate sources, and assisted in designing and deploying various Reports through Tableau, and IBM Cognos.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including Technical support, Troubleshooting, Report design and Monitoring of system usage.
• Monitored migration of data from various OLTP’s to OLAP’s cube using ETL tools such as Informatica. Also, raised SQL queries for extraction of data from different data marts.
• Extensively involved in Data Migration and Integration projects have assisted in ETL processes. Created and delivered full sign-off project documentation starting from Development and ending at post-Production deliverables by working with Key Stakeholders to elicit information and gain agreement.
• Performed various SQL queries like SELECT, JOIN, VIEW for relevant data retrieval on Oracle database.
• Designed and implemented SQL queries using joins, unions, outer joins, group by and aggregate functions to extract data from different databases (Oracle, SQL Server) for timely reporting and Validation.
• Performed the requirement Ad-Hoc Analysis and documented the requirements, used SQL queries in retrieving data using MySQL work bench, Performed SQL query operation such as DML and DDL commands and also supervised the source to target mappings in Informatica Power Center.
• Extensively used SQL queries for business analytics and analysis of data using data manipulation language.
• Skilled with Data Analysis concepts of Data Modeling, Data Dictionary and Normalization, Created Data Mapping Documents to transfer data from legacy to target system and to reduce data and duplication.
• Comprehensive understanding of Web-Services like XML and RESTFUL API using internet protocol suite like HTTP under Three-Tier Architecture, Service Oriented Architecture (SOA), AWS Platforms.
• Designed and produced API implementation documentation for system integration. Managed in finding on business objects in product research and offering technology-based solutions to the IT development team.
• Familiar with current industry standards CYBER SECURITY, CCAR, SOX, MIFID II (Market in Financial Instrument Directive), DOL-fiduciary, Solvency II, EMIR (European Market Infrastructure Regulation), Know Your Customer (KYC), Basel II, US GAAP, IFRS, Dodd-Frank, SEC.

TECHNICAL SKILLS

Programming Language: SQL, Apex, HTML, Python, JAVA

Web Application Development: HTML, JavaScript, XML, JSON, API, RESTFUL API

Design Tools: Microsoft Visio, Microsoft project, Balsamiq

Project Methodologies: Waterfall, Agile (Scrum), Waterfall hybrid, SAFE

Business Modeling Tools: MS Visio, Map force, BPMN, PERT table, Gantt chart, Pivot table, Tableau

Requirement management tools: Jira, HPALM, IBM Cognos, Rally, TFS

Testing tools: Cucumber, HPQC, HPALM, Load Runner

Databases: SQL server, MySQL, Oracle, Cloud database, Force.com, S3, Hadoob, Snow flake

PROFESSIONAL EXPERIENCE

Confidential - Baltimore MD

Sr. Business system analyst

Responsibilities:

• Attended business meeting to understand the Roadmap of the business units for the upcoming fiscal years.
• Conducted GAP Analyses by understanding the AS-IS business process and TO-BE business process.
• Generated in-depth Root Cause Analysis reports in relation to critical network events.
• Facilitated Brainstorming session to effectively understand the analytical reports needed by the internal clients.
• Conducted JAD Sessions with key Business Users and technical teams to elicit and know insights on the requirements on proposed project and to reduce ambiguity on the project goal.
• Used JIRA for requirements gathering and writing the associated test cases against the requirements.
• Assisted SME’s in feasibility study with respect to CRM Business Processes, and Client Management.
• Transformed user Requirements into User Story format along with Acceptance Criteria.
• Prepared Requirement Traceability Matrix (RTM) based on High level /low level requirements by aligning Test Cases to respective user story.
• Highly involved with Product Owner in Decomposing Business requirement into User stories, and Prioritization of user story in product backlog.
• Created, designed and development Activity Diagrams and Sequence Diagrams and OOD in unified modelling language and created use case scenario, use case narrative for respective functional requirements.
• Created UML diagrams, Use Case Scenario, Use Case Narrative, Use Case Diagrams, Data Flow Diagrams, Activity Diagrams and Sequence Diagrams using MS Visio.
• Involved in Data mapping and integration of data from legacy systems to SalesForce.com Objects and fields.
• Created Ad-hoc and BI reporting using Tableau and worked closely with business and technology executives to define the product and customer Reference Data strategies.
• End to end experience in designing and deploying data visualizations using Tableau
• Experienced in developing UI using Visualforce pages and providing business logics using Apex.
• Acquainted with onerous tasks that relate to Sales cloud, Service cloud, Marketing cloud & Community cloud.
• Proficient in salesforce customizing standard objects like Accounts, Contacts, opportunities, Products, Price books, Cases, Leads, Campaigns, Reports and Dashboards.
• High exposure in implementation of Salesforce Chatter in business to create team co-ordination and task accomplishment, Expertise in developing, deploying and integrating Salesforce.com CRM.
• Co-ordinated with ETL developers to explain transformation logics and business logics while loading the data from staging area (S3 curated bucket) to the snowflake data base.
• Various compliances used in the systems are CYBER SECURITY, MIFID II (Market in Financial Instrument Directive), DOL-fiduciary, Solvency II, Know Your Customer (KYC), Basel II.
• Facilitated the UAT testing, Highly Involved in BETA testing, Regression testing, system testing.
• Data points needed for the system requirements was documented by running query in the snow-flake data base.
• Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using SQL
• Interacted with business heads to finalize the Business Requirements for the application.
• Performed the requirement Ad-Hoc Analysis and documented the requirements. used SQL queries in retrieving data using MySQL work bench.

Environment: SAFE 4.0, Aws Environment, SalesForce.com CRM Application Platform, Apex Language, Autosys Infomatica cloud service, Apex Data Loader, Import Wizard, Tableau, JIRA, Balamsiq, Snow flake, Cucumber, Grand Central, JIRA, Morning star, workday.

Confidential, Atlanta GA

Sr. Business system analyst

Responsibilities:

• Acted as a liaison between USI BI team and Enterprise Data Warehouse management team.
• Conducted Root cause and SWOT analysis to fully understand the current state of the system.
• Acted as a Data steward to identify the master record and responsible for management and proficiency.
• Interviewed and Gathered the business requirements for BI reporting and conducted JAD sessions.
• Transformed business requirements into User Stories and Acceptance Criteria to respective user stories.
• Involved in creation Functional Specifications Document and developed System Requirement Specification
• Used Mockup screens to convey the look and feel of GUI screens for the end users to developers.
• Created test cases, managed and tracked requirements through Requirement Traceability matrix (RTM).
• Partnered with Business users during UAT and assisted in troubleshoot issues and evaluate system performance.
• Interacted with various end user teams during Beta testing to gather feedback on application usability.
• Executed SQL queries to verify data in the reporting system and used Tableau to generate reports.
• Involved in product Demo and assisted product and scrum master taking feedback from stakeholders.
• Developed Conceptual, Logical & ER diagrams for database and Created Data Dictionary for the data models.
• In depth understanding of CRM business processes like Campaign Management, Lead Management, Opportunity Management, Support Process, Account Management and Forecasting.
• Monitored migration of data from various OLTP’s to OLAP cube using ETL tools such as Informatica and also raised SQL queries for extraction of data from different data marts.
• Worked 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 and constructed SQL queries using normalization data, Inline queries and different functions and store processes.
• Made sure that the required information in being gathered for the KYC and was responsible for the monthly update.
• Proficient in creating Use Cases, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams using Balsamiq.

Environment: Agile Methodology, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS SQL, informatica power center, JIRA, Balsamiq, HPQC, Touchpoint, FA salesforce, Sales connect, salesforce.

Confidential, Brookfield WI

BUSINESS SYSTEM ANALYST

Responsibilities:

• Developed good knowledge on Equities, Fixed Income, Futures, Bonds, Bond Pricing, Derivatives, Credit Derivatives, Interest Derivatives and Equity Order Processing.
• Primary responsibility was to identify the Morning Star data points that needs to be subscribed.
• Assisted Project manager in creating RACI matrix for assigning roles and responsibility in the project.
• Involved in Business Process Re-engineering through workflow diagrams and other methods.
• Facilitated JAD sessions with focus groups, requirements workshops, Interface analysis and prototyping to effectively understand the analytical reports needed by the internal clients.
• Worked with SME’s to Gather Requirements on different Asset classes of portfolio management platform and Worked with risk analyst to gather requirements on Risk Analysis of portfolio’s.
• Identified the requirements of the stakeholders and created Business Requirement Document (BRD) and Functional Requirement Documents (FRD).
• Initiated Change Request in system and worked with Change Approval Board (CAB) and Stakeholders.
• Created Use Case Diagrams, Activity Diagrams and Entity Relationship Diagram (E-R) using MS Visio.
• Highly involved with Data scientist for Data preparation, cleaning and modelling using python.
• Performed Critical-path Analysis using Excel as per the requirements of the managers.
• Used HPALM for Requirement Tracking, Issue Tracking, and Requirement Traceability.
• Created Test Cases and Test scripts and actively participated during UAT, Unit testing, system Testing.
• Using TFS verified requirements satisfy by linking with test cases and increased team efficiency.
• Administered ETL Process and identified source table and target table by mapping the data and created the data mapping document.
• Analyzed data points need from Morningstar feeds, and Extracted financial data from Morning Star to a spreadsheet for analytics purpose.
• Good knowledge of BI tools like IBM COGNOS and Ab-Initio plus Tableau - data visualization and analysis
• Assisted developers to prepare End-user manual by giving assistance to people using a system.
• Extensively involved in Web Services, XML Documentation, and SOAP.

ENVIRONMENT: Hybrid (Waterfall - Scrum), MS Project, SharePoint, Morningstar, XML, SOAP, MS Outlook, MS-SQL Server, HTML, HPQC, Tableau, IBM Cognos, Team Foundation Server (TFS), Rally.

Confidential, Baltimore MD

BUSINESS SYSTEM ANALYST

Responsibilities:

• Assisted Project manager in Project Charter, Project Planning and work breakdown structure using MS Project.
• Established extensive knowledge of Trade Order management systems and Trade Execution.
• Organized workshops with Subject Matter Experts to obtain domain level information and Developed a vision plan that defined the primary goals and objectives of the project.
• Involved in Business Process modelling by designing UML diagrams such Use Case and Activity diagrams.
• Involved in decomposing Epics into user stories with product owners and Created Use Case Scenarios and maintained the Textual Use Cases.
• Used JIRA for tracking sprint progress, user story writing, backlog management, issue tracking, user story management and requirement traceability matrix and generated status reports.
• Actively involved in UAT & assisted Regression Testing, Interface Testing (SOAPUI) and Black-box Testing.
• Created Test Cases, Test Scenarios and conducted Manual Testing in HP Quality Center.
• Extensively interacted with data analysts during the ETL operations in identifying the source files/databases and implementing the transformation logic for achieving data uniformity. seasoned in creating Conceptual Model as well as Physical Model of the trading system using MS Visio. involved in increasing Data Integrity by performing Data Normalization, Data Standardization and Data Indexing to maintain accuracy and effectiveness of data using Informatica Data Quality.
• Designed and implemented basic SQL queries for QA testing and report / data validation, Created various types of reports for analytics using Tableau.
• Created regulatory reporting every quarter in the project on SEC, Dodd-Frank, EMIR, OCC, BASEL II, III

Environment: Hybrid(waterfall-Scrum), SQL, MS Office, MS Visio, Oracle, XML, SOAP, Informatica, IBM Cognos, JIRA, MS Share point, Tableau.

Confidential

Business Analyst/ Business System Analyst

Responsibilities:

• Worked with Project manager in creating and assigned task through Work Break-down Structure.
• Prepared Business Requirement Document (BRD) and Functional Requirement Document (FRD).
• Worked closely with Project Manager for any change request and helped to do Impact Analysis.
• Developed plans for verification and validation of requirements at all levels so that developed software successfully fulfilled user expectations and business needs.
• Worked with management to create and communicate critical information to the user community via email and discussion boards.
• Involved in writing Business Rules to support recommendations for resolving business and technical issues.
• Created Mockup screen to represent the look and feel of the module.
• Created Requirements Traceability Matrix (RTM) using HP QC tool.
• Created ad-hoc reports using MS-Excel and Pivot tables for calculations and creating reports.
• Helped creating and modifying SQL queries to match the requirements.
• Developed data mapping for retrieval of information from existing account systems and outlined security measures for accessibility and transmission of information.

ENVIRONMENT: Waterfall, Mock-up screen, MS Office, SQL, UAT Testing, HP QC, Oracle DB.

Confidential

Business analyst

Responsibilities:

• Participated in analyzing business requirements and developed functional requirement documents.
• Conducted elicitation techniques like Requirement workshops and Interviews to Gather requirements.
• Used MS Visio to create various UML diagrams like Use cases and sequence diagram.
• Facilitated the Root cause of the situation to determine why we need the proposed software. created sample wireframes to make system better understood by Business and Technology Teams.
• Involved with QA in preparing of Test Plans and Test case for the User Acceptance Test (UAT).

Environment: Waterfall, UML, MS Visio, MS Access, MS Office, SQL Server, Visual Studio.

Confidential

Jr. Business Analyst

Responsibilities:

• Conducted Interviews, Brainstorming sessions and Document analysis.
• Captained GAP Analysis by understanding the As-Is business process and To-Be business process.
• Identified actors and use cases to create use case diagrams that described the behavior of the system.
• Facilitated collection of functional requirements from system users and preparation of business requirement documents
• Developed Test Plans, Test cases and test scenarios also maintained Master Test Plan.
• Created Mock-up screen to make system better understood by Business and Technology Teams.
• Worked with development and testing teams to accomplish timely release objectives.

Environment: waterfall, MS Office Mock-up screen.