Post Job Free

Resume

Sign in

Project Sql Server

Location:
Little Falls, NJ
Posted:
May 23, 2018

Contact this candidate

Resume:

DEVI SATHEESHKUMAR

Application Developer – Microsoft Technology Stack

E-mail: ac5k1l@r.postjobfree.com Contact: 732-***-****

SUMMARY

11+ years of experience in Requirement Gathering, Analysis, Design, Development, and Coding of business/commercial, automation application and Intranet or Internet based applications.

Worked in industries such as HVAC (Heating, Ventilation and Air Conditioning), Thermoking, Banking Card Solution, Insurance.

MCP Certified.

Worked with Enterprise Applications such as Dynamics, EBS and Agiloft.

Experience in Microsoft Visual Studio.NET 2015/2013/2010/2008/2005/2003 – Framework 4.5/4.0/3.5/3.0/2.0/1.1, C#, C#.Net, ASP, ASP.Net,VB.Net and ADO.Net.

Strong experience in Object Oriented Programming Concepts (OOPs).

Developed 3-Tier Applications using ASP.Net, ADO.Net, C#, VB.Net, HTML, DHTML, CSS, VBScript, JavaScript, HttpHandlers and HttpModules with proven abilities in Software Development Life Cycle (SDLC) & Software Quality.

Experience in working with Database Programming like Microsoft SQL Server 2012/2008/2005 and Oracle 11g/10g – creating DDL/DML/DCL PL-SQL, TCL T-SQL, SQL Jobs, Queries, Packages, Stored Procedures/Functions, Cursor, Triggers, User Defined Functions, Indexed/Force Views, Clustered Index.

Experience in working with Crystal Reports, SQL Server Reporting(RDL) and Business Intelligence reports.

Experienced in development of Web Services, WCF Services, Web API, Windows Services and knowledge in TP Service call.

Experience in working with Multithreading.

Experienced in Using XML, XSLT, Xquery, Xpath and LINQ.

Experience in working with MVC, WPF, Entity Framework, Java Script, AJAX, Json.

Experience in working SOAP and REST Services.

Experience in working with Dev and Production Deployment/Integration, debug and fix production related issues.

Experience in working with Firebug, Selenium and Selenium Webdriver.

Worked with third party tool such as Telerik, Infragistics and Oboutsuite.

Experience in working with code-review and version control systems like Tortoise, Team Foundation Server and Visual Source Safe.

Experience in working with Business Intelligence and Oracle Apex.

Working experience with Agile/Scrum methodology.

Implemented the Innovative idea in the Hackathon competition during the year 2016 and 2017.

Ability to work well in both a team environment and individual environment.

Good testing skills, debugging skills, communication skills and interpersonal skills.

Strong ability to perform in diverse and complex technical environments.

TECHNICAL SKILLS

Programming languages

C#, ADO.Net, PL-SQL, T-SQL, C, C++, Visual Basic 6.0

Web Development

ASP, ASP.Net 4.5/4.0/3.5/2.0/1.1, MVC, Ajax, XML, XSLT, JavaScript, VBScript, Telerik, Infragistics, Oboutsuite, Web Services, WCF Services, SOAP, RESTful), HTML, CSS, IIS6

Other Development

Windows Service, WCF, Win API, LINQ

Enterprise Applications

Dynamics, EBS, Agiloft

Databases

SQL Server 2012/2008/2005/2000, Oracle 11g/10g, MS Access

Reporting Tools

Crystal Reports, Business Intelligence, SQL Server Reporting (RDL)

IDE

Visual Studio.Net 2015/2013/2010/2008/2005/2003

Version Control Tools

Tortoise, Team Foundation Server(TFS), Visual Source Safe (VSS)

Application Software

MS PowerPoint, Word, Visio, Excel

Bug Tracker Tool

Mantis

Testing Tool

Selenium, Selenium Webdriver

EDUCATION

Master of Computer Applications, Annamalai University, April 2007, Aggregate: 80%.

Bachelor of Computer Science, Annamalai University, April 2004, Aggregate: 72%.

