Data warehouse analyst

Data warehouse analyst


[ Malaysia Online Resume Listing ] [ FAQ ]

Posted by on November 19, 19102 at 18:39:19:


MD ISHAQ

E-mail: - qslishaq@rediffmail.com
♦Mobile: +919849236875
Res:040 6611186


A successful IT Professional having 3 years of experience in Business Intelligence (Cognos, Business Objects)/Decision Support Systems, analysis. Having Hands of experience of working on Cognos Decision Stream for creation of the Data Marts, design and development of client / server, Intranet and Internet Applications and Component Development.

EXECUTIVE PROFILE


 Strong designing, Programming, troubleshooting and problem solving skills.
 Able to work with and maintain relations with staff and clients on all levels.
 Ability to apply past expertise in design and development.
 Quick learner that expends extensive efforts to stay informed of new technologies.
 Able to work in independently or as part of a team.


EDUCATION, TRAINING & CERTIFICATIONS

Sri Venkateswara University,Tirupati, Andhra Pradesh, India.
Bachelor of Technology (CSE), 1999, 68%

S.K.J.S.C, Vijayawada, Andhara pradesh, India.
Intermediate , 1995, 88%

Kendriya Vidyalaya Sanghatan, (CBSE)
10th class, 1993,65%

Corporate Training on Cognos in Quantum Softech ltd.
Corporate Training on Oracle 8i in Quantum Softech ltd.


EMPLOYMENT HISTORY


Quantum Softech Limited, Hyderabad, Andhra Pradesh, India. Aug’99 -Present
SOFTWARE ENGINEER


TECHNICAL SKILLS


B.I Tools: Cognos Power Play enterprise Server 6.6,Power Play Client 6.6,Transformer Server 6.6,Cognos Visualizer 1.5,Impromptu Administration 6.0,Impromptu Web Reports 6.0,Business Objects 5.1 (Supervisor, Designer, Business Objects)
Data Warehousing/ETL Tools: Cognos Decision stream 6.5.
Operating Systems: MS-DOS, WINDOWS 95/NT/98/2000.
Languages: JAVA 2.0, C, C++, SQL, PL/SQL and Visual Basic6.0
RDBMS: Oracle 8i, MS-ACCESS.
Web Development Tools: Visual Interdev, MS-FrontPage 2000.
Markup Languages: HTML, DHTML, XML and WML.
Script Languages: JavaScript, VBScript, Jscript and WMLScript.
Server Side Programming: ASP, Servlets and JSP, J2EE.
Others: Object Oriented Analysis and Design, Unified Modeling
Language.


PROJECT SUMMARY

Project Name Team Size Organization
Business Intelligence Solution 8 Quantum Softech Limited, India
Inventory Analysis 8 Quantum Softech Limited, India
EASE 8 Quantum Softech Limited, India
www.cliks2india.com 5 Quantum Softech Limited, India


PROFESSIONAL EXPERIENCE


Quantum Softech Limited, Hyderabad, India Business Intelligence Solution
Project Name Business Intelligence Solution
Client Johnson & Johnson NJ
Organization Quantum Softech Ltd.
Period June 2001 – Till date
Description Working as Cognos consultant for Johnson & Johnson Inc, which is one of the MNC's that sells various numbers of products. It has various stores The Database has lots of historical data. So data warehouse plays a major role in enabling various stores to view the data at a lowest level and help them to make decisions to bring more revenue to company with new policies.
Role  The reporting tool used was Cognos. The reports were classified into simple report, analysis report.
 Used Cognos Impromptu tool to make a catalog file, tables, joins, folders and profiles and developed the reports by retrieving the data from .cat file to make list or cross-tab report.
 Slice and Dice Operations done for all OLAP applications.
 Pivoting, Drill Up/Down operations done for all OLAP applications.
 Used Impromptu to make .iqd file, which is used in Cognos Transformer to make a Power Cube.
 Arranged dimensions and measures in cube as per requirement.
 Used Cognos Power Play to analyze, display and present the Cube data in different types of charts.
 Scheduling Powerplay, Impromptu reports using Cognos Scheduler.
 Used filters to get required reports through main reports. Drill through reports to make sub-reports.


