Muruga Subramanian 
(925)8030771


SUMMARY 
Around 10 years of experience in different areas as a Senior Analyst Programmer. A Qualified Software Professional with a significant record of achievement in the field of Software Industry. This includes System Study, Design, Development, Testing and Implementation of application Software.  
TECHNICAL SKILLS 
PL/SQL, Shell Scripting, SQL Loader, SQL PLUS, TOAD, Developer/2000, Developer/2000 v2.0, RMAN, Statspack, Designer/2000 v2.1, Discoverer, JDeveloper 3.1, Enterprise Manager, Oracle Data Pump, PL/SQL Webtoolkit Visual Cafe, Shell Scripting, Ant 1.5, Crystal Reports, JDBC, C++, JDK 1.3, JDBC API v1.22, VB5.0, JSDK 2.0, JSP 1.2, Servlet 2.3, Velocity, Dreamweaver4.0, UltraEdit 1.1, Perl 5.6.1, Perl 5.8.7 and Perl DBI
RDBMS: Oracle 7.x, Oracle 8.0, Oracle 8.1.x, Oracle 9.x and Oracle 10g
Operating Systems: Windows XP, Windows 2000, Windows NT 4.0, Windows 95, SCO UNIX V 5.0.2, Sun Solaris 2.7, Linux 2.4.6, Digital Unix 4.0 and MS-DOS 
Web Servers: iPlanet Web Server 4.1, Tomcat 3.2.1, Apache 
Configuration Tools: Rational Clear Case, CVS and Visual Source Safe 
Application Server: Web Logic Server 6.x and Oracle 9iAS Release 2
Data Modeling Tools: ERWIN, Designer/2000
Oracle Applications: Knowledge of Oracle Apps 11i Schemas (AP, AR, GL, INV and OKC)

WagerWorks, San Francisco 
Sr. Database Developer			            Nov 2006 â?“ Present

Description:  
        This Project in essence deals with creating, feature-rich and regulatory compliant casino and poker online solutions
              
I was primarily involved with
â?¢	Managing tables (Standard and Raw), indexes (Tree and Functional), constraints, views  sequences, synonyms and stored program units.
â?¢	Creating Stored Program Units in the Functions, Triggers and procedures for implementing complex database intensive business rules as well as for BI extracts.
â?¢	Created Bourne Shell scripts and Bash Shell Scripts for automating tasks as well as for creating extracts.
â?¢	Heavily involved with the Physical Design of the Database.
â?¢	Performance Tuning of the Database(Informix), in the form of SQL Tuning, SPL Tuning, Memory Tuning and I/O tuning
â?¢	Created DDL scripts and Stored Program Units for migrating the current product from version 1.x to 2.x
â?¢	Prototyped a solution for Migrating from IDS to Oracle.


Environment: Informix IDS 9.4.0 UC3 and FC5, SPL, Oracle 10g (10.2.0), Solaris 5.8, PL/SQL, SQL Developer, DBAccess, AquaStudio, Bourne and Bash Shell Scripting and OEM.


IJS
Sr. DataModeler/Developer/DBA				               Apr 2006 - Aug 2006

Description:  
        This Project in essence, deals with Prescription Drug Programs (Medicare Part D)
              
I was primarily involved with
* Managing tables (HEAP, IOT and GTT), indexes (Btree and Functional), constraints, views and sequences.
* Creating Stored Program Units in the Form of Packages, Functions, Triggers and procedures for implementing the complex database intensive business rules.
* Enhancing the existing Stored Program Units to boost their performance ten fold using array processing and bulk binds.
* Created Bourne Shell scripts for automating tasks.
* Developed Perl scripts to simplify deployment of database scripts. 
* Heavily involved with the Physical Design of the Database.
* Performance Tuning of the Database(Oracle 10g, 9i and 8i), in the form of SQL Tuning, PL/SQL Tuning, Memory Tuning and I/O tuning
* Using TKPROF, Explain Plan, Optimizer Hints, ADDM, AWR, DBMS_Profiler and Stats Pack (Wait Events, Latches and Wait Interfaces).
* Performed Backups and Recoveries.
* Performed Installations and Upgrades.

