SUMMARY:

• Over 18 years of IT experience includes Datawarehouse,Database Design, Data Model, Development, Deployment, Database Administration, Testing, Enhancement, Maintenance, Migration and implementation of large and complex Oracle character & GUI based Client/Server applications and Web - based applications.
• Strong experience in Oracle 7.x/8.x/8i/9i/10G/11G, E-Business Suite, C/C++, SQL, PL/SQL, SQL*Forms 4.5/6.0/6i/10G, SQL*Reports 2.5/3.0/6i/10G, Developer 2000, Oracle Applications EBS, RMAN.
• Strong experience in Datawarehousing using Informatica 7.0/6.5 ETL, Power center, Siebel Analytics, SQL*Loader.
• Good experience with Data modeling, Schema Modeling, Multi-dimensional modeling using ERWIN.
• Experienced in working with business users, business analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
• Develop and document conceptual and logical data models using standard modeling techniques (entity-relationship diagrams) and software.
• Proven experience in project and team leading with zero defect delivery.
• Strong skills in Oracle are SQL*PLUS, PL/SQL especially, back end programming like Packages, Functions, Procedures and Database Triggers as well as writing ksh/bash/csh Shell and PERL scripts. Wrote PERL Scripts for automation of file transfers.
• Experience working with Java/JSP/EJB/Servlets/HTML/DHTML/JavaScript/VBScript/WebLogic/Websphere Server.
• Strong in Data Model & Database/Application Design, performance tuning and Database Administration.
• Experienced with data administration, data management, data integration, data standardization, metadata management and repository implementation techniques.
• Interaction with other technical groups including Oracle DBAs, Unix Administrators, business analysts and product analysts.
• Accountable for analyzing and developing complex logical database designs, logical data models and relational data definitions in support of business applications, data warehouses and data marts.
• Experience providing 24x7 on-call production applications support.
• Other skills include Team Management, Quality Assurance, Software Testing, Business Process Re-engineering, Information Systems Planning Study, and Reverse Engineering etc.

TECHNICAL SKILLS:

Databases: Oracle 7.1.6/8.x/9.x/10G/11G, MySQL, Teradata, Microsoft SQL Server 6.5/7.X/2000, MS Access 97/2000

ERP: Oracle Applications EBS 12.1/11.5.8/11.5.6/10.7.

Languages: PL/SQL, Java, XML, XSL, C/C++, Pro* COBOL, FORTRAN, Basic, Perl 5.x, UNIX. Java Script, VB Script

Data warehouse: Informatica 7.0/6.5 ETL, Powercenter, and Siebel Analytics

Data Modeling: Designer 2000, Erwin 3.x, Rational Rose, Visio, DB Artisan.

Application Server: ATG DYNAMO, Web Logic 8.1/7.0, Web Sphere 4.5/5.1, Apache, Tomcat

Tools: Informatica ETL 6.2/8.x, Developer 2000, Forms 4.5/6.0/6i, Reports 2.5/3.0/6i

Crystal: reports, Visual Basic 6.0, SQL*Plus, SQL*Loader, Erwin, DB Artisan, ER Studio, PL/SQL Developer, SQL Navigator, Toad, Benthic, MS Project, MS-Office 97/2000, RMAN, Composite SW.

Source Control: Visual Source Safe 6.x, PVCS 6.x, CVS and SVN.

O/S: HP-UX 10.20/11.0/11.11, Solaris 2.x, Sun 4.1.x, DG-UX 4.2, AIX 3.x/4.x, Linux, UnixWare/SCO 7.x, Windows 3.1/95/98/2000/ NT

Testing Tools: Win runner, Test Director, Load Runner

OLAP/OLTP: Business Objects, Analysis Services and Informatica, Data Stage.

PROFESSIONAL EXPERIENCE:

Confidential, El Segundo, CA

Sr. Oracle Applications Developer

• Creating Concurrent programs/Executables, registering them under Oracle E-Business Suite.
• Development of various Inventory, Order Management PL/SQL packages and SQL scripts.
• Worked on various TCA tables like HZ PARTIES and HZ CUST ACCOUNTS.
• Worked on various Oracle’s built-in packages, custom packages and tables.
• Developed Order Import Interface for business applications to load header and line details by creating staging tables and perform validations by writing PL-SQL package into the Order Import (OE) headers and line interfaces and then to OE base tables.
• Respond to support tickets (Help Desk tickets and end-user phone calls) in a timely and accurate manner.
• As per the business needs, created and implemented XML/BI Publisher reports for different modules like OM, AP and AR.

