SUMMARY:

• Over 15+ years of extensive experience as a Business Analyst in business and functional requirements elicitation, analyzing requirements, statistical data analysis, data mapping, object - oriented designing, Design of Experiments, Regression and Response Surface analysis, Unified Modeling Language (UML), SDLC methodology (RUP, Agile, SCRUM, XP, Waterfall) and project management in finance and banking domain (Wealth Management, Trading, Investment banking)
• Excellent knowledge in Wealth Management, Trading, Investment Banking, Asset Management, Derivative products such as Options and Futures, Swaps, Fixed Income, Trade Life Cycle, FIX protocol, Mortgage, Insurance, Bonds and Funds.
• Proficient in facilitating Joint Application Development (JAD), Rapid Application Development (RAD), and Accelerated Requirement Methodology (ARM) sessions comprising of Enterprise Analysis, Requirements Gathering and Documenting requirements.
• Hands-on experience working with diversifieddata/database solutions like HDFS (Hadoop Distributed File System), Teradata, Oracle and SQL Server.
• Very efficient at performing GAP analysis to check the compatibility of the existing system infrastructure with the new Business requirements and Best Practices, SWOT analysis, Business Rules Analysis, Impact Analysis (Business, Technical), Risk Analysis and Cost Benefit analysis.
• Good knowledge on latest BI Tools like Tableau
• Knowledge in understanding the data and designing/Implementing the enterprise platforms like Hadoop Data lake and Huge Data warehouses.
• Utilized MS Project and variance analysis to manage schedules, meet deadlines and plan resources in line with triple constraints. Followed up with weekly project status, organized task review meetings, conducted status meetings, managed deadlines, and facilitated prioritization discussions.
• Working knowledge of implementing Service Oriented Architecture involving Web services, Web methods, MT servers and Data mapping.
• Ability to produce high qualityrequirement specifications to support ERP functional design development.
• Efficient at conducting UAT (user acceptance testing), Functionality testing, Unit testing, Integration testing, System testing, Operation Readiness testing and Regression testing.
• Extensive experience with Data Warehousing, Extraction, Transformation and Loading (ETL) and Business Intelligence (BI) tools.
• Proficient in producing documents like Business Requirements Document (BRD), Functional Requirement Specifications (FRS), Software Requirement Specifications (SRS), Request for Proposals (RFP), Statement of Work (SOW) and Requirements Traceability Matrix (RTM).
• Adept in creating Use Case diagrams, Activity diagrams, Sequence diagrams, Flowcharts, Key Performance Indicators (KPIs) and experienced in change management.

TECHNICAL SKILLS:

Requirement Modelling: Lucidchart, Creately, ARIS, System Archit, ErWin, Click Chart, Balsamiq

Prototyping: Flinto, Proto, iRise

Requirement Communication: JIRA, Confluence

Data Extracting: Micro Strategy ETL, Talend Open Studio, SQL, MongoDB Shells

Reporting: Jasper Soft, Tableau

Analytics: Google, KISSMetrics

Dashboarding: Microstrategy, Dashthis

Issue Management Tools: ALM, Rational Clear Quest, Quality Center (QC), Test Director, Compuware QA Director, MKS Integrity Manager, Compuware Track Record, PVCS Tracker, Rational Requisite Pro, Rational Test Manager, Rational Manual Tester, Bugzilla, Compuware Reconcile

Database Management Tools: Oracle, SQL Server, DB2, AS400, MYSQL, MS Access

Database Tools: DB Visualizer, SQL Navigator4, SQL Developer, Oracle Developer 2000, TOAD, Compuware File Aid/CS, Compuware QA Hiperstation

Operating Systems: Mainframe, Linux, HP Unix/Sun Solaris, AS/400, Windows

Web based tools: PHP, Servlets, EJB, ASP, COM, DCOM, JDBC, RMI, MQ Series, HTML, DHTML and XML

Programming Languages: Java, C

Scripting Languages: Java Script, TSL, VBScript, Java script

Application servers: Apache Tomcat, Web Logic, Web Sphere, IIS, and JWS

DevOps CI CD: Maven, GitHub, Jenkins, Bamboo, Docker, SOAP UI, Post Man (API), Ant, Selenium Web Driver

Network: TELNET, FTP, HTTP, TCP/IP

Project Management Tools: MS Project, MS Project Web Access, Niku Portfolio Manager.

Others: Ingenium, MS Word, MS Excel, MS Power point, MS Front page, MS Outlook, Lotus Notes/Domino

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst

Responsibilities:

• Worked closely with multiple project stakeholders all thru CBAW (TD Wealth, TD Retail Banking, Auto Finance and Credit Cards), in order to identify business scope, perform a business function study and technical study
• Conducted interviews with key business users to collect additional information on business processes and functional requirements
• Performed elicitation of requirements from the business function study and the technical aspects study.
• Documented all key artifacts like the BRD, SRS, AS-IS (Current State & Capability), TO-BE (Future State & Capability), Gap Analysis based on detailed study and analysis on business needs and system requirements.
• Conducted review sessions with the Business Stakeholders, Project Management Teams, in order to review and sign off business requirements
• Developed detailed DOU (Document of Understanding) for every project untaken, in order to ensure all knowledge and detail is captured and stored in the knowledge repository.
• Used UML to articulate business and system workflow to the project team members within functional and Non-Functional requirements
• Chaired multiple brain streaming sessions on various requirement artifacts
• Worked in an Agile Scrum project environment.
• Worked closely with several set of vendors which included Symcor, IPOS during the roll out of Funds Facts for Mutual Fund customers.
• Worked with different Book of Record data, which included IBM, SEI Trust, SMS, Prime Base, MPower in order to validate data inputs into several source systems which include DPP, EDPP and FATCA
• Assisted in loading of BOR data on DPP and EDPP for the purposes of creating client reporting statements and performing a end to end test.
• Worked with Trades orders from IBM OMS, FIP system, as part of a reconciliation test effort, IIROC compliance, and also EDPP and DPP transformation initiatives
• Collaborated with cross-functional teams to develop reports and dashboards using tableau to analyze various financial trends
• Forecasted financial and traffic metrics for peak periods by analyzing trends for previous years
• Created weekly data quality reports extracting data, applying business rules and building dashboards using Tableau
• Was accountable to manage resources allocations, as per the project deliverables for each project initiative.
• Created detailed status dashboards in order to keep management informed on daily updates for various projects managed in parallel.

Confidential

Business Analyst

Responsibilities:

• Worked in a large-scale enterprise project environment, where teams were demographically located in Amsterdam, USA, Dublin, Manila and Australia.
• Worked closely with all project stakeholders and project executives to align business deliverables for all major releases for both AXI and ECM.
• Provided detailed estimates on various release backlogs to the SCRUM Master (PM) for both AXI and ECM.
• Participated in JAD sessions with expert advisors, fund managers and IT teams
• Conducted Elicitation and documentation of Business Requirement Documents (BRD) and Functional Requirement Specifications (FRS) by interviews, document analysis, requirement workshops, business process descriptions, business analysis and work flow analysis
• Chaired working groups and taking ownership of issues raised, and ensuring resolution or escalation
• Designed screen forms and reports that adheres business rules
• Worked with Subject Matter Expert and created Data flow diagram and created mapping for physical and logical databases. Used decision tree modelling technique for clarification of input and output parameters
• Performed Data analysis and validated data using excel and SQL queries
• Coordinated and collaborated with AWS (vendor) for cloud implementation
• Experience in developing test plans and strategies and have conducted User Acceptance Testing (UAT) with users and customers and wrote issues log based on outcomes of UAT
• Dataflow analysis using UML Diagram like use cases, dataflow diagrams, state diagrams, activity diagrams, class diagrams and collaboration diagrams using MS Visio
• Developed business process descriptions using use cases (MS Visio), scenarios, and task/workflow analysis.
• Involved in internal SDLC process improvements for the purpose of improving the quality of IT support to enhance overall customer relations and expectations.
• Developed and documented business requirements which includes wire frames and Business workflows
• Supported the offshore team in Manila on a daily basis in defect triage meetings, to provide business updates and help resolving ongoing issues/concerns on the business workflow.
• Lead the BAT process following the use case model and ensuring signing off prior to each deployment.
• Used Confluence for creating and maintaining business requirements

Confidential

Business Systems Analyst

Responsibilities:

• Responsible for enhancement and maintenance of business requirement document
• Interfaced with FX traders to prepare/update/modify Business Process Requirements (BPR), Software System Requirements (SSR) and Functional and Technical specification document
• Assisted IT Technical lead(s) in the creation of appropriate Technical Design documents in support of business requirements by providing technical guidance concerning business implications of various application development projects
• Performed dataflow analysis using UML Diagram like use cases, dataflow diagrams, state diagrams, activity diagrams, class diagrams and collaboration diagrams using MS Visio
• Supported the trading environment including daily user support, batch processes, and new enhancement projects, used the analysis to make operating decisions and to improve the Business process
• Coordinated the reconciliation of reports between source and new data ware house and recommend data mapping best practices as a part of the overall system design.
• Performed Data Mapping of user interface data requirements to enterprise services
• Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured that appropriate documentation is in place.
• Coordinated testing preparation and execution in support of all business requirements so as to achieve business sign-off on all business IT requests.
• Defined project milestones, schedules, monitoring progress using MS project and updating plans as required
• Defined user and system requirements for existing and proposed system during existing system integration and new system development initiatives.
• Initiated Use Case analysis using UML which provided the frame work for potential use case deliverables and their inter relationship and how maximizing software reuse

Confidential

Business Systems Analyst

Responsibilities:

• Conducted extensively brainstorming sessions with client ( Confidential ) and different levels of Symcor management to identify new requirements, use cases and to develop functional and technical specifications
• Interacted with stakeholders and gathered requirements as per the business needs.
• Provided primary liaisons between business/operations/core processing technology team and external development team.
• Utilized Agile Scrum methodology and conducted Daily stand up meeting, Sprint Planning meeting, Sprint Review meeting, and Sprint Retrospective meeting.
• Conducted GAP analysis by understanding the AS-IS system and the TO-BE system requirements by having discussions with the SME’s.
• Maintained project documents to be used for collaboration with developers, QA, project manager, etc. on Confluence.
• Utilized UML for process modeling and created Use Cases, Activity diagrams and Sequence diagrams using Rational Rose and MS Visio.
• Analyzed and Developed bi-directional integration between Service Now and JIRA using Workato.
• Gathered UI requirements to build service now forms. Created Mock-up screens using Axure.
• Performed Admin responsibilities for JIRA and Confluence. Responsible for upgrading to new versions of JIRA.
• Responsible for creating Disaster Recovery Plans for upstream and downstream applications handled by the team.
• Responsible for gathering requirements and documenting the functional and technical requirements for Computing labs in the cloud.
• Monitored project status to ensure progress toward completion, required procedural steps are completed fully and timely, participants are informed of progress.
• Responsible for Risk Analysis to detect the risks associated with the development of the new system.
• Additionally, formulated a Mitigation Plan to remove or reduce risks of high severity and one that would have major financial impacts.
• Created UAT/QA test plans, strong manual, functional, system and regression testing in an agile development environment.
• Worked on Service Now and JIRA ticketing Tools.
• Developed UAT Test Plan and UAT Test cases based on the Use cases and Functional specifications.
• Performed functional testing, reviewed and approved test cases and test results.
• Recorded all the test scripts and test results in Zephyr testing which is an add-on for JIRA.
• Provided to the testers and helped them in using zephyr testing.
• Conducted meetings/calls and classified the bugs as functional or technical (low, medium, high).
• Tracked UAT (User Acceptance Testing) to verify the implementation against the requirements.
• Collaborated with DBAs to perform data mapping using MS Excel and executed complex SQL queries to filter data from the MS SQL database
• Provided live support and for the end users.
• Responsible for interviewing and hiring new resources for building the Business Analysis team.
• Responsible for the new project resources on the application and system.
• Worked in the Agile Software Development methodology.
• Used JIRA for bug tracking, issue tracking and agile project management.
• Responsible for providing weekly status reports to the Program
• Worked on analyzing and escalating work effort and resource estimates for validating change requests.
• Worked closely with the Client ( Confidential ), Architecture and the Development teams to determine benchmarks, key performance areas on the application tier, middle tier and DB tier and System Load expectations, Incorporated the same into the performance test requirements.

Confidential

Project Manager

Responsibilities:

• Worked as a Project Manager for NeMO Phase 1 and Phase 2.
• Managed a team of 32 members, which involved, Business Analysts, QA Team, Development, Database Management, Configuration and Release Management Teams.
• Developed detail project plans to determine project timelines using Agile methodology
• Elicited requirements by interviewing clients and analyzed the information to create user stories for the development of software solution
• Organized daily SCRUM stand up calls with User experience team and Software Development team using JIRA
• Generated visualized report based on the statistical analysis of the data using MS Excel (pivot, V-lookups, SumIfs)
• Conducted data analysis, wrote mid-level SQL queries to interpret and generate reports as per specifications
• Created complex Stored Procedures, Cursors, and SQL Joins to maintain transactions and user data
• Performed unit and functional testing to make sure the deliverables are match with business requirement using SharePoint
• Initiated Process Improvement by introducing deployment checklists, Risk Analysis and comprehensive reporting.
• Managed biweekly production releases for Phase 1; developed deployment schedule, deployment checklists, smoke testing schedule and provided deployment signoff.
• Worked closely with various project teams within Confidential located at Austria, London and Hong Kong
• Worked very closely with vendors TT (Trading Technologies) and ORC, for trading on both EMEA and AMRS regions.
• Worked on various feeds like Reuters, GPK & GMI
• Provided detailed reports to the Steering committee on a weekly basis.

Confidential

Business Systems Analyst

Responsibilities:

• The objective of the project was to replace the legacy Plaid Wealth Management tool with the new X.eye Wealth Manager, the tool integrates customer relationship management (CRM), contact management and portfolio management into one system, for the Investment Executives to perform day to day activities with Accounts, Portfolios, Positions, Transactions, Business Units, Investment Policies and Portfolio Models. Trading was performed using FIX protocols.

Confidential

Business Analyst

Responsibilities:

• Clink Link assists Investment Advisors in documenting client background and objectives, updating current client holdings, modeling proposed portfolios, developing transition plans, and producing reports, including the Investment Policy Statement. This information is then consolidated into a rich proposal package for a client or prospect in an easy-to-follow customized format that uses pie charts and bar charts.

Confidential

Business Analyst

Responsibilities:

• IT Mutual Funds and Segregated Funds Integration project is associated in Conversion and Reconciliation of Data for Clarica Life Insurance and Confidential Services of Canada Inc. for the sale of their respective Mutual Fund and Segregated Fund Business to Confidential Inc. Primarily involved integration of information present on Clarica’s systems on to CI Mutual Funds system.