SUMMARY

• 10+ years of IT Professional experience with both The Web and Windows Application using ASP.NET using C#, VB.NET, ADO.NET, WCF, Java Script, XML and HTML
• UI Design, Development & Support experience using ASP.NET Web Form and MVC, C #, VB.NET, WPF, Silver light
• Extensive experience in working with ASP.NET, JQuery, XML, Windows based Apps, ADO.NET, LINQ, Web Services, WCF
• Expertise in relational base design, d extraction, transformation, writing Dbase queries, Packages/ Stored Procedures, Views, Functions, Triggers Using Oracle and SQL Server 2005/2014
• Extensive exposure in writing Business Logic in PL/SQL and TSQL for financial Applications.
• Experienced in handling different dbases like Oracle SQL Server 2005,2014, and MS Access
• Good Experience in Service Oriented Architecture (SOA)
• Experience in Software Development Life Cycle and extensively exposed to ER Studio.
• Good understanding of the Object - Oriented Analysis and Design along with UML
• Ability to Work in a complex, deadline-oriented environment

TECHNICAL SKILLS

• Programming Languages: C#.NET, VB.NET
• Scripting: JavaScript, JQuery, Bootstrap
• Technology: ASP.NET Web Form, MVC4 & 5 (Razor), Silver light, WPF, WCF, Web API
• Web based: HTML5, CSS3, Bootstrap, JavaScript, JQuery UI
• D Access Framework: Entity Framework, LINQ to SQL, MS DAAB, Code First EF Model, ADO.NET, Dapper
• Configuration Management: TFS, Visual Source Safe, SVN
• Dbases: MS SQL Server 2005, 2014, Oracle 10g, 11g, MS Access
• Reporting: SQL Server Reporting Service, MS Report Viewer, SAP BO/ Crystal Reports
• Case Tool: MS Visio, E-draw Max, Embarcadero ER Studio, MS Project
• Other packages: MS office
• Operating Systems: Windows XP, Windows7, Windows 8

PROFESSIONAL EXPERIENCE

Confidential,

Responsibilities:

• The "Application Administration Module" is the umbrella for all new applications. The Administration module was earlier built on using ASP.NET Web Form 2.0 now it has been converted it into MVC and J-query using "Admin LTE" Template.
• From a dbase perspective, it is an enhanced version of "aspnetdb" available in SQL server.
• Features of the application include defining the New Applications/ Modules with the type of Application, the type could be web Form / MVC / Desktop based Application / WPF or XAML based apps. Defining the Roles / Groups of a given Module.
• Defining the Menu Items Recursively Nth Level of a given module. Assigning the Roles to the Menu Items / Pages of a given module. Defining the new Users. or resetting their passwords by admin. Assigning the Groups/ Roles of a given module to Users. User Based Reporting.

Environment: VisualStudio2015, Dapper (ORM), NET4.5, JQuery, CSS3, HTML5, C sharp, Team Foundation Server, ASP.NET MVC, Razor, Sqlserver2014

Confidential,

Responsibilities:

• Calendar management (Branches Based) & Auto Execution of Day/Month/Qtr/Year end processes.
• Post Period Transaction Mgmt (opening of closed periods) only available to HO, based on Audit observation for adjustment of wrong entry made in past by different branches for a given period.
• Journal Vouching Other Then Loan (Primary system for maintaining Banks Affair statement/ Trail Balance). Interface with Oracle EBS (Payroll) for integration salary voucher to update the trial balance in CBAS.
• Management of subsidiary Ledgers for each Branch.
• Capable of Handling Different Working Dates of Each Branch (460) Branches, Inter Branch online Transaction of Loan Recovery cash only (from another branch).
• Disbursement Through Cash / Account.
• Integration with D.M.S (Deposit Management System) For Disbursement through Account + Recovery Through Account # Capable of Handling Disbursement/Recovery with effective dates (which was not entered/vouched in the system on same working date).
• Option for Reversal of Voucher on the same day, special approval for reversal on past date based on three step approval and rebuilding all dues in case of past date reversal.
• Installment Plan ( based on Installment Frequencies, Grace Periods, No of Installments, Int Rates, Handling of Fixed 1st Due Date is 07-JAN or 07-JUL based on configuration)
• Annuity Ratio if Gap of 1st Installment is not equal to rest of installment because of 1st Due Date (07-Jan/ 7-Jul)
• Monthly Accruals (Configurable to Quarterly, Daily)
• Conversion of Performing to Non-performing and vice versa as Per State-Bank Instructions
• Provision of Outstanding Principal based on State-Bank Instruction in case of Default Categories

