Customer Service Developer

Title:Customer Service Representative

******.*******@******.***

Document

Source below

NAME: Rafique Nighat

ADDRESS: 103A, 277 Fairfield Road

CITY: Fairfield

STATE/PROVINCE: NJ

ZIP/POSTAL CODE: 07004

COUNTRY: USA

EMAIL: ******.*******@******.***

PHONE: 973-***-****

CANDIDATE ID: 118798

CITIZENSHIP: US

Citizen

EDUCATION: Bachelor Degree

EXPERIENCE: 5

WILL RELOCATE: Yes

RELOCATION INFO:

JOB WANTED: Any

RATE NEEDED: Open

HOMEPAGE:

COMMENTS:

HOTSKILLS: Business Objects =5+ yrs, Sql*Plus =5+ yrs, PL/SQL =5+ yrs, Oracle 8.0.5

=5+ yrs, Sybase =5+ yrs, Web Intelligence 2.6 =5+ yrs, HTML =5+ yrs, Visual Basic =5+

yrs

ESUME

Nighat Rafique

Internet: ************@*******.***

Ph: 973-***-****

Work: ******.*******@***.***

PROFILE:

Five years IT Experience with More than 2 years of experience in creating client/server

applications using tools like Oracle7.3, SqlServer7.0, Microsoft Access97, Developer

2000(Oracle Forms 4.5, Oracle Report write 2.5) and Visual Basic 5.0.

Nearly three years of experience in creating Corporate Report Solutions using Business

Objects 4.1/5.0/5.1.2 and

Web Intelligence 2.6.

Experience in handling all the Modules in Business Objects like Supervisor, Designer,

User, Broad Cast Agent and Web Intelligence. Expertise in working with Different RDBS like

Sybase, Oracle, SQL Server and MS Access.

Experience in Creating Database Stored Procedures, Functions and performance tuning. Very

Strong experience

In creating Meta Data Layers(Universes) using Business Objects.

Excellent Analytical, problem solving and oral and written communication skills,

willing to work in both independent and team environment.

COMPUTER SKILLS:

LANGUAGES : C,SQL,SQL*PLUS, PL/SQL

RDBMS : ORACLE 8.0.5, SYBASE 10.5, SQLSERVER 7.0, MS ACCESS 95/97.

GUI : DEVELOPER 2000, VISUAL BASIC 5.0.

REPORTING TOOLS : BUSINESS OBJECTS 4.1/5.0/5.1, WEB INTELLIGENCE 2.6

WEB : HTML, CGI SCRIPTS, JAVA SCRIPT, JAVA APPLETS

OS : MS DOS, Windows 3.1/ 95/NT, VAX/VMS, Apple Macintosh

APPLICATION S/W : MS FRONT PAGE, FRONT PAGE 98

WORK EXPERIENCE:

Phillips Van Huessen, Bridgewater NJ (Mar 00 present)

Business Objects Consultant

Encountered extensive interaction with database teams to identify the source of data and

populate the data in Universes. Used Oracle functions, views etc. for Business Objects

reporting purposes in-order to represent data as per business partner's demands. Created

Universes for Shipment Tracking and Shipping reports with comparative data. Customized the

Universes for creation of canned reports. Designed, developed and tested (QA) reports.

After receiving the specifications, had to work very closely with the users to design the

required reports.

Responsibilities

Data Modeling and developed the reporting database in Oracle.

Gather the requirements from users and handling change requests and pilot

implementations.

Built Universes according to the requirements

Working with the Old reports and constantly working with the end users as per their

needs for new reports

Send the Documents to BCA, and Schedule the reports to refresh on a monthly or weekly

basis

Publish the reports to WEB Intelligence 2.6 and maintain them

Train the end users in working with WEB Intelligence and trouble-shoot any issues

related to Business Objects

Documenting the entire Universe and Report information.

Wrote Custom VBA Marco for Saving the Full client reports in XL and customizing the

reports as per the

User requests.

Environment: Business Objects 5.1, Web Intelligence 2.6, SDK, Oracle 8.0, AS400, Win NT.

NY

Times, NY (Oct 00Mar 00)

Business Objects Consultant

.

This project is for the marketing department at NY Times where the primary task is to

create reports. The project focuses on analyzing the data, designing the universe in

Business Objects 5.1, building reports in the User Module. Reports included analyzing and

producing results of Retention at NY Times. Worked in Oracle 8.0 (SQL) for testing

purposes.

Responsibilities

Installed the BO Server and on individual systems (Win 95, Win 98, Win NT)

Designed the Universe in Designer module of Business Objects 5.1. Edited Joins,

cardinalities, resolved the loops using aliases and contexts.

Exported the universe to the repository and scheduled time consuming jobs on the

Document Agent Server to run over the weekend.

Training the users in the User Module in Business Objects 5.1

Created reports and graphs for the Retention Curve to produce the net profit or gain

for the marketing department.

Environment: Business Objects 5.1, Oracle 8.0, Win NT.

CNA

Insurance, NJ

SQL Programmer

(Mar 00Oct 00)

This project was designed for the marketing group at CNA and the purpose of it was to

build tables with different customers identified by distinct codes. Business objects was

used for testing purposes. Involved building new and modifying old campaigns using

extensive SQL

Responsibilities

Identifying the groups that the different customers fell into using the appropriate

conditions and requirements

Writing automated scripts that would pick distinct producers and identify them into

various groups thus creating the main marketing table

Writing insert and update queries which will add new customers to the marketing table

and expire the old ones automatically every week

Producing various reports as per the requests of the other departments.

Environment: Business Objects 5.0, Sybase 10.0, Win 98.

