SUMMARY:

­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­

• Over ten years of solid experience in the Business Requirements Analysis, Application Design, Data Modeling, Development, and Testing of Data Warehousing and Database and Implementations.
• Seven+ years of experience in OBIEE in different domain like Consumer Goods, Public Sector, Pharma, Banking, Finance verticals in Sales and in Marketing Analytics.
• Strong knowledge in Oracle Database server & RDBMS and Programming concepts. Strong skills in SQL, PL/SQL.
• Extensive Data modeling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables, Physical and logical data modeling.
• Very good at gathering business requirements by interacting with the business users.
• Performed gap analysis and feasibility study for the given requirement.
• Created mock up reports and dashboards for review by the business users.
• Performed Data Validation of data in the reports and dashboards.
• Extensively used SQL Tuning to improve performance.
• Design, Development and Documentation of the ETL strategy to populate the Data Warehouse from the various source systems.
• In depth knowledge on Data Mapping, Data Conversion, and Data Cleansing.
• Extensive experience in Siebel Analytics/OBIEE repository (Physical, Business Model and Mapping and Presentation layers) for both Stand - Alone and Integrated Siebel Analytics implementations.
• Extensively worked in creating hierarchies and aggregates in the BMML.
• Excellent proficiency in data and object level Security in Siebel Analytics/OBIEE.
• Extensive experience in customizing Siebel Analytics/OBIEE dashboards and reports.
• Extensive experience in Repository and Reports performance tuning.
• Extensively worked on Siebel EIM to import/export data between legacy and Siebel Databases.
• Performed unit, integration and system testing for all components in Siebel Analytics.
• Created design, development, and testing documentation.
• Extensive experience using Oracle, Teradata, PL/SQL, Toad, SQL Assistant.
• Enthusiastic team player, with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g/11i/12c, MySQL, DB2, MS SQL Server 2000/2005/2008

ETL: Informatica Power Center 9.5, 9.0, 8.1.1, 8.6.1(Repository manager, Designer, Workflow manager, Workflow monitor), IBM Web Sphere Information Server 8.0(Designer, Director,Administrator)

Languages: SQL, PL/SQL, T-SQL, UNIX Shell Scripting, COBOL, ASP, HTML, VB, Java Script

Tools: Toad, SQL Developer, MS Office, Erwin 4.1, Putty, WinSCP, Xming, JAWS, AMP, JIRA, Citrix, SharePoint

Operating Systems: Windows 98/NT/2000/XP/7, 8, 10, UNIX, LINUX)

BI Tools: OBIEE 10.1.3.X, 11.1.1.X

PROFESSIONAL EXPERIENCE:

Confidential,MD

BI Architect

• Interacted with the business analyst and business users to understand the customer requirement documents.
• Worked extensively on OBIEE 11G new features
• Upgraded OBIEE10g Application to OBIEE11g.
• Configured OBIEE components for reports Performance Tuning
• Diagnosing and troubleshooting BI Reports ability to articulate configuration and technical issues.
• Worked on OBIEE 11g tool evolution and recommendations.
• Tuned WebLogic application server and its managed servers to run deployed applications fast.
• Analyzed reporting requirements for dashboard reports and adhoc reports.
• Involved in Analysis and Design of the BI data warehouse.
• Fix the ETL load issues because of the data or ETL mappings. Execute Incremental test loads.
• Validated and customized reports.
• Test ran the load for a complete data load.
• Design the test cases for all the initial requirements.
• Involved in configuring, creating and modifying repository for various modules for necessary customizations
• Implemented security by creating users & groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associated catalog objects and Web modules with the created groups
• Integrate Custom warehouse table with the OBI Apps tables for extending the business analysis capabilities.
• Migrating/merging Repository and web-cat and documented migration procedure and best practices to be followed during migration from development to test and then to production.
• Documented processing times for each module, developed test cases and used them to run through each process.

Environment: OBIEE 11.1.1.5, Oracle 11g, MS Excel, Linux, Windows 7, SQL Plus

Confidential,NC

OBIEE Developer/Architect

• Gathered User requirements, reporting requirements and the document for requirement specifications.
• Analyze Design and Developed Metadata repository (.rpd) that consists of physical layer, multiple business models with dimensions & time series objects, presentation layers with catalogs, external table security using session variables, LDAP authentication, assigning catalog objects & Web modules to users & groups etc.
• Created dimension hierarchies, aggregates and keys in BMM layer. Worked on session variables and dynamic variables along with initialization blocks.
• Created users and groups in the repository and granted privileges and group inheritance.
• Worked extensively on Oracle BI Answers, Delivers and Interactive Dashboards.
• Configured many dashboards with different views like Pivot table, Chart, Tabular and View Selector and guided navigation links.
• Created Drill down Hierarchies, Levels and implemented logic by creating Level Based Measures at BMM Layer.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Performed Unit testing and Integration testing to validate Dashboards/Reports.
• Created highly formatted reports using BI Publisher based on Oracle Database.

