SUMMARY:

• Over 8 years of experience in Analysis, Design, Development, Testing and Executing projects in SDLC and providing application support
• Experience in developing and deploying reports and in full life cycle implementations using BI Technologies - OBIEE (10g, 11g and 12c) and BI Publisher
• Experienced in gathering Business requirements for reports, analysing them and creating Requirement Specification documents, Mapping documents; data modeling of the OBIEE RPD including Physical, BMM and Presentation Layers
• Proficient in defining facts and dimensions, hierarchies and level based measures and in developing Star and SnowFlake Schemas
• Skilled at creating and configuring OBIEE Reports, Interactive Dashboards with drill-down & drill-across capabilities, Filters and Variables and Guided Navigation.
• Experience in performance tuning of Dashboards and Reports using Cache Management, Purging and seeding techniques and Usage Tracking
• Experience in working on offline, online and MUD (Multi User Development Environment) RPDs
• Experience in configuration of Data-level security using Session Variables and Object-level security by creating users roles and groups
• Configuring Security settings using Weblogic Server (Users and Groups), Oracle Enterprise Manager (Roles and Privileges), its architecture and components (OBI Server, Oracle BI Presentation Services, config files and other tools and utilities)
• Hands-on experience in developing reports using BI Publisher integrated with OBIEE; develop Data Models with multiple data sets; creating report layouts using RTF, eText and excel templates and delivering reports using Bursting and Scheduling techniques
• Tuning complex SQL queries to improve the performance of BI Publisher reports and creating tables,external tables, views and materialized views
• ETL and ELT experience using Informatica Powercenter, ODI to create and manipulate source definitions, target definitions, mappings, and transformations; knowledge in EDW and Data Modeling Concepts
• Worked on Oracle EBS(Finance), Oracle -10g,11g and 12c, SQL Server 2012, 2016 databases in designing tables, external tables, views, indexes, stored procedures, packages, functions and triggers
• Functional knowledge of Oracle EBS R12 in Finance modules
• Experience in Unix, Windows and Linux Operating Systems and in creating and modifying shell scripts and batch scripts
• Worked with Test Analysts, Business Users during QA and User Acceptance Testing to support testing efforts and to provide the and knowledge transition
• Strong debugging skills, troubleshooting and root-cause analysis and attending to customers’ issues, tickets and service requests and providing timely solutions

TECHNICAL SKILLS:

EDW Tools: OBIEE, BI Publisher, ODI, Informatica, Power BI

Databases: Oracle, Oracle EBS, SQL Server

Languages and Scripting: SQL, PL/SQL, and UNIX Shell Scripting

Web: XML, HTML

Application/Web Servers: Weblogic

Source Control: Subversion, TFS

Platforms: Windows, UNIX, Linux RedHat Enterprise Server

IDE: Toad, SQL Developer, Management Studio

WORK EXPERIENCE:

Confidential, Los Angeles, CA

Sr. BI Developer

Responsibilities:

• Interacting directly with the business users to understand the requirements, and create the functional/technical specifications(FSD/TSD) and Mapping documents
• Setting up connection pools in the RPD with various database sources like Oracle, SQL Server and excel and importing metadata to the repository
• Design and develop the Physical, Business Model and Mapping, Presentation layers in the RPD using OBIEE Administration Tool
• Converting Snowflake schemas to Star schemas and mixed Star schemas using multiple LTs and LTSs in the BMM layer
• Develop various business models by creating time dimension hierarchies, level based measures, aggregate tables and calculation based measures
• Developing customized interactive dashboards in OBIEE using drill down, guided navigation, master-detail events, prompts, filters, and variables
• Working closely with Admins during OBIEE 11g to OBIEE 12c upgrade by migrating and testing reports and dashboards
• Set up data level security for users using session variables and initialization blocks in the RPD
• Develop BI Publisher reports by creating datasets and data models to extract data from various data sources using SQL queries; improve the performance by creating temp tables, external tables, views and materialized views and packages using SQL and PL/SQL
• Developing excel, pdf and text format reports extensively on BI Publisher using RTF and etext templates and make them accessible to the users on the OBIEE dashboard by using report links; scheduling and automating reports using Bursting and job scheduler techniques in BI Publisher
• Migrated existing self-service reports and adhoc reports to Power BI
• Used Informatica Power Center to develop and customize mappings, transformations and to create workflows
• Developing shell scripts and batch scripts to automate DBMS jobs, generate and deliver reports across windows shared network drives and FTP Servers
• Providing full-lifecycle support for migration efforts from Dev to Production
• Create Adhoc reports, debug and fix production reports, participating in the QA and user acceptance testing and providing fixes

Environment: OBIEE 11.1.1.7, OBIEE 12.2.1.3, Oracle 11g/12c, SQL Server 2016, Unix, WIndows

Confidential

Responsibilities:

• Work closely with business users and analysts to understand their needs and propose ideas to achieve the objectives in a timely manner, gather and document detailed design specifications(High-Level and Low-Level)
• Setting up connection pools, configuring OBIEE Metadata Objects in the repository, creating subject areas in the RPD using Admin Tool
• Developed various OBIEE reports and dashboards with different Analytics Views- Drill-Down, Pivot Table, Chart, Column Selector, Narrative and Ticker
• Used Cache management, Seeding and Purging techniques for performance tuning of time intensive dashboards and reports
• Migrating reports from Hyperion to OBIEE 11g
• Develop complex data models for BI Publisher reports by integrating multiple data sources like Oracle and SQL Server, define parameters and list of values; set up event triggers and defining bursting logic
• Develop optimized data model design to achieve acceptable performance by creating multiple data sets; using group links; tuning views, tables and indexes for proper response time in the BI Publisher
• Worked on Informatica Power Center - Designer, Repository Manager, Workflow Manager and Workflow Monitor
• Worked on various mappings and transformations like Source Qualifier, Lookup, filter, etc
• Deploy the code in identified environment and prepare deployment documents and tickets
• Provide implementation and post implementation and production support
• Work closely with admins to increase the reports performance by setting up usage tracking

Environment: OBIEE 11.1.1.7, Oracle 10g/11g, SQL Server 2012, Informatica 9.5, Unix, Windows

Confidential, Redwood City, CA

BI Developer

Responsibilities:

• Participated in the whole life cycle of the OBIEE projects from requirement gathering phase to production implementation
• Analysed the data and developed star schemas by setting up multiple logical sources and defining logical joins
• Designed and customized Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR, FA and created the Ad-hoc report according to the client needs
• Part of Data Migration activities of Oracle R12
• Customized RPD as per user requirements and built subject areas according to the business groups
• Setting up variables, filters and prompts using OBIEE analytics to develop interactive and user - friendly dashboards, and summarized and detail reports with action links, drill down and navigation functionalities
• Perform unit and integration testing of reports and dashboards
• Develop daily, weekly and monthly reports using OBIEE that helps Operations teams identify and monitor various KPIs in application
• Migrating reports, dashboards and users/roles from OBIEE 10g to OBIEE 11g using Catalog Manager
• Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components
• Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios
• Extensively used ODI to load data from Oracle, XML files and flat files
• Used Oracle Data Integrator to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database and Oracle EBS interface tables

Environment: OBIEE 10.1.3.4, OBIEE 11.1.1.7, Oracle 10g, Oracle BI Applications (Financial analytics), ODI 11g, UNIX, Toad, WinSCP

Confidential

Responsibilities:

• Setting up system connection pools for various Oracle and SQL Server data sources and importing metadata
• Developed Reports and Dashboards in OBIEE analytics
• Set up groups, access privileges and query privileges using OBIEE web catalog
• Implemented security by creating roles and web groups, defined Object level and Data level Security
• Create schedules to seed and purge cache for cache management
• Worked on performance tuning of various OBIEE Reports / Dashboard
• Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Assist with planning and testing of application, configuration and database changes, and installation of upgrades and patches and update production support documentation

Environment: OBIEE 10.1.3.4.1 , Oracle 9i/10g

Confidential, John’s Creek, GA

Application Support Engineer

Responsibilities:

• Providing UNIX (and GUI) application/network support using BigBrother monitoring system
• Participate in the resolution of situation reviews triggered by major incidents along with documentation of post incident report
• Support Level -1 team incidents, monitor Level 2 issues/tickets opened by customers for application issues
• Support tasks to include alert monitoring for periodic jobs, opening trouble tickets, general escalation, client coordination, and vendor interactions
• Convey root cause analysis, parse logs and escalate bugs and defects to the R&D team
• Developed scripts for monitoring the daily health of the application

Environment: HTML, Java, JDBC, Oracle