SUMMARY

• 8+ years of IT experience in Software Design, Development, Implementation and Maintenance of Business intelligence applications
• Experience in Implementing reporting solutions based on OBIEE(11g/10g)
• Translating business requirements into functional specifications, reviewing the specifications with architecture team, developing test plans and deploying analytical applications with client community
• OBIEE 11.1.1.7/11.1.1.6/10.1.3 Repository Metadata Objects Configuration (Building Physical, BMM and Presentation layers) and Web Catalog Objects Configuration (Dashboards, Analyses, Reports, Alerts)
• Experience with OBIEE product suite, including RPD configuration and Dashboard development
• Extensively worked with DBAs and BAs towards performance tuning in OBIEE and Data Warehouse environment using cache management, aggregate tables, and indexes
• Experience in installing and configuring OBIEE 11g Windows platform
• Experience in migration of OBIEE RPD and Web Catalog between dev/test/prod environments
• Experience in set up of OBIEE Security using LDAP and Site minder and configuring object level and database level security
• Configuring Teradata and Oracle databases as data sources for OBIEE environment
• Experience in creating Agents using OBIEE Delivers
• Hands on experience in configuring Usage Tracking, BI Delivers and BI Mobile in OBIEE 11g
• Experience in Data Modeling using Dimensional Data Modeling, Star Schema/Snow flake Schema Data Modeling in the OBIEE Administration tool.
• Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Strong understanding of Data warehousing/ETL concepts and end to end OLAP approach.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality.
• Experience in complete Software development lifecycle(SDLC) which include gathering business requirements, compiling specifications, requirement analysis, design, data modeling, development, testing, deployment, platform administration and support.
• Expertise in writing Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases, Test scripts, RTMs, Defect status reports, Test Summary report.

TECHNICAL SKILLS

Software Products: Oracle Business Intelligence Suite EE 11.1.1.7.1/ 11.1.1.7.0 / 11.1.1.6.2 / 11.1.1.6.0 / 10.1.3.4 , Informatica 7.1.2, Oracle EBS 11i and R12, Seibel CRM

Platforms: Windows 7/XP/NT, UNIX, Linux, Windows Server 2008 R2

Databases: Oracle 11g/10g/9i, SQL, Teradata 12/13/14

Database Languages: SQL, SQL*Plus, UNIX Shell Scripts, Toad

Applications: MS Office (Word, Excel, PowerPoint, Access, Outlook)

Other Tools: WinSCP, Putty

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale CA

OBIEE Developer

Responsibilities:

• Worked with functional and technical project leads, to identify, analyze, and document Business requirements.
• Involved in translating business requirements into logical business dimensional model
• Interact with Customer operations team to convert business requirements into technical work plan.
• Work on OBIEE Administration Tool to build the Physical layer, BMM and Presentation layers of the repository (.rpd).
• Generate reports based on the Ad - hoc report requests of the users.
• Skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports.
• Manage Security privileges for Subject areas and Dashboards according to user requirements.
• Perform tuning of Oracle BI Reports.
• Extensive knowledge in working with Variable Manager to define session and repository variables and initialization blocks to streamline administrative tasks and modify metadata content dynamically.
• Work with users to prioritize business improvements identified and implement changes per prioritization.
• Experienced in defining Key Performance Metrics (KPIs), facts, dimensions, hierarchies and developing Star and Snow Flake schemas.
• Organize and leads team focus groups/workshops to document processes and identify improvement opportunities.
• Utilize OBIEE Analytics UI for Creating and Managing OBIEE Dashboards, Answers and Agents.
• Use the Catalog Manager to maintain OBIEE web catalog.
• Created and maintained metadata and ETL documentation that support business rules and detailed source to target data mappings.

Environment: OBIEE 11.1.1.7.0 , Windows 2008 R2, Oracle 11.2.0.1, Siebel CRM (Source).

Confidential, High Point NC

OBIEE Consultant

Responsibilities:

• Involved in translating business requirements into logical business dimensional model
• Utilized OBIEE Admin Tool to build Physical, BMM and Presentation layers of the repository (.rpd).
• Utilized the Catalog Manager to maintain OBIEE web catalog.
• Perform tuning of Oracle BI Reports
• Managed Security privileges for Subject areas and Dashboards according to user requirements.
• Work Extensively on Oracle Answers, Dashboards, to generate reports.
• Utilized OBIEE Analytics UI to create and manage OBIEE Dashboards, Answers and Delivers.
• Implemented Data Level and Object Level Security Setup for the Inventory Application
• Setup Event driven action reports and configured reports with drill down capabilities.
• Configured Oracle and Teradata Data sources for OBIEE Environment.
• Configured the security model for OBIEE 11g using SSO Authentication and LDAP Authorization.
• Tuned OBIEE 11g Platform to meet the performance criteria.
• Responsible for the project delivery timelines defined for OBIEE Module.
• Debugged the server logs, identify and resolve errors seen in the server logs.
• Monitored and resolved incidents with OBIEE Application support and development teams.
• Developed POC for BI Mobile configuration on iPhone / iPad to access OBIEE Reports.
• Support OBIEE 11g in production and non-production environments.

