Experience Summary:
Software professional with over 12 years of experience in developing high level and technical design, debugging, enhancements, testing using multiple computer languages, APIs, and tools on diverse operating systems. Experience working on a broad range of assignments doing full life cycle development using Oracle PL/SQL, Oracle Designer, Performance Tuning, Collections, Objects, Dynamic SQL Queries, SQL*Loader, Optimization, JDBC, Backend processing, UNIX and Perl Scripts. Has been involved in project planning, resource estimating, and progress reporting and proven ability to build effective relationship and manage multiple projects simultaneously. Worked in different industries like Financial (Pioneer Investment, Eagle Investment), Insurance (John Hancock), Pharmaceutical (Pfizer Inc), Storage and Records Management (Iron Mountain, EMC) etc. Strong interpersonal and communication skills and can be effective immediately on a project.

Education
MS Computer Science, 
Institute of Computer Science and Electronics, Confidential University 
BS Computer Science 
Confidential University

Technical Skills
Databases: ORACLE 11i, 10g, 9.x, 8.x, 7.x, 6.0, PostGresSQL, PL/SQL, PRO*C, PRO*COBOL, SQL-LOADER, SQL-Navigator, Toad
Languages: C, COBOL, JDBC, PERL 5.X
Operating Systems: UNIX (HP-UX, AT&T, SUN), Win 2000, DOS.
Tools: ORACLE DESIGNER, INFORMATICA (ETL), CLEAR CASE, MKS, PVCS, Quality Center
Hardware: HP-9000/847, E-45 (MINI FRAME) IBM PC-AT, SUN SOLARIS

Project Details

Confidential, Boston, MA Sep 2011 - Current
Consultant
Project: HI INCOME GROUP.
Role: Design and Development of Stored Packages, Views to generate data [Index, Security, Fund etc] required to generate reports for Portfolio Managers. Create Autosys job to schedule jobs to load data in tables. I am involved in performing data analysis, writing data repair scripts, maintain reference data and resolve data issues.

Involved in performing the Code Reviews, Designing Technical Specs, Unit Testing, Query optimization, SQL Tuning. Performance tuning, reading the TKPROF and Explain Plan etc.

Platform: Oracle 11i,10g, 9i, PL/SQL, SQL, Toad, UNIX, Autosys, SQL Server

Confidential, Lexington, MA Oct 2007 – Sep 2011
Consultant
Project: Chairside and Patient Trak Application.
Role: Design and Development of several Data Interfaces, API’s called from within Java, Reporting and Dashboard generation using the LogiXML tool.

Essential job functions include leading one-person projects, including analysis, design, scheduling along with application code development, maintenance and debugging under no or minimal supervision. Works with other developers and business analyst to define business problems, analyze existing systems and perform production code changes/enhancements.

Technical contribution involves mapping functional requirements into high and detail level technical design documents, developing data model, identifying API s interacting with Java. Developing Packages, Stored Procedure, Views, Triggers other backend objects along with UNIX Shell [Perl] for batch processes or for release engineering.

Platform: Oracle 10g, 11i, PL/SQL, SQL, Toad, UNIX, LogiXML, UNIX, Quality Center.

Confidential, Boston, MA Jun 2007 – Sep 2007
Consultant
Project: Data warehouse for Web Stats group.
Role: Design, development of backend stored procedures, packages, Views which are served as the common code repository for various projects etc. Involved in performing the Code Reviews, Designing Technical Specs, Unit Testing, Query optimization, SQL Tuning and adding/changing objects to Data Model.

Platform: Oracle 10g, 9i, PL/SQL, SQL, Toad, UNIX, Powerdesigner

Confidential, Boston, MA Sept 2004 June2007
Sr. Software Engineer
Project: Sustaining (Production Environment)
Role: Responsible for fixing S/W defects and enhancements to the production application. It also involved doing a lot of query performance, changes to the backend objects etc, creating and scheduling UNIX jobs etc. The changes in the application would go as next release or sometimes as hot fixes depending on the situation.

Project: Retention Management
Description: This module provides customers with tools to define how long assets are retained in the archive, and performs the actual destruction operations to remove assets from the archive subject to the business rules and customer approval workflow.

Project: Stability (Foldering / Asynchronous Search)
Description: The Iron Mountain Digital Archives EVAA system stores digital assets for customers and provides search and retrieval features for stored assets. Foldering is a way where users can store, search and retrieve their assets.

Project: SSO (Single Sign On)
Description: This part of the application is responsible for validating user s log on credentials, changing their password (by Admin or user), forcing the user to change their password (SLA property), lock or disable an account based on their inactivity etc.

Platform: Oracle 10g, 9i, Sun Solaris UNIX (ksh, sh), Oracle Designer, PL/SQL, SQL*Loader, Toad, Perl 5.x, JDBC.

Confidential, CT Jun 2003 Aug 2004
Sr. Programmer Analyst

Project: Electronic Data Capture Management (EDC Management)

Role: Design, development, bug-fixing, maintenance of the various backend stored procedures, packages, functions, views etc and in the development of the front end application built using JavaScript, HTML, Perl, CGI, Oracle. The Perl program creates dynamic pages using HTML, and JavaScript s based on the various functional needs of the users. I was also involved in writing a plenty of batch jobs and backend processes I was also involved in doing the Code Reviews, Designing Technical Specs, Unit Testing, Query optimization, SQL Tuning and adding/changing objects to Data Model. Extensive performance tuning utilizing hints etc, reading the TKPROF and Explain Plan etc.

Platform: Perl, Oracle 9i, 8i, PL/SQL, HTML, Javascript, CGI, SQL, SQ*LOADER, UNIX, ERWIN, SQL Navigator.

Confidential, Boston, MA Apr 2002 Feb 2003
Contractor

