SUMMARY:

• Technology Analyst/Lead with approximately 10+ years of experience in Retail Industry Processes, Retail Systems / Solutions engineering and Business Consulting. Extensive experience in operations, business analysis, development and support, communications with Subject Matter Experts (SMEs), performing Requirements Gathering and testing.
• Experience working in IT industry in Retail, Merchandising, Labor Management, Warehouse Management, E - commerce, Pricing/Promotion, Supply Chain processes, Order Processing, Customer Marketing, Store Systems, Payment Processing Systems etc.
• Experience in Production Application support and Excellent analytical & problem-solving skills.
• Experience in building Stored Procedures, Triggers and Views on various databases like SQL Server, Informix, Terra Data. Have knowledge on Mongo DB.
• Expertise in Tuning of Procedures, Packages, SQL Statements
• Experience in MSBI (SSIS, SSRS, SSAS).
• Experienced in all phases of Software Development Life Cycle (SDLC). Used both Agile and Waterfall Model for development and Hands on experience with build tools like ANT and Hudson.
• In Depth knowledge in Analysis, Design, Testing and Deployment of Web, Client Server and 3-tier applications using Microsoft .NET framework programming language such as .NET Frameworks 4.5/4.0/3.5/3.0 using ASP.NET MVC4 4/3, ASP.NET Web Forms, C#.Net, WPF, WCF, Web API, ADO.Net for Web and Windows based Applications.
• Expert in using Web development tools like HTML5, JQuery, CSS, JavaScript, AJAX and AngularJS.
• Experience in designing responsive, scalable web applications
• Experience with styling, theming, and layout frameworks such as Bootstrap, Material UI
• Experience with web application servers including IIS and Node.js
• Experience with build and package management tools for web applications including NPM, Yarn, Bower, Grunt
• Knowledge of development tools such as Git, JIRA and Confluence
• Experienced in data modeling using Entity Framework, LINQ, shell scripts, Perl Scripts batch scripting and C++.
• Sound proficiency in analyzing and creating use cases, Use Case Diagram, Sequence Diagrams, Data Flow Diagrams and Business Flow Diagrams using MS Visio.
• Proficient in creating Business Architecture, Business Requirement Documents (BRD), Functional Specification Documents (FSD), UAT documents.

TECHNICAL SKILLS:

Operating Systems: Windows XP/Windows 7,10 Windows Server 2003, Unix, Linux

Database / RDBMS: MS-SQLSERVER 2005/2008/2012/2016, DB2, Informix, UDB, Teradata, MongoDB

Programming Languages: C#, .NET, VB.NET, C, C++, Shell Scripting, VBA

Logging Framework: Log4Net & Common-logging

IDE: Microsoft Visual Studio.NET 2005/2008/2010/2012, 2015 MSBI, Visual Studio Code

Tools: Putty, HP Quality Center, HP Performance Center, ARIS 7.2, BMC Remedy client, Beyond Compare, IIS 6.0, Sonar & QMF

.Net Technologies: ASP.NET MVC4, ASP.Net Web Forms, WPF, ADO.Net, WCF, MS Entity Framework, LINQ, ASP.NET Web API, Windows Services

Front end Technologies: AngularJS, HTML, JQuery, AJAX, JavaScript

Version Control: Tortoise Subversion (SVN ),VSS,TFS, GIT

Modelling Tools: MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Bentonville, AR

Senior Developer, Lead

Responsibilities:

• Responsibilities involved requirements gathering and developing new modules for Quote Management in C# .net.
• Involved in Web Application using MVC4.
• Created Restful services using ASP.NET Web API .
• Developed frontend using AngularJS .
• Developed UI with HTML5/CSS3 .
• Used Bower -package Manager for frameworks and libraries
• Implemented T-SQL Queries, Stored Procedures and Triggers on SQL server and informix
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus on SQL server and Informix
• Used GIT Repository for the purpose of version Control and source code maintenance needs.
• Used Jenkins to automatically deploy code to lab servers.
• Written Karma testcases for AngularJS validation.
• Written Unit testcases and Integration testcases for developed modules.
• Performed code reviews for other developers.
• Involved in acceptance testing with Business users.
• Implemented Agile project methodology and a Domain Drive Design (DDD) approach.
• Worked on several automations, tools which has reduced manual effort, manual errors drastically. This again reflected huge dollar savings.
• Working on system enhancements to improve system and stabilize.
• Developed, Automated an Archival process for critical application tables to improve the performance and stability of the application.

