Sales Project
Resume:
Title:Production Analyst
*******@*******.***
Document
Source below
NAME: muthian, krishnakumar
ADDRESS:
ADDRESS2:
CITY:
STATE: CA
ZIP:
CANDIDATE ID: 2238939
US CITIZENSHIP: Requires Sponsorship
EDUCATION: Bachelor Degree
EXPERIENCE: 8
WILL RELOCATE
: Yes -
JOB WANTED: Any
RATE NEEDED: $70,000
TELEPHONE: 818-***-****
EMAIL: *******@*******.***
HOMEPAGE:
HOTTEST SKILLS: Microstrategy Consultant
REVISION: 30-JUL-01
YOE: 8
Krishnakumar Muthian
(KK)
Email: *******@*******.***
Cell:
Home: 818-***-****
Over 3 years of experience in Data Warehousing design and development involving 5 full
project life cycle
Very Strong expertise in OLAP tools - Micro strategy DSS suite, Informatica, Data
Junction &
Erwin
Very Strong expertise in OLTP applications-SAP and Siebel
Good Understanding of Sap and Siebel architecture and got trained in Siebel
2000,Microstrategy 7.1.1 & Microstrategy CRM application suite
5 years of functional experience in manufacturing Industries.
Knowledge in Retail, Engineering, Banking and Apparel Industry
PROFESSIONAL EXPERIENCE
Micro strategy Inc., Vienna (Jan 2001 - Present)
As a Business Analyst and team lead understood the architecture of the both the CRM
system
and MSTR CRM application and designed database connectivity.
Role: Mapping of the MSTR CRM and Siebel tables based on the business rules. He developed
script and
Informatica mappings for the population of data from Siebel to MSTR CRM staging tables
and used
Informatica tool to populate data from MSTR CRM staging table to MSTR CRM ware housing
table.
Project Environment:
CRM Tool - Siebel 99 and Siebel 2000
OLAP - Microstrategy CRM 7
Database - Oracle, MSSQL, DB2
ETL Tool - Informatica
OS - Windows NT
Apparel Insights. Systech Solutions Inc, Los Angeles(Oct 2000-Dec 2000 3 months)
Involved in building the ready-made data warehousing product for the apparel industries
where he
played a major role designing the warehouse and building of the ready made reports in
MicroStrategy
DSS 6 and upgraded the same to MicroStrategy 7.
Role:
Understanding the business requirements and converting them to various forms of
reports.
Designing and developing the reports in MicroStrategy DSS suite-6/7.
Designing of Star & Snow flake Schemas Data model using Erwin
Upgrading MicroStrategy DSS 6 to MicroStrategy 7
Configuring MicroStrategy web to view and create the reports
Troubleshooting problems with application/Tools
Scheduling jobs to run reports
Project Environment:
OLAP - MicroStrategy 6/7
Database - MSSQL 7
OS - Windows NT
Designing Tool- Erwin
Warnaco Group, Inc. Connecticut (Jan 2000 - Sept 2000 9 months)
As a Team member interacts with various levels of users to gather their requirements and
involved in
various phases of building Sales & Inventory Data marts.
Role:
Understanding various business requirements and converting them to various forms of
reports.
Building data model using Snowflake Schemas architecture
Designing and developing the reports in MicroStrategy DSS suite-5.6 (MSTR Agent, MSTR
Architect)
Communicating with customers for requirement gathering
Planning, designing, scheduling and conducting DSS tests, and monitoring the results
Involving in various System integration process
Analyzing application for performance and functionality
Troubleshooting problems with application/Tools
Scheduling of Jobs to run reports
Performing accurate analysis and effective diagnosis of client issues and managing Day-
to-day
client relationship
Customizing of data delivery process
Project Environment:
OLAP Tool - Micro strategy 5.6 DSS Suite
OLTP - ACS (AS/400)
Database - DB2, SQL Server
OS - AS/400, Windows NT
Authentic Fitness Corporation Inc., LosAngeles (Nov 1999 Dec1999-2 months)
Implemented a retail data warehouse to enable complex reporting on Sales, Inventory and
Purchase
Orders for several Business entities.
Role:
Understanding the business requirements and converting them to various forms of
reports.
Building data model using Snowflake Schemas architecture.
Designing and developing the reports in MicroStrategy DSS suite-6.
Automation of reports using Microstrategy Broadcastor.
Communicating with customers for requirement gathering.
Planning, designing, scheduling and conducting DSS tests, and monitoring test results
Analyzing application for performance and functionality
Troubleshooting problems with application/Tools
Scheduling jobs to run reports
Project Environment:
OLAP Tool - Micro strategy 6 DSS Suite
OLTP - ACS (AS/400)
Database - SQL Server
OS - Windows NT
Data warehouse project, OBSI, Chennai ( June 1999 - Oct 1999 5 months )
Along with a team of 4 consultants built a proto type sales data mart on the SAP
transactional system
for
the analysis of various sales datas using MicroStrategy as the data-warehousing tool.
Role:
Designed and built the MicroStrategy warehouse database based on the reporting
requirement
Mapped the SAP tables with that of the MicroStrategy warehouse tables
Extracted and Populated data using SQL Scripts.
Developed daily load Programs and procedures to build aggregates.
Configured and generated Data warehouse reports using MicroStrategy tool.
Project Environment:
OLAP Tool - Micro strategy 5
OLTP - SAP
Database - Oracle
OS - Windows NT
Spencers & Co Retail Chain, Chennai (Jan 1999 - May 1999 5 months)
Along with a team of 4 consultants built a Point-of-sales data mart.
Role: Extracted and Populated data using SQL. Developed daily load Programs and
procedures to build
aggregates. Generated Transactional reports using SQL. Maintained metadata.
Project Environment:
OLAP Tool - Micro strategy 5
OLTP - MS Access
Database - SQL Server
OS - Windows NT
TAFE Access Ltd, Chennai
(Nov 1997 - Dec 1998 )
Along with a 2-member team built a quality monitoring system to monitor the rejection
level using
statistical analysis and to generate various reports to meet the quality requirement of
the customer
oracle as backend and Visual Basic as front end.
Role:
Studied the functional requirement.
Designed and built the database in Oracle.
Designed the screen layout in Visual Basic
Tulya Alloys Ltd, Coimbatore
(May 1993Oct 1998)
Was instrumental in Implemented QS 9000 system in line with QS 9000 system requirement to
improve
the quality standard of the company thus decreasing the rate of rejection and increasing
the
productivity.
Role:
Documented the QS 9000 procedures.
Documented the work instructions.
WORKSHOPS
Microstrategy 7.0 conducted by Microstrategy Los Angles.
Microstrategy CRM 7 conducted by Microstrategy Los Angles.
Siebel
2000 In house training at Systech Solution Inc, Glendale
EMPLOYMENT
Company Title Period
Systech Solutions Inc
., CA Senior Consultant From Nov 99 to Till- date
OBSI, Chennai. India Data warehousing Consultant From Jan99 to Oct 99
TAFE Access Ltd
., Chennai. India Business Analyst From Nov 97 to Dec 98
Tulya Alloys Ltd, Coimbatore, India Business Analyst From May 93 to Oct 97
SKILLS SET
Area Skills
OLAP tools Micro strategy DSS Suite, Informatica, Erwin, Data Junction
Database DB2, SQL Server, Oracle, MS Access
Programming SQL, PL/SQL, ABAP
Transactional applications Siebel 2000, SAP
Operating System Windows - ME, NT, 2000 & Unix
Project management MS Projects
EDUCATION
Bachelor of Engineering,
MK University, India.1993
Contact this candidate