PROFESSIONAL SUMMARY:

• 6+ years of experience in Business Intelligence (BI) solutions and expertise ingathering requirements, planning, designing, implementation, testing, delivery, documentation and maintenance of Oracle BI applications and Data Warehousing solutions with OBIEE/OBIA, BI Publisher, Informatica, DAC.
• Certified in Oracle Business Intelligence Foundation Suite 11G Certified Implementation specialist 11G (1Z0 - 591), Oracle Business Intelligence Foundation 10 Implementation specialist (1Z0-526), Oracle Business Intelligence Applications 7.9.6 for ERP Essentials (1Z0-525)
• Good experience in implementing/customizing the Oracle BI Analytics Applications for various modules like Finance, HR, Procurement and Spent and SCOM modules with integrating the ERP Systems like Oracle E-business Suite R12, PeopleSoft 9.1
• Strong Knowledge of all phases of Software Development Life Cycle (SDLC) such as Requirement Analysis, Design, Development, Testing, UAT, Implementation and Post Production support.
• Experience in developing and extending ETL data mappings in Informatica.
• Experience in developing Informatica Mappings/Mapplets for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & Tasks and scheduling using both Workflow Manager and Unix Shell scripts.
• Experience with implementation and administration of Data Warehouse Administration Console (DAC) to configure, monitor, and schedule ETL routines of the Oracle Business Analytics Warehouse (OBAW).
• Expertise in installing and setting up Development, Test and Production environments in LINUX/UNIX and Windows environments
• Worked Extensively on Oracle BI Administration Tool, Presentation Services, Answers, & Interactive Dashboards, KPI’s.
• Worked Extensively in setting up Security like LDAP, Database Authentication, External Table Authentication etc.
• Deep understanding and technical skills in Oracle BI Platform and Applications, including dimensional & multi-dimensional data modeling design of star schema and Snowflake for large data warehouses, implementation of complex reports.
• Excellent command and implementation on Data warehousing, Data Modeling & Business Intelligence concepts and design techniques.
• Expertise in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model and Presentation Layer), Time Series Objects, Hierarchies & Interactive Dashboard reports with drill-across capabilities for trend analysis.
• Experience in modeling and implementing OBIEE security at Object and Data Levels for users and groups.
• Expertise in developing & customizing complex data models and RTF templates using BI Publisher reports and are delivered using different delivery channels like E-Mail, FTP and File.
• Experienced in Performance tuning on Informatica mappings, and Configure sessions and workflows in Informatica.
• Experience with testing of the end-to-end solution and validating results with business requirement and compare with Actual and Expected results.
• Have clear understanding of Business Intelligence and Data warehousing concepts with emphasis on ETL and Reporting functionality.
• Having good interaction with client side people and business stakeholders.

TECHNICAL SKILLS

BI Tool: (OBIEE). 11.1.1.9.1, 11.1.1.7.0, 11.1.1.6.12 and 11.1.1.5.5, BI Publisher

OBI Applications: OBI APPS 7.9.6.x, Financials, HR, Procurement, SCM

Business Intelligence: OBIEE (Oracle Business intelligence Enterprise Edition), Administration, AnswersInteractive Dashboards, Oracle BI Publisher, Disconnected Analytics, BI DeliversWeb Catalog Administration, Analytics Server Administration.

Developer Tools: Informatica Power Center 9.6.1, 9.5.1, 9.1.0, 8.6, DAC, SQL Developer, Toad

ERP: Oracle E - Business Suite 11.1.5.0/R1213

Data Modeling: Star - Schema Modeling, Fact & Dimension

Databases: Oracle 11.2.0.3,11.2.0.1/10g/9i/8i,MS-SQL Server 2000.

Bug tracking: HP Quality Center 10.00

Operating Systems: MS Windows, Unix and Windows Server2008, Oracle Enterprise Linux (OEL)

Programming Languages: C, SQL, PL/SQL, JAVA, JavaScript, Perl, HTML, XML, CSS, XSLT

Migration Tools: Winscp, Filezilla, Putty

PROFESSIONAL EXPERIENCE

OBIEE Consultant

Environment: OBIEE 11.1.1.9.1, Informatica 9.6.1, SQL Developer, OBIA 7.9.6.4, Oracle EBS R1213

Confidential, Austin, TX

Responsibilities

• Responsible for Analysis, Design, Development, Testing and System Integration Testing for the business requirement.
• Working with the business to gather requirements and guide them in understanding how to maximize their usage of Oracle BI Applications.
• Developing the dashboards for the Family Protective services on areas of Adult Protective Services (APS), Child Protective Services (CPS), Child-Care Licensing (CCL), and Statewide Intake (SWI), and Center for Policy, Innovation, and Program Coordination (CPIPC).
• Designed and developed the dashboards for the Home page of DFPS.
• Creating the data model as per business requirements.
• Installing and configuring OBIEE, OBIA and Informatica on the remote machines.
• Extracted data from different sources like Oracle and flat files implemented Business logic and loaded into target warehouse (OBAW).
• Building the various levels of RPD (Physical, BMM and Presentation Layers) and configuring hierarchies and Checking RPD for inconsistency and resolving if any.
• Developing Reports / Dashboards with different Analytics Views
• Suggest alternatives and work-around to problems being faced by the client.
• Working with large databases with high transaction volume in a fast-paced, production environment. Query and report performance tuning.
• Test plan preparation, review of test plans, unit &integration testing.
• Implemented Data level and Object level Security and LDAP security is implemented in providing security to business users.
• Expertise in Merging, migrating the BI & ETL metadata and custom code, deploying Rpds and Catalogs between different environments and setting up, Created Multi user Development (MUD) environment by utilizing projects in OBIEE.
• Worked in UNIX script for explicitly clearing the cache.
• Worked effectively in performance tuning Informatica queries which are taking longer time.
• Created dependency mappings to retrieve the values from another mapping and implement SCD 2 with soft delete.
• Created new execution plans in DAC for the different areas of protective services for daily, weekly and monthly loads.

Confidential

OBIEE Consultant

Environment: OBIEE 11.1.1.7.12, Informatica 9.5.1, SQL Developer, OBIA 7.9.6.4, Peoplesoft 9.1

Responsibilities

• Analyzing and Understanding of the business requirement for HRA Dashboard and Medical and Medicaid Dashboard requirements.
• Worked closely with Business Users, involved in discussing and gathering the requirements from different user groups.
• Setup the visibility of Dashboards to employees with respect to their responsibilities. Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
• Designed and developed reports and dashboards on Patient Metrics, Readmissions, HC Physician scorecard, Health care insurance, DR Scorecard, Patient satisfaction reports, HR Analysis, Average wait time KPI.
• Worked in Designing the Dashboard home page with high visualization using action links.
• Created Data level security from different dashboards and reports.
• Implementation and customization on HR Analytics module of OBIA 7.9.6.4.
• Developed and customized executive level dashboards and reports in various views such as Pivot Views, Charts(Graphical charts, pie charts), View Selectors, Column Selectors on HR data.
• Implementation of User Level and Data Level Security for OBIEE Dashboard Reports.
• Creating users and groups and assigning permissions based on responsibilities/roles, Giving security permission privileges to the user and Worked on performance tuning of the custom reports.
• Modified RPD to add new tables and join to the existing schema.
• Created Dashboards and Reports for the new releases of Helpdesk and MTM data.
• Created new mappings for Helpdesk and MTM data using different transformations like sorter, filter, expression, joiner, router, lookup etc.
• Modified the complete payroll related Informatica mapping to add new grade to the data.
• Developed Informatica Sessions and workflows for Full load and Incremental load for Helpdesk and MTM data.
• Created PLSQL stored procedures to call drop indexes before loading.
• Involved in modifying the existing data model and changing as per business needs.
• Created new execution plan in DAC for the MTM data load.
• Performance tuning in DAC to find out the unused indexes and dropping them.
• Parallel hints option is used in DAC for the long running tasks to reduce the run time.
• Interacting with the client for the new enhancements.
• Used Tivoli tool to make the changes to the job streams over daily and weekend.
• Clearing the issues in the support queue in HPSM tool.

OBIEE Consultant

Environment: OBIEE 11.1.1.7.0, Informatica 9.0.1, SQL Developer, HPQC, Nexus, AIT

Confidential, Charlotte, NC

Responsibilities

• In all Integrated, Independent and High Speed releases interacted with Business Users for gathering the Reports/Dashboards requirements.
• Created different dashboards and reports for the releases of Independent and high speed releases.
• Created dashboard prompts, filter and different views for reports.
• Created the RPD based on Star - Schema modeling.
• Creating Various Dashboard Reports on top of BI Answers and aligned them on various Dashboards as per the requirements from the client.
• Developed RPD design and developed custom reports from the source system and created new and opened Answers for adhoc reporting to the End users.
• Implemented MUDE for parallel development by developers.
• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into target data warehouse.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created workflows for full load and incremental loads to be used by DAC.
• Assembled subject areas and created execution plan and accommodated the new Informatica mappings.
• Monitoring Incremental & Full load through DAC.
• Developed some of the complex excel calculated highly formatted reports into BI Publisher and provided the capability to download the high-fidelity reports in the user defined formats (PDF, CSV, HTML, EXCEL and XML DATA).
• Installed and Configured OBIEE, DAC and Informatica on Linux Environment.
• Worked on developing ETL design using Informatica, used Transformations like Aggregator, Joiner, Update, Filter, Lookup, Sorter and developed various new mappings
• During the long run of the batch due to network issues, found out the solution of where the batch is effected and resolved them by stopping the execution plan and restarting them.
• Trained End Users and Power Users about OBIEE Tools.

