SUMMARY

• Around 9 years of experience of IT experience which includes Analysis, design, development, Testing and Implementation of complete Software development life cycle and all aspects of gathering Business Requirements.
• Experience in OBIEE 11g and OBIEE 10.1.3.4.1, Siebel Analytics 7.8 which include building and configuring repository, creating and managing Oracle / Siebel Intelligent Dashboards, oracle/Answers, Oracle / Siebel Delivers and Oracle / Siebel iBots (ETL Informatica, Reporting - Siebel Analytics, Scheduling-DAC), Oracle data integration(ODI)
• Extensively worked with Administration Tool to customize the RPD in all the layers Physical, BMM and Presentation Layers.
• Worked on complex reports that require running totals, sub-totals, sub-reports, cross-tabs and conditional display of groups, fields and messages.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Extensive experience in ETL using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems.
• Expertise in Creating Dynamic Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and Drill down Properties.
• Experience in Data Modeling using Dimensional data modeling, Star schema modeling, Snow-Flake modeling, Physical and Logical data modeling.
• Extensive experience in building and administering the metadata repository and front end reports in answers/dashboards for both standalone and integrated Siebel Analytics applications
• Expertise in debugging, optimizing the Performance Tuning of Oracle BI / Siebel Analytics Repository & Dashboards / Reports and Informatica / Mappings / Workflows.
• Strong experience in setting up a Multi-User Development Environment (MUDE)
• Implementing Siebel Security Setup (groups, object and data level), LDAP, External Tables, Single sign on (SSO) etc.
• Used EBS to track the performance of the database.
• Performed relational database design and normalization, client-server development, object-oriented analysis and design.
• Highly skilled at configuring OBIEE Metadata Objects including repository, variables,interactive dashboards with Map viewer/Big Maps/Google Maps, reports and three tier OBIEE architecture.
• Expert in configuring, designing, development, implementation and using Oracle pre-build RPD’s (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.) and ETL Mappings according to business requirements. Experienced in Oracle EBS R12 Financial.
• Experience in OBIA Architecture and in depth experience in OBIA suite (Oracle Database, Informatica, DAC and OBIEE).
• Creating requests, adding filters, Creating Prompts, and creating Pivot tables using OBIEE.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Narrative View, Guided Navigation, Tabular with global and local Filters)
• Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partners’ relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers.
• Experienced in Integrating OBIEE with Hyperion Essbase 9.X and in developing RPD and reports against multidimensional databases.
• Very good at inter-personal skills, problem solving with good technical background able to complete the task very frequently and works hard.

TECHNICAL SKILLS:

OBIEE Infrastructure: OBIEE 12C, 11.1.1.7, OBIEE 11.1.1.6, OBIEE 10g

OBIEE Applications: OBIA7.9.6.3, 7.9.6.1(Financial, HR Analytics, Sales, Service, Marketing)

ETL Tools: Knowledge in Informatica Power Center9.0, Informatica Power center8.6.1, DAC 10.1.3.4.1, ODI 11g

ERP and: Applications Servers Oracle Applications 11i, R12, PeopleSoft 8.9, Oracle Web Logic Server 10.3.5

Languages: C/C++, Java, SQL, Perl, VB Script

RDBMS: DB2 UDB (8.X AND 7.X), Hyperion system 9 Essbase

Databases: Teradata, SQL server 2000, oracle 7.x/8i/9i/10g/11g

Operating Systems: Windows 10, Windows 8.x, Windows 7, Solaris 5.8, UNIX

Oracle Enterprise: Linux 5.7, Mac OS X

Software Applications: MS Word, MS Excel, MS Access, and MS Power point

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. OBIEE Developer/Admin

Responsibilities:

