ANJANA GUDAPATI

Current Location: Singapore

Contact: +65 92374290 / +65 63005606; E mail: acg5jx@r.postjobfree.com

B I Business I mplementation Lead /B I Solution Architect / Functional Analyst

w ith Commendable Credentia ls throughout Career

Seeking to be an effective contributor with a well established and globally reputed

organization

P roven credentials in…

B usiness Implementation ~Solution ~ Data Analysis ~ Data Modeling ~ Designing

E nterpr ise Data Warehouse

P ROF I L E G LA NCE

AT A

Dynamic career of 12+ years reflecting pioneering experience in Functional Analysis, Design,

Development, Testing & Implementation of Business Intelligence solutions using Various BI

Reporting Tools like (Cognos, Qlikview, BO).

Currently associated with H CL Technologies as Senior Technical /Solution Analyst.

In-depth knowledge in delivering and implementing technical solutions in Data Warehouse on

various reporting platforms as well as designing Enterprise Data Warehouse in Client / Server

environment; experienced in working on MIS, Basel 2 Regulatory, Pnl, Client Summary and Ad-hoc

reports.

Involved in evaluation, recommendation and deployment of best practices and technology solutions;

l iaising with stakeholders, customers, project team and IT department, ensuring that business

impacts of project are properly managed and communicated.

Possess advanced skills in executing simultaneous projects with geographically dispersed teams, with

p roven managerial acumen and abilities to withstand work pressures, deliver sustainable results

w ithin specified time without compromising on quality benchmarks.

A rea of Expe rtise B usiness / Systems Analysis ~ Requirement Collation & Elicitation ~ Software

Evaluation ~ Functional Assessment & Transformation ~ Functional Testing ~ Data Mart ~ Data

A nalysis ~ Data Modeling & Solutioning ~ Change Management ~ End User Training & User

Adoption ~ Team Management

C AREER H I G H L IG H TS

~ received O2 award for my outstanding performance continuously for two successful years, HCL,

Singapore (2013) ~

~ Valuable Player Award for contribution in F unding MIS Data mart p roject, HCL, Singapore (2012)

~

~ Live Wire Award for contribution i n Concentrix Data Warehouse p roject, HCL, Singapore (2011) ~

~ Valuable Team Player Award for contribution in Star Hub Data Warehouse p roject for Q3 from Star

H ub MD (2009) ~

~ Best Employee of the Month Award for Core Banking China DW project f rom MD, T&O Data

warehouse (2008) ~

~ Recognition Award for best performance and commitment to H R-IT Data mart project f rom HP,

Singapore (2007) ~

SCHO LAST ICS

Bachelor Degree in Electronics and

Communication

P ROFESSIONAL D EVE LOP ME N T

Ab-Initio Training, Boston, MA, USA Siebel Analytics Training, Siebel University,

Qlikview Training, HCL, Singapore Singapore

Cognos Report Net Training, Cognos, HCL,

Singapore

T EC H N ICAL SK I L LSET

Win 9x / Win NT / Win 2000 / XP and working knowledge of UNIX

Operating Systems

MS SQL Server 2008 & Oracle 8x, 9x and 10x, Teradata V2R5

RDB MS

Cognos Solution Implementation Methodologies, IBM BI Methodology

Technologies/Methodolog

ies

Qlikview, Cognos BI Suite of tools, Seagate Crystal Reports 8.0, Dashboard,

B I Tools

B usiness Objects

Cognos Transformation Server, MS SQL OLAP / Analysis Services

OLAP Modeling

MS Office, MS Project, Mercury Test Director, CA Erwin, VSS, Visio

Applications & Tools

Informatica and SSIS

ET L Tools

P ERSONAL D OSSIER

Date of Bi rth: 5th December 1979; L anguages: English, Hindi and French; P referred Location:

Singapore / Australia

References: Available on request

Projects Handled

dbPalace

P roject

Deutsche Bank

Client

HCL Technologies, Singapore

Organization

Sep 2012 – ti l l date

Du ration

25

Team Size

Oracle, Qlikview, Sparx enterprise architect, Cognos 10

Envi ronment

Role B I Business I mplementation Lead

Deutsche Bank which is one of the leading banks in Germany has a profit and loss reporting

D escription

solution for i ts middle office function. The functionality of the system is to collate information

f rom the numerous systems around the bank and use each system to reconcile until a single

P rofit and Loss figure can be reported but the P&L production across Detusche Bank has

h istorically suffered from inconsistent processes, convoluted architecture and in many areas, an

over reliance on EUDAs as well as data processing which results in considerable operational

