We provide IT Staff Augmentation Services!

Business System Analyst Resume

San Rafael, CaliforniA

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.
  • Overall 8+ years of IT experience in Business Intelligence Applications using Oracle Business Intelligence (OBIEE) / Oracle Business Intelligence Apps (BI Apps), with close to 3 years of experience in business analysis, design, documentation, etc.
  • Expertise in all the phases of SDLC including requirement gathering, analysis, design, development, test and implementation of BI applications.
  • Methodologies, worked on: Agile-SCRUM, Iterative-and-Incremental, Waterfall.
  • Expertise in Data Modeling design, for designing the Star/Snowflake schemas, analyze and implement - conceptual, logical and physical data model in the area of Data Warehouse and Business Intelligence.
  • Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partners relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers.
  • Expertise in understanding the business requirement, figure out the various steps required to implement the requirements and break them into further smaller requirements and creating the User Stories in Rally.
  • Documentation includes: Business Process documentation, Functional Design Document Specifications (FDDS), Functional Design Document Review (FDDR), etc.
  • Extensive experience in data analysis, ETL techniques, understanding database structures.
  • Strong working experience in MUDE, designing, developing, deploying, maintaining and integrating complex OBIEE reports, dashboards, application objects (drill downs, filters, Prompts), KPIs.
  • Involved in Tuning by using Partition Tables, Indexes and Aggregate tables to enhance performance of reports.
  • Extensively worked with End Users on the User Acceptance Testing (UAT) of the Reports, System Integration Testing, Regression Testing, User Interface (UI) Testing etc.
  • Good understanding of Warehouse Standards, Normalization, De-normalization
  • Customer focused performer who is committed to quality in every task- from personal interaction with co-workers and users to high level of service provided to company/customer.
  • Guided other consultants and client personnel on best-practice techniques
  • Have worked on multiple projects parallely.
  • Excellent communication, analytical, written and presentation skills with strong aptitude towards learning new technologies.
  • Good team player and also has the ability to work independently.
  • Have facilitated many Data Warehouse and OBIEE relateds.
  • Managed hours so that delivery timelines for the clients are achieved.

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.

Languages: SQL, HTML, XML, Java Script, PL/SQL

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

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

PROFESSIONAL EXPERIENCE

Confidential, San Rafael, California

Business System Analyst

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

Responsibilities:

  • Effectively interact with the business users 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.
  • 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.
  • 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 future state: Global Data Warehouse (GDW)/ODSG(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.
  • Identify and suggest the best optimum solution to the business users and gather further requirements that needs 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.
  • 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.
  • Get final sign-offs for every Sprint at the end of Sprint cycle.

Confidential, New York City, New York

Business Analyst-OBIEE

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.
  • 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 (FDDS).
  • Review the functional document review reports- (Functional Design Document Review).
  • Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias tables.
  • Design the repository (rpd) - Physical Layer, Business Model and Mapping Layer and Presentation Layer.
  • Performed analysis of business rules, business and system process flows.
  • Created mock-up reports and dashboards 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.
  • Numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data.
  • Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
  • Implemented the ‘Write-Back’ attribute of OBIEE for the customers to add/update their feedback to the database.
  • Security Implementation. Added users and configured security in web logic console of OBIEE 11g.
  • Managed security privileges for each subject area and dashboards according to user requirements.
  • 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.
  • Performed the Performance Tuning for the financial reports, User Interface (UI) Testing and the User Acceptance Testing (UATs).
  • Present a demo 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 s for end users on Business Intelligence tool.

Confidential, Pittsburgh, Pennsylvania

OBIEE Analyst

Environment: Oracle Business Intelligence 10.1.3.4.1 , Informatica 8.6, OBIA 7.9.6.1, DAC 10.1.3.4.1 , Oracle 11g, SQL Developer, Windows Server, XML, Oracle EBS

Responsibilities:

  • Involved in understanding the reporting requirements, gathering the business requirement, translated the requirements into technical requirements.
  • Implementation of OBIA product suite for Finance.
  • Working on Low-level design document to meet the reporting needs.
  • Responsible for identifying and documenting business rules.
  • Design and development of repository (rpd-Physical, Business and Presentation layer).
  • Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
  • Worked on Multi User Development Environment (MUDE).
  • Development of Custom reports for Finance.
  • Responsible for creating users and maintaining visibility privileges using Analytics administration on the repository (rpd) side.
  • Documented all the configurations and new reports creation and published it to the end users.
  • Created user level security for intelligence dashboards based on Business Requirement.
  • Supported the development of the test plan and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
  • Prepared test cases specific to the requirements, executed the test cases and documented the results.
  • Performed Unit testing and Integration testing and documented the results.
  • Performed data validation of data in reports and dashboards.
  • Performed the User Interface (UI) Testing and the User Acceptance Testing (UATs).
  • Assist in development of materials for process improvements. Conducted s on Business Intelligence Administration Tool, Presentation Services, Dashboard creation, Business Process, etc.

Confidential, Pittsburgh, Pennsylvania

Sr. OBIEE Developer

Environment: Oracle Business Intelligence 10.1.3.4.1 , Informatica 8.6, Oracle 10g, SQL Developer, Windows Server, HTML, Java Script, XML, Oracle EBS R12

Responsibilities:

  • Understanding the business requirement.
  • Working on Low-level design document to meet the reporting needs.
  • Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias
  • Design and development of repository (rpd).
  • Worked on Multi User Development Environment (MUDE).
  • Developed many executive level Reports/Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart and Column Selector) using Oracle BI Presentation Services to provide insight into the financial data.
  • Review of Functional Design Document Specifications (FDDS), Code, related documents and deliverables.
  • Unit and integration testing. Prepared test cases, executed and documented the results.
  • Performed data validation of data in reports and dashboards.
  • ImplementedOBIEE Security(Object Level and Data Level Security) in the OBIEE Repository (rpd) and Answers, using Repository Variables, Session Variables and Initialization Blocks.

Confidential, North Raritan, New Jersey

OBIEE Developer

Environment: Oracle Business Intelligence10.1.3.2, Informatica 8.6, Siebel Business Analytics/OBIA 7.9.0, DAC, Oracle 8i/9i, SQL Developer, UNIX

Responsibilities:

  • Effectively interacted with the end users for requirement gathering, understanding the business requirement.
  • Prepared requirement specifications document and functional specification documents.
  • Review of Functional Design Document Specifications (FDDS), Code, related documents and deliverables.
  • Design and development of repository (rpd)- Physical Layer, Business Model and Mapping Layer and Presentation Layer and Configuration of Out-of-the-box HR Analytics.
  • Configuration and creation of reports and dashboard (Drill-Down, filters,Pivot Table, Chart, Column Selector, Tables) using Oracle Answers.
  • Worked with various teams including customers/end users, testers etc.
  • Conducted s on Business Intelligence Administration Tool, Presentation Services, Dashboard creation, etc.

Confidential

Seibel/OBIEE Developer

Environment: Seibel 7.8.3.1, Oracle 8i, SQL Developer, Windows

Responsibilities:

  • Understanding the business requirement, interacting with the clients, documenting the business requirement, functional and technical specifications.
  • Design and development of repository (rpd) - Physical, Business and Presentation layers, created hierarchies, level based measures.
  • Created OBIEE reports, dashboards, using Oracle BI Answers.
  • Unit and integration testing. Prepared test cases, executed and documented the results.
  • Performed data validation of data in reports and dashboards.
  • Managed security privileges for each subject area and dashboards according to user requirements.

Hire Now