Obiee Developer/analyst Resume
0/5 (Submit Your Rating)
OBJECTIVE
- Looking to join a leading organization as a BI Developer/Analyst and utilize my exceptional skills in problem - solving, analysis, communication and techniques of implementing and operation in Oracle.
SUMMARY
- Great at collaborating with peers from across functional teams and also work perfectly fine independently.
- Proficiency in OBIEE, Publisher, OBIA, administering ETL and data warehousing applications and tools.
- Expertise with installing, upgrading and configuring OBIEE tools, and security.
- Able to handle stress, fast pace environment and multitask on projects.
- Great with analytics using communication, requirement gathering, determining faults and documenting requirements.
- Exceptional record of delivering cost effective high performance technology solutions to meet challenging business needs.
- Have splendid experience in these environments: PL/SQL, SQL, ETL, Linux, Unix, BIApps, Informatica, Data stage, Teradata, DB2, Sybase, DAC, Oracle 10g & 11g, Windows 7 and 10… and more.
PROFESSIONAL EXPERIENCE
OBIEE Developer/Analyst
Confidential
Environment: OBIEE 11G, PL/SQL, SQL, Linux, Windows 7, BIApps, Informatica, Teradata, DAC
Responsibilities:
- Interacted amicably with the users and management for requirement gathering and verification through prepared documents and PowerPoint presentations. Performed great teamwork with other BI Developers, Project Managers, Database Programmers and DBAs.
- Performed Software Downloads, Installations, formatting and Configurations, ODBC connections and Loopback adaptors.
- Used time series functions to support historical time comparison analysis.
- Use the query log to verify query results and debugging issues if any.
- Experienced in configuringand performing Usage Tracking and Multiuser Development Environment (MUDE).
- Implemented security based onLDAP Authentication
- Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
- CreatedOBIEE reports & dashboardsfor MarketingOperations and Management’s decision making needs.
- Performed unit and integration testing of reports and dashboards.
- ConductedUAT sessionswith end users.
- Implemented security by creating roles and web groups.
- ImplementedFinancials, Supply Chain, HRandProcurement & Spend Analytics
- Worked in conjunction withSystem Administrators for migration, deployment and performance tuning of repositories.
- CreatedTime Series Functions - AGO, To Date and Period rolling.
- Designed and DevelopedGeneral Ledger, Payables, Receivables and Profitability Dashboards.
- DevelopedDashboard pageslikeOverview, Margins and Revenue.
- Designed and DevelopedAP Check Printing Report, Invoice Detail Report by Supplier, Payment Schedule Reporting XML/BI publisher.
- Applied cache management techniques to maintain and enhance query performance
- Developed various Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Narrative View, Dashboard Prompts and Variables.)
Oracle Business Intelligence and Oracle BI Apps Developer
Confidential
Environment: Oracle 10g, 11g; Windows;
Responsibilities:
- Teamed up great with Business Analysts in understanding the Analytical requirements and created the business model that generated reports and dashboards as needed.
- Created schemas on the database, Performed software installations and upgrades, loopback adaptors, System DNS connections and many other configurations.
- Performed connections to different data sources as business required.
- Developed Metadata repository (rpd), configured physical/logical tables/joints in the Business Model Layer & Physical Data Model and Web Catalog as per the data requirements using BI Admin tool and the Catalog Manager.
- Created Metadata Repository from scratch and modified ones that already existed to meet changing requirements, Web Catalog file, Performed Data modeling using Star/Snow Flake schema. Involved in building calculated measures for the fact tables
- Designed End to End life cycle of BI, Development, Maintenance and Documentation of various functionalities of Data Warehouses and Data Marts with expertise.
- Performed joints on facts tables and dimensions tables, did hierarchies, time series, aggregation, functions and created columns and tables with proficiency.
- Performed Data Analysis, Gap Analysis, Identification of dimensions, Facts & aggregate tables, Measures and Hierarchies (Level Based, Skipped and Ragged) with expertise.
- Developed Role-Based Dashboards for Managers and Business Heads to review the Forecasts vs. Revenues and Contact Relationship Management (CRM) to analyze the financial service center statistics for different campaigns, Customized pre-built dashboard.
- Good at deploying Performance tuning of server architecture / Dashboards / Reports and Setting up security to authenticate users and assign appropriate permissions and privileges to groups and individuals.
- Good at creating Key Performance Metrics (KPIs), graphs and different types of visualization.
- Proficient at setting up and working in a Multi User Development Environment (MUDE).
- Good at providing 24/7 Production Support.