Environment: OBIEE 11.1.1.5, Oracle 11g, MS Excel, Linux, Windows 7, SQL Plus

Confidential,MD

OBIEE Specialist

• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Performed gap analysis and feasibility study for the given requirement.
• Created mockup reports and dashboards for review by the business users.
• Customized the OBIEE Repository (physical, BMM, and presentation layers).
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Worked on repository and session variables.
• Used the security settings in Siebel Analytics Admin tool to setup users, Groups and Access privileges.
• Created materialized views and aggregates to improve performance.
• Customized Activity and Revenue star schemas.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Customized reporting with OBIEE Answers and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Created user level security for intelligence dashboards based on Business Requirement.
• Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation, Actual Vs Forecast Response rates, and Segment and Offer responses.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Performed Data Validation of data in the reports and dashboards.
• Extensively used SQL Tuning to improve performance.
• Created iBots to send pre-processed reports using OBIEE Delivers.
• Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.
• Worked on evaluation of Oracle BI Enterprise Edition and its new utilities including BI Server, Answers, Delivers and Publisher.
• Documented the design for intuitive understanding and future reference.
• Performed production support for the project.

Environment: OBIEE 11.1.1.6.2/11.1.1.6.0/10.1.3.4.2, Toad, Informatica, Erwin, SQL Server 2008 R2, Oracle 11g, SQL Server Management Studio 11, SQL Developer 3.2, Windows Server 2008, Windows 8.

Confidential,PA

OBIEE Specialist

• Performed various administrative tasks like OBIEE11g Installation, patching and configuration with different database environments, Production environment migration, creating and managing users etc.
• Worked closely with business users in the client side and designed the system accordingly.
• Experience in Oracle Map viewer configuration with OBIEE, troubleshooting web-logic, managed and BI admin servers, manually starting the servers using scripts.
• Created hundreds of dashboard reports as per the need of the client.
• Created the new RPD and detail level drill downs to as per business requirements using Oracle Answers.
• Worked extensively on OBIEE Administration tool and Presentation Services.
• Worked on the different layers in the data model (Physical, Business and Presentation).
• Involved in gathering and analyzing requirements and documenting them for further implementation.
• Created Session variable, Repository variable in RPD and used the same for role based security and Dynamic calculation in OBIEE answers.
• Customized Repository (RPD) to work with other EBI systems. Pulled new physical tables to physical layer of RPD, joined them with dimensional tables, developed hierarchy and presented them to presentation layer.
• Built Time-Series calculations using AGO and TODATE functions on BMM (Business mapping and modeling) layer of repository.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Used presentation variable in OBIEE Oracle answers to save prompt values and use them for conditional formatting.
• Developed different Dashboards/Reports with different view (Calculation, Detailed, Pivot, Charts, Filters) using the Presentation services.
• Scheduled iBots and seeded server cache using Delivers to improve system performance. Also used iBots to clear server cache using NQCmd utility. Scheduled reports to be e-mailed using iBots.
• Worked with both migrations of the Development and QA environments.
• Used TOAD for Oracle and SQL Navigator to connect to databases in Oracle.
• Performed Unit Testing and worked with the end user at various stages of the test cycles.
• Conducted meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle.

Environment: OBIEE 11.1.1.6.2/11.1.1.6.0/10.1.3.4.2, SQL Server 2008 R2, Oracle 11g, SQL Server Management Studio 11, SQL Developer 3.2, Windows Server 2008, Windows 7.

Confidential,NY

Sr. OBIEE Developer

• Involved in developing the Incremental ETL process i.e., Mappings & Mapplets using various transformations and Workflows with Sessions or Tasks.
• Identified and worked with various application areas in identifying, analyzing, and documenting various information sources solutions to meet the business requirements
• Extensively worked on OBIEE repository modeling at Physical, BMM and presentation layer
• Designed, developed and customized Reports and Dashboards using different analytical views.
• Designed and tested Reports in the Dashboards for the Oracle Financial Analytics and created the adhoc reports according to the client needs.
• Extensively worked with BI Publisher Reports and resolved the issues relating to BI Publisher and OBIEE integration.
• Created BI Publisher reports using OBIEE Answers: Union Report, Chart View and Drill Down.
• Created session variables for users to provide row- level security to build the query. Implemented Row level, Column level and object level security. Used various options in an OBIEE to improve the performance of reports.
• Used OBIEE Answers to create the Financial Statement reports and Dashboards as per the detailed design requirements. Coordinated the OBIEE RPD and Presentation Catalog objects migration across instances.
• Merged Presentation Catalogs (Web Catalogs) using OBIEE Catalog Manager. Set permissions on users in Catalog Manager.
• Involved in setting up and working in multi-user developer (MUD) environment

