Senior Software Engineer Resume
San Jose, CA
Technical Summary
Oracle Expertise: PL/SQL, SQL*Plus, SQL Loader, Pro*C/C++, Oracle Streams,Export, Oracle Forms, Reports Import, Performance Tuning, Partitioning,backup/recovery, standby database
Web Based Experience: Java, J2EE, Java Servlets, EJB, RMI, HTML, JSP, XML, XSLT, SOAP, JavaScript, MVC Struts, Perl/Cgi,Web/Application Servers: Apache/Tomcat, Weblogic, Java Web Server, Websphere, Apache Axis, IDE: Visual Café, Visual age for Java, Jbuilder
DBMS: Oracle, Informix, ESQLC, JDBC, and ODBC
Client/Server: Powerbuilder, Oracle Forms
Reporting Tools: Crystal Reports, Access
Case Tools: ERWIN, S Designer
Other Utilities: CVS, AutoSys, EDI, ECXpert, Mercator, Make, Ant, Clearcase, Teambuilder
Operating Systems: Unix, Windows, Linux
Languages: Java, C/C++, Perl, Shell, Assembly (x86)
Hardware: Windows, Unix, Hp-ux ,SunOS,AIX
Experience:
Confidential,San Jose CA Feb 2010 Present
Senior Software Engineer
Project : Maintenance and enhancements to M2M Billing and Provisioning system.
- Analysis of requirements, design walkthroughs
- Schema design,
- PLSQL stored procedures/packages, triggers,
- Improving performance,
- wrote scripts to automate table partitioning, monitor table space monitoring, adding datafiles etc.
- Scheduled jobs via shell scripts in Unix CRON
Confidential,San Franscisco CA Sept 2009 Feb 2010
Oracle Developer/Analyst
Project I : Analysis and enhancements to Collections system used by Wells Fargo. My involvement included
- Analysis of requirements
- Design walkthrough including design of new tables, stored procedures , triggers
- Development/Optimization of PL/SQL packages/procedures
Confidential,San Mateo CA Feb 2009 Aug 2009
Oracle Developer/Analyst
Project I : Analysis/Enhancements to USPS system used by business clients
- Analysis of requirements
- Design walkthrough including design of new tables, stored procedures , triggers
- Development/Optimization of PL/SQL packages/procedures
Confidential, Concord, CA Aug 2007 Jan 2009
Oracle Developer/Analyst
Project I : Analysis and enhancements to SOA oriented Business Banking System used by Wells Fargo. My involvement included
- Analysis of requirements from new clients
- Design walkthrough including design of new tables, stored procedures , triggers, materialized views.
- Optimization of slow queries
- Ad-hoc fixes for XML messages, new business rules etc.
- Setup and migration of data into test and regression environments.
Environment: Sunos, Oracle 10g, PL/SQL,Toad, XML, ksh,SOA,Perl,Clearcase
Confidential, Palo Alto, CA Jan 2007- July 2007
Oracle Lead
Project I : Development/Maintenance of HP Portal for business customers. This was an extremely tight project which involved teams from USA and India. I was responsible for the 4 member team in Palo Alto.
- Creation of Data Models for Migrated Database.
- Review and optimization of new/existing ETL processes.
- Optimization of long-running processes
- Storage analysis and allocation
- Online index rebuilds and storage recovery
- 2nd-level support for database application
- Developing batch jobs for loading data into the system
- Backups, exports and imports
- Rebuilt, reorganized and simplified database
- Unix shell scripts to monitor Database
- Database migration Oracle 9.1.x to 10.2.0.1, including (manual) scripting for conversion of all database objects.
- Migrating SQL Server Database into 10.2.0.1 Oracle Database
Environment : Hpux,Oracle 10.2.0.1 RAC, SQL Server, Weblogic, Java, Toad, Streams,Quest Data Modeler,Tidal Enterprise Scheduler,XML,Perl
Confidential, San Francisco, CA Nov 2005-Jan 2007
Oracle Analyst/Developer
Project I: Development/Maintenance of various Financial Database Applications. My involvement included the following:
- Development/Optimization of PL/SQL packages
- Shell scripts for batch processes
- Schedule batch jobs
- ETL from various source systems
- Interfacing and gathering specs from Clients
- Maintenance of existing Collateral/Securities Application
- Interfacing with Clients
Environment: Sunos, Windows Xp,Oracle 10g, PL/SQL, Toad, XML,Powerbuilder,Appworx
Confidential, San Jose, CA Apr 2004-Oct 2005
Developer
Project I: Development/Maintenance of TL9000 application. My involvement included the following:
- Development/Maintenance of PL/SQL packages
- Schema Maintenance
- Optimization of code.
- Analysis for onboarding new products
- ETL to load data into datawarehouse
- Support for application
Environment: Hp-Unix, Windows Xp,Oracle 9i, PL/SQL, Toad,Perl
Confidential,Palo Alto, CA Feb 2004-Mar 2005
Developer
Project I: Development and Maintenance of HP’s discount and pricing database for vendors
- Development of PL/SQL packages.
- Developed/Modified Perl-Cgi/Oraperl scripts.
- Modified Oracle Web-Toolkit Code.
- Cloning Database into new server
- CVS Setup on New Server.
- Wrinting shell/Perl Scripts.
Environment: Hp-Unix, Windows ,Oracle 9i, PL/SQL, Perl, Ksh,Oracle-webtoolkit,Toad