SUMMARY:

• .Net application developer with Eight years of programming experience in Analysis, Design and Implementation of Business Applications using C#, VB.Net, ASP.NET, jQuery, Angular JS, AWS, SSIS, DB2, SQL Server
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines
• Served as a Subject Matter Expert, guiding the development, maintenance, and support of a variety of applications.
• Resolved complex UI challenges, using latest technologies such as ASP.net, RESTful APIs, HTML5, CSS3, jQuery, AngularJS 2.
• End to End exposure in handling the client - side validation and experience using jQuery and JavaScript.
• Built Single-Page Web Application from scratch, leveraging Angular JS
• Good working experience on designing SSIS Packages, Crystal Reports
• Designed and modified Crystal reports for investment management reports. Automated expanding(horizontally) all the “objects” in a Crystal Report page using .Net for 110 reports
• Experience in using Language-Integrated Query (LINQ).
• Experience in Relational DBMS for DB2, SQL Server & Sybase by creating Database diagrams, stored procedures, functions, triggers, views, constraints, indexes and query optimization.
• Experience in conversion of complex stored procedures from Sybase to DB2
• Familiarity with .Net/Sql Performance tuning
• Solid Experience using .Net XML API to read and write XML Documents.
• Developed unit and integration test plans and automated unit tests.
• Experience in working in Agile and Waterfall model-based projects
• Experience in Automation of repetitive tasks done by client\developer
• Lead multiple Team with an experience in working with onshore/offshore model with multiple time zones.
• Acquired Intermediate level skill in Tableau, Power BI, Mongo DB, Xamarin through self-study and POCs
• Experience in working with version control tools like PVCS, Dimensions, TFS, SVN, Git.
• Build and configure TFS server/Jenkins for CI/CD (Continuous Integration, Continuous Development)
• Highly adaptable in quickly changing technical environments with strong organizational and analytical skills.
• Excellent communication and interpersonal skills with ability to interact with individuals at all levels and can work as a part of a team as well as independently

TECHNICAL SKILLS:

Languages/Programming: C#, VB.Net, ASP.NET, Web Apps, ASP.NET MVC, Web API, WPF, WCF, Crystal Reports 9, .Net Core, Excel VBA/Macros, MS-OFFICE, MS-Office Interop, iText, ASPOSE, JavaScript, jQuery, MS-SharePoint, Angular JS 2, Vue JS, Bootstrap, JSON, XML, XSLT

Databases: DB2 UDB, SQL Server 2013, Sybase

Tools: /Packages Visual Studio, AWS, GIT, SVN, TFS, PVCS, Splunk, Jenkins, MS Visio, Word, Excel, Outlook, Infragistics, Telerik

EMPLOYMENT EXPERIENCE:

Confidential, Middletown, RI

Software Applications Developer

Technologies and skills used: C#, VB.Net, ASP.Net MVC5, ASP.Net Razor Views, SQL Server, T-Sql, AJAX, JavaScript, jQuery, CSS, Bootstrap, Microsoft SharePoint, Visual Studio, Source Safe, TFS, Third Party dlls: iText, ASPOSE, Log4Net

Responsibilities:

• Re-engineer existing CLPPP application implemented in VB.net, Web Services, MS-SqlServer, Crystal Reports to C#, ASP.net, SQL Server based application
• Performing Coding/Programming tasks to specification and in accordance with development standards. Technology includes C#, VB.Net, ASP.Net MVC5, ASP.Net Razor Views, SQL Server, T-Sql, AJAX, JavaScript, jQuery, CSS, Bootstrap.
• Build and configure Team Foundation Server, connect to code repositories to automate the build and release into various phases in the development cycle.
• Analyse technical and functional specification document, prepare data for understanding the existing application workflows/functional routines.
• Design, develop and modify software applications/systems according to specifications and applicable coding standards.
• Conduct unit test for all deliverables against business requirements and research and resolve coding issues. Automate the testing of deliverables through the use of NUnit testing wherever applicable
• Support and troubleshoot software systems as required, optimize performance, resolve problems, and providing follow-up on all issues and solutions.
• Create and modify Database Tables, Stored Procedures, Functions
• Create database scripts for rolling out database objects in each phase
• Performance tune the database object through creation of Indexes, joins, modifying queries appropriately.
• Provide recommendations for the use of computer software/third party dlls/plugins, necessary JavaScript/jQuery based modern UI frameworks and design patterns.
• Develop appropriate software documentation as outlined in IDF and complete comprehensive unit testing on all developed/enhanced software.
• Co-ordinate with team members for query resolution, impact analysis, quality analysis, bug fixes.

Confidential, Roseland, NJ

.Net Technical Lead/Technical Architect/Developer

Technologies and skills used: .Net, AWS, DB2, Angular JS, Vue JS, Web Services

Responsibilities:

• Led the team in Application Modernization: WinForms Applications are converted to ASP.Net MVC, Angular JS 2, Vue JS Apps. Created necessary DB objects to support the migration.
• Consumed Web Services from Customer Office, to retrieve the latest data
• Integrated a new product NYPFL (New York Paid Family Leave) into the existing ASP.Net/DB2 product
• Developed SSIS Packages to Extract/Transform/Load feeds from external systems.
• Work with business units, software developers, security, to design and build applications within AWS
• S3 API implementation for accessing S3 bucket data files
• Created Excel Macro File to generate structured inserts, updates, deletes with ease
• Created ASP.net MVC application to automate creation of Deployment Files from local storage as well as from objects (Stored Procedures/Functions) deployed in DB, Involved in Requirement Analysis, Impact Analysis, Estimation
• Prepared Functional Design Specification document, Technical Specification Documents
• Involved in Implementation of the design, Carry out application maintenance and enhancement activities.
• Create Unit Testing, Unit Test Results (UTR), Support to E2E, QA & UA Testing teams
• Co-ordination between onsite and offshore for query resolution.

