Manager Data

SUJITH REDDY

Email : ******.*******@*****.***

PROFESSIONAL SUMMARY:

• 8+ Years of Complete Software Development Life Cycle implementation

experience of Data Warehouse/ Datamart and Business Intelligence using Oracle

Business Intelligence (OBIEE), Siebel Analytics, Siebel Data Warehouse/Analytics

Applications and Informatica .

• Experienced for 5+ years in the dome of Business Intelligence (OBIEE/Siebel

Analytics), and in designing & developing Business Intelligence solutions.

• Expert in working with OBIEE/Siebel administration tool developing metadata repository

and strong experience in working with Oracle BI answers, Oracle BI dashboards and

Oracle BI Delivers.

• Excellent understanding of OLTP/OLAP System Study, Analysis and developing

Database Schemas like Star schema and Snowflake schema.

• Expert in implementing the Oracle BI Security Setup (groups, data access/query

privileges).

• Expertise in creating Object Level Security and Row Level Security at the repository

level.

• Proficient in developing OBIEE/Siebel Analytics Time Series Objects, Interactive

Dashboards with Drill down capabilities using global and local Filters, configuring

OBIEE Metadata objects (Subject Area, Table, Column), Presentation Services/Web

Catalog objects (Dashboards, Pages, Folders, Reports ), Scheduling iBots or

Schedulers and OBI Cluster Controller.

• Reports/Dashboards with different analytics view (Drill

Developed many

Down/Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector,

Tabular with global and local Filters) using OBIEE/Siebel Analytics Web ).

• Expertise in OBIEE features like cash, usage tracking, dimensional hierarchy,

aggregate navigation, variables /initialization blocks configuration, Dim extensions,

physical and logical data modeling.

• Configured the NQSCONFIG.INI file for usage tracking using direct insertion.

• debugging optimizing OBIEE/Siebel Analytics

Expertise in and the

Dashboards/Reports.

• Hands on experience in Authentication and Authorization of OBIEE by using LDAP,

Database authentication, External Authentication and also implemented Single Sign

on (SSO).

• Hands on experience in Oracle BIEE testing, unit testing, report data validation, report

data testing based on SQL results, OBIEE query log data validation.

• Experienced with OBIEE 11g, took part in the upgradation of OBIEE 10g to OBIEE 11g.

• Extensively Worked on BI Publisher importing data from multiple data sources and

delivered Reports, common dashboards, metadata, security, calculation, caching, and

intelligent request generation services.

• Created, Enhanced and troubleshoot reports on BI Publisher.

• Extensive Experience in Data Warehousing development using ETL tools such as

Informatica Power Center / Power Mart 8.x/7.x/ 6.x, SQL Server Integration Services

(SSIS) and DTS Packages.

• Creating Workflows with Worklets & various Tasks and scheduling them using both

Workflow Manager and DAC.

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

Servers, Slowly Changing Dimensions (SCD types).

• Expert in Unit, System and Integration Testing and Performed Data Validation for all the

ETL’s and reports generated from Informatica and OBIEE/Siebel Analytics. Exceptional

ability to quickly master new concepts, strong inter personal skills, good verbal and

written communication capabilities.

• Self motivated professional with strong problem solving, time management and

organizational skills

TECHNICAL SKILLS:

BI Tools : OBIEE 11g/10g, Siebel Analytics 7.X, BI Publisher 10.1.X

ETL Tools : SSIS, Informatica 6.x, 7.x., 8.x, DAC

Data Bases : Oracle9i/10g, MS SQL Server 05/00, MS Access, Teradata,

Exadata

Operating System : Windows 98/2000/NT/XP/Vista, Sun Solaris, IBM AIX, LINUX

Applications : MS Word, Excel, Outlook, FrontPage, PowerPoint, Dream weaver

Data Modeling : ERWIN, Microsoft VISIO

Other Tools : TOAD, SQL Developer

PROFESSIONAL EXPERIENCE:

Cox Communications, Atlanta, GA Dec’09 Present OBIEE

Consultant

Cox communications is the third largest cable provider in the nation, Cox Communications Inc. is

noted for its high capacity, reliable broadband delivery network as well as the company’s ability to

provide superior customer service. For Cox, it’s not about being the biggest; it’s about being the

best. With more than 6 million customers, over 22,000 employees and a firm commitment to

education, the Cox team is widely regarded as the best in the cable industry, having earned

multiple distinctions in customer satisfaction and company strategy. In 2006, Cox received highest

