Project Data

Vaseem Khan

-Hyderabad, AP-Cell:****-**********-*************@*****.***

Business Analyst/Software Engineer

OBJECTIVE

To take a challenging role as a business analyst/ software projects

position in a company where I can give efficient and effective solution

that would help the organization, business and team-work skills to produce

effective business solution results.

Professional Summary

Business intelligence consultant with 3+ year of progressive experience in

the Business Information Management sphere. I have business and technical

skills in Relational Database, Data warehousing, ETL and Reporting in the

domain of lineal supply chain management, health care and financial

management. I have a track record in consulting, requirement analysis,

designing, developing, testing, integrating and implementing novel end-to-

end BI solutions, aligned with critical business requirements, under

stringent deadlines, for ace business corporations.

Professional Proficiency

. Multitudinous experience across all stages of software development

life cycle (SDLC) including business analysis, data mapping, unit

testing, system integration and user acceptance testing.

. Extensive work experience in ETL analysis, designing, developing,

testing and implementing ETL process in IBM Data stage Enterprise

Edition 7 and 8, Informatica 8, including performance tuning and ETL

process streamlining.

. Extensive work experience in reporting, report specification, report

layout, designing and development in Cognos 8 reporting studio.

. Substantial expertise in metadata modeling on Cognos Framework

manager.

. Strong SQL expertise in working with SQL queries, PL/SQL stored

procedures, Table Partitions, Packages, to load data into data

warehouse/Data Marts.

. Expertise in OLTP/OLAP System study, Analysis and Dimensional

Modeling, E-R modeling and Forward/ Reverse Engineering using Erwin.

. Distinguished proficiency at programming in SQL,PL/SQL, Unix shell

scripting, Teradata SQL,C,C++ and COBOL, including performance

tuning query/code optimization and streamlining.

. Experienced with mentoring Data Stage ETL teams, data modeling,

program code development, test plan development, datasets creation,

testing and result documentation, analyzing defects, bug fixing.

. Reputation for strong organizational skills, excellent communication

skills, dedicated team work, attention to details, ability to work

under pressure to balance competing priorities and meet deadlines.

. Extensive experience in providing critical integration and post

production support.

Technical Skills

ETL Tools : Ascential Data Stage 8.x, 7.5x2 (Designer,

Director, Manager,

Administrator),Parallel Extender,

Quality Stage, profile Stage

(information analyzer) and Server

Jobs, IBM Live Audit,

InformaticA Power Center

Reporting Tools : Cognos8, Cognos Reportnet and Business Objects.

Data Modeling : Erwin, Star-Schema Modeling, Snowflakes Modeling,

FACT &

Dimensions

RDBMS : Oracle 10g/9i/8i, MS Access, SQL Server 2000,

Teradata.

Languages : C, C++, SQL, PL /SQL

Operating Systems : Windows NT/2000/XP, UNIX, Red Hat Linux.

Scheduling tools : Autosys, Crontab Utility

Education & Certifications

> UNIVERSITY OF TRENTO, (Trento, Italy) - MS in Professional Masters

Degree in

E-Government Technologies, 2008.(72%).

> IT UNIVERSITY OF GOTHENBURG, (Gothenburg, Sweden) - MS in Software

Engineering and Management, (Majors in Applied Information Technology

specializing in Software Engineering and Management) 2007. (Grade:

Good).

> OSMANIA STATE UNIVERSITY (Hyderabad, India) - MCA in Computer

Applications,

2001. (72%).

> OSMANIA UNIVERSITY (Hyderabad, India) - Bachelor of Science in

Computer and Electronics 1998. (72%).

> OSMANIA UNIVERSITY (Hyderabad, India) - Intermediate 10+2, 1994.

(65%).

> SECONDARY STATE CERTIFICATE (Hyderabad, India) -10th class,

1992.(72%).

Professional Experience

Intern, Entity Centric Labs, University Of Trento(Trento, Italy)

Research Developer ( ETL )

