Summary
Overview
Work History
Education
Skills
Timeline
Generic

Dinesh Reddy Seelam

Oviedo,FL

Summary

• Over 12 years of IT experience in architecting, designing, and developing business intelligence solutions like QlikView, Qlik Sense, Tableau, and Power BI for various verticals like Manufacturing industries, Tech industries, financial services, Banking, and Healthcare.
• Experience in implementing Microsoft BI/Azure BI solutions like Azure Data Factory, Power BI, Tableau, Qlik sense, Azure Data Bricks, Azure Analysis Services, SSIS, and SSRS.
• Expertise in design, testing, implementation, maintenance, and administrating Business Intelligence Systems in multiple Windows environments.
• Experience in Multi-Dimensional Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, and Data Import/Export.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database consistency checks using DBCC utilities and Index Tuning Wizard.
• Intensive experience monitoring database performance using SQL Profiler and the DB's percent log space for all database servers using SCOM and Windows Performance counters.
• Experience in Database Backup and Recovery and Disaster Recovery procedures.
• Experience writing Stored Procedures, User Defined Functions, Cursors, Triggers, and Schema.
• Experience in Data Modeling (logical modeling and physical modeling) using Erwin. Good knowledge of database experience using Oracle 11g/10g/9i/8i, MS SQL Server 2005, MS Access 2000/7.0, TOAD, PL/SQL, SQL and SQL Loader, and SQL Navigator.
• Experience working with SQL Query analyzer, SQL Server Management Studio, and BI development studio and scheduling jobs.
• Scheduled reports on a Daily, Weekly, and Monthly basis on sales and shipments using multi-dimensional data using QlikView, Qlik Sense, and Tableau.
• Extensive experience in Data Quality Testing, data governance, and removing data anomalies in complex data integration systems.
• Trained the end users effectively to use the reporting tool to build and customize their ad-hoc reports. Designed training for offshore tier 2 support team.

Overview

12
12
years of professional experience

Work History

Sr. Business Intelligence Lead

Keeco, LLC
08.2022 - Current
  • Keeco LLC is best-in-class home textile supplier specializing in fashion top-of-bed, essential / utility bedding, and soft windows with additional businesses in bath, kitchen textiles, table linens, and patio mats
  • Have brought affordable and trendy products and solutions to homes for over 40 years
  • After Hollander Sleep Products had been merged with Keeco LLC worked with C level to integrate all QlikView, and Qlik sense dashboards to Tableau and Power BI
  • Design and develop end-to-end BI solutions leveraging Tableau, Power BI, and Azure services to meet business requirements
  • Create data ingestion pipelines using Azure Data Factory to extract, transform, and load data from diverse sources into Azure Data Lake Storage or Azure SQL Data Warehouse
  • Develop interactive dashboards and reports in both Tableau and Power BI to visualize insights and KPIs for stakeholders
  • Utilize Tableau Desktop and Power BI Desktop to build and optimize data models for efficient storage and analysis
  • Implement advanced analytics and machine learning capabilities using Azure Machine Learning within Tableau and Power BI environments
  • Configure data connections and integrate data sources seamlessly within Tableau and Power BI for comprehensive analysis
  • Implement row-level security and dynamic security filters to restrict access to sensitive data in both Tableau and Power BI
  • Deploy and manage Tableau Server and Power BI service environments on Azure for centralized report distribution and collaboration
  • Optimize performance of Tableau and Power BI reports by fine-tuning queries, data models, and visualizations
  • Monitor and maintain health and performance of Azure resources supporting Tableau and Power BI deployments
  • Ensure data governance and compliance standards are met by implementing appropriate security measures and data policies
  • Provide training and support to business users on utilizing Tableau and Power BI for self-service analytics and reporting
  • Collaborate with data engineers, Azure administrators, and business stakeholders to design scalable and secure BI solutions
  • Troubleshoot and resolve issues related to Tableau, Power BI, and Azure services to ensure smooth operation and user satisfaction
  • Designed and implemented complex data visualizations utilizing various chart types, graphs, and maps to effectively communicate trends, patterns, and outliers in data
  • Integrated Tableau with multiple data sources including relational databases, flat files, cloud services, and web data connectors, ensuring seamless data connectivity and integration
  • Performed data cleansing, transformation, and aggregation tasks using Tableau Prep Builder to prepare datasets for analysis and visualization
  • Implemented advanced calculations and statistical analysis using Tableau calculated fields, parameters, sets, and table calculations to derive meaningful insights from data
  • Collaborated with business stakeholders to gather requirements, translate business needs into technical specifications, and deliver solutions that meet business objectives
  • Optimized Tableau workbooks and dashboards for performance by optimizing data connections, extract refresh schedules, and dashboard design
  • Created user-friendly and intuitive dashboard layouts, applying best practices in data visualization and user experience design to enhance usability and clarity
  • Published Tableau workbooks and data sources to Tableau Server or Tableau Online, managing user permissions, access controls, and content schedules for efficient collaboration and sharing.

Sr. QlikView Admin & Developer

Hollander Sleep Product
03.2016 - 07.2022
  • Hollander Sleep Products is North America's giant pillow and mattress pad manufacturer
  • Hollander products are in most retailers, e-retailers, and hotels under Ralph Lauren, Nautica Bedding, Pacific Coast Feather, and Live Comfortably
  • Drove operational improvements, which resulted in savings and improved profit margins
  • Learned new skills and applied them to daily tasks to improve efficiency and productivity
  • Created User access rules and Login access rules to allocate Licenses and Tokens for business partners based on usage in Qlik Sense and well-versed with QlikView User Cal's types
  • Actively listen to customers' requests, confirming complete understanding before addressing concerns
  • Participated in full lifecycle implementation of Qlik applications
  • Implemented 3-tier architecture (Data-Extract, Data-Modeling, and Application Development) as recommended in QlikView best practices guide
  • Designed best practices document for QlikView Dashboard and QVD development, sizing, and configuration
  • Implemented Security & Deployment of Qlik Applications between environments
  • Created different audit dashboards for analyzing trends and usage of applications
  • Created publisher tasks in QMC for different applications based on 3-tier architecture to update QVD files and dashboards as scheduled
  • Expertise in relational structures, Star Schema/Snowflake modeling, Data warehouse, dimensional data modeling, and reporting techniques
  • Designed efficient Data-Models from Multiple Data sources and followed Best-Practices guide provided by QlikView
  • In-depth knowledge of handling disaster recovery backup plans for QlikView & Qlik Sense servers
  • Proficient in Software Development, Testing Life Cycle, and Defect Life Cycle
  • Expertise in knowledge of SQL, TSQL, and Shell scripting languages
  • Worked Extensively on QlikView Dashboard Prototypes and interacted with Customers and End-Users directly to gather requirements and show various advanced features of QlikView
  • Created and scheduled power shell scripts to monitor server resource utilization daily
  • Managed team of employees, overseeing hiring, training, and professional growth of employees
  • In-depth knowledge of handling disaster recovery backup plans for Qlik Servers
  • Documented best practices for Development and Administration
  • Expertise knowledge in design, testing, implementation, maintenance, and administration of Business Intelligence Systems in multiple Windows environments
  • Implemented different types of security on Qlik Sense streams based on user access types
  • Responsible for adding and managing Users, apps, objects, streams, ODBC data connections, content libraries, and extensions in Qlik Sense environment
  • Responsible for backing up and restoring Qlik Sense site and certificates used by the central node to restore site in emergency
  • Proactive monitoring and troubleshooting of day-to-day issues based on priority levels
  • Opened case tickets and worked with Qlik support on various production environment issues
  • Designed documents on troubleshooting most common QlikView and Qlik Sense issues
  • Monitor and maintain Windows Server operating system and additional server components including but not limited to Exchange, Active Directory, SharePoint & SQL Server
  • Apply patches to major subsystems and services, roles, and file system components within Windows Systems environment and perform operating system and patch testing on all changes before installation
  • Execute basic PowerShell or Command Shell commands
  • Assisted supervisory staff with managing complex calendars and to-do lists to support organization and productivity
  • Expertly coordinated logistics for functions both within and outside of an organization
  • Devoted particular emphasis to punctuality and worked to maintain outstanding attendance record
  • Received and processed stock into inventory management system
  • Recently upgraded Qlik view instance from 12.5 to 12.7.

