SUMMARY:

• I have primarily worked in Microsoft Technologies for more than 6 years, with vivid experience on .Net f/w ranging from 2.0 till 4.5.1 (the latest project migration took place on this framework). This includes my experience in designing, fabricating, developing, unit testing, system testing and UAT fixes of Web, Windows and Service based applications. This includes using coding language C# extensively and VB to an extent. I have also worked on SQL Server versions 2005 untill 2014 which includes designing database schemas using Visio and SQL Diagrammatic Tool, have created standalone schemas for the tables, written stored procedures, scripts to insert/delete/update and select queries using different join statements for business reports, scripting out SQL Server agent jobs, stored procedure tuning etc.
• In one of my previous project experience while designing UI of a CRM Apparel application for the Retailer (it is really a vast source code with 20 projects inside one solution catering to extensive length of business needs), I worked on creating CSS classes for easier code maintainability, reduce redundancy and improve code quality. The same application used MVC3, Javascript, Jquery 1.5.1, used JSON during Ajax data postback to the UI control. The front end was written in HTML5 using Razor Syntax in cshtml which acted as the View for the MVC application. This UI used to interact with Java webservices using the WSDL generated from service layer and used to follow SOA pattern with its DB as back end of the service layer, decoupling each layer as it goes.
• In my recent projects I have worked and still continuing work on Entity Framework Database First approach creating entity objects from the classes created using the entity template (EF 6). This we are using as designing the Model classes and using those classes, writing the Mapping layer which contains the business logic for the incoming Web XML requests coming through the Service interface which in turn is a WCF service installed in IIS of the application server. This follows ther HTTPS transport mechanism where the app server validates the XML requests coming through different channels i.e Store POS, Ecommerce Web channel, COM, Mobile POS etc.
• I also have experience in designing and coding Web UIs using ASP.Net, ADO.Net fudamentals for the retailer which is an application used for Gift Card Marketing systems.
• Strong OOP (Object Oriented Analysis, Design and Programming) skills
• Excellent experience on C#.NET, ASP.NET, ADO.NET, MVC, .NET Framework 4.5.1/4.0/3.5/2.0, SQL Server 2014/2012/2008/2005
• Successfully implemented various Multi - Layered, Multi-Tiered .NET applications
• Designed Data Access Layer using ORM tools, Entity Framework and migration of entity f/w from v5 to v6
• Excellent experience in implementing Web Service, WCF, REST service which communicate data in a both XML & JSON.
• Expertize in UI Designing & Scripting using XHTML, HTML5, Advanced CSS, Java Script, JQuery library, ASP.NET Ajax Control Toolkit, Telerik controls
• Experience in Relational Database Design, Data Modeling, Query Optimization and Implementation of database objects like Tables, Views, Stored Procedures, Functions and Triggers using MS SQL Server
• Experience with SSIS and knowledge on SSRS (Integration and Reporting)
• Experience with process/data modeling using tools like MS Visio
• Experienced working and configuring IIS 7 Express Edition
• Working experience with various versioning tools like GIT, TFS, VSS
• Skilled in all phases of the software development lifecycle

TECHNICAL SKILLS:

Programming Languages: - C#, VB.Net, VBA

Programming Concepts: - Entity Framework, WCF, MVC Arch, ASP.NET, ADO.NET, Telerik, Ajax, Crystal Reports, IIS 7 Express Edition, WPF

Scripting Languages: - Javascript, JQuery1.5.1, HTML5, CSS

Programming Editors/IDE: - Visual Studio

Database and Integration Services: - SQL Server, Oracle 11g, SSIS

Frameworks: - .NET f/w 3- 4.5.1

Source Controls: - GIT, TFS, Atlassian Sourcetree

Agile Tools: JIRA, Confluence

Test Tools: Soap UI 4.5.2

PROFESSIONAL EXPERIENCE:

Confidential

.NET Developer and Analyst

Responsibilities:

• Designed the Test interface
• Created the Test Project referencing the service client, entity model containing the entity contexts and database objects, data types
• Coded the EF mapping layer to build the request based on the Data provider
• Created Helper methods and common classes to be inherited across derived classes across the Test project

Confidential

SQL Developer and Analyst

Responsibilities:

• Developed SQL scripts to set up the SQL Agent jobs using sp add category in sandbox environment, responsible for the card creation workflow and modified the service account credentials to match as in lower environments.
• Modified the SSIS functions to match the business logic of adding new source destinations as part of Puerto Rico.
• Troubleshooted configuration issues with the SSIS package and planning to in corporate these scripts as part of the automated build/deploy process.

