Project Sql Server

PROFILE

Anil Kumar

Contact-No: 009**-*******

E-mail: kumaranil_jtr @yahoo.co.in., ******@***.***

Strengths As a motivated team player with interpersonal

skills, hard working & ability to work under

adverse situations as well as ready to endure

dynamic & challenging assignments.

Objective To participate in my employer's growth with a

technically as well as functional enriching

experiences.

Technical Exposure Profile

OPERATING SYSTEMS : Win 98/2000 /XP and Unix

Project Server : Project Server 2003 /

2007 / 2010.

Reporting Tool : Sql server 2000 / 2005

Reporting

Services, Crystal Reports XI.

Database : Sql Server 2000 / 2005

, Oracle

9i/10g

Technologies : Vb.net(1.1,

2.0),Asp.net(1.1,2.0),

Java, xml.

Analysis Tools : ACL(Data Analyzing

tool),Crystal Reports

Education Profile

Bachelor of Technology in Computer Science

Engineering from Narayana Engineering college

affiliated by jntu University, India 2005.

Certification

Oracle Certified Association (OCA) in SQL,

Pl/Sql and Pl/Sql Expert certificate from IBS

Kuwait.

WORK EXPERIENCE:

An IT Consultant with nearly 5+ years of hard core experience in Microsoft

Donet Technologies (1.0, 2.0, and 3.5) Microsoft EPM 2003/2007 /2010,Sql

Server 2000/2005, Sql, and Pl/Sql.

Period Organization Role Location

Oct 2010 to Till Agility Logistics EPM Consultant Kuwait

data

Jul 07 to OCT Commercial Bank of EPM Consultant Kuwait

2010 Kuwait

May-07 to Jul 08 ABX Express Sdn Bhd WEB Developer Malaysia

Jul-05 to Mar-07 Jb Software Programmer India

Solutions

Project Summary

Project #1

Title : Enterprise Project Management(EPM)

Role : Microsoft EPM Consultant

Client : Agility Logistics.

Software : Microsoft Project Server 2007, Share Point 3.0,

Project Professional.

Database : Sql Server 2000/2005.

Reporting Tools : Sql Reporting Services, Crystal Reports XI

Duration : Oct 2010 to Till Date

Description: Agility is one of the world's leading providers of integrated

logistics with more than 25,000 employees in over 550 offices and 100

countries.

Project Description: Agility Logistics is implementing EPM for tracking

there Project Schedules, Resource Time Sheets and Resource Time Allocations

for Various projects.

.

Role: The Role is to create and implement Microsoft EPM for Project

schedules by consulting Head of Management from various departments and

Assigning Resources to the projects and Publishing the projects into

project server.

Installed and Implemented Microsoft EPM with project server 2007,

SharePoint services 3.0, Sqlserver 2005.

Creating Basic Setups, Developing Reports in Sql reporting Services based

on End user requirements on project wise and Resource wise data from

project server database. Creating Resources, Time sheet managers, project

Managers based on the information provided by Managements. Creating

Packages, Procedures from Project server data base for Reporting.

Tracking the projects and sending the monthly Project reports to the

departments and tracking Resources time sheets.

Trouble shooting project schedules if there are issues in opening projects

from project server. Tracking Resources Timesheets and allocating resources

to specified projects and troubleshooting issues if the team members unable

to login to Project web access.

Responsibilities:

. Installing and implementing Microsoft EPM with Project Server, Sql Server

2005, Share point Services, Reporting Services, and Analysis Services.

. Developing Project wise reports and resource wise reports according to

end user requirements.

. Creating various reports from project server 4 database using SRSS and

publishing in Project Web Access.

. Developing Packages and Procedures for Reporting purposes in SQL server

and Oracle databases.

. Performing UAT Testing along with end users and training end users in

using Project Web Access.

Project #2

Title : Microsoft EPM Project

Role : Microsoft EPM Consultant and ACL Tool

administrator.

Client : Commercial Bank of Kuwait.

Software : Microsoft Project Server 2007, Share Point 3.0,

Project Professional.

Database : Sql Server 2000/2005.

