We provide IT Staff Augmentation Services!

Business Analyst Resume

Dublin, OH

Professional Summary:

  • Business Analyst with around 8 years' experience in SDLC of financial and healthcare products.
  • Extensive experience in Business Analysis, Project Management, Release Management, Client Relationship and Delivery Management in Onsite-Offshore model.
  • Experience in creating project-initiation diagrams including business use cases, activity diagrams, workflow diagrams, flowcharts
  • Extensive Scrum and Agile experience, including blending Agile practices with existing processes as well as gaining executive and organizational support for transitions to Agile practices
  • Experience in recognizing and understanding the various design models, including UML diagrams, detailed design entity-relationship(ER) diagrams, and data flow diagrams
  • Capable of producing various documents like Business Requirement Document(BRD), Functional Requirements Documents (FSD), User Acceptance Test cases and User Manuals.
  • Conducted BRD and Joint Application Development (JAD) sessions, interviewed Subject Matter Experts (SMEs) for detailed functionality aspects of business process and carefully updating the information to the requirements in an easily understandable format.
  • Well versed in writing SQL queries/scripts for data analysis and writing test strategies, test plans, test cases, defect reports and developing test scripts, traceability matrices and test environments.
  • Created project prototype diagrams using Wireframes for project initiation and sign-off.
  • Experienced in conducting User Acceptance Testing(UAT), creating Source to Target Mapping documents and Cost Benefit Analysis.
  • Expertise in creating Ad Hoc Reports using Business Objects and Crystal Reports tools.
  • Track record of success guiding major system migration and providing technical expertise across all aspects of the software lifecycle.

Technical Skills:

Applications: T24, OpenClinica, Electronic Medical Applications (EMR), AssetManagement Tool(AMT), MemberPro, FACETS, ISOTAC, Cheetah Route Optimizer.

Languages: Pro*COBOL, PL/SQL, C, C++ and SHELL scripting

Database: MS SQL Server 8.0/7.9/6.5, Oracle 10g/9i/8i

Operating System: Windows 2000/XP/NT/7, AIX UNIX

Tools: Microsoft Visio, Citrix connectivity, Balsamiq,TOAD, HP Project Finance Management, Enterprise Architect, Rational ClearCase,SQL Developer, SharePoint, Crystal Reports, Mercury Quality Center, MS Office, Lotus Notes, Visual Source Safe, BusinessObjects Desktop Intelligence/Info View, MS SQL Server Management Studio 2008, HP Lifecycle Application Management.

Methodologies: RUP, Waterfall, Agile, SCRUM.

Banking Norms: Basel II

Certification: ITIL V3 Certified by EXIN Technologies

Professional experience:

Client: Confidential,Dublin, OH August 2012 - Present
Role: Senior Business Analyst

Project Description:
Nuclear Pharmaceutical Services unit initiated this project for creation of a new Data Warehouse to be built on existing Teradata platform to support analytical reporting and to develop Business Objects report. As part of this project legacy systems like Oracle NPS DW and SAP 3.1 would be retired. Financial data would be migrated to new SAP instance and Business Objects 6.0 with standardized reports will be implemented.


  • Responsible for activities such as requirement gathering, assessing requirements, test planning, analysis, and concept development.
  • Conducted thorough business process analysis to understand existing workflows and systems, document current processes and systems, create requirements for new processes, develop use cases, and manage requirement changes.
  • Provided functional support for various Enterprise Applications systems by acting as the liaison between the business and technical teams to identify, analyze, and translate requests into specifications and business processes.
  • Interacted with Project Managers from multiple organizations to track project progress, identified risks, communicate risks with all stakeholders to assess potential impacts for the business.
  • Documented project budget details from Project Change Request (PCR) documents.
  • Maintained project documentation including, but not limited to, project lists, project status reports, budget information, and issues lists.
  • Generate ideas and suggestions for process improvements that are needed within business and IT organizations.
  • Work with Quality Control, Project Managers, and Technical Leads to ensure Business acceptance.
  • Created and maintained functional models, process flows, and wire-frame diagrams.
  • Gathered requirements for project implementation and created Concept Analysis Document (CAD) for option analysis.
  • Attended Subject Matter Experts- Functional Integration meetings and documented defects raised by business users.
  • Worked with Lifecycle Management application to open new defects and closed fixed defects.
  • Worked with development teams in 'Proof of Concept' stage to review initial technical feasibilities of project implementation.
  • Designed mock-up of Business Objects report for Functional Specifications document which were used for business approvals.

Environment: MS Office 2007, Windows XP, Microsoft Visio, SharePoint Server 2010, Cheetah Route Optimizer Software, Business Objects Info view, HP Application Lifecycle Management, Isotrac Online.

