SUMMARY

• 11+ years of experience in gathering business requirements, performing gap analysis, design, data modeling, development, testing, implementations, and documentation of various functionalities of data warehouse / data marts and business intelligence using Ralph Kimball and Bill Inmon Methodology.
• Extensive Business Intelligence experience using Oracle Business Intelligence and Siebel Analytics.
• In depth noledge of Software Development Life Cycle (SDLC) with thorough understanding of various phases which includes Requirements Analysis, Design, Development and Testing.
• Expertise in developing Oracle BI & Siebel Analytics Repository (.rpd) at three layers (Physical, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill - down capabilities using global & local Filters, Security Setup (groups, access / query privileges), LDAP, External Tables, configuring Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
• Expertise in Business Model development with Dimensions, Hierarchies, Level Based Measures, Aggregation Rules, Time Series, and Caching.
• In depth noledge of Product Life Cycle (PLC) - Introduction, Growth, Maturity and Decline and Software Development Life Cycle (SDLC) with thorough understanding of various phases like Requirements Analysis, Design, Development and Testing using RUP, AGILE and WATERFALL.
• Extensive experience in building Interactive Dashboards with drill-down & drill-through capabilities using global & local Filters, Contextual Navigation, Guided Analytics, Business Rules with User Identity & Roles, Profiles & Personalization.
• Extensive Experience in Data Warehousing development using ETL tools such as Informatica Power Center / Power Mart 9.x/ 8.x, ODI 11G, 12CR1.
• Very strong in developing Informatica Mappings / Mapplets using various Transformations (Filter, Expressions, Router, Aggregative, Lookup, Router, Update Strategy) for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Expertise in Performance Tuning, Debugging, and Optimizing Analytics Dashboards / Reports and Data Warehouse database.
• Good in Oracle PL/SQL (Packages, Procedures, Functions, Triggers, etc).
• Experience in working with various operating systems like IBM AIX, HP UNIX, Solaris, and WindowsNT/2000.
• Business Analysis experience with excellent communication & interpersonal skills and broad understanding of business operations and requirements.
• Good Team player and an individual contributor with steep learning curve and good interpersonal skills.

TECHNICAL SKILLS

• OBI Applications (11.1.1.x 7.9.x)
• OBIEE (10g 11g 12C)
• OTBI
• Siebel Analytics 7.x
• BI Publisher
• Tableau
• DOMO
• Cognos
• Microstrategy
• QlikView
• Oracle Data Integrator (11G/12CR1)
• Informatica 5.x/6.x 7.x 8.x
• Oracle Enterprise Data Quality (OEDQ)
• Oracle Application Express (APEX)
• Data warehouse Application Console
• Oracle 8i/9i/10g/11g/12C
• SQL*Plus 8.x/9.x
• PL/SQL 8.x/9.x
• C
• C++
• R-Programming
• Windows /NT/2000/XP
• Linux
• Unix
• Oracle EBS
• Oracle RMS
• Guidewire Claim Center
• Peoplesoft
• Business Requirements Gathering
• Functional Requirements Gathering
• Design Documents
• RUP
• AGILE
• GAP analysis
• User Interviews
• JAD
• Process Flow & Data Flow Diagrams
• MS Project
• Microsoft Office
• SDLC Methodologies

PROFESSIONAL EXPERIENCE

Confidential, Glendale, CA

BI Solution Lead

Responsibilities:

• Upgrade Planning, Installations, Documentation of Environment Upgrade from OBIEE 11G to 12C.
• Infrastructure setup and Server Capacity planning.
• Migrating OBIEE 11.1.1.9.0 to 12.2.1 using BI Migration tool (Jar file).
• Designed Architectural frameworks for OBIEE 12C Applications to meet Business needs.
• Gathering teh data from existing Source Systems and Developing complex Financial Reports for teh organizational Decision making process.
• Integrated Oracle APEX with OBIEE 11G and Apex 4.2 with OBIEE 12C.

Environment: Guidewire Claim Center 5 & 8, OBIEE 12C/ 11.1.1.7.1 /11.1.1.9.0, ODI 11.1.1.7.0 & 12CR1, Oracle Web Center, LaserFische, Apollo(Custom Application), Oracle DB 11g & 12C, Oracle SQL Developer, Linux RHEL6, Win 2007 Server, Oracle EDQ, Oracle APEX

Confidential, Irving, Tx

Sr Business Intelligence Specialist

Responsibilities:

• Report Conversion from Excel to BI Publisher.
• Training of Client Resources in advanced BI Publisher report techniques.
• Analysis of potential for Report conversions.
• Creation of intensely complex BI Publisher Reports with DataModels contain divergent Retail Data Sources like Oracle RMS, ReSA, RPM, RMS Extensions.
• Metadata BI Data Warehouse analysis for Data Sources and performance gains.
• Managing deployments through standard Dev/Test/Production process.
• Creation of Analyses and Dashboards in OBIEE using both Answers and BI Publisher as sources.
• Creation of parameter driven Dashboards, Templated (Multiple formats) and BI Publisher Reports.
• Performance tuning of queries.
• Installed and upgraded existing OBIEE 11.1.1.7.x environment to OBIEE 12C.
• Unit tested and upgraded to latest OBIEE 12C environment post installation and configuration.

Environment: Oracle RMS, ReSA, RPM, IBM PIM, OBIEE 11.1.1.7.1, OBIEE 12C, Informatica 9.x, Oracle BIP, Oracle DB, AIX

Confidential, Chicago, IL

Sr Business Intelligence Specialist

Responsibilities:

• Analyze and Evaluate teh MD-50’s (BRD) written by teh Analysts and verify teh compatibility of requirements with OBIEE Reporting.
• Develop Complex Gaming Reports with OBIEE tool using different features available in teh OBIEE.
• Modeled and Developed OBIEE Real Time Reports by connecting to teh Oracle EBS source data.
• Developed multiple reports in teh Oracle BI Apps OOTB areas of Finance, Projects, HCM.
• Responsible for Unit Testing teh Reports and migrating across multiple environments.
• Written MD-70’s (Technical Design) documents for teh reports which are worked on.
• Worked on adding additional columns to teh SDE, SIL custom mappings in ODI development area.
• Responsible for maintaining and implementing OBI Best practices across teh environment.
• Conducted Architectural Reviews of Reports, Dashboards, ODI Custom Columns developed by other developers in teh team to see if teh code adheres to teh best practices suggested by Oracle.
• Data Modeling teh Custom HR subject area needed for HR Analytics.
• Customized OBIA Repository for Financial Analytics, Supply Chain and HR Analytics.
• Customized teh HCM Data Model for HR Analytics by modifying teh out of teh box repository for HR Analytics and adding custom facts and metrics.
• Designed and developed numerous reports and dashboards for Finance, Supply Chain and HR Analytics.
• Customized OOTB OBIA packages for ETL using ODI studio based on teh business requirements.
• Implemented EIS Custom Reporting of HR, Finance in teh RPD and in teh BI Catalog.
• Installed and Configured ODI application across teh environment with standalone agents for Custom Data projects.
• Created ODI Packages, Jobs of various complexities and automated process data flow.
• Configured and managed ODI BI Apps environment through teh BIACM and FSM Utilities.
• Created Dashboards and Visualizations for Business Reports using Reporting tools like Tableau & OBIEE.

Environment: Oracle BI Apps (11.1.1.8.1 ), OBIEE ( 11.1.1.7.1 ), OTBI, Informatica 9.x, ODI 11G, Oracle DB 11G, Oracle EBS R12, Oracle RMS, EIS Custom Reporting. RHEL, Tableau

Confidential, Miami, FL

BI Solution Architect

Responsibilities:

• Analysis of specifications provided by Confidential and understanding Business to best fit teh Data for reporting.
• Business process understanding for Finance, Operations, Inventory tracks.
• Involved in designing of Conversion Implementation Strategy for Finance, Operations, Inventory data.
• Performed extensive Requirement Analysis including Data analysis and GAP Analysis.
• Planned alternative or best methods to utilize resources and develop a best possible BI Solution.
• Performed extensive System analysis to design data model to halp load data from multiple sources.
• Designed and Modified ETL (Informatica) Mappings to load teh data from source to target analytics system.
• Gathered Requirements to Implement Oracle BI Security in teh OBIEE RPD and Answers.
• Developed OBIEE RPD, Dashboards and Reports to fulfill teh Business Requirements of Finance, Operations & Inventory.
• Worked on Code Migration between Dev, UAT, PROD env’s.
• Performed Unit Testing & Integration Testing to verify Report functionality and Data accuracy.
• Conducted Workshops to increase adoption of dashboards and Reports dat halps user to use teh reports to analyze teh data rather TEMPthan excel based reporting.
• Conducted User Training for Dashboards and Reports to halp Business improve teh metrics dat halp them drive Critical Decisions.

Environment: OBIEE 11G, BI Apps 7.9.6, Informatica 9.x, Oracle DB, Linux, Oracle APEX, Oracle EBS R12

Confidential, Brea, CA

OEDQ Specialist

Responsibilities:

• Installed and configured Oracle Enterprise Data Quality 11.1.1.7.3 with Weblogic 10.3.6 App Server and Oracle DB.
• Developed custom match rules in EDQ to satisfy teh business requirements.
• Worked with Data Profiling, Cleansing and Parsing of data using EDQ.
• Developed reusable data cleansing jobs in EDQ for MDM, BI projects.
• Exported results (Title Name, email address and phone number) to excel, for those customers whose address or zip code attribute is not valid.
• Developed processor to obtain teh metrics, to issue business critical communication to all customers via their preferred contact method.
• Customers with valid physical address, Customers with all communication methods available, Customers without valid physical address, but with valid email address or telephone number.
• Finally with all teh above EDQ features, built a Marketing Datawarehouse with Oracle EBS, Sales Force (SFDC), SAP as data sources and DOMO as a reporting tool.

Environment: Oracle EDQ 11.1.1.7.3, Weblogic 10.3.6, Oracle DB 11G, OBIEE 11G, DOMO, Oracle EBS, SFDC, SAP MM

Confidential, Glendale, CA

BI Solution Lead

Responsibilities:

• Interacted with Business Analysts and Line of Business owners for gathering teh Business requirements and report/ dashboards requirements.
• Designed teh Business Analytics Warehouse Data Model for teh source data.
• Architected teh analysis, requirements, Infrastructure design, Report design, development, implementation, documentation and maintenance of OBIEE solution.
• Implemented Oracle Business Intelligence (OBIEE 11.1.1.7.1 ) solution for Confidential Line of Business.
• Articulated tangible requirements in teh form of features, stories & business rules.
• Responsible for teh software work products such as Technical and Functional Business requirement documents.
• Collaborated with cross-functional teams to develop new features, enhancements.
• Managed, gathered and analyzed source data to build a robust BI Solution for Confidential LOB.
• Designed and Developed ODI Mappings or Interfaces to populate teh De-Normalized data in to Datawarehouse, source to target data validation, Qualitative & Quantitative analysis of interfaces and Data Load strategies.
• Configured repository on all teh three layers (Physical Layer, BMM Layer & Presentation Layer).
• Developed Interactive Dashboards with drill-down capabilities, charts and table reports using global and local filters.
• Organized testing schedules. Managed execution and sign-off tests and also played an active role in product rollouts.
• Developed Performance tuning strategies in OBIEE, worked along with teh DBA to optimize teh performance of Database.
• Installed and Configured teh ODI application across teh environment with Agent configuration to load teh data from Source to Target.
• Created ODI Packages, Jobs of various complexities and automated process data flow.
• Configured and Managed ODI environment through teh ODI Client Designer Studio.
• Involved and Managed all teh Post Production support activities to halp resolve issues raised by Business Users.
• Maintained Master data by using Oracle EDQ to profile teh data.
• Developed reusable Data Cleansing jobs in EDQ for BI projects.

Environment: Guidewire Claim Center 5 & 8, OBIEE 11.1.1.7.1, ODIEE 11.1.1.7.0 & 12CR1, Oracle Web Center, LaserFische, Apollo(Custom Application), Oracle DB 11g & 12C, Oracle SQL Developer, Linux RHEL 6, Win 2007 Server, Oracle EDQ

Confidential, SFO, CA

Architect/Lead Oracle BI Developer

Responsibilities:

• Involved in analysis and gathering of requirements of theBASELreporting by meeting with teh business user and base lining teh details dat define business and functional specifications.
• Involved in Designing teh Technical Development Document andBI specifications dat fit inOBIEEdevelopment standards & best practices.
• Involved in designingstar schemaby determining teh granularity and figuring out teh facts and dimensions by working closely with database team.
• Designedsummary tablesfor OBIEE and maintained thedata scripts using SQL by working closely with database team.
• Involved ininstallation and configurationof Oracle BIEE 11.1.1.6.0 in teh Windows 2008 environment.
• Setup security using LDAP forautanticationanddesigned groups to setupauthorization. Createdinitialization blocksfor autantication setup.
• UpgradedOBIEE 10grepository and catalog usingOBIEE 11gUpgrade Assistant tool and customized OBIEE11g repository.
• Developed metadata repository (RPD) in three layers (Physical, BMM and Presentation Layer), configured metadata objects and web catalog objects as per teh client and reporting requirements usingOBIEE AdministrationTool.
• Developed metadata repository (RPD) in three layers (Physical, BMM and Presentation Layer) usingHyperion Essbase 11.1.2.1as source and implemented incremental loads for Hyperion Essbase cubes.
• Created dimensionalhierarchiesfor drill downand created complex measures and variablesin teh repository.
• In detail analysis of teh requirements and provide teh best possible solution on reports/dashboards using wide range of different analytic views(drill-down/dynamic, cascading style sheets, pivot table, chart, column selector, tabular with global and local filters and prompts) dat are part ofOBIEE Answers/Dashboard.
• DevelopedBASEL Management Reportsfor analyzing teh capital requirements.
• Developed interface similar toHyperion Essbase Excel AddInfeatures In OBIEE for users.
• Developed reports in OBIEE forHyperion Essbase Cubes validation. Developed dashboard with reports from source system(Oracle 11g) and Hyperion Essbase Cubes to compare teh results.
• Implemented security atdata level and object leveldepending on groups.
• ConfiguredOBIEE iBots/Agentsto deliver analytics content based upon schedule to higher management.
• Customized teh OBIEE products (Answers Login Page, Banners, CSS files, etc.) forlook and feel (style and skins)as per company standard specifications.
• Enhanced performance in generating Dashboards to users bymanaging cache.
• ImplementedPerformance tuningof time taking reports in answers and suggested changes todatabaseby implementing thematerialized views,aggregate tables, etc.,
• ImplementedPresentation Hierarchies,Charting, Conditional Formatting, Filter, Sort, Hide, Formulas and Functions and Rich text formatting.
• Configured teh OBIEE environment for migration between DEV box, QAT box and Prod box.
• Migratedmetadata repository (RPD) to different environments likeDev,QAand Productionof Repository, Dashboard Reports.
• Developedreports in OBIEE 11G using advanced techniques like Master detail eventsand Presentation hierarchies.
• Debugged report issues by analyzing teh executedSQL queriesusing Log files(used TOAD to run these SQL queries)
• Implemented different test cases by performing unit, integration, and regressiontestingto validate report functionality.
• Resolved teh issues in different phases of teh project and solved teh production problems by interacting closely with users, developers and administrators and by reviewing design changes made to production systems and made corresponding changes to OBIEE repository.

Confidential, Portland, OR

Sr Oracle BI Applications Developer

Responsibilities:

• TEMPEffectively interacted with teh end users for requirement gathering and defined requirement specifications document by access and retrieval of financial and personnel data from one single source .
• Identified & Created Facts, Dimensions, and Hierarchies of teh business model.
• Modeling and Mapping layerand created customized user views in thePresentation layer.
• CreatedCatalog Groupsand setpermissionsfor items in thepresentation catalogandprivileges andrightsto users and groups.
• Designed and Tested Reports in theDashboardsfor theOracle Financial Analyticsmodules like GL, AP, ARand created teh Ad-hocreport according to teh client needs.
• Designed and Tested Reports in theDashboardsfor theOracle Procurement & Spend Analyticsand Custom Inventory Analytics and created teh Ad-hocreport according to teh client needs.
• ConfiguredInteractive Dashboardwithdrill-downcapabilities usingglobalandlocal Filters, Metadata ObjectsandWeb Catalog Objects.
• AppliedCascading PromptsandMulti Level PromptsonDashboards.
• Identifiedissues,performancebottlenecks, and optimized teh Business IntelligenceDashboardsand Reports.
• Developed different kinds ofreports (pivots, charts, tabular)usingglobalandlocal Filters.
• WroteCustom SQL Codesfor teh reports.
• AppliedOptimization Techniquesfor teh better performance of teh reports.
• ImplementedSecurityby autanticating against theLDAPandexternal table in OBIEE 11g..
• Implemented Secure Socket Layer(SSL) for teh LDAP ADSI Autantication process.
• Trained End Users and Pilot Users aboutOBIEE Tools.

Environment: OBIEE 10g, 11g, Informatica 9.x, Peoplesoft, DAC, Oracle DB 11g, Linux, Windows

Confidential, Redwood Shores, CA

Oracle BI Architect

Responsibilities:

• Assess teh BI platform and define a technology road map to ensure dat teh Enterprise Data Warehouse and Business Intelligence follow best practices
• Design architecture for BI 11g platform
• Involve in GAP analysis and Data modeling sessions with teh team
• Design repository, reports and strategy for Ad hoc reporting requirements
• Install and Upgrade OBIEE platform from 10g to 11g.
• Configure LDAP for BI 11g platform using ADSI, Object Level Security, caching mechanism, usage tracking and deploy customized user Interface for BI Analysis
• Work and coordinate with teh team in an Agile-like approach.
• Responsible for teh Data Model design(Star Schema) for Confidential Analytics product(V 8.5).
• Architecture d Data Model, design docs, installation and configuration of OBIEE 11g.
• Solely responsible for architecture of OBIEE solution to migrate teh legacy Microstrategy reports(8.x) in to OBIEE reporting tool.
• Analysis and design of 200+ reports for OBIEE (Oracle Business Intelligence Enterprise Edition).
• Planning, analysis, design, implementation and testing responsibilities.
• Iterative development of OBIEE dashboards, Answers requests, charts, pivot table layouts, dashboard prompts.
• Design of ODIEE interfaces and Dimensions from teh source staging environments.
• Built ODIEE interfaces for teh associated Fact tables and Metric calculations in teh ELT tool.
• Iterative development of dashboards, Answers requests, charts, pivot table layouts, dashboard prompts.
• Collaborated with end-users and stakeholders to bring form and clarity to a multitude of data sources which enabled data to be displayed in a meaningful analytic way.
• Built OBIEE custom CSS styles and skins.

Environment: OBIEE 11G(11.1.1.5,11.1.1.6), ODIEE 11g, Micro strategy, Tortoise SVN, Oracle DB 11g, Mozilla Firebug, Teradata IDW

Confidential, Sunnyvale, CA

Business Intelligence Analyst

Responsibilities:

• Solely responsible for an OBIEE solution to analyze various Global Support subject areas.
• Iterative design and development of Dashboards, Answers requests, charts, pivot table layouts, dashboard prompts.
• Worked with teh business partners to understand teh As-Is process and document teh same in teh Business Requirements specifications.·
• Understood teh short comings of teh legacy application and created a Gap Analysis document.
• Created Functional Specifications documents for teh Technical and Cross-Functional to make necessary changes to teh Data Model.
• Created Wireframes and mockups to better understand teh User Interface teh Business partners are looking for.
• Coordinated with teh Application Architecture team for teh customization of OBIEE Metadata Repository (.rpd) model to create new columns dat would be available to teh business users and understand teh impacts of these customizations on teh current Data Model. ·
• Created complex reports and demonstrated teh same to teh business.
• Maintained teh repository by coordinating with teh Application Architecture team while coordinating weekly builds to include any ad hoc changes requested by teh user.
• Created Test plans and Test cases in HPQC and tested teh functionality as well as teh data being populated in teh reports.
• Built test cases and tested teh Reports/ Dashboards by comparing teh SQL Output on teh Data Warehouse to teh values in teh Reports/Dashboards.
• Created a consistent responsibilities matrix documenting teh underlying security, responsibilities and privileges across teh organization. ·
• Created comprehensive and easy-to-understand documentation and updated teh SharePoint to reflect teh same.
• Capability to guide and train less experienced developers, architects and users.
• Good data warehouse experience (normalized and dimensional models).
• Strong noledge of technology footprint noledge (DB2, Oracle, Unix AIX etc).
• Considerable experience working as a lead analyst on large and complex projects.
• Able to handle various projects at teh same time, institute priorities, work in given time period and complete deadlines.

Environment: OBIEE 11G, OBIEE 10.1.3.4.1, Cognos 8,Oracle 11G,SAP CRM, ELIXIR, HPQC,TOAD.

Confidential, Pittsburg, PA

Sr Oracle Business Intelligence Architect

Responsibilities:

• Gathering, Analyzing and identifying teh Gap of Business Report Requirements.
• Gathered business user’s reporting requirements and prepared teh requirement specifications document and High Level Conceptual Document.
• Also prepared report mockups to replicate teh requirements for teh developers.
• Performed Dimension modeling, Identify Fact tables & Measures, Identify Dimension Tables to store business attributes, Identify Aggregate tables & their definitions.
• Analyze, Design and Developed Analytical Metadata repository (.rpd) as per teh data requirements dat consists of physical layer, multiple business model/layers with dimensions & time series objects, presentation layers with presentation catalogs, External table security using session variables etc…
• Created repository, session variables, and initialization blocks for security and dynamic time periods.
• Set Aggregate Navigation for all aggregate fact tables in teh BMM layer.
• Completely developed Sales, Operations and Secondary Marketing reports and Dashboards.
• Analyze, Design and Developed OBIEE Metadata repository (.rpd) consists of physical layer, multiple business model / layers with aggregates, dimensions & time series objects, presentation layer with catalogs & folders, external table security using session variables, test and validate teh model using OBIEE Admin tool.
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Set up OBIEE Tool Level security for specific users who can access a part of teh tool, like just answers, No Dashboard prompts Etc.
• OBIEE reports performance improved by tuning long running SQL. Created indexes, created materialized views, created Aggregate Tables, Configuring Nqsconfig.ini parameters etc.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters).
• Worked extensively on teh Cascading Style Sheets(CSS) in teh reporting environment.
• Worked extensively with teh Business Users to fix issues like Dynamic scaling, CSS(Cascading Style Sheets).
• Manually tested all teh reports and used Change Management techniques to fix teh issues.
• Worked extensively with Business users on teh post production issues.
• Extensively trained users in Dashboard level and Reporting level.
• Involved in all teh Business meetings with various teams in making teh key decisions.
• Took care of complete Migrations from Dev to QA to Prod.
• Worked closely with teh ETL team to suggest teh changes in data.
• Worked on OBIEE Administration like, installation, configuration of OBIEE Security External Database, LDAP, Aggregate Table Configuration of nqsconfig file and also Instanceconfig.xml files, Setup and Configure OBIEE Delivers, Creating Materialized Views, Setup MUDE Environment, Repository Merge, Catalog Merge, Deployment from dev to prod.

