Tableau Developer/admin Resume
Madison, WI
SUMMARY:
- Tableau/BI Developer with Over 7+ Years of IT Experience in Business Intelligence and Data Warehousing applications in Retail, Financial, Health Care, Pharmacy and Manufacturing industries.
- Extensive knowledge in Dimensional data modeling, Star Schema, Snow - Flake Schema, Normalization, Physical and Logical modeling.
- Good understanding of Tableau Desktop architecture for designing and developing dashboards.
- Expertise in creating dashboards, reports, reporting and analytic applications and tools to drive sales and revenue growth
- Utilized all Tableau tools including Tableau Desktop, Tableau Public, and Tableau Reader extensively
- Extensive experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.
- Wrote SQL scripts and queries to extract data from various data sources into the BI tool, Visualization tool, and Excel reports
- Built and expanded reports available for both internal support and external customer/carrier reports, which included increasing the scope of data extracted and utilized for reporting purposes
- Created numerous ad-hoc analysis, dashboards, reports, graphs, and charts
- Experience with analysis, data, databases, and business intelligence
- Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables
- Excellent in applying Actions and Quick Filters
- Expertise in Data Warehouse development working with Data Migration, Data Conversion, and (ETL) Extraction/Transformation/Loading using Data Integrator with DB2 UDB, Oracle, and SQL Server.
- SQL Server and Oracle Database development experience using tables, triggers, views, packages and stored procedures in PL/SQL & T-SQL. Strong RDBMS fundamentals.
- Worked extensively with Business Objects Data Integrator to create complex Data Flows using Query, Table comparison, lookups and all transformations.
- Experienced in managing, monitoring and investigating cases such as trouble tickets from customers and fixing the issues
- Hands on experience with reporting tools BOBJ, Crystal Reports, and Xcelsius.
- Exposure to Full Life Cycle Solution Development (Requirement gathering, Analysis, Design, Development, Documentation, Testing and User training)
- Ability to handle multiple tasks and work independently as well as in a team.
TECHNICAL PROFICIENCIES:
ETL/BI Reporting Tools: Tableau Suite of Tools 8.1, 8.0. 7, 6, 5.1 which includes Desktop, Server, online and Public and Administration of Tableau Server and SAP Business Objects XI R2, XIR3.
Databases: MS SQL Server 2000/2005/2008/2008 R2/2012, MS Access 2000, Oracle 11g/10g/9i/8i/8.0.
Programming Languages: SQL, TSQL,PL/SQL, Java, C and C++
Operating Systems: UNIX, Linux, Ubuntu and Windows
Application Servers: WebLogic, WebSphere
Web Services & XML: SOAP, WSDL, XML, and XSLT
Scripting Language: JavaScript, JQuery
WORK EXPERIENCE:
Confidential, Madison, WI
Tableau Developer/Admin
Responsibilities:
- Responsible for interaction with business stakeholders, gathering requirements and managing the delivery.
- PreparingDashboardsusing calculations, parameters, calculatedfields,groups, sets and hierarchies in Tableau.
- Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
- Used Sheet filters to produce multiple chart types in a single view.
- Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
- Foundefficientways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
- Building,publishingcustomizedinteractivereportsanddashboards,reportschedulingusingTableauserver.
- Creating users, groups, projects, Data connections, settings as a tableau administrator.
- Ad-hoc ETL, Reports requirement runs.
- InvolvedincreatingdashboardsandreportsinTableau8.1andMaintainingserveractivities, user activity, and customized views on Server Analysis.
- Createdorganized,customizedanalysisandvisualizedprojectsanddashboardstopresenttoSeniorLevel.
- Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
- Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
- Created visualization for logistics calculation and department spend analysis.
- Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
Environment: s: TableauDesktop8.0/7.0, Tableau server/Administrator, SQL developer, SSIS, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office.
Confidential, Dallas, TX
Tableau Developer/Admin
Responsibilities:
- 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 reports and dashboard using KPI’s.
- Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
- Installed Tableau Server 7.0 in Dev, QA, UAT and Prod environments.
- Installed patches on the server and documented upgrade plan from tableau 8.0 to 8.1
- Administered user, user groups, and scheduled instances for reports in Tableau.
- Hands-on development on assisting users in creating and modifying worksheets and data visualization dashboards.
- Create, customize & share interactive web dashboards in minutes with simple drag & drop Expert in generating complex, dashboard reports, adhoc, business views along with user acceptance test and data accuracy test..
- Access dashboards from any browser or tablet.
- Created incremental refreshes for data sources on Tableau server.
- Coordinated database middleware issues with DBA's, system performance with System Architects.
- Involved in license management SLA's with Tableau support.
- Converted existing Crystal Reports and Celsius into Tableau Dashboards
- Defined and created procedures to install Tableau desktop in silent mode.
- Defined best practices for Tableau report development.
- Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
- Provided 24/7 production support for Tableau users
Environment: TableauDesktop8.0/7.0,Tableauserver/Administrator,SQLdeveloper, SSIS, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007
Confidential, Houston, TX
Tableau Developer/Admin
Responsibilities:
- Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
- Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
- Implement infographics and Dash boarding for data visualization.
- Interact professionally with a diverse group of professionals in the organization, including managers and executives.
- Experience 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.
- 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.
- Involved in license management SLA’s with Tableau support.
- Defined and created procedures to install Tableau desktop in silent mode.
- Defined best practices for Tableau report development.
- Provided 24/7 production support for Tableau users.
- Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
- Experience in converting OBIEE content into Tableau BI content.
- Experience in providing Tableau server and tableau desktop training.
- Experience with Teradata.
- Experienced with trouble shoot of Teradata connection.
- Testedreportsanduploadedtableaudashboardsontoserverandprovidedproductionsupportfortableau users.
Environment: s: Tableau server/Administrator, Tableau Desktop v6/v7, Windows Server Standard R2, Oracle 11i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL.
Confidential - New York, NY
PL/SQL/Report Developer
Responsibilities:
- Coordinate with the application team (Java developers) to provide them with the necessary Stored Procedures, functions and packages (Stored Procedures, Functions, Cursors, Ref cursor) and the necessary insight into the data.
- Resolved functional issues in business processes through enhancements.
- Converted business logics to logical and then physical design of database systems.
- Performed tuning and optimization on SQL queries using analyze, explain plan, TKPROF utility, SQL Trace and optimizer hints.
- Extensively used SQL*Loader to load data from flat files obtained from various facilities every day.
- Generated server side PL/SQL scripts for data manipulation and validation and created various materialized views, global temporary table.
- Generated scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, Stored Procedures, roles and granting privileges.
- Handled PL/SQL compile-time, runtime errors, and debugging Stored Procedure for business logic modification, granting and revoking Schema Object privileges and roles, responding to system events through triggers.
- Used nested tables, varrays/associative arrays, string indexed, nested collections; wrote PL/SQL programs using collections and compared associative arrays to collections.
- Involved in data loading using PL/SQL and SQL*Loader, external tables and Kron jobs calling Unix (AIX) scripts to download and manipulate files.
- Developed automated Korn Shell Scripts to schedule the load of flat files on daily, weekly and monthly basis.
- Responsible for gathering the requirements for creating data models for data analysis and reporting.
- Regularly analyze review the Crystal Reports developed and make enhancements to them if recommended by the user.
- Developed cross tab reports, sub reports by using Crystal Reports version XI.
- Performed integration testing for checking complete functionality of various modules.
- Participated in daily status meeting to report any bugs, issues and risks.
- Provided 24*7 production supports for complex modules.
Environment: Oracle 10g, SQL*Loader, TOAD, PL/SQL, SQL*Plus, Erwin, Crystal Reports XI, SQL Server 2005, APEX, UNIX, Perl, Clear Case (Version Control), Clear Quest, Windows 2000/XP.
Confidential
PL/SQL Developer
Responsibilities:
- Developed PL/SQL Packages, Procedures and Functions for Various Extract Process run through UNIX Jobs.
- Coded PL/SQL Packages and Procedures using Bulk Binding, for all Statements, DynamicSQL and Cursor Variables.
- Tuned PL/SQL Packages and Procedure to manipulate large no of data using collections like nested tables and arrays.
- Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.
- Created Schema Objects like Tables, Views, Materialized views, Sequences, Constraints, and Indexes.
- Developed and Deployed Traders Oracle REPORTS in Oracle Application Server 9i.
- Generated Oracle FORMS and REPORTS using Designer 6i.
- Designed and Developed Reports using Oracle Discoverer 9i.
- Improved Performance of Discoverer Reports using Materialized views.
- Developed UNIX Shell Scripts for Autonomous Jobs.
- Experience in developing logical and physical database design, data modeling using Erwin.
- Provided Productions support and ongoing user support for the application.
- Designed Development Documentation and Support Documentations.
Environment: Oracle10g, Oracle FORMS/REPORTS (10g), Designer10g, TOAD, Oracle, Application Server 9i and UNIX.
Confidential
SQL DEVELOPER
Responsibilities:
- Perform database consistency checks at regular intervals.
- Monitor SQL Server activity through Profiler.
- Developed stored procedures used by application developers for displaying reports.
- Modified existing database by adding tables and establishing the relationships using constraints.
- Created Data Models using Erwin tool.
- Created several stored procedures to Archive the old data in the database.
- Wrote custom T-SQL Stored procedures to improve performance, preserve referential integrity, and provide additional application functionality for maintaining hierarchal data.
- Created SSIS Packages.
- Knowledge of Database Performance Monitoring tools.
- Migration from SQL Server 7.0 to SQL Server 2008
- Maintained and improved high availability and disaster recovery strategies for the database and fail-over methods.
- Developed reports using complex formulas to query the database to generate different types of ad-hoc reports using Crystal Reports.
- Experience working with ASP.NET as frontend team.
- Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
- Scheduled jobs for Backup, and created alerts for error reporting.
Environment: SQL Server 2008 Enterprise Edition, T-SQL, Excel, Erwin, Windows 2008/XP, Visual Studio, Crystal Reports.