Candidates About

 

Vamsi Krishna

    BI-Tableau Developer

                                                                                                                                           

• Over 8+ years of IT experience Specialized in Data visualization, Dash board Development, Implementation, testing of software applications to support reporting and Business Intelligence Initiatives.
• Extensively worked on various Tableau desktop 7.x/8.x/9.x/10.x versions, Tableau Server, Tableau online, Tableau reader.
• Experience in creating rich interactive visualization reports and dashboards in Tableau Desktop and server utilizing LOD, Filters, Actions, Parameters, sets, Groups, Extracts, Data Blending, Page Trails.
• Extensively involved in the development of various interactive dashboards and reports such as Dual Axis, Pie-charts, Heat Maps, Waterfall Charts, Funnel Charts, Bar Graphs, Bubble charts, Box plots, Tree Maps.
• Extensive experience in publishing Tableau dashboards to Tableau Server.
• Extensively involved in creating users, user groups, roles, scheduled instances for reports in tableau server.
• Extracting data from data sources like Salesforce, SQL server and Excel files for getting data to Tableau for creating various dashboards.
• Worked with various teams in gathering user needs and documenting them in business requirement documentation.
• Extensively involved in Unit, System, User Acceptance Testing also involved in performing data validation for the dashboards that are generated from various data source.
• Worked on MS Visiofor database design and development of Entity Relationship Diagrams.
• Effectively utilized various Tableau features such as Dashboards, Stories, Quick POCs and worked with senior managements in analyzing the data trends, well utilized future forecasting option.
• Solid understanding on Microsoft SQL Server Integration Service(SSIS), SQL Server Reporting Service, MS Access, MS Excel, MySQL.
• Proficient in developing Stored Procedures, Triggers, User Functions, SQL joins, Sub queries.
• Excellent knowledge in developing Drill down and Drill through reports in SQL Server Reporting Services.
• Extensively worked on various filters such as Data Source filter, extract filter, Context filter, Measure filter and global filter.
• Extensively involved in performance tuning of reports and involved in resolving issues related to tableau server.
• Experience in report development, testing and publishing on to Tableau Server.
• Experience in Creating Users, Groups and Projects on Tableau Server, Involved in Tableau server upgradation activities.
• Experience in data modelling techniques like Snowflake Schema, Star schema, Fact, and dimension tables.
• Strong knowledge of Software Development Life Cycle(SDLC) methodologies like waterfall, Agile.
• Strong Individual contributor, good team player, problem solving skills, ability to work under pressure, fast learner.

 

Skills:

Reporting Tools	Tableau 10/9.4/9.2/8.x/7.x, SSRS
ETL Tools	SSIS
Databases	My SQL, SQL Server, Oracle 10g/ 11c/9i/8i,AWS Redshift.
Data Warehousing Modeling	Snow flake schema, star schema, Fact Tables, Dimension Tables
Operating Systems	Windows, Unix, Red Hat Linux
Programming Languages	SQL,PL/SQL, JAVA, UNIX
Other Tools	TOAD, MS OFFICE, MS visio, Jira,HP ALM, Quality center

 

 

 

 

 

NBCUniversal, New York city, NY                                                                         Feb 2016 to Current

Sr. Tableau Developer                                                                                                

NBCUniversal is a multinational media conglomerate, primarily involved in media and entertainment industries, Project involved in building reports for various units i.e. cable television networks, film studio, pay television outlets.Data sources including SQL Server and Excel.

 

·         Responsible for conducting requirements gathering sessions with corporatesenior information risk officer, Information Risk Management Teams.

·         Prepared Business use cases and converted it into analytical use cases for conceptualizing Tableau dashboards with the captured ADAP data stream.

·         Used Data blending to join the Data stream from various heterogeneous data sources to get the desired mapping.

·         Implemented row level, column level, and table level calculations in generating tableau reports and dashboards.

·         Extensively utilized Level of detail(LOD) expressions like include, fixed, and Exclude to create visualizations that are different from view level.

·         Using Data Blending Developed Tableau workbooks from various data sources.

·         Developed Tableau data visualizationusing Heat Map, Tree Map, Area Chart, Scatter plots, Bar Chart, Stacked Bars, Bullet Chart, Area Chart, Scatter plot, Gantt chart, Donut chart, Pie Chart.

