We provide IT Staff Augmentation Services!

Business System Analyst Resume

CaliforniA

Summary
Insightful, result driven, experienced and dedicated Business Systems Analyst with close to 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 Summary
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, MS Office Suit: Word, Excel, PowerPoint, SharePoint.
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,
Accomplishments

  • Close to 8 years of IT experience in Business Intelligence Applications using Oracle Business Intelligence (OBIEE) / Oracle Business Intelligence Apps (BI Apps), with 4 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 Requirements Documents (BRDs), Software Requirements Specifications (SRS), Requirements Traceability Matrix.
  • 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 related trainings.
  • Managed hours so that delivery timelines for the clients are achieved.
Confidential, California
Role: 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

Confidential multinational software corporation that focuses on 3D design software for use in the architecture, engineering, construction, manufacturing, media, and entertainment industries, leveraging the maximum possible returns from those investments. Autodesk became best known for AutoCAD but now develops a broad range of software for design, engineering, and entertainment. Autodesk also provides digital media creation and management software for film and television visual effects, color grading, and editing as well as animation, game development, and design visualization.

Project1: This assignment is to retire the current OBIEE reports, dashboards, subject areas and the repository as well and providing the Business Users with an interim solution with reports built using SAP Business Object or the final solution: new advanced reporting using QlikView. Have divided this assignment to different modules like Partner Authorization/Information, Assets, Major Accounts (MJA), Subscription Agreements, Customer Data Enrichment (CDE), etc.

Project2: This project is to do QlikView Reporting on the different Subscription Program Models: Desktop, Maintenance and CLOUD Services. Solution design across various attributes like Parent Industry, TERMS: Agreement/Renewal, Requirements Gathering and Analysis for new dashboard for EDUCATIONAL software, etc. Also working on requirements gathering and analysis for a new Subject Area called- ASSET UPGRADE, preparing the solution designing for the same. This subject area will enable the business and sales reps to navigate to the entire upgrade path for any selected asset, like-
  • Which was the initial registered asset,
  • To which all assets was/is it upgraded to,
  • If any mergers of asset/serial numbers happened during the upgrade,
  • What products customers were migrating from in a specific time frame, with any specific release,
  • Trending pattern for any customer, like, - if upgrading every year, with every release, or upgrading once every 3-4 years, new seats purchased, etc.
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 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.
  • 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.
  • 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
Role: Business Analyst-OBIEE
Environment: Oracle Business Intelligence11.1.1.6, Informatica 8.6, Oracle 11g, PL/SQL Developer, UNIX, Oracle EBS R12

The Confidential multinational banking and financial corporation formed on July 1, 2007 as result of the merger of The Confidential Financial Corporation. The Confidential operates worldwide in more than 100 markets in 36 countries and employs more than 48,000 employees. The group's American and worldwide headquarters is located at One Wall Street. The engagement comprised implementation of OBIEE to create analytical reports on the various types of the customers, their need for loan, collaterals kept with the bank, customer feedback for their respective bank representatives, etc.
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 (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.
  • Prepare the Requirements Traceability Matrix.
  • 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 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.

Confidential , Pennsylvania

Role: 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

Confidential is a financial services corporation. PNC operations include a regional banking franchise operating primarily in fifteen states and the District of Columbia, specialized financial businesses serving companies and government entities, and leading asset management and processing businesses. PNC is the sixth largest bank by deposits in the United States and is the third largest bank off-premise ATM provider.

Project 1: The first phase of this assignment comprised of the Oracle Financial Analytics out-of-box implementation.Confidential is a modular component of Oracle’s family of integrated Business Intelligence Applications. This project provides a data Warehouse solution by enabling the out-of-the box repository (rpd), enabling the dashboards and reports and customization of out-of-the box reports based on the change requests.

Another module was the implementation of OBIEE suite for the data flow at the ETL Level across various stages in an effort to provide a common platform for accessing and managing the information and automate the processes. The main objective and benefits of this project is to deliver an Analytics application to empower the end users (Internal users like managers, ETL Analysts), allowing them to perform powerful ad-hoc reports and data analysis and also to deliver critical path Analytics functionalities to the business community.

Project 2: This data warehouse project for PNC was to get detail report on the various bank activities and the customer engagements. The Credit Quality Book provides information of for the loans provided to customers categorized by Home Equity, Residential Real Estate etc., Performing and Non-Performing Assets, Dues etc. The entire project is divided in to two phases of which the second phase consists of creating the data warehouse and initial reporting capabilities.
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 High-level (BRD) document, Low-level design document to meet the reporting needs.
  • Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias.
  • 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 training materials for process improvements. Conducted trainings on Business Intelligence Administration Tool, Presentation Services, Dashboard creation, Business Process, etc.
Confidential , New Jersey
Role: 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

Confidential has more than 250 companies located in 57 countries around the world. GHRT project aims to centralize the HR processes with Confidential across all the operating companies and affiliates by outsourcing it to Convergys. The Confidential is a prestigious program that aims to transform Human Resource activities within Confidential by centralizing HR applications across worldwide operating companies and outsourcing it to Convergys.
The Confidential project is executed based on the Onsite-Offshore model and the GHRT team comprises of both TCS and Confidential WISE employees.

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.
  • Performed data validation of data in reports and dashboards.
  • Managed security privileges for each subject area and dashboards according to user requirements.
  • Implemented OBIEE Security (Object Level and Data Level Security) in the OBIEE Repository (rpd) and Answers, using Repository Variables, Session Variables and Initialization Blocks.
  • Unit and integration testing. Prepared test cases, executed and documented the results.
  • Conducted trainings on Business Intelligence Administration Tool, Presentation Services, Dashboard creation, etc.
Confidential, India
Role: Seibel/OBIEE Developer
Environment: Seibel 7.8.3.1, Oracle 8i, SQL Developer, Windows

Build a new data mart called Alignment Master to store all Novartis’ alignment data which will be derived from the various 3rd party tool, to which all master data marts are integrated. Integration of existing Novartis data stores which consists of the feeds from the following Novartis data marts:
  • Customer Master (CM)
  • Product Master (GPM)
  • Employee Master (ESA)
  • Product specialty data store (PSR)
Developed the custom reports on the Master Data Mart based on the client requirements.
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