Project Management .Net Application Data Software

Gorugantula Venkata Kiran Kumar

H.No:*-***/**/**,Road No 3, Sri Lakshmi Nagar Colony Bod Uppal, Hyderabad-

500039

Mobile: +91-986*******; Mail-ID: ********@*****.***

Summary

8+ years of strong experiences in Software Development Life Cycle (SDLC) -

including requirements, specifications, analysis, design, programming,

testing, implementation and maintenance and ability to plan and manage

complex multi-person/multi-location projects based on Microsoft

Technologies.

Education

< MCA from IGNOU 2000-2003

< Bachelor of Sciences from Osmania University Hyderabad. 1996-1999

< Completed GNIIT course.

Organisational Profile

Aug'24 to Till Date GENPACT

Lead Consultant (www.genpact.com)

May'24 to 23rd Aug 2011 SQL STAR International Pvt. Ltd

Sr.SoftwareEngineer (www.sqlstar.com)

May'06 to May'07 New Horizons Cyber Soft Ltd. Software

Engineer.(www.nhclindia.com)

May'03 to May'06 Interactive Corporation. Programmer

www.interactivewebinfo.com

.

Skill Set

Technical;

Operating Systems : Windows 2000, 2003 and 2008

Programming Languages : Vb.net, Visual Basic 6.0

Web Technologies : ASP.Net with VB.net, Classic ASP 3.0, Web Services and

CLOUD

Using Microsoft AZURE

Reporting Technologies : Generating Data reports, SSRS Reports

Scripting Languages : Java Script, Microsoft VB Script,

Database Technologies : Oracle, SQL Server 2008, MS-Access.

Involved in Making the Generic application with below mentioned points for

AP Process

> Out of the box processes for invoice with PO, expense vouchers and

invoices without PO

> Customizable workflows that can be modified by business users

> Completely web-based - supports centralized, distributed processing

models

> Enable approvals through email and web

> Multi-level escalations and follow ups

> Visibility and transparency to track every invoice from receipt to

payment

> Exception handling procedures and alternate approvers

> Powerful web-based, real-time reports and analysis on process

execution

> Customizable alerts and escalations for fraud detection and

exceptions

Projects Handled

Company : GENPACT.

Project: IT Issue Tracker

Role: Requirement gathering, Analysis, Design and Development.

Environment: ASP.Net 4.0, SQL 2008 and CLOUD using Microsoft AZURE

Implemented the IT Issue Tracker workflow for the IT Product Organization

in CLOUD, to track the issues against the each application used in that

organization. Whenever an issue is raised then an Auto mail will get

triggered to the respective support team with primary information so that

the support team logs in and try to resolve the issue based on its

priority.

Hosted the application In CLOUD

http://casetrackernew.cloudapp.net/login

Auto reminders and escalations are set in the application during life cycle

of an issue.

Company : GENPACT.

Project: MDM (Master Data Management)

Client : ECOLAB

Role: Requirement gathering, Analysis, Design and Development

Environment: ASP.Net 3.5, SQL 2008, IIS 7.0

Overview : Genpact MDM Workflow product helps orchestrate the end to end

Master data management process by managing Master Data Requests(creation,

modification and deletion), tracking exceptions till these are resolved and

finally reconciling requests 'processed' with data posted in the Customer

ERP System. The system integrates with various archival systems (thru XML

Data Exchange) to ensure that a data processing lifecycle ends only after

completion of the archival process. It also has a rich repository of

reports that provide near real-time visibility to the status of processing.

Application is hosted with below features

1. Hosted the application In internet with the redundancy built in

2. Application is developed in four tier architecture

3. Application is developed with the Multi language capability

4. Application is developed with Unicode option

5. Application will display the labels based on the language user

selected at the login screen

6. Reading Generic Mail box (GMB) and updating the status in the

workflow. Primary key will be the Transaction id in the Subject line

7. Pushing the data to client ERP system

8. Used SSRS reports

