Service Data

Mayur Tank

.Net Developer

Email: acyq2l@r.postjobfree.com Mobile: 872-***-****

SUMMARY

6+ years of professional IT experience in designing, developing and testing of Banking (Payment Card Industry and E-Commerce projects) using C#, ASP.NET, MVC, Ajax, Entity Framework, ADO.NET, LINQ, Web APIs(Rest Service), Web services, WCF, SQL, Oracle, JQuery, JavaScript, AngularJS, HTML, CSS, Crystal Report, Ajax Control toolkit, Dev Express.

Experience in Visual Studio development environment, for windows and web based applications having used them for professional and academic projects.

Experience creating multi-threaded application in windows form application.

Experience in waterfall and Agile Methodology for full life-cycle of the project such as planning analysis, prototyping, design implementation, testing, release and following for next iteration as per needs.

Proficient with all phases of Software Development Life Cycle (SDLC) with ample experience involved in designing, developing, Coding, Debugging, Testing and implementing software applications.

Experience in implementing Windows Communication Foundation (WCF) Service for Business Logic Layer for Service Oriented Architecture.

Experience working with ADO.Net component such as Dataset, Data Adapter and Data Reader.

Experience working with web servers such as IIS, and with source repositories, such as TFS.

Involved in requirement gathering by conducting meetings with the customers. Having good experience in Database (Stored procedures, Functions, T-SQL) using SQL Server 2005/2008 & Oracle and writing complex PL-SQL queries.

Experience in data object models like Language-Integrated Query (LINQ) and Entity framework to retrieve and modify data and developed entity data frame work services.

Experienced in developing rich GUI application using Ajax control toolkit and Dev-X controls.

Experience using AngularJS for E-Commerce project and experience using JQuery and JavaScript for client-side validation.

Expertise in using various software tools, languages and methodologies with special expertise in Microsoft .NET technologies and experience of developing end-to-end web applications on ASP.NET.

Understanding the risk and developing software with following PA-DSS (Payment Access Data Security Standards).

Financial, banking domain and E-Commerce experience for clients like HDFC bank, ICICI Bank, RuPay, Banco Popular, ZoomID and BSN Sports.

An effective communicator with exceptional communication & relationship management skills with the ability to relate to people at any level of business and management and excellent team building abilities.

Versatile team player as well as independent contributor. Managing resource allocations and setting up communication channels across various horizons of the organization structure.

Educational Qualifications

Computer Engineering (B.E.), Mumbai University

.Net Certification from Mikadoo Institute

Technical Skills

Database

SQL Server 2008/2010/2012, Oracle 10g, 11g

Language

C#, VB.NET, SQL, PL-SQL

Client Scripting

JQuery, JavaScript, AngularJS.

Reporting Tool

Crystal Report 10.2, Active X report.

Database

MS-SQL server 2005, 2008, 2010, 2012, 2013, Oracle 9i, 10g, 11g

Third Party Control

Dev Express 13.2.8

Middleware

ADO.Net, Entity Framework, WCF, Web Service, Web API.

Development Kits

Microsoft.NET Framework 4.5, Entity Framework, Ajax Control Toolkit

Web

ASP.NET 4.0, ADO.Net, Xml Web Services, IIS 7.0, JavaScript, JQuery, AJAX, JSON

Methodology

Agile (Scrum), Waterfall methodology.

Professional Work Experience

Client: Banco Popular, Chicago, IL.

Duration: March 2016 – Till Date

Role: Software Developer

Project: ITSS (IT systems services), CLIS (Commercial Lending Information System), Automated Development Tool, Monitoring Services.

Environment: C#, .Net Framework 4.5, SQL Server 2013, ADO.Net, Entity Framework 6.1.3, TFS 2012, Visual Studio 2010/2012/2014, HTML, CSS, Infragistic control.

Project Description:

Banco Popular (Popular community Bank), is one of the oldest bank. Bank internal uses many applications for performance monitoring, IT request, checking their commercial status and drawing plan as per the result.