honor in in J.D. Power and Associates' residential cable/satellite TV customer satisfaction study

as well as in 2005 for customer satisfaction among high speed Internet service providers.

Responsibilities:

• Involved in architectural level performance improvement including tuning of parameters in

Oracle Application Server, Web Server and OBIEE.

• Initiated work on a sandbox implementation of current OBIEE environment in OBIEE11g.

• Performing changes in the OBIEE repository in physical, business mapping and model

layer and presentation layer.

• Creation of dashboards, answers reports and deployment. Configured many

dashboards with different Views (Pivot Table, Chart, Tabular and View Selector),

alerts, dynamic dashboard prompts and guided navigation links.

• Perform administrative functions in OBIEE involving migration, manage users/groups

and manage OBIEE environment.

• Creation of Technical Specs based on functional requirement.

• Performed performance tuning of Dashboards/Reports and made recommendations for

changes to database by implementing the materialized views, partitions and re

building of indexes.

• Work on security for users based on LDAP Authentication and SSO in production and

also other authentication types (External table authentication and Database) in other

environments.

• Responsible for training the end users in OBIEE Answers, Dashboard and mentoring

other junior developers.

• Configure iBots to deliver analytics content based on schedule, automated ibots

queries to obtain reports & sent notifications Alerts to Managers.

• Perform ETL development using IBM Data Stage 8.0.1.

• Worked with the business analyst/users to set up project plan and scope.

• Ensure the change management process is adhered and meets the quality requirements.

Environment: OBIEE 10.1.3.4.1/11g, OAS 10.1.3.4, Web Logic 11g,Windows Server 2003 R2, AIX

6.1, Oracle 10g, IBM Data Stage 8.0.1 and IBM DB2.

MasterCard, St.Louis, MO Apr’08 Nov’09

OBIEE Consultant

MasterCard St Louis region is a home to MasterCard’s Global Technology and Operations head

quarters. MasterCard is focusing its local giving on a pressing education issue that requires new

resources and innovative solutions. In this project OBIEE based reports were developed to

provide an effective presentation of different financial transactions for sales and marketing.

Responsibilities:

• Worked with Business Analyst and analyzed the business requirements for developing

the repository and extraction of reports.

• Analyzed the specifications provided by the client, understanding the business.

• Install, configure, and administer the OBIEE platform.

• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling

IBOTS and BI Publisher.

• Designed Star schema for fact & dimensional tables and created alias for the

dimension and fact tables when necessary.

• Developed Physical Layer, Business Model & Mapping and Presentation Layer using

Oracle BI Administration Tool.

• Specified Dimensional hierarchy, Aggregate levels for the dimensions.

• Developed different brand level Reports, Filters, and Prompts using Oracle BI

Answers.

• Used Filters (Global and Local) and provided customized prompts to avoid excessive

data showing up in the reports.

• Developed many Reports / Dashboards with different Analytics Views (Drill Down /

Dynamic, criteria filters, Pivot Table, Chart, Column Selector, Tabular with global and

local Filters) using Oracle BI Presentation Services.

• Involved in setting up methods of Usage Tracking using Direct Insertion and setting up

Log File. Merged the Usage Tracking Repository with the main repository to have

dashboard based usage tracking.

• Used the Catalog Manager and maintained the Analytics web catalog to manage

dashboards & answers.

• Designed and Configured Intelligent Dashboards in Analytics for different groups of

users, which include like Managers, functional heads, Department Heads.

• Managed Security privileges for each Subject area and Dashboards according to user

requirements

• Implemented Multi User Development Environment (MUD) for concurrent rpd

development. Developed and debugged many Dashboards using different Analytics

Views (Pivot Table, Chart, and Column Selector, View Selector), Dynamic / Interactive

Dashboards with drill down capabilities, charts, tabular using global and local Filters.

• Involved in System Integration Testing (SIT), User Acceptance testing (UAT) and

Production support.

• Involved in upgrading the database form 10g to 11g.

• Involved in leading the training sessions for the end user.

• Used transformations like Source Qualifier, Expression, Update Strategy, Look up,

Router, Filter, and Sequence Generator. etc.

• Configure Custom Workflows.

• Custom incremental mechanism applied to non application data

• Performance tuning done to all jobs

• Full mode / incremental migration is done across different instances

• Analyze DAC Execution Plan

• Tested execution Plan in both Incremental & Full Mode

• Parallel processing the ETL tasks that belong to same task order

