Lekha Puthusseri Veetil adc4na@r.postjobfree.com
Sr. .Net Consultant Cell: +1-404-***-****
PROFESSIONAL SUMMARY
• Software development
o Senior Microsoft Technology Specialist with 12+ years of experience with diversified fields of System Applications, Application Software Development, Web Application, N-Tier Applications and Maintenance.
o Ebullient team player with excellent verbal and written communication skills.
o Rich experience working on end to end SDLC on development projects.
o Worked extensively in ASP, ASP.NET, J2EE applications using Struts framework and well versed with COM, Web services, SOAP.
o Developed applications using web related protocols (HTTP/HTTPS), JSP, ASP, Scripting Languages and IIS Server.
o Exposure to ASP.NET, C#, XML, Oracle and SQL Server.
o Proficient in Designing and Development Object-Oriented Web/Windows utilizing Microsoft Technologies like C#, ASP.Net/MVC 5, WCF, Ajax, Entity Framework, Web Services, IIS, LINQ, JQuery.
o Exposure to other tools such as Crystal Reports, Infragistics UI and Kendo UI toolkit.
o Familiar with N-tier SOA based design architectures as well as some of the design patterns like Factory and Singleton.
o Solid understand of SDLC (Software Development Lifecycle) and strong knowledge of Systems architecture and analysis, design, development, testing and implementation Web/Windows applications
o Experience on working with Entity Framework.
o Proficient in using AJAX, Java Script with .NET web applications
o Good knowledge in system integration using WCF and/or web services.
o Experience in designing and developing high performance applications using Multithreading techniques.
o Good experience in HTML, CSS, XML, JSON, Java Script and JQuery
• Database
o Expertise in designing strong database architectures for applications.
o Expert in writing complex stored procedures, views, jobs .
o Expertise in database performance tuning techniques such as query optimization, indexing, etc
o Experience in writing & debugging Stored Procedures, Triggers, SQL Scripts, Views, Indexes, Temp tables, SQL Jobs and running SQL Profiler traces for debugging and to optimize queries.
TECHNICAL SKILLS
Primary Skill: Microsoft Technologies - .NET
• Project Acquired skills: .NET 3.5/4.0/4.5, ASP.NET, VB.NET, C#, MVC 4/5, XML, Oracle and SQL Server, TFS, JQuery and Web services (WCF)
WORK EXPERIENCE – (MAJOR PROJECTS)
Project: Nestle USA Overage, Shortage and Damage system (OS&D) Sep/2017 – Till date
Client: Nestle, Stlouis (US)
Role: Lead Developer
Project Description:
OS&D is a web based application that will be used to enter, track and process the OS&D’s (overage/shortage and damages). The application would incorporate a workflow process that will allow the third party carriers, in addition to Nestle users, to enter and process the OS&D claims. The various Nestle internal users like OS&D Central team, customer service team, inventory control team will have the access to process the claims. The application would act as a unified platform allowing the teams to work on one streamlined business claim process to handle all the OS&Ds in NUSA markets. The business teams would also have the capability to generate live SAP BW reports as the BW universe will be built on top of the application’s SQL database
Responsibility:
• Design, build, and maintain efficient, reusable, and reliable C# code
• Develop Functional and technical spec documents based on the business requirements
• Develop windows service to call the service to check / ping the cognos instance based on the schedule
• Ensure the best possible performance, quality and responsiveness of applications
• Develop common control in order to reuse across the application
• Analyze the business requirement documents and High level design documents created by the business
• Requirement analysis and System Designing using MS Visio and preparation of Functional and technical spec document.
• Communicate project status and deliverables with managers and product Owner
• Interact daily with Development Lead, Product Owner, and Quality Assurance Professionals
• Develop business entities and interfaces and web service for triggering mail communication
• Creating database schemas that represent and support business processes and stored procedures
• Analyze and confirm the input data source format from SAP team
Technologies:
.NET Framework 4.0, ASP.NET, C#, WCF, JQuery, XML, LINQ, UI controls
Database: SQL Server
Project: Emerson Reporting Dashboard Tool for Service Manager Jun/2010 – Jan/ 2015
Client: Emerson, Pune India
Role: Sr Software Engineer
Project Description:
This Emerson reporting tool is a web based system developed to provide end-to-end solution to manage and check the data analysis reports for all IM / RM and Tech tickets and to have all sort of consolidated reports in one umbrella. However this reporting system is used to analyze and take a business decisions
Responsibility:
• Perform gap analysis and proposed the business solution to customer
• Design, build, and maintain efficient, reusable, and reliable C# code
• Prepared business requirement document and Functional documents
• Ensure the best possible performance, quality, and responsiveness of applications
• Design, create and program SQL Server databases per project needs
• Used Agile methodology and release project in the phased manner
• Develop business entities and interfaces and web service for triggering mail communication in case of alert that any ticket get breached
• Coordinate with offshore team to get the project developed
• Interact daily with Development Lead, Product Owner, and Quality Assurance Professionals Design, create and program SQL Server databases per project needs.
• Testing: This includes Unit Testing and System Testing
• Involved in User Acceptance Testing by coordinating with business users
Technologies:
.NET Framework 4.0, ASP.NET, C#, WCF, JQuery, XML, LINQ, MS Visio and Google
Charts
Database: SQL Server
Project: Emerson CQA - SAM Sales Application Aug/2008—May/2010
Client: Emerson, Pune India
Role: Developer
Project Description:
Emerson is a global company focused on providing superior products and services to customers in the automation industry. The purpose of this project is to integrate the existing Contract Quotation Acquisition (CQA) and Sales Advisory Memo (SAM) application in .NET architecture. The existing CQA is a ColdFusion system and SAM was developed in .NET 2.0. This system will be used by Sales Lead, Commercial Lead, Contract Lead Account Managers, Account Directors and Global Account Directors to create CQA and SAM.
A web application that helps the TRW sales and marketing team to provide Effective quotations, track the quotation status, record sales advisory memos, Do PO review and effectively handover the project to operations team Web application based on ASP.NET 3.5/Oracle 10g. The application designed using n-tier architecture and uses all the latest features like LINQ, Ajax controls, Update panel. Entities are used to pass information between layers.
Migration scripts created to extract data from 2 different applications to the newly designed database
Created web service (Mal service) to send a mail from web application for an approval of each stage or rejection and failures that notifies to next level of group / department to proceed
However this web service is being accessed from different applications
Responsibility:
• Design, build, and maintain efficient, reusable, and reliable C# code
• Ensure the best possible performance, quality, and responsiveness of applications
• Develop common control in order to reuse across the application
• Design, create and program SQL Server databases per project needs
• Analyze the business requirement documents and High level design documents created by the business
• Requirement analysis and preparation of Functional and technical spec document
• Get Sign off the Functional and technical spec document before start of the project
• Develop business entities and interfaces and web service for triggering mail communication for the status update of all quotation of each stages
• Develop user control to get the approvers (Users) for each stage using LDAP authentication
• Develop component which would generate report as excel / PDF format and produce as an output to end user for download
• Design, code, and unit test Web Services using .NET C#, XML,T-SQL
• Develop the main functionality using reflection concepts
• Develop Database design and stored procedures for SAM, Handover modules
• Improved the performance of the application in various areas by profiling and implementing design changes.
• Involved in developing of scripts for database migration from old system to the current system
• Interact daily with Development Lead, Product Owner, and Quality Assurance Professionals
• Used Agile methodology and release project in the phased manner
• Testing: This includes Unit Testing / System Testing / Integration Testing
• Involved in the user acceptance testing support phase
Technologies:
.NET Framework 3.5, ASP.NET,C#, web service, JQuery, XML, LINQ, Excel, PDF 3rd party
libraries
Database: SQL Server 2008
Project: Work order Management System (WOMS) Jul/2007—Aug/2008
Client: SCMC, Pune India
Role: Developer
Project Description:
WOMS (Work order management system) is developed to manage the work-flow between the TRW project sponsoring teams and the Satyam project execution teams. It covers the functions of work initiations, submission of proposals / requirement specifications, approvals, reporting of project progress and efforts spent, invoicing and informatory reporting. It ensures that the standardized processes / methods are followed. It also acts as the repository of all the projects flowed through this system
Responsibility:
• Design, build, and maintain efficient, reusable, and reliable C# code
• Ensure the best possible performance, quality, and responsiveness of applications
• Develop common control in order to reuse across the application
• Design, create and program SQL Server databases per project needs
• Analyze the business requirement documents and High level design documents created by the business
• Requirement analysis and preparation of Functional and technical spec document
• Develop business entities and interfaces and coding
• Develop component which would generate report as excel / PDF format and produce as an output to end user for download
• Develop Database design and contribution of stored procedures
• Involved in developing of scripts for database migration from old system to the current system
• Testing: This includes Unit Testing / System Testing / Integration Testing
• Involved in the user acceptance testing support phase
Technologies:
.NET Framework 3.5, ASP.NET, C#., JQuery, XML, LINQ, Excel, PDF 3rd party libraries
Database: SQL Server 2008
Project: GM Fusion (Development / Support Project )
Nov/2005—Jun/2007
Client: Choice Software, Hyderabad India.
Role: Developer
Project Description:
GM Fusion is a sophisticated web application developed using Framework, which provides entire vehicle information including design, safety, technical specification, overview, online test drive booking etc., from all over the world. Moreover this provides online vehicle shopping and buying solution for the clients. Features of this project: Vehicle Configurator, Vehicle Advisor, Vehicle Selector, Competitive Comparison, Product Info. Specification, Search Inventory and Dealer Locator
Responsibility:
• As a team member, was responsible for
• Analysis of the specifications provided by the clients.
• Overlooking the development of JSPs, data & content for Fusion
• Understanding the requirements and preparation of Usecase for all the functionalities
• Coding using C#, XML, HTML pages, Java Scripts
• Architecture & Design meetings with Onsite team and Core Technical competency group and getting approvals for designed architecture.
• Providing Technical guidelines to as a module leader to the team members.
• Conducting Code Reviews, Weekly meetings with team members
• Responsible for delivery of modules as per the schedule.
• Responsible for overseeing the Quality procedures related to the project
EDUCATION
MCA Master in Computer Applications: 2005
B.SC. Computer Applications: 2002