PROFESSIONAL SUMMARY:

• 8+ years of professional experience in Financial Services domain as a Business Systems Analyst with a strong understanding of Trade Life Cycle, Portfolio Management, Asset Classes and Simple & Complex Products.
• Experience in working with different Software Development Life Cycle (SDLC) methodologies like traditional methodology such as Waterfall and Agile methodologies such as Scrum and Scrum - Waterfall (Hybrid).
• Strong knowledge of the Trade Life Cycle of financial securities from initiation to the settlement phase and understanding of Asset Classes such as Equities, Fixed Income, Foreign Exchange and Products like Options (Put Options and Call Options) and Futures.
• Understanding of SOX, FINCEN, Dodd Frank, SEC and FINRA compliance.
• Experience in working with Business Owners, Business Users, Senior stakeholders, Project Managers, Product Owners, Technical Architects, Scrum Teams, Development Team, Quality Assurance/Testing Team, Maintenance Team, ETL Team and Database Administrators.
• Experienced in eliciting requirements using various techniques such as Joint Application Development (JAD) sessions, Interview sessions, Requirement workshops and Document analysis.
• Experience in Document Analysis, Risk Analysis, Root Cause Analysis and GAP Analysis.
• Experience in writing Business Requirement Document (BRD), Functional Requirement Document (FRD), System Requirement Specification (SRS), Requirement Traceability Matrix (RTM).
• Assisted Project Manager with Cost Benefit Analysis, Feasibility Study and Acquisition Plan.
• Assisted Project Manager in developing Project Management Plan, Project Charter and WBS.
• Experienced in writing User stories and Participated in Scrum Ceremonies like Release Planning, Backlog grooming, Sprint Planning, Sprint Review and Retrospective and experience in prioritizing techniques like MoSCoW, KANO and estimating techniques like Planning Poker, Relative Mass Valuation.
• Expertise in creating UML diagrams like Use Cases, Activity, Sequence and Class diagrams.
• Hands on experience in writing and executing SQL queries using DDL, DML, DQL & DCL statements to perform various operations on database and Experience in executing queries like Joins, Subqueries and Aggregate functions. Good understanding of Procedures, Functions and Triggers.
• Extensive experience in development of a Data Warehouse and in Performing Data Analysis, Data Profiling and Data Mapping from an Operational Data Store to an Enterprise Data Warehouse.
• Created Source to Target Data mapping documents indicating the source tables, data types, transformations required and business rules to be applied using Informatica and Abinitio.
• Extensive implementation knowledge of Databases, Data Table structures, Schemas, Data Marts and OLAP operations such as Roll-up, Drill-down, slice and dice.
• Experience in Troubleshooting SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Knowledge of 3-tier, n-tier architecture and Service Oriented Architecture (SOA) systems and Web APIs like SOAP and REST. Extensible Markup Language (XML), and JavaScript Object Notation (JSON).
• Assisted the QA team to design Test plans and Test Cases for User Acceptance Testing (UAT).
• Knowledge of Test Driven Development (TDD), Behavior Driven Development (BDD) and Acceptance Test Driven Development (ATDD) and Assisted in User Acceptance testing and Functional Testing.
• Undertook a comprehensive review of test cases to ensure their integrity and assist the Quality Analyst and Testing team to perform system testing and integration testing.
• Experience in creating analytical Business Intelligence (BI) dashboards using Tableau and Excel.

TECHNICAL SKILLS:

SDLC Methodologies: Waterfall, Agile-Scrum, Waterfall-Scrum Hybrid, Kanban

Requirement and Defect Management: MS Office, Atlassian-JIRA, Rally, HP ALM, Team Foundation Server (TFS)

Modeling & Designing: Lucid Charts, Smart Draw, MS Visio, Mock-up Screens, Balsamiq

Reporting and Data Analysis tools: Tableau, Power BI, MS Access, Informatica Power Center, MS SSRS, Excel

Project Management: MS Project, MS Office, MS SharePoint, Confluence

Data Modeling: Entity-Relationship, Conceptual, Logical, Dimensional, Star Schema, Snowflake Schema, Data Dimensions, Erwin Modeler

ETL: Informatica Power Centre, Abinitio, SSIS

Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, Slicing, Dicing

