Software Engineer Sql Server

ARULANANDHAN SILVESTER

Mobile: +1-469-***-**** or Home: 469-***-****

Email: ac1wry@r.postjobfree.com

Skype ID: sarulanandhan

LinkedIn Link: https://www.linkedin.com/in/arulanandhan-silvester-79497716/

Current Location: Frisco, TX

PROFILE

Full stack Senior Software Engineer with 9 years of experience in software analysis, design, development, and testing using the Microsoft technologies such as C#, ASP.Net, MVC 4, Azure, Winforms, WPF and SQL Server. I have 6 years experience in using Jquery, JavaScript, REST, JSON, AJAX, HTML, CSS and XML. Seeking a challenging position to be a successful Software Engineer in a firm where I could utilize my skills and knowledge to deliver software applications of high quality.

PERSONAL ATTRIBUTES

Calm hard-working developer

Committed with work

Reliable and responsible

Results oriented

Effective communication and writing skills

Good attitude and disposition

Adaptable to any team or work environment

Quick learner and always eager to learn new things

EDUCATION

Master of Computer Application (MCA) – Indira Gandhi University

Bachelor of Computer Application (BCA) – Indira Gandhi University

TECHNICAL SKILLS

Summary

●8 years experience in working different .NET framework versions 2.0, 4.0, 4.6 and 6.0

●5 years experience in developing windows applications (Winforms) using C#

●2 years experience in developing applications using WPF

●7 years experience in developing web based applications using ASP.NET, MVC 3, MVC 4 & Azure

●7 years experience in using data access layers API’s such as ADO.NET, LINQ, Entity Framework and Web API

●9 years of experience using different versions Visual Studio 2008, 2010, 2012 & 2017.

●4 years of experience using Third Party Tools such as DevExpress, Telerik, Flash & Adobe Dreamweaver.

●5 years experience in Jquery, JavaScript, REST, JSON, AJAX, HTML, CSS & XML

●1 Year experience in AngularJS, NodeJS & ReactJS

●9 years of experience using IIS 6.0 & IIS 7.0

●9 years of experience using Source Control Tools such as TFS, VSS & SVN.

●Strong knowledge in using the Object Oriented Programming concepts such as abstraction, encapsulation, polymorphism, interfaces and inheritance.

●7 years experience in working with RDBMS like SQL Server and different versions such as 2000, 2008 R2 and 2012

●7 years experience in using database objects such as stored procedures, functions, indexes and triggers

●2 years experience in MySQL and MS Access.

●4 years experience in using report generation tools such as Crystal Reports and SSRS.

●1 year experience in using ReSharper refactoring tool

●2 years experience in using Microsoft Unit Test Framework

●6 years experience in following Waterfall model

●1 year experience in following Agile model

WORK EXPERIENCE

Company

Fidelity Information Services, St.Petersburg, FL

Client

Fidelity Information Services

Duration

July 2016 to July 2017 (12 Months)

Role

Senior Software Engineer

Project: RTDX (Real-time DataXchange)

The API solution is to secure the existing Universal Data Interface (UDI) transactions being executed by current clients. Current UDI transactions will also continue to be offered to clients both existing and new, but all will be secured in a newly-created security administrative dashboard and function.

Responsibilities:

Created a Web Page for the newest version of the Real-time DataXchange using only HTML, CSS and AngularJS.

Developed the tool to auto format the given XML tags and validated the provided XML tags.

Created new reports using SSRS, reports where generated and displayed in the Real-time DataXchange Web application.

Created Unit Tests for the .NET Framework with the Microsoft Unit Test Framework for Managed Code

Used the ReSharper tool for refactoring the code.

Fixed visual design issues on existent reports (layout, text alignment, colors and fonts)

Extensive use of LINQ and C# for the reports code behind logic.

Used LINQ to Objects to work with big in memory collections of data for the reports.

Wrote T-SQL scripts and stored procedures that query financial data for the reports.

Created a small prototype version of encrypting the PCI data while storing in the database.

Code reviews for junior developers.

Technology Used:

Visual Studio 2012/2017, .NET Framework 4.6, ASP.NET 4.0, SQL Server 2012, jQuery, ReSharper, Voltage, OWASP, Firebug, and TFS

Company

Fidelity Information Services, St.Petersburg, FL

Client

Fidelity Information Services

Duration

Jun 2015 to Jun 2016 (12 Months)

Role

Senior Software Engineer

