Post Job Free

Resume

Sign in

Sql Server Management

Location:
London, Gt Lon, United Kingdom
Posted:
October 12, 2015

Contact this candidate

Resume:

Devanand Chahal

Technical Consultant at ANAQUA LTD.

acr19g@r.postjobfree.com

London, United Kingdom

+44(0) 777-***-****

Professional Summary

10+ years of experience in developing web applications using Microsoft technologies on windows platform.

Recently working for data migration from old application(s) to ANAQUA Product. It Involve understanding clients current data and business, create data migration plan and execute data migration.

Application deployment on client environment, post deployment technical issues resolution, reports generation and assisting in product demos to the clients.

4.5+ years of experience with UML modeling and product architecture using Sparx Enterprise Architecture.

Recent Working experience on UML(Sparx Enterprise Architect), C#(4.5 and earlier versions), ASP.NET (Visual Studio 2012), Telerik Open Access ORM,nHibernate, LINQ, Oracle, SQL Server (2012 and earlier versions), SSRS, WWF, WCF, WPF, Web Services, Web ORB, Adobe Flex builder, Action Script, Cairngorm Framework, SOA, MSMQ, DMS, JavaScript, AngularJs, XML, MS Excel, HTML, CSS, IIS, Unit Testing, Integration Testing, Regression Testing, UAT/Functional testing, TFS, SVN, VSS, JIRA.

Core Java knowledge.

Possess strong OOPS/OOD concepts, SDLC, Components Integration.

Understanding functional specifications and converting them to design model.

Application security fundamentals (XSS, SSL, SQL Injection etc.)

Have good knowledge on Intellectual Property (Invention Submission, Patent, Trademark and General Matters etc.) and Travel Domain.

Agile/SCRUM, KANBAN.

Effectively communicating with the teams spread across the globe (Especially in India, US, UK and France).

Efficiently mentoring and managing a team of 6 members for the product development in agile (Scrum/Kanban) mode.

Proven track for estimation, plan, lead and execute complex technical projects

Having B1/B2 US visa valid till January, 2023.

Having Tier 2 General visa for UK, valid till Novmber 2017.

Functional:

Analyzing the client/business requirements and implementing appropriate techniques.

Consulting and Implementation of Product at Client site and providing them Technical Support as and when required.

Involved in Product Demos and Product Trainings to the clients.

Handling various technical aspects like data migration and coding of modules.

Delivering and implementing the project as per scheduled milestones;

Extending post-implementation and maintenance support to the client.

Linked-in Profile

http://in.linkedin.com/in/devanandchahal

Skype id: devchahal2013

EDUCATION

Masters of Computer Application (MCA) degree with first division from Maharishi Dayanand University (MDU) India (2001 - 2004)

Bachelor of Science (B.Sc. Computers) degree with first Division from Maharishi Dayanand University (MDU) India (1998 - 2001)

EMPLOYMENT HISTORY

Organization: Anaqua Limited, London.

Role : Technical Consultant (Duration : Nov 2014 – Till date)

Organization: CPA Global

Role : Project Engineering Manager (Duration : Feb 2009 – Nov 2014)

Organization: R Systems International

Role : Senior Software Engineer (Duration : Jan 2008 – Dec 2008)

Organization: Interglobe Technologies

Role : Software Engineer (Duration : Oct 2006 – Dec 2007)

Organization: Elixier Web Solutions

Role: Senior Software Engineer (Duration : Mar 2006 – Oct 2006)

Organization: Kinis Solutions

Role: Software Developer (Duration : Mar 2005 – Mar 2006)

Organization: Mass Soft NetCom

Role: Trainee (Duration : Jan 2004 – Mar 2005)

PROJECT DETAILS

PRPDUCT: ANAQUA

Client: All IP Management Companies in Europe, USA and Asia

Duration: Nov 2014 – Till date

Environment: ASP.Net 4.5, C#, HTML, CSS, Java Script, SSRS, Telerik Open Access ORM, WCF, WPF, Design Principles, OOAD, SOA Principles, Visual Studio 2010, 2012, TFS.

Description: Anaqua provides IP management software and service to some of the world’s leading IP owners. These include ANAQUA Enterprise for large IP owners, ANAQUA Express for smaller IP teams, ANAQUA Element for cloud-based IP management, ANAQUA Essential for law firms and ANAQUA Services for IP maintenance payments. The ANAQUA products are designed for all types of intellectual property, including inventions, patents, trademarks and more.

Anaqua manages the full IP lifecycle and is a completely web-based system with automated workflow, integrated document and email management and advanced query and reporting. It is designed to enhance business productivity and IP visibility for all participants in the IP management process. For more information visit www.anaqua.com

Roles and responsibilities:

Understanding the clients existing application and data base structure.

Preparing the data migration plan from old existing client database to ANAQUA database.

Writing the data migration scripts in SQL Server. Data migration can be from Oracle database to SQL or SQL database to SQL database. Using SQL Server 2012 for data migration.

Implementing the documents migration framework for migrating the documents (size ranging from 100GB to 1.5TB, vary client to client). Document migration framework is in ASP.NET, C# with custom migration logging covering every aspect of tracing the errors.

Creating the custom reports for client using SSRS (Report Builder 2).

PRODUCT: MEMOTECH 6.O (PRODUCT)

Client: All IP Management Companies in Europe, USA and Asia

Duration: FEB 2009 – NOV 2014

