We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

Reston, VA


  • Excellent technical writing skills to create User Stories, Business Requirements Document (BRD), Functional Specifications Document (FSD), Nonfunctional Requirements Document and Use Cases Specifications, Data analysis, Data Mapping.
  • Comprehensive knowledge of SDLC Methodologies like Waterfall and RUP.
  • Comprehensive knowledge of and Solid experience of Agile and SCRUM methodologies.
  • Adept in Coordinating extensive communication networks by facilitating Joint Application Development (JAD) sessions, interviews, written correspondence, escalations, change requests (CR), oral presentations, to keep executive staff and team members apprised of goals and project status, and resolve relevant issues and conflicts.
  • Hosted JAD sessions with business stake holders and fellow team members to capture the business needs and document them in a project plan to provide solutions.
  • Well versed in Requirements/Change Management, Impact Analysis and Gap Analysis.
  • Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
  • Solid Experience in developing Scope/Vision Documentation, Project Plan, tracking Project Process, and managing resources to ensure successful delivery.
  • Experience in process modeling using UML (Use Cases, Sequence Diagrams, Activity Diagrams, Process flows etc.) and Business Process Modeling Notation (BPMN).
  • Experience writing SQL queries and reporting the results to the business team.
  • Excellent Team player to work in conjunction with testers (QA), developers and other team members in validation and testing of complex project scenarios and in the maintenance of Quality Standards of projects.
  • Major Interface between the PMO, business line, operations and the technical areas throughout the project cycle.
  • Experienced in writing and preparing business requirements documents (BRDs), system requirements specifications (SRS), system design specification (SDS), functional specifications, defining project plan and change request.


SDLC Methodologies: Rational Unified Process, Waterfall, Agile (Scrum), Prototype, RADSalesforce Technologies: Salesforce CRM, Apex Classes, Visualforce, Integration, Migration, Dashboards, Apex Web Services.

Salesforce and Integration Tools: Eclipse, Force.com Force.com Data Loader

Programming languages: Apex, Java, Java Script, C, C++, ASP.Net, SQL

Web Design Tools: HTML5, XHTML, CSS3, JavaScript, XML

Database: Oracle10g, MS Access, SQL Server 2012, DB2

Defect Tracking Tools: Atlassian JIRA, HP ALM, Quality Center, Bugzilla

Project Management tools: MS Project 2010, Atlassian JIRA, Rally, PPMC

Languages: SQL, PL/SQL, Java, XML and HTML, Mainframe/DB2

Operating Systems: Windows clients, Windows server 2012, Linux

Documentation Tools: Office 365, MS Visio, Balsamiq, StarTeam, Rational DOORS

Technologies & Analytics Tools: Advanced Excel, SQL, SharePoint 2012, Tableau, Web Services


Sr. Business Analyst

