SUMMARY:

• More than fourteen years of experience in total solution management, database architect, data modeling and DBA activities.
• Specialized in Data warehouse.
• Specialized in Shared Service e.g. Oracle RAC, SQL Server clustering.
• Specialized in Disaster Recovery Plan.
• Specialized in disparate industry verticals.
• Specialized in front office, mid office back office applications for trading.
• Specialized in database design, installation, migration, performance and tuning.
• Specialized in setting up the standards and governance.
• Specialized in SOA architecture.
• Unique skill set that includes development, enhancement, implementation, advanced DBA activities, programming and people skills.
• Good knowledge and understanding of both web and client - server applications.
• Excellent team player with experience working in small and large teams.

TECHNICAL SKILLS

Database: Oracle - 11g, 10g, 9iRAC, 9.x, 8.x, 7.x, Microsoft SQL Server - 2008 R2, DB2, Sybase - 12.x

Database Skills: Data warehouse (DW), Master Data Management (MDM), Table Partitioning, Index Partitioning, Performance Tuning.

Operating System: Sun Solaris, Digital UNIX, Hp UNIX, SCO-UNIX, Aix (IBM), Linux

Scripting/Content: Shell script (UNIX), MS-DOS batch, XML

Case Tool/Data modeling tool: Enterprise Architecture, Designer 2000, 6i, Discoverer, InfoSphere

GUI/Tools/ETL: Oracle Data guard (ASM, AWR, ASMM), Oracle Enterprise Manager, DBArtisan, Toad, SQL-Loader, Netbackup (Veritas), SSIS, Informatica.

Clustering: Oracle RAC, Microsoft, Veritas.

Storage: Exadata, EMC, SUN

Messaging Services: Solace router, TIBCO EMS

Middleware: TIBCO BW, Microsoft Integration Server.

Languages: PL/SQL, SQL, T-SQL, Pro-C

Web Application Technologies (Exposure): Oracle Applications Server, Apache Tomcat, ASP, .Net, J2EE, Web Logic, and Web Sphere.

Technologies: Vmware, Log Shipping, Grid Computing.

Source code control tool: Clear case

Process-Tools: Remedy, Revx, Six Sigma, SOX, ITIL Process and CVP

PROFESSIONAL EXPERIENCE

Confidential, CA

Lead Database Architect

Technical Environment: Oracle RAC 11g (ASM,AWR), Grid Control, Data guard, IBM (AIX), TIBCO, J2EE, .Net, MVC framework, SQL Server 2008 R2,EBS, TIBCO,Solace Router, NETAPP Storage, Temenos-T24, Documentum, Infosphere, Erwin

Job Responsibility:

• LED database and data warehouse solution architecture
• Define database standards, data governance and database security standards.
• Define Information architecture.
• Define data warehouse standards
• Define database performance tuning, Optimization guide lines.
• Define & design data modeling
• Define, design, develop and Implementation of Oracle Data Warehouse for trading platform.
• LED SOA architecture

Confidential

Lead database development /Data Architect

Technical Environment: Oracle RAC 11g (ASM, AWR), IBM (AIX), Exadata, TIBCO, J2EE, Infosphere

Job Responsibility:

• LED the database implementation of Credit Initiation System for Citibank to process new applications for secured/unsecured lending products. (APAC,EMEA)
• Define data modeling, database design for the Credit Initiation System.
• Lead end to end database development and data conversion.
• Database performance tuning, Optimization.
• Redefined data architecture and data modeling for Business Intelligent Data Warehouse.
• Analyzed and fine turned ETL process.
• Database performance tuning. Optimized the report run time from 3 hours to 5 min with effective data architecture changes.

Confidential

Data Architect / Senior DBA

Technical Environment: Oracle RAC 10g (ASM, AWR), SQL Server, Java, .Net, MVC framework, Business Object, Informatica, Windows 2003 Server, Sun Solaris, Web Logic, TIBCO, Veritas Clustering, Netbackup, SAN, Log shipping, Oracle Data Guard, Enterprise Architect, Exadata

Responsibilities:

• Defined, developed and managed shared services e.g. ORACLE RAC, SQL shared database (clustered).
• Designed data architecture and data modeling for power trading platform price data warehouse.
• Provided day-to-day DBA support to trading business (front office, mid office, back office applications), risk management.
• Supported application enhancement that included data modeling and change management.
• Performed DBA activities and conducted query optimization.
• Enforced DBA best practices to installation, server setup, backup and recovery, application tuning and performance tuning.
• Defined implementation process, disaster recovery process, and maintenance process.
• Managed disaster recovery drills two times in a year.
• Incident Management.
• Documentation: updated remedy Knowledgebase, support documents, change request implementation documents.

Confidential

BI Solution architecture / Senior DBA

Technical Environment: Oracle, DB2, Java, Windows 2000 Server, IBM AIX, Web Logic, Web Sphere, Tuxido, Perl, Cobol

Job Responsibility:

• Provided solution architect and data architecture to implement enterprise solution in client environments.
• Provided data modeling to BI solution as per client requirements.
• Enforced DBA best practices to installation, server setup, backup and recovery, application tuning and performance tuning.
• Worked on data analysis, data processing and enrichment of data.
• Conducted pre-sales and post-sales for enterprise solutions.

Confidential

Technology Manager/ Solution architecture

Technical Environment: Oracle, SQL Server, Microsoft, Java, Windows 2000 Server, Sun Solaris, Linux, DB2, Sybase

Responsibilities:

• Provided technical solution architecture and data architecture to clients.
• Provide project cost and time estimate
• Responding RFP’s and takes part in pre-sale and post-sale initiatives.
• Designed and implemented an automated data feed process to integrate Hewlett Packard Customer Knowledge Mart.
• Worked on data analysis, data processing and enrichment of data.
• Maintained customer knowledge-base data mart and provided data consultancy to clients.
• Worked on several customer acquisitions and retention initiatives across clients. Some of the versions involved redemption platforms.
• Enforced DBA best practices to installation, server setup, backup and recovery, application tuning and performance tuning.
• Provided maintenance and tuning to production databases.

Confidential

Oracle DBA

Technical Environment: Oracle 8i, Oracle 9iAS, Designer 6i, Developer 6i, J-initiator, Form server, Report server, Windows, Linux

Responsibilities:

• Technical adviser to all clients.
• Performed DBA activities such as installation, server setup, backup and recovery, strategy identification, application and performance tuning.
• Coordinate with clients for new requirements.
• System design and architecture.
• Implementation and user testing.
• Managing and implementing work change requests of deployed systems based on new business requirements.
• Composed maintenance strategies to improve the efficiency and effectiveness of the systems.
• Project monitoring and scheduling
• Managed a team of front-end and back-end specialists.