Magesh Gurunathan E-mail:
[email protected] Phone: 732-762-2540
Experience Summary Around 6 years of Experience in full life cycle development involving documentation, development, deployment, testing, implementation & maintenance of application software in Web-based environment and Client/Server architecture
Over 5+ Yrs of Experience in developing Microsoft Technologies.
Over 3Yrs of Experience in developing web-based applications with JavaScript, VBScript, HTML, IIS, and MTS.
Over 5Yrs of Experience in Data Base Technologies with Microsoft SQL Server and MS Access.
Over 1 Yr in development of the software applications using Visual Basic, Active-X, ODBC and ADO / RDO/ DAO to communicate with the database.
Experienced with XML related technologies such as XML, XSLT and XML Web Services. Have excellent analytical, problem solving, communication and interpersonal skills.
Over 5Yrs of Experience in Microsoft .NET Platform Technologies in both Web & Windows Forms using ASP.NET, ADO.NET, VB.NET, C#, Web Services, XML/XSLT and SOAP.
EDUCATION B.E. (Computer Science & Engineering) from University of Madras. Software Exposure:Skill Type Tools/Others DATABASE
Skill Name Visual Studio .Net MS SQL Server 2000/7
Proficiency Good Good
LANGUAGE
Good
Operating Systems
C/C++, Visual Basic 6.0, ASP.NET, C#, VB.NET Windows 2000/XP/NT/98
Methodologies Application Servers
UML 1.2 COM, COM +, IIS 5.0, MTS
Good Good
Web Technologies
VB Script, Java Script, XML
Good
Good
Projects:(In chronological Order) Used Microsoft Visual SourceSafe (VSS) for our project security, using VSS gives us a lot of options to store files, documents and projects with various security and sharing features. While SourceSafe gives us access to the projects and files, the VSS admin gives us option not only to impose restriction on specified users but allows us to take and restore archives of various projects stored in VSS.
Project #1 March 05-till date Project Title Workflow)
: Claims Processing System using OCR Development (Double Pass
Team Size
:5
Sherpa Business Solutions, Inc. Troy, Michigan
Profile: Claims Processing System is fully scalable, workflow based web application. Workflow is set of processes which will run in a sequential order. Set of claims are clubbed into a Batch and processed via the workflow to get the data from the claims. Each claim can be processed through each process only once. Initially, each claim is processed in an OCR Engine which is provided by Neurascript, a third party tool. Templates are designed and configured for capturing data from the claims. A batch can be processed in a process only if it completes its preceding processes in the workflow. The processes are classified into Electronic Inventory, Transfer, In-House Upload, Document Classification, OCRPreProcess, Recognition, OCRPostProcess, Claim Correction, Claim Key, Claim Compare, Post Correction, Completion1, Completion2, Audit Key, Audit Compare, Audit Review, Export, Post-Split, IHOutput, and Ship Build. Each Process is used to capture data, validate data and ensures that the correct data is captured. The data captured at each process is written in xml files and finally the data in the xml file is converted into customer specific format and transferred to the customer. Roles and Responsibilities: Software Consultant • •
• • •
Involved in Analysis of Claims and identifying a pattern for designing the Templates. Designing Recognition Templates for OCR Engine using Third Party Software. Designing and Development of Recognition Filter module for handling OCR data and performing validations on data for presenting them to the next process Correction. Used Form and Role based Authentication as a .NET Security. Development of a module which will separate the claims coming to the US Ftp server.
• •
Developed business layer components using C#.
•
XML was used as configuration profile for each process in the workflow. Developed the Business Logic layer as per the requirement. Involved in coding the application. Testing and debugging the application.
• • •
Development of ClaimCompare process which is used to compare the output files of Claim Correction and Claim Key process. The Claim Compare compares the data of both the process and will push to next queue if no mismatches found else will push to Claim Correction and Claim Key until there is no mismatches.
Environment: Windows 2000/XP/2003, ASP.Net, IIS, C#, VB.Net and MS SQL Server 2000. Project #2 April 2004 – February 2005.
Project title Team size
: :
Automation of Mortgage Company 10 Celine Mortgage Company, Santa Clara, CA
Profile: Loan Originating System – The primary intention of the product is to automate the Mortgage Company. This product contains several modules. The Product mainly contains two Modules. 1.
LOS (Loan Originating System)
2.
LX (Lending X Change)
In LOS a Loan Transaction Number will be created through Call Center for the Loan to be processed. Once the Loan Transaction Number is created then we logon to LOS to close and Fund the Loan. There are several stages that must be satisfied to close and fund a loan. For Example the Subject Property Information, Borrower Information and Credit Run of the Borrower are necessary for the transaction of the loan and also involved in all the modules mentioned below. Call Center, Property, Liabilities, Borrower, Loan Work Space Income and Loan Status, Closing Details Property: This is one of the 125 modules in Loan Originating System. The Objective of this module is to handle all the properties of primary borrower, co-borrower &other borrowers. There are mainly 3 types of properties are handled here, Subject property, Real estate property & Rental property. Subject property is the property in which borrower is going to take loan. Real estate property is the other properties of the borrower. Rental property is the rental property of the borrower. One of the advantages of this module is separate handling of property information and property financial information and we can attach the property to the corresponding liability. This module is highly integrated with Borrower, Liability, and Loan Workspace. Roles/Responsibilities: Software Consultant • Involved in the development of design artifacts such as class, activity, State, and sequence diagrams. • Implemented Data Access Layer components using ADO.NET techniques • Designed and developed the rich user interface using ASP.Net. • Implemented the form and Application level Security. • Designed and developed rich User interfaces. • Designed and developed user controls.
• • •
Developed business layer components using C#. Created Tables, Views and Stored Procedures in MS SQL Server 2000. XML was used for data transfer between the Application, Client and Server
Environment:
Windows 2000, ASP.Net, C#, IIS and MS SQL Server 2000.
Project #3 April 2003-April 2004 Project Title
:
Team Size
:
Profile:
powerway.com (Version 3.0) Indianapolis, IN 8
Powerway.com is designed for Mercedes Benz and GM Motors to accelerate product delivery reduce risks and costs and improve quality by connecting people, processes, documents and data within the enterprise and throughout the supply chain. This website is used to connect manufacturers — both internally and within supply networks — to critical information about products and processes, enabling visibility and communication from concept and design through engineering, sourcing, and manufacturing. This application developed using C#, VB.NET, ASP.NET and MS SQL Server 2000.incorporates their client needs and enhances the features provided by version 2 to better manage their suppliers and the production process with less paper-work. With a large database of suppliers of various parts managed by Power way, the automakers can browse the database to find out who can meet their requirement exactly and create trading relationships with that supplier. Suppliers on the other hand can respond to the client needs and expands the use of this software by managing their own supplier and creating a network of companies to do business. Each company (called PDO here) can manage their tasks, meeting discussions, questions, documents calendar, issues, e-mail alerts and so forth using powerway.com. Two parties can agree upon the responsibilities of either end and certain progress of the process and update the status at their respective ends so the other can also respond.
Role/Responsibilities: Software Consultant • •
Installed and configured the VS.NET environment. Developed the rich GUI using C# as code behind language.
•
Used Form and Role based Authentication as a .NET Security. Designed and developed base classes in C#.
• •
Developed custom validation controls to validate the client side data.
•
Wrote complex Stored Procedures, views and Triggers in MS SQL Server 2000. Built and implemented the application at both production and development servers. Extensive use of ADO.net Datasets, Data Adapter, Data Reader and XML to retrieve and store the data in the SQL DB. Involved in Production Support.
•
• • • •
Implemented Data Access Layer using ADO.NET techniques. Used .NET web setup project to make deployment project.
Environment:
Windows 2000, C#, ASP.NET, VB.NET, IIS and MS SQL Server 2000.
Project #4 Oct ’02 – April ’03. Project Title Team Size Profile:
: :
Financial Information Management System 5 Dept of Corporations, Financial Services division, State of California, CA
This application automates responsibilities of Department of corporations; financial services division of State Of California Govt. DOC FSD is responsible for licensing, monitoring and regulatory enforcement of financial sector entities. This is an intranetbased application developed in completely VS.net environment and MS SQL Server 2000 was used as database for this application. Role/Responsibilities: Software Consultant. • Installed and configured the VS.NET environment. • Developed the rich GUI using C# as code behind language.
•
Used Form and Role based Authentication as a .NET Security. Designed and developed base classes in C#.
• • •
Developed custom validation controls to validate the client side data.
•
• •
Implemented Data Access Layer using ADO.NET techniques. Wrote complex Stored Procedures, views and Triggers in MS SQL Server 2000. Built and implemented the application at both production and development servers. Extensive use of ADO.net Datasets, Data Adapter, Data Reader and XML to retrieve and store the data in the SQL DB.
Environment: Windows 2000, ASP.NET, VB.NET, C#, IIS and MS Sql Server 2000. Project #5 Mar ’02 – Sep ’02. Project Title Team Size
: :
Enterprise Resource Planning – Materials Module. 5 SunSmart Technologies Pvt., Ltd., India.
Profile: Materials Module is a fully scalable, 100% web based Enterprise Solution with integrated modules like Sales Distribution, Purchase, Production Planning, Financial Accounting, HR & Training etc. The solution facilitates company’s wide integrated information systems covering all functional areas. It performs core corporate activities and increases customer service there by augmenting corporate image. It organizes and optimizes data input and output methodologies systematically and it follows discipline across the functions. Request for Quotation (RFQ), Quotation Negotiation Charges, Maintenance of Purchase Order and Purchase Returns, Pending Purchase, Gatekeeper entry, in stores Quality control maintenance, Item requisitions, Inventory maintenance, Material swapping between factories. Role/Responsibilities: Software Consultant. • Installed and configured the VS.NET environment.
• •
Used Form and Role based Authentication as a .NET Security.
• • •
Using ADO.NET data access component in the middle tier for database connectivity and data transaction. Developed the Business Logic layer as per the requirement. Involved in coding the application
•
Testing and debugging the application.
•
Designed and developed base classes in C#. Involved in designing the interface
Environment: Windows 2000, ASP.NET, C#, IIS and MS Sql Server 2000. Project #6 Jul ‘01 – Feb ’02. Project Title Team Size Profile:
: :
Enterprise Resource Planning – Production Module. 5 SunSmart Technologies Pvt., Ltd., India.
Production Module is a fully scalable, 100% web based Enterprise Solution with integrated modules like Inventory control, Sales Distribution, Purchase, Financial Accounting, HR & Training etc. The solution facilitates company’s wide integrated information systems covering all functional areas. It performs core corporate activities and increases customer service there by augmenting corporate image. It organizes and optimizes data input and output methodologies systematically and it follows discipline across the functions. Bill of materials, Production Budget, Spares Replacement history, Quality Inspection plan, Product Inquiries, Vendor rating, Tools maintenance history, Machine break-down records, AMC records of various machinery Role/Responsibilities: Software Consultant.
• • • • • • •
Involved in designing the interface. Used Form and Role based Authentication as a .NET Security. Designed and developed base classes in C#. Using ADO.NET data access component in the middle tier for database connectivity and data transaction. Developed the Business Logic layer as per the requirement. Involved in coding the application Testing and Debugging the application
Environment: Windows 2000, ASP.NET, C#, IIS and MS Sql Server 2000. Project #7 Sep ’00 – Jun ’01. Project Title (DAIS) Team Size
:
Dept store automation and Inventory control system
:
5 SunSmart Technologies Pvt., Ltd., India.
Profile: A market data analysis tool; DAIS Telemarketing, a tool to capture customer and product information during a telemarketing call; and Applicant, a tool to maintain resume of applicants seeking jobs through a staffing company. Developed prototypes, user interfaces, stored procedures, unit and functional test cases. Responsibilities: • Developed software requirements specifications •
Performed Function Point Analysis
•
Prototype development
•
Designed and developed the user interface, stored procedure and triggers
•
Visited the client site for implementation and maintenance of web portal advertisement
Environment: Visual Studio, Visual Basic 6.0, MS SQL Server 2000.