.Net - SQL Developer
Resume:
Harshit Thakkar
Email: *****.*****@*****.***
Ph: 1-518-***-****
ASP.NET • WinForms • .Net Framework • Web Services • WCF • AJAX • Remoting ADO.Net • VB.Net • C# • Visual Basic • JavaScript • HTML • DHTML • XML • SQL Server T-SQL • SSIS • SSRS • MS-Access • Crystal Reports • MS VISIO • Rational Rose • Visual Source Safe • Design Patterns • Application Blocks • SCRUM
8 years of experience in Requirement Gathering, Data Modeling, Database Design & Development, Coding, Component Design & Development, Report Design & Development, UI Design & Development and Unit level Testing.
Strong hands-on experience in .net technologies & languages like VB.NET, C#.NET, ASP.NET, ADO.NET, Web Services, Remoting & WinForms. Experience in Web-based, Client-server, Multi-tier & Data warehousing applications development. Experience in Product based & Client based applications development.
Experience & very good understanding in Data Modeling using MS Visio. Experience & very good understanding in Database Designing & Database Programming (T-SQL, Stored Procedures, Triggers, Indexes etc.) using SQL Server 7.0/2000/2005.
Excellent team and communication skills.
Clients: Infocrossing (Wipro company) • ESP LLC • NYSERDA • Satyam Computers
Domains: ERP • Workflow • Time Management • Inventory • Education • State
Software • Help Desk • Data warehousing
Technical Summary:
Technologies : .Net Framework, ASP.NET 1.1/2.0/3.0, WinForms,
ADO.NET, Web Services, Remoting, AJAX
Programming Languages : VB.Net, C#.Net, Visual Basic 6.0, VBA, T-SQL
Scripting Languages : HTML, DHTML, JavaScript, XML
Databases : SQL Server 7.0/2000/2005, MS Access
Reporting Tools : Crystal Reports 9.0, SSRS
Designing Tools : MS Visio, Rational Rose
Version Control Tools : Visual Source Safe
Operating Systems : MS Windows 95, 98, 2000, 2003, XP
Others : Design Patterns, Application Blocks (Exception
Handling), SSIS, SCRUM
Experience Details:
Infocrossing[Wipro], Broomfield, CO .net Developer Dec ’08 – Feb ’09
GDM: As a part of GDM project I was involved in merging multiple Helpdesks & Ticketing systems into one database and provide a common set of tables. These tables are then targeted by different reports rather than accessing data from multiple sources.
I was responsible for:
• Understanding multiple source ticketing systems like iDesk & ServiceDesk
• Creating a super set database which can be used to store data from multiple sources
• Creating Data Dictionary to define mappings of multiple source columns with super set database columns
• Defining data transformation rules and logic for different sources
• Creating database objects like tables & Stored Procedures using T-SQL in SQL SERVER 2005
• Creating & modifying SSIS packages for data transformations
• Creating & Scheduling Jobs to execute SSIS packages
• Writing Stored Procedures for Reports
• Generating Crystal Reports.
Environment: .net Framework, VB.Net, SQL Server 2005, SSIS, ADO.Net, T-SQL,
Crystal Reports XI
ESP, Albany, NY Sr. Developer Feb ’08 – Aug ‘08
Student Tracking And Reporting System (STARS, Albany, NY): Developed for ESP, LLC. ESP’s Student Tracking and Reporting System (STARS) is an automated, component-based management information system for School Districts’ Special Education programs. Moreover, because it automates each School District’s existing forms, STARS does not require staff to learn any new terminology - and/or to change any of their current processes and procedures.
I had worked on Individual Education Plan, Service Delivery Logs & Plan-of-care and Compliance components.
I was responsible for:
• Creating database objects like tables & Stored Procedures using T-SQL in SQL SERVER 2005
• Creating data access layer to communicate with the database using ADO.NET, which involves the usage of DataAdapter, Dataset, Command & Connection objects
• Creating Business classes to implement business rules
• Designing Web Forms using ASP.NET
• Writing code for Web Forms using C#.Net
• Unit level testing
Environment: C#.Net, ASP.NET, ADO.Net, SQL Server 2005
NYSERDA, Albany, NY Sr. Developer May ’07 – Jan ‘08
Satyam Computers
www.nyserda.org
IT Service Desk: This intranet application was developed to provide solution for problems related to Network & Services for companies. Users located at different locations can raise tickets for different problems. There are different categories of problems like Software Installation & Removal, Data Access, Internet access, Login problems and hardware problems. Tickets are sent to a centralized help desk. N & S executives are then allocated tickets and they solve problems.
I was responsible for:
• Creating data model diagrams
• Creating database objects like tables, Stored Procedures, Constraints etc. using T-SQL in SQL SERVER 2000
• Creating interfaces to communicate with the database using ADO.NET, which involves the usage of DataAdapter, Dataset, Command & Connection objects
• Creating Business classes to implement business rules using VB.Net
• Creating Ticket Generation component and integrating it with the other modules of the application
• Creating Ticket Allocation component and integrating it with Mail Manager Component
• Designing and generating web forms using ASP.Net
• Designing and creating Master Pages and using them as a layout template for other web pages
• Designing and deploying Web forms onto IIS
• Unit level testing
• Integration of modules with other modules of the application
• Doing client interaction on phone or in person for requirement gathering and for module presentations
• Upgrade and enhancements
Environment: VB.Net, ASP.NET 2.0, ADO.Net, SQL Server
Satyam Sr. Developer Jul-‘06 – Apr ‘07
eLearning: eLearning is an intranet site and was developed for the Satyam Learning Center(SLC). SLC is a unit of the company, mainly involved into the training and education of the associates of the company. The goal to develop this application was to provide a workspace where company associates across the locations can put and share their educational data, ideas and thoughts.
There are different users who can register themselves and start using the application. Users can upload their data for later use. These data can be shared with other users also. Users can send data to other users through email. They can mark data as their favorites. There are Admin users in the system that can restrict the data on the basis of type of content in it. They can block/unblock any user or file. Data can be categorized for different categories. Emails are sent automatically to users when new files are uploaded into the system. Other user related functionalities like Edit Profile, Forgot Password etc. are there.
Users can also share their ideas on different subjects. Other users can reply or comment on that.
I was responsible for:
• Creating database objects like tables & Stored Procedures using T-SQL in SQL SERVER 2005
• Creating Business classes to implement business rules
• Creating & implementing Interface for business classes
• Creating interfaces to communicate with the database using ADO.NET. which, involves the usage of DataAdapter, Dataset, Command & Connection objects
• Designing Web Forms using ASP.NET
• Writing code for Web Forms using C#
• Upgrades and enhancements as requested by the client
• Unit level testing
Environment: .net Framework 2.0, C#.Net, ASP.NET 2.0, ADO.Net, SQL Server 2005
SDSPL (www.sdindia.com) Developer Mar ’03 – Jun ‘06
Over the last thirty five years, over hundred small and large organizations in the private and public sector have been provided software packages, implementation and data processing services and project consultancy by Systems Dynamics.
Today SD provides ready made, and customizable, enterprise wide business applications suite and knowledge management with business process and workflow modeling packages that could be used across all industries and government organizations. These programs can be offered both as server (at premises) license and in SaaS (Software as a Service) subscription model.
SD runs an ITeS in the domain of human expertise mapping and people matching, which are based on a sophisticated program, developed in-house with unique capabilities of high precision profiling and automated matching. This program is offered along with support of a client service executive to large recruiters.
SDBS: This Application is very generalized and web-enabled system. It is ERP kind of product that is designed and created from the scratch. SDBS is a complete comprehensive, enterprise level, and business automation application. It provides easy yet powerful tools to cater the needs of Small, Medium to Larger businesses, which can operate from multiple geographical remote locations but with centralized database. It enhances productiveness / efficiencies of the organizations with its innovative tools. This system is designed for one or more Licensees. Each Licensee can have one or more group of companies. And each group can have n number of companies (in the form of hierarchy). This provides the flexibility of operations for the people associated at all levels, from higher level to lower level. Operations can be viewed or summed up at any level, e.g. at department (the lowest unit) level, at company level, at group of company level & at licensee (the highest unit) level. The system has many powerful features & tools to efficiently store the data and to present the data. (1) Pick list with dynamic data selection, search and sort options (2) Standardized data access methods. (3) Abstract template to enhance any user interface. (3) Open ended hierarchical data models. E.g. Process model. (4) Security engine to enforce security on Users.
SDBS contains many modules, which includes Financial Accounting System (FAS), Inventory Management System (IMS), Payroll, Purchase, Sales, Workflow, TIME, Sales Force Automation, Fixed Assets & Depreciation (FAD) and Security.
My roles and responsibilities include:
• Holding end-to-end responsibilities in Purchase, Workflow, Image Processing, Sales(partly) & TIME modules
• Involved in full life cycle of all aforesaid modules
• Creating data model diagrams using MS Visio
• Creating database objects like tables, Stored Procedures, Constraints etc. using T-SQL in SQL SERVER 2000
• Creating interfaces to communicate with the database using ADO.NET. which, involves the usage of DataAdapter, Dataset, Command & Connection objects
• Creating Web Services to provide web enabled access to database
• Hosting Web Services onto IIS
• Creating Business classes to implement business rules
• Designing and integrating UI WinForms with the business classes
• Designing and deploying Web forms onto IIS
• Designing various reports using Crystal Reports. Also writing report queries in the database
• Unit level testing
• Integration of modules with other modules of the application
• Creating and maintaining Pick List user control. It was a generalized control and can be used into any form. It has features like dynamic column selection, search criteria specification and sort order selection
• Creating and maintaining Error handling component. It was a component to handle all type of exceptions throughout the application. It was used at all tiers of the application
• Doing client interaction on phone or in person for requirement gathering and for module presentations
• Upgrades and enhancements as suggested
Environment: .net Framework 1.1, VB.Net, ASP.NET 1.1, ADO.Net, Web Services, SQL Server 2000, Crystal Reports 9.0, MS Visio, Visual Source Safe
SDSPL Developer Jul ‘02 - Feb-‘03
Ensamble: Ensemble comprises of several components, which work in concert. These components belong to diverse disciplines - Process/Project management, HR management, Knowledge and Media assets management, Workflow and intelligent communications. It aims to integrate and anchor all media objects in a business model that is created and managed by the CEO/top management - coupled with this it provides an intelligent & enriched messaging system for everyone.
I was responsible for:
• Involved in full life cycle of the application
• Creating data model diagrams using MS Visio
• Creating database objects like tables, Stored Procedures, Constraints etc. using T-SQL in SQL SERVER 2000
• Creating interfaces to communicate with the database using ADO.NET. which involves the usage of DataAdapter, Dataset, Command & Connection objects
• Creating Business classes to implement business rules
• Designing and integrating UI WinForms with the business classes
• Unit level testing
Environment: .net Framework 1.1, VB.Net, ADO.Net, SQL Server 2000, MS Visio, Visual Source Safe
Icon Computer Services Developer Jul-’01 – Jun ‘02
Icon Computer Services is a service based company located in the state of Gujarat, India. It provides application development solutions for small scaled companies. Its clientele mainly includes domestic clients. I was involved into the following projects during the period of my service in the company.
Data Grid Component: This component was developed to represent the data into the tabular grid form. We can represent as well as save the Data. User can Add, Edit and Delete the records through this Control. Filter and sort facilities were also there. This control was also able to enforce all kinds of data integrity and constraints defined into the Database.
Was responsible for:
• Create grid view UI for the component
• Tracing multiple user events and using them to enforce different constraints.
• Doing data retrieval and data updation through ADO.
• Testing the constraints defined by the user for different data types
• Interacting with database by using different objects of SQL DMO library
Environment: Visual Basic 6.0, SQL Server, SQL DMO Library
Icon Computer Services Developer Oct ’00 – Jun ‘01
Insurance 2001: This project was designed for General Insurance Agency. This Software can manage the Customers’ information, Insurance product information, Policy information, sub agents’ information and their policy information, generation of renewing policies and cashbook. Software can also generate all kind of Reports & Queries.
Was responsible for:
• Collecting information from the client by having a series of meetings. It also involves study of different documents.
• Designing database in Access.
• Doing data retrieval and data updating through ADO.
• Designing windows forms using Visual basic and connect them with the database.
Environment: Visual Basic 6.0, MS Access 97
Icon Computer Services Developer Jan ’00 – Sep ‘00
Portfolio Management: This project was for an Investment Consultant Firm. Which has many customers and they invest their money through this Firm. The Firm has to manage all the portfolios for its customers.
Was responsible for:
• Requirement gathering from the client by doing meetings
• Designing database in FoxPro
• Designing UI screens in FoxPro
• Doing thorough testing to make the application error free
Environment: FoxPro 2.6
Icon Computer Services Developer May ’99 – Dec ‘99
Billing & Stock Maintenance: This project was designed to maintain the Stock and to create Bills for a Retail Shop. It was also able to maintain Customer & Stock Items information.
My roles and responsibilities include:
• Requirement gathering from the client by doing meetings
• Designing database in FoxPro
• Designing UI screens in FoxPro
• Doing thorough testing to make the application error free
Environment: FoxPro 2.6
Education
Master of Computer Application (MCA)
Contact this candidate