Anuj Gupta

Phone: 502-***-****

Email: ac26qf@r.postjobfree.com

Senior Dot Net Developer

Quick learner, creative problem-solver with extensive experience in high-pressure environments along with strong object-oriented programming expertise. Recognized for outstanding ability to establish and foster strong relationships with clients and employees throughout all levels of the organization. Utilizes strong programming and management skills to achieve continued success and exceed corporate expectations. Areas of expertise include:

.Net Developer – Programming – Documentation – Negotiations – Training & Development – Communications – Service – Process Improvement – Problem Resolution

SUMMARY:

12+ years of IT experience in Software Development and implementation in the areas including Internet/Intranet technology, Web Applications, Web Services, DBMS, Client Server (Multi Tier Architecture) applications, Project Management, Life Science and Health Care Insurance, Human Resource & Financial Applications

Extensively followed Waterfall methodology (Iterative) and extreme programming for software development

With over 3 years involvement in a client facing environment as Designer/Analysts for requirements gathering

With more than 4 years’ experience as project team lead in multiple projects

Extensive experience in developing applications using .NET Framework 1.1, 2.0, 3.0, 3.5 and 4.0.

Experience on development of ASP.NET, MVC Framework, C#.NET, Win Forms, Web forms, ADO.NET, Web Services, XML, XSLT, Java Script, JQUERY, JSON, HTML, IIS, Window Services, AJAX,MS Sharepoint, MVC, and Web services, Console and Active Directory applications

Understanding of Knockout JS JavaScript framework.

Experience in middle ware - using MS SQL Server for data processing

Experience in writing Database Queries, Stored procedures, Triggers and background jobs in SQL Server

Strong Object Oriented (OOPS) programming skills as extensively used C# to develop the middle tier of the applications.

Experience in design and development of Database.

Experience in working with Visual Source Safe (VSS), Team Foundation Server (TFS), SVN, and RTC Source control tools.

Strong analytical skills with proficiency in debugging and problem solving.

Have good experience in building ETL jobs using SSIS

Experience in code debugging using advanced tools like Fiddler and Developer Tools (Chrome/Firefox/IE)

Excellent communication skills and the ability to work indepently or in a Team environment

Excellent analytical and problem solving skills.

TECHNICAL SKILLS:

Languages

C#, VB.NET, Visual Basic, VBScript

.NET Technologies

ASP.NET, C#.NET, WCF, Web Forms, Windows Services, XML, XSLT, LINQ

Web Technologies

ASP.Net, Web Services, AJAX, HTML5, CSS3, JavaScript, jQuery, IIS, JSON, Bootstrap

Database Servers

MS SQL Server 2000 / 2005/2008/ 2010

MS Access

Operating Systems

Windows 98/2000/XP/Windows7/2012

Application Servers

IIS 6.0 /7.0 / 8.5

IDE / Utilities

Visual Studio .NET 2003/2005/2008/2010/2013, 2015

MS Visio

Source Control Tools

MS Visual Source Safe (VSS), TFS, SVN, RTC

End User Data Access tools

Crystal Reports, SSRS

Methodologies

Agile, Waterfall, Iterative

Educational Qualification:

Masters in Computer Applications in June 2005 from Guru Govind Singh Indraprastha University, India

PROFESSIONAL SUMMARY:

Client : Frontier Communications, WA - USA June 2017 – Present

Frontier Communications Corporation is a telecommunications company in the United States. Frontier is the fourth largest provider of digital subscriber line (based on coverage area) in the United States. In addition to local and long-distance telephone service, Frontier offers broadband Internet, digital television service, and computer technical support to residential and business customers in 29 states in the United States.

1.)Project : Triton UI

Role : Developer

Description: Triton UI is a WinForms companion call center application for Order/Service Writers to retrieve account/order details. This utility provides clearer data interpretation for users who previously relied on text output from AS400 Green screen terminals and VBS Scripts.

Roles and Responsibilities:

Involved in requirements gathering of the project

Involved in the development and unit testing of the Application

Working on creation of Sql Queries and Stored Procedures using SQL Server 2012

Used TFS as the Source Control in working on enhancements requests

Worked on creating deployment plans and providing deployment support.

Environment: C# 4.0/3.5, SQL Server 2012, Visual Studio .NET 2017, TFS

Client : Safeco Insurance (now Liberty Mutual), WA - USA Sep 2014 – May 2017

Liberty Mutual Insurance, is an American diversified global insurer, and the second-largest property and casualty insurer in the United States. It ranks 76th on the Fortune 100 list of largest corporations in the United States based on 2013 revenue based in Boston, Massachusetts.

2.)Project : Agency Compensation Center

Role : Tech Lead

Description: Agency Compensation Center is a website for Safeco’s agents wherein they can Electronically sign the Profit Sharing Guarantee & Stop Loss Election documents for the current Election year.

Roles and Responsibilities:

Involved in requirements gathering of the project and design and development of the Database as well as the application using ASP.NET MVC, jQuery, HTML5, CSS3, Json, KnockoutJS

Involved in the development and unit testing of the Application

Involved in making offshore understanding the requirements and their queries about requirements resolved from client.

Designed the SQL database using SQL Server 2012 and created Stored Procedures

Used RTC as the Source Control in working on enhancements requests

Worked on creating deployment plans and providing deployment support.

Maintain client expectations on supported by applications by providing 24x7 support thru bridge calls and contacting business users directly

Environment: C# 4.0/3.5, ASP.NET MVC 4.0, SQL Server 2012, Visual Studio .NET 2012, Web Services, AJAX, Json, CSS3, HTML5

3.)Project : Kaltura SSO

Role : Tech Lead

Description: Created a Single Sign-On portal for the Safeco Insurance’s agents using which the agents can sign-in to a Vendor maintained Videos’ website.

Roles and Responsibilities:

Involved in requirements gathering and creating the functional design of the application using ASP.NET, JavaScript.

Identify problems during the development, escalated as soon as it arrives and proposed and implemented solution

Worked solely on the application

Co-ordinated directly with the Vendor for the Single Sign-On requirements

Used RTC as the source control of the project

Point of contact on the progress of the project, reports directly to the management team

Environment: C# 4.0, ASP.Net, jQuery

4.)Project : Loyalty Rewrite Reports

Role : Tech Lead

Description: The Loyalty Rewrite Reports application shows the Rewrite Remaining/Used reports for the agents. The application fetches the data from a web services and then formats and displays the data to the end user.

Roles and Responsibilities:

Involved in the requirements gathering of the Project

Provided timeline and work plan

Designed the front-end of the application in ASP.NET MVC using HTML5, CSS3 and used jQuery, JavaScript & Json

Was involved in design of the Database using SQL Server 2012

Designed the Database and created Stored Procedures for the application

Co-ordinated with the team on the development of the project

Reviewer of technical and functional designs as well as other artifacts such as deployment/mitigation plans and risk and impact analysis

Conduct peer review on submitted modules

Used RTC as the source control repository

Created a batch job which gets a plain text data file from the source location and updates the Database with the data of the Agent codes

Environment: C# 3.5, RTC, Visual Studio 2015, SQL Server 2012, Web Services, jQuery, CSS3

5.)Project : ACE

Role : Enhancements to the application

Description: ACE is used to capture and assign insurance leads. A lead is a partial or completed quote for an insurance policy. In case of standard policy types, an agent is assigned by ACE and then control is given to the CQT (Customer Quote Tool). The assigned agent has to contact the customer and issue the policy.

Roles and Responsibilities:

Responsible for doing the enhancements to the ACE application

Responsible to support the Batch jobs which used to do the calculations and update the tables in the ACE Database.

Environment: Team Foundation Server 2010, ASP.NET MVC, Visual Studio 2010, C# 3.5, JavaScript, CSS, Web Services

Client : Humana Inc., Louisville - USA Sep 2010 – Aug 2014

Humana Inc. is a for-profit American health insurance company based in Louisville, Kentucky. As of 2014 Humana has had over 13 million customers in the U.S. and has had over 52,000 employees. In 2013, the company ranked 73 on the Fortune 500 list, which made it the highest ranked (by revenues) company based in Kentucky. It has been the third largest health insurance in the nation.

