SUMMARY

• Microsoft certified professional with overall 6+ years of IT experience in analysis, design, development, testing and deployment of web - based applications.
• Knowledge in Finance, Investment, Insurance, Oil and Gas Energy domain.
• Technical expertise in developing applications in .NET Framework using C#, ASP.NET (4.5/4.x/3.5/3.x/2.x), ADO.NET, Entity Framework (6.x/5.x/4.x), ASP.NET MVC (5.x/4.x), Web Services, WCF, REST APIs, Web API 2.x, XML, LINQ, SSRS and MS SQL Server 2014/2012/2008 .
• Worked on various architectural frameworks such as Client-Server Model, Model-View-Controller (MVC), Multitier-Tier (N-Tier) and Service-Oriented Architecture (SOA).
• Knowledge in Design Patterns such as Prototype, Factory, Abstract Factory and Singleton including Dependency Injection (DI) and Inversion of Control (IOC).
• Highly Skilled in front-end technologies such as HTML 5/4, CSS3, JQuery, JavaScript, JQuery-UI, Bootstrap 3/2 and Ajax.
• Developed JSON Based RESTful APIs and integrated with SOAP service to display in the reports and UIs.
• Expertise in working on SQL Server 2014/2012/2008 and writing SQL Queries, Stored Procedures, Joins, CTE, User-defined Functions, Views, Indexers, Cursors, and Triggers in Transact SQL.
• Significant experience in managing Security policies including Windows Authentication, Authorization, Membership, Roles, Profiles and Resource Access Control.
• Used Windows Communication Foundation (WCF) framework for building service-oriented application.
• Extensively created SSRS reports and integrated them with the SOAP Service using XML query and passed dynamic parameters to the service.
• Implemented Unit testing using NUnit and used Test Driven Development(TDD) methodology for creating more robust code.
• Competent in using Subversion (SVN) and Microsoft Team Foundation Server (TFS) for Version Control and Source Code maintenance.
• Deployed the web applications to the lower environments and hosted .NET applications on IIS 7.0/6.0/5.0.
• Worked in various development models such as Software Development Life Cycle (SDLC), Agile (SCRUM) and Waterfall Model.
• Strong knowledge in developing applications under Windows 10/7/XP/2003 environments.
• Currently exploring AngularJS and ReactJS with ASP.NET MVC and open to learning new technologies.
• I am a passionate, creative, and goal-oriented self-starter with readiness to acquire new skills and a proven ability to work efficiently in the ever-changing global business.

TECHNICAL SKILLS

Programming Languages\Framework\: C++, C#\MVC (5.0/4.0), MVVM, MVP, WCF\

Web Technology\Data Access\: ASP.Net (4.5/4.0/3.5/3.0/2.0 ), ASP.NET MVC, \ADO.NET, LINQ to SQL, Entity Framework \RAZOR, WCF-REST, WEB-API \(5.0/4.1)\

Front-End Technology\Methodology\: AngularJS, JSON, HTML, HTML5, CSS3,\Agile (Scrum), SDLC, Waterfall Model, \XML, AJAX, Bootstrap 3/2, JavaScript, PHP, \Accenture Delivery Standards\JQuery, JQuery-UI\

Database\Bug Tracking\: MS SQL Server 2014/2012/2008 , MySQL\JIRA, Postman, SOAP UI, Fiddler, Wireshark\

Web Servers\Web Services\: IIS (Internet Information Server) 7.0/6.0\SOAP, REST, HTTP\

Cloud Services\Testing Tools\: Azure, AWS\N-Unit, TDD, MS Visual Studio Test Tool\

Version controls Tools\Other Tools\: Git, Team Foundation Server (TFS), SVN\WordPress\Tableau 9.0.1\ Google Analytics \

Development IDE\Reporting Services\: Visual Studio 2015/2013/2010/2005 , Visio \SQL Server Integration Services (SSIS), \2015/2013, SharePoint Designer 2013/2010\SQL Server Reporting Services (SSRS)\

PROFESSIONAL EXPERIENCE

Confidential, Overland Park, Kansas

.NET/SSRS Developer

Responsibilities:

• Collecting requirements about the UI screens and understanding the database design from Data team.
• Currently, developing a new ASP.NET MVC web application for the internal business users.
• Writing stored procedures for the web application as well as creating RESTful API calls to perform CRUD operations. These APIs will be consumed in the MVC application to interact with the database to get data.
• Developed UI for the WebAdmin portal application using ASP.NET and used ADO.NET to connect with the database objects. Deployed to production and adding new enhancements features to this module now.
• Wrote unit test cases to handle validations at WebAdmin portal and used JavaScript to do validations on the ASP.NET pages.
• Directly working on a third-party vendor API in locally setting up code and running RESTful API service to pull data from their database.
• Analyzed the JSON format data and created new table structure to store JSON data.
• Used Tidal to Automated the API process to load data into SQL table by running a job daily

