Summary

• 10 years of professional experience in the field of IT including Requirements Analysis, Design, Development, and Maintenance of multi-tier Systems using Object Oriented Analysias/Design Methodologies.
• 10 years of extensive experience in PERL, CGI, DBI/DBD, C , HTML and SYBASE based applications. Around 5 yrs of IT experience in developing and maintenance of database using PowerBuilder.
• 5 years of experience in design, development and testing on client-server based pure open systems using UNIX Shell scripting, Pro C, ESQL, PL/SQL, RDBMS under UNIX RS/6000 SP-AIX, HP UX, Solaris, SCO , Linux and Windows environment and Good knowledge on HTML and XML.
• 5 experience and skilled in website design, HTML, XML parsing with Perl/CGI programming
• 4 years of extensive expertise in creating MS SQL Server databases, objects, stored procedures, triggers, DTS, BCP, Transact-SQL, SQL Mail, and SQL Server Agent using SQL Server.
• Excellent experience in Unix internals and Linux programming Socket, Multithreading, Interprocess Communication, Signal handling
• 5 years monitoring Autosys jobs for failures, re-running them, killing them, putting them on ice, looking for long running job, generating customized reports through Autosys
• 2 years experience in C, C , Java, J2EE, Rogue Wave. Experience in Java J2EE JSP, Servlets, JDBC, JMS experience with Java Server side programming, development of Java Web based applications and back-end batch applications..
• Design/Develop/Integrate/Test software application modules primarily using Java/J2EE.
• Experience in Integration of various data sources like SQL Server, Oracle, MS-Access, People soft and Flat Files into a staging area.
• Good experience in maintaining CMVC Configuration Management Version Control RCS Revision Control System , Subversion and CVS
• Experience in financial industry domain such as Fixed Income, Bond, options, equities, and trading applications.
• In depth business knowledge of Banking with over 3 years of FIX protocol environment and CRM applications
• Have done CPA, which helps me in understanding the business very fast that assists me in writing code and procedures for enforcing business logic and building application properly.
• Have worked as a team lead and have coordinated on and off shore team

Technical Skills:

Languages

PERL, KSH SCRIPTS, CGI, TSQL, Ansi-SQL, Javascript, HTML, PL/SQL, XML,

Web Server

Apache Web Server, Netscape/iPlanet Web Server, IIS

Databases

Sybase 11.x/12.x, 15, IQ, MS-SQL Server 2000, Oracle PL/SQL, MS-Access 2000, DB2, Informix

Design Methodology

Rational Rose, UML

MISCELLANEOUS

CRON TAB, VISIO, Visual Source Safe, ERWIN, DBI/DBD, FTP, BCP, ISQL, SQLPLUS, FIX, SWIFT, PVCS Tracker, Autosys, SAS, FIX protocol

Source Control

VSS, RCS, CVS, SVN

Methodologies

OOAD, UML

Operating System

UNIX, Linux 8, HPUX, Sun Solaris, Windows 95/98/2000, Windows NT

WORK EXPERIENCE

Confidential

Oracle and Informatica developer

Consecutive Leave policy was to drive the creation of policy groups. Policy groups will be assigned to an owner and administration team. Each policy group will assign various employees to be designated. Employees will enter consecutive leave absence requests within GAT.The CL project sets up a series of Control-M jobs that will control file watchers set up to look for the files being delivered to the landing pads mentioned above. The file watchers will be set up to start looking for a given file at the date/time that that been agreed to by the upstream interface partner that the file should exist on the landing pad by. The file watchers will run for no more than 30 minutes. In the event that a file watcher finds no file that meets the criteria it has been looking for, the job will fail. An autoticket will be opened into A1LCTBI queue which will trigger LCS Operate to contact the interface partner.

