Project Oracle
Resume:
Savita Chandrawat **** Ohio Drive
Cell: 972-***-****
******.**********@*****.***
Savita Chandrawat
A total of 11 years of work experience in the Software & IT Industry covering entire
spectrum of software development lifecycle with a core focus on Oracle Database
Application Development using PL/SQL, SQL, Pro *C and Database Administration.
Extensive in-depth knowledge and passion for Oracle database design, development,
Database application tuning and Database performance tuning. Working experience of
Oracle database on various platform including Sun Solaris, Linux, & Windows.
Experience in physical construction of tables, indexes, normalization, sizing,
optimization, and tuning.
Have extensive experience in application development using Java and C language with
Oracle/ MS SQL Server/ MS Access database. Have fair knowledge of Server-side Java
development, J2EE Application Architecture, Swing, JDBC, JSP, Web Development,
Object-Oriented Design and Programming, Design Patterns, Spring Framework and
UML design tool. Experience in profiling, analyzing and optimizing the developed
software and employing best practices for design, development, unit testing and test plan
development. Have strong ability to work with technical leaders/stakeholders in
constructing project plan utilizing their insight for defining tasks, scheduling and leading
projects in onsite/offshore model.
Along with sound technical knowledge, also have commendable communication skills
and very good presentation skills. Have contributed multiple documents related to Oracle
database architecture, design and performance tuning which are being used within
Infosys to improve technical skill levels of project team members.
Have Valid Green Card.
Professional Experience in -
: Apache Tomcat, Apache Ant, Visual SourceSafe, CVS,
Development Toolkit
RCS, Vim, Vi, Rational Rose, Visual Interdev, Textpad,
Editplus, Toad, MyEclipse, Visual Explain, Terradata
SQL Assistant, Subversion Version Control System
: HP Performance center
Performance Testing
: ORACLE 8, 8i, 9i & 10G, Oracle Enterprise Manager,
Databases
Oracle Performance pack, Stats pack and other tools used
for Performance Tuning, SQL Developer, PL/SQL
development for Oracle high demand OLTP/reporting
applications. Oracle DDL, DML scripting. Oracle
PL/SQL packages which also include DBMS_*, UTL_*
for performance tuning, Oracles SQL* Loader, Data
Confidential Page 1 of 4
Transfers/Sharing using Flat Files.
MS ACCESS, MS SQL Server, Web Databases, Java
Databases, DB2
: Windows 95/98/NT/2000/XP, Solaris, Linux, AIX
Operating Systems
: Websphere6.1
Application Server
: Oracle PL/SQL, SQL Programming
Programming Languages
UNIX shell scripting: Bash, Korn shell scripting, &
AWK scripts
C Programming: Data Structures implementations in C,
File Handling, memory management,
Java Programming: Socket programming,
Multithreaded Programming, JDBC and RMI
C++, HTML, JavaScript, XML, UML, Fortran 77.
: OMT, UML, OOAD, Data Modeling
Software Engineering
Methodologies/Tools
: Change Management, Client relationship Mgmt, Conflict
General Skill Areas
mgmt, Corporate Etiquette, Cross cultural, customer
orientation, Decision Making, Interpersonal skills, people
Networking, planning & Prioritizing, Problem Solving
and Probing skills
Present Job Responsibilities
Principle – Software Engg Group - Infosys Technologies, TX, USA - Jan 2010 till
date
Worked in Supply Chain project with application technology stack as J2SE 5, J2EE 1.4,
JRE 5. Core Application Framework – JSF, servlet, facelets for Web framework and
Spring for Application framework and Log4J for loogging on Websphere with backend
as DB2 database on mainframe. Main work included SQL tuning, data model updation
and performance testing. Subversion is used for Version control, JMX programming for
TIBCO queues.
Group Leader - Software Engineering Group – Infosys Technologies, TX, USA -
Aug 2006 till Dec 2010
Worked as Group Leader at Infosys, Plano, TX, USA. Job responsibilities include
managing Java & Oracle competency needs and anchoring best practices for design,
development, unit testing and test plan development for various projects. It includes
working with DC heads, Program Managers and Project Managers to ensure appropriate
level of technical competencies in projects. Also responsible for knowledge management,
taking technical discussions with project teams and providing consultancy services for
resolving intricate technical issues related to database management and tuning. Provided
Savita Chandrawat 6400 Ohio Drive
#1325, Plano, TX 75024
Cell: 972-***-****
******.**********@*****.***
support to the project teams working in accounts such as JCPenny, PepsiCo, COAF,
Bank of America, North Western Mutual, Target, Walmart, Texas Instrument, and AT&T
services Inc.
Technical Lead - Software Engineering Group – Infosys Technologies, Bangalore,
India - July 2005 to Aug 2006
As a Technical leader, managed the technology and software engineering group efforts of
organization. The responsibilities included:
a) Manage a team of 11 technical consultants for project planning, task scheduling,
tracking and monitoring deliverables.
b) Design and develop appropriate programs and processes with the project team
members across different SBUs.
c) Design and implementation of Oracle 10g database. The major activities are listed
below:
• Installation of Oracle 10G database on Windows OS
• Data Migration from MS SQL server.
• Analysis of data and usage of Oracle provided tools to find most effective
ways of searching the data repository.
• Maintenance of the Oracle database using Enterprise Manager during the
entire project.
• Porting of solution for Oracle database on Sun Solaris platform. This task
included usage of UNIX shell script programming along with SQL and
PL/SQL programming.
Provided consultancy services to specific projects in Oracle Databases mainly in
the performance tuning area and database queries
Sr. System Analyst, Technology and Software Engineering Group – Infosys
Technologies, Bangalore India – July 2003 to July 2005
As a part of TSE group, build technical competency center on Relational Database
Management Systems, Oracle Architecture, Programming, Performance Tuning, and
Database Administration. This center was involved in executing numerous projects. The
additional competency was build on UNIX shell scripting, C programming, Object
Oriented Concept, Java Programming, Object Oriented Analysis and Design.
The best practices developed on Oracle tuning led to multiple different project
interactions / engagements where I was directly involved in analysis and resolution of
core technical issues related to Oracle databases.
Worked as technical consultant in Schlumberger, USA account for Oracle Database
Confidential Page 3 of 4
performance tuning.
System Analyst, Technology and Software Engineering Group – Infosys
Technologies, Bangalore India – July 1999 to July 2003
As system analyst I was involved in Competency tracking project. Work responsibilities
included design and development of Competency database for keeping records of all the
Infosys employees regarding their technical skills, dynamic updates, effective search and
reporting. This application is in use within Infosys to maintain technical as well as
managerial skill level of each employee till date.
Assistant Professor, Oxford Group Bangalore, India – July 1998 to July1999
Conducted technical sessions in the areas of Relation Database Management Systems
(RDBMS), Computer Architecture, Operating systems, C language, Computer Graphics
and Information Management Systems. Created IT solutions, for the Oxford group’s
business management covering 12 distinct initiatives.
Faculty of Engineering, Department of Computer Science & Engineering – Thapar
Institute of Engineering & Technology, Punjab, India– Aug 1993 to Feb 1998
The job responsibilities included imparting undergraduate education, carrying out
research and providing consultancy services to nearby industries under project IMPACT
sponsored by Department of Electronics, Govt. of India, World Bank and Swiss
Development Corporation.
Educational Qualification:
Bachelor of Engineering (ELECTRONICS ENGINEERING) - July 1992
Master of Engineering (COMPUTER SCIENCE & ENGG.) - April 1998
Professional Courses
Oracle Technology Day
Java 2 Enterprise Edition, JSP, Java Servlet programming
Configuration Management, Time management
Object Oriented Analysis and Design
Integrated Requirements Analysis
Awareness training ISO 14001
Computer Hardware & System Software Concepts
QSD for Projects in Infosys
Technical Report Writing
Contact this candidate