SUMMARY

• 10+ years of IT experience with full life cycle implementation of OBI Product suites including OBIEE, OBIA, BI Publisher and ETL applications.
• Involved in all the phases of Software Development Life Cycle such as Requirements Gathering, Analysis, Proof of Concept, Gap Analysis, Design, Development, Testing, Implementation, and Production Support.
• Extensive experience in providing end - to-end Business Intelligence solution with Star Schema/Snow flake Schema methods configuring metadata repository, building business models, generating reports, dashboards, Scheduled reports.
• Extensive experience in implementation of pre-built OBIA modules like Project Analytics, HR Analytics
• Strong experience in OBIEE 10g to 11g upgrade work with pre-planning, analysis, upgrade of RPD, Web catalog, BI Publisher reports, Ibots Scheduler schema and BI Publisher Scheduler schema
• Experience in development of BI Publisher Reports using various templates using BI Publisher Desktop Tool
• Expertise with OBIEE 10 & 11g Architecture, Vertical & Horizontal clustering, Performance tuning, Security, Cache Management, Aggregation and Usage Tracking
• Extensive experience in OBIEE 10g/11g, Web Logic, Informatica & DAC Administration activities as Install, Upgrade, Patching, LDAP configuration, Security setup, Migration, Scaling etc.
• Experience in Shell, Perl & Web Logic Scripting Tool languages and created scripts as needed
• Developed custom Java based tool to read web catalog and extract details such as reports, dashboards, Ibots by subject area, dashboard reports, scheduled reports, etc.
• Proficient in developing Informatica mappings, Workflows, DAC routines
• Strong experience on Oracle PL/SQL programs
• Expertise in debugging, performance tuning of OBIEE
• Experience with Agile Methodology
• Strong Analytical, Interpersonal, Problem solving, Decision making, Written and Verbal Communication skills
• Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies.
• Proven experience in ability to adapt quickly and take challenges when necessary and drive the work to completion

TECHNICAL SKILLS

Reporting Tools: Siebel Analytics 7.8x, OBIEE 10.1.3.x, OBIEE 11.1.1.x, BI Publisher, BI Apps 7.9.6.x, SSRSETL Tools Informatica Power Center 8.x/9.x

Scheduling Tool: DAC 10g, Cron jobs

Programming: SQL, PL/SQL, Shell, Perl, Java

Database: Oracle 10g/11g, Confidential SQL Server, Teradata SQL

Database Clients: TOAD, SQL Developer

Web Technologies: HTML, Java Script, XML

Operating Systems: Windows 2000/XP, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

ETL & Oracle Design Architect

Environment: Informatica, PeopleSoft, Oracle, PL/SQL, Windows Linux

Responsibilities:

• Analyze the source tables in PeopleSoft HRMS and design core data warehouse
• Create data models with star schemas corresponding to source data
• Create designed tables at various levels - Staging(STG), Validation(VLD), Target (TG)
• Create mapping documents from Source to Target
• Design ETL mappings and workflows using Informatica Power Center to load data from Peoplesoft to Stage, Validation and DW
• Unit Testing of workflows and capture test results
• Peer Review of mappings
• Create views in DW as per reporting requirements from Qlikview
• Write PL/SQL programs - Stored procedures, Packages as per Business requirements
• Troubleshoot long running views and tune the performance - Create indexes, Rewrite queries, Gather Stats
• Daily status updates to client, Attend meetings with client on Business requirements
• Co-ordination with other team members, split the daily work, helping to resolve issues

Confidential, Bentonville, AR

OBIEE Technical Lead

Environment: OBIEE 10.1.3.4.1 , OBIEE 11.1.1.7.141715 , Oracle, Teradata, Tableau, Alteryx, SQL Server, Linux, AIX, Windows

Responsibilities:

• Organized upgrade (around 10k objects) into multiple work packages.
• Analyzed OBIEE objects (such as Reports, Dashboards, iBots, BI Publisher reports) and prioritize the subject areas for upgrade in each work package
• Involved in Installation and Patching of OBIEE 11g
• Worked extensively on upgrading OBIEE RPD, Web catalog, Scheduler Schema, Publisher schema from 10g to 11g
• Created BI reports and dashboards with HTML, Java script, security on reports, dashboards, and subject areas
• Created BI Publisher reports with new RTF template using BI Analysis data source
• Followed Change Management process and part of Change Council
• Co-ordinated with 30-member offshore team on validating and fixing the upgraded reports & dashboards
• Client interaction on daily basis about the project activities and sent weekly status reports to client
• Converted existing 10g monitoring scripts (watchdog, BI services restart, server monitoring etc) to 11g and created new scripts (rpd roll script, weblogic services restart) for 11g
• Conducted working sessions with each subject area business users on 11g product behavior post upgrade
• Conducted UAT sessions with Business users on upgraded objects and received sign offs with ZERO defects
• Created PL/SQL scripts as needed
• Migrated upgraded reports to TEST, UAT and Prod environments using change management process
• Go Live activities and post go live support
• Supported Tableau and Alteryx environments
• Performed BI Administration Activities - setting up Usage Tracking, Weblogic upgrade, applying patches, monitoring ibots & publisher jobs, RPD & Webcat migration etc
• Worked on Weblogic Admin activities - Weblogic upgrade from 10.3.5 to 10.3.6, Security setup, Domain configuration, Security migration, created WLST scripts
• Fixed critical issues encountered with BI publisher and OBIEE

Confidential, Bentonville, AR

OBIEE Lead

Environment: OBIEE 10g, Teradata, Unix

Responsibilities:

• Worked closely with client to understand business functionality
• Requirement gathering from Client, analyze, and provide the efforts estimates on reporting requirements
• Worked on Agile Model
• Attended daily scrum calls, Attended Story time and planned the work for each sprint
• Worked extensively on Answers to create the reports as per the Client Requirements.
• Customized OBIEE RPD with physical objects import from Teradata, creating logical facts and dimensions, define joins, expose into Subject areas
• Customized OBI reports and dashboards with union reports, graphs, links
• Provided the knowledge transition to the team

Confidential

OBIA Lead

Environment: OBIEE 11.1.1.7, Oracle 11g, Informatica 9.1, BI Apps 7.9.6 (Financial Analytics), DAC

Responsibilities:

• Analyzed Business requirements and prepared design documents
• Customized and developed OBI repository
• Implemented changes to the Star Schemas and in all the 3 layers of the RPD (Physical, Business Model and Mapping Layer and Presentation Layer)
• Designed the ETL processes using Informatica to load data from Flat files to target Oracle Data Warehouse database.
• Developed and supported the extraction, transformation, and load process (ETL) for a Data Warehouse from legacy systems
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator, Stored Procedure etc.
• Created sessions and workflow for designed mappings.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Created tasks like Decision and email tasks, Subject areas, and Execution plan in DAC.
• Used Workflow Manager for Creating Sessions and scheduling them to run at specified time with required frequency.
• Used various cache management techniques for performance
• Setup project specific security - Application centric application roles, Project centric application roles, inheritance between roles, security on RPD, catalog objects
• Configured Usage Tracking & customized management reports to analyze the users executing reports on the environment
• Co-ordinated with team in assigning tasks and daily client interaction on the project status
• Conducted trainings with in organization

Confidential

OBIEE Developer & Administrator

Environment: OBIEE 10.1.3.4.1 /2, 11.1.1.3/5/7 , DAC 10g, BI Apps 7.9.6.2/3 (HR Analytics), Informatica 8.6.1, 9.0.1, ODI, Oracle 10g/11g, Linux, Windows Server 2003

Responsibilities:

• Worked on OBIEE Development & Administration
• Built RPD, designed OBIEE 11g reports and dashboards to assess the response to RFCs and SRs
• Applied OBIEE application config level changes on the instances
• Performed OBIEE code promotions - DB scripts, OBIEE (RPD, Web catalog), DAC and Informatica components
• Applied patches to Oracle DB, Siebel, OBIEE, DAC and Informatica on both Linux and Windows platforms
• Created automation scripts for OBIEE 11g services stop, start and restart, 11g In-place upgrade
• Troubleshooting issues at Database, Siebel, OBIEE & ETL failures at different levels
• Configured OBIEE scheduler (10g/11g) and DAC scheduler
• Implemented Vertical scaling
• Setup project specific security - Application centric application roles, Project centric application roles, inheritance between roles, security on RPD, catalog objects
• Performed OBIEE code promotions in all environments
• Debugging & Troubleshooting OBIEE platform issues - Access issues, privileges, performance, configuration

Confidential

OBIEE Developer

Environment: OBIEE 11.1.1.6, DAC 10g, OBIA 7.9.6.2 (Procurement & Spend Analytics), Informatica 8.6.1, Oracle 11g, Windows Server 2003

Responsibilities:

• Interacted with Onsite team for reporting requirements analysis and to define business and functional specifications.
• Created Requirements Traceability Matrix and Mapping Document to trace requirements in BI implementation
• Analyzed BI requirements and designed data modeling with Star and Snowflake schemas
• Created Mappings, Sessions and Workflows using Informatica PowerCenter to load data from OLTP to OLAP
• Involved in DAC configuration for Procurement and Spend
• Executed, monitored and Scheduled execution plans in DAC Client
• Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.
• Created new dimensional Hierarchies, dimensional level content, calculated measures, aggregate mappings
• Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts
• 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.
• Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.

Confidential

OBIEE Developer

Environment: OBIEE 10.1.3.4.2 , DAC 10g, BI Apps 7.9.6.2, Informatica 8.6.1, Oracle 11g, Unix

Responsibilities:

• Analysis of Business requirements
• Implementation of the Marketing Analytics
• Created Segments, Segment Trees and List formats
• Designed Informatica mappings using various transformations and workflows
• Designed and Monitored DAC routines to execute ETL workflows to load the data from OLTP to OLAP.
• Customized star schemas and Business Metrics in RPD as per customer requirements
• Unit tested reports, dashboards.

Confidential

SSRS Developer

Environment: SSRS, SQL Server

Responsibilities:

• Analysis of the business requirements provided by the customer.
• Access code mining
• Preparation of process flow documents on the processes running in the current application.
• Preparation of report specification documents for the existing and new reports in different applications
• Design of reports using SSRS tool.

Confidential

OBIEE Developer

Environment: OBIEE 10g

Responsibilities:

• Analysis of warranty analytics requirements provided by the Oracle customers.
• Preparation of Bus Matrix.
• Design of Star schemas with the necessary dimensions and facts as per the business requirements to store the business attributes and measures
• Preparation of High Level Design document (HLD) for the provided warranty metrics
• Preparation of OLAP Data Model and mapping spread sheet for OLTP to OLAP mapping

Confidential

OBIEE Developer

Environment: OBIEE 10.1.3.3, DAC 10g, Informatica 8.1, Oracle 10g, Windows Server 2003

Responsibilities:

• Analysis of Business requirements
• Prepared High level and Low Level Technical Design documents
• Involved in Data modeling
• Designed and developed Mapplets and Mappings using various Transformations (Source qualifier, Expression, Look up, Filter, Update Strategy) in Informatica Power Center Designer
• Created workflows, sessions in Informatica Workflow manager for the mappings developed in Informatica Designer.
• Created DAC tasks, Subject Areas, Execution Plan, assembled subject areas and built Execution plan for executing ETL.
• Developed Oracle BI Metadata repository using BI Administration tool.
• Created of Business Facts & Dimensions and defining Logical joins,in BMM layer
• Defined Dimensional Hierarchies, levels for Drill down capability and implemented Business Logic by creating level based measures
• Developed measure for time comparison using time functions, ToDate and Ago
• Generated reports with different Analytics views (Compound, Table, Pivot Table, Chart, Column selector) as per business requirement
• Created dashboards with report views, prompts, links as per business requirements.
• Unit tested the reports, dashboard to verify if business functionality is achieved

Confidential

Siebel Analytics Developer & Tester

Environment: Siebel Analytics 7.8, DAC, Informatica 7.4, SQL Server 2005, Windows Server 2003

Responsibilities:

• Customized Physical, Business Model and Mapping and Presentation layer of Repository using Siebel Analytics Administration tool
• Imported physical schema from OLAP DB & defined physical joins between tables
• Created Logical tables (dimensions and facts), Logical table sources, columns and complex joins
• Involved in creating dimensional hierarchy for drill downs and level based measures.
• Created new subject areas with defined folder structure, generated adhoc reports.
• Involved in Loading data from Siebel transactional database to Analytical data ware house using ETL tool (Informatica)
• Developed Informatica SDE and SIL mapplets/mappings using Source Qualifier, Expression, Lookup, Filter, Sequence Generator etc transformations
• Developed of Informatica Workflows for Full and Incremental load
• Customized DAC to execute Informatica Workflows
• Executed & monitored execution plans to ensure proper data loading
• Troubleshoot ETL task failures
• Unit and System testing of ETL, OBIEE reports