Confidential

Responsibilities:

• Interacted with the business team in gathering requirements for the ODS Query Tool.
• FollowingAgile Scrum Methodologyenvironment to achieve the tasks within the given sprint deadline.
• Created JSON based RESTful APIs calls in .NET Framework and consumed the service in the tool to call the database objects specially stored procedures.
• Created multiple API calls for each search parameter at web page and tested these REST API calls by passing valid parameters using Postman software.
• Each WCF API is a solution stack with layers such as Business Service Provider, Products, Data Services and ORM (Object Relational Mapping).
• Used EXT.NET- ASP.NET (Web forms + MVC) component framework to build the ODS Query Tool.
• Consumed JSON Object directly in the User Interface to display data in the GridPanels.
• Designed Layouts Pages using HTML5, Bootstrap and CSS3 to give a uniform look.
• Used EXT.NET controls like GridPanels, Labels, Textfields, TextAreas, Buttons, Popup Window and ComboBox etc. Handled client-side validation by using JavaScript.
• For Security added Windows Authentication for validating users accessing the application.
• Worked with the DBA in getting the stored procedures logic setup as well as monitoring performance of the procedures at API level. Validated stored procedures retrieving the correct data as per requirement.
• Worked on setting up DNS and creating website at dev, test and stage at the web servers.
• Performed unit testing of the application and Business performed regression testing to check the stress at the SQL server and tool.
• Used AnkhSVN (Subversion Support for Visual Studio) to apply the Code Check-in and SVN for Source control.
• Actively worked in the deployment process of creating scripts and created Change Request and sending out the code to production environment.
• Involved in the ODS Query Tool 2.0 requirements gathering and bug fixing.

Environment: Visual Studio 2013, C#, .NET 4.5.1, MVC ASP.NET, REST Service, WCF, TortoiseSVN 2012, SQL Server 2012, Postman, Firefox Developer Tool

Confidential

Responsibilities:

• Developed a fully functional POC to call SOAP service within SSRS report and passed dynamic parameters in report to the service.
• Followed Agile Scrum Methodologyto achieve the tasks within the given sprint deadline.
• Analyzed the old reports and gathered knowledge from business users using these reports.
• Modified existing old SSRS reports passing multiple parameters using pipeline delimiter in the XML query to SOAP Service. And tested XML SOAP calls using SOAP-UI Software.
• Followed a design pattern which was like Factory to build SOAP and REST service.
• Worked on the Middle Tire (MT) layer which was a combination of Business Services, Data Services, Models and Products and ORM layer had business logic.
• Created RESTful APIs to retrieve JSON objects by passing parameters in the calls and testing using Postman software.
• Integrated SOAP service with REST API and consumed SOAP Service in the SSRS report.
• Wrote XML query to call SOAP service for each dataset in the SSRS Report.
• Removed SQL Queries from the SSRS datasets and converted to parameterize Stored Procedures.
• Modified the existing SQL Queries, Stored Procedures, Joins and Views in SQL Server 2012.
• Worked on creating DNS and setting up the IIS for helping the applications run without Time out issues.
• Wrote Unit Test cases for successful integration of modules such as Business Service Provider, Products, Data Services and Object Relational Mapping.
• Tested Entitlement and visibility by validating the reports based on user roles.
• Logged in the error in tools such as ALM and Remedyforce force.
• Used AnkhSVN (Subversion Support for Visual Studio) to apply the Code Check-in and SVN for Source control.
• Diligently involved in solving production issues and providing hot fixes and analysis on those incidents. Regularly, created Change Request and send out the new code to production environment.
• Documented SOAP and REST Calls for the QA team to test. Worked on the design document for my module.

Environment: Visual Studio 2013, C#, .NET 4.5.1, ASP.NET, Entity Framework 6.0, WCF, SVN 2012, SQL Server 2012, Postman, Soap UI5.3.0

Confidential

Responsibilities:

• Downloaded the old reports from the report server and setup the code in the local machine. And added shared datasets and databases to make the code functional.
• Directly worked with the Business team and took requirements.
• Analyzed and researched the data in the report and to fix the bugs raised by the Business.
• Fixed the existing bugs in the production reports and deployed the reports to production.
• Checked the formulas and calculations in the SSRS reports for the correct data to be populated.
• Added new enhancement features to the reports related to team concept and executive level reporting
• Modified existing SQL Queries, Stored Procedures, Joins and Views in SQL Server 2012. Created new SSRS reports for the portfolio managers and automated the process of sending reports using subscriptions.
• And added new enhancement features to SSRS reports such as Team Concept, Executive level reporting and called multiple sub reports in a single report etc. and fixed bugs in the existing reports and deployed to Production.
• Worked on deployment of SSRS reports and database objects to the production. These reports are used on daily basis by Portfolio Managers so needs to be fixed urgently.
• Tested the reports in the load environment and business team did UAT and tested to provide business approval.
• Logged in the incidents in the Remedyforce force tool.
• Used AnkhSVN (Subversion Support for Visual Studio) to apply the Code Check-in and SVN for Source control.
• Actively involved in solving production issues and provided hot fixes and analysis on those incidents. Regularly, created Change Request and moved my changes to the production environment.