Project: Security Exchange Commission Yield Processing.
Description: Eagle Investments delivers customized software packages to it clients dealing in Financial Investments for tracking the yields of Mutual funds and track their performance over a period of time. Current project requires amendments required by Securities and Exchange Commission are the calculation of Mutual Fund performance to better investor s ability to evaluate and compare the Mutual Funds. The objective of this project is to give Star the ability to calculate and report SEC Yields. All the below listed functionalities have been developed in Oracle PL/SQL, Packages, Stored Procedures and Functions, Triggers, UNIX, Perl.
Role: Design and development of various Oracle Stored Procedures, Packages, Triggers, Stored Functions, Views and Perl/UNIX Shell Scirpts for the calculation of complex Interest Income on various Fund s, Equity and Debt for various Securities like BondsWithCall, PrefundBonds, MortAssetBkd, MuniBonds,SteUpBonds,ShortTermBonds, BondsWithPut etc etc.
Calculate Expense Processing for a shared class, Update Expenses for a specified Share Class, Get the Forex Rate, Add Shares adjustment and Expense adjustments.
Income and Shares Adjustments with functionalities like Adding Security Income Adjustment for a specified amount or on account of Yield change, Add Entity Income Adjustment.
Calculation of interest income on a Settled and Pending positions for Business and Non Business days etc.

Platform: Oracle 9i, PL/SQL, SQL, SQ*LOADER, Perl 5.0, UNIX (Sun Solaris), HTML, XML, Win 2000 server, ERWIN, Toad, SQL Server.

Confidential, Boston, MA Nov 2001 Apr 2002
Contractor
Project: E-commerce Reporting.
Description: Pioneer Funds is one of the leading Asset Management Companies and they have a wide variety of Financial Products like Mutual Funds, Variable Annuities and Literature requests. This particular system was responsible for generating reports of visitor information. Visitors can be anyone from Share owners, Brokers, Dealers to Internal users. These reports help top management make decisions to better their services.
Role: Design and Development of Perl, UNIX, Awk, Sed and Oracle Scripts (complex PL/SQL routines, Packages etc etc) to populate Pioneer s Reporting Database for their future Data Ware House needs. Used many Perl Scirpting features like Regular Expression Parsing, Executing GET and POST for the URL s, Connecting to Data Base, Arrays, Functions, Exception Handling, Libraries like LWP, DBI, DBD, URI etc. Also, installed the Perl modules and libraries as needed.
The Perl Scripts take the data on a daily(nightly) basis from the ATG Dynamo s HTML/XML repositories. These files are maintained through templated contents from Interwoven, and updated directly on the ATG server. For maintenance purposes, the data from these repositories is accessed through a JHTML page which serves as a front end to Dynamo\'s repositories. The Perl Scripts takes in the required attributes and resolves the repository according to the path given as a query parameter in the request object, parses the records for their various Portals(US, ITALY,GERMANY etc) and populates the database. I was also involved in doing SQL Tuning and resolving Performance issues within the Crystal Report s SQL s executed at the server side so that the reports can be executed faster.

Project: Portfolio Management Application
Description: This is an application developed within Pioneer Investments which displays performance data for securities held by Pioneer funds and benchmark indices. Various reports in PMA display fund and index holdings, real-time prices, transaction data, commission s reports, analyst recommendations, etc. Also available is a trading interface that allows portfolio managers to enter security buys and sells, and send them to the traders to place orders.
Role: Designed and Developed load scripts which loads data into the database from various sources (mostly flat files). The entire logic of these scripts were developed in packages,PL/SQL stored procedures. Worked on writing, maintaining, optimizing and trouble-shooting all load scripts.
Worked on various reports for the application which is developed in Packages, procedures, functions, database types and collections, temporary tables, system performance and Query Optimization. Worked on developing and implementing test plan and test cases for the PMA applications. Developed Library Functions, Stored Procedures, Packages and Triggers

Platform: Oracle 8i, PostGresSQL, PL/SQL, Stored Procedures, Explain Plan, SQL, Perl 5.0, UNIX (Sun Solaris), ASP, ATG Dynamo, Crystal Reports 8.5, SQL Server.

Confidential, Westborough, MA May 2000 Sept 2001 
Contractor

Project: Integrated Dataware Application
Platform: Oracle 9i, 8i, Win NT, UNIX (Sun Solaris).
Role: Design, Development, Testing, and Maintenance of the ECO\'s (Engineering Change Orders) interface and to populate various Data Marts, Data Store from different source systems. Data is extracted from Oracle Applications source tables located in various Data Bases to the IDW Data Store (DS) using the Informatica ETL tool, PL/SQL programs (Stored Procedures, Packages, Triggers etc) and UNIX Shell and Perl Scripts.

Platform: Informatica, SQL*Loader, PL/SQL, SQL Navigator, Perl and UNIX Shell Scirpts, Explain plan, Erwin, Java(Light level), JDBC.

Confidential, Boston MA, Mar 1999 Mar 2000
Sr Programmer/Analyst for Marketing Data ware House Team/Licensing and Registration System

Description: I was involved in Development, Analysis, Testing, Integration, Maintenance and Enhancements for the Marketing Data Base (MDB) which forecast the Sales and Marketing trends through the data feeds into MDB. The work includes converting the existing PDL code to the corresponding Pro*C and C code, PL/SQL, Oracle Packages and Procedures, Triggers. Developed the C functions to convert the various data types like binary, packed decimal, unsigned packed decimal, EBCDIC, hex etc. to ASCII format.

Platform: C, Pro*C 2.3, Oracle (7.3.4), SQL/Plus, PL/SQL, Perl, UNIX (Sun Solaris), Shell Scirpts, SQL Loader, Export/Import, Toad, Parallel Data Language (PDL) on Sun Solaris.