Technical Skills

• Databases: SQL2008, SQL2005, Sybase, Oracle, DB2, MS Access.
• Data Access: WCF, Entity Frame Work, ADO.Net, SQL Native Client, ODBC, OLEDB
• Programming languages: C .NET, VB.Net, ASP.Net, VBA, HTML, XML, JavaScript,T-SQL, JQuery.
• Development Tools: MS Visual Studio 2010/8/5/3. Expression Studio 3, AJAX, SSRS, SSIS, CSS. Monarch, SQL Server Management Studio, SQL Server Business Intelligence, SQL Delta, Ultra Edit.
• Frameworks: NET 4.0, 3.5, 3.0, 2.0 and 1.1.
• Servers: Windows 2008, Windows 2003, Windows 2000 and Windows NT
• Desktop Operating Systems: Windows 7, Windows XP, Windows NT
• Mini Computers: IBM AS400, Client Access 400
• Main Banking Systems: Equation DBA Banking System,
• Kapiti International Banking System, Midas System, LoanIQ,
• Wall Street Systems

Relevant Experience

Confidential

• Developed Digital Mail report. Totally new application.
• Canada Project Created eight highly complex reports
• Broker Fee nine complex reports
• Currently working on PFAC project.
• Campaign Manager Application.
• Technology used: ASP.Net, C .Net, CSS, 4.0 framework. WCF, Perforce, Reflections, IBM Data Studio VS2010 etc.

Confidential

Project Manager

There are 3 type of reports created during the above mentioned projects. The decision about the type of report was based on the amount of processing time it will take to generate that report. There were built-in controls to prevent multiple submissions of reports simultaneously by a user to prevent overloading of the server. Three tier structure was maintained as almost all reports allowed user to build a complex selection criteria before invoking the generation process. Each selection parameter was validated before allowing the submit button to invoke the report generation. Stored procedures, List collection, Linq, delegates, foreach loop, object casting, switch, case, partial classes and many libraries were used during the compilation of the dataset for reports.

• has a built in capability to export the report in many different formats based on the add-ins available on the desktop running the report. The main built in formats are PDF and MS Excel.
• Reports which were displayed in the report viewer on the screen. This Microsoft ReportViewer
• Reports which were sent via e-mail with Excel attachment.
• Reports which were sent via e-mail with PDF attachment.

In addition to the reports the last project was a Campaign Manager Application. In this application heavy usage of ASP.Net controls were used. The most powerful and complex was the editable GridView that had radio buttons, check boxes, button control and textboxes. The behavior of each of those controls depended on the data values in the GriView rows or elsewhere on the page. This was handled by setting various indicators on or off. Based on the state of those indicators properties were set on at row binding event handler i.e. visible, enabled, disable, hide, color or fonts etc.

• Page dirty flag was used to select only the records which were modified and only those rows were updated in the database instead of the whole dataset.
• Parsed comma delimited file with claims and loaded into SQL Server 2008 database using SSIS package
• Parsed 835 EDI file and uploaded to SQL Server 2008.

Confidential

• Responsible for building class libraries using C .Net and Visual Studio 2005.
• Building ASPX pages using C or VB in the code behind.
• Designed relational databases using SQL Server 2000/2005.
• Wrote complex SQL Queries.
• Authored reports with SSRS using drilldown, drill through, sub-reports and parameterized reports.
• Used many Ajax controls to enhance the look and feel of applications
• Updated change control system of any changes.
• Participated in evaluation and testing of new tools and technologies.
• Participated in user group meetings to report progress and receive feedback.
• Participated in management meetings to get directions and guidelines.
• Played an active role in defining application security using windows authentication.
• Introduced SSIS and replaced several BCP and FTP batch processes.
• Developed maintenance plans to automatically backup databases.
• Implemented Commercial Paper Trade Capture Application using ASP.Net, C .Net and SSRS.
• Designed and implemented Money Market Fund trade capture application using ASP.Net, C .Net and SSRS.
• Designed and implemented Cash Management System using Oracle, Sybase and SQL Server as the backend databases and ASP.Net/VB.Net and SSRS as front-end reporting platform.
• Designed and implemented Nostro Reconciliation System and built many controls to maintain the integrity of data. This was highly visible project. Thousands of open items were reconciled within the first week of deployment. This application was written using VB.Net and SSRS.
• Designed and implemented GTMIS FXPL . This application was a management reporting application for all the Foreign Exchange and Money Market business of the bank. ASP.Net, C .Net and SSRS.
• Designed and implemented Call Back Log Application using C .Net and SSRS.
• Designed and implemented Good Faith Deposit Application to keep track of disbursements of good faith deposit for newly created leasing business and integrated with Cash Management System for position keeping.
• Designed and implemented an application to manage customer order to sell 5 pound notes Jack Nicklaus Note issued by The Royal Bank of Scotland plc .
• Developed and migrated several MSAccess applications to Web based applications.

Accomplishments:

• Managed the Y2K compliance project.
• Managed the configuration of the data center.
• Managed and configured the disaster recovery site.
• Managed two main system conversions
• Implemented document management system Doc-Manager for loan documents.
• Played a vital role in integrating RBS and NatWest systems after the merger.
• Operated the Branch from disaster recovery site for one week in a real disaster situation.
• Introduced Microsoft Reporting Services.