Environment: / Tools: MS Visual Studio, C#, .net, MVC4, Web API, Informix DB, MS SQL Server 2016, PL/SQL, SQL *Plus, GIT, DBeaver

Confidential, Bentonville, AR

Senior Developer, Lead

Responsibilities:

• Responsibilities involved requirements gathering and developing new modules for administration and Admin tool in C# .net.
• Involved in Web Application using MVC4.
• Implemented JQuery for validations.
• Created Restful services using ASP.NET Web API to maintain records.
• Implemented AngularJS directives to reduce the usage of redundant code .
• Developed UI with HTML5/CSS3, AngularJS.
• Implemented T-SQL Queries, Stored Procedures, and Triggers.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Used Microsoft Team Foundation Server (TFS) for the purpose of version Control and source code maintenance needs.
• Implemented Agile project methodology and a Domain Drive Design (DDD) approach.
• Documented and trained admin helpdesk on the new developed modules.
• Worked on several automations, tools which has reduced manual effort, manual errors drastically. This again reflected huge dollar savings.
• Working on system enhancements to improve system and stabilize.
• Developed a data feed WCF service hosted on Windows server 2008 R2 (IIS 7.5) using C# 5.0 (.net framework 4.5) which connects to Teradata database and connects to SQL server via LINQ to SQL.
• Re-written SSIS packages to integrate and added dependencies to automate the sequence.
• Developed, Automated an Archival process for critical application tables to improve the performance and stability of the application.
• Has lead the team of 14 (2 onsite, 12 offshore)

Environment: / Tools: MS Visual Studio, C#, .net, MVC4, Web API, WCF, SSRS, SSIS, Informix DB, BMC Remedy 6.3 / 7.1 / 7.6 Administrator, MS SQL Server 2008, PL/SQL, TOAD, SQL *Plus, Team Forge - Subversion, Eclipse, Web Services

Confidential, Bentonville, AR

Senior Developer, Lead

Responsibilities:

• Involved in Requirements gathering and documentation.
• Developed the application using Agile Scrum Sprint planning strategy.
• Developed an MVC4 application with Razor using Visual studio 2012.
• Worked on developing Space validation Tool using C#.NET.
• Developed UI using ASP. Net, Server controls, HTML5 Controls , Validation controls and AngularJS.
• Implemented different AngularJS based validations.
• Implemented DAL layer for data retrieval and manipulation using ADO.NET data objects and ADO.NET Entity Framework.
• Used Generics, Lambda Expressions, Extension Methods, LINQ to SQL, LINQ to Objects .
• Implemented SOLID design principles.
• Implemented AJAX functionality using JQUERY .
• Used TFS for source control management.
• Written stored procedures, triggers using SQL.
• Worked on designing the various modules of windows application and data flows of the system.
• Performed Configuration controlling using Team Forge.
• Participated in Code-reviews with Walmart ISD technical experts.
• Has leaded a team of offshore developers.
• Performed code review and peer testing for development done by other team members.

Environment: /Tools: Microsoft .NET Framework 4.5, C#.NET, MVC4, JQuery, ADO.net, AngularJS, SQL Server 2008, PL/SQL, TOAD, SQL *Plus, LINQ, TFS, Web Services, Team Forge - Subversion.

Confidential

Senior Developer

Responsibilities:

• Prepared Design Specifications - DS, Functional Specifications - FS, Technical Design Documents and Test Plans.
• Project is Implemented by SDLC model includes preparing Implementation Plan, giving Technical Design Walkthrough.
• Design and develop web application using MVC4.
• Automated all the SQL jobs by Microsoft BI - SSIS tool.
• Wrote automatic scripts to move the files across the various domains for business to access it
• Wrote and tuned all the stored procedures and eliminated unwanted database operations and improved the data quality.
• Was part of environmental support which enables the Workstation environments for the user to login and access the tools. Perform the System Study and intense analysis of the existing system and produced the solution performance improvement.
• Extensively worked Complex SQL Queries.
• Used Microsoft Visio to document solutions.
• Enhanced the application to extend the functionality requested the Business users
• Used JQuery functions.
• Used LINQ to SQL for querying objects.
• Used TFS for source control management.
• Written stored procedures, triggers using SQL in SQL SERVER 2008.

Environment: /Tools: Microsoft .NET Framework 3.5, VB.NET, MVC4, Web Services, JQuery, LINQ, SQL Server 2008, MS BI - SSIS, Team Forge - Subversion, Microsoft Visio.