r isk and manual effort spent on P&L production, reconciliations and reporting.

D B Palace and its data store (ODS) was developed for its first business roll-out (FX Derivatives)

2

w ith the intention from management to extend the coverage to many more trading businesses

was involved in extensive analysis and preparing the required due diligence documents and

a lso working with cross functional teams to prepare functional capabilities and requirements.

Engaging Key stake holders and understanding there pain points

Responsibiliti

Liaising with UK architectu re, Design Authority teams and Asia RTB teams to

es

u nderstand their daily Pnl Process and existing Eudas and prepare process maps.

Understanding the current business P&L production pain points, core functional needs,

d iscussing go l ive architecture and planning with stakeholders.

Updating management on weekly dashboard status & project r isks and recommending

solutions.

Responsible for development effort estimates, gap analysis, scope control, testing, training

and end-user support as per project methodology.

Analyzing requests for application patches /upgrades to determine impact on integrated

systems.

Understanding functional requi rements, preparing I n te rface solutions and

a ligning functional architectu ral gaps of ASIA.

Aligning the business rollouts in l ine with the Project Gantt

Funding M IS D ata ma rt

P roject

Deutsche Bank

Client

HCL Technologies, Singapore

Organization

Sept 2011 – Sept 2012

Du ration

15

Team Size

MS SQL Server 2008, Qlikview, SSIS packages

Envi ronment

Role B I P roject Lead \ Solution Architect

In Deutsche Bank AG Singapore, GBS Pnl production teams have no regular reports to monitor

Description

and control gaps in funding interest, this impacts accuracy of Pnl reported. Current approach

is ad-hoc, unstructured and time consuming. While business review was being done for

Singapore interest gap for other Non Japan Asia (NJA) locations spiked and the GBS CTB team

was engaged to conduct a fire drill to address the interest gap issue for those locations.

T he M I reporting involves large amounts of data gathering and consolidation from various

systems and stored in a data mart,for GBS-CTB team to facilitate the monitoring and analysis

of interest gap (IG) is IG by currency MI. the M I reporting is done now on Qlikview, which is a

near real time system. If there is a spike in interest gap in any NJA entity, the IG by currency

M I for that entity is prepared to help facilitate in identifying the issues in the entity. The aim of

t his project was to achieve a scalable, flexible automated and user friendly solution to identify

and monitor the causes of interest gap across entities which act as a golden source of

i nformation for funding related information for all entities.

Was responsible for understanding functional requi rements, business pain

Responsibiliti

es points and rest ructu ring the existing reports as per cur rent requi rement.

Liaised w ith CTB teams to understand functional requi rements.

Coordinated with the Cont rol Pack teams to understand thei r monthly report

p acks and spike highlights.

Documented the non-functional requi rements (scalability, pe rformance,

usability and security) as well as functional test scena rios, test plans and end-

user acceptance testing crite ria

Mapped business requi rements and t ransformed functional requi rements to

t echnical specifications.

I nvolved in development effort estimates, gap analysis, scope cont rol, testing,

t raining and end-user support as per project methodology.

P rovided ad-hoc data reports, promoted project methodology and

documentation standards.

Concentrix D ata Warehouse

P roject

Deutsche Bank

Client

HCL Technologies, Singapore

Organization

Jun 2010 – Sep 2011

Du ration

15

Team Size

MS SQL Server 2008, Cognos 8.4, SSIS packages, Erwin

Envi ronment

Role B I P roject Lead \ Solution Architect

Deutsche Bank the current Pnl is produced via Concentrix, in essence takes a number of feeds

D escription

f rom source systems. These systems include Trade capture, Risk calculations, Valuation and

settlement. By mapping the numerous systems together, a single trader's position can be viewed

i n a balance sheet l ike format. Currently the reporting and querying functionality within

Concentrix is l imited.

This implementation has brought to l ight a new degree of partnership between Technology,

F inancial Control & TMG teams to resolve a large number of significant data quality issues in

t he legacy architecture and spreadsheet environment. Data cleansing was an intensive and time

consuming task which led to an extended production parallel period. This system has provided a

more efficient month end process - Significant time savings at month end as 3 way rec between

M IS3, Lobster and SAP, Alice and R&N is replaced with a simpler trade level reconciliation

p rovided by the reporting tool.

I dentified business requi rements and developed a B I road map and execution

Responsibiliti

es p lan.

Liaised w ith Book Runners and CTB to understand requi rements and capture

b usiness functionality.

Assisted and guided new users in adopting and using the new reporting tool.

Conducted functional reviews and guided the team on functional and technical

i mplementations.