·         Performed Comparison analysis via combination of Line/Bar charts, Line/Line Charts using Tableau dual axis feature.

·         Creating users, groups, projects, Data connections, settings as tableau administrator.

·         Worked on creating the dashboards for weekly, monthly, daily reports using tableau Desktop.

·         Used Complex SQL queries at Meta data window to restrict the data source to only useful ones.

·         Used Data source filter, context filter for restricting visualization to desired data set, used filter action for further drill-down from one worksheet to another.

·         Performed the Sentiment analysis, time series analysis, Trend analysis with created visualizations.

·         Extracted data from various data sources such as SQL server, Excel files, Salesforce to create Tableau dashboards.

·         Acted as Tableau coach in migrating the data from various data sources to Tableau Dashboards.

·         Involved in scheduling tasks and then checking the tasks on the server on daily basis.

·         Publishing the dashboard to the Tableau Server to share the reports with the business users.

·         Published the Created Tableau Dashboard to development server and then subsequently to QA and Production server.

·         Performed web authoring of published Tableau content and edited reference line distribution.

·         Thoroughly supported the end users for further custom enhancement in line with Line of Business (LOB) requirement.

·         Continuous improvement of dashboard design to increase data visibility and provide improved insights through Cross-sectional analysis, drill-able insights and self-explanatory report structures and visualizations.

·         Proficient in designing and creating various Data Visualization Dashboards, worksheets, and analytical reports to help users to identify critical KPI.

·         Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository. 

·         Performance Tuning of Dashboards and working with users and Database teams for design review and modeling.

·         Documented the requirements, conducted walk-through sessions with development team.

·         Performed Functional Acceptance Testing, Facilitate User Acceptance Testing with CSIROs and IRM Teams, Facilitate production moves.

Environment: Windows XP, Tableau 10.3, Tableau server, MS Excel, MS word, Jira, SQL server, SQL.

 

Trident Maritime Systems, Crozet, VA                                                                    Nov 2014-Jan 2016

Tableau Developer                                                                                                        

Trident’s main focus is bringing value through the best engineered solutions in marine interiors, distributed ship systems, electromechanical solutions, and automation and control, designed tableau Dashboards and presented to each department.

·         Used best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel.

·         Developed custom designed dynamically chart selection driven dashboard which shows 10+ data visualization in a single dashboard.

·         Indexed all columns whichever are part of Tableau Table Join/Filter operation to ensure improved time efficiency.

·         Used union table feature in Tableau during the Meta data connection window to leverage database structure and schema.

·         Created multiple visualizations using Bubble chart, Bar chart, Line chart, Pie Chart, Donut chart, Scatter plot, Gantt Chart, side by side Bars, side by side circles, packed bubbles, Histograms, Filled geo-maps, Symbol geo-maps.

·         Used Ranking feature in Crosstab worksheet to highlight the Top N ranks of custom chosen dimension based on specific measure.

·         Created multiple story to describe systematic data analysis with areas of data security risks.

·         Data Pulse Reports are used to analyze volume of Applications across sectors and their usage in terms of frequency and duration.

·         Ensured precision and maintained sanity for data table calculation using the Tableau partitioning and addressing feature.

·         Used the Analytics tab in Tableau and performed the forecasting feature to predict the portfolio composition in user holding in line with historical data.

·         Published the created dashboard in production server and maintained load balancing feature on.

·         Implemented advanced geographic mapping techniques and use custom geo coding to build spatial visualizations of non-geographic data.

·         Transformed massive datasets through grouping, aggregation, and Complex table calculations.

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

·         Used advanced Tableau features including calculated fields, parameters, table calculations, row-level security, joins, data blending, and dashboard actions.

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

·         Created Tableau Dashboards with interactive views, trends, and drill downs along with user level security.

·         Responsible for Publishing the desktop version dashboard to the server and maintenance of server activity (Versioning, Data extract refreshing via server scheduler).

Environment: Windows XP, Tableau 9.0, Tableau Server, SQL, MS-SQL 2008, MS-Access, MS Excel and Salesforce.

 

 

