Sheela Reddy

adm9xz@r.postjobfree.com

925-***-****

Professional Summary

Over 5+ years of experience in SQL, T - SQL, SSIS, SSRS, Tableau, Data Virtualization with Denodo.

Development, Testing, and Implementation of client-server-based applications.

Experience in creating database Tables, Views, Cursors, Constraints, Joins, Stored Procedures, User Defined Functions, Temp Table consumed at various stages of migration/cleaning process, report, or data validations.

Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task, etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access, and CSV files to data warehouse.

Created SSIS packages to provide consolidated information in user-defined dashboards using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Text file and CSV files to data warehouse.

Designed a complex SSIS package for importing data from SQL Server 2016.

Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge and Merge joining, Pivot and Unpivot Control Flow Transformations

Created packages in SSIS with error handling and event handling.

Implemented data views and control tools for guarantee data transformation using SSIS.

Expertise in Extract Transform and Load (ETL) using SQL Server Integration Services (SSIS) Packages for integrating data using OLEDB connection from varied sources by using multiple transformations including Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.

Excellent Analytical, Problem-solving Skills, and Communication Skills, a Motivated Team-player with Excellent Inter-Personal Skills

Created databases and schema objects including tables, indexes, and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.

Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.

Created reports such as Parameterized, Cascading, Drill through/Drill down Reports, Charts and specialized in producing Sub Reports using SSRS.

Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Tableau Desktop and Excel to provide better data visualization.

Designed, deployed, and maintained of various SSRS Reports.

Created and managed database objects and efficiently such as tables, views, clusters, indexes, stored procedures, functions and triggers, and referential Integrity.

Wrote the expressions in SSRS wherever necessary.

Involved to write complex T-SQL queries and Stored Procedures for generating reports.

Defined parameters for parameterized Reports using SSRS.

Designed and developed various Service Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS.

Successfully worked with Report Server and configured into SQL Server 2016.

Successfully connecting to disparate Data sources from Denodo Data Virtualization

Creating Base views and derived views (joins, union, minus, Flatten, intersect, interface, association) from disparate Data sources.

Worked on development projects that were based on Data Virtualization concepts and creating web services in Denodo.

Developed Data Model by Data Virtualization techniques using Denodo 7.0 / 8.0 by connecting to multiple data sources such as SQL Server, Oracle, MySQL, Excel, Json, XML etc.

Created Data Models by extracting the data from various data sources by connecting through JDBC, ODBC.

Created scheduled jobs for data extracts and report reloads by Denodo Scheduler.

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 7.0 & 8.0 in internal project.

Publishing data sources on REST and SOAP based web services.

Connecting Denodo Data Virtualization from Reporting tools.

Created Job Monitoring and Financial Dashboards using Power BI and DAX quires

Tableau reports dashboards and publishing to the end users for executive level Business Decision.

Used lambda function for Infrastructure automation:

EC2 automated snapshot creation.

Daily automated reporting of list of EC2 instance

Action based on OS logs digested in cloudwatch logs like automatically creating deny for EC2 if some is trying to do unauthenticated login

Integration of Lambda with ticketing tools to take automated actions

Education

Bachelor’s in Computer’s at Villa Maria Degree College from India - 2009

Master’s in information technology management, Campbellsville University -Louisville - 2019

Technical Skills

Databases Tools: Business Intelligence Development Studio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Management Studio, MySQL Workbench, Oracle SQL Developer.

Data Virtualization Tools: Denodo DV 7.0 & 8.0

Data Visualization: Tableau Desktop

ETL Tools: DTS Data Transformation Services Export/Import and SQL Server Integration Service (SSIS)

Reporting Tools: Power BI, SQL Server Reporting Service (SSRS), Tableau

Database: SQL Server 2012, 2016, MS Access

Web Technologies: HTML, DHTML, XML, XSL

Operating Systems: Windows Server 2008/2003/2000/XP and Unix.

Other Tools: MS WORD, MS EXCEL, MS VISIO, and MS PowerPoint

Professional Profile

OrgSpire Inc. Jan 2019 to May 2021

SQL/Denodo Developer

Responsibilities

Worked on development of CCPA solution using Denodo as a Data Virtualization layer

Worked on development projects that were based on Data Virtualization concepts and creating web services in Denodo.

Developed Data Model by Data Virtualization techniques using Denodo 7 by connecting to multiple data sources such as SQL Server, Oracle by connecting through JDBC.

Created base views, derived views and interface views for JDBC data sources by importing source tables, SQL query, stored procedure.

Created integrated views using operations such as Joins, Unions, Projection, Selection, Minus, Flatten Views, Interface, associations and data service layers in Denodo.

Experience in integrating Denodo with Oracle, SQL Server, MySQL Workbench databases using JDBC.

Experience in publishing views on REST and SOAP based web services.

Experience in installing and configuring Virtual Data Port (VDP) server.

Having strong capability of managing end to end data flow using virtualization layer.

The primary responsibilities include the designing and creating Data Services Layer in Denodo and feeding it to the front-end web application.

