Web Services Sql Server
Resume:
Simi s Lal
****.************@*****.***
OBJECTIVE
To contribute in leadership position as an IT Software Development / Architect, develop Technology Initiatives that span across diverse technologies and apply the skills developed over years in as an Implementation Consultant, .Net Technical Lead, Senior .Net Developer and Programmer.
SUMMARY
Microsoft Certified Application Developer with 14+ years of professional experience in all stages of SDLC (Software Development Life Cycle) involving studying of the user requirements, analyzing, designing, coding, implementation, debugging, testing, deployment and documentation across diverse industries / work environments.
Experience in the domain of Time and Labor, Human Resources, Payroll, Biometric Clocks and Punch collection devices, Mobile and Tele punch Systems.
Good hands on knowledge of OOPS (Object Oriented Programming Structure) and Agile methodology.
Knowledge in latest web technologies including Angular JS, RESTful Api, Web Api, Asp.net Core
Hands on technology experience of designing and developing software applications with Microsoft .NET Framework 1.0/1.1/2.0/3.0/3.5,4.5 using C#, ASP.NET and ADO.Net.
Extensive experience with Web technologies like ASP.NET, WCF & Web Services, IIS 5.0, 6.0,7.0 HTML, ASP, XML, SOAP, XSLT, JavaScript, SSRS and SSIS.
Experience designing and/or developing solutions for a Service Oriented Architecture (SOA).
Experience using tools such as Visual Studio.Net 2003/2005/2008/2010,2013 and VPN.
Proficiency in Visual Studio 2015/2017.
Experience in coding for WinCE devices.
Excellent Knowledge of WCF (Windows Communication Foundation) for development and hosting.
Sound knowledge of 3-tier and N-tier layered architecture.
Experience in deploying application as Web Garden and Load Balancing.
Sound knowledge of several DESIGN PATTERNS like Singleton, Factory and ASP.NET MVC.
Extensive experience in creating rich content Web-Forms, Win-Forms (Windows Forms), Web User Controls, Custom Control, Server Controls, Windows Service and Web Service.
Extensive experience in web-based page and site designs using HTML, DHTML, CSS, Themes, Master Pages, Site Map, JavaScript and AJAX.
Experience in SQL Full Text Search for quick search of text from large data.
Experience with Data Accessing including using Data Adapter, Data Reader and Dataset in ADO.NET and LINQ (Language Integrated Query) Providers for data manipulation.
Expert knowledge of versioning tools like TFS (Team Foundation Server), VSS (Visual Source Safe),
Excellent experience in onsite-offshore model interacting with clients and Onsite managers.
Sound knowledge of Multithreading and Caching.
Hands on experience with SQL Server 2000, 2005, 2008 2014.
Extensively worked on writing Stored Procedures, Triggers, Functions, Views and Database Design.
Created and maintained SSIS packages to Import/Export data from flat files, XML, Excel and Oracle.
Experience in software unit testing and efficient at fact-finding, root cause analysis and bug-fixing.
Migrated applications to ASP.Net and C#, MS Access, FoxPro to SQL Server.
Very good Team player, Self-motivated, hardworking professional with good organizational, leadership, interpersonal and communication skills.
Quick learner and adapt quickly to any new situation/changes and work pro-actively towards meeting deadlines is my forte.
Additional experience in training customers & development teams and supporting pre-sales activities with platform technical details, functionalities and capabilities to meet customer needs.
CERTIFICATES
Microsoft Certified Application Developer (MCAD) .Net Framework 2.0 and Web Applications.
TECHNICAL SKILLS
Programming Languages:
C#.Net, SQL, Transact-SQL (T-SQL), VB.Net and VB6.
Web Technologies:
ASP.Net, Classic ASP, HTML / HTML 5, XAML, HTML/HTML5, XML, XSD, XPath, JavaScript, CSS2/CSS3, AJAX, jQuery, Restful API, Web API, AngularJS, Asp.Net Core
Databases:
SQL-SERVER 2000, 2005 and 2008,2012,2014, MS-SQL Reporting Services, Oracle 8i, MySQL, MS Access.
UML:
Use Case diagram, Dataflow diagram, Sequence diagram, UML Activity diagrams for modeling business scenarios and application flows and Class Diagrams.MS Visio
SDLC Models:
Iterative/Agile Development Methodology, SCRUM, Rational Unified Process, Water Fall Model, Spiral Model, RAD Model and View Models.
Version Control:
MS Visual Source Safe (VSS), Team Foundation Server (TFS)
Technologies & Libraries:
.NET Framework 1.1, 2.0, 3.5, .net CF 3.5, Win Forms, Win32 API, COM/DCOM/COM+, ActiveX, Web Services, SOAP, Web Forms, ADO.NET, ADO, ODBC, CDO, ISAPI, Design Patterns, WCF, LINQ, jQuery Plugins, AJAX Control Tool Kit
Testing Skills:
Unit Testing, Integration Testing, Automation Testing using TFS, WCF testing with WCF Test Client, SOAP UI.
PROFESSIONAL EXPERIENCE
Employee Based Systems LLC, Denver, CO – January 2005 – Present
Role: Sr.Net/C#/Sql Developer and Project Specialist.
Product Owned: Employee Based System (Payroll, HR, Time and labor, Attendance and Scheduling, Mobile and Tele punch Applications.).
Environment: Asp.net MVC, C#, Razor, SQL Server 2012,2014, Entity Framework, WCF,.Net4.0,XML,Javascript,jQuery,AngularJS
Primary technical contact for critical issues for Time and Labor, Attendance, Scheduling, Ebs-Mobile, Ebs-Telepunch and Biometric clocks used by large clients across US and Canada. Serves as lead of four members in US and provides guidance to ten team members located in Bangalore, India. Tasks include design and development of customized solutions for client requirements, programming, providing technical support for user issues and production issues, resolving technical issues in a timely manner, application infrastructure management, business continuity planning and management, change and problem management, automating application monitoring tools. Prepared technical training and process documentation for team, to aid with day-to-day support issues. Coordinated with business executives, pre-sales team.
Responsibilities:
Handle overseas Implementations of Time and Attendance, HR and Payroll projects Project coordination with offshore development team as per requirement documents, prepared after discussion with the managers of client teams.
Execute and advocate best practices; follow established process methodologies for managing scope and risk during project implementations
Handle all implementation tasks, project management, kick-off meetings, design, review, GAP analysis, implementation, training, status reports, etc. as well as be a team member on larger projects
Engage customers in planning meetings to plan out the scope, schedule and cost of services to be provided
Resolve and escalate customer implementation issues to ensure customer satisfaction
Develop and nurture business relationships within customer base to facilitate a sense of partnership with customers
Design and development of customization requirement–Professional service
Responsible to create web services, APIs using WCF, Web Api.
Support/modify the exiting web services as per user requirements.
Managing the SQL server databases.
Provide Support to other teams to fetch the data from the centralized database using ASP.net XML Web Services.
Prepare technical design documents, perform code reviews, debugging and testing
Provide inputs in architecting, designing, and implementing a Service Oriented Architecture (SOA) for the application development group
Responsible for the delivery of architecture artifacts that will demonstrate the projects adherence to strategy, design patterns, and best practices
Created and deployed SSIS packages to production, schedule them to run on routine basis and monitor error log for errors.
Client and server-side validations done using jQuery
Involve in Web Service unit testing using SoapUI tool.
Experience with Amazon Web Services (AWS) configuration and deployment of projects.
Designed and developed SAAS version of the products and implemented.
Implemented TPI Using APIs, created new API and Generic View Configuration for business integration
Role: Technical Lead.
Product Owned: Employee Based System (Payroll, HR, Time and labor, Attendance and Scheduling, Mobile and Tele punch Applications.).
Environment: Visual Studio.NET 3.5, WinForms, WCF, Microsoft AJAX toolkit C# 3.0, ASP.NET 3.0, Microsoft AJAX toolkit, ADO.NET, XML, SQL Server 2012/ 2008 R2, Microsoft Enterprise Library.
EbsSuite is a fully Integrated Solutions for Payroll, HR, Time and Labor Management, Attendance Tracking with Workflow, Scheduling, Business Activity Monitoring and e-Mail Processing with Workflow solutions. EbsTime enables you to easily configure complex payroll rules and policies for your organization, and then generate electronic time sheets which can be viewed, modified and approved online. The system is delivered with a complete set of time & labor, attendance and scheduling reports which enable you to validate and reconcile your electronic time sheets with payroll. EbsTime is the administrative module for configuration, for electronic time sheet approval, and for accessing reports and employee information. The other available modules include Web Time Sheet, Web Punch, Scheduler, Attendance, and Tele Punch, EBS Mobile App.
Responsibilities:
Responsible for analyzing the requirements and client interactions.
Programming Complex module and Business Logic.
Assigning task to team members.
Responsible for designing the database and application.
Created test plan and test strategy documents from system requirements and developed detailed, system-level test scripts from use cases and screen specifications. Conducted testing, reported test results, and maintained detailed reporting, retesting, and closing of issues in the Quality Center database.
Involved in all phase SDLC, Requirement Analysis, development, testing and implementation of the project.
Responsible for analyzing and developing enhancement & maintenance to existing application.
Ensure code written meets the predefined organizational and department standards
Design and develop Web Applications using Asp.net, delivering the functionality detailed in the technical specifications
Extensively worked on TFS for source control management, Project/task tracking and Prioritize tasks.
Experience in developing UI using Silverlight 3.0/4.0, ASP.Net Server-Side Controls, HTML Controls, CSS, JavaScript, and jQuery.
Involved in Developing WCF services to enable effective communication.
Involved in the creation of master pages using Menu and Site Map Path controls.
Worked with developers to resolve and fix the issues found in testing the structure and functionality of the application
Implemented, defect tracked, debugged, fixed applications and provided application support.
Made technical documentation for project.
Involved in the daily scrum meeting to update the task status at hand to the overall Team.
Provide a defining, senior level contribution to development team responsible for the implementation of critical SOA web-based applications using the .Net Framework and SQL Server technologies
Collaborate with business stakeholders and team members to define & analyze requirements
Analyze, design, and develop code for all application tiers, as needed
Developing enterprise wide reusable components for other application development teams
Provide inputs in architecting, designing, and implementing a Service Oriented Architecture (SOA) for the application development group
Used C#.NET, WinForms, ASP.NET and ADO.NET to define and implement secure middle-tier components using both connected and disconnected environment strategies. Components were consumed by web applications and windows applications utilizing SQL Server and stored procedures to perform logical business transactions.
Implemented presentation layer with all UI components (ASP.NET) for both the end-user application and administration and configuration purposes (Web Pages, Controls).
Project coordination with offshore development team as per requirement documents, prepared after discussion with the managers of client teams.
Database work involved, writing/fixing stored procedures, which were in turn used by the Core Data Access layer.
Role: .Net developer R&D Specialist
Product Owned: Employee Based System (Payroll, HR, Time and labor, Attendance and Scheduling, Biometric-HP 3000-Application Biometric-GT 400)
Skill set: Visual Studio 2008, .Net Framework 3.5, C#, XML, ADO.NET, SQL Server 2005,2008, LINQ, Windows and Web Services
Worked as a Senior .Net Developer and R&&D specialist in the offshore team with the responsibility of Research and development of User friendly GUI components, Custom .Net components and usage of web services. Developed the Controller Component assemblieswith Action classes. Used SOAP for Web Services by exchanging xml data between the applications. Created Windows application using the biometric clock SDK software and designed, implemented windows services to communicate with the biometric clocks, Accu-Time clocks, and Windows CE finger template clocks. Designed and Implemented web services to communicate with the clocks outside the network.
Responsibilities:
Managing all design and front-end related project to ensure timely completion of time and attendance product.
Creating intuitive, flexible User Interfaces
Ensure exceptional quality and usability of all web sites, while optimizing performance and scalability
Integrated and used Microsoft AJAX control toolkit with the application.
Created Master Pages and Page Base (Secured/Unsecured) classes for entire application.
Database work involved, writing stored procedures, which were in turn called by the Data Access layer using Microsoft-Application-Library API’s.
Worked at all levels is multi-tiered architecture (Code behind, Business Layer, Data Access Layer), built using OOP’s principles.
Implemented methods for export to excel functionality to be used in entire application.
Created custom controls for use in entire application, mainly for SQL injection prevention.
Implemented Web garden deploy and Load Balancing.
Developed Windows Services to communicate with Collection devices on Distributed/Remote VPN environment for real time update.
Role: .Net developer
Product Owned: Employee Based System (EbsTime, Customer Portal, CRM- Accounting System Integration)
Skill set: Visual Studio 2008, .Net Framework 3.5, C#, XML, ADO.NET, SQL Server 2005, Windows and Web Services.
Worked as a .Net Developer on the product development team for Employee Based systems. The system is delivered with a complete set of time & labor, attendance and scheduling reports which enable you to validate and reconcile your electronic time sheets with payroll. EbsTime is the administrative module for configuration, for electronic time sheet approval, and for accessing reports and employee information. Involved with development and testing of the modules. Created stored procedures, Views using T-SQL enforced organizational constrains on the database. Developed triggers to incorporate server end validations. Created an Audit Module, Home page dashboard Module, Multi Language /Globalization in EbsTime.
Designed and Lead two portal for Customers and Partners for EBS, with a two-member team. This includes Sql Database Design, screen template design and Requirement specs development.
Designed and Implemented Web Services, Windows Services for the customer portal and CRM-Accounting integration project with real time product registration and activation based on Invoice. Created a queuing system for case updates and Email Alerts.
Responsibilities:
Managing all design and development-related tasks and projects to ensure timely completion of Websites
Responsible for the design and creation of Websites and intranet sites
Ensure exceptional quality and usability of all web sites, while optimizing performance and scalability, develop standards and document best practices as it relates to the web site.
Implemented Multi language/globalization support.
Services Interface: To expose business logic as a service, created service interfaces that support the communication contracts (message-based communication, formats, protocols, security, exceptions, and so on) its different consumers require.
Data access logic components: This applications and services will need to access database during a business process. So, in this we have implemented centralizes data access functionality and makes it easier to configure and maintain.
ART Technologies, Cochin, India December 2004
Role: Programmer
Skill set: Visual Studio 2003, ASP.NET, VB.NET, Internet Information Service (IIS 5.0), JavaScript, ADO.NET, SQL Server 2000
Developed a complete test cycle, planned test case requirements, and performed manual and automated testing of applications. Developed business rules and process logic and created database tables, triggers, and stored procedures. Designed and developed all graphical user interface (GUI) screens for the eStore. Developed test scripts and testing methodologies and maintained the quality assurance model. Created and maintained test environments for efficient and faster testing. Wrote test cases for module, integration, and system level testing.
Responsibilities:
Developed project using ASP.NET, C# and back-end database as Microsoft SQL Server 2000
Developed C# components to implement the business logic, consumed instances of these using ASP.NET.
Designed User Controls in the Application using ASP.NET for writing reusable User Interface UI and encapsulating the functionality.
Used ADO.NET extensively for database manipulations and connections.
Performed validations on Web Forms using .NET Validation Controls and also JavaScript.
Configured security features for the application using Form Based Authentication and Role Based Authorization using C# and ASP.NET.
Created and consumed Web Services using C#.
Created and deployed Web Services using VB.NET, SOAP, XML for Pulling Customer Service Records.
EDUCATION
Master of Computer Application – (2000)
NI College of ENGINEERING, TN, INDIA
Bachelor of Science in Mathematics, Astronomy (1996)
Calicut University – Kerala, India
Contact this candidate