SUMMARY:

• Ten+ years in Database Programming and Database Administration including eight and a half years of extensive experience as a Database Architect involved in design, development, and implementation of ORACLE based DSS and OLTP business systems. Extensive experience in high - performance PL/SQL code development and SQL performance tuning.
• Strong skills in Database development and Data Warehousing. Strong experience with Oracle DBA Concepts and Unix shell scripts. Self starter with ability to work either independently or as part of a team. Proven problem solving abilities.

TECHNICAL SKILLS:

Operating Systems: UNIX, SunOS, Sparc Solaris, IBM AIX), LINUX, Windows NT/XP.

RDBMS: ORACLE 11.2 (SQL, PL/SQL, SQL*Plus)

ORACLE Utilities: SQL*Loader, Export, Import

Database Tools: TOAD, PL/SQL Developer, Tortoise SVN, Oracle DBA,ORACLE Performance Tuning, Partitioining and Indexing. Basic Replication and Bakup and Recovery.

ETL & OLAP Informatica PowerCenter: 9.1.

Languages: PL/SQL, UNIX Shell Scripting, SQL.

Testing Tools: Informatica Data Quality, Informatica Data Explorer, Fitnesse, Data Validator.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Lead Database Engineer

Responsibilities:

• Design the database strategies to design and execute billing. This involves massive usage of PL/SQL, Oracle DBA and learn new NoSQL databases like Cassandra/Hadoop.
• Create PL/SQL scripts to generate daily/weekly/monthly data reports for Accounts team. Use Jira as a task tracker.
• Perform QA using PL/SQL, Unix and other technologies.
• Work on the DBA side by defining indexing/partitioning strategy for the database. Help in replication of required objects.
• Doing massive performance tuning of the existing system.
• Day-to-Day dealing with Java team to design and develop frontend reports.

Confidential, Cupertino

Senior Design Engineer

• Design the security strategies to secure the Apple customer’s data. This involves massive usage of PL/SQL, Oracle DBA and learn new NoSQL databases like Mongodb.
• Create PL/SQL scripts to generate daily data reports for complaince team.
• Migrate all database users to a centralized database using PL/SQL objects.
• Created Charts using Oracle and Java JFreeChart through JDBC connections to Chart the data that exist in the system.

Confidential

Database Architect

• Design the Data Model for the Reference Data and replicate the data from the existing Sybase databases to Oracle database.
• Design PL/SQL scripts and performance tuning scripts to provide data to various consumers.
• Analyze Sybase and PL/SQL differences and implement the same for migration.
• Develop ETL Mappings to load Index Data into the database for the Index data consumers.
• Design Data Access Layer that will fulfil all the Reference Data (Instrument and Issuer) needs of the FIL customers - Charles River Trading Platform. Design Iterative Phases for publishing the data to the Charles River using FILML messages (customized FPML). Data Access Layer was a combined platform of PL/SQL and SQL Scripts and ETL Mappings.
• Analyze the Research Data Requirements for the FIL Research customers and design the ETL Informatica mappings to load the data from Sybase databases to Oracle Staging environments.
• Design the ETL Instrument and Issuer Feeds for the Research application customers.
• Day-to-Day dealing with Business Analysts and Java team to understand and implement the connectivity in backend and front-end.
• Partitcipating in DBA decisions of indexing and partitioiningg databases.

Confidential

Technical Design Lead

• Scoping and Estimation of the Project.
• Design Iterative Phases for the Project.
• Application Design and Oracle and Application DBA.
• Migration of the application from Sybase/MSSQL specific environment to support Oracle, by developing PL/Sql procedures, functions. Performance Tuning of the sql queries.Project Testing and Implementation.

Steria Employee

Senior Database Designer

• Enhancement of the Royal Mail application by developing and tuning PL/Sql packages, procedures and Unix shell scripts.
• Project Testing and Documentation.

Confidential

Technical Lead

• Worked as Application Lead on the Viewpoint system and handled the enhancements and maintenance of the existing application by developing PL/SQL code and performance tuning of the existing applications.
• Maintenance of the Viewpoint application, handling daily batch runs, handling tickets from the users through Clarify Bridge tool.
• Being an Application Lead, responsible for representing the team at daily conference calls.
• Represented the team at the client site, went to Birmingham, UK. Attended crucial client meetings at Bristol, UK.
• Motivated the team to learn new technologies from point of view of the application and automated certain manual tasks.
• Took initiatives to address and handle certain issues, not part of SLA as per discussion with client and the team.
• Took responsibility and handled the replatforming of the application from database version 9i to 10g.
• Received Client appreciation for the efforts put in to solve major and crucial project issues.
• Maintenance of the RM Data mart application, handling daily batch runs, handling tickets from the users through Clarify Bridge tool.
• Took initiatives to handle crucial bridge tickets.
• Doing DBA activities like backup and defining and clearing mountpoints.

Confidential

Systems Analyst

• EDP - Handled In House projects for the organization. Handled enhancement requests from the HR and Finance departments.
• Maintained and enhanced the applications. Developed certain Oracle packages, procedures and triggers.
• Contributed to the enhancement and maintenance of the applications, in agreement with the clients.