SUMMARY

• Overall 7+years of experience working on Data warehousing,Data Virtualization and Data Modelingin Healthcare, Insurance, Transportation, efficiently carried out Agile, Waterfall Software Development Life Cycle methodologies.
• Strong knowledge/experience in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production support.
• Extensive Data virtualization experience in creating Base view, Business View, Derived view and Data source using Denodo 6.0 - 7.0-8.0.
• Extensive experience in Denodo performance optimization technique using Cashing, gather statistic and Data movement.
• Created Denodo cashing (full/partial-explicit) in separate SQL Server database to improve performance related task.
• Design and implement Data virtualization layers using Denodo platform for data consumption via API calls & Web service calls
• Created Data Models by extracting the data from various data sources by connecting through JDBC, ODBC, and Web API.
• Experience in publishing data sources on REST and SOAP based web services.
• 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.
• 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).
• 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/8.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

Sr Denodo Developer

Responsibilities:

• Installed and configured Denodo 8.0 in windows environment. 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.
• 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.
• 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.
• Understanding data requirements, security requirements, metadata, design, development, and testing activities to successfully implement and support the needs of the business.

Environment: Denodo 8.0, DB2, SQL Server, Data Lake, Windows

Confidential, Paramus, NJ

Sr Denodo Developer

Responsibilities:

• Design and implement Data virtualization layers using Denodo platform for data consumption via API calls & Web service calls.
• Followed change management processes, including source code control, versioning, branching, defect tracking and release management.
• Created physical, business & application data virtualization artifacts including views, procedures, transformation, data sources, definitions & models.
• 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.
• 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.
• 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, NJ

Data Virtualization Expert

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

Confidential, Sacramento, CA

Denodo Developer

Responsibilities:

• Planning, design, development, and utilization of electronic data processing systems software.
• Collaborate on the definition, development, and maintenance of standards and processes.
• Drive continuous improvement and automation in BI solutions and processes.
• Serve as mentoring resource for other developers.
• Work closely with Business Systems Analysts to understand requirements regarding solutions, ensure data quality and match-back to core systems transaction results.
• Work with other IT staff to develop technical specifications based upon functional specifications as created.
• Follow typical systems development life cycle processes in defining projects and gaining approval.
• Actively participate and contribute to Uline's EDW architecture.
• Understand and contribute to enterprise data warehouse data model.
• Provide technical and business knowledge support to the team.
• Serves as subject matter expert, possessing in-depth knowledge and experience in ETL tool administration
• Provide ETL Administration including ETL Tool Configuration, Module Design and Development, Data Mining and Acquisition, and Metadata Management

Environment: Denodo 6.0, Oracle 12c, Dell Boomi, TOAD, XML Files, Windows, Mac and UNIX

Confidential, Durham, NC

ETL Developer

Responsibilities:

• Created physical, business & application data virtualization artifacts including views, procedures, transformation, data sources, definitions & models.
• Created API Layers for internal/external stakeholders using REST/SOAP to deliver standardized data.
• Connected heterogeneous data sources and standardize the data across the organization to create information delivery applications supporting a broad range of internal and external stakeholders.
• Maintained and extended agile data development methodology in support of both self-service and full-service models.
• Created reusable semantic and report-specific data layers that are secure and performant.
• Develop techniques for optimizing solutions, including caching, refactoring, performance, and testing.
• Ensured data security is maintained throughout the user, application, platform, and data layers.
• Developed integration with front-end tools (Tableau, custom apps) and back-end applications and data (e.g. SAP).

Environment: Oracle 12c, Kafka, FHIR format, JSON, Windows, Mac, UNIX