Sales Manager Software Project Business .Net Sql Server

YOGESWARA REDDY (******)

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

Mob: +91-097********

SUMMARY

. Highly successful IT Professional with over 10+ years of experience in

developing, testing Web-based solutions

. Expertise in Agile PLM system administration.

. Expertise in managing Agile PLM Infrastructure & Build Automation

. Expertise in designing, developing and testing various web applications

& client server applications

. Knowledge of PLM, HR, Education, Health, Sales & Marketing and Financial

domains

. Expertise in ASP.NET, VB.NET, C#, VB6.0, ASP, Webforms, Winforms

. Excellent analytical and debugging skills

. Excellent management skills with proven ability in leading big teams

SKILLS SUMMARY

Operating System: Windows XP, Windows Server 2000, 2003, 2008

Languages: VB6.0, ASP, VB.NET, C#, ASP.NET, ADO.NET, Core JAVA

Database: SQL Server 2008, 2005, 2000 & Oracle 10g, 11g

Web Servers: Web Logic 8 / 10.3, IIS5.0 / IIS6.0 / IIS7.0

Tools: Microsoft Visual Studio 2005, 2008, 2010, MCMS, SPS.

Testing: Quality Center, Manual Testing & Win runner

PLM Tools: Agile PLM 9.2.2.6 / 9.3 / 9.3.0.2

EXPERIENCE HIGHLIGHTS

DELL INTERNATIONAL SERVICES, BANGALORE

April 2009 - Present (April 2011)

Development Lead

Agile9.3 Upgrade

Dell is one of the large customers implementing Oracle Agile PLM tool for

managing design and manufacture products. Successfully upgraded and

implemented Agile 9.2.2.6 to Agile 9.3.0.2 with new infrastructure is

designed to enhance the scalability and performance. Implementing PC, PQM,

PPM, PCM modules of Agile 9.3.0.2 allows decommissioning most of the legacy

applications developed over a period of time. Advantages include saving

cost on support of these outdated technology standards

Account: Dell DBI

Duration: April 2009 to till date (March 2011)

Roles& Responsibilities:

Core responsibilities will include system administration, support, and

technical leadership within the Agile PLM platform, system configuration,

creating documentation, application change management, manage multiple

small projects and manage communications across multiple

businesses/geographies.

Experience in providing client support and consultation configures,

support, and administer Agile PLM platform. Proactively monitor the Agile

servers, setup and run jobs on a regularly scheduled basis which will

maintain the integrity of the system Provide problem management for the

Agile PLM platform including managing escalated issues to resolution.

Provide technical leadership and client support for the Agile PLM platform

including participating in the architecture team, desktop forum, and change

control board. Collaborate with technical teams across Medtronic including,

but not limited to Intel, Database, Storage.

Project responsibilities include as an infrastructure upgrade & build

automation lead involved in the following activities

. Worked closely with technical architecture team / Oracle teams to

design new architecture for implementing Agile PLM 9.3.0.2

. Upgraded Agile database to new versions using AUT, Averify tools

. Build over fifty Agile 9.3.0.2 cluster environments / standalone

environments

. Supporting all non-prod (PoC / DEV / DIT / SIT / UAT / PERF) and

production environment

. Defining roles & responsibilities for Infra team

. Worked on automation build for bolt-on applications

. Deployed / done configurations to all custom application post agile

build

. Troubleshooting network / hardware / systems errors

. Preparing deployment documents

. Technical support to assist customers to troubleshoot and resolve

issues

. Coordinate communications among different development, testing,

configuration management, business teams, and the customer

Agile PLM skills:

. Experience in Agile PLM 9.2/9.3 Administration

. Agile PLM install, patching, upgrades

. Knowledge of Application servers (Web Logic 10.3, Tomcat)

. Experience in Oracle DBA (10g/11g)

. Strong analytical and troubleshooting skills.

. Experience in Agile Architecture Clustered and non cluster

environments

. Knowledge of Agile Upgrade process

. Supporting Agile SDK custom reports and PX

. Proactive monitoring, application management skills

US TECHNOLOGY

December 2006 - April 2009

SYSTEMS ANALYST

M-Track & Image Watch

L3 dev support for M-track and Image Watch applications

Responsible for code changes and code development for new enhancements, as

a developer my role includes understanding the requirements from the

business users, develop, test and implement the requests raised by business

users.

M-track:

M-track is an application that supports PjMs (Project Managers) and

Material Librarians on tracking inventory parts and systems from Product

Group. The main purpose of PjMs and Material Librarians is to develop and

test prototypes of new products.

PjMs will be able to generate different types of reports available using M-

Track Reporting website.

Image Watch:

Image Watch application used by PG marketing to keep enterprise customers

aware of the latest hardware or software releases.

Image watch has got three different end users admin, internal and external.

Image watch provides access to external users through premier web site.

Image watch provides the following information to the Dell customers

1) Supplying introduction, transition and EOL information for platforms,

peripherals, drivers, BIOS and software

2) Providing a six-month forecast roadmap

3) Proactively emailing customers (optional)

4) Displaying Global Standard Platforms and regional details

Successfully implemented admin filter enhancement & MPR report generation

enhancement.

Account: Dell (Through UST-Global)

Duration: May 2008 to till date (Apr 2009)

Roles& Responsibilities:

As a developer involved in the following activities

. Understanding the trouble tickets raised by business users

. Communicating & supporting L2 team and business users

. Providing fixes or solutions to the trouble tickets raised

. Coding, promoting the changes to DIT, SIT & UAT.

. Preparing unit test cases and performing unit testing

. Creating change tickets for moving the changes to production

. Preparing deployment documents for production & supported in the

implementation

Software Used:

Windows XP, Visual Studio 2003, C#, ASP.NET, ASP, Visual Basic 6.0, Oracle

10g

My Activity Tracker

My Activity Tracker application is designed for Inside Sales Manager (ISM)

& Inside Sales Representatives (ISR). Using this application ISM can

graphically analysis his team performance as well as compare with other

teams on daily, weekly or monthly basis on different metrics namely quotes

and orders. This application allows ISM to compare three teams or three

different team members of different teams. This application allows ISR to

easily track the quote or orders with his customer & product details on

daily, weekly or monthly basis.

Windows service is pulling the Resource Management Data (RMData) from

oracle to the SQL Server 2005 staging table. SSIS package is pulling data

(excel) from the shared location on daily basis to the SQL Server 2005

staging table.

Account: Dell (Through UST-Global)

Duration: Feb 2008 to May 2008

Roles& Responsibilities:

As a team member involved in the following activities

. Studying the business requirements from the business (EMEA - Spain).

. Responsible for preparing System Requirement Specification document

based

on the requirement study and EMEA business requirements

. Coding & testing the application

. Prepared deployment documents for production & supported in the

implementation

. Created SSIS package for pulling data to the SQL Server 2005 from

shared folders.

Software Used:

Windows XP, Visual Studio 2005, C#, ASP.NET, SQL Server 2005, Oracle 9i

Well Point Pharmacy-PATH Application

PATH (Prior Authorization Team Helper) application is designed for members

of the insurance company for getting prior authorization on the required

drugs.

PATH application allows generating reports for a specific member to know

the status of the request and also the historical data of the drugs

requested.

PATH application also allows generating reports for knowing the

availability of the drug.

Account: WellPoint - UST-Global

Duration: May 2007 to Feb 2008

Roles& Responsibilities:

As a team member involved in the following activities

. Analysing the change requests from the client

. Creating new repositories or changing the functionality of the

existing repositories.

. Responsible for preparing System Requirement Specification document

based

. on the change requests requirement

. Coding for the change requests

. Writing test cases & performing manual testing & Reporting

. Responsible preparing transition document & deployment documents

Software Used:

Windows XP, VB6.0, SQL Server 2005, Oracle 9.0, Manual Testing, Microsoft

Visio,

Livewire

HEB Intranet (Livewire) application will help the sales team collaborate

marketing and sales related contents in the EMEA region. Sales Agents,

Content Originators and Process Manager are the three main users for the

Livewire System Sales Agents will be able to easily access Marketing

contents, Products, Line of Products, Finance promotion roadmaps and any

latest Software offerings available regionally Livewire will have a link

against each product which will direct to the Dell Public website.

Livewire will provide Content Originators from each department the ability

to easily add Information / documents to Livewire for that department. The

departments would be Finance, Accounts, Technical Support, Customer Care

and Credit control. Submission of the documents needs to be approved by the

Process Manager. The Livewire will provide email links for supporting

organizations to allow sales agents to submit requests for

information/action

Livewire will provide Content Originators from each region to create

