Candidates About

 

Sahithi

Professional Summary:

ü  8+ Years experience working with Business Intelligence data visualization tools with specialization on Tableau […]

ü  3+ years of extensive experience in Full Life Cycle Development including Analysis, Design, Implementation and Maintenance of different analytical applications using QlikView suite of Products (QlikView Server, Publisher and QlikView Enterprise).

ü  As a Tableau Developer, responsible for creating wonderful visualizations to help clients to take their decisions.

ü  2+ years of experiences in Database Design, Development and business intelligence of Microsoft SQL Server 2012/2008R2/2008/2005/2000 in Development, Test and Production Environments with various business domains.

ü  Consistently delivered results in various stages of Software Development Life Cycle (SDLC).

ü  Have been working with various data sources such as Oracle, SQL Server, ODBC and flat file sources

ü  Extensive experience in Business and Data Analysis along with 4 years of data visualization using Tableau Desktop.

ü  Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.

ü  Tableau tools include Tableau Desktop versions and recent implementation of 8.2, Tableau Server, Tableau Public, and Tableau Reader.

ü  Administered user, user groups, and scheduled instances for reports in Tableau. Installed patches on server and documented upgrade plan form Tableau 8.0 to Tableau 8.1

ü  Extensive Knowledge of Tableau Server Concepts like tabcmd, tabadmin, creating users, sites and projects.

ü  Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.

ü  Experienced on generating various dashboards in Tableau server using various sources such as Teradata

ü  Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, calculations and Relationships.

ü  Having knowledge on gather business requirements and translate them into reporting needs.

ü  Recommending Dashboards per Tableau visualization features and delivering reports to Business team on timely manner.

ü  Successfully upgraded Tableau platforms in clustered environment and performed content

ü  Established Best Practices for Enterprise Tableau Environment and application intake and Development processes.

ü  Designing, Developing and supporting interactive Tableau Dashboard reports.

ü  Experience in Marks, Publisher, Security concepts, creating Worksheets and Dashboard using Tableau.

ü  Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence applications.

ü  Knowledge of Data warehouse Concepts and methodologies.

ü  Expertise in identification of Business and Data requirements and converting them into conceptual and logical data models.

ü  Expertise in working with diverse business users to understand the requirements and develop a robust data model that will support the current requirements and future business growth utilizing Agile Methodology.

ü  Strong Knowledge in designing and developing Data marts, Data Warehouse using Multi-dimensional models such as Snow Flake and Star Schema.

ü  Expertise in Installing and Configuring QlikView Server and Publisher with QlikView web server in both clustered and non-clustered environments.

ü  Experienced in configuring Authorization on QlikView Server both NTFS & DMS.

ü  Strong experience in Scripting, developing and designing dashboards using QlikView by extracting data from multiple sources (SAP BW, Teradata, Oracle, SQL Server, Flat files, Excel, Access).

ü  Extensively used different QlikView features and scripting statements (Different Load Techniques, Keep, Join, Concatenate, Apply Map, Set Analysis, Drill Down Groups, Cyclic Groups and Actions)

ü  Implemented data level security using Section access that hides selected areas of the dashboard & filters data dynamically depending upon user privileges.

ü  Developed Unified QlikView Dashboard's and worked with various sheet objects like list boxes, bar charts, combo charts, radar charts, pie charts, straight table, pivot table, container, current selection box, Search and so on.

ü  Extensive use of advanced QlikView features like Alternative State, Incremental Load, Interval Match, Link Table, Document chaining and so on.

ü  Extensive experience with data modeling techniques, logical and physical database design.

ü  Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS). 

ü  Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.

ü  Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000 to 2005/2008/2008R2/2012.

ü  Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.

ü  Experience in created complex Reports as per business requirements and migration of SSRS reports from SQL 2018R2 to SQL 2012

ü  Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.

ü  Experience in ETL development using SSIS Packages, enhancing and deploying the SSIS Packages from development server to production server.

ü  Outstanding knowledge of high availability/DR SQL Server solutions, including Log shipping, Mirroring and Replication

 

TECHNICAL SKILLS:

BI Tools	Tableau Desktop, Tableau Server, Tableau Public, Tableau Reader, Tableau Online, Informatica Power Centre
Database	SQL Server, Oracle 11i/11g, MS Access, Lotus notes, Kognitio
ETL Tools	Tableau Desktop, SSIS
Other Tools and packages	SQL Server Management Studio, Microsoft Visual Studio, Microsoft Office, MS Visio, SQL Developer
Languages	SQL, T-SQL, C, C++, Java, HTML, XML, Java Script, J2EE
Reporting Tools	Tableau, SSRS
OLAP Tools	SSAS
Operating Systems	Windows [ ] 2008 Server, Windows [ ]

 