Worked in the onsite – offshore atmosphere du ring the development phase.

Planned daily project activities and acted as a single point of contact for all

p roject related activities.

Coordinated with various teams like Testing, TA team and SA teams to perform

d aily activities.

Conducted P M R reviews & audit checks and planned & allocated resources.

Developed & deployed prototype applications to int roduce new Cognos

f unctionality.

Star H ub D ata Warehouse

P roject

Accenture

Client

4

Tech Mahindra, Singapore

O rganization

Nov 2008 –Jun 2010

Du ration

40

Team Size

Oracle 10g, Informatica 8.1, Unix, Erwin

Envi ronment

Role L ead P roject \ Solution Architect

Star Hub is Singapore's second largest info-communication company and the sole operator

D escription

delivering a full range of information, communications and entertainment services over fixed,

cable, mobile and Internet platforms. It currently operates a set of fragmented reporting

repositories on disparate architectures that are primarily separated by Comms and Cable

businesses. These repositories consist of data marts & operational data stores from the merger

between Star Hub and SCV. Data is duplicated across some of the repositories to facilitate cross-

business analysis. The duplication of data storage interfaces and data processing causes

operational inefficiencies and results in slower response to business.

Handled the overall responsibil ity of project from inception til l implementation.

Responsibiliti

Interacted with client to understand requirements and capture functionality and accordingly

es

p lanned daily project activities.

Functioned as a single point of contact for all project related activities.

Designed the stage design for CAR and validated source to target transformation rules.

Worked in the onsite-offshore atmosphere during the development phase.

Liaised with both the Star Hub IS and Business users and planned & allocated resources.

Coordinated with various teams l ike Testing, TA team and Source team to perform daily

activities.

Analyzed and fixed SIR and guided team to conduct AT, SIT, UAT, SPT, ORT-P and DRT.

Presented KT schedules to Star Hub Business users and IS users.

Assisted the Migration team analyze the to-be architecture and map.

Reviewed PMR, checked audits and updated senior management & Group Head on project

status.

Analyzed CR and effort estimation for the CR activities.

Core Banking D ata Warehouse

P roject

DBS Bank

C lient

Ness Technologies, Singapore

O rganization

Aug 2007 – Nov 2008

Du ration

25

Team Size

Teradata, Informatica 7.1, Unix, Tivoli Scheduler

Envi ronment

Role I T Lead Architect

DBS is the largest bank in Singapore as measured by assets, and a leading bank in Hong Kong,

Description

w ith leading positions in consumer banking, treasury & markets, asset management, securities

b rokerage, equity and debt fund raising. With one of the highest credit ratings in the region,

D BS is ready to serve customers in 15 markets as a bank that specializes in Asia. The objective

of this project is to load the data from various source systems like Finacle, I MEX, Factoring

and CBF required for Basel 2 regulatory reports and other downstream users (RMG, AML,

Bancware). The data is loaded into the Business Data warehouse, based on NCR’s FS-LDM. At

t he end of this project, users will be able to perform variety of analysis through the business

objects reports.

Efficiently managed the entire project from planning til l delivery.

R esponsibiliti

Architected few key components of the Basel 2 Regulatory Data Model.

es

Liaised with various teams l ike downstream mart owner l ike BPL, RMG, Reporting Team in

Shanghai, IBM Teams l ike the SA, Change Coordinator, etc.

Functioned as member of the Release Management to deploy projects to production.

Handled production support activities, worked with source systems and proposed

enhancements.

Designed and developed few mappings to handle Chinese characters.

Validated source to target transformation rules done by the modeling team.

Designed documents and operational manual for knowledge transfer to the new team

members.

Analyzed tickets and provided solutions for fixing, testing as well as re-promoting them to

p roduction.

H R-I T D ata M a r t

P roject

Hewlett Packard, Singapore

Client

GMP Recruitments, Singapore

Organization

Nov 2006 - Aug2007

Du ration

33

Team Size

Oracle 10G, Informatica 8.1, Tidal Scheduler

Envi ronment

Role B I Team Lead

Workforce Excellence, a collaboration of HR IT, the Learning and Development businesses,

Description

Talent and Performance Management, and HP Education Services. The Workforce Excellence

p rogram is implementing an industry-standard, integrated learning ecosystem to support HP

employees, its partners, and customers. The goals of Workforce Excellence are to integrate the

Saba Human Capital Management System into the HP environment, migrate data from legacy

applications, and establish supporting business processes in order to reduce costs by

consolidating and managing vendors. Workforce Excellence Project is a data Migration project

w here we were migrating data from various applications into SABA. There are 3 phases in this

p roject phase, in phase one we have migrated data from our 13 existing system to SABA which is

an E-learning management system in second phase we will built business intelligent data

warehouse using SABA data and the last phase its reports to the business .

Coordinated and worked closely with the global Infrastructure and DBA team to resolve

Responsibiliti

issues.

es

Designed work allocation plan, technical mapping and functional specification & QA

documents.

Developed Informatica mappings to load data and loaded data to test environment and fix

bugs.

Designed logical data model for data warehouse.

Designed the warehouse system and scheduled & monitored jobs.

Ensured knowledge transfer on application and issues to the new team members.

Enhancement of Global I nformation D ata Warehouse

P roject

Franklin Templeton Investments, USA

Client

Innova Solutions, USA

Organization

Jan 2005 - May 2005

Du ration

6

12

T eam Size

Unix Shell Scripts, Pearl, Informatica 5.1, Control-M Scheduler, Serna Web Version

Envi ronment

M anagement Tool, Manage Now Ticketing Tool

Sr BI Developer

Role

Franklin Resources, Inc. is a global investment management organization known as Franklin

Description

Templeton Investments and having offices in 29 countries around the world and offer investment

solutions and services in more than 100 ways. This project aims to add the third party data to

t he existing operational data store GID. GID is the enterprise Data warehouse that stores

enterprise data of Franklin Templeton mutual funds. There are different third party and

i nternal source systems with in Franklin Templeton which provides account, client, trade,

settlement, daily transaction, corporate action and fund information, as a part of this project we

have collected information from the source systems, applied ETL process to the source data. We

have used Informatica mappings and transformations extensively from source to staging,

staging to warehouse and warehouse to marts. We have used control-M scheduler a product of

I BM to schedule the sessions.

Involved in project mapping; preparing Tech support documents, Low level designs and ETL

Responsibiliti

job flow including troubleshooting of loading failures cases.

es

Developed control-M jobs and transformations and coordinated with IBM on scheduling

control-M jobs.

Prepared unit & integration test cases and conducted Unit Testing & System Integration

Testing.

Analyzed job dependency and developed several Kornshell scripts.

Global I nformation D ata Warehouse (G I D)

P roject

Franklin Templeton Investments, USA

Client

Innova Solutions, USA

Organization

Feb 2004 – Feb 2005

Du ration

8

Team Size

Oracle 9i, Shell Scripting, Control-M Schedulers, Informatica 5.1

Envi ronment

B I Developer

Role

Franklin Resources, Inc., is a global investment management organization known as Franklin

D escription

Templeton Investments and having offices in 29 countries around the world and offer investment

solutions and services in more than 100 ways. It offers investment management and fund

administration services to open-end and closed-end investment companies (including our own

family of retail mutual funds),institutional accounts, high net-worth famil ies, individuals and

separate accounts in the United States (the “U.S.”) and internationally. ODS for FTT, ODS

receives information from various source systems it validates, reconciles and provides data to

adhoc reports, business users, online clients and downstream applications l ike AUM, Proxy &

Onetis etc . Very important feature of ODS is it delivers month end statements.

Provided EOD & DOB support and fixed A-bend jobs.

R esponsibiliti

Resolved business ticket, investigation & fixed issues by raising change request.

es

Conducted root cause analysis of batch A-Bends including capacity planning & load

balancing analysis.

Designed test plan for software releases and disaster recovery projects.

Scheduled UAT jobs for business testing, provided estimates and new enhancements.

Worked with Serena web version control tool to maintain the versions of source code.

Created ad-hoc reports and extracts for downstream applications.

Commercia l D ata Warehouse

P roject

Consumer Finance, USA

Client

Organization I R MAC Services Pvt. L td., I ndia

Jul 2003 – Jan 2004

Du ration

6

Team Size

SAS, Autosys Scheduler, Unix Shell Script, Perl Script, Oracle 8i, PL /SQL

Envi ronment

B I Developer

Role

Consumer Finance A unit of the General Electric Company is a leading provider of financial

D escription

services to consumers and retailers in 47 countries around the world, All the data of consumers

and retailers are maintained in respective data warehouses as a team member I was involved in

commercial (retail) Data warehouse FDR phase I I project where most of the source systems are

changing from Genesis to FDR we have mapped all the new sources in place of old sources

w ithout effecting the daily activities.

Involved in commercial (retail) Data Warehouse FDR phase I I project where most of the

Responsibiliti

source systems were changed from Genesis to FDR.

es

Implemented logical and physical data modeling with STAR and SNOWFLAKE techniques.

