Rajeev Kumar

Send Email to Rajeev Kumar
for downloading Resume in word format, right click here and save target as or save link as
 
SUMMARY
I have over 12 years of experience as Database Architect, System Architect, OOM/OOAD, System Analyst, Data Architect, Data Modeler, SDLC, Project Lead and Project Management, Erwin for e-Commerce, web site design, client/server applications, re-engineering systems with over 9 years experience in the Oracle environment.
 
EDUCATION
Masters Degree in Computer Science
 
SKILLS
Project
Management		 Managed teams of up to 8 persons in various situations, handled the client contact for the team, technical leader for the team and handled the projects from requirement study to implementation of the systems.
 
Web Design Created web sites for large insurance corporation, e-commerce sites for the company to sell their products through web. I'm familiar with some web technologies including Broadvision, Java, JavaScript, CGI, HTTP, HTML 3.0/4.0.
 
Software
Development 		Requirement study, analysis, data-modeling, design and development (including client/server development and web system design) using oracle, also worked as oracle DBA and also worked in re-engineering of systems.
 
Internet Broadvision One-to-One 5.0/4.1, Java, JavaScript, WWW, HTTP, HTML, CGI, Oracle Application Server 3.0/4.0
 
Languages Developer 2000(Forms 4.5, Reports 2.5, Procedure Builder1.5), PL/SQL, SQL*Plus, Pro*C, C, SQL*Forms 3.0/2.3, Shell Scripting, Awk, COBOL/400, RPG/400, SQL/400, CL/400, MF-COBOL
 
OS/Environments AIX, Sun-Solaris, IRIX, DG-Unix, HP-UX, OS/400, Windows NT, Windows 95, VMS, DOS
 
Databases Oracle 8i/8/7/6
 
Hardware Sun, Digital Alpha, RS/6000, HP, IBM SP2, DG Aviion, Silicon Graphics, AS/400, PC, Vax
 
Case Tools Erwin, Turbo Analyst, Designer 2000, Familiar with Rational Rose
 
Business Areas
  • Health-care
  • Insurance
  • Finance
  • Inventory
  • Loan Accounting (Banking)
  • Management Accounting/Information System
  • Personnel Management
  • Materials Requirement Planning (MRP)
EXPERIENCE
 
Aug, 00 onwards Computer Science Corporation, Philadelphia, PA
As a Technical Lead / Senior Database architect, involved in requirement study, analysis, design, system architect, database design, for development of web-site for Children's Hospital of Philadelphia, a pediatric healthcare network. The site provides the online health information on various medical conditions and resources.
 
Responsibilities included:
  • Requirement Study with various users, departments of CHOP,
  • Scoped the business functionality to be included in phase one,
  • Database Architecture/modeling,
  • Database design
  • Configured Sun Solaris E4500 boxes for Broadvision and Oracle 8.1.6
  • Installated and configured Oracle 8.1.6 on Solaris E4500,
  • Installed and configured Netscape Enterprise Server,
  • Installed and configured Broadvision 5.0, Publishing Center, Instant Publisher, Knowledge, Corba Services, Interaction Manager on 2 Sun Solaris E4500 servers,
  • Technical lead for JSP and guided JSP programmers
Environment: Oracle 8.1.6, Erwin, Broadvision One-to-One 5.0, Sun Solaris E4500, Windows, Java Script Pages, HTML
 
Apr, 00 - Jul, 00 HP Consulting/Transys Corp., Princeton, NJ
As a Senior Database / Broadvision Architect, facilitated the requirement workshop, involved in requirement analysis, design, system architect, database design, Broadvision admin for development of e-commerce site for whatzNew.com, an information resource and online store for all IT related products such as computers, software, network products.
 
Responsibilities included:
  • Facilitated the complete requirement workshop,
  • Scoped the business process to be included in phases,
  • Created the business process,
  • Database Architecture/modeling,
  • Broadvision database design
  • Supervised the Installation of Oracle 8.0.6, Netscape Enterprise Server, Broadvision 5.0, Corba Services, Interaction Manager on 2 HP/UX L servers,
Environment:  Broadvision One-to-One 5.0/4.1, HP-UX, Windows NT, Oracle 8.0.6, Erwin, Java Script Pages, HTML
 
