SUMMARY

• 8 years of experience in Software Analysis, Design, Development, Implementation, Testing and Supporting distributed, Client/Server, Web/Windows - based software solutions for multiple business models
• Extensive experience in developing various Enterprise based Client /Server side applications (Windows, Web, XML Web Services and SOA) using Microsoft .NET and other technologies like C#, ASP.NET 2.0/3.5/4.0, VB.NET, Win Forms, ADO.NET, Entity Framework, LINQ, Web Services, ASP.NET MVC 3/4/5, WEB API, RESTful, WCF, WPF, XML, XSD, XSLT, SOAP and .NET Framework 1.0/1.1/2.0/3.0/3.5/4.0/4.5.2
• Used Version Controlling tools such as Subversion (SVN), Source Safe (6.0) and Team Foundation Server (TFS), GIT
• Good experience on Relational Databases, Proficient in Database programming, designing, modeling and development using SQL Server 2005/2008/ 2012/2014/2017 , Oracle 10g/11g, and Microsoft Access.
• Proficient in writing Stored Procedures, Cursors, Triggers, Views, User Defined Functions, Complex Query joins using T-SQL, PL/SQL, Performance Tuning and Optimizing SQL Queries.
• Experience in usingORM (Object-relational mapping) tools like NHibernate 3.1 and Microsoft Entity Framework 4.
• Strong abilities in Data Modelling, Database Design, Views, Normalization, Stored Procedures, Triggers, Views, and Functions.
• Develop reports or queries to retrieve and analyse data for projects/programs requiring sophisticated inferential techniques.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Experience in Angular 2 with good understanding of its style guide, modular design, routing, dependency injection & component structure.
• Used Angular Reactive forms to implement complex forms and performed the validations using Form Builder.

TECHNICAL SKILLS

Programming Languages: C#, VB Script, C, C++

UI Skills: HTML 5, XHTML, XAML,CSS 3, XML, XSLT, VBScript, JavaScript, jQuery, AngularJS, JSON

.NET Technologies: ASP.NET, ADO.NET, MVC, Entity Framework, LINQ, ORMOffice Developer Tools

Web Technologies: Ajax, IIS, XAML, XSL, Web forms, WCF, WWF, WPF, REST SOAP, Angular JS, HTML 5, DHTML

Data Warehousing Tools: SSAS, SSIS, SSRS

Databases: SQL Server 2012/2014/2017 , Oracle 10g/11g, MS Access

Web Server: Internet Information Server (IIS) 5.1/6.0/7.0/7.5/8.0

Protocols: SOAP, TCP/IP, HTTP, HTTPS, SMTP

IDE: Visual Studio.NET 2017/ 2015/2012/2010/2008

Framework: Microsoft .NET Framework 4.5.2/4.0/3.5

Versioning Tools: Subversion (SVN), Source Safe (6.0) and Team Foundation Server (TFS), GIT & VSTS (Visual Studio Team Services)

PROFESSIONAL EXPERIENCE

Confidential, Warsaw, IN

C# Software Analyst & Design

Responsibilities:

• Involvement in SDLC, which includes gathering of business requirements, architecture, design document, planning, development, deployment and maintenance of windows, web applications and portal infrastructures
• Implementing agile scrum methodology, (Daily stand up meeting, Sprint planning, break down concepts into user stories, plan future releases, and Prioritize backlog)
• Formulated technical specifications to support development and testing of C# components and implemented concurrency management
• Write Stored Procedures, Cursors, Triggers, Views, and User Defined Functions, Complex Query joins using T-SQL, PL/SQL, Performance Tuning and Optimizing SQL Queries
• Participate in design reviews and identify potential mitigation strategies for technical risks identified during the Unified Process phase reviews
• Evaluate, design, implement and maintain internal and external portal applications
• Testing and monitoring software applications and systems, including coordinating the installation of customizations to the applications
• Participate in Testing and Evaluation of new Technologies to ensure Compatibility and Functionality by following the Policies and Procedures for Change and Incident Management
• Compiling and writing documentation of program development and revisions, so that others can understand the program
• Retrieve the data efficiently by using LINQ to SQL, LINQ to XML and LINQ to OBJECTS
• Deploying the Projects using Microsoft Azure by CI/CD (Continuous Integration and Deployment) Pipeline
• Integrated SQL Server 2008 reporting services with MOSS (Microsoft Office Share Point Server) to automatically deliver reports to the Share Point portal
• Stay Current on Industry Trends and New Technologies and Recommend Future Initiatives by Collaborating with peer organizations, quality assurance and end users to produce innovative Software Solutions
• Extensively Work on C# Coding, Web API, JQuery, MVC6, ASP.NET core, Entity Framework core, Win Forms, WPF, ADO, .NET, XML, XSL, HTML 5, REST services, Generics, Web Services
• Managing the offshore team, assigning tasks and scheduling the weekly status review meetings
• Work in System and Server administration of Windows and Linux Environments