Environment: Oracle 11G, Oracle Applications 12.1 E-Business Suite, PL/SQL, Automation (job scheduling), ESP, Data Stage, SQL Developer, Toad, Sun OS, UNIX, Perl, Windows XP, MS SharePoint, Remedy, LiveMeeting, Communicator.

Confidential, Pleasanton, CA

Sr. Database Developer

• Troubleshoot production issues and restore service by resolving customer-facing incidents for .Net business applications.
• Ability to create all types of database objects such as tables, indexes, procedures and triggers to support development of web-based applications.
• Extensively involved in migrating applications from RDBMS to Cassandra (NoSQL).
• Understanding and use of advanced database concepts such as partitioning, parallel operation and analytic queries.
• Worked extensively on stored procedures, PL/SQL packages and Database Triggers.
• Contribute to the implementation and enhancement of Windows application and database systems used by the Loyalty and ecommerce departments.
• Worked on ETL programs to extract data from Source Systems to create reports.
• Contribute to the design and implementation of performance improvements to Linux/Windows application and database systems in support of the Loyalty and ecommerce departments.
• Perform proactive analysis and troubleshooting to predict and prevent production incidents.
• Define and contribute to monitoring capabilities for production Unix/Windows application and Oracle/Teradata/SQL Server systems in support of the Loyalty and ecommerce departments.
• Collaborate with key vendors on functional, performance and capacity improvements.
• Provide 3rd level support for a customer-facing suite of Loyalty and ecommerce solutions that require 24x7 availability, including after-hours and on-call activities.

Environment: Oracle 11G, Teradata, MYSQL, SQL Server 2008, Cassandra, Hive, PL/SQL, Automation (job scheduling), ESP, Data Stage, SQL Developer, Toad, Sun OS, UNIX, Perl, Windows XP, MS SharePoint, Remedy, LiveMeeting, Communicator.

Confidential, FosterCity, CA

Sr. Database Engineer

• Work closely with quality engineering and operations to test and deploy product enhancements and issue resolutions.
• Provide support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN trace analysis, service creation, and cluster and system management.
• Planned and implemented high availability solutions using Oracle 11g RAC, Standby Database using Oracle Data Guard.
• Configuration, upgrade and performance tuning of Oracle RAC, Experience in using OEM, TOAD, and Data Migrations using export/import.
• Troubleshoot production issues and restore service by resolving customer-facing incidents for .Net business applications.
• Provide support for Oracle Enterprise Manager Grid Control and Agents, Experience with writing advanced Korn/bash/C shell scripts.
• Perform proactive analysis and troubleshooting to predict and prevent production incidents.
• Define and contribute to monitoring capabilities for production Unix/Windows application and Oracle/MySQL/SQL Server systems in support of the Loyalty and ecommerce departments.
• Collaborate with key vendors on functional, performance and capacity improvements.
• Design and build tools to automate support and monitoring functions.
• Provide 3rd level support for a customer-facing suite of Loyalty and ecommerce solutions that require 24x7 availability, including after-hours and on-call activities.

Environment:: Oracle 11G/10G, RAC, SQL Server 2008, DB2, PL/SQL, SQL Developer, Toad, LINUX, Perl, Windows XP, SVN, Composite SW, Communicator, Golden Gate.

Confidential, San Leandro, CA

Sr. Oracle Developer

• Worked on ETL programs to extract data from Source Systems to create reports.
• Worked on Creating, Scheduling & refreshing of Materialized Views/ Snapshots.
• Understanding of Wholesale Technology Services processes, methodologies and tools to include Pac2000.
• Promote the developed/tested code to subsequent stage/production environments.
• Understand detailed Wachovia integration business process and analyze data for Oracle Back End Database.
• Used Various Optimizer hints, BIT MAP, ORDERED to tune Complex SQL queries.
• Document the findings from the analysis and understanding of business process into technical design document.
• Working on creating reports using SQL*Plus spooling.
• Created & Scheduled SQL*Loader control files for incoming data transmission.
• Worked on Automation of jobs USING UNIX Shell scripting & Perl.
• Extensively worked on Trouble tickets work (Remedy/Pac2000).
• Worked on creating and scheduling Oracle based applications using Shell and Perl scripts.
• Developed and implemented the coding of Informatica Mappings for the ETL data loading.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Worked on debugging and testing of the application in UNIX and Perl.
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager.
• Performance Tuning of complex SQL queries & PL/SQL Procedures Packages
• Worked on Data propagation from source systems to Destinations.

Environment:: Oracle 11G/10G/9i/8i, SQL Server, PL/SQL, Informatica 8.5, NDM, AutoSys Workload Automation (job scheduling), Toad, Sun OS, UNIX, Perl, Windows XP, MS SharePoint, Remedy, LiveMeeting, Communicator.

