SUMMARY:

• 11 years of Total IT experience
• 10 years of Data warehouse and Business Intelligence Solution experience
• 9 years of OBIEE Experience
• 8 years of SQL experience
• 3 years of ETL experience
• 2 years of QA experience
• 11 years of experience in Complete Software Development Life Cycle (SDLC) implementation of various Business Intelligence and Data Warehouse / Data Marts that covers gathering Business Requirements, GAP Analysis, Design / Modeling (Star and Snowflake), Development, Testing, Implementations and Documentation and post Production Support.
• Experience in installing and configuring OBIEE 11g and OBIA 7.9.x (Finance, Project, Procurement and Spend, Sales Analytics)
• Excellent understanding of Star Schema/Snow flake Schema methodologies and Dimensional Modeling
• Worked in different Industry Verticals and well experience in Utilities, Retail, Telecom, Manufacturing, Hi - Tech, Banking.
• Experience in interacting with the Business Users to analyze the business process and gathering business Requirements.
• Good in Oracle SQL Plus programs, Procedures, Packages, Functions, Triggers and other objects.
• Multi-platform experience on UNIX / Linux and Windows Server family.
• Experience in documenting Design specs, Unit test plan and deployment plan.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.
• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts.
• Strong Conceptual, Business, Analytical skills & highly motivated team player and ability to provide work estimates and meet deadlines.
• Excellent written and verbal communication skills.
• Very strong experience in developing OBIEE / Siebel Analytics Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using page and dashboard prompts, Security Setup (groups, object and data level), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
• Implemented Data level and Object level Security
• Experience in setting up the usage tracking, creating variables/ Initialization Blocks
• Hands-on Experience in configuring Interactive Dashboards with drill-down capabilities using Filters and Dashboard Prompts, OBIEE Security Setup (groups, access privileges), Metadata objects and Web Catalog objects (Dashboard, pages, folders, and reports), Answers to run queries to test and validate the repository
• Working with different types of hierarchies and setting aggregation content level in facts and dimensions variables and Initialization blocks
• Creating complex joins in BMM layer
• Implementing Security at both Object level and data/row level
• Working with different caching strategies
• Have hands-on work experience with MUDE (Multi-User Development Environment)
• Creating set operations within an analysis, performing run-time aggregation within an analysis,complex filtering and aggregation
• Creating dashboards with complex prompt and layout requirements
• Creating navigational links using GOURL, Drill-through Action links and drill up/down
• Creating agents and distributing reports in multiple formats
• Creating custom report layouts using HTML, Javascripts/JQueries and Narrative views
• Worked with data models to create BI Publisher reports
• Created BI Publisher reports using doc and xls
• Performance tuning initiatives to improve run time performance of several reports in OBIEE which included indexing strategies, redesigning reports/FM/RPD model to employ best practices, creating aggregate tables
• Migration of OBIEE objects from one environment to another.(DEV-SIT-UAT-PROD)
• Experience with Authentication through LDAP and Authorization to the external tables, Single Sign On (SSO).
• Good in validating the BI reports/dashboards by preparing the Test Plans and Cases.
• Implemented Usage tracking to analyze and tune the query performance.
• Customization of Confidential reports in OBIA to meet specific customer requirement, which involved change in RPD as well as reports.
• Translating and converting business requirements into Business Intelligence functional design documents to support the business and technical teams.
• Managing BI teams in onshore-offshore mode.
• Experience with Agile Project Management and Waterfall.
• Work closely with Subject Matter Experts and Data SMEs in the team to ensure functional specifications are designed appropriately to meet the reporting needs
• Identify, create and develop requirements around useful business analytics, dashboard views, decision algorithms and management summaries
• Perform functionality gap analysis of the current reporting landscape and solution design of how that fits within the BI reporting solution.
• Walkthrough the functional design documents and related deliverables with the technical team and business team to seek signoff
• Review and provide feedback on the technical design documents from the technical team to ensure it aligns with the functional design document and leverages best practices from a BI and DW perspective
• Provide functional support in the form of research, documentation updates and enhancement requests during the testing phase to ensure the defects identified are valid defects that the technical team needs to work on
• Support data reconciliation from a BI front end perspective to ensure the KPIs, balances and field level data within dashboards/reports matches with what’s expected to ensure data accuracy and completeness
• Hands on experience on different versions of OBIEE and OBIA, expertise on creation of OBIEE reports, dashboards, developing the r.p.d (Metadata) and customization of OBIA r.p.d (Metadata).
• Experience in documenting key deliverables such as Requirement Gathering, FIT/GAP Analysis, ETL specs, Repository Protocol Design (RPD), Functional Design for Reports and Data Mapping.
• Strong experience on customization & implementations of Data Warehouses using ETL and Oracle BI Reporting tools
• Have a strong understanding of the OBIA architecture including physical data models, ETL, logical business models and subject areas.
• Excellent communication & presentation skills
• Detailed Oriented and strong experience in performing Data analysis
• Experience in end-to-end implementation of BI