Arthrex, Naples, FL                                                                                                 Sep 2012- Nov 2014

 

SQL/Tableau Developer                                                                                              

Arthrex, a global device company and leader in product development and medical education in orthopedics, with corporate mission of helping surgeons treat their patients better, prepared financial reports as per the demographics.

·         Created the Analytical visualizations based on the AIP data to provide the clear discrimination of in-scope vs. Out-of-scope Applications and Active vs. inactive Applications across Organization down to various departments.

·         Responsible for conducting requirements gathering sessions with business and prepared high level functional specification document for the application.

·         Created Financial reports, Demographics. This report explains the Company profit and employee relationships and we calculated using norm for comparison. 

·         Used Context filters and Created Geographic map reports which explains the company financial keys according to the members. 

·         Created custom joins through calculations to bring multiple heterogeneous data source together.

·         Used advance analytics features Reference line, Reference band, Distribution band, Trend lines in creation of Tableau dashboard.

·         Responsible for tracking defects and issue raised by the business users and communicating the same to developers.

·         Participated in change request session with business users and conveying the same to developers with functional document; and tracking the progress of change request with Jira.

·         Responsible for the gap analysis during the assessment phase of changes.

·         Published the dashboard to the server and maintained the server sanity with the use of in Tableau in memory feature and load balancing standards.

·         Tuned the database after publishing content to Tableau server.

·         Supported the Published Tableau dashboard while migrating to newer versions.

Environment: Tableau Desktop 8.2/8.0/7.0, Tableau Server, SQL Server 2008/2012, PL/SQL, MS-Access, MS Excel and SQL.

 

 

 

ePromos, Pompano Beach, FL                                                                           Jan 2011- Aug 2012

SSIS/ SSRS Developer

ePromos offers the best promotional products, promotional, items, and custom logo-imprinted

      gifts, trade show giveaways, and corporate apparel online.

·         Involved in gather the business requirement documentation and converting that documentation into functional design documents.

·         Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.

·         As per the business requirements created complex stored procedures, Triggers, User-defined functions, Queries.

·         Created SSIS packages using Pivot transformation, Fuzzy Lookup, Conditional Split, Term Extraction, Aggregate, Execute SQL Task, Data Flow Task, 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.

·         Designed and tested packages to extract, transform and load data(ETL) using SSIS, designs packages which are utilized for tasks and transformations such as Execute SQL Task, Mapping the right and required data from source to destination, Data Flow Task, Data conversion, Foreach Loop container.

·         Intensively worked on transformations like derived columns, import columns, Export column, Row count, Union all, Copy column, Lookup, Data Conversion with SSIS.

·         Created Drill-down and Drill-through reports, also scheduled and managed weekly/monthly inspection and violation reports based on the business requirements.

·         Designed and developed different reports like Matrix and Tabular reports, Cascaded, Parameterized, and pie chart reports using SQL Server Reporting Services (SSRS).

·         Deploying reports to reports server, proving features for reports to show in PDF format as per the requirement and printing all the reports in a batch process for monthly Statements. 

 

 

  HSBC, India                                                                                                           Aug 2009- Nov 2010

 Jr. SQL server Developer

Responsibilities:

·         Interacted with Team and involved in Analysis, Design and Developing databases using ER Diagram, Normalization, and relational database concepts. 

·         Involved in Design, Development, and testing of the system. 

·         Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan).

·         Applied Normalization rules in designing the database. 

·         Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.

·         Developed database objects like Tables, views, stored procedures, indexes etc. 

·         Tuned SQL statements using views and Stored Procedures. 

·         Rebuilding the indexes at regular intervals for better performance. 

·         Wrote various stored procedures for application development. 

·         Wrote SQL Scripts to select the data from the source. Designed and implemented data access stored procedures and triggers for automating tasks.

·         Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables. 

·         Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.

·         Creating and automating the regular Jobs. 

·         Tuned and Optimized SQL Queries using Execution Plan and Profiler.

·         Rebuilding Indexes and Tables as part of Performance Tuning Exercise. 

·         Involved in performing database Backup and Recovery.

 

Education

Bachelors in Computer Science, Acharya Nagarjuna University, India – May 2009