SUMMARY:

• 5+ years of expert level experience in Business Requirements Gathering & Analysis, Development, Implementation, Testing of dashboards, scorecards, analytical reporting and OBIEE meta data modeling for OBIA analytics 7.9.6.4 such as: financial analytics, sales analytics, order management, procurement and spend and customer loyalty analytics for high technology vertical market.
• I have designed and developed Informatica Data Warehouse mapping customizations for OBIA application analytics and custom analytics.
• I possess expertise in business process flows and developing functional and design documents for projects.
• Analytics repository management, administration and the development of custom modules for the Warehouse using Oracle Business Intelligence Enterprise Edition, Informatica and DAC. Strengths include: teamwork, multi - tasking, and delivering high quality results; organized, goal-oriented and sociable.
• Dimensional Data Modeling experience using Data modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling using OBIEE 11g/10g.
• Business user training content development and delivery
• ETL development and customization of existing ETL mappings as per business needs.
• Business process re-engineering, requirements gathering and translation of business requirements into technology solutions.
• Dashboard and Scorecard development, customization and detailing Metrics, KPIs that are critical to quality metrics.
• OBIEE, OBI applications and SQL programming. Configuring, administering and managing the repository, creating complex reports and role based Analytics Intelligence Dashboards
• Unit testing using PL/SQL scripting and data validation.
• Oracle, MS SQL Server 2000, SQL, SQL Server, Windows 95/98/2000 XP, Win NT 4.0 and UNIX Sun Solaris 2.x.
• Enthusiastic team player, with excellent communication and interpersonal skills. Can take up individual responsibilities and detailed in the analysis and process optimization.

TECHNICAL SKILLS:

Operating Systems: Windows OS, UNIX OS and

Red Hat LinuxVirtual Machines: VMware Server and Workstations, AWS EC2

Programming Languages: PL/SQL Scripting, C programming, Java Script, HTML, Unix Shell Programming, Java

Databases: Oracle 11g/10g, Microsoft SQL Server 8.0

Tools: Know the QuickTestPro process and methodology, Quest Toad, MS Access 2010, SQL Developer & SQLPLUS, OBIEE Admin Tool, Oracle Answers, Oracle Delivers, Minitab 16, Matlab, COMSOL Multiphysics, LabVIEW, Abaqus, LabChart for PowerLab, PSPICE, OpenSim, SolidWorks,osmometry, ECG interpretation

Data Integration Tools: Informatica PowerCenter 8.1.1 & 9.0.1, SP4 and Oracle DAC

Data Warehouse: Oracle 10g/11g data warehouse for Oracle Apps, Siebel CRM DW

Oracle Fusion Middleware: WebLogic 10.1.3, Jdeveloper, SOA, BAM, BEPL

Business Intelligence: Tableau 8.0, OBIEE 11.1.1.7.1 with patches, OBIA 7.9.6.4 (Supply Chain, HR, Financial and Order Management Analytics) custom Customer Loyalty Analytics for OBIEE 11g.

PROFESSIONAL EXPERIENCE:

Confidential

OBIEE Developer

Responsibilities:

• Complete installation and de-installation of OBIEE 11g in local machine and provisioned virtual desktop server instances
• Patch upgrade to OBIEE 11.1.1.7.1 .140415
• Report creation and dashboard development
• Applied repository patches and migrated changes from one environment to another (Dev > UAT > Val > PRD)
• Comfortable using TortoiseSVN repository browser as a shared directory with IT for applying patches
• Created BI Publisher reports and embedded them into dashboards
• Modeled Metadata of complex star schemas involving conformed dimensions
• Explored other data visualization strategies including Tibco Spotfire
• Deployed rpds and catalog folders using the Enterprise Manager
• Created plenty of documentation for unit testing, security, data validation etc...
• Fulfilled the scrum master role in team sprint meetings
• Built Report Specification documents
• Built mapping documents

Confidential

OBIEE Developer

Environment: OBIEE 11g, Server was configured and deployed in Linux

Responsibilities:

• Designed and developed Reports/Dashboards with different Analytics Views using Oracle Business Intelligence Presentation Services.
• Imported the Physical tables and keys into Repository and Developed Business Model and Mapping layer, Implemented logical column measures and calculations.
• Created Dimensional hierarchies and Level based Measures along with rank measures in BI Administration Table.
• Designed and implemented quality analysis test plans and QA documentation
• Created guided navigation links to help files within the dashboards to help the end users.
• Validation of EDW and source staging for Quality Analysis
• Validation of row count in analysis versus data warehouse based on SQL queries

