Manager Sales

Teja.S

618-***-**** ********@*****.***

SYNOPSIS

• Over 8 years of extensive experience in complete Software Development Life Cycle (SDLC) including System Requirements Collection, Architecture, Design, Coding, Development, Testing, Production Support, Maintenance and Enhancement in variety of technological platforms with special emphasis Client/Server, Data Warehouse and Business Intelligence applications in Windows and Unix environments

• Experience in OBIEE 11.1.1.x, OBIEE 10.1.3.x, Oracle BI Applications 7.9.x, Siebel Analytics 7.7 which include building and configuring repository, creating and managing Oracle/Siebel Intelligent Dashboards, Oracle/Siebel Answers, Delivers, iBots/Agents.

• Experience in managing Enterprise Manager, Web Console in OBIEE 11.1.1.x

• Experience serving industrial segments that include Pharmaceutical, Finance, Insurance, Banking and Health Care.

• Experience in Metadata Modeling at all three layers (Physical, Business Model and Presentation) using the Oracle/Siebel Analytics Administration Tool.

• Experience on assigning Data security & User Interface level security to the users using OBIEE repository objects & external data base.

• Experienced in creating Intelligence Dashboards and reports based on the business requirements.

• Experience in Installation, Configuration, and Administration of OBIEE, Informatica Power Center 8.1.1/7.1.x.

• Experience with repository development, configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Folders, Reports). Added Metadata changes to the OBI/Siebel Analytics .rpd.

• Experienced in creating reports using the Oracle Essbase (Essbase) by integrating the Essbase with the OBIEE. Experienced in creating the Disconnected Analytics application for the online version of the repository and the reports.

• Experienced in creating highly formatted reports in Oracle BI Publisher by using Oracle BI Answers and Oracle BI Server metadata.

• Expertise in ETL methodology in Data Extraction, Transformation and Loading. Experience in Performance Tuning of sources, mappings, targets and sessions.

• Excellent Written and Verbal Skills; Results oriented and Self-Starter looking for challenges; Ability to rapidly learn and apply new technologies and improve processes: Self-motivated and results-oriented with solid work ethic.

TECHNICAL SKILLS SUMMARY:

OBIEE Development Tools OBIEE 11.1.1.6/11.1.1.5/11.1.1.3/10.1.3.X, Siebel Analytics 7.7/7.5

ETL Tools Informatica 8.x/7.x

Relational Databases Oracle 9i/10g/11g, SQL Server 2005, MS Access, Essbase

Languages C,C++, SQL,PL/SQL

Operating Systems Windows, UNIX

Methodologies Data modeling Logical/Physical, Star/Snowflake Schema, Dimension Tables, ETL, OLAP, SDLC

Web Technologies HTML, XML

EDUCATION:

• Bachelor of Technology in Electronics and Communication Engineering.

PROFESSIONAL EXPERIENCE:

Miami University, OH Jan 12 – Present

Sr. OBIEE Developer

Miami University is a public university with a student body of 16,000, effectively combines a wide range of strong academic programs with the personal attention ordinarily found only at much smaller institutions. Miami University is using OBIEE reports for better understanding of Revenue and Budget allocated to students, staff and Departments.

Responsibilities:

• Involved in building OBIEE Reports for VP, ETL and DBA sector and validating data for the reports.

• Responsible for Metadata design document (Physical Layer, Business Model and Mapping Layer

and Presentation Layer, Variables, Initialization Blocks, Dimension Hierarchies, Level Based

Measures) in the implementation phase.

• Worked on Physical, BMM and Presentation Layers to created ETL and DBA subject areas.

• Created Dimensional hierarchies in BMM Layer so that user can drill down through lower levels on the reports.

• Worked closely with users in resolving the bugs that were raised by them during Unit Testing of the analysis.

• Created Drill down and column selector reports for Revenue and Enrollment based reports.

• Resolved issues that were raised by the other developers while developing the new reports.

• Customized Dashboards, Administered Permissions and Privileges for Dashboard visibility and modifications to users.

• Involved with the testing to resolve, fixing and testing problems found during the system integration test and UAT phases.

Environment: OBIEE 11.1.1.6/11.1.1.5, Flat Files, Oracle 10g/11g, Windows XP, SQL Developer

