Resume

Sign in

Project Sql Server

Location:
Chennai, Tamil Nadu, India
Posted:
April 13, 2018

Contact this candidate

Resume:

S Thangamuthu

Summary

More than *+ years of experience in software development and maintenance of Business Applications, System Implementation, etc.

Worked extensively in ASP.NET 3.5/4.0, C#, WCF, WPF, LINQ, SQL Server 2005/2008.

Rich experience in all stages of PDLC including requirements gathering, design & documentation of the architecture, detailed client-server and web/Windows-based applications specifications, development, testing, implementation and post-implementation support.

Hands on Experience in offshore coordination and Onsite development (SCB,Western Union, India)

Good communication, interpersonal skills and self motivated to implement next-generation paradigms.

Willing to learn cross domain/technology.

Ability to manage and build the team.

Work Experience

Organization

Designation

Period

Capgemini India Pvt Ltd

deputed in

Scope International Pvt Ltd

Consultant

Jun 2016 To Oct 2017

Virtusa Software Solutions

deputed in

Scope International Pvt Ltd

Senior Software Engineer

Nov 2012 To Jul 2015

SHAAR Technologies

Deputed in

Virtusa Software Solutions

Senior Software Engineer

Jan 2012 To Oct 2012

Target Software Solutions

Senior Software Consultant

Feb 2010 To Jan 2012

PRIST University

Web Designer

Apr 2008 to Feb 2010

Pentasoft Technologies Pvt Ltd

Developer

Feb 2007 to Mar 2008

Technical Skills

Web Technologies

ASP.NET 3.5/4.0, WCF

Scripting Language

AJAX

Database

SQL Server 2005/2008, Oracle 10g

Languages

C#

Other

Remedy (Incident management, Change management, Problem Management, RMS implementer ), Software Configuration Management (VOB/ Branch request, DOD request, SCM Plan, SCM Variance request), Tortoise SVN 1.7.5, Project document preparation like FSD, AIG, ABG, ASRM, Architecture diagram, OLA,SLA and HUSA transition, DR drill.

Educational Qualifications

Qualification

Name of Institution

Board/University

Period

% Marks

Bachelor of Engineering in

Electronics & Communication

P.R. Engineering College.

Bharathithasan University

2004

68

Higher Secondary

Kalyana Sundaram Higher Secondary School, Thanjavur

State Board

2000

67

SSLC

Kalyana Sundaram Higher Secondary School, Thanjavur

State Board

1998

77

Support Applications

Role

Senior Product Analyst

Responsibilities

Liaising with business stakeholders in understanding their requirement and proposing the best solution.

Given adequate training to the business users with respect to the product

Finding the Root cause analysis (RCA) for most recurring technical issues, troubleshooting and fixing the same

Closed several risk attached to the applications – includes technology obsolesce risk

Ensuring that problems are attended and resolved on time without any delay or escalations.

Application

Description

Ezeepay

This application is mainly used for salary process. It will receive the file from the business with the Credit and Debit details and it will validate the account number with the eBBS (Core Banking) System through online. It will check the Credit and Debit balances should be tallied. The system will generate an output file to upload the transactions into the eBBS (Core Banking) system.

SIGCAP

SIGCAP is a product developed by a Bahrain Software Company, The ultimate aim of this product is to capture customer signature and retrieval of customer signature. The application is having interface with core banking product and many other applications as well. The application can support different database such as Betrieve, SQL, Oracle and DB2. It’s is running in 25 countries and involved in several major roll out of the application.

SIGRECON

This application is used to reconcile the accounts captured in sigcap system with eBBS (core banking) system. It is mainly used to find out the account which needs to be capture in sigcap system and also to find out the mismatch in dormancy status of an account. It will generate various reports along with a download which will be again uploaded to sigcap system to make the accounts dormancy status of sigcap system in synch with banking system. The application is running in 25 countries and involved in roll out of the application.

eIBM

This system is used to process Islamic Banking products like Islamic commodity Murabaha Program (CMP), Reverse CMP, Islamic Cash Murabaha Financing (corporate financing), Islamic Goods Murabaha to name few. This system works on maker/checker concept. Maker will input the deal details and Approver will review it and approve it, once approved relevant documents with respect to the products will sent to customers via Fax using an interface called RightFax and during EOD accounting entries will be generated and it will be uploaded in core banking system. Various On demand Reports are generated.

Relevant Project Experience

Project Title#1: Project eSIGCAP (Jun 2016 – Aug 2017)

