Project Experience Sharing

Trainer : Deepak Natarajan
Date : 30-Dec-2008
Venue : Conference Room
Duration : 2 hours

Deepak Natarajan, who was working for the Guitar Center project shared his valuable experience about the project and various important features of Microstrategy. He gave a brief insight into the pros and cons of Microstrategy and emphasized on the effectiveness and implementation of the tool in his project.

The session focussed on the following areas:

Data model built for GC

Overview on MSTR architecture & project design

Reports & Dashboards developed for GC

Narrow cast server setup and implementation

Netezza Professional

Trainer : Karthikeyan Sethuraman
Date : 10-Dec-2008 to 16-Dec-2008
Venue : Conference Room
Duration : 10 hours

Netezza is a booming data warehouse appliance in recent times. Hence it has become an essential trait for a BI consultant to understand the basics of Netezza as it helps a great deal to work in the ETL projects.

The concise course content is as follows:

Introduction to Architecture and Administration

Database objects overview

Basic commands and its operations

Connectivity and Statistic Planning

Microstrategy Professional

Trainer : Ramya Sambathu
Date : 04-Dec-2008 to 10-Dec-2008
Venue : Conference Room
Duration : 10 hours

Microstrategy has been reigning as the most efficient reporting tool for delivering business intelligence solutions. The purpose of this training is to give an insight to BI consultants on the various components of Microstrategy.

The training session focused on the following:

MicroStrategy Desktop : Reporting Essentials

MicroStrategy Architect : Project Design

MicroStrategy Office Essentials

MicroStrategy Report Services

Microstrategy Web Report Analysis

Microstrategy Expert

Trainer : Keerthana Venkatesan
Date : 27-Nov-2008 to 03-Dec-2008
Venue : Conference Room
Duration : 10 hours

The expert training focuses on the advanced concepts of Microstrategy.
This training provides in depth technical knowledge on all the features of Microstrategy which helps the associates to be in a better position to build reports and dashboards.

The course content includes:

MicroStrategy Desktop: Advanced Reporting

MicroStrategy Intelligence Server Administration

Advanced features of MicroStrategy Office

MicroStrategy Narrowcasting Server

MicroStrategy Enterprise Manager

Microstrategy Web Report Designer

Behavioral Skills Training

Trainer : Sudha Gopal
Date: 20-Nov-08 to 24-Nov-08
Venue: Training Room
Duration: 15 hrs (Classroom training)

Behavioral skills training is an essential component which helps to better understand the fundamental need of how to behave in an organization. This session helped the trainees to sharpen their behavioral etiquette even before they could venture out of their boot camp.

The training session focused on:

Behavior within a team

Exercising Leadership

Basic business etiquettes

Teradata Professional Training

Trainer : Sangeedha Dhandapani
Date: 17-Nov-08 to 19-Nov-08
Venue: Conference Room
Duration: 6 hr

The objective of this training program is to make the associate work with fundamentals of this database.

The course covered the following:

Teradata Architecture.

Teradata Management Systems.

Loader Utilities.

Indexing Concepts.

Data Storage methods.

Interpersonal Skills Training

Trainer :Ashwin
Date: 13-Nov-08
Venue: Conference Room
Duration: 1 hr

Interpersonal skills are important for successful managing, cooperating, problem-solving and other aspects in an organization. We need to know how to build and encourage productive relationships, even in the most difficult of human relation situations.

The training threw light on the need for interpersonal skills:

as an individual and

a professional

Soft Skills Training

Trainer : Vidhya Sriram Bhat
Date: 07-Nov-08
Venue: Conference Room
Duration: 2 hrs

Soft skills are basically a cluster of personality traits, social graces, good communication, ability with language and professionalism. This training was very useful in grooming and enhancing our personality.

The training program dealt with the following:

Cultural differences

Business etiquettes

Communication styles

Smart I Training

Trainer:Kannan, Santosh Kumar
Date:20/Oct/2008 to 24/Oct/2008
Venue:Conference Room
Duration:8 hrs

The Smart i Appliance is a low-cost, data analytics solution for small and mid-size businesses seeking the benefits of a Business Intelligence without the cost and complexity of current solutions. Smart i is based on easy-to-use, proven technologies of the IBM System i and Power Server,the first Open Source ETL software from Talend, and IBM's powerful Web Query analytics engine.

       The objective of this training is to give an overview of Smart I architecture,