Created scheduled jobs for data extracts and report reloads by Denodo Scheduler.

Strong knowledge of using cache, Massive Parallel Processing (MPP), Data movement and other optimization techniques.

Improved view performance by analyzing VQL execution plan and log files.

Have set role to group of users and granted permission on required elements.

Developed export and import scripts for deployments.

Imported data from desperate data sources like JDBC, XML, Delimited files, Excel, and Web service.

Strong knowledge on Installation, configuration, monitoring and support of Denodo platform including upgrades and maintenance of security.

Diagnosed issues including errors and performance analysis. Worked with Denodo technical support leading to resolution.

Used Denodo Restful Web service to publish entire elements of Virtual Data Port server with different representation formats like HTML, XML and JSON.

Configured different advanced settings of a view like Cache, Memory, Search Methods, Indexes, Statistics and Execution Plan.

Analyzed error using execution trace and log files to improve performance.

Defined different log levels like TRACE, DEBUG, INFO, WARN, ERROR and looked at log4j2 conf file for debugging.

Used different cache types like Full, Partial to improve performance.

Strong knowledge on Top-Down and Bottom-up Modeling.

Strong knowledge on Metadata Management and Data Catalog.

Created user and defined different roles using Role Management.

Defined row-level and column-level security mechanism in data virtualization layer

Monitored Denodo Platform servers using Diagnostic and Monitoring tool.

Created databases, Logins, Roles and granted appropriate permissions.

Created jobs, alerts, activity logs, error logs to capture any possible error.

Environment: MS SQL Server 2016, SQL Server Management Studio, MySQL, Oracle, T-SQL, MS-Excel, Denodo DV 7.0 & 8.0, Tableau, Aws lambda.

Fidelity Investment Jan 2016 to Dec 2018

SQL/Denodo Developer

Responsibilities

Successfully connecting to disparate Data sources from Denodo Data Virtualization

Creating Base views and derived views (joins, union, minus, Flatten, intersect, interface, association) from disparate Data sources.

Worked on development projects that were based on Data Virtualization concepts and creating web services in Denodo.

Developed Data Model by Data Virtualization techniques using Denodo by connecting to multiple data sources such as SQL Server, Oracle, MySQL, Excel, Json, XML etc.

Created Data Models by extracting the data from various data sources by connecting through JDBC, ODBC.

Created scheduled jobs for data extracts and report reloads by Denodo Scheduler.

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 in internal project.

Publishing data sources on REST and SOAP based web services.

Connecting Denodo Data Virtualization from Reporting tools.

Created Job Monitoring and Financial Dashboards using Power BI and DAX quires

Expert on Microsoft Power BI and Tableau reports dashboards and publishing to the end users for executive level Business Decision.

Experienced in managing users, groups, sites, permissions and roles on Power BI Service and Tableau Server.

Created Data Models by extracting the data from various data sources by connecting through JDBC, ODBC, excel, json, xml etc.

Responsible for Creating and Monitoring all components of Denodo tool (Administration, VDP, Scheduler, Custom Views, and Caching)

Participated in SDLC methodologies such as planning, analysis, design and implementation.

Solved issues related to server performance and disk space.

Successfully implemented Database Mirroring in SQL Server 2012 for high availability.

Installed SQLSafe on all the database servers.

Evaluated database performance and performed maintenance duties such as tuning, backup, restoration, and disaster recovery.

Maintained High Availability such as Log Shipping and Mirroring as a database disaster technique.

Created Clustered and Non Clustered Indexes on tables, views, and columns

Creating and managing schema objects such as tables, views, index, and procedures.

Created SQL Server Clustering on multiple nodes.

Involved in database backup, recovery, and restoration.

Wrote documentation for all the Database maintenance related issues.

Environment: MS SQL Server, SSIS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, Denodo

Nevonex Solutions Private Limited Jan 2015 – Nov 2015

SQL/BI Developer

Responsibilities

Gathered and documented business requirements for analytical reports. Participated in requirements meetings and data mapping sessions to understands business needs, identified and documented detailed business rules.

Perform thorough unit testing on all relevant platforms to ensure proper implementation.

Conduct Tableau user training, analyze the business processes, gather requirements, and bridge the needs of the business with the use of Tableau analytics and systems best practice.

Worked collaboratively with a team of developers to build the ETL process needed for reporting.

Successfully migrated data between different heterogeneous sources such as a flat file, Excel and SQL Server 2012 using SSIS.

Created and modified already existing stored procedures, views, indexes.

Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.

Designed, developed, and published interactive reports and dashboards in Tableau Desktop and integrated custom visuals based on requirements and scheduled them for automatic refresh using tableau Service.

Utilized tableau (Power View) to create various analytical dashboards that depict critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

Generated ad-hoc reports in Excel Power Pivot and shared them using Tableau to the decision makers for strategic planning.

Utilized Tableau gateway to keep dashboards and reports up to-date with on-premises data sources.

Environment: MS SQL Server2012, SSIS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL

Contact this candidate