Environment: OBIEE 11.1.1.6.0/11.1.1.6.2/ 11.1.1.7.0 , Linux OEL 5.6, Weblogic 10.3.6, Teradata 12/13/14, Oracle 11.2.0.1.

Confidential, Reston, VA

OBIEE Developer

Responsibilities:

• Conducted requirements analysis, Designed report structure to business owners’ requirements
• Designed and developed Data models and RPD models to support defined reporting requirements
• Optimized OBIEE report performance
• Configured OBIEE Security and Performed OBIEE Admin Activities
• Extensively experienced in gathering requirements from Business Users and translating them into Design documents
• Worked on POC on BI Publisher and Map Viewer
• Created much analysis, dashboards and scheduled many Agents to make sure that the users receive the reports as per their demand.
• Trouble shooting the data against the core database and delivering the good results to the users.
• Created new subject areas in RPD and also involved in Full merge, patch merge and deployments in the server.
• Experienced in agents failing issue and in migrating the reports from one environment to other.
• Created repository variables and Initialization blocks.
• Created level based measures.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Created Global/Local Prompts, Narrative Views, Filters, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Configured Intelligence dashboards by including embedded content such as links/images & HTML objects.
• Created Aggregated Tables and configured the content in Business Model Layer to use the Aggregate tables for better performance.
• Implemented Time Comparison and Calculation measures in the business model using Time series Functions.
• Responsible for testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, Oracle) feeds using ODI and CDC.

Environment: OBIEE 11.1.1.3/6, ODI 10g/11g, Oracle 10/11g, TOAD, SQL Developer, Windows XP, Windows 2003 Server.

Confidential, Brookfield WI

BI Tester

Responsibilities:

• Examined and understood the Requirements from client and developed test cases based on functional requirements, reports specifications, data mapping requirements and system specifications.
• Used Quality Center for Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result maintenance.
• Prepared Test Plans and Test Cases for Reports testing and ETL testing.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Written test cases for - unit level, functional and integration testing.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests
• Extensive querying using Toad to run SQL queries and monitor quality & integrity of data.
• Worked with data base validation, constraints validation, record counts, source to target validation, and error processing.
• Done data validation, accuracy of calculated fields, Accuracy of the data shown, Selection criteria shown, Accuracy of subtotals for the OBIEE reports.
• Validated the front end reporting components created using OBIEE Reports as well as performed back end testing, making sure that the correct data for a specific report are being pulled out from the Data Warehouse.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts.
• Worked in the role of data analyst in mapping and scrubbing sensitive data within the application.
• Verified Informatica session logs to identify the errors occurred during the ETL execution.
• Actively participated in stand up meetings, story reviews, retrospectives of the Agile process.

Environment: Informatica Power center 9.1, Oracle 11g, SQL, OBIEE, SQL Server 2008, T-SQL, SSIS, SSRS, DB2, Analytics, Share Point, Quality Center 11, Jira, UNIX, Remedy, SnagIt, Compare IT, MS Office

Confidential

Associate Engineer - ETL Tester

Responsibilities:

• Performed Requirements Verification Testing, Unit Testing, Functional Testing, Regression Testing, Post Production testing and End to end Testing of ETL code and reports.
• Tested daily, monthly and quarterly loads end to end.
• Experience in writing complicated SQL statements.
• Designed, Developed and tested SQL Programs to prepare and clean Data for data migration and also to retrieve data from the database to compare against the input sets
• Validated the base table (Star schemas- Fact and Dimension) by writing SQL statements and reports.
• Did functional testing using Quick Test Pro.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Prepared Mapping documents and design documents for data conversion.
• Developed validation procedures and error reporting on the data in the intermediate tables.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables.
• Used various checkpoints in the Informatica designer to check the data being transformed.
• Wrote and ran UNIX Scripts for batch jobs.
• Involved in validating the ETL mappings from various systems (CRM, OLTP) to transaction history/reporting database.

Environment: Informatica 6.2/5.1, Toad, SQL, Test Director, Shell Scripting, QTP, Sun Solaris 5.8, Windows NT 4.0, Erwin, Test Cases, Test Plan, Test Scripts

Confidential

Jr. Software Tester

Responsibilities:

• Document Manual testing procedures for the entire application with strong emphasis on regression and integration testing.
• Performed Data-Driven Tests by passing different sets of data and checked whether the information entered is updated into the database.
• Reported the defects in the Quality Center automated tool and coordinated with the QA Lead and developers.
• Developed Test Analysis reports and Master Test Plans for each testing effort.
• Analyze Business, System requirements and Test Requirements Document (TRD) that are being loaded in HP Quality Center.
• Update those Manual testing procedures as and when Application functionality changes.
• Manually test key application functionality for major releases.
• Document defects identified during manual testing.
• Work with development team to fix those defects and re-test manually.
• Work with QA lead to prepare Test Plan, Test Cases, Test requirements and procedures.

Environment: SQL, MS Visio, XML, Windows XP/2000, JIRA Bug Tool, Test Director.