## BIO
PROFILE
\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|
I have over 15+ years of experience in the
information technology industry and proficient
at system analysis,design, development,testing
and implementation on Oracle 9i/8i/8.x with
Developer/2000,Visual Basic 6.0/5.0,
PowerBuilder 6/5.0 under UNIX and Windows NT.
TECHNICAL SKILLS OF EXPERTISE
\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|--
(A)ORACLE TECHNOLOGY VERSION 9I/8I/8.X/7.X/6.0
* PL/SQL, Pro*C, SQL
* Developer/2000 (Forms4.5, Reports2.5)
* DBA Tool TOAD
* Database Tuning and Designing Techniques
(B)MICROSOFT TECHNOLOGY
* Visual Basic 6.0/5.0
(ADO,RDO,ActiveX,Dll's)
* Exposure to .NET Technology
* Active Server Page
* Segate Crystal Reports 8.0/7.0
* ODBC API
(C)POWERSOFT TECHNOLOGY
* PowerBuilder 5.0/4.0
* Sybase (SQL Anywhere)
(D)DATA MODELING TECHNIQUES
* Erwin
* Visio Professional
* ER/Studio
* Rational Tool
(E)ERP (Hands on Experience)
* Oracle Apps 10.7
* PeopleSoft 7.0
(F)OPERATING SYSTEMS
* Unix, Solaris, HP/UX
* Windows 95/NT
WORK EXPERIENCE
\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|
Company: NIS Solutions, VA/USA
Period : Oct’03-Till Date
Role : Systems Analyst
Project: CBRD (Chemical-Biological-Radiological
Defense) is a Fund Tracking
\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|
This system provides the facilities to the End-
user to Track and Operate on funds allocated to
the specific Protective Equipment (IPE)
purchased and delivered by various departments.
Responsibilities involved:
* Preparation of Detail design to explain the
Functional, structural and GUI Requirement for
the Each transaction in Original Excel file
and how this is to be handled in the current
system.
* Migrate EXCEL Spreadsheet data into Access
Database staging Table.
* Preparation of GUI using VB6.0 based on the
requirement.
* Creating a test plan and data for the unit and
integration Testing for the Back-end and GUI
modules.
* Troubleshooting Database and Applications.
Tools: Windows NT, Visual Basic 6.0 (MSDAC 2.x,
ActiveX Control, Dll’s etc..) and AccessDB.
\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|
Company: Megasoft Limited - Chennai, India/USA
Period : May'03-Jun'03
Role : Data Modeler
Project: Megellan is an intranet application
\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|
My Role is to RE-Engineer the existing system
and Integrate the tools into a single megallan
product.
* Preparation of Data Model based on the User
Requirement using ER/Studio
* Prepation of high Level and Low Level Document
using Rational Tool
* Preparation of Database Scripts using TOAD
Tools:
Rational, ER/Studio and Toad.
\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|
Company: Philadelphia Corporation for Aging (PCA)-
PA,USA
Period : Mar'00-Mar'03
Role : Analyst
Project: PCA Reporting Application
\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|
The P.A.S.S (Oracle system)consists of over 20
modules and PCA Reporting is the pivot to the
entire application module. The reporting module
consists of over 350 Reports running on Oracle
Client/Server Environment.
Responsibilities involved:
* Analysis of Existing system, Preparation of
Design specification for the Reports Based on
the user requirements and Translation of Design
Specification to the Oracle Reports Data Model
with the help of Erwin.
* Preparation of Oracle Stored procedures,Functions
in PL/SQL based on the
Reports Requirement.
* Writing a Requirement Document for the New
Reports Modules based on the user
Specifications.
* The Performance tuning of all the Queries used
in the Crystal Reports and Stored procedures
using proper Oracle Indexing and Performance
Tuning techniques.
* Preparation of VB 6.0 forms, Segate Crystal
Reports, Dll's etc.
* Creation of Complex Crystal Reports using
Segate Crystal Reports 7.0 of various types
viz.Standard Reports,Label Reports,SubReports,
CrossTab Reports which uses a temporary table
data populated from the stored procedures
during execution.
* Creation of ASP Pages (PROVIDER INVOICE) using
MS.ADO v.25 control and oracle8.0 as a
[login to view URL] role is to Design and develop an
ASP/Oracle back-end package.
* Integration of Report into the main module.
* Creating a test plan and data for the unit and
integration Testing of Reports and stored
procedures.
* Troubleshooting Database and Applications using
iTAR and Metalink.
* Troubleshooting of Crystal report using
Crystaldecision support link.
Tools:
Windows NT, Oracle 8.x, PL/SQL 8.0.5 (Stored Procedures
& Dynamic), Visual Basic 6.0,and Segate Crystal Report
Professional Edition 7.0. Erwin3.5 and Active Server
page (ASP2.0).
\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|-
Company: PeopleMover Inc, LA-USA
Period : Jan'00-Feb'00
Role : Analyst
Project: PeopleMover HR Application
\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|-
PeopleMover Application is a customized application
for the Human Resource Management.
Responsibilities involved:
* Setting up Staging Tables for data conversion
Process system.
* Converting the Customer Data into Excel CSV
File.
* Analyzing the User Specification and Creating
Control file for the data Upload
throughSQL*Loader.
* Preparation of Stored procedures in PL/SQL
based on the Peoplemover Application to upload
data from a staging Table.
* Testing of converted data in People Mover
Application.
* Writing PL/SQL Stored procedures in Oracle
7.3.x for the PowerBuilder Reports.
* Creating a Powerbuilder GUI for the Reports
using Datawindow and writing scripts.
Tools:
Windows NT, Oracle 7.3.x, PL/SQL (Stored Procedures
& Dynamic).
\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|-
Company: PSINet Inc, LA-USA
Period : Apr'99-Dec'99
Role : Analyst
Project: Enterprise Y2k Compliance Analysis
\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|-
Internet Business Applicati
## Area of Expertise
TECHNICAL SKILLS OF EXPERTISE
\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|\---|--
(A)ORACLE TECHNOLOGY VERSION 9I/8I/8.X/7.X/6.0
* PL/SQL, Pro*C, SQL
* Developer/2000 (Forms4.5, Reports2.5)
* DBA Tool TOAD
* Database Tuning and Designing Techniques
(B)MICROSOFT TECHNOLOGY
* Visual Basic 6.0/5.0
(ADO,RDO,ActiveX,Dll's)
* Exposure to .NET Technology
* Active Server Page
* Segate Crystal Reports 8.0/7.0
* ODBC API
(C)POWERSOFT TECHNOLOGY
* PowerBuilder 5.0/4.0
* Sybase (SQL Anywhere)
(D)DATA MODELING TECHNIQUES
* Erwin
* Visio Professional
* ER/Studio
* Rational Tool
(E)ERP (Hands on Experience)
* Oracle Apps 10.7
* PeopleSoft 7.0
(F)OPERATING SYSTEMS
* Unix, Solaris, HP/UX
* Windows 95/NT
