Sr. Bi/tableau Report Developer Resume Profile
San Jose, CA
SUMMARY
- Over 8 years of experience in all the phases of SDLC Design, Development, Integration, Implementation and Maintenance of MS Business Intelligence and Tableau Platforms.
- Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6/7/8.
- Solid experience of technical support in major financial institutions including Health Insurance, P C insurance, Banking, media and Utilities.
- Expertise in Tableau, MySQL, Teradata, Oracle, Qlikview, Informatica, COBOL, PL/I, EASYTRIEVE , CICS, DB2, SQL, XML, MS. Access, MS SQL server.
- Experienced on Tableau Admin activities, Multidimensional database and writing SQL queries.
- Hands-On, detailed-oriented Data Analyst, SAS Developer, and Data Miner
- Familiarity with web technologies like HTML, JavaScript is plus
- Extensive hands-on experience server level experience on Windows and Linux servers
- Strong experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server 2012, 2008, 2005 and 2000.
- Ability to use custom SQL for complex data pulls
- Experienced in Tableau Platform Dash boarding In-Memory OLAP processing
- Extensive experience in dealing with Relational Database Management Systems, including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
- Good Experience with Teradata and Semantic Views.
- Strong understanding of Finance, Operations, Call Center data and key metrics.
- Ability to write reports, and create visual data presentations.
- Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and/or concrete variables.
- Experienced in SQL Server Business intelligence tools like SQL Server Integration services SSIS , SQL Server Reporting Services SSRS
- Well versed in query optimization for performance tuning and monitoring of processes.
- Expert in creating universes on OLAP SAP BW, Oracle , SQL server, Teradata, DB2
- Extensive knowledge on visualization of data and knowledge of tools such as tableau.
- Worked on complex KPI scorecards, heat maps, tree views, circle views, bar charts etc... Data visualizations and interactive dashboard which helped business get a good handle on the team's productivity.
- Master in Tableau Charting, reusability, Leveraging variables and templates and building/deploying section access security models.
- Worked on different table calculations for different Scorecards.
- Published dashboards on Tableau public. Design and develop various reports and dashboards that can be easily accessible through Tableau App in I pads, iPhones, and other smart mobile phones.
- Worked closely with Tableau support team during tableau server upgrades to 8.1
- Worked on data blending and increased the dashboard performance by extracting data.
- Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings Workflows, Customized Analytics Reports.
- Deployed tableau server in clustered environment by adding worker machines.
- Broad experience in resolving universe issues like Loops and Traps using Alias and context.
- In-depth knowledge in building/maintaining Repository, Universes and creating adhoc reports.
- Working in both Semantic layers of Business objects like Universes and Business views as Data source for Crystal reports.
- Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
- Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
- Experience on data warehousing concepts, ETL tool Informatica.
- Good Independent / team working skills and experiences, excellent communication skills with very good customer handling capabilities.
- Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.
TECHNICAL SKILLS
Programming Languages | C, C , T-SQL, XML, Oracle, PL/SQL, COBOL |
Business Intelligence tools | Tableau, Business Intelligence Development Studio SSIS/SSRS , Informatica Power Center 7.1/8.6/9.1, Web intelligence, Xcelsius 2008 and Crystal Reports 2008 XI. |
Data Base | Server 2000/2005/2008/2008R2/2012, MS Access, Teradata, DB2, MS. Access, MS SQL server, SSAS, Oracle, Oracle Essbase, |
Operating Systems | XP, Windows NT / 2000. Windows Server 2003/2008/2008R2, Linux, iOS |
SDLC tools | Perforce, Team foundation Server TFS , HP Quality center |
Other Stored Procedures | DB2 Utilities, IBM utilities, Visio. |
ETL Tools | Informatica 8.6/9.0.1,SSIS 2005/2008, Cognos, Abinitio. |
PROJECT SUMMARY
Confidential
Sr. BI/Tableau Report Developer
Responsibilities:
- Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
- Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for BML eBay PayPal. Worked on various data sources such as Oracle, Teradata, SQL Server,DB2
- Developed ETL processes extracted data daily from Mainframe DB2 and ORACLE Databases, and loaded data into a SAS based Decision Support Warehouse
- 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 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 assisting users in creating and modifying worksheets and data visualization dashboards.
- Worked on BI Report Tuning and Report Validation SQL Tuning
- 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 Xcelsius 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: Tableau Desktop 8.0/7.0 , Tableau server / Administrator, tabcmd, SQL developer, SQL 2012,Oracle 10g, DB2, Microsoft Excel 2007, MS Access , Windows 2007 server, Microsoft office 2007.
Confidential
Tableau Developer/Consultant
Responsibilities:
- Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects
- Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
- Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
- Scheduled the published dashboards from Tableau Server on weekly basis.
- Sending the dashboards to users by emails with the help of admin team with subscriptions.
- Performance tuning of Reports by creating Linked Universes, Joins, Contexts, Aliases for resolving loops and checked the integrity of the universes using Business Objects Designer module during development.
- Given training/demos to users on Tableau Desktop for development.
- Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
- Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards.
- Administered user groups and scheduled instances for reports in tableau.
- Administered user, user groups, and scheduled instances for reports in Tableau.
- Built complex formulas in Tableau for various business calculations.
- Resolved various performance issues and analyzed the best process distribution for different projects.
Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, UNIX, SQL Server 2008, Oracle 11g, Toad, DB2, MS Office, Visual Studio 2010, Cognos 8.1,SSIS package, Enterprise Architect tool.
Confidential
Tableau Developer
Responsibilities:
- Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
- Data blending implemented on EMPI databases and generated interactive dashboards.
- Created adhoc reports to users in Tableau by connecting various data sources.
- Handled Tableau admin activities granting access, managing extracts and Installations.
- Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
- Published Workbooks by creating user filters so that only appropriate teams can view it.
- Embedded Tableau views in to SharePoint.
- Analyzed the source data and handled efficiently by modifying the data types.
- Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
- Generated context filters and used performance actions while handling huge volume of data.
- Generated tableau dashboards for sales with forecast and reference lines.
- User Java Script API to customize the views, selects, filters, date and time.
- Generated tableau dashboards with combination charts for clear understanding.
- Prepare daily status reports, Weekly status reports and Task completion report.
Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, UNIX, SQL Server 2008, Oracle 11g, Toad, MS Office, Visual Studio 2010,Informatica 8.6, Quality Center 9.2, SVN, Windows NT/XP, 2000
Confidential
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.
Confidential
Business System Analyst
Responsibilities:
- Interacted with business users for gathering requirements for ITASCA Projects.
- Prepared Use cases and got reviewed with Business users.
- High level and low-level design prepared and got the signoff from SMEs.
- Wrote Project Technical Specifications.
- Coordinated for SIT and UAT testing.
- Interacted with the Business Analysts for gathering the SAMI project requirements.
- Modified the Charge sheet systems for providing the required information for Informatica and SAP Projects.
- Designed Mainframe Migration requirements.
- Prepared the Charge sheet reports for books, magazines. Etc.
- Analyzed data and prepared the reports for different months.
- Migrated Natural programs to COBOL.
- Identified the issues in current system and proposed the required changes.
- Wrote programs in Natural/Adabas, COBOL,CICS, JCL, IMS and DB2
- Wrote Adabas queries to capture the information from ADABAS database.
- Documented Monthly charge sheet flow by analyzing the jobs/programs
Environment: NATURAL, ADBAS, VS COBOL II, IMS DB, MARK IV, DB2, VSAM, JCL, CICS, INTERTEST, Win-XP z/OS, SQL Server 2008 Enterprise Edition, T-SQL, Excel, Erwin, Windows 2008/XP, Visual Studio, Crystal Reports.