Environment: Agile methods, NET Framework 4, ASP.NET Web Form, C#, TFS, XML, Visual Studio2012, Oracle 10g, IIS7, JQuery, WCF, Microsoft Report Viewer, Crystal Report/ SAP BO Project:

Sr. Analyst Programmer,

Confidential,

Responsibilities:

• Migration of Legacy system D to Centralized Branch Automation System using Scripts.
• The major migrated components are
• Customer Profiles (2 Million Active Customers)
• Borrower Land Information (1.2 Million)
• Credit Investigation D (Live Loan Profiles)
• Loan Account Balances As on 30-JUN-2016 (1.1 Million Accounts) (1.8 billion dollars outstand Balance As on 30.06.2016 of All Live Cases)
• General / Subsidiary Ledger balances As on 30-JUN-2016
• Installment Plan of Live Loans (5.3 million Records)
• All Configuration (more than 40 configuration Entities)
• Risk Ratings of live loan cases
• Reschedule Information about live Cases.
• Provision of Principal's LC wise and reconciled with Branch Provision GL (1710).
• Accruals Case wise for regular cases and reconciled with Branch Accrued GL (6362) Balance.
• Markup Case wise including regular and NPL.
• Bifurcation detail of performing / Non-performing (Regular and NPL)
• Live Cases Recovery Vouchers since disbursement.
• Other Charges LC wise (legal Expenses due to court cases).
• SAM (Special Assets Management) cases which are made out of Books and declare loss due to 3 years of default any recovery(principal and markup) in these cases are part of income only because 100% Expenses are booked and credit the principal GL during shifting process from regular into SAM.. While Provisioning starts from 2nd category and onward by 20, 50 and 100 % and finally shifted into SAM.
• Outstanding Originated entries for other Branches pending to respond

Environment: Oracle PL SQL, SSIS

Confidential,

• Help desk support System is a work flow system designed for the Branches, Zone and Head Office level, users. Branches users make the complaint regarding software’s, network, Installations through this system.
• This request/ complaint is then forwarded to Zonal Support Officer, where he may able to resolve, Deferred, or forward the issue to the next level.
• The forwarded request then assign to respective Department Representative, Who may assign the ticket to the respective technician of the department, or even change the category of the request if it does not pertain to his department. The technician may set the status to deferred, Resolve, Not an Issue, Assign to other.
• UI Design and modifications using ASP.NET tools.
• Wrote the stored procedure to validate the flow of the systems and assign to the next category based on defined Workflow of the system.
• Reporting of the system Aging Wise, Status Wise, Location Wise, Category/ Sub Categories Wise, Opening and Closing during the Week, Month, and Year etc.

Environment: NET4, C#, Team Foundation Server, ASP.NET, Visual Studio 2010, SQL Server 2005, IIS7, SAP Business Objects

Confidential,

Responsibilities:

• ISO 8583 is an international standard for financial transaction card originated interchange messaging.
• It is the International Organization for Standardization standard for systems that exchange electronic transactions initiated by cardholders using payment cards.
• I have developed the Utility for message integration with both Banks.

Environment: Visual Studio 2012, C#, WCF, XML Document, Crystal Reports, MS Report Viewer, ODP.NET, Oracle 11g

Confidential,

Analyst Programmer,

• Internal Audit Management System (IAMS) provides the entire feature set to handle audit related activities.
• It can be called as the ERP of Audit. Used by ZTBL Internal Audit Division at head office as well as field offices.
• This system is also used by audit users for better recording of audit observations and their compliance from Audi tee to track records.
• Field Audit Department (FAD) of Audit Division currently performs audit tasks at branches.
• Discussion with Business Users to understand the complete cycle of FAD, CAD, ISAD departments
• Develop the Flow charts of the Business Process
• Defined the complete Business Roles and Identify the Entities for the complete process.
• UI Designing and Development using.Net framework and C#.
• Designed Complete Work Flow based on FAD, Corporate Audit Department, IS Audit Department.
• Developed Screen for Audit Planning and Team Formation and expected dates of arrival and closure.

Environment: NET3.5, C#, Asp.Net, MS Excel, SQL Server, SSIS, Crystal Reports, MS Report viewer