Reporting Tools : Sql Reporting Services, Crystal Reports XI

Duration : JUL-2007 to OCT 2010

Description: Commercial Bank of Kuwait operates the second largest domestic

bank in Kuwait, network comprising of 52 branches.

Project Description: Commercial Bank of Kuwait Implemented EPM for Projects

Schedule Tracking, Resource Time Sheets (Staff), HR Appraisals, Time

tracking for various projects and for billing purposes.

Role: The Role is to create and implement Project schedules by consulting

Head of Management from various departments and Assigning Resources to the

projects and Publishing the projects into project server.

Tracking the projects and sending the monthly Project

reports to the departments and tracking Resources time sheets. Trouble

shooting project schedules if there are issues in opening projects from

project server.

Tracking Resources Timesheets and allocating resources to

specified projects and troubleshooting issues if the team members unable to

login to Project web access.

Creating various reports from project server 4 database using SRSS and

publishing in Project Web Access. Creating Packages, Procedures from

Project server data base for Reporting.

Data Analysis Reports (ACL Reporting Tool): ACL is Data Analyzing Software

tool used for extracting data from different Database Sources and producing

the Data analyzing reports by using the scripting language and Sql queries

provided by the tool.

Job Role: The Role is to provide the Fraud Exceptional reports, Statistical

Reports for Financial Auditors and IT Auditors thru ACL tool. The reports

are generated from the information provided by the auditors for different

domains in the bank like Retail Management, Fund Management, Loans, and

Cards Management and Corporate Credit etc.

The Fraud Exceptional reports are generated by getting the data from

different sources like Mainframes, Oracle, Sql server, and Delimited Text

files etc .After information is acquired from different source the

Exception reports are designed by writing the ACL scripts and integrating

the ACL with Crystal Reports and producing the Exception Reports.

Continuous Monitoring: The Continuous Monitoring reports are generated by

using ACL by Scheduling Reports Daily, Weekly, Monthly for all the Branches

in the Bank.

The Role is to design Complete Architecture of Reports for automating

generation of reports by scheduling the ACL Scripts with specific

conditions in generating the Reports by integrating with Crystal Reports.

Responsibilities:

. Installing and implementing Microsoft EPM with Project Server, Sql Server

2005, Share point Services, Reporting Services, and Analysis Services.

. Developing Project wise reports and resource wise reports according to

end user requirements.

. Developing Packages and Procedures for Reporting purposes in SQL server

and Oracle databases.

. Performing UAT Testing along with end users and training end users in

using Project Web Access.

. Generating ACL reports and creating ACL Scripts and installing in server

and maintaining ACL on the network server and providing access to scripts

for auditors to access from different locations.

Project#2

Title : Smart Tracking System

Role : Application Developer

Platform : C# Asp.net 2.0, Dream weaver, Ajax, Smart devices

(MC70 CDMA-EVDO)

Reports : Crystal Reports XI

Database : Oracle 9i

Client : ABX Express Sdn Bhd

Malaysia(www.abxexpress.com.my)

Duration : May-06 to Jun 07

Description:

About Abx Express:

ABX is a Courier Services that provides door-to-door express delivery of

documents and packages by using computerized system developed in Microsoft

Dot net Technologies..

Our state-of-the-art computer tracking system can reveal the precise status

of your packages from pick-up point to final destination.

ABX's express service is the most cost-effective convenient way to swiftly

and safely dispatch your important business correspondence and package

within Malaysia and the World.

Project Description: The Main motive of the Smart Tracking system is to

track the Shipment details, Pickup schedules, and Tracking Air bill numbers

based upon the user login details, to their desired Destination.

The Smart Tracking System Consist of various modules, which are, discusses

below separately.

1. Operation Module: This Module Provides the Organization Staff (Call

centre Department) to enter the Shipment details of the Clients by

receive the calls from the Customers regarding their Shipment details

uses this module. All the necessary information provided by the

customer is keen into the forms and saved to database based on the

time and date factors.

2. Manifest Module: This module is to track the Air bill numbers based

upon the User details, station codes etc. This modules Enables the air

