Resume

Sr Business Analyst/ Web Developer

Location:

Grand Rapids, MI, 49612

Posted:

January 17, 2011

Contact this candidate

Resume:

Roopa Miriyala

pdiu32@r.postjobfree.com

(Ph No): 224-***-****

PROFESSIONAL SUMMARY:

• IT professional around 9 years of experience in application, designing, development and implementation of Siebel Analytics, Oracle Business Intelligence, ETL Tools and RDBMS projects.

• Very strong experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges) scheduling iBOTS and used BI Publisher to publish the reports.

• Worked Extensively on Oracle BI / Siebel Analytics Administration Tool, Siebel Analytics Web / Presentation Services, Answers, & Interactive Dashboards and Security Implementation

• Extensive Dimensional Modeling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables.

• Expertise in fine tuning reports by using view selector, column selector, is prompted, where ever necessary to increase performance.

• Extensive experience in building Interactive Dashboards with drill-down & drill-across capabilities using global & local Filters, Contextual Navigation, Guided Analytics, Business Rules with User Identity & Roles, Profiles & Personalization.

• Expertise in implementing the Oracle BI / Siebel Security Setup (groups, data access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).

• Expertise in handling OBIEE Server, OBIEE Presentation server configurations and skillful in debugging saw server log files for trouble shooting issues.

• Extensive experience in gathering business requirements by interacting with the business users.

• Developed complex mappings by extensively using the Informatica transformations and

flagging the records using the update strategy for populating the desired SCD tables.

• Used Workflow manager and Workflow monitor for Workflow, sessions and database

connection management and workflow monitoring.

• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI / Siebel Analytical Dashboards / Reports.

• Well-developed organizational and communication skills, with strength in inter-personal relationships Self-starter, result-oriented team player with an ability to manage multiple tasks simultaneously.

• Working with Business users as an Analyst to translate requirements into the OBIEE Analytics reporting structure.

• Understanding and experience with data modeling, data warehousing, ETL processing, database design, and performance tuning

• Good knowledge of writing queries for Teradata tables

• Have knowledge of building cubes in Essbase for faster retrieval of data

• Administered Usage Tracking, NQSCONFIG.INI and Instanceconfig.xml configuration files

• Multi-platform experience on UNIX / Linux and Windows Server family.

• Strong in Object Oriented and DW concepts

• Good Analytical, logical, communication & problem solving skills

• Can work independently, and as a team player

• Good in Microsoft Office tools – Excel, Word, Access

• Good in writing SQL queries

Educational Qualification:

• Masters in Computer Applications from Osmania University, India

• Bachelors of Computer Science from Osmania University, India

TECHNICAL SKILLS:

Analytics : OBIEE 10.3.1.x,,Siebel Analytics 7.x, BI Crystal Reports 8.*, Cognos 8.x

BI Publisher

RDBM : Oracle 8i/9i/10g/11i, MS SQL server, MS Access 7.0/2000

Language : SQL*PLUS 8.x/9.x, PL/SQL 8.x/9.x, C, C++, Java

Scripting : Shell, Perl, java script

OS : Linux/UNIX, Windows 95/98/NT/2000, Sun Solaris

Tools : Erwin, Toad, SQL Developer

Data Modeling : DAC (Data warehouse Administration Console)

Tools

RDBMS : Oracle 10g, 11g, DB2, MS SQL Server 2000 & 2005, MS Access 2000

Case Tools : Erwin, Visio, Oracle SQL Developer, TOAD

Languages : SQL, MDX, SQL, PL/SQL, HTML/XML, Java scripting

ETL Tool : Datanet (Amazon Internal ETL Tool), Informatica

Knowledge : Micro Strategy 9, ODI 10.x , Teradata, Essbase

Project Details:

Micro Strategy Migration to OBIEE

Oct 2009 – Till Date

Client - Amway (Ada MI)

Role - OBIEE Datawarehouse Architect

(Team Size – 5)

Description: OBIEE over North America data was mainly developed for some of the extra business functions required for the North America data. The Dashboard mainly depicts the Amway Agent and customer relationships. The Dashboard’s are useful to arrange the Agent’s into different categories based on the no of order’s they place for a customer or an agent.

• Involved in requirements gathering of the various work streams by meeting with the business

User’s and base lining the details and translate those requirements into a Data warehouse design.

• Was part of Team member’s Design Review meeting’s and other Production issue meetings to discuss and finalize on the Design approach.

• Expertise in Performance tuning of the queries and tracking the issues involved in the data warehouse ETL process.

• Experienced in Reporting/ DW Data analysis and Data validation process which will overcome maintenance overhead

• Worked with Data Engineering team to design Facts, Dimensions, Dimensional data Model, Data Structures(relational and OLAP) and Hierarchies of the business model.

• Experienced in working with Generation of XML data, upload the Templates in BI Publisher.

