Summary:

• Eight and half years of professional experience involving designing, development, testing, implementation and support of applications using Perl , Sybase, Oracle, DB2 and Unix shell scripting
• Premium experience on investment banking and other financial domain
• Strong experience in writing Perl scripts covering data feed handling, implementing business logic, communicating with web-services through SOAPLite module and WSDL.
• Strong experience in writing efficient Sybase (12.5) SQL queries and objects like Stored procedures, Triggers, views etc
• Actively performed Database performance tuning (Show plan, Indexing, query optimization)
• Extensive experience with data loading (BCP) tool
• Good knowledge in Unix shell scripting
• Good working knowledge in DB2. Hands on experience in writing complex queries, debugging stored procedures in DB2
• Strong in AUTOSYS batch scheduling to automate process workflow
• Highly motivated, energetic, quick and independent learner
• Great team player, who can supremely motivate others
• Exceptional ability to quickly master new concepts
• Sound Analytical skills

Technical skills:
Database: Sybase ASE 12.5.0, Oracle 10g, DB2
Languages: PERL 5.8, Unix Shell script
Platforms: Windows XP, UNIX
Source Control Tools: CVS, IBM Rational ClearCase, SVN, Perforce
Miscellaneous Tools: AUTOSYS, SOAPUI, JobVision, Actuate, Aqua Data Studio, Exceed

Education:
Bachelor of Technology (Information Technology), June 2003
Confidential, University, India

Certification:
Infosys internal certification on Securities Market Overview, CM101

Professional experience:

Confidential,Jersey City, NJ Sep 2011 – Till date
Senior Perl developer

Project: PostEdge

The PostEdge team ingests its client’s statements and confirms into OnDemand system, posts/sends the statements to the clients both as hard copy and e-files and sends the corresponding billing information to the finance team so that they can charge the clients accordingly. OnDemand is a tool which has a front-end GUI for its users through which they can check the ingestion records, back-end is maintained on DB2 database and the files are kept in Unix folder structure.

Responsibilities:

• Define and develop technical specifications for the automation of the Billing file which is to be sent to the finance team to bill the clients
• Develop the Perl and Shell scripts to automate the finance billing file
• Take part in RBC CANADA project to make the necessary script changes (Perl) to ingest RBC CANADA AFP files into PostEdge
• Develop the post-processor script in PERL for American Funds ingestion process to move the pdf files to the NAS mounted directory structur based on the config file format
• Develop the pre-processor and post-processor scripts in PERL for the Mercer Funds files to create the index files for the incoming zip files and to update corresponding DB2 tables during the post ingestion process
• Participate in the Oracle ShareLink project to recommend necessary changes in OnDemand system and testing the loading of PDF files through the new archive, 000INVS
• Take part in streamlining the code migration process by syncing up the application scripts between different environments like Production, QA, Dev and UAT. Sync up the Autosys boxes between QA and PROD
• Support the users as per their ad-hoc requirements

Confidential,Jersey City, NJ Oct 2010 – Aug 2011
Senior Perl developer

Project: Broadridge Conversion for Equity products

This project helps the client, Societe Generale to convert from the existing back-office system, BETA (Reuters) to BPSA (Broadridge) for equity products.

Responsibilities:

• Define and develop the overall conversion strategy between BETA and Broadridge – BPSA
• Define and develop technical specifications for BETA de-conversion and Broadridge on-boarding of stock record, positions, pending trades, balances, fails etc.
• Develop the reconciliation tools and reports for the users
• Develop the batch jobs for loading the BETA side trades into Broadridge using Perl script, Unix shell script and Autosys
• Develop stored procedure and other load scripts in PL/SQL
• Work with users to review the results and assist users in obtaining user acceptance

Confidential,New York City, NY May 2009 – Sep 2010
Senior Perl developer/Module lead

Project: Fundamental Systems – Banking FM

This project is about developing tools that will improve the quality of credit research and the rating committee process through increased data gathering efficiency, depth analysis and monitoring capabilities. It includes processing of financial statements, validating the statements and generating different kind of ratios for the analysts.

Responsibilities:

• Developing Perl modules to load the financial statements of different banks, implementing business validation on statement level, deriving discrete and LTM (last twelve months) statements based on available statements of an issuer and calculating ratios for analysts based on predefined formulas
• Implemented Perl packages extensively. Used multithreading. Used SOAPLite module to communicate with different web-services based on given WSDL
• Using SOAPUI tool to test web-service calls
• Writing queries and debugging Stored Procedures in DB2 to analyze different production issues
• Enhancement of existing functionalities to meet user’s changing need
• Independent unit testing
• UAT support

Confidential
Goldman Sachs. Jersey City, NJ Aug 2007 – Apr 2009
Senior Developer

Project: GASS (Global Asset Servicing)

