Hem Chandra

Rockville, Maryland

469-***-****

adcjrh@r.postjobfree.com

OBJECTIVE:

Lead Developer with more than 15+ years of experience in full-stack development (C#, VB.NET, .Net, ASP.NET, ASP.NET MVC, Web API, Angular, AWS, SharePoint, InfoPath, SQL Server, SSIS, SSRS, Web services, WCF, LINQ, XML, TFS 2010/13, SVN, VSS, GitHub, Telerik Controls, UML, JQuery and JavaScript) for building various desktop and web applications.

SUMMARY:

• Working experience on ASP.NET, ASP.NET MVC framework, Web API and Entity Framework.

• Working experience on SharePoint 2013 and SharePoint 2010.

• Proficiently learned AWS (Design, Deployment, AWS EC2, S3, Cloud watch, Load balancing & Lambda etc.).

• Understanding of Microsoft Azure Cloud (Design, Deployment, app services, Azure Functions etc.).

• Extensive experience in coding using C# and VB.NET

• Implementation experience of various designs patterns (GOF).

• Involved in Creation, Development and Deployment of SSIS packages in SQL Server.

• Used SQL Profiler for Performance monitor to resolve Dead Locks and long running queries by checking appropriate changes to Transaction Isolation levels

• Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues.

• Performed and fine-tuned Stored Procedures, SQL Queries and User Defined Functions.

• Extensive experience in developing UML Models using Visio and Rational Rose.

• Practical experience to implement SOA (Service Oriented Architecture: WCF) and Three-tier architecture.

• Methodology: AGILE, Scrum, Test Driven Development.

• Worked as TFS administrator (TFS Server setup, installation, collection creation, build automation, branching & merging etc.)

• Vertical/Domain Experience: Travel, Banking, Insurance, Chemical, Water and Energy

• Proficiently learned new technology Angular to meet client need.

PROFESSIONAL EXPERIENCE

Maryland Department of Labor Oct 2018 – Present

Lead Developer

Description:

Foreclosure System-The Foreclosure Registration System is a web-based application for submission of those foreclosure-related notices and registrations that are mandated by Maryland law. System verifies lender companies using Nationwide Multistate Licensing System & Registry (NMLS). Application is divided into three sub-systems.

1. NOI (Notice of Intent to Foreclose): Lender companies can submit NOI to DLLR. Notice is created in pdf and send to borrower thorough email as well as by post. User can also upload predefined csv files for bulk submission. SSIS package reads and saves data into database. System sends processed NOI status email to user.

2. NOF (Notice of Foreclosure Filing): Lender submits NOF in the system which creates notice in pdf and sends NOF to borrower through email.

3. FPR (Foreclosed Property Registration): Lender company admin submits property registration of foreclosed property. Payment is done by PayPal payment gateway.

User can access the system by https://www.dllr.state.md.us/ForeclosureSystems/

Responsibilities:

• Analysis of requirement.

• NMLS and PayPal payment gateway integration.

• Application designing and coding

• Database designing and writing stored procedures.

• Client interaction

• Helping team to resolve technical issues.

Technologies/Tools: C#, ASP.NET, SSIS, TFS, Aspose and SQL Server 2012

National Institutes of Health (NIH), MD May 2018 – Sep 7 2018

Lead Developer

Description:

Event Management site- NIBIB staff need a way to manage registration of speakers and attendees for conferences that they host. The site accommodates registration of conference participants internal to NIBIB, other ICs, federal agencies, and external to the federal space. The site is generic enough that it is used by all NIBIB departments, offices, and labs as appropriate. Staffs who have rights can create event with proper dates. Those events are shown in public landing page. When user hits registration button in event then system asks for sign in or signup. Once user sign in they can do event registration. After registration end date Event Creator can generate reports like total no of attendees with accommodation, total no of walking attendees, total no of attendee’s order for lunch, total no of attendees going to attend all session etc.

Responsibilities:

• Analysis of requirement.

• Application designing and coding

• Database designing and writing stored procedures.

• Helping team to resolve technical issues.

• Client interaction

Technologies/ Tools: C#, Web API, HTML, Angular5 and SQL Server 2012

National Institutes of Health (NIH), MD Nov 2016 – Apr 2018

Lead Developer

Description:

Grant Management System- This system is divided into three sub systems Grant assignment to Program officers (PO), Study section and council coversheet. Grant data is imported from CIT main oracle database server to department local SQL server. Based on PO experience Program Director assigns grants to PO. Program officers invite relevant officers for study section. Based on study section Program officers create council coversheets with recommendation. Those council coversheets are presented by Program officers in council meeting for taking decision to award grants. Documents versions are managed using SharePoint.

Responsibilities:

• Designing, coding and managing modules of the application

• Develop SSIS packages which include a variety of transformations, for example look up, Aggregate, Derived Column, Conditional Split and Data Conversion.

• Writing stored procedures.

• Helping team to resolve technical issues.

• Production Support.

Technologies/ Tools: ASP.net MVC 5, Visual Studios 2013, Aspose, jQuery, SharePoint 2013, C#, SSIS, Windows Server 2012 and SQL Server 2012, Jira.

National Institutes of Health (NIH) MD Jan 2016 – Oct 2016

Senior Software Developer

Description:

Electronic Assignment- This project is used to assign document to reviewer and track the status of documents assigned to reviewers. There are two types of assignments sequential and parallel. In sequential assignment document is assigned to next level after approval from previous level. In case of parallel assignment document is assigned to all at the same time. If document is approved by all reviewers, then it is considered as approved document. Application stores reviewers list i.e. routing based on document category.

Responsibilities:

• Implementation of work flow for business processes.

• Customization using Web Parts (using SharePoint object model).

• Team Foundation Server (TFS) setup (advance installation) and configuration in Windows Server 2012.

• Migration of Visual Source Safe (VSS) code repository to TFS.

• Build Automation in TFS server.

• Release Management.

• Implementation of Agile Project Management (Sprint).

• TFS Permission Management.

• Familiarize Agile Methodology to team.

Technologies/ Tools: SharePoint 2013, C#, SharePoint Designer, InfoPath, Windows Server 2012, VS 2013, Telerik controls, Nintex workflow and SQL Server 2008R2, Jira.

National Institutes of Health (NIH), MD May 2015 – Dec 2015

Senior Software Developer

Description

Teak Search – This project is used to search program officers involved in research of specific science terms and vice versa. Admin and management can also view reports like grant reports, science term reports, scientist reports, program officer’s portfolio etc. SSIS is used to load the data from oracle central database to departmental SQL Server database. Once data is loaded to SQL Server, SharePoint crawling is done on it.

Responsibilities:

• Implementation of SharePoint 2013 search and search API.

• Develop SSIS packages which include a variety of transformations, for example look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.

• Writing stored procedures on the database.

• Create SSRS reports to show grants and science related information.

Technologies/ Tools: SharePoint 2013, C#, SSIS, SSRS, Windows Server 2012, VS 2013 and SQL Server 2012, Jira.

Nalco Holdings, IL Sep 2012 – Mar 2015

Business Solution Analyst

Description:

Envision- Envision is not only simple web application or portal, it is business centric application. It monitors level of chemical tanks by reading alarms send by sensors. Envision sends alerts to customers to order (purchase) chemical when tank level reaches to reorder level. User can analyze chemical consumption using trend charts. It shows different type of alarms send by sensors. Nalco 360 team can take action on those alarms based on parameter values like pH etc. Envision also provides to customer highly calculated and automated business proposal for Boilers, Cooling Towers and RO and their work flows.

Responsive Web Design (RWD) concept is used to access it in mobile devices.

In Envision customers and their billing information are shown after extracting data from SAP and CRM using SSIS (package scheduled as job in SQL Agent).

Responsibilities:

• Based on user stories analyze, design and prepare SRS and Design documents.

• Writing stored procedures and SSIS packages which includes a variety of transformations.

• Managing a team and Client interaction.

• Develop complex components using C#.

• Exposed alarms information in the JSON format using WCF Services (Restful) for other applications like Toolbox and Nalco Pro.

• Production support.

Technologies/ Tools: ASP.NET, ASP.NET MVC, C#, Entity Framework, LINQ, SQL Server 2008, Visio 2010, SSIS, SSRS, Ajax, WCF Services (Restful), Telerik Controls and jQuery.

Nalco Holdings, IL Jan 2012 – Aug 2012

Sr. Application Developer

Description:

Informatica- Data ware house is created to analyze faulty alarms. Based on numbers of same type of faulty alarms management can take decision to repair/ replace hardware. If same types of faulty alarms are generated for almost all customers, then management can take decision to improve controller respective to that issue. Many types of reports like chemical consumption rate, reduction on faulty alarms generation rate etc. are generated for a year. Management can analyze chemical consumption history for a specific client.

Responsibilities:

• Writing stored procedures and SSIS packages which includes a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.

• Cube creation and writing MDX queries.

• Production support.

Technologies/ Tools: C#, SQL Server 2008, SSIS, SSAS and SSRS

Nalco Holdings, IL May 2011 – Dec 2011

Sr. Application Developer

Description:

myNalco.com- It is Nalco's Customer Web Portal. It is developed in SharePoint 2010. After login to myNalco.com user can navigate to other Nalco’s websites without login again to those sites (single sign on).

Controllers those are assigned to logged-in user are shown using WCF service as below.

Assigned legacy controllers of different sites. To know more about legacy controller user can click on controller and redirected Envision website.

Assigned next gen controllers of different sites. To configure controller user can click on controller and redirected to next gen controller configuration website.

If user has permission, he/she can be redirected to Nalco Pro website when clicks on link.

Nalco associates contact details who are working with him/her.

Responsibilities:

• Integration of WCF service with SharePoint 2010 using BCS.

• Based on user stories analyze, design and prepare SRS and Design documents.

• Client interaction.

Technologies/ Tools: C#, SharePoint 2010, WCF, ASP.NET, SQL Server 2008

Sales Partner Systems, FL May 2010 – April 2011

Sr. Application Developer

Description:

OASYS-Handheld Device Driver Application and Caravan Control Centre: OASYS Caravan transports provide paperless communication, bringing customer service to levels never before experienced in foodservice.

This system is divided into two applications.

1. Handheld Device Driver Application has following functionalities

o Automated systems including paperless manifest, invoices, and driver check-in forms reduce costs and eliminate hours of costly overtime.

o If internet available driver can update delivery status to CCC.

o Printing of invoices using Handheld printers.

o Provide stop by stop route information to driver. It removes fear of sending new drivers on a route.

o DB Sync process: After delivery driver can upload invoices, vouchers information to CCC.

2. Caravan Control Centre (CCC)

o It is a .NET web-based application which has following functionalities.

o Route Menu: Route manager manages drivers, trucks, trailers, routes and equipment (Like Tablet PC) assigned to drivers.

o Operations Menu: Operations personnel manages forms, invoices, pickup and collection

o Report Section: Delivery Status report, Routes report, Drivers details report etc.

Responsibilities:

o Develop application using .Net compact framework target to Casio handheld devices with minimal memory usage.

o Testing using windows CE Emulator.

o Writing queries for SQL Server CE.

o Development of the components and Maintenance.

Technologies/ Tools: Windows CE, SQL Server CE, .Net compact framework, ASP.NET, SQL Server

Marsh, GA May 2009 – Apr 2010

Sr. Application Developer

Description:

CS Stars: CS STARS provides a comprehensive solution for managing all types of claims for clients in all industries using web application. It also handles data related to occurrence, location, contacts and payments. Data can be imported from different data sources into system using SSIS and vice versa. Some functionalities like occurrence and claim has been exposed via WCF. Clients/ agents in their applications can use these exposed functionalities.

Responsibilities:

• Analysis, designing and preparation of documents.

• Developing web methods using WCF

• Writing stored procedures and SSIS packages.

• Managing a team and Client interaction.

• Development of the components and Maintenance

Technologies/ Tools: ASP.NET using C#, SQL Server 2005, Oracle 10g, Visio, NUnit, SVN, SSIS

Army Postal Services, India Oct 2007 – Apr 2009

Sr. Application Developer

Description:

1. APS: Army Postal Service Corps provides mail and financial services to defence and certain Para military forces through its network of around 500 Field Post offices (FPO) spread across the country.

2. Saving Bank Services Module: Work is done in maker/checker mode. All the transactions entered are verified and then committed in final database. List of document (LOD) and List of Transaction documents (LOT) are managed daily basis. If there is any addition or updation in LOD, Intimation email is sent to configured users. Saving Account, TD (1-5 years), RD, MIS, PPF, NSS and SCSS are handled in SB.

3. Responsibilities:

• Analysis, designing and preparation of SRS (in IEEE format).

• Developing Web Services, Writing stored procedures and queries.

• Manage a team and Client interaction.

• Development of the components and Maintenance.

Technologies/ Tools: ASP.NET using C#, SQL Server 2005, Rational Rose, FXCop

BCD Travels, UK Jul 2005 – Oct 2007

Sr. Programmer Analyst

Description:

NetProfile: NetProfile is a web-based application designed for travel agencies and travellers. It is basically used to maintain the profile of travellers. It also facilitates travel agencies and travellers to book the ticket using integrated GDS Amadeus, Saber, Apollo and GetThere (OBE). It is divided into four modules. The modules are ‘System Factory and Security Module’, ’GDS Export’, ‘Template Creation Module’ and ‘Bulk Import’.

Responsibilities:

• Designing, coding and managing a module of the application

• Developing Web Services, Writing stored procedures and queries.

• Client interaction.

• Development of the components and Maintenance.

Technologies/ Tools: ASP.NET, Web services, C#, VB.Net, SQL Server 2000, Visio 2003

Cox & King, UK Oct 2004 – Jun 2005

Programmer

Description:

INTRAM (Integrated Travel Management) - It is window-based project designed for travel agents for office operations (accounting operations). It is integrated with the front office operations. It supports hard closing and soft closing of the financial year. INTRAM not only generates the common reports like day books, ledgers, statements, trail balance, balance sheet but also very specific management MIS, clients MIS, Financial MIS, Airline MIS reports.

Responsibilities:

• Coding and testing

• Handle Admin section that involves concept of retrieving traveller information from downloaded “AT” files and put the details into the SQL database.

Sakshym services, India Feb 2003 – Sep 2004

Programmer

Description:

Logodisplaycase - This system supports online store of display cases like boxing display cases, glass display cases, golf display cases, football logo case, and hockey logo case. The project is divided into two sections User section and Admin section. The user section contains features like order placing form, shopping basket, and registration form etc. Admin section provides complete management of application that includes management of database and stock. Admin section tracks balance between demand and supply, regular updating units prices, product info.

Responsibilities:

• Coding and testing

Technologies/ Tools: ASP.NET using VB.NET, SQL Server 2000, Java script.

EDUCATION & CERTIFICATION

• Master’s in computer applications, VBS Purvanchal University, India

• Bachelor’s in science, University of Allahabad, India

• Microsoft Technology Specialist (MCTS) in WCF (For more information visit https://mcp.microsoft.com/anonymous/transcript/validate and use Transcript ID “909880” and Access Code “hemchandra” to access the information)

• AWS Certified Solutions Architect – Associate ( For more information visit https://www.certmetrics.com/amazon/public/transcript.aspx?transcript=01RPL6WKC2VEQ0C4 )

(Hem Chandra)

Contact this candidate