SUMMARY:

• A seasoned IT professional with 24 years of total experience as Developer, DBA, Data Modeler and Architect and specialization in leading various projects of Business Intelligence, Database and Application analysis, architecture/design, modeling, development, administration, maintenance, and performance optimization with proven records of successful implementations across multiple platforms and technologies like Oracle, Microsoft SQL Server, MySQL, Sybase, Informix, DB2, Oracle ERP, SAP, Siebel/OBIEE, J2EE.
• Data Center Migrations, Cross data center and cross platform database and application migrations, data migrations across heterogeneous platforms of Microsoft SQL Server, Oracle, Sybase, MySQL.
• Responsible for installation, migration and upgrade of the database, creation and management of database objects, design and implementation of security policies and procedures, enterprise wise database monitoring and maintenance, design and implementation of backup and restore mechanism, DataGuard / standby server and database, implementation of fallback procedure, flash recovery, export/import of data, configuring RAC (Real Application Clusters) / parallel server and advanced replication, database/application tuning, troubleshooting database, resource / capacity planning and provisioning, Data replication using Oracle Stream, Data Guard, Golden Gate.
• Scheduling and maintenance of jobs using Cron, Autosys, SQL / Oracle Scheduler, evaluation of dependencies among jobs and rescheduling for optimal performance.
• 10 years of experience in Business Intelligence architecture, Data Warehouse architecture & development with responsibility to design, develop and implement the star and snowflake schema for the enterprise wise data warehouse using Oracle Warehouse Builder, OLAP Master Data Management (MDM) SQL Server SSAS, SSIS, SSRS, BIDS, SSMS.
• Demonstrated knowledge of data warehouse implementation process, from business requirements through logical modeling, physical database design, data sourcing and data transformation, data loading, SQL, end - user tools, database technology in application development environments.
• Influence the development of the corporate database strategy in conjunction with the Database Architect. In particular, assist with development and maintenance of the technical architecture framework for data warehouse/data marts.
• Conduct data modeling and database design to establish databases (including transactional systems and data warehouse/data marts) which meet business needs in a cost-effective manner and conforming to the technical architecture framework.
• Evaluating and testing DB administrative tools, developing specs and project plans for design, maintenance and enhancements of database systems, monitoring and analyzing DB statistics to maintain DB performance levels, implementing tuning strategies on production DB’s and developing Data Flow plans / statistical / status reports as required.
• Worked with various security compliances like, SOX, PCI, HIPPA

TECHNICAL SKILLS

Big data: Slight exposure to Hadoop & Big Data. Still Exploring the details.

Database: Oracle 11g, 10g, 9i, RAC, 8i/8/7/6, SQL Server 2008/2005/2000/7 , Sybase, Mysql, Informix, Access, Db2 9.5, SAP db6 Cockpit

ERP: Oracle 11i/R12, SAP ECC6

OLAP & BI Tools: Oracle Discoverer (Admin, User, Web), Oracle Warehouse Builder, EDW Informatica, Siebel/OBIE, Retek RMS/RDW; BIDS, SSAS, SSMS, SSIS, SSRS, MDX,DMX, Tibco SpotFire

Clustering: Oracle 11gR2/10g/9i RAC, Oracle Fail-Safe, MS/SQL Clustering

Oracle Management: ONT, OE, INV, MPR, etc.

Tools: TOAD, SQL Navigator, Power Designer, Oracle Designer, Erwin, Shareplex, PVCS, Version Control, Kintana, RMAN, BR*Tools, DBA Cockpit for SAP

OS: HPUX, AIX, SOLARIS, LINUX, WIN NT/2000/2008/XP/Vista

Other Oracle: SQL, SQL Forms, SQL Plus, SQL Loader, PROC, Pro COBOL, Report Writer, SQL NET, SQL DBA, Oracle Analyzer, PL SQL, OFA, Oracle Intelligent Agent, Oracle Discoverer, SQL Back Track, Data Guard, Grid Control, Oracle Stream, Oracle Express, Unix and Pearl scripting, javaScript, HTML5

Sybase: SQR, Easy SQR, Sybase SQL, BCP, I SQL, T SQL, Sybase NET

WORK EXPERIENCE

Confidential, Bloomington, MN

Senior IT Architect

Responsibilities:

• Database management for Oracle, SQL Server, MySQL environments including Exadata.
• Setup standards, policies, procedures.
• Implementation of Data Guard, Golden Gate, SSIS replication, Advance binary log replication across data centers.
• Database monitoring, performance tuning and optimization at various levels of BI, ETL and Data Warehousing.
• Data Warehousing and data mining using BIDS, SSIS/SSRS, SSAS, OLAP designs, Data Mining and MDM using MDX & DMX and Informatica
• Designing high performance, dynamic and effective Business Intelligence solutions and visualizations using Tibco SpotFire & MicroStrategy.
• Administration of Spotfire 4.2