Environment: OBIEE 10.1.3.4.1 /11 g, Oracle BI Applications 7.9.6.2/3, Oracle DAC BI Publisher SQL, PL/SQL, Oracle Database 11g, Teradata, Oracle EBS R12, Oracle 10g/11g, SQL Developer, Windows 2003 server and Red Hat Linux 5.2

Confidential,Woonsocket,RI

OBIEE Developer

• Installation and configuration of all components of OBIEE, including the physical, logical, BMM and presentation layers.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Built Time-Series calculations using AGO and TODATE functions on BMM (Business mapping and modeling) layer of repository and TIMESTAMP Functions in the Answers.
• Worked on data from different sources and data at different levels of granularity to build the required functionality. Performed Data Validation including both unit and regression testing of data in the reports and dashboards including the functionality based on requirements.
• Implemented user security authentication using LDAP server directory
• Involved in performance tuning for BI server and Oracle SQL queries.
• Worked Extensively on Oracle Answers, Dashboards and Delivers to create reports.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Performance Enhancement of the data ware house using indexing, partitions and running statistics.

Environment: OBIEE 11.1.1.X, Siebel Analytics 7.8, DAC 7.9.5, ORACLE 11g, SQL, TOAD, PL/SQL,DB2, BI Publisher, XML, Oracle Reports, UNIX.

Confidential,Waltham,MA

OBIEE Developer

• Installed and configured complete suite of OBIEE 10.1.3.X in test and development environment windows platform.
• Worked closely with business users in the client side and designed the system accordingly.
• Created the new RPD and detail level drill downs to as per business requirements using Oracle Answers.
• Worked extensively on OBIEE Administration tool and Presentation Services.
• Worked on the different layers in the data model (Physical, Business and Presentation).
• Involved in gathering and analyzing requirements and documenting them for further implementation.
• Created Session variable, Repository variable in RPD and used the same for role based security and Dynamic calculation in OBIEE answers.
• Customized Repository (RPD) to work with other EBI systems. Pulled new physical tables to physical layer of RPD, joined them with dimensional tables, developed hierarchy and presented them to presentation layer.
• Built Time-Series calculations using AGO and TODATE functions on BMM (Business mapping and modeling) layer of repository.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Used presentation variable in OBIEE Oracle answers to save prompt values and use them for conditional formatting.
• Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager. Used job manager to manage and monitor Agent.
• Developed process for object level migration of web catalog, for post-production release of - enhanced and bug fixed reports.
• Worked with both migrations of the Development and QA environments.
• Used TOAD for Oracle and SQL Navigator to connect to databases in Oracle.
• Performed Unit Testing and worked with the end user at various stages of the test cycles.

Environment: OBIEE 10.1.3.4.1, Informatica Power Center 8.1.1, Oracle 9i, TOAD, SQL Navigator, Web Logic 8X, Windows XP Professional.

Confidential,Plainsboro,NJ

QA Engineer

• Performed Black Box Testing.
• Developed Test Cases from Business and Technical Specification wrote them in Test Director
• Execution of generated Test Cases Manually in Test Director
• Performed Functional, Regression and System Testing
• Maintained defect tracking and reporting using Test Director
• Performing Cross Browser, Configuration and Content testing
• Performed testing of the application on different versions of Internet Explorer, Netscape, AOL in diverse environments including Windows 98/NT, Unix and MAC
• Identified new performance issues with the web site that appeared in the new version.
• Provided recommendations to the application on steps to meet performance goals.

Environment: WinRunner 8.0, LoadRunner 8.0, Test Director 8.0, Oracle, JAVA, HTML, XML, Java Script, Java Servlets.

Confidential, TX

QA Tester

• Analyzed business requirements document, functional specifications document to prepare Test plan and Test cases.
• Developed and executed SQL Queries to verify the database updates, inserts and delete of the records, developed and execute complex SQL queries.
• Developed and executed Test Cases and Test Scripts for Functionality and Regression testing.
• Developed and documented Standard Testing Procedures for both Manual and Automated Testing.
• Involved in testing the new functionalities based on test cases and coordinated with development team in fixing the issues.
• Performed functional testing, integration testing, system testing, performance testing, stress testing and load testing.
• Provided testing the GUI consistency against different browsers (running on windows) against various screen resolutions.
• Performed Data Validation followed by the manual testing of back end
• Interacted with developers, business & end users.

Environment: HP Quick Test Professional, Quality Center, SQL Server, JAVA, SOAP UI, Windows XP/2000, UNIX and Agile.