• Wrote several complex perl scripts from scratch for ftping CSV files from the remote location, processing those input files to staging tables in Oracle, adding sequential keys to audit table, then propagating data to fact table and finally archiving the processed file. Used module such as File::Copy, File::stat, Text xSV, Process Statistics, DBI to name a few
• Bug fixing in existing Perl and Shell scripts
• Enhancement of existing application and unit testing of the given local modules in Perl
• Wrote shell scripts for automating several testing jobs
• Use Control-M to schedule, run and monitor jobs.
• Wrote Korn Shell to provide management with the ability to monitor, track, record, and audit every command executed by any user of a system. It provided detailed information that includes date, time, tty, user, and the command. The information was transmitted in real time to a remote logging system.
• Performed regression test, smoke test, and performance test.
• Worked with Informatica developers to gather requirement to load data from staging to fact tables. Helped them in loading test data in staging tabale for its testing.
• Prepared document for data flow process from different source systems to target system
• Worked with development team to write Informatica mapping
• based on the business and technical requirements incorporating the best practices.
• Designed and developed audit control process for Informatica jobs to keep
• track of all the job execution along with balance and reconciliation reports.
• Created lot of test data files for testing Perl scripts written
• Provided maintenance and helped in resolving production issue

Environment: Perl, Unix, Oracle, Informatica, Kornshell scripting, Control-M, SVN

confidential

Web Development

In a world of advanced and complex cyber threats, Lumeta empowers information security professionals with the industry's most comprehensive network visibility and continuous monitoring solutions. The accurate and timely information Lumeta provides on topology, perimeter defense, and access control allows our clients to proactively secure their critical assets.

Responsibilities:

• Worked and got conversant with object oriented practices native perl or Moose and procedural scripting
• Worked with Catalyst, Template Toolkit and Mason Creation, manipulation and accessing information from complex data structures
• Wrote Perl Scripts for generating alerts in a particular format and then sending it via email, both real time and the timely consolidated one
• Fixed lot of Perl bug and errors
• Sole developer of internal API s for globalization and localtization of products.
• This application allowed warehouses to see, in real-time, inventory levels, orders, backorders, print shipping labels, etc. Created 'data movers' which moved data to and from the main Informix database, and the Sybase databases, and coded much of the Perl, which drove the web application.
• Various scripts were created to monitor the web server, extract information to create EDI files, create user reports, do real-time database replication Msql , dynamically update the web servers, and other system tasks.
• Created a web based sales forecasting application, using HTML, Perl, and Access.
• User Perl CGI in conjunction with HTML templates along with CSS and Javascript to create web based reports for scanning networks and its states, based on various parameters

Environment: FreeBSD, Informix, Sybase 15.0,3, Perl, XML, HTML, JavaScript, Apache, mod perl, embedded Perl ePerl , shell scripting, Apache source code, ODBC, NT, MS SQL, and others

Sybase/Oracle, Perl/Shell Scripting, Sybase IQ, Production Support

gives the best perspective for making more confident investment decisions. Confidential flexible platform provides an objective view of over 20,000 companies worldwide. Its rigorous methodology examines accounting information, converts it to cash and then values that cash, allowing you to survey the entire corporate capital structure and identify key drivers of value that others miss. HOLT is based on a simple premise: that what's important isn't seeing everything, but seeing the right thing, the right way.

Responsibilities:

• Working on the Holt project, where propogating data from Oracle Datawarehouse to Lens Sybase ASE and then to Sybase IQ through shell script, isqlx and sqlplusx, and informatica was an important task. Lot of manipulation of data and committing of data was handled through shell script with connectivity to database through isql and sqlplus
• Wrote several complex shell script to enforce business logic, and also to have current data propogated to historic table in Sybase IQ from the Oracle data warehouse and then scheduling it through cron and job control console
• Duties include creating dynamic web sites with Perl and Cold Fusion. Applications range from simple sites created from a database MySQL and Postgresql to online shopping cart systems. Other duties include creating maintenance programs, in Perl, to support customer needs such as parsing server logs, mail filtering, software installation, and database updates. Technologies being used are Perl, Cold Fusion, MySQL, Postgresql, SQL, Apache, mod perl, Linux, and FreeB
• Wrote cursors in Sybase IQ to enforce the logic of missing data from research table in company historic and company sub industry tables.
• Created and worked in Sybase ASA database too for local use when offline for demonstration to the client.
• Worked in ERWIN to create the Entity Relationship Diagram.
• Wrote complex procedures in Sybase ASE for committing the transactions and calculating the premium as well as the HOLT market value which was based on many factors and scenarios
• Worked on SVN project of creating repositories. Wrote several Perl script to extract all the DDL of tables, view, procs, triggers and other databse objects of Oracle datawarehouse, Sybase ASE and IQ, added the header and footer to all the DDL scripts and then importing them SVN repository
• Wrote Perl Script for loading current gic data as well as lookup data in staging table, subroutines to get company list, period list and variable list, and then manipulating the company key, according to its size and then adding period id to it.
• Installed lot of modules from CPAN, uploaded some of the modules in CPAN and to the library. Use object oriented Perl for Automation of jobs, using moose and catalyst modules.

Environment: Sybase 15.0.3, Kornshell Scripts, Perl, Sybase IQ, UNIX, Linux, Windows, Autosys, SVN, HTML, JavaScript, XML, Informatica, Cron, ISQL, SQLPLUS,

Web Development and Management

Confidential support feeds team aids GSI's business departments and their functions. GSI's business departments bring additional business to GSI while finding ways to minimize financial loss, identify opportunities to improve operational execution, and control the end-to-end Customer order process while interfacing with various groups within the company to ensure seamless business operation. Duties also included creating dynamic web sites with Perl and Cold Fusion. Applications range from simple sites created from a database MySQL and Postgresql to online shopping cart systems. Other duties include creating maintenance programs, in Perl, to support customer needs such as parsing server logs, mail filtering, software installation, and database updates. Technologies being used are Perl, Cold Fusion, MySQL, Postgresql, SQL, Apache, mod perl, Linux, and FreeBSD.

Responsibilities

• Worked in AutoRecon project where we were replacing Sterling Integrator and so all downloading, credit card masking, uploading, updating and archiving was to be handled by Perl
• Wrote several Perl script and functions to sftp, rename, copy, manipulate, mask, create acks and upload files to database.
• Wrote Shell Script for Automation of complex unix commands and the testing commands for file size, its permissions, its stats such as date, time, tty, user, and the command
• Provided on call support 7 days a week for any feeds failure and P1 request. Joined the bridge call to give suggestions and advice on how to fix the issue. Talk to the business team of several clients to fix the issue promptly.
• Wrote a multi-layered web based security system to replace Basic Authentication and allow per-page access as well as per-page options which included an administrative system and supporting scripts for developers. This became the de-facto web-based security at USCO.
• Integrate with various back-end systems using Scala, ReST / JSON APIs and SOAP.
• Provide API documentation and continual customer support for web services.
• Secure web site and web services via Acegi and database authorization.
• . Wrote scripts which moved data to and from the main Informix database, and the Msql and later MySQL databases, and coded much of the Perl, which drove the web application.
• Work together with graphic designers and user interface to apply intuitive and appealing front-ends to Perl, web-based functionality.
• Various scripts were created to monitor the web server, extract information to create EDI files, create user reports, do real-time database replication Msql , dynamically update the web servers, and other system tasks.
• Created lot of new modules and then standardizing those modules in the library in DataX which could be reused
• Use Perl on windows platform to read MS Word doc and Excel sheet by usage of appropriate modules and then comparing it with information read from some other drive and file, and then manipulate and process the data accordingly.
• Used Autosys for monitoring failed and long running jobs, the occurrence of jobs, its dependency, the job command and its parameters.
• Interactively worked with development team and project managers to develop new features and functionality, on both sides of backend scripts and web based scripts.
• Worked on building CSS JavaScript modules
• Assisted in SQL database design and performance tuning.