Nov, 99 to Mar, 00 Zefer Corp, New York
As a Database / Broadvision Architect, worked in development of e-commerce site for Entotal.com, which is an information resource and online store for all telco products such as long distance service, local service, wireless phones and service, pagers and accessories and also provides the service to pay all the bills online at one place.
 
Responsibilities included:
  • System design and defining the business processes,
  • Broadvision Installation and Maintenance,
  • Database Architecture/modeling,
  • Broadvision database design,
  • Database Installation,
  • Creation of database/stored procedures,
  • Writing Java Script Pages
Environment:  Broadvision One-to-One 4.1 Application Server, Sun Solaris, Windows NT, Oracle 8/8i, Erwin, Java Script Pages, HTML, PL/SQL, Sql*Plus, Stored Procedures, Packages
 
Apr, 99 - Oct, 99 Solbright.com, New York
As a Database Architect, involved in the database architecture, modeling, design and creation of database (also using object types, object tables (Object-Relational concepts) of Oracle) for automating Internet advertising over web.
 
Responsibilities includd:
  • Object oriented analysis and design,
  • Requirement study & analysis,
  • Database Architecture/modeling,
  • Database Design using Objects types, object tables
  • Creation of database/stored procedures,
  • Database installation
Environment:  Sun Solaris, Windows NT, Oracle 8/8i, Erwin, Rational Rose, Java, JDBC, HTML, Java Script, PL/SQL, Sql*Plus, Stored Procedures & Packages
 
Oct, 98 - Apr, 99 American International Group (AIG), New York
As a Consultant, involved in the database architecture, modeling and development of oracle database for e-commerce projects (web sites).
 
Responsibilities included:
  • Requirement study & analysis,
  • Database Architecture/modeling,
  • Database Design,
  • Creation of database/Stored Procedures/Packages,
Environment:  Sun Solaris, Windows NT, Erwin, Oracle Application Server 3.0/4.0, Java, HTML, Java Script, Pl/Sql, Sql*Plus
 
Jun, 96 - Sep, 98 The Hartford Insurance Group (HIG), CT
As a Consultant, involved in the following projects for The Hartford Insurance Group (HIG):
  • Technical Project Lead for Re-engineering Champs (Auto letter creation) system into client/server environment from character based.
  • Analysis, Design, Data Modeling and Development of Quality Management system and Employee Information System.
  • Analysis, Design and Development of Loss Control system.
  • Analysis, Design and prototype development of MIS system.
  • Development, Unit & System Testing of Claim Service system.
Responsibilities included:
  • Requirement study & analysis (interacting with users to understand system requirements),
  • System design,
  • DBA activities
    • Data modelling
    • Creation of database
    • Creation and maintenance of Oracle schema objects like tablespaces, tables, indexes, sequences and synonyms
    • Creation and maintenance of stored procedures and database triggers
    • Fine tuning of the database using explain plan
    • Creation and maintenance of Oracle users, roles
Environment:  Digital Alpha, DG-UX, VAX, Sun Solaris, Windows 95/NT, Developer 2000, Erwin, Pl/Sql, Sql*Plus, MF-cobol, Pro*cobol
 
Aug, 95 - May, 96 Income Tax Department of India
Involved in requirement analysis, design, data modeling, specs writing, system testing and implementation of Individual Running Ledger Account (IRLA) System for Income Tax Dept of India as a module leader (System Analyst).
 
Responsibilities included:
  • System design,
  • System testing,
  • Implementation,
  • DBA activities
    • Data modelling
    • Creation of database
    • Creation and maintenance of Oracle schema objects like tablespaces, tables, indexes, sequences and synonyms
    • Creation and maintenance of stored procedures and database triggers
    • Fine tuning of the database using explain plan
    • Creation and maintenance of Oracle users, roles
Environment:  RS6000, AIX, Windows 95, Oracle 7.1, Forms 4.5, Reports 2.5, Pl/Sql, Sql*Plus
 
Nov, 94 - Jul, 95 P&O Containers Ltd, UK
Involved in the enhancement analysis, design, specs writing, development and system testing of Finance module of Documentation and Revenue System (DRS) for P&O containers Ltd as a Systems Analyst & Programmer.
 
Responsibilities included:
  • Enhancement analysis and design,
  • Development,
  • System testing,
  • Implementation,
Environment:  IBM SP2, AIX, AS/400, OS/400, Windows 3.1, Oracle 7.0, Forms 4.0, Pl/Sql, Sql*Plus
 
