SUMMARY

• I have been a Teradata DBA, Teradata Lead DBA for more than 13 years.
• I worked as infrastructure DBA, Application DBA and Operational DBA in some of the most complex Teradata installations with proven track records of creating stable and very efficient Data Warehouses and teams.
• I successfully adopted new technologies and tackled new technical challenges with great success as evidenced by some of the most successful Data Warehouses in the world that I helped setup and manage from scratch.
• Posses’ expertise with big MPP databases such as Teradata, Paraccel and Hadoop and big data technologies
• Possess expertise with database design, relational database and BI application development lifecycle
• Posses’ expertise in administering 100+ TB Teradata systems including performance monitoring/optimization, capacity planning, security administration, archive and restore and disaster/ recovery.
• Very creative and always explore new technologies and new efficient ways in solving reporting and product development initiatives
• Proficient in all Teradata technologies such as PDCR, Viewpoint, TASM, recourse analysis (CPU, DATA and I/O skew), DSA, Tools and Utilities (Multiload, FastLoad, TPump, SQL Assistant, Administrator etc...)
• Possess exceptional performance tuning skills, effective issue resolution expertise with tenacious follow up to attain operational excellence
• Posses’ experience in successfully hiring, managing and mentoring exceptional Teradata DBAs in EDW and BI environment
• Posses’ expertise in setting up and running/supporting ETL Tools (Informatica, DM Express, DataStage), techniques and complex infrastructure environment in Linux and other OS
• Build relationships with developers, DBAs, Data Architects and vendors to enhance solution delivery in IT environment.
• Experience in providing development support for Data Warehousing and Business Intelligence projects.
• Solid interpersonal organizational and people communication skills.
• Analytical thinker that consistently resolves ongoing issues or defects, often called upon to consult on problems that have eluded resolution.
• Versatile DBA, worked in Retail, Healthcare, Financial and Insurance, and car industry companies
• Achieved hundreds of millions of dollars of ROI and cost savings through some of EDW initiatives
• Experience with Teradata 14.10 and 15.10 and Linux Suse 11 scripting

TECHNICAL SKILLS

• Project management ETL Development
• Database Administration
• Linux System Administration
• MS productivity tools
• Word
• Project
• Teradata Tools and Utilities
• ETL Tools and Utilities
• Informatica
• ETI
• DM Express
• DataStage)
• RDBMS (Teradata
• SQL Server
• Oracle
• Paraccel
• DB2) Mainframe (MVS
• JCL
• TSO/ISPF
• FILEAID
• SPUFI)
• Erwin
• Business Intelligence tools
• Microstrategy
• Tableau
• ClickView
• Business Objects)
• Customer Relationship Management (CRM)
• Data Transformation
• Enterprise Warehouse
• Data Modeling
• Erwin Designer
• Data Marts
• OLAP
• Metadata
• ETI Master User
• VB programming
• Object oriented programming
• Data Warehouse hardware and software

PROFESSIONAL EXPERIENCE

Confidential

Lead Teradata DBA

Responsibilities:

• Planned and executed a complete hardware refresh of Teradata environment to a new Teradata 6800 300+ TB Active Data Warehouse, with very minimal interruption to development, QA and Production
• Planned and executed a full DR solution, that involved implementation of DSA, WAN changes, establishing Teradata System in DR, continuous loading and periodic DR tests
• Complete re - write of the Backup/restore environment, leverage of DSA and online backup with virtual storage (EMC data domain) and physical tapes that reduced time of the backups and completely eliminated contention of backup with ETL and reporting jobs.
• Implemented a rigorous code review process that insured production code quality and considerably reduced inefficient queries
• Worked with ETL teams and BI tools administrators to make architectural changes that significantly reduced resource consumption by the ETL and tool generated queries
• Worked with dozens of developers and business users to educate them on Teradata technologies through training session and continuous collaborations
• Constantly tweaked and improved workload management TASM to address new workloads and insure proactive handling of inefficient queries

Confidential

Teradata DBA/Architect

Responsibilities:

• Set up new EDW environment for Confidential that consists of DEV/QA system and a production system with Archive and DR solutions from scratch
• Implemented new Revenue Cycles databases to support Billing, Collection, Patient Financials, Financial reporting and supply Chain activities
• Implement Claims data warehouse for the Relay Health claims data
• Daily database management, including performance monitoring/optimization, capacity planning, security administration, archive and restore and disaster/ recovery.
• Implement revenue cycle reporting solutions for Confidential customers (Lifepoint and CHP) with flexible reporting dates
• Participate in Architecture discussions and POC to implement big data solution that will harness Confidential revenue cycle data and enable data discovery and process optimization

Confidential

Consulting Application Engineer

Responsibilities:

• Worked with SG2 Research group to provide inpatient, outpatient, encounter and CPT for admissions analysis and forecasting for Confidential markets.
• Developed ETL process for Revenue Analysis project
• Worked on successful transition from Informata ETL Tool to DM Express ETL tool

Confidential

Teradata DBA Lead

Responsibilities:

• Supervise EDW release management process and insure changes are coordinated and implemented in the right sequence in a highly integrated EDW environment
• Daily database management, including performance monitoring/optimization, capacity planning, security administration, archive and restore and disaster/ recovery.
• Interface with business owners and application stake holders to understand requirement and enhance application development and support
• Manage application performance and availability SLAs and create and implement plans to insure capacity and address any issues whenever they arise
• Work with application development teams throughout all steps of the project cycle until successful deployment in production
• Actively manage two groups: Application development DBAs and Operations DBAs who provides application development and support for all EDW projects at The Confidential
• Successfully created a process to refresh big data sets from Teradata to Paraccel for data Mining
• Implemented purge process for 200+ TB database to manage data growth and maintain optimal levels of performance

Confidential

DBA Team Lead

Responsibilities:

• Lead a team of successful DBAs and provided guidance and leadership in training, task assignment, mentoring and management of the full cycle of various projects
• Project managed and implemented large hardware and software upgrades for the EDW Data Management team
• Have been part of successful Clinical initiatives such as HAI, ED Dashboard and Meaningful Use
• Interface with business owners and application stake holders to understand requirement and enhance application development and support
• Supported development projects for the Patient Financial, Financial Services, Supply Chain and Physician Services
• Created and implement procedures for maintenance and management of all EDW servers and projects.
• Established best practices for Data Management and ETL development in EDW environment
• Provided leadership in implementation of processes and procedures for managing performance on the EDW.
• Interfaced with DBAs, business users and application developers for the purpose of application development.
• Interface with Teradata vendors and global support team to manage infrastructure changes and resolve Software and Hardware problems.

Confidential

EDW Consultant/ DBA

Responsibilities:

• Provided DBA support for development projects for several application development teams within Ford and Ford Credit.
• Developed procedures and processes to manage user creation, database physical implementation, and space management.
• Managed Performance for Inventory system (IMAS) that lead to an ROI of more than 20 Million Dollars a month. This project was featured in the Teradata Magazine.
• Created ETL processes and Load jobs for Data Warehouse applications.
• Developed, implemented and documented processes for Archiving, business continuity, disaster recovery, performance monitoring, performance improvement, capacity planning, and change management.
• Put in place process to monitor daily workloads and system usage and adjust Priority Scheduler parameter when needed for all Ford EDW Servers.

Confidential

DBA Team Lead

Responsibilities:

• Successfully managed the infrastructure team for the Data Warehouse. This team included 2 Teradata DBAs, a SQL Server DBA and two BI application developers.
• This Team was the foundation of successes that resulted in two Data Warehousing Institute’s International Awards.
• Managed the budget for the Infrastructure team.
• Provide leadership in implementation of major hardware upgrades for test and production systems as well as many software upgrades (and patch upgrades).
• Supported application development timelines by implementing designs as well as incremental changes to database definition in a timely manner into production and non-production environments.
• Managed the day-to-day system administrator tasks for the Data Warehouse environment and fixed software and hardware problems whenever they occur.
• Performed Archiving, business continuity planning, disaster recovery, performance monitoring, performance improvement, capacity planning, and change management.
• Provided DBA support for all the development projects within the Business Intelligence department.
• Interfaced with vendors and global support team to manage infrastructure changes and resolve Software and hardware problems and investigate different issues.

Confidential

ETL Developer/ DBA

Responsibilities:

• Developed procedures and processes to manage user creation, database physical implementation, and space management.
• Performed hardware upgrade on the production system from a Teradata WorldMark 4800 to Teradata WorldMark 5200.
• Maintained all database objects (Table DDLs, Views, and Macros) and production jobs for the Nationwide Data Warehouse.
• Created test and production environments for the Confidential Data warehouse and assisted development teams with performance tuning.
• Developed, implemented and documented processes for Archiving, business continuity, disaster recovery, performance monitoring, performance improvement, capacity planning, and change management.
• Developed ETL processes to do daily updates to the AUTO and Claims Data Warehouse using COBOL, ETI*Extract and Teradata utilities.
• Created and implemented ETL process extracted data from the Producers DB2 legacy system and populated the Producers Data Mart.
• Implemented an ETL process to populate the Agency DataMart within the Nationwide Data Warehouse.
• Collected and Analyzed RESUSAGE data (Bynet, CPU, disk usage, etc.) to monitor and improve performance and balance the production workloads.