Candidates About

 

Sruthi Reddy

 

PROFESSIONAL SUMMARY:

 

·         Having overall 8+ Years of IT experience. 5+ Years of Tableau and 3 + Years of SQL server experience, creating highly interactive Data Visualization reports and dashboards using Data blending, Extracts, Calculations, Filters, Actions, Parameters, Context Filters, Sets, Groups, Aggregate measures etc. Experienced professional having thorough knowledge of SQL Server, Dashboards, Reports, Teradata, Excel and desktop management.

·         Experience with Relational Databases in a SQL/Oracle Server environment

·         Experience with MS SQL Server Reporting Services (SSRS),(SSIS) MS SQL Server Integration services, MS SQL Server Analysis Services(SSAS).

·         Expertise in writing SQL Queries and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.

·         Extracted data from SQL Server into data marts, views, and/or flat files for Tableau workbook consumption using T-SQL.

·         Have working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database objects like tables, constraints (Primary key, Foreign key, Unique, Default) and Indexes.

·         Extensive experience using Tableau Server, Tableau Desktop. Installing, Configuring and Administration of Tableau Server.

·         Experience in creating dashboards using calculations, groups, sets, parameters, calculated fields and hierarchies.

·         Expert in strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata management i.e., Connections, Data model and VizQL model.

·         Highly skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Dual Axis, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.

·         Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.

·         Experience in creating filters, quick filters, data source filters, global filters, context filters and user filters.

·         Experience in implementing Data blending, Replace references, Customized queries and advanced visualizations in Tableau.

·         Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option- Parameterized, and Linked reports using Tableau.

·         Hands on Experience on Google Big Query (Google Cloud).

·         Created Tables in Google cloud using Big Query. Extracting the data from the Google Cloud for reporting on Tableau.

·         Possessing comprehensive knowledge of technology and business strategic logics.

·         Hands-on experience in trouble shooting, Performance tuning of reports and resolving issues within Tableau Dashboards and worksheets.

·         Good Understanding of Big Data and Hadoop technologies experience in loading, processing and extracting data in Hadoop environment.

·         Experience in documenting the testing process using MS-Office tools including MS-Word, MS-Excel, and MS-Project.

·         Worked in AGILE methodologies.

·         Excellent skills in communication & collaboration, strong analytical, logical problem solving skills and ability to quickly adapt to new technologies by self-learning.

·         Impeccable attention to detail & accuracy, handle process information, business models and needs.

·         Skilled at handling requirements, analysis, maintenance support. Self-motivated and goal oriented with high degree of flexibility, creativity, resourcefulness, commitment and optimism

 

 

PROFESSIONAL  EXPERIENCE:

 

CLIENT: Marriott International - Bethesda, MD

DURATION: January 2015 - Present

ROLE: Tableau Developer/ Admin

         Worked on the Administering Tableau Server as well as created dashboards related to tableau admin views and also helped other departments in developing Tableau Dashboards and published them to the Tableau Server for interactive custom.

 

RESPONSIBILITIES:

·         Converted the Business Objects/OBIEE reports into Tableau Dynamic Data Visualization and created Mapping Documents.

·         Responsible for creating efficient design and developing User Interaction dashboards using Tableau Desktop 10.3.1.

·         Using Google Big Query and Google Cloud for the latest requirements from the Business users.

·         Analyzing the data by Google Big Query and then building the dashboards by connecting to Google Big Query.

·         Involved in Migration of SSRS reports to Interactive Tableau Dashboards.

·         Developed YoY, QoQ, MoM reports which compare the hiring activity parameters from the previous years, quarters and month in a fiscal year. 

·         Combined multiple dashboards into a single story to enhance the visual appeal of the report.

·         Worked on Proof of Concepts to decide Tableau as a BI strategy for enterprise reporting.

·         Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.

·         Gathered business requirements and  transformed the business into high interactive Data Visualization using Tableau.

·         Created Metadata dictionary dashboard and allowed the business users to audit the          metadata of identified data sources.

·         Transformed complex data into easy-to-understand visualizations using Tableau and created a Story.

·         Converted the Business Objects technical specification into tableau metadata using  workbook tools for tableau.

·         Ensured Action Filters, created a Row Level Security and shared the reports with functional/business users.

·         Created Dashboards with the security using filters for the clients to measure cost saving.

·         Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

·         Generated Tableau Dashboards with filters, quick filters, context filters, global filters, parameters and calculated fields on Tableau reports. 

