Business Intelligence Analyst Resume
3.00/5 (Submit Your Rating)
Cincinnati, OhiO
SUMMARY
- Experience of 5 years working as a Business Analyst with expertise in Business Requirements Gathering, Translating Requirements into Specifications, Evaluating Data Sources, and Business Analysis in various domains like Supply Chain & Retail, Financial, E - commerce and Mobile App.
- Utilized a combination of business noledge, technical skills, and strategic analysis to provide solutions and creative insights to criticalbusinessproblems.
- Comprehensive noledge and experience in Software Development Life Cycle (SDLC), Project Management Life Cycle (PLC) and software development methodologies: Agile (Scrum) and Waterfall.
- Extensively worked on all phases of Data Warehousing project along with migrating data and business processes from legacy to latest technology solutions.
- Proficient in creating various documents like Business Requirements Document (BRD), Functional Requirements Specifications Document (FRD) and Use Case Narratives.
- Worked closely with various project Stakeholders, Subject Matter Experts (SMEs) and Developers to understand and document business requirements, functional requirements and design specifications for new applications along with enhancements to the existing applications.
- Analyzed and synthesized results from Joint Application Development (JAD), proposed alternative tasks and transformed those into Requirements Document.
- Extensive experience in modeling the As-Is, To-Be and Gap business processes.
- Used Microsoft Visio for Business Process Modeling and Data flow diagrams.
- Proven track record in Data Analysis and Data Mapping, change control combined with analytical problem solving and decision making capabilities.
- Experience working with Business Intelligence tools such as SAP BusinessObjects, MicroStrategy, Cognos.
- Experience with extracting and filtering data from databases such as Oracle and SQL server.
- Assisted QA team in developing Test Scripts, Test Cases and Test Plans to ensure that the application is functioning as per the Business Requirements and prevent any potential production issues.
- Responsibility to support both onshore and offshore team resources in development, testing, integration, regression and user acceptance.
- Worked with business and customer on new initiatives, identify and provide insight and recommendations of what data will be helpful to reach the desired project goals.
- Highly motivated team player and self-starter with excellent communication, coordination, documentation and interpersonal skills and strong ability to acquire new noledge very rapidly.
- Capable of forming and maintaining positive and productive working relationships in internal, external, independent and team environment.
TECHNICAL SKILLS
- Microsoft Office
- Excel
- Word
- PowerPoint
- Outlook
- HTML
- Java
- JIRA
- MySQL
- Oracle SQL Developer
- Toad
- MS SQL Server
- SAP BusinessObjects
- MicroStrategy
- Microsoft Power BI
- Crystal Reports
- MS Visio
- MS-Access
- SharePoint
- Quality Center
- Service Manager
- SPSS 20
- Microsoft Visual C++
- MAT-Lab jGRASP
- Windows and Mac.
PROFESSIONAL EXPERIENCE
Confidential - Cincinnati, Ohio
Business Intelligence Analyst
Responsibilities:
- As a part of the reporting team, successfully documented and delivered 70+ reports for their 6 major retail clients following Agile Methodology.
- Gathered business requirements by interacting with the stakeholders, developed Business Requirements Document (BRD) and Reporting Functional Specifications (RFS).
- Helped in defining the scope of the project based on the gathered business requirements including documentation of Constraints, Assumptions, Business Impacts, Project Risks and Scope Exclusions.
- Modeled the data warehouse by performing source to target mapping, so that developers and other stakeholders can understand the business process.
- Identified any data gaps during the mapping process and worked with the ETL team to populate those gaps from the source to data warehouse.
- Prepared and tested Ad-hoc SAP BusinessObjects Reports - Crystal reports and WEBI to validate the report data and cosmetics of the report.
- Worked extensively on Oracle SQL Developer database to extract & validate data and build Business reports.
- Handled huge volume of data in MS Excel, performed extensive amount data analysis using Pivot tables, V-look up and creating custom filters.
- Performed data validations for SAP BusinessObjects reports.
- Led and interacted efficiently with the onshore/offshore development teams ensuring business expectations are communicated correctly.
- Identified data quality issues and support data governance initiatives by participating in necessary activities including data profiling.
- Assisted production support team with production issues to analyze the root cause of the problems and resolved it with the team.
- Used JIRA for writing Epics, User Stories with Acceptance Criteria along with creating and tracking Change Requests and Defects during the course of the project.
- Designed and implemented SQL Queries for QA testing and report/data validation.
- Conducted presentations of the QA test results with analysis to the stakeholders and users and documented any modifications and requirements to ensure UAT is done per standards.
- Facilitated the development of the test plans and scenarios for the test scripts.
- Coordinated with the QA team to facilitate workshops during UAT for Real-Time testing, defect resolution and risk mitigation to shorten UAT timeline.
- Worked TEMPeffectively as a team, supporting other team members in achieving project/ business objectives.
Confidential - New York, NY
Business Analyst
Responsibilities:
- Created high level Business Requirements Document (BRD) and Functional Requirement Document (FRD) resulting from JAD sessions and meetings with the stakeholders.
- Assigned tasks among development team, monitored and tracked progress following Agile methodology.
- Participated in daily stand-up meetings, sprint planning meetings, sprint review meeting, and retrospective meetings.
- Initiated JAD sessions with other System Analysts and Business Analysts to capture the impacts from the other applications on the overall website.
- Actively managing Stakeholders of all levels by leading discussions of project scope and approach, and presenting business analysis findings/documentation and proposed solutions.
- Conducted technical/non-technical presentations to the management and training workshops with the clients.
- Worked on backlog grooming items and presented what items can be picked up in next sprint to the squad/scrum master.
- Acted as a Subject Matter Expert (SME) on many occasions to explain in brief about the internal systems to the business users.
- Distribute work load to onsite and offshore teams to ensure full utilization of the team.
- Maintained all versions of the document during the requirements gathering process as well as the final approved versions on SharePoint.
- Kept track of all QAT and UAT bugs/defects and helped the testers to resolve the issues and made a report of all the defects which were resolved and which were not using MS Excel.
- Coordinated with the testing team while Smoke Testing at the time of the deployment.
- Verified the Business Scenarios on new builds to allow extended testing by the QA team.
- Provided production support after the application went live.
Confidential - Colmar, PA
Business Analyst
Responsibilities:
- Responsible for requirements gathering, analysis, detailed process flow design, user acceptance testing and rollout of their rebate calculation application.
- Worked as a liaison between the business and technical side to convey the business needs to the developers and the architects.
- Participated in the stack sessions, and met with the stakeholders to understand, articulate, and document the requirements.
- Documented meeting minutes and published it to all stakeholders highlighting discussion points and pending action points.
- Applied Unified Modeling Language (UML) methodologies to create Use Cases, design Activity Diagrams, Sequence Diagrams, and Interaction Diagrams using Microsoft Visio.
- Intensively worked with the development team to resolve critical defects during Production/UAT/QA.
- Conducted Use Case reviews and identified gaps, leading to improvements/enhancements in the same.
- Developed strategies with the Quality Assurance (QA) team to implement the test cases for User Acceptance Testing (UAT).
- Tracked change requests and monitored workload and schedule.
- Analyzed test results from the QA teams to create various scenarios.
- Facilitated User Acceptance Testing of the software; trained system users on software use.
- Participate in weekly meetings to discuss areas of improvement and set future goals with the manager.
- Plan and partake in team trainings to enhance performance for associates to better meet client needs.