Pratyush Agarwal

Design,Architecture and Development of Technical Solutions addressing Business requirements using Microsoft Technologies

Zensar Technologies Ltd, Sr Software Engineer, Sandton,Johannesburg,South Africa (Apr 2008 - Oct 2008)
1. Capital Gain Tax (Onsite)
Calculates capital of clients for their investments and reconciles accounts. Scans 50 billion records, calculates and reconciles them. A web based SOA architecture. Very efficient code that uses Mathematics formulae rather than traditional coding and preferred cloning to deign patterns to save memory as Collection of objects is used to hold the data for calculation and reconciliation of row by row processing. Used Sql Server Framework like exception handling, Temp variable indexing, UDF and Temp tables to bring data from Linked Server and to XML to insert bulk records in one action. Runs even without UI means scheduler and time to calculate is reduced to 3 hrs from earlier of 30 Days.
Covers Stock Deals, Gilts, Bonds, Dividend, Corporate actions, Reversal Deals, Bear Sale, Futures Deals, UPA deals.
Client: Investec Bank SA Duration (July 2008-Oct 2008)
Role: As SSE involved in Analysis, Design, Framework Building, Development, Unit Testing, Deployment.
Environment: C# 3.5, Silver light, ASP.Net, Ajax, Threading, WCF, MSMQ, Visual Studio 2008, SQL Server 2005, SSRS.

2. Market Services Online (Onsite)
This is and Intranet application used by Investec Securities Ltd People to perform their all the daily work.
This included Market Info, Portfolio Management, User Management, Brokerage Scales, Client Management, Fund Manager, International Trading, Research, Reports.
Client: Investec Bank SA Duration (May 2008-June 2008)
Role: As SSE involved in Analysis, Development, Testing, Deployment.
Environment: C# 3.5, ASP.Net, Visual Studio 2008, Ajax, Doondas Charts, WCF, MSMQ, SQL Server 2005

Mphasis Software Solutions India Ltd, Module Leader, Mumbai (May 2008 - Feb 2008)
1. Gateway Rearch
This is online banking project for 2nd largest bank of US for its retail customers. It is SOA architecture and allows customer to view their accounts, change password, change security code

Client:JP Morgan Chase Duration: 6 months (Sep 2007-Feb 2008)
Role: As a Module Leader with a Team Size of 20 involved in Development.
Environment: C# 2.0, ASP.Net, Visual Studio 2005, XML, Web Services, SQL Server 2005, JSP

2. HDFC SMS Service
This is mobile SMS Service project for sending SMS for NAV, SA, Registration, Premium, Branch, HELP.
Client:HDFCSL Insurance Duration: 4 months (May 2007-Aug 2007)
Role: As a Module Leader with a Team Size of 2 involved in Development.
Environment: C# 2.0, ASP.Net, Visual Studio 2005, XML, Web Services, Oracle.

C#, VB.Net, UML, XML,XSD,XSLT,SQL Server, Oracle, My SQLWCF, MSMQ,WWF, Silverlight, Linq,ASP.Net, ASP, Web Service, JSP, Eclipse
Visual Studio.Net 2008, Visio, Rational Rose, Perforce, MS Project, Open Office, Lotus Notes
VSTO 2005 SE, Rational Clear case, TFS, Test Directo,Design Patterns, OOAD, Agile, SOA,
Microsoft Application Blocks,

Investment Banking, Securities, Logistic, Retail Banking, Insurance, ,Ecommerce,Consulting,
Products,CRM,SCM,CPM,CMS,Process re engineering