We provide IT Staff Augmentation Services!

Business System Analyst Resume

0/5 (Submit Your Rating)



  • Analytical, goal oriented and result driven professional with 6 years of experience as a Business/System Analyst.
  • MBA graduate from AACSB accredited university with major on Information System Management.
  • Extensive qualifications in all facets of information systems methodology from conceptual design through documentation, implementation, user training, quality review, and enhancement
  • Experience of handling Business Users Requirements in Pharmaceuticals, Financial and Retail Management Domain.
  • Experience in communicating with the client on regular basis to Elicit, Analyze, Validate, and specify the real needs of the project stakeholders, including customers and end users.
  • Excellent business writing skills for Functional Requirement Specifications (FRS), Business Requirements Documents (BRD), Systems Design Specification, Systems Requirement Specification (SRS), Use cases and User Stories.
  • Experience in conducting Joint Application Development (JAD) sessions, Project meetings, Reviews and Walk through sessions.
  • Certified as a Scrum Team Member and Scrum Product Owner from International Scrum Institute
  • Certified Business Associate with SAP ERP 6.0 .Knowledge of how the fundamental integrative business processes interact within ERP system
  • Expertise in the concepts of Data Warehousing. Have Good knowledge of Data Marts, ER Modelling, Dimensional Modelling, Fact and Dimensional tables.
  • Good knowledge of Extract, Transformation and Load (ETL) process. Working knowledge of Abinitio GDE and EME management.
  • Effective with using Gap Analysis to check the compatibility of the existing system infrastructure with new business requirements.
  • Strong knowledge in Object Oriented Concepts, Object Oriented Design (OOD), Object Oriented Analysis (OOA) and its implementation
  • Well versed in writing SQL commands to query Databases
  • Well Versed with advance concept in Excel. Worked with VLookup, Index, Match, IF Statements, Pivots and creating complex formulas.
  • Excellent Verbal and Written communication skills and the ability to interact professionally with a diverse group, executives, managers and subject matter experts
  • Highly motivated Team Player with strong management, interpersonal, administration, problem solving and decision - making skills. Good at Managing multiple projects simultaneously
  • Highly proficient in Microsoft Office Suite, Visio and SQL


Business Skills: Business Process Analysis & Design, Gap Analysis, Impact Analysis, JAD/JRP Sessions Requirement Gathering, Customer Liaison, Requirement Extraction and Documentation, and Use Case Modeling

Methodologies: SDLC, Waterfall Model, Agile, Agile Scrum

Databases: Oracle, MS Access, SQL, Teradata

ETL tool: Abinitio

Modeling Tools: MS VISIO, Smart Draw, UMLet, Bx Query Analyzer, Team Foundation Server (TFS) Project Management MS Project

Quality Management: HP Quality Center, Win Runner and Load Runner

GUI/Tools: MSWord, MS Excel, Crystal Reports, SnagIt, Photoshop

Reporting Tools: Business Objects, BEx Query analyzer

Documentation Tool: SharePoint, MS Office Suite (Word/Excel/Power Point)

Languages: C, C#, HTML, XML


Confidential, IL

