Piyush

PIYUSH

CHAWHAN

N e a r V R C E Te l e p h o n e E x c h a n g e , IT Park, Parsodi-Nagpur-440022 + 91 9370772734 / + 91 9764004288

[email protected]

Summary •Over 5 years of Information Technology experience in Software Development with Windows / Web / Windows Mobile application development, C#, ADO.NET, VB.NET, COM/DCOM and Custom Report Generation. •Skilled C# / VB.NET / VB 6.0 developer.

•Object oriented design and programming skills. •Actively participated and lead projects involving 2 & 3 tier application development. •Knowledge of database development, data retrieval, data manipulation and data management for Sql Server 2000/2005/2008, Sql Server CE, SqlAnywhere 11, Ms Access database. (Stored procedures, functions, triggers and views) •Good understanding of Client-Server Architecture.

•Implemented various projects using Software Development Life Cycle [SDLC]. •Good in verbal, written communication skills and preparing/making presentations to technical personnel. Quick learner, team player and easily adapts to new technology.

EXPERIENCE

Currently Working in ZEON Solutions (P) Ltd. as an Software Engineer (Microsoft Technologies) [March, 08-Till Date] Worked as Software Engineer at Rungta InfoTech Systems (P) Ltd. [June, 07-Feb,08] Worked as an Sr. Software Engineer at Sovatech Solutions (P) Ltd. Raipur [Sep-04-June,07] Worked as an Software Developer at Nexus System and Solutions, Raipur [Feb, 04-Sep-04] Worked as a Developer cum Quality Assurance Executive in a BPO (Non-Voice Based), eXact Outsource pvt. Ltd. STPI, Bhilai. [April 03 – Feb 04] Worked as an Programmer cum Faculty at COMPUTECH®, Computer Education and Software development centre, Alwar (RAJ) [March 02 – March 03]

DETAILS OF TRAININGS UNDERGONE TRAINED ON C, C++ , MS-Office DotNet Framework,VB 6.0 ,SQL Server, Java, Oracle 8i, Asp, VC++, Win –NT/ 2000

AT All India Society for Electronics and Computer Technology, Bhilai

Silverline Institute of Software Technology, Chennai

TECHNICAL SKILLS Areas Programming Languages Web Technologies Web Servers Design Methodologies/Tool Testing Tools Project Management Tools CM Tools Frame Work Software Development Methods Databases Reporting Tools Domain Expertise Tools

Skill Sets C#, VB.Net, VB6.0, C, Java ASP.Net, ASP, XML IIS , Apache Tomcat UML Win Runner, Nunit Microsoft Project, Open Project TFS, Microsoft VSS, SVN . Net 3.5, .Net 2.0 Waterfall, Agile(Scrum) Microsoft Sql Server 2008/2005/2000, SQLAnywhere10, MySql 4.1 Seagate Crystal Reports, Active Reports, Sql Server Reporting Tool Healthcare, Education, ERP for SME, Wireless TOAD, SqlYog,Ms Visio

CERTIFICATION Microsoft Certification: MCTS Dotnet Framework 2.0 Windows Application

https://mcp.microsoft.com/authenticate/validatemcp.aspx ( Transcript ID (824143) Access Code (pc100180) ) BrainBench Certification: ASP.Net Fundamentals,VB.Net Fundamentals,J2EE 1.4,MS Access 2000 Fundamentals, Project Management, RDBMS Concepts

http://www.brainbench.com/transcript.jsp?pid=5928855 Areas of expertise /interest includes but not limited to Product Development Efficient Code development Team Building/Leadership Functional documentation

Project Management Object oriented design Modules Integration Reports generation

Strategic Planning Database design GUI development 

DETAILS OF THE PROJECTS WORKED ON 01

Project Name

Facility Management (FM)

Customer

Tiscor, Brady Corporation

Organization

Zeon Solutions (P) Ltd.

Description of the project

02

Team Size

: 4

Role

: Team Member

Responsibility

: Bug Fixing- Solving Escalation and BTT Issues.

Technologies Used

:

Project Name

Label Mark (LM)

Customer

Brady Corporation

Organization

Zeon Solutions (P) Ltd.

Worked on PPC Side. Vb.net / Sql Server CE / Window Mobile 6 /VB 6.0 /Crystal Reports 11.0 / Sql Server 2005 / Oracle 11i

Description of the project Team Size

: 10

Role

: Team Member

Responsibility

: Worked on Editor –Text, Image and Barcode Object.

Technologies Used

03

Code Review and Code re-factoring on daily basis according to client standard. Interaction with client about task updates. : C# / WPF / Dotnet Framework 3.5

Project Name

Bird Watcher

Customer

Mumbai Bird Club

Organization

Rungta Infotech Systems Pvt. Ltd.