OBIEE Developer

Environment: OBIEE 11.1.1.6.0, Informatica 9.0.1, SQL Developer, Toad, OBIA 7.9.6.4

Confidential, Dallas, TX

Responsibilities

• Implemented Financial Analytics and SCOM Analytics, Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Involved in requirements gathering (Reports/Dashboards/Delivers), analysis, design, used various data sources, development and implementation of the project.
• Involved in the analysis, requirements, design, development, implementation, documentation &maintenance of the OBIEE solutions as per the Client Requirements.
• Design and Developed GEAS Analytics Metadata repository (.rpd) that consists of physical layer, business model layers with aggregates & dimensions, presentation layers with catalogs & folders and external table security with session variables using Oracle BI Analytics Admin tool.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE.
• Designed and Developed General Ledger, Payables, Receivables, profitability, Procurement and spend and supplier performance Dashboards in OBIEE.
• Created KPI’s, Score Cards, reports and Dashboards with Dashboard prompts, Charts, Pivot tables
• Customization had been done on Finance, Procurement and Spend modules on OBIA 7.9.6.4.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Debugging Informatica Mappings for the new changes based on the requirement.
• Developed Sessions and workflows for Full load and Incremental load.
• Assembled subject areas and created execution plan and accommodated the new Informatica mappings.
• Building DAC execution plan by adding new tasks and task groups and then assembling subject areas.
• Involved in the design phase of data model

OBIEE Developer

Environment: OBIEE 11.1.1.5.5, Informatica 8.6, SQL Developer, Toad, OBIA 7.9.6.4

Confidential

Responsibilities

• Direct Interaction with the Client to gather the requirements and analyzing the requirement for Enhancements.
• Customizations are done on the module of Procurement and Spend and SCM of OBIA 7.9.6.3
• Customized the BMM layer to reflect the data, hierarchies, aggregation and created reports based on the custom facts and dimensions.
• Created reports with charts, dashboard prompts, and filters to display appropriate data based on report specification.
• Design and development of many Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts, Guided Navigation, and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters for building various Corporate KPI’s.
• Created the user accounts, granting the access/privileges.
• Provided Group level security to different groups users.
• Involved in creating Custom ware house tables to accommodate data from multiple sources for reporting
• Debugging the mappings and validated the data from ETLs running full and incremental loads.
• Created new mappings, sessions and workflows in Informatica for the new changes.
• Created the test cases for the new changes as part the release and testing it in the existing reports, dashboards and new dashboards as per the functionality specified by the business.
• Proficient in working with HP Service center and Quality center.
• Also involved in the Support activities like checking the Support queue for any new tickets and fixing them.

OBIEE Developer

Environment: OBIEE 10g,11.1.1.5.0, Informatica 8.6, SQL Developer, Toad, OBIA 7.9.6.3

Confidential, Chicago

Responsibilities

• Gathering requirements, Analysis, functional and technical specifications, interacting with Business Managers and End users at client site.
• Implementation and Customizations are done on Finance module of OBIA.
• Design and Developed (.rpd) that consists of physical layer, business model layers with aggregates & dimensions, presentation layers with catalogs & folders and LDAP security with session variables using Oracle BI Analytics Admin tool.
• Worked on OBIEE Answers to create the customized reports as per the Client Requirements.
• Validated the business model in Oracle BI Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Design and development of many Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts, Guided Navigation, and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters for building various Measures.
• Debugging mappings and configuring sessions and workflows to run those mappings in TEST environment and testing the functionality of mappings on Finance Modules.
• Created new execution plan in DAC for the scripts data.
• Resolving the Data issues related to Informatica Mapping.
• Developing the new mapping in DEV Environments for the test scripts.
• Monitoring the DAC execution plan and fixing the bugs.
• Created test cases for the reports, dashboards, prompts and compare it with the actual and the expected results.
• Scheduled Agents for reports on weekly basis.