Environment: Oracle 10g (10.2.0), Oracle 9i (9.2.0.7), Oracle 8i, Red Hat Linux Kernel 2.4.8.1, Solaris, PL/SQL, TOAD, Perl 5.8, RMAN, Bourne Shell Scripting and OEM.


Deftmd.com
Sr. DataModeler/Developer/DBA				               Feb 2006 âïon;¿½â?œ Mar 2006

Description:  
              This Project essentially deals with Health Care Claims Management System.
I was primarily involved with
* Logical and Physical Design of  Claims Management System 
* Managing tables, indexes, constraints, views and sequences.
* Creating Stored Program Units in the Form of Packages, Functions, Triggers and procedures for implementing the complex database intensive business rules.
* Created Bourne Shell scripts for automating tasks.
* Performance Tuning of the Database, in the form of SQL Tuning, Memory Tuning and I/O tuning
* Using TKPROF, Explain Plan, Optimizer Hints, ADDM, AWR and Stats Pack(Wait Events, Latches and Interfaces).

Environment: Oracle 10g(10.1.3), Red Hat Linux Kernel 2.4.8.1, Oracle Designer 10g, PL/SQL, JDeveloper 10g, Bourne Shell Scripting and OEM.


Betzip.com
Sr. DataModeler/Developer/DBA				               Dec 2005 âïon;¿½â?œ Jan 2006

Description:  
              This Project primarily deals with an online multi-gaming site.
I was primarily involved with
* Logical and Physical Design of Subscription Management System using ERD, DDT, Design Editor and RON.
* Administration of Oracle Designer using RAU.
* Managing tables, indexes, constraints, views and sequences.
* Creating Stored Program Units in the Form of Packages, Functions, Triggers and procedures for implementing the complex database intensive business rules.
* Created Bourne Shell scripts for automating tasks.
* Performance Tuning of the Database, in the form of SQL Tuning, Memory Tuning and I/O tuning
* Using TKPROF, Explain Plan, Optimizer Hints, ADDM, AWR and Stats Pack (Wait Events, Latches and Interfaces).

Environment: Oracle 10g(10.1.3), Red Hat Linux Kernel 2.4.8.1, Oracle Designer 10g, PL/SQL, JDeveloper 10g, Bourne Shell Scripting and OEM.

Shopping.com, South San Francisco CA 
Sr. Database   Engineer						  Aug 2005 âïon;¿½â?œ Nov 2005

Description:  This Project is basically an online comparison of various merchandise. With millions of commodities, thousands of merchants and millions of reviews from the community. This endeavor empowers consumers to make informed choices and, as a result, drives much higher conversion to sale and value for merchants.

I was primarily involved with
* Managing tables, indexes, constraints, types, views, synonyms and sequences.
* Creating Aggregate Materialized Views for speeding up the response of SQL queries.
* Creating Stored Program Units in the Form of Packages, Functions, Triggers and procedures for implementing the complex database intensive business rules.
* Used DBMS_OLAP, DBMS_MVIEW for estimating the size of the Aggregate Materialized Views, determining the Capabilities of the Materialized Views and for Fast Refreshing the Aggregate Materialized Views.
* Created Bourne Shell scripts for automating tasks.
* Performance Tuning of the Database, in the form of SQL Tuning and Memory Tuning
Using TKPROF, Explain Plan, Optimizer Hints and Stats Pack (Wait Events and Latches)
* Creating Perl Scripts using DBI for refreshing the aggregates materialized views and for generating Tab Delimited files.


Environment: Oracle 9i (9.2.0.6), Red Hat Linux Kernel 2.4.8.1, PL/SQL, TOAD, Bourne Shell Scripting, Perl 5.8.7 and DBI.




PipelineSoftware, Irvine CA (Mitsui)
Oracle DBA/Developer  						Nov2004 - June 2005
Project: Supply Chain Management 3.0
Description: This purpose of this project is for increasing product availability and sales. The project also improves customer satisfaction and minimized inventory levels. Furthermore, it reduces transportation costs, warehousing costs and transaction costs. In addition to the above, it also reduces order-to-delivery and order-to-cash cycles.