Confidential

Senior Developer

Responsibilities:

• Prepared Design Specifications - DS, Functional Specifications - FS, Technical Design Documents and Test Plans.
• Project is Implemented by SDLC model includes preparing Implementation Plan, giving Technical Design Walkthrough.
• Design and develop web application using MVC4.
• Development of component classes and interfaces in C# encapsulating the business logic with strict adherence to Object Oriented Paradigms.
• Responsible for extracting daily reports and upload to Team site using ARIS 7.2 tool.
• Developed and hosting WCF Services on IIS by following Service Oriented Architecture (SOA).
• Working on Application Portfolio Management reports and modifying it to business requirements.
• Application retirement progress through reports.
• Technical support for ARIS Mash Zone.
• Access/Revoke user access to ARIS and uPerform.
• Used TFS for source control management.
• Written stored procedures, triggers using SQL in SQL SERVER 2008.

Environment: /Tools: ARIS 7.2, Share point, MVC4, Windows 7.

Confidential

Senior Developer

Responsibilities:

• Involved in requirement gathering and documentation.
• Involved in process automations, batch files creation, tools and root cause fixes which resulted in dollar savings for the clients. One of the automated scripts which were developed for an application process alone resulted in saving 200 man hours per year.
• Involved in database modeling, data sampling and data mining activities to assist in business requirements fulfillment and use case validations.
• Used Interop Assemblies to Enhance this Excel Add-in.
• Created 100 + SSIS package with many data transformations.
• Interacting with multiple cross commits teams for the application support to fix the data related issues.
• Lead a team of 10 including onshore and offshore.
• Worked on automating the reports generated for every month.
• Project is Implemented by SDLC model includes preparing Implementation Plan, giving Technical Design Walkthrough.
• Development of component classes and interfaces in C# encapsulating the business logic with strict adherence to Object Oriented Paradigms.
• Used TFS for source control management.
• Written stored procedures, triggers using SQL in SQL SERVER 2008.

Environment: /Tools: C#.Net, Visual Studio 2008, VBA, SQL Server 2008 R2, SSRS, IIS and Windows 7.

Confidential

Developer

Responsibilities:

• Used N-tier architecture for Presentation layer, the Business and Data Access Layers and were coded using C#.NET and ASP.NET.
• Worked with the team for analyzing the requirements and to design the business rules as per the business requirements
• Used HTML, JavaScript and AJAX for developing Controls and web forms.
• Developed a Custom User Control for displaying products.
• Used Grid View BoundField, HyperLinkField, TemplateField to display data in a well-defined manner with sorting, paging, Export to excel, zip, bookmark a link, static Grid View headers on scroll features. Implemented Template Columns for Custom nested Grid View.
• Worked on exporting reports to Excel from Grid View.
• Used Java Script for Client side validations.
• Also, applied validation controls for validation the Web forms for the UI using ASP.Net.
• Used Data Set, Data View and Data Adapter to manipulate and display the data.
• Involved in Database diagram design and Tables design in SQL Server.
• Developed code to generate PDF which is the final output/complete quote of the application.
• Written stored procedures, triggers using SQL in SQL SERVER 2008.
• Deployment of Application on Test and Production Server.
• Handled many production issues and enhancements to existing Live portals.
• Used Visual Source Safe for source control management.
• Involved in Unit Testing for entire application, documented the User Manual.
• Used the Microsoft SQL Server Reporting Services to displaying the data in reports form.
• Worked with Install Shield for installations.
• Prepared unit, integration and system test plans.
• Inducted new team members and mentored them to being them up to speed in the application.
• Providing status on ongoing activities.
• Providing Estimation and Tracking.
• Provided Production support.

Environment: Visual Studio 2008 with .Net framework 3.5, MS Dynamics CRM, IIS 7.5, C#, SQL Server 2008, SSRS, StyleCop 4.3 and Visual Source Safe.

Confidential

Developer

Responsibilities:

• Used N-tier architecture for Presentation layer, the Business and Data Access Layers and were coded using C#.NET and ASP.NET.
• Worked with the team for analyzing the requirements and to design the business rules as per the business requirements.
• Used HTML, JavaScript for developing Controls and web forms.
• Developed a Custom User Control for displaying products.
• Used Java Script for Client side validations.
• Also, applied validation controls for validation the Web forms for the UI using ASP.Net.
• Used Data Set, Data View and Data Adapter to manipulate and display the data.
• Involved in Database diagram design and Tables design in SQL Server.
• Developed code to generate PDF which is the final output/complete quote of the application.
• Written stored procedures, triggers using SQL in SQL SERVER 2008.
• Used Visual Source Safe for source control management.
• Involved in Unit Testing for entire application, documented the User Manual.
• Prepared unit, integration and system test plans.
• Inducted new team members and mentored them to being them up to speed in the application.
• Providing status on ongoing activities.
• Providing Estimation and Tracking.
• Provided Production support.

