SUMMARY:

• Over Twenty years of experience in Managing, Architect & Lead Application Design, Development, Implementations across platforms, such as Oracle, Siebel CRM, SAP, ERP R12.2, Integration, Business Object reporting, Project Tracking, ETL
• In - depth experience in Transnational and Decision Support Solutions DSS system design architecture along with a solid technical acumen of web, client/server, ETL, & Data Administration. Proficient in Business Process, Flow Charts, Project Plan & various facets of Information Systems Methodology from Requirements Gathering, Conceptual Design, Gap Analysis.
• Information Technology Leader with extensive experience in delivering a broad variety of Transactional and Decision Support Solutions. Solid Technical Acumen of Relational Databases.
• Goal oriented, Task driven, disciplined decision-maker with a strong sense of accountability. Focused on continuous learning to improve Productivity, Processes and Business Profitability; delivering solutions on time. Proven track record of leadership in many facets of businesses and disciplines, dispersed organizations.
• Proficient in Strategic Planning, Design & Architect. Extensive experience as liaison between Corporate Users and Technical Team. Possess impressive Written and Oral Communication skills.

TECHNICAL SKILLS:

RDBMS: Oracle RAC 11g/12c, MSSQL Netezza 7.1/6.5, MySQL, DB2, data warehousing and data mining

UNIX operating systems: Unix (HP, Sun, AIX), Linux, and Windows, OVM, VM Ware

IT Infrastructure/Storage: NetApp, XIV, Dell Compellent, EMC

Database & Application Security: OVD, OID Active Directory LDAP & OAM

BigData: Hadoop, HBase NoSQL, Hive, PIG, HDFS, Map-Reduce, Zookeeper, YARN, Cloudera

Languages: Java, JavaScript, C++, PL/SQL, C, Perl, Shell Scripts and Batch scripts

Middleware: Oracle Application Server, SOA, WebLogic, Transparent & Procedure Gateway

Enterprise Applications: R12.2.4, Siebel 7.8, SAP R/3, Vantive Oracle Financials, Oracle Express

Misc: PL/SQL, Oracle Forms, Reports, Perl, UNIX Shell Scripting, TSQL, SSIS, SSRS, Erwin, ERStudio, Power Designer, MDM, RMAN, GRID/EM, DataGuard, ASM, OBIEE, GoldenGate, IBM Change Data Capture (CDC), DataStage

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle DBA

• As a database specialist responsible for database support include Oracle, Netezza and MSSQL, including Oracle EBS R12.2.4 and Oracle Retail Databases, 24x7 Production & Application Development support; worked with Microsoft SSIS and SSRS services
• Hands on involved in Oracle Patching and cloning, Monitor, tune and resolve performance issues for Oracle database and applications; Applying patches, mini-packs, family-packs and maintenance packs, upgrades
• Installed and set-up processes for management and up-keep of the databases, setup RMAN repository, Data Guard, LDAP, OID, and unattended monitoring using OEM. Actively involved in RICE (Reports, Interfaces, Conversions, Extensions) builds in Oracle ERP R12.2.
• Leveraged and propagated the usage of Oracle Apex5 in Oracle ERP for various internal initiatives. Build small applications for password resets and user management using Apex and OID
• Involved with BIG Data/DW databases Netezza, Postgres, Hadoop/HBase

Confidential

Lead Database Admin / Data Architect

• Hands on managing and administering Oracle RAC Databases (11g and 12c), Netezza 7.1 and 6.5.
• Manage a team of offshore and on-shore DBA resources for 24x7 support
• Actively involved in Application Architecture and Design;
• Manage and Administer Data infrastructure for GoldenGate, IBM CDC & Datastage, and other Applications & performance KPI initiatives; centralized performance data collection and reporting system; gathering performance key Indicators (PKI) for infrastructure
• Manage Administration, Configuration, Upgrading, Patching & Installation for Oracle and Netezza & Infrastructure Capacity Planning, DR Design and Testing
• Manage ETL processes for data delivery (using Golden Gate, CDC & Datastage) that ensured Data Integration from various sources, actively involved in Corporate Data Collections, Data Mining, Data Management, Consolidation, Transformations and its Delivery/Reporting architecture
• Extensively involved with ER Modeling using Power Designer for the Data Warehouse

Confidential

Sr. System Engineer Specialist

• Manage Oracle & Netezza databases for various business applications such as JDA/ Manugistic, Uptime, Retail Pricing, OMS, MDM, EPS and home grown applications.
• Manage ASM, Data Guard, RAC, RMAN Backup, Recovery, Replication, cloning, Implement unattended monitoring via EM/Grid Control for Oracle, SQL Server, WebLogic /Application Server
• Administration, Configuration, Upgrading, Patching & Installation for Oracle and SQL Server & Infrastructure Capacity Planning, DR Design and Testing
• Architect for centralized performance KPI collection for Databases tuning and database optimization
• Worked extensively in Design and Development of Data Warehouse and Data Integration projects using ETL tool Data stage and Databases like Oracle, MS SQL Server and DB2 and is versed in PL/SQL
• Work with other Infrastructure teams to Troubleshoot Incidents, Coordinate Maintenance work and enforce database best practices
• Extensively involved with Application Architecture Designs, Data Warehouse modeling/mapping and Datastage ETL design and analysis and Reporting (using Cognos),

Confidential

Sr. IT Manager

• Responsible for Applications and Data Management for international as well as domestic businesses covering 21 locations, leading Information Security, Risk Management, Business Process Enablement and smooth transitioning of new businesses
• Managed staff of 14 direct reports and a varying number of contract & indirect resources providing cross-functional expertise, actively involved in Application Development and Database Administrations activities, based on Unix & MS Servers, .Net, Share Point, MS SQL & Oracle, interfaces with SAP. Hands on, technically involved, in architecture and design.
• Ensured and led team so that businesses are certified for PCI/DSS and SAS70 from processes and applications and Data perspective
• Managed SLAs (for Uptime, response time, app. Performances, backups, recovery etc) are met and smooth 24*7 IT operations, leading to great customer satisfaction.
• Established Global Information Delivery applications for internal and external customers, ensured delivery of effective technology solutions to support data integration, business needs and strategies within cost, schedule & scope to ensure effective operational efficiencies and cost reduction within business
• Prepared project briefing and capital request presentations for executive team, & clients
• Actively hands-on involved in corporate data management, consolidation, transformations and its delivery using wide verities of technologies.
• Managed vendor (such as IBM, Wipro, HP, MS, Oracle etc.) relationships to ensure delivery of products & services within published service level agreements

Confidential

Principal Consultant

• Conducted business requirements gathering workshops, Project Scoping, requirements designing, effort estimation, resource estimation, resource planning, expectation management and project management, progress monitoring and reporting. Led development of business processes, process maps and SOPs.
• Business sign-off, on high level design documents, review and sign-off on LLDs
• Conducted CRP - conference room pilot, Sanity testing, ULAB - usability labs with business users
• Identification of business needs, conceptualization of project release strategy, project risk identification and mitigation management.
• Monitored, Controlled and Reported all project milestones and expenditure
• Managed interfaces between National Crime Information Center NCIC and various other CA State and Federal applications
• Established deployment and training strategy, for end users & successful rollout of the application
• Chief Architect for underlying Oracle technologies and expertise