Lavanya Kalam

Senior BI Developer

Professional Summary:

Over 8 years of expertise in all aspects of Business intelligence projects which including analysis, design, development, configuration, Customization, validation and deployment.

Expertise in providing end-to-end business intelligence solutions using OBIA, Informatica, DAC, OBIEE 11g, OBIEE 10.X

Deep knowledge on Oracle Business Analytics Warehouse (OBIA) data model.

Worked Extensively on OBIEE Administration Tool and Presentation Services

Subject matter Expertise in Oracle BI Apps (OBIA), OBIEE, Informatica, DAC.

Worked with different data sources including Oracle EBS, Siebel, and People Soft etc.

Deep knowledge on OBIEE security integration with LDAP, Oracle EBS and Siebel security models.

Worked on Install, upgrade and configure all components of OBIEE 12.2.1 (12c) from 11g Environment.

Enthusiastic and project-oriented team player, with excellent communication and

Leadership skills to develop a creative solution for challenging business needs of the clients.

Extensive Experience in Data Warehousing development using ETL tools such as Informatica Power Center 9.x/8.x/7.x/ 6.x and DAC

Experience in Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager.

Added users and configured security in web logic console of OBIEE 11g

Responsible for installing, configuring, developing, support and maintenance of the BI APPS

Provide Production Support for end-users of the system including training, responding to the queries, resolving problems, and providing ad-hoc reporting

Implemented security by creating roles & web groups, checks with External tables and LDAP, and Object Level Security

Defined repository /session variables and initialization blocks to get dynamic reports and dashboards

Expertise in Developing Qlikview Applications using multiple data sources like MySql, Text files, Excel documents.

Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.

Effectively migrated RPD and Presentation Catalog changes, Skins, Style Sheets across environments through catalog manager using MUD

Extensive experience in designing the Data Warehouse with strong understanding of dimensional Modeling. Identification of fact and dimension tables, Normalization, Physical and Logical data modeling.

Mentored other members in the team & active participant in training the business users with the Dashboards/ Answers.

Familiar with Oracle BI Apps (OBIA) 7.9.x modules- Purchasing, Project, Marketing, HR, and Finance.

Ability to proactively manage workload and identify opportunities for additional contribution.

Liaising with technical and development team on issues relating to forthcoming implementations and new Siebel and OBIEE software releases.

Delivered excellent results to each client company and maintained a track record of client satisfaction, assignment completion on time.

Ability to work on multiple assignments, good analytical, interpersonal and management kills.

Experience working with Tableau Software as a dashboard developer

Detailed knowledge in Data warehouse Application Console (DAC) and Informatica Servers.

Efficient in troubleshooting, performance tuning and optimization of ETL and reporting analysis.

Education:

BTECH, JNTU University – INDIA

Technical Skills:

OBIEE

OBIEE 12.2.1, OBIEE 11gOBIEE 10.x, Siebel Analytics 7.5\7.7\7.8

Databases, Database Tools

Exadata, Oracle 8I/9I/10G, SQL Server 2000

ETL\Data migration

Informatica 6/7/8/9, DAC 10.X/11g

Languages

SQL, PL/SQL, JAVA, HTML, C, C++.

Web Servers / Tools

Microsoft IIS, Sun One

Testing Tools

Manual Testing

ERP

General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Purchase Order (PO), Order Management (OM), Inventory (INV),P2P,O2C,Project Analysis, Purchase Analytics, HR Analytics

Professional Experience:

Aramark Philadelphia, PA Dec 2015 - Current

Sr.BI Developer

Responsibilities:

Implemented out of box and custom build Oracle BI applications - HR Analytics

Participated in gathering and analyzing the Business Requirements with Business Analysts and Users.

Designed the Technical Design and System Design documents by understanding the FSD and BRD Documents.

Involved in Installation/Configuration of OBIEE Server, Repository (RPD) and responsible for setting up Development

Extensive worked on OBIEE 11g repository (Physical, Business Model and Mapping and Presentation layers) Cache management, Usage tracking, Dimensional hierarchy, Aggregate navigation, and variable initialization blocks configuration and etc.

