Data Reports
Resume:
Tejasiv
***********@*****.***
Professional Summary
Over 7 years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
Involved in Full Life Cycle Development of Reporting Projects, includes Requirements Gathering/ analysis, Design, Development, Testing and Production rollover.
Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
In-depth knowledge on Tableau Desktop and Tableau Server.
Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
Expert in Strong understanding of dimensional data modeling and strong SQL optimization capabilities.
Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting) using Tableau Desktop.
Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security.
Improved Reports performance in tableau using extracts and context filters.
Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables .
Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.
Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.
Technical Skills:
Database
Teradata, MS SQL Server 2005/2000, DB2, Oracle
Languages
SQL, PL/SQL, Teradata-BTEQ, TPT
Reporting Tools
Tableau 7.0, Tableau 8.0/8.1/8.3, Tableau 9.0
BI Tools
Tableau, Business Intelligence Development Studio (SSIS/SSRS)
Domains
Financial, Banking, Retail
Web Tools
HTML, DHTML, XML
Others
MS Word, Excel, VISIO 2007
Education: Bachelors of Engineering
GAP, San Francisco, California Aug 2014 – Till Date
Tableau Developer - Project and Portfolio reporting system
Responsiblities:
Gathered reports requirement and collaborated with business users using wireframe mockups
Worked closely with business power users to create reports/dashboards using tableau desktop.
Utilized complex SQL join statements to represent relationship between facts and dimensions
Computed margins using calculated field following pre-defined business rules
Modeled all the dashboards with appropriate filters for comprehensive analysis by portfolio, application and employee roles, timestamps and location
Generated groups for the application field to do category based analysis
Implemented hierarchies in Tableau with Portfolio as the highest level followed by application and project details
Created symbol maps to understand the geo-spatial distribution of projects with custom symbols made of represent the application category
Implemented sets to display Top N projects based on business defined conditions in a portfolio
Scheduled daily data extracts to enhance performance
Experience with creation of users, groups, projects, workbooks and appropriate permission sets for Tableau server authorization
Created symbol maps to understand the geo-spatial distribution of projects with custom symbols to represent the application category
Used Tableau workbook design, Tableau reports and dashboards design.
Environment: Tableau 8.0/8.2, SQL Server 2005/2008, MS Access database and MS Excel
Client: Bank of America, Charlotte, NC Apr 13- July 14
Rolle: Tableau Consultant
Responsibilities:
Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports
Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated through Tableau desktop.
Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
Publish Tableau workbook to cloud and schedule the refresh of data. Specialized in analyzing the incremental refresh scenarios.
Participated in preparing detailed technical documents from the functional specifications.
Created Global Filters and applied for all the views in the dashboard.
Created Data Source and published into the server for other users.
Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
Executed and tested required queries and reports before publishing dashboards.
Created Tableau scorecards, dashboards, Heat maps using show me functionality.
Created complex data Views manually using multiple measures also used Sort, Filter, Group, Create Set functionality.
Published Reports, workbooks & data source to server and exporting the reports in different Formats.
Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards
Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Indicators (KPI) and Measures.
Environment: Tableau Desktop 8.1, Tableau server / Administrator, SQL developer,, Oracle 10g, DB2, Microsoft
Excel 2007, MS Access, Windows 2007 server.
Client: Target, Minneapolis, MN Jan 11 – Mar 13
Role: Tableau Consultant
Responsibilities:
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Upgraded tableau 7.0 to tableau 8.0 and gathered requirements, analyzed from raw data.
Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
Worked on Motion chart, Bubble chart, Drill down analysis using tableau desktop for Amazon.
Involved in created stored procedures, views, and custom SQL queries to import data from SQL server to tableau.
Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
Ability to work quickly and under tight delivery deadlines with focus on details.
Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.
Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
Environment: Tableau Desktop 8.0/7.0, Tableau server / Administrator, SQL developer, SSAS/SSIS, Oracle 10g,
DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007
Progressive Insurance, Mayfield, OH Oct 2009 - Dec 2010
SQL/ BI Developer
Responsibilities:
Designed, Coded, Tested, Implemented the Stored Procedures to support the System.
Fixed bugs in the existing in-house developed Software which is used to upload the reports for the end users to view the reports.
Designed, coded and tested several T-SQL Queries to Support the System.
Fixed bugs in the software that was used to support the healthcare system.
Designed, Coded, Tested, Implemented Stored Procedures to get data for the reports.
Designed the reports using Crystal reports And SSRS to create reports for the end users.
Created ad-hoc reports, drill down, and drill through reports using Crystal Reports and SSRS.
Scheduled meetings with the end users and business owners and gathered requirements for the system.
Developed triggers on tables to support the system.
Created and configured SQL mail to send mail as events occur.
Used the SQL profiler to trace the data and thus troubleshoot effectively.
Worked on SQLSMS to grant other users the rights to the needed stored procedures and table as required.
Environment: SQL Server 2008, MS Visio, Erwin Visual studio 2008,NET Framework, PowerBuilder, Crystal reports, SSRS.
Vertex Computer Services, Hyderabad, India Apr 2008- Aug 2009
SQL Data Analyst
Responsibilities:
Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
Designed Web-based Internet applications linked to firm-wide SQL databases.
Creating and debugging of packages and procedures and functions and troubleshoot jobs using the debugging tool.
Involved in analysis, coding, testing and Implementation of various modules and reverse engineering of the application using Erwin. Used Erwin to transform data requirements into data models.
Used PL/SQL for creating database objects, running the command scripts for inserting the configuration data items.
Automated data loading, extraction, reports generation using UNIX Shell scripting and loading data using SQL* Loader to custom tables
Worked on materialized views, DBMS_SCHEDULER for scheduling jobs and UTL_MAIL to send mails using oracle 10g.
Implemented shell scripts for trouble shooting Oracle Errors with the help of trace files and scheduled them.
Tested any changes to the system and ensured that the changes are according to the specifications.
Environment: Oracle 10g, PL/SQL, SQL* Loader, MS Excel, UNIX Shell scripting
.
Contact this candidate