Environment: OBIEE 10.1.3.4.1, Oracle DB 10g, Win 2003 Server, Mercury Quality Center, Unix.

Confidential, Bethlehem, PA

Lead Oracle Business Intelligence Application’s Developer

Responsibilities:

• Gathering, Analyzing and identifying teh Gap of Business Reports Requirements.
• Analyze data model and requirements from an Application Architecture Repository and Framework standpoint.
• Responsible for creating a prototype of teh application, create teh Functional Requirements Document (FRD), and demo teh prototype to teh end users for sign off
• Installed and configured all teh environments (Dev, Prod, Test) for Sales analytics module of BI applications.
• Responsible for maintaining teh entire BI Applications for Sales Analytics module.
• Built customized tables for Activity analytics and Project analytics.
• Worked extensively with Siebel 8.1.1 data source.
• Responsible for executing teh DAC plan to load teh data in to teh data warehouse.
• Also developed Informatica ETL customized mappings.
• Worked extensively with teh prebuilt OBI Applications repository.
• Responsible for implementing teh ADSI Security Autantication with OBI Applications.
• Identified Facts and Dimensions (with levels & hierarchy) and developed OBIEE Repository (RPD) 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 presentation catalogs), create presentation folders, test and validate teh model.
• Developed many Analytical and Operational reports using different Analytics Views (Pivot Table, Chart, Column Selector, and Narrative View), Dynamic / Interactive Dashboards with drill-down and drill through capabilities, charts, tabular using global and local Filters. Extensively used Siebel Delivers and iBots.
• Implemented Security by creating roles, web groups, and external tables.
• Coordinated teh Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to teh Production environment.
• Developed teh Initial and Incremental / Delta ETL process i.e., Mappings & Mapplets using various Transformations for new objects.
• Performed Unit, Integration and Regression testing to validate reports and mappings.
• Involved in developing teh Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks. Executed teh 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 Siebel Analytics Repository.
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 8.6.1.
• Extensively worked in fine-tuning of Informatica Mappings.
• Used different application development tools like TOAD (Oracle)