Description: This (Sigcap) is a vendor product, I supported to users whenever they are facing any problem in this application. This product is used in more than 24 countries with one or more branches in each country. The databases used for this application are Oracle, SQL Server.

Role: I have played as a “Consultant” and following are my contribution

Database consolidation Project.

Data migration and implementation activity for Malaysia, India, MESA & Africa countries, Hongkong eSigCap migration project.

Written queries and PL/SQL blocks to get reports like audit trial, user list with security matrix and analytical reports.

Developed tools to automate the branch update.

Responsibilities:

Effectively contributed in support and maintenance of this product.

Develop utilities to automate this product with other application.

Testing & Bug fixing. Analyzing resolving the technical issues/problems.

Environment: Windows XP, Windows 7, Windows 2003, Windows 2008, Oracle, SQL Server.

Project Title#2: Islamic Banking Murabaha System (IBMS) (Mar 2013 to Sept 2013)

Brief Profile:

SCB has launched murabaha based Islamic banking products in various countries.

This Murabaha product has been classified into four major product groups namely Deposit Based Products, Global Market Products, Finance (Lending) Based Products and Consumer Finance Products. IBMS containing two main modules like Global Market Product (GMP) and Deposit Based Product (DBP). IBMS is a web based application. GMP module was used standard chartered Saadiq (SCS) Like ALM, FMO, LPU, and GSSC Finance. The system maintains all the transactions of metal and goods deal for trader / customer / broker. It contains six sub modules such as Masters, Mapping, Transactions,Enquiry, Reports, Security.DBP module used Consumer Transaction Banking (CTB) and Consumer Banking (CB-RLS) unit for SCS.DBP module get feeds from different TP systems like RLS, eBBS, ACBS and based on that system will calculate weightage of profit. It contains eight sub modules such as Masters, Upload, Asset, Deposit, Weightage, Enquiry, Security and Reports. In this system the user group is parameterized and can create n number of user group based on the privileges given to the user. IBMS was captured this business functionalities like automation of processes and their sequence based on data entry, introduction of systemized Maker-Checker, Enquiry concept, effective monitoring and control, auto generation and faxing, emailing of confirmations/offer/acceptances, centralized database, built in data archival procedures and backup facilities, elimination of manual excel registers/Word files, brokerage calculation, proper audit trail, security mechanism, addition of new products with operational case, reduced lot of paper work and ability to extract different MIS/Reports.

Role: Team Member

Responsibilities : Prepare Functional Specification, Design and Coding, Database activities, Interaction with SIT, UAT and UVT and Deployment.

Project Title#2: eSigcap Data Migration (Mar 2012 to Feb 2013)

Brief Profile:

Sigcap is to capture customer signature and retrieval of customer signature. The application is having interface with core banking product and many other applications as well. The application can support different database such as Betrieve, SQL, Oracle and DB2.

Role: Team Member

Responsibilities: Converted the SCP Application Data which have 45LK records to Sigcap by using Stored Procedure in SQL Server Environment. Performed Design and Coding, Database activities, Interaction with SIT, UAT and UVT and Deployment.

Project Title#3: iWatch – WesternUnion, Chennai (Jan 2012 to Feb 2012)

Brief Profile:

Western Union AML regulatory reporting division reports suspicious transactions to regulatory authorities in various countries. Each regulatory authority has one or more reports with a defined format (pdf, csv, xml) which needs to be filed (transmitted in different modes online, upload of docs, regular mail of printed reports) within x days of the transaction date.

The user base (Analyst, QA, Supervisor and Administrator) would use a client application that provides the functionality as defined in the business requirements specifications. The application is expected to be a thick client application providing a rich user experience and make daily tasks easy.

ARRM UI Service Layer is the application server component that services the calls from the client application by updating/retrieving information to/from the application database. This additional layer helps to ensure that the database server need not be exposed to all the clients to connect, thereby making the system more secure and compliant with data center security requirements.

Role: Team Member

Responsibilities:

Understanding existing business model and customer requirements.

Analysis of the client requirements and projecting the impact.

Following the process to be adopted for a PDLC project.

Technical Environment:

ASP.Net 4.0, C#.Net, WCF, WPF, SQL Server 2008, LINQ.

Project Title#4: Menuworx-US (Dec 2010 to Nov 2011)

Brief Profile:

This providing an online platform for "Green" business and Food & Beverage Establishments to conduct an extensive and successful online marketing campaign. It will be able to create a "Homepage" with a customized URL, which will be able to be viewed by non-members such as consumers, businesses, and food service employees. On their homepage, they will be able to upload documents like menus, Flyers, Coupons, Certificates, and Brochures. The uploaded documents will be sorted in any format; however, our preferred format is PDF (Adobe Readers), which can be installed in any PC or MAC Computer. When using Adobe, information will be protected with a password what will allow only the consumer to have printing capabilities and it will also zoom in to the text which in the document for patron with poor eye sight. By allowing consumers the ability to print from home or the office, the cost of printed media will be lowered, hence our environmentally friendly “Paperless Marketing Program".

Role: Team Member

Responsibilities:

Understanding existing business model and customer requirements.

Analysis of the client requirements and projecting the impact.

Involved completely in the development of the enhancements as per the standards meeting the requirements in Functional Specification.

Level 2 & 3 production support.

Following the process to be adopted for a PDLC project.

Technical Environment:

Dotnetnuke,ASP.Net,C# 3.0, Java Script, Visual Studio 2008, HTML,SQL Server 2008,Microsoft.Net Framework 3.5.

Project Title#5: Proposed PO Application, Eaxes Soft-UK (Feb 2010 to Dec 2010)Target Started

Brief Profile:

The proposed PO application is a easy-to-use procurement management system that can streamline the complete purchase process and drive significant savings directly to your bottom line. The solution can automate Indenting, requisitioning, budget checking, purchasing, workflow approvals, Vendor Bills Posting to Sun System and inventory control.

Role: Team Member

Responsibilities:

Understanding existing business model and customer requirements.

Analysis of the client requirements and projecting the impact because of it.

Involved completely in the development of the enhancements as per the standards meeting the requirements in Functional Specification.

Worked in Integration of this application with a Business Intelligence tool called Business Objects.

Ensure quality of deliverables from the offshore.

Level 2 & 3 production support.

Worked as a Quality Leader for this project.

Following the process to be adopted for a PDLC project.

Technical Environment:

ASP.NET 3.5, ADO.NET, C# 3.0, SQL Server 2005.

Project Title#6: MyStudentEvals (Jan 2009 to Jul 2009) pentasoft over

Brief Profile:

The objective of this project is to design & deploy evaluations, generate reports on evaluations for all user types including custom types in a school or district. It has been designed to be used by multiple schools and districts.

Role: Team Member

Responsibilities:

Involved in Functional Design and Development of the software.

Application Designing and Coding.

System Testing.

Technical Environment:

ASP .Net, C#, SQL Server 2000.

Project Title#7: MyEvaluations.com (Sep 2008 to Jan 2009)

Brief Profile:

The objective of this project is to maintain evaluations of residents and attending in a hospital by doctors. It has been designed to be used by multiple hospitals.

I have worked on the procedure export system, which exports procedure count, and related data from sql server to excel, access, formats.

Role: Team Member

Responsibilities:

Involved in Functional Design and Development of the software.

Application Designing and Coding.

System Testing.

Technical Environment:

ASP .Net, C#, SQL Server 2000.

Project Title#8: Precious Performance Improvement Programme, India (Feb 2008 to Sep 2008)

Brief Profile:

This Software product provides keeping “Human Resource” motivated at all times and retaining “technical skill set”, becoming a nightmare and posing a real challenge to HR and other function heads. PPIP comes handy as a software tool to manage and meet such challenges at ease, based on “Six-sigma Controlled” approach.

Role: Team Member

Responsibilities:

Involved in Functional Design and Development of the software.

Application Designing and Coding.

System Testing.

Technical Environment:

ASP .Net, C#, SQL Server 2000.

Project Title#9: MIDCAB/SLRCTS, India (Jul-2007 to Feb-2008)

Brief Profile:

The objective of our web Application project is to collect the patient’s Information of the New York state Thoracic Surgeon Hospital. Details such as Admission Date, Discharge Date, Surgical Info, Clinical Info etc. Patient’s Reports can be generated dynamically. E-mail can be sent whenever it is required to each patient.

Role: Team Member

Responsibilities:

Involved in Functional Design and Development of the software.

Application Designing and Coding.

System Testing.

Technical Environment:

ASP.Net, C#, ADO. Net, HTML, SQL Server 2000

Passport Details

Passport No : L2938100

Valid From : 04/05/2013

Expiry Date : 03/05/2023

Personal Profile

Date of Birth : 14.06.1982

Father Name : Mr. P.Swaminathan

Sex : Male

Marital Status : Single

Nationality : Indian

Languages Know : English, Tamil.



Contact this candidate