TECHNICAL SKILLS:

Reporting: OBIEE 11g, OBIA (11.1.1.8, 7.9.6.3 and 7.9.6.2), OBIEE 10g, BI publisher 10g, Siebel Analytics 7.8, Tableau

ETL: Understanding of ODI, Informatica, OWB

Programming Languages: SQL, PL/SQL, Unix Shell Scripting

RDBMS: Oracle 11g, Oracle 10g

QA Tools: Test director, HP Quality Centre

Portal: Oracle WebCenter/Weblogic-Oracle OBIEE 11g and Oracle Dashboards

Database Apps: Oracle SQL Developer, TOAD, PL/SQL developer

Data Modeling: Erwin

Operating System: Unix, Linux, Windows

PROFESSIONAL EXPERIENCE:

Confidential

OBIEE Technical Consultant

Responsibilities:

• Responsible for the entire migration lifecycle of OBIA 7.9 reports to OBIA 11.1.1.8
• Conduct workshops to gather new requirements of reports to be developed as part of the migration along with the existing reports.
• Worked with customers to help identify the best ways to improve the current reports/dashboards.
• To set customer expectations regarding the changes to be expected as part of the migration.
• Define migration strategy with business IT division.
• Create functional and technical design documents for the migration. Creating MD120 and MD70 documents.
• Installation and configuration of OBIA 11.1.1.8
• Customize the RPD of OBIA 11.1.1.8 to replicate the customizations of existing reports of OBIA 7.9. This included complex changes in the RPD BMM layer and modifications in the Presentation layer.
• Custom changes included creation of initialization blocks and variables, Modifying hierarchies, including custom tables in the Confidential physical and BMM layer along with the Confidential tables, new column with complex definition.
• Customize Confidential reports and dashboards to ratify new user requirements.
• Performance Tuning for the problematic reports.
• Develop different levels of Security, both data and object, set-up for the entities of the application (on both Repository file and Web catalog file)
• Define testing strategy of the migrated reports.
• Co ordinate with Business and Functional Consultants for UAT.
• Active role in Deployment of the entire OBIA suite in production
• Post Production support for any issues.
• Debugging and resolution of any issues, which came up post, go live.
• Simplify operations and reduce costs across the business
• Enable better decisions based on the quality of data;
• Enable a single view of all enterprise assets;
• Enable customer facing services and collaboration to improve the quality of service;
• Establish an enterprise-wide process for the management and reporting of capital projects; and
• Improve the quality and cost of IT services across the business

Environment: OBIA 11.1.1.8 (OBIEE 11.1.1.7.0 , ODI 11g, EBS R12, Weblogic, DAC), SQL developer, SQL, Oracle 11g

Confidential

OBIEE Technical Consultant

Responsibilities:

• Total of nearly 1500 reports to be upgraded as part of the entire project plan. Define strategy for the two-step upgrade- Siebel Analytics to OBIEE 10g and OBIEE 10g to OBIEE11g.
• Plan the upgrade and release process along with UAT with business and IT division.
• Use the Upgrade Utility of OBIEE for the initial upgrade.
• Apply existing customization on the upgraded reports, which involved changes in Report front end.
• Provide users with new functionalities and capabilities of OBIEE 11g in upgraded reports.
• Performance tuning of reports done through application of hints in OBIEE by creating indexes in the database tables.
• Usage tracking implemented for tracking the performance of reports.
• Cache management implemented as part of the upgrade.
• Instance config file customized for satisfying report requirements.
• Applying Existing Security settings to the upgraded Reports and dashboards using external tables.
• Migration of OBIEE objects (rpd and web catalog) from Dev-SIT-UAT-Prod.
• Co ordinate with business users for UAT and sign off for production go live.
• Resolve issues faced during UAT.
• Capacity and EOSL hardware issue mitigated.
• Users got the feel of latest OBIEE reporting version with advanced features.
• Increase in User satisfaction and reporting capabilities.

Environment: OBIEE 11g (11.1.1.7.140527 ), OBIEE 10g, PL/SQL,SQL developer,SQL, Oracle 11g

Confidential, Redwood City, CA

OBIEE Technical Consultant

Responsibilities:

• Conduct workshops with Business to gather requirements for custom reports to be developed.
• Apply analytical skills to high-level Business requests to determine the needs of the business and transform the requirements to technical specs.
• Define KPIs.
• Worked on Dimensional modeling by converting transactional data into the analytical data.
• Created Mockup reports and dashboards and conducted CRPs with Business.
• Worked closely with the ETL and Database Team to coordinate the Necessary Data movement.
• Suggested the creation of Indexes, Partitions for the tables.
• Created Logical Tables, Dimensions, Facts and additional Metadata in the Business Layer by using Administration tool.
• Created dimensional hierarchies as per the business needs.
• Worked extensively on BMM (Business Model and Mapping) layer to develop various business models using Star Schema and Snowflake Schema.
• Created Session (Static & Dynamic) and Repository (System and Non-system) variables.
• Built Interactive Dashboards and Reports using Tabular, Pivot and Pie Chart Reports with Drill down and drill up capabilities to enhance granularity in the Data.
• Setup the security of Dashboards to employees with respect to their responsibilities.
• Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
• Used Guided Navigation functional for specific set of dashboards.
• Used presentation variables in Prompts extensively.
• Used Level based measures (LBM) as and when required to improve performance.
• Used Multiple Logical table source (LTS) concept in order to convert Snowflakes to Star Schema in Rpd.
• Created Opaque views in Physical layer to minimize the effort at database level.
• Managed Catalog migration and RPD version control between Dev, Test, UAT and Production environments.
• Unit tested the code and documented the results.
• Involved in Production deployments and releases.
• Involved in Support activities post production.
• Report Performance issue resolved by developing a new data mart specific for reporting layer.
• Commercial teams had paid minute and performance data to assist them to manage their customers and suppliers.
• New operational and executive reports and dashboards were developed.

Environment: OBIEE 11g ( 11.1.1.7.0 ), Informatica, DAC, PL/SQL,SQL developer,SQL, Oracle 11g,HPQC,SFDC, EBS

Confidential

Module Lead

Responsibilities:

• Agile implementation of project.
• Gather report requirements from business and develop functional and technical design document and get sign off. Involved in the Data Model Designing, which includes customizing the repository according to the business requirements.
• Developed Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions (AGO and TODATE functions) based on the Requirements.
• Extensively used presentation variables to develop the logic for the reports.
• Implemented the variables in the repository.
• Developed and Debugged Dashboards /Reports with different analytics views (Pivot table, Chart, Tabular and View Selector), Alerts, Guided Navigation and Dynamic /Interactive Dashboards with drill down capabilities using global and local filters.
• Implemented Map viewer reports to view reports on the assets of the organization
• Involved in Detailed Functional Design for all reports / metrics.
• Involved in testing the reports on all data sources.
• Performed OBIEE System Administration Tasks like Configuration of system for deployment,
• Security privileges like Object level and Data level, starting and Stopping services, managing and resolving services, migration of rpd and web catalog from test to production, backing up metadata.
• The ability to report on invoices that required receipt matching but where the appropriate receipts have not been entered into EBS.
• The ability to report on all ‘states’ that an invoice has entered and when it entered those ‘states’. States have been identified in the reporting requirements
• The Sub contractor Management ha the necessary reports for management of Quotations, Comparisons of Quotations received from Suppliers, Health and safety grades of Suppliers.

Environment: OBIEE 11g (11.1.1.6.4 ), Informatica, DAC, PL/SQL,SQL developer,SQL, Oracle 11g

Confidential

Reporting Specialist

Responsibilities:

• Map the existing reports of the organization with the Confidential reports of OBIA for the Projects, Finance, Procurement and Spend modules.
• Creation of Requirements traceability matrix.
• Preparation of requirement specification document and getting sign off.
• Installation and configuration of OBIA.
• Customization of Confidential reports to meet reporting requirements.
• Data level Security implementation using VPD.
• Prepare test cases in Test Director Tool.
• Manage UAT with Business Users.
• Actively involved in Production deployment activities and post production support.
• Globally integrated procurement, project accounting, fixed assets and expense management function for better-cost control.
• Improved the timeliness, quality and granularity of business information to support decision-making
• Build industrial-strength capabilities to meet statutory and regulatory requirements
• Drive reductions in Operational Risk through institutionalized controls and processes
• Enhanced organizational agility to improve responsiveness to strategic decisions

Environment: OBIApps 7.9.6.3, Informatica, DAC, PL/SQL, SQL developer, SQL, Oracle 11g, Test Director, EBS 11i

Confidential

Product Specialist

Responsibilities:

• Worked with Business representatives for gathering the reports and dashboards requirements and to define business and functional specifications.
• Feasibility Study.
• Modeled the Logical Layer based on the Business requirements in the Business Mapping and Modeling Layer and Developed the necessary Star Schemas.
• Involved in the Metadata Designing which includes customizing like design, configure, and document logical and Physical Data Models, Presentation Layer the repository according to the business requirements
• Implemented Write Back Functionality.
• Write Complex SQL queries for fetching data for BI publisher Repots
• Developed and debugged many Dynamic / Interactive Dashboards /Reports with different Analytics Views, drill-down and drill-across capabilities, Contextual Navigation, Guided Analytics, roles and web groups, and Alerts using Presentation Services Developed and Debugged Dashboards /Reports with different analytics views (Pivot table, Chart, Tabular and View Selector), Alerts, Guided Navigation and Dynamic /Interactive Dashboards with drill down capabilities using global and local filters.
• Developed Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions (AGO and TODATE functions) based on the Requirements.
• Extensively used presentation variables to develop the logic for the reports.
• Implemented the variables in the repository.
• Implemented Security by creating roles and web groups, checks with External tables and LDAP.
• Enhance performance of Reports/Dashboards by implementing the Aggregate tables, cubes and Cache Management.
• Performance Tuning of Dashboards/Reports and made recommendations for changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL.
• Testing the repository by using various techniques for yielding the correct results or not.
• Performed the regression testing on the Subject areas, dashboards and validated the build in production environment.
• Generating Adhoc reports using Oracle Answers by applying filters and prompts and developed customized reports from analytics and used BI Publisher tool to generate the pixel perfect reports based user criteria.
• Actively involved in Production deployment activities and postproduction support.
• Monitoring of BAU activities through reports build in OBIEE and BI Publisher for Finance, Supply Chain, Stores and Merchandise.
• KPIs build helped in business decisions