I was primarily involved with
* Managing tables, indexes, constraints, types, views, object views, synonyms, sequences, locally managed tablespaces, datafiles, temp files, redo logs, archived redo logs, users, roles, assigning system and object privileges to roles and in turn assigning roles to the users and thereby securing the database.
* Creating Stored Program Units in the Form of Packages, Functions, Triggers and Procedures for implementing the database intensive business rules.
* Performing DBA Maintenance tasks in the form of adding datafiles to tablespaces, resizing the datafiles, increasing the size of redo log files, segregating the data, lob and the index tablespaces.
* Creating Backups (Compressed, Image Copy) using RMAN full and incremental, performing disaster recovery.
* Performing Tablespace, Datafile and Database Recoveries.
* Maintenance of Backups Using RMAN, namely deleting the expired and obsolete backups.
* Using the Scheduler for Automatic Tasks (Analyzing tables and the Data Dictionary).
* Created Korn Shell scripts for automating tasks.
* Performance Tuning the Database namely memory tuning, I/O tuning and SQL Tuning.
* Using SQL Loader for populating static tables and fact tables from CSV Files.
* Dynamically generating SQL scripts(Merge)
* Creating the Database using DBCA.
* Cloning the Database.
* Performing table-level, user-level exports using Data Pump.
* Used Designer for generating the DDL Scripts, for creating the schemas.


Environment: Oracle 10g (10.1.0.4), Red Hat Linux Kernel 2.4.8.1, PL/SQL, TOAD, Designer, SQL*Loader, Enterprise Manager, RMAN, TKPROF, STATSPACK and Korn Shell Scripting 

Target Corporation, Minneapolis
Sr. Oracle Developer/DBA				             	Aug 2004-Oct 2004
Project:  Diagnostic Tool Kit
 
Description: The Objective of this project is primarily for analyzing the various metrics of a retail order management system.

I was primarily involved with 
* Creating stored programs in the form of PL/SQL Packages, Procedures and Functions returning record sets, which in turn, are used for developing HTML reports using ASP.
* Creating Stored Packages for moving the data from the staging area tables to the Fact and the dimension tables.
* Creating Nested Aggregate Materialized Views (Three Levels).
* Utilizing Built in Oracle Packages like (UTL_FILE, DBMS_PIPE) for better debugging.
* Creating SQL Loader Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area Tables.
* Creating Korn Shell Scripts which act as a wrapper for various tasks like - for executing the SQL*Loader command lines, for refreshing the materialized views and for updating the Fact and the dimension tables with the data from the Staging Area Tables.
* Tuning the SQL Queries for better performance (The size of database was 10 Terabytes).
* Partitioning the Fact Tables and aggregate materialized views for enhanced Performance.
* Tuning various database instance parameters for improving the performance of this DSS.



Environment: Oracle 9.2.0.4, Solaris 5.6, PL/SQL, JDeveloper, SQL*Loader, Korn Shell Scripting and ERWIN

USAF,   Falls Church, VA						Aug 2003-June 2004
Sr. Developer
 
Project: COHORT
 
Description: This Projectâïon;¿½â�¢s objective is basically a System for Tracking Occupational Health and Risk.

I was primarily involved in 