Confidential - Reston, VA


  • As a Business Analyst, I was involved in full software development life cycle. The methodology used for this project was Agile/Scrum.
  • Coordinated with the stakeholders and project key personnel to gather functional and non-functional requirements during JAD sessions.
  • Created User stories and Acceptance Criteria for the new Automated Loan Quality Connect System (LQCS) Automated
  • Maintained WIP (Work In Progress) cards on Kanban board to maintain project increments
  • Participated in the Change Advisory Board Process to get the approvals on change requests
  • Supported the development team to update the sprint backlog and ensure the development teams are practicing the core agile principles of collaboration, prioritization, team accountability, and visibility.
  • Assisted PMs in preparing weekly/monthly project status reports to be provided out to senior level management/project stakeholders.
  • Facilitated User Story grooming session with Development team and documented user stories and acceptance criteria for the team product backlog in JIRA
  • Used DOORS to create and document Business Requirements and created link sets to link business requirements document to the scope document and functional specs document
  • Maintained metrics that provide visibility to stakeholders on program-level plans, progress and quality to ensure commitment to the quality. This information may take the form of various Scrum artifacts, from backlogs to burn-down charts
  • Defined business run-book mapping with Incidents/Problem/Tasks and catalog service requests on Service Now and BMC Remedy. This helped Enterprise Production Support (EPS) team to perform and escalate all severity tickets proactively at minimal timeline.
  • Investigated, analyzed and make recommendations to management regarding technology improvements, upgrades, and modifications.
  • Worked on Target Process to create and maintain User Stories, Acceptance Criteria, Story Point and Product Backlog for Iteration Planning and Release planning
  • Managed vendor and Inline cross-functional resources while working on deploying Infrastructural, Network and Client Requirements.
  • Used Agile methodology with Scrum to create user stories, specified Acceptance Criteria, and story pointed the user stories for accurate workload allocation.
  • Used MS-Visio to document current work flows, manual processes and end-to-end processing of system interactions
  • Participated in Scrum and Sprint Planning meetings, ensured successful and timely project implementation.
  • Developed and managed SharePoint site for communication and building effective presentations using MS Office.
  • Conducted workflow, process diagram and gap analysis to derive requirements for existing systems enhancements
  • Acted as a Primary Point-of-Contact between the client and technology team, gathered requirements from various end users and analyzed, evaluated, and implemented these requirements into appropriate Business and Technical solutions.
  • Project tracking and ensuring timely delivery of functionalities including documentation and proper approvals.
  • Deliver requirements under the Agile Scrum SDLC methodology to meet a very fast release schedule.
  • Performed Data Analysis of existing data through SQL and MS Access.
  • Executed SQL queries, to retrieve data from different databases, for data validation & analysis, researching underlying data errors, and generating reports.

Data Analyst

Confidential - Tampa, FL


  • Involved in all phases of software development life cycle in RUP framework.
  • Worked in the RUP environment for the elicitation, representation of requirements and in change management.
  • Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the process owners & stake holders and document analysis, represented them in requirements traceability matrix (RTM) using Requisite Pro. Performed user interviews and JAD sessions.
  • Assessed the flaws in the existing as-is system and made clear recommendations of Business process improvements and BPR, incorporated them in the future to-be system design.
  • Wrote user requirements specification (URS) and Functional requirements specification (FRS) documents as per the business requirements and process flow.
  • Designed and developed project templates based on SDLC Methodology.
  • Developed UML Use Cases for the application using Rational Rose and prepared the detailed work flow diagram based on the proposed enhancement for the system.
  • Formulated and defined project objectives and system Scope, focused squarely on customer needs. Checked the Database changes by using SQL queries.
  • Generated requirements for Capital Markets - Fixed Income Investment Management Business, Portfolio Management, Hedge funds, corporate actions, Brokerage and Trading Model within the scope of both the Front and Middle Office.
  • Writing Complex SQL queries and optimizing SQL Queries
  • Developed and maintained Global Capital Market Systems databases, implemented Research Publishing System and Market Commentary Database, enhanced Customer Relationship Management (CRM) databases.
  • Assisted with the redesign of the chart of accounts and organizational cost center layouts.
  • Use Data Modeling (Physical & Logical), Data Analysis and wrote High level and Low-level Design Specifications for ETL and Business Intelligence (BI). Work with ETL team for data mart modeling to design complex OBI repositories & BI solutions.
  • Designed a custom process to handle specialized needs for the State of Alabama Encumbrance Requirements.
  • Understand and articulate business requirements from user interviews and then translate requirements into business model, process model, workflows, functional and technical specifications.
  • Played a major role in identifying the source and target elements implementing SQL queries.
  • Determine strategy and business requirements for capital market software products. Responsible for products pricing, workflows, operations, and P&L/position analysis, with a focus on Fixed Income, Interest Rate Derivatives, and risks.
  • Effective with the creation of artifacts and management of various roles specified by Rational Unified Process (RUP), Agile Methodology, RAD, Workflow Processes and Waterfall cycle method.
  • Reviewed and analyzed business requirements for International Fixed Income, Equities, Equity Derivatives and Prime Brokerage; developed business strategy and test plan
  • Designed and developed project templates based on SDLC Methodology