21-01-2009 to 20-05-2009

Self-Administrative-life cycle Management for entities in the OKKAM FP7

European Project.

The Goal of the project is to Design, implementation and evaluation of

novel models and methods for managing the creation and evolution of

entities in an Entity Name System in the OKKAM project. Involved building

Data warehouse repository for managing entities of geonames. The objective

of the project was to build central repository of 7.5 million geonames

database. The data in the text files is imported in to the repository and

after applying business rules like finding alternative ids related to

Dbpedia database and updating the alternative information i.e. owlSameas

information into the geonames id, is than transferred to oracle database.

Clients interact with the system through the OKKAM Services layer. Clients

can be both human users and applications.

Environment: Windows 2000 Server, Oracle 8i, Informatica,Data stage,

Erwin, Cognos

RESPONSIBILITY

. Project Planning through Requirement Analysis Project Scheduling and

Monitoring Status at each phase. Reviewing Project Status by holding

Project Status Meetings. Documenting the Project Plan and Status

Reports at each phase.

. Interacting with the Middle Management, Branch Managers for

Requirement gathering, Reviewing Project Status, Suggestions for

version upgrades and Designing Report formats.

. Transferring of Source Files from flat files for Creation of the Data

Staging Area.

. Conversion of Flat Files running to about 10GB of data space into Data

Stage Area. Each field in the tables had to be identified with the

help of Cobol Library files.

. Filtering and Cleaning the Data Stage Area before final loading into

the Data warehouse like formatting the date fields for time dimension,

formatting decimal and currency fields.

. Identifying Dimensions and Fact Tables according to the Customers

requirement from the Data Stage Area and Forward Engineering Star

Schemas into the Data warehouse.

. Creating Repository and Transfer of the Conformed Dimensions and

Conformed Facts into the Data warehouse.

. Mapping the transfer of Files into the Data Stage Area and into the

Data Warehouse through different Transformations. Creating Sessions

for the mappings.

. Scheduling the Workflows and Worklets for transfer of data into the

repository. Monitoring the Transfer of Data and Error Correction for

the same.

. Creating Drill through, Cross-Tab reports through Cognos Catalogs from

the Data warehouse. Defining various macros for aggregating the

reports.

. Impromptu Administration for Designing and scheduling Ad Hoc Report

generation according to client's requirements.

SIS INFOTECH LTD ( Hyderabad, INDIA)

Web Associate

02-06-2003 to 31-12-2004

Strategic Industry Services (SIS) InfoTech Pvt. Ltd. is a business research

and analysis company, which provides research and strategy support services

to some of the world's leading research and consulting firms. With the

industry's largest and trusted collection of research reports, and

projects, SIS is well renowned for offering exemplar research, analysis,

content development, idea consolidation, and technology expertise to

develop learning programs on the web. The company has a distinctive

research pedigree and a long established track record in business

journalism, strategy and market intelligence. Provide business intelligence

on major industries ranging from banking, financial services, information

technology, consumer goods, aerospace to automobiles, and food & beverage.

SIS research programs are based on advanced techniques, and scalable,

robust research, and statistical tools that help accurately quantify, and

qualify changing market conditions. With over 18 years of established

research operations, SIS maintains a state-of-art research station in

Hyderabad (INDIA),

Providing specific genres of expertise, which supports the creation of

research reports.

RESPONSIBILITY

. Assists web editors with developing, coordinating, editing and

maintaining assigned content on organization or client websites.

. Communicates web standards and guidelines, content process, and

strategic direction of website to necessary staff.

. Ensures that content meets organization's or client's needs.

. Confirms project specifications and troubleshoots encountered problems

to ensure timely delivery of finished product.

. Monitors compliance with corporate guidelines. Reviews written

submissions for formatting, layout, design, and specification

requirements.

. Serves as back up for other web editors.

. Maintains familiarity with other web applications and new online

technologies.

. Provides advice and counsel on communications, web writing, copy

