Project Data
Resume:
RAJA THANISLAS
**********@*****.***
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