* Creating Packaged Stored Procedures to bulk load data(Around 500 GB of Data) from Databases at Various Sites to a Consolidated Database.
* Responsible for the Logical and Physical Design of the Consolidated Database
* Used Ref Cursors, Native Dynamic SQL and Bulk Collections to implement the Bulk Load.
* Created Targets Using Ant for Rebuilding Databases for the Development Environment.
* Developed Packaged Stored Procedures for Testing the Transferred Bulk Load Data Using Set Operators and Bulk Collections.
* Developed Packaged Stored Procedures for Transferring the Difference of Static Table Data from the Independent Databases at Various Sites to the Consolidated Database in a Efficient Manner.
* Developed Packaged Stored Procedures for Transferring the CLOB data from various sites to the Consolidated Database.
* Performed SQL Query Tuning using TKProf and SQL Trace to improve performance.
* Streamlined and tuned the Consolidated Integrated Database for a better throughput.
* Created Functional indexes, Bitmap Indexes, Domain Indexes and BTree Indexes to improve performance.
* Developed Complex Reports (Master-Detail, Matrix and Columnar) using Reports 9i for presenting the Data.
* Developed Complex Forms, Customized Forms for Data Collection using Forms 9i.
* Created Simple, Join and Aggregated Materialized Views in DSS for Replicating an OLTP and using the concept of Query Rewrite to get better response time of  Aggregate Queries
* Used JDOM for building and for parsing XML
* Created Tables with XMLType for storing XML in database
* Used Advanced Queuing to enable asynchronous communication between application/users
* Created Queue tables, created queues, ability to browse through AQ Messages, ability to add AQ Subscribers and manage propagation.
* Created Object Views for co-existence of relational and object-oriented applications
* Created Packaged Procedures for Refreshing the Materialized Views and for setting up Cron Jobs using DBMS_JOB and DMBS_MVIEW
* Used Optimizer Hints to Control the Execution Plan of SQL Queries
* Used Discoverer to Create Business Areas for Business Intelligence Reports
* Developed DAO using Java and JDBC for transferring Data from Large Static Tables from Databases at various Sites to the Consolidated Database in an Efficient Manner.
* Used concept of external tables for migrating data from non-Oracle Databases to an Oracle Database through flat files(Fixed Record Length as well as CSV).
* Developed Tests to Validate the Data in External Table using UTL_FILE
* Developed Test Cases Using JUnit and DBUnit to test the above mentioned task.
* Developed a Servlet Filter.
* Demonstrated the use of Java stored procedures, for implementing database intensive logic, allowing portability across several database vendors.
* Demonstrated the Use of SQLJ as a standard way of embedding static SQL statements in Java programs, similar to how Pro*C allows you to embed static SQL statements in C.
* Assisted in Implementing Business Intelligence Using Oracle Financials
* Familiar with the AP and GL Schemas in Oracle Financial Apps.
* Demonstrated various methods (Incremental and Full Backups) of performing backup and recovery using RMAN.



Environment: Oracle 9.2.0.4, Windows 2000, TOAD 6, PL/SQL , Oracle 11i , JUnit, DBUnit, Eclipse, J2EE, Oracle9iAs, Reports 9i, Oracle Reports Server, PL/SQL, RMAN and ERWIN

Quant, Fremont						               April 2003-Jul2003
Sr. Developer
 
Project: HR Staffing Effectiveness Data Management Program
 
Description: This Projectâïon;¿½â�¢s objective is for measuring the effectiveness of healthcare staff.

I was primarily involved in architecting, designing and developing the product.

* Created Packaged Stored Procedures using PL/SQL to migrate data from Legacy System to the Current System.
* Created Stored Program Units using PL/SQL to implement Database Intensive Logic.
* Enhanced the Performance of the existing Oracle Database using SQL Tuning, Memory tuning and Instance Parameter Tuning.
* Created Functional indexes, Bit Mapped Indexes, Bitmap Join Indexes to improve performance
* Created Tables, Synonyms, Materialized Views, and Table spaces, Users, Profiles, Roles and Views.
* Performed Backup and Recovery Using RMAN.
* Responsible for the Logical and Physical Design of Database Using ERWIN
* Used MVC Architecture for architecting this product.
* Developed Servlet, JSPs and EJBs(Stateless and Stateful Session Beans)
* Developed Servlet which acts as a Controller
* Used  Struts to include a servlet that implements the primary function of mapping a request URI to an Action class
* Developed Data Access Objects for abstracting Data Base Access
* Developed JSPs which act as the view.
* Developed EJBs which act as a Model
* Used XML Based Messaging to communicate between different tiers
* Used JFreeChart  for developing various kinds of Charts for Benchmarking, Correlation and Time trend
* These above mentioned charts were used for Statistical Analysis.
* Developed Scatter Plots using JFreeChart

Environment: Oracle 9i, UML, Linux,  Windows 2000, TOAD 6, PL/SQL, RMAN, OEM, JFreeChart 0.98, J2EE, Java, Javascript, WebLogic 5.1, Struts 1.1 and ERWIN

