TAMILCHELVAN BALACHANDRAN

SENIOR CONSULTANT

Cell # 908-***-**** email: abqwo3@r.postjobfree.com

PROFILE

** ***** ** *********** ** experience in Pharmaceutical, Banking, Finance, Insurance, Logistics and

•

Telecom with strong hands on experience in Data warehousing, OLAP, ETL and Report generation

specializing in COGNOS and Qlikview

7 years of Hands-on Professional experience in OLAP using COGNOS BI Tools (Framework Manager,

•

Report Studio, Query Studio, Analysis Studio, Cognos Connection, Cognos Configuration, Cognos

Impromptu, Cognos IWR, Access Manager, Upfront and Analytical tools like Cognos Transformer Cube &

Power Play)

Area of expertise encompasses reporting, modeling, SQL performance Tuning, Database designing and

•

ETL phases of Data Warehousing. Working knowledge of the Star Schema and Snow Flake Schema

Design Strategies

Extensive experience in RDBMS like Oracle, MS SQL Server, Sybase and DB2. Experience in creating

•

complex Stored Procedures, DTS packages, triggers, cursors, tables, views and other SQLs and PL/SQLs

Strong knowledge in all the phases of Software Development Lifecycle Analysis, Estimates, Design,

•

documentation, coding, implementation and Testing of business technology solutions

Worked exclusively with the End users in understanding the requirements of the system. Worked with

•

Business users in finalizing the requirement and design and deliver the reports and solutions

Ability to prioritize tasks well and work on multiple tasks. Highly motivated, result oriented professional

•

with Good Analytical abilities, Technical Skills, excellent Communication Skills

CERTIFICATIONS

COGNOS Development – Brain Bench

•

RDBMS Concepts – Brain Bench

•

EDUCATION

Master of Computer Applications, Kongu Eng College, Bharathiar Univ, India

Master of Business Management, Annamalai Univ, India

TECHNICAL SKILLS

Cognos 10.1.1(Configuration Manager, Cognos Connection, Framework

Reporting

Manager, Report Studio, Query Studio, Analysis Studio), Qlikview Enterprise

Tools

8.2 64-bit edition, Crystal Reports 8.5, Actuate e.Reporting Suite 5.0 for Unix

Informatica, DTS, DataStage

ETL Tools

Oracle8/9i/10G, MSSQL Server 7.0/2000, Sybase ASE 11.5, DB2 7.0

RDBMS

SQL, PL/SQL, Visual Basic 6.0, C, HTML

Languages

IIS

Web Server

PMIS, PVCS Tracker, Remedy, VSS, Visio 2003, Erwin, Team Tracker

Others

Operating Windows NT 4.0 / 95 / 98 / XP / 2000, Sun Solaris, HP-UX 11.x

System

CAREER ACHIEVEMENT

Awarded Recognition of Excellence for the Project “The Northern Trust – SSR” by Mascon Global Limited for

the work in NTGI and OSP

Awarded Service Excellence Award by IBM for the 3rd Quarter of 2008 in appreciation of my contributions and

Success for the engagement at Pfizer

EMPLOYMENT HISTORY

Duration Company Name Designation

Mar 2007 to Till Date IBM Corporation Global Business Services Senior Consultant

Mar 2005 to Feb 2007 Take Solutions Senior Analyst

Jul 2002 to Feb 2005 Mascon Global Limited, Chennai Systems Executive

PROFESSIONAL EXPERIENCE

Client: Raymond James., FL Jun 2012 – till date

Reporting Team Lead

IBM assists Raymond James with converting current reports, Report center to Cognos 10 solution. The

objective of this program is to implement all the existing reports and any client-facing reports critical to the

success of the Morgan Keegan (MK) integration effort; to migrate any existing MK reports identified as

functionality gaps and designated as "Fills" to the future-state Raymond James (RJ) reporting platform.

Responsibilities:

Meet Business Owners and Business Analysts to understand and provide solution to the requirements

•

Finalize the Report Technical Design Specification Template document

•

Identify gaps in the Requirements for Practice management, Client and Performance reports

