Manager Oracle
Resume:
PROFESSIONAL SUMMARY:
• Seven plus years of experience in gathering Business Requirements, Analysis, Design, Development, Testing and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence
• Extensive BI and Data warehousing experience using OBIEE 11.1.1.x/10.1.3.x, OBIA 7.9.6.x/7.9.5.x, Siebel Analytics 7.x, Informatica 9.x/8.x/7.x, DAC 10.1.3.4, SQL and PL/SQL.
• Extensive experience in OBIEE Administration Tool, OBI Answers, OBI Intelligent Dashboards, OBI Publisher, Delivers and iBots with OBIEE Applications.
• Experience in Installation and Configuration of OBIA (including Informatica, DAC and OBIEE) Out of the Box Reports.
• Customized OBIA Out of Box Reports to meet the requirements by doing Business Analysis, Technical Analysis and RPD Modifications.
• Experience in developing Dimensional Hierarchies/Creating Aggregate Measures/Aggregate Tables/New logical columns/Filters/Variables/Time Series Functions as per business requirements
• Proficient in configuring Security settings at various levels both in Repository level (OBIEE Administration Tool to setup Groups, Access Privileges and Query Limits) and Presentation Catalog level.
• Experience Integrating LDAP Server for authentication of users.
• Experience developing reports & dashboards in OBIEE (BI Publisher, Dashboard, Answers, Delivers, Oracle BI for Microsoft Office).
• Expertise in Creating Dynamic Dashboards and OBIEE Answers using Prompts, Filters, Calculations, Charts, Pivot tables, View Selector and Conditional Formatting.
• Configured, Designed and developed BI Publisher reports by integrating them with Microsoft Office application according to client’s requirement.
• Experience in migration techniques for OBIEE, Informatica and DAC components into various test and production environments.
• Strong understanding of OBIEE 11g concepts, especially in configuring Security settings using Weblogic Server (Users and Groups), Oracle Enterprise Manager (OEM for Roles and Privileges) and Presentation Catalog.
• Strong Knowledge and understanding of Relational Databases(Oracle and SQL Server), data warehousing concepts and querying tools.
• Skilled in data warehouse methodology, data analysis and modeling, business intelligence architectures, report development, ETL development, and database design.
• Created Test cases and Tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
• Experience in designing and testing mappings, mapplets and workflows using Informatica Power Center.
• Experience with Oracle EBS concepts of Financial Analytics, Spend Analytics, Project Analytics, HR Analytics and Supply Chain module.
• Worked on different subject areas of AP, AR and GL to create Reports and Dashboards according to the business requirements.
• Very strong in Oracle PL/SQL programs, Procedures, Packages, Functions, Triggers and other objects.
• Excellent Written and Verbal Skills; Ease to learn and apply new technologies and improve processes.
CERTIFICATIONS:
• Oracle 11g Database Administrator Certified Associate
TECHNICAL SKILLS:
Business Intelligence : Oracle Business Intelligence Enterprise Edition (OBIEE) 11.x/10.x, OBIA 7.9.x, Siebel
Analytics 7.x, OBIEE+ 10.x, BI Publisher.
ETL Tools : Informatica Power Center 9.x/8.x/7.x, DAC 10.x
ERP Systems : Oracle EBS R12, People Soft, Siebel CRM.
RDBMS : Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000, MS Access
Operating Systems : Windows 2000/XP/vista/7, LINUX, UNIX AIX, UNIX(Solaris)
Languages : Java, SQL, PL/SQL, T-SQL
Web Based : HTML, XML, Dreamweaver
Tools : SQL*Plus, SQL Developer, TOAD
Others : MS office, Adobe Acrobat, SQL Developer Datamodeler, Microsoft Visio.
PROFESSIONAL EXPERIENCE:
Client : Blue Cross Blue Shield of Michigan Detroit, MI
Duration : 12/2011 - Present
Designation : OBIEE/BI Apps Consultant
Responsibilities:
• Worked closely with Business users, Functional team to understand the reporting requirements and did business analysis and Technical Analysis.
• Trained Business users to generate and create their own reports, dashboards and perform ad-hoc analysis. Documented the steps according to the company format.
• Configured ETL procedures to load data from different sources into data- warehouse using Informatica Power Center Designer, Workflow Manager, Repository Manager and Workflow Monitor.
• Created and Customized the source and target instances and various transformations (Joiner, Aggregate, Lookup, Filters and Router Transformations) in informatica and also created mappings, sessions and workflow to run ETL process using Informatica Power Center.
• Configured, Customized and Defined Repository objects in DAC (tasks, taskgroups, subject areas etc.), built, ran and monitored ETL execution plans.
• Generated DDL scripts for the target tables as per the Warehouse naming standards – column, table, index, etc.
• Created OBIEE Repository and implemented the business logic by customization, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, etc.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Developed dimensional hierarchies based on the business requirements of an attribute.
• Performed Consistency check and Global Consistency check of the Business Model before exposing Business Models in the Presentation Layer considering errors, warnings and best practices.
• Built test cases and tested the Repository/Reports by comparing the SQL Output on the Data warehouse to the values in the Reports and documented the test results.
• Worked with OBIEE Answers and created required reports. Demonstrated knowledge in dealing with various functionalities like views, aggregates, filters, pivot tables, tables, view selectors, charts, Interaction, customization, conditional formatting of reports.
• Created and Executed test cases to validate the User Interface, Data and Design.
• Managed User access by implementing Object level and Data Level Security for each Subject area and Dashboards.
• Worked on deployment of different OBIEE Builds on Linux Production Servers.
• Responsible for maintaining and troubleshooting issues on the servers. Migrating Informatica Workflows, DAC Repository, OBIEE Repository, Instanceconfig.xml, Web catalog etc and other files between different environments.
• Designed the Business Requirements document, Technical Design document and Migration documents as per the company format.
Environment: OBIA 7.9.6.3, OBIEE 11.1.1.5, Informatica Power Center 9.0.1, DAC 10.1.3.4.1, Oracle 11g, Windows Server 2005, SQL, Oracle People Soft ERP (Financial Analytics, Procurement and Spend Analytics, Service Procurement Analytics) 9.1, Windows XP, WINSCP, Putty, SQL Developer.
Client : SHERWIN-WILLIAMS Cleveland, OH
Duration : 06/2011 – 11/2011
Designation : OBIEE Consultant
Responsibilities:
• Worked closely with business users and BI team which built reporting solution for the Sales BI Project and gathered business requirements.
• Designed the required reports for the SWAFC Supply Agreement module to meet the business requirements.
• Worked closely with the Data Modeling team in understanding the business requirements and generated DDL scripts for the target tables as per the SWAFC naming standards – column, table, index, etc.
• Created OBIEE Repository and implemented the business logic by customization, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, Security Management and Variables.
• Responsible for implementing and managing security at both Repository Level and Presentation Catalog Levels and Configured LDAP Server for authentication of users.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Developed dimensional hierarchies based on the business requirements of an attribute.
• Performed Consistency check and Global Consistency check of the Business Model before exposing Business Models in the Presentation Layer considering errors, warnings and best practices.
• Built test cases and tested the Repository/Reports by comparing the SQL Output on the Data warehouse to the values in the Reports and documented the test results.
• Worked with OBIEE Answers and created required reports. Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, filters, view selectors, charts, Interaction, customization, conditional formatting of reports.
• Created and Executed test cases to validated the User Interface, Data and Design.
• Worked on deployment of different OBIEE Builds on Linux Production Servers.
• Responsible for maintaining and troubleshooting issues on the servers. Migrating RPD and Web catalog between different environments.
• Designed the Business Requirements document and Technical Design document as per the company format.
Environment: OBIEE 10.1.3.4.1, Oracle 11g, SQL Developer, Oracle EBS R12, Windows XP, SQL Developer Datamodeler, SQL Server 2008, Informatica Power Center 8.1.1, WINSCP, Putty, SQL.
Client : NJVC, LLC - Vienna, VA
Duration : 06/2010 – 05/2011
Designation : OBIEE/BI Apps Consultant/Admin
Responsibilities:
• Installed and configured the OBIEE 10.3.4.1 client, server tools and configured ODBC Connections. Configured Oracle BI Applications RPD and Web Catalog.
• Configured DAC client and server to work with Oracle BI Applications and Informatica.
• Defined Repository objects in DAC (tasks, taskgroups, subject areas etc.,), built, ran and monitored ETL execution plans.
• Installed and Configured Oracle BI Applications (Oracle Financial Analytics) and metadata repository files.
• Customized Out of Box OBIA reports to meet the requirements by doing Business Analysis, Technical Analysis and RPD Modifications.
• Designed, developed and tested reports for Oracle Financial Analytics modules of AP, AR and GL as per the requirements.
• Created OBIEE Repositories and implemented the business logic by customization, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, Security Management (Data level/Object level security), Variables, Initialization blocks and cache management.
• Responsible for implementing and managing security at both Repository Level and Presentation Catalog Levels.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Developed dimensional hierarchies based on the business requirement of an attribute.
• Performed Consistency check and Global Consistency check of the Business Model before exposing Business Models in the Presentation Layer considering errors and warnings.
• Worked with OBIEE/OBIA Answers, Intelligence Dashboards. Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, scheduling, guided navigation, customization, conditional formatting of reports. Managed dashboard and request security/privileges in the analytics catalog manager.
• Worked on different subject areas of AP, AR and GL to create Reports and Dashboards according to the business requirements.
• Successfully implemented OBIEE delivers/Created Proactive agents (iBots) and configured Interactive dashboards to alert the Business/Field users as per the requirements.
• Created and Executed test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
• Configured, Designed and developed BI Publisher reports by integrating them with Microsoft Office application according to client’s requirement.
• Involved in merging changes of Repository and Web catalog from development to test and production environments.
• Migrated Repository and Web Catalog files between development, test and production environments.
• Trained and assisted Business users to generate their own reports.
Environment: OBIEE 10.1.3.4.1, OBIA 7.9.6.1 (Financial Analytics, Procurement and Spend Analytics and HR Analytics), Informatica Power Center 8.6, DAC 10.1.3.4, Oracle 11g, SQL Server 2008, Oracle EBS R12, TOAD 9.5, MS SQL Server 2008, Windows NT, WINSCP, Putty, Oracle BI Publisher, SQL.
Client : ArvinMeritor, Inc - Troy, MI
Duration : 11/2009 - 05/2010
Designation : OBIEE Consultant
Responsibilities:
• Involved in analysis, requirements gathering, function/technical specifications, development, deploying and testing.
• Data modelling (STAR schema) design and architecture, created new facts, dimensions, select tables and alias tables for the dimensional tables when required.
• Extensively used OBIEE Administration Tool for customizing and modifying the Physical, Business and Presentation layer of the Repository.
• Architecture design of business model. Identified Facts, Dimensions, and Hierarchies of the business model. Created complex calculated measures based on time dimension to calculate Quarter Ago and Year Ago metrics
• Specified dimensional hierarchy and aggregate levels for the dimensions.
• Developed different brand level Reports, Filters, and Prompts using Oracle Business Intelligence Answers.
• Created various reports to fulfill the staff needs and customized the views using Oracle BI Answers.
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users which include business users from various parts of the world.
• Used Analytics Web Catalog to set up groups, access privileges and query privileges.
• Created and scheduled iBots as per the business requirements.
• Used Oracle Hyperion Smart Views to view, import, manipulate, distribute and share data in Microsoft Excel, Word and PowerPoint interfaces.
• Designing data warehouse to support RPD schemas.
• Reports development/customization with prompts and various types of pivot tables.
• Created and Executed test cases to validated the User Interface, Data and Design.
• Communicating with client to understand/clarify requirements and suggest enhancements.
• Extensive SQL coding for data verification.
• Customizing latest oracle data warehouse to meet metadata design requirements.
Environment: OBIEE+ 10.1.3.3.2/3.3.3, Informatica Power Center 8.1.1, Oracle EBS (INVENTORY, PO, AP, AR, GL), Oracle 11g, SQL Developer, SQL, PL/SQL, Windows XP, Unix AIX, Puty, Windows Server 2008.
Client : Eaton Steel - Oak Park, MI
Duration : 08/2008 - 10/2009
Designation : OBIEE Consultant
Responsibilities:
• Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
• Analyzed the specifications provided by the client, understanding the business.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher
• Designed Star schema for fact & dimensional tables and created alias for the dimension and fact tables when necessary.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports
• Specified Dimensional hierarchy and Aggregate levels for the dimensions.
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports
• Created various reports to fulfill the marketing needs and customized the views using Oracle BI Answers.
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users, which include like Managers, functional heads, Department Heads.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Used the Catalog Manager and maintained the Analytics web catalog to manage dashboards & answers.
• Worked in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Extensively worked on workflow manager and workflow monitor to create, schedule, monitor workflows, work lets, sessions, tasks etc.
• Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
• Performed Unit testing, integration testing to verify the report functionality and debugged dashboard reports to verify data matches as expected.
Environment: OBIEE 10.1.3.3, Informatica Power Center 8.1.1,Oracle EBS, Windows XP, UNIX AIX, Oracle 10g, SQL, PL/SQL.
Client : Marathon Electric India Pvt Ltd (MEIPL) - Hyderabad, India.
Duration : 06/2006 - 07/2008
Designation : Siebel Analytics/OBIEE Developer
Responsibilities:
• Involved in all major aspects of Siebel Analytics development. Siebel Analytics repository configuration, security administration, web catalog maintenance, Dashboard and report development, delivers, and cache management.
• Designed and built Star and Snowflake schemas.
• Define the mapping from various physical databases to Business Layer to create the various subject areas in Presentation Layer.
• Implemented OBIEE security for users and groups in administrator tool.
• Created reports by applying views, filters, calculations and conditional formatting in answers.
• Extensively worked on Data Extraction from Databases, XML and flat files by using Informatica.
• Experienced in Data warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources into data- warehouse using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Created the source and target instances and various transformations (Joiner, Aggregate, Lookup, Filters and Router Transformations) in informatica and also created mappings, sessions and workflow to run ETL process using Informatica Power Center.
• Designed Intelligent Dashboards for different user groups to view updated KPIs
• Wrote scripts for creating tablespaces, rollback segments, tables, synonyms, roles, indexes, views, constraints, database tuning by deciding appropriate table sizing parameters, user maintenance.
• Provided technical and user documentation.
Environment: Siebel Analytics 7.8.2, OBIEE 10.1.3.1, Informatica Power Center 7.1.3, Oracle 10g, SQL, PL/SQL, Linux, windows XP.
Client : iGate Global Solutions - Hyderabad, India.
Duration : 01/2005 - 05/2006
Designation : Oracle Developer
Responsibilities:
• Communicated with clients regarding system requirements, ensuring the development and implementation of customized products to customer satisfaction
• Prepared functional specifications for user requirements.
• Experience in writing, testing and implementation of PL/SQL triggers, stored procedures, functions, packages to implement business logic.
• Developed and modified applications, authored database procedures and triggers for data processing.
• Created entry forms/reports for various modules. Created databases, generated users, and assigned roles and access.
• Created Tables, Indexes, Table Spaces, Views synonyms, and integrity constraints.
• Prepared User manual, Technical documents for the end user.
• Prepared executables for system deployment and led the release of applications following
• Experience in UNIX Environment in file transfers, job scheduling and error handling
• Maintenance and support for the system.
Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, Windows XP, UNIX.
EDUCATION:
• Bachelor of Technology in Engineering
Contact this candidate