• Experienced in working with creating RTF templates in MS Word by connecting to BI Publisher, and publish these templates for the reports to view data in BI Publisher.

• Created Repository by building Physical Layer, Business Model and Mapping Layer, and

Presentation Layer using OBIEE Admin Tool..

• Created Dimensions, Aggregations and Levels using admin tool in the Business Model and

Mapping Layer.

• Creating complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over

columns.

• Modified presentation layer dimensions and attributes to match user requirements.

• Developed training material for the users to create their own Ad-hoc reports using Oracle BI Answers

• Used Filters (global and local) and provided customized Prompts to avoid excessive data

populating in the reports.

• Configured Intelligence dashboards by including embedded content such as links/images &

HTML objects.

• Implemented security by creating users & groups, setting up External Table Authentication,

creating Session Variables and Initialization Blocks and associated catalog objects and Web

modules with the created groups.

• Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots)

to subscribed users.

• Knowledge of debugging ODI extracts, transforms, procedures and loads to validate data.

Environment: OBIEE 10.1.3.4, SQL Server 2008, Linux RHEL 5, ODI 10.x

Amazon Analytics Dashboard-Kindle Analytics

Feb 2008 – Sep 2009

Client – Amazon.com (Seattle WA)

Role - OBIEE Lead Administrator

