Sales Sql Server Development .Net Design Application

M ADHAVI VENNAVELLI

Phone: 631-***-**** Email: ***********@*****.***

EXPERIENCE SUMMARY:

* ***** ** ************ ********** in analysis, design, development, implementation and

production support of software in enterprise & distributed J2EE applications.

Extensively worked on Distributed Programming with J2EE Architectural Framework, EJB,

Servlets, JSP, JMS, RMI, XML, XSLT, JavaScript, HTML, DB2, Oracle (SQL, PL/SQL), and

Log4J.

Experience in MVC Architecture and Struts framework.

Experience with IBM Websphere, Oracle Application Server and exposure to similar technologies

like BEA Web Logic and Tomcat.

Efficient in developing Java/J2EE applications using various IDE tools like Eclipse 3.0.1.1,

WSAD5.0/5.1, RAD6.0 and JDeveloper.

Good knowledge & working experience on Multi-Tier & Designs, including Web & Application

tiers.

Proficient with J2EE Design Patterns, System Analysis and Design using UML & RUP with

Rational Rose for J2EE based applications.

Knowledge of Hibernate and Spring framework.

Good experience in C/C++, UNIX, shell scripting, Embedded SQL, PL/SQL with the Oracle,

Sybase RDBMS, DB2 and, UDB.

Good working knowledge on CVS and Visual Source Safe (VSS) for version control

Experience in all phases of Software Development Life Cycle (SDLC) including requirement

analysis, Design, development, testing, deployment and maintenance.

Excellent team player with very good communication skills.

EDUCATION:

Master of Science, Computer Science & Engineering, University of Texas at Arlington, Arlington, TX.

Bachelor of Technology, Jawaharlal Nehru Technological University, Hyderabad, India.

TECHNICAL SKILLS:

Programming Languages: Java, C, C++, C#, Embedded SQL, PL/SQL

J2EE -Technologies: EJB, JSP, Servlets, RMI, JNDI, JDBC, Java Beans, MVC Arch,

and Ant (Jakarta) for building the project

Development Environment: WSAD5.0/5.1, RAD6.0

Operating Systems : UNIX - DEC UNIX Server, HP-UNIX, AIX, Linux

Databases : Sybase12, Oracle8.4, MS SQL Server 7.0, DB2

Scripting : UNIX Shell Scripting, sed, awk, HTML, DHTML

PROFESSIONAL EXPERIENCE:

Chrysler LLC, Auburn Hills, MI (USA). Sep 2007 – Present

Programmer Analyst.

ISP – Integrated Sales Planning

ISP is a tool that was designed to integrate business planning for Chrysler and Mercedes Benz

vehicles. This planning tool was created to help regional offices to develop sales forecasts, as

well as review, consolidate, and approve forecasts submitted by the MPUs. Every month this

system creates a new production program based on the production forecast sent by the

forecasters, and the over builds/under builds of the previous month. The production forecast that

is submitted through ISP is ultimately used to schedule vehicle production. The goal of ISP is to

establish world wide sales planning process and common system for all Daimler Chrysler brands.

Role:

Involved in the analysis, design and development of the Production requirement Worksheets for

various vehicle markets (Chrysler International, MB Global, and Volkswagen NAFTA).

Analyzed and implemented the EPT (Excel Planning tool), an offline worksheet – used for

planning purposes.

Identified and designed system’s low level components, estimated high level time and resource

requirements.

Responsible for writing high level and low level Design and Solutions Specification Document.

Computed various formulas for the planning process and profit impact analysis.

Implemented the Formula One methods and functionality.

Led two members in design, development, testing and delivery and was the SME (Subject Matter

Expert.)

Worked effectively with offshore teams by sharing system knowledge and extracting productivity

from them.

Environment:

Java /J2EE, Struts, IRAD, Formula One, EPT with Excel Macro (VBA), C++, UNIX, Sybase.

Lowe’s Companies Inc, Wilkesboro, NC (USA). June 2004 – Sept 07

Programmer Analyst.

GBI - Credit Processing Overhaul (GECC)

As part of the Global business interface, the CPO GECC project will enhance the existing credit

express process to handle the Canadian credit express in the CA Stores. This store processes at

Lowe’s communicate with GE for approval, pre-approval, and modifications of the credit

applications. The various types of credit provided by Lowe’s & GE are LCC, LPC, LAR and LBA

cards.

Role:

Involved in the analysis, design and development of the system.

Involved in the store side application which involves development of the commercial and

consumer application for both the countries.

Involved in the web application which sets up the application data in the DB2 tables which are

send to the store on a daily /weekly basis.

Re-architected and re-designed existing application to meet the enhanced requirement.

Modified existing automated test plans to accommodate new changes and executed for its

performance.

Wrote very detailed Unit and Integration/System Test plans to cover existing functionality and

new changes added to the system.

Assisted Business users in writing user acceptance test plans and setting up appropriate data

required for testing.

Was Subject Matter Expert for Vendor teams and shared system knowledge.

Responsible for Vendor testing with GE.

Environment:

Java, JDBC, RAD with LKN framework, C++, UNIX, Sybase.

Returns System

The Returns Enhancement Project will implement the Store Returns System in accordance with

the Sales System. The system is redesigned to capture the sales data, tax information and sync

with the generic POS system. All the sales data is stored and is used in the returns process. The

returns system is enhanced to retrieve the sale info based on the sale tender when the customer

doesn’t provide the sales receipt.

Role:

Involved in the analysis of the current returns system and in the re-design of the new system.