Environment: BI publisher (10.1.3.4) and OBIEE (10.3.4.1) SQL developer, SQL, Oracle 11g, HPQC, Oracle Retail EDW.

Confidential, Columbus, IN

Product Specialist

Responsibilities:

• Feasibility Study.
• Design, configure, and document logical and Physical Data Models, Presentation Layer including administrator functionality.
• Built the Star Schemas based on the functionality. Worked on the different layers of the OBI Administration Tool.
• Configured metadata objects (Subject Area, Tables, and Columns) and Web Catalog Objects (Dashboard, Pages, Folders, and Reports); created hierarchies, variables, and event poll strategies in the repository.
• Creating Adhoc Views for different tables.
• Perform administrative tasks like creating Users and assigning them to access the reports based on hierarchy. Only related users are given access to these dashboards thereby giving security to the data.
• Testing the repository by using various techniques for yielding the correct results or not.
• Administering the cache parameters and implementing the cache features for improving BI server performance Implemented caching to increase performance.
• Hands on creating Variables. Worked on Oracle BI Answers to build Interactive Dashboards with drill-down capabilities.
• Created Reports using different Analytics Views. Created calculation wizards on demand
• Development of RPD like creating views in RPD level and web catalog objects.
• Hands on Deployment and migration of RPD code and web catalog in Different environments.
• Hands on IBOTS and Delivers.
• Installation of OBIEE on Windows Server 2000
• Customized Oracle BIEE 10.3.4.1 Metadata Repository (.rpd) using OBIEE Admin Tool by importing some of the required objects with integrity constraints into Physical Layer.
• Worked extensively in Oracle BI Security, Web Object Security and Data Level security.
• Administering the OBIEE Dashboards and Reports, Data Visibility, Caching and RPD file migrations
• Executed the SQL queries using TOAD
• Involved in writing SQL queries using Oracle 10g
• Actively involved in Production deployment activities and post production support.
• Achieved building of DBU DW by the different data systems
• Unified reporting strategy for the distributor business unit.

Environment: OBIEE, Informatica, SQL developer,SQL, Oracle 11g

Confidential

BI Designer and Developer

Responsibilities:

• Requirement Analysis and Feasibility Study.
• Develop Unix Shell scripts for the entire data warehouse for executing data loading scripts, file checking, auditing, and housekeeping.
• Design and develop OWB ETL Maps for data loading.
• Write complex PL/SQL codes including packages, procedures, triggers, and control scripts for sql loader.
• Executed the SQL queries using TOAD
• Involved in writing SQL queries using Oracle 10g
• Developed repository (RPD), configured metadata the Business Model Layer & Physical Data Model and Web Catalog Objects as per the reporting requirements using SA Admin and Web tool.
• Worked and developed Repository (.rpd), configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Imported Physical Tables and Defined Relations In Physical layer in SA.
• Creating hierarchies and creating new logical columns for implement the level based measures.
• Created Business Facts & Dimensions and defined Logical relation between them in BMM layer
• Testing the repository by using various techniques for yielding the correct results or not.
• Administering the cache parameters and implementing the cache features for improving SA server performance. Implemented caching to increase performance.
• Creating Users and Groups and assigning the security privileges.
• Maintained Session and Security in Siebel analytics.
• Worked on Siebel analytics Answers to build Interactive Dashboards with drill-down capabilities.
• Created Multiple Sources for a logical Table Source.
• Created Reports using different Analytics Views.
• Created calculation wizards on demand.
• Written test scripts to compare data source and report for data testing.
• Actively involved in Production deployment activities and postproduction support.
• Met Confidential regulation to provide all the CPs equivalent access the data.
• Legacy reporting system replaced by advanced Siebel Analytics reports using the new data warehouse which consolidated data from all sources to become the single source of truth.

Environment: Siebel Analytics 7.9.6.3, OWB 10g,Unix Shell Scripting, PL/SQL, SQL, Oracle 10g