Created OBIEE Roles based on the projects and assigned users to it.

Created users and configured security in web logic console of OBIEE 11

Developed custom reports/Adhoc Queries using OBIEE Answers and assigned them to application specific dashboards.

Troubleshoot the data issues in OOTB report

Modified the OOTB reports and Dashboards

Monitor the day-to-day activity of the data warehouse, Informatica jobs, BI Tools and reporting.

Worked with Business Groups to identify, analyze, and document Business Requirements

Developed many Reports/Dashboards with different Analytics Views using Drill-Down & Drill-Across, Pivot Table, Chart, View Selector, and Column Selector, with global & local Filters within Oracle BI Analytics.

Supported Unit Testing and System Integration Testing (SIT)

Build Adhoc subject areas and trained end users as part of self-service analytics project.

Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.

Generated various Analytics Reports using global and local filters.

Performance tuning of Dashboard/Reports and made changes to database by implementing materialized views and aggregate tables, rebuilding of indexes

Managed security privileges for each subject area and dashboards according to user requirements

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 suite.

Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.

Built multiple execution plans in DAC for weekly and daily loads.

Building dashboards using Tableau desktop

Install, upgrade and configure all components of OBIEE 12.2.1 (12c) from 11g Environment.

Created OBIEE 11g export bundle by using BI Migration Tool jar file

Performed import 11g data in to the 12c system by using BI Migration scripts.

Created dashboards for Apple IPad by using new OBIEE 12c mobile designer.

Created POC report by using OBIEE 12c Analyzer

Created SOPs for RPD, Web catalog migration, cache management etc. in new 12c environment.

Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters

Very strong analytic and presentation skills and problem solving techniques with emphasis on individual and team effort backed by excellent communication skills.

Environment: OBIEE 11.1.1.7,OBIEE 12.2.1.0.0, Oracle 12c, Informatica 9.5.1, DAC 11.X, OBIA 7.9.x (HR Analytics, Payroll), OBIA 7.9.6, Tableau 9.3, Microsoft Windows XP, UNIX, SQL Developer.

HP (Client WCDC) Sacramento, CA May 2013 - Nov2015

Sr OBIEE Developer/ Admin

Responsibilities:

Implemented out of box and custom build Oracle BI applications - Procurement & Spend Analytics, Project Analytics and HR Analytics

Worked with Business Groups to identify, analyze, and document Business Requirements

Gathered requirements for GAP Analysis, translated them into technical design documents

Designed and Developed Custom Mappings, Workflows and Registered in DAC.

Extensively Worked with Oracle EBS tables, OLTP, flat files and integration and loading data to Data Warehouse (OLAP) system.

Troubleshoot the data issues in OOTB report

Modified the OOTB reports and Dashboards

Identified the aggregate levels for each source and created dimension sources for each level of aggregates.

Configure the SSIS Package for run time Parameters and Configured file

Added users and configured security in web logic console of OBIEE 11g.

Supported Unit Testing and System Integration Testing (SIT)

Developed test cases and participated in UAT (User Acceptance Testing)

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 suite.

Generated various Analytics Reports using global and local filters.

Managed security privileges for each subject area and dashboards according to user requirements prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.

Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.

Created workflows for full load and incremental loads to be used by DAC, worked with two offshore developers to ensure delivery and accuracy

Assembled subject areas and created execution plan and accommodated the new Informatica mappings.

Used Tableau Desktop to analyze and obtain insights into large data sets & also Generated Tableau reports with Trend lines

Monitoring Incremental & Full load through DAC.

Building dashboards using Tableau desktop

Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters

Trained End Users and Pilot Users about OBIEE Tools

Environment: OBIEE 11.1.1.7, Oracle 11GR1, Informatica 9.1, DAC 11.X, OBIA 7.9.x (HR Analytics, Account Payables) Tableau, Microsoft Windows XP, UNIX, SQL Developer.

KBR Inc, Houston, TX. Jun 2012 – April 2013

OBIEE Analyst/Developer

