RAJA THANISLAS

aco12h@r.postjobfree.com

818-***-****

EXPERIENCE SUMMARY

. 16 years of experience in Information Technology including Data

Warehousing, Internet and Client/Server applications.

. 14 years of experience in installing, configuring ROLAP TOOL and

MicroStrategy 5.x/6.x/7.x/8.x/9.x) Suites including Desktop, Broadcaster,

Narrowcaster, SDK, WEB and Intelligent Server.

. Extensive experience in designing the architecture of the Extract,

Transform and Load environment and development of transformation

standards and processes

. Excellent experience in ETL Tools - Informatica PowerMart 5.0/5.1 &

PowerCenter 5.0/1.7 and Custom SQLs for Data mart building and Data

warehousing.

. Proficient in Oracle, SQL Server and DB2 UDB for Data warehousing and

Database applications with over 5 years of experience .

. Over 3 years of experience in Insurance Industry 21st Century

Insurance/AIG

. Over 4 Years of Experience in Restaurant IndustryThe Cheesecake Factory

Inc.

. Over 6 years of experience in Retail Industries includes Guitar Center,

WHV,Federated Department Stores(FDS), Ingram Micro, BMHC, ABS, Petco And

Danone

. Excellent understanding of business processes in a variety of industries

- Insurance, Sales, Finance, Manufacturing and Marketing.

TECHNICAL ENVIRONMENT

DATA WAREHOUSING MicroStrategy Suite 5.x/6.x/7.x/8.x/9.x

including Desktop, Narrowcaster, SDK, WEB

and Intelligent Server, Business Objects,

ERWIN/ERX 3.5.2(case Tool), Visio, MS-DTS

ETL Dimensional Data Modeling and Design both

Entity Relationship and Star Schema

Informatica PowerMart 5.0/5.1, PowerCenter

5.0/1.7, IBM Datastage

DATABASES Oracle 7.x/8.x/9.x/10.x, MS SQL Server, DB2

400, DB2 UDB, MS-Access

LANGUAGES/ DEVELOPMENT SQL, PL/SQL, C, C++, Java, Java Servlets, JSP,

TOOLS Visual Basic, ASP, XML, XSL, CSS, IIS,

JavaScript, VBScript, UNIX Shell Scripting

OTHER SKILLS MS Project, MS Excel,Rational Rose

PLATFORMS Windows NT, UNIX

MAJOR ASSIGNMENTS

Organization : The Cheesecake factory, Calabasas, CA

Project : Enterprise DataWarehouse (Mar 2010 - Till

Date)

As a MicroStrategy Architect

I was responsible for the following:

. Developing a business-oriented strategic roadmap of BI initiatives based

on key organizational objectives and values.

. Creating a data model for integrating different data source into a

single, comprehensive resource for MicroStrategy reporting and analysis.

. Conducting a Design walk through sessions with business and design

signoff.

. Architecting the entire datawarehouse by defining hierarchies, facts,

attributes, transformations, partitions and using industry best practices

. Designing OLAP services & Intelligent Cube Design for advanced analytics

and Trend analysis reporting.

. Designing dynamic flash dashboards for Executives, ADO's, RVP's &

Restaurant GMs

. Troubleshooting the performance issues

. Coordinating with the QA Team on report testing.

. Creating complex SQL procedures and validating data.

. Supporting and maintaining the environment for 24*7 usage

. Providing Tool and Data Training to the end Users.

. Preparing documentation and manuals.

Environment: Micro Strategy 9.4.1, SQL Server 2005/2008/2010, SSIS.

Organization : Guitar Center, Westlake Village, CA

Project : Enterprise DataWarehouse (Jan 2009 - Mar

2010)

As a Microstrategy Architect

I was responsible for the following:

. Gathering, A Business Requirements.

. Preparing BRD and Design Documents

. Preparing the Design for the ETL and Reports

. Architecting the entire project by defining hierarchies, facts,

attributes, transformations, partitions

. Creating complex MSI reporting objects using Relationship filters, Metric

dimensionalities, Nested Prompts, Hierarchy Filters, Consolidations,

Custom Groups.

. Creating and Testing MSI Reports.

. Creating and Testing the Design for Report delivery using MSTR Narrowcast

. Preparing Use Cases and Unit Test Cases

. Conducting User acceptance Tesing

. Preparing project documentations, user manuals

. Providing Tool and Data Training to the end Users.

Environment: Micro Strategy 9.x, Oracle 10g, Netezza, DB2, Data Stage,

