Sripradha Chakravarthy
E-mail: [Send email using form at bottom]
Phone:  [Send email to request phone number] 80-6673

SUMMARY

	Senior database developer/Admin with 7 years of experience in Oracle
Relational Database Technologies 9i/10g/11g, Oracle E-business suite
applications, MySQL, Teradata, DB2, VLDB, UNIX Shell scripting and PERL
scripting.
	Good understanding of Software Development Life Cycle (SDLC), AGILE,
Scrum, Iterative life cycles in designing, developing and implementing the
software applications starting from requirement definition, system and database
design, coding and production support.
	Expertise in writing PL/SQL stored procedures, functions, packages and
triggers according to business requirements.
	Experienced in resolving sql query, pl/sql performance related issues
using explain plan, TKProf and optimizer hints.
	Good understanding and experience in data modeling, database design,
data loading (SQL *Loader), database migration, data mart and data warehousing
concepts.
	Have good knowledge of ETL tools & methods like designing jobs,
workflows & creating loading scripts.
	Knowledge of various DBA activities like creating databases, users
access, table spaces, logical export/import, DB links, materialized views,
indexes, partitioning, monitoring and job scheduling.
	Good experience in working with various operating systems like Red Hat
Linux, HP-UX, IBM AIX, and Windows 2000 /NT /Server 2003 in 24x7 production and
development environments.
	Good knowledge in UNIX shell scripting, running background processes &
scheduling autosys jobs.
	Strong domain, business and application knowledge in various sectors
like Retail, Enterprise Solution, Telecommunication, Banking and Capital Markets,
Manufacturing Growth and Discrete Technology and Insurance, Health and life
development.
	Good experience in client interfacing skills, giving innovative
solutions & adding value to the business. 
	Quick Learner with good analytical and excellent communication skills.

TECHNICAL EXPERTISE

Operating Systems	MS-DOS, Windows 98/2000/XP/NT/03/VISTA/7, UNIX 5.0/7.0, LINUX
2.6.0,HP-UX 11.x/10.x, AIX 4.3
Languages	C, C++, Oracle SQL 8i/9i/10g/11g, PL/SQL, T-SQL, HTML, XML, VB
6.0/9.0, JSP, UNIX 5.0/7.0 Shell scripting ,LINUX 2.6.0, PERL scripting. 
Database technologies	Oracle 8i/9i/10g/11g (SQL, PL/SQL), Oracle E-business
suite applications, SQL Server 2000/2005/2008, DB2 8.0/9.0/9.5/9.7, Teradata
6.0/7.0/12, MySQL 5.1, Crystal Reports 9.0/10.0/11.0, MS Access 8.0/9.0/10.0/12
Database Tools	TOAD 9.1/9.7, SQL Developer 2.0, SQL*LOADER, SQL*Plus, Oracle
Enterprise Manager, MySQLYog 5.1, MySQL Workbench 5.1, PL/SQL Developer, DB2
Client
GUI Tools	Heat Utility, Comparator, Goose, LPOC, Page Mapper, CAT tool, Valid
values, Business Rules Checker, SDQAudit
Datawarehouse Tools	Informatica, Datastage 6.0/7.5/8.1, Teradata SQL Assistant
6.0/7.0/12
Automated Testing tools	LoadRunner 8.0/8.1/9.5, QuickTest Pro 8.0/9.5, Mercury
quality center 8.0/8.2/9.0/10.0 
Other tools	Erwin 3.5.2/3.x, Microsoft Visio, Visual Source Safe(VSS) 8.0, ANT,
Test Director 7.0/8.0/9.0, Visual Intercept 3.7, Rational Requisite Pro 7.0/7.1,
Rational Clear Case 7.0/7.1, Clear Quest 7.0/7.1, PVCS Tracker 7.1,VPN Client,
Citrix 9.0/10.0/11.0, LPOC Monitoring, FTP Tools, Putty 0.50/0.60, WinSCP,
SecureCRT, Cygwin, Telnet, Tortoise CVS 1.10.10, JIRA 4.0, Remedy 6.0/7.0


PROJECT EXPERIENCE

Operations Support Systems							Jan 2010 – Aug 2010
College Board, USA	     				 Senior database developer/Admin

The project involved understanding the business usecases, designing database
structures, developing sql scripts, timely resolution of the problem tickets,
providing Ontime Window support for NSAT (New scholastic aptitude
test)/PSAT(Preliminary scholastic aptitude test) score release, data loading for
NSAT/PSAT scores and providing technical assistance to the adhoc business
requirements. 

