SUMMARY:

• Having experience in Software Design, Database Design, Development, Integration Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Highly motivated, analytical and process - oriented Tableau developer with 3+ years of in-depth experience as a Tableau report developer which involves designing, configuring and administering Tableau Server and reports. Furnishes insights, analytics and business intelligence used to advance opportunity identification, best practices, process reengineering.
• Experience in all facets of software development lifecycles viz. Requirement analysis, design, development, testing, System performance analysis and Documentation.
• Expert in Publishing and Sharing Workbooks, Data Sources with User Filter to Tableau Server, Setting Schedules for the extracted reports, Authorization and Permissions, incremental refresh extracts and updating server data that are using extracts.
• Experienced on using MySQL for tableau and in writing parametrized queries for generating tabular reports, formatting report layout and expressions. Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters etc.,
• Good knowledge in using context filters, cascading filters, data source filters, quick filters, to filter the data and implemented forecasting.
• Experience in all facets of software development lifecycles viz. Requirement analysis, design, development, testing, System performance analysis and Documentation.
• Highly self-motivated. Skilled at problem solving and can provide effective solutions to issues.
• Having experience in SCM and Build/Release Engineer.
• Good understanding of Agile software development lifecycle (iterative and incremental).
• Capable of working efficiently under stress and tight deadlines.
• Having experience in Retail and Banking Domain
• Excellent communication and writing skills.

TECHNICAL SKILLS:

Databases: MS SQL SERVER 2000/2005/2008 R2/ 2014/2016, MYSQL 5.0, Teradata V2R6, DB2, SAS

Operating Systems: Windows 2007/XP/Vista/2003

BI Tools: Tableau Desktop (2019.1.x/2018.1.x/10.x/9.x), Tableau server (10.x/9.x/8.x), Reader, Online, Crystal reports, MS Excel, SSRS

ETL Tools: SQL Server Integration Services (SSIS).

SQL Server Tools: SQL server management Studio, BIDS, SQL server profiler, FTP, TOAD.

Programming Languages: C, C++, Visual Basic, SQL, QA, Oracle PL/SQL, Linux, UNIX shell scripting, Java, JSP, HTML, JavaScript, JIRA

Software Methodologies: Software Development Life Cycle, Agile, Waterfall, Data Modeling Logical/ Physical/ Dimensional, Snowflake Schema, ETL

PROFESSIONAL EXPERIENCE:

Confidential, Bridgewater, NJ

Tableau Developer

Responsibilities:

• Responsible for gathering/refining requirements from the customer for developing reports in Tableau .
• Collaborate with business leadership to identify potential areas of analysis.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Created Web reports using custom SQL queries and converted them to tableau dashboards for advanced visualizations.
• Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. in a single dashboard by using parameters.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Displayed multiple measures like Individual Axes, Blended Axes, and Dual Axes.Effectively used data blending feature in Tableau to combine the data from different sources like Adobmarketing cloud into a single report.
• Worked closely with end users in identifying and implementing the right set of business criteria to convert raw data into meaningful information.
• Defined best practices for Tableau report development.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Worked on understanding of relational database structures, theories, principles and practices. Found efficient ways to make tables and graphs that were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Used SQL queries at the custom SQL level to pull the data in Tableau desktop and validated the result in Tableau by running SQL queries in Teradata SQL

  Assistant.

• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created Tableau functional design document.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop. Participated in the retrospective meetings and next sprint planning meetings.
• Environment: Tableau (Desktop/Server), MS SQL Server 2008, UNIX, Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential

Tableau Developer

• Interacted with business stakeholders, gathered requirements and managing the delivery, covering the entire Tableau development lifecycle. Testing the each report based on the requirements before and after migration, performance monitoring of each object before and after migration.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Developed Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• Created histograms, pie charts, box plots, scatter plots for inventory management and background maps illustrating the potential revenue change.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Involved in Sprint planning, review meetings and various business meetings for requirement gathering.
• Extensively work on various production migrations, interacting with the business and handle UAT process successfully.
• Scheduling the reports for daily run against the Hadoop environment, monitoring the performance daily.
• Work closely with the Data Architects in making necessary design changes and reviewed the data model.
• Coordinated with various teams in Enterprise Data warehouse and other IT teams and responsible for the whole life cycle of multiple BI migration projects. Environment: Tableau9.x (desktop, server, reader, online), My SQL Server 2008, DB2.

Confidential - Newtown Square, PA

Tableau Developer

Responsibilities:

• Work closely with Project Manager to develop and update the task plan for ETL work and to keep the manager aware of any critical task issues and dependencies • Ensure the ETL code delivered is running, conforms to specifications and design guidelines and analyze the data in the source to look for data quality problems and write code to fix data quality issues • Unit testing the ETL code to ensure it can be delivered and run in a system testing environment
• Monitor Scheduled ETL Jobs & reports and resolve issues if any • Build a reporting views on the top of Data Model as per the report requirement • Assist with the interpretation of user requirements into feasible options and communicating this back to the business stakeholders. Manage and track the status of requirements throughout the project lifecycle; enforce and redefine necessary.
• Develop and conduct peer reviews of the business requirements to ensure that requirement specifications are correctly interpreted.
• Performed all development activities required for delivery of BI solutions including ETL, data modeling, cube development, solution deployment and maintenance.
• Supported in consolidation of Risk and P&L Microsoft cube for all products traded in Structured Credit products.
• Collaborate within global development teams across Mississauga (Canada), and Asia to delivery cube for both Structured Credit Business and Counterparty Desk.
• Created web-based mock-up of the file cleanup/reformatting windows application in Visual Studio 2008 utilizing HTML5, CSS, Bootstrap, and ASP.Net.
• Supported Ops Capital System including: MDX calculations, Cube changes, ETL changes and more.

Confidential

QlikView/Qlik Sense Developer

Roles and responsibilities:

• Experience in Building customized Interactive Reports, Views and Dashboards as per end user requirement.
• Expertise in creative custom fields using Table Calculations and LOD's (Level of Details).
• Hands on experience in creating Joins and Blending data from heterogeneous sources.
• Proficient in design and development of various dashboards, reports using Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts etc.
• Implemented Quick Filters, Cascading Filters, Context Filters and Data Source Filters while handling huge volume of data.
• Having experience in identifying, analyzing and interpreting trends and patterns in complex data sets.
• Proficient in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Mastered the ability to design and deploy rich graphic visualizations with Drill Dow, Drop-Down menu option and parameters using Tableau Desktop.
• Created solution driven dashboards by developing different types of charts including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs and Histograms in Tableau Desktop.
• Involved in creating dashboards by using Level of Detail concept (LOD's).
• Worked on creating visualizations using custom hierarchies, groups and merged data from multiple sources using the data blending technique within the tableau workbook.
• Knowledge in Data warehousing concepts such as Star Schema & Snowflake schema etc.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community. Created conditional filters and Action links to filter the data on dashboard.
• Used various types of aggregations like sum, average, count, count (distinct), median, minimum, maximum, percentile and std. deviation, etc. to build strong informative dashboards.
• Developed Tableau workbooks to perform year over year, YTD, QTD and MTD type of analysis.
• Hands-on development in assisting users by creating and modifying worksheets to get best data visualizations.
• Written complex SQL queries using Joins, nested sub queries, Set Operations, aggregation and Advanced OLAP Functions.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the charged data accurately environment Tableau Desktop 10.x, Tableau Server SQL server