Sandip Hatkhamkar
Cell : 732 333 1574
Email: sandiphath@rediffmail.com
7 years of software development experience involving Analysis, Design, Development and Testing of Core business applications including Client-Server and Web-based n-tier Architecture with exposure to diverse business domains that include, Web Portals, B2B site & Banking.
Strong experience in developing applications using COM, ASP.NET 2.0, C# 2.0, XML Web Services, Visual Studio. NET 2.0, ADO.NET 2.0, JavaScript, IIS, Visual Studio 6.0, HTML, CSS, XML, XSL, SQL Server , nHibernate etc.
Expertise in creating Web Forms, Win Forms, User Controls and Custom controls using C#, ASP.NET, HTML, DHTML, CSS, XML, XSL, JavaScript, Visual Studio.NET 2005.
Expertise in .Net Framework, .Net Remoting, Namespaces, Delegates, Reflection and n-tiered Applications
Solid Understanding of Web Services, SOAP, XML, WSDL, Biztalk server, NUnit, NHibernate.
Strong Experience in Agile Programming Environment that includes splitting of a complex problem into small workable solutions and creation of story cards for each small workable solution.
Expertise in Test Driven development.
Strong Experience in developing solutions using Rational Unified Process.
Involved in Full Software Development Life cycle (SDLC) process for projects.
Good understanding of Design Patterns Factory, Singleton, Builder and Provider..
Strong experience in drawing Use case diagrams, Sequence diagrams, class diagrams, object modeling and data modeling using MS Visio and Enterprise Architect.
Strong knowledge in Database Programming using RDBMS databases like SQL Server 2000/7.0. Expertise in writing Stored procedures, triggers and DTS packages.
Strong experience in unit testing automation for .NET applications using NUnit tool.
Used Version Controlling tools such as Visual Source Safe, Subversion.
Proven ability to work as a team player as well as an individual. Excellent Interpersonal and Communication skills, coupled with strong technical and problem solving capabilities.
Worked onsite for clients IBM UK, British Petroleum UK lead.
Proven effectiveness working cross teams/disciplines
Proven record of working in both small and big teams under stringent timing constraints and ability to deliver on time.
Quick learner, excellent in learning new technologies and quickly adapting to new environment
SKILLS SUMMARY:
Hardware: Dell PC, MS Workstations.
Operating Systems: Windows 95/ NT4.0/ 2000, IBM AIX v 4.3
Modeling Language: UML
Modeling Tools: MS Visio
Languages: C++, C#.NET, VB
APIs/Libs: ADO.NET, ADO, COM.
Framework: .NET framework 1.1/20
WEB Technologies: XML, XSL, HTML, Java Script, ASP.NET.
Component Technologies: COM/COM+, MTS, MSMQ
Data Bases: MS-SQL 7.0/2000/2005 Server, Oracle 8.0i., Ms Access.
Web Servers: Internet Information Server (IIS).
Version Control Tools: Microsoft Visual Source Safe, Subversion
Reporting tool Crystal report
Other Tools: Nunit v 2.8, Cruise Control .NET , Visual Studio 6.0, Visual Studio.NET, Microsoft Application Center Test, NUnit, NHibernate.
PROFESSIONAL EXPERIENCE
Client: SolutionsIQ, WA on Fidelity National Ticor Title Group website June 2006 – Till date
.NET Consultant
Description:
Working for SolutionsIQ a Washington based development company on Fidelity investments Ticor Title application website project. This website is taking care of order processing for Titles from the company’s local Title processing agents and providing the data on the internet for further business process. The application is involving five sql server databases, biztalk server, C# components and ASP.net as UI. Also ajax support is provided for dynamic processing on some .aspx pages.
Roles & responsibilitie
Following Agile development programming model.
Planning and executing each sprint meeting goals.
Understanding the requirements and converting them into application requirement documents.
Converting entire site to use ORM code for functioning.
Using nHibernate to map Objects to database and develop aspx pages to use them.
Developed automated unit tests using Nunit tool
Developed automated Acceptance Test for the entire website using STIQ tool.
Environment:
ASP.NET 2.0 with C# 2.0, .NET Web service, .NET framework 2.0, ADO.NET, IIS 5.1, SQL Server 2005, Windows 2003 server, Visual SourceSafe 6.0, Ms Visio. NUnit 2.2.7, nHibernate, Biztalk server 2004.
Client – Dow Corning Corp., Midland, Michigan. Nov 2005 –May 2006
.NET Consultant
Description:
Worked for Dow corning corp. for constructing a web based application for Analytical Science laboratory to keep track of analytical inquiries for chemical samples, inquiry progress, invoicing, and SAP integration of the application. The application is an intranet application, which is loosely coupled with the SAP for the Global customer database.
Modules:
Manage Customers : Create, Update Customers for Dow Corning Analytical labs.
Manage Customer Inquiries. Log customer inquiries for sample testing involving details such as samples send, samples send date, samples received, price quote estimate, final price for service, discount etc.
Track Inquiries. Customer inquiries go through a 8 steps business process which is manually updated within the system by chemist at the labs and also the marketing team till final delivery and invoice.
Email Communication. Emails are generated at specific stages of the system to keep teams involved, customers of the progress of their inquiries.
Invoice Reports. At the end of the cycle soft copy invoicec is generated and send to billing and dispatch department.
Summary reports: Summary reports are generated using the system for higher management for monthly, /quarterly sales, total number of inquiries serviced, turn around time etc.
Roles & responsibilities:
Worked at a capacity of onsite project lead.
Worked on gathering requirements from business users.
Interacting Business managers for the project status reporting and meetings.
Understanding the requirements and converting them into application requirement documents.
Prepared technical specification documents.
Prepared wire frame diagrams for the entire application in scope.
Constructed Application architecture, use cases, class diagrams and sequence diagrams.
Assisted DBA in designing RDBMS for the application based on the business requirements.
Resource scheduling and off shoring tasks, tracking task progress and offshore communication.
Constructed SQL stored procedures, SQL queries.
Coding C# classes and ASP web forms for the application.
Unit testing using Nunit tool.
Environment:
ASP.NET with C#, .NET Web service, .NET framework 1.1, ADO.NET, Sap.NET, IIS 5.1, SQL Server 2000, Windows 2003 server, Visual SourceSafe 6.0, Ms Visio. NUnit 2.2.7
Client – Data-Core Systems Inc, USA Jun 2005 – Oct 2005
Software Consultant – CT Corporation Systems Inc, New York
Worked for CT corp., New York on the data linkage project, which involved integrating CT website with the third parties/client applications with the help of data transformation in XML format for the purpose of Annual report e-filing to the state. With the release of the new functionality third parties can push data for Annual report e-filing to CT corp website and reuse the data after successful login to the site. Thus the third party users save time on feeding the data manually on the website and navigate to the order fulfilment and pay order.
Modules:
XML schema for third party integration: Agent application can send XML data post to CT connection as HTTP secured post. .For this purpose a well defined XML schema document was required based on the mutual data structure agreement between CT connection and its agents. Agents send two types of XML data XML schema based document and other DTD based documents.
XML Receiver class library:
A C# class library developed to receive and process the agent data validate with the respect to schema and put it into oracle after validating and applying business rules.
Role, duties, responsibilities:
Worked on designing and finalizing the XML document schema to enable third party agents of CT Corp to send data to the website.
Developed Class/Sequence diagrams to implement the interface.
Developed C# class library to process the data post from website agent applications.
Environment: ASP.NET with C#, .NET framework 1.1 , ADO.NET, IIS 6.0, XML, XSD, DTD, Oracle 9i, Windows 2000 server, Visual Studio 2003, Visual SourceSafe 6.0.
Melstar Information Technologies Ltd March 2003 – March 2005
Software Engineer- IBM (UK)-BP (UK) Offshore Project Team
Worked with IBM UK to Develop and support array of applications for British Petroleum UK and to support off shoring activities. Have developed and deployed applications, also lead team of IT professionals for supporting other applications from offshore. The project involved developing an application British Petroleum for their Western
Hemisphere Property legal dispute management and tracking also BP brand policy violation legal suites information management on web. Supporting other .net & asp application from offshore.
Role, duties, responsibilities:
Project Management activities like Requirement gathering and analysis,
Supported critical financial application from onsite & offshore.
Planning, Estimations preparations, Team building and driving, user Co-ordinations, etc.
Involvement in technical design makings like database designing and framework, etc.
Helping the team in debugging and testing the applications.
Environment: ASP.NET with C#, ADO.NET, IIS 6.0, ASP, COM, SQL Server 7.0/2000, Windows 2000, Visual SourceSafe 6.0 & third party components.
Employer: Graceworks Technologies Pvt. Ltd. June 2001 – Feb 2003
Software engineer
Worked on a range of projects including Information management system, CRM, Banking web application and Billing application. Developed few applications for overseas clients and have experience in customer communication.
Information Management System
This is a comprehensive end-to-end Information Management System, which adds value to information that already exists in an organization. It enables organizations to aggregate that information into a central location to be shared by the staff of the organization on a need-to-know basis. It has data synchronization sub system which is used to keep the data in sync with the front office system and the website.
The system is divided into following layers of modules-
Core Modules
Employees
Contacts
Projects
Document Management
Organization Structure
Layer One Modules
Opportunity Management
Sales Reporting
Visit Reports
Time Sheets
Layer Two Modules-
Expense
Leave
Training and Seminar
Appraisals
Environment:
VBScript, Javascript, ASP, ADO, SQL server 7.0 , windows 2000, XML., COM, Visual Studio 6.0, MS Visio.
Client:
www.kokanbank.com, Kokan Mercantile Co-Op bank.
The www.kokanbank.com is authorized website of Kokan Mercantile Co-Op Bank, the objective behind building the website is to provide customers of kokan bank with eBanking services. It is a robust ebanking application website categorized mainly into two sections
Bank Description
eBanking application
Bank Description :
This section contains information about products & services offered by bank to the customers. This is the static section containing HTML pages.
eBanking application:
eBanknig is an ASP application. It brings your account access at a click of a mouse. It is divided into following sections
Transacting to account
Website administration
Data synchronization
Environment:
ASP, VB, Sql server 2000, windows 2000, XML, COM+, IIS 5.0, HTML 4.0, JavaScript 5.0, VBScript 5.0,
Visual Studio 6.0, Visual Source Safe 6.0.
www.globetalk-int.co.uk
GlobeTalk international provides its customers and several other clients with telephone and mobile services. The project is aimed at building an web enabled application for the company which will allow its entire customer base to interact with the application. Work included collecting billing details into central database and making the details available to the customers so that a customer can check his billing and other information at his will. Also make the payment online for bills. The application should also generate bills on request and send to customer’s email address.
Role, duties, responsibilities:
Requirement understanding and analysis
Database designing.
Reviewing of code and maintaining logs.
UAT implementation & deployment.
Environment:
VB 6.0, ASP, IIS 6.0, COM+, IIS, HTML 4.0, JavaScript 5.0, VBScript 5.0, SQL Server 7.0, Visual Studio 6.0, Visual Source Safe 6.0.
www.GlobalR2R.com , B2B Recruitment website Oct 2000 – May 2001
Web Developer
This project was developing a B2B online recruitment website application. The GlobalR2R which mean global recruiter to another recruiter network, using this website a recruiter can search for candidates through out the website database, communicate with the candidate, fix up meetings with the candidate, also send the candidate to an interview with an employer. Any employer can use the services offered by the website. Individual candidates can post their resumes on this website. Recruiters can also post their resume database on the website so that it is shared among the other recruiters. If an employer selects a candidate belonging to a recruiter then the fees payments are done online by the employer and the recruiter will receive the payments.
Role, duties, responsibilities:
Client interaction for requirement gathering.
Flow of the site, Database Design & Management
Code development and testing.
Client side Installation and deployment of the site.
Environment:
VB 6.0, ASP 3.0, COM+, IIS 5.0, HTML 4.0, JavaScript 5.0, VBScript 5.0, SQL Server 7.0, Visual Studio 6.0, Visual Source Safe 6.0.
Online Contesting web portal www.contest2win.com, April 99 – Oct 2000
The project involved setting up a Contest data acquisition system using Microsoft Technology. It was a B2C website. The website works in way where an ordinary user registers on this website and gets a login id and password. After his registration is successfully done he can use his login & password to play any of the contests that are online. Every contest has its own database format where the all user entries will be collected. The credit point system collects points for every contest played by the user. The user can redeem points earned for specific gifts showcased on the website. The website has winner hosting system with the help of which winners of a contests are listed on the contest page.
Role, duties, responsibilities:
Client interaction for requirement gathering.
Design flow of the site and database and management
Handling, guiding the team to successfully code the project.
Integrate payment gateway of secure server.
Web hosting and management
Environment:
VB 6.0, ASP, COM+, IIS 4.0, HTML 4.0, JavaScript 5.0, VBScript 5.0, SQL Server 7.0, Visual Studio 6.0, Visual Source Safe 6.0.
Educational Qualification:
Diploma in Oracle Specialist Professional from Gebbs institute of Computer Education
Advance Diploma in Software Engineering from Aptech Computer Education.
Bsc in Statistics from Mumbai University, India.
Professional Qualification:
Microsoft certified professional in Developing & Implementing Web Applications using Microsoft C#. NET
Microsoft certified professional in Developing & Implementing Web Service applications using Microsoft C#. NET
Microsoft certified professional in SQL server 7.0
Brain Bench Certified for Active Server pages 2.0.