We provide IT Staff Augmentation Services!

Senior Business/data Analyst Resume

Cary, NC

SUMMARY

  • Proficient Sr. Business Analyst/Data Analyst/System analyst & Financial Advisor with over 10 years of experience in finance Industry managing investment portfolios for investors.
  • Extensive knowledge of the Software Development Cycle (SDLC) (Waterfall, RUP, Agile).
  • Experience as a scrum master/Project coordinator, maintaining product backlog, creating user stories, in capturing/analyzing Business, IT & Functional Requirements, Business Process Re - engineering, and Object-Oriented Design / Modelling, Service Oriented Architecture and Project Management activities, and good understanding of commercial and business issues.
  • Extensive experience researching broad range of securities, corporate action, risks and security clearance via OCC/DTCC.
  • Strong technical background and excellent communication and analytical skills, which allow me to fulfil variety of different roles within projects, teams and provide an effective interface between business and technical functions.Experience in snowflake and star schema databases, data warehousing, AWS, Mainframe and data analysis.
  • Strong understanding of Capital Markets, Fixed Income, Equities, Derivatives, Risk Management, Mutual Funds, mortgage products, Collateralized Assets, consumer and commercial lending, Loan Processing Applications and Portfolio Management.
  • Deep understanding of capital market and banking regulations - AML, KYC, & Dodd Frank/Volker regulations.
  • Strong experience as a lead BA in Requirement Gathering, Gap analysis, Use case Design, various project documentations like Business Requirement Document (BRD), Functional Requirement Document (FRD). Ability to gather business and technical requirements from both formal and informal sessions through interviews, questionnaires, JAD sessions, conference calls, and liaising with the Project Management Office (PMO).
  • In depth knowledge of Process Mapping, Requirements Definition & Analysis and UML Modeling diagrams that included Use Cases, Activity flow diagrams, Process flow diagrams and Flow charts using Microsoft Visio. Experience in creating user mockups/ wireframes using MS Visio.
  • Experience in the Agile & Waterfall software Development Life Cycle SDLC methodologies.
  • Exemplary analytical and planning skills with the ability to manage multiple projects simultaneously and properly prioritize workload across projects.
  • Excellent communication skills (both verbal and written) and ability to work in a team environment. Strong quantitative, analytical, organizational, presentation and interpersonal skills. Ability to utilize new tools and adapt technologies in a rapidly changing environment
  • Experience in importing, managing, and tagging requirement documents, and designing project deliverables (Traceability Matrix) usingvarious tools.
  • Successfully handled all phases of projects as a scrum master/project coordinator right from inception to delivery including the definition of scope, estimation, demand forecasting, budgeting, kick off, planning, analysis, risk management, design, development, quality assurance, implementation, client on-boarding, user guides, training and post-production training.

PROFESSIONAL EXPERIENCE

Confidential, Cary, NC

Senior Business/Data Analyst

Responsibilities:

  • Was responsible for gathering of requirements from stakeholders
  • Held meetings with different downstream teams to gather requirement specification for their preferred downstream system feeds
  • Reviewed existing documents and reverse-engineering manual discount rate calculation and documenting same
  • Created Business Requirement Documents and reviewed same with stakeholders for approval
  • Created Functional Requirement Document, including user stories, use cases and mapping documents
  • Documented Test Plans and test cases based on requirement specifications
  • Engaged in Knowledge transfer sessions with new members on the team to coach them on established procedures
  • Engaged in demonstrations to stakeholders to review requirements, revision to requirements, and review of test results
  • Held weekly status meetings with stakeholders to discuss cost overruns, progression, and timeline of deliverables
  • Engaged in sourcing of data from different sources for currencies and countries in scope, from Bloomberg, Barclays, Risk-America, etc.
  • Conducted tests in both the development and QA environments, based on test plan and test cases.
  • Was involved in daily scrum/standup meetings, backlog grooming calls, retrospective meetings and demonstration meetings
  • Was involved in assigning of tasks and estimation of effort to complete tasks

Confidential, NY