• Performance tuning is achieved

• Exported the DAC repository in full / incremental mode (Logical, System & Run)

• Worked on BI Publisher Reporting

Environment: OBIEE 10.1.3.3/10.1.3.4, BI Publisher 10.1.3.4, Oracle 10g, SQL, SQL Server

2005, SQL Developer, Windows XP, UNIX.

Symantec, Sunnyvale, CA May’06 Mar’07

OBIEE Developer

Symantec has adopted a partner led services approach to help organizations manage IT risk and

maximize IT performance around Symantec solutions. This system was built with an objective to

help top level management in decision making. The data from different data marts is collected

and integrated into a data warehouse.

Responsibilities:

• Business requirement gathering, understanding business objectives and analysis.

• Analyzed the source data, made decisions on appropriate extraction, transformation

and loading strategies.

• Created mappings to perform the tasks such as cleaning the data and populate that into

staging tables, Populating the Enterprise Data Warehouse by transforming the data into

business needs & Populating the Data Mart with only required information.

• Used all Transformations such as Expressions, Filters, Joiners, aggregators, Lookups,

Update strategy, Sequence Generator, Routers and XML to load consistent data into

Database Using ETL Tool Informatica 8.x.

• Developed mappings / Reusable Objects / Transformation / Mapplets by using

mapping designer, transformation developer and mapplet designer in Informatica

Power Center 8.x

• Get the database connectivity and design the Physical Layer, Business model and

Mapping layer and the presentation layer in the repository (.rpd).

• Creating reports and publishing them in the dashboards using answers.

• Customized and developed repository, configured metadata objects (Subject area table

column) and web catalog Objects (Dashboards, Pages, Folders, and Reports.)

• Created Dimensional Hierarchy from Date, Facility and Location Dimensions, Level

based Measures and Aggregate navigation in BMM layer.

• Created hierarchies based on the territory level to territorial level sales and contact

reports.

• Used unconstrained filters, column filter prompts and various views such as Pivot tables.

• Added users to the new group and apply the data level security and object level security

at the rpd and Web cat.

• Configured Low Level Security to allow users to view data only according to this

requirement.

• Involved in the analysis of the existing system reports and modification of the reports,

created new reports based on the user requirements.

• Worked Extensively on OBIEE Administration Tool, Presentation Services, Answers,

& Interactive Dashboards and Security Implementation .

• Define iBots / Delivers for various requests if needed.

• Created reports in BI Publisher using PDF, RTF templates.

• Performed OBIEE Administration – including creation of users and cache

management.

• Requirements of the Business Analysts. Mapped the configurations to accommodate for

the territorial hierarchy that were accommodated via chart drilldowns.

• Merge Repositories two way and three way into mater repository from each developer.

• Merging Catalogs folders to master catalog using Catalog Manager.

• Implemented dynamic dashboard prompts to zoom into particular segments of the

business in a performance optimized manner.

• Developed many Dimensions and Time Series Objects with Security settings for

analyzing.

• Configured Repository and session variables to get dynamic reports and dashboards.

• Added new Dimensions and Columns to the Subject Areas to full fill the additional

Requirements of the Business Analysts. Mapped the configurations to accommodate for

the Territorial hierarchy that were accommodated via chart drilldowns.

• Implemented security by creating roles & web groups, External tables.

• Debugged reports and Dashboards visibility with respect to user’s responsibility and web

groups in an integrated environment.

• Worked on Obiee Administration like installation, configuration of Obiee Security External

Database, LDAP, Aggregate Table Configuration of nqsconfig file and also

Instanceconfig.xml files, Setup and Configure Obiee Delivers, Creating Materialized

Views, Setup Mude Environment Repository Merge, Catalog Merge, Deployment from

development to production.

Environment: OBIEE 10.1.3.3/10.1.3.4, Informatica 8.6 Oracle 10g, SQL, Windows 2003 Server,

Windows Services, UNIX, TOAD, PL/SQL.

Linco lnFinancial, Philadelphia, PA Jul’06 July’07 OBIEE

Developer/Siebel Developer

Lincoln Financial Group is leading the industry in redefining financial security for its customers.

The objective of the project is to build an Investment Management Data Mart using Informatica

Power Center and also to generate reports based on the data available in the Data Mart.

Responsibilities:

• Worked closely with Business Analysts in understanding the Business requirements.

• Effectively managed ODBC connections and imported the physical tables, keys and

foreign keys.

• Customized and developed the Logical layer, implemented logical column measures and