Booz Allen Hamilton, VA July 10 – Dec 11

Sr. OBIEE Developer

Booz Allen Hamilton is a leading provider of management and technology consulting services to the US government in defense, intelligence, and civil markets. BAH has implemented OBIEE so that users can drill down to lower level of data in analyzing their data.

Responsibilities:

• Involved in gathering requirements with Users for Finance and People Services reports.

• Created and administered Physical Layer, Business Model and Mapping (BMM) Layer and Presentation Layer using Administration Tool for Finance and People Services reports.

• Created new sources (Different filters), logical columns and calculated columns in RPD.

• Designed external security table for Finance, Acquisition and People Services users so that users can able to login into OBIEE according to their security roles and data is filtered according to data filter.

• Designed external table for updating midmonth and End of month substitution variables data.

• Worked extensively in Customizing dashboards, Administered Permissions and Privileges for dashboard visibility and modifications to users.

• Involved in upgrading web catalog and RPD from OBIEE 10.1.4.2 to 11.1.1.3.

• Recreated reports in OBIEE 11.1.1.3 which were throwing errors after upgrading web catalog.

• Designed No Limits security model for users so that users can have different types of roles and able to access dashboards.

• Involved in deployment of reports and RPD from Dev to QA to Production

• Created new user Groups and Native Users in Web logic and Application roles in Enterprise Manager.

• Responsible for upgrading OBIEE 11.1.1.3 to 11.1.1.5 including RPD and catalog.

• Created Agents in OBIEE 11.1.1.3, so that whenever new data is loaded into cubes user will be notified about updated data in reports.

• Implemented OBIEE reports in IPAD using Oracle App so that managers can use these reports remotely.

• Worked closely with testing team in validating data, resolving bugs and formatting of Finance and People Services reports.

• Worked extensively on documenting Technical requirements document for all reports that were created

• Worked closely with Essbase team and data staging team to better understand cubes and oracle tables in creating new reports.

Environment: OBIEE 11.1.1.x/10.1.3.x, Flat Files, Oracle 10g, Essbase, Windows XP, Toad.

Eli Lilly, IN May 09 – July 10

Sr. OBIEE Developer

Lilly is the 10th largest pharmaceutical company in the world. Across the globe, Lilly has developed productive alliances and partnerships that advance their capacity to develop innovative medicines at lower costs. Lilly has implemented the OBIEE in order to provide the Lilly Sales Reps in analyzing their Sales data and to analyze their daily Call activities with the HCP’s and accounts and for the Medical people to analyze their daily Interactions with the HCP’s.

Responsibilities:

• Worked closely with Business Analyst and Sales Reps in understanding the Analytics requirements and generated reports as per the user requirements.

• Installed the Essbase Client software and integrated the Oracle Essbase with the OBIEE for the Sales data and to create the Sales reports for the Reps.

• Worked extensively in the MUD environment for Configuring OBIEE Repository like implementation of Physical data model as per requirements, imported the tables from the Siebel OLTP, OLAP, databases and having the physical joins/keys required and changed the physical joins/key on the existing tables.

• Created the different projects in BMM layer by creating the logical joins and by identifying the new facts and dimensions. Created the presentation layer according to the reports specifications.

• Created session variables, repository variables and initialization blocks in the repository building and modification procedures. Added the specific user groups in the security manager regarding the BI Publisher reports.

• Created the reports according to the Sales Reps specific, District manager specific and Operations user specific.

• Created the Sales reports using the Essbase for the Monthly Sales data, Quarterly Sales data and 12 months of data. Created the daily Call activity reports using the Siebel OLTP data and monthly Call reports using the OLAP Database.

• Created the monthly account based reports by integrating the Calls and Sales Data in the single report by using the union function. By using the repository variables in the reports attained the 12 months of the previous months from the current month.

• Implemented the Guided Navigation for the specific reports which has to be shifted according to the selection of the prompts(Sales or Units)

• Implemented the security for the reports by using the session variables so that whenever the Reps login into the analytics they can see their specific data.

• Created the Disconnected Analytics application for the online reports for the Sales Reps.