Senior Business Analyst/Scrum Master

Responsibilities:

  • Gathered and analyzedbusiness requirements through interviews, surveys, and document analysis.
  • Conducted JAD sessions to facilitate requirements gathering incoordination with multiple teams in concert with the PMO.
  • As Scrum Master/Lead BA/Project Coordinator, I was involved in maintaining thecapacity plan, sprintbacklog, velocitycharts andburn downcharts.
  • As Scrum Master/Lead BA/Project Coordinator, I was involved in identifying and removing hurdles in the success of the sprintby working with every single team member.
  • Documented specifications for the Price, Yield,Coupon, Marketvalue.
  • ConductedBusiness Gap Analysis with respect to proposed enhancements and new requirements.
  • Conducted feasibility study through mapping of AS-ISBusiness processes versus TO-BEbusiness processes
  • Trained with the Capital Markets team on the forecasting process of treasury forCash, Investments & Debt and other Income & Expense.
  • Interacted with SME’s in identifying and documentingbusiness needs andcreated data flow, activity diagrams, andstatetransition diagrams using MS Visio.
  • Collaborated with production team to identify and map detailed existing processes, identify system gaps and developed user stories and user story specifications that supported overall strategy, goals and objectives.
  • Analyzed data sets which included equities, interest rates, andcurrencies using SQL.
  • Maintained Traceability Matrix for thecurrentbusiness processes and proposedchanges.
  • Documented test plans and testcases and ensured that the module was linked to market, and the securities were marked to market on report and presentedBack End Testing scenariosby using SQL server.
  • Conducted RegressionTestingto ensure the generation ofcertain datasets regardless of parameter selection.
  • Functioned as a primebrokerage relationship manager and handled field primebrokerage questions, all primebrokered accounts and filed investor inquiries.
  • Provided technical and procedural support for User Acceptance Testing.Tracked testing issues, maintained test matrix.

Confidential

Responsibilities:

  • Coordinated interviews and surveys with bankers and all frontline staff, underwriters, and middle office team
  • Performed as-is-analysis and GAP analysis of commercial lending and consumer lending system
  • Participated in sprint planning, daily sprints, sprint demonstration and reviews, sprint retrospective meetings and JAD sessions
  • Designed Use case diagram, Activity diagram and workflow diagram using MS Visio to make the technical team understand the requirement and process
  • Assisted in the creation of test plans, test cases and was involved in carrying out CIT, SIT and UAT testing
  • Designed Use case diagram, Activity diagram and workflow diagram using MS Visio to make the technical team understand the requirement and process.
  • Created data mapping documents and assisted Data Modeler in resolving any issues with Data Mapping and helped in financial data reconciliation.
  • Used SQL queries to retrieve and validate data from different databases and ensuring the quality of data received and required by the users.

Confidential

Responsibilities:

  • Assisted in Requirements elicitation and Analysis and created epics and user stories
  • Used requirements management tool JIRA for creating and managing of user stories.
  • Reviewed and approved all business and functional requirements documents for Basel compliance and reporting.
  • Supported prototyping activities that will validate business requirements and solution definition.
  • Understood company goals and practices and applies them when resolving a variety of problems.
  • Recommended Solutions using judgment, creativity, initiative, and sound technical knowledge.
  • Ensured that customer’s needs are met by taking personal responsibility for service and quality.
  • Overview of artifacts to be created and trainings available for the same.
  • Involved in the complete ETL process and created ETL mapping document in snowflake and star schema databases and data warehousing and Mainframe
  • Generated weekly, monthly and quarterly report on MBS, and performed data analysis, and demand forecasting

Confidential, Hopewell, NJ

Business Analyst

Responsibilities:

  • Performed as-is analysis of current systems and conferred middle office teams and frontline staff on preferred functionalities
  • Worked with other BA’s to create FRD and BRD
  • Utilized UML diagrams to present a visual representation of workflow and use cases
  • Participated in JAD sessions, daily scrum meetings, sprint planning, sprint demonstration and sprint retrospective meetings
  • Worked to create test plans, test cases and coordinated CIT, SIT, and UAT testing
  • Worked with ETL team to map and analyze data and create a mapping document in snowflake and star schema databases and data warehousing and Mainframe

