Sales Manager

SOUMYA RANI GOPU

571-***-**** / abg3co@r.postjobfree.com

SUMMARY:

. 6 years of experience in Information Technology with extensive

knowledge and work experience in design and development of Business

Intelligence Applications.

. Over 3+years of extensive experience in OBIEE 10.x including

Installation & Configuration of OBIEE.

. Over 2+years of experience in Informatica Power center 7.x,8.x

. Expertise in implementation of end-to-end BI solutions following

standard OLAP methodologies using Oracle Business Intelligence (OBI

EE).

. Expertise in design and development of the three layers

(Physical/Business Model and Mapping/ Presentation) of OBI Metadata

Repository using Oracle BI Administration Tool.

. Experience in implementing pre-built Oracle BI Applications (OBIA).

. Expertise configuring Analytics Metadata objects (Subject Area, Table,

Column), Answers (ad-hoc querying, reports), Variables (Repository/

Session/ Presentation), Interactive Dashboards with drill-down

capabilities (charts/ tables/ graphs), Delivers (iBots) and

administering Web Catalog Objects (Dashboard, Pages, Folders,

Reports).

. Experience in Security Setup at both Object and Data levels, LDAP

authentication setup and configuration of Multiuser Development

Environment (MUD).

. Experience in integration of BI Publisher with BI server and vast

experience in building rtf templates for the reports using Oracle BI

Publisher.

. Used DAC Client to customize and execute out-of-the box DAC execution

plans to run all ETL mappings at specified interval.

. Experience in customizing the change capture process of DAC to load

data incrementally.

. Extensive Knowledge on Oracle BI Delivers and Implemented schedule

based iBots to deliver reports.

. Extensively worked on Informatica Power Center tools - Repository

Manager, Designer, Workflow Manager and Workflow Monitor.

. Strong understanding of Dimensional Data modelling (Star Schema

modelling, Snow-Flake modelling, Fact and Dimension tables), Physical

and logical data modelling

. Expertise in performance tuning of BI Repository, Reports, Informatica

.

. Mappings/Mapplets.Experience in Oracle PL/SQL programs, Procedures,

Packages, Functions and Triggers.

. Multi Environment working experience - UNIX, Windows.

. Excellent communication and strong interpersonal skills with ability

to interact with end-users.

. Did Project Estimation for various projects.

. Designed and maintained Security model for OBIEE users.

. Code migration from one Environment to another(Dev,UAT,Prod).

. Created Projects for Developers for Mud Process.

SKILLS:

ETL Tools Informatica Power Center 8.x

OLAP/BI/Reporting Siebel Analytics 7.8.x/OBIEE 10.1.3.x

DBMS Oracle 8i/9i, Oracle 11g, DB2, Microsoft

Access, SQL Server 7.0

Languages C,C++,Java,HTML,Java script,SQL,PL/SQL

Operating systems Windows NT/2000/XP, UNIX, LINUX

EDUCATION:

. Masters in Software Engineering, Stratford University, Falls Church,

VA.

. Bachelors in computer science, JNT University, Hyderabad, India

EXPERIENCE:

Feb'11 - Present OBIEE Developer, EDMC (Education Management

Corporation), Phoenix, AZ.

9010 Education Management Corporation is among the largest providers of

private post-secondary education in North America, based on student

enrollment and revenue, with 104 locations in 31 U.S. States and Canada.

9010 is a reporting project, helping the business line understand the

revenue flow based on the following, Ed system Analysis, Program Analysis,

Fund Source Analysis and OPEID analysis. The Analysis reports included all

the revenues generated in relation to students of the organization and

grouping them based on Fund Source, Ed System, and Program etc. 9010

reporting module helped the business line understand and plan the budget

for the next fiscal year and fiscal months.

. Proposed Architecture/Design for Business Model and Performed Metadata

Modeling for proposed architecture.

. Configured OBIEE Repository, Physical Layer, Business Model and