• Created the Account Profile reports, HCP Profile reports for different Business Divisions using the Oracle BI Publisher. And created these BI publisher reports in the Disconnected Analytics application using the OBI Answers.

• Developed the reports for the specific users and delivered the reports to their E-mails by creating the ibots on the daily basis.

• Formatted each and every report as the end user specific.

• Worked extensively with the testing team in resolving the defects that were raised by them. Worked with the performance testing team in fine tuning the reports.

• Extensively worked on the Documentation of the System Requirements document, User Specific document, Repository Design Document and Report Validation document.

Environment: OBIEE 10.1.3.4.0/10.1.3.4.1, Flat Files, Oracle 10g, Essbase, Windows XP, Toad.

Fitch Ratings Inc, NY Apr 08 – Mar 09

OBIEE Developer

Fitch Ratings is a leading global rating agency committed to providing the world's credit markets with independent, timely and prospective credit opinions. Fitch Ratings implemented Oracle Bi Apps in order to provide reporting and analyzing the records of projects, funds utilization and data for the better management.

Responsibilities:

• Involved with management professionals, analysts as well as other business teams on requirement gathering.

• Worked extensively on Oracle Service Analytics to provide a comprehensive customer service solution to the customers.

• Effectively managed ODBC connections and imported the Physical tables, keys and foreign keys.

• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.

• Created the Dimension Hierarchies and Level Based Measures in the BMM Layer according to the end user requirements.

• Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business Model and Mapping layer.

• Established the logical joins/keys required to support drill-down aggregation.

• Configured advanced Navigation reports, guided navigation link, Union reports etc.

• Implemented the delivery of iBots using OBI Delivers to alert the associated teams.

• Involved in developing Initial and Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions/Tasks

• Implemented security by creating roles, checks with LDAP Authentication.

• Presented the overall rpd metadata development methodology.

• Provided views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc. Weekly status reports to the senior manager.

• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views.

• Created reports on Travel Expenses, Time sheets, Funds Utilization in various projects, Revenue analysis.

• Applied various function formulas in the building the reports in the Oracle BI Answers.

• Created mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and Update Strategy to store the data in target table.

• Performing Testing of the IT Defects raised by the Testing team.

• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems.

Environment: OBIEE 10.1.3.2, Informatica 8.1.1/7.1.4, Oracle BI Apps(Service Analytics), DAC, Flat Files, Oracle 10g, UNIX, Windows XP, SQL server 2000, MS Office 2003, SQL Loader

Liberty Mutual, IN Sep 07- Mar 08

OBIEE/Informatica Developer

Liberty Mutual is one of the major automobile, homeowners Insurance Providers in the United States. The scope of the project is to develop operational and analytical reports using Oracle Business Analytics. Reports and Dashboards are developed using OBIEE. The ETL part is handled by using Informatica 7.1. And Oracle 10g is the Database used where the Facets supports all the Relational Database.

Responsibilities:

• Involved with the Business Analytics in gathering the requirements from various Business teams.

• Created the OBIEE Repository by importing the new tables in the Physical Layer and in the BMM Layer Identified Facts and Dimensions according to the design specification.

• Implemented complex requirements like Dimension hierarchies, time comparisons.

• Customized and developed the OBIEE Business Model and Mapping layer.

• Worked with Oracle BI Apps prebuilt like Financial Analytics to monitor operational effectiveness.

• With the Financial Analytics we improved the financial performance of the department’s expenses and revenues.

• Implemented caching and aggregate table techniques to improve the performance.

• Architected and implemented mapping for slowly changing dimension design.

• Tested and validated the repository integrity with global consistency check feature.

• Worked extensively on OBIEE Presentation Services to create the reports as per the client requirements.

• Worked extensively to develop Dashboards and Reports so as to meet the Functional Requirements.

• Created, modified and formatted requests, along with charts and filters, in OBIEE Answers

• Developed various kinds of reports in various views for better user readability.

• Created various user groups and assigned them appropriate permissions and privileges.

• Utilized Siebel Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.

• Worked with Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor.

• Used DAC (Data ware Administration Console) for both incremental and full loads.

• Created custom Execution plans using DAC.

• Fine-tuned Informatica jobs by optimizing all transformations.