1.)Project : Gaps in Care

Role : Senior Software Developer

Description: The project involves development of SSIS packages for data loading from Claims files and loading it to our own Database. This data is used to analyse the Gaps in Care and then providing a report to the members (people having insurance with Humana) with the information regarding any possible Gaps (shortcomings) which could be taken care of and this will benefit the members in taking measures to take care of their health and be less prone to possible healthcare issues.

Roles and Responsibilities:

Developed the SSIS packages to load the data into the Database

Worked with the Architect directly for the development of the SSIS Packages

Wrote complex queries to fetch the data from multiple sources like flat file or CSV files

Was involved in release and deployment of the SSIS packages

Create detailed design to determine the actions needed to take for migration

Involved in scheduling the packages

Environment: Sql Server 2008, SSIS, T-Sql

2.)Project : ETSS

Role : Tech Lead

Description: The Electronic Transmissions Self Service (ETSS) is an application which is used to make the configuration for a third party software system. This this party system is used to transmit the Enrolment files to/from Humana from/to its Trading partners. The data entered into this application is required for the third party software system to transfer the files on a scheduled basis and in a pre-defined format with encryption and compression being applied on the files being transmitted.

Roles and Responsibilities:

Developed the Web application using ASP.Net, Linq & WCF Service.

Involved in designing the web pages with rich UI using CSS and Ajax

Worked on data layer using Entity Framework approach

Lead the project and reviewed the Offshore deliverables

Developed SSIS packages and SSRS reports

Created Stored Procedures for data interaction with the Database

Optimized the existing Stored Procedures

Was responsible for the deliveries and deployments

Worked in Agile methodology

Using Microsoft Team Foundation Server for the version control

Communicated with the client for working on and prioritizing the requirements, documenting the technical specifications and communicating the same to the team

Rolled out the changes in the production and performed the integration testing

Environment: ASP.Net 3.5, C#, Ajax, CSS, Visual Studio 2010, Entity Framework, WCF, Sql Server 2008, SSIS, SSRS

3.)Project : Data Measurement and Reporting

Role : SSIS/SSRS/Sql Developer

Description: The Data Measurement and Reporting involves development of SSIS packages for Data loading and various systems like EDW/SDR and loading it to our own Database. This data is used to prepare various Reconciliation Reports for the Management which gives them an overview of the match in the percentage of the members between the source systems and the target systems. Any major variances are further analysed and reported with the reason for the variation.

Roles and Responsibilities:

Documented the Business requirements and technical specifications

Involved in designing of the Database

Worked on creation of the SSIS packages to load data from different flat file sources

Worked on logging the ETL package errors and communication of the same to the end users via automated Emails

Developed SSRS reports represented with Graphs for higher management

Involved in design and development of the SSIS packages and SSRS reports

Using Microsoft Team Foundation Server for the version control

Rolled out the changes in the production and performed the testing

Environment: Visual Studio 2010, Sql Server 2008, SSIS, SSRS

Team Lead - Logiciel Information Systems Pvt Ltd. April 2008 – Aug 2010

(Avalon Group)

Managed developers and P&M sheets. Assigned tasks, deadlines and reviewed the work and provided and effective and efficient solutions to the queries. Designed the Unit Test cases, URS and SRS before the development work. Provided solutions/support to the clients that were encountered while working with the product. Developed user control, business logic, Data access layer and part of the web application.

Project Details

1.CRING Info

Tools and Technologies: - ASP.Net, C#.Net, SQL Server 2008, XML, JavaScript, CSS

Description: – CRING Info provides a web based solution that helps the UNICEF to monitor the targets achieved by the countries. It has various levels of users that validate the data entered by the lower level. Users have the option to export the data view on to the excel sheet with various level of validations and import it back to the database after entering the new data points. It works on the two databases i.e. staging and final database. Options for visualizing the target and the value points were available. It functioned on two databases i.e. staging and final database and had the option to visualize the target and the value achieved against any indicator through web service and finalize database of accepted values through common database (staging database).

Roles and Responsibilities:

Involved in the requirements gathering of the Project

Provided timeline and work plan

Designed the front-end of the application in ASP.NET using HTML, CSS and used jQuery, JavaScript, Ajax

Was involved in design of the Database using SQL Server 2008

Designed the Database and created Stored Procedures for the application

Co-ordinated with the team on the development of the project

Conduct peer review on submitted modules

Used TFS as the source control repository

2.DevInfo(DI) 6.0

Tools and Technologies: - ASP.NET 3.0, C#.Net, VB.Net, SQL Server 2008, MS-Access, JavaScript, AJAX, CSS, XML

Description: – These systems had been endorsed by the UN Development Group. DevInfo 6.0 is an advanced database on Social Development Indicators or Millennium Development Goals to keep track of the commitments towards human development. It gives more options in querying for data and help to undertake results-based monitoring and effective advocacy. DevInfo 6.0 includes powerful data presentation methods and extended mapping features.

Roles and Responsibilities:

Involved in the requirements gathering of the Project

Provided timeline and work plan

Designed the front-end of the application in ASP.NET using HTML, CSS and used jQuery, JavaScript, Ajax

Was involved in design of the Database using SQL Server 2008

Designed the Database and created Stored Procedures for the application

Co-ordinated with the team on the development of the project

Conduct peer review on submitted modules

Used TFS as the source control repository

S/W Developer – Agile Info Systems Pvt Ltd April 2006 to April 2008

Responsible for S/W development which included the management of the entire process i.e. detailed analysis to implementation of the software. Handled Client interaction for requirements gathering and time estimation. Prepared various technical and user oriented documents like Project specification documents, User manuals, etc.

Project Details

1.Web Harvesting

Tools and Technologies: - ASP.NET 3.5, C#.Net, IMacros (Iopus), SQL Server 2005, XML, Windows Service

Description: – An Application developed for harvesting information using Web Scraping technology from the Records Index sites (e.g. http://philadox.phila.gov/) and present the data to the user for analysis.

Roles and Responsibilities:

Involved in the requirements gathering of the Project

Provided timeline and work plan

Designed the C# Windows application showing the records of harvesting

Created service using C# using IMacros for harvesting the records

Was involved in design of the Database using SQL Server 2005

Used TFS as the source control repository

2.Distance Learning

Tools and Technologies: - ASP.NET 2.0, VB.Net, SQL Server 2005, JavaScript, CSS, Ajax

Description: – An Application developed for Indian Army using which training is provided to Army personnel in Remote locations. The user can login to the portal using his username & password and can attend live sessions and can view various files uploaded by the Admin as well as access the portal for various other functionalities.

Roles and Responsibilities:

Involved in the requirements gathering of the Project working directly at the Client-site with the Indian Army

Provided timeline and work plan

Was involved in the designing of the Distance Learning portal

Creating the portal using ASP.Net, C#, Ajax, JavaScript, HTML, CSS

Was involved in design of the Database using SQL Server 2005

Used TFS as the source control repository

S/W Developer – Planet E-Com Solutions Pvt Ltd April 2005 to March 2006

Dedicatedly responsible for In house S/W development which included the management of the entire process i.e. detailed analysis to implementation of the software. Handled Client interaction for requirements gathering and time estimation. Prepared various technical and user oriented documents like Project specification documents, User manuals, etc.

Project Details

1.Web Content Management System

Tools and Technologies: - ASP.NET 2.0, Oracle 9i

Description: – The Web Content Management System is a Web application which enables the updation of the Content on the Front-end Website of CERT (www.cert-in.org.in).

Roles and Responsibilities:

Involved in the requirements gathering of the Project

Provided timeline and work plan

Worked on the web application using JSP

Educational Qualification

Course

University/Board

Year of passing

A.I.S.S.E.

C.B.S.E. (New Delhi)

1996

A.I.S.S.C.E

C.B.S.E. (New Delhi)

1998

B.Com (Hons.)

Delhi University, Delhi

2001

M.C.A.

GGSIPU, Delhi

2005

(ANUJ GUPTA)

Contact this candidate