Also designed the main frame processes which communicate with the C store modules.

Developed code which modulates the returns rules based on the tenders used during sale. Also

prepared Unit test plans for all the modules. Also responsible for documentation.

Environment:

Java, JDBC, RAD with LKN framework, C++, C, UNIX, Sybase.

Rebate System

The rebates system automatically prints rebate information to receipts when items that qualify for

rebate programs are purchased. The web application that supports the existing rebates project is

modified to allow role based users. Based on their role the users are allowed to edit the existing

rebate data such as the quantity, cost and the items included in the rebates. The application also

provides the ability to generate location specific item rebates all over US. Inbound processor for

store receives file with new rebate data that is setup with this web application.

Role:

Involved in meeting with the business for requirement gathering.

Involved in the analysis, design and development of the system.

Responsible for various test cases and unit test plans to test the functionality of the application.

Environment:

Java, JDBC, DB2, Web sphere with LKN framework.

Signage

The Store Signage Enhancement will implement Lowe’s new strategic direction for in-store

signage. This enhancement will reduce the number of colored stocks and consolidate them into

one colored stock, with varying formats. In addition, this enhancement will implement new

formats, clean up existing formats, increase legibility, and clarify the information on the signage.

Store system modifications will be made to streamline the signage setup/request process in the

stores.

Role:

Involved in the re-design and analysis of the system.

Involved in the development of system using C and UNIX, & embedded SQL.

Environment:

C, UNIX, Sybase.

InfoDat Inc, Houston, TX. Jan 2003 – June 2004

Software Programmer.

PDA Preventive Maintenance Application

Involved in the development of a web based application for City of Sugar land, a Utility Job

Messaging System. This is used by the mobile inspectors who inspect their jobs such as the

Hydrants, Valves and Manhole and upload the data to the remote server using a PDA. The jobs

are uploaded using the XML web services. The uploaded jobs are inspected by the supervisor

through a web-interface and reports are generated.

Role:

Designed and implemented the back end of the application using C#.NET.

Developed the User authentication module which deals with various user roles and user groups.

Designed the database in MS Access and SQL server CE.

Implemented Web services which are used to sync the data to/from the PDA to the backend

server.

Written various SQL queries and performed Unit testing.

Environment:

Microsoft Visual Studio.NET 2003, ASP.NET, C#.NET, HTML, XML, IIS 5.0, SQL Server, MS

Access 2000, Microsoft Visual Source Safe.

Vendor Surveillance Reports

Involved in the design and development of a web-based application, as part of InfoDat’s

Enterprise Reporting System. This application incorporates the three-tier architecture wherein the

thick client interacts with the backend database using the web services and a web interface is

used to access the backend application. It is mainly used by the PPI employees who create

surveillance reports and upload the reports to their supervisor. This facilities various kinds of

operations to the employee as well as the supervisor. For ex: the employee can edit, delete

reports in addition to creating them. The supervisor can view, edit, delete and approve reports. A

PDF format of the report can also be generated.

Role:

Mainly responsible for the development of the client side application. Implemented the client side

modules in C# NET.

Developed the Wrapper Classes in C#, which interact with Data Layer to hide the complexity of

Data interaction.

Developed server side modules using XML Web Services.

Designed and implemented reports using Crystal Reports.

Used ADO.NET to access the database.

Used the code analysis tool FxCop .

Involved in the System Analysis, Design, Development and Implementation of the Architecture.

Requirement Analysis, Documentation and Status Reports.

Involved in the maintenance of the system.

Environment:

C# .NET, ASP.NET, Microsoft Visual Studio. Net, Web Services, HTML, XML, IIS 5.0, MySQL,

MS Access, Windows 2000, Crystal Reports, Microsoft Visio, FxCop, Microsoft Visual Source

Safe.

Timesheet Reporting System

Involved in designing and implementing a web-based application as part of InfoDat’s Enterprise

Reporting System. This application is used by the PPI employees to submit their timesheets. The

employees create, view, edit, save, delete, and submit timesheets to the server. They also

manage their accounts. The supervisors view, approve, deny, download, edit, delete timesheets,

and send e-mail remainders to the employees. They query and generate reports. They can

delegate the employees to another supervisor. They also manage their accounts. The accountant

manages the payrolls of all the employees. He even checks for timesheets that are not submitted.

They also manage the user accounts.

Role:

Implemented the module where in the employee creates a time sheet for the current period as

well as any prior periods. Also designed the database.

Actively involved in all the phases of the software life cycle.

Implemented the source code using C#.NET.

Performed various types of testing.

Environment:

Microsoft Visual Studio.NET 2002, ASP.NET, C#.NET, HTML, IIS 5.0, SQL Server, MS Access,

Microsoft Visio

Utility Job Messaging System

Designed and maintained a Smart phone, web based application (UJMS) for a construction

company. This application is used by the mobile sales personnel via a smart phone or a pocket

PC. The salesman can view their jobs, create new jobs and update any completed jobs on the fly

using the mobile device. When the salesman submits a job, it is sent to the remote SQL server by

calling a web service. The information is maintained and updated in the database.

Role:

Designed and implemented the front end of the application using C#.NET.

Designed the database in MS Access (front end) and SQL server (Back end).

Implemented Web services.

Written various SQL queries using Stored Procedures.

Performed Unit testing.

Environment:

Microsoft Visual Studio.NET, ASP.NET, C#.NET, HTML, XML, IIS 5.0, SQL Server, MS Access,

Microsoft Visual Source Safe.

Reference: Will provide upon request.

Contact this candidate