OS 400 commands, DB2 basics, Talend's ETL tool and IBM Web Query.

Talend - Expert Training

Trainer : Antony Cruz, Fredrick Jose
Date: 20/Oct/2008 to 24/Oct/2008
Venue: Conference Room
Duration: 10 hrs

It is not enough for us to just know the overview of the various features of the tools in this profession. This session is the continuation of the professional level. In this training program the trainer got into a mode of detailed explanation of all the components of this tool.

Oracle BI - Professional Training

Trainer: Pradeep Singh, Yogendra Kumar
Date: 30-Sep-2008 to 09-Oct-2008
Venue: Conference Hall
Duration: 10 hrs (Class room Training)

It is very essential for us to keep up with the new trends in the data warehouse industry in order to help a wide range of clients to take certain vital business decisions. This session by Yogi was able to provide the fundamental of this tool. The session also included exercises on creating the business catalogs.

Training includes the below listed essentials concepts:

Describe the role of key components in Oracle BI architecture

Describe the relationships among the components

Identify and describe repository features and functions

Design the repository and test the repository using Answers

Build queries in Oracle BI Answers

Create and modify Oracle BI Interactive Dashboards

Publish a BI Publisher report created from BI Server repository and Oracle BI Answers

Cognos - Professional Training

Trainer: Karunakaran, Vidya Latha
Date: 30-Sep-2008 to 09-Oct-2008
Venue: Conference Hall
Duration: 10 hrs (Class room Training)

Thirst of new knowledge is very much essential for us to excel in this field. The purpose of this training program is to build the fundamentals of Cognos tool. The course included the below listed essentials concepts of the basic level,

Cognos 8 BI Ad Hoc Querying.

Cognos 8 BI Report Authoring.

Cognos 8 BI Query Model.

Cognos 8 BI Introduction to Event Studio.

Cognos 8 BI Server Administration.

DW Concepts Training

Trainer : Venkatesan, keerthana
Date: 01-Oct-2008
Venue: Conference Room
Duration: 1 hr

The objective of this session is to give a brief insight to the associates working for Pi solutions on the basic concepts of data warehousing. This helped the trainees to better understand the various terminologies and features of data warehousing.

The concise course content is as follows,

Introduction to data warehousing

Overview on dimensions and facts

OLAP vs OLTP

Benefits of data warehousing

SSIS Training

Trainer: Neelakantan, Mohana Priya
Date: 22-Sep-2008 to 26-Sep-2008
Venue: Conference Hall
Duration: 7 hrs (Class room Training)

It is very important for us to learn the latest tools from the popular vendors in order to excel in the business. The same goes to Microsoft Sql Server 2005. An interactive session by Mohanapriya was able to provide the knowledge on the components of this tool. Later the session got in detail with integrated services which is an ETL part of this tool. Training includes the below listed essentials concepts of advanced level,

· Introduction to Sql Server 2005 Integrated Services
· Overview of Control flow elements
· Overview of Data flow elements
· Introduction to event handlers
· Overview of Variables

Data Modelling Training

Trainer: Karuppiah, Maruthu Pandian
Date: 22-Sep-2008 to 24-Sep-2008
Venue: Conference Hall
Duration: 4 hrs (Class room Training)

The objective of this course is to let the associates venture in depth the various concepts of data modeling. The session also included a case study where the associates executed the data modeling of retail sales. The concise course content is as below,

· Transform the data warehouse requirements
· Understand different business process
· Describe the source system data structures and their relationship
· Use data modeling techniques
· Develop Dimensional data models

Talend - Professional Training

Trainer: Kannan, Santosh Kumar
Date: 15-Sep-2008 to 19-Sep-2008
Venue: Training Room
Duration: 10 hrs (Class room Training)

In order to be a successful data warehouse developer we ought to have the knowledge in every ETL tool possible, so that we are able to reach variety customers. The course included the below listed essentials concepts of the basic level,

· Introduction to Talend
· Architecture of Talend
· How to import source definitions.
· Components in Talend

BO XI - Expert Training

Trainer: Koilada, Sridhar
Date: 08-Sep-2008 to 11-Sep-2008
Venue: Conference Hall
Duration: 6 hrs (Class room Training)

