Profile:

• More than 9 years of experience in Software development involving Requirement Analysis, Designing, Development, Testing, Release Management and Production Support in various applications using Informatica Power Center, Sybase, Oracle, MS SQL Server, UNIX, Perl, Shell Scripts, and C/C++
• Diverse experience in Banking & Financial services (Investment Banking and Wealth Management), Manufacturing sector and applications for Government Sector. Good exposure to applications of clearing & settlement and client reporting functions.
• Good experience in ETL tools like Informatica PowerCenter and exposure to datawarehouse applications. Worked in end-to-end ETL application development including functional requirements gathering, designing ETL architecture for the application.
• Strong skills in DataModelling techniques like Star and Snowflake schemas.
• High working experience with Informatica PowerCenter transformations like Joiner, Router, Update Strategy, connected and unconnected lookups, Expression, Sorter, Filter, Union, Normalizer, etc. Also worked with varied sources and targets like relational tables, flat files, XML Editor, VSAM files, XLS, etc. Aware of the basic administrative tasks with Integration Service, Repository Manager, etc
• Very good experience of working in different relational databases like Sybase, Oracle, MS SQL Server and DB2. Expertise with T-SQL, PL/SQL. Worked with stored procedures, triggers, indexes and performance tuning. Also worked with data loading utilities like bcp and SQL Loader.
• Strong experience in Perl Scripts development. Worked with array, hash, subroutines, packages, DB libraries for database connectivity and parsing files.
• Excellent skills in working with UNIX shell scripts. Developed shell scripts for feed file integrity checks, polling, FTP activities using commands like find, grep, pipe, cut, redirection and utilities like awk and sed.
• High skills in working on UNIX environment. Worked in porting applications across different versions like Solaris, HP-UX, AIX and Linux. Shell scripts.
• Extensive experience with Autosys job scheduler like writing jil scripts for creating job definitions. Also used commands like autorep for checking status, definitions, sendevent for starting jobs, changing status.
• Good knowledge of working with Business Objects, developing reports using Crystal Reports X1 and scheduling those reports using InfoView.
• Exposure to working in onsite client’s place for about 5 years; good experience in Onsite-Offshore delivery model and its co-coordinating activities
• Recognized for my professional excellence by my employer with Outstanding Contribution Award and Best Outsourced Project Award, by the client.
• Vast experience with Level 2 production support, involving resolution of issues escalated to development team.

Technical Expertise:

ETL Tools:

Informatica PowerCenter 9.1.0 / 8.6.1 / 8.5.1/ 7.1.1

Relational Database:

Sybase 12.5.4 / 12.5.2, Oracle 10.2.0.5 / 9.2.0.8 / 8i, MS SQL Server 2008, UDB, T-SQL, PL/SQL

Scripting:

Perl Scripts with DBLib, C-Shell and Korn shells Scripting, Autosys JIL scripts, Make files

Languages / Reports:

Crystal Reports XI R2, C/C++, PowerBuilder

Operating Systems:

Environment:

SUN, IBM-PC, HP, IBM and IA64 (Itanium) Workstations

Other Tools / Software:

AutoSys, Sub Version (SVN), ClearCase, Perforce, MS Visio, DB Artisan, Toad, MS Visual SourceSafe, FIXML, Rational Purify, dbx, gdb, TCP-IP, SNMP, UML

Web Technologies:

HTML, PHP

Education:

• Bachelor of Engineering (B.E.) in Information Technology

Professional Experience:

Confidential,New Jersey, US August 2009 to Present

Role: IT Lead and Application Developer

Brief Profile:
The firm uses a vendor product BPS, supplied by Broadridge, to carryout transaction processing and settlement for both equities and fixed income securities. Broadridge provides BPS Advantage (BPSA) to feed real time data to its clients. BPSA normalizes the data available in mainframe and loads it Relational databases in distributed network, which is carried out in both real-time and EOD batch.
We have designed a lot of customized processes around BPSA. This serves as the firm’s gateway for US Equities settlement. Currently we are integrating the US fixed income flows to this.

