Business Analyst Resume
Detroit, MI
SUMMARY
- 8 years of IT experience with an emphasis on Business Analysis & Business Process Reengineering.
- Experience in Business Process Management, Business Analysis, Software Design and Quality Assurance.
- Extensive knowledge of the System Development Life Cycle phases and methodologies like Waterfall, Agile, Change Management, Project Management Concepts and Processes.
- Extensive experience in creating project artifacts like Vision documents, Process Summary Document, Business Requirement document (BRDs), Use Cases and Traceability Matrix.
- Accurate in modeling and documenting business requirements into functional and non - functional specification by utilizing UML based diagrams such as Use Cases, Activity Diagrams, Sequence Diagrams and Component Diagrams.
- Understanding of the requirement management tools like Requisite Pro & DOORS and testing tools like Confidential Quality Center.
- Skilled at performing Confidential, Risk analysis, and Cost/Benefit analysis, along with good knowledge of process workflow tools and techniques.
- Excellent experience in building presentations and presenting it to the clients that varied from the basic market research to the user training.
- Worked closely with various project stakeholders, SMEs, to understand and document business requirements, functional requirements, and design specifications for new applications along with enhancements to the existing applications.
- Experience in data analysis using advanced Excel features like Pivot tables and charts.
- Possess reasonable understanding of different relational databases, writing SQL queries, creating tables, and generating reports.
- Familiar with MS Project to manage schedules, deadlines, resources, collaborate with different teams, and analyze project information.
- Broad understanding and knowledge of financial services industry with emphasis on Banking and Automotive finance.
- Result oriented approach with strong analytical, communication, leadership and project management skills.
- Lead and worked with teams to examine and solve business problems by accurately analyzing the needs of clients and helping them achieve improved quality and value for their customers.
TECHNICAL SKILLS
Operating systems: Windows 95/98/XP/2003/2000/NT/2000 Server
Programming languages: Excel/VBA, Access/VBA, Visual Basic 6.0, SQL
Databases: SQL Server, MS Access 2000/2003/2007
Software packages: MS Office 2000/2002/XP/2007
Modeling Tools: MS VISIO, BEA Confidential
Testing Tool: Confidential Quality Center
Requirement Mgmt. Tools: Requisite Pro, DOORS
PROFESSIONAL EXPERIENCE
Confidential, Calverton, MD
Sr. Business Process Analyst
Responsibilities:
- Develop requirements specifications according to standard templates.
- Manage the EA tool and support projects and Product Development’s use of the tool.
- Provide support for user tool access, communicate product issues, and maintain repository data and back-ups.
- Manage the Business Process and Requirements repository and artifacts.
- Build out deliverable templates for systematic generation of deliverables and documentation to support products, services, projects and internal processes.
- Support project deliverable generation, process modeling, and requirements gathering for individual projects using EA tool.
- Update the internal process documents and EA tool attributes as needed to support the BPM Center of Excellence approaches.
- Created training materials and conducted BPM notations & tool training.
Environment: MS Office, EA (Enterprise Architect) tool, MySQL
Confidential - Rockville, MD
Business Process Analyst
Responsibilities:
- Analyze the AS-IS business process to understand the functionality of the application & Generated the Business Process Design document.
- Co-ordinate with the SMEs and Stakeholders for the facilitation sessions to gather requirements.
- Created System Specification document which comprised of the following:
- High level business requirements (as an attachment)
- Functional requirements (in the form of Use cases)
- Responsible for the Project repository - maintaining project artifacts and deliverables
- Extract business rules out of the understanding of the application to in corporate in the High level business requirements document.
- Review all business rules and perform requirements analysis to validate key capabilities and assumptions.
- Designed the Data Model of the system using Erwin data modeling tool.
- Understanding the current SQL procedures and queries to get the current relationships in the database.
- Document requirements using Use Cases and created process documents (with prototypes & data elements) to further explain the requirements.
- Being a Payroll & Time tracking system, reporting is one of the important modules of the system.
- Created a separate Report Specification document which included:
- Data Source of report (used SQL Server to understand the data elements)
- Report Layout details (prototype of the report)
- Lead the Project Status Meeting every week.
Environment: MS Office, MS VISIO, SQL Server, Erwin, MS Access DB
Confidential, Washington DC
Business Process Analyst
Responsibilities:
- Identification of business stretch goals for the all the business processes (includes quality and timing metrics for financial reporting; decision influencing metrics)
- Modeling the end-user’s AS-IS workflows and TO-BE business processes using MS VISIO.
- Documenting business requirements and functional specifications.
- Analyze existing business rules, processes, and systems for process enhancement.
- Identified processes for improvement, designs new processes, developed process performance measures
- Produced details (to data element level) to be used for improvement of system and processes
- Performed GAP and Risk analysis of existing system and evaluated benefits of new system.
- Establish baseline metrics and collect data in which to measure process improvements.
- Creating a business case emphasizing on: Degree of importance to the Business, Level of effort involved in delivering the solution inherent in the business case
- Level of risk required in the proposal / solution / or benefits & Quantity of benefit in the proposal
Environment: MS Office, MS Visio, Oracle, ARIBA (Procurement tool), SharePoint
Confidential, McLean, VA
Business Process Reengineering/Analyst
Responsibilities:
- Performing LOB needs analysis and assessment; collaborating to identify and clarify program, business and functional requirements; management of their expectations and relationships.
- Gathered business requirements by conducting interview sessions with LOBs & SMEs.
- Created Business Requirements and converted them to Functional Specifications.
- Involved in modeling the end-users’s AS-IS workflows and TO-BE business processes using MS VISIO.
- Involved in Requirement Scoping and analyzing high priority requirement for implementation.
- Managed changes to the requirement using DOORS.
- Performed GAP and Risk analysis of existing system and evaluated benefits of new system.
- Liaised with Business Analysts in California & North Carolina to create data maps and business process diagrams.
- Communicated and interacted on a regular basis with the PM & development team during different stages of the project.
- Created process documents (with sample screens and data elements) to depict the flow of critical information.
- Assisted with data analysis, interpretation, correction and document presentation for various assignments.
- Consolidated information from various sources (e.g. Access to Excel).
- Generating reports using Excel Pivot charts and tables.
- Interfaced with SMEs to prepare BPR documents for ongoing projects.
- Capture and document change requests per the change management process.
- Created test scenarios for User Acceptance Testing (UAT) and prepared simple yet detailed User Manuals.
- Managed schedules and collaborated with different teams working on the project.
- Assisted the testing team in solving the queries during UAT.
- Created Meeting Minutes and weekly status reports.
Environment: MS Office, MS VISIO, DOORS
Confidential, Detroit, MI
Business Analyst
Responsibilities:
- Created Business Requirements and converted them into System Requirement Specifications.
- Created and maintained Data Dictionary and pursued to reach consensus.
- Used Rational RequisitePro for Managing and Configuring the Requirement Analysis effort.
- Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.
- Prepare Report Templates in Excel as needed by the ITM Finance Team.
- Generated monthly reports using VBA in Excel & SAP Finance.
- Generating graphs and reports as per the requirements using VLOOKUP & Pivot table and graphs.
- Performing accounting activities like accruals, budgeting.
- Performing variance analysis from the actual and the budget submitted by the managers.
- Conduct meeting with the project managers analyzing the financial information like expenses per project/department, expenses per headcount.
- Forecasting and monitoring project cash flows using Excel based functions of IRR, NPV.
- Monitor and track obligations and the use of budgetary resources for assigned programs through the review of financial data, examination of accounting records, and information provided by project managers.
Confidential, Detroit, MI
BPR Consultant
Responsibilities:
- Interface with all levels of business users to assist in defining the business process requirements.
- Conducted interviews/workshops with the subject matter experts (SMEs) for process understanding application portfolio analysis including assessment of business impact & relevance.
- Developed the Business Requirements Specifications and Functional Requirements Specifications describing and prioritizing the requirements.
- Used BPM to generate models of existing system and the proposed new system based on the scope of the project.
- Develop process maps out of the understanding of the processes.
- Provide consulting to re-engineer and strengthen the business process in terms of execution time and cost.
- Identified processes for improvement, designs new processes, developed process performance measures.
- Responsible for ensuring on-time, on-budget delivery of projects in collaboration with project sponsors and stakeholders.
- Developed and delivered presentations/reports to executive and senior management about the observations made and the next steps to be taken.
- Helped the Data Architect to understand the business requirements to create the database models and resolve the data migration issues.
- Assisted the QA team in designing the Test Plan
- Created Test Cases for User Acceptance Testing.
- Prepared the User Manual of the New System and conducted a User Training session.
Environment: In-house applications based on Java, SQL Server, MS Office, MS VISIO, BEA
Confidential
Business Analysis
Responsibilities:
- Researching market conditions in local, regional and national area to determine the potential sales of the IT services.
- Design format for data gathering and research document template.
- Gathering data on competitors and analyzing their products and services, comparing it with Confidential and where Confidential can mark its place.
- Preparing research documents for the Pre Sales team aiding them in making cold calling to the potential customers.
- Assisted in response to RFPs (Request for Proposals).
- Understanding the client’s business and its competitiveness.
- Understanding of the client’s process and technical environment.
- Responding to the RFP questions by identifying the client’s solution requirements and Confidential capabilities.
- Coordinating with Delivery, SMEs, Sales team, CoEs etc to build competitive RFI/RFP response/proposal.
- Preparing collaterals, case studies, presentations, offering /capabilities documents and other presales support documents.
Confidential
Business Process Reengineer
Responsibilities:
- Assisted with required data analysis, interpretation, correction and document presentation.
- Performed in-depth Confidential identifying the key pain points in the portal in comparison with Best Practices from the industry.
- Gathered feedback from representatives of each key department that interfaces with the dealers.
- Assess the functional and technical state the portal.
- Assisted in modeling and documenting the end-user's AS-IS workflow and TO-BE business processes.
- Used MS Visio to create process flowcharts and workflow Diagrams.
- Prepared a Gap Register - listing the observations and the recommendations for each of the gap identified & categorizing (e.g. Business, Technical, Process, Security etc) and prioritizing (e.g. high, medium, low).
- Managed schedules and collaborated with different teams working on the project.
- Prepared project progress reports and status reports and submitted to the management on an ongoing basis.
Confidential
Business Analyst
Responsibilities:
- Acted as a resource point for the development and test teams.
- Maintained the traceability matrix to trace the requirements to the functional specification and the deliverables.
- Assisted the QA team in prioritizing the software modules to be tested. Worked with the QA team in identifying test cases.
- Performed the Unit Testing - testing the interaction of the one module with the other modules and the database.
- Maintained Defect Logging and Tracking sheet.
- Developed the test plan and the test script with Quality Assurance (QA) team and performed Integration Testing.
Confidential
Business Process Analyst
Responsibilities:
- Interacting with the stakeholder to get a clear understanding of client business processes and Conducted business requirements analysis.
- Developed the AS-IS and TO-Be Process flow diagrams with Process Summary documents.
- Gathering explicit and implicit requirements from business as well as from UI prospective.
- Developed and facilitated Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
- Scheduled meetings with developers, system analyst and testers to collaborate resource allocation and project completion using MS Project.
- Conducting User Acceptance Testing (UAT) and verified performance, reliability and fault tolerance issues.
- Monitored client expectations and conducted user interviews to improve overall quality of the Application.
Environment: MS Office, MS Visio, MS project, Java, SQL Server
Confidential
Responsibilities:
- Interviewing the business people including the IT Manager to gather the data pertaining to the usage of IT in the day-to-day tasks.
- Studying the business & IT alignment and generating a model for IT Strategy implementation.
- Application portfolio analysis including assessment of business impact & relevance.
- Generating a spreadsheet to analyze the data gathered with the use of graphs and pivot tables.
- Developing Cost benefit cases for IT investments.
Confidential
Business Process Analyst
Responsibilities:
- Analyzed the current business process across the research division and identifying the inefficiencies.
- Recommended improvements to the current processes.
- Conducted focus group sessions to evaluate products and services for clients such as Australian Government, Philip Morgan, and Medicare.
- Developed questionnaires and surveys for quantitative and quantitative market research on a range of services and products.
- Documented feedback and suggestions from Confidential and Confidential business clients as per industry standards and policies.