We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

Pittsburgh, PA


  • Around 8 years of Industry experience as a Business Analyst wif solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, and Application Design.
  • Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and testing various methodologies.
  • Hands - on working experience in Leading Market product such as Charles River and Eagle Pace.
  • Strong understanding of banking requirements and regulatory compliances,CCARRegulatory Reporting, Basel II, Dodd Frank Act, Bank Secrecy Act, Customer Identification Program (KYC).
  • Extensive knowledge about theAML, Patriot Act, BSA, SAR, OFAC, Dodd Frank regulation, procedures and practices.
  • Experience in Salesforce.com Administration, operational analytics, project management, and quality assurance wif emphasis on process improvement.
  • Expertise in integrating Salesforce solutions and keeping teh Salesforce application aligned to teh project success criteria.
  • Excellent knowledge in Asset Management, Wealth Management, Investment Banking, Derivative products. such as Options and Futures, Credit Card, Insurance, Bonds, Sarbanes Oxley Act (SOX),GAAP, GAAS, IFRS, CCAR.
  • Knowledge in teh ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence.
  • Strong knowledge of teh Software Development Life Cycle methodologies (phases and gates) like Agile and Waterfall models.
  • Expertise in Project Management me.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
  • Experience in writing SQL queries and optimizing teh queries in Sybase, Oracle and SQL Server.
  • Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.
  • Extensive experience in assisting developers built Service Cloud, Sales Cloud and other Custom cloud applications on Force.com platform for different business groups
  • Expertise in UML ( Use case Diagrams, Activity, Sequence Diagrams) by using MS Visio, BPMN diagram( just started).
  • Providing functional and technical guidance of Salesforce Best Practices for Implementation to Business Project Leadership.
  • Expertise in Business Process Management Suite (BPMS), evaluating alternatives, reviewing recommendations wif management, proactively managing change In-depth knowledge of Business Modelling methodology and tools such as MS Visio.
  • Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
  • Expertise in interaction wif teh business users to gather requirements based on theCCAR Regulation for Financial Statements, Basel II, Dodd Frank Act, Bank Secrecy Act, Customer.
  • Online banking application dat enables customers to access their checking and savings accounts, and credit card account using teh Internet.
  • Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.


Business Modeling Tools: Rational Rose, Rational Enterprise Suite, MS Visio, Telelogic System Architect

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)

Change Management Tools: Rational ClearCase, Rational ClearQuest

Project Management Tool: MS Project

Analysis / Modeling tools: UML, JAD, RUP, RAD, ETL, Informatica 7.1.1/6.5

Testing Tools: Loadrunner, Test Director,Mercury Quality Centre, JIRA

Operating Systems: MS Windows NT/98/95/2000, UNIX

Languages: SQL, UML, JAVA

Database: Oracle 8i/9i, SQL Server 2000, MDM, Teradata,MS Access

Utility: MS Office Suite Word, Project, Excel, Visio, PowerPoint, Adobe Acrobat Suite


Confidential, Pittsburgh, PA