•

Prepare Reporting Standards document and Developers Guideline document

•

Help in the approach for Report Template

•

Create Technical specification, Build, Develop, Unit test reports

•

Help RJ Developers when they have questions on the reports

•

Create tickets with Cognos help desk to implement a best solution

•

Knowledge transfer of the reports to RJ Developers

•

Remediate defects during QA and UAT

•

Interaction with Red team to get their feedback on the methods followed in developing reports

•

Client: Abbott., IL May 2011 – May 2012

Senior Report Developer

Abbott’s AES environment is the original and largest SAP environment supporting $15Bn of annual sales and

critical manufacturing sites globally. Abbott has decided to replace the SAP environment with a completely

new SAP ECC 6.0, Vistex, Vertax, Portal, BI and SRM platform, leveraging harmonized business processes,

new implementation methods and tools, and new ways of working. Scope includes Record to Report, Order to

Cash, Procure to Pay, Manufacturing, Supply chain, and Logistics/Warehousing. The overall five year program

is estimated at $850MM. IBM’s revenue in that timeframe is estimated to be $350MM.

Responsibilities:

Design and Develop Models and Reports for Procure To Pay (PTP) module

•

Interact with Cognos Support team for issues

•

Interact with SAP BW team for backend

•

Interact with Client team, includes Business Users and Area level experts

•

Prepare Project deliverables

•

Enhance and tune the Report Template

•

Maintain and support FUT folders

•

Knowledge sharing of PTP reports to Application Management Support Team

•

Client: Cephalon., PA May 2009 – May 2011

Data and ETL Analyst, Modeler and Report Developer

IBM worked with Cephalon to develop an Aggregate Spend Compliance Management Roadmap that will help

facilitate compliance to current State legislation and Office of the Inspector General (OIG) reporting

requirements. IBM implemented Customer Master and Aggregate Spend Reporting System (ASRS) that

included Health Care Professionals (HCP) and Institutions/Organizations (HCA) essential to support the spend

types required for state and federal/OIG reporting requirements. This solution will support Corporate

Integrity Agreement (CIA) for 2010 and 2011 as well as recently released State Legislation requirements.

The project will also help drive towards a “single source of truth” by propagating profile updates to SFA and

other systems.

Responsibilities in Customer Master:

Validate source data for Spend and prepare model to extract data from these sources

•

Unit test the various Siperian components of the system for Customer Master

•

Prepare and Validate System Test Scripts

•

Prepare Traceability matrix to map Functional spec, design spec, unit test cases and the system test

•

cases

Review the script and test results after execution

•

Prepare SQLs to execute the test scripts and run System test Scripts

•

Tracking defects in the SME log

•

Onsite Offshore coordination for test execution

•

Maintaining consistency check sheets of data loads at various stages

•

Maintain one time load for lookups

•

CM Analysis Deck to analyze the system, its LOV values, completeness of data, merge issues and

•

Traceability of data in the system

Validate the Auto merged records and suggest change to the Siperian auto merge rules based on the

•

manual merge queue volume and the quality of merged data

Create Cognos reports to the data stewards to help them prioritize the manual queue

•

Responsibilities in Aggregate State Spend Reporting System:

Source Data Mapping to ASRS and Source Extract Testing and Gap analysis to fix the issue

•

Perform ASRS loads and Maintain Run logs and Supervised the team mates for the loads

•

Perform ASRS Checks and Data Load Status Report results

•

Backup all relevant information after filing the report

•

Create Manual source files that involved complicated process

•

ASRS Fixes and Enhancements for better data quality checks and key logics changes in ASRS

•

Informatica and Cognos Code Version Control and Business Rules files Version Control

•

Investigate ASRS to accommodate the load of Health Care Accounts

•

Adjusting ASRS to support Multi-lingual characters from CM

•

Adjusting ASRS to support Related Entities

•

Mentoring and Supervision of resources on the project

•

Built the Cognos Framework model for Load Comparison Report and merged it with the ASRS Model

•

Update and Create project deliverables, which included Detailed design documents, Modification log,