Project: eZDisclosure

EZDisclosure is an application that allows Financial Institutions to manage their regulatory requirements by allowing you to provide disclosures and cardholder agreement documentation.

Responsibilities:

Developed new Web Pages and artifacts for eZDisclosure application. Web application using C#, HTML, CSS, JavaScript, ASP.NET MVC 3 and 4, jQuery, AJAX, JSON, Views and Controllers.

Created small prototype version of validating the image whether it’s a black and white image or not.

Developed the module to create the “financial institutions terms & conditions” dynamically to generate in the format of “Ms Word, PDF and JPEG” using PDFLib.

Fixed visual design issues on existent reports (layout, text alignment, colors and fonts)

Extensive use of LINQ and C# for the reports code behind logic.

Used LINQ to Objects to work with big in memory collections of data for the reports.

Wrote T-SQL scripts and stored procedures that query financial data for the reports.

Technology Used:

Visual Studio 2012/2017, .NET Framework 4.6, ASP.NET 4.0, SQL Server 2012, jQuery, Voltage, OWASP, Firebug, and TFS

Company

Fidelity Information Services, Bangalore, India

Client

BB&T, Bank of America and Wells Fargo Bank

Duration

Sep 2012 to June 2015 – (33 Months)

Role

Senior Software Engineer

Project: eZCard

EZCard is a credit card management application divided into Admin and Client sides. Admin application allows administrators of the companies/departments to perform certain operations on credit cards/users such as generating reports, set alerts, enroll/approve users, manage credit expenses etc. Client side allows cardholders to login and perform transactions, check balance or update account information.

Project: PayEx (FIS Payment Exchange)

The PayEx product is a highly customizable payment solution for our clients. While the flow is similar per client program, some of the processes or steps as well as the details within each process may differ slightly. As a result, a separate PayEx Windows scheduler service will run for each client program. Each process updates the payment status, and generates the outputs/flat files and sends to the appropriate client location.

Responsibilities:

Developed a module called Expense management in eZCard application to maintain the expenses that happen in a company using C#, HTML, CSS, JavaScript and Ajax.

Created analysis artifacts for the existing EZCard application using VISIO diagrams.

Created new reports using C# and SSRS.

Fixed browser compatibility (Chrome and Internet explorer versions) issues on existing eZCard application (layout, text alignment, colors and fonts) using CSS, Firebug tool.

Wrote the unit test code for eZCard application with Microsoft Unit Test framework.

Wrote T-SQL scripts and stored procedures that query eZCard statistics reports using Crystal reports.

Developed windows application to process the flat files using file system watcher in C# in PayEx.

Prepared technical specifications and High Level and Low level design from requirements specifications.

Developed and implemented as per the specifications, working in small teams.

Handling enhancements and change requests to existing software systems.

Writing technical documentation for the modules developed.

Mentoring junior developers

Responsible for builds in PROD environment.

Coordinate with onshore team for requirements and other deliverables.

Technology Used:

Visual Studio 2012, .NET Framework 3.0, MVC 3.0, Winforms, WPF, SQL Server 2008 R2, Jquery, Voltage, Firebug, PDF Generator and TFS

Company

Smartek21, Chennai, India

Clients

Microsoft, Intelectual Venchers

Duration

January 2011 to September 2012 – (18 Months)

Role

Software Engineer

Project: MMIG Metrics Portal (Microsoft Internal Tool)

MMIG metrics application is to show the various report data on day basis in the tile. The tiles can be created based on the sections selection and the tiles are associated with the specific category names. The sections, categories and tiles customization can be done by using the portal editor which is another part of this portal. This application has the site map feature also. Site map will help to navigate to SSRS report files. The site map categories and report names can be customized in the portal editor.

Project: Helipad

Helipad is a product for maintaining and manages the Assets of Intellectual Ventures. It’s a light weight application for managing the assets with having speed and highly secured.

Responsibilities:

Worked on Agile SCRUM methodology for MMIG tool.

Developed MMIG project (Worked as Vendor for Microsoft projects) to show the website access reports in tiles using MVC3.0, JavaScript, Jquery, XML, SQL Server 2008 R2.

Developed reports to trace down the website access from Bing search using and SSRS.

Developed Link Management Tool (Microsoft internal tool) to create the meta tag in the images to track the no of clicks in the images provided using MVC 3.0, Jquery and XML.