Description of the project It’s an application for PDA/Handheld/mobile evices, which will enable user to identify a Bird species through a predefined Identification process. The application will be designed to have a simple step by step identification process based on a set of predefined inputs (like geographical location, anatomical parts, habitat, point of find etc) as identification parameters and these will be used to have a sequential elimination of the species to arrive at the fewest number of species possible

Team Size

: 2

Role

: Team Leader

04

Responsibility

: Analysis of Client requirements. Design of the operational flow,

Technologies Used

: C# / Sql Server CE / Window Mobile 6

Project Name

Sales force Automation System (Product)

Customer

Meditia Labs (P) Ltd.

Organization

Rungta Infotech Systems Pvt. Ltd.

prepared design documents, E-R diagrams, Class Design Document, Database Design Document.

Description of the project Sales force management systems are information systems used in marketing and management that help automate some sales and sales force management functions. SFA includes a contact management system which tracks all contact that has been made with a given customer, the purpose of the contact, and any follow up that might be required. This ensures that sales efforts won’t be duplicated eliminating the risk of irritating customers.

Team Size

: 5

Role

: Team Leader

Responsibility

: Analysis of Client requirements. Design of the operational flow,

Technologies Used

prepared design documents, E-R diagrams, Class Design Document, Database Design Document.

Developed efficient, object oriented .NET applications in modular form. Implemented parameterized functions, procedure. : VB.NET / Sql Server 2005 / Crystal Reports

05

Project Name

Institute Management System (Tanishq)

Customer

Product Development

Organization

Rungta Infotech Systems Pvt. Ltd.

Description of the project Tanishq is a product specially made for Educational Institutions for hassle free Management of the Institution. It included Campus Management, Department management, Admission Management, Student Management, Staff Management, General Management, Library Management, Laboratory Management, Examination Management, Hostel Management, Transport Management, Canteen Management, Inventory Management and Accounts Management. And is available in LAN and WAN version with interface to smart gadgets and cards.

Team Size

: 8

Role

: Sr Software Engineer

Responsibility

: Design of the operational flow, prepared design documents, E-R

Technologies Used 06

diagrams, Class Design Document, Database Design Document. Developed efficient, object oriented .NET applications in modular form. Managing Sql Server Database for all the module : VB.NET 2005/ ASP.NET 2005/ Sql Server 2005 / Crystal Reports

Project Name

Project Management System

Customer

Tometa Software, Inc

Organisation

Sovatech Solutions Pvt. Ltd.

Description of the project As the Name Suggest, its an Project Management application for managing on going projects of an organization, Covered features – Business case, Meeting, Decision, Assumptions, Issue, Risk, Action Items, Schedules, Scope and Project Priorities

Team Size

: 2

Role

: Project Leader

Responsibility

: Requirement studies by communicating with the client. Detailed analysis of Client requirements. Design of the operational flow, prepared design documents, E-R diagrams, Flow charts.

Developed efficient, object oriented .NET applications in modular form. Implemented parameterized functions, procedures, delegates and invoking events.

Duration Technologies Used

Developed code for data access routines in ADO.NET, which involved data manipulation with ‘Data Reader’, ‘Data Adapter’, connection, collection, arrays, transaction processing and exception handling. : 3 Month

: VB.NET / Sql Server 2005 Express Edition / Crystal Reports

07

Project Name

Call Center Management

Customer

RTG Healthcare Service Pvt. Ltd.

Organization

Sovatech Solutions Pvt. Ltd.

Description of the project The project involved development of an integrated system for Unique concept in healthcare industry. This project was having a comprehensive database of healthcare service providers in various capacities, the members database with RTG and also their call and query system. On business side, it was having franchise, head office and state office management..

Team Size

: 10

Role

: Sr Software Engineer

Responsibility

: Successfully developed and deployed .NET applications following all coding standards.

Created a simple, aesthetic and consistent User Interface with shortcuts, menus, forms and controls in VB.NET. Final output was presented using Crystal Reports in .NET framework using Business Objects functionalities.

Duration

08

Managing Sql Server Database for all the module : 10 Month

Technologies Used

: VB.NET / MSSql Server 2000 / Crystal Reports

Project Name

Enterprise Resource Planning System “Nolan ERP”

Customer

Nolan Softwares Inc Singapore

Organization

Sovatech Solutions Pvt. Ltd.

Description of the project Nolan-ERP is the Parent module of the program that incorporates a complete set of the tools for Supply Chain Management (SCM), ERP(Enterprise Resource Planning) including sub modules like Asset Management, Manufacturing, Re-Manufacturing Process(RMP),Account’s Collection, Cash Flow Management(CFM),Contact Manager(CM) with Juggler Program(Security),Report Manager etc. that is designed to implement automation in the Manufacturing /Non Manufacturing organization’s with heterogeneous functional area. NolanERP manages/works on the preliminary record’s and transactions like Sale/Purchasing/Invoicing/Ledger/Inventory

