SUMMARY

• 10 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 Data warehouse development experience using OBIEE, BI APPS, Informatica, Oracle Data Integrator ODI, BI Publisher, Oracle 10g/11g, SQL/PLSQL
• Hands on experience in the Data Modeling, Meta Data Development, BIAPPS Implementations and Testing of OBIEE/BIAPPS Functionalities
• Experience in Creating Dimensional modeling of STAR, SNOWFLAKE schemas in OLAP and customizing Fact and Dimension tables as per the user requirements.
• Good understanding of all phases of Software Development Life Cycle SDLC including Business Requirement Analysis, Development and Testing
• Expert in working with OBIEE administration tool in developing RPD with Working on Advanced concepts like aggregated tables, time series functions security privileges.
• Experience in writing and modifying Design documentation, technical requirements analysis, test results documentation and standard operating procedures SOP documentation.
• Developed many Reports / Dashboards with different Analytics Views Drill - down / Dynamics, Pivot table, Chart, Column Sector, Tabular with local and global filters using Analytics.
• Created and scheduled OBIEE IBOT's to be delivered to key business users in various function areas.
• Expertise in Cache Management, Performance tuning at report level and database level.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work effectively as a team member as well as independently.
• 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.
• Good Programming Skills using Shell Scripts and Pl/SQL Coding Procedures, Functions, Database Packages and Triggers for Automation of BIP Reports.
• Optimized solutions using various performance tuning methods SQL tuning,
• Worked on OTBI Reporting on Oracle HCM Modules
• Actively involved in business-related project milestones such as in Requirements Gathering, Data modeling logical and physical design of databases, Business Gap Analysis, Unit/Integration Testing, Data Migration, User Training, and System Maintenance

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

LEAD OBIEE/OBIA Developer

Responsibilities:

• Understanding from business users of requirements for reporting Metrics, KPIs and standard analytics, transforming these requirements into Business Intelligence solutions available to end users
• Developed Custom ETL for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 8.1, Oracle Data Integrator 11.1.1.9.
• Implementing OBIEE metadata (RPD) design and development - including design and definition of logical tables, physical sources, dimensions, columns and aggregation rules
• Report development and data extracts for using other Oracle PL/SQL development tools including BI Publisher, Oracle Reports, SQL Loader, Discoverer etc.
• Enhancing and Maintaining OOB and Custom reports for Oracle BI Apps (OBIA) - Financial Analytics, Project Analytics, HR Analytics, Procurement Analytics and Spent Analytics.
• Worked on creating OTBI Reports for HCM Cloud and Financial Analytics and spend and proc
• Administration Tasks of OBIEE and the OBIEE Web Catalog
• Assigned Object level and Data level Security
• Production Support Maintenance for closing Tickets
• Worked on OMCS and OCI Instances.
• Extensive Experience in developing BI Publisher Reports in 10G/11G
• Developed OTBI reports for HR users to view and validate employee data using existing subject areas
• Expertise in Oracle BI Answers, BI Interactive Dashboards and Oracle BI Server and Oracle BI Publisher.
• Implemented Best Practices in BI Publisher/XML Publisher.
• Worked on Online mode BI Publisher reports aswell as well as RTF templates in MS Word by connecting to BI Publisher and publish these templates for the reports to view data in BI Publisher
• Worked on Scheduling and Bursting Of BI Publisher Reports
• Worked on Conversion reports from Discover to Tableau, Power BI

Confidential, NY

OBIEE Lead Developer

Responsibilities:

• Requirement analysis, understanding client specification and develop user interface designs Customize applications to customer specific needs based on business requirements
• Work extensively on OBIEE usage tracking to track data usage.
• Performance of these functions require the use of operating systems, tools, software and languages as Seibel Analytics 7.7.1, Informatica 8.1, Oracle 9i, SSRS, OBIEE (Oracle Business Intelligence), SQL Navigator 4.5, Erwin 4.0, and ASP.Net Implemented version controlling using Team Foundation Server.
• Migration of reports and ETL code for Dev, CIT, QA and UAT Environments.
• Unit Test the Code and deploy for testing
• The incumbent creates new solutions and algorithms to manage and implement those solutions.
• Support testing team with Code fixes and defects
• Designing Database tables, Materialized views and import to OBIEE metadata layer
• For developing various Analysis and dashboards.
• Working on BI Publisher Reports to Design, develop, test and implement reports.
• Involved Answer reports, Dash boards and Filters migration from one instance to another instance. All OBIEE objects will be check in to SVN version control system
• Migrations between the Development, Quality Assurance and Production using Catalog manager and Harvest Tool to check in reports and dashboards.
• Designing Business Service Layer/Business Objects Layer for Executive Dashboard

Confidential, Houston, TX

OBIEE Developer

Responsibilities:

• Involved in requirements gathering of the various work streams by meeting with the business user, performed Gap Analysis and Data Analysis
• Developed Finance dashboards and reports which are used by CFO to identify Income Statement, Variance, and Bad Debt which evaluates Top N customers and analyze revenue trends and identify opportunity/risk.
• Deployment of rpd/webcat, creating application roles, groups, setting the configuration of Oracle BI Apps (Oracle BI ACM), parameters using Enterprise Manager/Weblogic console Catlog point
• Implemented Object Level Security by creating roles & web groups using External tables and web logic console
• Worked extensively on Oracle BI Publisher and provided the capability to download the reports in the user defined formats
• Regularly interacted with Admin team for migrating RPD and Web catalog to higher environments
• Developed Metadata Layer (RPD) for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer
• Developed Complex Reports by using the Different Views like Table, Pivot, Chart,
• Link, Narrative View, Column Selector, View Selector and Combined with Similar Requests
• OBIEE Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users
• Created updatable Briefing Books and Scheduled via Agents (iBots) and delivered to end users
• Developed Write back Method for users to Input data from reports which gets appends directly to respective data base tables.
• Implemented security by creating Application roles, checks with Oracle Identity Manager.
• Worked closely with users in resolving the bugs that were raised by them during Unit Testing of the analysis
• Extensively worked on the Documentation of the System Requirements document, User Specific document, Repository Design Document and Report Validation document

Confidential, Lee Summit MO

OBIEE Developer

Responsibilities:

• Involved in gathering requirements and prepare functional and technical document for development
• Created Low-Level Design Document (LLD) and Technical Express Project document (EPD).
• Created database objects Tables, Views, Synonyms etc.
• Implemented the different types of constraints (Primary key, foreign key, unique key etc) on tables to avoid data discrepancies and enforce the integrity of data.
• Created complex stored procedures, functions using joins for application following SQL standards.
• Created stored procedures, SQL Scripts using Dynamic SQL.
• Extracted the data from different sources such as Excel spreadsheet, flat files, SQL Server, me series, Transformed data according to business logic and loaded the data into dimension and fact tables using SSIS packages.
• Extracted the data from different sources using OPENQUERY.
• Responsible for the development of ETL Component using SSIS accordingly for Initial and Incremental Load process. Implemented the Error Logging, Package configurations and Event Handling in SSIS packages.
• Responsible for migrating dtsx Packages,rdls, database scripts from one environment to another using branch and merge option in Team Foundation Source Control.
• Responsible for providing ad hoc reporting for end users using General Ledger RPD using the Administration Tool for all the services of Physical, Business model and mapping and Presentation layers using OBIEE 11.1.1.5
• Deployment of RPD was performed in Enterprise Manager 11g to create the required Reports and Dashboards
• Web Catalog was created to store all the created Reports and Dashboards at one instance.

Confidential, Olathe, KS

OBIEE Developer

Responsibilities:

• Involved in gathering requirements and prepare functional and technical document for development.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer to customize the existing business models and also developed new models for maintenance
• Developed new Dashboards and Reports, for users through OBIEE Answers
• Involved Answer reports, Dash boards and Filters migration from one instance to another instance. All OBIEE objects will be check in to SVN version control system
• Integrated Fusion Charts As per Client requirement.
• Involved in development of star and snowflake schema.
• Responsible for creation of facts and dimension tables as per end reporting needs.
• Used Repository variables for getting dynamic results in reports based on current date and current month.
• Performed Installation of OBIEE 10.1.3.X on various Servers as per client request.
• Involved in dimensional modeling approach while extracting data from various legacy source systems.
• Gatheird requirements from business leads and prepared operational and analytical MDO50 documents.
• Worked on setting up Session and Repository (Static and Dynamic variables using various initialization blocks. Created Analytics star Schema and Snowflake Schema in Physical and Business model layer .
• Configured connection pool for database connection in the Physical layer.
• Coordinated with Admin to add new TNS entry when new subject area is brought to Repository by providing exact data Source name server credentials used for pulling data from source to Meta data layer (RPD).
• Responsible for implementing Data-level security and Object - level (Dashboard/reports) Security among Users, Groups and web - groups using various authentication methods.
• Involved in various performance tuning methods for report performance on dashboards.
• Configured IBots to deliver Analytics content based on schedule, automated IBot queries to obtain weekly reports.
• Worked on BMM layer and performed various calculations, Hierarchy modeling according to reporting requirements.
• Developed cubes using SSAS analysis services and integrated in to RPD using Multi-Dimensional option.
• Created new logical columns as per requirement and necessary calculations associated with it.
• Responsible for writing small Java Scripts which are essentially required for reporting needs.
• Implemented Go url method in dashboard reports for navigational approach from one report to another.
• Responsible for creation of development and production Support Documents.
• Installed OBIEE 11g on Windows server as per client requirement.
• Involved in creation of SSIS Reusable Packages to extract data from Multi formatted Flat files Excel XML files into UL database.
• Responsible for maintaining Dev server (OBIEE) which is installed on Unix environment which involves writing Unix scripts for stopping, starting services and Query tracking .
• Efficiently coordinate with all team members in all Scrum meetings and update status and get input from team members.