QlikView Developer & Admin, Administrator

PERS, State of Oregon
04.2015 - 02.2016
  • Public Employment and Retirement Systems serve the people of Oregon by administering public employee benefit trusts to pay right person proper benefitS at the right time
  • Analyzing existing complex systems to understand and document data elements, relationships, data flow, dependencies, and related interfaces
  • Designed and implemented Incremental Loading using QVDs so that instead of reloading entire data from the database, QlikView would only load data worth one day and concatenate it to old Data stored in QVDs
  • Designed data model using various data sources like Oracle 10g/DB2 Database, XML, and Excel Sheets
  • Developed Variables, Input boxes, calendar & Macros, Linked Tables, Concatenation, and solved loop issues
  • Implemented Section Access on Financial Dashboards where users belonging to specified Windows AD groups can view Dashboards based on their privileges defined in the QlikView Application
  • Designed rank and exceptional reports according to customer needs
  • Partnered with the QlikView team in gathering and analyzing business requirements from various sources, ensuring business needs and delivery feasibility
  • Document all deliverables before moving to production
  • Responsible for migrating QVW files from Dev to the Prod environment during Production window schedule times
  • Daily Scheduled includes Publisher Tasks Daily/Weekly/Monthly on various Dashboards based on Database updates
  • Used to create and run .bat file jobs through external command in QMC
  • Installed and Configured QlikView 11 on Windows 2008 R2 Servers and clustered 6 servers for the production environment
  • Involved in scaling and sizing the environment
  • Experience in handling system backups before upgrade and migration
  • Experienced in recycling QlikView services whenever required
  • Responsible for monitoring shared file corruptions in the Production environment
  • Extensive experience in cleaning up corrupted shared files using power tools
  • Expertise in creating different ODBC connections to extract data from data sources like DB2, SQL Server, Oracle, and SAS databases
  • Translated technical concepts and information into terms parties could easily comprehend
  • Analyzed work to generate logic for new systems, procedures, and tests
  • Worked with QlikView 10
  • X, 11.x SQL Server, Oracle, SAP, Excel, flat files
  • Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs, and enhancements.

QlikView Developer

Intuit
10.2014 - 03.2015
  • Intuit Inc
  • Is an American software company that develops financial and tax preparation software and related services for small businesses, accountants, and individuals
  • Worked on Salesforce Dashboard (SFDC) on the development and performance side
  • The main agenda of this project is to work on performance issues and merge other data sources into one
  • Designed and developed analytical data structures
  • Rapidly prototyped new data processing capabilities to confirm integration feasibility into existing systems
  • Cleaning up data, alerting data issues, restoring whole QMC, and changing dependencies
  • Working on server performance and alerting dashboard effects on server performance
  • Developing new reports, including ad hoc reports, sheet objects, and significant KPIs
  • Started analytical dashboard from scratch for TurboTax Life cycle, Growth analysis from past years, and defects from past years in each tab compared with different states' data
  • Implemented section access on dashboards, which gives access to only a few executives in the group to confidential data
  • Helped end users design test cases and worked through multiple UAT cycles
  • Extensive experience in troubleshooting day-to-day issues based on priority levels
  • Opened problem records and worked closely with Qlik Tech on different issues
  • Extensive experience in recycling QlikView Services in Dev., Test, and Prod environments
  • Experience in proactive monitoring of the environment.

QlikView Developer