Business System Analyst


  • Worked on Agile SDLC during the project phase, performed the role of Product Owner and Team member in Scrum Meetings.
  • Serve as liaison between thebusinessusers and the IT Application Development (AD) to provide Technical Solutions that meet user needs.
  • Conducted JAD session with system analysts, development team, project manager for application development and Pre-validation specifications.
  • Created Project vision and Scope Document after identifying the Business Goals.
  • Analyzed Business process flow, Logical flow and designed the optimum process models.
  • Created the Business Requirements Document (BRD) from the requirements gathered
  • Provided comprehensive and complex analysis of pharmacy process to the technical users. Applied Strategic, Operational and Technical methodology to analyze the pharmacy source data.
  • Validated the business, user and functional requirements and segregated them into Use Case Diagram and Activity diagrams using Visio, thus defining the Data Process Models.
  • After collecting the data requirement, created the Mapping Document based upon the Business Rules to map the fields from Source System (IC+, ERX, POS, and CDI) to the Target System EDW based upon the requirement.
  • Worked with the outbound team to identify the extract they need on daily, weekly and monthly basis and presented it to the ETL designer
  • Collected and managed the various existing data sources to Perform pre-ETL tasks (Staging phase) upon which the Data Warehouse depends.
  • Coordinated with users on Teradata Query Optimization. Assisted FDL business user on writing well-tuned SQL queries against the EDW to maximize user experience without impacting other users.
  • Created the Views on Teradata by joining different Integrated Data Layer (IDL) tables for diverse users groups based upon their department and security access.
  • Performed data analysis and data profiling usingSQL queries.
  • Analyzed the flow and dependency of IDL RX jobs with other dimension and created run sheets to automate the batch execution process through CA Automation tool
  • Worked with EHR (Electronic health record) and EMR (electronic medical record) team for data requirement.
  • Tracked and Managed Risks and issues, develop mitigation strategies to reduce adverse effects.
  • Used UML Methodology to define the Context Diagram, Data Flow Diagrams (DFD) and Sequence Diagram
  • Performed GAP analysis for the modules in production, conducted Feasibility study and performed impact analysis for proposed enhancements, Identified risks and project impacted
  • Prepared Requirement Traceability Matrices (RTM) and managed every change requests effectively throughout the software development life cycle.
  • Reviewed Functional Test Cases to confirm the expected outcome and behavior.
  • Documented the UAT test cases, scenarios, test cases and test scripts.
  • Conducted detailed Business workflow and Timeline reviews with my team on regular basis to ensure that business targets are achieved
  • Regularly worked with the Change Control Board to manage requirements. Create the Change Request Document for the changes and assign it to the party.
  • Completed the Teradata training from Confidential that qualifies as an effective user in EDW/FDL environment.

Environment: Share Point 2010, MS Visio 2010, Microsoft Office Suite (MS Word, Excel, PowerPoint)2010, Team Foundation Server(TFS)2010, SQL, Ab initio GDE 3.14 and Co>Op 3.0.6, Teradata 12,14, Business Objects4.0, Microsoft Visual Studio 2012, XML,SOA, Web Services, HP Quality Center 11.5, Linux.

Confidential, Columbus, OH

Business Systems Analyst


  • Performed Requirement Gathering & Analysis by actively soliciting, analyzing and negotiating customer requirements and prepared the Business Requirement Document(BRD) for the application
  • Performed Task Planning with my project manager and the team members.
  • Prepared Level of Effort (LOE) for particular enhancements to be done for the business stakeholders and getting approval from the project manager.
  • Identified opportunities for Business Process Improvement and initiated efforts to make improvements.
  • Studied project planning and business process. Analyzed existing procedures and reported them to management to improve productivity.
  • Conducted walk through sessions with business users to get sign-offs on the approach document.
  • Created Mock-ups and Wireframes.
  • Did extensive Data Modeling for Impact Analysis. Assisted the database designer in Data Modeling through ER diagrams.
  • Performed extensive back-end validations, which include designing and executing SQL queries using Oracle SQL Developer and SQL Server for Impact analysis purposes
  • Conducted a demo of the enhancement with the Developer, System tester, Test lead and release lead after integration testing is done in the test environment.
  • Worked with Business Users and Stakeholders if there were requirement changes to be on the same page.
  • Coordinated tasks with multiple systems and departments to successfully complete the UAT effort.
  • Worked as a User/Customer advocate and negotiated with user as well as the technical team and management staff to resolve Requirement Conflict during the whole SDLC process
  • Planned and facilitated AS-IS Business process and workflow models to create TO BE Business scenarios.
  • Created Non Functional Requirements (NFR) with the inputs from Technical Architects
  • Performed end to end testing of the new functionality designed before it went for the Enterprise release.
  • Updated the Issues log with all Issues identified during UAT and communicated the same to all stakeholders.
  • Conducted detailed business workflow and Timeline Reviews with my team on regular basis to ensure that business targets are achieved
  • Documented the Requirements and Approach .Circulated it among Business & Tech teams for Signoffs.