JPMorgan Chase, NJ 							Nov 2002-March2003
Sr. Developer
 
Project: EZ-PASS Transition, Efunds and NavyCash 
 
Description: This Projectâïon;¿½â�¢s objective is migration of E-Z Pass New Jersey Customer Data into VECTOR, the ACS Electronic Toll Collection Systems. 
  *	Created Korn Shell scripts and AWK scripts for validating the data files (namely customer accounts, Plans, vehicles, Trip History, Transaction History and Toll) as well as the control files (which basically have totals and count of records in the data file). 
*	Created Korn Shell scripts for compressing and encrypting the image files. Created Perl Program for encrypting the Log files using PGP. 
*	Assisted in creating Perl scripts for generating data files (Fixed Record Length) from the database using Perl DBI and Oraperl. 
*	Modified PL/SQL Stored Procedures and PL/SQL Stored Packaged Procedures. Developed  Java Classes to execute PL/SQL stored Procedures in Database using JDBC. The data parameters, which are passed to the stored procedures, were read from a data file. 
             Developed report definition files (RDF) for presenting data in an intelligent way. 
             Namely    Master-Detail, Tabular, Group and Character Mode Reports.
*	Designed and developed Price/Yield and Analytics calculators for a fixed income securities trading system for banks.  
*	Used Perl Scripts for parsing invoice text files and creating files with fixed length records and validating the information in the invoices against the Database. 
*	Used Perl Scripts to generate MIS reports from the Database.  Modified C++ programs which access database (for performing DML) using OTL (Oracle Template Library)/OCI Libraries. 
*	Worked on a merchandising application system(transaction processing)  which is considered by most credit card processors to take place when a request for selling authorization or capture is passed through to them. 
*	Used XML for messaging to authorize the credit cards.
*	Used a stateful session bean and stateless session bean to calculate the total of all the products a customer has picked up. The tax and charges are calculated by a stateless session bean. 


Environment: Oracle 9i, Sun Solaris 2.6, Digital Unix, Windows 2000, TOAD 6, PGP, PL/SQL, Pro*C/C++, OTL, Perl 5.6.1, Fixed Income Securities, JRun, Perl DBI,Oraperl, CVS, Korn Shell, AWK ,sed, J2EE, JDBC, Java, C++ and Reports 6i

Closedloop Solutions, Redwood City, CA 			             Feb2002-Oct 2002
Application Developer

Project iClear Web Based Business Intelligence System 
 
Closedloop Solutions offers a suite of enterprise applications for dynamic financial planning and control of customerâïon;¿½â�¢s business.

*	Creating PL/SQL packages, PL/SQL stored procedures and PL/SQL stored functions for implementing database intensive logic as well as for dynamically generating SQL queries.
* Created PL/SQL Object-Oriented Types for Dynamically generating Queries.
* Responsible for Logical and Physical Design of Database using ERWIN
* Assisted in enhancing an ETL process using Java, Perl, Perl DBI, Bourne Shell, SQL PLUS and SQL Loader. This extract program basically takes data from an OLTP environment and populates the DSS at regular intervals. 
*	Was involved in database administration activities like creating table spaces, creating tables, creating indexes, creating synonyms and creating views.
*	Developed Ant scripts for automating tasks and for creating makefiles, which are platform independent. Used Perl for automating report generation. 
*	Familiar with Oracle Financials(GL/AP/PO) schema
*	Transferring balances from GL to Spendcap(Financial Analyzer) and adding dimension values in Spendcap. Transferring exchange rates from GL to Spendcap. Transferring currency, hierarchies ,calendar and segment values from GL to Spendcap. The frequency of transfers is after each accounting period.
*	Developed report definition files (RDF) for presenting data in an intelligent way. Namely Matrix, Tabular and Character Mode Reports. 
*	Used Model 2 architecture for developing web application using struts controller.
*	Creation of velocity macros for developing web user interfaces for the view part.
*	Assisted in developing servlets acting as a controller to display various types of reports. 
*	Developed Java class with static methods as well as singleton class for implementing business logic. 
*	Used CVS for version control.
*	Used  Struts to include a servlet that implements the primary function of mapping a request URI to an Action class