• Managed, developed and maintained OBIEE environments.
• Participated in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Worked on RPD Development, Oracle BI Administration, Oracle BI Answers and Agents.
• Developed Reports using OBIEE 12c Visual Analyzer and BI ASK for the Proof of Concept.
• Created Logical Tables, Logical Columns and calculated measures and metrics as per the business need.
• Identified Facts and Dimensions (with levels & hierarchy) and made required changes to the Data Mart.
• Developed and debugged many intelligence Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Used group functions like aggregate, count, sum, etc. and created separate measures within the data model and used the group variables in the reports.
• Develop in line record view with action links and develop reports with guided navigation links.
• Implemented Oracle BI security at the data and object levels and utilized variables and initialization blocks in the repository.
• Used ODI designer and implemented knowledge modules like LKM, IKM, CKM, RKM and JKM when needed.
• Monitored and documented ETL Load strategy and process to populate Dimensions and Facts.
• Customized the Oracle stored procedures to aggregate the data into different metrics based on Business Unit using PL/SQL.
• Performed extraction, Loading and Transformation of data from RDBMS tables and Flat File sources into Oracle 11g in accordance with requirements and specifications.
• Created visually compelling and actionable interactive worksheets and dashboards for the clients to analyze various KPIs.
• Worked on Migration of existing reports in Oracle EBusiness Suite (such as Purchase Orders, Deposit slips, checks etc.) to BI Publisher.
• Worked with DBA and technical team to identify and resolve performance bottlenecks and provide appropriate solution.

Environment: OBIEE 10.x/11.x/12.2.1.0.0, Oracle 11g/10g, Oracle Data Integrator (ODI)12.1.3, OBIA7.9.6.3, Essbase 9, SQL *PLUS, Toad, Informatica 9.0.1, BI Publisher, Smart View 9.3.1, Windows 7/8/10.

Confidential, Atlanta, GA

OBIEE Developer/Admin

Responsibilities:

• Managed, developed and maintained OBIEE environments.
• Upgraded to 11.1.1.7.1 new version and worked on RPD (physical, BMM, presentation)
• Worked on the latest waterfall graphs and stacked graphs.
• Implemented OBIEE Catalog Security model for all the environments from the business user’s perspectives.
• Worked on drill-down, action links, agents,view selector and column selector graphs and reports
• Given support for front-end application for BI publisher reports.
• Merge and split subject’s areas to and from the unified RPD files in each environment.
• Implementation MUDE Setup in development environment.
• Managed OBIEE to enable privileges on the catalogs based on Active-Directory based groups.
• Compute complex business reports with Oracle SQL Developer based on Clients' business needs.
• Implemented and documented steps to apply patches, fixes, upgrades and rollbacks of OBIEE releases from Oracle.
• Worked with Middleware team to design and implement various monitoring alerts.
• Assisted Middleware teams with new environment builds and ongoing production support as needed.
• Assisted development teams in fine tuning reports and RPD models, and report development.
• Deployment of RPD through Enterprise Manager (EM) and manually through UNIX servers.
• Managed various application roles through EM and worked on creating LDAP authentication through web logic administration console.
• Occasionally worked on Cognos reports and promotion of reports.

Environment: Oracle11g, OBIEE 11.1.1.6.2, 11.1.1.7.0, 11.1.1.7.1, PL/SQL, SQL*PLUS, SQL*Loader, TOAD, UNIX, Windows XP and windows 7

Confidential, Irvine, CA

Sr. OBIEE Developer/Admin

Responsibilities:

• Worked with end users to gather Business Requirements and efficiently converted the requirements to technical specifications for developing the Reports/Dashboards as defined.
• Upgraded the entire application and components from OBIEE 10.1.3.4.2 to OBIEE 11.1.1.5.0/11.1.1.6.0/11.1.1.7.1, re-designed the security, customizations and re-configured the external application.
• Used OBIEE Administration Tool for customizing and modifying the Physical, Business Model/Mapping and Presentation layers of metadata repository (. rpd).
• Categorized the Facts, Dimensions and identified the Granularity level in accordance with the need of end user before implementing the Multi-Level Based Hierarchies.
• Compared data from Hyperion Essbase with the OBIEE for data validation.
• Proficient in writing PL/SQL procedures, Functions, Packages and Database triggers.
• Created measures and Aggregated Tables to better the performance/understanding of the reports.
• Developed Performance Tuning Strategies, for optimized performance, by implementing Aggregate Navigation, Cache Management, re-organizing data, and making some changes to Reports.
• Included the custom mappings in DAC Execution plan.
• Report to the senior management with weekly and monthly project status report.
• Involved in Unit Testing, System Integration testing and Regression Testing.