Environment: Oracle BI Applications 7.9.6.1,OBIEE 10.1.3.4.1, DAC 10.1.3.4.1, Informatica 8.6.1, Oracle DB

Confidential, San Jose, CA

Oracle Business Intelligence Architect

Responsibilities:

• Gathering, Analyzing and identifying teh Gap of Business Reports Requirements.
• Analyze data model and requirements from an Application Architecture Repository and Framework standpoint.
• Responsible for creating a prototype of teh application, create teh Functional Requirements Document (FRD), and demo teh prototype to teh end users for sign off.
• Implemented Proof Of Concept for Helpdesk Analytics.
• Identified Facts and Dimensions (with levels & hierarchy) and developed OBIEE Repository (RPD) 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 presentation catalogs), create presentation folders, test and validate teh model.
• Created repository, session variables, and initialization blocks for security and dynamic time periods.
• Developed many Reports using different Analytics Views (Pivot Table, Chart, View Selector and Column Selector), Presentation Variables, Dynamic / Interactive Dashboards with drill-down and drill-through capabilities, charts, tabular using global and local Filters
• Installed and Configured Oracle Business Intelligence Applications(OBI Apps) for Procurement and Spend Analytics.

Environment: Oracle Business Intelligence EE 10.1.3.4.1, Oracle Business Intelligence Applications 7.9.6, Oracle Applications, DAC, OBIW (Oracle Business Intelligence Warehouse), Informatica PowerCenter 8.6, Oracle 10gR2, RHEL 5.4, Windows Server 2003, OWB