It is an integral quality of a BI consultant to understand the Advanced Concepts of BO XI as it helps them to accomplish the Reporting needs of projects independently. The training includes the below listed essentials concepts of advanced level,

· Advanced Features in Administering Users and Content
· Introduction in Administering Servers
· Overview of Designing and Deploying
· Advanced Features in Business Objects Universe Design
· Introduction for Designing Dashboards
· Import Wizard

Netezza Quick Start Program - UDX

Trainer: Perumal Vadivel
Date: 01-Sep-2008 to 05-Sep-2008
Venue: Conference Hall
Duration: 6 hrs(Class room Training)

Netezza is one of the latest gadgets in this industry which is proving its existence at a very fast rate. The objective of this program is to give an overview of one of the features of netezza that has made it popular.

BO XI - Professional Training

Trainer: Koilada, Sridhar
Date: 28-Aug-2008 to 04-Sep-2008
Venue: Conference Hall
Duration: 9 hrs (Class room Training)

The purpose of this training program is to build the fundamentals of BO XI architecture, new features/components of BO, design a universe with necessary contexts, resolve loops, traps and create objects, hierarchies. During the program the associates were thought how to create reports and format them according to the requirements. Brief course content is as below,

· Business Objects Desktop Intelligence Report Design
· Business Objects Desktop Intelligence Advanced Report Design
· Introduction for Administering Users and Content
· Overview of Business Objects Universe Design
· Scheduling Reports

Informatica - Expert Training

Trainer: Sengodan, Gopinath
Date: 11-Aug-2008 to 02-Sep-2008
Venue: Conference Hall
Duration: 12 hrs (Class room Training)

To be an ace tool developer we need to have the knowledge on every feature of the tool. This was the prime objective of this training program. Sathiya Narayanan Manickam Srinivasan as a trainer was able to fulfill this and by doing so was able to enhance the confidence of the associates to work with the clients with the tool in real time projects. The program got into detail of the below listed topics,

· How to use Debugger
· How to read a COBOL file using Normalizer
· The advantages of Dynamic and Shared Lookup caches
· Mapping parameters and variables

DW Bootcamp Training Apr 2008

DW Bootcamp training is carried it in a way such that the associate graduates as a complete data warehouse consultant. This program walks you through all the phases of a data warehouse project lifecycle providing hands on experience in generating required deliverables at each phase using the necessary tool kit. On successful completion of the training program he/she is qualified to work in an integrated team performing the following tasks at ease,

• Understand and Interpret the Project Documentation
• Understand DW/ETL Concepts, Data Modeling, Analyze a given Data Model
• Develop ETL Scripts with SQL/PL-SQL Programming
• Develop Report Generation Scripts with SQL/PL-SQL Programming
• Develop Informatica Code with the Provided Design
• Develop and execute Test Cases and debug the above developed Scripts in case of Issues
• Generate reports using Microstratergy
• Report Project Status with the help of a Task List and Escalate Issues with the help of an issue log

Soft Skills Training

Trainer: Sudha Gopal
Date: 21-July-2008 to 23-July-2008
Venue: Conference Hall
Duration: 9 hrs (Class room Training)

The objective of the program is to provide an introduction to customer relationship management and conflict management. It will help in improvising on both verbal and written communication skills. This training encompasses a whole range of skills, including assertiveness, influencing and persuading, negotiating, presenting and interacting. Overall, it is about gaining a better understanding of how to present yourself and your ideas in a way that will have the best impact.

A brief overview on the course content is as follows:

Customer Relationship Management
Communication Strategies
Advance Writing Skills
Problem Solving & Decision Making
How to manage anger in work space

Open Office Training

Trainers: Sangeedha Dhandapani, Dinesh Rajendran
Date: 16-July-2008, 18-July-2008, 21-July-2008
Venue: Conference Hall
Duration: 6 hrs (Class room Training)

The main objective of the training program was to provide an introduction and a brief insight on Open office tools suite. The trained associates could effectively work on the open office tools as they work on Microsoft office tools. The Ultimate aim of this training was to discuss on the issues caused in using the applications and provide with the solutions.

We will provide the required support and guidance to all the associates in using the applications effectively.


The training includes,

1. Introduction to open office CALC.
2. Introduction to open office WRITER.
3. Introduction to open office BASE.
4. Introduction to open office IMPRESS.

