We provide IT Staff Augmentation Services!

Tableau Developer/ Sql Server Developer Resume

New York, NY

PROFESSIONAL SUMMARY:

  • 7+ years of experience in Business Analysis, Systems Analysis, Data Analysis, Software design, development, testing and maintenance of BI/Data warehousing environment.
  • Extensive experience with the design and development of Tableau visualization solutions.
  • Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
  • Good understanding of Tableau Desktop architecture for designing and developing dashboards.
  • Worked with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
  • Experience in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau desktop report.
  • Responsible for developing interactive data visualizations.
  • Involved in upgrading Tableau platforms in clustered environment and performing upgrades.
  • Created solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
  • Excellent experience in designing Dashboards, BI Answers, and Analytics using Tableau.
  • Good experience in generating Sub - Reports, Drilldown reports, Drill through reports, and Parameterized reports using Tableau.
  • Expert in converting Functional specs to Technical Specs and implementing OBIEE Best practices.
  • Experienced in working with different database environments like MS Access, Oracle, SQL Server, MySQL.
  • Extensively worked on SQL Server Profiler, Analysis Services and Integration Services.
  • Good understanding and background in financial services, media, and telecom industry.
  • Comfortable working independently or with team with limited supervision and working in tighter schedules, meeting deadlines, and ability to learn on the fly.
  • Good knowledge in Geocoding and Geospatial.
  • Excellent communication skills in both written and oral along with ability to tell a story through data.
  • Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.

BUSINESS SKILLS/TECHNICAL SKILLS:

BI/Visualization Tool: Tableau 6/7/8.1/8.2/8.3 and 9.0,9.2, Qlikview, Cognos

Utilities: MS Office Suite

Front End Tools: MS Project, MS Office Suite, MS Share Point

Databases: Oracle10g/11i, SQL Server, MS Access, MySQL

Platforms: Windows7/8/2003/NT, MS Server 2008 R2, Mac OS, DOS, UNIX

Languages: C,C++,Java, HTML

Data Modeling: Visio

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Tableau Developer/ SQL Server Developer

Responsibilities:

  • Gathered user requirements, analyzed and designed software solution based on the requirements.
  • Extracting data from DW and hosting Dashboards in servers.
  • Selected and implemented agile development practices according to the user requirements for the project.
  • Daily communication with IT and Senior Leadership and Recommending Dashboards per Tableau visualization features.
  • Involved in reviewing business requirements and analyzing data sources, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Created views in Tableau Desktop, in Agile environment, that were published to internal team for review and further data analysis and customization using filters and actions.
  • Created Heat Map showing current distributors by color that were broken into regions allowing business user to understand where we have most profitable vs. least.
  • Blended data from multiple databases into one report by selecting primary keys data validation.
  • Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
  • Knowledge on working thru TabAdmin and Tabcmd commands.
  • Converted charts into Crosstabs for further underlying data analysis in MS Excel.
  • Created Bullet graphs to determine profit generation by using measures and dimensions data from MS SQL Server.
  • Combined views and reports into interactive dashboards in Tableau Desktop, environment, that were presented to Business Users, Program Managers, and End Users.
  • Oversee the Tableau data import/export.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8.1&9.2 desktop/Server.
  • Administrated the Active Directory to manage user authentication for Tableau server access, in corporate the existing SS single-sign on component.
  • Write scripts or set up configuration to automate the data import process into Tableau.
  • Set up default file directory to host the Tableau software and data files appropriately.
  • Daily check-up servers. And deploying servers.
  • Making the end users to use tableau on iPad, creating offline snapshots and deploying dashboards on cloud.
  • Involved in complete Life Cycle including Analysis, Design, Development and Testing.

Environment: Tableau Desktop 8.1 & 9.2,Tableau Server, MS SQL Server 2012, Oracle, MS Office Suite, MS Project, MS Visio, Agile Scrum Environment

Confidential, Kalamazoo, MI

Tableau Developer/Tableau Admin