(Team Size 6 (4 Onsite 2 Offshore)

Description: Kindle analytics Dashboard was separately built to analysis kindle collection, newly added kindle books, approved books and suppressed books for a publisher. After kindle was launched in more than 200+ countries, measuring kindle collection across countries and publishers who publish the kindle version of the books was really important.

This Dashboard solves the purpose of collection of kindle books.

Responsibilities:

• To Manage Onsite-Offshore Team in terms of Development of new tasks, migrating them to QA and Production boxes and to mange Support activities for the existing environment.

• To drive weekly meeting to discuss the Production and other major issues and to design the solution for the re-occurring problems

• Have experience in Installing OBIEE server, configuring IBOTS in Linux environments.

• Responsible for administration and migration of repositories and catalog between Development, Test (QA) and Production environments

• Granting permissions to specified users to Specified folders/ subject Areas/ Dashboards/Dashboard Pages

• Have experience in merging of Individual Subject Areas across Dev/QA/Prod Environments

• Involved in installing OBIEE for Linux systems, and involved in cluster configuration to handle backup issues. Migrating catalog/Repositories from Development environment to QA and from QA to Production Versions

• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.

• Worked on parameter passing mechanism across dashboards, which involves parameter passing from one dashboard to other dashboard

• Involved in handling production support issues, and verifying sawserver logs for details errors.

• Designed and developed the Analytics Metadata Repository (.rpd) using Siebel Analytics Admin (Later migrated to Oracle BI EE) by importing the required objects (Dimensions, Facts & Aggregates) with integrity constraints into Physical Layer, developed multiple Dimensions (Drill-Down Hierarchies) & Logical & Facts / Measures objects in Business Model Layer and creating the Presentation catalogs in Presentation Layer

Worked on security for users based on LDAP Authentication type in Production and also other Authentication types (External table authentication and Database) in other environments.

• Configured Repository variables to generate dynamic reports.

• Configured session (system & non-system) variables to implement data level security.

Environment: OBIEE 10.1.3.4, Oracle 10GR2, Linux RHEL 5

Financial Analytics

May 2007 – Jan 2008

Client – Amazon.com (Seattle WA)

Role - Sr OBIEE/Architect

Description: This project is to develop financial reports(Daily, weekly, Monthly basis).this involves reports no of orders, ordered units, shipped items, cancelled items both through amaozn.com and other third party tools. Graphical representation of data provides higher level management easily to compare data across quarterly and yearly.

Responsible for

• Implemented prompts to provide dynamic filter condition to end users.

• Configured Repository variables to generate dynamic reports.

• Configured session (system & non-system) variables to implement data level security.

• Designed reporting environment that gives super users the ability to directly access the data warehouse to create new ad-hoc reports

• Development includes to: - Get the data base connectivity and design the physical layer the business model and mapping layer (BMML) and the presentation layer in the repository (rpd).

Implemented Security Groups and Roles using LDAP Authentication.

• Define ibots/delivers for various requests if needed.

Add users to the new group and apply the data level and object level security at Repository level as well as web level

• Developed Informatica mappings and mapplets to build key interfaces using transformations

(Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator) for

loading the data into data warehouse tables.

• Have knowledge of Teradata sql to query Teradata tables.

Environment: OBIEE 10.1.3.4, Oracle 10GR2, Informatica 8.x, Linux RHEL 5

Amazon Analytics Dashboard-Vendor Lead Time

Aug 2006 – Apr 2007

Client – Amazon.com (Seattle WA)

Role - OBIEE/Siebel Analyst Consultant

Description: This Project calculates the lead time for a Vendor from the time when PO is placed by Amazon, till it reaches Amazon fulfillment Center. Reports developed were basically used to find the glance views, demand for a hot product which is out of stock. Reports can be used to calculate the amount of freight needed to satisfy unplanned customer demand spikes. Business users can quickly view the information as data is categorized into different Organizations, Product Group category etc.

Responsible for

• Implemented prompts to provide dynamic filter condition to end users.

• Developed the Dimensions and Time Series Objects in the Business Model and Mapping Layer.

• Configured session (system & non-system) variables to implement data level security.

• Business requirements gathering data source analysis report dashboard analysis user subject area analysis all which involves detailed defining of fact and dimensions tables (star schema dimensional modeling is used) defining the hierarchies defining the aggregate levels transforming the business requirements to technical requirements and defining the security model.

• Development includes to: - Get the data base connectivity and design the physical layer the business model and mapping layer (BMML) and the presentation layer in the repository (rpd).

• Create the reports like Table, Chart, Pivot, filters and Narrative views and publish them in dash board using answers and dash boards.

• Define ibots/delivers for various requests if needed.

• Add users to the new group and apply the data level and object level security at Repository level as well as web level

Environment: OBIEE 10.1.3.4, Oracle 10GR2, Linux RHEL 5, Essbase 9.x

AMAZON ANALYTICS REPORT MIGRATION

Sep 2005 – Jul 2006

Client – Amazon.com (San Jose CA)

Role – OBIEE/Siebel Analyst Consultant

Description: Migration of Reports from Cognos to OBIEE without changing all the functionality of the reports

Migration of Reports from existing Cognos version to OBIEE involves entire process of analytics Data sets again and building repository and developing reports from scratch. Building reports without changing the functionality of the existing reports. Building Dashboards out of reports and deploying them. Involved in migration of DSF Dashboards, 3P selection, Warehouse Deals, Blackberry Reports etc.

Created internal Reports to track performance of queries, errors, TOP Usage of Dashboards, subject Areas, Users etc which will be helpful to track performance and Error tracking etc

Responsibilities:

• Implemented prompts to provide dynamic filter condition to end users.

• Configured Repository variables to generate dynamic reports.

• Configured session (system & non-system) variables to implement data level security.

• Development includes to: - Get the data base connectivity and design the physical layer the business model and mapping layer (BMML) and the presentation layer in the repository (rpd).

• Create the reports like Table, Chart, Pivot, filters and Narrative views and publish them in dash board using answers and dash boards.

• Define iBots/delivers for various requests if needed.

• Add users to the new group and apply the data level and object level security at Repository level as well as web level

Environment: OBIEE 10.1.3.4, Oracle 10GR2, Linux RHEL 5

Data Warehouse Platform Operations

Feb 2004– Aug 2005

Client – Baxter

Role – ETL Developer and Maintenance

Description: Developing and maintaining Data warehouse.

Data warehouse servers load data around the clock from remote instances. Snapshots commence once the local instance's work day has transpired--end of day. The data is extracted from SOURCE Tables and temporarily loaded in STAGE Tables, where major transformations take place , unwanted data which is not used for Business analysis will be eliminated here and later loaded into DW tables. These Tables are de-normalized and can be used to run aggregate transforms. Aggregated data can be used for by business analytics for decisions, Adhoc querying etc.

Responsible for:

• Using Pl/SQL and SQL code creating new ETL Transformations, mappings, mapplets, work flows and loading data into DW transforms.

• Executing Day-to-Day Operations which includes rerunning the jobs on failure, fixing the transformation for Edge cases and verifying data quality of the tables.

• Monitoring the jobs to meet our Service Level Agreement and to deliver tables on time.

• Handling users adhoc requests in our operational meeting (Office Hours)

• Tracking long running Transformations and Loads and was involved in fining tuning the sql queries.

Environment: Informatica, Oracle 10G, Linux RHEL 3

iGATE Global Solutions

Dec 2001 – Dec 2003

Tobacco Farmer Partnering Program

Client: Phillip Morris (Hyderabad India)

Role: Crystal Reports Developer

Description: This is a tobacco procurement project, and this mainly deals with the purchase of tobacco (Burley and Flue-cured) from the farmer till it reaches Production. This project maintains the details starting from the contracts made by the farmers, Purchasing of Tobacco at receiving stations, Various types of test performed to identify the quality of tobacco like Percentage of moisture present in tobacco, waste materials etc. based on which price varies. Later all the tobacco will be shipped to Warehouses End Of the Day. My role was to generate various reports using crystal reports tool.

Major types of Reports include:

New Farmers added to the business this year, for a particular Receiving station and the type of contract made.

Total amount of Lbs purchased on a particular day for a particular Receiving station

Responsible for

• Understanding Business Requirements and understanding them and developing desired solution in the form of procedure/queries and to develop reports based on them.

• Creating procedures which will group data from various sources at desire level and filter out unnecessary data at data base level.