SUMMARY:

• 14 years of IT experience: Retail, Medical Devices, Utilities Services (Electricity/Pole Restoration), Healthcare Services, Supply Chain and Online Payments/Financial Services
• .NET development (developing Web, Windows and Console Applications for both ETL and IT teams):
• ASP.NET 4.6.1 MVC 5 Web Application implementing Unity IoC Container (Dependency Injection)
• ASP.NET Web API (also RESTful) development part of Full Stack ASP.NET Website using Angular 2, NodeJS (MVC5 - Model & Controller in Web API module and View in Website module)
• BATCH .NET C# Console Applications for batch processing automated via Automic
• Backend development in both .NET IT projects and ETL/Datawarehouse projects
• Healthcare: FACETS data model
• SQL Server
• Greenplum / Postgresql (Tool: SqlDbx & PGAdmin)
• Sybase IQ & ASE (Tool: SqlDbx)
• DataStage development (ETL tool: IBM InfoSphere DataStage)
• QA Engineer with Scripting & Automation experience in Selenium and MS Visual Studio Telerik plugin
• About 14 years of experience in Application/Software Development including about 12 years of experience in .NET development including team lead & Dev experience in developing ASP.NET Applications for Web API and Websites using MVC-RESTful-Entity, Windows Applications using C#, Winforms, Console based, WPF, Telerik, DevExpress Controls, ADO.NET, Visual Studio.NET and .NET Framework using OOAD and Service Oriented Architecture (SOA) in multi-tier applciations and backend using SQL Server 2005/2008
• Wrote unit test case libraries using C# & NUnit and also experienced in writing test cases and test plans for QA, UAT, FQA and RQA and executing test cases (Black Box & White Box testing) using Selenium and C# scripts for automation
• Experienced in writing SQL queries, Stored Procedures and functions using MS SQL Server, Greenplum and Oracle
• 10 years of experience in writing Technical Specification Documents and Screen Notes based on Functional Requirement Documents and Business Requirement Documents including experience in using software & data modeling tools like Visio & DB Designer
• 2 years of experience as a C++ Developer (beginning of Object Oriented Programming Career)
• Have been a customer advocate for more than 4 years and bringing in customer perspective in various cross vertical initiatives run by Confidential technology
• Extensive experience in all phases of SDLC including project estimation, design, development, QA and Live support for features/applications with experience in development using version control tools like Visual SourceSafe, Team Foundation Server (TFS) and ClearCase
• Have also been developer, team lead and project co-coordinator of the RISK-Compliance domain in Covansys- Confidential that designs, implements and releases features to minimize Confidential fraud and Compliance losses
• Experienced on working projects based on Agile Methodology (Scrum) to meet timelines with quality deliverables

TECHNICAL SKILLS:

Programming Languages: C, C++, C#, Java

.NET Technologies: .NET Framework 4.6/4.5/4.0/3.5/3.0 , ASP.NET, ADO.NET, WPF

Design Pattern: CSLA, MVVM, MVC (client Confidential framework) and MVC 5, 4

Scripting Languages: Perl, JavaScript, Python, tcsh/bash Unix shell script

Testing Tools: NUnit, Selenium, Telerik, Xamarin Studio (MonoDevelop)

ORM: nHibernate, Entity Framework (DB First Modelling), LINQ to SQL

Web Technologies: HTML, DHTML, CSS, XML, XSLT, PHP

RDBMS: SQL Server 2005/2008/2014 , Sybase (SqlDb & RapidSQL tool), Oracle 8i/9i, MS AccessPostgreSQL, Greenplum

Software Modeling: MS Visio 2003/2007, UML, Rational Rose, OOAD

SCM Tools: Clear Case, MS Visual SourceSafe, Team Foundation Server (TFS)

Defect Tracking Tool: ClearQuest, JIRA

IDE Tools: MS Visual Studio, Visual Slick Edit

Operating Systems: WIN NT Server/2000/XP/Vista, UNIX, Linux - Red Hat 6.0

EXPERIENCE:

Confidential, Dallas, TX

Software Developer (Consultant)

Responsibilities:

• Design of TM General Inquiry using ASP.NET MVC 5 in RESTful and SQL Server as backend database
• Design, development, testing and deployment of Confidential Windows Application on Purchase Order Maintenance: TM MultiPO Maintenance application, PO Notes (Purchase Order Notes) application using C# and WPF (Windows Presentation Foundation - XAML file) in MVVM (Model View-View Model) framework and SQL Server as backend
• Wrote custom library TM.Merchandising.UtilityBase for ValidationHelper, WPFHelper (using Interface INotifyPropertyChanged, ICommand), DBHelper and consumed by above mentioned WPF applications
• Used 3rd party controls - Telerik UI for WPF controls in XAML in the WPF applications
• Implemented login and security group control using database driven methodology in addition to Windows credentials
• Code review in dev phase; Support and bug fixing in Dev, SIT, UAT and PROD phase/environments
• Extensively wrote Table designs handling dependencies, Views, Functions and Stored Procedures including XML parsing in SQL Server 2018

Environment: C#, ASP.NET MVC 5, Entity Framework, WPF, XAML, MVVM, Telerik UI for WPF 2018, MS Visual Studio 2017, SQL Server 2014, SQL Server Profiler 2014, Visual SourceSafe

Confidential, Fort Worth, TX

Sr .NET Developer

Responsibilities:

• Diner Web - First step towards enhancing and moving Diner 2.0 business logic and backend to the web, in progress - design & development of Web API Services using RESTful Services and MVC 5 framework implementing core services of Diner 2.0 with existing DB in SQL Server as Backend
• Working knowledge of hosting Web API in MS Azure with SQL Azure backend
• Design and development of VB.NET Diner 2.0 application using Object Oriented on CSLA (Component-based Scalable Logical Architecture) Design Pattern and using SQL Server 2018 as backend
• Multiple Winforms client projects (SmartClient, MaintenanceClient, DataExport), Object layer project and Database layer project as Business Objects in CSLA Framework under one solution DinerCPak
• Used 3rd party controls Infragistics for UI design with controls such as UltraWinGrid, UltraWinTree, UltraWinListView
• Maintaining all database objects (scripts for table creation, Stored Procedures, Functions, etc.,) in TFS and keeping code and database in sync using TFS SQL Server Schema Comparison in MS VS 2017 with .NET 4.5
• Practiced Continuous Integration on Diner CPak Client and Maintenance Client in automating build, test and publish win installer exe to publish folder mapped to url upon code check-in in TFS
• For performance enhancement used SQL Server Profiler for running trace to monitor Stored Procs and Queries executed by DinerCPak on DB Server and tweaking/rewriting SPs and Queries
• Code promotion/deployment on different environments - Dev, Test, VAL and PROD
• Wrote Functions and Stored Procedures using T-SQL in SQL Server 2018
• Agile methodology running in biweekly sprints and tasks/progress tracked in JIRA

Environment: C#, ASP.NET Web API, MVC 5, MS Azure, VB.NET 4.5, CSLA Framework, Infragistics 4, MS Visual Studio 2017, SQL Server 2018, SQL Server Profiler V14, TFS, Agile, JIRA

Confidential, Buffalo, NY

Sr .NET Consultant

Responsibilities:

• DataReview Web Application is a non-customer facing internal web application to analyze all client's wood pole decay using decay algorithm to help Osmose's clients save money by better predicting service inspections if required or not. This is part of Osmose's big initiative of predictive analysis.
• Worked solo in design & development of ASP.NET MVC 5 Web Application with SQL Server 2014 as backend
• Used JavaScript in Views for dynamic display of image of each item in list (paged list) using checkbox and also for tooltip
• Used MVC 5 and implemented separate class (Repository) for Data Access Layer (using ADO.NET) and developed separate class implementing Entity framework
• Designed and developed SSIS package to automate consolidating data from 800+ servers databases of similar schema to one target server (database) in SQL Server
• Heavy work on writing Stored Procedure that is called by the SSIS package and also writing inline queries within SSIS package
• Extensively worked on SSRS to generate complex reports for pole decay predictive analysis from different data sources in SQL Server Database
• Automation/Scheduling SSIS package in SQL Server Job Scheduler
• Wrote C# .NET Console application with SQL Server as backend to process PDF and Excel files, move files and email notification (using SMTP) for specific recipients for processing files for specific customers
• Implemented library EPPlus for excel file processing
• Created Views in SQL Server 2014 to get customer file data to process files from specific paths
• Scheduled this application in Windows Task Scheduler