Responsibilities:

  • Involved in reviewing requirements and data sources form MS Excel and MS Access for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Participated in designing and development of dashboards using agile development practices.
  • Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
  • Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
  • Applied the data blending capabilities of the tableau establishing runtime combinations of data models without needing to predefine data relationships.
  • Enforced backup creations, incremental extract (.TDE) file refresh on weekly basis.
  • Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
  • Review Vendors Status Reports with Project Team and created visualization for budget forecasting.
  • Published views and dashboards in Tableau Server for auditor review.
  • Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
  • Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
  • Reviewed basic BTEQ queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
  • Filled missing values using in the data using mean replacement and mode replacement.

Environment: Tableau Desktop 6.x,7.x, Tableau Server, MS SQL Server, Oracle SQL Server, MS Office Suite, MS Project, MS Visio, UNIX.

Confidential, Fairfield, OH

Tableau Developer/SQL Server Developer

Responsibilities:

  • Gathering requirements, analyzing, designed software solution based on the requirements.
  • Building, publishing customized interactive reports and dashboards.
  • Extensive use of data blending, filters, parameters, sets, groups etc., with best practices
  • Knowledge on installation, configuration, procurement assessment, machine uplifts.
  • Defined best practices for Tableau report development.
  • Administered users, groups, and scheduled instances for reports in Tableau server.
  • Executed and tested required queries and reports before publishing.
  • Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
  • Mentored business power users to create reports/dashboards using tableau desktop.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
  • Worked on submitting various reports from database using Excel pivots and SQL Reporting.
  • Involved in the migration of SQL Server 2000 to SQL Server 2005 environment.
  • Involved in the performance tuning of the queries using execution plan and SQL Profiler.
  • Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
  • Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
  • Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
  • Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
  • Performed the detailed design of Visualization components
  • Scheduled

Environment: Tableau Desktop 7.x, MS SQL Server, MS office Suite, MS Visio, Mac OS, DOS, UNIX.

Confidential, Princeton, NJ

Business Intelligence Consultant

Responsibilities:

  • Evaluated and worked on several Business Intelligence Platforms such as Qlikview in order to compare and contrast specific client’s needs against Tableau.
  • Migrated content from Production, to QA to Development Environment.
  • Used Actions extensively to link and filter sheets for easier navigation in Dashboards.
  • Interacted with business users to gather requirements and provided guidance for the Data Warehouse team in how to structure data for optimal use in Tableau.
  • Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
  • Created extensive joins for data blending from several different data sources.
  • Helped customize Tableau Server with Company Logo and Company Pop-Ups.
  • Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau 7x, Oracle Server, Microsoft SQL Server, Qlikview

Confidential

BI DEVELOPER

Responsibilities:

  • Actively involved in business meetings with the customers for understanding the as-is process flow and new business requirements or enhancement activities.
  • Prepared the technical and functional specification documents for report development, coding and testing.
  • Ensured the development teams are practicing the Agile principles. Completed product demonstrations, retrospectives, and resolve action items. Assisted Product Owner with Backlog maintenance.
  • Developed a Framework Manager model by importing Meta data, preparing business logic, setting up object level security and developing and publishing package.
  • Created standard filters, prompts, calculations and conditions in Catalog.
  • Created various impromptu reports (List, Cross-Tab and Drill through) and power play Reports.
  • Defined join conditions, table aliases and views for the user requirement.
  • Updated impromptu catalog by adding tables and creating new joins.
  • Created various report studio reports using calculations, filters, prompts conditional formatting and drill through.
  • Created IQDs that are used as data sources in PowerPlay transformer to generate transformer models.
  • Converted char fields to varchar fields and date functions.
  • Migrated reports from Cognos EP Series 7.3 to Cognos 8 Environment.
  • Published impromptu reports and Power Play reports to upfront and scheduled reports to run periodically.
  • Validated report results with the source data and authorized the reports to production environment.
  • Granting access to different users for the system.
  • Provided technical assistance, training and mentoring to business users.
  • Involved in Data Auditing process using SQL to validate the masked data.
  • Involved in writing different stored procedures, triggers in PL/SQL as per functionality.
  • Installing applications like Impromptu user 7.3 & Power Play user 7.3.

Environment: Cognos 8.0 BI, Cognos Powerplay7.3, Transformer 7.3, Cognos Report Net 1.1, PowerPlay Enterprise Server 7.3, Upfront 7.3, Impromptu 7.3, Access Manager 7.3

Hire Now