I am available now

Sudin Huddar
sudinhu@xxxxxxxxx
402 218 2185
402 218 2179


Career Profile / Summary
· Have 11+years as Developer and 3+ years as Lead and Architect
experience in the IT industry with a focus on system study, design,
development and implementation of Business Applications.
· Have strong experience in handling large volume of data and Data
warehouse.
· Have very strong experience in back end coding.
· Have good exposure to SQL performance tuning and PL/SQL code
optimization.
· Have worked in analysis and tuning of components (jserv, apache,
forms) of Oracle Applications properties.
· Have good exposure to oracle system tables (v$ tables), system
parameters and Statspack.
· Have worked on object level fragmentation and performance analysis.
· Have functional experience in Oracle Projects - Budget and
Forecasting module.
· Have strong experience in Analyze, Development and implementation
of
o Data refresh into multiple database environments.
o Data migration from multiple databases to data ware house.
o Database consolidation.
o Data load from and to Data warehouse
o Data clean, load from large volume of flat files. .
o Data collection and distribution to extranet based applications.
· Have very strong experience in UNIX (Sun Solaris and AIX) Bourne,
Kron and C shell scripting.
· Have worked on PERL for data extraction and cleansing applications.
· Have experience in handling cron jobs, mail servers and daemon in
UNIX.
· Have converted legacy application scripts into more automated way.
· Have experience in handling internet/intranet/extranet systems in
IT projects.
· Have worked on customization of third party ETL applications.
· Have working knowledge of installation and customization of
PeopleSoft's Campaign Generation tool called "Online Marketing".
· Have exposure to healthcare industry data.
· Have exposure to Oracle Workflow to provide solution to business
process management.
· Have a good communication skill, innovative ideas, project design
skill and interpersonal skill, self-starter, continuous learner and can
play a lead role in any project.

Life Cycle Expertise
Data Models, Data warehouse design, Data migration, Data population,
Database consolidation, User Interface Prototypes, Database design,
Systems analysis, Technical, Functional specifications, Unit Test Plan,
Integration, Test Plan, Testing, Impact Analysis, Implementation

Education:
M.S., Computer Applications, St. Joseph's College, Bharathidasan
University, India (1985-88).
B.S., Physics, St. Joseph's College, Bharathidasan University,
India (1982-85).

Technical Skills
Hardware Sun Enterprise E4500/E5500, Sun Ultra 80, IBM and Intel
Pentium based micros.
Operating Systems Unix (Sun Solaris 2.x, IBM AIX 5 ), XENIX (SCO), UNIX
(SCO and AT&T), UnixWare (SCO), Windows 2000, Professional and NT
Scripting Very strong experience in UNIX Shell scripts (Bourne, C and
Korn Shell), Windows NT Batch script, Windows 2000/Professional Batch
script.
Database Languages
Very strong experience in PL/SQL Packages, Stored Procedures,
Functions, Embedded Pl/SQL, Database triggers, Dynamic SQL, SQL Loader,
SQL*Plus, SQL*Plus reports, SQL tuning, PL/SQL Cartridges and
dBase/FoxPlus/FoxPro
Databases ORACLE v9.x, 8.x, 7.x and 6.0, SYBASE 12.5
Application Oracle Projects - Budget and Forecasting module,
Oracle Workflow - Business Process Management Solution.
Programming languages Strong experience in PERL/CGI, working experience
in Java, JavaScript, JSP and HTML.
Packages PeopleSoft Online Marketing and Trilogy Backbone Manager
Database Performance tools Have a good exposure to Statspack packages,
tkprof and SQL tracing
IDE TOAD, Benthick, Go-Global and SQL Navigator


Corporate Affiliations
Since June 2004 Kraftware Inc Database Developer
January 2001 - May 2004 Sun Microsystems Inc, California Senior
Software Engineer
February 2000 - December 2000 Systems Integration Solutions Inc,
California Programmer Analyst/Software Engineer
July 1989 - December 1999 National Informatics Center,
India Principal Systems Analyst



PROJECT EXPERIENCE:

Kraftware Inc (June 2004 to present)
Client: Sun Microsystems Inc, CA (May 2005 to present)
Role: Consultant
Project: Electronic Approval Process
Description:
The tool allows sales team and its manager to create, approve and
process goal sheets electronically.
· Goal sheets have been captured in backend and stored into database
table as CLOB data.
· Goal *** details are sent to front end using REF CURSORS.
· Extensive error handling process has been implemented.
· Served filters have been used to capture the html page at back end
and store into CLOB data.
· Data set have been passed using REF CURSORS and VARRAYs.

Project: Transfer of transactions and email notification.
Description:
This application validates, verifies and transfers data from downstream
system to main system and send notification to the owners of data.
· Invalid emails are filtered out.
· Email validation and verification are configurable.
· Exceptions on UTL_SMTP have been handled properly.
· Results of sending of emails have been logged properly.

Project: EDI Data load and month close process.
Description:
Data from various downstream systems are captured and loaded into local
database.
· Load process takes decision from users while doing month close
process.
· Multiple processing of same script is controlled.
· Error handling is done extensively
· Performances of existing scripts have been improved through
analysis.

Project: Assignment of transactions.
Description:
Transactions from various downstream systems will be captured and
distributed to various resellers based on percentage.
· Search capability has been provided to owner before assigning the
transactions.
· VARRAY , REF CURSORS and Dynamic SQL have been used extensively.
· Query String is built dynamically based on search string. Query has
not been hard coded.

Project: Application Performance tuning
Description:
Poorly behaved applications have been identified and tuned.
· Performed database level tuning.
· Performed query tuning,
· Performed scripts tuning.

Environment for the above projects:
Oracle 9.2.0, 8.1.7, PL/SQL Packages, Functions, Procedures, Dynamic
SQL, Statspack packages, tkprof, Unix Shell scripts, Java Servlets,
JSP, iPlanet web server and Oracle Report Server, Oracle Workflow

Client: Oracle Corporation, CA (November 2004 to April 2005)
Role: Senior Consultant

Project: Database and application monitoring
Description:
To collect database and application related data, set of scripts have
been developed.
· Collect schema changes across databases
· Collection and tuning of SQLs hitting the database.
· Parse SQLs and extract objects to analyze.
· DB, Tablespace and table fragmentation scripts.
Project: Reporting data warehouse
Description:
To collect data from master database and populate into local data
warehouse.
Set of scripts have been developed for
· Refresh data from master database.
· Create and refresh materialized views.
· Build reports using the populated data.
Project: Projects Performance monitoring
Description:
To collect the performance data of database when heavy application
testing running on the system.
This is achieved through reading v$ tables in database and statspack
snapshots.
Set of scripts have been developed for
· Collect performance data from v$ tables and statspack snapshots.
· Identify the duplicate issues and ignore that.
· Identify the issues and open a bug.

Project: Functional level tracing and tuning of Oracle Projects -
Budget and Forecasting module.
Description:
Has performed functional level role on performance analysis and tuning
of Budget and Forecasting module in Oracle Projects. Analyzed and
tuned properties of components of Oracle Applications.

Environment for the above projects:
Oracle 9.2.0, 8.1.7, PL/SQL Packages, Functions, Procedures, Dynamic
SQL, Statspack packages, tkprof, Unix Shell scripts, PERL and Oracle
11i Budget and Forecasting module, Oracle Workflow

Client: Kaiser Permanente, CA (June 2004 to October 2004)
Role : Architect and Developer.
Project: Data refresh in multiple environments.
Description:
When it is planned to refresh data from one environment to another
environment, this set of scripts will do the comparison between source
and target environment, find the delta and push the delta to target
environment. This script has three components as:
· Find delta between environments
· Prepare the report of delta between environments
· Delete the rows from target environment, which are not in source
and prepare report for that.
Achievements:
· Scripts are generic.
· These scripts can be executed both in UNIX and Windows platform.
Wrapper scripts have been written using Unix AIX 5 Bourne shell script
and Windows NT Batch script.
· Exception handling is well maintained at UNIX shell script, NT
Batch script and PL/SQL packages.
· Every operation at OS side and Database side are controlled by
these scripts.
· Scripts do the validation after each run.
· DMLs have been prepared in form of text file for the purpose of
reference.
· Have capability of monitoring execution of the scripts.

Environment for the above projects:
Oracle 9.2.0 ,PL/SQL Packages, Functions, Procedures, Dynamic SQL,
Statspack packages, tkprof, Unix Shell scripts, DOS Batch scripts and
PERL.


Sun Microsystems Inc (January 2001 to May 2004)
Responsibility:
Responsible for the Oracle database application design, development and
implementation of web-based applications used to improve the
productivity of company's sales and marketing team worldwide. Job
duties include system admin activities, data migration, data
population, data loading, data maintenance, developing web services
using web technologies, customizing and integrating readymade packages
for specific internal needs carrying out coding in Java, JDBC, and
servlets; and analyzing and designing large DB applications through
knowledge of Java development, PERL and shell scripting, distributed
application development, networking techniques, Oracle database,
Embedded PL/SQL and JDBC programming.

Project: Database tuning scripts for network timeout (April 2004 -
May 2004)
Role : Lead Architect.
Description:
When the scripts are run from one set of network and communicate to the
database which is another set of network, communication in between
these networks are broken because of firewall setup. This has caused
failure of all the scripts. This project aims at bypassing this network
timeout by spinning a dummy process with some meaningful data in order
to send some false pockets over the network. This helps in keeping the
communication between two sets of network to be alive.
Achievements:
· Scripts are generic.
· Status of scripts is controlled by property file.
· Scripts have been developed to run sequentially.
· Have capability of monitoring execution of the scripts.

Project : DataPopulation Triggers (March 2004)
Role : Lead Architect and Developer
Description:
Data Population triggers will take care of populating data into various
tables after validation when user submits the data *** through URL.
Achievements:
· Triggers have been written to build sqls dynamically whenever the
population needs to be done.
· Overhead of building of dynamic sqls have overcome by having
control table, which decides whether build of dynamic sql is needed, or
not.

Project : Data Migration into Data warehouse (May 2003 - February
2004)
Role : Migration Architect and Developer.
Description:
Extracted data from three different databases, convert data,
manipulate the data and sent to centralized data warehouse. Shell
script has been used extensively to validate the data. The following
are main activities of this migration process.
o Populate the data from different tables.
o Convert the data's date into GMT.
o Convert LONG RAW data into BLOB.
o Validate the data.
o Build flat file using the extracted data.
o Send the data to data warehouse from flat file.
Achievements:
· The entire process has been completed in short duration of down
time.
· Spinning of multiple process and control over every process helped
to complete the migration in estimated time.
· Dynamic sqls have been used extensively to convert LONG RAW data
into BLOB.
· All the scripts have been in generic, which can be reused any time.
· Concept of property file has been introduced in shell scripts to
make the script generic.
· Java has been used extensively for data manipulation.

Project : Leads Management System (April 2003)
Role : Developer
Description:
Data have been archived from data warehouse, cleaned, made flat file
from this data based on some condition, distributed to data warehouse.
Achievements:
· These scripts have been activated by .forward mechanism as soon as
the receipt email from data warehouse.
· Error handling has been handled in an efficient way, so that
failure of one script will not allow another script to start.
· Rerunning of the same bundle of scripts will not create duplicate
records, so that sales team will get only records pertaining to them.
· PERL has been used to create flat file and send email to the sales
team with created flat file.
· All the scripts have been in generic, which can be reused any time.
· Concept of property file has been used in shell scripts to make the
script generic.

Project : Database consolidation (November 2002 - March 2003)
Role : Architect and Developer.
Description:
In PeopleSoft's Online Marketing tool, tables and data grew very
faster. In order to improve the performance, tables have been
consolidated and Meta data information has been updated.
Achievements:
· The entire process has been completed in short duration of down
time.
· Scripts were written in generic fashion.
· Type of report to be generated has been controlled by property
file.
· Dynamic sqls have been used extensively.

Project : Email parser (June 2002-October 2002)
Role : Architect and Developer.
Description:
In PeopleSoft's "Online Marketing" tool, a watchdog checks
whether all the components are running fine or not. This watchdog sends
an email to know whether all the components are working or not.
Sometimes this email could be a false alarm also. This email parser
will parse the incoming emails from watchdog, analyze it and open an
internal service desk ticket if that alarm is true.
Achievements:
· Incoming emails have been read and edited through vi editor in
shell script.
· Required information is retrieved from the edited email.
· Script is activated through .forward mechanism in UNIX environment.

Project : DataLoader (January 2002 - May 2002)
Role : Architect and Developer.
Description:
URL has been designed to facilitate the users to upload the data, which
they collected from trade show, road show for marketing purpose.
Achievements:
· Users' requests are processed in a sequential manner.
· Clear information about the data loaded is sent to users and
development team.
· Certain validations are done at front-end level itself.

Project : UserID conversion as a part of transition (November 2001 -
December 2001)
Role : Developer.
Description:
UserIDs in various columns in tables in several databases have been
changes as a part of sales team transition.
Achievements:
· Changes have been made at the same time in several databases.
· Dynamic SQLS have been used extensively.
· Database names and other Meta data have been read from property
files.

Project : TestDrive Reporting tool (June 2001 - October 2001)
Role : Developer.
Description:
A reporting tool has been developed for internal sales team to convert
the lead into sales.
Achievements:
· Function based index has been introduced to increase the search
performance.
· SQL tuning has been done to increase the performance.

Project : Data mining, cleaning and loading into Data warehouse. (Jan
2001 - May 2001)
Role : Developer.
Description:
A set of scripts has been developed for reading a data from delimited
data file, clean, load and distributes the data to various teams.
Achievements:
· Validation to read the completeness of the file has been done.
· SQLs have been fine tuned to check the validity of data.

Environment for the above projects:
Oracle 9.2.0, 8.1.7, PL/SQL Packages, Functions, Procedures, Dynamic
SQL, Unix Shell scripts, PERL, Java, HTML.JavaScript, iPlanet Web
Server, iPlanet Application Server and Trilogy backbone manager

Systems Integration Solutions, Inc. (February 2000 to December 2000).
Client: iPlanet (Sun Microsystems - Netscape Communication Corp
alliance)
Role : Developer
Responsibility:
Development, maintenance and support for Business Applications of
sales team. Prepared report for sales team. Developed front-end reports
for sales team. Necessary daily support has been given to sales team
on the reports, data loading and other data issues. The job involves
using PERL/CGI scripts, HTML scripts, JavaScript, Java, JSP, UNIX Shell
scripts, Oracle 9.x, and 8.x Pl/SQL, Embedded PL/SQL, Stored
procedures, Functions, SQLPlus reports, SQL Loader, SQL query building
& tuning, table normalization and index & table maintenance for front
end reports.

Project : Leads distribution from cleaned data (July 2000 - December
2000)
Description:
Data from downstream system after cleaning have been distributed to
several sales persons based on various conditions.
Achievements:
· Leads distribution have been made dynamic.
· Progress in every process has been intimated to support team
through email.

Project : Data cleaning, mining and loading from flat file (April 2000
- June 2000).
Description:
Data from the downloaded information have been mined, cleaned and
loaded for reporting purpose.
Achievements:
· Data cleaning has been done using intelligent logic of identifying
invalid names of customers.
· Cleaned data has been verified again by another intelligent process
to avoid the unnecessary drops of valid names.

Environment for the above projects:
Oracle 8i, PL/SQL Packages, Procedures, Functions, PERL, Unix Shell
scripts.

National Informatics Center (July 1989 to December 1999)
Responsibilities:
Involved in study, analysis, design, development, test, implementation
of applications and post production support activities. Designed data
entry screens using Oracle Forms, prepared report using Oracle reports.
Prepared Data Flow Diagram and program specifications

Role : Team leader and Developer.
Project Names:
o Depositors' money monitoring System, Movement of files.
o Prosecution Monitoring System, File Movement System, Default
Monitoring System
o Defective Documents Monitoring System, Computerization of unclaimed
dividends
o Document Registration System, Receipt of Documents, and Name
availability system.
o License Information System, Personnel Information System, Automation
of Food & Civil Supplies Information, Cabinet Meeting Information
System, Grant in Aid Information System, Inner Line Permit Information
System
o Arms License Information System, Power Failure System, Consumer
Ledger System, Inventory Control System

Environment for the above projects:
Oracle 7.x, 6.x. Oracle Forms, Reports, Pro*C, PL/SQL Packages,
Procedures, Functions, Java, HTML, Unix Shell scripts and
dBase/FoxPlus.

Bishop Heber College, Trichirapalli (September 1988 - April 1989).
Title: Programmer cum Lecture
Responsibility:
Developed applications for students and college.
Environment:
DBase, FORTRAN, Pascal and C

.

Loading