Project Manager Data

Dharaneendra

Rambhatla

************@*****.*** 248-***-****

Summary:

Over 11 years of experience in IT with focused experience in analysis,

design, development, Installation and configuration on Linux and Windows

platforms, implementation and customization of OBIEE/Siebel Analytics

involved in all phases of Software Development Life Cycle (SDLC).

> Experience in Oracle Applications 11i, Peoplesoft 8.9 with AP, AR, GL

modules and BI Apps 7.9.6.1, 7.9.6.2 and 7.9.6.3 with Informatica

8.x/9.x and DAC.

> Experience in Oracle OBIEE (11g & 10g), Oracle BI Answers, Oracle BI

Dashboard implementation, Weblogic Server Administration, BI Publisher

11g/10g, and Oracle Discoverer.

> Experience in ETL data integration and Data Warehouse experience using

Informatica Powercenter 8.x/9.x.

> Experience in Business Model development with Dimensions, Hierarchies,

Measures, Aggregation, Time Series and Cache Management.

> Experience in building repositories, developing Subject Areas and

applying security at object and data level in OBIEE Administration

tool.

> Experience in analyzing and designing customized analytical reports

and creating Interactive Dashboards with drill down capabilities using

OBIEE.

> Experience in Siebel Analytics 7.8 which include building and

configuring repository, creating and managing Oracle/Siebel

Intelligent Dashboards, Oracle/Siebel Answers, Delivers and iBots.

> Extensive experience in dealing with databases like Oracle 11gR2, R1,

10gR3, R2, R1/9i/8i/ under RHEL (3.x,4.x,5.x), Suse Linux, Fedora,

CentOS and Windows 7/XP/2000/NT and server environments.

> Strong understanding of the process of designing and developing OLTP,

OLAP, Relational and dimensional (STAR and Snowflake) data modeling.

Certifications:

Oracle Database 10g Administrator Certified Associate

SAS Certified Analyst

Microsoft Certified Systems Engineer (MCSE)

Cisco Certified Network Associate (CCNA)

Technical Skills:

BI Tools

Oracle Business Intelligence Enterprise Edition (OBIEE 11g/10g ), Oracle

BI Server, Oracle Presentation Server, Oracle BI Answers, Oracle BI

Interactive Dashboards, BI publisher, Oracle BI Administration, Siebel 7.x

Administration Tool and Analytics, Informatica Powercenter Server/ Client

8.x, Datawarehouse Administration Console(DAC) and SAS.

Operating systems

Proficient in working with Red Hat Enterprise Linux 3.x, 4.x, 5.x, 7.x,

Fedora Core, Cent OS 4x&5x and other similar flavors of Linux (both

Enterprise and Standard editions), Windows 2003/08 Server, Windows 7/XP,

Windows 2000 Advance Server, Windows 2000 Server, Windows 2000 Terminal

Server, Window NT 4.0 Server, Windows 98.

Languages/Web Related

Familiar with Perl Scripting, Python, SQL, T-SQL, PL/SQL, HTML, XML,

Apache and Tomcat web servers (Windows)

RDBMS:

Oracle 11gR1, R2, 10gR1, R2, 9i/8x/7x, DB2, Sybase and SQL Server

2000/08, MS Access

---

Professional Experience:

Franklin Templeton Investments, Dublin, CA

Feb 2013-Till Date

Senior BI Architect

Project: Investment Analysis/ Financial Analytics(Treasury GL

Reconciliation)

As a senior BI Developer, my role was to design reports for Franklin

Templeton Investments enabling them to submit their annual filings to the

Securities and Exchange Commission faster and also design reports which

would provide them insight into their holdings of various investment

instruments on a quarterly basis, which in turn would help them in

reconciliation of their data submitted to the Securities and Exchange

Commission.

Functions:

. Install and configure 11.1.1.6 environment and upgrade existing 10g

infrastructure ( RPD and Catalog) to the newer environment.

. Upgrade/Install BI Apps 7.9.6.3 for Financial Analytics, primarily for