Environment: Oracle 8.1.6, Linux, Windows 2000, Tomcat, Apache, TOAD 6, Reports 6i, Perl 5.6.1, Perl DBI, Oraperl, PL/SQL, SQL Loader, JDBC, JDK 1.3, J2EE, Servlets, Velocity 1.2, Struts, UML, JavaScript, CVS, Oracle 11i(GL), XML, XSL, JAXP, XSLT and Ant 1.5 

CNSI, Maryland  							Sept2001-January2002
Developer/Architect

Project Claims Management System 
 
Description: This project is for automated and enhanced claims processing; financial analysis and processing; administrative and information reports; provider file and other reference information management, integration of the Maine Medicaid Decision Support System, and workflow routing and monitoring.  

* Creating Packages, Stored Procedures, Stored Functions and Database Triggers using PL/SQL for implementing database intensive logic. 
*	Creation of JSPs Web User Interface, creation of servlets acting as a controller, creation of stateless session bean for fetching read only data that is often used by the clients. The architecture used for this web application was MVC.
*	Created stateful session beans for storing the client session related information across method invocations.
*	Used stateful session beans for verifying the provider data as well as the client data.
*	Created Entity Beans for Persisting Provider Information. Used Entity Beans for Persisting Client Information. 
*	Deployed EJBs. Deployed Servlets and JSPs. 
*	Involved in preparing Use Cases, Activity Diagrams, Class Diagrams and Sequence Diagrams. Designing the application architecture
*	Used Front Controller, Business Delegate, Service Locator, Session Facade, Singleton, Page-by-Page Iterator, Proxy and Value ObjectPatterns for designing the provider subsystem

Environment: Oracle 8.1.5 Sun Solaris 2.6 UNIX, ERWIN 3.5.2, TOAD 6, PL/SQL, JDBC, J2EE, EJB 1.1, Servlets 2.2, JSP 1.1, JavaScript, XML, UltraEdit 1.1, Forms 6i, Reports 3.0, Struts, JRun, Rational Rose 2001A, RUP, Rational Clear Case, Web Logic 6.x and Enterprise Manager

 
Trintech Inc, San Mateo CA  						Sep99-Aug 2001
Analyst Programmer.

Project Internet Payment Product
 
Description: This Project is basically creating a product for secure electronic payments. 
*	Involved in the logical and the physical design of the database. Populating the database, exporting and importing data.
* Creation of packages, database triggers, standalone-stored procedures using PL/SQL , java stored procedures for implementing the business logic and database intensive logic.
* Performing Fundamental DBA tasks.
*	Using korn shell scripts to automate tasks. 
*	Creation of screens for administration purpose. These screens where created using Java Swing. Used JDeveloper 3.0 for creating JSP as well as servlets and for debugging servlets. Creation of JSPs Web User Interface and creation of Servlets acting as a controller, and developing a transaction server. The architecture used for the web application was MVC.
*	Creation of stateful session beans for verifying the Credit Card Information and for storing the client Session data across method invocations.
*	Creation of Entity Beans for Persisting Credit Card Information and Customer Information.
*	Created stateless session beans for retrieving read only data sets frequently used by clients. Used stateless session bean for doing generic tasks.
*	Created stateful Session bean to manage the workflow of several other enterprise beans. 
Deployed EJBs. Deployed Servlets and JSPs.
*	Involved with the performance tuning of the database. 
*	Used Visual Source Safe for version control.
*	Used XSLT and XSL for transforming XML Documents to HTML
*	Worked on a merchandising application system(transaction processing)  which is considered by most credit card processors to take place when a request for selling authorization or capture is passed through to them. 
*	Used XML for messaging to authorize the credit cards.
*	Used a stateful session bean and stateless session bean to calculate the total of all the products a customer has picked up. The tax and charges are calculated by a stateless session bean. 