calculations.

• Implemented complex requirements like dimensioning, time comparison and sharing

measures along with rank measures.

• Utilized session variables, repository variables and initialization blocks in the

repository building and modification procedures.

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

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

requirements.

• Created, modified and formatted requests, along with charts and filters in answers.

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

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

Administered permissions and privileges for Dashboard visibility and modifications to

users based on their groups or responsibilities.

• Design and development of various Dashboards, reports that are dynamic and interactive

with drill down capabilities and local &global filters.

• Development of interactive flash based drillable charts such as bar charts, Pie charts,

radars, bubble charts, etc.

• Implemented dynamic dashboard prompts to zoom into particular segments of the

business in a performance optimized manner.

• Created Dimensional Hierarchies and modeled Slowly Changing Dimensions.

• Worked on cache purging strategy using event polling table cache purging technique.

Environment: Siebel analytics 7.X, DAC, Oracle 10g, Windows XP, TOAD, ERWIN, SQL,

PL/SQL.

Satya Informatics,India Jun’05 Apr’06 Siebel Analytics

Developer

Performance & Risk Data Mart (PRDM) was implemented for mortgage division to track different

kinds of key performance for indicators for their mortgage lending group. The data mart also

helped evaluate credit risk with the customer and also find new sales opportunities based on the

customer needs.

Responsibilities:

• Worked closely with Business Analyst, discussed and gathered the Analytics

requirements and created the Business Model using Star schemas.

• Used Administration Tool for customizing and modifying the physical, business and

presentation layers of metadata repository.

• Worked on Time Series Wizard and implemented time comparison measures.

• Used Filters and provided Prompts appropriately to avoid excessive data showing up

reports.

• Developed many Reports / Dashboards with different Analytics Views (Drill Down/

Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with

Global and local Filters) using answers.

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

requirements.

• Defined additional views (narrative, pivot, chart views) of the data returned by the request

to visualize data in many different ways.

• Configured Intelligence dashboards by adding content such as links/images, HTML

objects and folders.

• Implementation of Siebel Delivers using iBots for delivery of reports via email, hand held

devices and mobile phones.

• Maintained effectiveness in creating the Dashboards by appropriately including guided

navigational links and drilldowns.

• Used the Catalog manager and maintained the Analytics web catalog to manage

Dashboards, Answers.

• Assisted in creating Reusable and Non Reusable Mappings and Mapplets using Filters,

Aggregator, Lookups, and Expression Aggregator, Sequence generator, sorter, Joiner and

update strategy Transformation.

Environment: Siebel analytics 7.X, SQL Server 2005, Oracle 9i, SQL Server 2005, SQL*Plus,

TOAD, Windows XP/2003 Server.

EMINENT Technologies, India Apr’03 – May’05

ETL Developer

EMINENT provides end to end business solutions that leverage technology and also provide

solutions for a dynamic environment where business and technology strategies converge.

Employees Information System (EIS): EIS is for planning, maintaining and performance

evaluation of employee’s activities. The System keeps track of total man hours spent at different

levels, allows estimating overall cost of project and individual contribution for a given period.

Responsibilities:

• Involved in developing Logical and physical data models and performed forward and

reverse engineering using Erwin

• Used Informatica Power Center Designer, analyzed the source data to Extract &

Transform from various source systems by incorporating business rules using different

objects and functions that the tool supported.

• Using Informatica Power Center created maps and Mapplets to transform the data

according to the business rules.

• Created aggregator, expression, filter, joiner, lookup, stored procedure, source

qualifier, update strategy and sequence generator transformations.

• Performed Data cleansing using various SQL functions like LTRIM and RTRIM.

• Implemented slowly changing dimensions (SCD) as per requirement.

• Wrote stored procedures for dropping and re creating indexes for efficient Data Load.

• Documented Informatica mappings in Excel spread sheet.

• Tuned the Informatica mappings for optimal load performance.

• Involved in Creating tasks, workflows and Schedule, Run, Monitor sessions by using

workflow manager and workflow monitor.

• Experience in backup and restoring of Repository.

• Used pmcmd command to schedule sessions and batches and to recover the sessions.

• Developed UNIX shell scripts.

• Documented ETL Test plans, Test cases, Test Scripts, Assumptions and validations,

expected results cases.

Environment: Windows 98, MS Word, MS Visio, Oracle 8i/9i, SQL*PLUS, SQL Server 2000,

Pl/SQL and Crystal Reports.

Contact this candidate