Business Analyst Resume
SUMMARY
- 5+ years of experience in business analysis, business requirements modelling, and development of Web - Based and Client/Server.
- Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
- Hands-on experience with Adobe Target - Target and A/B campaign experience.
- Functional and Technical experience in Workday Confidential in Analysis, Design, Implementation, Production Support, Administration and Security Services.
- Experience working on Automated Financial Systems platform (AFS) in fully integrated commercial lending system designed to process multiple types of loans on a single, real-time, multibank, multilingual, multicurrency system.
- Extensive experience of Web Content Management System for e-commerce including Adobe Experience Manager (AEM), Magento, Drupal, Word Press to improve site performance, providing solutions to supplement sales strategies, price optimization and developing Predictive Analytic Solutions.
- Excellent documentation skills - demonstrated in documenting user requirements, creating all the necessary components of Business Requirement Document (BRD) and Functional Specifications Document (FSD).
- Familiar with Oracle, SQL Server, Postgres, DB2 and MS Access database.
- Facilitated weekly and monthly business review meetings to keep SME’s, Stakeholders, product managers, executive staff and team members apprised of goals, project status, resolving issues and conflicts and preparing product demonstrations.
- Skilled at performingGap Analysis, Risk Identification, Analysis and Risk Managementalong with good knowledge of process workflow tools and techniques.
- Technical expertise in BI Reports, DW ETL, Data profiling, Data Cleansing, Data Integrity, Deference Data, Data Security and Data Quality Management.
- Extensive experience in Securities Trading (stock trading, fixed income trading, and derivatives trading), wealth management, and risk management projects in Investment Banking.
- Excellent in designing business models using UML diagrams such as use case diagrams, class diagrams, activity diagrams, sequence diagrams and collaboration diagrams using Rational Rose and MS Visio.
- Expertise in the role of Scrum Master, facilitating/organizing daily scrum sessions, sprint planning meeting and sprint review meeting and preparing/analyzing burn down charts.
- Experienced in using Bugzilla, Jira, HP ALM/Quality Center to track defects, Triage, Validation, Root Cause Analysis etc.
- Knowledge of creating DCR’s (Document for Change Request) for change management for any new requirements.
- Excel in Data Visualization using Excel Pivot Tables, VLOOKUP, Tableau etc.
- Proficient with tools such as MS Project, MS Visio, MS Excel, MS SharePoint, Jira, TFS, etc.
- Experience leading Joint Application Development (JAD) sessions and White Board Sessions with end-users, Subject Matter Expert (SMEs) team, Architects and design group development, and QA team for project meetings, walkthroughs, and customer interviews, as well as excellent communication skills.
- Worked on multiple assignments with major project which was to develop the application for calculating Credit Risk Exposure for Trading system. The system calculates the pre-settlement risk and settlement risk for domestic fixed income, money market, secondary loan trading (Par and distressed loan), and commercial MBS.
- Generated reports using Tableau and publishing to Tableau Server.
- Excellent understanding of SOQL, SOSL, Web Services, Security Model, Data Loader, Profiles, Roles, Custom Object/Fields, Email Templates/Handling, and other Salesforce.com features.
- Team player and self-starter with excellent work prioritization, communication, coordination, documentation, project planning and interpersonal skills.
- Configured the Data mapping between Oracle and SQL Server and worked on Database security and integrity planning.
- Solid understanding of Object Oriented Analysis and Design OOAD, as well as proficiency in documenting as-is and to-be business processes.
- Experience in Salesforce CRM Administration, configuration, standard data model, security, and automation such as validation rules, workflows, and process flows and development.
- Created/Maintained business requirement documents, use cases, Process flows & End User Guidelines for Legal applications in Jira.
- Possess excellent communication and interpersonal skills to co-ordinate with offshore teams.
- Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
- Strong knowledge of information technology capabilities and dependencies, such as platforms, content management, e-document strategies, and process mapping.
- In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
- Excellent analytical, problem solving, communication and documentation skills along with good process management skills to gather requirement.
- Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
- Created Requirements Traceability Matrix to keep the stakeholders informed of the project progress.
- Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
- Dedicated team player with strong interpersonal and customer relationship skills, as well as demonstrated communication, organizational, analytical, and presentation skills and leadership qualities.
TECHNICAL SKILLS
Cloud Technologies/ERP: Workday - Core Connector, EIB, Report Writer and Security, Kainos - Testing tool, Document Processing: MS Office Suite.
Databases: Oracle, MySQL, MS Access, SQL Server, AQS, Access Express
Language: HTML, SQL, Php, Java Scripts, Python
Browser: Chrome, Firefox, Safari, Edge, IE 11
Web Technologies: HTML, CSS, XML, LAMP, AJAX
Project Management Tools: MS Project, JIRA, Rally
Banking Protocols: FIX, SWIFT
Defect Tracking Tools: Silk Central, Bugzilla and JIRA
Financial Terminals: Bloomberg, Reuters, Capital IQ
Other Tools: MS Office 365, SharePoint, Documentation, File Net, SFOC Sales, SAPSCM, Oracle OM, Trello, Outlook, Toad, MS Edge, Tableau.
PROFESSIONAL EXPERIENCE
Business Analyst
Confidential
Responsibilities:
- Significant involvement in requirement gathering, analysis, gap/risk analysis, and JAD sessions.
- Oversaw scrum team, daily Scrum Meetings, Planning, Scope, daily Status Tracking, Coordination, Problem Solving, Defect Triaging, Sprint Grooming, and Retrospective Meetings.
- Participated in CRM processes such as designing, developing, planning, testing, and integrating Salesforce Cloud services, data, and accounts.
- Met the manual, automation functional and non-functional deliverables with quality and time constraints.
- Ensure effective client and stakeholder engagement to mitigate risks and manage expectations.
- Creates use cases, user stories, functional specifications, diagrams, and technical documentation as needed to articulate requirements.
- Managed Salesforce.com SFA setup, including modifying roles and profiles, creating/modifying dashboards/reports, and managing users.
- Applied Unified Modelling Language (UML)methodologies to design Use Case Diagrams, Activity Diagrams, Sequence Diagrammed diagrams Data Mapping.
- Ability to independently perform implementation, documentation, testing and updating as it relates to the SalesForce.com business requirements.
- Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
- Created and analyzed reports and dashboards for various management and business unit personnel in order to provide detailed information on key performance indicators.
- Proficient in Code & Data Migrations using SFDC utilities & tools following the SFDC Development Life Cycle.
- Modelled the business and application using RUP methodology and UML. reated Workflow Rules to automate Tasks, Email Alerts, Field Updates, time-dependent actions and Outbound API Messages.
- Maintained Scrum tools such as story board, action boards, tasks, charts, backlogs etc.
- Involved in Salesforce.com application setup activities and customized the apps to match the functional needs of the organization.
- Created Visual force email templates, New Templates, Mail Merges and also automated Email Process to send installation instructions to new and existing customers.
- Using Data Management, developed and deployed workflows and approval processes for opportunities, products/assets, and mass delete/transfer records.
- Developed Rest Web Service to move the attachments from Qualtrics Survey to Salesforce.
- Managed and resolved Service Requests, including Custom Profiles, Public Groups, and Sharing Rules visibility issues.
- Worked on various Salesforce.com standard objects like Case Management, Accounts, Contacts, Content, Reports and Workspaces.
- Worked on SFDC Security Model - Roles, Profiles, Permission Sets, OWD, Sharing, & User Management.
- Directly interacted with clients (Ratings Analysts) to elicit the requirements and translate them into terms that development team can comprehend.
- Created Business Requirements Documents, Functional, Requirements Specification Documents and detail design specifications for Change Requests and Product Enhancements.
- Enhanced Wealth Management Systems for Front/Back Office Securities, Credit, Debt, and FX Markets, Risk/Asset Management, Derivatives, and Liquidity Reporting in Risk/Asset Management, Derivatives, and Liquidity Reporting.
- Used HP ALM (Application Lifecycle Management) to manage requirement traceability and maintain CRs, business requirements, system requirements, and configuration requirements.
- Used JIRA and Confluence tools for user stories and overall tracking.
Business Analyst
Confidential
Responsibilities:
- Interacted with business stakeholders to learn about their decision-making processes, analyze data to create Tableau Dashboards, and oversee delivery.
- Using Rational Requisition, extracted business requirements from end users based on their need for the application and created Business Requirement Documents BRD.
- Worked with Finance & Regulatory Report Automation Project (Dodd Frank and Call Reporting Process) to improve production efficiencies while lowering operational risk by implementing AXIOM SL, an automated reporting application.
- Participate in Workday Communities to remain connected with Workday and customers
- Designed, configured, and automated business processes to improve current application systems, such as hiring, changing jobs, terminating employees, and proposing compensation, among others.
- Designed and configured Workday compensation packages including salary, bonus, allowance, commission, and merit plans to accommodate JPA.
- Provided assistance in researching new capabilities within Workday
- Documented and translated data requirements and business rules for CCAR reports using the data dictionary for use in Axiom.
- Collaborated closely with a development manager on project planning, creating project schedules and resource histograms, and researching business cases for expanding system scope to support funding managers' intraday liquidity monitoring needs.
- Involved throughout the Software Development Life Cycle (SDLC)Scrum-Waterfall.
- Created Blank Instances from Source Maintenance - Axiom Controller View for the FFIEC 031, FFIEC 041, FRY 14M/Q Reports.
- Examined the various types of risks that needed to be considered, such as Asset Class Risk, which includes credit card, personal loan, and mortgage loan risks, among others.
- Scheduled and conducted meetings with client work group (SME’s) to identify requirements, and documented them in SRS document and identified priorities.
- Defined Test Scripts, created Test cases, analyzed defects, by interacting with QA /developer teams in fixing errors and writing simple SQL queries.
- Worked as part of the AXIOM team on the business rules and the change requests when there were changes from Dodd Frank.
- Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
- Configured Workday compensation packages including salary, bonus, allowance, commission, and merit plans for multiple countries including merit and bonus plan processing.
- Collaborated extensively with SME in understanding and documenting their requirements for monitoring changes and portraying a trend to maintain and analyze customer needs, as well as many other business areas.
- Process mapping, data cleansing, data migration and validation of data table structure in areas of sales, inventory, procurement, production and distribution.
- Released System Engineer for entire SDLC process by guiding tasks in JIRA, addressing each requirement, updating as needed based on team feedback, managing and refining product backlog under product owner's and Scrum Master's guidance.
Business System Analyst
Confidential
Responsibilities:
- Interviewed, discussed, and learned about the company's current overall business operations from multiple departments (Brokerage, Trading, and Fixed Income) and multiple locations.
- Worked with Trading and Accounting System business users to determine the system's criticality and the impact of a new data source.
- Provide fiduciary duty and the impact of DOL fiduciary standards on retirement plans, broker and insurance business effects, products and marketing, policies and procedures, advisor conduct, revenue replacement, fee transparency, conflicts of interest, and target market business model differentiation consultation to bank project managers and law firms.
- Served as extra AEM resource to Barclays IT Ops team and authors to solve various AEM content and digital asset issues.
- Created requirements for Fixed Income Investment Management Business, Portfolio Management, Hedge Funds, Corporate Actions, Brokerage, and Trading Model in the Front and Middle Office.
- Assisted PMO Leadership Team with the coordination and administration of the Project Management Office including but not limited to managing and adjusting project timeline, IT development work efforts for standardization of project implementations, administration duties, monitoring deadlines, activity, and issue tracking.
- In staging environment, conduct audits to insure AEM content migration accuracy and URL redirects
- Sybase Exodus Project: Worked as a senior test analyst on the migration of databases from Sybase to SQL server. Ran all the jobs in the SQL server environment as part of this project, compared the output with Sybase, and ensured that there is no change in the results.
- Automation: Wrote Selenium tests for automated testing of the ESM trading portal web application using Selenium Web Driver. Developed and maintained automated regression test cases in Selenium Web Driver using Java programming language.
- ESM to AC Flows Project: Verified and tested the major processes and data flows between ESM and AC environments. Ensured that correct AC identifiers are assigned to products and checked that update in ESM environment.
- Performed in-depth analysis of current state pricing flows across the business. Rationalized ten pricing feeds used by multiple business units. Developed process flows for a centralized pricing warehouse. Products covered included Equities, Fixed Income, and Derivatives.
- Contributed to various phases of this project, ensuring that proper alerts are raised in RTB when messages are stored in queues. Checked alerts and other logs with the Middleware team in New York.Verified the queues and messages stored in the queues in the SolMon tool.
- Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
- Was responsible for gathering QA requirements to create test cases based on the functional and nonfunctional requirements
- Worked as a QA Analyst for testing the applications and closely worked on agile software development methodology.
- Participated in the Logical and Physical Design sessions and develop Design Documents.
- Worked with developers to make sure that they understand the Use Cases.
- Created User and Training Manuals in accordance with Project Specifications and Deadlines.
- Designed and implement basic SQL queries for QA Testing and Report/Data Validation.
- Verified Business Scenarios on new builds to allow the QA team to test them further.
