Post Job Free

Resume

Sign in

Project Sql Server

Location:
San Rafael, CA
Posted:
February 15, 2019

Contact this candidate

Resume:

Dhanya Kappuva Veettil

:San Rafael,CA

(: +1-224-***-****

*: ac8h8i@r.postjobfree.com

PROFILE SUMMARY

• 7 years of IT Software development experience on Microsoft Platforms.

• Result oriented professional hands on experience on C#, ASP.Net, MVC and SQL Server.

• Rich Knowledge of Object Oriented Analysis and 3 - Tier Architecture.

• Well versed with knowledge of GUI development using ASP.Net, ASP, HTML, and JavaScript etc.

• Extensive experience in writing stored procedures with SQL Server 2005,2008 & 2012.

• Application enhancement to provide permanent solution for recurrent issues.

• Co-coordinating and conducting knowledge transfer session for other team members.

• Has the ability to understand and transform complex business requirements into software, ensuring applications are delivered on time, to specification, are scalable, performance optimized and maintainable.

• Good analytical, problem solving, decision making, negotiation and communication skills. CORE COMPETENCIES

• Technical Architecture

• Product Development

• Product Design

• Development, Coding & Testing

• Process Improvement & Re-engineering

• Define Requirements and Analysis

• Root Cause Analysis and Problem solving

• Exception handling & debugging

EXPERIENCE & ACHIEVEMENTS

NSWRD, Illinois-Senior Programmer/Analyst MAR 2018-JAN 2019 Roles and Responsibilities:

• Analyze existing application systems and develop recommendations for improvements of technology utilization and/or business functions.

• Program, test, debug, and implement application programs.

• Install, test and implement system and application software releases required to maintain a supportable technology and business environment.

• Train users in new/updated application systems.

• Educate department staff members in the use of new technology products and services.

• Support and maintenance for new and existing third-party applications and systems. Key Accomplishments:

• Involved in the upgrade of Microsoft Dynamics GP application.

• Worked with the migration of online utility bill payment system.

• Developed & implemented C# console applications to automate SFTP file transfer.

• Worked in maintaining the company website.

• Contributed in the data analysis and data migration of the utility billing system.

• Worked in bug fixing and support of the various in-house applications.

• Involved in server monitoring and VPN audit.

• Implemented the SSRS feature of the Microsoft Dynamics GP application. HITACHI CONSULTING, India-Consultant NOV 2014 – FEB 2017 Roles and Responsibilities:

• Worked as a software consultant and contributed to project design, development and implementation using C#, ASP.NET, MVC and SQL Server.

Key Accomplishments:

• Designed & developed in house application Code Quality Tracker.

• Worked on Corvel Application maintenance.

• Worked independently on MVC and Web API.

• Assisted in the UI development and documentation.

• Designed front-end using latest tools like Ajax.

• Worked extensively using JavaScript.

• Managed work items in Microsoft Team Foundation Server.

• Worked on Infragistic controls and upgraded the UI to new Infragistic version.

• Performed code review, worked close to team member to ensure consistence to code standards. CMM MARKETING MANAGEMENT, Singapore-Software Programmer OCT 2010-OCT 2014 Roles and Responsibilities:

• Lead role in functional work Designing, developing, testing and deployment of web applications for Sheng Siong Business Group.

Key Accomplishments:

• Lead & Developed Web Application for the HR management system using ASP.NET 3.5 technology.

• Lead research and proposed software programs that are compatible to the future technologies.

• Lead & Developed Windows Application for downloading the attendance record from the finger print machine and processing the timesheet.

• Coordinate with other designers and programmers to develop web projects.

• Prepare documents for program code and maintain it for future reference to ensure appropriate implementation of programs.

• Implement Monitoring and Control, ensuring milestones are met within the project constraints

• Developed Windows Application for Payroll Auto Processing based on the employee timesheet.

• Implemented both Client side and Server side scripting using JavaScript.

• Developed database communication by using ADO.NET & application using FTP commands.

• Supporting intranet web portal for ShengSiong employees to manage self-help tools.

• Involved in implementation of finger print door access system, E-leave and vendor Portal in MVC architecture.

• Created subsystems that helped in enhancing day to day business activities.

• Developed & implemented data transfer program to synchronize HR system data with POS (Point of Sale) system.

• Involved in system analysis, design and development, system integration testing, UAT support, implementation and documentation, user and administrator training. SIXO SOFTWARE SOLUTIONS, INDIA - Web Developer APR 2010 - OCT 2010 Roles and Responsibilities:

• Worked as a team member in developing user friendly websites for individuals and business groups. Key Accomplishments:

• Developed business and personal websites using ASP.Net.

• Developed an online auction website using ASP.Net.

• Developed the front end using ASP.Net.

• Prepare schedule for project development and ensure compliance to deadline.

• Analysis of system requirements, designing system architecture and database.

• Design and development of GUI, components.

• Coordinate with project manager and clients and develop appropriate graphic designs for sites.

• Review coding standards as per project requirement.

• Designed and developed the database and wrote stored procedures in SQL Server 2005.

• Developed RDLC reports.

• Ensured quality inputs in web development processes, coordinating with senior developers for eliminating any critical errors.

• Coordinated change control, and incorporating all possible user requests and enhancements.

• Ensured that the product has been tested properly prior to its launch or distribution. KEY PROJECTS

Project 1: Corvel Claim Management Portal

Client/Customer: Corvel, USA

Team Size: 4 Duration: 5 months Tools &Technologies: ASP.Net, C#, Infragistic Controls, SQL Server 2012, JavaScript

Project Description:

• Corvel Claim Management portal is a healthcare management solution used for medical insurance companies. Roles & Responsibilities:

• Involved in Web UI upgrade using infragistic controls.

• Investigated and resolved application functionality related issues and provided support and troubleshooting as needed.

• Documented issues and problem-solving process.

Project 2: Code Quality Tracker

Client/Customer: Hitachi Consulting, India

Team Size: 3 Duration: 5 months Tools &Technologies: ASP.Net, C#, MVC 5, Bootstrap, SQL Server 2012

Project Description:

• Code Quality Tracker(CQT) is an in-house application for tracking the status of ongoing and under construction projects in the organization.

• It contains one dashboard for consolidated view of all the projects.

• CQT provides project information at various level of detail to different user roles on the project.

• It also includes document & knowledge management and customizable reporting.

• Helps users track project progress.

Roles & Responsibilities:

• Worked on UI design and development.

• Designed and developed .NET web components and user controls using ASP.NET, MVC, C#.NET, AJAX Toolkit.

• Implemented JQuery for client side validations.

• Implemented object dependency injection concepts among classes.

• Extensively used CSS, JavaScript, AJAX, and HTML.

• Implemented document upload/download functionality for various file formats.

• Used LINQ for querying, sorting, filtering the complex objects utilizing Entity Framework DB Context.

• Implemented Repository pattern for centralized data access. Project 3: HR & Payroll Management System

Client/Customer: Sheng Siong Business Group, Singapore Team Size: 2 Duration: 1.5 years Tools&Technologies: ASP.Net, C#, SQLServer2008, Ajax Project Description:

• The Human Resource module is a component covering many other HR aspects from application to retirement. The system records basic demographic and address data, selection, training and development, capabilities and skills management and other related activities.

• The Timesheet Module manages employee attendance by fetching the In/Out time from the Finger Print machine.

• The Payroll Module automates the pay process by gathering data on employee time and attendance, calculating various deductions and taxes, and generating periodic pay and employee tax reports. Roles & Responsibilities:

• Developed Web Application for the employee record management using ASP.NET 3.5 technology.

• Developed Windows Application for downloading the hand punch record from the machine and processing the timesheet.

• Developed Windows Application for Payroll Auto Processing based on the employee timesheet.

• Implemented both Client side and Server side scripting using JavaScript.

• Developed database communication using ADO.NET.

• Created SQL Server reports.

• Managing the project team throughout the project life cycle.

• Ensures project management methods are used throughout the project life cycle.

• Lead the team to perform requirements analysis, design and software development and testing.

• Monitoring the project progress and performance according to the project plan.

• Collaborate with stakeholders to elicit and review Requirements & Design and get their approval on Final project management plan and deliverable.

• Implement Monitoring and Control, ensuring milestones are met within the project constraints.

• Created subsystems that helped in enhancing day to day business activities. Project 4: E-Leave System

Client/Customer: Sheng Siong Business Group

Team Size: 1 Duration:6 Months Tools & Technologies: ASP.Net, C#, SQL Server 2008, Ajax Project Description:

• E-Leave is a web-based leave management system where employees can apply for leave via online. Email will be sent to notify the approver.

• The system will also keep track of all employees' leave records, entitlements, balances. User is able to view their current leave entitlement, leave balance and notification of leave approval from their manager.

• There is a separate mobile version for the application which employees can browse using PDA. Roles & Responsibilities:

• Developed E-leave system using ASP.NET 3.5 technology.

• Developed database communication using ADO.NET.

• Developed a tool for synchronizing HR management system with E-Leave system.

• Ensures project management methods are used throughout the project life cycle.

• Lead the team to perform requirements analysis, design and software development and testing.

• Implementation.

Project 5: Online Auction Website

Client/Customer: Sixo Online Services, India

Team Size: 4 Duration: 4 Months Tools&Technologies:ASP.Net,C#,SQLServer 2008,PhotoShop Project Description:

• Administrator side that focuses on management of administrative tasks, such as pricing and/or discounts where applicable, upload images of items where applicable, closing auctions etc. Reference: Available on Request

• Registered bidders can browse items and place their bids.

• Bidder will be notified via email when they have won an auction. Roles & Responsibilities:

• Interact with clients to determine their requirements and needs.

• Developed Interactive content using ASP.NET 3.5 technology.

• Developed database communication from using ADO.NET.

• Developed functions and routines to enhance business functionality. EDUCATION

• Master of Computer Applications (MCA),Bharathiyar University, India – 2010 TECHNICAL FORTE

Database: SQL Server 2012,2008,2005, MS Access

Coding: C#, ASP.Net, Vb.Net, Javascript, HTML, CSS, XML, Bootstrap Technologies and Frameworks: NET Framework, ASP.NET, MVC, Web API, ADO.NET, AJAX, jQuery, WCF, Crystal reports, RDLC reports, LINQ, Entity Framework, Web services, Visual Studio 2008/2010/2012, 2017, AJAX toolkit, Infragistic controls Operating System: Windows

PERSONAL DETAILS

US Visa Status: L2- EAD Holder

Languages Known: English, Hindi, Malayalam, Tamil

Date of Birth: 22-July-1986



Contact this candidate