•

test Plan, test scripts and Architecture design and decision document

Create DB objects for the Application and create stored procedures

•

Environment: Informatica 8.1.1, Oracle 10G, Siperian 7.0, Cognos 8.3

Client: Pfizer., NY Sep 2007 – Mar 2009

BI Reporting Team Lead

The Reporting team/Delivery and Reporting Environment (DARE)/Business Intelligence (BI) team of Pfizer

Data Management organization. It works to provide ad-hoc and pre-defined reporting capabilities to various

groups within Pfizer US Pharmaceuticals via Cognos reporting layer and Qlikview tool. The Reporting team

was responsible for transitioning and stabilizing the DARE from the S4 Transformation Delivery team. The

team was responsible for BI activities like:

Stabilization from S4 Transformation, Powers BI Dashboard and CORE Reporting, Field Force

•

Alignment related to Reporting, CBU-MM Reporting, DARE 2008 Projecting for Nation wide reporting

and reporting for all Business Units – Powers, Powers MS - EPI, Steere, Pratt, Specialty Markets,

Vista and Oncology. The reports are based on the Market, Product, Physician Type, Specialty,

Geography, Time period and Alignments. The reports covers the following subject areas like

Performance, Payers and Call Activity and analyze the trend and bench mark, Cognos Environment

Administration and Cognos Exploration

CSC Toolkit, which used Qliktech

•

Responsibilities:

Maintain and Support the Cognos Production Environment and Servers

•

Establish the new LDAP to the production Environment

•

Administer and Maintain the Users and Groups on the Cognos Production Servers

•

Handle enhancements and new developments to Powers BI Dashboard Reports

•

Field Force Alignment Impact analysis and change to the production reports

•

Territory based Security implementation to the Powers Core Reports

•

Performance tuning of the Existing reports (BI Dashboard Reports and Powers Core Reports)

•

Development, Fine tuning the Cognos Model of BI Dashboard Reports and Powers Core Reports

•

DAO Security Implementation for Cognos Powers CORE Reports

•

Level 2 and 3 support for the CSC Toolkit application used by Customer Service Center Representatives

•

System Testing the CSC Toolkit Application for the new release

•

Automation and maintenance of the CSC Toolkit Reloads

•

Impart Knowledge to Level 1 support and Creating run book for Level 1 support

•

Initiatives on Cognos Cubes

•

Environment: Cognos 8.3, Oracle 10G, Qlikview Enterprise 8.2 X64

Client: Genzyme., Cambridge, MA Jul 2007 – Sep 2007

Testing Consultant

The Clinical Data Warehouse (CDW) system will enable more efficient and accurate processes for SAE

Reconciliation, Adverse Event and Concomitant Medication Coding, and the systematic capture of external

data sources. The external data sources include EDC, CRO, Central Labs and Specialty Labs. The central

and specialty labs have additional reconciliation processes needing workflows that are more efficient. In

addition, the first phase will provide a foundation of clinical trial data with a standard data structure enabling

the reuse of SAS programs. The CDW will also serves as data integration hub between transactional

systems.

Responsibilities:

Mapped the FRS with Test Cases for preparing the Traceability Matrix

•

Prepared the System Test Scripts

•

Reviewed the System Test Scripts

•

Wrote SQLs for the test scripts

•

Run the System Test Scripts which compared the system with Configuration Specification

•

Filled the Incidents log

•

Track the incidents to closure

•

Interacted with the clients for UAT: Analyzed the clarified the issues raised by them and tracked them to

•

closure

Environment: Informatica 7.1, Oracle 10G, Cognos

Client: Bristol-Myers Squibb., Plainsboro, NJ Mar 2007 – Jun 2007

Testing Consultant

The State Reporting System provides BMS USP with a centralized repository of integrated data required to

support Spend reporting per the requirements defined by the business users.

States require monitoring and/or disclosures on the value, nature, and purpose of spend (Spend Data)

incurred by pharmaceutical companies on individual healthcare professionals and institutions that prescribe,