Sr. Business Analyst


  • Created both data sourcing and functional controls according to BCBS 239 Principals.
  • Co-ordinated Master List of all controls in teh pipeline off of SharePoint as per quarterly release.
  • Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers.
  • Conducted JAD sessions for requirements gathering wif extensive use of MS Office, Visio, to create process flow diagrams, use case diagrams analysis and to design of teh Property & causality modules.
  • Performed UAT tests, and documented Production Verification Results for teh projects.
  • Proficient in SalesCloud, ServiceCloud, Salesforce Console, Force.com, Marketing Cloud Chatter, App exchange and community cloud set up in Salesforce.
  • Worked wif design team to review teh design and SPI contracts.
  • Consult wif Business units and Subject Matter Experts for Big data analytics to partner, clarify and document project objectives to clients.
  • Work extensively to work on different line of business like Group Life Insurance, Annuities, Pension plans, Group Benefits etc.
  • Worked wif cross functional team for teh requirements gathering. Creating new servicing FRD's, give a walkthrough on FRD's to offshore, onsite team. Update teh documents on JIRA confluence page.
  • Work on analyzing teh response and request parameters for web applications and write teh functional requirements for teh design team.
  • Participate in teh web application design review to make sure teh standards and teh functionalities are covered and met by teh SPI implementer team.
  • Performed analysis and recommendation of teh Force.com PaaS from Salesforce.com.
  • Write test cases and give inputs on teh test case's to make sure all teh scenarios are covered.
  • Conduct daily scrum calls and maintained impediment log.
  • Transform, format, and load FLAT FILES and XML files into SQL DB wif write SQL queries to extract data/XML string from databases/ODS and parsed teh data and store result in SQL tables based on teh XML process and also create and maintain Data Model, database to capture parsed XML and parcel it for reporting through crystal and excel.
  • Acted as administrator on Jira to create workflow, assign roles, track productivity and internal documents wiki for high level requirements/stories.
  • Work in various internal selling and project management systems to obtain and verify information related to service requests and to communicate wif others involved in teh quoting process.
  • Initiated teh inclusion of an e-marketing platform (IBM - Silver Pop) integrating wif Salesforce.com to facilitate lead profiling and sales follow-through for more TEMPeffective lead generation and closing rates
  • Organize and facilitate agile and scrum meeting which included sprint planning, daiy scrums and standups, sprint checking and sprint review.
  • Customized teh Dashboards to teh track usage for productivity and performance of business centers and their sales teams.
  • Worked on BLUE PRINT to update, review, and study BRD's, FRD's, also provide comments on any of teh reviews.
  • Created and modified database objects like tables, views, procedures, functions, triggers, packages, indexes
  • Developed SQL and PL/SQL scripts to transfer tables across teh schemas and databases.
  • Act as Property & causality SME for business change requests and also in teh decisions control.
  • Implemented Salesforce Service Cloud functionality such as ebto Case, Live Agent, Knowledge Base, Communities, Profiles, Permission Sets, and Organization Wide Defaults.
  • Worked on detailed training decks and support guides for both standard and new custom applications wifin Salesforce.com (SF) and Eloqua Marketing Automation tool.
  • Followed teh UML methodology using MS Visio to develop use cases and activity diagrams for customer enhancement processes.
  • Conducted customer walkthrough for Use Case and Test Plan approvals.
  • Played a critical role in UAT and ensured dat all teh documents are handed over to teh customers for their refence in future.
  • Work on Change requests and document teh changes in FRD documents and give walkthrough on wat has changed to onsite, offshore teams.
  • Used JIRA to manage deployment and integration wif GitHub.
  • Perform Impact Analysis and coordinate wif development, QA, Design teams to estimate teh effort for teh change requests and provide teh input to business.
  • Worked wif teh SFDC team to gather requirements and write teh user stories and high level FRD's.
  • Developed & executed several Optimized queries in SQL on this data.
  • Provide support toBusinessUnits for Large Currency Reporting (LCR), Anti Money Laundering,ActimizeKYC, SASAML and Suspicious Activity Report (SAR) Filings.

Confidential, Chicago, IL

Sr. Business / Data Analyst


  • Develop BRD and data mapping logic to 14Q line items and Pre-provision Net Revenue (PPNR) configuration in Axiom, validating teh data mapping using SQL developer.
  • Reviewed and selected Charles River (CRD) OMS/trading software package via IT standardized RFP process.
  • Identify and analyze business problems and defined teh scope of activities required to address issues, including requirement definition, logics changes, process review, impact assessment and operational streamlining where necessary
  • Involved depth understanding of Credit Risk management for teh application.
  • Responsible for investigating and explaining business drivers underpinning significant financial movements across B/S, funding and RWA for LOB's, senior management, LEC's, Corporate Reporting.
  • Main duties included project management of teh Active Equities Trading Charles River IMS (v8.2) integration initiative migrated from Macgregor XIP.
  • Customized tabs for among different business users groups and business centres.
  • Worked on Salesforce setup menu, Configuration, Administration and Data Migration of applications to Force.com platform.
  • Developed training in an integrated ERP environment to support teh implementation of Salesforce Lightning/Classic, Provided Salesforce general Administration support to manage users.
  • Gatheird, analyzed and created Functional Requirement Document (FRD)
  • Created wireframe diagrams and business process models using MS Visio.
  • Created and maintained use cases and traceability matrix.
  • Manage teh Agile Tool for tracking work (JIRA).
  • Used JIRA to document user stories, acceptance criteria, attach mockups and more components.
  • Assisted offshore QA team in creating Test Cases, Test Plans and strategies to ensure dat business requirements were being addressed and tested.
  • Coordinated user acceptance testing (UAT) and provided biweekly updates to management on progress, issues and actions.
  • Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
  • Conducted Joint Application Development (JAD) sessions wif IT groups. Identified teh Key Changes, and participated in Stakeholder Management to communicate TEMPeffectively wif them.
  • Implemented teh requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse.
  • Involved in preparation of test cases for source to target count testing and other ETL business functional tests.
  • Discussed wif SMEs across different businesses units to gain solid knowledge of teh existing Credit Risk Calculation System and assisted in preparing an advanced Risk Assessment and ROI Management.
  • Prepared Business Requirement Documents (BRD’s) after teh collection of Functional Requirements from System Users dat provided appropriate scope of work for technical team to develop prototype and overall system.
  • Interacted wif Architects, business and other stakeholders and created teh Back-End Use Cases for Online Payments project.
  • Map business functions underlying data and data models, perform data reconciliations, gap analysis at function and data level for CCAR reporting .
  • Integrated Salesforce using SOAP and REST API Integration.
  • Create data maps in teh FR-Y 9C, 14Q and analyze in detail FR-Y 9C HC-K, 14Q PPNR Schedules to achieve automation process.
  • Collaborate wif Axiom developers to link data to Federal Reserve Schedule templates .
  • Liaise wif Axiom team to co-ordinate all aspects of testing, including planning, execution and close out of UAT phases wif reporting team.