https://ecolab-bo-workflow.genpact.com/Mdmlite/login

Company : GENPACT.

Project: MJE Tracker

Client: Catalent

Role: Requirement Gathering, Designing, Implementation

Environment: ASP.Net 4.0, SQL 2008, IIS 7.0

Implemented the MJE tracker workflow for the client Catalent to track the

Journal entries and getting the approval from the client for posting

journals, whenever an entry is made then based on the category user selects

it will ask for the approver from the list of valid approvers.

Hosted the application in intranet

Reminders and escalations are defined in the application for the closure if

the ticket

Company : SQL Star International Ltd.

Client: Catalent / Lexis Nexis / GBS / MODUS

Project: APTOME (Workflow tool for AP department in finance)

Role: Designing, Coding, Implementation

Environment: ASP.Net, SQL 2005/2008, IIS 6.0 and above

Description:

APtome is a web based application that is used for processing documents

by the backend operations team for daily financial business. The vendors

send the hard copy images of the invoices are then sorted out, scanned

and uploaded for the backend team to use in processing.

The APtome uses scanned documents (soft copies Tiff/PDF/JPEG) for further

processing. If facilitates work load management by organising the images

in user defined queues. It enables to perform MIS reporting capabilities.

The user, Role bases access ensures authorized access to important data.

Older version (VB 6.0) of the tool is implemented for more than 10

customers in GENPACT at GENPACT/Customer datacenters and new version (ASP

.Net) is implemented for one customer. It is a simple configurable tool.

This tool was re-developed from VB 6.0 to ASP .Net

Responsibilities

. Requirements Gathering, Preparing BSAR document

. Preparing a Project Plan.

. Implementation and training users etc.

Achievements

. Achieved a high level of customer satisfaction through proactive

interaction with the client

. Received a GOLD award for the successfully implementation

. Received Best Resource award for the year 2009-2010

. Implemented for 13 customers

Company: SQL Star International Ltd.

Client: HR Process, GENPACT

Project: Daily Status Tracker

Role: Designing and Coding

Environment: ASP, SQL 2005, IIS 6.0

Description:

This Project is used to raise a ticket for a particular category and

tracking status of the ticket and based on the configured day's

escalation mails will fire to the hierarchy of the user who raised ticket

Application is hosted in GENPACT home page and it is accessible through

out GENPACT and it is working fine without any issue and application is

enabled with SSO authentication

. Involved in design, Coding and programming of Application

. Created a job in SQL SERVR 2005 which picks the data from ERP and

Pumps in to the database regularly

. All the reports have export to Excel option

Company: SQL Star International Ltd.

Client: GENPACT, Hyderabad

Project: Case Tracker, Nova tool, DAT tool

Role: Designing and Coding

Environment: ASP.Net, VB6.0, SQL 2005/2008, IIS

Description:

CASE TRACKER: Internal user or Vendor can raise a ticket for products based

on CATEGORY, the tickets will be generate in two methods, Round Robin

method and PULL method.

1. In RRB the tickets can allocate the users based on category, if the

issue solver or user is not present then we can allocate those tickets

to another user by swapping method.

2. PULL method the tickets will open to all users who are the issue

solvers are there they should login and pull the tickets one by one.

If the issue is correct user will resolve the issue or user can forward,

approved, reject the issue to another user. So Issue Raiser will know the

status of the ticket. The application deployed internal for internal

users and globally for Vendors.

Nova Tool: This tool is developed to minimize manual reporting time and

errors. There are various versions of this tool implemented for more than

7-8 customers. Excel/flat file downloaded for ERP is the input for the

tool and business logic is applied and output is generated. This tool can

also generate Pivot charts, Graphs.

DAT: DAT is a Web based application used to identify duplicate invoices

before payment run, which are frequently missed by the ERP. Unlike ERP,

Duplicate Audit can: Search for duplicates by any combination of fields

in the payment proposal file and perform Out/In Range Audit. It can

define a number of duplicate identification criteria on any field