Environment: Sybase 15x, Kornshell Scripts, Perl CGI, SOAP, HTML, JavaScript, XML, SQL, UNIX, Linux, Windows, Autosys, Datastage, Sterling Integrator, I5 AS400, CVS,

Confidential

Vendor Management

Confidential other health care providers with each other and to critical health information at the point of care to enable significant improvements in patient safety, health outcomes and opportunities for practice efficiencies.The network utilizes the Axolotl HIE platform from OptumInsight to create a secure clinical network that connects participating physicians, hospitals, laboratory services providers and pharmacies in the region. This enables medical professionals to access and share critical health information, including electronic medical records, to support faster, more effective clinical decision-making and coordination with other care providers.Further, through the Axolotl HIE platform, participating physicians and hospitals will easily be able to connect to the state Health Information Partnership for Tennessee Network to coordinate patient care and access clinical data from Immunization Services, Public Health Reporting, Lab Reporting Services and other qualified organizations across the state.This initiative helps reduce duplicate testing, provide safer transitions of care and reduce administrative costs.

Responsibilities

• Created several Perl modules and wrote many sub routine for loading the business rules in a hash and hashes and then building transaction queries based on the time period and associating it with a particular rule to create invoices for fees and adjustment and book it to a particular account.
• Wrote Perl script to compare both manual and auto settle invoices from DB2 and the invoices in Oracle Financials, and then creating a payment in Oracle through Oracle packages, which was part of migrating data from DB2 and Informix to Oracle Financials.
• Wrote Kornshell scripts to create temporary tables, execute stored procedures to populate those tables and then dump the data to the flat file and finally drop the tables.
• Wrote Kornshell scripts to remove old files in log and temp directories, for sql check and to check the number of rows returned.
• Maintained the FreeBSD servers as well as maintained and configure the Apache web servers.
• Created a web based sales forecasting application, using HTML, Perl, and Acces
• Creating/maintaining Internet, Extranet, and Intranet web pages and sites according to customer specifics and my embellishments. Web design skills that I utilized were client interaction, HTML, Perl, JavaScript.
• Personally designed and built new SOAP web service interface implemented in Java using Apache SOAP Axis. Validated it with Perl and Scitegic Pipeline Pilot clients, prototyped in Perl SOAP::Lite.
• Created an Access database driven search engine which function is to index and search all multimedia files entered into the database, done with web-based Perl driven forms.
• Work together with graphic designers and user interface to apply intuitive and appealing front-ends to Perl, web-based functionality.
• Refract, revise and maintain existing code with some focus on improving, security, performance, modularity, and maintainability.
• Created lot of new modules and then standardizing those modules in the library, which could be reused
• Use Perl on windows platform to read MS Word doc and Excel sheet by usage of appropriate modules and then comparing it with information read from some other drive and file, and then manipulate and process the data accordingly.
• Used Opswise scheduler to schedule all batch jobs and to run the Perl scripts for automation.
• Interactively worked with development team and project managers to develop new features and functionality, on both sides of backend scripts and web based scripts.
• Assisted in SQL database design and performance tuning.
• Wrote several stored procure for processing of patients data, fee, claims, and categorizing and tier-ing them based on their background information, claims worth and the type of problem and cure
• Develop internal/client web projects interactive marketing campaign through Javascript and CSS

Environment: Kornshell Scripts, Perl, Apache, mod Perl, SOAP, XML, SSL, Msql, Javascript, CSS, UNIX, Linux, Windows, Power Builder, HTML, CVS, BCP, ISQL, PVCS Tracker, Informix, Orace 9i, 10i, Squirrel Sql

Fixed Income and Asset Management

The project scope is managed via the Project Charter. The Workstation is the Global Application Portal for JP Morgan Private bank. It is a suite of applications tailored for Private Bank Business and supports day to day investment activities.We have recently released a new IPB Workstation entity called SAO to host the Brazil onshore accounts. This new platform is particular as the BO system is not OLYMPIC, but outsourced to different companies, namely Banco ITAU for Managed accounts and JPM Investment Bank for Brokerage accounts. In a first phase we have installed the SAO server, and delivered the Workstation access and view of Client accounts and Client Positions consolidated view from Banco ITAU and JPMorgan Investment bank .

Responsibilities

• Writing and modifying complex Sybase Stored Procedures, Perl scripts, SQL code for production processes that supports the organization. Researching and resolving production problems. Participating in full projects analysis, coding, testing, debugging, implementation .
• Wrote Perl Script for creating def files that included several Perl Modules for executing stored procedures for extracting and processing data. Similarly, comparators were written in XML format to compare and reconcile the tables in Platinum server, Brazil and International Private Bank, Geneva, SUI.
• Did designing, developing and enhancing, maintenance and migrating the Client/Server Applications using Power Builder version 6.5,7,8 and 9 including PFC with in relational database and client server environment Sybase on Win NT, Oracle, SQL, PL/SQL and Batch process UNIX and Shell Script .
• Wrote Korn Shell to provide management with the ability to monitor, track, record, and audit every command executed by any user of a system. It provided detailed information that includes date, time, tty, user, an the command. The information was transmitted in real time to a remote logging system.
• Production support of Batch Jobs Define in the UNIX Server, developing and enhancing the shell scripts, executing the shell script manually defend in the cron whenever the process fail and FTP the require file from other system
• Bond Portfoilio System totaling over 3.5 B in short term, intermediate and long term T-Bill notes, new asset based system runs in a J2EE/Websphere 7.0 cluster EJB framework is a custom Java API which prices futures contracts using Monte Carlo and the calculus of finite differences pricing models center

Environment: PERL 5.8.4, Sybase 15.0.2, UNIX, Linux, PowerBuiler, J2EE, Windows, Subversion, Embarcedo DBArtisan 8.7.4, Kornshell Scripts, Crontab, BCP, ISQL, YART Yet Another Release Tool, HP Ouality Center 9.2

Consumer Equipment Tracking System CETS Integration

The moves are scheduled by CETS move schedule. A PowerBuilder Application utilizing a Sybase database and Sybase stored procedures. The primary focus of the system is on four core areas.1 Move 2 Service/PM 3 Parts Inventory Management 4 Equipment Inventory Management. Canada is retiring their equipment tracking and service system in an effort to consolidate application maintenance efforts with the US. CETS, the US Equipment and Service application is currently being enhanced and will be modified and internationalized so that it can be used for Canada and potentially Mexico in future releases. Internationalization of the application includes three major buckets of work, primarily: a Language b Tax - Application should be flexible enough to charge for tax appropriately to the country's tax specification. c Invoice - Invoicing based on BU or Country specifications.

Responsibilities

• Wrote stored procedures to compute the three levels of taxation based on adjusted rates, the asset, the contract type, part and the service type.
• Designed and developed many Sybase tables, Stored Procedures and Triggers and database objects such as rules, constraints and defaults.
• Enhanced several stored procedures for US to include Pepsi locations for Canada and its three levels of taxation.
• reated various tools using Perl and Unix shell scripts for instrumenting and tracking of all database objects in the system
• Developed GUI front end using Windows forms in C .
• Designed and implemented a web-based tool using dynamic HTML and Perl/CGI scripts for managing video files recorded for an interactive exhibit.
• Assisted in performance tuning with SYBASE to maximize the speed of the query
• Ran Autosys jobs which ran the KSH script, which would execute the respective stored procedures for Accounts Receivable AR , General Ledger GL , rental billing, for AR and GL and equipment service invoicing for AR and GL.
• Worked on supporting application on Unix platform
• Installed and maintained CVS Concurrent Version Management System to provide source control within the Perl development and production environments
• Participated in UAT and took part in project documentation.
• Developed Unix shell scripts, PERL scripts which run as cron jobs in a specified time interval to make connection with the database and extract the data of interest from various tables very large in volume and populate tables smaller in size so as to improve the SQL query execution time and hence making the system perform efficiently.