Confidential

Responsibilities:

  • Gathered and documented business requirements based on current systems functionalities and from interviews with field FAs and compliance team
  • Analyzed legacy system, identified system interfaces that may impact the new system and developed requirements specification document for both Mainframe and comprehensive web-based applications.
  • Performed GAP analysis of current wealth management system, processes and compared with proposed system enhancement.
  • Verified functional specification and validated interface with web-based system and data conversion from legacy system.
  • Created UML diagrams to illustrate workflow, use cases and test cases
  • Used SQL to retrieve data encompassing vast customer risk profiles for use in creating alerts for field FAs
  • Created data mapping documents both snowflake and star schema databases and data warehousing, in co-ordination with the ETL team

Confidential

Responsibilities:

  • Managed retirement assets for client across the USA
  • Provided retirement education, investment advice, and guidance
  • Provided managed solutions and custom investment vehicles
  • Helped consumers and businesses set goals, and provided solutions to help them stay on track with their investment goals
  • Constructed goal-based portfolios in line with clients’ risk tolerance and time horizon and reallocated portfolios where applicable
  • Educated investors on retirement planning and investments
  • Researched securities and investment solutions and tailors same to investors’ needs

Confidential, Greenwich, CT

Branch Manager

Responsibilities:

  • Managed a branch with net deposit of $100 Million+
  • Conducted huddles, sets strategy worksheet, coordinate with assistant manager and partners
  • Observed bankers and engage in role-plays to effectuate efficiency
  • Co-ordinated conference calls for district, trade fairs, Wells@Work, and community outreach
  • Show-coached, managed, and motivated a team of 9 team members
  • Coached Tellers and bankers on effective customer service and needs assessment
  • Managed internal controls, expenses, and increase Profit and loss
  • Observed daily one-on-one meetings with bankers and Service manager
  • Strategized with partners and DM on effective positioning, referrals and closings
  • Implemented HR strategies, conducted interviews and recruitment
  • Assed the needs of affluent customers and prospects, and cross-sell to deepen relationship

Confidential, NY

Relationship Manager

Responsibilities:

  • Developed new relationships through networking
  • Worked the Lobby to service and deepen/cross-sell Customer/Bank relationship
  • Organized off-site sales campaigns with Businesses in New York
  • Engaged financial advisors to sell securities, generating unsurpassable sales
  • Worked with loan officers to meet the needs of customers on commercial lending, consumer lending, and mortgages
  • Partnered with Personal Banker/Small Business Specialist to meet the cash-flow needs of businesses
  • Conducted Branch Manager Involvement (BMI) for junior banker when the manager is absent
  • Conducted huddles and managed service escalations
  • Worked closely with clients to assess their needs and provide wealth management solution
  • Performed insurance reviews to assess clients’ insurance needs

Confidential, NY

Security Clearance Analyst

Responsibilities:

  • Security processing and operations, managing stock certificates, clearing and journals
  • Handled electronic transfer of options, via OCC/DTCC and re-organization/ corporate action securities
  • Generated weekly and monthly trading reports using SQL
  • Researched with the compliance team all trades for clients’ litigation and regulatory subpoena
  • Liaised with the IT, business, and middle office teams
  • Generated periodic corporate action lists using SQL and in concert with the IT team
  • Worked with the ETL team in warehousing data, data analysis, and demand forecasting

Confidential, NY

Account Executive

Responsibilities:

  • Developed new business relationships through cold calling to investors, domestically and across Europe.
  • Networked and courted affluent prospects to meet their personal and estate needs
  • Researched and implemented covered call option and straddle strategies for clients
  • Researched variety of securities for clients’ recommendation
  • Hired, trained, and managed teams of new brokers on a consistent basis
  • Managed portfolio of securities - Stocks, bonds, ETF, mutual funds, and private equities

Hire Now