Netezza Quick Start Program

Trainers : Vadivel Perumal, Karthikeyan Sethuraman, Yashpal Saini
Date : 13/June/2008 to 18/July/2008
Venue : Conference Hall

Objective of this Training is to develop associates who will be masterized in this Netezza Technology and who will be competent to resolve client queries. These Trained associates will support the clients using both the business & technology perspectives acquired to this Training.

The Netezza Quick Start Program is a 30 days program which will address all the issues and queries which will be raised by the client during the initial phase.

We will provide support and guidance to the client for the first thirty days during Project initiation. Our ultimate goal through this Training is to acquire the utmost client satisfaction.

This Quick start Training package includes concepts of, Netezza - Professional/Advanced/Quick Start and also it is inclusive of Soft skill sessions which may deal with the communication capabilities, customer relationship & other behavioral aspects in terms of communication.

"Games people play"

As an initiative of Systech Academy, we had a presentation on "Games people play" by Mr. Umapathy, Deputy General Manager, Talent Transformation, Reliance Retail Ltd. on June 06th, 2008.

This initiative is to provide sessions on soft skills which will help the associates to equip themselves in those areas and to mark their presence as an active player in whatever role they perform. Such sessions help them to plan, execute, adapt to change and learn from their experiences. To brief about the session, it was interactive and thought provoking. The various topics discussed in this presentation are,

• People relation
• Positive stroke
• Roles people play
• Self realization
• Customer satisfaction

Business Objects XI Essentials training

Trainer : Mariappan, Gomathi Nayagam
Date : 30/May/2008 to 06/June/2008
Venue : Conference Hall
Duration : 14 hrs (Class room Training), 2 hrs/day

Business Objects XI Essentials training is aimed at basic awareness of BO XI architecture, new features/componets of BO, design a universe with necessary contexts, resolve loops, traps and crea te objects, hierarchies. The training also includes report creation, formatting reports, export to repository, scheduling reports using central management console, create and manage users/groups. Brief course content is as below,

• BusinessObjects Desktop Intelligence Report Design
• BusinessObjects Desktop Intelligence Advanced Report Design
• Introduction for Administering Users and Content
• Overview of BusinessObjects Universe Design
• Overview of Scheduling Reports

SSIS (SQL Server Integration Services) Training

Trainer : Neelakantan, Mohana Priya & Abubaker, Shabeer Ahmed
Date : 23/May/2008 to 28/May/2008
Venue : Conference Hall
Duration : 10 hrs – classroom training (2 hrs/day)

It is an essential trait of a BI consultant to understand the basics of SSIS as it helps them to work in the ETL projects. This Training covers the following SSIS concepts,

• Introduction to Sql Server 2005 Integrated Services
• Overview of Control flow elements
• Overview of Data flow elements
• Introduction to event handlers
• Overview of Variables

Microstrategy Essentials Training

Trainer: Maruthu Pandian
Date: 09/May/2008 to 19/May/2008
Venue: Conference Hall
Duration: 14 hrs – classroom training (2 hrs/day)

It is an essential trait of BI consultants to understand the basics of MicroStrategy as it helps them to work in the Reporting projects. Throughout this course, consultants were imparted with knowledge from practical experience. This course was aimed to understand the design process involved in configuring and developing microstrategy project, inclusive of the following courses:

• Overview of MicroStrategy Desktop
• How to model and design a MicroStrategy Project
• MicroStrategy Report Services
• Overview of MicroStrategy Web

Database Essentials: Oracle Training

Trainer : Hariharasudhan Krishnaswamy
Date : 29/April/2008 to 06/May/2008
Venue : Conference Hall
Duration : 14 hrs – classroom training (2 hrs/day)

Through this Training associates will learn the following components of Database Essentials: Oracle. This program provides them the indepth understanding of the concepts bound with this technology,

• Oracle architecture
• Oracle Tuning
• SQL Tuning
  - Optimizer Concept and Techniques
  - Generation of Explain Plan - and Understanding the Sql plan
  - Index Concepts - B-Tree and Bitmap Indexes
• ETL Concepts and Queries - Oracle New Features and ANSI Standard Queries

Netezza: Professional Training - April 2008