Business Systems Analyst

Confidential, Stamford, CT


  • Worked closely with project manager to prepare project plans, budgeting, scope creep and feature creep and analyzed the existing system and business process flow by understanding preset business rules and conditions.
  • Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle, worked with infrastructure team to understand Teradata for cloud migration.
  • Created the Data Mapping document which highlights the mapping logic of data between source platforms and enterprise Data Warehouse through ETL process to ensure data quality.
  • Worked with cross functional teams to establish comprehensive business and functional requirements and translated those requirements into functional specifications in a Hybrid Agile environment.
  • Queried the Data Warehouse through SQL to access/extract data for validation and reporting purposes. Written and executed complex SQL queries for back-end testing.
  • Encryption and decryption testing of all file types, by using available options, methods and levels.
  • Created and delivered elegant visual user interfaces utilizing user-centered design principles to development teams for the UBS Neo mobile application.
  • Participated in adaptive Agile planning throughout the lifecycle allowing resources to be redirected depending on new discoveries that come to light during each sprint.
  • Implemented and maintained user access, process and procedures to prevent unauthorized access. Modified user access controls to maintain company information security throughout the entire network.
  • Create Data Flow/data Lineage Diagrams (DFD/DLD) to depict the source-to-Target Mapping and Data Lineage Analysis. Analyzed project requirements to design hierarchy management solutions and data visualization for Analytics, design of analytical charts and customized reports for integration to application screens.
  • Worked in Agile Delivery Model to design User Stories for iterative development, worked with delivery teams to translate system requirements into story documents, received input and estimates for Scope capture.
  • Performed Data cleansing and Data profiling for detecting and correcting inaccurate data from the databases and to track data quality and assess risk involved in integrating data for new applications.
  • Implementation of Information Security & Corporate Compliance Policies during new project platforms.
  • Advanced Excel knowledge including pivot tables. Proven experience in data manipulation.
  • Worked on data manipulation, cleansing, and analyzing data using MS Excel and SQL
  • Assisted in identifying and quantifying Credit Risk, Operational Risk and Market Risk and designed and developed project document templates, Data model diagrams and UML model documents for development.
  • Worked extensively in designing the database with the design team and created data flow diagrams, data analysis, and Process flow diagrams using Erwin.
  • Facilitated and managed Joint Application Development (JAD) sessions, Interviews with subject matter experts (SME’s) from various areas and conducted surveys and brainstorming sessions while gathering requirements. Utilized Agile methodology which emphasized on real time communication in a fast-paced project environment.
  • Analyzed the AS-IS and TO-BE processes to understand the key findings, the short-term considerations, the long-term considerations and its benefits.
  • Involved in mentoring specific projects in application of the new SDLC based on Agile Solution Delivery, especially from the Project Management, requirements and architecture perspectives.
  • Created the project templates for Use case specification, Change request form, functional specification documents, Business Requirement Documents and Defect Status Forms.
  • Conducted User Acceptance Testing (UAT) and trained users on the implemented system.
  • Involved with the technical teams during implementation such that right business requirements are being translated into the system. Worked closely with QA teams to define test cases and execute test plans.

Environment: UML, MS Office, MS Project, HP Quality Center, Agile, Oracle 11i, DB2, PL/SQL, C#, Windows services, SQL Server 2014, SQL Developer, XML, SharePoint, JIRA, Excel.

BA, Microsoft Dynamics CRM Analyst

