Manish Nevrekar

*** ******** ****

Pelham, AL ***24

Email: actjmz@r.postjobfree.com

Phone: 205-***-****

Enterprise Information Systems and Data Management professional with 13 years of experience evaluating, implementing, and supporting business critical applications across healthcare, Insurance, restaurant 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/Architecture (Security,Backup Recovery Strategies, Private cloud, Performance Tuning, Patching Upgrades, Migrations)

Executive Reporting,

Data Integration and Migration,

Business Intelligence and analytics

Extraction/Transformation/ Loading (ETL) design & development.

PROFESSIONAL EXPERIENCE

Lead Database Architect

Regions Financial Corporation, Birmingham, AL (June 2013 to current)

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.

Perform low downtime Migrations using Goldengate & othrt Oracle technologies

Tune and administer all aspects of Oracle Exadata (2 Full racks X3-2 and 2 full Racks X5-2)

Evaluating and implementing Oracle Big Data Sql

Architected Datalake using Oracle Big Data Appliance (Cloudera Distribution of Hadoop) and exadata and Big Data Technologies (i.e. Hive, Hadoop, Impala etc)

Solve performance issues that arise in Tier 0 applications.

Understand and apply security standards to Database development( PCI-DSS, SOX)

Solutions Architect for OFSAA 8.0 implementation.

Perform zero downtime migrations of mission critical applications

Evaluate software for the enterprise and manage vendors.

Major contributor to the Big Data information architecture which was awarded "Datawarehouse and Big Data Leader excellence award of the year 2014 by Oracle for North America"

Presented at Oracle Open World 2014.

Lead Database Administrator

Infinity Property & Casualty Corporation, Birmingham,AL (June 2011 To June 2013)

Infinity Property & Casualty Corporation is a national provider of personal automobile insurance with a concentration on nonstandard auto insurance.

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 implemented 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

Children's Health System, Birmingham, AL (Nov 2002 to June 2011)

Children's Health System (CHS) is a pediatric healthcare system in Alabama comprised of Children's Hospital and a statewide network primary and specialty care offices.

Perform Backup/Recovery of Production Databases

Actively involved in charting a BI (Business Intelligence) Strategy and Executive Dashboard.

Technical Lead Design/Develop/maintain Patient management/ Patient 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, Oracle Corporation

(Business Intelligence & Data Warehousing Group) (Feb 2000 to November 2002)

Ahold International, Greenville South Carolina

Ahold International, BI-LO marketing datamart

Ahold International Inc, headquartered in Amsterdam, Holland, is a company that owns and operates a large number of grocery store chains, namely BI-LO, Bruno’s etc.

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

Outback Steakhouse Inc, Tampa, Florida

Outback Steakhouse Data Mart, Senior Consultant, Oracle Consulting

Outback Steakhouse, Inc., headquartered in Tampa, is a company of restaurants that owns and operates “Outback Steakhouse” units throughout the U.S. as well as Carrabba’s Italian Grills, Zazarac, and Lee Roy Selmon’s.

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.

Networktelephone.net,Pensacola,Florida

Networktelephone Discoverer 3i implementation, Senior Consultant, Oracle Consulting

Network Telephone provides small and medium-sized businesses with digital subscriber lines (DSL), local and long-distance telephone services, ISDN and high-speed Internet web hosting; streaming video; and other cutting-edge multimedia applications.

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.

Visa International, Miami, Florida.

Visa International Data Mart, Senior Consultant, Oracle Consulting

Visa is an organization jointly owned by more than 21,000 member financial institutions around the globe. Visa plays a pivotal role in advancing new payment products and technologies on behalf of its members.

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.

Envera Clearinghouse, Richmond, Virginia.

Envera Clearinghouse Data Warehouse & BI portal, Senior Consultant, Oracle Consulting

Envera is a member-drive, Business for Business service for Web-enabled transactions and related supply chain services for the petroleum and chemical industries.

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).

CATCH/IT Project, Tampa, Florida

Data Warehouse Developer/Designer (Aug 1998 to Feb 2000)

CATCH/IT project, ISDS department, University Of South Florida, Tampa involved building a data warehouse to track the community health status of the various counties in Florida.

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.

Schiffer & Menezes Dental Care Products Ltd., Goa, India.

Production Engineer (August 1997 to July 1998): Was in charge of scheduling production and controlling inventory.

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 .

Kodak India Ltd., Goa, India

Trainee Engineer (May 1996 to July 1997): Scheduled production and preventive maintenance.

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

TECHNICAL OVERVIEW

Methodologies & Techniques

Data Warehouse life cycle

Software Development Lifecycle

Executive Dashboards

Information Lifecycle Management

Applications

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

Technology

Software, Tools & Languages

Database

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)

OLAP Tools

Oracle Discoverer, Oracle OLAP

Microsoft Analysis Services.

Hardware & Operating Systems

Big Data

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.

Education

University Of South Florida, Tampa, M.S. (MIS)

Goa University, Goa, India, BS(Mechanical Engineering).

Certifications

Oracle 8i certified DBA

References available on request.

Contact this candidate