Trainer : Vadivel Perumal, Balakrishnan Kannaiyan
Date : 21/April/2008 to 30/April/2008
Venue : Conference Hall
Duration : 16 hrs (classroom Training) - 2 hrs/day

Netezza Professional Training by Vadivel Perumal & UNIX/LINUX concepts Training by Balakrishnan Kannaiyan. Netezza being an essential trait of a BI consultant, this Training helps the consultants to understand the concepts of this technology & also it helps them to work in the ETL Projects. Topics covered under this Training Programme are,

• Introduction to Netezza Architecture and Administration
• UNIX/LINUX concepts
• Netezza Database Objects Overview
• Using NZSQL
• Netezza Basic Commands and its Operations
• Netezza Connectivity and Statistic Planning

Oracle Business Intelligence: Professional Training

Trainer : Anu Umadevi Karthikesan
Start Date : 08/April/2008 to 23/April/2008
Venue : Conference Hall
Duration : 16 hrs (classroom Training) - 2 hrs/day

Through this Training associates will gain a foundational understanding of the prebuilt components of Oracle Business Intelligence Applications and foundational understanding of business intelligence concepts, Oracle BI Enterprise Edition architecture and user interfaces and create simple Repository, Answers, and Dashboards.

This Training covers the below listed concepts,

• Key components in OracleBI architecture and OracleBI Applications
• Relationships among the components
• Identify and describe repository features and functions
• Design the repository and test the repository using Answers
• Build queries in OracleBI Answers
• Create and modify OracleBI Interactive Dashboards
• Publish a BI Publisher report created from BI Server repository and Oracle BI Answers

Through this Oracle Business Intelligence Training, associates will be equipped in creating OracleBI repository, quality reports and dashboards with OracleBI Presentation Services.

Certificate presentation ceremony - MSTR Certification exam

Date - 01/April/2008

Venue - Conference Room

Timings - 12:00 to 01:00 P.M

We have conducted the Certificate presentation ceremony on 01/April (Tuesday) for the below listed associates who have successfully cleared their, "Microstrategy Certification Exam". Congratulations to all these associates.

Associates
1. Mani, Arun
2. Arunachalam, Ayyappan
3. Sudarsan, Bharath Ram
4. Panneer Selvam, Dhivya
5. Shahul Hameed, Feroz
6. Nagarajan, Kannan
7. Gurumurthy, Lakxmi
8. Appadurai, Selvakumar
9. Abubaker, Shabeer Ahmed
10. Venkataramana, Sreenivasaraghavendran
11. Paramasivam, Thanigaivel
12. Rajendran, Dinesh
13. Sankaranarayanan, Vani
14. Chenthil Kumar, Krithika
15. Zehra, Durdana
16. Thangapandian, Prasanna Kumar
17. Ganesan, Srinivasan
18. Nathan, Prabhavathy
19. Subramani, Raja
20. Sethuraman, Karthikeyan

Certificate presentation ceremony - DI Certification Exam

Date - 31/March/2008
Venue - Conference Room
Timings - 12:00 to 01:00 P.M