·         Generated Tableau reports with Trend lines, Reference lines and Bands and also generated several drills down and drill up reports.

·         Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes. Combined  Multiple data sources by joining tables and using Data Blending.

·         Used various join types (left, inner, right, outer joins) based on business requirements.

·         Published Workbooks by creating user filters and security, so intended teams can view it.

·         Worked on groups, sets, different calculation functions including Table calculations.

·         Hands on Tableau Administrator installation, configuration, and load balancing.

·         Hands on Design and implement security model.

·         Blended data from multiple databases such as MS Excel, MS SQL, Teradata and Oracle.

 

   ENVIRONMENT: Tableau v10.3, Data Stage, SQL Server, Oracle, MS Access, Teradata, Microsoft        

   Office Suite (Word, PowerPoint, Excel), SSRS Google Big Query – Google cloud.

 

CLIENT: HP - Palo Alto, CA

DURATION: August 2014 - November 2014

ROLE: Tableau developer

         Gathered information from the business and developed dashboards based on the requirements given. Also, designed KPI dashboards as well. Helped the team to create dashboards using Tableau. 

 

RESPONSIBILITIES:

·         Going through Report Specification Documents and Understanding the User requirements.

·         Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.

·         Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.

·         Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.

·         Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.

·         Created of dashboards for business groups like finance and sale.

·         Designed and publishing visually rich and intuitive Tableau dashboards for decision making.

·         Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc.

·         Created symbol maps to understand the geo-spatial distribution of projects with custom symbols made of represent the application category

·         Provided visual/graphic analysis based on data content.

·         Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.

·         Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.

·         Derived the performance of company base on revenue, occupancy, rate.

·         Used Trend Lines, Reference Lines and Annotations to describe the data.

·         Created Data extracts for better performance and accessing data offline.

·         Used parameters and input controls to give users control over certain values.

·         Created and Published Tableau Dashboards into Tableau Server.

 

ENVIRONMENT: Tableau Desktop v10-v9, Tableau server / Administrator, SSIS, SSRS,

SQL 12r2, Oracle 10g, PL/SQL, Microsoft Excel, MS Access, Windows server, Microsoft office.

 

CLIENT: General Atlantic- Greenwich, CT

DURATION: January 2013 - July 2014

ROLE: Tableau Developer

         General Atlantic combines a collaborative global approach, sector specific expertise, a long-term investment horizon and a deep understanding of growth drivers to partner with great entrepreneurs and management teams to build exceptional businesses worldwide. Used tableau as the reporting and dashboard tool to have a clear overview to the users about the expense bill which is spent on different projects. Help the approval managers to reduce the costs if it is going beyond the budget allocated. 

 

RESPONSIBLITIES:

·         Received data and records in various format in regards of operation information and connect data source to Tableau for visualized analysis.

·         Representing data using the visualizations such using Charts.

·         Used tableau to create worksheets, dashboards and stories for analysis purpose, using features such as filters, calculation fields, parameters, geo coding etc. to manipulate data and create advanced type of charts.

·         Involved in reviewing business requirements and analyzing data sources form Teradata Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

·         Used Tableau Desktop to create various analysis worksheets, including customer analysis and equipment analysis.

·         Developed Scorecards/Reports for the system using Tableau.  

·         Used landing page with navigations to provide quick access to target dashboards.

·         Use Reference Lines and statistical techniques to describe the data.

·         Use Measure name and Measure Value fields to create visualizations with multiple measures and dimensions.

·         Combine data sources by joining multiple tables and using data blending.

·         Use parameters and input controls to give users control over certain values.

 

ENVIRONMENT: Tableau v9, Tableau Server v9 , MS Office Suite, MS Access, MS Excel,

MS Project, Windows, Teradata.

 

CLIENT: Bed Bath & Beyond- Union, New Jersey

DURATION: Jan 2012- Dec 2012

ROLE: Tableau Developer/ Data Analyst

         Bed Bath & Beyond Inc. operates the largest house ware goods specialty stores in the United States. The company has a chain of over 300 stores that sell such domestic merchandise as bed linens, bath accessories, kitchen textiles, cookware, dinnerware, kitchen utensils, small electric appliances, and basic home furnishings. This project is to convert the existing Dashboards and SQL metrics, filters and reports into advanced chart types and visualization. Also creating dashboards for existing employees, shares, products, customer information. The objective of the engagement was designing interactive dashboards, Reports and visualizations to profile the customers based on their behavior. Leads and executes analytic projects to provide insight into client needs and behavior, supporting marketing and client servicing decisions. Engages with project sponsors and stakeholders to understand each business question, probes for hidden questions and goals. Brings structure to each request and translates requirements into an analytic approach.

 

