SUMMARY

• Denodo Administrator with more than six years of experience in the design and development of data warehouse data visualization, data warehouse and servers administration.
• Extensive Data virtualization experience in creating Base view, Business View, Derived view and Data source using Denodo 6.0 - 7.0.
• Configured Denodo cashing (full/partial-explicit) in separate oracle database to improve performance related task. Also worked in Denodo code migration using VQL script.
• Design and implement Data virtualization layers using Denodo platform for data consumption via API calls & Web service calls
• Implemented Data Virtualization platforms using Denodo application in pharmaceutical (Gxplearn environment) and finance domain.
• Experienced in ETL concepts and tools such as Informatica, SQL, Data Mapping, XML, Web services.
• Extensive ETL experience with Informatica PowerCenter 9.0.1/8.6.1 . Advanced knowledge and excellent concepts in development and design of ETL methodology for supporting data transformations and processing ETL solutions.
• Strong knowledge of reporting applications using leading industry tools, ETL and BI reporting.
• Comprehensive knowledge in implementation of Data Warehousing, Data Marts, Star and Star Flake Schema Modeling, Dimensional Modeling on OLTP and OLAP concepts using Ralph Kimball and Bill Inmon methodologies.
• Extensive experience in Oracle Technologies in back-end oracle database design, development, testing, production migration, production support and maintenance activity.
• Experience in UNIX shell scripting (file validations, file downloads, workflow executions).
• Excellent attitude with good verbal, written, and interpersonal communication
• Ability to multitask and easily adapts to changing priorities, self-starter and able to work with minimal supervision.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, SQL server 2008, Netezza, Teradata

Data Modeling Tool: ERWIN

ETL Tools: Informatica Power Center 9.0.1/8.6.1 , SAP BODS/BODI, SSIS

Data Visualization: Denodo 6.0/7.0

RDBMS Tools: TOAD, SQL Developer, SQL Plus, MS SQL Management Studio

Reporting Tools: Crystal Reports, Dashboard, Tableau reports

Scripting: Unix, Python

Other Tools: Control - M, Autosys, TIDAL, Secure FTP(SSH), MS Excel, Notepad++, BMC(Pak 2000)

Operating Environment: Windows/Mac-OS/ UNIX

PROFESSIONAL EXPERIENCE

Confidential, TX

Denodo Admin

Responsibilities:

• Configure Denodo 7.0 environment and taken part in documentation.
• Participate in denodo cache configuration.
• Follow typical systems development life cycle processes in defining projects and gaining approval.
• Plans and coordinates installation of upgrades, enhancements, and changes to the Data Virtualization software. Supports testing and quality assurance for all upgrades, enhancements, and changes to the Data Virtualization software. conduct Deployment of Revision drills. Automate regular administration activities.

Confidential, Maryland

Denodo Administrator / Expert

Responsibilities:

• Installed and configured Denodo 7.0 in windows environment.
• Diagnose any issues including errors and performance topics. Work with Denodo technical support leading to resolution.
• Establish load balancing, caching, backups, conduct DR drills. Automate regular administration activities. collaborate with technical staff to understand and to develop new solutions or the resolution of software problems and, use expertise to design develop, code, test, and debug software
• Design and implement Data virtualization layers using Denodo platform for data consumption via API calls & Web service calls
• Manage configurations across multiple environments (i.e. Dev, Test, Perf, Prod), configurations within version management tools (i.e. GIT) and Support branches within configuration pipelines, supporting partial deployments •
• Manage security at row and/or column level through security groups
• Profile & discover data stores, data sources and generate profiling reports. Document data quality risks & design data quality solutions.
• Implementing best practices and procedures to ensure improved performance of data loads, integrity of data movement within the organization, and enhanced data architecture to support Business Intelligence applications and analytics.
• Communicate progress of resolution and status in a timely fashion and/or per service level agreements.
• Diagnose and resolve client inquiries related to operating Denodo software products in their environment.
• Understanding data requirements, security requirements, metadata, design, development, and testing activities to successfully implement and support the needs of the business.

Environment: Denodo 6.0, Oracle 12c, FHIR format, JSON, Windows, Mac, UNIX and SSH

Confidential, Parsippany, NJ

Senior Denodo / Data Virtualization Developer

Responsibilities:

• Installation, configuration, monitoring and support of Denodo platform including upgrades and maintenance of security.
• Take on the role of technical lead for the Denodo platform.
• Experience working with JSON and AWS is a plus and FHIR format.
• Supports the definition of, and adherence to, Data Virtualization standards, conventions, principles
• Address a majority of technical questions concerning customization, integration, enterprise architecture and general feature / functionality of Denodo.
• Obtain and maintain strong knowledge of the Denodo products, be able to deliver a superb demo and technical pitch, including overview of our key and advanced features and benefits, services offerings, differentiation, and competitive position.
• Lead custom deployments dealing with business-focused and engineering-focused requirements.
• Establish governance processes and best practice documentation and internal knowledgebase for users of Denodo. Review usage and adoption of best practices.
• Establish load balancing, caching, backups, conduct DR drills. Automate regular administration activities.
• Constantly learn new things and maintain an overview of modern technologies.
• Contribute to the development of the Semantic Layer team’s tools, skills, culture, and impact.
• Lead globally disbursed team members

Environment: Denodo 6.0, Oracle 12c, Tableau, TOAD, XML Files, Windows, Mac, UNIX and SSH