OBJECTIVE:

Manage, highly challenging IT projects

CORE COMPETENCIES:

Senior DBA on Oracle 12.x and Sybase ASE 15.x, and MS SQL Server 2005/08 for Infrastructure, Applications. Expert Data architect. Consulting Tech. Manager/ Lead Technical Architect for Oracle Utilities applications CC&B 2.5 and WAM 1.8 Applications.

AREA OF EXPERTISE:

DBA - Infrastructure/Application: 15+ years high expertise as a Infrastructure DBA/ Application DBA 12 years expertise in application design and development and managing applications. Expertise as a Senior Oracle DBA for databases (11g, 10g, 9i), Sybase 15.x, 12.5.x. and Oracle EBS 11.5 applications. Locally managed tablespaces, External Tables, Transportable tablespaces, log miner utilities etc. OPS (support), Application Tuning.

Design/Development Tools: 12+ years working on all Fusions 4.0/ ERWIN/Model Mart (ER), Embarcadero DB Artisan, ER/Studio, Oracle Designer 2000, System Architect Design/1, IEF. DIMENSIONAL modeling. Managed the following sectors as Banks, insurance, Trading, pharmaceuticals, telecommunications and Government Utilities. Logical and Physical DB design for VLDB. Application design and reverse Engineering. Architecture and application design of GUI front end applications, Interface and implementation with other Oracle Applications. Worked on application development using complete SDLC.

Data Warehouse: 10+ years in Data Migration/ mapping and transfer of data from MVS and other platforms to Oracle Data Warehouse. DW design, support & performance tuning. Star Schema, ETL using SQL Loader and Informatica, gathering BI, data cleansing, parallel processing. Oracle Warehouse builder(OWB), Oracle Data Integrator (ODI), OBIEE, Brio Query, SAS, Q&E, Business Objects XI, Crystal Reports, COGNOS Power Play, SQL Loader, Partitioning, Kimball DW methodology, star schema, snowflakes, dimensional modeling.

Conversion/Migration: Worked on very large data conversion projects for legacy data, Sybase and UDB to Oracle. Upgraded several Oracle 8i and 9i DB to 10g and 11g.

HA: 5+ years in setup and knowledge of Oracle DATAGUARD (for standby DB), Oracle Streams and Advanced Replication (information sharing), Advanced Queuing. Troubleshooting, Performance Tuning, Oracle Clustering, Materialized Views. RMAN Backup setup, DR & Security implementation, Partitioning, STATSPACK, AWR stats analysis, ASO. Knowledge and setup concepts with Oracle 9i RAC installation and support.

DB Management - OEM, BMC Patrol, DB Artisan, Platinum, TS Reorg, RMAN, SQL Backtrack

Tools: ERwin, Oracle Designer, Oracle Developer, SQL Navigator, Developer 2000, Toad 7.x, SQL LAB Tuner, Model Mart, SQL Station.

Databases: Oracle 7/8/8i/9i/10g,11g, Sybase 15.x, SQL Server 2005/08, Access, dBase.

Applications: Oracle ERP 10.7/11.x, Oracle CC&B & WAM, Oracle 10g OAS

Pharma Appliations : ARGUS, Trackwise, Eclipse, OSI, ADMS

Data Models: ERD, DBMS, Logical/Physical

Platforms: UNIX (AIX/SunOS-Solaris/HPP/AT&T/SCO/Linux), Win-NT/2000

Networks: DBSNMP, SNMP, advanced routing (Cisco, 3Com)

Internet: firewalls, proxies, e-mail (Send mail, GroupWise, Exchange)

Languages: PL/SQL, JavaScript, Unix shell scripts, C/C++, Cobol

Environments: Production, UAT, DEV and DW support.

Other Utilities: Top, vmstat, sar, Glance, PC Anywhere, Veritas & Legato Backup, Remotely Possible, RAID storages, STK Storage, Tuxedo, Visual SourceSafe, AUTOSYS, TNG, Eco Tools, Motif, Omni Back, ftp, Oracle Gateway to DB2/ UDB.

PROFESSIONAL EXPERIENCE

Confidential

SENIOR DBA / Data Architect

Responsibilities:

• Working in the pharmaceutical industry with  confidentil as their primary support DBA to manage their global applications using Oracle, Sybase and SQL Server databases for the production, QA and development databases and support of databases and for the database and applications architectural design and implementation in the production, QA, test and development environments.
• The tasks include development, testing, validation and production support of the highly critical pharmaceutical applications in a FDA regulated environment, implementations of applications, support, troubleshooting and resolving issues in a timely manner.
• Responsible for Oracle 12c, 11g, 10g, Sybase 15.x, SQL Server 2005/08 for the logical / physical database design, implementation, and maintenance on Unix, Linux and Windows NT environments.
• Worked with application teams for the database migrations, creations and implementation of Application changes. Implemented database refresh using Oracle cloning, full export for table level and full database defragmentation, resulting in improved performance and effective space management. Implemented HA using standby databases on clustered environment.
• Managed database security, design, develop, and implement automated data backup and restoration procedures.
• Provided technical support for database maintenance and disaster recovery. Identified, recommend, and implemented all new database technologies and Oracle license management.
• Involved in the SDLC of database development. Worked on database and application architecture for implementation of software applications from needs assessment to Development, QA, TEST and production, design, and support as per Service Level Agreement (SLA) conditions and deadlines for pharmaceutical applications such as confidential
• Supported applications in a PeopleSoft/SAP applications and Medicoder applications. Worked with conversion team to convert XML data for an application ‘datavision’. Worked with Astellas vendors and Oracle, Sybase and SQL server vendors to resolve database issues. Supported reports for development, performance issue resolutions. Currently working on supporting IGD Database applications and working with team of Confidential, Accenture and TCS consultants.
• Environment:, Oracle 12c, 11g & 10g, Sybase 15.x, SQL Server 2005/08/14, UNIX, Linux, Windows 7, Windows 2003, Embarcadero DB Artisan, Toad, OEM, Sybase Central, MS SQL Enterprise Manager 8.

Confidential

Consulting Tech. Manager/CC&B technical Architect

Responsibilities:

• Managed and worked with several Oracle Utility clients for Customer Care and Billing and Work and Asset Management (Oracle CRM/CIS CC&B 2.2 and WAM 1.8 Part of Oracle EBS) projects for Oracle Utility clients, in government sector as a Lead Technical Architect/Senior Oracle DBA.
• Managed several, multi million dollar projects, for Oracle Utility’s Customer Care and Billing and Work and Asset Management (Oracle CRM/CIS Part of Oracle EBS) in government sector on multi tiered architectures and using multiple third party software’s. i.e. Application Server, web server and database server setup.
• Installed, developed and implemented CC&B 2.x using Oracle 10g and 11g DB and 10gAS/ Web Logic/Tomcat on different OS platforms as, UNIX and Linux and Windows 2003 and on 10g RAC environments.
• Managed activities are data architecture (for CC&B and WAM), software design, functional design, sizing and preparation, installation, configuration, conversion, configuration Lab, Package implementation, Web Services, Reports integration using Business Objects/Crystal Reports, Web Self Service (ecommerce/web application), training users, setting up of Security, Audit, Batch, Framework, Extension Tools, and Development and support using tools like Eclipse, development of application and interfaces using java, COBOL and PLSQL and managed the implementation with the Senior Oracle DBA skills.
• Advised and coordinated conversion team for migration of data conversion of several years’ legacy application data to Oracle using Conversion Mapper & SQL*Loader.
• Worked on performance issues and identified and fixed issues for Oracle Utility application and People Soft. Installed and implemented BI with CC&B (in Enterprise Data Warehouse environments, EDW) module.
• Worked on 2 projects for data conversion of large mainframe and COBOLVSAM environment data to Oracle using Oracle DW and ETL tools, OWB, ODI and OBIEE. Install, manage and administering BO XI and Crystal reports with Oracle utility application CC&B.
• Installed and administered Oracle 11g with CC&B application. Used data pump, new features of RMAN. Other technical activities were Capacity planning for customers to evaluate recommend and implement their hardware and software needs for the utility applications considering future manageability for application performance.

Environment: CIS - CC&B and WAM, Oracle 11g,10g, 9i, 10gAS, 10gRAC, OEM,, Toad, Eclipse, SQL Developer, Perl; Java, J2EE, JavaScript, JMS, XML, XSLT, Apache Tomcat, Web Logic 10, C3P0, Hibernate, Version Control, Visio, Partitions, Windows 2003, Linux, AIX, Confidential RS 6000, Sun Solaris, HP, SAN (EMC), MS Office, MS Project, Business Objects, Crystal Enterprise 10, Universe Designer, Oracle Developer, Designer Forms & Reports, MF COBOL, ADDM, AWR, OWB, ODI and OBIEE.

Confidential

SENIOR ORACLE DBA / DATA ARCHITECT:

Responsibilities:

• Managed the project SCON (server Consolidation and Migration) for the International Computer hardware and software innovator as a lead DBA for several databases. It included implementation of HA options, data migration of Oracle 9i to 10g, data moves setting up databases and backup recoveries for corporations Confidential, Confidential, Confidential etc. using Oracle data manipulation tools like SQL*Loader, Export and Import. Managed projects for data conversion/migration of large mainframe DB2 environments data to Oracle of about 20 databases with approximately 500 GB+. These projects were managed by Confidential and the tools used are Oracle ETL tools, OWB. .For performance issues used Automatic Database Diagnostic Monitor (ADDM) from AWR. Used database design tools like ERWIN, SQL Lab.
• In the Chicago based investment giant, managed several Investment banking applications DB’s for web/ecommerce applications as Price Scrubber, HR, Benefits, Investment, Private passport, foreign exchange, securities lending, brokerage and worked with DB management team and developers to make sure the with very high availability production, development, UAT Oracle DB’s, Sybase DB’s and UDB DB’s are up and running for their HA needs and available for about 200 DB’s. Managing development, SIT, UAT and the Production environment supporting all areas like DB performance Oracle DB’s on UNIX, Linux and Windows platforms, shell scripting, DR setup, backups, recovery, logical and physical changes, Oracle DB upgrades, migration and Conversion and advising on coding using PL/SQL, java etc. Managing Oracle HA options, Oracle DB upgrades, migration and Conversion and application development, project implementation for the backup and recoveries. Implemented data guard, advanced replication, Shareplex with a team for HA. Managed several Sybase, SQL Server 2008 and DB2 databases on several performances and tuning projects to effectively resolve issues using DB Admin tools and used PLSQL, T-SQL, isql. Managing and resolving very complex issues for hotline and fire calls for HA DB’s. Administering and managing Remedy (change management BMC) for process workflow management. Implementing, administering, effectively managing and using products like OEM and DB Artisan v8.0.
• In the telecommunications leader for mobile phones and networking devices managed a team of DBA’s, and UNIX administrators for the setup, installations, upgrades and conversions of Oracle 8i, 9i to 10g databases of multiple DB’s about 1 TB. Managed databases which run web/ecommerce applications for test, development, QA and setting up HA production instances using Oracle Data Guard and fail-over systems and advising and helping them for setup of SUN clusters and EMC data storage using SRDF. Managed project on software support and maintenance of Oracle financials 11.5.
• In this International Bank managed the database needs for this application as a Lead primary Sr. Oracle consultant managing and working with team of DBA’s and System Administrators and developers and successfully implemented the Wires project (to Perform and monitor a full range of domestic and international internal money wire transfer and web and ecommerce) and SUMO project and building data warehouse applications from their OLTP to OLAP DB for analysis and reporting purpose using oracle ETL tools. Managed Data Conversion/ data cleansing, mapping and transfer from Confidential legacy data to Oracle Data Warehouses (1 TB. Completed study of the in-house requirements for the data warehouse. Analyzed the DW project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analyzed. Conduct workflow, process diagram and GAP analyses to derive requirements for existing systems enhancements. Prepared the questioners to users and created various templates for dimensions and facts. Created dimensional model based on star schemas and designed them using ERwin. Used ERwin for creating tables using Forward Engineering. Advise and assist with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place. Responsible for identifying and documenting business rules and creating detailed cases. Maintained warehouse metadata, naming standards and warehouse standards. Used SQL and PL/SQL to do queries for analysis purposes. Implemented and managed oracle utilities on projects with Advanced replication using Materialized Views, Streams, Data guard (for standby physical and logical DB), Advanced Queuing. Oracle Clustering, RMAN Backup, Partitioning. Worked with team for Oracle 10g RAC implementation for SUMO project on a two node system, administering, configuration and working on Transparent Application Failover (TAF) and cache fusion. Installed Oracle EBS 11i AP, AR, GL.
• Managed a project for their financial application system reporting as senior data architect and to d esign and develop database for reports, analyze dashboard solutions using BOE XI and Crystal Reports. Created and maintained design universe for this purpose and worked with management and developers to analyze and design and develop reports from DB about 1TB. Installed and maintained BO XI and crystal reports for this project.

Environment: Oracle 10g, 9i, EBusiness 11i, Sybase 12.5, SQL Server 2008, UDB, AWR, ADDM, STATSPACK, RMAN, Partition, SUN, PLSQL, Sun E10K, Sun Clusters, Sun Solaris, RAC, EMC SRDF, UNIX, Application servers, OAS, People Soft, ERWIN/ Model Mart, DB Artisan, ER/Studio, BO XI, Universe Designer, Crystal Enterprise 10, ETL, SQL Loader, 1 TB.

Confidential

SENIOR ORACLE DBA/DATA ARCHITECT

Responsibilities:

• Accomplishments include managing Trading environment with high transactional systems for confidential's as a DW DBA/DA for their Stock and Options DW and surveillance database design and implementation and to prepare meaningful data definitions for meta data management, design of data marts, gathering BI, user interviews, development, QA and implement production DB’s for the various new Oracle DW projects. Used ERWIN 3.5/ All Fusions 4.0/ Model Mart extensively (Forward Engineering and Reverse Engineering and design) for the design and development. Used Star schemas and worked normalization strategies, de-normalized tables to enhance view construction and data retrieval, loaded data and did database structural changes. Used Dimensional modeling, process and governance, data mapping and support & performance tuning. Used Fact tables. Developed ETL’s using SQL Loader. Worked on creating metadata and cleansing of data. Heavy performance tuning for the DW queries to rewrite codes effectively. Worked on Data Migration/ mapping and transfer of trillions of data records from legacy systems to Oracle Data Warehouses in Enterprise Data Warehouse, EDW, using ETL’s and SQL Loader. Developed DW design, support & performance tuning, Star Schema,, SQL Loader for gathering BI, data cleansing and used SQL LAB Tuner and PRECISE on a distributed DW environment. Did capacity planning. Downloaded, did data cleansing and loaded data from MVS into Oracle DB. Managed OS resource monitoring and optimization. The size of the DB was about 500 GB each.
• Managed a project as a Senior Oracle Applications DBA/ Data Architect/ Web Applications DBA Support with the Database Management team working for their ecommerce/Web Applications database design and support. Supported several developers to design, develop, test and implement applications Supported PROD, DEV and UAT in their corporate headquarters which used Java, HTML, Dynamo and using the backend Oracle 8i OLTP databases. Reviewing and modifying the ER diagrams using ER/Studio, Designer 2000, Toad.
• Lead the DB team in the Insurance Giant as a Senior Oracle DBA for the database build of Geo Servers DB Administration, Architecture/ Infrastructure for DBMS group for very large distributed databases. Worked with DBA’s for the Architecture/ Infrastructure and logical and Physical design of Oracle databases including DW instances and develop ETL for DW from the OLTP databases and Creation, setup, patching. Supported the national Oracle hotline, for all Oracle Issues. Worked with a team for the setup and support of BRIO QUERY (OLAP). Managed and used OMWB for conversion and Web Applications database design. Used Embarcadero DB Artisan, ER/Studio for accessing the Sybase and Oracle databases. Used OMWB for the conversion testing. Developed shell scripts to manage database and loading of data and conversion of several Sybase to Oracle DB. Developed applications for the CRM (ITSM) for the tickets management and to track and work on the tickets.
• Managed the application development effort as Senior Oracle DBA/Developer for the maintenance and development of their Medical Sales Administration System and generating analytical reports and the production support. The system consisted of administering sales of the drugs for TAP. Used Q&E and COGNOS POWERPLAY for OLAP Queries. Design and development numerous oracle objects to support the application and using Erwin for new modifications on the system.
• Designed, developed and implemented application as a Senior Oracle Infrastructure DBA/ DA/ Application DBA. Managed a team for the physical and logical design of Oracle 7.1.x very large databases for high availability. This project was to create and manage integrated applications for “long distance telephone calls”. Involved in the design, development and implementation of several applications like Common Database, Data Warehouse, Telephony, Full Service, ALDOS Management, Access Cost Management, Error Correction, Promotion Management, Revenue Assurance using System Architect and Design/1.
• Managed and worked as Application DBA for their Database setup, Physical and logical design Conversion from Sybase to Oracle 7.1. Developed SQL*Loader scripts. Participated and developed Database setup strategy and installed databases and supported applications, i.e. installation of ORACLE and creation of databases. Designed and developed GUI screens, reports and Oracle entities and worked with the development team for Confidential Services for their enhancement of the CIS Application..

Environment: Oracle 9i, ERWIN 3.5,, Data Guard, Materialized views, Embarcadero, ER/Studio, DB Artisan, ETL, SQL Loader, STATSPACK, Partition, RMAN, SUN, HP, AIX 5.1, Web Sphere, Windows, EMC SRDF, HACMP, SQL Server 2005, Sybase 11.x., Designer 2000, Sun Solaris, VAX VMS, Stratus

SR. SYSTEMS ANALYST/ PROGRAMMER

Confidential

Responsibilities:

• Managed and worked as Application developer, Systems Analyst for their Database setup, Physical and logical design of Insurance packages using Oracle and COBOL.
• Managed and worked as Application developer, Systems Analyst for their Database setup, Physical and logical design of Administration software’s using COBOL.

Environment: Unix, Oracle 7.0.x, Oracle Designer, DG Aviion-4625, Windows, IMS, VSAM.