Confidential

.NET Developer and Analyst

Responsibilities:

• Designed the Operation interface.
• Generated datatypes and classes from the WSDL and designed the implementation layer as an interface containing the abstract class definitions.
• Designed an Entity Repository to decouple the business logic from the entity objects. This repository implementation was done using LINQ to fetch the list of data using the entity objects from DB
• Wrote unit tests for the operations and the entity repository.
• Was responsible in migrating the User Interface from .Net 2.0 to .Net 4.5.1. Upgraded the dlls and incorporated them as part of the GAC. Changed the target frameworks to 4.5.1 for each of the projects in the .sln file and troubleshooted the compilation errors.
• Performed IIS modifications for the migration which included setting up the app pool, service account creation, add directories, enable the ISAPI filter to allow worker process to send/receive and convert to application
• Developed SQL scripts for schema related changes and SQL scripts to insert/update data as per business needs.
• Analyzed the Card Creation workflow which included the UI, Stored Procedures, SSIS and .bat files as part of Control M job flow. Have modified the Stored procedures and the Fx (functions) in SSIS to include new values and change the logic based on the business needs

Confidential

.NET Developer and Analyst

Responsibilities:

• Was involved in discussions of requirement gathering, analyzing systems, designing and finalizing the WSDL definition using Enterprise Architect and Visual Studio ORM tool.
• Was involved in designing and coding of the Settlement operation for ERTM release of GCP. This was quite of a challenge as this was the first time such an operation was being written in WCF, previously which used to happen through batch.
• In this project, we defined the Data model, DataTypes, DataAccess Layer, Business Logic layer and the WCF service which would communicate with the end consumers of this service. The data model was a Database First Approach and the model/template/entities were generated form the BD schema. The EDMX contained the designer, context and model definitions. The solution as a whole contained Model, Mapping layer with the business logic in it and the SVC.cs which contains the entry points for each of the service methods and the classes which defines the different types of faults (business, system and security). There were 15 Sprints and one hardening sprint based on which the development took place.
• Was solely responsible in designing the Exception logging architecture of parameterizing the errors and then passing the input to SCOM and Splunk (activity taken care by different teams) which in-turn was used for ALERTS mechanism.
• Developed data cleanup SQL scripts as part of cutover process to real time mode, update scripts to synchronize data for future business requirements, drafted Release plans and raised service requests for ERTM production release.
• During the System and UAT, I was involved in deploying code to Test environment for E2E QA team.
• Was involved in defect fixing and issue resolution as part of the warranty support post go-live.

Confidential

Multiple UI Designer and Developer

Responsibilities:

• This application was broadly divided into UI, Weservice and DB layer. I was working in UI team.
• Followed the MVC architectural pattern. Created the classes as part of the Model which is in turn inheriting the properties of the classes from the WSDL generated by the Web Service layer which is in Java/Spring
• Created Controller action methods to provide the action back to the View associated with the particular controller. Sometimes, during an Ajax postback, the return object will be a Json datatype
• Created Views using HTML5 razor engine syntax, included the System.Web.Mvc namespaces, added the master layout page, included javascripts and Ajax.BeginForm methods to take care of any postback functionality
• Created the Sitemaps to dynamically load the on screen tabular controls based on user roles and privileges.
• Routing used to happen through the Global.asax page
• Created classes for HTML Helper extensions, HTML Sanitizers and also created configs specific to environments in XML.
• As part of static content, the parent solution contained the Jquery 1.5.1 library files and extensions.
• Created Javascript functions using Jquery libraries for various functionalities like loading Chromeframe, client side validations, load modal pop-ups, load telerik controls(datepicker, telerik gridview) and fetch or bind the values to the client side controls.
• Worked on creating CSS classes and referring them across the Views and Javascripts during dynamic loading of web pages

Confidential

System Developer

Responsibilities:

• Developed the Console application changes, Business logic and Network changes with TCP/IP sockets
• Handled the integration with other systems with respect to the creation of a XML configuration file
• Developed a automatic windows service for the business change
• Developed Aggregator connectivity along with Asynchronous send and multi-thread program

Confidential

Application Developer

Responsibilities:

• Developed the Console application in VB.Net technology along with the UI for business needs
• Use of Dynamic Linked Libraries (dll) to refer the VB.Net function in C#.Net
• Connection strings and queries to access the data and format the jpg files from the excel application