************@*****.***
keerti jain Apt # 6,
LA, CA 90007
OBJECTIVE
Seeking software developer position where I can learn new technologies and
apply my skills & work experience.
EDUCATION
B.S. Electronics and Communication, Jaipur Engineering and Research Center,
India (GPA - 3.5) June 2009
Relevant Coursework:
Analysis of Algorithm Software Engineering Database Systems
Programming in C, C++ and Java
Operating Systems Computer Networks Multimedia
Radar and TV Engineering
Optical Communication VHDL Design VLSI Design
Computer Architecture
Microprocessor 8084 and 8086 Digital Communication Microwave
SKILLS
Development Tools: PL/SQL Developer, Informatica(ETL).
Quality Tools: Microsoft Visual Source Safe, SVN
Tortoise
Databases: Relational databases: Oracle 9i,
10g
Programming Languages: C, C++, Java, PLSQL, JSP
WORK EXPERIENCE (3 YEARS)
2010-2012
. Well experienced in writing SQL Queries, Procedures, Packages, Functions,
Triggers, views, Pipelined functions, bulk processing, batch processing,
user defined datatypes and collections using PL/SQL.
. Have done traditional DBA activities such as objects creation, grants,
synonyms and creating jobs etc. Have always been involved in performance
tuning of PL/SQL packages and procedures. Reduced cost of many queries by
applying various hints and changing the age old Database Structure.
. Have done one ETL project using Informatica tool.
. Have prepared many rules for validation purpose and inserted them in
Database using Oracle Forms.
. Was involved in database designing module from beginning.
. Responsible for dealing with the problems, bug fixing and
troubleshooting.
. Designed complete module to send automated mails through jobs from PLSQL
programming.
. Being a lead of a module comprised of 9 team members, has improved my
leadership, management and team skills. Acquired knowledge and experience
in software development life-cycle including requirements gathering,
analysis, design, development, testing and deployment.
. Worked as "Process Improvement Buddy" for all the projects under GESS
(Global Employee Self Services), TCS. Applied Six Sigma to improve the
process of many projects.
PROJECTS
Tata Consultancy Services (TCS), Mumbai, India
1. Employee Travel Project (Global Employee Self Services) [Team Member]
Travel module takes care of all the formalities which should be completed
by TCS employee before going for any travel. It can be either International
Business travel, International Relocation or travel within a country.
Depending on type of travel different approval workflows will be generated
with various approvers. I have designed these approval workflows using
various rules formation.
Solution Environment: Oracle 10g PLSQL Developer, Informatica, Oracle
Forms.
2. Employee Forex (Foreign Exchange) Project (Global Employee Self
Services) [Module Lead]
- Have designed and developed database for Forex module. This system
handles foreign exchange that needs to be given to employees who are going
on deputation along with forex invoicing and settlement processes.
- Have developed interfaces with other modules like payroll and AP systems
to retrieve and post Forex data using Informatica.
- Have been involved in requirement feasibility analysis.
Solution Environment: Oracle 10g PLSQL Developer, Informatica, Oracle
Forms.
ACHIEVEMENTS
. OCA (Oracle Certified Associate) certified with 90%.
. Was appreciated by client for improving the performance of many systems
by tuning the queries.