Confidential, Palo Alto, CA

Database Architect / Tower Lead

Responsibilities:

• Leading data center relocation / migration process as Database Tower Lead for Confidential Hospital & Clinics from Dell (Perot Systems) data centers to Accenture data centers for Oracle, SQL Server, Sybase, MySQL & DB2.
• Setup policies, procedures, Oracle database architecture, design, installation, migration, configuration, backup / restore plans and process, high availability architecture, ITSM, incident, problem & change management, capacity planning.
• Set process for database monitoring, performance tuning and optimization at various levels.
• Knowledge transfer & mentoring data base team.
• Creating expectations, Service Level Agreements, policies & procedures and metrics.
• Infrastructure outsourcing and management.
• P2P, P2V & V2V migration.
• Data replication across heterogeneous platforms using Gold Gate and SQL Server, SSIS.
• Data Warehousing and data mining using BIDS, SSIS/SSRS, SSAS, OLAP (ROLAP, MOLAP, HOLAP) designs, Data Mining and MDM using MDX & DMX
• Migration of Sybase Database and application to Oracle.
• Database / server patching and upgrades.
• Analysis of existing application & database for enhancements to scale up for future growth
• Database migration, Replication and High Availability installation, setup, configuration and management (RAC, Data Guard, Golden Gate) Oracle Versions 9i,10g,11gR2.

Confidential, Atlanta, GA

Senior Database Architect and Project Manager

Responsibilities:

• Actively working with onshore/offshore team in order to coordinate development, design, testing, implementation and maintenance efforts, Manage timely delivery of all database related deliverables associated with Virtual Merchant System for Credit Card Authorization and Settlement application.
• Project effort(s) including overall budgeting, capacity planning, controlling, staffing, administering, and management status reporting.
• Analysis of systems to identify opportunities related to performance, security, scalability enhancements.
• Analysis of Standards and benchmarks of existing and proposed systems and developing best practices
• Providing expert opinion and hands on support for Oracle Database related issues such as performance tuning, optimization, backup/recovery, upgrade, configuration and support of 9i/10g/11g RAC database on sun Solaris platforms
• Analysis of existing application based on Java, JavaScript, HTML5 & underlying database for enhancements in performance and functionality.

Confidential, Minneapolis, MN

Senior Database Administrator Oracle / SQL Server (CRDM)

Responsibilities:

• Support and Administration of Siebel - Oracle databases for CRM, SOA and Clinical Trial Management. Installation and configuration to support SOA projects.
• Helping and mentoring developers in writing efficient codes for complex processes of Siebel CRM, SOA and CTMS applications.
• Performance testing and optimization
• Maintenance of database in Production/ Development and Test environments
• Standards and work-instructions revision
• RMAN configuration and support. Backup/restore using SAN snap/dsnap technology
• Oracle, Sql Server Installation/Upgrade/Patching and Support
• Configuring the Oracle database for Veritas clusters environment
• Working with and helping the Data Warehouse / ETL (Informatica) team in design, development and implementation of Enterprise data warehouse and data marts;
• Maintenance and development of Oracle Forms and Report
• Analysis of existing / new requirements, design and testing for optimal performance of application
• Data modeling using Erwin, Power Designer. Unix scripting and creating database triggers, stored procedure and packages
• Providing expert opinion and hands on support for Oracle Database related issues such as performance tuning, backup/recovery, upgrade, configuration and support of 9i/10g/11g database on Sun clusters
• Installed and Configured Oracle 10g/11g RAC using SAN and NAS and Data Guard for St. Paul Police Department as out of office work

Confidential, Minneapolis, MN

DBA LEAD & Database Solutions Architect

Responsibilities:

• Responsible for managing enterprise database services across various platforms, db2 - SAP using DBA Cockpit and BR*Tools, Oracle Apps, Sql Server, Hyperion and Access. Also responsible for managing the DBA team, coordinating with various user groups and developers, proactive problem resolution, project evaluation and monitoring, performance tracking and enhancements. Capacity planning and resource management. Design and test of Disaster Recovery (DR) system. Helping the ongoing business on legacy system as well as supporting the SAP transitions. Performance tuning of database/application for Oracle and SAP ERP. Managing with various SAP transactions and notes.
• Mentored the development team to write efficient code, migrating changes to test and production and actively involved in code reviews.
• Responsibilities include administering, monitoring, Performance tuning Oracle Applications 11i and database, Diagnosis and problem ticket monitoring & resolution, Setup and administer security, Analysis, testing and install patches, supporting and resolving issues with various tiers / components of Oracle ERP under Oracle RAC environment. Configuration of Data Guard and flash recovery.
• Setup and enhancement of standards and policies and procedures.
• Monitoring and supporting Sql Server 2000/2005/2008 , mysql, Oracle ERP 11.5.9, Oracle RAC, DB2 9.5, OBIEE (Siebel) and Business Intelligent architecture and reporting, Hyperion & eCommerce, unix shell and pearl, Java, JavaScript and HTML5 scripting.
• Data modeling using Erwin Power Designer.
• Oracle Database replication using Oracle Streams and Quest Shareplex
• Introduction of MySQL database for non-critical applications to save company revenue. Set up and configuration of binary log replication, backup processes.
• Designed the process/procedure to upgrade Oracle 11i Ebiz suite to Rel.12.
• RDW and RMS applications customizations and tuning
• Data Warehousing using SSIS, SSRS & SSAS.

Confidential, Minneapolis, MN

Lead DBA / DWHS-ETL Architect

Responsibilities:

• Reporting to VP Business Intelligence. Coordination between various user groups and Information Technology group.
• Responsibilities also include but not limited to make sure if Databases (Oracle 9i and Sql Server 2000/2005), ETL processes, Scheduled and ad hoc jobs, Reporting services up running smoothly and in timely manner. Administration, monitoring & performance tuning Oracle and Sql Server databases and applications. Design and test of Disaster Recovery (DR) system.
• Enhancement of standards, policies, and procedures. Making sure if the documentations are correct and up to date.

Confidential, Minneapolis, MN

Project Manager Database Services / Architect

Responsibilities:

• Responsible for the day-to-day operation and direction of Data Acquisition and Delivery, Project effort(s) including overall budgeting, capacity planning, controlling, staffing, administering, and management status reporting.
• Porting data across various platforms like Oracle, SQL Server, DB2, Sybase and MS Access.
• Configuration and support of Oracle/Sql Server database for VLDB to accommodate multi terabyte of data in large Data warehouse environment.
• Design, development, implementation and support of Data Warehouse, Data modeling, Data Analysis, ETL development (Unix, Perl and Data Stage
• Database backup & replication
• Managing Oracle Application 11i.

Confidential, Minneapolis, MN

Senior Database Administrator Oracle / SQL Server / Sybase

Responsibilities:

• Database Support in Production/ Development and Test environments
• Policies, procedures and standards revision
• Support and training to the application users
• ODS and Data Warehouse development and management support
• ETL (Data Stage)
• Performance enhancements, Co-ordination between the Middle Management and Applications / Database team.
• Supporting Brio, Mint, Unitrade and other trading operations/ tools.

Confidential, Omaha, NE

Oracle DBA / Application Developer

Responsibilities:

• Responsible for Oracle Applications tuning and maintenance. Creating documentations
• Unix scripting and creating database triggers, writing stored procedure and packages.
• Administering Oracle database, Development of interfaces between application and database. Development/customization/maintenance of Oracle Forms & Reports, Creating Stored Procedures, Unix shell scripting, Creating test cases and test plans, Testing and Documentation. Support Retek RMS and RDW.

Confidential, Omaha, NE

Oracle Database Administration and Production Support

Responsibilities:

• Monitoring and managing the smooth rollout of the projects from inception to production
• Tuning, maintenance and security implementations of the application
• On-call for production support
• Installations, configuration, maintenance and support of Oracle Database and Applications Server
• Creating and revising standard documentation and procedures for various application development process
• Mentoring and developing Forms interfaces using Forms 6i, identifying weak SQL and optimizing queries and performance improvements.
• Data and code migration from Oracle to SQL Server using PL/SQL and TSQL. Log Shipping, Clustering backup/restore, security and access management and tuning of Sql Server database.
• Supporting Oracle Applications 11i and helping configuration of various modules
• Configuring and controlling SIEBEL/CRM tool and application. Providing the support and actively participating in SIEBEL upgrade to versions 6.0.2 and 7.0.4
• Supporting development work on Powerbuilder, Visual Basic, WebLogic, J2EE etc. technologies
• Installing and Configuring Oracle 9i RAC on Sun Solaris platform

Confidential, Minneapolis, MN

Oracle Developer

Responsibilities:

• Application tuning using Explain Plan and Sql Trace utilities.
• Providing expert suggestions for making changes in data model, using the features of 8I to ripe best performance.
• Identification of weak SQL embedded in java codes