dispense, and / or influence the purchase of pharmaceutical products.

Responsibilities:

Mapped the FRS with Test Cases for preparing the Traceability Matrix

•

Prepared and reviewed the System Test Scripts

•

Wrote SQLs for the test scripts

•

Run the System Test Scripts which compared the system with Configuration Specification

•

Filled the Incidents log and Track the incidents to closure

•

Interacted with the clients for UAT: Analyzed the clarified the issues in UAT and tracked them to closure

•

Environment: Unix, Informatica, Oracle 9i, MS Access

Client: NOVARTIS., Florham Park, NJ Nov 2006 – Feb 2007

Cognos Developer

Clintelligence is Clinical software implemented in Novartis for their clinical study tracking. Reports developed

using Cognos Version 8.1. This version of reports covers Oncology and Medical affairs for their clinical study,

which tracks the study in its hierarchy and also tracks the risk and the goals of the project.

Responsibilities:

Developed and maintained Overview reports

•

Design of reports in Report Studio, Created Prompts, Filters, Conditional expressions

•

Created list based reports, Chart reports and Master detail reports

•

Created Drill-Through which dynamically calls the report with parameters

•

Interact with the business analyst in implementing the needs of the customers

•

Created Views and Procedure for the reports to calculate the goals and risks on the fly for the reports

•

Environment: Cognos 8.1, Oracle 9i

Employer: Take Solutions Ltd, Chennai and Take Solutions Inc., Princeton, NJ

Lead Cognos Developer Nov 2005 – Oct 2006

One Clinical is a Clinical Trial System for pharmaceutical companies that extract data from different source

systems by using different types of “Source Adapters”. The extracted data from the source systems will be

stored in the Staging area where cleansing is performed. The UDDM (Universal Drug Development Model) is

the target repository and is meant for capturing all the details pertaining to trail completion, administration

and safety data through a set of business rules. UDDM comprises of Integrator and Distributor from where

we arrive at the Information, Metrics and Intelligence. The distributor is intern divided into data marts for

reporting. Based on the output we classify them as CLIN Govern: Includes IND and FDA Reporting, CLIN

Seek: Deals with the data mining and intelligence reporting, CLIN Metrics: Works on signal-detection and

arriving at standards

Responsibilities:

Developed Framework Manager models, involving the creation of Query subjects, Query Items, Shortcuts

•

for the FDA and IND reports

Recreated the old reports from Impromtu to reportnet

•

Created reports for various users spanning all over Europe, Asia and US

•

Setup Bursting in report studio and query studio

•

Used Visio for creation of logical E-R Diagram before creating the Catalog

•

Developed Standard Templates

•

Involved in writing procedures and views required for reports to improve performance

•

Created and maintained Power Cubes for the Clin metrics and Clin Seek modules

•

Preparation of the High Level Design Document in sink with the requirements specification document

•

Interaction with the Domain experts and coordinating the off-shore team

•

Use Performance Monitor and SQL Profiler to optimize queries and enhance the performance

•

Prepared test cases and interacted with the Analysts and the Quality team

•

Environment: Cognos Reportnet 1.1(Framework Manager, Report Studio), Cognos EP Series

7.1(Impromptu, Transformer, PowerPlay, Web Reports, Scheduler), SQL Server 2000, Data

Sources – CT4, SQL Server 2000, Flat files

BIA Data Mart, Advantage Management Solutions, Irvine, CA Aug 2005 – Oct 2005

Senior Analyst/Lead Cognos Developer

UCB Japan a pharmacy based company has instructed Advantage Management Solutions (AMS), California to

design, implement and operate its Customer Master, Operational DB and Data Mart as part of UCB Japan’s

Business Information Architecture. Data is received from UCB and Dendrite in the form of raw data files,

house the integrated data in a consolidated data mart and provide reporting capability through a Web Portal

and analysis capability through Impromptu web reports. UCB data mart consists of three databases i.e. Raw

DB, Operational DB and Data mart. This UCB and Dendrite raw data is loaded (consolidate/Incremental) into

