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.