PROFESSIONAL SUMMARY:

• Software Developer Professional with over 11+ years of demonstrated work experience Software Application Design and Development in Microsoft practice - primarily .NET & MS SQL and implementing business technology applications, systems integration and testing solutions.
• Experience with in-depth domain knowledge of Retail - Store Management (Replenishment), E-Commerce (Order management), Supply-Chain (Sales Floor Automation and Retail Execution Planning), financial / Non-Financial reporting & Public Sector (Police). Finance & Banking industry and skills including, but not limited to, software analysis, design and development.
• Comprehensive understanding of the Web Page, ASP.NET Framework 4.0, 3.5, 2.0 and C#.NET, VB.NET, ADO.NET, WinForms, ETL Process, Entity Framework, HTML5, CSS3, JavaScript, WCF &WPF.
• Designing and developing SQL Server 2008 R2, SQL Server 2008, SQL Server 2005 with technologies such as database structure, Stored Procedures, Triggers, Transact SQL.
• Worked on 3-tier and N-tier layered architecture.
• Expereience in several DESIGN PATTERNS like Singleton, Factory and ASP.NET MVC etc.
• Extensive experience in creating rich content Web-Forms, Win-Forms (Windows Forms), Web User Controls, Custom Control, Server Controls, Windows Service and Web Service.
• Experience in using Javascript MVC frameworks like AngularJS for single page web application and partial view web components
• Architected Multi-tiered/ Multi-threaded applications. Used Design Patterns in developing applications using MVC. Standardized UI using Master Pages, Skin sand Themes. Globalized and Localized applications. Developed CustomWeb Controls using C#, HTML, AJAX, JavaScript and JQuery.
• Developed and maintained OLTP and BI systems for large to medium scale Data Transformation services for varied Data formats in text files, XML, Oracle, SQL Server using SQL Server SSIS and SSRS.
• Designed Normalized Databases, programming in T-SQL, PL-SQL, PLSQL Developer, SQL Profiler.
• Optimized Stored Procedures, Functions, Triggers, Views and Indexes.
• De-normalized Database for reporting and performance needs.
• Designing and developing DB objects on SQL Server 2012/2008 R2/2005 - data modeling, Stored Procedures, views, Transact SQL.
• Expert in designing, developing, executing and managing SharePoint, ASP.NET, C#, WCF, WinForms, Visual Basic 6.0 based front end server side applications and Back-end databases like Oracle and SQL Server in all aspects of a project‘s life cycle.
• Hands on experience with SQL Server 2000, 2005, 2008 and 2012
• Extensively worked on writing Stored Procedures, Triggers, Functions, Views and Database Design.
• Created and maintained SSIS packages to Import/Export data from flat files, XML, Excel and Oracle.
• Used Design Patterns in developing applications using MVC.
• Worked with multiple MNCs primarily in Retail domain
• Extensive experience in Requirement elicitation, impact analysis and NFR identification tools mainly in Caliber / QC / Dyna-Trace.
• Expertise in high level and low level design, build, source code management design and code reviews (peer/group) tools like Visio/Visual Studio/FxCop/VSS/TFS/MS SQL/JS/jQuery/MSMQ
• Proven experience in testing and testing tools, implementation and support such as VS TFS/ Quality Center / Splunk/ Remedy
• Good experience in Analytics. Tools: ASP.NET custom reports, SAP BO
• Project Management experience include Estimation, Change Management, Risk Management & Team management. Strong communication and team playing skills.
• Highly motivated, self-driven, energetic team player with positive attitude.

TECHNICAL SKILLS:

Microsoft Technologies: .NET Framework 2.0-4.5, C#/VB.NET, ASP.NET, ADO.NET, AJAX, WebServices, WCF, LINQ

Web Technologies: HTML, DHTML, CSS, XML

Scripting Languages: JavaScript, jQuery, AngularJS

Visual Dev Tools: MS Visual Studio 2012,2013

Databases: MS SQL Server 2012/2008/2005

Source/Version Control: MS TFS 2010/2012/2013 , VSS, SVN

Integration Tools: SSIS

Deployment Tool: Cruise Control

Others: MS Visio, MS Office

Middleware: Web Services/WCF/RESTful WEB API

IDE: VS2012/2013

BI Tools: SSIS

Reporting Tool: SAP BO

PROFESSIONAL EXPERIENCE:

Confidential, Northfield, IL

Technology Lead

