Developer Project

Amrutha Malli

*******.***@*****.*** • 972-***-****

BI/DW Consultant

Positive attitude, creative thinker, excellent communication and presentation skills, team player,

quick learner. Flexible in adapting to any new environment with a strong desire to keep pace with

latest technologies.

Career Summary

• Total experience of 6 years in IT with 4.5 years of experience in BI/DW using OBIEE, BI

APPS, OWB, Informatica.

• Designing, developing and maintaining Reports and Dashboards in OBIEE

• Skilled experience in Physical Layer, BMM Layer and Presentation Layer in OBIEE.

• Experienced in OBIEE Components - BI Publisher and Delivers.

• Played an active role in testing of OBIEE reports compared to the source systems.

• Worked with Oracle and Sql server databases.

• Rich experience in SQL and PL-SQL.

• Experience of ETL (Extraction, Transformation, Loading) tool using OWB, Informatica.

• Knowledge on data warehousing concepts like star and snowflake schemas.

• Worked in Agile and waterfall methodologies.

Technical Summary

Reporting Tools OBIEE 10.1.2.x, OBIEE 11.1.1.5

ETL Tools Informatica 8.x, OWB 10gR2, Business Objects Data

Integrator

Tools/Utilities-Scheduler SQL Developer, TOAD, DAC, Tidal

Database Oracle - 9i, 10g

Operating Systems Windows NT, Windows 2000/XP

Version control systems SVN, CVS

Languages/Technologies HTML, CSS, Java script

Experience Summary

OBIEE Experience

Mar 2013 - Aug 2013 : OBIEE Consulatnt

Mar 2012 - Jul 2012 : BI Apps Consultant at Midasis Technologies

Jun 2011 - Jan2012 : Senior Engineer at Opus Software Solutions, Chennai

Jan 2008 - Jun 2011 : OBIEE Consultant at Delta Edze Solutions, Bangalore

Oracle Experience

Jun 2007 - Dec 2007 : System Analyst at Nanosoft, Chennai

Jan 2005 - Dec 2005 : System Analyst at Nanosoft, Chennai

Professional Experience

OBIEE Experience

HB Consultants Mar 2013 – Aug 2013

HB Consultant is an engineering and management consulting company. I am working as a OBIEE

contractor in developing a Proof Of Concept for sales Dashboard.

Role: OBIEE Consultant

Environment: OBIEE 11.1.1.5, BI Apps

Responsibilities:

• Interacted with business users to gather the requirement

• Collecting the requirements for OBIEE Dashboard

• Building the RPD and Dashboard

• Created Hierarchies, variables and implemented security

• Developed Dashboards for Managers and Business Heads to review the Forecasts vs.

Revenues

• Designed various reports i.e. Drill Down, Pivot and Narrative reports in Answers and

Configured Intelligent Dashboards for different groups of users to view across regions

• Created the Reports Usage Tracking Subject Area

• Review of Metadata Configuration, Web Cat development and writing Test Plans.

Customization of Dashboard and dashboard management.

• Implementing the object level security in the project.

GE Aviation Systems, USA May 2012 – Jul 2012

BI Error Reporting reports are used as Analytical reports for Business Users to Audit the overall

conversion process of the Data Entities from legacy system to Oracle R12. These reports are built to

provide details of No of records processed, No of Error records and records successfully loaded in

the base tables for ‘Manufacturers Part Number’ Data Entity.

Role: BI Apps Consultant

Environment: OBIEE 10.1.3.4, BI Apps

Responsibilities:

• Creating Materialized views in the RPD

• Setting up MUD environment

• CF 250 Documentation for all reports

• MD 200 Documentation for all reports

• Editing the reports in Answers.

BE Aerospace, USA Mar 2012 – Apr 2012

BE Aerospace is the world’s leading provider of interior products and solutions for the commercial,

business jets, and military aircraft markets. The project objective was to develop POC (proof of

concept) named Balanced score card drill down.

Role: Senior developer

Environment: OBIEE 10.1.3.4

Responsibilities:

• Resolved post production Support issues.

• Co-ordinated the onsite and offshore team.

• Fixed issues with high priority quickly.

• Documented all the issues and solutions.

Netspend, USA Oct 2011 – Jan 2012

Financial Infrastructure (FI) is an integration project using Oracle Warehouse Builder (OWB) where

a new distributor is newly added to the existing mappings and verified everywhere in the Clearing

and Settlement schema. This is tested over Testlz, devlz and prodlz environments and the mappings

are scheduled using Tidal scheduler. OBIEE reports in Clearing and Settlement Dashboard are

maintained and enhanced with changes as requested by the client.

