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 knowledge 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 knowledge 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.
• Over 2 years of development experience in creating highly interactive data visualization reports and dashboards using Tableau Desktop/Server.
• Expert in developing Business Intelligence Reports/Dashboards using different BI Tools like Tableau, OBIEE, Domo.
• 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, OTBI-E, Siebel Analytics 7.x, BI Publisher (10.x, 11.x, 12.x), 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, Pasadena, CA

BI Report Developer

Responsibilities:

• Infrastructure setup and Server Capacity planning.
• Managed daily Project activities which includes Technical and Functional planning.
• Prepared all the Business Requirements and change documents.
• Effectively drafted functional requirements.
• Installation and configuration of Tableau server in cluster environment.
• Migrating OBIEE 11.1.1.9.0 to 12.2.1 using BI Migration tool (Jar file).
• Converted, Configured and Deployed legacy BI reports in to Oracle BI Publisher 12C for various Government Organizations.
• Developed different Tableau data visualizations using Line charts, Cohort charts, Box and Whisker charts, Scatter Plots, Geographic Maps, Cross tabs etc.
• Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations to build dashboards.
• Implemented row level security as well as group/user level security for Tableau dashboards.
• Performed administration tasks such as creating, managing users, sites, setting permissions, managing ownerships, providing access to users using user filters.
• Developed extremely complex dashboards using Tableau table calculations, quick filters, context filters, hierarchies, parameters and action filters.

Environment: OBIEE 11G, OBIEE 12C, Tableau Desktop/Server 10.2, Legacy Reporting App, Windows Server 2012.

Confidential

BI Solution Lead

Responsibilities:

• Upgrade Planning, Installations, Documentation of Environment Upgrade from OBIEE 11G to 12C.
• Infrastructure setup and Server Capacity planning.
• Managed daily Project activities which includes Technical and Functional planning.
• Prepared all the Business Requirements and change documents.
• Effectively communicated functional requirements to the teams.
• Good functional Knowledge of Guidewire Claim Center.
• 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 the data from existing Source Systems and Developing complex Financial Reports for the organizational Decision making process.
• Worked on the OTBI-E/BI Apps side of Oracle HCM Cloud implementation.
• Oracle Data Integrator expertise and built numerous mappings, load plans for the project.
• Built numerous custom OTBI - HR Reports for Payroll, Recruitment, Retention, Talent Management, Work Force Deployment etc. Subject Areas.
• Managed and maintained the OTBI/OBIA Metadata Repository.
• Configured OTBI Enterprise for HCM Cloud Service.
• Defined, Generated & Executed a domain-only Load Plan to Load source-specific data in to Configuration Manager.
• Monitoring & Troubleshooting a Load Plan for OTBI Enterprise.
• Performed Functional setup of OTBI Enterprise for HCM Cloud Service.
• Performed Configuration Tasks in OTBI Enterprise for HCM Cloud Service.
• Managed Initial Load Plan in OTBI Enterprise for HCM Cloud Service.
• Did a POC on OTBI Enterprise for HCM Cloud Service Security integration with Oracle Fusion Middleware Security Architecture.

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, Oracle HCM Cloud, OTBI-E

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.
• Functional and working knowledge of Oracle Retail Management System modules.
• Effectively communicated business requirements to the developers and assist with unit testing.
• Managed day to day project activities with the cross functional teams.
• 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

Sr Business Intelligence Specialist

Responsibilities:

• Analyze and Evaluate the MD-50’s (BRD) written by the Analysts and verify the compatibility of requirements with OBIEE Reporting.
• Good Knowledge on Order to Cash and Procure to Pay business life cycle.
• Managed day to day project activities with cross functional teams.
• Effectively communicated Business requirements with the teams and assist in Unit Testing.
• Develop Complex Gaming Reports with OBIEE tool using different features available in the OBIEE.
• Modeled and Developed OBIEE Real Time Reports by connecting to the Oracle EBS source data.
• Developed multiple reports in the Oracle BI Apps OOTB areas of Finance, Projects, HCM.
• Responsible for Unit Testing the Reports and migrating across multiple environments.
• Written MD-70’s (Technical Design) documents for the reports which are worked on.
• Worked on adding additional columns to the SDE, SIL custom mappings in ODI development area.
• Responsible for maintaining and implementing OBI Best practices across the environment.
• Conducted Architectural Reviews of Reports, Dashboards, ODI Custom Columns developed by other developers in the team to see if the code adheres to the best practices suggested by Oracle.
• Data Modeling the Custom HR subject area needed for HR Analytics.
• Customized OBIA Repository for Financial Analytics, Supply Chain and HR Analytics.
• Customized the HCM Data Model for HR Analytics by modifying the out of the 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 the business requirements.
• Implemented EIS Custom Reporting of HR, Finance in the RPD and in the BI Catalog.
• Installed and Configured ODI application across the 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 the BIACM and FSM Utilities.
• Created Dashboards and Visualizations for Business Reports using Reporting tools like Tableau & OBIEE.
• Strong in writing and understanding complex calculated fields & building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

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

BI Solution Lead

Responsibilities:

• Interacted with Business Analysts and Line of Business owners for gathering the Business requirements and report/ dashboards requirements.
• Designed the Business Analytics Warehouse Data Model for the source data.
• Architected the 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 CIGA Line of Business.
• Articulated tangible requirements in the form of features, stories & business rules.
• Responsible for the 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 CIGA LOB.
• Designed and Developed ODI Mappings or Interfaces to populate the De-Normalized data in to Datawarehouse, source to target data validation, Qualitative & Quantitative analysis of interfaces and Data Load strategies.
• Configured repository on all the 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 the DBA to optimize the performance of Database.
• Installed and Configured the ODI application across the environment with Agent configuration to load the data from Source to Target.
• Created ODI Packages, Jobs of various complexities and automated process data flow.
• Configured and Managed ODI environment through the ODI Client Designer Studio.
• Involved and Managed all the Post Production support activities to help resolve issues raised by Business Users.
• Maintained Master data by using Oracle EDQ to profile the 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 WebCenter, LaserFische, Apollo(Custom Application), Oracle DB 11g & 12C, Oracle SQL Developer, Linux RHEL6, Win 2007 Server, Oracle EDQ

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 the 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 the 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 the 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