Environment: Oracle 8.1.5 Sun Solaris 2.6 UNIX, Korn Shell Scripting, Perl 4.004, ERWIN 3.5.2, WebLogic 5.1, Designer/2000, TOAD 6, Visual Source Safe, SQL Navigator, iPlanet Web Server 4.1, JDeveloper 3.0,JAD, Dreamweaver 4.0, PL/SQL, JDBC, JAVA, Servlets, JSP, JavaScript, XML, XSL, JAXP, XSLT, EJB, CrystalReports, Borland Inprise Server, OAS PL/SQL Cartridge, DB2 UDB, MQ Series, SOAP, Performance Tuning, HP-UX and Enterprise Manager OEM 


Wells Fargo Bank, San Francisco, CA 				          Aug 99- Sep 99 
Programmer/Analyst

Project Data Mart 
 
Description: This Project is basically creating a data mart for the Private Client Services division PCS of Wells Fargo Bank. 

Involved with the designing the households part of the datamart i.e. both the physical as well as the logical design of the datamart, and migrating the data from the IBM mainframe system to the Oracle Database. This was a part of ETL Process which I was involved in. Created SQL Loader control files. Used server utility SQL *Loader Direct Load, Parallel Option for populating the temporary tables from the flat files. Created packages as well as stored procedures using PL/SQL for further refining the data and for enforcing the business logic. Developed a package, using PL/SQL,  for handing errors.  Used performance diagnostic tools like tkprof and explain plan for SQL Tuning. Involved with memory tuning and I/O tuning 

Environment: Oracle 8.0.5.1 Win NT 4.0, SQL*Loader, PL/SQL, TOAD and Enterprise Manager

Embedded Objects, Fremont, CA						 June99-July99 
Programmer/Analyst
Project Real Time Application for Hand Held Devices 

Designed and developed an Oracle database for a real-time application for Hand Held devices. Linked the front-end Java-based GUI to the database using JDBC - this was done through interfaces: Driver Manager interface, Connection interface, Prepared Statement interface, Statement interface, and ResultSet interface. This application supports DML operations. Created an abstract class in Java to support these DML operations. 
Environment: JBuilder 3, Oracle 8i, JDBC API, Pro *C 



Kaiser Permanente, CT 						March99-May99
Programmer/Analyst

Project Blended Warehouse Load 

Description: Kaiser Permanente is an HMO. This project is basically a Blended Warehouse Load wherein the data is being moved from the production database to the tester database through a staging area. 

Created database triggers, stored procedures, stored functions and packages using PL/SQL for loading the main tables and the reference tables present in the tester database with the data from the production database and the staging area. This was part of the ETL Process. Creation of korn shell scripts for automating tasks. I also performed the migration of Warehouse stored procedures and migration of Warehouse procedures using Synonyms. Furthermore, used performance diagnostic tools like tkproff, SQL Trace to accurately assess the efficiency of SQL statements. 

Environment: Oracle 7.3.5.5.0 64-bit version, Digital UNIX V4.0D, SQL *Plus, Korn Shell Script, PL/SQL, ETL, Impromptu and Oracle Enterprise Manager, ERWIN 3.0 and Designer 2000

NEOSOFTECH PVT LTD. 						MAY 98 - JAN 99
Programmer/Analyst

Project1: Marksoft 
Description: This application automatically generates Marketing Inquiries to customers for targeted products based on information extracted from a database. 

Generation of MIS and statutory reports using Reports 3.0. Creation of interactive and intelligent screens to facilitate data-entry retrieval, creation of database and storage of data. Created applets to display the current prices of the products. Tested the application. 

Environment: Forms 5.0, Reports, Oracle 7.3/8.0, Designer/2000, Oracle, Web Server PL/SQL & Java cartridge, JDK 1.1.5, JDBC Thin, Win NT


Project 2:Statistical Process Control Information System (Client: Annapurna Electronics)
This software package is developed to cater to the requirements of process control Industry to analyze and evaluate, indicate the process parameters.
 
Instrumental in preparation of the Strategy document, SRS, ensuring adherence to the project plan, performing data analysis and system analysis, the above-mentioned task involves defining the major functions, defining the entities, establishing relationship between the entities, function mapping, module categorization, module data usage and module arguments. The data flow diagrams, function hierarchy diagrams and process flow diagrams were prepared. Also, was involved with the data modeling, database design, designing the modules, creation of database roles, assigning the system privileges as well as table privileges to the roles, creation of the menu module, setting the GUI standards, setting coding standards, testing standards, enforcing security through the menu module and above all motivating the team members. 
Environment: Dev/2000, Oracle 7.3, Designer/2000, Windows NT