Responsibilities:

Worked with Business Users, Involved in Discussing and Gathering the Analytics requirements from different user groups.

Identify Data Sources & Extension columns - Identify OLTP tables, fields, Map them with Staging Tables and finally map them to OLAP’s Physical layer tables/schemas.

Configured and developed Order Management and Order Fulfillment reports using OBIEE Answers and Oracle BI Publisher.

Worked on Repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBI Administration Tool.

Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.

Used the Security settings in OBIEE Admin Tool to set up users, groups, access privileges and query privileges.

Created Dimensional Hierarchy, Logical columns, Aggregate columns, Level based Measures and Aggregate navigation in BMM layer.

Configured charts, pivot table views, Gauge Views, filter in user interface.

Configured Global Filters and Dashboard and page Prompts in OBI Web.

Expertly used the OBIEE add-ins to insert and analyses reports in Word, Excel and PowerPoint.

Developed new reports and migrated existing excel reports to OBIEE dashboards.

Configured repository and session variables to get dynamic reports and dashboards.

Designed and developed Performance Measurement Dashboards/Reports that are Dynamic & Interactive with drill-down, drill-across capabilities split reports for summary & details information, and local & global filters using Oracle BI Presentation Services.

Created iBots using Oracle BI Delivers to deliver reports to different devices across enterprise.

Developed Qlikview Dashboards using various Qlikview objects like Charts, List Box, multi box, Table Box, Button, text box and containers as per business needs.

Configured LDAP server to Authenticate users and implemented both object level and row level security based on roles and responsibilities.

Hands on experience with DAC in creation of Tasks, Task Groups, Subject Areas, and Execution Plans.

Experienced in DAC to configure, monitor and schedule ETL routines.

Used Informatica for ETL purpose, for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center.

Extensively worked in fine-tuning of Informatica Mappings, Troubleshoot ETL performance issues.

Implemented Qlikview Publisher into existing Qlikview server environment. Developed PDF

report for distribution to large customer base using Loop and Reduce Publisher methodology.

Created sessions, tasks, and workflows etc. in Workflow Manager.

Involved with the Testing team to resolve, fixing and testing problems found during the Systems integration test, UAT Phases.

Environment: Oracle Business Intelligence Enterprise Edition 11.1.1.6, Oracle 11GR1, Informatica 9.1, DAC, OBIA 7.9.x (Purchase Analytics, Project Analytics), Qlikview, Microsoft Windows XP

AT&T Alpharetta, GA Feb 2010 – May 2012

Sr. OBIEE Developer

Responsibilities:

Participated in the Requirements Gathering of the various work streams by meeting with the business user and base lining the details.

Configured the tables and joins between them in the Data Warehouse.

Identify the OLTP tables, design the mappings, and finally map them to the OLAP Tables.

Installation of Siebel Analytics/OBIEE and related components for development, QA and production environments.

Customized Oracle BIEE Metadata Repository using Siebel Analytics/OBIEE Admin Tool by importing some of the required objects with integrity constraints into Physical Layer.

Migrate the repository and presentation catalog between different environments like Dev, Test, QA and Maintenance.

Worked on Configuration & Application Deployment Management.

Worked on Oracle BI Administration tool for customizing the Physical Layer, Business Layer, and Presentation Layer that came with OBIA and modifying it according to the business requirements.

Worked on Metadata Repository objects and also Web catalog Objects, which include Dashboards, Reports, Pages and Folders.

Designed and developed Performance Measurement Dashboards/Reports that are Dynamic & Interactive with drill-down, drill-across capabilities split reports for summary & details information, and local & global filters using Oracle BI Presentation Services.

Developed custom reports/Ad-hoc queries using Seibel Answers and assigned them to application specific dashboards.

Worked on scheduling tool Data Warehouse Administration Console (DAC) to configure, monitor and schedule ETL routines of the Oracle Business Analytics Warehouse.

Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.

Enhance performance of Reports/ Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions, re-building of indexes and managing Cache etc.

Used Informatica for ETL purpose, for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center.