the Operational DB and then to the data mart as per the business logic. Periodic data are generated by UCB

internal system such as sales and employee (e.g. Medical Representative) management, UCB SFA system

(Dendrite) and are also purchased from external syndicated data provider such as IMS and Ultmarc.

Responsibilities:

Involved in knowledge transfer with the AMS team on the BIA project

•

Prepared specifications document on the existing reports and packages on the UCB and IMS feeds

•

Generated reports for the Ultmarc data feed implementation based on the inputs from Business users

•

Updated the Ultmarc feed info to the existing cubes

•

Scheduled the report to run on a regular basis by estimating the time of load

•

Ran daily data load from Raw DB to Operational DB and from Operational DB to Data mart using DTS

•

packages

Ran QC (Quality Check) reports on SQL Reporting Services and Flash reports on MSTR

•

Implemented automated jobs for database backup on a daily basis based

•

Interaction with the AMS team and carrying out their recommendations

•

Environment: Cognos EP Series 7.1(Impromptu, Transformer, PowerPlay, Web Reports,

Scheduler), DTS and MS SQL Server 2000, Data Sources –Flat files

Telekom Malaysia, KL, Malaysia Mar 2005 – Jul 2005

Cognos Technical Consultant

As part of TM’s (Telekom Malaysia) group wide Customer Relationship Management (“CRM”) initiative, the

CRM division has initiated the Sales Force Automation (“SFA”) project with the aim to improve their sales

force effectiveness covering their Retail and Wholesale Operating Units. The operational reports for the TM

SFA project will be delivered using Cognos, through the Onyx Operational Reporting and Onyx Analytics

Reporting bundling.

Responsibilities:

Highlighting the unexplored features of Impromptu to the Technical Team of Solsis

•

User IDs Creation in Access Manager

•

Table Weighting, Query Performance, Client server balancing

•

Created bursting of reports which a part of implementing security at report level

•

Created dimensions, levels and hierarchies

•

Created Multi-Dimensional Cubes and Reports as per the User Requirements

•

Interacted with the Phase I architecture team to leverage the existing framework to IWR

•

Change existing Impromptu reports to IWR. Publish Reports and Cubes to IWR

•

Used Power Play Enterprise Server to publish the cubes

•

End user training on Cognos suite of products to the various level of users in the organization

•

Set up security for user classes, users and access rights to data within the application

•

Environment: Cognos EP Series 7.3 (Impromptu, Transformer, PowerPlay, Impromptu Web

Reports, PowerPlay for Web), Oracle

Employer: Mascon Global Ltd, Chennai

USFC, Chicago, IL Apr 2004 – Feb 2005

Analyst

USFC – United States Freight Carrier, a leading Logistics formed by union of 5 Carriers. USFB – USF Bestway,

HMES – USF Holland, DUGN – USF Dugan, RETL – USF Reddaway, RSEL – USF Red Star

Before USFC is formed these companies are involved in transportation of shipments in their specified regions.

So the customer used to go for different carriers whenever there is a need to book a shipment across regions

operated by different carriers. Now the USFC is the only one where the customer can go and book the

shipments without worrying about how many carriers are going to be involved and who is going to deliver

the shipment at destination. Depending on the number of carriers the services of USFC is divided into 2 parts

like Premier, intra-territory shipment and Premier Plus, inter-territory shipment.

Responsibilities:

Create Catalogs, user classes, folders and Prompts in Impromptu

•

Create complex impromptu reports using slice & dice, Drill Down, Drill Through based on the specification

•

Created and maintained two Power Cubes for Personnel and sales

•

Created Linked reports

•

Set the graphical representation of cubes in Cross tab, pie, 3d bar and single line

•

Developed procedures and views for the reporting needs

•

Involved in Analysis, Development, Testing and Tuning

•

Exception highlighting, sorting, ranking etc

•

Helped identifying the Key Performance Indicators, Trends and Association Analysis for the Business

•

Environment: Cognos EP Series 7.1(Impromptu, Transformer, PowerPlay, Web Reports,

Scheduler), SQL Server 2000