General Ledger usage in order for reconciliation of Treasury Data,

configured and customized ETL mappings and DAC to extract data from

custom investment foundation tables to load into the warehouse.

. Design customized warehouse for holding data coming directly from

Peoplesoft system and Nvision Excel forms for Disclosure reports like

10k and 10Q to be filed to SEC.

. Designed and built a completely custom Repository for modules like

Treasury, Portfolio Holdings, OCI and OTTI Investments.

. Worked simultaneously on customization of prebuilt GL reports like

Balance sheet and Income statement which included purchases of

securities comprising of multiple layer of funds and deals, and, on

Investment reports like Disclosure,10K,10Q,Investment Footnote and

Investment Breakdown.

Senior BI Architect NYU Medical Center, NYC

Jul 2012-Feb 2013

Project: Financial Analytics

Acting as a senior BI Developer, my primary role was to validate data for

Accounts Payable and General Ledger incorrectly designed by a previous

vendor company, build analyses based off of that data and other

requirements provided and also work on a lot of customized analyses which

were not in accordance with dimensional modeling.

Functions:

. Responsible for implementing a lot of customized analyses from the

start of the BI cycle acting both as a Business Analyst and gathering

requirements directly from user and also developing it,validating it

and pushing it to production.

. Used Informatica as the ETL tool to process and extract data from

multiple sources such as Peoplesoft database, flat files, Access

database and load data into multiple target warehouse databases and

configuring the corresponding subject areas and Execution Plans in DAC

accordingly.

. Utilize existing prebuilt Financial Analytics metadata repository to

validate and create various reports/Dashboards like AP Aging Reports,

Top 10 Vendors, Invoices by Volume, Cash Requirements, Match

Exceptions, Debit/Credit Report, Onbase and Payments by Method

utilizing various subject areas like AP, GL and Proc & Spend for the

NYU Financial Executive Dashboard specifically designed for the VP

Finance.

. Responsible for not only designing reports based on user requirements

but educating user about the various features of 11g and utilizing few

of them to leverage the existing reports such as custom groups in

presentation layer, presentation hierarchies, and Action Links for

multiple layer drills .

BI Architect/Technical Lead Freddie Mac, VA

Jul 2011-Jun 15th,2012

Project: Human Capital Management Analytics and Financial Analytics(Tech

Lead)

Acting as a Technical Lead, am responsible for the entire Design and

Planning of both HCM and FDM projects simultaneously and how the project

will be implemented right from the Strategy and Planning phase till the

Deployment Phase, acting as a developer and architect at the same time.

Source systems are Peoplesoft HCM 9.1 and 8.9 for Finance.

Functions:

. Designed and deployed Proof of Concept for the business users which

enabled them to have a clear picture of what the product could deliver

and aid in FIT/GAP Analysis. Performed this for both HR and Financial

Analytics projects.

. Performed GAP analysis working closely with the business analysts and

converted relevant functional requirements to technical which would

aid in report generation and also worked on estimating LOE for both

the projects.

. Used Informatica as the ETL tool to process and extract data from

multiple sources such as Peoplesoft database and flat files, and load

data into target warehouse and configuring the corresponding subject

areas and Execution Plans in DAC. Modified pre-built mappings in order

to import delivered and custom trees from Peoplesoft for relevant

data to get populated into the target tables, as the reports were

integrated with the tree structure.

. Utilize existing prebuilt HR and Financial Analytics repository to

create various reports/Dashboards like Employee Demographic Roster,

Headcount by Demographics, Pay Details, Earnings Detail, Balance

Sheet, Cash Flow, Income Statement using BI Answers.

. Responsible for proposal and implementation of bottom up approach of a

customized warehouse and metadata repository, so that business users

can create reports on their own.

. Responsible for implementation of security within BI Answers by

creating various security groups and users and implement Data and

Object level security.

. Integrate BI Publisher as the front end tool for report display to

Executive Committee instead of the delivered Dashboards.

. Responsible for Training the entire group of business users and also

for the technical documentation of the entire development process

through the various stages.

Senior OBIEE Developer Georgia State DBHDD, GA

Dec 2010-Jun 2011

Project: CIMS (Consumer Invoice Management System)

Design and Develop reports as a BI developer in a fixed price project which

would help in providing a major spectrum of insight on how DBHDD

(Department of Behavioral Health and Developmental Disabilities) could

manage its consumers and suppliers/providers of medical equipment to

affiliated hospitals within the State of Georgia through an integrated

invoice management system.

Functions:

. Responsible for development using OBIEE suite throughout the project

life cycle and aid in Integrating Consumer repository with invoice

management capabilities that gathers organizes and presents

consumer/supplier information in a way that assists DBHDD in

assessing, managing and planning services for various state wide

hospitals.

. Performed GAP analysis working closely with the business analysts and

converted relevant functional requirements to technical which would

aid in report generation.

. Use Informatica ETL process to extract data from disparate sources

such as OracleEBS, Peoplesoft and flat files, modify pre-built

mappings, add new ports, tables, filters and transformations, and load

data into target systems and configuring the corresponding workflows

in DAC for execution and monitoring purposes.

. Used DAC to configure and monitor the sessions and ran weekly loads to

update the data in the data warehouse.

. Utilize existing prebuilt Financial Analytics repository to create

various reports/Dashboards like Company Summary, Payables Summary,

Receivables Summary, customized sub-reports like Special Handling

Invoice Volume, COL Adjustment Volumes and Credit Release Volume and

Average Contract Run Rate using BI Answers.

. Responsible for implementation of security within BI Answers by

creating various security groups and users and implement Data and

Object level security based on requirement and Virtual Private

Database (VPD) for a couple of existing BI Publisher reports.

. Enhanced performance of reports/Dashboards by implementing Aggregate

tables, Materialized views, minimizing Junk and Degenerate dimensions

within the data model.

. Deployed reports across various stages from QA, Testing and Production

involving various state representatives at Provider and Consumer

level.

. Responsible for technical documentation of the entire development

process through the various stages.

OBIEE Report Developer Beckman Coulter, FL

Aug 2009 - Nov 2010

Project: Customer Product Feedback Analysis System

Design and develop reports for Beckman to assist analysis of their product

line and various metrics involved based on customer feedback, thus aiding

them to improve customer service.

Functions:

. Responsible for gathering requirement both functional and technical by

associating with the business analysts about the current and projected

state of product service trend to the project manager (confined to the

DxH product line).

. Involved in ETL process primarily customization of various mappings in

Informatica from various source file systems such as

OracleEBS,PeopleSoft and flat files.

. Involved in repository (rpd) modeling, which includes building star

schema as per the business requirements and configuration of Logical

Tables, dimensions and columns in BMM Layer.

. Created and customized various Reports and Dashboards for various user

groups and scheduled iBots for delivering personalized reports to

those users on time.

. Implemented OBIEE security feature at data and object level.

. Created customized reports using BI Publisher using Data Template

designs, Data Mapping and BI Server Administration.

. Modified existing seeded templates using BI Publisher for required

customized output reports.

. Performed Conversion of Oracle Reports (Customer, Sales, Invoice,) to

be used using the corresponding utility in BI Publisher.

. Involved in UAT (user acceptance testing) and production support for

BI Answers, Dashboard and Publisher reports for the entire DxH line of

products and corresponding data.

. Created user manuals and troubleshooting guides in form of Wiki pages.

Oracle BI Developer D E Shaw & Co,

NYC Dec 2006 -Aug 2009

Project: Hedge Funds Customer Investment Analysis Reporting

Primary focus involved pulling customer investment data from enterprise

customized data warehouse and present information to the users in a

meaningful way to improve decision making.

Functions:

. Worked with business users to capture business requirements and

performed GAP analysis.

. Experience on OBIEE metadata development which includes Physical,

Business Model and Mapping and Presentation Layer using OBIEE

Administration tool

. Implemented recommended design principles and best practices for

Dashboards and Reports Development

