Manager Data
Resume:
TAMILCHELVAN BALACHANDRAN
SENIOR CONSULTANT
Cell # 908-***-**** email: *************@*****.***
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