ANJAN SINGH

Email :ac3fij@r.postjobfree.com

Contact : 510-***-****

Summary:

* ***** ** ********** ** system analysis, design, development, Support and maintenance of business applications in client/server technology, three tire architecture and web development using MVC.

Over 2 years of experience of leading team (3 members) spared in multiple geography.

Extensive experience in Client Facing Role.

Over 7 years of experience in Retail domain.

Extensive experience in managing and working with teams in offshore - onshore model.

Experience in client facing roles in US, process documentation, people management.

Extensive experience using C#,WCF, VB.NET, ASP.NET, MVC 5, REST, IIS, Entity Framework, NuGet, Web services.

Worked in project extensively using Agile and SCRUM methodology. Experienced in JIRA

Worked in a Web based project extensively using JavaScript and CSS.

Experience in Configuration and Version Management using Team Foundation Server (TFS)

Expertise in designing and developing WCF based services using SOA architecture.

Software architecture designing experience using MS Visio.

Extensive Experience in MVC and Entity Framework using Moq and Dependency Injection (IoC).

Experience with Design Patterns, Multi-tiered Component-based Modeling and Object Oriented Programming.

Expertise in Database Design and Programming (Stored Procedures, Functions, Triggers, Views) using SQL Server 2000/2005/2008/2012.

Experienced in hosting and configuring web applications in Internet Information Services (IIS)

Hands-on experience with SQL Server Integration Services (SSIS) for ETL.

Technical Skills:

Business requirement analysis

Code development and deployment

Project build management

Unit testing

Project functional and technical documentation

Source code management

Post production stabilization and support

Web Technologies: .NET (2.0/3.5/4.0/4.5), VS 2005/2010/2012/2013, ASP.NET, VB.NET, C#, MVC 5, WCF,LINQ, REST,Entity Framework, Enterprise Library, JavaScript, JQuery

Database: SQL Server 2008/2012

Tools: Team Foundation Server (TFS), SQL Server Integration Services(SSIS), Dreamweaver

Professional Experience:

Client : Levi Strauss & Co., San Francisco

Project : BackOffice_Mobility

Role : Technology & Team Lead

Duration : Nov 2013 – Current

Project Description: The client business is expanding its footprint across the globe and the aim of the engagement is to consolidate and upgrade the Retail applications and database instances across the various regions to support the growing business needs and also to enhance the digital capabilities of the client by introducing new solutions. As part of these endeavors we introduced Back office mobility application. This mobile solution automates store tasks including receiving, sales floor replenishment, stock and price look-ups, return to vendor, store to store transfer and stock taking which makes store back office operations more effective.

Responsibilities:

Requirement gathering sessions with client.

Prioritization, effort & resource estimations and planning.

Prepared and tracked project timelines

Developed proof of concepts as designed by the solution architect.

Setup development environment.

Discussion in designing app templates and wireframes.

Code development using C# and WCF. Used JSON as request and response format and backend in SQL Server 2008.

Created stored procedure, function, views in SQL Server for data logic.

Developed logging component for proper logging of service calls and capture exception for better debugging of code

Regular check in and check out in TFS with proper comments.

Created functional and technical documentations.

Contributed towards QA planning and UAT.

Prepared status and usage reports.

Involved in rollout plan and implementation.

Provided stabilization and transition to Support Teams.

Environment: .NET Framework 3.5, C#,WCF, MVC, VS 2010, SQL Server 2008, Agile Methodology, TFS,MS Visio.

Client : Levi Strauss & Co., San Francisco

Project : RFID Interfaces

Role : Technology & Team Lead

Duration : Jan 2015 - Current

Project Description: The aim of this engagement was to provide inventory accuracy as perfect as possible. The current inventory management system provides accuracy up to 65-70%. By implementing RFID in stores across all US locations, system will be able to achieve accuracy up to 95% and also eliminate the need for physical inventory count. Developed two interfaces Inventory Snapshot and Inventory Movement using SSIS Snapshot will run every night and fetch inventory data after a day’s business while the movement interface will run every 5 minutes giving most current inventory count.

Responsibilities:

Requirement analysis

Defined project time line

Prepared technical and functional documentation

Develop SSIS packages and build SQL objects to achieve desired result.

Unit testing and Back end Integration

Build Release

Deployment and post production support

Code walkthrough with client