Client: Confidential,Brooklyn, NY March 2012 - June 2012
Role: Lead Business Analyst

Project Description:
This project was for HealthPlus insurance application migration from in-house developed application MemberPro SQL to FACETS. As a part of this system migration and Data integration Consolidated Business Objects reports and new reports to comply with state laws were created.


  • Worked with end users to define business problems and design solutions (e.g. new workflows, systems, programs, reports)
  • Responsible for preparing Business Requirement Document (BRD) and then translating into functional specifications and test plans.
  • Organized daily SCRUM meetings and distributed daily tasks to address issues raised in these meetings
  • Performed analysis on existing systems, recommended enhancements, and implemented strategies to streamline current processes
  • Performed systems analysis to determine feasibility; develop software code to test newly developed features
  • Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the project plans accordingly and conducted project related presentations
  • Create test plans, end-user documentation and User manuals
  • Accumulated reporting requirements from various departments through interviews
  • Consolidated more than 150 BusinessObjects reports for various department including Enrollment, Retention, Finance and Marketing departments
  • Involved in Testing by using SQL and work with QA together to develop test Scenarios and test cases
  • Handled the tasks of directing, organizing and leading projects as well as in the implementation of BI software tools and systems.
  • Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio
  • Created Operators manual and published them to MS Visual source Safe
  • Managed team members by distributing work and monitoring status of deliverables.

Environment: SCRUM Agile, MS SQL Management Studio, MS SQL Server 2008, Windows XP, Microsoft Visio, MS Visual Source safe, Citrix connectivity, Business Objects Desktop Intelligence, MemberPro, FACETS.

Client: Confidential,Tampa, FL May 2010 - Jan 2012
Role: Senior Business Analyst (Lead)

Project Description:
The project is called Product Line Expansion and had to deal with adding new products, expanding the product line with all the latest products and adding more features like private banking, foreign banking and cash flow handling to online trading site. New functionalities to generate periodic portfolio statements and cash-flow statements were integrated into the system.


  • Interacted with subject matter experts, project manager, developers, and process analysts to understand the business process, gather Business Requirements and identify enhancements.
  • Performed Business Process Re engineering for new requirements and facilitated many applications and reviewed artifacts.
  • Prepared presentation of proposed system and functions.
  • Gathered business requirements through interviews, surveys, prototyping and observations.
  • Developed system As Is and To Be diagrams using Wireframes.
  • Worked on Web Intelligence and Crystal Reports to develop and publish client reports.
  • Participated in sessions with management, vendors, users and other stakeholders for open and pending issues.
  • Developed Business Requirement Specification as well as High-Level Project Plan on the Project Scope and SDLC Methodology.
  • Designed and developed Use Case Diagrams, Activity Diagrams, and Data Flow Diagrams and also defined the Business Process and Data Process model.
  • Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
  • Worked as a team with Developers and Process Analysts in preparing the requirements, and writing work-flows, process flows.
  • Involved with the QA team to determine and develop test approaches.

Environment: MS Excel, MS-Project, Oracle 10,SQL Server 2000, Windows XP, Microsoft Visio, Citrix connectivity, Bloomberg, Crystal Reporting,Balsamiq

Client: Confidential,San Francisco, CA February 2009 - March 2010
Role: Business Analyst

Project Description:
The Asset Management System for the Securities department was analyzed and constant changes were deployed to make the retrieval of information from other systems seamless and added features to automatically generate portfolio statements for account managers to monitor performance periodically.


  • Collaboration with the business teams in understanding the requirements, while providing them with required system information.
  • Increased the quality and on-time delivery of application deployments by championing and implementing Agile practices for onshore and offshore teams.
  • Assess the impact of proposed changes with the development team and interfacing teams.
  • Update the FSD as needed to incorporate approved change requests once the key stakeholders are informed.
  • Interacted with external teams to analyze the interfacing system's impact on Asset Management application
  • Create test plans/strategy, test cases, perform testing in UAT and work with the development team to get any of the outstanding issues resolved in a timely manner.
  • Communicate with QA team about any of the impacted functionality that needs to be included in their test planning.
  • Added new dimensions to allow product information to be linked with financial data and to classify data based on actualized or forecasted months.
  • Work with the development team and interfacing applications to ensure the availability of the environment for proper QA testing and in arranging for proper test data as and when needed.

Environment: Agile, MS Excel, Asset Management Tool, SQL Developer, Windows XP, Microsoft Visio.

Client: Confidential,Pasadena, CA May 2008 - December 2008
Role: Business Analyst