Confidential - Phoenix, AZ


  • Performed Functional Requirement reviews and walkthroughs with the designers, developers and stakeholders
  • Installed and configured MS Dynamics CRM 2013 system for development and testing, configured server instance, created organizations.
  • Integrated and monitored SharePoint 2010 integration with CRM 2013 for document management under different site security settings.
  • Discussed the requirements with end user and propose solutions to achieve business goals.
  • Customized system entities and custom entities to meet the business requirements.
  • Worked on data modelling and produced data mapping and data definition documentation
  • Create training manuals and conduct enterprise-wide formal training on the ERP system.
  • Used Bing Maps API to design and develop dashboards to display incoming customer requests and update address coordinates in the Microsoft Dynamics CRM.
  • Suggested several security policies on various entities in the system to manage and implement appropriate access controls
  • Migration of data from Excel source to CRM using SSIS.
  • Used Advanced Find feature of MS Dynamics CRM and created multiple views of System entities
  • Imported contacts from existing application into MS Dynamics CRM using the WCF service.
  • Analyze the requirements and map them with ERP systems (Microsoft Dynamics AX) without much code customization.
  • Customized the forms to extend the functionality and to meet the client requirements.
  • Provided CRM end user training for case and service managements for department staff.
  • Collected existing infrastructure information including Active Directory, SQL server, Reporting Server instance for implementation of MS Dynamics CRM system.
  • Created several plug-ins and workflows for enhancing the system and maintain data integrity.
  • Created custom asp.net pages and configured forms and views for new modules to be added to MS Dynamics CRM system.
  • Used SSRS create reports in the system to provide accurate data for business decision making.
  • Provided technical guidance to the team and participated in several sessions of code review.
  • Assisted the team in basic testing and deployment of the solution.

Environment: Agile, Salesforce.com, Microsoft Dynamics CRM, ETL, Rational Requisite Pro, Rational Rose, Informatica, SQL, UML, MS Visio, Oracle, Quality Center.

Business Analyst

Confidential - Chicago, IL


  • Acted as a Primary Point-of-Contact between the client and technology team, gathered requirements from various end users and analyzed, evaluated, and implemented these requirements into appropriate Business and Technical solutions
  • Conducted GAP Analysis, by interacting with business users and SMEs, to document the existing application (as-is) and capture the user's requirements for the proposed application (to-be).
  • Worked with Scrum Master, Product Manager, Agile coach and development teams throughout planning, design, development, testing, and implementation of feature product releases.
  • Owned the UAT process (creating use cases, iterative testing, UAT reviews & communicating testing issues & results to implementation teams).
  • Analyzed "AS IS" and "TO BE" scenarios, designed and documented new process flows business process and various business scenarios.
  • Utilizing Sprint retrospective Meetings to understand the impediments and improve the productivity of the team.
  • Used MS-Visio to document current work flows, manual processes and end-to-end processing of system interactions
  • Participated in Scrum and Sprint Planning meetings, ensured successful and timely project implementation.
  • Worked in Agile environment playing an active role in Iteration planning, Sprint Review, Lesson Learned and resolving roadblocks.
  • Conducted workflow, process diagram and gap analysis to derive requirements for existing systems enhancements
  • Followed Agile/Scrum Software Development Life Cycle methodology for project execution.
  • Project tracking and ensuring timely delivery of functionalities including documentation and proper approvals.
  • Deliver requirements under the Agile SCRUM SDLC methodology to meet a very fast release schedule.
  • Used the Agile methodology to build the different phases of Software development life cycle.
  • Performed Data Analysis of existing data through SQL and MS Access.
  • Executed SQL queries, to retrieve data from different databases, for data validation & analysis, researching underlying data errors, and generating reports.
  • Created the Data Mapping Document, for defining data flow between data source and target, along with business rules
  • Wrote extensive SQL scripts for validating the data generated by the UATs.
  • Working extensively in JIRA to upload Requirements, Test plans, Test Steps, Log defects and to follow up to fix.
  • Conducted Regression Test on the system to make sure that the existing Dashboard reports are working fine.
  • Created Requirements Traceability Matrix (RTM) to track requirements and testing activities, as well as maintained forward and backward traceability throughout the testing and development lifecycle.

Hire Now