I was involved in developing extracts for different downstream systems using Informatica PowerCenter 8.6.1. This requires data enrichment from different sources and also data formatting as per downstream requirements. Different sources include relational tables of Oracle, Sybase, SQL Server and different file formats like fixed or delimited files, Large Option Position Report (LOPR) files in FIXML format, Mainframe VSAM files, etc. Managed setting up the Informatica environment for our application. Also I did designing and development of schemas for data warehouse and also the related mappings that load data to the warehouse. The data warehouse is being implemented in Oracle.

Also involved in enhancing the existing legacy flows developed using Perl and Shell scripts for parsing and loading upstream feeds to database. The database development involves DDL statements for the schemas designed and DML statements, stored procedures for implementing the functional logic. This requires performance tuning for queries and stored procedures. Leading a team of five developers to execute this project and work closely with different vendor and support teams.
Currently we are involved in an initiative for migrating Informatica PowerCenter from 8.6 to 9.1

Responsibilities:

• Lead the development team and co-ordinate the projects among the developers.
• Analyzing the requirements and making functional specification by discussing with business user groups, generally back-office operations.
• Developing Informatica mappings and workflows for extracts and feeds. Data is extracted through mappings from different sources like Relational database tables, FIXML messages, VSAM files, etc.
• Designing and developing the data warehouse schemas based on the new functional requirements.
• Additional development activities include writing stored procedures, making Perl and UNIX shell scripts, and then scheduling the same using Autosys JILs.
• Maintenance tasks like performance and process improvement by remediating the production code. Also includes fixing the functionality bugs.
• Developing user reports using Crystal Reports and deploying the same to Business Objects XI web interface, InfoView
• Level-2 production support work in assisting the application support team to resolve the day-to-day production issues.
• Capacity planning to cater for business volume growth and maintaining the SLAs within limits.

Technical Environment: Sun Solaris 8, Linux 2.6.9, Informatica PowerCenter 9.1/ 8.6, Oracle 10.2.0.5, PL/SQL, Sybase 12.5.4, T-SQL, Shell Scripts, Perl Scripts, MS SQL Server 2008, Crystal Reports XI, ClearCase, Perforce, AutoSys

Confidential,Singapore May 2008 to July 2009

Role: System Analyst, Application Developer and IT Lead

Brief Profile:
This is a Client/Server application to facilitate the generation of client statements and transaction advices in Asia Pacific locations of the bank. The system supports the following

• Printing of physical copies and PDF generation of trade confirmation advices and other transaction advices
• Supports advices of different security products, FOREX trades, Money market trades, etc. on both domestic and foreign markets
• Generates output in different languages like English, Japanese, and Chinese depending on the client
• Allows for reprinting, selective printing for authorized end users
• Additional features like printing of bar code and OMR for automated reconciliation and enveloping.

The ETL workflows extract data necessary for generating advices from a data warehouse. The data warehouse schemas captures trade settlement data (for all securities including equities, fixed income), client static info, etc. These data are extracted through mappings/workflows for generating client reports. The work involved developing new Informatica mappings and workflows to support enhancements / change requests like generating advices for new products and security types.

Managed a team that upgraded the ETL environment from PowerCenter 7.1.1 to PowerCenter 8.5.1. This involves upgrading across development, QA and Production environments and performing functional and regression tests. Additionally need to handle mapping/workflow deployments across different environments. Also had to work with Infrastructure teams to install Informatica Server, setting up the Integration service and maintain the Integration services for Dev region. For Instance, restarting the service when Informatica database (metadata) needs be bounced.
New interface was developed using Perl and SHELL scripts to feed soft copies of advices together with the necessary indexing information to the archival system. Also did development in PowrBuilder to change the contents and format of advices, improve the GUI for IT operations, etc.

Responsibilities:

• Requirements analysis and preparation of functional, interface specifications
• Lead and coordinate the development tasks among other developers
• Designing the interface with data warehouse and the developing the extraction / enrichment logic using PowerCenter Mappings.
• Deploying the mappings/workings across QA and PROD enviroments
• Accessing, monitoring and restarting the Integration service for the development environment through the web interface.
• Design of the advice format and layouts using PowerBuilder
• Develop stored procedures. Also analyze and fine tune to improve their performance. This also includes DDLs for tables, view, triggers, indexes, etc.
• Development of day end processes using Perl and/or UNIX Shell Scripts. This also includes file processing through sed, awk within the UNIX scripts.
• Writing JIL scripts to schedule the processes in AutoSys.
• Perform functional testing and integration tests with other systems
• Support user testing and deploying the changes
• Assisting application Production Support team in resolving production issues when escalated to Level-2