Databases: Teradata, SQL Server, Oracle11g, MySQL

Testing Tools: Selenium, Cucumber, HP QC, POSTMAN, SOAP UI

Business Skills: Process Modeling, GAP Analysis, Impact Analysis, Risk Analysis, Cost-Benefit Analysis, SWOT Analysis, JAD Sessions

Operating Systems: Windows XP, Windows 8, Windows 10, Linux, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Sunrise, FL

Project Manager/ Scrum Master

Responsibilities:

• Networked with Subject Matter Experts, Business Users and Process Analysts to understand the business process, gathering Business Requirements and identified enhancements.
• Refined business requirements by participating in JAD sessions, interviewing business users and stakeholders, conducting one to one sessions and consulting existing systems documents.
• Assisted the BA in Identifying dependencies and document functional, non-functional requirements and data requirements in Business Requirements Document (BRD) and Functional Requirements Document(FRD).
• Created Mock-Up Screens using Visio for User Interface components for client verification.
• Extensively used MS Project to develop work breakdown structure (WBS) and Gantt Charts.
• Assisted the Product owner in decomposing the Epics into User Stories and maintain the Product Backlog.
• Ensured coordination between product owners, analysts, developers and QA. Created and routinely updated Sprint Burn-down Chart, Sprint Burn-up Chart, and Task Board to track team’s progress toward goals.
• Assisted the PO in transforming requirements into user stories and determining Acceptance criteria.
• Tracked stories using JIRA software and maintained the entire project related documents and decisions in Confluence and Created widgets on dashboard to help the scrum team view progress.
• Led User Story Writing sessions and determined Acceptance Criteria for Potentially Shippable Product Increment. Worked with the Product Owner during the Sprint Review Meeting for the PSPI and helped decide which features are DONE and satisfied using the Acceptance Criteria.
• Employed various retrospective techniques during Sprint retrospective meetings such as Silent Writing, Happiness Histogram and Star fish to identify the development team’s issues and resolve them.
• Developed timelines for project delivery, and managed projects and resources to successful completion.
• Assisted the testing team in Manuel testing, logging defects and creating an error repository to support them in testing, tracking defects and systematically manage defects.

Environment: Scrum, Microsoft Office (Excel, Powerpoint, MS Project, MS Visio), Microsoft Visio, Tableau, Hadoop, Informatica Power Center, JIRA, Confluence, SOAP UI, Postman

Confidential, Stamford, CT

Sr. Business Systems Analyst

Responsibilities:

• Strong Understanding of Foreign Exchange Market, Trade Life cycle and Trading Platform.
• Conducted Interviews with business users, SMEs and performed extensive document analysis to develop a thorough understanding of end-to-end business processes involved in portfolio management.
• Elicited requirements using JAD Sessions, one on one Interviews, Brainstorming and used Delphi technique for consistent requirement gathering. Also, conducted GAP analysis to derive consistent requirements.
• Identified dependencies and documented functional, non-functional requirements and data requirements in Business Requirements Document (BRD) and System Requirements Specification Document (SRS).
• Designed UML diagrams like Use Cases, Activity Diagrams and Class Diagrams using MS VISIO.
• Assisted the product owner in determining Acceptance criteria and Transformed requirements to user stories.
• Gave insight into the complex data carried by Bloomberg and other sources and constantly looked for ways to improve processes and drive the team forward.
• Documented the Source to Target Mapping documents with business logic and data transformation logic.
• Wrote and executed SQL queries to perform various types of analysis like data analysis, data validation and data manipulation using different types of Joins, Subqueries and Aggregate functions.
• Used SQL minus queries to make sure that the extraction process did not provide duplicate data or redundant data in the source and all unnecessary columns are removed as per the business requirements.
• Created Data Mapping documents for tables and columns stored in the database after coordinating with the development team, business users, subject matter experts, project manager and stakeholders.
• Involved in API documentation for SOAP and documented XML request and responses.
• Wrote test cases, test plans and test scenarios and used HP QC to log defects and create an error repository to support QA team in testing, tracking defects and manage defects and bugs.
• Assisted in User Acceptance Testing (UAT) against test cases and Acceptance Criteria and participated in and facilitated testing of the system during Smoke testing and Regression Testing.
• Developed Tableau dashboards incorporating Waterfall charts, Bubble charts, Heat Maps, and Histograms for portfolio managers viewing their investments and senior management viewing risk exposures.