Environment: OBIEE 10.x/11.x, Oracle 11g/10g, Oracle Data Integrator (ODI), SQL *PLUS, Informatica,BI Publisher, Smart View 9.3.1.

Confidential, Atlanta, GA

OBIEE Developer/Admin

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document
• Installed, Configured and developed BI Apps Financials, Supply Chain, Procurement and Spend, HR modules.
• Designed and Tested Reports in the Dashboards for the Oracle Sales Analytics & Financial Analytics modules and created the Ad-hoc report according to the Business needs.
• Worked on E-Business Suite Modules such as General Ledger, Profitability, Account Payables and Receivable, the Reports were made to analyze the past year’s financials data to help grow the company revenue & Increase profitability. The reports displayed the key Areas of Performance including the Balance sheet, Cash flow, Liquidity, GL Balance.
• Wrote PL/SQL Stored Procedures to check the status of the target database before moving records into it.
• Created numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Upgraded from OBIEE 10g to 11g.Involved in installation and configuration of OBIEE 11.1.1.6.
• Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders.

Environment: OBIEE 11g/10g, BI Apps 7.9.6.3, Web Logic Server, Informatica 9.0.1, Essbase 9, Oracle 11.2.0.2, SQL, PL/SQL, DAC 7.8.4, TOAD, SQL* Plus, UNIX, Windows XP.

Confidential, Cincinnati, OH

OBIEE Developer/Admin

Responsibilities:

• Involved in discussions with business users for gathering the requirements.
• Updated from OBIEE 10g reports to 11g reports and update all the reports to 11g environment.
• Developed many Dashboards / Reports for providing analytical information's using Oracle BI Answers and Dashboards. Created and used Oracle BI Delivers and IBots/Agents extensively.
• Creating and maintaining the RPD.
• Deploying the RPD when new reports were created.
• Creating reports in Answers/Analysis and creating and managing dashboardsUse filters, pivot tables, graphs, column selectors, view selectors to build reports
• Interacted with business to understand the sub-ledger requirements from parts of world data.
• Enhancing the present RPD with new attributes to fit the earlier project and current project.
• Building Reporting Dashboards and Reportswith differentAnalytics Views(Pivot Table, Chart, Tabular and View Selector),Alerts.
• Implemented Groups and Hierarchy Level Based security to dashboards based on Role.

Environment: OBIEE 10g, Oracle 10g, Oracle Enterprise Manager, Oracle Developer 6.0/6i, SQL*Loader, SQL*Plus,PL/SQL, Windows 2000, Autosys, UNIX (Sun Solaris), TOAD, PL/SQL Developer.

Confidential

OBIEE Developer/Admin

Responsibilities:

• Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
• Generate direct links to OBIEE reports in order to access on a mobile device
• Apply required parameters to each report based on user credentials, position and responsibility.
• Render OBIEE report on iOS and Android device
• Adapt mobile versions of reports to work on iOS 5
• Authenticate users in Ingersoll Rand LDAP and bypass VPN using proxy link so that reports can be accessed directly without logging in to VPN every time.
• Created OBIEE reports and Dashboards for the Marketing Operations organization.
• Administered NQSCONFIG.INI and Instanceconfig.xml configuration files.
• Creating KPI’s (Key Performance Indicators), Interactive Dashboards, Administering Oracle OBIEE Applications.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.

Environment: OBIEE 10.1.3.4.2, iOS 5, Android 2.3.

Confidential

OBIEE developer

Responsibilities:

• Created object in the Data Warehouse and populating data from the EBS.
• Developed and tested Store procedures, Functions and packages in PL/SQL for Data ETL.
• Involved in developing the Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks. Executed the workflows through shell scripts using pmcmd.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE/Siebel Analytics Repository.
• Created Aggregated Tables to improve the Performance of the Reports.
• Created Logical Tables, Logical Columns with Measures Calculated as per the Business need.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Effectively managed ODBC connections and imported the Physical tables and keys to the physical layer.
• Performed Unit, Integration, and Regression testing of various Dashboards / Reports and Repository.

Environment:OBIEE 10.1.3.4, Oracle BI Apps 7.9.5/7.9.6, DAC, BI Publisher, Siebel CRM, Informatica 7.x, Oracle 10g, Windows.