Environment: Visual Studio 2013, SVN 2012, SQL Server 2012

Confidential

Graduate Research Assistant

Responsibilities:

• Improved the performance of the computers by installing new OS, defrag the hard drive and increased RAM Memory etc.
• Built database in MySQL for Research Network Visualization project.
• Developed visual interface using PHP coding language and explored tools such as Gephi & D3.js.
• Maintained the SERC WordPress website and designed and published new pages on it. Link to the website 
• Wrote batch scripts to run the visualizations created by PhD students.

Environment: WordPress, MySQL, PHP, Gephi, D3.js, Microsoft Excel, Tableau

Confidential

Software Developer

Responsibilities:

• Worked on requirement gathering, functional and technical specification with the Business.
• Created SharePoint website under the top-level site collection and added list, library and web parts to the SharePoint site.
• Referenced Microsoft SharePoint Assemblies such as Microsoft, SharePoint, Client.Runtime.dll and Microsoft.SharePoint.Client.dll to connect to C# code.
• Wrote various methods to read data from the fields entered in excel to perform the specific actions as per the requirement.
• Worked on migrating website data from SharePoint 2007 to SharePoint 2010.
• Wrote and triggered workflows in the SharePoint Designer based on the conditions.
• Developed forms using InfoPath and connected the InfoPath forms to the SharePoint site by publishing to the website.
• Performed InfoPath validations at the SharePoint Website.
• Worked on the Permission Levels for the various users for the website.
• Communicated with the client on daily basis on correcting flaws found in the live website.
• Involved in the new enhancement related development and Bug Fixes in the production environment.
• Trained new resources on the SharePoint technology and gave knowledge sharing session to them before handing it to support team.

Environment: Visual Studio 2010, C#, ASP.NET 3.5, Windows XP, SharePoint Designer 2010

Confidential

Software Developer

Responsibilities:

• Collected requirements for writing business logic and understand the functionality.
• Application was developed in ASP.NET 3.5 as a back end and SharePoint was the front end of the application.
• Launched the SharePoint website through the Visual Studio using .NET client Object Model and added SharePoint Assemblies Microsoft.SharePoint.Client.Runtime.dll and Microsoft.SharePoint.Client.dll.
• Created InfoPath forms and attached to the Visual Studio source code.
• Designed InfoPath forms using controls available in the InfoPath such textbox, checkbox etc.
• Performed validation in the InfoPath forms by writing the conditions.
• Wrote exclusive functions to read data entered in the InfoPath form and populating correct data in the calculated fields. And send correct data to the SQL Server database.
• Wrote queries using LINQ to SQL for data retrieval.
• Implemented the data access layer using Schema First approach.
• Created SQL scripts to perform unit testing for my module and shared with the QA team.
• Maintained TFS as a central repository system and used a power Confidential script to deploy the application for testing locally. Daily updated InfoPath forms and checking in the TFS.
• Actively performed in the daily scrum meeting.

Environment: Visual Studio 2010, C#, ASP.NET 3.5, Entity Framework 3.5, LINQ, SQL Server 2008 R2, Windows XP,TFS 2010, IIS 5.0, InfoPath, SharePoint Designer 2010

Confidential

Associate Software Developer

Responsibilities:

• Invested time in understanding the core functionality and brainstorming on the various modules.
• Designed the functionality using 3-tier architecture with the layers such as Presentation, Business and Database layer in the source code.
• Created a common Master page to allow centralizing the layout of the application.
• Used HTML and CSS to design the web forms in the application.
• Worked on various ASP.NET Controls like grid, calendar, textbox, checkbox, label, button, checkbox list, list box control, radio button list, and dropdown list etc. to create ASP.NET pages.
• Used JavaScript to perform client-side validation such as required field validator, range, compare, regular expression, and summary and server-side validation on the code.
• Connected to SQL Server database objects using ADO.NET.
• Wrote Stored Procedures and SQL queries for add, update, edit and delete and performing other calculations.
• Worked on fixing security flaws such as Cross site request forgery (CSRF), SQL Injection, Cross Site Scripting and Directory Traversal in the application.
• Hosting the website using IIS 5.0 to the Confidential Internal network.
• Performed test, bug fix, deployment and provided production support for the application.
• Participated in the Stand-up meeting every day in the development phase.

Environment: Visual Studio 2008, C#, ASP.NET 3.0, HTML, CSS, JavaScript, JQuery, SQL 2008, IIS 5.0, Windows XP