Unix, Erwin

Organization : AIGDirect.com, Woodland Hills, CA

Project : Enterprise DataWarehouse (Apr 2008 - Oct

2008)

As a Sr Business Intelligence Engineer

I was responsible for the following:

. Gathering, Business Requirements.

. Preparing Functional and Technical MRA

. Preparing the Design for the ETL

. Creating a test,development and production environment including backup

and disaster recovery strategies

. Creating Standards and Process flow for Microstrategy

Administration,Development and QA

. Developing the Programs to build Reports

. Architecting the entire project by defining hierarchies, facts,

attributes, transformations, partitions

. Creating complex MSI reporting objects using Relationship filters, Metric

dimensionalities, Nested Prompts, Hierarchy Filters, Consolidations,

Custom Groups.

. Creating and Testing MSI Reports.

. Creating and Testing the Design for Report delivery

. Preparing Use Cases and Unit Test Cases

. Fine-tuning includes report timings using VLDB properties,Partitioning

and temporary tables.

. Conducting User acceptance Tesing

. Preparing project documentations, user manuals

. Providing Production support & Training

Environment: Micro Strategy 8.1.1, Oracle 9.0/10g, DB2, Data Stage, Unix,

Erwin 3.5.2

NETFLIX.COM (SR Microstrategy Engineer Jul 2007 - Mar 2008)

Project : EDW QuickWin, ED Supply Chain

As a Sr Microstrategy Engineer I was responsible for the following:

. Creating Standards and Process flow for Microstrategy

Administration,Development and QA

. Gathering Business Requirements.

. Preparing the Design for the ETL

. Developing the Programs to build Reports

. Administrating the Microstrategy Desktop, Web and Narrowcast

. Architecting the entire project by defining hierarchies, facts,

attributes, transformations, partitions

. Creating complex MSI reporting objects using Relationship filters, Metric

dimensionalities, Nested Prompts, Hierarchy Filters, Consolidations,

Custom Groups.

. Creating and Testing MSI Reports.

. Preparing Use Cases and Unit Test Cases

. Fine-tuning includes report timings using VLDB properties,Partitioning

and temporary tables.

. Conducting User acceptance Tesing

. Preparing project documentations, user manuals

. Providing Production support & Training

Environment: Micro Strategy 8.1, Oracle 10G, AB Initio, Unix

KANBAY INC (SR Consultant Jan 2005 - Jun 2007)

Organization : AIG Direct.com, Woodland Hills, CA

Project : Enterprise DataWarehouse (Jan 2005 - Jun

2007)

As a Sr Programmer Analyst I was responsible for the following:

. Gathering, Business Requirements.

. Preparing Functional and Technical MRA

. Preparing the Design for the ETL

. Creating a test,development and production environment including backup

and disaster recovery strategies

. Developing the Programs to build Reports

. Architecting the entire project by defining hierarchies, facts,

attributes, transformations, partitions

. Creating complex MSI reporting objects using Relationship filters, Metric

dimensionalities, Nested Prompts, Hierarchy Filters, Consolidations,

Custom Groups.

. Creating and Testing MSI Reports.

. Preparing Use Cases and Unit Test Cases

. Fine-tuning includes report timings using VLDB properties,Partitioning

and temporary tables.

. Conducting User acceptance Tesing

. Preparing project documentations, user manuals

. Providing Production support & Training

Environment: Micro Strategy 8.01, Oracle 9.0, Data Stage, Unix, Erwin

3.5.2

HEXAWARE TECHNOLOGIES (Systems Analyst Apr 2002 - Dec 2004)

Organization : Warner Bros. Entertainment(Home Video), Burbank. CA

Project : Category Management (April 2004 - Dec 2004)

As a Programmer Analyst I was responsible for the following:

. Understanding Business Rules for a specific retailer and the Industry.

. Gathering, Analysing, Specifying and Validating Requirements.

. Studying PDM and Developing LDM and ETL View layer preparation

. Creating a test,development and production environment including backup

and disaster recovery strategies

. Architecting the entire project by defining hierarchies, facts,

attributes, transformations, partitions

. Creating complex MSI reporting objects using Relationship filters, Metric

dimensionalities, Nested Prompts, Hierarchy Filters, Consolidations,

Custom Groups.

. Creating and administering user accounts using security roles.

. Creating and Testing MSI Reports.

. Fine-tuning includes report timings using VLDB properties,Partitioning

and temporary tables.

. Conducting User acceptance Tesing

. Preparing project documentations, user manuals

