PROFESSIONAL SUMMARY:

• Over seven (7) years of experience in IT Industry and over (5) years’ experience in design and development of Oracle Fusion Applications using Fusion technology stack which includes Oracle Data Integrator 11g/12C, OBIEE 10g/11g and 12C, OBIA 11.1.1.8, and WebLogic server 10.3.X/12c
• Expertise in providing end - to-end business intelligence solution by configuring metadata & building Analytics Repository, dimensional modeling design, building business models, generating reports, and creating Interactive Business Intelligence Dashboards using Oracle Business Intelligence 10.x. as well as 11g
• Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP authentication setup and configuration of Multiuser Development Environment (MUD).
• Expertise in building Metadata Model (rpd), building Physical layer, Business Model and Mapping layer, Presentation layer using Oracle BI Administration tool along with development of dynamic and interactive Dashboards, Answers and IBots.
• Extensive experience in developing the load plans, packages and job scheduling. Good knowledge in installing ODI 11g, and to create Master and work repositories in different RDBMS products like Oracle11g/12c on different platforms like UNIX, Linux and windows servers
• Work experience in using all types of variables like repository, session, presentation and request variables
• Familiar in PL/SQL Procedures, Packages, Functions, Triggers and other objects.
• Extensively worked with DBAs and BAs
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Extensive experience in creating executive reports with BI Publisher
• Ability to effectively manage time, strongly motivated, enjoy team work

TECHNICAL SKILLS:

Data Model: Erwin, SQL developer, Toad, MYSQL Work beach

Oracle Apps: Oracle E-Business suite R12/11i OM, GL, AP, AR, AOL.

Databases / ETL: Oracle 10g/11g/12c, SQL Server 2008/2012. ODI 11g/12C, BICS, EssbaseReporting Tool: OBIEE (10/11g), OBIA 11.1.1.8, BI Publisher 11g/12c, Tableau 10.2

Operating Systems: Linux, UNIX, Windows 7, Windows 10, HP-UX, and Solaris.

Proficient: English Language

PROFESSIONAL EXPERIENCE:

Confidential, New Haven, CT

OBIEE / Architect & Developer

Responsibilities:

• Gathered requirements from the client, translated them into technical design documents and worked with team members.
• Created Requirements Traceability Matrix and Mapping Document to trace requirements in BI implementation.
• Identified the facts and dimensions and designed the relevant dim and fact tables.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Designed Star schema for fact dimensional tables and created alias for the dimension and fact tables when necessary.
• Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer
• Ensure availability and security of the analytic data and system
• Worked on the testing and validating the Repository in OBIEE.
• Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.
• Implemented Object Level Security for the objects like Dashboards, Reports, and Data Level Security for Region and Product dimensions using Session Variables.
• Worked on BI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
• Created Alerts and iBOTs such as Customers with Due payment at the end of the month with prompted Customer ID, Customer Details, Month and Year, Amount Due using BI scheduler, automated iBot queries to obtain reports on required time basis.
• Time for cache seeding to improve Query Performance using Caching.
• Configured Security at the repository level, Catalog level & the Application level.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
• Experience in Performance tuning at the Database and Report level by creating aggregate tables.
• Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer for OBIEE 11g manufacturing data model.
• Performed Installation and upgrade discovery of Oracle 11g to 12C Enterprise Edition, as well as Migrated Analytic RPD and web catalog from one environment to another.
• Developed and documented technical architecture, system designs, performance test results, and other technical aspects of implementations on Tableau platform

Environment: OBIEE 11g/12c, UNIX, HP-UX, Windows 7, Windows 10.

Confidential

OBIEE / DW Developer

Responsibilities:

• Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
• Install, configure, and administer the OBIEE platform.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher.
• Created OBIEE reports and Dashboards for the Marketing Operations of the Organization.
• Developed reports / Dashboards with different Analytic Views (drill-Down / dynamic, Cascading styles Sheets, Pivot Table, Charts, Column Selector, Tabular with global and local filters) using Siebel Analytics Web.
• Worked on BI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
• Created highly formatted reports using BI Publisher based on Oracle Database.
• Implemented Object Level Security for the objects like Dashboards, Reports, and Data Level Security for Region and Product dimensions using Session Variables.
• Worked on BI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
• Created Alerts and iBOTs such as Customers with Due payment at the end of the month with prompted Customer ID, Customer Details, Month and Year, Amount Due using BI scheduler, automated iBot queries to obtain reports on required time basis.
• Time for cache seeding to improve Query Performance using Caching.
• Configured Security at the repository level, Catalog level & the Application level.

Environment: Oracle 10g/11g Linux, Windows 7 and 10

Confidential

Compliance and monitoring / UAT

Responsibilities:

• Monitored Pharmacy Techs on Prior authorization process to avoid IRE s.
• Ensured approved and denied claims where processed correctly.
• Monitored Techs who failed to follow Release of standard information policies & procedures and HIPAA regulations.
• Wrote test cases for company prior authorization process.
• Worked in the testing environment during deployment.