Environment: Scrum, Microsoft Office Suite, Microsoft Visio, UML, Tableau, Teradata, Informatica Power Center, Selenium, JIRA, Cucumber, SOAP UI, FIX, HP QC

Confidential, St. Petersburg, FL

Sr. Business Systems Analyst

Responsibilities:

• Conducted interviews and facilitated JAD Sessions with stakeholders to elicit requirements for BI reports.
• Understood problem definition through one to one meetings with Data Architect and Enterprise Architect.
• Prepared Requirements Document, Release Planning Document and aided Product Owner (PO) in preparing Product Backlog and UAT Artifact and in Acceptance Criteria elaboration.
• Involved in defining the source to target data mappings, business rules, business and data definitions.
• Created processes and flow charts to meet the business needs and created data mapping documents.
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Provided management support to the development team and checked the Data Quality.
• Extracted data from various production databases such as Oracle to meet Campaign data needs.
• Improved Data Integrity by performing Data de - normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data.
• Aided the application of Snow-flake Schemas in Dimensional model by providing business rules to architects.
• Integrated various OLTP databases to OLAP using Informatica Power Center as an ETL and reporting tool.
• Assisted in developing and maintaining business & financial reports and IT work/databases which was required to support the various lines of business and specific projects.
• Assisted QA team in User Acceptance Testing, while developing and maintaining quality procedures. Helped the team during automation testing, smoke and sanity testing and Regression testing.
• Assisted in drafting test cases, test plans and test strategies and exit strategy by working with the QA team.
• Worked closely with business users to define requirements, prioritize and address production support issues.
• Used Tableau for data reporting and creating dashboards for visualizing the data patterns and trends.

Environment: Oracle, SQL Server, Management Studio, Teradata, UNIX, Tableau, MS Excel, MS Power Point, Informatica Power Center Designer.

Confidential, New York City, NY

Sr. Business Systems Analyst

Responsibilities:

• Assisted PM in developing project scope document, concept statement, risk analysis document, mitigation plan and proposal statement. Performed feasibility study, SWOT analysis and cost benefit analysis.
• Understood the As-Is system, developed the To-Be system and prepared the System Process Maps.
• Elicited requirements by conducting Brainstorming and JAD sessions. Interviewed business owner’s and SME’s by asking both open ended and close ended questions to refine the requirements.
• Created requirements documents- BRD & FRD. Converted these requirements into user stories along with the team and product owner. Assisted PO in defining acceptance criteria and prioritization of requirements.
• Coordinated requirements using incident tracking tool- JIRA.
• Created Use Case diagram, Data Flow diagram, Activity diagram showing the workflow. Also created mock up screens for better understanding of Graphical User Interface (GUI) requirements.
• Created and updated the Gantt Chart to trace the project planning in detail.
• Facilitated and managed meeting sessions with PM, BO, committee of SME’s and ensured that their requirements are implemented as specified in the business and functional requirements.
• Used DDL, DML and DQL SQL queries to perform data analysis, data validation and data manipulation.
• Involved in API technical writing and documented XML and JSON request and responses.
• Created Test Plans and Test Cases for functional testing by analyzing the Business requirements specification document.
• Reviewed test scripts to ensure that all the functional requirements were tested.
• Assisted QA team in performing Functional Testing and User Acceptance Testing (UAT).
• Developed user manuals, presentations and training manuals as per project specifications and timelines.
• Used Tableau for reporting, pattern recognition and business intelligence (BI).

Environment: Waterfall-scrum Hybrid, SOA, MS Office 365, HTML, JIRA, Selenium, Tableau, Oracle 11g, SOAP UI

Confidential, Pittsburgh, PA

Business Systems Analyst

Responsibilities:

• Elicited requirements using JAD sessions, Surveys/Questionnaire, Interview sessions, Requirement Workshops, Focus Groups, Interface Analysis and conducted GAP Analysis to derive requirements.
• Conducted Cost Benefit analysis, Feasibility check, Impact analysis, Cost analysis, and evaluated Porter’s Five Forces.
• Helped the Product Owner Prioritize the Product Backlog for developing Sprint tasks supported by cross-functional team. Used JIRA for issue tracking, user story management and requirement traceability.
• Created Mock-Up Screens and Wireframes using Visio for User Interface components for client verification
• Developed Conceptual and Logical data models for Customer and Collateral tables.
• Generated ad hoc SQL queries using joins, subqueries and aggregate functions, database connections and transformation rules to fetch data from the SQL Server database systems.
• Supported ETL developers in creating workflows and scheduling batch processes based on Data Mapping.
• Aided in transformation of various OLTP databases to new OLAP databases. Updated the existing Data Dictionary and identified and analyzed the data sources thoroughly while data profiling by collecting statistics.
• Oversaw the Database teams and DBAs while implementing the Enterprise Data Warehouse.
• Assisted in UAT, developing and maintaining quality procedures, and ensure that proper documentation is in place. Assisted in Smoke and Regression testing.
• Used Tableau for data reporting, studying the trends, data patterns, data forecasting and visualization.

Environment: Waterfall - Agile Methodology, MS SQL server, MS Office 365 (SharePoint, Project, PowerPoint, Visio), Jira, Informatica Power Center, Tableau

Confidential

Business Systems Analyst

Responsibilities:

• Assisted the Project manager in creating and assigned task through Work Breakdown Structure (WBS).
• Followed Waterfall as the System Development Life Cycle (SDLC) Methodology.
• Gathered requirements from key stakeholders, business owners, business users, end users, customers and Subject matter experts (SMEs) to define the scope and requirements of online banking system.
• Worked closely with the development team to verify that business needs are thoroughly fulfilled and deliverables are produced within specified budget, quality and time.
• Defined the context of the system by creating various Use Cases for the development system requirements specifications encompassing Functional and Non-Functional requirements.
• Developed Use Case Diagram and Sequence Diagrams to represent interaction between user and system.
• Assisted the QA team in designing Test Plan and wrote Test Cases for the User Acceptance Testing (UAT) and assisting the Automation Testers in System Testing, Integration and Regression Testing.
• Helped creating and modifying SQL queries to match the requirements.

Environment: Waterfall, Oracle, HTML, MS Visio, MS Project, SQL, MS VISIO, MS Access, MS Word & Excel

Confidential

Teradata Database Administrator/ Jr. Business System Analyst

Responsibilities:

• Worked in Waterfall methodology as Software Development Life Cycle (SDLC).
• Assisted Sr. Business Analyst in gathering requirements from key stakeholders, customers and SME’s to define the scope of the project.
• Defined the context of the system by creating various Use Cases for the development system requirements specifications encompassing Functional and Non-Functional requirements.
• Developed Business Requirement Document (BRD) and Use Case Document (UCD).
• Created screen mockups for the new platform using MS Visio.
• Created Requirements Traceability Matrix (RTM) using HP QC tool.
• Used SQL for performing CRUD operations and used join functionality to fetch Business facts.
• Created ad-hoc reports using MS-Excel and Pivot tables to do the calculations and creating reports according to the needs of the users.
• Worked with the QA team for designing Test Plan and Test Cases and also assisted in conducting User Acceptance Testing (UAT).

Environment: Waterfall, MS Office, SQL, Teradata, Excel, HP QC

Confidential

Teradata Database Administrator

Responsibilities:

• Working on 24*7 Support Environment managed by strict Service Level Agreements with time limits for ticket acknowledging, ticket resolution/Escalation.
• Data refreshed across different Teradata production and non - production environment using Teradata.
• Dropping Databases / Users with proper approvals verifying the dependency before dropping.
• Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles.
• Monitoring resource, CPU usage through Teradata Viewpoint and Users activity using DBQL data.
• Monitoring and resolving session blocking.
• Creation of databases, determining logical and physical Databases as per business requirement reviewing for any performance impact.
• Creation of users and mapping appropriate roles as per application requirements following standard firm policies.

Environment: Waterfall, Teradata SQL Assistant, Teradata Administrator, Teradata Viewpoint, Unix