Environment: Crystal Reports 2010, Business Objects 4.0, Ab initio 3.0.6, HP Quality Center, Oracle 11g, Visio 2007, MS Office Suite, SnagIt 9.0, SharePoint 2010, Java.

Confidential, NY

Business System Analyst


  • Performed GAP Analysis by comparing the existing system to the future system to create “AS-IS” and “TO-BE” flow charts and generated risk assessment.
  • Followed Unified Modeling Language (UML) methodology to create/maintain: Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams
  • Periodically interface with financial advisors to understand Business Needs
  • Responsible for efficient document management and Version Control using MS SharePoint and to update the document and transmit the information to financial advisors
  • Extensively worked on Documentation for Functional Analysis
  • Authored Data flow diagram(DFD), Sequence diagrams and Business Process Modeling (BPM)
  • Developed Flow Charts to document work flow for the application to be accessed by different types of Business Users.
  • Reported Project progress to the team, senior management and all stakeholders periodically.
  • Surveyed upcoming customer needs and coordinated with technical subject matter experts to identify technologies that would lead to increased market share in both factory deliveries and engineering services
  • PerformedBusinessActivity Monitoring to monitor Key Performance Indicators (KPI) metrics in real time.
  • Coordinate the change request process and use JIRA to track the changes.
  • Conduct Requirement Walkthrough Sessions with Technical & QA teams to bring them on speed with the Requirements and the report.
  • Analysed Business Scenarios to track possible business outcomes for the functions which could be incorporated into more detailed test script
  • Documented Test Scripts for Integration testing. Helped users in integration testing and provided support on planning
  • Documented Test Plans containing test scripts, test cases and expected results for the User Acceptance Testing (UAT).
  • Participated in the Implementation process and assisted withUATdocumentation.

Environment: ASP.NET, UML, JAD, MS Visio, MS Project, Quality center.


Business Analyst


  • Facilitated Business and Technical meetings with Finance, IT and Customer Service personnel to develop web site content and presentation requirements as well as application data and business logic requirements.
  • Bridged the gap between the client and technical team. Coordinated with the stake holders to translate the business requirements into actual project plan.
  • Created Functional requirement specification (FRS) document, User requirement specification and (URS) document for system application development
  • Performed Web Application Development Framework Industrial Analysis using Porter Five Forces analysis
  • Created Use Cases, User Interface Designs, Report Specifications, Print Specifications and System to System Interfaces.
  • Worked with the UI/UX designer on creating the Wireframes and presented it to the business users.
  • Identified areas for automation
  • Created Change Request (CR) Documents. Analyzed the change request and co-ordinate the changes required with the development team.
  • Prepared the User Manuals for the technical users.
  • Met with the programmer and Quality Assurance officer to discuss about the products features and strategy to enhance Customer Service.
  • Kept track of the release of all new versions through SharePoint. Manage the proper documentation of changes in every new version released.
  • Search Engine Optimizer: Generate the Title, Meta-tag and Keyword for website.
  • Designed content and interactive applications to improve site usability.
  • Selected as “Employee of the Month “for the month of February 2011

Environment: Java/J2EE, HTML, SQL Server, MS Visio, UML2.2, RAD, Google Analytics, Web2.0, Web Application Development.


Junior Business Analyst


  • Created Questionnaires, and analyzed the feedback from the key users in order to understand and capture the requirements.
  • Documented meeting agendas, meeting minutes as well as tracked action items, issues and problems logs.
  • Provided UML documentation such as use case scenarios for customer, customer service, and system administration roles as well as page layout and display requirements for the package tracing and information website.
  • Created Use Cases, User Interface Designs, Report Specifications, Print Specifications and System to System Interfaces.
  • Critically evaluated information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true needs.
  • Assisted Project manager on preparing the Business Proposals

Environment: UML, MS Visio, MS office, Business Process Analysis

We'd love your feedback!