Diploma in Computer Technology, Muthiah Polytechnic, April 2000, Aggregate : 84%

MICROSOFT CERTIFICATION

Programming in C#

Developing ASP.NET MVC Web Applications

Design and development of Web Application using Microsoft .Net Framework 4.0

Microsoft Dynamics AX 2012 Development Introduction.

Microsoft Dynamics AX 2012 Installation and Configuration.

RECOGNITIONS

Winner of Rock star Award for the costing implementation, SRA migration in Ingersoll Rand.

Winner of Quarterly Award for IKare in Ingersoll Rand.

MAD (Make A Difference) Award for Paccar Card Management in Fidelity Information Service.

MAD (Make A Difference) Award for Valutec Application Service and Windows Service in Fidelity Information Service.

PROFESSIONAL EXPERIENCE

Nov 2017 to current as a Software Engineer for Sequent Inc.,

Mar 2016 to Jul 2017 worked as a Technical Lead/Senior Programmer Analyst for FIS Global Business Solutions India Private Limited.

Apr 2007 to Nov 2015 worked as a Senior Configuration Analyst for Ingersoll Rand Services and Technologies Pvt. Ltd.

PROJECT EXPERIENCE

Project: SpotCars Feb 2018 to May 2018

Client: Norra

Environment: WCF Service, MVC, C#.Net, Json, Visual Studio 2013, Google Maps, Windows Server 2008, Sql Server 2012

Project Description:

SpotCar is web and mobile application to track 2018 Norra Mexican 1000 buggy race in Mexico.

Display all the participants race and the chase vehicles in the Google map.

Feature of messaging service is enabled throughout the race to know the race or chase vehicle details.

Cars, Trucks, UTV’s, and Bikes all crossed the final finish line at the Yokohama NORRA Mexican 1000.

The journey has taken competitors from Ensenada, all the way to San Jose Del Cabo during 5 days of racing.

Responsibilities:

Analysis, Design and Development of technical use cases.

Expertly manage technical development and support operations, diligently troubleshooting issues to identify root causes and prevent recurrence.

Created and normalized the database, wrote SQL Server Stored procedures, queries using PL/SQL and all the DDL and DML.

Communicates the status and created business and technical documentation.

Project: Integration between Agiloft and ERP Nov 2017 to Jan 2018

Client: Insmed

Environment: Windows Service, C#.Net, Json, XML, Visual Studio 2013, Agiloft, Oracle EBS, Microsoft Dynamics AX 2012 R3, Windows 8, Sql Server 2012

Project Description:

Agiloft's Contract Management Suite enables organizations to automate their complete contract lifecycle and streamline their approval process.

Contract information from Agiloft can be integrated into related business processes such as finance, legal or human resources.

This integration focuses on Agiloft’s integration capability with financial components of an Enterprise Resource Planning (ERP) system.

An ERP system such as Oracle EBS and Microsoft Dynamics provides a integrated set of applications to manage core business processes within an organization.

Integration of contracts with ERP improves data quality, increases efficiency and streamlines processes such as approvals and metadata setup.

Integration between Agiloft Contracts and ERP is enabled by built-in tools, industry standard file formats and Secure Transfer Service.

Responsibilities:

Active participation in gathering and understanding business requirements with client business team.

Planning the development schedule and deliverables for the project.

Performed data mapping and migration.

Created business and technical documentation.

Effectively involved in various stages of the development starting from the project planning till UAT, production and maintenance.

Wrote SQL Server stored procedures, queries using PL/SQL and all the DDL and DML.

Effectively communicate status of tasks and projects status in meeting.

Involved in regular team meetings, unit tests and code reviews.

Project: VCS Mar 2016 to Jul 2017

Environment: ASP.Net, C#.Net, Visual Studio 2013, Windows 7, Webservice, Sql Server 2012, SSRS Report, Windows Scheduler

Project Description:

VCS is the internal web application, which includes all the Reseller, Merchant, Location, Terminal and Fees information.