Configured LDAP server to Authenticate users and implemented both object level and data level security based on roles and responsibilities.

Security settings were implemented in Siebel Analytics Administration Tool to set up groups, access privileges and query privileges.

Configured and Scheduled BI Scheduler for report bursting to File and email locations and used advanced reporting features such as Online Analyzer, Excel Analyzer and report security options.

Created templates as required by the client using BI Publisher.

Created sessions, tasks, and workflows etc. in Workflow Manager.

Performed Unit, Integration and Regression testing to validate reports and mappings.

Assist with performance tuning of Data warehouse both online and night batch

Environment: Oracle Business Intelligence Enterprise Edition 10.1.X, OBIA APPS (Purchasing, Account Payables, Account Receivables), Microsoft Windows XP, Toad

Digital River, Minneapolis, MN Mar 2008 – Jan2010 OBIEE Reports developer

Responsibilities:

Created MUD (Multiple user Development) environment by utilizing projects.

Splitting of repository projects and makes it available to developers.

Effectively migrating web cat, Skins and Style sheets from one server to another server by using catalog manager.

Installed Siebel Analytics in windows server.

Created production builds and getting approvals from senior management.

Customized and developed the Siebel Analytics Business Model and Mapping layer.

Granting access to users and maintain security by using database authentication and authorization.

Organize Presentation Layer in a format that is easy for end-user to use as a basis for reporting

Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures.

Created auto purge for repository cache and scheduled as per the demand.

Trouble shooting the issues related to repository models and report development.

Designed Metadata repository – Physical layer, Business Model & Mapping layer and Presentation Layer

Defined Connection Pools to the Source Data Mart tables in the Physical Layer

Created Logical Columns based on other Logical and Physical columns in the BMM layer

Created Presentation catalogs for Sales and Month End Account measures.

Siebel Analytics Server Administration (Setting up a repository, Administering the Query Environment, Scheduler, Query Caching)

Created the physical and complex joins in the Physical and Business layers

Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.

Created Repository Groups and Web Groups and assigned users to configure security in the Siebel Analytics Server

Defined Session variables and the corresponding Initialization Blocks for User Logins at dimensional levels

Defined Session variables in the repository to populate the current date filters

Developed/Customized Siebel Dashboards, Siebel Answers, Siebel Delivers (I-Bots)

Created Reports based on user requirements

Worked on Dashboard and Page level prompts and Report filters

Documentation, Knowledge transfer and User training

Environment: Siebel Analytics 7.8, Informatica 7, Sun Solaris 9, Oracle 10g

Surya Jyothi Infotech, Hyderabad, India June 2006 – Jan 2008

Siebel Analytics/Developer

Responsibilities:

Implemented Time Comparison and calculation measures in the business model using Time series wizard and modeled Slowly Changing dimension data.

Performed Repository Testing and validation before exposing Business Models in the Presentation layer.

Created proactive agents (iBots) and interactive dashboards to alert the sales rep about the sales of the particular item.

Maintained effectiveness in creating the dashboards by appropriately including drilldowns. Setup the visibility of dashboards to employees with respect to their responsibilities.

Implemented, designed, enhanced business logic in existing Oracle Applications.

Designed and developed PO interface to update the status of the receipts for the shipments in accordance with packing slip and transaction types to the custom table.

Worked on PO interface to transfer Clear orbit data from legacy to Oracle Application.

Wrote PL/SQL stored procedures to fulfill the iterative process and to solve complex business

Developed scratch Oracle Reports on many modules like PO requisition reports.

Worked on order checking of the items and updated in to the custom table.

Participated in various meetings with functional team and legacy system management to gather user requirements regarding reports and other customizations and incorporate those requirements into Oracle applications features.

Debugged and modified various forms, based on the user requirements using Oracle Forms and Oracle Repots 6i

Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILEpackage.

Relation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Environment: Siebel CRM 7.8, Analytics 7.8, Oracle EBS 11.0.3, Oracle10g, Win 2003, &

Sun Solaris. Reports 6i, Forms 6i

Contact this candidate