Professional Experience:

Tableau Developer

Charter Communications, CO                                                                                  Jan’ 2017 – ongoing

Responsibilities:

ü  Assisted in complete Life Cycle including Design, Development and Testing

ü  Created Sub Reports, Parameterized and Drill down Reports based on the requirements provided

ü  Deployed the generated reports onto the report server.

ü  Formatted the reports using the Global variables and expressions.

ü  Designed and Developed matrix, tabular, parametric and Sub Reports in the SQL Server Reporting Services 2012.

ü  Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, Fast Export, T pump, Visual Explain, Query man) and Teradata parallel support.

ü  Created Parameterized reports, Cross-Tab reports, Drill down reports& Summary reports by using SSRS using SQL Server.

ü  Deep experience with the design and development of Tableau visualization solutions.

ü  Background in installing and upgrading of Tableau server and server performance tuning for optimization.

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

ü  Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

ü  Proficient in coding of optimized Teradata batch processing scripts for data transformation, aggregation and load using BTEQ.

ü  Defined best practices for Tableau report development.

ü  Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

ü  Preparing Dashboards using calculations, parameters in Tableau.

ü  Understanding of relational database structures, theories, principles, and practices.

ü  The ability to interact professionally with a diverse group, including executives, managers, and LOB.

ü  Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.

ü  Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while maintaining the accuracy of the core information content that is being communicated

ü  Involved in license management SLA's with Tableau support.

ü  Defined and created procedures to install Tableau desktop in silent mode.

ü  Extensively used Tab admin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

ü  Proof-read all documents and maintain accuracy of information and preparing SOP.

ü  Responsible for Developing a Dashboard and preparing ad-Hock Reporting.

ü  Managed and created and altered Databases, Tables, Views, Indexes, Constraints with business rules using T-SQL

ü  Developed complex Stored Procedures, Triggers, User Defined Functions based on the requirement

 

Environment: Tableau Server 7.0, Oracle SQL Developer, SQL server, HPQC, Oracle 11g, java 1.5 platform, Teradata, Microsoft office 2007, Business objects, SQL, PL/SQL, T-SQL.

Tableau developer

Michaels, TX                                                                                                                                  Feb ‘2016 – Nov‘2016

Responsibilities:

ü  Actively involved in gathering requirements from end users, involved in modifying various technical &amp, functional specifications.

ü  Analyzed various reports, dashboards, scorecards in Micro Strategy and created the same using Tableau desktop server.

ü  Mentored business power users to create reports/dashboards using tableau desktop.

ü  Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

ü  Utilized advance features of Tableau software like to link data from different data sources together on one dashboard to filter data in multiple views.

ü  Involved in new KPI generation for Scorecards.

ü  Data collection and leveraging on data manipulation teams for required data.

ü  Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.

ü  Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

ü  Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.

ü  Effectively used data blending, quick filters, actions, hierarchies' features in tableau.

ü  Executed and tested required queries and reports before publishing.

ü  Converted Metric insight reports to tableau reports.

ü  Analyzed the data using statistical features in tableau to develop Trend Analysis reports.

ü  Experience in assisting users in creating and modifying worksheets and data visualization dashboards.

ü  Scheduled frequency and time to refresh data for the data sources are publishes or extracted to server.

ü  Design and development of various reports and dashboards that can be easily accessible through Tableau App in IPad, IPhones, and other smart mobile phones.

 

Environment: Tableau 7/8.2 Desktop, Tableau server, Oracle 11i, SQL, SQL*Plus, TOAD, Windows 2003/ XP, UNIX.

Tableau Developer

Baker Hughes, Houston - TX.                                                                                                      Jun’ 2014–Nov‘2015

Responsibilities:  

ü  Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.

ü  Exposed to data conversion from different data sources to SQL Server 2012 using SSIS.

ü  Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server 2012.

ü  Experience in developing and monitoring SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS),

ü  Developed and maintained graphs, tables, slides and document templates for the efficient creation of reports.

ü  Interacted professionally with diverse group of professionals in the organization including managers and executives.

ü  Experienced in standardizing Tableau for shared service deployment.

ü  Developed Standard Operating Procedures (SOP) for Monitoring.

ü  Extensively used data blending, embed functionalities in Tableau.

ü  Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.

ü  Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.

ü  Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots,

ü  geographical maps, Gantt charts using show me functionality.

ü  Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.

ü  Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPIs.