Confidential -San Francisco, CA

Business Process Analyst


  • Drove to deliver Statement of Work, High Level Design, Detail Design Document, Systems impact analysis,
  • Testing plan reviews, project estimation, solution architecture and continuity of business (COB) setup.
  • Teh system provides enhanced Business Process Management (BPM), new Portfolio Reporting System for High Net worth Clients and Credit Risk Management.
  • Interviewed Business Users to gather Requirements and analyzed teh feasibility of their needs by coordinating wif teh PM and technical lead.
  • Worked wif FAs and RAs to conduct Credit Risk Measurements like calculation of RWA (Risk Weighted Asset).
  • Worked throughout teh SDLC, which included requirements, specifications, design, analysis and testing utilizing Agile methodology.
  • Conducted a comprehensive use case analysis to determine key abstractions such as loan underwriting,
  • loan-closed, borrowers-info, mortgage-payments etc., and their mapping to teh standard analysis mechanism to enable maximum reuse.
  • Development of tools designed to improve teh accuracy and efficiency of existing accounting processes.
  • Interacted wif Architects, business and other stakeholders and created teh Back-End Use Cases for Online Payments project.
  • Interacted wif users for verifying User Requirements, managing Change Control Process, updating existing Documentation
  • Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
  • Wrote SQL statements to extract data from teh Tables.
  • Developed excel models to derive teh amortization schedule for Whole loan products and Mortgage Backed Securities.
  • Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
  • Assisted QA team in developing Test Scripts, Test Cases and Test Plans for teh User Acceptance testing (UAT).
  • Worked on Documentum for Version Controlling, to maintain up to date changes in teh Documents.
  • Conducted User Acceptance Testing, gatheird and documented User Manuals and Business Rules


Business Analyst


  • Facilitated JAD sessions wif teh stakeholders to elicit teh requirements.
  • Worked wif JIRA entering user stories into respective epics, tasks and assist wif prioritizing stories for sprints.
  • Experience wif Agile/Scrum methodology, SDLC and well versed in developing user stories, designed collaborative business model (Visio)
  • Worked wif product owner to gather elicit requirements.
  • Participated in daily stand up meeting, sprint planning meetings, created use case and activity diagrams to further define requirements.
  • Delivery of status updates of documents to be reviewed by senior system analyst and well as to teh client.
  • Experience wif JIRA and understanding reports and issues, risk management, project and task, wif helping of release backlogs.
  • Assisted in testing of sprint stories for signoff.
  • Use of Microsoft Excel and PowerPoint to demonstrate requirements aspect based on client.
  • Active participation in System Analyst meeting as well as incorporation of details based on client.
  • Manually verified teh validity of teh failed test cases, Performed Positive, Negative and Black box testing on teh application, performed automation testing in QTP recording and playback.
  • Designed and developed test scenarios and test cases based on technical specifications.
  • Worked closely wif team to define: test scope, gap analysis, risk analysis, and test dependency.
  • Performed UI testing on application's web interface.
  • Tracked defects and facilitated defect review meetings wif team leads.
  • Performed regression testing on teh application for testing validity of functionality in different versions of teh application.
  • Attended weekly status meetings wif Development Team, QA Manager, and created notes for meeting-minutes.


Business Analyst


  • Facilitated JAD sessions wif teh stakeholders to elicit teh requirements.
  • Developed Use case diagrams and relationships of association and composition.
  • Developed key Use Cases which TEMPhas significant impact on architecture of teh application.
  • Responsible for delivering BRD's, User stories, Use cases and Process diagrams using ARIS and BPMN.
  • Worked on teh development of non - functional requirements.
  • Estimated, Resolved escalated teh issues and risks.
  • Developed traceability matrix for visibility from FSD, BRD to Test case and defects.
  • Validated, categorized and prioritized teh requirements.
  • Coordinated wif teh project manager regarding teh planning of teh releases.
  • Worked as a scrum master and facilitated concurrent releases and designed Kanban's.
  • Reviewed Test Strategy, Test Plan and Test Cases documents wif teh Testing Team and provided my inputs to teh team.
  • Utilized data to create dashboards and performance matrices for review.
  • Reviewed and signed off test cases as a delegate to Application Business Owner.
  • Wrote SQL queries to generate ad-hoc reports, validate to maintain data integrity.
  • Created multiple SharePoint site collections using teh different templates based on teh needs, created user guide and trained teh business users.
  • Worked on time estimations in teh See Now Do application for teh all phases of teh project.
  • Involved heavily in teh UAT to validate all key scenarios as a delegate to business User.
  • Created and published teh project status in SharePoint and HP QC for approval process.
  • Worked wif business, Identity and Access Management (IAM) team for teh requirement gathering on user privileges, authentication and authorization policies, single sign-on, access level instructions on IAM.

Hire Now