Project 3: Electromagnetic Designer (Client Electromagnetic Devices) 
Description: Electromagnetic Designer is a scientific application optimized to design layer wound magnetics using cores that have rectangular or circular winding areas. 

Instrumental in preparing the Strategy document, SRS, data analysis and system analysis. This included defining the functions and entities, function mapping and usage, module categorization and data usage. Developed data flow diagrams, function hierarchy diagrams and process flow diagrams. I was also involved with the database design, data modeling, designing the modules, creation of roles, creating stored Program Units(Packages, Procedures and Functions) using PL/SQL, assigning system privileges as well as table privileges to the roles, creation of the menu module, setting GUI, coding and reporting standards, enforcing testing standards and enforcing security through the menu module. 

Environment: Dev/2000, Oracle 7.3, Designer/2000, Windows NT 

Sanghi Spinners India Limited 					NOV 97 - MAY 98
Programmer/Analyst

Project: Management Information System 
Export Information System is a module of an information system developed for use in Export oriented Units. It stores, monitors and retrieves information regarding merchandise to be exported. 

I was involved in the entire project lifecycle i.e. from analysis to implementation. I was instrumental in preparation of the Strategy document, SRS, data and system analysis. This included defining the entities along with the attributes, relationship between the entities, function mapping and usage, module categorization, and drawing the data flow diagrams and the process flow diagrams. I was involved with the designing of the window-style screens and improving the functionality using triggers and preparing the project documentation. This project has been implemented. In addition to this, I was involved with the database design, data modeling, designing the modules, creation of database roles, creating stored Program Units(Packages, Procedures and Functions) using PL/SQL, assigning the system privileges as well as table privileges to the roles, creation of the menu module, setting the GUI standards, setting coding standards, testing standards and enforcing security through the menu module. 

Environment: Dev/2000, Designer/2000 and Oracle 7.3, Win95, PL/SQL, Sco UNIX, Pro*C, Shell Scripting

NEOSOFTECH PVT. LTD 						JULY 97 - OCT 97  
Programmer/Analyst

Project 1: Drakeshire Database System 
Drakeshire Database System is used for construction firms. It automates the maintenance of a group of apartments by a particular renting agency. 

Involved in designing the system. Work involved defining the data objects along with its attributes, establishing relationships between objects and drawing Entity relationship diagrams. 
I was instrumental in creating and populating the database, designing the data entry screens and customizing the application through triggers. 

Project 2: Instruments Information System 
this system keeps track of all the out going instruments, which are serviced, and the incoming instruments, which have to be serviced. 

Involved in the development of Window-style applications, creating standard menus and toolbars, integrating the project with the existing database and writing the user and system documentation. Introduced the concept of updating the context Information and generating the new values from the sequence generator etc in database triggers previously adopted a process of inserting the context information through coding itself. 
Environment: Dev/2000, Designer/2000, Oracle 7.3, PL/SQL, Windows NT and Pro*C

INSTEST  PVT. LTD.							JAN 96 - JUNE 97
Programmer/Analyst

Project 1: Banking 
Development and testing of four of the maintenance forms Customer Master, Account Master, Interest Maintenance, etc. and some of the transactional forms Daily Transaction, Loan sanctions and its related child transaction windows. Wrote database triggers, stored procedures and packages, event handling triggers and local procedures as per the module specifications and common libraries being used in some of the forms. Also involved in the development and testing of the complex reports like break, master detail and matrix reports. 

Project 2: Human Resource Management System 
Involved in the entire lifecycle, i.e., from design stage to implementation stage. Work involved creation of the database, populating the database, designing of data entry screens, views only mode screens and all types of reports related to HR system. 

Environment: Dev/2000, PL/SQL and Oracle 7.3

EDUCATION 
M.S. Electrical Engg.., I.I.T., Madras, India