Asset servicing is the processing of Corporate Actions. Corporate actions are any events, which have an impact on the shareholder or bondholder in terms of exchanging, amending and paying income based on their positions. Goldman Sachs and clients of the firm are entitled, through ownership of financial instruments to participate in any of a range of corporate events that may be applicable to that particular security. Processing of corporate actions encompasses obtaining accurate information on the event, notification and response to holders, entitlement calculation and then distribution of payment. Event life cycle consists of four distinct steps, i.e. announcement, entitlement, notification and distribution. The Global Asset Services team is responsible for managing these corporate events on behalf of the firm and their clients.

Responsibilities:

• Developed Perl scripts to load data feeds into GASS and to generate feeds for the downstream systems
• Developed Perl scripts to automate frequent reports for the users
• Developed wrapper scripts in Unix shell script for the AUTOSYS batch jobs
• Developed and modified many stored procedures in Sybase to apply the business logic and to generate complex reports
• Used BCP extensively for export and import table data, loading CSV files into tables
• Participated in optimization of stored procedures and SQL queries to reduce the run time of the batch jobs
• Involved in Production Batch support. There were around 2000 Autosys batch jobs, which were supported from the different regions (New York and India)
• Monitored production database server to resolve performance issues of the applications, related to long-running processes or database-locks and worked with DBA in resolving the issue
• Closely worked with the business users to solve different production issues doing root-cause analysis and break-fixes
• Involved in Regression testing before the monthly migrations. It involves simulation of the production batch in the test environment and running it for both the benchmark and the test versions. Then the results were compared between two runs
• Responsible for maintaining the graphical structure of the Autosys batch using the tool JobVision
• As a senior member, was involved in mentoring and guiding the offshore team in solving different issue

Confidential,New York City, NY June 2006 – July 2007
Senior Developer

Project: PWM Portfolio API

PWM (Private Wealth Management) offers investment services to high net worth individuals. PAPI (Portfolio API) works as the middle layer for all the applications. It maintains the data and implements the business logic mainly within Sybase stored procedures. There are different applications in PWM as Desktop, CIO, ClientWeb, ClientProfile etc. which call the PAPI methods to return result to their clients.

Responsibilities:

• Analyzed user requirements and designed the database changes accordingly
• Developed and maintained database objects like tables, views and stored procedures in Sybase for all the end applications which connects to PAPI for accessing data and reports
• Worked extensively on the Sybase stored procedures to work on the raw data and generate complex reports
• As part of client-facing applications, involved in performance tuning of stored procedures. Analyzed and tuned query plans, indexes, I/O and CPU to get the optimum performance

Confidential,London, UK Jan 2005 – Apr 2006
Developer

Project: BN272 Transaction Reporting

It reports all the GSI trades (executed by GS and its clients) to FSA (Financial Services Authority) and LSE (London Stock Exchange) daily on T+1 basis. BN272 (group created based on Board Notice 272 from FSA) receives trades mainly from Lew (Legal Entity Workstation) which gets those trades from PARA. Apart from this it receives Agency trades from GMI and DOTE, Buy-Sell trades from REPO factories in London and Tokyo, Component trades from Graph. BN272 loads those trades into its database, sets the reporting criteria of the trades and generate the report files. Then it sends the report files to FSA through DRS system and to LSE through ISMA Gateway. It also generates the COOL reports for its users.

Responsibilities:

• Developed Perl and Shell scripts for upload of data feed into database
• Developed reports in Perl for our end users
• Developed and implemented the new flow of Component trades which includes loading the feed file in Perl/Unix shell, applying the business rules through stored procedures and generating the report in Perl for the end users
• Handled the data load between flat files and tables by using BCP
• Designed and implemented AUTOSYS job scheduling to automate report generation
• Developed stored procedures to apply the business logic on trade data
• Developed complex database queries with T-SQL to analyze different data issue and generating reports for business users

Confidential,India Nov 2004 – Dec 2004
Developer

It involved building the prototype of the web application where any client of Fidelity Actions Exchange (FAX) can see the details of different corporate actions and can update the same. FAX group wanted to package functionalities of the existing ActionService application (developed in PowerBuilder) as a web solution for their clients.

Responsibilities:
- Developed the prototype of the web application using HTML and JavaScript

Confidential,India Dec 2003 – Oct 2004
Developer

Decision Economics Investment Research (DEI)’ is a branch of Fidelity Investments. DEI publishes report of analysis on Equities, Fixed Income and Money Market products. The research is published and made available to the customers through the website of the firm. This project involves in developing the backend and the frontend of the official website of DEI. Frontend was developed in ASP 3.0 and the backend was maintained in Siteserver 3.0, Sybase, IIS 5.0

Responsibilities:

• Designed and developed the front-end pages in ASP 3.0
• Developed the database queries in Sybase
• Maintained the backend server in SiteServer 3.0, IIS 5.0