PROFESSIONAL SUMMARY:

• Overall 6+ years of experience working on Data warehousing, Data Virtualization and Data Modeling in Finance, Banking, Healthcare, 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.
• Over 3 years of experience in Data Virtualization with Denodo.
• Worked on development projects that were based on Data Virtualization concepts and creating web services in Denodo.
• Good experience in Java, Python, RDBMS, PL/SQL, TOAD, Oracle EBS Apps Technical, ETL (SQL Loader), Workflow Builder, BI Publisher, Tableau, DENODO - Data Virtualization.
• Developed Data Model by Data Virtualization techniques using Denodo 5.5 / 6.0 by connecting to multiple data sources such as SQL Server, Oracle, Hadoop etc.
• Created Base Views, Derived Views, Joins, Unions, Projection, Selection, Union, Minus, Flatten Views, Interface and associations of data service layers in Denodo.
• Created Data Models by extracting the data from various data sources by connecting through JDBC, ODBC, and OLEDB.
• Created scheduled jobs for data extracts and report reloads by Denodo Scheduler.
• Upgraded Denodo 5.5 to Denodo Express 6.0 and solved many challenges and provided suggestion to Denodo Vendor for future enhancements.
• Developed business requirements, Dashboard development, and data verification and analysis.
• Experience in integrating Denodo with Oracle, SQL Server, MySQL Workbench databases using JDBC.
• Experience in Installing and Configuring Virtual Data Port(VDP) Database setup in Denodo.
• Having strong capability of managing end to end data flow using virtualization layer at Data Warehouse.
• Excellent knowledge of TSQL Query optimization, Stored Procedures, Packages, Database Triggers, Views, Functions.
• Experience in publishing data sources on REST and SOAP based web services.
• Excellent knowledge on Data Modeling e using Erwin, ER Studio IBM Rational System architect for Dimensional Modeling, Relational Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data mart, OLTP, OLAP, FACT Dimensions tables, Physical and Logical data modeling.
• Involved in Database design Development of SQL SERVER 2005/2008R2/2012/2014
• Experience in developing Conceptual, Logical modeling and Physical database design for OLTP and OLAP systems.
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snowflake Schemas, Fact and Dimensional Tables.

TECHNICAL SKILLS:

Data Virtualization: Denodo Express 6.0, Denodo 5.5

Data Visualization: Tableau Desktop, QlikView/QlikSense

Databases: Oracle 11g, MS SQL Server 2008, MS SQL Server 2012, MY SQL

Operating Systems: Windows XP, Windows 7, Windows 10

Programming Languages: Python, Java, PL/SQL

Others: Oracle Workflow and Report Builder, BI Publisher, TOAD

Office Tools: MS Word, Excel, PowerPoint

Database Tools: SQL * PLUS, Toad for Oracle Base (10.6.1.3)

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Data Virtualization Consultant-Denodo Developer

Responsibilities:

• The primary responsibilities include the Requirement Analysis, Designing and Creating Data Services Layer in DENODO Express and feeding it to downstream Dashboard systems.
• Identifying the Source Systems, possible Fact tables and Dimension Tables.
• Created custom Denodo views by joining tables from multiple data sources.
• Developing web services to be used for connecting to Dashboard systems.
• Other activities include data preparation for data services layer, unit testing, and other project lifecycle activities support.
• Integrated MySQL Workbench and Oracle using JDBC to Denodo.
• Responsible for Creating and Monitoring all components of Denodo tool (Administration, VDP, Scheduler, Custom Views, and Caching)
• Designed and developed high-quality integration solutions by using Denodo virtualization tool (read data from multiple sources including Oracle, Hadoop, MySQL)
• Read the Employee data from SAP-BAPI's/Web services to Denodo and implemented business logic in Denodo and exposed the final business views
• Created caching jobs in Denodo different databases like MySQL, Hadoop, Teradata, Excel.
• Analyzing and debugging of code to fix issues reported.
• Ensuring Quality Standards and improving the overall quality of deliverables.
• Coordination with various stakeholders of the project.
• Providing technical assistance to team members.
• Fine-tuned and optimized the performance of Complex views in Denodo.
• Involved in Testing like Unit testing, System integration, and regression testing and performed code review.

Environment: Denodo 5.5, Tableau, Hadoop, MySQL, Oracle 11g, PL/SQL, Teradata, Windows Server 2008 R2.

Confidential, Hartford, CT

SQL DBA

• Involved in designing of Conceptual Logical Model and Physical Model.
• Design/Build Extract Transform Load procedures in SQL Server 2000 using DTS packages to import/export data feeds to/from the data warehouse and claim systems.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks, and performance of SQL server.
• Created SSIS packages to export data from Oracle to SQL Server Database.
• Performance: Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.
• Supported clustering and replication for servers.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Responsible for tier 2 support for more than 10 SQL Servers in a 24x7 mission-critical/production environment.
• Worked on CDC(Change Data Capture)
• Maintained cluster servers to provide high availability.
• Design/Build Extract Transform Load procedures in SQL Server 2000 using DTS packages to import/export data feeds to/from data warehouse and claim systems
• Created and tuned stored procedures, triggers, and tables.
• Created several materialized views and UDF's to be accessed by the new front end applications.
• Managed Materialized and Partitioned views for better performance.
• Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Provide 24 X 7 supports to all production, development, staging and clustered servers.
• Configured two Active/Passive Clustering setups for failover on production servers. This included installing windows cluster service and SQL on windows enterprise edition.

Environment: SQL Server with clustering, Replication, ETL, Sybase, T-SQL, Windows 64 bit, SQL/PLSQL, DTS.

Confidential

MS SQL Developer

• As a developer, I was responsible for the systems study, analysis, understanding systems design and database design.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Created User Defined Functions, Stored Procedures, and Triggers.
• Experience in creating small Packages.
• Created Views to facilitate easy user interface implementation, and triggers on them facilitate consistent data entry into the database.
• Data mapping using Business Rules and data transformation logic for ETL purposes.
• Involved in Migrating the data model from one database to oracle database and prepared an oracle staging model.
• Designed star schemas and bridge tables to control slowly changing dimensions.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
• Assisted in the design of report layouts to maximize usability and business relevance.

Environment: HTML, VBScript, SQL Server 2005, SQL Query Analyzer, Windows NT, MS Access, MS Excel, Erwin.