We conducted the Certificate presentation ceremony on 31/March (Monday) for the below listed associates who have successfully completed their DI Certification Exam (Sep' 07 bacth).

Associates
1. Aarthi Prabakaran
2. Arun Gnana Vijay Iruthayaraj
3. Bharath Ram Sudarsan
4. Dhanalakshmi Govindaswamy
5. Kannan Nagarajan
6. Madhanagopal Sankararaj
7. Nabajit Dutta
8. Sathish Kumar Nithyanandam
9. Shabeer Ahmed Abubaker

Microsoft Excel: Proficiency Training

Trainer : Ramya Sharathkumar
Start Date : 28/March/2008 to 01/April/2008
Venue : Conference Hall
Duration : 3 hrs, 1 hr/day classroom Training

This Training gives an insight to most of the important features of Excel in BI space and helps in preparing reports, analyzing and validating data. The Training includes the following basic & advanced concepts.

Basic Concepts - Page setup, Paste Special, Find & Replace, Go to, Custom Views, Header & Footer, Comments, Error Checking, Share workbook, Sort, Import & Export, Freeze panes,
Templates, Emailing, Naming Conventions

Advanced Concepts - Chart, Functions, Name, Auto format, Conditional Formatting, Macro, Track Changes, Filter, Subtotal, Validation, Pivot table & chart, List, Errors, Protection

Project Presentation - DI Bootcamp Training (Jan 2008 batch)

Start Date: 10/March/2008
End Date: 19/March/2008
Venue: Training Hall (2nd Floor)
Panel Members: Sethu Rayar; Yogendra Kumar Pradeep Singh; Jayalakshmi Lakshman; Najeeb Ahmed Khan; Naga Subramanian; Santosh Kumar Kannan

Project presentation was conducted for the Jan-2008 Bootcamp Trainees. The Trainees were assigned with a Simulation Project - Ken Tires and it was scheduled for 2 weeks duration. This presentation was conducted with an objective to evaluate the Trainees understanding on the Business concepts and BI technologies that drives the Project. Each individual was given 45 mins. for an oral presentation with a supportive PowerPoint doc and 15 mins. was alloted for Q & A session by the panel members.

Presentation went interactive and the questions posted by the panel members induced the Trainees to map their technical understanding on business grounds. In addition to that the session also helped the Trainees to explore the real time business scenario & the key role played by a BI Consultant.

Thanks to the panel members for their support, involvement and also for helping us to meet out our objective behind the session.

BO XI: Essentials Training

Trainer : Sridhar Koilada
Start Date : 17/March/2008 to 26/March/2008
Venue : Conference Hall
Duration : 12 hrs, 2 hrs/day classroom Training

Business Objects XI R2 Essentials training is aimed at basic awareness of BO XI architecture, new features/componets of BO, design a universe with necessary contexts, resolve loops, traps and create objects, hierarchies. The training also includes report creation, formatting reports, export to repository, scheduling reports using central management console, create and manage users/groups.

Advanced Miscrostrategy Training

Trainer : Anu Umadevi Karthikesan, Saravanan Selvaraj
Start Date : 10/March/2008 to 25/March/2008
Venue : Conference Hall
Duration : 20 hrs, 2 hrs/day classroom Training

It is an essential trait of a BI consultant to understand the Advanced Concepts of MicroStrategy as it helps them to work in the Reporting projects individually. Training includes the below listed essentials concepts of advanced level,

• MicroStrategy Desktop: Advanced
• MicroStrategy Intelligence Server
• Advanced Features of MicroStrategy
• MicroStrategy Narrowcasting
• MicroStrategy Enterprise
• MicroStrategy Web Report

Certification exam was conducted 16th April, 2008 at the end of Training Program. Below is the details of the scores secured by the associates.

Associate - Score (Out of 100)

1. Arunachalam, Ayyappan - 82
2. Abubaker, Shabeer Ahmed - 78
3. Nagarajan, Kannan - 56
4. Rajendran, Dinesh - 64
5. Sambathu, Ramya - 76
6. Sankaranarayanan, Vani - 82
7. Sethuraman, Karthikeyan - 54
8. Sudarsan, Bharath Ram - 54
9. Venkatesan, Keerthana - 80
10. Venkataramana, Sreenivasaraghavendran - 72
11. Zehra, Durdana - 64

Note: Pass criteria 75%

"Data Warehouse Appliances: Evolution or Revolution?"

Session: Data Warehouse Appliances: Evolution or Revolution?
Date: 6th March 2008
Timings: Between 2.30 pm to 3.30 pm
Venue: Conference Room
Conducted by: Koilada Sridhar, Ranganatha Babu Kaushik, Subashchandrabose Shanthi, Ganesh Selvaraj, Panneer Selvam Dhivya

An informative session on "Data Warehouse Appliances: Evolution or Revolution?"
This session helped the associates with the following updations: current trend, purpose, need and various types of Datawarehouse Appliances. It also includes the Architectural part of the DW Appliances.

Real time examples were quoted including the case studies of companies like PBG, Epsilon Data Management, etc which explaied the reasons for their switch over to DW Appliances like Netezza, Teradata, IBM, Greenplum etc.

The Case Studies were explained by the experts - Koilada Sridhar, Shanthi, Kaushik and Dhivya.

The Team includes Ganesh Selvaraj, Ranganatha Babu Kaushik, Koilada Sridhar, Subashchandrabose Shanthi, Panneer Selvam Dhivya

Congratulations to the Team for providing such an interactive knowledge sharing . This session received an overwhelming response from associates, the discussion hall was flooded.

"Nationwide Insurance - Business Review"

Trainer : Kandha
Date : 29-Feb-2008
Venue : Conference Hall
Timing : 04:00 P.M to 05:30 P.M

An interactive session on "Nationwide Insurance - Business Review" by Mr.Kandha has given a broader vision & exploring the Business model of Nationwide Project. The prime focus of this Training is to inculcate Associates with the Business concepts & the benefit behind a systemic approach. This real time project knowledge sharing session also included the etiquettes to be followed by the Project Team.

This session is a wholesome bunch of Business, Project management etiquettes and lot more.

On behalf of Systech India Associates we thank Kandha for sparing his time with us and for delivering us such an informative session.

“Advanced Informatica" Training

Trainer : Sathiya Narayanan Manickam Srinivasan
Start Date : 25/Feb/2008 to 03/March/2008
Venue : Conference Hall
Duration : 18 hrs Classroom Training (2 hrs/day)

“Advanced Informatica Training” by Sathiya Narayanan Manickam Srinivasan has helped the Trainees to explore the technique behind each and every informatica function. The prime objective of training is to impart the trainees with enough knowledge which will help them run in their career and projects. This Training is focused to develop knowledge and also included the real time project experiences.

The explanation on below listed Informatica concepts and the educative exercises helped in analyzing each concept in depth.

• Debugger
• Normalizer transformation
• Dynamic and shared lookup caches
• Mapping parameters and variables
• Advanced expressionsMapping optimization

On behalf of Training Department thanks to Sathiya, for his extensive involvement, effort & support towards this Training Program.

Certification exam was conducted 11th March, 2008 at the end of the Training Program. Below are the details of the scores secured by the associates.

Associate - Score (Out of 100)

1. Balasubramani, Sarveswari - 19.5
2. Chenthil Kumar, Krithika - 13
3. Dutta, Nabajit - 18.5
4. Ganesan, Srinivasan - 13.5
5. Lakshman, Jayalakshmi - 26.5
6. Mohan, Hari Krishnan - 33
7. Mohapatra, Ashis Kumar - 25
8. Palaniappan, Meena - 19.5
9. Perumal, Vadivel - 20.25
10. Rajendran, Dinesh - 17.5
11. Raman, Senthil Nathan - 17
12. Sengottaian, Boopathi - 22
13. Sreenivasaraghavendran - 22
14. Venkatramani, Ramanathan - 22
15. Zehra, Durdana - 29.5

Note: Pass criteria - 50%

"Microstrategy Essentials" - Feb 2008

Trainer: Anu Umadevi
Date: 04th Feb to 19th Feb

It is an essential trait of BI consultants to understand the basics of MicroStrategy as it helps them to work in the Reporting projects. Throughout this course, consultants were imparted with knowledge from practical experience. This course was aimed to understand the design process involved in configuring and developing microstrategy project, inclusive of the following courses:
• Overview of MicroStrategy Desktop
• How to model and design a MicroStrategy Project
• MicroStrategy Report Services
• Overview of MicroStrategy Web

Congratulations to Anu Umadevi & Team, for their extensive involvement & support which made this Training Program successful.

Certification exam was conducted 19th February, 2008 at the end of the Training Program. Below are the details of the scores secured by the associates.

Associate - Score (Out of 100)

1. Arunachalam, Ayyappan - 94
2. Mani, Arun - 90
3. Sudarsan, Bharath Ram - 88.5
4. Panneer Selvam, Dhivya - 93.5
5. Shahul Hameed, Feroz - 94.5
6. Nagarajan, Kannan - 92
7. Gurumurthy, Lakxmi - 86
8. Appadurai, Selvakumar - 76
9. Abubaker, Shabeer Ahmed - 88.5
10. Sreenivasaraghavendran - 94
11. Paramasivam, Thanigaivel - 87.5

"Introduction to Business, Business Concepts & Business Elements"

Trainer: Arun Gollapudi
Date: 19-Feb
Venue: Training Hall
Duration: 3 Hours


An interactive and informative Training conducted by Arun Gollapudi on "Introduction to Business, Business Concepts and Business Elements". The topics are, two major heads of Business viz. a) Strategy b) Marketing - 4 P's of Marketing, Value Chain model, demographic framework, core business strategy / processes.
A Training all about Business mapped with real time examples helped the DI Bootcamp Trainees (Jan 2008 batch) to get a clear picture about the Business concepts correlated with Business Intelligence.