Environment: ASP.Net 3.5, C#, Adobe Flex Builder, Action script 3.0, Enterprise Architect, Telerik Open Access ORM, WCF, Design Principles, OOAD, Agile Practices – SCRUM, SOA Principles, Visual Studio 2010, 2012, Subversion, VSS

Description: Memotech is a state of the art, web-based IP management software solution specifically designed for the corporate IP department.

It not only helps handle the patent, trademark, design, licensing & agreement and domain name portfolios, but also keeps track of invention submissions, inventor awards and costs associated with the lifecycle management of the IP. Memotech is modular so we can build up our own solution by choosing and adding the features we need. There are five core elements – patent, design, trademark, licensing & agreement and domain name – that can be set up separately or deployed as a combined solution.

Roles and responsibilities:

SCRUM master for running the sprint and managing 8 members to get maximum productivity.

Managing the design model using sparx EA from past four years. Normally I got the requirement specification, based on requirement specification I create the design model, and from design model generate the code for business(C#) and UI (Action Script) layer.

Implementing the basic service operations after generating the code(C#) from design model.

Helping the DBA for model and data base synchronization.

Implementing and managing the application Rules using Business Rule Engine.

Implementing the custom activities to be used in dynamic workflows.

R&D for new features to be included in the product.

Understanding the functional specification document, Preparing technical analysis document, Coding and unit testing of the most complicated tasks. Bug fixing.

Manage and provide technical assistance to team members

Managing 2 clients for product deployment on their environment and their queries resolution.

PROJECT: eTMS (eSign-Transaction Management Suite)

Client: Wave Systems Corp.

Environment: .Net framework 2.0, ASP, VB6.0, XSLT, XSD, SQL Server, VSS.

Description: eSign Transaction Management Suite (eTMS) is an integrated suite of applications to create, sign, store, access and manage electronic records. The suite contains:

SmartSAFE™ - Web-based document repository/e-vault for signed and unsigned electronic records

SmartConnect™ Web Services – Web services to allow for automated interaction with the SmartSAFE, enabling workflow and process automation

SmartSigning™ Room - Add-on module that provides user interface for performing electronic transactions and presentation of signature images in the signed documents.

SmartClose™ - Add-on module that extend the capability of SmartSAFE™ to interact with MERS (Mortgage Electronic Registration System.) to carry out eRegistry transactions which are necessary requirement for mortgage deals in US

Roles and responsibilities:

Requirement understanding.

Implementing the C# services, Application UI.

Implementing SQL Stored procedures, Functions, Triggers etc.

Unit and Integration testing.

PROJECT: TRAVEL HOLIDAYS ONLINE RESERVATIONS (THOR)

Client: Tempo Holidays (www.tempoholidays.com), Australia

Environment: ASP.Net 2.0, C#, Web Services, Design Principles, OOAD, VSS, ADO.NET, SQL SERVER

Description: THOR is both B2B and B2C system. It is a comprehensive Front and Mid office online reservations management system which can be used by travel agencies, customers, suppliers and company staff to create as well as manage the a booking.

The system would allow complete management of travel products and booking. Also suppliers can see and confirm their products booked through the system (using Supplier Interface which is a separate system developed in parallel with THOR)

THOR maintains inventory for all the products except Flights. For flights results are fetched from GWS (Galileo web services)

The following User Type can interact with THOR: - Internal Users, Agents, Suppliers, Direct Users.

The following products can be booked using THOR: - Accommodation – Hotel, Villas, Car, Cruise, Flight, Service and Package.

Roles and responsibilities:

Client Interaction (Requirement gathering and general discussions related to project)

Screen Designing.

Creating/Reviewing Program Specifications and Unit test cases.

Programming in C#, JavaScript, HTML and SQL (Procedures, Functions, Triggers)

Conducting Project Audits

PROJECT : Rent Out Property

Client : US Client (Small Project for an Individual)

Environment: .Net Framework 2.0, ASP.NET. C#, Dream Viewer, SQL Server 2000, Java Script, IIS 6.0

It was a small project for property rent, room sharing, packers & movers and other related activities.

Roles and responsibilities:

Requirement Capture from Client on the functionality & design of Application Screens.

Implementing the data base schema

Implementing the C# code and ASP.NET pages.

Unit testing of the application and deployment.

PROJECT: LSG (Learning Solution Guide 2005)

Client: Learning Solution Provider, US

Duration: March 2005 – March 2006

Environment: .Net framework 2.0, ASP.Net, C#, XML, SQL Server, SVN.

This web portal supports the content management for learning guide. It provides three levels of contents to users. The three levels are Starter, Advanced and Experts. It has its own WYSIWYG editor.

Roles and responsibilities:

Requirement Capture from Client on the functionality & design of Application Screens.

Implementing the data base schema

Implementing the C# code and ASP.NET pages.

Unit testing of the application and deployment.

PROJECT: FinanceBiz (An ERP System)

Client: Mass Soft NetCom, in house product, India

Environment: VB6.0, SQL Server, MS Access, Crystal Reports.

FinanceBiz is a system for manufacturing companies to provide online business. The software consist multiple modules (Finance Accounting, Service and maintenance, Purchasing, procurement and inventory etc.).

Roles and responsibilities:

Maintenance and reporting.

STRENGTHS

Effective in technical and management role.

Ability to manage the team for getting optimum results.

Ability to grasp quickly and adapt to a new business environment.

(Devanand Chahal)



Contact this candidate