.Net & SQL Developer

Archana Sivakumar

Email: *******@*****.***

Mobile: 858-***-****

Summary

. Over 5 years of experience in development, testing and integration of

windows applications and web applications using Microsoft .Net

Technologies.

. Experience in working in Waterfall and Agile methodologies (Scrum

model).

. Expertise in developing Windows Applications using .Net Framework

4/3.5/3.0, Enterprise Library, C#, ADO.NET, XML Web Services, IIS

7.0/6.0 and Infragistics and Visual Studio 2010/2008/2005.

. Specialized in developing ETL packages using SSIS.

. Expertise in database programming skills using SQL Server 2008/2005,

SQL Stored Procedures, functions, triggers, data migration from

various data sources.

. Experience in developing ASP .Net Web Applications.

. Experience in creating middle tier components including creating

business components, data models and data access components in multi

layered applications and MVC design patterns.

. Experience in using Infragistics controls for windows and web

applications.

. Requirement gathering and documentation, system analysis,

architecture, design & development of multi-tier applications and MVC

patterns.

. Experience in developing POC's with API's.

. Expertise in GUI testing, database testing, unit testing, integration

testing, system testing and regression testing of windows

applications, web applications, SQL and ETL packages and writing test

cases for the same.

. Involvement in preparation of test scenarios, test cases and executing

the same.

. Experience in writing unit tests and integration tests using mocking

frameworks.

. Excellent communication and interpersonal skills. Ability to work in a

team and individual environment.

. Excellent ability to work in shorter sprints.

Skillset

.NET Technologies C#.NET, ASP.NET, ADO.NET,

Web services, Enterprise Library 4.1/5

Tools Rhino mock, Infragistics, StyleCop

Databases MS SQL Server 2008/2005

ETL SSIS

Tools Microsoft Visual Studio 2010/2008

App servers / Web servers MS IIS 6.0/7.0

Web Development HTML, JavaScript, CSS, AJAX, Jquery

Configuration Management VSS, TFS

Test management tools Visual studio team foundation, Bugzilla,

JIRA

Education

Bachelor of Engineering in Computer Science, Anna University, India.

Certifications

. Microsoft Certified Technology Specialist

. Microsoft Certified Professional - Developing and Implementing Windows

Applications with Microsoft Visual Studio .NET

Work experience

Working with Infosys Limited since November 2008 currently as a Technology

Analyst for Intel client at onsite.

Projects worked on

. Project Name : AppUp

. Client : Intel Corporation, Hillsboro- Oregon

. Role : Technology Analyst

. Duration : December 2012 to till date

. Technologies : C#, .NET 4.0, JavaScript, Jquery, XSLT

. Description : The Intel App-Up is a one stop PC application store

where we will find tons of apps ranging from functional to fun. The

App-up center is a Client where we have to download an .exe file and

install it on our machine. Once we install it, we have to Sign up and

signing up grants you access to all your apps on up to five PC's. Then

User searches for different apps and download them.

It has three major components, Developer Portal (where apps are

submitted by publishers), Store Partner portal (Store Management) and

Client (End user who purchases the apps). The project involves testing

of these three components individually as well as end to end

integration testing of these components. App Store is tested by

purchasing different apps through UI or Soap request, validating the

UI and the back end changes for SPP, developer Portal and Localization

testing of the Client, Developer Portal. Also testing is done on

verifying the OS compatibilities, download and install of various apps

i.e. .Net, Java, etc. from the store. Also Integration testing is done

for the Store integration with third party vendors.

. Responsibilities:

. Analyzing the existing applications.

. Discussions to understand the current business model with

client.

. Documenting the current business model.

. Requirements gathering and documentation.

. Worked on project by agile development methodology.

. Developed POC for the purchase module with distributor API.

. Developing "Purchase and Price Management" module.

. Programmed for purchase module webservice using C#, interface,

StoredProcedure, functions and triggers(sql).

. Created web page for Price management of Apps using VS2010 in

C#,Asp.Net controls, JQuery, creating tables, views, stored

procedure, functions and triggers (sql)

. Created a Apps Preview page to show details of individual apps

from xml like publisher, price, Os \Rating\Category Mapping,

Status(New or Published), locale using XSLT, C#,CSS, Jquery, SQL

back end - Stored Procedure using joins and subqueries.

. Created scheduled job to queue up the import apps process using

C# and Sql backend.

. Created SQL scripts to clean up data which helped in solving

data issues.

. Normalized tables and Used lock hints like nolock for better

performance and efficiency

. Creating unit tests and integration tests using Rhino Mocks unit

test framework.

. Involved in Test Plan, Test Case Design and their Reviews.

. Providing support for Production system by resolving technical

issues, user related issues and

change requests (enhancements).

