SQL Developer
Resume:
Keeran
Summary – * 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.
Experienced in:
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.
Technology Skills
Operating Systems – Windows OS, UNIX OS and Red Hat Linux
Virtual 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.
Education & Certification
Currently pursuing a Master's Degree in Engineering Management at Santa Clara University. I anticipate in graduating by the end of 2016. (9 units remaining)
Bachelor of Science in Software Engineering, University of Phoenix, Phoenix, Arizona
4 years undergraduate degree in Biomedical Engineering, California Polytechnic State University, San Luis Obispo
Oracle Business Intelligence Foundation 11 Certified Implementation Specialist
Oracle Business Intelligence Foundation 10 Certified Implementation Specialist
Certified as an ENGINEER-IN-TRAINING (Fundamentals of Engineering (FE) Exam)
Training Experience
Oracle Trainer at Mahim Xavier Institute of Technology, Mumbai Dec 2015
Oracle BI 11g R1: Create Analyses and Dashboards
Oracle University Faculty Jun 2013 - Aug 2013
Oracle BI 11g R1: Create Analyses and Dashboards
Oracle BI 11g R1: Build Repositories
Corporate Training for Janssen Pharmaceuticals, Inc. July 2013
Lead a five-day training in OBIEE 11g Create Analyses and Dashboards and Build Repositories
Created the student activity guide which was delivered during the training
Projects
Gilead Sciences, Inc.
OBIEE Developer & Administrator Jan 2015 - Dec 2015
Gilead GVMS, PDMBI, GBAS,
I mainly built customizations for Gilead's Vendor Management System and Business Analytics System applications. Most of work pertained to ETL mappings, building reports, repositories, migrating patches and testing. A detailed list of tasks that I accomplished are further expounded under 'Responsibilities'.
Environment: OBIEE 11g, Oracle DB, clients were installed on Windows 7
Responsibilities:
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
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
Bosch Sept 2014 - Nov 2014
OBIEE Developer
This was a standalone application analytics project that dealt with the patients' survey data. I designed and created data models to represent patients' survey data, which resulted in creation of four fact tables and fifteen dimension tables including conformed dimensions. One of the challenges was in identifying and representing survey results for questions responded and questions not responded in a survey.
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
B/E Aerospace Project Jun 2014 - Sept 2014
BI Solutions Architect
The presentation catalog contained many misplaced reports, dashboards and other BI objects that were stored in an unorganized and cluttered manner. The client’s objective was to consolidate a handful of subject areas that were used to build these reports down to just a few. My role was to consolidate nine subject areas down to three subject areas. I also consolidated several subject areas that were designated for internal use into one single subject area. In addition to subject area consolidation, I upgraded the OBIEE 11g version from 11.1.1.7.0 to 11.1.1.7.140715 in the DEV, QA and PROD environments. During the latter stages of the project, I served as support, fixing reports that yielded errors and broken paths.
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
oProficient 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.140715
Applied additional features to the upgrade such as IE 11 compatibility, export to Excel functionality and more
Jeppesen Project Jul 2013 – May 2014
OBIEE Sr. Technical Developer/ Architect
This engagement pertained to the HR analytics customization. The project involved customization of HR analytics configuration files in Informatica and DAC as per Oracle EBS applications for human capital management. The data for this customization was sourced from Europe and the United States; therefore, I had to merge data across business units and geographic locations. Localization was also part of the customization. I served as support during the latter portion of the project. I've performed the 11.1.1.7.131017 patch upgrade. I was also a trainer coordinator and trainer for training the Jeppesen HR team. The trainer material that I created included 500 slide PowerPoint lecture and 300 hundred page activity guide.
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
Calix project Mar 2011 – Jun 2013
OBIEE/ ETL Sr. Developer
This engagement pertained to the OBIA customization. My responsibilities were in the areas of ETL development and meta data customizations.
I was involved in building the technical solution for the Booking Single Source of Truth (Bookings SSOT) – Data Model. This booking is known as a purchase order (PO) from an approved customer or reseller approved by Sales Force Dot Com (SFDC). The ETL mappings from the OLTP source database was migrated to Operational Data Store, which in turn became the source for all my OBIA customizations that were eventually migrated to the OLAP target warehouse.
Bookings SSOT – Customization of OOTB (out-of-the-box) analytics application for Supply Chain and Order Management involved in capturing the booking order lines at transactional audit grain. The challenge to this requirement is in EBS order management transactions were captured at order line level but were updated on a daily basis. Previous updates were eventually lost by order management system; however, the business required that the transaction update audit was captured. This customization was done in EBS events view where the audit data was tracking the transaction updates. Custom views were developed from events view to capture this data. My responsibility was to integrate the custom view transactional audit data from events view with the out-of-the-box bookings data.
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.
DataDirect Networks Sunnyvale, CA Feb 2010 – Mar 2011
DW/BI Developer
DataDirect Networks (DDN) is the world leader in massively scalable storage. They are the leading provider of data storage and processing solutions. They also specialize in professional services that enable content-rich and high growth IT environments to achieve the highest levels of systems scalability, efficiency, and simplicity. DDN enables enterprises to extract value and deliver results from their information. Customers include the world's leading online content and social networking providers, high performance cloud and grid computing, life sciences, security & intelligence organizations and media production organizations.
Environment: OBIEE 11g, BI Apps 7.9.6.3, Web Logic Server, Informatica 9.0.1, Oracle 11.2.0.2, SQL, PL/SQL, DAC 7.8.4, TOAD, SQL* Plus, Unix, Windows XP.
Responsibilities:
Installation, configuration of OBIEE 11g in Linux platform and configuration and customization of OBIA 7.9.6 applications – Supply Chain and Order Management Analytics, Financial Analytics, HR Analytics, Procurement and Spend Analytics and customization of DDN Operations Reports.
The above tasks required customization of Informatica SrcFiles and LkpFiles by querying the data from the source, validating and updating the .csv files in order for the DAC to pick up the configuration and execute the ETL successfully.
Metadata customization to reflect the business requirements for back orders and shipments were done and required report development was also done.
Effectively interacted with the end users for requirement gathering and defined requirement specifications document
Installed, configured and developed BI Apps Financials, Supply Chain, Procurement and Spend, HR modules.
Worked extensively with Physical Layer, Business Layer and Presentation Layer.
Created numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data.
Built Business model and established relationships & Foreign Keys Physical & Logical between tables.
Setting up LDAP authentication to enable Single Sign On for Users in Development environment leveraging Analytics Repository.
Managed security privileges for each subject area and dashboards according to user requirements
Created workflows for full load and incremental loads to be used by DAC.
Added users and configured security in web logic console of OBIEE 11g.
Trained End Users and Pilot Users about OBIEE Tools.
Responsible for installing, configuring, developing, support and maintenance of the BI APPS.
Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local filters) using Oracle BI Presentation Services.
Setup Multi User Development Environment (MUDE) in OBIEE.
Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
Plantronics, Santa Cruz, CA Apr 2009 – Feb 2010
OBIEE Consultant/Business Analyst
The sales department at Plantronics wanted to re-engineer its existing model in order to cut down customer service time and automate the workflow. This required a complete overhaul of existing online functionalities and integration with new components as well as interface redesign (CRM Analytics customization).
Responsibilities:
Gathered user requirements via JAD sessions with users and stakeholders, and developed functional and non-functional requirements and technical specifications
Create report mock-ups based on the business requirements and get sign off from business on the functional specifications.
Created Data Flow Diagrams and Data Models (Star Schema). Formulating the TO-BE features based on the business requirements and pain points
Developed and updated Test plans, Test Matrixes, Test Scenarios, and Test Cases
Used Siebel Analytics Administration Tool for customizing and modifying the physical, business and presentation layers of metadata repository (.rpd)
Worked in BI Publisher and Windows environment with OBIEE writing SQL and PL/SQL queries along with the Data Warehousing concepts.
Worked on the Time Series Wizard and implemented time comparison measures
Used Filters and provided Prompts appropriately to avoid excessive data showing up Reports
Managed security privileges for each subject area and dashboards according to user requirements
Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders
Worked Extensively on Siebel Answers to create the reports as per the client requirements
Defined additional views (narrative, pivot, chart views) of the data returned by the request to visualize data in many different ways
Configured Intelligence Dashboards by adding content such as links/images, HTML objects, and guided navigational links and drilldowns
Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers
Worked on project planning, project scheduling, status reporting, cost and time estimation using MS Project
Defined test scope and objectives using business process flow diagram defined in the design specifications and reviews design and flow with the UAT business team
Environment: OBIEE 10.1.3.2, TOAD, SQL, Oracle 9i, MS Visio, MS Office.
Step Ahead Solutions, Inc. Mar 2008 – Apr 2009
DW/BI Developer
Joined Step Ahead as a dashboard developer and continued with design and development of Meta Data, Dashboards and Scorecards. As an Oracle Answers Developer, I was involved with requirements gathering and business analysis and analytical reporting workflows to translate business need into business intelligence solutions for various clients of Step Ahead.
Projects for Step Ahead
Internal Product development at Step Ahead Solutions
Customer Loyalty Analytics for High Tech Industry – This is a custom analytics application built on OBIEE 10.1.3.4.1 technology platform for heterogeneous source applications for partner relationship management and customer relationship management. The core of the application was centered on customer retention, demographic analytics, and customer share of the wallet, certification analysis, program effectiveness and loyalty analytics.
Environment: OBIEE 10.1.3.4.1 on Redhat Linux, OAAM, OAM and OIM, Oracle WebCenter application integration, DAC, OBI Applications 7.9.6 and Informatica Powercenter 8.1.1. Clients were installed on Windows XP, 8 and Vista.
Responsibilities:
Requirements gathering, analysis, functional specification documentations, BI report mockups.
Identified key dimensions and measures for business performance.
Installation and configuration of OBIEE and related components for development, QA and test environments
Involved in system testing efforts (e.g. bug fixes, analysis, and documentation)
Involved in development and review of System documentation and Validation of deliverables
Customized Customer Loyalty Analytics Metadata Repository (.rpd) using OBIEE Admin Tool by importing some of the required objects with integrity constraints into Physical Layer.
Developed and customized some of the existing multiple Dimensions (Drill-Down Hierarchies) & Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
Designed and developed Web catalog, Reports/Dashboards with different Analytics Views using Oracle Business Intelligence Presentation Services.
Developed Calculated Measures and dimension hierarchies in the Business Model and Mapping Layer.
Configured Web Catalog Objects (Dashboards, Pages, Folders, and Reports).
Implemented column selector to select different column values.
Designed and developed Reports/Dashboards with different Analytics Views using Oracle Business Intelligence Presentation Services.
Created guided navigation links to help files within the dashboards to help the end users.
Scorecard and Dashboard development including top 10, trend analysis, variation analysis, customer demographics, historical performance management and comparative analysis.
The entire dashboards and reports were designed and deployed by me. I had also built close to 105 custom measures and KPIs from the basic measures published by the data modeler.
Trade Show Analytics – This is a custom analytics application built on OBIEE 11g technology platform for organizations participating in trade shows across the county. The core of the application was centered on trade show participants, participant demographic analytics, and decision maker share of the wallet, participation analysis, exhibit effectiveness and loyalty analytics.
Environment: OBIEE 11g on Redhat Linux, and Informatica 9 Clients were installed on Windows XP and Vista.
Responsibilities:
Participated in multiple end to end implementations which consists of gathering requirements from multiple user groups, analyzing Business Requirements Documents (BRD’s), preparing high level and low level design documents, Development, Support.
Participated in Business Requirement Documents review, Functional Requirements Documents Data Model Reviews to understand the requirements and to prepare the necessary design documents accurate.
Gave necessary inputs in Star Schema Design.
Architecture and Design of OBIEE for Step Ahead custom solutions.
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.
Created Time series measures for QTQ, YTY, WTW, YTD, QTD analysis.
Designed and developed Web catalog, Reports/Dashboards with different Analytics Views using Oracle Business Intelligence Presentation Services.
Created session variables, repository variables and initialization blocks in the repository building and modification procedures.
Customized the presentation layer according to the easy understanding of the Business Users.
Implemented MUD (Multi User Development) environment across the whole organization which helps in smooth, easy, fast rpd development.
Configured Security groups through Weblogic console and Application roles through Weblogic EM in OBIEE 11g.
Added new functionality such as Hierarchical prompts in OBIEE 11g.
Implemented Data Level Security by creating data groups in rpd and implemented Object Level Security by creating web groups in Presentation services in BI Answers.
ODL™ (On Demand Laptops) are Step Ahead’s proprietary cloud based system that provides OBIEE and OBIA environments on demand. I had customized many ODL™ for several application and custom analytics.
Environment: OBIEE 11g on Redhat Linux, Informatica 9 Clients were installed on Windows Server 2008, AWS EC2 Systems, OBIA 796
.Responsibilities:
Prepare architecture for data, prepare strategies and provide business object solutions as per requirements.
Supervise efficient working of all Business Intelligence projects and analyze requirements and perform appropriate tests on same.
Administer projects, prepare updates and implement all phases for project to achieve all project objectives.
Analyze all complex data and identify requirements for business enhancement in project.
Perform assessment on all reporting requirements and develop long term strategy for various reporting solutions.
Maintain and transform all strategies in operational plans according to business priorities and within budget.
Develop scalable and maintainable BI applications to meet business objectives.
Develop security and authentication standards for the organization.
Maintain accurate and complete technical architectural documents.
Define BI standards, guidelines and best practices for business groups &technical teams.
Support BI tools upgrades in development, testing and documentation.
Perform maintenance and troubleshooting activities for BI tools.
Diagnose and resolve BI tool capacity issues.
Recommend strategies to improve performance and capacity of BI tools.
Install, configure, design, architect and deploy Oracle Business Intelligence Enterpriser Editions (OBIEE) technology platform for in-house projects as well as for Step Ahead clients.
Build Proof of Concepts, Demos, and presentations on technology for pre sales with Oracle Corp.
Manage development teams on product deliverables and deployment in Amazon Cloud.
Testing the data using PL/SQL scripting
Manage Oracle BI systems in the Cloud.
Total custom application analytics design and development.
Installation and configuration of Oracle Business Intelligence Applications(OBIA)
Customizations and extensions of OBIA.
Design and development of data warehouse using popular (ETL) tools.
Project and Program management.
Contact this candidate