ITSS is internal system for banks back office operation team and for development team, portal is already build and ready to use, but users required some enhancement in the portal and so new version with UI changes using HTML 5 and bootstrap css is used, few other enhancements were to add other vendors so operation team can directly raise a ticket to all vendors and stake holders. It also used for all IT related issues and a ticket are raised for each request with TAT for each request.

TMD application is also a request portal for software development, users would request a CR for new changes, developer will analyze the request and an estimate work hour required for the work to completed will be provided based on budget development will be started for the CR.

CLIS application is basically a loan lending application which will keep track of user details and documents that are uploaded in the system. CLIS is also used for analysis and based on analysis bank offers loan to the user with few schemes and credits. It helps boosting business with the detailed analysis and multiple calculations done for analysis.

Automated Deployment Tool is a small windows application build to check file for deployment, since currently deployment team is not using any automation tool, and so avoid any redundancy in files copied over from UAT to production, windows deployment tool is used. It basically has a very minimum functionality of check files already exists and logging the same, backing the old files and replacing with new files.

Monitoring Services is a service monitoring console application. Since, bank uses services from many different vendors and if one service is down it has great impact other applications using their services. It was difficult to monitor know the root cause of application failure due to which service and notifying also takes time, automatic monitoring service will keep pinging the service every 5 mins and if response is failed then mail will be send directly to service provide so a quick response is provided with less delay.

Role & Responsibility:

Involved in client requirement gathering and working on complex requirement, document the requirement in technical specification and developing.

Writing automated unit test cases.

Used TPL (Task parallel library) for better result and performance.

Created procedures, functions and tables in SQL.

Consumed Web Services and Web API services for monitoring services application.

Worked on Agile methodology, and participating in daily sprints and working on completing sprint.

Worked on third part tools like infragastic control.

Using HTML 5 for better UI.

Used entity framework 6.0 and ADO.net for different application.

Worked on Console applications, Winforms and web forms applications.

Worked with JavaScript framework like Angular 2.0 and Knockout JS.

Used LINQ query for better performance and fast response.

Fixing defects and unit testing code.

Client: CDW, Chicago, IL.

Duration: September 2015 – Feb 2016

Role: Software Developer

Project: Managed Service Fixed fee.

Environment: C#, .Net Framework 4.5, SQL Server 2013, Auto Mapper 4.2, Entity Framework 6.1.3, TFS 2012, Visual Studio 2010/2012/2014, HTML, CSS, Rest API.

Project Description:

CDW is internally divided into 3 companies. Company 01 – deals with Government, 02 – is general and 03 – for service, because of the division it causes problem to the client. Client gets separate invoice for the service and installation. Managed Services Fixed Fee project is basically to migrate customers to company 01 and 02, from 03 companies. It includes creating new customer based on the account type, migrating products and subscriptions. This will ensure in generating only one invoice and decreasing cost for printing invoice, also maintaining customer data would be very, since customer are bifurcated based on Account type.

Role & Responsibility:

Involved in various levels of the development life cycle by Gathering Requirements, Analyzing, Design and Development.

Used Windows Forms using visual studio 2014 for uploading input file, and migrating customer account, product and subscriptions.

Created multi-threaded application, validating each customer against iSeries making a Rest API call. Consumed Rest API for creating new subscriptions, Products and customers Account.

Created text file for logging mechanism for logging each customer account, product details and subscription details. It helps in reconciliation of data between old and new systems.

Used Auto mapper to map data with data adapter, data table and class entity. It ensure proper mapping of data with minimum code.

Created SQL procedure, function and complex queries for data migration.

Used SQL loader for bulk upload of input file. Input file will be in CSV format.

Used LINQ query to retrieve data from Arrays, collections and Generics.

Used JQuery for client side validation.

Used Entity framework for generating poco class from SQL procedures.

Created CSS class and applied CSS for better GUI.

Worked on Agile methodologies, and participating in daily sprints and working on completing sprint.

Involved in writing unit test cases, creating testing evidence for fixing defects and production support.

Created technical document with details specifying tools used for migration.