Technical Environment: Sun Solaris 8, Informatica PowerCenter 8.5.1/7.1.1, Oracle 9.2.0.8, PL/SQL, PowerBuilder, Shell Scripts, Perl Scripts, Subversion, AutoSys

Confidential,Singapore July 2007 to April 2008

Role: System Analyst, Application Developer and Quality Assurance Lead

Brief Profile:
In the firm, the physical hard copies of any document is processed by different Operations teams (situated in different locations) and finally archived electronically. This application intends to scan the documents upfront and further processing is done the system. A workflow is designed that

• Receives the scanned images of documents
• Segregates the documents and channels to queue of different teams
• Allows Authorized user teams pick up the images and process
• Once processing is complete document is routed to archive.

This reduces the processing time and avoids loss of documents in transit. The project involved developing a new application end-to-end.

Responsibilities:

• Requirements gathering from users and analyze the feasibility
• Application architecture design including preparation of interface specifications with other applications.
• Development of interface components using Informatica mappings & workflows. The mappings were designed to extract data from the warehouse and diverse relational DB sources.
• Oracle stored procedures were developed to handle the functional calls for the front end GUI. Also used Database links for direct connectivity between database instances.
• UNIX Shell Scripts and Perl Scripts are developed to invoke the Informatica workflows and feed file integrity checks.
• Scheduling the processes in AutoSys. Used JIL scripts to develop the jobs and commands like autorep, sendevent to check jobs status, definitions, force starting the jobs, putting on/off ICE, on/off HOLD, etc
• Perform functional testing
• Coordinate user testing and rollout the application to production

Technical Environment: Sun Solaris 8, Oracle 9.2.0.8, PL/SQL, Informatica PowerCenter 8, Shell Scripts, Perl Scripts, Clearcase, AutoSys

Confidential,Singapore October 2006 to June 2007

Role: System Analyst and Test Coordinator

Brief Profile:
This application intends to capture documents electronically. It serves as a archiving system for legal documents, correspondence documents and the statements/reports/advices sent to clients. It facilitates access of required documents by authorized end users from markets, legal and compliance, operations, etc to search, view and print the documents.
The documents get into the archive by two means

• Input of softcopy feeds directly from various output generation systems
• Scanning of hardcopies by the operations team. In this case the document is classified and segregated based on barcode information.

The scope of work is to rollout the system in different locations of Asia Pacific. Also customize the application for individual location requirements.

Responsibilities:

• Requirements analysis and rollout strategy plan
• Location customization involving development of UNIX shell / Perl scripts, database stored procedures
• Perform functional testing
• Coordinate user testing and rollout the application including both server and client packages to production

Technical Environment: Windows XP, Sun Solaris 8, Oracle 9.2.0.6, Informatica PowerCenter 7, Shell Scripts, Perl Scripts, ClearCase, AutoSys

Confidential,Tokyo, Japan April 2006 to September 2006

Role: Application Developer and Quality Assurance Lead
Technical Environment:

Windows 2000/2003, Sun Solaris 9/10, HP-UX 11i/11i V2, IBM-AIX 5.2/5.3, C/C++, Shell Scripts

Brief Profile:
This is a group of products developed for managing, executing processes on both UNIX and NT. It provides highly reliable facilities for centralizing and simplifying hierarchical management of large-scale, complicated information systems.
The product is composed for three components namely,

• Central Console
• Central Scope
• Central Information Manager

Central Scope is a new component of product family, which will enhance the product with a new Business oriented management functionality. The scope of the project is to make the following enhancements to the existing system,

• Implementation of Healthcheck functionality
• Supporting UTF-8 Locale for automatic generation of monitoring tree
• Development of command to automatically update the monitoring tree after automatic generation

Responsibilities:

• Requirements analysis and estimation for the new functionalities
• Preparation of functional and detailed design specifications
• Coding along with modification of Data Collection Tool (Shell Script)