Environment: OBIEE 10.1.3.x, Siebel Business analytics 7.7, Informatica 7.1, Oracle 10g, UNIX, Windows XP, DAC, PL/SQL developer.

PNC Bank, PA Oct 06 – Aug 07

Siebel Analytics developer

The purpose of this project is to assist sales and marketing Department to calculate their market share in different segments based on geographical area. Also help the Management to forecast their markets accurately, Identify the factors that most impact each segment's profitability. The project is focused on developing various detail and summary reports that will prove helpful for the sales and marketing teams.

Responsibilities:

• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer in a Siebel Analytics repository.

• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.

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

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

• Configure and interactive Dashboards to alert the Marketing team about business changes .

• Managed day-to-day Rpd, Siebel Delivers, Scheduler & iBots.

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

• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.

• Handled Full load and refresh load via staging tables in the ETL Layer.

• Involved in Design and Data Modeling using Star schema.

• Designed & assisted Informatica ETL developer to create new Aggregate.

• Created Informatica mappings for initial load and daily updates.

• Developed several mappings to load data from multiple sources to data warehouse.

• Developed, tested Store procedures, Functions and packages in PL/SQL for Data ETL

• Performed Data conversions.

Environment: Siebel Analytics 7.5.2, Informatica 6.1, Oracle 10g, UNIX, SQL server, Windows NT 2000.

ROCHE PHARMA, NJ AUG 05 – SEP 06

Siebel Analytics Application Developer

The purpose of this project is to maintain and manage all possible distribution scenarios including commission payments of Sales Reps. for internal, external and third party clients. The reporting requirements are handled using Siebel Analytics.

Responsibilities:

• Used the Siebel Analytics Admin Tool to develop the 3 layers in the Repository

• Created connection pools, physical tables and defined Primary key

Foreign key joins, complex joins in the physical layer of the repository.

• Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements.

• Created and modified logical tables, logical columns and defined

Foreign-keys and complex joins.

• Created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys.

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

• Created Mappings, Sessions and Workflows by using Informatica.

• Defined additional views (compound, table, chart views) of the data returned by the request to visualize data in many different ways.

• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.

• Created global filters for use in exercising dashboard wide control over requests that are embedded into a dashboard page.

• Created Proactive agents (iBots) and configured Interactive dashboards

to alert the employees as per the requirements.

• Used various Transformations like Router, Update Strategy, Lookup, Filter, Aggregator, and Expression for the exact results according to Business Requirements.

• Using Workflow Manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.

• Formatted columns used in generating the requests and used various filtering options as and when needed.

• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.

• Worked on improving the dashboard performance, readability, and security.

Environment: Siebel Analytics 7.8/7.7.1, Oracle 9i, Informatica 6.2, UNIX, Windows 2k.

Industrial Development Bank of India (IDBI), India Feb 04 – Jun 05

Data warehouse Developer

Over the years, IDBI has enlarged its basket of products and services to industrial concerns, covering almost the entire spectrum of industrial activities, including manufacturing and services. The project is designed for maintenance of loans given to various firms and to generate reports.

Responsibilities:

• Extracted data from Oracle, Flat files, Sql Server using Informatica Power Center.

• Implemented business data mart with OLAP functionality.

• Implemented Aggregate, Filter, Joiner, Expression, Sorter, Lookup and Update Strategy, Normalizer, Sequence generator transformations.

• Created Mapplets in Designer and used those Mapplets in the Mappings.

• Used debugger to test the mapping and fixed the bugs.

• Executed sessions, sequential and concurrent batches for proper execution of mappings and sent e-mail using server manager.

• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.

• Used the Workflow manager to create Workflows, Worklets and Tasks.

• Documented Informatica mappings, design and validation rules.

• Tuned the mappings to improve the performance of the ETL process.

• Partitioned source data and performed extract, transformation and load for each partition in parallel using an Informatica server for achieving high performance.

• Proficiency of writing complex SQL queries and demonstrated ability to collaborate with other developers during design, development, and testing.

• Created and Monitored Sessions and Batches using Server Manager to load the data into the Target Database.

Environment: Informatica Power Center 6.2(Designer, Workflow Manger, Workflow Monitor and Repository Manager), SQL Server 2000/2005, Oracle 8i/7i, Windows 2000.

Contact this candidate