Team Size

: 5

Role

: Sr Software Engineer

Responsibility

: Managing the team members with proper sizing/assignment to a given module.

Analysis, Design, Development and Support for all the module’s at domain level. Involved in designing the COM component of the required modules like Inventory, Accounting, Asset classes their Form level implementation management. Design of a rule-based, multiple constraint, and finite capacity production scheduling system to efficiently manage customer’s inventory and production in Visual studio

09

Duration

: 12 Month

Technologies Used

:

Project Name

FAS (Internet Education Network) http://www.franklinsquires.net

Customer

The FranklinSquires Center of Provo, UT

Organization

Sovatech Solutions Pvt. Ltd.

VB 6.0 / MsAcces 2000 /Mysql/Sql Server 2000/98/2003/XP

Active Reports 2.0/Win

Description of the project The FranklinSquires Institute is a private organization dedicated to teaching individuals, families, and small businesses the principles and values related to prosperity economics. The Institute offers live workshops, self-paced home study courses, and live interactive webbased classes via distance learning. The primary objective of the Institute is to provide Tran formative educational experiences by actually working directly with students to realize the goals of self-reliance, economic independence, and financial freedom for themselves, their families, and their businesses.

Team Size

: 2

Role

: Team Member

Responsibility

: Fix the issues bugs that was assigned from the client

Duration

: 4 Months

Technologies Used

: ASP. Net, MS SQL Server

10

Project Name

Enterprise Resource Planning System “Business Pro”

Customer

Qweb Consulting Pty Ltd. Australia

Organization

Sovatech Solutions Pvt. Ltd.

Description of the project BPMain is the Parent module of the program that incorporates a complete set of the tools for Supply Chain Management (SCM), ERP(Enterprise Resource Planning) including sub modules like Asset Management, Manufacturing, ReManufacturing Process(RMP),Account’s Collection, Cash Flow Management(CFM),Contact Manager(CM) with Juggler Program(Security),Report Manager etc. that is designed to implement automation in the Manufacturing /Non Manufacturing organization’s with heterogeneous functional area. BpMain manages/works on the preliminary record’s and transactions like Sale/Purchasing/Invoicing/Ledger/Inventory

Team Size

: 9

Role

: Sr. Software Engineer

Responsibility

: Managing the team members with proper sizing/assignment to a

Duration

11

given module. Managing Sql Server Database for all the module Analysis, Design, Development and Support for all the module’s and incorporating the various module in the BPMain. : 6 Month

Technologies Used

: VB 6.0 / SQL SEVER 2000 / Active Reports 2.0/Win 2000

Project Name

Hospital Management System “Spandan”

Customer

Ramkrishna Care Hospital

Organization

Sovatech Solutions Pvt. Ltd.

Description of the project The project involved development of Integrated Hospital Management System comprising of patient management, Billing Management, Pharmacy, pathology, Operation theatre, bed management for the small and mid size hospitals (up to 250 beds). This was initially developed as customized application for Ramakrishna Care hospital and later upgraded to a generalized product by name “Spandan”

Team Size

: 8

Role

: SOFTWARE ENGINEER

Responsibility

: Work involves developing user-friendly interfaces, coding, testing and

Duration Technologies Used

debugging. Requirement analysis, design of algorithmic flow and E-R diagram generation. Scheduling of production stages through business processes : 6 Months

: VB 6.0 / SQL SEVER / CRYSTAL REPORTS 8.5

ACADEMIC RECORD MCTS

Pursuing

(Final Sem)

Aug. ’01 – Jan.’02 1996-1999 1998 1996

Personal Details

Permanent Address:

Dotnet Framework 2.0 Windows Application DOEACC ‘B’ level course (Equivalent to M.C.A.) from Department of Electronics, Govt. of India, New Delhi Diploma in Advanced Computing from Silverline Institute for Software Technology, Chennai with ‘A’ grade. (CDAC) Diploma in Mechanical Engg. From Govt. Polytechnic College, Dhamtari (C.G) with 74.70% Marks. Senior Sec. (12th) under Board of Secondary Education Bhopal (M.P.) with 67.11% marks. Secondary (10th) under Board of Secondary Education Bhopal (M.P.) with 74.40 % marks.

•Father’s Name •Date of Birth •Marital Status •Email •Contact No. •Nationality

:

Late H.M. Chawhan

:

1st July, 1980

:

Single

:

[email protected]

: :

9764004288 / 9370772734 Indian

MI G - 9E , C H A NA K YA PA RI SA R, DEVENDRA NAGAR, S E C T O R- 3 , R A I P U R , 4 9 2 0 0 1