Confidential,Tokyo, Japan July 2005 to March 2006

Role: Technical Leader, Application Developer and Defect Prevention Group Member

Brief Profile:
This is a base product providing facilities for Job Management and Integrated Enterprise Systems Management products of the family. It is prerequisite for running other related products.
Remote Command execution is the function of this product that facilitates Integrated Management. A command can be executed on the other computer by using Integrated Management Product i.e. executing the command on the remote host, and return the result to the host that requested the execution. Command information is transferred from issuing host to executing host by descending the host tree. When the execution result is returned, it ascends the tree.
The following are the new enhancements made to the existing system,

• Expanding the size of execution command
• Improvement of Communication routing
• Improvement of Command Execution Information
• Support to UTF-8 Locale on RedHat Linux AS 4
• Internationalization support

Responsibilities:

• Analysis of the requirements and preparation of design memos, Functional Specifications
• Detailed Level Design
• Coding of Command Execution and API modules. This involves command development for conversion of database, Variable length protocol approach for Socket and Pipe communication.
• Porting and makefile preparation for all UNIX and IPF platforms
• Migration to next release of operating systems in Solaris, AIX and Linux
• Build and Release Management
• Bug fixing and product integration support

Technical Environment:
Windows 2000/2003, Sun Solaris 9/10, HP-UX 11i/11i V2, IBM-AIX 5.2/5.3, RedHat Linux AS 3/AS 4, C, C++, Shell Scripts

Confidential,Tokyo, Japan August 2004 to June 2005
Role: Analyst and Application Developer

Brief Profile:
The purpose of this project is to re-engineer the Remote Command function of this base product. The idea is to overcome the problems in earlier version of the system and to provide the better performance of the system with better reliability. The following are the enhancements made to the system,

• Improving the Troubleshooting functionality
• Increased performance compared to existing system
• Resource Management Functionality
• Managing 1024 agents
• Introducing priority for command

Responsibilities:

• Involved in feasibility study of various architectural approaches
• Detailed Level Design for API and Common Modules. Involves analysis of Multi-threaded architecture and different IPCs (Sockets, Pipe and Shared Memory) in Windows and UNIX.
• Coding of Common, API and Command execution modules. This involves Process creation in Windows and UNIX, mutual exclusion among threads, usage of various STLs (vector, hash table, map)
• Makefile preparation for Windows and Solaris, Message DLL creation and message text file parsing using Perl
• System Integration and Porting for UNIX, IPF platforms
• Test case preparation and testing of the system
• Usage of dbx and gdb for debugging and bug fixing
• Implementation of alternative approaches in Command execution module for better performance of the system.
• Involved in performance improvement of the system

Technical Environment: Windows XP/NT/2000/2003, Sun Solaris 8/9, HP-UX 11/11i, IBM-AIX 5.1/5.2, RedHat Linux 7.2/7.3/AS 2, C, C++, Shell Scripts, Perl Scripts

Client: Confidential,Tokyo, Japan February 2004 to July 2004
Role: Application Developer

Brief Profile:
This is the base product providing facilities for Job Management and Integrated Enterprise Systems Management products of the family. It is prerequisite for running other related products. The product provides three basic functionalities,

• User management
• Event Service
• Command Execution

The scope of the project is to port the product running on the Intel IA-32 architecture to the Intel IA-64 architecture on both Windows and Linux platforms

Responsibilities:

• Porting including data collection tool modification for IPF platforms (Shell script)
• Testing the system

Technical Environment: Windows 2000/2003, RedHat Linux 3, C, C++

Confidential,Bangalore, India August 2003 to January 2004
Role: Application Developer

Brief Profile:
This organization is involved in implementing projects for bridging the Digital Divide. It depends on Non-government Organizations across the country/world for their execution.
ACCESS NGO is an attempt to provide a single point to access to NGOs in different target domains and geographical locations. The system helps to identify a NGO and find information including, the target domain, geographical expanse, source of funds, nature of activities, etc. The functional requirements include,

• Information management
• User management
• Suggestion management

Responsibilities:

• Design and development of User interface screen using PHP
• Design of tables for the database

Technical Environment: Windows NT/XP, PHP, HTML, Oracle 8i, MS Visio