Build Fact tables and dimension table structure using ERWIN.

Interacted with FDR on understanding source file layouts.

Mapped new source system to warehouse, provided HLD & LLD and designed ETL job flow.

Worked on SQL scripts to validate the pre & post load data.

Involved in troubleshoot the loading failure cases and database problems.

Managed coding, preparing test cases and conducting user testing and acquiring sign off

f rom clients.

Commercia l D ata Warehouse

P roject

Consumer Finance, USA

Client

Organization I R MAC Services Pvt. L td., I ndia

Nov 2002 - Aug 2003

Du ration

5

Team Size

SAS, Autosys Scheduler, Unix Shell Script, Perl Script, Oracle 8i, Pl / SQL

Envi ronment

J r Associate

Role

Consumer Finance A unit of the General Electric Company is a leading provider of financial

D escription

services to consumers and retailers in 47 countries around the world, All the data of consumers

and retailers are maintained in respective data warehouses as a team member I was involved in

M aintains and enhancement of commercial Data warehouse (retail) commercial credit cards

w ill be issued by GE to its clients. In commercial business there clients l ike Home depot, Xenon

mobile, sams club etc all the dimensions and facts feeds from various source systems are loaded

i nto warehouse by EOD.

Involved in maintenance and enhancement of commercial Data Warehouse (retail) where

R esponsibiliti

commercial credit cards wil l be issued to GE clients (Home Depot, Xenon Mobile, Sams Club,

es

etc.).

Was responsible for requirement collation and preparing coding for enhancements.

Handled extraction, transformation and loading of large volumes of data.

8

Generated reports based on dimensions l ike monthly, quarterly and annual sales for business.

Evaluated and recommended Business Intelligence tools to meet business requirements.

Developed and implemented training programs for internal and external clients.

Conducted impact analysis on new code changes and scheduled new jobs in Autosys.

Maintained Data Warehouse and validated data for quality and accuracy.

Analyzed and implemented Change Requests and fixed production issues.

Created new extracts for downstream applications.

Data Mart

P roject

Client Amaraja Batteries L td.

Organization I R MAC Services Pvt. L td., I ndia

Feb 2002 – Sep 2002

Du ration

14

Team Size

Cognos, SQL Server,Informatica

Envi ronment

Software Engineer

R ole

As a Software Engineer, and part of a team The scope was to develop Data Mart for ABL, having

D escription

operational systems for Purchase, Production, Sales, Distribution and Finance by using

d isparate RDBMS / DBMS / F i le System l ike Purchase Database in MS Access.

Worked as apart of ETL team

Responsibiliti

Extracted data from disparate databases into the Data Warehouse Database.

es

Addressed user requirements by means of Queries, Decision Support Systems (DSS),

Executive Information Systems (EIS) and Online Analytical Processing (OLAP).

Prepared ad-hoc reports by using ROLAP and MOLAP tools.

Data Mart

P roject

Venkateshwara Hatcheries Ltd.

Client

Organization I R MAC Services Pvt. L td., I ndia

Feb 2002 – Sep 2002

Du ration

8

Team Size

Cognos, SQL Server

Envi ronment

I nternal Trainee

Role

As an internal trainee, and part of a team, we developed Data Mart for Venkakaswera

Description

H atcheries, which is one of the first and biggest Hatcheries in India, they are having different

sales unit across India and abroad. Ensuring quality and accuracy of information as well as

p roviding a foundation for enterprise wide information access and knowledge delivery. It enables

data to stay in an organized format, Data integration. It helps the officials in developing better

O rganization Intelligence, Reduce costs and in making effective decision-making

Worked as a Software Engineer, analyzed data .

Responsibiliti

Provided a foundation for enterprise wide information access and knowledge delivery.

es

Developed Cognos Reports

Software Development

P roject

Skids

Client

O rganization I R MAC Services Pvt. L td., I ndia

Jun 2001 – Oct 2001

Du ration

18

Team Size

Cognos, SQL Server

E nvi ronment

I nternal Trainee

Role

As a Software Engineer, and a part of team, we developed web-based software for educational

Description

i nstitutions in order to computerize the existing systems. The Product Integrates all the accepts

of school Starting from Admissions, Student information, Staff Information, Staff Payroll,

School Timetable, School Transportation, School Accounts & School Inventory. This product is

purely web based and includes all latest technologies.

Worked as an Internal Trainee, analyzed product and designed & implemented various

Responsibiliti

modules.

es

Tested and debugged modules and converted HTML fi les into WAP files.

Developed reports in Cognos Impromptu.

10

Contact this candidate