SUMMARY:

• Enterprise Information Systems and Data Management professional with 15 years of experience evaluating, implementing, and supporting business critical applications across healthcare, Insurance, Finance and manufacturing industries. An innovative and strategic thinker who specializes in designing and managing enterprise data strategies.
• Enterprise Database Architect / Technical Lead.
• Big Data Architect
• Dimensional modeling/ Physical Design of Data Warehouses,
• Application Development (OLTP),
• Oracle Database Administration (Backup Recovery Strategies, Performance Tuning, Patching Upgrades, Migrations)
• Executive Reporting,
• Data Integration and Migration,
• Business Intelligence and analytics
• Extraction/Transformation/ Loading (ETL) design & development.

TECHNICAL SKILLS:

Technology and Tools: Data Warehouse life cycle Software Development Lifecycle Executive Dashboards Information Lifecycle Management Oracle Portal 3.0.9.8.5 Oracle Discoverer 3i &Discoverer 4i Oracle BIEE Oracle Data Integrator Oracle Goldendgate 11.2.1.01 Oracle Designer 6i,9i Oracle Warehouse Builder 2.1. Crystal report 8 & 9 Oracle BPEL Python, PL/SQL, Java, C# J2EE & .NET technologies, Golden Gate Oracle 8.0 and Oracle 8i., Oracle Parallel Server, Oracle 9i, Oracle 10g, Oracle 10g, Oracle 11g,Oracle RAC, Oracle Exadata Platform,,ASM,RAC, Oracle Standby, Oracle Failsafe, HACMP architecture on Aix . SQL Server2000,SQL Server 2005, Analysis Series(SQL Server) Compaq Tru - 64 Unix, Solaris, IBM Aix (4.3.3& 5.1L), Oracle Enterprise Linux (Fedora Core) 4,5 &6 Hadoop( Cloudera Distribution), Hive, Impala, sqoop, pig.

PROFESSIONAL EXPERIENCE:

Lead Database Architect

Confidential, Birmingham,AL

Responsibilities:

• Regions is a Top 20 US Bank with product lines in Consumer banking, Commercial banking, Wealth management, Mortgage products and services and Insurance products and services
• Architect, set standards and mentor fellow DBAs in all aspects of oracle database administration
• Currently in the process of architecting Regions private cloud using Oracle 12c on Vmware, Oracle VM and Exadata.
• Major contributor to the Big Data information architecture which was ed "Datawarehouse and Big Data Leader excellence of the year 2015 by Oracle for North America"
• Solve performance issues that arise in Tier 0 applications
• Perform zero downtime migrations of mission critical applications
• Evaluate software for the enterprise.
• Presented at Oracle Open World 2014.

Lead Database Administrator

Confidential, Birmingham,AL

Responsibilities:

• Lead DBA for the OLTP/DW Oracle/Sql Server databases
• Manage Oracle Databases on Oracle Exadata (V2,X2)platform.
• Design backup/recovery and Disaster recovery strategies.
• Proactively tune the databases for optimal performance
• Application Design and Development for OLTP and DW systems
• Lead role in migration applications from Oracle (8i,9i,10g) to Oracle Exadata platform (X2 Full Rack, V2 Half Rack)
• Extensive use Oracle Goldengate for Migration and CDC using ODI
• Design ELT using Oracle ODI .
• Evaluate and implement Security Products for PCI compliance.
• Application development using Oracle XMLDB
• Implemented Big Data POC using a 4 node Hadoop cluster, Splunk and Vertica

Lead Programmer /Analyst

Confidential, Birmingham, AL

Responsibilities:

• Perform Backup/Recovery of Production Databases
• Actively involved in charting a BI (Business Intelligence) Strategy and Executive Dashboard.
• Technical Lead Design/Develop/maintain Confidential t management/ Confidential t Access/Clinical Data warehouse (Logical & Physical design).
• Designed and tuned the ETL procedures and Dashboards.
• Designed metadata for Data Warehouse.
• Involved in SOA architecture design and implementation using J2EE, Oracle fusion middleware.
• Implemented Web Services Orchestration using Oracle BPEL.
• Implemented Oracle Discoverer and Oracle Portal.
• Monitor & Tune Various Oracle and SQL server databases(OLTP & Data Warehouse)
• Develop the backup and Recovery strategies for databases (RMAN for Oracle)
• Provide database support in various projects and Applications at CHS.
• Production DBA for Oracle (Version 8i, 9i, 10g, 10gRAC) and SQL Server Databases (2000, 2005)
• Involved in the implementation of Oracle HTB ( Healthcare Transaction Base)
• Well versed in hl7 v2 and a good understanding of hl7 v3.
• Involved in the implementation of Query T 12 exchange of CCD (Continuity Of Care Document) with Alabama Medicaid under the Together For Quality Initiative.
• Currently working on delivering C32 Compliant CCD to Alabama Medicaid.
• Implemented an Interface to Baxa pump for TPN.

Senior Consultant

Confidential

Responsibilities:

• Team member from Oracle Consulting designing BI (Business Intelligence) strategy.
• Worked on designing the physical and logical structure “Star Schema”
• Designed and implemented ETL routines using PL/SQL and Korn shell scripts.
• Designed metadata for the Data Warehouse
• Tuned Oracle Parallel server (OPS) on AIX 4.3.3
• Designed and tuned Ad-Hoc queries (OLAP) using Discoverer 4i & Microstrategy 7.1

Senior Consultant, Oracle Consulting

Confidential, Tampa, Florida

• Designed Data Mart for Reconciliation, Inventory and Budget.
• Implemented Summary management using Materialized Views.
• Indexed and Tuned Queries for Performance.
• Installed and Configured 9iAS 1.0.2.2 on Windows 2000, Discoverer 4i and Portal 3.0.9.
• Designed and implemented the ad hoc queries in Discoverer4i.

Senior Consultant, Oracle Consulting

Confidential, Pensacola,Florida

Responsibilities:

• Installed 9iAS1.0.2.0 and Oracle Database 8.1.7 V3.
• Configured Discoverer 3i
• Simulated existing reports in Discoverer 3i.
• Tuned the queries for Performance.

Senior Consultant, Oracle Consulting

Confidential, Miami, Florida

Responsibilities:

• Designed / developed Data Warehouse logical and Physical design.
• Wrote the ETL using PL/SQL and Korn shell scripts.
• Installed and configured Oracle 9iAS
• Designed the user interfaces (ad-hoc queries) using Discoverer 3i.

Senior Consultant, Oracle Consulting

Confidential, Richmond, Virginia.

Responsibilities:

• Designed the Data Warehouse using Designer 6I( CASE tool).
• Wrote the ETL procedures for data from the OLTP system using PL/SQL stored procedures.
• Designed/Built metadata for management of the Data Warehouse.
• Designed user interface using Discoverer 3.1 and Oracle Portal 3.0 (OLAP interface).

Data Warehouse Developer/Designer

Confidential, Tampa, Florida

Responsibilities:

• Designed and developed star schemas for the Data warehouse using Oracle8.1.5.
• Designed and implemented the aggregate tables.
• Worked on optimizing query time for the ad hoc queries (Partitioning and indexing plans).
• Designed/Built ETL procedures and the metadata interface.
• Wrote PL/SQL procedures for the CATCH methodology for the staged data.
• Set up Oracle 8 and Oracle 8i (8.1.5) instances for Windows NT 4.0 platform.
• Designed/Built OLAP interface using Oracle Discoverer3.1.

Confidential

Production Engineer

Responsibilities:

• Planned the preventive maintenance of the plant machinery.
• Member of the in house MIS team
• Designed and developed production reports using Oracle 7.3.1 & Ms Access .

Confidential

Trainee Engineer

Responsibilities:

• Stipulated ISO 9001 maintenance procedures for production machines.
• Assisted in configuring and implementing the production module of “4th shift” ERP software on Oracle 7.3.1.
• Member of the in house MIS team.
• Designed and developed MIS reports using Access 97