Summary

●      A Result Oriented Professional with 5+ Years of Experience with Microsoft .Net Technologies and Microsoft SQL Server 2000/2005/2008 in Software Design, Development, Testing and Implementation of Web Technologies /Win Forms/Client Server Technology.

●      Expertise in handling a diverse range of operations with Microsoft .Net Technology as well Database Design, Development and Administration (ASP.NET,C#,VB.NET [.NET Framework 1.1/2.0/3.0/3.5] , SQL SERVER 2000/2005/2008)

●      A Microsoft Certified Technology Specialist : Web, Windows SharePoint Services 3.0 - Configuration

●      Extensive experience in full life cycle of Software Development including Requirement analysis, Design, Coding using Object Oriented Programming Concepts with Microsoft .Net as well as Deployment and Testing of end-to-end business solutions.

●      Experience with Windows Presentation Foundation (WPF), Windows Communication Foundation (WCF).

●      Extensively made use of Design Patterns such as Abstract factory, Singleton, MVP and Data Transfer Objects.

●      Expertise in Web Services and other technologies like SOAP, XPATH, XHTML, XML, XSL and XSLT.

●      Experience in Installation, Upgrade and configuration of MS SQL Server database.

●      Good command over Database Programming (TSQL) like writing complex stored procedures, views, functions and triggers for data consistency and manipulation.

●      Expertise in Database Performance Tuning and Query optimization and experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

●      Experience in Microsoft SQL Server Database Administration including planning, implementing, backup, and recovery strategies.

●      Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization.

●      Hands on to with SharePoint object Model, Web Parts and Event Receivers and Design the Site structure of a site collection optimized navigation and security configuration.

●      Design and Development of SharePoint 2007 (MOSS) Articles Management Solution.

●      Worked with SharePoint Services for Navigating a SharePoint Site, Creating and Managing Sites and Libraries.

●      Good understanding of network and software security risks and hence well aware of strategies and techniques for building secure applications.

●      Good knowledge of Networks, Network configuration (LAN/Wi-Fi), security mechanisms, various Internet Protocols and Experience with Socket Programming using WinSock and .Net libraries.

●      Good Experience with UML standards and hands on experience in preparing Use Case Diagrams, Class Diagrams, Sequence Diagrams and Activity Diagrams.

●      Experience with Source Code Management, Code Documentation, Application Documentation, and User Guide and User Training Manuals preparation process.

●      Knowledge of designer tools including MS Visio.

●      Good Experience in designing, deploying and managing reports in SSRS.

●      Experience with working in Multi threaded environment.

●      Experience with doing Search Engine Optimization (SEO) of websites.

●      Working with Open source technologies like BlogEngine.Net, Dropthings , Yet Another Forum and nopcommerce.

●      Excellent analytical, programming, troubleshooting and debugging skills. 

Work History

Work History
Jul 2007 - Present

Senior Developer

Strategic Alliance
Aug 2006 - Jan 2007

Programmer

Strategic Alliance

Description: Retailmate Client is add-on application for Retailmate ERP. It is meant to be used as POS system at retailer outlet. It synchronizes data with parent organization via internet using XML based communication..         

Role:

●      Involved in Data Modeling, Designing, Normalization and Maintaining data integrity of tables.

●      Involved in GUI designingof Win forms and Web forms anddeveloped them for the application to meet the business requirements.

●      Used Design patterns for implementing system structure.

●      Used Object Oriented Programming in developing controls using interfaces.

●      Used XSL defined schema structures for XML files and implemented SOAP XML based communication using web services.

●      Involved in writing Stored Procedures, Functions, Joins, Views in SQL Server at backend level.

●      Written T-SQL to read and parse XML stored in database.

●      Used SSIS to import, transform and cleanse data from other sources.

●      Written code to communicate and transfer files over FTP.

●      Implemented mechanisms to authenticate and authorize each client communicating with HO.

●      Created Data structures and code to synchronized data between client and HO.

●      Implemented mechanisms and messaging systems to maintain Supply Chain.

●      Used ADO.NET and data objects such as Data Adapter, Data Reader, Dataset, data table for consistent access to SQL data sources.

●      Involved in reviewing code, test plans and design documents.

●      Used Visual Source Safe (VSS) for version controlling.

Environment: Windows, Visual Studio.NET 2005, ADO.NET, VB.Net, C#, XML, XSLT, Web Services, SQL 2005, SSIS. 

Jun 2005 - Jul 2006

Programmer

Strategic Alliance

• Involved in GUI designing of Win forms and developed them for the application to meet the business requirements.

• Involved in Data Modeling, Designing, Normalization and Maintaining data integrity of tables.

• Designed physical development databases on SQL 2005 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for maintaining data integrity in developing database.

• Wrote T-SQL for server stored procedures, views, tables and used database transactions.

• Wrote User Defined Functions in T-SQL to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.

• Wrote and modified stored procedures to implement the complex business needs.

• Implemented and managed SQL Server Merge Replication to synchronize data between servers running on different sites.

• Followed the Microsoft recommended best practices in designing, developing, implementation and testing of the ETL using SQL Server Integration Services.

• Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables and indexes.

• Performed optimization of query, triggers and stored procedures, their testing focusing on stability and execution plan which has increase in performance of numerous modules.

• Used SSIS to import, transform and cleanse data from other sources.

• Involved in the Performance Analysis and tuning of complex Stored Procedures and Functions. Made use of SQL Server Profiler and explain plans to improve the performance.

• Performed optimization of query, triggers and stored procedures, their testing focusing on stability and execution plan.

• Wrote optimized SQL queries to access source data from RDBMS, and provided reports according to the requirements.

• Involved in designing, testing disaster recovery model & implementation

• Designed, Deployed and managed various Reports on SQL Server Reporting Services (SSRS).

• Created different user level groups, and assigned appropriate permission levels to the reports, to ensure access to the information for the right persons with authorizations based on their levels in the organizational hierarchy.

• Used ADO.NET and data objects such as Data Adapter, Data Reader, Dataset, data table for consistent access to SQL data sources.

• Used Object Oriented Programming in developing controls using interfaces.

• Used GDI printing to print invoices and bills.

• Written code to generate Code-39 barcodes using GDI classes available in .Net.

• Written code to communicate with barcode reader and barcode printers to read/print barcodes.

• Involved in reviewing code, test plans and design documents.

• Used Visual Source Safe (VSS) for version controlling.

Jun 2005 - Jul 2006

Programmer

Strategic Alliance

Description: Retailmate is an ERP developed for the retailing industry. It has modules for Payables, Receivables, Accounts Management, Financial management, Inventory, HRM, CRM, SCM, Security, MIS, etc. It is targeted for big retail stores.   

Role:

●      Involved in GUI designing of Win forms and developed them for the application to meet the business requirements.

●      Involved in Data Modeling, Designing, Normalization and Maintaining data integrity of tables.

●      Designed physical development databases on SQL 2005 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for maintaining data integrity in developing database.

●      Wrote T-SQL for server stored procedures, views, tables and used database transactions.

●      Wrote User Defined Functions in T-SQL to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.

●      Wrote and modified stored procedures to implement the complex business needs.

●      Implemented and managed SQL Server Merge Replication to synchronize data between servers running on different sites.

●      Followed the Microsoft recommended best practices in designing, developing, implementation and testing of the ETL using SQL Server Integration Services.

●      Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables and indexes.

●      Performed optimization of query, triggers and stored procedures, their testing focusing on stability and execution plan which has increase in performance of numerous modules.

●      Used SSIS to import, transform and cleanse data from other sources.

●      Involved in the Performance Analysis and tuning of complex Stored Procedures and Functions. Made use of SQL Server Profiler and explain plans to improve the performance.

●      Performed optimization of query, triggers and stored procedures, their testing focusing on stability and execution plan.

●      Wrote optimized SQL queries to access source data from RDBMS, and provided reports according to the requirements.

●      Involved in designing, testing disaster recovery model & implementation

●      Designed, Deployed and managed various Reports on SQL Server Reporting Services (SSRS)

●      Created different user level groups, and assigned appropriate permission levels to the reports, to ensure access to the information for the right persons with authorizations based on their levels in the organizational hierarchy.

●      Used ADO.NET and data objects such as Data Adapter, Data Reader, Dataset, data table for consistent access to SQL data sources.

●      Used Object Oriented Programming in developing controls using interfaces.

●      Used GDI printing to print invoices and bills.

●      Written code to generate Code-39 barcodes using GDI classes available in .Net. 

●      Written code to communicate with barcode reader and barcode printers to read/print barcodes.

●      Involved in reviewing code, test plans and design documents.

●      Used Visual Source Safe (VSS) for version controlling.

Environment: Windows, Visual Studio.NET, ASP.NET, ADO.NET, VB.Net, C#, SSRS, XML, Web Services, SQL Server 2000/2005, SSIS/DTS, SSRS.

Education

Education
2002 - 2006

B.E. IT

SCET,Surat
2000 - 2002

HSC

I.N.Tekrawala
1999 - 2000

SSC

Lokmanya Vidhyalaya ,Rander,Surat