Management Manager
Resume:
Anandhi Somasundaram
*******************@*****.**.**
309-***-****(M)
Houston, TX
I have over twelve years of experience in Information Technology. My
expertise is in Cognos BI & Business Objects/ Informatica (7.1.3)
/Datawarehousing / Data Modeling. I have been involved in production
support and maintenance, which includes enhancements to existing Cognos BI
tools, software upgrades, bug fixes, and problem diagnosis. I have
performed upgrades, designed, built, tested, and administered Cognos BI
tools and has guided business customers in the development of new reports.
I am responsible for setting up groups and users for a Cognos User group
deployment, organizing and changing user properties. I have performed
extensively with Cognos 8 / Impromptu admin version and Power play
enterprise /Cognos Visualizer version to generate various ad-hoc and
permanent reports, cubes directly from transactional database as well as
from Data warehouses. I have working knowledge in SAS.
SOFTWARE/LANGUAGES/PACKAGES:
Appsworx DB2 MS Access
C/C++ Embarcado Oracle 8
COBOL Oracle Express Business Objects Suite
COBOL/400 Server 6.2 Oracle Express Objects
Brio Enterprise (BI) SQL Server 2005 PL/SQL
Cognos Impromptu Informatica 7.1.3 RPG/400
Cognos Poweplay Informix 7.2 Seagate Crystal Reporter
Cognos Transformer Data Integrator
Cognos Visualizer Java MS OLAP Analysis Service
Cognos 8 Tools /Cognos SDK Maestro
Hyperion Control -M SAS 8.1,
Manugistics (Demand Plan
Tools)
HP Service Desk / SFQ /
Remedy Service Desk
Tools
OPERATING SYSTEMS:
Unix DOS
Windows NT/2000
EDUCATION:
Bachelor of Engineering (Computer Science and Engineering)
TRAINING/CERTIFICATIONS:
SAS
Impromptu Web Reports - Cognos
Brio Enterprise
IBM Certification on AS/400
PROFESSIONAL EXPERIENCE:
Company Name Position From To Supervisor Address
Datacert Senior March Till Donna Rabalais 3040, Post Oak
Business 2010 to Blvd,Houston,
Intellig Date TX-77056
ence Phone: (713)
Develope 572-DATA (3282)
r Fax: (713)
572-3286
Ciber Inc Senior Novemb Februa Jessica Shields 205 North Main
Consulta er ry Street, 3rd
nt 2004 2010 Floor, Suite 3A,
Bloomington,
Illinois 61701
Phone:
Fax: 309-***-****
Wipro Associat Novemb Novemb Dayamoy 1300, Crittenden
Technologies e er er Chakaraborthy Lane, #200, 2nd
Consulta 2003 2004 Floor,
nt Mountain View, CA
94043
Phone :
Fax
650-***-****/68
Satyam Conputer Senior August Novemb Chandrasekar One Gatehall
Services Ltd Systems 2000 er Rachakonda/SanjayK Drive, Suite 301
Analyst 2003 umar Joshi
Parsippany, NJ
07054
Tel: +
Fax: +
Pentasoft Programm July July Prof. D.Nagarajan #1, First Main
Technologies er 1999 2000 Road
United India
Colony
Chennai 600 024
INDIA
SODAT Training Programm June June Prof G. Ravi Thanthai Hans
Centre er 1997 1999 Roever College
Elamabalur,
Perambalur-621212
Tamil Nadu -
India
Datacert - March 2010 - Till Date
As a Senior BI Developer, duties included:
. Working with Cognos 8 Framework Manager models
. Designing Packages and deploying them in Test / Prod Environments.
. Working with Cognos SDK in order to develop packages based other
matter management / spend management applications
. Setting up user account and maintenance
. Responsible for root cause analysis for problems.
. Involved in Defect Management Metrics.
. Working with SQL 2005 database
. Creating Report studio reports
. Maintaining existing report studio reports
Ciber Inc - January 2008 - February 2010
Client-Statefarm Insurance
As a Systems Analyst/Consultant, duties included:
. Responsible for migrating Cognos 7.3 V reports to Cognos 8 and setting
up Cognos 8 BI Environment.
. Providing support for new version of e-Gain knowledge management
search tool to support Service Management processes such as Incident
Management/Service Management/Problem Management/Change Management
. Providing support / maintenance for Cognos catalogs for both Service
Management/WLM reporting units. Responsible in development of Packages
using Cognos Framework manager and convert Cognos 7.3 V Catalogs into
Cognos 8 packages
. Responsible for ETL process using Integration Service Packages /
Informatica(7.1.3) to extract data from SQL Server2005 /DB2/Oracle 10g
data sources.
. Responsible for data modeling using Embarcadero to design database
schema's based on requirements.
. Developing Dashboards and scorecards in Cognos report studio sourced
from Cognos 8 cubes and database.
. Providing support for Work Load Management Database Reporting out of
Primavera tool
. Responsible for Cube / Transformer Powerplay cube training.
. Responsible for scheduling jobs using Control - M scheduling tool.
. Responsible for root cause analysis for problems.
. Involved in Defect Management Metrics.
. Working with migration/recreation of reports/cubes from Service
Desk/Service Manager.
. Providing support for Metrics team using HP Service Desk/HP Service
Manager for different process areas such as Incident
Management/Service Management/Problem Management/Change Management
. Responsible for leading the reporting team and guiding the team
members In their respective tasks.
. Followed Agile Project Management methodology in order to assign
tasks/track the activities.
Ciber Inc - November 2005 - December 2007
Client- Statefarm Insurance
As a Systems Analyst/Consultant, duties included:
. Gathering Business requirements and analysis
. Responsible for leading BI Reporting team by assigning work and
provide subject matter expertise.
. Providing support for Metrics team using HP Service Desk for different
process areas such as Incident Management/Service Management/Problem
Management/Change Management
. Providing support for Metrics team using WLM Data mart for employee
workload management activities and allocation of hours for each
activity
. Providing support / maintenance for Cognos catalogs for both Service
Management/WLM reporting units.
. Developing Dashboards / Scorecards using Transformer Cubes, Power Play
Reports, Impromptu Reports and Cognos Visualizer for different
departments.
. Responsible for User Class Security accounts
. Responsible for ETL process using DTS / Informatica(7.1.3) to extract
data from SQL Server/DB2/Oracle data sources
. Responsible for creating/maintaining Informatica job
workflows/sessions which compiled through job streams to load data
automatically.
. Responsible for data modeling using Embarcadero to design database
schema's based on requirements.
. Responsible for scheduling jobs using Control - M scheduling tool.
. Responsible for root cause analysis for problems.
. Responsible for creating ad-hoc reports in Cognos 8 (pilot work)
. Conducted requirements analysis
. Developing Dashboards / Scorecards using Transformer Cubes, Power Play
Reports, Impromptu Reports and Cognos Visualizer for different
departments.
. Responsible for creating ad-hoc reports in Business Objects
. Responsible for creating Universes in Business Objects
Wipro Technologies -November 2003 to November 2004
Client-JC Penny - September 2004-November 2004
As a Project Leader/Business Analyst, duties included:
. Provided support in Implementing Manugistics/ Cognos reporting
environment set up.
. Responsible for setting up Cognos environment which is packaged with
Manugistics(Networks Analytic Solution Package)
. Providing reporting solutions for JCPenney's different functional
areas like Forecasting/Monitoring/Market Management Programs
. Working with Project plans
. Conducted requirements analysis
. Responsible for customer communication and onsite coordination
. Developing Forecasting / Event Monitoring cubes using Transformer
Cubes, Power Play Reports, Impromptu Reports and Market Management
reports with Cognos ReportNet
. Responsible for User Class Security accounts
Client-Cadbury Adams - November 2003-August 2004
As a Project Leader/Business Analyst, duties included:
. Provided Cognos Server Administration support for application, quality
assurance, and production environments
. Responsible for User Class Security accounts
. Upgraded and installed Cognos servers
. Published reports using IWR in the Upfront website
. Configured Cognos server test environment
. Provided web-enabled access to reports and analysis in a Cadbury
Schweppes environment
. Monitored and performed capacity planning on Cognos servers
. Performed project planning
. Conducted requirements analysis
. Advised management on Cognos licenses
. Responsible for customer communication and onsite coordination
. Developed and automated Transformer Cubes, Power Play Reports,
Impromptu Reports
Satyam Computer Services, Ltd - August 2000 - November 2003
Client-Bear Stearns & Co. - October 2003-November 2003
As a Project Leader/OLAP Analyst, duties included:
. Provided Cognos technical support
. Responsible for converting backlog and revenue reports running in
PowerBuilder system as FBRS application to Impromptu reports,
published in Upfront
. Performed project planning
. Responsible for customer communication and onsite coordination
. Published the reports using IWR in the Upfront website
. Responsible for Ad-hoc query build and testing
. Provided assessment methodology for new version update and
requirements
Client-The Hartford Life Insurance - August 2003-October 2003
As a Project Leader/OLAP Data Architect, duties included:
. Responsible for migrating all currently scheduled jobs from Brio BI
Scheduler Version 5.5 to Version 6.6
. Installed Version 6.6 on a different server and migrated jobs to the
new environment scheduler
. Created reports from IQ Objects into Brio Version 6.6 Claims, the main
subject area where Brio reports are reported across
. Responsible for customer communication and onsite project management
. Performed project planning
. Prepared Report Specs to recreated IQ Objects to Brio
. Automated reports through Brio Scheduler
Client-Coke - June 2003-July 2003
As a Requirements Analyst, duties included:
. Involved in the Reporting Requirements study with Business Analyst
. Responsible for understanding the OSA data model
. Performed analysis and design of the ODS system
Client-Armstrong - February 2003-June 2003
As an OLAP Data Architect/Project Leader, duties included:
. Provided Administration for Cognos Server maintenance
. Monitored scheduled jobs through Maestro
. Provided support for Cognos DSS System with use of help desk system
called Remedy
. Involved in the Reporting Requirements study with a Business Analyst
. Developed and automated Transformer Cubes, Power play Reports,
Impromptu Reports
Client-GETS - August 2002-January 2003
As an OLAP Data Architect/Cognos Administrator/Project Leader, duties
included:
. Performed as Cognos Administrator for Cognos Server and Reports
Maintenance, IWR, Cognos Query
. Participated in the system study analysis, estimation and
implementation phases
. Designed and developed OLAP reports and generated Cubes
Client- Statefarm Insurance(USA) - May 2001-August 2002
As a Metrics Analyst, duties included:
. Responsible for gathering user requirements from Business Analyst,
Power Users
. Designed and created OLAP reports
. Published reports through IWR
. Provided support for Division Reporting Requirements
Client-Hewlett Packard(Singapore) - November 2000-April 2001
As an OLAP Architect, duties included:
. Created a Decision Support System for HP to distribute accessories
across different plants
. Developed ROLAP reports and MOLAP Cubes
. Assisted Power users and Business Analysts in providing analysis
reports to Regional Managers and business users with history and
current reorder, stock in hand
. Involved in System study and user requirement analysis
. Designed and created OLAP reports utilizing Brio Suite tools
. Generated Cubes using MS OLAP Analysis for each subject area
. Involved in ETL and Testing on Database
. Distributed cubes through LAN
. Web-enabled few reports, which are integrated in the intranet site of
HP
Client-Indian Overseas Bank(India) - September 2000-November 2000
As a Senior Software Engineer, duties included:
. Performed on a project, which helped to analyze branch profitability
and balance sheet analysis and offered facility to generate different
reports in multidimensional format
. Utilized data from different source systems such as Oracle, Flat File,
and Excel
. Utilized PL/SQL codes data, which was extracted and loaded
. Built cubes using Oracle Express and generated reports using Oracle
Express Objects
. Set up distributions of cubes to Regional Managers via LAN
. Involved in Report Requirement Study and System Study
. Designed and generated OLAP reports
. Provided training for the Power users on developing end user reports
Pentasoftech Technologies, Ltd - July 1999-July 2000
Client-3CRC Technologies Ltd(India) - March 2000-July 2000
As a Programmer, duties included:
. Involved in system study and user requirement analysis
. Involved in data modeling and database design
. Developed ROLAP Reports and integrated with MSOLAP cubes
SODAT Training Centre(India) - June 1997-June 1999
As a Programmer, duties included:
. Implemented a payroll maintenance system, which included all basic
payroll calculations for different categories of employees
. Involved in systems study and user requirement analysis
. Developed screen design, code and implemented applications
. Involved setting up test environments
Client-Pentafour Software and Exports Ltd. - May 1998-September 1998
As a System Designer/Programmer, duties included:
. Involved in Systems Study and user requirement analysis of Inventory
management system, which included modules for stock maintenance,
reorder level, branch-wise order status maintenances
. Developed screen design, coding and implementation
. Involved in setting up test environment
Contact this candidate