Concord Industries, NY (Feb 99Feb 00)

Business Objects, Web Design and Database Developer

This is a Intranet based Inventory Control Project which deals with pulling up the data

and reports from the internet for the web users. Involved in creating Inventory database

for Concord Industries using SqlServer 7.0, Designing web pages using HTML and Front page.

Also extensively involved in creating Universes and Reports using Business Objects 4.1.

Responsibilities as a Database Developer

Designing the Database Tables with keys .

Normalized the tables.

Modified the Flat files and XL Spread Sheet data by eliminating data type errors and

duplicate records.

Uploading Flat files and XL Spread sheet data into database Tables by using ODBC and

BCP (Bulk Copy Program).

Create the devices on which the database rests and set size and location of those

devices.

Responsibilities as a Web Designer

Created web pages to let the user to work with the Inventory database.

Queries were written in the IDC files and displayed using htx output method.

Responsibilities as a Business Objects Developer

Based on the Business Requirements, created the Universe created and Edited the Joins.

Resolving loops through Aliases and Contexts.

Complex User Dimensions and Measure objects were created using the Case Statements and

@ functions using

Sql Server

.

Performed the Integrity Check of the Universe and exported to the repository.

Report Template was created with the necessary Logo, Date and Project Description.

Critical reports were created using Sub Queries, Combined Operators.

All the Reports are formatted with business objects functionalities like Slice and

Dice, drill down, user responses, prompts, applying breaks and sorting.

Reports were sent out to the Users for testing as well as to get the user acceptance.

One of the main issues with this project is the Performance of the Reports. As it deals

with very huge amount of databases, tuning the SQL is required. All the report SQL has

been tuned to the maximum extent.

Document Agent Server has been used extensively because of the time constraint. All the

production report were kicked to the Doc Agent Server to run these reports in the batch

mode, without stopping the development work.

These reports are published on the intranet for all the Business Users with the help of

WEB INTELLIGENCE

Environment: Business Objects 4.1.2, Erwin, Sql Server 7.0, IIS 4.0, HTML, Front Page,

Win NT.

STAR

(Shubbert Technologies, NJ) Sep 98Jan 99Programmer Analyst

Description:

STAR

(Shubbert Accounting & Reporting System) was developed to maintain and track the

accounting information of Shubbert technologies. This system was developed in Visual Basic

5.0 and Oracle as back end. Used Business Objects for reporting.

Responsibilities

Involved in Designing and Developing of complete reporting application.

Design and development of Reporting System using Business Objects 4.0.

Created Universes for report generation using Designer module in Business Objects. As a

part of Universe development, created Classes, different kind of objects, cardinalities,

Strategies. Resolved the loops using Aliases and contexts. Check the Integrity of the

Universes. Export the Universes to Repository for making available to users.

Created Adhoc Reports using User module in Business Objects. As a part of report

development created the reports using universes as a main data providers and using the

Powerful business objects functionalitys like @ functions, user response and formulaes.

Created different types of reports like Master/Detail, Cross Tab and Chart. Used Analyzer

and Explorer to view reports from different prospect. For this used Slice and Dice and

Drill down. Export the documents to Repository.

Scheduled and monitored the reports using Doc Agent Server.

Trained the users, in using the System and writing the simple SQL Queries.

Environment: Oracle 7.3, Business Objects 4.0

Eaton Corporation

(Apr98Aug 98)

Design and development of labor and overhead system for Eaton Corporation. This

application kept track of the actual and overtime labor hours; performed productivity

analysis by calculating the actual cost per piece considering all the overhead

expenditures

Responsibilities:

Performed system analysis, gathered information and studied their current system

Perform analysis of data gathered to create tables and constraints.

Wrote various types of queries using Access query builder.

Developed user interface using Visual Basic

Used loops, procedures, functions, arrays and property classes.

Environment: Windows 95, Visual Basic5.0, MS Access 95.

NetLink Corporation

(Jul 97- Mar 98)

Designed and developed a client/server application for the customer database for NetLink

Corporation. This application kept track of all the information about the customers, bills

owed, etc. The user interface was developed in Developer 2000 and the database was

developed using Oracle.

The system maintained data on account history and enabled data management of transactions

performed. This system had the capability to manipulate data using queries and generated

reports as required.

Responsibilities:

Creation of tables, constraints and Entity Relationship Diagrams.

Normalization of tables and creation or relationship between them

Used Oracle Forms to create user-friendly screens for data entry and wrote Triggers to

switch between menu options and also to generate queries.

Created reports for the transaction details.

Designed and developed various interfaces as per user requirements using Forms 4.5.

Debugged the application for errors to get desired output.

Training, documenting and communication with end-users.

Environment: Oracle 7.2, SQL*PLUS, Oracle Form 4.5, Oracle Reports 2.5, Windows 95

Intern

in Universal Group of Companies, Dubai, UAE (Dec 96May 97

)

Programmer/Analyst

Worked with a team of developers for the development of the Payroll system of a financial

institution. The application keeps track of employees information, their regular and

overtime hours and generates various reports.

Responsibilities:

Performed system analysis, gathering information and writing SQL scripts to create

tables and constraints.

Wrote functions, procedures, queries, class modules and property classes to validate

data and enhance functionality.

Created various screens using Visual Basic.

Designed and developed reports to reflect daily and weekly activities.

Responsible for communicating with end-users and documentation.

Environment: Windows95, ORACLE, Visual Basic5.0

EDUCATION:

Bachelor of Business Administration

Major: Computer Information Systems

Advanced courses: HTML 4.0, VISUAL BASIC, System Analysis and Design, Business

Applications of Database, TCP/IP, Cum

GPA:

3.0

Contact this candidate