Confidential, Oakland, CA

Sr. Database Engineer

• Worked extensively with Oracle Technical support on various Tars.
• Created new databases and users: set up backups, export, and other monitoring scripts.
• Implemented database refresh using full export for table level and full database defragmentation, resulting in improved performance and effective space management.
• Managing database security. Design, develop, and implement automated data backup and restoration procedures. Provide technical support for database maintenance.
• Identify, recommend, and implement all new database technologies and Oracle license management.
• Installed and configured Oracle Enterprise manager on Linux platform.
• Used various Optimizer Hints to speed up the SQL queries.
• Designed ETL programs to extract data and created the reports.
• Monitored memory, CPU utilization, disk utilization (I/O usage), and locks/deadlocks.
• Worked on creating and scheduling Shell and Perl scripts.
• One of the main responsibilities was database Performance tuning using TKPROF, Explain/Plan, utility and also performed Application tuning i.e., SQL, PL/SQL, Maintaining the security of the databases and error correction.
• Extensively worked on SVN version control tool and with Release management team.
• Worked on applying Oracle patches on Production & Adhoc databases using Opatch utility.
• Worked with the team on Oracle database upgrade to 11G.
• Worked on packaging rpms in Linux and used SVN source control.
• Performance Tuning of complex SQL queries
• Worked extensively on PL/SQL Procedures and Packages
• Worked on Data propagation from source systems to Destinations.
• Extensively worked on performance tuning of PL/SQL.
• Worked on call round the clock 24/7 Support model.
• Worked on 3PAR storage, Creating CPGS, Volumes, and LUNS/VLUNS.
• Performed data backup using logical exports/imports.

Environment:: Oracle 11G/10G/9i/8i, OEM, PL/SQL, Linux, Perl, Data Guard, 3Par Storage, Apache, Tomcat, SVN.

Confidential, San Jose

Database Developer

Responsibilities Include:

• Loaded Data from huge Oracle Database tables to Excel spreadsheet Sheets.
• Development of PL/SQL packages and SQL scripts.
• Worked on various TCA tables like HZ PARTIES and HZ CUST ACCOUNTS.
• Created certain Materialized views to get best-optimized results based on TCA tables, which are used in search engine.
• Performance Tuning of SQL queries
• Provided Production Support and handled production-related issues.
• Involved in taking logical backups like Exports and Imports.
• Used various Optimizer Hints to speed up the SQL queries.
• Extracted data from Oracle Applications 11i databases.
• Database Tuning: Instance tuning, Application Tuning, Used parallel query parameters.
• Worked on Oracle Objects, Object Oriented Programming.

Environment:: Oracle 8i/9i, SQL Loader, SQL Server, Dollar Universe, PL/SQL, Shell Scripting, HP UNIX, Java, Windows 2000, Benthic, Toad and SQL Navigator, HTML, Java Script.

Confidential, Newark, CA

Oracle Developer

• One of the main responsibilities was database Performance tuning using TKPROF, Explain/Plan, utility and also performed Application tuning i.e., SQL, PL/SQL, Maintaining the security of the databases and error correction.
• Used various Optimizer Hints to speed up the SQL queries.
• Used SQL Loader to import data from large flat files and Excel sheets to Oracle tables.
• Loaded Data from huge Oracle Database tables to Excel spreadsheet Sheets.
• Understanding Business Requirements and Impact Analysis. Defined the Data requirements.
• Developed Oracle reports using Oracle report builder for real-time applications.
• Created Data base schemas, Data Model, Data Flow, and Database Objects.
• Design and developed data layer.
• Designed Multi-Dimensional abstract Data Model using ERWIN.
• Extracted data from other databases (Oracle).
• Development of PL/SQL packages and SQL scripts.
• Worked extensively on database exports/imports and troubleshooting.
• Facilitate what-if analysis, ad-hoc reporting, portfolio reruns and forecasting.
• Support XML-based valuation transactions.

Environment: Oracle 9i, PL/SQL, Erwin, SQL Loader, Shell Scripting, UNIX, Java, XML, Windows 2000, Toad, SQL Navigator, HTML, and Java Script.

Confidential, Washington D.C

Oracle Developer

Responsibilities:

• Build Enterprise wide Conceptual, Logical and Physical data models and Data Dimensional Modeling using the ERWIN.
• Used various Optimizer Hints to speed up the SQL queries
• Used SQL Loader to import data from large flat files and Excel sheets to Oracle tables.
• Loaded Data from huge Oracle Database tables to Excel spreadsheet Sheets.
• Worked on SQL Enterprise manager and Data Transformation Services.
• Understanding Business Requirements and Impact Analysis. Defined the Data requirements.
• Worked on setting up of OC4J instance on windows Platforms and configured the properties files.
• Developed Oracle reports using Oracle report builder for real time applications.
• Created Data base schemas, Data Model, Data Flow, and Database Objects. Design and developed data layer.
• Designed Multi-Dimensional abstract Data Model using ERWIN.
• Extracted data from other databases (Oracle).
• Development of PL/SQL packages and SQL scripts.
• Worked extensively on database exports/imports and troubleshooting.
• All database transactions are handled through SQLJ programming.
• Facilitate what-if analysis, ad-hoc reporting, portfolio reruns and forecasting.
• All SQLJ files are preprocessed by the Oracle SQLJ translator into Java files, and then compiled into
• Java Classes.
• Provide a single access point for all Confidential valuations
• Support XML-based valuation transactions

Environment:: Oracle 8i/9i, SQL Loader, SQL Server 2000, Oracle 9i, Oracle 9IAS, Embedded OC4J Server, PL/SQL, Shell Scripting, HP UNIX, Windows 2000/2003, Benthic, Toad and SQL Navigator, HTML, Java Script, Crystal Reports, XML, Java J2EE, Web Logic, Web Sphere, Tomcat, Erwin.

Confidential, San Jose, CA

Oracle DBA/Developer

Responsibilities:

• Involved in Re-Engineering of existing applications and preparation of Functional/Technical Design document.
• Worked extensively on Data mapping using Data Junction’s content extractor.
• Developed reports using VB .NET
• Created and modified UI Screens using java Script, VB script & HTML.
• Converted Crystal reports from version 7 to 8 to web enable them.
• Involved in Re-Engineering of existing applications and preparation of Functional/Technical Design document.
• Frequent interactions with user teams for analysis of problems in the existing system.
• Involved in creation of databases, moved databases by recreating control files, export/import, and complete backups. Created and maintained Oracle schema objects like Table spaces, Tables, Rollback segments, Indexes, Sequences and Synonyms.
• Handled database server tuning, application tuning, maintaining documentation, capacity planning and database security.
• Worked on admin console of web sphere and web logic and involved in debugging of the web app written in Java J2EE Platform with Oracle 8i/9i.
• Used SQL Loader to import data from large flat files and Excel sheets to Oracle tables.
• Loaded Data from huge Oracle Database tables to Excel spreadsheet Sheets.
• Installed and configured IBM Web sphere 5.1 and BEA Web logic 8.1 software according to customer needs.
• Involved in creation and maintenance of Oracle Users, Roles and Profiles.
• Developed PERL scripts to interact with Oracle extract data and display these data onto the Internet.
• Developed UNIX shell (ksh) scripts and Perl scripts to automate most of the engineering and testing tasks.
• Performance/query optimization (using TKPROF, Explain Plan, Hints, etc.)
• Created new databases, involving importing and exporting: installing and configured database software for Oracle Application development environment.
• Analyzed database for referential integrity violations and write PL/SQL stored procedures to correct “live” data.
• Interaction with other technical groups including Oracle DBAs, Unix Administrators, business analysts and product analysts.

Environment:: Oracle 7.x/8.x/8i/9i, Data Junction, C++, Java, SQL*Loader, SQL*Plus, Erwin, Toad, Benthic, PL/SQL, SQL, SQL*Trace, ksh, PERL 5.x, JavaScript, HTML, Shell Scripts, Windows NT/9x/2000, Sun Solaris.

Confidential

Oracle DBA/Developer

Responsibilities:

• Design & Development of user interface using Developer/2000 and Designer/2000.
• Design & Development of reports using Reports 3.0.
• Production Support - Retrieving and loading data from banks.
• Created Standby databases (now called as Data Guard) for high data availability.
• Prepared Roles for System User to give security to the system.
• Involved in SQL & PL/SQL programming for stored procedures.
• Wrote PL/SQL procedures, packages, triggers and Oracle Forms (Developer 2000/6i) as required.
• Developed applications using .NET to include ASP.NET, C# or VB.NET.
• Worked extensively on RMAN backup of multiple databases.
• Administered databases and handled large volume of data.
• Developed the whole of Power Monitoring System Online, Batch Programs, and Reports & Graphs using PL/SQL.
• Integration of Custom Applications and database objects as well as Customization and
• Testing and Debugging Oracle Applications and Batch jobs.

Environment:: Oracle 7.x/8.0, RMAN, Standby Database, Designer 2000, Developer 2000 (Forms 4.5, Reports 2.5), Visual Basic.