Used IntStudio, Source Depot Browser and Scope tools to check in the Microsoft environment.

Developed SQL Server Analysis Service (SSAS) to import the Microsoft data from one database to another database.

Fixed browser compatibility (Chrome and Internet explorer versions) issues in helipad web application (layout, text alignment, colors and fonts) using CSS, Firebug tool.

Wrote the unit test code for helipad application with Microsoft Unit Test framework.

Used TFS to check in the helipad changes.

Preparing technical documents such as requirements and design specifications, understanding and help documents.

Developing the software by implementing the tasks which are assigned to me.

Giving project demo to the clients.

Communicated with onsite for work items delivery.

Technology Used:

Visual Studio 2010, NET Framework 3.5, Winforms, MVC 3.0, SQL Server 2008 R2, SQL Server Analysis Service (SSAS), SSRS, JavaScript, Jquery, XML, Telerik controls, IntStudio, Source Depot Browser, Scope, Firebug and TFS

Company

Infognana

Clients

TAB1099

Duration

April 2010 to January 2011 – (9 Months)

Role

Software Engineer

Project: TAB1099

The TAB1099 system provides a complete web-based solution for 1099 compliance. TAB1099 has all the features you need to meet IRS 1099 reporting requirements and gives you the tools to manage the entire processes scores for the users. RRA can be scheduled and reports can be automated.

Responsibilities:

Developed various tax processing templates using ASP.NET 2005, C#.NET, MySQL, JavaScript.

Used Photoshop, Microsoft Office Visio 2003, and Adobe Professional tools to create the tax processing templates design.

PDBLib tool was used to edit the existing PDF templates.

Used SVN tool to check in the TAB 1099 changes.

Preparing technical documents such as requirements and design specifications, understanding and help documents.

Communicated with onsite for work items delivery.

Technology Used:

Visual Studio 2008, NET Framework 2.0, Winforms, ASP.NET, MySQL, Navicat for MySQL, Photoshop, Microsoft Office Visio 2003, SVN, PDBLib Tool and Adobe Professional

Company

BOSCO ITS

Clients

Pawaa, Decapro and DBNF-YAR

Duration

June 2008 to April 2010 – (22 months)

Role

Trainee & Software Developer

Project: Pawaa Risk Rank Agent

Pawaa Agent is for data leakage preventive mechanism for systems connected in Internet or intranet. It gathers data based on the policies. There is a list of profiles created for risk factors. The factors may be individual event or sequence of events. Pawaa risk rank agent identifies the risks based on the rules and generates the risks scores for the users. RRA can be scheduled and reports can be automated.

Project: Marking (www.decapro.com)

It is a web based design tool, to design the T-Shirt and other available products by placing different pictures and text. Generate products for the list of players for a team rather than designing product for each player. Finally produce the BAT (pdf) files as an input for the printers.

Project: HomeLink

This HomeLink is software that networks all the children at risk in different and difficult circumstances in India. It helps in documenting the details of these children and uploading them to Missing Child Search (MCS) portal, through which public report missing and found children, and parents find their missing children. HomeLink brings together different regions of HomeLink organizations working for the children at risk into its network as Hub, Node, and Unit structures. Each main hub contains many organizations called nodes. And each node in turn contains many units (centers) working for the welfare of the young at risk.

Responsibilities:

Developed risk analysis reporting tool based on the user’s illegal activities(tracing clipboard activities) in a machine usingASP.NET 2008, C#.NET, SQL Server2005, MySQL and JavaScript.

Developed web application to design the t-shirts for the players using Flash MX 8.0 (Action Script 2.0).

Developed windows application to maintain the children missing using C#.NET 2005, MYSQL, XML and ADO.NET.

Understanding the product domain to implement the change requests of the customers.

Developing the software by implementing the tasks which are assigned to me.

Giving the product demo to the customers at the customer site as well as in the exhibitions.

Underwent training on C# 2003, C# 2005, ASP.Net, Project Development skills, Management Skills and various seminars on Project Development. Underwent intensive training based on the famous book CODE COMPLETE to be a very good programmer

Technology Used:

Visual Studio 2005/2008, NET Framework 2.0, Winforms, ASP.NET, C#.NET, MySQL/SQL Server 2005, JavaScript, XML, Flash MX 8.0 (Action Script 2.0), Macromedia Dream weaver, DevExpress, Clear quest, Fireworks, Photoshop, Visio 2003 and VSS.

Contact this candidate