bill numbers for shipment processing. The Form Enables the staffs to

keen the air bill numbers and process the tracking process based on

the user login details, station codes, date etc.

The office staff of the Abx Express to Process Shipment uses this

module. In this module the shipment details are tracked based on the

air bill numbers enters into the forms.

3. Demanifest modules: The Demanifest module is final step for the pick

up schedules of the air bill numbers. After demanifesting the Air bill

numbers, all the necessary information is send to the Shipment module.

4. Shipment Module: The Air bill Numbers that are tracked based on the

information details that are received in this module based on the time

and data factors. And the air bill numbers are sending to pickups.

5. Update Status module: The Air bill numbers that doesn't undergo the

shipment process due to specific reasons are update in this module by

entering that air bill numbers into the forms and updating the reasons

for not underground the shipment processing.

6. Data Transferring: This module is used for transferring the shipment

data from one station to another station. The data that users have to

transfer can enter the destination station address and by clicking the

form the data can be transferred from one station to another station.

7. Mail module: This Mailing module is used for the company intranet for

sending and receiving the mails by the users regarding pickup dates,

pod updates shipment details etc.

Responsibilities:

. Database Design & Development

. Designing and coding dot net web forms.

. Developing Packages, Procedures, functions and stored procedures.

. Designing Reports based on the users request by using crystal reporting

tool.

. Developed data base Packages, Procedures, and functions for the above

specified modules.

Project#3

Title : Transport System

Platform : VB Dot net (1.1) And Java Script

Client : Balaji Transport system

Environments :Development and Customization of Forms and Reports

Duration : Jul 05 to Apr06

Description:

This Project describes about import and exports of goods of overseas the

company have four types of transportation of goods from one country to

another country and its maintain all the custom costs and rates of each

every transport goods This project is developed for all duties (Import and

Export) details and every mode of transportation on goods and maintain the

Invoice for each import or export according to client or agent wise and.

Each import and export having own invoices number and it according to

custom clarify number and custom identification of transaction we are

maintain all the values to using COM and DLL, each having its own

functionalities.

Import

This module maintain all the imports goods Details and import invoices

According to exporter's country's and Custom duties of different items via

items and measurements wise and It maintain the Transport mode also like

Road, Sea, Air The value will generate automatic invoice depending on

transport mode and imports goods type.

Export

This module maintain all exports details depending upon

export goods and destination stations according to importer or client or

agent wise and it maintain all types of imports duties (value to custom)

and mode of transportation and it generate automatic quotation for each

export

Billing

This module generate all billing and invoice for exports and

imports and maintain custom relation management and ports identifications

and port details also.

Responsibilities:

. Database Design & Development

. Analysis of Dependencies and Design the flow of System

. Designing and generating reports.

Academic Project:

Title : Online Customer care and Support

Platform : Dot net Technologies 1.1, Java

Organization : Narayana Engineering College

Description:

The Customer Care and Support Services is an online form for the clients

who do online marketing for the products that are of Electronic classes

such as Computers, Electronics, and Hardware's etc. The main theme of the

project is that we give online support for the complaints give by the

customers of the corporation a 100% satisfaction and very quick services.

The Primer Global is a Distribution company dealing in Electronic parts and

represents more than 100 different principal organizations in India. A

range of products is targeted at specific industry segments and some of

these products are re-purchased at regular intervals. Along with the

strengthening of its Account Management and Marketing function, The CEO

realized that one of the most important factors that will ensure long term

loyalty and patronage of client organization would be MNC-GLOBAL solutions

level of customer support. Every time a customer calls into login a problem

with respect to one of the products that they purchased from MNC-GLOBAL

solutions, there is a opportunity to retain that customers for ever by

providing fast responsive and effective customer support.

Roles & Responsibilities

. Play a key role in Developing Database structures.

. Designing forms and reports for online modules.

. Developing packages, procedures and functions

Reference:

NAME N. Prasad

Role Oracle Application DBA

Company Commercial Bank of Kuwait

Email *******@***.***

Personal Details:

NAME J.Anil Kumar

Pass Port Num F0165738

Nationality Indian

Contact this candidate