.Net Technical Lead/Developer

Confidential

Technologies and skills used: .Net, Angular JS 2, SSIS, SQL Server, WCF, Web Services

Responsibilities:

• Requirement Analysis
• Developed VB.NET code for Console Applications to process feeds from external systems
• Designed Screens for customer input for product suitability, using ASP.net MVC, Angular JS 2, SQL Server
• Developed SSIS Packages to Extract/Transform/Load feeds from external systems
• Created and consumed Web Services (Web API) to receive data from external systems
• Created/Modified Database objects for the CRs.
• Coordinated with Offshore, and track the status of the CRs
• Involved in Unit testing, QA, UA Support
• Performance Tuning of stored procedures involved in transforming the feeds.
• Document design specifications & technical specification documents

.Net Technical Lead/Developer

Confidential

Technologies and skills used: .Net, Interop. Word, SQL Server, DB2

Responsibilities:

• Developed VB.NET code for Windows Form Application(Complaint Handling Application)
• Provided enhancements to an ASP.net Web forms application ( Confidential Policy System), involving crud operations on several screens with grids.
• Provided validations for Web forms inputs using Jquery/Javascript.
• Involved in Office 2007 to Office 2013 migration
• Automated Letters (200) testing for the Office migration project
• Created/Modified Database objects for the CRs.
• Implemented SOAP Webservices to communicate with Documentum team to save, convert, retrieve letters
• Involved in Unit testing and QA Support
• Optimized the existing code for faster response through the usage of LINQ and caching of static tables in the application

.Net Developer

Confidential

Technologies and skills used: Crystal Reports, .Net, WPF, DB2

Responsibilities:

• Created/Modified 110 Crystal Reports
• Automated the horizontal expansion of the controls on the Crystal Reports for the change in the horizontal span of crystal reports.
• Created a Tool for extracting metadata (font, font style, font size) from the crystal reports. All reports modified for property changes as such with single button click, using the tool
• Created/Modified Database objects for the CRs.
• Developed VB.NET code for Batch applications to create reports and cyberfuse them
• Involved in Unit testing and QA/UA Support

Developer

Confidential

Technologies and skills used: ASP.Net, C#, SQL SERVER 2008

Responsibilities:

• Developed a complex user control involving a GridView/Accordion Panel/Button Fields/Label Fields.
• Designed dynamic menus for the Master Page completely derived from the Database, with the display of menu options restricted based on the user roles
• Created/Modified Database objects, primarily for the CRUD operation on UI grids
• Created Unit test cases for the DB objects/UI screens
• Performed Datatype, Custom Validations on Server Side/ Client Side
• Involved in defect fixing of the complete project, supporting through QA, UA
• Co-ordinating with onsite for the clarifications on the requirements.

ASP.Net Developer

Confidential

Technologies and skills used: ASP.Net, C#, SQL SERVER 2008

Responsibilities:

• Involved in the analysis of the classic ASP code
• Developed screens in asp.net from their Classic ASP counterparts
• Developed an automated tool to convert basic building blocks from ASP/XSLT/XML code to ASP.net designer pager
• Created/Modified Database objects, primarily for the CRUD operation on UI grids
• Created Unit test cases for the DB objects/UI screens
• Performed Datatype, Custom Validations on Server Side/ Client Side
• Involved in defect fixing of the complete project, supporting through QA, UA
• Co-ordinated with onsite for the clarifications on the requirements.
• GridViews/Datagrids/User Controls are widely used in the development

.Net/DB2/Sybase Developer

Confidential

Technologies and skills used: DB2, Sybase, SQLWays, C#.Net (Framework 3.5), VBA, PL/SQL

Responsibilities:

• Handled all the database interactions in .net code, changed them from Sybase procedures/SQLs s to DB2 procedures/SQLs s
• Converted 70 database Triggers and Tested them
• Converted 100 database Stored Procedures using SQLWays conversion tool and tested the same
• Performance Fixes in complex Confidential DB2 stored procedures
• Fixed issues in critical Confidential applications
• Created Functions to support Sybase like formatting of money fields, including decimal precision handling
• Created a tool to parse the SQLs to find the tables involved in Inserts/Updates/Deletes/Truncates in a stored procedure. Applied to 1500 procedures for analysis.

.Net/DB2/Sybase Developer

Confidential

Technologies and skills used: DB2, Sybase, SQLWays, C#.Net (Framework 3.5), VBA, PL/SQL

Responsibilities:

• Handled all the database interactions in .net code, changed them from Sybase procedures/SQLs s to DB2 procedures/SQLs s
• Converted 44 database Views using SQLWays conversion tool and tested the same
• Converted 390 database Triggers and Tested the same
• Converted 500 database Stored Procedures using SQLWays conversion tool and tested the same
• QA & UA support
• Fixed issues in critical Confidential Claim application
• Unix Batch testing and fix the issues in complex stored procedures
• Performance Fixes in complex batch and claim Confidential stored procedures
• Created Automated tool for finding possible Db2 runtime bugs involving NULL handling, Auto Truncation issues