. Created technical document.

. Worked on deployment activities.

. Responsible for Knowledge Management.

TOMRA client May 2009-Nov 2012

. Project Name : E-Comm

. Client : Tomra

. Role : Senior Software Engineer, tester and configuration

controller.

. Technologies : C#.NET 4.0, Entity Framework, Enterprise library 5

. Duration : June 2012- Nov 2012

. Description : E-Comm is a long polling web application using comet

programming which displays status of SQL jobs at real time using SQL

dependency and windows services to schedule and monitor SQL jobs.

. Responsibilities:

. Designing UI layouts and implementing the web user interface,

job scheduling windows services and SQL dependency module and

the exception handling module.

. Created UI for creating new job and selecting different field

and validating using C#, Linq and entity framework

. Created exception handling using enterprise library 5

. Creating a test user interface to simulate SQL jobs for testing

and to provide mock data for regression testing by creating 100

jobs per second and manual testing of functionality, performance

and recording the throughput of the application.

. Writing unit tests and integrations tests using mocking

frameworks for the data-model layers and services.

. Functionality testing and regression testing.

. Deployment activities.

. Acted as configuration controller and Knowledge management

anchor.

. Project Name : Barcode Management System

. Client : Tomra

. Role : Senior Software Engineer and Tester

. Technologies : C#.NET 3.5, SQL Server 2008

. Duration : 8 months

. Description : BAM is a windows application which takes care of

authorization and de-authorization of the suppliers, distributors and

retailers which serves as the input for the billing. The BAM

application also takes care of validating the transactional files

downloaded from the Reverse Vending Machines (RVM) during the billing

cycle and providing the validated data as input for invoicing. This

application is integrated with every other billing application used by

the client to validate the correctness of the billing data.

. Responsibilities:

. System analysis, requirement gathering and documentation.

. Coding of barcode authorization and validation module in VS2008

using c#, Stored Procedure using cursors, creating tables,

views.

. Scripting in SQL to check and display data inconsistencies,

which was extensively used for manual testing for which an award

was received.

. Modified existing Stored Procedures as per new business

requirements

. Used SQL Server Profiler to monitor the performance of the

stored procedures and functions.

. Functionality testing and regression testing.

. Fixing functionality issues faced by the client.

. Responsible for source code management, control and module

integration.

. Acted as configuration controller and Knowledge management

anchor.

. Involved in anchoring Employee engagement activities.

. Project Name : Appointment Booking

. Client : Tomra

. Role : Senior software engineer, subject matter expert and

configuration controller

. Technologies : C#.NET 3.5, SQL Server 2008

. Duration : 12 months

. Description : Appointment Booking is a windows application to enable

users to schedule pickup and deliver supplies by creating appointments

and other functionalities. This application reduced customer service

and dispatch calls which improved the client's operational efficiency

in transport group.

. Responsibilities:

. Requirements gathering and documentation.

. Developed permission module using C# and Sql db.

. Create and Edit of Appointment booking module as windows

application using C#, SQL StoredProcedures, triggers, views.

. Create joins and sub-queries for complex queries involving

multiple tables.

. Deployment, code reviews and team coordination.

. Conduct periodic configuration audits and meetings as

Configuration Manager to evaluate the quality of the project and

helped avoid version issues.

. Tester during the system-testing phase. Application level

tracing, debugging and Involved in Unit testing, System testing

and UAT.

. Project Name : Material Handling System

. Client : Tomra

. Role : Software Engineer

. Technologies : C#.NET 3.5, SQL Server 2008

. Duration : 12 months

. Description : MHS is a web application to manage material handling for

the various stores and distributors in the material handling business

working with Tomra. This application helped the users order supplies

which were used by the drivers using their handheld devices to

determine the road paths and orders to be handled for the day. The

drivers would also use this app to input data such as time stamps,

odometer readings, order status etc. which were used by the road

mapping program to determine the best road paths for the drivers.

. Responsibilities:

. Understanding the existing applications.

. Handling support tickets and implementation of enhancement

requests in existing web application using C#, infragistics

grid, Ajax, file transfer, xml import, Javascript, IIS6, Sql

StoredProcedures, scripts, creating Tables, views.

. Involved in developing ASP.Net pages which acts as a user

interface using infragistics grid, Javascript.

. Designed WebService components for Business Components and

Business Facades.

. Used ADO.NET to develop Data Access Layer, which communicates

with MS SQL Server.

. Data migration from EXCEL to SQL Server

. Data migration and performance tuning of SSIS packages.

. Collating business and technical knowledge as SME into wiki.

. Achievements :

. Suggested to use ticket tracking system for application level

support to log any issues/request .This resulted in better

tracking, prioritization, SLA management and reporting.

Archana Sivakumar

Contact this candidate