Responsibilities:
	Involved in detailed analysis of the business usecases to get knowledge
of the existing system.
	Engaged with subject matter experts for reviewing business scenarios
and assured technical consistency and stability for the change requests.
	Involved in database modeling for designing the physical schema using
Erwin.
	Developed sql queries, pl/sql stored procedures, functions, packages
and triggers for adhoc business requests.
	Enhanced the physical DB schema by creating and managing tables,
indexes, tablespaces, triggers, db links and privileges.
	Loaded data from different sources into the temp/stage data backup
environments using SQL Loader.
	Involved in monitoring space usage, diagnosing errors & performing
database modifications. 
	Involved in data migration by creating programs to migrate data from
one database to another.
	Performed backup and recovery strategies using RMAN and import & export
tools.
	Created NSAT/PSAT reports from various business utilities like HEAT,
Page Mapper, and Comparator.
	Involved in developing and maintaining UNIX Shell Scripts using Putty.
	Develop XML’s based on the UNIX/MQ Server details for source and
destination path.
	Involved in scheduling batch jobs using UNIX CRON scheduler, Autosys.
	Proactively resolved the trouble tickets with a quick turnaround for
the application maintenance. 
	Used Tortoise CVS for configuration management of the source code and
the documents respectively.
	Interacted with clients regularly and performed maintenance and
production support activities.
Environment & Tools 
Oracle PL/SQL, SQL* Plus, OEM, PERL, UNIX 7.0, TOAD 9.6, LPOC Monitoring, Erwin,
Comparator, HEAT Utility, Page Mapper, Datastage, Mercury, Valid values, Business
Rules Checker, IBM Clearcase rational tools, CAT tool, SDQAudit, WinSCP,
SecureCRT,Cygwin, SQL* Loader, Tortoise CVS 1.10.10

Export Compliance System							Jan 2009 – Dec 2009
Verizon Business, USA				    Senior database developer/Administrator

The project focused on providing sign offs for parties who are eligible for
export and import process for business transactions. The system maintains the
list of parties who are eligible for transactions. Based on the analysis and
acknowledgement from third parties like trade engine and trade collaborator, the
system would approve or reject the orders thereby enabling to take up subsequent
steps to ship them to the respective vendors. 

Responsibilities:
	Involved in conversion of business requirements into functional and
technical specification documents.
	Provided end to end leadership to the offshore team.
	Designed the physical database model using Erwin. 
	Developed sql scripts, pl/sql stored procedures, functions, packages
and triggers using TOAD.
	Involved in data migration by creating programs to migrate data from
one database to another.
	Worked on SQL query optimization and tuning using sql trace, analyze
and explain plan to boost the application performance and providing a quick
defect fix turnaround time.
	Involved in setting up RAC and standby database servers and applying
Oracle patches.
	 Involved in monitoring space usage, diagnosing errors & performing
database modifications. 
	Used ETL tools for extracting, transforming and loading base data from
one system to the other using procedures and tools.
	Involved in developing and maintaining UNIX Shell Scripts using Putty.
	Involved in scheduling oracle jobs using DBMS_JOB, DBMS_SCHEDULER and
batch jobs using UNIX CRON scheduler, Autosys.
	Responsible for preparing test plans; executing the test cases and
providing the test results.
	Used Tortoise CVS for configuration management of the source code and
the documents respectively.
	Tracked and logged defects using Mercury test director.
	Interacted with clients regularly and performed maintenance and
production support activities.
Environment & Tools 
Oracle PL/SQL, SQL* Plus, Oracle 10g Solaris, UNIX 7.0, TOAD 9.1, Visual Source
Safe (VSS) 8.0, Erwin ,Data stage 8.1, FTP tools, Windows Vista, Putty 0.60,
Mercury test director, Tortoise CVS 1.10.10, PVCS 7.1

Seller Portal Market place management							Jan 2007-Dec 2008
Sears Holding Corporation, USA						Senior database developer

The portal system provided sellers a platform to upload and publish their
products online. The seller can sell his products through the web where he can
enter the item details from its name, number, description, size and other
necessary attributes through an excel upload. The details are then entered and
stored in the database for data storage, retrieval and manipulations. It also
enables the administrators to set specific commission and cost per click values
for the products based on certain business rules for each seller.

Responsibilities:
	Involved in requirement analysis process with business analysts.
	Transformed the business requirements into functional/technical
documents.
	Designed relational database schema using Erwin.
	Developed pl/sql stored procedures, functions, packages, triggers and