Mapping Layer and Presentation Layer using OBIEE Administration Tool.

. Worked closely with the business users in identifying various KPI's

and designed solutions to indicate them efficiently for enhance

business decision-making.

. Did Project estimation for multiple projects.

. Implemented Security for various users and groups using External Table

Authentication.

. Creating application, process, testing and data mapping documentation.

. Created data source view in the physical layer to convert rows coming

from back end to columns

. Updated security permission / privileges as per the role of each user.

. Designed and developed a prototype of reports for the 9010 project.

. Developed report layouts using Html and JavaScript.

. Developed custom prompts for reports.

Environment: OBIEE 10.1.3.2, OBIEE Answers, Informatica Power Center 8.X,

SQL SERVER 2008.

Jan'09 - Jan'10 OBIEE Developer, Wal-Mart(EIS Divisional Dashboard)

Brisbane, CA.

Wal-Mart is one of the biggest retail market in us, it has lots of branches

in Benton, Brisbane CA And also it has branches in UK .This project mainly

speaks about the Organisation and the performance of the Employees in the

Organisation .We are Developing Dashboards For the Higher level Employees

in the organisation .Based on the user who logged in Dashboard will show

their Direct Employees and their Supervisors. Logged in user can see

Details of his direct employees but not his peers. We are using Oracle BI

10.1.3.2 for developing the reports and for loading the back end is

Informatica .

. Proposed Architecture/Design for Business Model and Performed Metadata

Modeling for proposed architecture.

. Configured OBIEE Repository, Physical Layer, Business Model and

Mapping Layer and Presentation Layer using OBIEE Administration Tool.

. Worked closely with the business users in identifying various KPI's

and designed solutions to indicate them efficiently for enhance

business decision-making.

. Created ad-hoc reports in OBIEE Answers and Intelligence Dashboards as

per the business requirements.

. Created application, process, testing and data mapping documentation.

. Create data source view in the physical layer to convert rows coming

from back end to columns

. Giving security permission / privileges as per the role of each user

. Developing business reports using Siebel Answers and to display the

reports in Dashboards.

. Worked on different types of securities like object level, Row level

and data level security in reports and dash boards.

. Organizing the presentation layer in a format that is easy for end

user to use as basis for reporting.

Environment: OBIEE 10.1.3.2, OBIEE Answers, Informatica Power Center 8.X,

Oracle 11g, TOAD.

Aug'07 - Jan'09 OBIEE

Developer, Exxon Mobil, Fairfax, VA

The CRM project provides sales and order Analytics solution to Exxon Mobil

to enhance decision making process regarding their products and customers.

The system will allow users to perform data analysis and track their

products and customer details. The aim of the project "Production Budgeting

Analysis" was to implement Oracle OOTB solution for Production, Supply and

Order Management. The module "Order Management Analysis" involved

customizing the business model to analyze the business metrics and to track

the key performance metrics such as order size, Invoice revenue, Profit%,

Sales by customer and by product etc. It also involved generating reports

and dashboards for Managers/Executives (Sales Representatives, Purchasing

Managers, etc).

. Developed OBIEE (RPD) per user requirements and available

information in DW.

. Analyzed and validated the business model in Siebel Administration

Tool by performing consistency check, validating logical source

tables, logical columns, and also validating repository level

calculations done in the business model layer

. Implemented Security for various users and groups using External

Table Authentication

. Implemented dynamic dashboard prompts to zoom into particular

segments of the business in a performance-optimized manner

. Responsible for creation of pivot table requests and bar/column

charts allowing manager to analyze the business from different

perspectives provided optimized Analytics request using column

selector/view selector, multi-select page prompts

. Created and used Siebel Delivers and iBots extensively

. Developed and debugged Dashboards/ reports visibility with respect

to user's responsibility and web groups in an integrated environment

. Developed Informatica mappings with re-usable transformations and

mapplets using various transformations

. Extensively involved in performance tuning of the Informatica ETL