Confidential, Emeryville, CA

OBIEE Lead BA

Responsibilities:

• Conducted meetings with business representatives for gathering teh Finance Team’s Reports / Dashboards business requirements.
• Gathered and documented Business Requirements through stakeholder engagement, cross-functional team interviews, and business process analysis
• Wrote complex technical specifications detailing data transformations, business rules and process flows
• Interpreted and developed integrated business analyses and documents for sign-off and implementation and supported change management activities
• Conducted Process Flow Mapping, developed BRD’s and as - is / to- be analysis
• Developed use case scenarios, activity and sequence diagrams and various other data mapping techniques
• Developed financial reports on an ad hoc basis and as per business requirements
• Provided financial and consumer metrics data, analysis and recommendations to teh executive team
• Facilitated JAD (Joint Application Development) sessions for Rapid Application development (RAD) to perform GAP analysis and identify business rules, changes to teh existing systems and requirement elicitation
• Worked closely with various development groups (e.g. UI, middleware, backend) to propagate teh ideas and business requirements in a concise way
• Performed CFAM Data Warehouse analysis and identified teh required Facts, Dimensions, Levels / Hierarchies of Dimensional and referential joins.
• Devised a model plan to implement teh CFAM analytical repository from an Oracle Business Intelligence perspective.
• Responsible for expense reporting tasks for financial tracking and management
• Worked with teh business to identify return on investment, process refinements, change management opportunities, data quality management and project justification by providing investment data, identifying risks and tracking progress.
• Identified value propositions, built and documented Business Cases and justified project scope using ROI to articulate findings
• Identified opportunities for improvements / enhancements, and negotiated agreements and commitments between teh business unit and IT from requirements gathering to final implementation and maintenance through teh complete Software Development Life Cycle.
• Performed teh setting up, installation and configuration of teh complete Analytics platform environment and teh required connectivity for seamless integration with teh CFAM data warehouse.
• Designed and developed Analytics Metadata Repository (.rpd) using Oracle BI by importing teh required objects with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies), Logical objects in Business Model Layer, and creating teh Presentation catalogs in Presentation Layer.
• Used advanced SQL to query and perform analysis of teh various sources
• Used industry standard analysis techniques such as data flow modeling, use-case analysis, workflow analysis, functional decomposition analysis, data modeling, and object modeling to uncover client requirements and converted them into system requirements based on teh business process rules
• Designed data models and mapping using ER Diagrams
• Data mined and organized data to provide insights across teh business organization and analyzed results to make recommendations to improve performance
• Enabled and validated accuracy and independently supportable analysis of compiled data conforming to development and documentation standards
• Applied data structure techniques such as Relational Data Models, Dimensional Models, Materialized Views, Partitioned Tables, etc. to optimize reporting.