Environment: C#, MS SQL 2014, Azure, MVC 5.0

Responsibilities:

• Architecture - System Integration, Technology Stack & NFR definitions (Sizing & performance parameters)
• Designed logical and physical Data model for the project using Erwin
• Source code management (Configuration controller) using Visual Studio Online (VSO) Requirement elicitation, high & low level design, development (Build), Design & Code review, testing, defect management, implementation. Tools used - Confluence, Visio, MS Word/Excel/power point, Visual Studio, SQL Management studio, Resharper & Quality Center.
• Developed html view template and used services like $http, $resource for performing view switching and CRUD operations using AngularJS along with RESTful service implementations when provider makes changes or additions or deletions of account balance data on the Account summary page
• Involved in using AngularJS for marshaling the model to the view and forward events to the controller for rendering ‘Accounts summary page’ into the Accounts module (single page application)
• Involve in Web Service unit testing using SoapUI tool.
• Developed Build Report application using .Net Framework and ASP.net MVC with back end as SQL Server 2012.
• Developed the Data entry screens with complex business validation rules, robust security and administration modules.
• Seamlessly integrated the portal with SAP BO reporting solution using Open doc and RESTful API interfaces.
• Designed the DB Data model in MS SQL Server 2012/2008-R2 DB.
• Worked on Requirement elicitation, high & low level design (Data modeling), development, review, testing and implementation.

Environment: ASP.NET MVC4, Razor View Engine, jQuery, JSON, CSS 3, HTML5,JS,Bootstrap, SQL Server 2012,WCF,TFS, SSRS, Visual studio 2012, NUnit

Confidential, Deerfield, IL

Technology Lead

Responsibilities:

• Designed and Developed the One-Stop Web portal to enable finance users capture KPI metrics and generate key financial reports.
• Developed website presentation layer using ASP.Net, C#, HTML5, CSS3, JavaScript and JQuery.
• Developing Windows Services.
• Developing SSIS packages to handle various Sources like Database, HTTP API, network storage folder etc.
• Implemented document standards, procedures, artifacts.
• Use of jQuery for better User Interface.
• Created the Custom User Grid View Control which includes the Sorting and Paging.
• Used the WCF/Web Services to accessing data from a database on a back-end server and displaying it in a Silverlight user interface.
• Provide Support to other teams to fetch the data from the centralized database using ASP.net XML Web Services.
• Developed and hosting WCF Services on IIS by following Service Oriented Architecture (SOA).
• Developed C# Class Library Project using .Net Framework and TFS API’s for generating the different types of SQL builds (full and incremental) between source and destination SQL project solutions.
• Involve in Web Service unit testing using SoapUI tool.
• Developed Build Report application using .Net Framework and ASP.net MVC with back end as SQL Server 2012.
• Worked on Requirement elicitation, high & low level design (Data modeling), development, review, testing and implementation.

Environment: C#, MS SQL, SSIS, RESTful web service, JS/jQuery, SAP BO

Confidential, Deerfield, IL

Technology Lead

Responsibilities:

• Design and Development of Sales Reporting solution in Front Office area.
• Developed integration layer with Stay-In-Front product for Sales Force Automation data and SAP MDM system for Product master data.
• Used the AJAX tools like Update Panel etc. for partial post back.
• Created Stored Procedures, Views, Triggers and Complex T-SQL queries in SQL Server.
• Involved in Unit testing and Bug fixing.
• Manage the Dev, QA, Staging and Production web Services and ESB environment.
• Provide inputs in architecting, designing, and implementing a Service Oriented Architecture (SOA) for the application development group.
• Implemented SSIS packages to update SQL data tables from Oracle Server.
• Provide Support to other teams to fetch the data from the centralized database using ASP.net XML Web Services.
• Developed SAP BO Universe (semantic layer) and BO reports for end customers (Sales Representatives).
• Developed ETL jobs (MS SQL SSIS) to enable end customer Ad-hoc reporting on SAP BO.
• Requirement elicitation, estimation, system integration, SAP BO Report & SSIS development, testing and implementation.

Environment: C#, MS SQL, SSIS, RESTful web service, JS/jQuery, SAP BO

Confidential, Deerfield, IL

Technology Lead

Responsibilities:

• Maintenance/Support Engagement in STC (Sell-To-Customer) and Trade Retail areas.
• Designed and developed crew list user control using ASP.NET & Windows forms primarily in C# & VB.NET.
• Involved in development of the web application using LINQ.
• Designed and developed crew alerts user control using ASP.NET and code behind as C#.
• Created store procedures using complex joins for crew listing, alerts and advance search functionalities using SQL Server 2005.
• Development of component classes and interfaces in C# encapsulating the business logic with strict adherence to Object Oriented Paradigms.
• Responsible for implementing and deployment of WCF Services.
• Developed and hosting WCF Services on IIS by following Service Oriented Architecture (SOA).
• Implemented the functionality to render data using XML files and format them using XSLT.
• Involved in Database diagram design and Tables design in SQL Server.
• Created Stored Procedures, Views, Triggers and Complex T-SQL queries in SQL Server.
• Used Team Foundation Server (TFS) for project repository and versioning control.
• Designed and developed crew advance search user control using ASP.NET and code behind as C#.
• I lead a team supporting a suite of high availability applications in Sales and Trade areas which spanned across regions.
• These applications had scheduled releases and I was involved in customer meetings for scope definitions, estimations and governance.
• I also was involved in design and code review of the key deliverables other than managing/owning the complete delivery
• Design/Code review, performance tuning, change management, risk management, estimation, escalation management and team management

Environment: C#, MS SQL, SSIS, RESTful web service, JS/jQuery, SAP BO

Confidential, Minneapolis, MN

Technology Lead (Onsite & Offshore)

Responsibilities:

• Design and Development of Canada Store Replenishment systems automating/optimizing the In-Store and Back room Business processes.
• These applications catered for the new Confidential stores that opened in Canada in 2013.
• I was involved in development of Sales Floor and Back room Replenishment modules which involved implementing work flows and algorithms. The project supported multi lingual & Currency behaviors. Globalization solution was implemented.
• Since these applications ran on PDA devices, the performance considerations (NFRs) were of very high standards.
• I was involved in performance testing and tuning as well.
• High & low level design, development, review, testing, performance tuning, implementation, estimation & support

Environment: C#/VB.net, MVC 4.0, MS SQL, SSIS, JS/jQuery, MSMQ, DynaTrace, Splunk, Quality Center

Confidential, Minneapolis, MN

Technology Lead (Onsite & Offshore)

Responsibilities:

• Development and Maintenance of US Store Replenishment systems - In-Store and back room store Business processes (US stores).
• I was involved in the enhancing US Store applications to improve In-stock Accuracy.
• I designed and developed new DB & .NET components and optimized the code to cater the business requirements.
• Impact analysis, Estimation, low level design, development, review, testing, implementation and support

Environment: C#/VB.net, MVC 4.0, MS SQL, SSIS, JS/jQuery, MSMQ, DynaTrace, Splunk, Quality Center

Confidential

Senior Software Engineer (Onsite & Offshore)

Responsibilities:

• Development of High availability multi-region E-Commerce application - “Integrated Simple Commerce Solution”.
• I was involved in developing the Tax module which had multiple considerations based on countries.
• I was also involved in UI design to make the site appealing to online buyers.
• I was involved in testing of critical modules - Credit, Security and Pricing
• Low level design, development, testing, & support

Environment: C#, VB.net, MVC, MS SQL, SSIS, JS/jQuery, Quality Center, ASP 3.0

Confidential

Senior Software Engineer (Onsite & Offshore)

Responsibilities:

• Development and Maintenance of Financial Reporting solution- a Volume Direct business initiative.
• Manage account portfolio, Identifying new Confidential accounts, drive pricing strategy.
• I was involved in developing integration layer (primarily excel feeds) and custom .NET (ASP.NET & Windows forms) and ASP 3.0 reports. The application supported multi language and Globalization was implemented.
• I enhanced the performance of existing excel integration process by 3X times using XML serialization technique which was well appreciated by customers.
• Impact analysis, Low level design, development, testing, implementation & support

Environment: C#, VB.net, MVC, MS SQL, SSIS, JS/jQuery, Quality Center, ASP 3.0

Confidential

Software Engineer

Responsibilities:

• Development of Process Automation application for Confidential .
• I was involved in automating the standard police manual procedures using ASP.NET (web application).
• I developed multiple page data input screens and custom reports in .NET and crystal reports.
• I was involved in client reviews to present the system capabilities and also support the User Acceptance Testing.
• Development, testing, & implementation

Environment: VB.net, MS SQL, Crystal reports, JS