. Analyzed and worked on Uniform and Ragged hierarchy in physical and

business layer

. Created reports using different Views and Selectors

. Configured Dashboard page visibility as per business rules

. Created pre-built reports using BI Publisher

. Integrated BI Publisher reports based on Answers requests and BI

metadata Subject Areas

. Debug SQL queries issued during report execution in case of any issues

. Worked on performance tuning of the reports and metadata by following

the best practices suggestions by Oracle

. Involved with Data Architects on logical and physical model designs

and understanding data models for OLTP and OLAP

. Utilizing ETL application Informatica Client to analyze data necessary

to resolve issues uncovered and related to various source data and

related transformations.

. Involved in User Acceptance Testing (UAT) for Web catalog objects

Siebel Analytics Developer

Project: Stock Pricing Instrument and Asset Management Reporting

Primary focus involved gathering and translating stock price variable

quotes data and corresponding investment rate management and generate

reports for better decision making by traders.

Functions:

. Gathered and refined requirements from the business users.

. Installed and Configured Siebel Analytics

. Configured Column and Dashboard filters in Siebel Analytics

requirement validation of reports and drilldowns.

. Developed Assets, Risk, Portfolio, Entitlements Subject Areas using

Siebel Analytics/Answers

. Created logical tables and assigned levels and custom aggregation

rules

. Used Catalog Manager to manage work between various directories

. Wrote SQL queries to test OLTP and OLAP databases based on

functionality changes

. Imported metadata into the Physical layer, applied business rules in

the Business Modeling and Mapping Layer, created customized user views

and set up catalog folders in the Presentation layer using

Administration tool.

. Developed Star schema as per business requirements

. Designed and developed new Subject Areas/Customizations

. Interacted with traders, developed and maintained Reports and

Dashboards

. Configured Analytics iBots and Scheduler

. Responsible for Daily/Weekly/Monthly on time report delivery to

traders

. Developed standalone reports using BI Publisher

. Performed ETL procedure to load data from different sources into data

warehouse using Repository Manager, Designer, Workflow Manager and

Workflow Monitor.

. Configured report level security and user interface designs

. Applied optimization techniques and tuned performance of reports

. Implemented caching to improve performance

Senior SAS Analyst

Project: Customer Stock Holdings Comparison and Trend Analysis

The aim of the project was to address customer analytical needs to enhance

strategic business requirements mainly for stock holdings comparison &

strategic planning; thus facilitates decision support systems knowing the

business requirements precisely.

Functions:

. Extracted data using SAS as an ETL tool from large flat (xls, csv)

files and transaction databases.

. Study decision-makers for business model, transformed & loaded data

from transactional databases and generated numerous analytic reports.

. Develop and validate standard/ad-hoc SAS macros for automatic running

of stock holding frequency report for each financial composition

. Developing reports using Proc REPORT, Proc TABULATE, Proc FREQ and

Proc MEANS

. Used SAS macros and procedures like Proc SQL, Transpose, Univariate,

Means, Freq

. Used Proc GPLOT, Proc GCHART for graphical presentation of the data in

the form of Bar charts, Pie Charts and Scatter Plots.

SAS Analyst 9i Solutions, India

Oct 2002 - Sep 2006

Functions:

. Analyze business requirements with multiple various user communities

. Maintain and code SAS programs for evaluation and validation of

incoming clinical data

. Code and test SAS programs to create Clinical Summary reports

. Perform diverse analysis, code and test SAS programs using Proc

Tabulate, Proc Report and Data_Null

. Sorting and Merging on data sets and code them using Proc SQL and

SAS macro facility to get required output

. Generate various tables, listings and graphs in SAS and manipulate

and clean up data

. Provide general SAS programming support

. Create SAS datasets from Excel using Proc Import and Import Wizard

. Identify and correct data step syntax and programming logic errors

Education:

Masters in Information Technology and Computer Applications-2004

B. Sc (Bachelors of Science in Information Technology) -2002

Professional References:

Available on request. [pic][pic][pic][pic]

Contact this candidate