Environment: ASP.net with C#, WPF, ADO.Net, SQL Server 2005, TFS 2008 and Windows XP.

Confidential

Developer

Responsibilities:

• Used N-tier architecture for Presentation layer, the Business and Data Access Layers and were coded using C#.NET and ASP.NET.
• Developed Business, Repository and related class modules based on the requirements.
• Created high level and detailed level design documents using the business requirements.
• Implemented WPF, learning it on job.
• Writing complex database stored procedures and triggers.
• Wrote Stored Procedures and SQL Statements for report generation and data modification activities.
• Extensively worked Complex SQL Queries.
• Developed code for the given requirements.
• Prepared unit, integration and system test plans.
• Inducted new team members and mentored them to being them up to speed in the application.
• Also, applied validation controls for validation the Web forms for the UI using ASP.Net.
• Used Data Set, Data View and Data Adapter to manipulate and display the data.
• Used Visual Source Safe for source control management.
• Providing Estimation and Tracking.
• Provided Production support.

Environment: ASP.net with C#, WPF, ADO.Net, SQL Server 2005, TFS 2008 and Windows XP.

Confidential

System Engineer Responsibilities:

• Created high level and detailed level design documents using the business requirements.
• Integration between Entitlements - Vastera application.
• Writing complex database stored procedures and triggers.
• Wrote Stored Procedures and SQL Statements for report generation and data modification activities.
• Extensively worked Complex SQL Queries.
• Developed code for the given requirements.
• Prepared unit, integration and system test plans.
• Inducted new team members and mentored them to being them up to speed in the application.

Environment: ASP.net with C#, SQL Server 2005, SSRS and Windows XP.

Confidential

System Engineer

Responsibilities:

• Implemented all the functionalities of the application - user creation, access related activities of all the templates, email templates and issues.
• Created a Windows Service for Emails.
• Developed a web application using ASP.net for User related activities.
• Implemented OOPs concepts overriding and overloading.
• Responsible for fixing the existing bugs in the application.
• Implemented Year End activities for merchandise hierarchy as part of supporting the application.
• Writing complex stored procedures and triggers.
• Performed code review and peer testing for fixes done by other team members.

Environment: ASP.net with C#, Oracle, Windows XP.

Confidential

System Engineer

Responsibilities:

• Responsible for fixing the existing bugs in the application.
• Implemented Year End activities for merchandise hierarchy as part of supporting the application.
• Writing database scheduled tasks and adding new product group and their charts information.
• Performed code review and peer testing for fixes done by other team members.
• Developed a web application using ASP.net for displaying bookings, shipments.
• Implemented OOPs concepts using Interfaces and abstract classes.
• Implemented Exception handling.
• Responsible for fixing the existing bugs in the application.
• Implemented Year End activities for merchandise hierarchy as part of supporting the application.
• Writing complex stored procedures and triggers.
• Performed code review and peer testing for fixes done by other team members.

Environment: ASP.net with C#, Oracle, Windows XP.

Confidential

System Engineer

Responsibilities:

• Developed and later led the design, development and implementation of critical Sales operation functionality.
• Created high level and detailed level design documents using the business requirements.
• Integration between Deal desk and Non - Standard Pricing applications.
• Writing database procedures to generate COGS information from Oracle and provided continuous support for this tool.
• Wrote Stored Procedures and SQL Statements for report generation and data modification activities.
• Extensively worked Complex SQL Queries.
• Developed code for the given requirements.
• Prepared unit, integration and system test plans.
• Inducted new team members and mentored them to being them up to speed in the application.
• Integration between Deal desk and Non-Standard Pricing applications, writing database procedures to generate COGS information from Oracle and provided continuous support for the tool.
• Developed a web application using ASP.net for sales operations.
• Developed a web service for sales related functionalities.
• Implemented OOPs concepts using Interfaces and abstract classes.
• Implemented Exception handling.
• Responsible for fixing the existing bugs in the application.

Environment: ASP.net with C#, Oracle, Windows XP.