Environment: ASP.NET 4.6, MVC 5, JavaScript, MS Visual Studio 2015, SQL Server 2014, MS SSRS, MS SSIS (Integration Services in Visual Studio), .NET 4.5.2 Console Application, EPPlus library, SQL Server Job Scheduler, Windows Task Scheduler, TFS

Confidential, Rochester, NY

Lead .NET Developer

Responsibilities:

• Wrote C# .NET Console Applications & C# Winforms .NET application using SQL Server as backend and .NET Framework 4.6 from legacy Excel Macro and MS Access legacy application
• Started designing and developing prototype ASP.NET Web API using MVC 5 with .NET 4.6.1 to house Expediting Report & Functionalities for Engineering team VB Code Applications (MultiLotGenealogy, CVML Reports and Expediting Reports):
• MultiLotGenealogy Application: Excel Macro based VBA Application. Designed and developed MultiLotGenealogy application to track status, history and generate report on contact lens manufactured under specified lot range and machine type.
• Wrote Stored Procedures and Views in SQL Server 2012 that is called from VBA code of MultiLotGenealogy

Environment: C#, MS Visual Studio 2012/2015, ASP.NET Web API, MVC 5, .NET 4.6.1, SQL Server 2012, Visual Basic 6 (VB 6), MS Access (DB), Telerik Decompiler, Excel Macro with VBA code

Confidential, Buffalo, NY

Lead .NET Developer, ETL/SQL Developer

Responsibilities:

• Lead developer with offshore team for ASP.NET Project for modules Website (Angular2): Offshore and Web API (MVC 5): Local and also responsible for Dev & QA App Server setup, installation and deployment
• Full Stack designed and developed APD Claims Error Dashboard Application, mainly the ASP.NET Web API with Unity IoC Container Dependency Injection (Model & Controller - Business & Data Access Layer ADO.NET) and integrated with front-end that is implemented via ASP.NET Website using Angular 2 and NodeJS
• Tested and published/deployed above ASP.NET Web Application (Website using NPM and Web API using File System Deploy) in new Dev Web Server
• Involved in new dev web server setup (also IIS) and resolving issues including firewall issue, connection with SQL Server (via TLS & SHA)
• Designed & developed alternate design prototype application: ASP.NET Web Application using MVC 5 and Unity
• Designed & developed prototype: ASP.NET Web API using RESTful Services and MVC 5 for APIs above as alternate
• Designed & developed another APD prototype application: ASP.NET Web Application using Entity Framework and LINQ to SQL implementing ORM concepts instead of ADO.NET SQLClient namespace classes
• Experience in OOAD techniques, service-oriented architecture (SOA)
• Wrote Stored Procedures and designed and created tables using SQL Server 2014
• Design & development of DataStage jobs using IBM InfoSphere DataStage Designer to generate pipe-delimited extract files that is FTP’ed to vendor of New York State
• Wrote complex Functions in GreenPlum (database) querying FACETS data including performance tuning that is invoked by DataStage jobs
• Generated claim reports that are monthly, quarterly and yearly by different type of reports using SSRS HBX (Health Benefit Exchange program) - 834 Outbound process with the New York State - Billing & Claims Processing:
• 834 Outbound application is written as C# Console application that is run daily in Automic workflow
• Wrote 834 Outbound application by which 834 Outbound files in X12 format are sent to the New York State containing data about members/subscribers being terminated or cancelled or effectuated or reinstated
• Also incorporated Facets Member/Subscriber, Provider Data Model in 834 Outbound code
• Wrote Stored Procedures and T-SQL queries in SqlDbx (tool for Sybase database)
• Optimized Stored Proc for performance in SqlDbx setting showplan and displaying execution plan; minimizing table scans by adding indexes and index hints
• Design & Development: Decompiled VB6 Executable (using .NET Reflector and Telerik) and rewrote legacy VB 6 Application to .NET C# Console Application and using Rapid SQL (IDE for SQL Development) as Backend
• Creation of excel files based on incoming flat text files and adding email functionality at the end of excel file created and run as batch/daily process through Automic workflow
• Wrote 9 applications in MS Access DB (both UI and DB side) that is used by field agents to track patients under treatment for specific diseases
• Enhancements and defect fixing in VB6 legacy application
• Writing stored procedures and queries in Rapid SQL and SQL Server
• Responsible for Development, Code Review, Testing (Unit Testing), QA Support, Deployment to PROD and supporting CAB approvals

