Project Sql

Samir Jain

*****.****@*****.***

508-***-**** Home

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, First Class (1992 1994)

Institute of Computer Science and Electronics, DAVV University, India

BS Computer Science, First Class (1988 1991)

Delhi University, New Delhi, India

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, ASP/HTML, 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

U.S Resident Status: U.S Citizen

Project Details

Fresenius Medical Care, Lexington, MA Oct 2007 - Current

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. Extensive SQL

performance tuning utlilizing hints etc, reading the TKPROF and Explain

Plan etc.

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

Center.

Fidelity Investments, 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. Extensive performance tuning utilizing hints etc, reading the TKPROF

and Explain Plan etc.

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

Iron Mountain, 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.

Pfizer Inc, 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.

Eagle/Mellon Investments (Navo Systems), 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.

Pioneer Investments, 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.

EMC, 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.

John Hancock, 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.

Hills Departmental Stores, Boston, MA Dec 1997 Feb 1999.

Programmer Analyst (Data Warehouse)

Project: Stores Interface.

Description: Development, analysis, integration and maintenance of

Interface between Retek Merchandising System and Stores. I was involved in

creating and standardizing the makefiles and buildfiles for Pro*C and C

programs. Also created various C utilities libraries used in data

conversion and a few for error capturing and reporting for C and Pro*C

programs.

Platform: C, Oracle 8.0.4/7.3.4, PL/SQL 2.3.3, Pro*C 2.3, SQL Plus 3.3,

Oracle Forms and Reports, UNIX Shell Scirpts(AWK), Erwin, SQL Navigator.

Citicorp Technology Center, Westlake, Fort Worth, TX. Nov 1996 Nov

1997

Development, Testing, Integration, Maintenance

Project: Account Server

Description: Involved in coding, unit testing, Code Walkthrough's, IQA of

various API's (server function's) in C, Pro*C, and PL/SQL(Stored

Procedures, Packages, Triggers), C Shell Scirpts and SQL Loader. The

system provides services like: Profile Services (Open Account, Change

account, etc.), Balance Services (GetFutureBal, GetTurnOver, etc.),

Movements Services (CreateCashMovement, GetMvmtDtls, etc.), End-of-Period

Services (Post Maturing Transactions, Back Valued Transactions, Purge).

Platform: C, C++, HP-UX, ORACLE 7.3.4, SQL Plus 3.3, PL/SQL 2.3.3, Pro*C

2.3, UNIX Shell Scirpts, SQL Navigator, HP UNIX 10.2.

Jun 1994 - Sep 1996

Programmer Analyst

Location: New Delhi, India

Platform: C, Oracle 7.1, 7.2, SQL*Forms 3.0, Pro*C, HP-UNIX and PL/SQL,

Stored Procedures, Packages, 2.0, Oracle Developer 2000.

Contact this candidate