Environment: SQL Server Integration Services (SSIS), SQL Server 2008 R2, Agile Methodology, TFS,MS Visio.

Client : Wyndham Hotel Group, Kolkata

Project : Request Management Tool

Role : Team Lead & Developer

Duration : April 2011- Nov 2013

Project Description: Client is world’s one of best brand name in Retail and Hospitality domain. The Project is to develop a Request Management Tool that will enable client to raise online request for various requirements for their day to day business. The application will also track request status and enable end user/business user take necessary action towards request completion process.

Responsibilities:

Understanding the business requirement and create BRE (Business Requirement Estimation) document and get Signoff from customer to proceed for development.

Understanding the requirements to be implemented in the application

Designing/ Developing applications using .NET 4.0 functionalities and Razor view engine

Developed logging component for proper logging of service calls and capture exception for better debugging of code

Created loosely coupled dependent components using DI container.

Preparing text execution reports.

Used Moq framework to create mocking objects to test unit test components efficiently. Unit testing deliverables for defect free delivery.

Bug fixing and support.

Environment: .NET Framework 4.0, C#, MVC, VS 2010, SQL Server 2008, Agile Methodology, TFS,MS Visio.

Client : Walmart Inc., Kolkata

Project : Retail Link Migration & Walmart Store Number Expansion

Role : Sr .Developer

Duration : May 2010- April 2011

Project Description: The main objective of the Project RLM is to migrate applications built in older technologies into most recent technology for better performance as well as to provide enhanced security. With the business expanding all over the world Wal-Mart needed to increase their maximum store number limit from 4 digits to 5 digits. The main objective of the Project is to analyze existing application codes/logic and identify/capture the part into excel sheet that need to be modified for the required expansion.

Responsibilities:

Understanding the business requirement and create BRE document and get Signoff from customer to proceed for development.

Understanding the requirements to be implemented in the application

Designing/ developing applications using .NET3.5 with .NET2.0 functionalities.

Developed application in three tier architecture and used .NET 3.5 features of master/content pages for a uniform look and feel

Developed logging component for proper logging of service calls and capture exception for better debugging of code

Created tabled,stored procedure, function as per need to support database related activities.

Preparing text execution reports.

Unit testing deliverables for defect free delivery

Bug fixing and support

Environment: .NET Framework 3.5, C#, ASP.NET, VS 2008, SQL Server 2005, Agile Methodology, TFS,MS Visio.

Client : Levi Strauss & Co., Kolkata

Project : SSIS Pivot Link

Role : Developer

Duration : Dec 2009- April 2010

Project Description: PivotLink is third party reporting tool which provides reports such as sales, Inventory, Cost price etc. PL doesn’t have direct access to Raymark DB and for this we needed to write ET jobs (ETL) for the entire data needed for PivotLink

Responsibilities:

Understanding the business requirement.

Understanding the requirements to be implemented in the application

Developing SQL Server packages as per requirement.

Environment: SQL Server Integration Services (SSIS), SQL Server 2008 R2, Agile Methodology, TFS,MS Visio.

Client : netGuru Limited, Kolkata

Project : ERP System

Role : Developer

Duration : July 2007- Dec 2009

Project Description: This web-based application will facilitate preparation of Quotations and Orders,

Preparation of Purchase Orders, manage inventory, calculate sales commissions. Different users of the software will have different access levels. Administrative users will have access to all parts of the system. They will also have privileges to add, modify and deactivate other users and their access levels.

Responsibilities:

Understanding the business requirement.

Understanding the requirements to be implemented in the application

Developing SQL Server objects and .NET application as per requirement.

Developed logging component for proper logging of service calls and capture exception for better debugging of code

Unit testing and bug fixing

Environment: ASP.NET 2.0, SQL Server 2005, Agile Methodology, TFS,MS Visio.

Client : AMB Computer Integrated Engineering Pvt Limited, Kolkata

Role : Developer

Duration : May 2005- June 2007

Project Description: Worked as a Consulting Engineer in the Organization which carries out the digitization of Electrical drawings of Electrical Power Plants, Oil Industries etc. in soft media using E-CAD software Promis Engine.

Responsibilities:

Understanding the business requirement.

Creating/designing document as per requirement and establish reference in system diagram.

Education:

Bachelor of Technology, (Electrical Engineering)-2004, Netaji Subhash Eng. College/University Kalyani

Class XII, Narikel Danga High School

Contact this candidate