• Detail-oriented DB Architect and Administrator with expertise in Oracle,Mysql,Mssql, Sybase and IBM Blue IBM's implementation of HBase
• Experienced in ETL tools such as Informatica, Cognos and Business Objects
• Wide exposure to ITIL, Scrum and Agile methodologies

PROFESSIONAL EXPERIENCE

Confidential

Sr. DB Archiect and DBA

Designing and Implementing a data warehousing solution that integrates all university of California campuses and provide a common view for higher management

Tools: Oracle 11G, Mysql 5.x, DB2 9.x, IBM Blue Hbase , Hadoop, J2EE,Informatica, Cognos, Business Objects,

Linux, EMC Clarrion

Confidential

Sr. DB Architect for Verizon's datacenter operations servicing very large multi terabyte financial / retail / Airlines clients such as Gap,Best Buy, Jetblue, Equilend, American Air , Scholastic etc

Tools: Oracle 9.x/10.x/11G, Mysql 5.x, MsSQL 2005/2012, DB2 V9.x, Sybase, Sun Solaris Clusters, Ret Hat linux clusters, Microsoft clusters, Opsware, HP Openview, Sitescope, ATG Dynamo, Web Logic, Retek, SAP, OBIEE, Remedy, Bugzilla,Perforce

• Gathering the requirements from clients to design conceptual and logical data models for oltp as well as olap databases across multiple domains such as retail, airline, finance and education.
• Created checkpoints and automated solutions for many data integration issues
• Designed and Developed ETL solutions for many complex environments using Informatica, Cognos and custom written multi threaded JDBC routines
• Responsible for day to day operational issues in a 24x7 operational environment
• Leading the effort to integrate systems with HP Openview, Sitescope and Remedy to seamlessly monitor them using dashboards to meet very critical SLA's for some customers
• Involved in analyzing the existing infrastructure and designed a new private cloud environment to cater to the needs of small to midsize client base.
• Identifying team's training needs and helping the company to serve customers in a wide variety of technical environments
• Leader in identifying shortfalls in the infrastructure and led the effort in transforming many legacy systems to vmware
• Led the development effort to integrate windows platforms to HP Open View and implementing Microsoft clusters to make sql server env highly available for mission critical DOD clients.
• Migrated many clients from oracle 9i to 10G and Mysql 4.x to 5.x and worked with many vendor partners for pricing and support issues.
• Presented to higher-ups the daily/monthly and yearly data snapshots such as SLA misses , systems availability etc

Confidential

DB and Application Architect for Oracle 9i/DB2 UDB/ SQL Server2000/2005/Sybase/Business Objects/Informatica/EAGLE PACE/Charles River CRD /Weblogic/WebSphere/Tomcat

• Managing a team of 15 dbas as well as application support engineers in
• Equity Trading Dev/Prod Support including performance and data model maintenance,Eagle ETL support for trading warehouse operations in wide variety of databases lncluding IBM DB2 UDB , Oracle 9.x, Sqlserver 2000 and 2005, Sybase, and , Charles River support for Fixed income trading operations .
• Developed a datawarehouse application using EAGLE Pace for all investment products and customized messaging protocol for 24x7 monitoring of trading system

Confidential

Sr Solution Architect for J2EE, Db2UDB6.x/7.x/Mysql 4.x/

• Crystal Reports/Business Objects/WebLogic/Tomcat based Employee Relationship suite ERM , Application Support in Hosted Ops with IBM DB2 .
• Major responsibility is publishing performance benchmarks with product releases, traveling to client site
• for tuning the app in their environments, Created a custom ETL solution to port data from ERP modules to in house product, Applying patches, Perf Tuning of Application Stack using Loadrunner, Jmeter that includes J2EE as well Database layers.

Confidential

Sr Data modeler/ Oracle 8i DBA 24x7 /Oracle forms/Oracle Financials/Weblogic

Supporting Lab tracking system Support Application for Honeywell's aircraft engines.

Confidential

Oracle Applications DBA

This product converts the existing GE legacy application to Oracle Apps

Confidential

Member of Subsystem module involved in development of Powerbuilder and Oracle based milk processing product.This product captures different life cycles involved in Nestle's milk procuring and processing process.I was also involved in development of oracle stored procedures and triggers, PRO C programming, SQL tuning, configuration management using SCCS, quality control and SEI-CMM level3 standards implementation.

Technology Skills

Databases : Oracle 6/7/8i/9i/10g/11g, sql server 7/2000/2005,DB2 UDB 6.x/7.x/8.x/9.x Operating Systems : Linux, Sun Solaris, HP UX, AIX, Windows, DRS-6000

ERP Applications : SAP R3, Oracle Applications, ReTek, JDAS Storage Systems : EMC Clarion CX480, HP XP12000 HDS Modeling Tools : Erwin, Oracle Designer, Visio Development Tools: Toad, Sql Navigator, Oracle Developer, Oracle Application Express,Mysqladmin Other Tools: Oracle Grid Control, Oracle Recovery Manager, Remedy, Control-M, Spotlight, Sitescope, Nagios, Informatica, Hyperion, visual studio c .