It enables or disable certain functionality/screen depends on the user role like Admin, Admin+NPI(Non-Public information), User, User+NPI, RO and RO+NPI.

Huge upload of data are handling with offline processing like SQL Jobs or Windows Scheduler.

Card creation request are processed with Separate service during non-business hours.

Modules : View Call Notes, Add Call Notes, Card Lookup, Raw Transaction Lookup, Terminal Lookup, Card Program Lookup,Email Reports, View Reports, Web Access, Report Setup.

Account Verification: Check Banking details of a Particular merchant and all locations for that merchant

Billing History: Datewise billing details of Merchant, Locations and Reseller.

Change History, Add Orders, Fee Maintenance, Search By Account, Enterprise: This module is used for mellennia users

Card Maintenance: Maintain all activities related to card

Responsibilities:

Played key role in all phases of software development lifecycle, from design and documentation to implementation and testing.

Responsible for code-review, technical, unit test case and change ticket documentation.

Ownership of work break down and identification of milestones and deliverables for modules involved.

Performed analyses and implemented a streamlined offline batch processing that improved error recovery time.

Involved in implementation of REST based web services.

Wrote SQL Server Stored procedures, functions, complicated queries using PL/SQL and all the DDL and DML.

Used Team Foundation Server repository to maintain the code integrity.

Sql server reporting tool is used for creating all the reporting.

Effectively communicate status of tasks and projects status with Scrum call and meeting.

Project: CardManagement Jul 2016 to Oct 2016

Environment: ASP.Net, C#.Net, VisualStudio 2013, Windows 7, Webservice, Sql Server 2012

Project Description:

CardManagement is the service to create cards for different location under merchant and reseller. This service is created as a job.

Card creation process is a offline job, every night according to the country it should create the cards. Customers always request minimum 30,000 to lakh and above.

Responsibilities:

Interacting with architect and business team to understand the requirements and feasibility.

Planning the development schedule and deliverables for the project.

Responsible for implementation roll-outs and change ticket documentation.

Ownership of work break down and identification of milestones and deliverables for modules involved.

Effectively involved in various stages of the development starting from the project planning till UAT, production and maintenance.

Wrote SQL Server Stored procedures, functions, queries using PL/SQL and all the DDL and DML.

Used Team Foundation Server repository to maintain the code integrity.

Effectively communicate status of tasks and projects status with Scrum call and meeting.

Involved in regular team meetings, unit tests and code reviews.

Project: VT Merchant Portal Apr 2016 to Jul 2017

Environment: MVC, C#.Net, Visual Studio 2013, Windows 7, TP Service Call, Sql Server 2012, SSRS Report

Project Description:

VTMP is the client application, which includes 4 different user levels like Reseller, Merchant, Location, Virtual Terminal.

Customers : Lookup Customers and Card Registration

Reports : Real Time Reports(Eg:- Transaction Detail, Outstanding Bal) and Report Generator

Order Tracking, My Account, Maintenance, Card Info

Responsibilities:

Interacting with the business users to understand the Requirements and feasibility.

Planning the development schedule and deliverables for the project.

Responsible for implementation roll-outs and change ticket documentation.

Ownership of work break down and identification of milestones and deliverables for modules involved.

Effectively involved in various stages of the development starting from the project planning till UAT, production and maintenance.

Wrote SQL Server Stored procedures, functions, triggers, queries using PL/SQL and all the DDL and DML.

Used Team Foundation Server repository to maintain the code integrity.

Sql server reporting tool is used for all the reporting in this portal.

Effectively communicate status of tasks and projects to onsite team.

Project: Paccar Card Management Feb 2017 to Jul 2017

Environment: Windows Service, C#.Net, Visual Studio 2015, Windows 7, Sql Server 2012

Project Description:

Paccar Card Management is the card creation process of different units which do their service via cards and it is a job which is running throughout the day.

It should fetch the Card Request from the PaccarCardRequest queue and created the cards depends on the country and their states.

Once the cards are successfully created, it should send the email to the corresponding users with the status.

