We provide IT Staff Augmentation Services!

Sr. Bi/tableau Report Developer Resume

5.00 Rating

Jersey City, NJ

SUMMARY

  • Over 6+ years of IT experience in 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.
  • 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 Platfora 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 withTeradata 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 noledge on visualization of data and noledge 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 halped business get a good handle on teh 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 dat can be easily accessible through Tableau App in Ipads, 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 teh 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 noledge 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.
  • Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

Programming Languages: T-SQL, XML, Oracle

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/2008 R2/2012, MS Access, Teradata

Operating Systems: XP, Windows NT / 2000. Windows Server 2003/2008/2008 R2, Linux

SDLC tools: Perforce, Team foundation Server (TFS), HP Quality center

PROFESSIONAL EXPERIENCE

Confidential, Jersey city, NJ

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 teh 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, Virginia Beach, VA

Tableau Report Developer

Responsibilities:

  • Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects
  • Analysis teh metric dashboard reports and identified teh formulas and functionality of teh dashboard reports and digitizing teh metric dashboards to Tableau application.
  • Published teh dashboard reports to Tableau Server for navigating teh developed dashboards in web.
  • Scheduled teh published dashboards from Tableau Server on weekly basis.
  • Sending teh dashboards to users by emails with teh halp of admin team with subscriptions.
  • Performance tuning of Reprots by creating Linked Universes, Joins, Contexts, Aliases for resolving loops and checked teh integrity of teh 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 teh business logic by customization.
  • Created Data Connections, published on Tableau Server for usage with Operational/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 teh 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,MS Office, Visual Studio 2010.

Confidential, Plainville, CT

SQL/BI Developer

Responsibilities:

  • Designed, Coded, Tested, Implemented teh Stored Procedures to support teh System.
  • Fixed bugs in teh existing in-house developed Software which is used to upload teh reports for teh end users to view teh reports.
  • Designed, coded and tested several T-SQL Queries to Support teh System.
  • Fixed bugs in teh software dat was used to support teh healthcare system.
  • Designed, Coded, Tested, Implemented Stored Procedures to get data for teh reports.
  • Designed teh reports using Crystal reports And SSRS to create reports for teh end users.
  • Created ad-hoc reports, drill down, and drill through reports using Crystal Reports and SSRS.
  • Scheduled meetings with teh end users and business owners and gathered requirements for teh system.
  • Developed triggers on tables to support teh system.
  • Created and configured SQL mail to send mail as events occur.
  • Used teh SQL profiler to trace teh data and thus troubleshoot TEMPeffectively.
  • Worked on SQLSMS to grant other users teh rights to teh needed stored procedures and table as required.
  • Worked closely with teh business owner to understand teh requirements.

Environment: SQL Server 2008, MS Visio, Erwin Visual studio 2008,NET Framework, PowerBuilder, Crystal reports, SSRS

Confidential, Memphis, TN

SQL Server Developer

Responsibilities:

  • Created SSIS Packages.
  • 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 teh relationships using constraints.
  • Created Data Models using Erwin tool.
  • Created several stored procedures to Archive teh old data in teh database.
  • Wrote custom T-SQL Stored procedures to improve performance, preserve referential integrity, and provide additional application functionality for maintaining hierarchal data.
  • 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 teh database and fail-over methods.
  • Monitored Server Activity and Performance.
  • Developed reports using complex formulas to query teh database to generate different types of ad-hoc reports using Crystal Reports.
  • Experience working with ASP.NET as frontend team.
  • Optimized teh 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.
  • Involved in testing, bug fixing and documentation for teh project
  • 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.

Confidential

MS SQL Server Developer

Responsibilities:

  • Involved in implementation and scheduling of teh backup and maintenance strategy on teh development server.
  • Created Stored Procedures and Database objects.
  • Responsible for backups/restores, designing DTS packages and maintenance.
  • Reviewed and optimized SQL queries, Stored Procedures, Views and Triggers to achieve maximum efficiency and scalability.
  • Daily Database backups and integrity checking.
  • Data Transfer (using DTS) from Development to Testing and to Production Servers.
  • Designed and created Stored Procedures, Tables Views and DTS packages for existing SQL Server Databases.
  • Involved in Data Migration and used DTS to import and export data into tables using SQL Server 2000/2005, creating tables, views and Stored Procedures using SQL Server.
  • Fine-tuned queries for teh performance of reports which were being deployed in Crystal Reports.
  • Wrote Stored Procedures for Reporting purposes and developed various reports using SQL Server Reporting Services.
  • Used T-SQL to create various queries.

Environment: SQL Server 2000/2005, Windows NT/2000 server, Crystal Reports.

We'd love your feedback!