"Netezza: Professional Training" - Feb 2008

Trainers: Shanthi Subashchandrabose and Vamsi Pentakota Mohan
Start Date: 11-Feb
Venue: Conference Hall
Duration: 20 Hours total (Classroom Training)

Ongoing Netezza Professional Training by Shanthi Subashchandrabose & UNIX/LINUX concepts Training by Vamsi Pentakota Mohan. Netezza being an essential trait of a BI consultant, this Training helps the consultants to understand Netezza concepts & it helps them to work in the ETL Projects. Topics to be covered in the Training Programme,

• Introduction to Netezza Architecture and Administration
• UNIX/LINUX concepts
• Netezza Database Objects Overview
• Using NZSQL
• Netezza Basic Commands and its Operations
• Netezza Connectivity and Statistic Planning

Certification exam was conducted on 14th March. Below are the details of the scores secured by the associates.

Associate - Score (Out of 100)

1. Ayyappan Arunachalam - 63
2. Dinesh Rajendran - 56
3. Durdana Zehra - 60
4. Fredrick Jose Antony Cruz - 54
5. Krithika Chenthil Kumar - 62
6. Malathi Rajarethinam - 48
7. Meenambal Sivaramakrishna Iyer - 65
8. Prabhavathy Nathan - 58
9. Sarveswari Balasubramani - 59
10. Senthil Nathan Raman - 49
11. Sivanesh Babu Anandaraman - 52
12. Srinivasan Ganesan - 67
13. Yogendra Kumar Pradeep Singh - 71