ü  Gathered user requirements, analyzed and designed software solution based on the requirements.

ü  Interacted with Business Analysts and Data Modelers and defined Mapping documents and ➢ Design process for various Sources and Targets.

ü  Defined best practices for Tableau report development and effectively used data blending feature in tableau.

ü  Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.

 Environment: Tableau Server 7.0, Oracle SQL Developer, SQL Assistant, Oracle 11g, java 1.5 platform , Teradata, Microsoft office 2007 , Business objects, SQL, PL/SQL, T-SQL.

Qlikview Developer

Mind Tree, India                                                .                                                               Jan 2013 – May’ 2014

Responsibilities:

ü  Involved in gathering & Analyzing business requirements.

ü  Designed ECD Convergence Dashboard which gives user to rate customer and their status.

ü  Implemented Star schema data modeling, Removed complex synthetic keys in the existing data modeling of various dashboards.

ü  Worked extensively on the SQL Server/MYSQL databases and imported SQL scripts into Qlikview.

ü  Implemented best practices of scripting and ensured that QV can handle millions of data without  performance issues.

ü  Ability to write VB script macros whenever required.

ü  Implemented security using section access that dynamically hides selected areas of the dashboard depending upon user privileges.

ü  Implemented Sheet level security to limit access based on user groups.

ü  Dynamically show/hide sheets, handled Null Values.

ü  Developed Macros which facilitates user to export large volume of data into Flat Files.

ü  Worked on complex aggregate functions and gave the desired output across the combinations.

ü  Created optimized QVDS which loads faster and helps to improve the performance.

ü  Experience with Qlikview functions like fabs, peek, previous, is null etc.

ü  Created pop up text box on button click which will prevent it working where user can navigate to that sheet only after making required selections in that page.

ü  Worked on enhancements and Performance tuning on existing dashboards.

ü  Provided User meetings and training on Qlikview Dashboard functionalities.

Environment: Qlikview 11.2, SQL server, Oracle, MY SQL, Toad, SQL Developer, Putty.

Qlikview Developer

Axis Bank, India                                                                                                                        Jun’ 2011 – Dec’ 2012

Responsibilities:

ü  Worked with the business units, identified and resolved the existing issues.

ü  Developed reports by connecting to Hadoop by using Cloudera connector which pulls data from the Hadoop into Qlikview.

ü  Proposed solutions such as incremental Qvds which helps to optimize the load on the database when there is a limit for 10 million rows.

ü  Automated various dashboards, publishing them to the server and also proposed best practices for the server installation.

ü  Developed SQL scripts and made required modifications to function in Hadoop Environment.

ü  Worked on Hive/Hue and tested various scripts in Hadoop before getting them into Qlikview.

ü  Worked on setting up the email alerts in the dashboard without pointing to server by writing a macro script.

ü  Proposed a solution for the date range issue where user wants to see only one week of data on default upon opening of a dashboard.

ü  Modified the scripts in DB2 which reduces the load on the database and optimized the performance.

ü  Imported data from different sources like DB2, SQL, and Hadoop.

ü  Added dimensions to the existing SEO dashboard which resulted to show and compare W/W (week over week), Y/Y (Year/Year) analysis by writing set analysis.

ü  Trained end users on using Qlikview.

ü  Experience in using Qlikview Functions (Date and Time, Keep, Join, peek, Fabs).

ü  Good experience in performance tuning and deployment.

Environment: Qlikview11/11.2, SQL server, DB2, Toad for DB2 5.0, Tableau 8.0, Hive 0.8, Business Objects 4.0

 

Bridle IT Solutions, India                                                                                        Jun’2009 -May’2011                      

SQL Server Developer/DBA

Responsibilities:

ü  Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

ü  Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).

ü  Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.

ü  Involved in deployment of SSRS reports on the SharePoint Portal.

ü  Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

ü  Wrote stored procedures to get the fields required for the reports.

ü  Created datasets using stored procedures and reports using multi value parameters

ü  Created sub reports, bar charts and matrix reports.  

ü  Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i

ü  Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse

ü  Created Triggers to enforce data and referential integrity.

ü  Defined Check constraints, Business Rules, Indexes, and Views.

ü  Configured Server for sending automatic mails to the respective people when a DTS process failure or success.

ü  Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.

ü  Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS

ü  Deployed the SSRS reports in Microsoft office share point portal server MOSS 2007.

ü  Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.

ü  Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.

Environment: SQL Server 2005 /2000, 64-bit edition of SQL server 2000), DTS, Crystal Reports, Microsoft Business Intelligence Development Studio, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS.