SUMMARY

• Over 8+ years of experience in design, analysis, development, and implementation of various Reporting/Developing environments using Oracle Business Intelligence.
• Experience in Information Technology with strong background in OBIEE/Siebel Analytics, Informatica, Oracle Applications, and Data Warehousing Complete Software Development Life Cycle (SDLC) including System Requirements Collection, Architecture, Design, Coding, Development, Testing, Production Support.
• Maintenance and Enhancement in variety of technological platforms with special emphasis Client/Server, Data Warehouse and Business Intelligence applications in Windows and Unix environments.
• Development (Custom Reports which also included BI Publisher, Metadata (RPD), Informatica (ETL), DAC andDatawarehouse)
• OBIEEInstallation and Software Configuration including the BI Applications, Informatica, DAC andOBIEEDatawarehouseDB, Business Requirements Definition, Analysis, Design, Development
• Expertise in OBIEE10g/11g, 12c features like installation, security setup and Integration with Siebel and Oracle EBS Applications
• Expertise in full life cycle Business Intelligence implementations and understand all aspects of an implementation project usingOBIEE10g/11g
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers includingPhysical, Business Model and Mapping, and Presentation layer.
• Worked extensively with Oracle BI (OBIEE) applications includes meta data configuration, dashboard report development, configuring Physical Layer, Business Model, Logical Table, Dimension, Column, Logical Table Source, Logical Joins, Aggregation Rules, Dimension Hierarchies, Complex Case Expressions, Facts, Dimensions, Repository Static/Dynamic Variables, Session Variable, adding multiple sources, executing direct Database requests, Oracle BI Views (Compound Layout, Chart, Gauge, Title, Narrative, Table, Pivot Table, Funnel Chart) etc.
• Experienced in up gradation andmigration of OBIEE between dev/test/prod environments.
• Experienced indesigning customized interactive dashboardsin OBIEE using drill down, guided navigation, prompts, filters, and variables.
• 3+years of work experience in Oracle data integrator(ODI).
• Extensively worked in Designer, Knowledge Modules, and Topology Manager.
• Strong programming experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL and PL/SQL.
• Extensive work experience using different transformations for Extraction, Transformation & Loading from multiple sources using Oracle data integrator.
• Proficient in defining Key Performance Metrics (KPIs), facts, dimensions, hierarchies and developing Star and Snow Flake schemas.
• Installed, configured and administered BEA/Oracle WebLogic, ApacheHTTPandOHSservers in various environments (Dev, SIT, Pre Prod, Prod and DR)
• Performed OracleHTTPserver installation and Configured and integrated with oracle fusion components, oracle application server and WebLogic server
• Highly proficient in Extraction, Transformation and Loading (ETL) of data from various sources (such as OLTP Systems, Oracle E - Business Suite, Flat files)/data marts in to the target systems (such as OLAP Systems, Business Analytics Warehouse(BAW)) using various tools and utilities which include Informatica 8.5, Power Center and DAC.
• Expert in usingOBIEE Answers/Analyticsto create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Skilled at creating and scheduling Agents inOracle BI Deliversto provide real-time, personalized, and actionable intelligence data to subscribers.
• Experienced in developingDimensional Hierarchies,Level Based Measures,and adding multiple sources to business model objects.
• Installation & Creating repository OBIEE 12c & 11g administration Tool on Linux/windows.
• Hands on Experience with OBIEE 12c improvements, Enhancements, and advanced new features in installation, migration, analyses and dashboards, Oracle BI Mobile, Oracle BI Publisher, metadata repository development, system administration, integration and API, and localization.
• Experienced in configuring and set up ofOBIEE Security using LDAP and External Database Tablesand configuring object level and database level security.
• Experienced in configuringUsage Tracking and Multiuser Development Environment (MUDE).
• Extensively worked with DBAs and BAs towardsperformance tuningin OBIEE and Data Warehouse environment using cache management,aggregate tables, and indexes.
• Extensive experience in creating executive reports withBI Publisherintegrated with OBIEE.
• Highly skilled in Data Analysis, Data Modeling, Dimensional Modeling, and Data Warehousing.
• Experienced in creating Sessions, Workflows, Mappings, Mapplets using various available transformations in Informatica, including Router, Aggregator, and Lookup.
• Explored Structured and unstructured data with Ruby,Python
• Web scrapping usingPythonbeautiful soup package and performed transformation and Loading to target MySQL database (ETL)
• Familiar withOracle BI Apps (OBIA) 7.9.xmodules- Sales, Service, Marketing, HR, and Finance.
• Experience in creating and understandingUse Case Specifications and UML diagramsincluding Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and Class Diagrams, Data Flow Diagrams, and Flow Chart Diagram using Rational Rose and MS Visio.
• Involved in Customization for Oracle EBS Integrations withAmazonSystems (both upstream & downstream systems)
• Good experience with SQL and PLSQL or T-SQL
• hands-on programming experience with SAS, Oracle Portal, TOAD (SQL querying tool).
• Experience in Security Setup at both Object and Data levels, which involved creation of users/ groups, Access privileges, LDAP authentication setup, External table, and configuration of Multiuser Development Environment
• Expertise in Repository and Web Catalog production migrations.
• Extensive experience in Unit, Regression, Performance, Integration and User Acceptance testing methodologies.
• Experience in supporting the production system and handling day-to-day issues.
• Ability to learn and adapt to new technologies, good team player in dynamic work group environments and also self-motivated to work independently with excellent communication skills.

TECHNICAL SKILLS

BI Tools: OBIEE 11g/10g, Oracle BI Publisher, BI APPS 7.9.6.x/7.9.5,Siebel Analytics 8.x, 7.x (Administration, Answers, Interactive Dashboards, BI Publisher, Disconnected Analytics, Briefing Books, BI Delivers, Analytics Server Administration).ETL Tools Informatica 9.x/8.x, DAC

Scheduling Tools: Datawarehouse Administration Console (DAC).

ERP Applications: Oracle R12/11i (Financials (General ledger, Accounts Payable, Accounts Receivables)).

Databases: MS office, Toad, Data Loader, SQL Loader, IBM DB2, MS Access, MYSQL

Languages: Java1.6, C/C++, PL/SQL, Java script, Python, PHP, Perl, Visual Basic

Software Methodologies: Object Oriented Analysis & Design, UML, SDLC (Agile, Iterative)

Modeling Tools: RUP, MS Visio, InFlux Tool for BPE

Documentation: MD050, BR100, BR30, TE040, User manuals

Testing tools: Selenium, JIRA, QC

Web Technologies: HTML, XML,CSS, PHP

Operating Systems: UNIX, SUN Solaris, WINDOWS XP/7.0, MS DOS.

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

OBIEE DEVELOPER

Responsibilities:

• Worked in all phases of implementation life cycle of the project from requirements gathering to deployment
• Worked on upgrade version of OBIEE 11g and on patches while migrating from OBIEE 11.1.1.6 to 11.1.1.7 with the help of Certification Matrix.
• Gathered requirements and performed the GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP
• Worked with ETL developers in extracting the data from Oracle EBS, OLTP flat files and loading into DWH
• Created Time Series Measures like Year ago, Month Ago, Year-to-date measures using AGO and to Date functions to incorporate into reports
• Created Session Variables used for Data Visibility, configured security at the repository level, Catalog level & at the Application level
• Created and customized Dimension Hierarchies to achieve the drill down functionality and for creating level based measures as per Business Requirements.
• Used new version features like Master-Detail reports, Bread Crumbs, Freeze header column on multiple dashboards
• Involved in setting up Agents to run reports at scheduled time for Cache Seeding and mailing out report outputs to users
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), and used features like conditional navigation in reports
• Worked withETLTools such asInformatica Power Center/ Power Mart 8.x/7.x in creating Source/ Target definitions, building Mappings/ Mapp-lets and creating and monitoring Sessions/ Workflows
• Created interactiveUI Design(Siebel Answers, Delivers, and Dashboards) including experience in User Interface Design usingCSS, HTML, XML and Java Scripts.
• At the front-end report level worked on selection group, calculated items, master-detail column selector, view selector, action links and various kind of variables
• Experience in performance tuning at the Database level by creating aggregate tables, Bitmap indexes and tuning the Reports at BI level.
• DesignedAWSCloud Formation templates to create custom sized VPC, subnets, NAT to ensure successful deployment of Web applications and database templates.
• UtilizeAWSCLI to automate backups of ephemeral data-stores to S3 buckets, EBS and create nightly AMIs for mission critical production servers as backups.
• Experience in writing scripts inPythonto retrieve data in different formats as per the business requirement.
• Used Catalog Manager to migrate reports in Web Catalog from Instance to Instances.
• Integrated Oracle BI Presentation Services with BI Publisher and in merging BI catalog
• Experienced in configuring Usage Tracking and Multiuser Development Environment
• Have good experience on SQL, creating indexes, views, and materialized views
• Good knowledge on the Oracle packages, procedures, functions and in writing complex SQL queries
• Experienced in designing and development of various dashboards, reports utilizing various Tableau Visualizations

Environment: Oracle DB 11g, OBIEE 11.1.1.7, Oracle EBS 12, Windows, Linux, ODI 11g, Tableau, SQL Server 2012

Confidential, Danville, PA

OBIEE Report Developer

Responsibilities:

• Worked during the whole life cycle of the project from requirements gathering to deployment.
• Acted as aliaison between business users and BI teamto facilitate understanding of business requirements.
• CreatedRequirements Traceability Matrix and Mapping Documentto trace requirements in BI implementation.
• ConductedFunctional Requirements review and walk throughwith BI Architect, Designers, and Stakeholders.
• Analyzed the data and developedLogical Star Schemamodel with consultation from Data Modelers and Business Analysts.
• Developed metadata repository usingOBIEE Administration toolin Physical, Business Model and Mapping, and Presentation Layer.
• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
• Developed Time Series Objects usingAgo and To Date functionsfor time series comparisons.
• Designed and developed variousInteractive Dashboardsand reports with drilldowns, guided navigation, filters, and prompts.
• Created varioussession and repository variablesand initialized them in theInitialization Blocksto change metadata dynamically as the environment changes.
• ConfiguredBI SchedulerandOracle BI Delivers-Agentsto deliver alerts and publish updated content to subscribed users as per the schedules and requirements.
• Worked towards the Performance Tuning of Dashboards and Reports with Business Users and DBAs.
• Implementedsecuritybased onLDAP Authentication.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
• Createdsecurity settingsin OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
• IntegratedBI Publisherwith OBIEE to build reports in word, excel and doc format.
• Created various templates, reports, and prompts in BI Publisher.
• Developed test cases and performedUnit Testing and Integration Testingof the Repository and Web Catalogs.
• Provided guidance and support to end users during the implementation and in production.

Environment: OBIEE 10.1.3.4, BI Publisher 10.1.3.4, Oracle 10g, SQL, Toad 9.7, Windows XP, HTML, CSS.

Confidential

Oracle/Report Developer

Responsibilities:

• Participated in requirements gathering by meeting with the business user and base lining the details
• Identified the Data Sources (Relational, Excel etc.) and designed Facts & Dimensions with the ETL developers by looking at the data
• Designed and BuiltOBIEERPD at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create subject areas)
• Developed the Dimensions and Time Series Objects in the BMM Layer
• Worked on Security settings using Basic RPD Authentication and External Table Authentication to setup groups, access and query privileges
• Created Week Ago, and Month Ago, and Year Ago Fact Measures and Dimension attributes
• Extensively usedOBIEEDelivers and iBots
• Created strategy for refreshing reports Query caching. Optimized database indexes and run statistics process for enhancing query performance.
• Debugged reports and Dashboards visibility with respect to user's role privileges and web groups in an integrated environment
• Prepared the Test Plans and Test cases for validating the reports/dashboards
• Written many SQL statements for validating the reports and used the same in Test documents
• Performed Tuning of Dashboards/Reports by aggregate navigation, and cache management

Environment: OBIEE 11.1.1.5, Oracle DB 11g, Red Hat Linux, Informatic, DAC, SQL

Confidential

OBIEE Engineer/Report Developer

Responsibilities:

• Created and administered the Physical Layer, Business Model and Mapping Layer, Presentation Layer in a Siebel Analytics repository.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Developed custom reports/Ad-hoc queries using Siebel Answers and assigned them to application specific dashboards.
• Configure Interactive Dashboards with delivers/iBots to alert the marketing team about business changes.
• Managed day-to-day Rpd, Siebel Delivers, Scheduler and iBots.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Designed and developed new Aggregates using OWB ETL processes.
• Created mappings for initial load and daily updates using oracle warehouse builder.
• learned with strong communication and people skills and worked in a team and independently

Environment: Siebel Analytics 7.5.2, OWB 10g, Oracle 9i/10g, UNIX, SQL server, Windows Server 2008

Confidential

Oracle/Report Developer

Responsibilities:

• Managed day-to-day Rpd, Siebel Delivers, Scheduler and iBots.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Designed and BuiltOBIEERPD at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create subject areas)
• Developed the Dimensions and Time Series Objects in the BMM Layer
• Worked on Security settings using Basic RPD Authentication and External Table Authentication to setup groups, access and query privileges
• Created Week Ago, and Month Ago and Year Ago Fact Measures and Dimension attributes