Jul, 94 - Oct, 94 Tata Iron & Steel Company, India
Involved in review from AS/400 perspective of MIS & Planning System for TISCO, India as an AS/400 consultant.
 
Responsibilities included:
  • System design,
  • System testing,
  • Quality Assurance
  • Implementation,
Environment:  AS/400, Cobol/400, Sql/400, Cl/400
 
Oct, 93 - Jun, 94 Tata Exports, India
As a System Analyst, involved in the System Study, Analysis and Design of Raw Material Inventory, Production Planning & Control and Finished Goods Warehouse module.
 
Responsibilities included:
  • Requirement study & analysis (interacting with users to understand system requirements),
  • System design,
  • DBA activities
    • Data modelling
    • Creation of database
    • Creation and maintenance of Oracle schema objects like tablespaces, tables, indexes, sequences and synonyms
    • Creation and maintenance of stored procedures and database triggers
Environment:  SGI, IRIX, Turbo Analyst (Case Tool), Oracle 6.0, Forms 3.0, Pl/Sql, Pro*C
 
Mar, 93 - Sep, 93 Hamdard, India
Development, system testing and implementation of Bill of Material (BOM) and Inventory for Hamdard, India as a team member.
 
Responsibilities included:
  • Development,
  • System testing,
  • Implementation,
Environment:  HP, HP-UX, Oracle 6.0, Forms 2.3, Pro*C, Shell Programming
 
Aug, 92 - Jan, 93 Mahanagar Telephone Nigam Ltd. India
Involved in reengineering of Telephone Revenue Billing System and Design of Financial Accounting Module for MTNL, India as a project leader.
 
Responsibilities included:
  • Requirement study & analysis (interacting with users to understand the system),
  • Development of tools for conversion,
  • System design,
  • System conversion,
  • System testing,
  • Implementation,
Environment:  DG Aviion, DG-UX 5.4.1, RM-COBOL, C, C-Shell Programming, Awk
 
Jul, 91 - Jul, 92 Fidelity Investment, UK
Involved in the design, development and system testing of Integrated Customer Database System for Fidelity Investment, UK as system analyst & programmer.
 
Responsibilities included:
  • Development,
  • System testing,
Environment:  AS/400, OS/400, RPG/400, SQL/400, CL/400
 
Sep, 90 - Jun, 91 Continental Insurance, USA
Involved in the development and system testing of Producer Billing System for Continental Insurance Inc., USA as a programmer.
Environment:  AS/400, OS/400, RPG/400, SQL/400, CL/400
 
Mar, 90 - Aug, 90 Maruti Udyog Ltd., India
Involved in the requirement study, analysis and design of Production, Planning & Control and Inventory modules for Maruti Udyog Ltd., India as team member.
 
Responsibilities included:
  • Requirement study & analysis (interacting with users to understand system requirements),
  • System design
 
Oct, 89 - Feb, 90 Indian Institute of Technology, India
As a Analyst, involved in the study, analysis and design of Personel Management system for Indian Institute of Technology, India as an analyst.
 
Responsibilities included:
  • Requirement study & analysis (interacting with users to understand system requirements),
  • System design
 
Jul, 88 - Sep, 89 Citibank, India
Involved in the analysis, design and development of Loan system for CITIBANK, India as a Project leader.
Environment:  Oracle, Forms 2.0, Pro*C
 
COURSES CONDUCTED
YEAR TITLE LOCATION ORGANISED BY
1994 UNIX New Delhi TCS
1994 SSAD New Delhi TCS
 
COURSES ATTENDED
YEAR TITLE LOCATION ORGANISED BY
1998 ABAP/4 Edison, NJ SOFTEC
1997 Intro to Oracle Manufacturing Boston, MA ORACLE
1997 Oracle Planning Products Boston, MA ORACLE
1989 SSAD New Delhi TCS
1990 Oracle New Delhi TCS
1990 QA & Productivity Tools New Delhi TCS
1990 DBMS New Delhi TCS
1991 AS/400 New Delhi TCS
1992 Oracle Forms 3.0 New Delhi TCS
1994 GUI New Delhi TCS
1995 Visual Basic 3.0 London P&O
1995 OOM (Rambaugh’s) New Delhi TCS
 

Send Email to Rajeev Kumar

for downloading Resume in word format, right click here and save target as or save link as