mappings like increasing the caching size, overriding the existing

SQL

. Developed / modified mappings per gaps identified

. Used Toad to debug the SQL query to identify duplicate rows in the

warehouse tables, and to debug SQL query issued during report

execution

. Coordinated the Analytics RPD and Web Catalog objects migration from

Dev environment to QA environment and to the Production environment

Environment: OBIEE 10.1.3.2, Informatica 8.6.1, Oracle 9i, Sun Solaris,

Toad,OBIEE Application

Nov'06 - Jul'07 OBIEE Consultant, Health

Net, Inc, San Diego, CA

Description: Health Net provides managed health care and other medical

coverage to more than 6.6 million members in 27 states. The firm's Health

Plan Services unit offers HMO, PPO, Medicare, and Medicaid plans. The

primary objective of this Data warehouse project was to make a separate

data mart for customer, provider and insurance policies information to

sales and marketing people. As a Siebel Analytics/OBIEE consultant involved

in developing BI solution for strategic analysis by sales, marketing, and

pricing. This would help managers drive key business decisions, improve

category management, lower inventory costs, and optimize pricing decisions

to strengthen its dominance.

. Used the OBIEE 10.1.3.x OBIEE Administration tool to develop and

enhance meta-data.

. Created connection pools, physical tables, defined joins and

implemented authorizations in the physical layer of the repository

. Configured and Created repository using Siebel Analytic Admin tool.

. Worked extensively with Physical Layer, Business Layer and

Presentation Layer.

. Created numerous executive level reports. 'Dashboards' were generated

to provide insight into the sales/marketing/financial data.

. Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical,

Alias and Extension tables.

. Created different types of Customized Reports (Drilldown, Aggregation)

to meet client requirements.

. Built Business model and established relationships & Foreign Keys

(Physical & Logical) between tables.

. Created business reports using Siebel Answers as per requirements.

. Monitoring Incremental & Full load through DAC.

. Maintaining the Full and Incremental loads through DAC on different

environments like Development and Test environment.

. Generated various Analytics Reports like Formulary Report and Direct

Sales Report using global and local filters.

. Involved in modifications of physical, business and presentation

layers of metadata repository using Siebel Analytics Administration

Tool.

. Identified the aggregate levels for each source and created dimension

sources for each level of aggregates.

. Involved in managing appropriate security privileges on subject areas

and dashboards according to business requirements.

Environment: OBIEE 10.1.3.3, Oracle 9i/10g, Informatica Power Center 7.x,

Windows 2000, UNIX, SQL*PLUS, Toad.

March'06 - Nov'06 Oracle Developer, Reddy Labs

Pharmaceuticals, Hyderabad, India.

Worked in Reddy Labs, which provides a wide array of, comprehensive, fully

integrated outsource solutions that help pharmaceutical and biotechnology

manufacturers commercialize their products. Most of their clients are the

designer drugs and biotechnology drugs. Involved in

modifications/enhancements, maintenance and supporting the existing system

and perform some new development.

. Data Modeling Using ER-Win Tool.

. Involved in the design, development and implementation of application

using Oracle

Assisted with the definition of the end-user requirements.

. Created and maintained huge number of database objects including

stored procedures, views, triggers and packages using SQL & PL/SQL.

. Involved in performance tuning of the existing SQL Packages.

. Created and maintained huge number of Database Objects including

Stored Procedures, Views and Triggers.

. Implemented Dynamic queries and other complicated Queries involving

more than 25 tables and complicated Joins.

. Worked extensively in various kinds of queries such as Sub-Queries, Co-

related Sub-Queries, Dynamic SQL and Union Queries and concentrated

much on Query tuning.

. Written Korn shell scripts for the Batch process of Oracle/PLSQL

scripts.

Environment: Oracle 7i, SQL* Plus, SQL Developer, PL/SQL, Erwin 3.5, HP-

UNIX, Windows 2000, Win NT.

Contact this candidate