RESPONSIBLITIES:

·         Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

·         Generated report schedules on Tableau server.

·         Administered sites for various projects.

·         Administered user, user groups, and scheduled instances for reports in Tableau.

·         Published Workbooks by creating user filters so that only appropriate teams can view it.

·         Install upgrade Tableau server and server performance tuning for optimization.

·         Participated in daily stand-ups with clients on daily design and development effort.

·         Scheduling data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.

·         Deployment of Tableau Server in clustered environment by mapping server nodes to primary machine.

·         Using Tabadmin and Tabcmd commands in creating backups and restoring backups of repository.

·         Mastered the ability to design and deploy rich Graphic visualizations using Tableau.

·         Developed Tableau data visualization using Pareto’s, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.

·         Developed donut charts for analyzing sales planning data.

·         Created different KPI’s using Table calculations and calculated key figures (Manipulating strings, arithmetic calculations, aggregation options and Logical functions)

·         Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines.

·         Expertise in working with data building Groups, Hierarchies and sets.

·         Mastered in different Formatting techniques, using Annotations and Mark labels.

·         Developed effective and interactive Dashboards using Parameters and Actions

·         Strong Dashboard design experience and passionate practitioner of effective data visualization.

·         Familiarity with best practices around visualization and design.

·         Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

·         Scheduled extract refresh and subscriptions.

·         Assisting users with questions and issues using Tableau.

·         Working with various infrastructure teams and Tableau support team to help improve dashboard response time.

·         Advocate the use of Tableau solution and help educate business users to facilitate early adoption of the tool.

·         Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.

·         Ability to work effectively in team environment and interact with all levels of management.

 

ENVIRONMENT: Tableau Desktop v8, Tableau Server v8, MS Excel, MS SQL Server 2012 , Win Server 2008 R2, Active Directory, Informatica Power Center 9.X.

 

 

CLIENT: Glaxo Smith Kline - India

DURATION: January 2011 - November 2011

ROLE: SQL Developer

A science-led global healthcare company with a special purpose to help people do more, feel better, live longer. There are 3 global businesses that research, develop and manufacture innovative pharmaceutical medicines, vaccines and consumer healthcare products.

RESPONSIBILITIES:

·         Involving in calls with customer and discussing about status and new requirements of the project.

·         Extract the data from various sources like SQL Server, Text files, and access into Data Warehouse.

·         Created SSIS packages to populate data from various data sources.

·         Optimize query performance by creating indexes. 

·         Involved in writing SQL batch scripts. 

·         Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL 
Queries and Stored Procedures. 

·         Involved in merging existing databases and designed new data models to meet the requirements. 

·         Create joins and sub-queries for complex queries involving multiple tables. 

·         Install and Configured SQL Server 2008 on development server for designing and testing. 

·         Created story showing the performance of each sales rep since sales territory assignment.

·         Developed reports for different sales management hierarchies. 

·         Collaborated with fellow team members through Team Foundation Server (TFS) for effective project management, which includes work issues and track on the update of versions.

 

ENVIRONMENT: Microsoft Power BI Power, SSIS/SSRS, T-SQL, MS Office 2007, SQL Server 2008, Ms Excel.

 

CLIENT: Dr. Reddy's Laboratory - India

DURATION: Feb 2008 - Dec 2010

ROLE: SQL Developer

         Dr. Reddy’s Laboratories Ltd. is an integrated pharmaceutical company, committed to providing affordable and innovative medicines for healthier lives. Through its three businesses - Pharmaceutical Services & Active Ingredients, Global Generics and Proprietary Products. The project was to load data into data warehouse tables using T-SQL and SSIS 2008 R2. Responsible to rewrite the significant number of its existing data extract and ETL process to use SSIS and data source.

 

RESPONSIBILITIES:

·         Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.

·         Written stored procedures and SQL scripts in SQL server implement business rules for various clients.

·         Written T-SQL queries for the retrieval of the data.

·         Writing and debugging T-SQL, stored procedures, views and user defined functions.

·         Data migration (import & export – BCP) from text to SQL Server.

·         Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.

·         Error handling using Try-Catch Block.

·         Normalization and De-Normalization of tables.

·         Developed backup and restore scripts for SQL Server 2008.