sql scripts using TOAD.
	Improved query performance by tweaking the join conditions.
	Managed large multi-terabyte instance including partition management of
the backend.
	Involved in data migration by creating programs to migrate data from
one database to another.
	Performed ETL operations and created jobs and workflows using
Datastage.
	Involved in developing Teradata sql scripts, procedures and functions
using Teradata SQL Assistant.
	Develop XML’s based on the UNIX/MQ Server details for source and
destination path.
	Involved in scheduling oracle jobs using DBMS_SCHEDULER and batch jobs
using UNIX CRON scheduler, Autosys.
	Responsible for preparing test plans; executing the test cases and
providing the test results.
	Used VSS & Code base for configuration management of the source code
&documents respectively.
	Used JIRA to log the design defects, bugs or review defects.
	Interacted with clients regularly and performed maintenance and
production support activities.
Environment & Tools 
Oracle PL/SQL, SQL* Plus, UNIX 7.0 , TOAD 9.7, Erwin, Visual Source Safe (VSS)
8.0, Datastage 8.1, FTP tools, Windows Vista,Teradata, MySQL 5.1, Putty 0.60,
Oracle Performance Tuning, SQL* Loader, JIRA 4.0

TOYS’R’US Demand Chain Management and Support				Jul 2005 – Dec 2006
TOYS’R’US Inc, USA						Database Support Engineer
	
The production support project mainly focused on resolving priority tickets,
monitoring the job runs and employing new business functionalities to support
applications as minor enhancements. It also involved in completing the bug fixes
on time for the applications running in the production environment. Using the
tools like Remedy, the issues were tracked and completed on time based on the
priority.


Responsibility
	Prepared the database design, technical design of various sub system
modules.
	Responsible for making enhancements to the physical data model using
Microsoft Visio.
	Involved in developing sql queries, pl/sql stored procedures,
functions, packages and triggers.
	Installed Oracle Enterprise Manager and Intelligent Agent applications
efficiently.
	Developed Teradata sql scripts, procedures and functions using Tera
data SQL assistant.
	Performed tuning and optimization on sql queries using analyze, explain
plan, TKPROF utility and optimizer hints.
	Utilized SQL*Loader to load data from flat files into database.
	Develop XML’s based on the UNIX/MQ Server details for source and
destination path.
	Involved in scheduling oracle jobs using DBMS_SCHEDULER and batch jobs
using UNIX CRON scheduler, Autosys.
	Used Remedy to log the design defects, bugs or review defects.
	Interacted with clients regularly and performed maintenance and
production support activities.
Environment & Tools
Oracle PL/SQL, SQL* Loader, UNIX 7.0, Putty 0.60, Teradata, Visual Source Safe
(VSS) 8.0, Datastage 8.1, FTP tools, TOAD 9.7, Windows 2007, Visio, Remedy 7.0

SONY Online Transaction processing						          Jun 2004 – Jun 2005
Sony Corporation							    Database Application developer

SONY Online Transaction processing project involved in making upgrades to the
Oracle components (Forms and reports). The projects focused on analyzing the
impact due to the upgrade and involved making the changes to various oracle
components as required ensuring compatibility to be present from functionality
perspective after the version migration.

Responsibility
	Thoroughly studied the applications running in the earlier environment
and performed rigorous analysis of the impact occurring due to the new version
changes.
	Engaged team members with subject matter expert for reviewing business
scenarios and ensure the development consistency for change request.
	Developed data model for the new table structure and database system
using Visio.
	Preparation of Impact Analysis documents.
	Designed data mart components like star schema, dimensional model and
performed OLAP documentation.
	Developed Oracle Forms 6i and Reports 6i per business requirements. 
	Involved extensively in modifying database tables, procedures,
functions, packages and triggers.
	Worked on sql query optimization and tuning using sql trace, analyze
and explain plan to boost the application performance.
	Developed UNIX Interfaces and shell scripts using Putty.
	Performed an independent unit testing of the entire application.
	Used Remedy to log the design defects, bugs or review defects.
	Interacted with clients regularly and performed maintenance and
production support activities.
Environment & Tools
Oracle Applications E-business suite (Forms and Reports) 10g, PL/SQL, Putty
0.60, SQL* Plus, Oracle Forms 6i, Oracle Reports 6i, UNIX Interfaces,TOAD 9.7,
Visio, Visual Source Safe (VSS) 8.0, FTP tools, Remedy 7.0, Windows 2007

EDUCATION 

Master of Business Administration, Anna University, India.
Bachelor of Engineering, Anna University, India.