Role: Senior developer

Environment: OBIEE 10.1.3.4, Oracle Warehouse Builder, SQL Developer

Responsibilities:

• Analyzing the mapping and Implemented the changes

• Documentation of clearing & Settlement mappings

• Fixing issues in Clearing & Settlement OBI Dashboard

• Scheduled the mappings using Tidal scheduler

• Validated if the output for Testlz and Prodlz environments match.

Opus Trendis, India Jun 2011 – Sep 2011

Trendis is a business intelligence and performance management system that helps banks analyze

customer behavior and channel performance. Based on data warehousing principles, the Trendis

collates and consolidates data from a variety of delivery channels such as ATM, POS, IVR, internet

into a dashboard. Trendis is a tool built by Opus Software on the .net platform. This project was to

check the feasibility of migrating Trendis to OBIEE by developing a prototype of the Downtime

module.

Role: Senior developer

Environment: OBIEE 10.1.3.4, Oracle Warehouse Builder, SQL Developer

Responsibilities:

• Captured business requirements for the Trendis tool.

• Involved in Preparing the Functional Design Document.

• Researched and identified OBIEE features that satisfy the requirements

• Developed the prototype RPD that included various types of hierarchies

• Designed and developed the prototype front end using various features like Value

Navigation and Customized Dashboard

• Designed dashboard using Drill Down, Pivot and Narrative view in Answers and

Configured Intelligent Dashboards for different groups of users to view across regions,

Customer Demography with the facility to drill downs and Charts.

• Documented requirements and design in the project overview document

• Conducted training on OBIEE 10.1.3.4 to Opus team

Cadem Designs, India Jun 2010 – May 2011

This project deals with Financial reporting for Cadem. The source data for the Analysis Reporting is

from an ERP system. Using Informatica, the historical data is loaded into the datawarehouse.

OBIEE is being used to deliver various financial metrics and adhoc queries – for example Year-on-

Year variance of specific P&L accounts.

Role: OBIEE Developer

Environment: Oracle 9i, OBIEE 10.1.3.4, Informatica 8.5

Responsibilities:

• Worked on OBIEE Answers to create reports as per client requirements.

• Maintained effectiveness in creating the dashboards by appropriately including guided

navigational links and drilldowns.

• Configured iBots to deliver analytics content based on schedule to obtain weekly reports and

sent notification Alerts.

• Setup the visibility of dashboards to employees with respect to their responsibilities.

• Created groups and added users to the groups and granted privileges explicitly and through

group inheritance.

• Worked on support and enhancements of the dashboard.

Ceejay Finance, India Mar 2009 – Mar 2010

This project deals with loan management systems for Ceejay Auto Finance.

The scope of this project covered maintenance and support for the Ceejay Loan Origination System

(CLO).

Role : OBIEE Developer

Environment: Oracle 9i, OBIEE 10.1.3.2, Informatica 8.1

Responsibilities:

•

• Working on report enhancements based on the requirements.

• Co-ordinated the onsite and offshore team.

• ixed issues with high priority quickly.

• Documented all the issues and solutions.

Flairview Travel, Australia Jan 2008 – Feb 2009

Flairview is a global search engine for accommodation online. Flairview Global Accommodation

Search offers over 100,000 accommodation options worldwide, where consumers can search,

compare and book accommodations. The objective of this project was to provide Booking metrics

related to accommodations booked through Flairview systems.

Role : OBIEE Developer

Environment: Oracle 9i, OBIEE 10.1.3.2, Informatica 8.1

Responsibilities:

• Worked on Answers to build various reports like charts, pivots and narrative views.

• Implemented filters and prompts in reports.

• Creating and managing Web Groups and Reports Security using Analytics Web

• Administration.

• Preparing the Technical Design document based on the collected requirements for OBIEE

• Troubleshooting of reports while reviewing and formatting them.

Oracle Experience

Nanosoft, India Jul 2005 – Dec 2007

Role: PL/SQL Developer

Environment: Oracle 10g, D2K, SQL*Plus, PL/SQL, SQL*Loader

Responsibilities:

• Developed billing scripts and reports

• Developed back-end logic for business applications through procedures/functions

• Responsible for the delivery of SQL queries for customized reports

• Implemented views, procedures, functions, packages

• Responsible for assisting with the conversion of data from legacy systems and spreadsheets.

• Responsible for creation of tables, views in the employee and payroll modules

• Created database packages for payroll processing.

Education and Credentials

B.Sc. (Math), Madurai Kamaraj University, India

M.Sc. (Computer Science), Madurai Kamaraj University, India

Contact this candidate