Toshiba
12.2012 - 10.2014
  • Toshiba America Medical Systems markets, sells, distributes, and services diagnostic imaging systems, including CT scanners, Ultrasound, and MRI machines, and coordinates clinical diagnostic imaging research for all modalities in the United States
  • This project started from scratch and developed many working dashboards in 1 Year with limited resources
  • Involved in various Prototype Designs and helped Business Analysts to understand the capabilities of the QlikView Tool
  • Designed Dashboards like Contracts Module, which gives contract details on every System, forecasting details, Life cycle, and other analytics user requests
  • Developed Dashboards for Financial Details of the company with Charts based on Metrics of Revenues, Expenses, Income, Returns, and Margins
  • Identified KPIs for QlikView Dashboards like Loan Revenue Tracking, Portfolio Risk
  • Designed and implemented incremental Loading using QVDs so that instead of reloading entire data from the database, QlikView would only load data worth one day and concatenate it to Old Data already stored in QVDs
  • Designed Data-Model using various data sources like Oracle 10g/DB2 Database, XML, and Excel Sheets
  • Implemented 3-tier architecture, Data Extract, Data Model and Application
  • Data Extract would load Data from data sources into QVDs and Data Model will define relationships between tables (QVD), and The application layer is the User Interface Design layer, where the layout of all Charts, Tables, and List Boxes
  • Implemented Section Access on Financial Dashboards where users belonging to specified Windows AD groups would be able to view Dashboards based on their privileges defined in QlikView Application
  • Created Publisher Tasks in QMC for QlikView Application to Reload and Distribute QlikView Application onto Access Point
  • Scheduled Publisher Tasks Daily/Weekly/Monthly on various Dashboards based on Database updates
  • Responsible for documenting all activities performed in QlikView Environment
  • Involved in setting up Development and Performance Environments for QlikView
  • Extensively worked with Set Analysis in some of the Dashboards
  • Worked with QlikView 10.x, SQL Server, Oracle, DB2, Excel, flat files.

SQL DBA

Sherwin Williams
06.2012 - 09.2012
  • Involved in new database design and creation using Rational Rose
  • Created Database Diagrams using the third-party tool ER-Win at the beginning of the project
  • Identify database entities and attributes, relation among entities tables, and enforce referential integrity constraints
  • Worked on the creation and improving stored procedures and trigger performance
  • Implementation of Microsoft Office SharePoint Server 2007 Beta for corporate intranet, document management, collaboration
  • Experienced in the Design of OLAP Data warehouse using Star Schema and Snowflakes Schema
  • Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user-defined data types, and functions
  • Created Database Diagrams using the third-party tool ER-Win at the beginning of the project
  • Defined relationships between tables and enforced referential integrity constraints
  • Responsible for Query Performance Tuning and Optimization
  • Created views, SQL joins DTS packages and statements for applications
  • Designed and implemented stored procedures and triggers for automating tasks
  • Generated T-SQL code for creating cursor and handling data validations
  • Created SQL server Analysis Projects using MS SQL Server 2005
  • ETL packages are created to extract, transform, and load data to the data warehouse using SSIS
  • SSIS transfers data to and from flat files, MS Excel, MS Access, and SQL Server 2005
  • Implemented calculations to aggregate physical measures using management studio
  • Involved in the creation of Multi-Dimensional Cubes and Relational Cubes
  • Used BCP techniques, Stored Procedures, Triggers, Cursors and Transaction management, and T-SQL to convert data from various sources to MS SQL 6.5/7.0 databases.

Education

MBA - Health Care Administration

International Technological University
San Jose, CA
03.2012

Skills

  • Business Intelligence: Power BI, Azure Data Factory, Azure Data Bricks, Azure analytical services, Azure Data Lake Analytics, Azure Data Lake Storage, Power apps, QlikView, Qlik Sense, SSRS, SSIS, SAP Business Objects, Tableau
  • Defect Tracking Tools: Apache JMeter, HP Load Runner, and IBM ClearQuest
  • ETL Tools Informatica - Power Center, Oracle Data Integrator, and
  • Database Technologies: Oracle 8i, 9i, 10g, 11g, MS SQL Server 2000/2005/2008/2012, MS Access
  • Web Technologies: HTML, CSS, Nodejs, and JavaScript
  • Programming Languages: SQL, PL/SQL, C, C, Java, and Shell
  • Operating Systems: Windows 2012/2008R2/2008/2005/2000/XP

Timeline

Sr. Business Intelligence Lead

Keeco, LLC
08.2022 - Current

Sr. QlikView Admin & Developer

Hollander Sleep Product
03.2016 - 07.2022

QlikView Developer & Admin, Administrator

PERS, State of Oregon
04.2015 - 02.2016

QlikView Developer

Intuit
10.2014 - 03.2015

QlikView Developer

Toshiba
12.2012 - 10.2014

SQL DBA

Sherwin Williams
06.2012 - 09.2012

MBA - Health Care Administration

International Technological University

Similar Profiles

CREATE PROFILE
Dinesh Reddy Seelam