Environment: Oracle Business Intelligence EE 10.x, Informatica PowerCenter 8.1, RUP, UML, AGILE, Rational RequisitePro, MS Visio, MS Project, Excel, HTML, Oracle 9i,Oracle 10g

Confidential

Business Analyst

Responsibilities:

• Developed Business process flow diagrams in Visio, identified critical points which are creating issues.
• Gathered As-Is information by following teh concerned stakeholders in their day - to - day activities, studying their operations behavior.
• Optimized efficiency of Supply Chain & Logistics planning by eliminating teh errors occurring at distribution centers; thereby enhancing product availability at stores.
• Conducted workshops and brainstorming sessions with various stakeholders in teh project to gather their individual requirements; documented and analyzed them to develop functional tasks.
• Used Microsoft Visio for flow-charts, Use - Case process model and architectural design of teh application.
• Responsible for business process analysis dat includes requirements facilitation, definition & analysis, alternatives, software selection, prototyping, business process design and mapping.
• Conducted meeting and JAD sessions for project definition, resource identifications and deliverable prototype identification.
• Developed Functional Requirement Document’s, Workflow Diagram’s and Use case specification document.
• Developed action plans for correcting teh issue in incremental steps and comparing outcome against teh KPI’s set, streamlined logistics activity.

Environment: MS Vision, MS Office, Human Factor Analysis, KPI Analysis, Process Analysis, Negotiating & Delegating, Logistics, Supply Chain Management