Smart Stream Reconciliation (TNT – SSR), the Northern Trust Bank, Chicago, IL

Senior Actuate Developer Dec 2003 – Mar 2004

This is a maintenance project to incorporate the handling of raw data to SWIFT Format and there by

automating the Reconciliation job. The Smart Stream Reconciliation (SSR) system is a vendor package

designed and developed by Smart Stream Technologies Inc., for use by financial institutions and their

correspondents. The system reconciles the information found on the institution’s internal ledgers and the

external statements. There are several agent, sub agent, cash, stock, exceptional, log reports to help the

business partners at UK and US. This also includes relocation of major accounts to a separate server.

Responsibilities:

Provide Severity 1 Production Support to ensure that the system is up and running with downtime not

•

exceeding the threshold

Make all fixes required that may be reported by Business Partners or discovered internally

•

Escalate/ co-ordinate with other systems partners (like DBAs, UNIX) to provide periodic support and

•

ensure system availability

Communicate any system outages and other failure notifications to all the concerned business partners

•

Create or maintain actuate reports for US, UK, NTGI & OSP as required/specified by Business Partners

•

Proactive maintenance of the code for performance improvements

•

Escalate/ co-ordinate with the technical support team at STI for any functional defects in the system by

•

raising and following-up heat calls

Environment: Actuate 5.0, UNIX, Sybase ASE 11.5

BPI Core Administrative Systems, Benefit partners Inc, Orange County, CA

Cognos Developer Dec 2002 – Nov 2003

BPI (Benefit partners Inc.) is an organization doing administrative work for an Insurance provider called PAC

advantage. The major modules covered are Carrier Maintenance, Sales and Marketing, Enrollment and

Finance. BPI Reports are broadly classified into two types, interactive reports and scheduled reports, which

will sent as an attachment through e-mails. The interactive reports are generated using Impromptu. The

Later use Cognos Impromptu and Powerplay for Management. Dimensions against Time, Sales, Enrollment,

Marketing Agent, Policy and Region were used to create and generate reports.

Responsibilities:

Generated reports(List, Crosstab, Mailing Labels, Form Letter) as per the requirements using COGNOS

•

Impromptu and create and review of functional and technical specs

Developed & generated scripts for building the database structure (tables & synonyms)

•

Created PowerPlay cubes using Transformer

•

Created User Classes for catalogs and used Access Manager to administer security for all the catalogs

•

Defined conditions, calculations and prompts in the catalog

•

Used Impromptu’s optimizing features like table weighing, governors, bulk fetch

•

Published IWR on the web server and create audit controls

•

Created Hierarchies from providing drill down options for the end-user

•

Coordinated in training sessions and demonstration of COGNOS tools to End-users

•

Environment: Cognos EP Series 7.0 (Impromptu, Transformer, PowerPlay), DB2 7.0, J2EE

iBranch and iPRO, TNSC Bank, Chennai and PSC Bank, Pondicherry Dec 2001 – Nov 2002

Developer

iBranch, a Total Branch Automation Package for core banking. iPRO is Head office automation, which involves

consolidation all branches along with other HO activities. The front end is an executable that calls the Visual

Basic DLL that handles the business logic; Visual C++ formed the next layer that handles the Database

transactions like Insertion, updating and deletion in SQL Server. The data can be viewed for analysis,

interpretation and decision-making and is available in Crystal Reports. Previously, it was a text-based report.

Responsibilities:

Handled the client side, business and end user interactions for requirements collection and fixing

•

schemes for the loans module

Created the init data for the application run

•

Associated with the client team and track several issues to closure

•

Developed and maintained the Loans and Clearing modules of the project

•

Transferring the reports from text format to Crystal Reports

•

Integrated the reports with the VB Front end

•

Handled all the reports development comprising Branch related statements, HO related statements, MIS

•

based reports and others(Deposits, Loans, Clearing, Locker, Bills and weekly, monthly statements)

Environment: Crystal Reports 8.0, Microsoft SQL Server 7.0, Windows NT, VB 6.0, VC++

Contact this candidate