Responsibilities:

Interacting with the business users to understand the Requirements and feasibility.

Design and Development done with proper plan which includes Database design.

Planning the development schedule and deliverables for the project.

Responsible for code-review, implementation roll-outs and change ticket documentation.

Ownership of Project Sequence diagram with work break down and identification of milestones and deliverables.

Effectively involved in various stages of the development starting from the project planning till UAT, production and maintenance.

Wrote SQL Server Stored procedures, complicated queries using PL/SQL.

Used Team Foundation Server repository to maintain the code integrity.

Effectively communicate status of tasks and projects with Scrum team.

Project: IHitlist Apr 2014 to Nov 2015

Environment: ASP.Net, C#.Net, Visual Studio 2008, Oracle 11g

Project Description:

IHitlist is a single environment where dealer can input and retrieve data about their business with Thermo King. It lists out all the deals in negotiation in the market (pipeline).

IHitlist comes in two versions catering to the needs of external dealers and internal customers like ASM, RD and Admin. For external dealers, iHitlist is hosted in the Thermo King site and it can be accessed through iService.

For the internal customers, iHitlist is hosted in one of our web-development servers. IHitlist external site works on the authentication of iService where as the internal site has its own authentication.

Responsibilities:

Active participation in gathering and understanding business requirements with regular interaction with architect, business and marketing teams

Planning the development schedule and deliverables for the project.

Responsible for implementation roll-outs.

Conducted deep dive sessions and trainings to business users.

Ownership of work break down and identification of milestones and deliverables for modules involved

Organize weekly meetings and significant client discussions

Effectively involved in various stages of the development starting from the project planning till production and maintenance.

Wrote Oracle Stored procedures, Package, Cursor, complicated queries using PL/SQL.

Used Visual Source Safe repository to maintain the code integrity.

Project: IKare (Thermoking) Sep 2009 to Nov 2015

Environment: VB.Net, ASP.Net, Visual Studio 2008, Oracle 11g, Crystal Report

Project Description:

IKare is the new TKTK portal on the internet for dealers, customers and TKTK back-office.

This portal allows the dealer to request authorizations and submit claims for work carried out on TKTK units. It supports advanced features like allowing the dealer to manage its payments, service locations and contact details.

Responsibilities:

Active participation in gathering and understanding business requirements with regular interaction with architect, business and marketing teams

Performed feasibility study for complex modules

Organize weekly meetings and significant client discussions

Effectively communicate status of tasks and projects

Implemented membership management and country based security for managing the users.

Used JavaScript to implement the client side business logic and validations.

Used different state management techniques (Hidden Fields, View State, Session, query string etc.) to maintain the state between the pages.

Extensively worked on Stored procedures, Triggers, User defined Functions, Views, Temporary tables and Table variables using Oracle 11g

Created and designed reports using crystal reports

Used Tortoise for Version Control and source Control.

Project: SRA May 2007 to Mar 2014

Environment: Microsoft Visual Studio 2008/ASP.Net/C#.Net/AJAX/Oracle 11g/Infragistics

Project Description:

SRA is a web based and thick client based application

The data is processing from the ENZ file and converted into XML data for processing.

It is mainly used for Special Request Approval for pricing in different levels like Sales Engg, Cojo Team and POM Team.

For the costing update used for the windows scheduler.

Responsibilities:

Created a framework which can be reusable for all web projects.

Involved in getting the business requirements, feasible study and planning the development schedule and deliverables for the project.

Responsible for application and database design

Designed and developed several reusable components to be used in other ongoing web project development.

Participated in implementation roll-outs and mentored business people in this tool.

Effectively communicate status of tasks and projects.

Created database objects like Tables, Stored Procedures, and User defined functions, Triggers, Cursors and access them via Model/Data access layer.

Transform Encrypted XML data.

Created the Windows Task schedulers for pricing update.

Improved the performance and scalability of the application by disabling possible Viewstate, making appropriate changes in the web.config file, using as much as client side validations, properly maintaining index in the database table, etc.