Project Description:
The project was initiated to increase the systems functionalities for maintaining patient records, past history and adding new products. New functionalities to generate reports were integrated into the system.


  • Interacted with subject matter experts, developers, and process analysts to understand the business process, gather Business Requirements and identify enhancements.
  • Gathered business requirements through interviews, surveys, prototyping and observations.
  • Provided User Acceptance Test (UAT) scenarios for prospective users and trained them on the new features.
  • Participated in sessions with management, vendors, users and other stakeholders for open and pending issues.
  • Developed Business Requirement Specification as well as High-Level Project Plan on the Project Scope and SDLC Methodology.
  • Designed and developed Use Case Diagrams, Activity Diagrams, and Data Flow Diagrams
  • and also defined the Business Process and Data Process model.
  • Worked as a team with Developers and Process Analysts in preparing the requirements, and writing workflows, process flows.

Environment: MS Excel, MS-Project, Oracle, PL/SQL, Microsoft Visio, TOAD, Electronic Medical Applications (EMR).

Client: Confidential,Boston, MA November 2007 - April 2008
Role: Business Analyst

Project Description: Coordinate with client technical team in identifying system development scope and User accepting test environment conditions for off-shore stimulations.


  • Requirement gathering, documentation and solution Prototyping.
  • Created Business Requirement Documents and source to target mapping documents
  • Created and executed Test cases / Test Scripts according to the Business and Functional requirements.
  • Extensively involved in data driven and back end testing.
  • Developed SQL Queries and Test data as part of Testing.
  • Involved in User Acceptance Testing before every release and assisted Business Team in Test Data creation.
  • Coordinated with the Team for weekly status reports and change requests.

Environment: Pro*COBAL, Oracle 9i/10g, SQL Server, Informatica 6, Windows XP, TOAD, PL/SQL Developer, MS- Office.

Client: Confidential,Geneva, Switzerland August 2006- September 2007
Role: Business Analyst

Project Description:
Enhancement and development are planning for Private Wealth Management core trading system which did Securities trading, FOREX trades and Cash account handling applications. The trading application allows Relationship managers to do regular portfolio management operations such as entering transactions; funds transfer between accounts and generate portfolio statements. Also gathered requirements to upgrade the system for latest Basel II requirements and annually changing SWIFT messaging codes. This trading application was also used for providing data to dependent satellite systems for reports archival and financial audits.

Identified and validated high potential business opportunities for stakeholders and developed customized business strategies that are aligned with corporate strategic objectives.

  • Provided analysis, understanding and business perspectives on many financial and operational issues.
  • Delivered a 100% defect-free and flawless global implementation by leveraging Agile practices for estimations, prioritization, collaboration, and delivery.
  • Conducted several Joint Application Development (JAD) sessions for gaining detailed requirements and finalizing Business Requirement Document (BRD).
  • Gathered technical requirement for developing system based on Basel II standards with business inputs from audit and legal departments.
  • Documented existing processes, prepared Business Requirement Documents (BRD), analyzing Business Requirements, worked with Requirements Traceability Matrix, re-engineering business processes and developing Functional Requirements Document (FSD).
  • Monitored the IT Business Support team on regular incident and problem management tasks by tracking raised tickets on BMC Remedy.
  • Developed several impromptu reports for customer server incentive reporting.
  • Planned yearly project team budgets and Schedule using MS Project.
  • Worked as an Interface between the users and the different teams involved in the application development for better understanding of the business and IT processes.
  • Involved in Incident Reporting and Change Control procedures using Clear Quest and reports to track process of repairs and determine the current quality of the application.

Environment: Agile, BMC Remedy, MS Visio, MS Office, MS Project, Business Objects.

Confidential,Bangalore, India May 2004 - July 2006
Client: Deutsche Bank-Private Wealth Management
Role: Business Analyst

Project Description:
Data migration from legacy proprietary trading application to web based banking software developed by Temenos Private Ltd.


  • Interacted and attended various meetings with Development and processing team to discuss about Test Problems.
  • Developed migration Plans and check-in Scripts by following TDD and FRD.
  • Created source to target mapping documents, created and executed Test cases / Test Scripts according to the Business and Functional requirements Documents (FSD).
  • Involved in the creation of Technical Specification documents and Customer reports.
  • Responsible for System Integration Testing and Performance testing during various phases of software deployment.
  • Developed SQL Queries to test the Data Integrity and impact on dependent satellite applications.
  • Responsible for the management of issues using BMC-Remedy.
  • Responsible for User Acceptance Testing and created Client Data using Excel sheets and also by writing Macros.

Environment: DB Symphony issue tracking tool, BMC-Remedy Change management System, Oracle 9i, SQL Server 2000, Windows XP, TOAD, SQL Developer, MS-Office, HP Project Finance Management, Rational Rose.

Hire Now