Client: ZoomID, Tacoma, WA.

Duration: Aug 14 – Sept 15.

Role: Software Developer

Project 1: BSN Sports (www.bsnjackets.com)

Environment: C#, .Net Framework 4.5, SQL Server 2012, WCF, Entity Framework 6.1, TFS 2012, Visual Studio 2012, WCF, JavaScript, JQuery, Html, css, AngularJS.

Project Description:

BSN Sports is an affiliate company of ZoomID. Website is similar to ZoomID and same jackets are shipped to the customer with BSN Sports branding. ZoomID pays commission to BSN sports for each jacket shipped via www.bsnsport.com. Processing is identical to ZoomID, where customer design the jackets and patches and places the order.

Role & Responsibility:

Designed and developed application using VS 2012 and C#.net, SQL server 2012, JQuery, JavaScript, AngularJS, Html, CSS, and WCF.

Involved in requirement gathering and understanding requirements, converting functional requirement into technical requirement, documenting requirements in the form of user stories and development module as per the user stories.

Implemented Agile Methodology or the project which involved daily scrums.

Developed applications at presentation GUI based on N-tier application architecture.

Created custom classes for different modules including order placement, customer account, etc.

Implemented client side validation using JavaScript and JQuery and used bootstrap CSS for application layout and component layout.

Designed Custom Validation Controls for validating the data in the User Control and used ASP.NET Validation Controls for server side validation and Java Script for client side validation.

Implemented Ogg chat functionality.

Created invoice for the customer in PDF format using Active X reports and generated reports for admin based on the data available.

Used AngularJS for validation and fetching data using the service factory.

Implemented AngularJS for Order placement reports which involve creating transaction block for credit card details and used authorize dot net for credit card validation.

AngularJS is used for validation and used bootstrap CSS for GUI.

Used Windows Communication Foundation (WCF) for rapidly building service-oriented applications that communicate across the web and the enterprise.

Created factory methods for different modules using WCF for binding with AngularJS controller for segregation of data.

Maintained TFS (Team Foundation Server) as a central repository system.

Used Entity framework and LINQ for easy retrieval of data making application highly maintainable.

Involved in creation of Database Tables, Stored Procedure and Functions in SQL 2012.

Created test cases, for unit testing and integration testing.

Debugging and defects fixing as per the test result.

Created Email utility, exception handling and error logging component.

Supporting all production related issues.

Project 2: ZoomID (www.zoomid.com)

Duration: Apr 14 – Aug 15.

Environment: .NET Framework 4.0, C#, ASP .NET 4.0, Entity Framework, SQL Server 2008 R2, DevX controls 13.2.8., Active reports, WCF, HTML, CSS, JavaScript, JQuery, Google Analytics.

Project Description:

ZoomID is a web based system that will enable the customer to customize a jacket, patches and thereby order the same. This system will also provide a facility where a user can choose his/her school, select a jacket template and get the customized patch work done for them. Customer can customize jacket and patch. The customized jacket will get delivered at the doorstep. As of now, delivery is available in United States of America.

Role & Responsibility:

Involved in requirement gathering and understanding requirements, converting functional requirement into technical requirement, documenting requirements in the form of user stories and development module as per the user stories.

Designed application using VS 2010 IDE and C#, while utilizing SQL server 2012 as backend.

Application involves N-Tier architecture and entity framework with dot net 4.0

Created and consumed WCF services to communicate between DAL layer and Database.

Used JQuery and JavaScript for client side validations.

Used TFS (Team Foundation Server) for version control.

Used third party control like Dev express control 13.2.8, which give high flexibility for UI and for reporting.

Used HTML and CSS for designing UI used across the application.

Created admin reports in PDF format using Active x reports and sales reports in excel format using Dev X Controls, hands on experience in binding data from Grid view data to excel reports.

Providing search criteria to user in grid view using dev express grid view control.

Involved in code review and Unit test cases for different modules.

Created test cases and executed test case for Unit testing and Integration testing of the application.