combination and report out probable duplicates out of the current payment

proposal file.

Responsibilities

. Identifying and Analyzing Client Requirements

. Preparing a Project Plan.

. Integrating the front-end & back-end modules

. Implementation and training of users etc.

Achievements

. Achieved a high level of customer satisfaction through proactive

interaction with the client

. Implemented for more than 8 customers.

Company: New Horizons Cybersoft Ltd.

Client: GESCOM, APCPDCL

Project: Total Revenue Management (TRM) System, APCPDCL,

Role: Designing and Coding

Environment: VB6.0, VB .Net, Oracle 9i, Windows 2003 Server

Total Revenue Management (TRM) System:

This project was started as the result of an e-governance initiative

by our client Gulbarga Electricity Supply Company (GESCOM), Karnataka.

The goal of the management was to improve its efficiency by streamling

its operations. The aim of this project is to computerize & automate the

operations of MESCOM & also to set up a "Management Information System"

(MIS).

This Project Mainly Consists of Three Modules

1. Download of the Monthly/Bi-Monthly Bills

2. Upload of the Bills

3. Upload of Payments

For this we used the software Vb 6.0 and oracle and Backend

For Counter Payments we developed software in VB.Net and Ms-Access

Description:

Company : Interactive Corporation

Project : HOSPITAL MANAGEMENT SYSTEM(HMS)

Client : Rainbow (Banjara Hills), Sai Bhavani (Jeedimetla),

NEGHRIMS (Meghalaya)

This is software developed in a view to simplify the administration

of any Hospital by computerizing the activities, which are performed

manually. This software is more users friendly.

There are 4 modules in total in which all are main modules. They are

In Patient Module Outpatients Module, Labs Module and Pharmacy Module.

Responsibilities:

. Implementation of the application

. Involved in developing and executing the Software requirements.

. Used Visual Basic 6.0 as the Front End of the application and SQL

SERVER.MS-ACCESS AND ORACLE as Back End.

. Preparing the Data Reports.

Environment:

Visual Basic, Data Reports, Windows 2000, Oracle 8i

Company : Interactive Corporation

Project : Payroll

Client : Megha Engineering (Balnagar)

The Payroll Modules facilitates the Employee daily attendance. With the

help of swipe card system. We can even produce the Employee Monthly Pay

slip; we can allocate shifts the employees.

Responsibilities:

Involved in Designing, Coding and debugging.

Created Reports.

Used SQL SERVER SQL statements for backend process.

Environment:

Visual Basic 6.0, SQL SERVER, Windows2000

Company : Interactive Corporation

Project : CIVIL

Client : SCCL

Description

The mains purpose of this project is to make the data to be stored

at one place and reports can be generated at their will. Civil Project Is

having Different Modules 1.Work Initiation 2.Cost Estimation 3. Tender

4.Work Award 5. Bills. I Created a Interface For This Project

To export the data from the server to ms-access and import the data

from ms-access to the server.

Responsibilities:

> Involved in coding

> Involved in Debugging

> Involved in Writing Patches

> Involved in Maintaining the Data from Different Areas.

> Design of reports

Used Visual Basic 6.0 as the Front End of the application and MS-ACCESS,

ORACLE as Back End and Used ASP for the Web Reports.

Personal Details:

Name : G.V. Kiran Kumar

Father's name : G.V.Subramanyam.

Date of Birth : 31/12/1978

Sex : Male

Marital Status : Married

Nationality : INDIAN

Religion : Hindu

Languages Known : English, Hindi, and Telugu

Passport No : K2580356

Present Address : G.V. Kiran Kumar

H.No: 3-125/87/47

Road No 3 Sri Laxmi Nagar

Colony,

Bod Uppal-500039,

Andhra Pradesh,

INDIA.

Ph.No: 64604072.

Cell No: 986-***-****

E-Mail : ********@*****.***

Place: Secunderabad,

Date:

(G.V. Kiran Kumar)

Contact this candidate