Quantum Softech Limited, Hyderabad, India Inventory Analysis
Project Name Business Intelligence Solution
Client Tata Memorial Hospital
Organization Quantum Softech Ltd.
Period Dec 2000 – May 2001
Description The Project involved building of data warehouse. This involved extraction of Data from various data sources such as Flat File, Oracle, SQL Server, AS/400,Foxpro.The project involved extensive cleansing of dirty data, data migration, data transformation and loading of data.
Software/Tools used are Decision Stream (Cognos) for building data warehouse involving activities such as data extraction, cleansing, transformation and loading.
Role Involved in Data Modeling.
Designing Star/Snow flake schemas
Extraction, Transformation and Loading the data into warehouses.
Also involved in System Integration tasks such as installing and configuring the software.
Creating subject oriented data marts.


Quantum Softech Limited, Hyderabad, India EASE
Member Technical Staff
Module Name EASE
Duration 8 Months
Client Quantum Softech Ltd.
Organization Quantum Softech Ltd.
Description EASE (Engineered Application for Small and medium Enterprises) - an ERP solution which is user configurable system with functional stability and high levels of program and Data Integrity critical to Small and Medium Enterprises targeting Indian SME market. EASE system comprises of Payroll, Invoice, Inventory and Accounting Modules. The models for this project are web based ones supporting both Internet and Intranet technologies over a proposed three-tier architecture having its presentation layer in HTML 4.01. Microsoft's
ASP to communicate with the components in the middle-tier implementing the business logic on MTS, which in turn interacts with the Database tier being implemented in Oracle8i.
Role  Active role doing design-using UML.
 Designing the database and GUI screens.
 Co-ordination with team members in overall development
 Involved in writing code in ASP and Component development.
Environment IIS 4.0 web server, MTS for component deployment (on windows NT 4.0 server) and client Pentium nodes connected to server using Visual Interdev. Visual Basic 6.0 for component development.
Architecture 3-Tier architecture
Database Oracle 8i R2 V8.1.6
Languages PL/SQL, HTML, JavaScript, VBScript (ASP)
Front End Visual InterDev 6.0, Visual Basic 6.0
Tools Visio Professional
Methodology Component Oriented

Quantum Softech Limited, Hyderabad, India

Cliks2india.com
Member Technical Staff
Project Name Cash2India, Matrimonial
Duration 3 Months
Client BuyIndiaonline.com Inc, Boston, US
Organization Quantum Softech Ltd.
Description Cash2India – This module enables a registered user to send money from US to India. A registered user can enter into this module and perform single and multiple transactions. A user has an option to specify the amount in US dollars for which he/she is charged for the service rendered. He/she can also get addresses from Address Book module, which is merged with this module. Other features include: -
 Viewing transaction history, changing credit card and deleting transactions.
 Customer support, which provides a detail report for administrator about each individual transaction.

Matrimonial – This module enables a registered user to enter his/her profile according to his/her needs and requirements for getting married. A user can later modify, delete or view his/her profile. After entering the profile, he/she can find the required match depending on their criteria. An option of entering multiple profiles is also available. Other features include: -
 Adding his/her photograph.
 Entering personal, family and Professional details.
 A user can add multiple profiles.
 Search by criteria (ex: - profiles with photographs etc.,)
Role  Active role in doing system design.
 Co-ordination with team members in overall development
 Coding in ASP and front end scripts.
Environment IIS 4.0 web server on windows NT 4.0 server and client Pentium nodes connected to server using Visual Interdev.
Architecture 2-Tier architecture
Database Oracle8i
Languages ASP using VBScript, JavaScript, HTML.
Front End Visual InterDev 6.0
Tools Visio professional 5.0
Methodology Company Design and Development methodologies.

PERSONAL PROFILE

Date of Birth: 7th SEP, 1978.
Marital Status: Single.
Fathers Name: Md Nuha.
Passport No: A 5551238.
Place of Issue: Hyderabad.
Date of Issue: 10-06-1998.
Valid Until: 09-06-2008.
Languages Known: English and Hindi.



[ Malaysia Online Resume Listing ] [ FAQ ]