We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

SUMMARY

  • Insightful, result driven, experienced and dedicated Business Systems Analyst with 8+ years of experience in analyzing the data warehousing and business intelligence projects, strong reasoning & analytical skills, management background and excellent communication skills. Experienced in all phases of development life cycle, primarily requirement gathering and analysis, along with design, development and testing of OLAP/Data Warehousing and business intelligence in Hi - Tech, Life Science & Health Care and Banking & Financial domains.

TECHNICAL SKILLS

Technical Expertise Area: Data Warehousing, Business Intelligence/Siebel Analytics

Tools: Rally, OBIEE (Oracle Business Intelligence10.1.3.x/11.x), OBIA (OBIApps7.9.6.3), PL/ SQL Developer, MS-SQL Developer, Informatica 9.0, SAP-Business Objects, QlikView, HADOOP Technologies - HIVE/DynamoDB, Siebel Call Center 7.7, MS Office Suit: Word, Excel, PowerPoint, Visio, SharePoint.

Databases: Oracle 8i, Oracle 9i, Oracle 10g/11g

Domain: Hi-Tech, Banking and Financial Services, Life Science & Health Care, HR Analytics, Financial Analytics.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Analyst

Responsibilities:

  • Effectively interact with the Business Stakeholders for requirements gathering, understanding the end-to-end scope of the requirement and define requirement specifications document.
  • Actively solicit, analyze, prioritize and negotiate customer requirements from scope definition through detailed system requirements.
  • Analyze the existing Platform files and data elements, the transformation logic, if any in the EDW-EDR, etc.
  • Identify the impacted downstream processes, connect with the stakeholders for each downstream process and gather their list of Required Data Elements (RDEs).
  • Creation of process flow diagrams for the “As-Is” and “To-Be” environments.
  • Create mapping documents between “existing” and “to-be” Platform extract files and/or Data Elements, identify the gaps, analyze the gaps and discuss with the vendor and the Business SME on the work-around and do the necessary transformations required, if a one-to-one mapping is not available.
  • Identify if all the involved efforts are limited to “Inbound”, i.e., the Core environment gets data from the third party or if it needs any “Outbound”, i.e., the files in the requested formats and structure has to be delivered to any impacted downstream process or third party.
  • Identify all the risks involved and do an assessment for the same. Work around to find if any mitigation plan is available.
  • Create the BRD (Business Requirement Document) for the project with the Scope identification, impacts, risks, involved teams, processes, gap analysis, etc.
  • BRD- walk through with all the teams involved, discuss and implement changes, if any requested. Release the updated version of the BRD and conduct the walk-throughs as-and-when required.
  • Work with all the leads and high-level managers to get the approval on the BRD.
  • Work with the Data Architect on converting the transformation logic into actual formulae and creating the FRD (Functional Requirement Document), (the BA part of it).
  • Continuous follow-ups and meeting for the gap closure, if any, with Vendor and/or Business SMEs.
  • Work on creating QC Document for the high-level test case scenarios and work with the QA to create test plan for the project and test cases.
  • Build demo reports for the UAT. Walk-through the business users and stakeholders of downstream processes.
  • Maintain all the versions of BRD, FRD, approvals, and QC documents in the SharePoint.
  • Provide support for the User Acceptance Testing (UATs).
  • Prepare presentations for the demos.
  • Get sign-offs for UATs conducted with all the downstream processes.
  • Get final sign-offs for the project.

Confidential

Business System Analyst

Environment: Oracle Business Intelligence 10.1.3.4.1 , Oracle, Informatica 9.0, Oracle 10g, PL/SQL Developer, MS SQL, Rally, Seibel CRM, Business Object, QlikView

Responsibilities:

  • Effectively interact with the Business Stakeholders for requirement gathering, understanding the end-to-end scope of the requirement and define requirement specifications document.
  • As per the requirements discussed with the business users, categorize them, analyze and agree upon the Minimum Releasable Units (MRU).
  • Participate in designing the SPRINT, phases of the AGILE Methodology used.
  • Transform the business requirements to technical specifications, work on creating data models.
  • From the received requirement, create smaller requirements and define the respective User Stories.
  • Discuss and document the acceptance criteria for each defined User Story.
  • Analyze the User Stories, assign it to the team and work towards the MRUs.
  • Actively solicit, analyze, prioritize and negotiate customer requirements from scope definition through detailed system requirements.
  • Analyze the existing OBIEE reports, tables and attributes, metrics used in the reports, data analysis from the Data Warehouse and from the source system: Siebel. Identify the attributes and their purpose, suggest on the enhancement, if any possible.
  • Analyze the existing state: ODS & EDW, future state: Global Data Warehouse (GDW)/ODS(G-Global), compare with the existing Data Warehouse/Siebel source, share the analysis finding with the business, suggest on the better way of implementing the old Siebel Data Warehouse to future state.
  • Creation of data flow diagrams, mapping documents between ODS/DW/Reporting Tool-Scripts.
  • Data Analysis on huge data set (e.g. 80 million Assets).
  • Identify and suggest the best optimum solution to the business users and gather further requirements that need to be implemented in the new future state.
  • Prepare sample reports in SAP-Business Objects as a part of the interim solution, or prepare sample reports in QlikView as a demo/sample for final future state.
  • Build demo reports for the UAT. Walk-through the business users: Business Object Reports or QlikView reports.
  • Perform the System Integration Testing, Regression Testing, User Interface (UI) Testing and the User Acceptance Testing (UATs).
  • Document the analysis and finding for each User Story. Update and maintain all the User Story respective changes and documents in Rally and SharePoint.
  • Prepare presentations for the Sprints. Present the demo at the end of every Sprint to the Business Owners.
  • Get sign-offs for each User Story in every Sprint & final sign-offs for every Sprint at the end of Sprint cycle.

Confidential

Sr. Business Analyst

Environment: Oracle Business Intelligence11.1.1.6, Informatica 8.6, Oracle 11g, PL/SQL Developer, UNIX, Oracle EBS R12

Responsibilities:

  • Effectively interacted with the end users for requirement gathering, understanding the end-to-end scope of analytical requirement and defined requirement specifications document.
  • Created BRDs, Requirements Specification Documents, Requirements Traceability Matrix (RTM), etc.
  • Extensively worked on the design of data/dimension model accordingly.
  • Involved in assisting building detailed project schedule.
  • Provide support in the OBIEE architecture of the project through modeling and implementation.
  • Engage in project planning and preparing the functional document- Functional Design Document Specification.
  • Acting as a liaison between the technical, business, testing groups to provide them with required specifications/documentation and to resolve any issues in between.
  • Review the functional document review reports- (Functional Design Document Review).
  • Performed analysis of business rules, business and system process flows.
  • Data Analysis on huge data (75 million records-e.g.) available in the ODS (Operation Data Store) / EDW (Enterprise Data Warehouse).
  • Created mock-up reports and dashboards with the developer, for review by the business users.
  • Work in collaboration with various development teams: BI/ETL and other business stakeholders to maintain cooperative relation and translate plans into action.
  • Worked with various teams including customers/end users, development, and QA teams for a smooth transition of business requirements till QA tests.
  • Prepared test cases specific to the requirements, executed the test cases and documented the results.
  • Work with Development and QA teams to transition business requirements into QA test cases.
  • Performed the Performance Tuning for the financial reports, User Interface (UI) Testing and assist in User Acceptance Testing (UATs).
  • Present demos for the functional requirements gathered and the technical implementations been done to the Business Owners.
  • Get sign-offs for the reports been created & delivered to the production environment.
  • Conducted trainings for end users on Business Intelligence tool.

Hire Now