Tejashwar Rao



Around 7Yrs of IT professional experience in development of various applications, web applications & Industrial automation systems under Windows 2003 .Net Server, 2000 & Unix using .NET Framework (Visual Basic. Net, ASP. Net, ADO. Net, C#. Net), Crystal Reports 10/9/8.5,ASP 3.0/2.0, Visual Basic 6.0/5.0, SQL Server 2000/7.0/6.5, Oracle 8i/7.x, COM Technologies, XML, C/C++, Java, JSP, HTML/DHTML, Java Script and XSLT.

Expertise in developing Web Top applications using VB.Net /C#and ASP. Net and Classic ASP.

Proficient in writing stored procedures, database triggers using SQL and PL/SQL.

Hands on experience on IIS 6.0/ 5.0/4.0 and MS SQL Server DTS.

Requirement Analysis, Design and Development of Internet Based Applications.

Strong experience in developing reports using Crystal Reports. Designed and developed reports using Cross Tab, Mail Label and Charts.

Expertise in designing complex design patterns, Sub Reports, Formulae.Conducted corporate trainings on Crystal Reports.

Also posses experience in modules of Data Warehousing, Data modeling tool Erwin and ETL tools Informatica, COGNOS & Business Objects.

Excellent work ethics, self-motivated, quick learner, team player, and team oriented. Continually provided value-added services to the clients through thoughtful experience, productive coding habits and excellent logical aptitude and communication skills.

Have a strong desire to learn new technologies



Education and Certification:

Masters In Computer Science

Microsoft® Certified Professional in Vb.Net



Technical Skills:



Skill Set Exp (Yrs) Skill Set Exp (Yrs)

. Net (Vb. Net, ASP. Net, C#. Net) 2 MS SQL Server 2K 7

Visual Basic 6 7 Crystal Reports 10/9/8.5 6

ASP 5 HTML, XML, XSLT, VB Script, JavaScript 5

Informatica 1 Erwin 1

OS (Win 2003/2K/XP/Nt) 7 Java, JSP, C++ 2

Oracle 8x 3 IIS 6/5 5

Visual Source Safe, InterDev 5 BOS, COGNOS, TOAD





April 2004- Till: SAPHRAN INC.

Forecasting provides answers to the critical question, “What can I do today to improve my business tomorrow and make me

Profitable in the long term?”

The Saphran PartBase Forecast Manager powered by CSM™ is a unique software solution that enables automotive

suppliers to optimize profitability by improving the process of planning, and forecasting throughout the entire life cycle of a

supplier’s product portfolio. This system allows you to quickly and seamlessly merge external market forecast data with your

Internal part and vehicle base information into one comprehensive reporting tool and simulator, producing a living and

dynamic forecast that stays viable and current.

Provides current and accurate reports to make strategic decisions about quoting, cost planning, outsourcing, capital investments, product mix, profit planning, target customers and target markets.

Enables Account Managers to track and report on all revenue and margin assumptions for current and future programs-including $ per vehicle

Create multiple “what if” simulations based on cost, price and volume relationships.

Create trending reports to constantly improve the quality of your forecast assumptions

Up-to-date reports within minutes, especially if linked to an automated costing and quoting system such as Saphran’s Costing & Quoting solution .

Output data into Excel, Access or other comparable software if desired.

Responsibilities:

Involved in software requirement analysis and design.

Designed the schema MS-SQL Server 2000.

Involved in SQL Server Administration, such as DB Back –Up, installing and configuring .Managing databases.

Involved in Forecast Management Engine Development, Report / Filter Engine Development and GUI Design.

Used MS Data Grid Control for displaying data before and after each transaction done in corresponding Webform. And also used pagination and grid events. Used ADO.Net for database transactions.

Used XMLAdapter to import and export data from XML documents

Designed & Developed web forms using ASP.Net on VS.Net IDE, and Used nUnit Framework for unit Testing and automated testing using Win Runner as per requirement

Used .Net InterOp features in development of Reporting and Filter Engine.

Designed Crystal Reports using stored procedure and views. Used sub reports and formulae for accurate data representation in reports. Used crystal reports formula editor for writing formulae as per requirement in design.

.Designed and developed reports using Cross Tab, Mail Label and Charts.

Integrated and published the reports with Crystal Enterprise, RAS, ASP.Net.

Dynamic, Multiple selection and Sort based Reports are developed by using Crystal Reports 10.

Wrote Data Base Connection Classes, Transactions Classes for Update, Delete, and Insertion.

Wrote Store Procedures, Triggers and User Defined Functions.

Wrote Client side functions in JavaScript.

Developed Result Set Export function to various formats such as Excel and word etc.



Environment: VB. Net, Asp. Net, MS-SQL Server 2000, XML, Windows 2003 Server, Crystal Reports 10, Crystal Enterprise 10.0/9.0,IIS 6,Visual Source Safe and Java Script.



Jan 2004 – Mar 2004: ENGINEERED SINTERED COMPONENTS INC.

eProMM-Adv. Server 1.10(Web Enabled) is advance version of eProMM basic system. eProMM –Adv.Server collects real time data of production floor. Stores data for monitoring, management analysis and Reports. Alerts the subscribed user about the exceptional variations in production information. Various Servers like Data Processing Server, Control Server Alerts Server, and Report Server working in tandem to enhance system performance and capabilities. Interacts with external systems for data sharing and performance comparison with business partners. Due to extranet /Intranet architecture production information can be monitor and maintained from anywhere in global. Has GMTS (Global Management Tracking System) which sends paging to responsible user or person in charge when exceptional variations occurs and escalates message in hierarchical manner in department until it receives response. Able to integrate with third party applications like ERP, MRP Systems

Responsibilities:

Involved in user requirement analysis and system design.

Designed and developed Web Forms (for Web Top Application), Win Forms (Client /Server Data Processing Module) as per requirement using VB. Net, Used MS Data Grid Control for displaying respected data before and after each transaction done in corresponding page, and also used paging, and other data Grid events.

Integrated crystal reports with Vb.Net window Application.

Developed Job Scheduler Using Vb.Net Win Application.

Used Sax Comm. control to communicate with serial ports via Vb.Net Win Application using InterOp Features

Production and managerial reports were designed and developed using Crystal Reports features like Sub Reports, formulae, and various report templates.Designed graphical reports using Crystal Report Chart feature. Designed customized report templates.

Developed GMTS (Global Management Tracking System) to escalate alerts or page messages in hierarchical manner in department until it receives response.

Designed Integrator module for integration with third party Applications like ERP (JD Edwards, Karen soft), MRP by exporting data in to XML or fat files via .Net and at the same time loading data from XML and Fat Files or Text Files.

Written common validating functions using JavaScript for Client side validations and Vb.net for server side validations.

Used nUnit Framework for unit Testing and automated testing using Winrunner as per requirement

Developed Data Access utility, which connects to SQL server Database, retrieves data into Datasets and also updates Database with Datasets. Provide transactional Support. Wrote stored procedures, Triggers, User defined functions and views



Environment: VB. Net, Asp. Net, MS-SQL Server 2000, Crystal Repots 10/9.0,Java Script, Windows 2003 .Net Server,Win Runner 7.0



June 2002 –Dec 2003 ENGINEERED SINTERED COMPONENTS INC.Troutman, North Carolina

eProMM (Electronic Production Monitoring Management System) Which is a synonym for Real time Production Management System. eProMM is designed for large scale, small and medium scale industries for their Production Monitoring. It collects real time information/data of production floor, and stores data for analysis, monitoring and reports. Various modules like Data Processing Module, Job Scheduling /Master Data Maintenance module and reports wizard working in cycle to enhance system capabilities and performance. Alerts in graphical way when variations occurs in production.

Responsibilities:

Involved in software requirement analysis and design.

Designed the schema MS-SQL Server 2000.

Designed various reports using Crystal Reports 8.5.Used charts for graphical representation of data.

Designed Crystal Reports using stored procedure and views. Used sub reports and formulae for accurate data representation in reports. Used crystal reports formula editor for writing formulae as per requirement in design.

Designed & Developed Win forms using Vb.Net on VS.Net IDE, and Used nUnit Framework for unit Testing and automated testing using Win Runner.

Used MS Comm. control to communicate with Serial Port using .Net InterOp features

Developed an interface to integrate with third party applications by Extract, Transform and Loading concept either from XML or from Text Files via .Net.

Stored Meta data in SQL Server 2000 using ADO.Net

Used MS Data Grid and Fly Tree Control for displaying of data.

Wrote Data Base Connection Classes, Transactions Classes for Update, Delete, and Insertion.

Used MS –Project & Visio for System Design and Project Planing

Created dimensions and facts in physical data model using Erwin tool.

Used Informatica Designer to create complex mappings using different transformations to

Move data to a Data Warehouse

Developed mappings in Informatica to load the data from various sources into the Data

Warehouse, using different transformations like Source Qualifier, Look up, Aggregator,

Stored Procedure, Update Strategy, Joiner, Filter.

Created repository and set up groups & users for different departments and also managed user profiles using Informatica Repository Manager.





Environment: VB. Net, MS-SQL Server 2000, Crystal Repots 8.5, Informatica Power Center 7,Basic Data Collector Serial Device, Windows XP, MS Project, Visio and Win Runner



Tool-Tracker Tool Tracker is a Web Top application to keep track of tool information, which is mainly designed for in-house intranet architecture, which keep tracks of tools (dies), life time, manufacturing details, service due date, no. Of strokes and alerts messages if due date to service is near.

Responsibilities:

Designed and Developed Web Forms as per requirement,

Used JavaScript and VB Script for validations

Integrated ASP with Crystal Report for web reports using RDC component, Crystal Report API

Developed Activex.dll for data base connection and transactional utilities using Ado.

Designed schema for MS-SQL Server.

Designed and developed required stored procedures and database triggers.

Designed an interface to read and print Barcodes of Tool information.

Designed reports, which contains formulae, and complex design patterns using Crystal Reports.

Environment: ASP, Crystal Reports 8.5, MS-SQL Server2k, VB-Script, JavaScript 1.2, IIS 5, Win 2k, and Visual Interdev.





Dec 2000–April 2002: NCS-Singapore Ltd. (Group of Singtel, Singapore)

BBDC System is developed for BBDC Systems (Bukit Batok Driving Center Ltd.) Singapore. BBDC is one of the largest and advanced driving schools in South East Asia. The BBDC (Bukit Batok Driving Center) System is implemented to replace the existing modules in the current system with a web application and also to introduce new modules to this system. The New web based BBDC system features a single point of interaction to data managed by different data sources, put in place a robust infrastructure and enhance the software application to support an expanded business operation.

Responsibilities:

As member of 20 involved in analysis, design, development, unit testing and implementation of various modules.

Designed around 75 reports, which contains sub reports, formulae, and complex design patterns using Crystal Reports.

Designed graphical reports using Crystal Reports.

Integrated Crystal Reports with Visual Basic using Crystal Reports API

Designed schema for MS-SQL Server.

Designed and developed required stored procedures and database triggers.

Developed UI with Visual Basic-6 and ASP as per requirement,

Used XML for dynamic menu items based on user privileges.

Used JavaScript for validations.

Created a printing controller (OCX component) used for printing pre-formatted reports from client web pages



Environment: VB.6, ASP, Crystal Reports 8, MS-SQL Server 2K, VB-Script, JavaScript 1.2,XML Windows NT Server.



May 1998- Nov 2000: Pac Technologies SND BHD (Malaysia)

PICA (Production Information Computerized Analysis) Which is an alternative for Manual Production Management System Customized for National Panasonic Malaysia, Clipsal Malaysia (Clipsal Australia), SUMITOMO Malaysia (SUMITOMO-Japan), and PICA is designed for all type of industries for their Production Monitoring. PICA will capture production information like Actual Good Produced and at same time it also analyze the Production information. Of various Production Lines, It uses various sensors as per requirement to capture production information and those sensors will transmit signal to DMM (Data Management Module) where the signals are processed and send to PICA.

Responsibilities:

Involved in software requirement analysis and design.

Designed the schema MS-SQL Server 2000.

Designed various reports using Crystal Reports 8

Developed UI with Visual Basic 6 and unit tested

Used DMM (Data Management Module), Advantech 1620 PCI card to capture signals from PLC and Sensors.



Environment: VB-6, MS-SQL Server 2000(Upgraded from SQL Server 7), Crystal Repots 8, Data Management Module, Windows 98



March 1997-April 1998: Pennar Group (India)

General Insurance System (GIS) is a comprehensive system with the facility to provide Fire, Motor, Marine, and Casualty Insurance. The various modules in the system are Reference Module, Security Module, Underwriting Module, Claims Module, Reinsurance Module, Treaty Module and Investment Module. High functional requirements, complex calculations, high interdependence among modules and high data volumes made the system very complex. This application is supposed to support a database of 60GB, which consists of around 600 tables 550 forms, and 450 reports.

Responsibilities:

Designed schema for Oracle 8 database.

Reports were designed and developed using Crystal reports 8.0

Designed and developed required stored procedures and database triggers.

Involved in User Requirement analysis that includes analyzing user interface design and creation.

Developed User Interface Using Visual Basic.

Developed COM components for database connection.



Environment: Visual Basic 6,Oracle 8,Crystal Reports 8.0,and Windows NT

Project Monitoring System It is an automated tool for tracking the progress of a project and submission of the daily project report. It has the ability to configure and keep track of various projects handled by the company for respective client and assigns the team members and their respective roles. The details about the starting date, deadlines and the man-hours to be spent for a particular project, module and task can be maintained. It sends alerts to the concerned person regarding the deadline at regular intervals. Using the total time spent for a particular project the time required for a similar project and the efficiency of an employee could be estimated.

Responsibilities:

As a member of 3 involved in analysis, design, developed and unit testing.

Designed and developed user interface using HTML

Used JavaScript for validation of data formats

Used Servlets to generate dynamic web pages.



Environment: JDK1.3, Servlets, JSP 1.2, MS-SQL Server 7.0, HTML 3.0, JavaScript 1.2, Java web server 2.0,Windows NT



Document Management System Enterprise-1 is an automated Document and business process management software. It offers online real-time intelligent control and monitoring business documents and processes to achieve maximum efficiency with minimum human intervention. The system will ensure that all the required data are only keyed once and that all relevant modules automatically share data. It is an Internet enabled system as well. The interface is a Digital Dashboard with outlook based. Documents can be captured by Native applications e.g. Fax, Scan and Email.

Responsibilities:

Development of Document Management System in VB6 Using the DNA Technology.

Writing Components for Four Layer Architecture and Tested in MTS environment.

Documented the Whole Scenario of Document Management System from Architecture to the front End Client level.

Implement Test Plans and Result evaluations.

Environment: Visual Basic 6,MS- SQL Server 7.0,Windows NT



Monitoring Movement System is developed to monitor the movements of employee in a company. This system provides feasibility to the employees. Main objective is the system itself has to take care of each and every employee whether he is entering into office or going out from the office. The employees can change their address as well as passwords. It also provides enquiry screen in order to know the availability of each and every employee and how many hours he is spending in the office.

Responsibilities:

Analysis, design and development of user interface screens using VB 6.0

Involved in report designing using Crystal Reports 7.0



Environment: Visual Basic 6,MS-SQL Server 7.0,Crystal Reports 7.0,and Windows NT



Material Requirement Planning System The Material Requirement Planning System Application was done for PALCO. Developed Material Requirement Planning System to keep track of material needs in an organization based on master production schedule. M.R.P System has several modules like Production, Sales, Stores, Purchase and Accounting.

Responsibilities:

Design and Development of user interface screens for the Purchase, Stores and Production

Developed reports for data representation using Crystal Reports 7.0



Environment: Visual Basic 6,MS-SQL Server 7.0,Crystal Reports 7.0,and Windows NT



Developed Direct Response Marketing Systems to maintain vendor/client information in the organization. The organization materials from vendors on regular bases .DRM System update all transactions on regular bases and generates purchase orders to vendors for request of raw material needs. DRM System also includes payroll module, maintains employee information.

Responsibilities:

Design, development, report Generation and Testing

Environment: Visual Basic 5, Oracle 7.3, and Windows NT



Reference: On request