Product Announcements or Headlines targeted to the sales agents to a

particular state / location with in the region

Process Manager has the ability to review content requests submitted.

Livewire provides Process manager the ability to approve or deny content

requests submitted by content originators. Content Originator alerted with

the status of approval or rejection by sending an automated email.

Livewire imports a list of domain users from Active Directory that can be

used to import information from other directory services or applications.

Livewire will provide all users the ability to maintain their user profile

information

Account: Dell (Through UST-Global)

Duration: Dec 2006 to Apr 2007

Roles& Responsibilities:

As a team member involved in the following activities

. Studying the business processes of EMEA.

. Research and development on MOSS 2007 as its new technology

. Supported in writing test cases, manual testing & Reporting

. Responsible for preparing System Requirement Specification document

based

on the requirement study and EMEA requirements

Software Used:

Windows 2003, IIS6.0, Manual Testing, Microsoft Visio, ASP.Net2.0, ADO.Net,

C#, JavaScript, HTML, SQL Server 2005, Visual Studio 2005, Share point

Portal Server 2007 (MOSS 2007)

CES PVT LTD

JAN 2006 - DECEMBER 2006

PROJECT LEAD

Institutional Strengthening & Capacity Building of AAAD

External assistance made available by World Bank, Asian

Development Bank, IBRD, Japan etc to India comprises of loans and grants.

Aid Accounts & Audit Division (AA&A Division) is one of the divisions under

external finance wing. AAAD is the designated authority to withdraw funds

from loan/grant account. The AA&A division deals with all matters connected

with financial covenants in the agreement. AA&A division is responsible for

scrutinizing claims received from the project implementing agencies. AA&A

division also handles timely discharge of debt service payments to all the

donors and maintaining loan account under each loan agreement.

Automation of Aid Accounts and Audit Division office will

provide effective and efficient handling of transactions. The

system is divided into five different modules for convince, namely

administration, transactions, processing, reports, & masters. The

requirement is that to design, develop web-based solution, including

implementation, customization, testing, supply, installation, integration,

and migration of legacy data, documentation, support and maintenance

evolving a fully integrated system. The system provides facility to project

authorities to submit e-claims. Reporting Services feature of SQL Server

2005 is used to design and generate web reports. Training provided for the

end users on ad-hoc reporting.

Duration: Dec 2006 to Apr 2007

Roles& Responsibilities:

As a Team lead I was involved in the following activities

. Studying the business processes of AAAD and existing ICS application.

. Designing the software solution to meet the needs of AAAD.

. Development of application software based on the design developed as

per

AAAD requirements

. Undertaking data population and data migration to populate the

developed

Databases of the application environment

. Implementing the tested code for roll out on production servers at

AAAD

. Undertaking changes and modifications as per the requirements of AAAD

as

per a laid down change request process

. Helping AAAD roll out a network plan for the project

. Ensuring application availability to remote clients via web

. Maintenance of the developed code for a period of six months

. Undertaking training of AAAD personal, representatives of funding

agencies &

Representatives of project authority on the developed application

software

. Provisioning of detailed user manuals for all the supplied code

. Coordination between the team members

. Receiving the reports from team members and filing after adding

comments

. Reporting to the project manager.

. Distribution of work between the team members according to the project

Schedule

Software Used:

Windows 2003, IIS6.0, Manual Testing, ASP.Net, ADO.Net, VB.Net, JavaScript,

HTML, SQL Server 2005, SQL Server 2005 Report Services, Visual Studio 2005

PEROT SYSTEMS

MARCH 2005 - JANUARY 2006

ASSOCIATE

Document Registry Replacement System

Share Point Document Registry System to replace existing Document

Registration system. To integrate the existing Document Registry business

processes with the SPS to provide a secure repository for controlled

documents, this also includes custom search. The system composed of a

document repository around a Share Point Document library with custom Web

Parts. Interface with the PSA application for referencing Project Numbers

and locating documents relating to Proposals. Interface with the

Salesforce.com application for maintaining the Client list. To build a

collaborative portal solution that is scalable, reliable, easy to use, and

easy to manage.

Roles& Responsibilities:

As an Associate I was involved in the following activities

. Coordination between the team members

. Receiving the reports from team members and filing after adding comments

. Reporting to the project leader.

. Analysis, Design & Coding

. User Acceptance Test support

Software Used:

Share Point Portal Server 2003, Windows Server 2003, IIS6.0, C#, ASP.Net,

JavaScript, .NET Web Services, FrontPage 2003, SQL Server 2000.

PEROT SYSTEMS

MARCH 2005 - MARCH 2005

ASSOCIATE

Orange (Migration of Online Catalogue site from Active Server Pages to CMS

2002)

Reverse Engineering & Requirements Gathering. The role included to first

reverse engineer an existing site, so as to understand the basic business

logic. Model the existing functionality so as to migrate it in CMS 2002.

The work included of writing Use Cases, creating template layouts, creating

database relation diagrams, creating the site map for existing

functionality. Role also demanded to guide junior team members by

modularizing the entire functionality and distributing the modules among

them.

Roles& Responsibilities:

As an Associate as involved in the following activities:

. Test Database development

. Construction and Testing of the incidents

. Coordination between client and offshore team

. User Acceptance Test support

. Implementation support

Software Used:

Windows 2000, IIS5.0, ASP.Net, ADO.Net, C#, JavaScript, HTML, XML, SQL

Server 2000, Content Management Server 2002

PEROT SYSTEMS

JANUARY 2005 - FEBRUARY 2005

ASSOCIATE

Orange (Download request enhancements on www.shl.com)

The requirement was that downloads that require users to be authenticated

should not be sent as email attachments. Such downloads should be returned

in the browser after user authentication. If the browser cannot display the

download document then the user should be able to save it to their disk.

The implementation of this functionality demanded critical knowledge of

Input / Output operations done on file & Binary write operations done on

the requested file.

Roles& Responsibilities:

As an Associate as involved in the following activities:

. Analysis

. Design

. Development

Software Used:

Windows 2000, IIS5.0, ASP.Net, ADO.Net, C#, JavaScript, HTML, XML, SQL

Server 2000, Content Management Server 2002

Visu Cybertech Ltd

JULY 2003 - DECEMBER 2004

SOFTWARE PROGRAMMER

ASP.net Leave Project

This Internet application allows employees of the company to apply leave

from anywhere through Internet. The main aim of this project is the

transactions of leaves. The home of this project is designed is such a way

that it allows both employees and administrators to enter into their

applications with different log-ins. If you enter using administrator log

in you can have extra permissions like recruiting new employees and

sanctioning leaves, viewing monthly and yearly reports of any employee. If

you enter using user log in, you have only a few options like applying for

leave and viewing the status of your leaves.

Roles& Responsibilities:

As a software programmer as involved in the following activities:

. Analysis

. Design

. Development

Software Used:

ASP.NET, VB.NET, SQL Server 2000

Visu Cybertech Ltd

NOVEMBER 2001 - JUNE 2003

SOFTWARE PROGRAMMER

Online Tests Portal Development (ICET)

It is an online ICET (Integrated Common Entrance test). In ICET a student

has to register in order to take the test. In ICET there are 3 sections

Verbal, Analytical, Quantitative Sections. Each section has its own method

to display questions. The questions are selected randomly from the database

and not repeated. The score is displayed at the end of the test and the

time for each section is maintained. If it is not completed with in

allotted time the test stops and the scores obtained till that time for

that subject.

Roles& Responsibilities:

As a software programmer as involved in the following activities:

. Analysis

. Design

. Development

Software Used:

Visual Basic 6.0, MS-Access

Visu Cybertech Ltd

JULY 2000 - OCTOBER 2001

SOFTWARE PROGRAMMER

Master Prep GRE CBT

This project involved the development of CAT (Computer Adaptive Tests)

which helps students in preparing and mastering the GRE Test conducted by

Educational Testing Service through SYLVAN Testing Services. The main

modules include Verbal, Analytical, and Quantitative Sections. Adaptive

logic was written for all the sections. The main feature of this CBT is to

measure proficiency of English through Computer Adaptive test, the CAT

adapts itself to the level of test-taker. Scores are displayed soon after

the tests. This CD also has a review section.

Roles& Responsibilities:

As a software programmer as involved in the following activities:

. Analysis

. Design

. Development and

. Implementation

Software Used:

Visual Basic 6.0, MS-Access

EDUCATION, TRAINING & CERTIFICATIONS

. Master of Technology in computer science from Golden State university

. Master of Science in Biological Sciences from Sri Venkateswara

University

. PGDCA from CSTI

[pic]

Contact this candidate