editing and technical matters

. Ensure that content on the web site is upto date and optimally

displayed.

. Make use of content management and reporting systems.

. Building the SQL queries for Oracle to fetch the data from the

database as per the business requirement and use the Sql Queries in

the Datastage for further processing.

. Other responsibilities as assigned by the web manager, web coordinator

and communication manager.

SQL STAR INTERNATIONAL (Hyderabad, INDIA)

Technical Executive

02-12-2002 to 31-01-2003

Supervising and coordinating technical department. Traning employees in the

troubleshooting of technical systems. Review report for planning and

strategies. Analysis of technical report prepared for presentations and

seminars.

RESPONSIBILITY

. Improved the quality of product by giving technical training to

employees.

. Introduced new technologies for effective working.

. Using business intelligence tools improved the quality of reports.

. Review reports for planning and coordination

AIMS SOLUTIONS ( HYDERABAD, INDIA)

Software Engineer

03-12-2001 to 02-12-2002

Saudi Telecom Company is the largest Telecommunication services provider

company in the Saudia Region. The 'Vendor Management' team at Saudi Telecom

company requires each vendor desiring to work with Saudi Telecom Company to

register and be pre-qualified before being short-listed for any activity.

This application has the following modules: Registration, Admin and

Document manager. These modules include many sub modules as Vendor

Registration, Pre-qualification of new vendors and classification of

vendors, Bank Guarantee, Criteria set, Criteria pool, Workload report,

Expression of interest.

The basic idea of this project is to provide an efficient system with

complete automation of vendor pre-qualification, selection, evaluation and

classification processes in an organization.

RESPONSIBILITY

. Involved directly to understand business requirements

. Develop technical design documents and implementation plan based on

business requirements.

. Pl/SQL Programming for writing SQL Queries using joins and applied

PL/SQL programming using, Stored Procedures and Triggers in Oracle.

. Created Tables as per the project requirement.

. Oracle 9i, Oracle plus,Toad was used for this project

. Unit test and debug large-scale complex development initiatives

. Support ongoing release cycle.

Academic Projects

Project Title: Comparative Analysis of Data Cleaning Models Which Involve

End User In Data Cleaning Process

Funded By : University of Trento, Italy

Client : Trentino Health care Department

This project involved building Data Warehouse for health care department,

Trento Italy The objective of the project was to have central repository of

health departments and to avoid the impact of bad data displayed at the end

user and how easily end user can be evolved to clean the data. Monthly

analysis reports were generated from the warehouse. The data in the text

format is transformed after applying some business rules is transformed

into oracle. During analysis if the user finds inadequate data using

interactive data cleaning tools he can update the information or delete the

information and save in the repository.

1. Branch Office consists of Flat Files (Fixed width) running on Novell

Netware 4.6 and a client on Windows 98.

2. Seven Branches were connected to Circle Office through Leased Lines.

. Project Planning through Requirement Analysis Project Scheduling and

Monitoring Status at each phase. Reviewing Project Status by holding

Project Status Meetings. Documenting the Project Plan and Status

Reports at each phase.

. Interacting with the Middle Management, Branch Managers for

Requirement gathering, Reviewing Project Status, Suggestions for

version upgrades and Designing Report formats

. Transferring source files to data staging Area.

. Filtering and cleaning the Data stage Area before finally loading into

the data warehouse like formatting the data fields for time dimension,

formatting decimal and currency fields.

. Interactive Data cleaning tools were used to clean the data

interactively by the end user using transformations.

. Data cleaning tools like Potter wheels an interactive data cleaning,

Intelliclean, Gmine, Lineage In Improving Data Cleaning Quality,

Uncertain Data Cleaning, Interactive Deduplication Using Active

Learning were scheduled on the warehouse to see which data cleaning

tool can be used more easily by the end user.

Environment: Windows98, SQL, Data stage, Potter wheels an interactive data

cleaning tool.