Involved in creation of Database Tables, Stored Procedure, Functions and writing complex queries in SQL 2012.

Used Entity Framework to bind data which is faster and code is also much neat and maintainable then ADO.Net.

Used LINQ query to filter result from Arrays, collections and generics.

Used google Analytics for gathering statics. It gives client real time statics of people browsing website and making a purchase order. It enables client to plan differently for the business.

Supporting all production related issues.

Client: First Data, India.

Duration: Apr 2011 – Mar 2014.

Role: Software Developer

Project: FDI Statement Generation

Environment: C#, VB.Net, .Net Framework 3.5, ADO.Net, Oracle 11g, SVN, Visual Studio 2010, Crystal Report, JQuery, JavaScript.

Project Description:

For this project, we are generating reports related for Merchant and Bank. In this we have various reports like FIRC (Foreign Inward Remittance Certificate), in which we are displaying all the Foreign Transactions for the merchant and calculate commission for the merchant.

We have Merchant Payment Advice, in which we have details for all the Transactions carried out at the merchant’s end. Total amount credited and debit (in-case of refund).

Report is in pdf format.

Roles and Responsibilities:

Actively involved in all phase of project design and development.

Involved in requirement gathering and understanding requirements, converting functional requirement into technical requirement, documenting requirements and developing software as per the requirement.

Created reports in Oracle server using Util library and for loop cursor for looping data.

Used ADO.Net object such as data adapter, dataset and data reader for consistent data access.

Designed and tested reports generated through oracle procedure in format like excel, csv and text.

Consumed Web Services for sending Email.

Created and consumed Web Service to validate Merchant ID.

Generated merchant report using crystal reports 10.0 based on huge amount of data.

Involved in reconciliation process which involves matching of the available data from bank with data from all source of file with minimum difference in data.

Implemented PA-DSS (Payment access data security standard) to adhere security requirements.

Created CTL file (Control file) for bulk upload of data in oracle. It will dynamically create and CTL file based on the data provided and Log for the missing file. CTL file specifying direct path gives better performance.

Used parallel, Oracle hints and indexes for oracle performance tuning. Parallel can be used if server has multiple cores, it gives better performance.

Created dynamic query to analyze Hints and indexes in oracle, it gives better performance and fast retrieval of data.

Used tortoise SVN as a version controlling tool.

Created test cases, executed test case documenting test as a testing evidence and fixing defects.

Actively involved in team-building activities.

Client: HDFC Bank, India.

Duration: Mar 2011 – Feb 2012.

Role: Software Developer

Project: HDFC Bank

Environment: C#, VB.Net, .Net Framework 4.0, ADO.Net, Oracle 11g, SVN, Visual Studio 2010, Crystal Report, JQuery, JavaScript, HTML, CSS, Ajax Control Toolkit.

Project Description:

It is an application for capturing and maintaining data related to merchant (card payment industry). It is involved in its enrollment, DVU, etc. Generating reports related to merchant and it transactions on daily, monthly basis. Maintains data related to its terminals.

Role & Responsibilities:

Actively involved in all phase of project design and development.

Involved in requirement gathering and understanding requirements, converting functional requirement into technical requirement, documenting requirements and developing software as per the requirement.

Coding and Debugging using Asp.Net C# and application module written in VB.Net.

Create reports and welcome letter for new user using crystal reports in PDF format and banks internal reports in excel format.

Created reports in Oracle server using Util library and for loop cursor for looping data.

Used ADO.Net object such as data adapter, dataset and data reader for consistent data access.

Implemented PA-DSS (Payment access data security standard) to adhere security requirements.

Modifying existing application following same coding standards and using same terminologies for building robust application.

Used Ajax control for asynchronous calls by using controls like update panel, timer control, cascading dropdown control, etc. for better user interface.

Used JQuery and JavaScript for client side validation to avoid server overhead for better performance.

Used tortoise SVN as a version controlling tool.

Created test cases, executed test case documenting test as a testing evidence and fixing defects.

Created project documentation including high level and low level diagram, data flow diagram and state transition diagram.

Contact this candidate