ENVIRONMENT: .NET Framework 4.5, Visual Studio.NET 2012, 2013/2015, MVC.NET 4/5, ADO.NET, C#, WCF, XML, HTML5, Bootstrap, CSS3, Java Script, JQuery, MS Unit Test, TFS.MS SQL server 2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T-SQL, Report Builder, MySQL, MS Access, Tableau, Angular JS and C#.NET

Confidential, Miami, FL

Sr. C# NET Developer

Responsibilities:

• Used C#, Web API, JQuery, MVC6, ASP.NET core, Entity Framework core, Win Forms, WPF,ADO.NET, XML, XSL, HTML 5, WSDL, Master Pages, Globalization, REST services, Generics, Web Services
• Maintained Portal Using E.M.R’S Using the SOLID principles, which help to design effective, maintainable, object-oriented systems
• Implemented Agile scrum methodology (Daily stand up meeting, Sprint planning, break down concepts into user stories, plan future releases, and Prioritize backlog)
• Formulated technical specifications to support development and testing of C# components and implemented concurrency management
• Involved in complex MS Excel Macro work, Visual Basic (VB) Script work, ODBC Driver Connection, Relational DB, Data Formatting, XLQuery Add Ins, Date Parameter Changes, and DSN Connections
• Created and maintained stored procedures and wrote SSIS packages (data flow, tasks, etc.) to Import/Export data from flat files, XML, Excel. Used SSIS for ETL operations
• Wrote SQL queries, Transactions, CTE (Common type expressions), Used SQL Profiler, Used SSRS (Microsoft Reporting services) for reports generation using SQL Server 2014
• Implemented CRUD functionality with Entity framework in ASP.NET MVC and implemented sorting, filtering and paging with Entity framework in MVC
• Created Custom Menu in Excel and Customized Menus in Excel Using VB Script that calls a Macro
• Involved in using MVC (MVVM pattern) for both UI development with Angular JS and application development with C#
• Used MSTEST Unit Testing, and Built Services, controllers using AngularJS to create WEB-API’s and Services
• Designed the Database and developed Stored Procedures, Triggers, and Views to create it using SQL Server 2017
• Worked extensively with Angular 2, Generated Components, Services using Angular-CLI
• Utilized GIT for source version control in a shared team environment
• Used Cloud Repositories in V.S.T.S (Visual Studio Team Services)
• Used LINQ to SQL, LINQ to XML and LINQ to Objects for retrieving the data efficiently and Just in Time manner
• Proven background translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs
• Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries
• Involved in MSTEST Unit testing and End to End testing. Handling production support and responsible for web application security
• Deployed Project Using Microsoft Azure using continuous integration and deployment pipeline (CD/CI)
• Created and maintained technical design documentation. Keep development process documents up to date
• Organized and maintained database using MS Access to provide accurate patient records
• Evaluated, designed, implemented and maintained internal and external portal applications
• Created, maintained and administered BI Portal and align with change & release management processes

ENVIRONMENT: .NET Framework 4.0/5.0 C#, ASP.NET, Web API, Bootstrap, Dev express, GIT,Azure,V.S.T.S, Devexpress, Postman, Entity framework core, Asp.NET core, Web forms, Angular JS, HTML5, MVC 5/6, SQL Server 2005/2008/2012/2014 Enterprise Edition, SSIS, T-SQL, SSRS, Windows Server, Visual Studio 2012/2015, Web Services, Visual Basic 6, Visual Basic for Applications (VBA), Excel and Access, UML, XML, nHibernate, CSS 3.0, IIS 6.0/7.5, LINQ, JavaScript, JSON, VSS, TFS and Tortoise SVN

Confidential, Miramar, FL

C# .Net Developer/SQL Server Developer