Environment: Sybase 11.x,12.x, Kornshell Scripts, Perl, C , DB2, UNIX, Linux, Windows, Power Builder, Matlab, HTML, JavaScript, GUI, CVS, Rapid SQL Embarcedo 7.4.1, Serena Version Control, Autosys, BCP, ISQL

Risk management - International Equity Trades

The system provides all clearing, settlement and risk management services to Turqoise, a consortium of seven major financial institutions that are working to develop a new pan, European trading platform EuroCCP . It accepts trade from the Turqoise trading platform and these trades are then netted on the trade date. The trades are handled through general clearing member relationships. It applies risk based margining with appropriate levels of margining collected on daily basis. Separate margin and guarantee fund is established. Its global transaction service business processes EuroCCP's settlement instructions for delivering and receiving securities and related payments in various currencies through its local securities network.

Responsibilities:

• Wrote wrapped stored procedure for referential integrity.
• Worked on supporting application on Unix platform
• Used Perl, Sybase.pm for Sybase connection and creation of various web pages using Perl, C , CGI and HTML end.
• Designed and developed many Sybase tables, Stored Procedures and Triggers
• Created many Sybase database objects
• Assisted in SQL database design and performance tuning
• Used SQL objects such as rules, constraints, and defaults to enforce data integrity.
• Used Perl DBI/DBD along with html for creating the screen for reports at front end.
• Created many batch scripts using Unix Shell scripts UNIX SHELL SCRIPTS
• Utilized object oriented Perl, and the Tk GUI library for development of special projects
• Used AUTOSYS for scheduling jobs
• Wrote stored procedures and triggers to send the settled information to the financial clients.
• Created many Sybase TSQL batches for backend work.
• Used SQL server for full commit, rollback, crash recovery and row level locking capabilities
• Design and developed DBI/DBD and DB library connection script for the data retrieval or data manipulation.
• Developed many SYBASE batches for backend work and tuned queries for better performance by creating index, stored procedure triggers.
• Assisted in for all aspects of the project including analysis, coding, maintenance and end user support.
• Participated in UAT and took part in project documentation for European Corporation ECCP .

Environment: Sybase 12x, DB2, UNIX, Linux, Windows, C , SAS, Matlab, HTML, JavaScript, Perl, UNIX SELL SCRIPTS, Rapid SQL Embarcedo 7.4.1, PVCS, Crontab, Autosys, PVCS Tracker

Financial Customer Management System

My SQL Server, Sybase and Perl developer

This system was designed and built to effectively address customer queries in a systematic way. The software has modules for the user to enter the customer queries and complaints, to view reports based on the number of complaints, to enter customer details in case the customers wish to buy or redeem mutual fund units and a automated mail process. The automated mail process runs in the background and checks the database for any data and exports the data to a MS-Excel file and mails to service agents, where the complaints are addressed and sent back to the software and is imported by the mail process into the database.

Responsibilities:

• Developed all the middleware components, which consisted of all the business logic, using C and ATL.
• Developed many HTML pages for data presentation and collection.
• Created many Sybase TSQL batches for backend work.
• Developed various stored procedures, triggers on Sybase database.
• Developed Project management Plan.
• Developed server side PERL scripts for data collection and manipulation for the reports.
• Design documents Low High Level Design, Design Level Document .
• Participated in Unit/System testing.
• Worked with MS SQL team.
• Took part in project documentation.

Environment: C , PERL, CGI, Html, JavaScript, Sybase 11.5.1, MSSQL 2000, DBI/DBD, Apache Web Server, HPUX, Windows NT