Environment: FACETS Data Model (Member/Subscriber Data Model), ASP.NET 4.6.1, MVC 5&4, Angular 2, NodeJS with NPM, C#, MS Visual Studio 2012/2015, SQL Server 2010/2014, MS SSRS, MS SSIS, IBM InfoSphere DataStage Designer, SqlDbx, Sybase, Automic tool, JIRA, Agile, HP ALM, TFS, Visual Basic 6 (VB 6), MS Access (DB), Rapid SQL (SQL IDE), RedGate .NET Reflector, Telerik Decompiler

Confidential, Round Rock, TX

Automation/Quality Engineer

Responsibilities:

• Worked as Automation/Quality Engineer for Feature Team: Security
• Wrote automation test scripts (main and reusable test scripts) using Telerik in MS VS and C# as the coded steps for Feature Requirements in Security module for DSA (web application) and used MS TFS as Version Control
• Created and executed test scripts (for functional, regression and smoke testing) both locally through MS VS and also scheduled runs using MS Test Manager on select build and machine (manual and automated)
• Fine tuning existing test scripts for better performance and trouble-shooting failed test scripts
• Part of migrating test scripts from Telerik to Selenium (C# - Web Driver)
• Created and tracked defects in MS TFS space for different environments such as DIT, SIT, VPOD and PROD
• QE approval and elevation process: 24 X 7 coverage to test, verify and approve code elevation/deployment between environments
• Created automation test scripts for smoke test suite that is run for approval for elevation/deployment using MS Test Manager
• Stringent deliverables using Agile methodology with Daily Standup (SCRUM) and biweekly sprint
• Worked in colocation environment (with Dev team) and also global environment with team in India, Ireland and Malaysia

Environment: C#, MS Visual Studio 2012 Ultimate with Telerik plugin, Telerik Test Studio, MS Test Manager, MS TFS, Selenium (C# web driver code)

Confidential, Austin, TX

Team Leader / .NET Developer & QA

Responsibilities:

• Major milestone: Lead for ATP DCC Move: Migrating ATP Application Server and ATP DB Server for both QA and PROD as Data Center is moved from Austin to Atlanta
• Enhancement and maintenance of ATP Backend Application (C# with heavy business logic in Stored Procedures in SQL Server) as per requirement from business
• Developed as per change request on ATP UI Application using C#, WPF (XAML) with Telerik controls and MVVM design
• Implemented ADO.NET in data access layer in both ATP UI Application (C# Windows WPF Application) and ATP Backend Application (pure C# Console Application)
• Wrote unit test class libraries in C# for testing modules in ATP Backend Console Application using NUnit framework and ran unit tests using NUnit GUI Runner Application
• Modified Stored Procedures, Views and Functions according to Change Request/Bug using SQL Server 2008 R2
• Created new views in SQL Server 2008 R2 for Business User team to run reports
• For DCC move: Wrote and executed test cases in MS Test Manager for ATP UI Application and ATP Backend Application in both QA (also UAT testing) and PROD environment for DCC Move
• Used MS Test Step Editor in running and capturing result of test cases that were written using MS Test Manager
• Modified .bat and Perl scripts to accommodate server move/name changes
• Used MS Team Foundation Server (TFS) for Version Control
• Wrote documentation on ATP System Setup and ATP Account Setup

Environment: C#, MS Visual Studio.NET 2008 R2, WPF, MVVM design pattern, XAML, .NET 4.0, NUnit, ADO.NET, IIS, MS SQL Server 2008 R2, MS Test Manager, MS Test Step Editor, MS TFS

Confidential, Austin, TX

Software Engineer / Developer Technical Services Engineer

Responsibilities:

• Developed Windows and Web applications integrating Confidential APIs (APIs in Confidential products such as Adaptive Payments, Adaptive Accounts, Account Authentication and Permissions) using C#, VC#.NET and ASP.NET for internal debugging and understanding
• Wrote C# Console Application and C# Windows Application using Winforms and consumed Web Services (svcs. Confidential .com) providing services such as Pay, PaymentDetails, Preapproval, Refund, ConvertCurrency, etc., using bindings Name-Value pair, XML, JSON and SOAP
• Wrote Java applications in Eclipse IDE to consume Web API (Adaptive Payments) to sample to Developer at Confidential API vendors
• Developed and approved ASP.NET application with MVC 4 for Confidential mid-sized clients (client side application)
• Used XSLT for presentation and transferring of data from XML file into HTML pages
• Wrote unit test libraries in C# using NUnit framework and also used Selenium C# script for browser based testing
• Wrote PHP files integrating Confidential API stated above with NVP binding
• Helped client & client developers design their application business logic and high-level architecture and database design and what Confidential product and APIs can be used for their application according to their business requirements
• Debugged and corrected C#, VC#.NET, PHP, ASP.NET code/application sent by client developers and help them run their application in Live
• Working knowledge of Entity Framework, nHibernate and LINQ to SQL
• Utilized ADO.NET technology extensively for data retrieving, querying, storage and manipulation
• Certified developer applications by providing help with application submission and approval process that involves business logic review abiding developer policies
• Created and ran SQL queries and stored procedures using MS SQL Server for generating report on client’s app status and approval
• Used JQuery in JIRA to query on bugs and for generating reports and exporting to Excel
• Provided live support to mainly small and medium sized businesses and also large merchants globally and also provided direct support to certified Confidential developers
• Identify, investigate and resolve top issues for Confidential ’s client developers and internal team (Account Management, Sales, Business Unit, and occasional Exec escalations)
• Identified, verified and filed bugs on irregularities in Confidential API functionality using ClearQuest and JIRA

Environment: C#, Visual Studio.NET, Winforms, Web Services, Java, Eclipse, ASP.NET, MVC 4, ADO.NET, LINQ to SQL, Entity Framework, nHibernate, NUnit, Selenium, MS SQL Server 2008, ASP.NET, PHP, HTTP/HTML, XML, XSLT, ClearQuest, JIRA

Confidential, Irving, TX

.NET Developer

Responsibilities:

• Designed modules DayPickList and Purchase Summary Recap and presentation layer using winforms
• Designed and developed business logic layer and data access layer for the above mentioned modules with MVC design and using C#
• Implemented and consumed Web Services (SOAP, WSDL and UDDI) to communicate with wrapper class on data access layer using SOA concepts
• Designed and developed batch process Update Balance On Hand to create and implement functionalities in business and data access layer using C# and SQL Server
• Used typed DataSet as a container to pass the data retrieved from the server side to the client side
• Implemented Data access layer using ADO.NET to connect and retrieve and manipulate database information
• Wrote Stored Procedures and SQL queries for data retrieval and update for the 3 modules using SQL Server Management Studio Express 2005
• Designed the sequence diagrams using MS Visio, and class diagrams using Visual Studio following the 7-Eleven Technical Specifications Template
• Wrote the Functional Checklist and system test cases for DayPickList, Recap and Update BalanceOnHand modules
• Wrote the Technical Specification Document, for three out of five modules and reviewed it at the approval meeting with Product and the Business Team
• Used Team Foundation Server (TFS) for Version Control
• Followed Agile development methodologies (SCRUM) with a close, daily cooperation between business team and developers
• Involved in Unit Testing and Integration Testing of different modules using NUnit
• Created Data Model using DB Designer

Environment: C#, MS Visio, MS Visual Studio.NET, NUnit, Web Services, MVC, SOAP, WSDL, XML, SQL Server 2005, DB Designer, TFS, Windows NT/2003

Confidential, Irving, TX

Software Developer

Responsibilities:

• Developed Web forms using ASP.NET controls and C# as the code-behind language
• Wrote Stored Procedures and Queries using SQL in MS SQL Server
• Designed the classes and database structure using MS Visio
• Extensively used GridViews to list the files and assets and to add new / edit / delete records
• Implemented editable GridViews along with validation
• Implemented Pop up functionality and document upload and download through the web pages using user defined control in ASP.NET
• Developed custom controls with specific functionalities and validations such as validation on every web form for already existing records, max/min length, regular expressions, not null etc.,
• Implemented Data access layer using ADO.NET to connect and retrieve and manipulate database information
• Used Visual SourceSafe for Version Control
• Created unit tests and documenting test case results for different modules
• Using Report Viewer to generate reports for sales orders and invoices

Environment: Visual Studio.NET, C#, ASP.NET, ADO.NET, MS SQL Server, MS Visio, Visual SourceSafe