SUMMARY

• He is a senior consultant with over 20 years of Data Warehouse and 23 years of information technology experience includes expert Engineer and developer level on Data Virtualization Platforms/Big Data MapR Data Stage, Informatica, CRM, Data Warehousing, and ERP systems.
• Technology expertise includes technical lead, architecture planning and software implementation, client server, system integration, relational databases, star schema, WEB and Java on medium and large projects. Development tools include Data Stage, Co - sort, Sync-Sort, Jbuilder, and Together Soft.

TECHNICAL SKILLS

• Data Virtualization
• Database Architecture
• Data Lake
• Development (T-SQL & PL/SQL)
• Query optimization
• Performance Tuning
• Pipeline and ETL Design/Development
• DB2
• Data Stage
• VB, C#. Visual Studio, .net
• Migration, Conversion
• Visio Data Modeling tool
• Toad, visual Studio
• Erwin, ER Studio, Oracle SQL Developer
• Data Modeler

PROFESSIONAL EXPERIENCE

Solutions Data Architect

Confidential

Responsibilities:

• Designed large scale Teradata data repository for Account/asset pricing that included feeds to applications used for account asset pricing review.
• Designed and implemented snapshot and change data capture methodology for reducing space requirements and improve performance.
• Developed architecture Design patterns for Data Virtualization and Big Data
• Integrated, created views, and tested Tibco Data Virtualization against MapR Big Data Solution
• Data Lake MapR/HIVE/Drill
• Coordinated data delivery, security access setups, and hardware and environment setups.
• Reviewed numerous system banking designs including asset pricing, asset management,
• Develop APPs for Trust Division
• Developed built in security profiles using ACE controls, tags and views.
• Develop Naming Conventions for Big Data environment
• Assisted with and Reviewed Big Data guidelines for teh Big Data Environment

Technical Environment: Tibco 7.8, 8.0 Power Designer 16.6, Oracle/Oracle Exadata, Cognos, Big Data/MapR, Drill Explorer, Drill SQL Server 2012, Teradata, Tibco/Cisco Data Virtualization tools.

Data Virtualization Architect/Developer/Data Modeler

Confidential

Responsibilities:

• Implement teh TIBCO solution in BW. dis includes Development, unit testing, integration testing
• Defined best practices for Caching, Layer Definitions and Modeling for Data Virtualization (DV)
• Designed Business Layer and multi-layer model for Data Virtualization Overall Solution
• Demonstrated Caching solutions that brought view designs that returned data in 11 minutes enhanced to returning data in 11 seconds.
• Developed backend cached solutions that enhanced Development time frames for more rapid reporting development
• Drove implementation of Model and caching solutions on Teradata and SQL
• Lead Data Governance meetings for new enrichment data
• Design of feeds from external systems to teh STARS/MED MEASURES database
• Designed and developed may various executive reports for Ad-hoc reporting.
• Design of Census team data delivery for COGNOS Executive reporting.

Technical Environment: Tibco 7.6, Erwin 9.2, Oracle, Cognos, Big Data, SQL Server 2012, Teradata, Cisco Data Virtualization tools.

Data Architect/Data Modeler/Model Delivery and Production Support

Confidential

Responsibilities:

• Developed and implemented multiple 'hot' changes to 24x7x365 warehouse live system.
• Developed near real time interfaces/models for reporting to handle HSA account balances.
• Supported warehouse model changes for Employee health portal application for health care incentives
• Profiling of data for release 7 of Clinical Reporting Project (CRP)
• Developed high speed data loads for large volume tables over a 2 billion records
• Developed models for SDS/ODS layers for DW and implemented canonical models for Client Intelligence Projects / (MDM) Master Data Management for IBMs MDM Platforms.
• Worked with teh business to develop SDS/ODS data models to support teh CIP project and other down-stream applications.
• Analyzed and designed partition and compression methods to reduce disk space usage/foot print reduction on Teradata databases and implemented those compression techniques.
• Data Architect for (EHP) Employee Health Portal Reporting. Worked closely with Application DA’s for design of both SDS and aggregated data mart for EHP releases. Worked with reporting developers to assist on for Micro Strategy reporting SQL development.

Technical Environment: Erwin r7.3 and 9.2, SQL Server 2012, Teradata, Oracle, DB2, DataStage 8.1, FACETS, IBM InfoSphere Master Data Management, MicroStrategy

Java Development

Confidential

Responsibilities:

• Took on coding Java classes to extract data from an application on a 10 year old sunset system where literally all documentation and comments were nonexistent and all developers that had worked on teh project were no longer with teh company.
• Developed extracts of vat reports by building teh vat reports and then exporting them to PDF files in teh server for archiving.
• Developed extracts of Statements by building teh Statements from an xml schema and then exporting them to PDF files in teh server for archiving.
• Developed extracts of Requests forms by building teh Request forms from an xml schema and then exporting them to PDF files in teh server for archiving.

Technical Environment: Java, IText, Intelij, MS SQL

ETL Technical Lead

Confidential

Responsibilities:

• Developed ETL extracts using DataStage 7.5 for transcript reporting, turnaround tracking and historical reporting.
• Developed numerous MS reports to replace Brio reports for financial reporting.
• Architected DW model for course room activity tracking and reporting to enhance learner retention and flag coaching possibilities for instructors.
• Reverse engineered black box course work registration system and Developed Mapping documents and built ETL process for dis effort.
• Functioned as Business Analyst to collect requirements and develop cube designs for learner to course room, and instructor to learner interactions.

Technical Environment: Sun Solaris, AIX, Oracle 9i, TOAD, ER Studio 6.6, DataStage