Confidential

BI Solutions Architect

Environment: OBIEE 11g, Windows Server 2008 R2 Standard with Windows x64 bit OS, clients were installed on Windows

Responsibilities:

• Consolidated multiple subject areas in the presentation layer of the rpd into a single subject area
• Integrating data models built from disparate connection pool sources
• Merging rpds before migrating them from one environment to another
• Proficient in performing both the full and partial rpd merges
• Modified the XML references to point to new subject areas
• Migrated BI objects between the DEV, QA and PROD environments using the Catalog Manager tool
• Created documentation for the Subject Area Consolidation effort
• Created documentation for the patch upgrade from OBIEE 11.1.1.7.0 to 11.1.1.7.1 40715
• Applied additional features to the upgrade such as IE 11 compatibility, export to Excel functionality and more

Confidential

OBIEE Sr. Technical Developer/ Architect

Environment: OBIEE 11g, OBI HR Applications 7.9.6.4, Informatica Powercenter 9.0.1. DataWarehouse Administration Console 11g Oracle, Clients were installed on Windows

Responsibilities:

• Created custom reports and dashboard pages based on dynamically changing business needs
• Applied filters and dashboard prompts with dynamic variables as mechanisms for restricting data
• Managed OBIEE security in the Weblogic Enterprise Manager and the front-end Analytics by creating application roles and assigning them user groups
• Managed and worked with the following HR analytics subject areas: workforce development, user tracking, security, workforce profile, top performers, internal mobility, learning management, usage tracking, performance tracking
• Designed level-based and parent-child hierarchies in business model and mapping layer of the rpd
• Defined user and group access to control object level security
• Applied session variables to define data-level security in the rpd
• Modified query logging levels in the Analytics level and RPD level for validating data
• Built hierarchies and applied aggregation rules to logical business model in the rpd
• Created and managed folders to respective users and groups
• Requirements and design for ETL mappings from Source to Target to load data into Data warehouse.
• Parsed high-level design specification to ETL coding and mapping standards.
• Modified headcount metric to accurately reflect source data.
• Designed and custom data merge process to merge data from Europe and U.S. Most of the data was specific to each of the domains; however, the information that was common to both were related to roles and responsibilities. The same roles and responsibilities were existing in both the data centers. I merged these into one.
• Designed and developed approximately five-hundred training slides for HR team (for on-boarding with HR analytics)
• Developed three-hundred page activity guide that contained detailed step-by-step instructions on lab work.
• Developed Key Performance Indicators and balanced scorecards as part of the Enterprise Performance Management tools

Confidential

OBIEE/ ETL Sr. Developer

Environment: OBI Applications 7.9.6.4, Informatica Powercenter 9.0.1. DataWarehouse Administration Console 10g Oracle, Clients were installed on Windows

Responsibilities:

• Development of BRD & FSD documentations.
• Interacted with business users to identify business groups and assign security groups to folders
• Successfully configured Windows ADSI security in the Administration Console
• Participated in Business Requirement Documents review, Functional Requirements Documents Data Model Reviews to understand the requirements and to prepare the necessary design documents accurately.
• Involved in building the ETL mappings from Source to Target to load data into Data warehouse.
• Using Informatica PowerCenter created and extended sales order bookings and line facts and dimension mappings and mapplets to transform the data according to the Business Requirements Documents (BRDs), preparing high and low level design documents.
• Responsible for monitoring sessions that are running, scheduled, completed and failed using Informatica Power Center 9.0.1
• Fixing load errors by analyzing the session and workflow logs and resolving the errors due to duplicate data from source, index creation failures and space issues.
• Optimized SQL in source qualifier to reflect the additional audit data in the mappings and mapplets.
• Modified target sales order lines and sales booking lines fact tables to contain additional line level metrics.
• Parsed high-level design specification to ETL coding and mapping standards.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed many complex mappings and mapplets using various transformations (Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator) for loading the data into Data Warehouse.
• Writing PL/SQL routines to validate the Data Warehouse data and also reporting/dashboards
• Customization of workflow sessions and tasks to reflect my mapping customizations
• DAC customization to include my custom workflows, customization and generation of parameter files.
• Monitoring and resolving DAC load errors to complete the DAC load successfully.