Responsibilities:

• Created SSIS packages for File Transfer from one location to the other using FTP task
• Used SQL Server 2012/2014 database as back-end along with ADO.NET Entity Framework and LINQ to access the database tables
• Developed stored procedures, views, and triggers for data manipulation, ensuring set up relations includes indexing, constraints and foreign keys
• Worked on creating Rest Services using ASP.NET Web API and C#
• Used N-tier architecture for the presentation layer, Business and Data Access Layers using C#
• Coding and debugging using ASP.NET and C#.NET and extensively worked on OLAP cubes using SSAS
• Maintained and updated MS Access databases macros and VBA modules
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
• End-to-End development of SSIS packages with sources, destination, transformations and customized error handling and logging using event handlers in SSIS packages
• Extensive working experience in Sitecore platforms like Web Content Management
• Designed, Developed and Deployed customized reports for the client Requirements with Data Driven subscriptions using SQL Server Reporting Services and Report Server
• Developed the logic to fix Day Light Savings for different time zones by creating Time Zone and DST Detail information table
• Created application using Angular JS/Angular 2, Python Rest API and HTML5/CSS3
• Developed complex stored procedures and SSIS Packages, convert and load data to front-end tools like Starmatic 2.0 portal and Arise portal
• Creation of database objects like tables, views, materialized views, procedures, and packages using SQL Server Management Studio (SSMS)

ENVIRONMENT: .NET Framework 4.5, Visual Studio.NET 2012, 2013/2015, MVC.NET 4/5, ADO.NET, C#, WCF, XML, HTML5, Bootstrap, CSS3, Java Script, JQuery, MS Unit Test, TFS.MS SQL server 2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T-SQL, Report Builder, MySQL, MS Access, Tableau, Angular JS and C#.NET

Confidential, Hoboken, NJ

.Net Developer

Responsibilities:

• Analyzed and Migrated Application using VB.NET and SQL server database as back end
• Used JIRA bug tracking system to log and work on defects
• Worked as an S.M.E (Subject Matter Expert) and Kept detailed records of project activities
• Used AJAX CONTROL TOOL KIT to enhance the performance of the application
• Used ASP. Net to create rich web interfaces
• Wrote JavaScript functions for client-side validations and DOM manipulation
• Designed and developed the required SQL stored procedures, Views
• Unit testing of all developed pages and modules, and pass on to QA for Testing
• Used SVN for the source & document version control
• Developed Web Forms using ASP.NET and C#.NET
• Created server controls using C# and .NET framework classes
• Designed and developed middle-tier database access objects using the Microsoft .NET framework with C# .NET and ADO.NET
• Designed, developed user interface looks and feel and functionality for web users using XML, HTML, JavaScript, DHTML, XHTML, CSS and using ASP.NET and C#.NET
• Involved in the Unit test and Integration testing
• Used ADO.NET to access the SQL 2008 database and to optimize queries
• Worked in taking Backups, Restoring, Import/Export data using MS SQL Server2008 and DTS
• Migrated SQL server 2008 database to windows AZURE SQL database and updating the connection strings based on this

ENVIRONMENT: IIS7, Windows 2008, .NET Framework 3.5, ASP.NET Web Forms, Web API, C# ADO.NET, AWS, Visual Studio .NET 2013 and SQL Server 2008

Confidential

.Net Developer

Responsibilities:

• Involved in AGILE software development methodology
• Developed Master pages to create a consistent layout of the pages
• Controlled the style and layout of various Web Forms using CSS
• Extensively used JavaScript to display client-side messages
• Created libraries to implement a Business layer that is consumed by VB.NET
• Developed Web User Controls for reusability
• Involved in writing Client-side and Server-side scripting
• Created and consumed Web Services using C#
• Extensively used ASP.NET controls such as Web Data Grid, Web Date Chooser
• Used ADO.NET as data-access middleware for retrieving data and updating records in the database
• Responsible for performing the backend database development of stored procedures, triggers, packages, and functions within SQL Server database environment using T-SQL
• Implemented Forms-based authentication
• Implemented source control using SVN

ENVIRONMENT: Visual Studio 2008, .NET Framework 4.0, C#.NET, ASP.NET, ADO.NET, JavaScript, Web Forms, Web Services, CSS, HTML, XML, IIS, SVN, Oracle, MS SQL Server 2005, T-SQL