. Providing support & Training

Environment: Micro Strategy 7.2.2, Teradata V2R4, Queryman 6, Erwin

3.5.2,

Organization : Danone Waters of North America, Glendale. CA

Project : HOD Business Foresight (June 2003 - March 2004)

As a System Analyst I was responsible for the following:

. Preparing a Project Plan in Microsoft Project. Identified tasks and

allocated resources

. Installing, Configuring and administrating MicroStrategy7 Desktop,

Intelligence Server,Web Server and Narrowcaster.

. Architecting the entire project by defing hierarchies, facts, attributes,

transformations, partitions

. Creating complex reports using Relationship filters, Metric

dimensionalities, Consolidations, Custom Groups.

. Creating and administering users,applying security roles,security filters

for the group of users

. Customizing and sending reports through narrowcaster using XSL and XML

. Installing and configuring Enterprise Manager to adminster the users and

traffic control and reporting to the Managers

. Fine-tuning includes report timings using VLDB properties and temporary

tables.

. Preparing project documentations, user manuals

. Providing support & Training

Environment: Micro Strategy 7.2.3, SQL Server2000, ERWin 3.5.2, DB2/400

Organization : Federal Systems Group, Duluth. GA

Project : Demand Data Warehouse (September 2002 - May 2003 )

As a System Analyst I was responsible for the following:

. System study and Providing a suitable Project plan and Data Model for the

Web Based BI Analysis system and Demand Data Warehouse.

. Providing High level Microstrategy Technical support

. Laying out a plan for implementing a new technologies on a legacy systems

to help and accomodating Business Users requirements.

. Preparing a document to upgrade DDW using Microstrategy 7.1.1 to

Microstartegy 7i

. Reviewing the Upgrade issues, testing and debugging the failed objects

. Providing support for the Testing, Development and Production

Environments

. Accommodating new user requirements for web and Desktop Users and

providing Knowledge Base Training.

Environment: Micro Strategy 7.1.1, Teradata on UNIX, Queryman.

Organization : Danone Waters of North America, Glendale. CA

Project : Retail Datawarehouse (April 2002 - September 2002 )

As a System Analyst I was responsible for the following:

. Prepared a Project Plan in Microsoft Project. Identified tasks and

allocated resources

. Upgraded the test project from MSTR 6 to MSTR 7.1.4 using the Software

Utilities

. Reviewed the Upgrade issues, tested and debugged the failed objects

. Installed, Configured and administrating MicroStrategy7 Desktop,

Intelligence Server,Web Server and Narrowcaster.

. Used Microstrategy WEB APIs in ASP pages to simulate the functionalities

of Microstrategy.

. Created XSL Stylesheets for MicroStrategy Narrowcaster and WEB.

. Had one-to-one Interface with end users at vice-president and other

level's for the collecting the reporting requirements, security planning

and in data validation

. Designed & Developed new mappings to accommodate the new warehouse design

using Informatica

. Fine-tuned the entire System to reduce the data load process & report

response time.

. Created new document objects, reports, filters, metrics, schema objects,

user objects, security roles and security filters

. Prepared project documents, user manuals and Trained 60 business users

across the country through video conferencing technology

. Providing support & accommodating new user requirements for 60 web and

Desktop Users.

Environment: Micro Strategy 7.1.4, DB2 UDB7.1 & 5.5 on UNIX, SQL

Server2000

SYSTECH SOLUTIONS INC (Programmer Analyst April 2000 - January 2002)

Engaged as a Datawarehouse Consultant, for the following Clients

Ingram Micro Inc, Santa Ana, CA (Sep 2001 - Jan 2002)

BMC West Corporation, Inc., Boise, Idaho (July 2001 - September 2001)

ABS by Allen Schwartz, Los Angeles, CA (September 2000 - March 2001)

Petco Supplies, Inc., San Diego, CA (April 2000 - August 2000)

And I was responsible for the following

. Architect Logical Data Model (Dimensional) and Physical Data Model.

. User Specific Reports and Metrics, Templates and Filters were created

using MicroStrategy Desktop and WEB.

. Performance tuning to decrease load time.

. Provided key documentation and knowledge transfer to client personnel for

ongoing support

Developed Technical and User Documentation.

EDUCATION & CERTIFICATION

Education : Bachelor of Engineering, Bharathiyar University.

India

Certification : Certification in Data warehousing Technologies

Data Modelling and DSS

Tool(Microstrategy)

: Certification in Oracle, VB, Unix, C, C++

Contact this candidate