Note: Minimum pass criteria being 60%

“Project Management: Team’s Perspective” - Feb 2008

Trainer: Maruthu Pandian
Date: 04th Feb to 06th Feb
Venue: Conference Hall
Duration: 6 Hours total (2 hrs/session)

Project Management Training conducted by Maruthu is aimed to discuss all Project Management activities. Topics covered in this Training includes: Project, Project management, Project Life Cycle, Process Group, Project Management Knowledge Areas, Systech PM Framework, Effective Project Team. This Training will help Trainees to learn many project related processes, Planning & tracking project activities, addressing risks during project execution and their appropriate solutions.

"Microstrategy Essentials" - Jan 2008

Trainer: Maruthu Pandian
Date: 09th Jan to 22nd Jan
Venue: Conference Hall
Duration: 10 Hours total (Classroom Training)

It is an essential trait of BI consultants to understand the basics of MicroStrategy as it helps them to work in the Reporting projects. Throughout this course, consultants were imparted with knowledge from practical experience. This course was aimed to understand the design process involved in configuring and developing microstrategy project, inclusive of the following courses:

• Overview of MicroStrategy Desktop

• How to model and design a MicroStrategy Project

• MicroStrategy Report Services

• Overview of MicroStrategy Web

Certification exam was conducted at the end of the Training Program. Below are the details of the scores secured by the associates.

Associate - Score (out of 100)
Chenthil Kumar, Krithika - 91.5
Ganesan, Srinivasan - 84
Nathan, Prabhavathy - 81.5
Rajendran, Dinesh - 98
Sankaranarayanan, Vani - 98
Sethuraman, Karthikeyan - 73
Subramani, Raja - 74
Thangapandian, Prasanna Kumar - 85
Zehra, Durdana - 87.5

"DI Bootcamp Training" - Jan 2008

Ongoing DI Bootcamp Training is conducted with an objective to prepare every Trainee better, who will be capable enough to be made productive on a Project, immediately after the completion of 6 Weeks of Bootcamp Training Program and who can play the Role of a Team Member with the below mentioned capabilities,

• Understand and Interpret the below Project Documentation
• Understand DW/ETL Concepts, Data Modeling, Analyze a given Data Model
• Develop ETL Scripts with SQL/PL-SQL Programming
• Develop Report Generation Scripts with SQL/PL-SQL Programming
• Develop Informatica Code with the Provided Design
• Develop and execute Test Cases and debug the above developed Scripts in case of Issues.
• Report Project Status with the help of a Task List and Escalate Issues with the help of an Issue Log