Project Title : Job offer ( Job offers with candidate's profiles )

Funded By : University Of Trento

Client : Lego Labs, Italy

Client Lego labs, Italy The project job bank were developed in order to

link the job offers based on candidate's profile. The scenario is having a

two clients,

. Firstly will be the worker- who used to create, manage and delete the

profile what he enters into the unemployed worker union. This

unemployed worker union is the place where we can find all the

profiles of the unemployed people.

. Secondly client will be company profile and this company profile will

be linked to job union, where you can find all types of jobs for the

suitable people. The company will publish new profile, update the

profile and delete the profile based on the requirements.

So here the scenario will be the worker is connected to worker union and

company is connected to job union. Now we have connector to connect with

worker union and job union, which is called as job broker. This job broker

will search for any new profile in the server. If any profile comes from

worker side, it will match the requirements of the worker with the profile

of the company, if the worker's profile matches with any company profile

then the job broker will send a mail to worker saying that you got a job.

Same way happens on the other hand, where if any new profile comes from

company side, it will check and send it to the company.

Environment :Windows-XP,RMI, SOA,ESB,Java,oracle10g

Project Title : Comparative Analysis of On-Line Analytical Processing Tools

Funded by : IT university of Gotenborg, Sweden

Client : Lidel,Germany

C Lidel, Germany is a leading chain of food and beverages supply shop

with more than 500 outlets all over Europe. The Data warehouse is developed

to analyze sales and financial data for both franchise and company owned

stores on a periodical basis. Data for analysis was received in flat files

and than converted to tables in Oracle database using Informatic tool. Flat

files sources were stored in Informatica repository, which was design as

staging area for transformation purpose. Depending on the dimensional data

model implemented on Oracle8i data were segregated, fine-tuned and

transformed using Informatica features like Filtration, Aggregation,

Joiner, Expression, Stored Procedure and Source Qualifier. Information was

provided to the clients using cognos reporting tools. Cognos repository was

created on oracle 8i database to hold reports and view. In order to analyze

and compare tools performance we have created Business object repository on

oracle database to test the performance factors in generating reports by

the end user for analytical purpose.

. Project Planning through Requirement Analysis Project Scheduling and

Monitoring Status at each phase. Reviewing Project Status by holding

Project Status Meetings. Documenting the Project Plan and Status Reports

at each phase.

. Extracted source definitions from various databases like oracle and

SQL Server into the Power Center repository.

. Developed Informatica mappings and change detection procedures and

also tuned mappings for improving performance. Created complex mapping

using Expression, Aggregate, Lookup, Sequence Generator, Update

Strategy, Stored Procedure and Router Transformations.

. Involved in logical/physical diagram of DW, in Erwin

. Created multiple Universes and resolved Loops by creating table

aliases and contexts.

. Designed Class, Dimension, Detail, and Measure Objects and organized

these objects in Universe designer with business logic.

. Created reports in cross tab, master detail format and transformed

them in 2-D, 3-D Column, Line, Area, and Pie charts for graphical

analysis.

. Created reports with conditions and organized data in regions using

slice and dice mode and created thin client reports with Ranking,

Sorting and Filter objects in Web Intelligence.

Environment :windows, Oracle,SQL server,Informatica, Cognos, BO

Key Qualifications

> Excellent interpersonal and communication skills, technically

competent and result-oriented with strong problem solving skills.

> Diverse background with fast learning skills and creative analytical

abilities.

> Profound in working with the team and alone also.

Personal Profile

Father : Ismail khan

Marital Status : Married

Nationality : Indian

Language Known : English, Telugu, Hindi, Swedish, Italian.

Hobbies : Chess, Football, Cricket.

Reference

Supervisor SAP technologies

Dott. Tullio Nicolussi

Divisione Sistemi Informativi

Via Briamasco, 2 - Palazzina D.I.T. - 38100 Trento, Italy.

Tel. +39 0461/881352, Fax +39 0461/881119

E-mail address: ******.*********@***.*****.**

Contact this candidate