Used Visual Source Safe repository to maintain the code integrity.

Project: Document Generation Nov 2008 to Mar 2009

Environment: Microsoft Visual Studio 2008/C#.Net/Oracle 11g/MS-Office 2007 Plugins

Project Description:

Document Management (DocMan) is a standalone tool that can be plugged to any application for generating various documents and diagrams (in different languages), and finally press them into binder(s) to print them.

Command line operation by passing parameters and reading data from various sources like xml, text, excel, databases. It can use multiple data sources such as XML, Text, Excel and DBs. It handles translations in various languages across countries. It also syndicates external documents such as pdf, images, and scans.

Responsibilities:

Involved in getting the business requirements.

Developed a single template for all kind of visio diagrams.

Participated in implementation roll-outs.

Effectively communicate status of tasks and projects.

Worked with WPF templates, styles and converters.

Create and modify Oracle database schema which includes all the DDL/DML/TCL.

Work with different branches of code for different environments and maintain code reliability using Visual source safe as Project repository.

Project: ProAct V2 Jun 2008 to Feb 2009

Environment: Visual Studio 2008, Smart Client Software Factory, C#.Net, WCF,Ajax, Infragistics, Oracle 11g

Project Description:

Project Administration Common Tool (PROACT) is trane controls fulfillment software. It’s a standardized European project management tool. It is used by project coordinators and project managers.

ProAct imports order data from SQP. It handles all project data such as contacts, labor times. It manages I/O points and create controllers wiring diagrams. ProAct also has maintenance modules for Item types, Item class, Catalogs, Rules, Languages, Currency, Pick lists and Products and Equipment’s. This tool is rolled-out in 13 European countries.

Responsibilities:

Develop components/modules/scripts implementing business process rules.

Effectively communicate status of tasks and projects

Handled back-end processing like DDL, DML and using stored procedures, Triggers, Views, User Defined Functions.

Project: SQP Jul 2008 to Oct 2008

Environment: Microsoft Visual Studio 2000, C#.Net, SQL Server

Project Description:

SQP is a windows application which helps to handle Sales Quotation Proposal.

It allows user to create a Proposal and select various components which will support a proposal generation.

Responsibilities:

Involved in developing and testing new user interfaces and enhancing the existing modules.

Created SQL Server database schema, database objects, stored procedures, User Defined Functions, CTE’s, Triggers, Views, Cursors, SQL Joins and other statements for various SQL implementations.

Project: People Trax Apr 2008 to May 2008

Environment: Oracle APEX

Project Description:

Employee details maintenance application.

Allows the User to view and maintain all the employee details.

Responsibilities:

Business requirements gathering, feasible study and planning the development schedule and deliverables for the project.

Database design, Application design and architecture.

Project: Online Shopping Feb 2007 to Apr 2007

Environment: ASP, SQL Server

Project Description:

The objective of this project is to maintain stock details for E-Purchase and developed.

The customers ordered and add into the Cart and the payment gateway is Online Payment System.

Responsibilities:

Involved in collecting the business requirements, feasible study and planning the development schedule and deliverables for the project.

Database design, Application design and architecture

Project status update to senior management

Project: Library Management System

Environment: Microsoft Access

Project Description:

Application to manage and track library related activities

Complete workflow automation to handle Book Maintenance, Book Issue, Book Ordering, Transaction and Fine to be collected as per the rules specified.

Responsibilities:

Requirements gathering, feasible study, development and Unit testing.

Database design in MS-Access.

Project: Life Insurance Corporation of India

Environment: Microsoft Visual Basic 6.0 / MS-Access

Project Description:

Application to maintain information on various customer loans, insurance policies and agents

Responsibilities:

Business requirements gathering, feasible study and planning the development schedule and deliverables for the project.

Database design and Project status update to senior management

Project: Searching By Keywords

Environment: ASP, MS-Access

Project Description:

Simple utility to search for keywords from large volumes of files.

Responsibilities:

Involved in collecting the business requirements, development and deliverables for the project.

Database design



Contact this candidate