SUMMARY:

• Around 19 years of experience in IT focused in design, development and implementation of Data Warehousing, client server and web - based applications developed for Financial (Brokerage/Trading), Pharmaceutical, Shipping and Telecom industries with experience in Oracle (14 Years), Perl (14 Years), informatica (7 years), Java (6Years), IBM MQSeries (10), SQL, Pro*C (4 Years), UNIX (18 Years), Windows (16 Years), Data Warehousing (7 years).

TECHNICAL SKILLS:

Skills: Perl, Shell, Java, C++,C, Pro*C, PL/SQL,OOP, OOD, Javascript, JSP, HTML, DHTML, SQL, Roguewave, MS SQL, Oracle, Sybase, DBX, PVCS, Sablime. Clear Case, Visual Source safe, Visual cafe, Rational Rose, UML, Unix, EJB, Websphere, Weblogic, Jrun, Tomcat, XML, XSLT and XSL:FO.

Tools: TOAD, ERWIN,DBARTISAN,Rapid SQL.ECLIPSE.

PROFESSIONAL EXPERIENCE:

AVP/Senior Programmer Analyst

Confidential

Responsibilities:

• Used Business Object tool (Cognos 8) for performance analysis.
• Analyzed the products and determined better logic to determine PrimaryMarkets for Products Trading.
• Created a report based on volumes of stocks with time to determine PrimaryMarkets for products.
• Designed the Price Variance logic and created an alert for large variation.
• Wrote an alert for Swift messages for message delivery failure.
• Used Cognos 8 to generate Dash boards for positions
• Familiar with Data Microstrategy, Ascential, Teradata.Data Modeling Experience:Swap Data Modeling
• Gathered requirements from Business folks
• Used Use Cases for business logic.
• Identified the entities and designed ERD for data usage.
• Converted ERD to logical tables.
• Used Star model in multidimension for positions.Securities as Products
• Did data modeling for Products Set up.Libor other Forex Rates Design
• Designed the Use Case diagram for flow of Libor Dataand other Forex Rates. Corporate Actions
• Did Data Modeling for Corporate ActionsAdministration Work in Informatica:
• Installed a new odbc driver for third party vendor database by name Meta Metrix. Configured Informatica on Unix box (Solaris OS) to use the ODBC driver.
• Added new repositories and users for UAT in development servers
• Helped Informatica Admins to tune informatica in memory allocation onSun machines
• Designed a common Frame Work in Shell to run Informatica Work flows.Examples a)pmcmd command b)Parameter file substitution. c) Appending of Workflow and Session log files to main logfile d) Trapping of errors. e) Developed a Connection Pool using informatica system variable$DBCOnnection * to usedifferent database.
• Developed Loopkup mapping for CDS products.
• Implemented Reusable Cross Mapplet using Dynamic Cache in Informatica.
• Tuned the target objects for loading data. Tuning involved index creationOn database objects, commit intervals in informatica workflow.
• User routers to load data for updates and inserts
• Used dynamic lookup for target object to reduce the reading freq. for target.
• Created Deltas (Insert, Update and delete files) for down stream systems.
• Used multiple cache features in dynamic lookup to make sure that if one cache corrupted, other cash cab used. This is to avoid reloading the cacheFrom target object as it was being used frequently by OLAP applications.Forex Data Load(Rates,COF’s,FEDOPEN Rates and FX Rates)
• Used Web service from Informtica to pull Forex rates. This is still in development stage. The old code used to use Web service by perl.Products Sync up (Fixed Income, Options, Futures, Equity)
• Developed multi partition access to source databases to pull Product data. This is to improve the performance as source database (DB2) has about 20 millions of demoralized data. Range Partition and Hash Partition techniques are used. The target is Oracle database.Data Files load
• Developed mappings to load Main Frame files. Used COBOL Input SourceQualifier for this.
• Used Informtica to load delimited files.Use XML Source Qualifier Transformation to load and parse XML data filesData Load from Message Ques(MQ Series)
• Used Message Que Input Transformation to load MQ Series data.Developed Cross Database (Oracle, Sybase and DB2) mappings for products (Equity, Fixed Income, Futures and Options using informatica.Migration of Legacy Loads
• Migrated all legacy loadings to informatica.
• Used XML source qualifier tp pase XML files.
• Used rank transformation to report different levels of Stock availability (Quantity) to Stock Loan groups.
• Developed a common Frame Work in Shell in Unix to run informatica jobs.
• Wrote Shell Wrappers to run Informatica Workflows.
• Did query tuning in Oracle 10G.
• Tuned Linux for Oracle Database Server.
• Installed Perl DBA module for oracle.
• Did back up of database from Prod to UAT servers(Imports and Exports)
• Did partition implementation for history data.
• Used index tuning using bitmap index for low cardinality data.
• Suggested Buffer Pool configuration to improve performance.
• Wrote PL/SQL Procs and Triggers.
• Created Materialized view to reduce network traffic for large tables.
• Suggested to DBA’s for Striping of large tables across different disks to
• Used SQL trace in oracle for performance tuning of queries.
• Used SQL loader to load data files.
• Wrote Stored Procs in DB2.
• Wrote Sqls in DB2 and used them through Data Joiner.
• Did Query tuning in DB2.
• Use XSLT in XPATH to parse XML files coming from Message Que(MQ Series).
• Wrote SAX parser in Perl Code to parse large XML files.
• Did Production Support for all of the above applications.
• Wrote java code using JDBC to pull Futures activity data from DB2.

Sr. Programmer/Analyst

Confidential, Vienna, Virginia

Responsibilities:

• Wrote a Module perl which creates XML file using XML generator Module from Excel Spread Sheets, Data from MS Access and Flat tab delimited text Files and send it to the third Part by secured ftp.
• Wrote Stored Procs and Triggers in Sybase to keep Database in Sync
• Wrote a Module in Perl, which gets Data from DB2 database using DBI.pm and Creates output in XML format.

Programmer/ Analyst

Confidential, South Brunswick, NJ

Responsibilities:

• Wrote Perl code to load Data from Confidential and Reuters to Oracle Database.
• Wrote Stored Procs and Triggers in Oracle
• Tuned Queries in Oracle.
• Preprocessed the feed in Perl and Created XML file using DOM Parser in Java.
• Wrote a Loader in Java to Load XML Data in to Oracle Database.
• Wrote Triggers and Procedures in Sybase to keep the Data in Sync.
• Wrote an alert System in Perl to Monitor Websites. LWP Module was used here.

Sr. Programmer/Analyst

Confidential, White House, NJ

Responsibilities:

• Here Oracle 8i was used. Installed Oracle 8i in Solaris, set up the environment and Database.
• Preprocessed the feed and converted that to XML using XML Generator in Perl.
• Wrote Procedures and Triggers. Wrote Java Servlets. The webserver was IBM Websphere. The Object Oriented Feature of Oracle 8i is used here to query the Database. Wrote Procedures and Triggers using PL/SQL. The Screens are designed using DHTML and Links are made dynamic in JavaScript.

Sr. Programmer/Analyst

Confidential, Franklin Lakes, NJ

Responsibilities:

• Worked on the enhancement of existing Prescription Card System using C++ under CGI. Here to get the Data from Mainframe, IBM MQSeries is used. WebServer was Apache.
• Used SiteScope tool to check Web Performance.
• Some of the data related to PCS is stored in Sybase. Wrote Stored Procs in Sybase.
• Wrote C++ Code using CT-Library to get Data from Sybase.This Program is used under CGI Environment.
• Wrote shell scripts to do some maintenance tasks.
• Wrote Stored Procs and Triggers in Sybase.
• Developed on line Application Log in Perl under CGI. The Pop Menu is handled Confidential the front end in JavaScript.
• Wrote an Application in Java to Create XML file for Data from Apache’s DOM Parser.

Environment: C++, SQL, Sybase, UNIX (HP UNIX), NT, Rougewave, Java, JDBC 1.0, Perl, Sybase, PVCS, Rational Rose, Apache Webserver.

Sr. Programmer/Analyst

Confidential, NJ

Responsibilities:

• Responsible for Parcel Tracking System. Designed Object Oriented Parcel using OOA/OOD. Used Rational Rose tool to Design Classes. Implemented Classes which represent the Objects like HTML attributes (like table, rows etc.), Cookies, MiddleWare library using MQSeries etc.
• Wrote JavaScripts to do the Validation of User Entered data Confidential the front end.
• Did integration of all the modules for the Tracking System.
• Set up the testing Environments and wrote some shell scripts in Korn Shell.Responsible for Bulkmail System. This will help to send Messages in bulk maintaining the confidentiality. This is developed using Visual C++ 5.
• Developed a Testdriver for Confidential Bulkmail System using Visual Basic 5.

Environment: C++, UNIX (Sun Solaris), Rougewave, Perl, HTML, JavaScript, Shell Script (Ksh), CVS, Visual Basic, Rational Rose.

Programmer/Analyst

Confidential, Middletown, NJ

Responsibilities:

• Worked on tuning of oracle queries.
• Wrote triggers in PL/SQL to handle the Updates on existing circuit.
• Did the Production Support for MO. Wrote Awk scripts to process the Logfile to determine the Performance MO Server.

Programmer/Analyst

Confidential, Piscataway, NJ

Responsibilities:

• Responsible for the maintenance of Confidential &T’s Financial Database.
• Enhanced the existing application written in C for Sybase and Oracle. Used Dblibrary for Sybase and Pro C for Oracle.
• Wrote Embedded SQL Code in C for Informix.

Software Engineer

Confidential, Allendale, NJ

Responsibilities:

• Responsible for Migration of Data from Confidential ’s Proprietary Database to Oracle Database.
• Wrote Procedures and Triggers in Oracle.
• Used VMS OS for test validation scripts.

Environment: C/C++(Borland), SQL, Oracle, UNIX (HP UNIX), NT, Shell Script (Ksh).

Programmer

Confidential, Oldbridge, NJ

Responsibilities:

• Designed a GUI Interface in Visual Basic for the Data Entry of Cable Information from Confidential (Now Confidential ).
• Wrote C code using DB Library.
• Wrote stored procs and triggers in Sybase.

Environment: C, SQL, and Sybase, UNIX (HP UNIX, Solaris).